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.IEX_WEBSWITCH_PKG dependencies on FND_API

Line 47: IF NOT FND_API.Compatible_API_Call (l_api_version,

43: -- Standard begin of API savepoint
44: SAVEPOINT Create_WebSwitch_PUB;
45:
46: -- Standard call to check for call compatibility.
47: IF NOT FND_API.Compatible_API_Call (l_api_version,
48: p_api_version,
49: l_api_name,
50: G_PKG_NAME)
51: THEN

Line 52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

48: p_api_version,
49: l_api_name,
50: G_PKG_NAME)
51: THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: END IF;
54:
55: -- Check p_init_msg_list
56: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 56: IF FND_API.to_Boolean( p_init_msg_list ) THEN

52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: END IF;
54:
55: -- Check p_init_msg_list
56: IF FND_API.to_Boolean( p_init_msg_list ) THEN
57: FND_MSG_PUB.initialize;
58: END IF;
59:
60: -- Initialize API return status to success

Line 61: x_return_status := FND_API.G_RET_STS_SUCCESS;

57: FND_MSG_PUB.initialize;
58: END IF;
59:
60: -- Initialize API return status to success
61: x_return_status := FND_API.G_RET_STS_SUCCESS;
62:
63: -- API body
64: OPEN c1;
65: FETCH c1 INTO l_dummy;

Line 210: IF FND_API.To_Boolean ( p_commit ) THEN

206: END IF;
207: CLOSE c2;
208:
209: -- Standard check of p_commit.
210: IF FND_API.To_Boolean ( p_commit ) THEN
211: COMMIT WORK;
212: END IF;
213:
214: -- Debug Message

Line 231: WHEN FND_API.G_EXC_ERROR THEN

227: -- Normal API Exception handling, IF exception occurs outside of phone processing loop
228: --
229: EXCEPTION
230:
231: WHEN FND_API.G_EXC_ERROR THEN
232:
233: ROLLBACK TO Create_WebSwitch_PUB;
234: x_return_status := FND_API.G_RET_STS_ERROR ;
235:

Line 234: x_return_status := FND_API.G_RET_STS_ERROR ;

230:
231: WHEN FND_API.G_EXC_ERROR THEN
232:
233: ROLLBACK TO Create_WebSwitch_PUB;
234: x_return_status := FND_API.G_RET_STS_ERROR ;
235:
236: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
237: p_data => x_msg_data );
238:

Line 239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

235:
236: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
237: p_data => x_msg_data );
238:
239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
240:
241: ROLLBACK TO Create_WebSwitch_PUB;
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
243:

Line 242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

238:
239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
240:
241: ROLLBACK TO Create_WebSwitch_PUB;
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
243:
244: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
245: p_data => x_msg_data );
246:

Line 250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

246:
247: WHEN OTHERS THEN
248:
249: ROLLBACK TO Create_WebSwitch_PUB;
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
251:
252: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
253: THEN
254: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 288: IF NOT FND_API.Compatible_API_Call (l_api_version,

284: -- Standard begin of API savepoint
285: SAVEPOINT Update_WebSwitch_PVT;
286:
287: -- Standard call to check for call compatibility.
288: IF NOT FND_API.Compatible_API_Call (l_api_version,
289: p_api_version,
290: l_api_name,
291: G_PKG_NAME)
292: THEN

Line 293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

289: p_api_version,
290: l_api_name,
291: G_PKG_NAME)
292: THEN
293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
294: END IF;
295:
296: -- Check p_init_msg_list
297: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 297: IF FND_API.to_Boolean( p_init_msg_list ) THEN

293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
294: END IF;
295:
296: -- Check p_init_msg_list
297: IF FND_API.to_Boolean( p_init_msg_list ) THEN
298: FND_MSG_PUB.initialize;
299: END IF;
300:
301:

Line 303: x_return_status := FND_API.G_RET_STS_SUCCESS;

299: END IF;
300:
301:
302: -- Initialize API return status to success
303: x_return_status := FND_API.G_RET_STS_SUCCESS;
304:
305: -- API body
306: UPDATE iex_cgi_switches
307: SET

Line 369: IF FND_API.To_Boolean ( p_commit ) THEN

365: WHERE cgi_switch_id = p_switch_data_rec.cgi_switch_id
366: AND switch_data_id = p_switch_data_rec.switch_data_id;
367:
368: -- Standard check of p_commit.
369: IF FND_API.To_Boolean ( p_commit ) THEN
370: COMMIT WORK;
371: END IF;
372:
373: -- Standard call to get message count and IF count is 1, get message info.

Line 383: WHEN FND_API.G_EXC_ERROR THEN

379: -- Normal API Exception handling, IF exception occurs outside of phone processing loop
380: --
381: EXCEPTION
382:
383: WHEN FND_API.G_EXC_ERROR THEN
384:
385: ROLLBACK TO Update_WebSwitch_PVT;
386: x_return_status := FND_API.G_RET_STS_ERROR ;
387:

Line 386: x_return_status := FND_API.G_RET_STS_ERROR ;

382:
383: WHEN FND_API.G_EXC_ERROR THEN
384:
385: ROLLBACK TO Update_WebSwitch_PVT;
386: x_return_status := FND_API.G_RET_STS_ERROR ;
387:
388: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
389: p_data => x_msg_data );
390:

Line 391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

387:
388: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
389: p_data => x_msg_data );
390:
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392:
393: ROLLBACK TO Update_WebSwitch_PVT;
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
395:

Line 394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

390:
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392:
393: ROLLBACK TO Update_WebSwitch_PVT;
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
395:
396: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
397: p_data => x_msg_data );
398:

Line 402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

398:
399: WHEN OTHERS THEN
400:
401: ROLLBACK TO Update_WebSwitch_PVT;
402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
403:
404: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
405: THEN
406: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 439: IF NOT FND_API.Compatible_API_Call (l_api_version,

435: begin
436: -- Standard begin of API savepoint
437: SAVEPOINT Lock_WebSwitch_PVT;
438: -- Standard call to check for call compatibility.
439: IF NOT FND_API.Compatible_API_Call (l_api_version,
440: p_api_version,
441: l_api_name,
442: G_PKG_NAME)
443: THEN

Line 444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

440: p_api_version,
441: l_api_name,
442: G_PKG_NAME)
443: THEN
444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
445: END IF;
446:
447: -- Check p_init_msg_list
448: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 448: IF FND_API.to_Boolean( p_init_msg_list ) THEN

444: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
445: END IF;
446:
447: -- Check p_init_msg_list
448: IF FND_API.to_Boolean( p_init_msg_list ) THEN
449: FND_MSG_PUB.initialize;
450: END IF;
451:
452: -- Initialize API return status to success

Line 453: x_return_status := FND_API.G_RET_STS_SUCCESS;

449: FND_MSG_PUB.initialize;
450: END IF;
451:
452: -- Initialize API return status to success
453: x_return_status := FND_API.G_RET_STS_SUCCESS;
454:
455: -- API body
456: DECLARE
457: v_dummy CHAR(1);

Line 495: IF FND_API.To_Boolean ( p_commit ) THEN

491:
492:
493:
494: -- Standard check of p_commit.
495: IF FND_API.To_Boolean ( p_commit ) THEN
496: COMMIT WORK;
497: END IF;
498:
499: -- Standard call to get message count and IF count is 1, get message info.

Line 509: WHEN FND_API.G_EXC_ERROR THEN

505: -- Normal API Exception handling, IF exception occurs outside of phone processing loop
506: --
507: EXCEPTION
508:
509: WHEN FND_API.G_EXC_ERROR THEN
510:
511: ROLLBACK TO Lock_WebSwitch_PVT;
512: x_return_status := FND_API.G_RET_STS_ERROR ;
513:

Line 512: x_return_status := FND_API.G_RET_STS_ERROR ;

508:
509: WHEN FND_API.G_EXC_ERROR THEN
510:
511: ROLLBACK TO Lock_WebSwitch_PVT;
512: x_return_status := FND_API.G_RET_STS_ERROR ;
513:
514: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
515: p_data => x_msg_data );
516:

Line 517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

513:
514: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
515: p_data => x_msg_data );
516:
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518:
519: ROLLBACK TO Lock_WebSwitch_PVT;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
521:

Line 520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

516:
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518:
519: ROLLBACK TO Lock_WebSwitch_PVT;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
521:
522: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
523: p_data => x_msg_data );
524:

Line 528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

524:
525: WHEN OTHERS THEN
526:
527: ROLLBACK TO Lock_WebSwitch_PVT;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
529:
530: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
531: THEN
532: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 567: IF NOT FND_API.Compatible_API_Call (l_api_version,

563: -- Standard begin of API savepoint
564: SAVEPOINT Delete_WebSwitch_PUB;
565:
566: -- Standard call to check for call compatibility.
567: IF NOT FND_API.Compatible_API_Call (l_api_version,
568: p_api_version,
569: l_api_name,
570: G_PKG_NAME)
571: THEN

Line 572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

568: p_api_version,
569: l_api_name,
570: G_PKG_NAME)
571: THEN
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: END IF;
574: -- Check p_init_msg_list
575: IF FND_API.to_Boolean( p_init_msg_list ) THEN
576: FND_MSG_PUB.initialize;

Line 575: IF FND_API.to_Boolean( p_init_msg_list ) THEN

571: THEN
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: END IF;
574: -- Check p_init_msg_list
575: IF FND_API.to_Boolean( p_init_msg_list ) THEN
576: FND_MSG_PUB.initialize;
577: END IF;
578:
579: -- Initialize API return status to success

Line 580: x_return_status := FND_API.G_RET_STS_SUCCESS;

576: FND_MSG_PUB.initialize;
577: END IF;
578:
579: -- Initialize API return status to success
580: x_return_status := FND_API.G_RET_STS_SUCCESS;
581:
582: -- API body
583: IF p_switch_data_rec.switch_data_id IS NOT NULL THEN
584: DELETE FROM iex_switch_data

Line 595: IF FND_API.To_Boolean ( p_commit ) THEN

591: WHERE cgi_switch_id = p_cgi_switch_rec.cgi_switch_id;
592: END IF;
593:
594: -- Standard check of p_commit.
595: IF FND_API.To_Boolean ( p_commit ) THEN
596: COMMIT WORK;
597: END IF;
598:
599: -- Debug Message

Line 616: WHEN FND_API.G_EXC_ERROR THEN

612: -- Normal API Exception handling, IF exception occurs outside of phone processing loop
613: --
614: EXCEPTION
615:
616: WHEN FND_API.G_EXC_ERROR THEN
617:
618: ROLLBACK TO Delete_WebSwitch_PUB;
619: x_return_status := FND_API.G_RET_STS_ERROR ;
620:

Line 619: x_return_status := FND_API.G_RET_STS_ERROR ;

615:
616: WHEN FND_API.G_EXC_ERROR THEN
617:
618: ROLLBACK TO Delete_WebSwitch_PUB;
619: x_return_status := FND_API.G_RET_STS_ERROR ;
620:
621: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
622: p_data => x_msg_data );
623:

Line 624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

620:
621: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
622: p_data => x_msg_data );
623:
624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
625:
626: ROLLBACK TO Delete_WebSwitch_PUB;
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
628:

Line 627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

623:
624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
625:
626: ROLLBACK TO Delete_WebSwitch_PUB;
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
628:
629: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
630: p_data => x_msg_data );
631:

Line 635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

631:
632: WHEN OTHERS THEN
633:
634: ROLLBACK TO Delete_WebSwitch_PUB;
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
636:
637: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
638: THEN
639: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);