DBA Data[Home] [Help]

APPS.CCT_AQ_PUB dependencies on STANDARD

Line 62: -- Standard Start of API savepoint

58: xml_data1_null EXCEPTION;
59: p_server_group_id NUMBER;
60:
61: BEGIN
62: -- Standard Start of API savepoint
63: SAVEPOINT ENQUEUE_ITEM_PUB;
64: -- Standard call to check for call compatibility.
65: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
66: p_api_version ,

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

60:
61: BEGIN
62: -- Standard Start of API savepoint
63: SAVEPOINT ENQUEUE_ITEM_PUB;
64: -- Standard call to check for call compatibility.
65: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
66: p_api_version ,
67: l_api_name ,
68: G_PKG_NAME )

Line 125: -- Standard check of p_commit.

121:
122: --dbms_output.put_line ('ENQUEUE_ITEM: Enqueue done');
123:
124: -- End of API body.
125: -- Standard check of p_commit.
126: IF FND_API.To_Boolean( p_commit ) THEN
127: COMMIT WORK;
128: END IF;
129:

Line 270: -- Standard Start of API savepoint

266: no_messages exception;
267: pragma exception_init (no_messages, -25228);
268:
269: BEGIN
270: -- Standard Start of API savepoint
271: SAVEPOINT DEQUEUE_ITEM_PUB;
272: -- Standard call to check for call compatibility.
273: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
274: p_api_version ,

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

268:
269: BEGIN
270: -- Standard Start of API savepoint
271: SAVEPOINT DEQUEUE_ITEM_PUB;
272: -- Standard call to check for call compatibility.
273: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
274: p_api_version ,
275: l_api_name ,
276: G_PKG_NAME )

Line 312: -- Standard check of p_commit.

308: server_group_id = message.server_group_id;
309: --dbms_output.put_line('DEQUEUE_ITEM: Select done');
310:
311: -- End of API body.
312: -- Standard check of p_commit.
313: IF FND_API.To_Boolean( p_commit ) THEN
314: COMMIT WORK;
315: END IF;
316:

Line 413: -- Standard Start of API savepoint

409: server_down EXCEPTION;
410:
411:
412: BEGIN
413: -- Standard Start of API savepoint
414: SAVEPOINT ENQUEUE_WEB_CALLBACK_ITEM_PUB;
415: -- Standard call to check for call compatibility.
416: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
417: p_api_version ,

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

411:
412: BEGIN
413: -- Standard Start of API savepoint
414: SAVEPOINT ENQUEUE_WEB_CALLBACK_ITEM_PUB;
415: -- Standard call to check for call compatibility.
416: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
417: p_api_version ,
418: l_api_name ,
419: G_PKG_NAME )

Line 576: -- Standard check of p_commit.

572: --dbms_output.put_line('ENQUEUE_WEB_CALLBACK_ITEM: ' || x_return_status);
573: --dbms_output.put_line('ENQUEUE_WEB_CALLBACK_ITEM: ' || l_msg_count);
574: --dbms_output.put_line('ENQUEUE_WEB_CALLBACK_ITEM: ' || l_msg_data);
575: -- End of API body.
576: -- Standard check of p_commit.
577:
578: -- web callback is true, now check if server is up do this at the end, otherwise ,
579: -- values of x_msg_data will get over-written by the enqueue call.
580: if (is_server_up(l_iqdServerId) <> 0) then

Line 749: -- Standard Start of API savepoint

745: ih_media_item_id_null EXCEPTION;
746: phone_number_null EXCEPTION;
747:
748: BEGIN
749: -- Standard Start of API savepoint
750: SAVEPOINT ENQUEUE_WEB_COLLAB_ITEM_PUB;
751: -- Standard call to check for call compatibility.
752: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
753: p_api_version ,

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

747:
748: BEGIN
749: -- Standard Start of API savepoint
750: SAVEPOINT ENQUEUE_WEB_COLLAB_ITEM_PUB;
751: -- Standard call to check for call compatibility.
752: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
753: p_api_version ,
754: l_api_name ,
755: G_PKG_NAME )

Line 889: --Standard check of p_commit.

885:
886:
887: --dbms_output.put_line('ENQUEUE_WEB_COLLAB_ITEM: Enqueue done!');
888: --End of API body.
889: --Standard check of p_commit.
890: IF FND_API.To_Boolean( p_commit ) THEN
891: COMMIT WORK;
892: END IF;
893:

Line 963: -- Standard Start of API savepoint

959: l_root_server_group_name VARCHAR2(256);
960:
961: server_group_name_null EXCEPTION;
962: BEGIN
963: -- Standard Start of API savepoint
964: SAVEPOINT ABANDON_MEDIA_PUB;
965: -- Standard call to check for call compatibility.
966: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
967: p_api_version ,

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

961: server_group_name_null EXCEPTION;
962: BEGIN
963: -- Standard Start of API savepoint
964: SAVEPOINT ABANDON_MEDIA_PUB;
965: -- Standard call to check for call compatibility.
966: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
967: p_api_version ,
968: l_api_name ,
969: G_PKG_NAME )

Line 1020: --Standard check of p_commit.

1016:
1017:
1018: --dbms_output.put_line('ABANDON_MEDIA: Enqueue done!');
1019: --End of API body.
1020: --Standard check of p_commit.
1021: IF FND_API.To_Boolean( p_commit ) THEN
1022: COMMIT WORK;
1023: END IF;
1024: