DBA Data[Home] [Help]

APPS.IEM_CLASSIFICATIONS_PVT dependencies on STANDARD

Line 80: -- Standard Start of API savepoint

76:
77:
78: BEGIN
79:
80: -- Standard Start of API savepoint
81: SAVEPOINT create_item_PVT;
82:
83: -- Standard call to check for call compatibility.
84: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 83: -- Standard call to check for call compatibility.

79:
80: -- Standard Start of API savepoint
81: SAVEPOINT create_item_PVT;
82:
83: -- Standard call to check for call compatibility.
84: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
85: p_api_version_number,
86: l_api_name,
87: G_PKG_NAME)

Line 161: -- Standard Check Of p_commit.

157: ELSE
158: x_return_status := FND_API.G_RET_STS_SUCCESS;
159: END IF;
160:
161: -- Standard Check Of p_commit.
162: IF FND_API.To_Boolean(p_commit) THEN
163: COMMIT WORK;
164: END IF;
165: -- Standard callto get message count and if count is 1, get message info.

Line 165: -- Standard callto get message count and if count is 1, get message info.

161: -- Standard Check Of p_commit.
162: IF FND_API.To_Boolean(p_commit) THEN
163: COMMIT WORK;
164: END IF;
165: -- Standard callto get message count and if count is 1, get message info.
166: FND_MSG_PUB.Count_And_Get
167: ( p_count => x_msg_count,
168: p_data => x_msg_data
169: );

Line 242: -- Standard Start of API savepoint

238: l_api_name VARCHAR2(255):='delete_item';
239: l_api_version_number NUMBER:=1.0;
240:
241: BEGIN
242: -- Standard Start of API savepoint
243: SAVEPOINT delete_item_PVT;
244: -- Standard call to check for call compatibility.
245: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
246: p_api_version_number,

Line 244: -- Standard call to check for call compatibility.

240:
241: BEGIN
242: -- Standard Start of API savepoint
243: SAVEPOINT delete_item_PVT;
244: -- Standard call to check for call compatibility.
245: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
246: p_api_version_number,
247: l_api_name,
248: G_PKG_NAME)

Line 270: -- Standard Check Of p_commit.

266: WHERE EMAIL_ACCOUNT_ID=P_EMAIL_ACCOUNT_ID
267: AND CLASSIFICATION=P_CLASSIFICATION;
268: END IF;
269:
270: -- Standard Check Of p_commit.
271: IF FND_API.To_Boolean(p_commit) THEN
272: COMMIT WORK;
273: END IF;
274: -- Standard callto get message count and if count is 1, get message info.

Line 274: -- Standard callto get message count and if count is 1, get message info.

270: -- Standard Check Of p_commit.
271: IF FND_API.To_Boolean(p_commit) THEN
272: COMMIT WORK;
273: END IF;
274: -- Standard callto get message count and if count is 1, get message info.
275: FND_MSG_PUB.Count_And_Get
276: ( p_count => x_msg_count,
277: p_data => x_msg_data
278: );

Line 374: -- Standard Start of API savepoint

370: IEM_DUPLICATE_CLASS EXCEPTION;
371: PRAGMA EXCEPTION_INIT(IEM_DUPLICATE_CLASS, -00001);
372:
373: BEGIN
374: -- Standard Start of API savepoint
375: SAVEPOINT update_item_PVT;
376:
377: -- Standard call to check for call compatibility.
378: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 377: -- Standard call to check for call compatibility.

373: BEGIN
374: -- Standard Start of API savepoint
375: SAVEPOINT update_item_PVT;
376:
377: -- Standard call to check for call compatibility.
378: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
379: p_api_version_number,
380: l_api_name,
381: G_PKG_NAME)

Line 415: -- Standard Check Of p_commit.

411: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
412: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
413: WHERE CLASSIFICATION_ID=p_classification_id;
414:
415: -- Standard Check Of p_commit.
416: IF FND_API.To_Boolean(p_commit) THEN
417: COMMIT WORK;
418: END IF;
419: -- Standard callto get message count and if count is 1, get message info.

Line 419: -- Standard callto get message count and if count is 1, get message info.

415: -- Standard Check Of p_commit.
416: IF FND_API.To_Boolean(p_commit) THEN
417: COMMIT WORK;
418: END IF;
419: -- Standard callto get message count and if count is 1, get message info.
420: FND_MSG_PUB.Count_And_Get
421: ( p_count => x_msg_count,
422: p_data => x_msg_data
423: );

Line 758: --Standard Savepoint

754: l_api_name varchar2(30):='delete_item_batch';
755: l_api_version_number number:=1.0;
756: BEGIN
757:
758: --Standard Savepoint
759: SAVEPOINT delete_item_wrap;
760: -- Standard call to check for call compatibility.
761: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
762: p_api_version_number,

Line 760: -- Standard call to check for call compatibility.

756: BEGIN
757:
758: --Standard Savepoint
759: SAVEPOINT delete_item_wrap;
760: -- Standard call to check for call compatibility.
761: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
762: p_api_version_number,
763: l_api_name,
764: G_PKG_NAME)

Line 794: --Standard check of p_commit

790: FND_MSG_PUB.ADD;
791: RAISE FND_API.G_EXC_ERROR;
792: END IF;
793:
794: --Standard check of p_commit
795: IF FND_API.to_Boolean(p_commit) THEN
796: COMMIT WORK;
797: END IF;
798:

Line 799: -- Standard callto get message count and if count is 1, get message info.

795: IF FND_API.to_Boolean(p_commit) THEN
796: COMMIT WORK;
797: END IF;
798:
799: -- Standard callto get message count and if count is 1, get message info.
800: FND_MSG_PUB.Count_And_Get
801: ( p_count => x_msg_count,
802: p_data => x_msg_data
803: );

Line 834: --Standard call to get message count and message info

830: FND_MSG_PUB.Count_And_Get
831: ( p_count => x_msg_count ,
832: p_data => x_msg_data
833: );
834: --Standard call to get message count and message info
835: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
836: p_data => x_msg_data);
837: END delete_item_wrap;
838: PROCEDURE delete_item_wrap_sss

Line 855: --Standard Savepoint

851: l_class_id number;
852: l_email_account_id number;
853: BEGIN
854:
855: --Standard Savepoint
856: SAVEPOINT delete_item_wrap;
857: -- Standard call to check for call compatibility.
858: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
859: p_api_version_number,

Line 857: -- Standard call to check for call compatibility.

853: BEGIN
854:
855: --Standard Savepoint
856: SAVEPOINT delete_item_wrap;
857: -- Standard call to check for call compatibility.
858: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
859: p_api_version_number,
860: l_api_name,
861: G_PKG_NAME)

Line 904: --Standard check of p_commit

900: iem_themes_pvt.calculate_weight (l_email_account_id,
901: 'R' ,
902: l_status );
903:
904: --Standard check of p_commit
905: IF FND_API.to_Boolean(p_commit) THEN
906: COMMIT WORK;
907: END IF;
908:

Line 909: -- Standard callto get message count and if count is 1, get message info.

905: IF FND_API.to_Boolean(p_commit) THEN
906: COMMIT WORK;
907: END IF;
908:
909: -- Standard callto get message count and if count is 1, get message info.
910: FND_MSG_PUB.Count_And_Get
911: ( p_count => x_msg_count,
912: p_data => x_msg_data
913: );

Line 944: --Standard call to get message count and message info

940: FND_MSG_PUB.Count_And_Get
941: ( p_count => x_msg_count ,
942: p_data => x_msg_data
943: );
944: --Standard call to get message count and message info
945: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
946: p_data => x_msg_data);
947: END delete_item_wrap_sss;
948:

Line 971: -- Standard Start of API savepoint

967: l_classification2 VARCHAR2(100);
968: l_cnt NUMBER := 0;
969:
970: BEGIN
971: -- Standard Start of API savepoint
972: SAVEPOINT update_item_PVT;
973: -- Standard call to check for call compatibility.
974: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
975: p_api_version_number,

Line 973: -- Standard call to check for call compatibility.

969:
970: BEGIN
971: -- Standard Start of API savepoint
972: SAVEPOINT update_item_PVT;
973: -- Standard call to check for call compatibility.
974: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
975: p_api_version_number,
976: l_api_name,
977: G_PKG_NAME)

Line 1031: -- Standard Check Of p_commit.

1027: x_msg_count => x_msg_count,
1028: x_msg_data => x_msg_data);
1029:
1030:
1031: -- Standard Check Of p_commit.
1032: IF FND_API.To_Boolean(p_commit) THEN
1033: COMMIT WORK;
1034: END IF;
1035: -- Standard callto get message count and if count is 1, get message info.

Line 1035: -- Standard callto get message count and if count is 1, get message info.

1031: -- Standard Check Of p_commit.
1032: IF FND_API.To_Boolean(p_commit) THEN
1033: COMMIT WORK;
1034: END IF;
1035: -- Standard callto get message count and if count is 1, get message info.
1036: FND_MSG_PUB.Count_And_Get
1037: ( p_count => x_msg_count,
1038: p_data => x_msg_data
1039: );

Line 1098: -- Standard Start of API savepoint

1094: l_classification_id number;
1095: DUPLICATE_INTENT EXCEPTION;
1096:
1097: BEGIN
1098: -- Standard Start of API savepoint
1099: SAVEPOINT update_item_PVT;
1100: -- Standard call to check for call compatibility.
1101: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1102: p_api_version_number,

Line 1100: -- Standard call to check for call compatibility.

1096:
1097: BEGIN
1098: -- Standard Start of API savepoint
1099: SAVEPOINT update_item_PVT;
1100: -- Standard call to check for call compatibility.
1101: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1102: p_api_version_number,
1103: l_api_name,
1104: G_PKG_NAME)

Line 1180: -- Standard Check Of p_commit.

1176: 'R',
1177: l_status );
1178: END IF;
1179:
1180: -- Standard Check Of p_commit.
1181: IF FND_API.To_Boolean(p_commit) THEN
1182: COMMIT WORK;
1183: END IF;
1184: -- Standard callto get message count and if count is 1, get message info.

Line 1184: -- Standard callto get message count and if count is 1, get message info.

1180: -- Standard Check Of p_commit.
1181: IF FND_API.To_Boolean(p_commit) THEN
1182: COMMIT WORK;
1183: END IF;
1184: -- Standard callto get message count and if count is 1, get message info.
1185: FND_MSG_PUB.Count_And_Get
1186: ( p_count => x_msg_count,
1187: p_data => x_msg_data
1188: );