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.JTF_PREFAB_POLICY_PUB dependencies on FND_MSG_PUB

Line 61: FND_MSG_PUB.initialize;

57: END IF;
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.To_Boolean( p_init_msg_list ) THEN
61: FND_MSG_PUB.initialize;
62: END IF;
63:
64: -- Initialize API return status to success
65: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 157: FND_MSG_PUB.Count_And_Get(

153: COMMIT WORK;
154: END IF;
155:
156: -- Standard call to get message count and if count is 1, get message info.
157: FND_MSG_PUB.Count_And_Get(
158: p_count => x_msg_count,
159: p_data => x_msg_data );
160:
161: EXCEPTION

Line 166: FND_MSG_PUB.Count_And_Get(

162: WHEN FND_API.G_EXC_ERROR THEN
163: ROLLBACK TO INSERT_POLICY;
164: x_return_status := FND_API.G_RET_STS_ERROR ;
165:
166: FND_MSG_PUB.Count_And_Get(
167: p_count => x_msg_count,
168: p_data => x_msg_data );
169:
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 174: FND_MSG_PUB.Count_And_Get(

170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: ROLLBACK TO INSERT_POLICY;
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
173:
174: FND_MSG_PUB.Count_And_Get(
175: p_count => x_msg_count,
176: p_data => x_msg_data );
177:
178: WHEN OTHERS THEN

Line 182: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

178: WHEN OTHERS THEN
179: ROLLBACK TO INSERT_POLICY;
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
181:
182: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
183: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
184: END IF;
185:
186: FND_MSG_PUB.Count_And_Get(

Line 183: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

179: ROLLBACK TO INSERT_POLICY;
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
181:
182: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
183: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
184: END IF;
185:
186: FND_MSG_PUB.Count_And_Get(
187: p_count => x_msg_count,

Line 186: FND_MSG_PUB.Count_And_Get(

182: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
183: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
184: END IF;
185:
186: FND_MSG_PUB.Count_And_Get(
187: p_count => x_msg_count,
188: p_data => x_msg_data );
189:
190: END INSERT_POLICY;

Line 239: FND_MSG_PUB.initialize;

235: END IF;
236:
237: -- Initialize message list if p_init_msg_list is set to TRUE.
238: IF FND_API.To_Boolean( p_init_msg_list ) THEN
239: FND_MSG_PUB.initialize;
240: END IF;
241:
242: -- Initialize API return status to success
243: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 301: FND_MSG_PUB.Count_And_Get(

297: COMMIT WORK;
298: END IF;
299:
300: -- Standard call to get message count and if count is 1, get message info.
301: FND_MSG_PUB.Count_And_Get(
302: p_count => x_msg_count,
303: p_data => x_msg_data );
304:
305: EXCEPTION

Line 310: FND_MSG_PUB.Count_And_Get(

306: WHEN FND_API.G_EXC_ERROR THEN
307: ROLLBACK TO UPDATE_POLICY;
308: x_return_status := FND_API.G_RET_STS_ERROR ;
309:
310: FND_MSG_PUB.Count_And_Get(
311: p_count => x_msg_count,
312: p_data => x_msg_data );
313:
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 318: FND_MSG_PUB.Count_And_Get(

314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
315: ROLLBACK TO UPDATE_POLICY;
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
317:
318: FND_MSG_PUB.Count_And_Get(
319: p_count => x_msg_count,
320: p_data => x_msg_data );
321:
322: WHEN OTHERS THEN

Line 326: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

322: WHEN OTHERS THEN
323: ROLLBACK TO UPDATE_POLICY;
324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
325:
326: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
327: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
328: END IF;
329:
330: FND_MSG_PUB.Count_And_Get(

Line 327: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

323: ROLLBACK TO UPDATE_POLICY;
324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
325:
326: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
327: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
328: END IF;
329:
330: FND_MSG_PUB.Count_And_Get(
331: p_count => x_msg_count,

Line 330: FND_MSG_PUB.Count_And_Get(

326: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
327: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
328: END IF;
329:
330: FND_MSG_PUB.Count_And_Get(
331: p_count => x_msg_count,
332: p_data => x_msg_data );
333:
334: END UPDATE_POLICY;

Line 368: FND_MSG_PUB.initialize;

364: END IF;
365:
366: -- Initialize message list if p_init_msg_list is set to TRUE.
367: IF FND_API.To_Boolean( p_init_msg_list ) THEN
368: FND_MSG_PUB.initialize;
369: END IF;
370:
371: -- Initialize API return status to success
372: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 393: FND_MSG_PUB.Count_And_Get(

389: COMMIT WORK;
390: END IF;
391:
392: -- Standard call to get message count and if count is 1, get message info.
393: FND_MSG_PUB.Count_And_Get(
394: p_count => x_msg_count,
395: p_data => x_msg_data );
396:
397: EXCEPTION

Line 402: FND_MSG_PUB.Count_And_Get(

398: WHEN FND_API.G_EXC_ERROR THEN
399: ROLLBACK TO DELETE_POLICY;
400: x_return_status := FND_API.G_RET_STS_ERROR ;
401:
402: FND_MSG_PUB.Count_And_Get(
403: p_count => x_msg_count,
404: p_data => x_msg_data );
405:
406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 410: FND_MSG_PUB.Count_And_Get(

406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
407: ROLLBACK TO DELETE_POLICY;
408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
409:
410: FND_MSG_PUB.Count_And_Get(
411: p_count => x_msg_count,
412: p_data => x_msg_data );
413:
414: WHEN OTHERS THEN

Line 418: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

414: WHEN OTHERS THEN
415: ROLLBACK TO DELETE_POLICY;
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
417:
418: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
419: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
420: END IF;
421:
422: FND_MSG_PUB.Count_And_Get(

Line 419: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

415: ROLLBACK TO DELETE_POLICY;
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
417:
418: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
419: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
420: END IF;
421:
422: FND_MSG_PUB.Count_And_Get(
423: p_count => x_msg_count,

Line 422: FND_MSG_PUB.Count_And_Get(

418: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
419: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
420: END IF;
421:
422: FND_MSG_PUB.Count_And_Get(
423: p_count => x_msg_count,
424: p_data => x_msg_data );
425:
426: END DELETE_POLICY;

Line 463: FND_MSG_PUB.initialize;

459: END IF;
460:
461: -- Initialize message list if p_init_msg_list is set to TRUE.
462: IF FND_API.To_Boolean( p_init_msg_list ) THEN
463: FND_MSG_PUB.initialize;
464: END IF;
465:
466: -- Initialize API return status to success
467: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 505: FND_MSG_PUB.Count_And_Get(

501: COMMIT WORK;
502: END IF;
503:
504: -- Standard call to get message count and if count is 1, get message info.
505: FND_MSG_PUB.Count_And_Get(
506: p_count => x_msg_count,
507: p_data => x_msg_data );
508:
509: EXCEPTION

Line 514: FND_MSG_PUB.Count_And_Get(

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

Line 522: FND_MSG_PUB.Count_And_Get(

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

Line 530: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

526: WHEN OTHERS THEN
527: ROLLBACK TO INSERT_UR_POLICY;
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 ) THEN
531: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
532: END IF;
533:
534: FND_MSG_PUB.Count_And_Get(

Line 531: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

527: ROLLBACK TO INSERT_UR_POLICY;
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 ) THEN
531: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
532: END IF;
533:
534: FND_MSG_PUB.Count_And_Get(
535: p_count => x_msg_count,

Line 534: FND_MSG_PUB.Count_And_Get(

530: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
531: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
532: END IF;
533:
534: FND_MSG_PUB.Count_And_Get(
535: p_count => x_msg_count,
536: p_data => x_msg_data );
537:
538: END INSERT_UR_POLICY;

Line 574: FND_MSG_PUB.initialize;

570: END IF;
571:
572: -- Initialize message list if p_init_msg_list is set to TRUE.
573: IF FND_API.To_Boolean( p_init_msg_list ) THEN
574: FND_MSG_PUB.initialize;
575: END IF;
576:
577: -- Initialize API return status to success
578: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 597: FND_MSG_PUB.Count_And_Get(

593: COMMIT WORK;
594: END IF;
595:
596: -- Standard call to get message count and if count is 1, get message info.
597: FND_MSG_PUB.Count_And_Get(
598: p_count => x_msg_count,
599: p_data => x_msg_data );
600:
601: EXCEPTION

Line 606: FND_MSG_PUB.Count_And_Get(

602: WHEN FND_API.G_EXC_ERROR THEN
603: ROLLBACK TO DELETE_UR_POLICY;
604: x_return_status := FND_API.G_RET_STS_ERROR ;
605:
606: FND_MSG_PUB.Count_And_Get(
607: p_count => x_msg_count,
608: p_data => x_msg_data );
609:
610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 614: FND_MSG_PUB.Count_And_Get(

610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
611: ROLLBACK TO DELETE_UR_POLICY;
612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
613:
614: FND_MSG_PUB.Count_And_Get(
615: p_count => x_msg_count,
616: p_data => x_msg_data );
617:
618: WHEN OTHERS THEN

Line 622: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

618: WHEN OTHERS THEN
619: ROLLBACK TO DELETE_UR_POLICY;
620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
621:
622: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
623: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
624: END IF;
625:
626: FND_MSG_PUB.Count_And_Get(

Line 623: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

619: ROLLBACK TO DELETE_UR_POLICY;
620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
621:
622: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
623: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
624: END IF;
625:
626: FND_MSG_PUB.Count_And_Get(
627: p_count => x_msg_count,

Line 626: FND_MSG_PUB.Count_And_Get(

622: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
623: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
624: END IF;
625:
626: FND_MSG_PUB.Count_And_Get(
627: p_count => x_msg_count,
628: p_data => x_msg_data );
629:
630: END DELETE_UR_POLICY;

Line 664: FND_MSG_PUB.initialize;

660: END IF;
661:
662: -- Initialize message list if p_init_msg_list is set to TRUE.
663: IF FND_API.To_Boolean( p_init_msg_list ) THEN
664: FND_MSG_PUB.initialize;
665: END IF;
666:
667: -- Initialize API return status to success
668: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 685: FND_MSG_PUB.Count_And_Get(

681: COMMIT WORK;
682: END IF;
683:
684: -- Standard call to get message count and if count is 1, get message info.
685: FND_MSG_PUB.Count_And_Get(
686: p_count => x_msg_count,
687: p_data => x_msg_data );
688:
689: EXCEPTION

Line 694: FND_MSG_PUB.Count_And_Get(

690: WHEN FND_API.G_EXC_ERROR THEN
691: ROLLBACK TO DELETE_UR_POLICY;
692: x_return_status := FND_API.G_RET_STS_ERROR ;
693:
694: FND_MSG_PUB.Count_And_Get(
695: p_count => x_msg_count,
696: p_data => x_msg_data );
697:
698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 702: FND_MSG_PUB.Count_And_Get(

698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
699: ROLLBACK TO DELETE_UR_POLICY;
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
701:
702: FND_MSG_PUB.Count_And_Get(
703: p_count => x_msg_count,
704: p_data => x_msg_data );
705:
706: WHEN OTHERS THEN

Line 710: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

706: WHEN OTHERS THEN
707: ROLLBACK TO DELETE_UR_POLICY;
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
709:
710: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
711: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
712: END IF;
713:
714: FND_MSG_PUB.Count_And_Get(

Line 711: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

707: ROLLBACK TO DELETE_UR_POLICY;
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
709:
710: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
711: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
712: END IF;
713:
714: FND_MSG_PUB.Count_And_Get(
715: p_count => x_msg_count,

Line 714: FND_MSG_PUB.Count_And_Get(

710: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
711: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
712: END IF;
713:
714: FND_MSG_PUB.Count_And_Get(
715: p_count => x_msg_count,
716: p_data => x_msg_data );
717:
718: END DELETE_UR_POLICY;

Line 760: FND_MSG_PUB.initialize;

756: END IF;
757:
758: -- Initialize message list if p_init_msg_list is set to TRUE.
759: IF FND_API.To_Boolean( p_init_msg_list ) THEN
760: FND_MSG_PUB.initialize;
761: END IF;
762:
763: -- Initialize API return status to success
764: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 835: FND_MSG_PUB.Count_And_Get(

831: COMMIT WORK;
832: END IF;
833:
834: -- Standard call to get message count and if count is 1, get message info.
835: FND_MSG_PUB.Count_And_Get(
836: p_count => x_msg_count,
837: p_data => x_msg_data );
838:
839: EXCEPTION

Line 844: FND_MSG_PUB.Count_And_Get(

840: WHEN FND_API.G_EXC_ERROR THEN
841: ROLLBACK TO CONFIGURE_SYS_POLICY;
842: x_return_status := FND_API.G_RET_STS_ERROR ;
843:
844: FND_MSG_PUB.Count_And_Get(
845: p_count => x_msg_count,
846: p_data => x_msg_data );
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 852: FND_MSG_PUB.Count_And_Get(

848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: ROLLBACK TO CONFIGURE_SYS_POLICY;
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
851:
852: FND_MSG_PUB.Count_And_Get(
853: p_count => x_msg_count,
854: p_data => x_msg_data );
855:
856: WHEN OTHERS THEN

Line 860: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

856: WHEN OTHERS THEN
857: ROLLBACK TO CONFIGURE_SYS_POLICY;
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
859:
860: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
861: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
862: END IF;
863:
864: FND_MSG_PUB.Count_And_Get(

Line 861: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

857: ROLLBACK TO CONFIGURE_SYS_POLICY;
858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
859:
860: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
861: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
862: END IF;
863:
864: FND_MSG_PUB.Count_And_Get(
865: p_count => x_msg_count,

Line 864: FND_MSG_PUB.Count_And_Get(

860: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
861: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
862: END IF;
863:
864: FND_MSG_PUB.Count_And_Get(
865: p_count => x_msg_count,
866: p_data => x_msg_data );
867:
868: END CONFIGURE_SYS_POLICY;

Line 913: FND_MSG_PUB.initialize;

909: END IF;
910:
911: -- Initialize message list if p_init_msg_list is set to TRUE.
912: IF FND_API.To_Boolean( p_init_msg_list ) THEN
913: FND_MSG_PUB.initialize;
914: END IF;
915:
916: -- Initialize API return status to success
917: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 989: FND_MSG_PUB.Count_And_Get(

985: COMMIT WORK;
986: END IF;
987:
988: -- Standard call to get message count and if count is 1, get message info.
989: FND_MSG_PUB.Count_And_Get(
990: p_count => x_msg_count,
991: p_data => x_msg_data );
992:
993: EXCEPTION

Line 998: FND_MSG_PUB.Count_And_Get(

994: WHEN FND_API.G_EXC_ERROR THEN
995: ROLLBACK TO INSERT_WSH_POLICY;
996: x_return_status := FND_API.G_RET_STS_ERROR ;
997:
998: FND_MSG_PUB.Count_And_Get(
999: p_count => x_msg_count,
1000: p_data => x_msg_data );
1001:
1002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1006: FND_MSG_PUB.Count_And_Get(

1002: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1003: ROLLBACK TO INSERT_WSH_POLICY;
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1005:
1006: FND_MSG_PUB.Count_And_Get(
1007: p_count => x_msg_count,
1008: p_data => x_msg_data );
1009:
1010: WHEN OTHERS THEN

Line 1014: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1010: WHEN OTHERS THEN
1011: ROLLBACK TO INSERT_WSH_POLICY;
1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1013:
1014: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1015: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1016: END IF;
1017:
1018: FND_MSG_PUB.Count_And_Get(

Line 1015: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1011: ROLLBACK TO INSERT_WSH_POLICY;
1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1013:
1014: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1015: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1016: END IF;
1017:
1018: FND_MSG_PUB.Count_And_Get(
1019: p_count => x_msg_count,

Line 1018: FND_MSG_PUB.Count_And_Get(

1014: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1015: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1016: END IF;
1017:
1018: FND_MSG_PUB.Count_And_Get(
1019: p_count => x_msg_count,
1020: p_data => x_msg_data );
1021:
1022: END INSERT_WSH_POLICY;

Line 1064: FND_MSG_PUB.initialize;

1060: END IF;
1061:
1062: -- Initialize message list if p_init_msg_list is set to TRUE.
1063: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1064: FND_MSG_PUB.initialize;
1065: END IF;
1066:
1067: -- Initialize API return status to success
1068: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1111: FND_MSG_PUB.Count_And_Get(

1107: COMMIT WORK;
1108: END IF;
1109:
1110: -- Standard call to get message count and if count is 1, get message info.
1111: FND_MSG_PUB.Count_And_Get(
1112: p_count => x_msg_count,
1113: p_data => x_msg_data );
1114:
1115: EXCEPTION

Line 1120: FND_MSG_PUB.Count_And_Get(

1116: WHEN FND_API.G_EXC_ERROR THEN
1117: ROLLBACK TO UPDATE_WSH_POLICY;
1118: x_return_status := FND_API.G_RET_STS_ERROR ;
1119:
1120: FND_MSG_PUB.Count_And_Get(
1121: p_count => x_msg_count,
1122: p_data => x_msg_data );
1123:
1124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1128: FND_MSG_PUB.Count_And_Get(

1124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1125: ROLLBACK TO UPDATE_WSH_POLICY;
1126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1127:
1128: FND_MSG_PUB.Count_And_Get(
1129: p_count => x_msg_count,
1130: p_data => x_msg_data );
1131:
1132: WHEN OTHERS THEN

Line 1136: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1132: WHEN OTHERS THEN
1133: ROLLBACK TO UPDATE_WSH_POLICY;
1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1135:
1136: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1137: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1138: END IF;
1139:
1140: FND_MSG_PUB.Count_And_Get(

Line 1137: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1133: ROLLBACK TO UPDATE_WSH_POLICY;
1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1135:
1136: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1137: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1138: END IF;
1139:
1140: FND_MSG_PUB.Count_And_Get(
1141: p_count => x_msg_count,

Line 1140: FND_MSG_PUB.Count_And_Get(

1136: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1137: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1138: END IF;
1139:
1140: FND_MSG_PUB.Count_And_Get(
1141: p_count => x_msg_count,
1142: p_data => x_msg_data );
1143:
1144: END UPDATE_WSH_POLICY;

Line 1178: FND_MSG_PUB.initialize;

1174: END IF;
1175:
1176: -- Initialize message list if p_init_msg_list is set to TRUE.
1177: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1178: FND_MSG_PUB.initialize;
1179: END IF;
1180:
1181: -- Initialize API return status to success
1182: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1212: FND_MSG_PUB.Count_And_Get(

1208: COMMIT WORK;
1209: END IF;
1210:
1211: -- Standard call to get message count and if count is 1, get message info.
1212: FND_MSG_PUB.Count_And_Get(
1213: p_count => x_msg_count,
1214: p_data => x_msg_data );
1215:
1216: EXCEPTION

Line 1221: FND_MSG_PUB.Count_And_Get(

1217: WHEN FND_API.G_EXC_ERROR THEN
1218: ROLLBACK TO DELETE_WSH_POLICY;
1219: x_return_status := FND_API.G_RET_STS_ERROR ;
1220:
1221: FND_MSG_PUB.Count_And_Get(
1222: p_count => x_msg_count,
1223: p_data => x_msg_data );
1224:
1225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1229: FND_MSG_PUB.Count_And_Get(

1225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1226: ROLLBACK TO DELETE_WSH_POLICY;
1227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1228:
1229: FND_MSG_PUB.Count_And_Get(
1230: p_count => x_msg_count,
1231: p_data => x_msg_data );
1232:
1233: WHEN OTHERS THEN

Line 1237: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1233: WHEN OTHERS THEN
1234: ROLLBACK TO DELETE_WSH_POLICY;
1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1236:
1237: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1239: END IF;
1240:
1241: FND_MSG_PUB.Count_And_Get(

Line 1238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1234: ROLLBACK TO DELETE_WSH_POLICY;
1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1236:
1237: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1239: END IF;
1240:
1241: FND_MSG_PUB.Count_And_Get(
1242: p_count => x_msg_count,

Line 1241: FND_MSG_PUB.Count_And_Get(

1237: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1238: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1239: END IF;
1240:
1241: FND_MSG_PUB.Count_And_Get(
1242: p_count => x_msg_count,
1243: p_data => x_msg_data );
1244:
1245: END DELETE_WSH_POLICY;

Line 1281: FND_MSG_PUB.initialize;

1277: END IF;
1278:
1279: -- Initialize message list if p_init_msg_list is set to TRUE.
1280: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1281: FND_MSG_PUB.initialize;
1282: END IF;
1283:
1284: -- Initialize API return status to success
1285: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1321: FND_MSG_PUB.Count_And_Get(

1317: COMMIT WORK;
1318: END IF;
1319:
1320: -- Standard call to get message count and if count is 1, get message info.
1321: FND_MSG_PUB.Count_And_Get(
1322: p_count => x_msg_count,
1323: p_data => x_msg_data );
1324:
1325: EXCEPTION

Line 1330: FND_MSG_PUB.Count_And_Get(

1326: WHEN FND_API.G_EXC_ERROR THEN
1327: ROLLBACK TO INSERT_WSHP_POLICY;
1328: x_return_status := FND_API.G_RET_STS_ERROR ;
1329:
1330: FND_MSG_PUB.Count_And_Get(
1331: p_count => x_msg_count,
1332: p_data => x_msg_data );
1333:
1334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1338: FND_MSG_PUB.Count_And_Get(

1334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1335: ROLLBACK TO INSERT_WSHP_POLICY;
1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1337:
1338: FND_MSG_PUB.Count_And_Get(
1339: p_count => x_msg_count,
1340: p_data => x_msg_data );
1341:
1342: WHEN OTHERS THEN

Line 1346: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1342: WHEN OTHERS THEN
1343: ROLLBACK TO INSERT_WSHP_POLICY;
1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1345:
1346: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1347: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1348: END IF;
1349:
1350: FND_MSG_PUB.Count_And_Get(

Line 1347: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1343: ROLLBACK TO INSERT_WSHP_POLICY;
1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1345:
1346: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1347: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1348: END IF;
1349:
1350: FND_MSG_PUB.Count_And_Get(
1351: p_count => x_msg_count,

Line 1350: FND_MSG_PUB.Count_And_Get(

1346: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1347: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1348: END IF;
1349:
1350: FND_MSG_PUB.Count_And_Get(
1351: p_count => x_msg_count,
1352: p_data => x_msg_data );
1353:
1354: END INSERT_WSHP_POLICY;

Line 1389: FND_MSG_PUB.initialize;

1385: END IF;
1386:
1387: -- Initialize message list if p_init_msg_list is set to TRUE.
1388: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1389: FND_MSG_PUB.initialize;
1390: END IF;
1391:
1392: -- Initialize API return status to success
1393: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1411: FND_MSG_PUB.Count_And_Get(

1407: COMMIT WORK;
1408: END IF;
1409:
1410: -- Standard call to get message count and if count is 1, get message info.
1411: FND_MSG_PUB.Count_And_Get(
1412: p_count => x_msg_count,
1413: p_data => x_msg_data );
1414:
1415: EXCEPTION

Line 1420: FND_MSG_PUB.Count_And_Get(

1416: WHEN FND_API.G_EXC_ERROR THEN
1417: ROLLBACK TO DELETE_WSHP_POLICY;
1418: x_return_status := FND_API.G_RET_STS_ERROR ;
1419:
1420: FND_MSG_PUB.Count_And_Get(
1421: p_count => x_msg_count,
1422: p_data => x_msg_data );
1423:
1424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1428: FND_MSG_PUB.Count_And_Get(

1424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1425: ROLLBACK TO DELETE_WSHP_POLICY;
1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1427:
1428: FND_MSG_PUB.Count_And_Get(
1429: p_count => x_msg_count,
1430: p_data => x_msg_data );
1431:
1432: WHEN OTHERS THEN

Line 1436: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1432: WHEN OTHERS THEN
1433: ROLLBACK TO DELETE_WSHP_POLICY;
1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1435:
1436: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1437: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1438: END IF;
1439:
1440: FND_MSG_PUB.Count_And_Get(

Line 1437: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1433: ROLLBACK TO DELETE_WSHP_POLICY;
1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1435:
1436: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1437: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1438: END IF;
1439:
1440: FND_MSG_PUB.Count_And_Get(
1441: p_count => x_msg_count,

Line 1440: FND_MSG_PUB.Count_And_Get(

1436: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1437: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1438: END IF;
1439:
1440: FND_MSG_PUB.Count_And_Get(
1441: p_count => x_msg_count,
1442: p_data => x_msg_data );
1443:
1444: END DELETE_WSHP_POLICY;

Line 1478: FND_MSG_PUB.initialize;

1474: END IF;
1475:
1476: -- Initialize message list if p_init_msg_list is set to TRUE.
1477: IF FND_API.To_Boolean( p_init_msg_list ) THEN
1478: FND_MSG_PUB.initialize;
1479: END IF;
1480:
1481: -- Initialize API return status to success
1482: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1499: FND_MSG_PUB.Count_And_Get(

1495: COMMIT WORK;
1496: END IF;
1497:
1498: -- Standard call to get message count and if count is 1, get message info.
1499: FND_MSG_PUB.Count_And_Get(
1500: p_count => x_msg_count,
1501: p_data => x_msg_data );
1502:
1503: EXCEPTION

Line 1508: FND_MSG_PUB.Count_And_Get(

1504: WHEN FND_API.G_EXC_ERROR THEN
1505: ROLLBACK TO DELETE_WSHP_POLICY;
1506: x_return_status := FND_API.G_RET_STS_ERROR ;
1507:
1508: FND_MSG_PUB.Count_And_Get(
1509: p_count => x_msg_count,
1510: p_data => x_msg_data );
1511:
1512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1516: FND_MSG_PUB.Count_And_Get(

1512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1513: ROLLBACK TO DELETE_WSHP_POLICY;
1514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1515:
1516: FND_MSG_PUB.Count_And_Get(
1517: p_count => x_msg_count,
1518: p_data => x_msg_data );
1519:
1520: WHEN OTHERS THEN

Line 1524: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1520: WHEN OTHERS THEN
1521: ROLLBACK TO DELETE_WSHP_POLICY;
1522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1523:
1524: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1525: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1526: END IF;
1527:
1528: FND_MSG_PUB.Count_And_Get(

Line 1525: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1521: ROLLBACK TO DELETE_WSHP_POLICY;
1522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1523:
1524: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1525: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1526: END IF;
1527:
1528: FND_MSG_PUB.Count_And_Get(
1529: p_count => x_msg_count,

Line 1528: FND_MSG_PUB.Count_And_Get(

1524: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1525: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1526: END IF;
1527:
1528: FND_MSG_PUB.Count_And_Get(
1529: p_count => x_msg_count,
1530: p_data => x_msg_data );
1531:
1532: END DELETE_WSHP_POLICY;