DBA Data[Home] [Help]

APPS.IEM_TAG_KEY_PVT dependencies on STANDARD

Line 44: --Standard Savepoint

40:
41: IEM_TAG_NOT_DELETED EXCEPTION;
42: BEGIN
43:
44: --Standard Savepoint
45: SAVEPOINT delete_item_batch;
46:
47: -- Standard call to check for call compatibility.
48: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

43:
44: --Standard Savepoint
45: SAVEPOINT delete_item_batch;
46:
47: -- Standard call to check for call compatibility.
48: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
49: p_api_version_number,
50: l_api_name,
51: G_PKG_NAME)

Line 130: --Standard check of p_commit

126: );
127: */
128: end if;
129:
130: --Standard check of p_commit
131: IF FND_API.to_Boolean(p_commit) THEN
132: COMMIT WORK;
133: END IF;
134: FND_MSG_PUB.Count_And_Get

Line 192: --Standard Savepoint

188:
189: IEM_TAG_NOT_DELETED EXCEPTION;
190: BEGIN
191:
192: --Standard Savepoint
193: SAVEPOINT delete_association_on_acct_ID;
194:
195: -- Standard call to check for call compatibility.
196: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

191:
192: --Standard Savepoint
193: SAVEPOINT delete_association_on_acct_ID;
194:
195: -- Standard call to check for call compatibility.
196: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
197: p_api_version_number,
198: l_api_name,
199: G_PKG_NAME)

Line 218: --Standard check of p_commit

214: --Actual API starts here
215: l_acct_id := LTRIM(RTRIM(p_email_acct_id));
216: delete from iem_account_tag_keys where email_account_id = l_acct_id;
217:
218: --Standard check of p_commit
219: IF FND_API.to_Boolean(p_commit) THEN
220: COMMIT WORK;
221: END IF;
222:

Line 289: -- Standard Start of API savepoint

285: IEM_ADM_G_MISS_FOR_NOTNULL EXCEPTION;
286: IEM_TAG_NAME_VALUE_KEY_NULL EXCEPTION;
287:
288: BEGIN
289: -- Standard Start of API savepoint
290: SAVEPOINT create_item_tag_PVT;
291:
292: -- Standard call to check for call compatibility.
293:

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

288: BEGIN
289: -- Standard Start of API savepoint
290: SAVEPOINT create_item_tag_PVT;
291:
292: -- Standard call to check for call compatibility.
293:
294: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
295: p_api_version_number,
296: l_api_name,

Line 458: -- Standard Check Of p_commit.

454: sysdate,
455: decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
456: );
457:
458: -- Standard Check Of p_commit.
459: IF FND_API.To_Boolean(p_commit) THEN
460: COMMIT WORK;
461: END IF;
462:

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

459: IF FND_API.To_Boolean(p_commit) THEN
460: COMMIT WORK;
461: END IF;
462:
463: -- Standard callto get message count and if count is 1, get message info.
464: FND_MSG_PUB.Count_And_Get
465: ( p_count => x_msg_count,
466: p_data => x_msg_data
467: );

Line 596: -- Standard Start of API savepoint

592: IEM_TAG_ACCT_ID_NOT_EXIST EXCEPTION;
593:
594: BEGIN
595:
596: -- Standard Start of API savepoint
597: SAVEPOINT create_item_account_tags_PVT;
598:
599: -- Standard call to check for call compatibility.
600: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

595:
596: -- Standard Start of API savepoint
597: SAVEPOINT create_item_account_tags_PVT;
598:
599: -- Standard call to check for call compatibility.
600: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
601: p_api_version_number,
602: l_api_name,
603: G_PKG_NAME)

Line 688: -- Standard Check Of p_commit

684: sysdate,
685: decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
686: );
687:
688: -- Standard Check Of p_commit
689: IF FND_API.To_Boolean(p_commit) THEN
690: COMMIT WORK;
691: END IF;
692:

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

689: IF FND_API.To_Boolean(p_commit) THEN
690: COMMIT WORK;
691: END IF;
692:
693: -- Standard callto get message count and if count is 1, get message info.
694: FND_MSG_PUB.Count_And_Get
695: ( p_count => x_msg_count,
696: p_data => x_msg_data
697: );

Line 776: -- Standard Start of API savepoint

772: l_tag_key_id iem_tag_keys.tag_key_id%type :=0;
773:
774: l_temp varchar2(256);
775: BEGIN
776: -- Standard Start of API savepoint
777: SAVEPOINT update_acct_tag_wrap;
778:
779: -- Standard call to check for call compatibility.
780: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

775: BEGIN
776: -- Standard Start of API savepoint
777: SAVEPOINT update_acct_tag_wrap;
778:
779: -- Standard call to check for call compatibility.
780: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
781: p_api_version_number,
782: l_api_name,
783: G_PKG_NAME)

Line 834: -- Standard Check Of p_commit.

830: end if;
831:
832: end loop;
833:
834: -- Standard Check Of p_commit.
835: IF FND_API.To_Boolean(p_commit) THEN
836: COMMIT WORK;
837: END IF;
838:

Line 911: -- Standard Start of API savepoint

907: l_IEM_INVALID_PROCEDURE EXCEPTION;
908: IEM_ADM_G_MISS_FOR_NOTNULL EXCEPTION;
909: BEGIN
910:
911: -- Standard Start of API savepoint
912: SAVEPOINT update_item_tag_key;
913:
914: -- Standard call to check for call compatibility.
915: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

910:
911: -- Standard Start of API savepoint
912: SAVEPOINT update_item_tag_key;
913:
914: -- Standard call to check for call compatibility.
915: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
916: p_api_version_number,
917: l_api_name,
918: G_PKG_NAME)

Line 999: -- Standard Check Of p_commit.

995: LAST_UPDATE_DATE = sysdate,
996: LAST_UPDATE_LOGIN = decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
997: where tag_key_id=p_tag_key_id;
998:
999: -- Standard Check Of p_commit.
1000: IF FND_API.To_Boolean(p_commit) THEN
1001: COMMIT WORK;
1002: END IF;
1003:

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

1000: IF FND_API.To_Boolean(p_commit) THEN
1001: COMMIT WORK;
1002: END IF;
1003:
1004: -- Standard callto get message count and if count is 1, get message info.
1005: FND_MSG_PUB.Count_And_Get
1006: ( p_count => x_msg_count,
1007: p_data => x_msg_data
1008: );