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_EMAILPROC_PVT dependencies on FND_MSG_PUB

Line 89: FND_MSG_PUB.initialize;

85: END IF;
86:
87: --Initialize the message list if p_init_msg_list is set to TRUE
88: If FND_API.to_Boolean(p_init_msg_list) THEN
89: FND_MSG_PUB.initialize;
90: END IF;
91:
92: --Initialize API status return
93: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 222: FND_MSG_PUB.Count_And_Get

218: EXCEPTION
219: WHEN FND_API.G_EXC_ERROR THEN
220: ROLLBACK TO loadEmailProc_pvt;
221: x_return_status := FND_API.G_RET_STS_ERROR ;
222: FND_MSG_PUB.Count_And_Get
223: ( p_count => x_msg_count,p_data => x_msg_data);
224:
225:
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 229: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);

225:
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: ROLLBACK TO loadEmailProc_pvt;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
229: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
230:
231:
232: WHEN OTHERS THEN
233: ROLLBACK TO loadEmailProc_pvt;

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

231:
232: WHEN OTHERS THEN
233: ROLLBACK TO loadEmailProc_pvt;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
236: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
237: END IF;
238:
239: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

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

232: WHEN OTHERS THEN
233: ROLLBACK TO loadEmailProc_pvt;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
236: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
237: END IF;
238:
239: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
240:

Line 239: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

235: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
236: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
237: END IF;
238:
239: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
240:
241: END ;
242:
243:

Line 323: FND_MSG_PUB.initialize;

319: END IF;
320:
321: --Initialize the message list if p_init_msg_list is set to TRUE
322: If FND_API.to_Boolean(p_init_msg_list) THEN
323: FND_MSG_PUB.initialize;
324: END IF;
325:
326: --Initialize API status return
327: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 450: FND_MSG_PUB.Count_And_Get

446: EXCEPTION
447: WHEN FND_API.G_EXC_ERROR THEN
448: ROLLBACK TO loadAcctEmailProc_pvt;
449: x_return_status := FND_API.G_RET_STS_ERROR ;
450: FND_MSG_PUB.Count_And_Get
451: ( p_count => x_msg_count,p_data => x_msg_data);
452:
453:
454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 457: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);

453:
454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
455: ROLLBACK TO loadAcctEmailProc_pvt;
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
457: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
458:
459:
460: WHEN OTHERS THEN
461: ROLLBACK TO loadAcctEmailProc_pvt;

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

459:
460: WHEN OTHERS THEN
461: ROLLBACK TO loadAcctEmailProc_pvt;
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
464: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
465: END IF;
466:
467: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

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

460: WHEN OTHERS THEN
461: ROLLBACK TO loadAcctEmailProc_pvt;
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
464: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
465: END IF;
466:
467: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
468:

Line 467: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

463: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
464: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
465: END IF;
466:
467: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
468:
469: END ;
470:
471:

Line 515: FND_MSG_PUB.initialize;

511: END IF;
512:
513: --Initialize the message list if p_init_msg_list is set to TRUE
514: If FND_API.to_Boolean(p_init_msg_list) THEN
515: FND_MSG_PUB.initialize;
516: END IF;
517:
518: --Initialize API status return
519: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

579: WHEN MY_EXCEPTION THEN
580: ROLLBACK TO loadAcctEmailProc_pvt;
581:
582: x_return_status := FND_API.G_RET_STS_ERROR ;
583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
584: WHEN FND_API.G_EXC_ERROR THEN
585: ROLLBACK TO loadAcctEmailProc_pvt;
586: x_return_status := FND_API.G_RET_STS_ERROR ;
587: FND_MSG_PUB.Count_And_Get

Line 587: FND_MSG_PUB.Count_And_Get

583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
584: WHEN FND_API.G_EXC_ERROR THEN
585: ROLLBACK TO loadAcctEmailProc_pvt;
586: x_return_status := FND_API.G_RET_STS_ERROR ;
587: FND_MSG_PUB.Count_And_Get
588: ( p_count => x_msg_count,p_data => x_msg_data);
589:
590:
591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 594: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);

590:
591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
592: ROLLBACK TO loadAcctEmailProc_pvt;
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
594: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
595:
596:
597: WHEN OTHERS THEN
598: ROLLBACK TO loadAcctEmailProc_pvt;

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

596:
597: WHEN OTHERS THEN
598: ROLLBACK TO loadAcctEmailProc_pvt;
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
601: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
602: END IF;
603:
604: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

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

597: WHEN OTHERS THEN
598: ROLLBACK TO loadAcctEmailProc_pvt;
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
601: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
602: END IF;
603:
604: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
605:

Line 604: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

600: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
601: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
602: END IF;
603:
604: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
605:
606: END ;
607:
608: --update iem_routes, update iem_route_rules, insert iem_route_rules

Line 691: FND_MSG_PUB.initialize;

687:
688: -- Initialize message list if p_init_msg_list is set to TRUE.
689: IF FND_API.to_Boolean( p_init_msg_list )
690: THEN
691: FND_MSG_PUB.initialize;
692: END IF;
693:
694:
695: -- Initialize API return status to SUCCESS

Line 896: -- FND_MSG_PUB.Add;

892: WHEN l_IEM_FAIL_TO_CALL THEN
893: ROLLBACK TO update_item_wrap;
894: -- FND_MESSAGE.SET_NAME('IEM','IEM_NO_ROUTE_UPDATE');
895:
896: -- FND_MSG_PUB.Add;
897: x_return_status := FND_API.G_RET_STS_ERROR ;
898: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
899:
900: WHEN IEM_ADM_AUTOPRC_NO_PARAMETERS THEN

Line 898: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

894: -- FND_MESSAGE.SET_NAME('IEM','IEM_NO_ROUTE_UPDATE');
895:
896: -- FND_MSG_PUB.Add;
897: x_return_status := FND_API.G_RET_STS_ERROR ;
898: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
899:
900: WHEN IEM_ADM_AUTOPRC_NO_PARAMETERS THEN
901: ROLLBACK TO update_item_wrap;
902: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_AUTOPRC_NO_PARAMETERS');

Line 904: FND_MSG_PUB.Add;

900: WHEN IEM_ADM_AUTOPRC_NO_PARAMETERS THEN
901: ROLLBACK TO update_item_wrap;
902: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_AUTOPRC_NO_PARAMETERS');
903:
904: FND_MSG_PUB.Add;
905: x_return_status := FND_API.G_RET_STS_ERROR ;
906: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
907:
908: WHEN IEM_PROC_REDIRECT_SAME_ACCT THEN

Line 906: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

902: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_AUTOPRC_NO_PARAMETERS');
903:
904: FND_MSG_PUB.Add;
905: x_return_status := FND_API.G_RET_STS_ERROR ;
906: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
907:
908: WHEN IEM_PROC_REDIRECT_SAME_ACCT THEN
909: ROLLBACK TO update_item_wrap;
910: FND_MESSAGE.SET_NAME('IEM','IEM_PROC_REDIRECT_SAME_ACCT');

Line 912: FND_MSG_PUB.Add;

908: WHEN IEM_PROC_REDIRECT_SAME_ACCT THEN
909: ROLLBACK TO update_item_wrap;
910: FND_MESSAGE.SET_NAME('IEM','IEM_PROC_REDIRECT_SAME_ACCT');
911:
912: FND_MSG_PUB.Add;
913: x_return_status := FND_API.G_RET_STS_ERROR ;
914: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
915:
916: WHEN IEM_ADM_INVALID_PROC_NAME THEN

Line 914: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

910: FND_MESSAGE.SET_NAME('IEM','IEM_PROC_REDIRECT_SAME_ACCT');
911:
912: FND_MSG_PUB.Add;
913: x_return_status := FND_API.G_RET_STS_ERROR ;
914: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
915:
916: WHEN IEM_ADM_INVALID_PROC_NAME THEN
917: ROLLBACK TO update_item_wrap;
918: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_PROC_NAME');

Line 920: -- FND_MSG_PUB.Add;

916: WHEN IEM_ADM_INVALID_PROC_NAME THEN
917: ROLLBACK TO update_item_wrap;
918: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_PROC_NAME');
919:
920: -- FND_MSG_PUB.Add;
921: x_return_status := FND_API.G_RET_STS_ERROR ;
922: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
923:
924: WHEN IEM_NO_ROUTE_UPDATE THEN

Line 922: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

918: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_PROC_NAME');
919:
920: -- FND_MSG_PUB.Add;
921: x_return_status := FND_API.G_RET_STS_ERROR ;
922: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
923:
924: WHEN IEM_NO_ROUTE_UPDATE THEN
925: ROLLBACK TO update_item_wrap;
926: FND_MESSAGE.SET_NAME('IEM','IEM_NO_ROUTE_UPDATE');

Line 928: FND_MSG_PUB.Add;

924: WHEN IEM_NO_ROUTE_UPDATE THEN
925: ROLLBACK TO update_item_wrap;
926: FND_MESSAGE.SET_NAME('IEM','IEM_NO_ROUTE_UPDATE');
927:
928: FND_MSG_PUB.Add;
929: x_return_status := FND_API.G_RET_STS_ERROR ;
930: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
931: WHEN IEM_NO_RULE_UPDATE THEN
932: ROLLBACK TO update_item_wrap;

Line 930: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

926: FND_MESSAGE.SET_NAME('IEM','IEM_NO_ROUTE_UPDATE');
927:
928: FND_MSG_PUB.Add;
929: x_return_status := FND_API.G_RET_STS_ERROR ;
930: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
931: WHEN IEM_NO_RULE_UPDATE THEN
932: ROLLBACK TO update_item_wrap;
933: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');
934: FND_MSG_PUB.Add;

Line 934: FND_MSG_PUB.Add;

930: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
931: WHEN IEM_NO_RULE_UPDATE THEN
932: ROLLBACK TO update_item_wrap;
933: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');
934: FND_MSG_PUB.Add;
935: x_return_status := FND_API.G_RET_STS_ERROR ;
936: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
937:
938: WHEN IEM_RULE_NOT_DELETED THEN

Line 936: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

932: ROLLBACK TO update_item_wrap;
933: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');
934: FND_MSG_PUB.Add;
935: x_return_status := FND_API.G_RET_STS_ERROR ;
936: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
937:
938: WHEN IEM_RULE_NOT_DELETED THEN
939:
940: ROLLBACK TO update_item_wrap;

Line 942: FND_MSG_PUB.Add;

938: WHEN IEM_RULE_NOT_DELETED THEN
939:
940: ROLLBACK TO update_item_wrap;
941: FND_MESSAGE.SET_NAME('IEM','IEM_RULE_NOT_DELETED');
942: FND_MSG_PUB.Add;
943: x_return_status := FND_API.G_RET_STS_ERROR ;
944:
945: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
946:

Line 945: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

941: FND_MESSAGE.SET_NAME('IEM','IEM_RULE_NOT_DELETED');
942: FND_MSG_PUB.Add;
943: x_return_status := FND_API.G_RET_STS_ERROR ;
944:
945: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
946:
947: WHEN IEM_ROUTE_RULE_NOT_CREATED THEN
948: ROLLBACK TO update_item_wrap;
949: FND_MESSAGE.SET_NAME('IEM','IEM_ROUTE_RULE_NOT_CREATED');

Line 950: FND_MSG_PUB.Add;

946:
947: WHEN IEM_ROUTE_RULE_NOT_CREATED THEN
948: ROLLBACK TO update_item_wrap;
949: FND_MESSAGE.SET_NAME('IEM','IEM_ROUTE_RULE_NOT_CREATED');
950: FND_MSG_PUB.Add;
951: x_return_status := FND_API.G_RET_STS_ERROR ;
952: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
953:
954:

Line 952: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

948: ROLLBACK TO update_item_wrap;
949: FND_MESSAGE.SET_NAME('IEM','IEM_ROUTE_RULE_NOT_CREATED');
950: FND_MSG_PUB.Add;
951: x_return_status := FND_API.G_RET_STS_ERROR ;
952: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
953:
954:
955: WHEN IEM_ADMIN_EMAILPROC_NO_RULE THEN
956: ROLLBACK TO update_item_wrap;

Line 958: FND_MSG_PUB.Add;

954:
955: WHEN IEM_ADMIN_EMAILPROC_NO_RULE THEN
956: ROLLBACK TO update_item_wrap;
957: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_EMAILPROC_NO_RULE');
958: FND_MSG_PUB.Add;
959:
960: x_return_status := FND_API.G_RET_STS_ERROR ;
961: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
962:

Line 961: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

957: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_EMAILPROC_NO_RULE');
958: FND_MSG_PUB.Add;
959:
960: x_return_status := FND_API.G_RET_STS_ERROR ;
961: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
962:
963: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
964: ROLLBACK TO update_item_wrap;
965: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');

Line 966: FND_MSG_PUB.Add;

962:
963: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
964: ROLLBACK TO update_item_wrap;
965: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
966: FND_MSG_PUB.Add;
967:
968: x_return_status := FND_API.G_RET_STS_ERROR ;
969: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
970: WHEN FND_API.G_EXC_ERROR THEN

Line 969: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

965: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
966: FND_MSG_PUB.Add;
967:
968: x_return_status := FND_API.G_RET_STS_ERROR ;
969: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
970: WHEN FND_API.G_EXC_ERROR THEN
971: ROLLBACK TO update_item_wrap;
972: x_return_status := FND_API.G_RET_STS_ERROR ;
973: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);

Line 973: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);

969: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
970: WHEN FND_API.G_EXC_ERROR THEN
971: ROLLBACK TO update_item_wrap;
972: x_return_status := FND_API.G_RET_STS_ERROR ;
973: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
974:
975:
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
977: ROLLBACK TO update_item_wrap;

Line 979: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

975:
976: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
977: ROLLBACK TO update_item_wrap;
978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
979: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
980:
981:
982: WHEN OTHERS THEN
983: ROLLBACK TO update_item_wrap;

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

981:
982: WHEN OTHERS THEN
983: ROLLBACK TO update_item_wrap;
984: x_return_status := FND_API.G_RET_STS_ERROR;
985: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
986: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
987: END IF;
988:
989:

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

982: WHEN OTHERS THEN
983: ROLLBACK TO update_item_wrap;
984: x_return_status := FND_API.G_RET_STS_ERROR;
985: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
986: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
987: END IF;
988:
989:
990: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

Line 990: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

986: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
987: END IF;
988:
989:
990: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
991:
992: END update_emailproc_wrap;
993:
994: PROCEDURE create_emailproc_wrap (

Line 1058: FND_MSG_PUB.initialize;

1054:
1055: -- Initialize message list if p_init_msg_list is set to TRUE.
1056: IF FND_API.to_Boolean( p_init_msg_list )
1057: THEN
1058: FND_MSG_PUB.initialize;
1059: END IF;
1060:
1061: -- Initialize API return status to SUCCESS
1062: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1202: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1198: EXCEPTION
1199: WHEN IEM_EMAILPROC_NOT_CREATED THEN
1200: ROLLBACK TO create_item_wrap;
1201: x_return_status := FND_API.G_RET_STS_ERROR ;
1202: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1203:
1204: WHEN IEM_ADM_AUTOPRC_NO_PARAMETERS THEN
1205: ROLLBACK TO create_item_wrap;
1206: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_AUTOPRC_NO_PARAMETERS');

Line 1207: FND_MSG_PUB.Add;

1203:
1204: WHEN IEM_ADM_AUTOPRC_NO_PARAMETERS THEN
1205: ROLLBACK TO create_item_wrap;
1206: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_AUTOPRC_NO_PARAMETERS');
1207: FND_MSG_PUB.Add;
1208: x_return_status := FND_API.G_RET_STS_ERROR ;
1209: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1210:
1211: WHEN IEM_ADM_INVALID_PROC_NAME THEN

Line 1209: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1205: ROLLBACK TO create_item_wrap;
1206: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_AUTOPRC_NO_PARAMETERS');
1207: FND_MSG_PUB.Add;
1208: x_return_status := FND_API.G_RET_STS_ERROR ;
1209: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1210:
1211: WHEN IEM_ADM_INVALID_PROC_NAME THEN
1212: ROLLBACK TO create_item_wrap;
1213: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_PROC_NAME');

Line 1214: -- FND_MSG_PUB.Add;

1210:
1211: WHEN IEM_ADM_INVALID_PROC_NAME THEN
1212: ROLLBACK TO create_item_wrap;
1213: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_PROC_NAME');
1214: -- FND_MSG_PUB.Add;
1215: x_return_status := FND_API.G_RET_STS_ERROR ;
1216: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1217:
1218: WHEN IEM_EMAILPROC_RULE_NOT_CREATED THEN

Line 1216: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1212: ROLLBACK TO create_item_wrap;
1213: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_PROC_NAME');
1214: -- FND_MSG_PUB.Add;
1215: x_return_status := FND_API.G_RET_STS_ERROR ;
1216: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1217:
1218: WHEN IEM_EMAILPROC_RULE_NOT_CREATED THEN
1219: ROLLBACK TO create_item_wrap;
1220: FND_MESSAGE.SET_NAME('IEM','IEM_EMAILPROC_RULE_NOT_CREATED');

Line 1221: FND_MSG_PUB.Add;

1217:
1218: WHEN IEM_EMAILPROC_RULE_NOT_CREATED THEN
1219: ROLLBACK TO create_item_wrap;
1220: FND_MESSAGE.SET_NAME('IEM','IEM_EMAILPROC_RULE_NOT_CREATED');
1221: FND_MSG_PUB.Add;
1222: x_return_status := FND_API.G_RET_STS_ERROR ;
1223: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1224:
1225: WHEN IEM_ACTION_NOT_CREATED THEN

Line 1223: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1219: ROLLBACK TO create_item_wrap;
1220: FND_MESSAGE.SET_NAME('IEM','IEM_EMAILPROC_RULE_NOT_CREATED');
1221: FND_MSG_PUB.Add;
1222: x_return_status := FND_API.G_RET_STS_ERROR ;
1223: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1224:
1225: WHEN IEM_ACTION_NOT_CREATED THEN
1226: ROLLBACK TO create_item_wrap;
1227: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_NOT_CREATED');

Line 1228: FND_MSG_PUB.Add;

1224:
1225: WHEN IEM_ACTION_NOT_CREATED THEN
1226: ROLLBACK TO create_item_wrap;
1227: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_NOT_CREATED');
1228: FND_MSG_PUB.Add;
1229: x_return_status := FND_API.G_RET_STS_ERROR ;
1230: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1231: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
1232:

Line 1230: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1226: ROLLBACK TO create_item_wrap;
1227: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_NOT_CREATED');
1228: FND_MSG_PUB.Add;
1229: x_return_status := FND_API.G_RET_STS_ERROR ;
1230: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1231: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
1232:
1233: ROLLBACK TO create_item_wrap;
1234: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');

Line 1235: FND_MSG_PUB.Add;

1231: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
1232:
1233: ROLLBACK TO create_item_wrap;
1234: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
1235: FND_MSG_PUB.Add;
1236: x_return_status := FND_API.G_RET_STS_ERROR ;
1237: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1238:
1239: WHEN FND_API.G_EXC_ERROR THEN

Line 1237: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1233: ROLLBACK TO create_item_wrap;
1234: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
1235: FND_MSG_PUB.Add;
1236: x_return_status := FND_API.G_RET_STS_ERROR ;
1237: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1238:
1239: WHEN FND_API.G_EXC_ERROR THEN
1240: ROLLBACK TO create_item_wrap;
1241: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1242: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);

1238:
1239: WHEN FND_API.G_EXC_ERROR THEN
1240: ROLLBACK TO create_item_wrap;
1241: x_return_status := FND_API.G_RET_STS_ERROR ;
1242: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
1243:
1244:
1245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1246:

Line 1249: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1246:
1247: ROLLBACK TO create_item_wrap;
1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1249: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1250:
1251: WHEN OTHERS THEN
1252: ROLLBACK TO create_item_wrap;
1253: x_return_status := FND_API.G_RET_STS_ERROR;

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

1250:
1251: WHEN OTHERS THEN
1252: ROLLBACK TO create_item_wrap;
1253: x_return_status := FND_API.G_RET_STS_ERROR;
1254: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1255: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
1256: END IF;
1257:
1258: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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

1251: WHEN OTHERS THEN
1252: ROLLBACK TO create_item_wrap;
1253: x_return_status := FND_API.G_RET_STS_ERROR;
1254: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1255: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
1256: END IF;
1257:
1258: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1259:

Line 1258: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

1254: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1255: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
1256: END IF;
1257:
1258: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1259:
1260: END create_emailproc_wrap;
1261:
1262:

Line 1308: FND_MSG_PUB.initialize;

1304: -- Initialize message list if p_init_msg_list is set to TRUE.
1305: IF FND_API.to_Boolean( p_init_msg_list )
1306: THEN
1307:
1308: FND_MSG_PUB.initialize;
1309: END IF;
1310:
1311:
1312: -- Initialize API return status to SUCCESS

Line 1366: FND_MSG_PUB.Count_And_Get

1362: IF FND_API.To_Boolean(p_commit) THEN
1363: COMMIT WORK;
1364: END IF;
1365: -- Standard callto get message count and if count is 1, get message info.
1366: FND_MSG_PUB.Count_And_Get
1367: ( p_count => x_msg_count,
1368: p_data => x_msg_data
1369: );
1370:

Line 1377: FND_MSG_PUB.Add;

1373: WHEN IEM_NOT_REDIRECT_SAME_ACCT THEN
1374: ROLLBACK TO create_wrap_account_routes_PVT;
1375: FND_MESSAGE.SET_NAME('IEM','IEM_NOT_REDIRECT_SAME_ACCT');
1376:
1377: FND_MSG_PUB.Add;
1378: x_return_status := FND_API.G_RET_STS_ERROR ;
1379: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1380:
1381: WHEN IEM_ADMIN_ROUTE_NOT_EXIST THEN

Line 1379: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1375: FND_MESSAGE.SET_NAME('IEM','IEM_NOT_REDIRECT_SAME_ACCT');
1376:
1377: FND_MSG_PUB.Add;
1378: x_return_status := FND_API.G_RET_STS_ERROR ;
1379: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1380:
1381: WHEN IEM_ADMIN_ROUTE_NOT_EXIST THEN
1382: ROLLBACK TO create_wrap_account_routes_PVT;
1383: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NOT_EXIST');

Line 1385: FND_MSG_PUB.Add;

1381: WHEN IEM_ADMIN_ROUTE_NOT_EXIST THEN
1382: ROLLBACK TO create_wrap_account_routes_PVT;
1383: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NOT_EXIST');
1384:
1385: FND_MSG_PUB.Add;
1386: x_return_status := FND_API.G_RET_STS_ERROR ;
1387: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1388:
1389:

Line 1387: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1383: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NOT_EXIST');
1384:
1385: FND_MSG_PUB.Add;
1386: x_return_status := FND_API.G_RET_STS_ERROR ;
1387: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1388:
1389:
1390: WHEN IEM_ADMIN_ACCOUNT_NOT_EXIST THEN
1391: ROLLBACK TO create_wrap_account_routes_PVT;

Line 1393: FND_MSG_PUB.Add;

1389:
1390: WHEN IEM_ADMIN_ACCOUNT_NOT_EXIST THEN
1391: ROLLBACK TO create_wrap_account_routes_PVT;
1392: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ACCOUNT_NOT_EXIST');
1393: FND_MSG_PUB.Add;
1394:
1395: x_return_status := FND_API.G_RET_STS_ERROR ;
1396: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1397:

Line 1396: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1392: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ACCOUNT_NOT_EXIST');
1393: FND_MSG_PUB.Add;
1394:
1395: x_return_status := FND_API.G_RET_STS_ERROR ;
1396: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1397:
1398: WHEN IEM_ACCOUNT_ROUTE_NOT_UPDATED THEN
1399:
1400: ROLLBACK TO create_wrap_account_routes_PVT;

Line 1402: FND_MSG_PUB.Add;

1398: WHEN IEM_ACCOUNT_ROUTE_NOT_UPDATED THEN
1399:
1400: ROLLBACK TO create_wrap_account_routes_PVT;
1401: FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_ROUTE_NOT_UPDATED');
1402: FND_MSG_PUB.Add;
1403: x_return_status := FND_API.G_RET_STS_ERROR ;
1404: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1405:
1406: WHEN FND_API.G_EXC_ERROR THEN

Line 1404: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1400: ROLLBACK TO create_wrap_account_routes_PVT;
1401: FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_ROUTE_NOT_UPDATED');
1402: FND_MSG_PUB.Add;
1403: x_return_status := FND_API.G_RET_STS_ERROR ;
1404: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1405:
1406: WHEN FND_API.G_EXC_ERROR THEN
1407: ROLLBACK TO create_wrap_account_routes_PVT;
1408: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1410: FND_MSG_PUB.Count_And_Get

1406: WHEN FND_API.G_EXC_ERROR THEN
1407: ROLLBACK TO create_wrap_account_routes_PVT;
1408: x_return_status := FND_API.G_RET_STS_ERROR ;
1409:
1410: FND_MSG_PUB.Count_And_Get
1411: ( p_count => x_msg_count,
1412: p_data => x_msg_data
1413:
1414: );

Line 1419: FND_MSG_PUB.Count_And_Get

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

Line 1429: IF FND_MSG_PUB.Check_Msg_Level

1425: WHEN OTHERS THEN
1426: ROLLBACK TO create_wrap_account_routes_PVT;
1427:
1428: x_return_status := FND_API.G_RET_STS_ERROR;
1429: IF FND_MSG_PUB.Check_Msg_Level
1430: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1431: THEN
1432: FND_MSG_PUB.Add_Exc_Msg
1433: ( G_PKG_NAME,

Line 1430: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1426: ROLLBACK TO create_wrap_account_routes_PVT;
1427:
1428: x_return_status := FND_API.G_RET_STS_ERROR;
1429: IF FND_MSG_PUB.Check_Msg_Level
1430: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1431: THEN
1432: FND_MSG_PUB.Add_Exc_Msg
1433: ( G_PKG_NAME,
1434: l_api_name

Line 1432: FND_MSG_PUB.Add_Exc_Msg

1428: x_return_status := FND_API.G_RET_STS_ERROR;
1429: IF FND_MSG_PUB.Check_Msg_Level
1430: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1431: THEN
1432: FND_MSG_PUB.Add_Exc_Msg
1433: ( G_PKG_NAME,
1434: l_api_name
1435: );
1436: END IF;

Line 1437: FND_MSG_PUB.Count_And_Get

1433: ( G_PKG_NAME,
1434: l_api_name
1435: );
1436: END IF;
1437: FND_MSG_PUB.Count_And_Get
1438: ( p_count => x_msg_count,
1439:
1440: p_data => x_msg_data
1441:

Line 1485: FND_MSG_PUB.initialize;

1481: -- Initialize message list if p_init_msg_list is set to TRUE.
1482: IF FND_API.to_Boolean( p_init_msg_list )
1483: THEN
1484:
1485: FND_MSG_PUB.initialize;
1486: END IF;
1487: -- Initialize API return status to SUCCESS
1488: x_return_status := FND_API.G_RET_STS_SUCCESS;
1489:

Line 1536: FND_MSG_PUB.Count_And_Get

1532: COMMIT WORK;
1533: END IF;
1534:
1535: -- Standard callto get message count and if count is 1, get message info.
1536: FND_MSG_PUB.Count_And_Get
1537:
1538: ( p_count => x_msg_count,
1539: p_data => x_msg_data
1540: );

Line 1547: FND_MSG_PUB.Add;

1543:
1544: WHEN IEM_ACCT_EMAILPROC_NOT_UPDATED THEN
1545: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1546: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_EMAILPROC_NOT_UPDATED');
1547: FND_MSG_PUB.Add;
1548: x_return_status := FND_API.G_RET_STS_ERROR ;
1549:
1550: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1551:

Line 1550: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1546: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_EMAILPROC_NOT_UPDATED');
1547: FND_MSG_PUB.Add;
1548: x_return_status := FND_API.G_RET_STS_ERROR ;
1549:
1550: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1551:
1552: WHEN IEM_ACCT_EMAILPROC_NOT_DELETED THEN
1553: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1554: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_EMAILPROC_NOT_DELETED');

Line 1555: FND_MSG_PUB.Add;

1551:
1552: WHEN IEM_ACCT_EMAILPROC_NOT_DELETED THEN
1553: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1554: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_EMAILPROC_NOT_DELETED');
1555: FND_MSG_PUB.Add;
1556: x_return_status := FND_API.G_RET_STS_ERROR ;
1557: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1558:
1559: WHEN FND_API.G_EXC_ERROR THEN

Line 1557: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1553: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1554: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_EMAILPROC_NOT_DELETED');
1555: FND_MSG_PUB.Add;
1556: x_return_status := FND_API.G_RET_STS_ERROR ;
1557: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1558:
1559: WHEN FND_API.G_EXC_ERROR THEN
1560: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1561: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1562: FND_MSG_PUB.Count_And_Get

1558:
1559: WHEN FND_API.G_EXC_ERROR THEN
1560: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1561: x_return_status := FND_API.G_RET_STS_ERROR ;
1562: FND_MSG_PUB.Count_And_Get
1563: ( p_count => x_msg_count,
1564: p_data => x_msg_data
1565: );
1566:

Line 1570: FND_MSG_PUB.Count_And_Get

1566:
1567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1568: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1570: FND_MSG_PUB.Count_And_Get
1571: ( p_count => x_msg_count,
1572: p_data => x_msg_data
1573: );
1574:

Line 1579: IF FND_MSG_PUB.Check_Msg_Level

1575: WHEN OTHERS THEN
1576: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1577: x_return_status := FND_API.G_RET_STS_ERROR;
1578:
1579: IF FND_MSG_PUB.Check_Msg_Level
1580: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1581: THEN
1582: FND_MSG_PUB.Add_Exc_Msg
1583: ( G_PKG_NAME,

Line 1580: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1576: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1577: x_return_status := FND_API.G_RET_STS_ERROR;
1578:
1579: IF FND_MSG_PUB.Check_Msg_Level
1580: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1581: THEN
1582: FND_MSG_PUB.Add_Exc_Msg
1583: ( G_PKG_NAME,
1584: l_api_name

Line 1582: FND_MSG_PUB.Add_Exc_Msg

1578:
1579: IF FND_MSG_PUB.Check_Msg_Level
1580: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1581: THEN
1582: FND_MSG_PUB.Add_Exc_Msg
1583: ( G_PKG_NAME,
1584: l_api_name
1585: );
1586: END IF;

Line 1587: FND_MSG_PUB.Count_And_Get

1583: ( G_PKG_NAME,
1584: l_api_name
1585: );
1586: END IF;
1587: FND_MSG_PUB.Count_And_Get
1588: ( p_count => x_msg_count,
1589: p_data => x_msg_data
1590: );
1591: END update_wrap_account_emailprocs;

Line 1633: FND_MSG_PUB.initialize;

1629: END IF;
1630:
1631: --Initialize the message list if p_init_msg_list is set to TRUE
1632: If FND_API.to_Boolean(p_init_msg_list) THEN
1633: FND_MSG_PUB.initialize;
1634: END IF;
1635:
1636: --Initialize API status return
1637: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1699: FND_MSG_PUB.ADD;

1695: ROLLBACK TO delete_item_batch;
1696: x_return_status := FND_API.G_RET_STS_ERROR;
1697: FND_MESSAGE.SET_NAME('IEM', 'IEM_ROUTE_NOT_DELETED');
1698:
1699: FND_MSG_PUB.ADD;
1700: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1701:
1702: WHEN FND_API.G_EXC_ERROR THEN
1703: ROLLBACK TO delete_item_batch;

Line 1700: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1696: x_return_status := FND_API.G_RET_STS_ERROR;
1697: FND_MESSAGE.SET_NAME('IEM', 'IEM_ROUTE_NOT_DELETED');
1698:
1699: FND_MSG_PUB.ADD;
1700: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1701:
1702: WHEN FND_API.G_EXC_ERROR THEN
1703: ROLLBACK TO delete_item_batch;
1704: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1705: FND_MSG_PUB.Count_And_Get

1701:
1702: WHEN FND_API.G_EXC_ERROR THEN
1703: ROLLBACK TO delete_item_batch;
1704: x_return_status := FND_API.G_RET_STS_ERROR ;
1705: FND_MSG_PUB.Count_And_Get
1706: ( p_count => x_msg_count,p_data => x_msg_data);
1707:
1708:
1709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1712: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);

1708:
1709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1710: ROLLBACK TO delete_item_batch;
1711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1712: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1713:
1714:
1715: WHEN OTHERS THEN
1716: ROLLBACK TO delete_item_batch;

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

1714:
1715: WHEN OTHERS THEN
1716: ROLLBACK TO delete_item_batch;
1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1719: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1720: END IF;
1721:
1722: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

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

1715: WHEN OTHERS THEN
1716: ROLLBACK TO delete_item_batch;
1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1719: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1720: END IF;
1721:
1722: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
1723:

Line 1722: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

1718: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1719: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1720: END IF;
1721:
1722: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
1723:
1724: END delete_item_emailproc;
1725:
1726:

Line 1758: FND_MSG_PUB.initialize;

1754:
1755:
1756: --Initialize the message list if p_init_msg_list is set to TRUE
1757: If FND_API.to_Boolean(p_init_msg_list) THEN
1758: FND_MSG_PUB.initialize;
1759: END IF;
1760:
1761: --Initialize API status return
1762: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1775: FND_MSG_PUB.Count_And_Get

1771: IF FND_API.to_Boolean(p_commit) THEN
1772: COMMIT WORK;
1773: END IF;
1774:
1775: FND_MSG_PUB.Count_And_Get
1776: ( p_count => x_msg_count,p_data => x_msg_data);
1777:
1778: EXCEPTION
1779: WHEN FND_API.G_EXC_ERROR THEN

Line 1782: FND_MSG_PUB.Count_And_Get

1778: EXCEPTION
1779: WHEN FND_API.G_EXC_ERROR THEN
1780: ROLLBACK TO delete_acct_emailproc_by_acct;
1781: x_return_status := FND_API.G_RET_STS_ERROR ;
1782: FND_MSG_PUB.Count_And_Get
1783:
1784: ( p_count => x_msg_count,p_data => x_msg_data);
1785:
1786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1789: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);

1785:
1786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1787: ROLLBACK TO delete_acct_emailproc_by_acct;
1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1789: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1790:
1791:
1792: WHEN OTHERS THEN
1793: ROLLBACK TO delete_acct_emailproc_by_acct;

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

1791:
1792: WHEN OTHERS THEN
1793: ROLLBACK TO delete_acct_emailproc_by_acct;
1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1796: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1797:
1798: END IF;
1799: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

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

1792: WHEN OTHERS THEN
1793: ROLLBACK TO delete_acct_emailproc_by_acct;
1794: x_return_status := FND_API.G_RET_STS_ERROR;
1795: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1796: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1797:
1798: END IF;
1799: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
1800:

Line 1799: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

1795: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1796: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1797:
1798: END IF;
1799: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
1800:
1801: END delete_acct_emailproc_by_acct;
1802:
1803: END IEM_EMAILPROC_PVT; -- Package Body IEM_EMAILPROC_PVT