eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_DP_MONITORING_PVT dependencies on FND_API

Line 41: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

37: x_msg_data OUT NOCOPY VARCHAR2
38: ) is
39: l_api_name VARCHAR2(255):='CREATE_DP_ACCT_STATUS';
40: l_api_version_number NUMBER:=1.0;
41: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
42: l_msg_count NUMBER := 0;
43: l_msg_data VARCHAR2(2000);
44: l_seq_id NUMBER := 10000;
45:

Line 56: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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,
59: G_PKG_NAME)
60: THEN

Line 61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

57: p_api_version_number,
58: l_api_name,
59: G_PKG_NAME)
60: THEN
61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
62: END IF;
63:
64: -- Initialize message list if p_init_msg_list is set to TRUE.
65: IF FND_API.to_Boolean( p_init_msg_list )

Line 65: IF FND_API.to_Boolean( p_init_msg_list )

61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
62: END IF;
63:
64: -- Initialize message list if p_init_msg_list is set to TRUE.
65: IF FND_API.to_Boolean( p_init_msg_list )
66: THEN
67: FND_MSG_PUB.initialize;
68: END IF;
69:

Line 72: x_return_status := FND_API.G_RET_STS_SUCCESS;

68: END IF;
69:
70:
71: -- Initialize API return status to SUCCESS
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73:
74: --begins here
75:
76: --get next sequential number

Line 108: IF FND_API.To_Boolean(p_commit) THEN

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:
112: -- Standard callto get message count and if count is 1, get message info.

Line 119: WHEN FND_API.G_EXC_ERROR THEN

115: p_data => x_msg_data
116: );
117: EXCEPTION
118:
119: WHEN FND_API.G_EXC_ERROR THEN
120: ROLLBACK TO create_item_PVT;
121: x_return_status := FND_API.G_RET_STS_ERROR ;
122:
123: FND_MSG_PUB.Count_And_Get

Line 121: x_return_status := FND_API.G_RET_STS_ERROR ;

117: EXCEPTION
118:
119: WHEN FND_API.G_EXC_ERROR THEN
120: ROLLBACK TO create_item_PVT;
121: x_return_status := FND_API.G_RET_STS_ERROR ;
122:
123: FND_MSG_PUB.Count_And_Get
124:
125: ( p_count => x_msg_count,

Line 129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

125: ( p_count => x_msg_count,
126: p_data => x_msg_data
127: );
128:
129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
130: ROLLBACK TO create_item_PVT;
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
132: FND_MSG_PUB.Count_And_Get
133: ( p_count => x_msg_count,

Line 131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

127: );
128:
129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
130: ROLLBACK TO create_item_PVT;
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
132: FND_MSG_PUB.Count_And_Get
133: ( p_count => x_msg_count,
134: p_data => x_msg_data
135: );

Line 139: x_return_status := FND_API.G_RET_STS_ERROR;

135: );
136:
137: WHEN OTHERS THEN
138: ROLLBACK TO create_item_PVT;
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: IF FND_MSG_PUB.Check_Msg_Level
141: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
142: THEN
143: FND_MSG_PUB.Add_Exc_Msg

Line 174: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

170: l_api_name VARCHAR2(255):='RECORD_ACCT_STATUS';
171: l_api_version_number NUMBER:=1.0;
172:
173: l_count NUMBER ;
174: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
175: l_msg_count NUMBER := 0;
176: l_msg_data VARCHAR2(2000);
177:
178: BEGIN

Line 184: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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,
187: G_PKG_NAME)
188: THEN

Line 189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

185: p_api_version_number,
186: l_api_name,
187: G_PKG_NAME)
188: THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191:
192: -- Initialize message list if p_init_msg_list is set to TRUE.
193: IF FND_API.to_Boolean( p_init_msg_list )

Line 193: IF FND_API.to_Boolean( p_init_msg_list )

189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191:
192: -- Initialize message list if p_init_msg_list is set to TRUE.
193: IF FND_API.to_Boolean( p_init_msg_list )
194: THEN
195: FND_MSG_PUB.initialize;
196: END IF;
197:

Line 200: x_return_status := FND_API.G_RET_STS_SUCCESS;

196: END IF;
197:
198:
199: -- Initialize API return status to SUCCESS
200: x_return_status := FND_API.G_RET_STS_SUCCESS;
201:
202: --begins here
203:
204: select count(DP_ACCT_STATUS_ID) into l_count from IEM_DP_ACCT_STATUS where email_account_id=p_acct_id;

Line 213: p_init_msg_list => FND_API.G_FALSE,

209: if l_count > 0 then
210: if p_error_flag = 0 then
211: IEM_DP_MONITORING_PVT.update_dp_acct_status(
212: p_api_version_number => P_Api_Version_Number,
213: p_init_msg_list => FND_API.G_FALSE,
214: p_commit => P_Commit,
215: P_acct_id => P_acct_id,
216: p_inbox_count => p_inbox_count,
217: p_processed_count => p_processed_count,

Line 222: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

218: p_retry_count => p_retry_count,
219: x_return_status =>l_return_status,
220: x_msg_count => l_msg_count,
221: x_msg_data => l_msg_data);
222: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: end if;
225: else
226: update IEM_DP_ACCT_STATUS set LAST_UPDATE_DATE = sysdate where email_account_id=P_acct_id;

Line 223: x_return_status := FND_API.G_RET_STS_ERROR;

219: x_return_status =>l_return_status,
220: x_msg_count => l_msg_count,
221: x_msg_data => l_msg_data);
222: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: end if;
225: else
226: update IEM_DP_ACCT_STATUS set LAST_UPDATE_DATE = sysdate where email_account_id=P_acct_id;
227: end if;

Line 231: p_init_msg_list => FND_API.G_FALSE,

227: end if;
228: else
229: IEM_DP_MONITORING_PVT.create_dp_acct_status(
230: p_api_version_number => P_Api_Version_Number,
231: p_init_msg_list => FND_API.G_FALSE,
232: p_commit => P_Commit,
233: P_acct_id => P_acct_id,
234: p_inbox_count => p_inbox_count,
235: p_processed_count => p_processed_count,

Line 241: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

237: x_return_status =>l_return_status,
238: x_msg_count => l_msg_count,
239: x_msg_data => l_msg_data);
240:
241: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: end if;
244:
245: end if;

Line 242: x_return_status := FND_API.G_RET_STS_ERROR;

238: x_msg_count => l_msg_count,
239: x_msg_data => l_msg_data);
240:
241: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: end if;
244:
245: end if;
246:

Line 248: IF FND_API.To_Boolean(p_commit) THEN

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:
252: -- Standard callto get message count and if count is 1, get message info.

Line 259: WHEN FND_API.G_EXC_ERROR THEN

255: p_data => x_msg_data
256: );
257: EXCEPTION
258:
259: WHEN FND_API.G_EXC_ERROR THEN
260: ROLLBACK TO create_item_PVT;
261: x_return_status := FND_API.G_RET_STS_ERROR ;
262:
263: FND_MSG_PUB.Count_And_Get

Line 261: x_return_status := FND_API.G_RET_STS_ERROR ;

257: EXCEPTION
258:
259: WHEN FND_API.G_EXC_ERROR THEN
260: ROLLBACK TO create_item_PVT;
261: x_return_status := FND_API.G_RET_STS_ERROR ;
262:
263: FND_MSG_PUB.Count_And_Get
264:
265: ( p_count => x_msg_count,

Line 269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

265: ( p_count => x_msg_count,
266: p_data => x_msg_data
267: );
268:
269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
270: ROLLBACK TO create_item_PVT;
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
272: FND_MSG_PUB.Count_And_Get
273: ( p_count => x_msg_count,

Line 271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

267: );
268:
269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
270: ROLLBACK TO create_item_PVT;
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
272: FND_MSG_PUB.Count_And_Get
273: ( p_count => x_msg_count,
274: p_data => x_msg_data
275: );

Line 279: x_return_status := FND_API.G_RET_STS_ERROR;

275: );
276:
277: WHEN OTHERS THEN
278: ROLLBACK TO create_item_PVT;
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: IF FND_MSG_PUB.Check_Msg_Level
281: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
282: THEN
283: FND_MSG_PUB.Add_Exc_Msg

Line 317: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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,
320: G_PKG_NAME)
321: THEN

Line 322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

318: p_api_version_number,
319: l_api_name,
320: G_PKG_NAME)
321: THEN
322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
323: END IF;
324:
325: -- Initialize message list if p_init_msg_list is set to TRUE.
326: IF FND_API.to_Boolean( p_init_msg_list )

Line 326: IF FND_API.to_Boolean( p_init_msg_list )

322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
323: END IF;
324:
325: -- Initialize message list if p_init_msg_list is set to TRUE.
326: IF FND_API.to_Boolean( p_init_msg_list )
327: THEN
328: FND_MSG_PUB.initialize;
329: END IF;
330:

Line 333: x_return_status := FND_API.G_RET_STS_SUCCESS;

329: END IF;
330:
331:
332: -- Initialize API return status to SUCCESS
333: x_return_status := FND_API.G_RET_STS_SUCCESS;
334:
335: --begins here
336:
337: UPDATE IEM_DP_ACCT_STATUS

Line 349: IF FND_API.To_Boolean(p_commit) THEN

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:
353: -- Standard callto get message count and if count is 1, get message info.

Line 360: WHEN FND_API.G_EXC_ERROR THEN

356: p_data => x_msg_data
357: );
358: EXCEPTION
359:
360: WHEN FND_API.G_EXC_ERROR THEN
361: ROLLBACK TO create_item_PVT;
362: x_return_status := FND_API.G_RET_STS_ERROR ;
363:
364: FND_MSG_PUB.Count_And_Get

Line 362: x_return_status := FND_API.G_RET_STS_ERROR ;

358: EXCEPTION
359:
360: WHEN FND_API.G_EXC_ERROR THEN
361: ROLLBACK TO create_item_PVT;
362: x_return_status := FND_API.G_RET_STS_ERROR ;
363:
364: FND_MSG_PUB.Count_And_Get
365:
366: ( p_count => x_msg_count,

Line 370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

366: ( p_count => x_msg_count,
367: p_data => x_msg_data
368: );
369:
370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
371: ROLLBACK TO create_item_PVT;
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
373: FND_MSG_PUB.Count_And_Get
374: ( p_count => x_msg_count,

Line 372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

368: );
369:
370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
371: ROLLBACK TO create_item_PVT;
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
373: FND_MSG_PUB.Count_And_Get
374: ( p_count => x_msg_count,
375: p_data => x_msg_data
376: );

Line 380: x_return_status := FND_API.G_RET_STS_ERROR;

376: );
377:
378: WHEN OTHERS THEN
379: ROLLBACK TO create_item_PVT;
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: IF FND_MSG_PUB.Check_Msg_Level
382: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
383: THEN
384: FND_MSG_PUB.Add_Exc_Msg

Line 410: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

406: x_msg_data OUT NOCOPY VARCHAR2
407: ) is
408: l_api_name VARCHAR2(255):='CREATE_PROCESS_STATUS';
409: l_api_version_number NUMBER:=1.0;
410: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
411:
412: l_seq_id NUMBER := 10000;
413:
414: BEGIN

Line 420: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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,
423: G_PKG_NAME)
424: THEN

Line 425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

421: p_api_version_number,
422: l_api_name,
423: G_PKG_NAME)
424: THEN
425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END IF;
427:
428: -- Initialize message list if p_init_msg_list is set to TRUE.
429: IF FND_API.to_Boolean( p_init_msg_list )

Line 429: IF FND_API.to_Boolean( p_init_msg_list )

425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426: END IF;
427:
428: -- Initialize message list if p_init_msg_list is set to TRUE.
429: IF FND_API.to_Boolean( p_init_msg_list )
430: THEN
431: FND_MSG_PUB.initialize;
432: END IF;
433:

Line 436: x_return_status := FND_API.G_RET_STS_SUCCESS;

432: END IF;
433:
434:
435: -- Initialize API return status to SUCCESS
436: x_return_status := FND_API.G_RET_STS_SUCCESS;
437:
438: --begins here
439:
440:

Line 474: IF FND_API.To_Boolean(p_commit) THEN

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:
478: -- Standard callto get message count and if count is 1, get message info.

Line 485: WHEN FND_API.G_EXC_ERROR THEN

481: p_data => x_msg_data
482: );
483: EXCEPTION
484:
485: WHEN FND_API.G_EXC_ERROR THEN
486: ROLLBACK TO create_item_PVT;
487: x_return_status := FND_API.G_RET_STS_ERROR ;
488:
489: FND_MSG_PUB.Count_And_Get

Line 487: x_return_status := FND_API.G_RET_STS_ERROR ;

483: EXCEPTION
484:
485: WHEN FND_API.G_EXC_ERROR THEN
486: ROLLBACK TO create_item_PVT;
487: x_return_status := FND_API.G_RET_STS_ERROR ;
488:
489: FND_MSG_PUB.Count_And_Get
490:
491: ( p_count => x_msg_count,

Line 495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

491: ( p_count => x_msg_count,
492: p_data => x_msg_data
493: );
494:
495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
496: ROLLBACK TO create_item_PVT;
497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
498: FND_MSG_PUB.Count_And_Get
499: ( p_count => x_msg_count,

Line 497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

493: );
494:
495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
496: ROLLBACK TO create_item_PVT;
497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
498: FND_MSG_PUB.Count_And_Get
499: ( p_count => x_msg_count,
500: p_data => x_msg_data
501: );

Line 505: x_return_status := FND_API.G_RET_STS_ERROR;

501: );
502:
503: WHEN OTHERS THEN
504: ROLLBACK TO create_item_PVT;
505: x_return_status := FND_API.G_RET_STS_ERROR;
506: IF FND_MSG_PUB.Check_Msg_Level
507: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
508: THEN
509: FND_MSG_PUB.Add_Exc_Msg

Line 537: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

533: l_api_version_number number:=1.0;
534: logMessage varchar2(2000);
535:
536: l_count NUMBER ;
537: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
538: l_msg_count NUMBER := 0;
539: l_msg_data VARCHAR2(2000);
540:
541: IEM_ERR_QUE_RESET EXCEPTION;

Line 548: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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)
552: THEN

Line 553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

549: p_api_version_number,
550: l_api_name,
551: G_PKG_NAME)
552: THEN
553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END IF;
555:
556: --Initialize the message list if p_init_msg_list is set to TRUE
557: If FND_API.to_Boolean(p_init_msg_list) THEN

Line 557: If FND_API.to_Boolean(p_init_msg_list) THEN

553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
554: END IF;
555:
556: --Initialize the message list if p_init_msg_list is set to TRUE
557: If FND_API.to_Boolean(p_init_msg_list) THEN
558: FND_MSG_PUB.initialize;
559: END IF;
560:
561: --Initialize API status return

Line 562: x_return_status := FND_API.G_RET_STS_SUCCESS;

558: FND_MSG_PUB.initialize;
559: END IF;
560:
561: --Initialize API status return
562: x_return_status := FND_API.G_RET_STS_SUCCESS;
563:
564:
565: DELETE
566: FROM IEM_DP_PROCESS_STATUS;

Line 574: p_init_msg_list => FND_API.G_FALSE,

570:
571:
572: IEM_PP_QUEUE_PVT.reset_data (
573: p_api_version_number =>P_Api_Version_Number,
574: p_init_msg_list => FND_API.G_FALSE,
575: p_commit => 'F',
576: x_return_status =>l_return_status,
577: x_msg_count => l_msg_count,
578: x_msg_data => l_msg_data);

Line 580: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

576: x_return_status =>l_return_status,
577: x_msg_count => l_msg_count,
578: x_msg_data => l_msg_data);
579:
580: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
581: raise IEM_ERR_QUE_RESET;
582: end if;
583:
584: -- Insert parameters into iem_comp_rt_stats

Line 589: p_init_msg_list => FND_API.G_FALSE,

585: delete IEM_COMP_RT_STATS where type='DOWNLOAD PROCESSOR';
586:
587: IEM_COMP_RT_STATS_PVT.create_item (
588: p_api_version_number =>P_Api_Version_Number,
589: p_init_msg_list => FND_API.G_FALSE,
590: p_commit => 'F',
591: p_type => 'DOWNLOAD PROCESSOR',
592: p_param => 'POSTPROC_SLEEP_DURATION',
593: p_value => p_postproc_sleep,

Line 598: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

594: x_return_status =>l_return_status,
595: x_msg_count => l_msg_count,
596: x_msg_data => l_msg_data);
597:
598: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
599: raise IEM_ERR_QUE_RESET;
600: end if;
601:
602: IEM_COMP_RT_STATS_PVT.create_item (

Line 604: p_init_msg_list => FND_API.G_FALSE,

600: end if;
601:
602: IEM_COMP_RT_STATS_PVT.create_item (
603: p_api_version_number =>P_Api_Version_Number,
604: p_init_msg_list => FND_API.G_FALSE,
605: p_commit => 'F',
606: p_type => 'DOWNLOAD PROCESSOR',
607: p_param => 'PREPROC_SLEEP_DURATION',
608: p_value => p_preproc_sleep,

Line 614: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

610: x_msg_count => l_msg_count,
611: x_msg_data => l_msg_data);
612:
613:
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

Line 619: IF FND_API.to_Boolean(p_commit) 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:
623: FND_MSG_PUB.Count_And_Get

Line 628: WHEN FND_API.G_EXC_ERROR THEN

624: ( p_count => x_msg_count,p_data => x_msg_data);
625:
626: EXCEPTION
627:
628: WHEN FND_API.G_EXC_ERROR THEN
629: ROLLBACK TO cleanup_monitoring_data_PVT;
630: x_return_status := FND_API.G_RET_STS_ERROR ;
631: FND_MSG_PUB.Count_And_Get
632: ( p_count => x_msg_count,p_data => x_msg_data);

Line 630: x_return_status := FND_API.G_RET_STS_ERROR ;

626: EXCEPTION
627:
628: WHEN FND_API.G_EXC_ERROR THEN
629: ROLLBACK TO cleanup_monitoring_data_PVT;
630: x_return_status := FND_API.G_RET_STS_ERROR ;
631: FND_MSG_PUB.Count_And_Get
632: ( p_count => x_msg_count,p_data => x_msg_data);
633:
634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

630: x_return_status := FND_API.G_RET_STS_ERROR ;
631: FND_MSG_PUB.Count_And_Get
632: ( p_count => x_msg_count,p_data => x_msg_data);
633:
634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
635: ROLLBACK TO cleanup_monitoring_data_PVT;
636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
637: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
638:

Line 636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

632: ( p_count => x_msg_count,p_data => x_msg_data);
633:
634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
635: ROLLBACK TO cleanup_monitoring_data_PVT;
636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
637: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
638:
639:
640: WHEN OTHERS THEN

Line 643: x_return_status := FND_API.G_RET_STS_ERROR;

639:
640: WHEN OTHERS THEN
641: ROLLBACK TO cleanup_monitoring_data_PVT;
642:
643: x_return_status := FND_API.G_RET_STS_ERROR;
644: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
645: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
646: END IF;
647: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

Line 674: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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)
678: THEN

Line 679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

675: p_api_version_number,
676: l_api_name,
677: G_PKG_NAME)
678: THEN
679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
680: END IF;
681:
682: -- Initialize message list if p_init_msg_list is set to TRUE.
683: IF FND_API.to_Boolean( p_init_msg_list )

Line 683: IF FND_API.to_Boolean( p_init_msg_list )

679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
680: END IF;
681:
682: -- Initialize message list if p_init_msg_list is set to TRUE.
683: IF FND_API.to_Boolean( p_init_msg_list )
684: THEN
685: FND_MSG_PUB.initialize;
686: END IF;
687:

Line 689: x_return_status := FND_API.G_RET_STS_SUCCESS;

685: FND_MSG_PUB.initialize;
686: END IF;
687:
688: -- Initialize API return status to SUCCESS
689: x_return_status := FND_API.G_RET_STS_SUCCESS;
690:
691: l_instance := FND_CONCURRENT.Get_Service_Instances('IEMDPDEV');
692:
693: if ( l_instance is not null ) then

Line 731: IF FND_API.To_Boolean(p_commit) THEN

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:
735: -- Standard callto get message count and if count is 1, get message info.

Line 743: WHEN FND_API.G_EXC_ERROR THEN

739: );
740: EXCEPTION
741:
742:
743: WHEN FND_API.G_EXC_ERROR THEN
744:
745: ROLLBACK TO GET_DP_RUNNING_STATUS;
746: x_return_status := FND_API.G_RET_STS_ERROR ;
747: FND_MSG_PUB.Count_And_Get

Line 746: x_return_status := FND_API.G_RET_STS_ERROR ;

742:
743: WHEN FND_API.G_EXC_ERROR THEN
744:
745: ROLLBACK TO GET_DP_RUNNING_STATUS;
746: x_return_status := FND_API.G_RET_STS_ERROR ;
747: FND_MSG_PUB.Count_And_Get
748: ( p_count => x_msg_count,
749: p_data => x_msg_data
750: );

Line 751: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

747: FND_MSG_PUB.Count_And_Get
748: ( p_count => x_msg_count,
749: p_data => x_msg_data
750: );
751: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
752:
753: ROLLBACK TO GET_DP_RUNNING_STATUS;
754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
755: FND_MSG_PUB.Count_And_Get

Line 754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

750: );
751: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
752:
753: ROLLBACK TO GET_DP_RUNNING_STATUS;
754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
755: FND_MSG_PUB.Count_And_Get
756: ( p_count => x_msg_count,
757: p_data => x_msg_data
758: );

Line 762: x_return_status := FND_API.G_RET_STS_ERROR;

758: );
759: WHEN OTHERS THEN
760:
761: ROLLBACK TO GET_DP_RUNNING_STATUS;
762: x_return_status := FND_API.G_RET_STS_ERROR;
763: IF FND_MSG_PUB.Check_Msg_Level
764: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
765: THEN
766: FND_MSG_PUB.Add_Exc_Msg

Line 800: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

796: is
797: l_api_name VARCHAR2(255):='GET_ACCOUNT_DP_STATUS';
798: l_api_version_number NUMBER:=1.0;
799:
800: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
801: l_msg_count NUMBER := 0;
802: l_msg_data VARCHAR2(2000);
803:
804: l_dp_status VARCHAR2(10);

Line 851: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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)
855: THEN

Line 856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

852: p_api_version_number,
853: l_api_name,
854: G_PKG_NAME)
855: THEN
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: END IF;
858:
859: -- Initialize message list if p_init_msg_list is set to TRUE.
860: IF FND_API.to_Boolean( p_init_msg_list )

Line 860: IF FND_API.to_Boolean( p_init_msg_list )

856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: END IF;
858:
859: -- Initialize message list if p_init_msg_list is set to TRUE.
860: IF FND_API.to_Boolean( p_init_msg_list )
861: THEN
862: FND_MSG_PUB.initialize;
863: END IF;
864:

Line 866: x_return_status := FND_API.G_RET_STS_SUCCESS;

862: FND_MSG_PUB.initialize;
863: END IF;
864:
865: -- Initialize API return status to SUCCESS
866: x_return_status := FND_API.G_RET_STS_SUCCESS;
867:
868:
869: IEM_DP_MONITORING_PVT.get_dp_running_status(
870: p_api_version_number =>P_Api_Version_Number,

Line 871: p_init_msg_list => FND_API.G_FALSE,

867:
868:
869: IEM_DP_MONITORING_PVT.get_dp_running_status(
870: p_api_version_number =>P_Api_Version_Number,
871: p_init_msg_list => FND_API.G_FALSE,
872: p_commit => 'F',
873: p_mode => 'N',
874: x_DP_STATUS => l_dp_status,
875: x_return_status =>l_return_status,

Line 879: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

875: x_return_status =>l_return_status,
876: x_msg_count => l_msg_count,
877: x_msg_data => l_msg_data);
878:
879: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
880: raise IEM_ERROR_GET_DP_STATUS;
881: end if;
882:
883: i:= 1;

Line 1022: IF FND_API.To_Boolean(p_commit) THEN

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:
1026: -- Standard callto get message count and if count is 1, get message info.

Line 1035: x_return_status := FND_API.G_RET_STS_ERROR;

1031: EXCEPTION
1032:
1033: WHEN IEM_ERROR_GET_DP_STATUS THEN
1034: ROLLBACK TO GET_ACCOUNT_DP_STATUS;
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036: FND_MSG_PUB.Count_And_Get
1037: ( p_count => x_msg_count,
1038: p_data => x_msg_data
1039: );

Line 1041: WHEN FND_API.G_EXC_ERROR THEN

1037: ( p_count => x_msg_count,
1038: p_data => x_msg_data
1039: );
1040:
1041: WHEN FND_API.G_EXC_ERROR THEN
1042:
1043: ROLLBACK TO GET_ACCOUNT_DP_STATUS;
1044: x_return_status := FND_API.G_RET_STS_ERROR ;
1045: FND_MSG_PUB.Count_And_Get

Line 1044: x_return_status := FND_API.G_RET_STS_ERROR ;

1040:
1041: WHEN FND_API.G_EXC_ERROR THEN
1042:
1043: ROLLBACK TO GET_ACCOUNT_DP_STATUS;
1044: x_return_status := FND_API.G_RET_STS_ERROR ;
1045: FND_MSG_PUB.Count_And_Get
1046: ( p_count => x_msg_count,
1047: p_data => x_msg_data
1048: );

Line 1049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1045: FND_MSG_PUB.Count_And_Get
1046: ( p_count => x_msg_count,
1047: p_data => x_msg_data
1048: );
1049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1050:
1051: ROLLBACK TO GET_ACCOUNT_DP_STATUS;
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1053: FND_MSG_PUB.Count_And_Get

Line 1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1048: );
1049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1050:
1051: ROLLBACK TO GET_ACCOUNT_DP_STATUS;
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1053: FND_MSG_PUB.Count_And_Get
1054: ( p_count => x_msg_count,
1055: p_data => x_msg_data
1056: );

Line 1060: x_return_status := FND_API.G_RET_STS_ERROR;

1056: );
1057: WHEN OTHERS THEN
1058:
1059: ROLLBACK TO GET_ACCOUNT_DP_STATUS;
1060: x_return_status := FND_API.G_RET_STS_ERROR;
1061: IF FND_MSG_PUB.Check_Msg_Level
1062: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1063: THEN
1064: FND_MSG_PUB.Add_Exc_Msg