DBA Data[Home] [Help]

APPS.IEM_DP_MONITORING_PVT dependencies on STANDARD

Line 51: -- Standard Start of API savepoint

47: logMessage varchar2(2000);
48:
49:
50: BEGIN
51: -- Standard Start of API savepoint
52: SAVEPOINT create_item_PVT;
53:
54: -- Standard call to check for call compatibility.
55:

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

50: BEGIN
51: -- Standard Start of API savepoint
52: SAVEPOINT create_item_PVT;
53:
54: -- Standard call to check for call compatibility.
55:
56: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
57: p_api_version_number,
58: l_api_name,

Line 107: -- Standard Check Of p_commit.

103: decode(G_created_updated_by,null,-1,G_created_updated_by),
104: sysdate,
105: decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
106: );
107: -- Standard Check Of p_commit.
108: IF FND_API.To_Boolean(p_commit) THEN
109: COMMIT WORK;
110: END IF;
111:

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

108: IF FND_API.To_Boolean(p_commit) THEN
109: COMMIT WORK;
110: END IF;
111:
112: -- Standard callto get message count and if count is 1, get message info.
113: FND_MSG_PUB.Count_And_Get
114: ( p_count => x_msg_count,
115: p_data => x_msg_data
116: );

Line 179: -- Standard Start of API savepoint

175: l_msg_count NUMBER := 0;
176: l_msg_data VARCHAR2(2000);
177:
178: BEGIN
179: -- Standard Start of API savepoint
180: SAVEPOINT create_item_PVT;
181:
182: -- Standard call to check for call compatibility.
183:

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

178: BEGIN
179: -- Standard Start of API savepoint
180: SAVEPOINT create_item_PVT;
181:
182: -- Standard call to check for call compatibility.
183:
184: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
185: p_api_version_number,
186: l_api_name,

Line 247: -- Standard Check Of p_commit.

243: end if;
244:
245: end if;
246:
247: -- Standard Check Of p_commit.
248: IF FND_API.To_Boolean(p_commit) THEN
249: COMMIT WORK;
250: END IF;
251:

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

248: IF FND_API.To_Boolean(p_commit) THEN
249: COMMIT WORK;
250: END IF;
251:
252: -- Standard callto get message count and if count is 1, get message info.
253: FND_MSG_PUB.Count_And_Get
254: ( p_count => x_msg_count,
255: p_data => x_msg_data
256: );

Line 312: -- Standard Start of API savepoint

308: l_api_name VARCHAR2(255):='UPDATE_DP_ACCT_STATUS';
309: l_api_version_number NUMBER:=1.0;
310:
311: BEGIN
312: -- Standard Start of API savepoint
313: SAVEPOINT create_item_PVT;
314:
315: -- Standard call to check for call compatibility.
316:

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

311: BEGIN
312: -- Standard Start of API savepoint
313: SAVEPOINT create_item_PVT;
314:
315: -- Standard call to check for call compatibility.
316:
317: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
318: p_api_version_number,
319: l_api_name,

Line 348: -- Standard Check Of p_commit.

344: LAST_UPDATE_LOGIN = decode(G_created_updated_by,null,-1,G_created_updated_by)
345: where
346: EMAIL_ACCOUNT_ID = p_acct_id;
347:
348: -- Standard Check Of p_commit.
349: IF FND_API.To_Boolean(p_commit) THEN
350: COMMIT WORK;
351: END IF;
352:

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

349: IF FND_API.To_Boolean(p_commit) THEN
350: COMMIT WORK;
351: END IF;
352:
353: -- Standard callto get message count and if count is 1, get message info.
354: FND_MSG_PUB.Count_And_Get
355: ( p_count => x_msg_count,
356: p_data => x_msg_data
357: );

Line 415: -- Standard Start of API savepoint

411:
412: l_seq_id NUMBER := 10000;
413:
414: BEGIN
415: -- Standard Start of API savepoint
416: SAVEPOINT create_item_PVT;
417:
418: -- Standard call to check for call compatibility.
419:

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

414: BEGIN
415: -- Standard Start of API savepoint
416: SAVEPOINT create_item_PVT;
417:
418: -- Standard call to check for call compatibility.
419:
420: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
421: p_api_version_number,
422: l_api_name,

Line 473: -- Standard Check Of p_commit.

469: );
470:
471: x_status_id := l_seq_id;
472:
473: -- Standard Check Of p_commit.
474: IF FND_API.To_Boolean(p_commit) THEN
475: COMMIT WORK;
476: END IF;
477:

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

474: IF FND_API.To_Boolean(p_commit) THEN
475: COMMIT WORK;
476: END IF;
477:
478: -- Standard callto get message count and if count is 1, get message info.
479: FND_MSG_PUB.Count_And_Get
480: ( p_count => x_msg_count,
481: p_data => x_msg_data
482: );

Line 544: --Standard Savepoint

540:
541: IEM_ERR_QUE_RESET EXCEPTION;
542: BEGIN
543:
544: --Standard Savepoint
545: SAVEPOINT cleanup_monitoring_data_PVT;
546:
547: -- Standard call to check for call compatibility.
548: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

543:
544: --Standard Savepoint
545: SAVEPOINT cleanup_monitoring_data_PVT;
546:
547: -- Standard call to check for call compatibility.
548: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
549: p_api_version_number,
550: l_api_name,
551: G_PKG_NAME)

Line 618: --Standard check of p_commit

614: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
615: raise IEM_ERR_QUE_RESET;
616: end if;
617:
618: --Standard check of p_commit
619: IF FND_API.to_Boolean(p_commit) THEN
620: COMMIT WORK;
621: END IF;
622:

Line 670: -- Standard Start of API savepoint

666: l_count number;
667: l_instance FND_CONCURRENT.Service_Instance_Tab_Type;
668:
669: BEGIN
670: -- Standard Start of API savepoint
671: SAVEPOINT GET_DP_RUNNING_STATUS;
672:
673: -- Standard call to check for call compatibility.
674: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

669: BEGIN
670: -- Standard Start of API savepoint
671: SAVEPOINT GET_DP_RUNNING_STATUS;
672:
673: -- Standard call to check for call compatibility.
674: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
675: p_api_version_number,
676: l_api_name,
677: G_PKG_NAME)

Line 730: -- Standard Check Of p_commit.

726: y := Y+1;
727: end loop;
728: end if;
729:
730: -- Standard Check Of p_commit.
731: IF FND_API.To_Boolean(p_commit) THEN
732: COMMIT WORK;
733: END IF;
734:

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

731: IF FND_API.To_Boolean(p_commit) THEN
732: COMMIT WORK;
733: END IF;
734:
735: -- Standard callto get message count and if count is 1, get message info.
736: FND_MSG_PUB.Count_And_Get
737: ( p_count => x_msg_count,
738: p_data => x_msg_data
739: );

Line 847: -- Standard Start of API savepoint

843: order by a.email_address desc;
844:
845: IEM_ERROR_GET_DP_STATUS EXCEPTION;
846: BEGIN
847: -- Standard Start of API savepoint
848: SAVEPOINT GET_ACCOUNT_DP_STATUS;
849:
850: -- Standard call to check for call compatibility.
851: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

846: BEGIN
847: -- Standard Start of API savepoint
848: SAVEPOINT GET_ACCOUNT_DP_STATUS;
849:
850: -- Standard call to check for call compatibility.
851: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
852: p_api_version_number,
853: l_api_name,
854: G_PKG_NAME)

Line 1021: -- Standard Check Of p_commit.

1017: x_process_msg_count:= l_process_msg_count;
1018: x_retry_msg_count := l_retry_msg_count;
1019: x_log := l_log;
1020:
1021: -- Standard Check Of p_commit.
1022: IF FND_API.To_Boolean(p_commit) THEN
1023: COMMIT WORK;
1024: END IF;
1025:

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

1022: IF FND_API.To_Boolean(p_commit) THEN
1023: COMMIT WORK;
1024: END IF;
1025:
1026: -- Standard callto get message count and if count is 1, get message info.
1027: FND_MSG_PUB.Count_And_Get
1028: ( p_count => x_msg_count,
1029: p_data => x_msg_data
1030: );