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 694: FND_MSG_PUB.initialize;

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

Line 913: -- FND_MSG_PUB.Add;

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

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

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

Line 921: FND_MSG_PUB.Add;

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

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

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

Line 929: FND_MSG_PUB.Add;

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

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

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

Line 937: -- FND_MSG_PUB.Add;

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

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

935: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_PROC_NAME');
936:
937: -- FND_MSG_PUB.Add;
938: x_return_status := FND_API.G_RET_STS_ERROR ;
939: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
940:
941: WHEN IEM_NO_ROUTE_UPDATE THEN
942: ROLLBACK TO update_item_wrap;
943: FND_MESSAGE.SET_NAME('IEM','IEM_NO_ROUTE_UPDATE');

Line 945: FND_MSG_PUB.Add;

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

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

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

Line 951: FND_MSG_PUB.Add;

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

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

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

Line 959: FND_MSG_PUB.Add;

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

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

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

Line 967: FND_MSG_PUB.Add;

963:
964: WHEN IEM_ROUTE_RULE_NOT_CREATED THEN
965: ROLLBACK TO update_item_wrap;
966: FND_MESSAGE.SET_NAME('IEM','IEM_ROUTE_RULE_NOT_CREATED');
967: FND_MSG_PUB.Add;
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:
971:

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

965: ROLLBACK TO update_item_wrap;
966: FND_MESSAGE.SET_NAME('IEM','IEM_ROUTE_RULE_NOT_CREATED');
967: FND_MSG_PUB.Add;
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:
971:
972: WHEN IEM_ADMIN_EMAILPROC_NO_RULE THEN
973: ROLLBACK TO update_item_wrap;

Line 975: FND_MSG_PUB.Add;

971:
972: WHEN IEM_ADMIN_EMAILPROC_NO_RULE THEN
973: ROLLBACK TO update_item_wrap;
974: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_EMAILPROC_NO_RULE');
975: FND_MSG_PUB.Add;
976:
977: x_return_status := FND_API.G_RET_STS_ERROR ;
978: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
979:

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

974: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_EMAILPROC_NO_RULE');
975: FND_MSG_PUB.Add;
976:
977: x_return_status := FND_API.G_RET_STS_ERROR ;
978: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
979:
980: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
981: ROLLBACK TO update_item_wrap;
982: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');

Line 983: FND_MSG_PUB.Add;

979:
980: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
981: ROLLBACK TO update_item_wrap;
982: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
983: FND_MSG_PUB.Add;
984:
985: x_return_status := FND_API.G_RET_STS_ERROR ;
986: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
987: WHEN FND_API.G_EXC_ERROR THEN

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

982: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
983: FND_MSG_PUB.Add;
984:
985: x_return_status := FND_API.G_RET_STS_ERROR ;
986: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
987: WHEN FND_API.G_EXC_ERROR THEN
988: ROLLBACK TO update_item_wrap;
989: x_return_status := FND_API.G_RET_STS_ERROR ;
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.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
987: WHEN FND_API.G_EXC_ERROR THEN
988: ROLLBACK TO update_item_wrap;
989: x_return_status := FND_API.G_RET_STS_ERROR ;
990: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
991:
992:
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994: ROLLBACK TO update_item_wrap;

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

992:
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994: ROLLBACK TO update_item_wrap;
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
996: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
997:
998:
999: WHEN OTHERS THEN
1000: ROLLBACK TO update_item_wrap;

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

998:
999: WHEN OTHERS THEN
1000: ROLLBACK TO update_item_wrap;
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1003: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
1004: END IF;
1005:
1006:

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

999: WHEN OTHERS THEN
1000: ROLLBACK TO update_item_wrap;
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1003: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
1004: END IF;
1005:
1006:
1007: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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

1003: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
1004: END IF;
1005:
1006:
1007: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1008:
1009: END update_emailproc_wrap;
1010:
1011: PROCEDURE create_emailproc_wrap (

Line 1078: FND_MSG_PUB.initialize;

1074:
1075: -- Initialize message list if p_init_msg_list is set to TRUE.
1076: IF FND_API.to_Boolean( p_init_msg_list )
1077: THEN
1078: FND_MSG_PUB.initialize;
1079: END IF;
1080:
1081: -- Initialize API return status to SUCCESS
1082: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

Line 1240: FND_MSG_PUB.Add;

1236:
1237: WHEN IEM_ADM_AUTOPRC_NO_PARAMETERS THEN
1238: ROLLBACK TO create_item_wrap;
1239: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_AUTOPRC_NO_PARAMETERS');
1240: FND_MSG_PUB.Add;
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: WHEN IEM_ADM_INVALID_PROC_NAME THEN

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

1238: ROLLBACK TO create_item_wrap;
1239: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_AUTOPRC_NO_PARAMETERS');
1240: FND_MSG_PUB.Add;
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: WHEN IEM_ADM_INVALID_PROC_NAME THEN
1245: ROLLBACK TO create_item_wrap;
1246: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_PROC_NAME');

Line 1247: -- FND_MSG_PUB.Add;

1243:
1244: WHEN IEM_ADM_INVALID_PROC_NAME THEN
1245: ROLLBACK TO create_item_wrap;
1246: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_PROC_NAME');
1247: -- FND_MSG_PUB.Add;
1248: x_return_status := FND_API.G_RET_STS_ERROR ;
1249: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1250:
1251: WHEN IEM_EMAILPROC_RULE_NOT_CREATED THEN

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

1245: ROLLBACK TO create_item_wrap;
1246: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_PROC_NAME');
1247: -- FND_MSG_PUB.Add;
1248: x_return_status := FND_API.G_RET_STS_ERROR ;
1249: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1250:
1251: WHEN IEM_EMAILPROC_RULE_NOT_CREATED THEN
1252: ROLLBACK TO create_item_wrap;
1253: FND_MESSAGE.SET_NAME('IEM','IEM_EMAILPROC_RULE_NOT_CREATED');

Line 1254: FND_MSG_PUB.Add;

1250:
1251: WHEN IEM_EMAILPROC_RULE_NOT_CREATED THEN
1252: ROLLBACK TO create_item_wrap;
1253: FND_MESSAGE.SET_NAME('IEM','IEM_EMAILPROC_RULE_NOT_CREATED');
1254: FND_MSG_PUB.Add;
1255: x_return_status := FND_API.G_RET_STS_ERROR ;
1256: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1257:
1258: WHEN IEM_ACTION_NOT_CREATED THEN

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

1252: ROLLBACK TO create_item_wrap;
1253: FND_MESSAGE.SET_NAME('IEM','IEM_EMAILPROC_RULE_NOT_CREATED');
1254: FND_MSG_PUB.Add;
1255: x_return_status := FND_API.G_RET_STS_ERROR ;
1256: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1257:
1258: WHEN IEM_ACTION_NOT_CREATED THEN
1259: ROLLBACK TO create_item_wrap;
1260: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_NOT_CREATED');

Line 1261: FND_MSG_PUB.Add;

1257:
1258: WHEN IEM_ACTION_NOT_CREATED THEN
1259: ROLLBACK TO create_item_wrap;
1260: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_NOT_CREATED');
1261: FND_MSG_PUB.Add;
1262: x_return_status := FND_API.G_RET_STS_ERROR ;
1263: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1264: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
1265:

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

1259: ROLLBACK TO create_item_wrap;
1260: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_NOT_CREATED');
1261: FND_MSG_PUB.Add;
1262: x_return_status := FND_API.G_RET_STS_ERROR ;
1263: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1264: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
1265:
1266: ROLLBACK TO create_item_wrap;
1267: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');

Line 1268: FND_MSG_PUB.Add;

1264: WHEN IEM_ACTION_DTLS_NOT_CREATE THEN
1265:
1266: ROLLBACK TO create_item_wrap;
1267: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
1268: FND_MSG_PUB.Add;
1269: x_return_status := FND_API.G_RET_STS_ERROR ;
1270: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1271:
1272: WHEN FND_API.G_EXC_ERROR THEN

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

1266: ROLLBACK TO create_item_wrap;
1267: FND_MESSAGE.SET_NAME('IEM','IEM_ACTION_DTLS_NOT_CREATE');
1268: FND_MSG_PUB.Add;
1269: x_return_status := FND_API.G_RET_STS_ERROR ;
1270: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1271:
1272: WHEN FND_API.G_EXC_ERROR THEN
1273: ROLLBACK TO create_item_wrap;
1274: x_return_status := FND_API.G_RET_STS_ERROR ;

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

1271:
1272: WHEN FND_API.G_EXC_ERROR THEN
1273: ROLLBACK TO create_item_wrap;
1274: x_return_status := FND_API.G_RET_STS_ERROR ;
1275: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
1276:
1277:
1278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1279:

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

1278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1279:
1280: ROLLBACK TO create_item_wrap;
1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1282: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1283:
1284: WHEN OTHERS THEN
1285: ROLLBACK TO create_item_wrap;
1286: x_return_status := FND_API.G_RET_STS_ERROR;

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

1283:
1284: WHEN OTHERS THEN
1285: ROLLBACK TO create_item_wrap;
1286: x_return_status := FND_API.G_RET_STS_ERROR;
1287: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1288: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
1289: END IF;
1290:
1291: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );

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

1284: WHEN OTHERS THEN
1285: ROLLBACK TO create_item_wrap;
1286: x_return_status := FND_API.G_RET_STS_ERROR;
1287: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1288: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
1289: END IF;
1290:
1291: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1292:

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

1287: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1288: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
1289: END IF;
1290:
1291: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
1292:
1293: END create_emailproc_wrap;
1294:
1295:

Line 1341: FND_MSG_PUB.initialize;

1337: -- Initialize message list if p_init_msg_list is set to TRUE.
1338: IF FND_API.to_Boolean( p_init_msg_list )
1339: THEN
1340:
1341: FND_MSG_PUB.initialize;
1342: END IF;
1343:
1344:
1345: -- Initialize API return status to SUCCESS

Line 1399: FND_MSG_PUB.Count_And_Get

1395: IF FND_API.To_Boolean(p_commit) THEN
1396: COMMIT WORK;
1397: END IF;
1398: -- Standard callto get message count and if count is 1, get message info.
1399: FND_MSG_PUB.Count_And_Get
1400: ( p_count => x_msg_count,
1401: p_data => x_msg_data
1402: );
1403:

Line 1410: FND_MSG_PUB.Add;

1406: WHEN IEM_NOT_REDIRECT_SAME_ACCT THEN
1407: ROLLBACK TO create_wrap_account_routes_PVT;
1408: FND_MESSAGE.SET_NAME('IEM','IEM_NOT_REDIRECT_SAME_ACCT');
1409:
1410: FND_MSG_PUB.Add;
1411: x_return_status := FND_API.G_RET_STS_ERROR ;
1412: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1413:
1414: WHEN IEM_ADMIN_ROUTE_NOT_EXIST THEN

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

1408: FND_MESSAGE.SET_NAME('IEM','IEM_NOT_REDIRECT_SAME_ACCT');
1409:
1410: FND_MSG_PUB.Add;
1411: x_return_status := FND_API.G_RET_STS_ERROR ;
1412: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1413:
1414: WHEN IEM_ADMIN_ROUTE_NOT_EXIST THEN
1415: ROLLBACK TO create_wrap_account_routes_PVT;
1416: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NOT_EXIST');

Line 1418: FND_MSG_PUB.Add;

1414: WHEN IEM_ADMIN_ROUTE_NOT_EXIST THEN
1415: ROLLBACK TO create_wrap_account_routes_PVT;
1416: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NOT_EXIST');
1417:
1418: FND_MSG_PUB.Add;
1419: x_return_status := FND_API.G_RET_STS_ERROR ;
1420: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1421:
1422:

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

1416: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NOT_EXIST');
1417:
1418: FND_MSG_PUB.Add;
1419: x_return_status := FND_API.G_RET_STS_ERROR ;
1420: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1421:
1422:
1423: WHEN IEM_ADMIN_ACCOUNT_NOT_EXIST THEN
1424: ROLLBACK TO create_wrap_account_routes_PVT;

Line 1426: FND_MSG_PUB.Add;

1422:
1423: WHEN IEM_ADMIN_ACCOUNT_NOT_EXIST THEN
1424: ROLLBACK TO create_wrap_account_routes_PVT;
1425: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ACCOUNT_NOT_EXIST');
1426: FND_MSG_PUB.Add;
1427:
1428: x_return_status := FND_API.G_RET_STS_ERROR ;
1429: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1430:

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

1425: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ACCOUNT_NOT_EXIST');
1426: FND_MSG_PUB.Add;
1427:
1428: x_return_status := FND_API.G_RET_STS_ERROR ;
1429: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1430:
1431: WHEN IEM_ACCOUNT_ROUTE_NOT_UPDATED THEN
1432:
1433: ROLLBACK TO create_wrap_account_routes_PVT;

Line 1435: FND_MSG_PUB.Add;

1431: WHEN IEM_ACCOUNT_ROUTE_NOT_UPDATED THEN
1432:
1433: ROLLBACK TO create_wrap_account_routes_PVT;
1434: FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_ROUTE_NOT_UPDATED');
1435: FND_MSG_PUB.Add;
1436: x_return_status := FND_API.G_RET_STS_ERROR ;
1437: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1438:
1439: WHEN FND_API.G_EXC_ERROR THEN

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

1433: ROLLBACK TO create_wrap_account_routes_PVT;
1434: FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_ROUTE_NOT_UPDATED');
1435: FND_MSG_PUB.Add;
1436: x_return_status := FND_API.G_RET_STS_ERROR ;
1437: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1438:
1439: WHEN FND_API.G_EXC_ERROR THEN
1440: ROLLBACK TO create_wrap_account_routes_PVT;
1441: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1443: FND_MSG_PUB.Count_And_Get

1439: WHEN FND_API.G_EXC_ERROR THEN
1440: ROLLBACK TO create_wrap_account_routes_PVT;
1441: x_return_status := FND_API.G_RET_STS_ERROR ;
1442:
1443: FND_MSG_PUB.Count_And_Get
1444: ( p_count => x_msg_count,
1445: p_data => x_msg_data
1446:
1447: );

Line 1452: FND_MSG_PUB.Count_And_Get

1448:
1449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1450: ROLLBACK TO create_wrap_account_routes_PVT;
1451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1452: FND_MSG_PUB.Count_And_Get
1453: ( p_count => x_msg_count,
1454: p_data => x_msg_data
1455: );
1456:

Line 1462: IF FND_MSG_PUB.Check_Msg_Level

1458: WHEN OTHERS THEN
1459: ROLLBACK TO create_wrap_account_routes_PVT;
1460:
1461: x_return_status := FND_API.G_RET_STS_ERROR;
1462: IF FND_MSG_PUB.Check_Msg_Level
1463: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1464: THEN
1465: FND_MSG_PUB.Add_Exc_Msg
1466: ( G_PKG_NAME,

Line 1463: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1459: ROLLBACK TO create_wrap_account_routes_PVT;
1460:
1461: x_return_status := FND_API.G_RET_STS_ERROR;
1462: IF FND_MSG_PUB.Check_Msg_Level
1463: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1464: THEN
1465: FND_MSG_PUB.Add_Exc_Msg
1466: ( G_PKG_NAME,
1467: l_api_name

Line 1465: FND_MSG_PUB.Add_Exc_Msg

1461: x_return_status := FND_API.G_RET_STS_ERROR;
1462: IF FND_MSG_PUB.Check_Msg_Level
1463: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1464: THEN
1465: FND_MSG_PUB.Add_Exc_Msg
1466: ( G_PKG_NAME,
1467: l_api_name
1468: );
1469: END IF;

Line 1470: FND_MSG_PUB.Count_And_Get

1466: ( G_PKG_NAME,
1467: l_api_name
1468: );
1469: END IF;
1470: FND_MSG_PUB.Count_And_Get
1471: ( p_count => x_msg_count,
1472:
1473: p_data => x_msg_data
1474:

Line 1518: FND_MSG_PUB.initialize;

1514: -- Initialize message list if p_init_msg_list is set to TRUE.
1515: IF FND_API.to_Boolean( p_init_msg_list )
1516: THEN
1517:
1518: FND_MSG_PUB.initialize;
1519: END IF;
1520: -- Initialize API return status to SUCCESS
1521: x_return_status := FND_API.G_RET_STS_SUCCESS;
1522:

Line 1569: FND_MSG_PUB.Count_And_Get

1565: COMMIT WORK;
1566: END IF;
1567:
1568: -- Standard callto get message count and if count is 1, get message info.
1569: FND_MSG_PUB.Count_And_Get
1570:
1571: ( p_count => x_msg_count,
1572: p_data => x_msg_data
1573: );

Line 1580: FND_MSG_PUB.Add;

1576:
1577: WHEN IEM_ACCT_EMAILPROC_NOT_UPDATED THEN
1578: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1579: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_EMAILPROC_NOT_UPDATED');
1580: FND_MSG_PUB.Add;
1581: x_return_status := FND_API.G_RET_STS_ERROR ;
1582:
1583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1584:

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

1579: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_EMAILPROC_NOT_UPDATED');
1580: FND_MSG_PUB.Add;
1581: x_return_status := FND_API.G_RET_STS_ERROR ;
1582:
1583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1584:
1585: WHEN IEM_ACCT_EMAILPROC_NOT_DELETED THEN
1586: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1587: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_EMAILPROC_NOT_DELETED');

Line 1588: FND_MSG_PUB.Add;

1584:
1585: WHEN IEM_ACCT_EMAILPROC_NOT_DELETED THEN
1586: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1587: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_EMAILPROC_NOT_DELETED');
1588: FND_MSG_PUB.Add;
1589: x_return_status := FND_API.G_RET_STS_ERROR ;
1590: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1591:
1592: WHEN FND_API.G_EXC_ERROR THEN

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

1586: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1587: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_EMAILPROC_NOT_DELETED');
1588: FND_MSG_PUB.Add;
1589: x_return_status := FND_API.G_RET_STS_ERROR ;
1590: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1591:
1592: WHEN FND_API.G_EXC_ERROR THEN
1593: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1594: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1595: FND_MSG_PUB.Count_And_Get

1591:
1592: WHEN FND_API.G_EXC_ERROR THEN
1593: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1594: x_return_status := FND_API.G_RET_STS_ERROR ;
1595: FND_MSG_PUB.Count_And_Get
1596: ( p_count => x_msg_count,
1597: p_data => x_msg_data
1598: );
1599:

Line 1603: FND_MSG_PUB.Count_And_Get

1599:
1600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1601: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1603: FND_MSG_PUB.Count_And_Get
1604: ( p_count => x_msg_count,
1605: p_data => x_msg_data
1606: );
1607:

Line 1612: IF FND_MSG_PUB.Check_Msg_Level

1608: WHEN OTHERS THEN
1609: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1610: x_return_status := FND_API.G_RET_STS_ERROR;
1611:
1612: IF FND_MSG_PUB.Check_Msg_Level
1613: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1614: THEN
1615: FND_MSG_PUB.Add_Exc_Msg
1616: ( G_PKG_NAME,

Line 1613: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1609: ROLLBACK TO update_wrap_acct_emailproc_PVT;
1610: x_return_status := FND_API.G_RET_STS_ERROR;
1611:
1612: IF FND_MSG_PUB.Check_Msg_Level
1613: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1614: THEN
1615: FND_MSG_PUB.Add_Exc_Msg
1616: ( G_PKG_NAME,
1617: l_api_name

Line 1615: FND_MSG_PUB.Add_Exc_Msg

1611:
1612: IF FND_MSG_PUB.Check_Msg_Level
1613: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1614: THEN
1615: FND_MSG_PUB.Add_Exc_Msg
1616: ( G_PKG_NAME,
1617: l_api_name
1618: );
1619: END IF;

Line 1620: FND_MSG_PUB.Count_And_Get

1616: ( G_PKG_NAME,
1617: l_api_name
1618: );
1619: END IF;
1620: FND_MSG_PUB.Count_And_Get
1621: ( p_count => x_msg_count,
1622: p_data => x_msg_data
1623: );
1624: END update_wrap_account_emailprocs;

Line 1666: FND_MSG_PUB.initialize;

1662: END IF;
1663:
1664: --Initialize the message list if p_init_msg_list is set to TRUE
1665: If FND_API.to_Boolean(p_init_msg_list) THEN
1666: FND_MSG_PUB.initialize;
1667: END IF;
1668:
1669: --Initialize API status return
1670: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1732: FND_MSG_PUB.ADD;

1728: ROLLBACK TO delete_item_batch;
1729: x_return_status := FND_API.G_RET_STS_ERROR;
1730: FND_MESSAGE.SET_NAME('IEM', 'IEM_ROUTE_NOT_DELETED');
1731:
1732: FND_MSG_PUB.ADD;
1733: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1734:
1735: WHEN FND_API.G_EXC_ERROR THEN
1736: ROLLBACK TO delete_item_batch;

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

1729: x_return_status := FND_API.G_RET_STS_ERROR;
1730: FND_MESSAGE.SET_NAME('IEM', 'IEM_ROUTE_NOT_DELETED');
1731:
1732: FND_MSG_PUB.ADD;
1733: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1734:
1735: WHEN FND_API.G_EXC_ERROR THEN
1736: ROLLBACK TO delete_item_batch;
1737: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1738: FND_MSG_PUB.Count_And_Get

1734:
1735: WHEN FND_API.G_EXC_ERROR THEN
1736: ROLLBACK TO delete_item_batch;
1737: x_return_status := FND_API.G_RET_STS_ERROR ;
1738: FND_MSG_PUB.Count_And_Get
1739: ( p_count => x_msg_count,p_data => x_msg_data);
1740:
1741:
1742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1741:
1742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1743: ROLLBACK TO delete_item_batch;
1744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1745: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1746:
1747:
1748: WHEN OTHERS THEN
1749: ROLLBACK TO delete_item_batch;

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

1747:
1748: WHEN OTHERS THEN
1749: ROLLBACK TO delete_item_batch;
1750: x_return_status := FND_API.G_RET_STS_ERROR;
1751: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1752: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1753: END IF;
1754:
1755: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

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

1748: WHEN OTHERS THEN
1749: ROLLBACK TO delete_item_batch;
1750: x_return_status := FND_API.G_RET_STS_ERROR;
1751: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1752: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1753: END IF;
1754:
1755: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
1756:

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

1751: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1752: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1753: END IF;
1754:
1755: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
1756:
1757: END delete_item_emailproc;
1758:
1759:

Line 1791: FND_MSG_PUB.initialize;

1787:
1788:
1789: --Initialize the message list if p_init_msg_list is set to TRUE
1790: If FND_API.to_Boolean(p_init_msg_list) THEN
1791: FND_MSG_PUB.initialize;
1792: END IF;
1793:
1794: --Initialize API status return
1795: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1808: FND_MSG_PUB.Count_And_Get

1804: IF FND_API.to_Boolean(p_commit) THEN
1805: COMMIT WORK;
1806: END IF;
1807:
1808: FND_MSG_PUB.Count_And_Get
1809: ( p_count => x_msg_count,p_data => x_msg_data);
1810:
1811: EXCEPTION
1812: WHEN FND_API.G_EXC_ERROR THEN

Line 1815: FND_MSG_PUB.Count_And_Get

1811: EXCEPTION
1812: WHEN FND_API.G_EXC_ERROR THEN
1813: ROLLBACK TO delete_acct_emailproc_by_acct;
1814: x_return_status := FND_API.G_RET_STS_ERROR ;
1815: FND_MSG_PUB.Count_And_Get
1816:
1817: ( p_count => x_msg_count,p_data => x_msg_data);
1818:
1819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1818:
1819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1820: ROLLBACK TO delete_acct_emailproc_by_acct;
1821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1822: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1823:
1824:
1825: WHEN OTHERS THEN
1826: ROLLBACK TO delete_acct_emailproc_by_acct;

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

1824:
1825: WHEN OTHERS THEN
1826: ROLLBACK TO delete_acct_emailproc_by_acct;
1827: x_return_status := FND_API.G_RET_STS_ERROR;
1828: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1829: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1830:
1831: END IF;
1832: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

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

1825: WHEN OTHERS THEN
1826: ROLLBACK TO delete_acct_emailproc_by_acct;
1827: x_return_status := FND_API.G_RET_STS_ERROR;
1828: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1829: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1830:
1831: END IF;
1832: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
1833:

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

1828: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1829: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1830:
1831: END IF;
1832: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
1833:
1834: END delete_acct_emailproc_by_acct;
1835:
1836: END IEM_EMAILPROC_PVT; -- Package Body IEM_EMAILPROC_PVT