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

Line 87: FND_MSG_PUB.ADD;

83: END IF;
84: END IF;
85: END IF;
86: END IF;
87: FND_MSG_PUB.ADD;
88: l_error_message := SUBSTR(FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg(), FND_API.g_false), 1, 2000) ;
89: END IF;
90: l_debug_info := 'Error Mesage: '||l_error_message;
91: INL_LOGGING_PVT.Log_Statement(

Line 88: l_error_message := SUBSTR(FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg(), FND_API.g_false), 1, 2000) ;

84: END IF;
85: END IF;
86: END IF;
87: FND_MSG_PUB.ADD;
88: l_error_message := SUBSTR(FND_MSG_PUB.get(FND_MSG_PUB.Count_Msg(), FND_API.g_false), 1, 2000) ;
89: END IF;
90: l_debug_info := 'Error Mesage: '||l_error_message;
91: INL_LOGGING_PVT.Log_Statement(
92: p_module_name => g_module_name,

Line 270: IF FND_MSG_PUB.Check_Msg_Level(

266: p_module_name => g_module_name,
267: p_procedure_name => l_proc_name
268: );
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: IF FND_MSG_PUB.Check_Msg_Level(
271: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
272: ) THEN
273: FND_MSG_PUB.Add_Exc_Msg(
274: p_pkg_name => g_pkg_name,

Line 271: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

267: p_procedure_name => l_proc_name
268: );
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: IF FND_MSG_PUB.Check_Msg_Level(
271: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
272: ) THEN
273: FND_MSG_PUB.Add_Exc_Msg(
274: p_pkg_name => g_pkg_name,
275: p_procedure_name => l_proc_name

Line 273: FND_MSG_PUB.Add_Exc_Msg(

269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: IF FND_MSG_PUB.Check_Msg_Level(
271: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
272: ) THEN
273: FND_MSG_PUB.Add_Exc_Msg(
274: p_pkg_name => g_pkg_name,
275: p_procedure_name => l_proc_name
276: );
277: END IF;

Line 346: IF FND_MSG_PUB.Check_Msg_Level(

342: p_module_name => g_module_name,
343: p_procedure_name => l_proc_name
344: );
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
346: IF FND_MSG_PUB.Check_Msg_Level(
347: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
348: ) THEN
349: FND_MSG_PUB.Add_Exc_Msg(
350: p_pkg_name => g_pkg_name,

Line 347: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

343: p_procedure_name => l_proc_name
344: );
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
346: IF FND_MSG_PUB.Check_Msg_Level(
347: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
348: ) THEN
349: FND_MSG_PUB.Add_Exc_Msg(
350: p_pkg_name => g_pkg_name,
351: p_procedure_name => l_proc_name

Line 349: FND_MSG_PUB.Add_Exc_Msg(

345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
346: IF FND_MSG_PUB.Check_Msg_Level(
347: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
348: ) THEN
349: FND_MSG_PUB.Add_Exc_Msg(
350: p_pkg_name => g_pkg_name,
351: p_procedure_name => l_proc_name
352: );
353: END IF;

Line 422: IF FND_MSG_PUB.Check_Msg_Level(

418: INL_LOGGING_PVT.Log_UnexpecError (
419: p_module_name => g_module_name,
420: p_procedure_name => l_proc_name
421: );
422: IF FND_MSG_PUB.Check_Msg_Level(
423: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
424: ) THEN
425: FND_MSG_PUB.Add_Exc_Msg(
426: p_pkg_name => g_pkg_name,

Line 423: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

419: p_module_name => g_module_name,
420: p_procedure_name => l_proc_name
421: );
422: IF FND_MSG_PUB.Check_Msg_Level(
423: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
424: ) THEN
425: FND_MSG_PUB.Add_Exc_Msg(
426: p_pkg_name => g_pkg_name,
427: p_procedure_name => l_proc_name

Line 425: FND_MSG_PUB.Add_Exc_Msg(

421: );
422: IF FND_MSG_PUB.Check_Msg_Level(
423: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
424: ) THEN
425: FND_MSG_PUB.Add_Exc_Msg(
426: p_pkg_name => g_pkg_name,
427: p_procedure_name => l_proc_name
428: );
429: END IF;

Line 501: IF FND_MSG_PUB.Check_Msg_Level(

497: INL_LOGGING_PVT.Log_UnexpecError (
498: p_module_name => g_module_name,
499: p_procedure_name => l_func_name
500: );
501: IF FND_MSG_PUB.Check_Msg_Level(
502: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
503: ) THEN
504: FND_MSG_PUB.Add_Exc_Msg(
505: p_pkg_name => g_pkg_name,

Line 502: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

498: p_module_name => g_module_name,
499: p_procedure_name => l_func_name
500: );
501: IF FND_MSG_PUB.Check_Msg_Level(
502: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
503: ) THEN
504: FND_MSG_PUB.Add_Exc_Msg(
505: p_pkg_name => g_pkg_name,
506: p_procedure_name => l_func_name

Line 504: FND_MSG_PUB.Add_Exc_Msg(

500: );
501: IF FND_MSG_PUB.Check_Msg_Level(
502: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
503: ) THEN
504: FND_MSG_PUB.Add_Exc_Msg(
505: p_pkg_name => g_pkg_name,
506: p_procedure_name => l_func_name
507: );
508: END IF;

Line 633: IF FND_MSG_PUB.Check_Msg_Level(

629: INL_LOGGING_PVT.Log_UnexpecError (
630: p_module_name => g_module_name,
631: p_procedure_name => l_func_name
632: );
633: IF FND_MSG_PUB.Check_Msg_Level(
634: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
635: ) THEN
636: FND_MSG_PUB.Add_Exc_Msg(
637: p_pkg_name => g_pkg_name,

Line 634: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

630: p_module_name => g_module_name,
631: p_procedure_name => l_func_name
632: );
633: IF FND_MSG_PUB.Check_Msg_Level(
634: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
635: ) THEN
636: FND_MSG_PUB.Add_Exc_Msg(
637: p_pkg_name => g_pkg_name,
638: p_procedure_name => l_func_name

Line 636: FND_MSG_PUB.Add_Exc_Msg(

632: );
633: IF FND_MSG_PUB.Check_Msg_Level(
634: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
635: ) THEN
636: FND_MSG_PUB.Add_Exc_Msg(
637: p_pkg_name => g_pkg_name,
638: p_procedure_name => l_func_name
639: );
640: END IF;

Line 744: IF FND_MSG_PUB.Check_Msg_Level(

740: INL_LOGGING_PVT.Log_UnexpecError (
741: p_module_name => g_module_name,
742: p_procedure_name => l_func_name
743: );
744: IF FND_MSG_PUB.Check_Msg_Level(
745: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
746: ) THEN
747: FND_MSG_PUB.Add_Exc_Msg(
748: p_pkg_name => g_pkg_name,

Line 745: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

741: p_module_name => g_module_name,
742: p_procedure_name => l_func_name
743: );
744: IF FND_MSG_PUB.Check_Msg_Level(
745: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
746: ) THEN
747: FND_MSG_PUB.Add_Exc_Msg(
748: p_pkg_name => g_pkg_name,
749: p_procedure_name => l_func_name

Line 747: FND_MSG_PUB.Add_Exc_Msg(

743: );
744: IF FND_MSG_PUB.Check_Msg_Level(
745: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
746: ) THEN
747: FND_MSG_PUB.Add_Exc_Msg(
748: p_pkg_name => g_pkg_name,
749: p_procedure_name => l_func_name
750: );
751: END IF;

Line 865: IF FND_MSG_PUB.Check_Msg_Level(

861: INL_LOGGING_PVT.Log_UnexpecError (
862: p_module_name => g_module_name,
863: p_procedure_name => l_func_name
864: );
865: IF FND_MSG_PUB.Check_Msg_Level(
866: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
867: ) THEN
868: FND_MSG_PUB.Add_Exc_Msg(
869: p_pkg_name => g_pkg_name,

Line 866: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

862: p_module_name => g_module_name,
863: p_procedure_name => l_func_name
864: );
865: IF FND_MSG_PUB.Check_Msg_Level(
866: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
867: ) THEN
868: FND_MSG_PUB.Add_Exc_Msg(
869: p_pkg_name => g_pkg_name,
870: p_procedure_name => l_func_name

Line 868: FND_MSG_PUB.Add_Exc_Msg(

864: );
865: IF FND_MSG_PUB.Check_Msg_Level(
866: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
867: ) THEN
868: FND_MSG_PUB.Add_Exc_Msg(
869: p_pkg_name => g_pkg_name,
870: p_procedure_name => l_func_name
871: );
872: END IF;

Line 994: IF FND_MSG_PUB.Check_Msg_Level(

990: INL_LOGGING_PVT.Log_UnexpecError (
991: p_module_name => g_module_name,
992: p_procedure_name => l_func_name
993: );
994: IF FND_MSG_PUB.Check_Msg_Level(
995: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
996: ) THEN
997: FND_MSG_PUB.Add_Exc_Msg(
998: p_pkg_name => g_pkg_name,

Line 995: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

991: p_module_name => g_module_name,
992: p_procedure_name => l_func_name
993: );
994: IF FND_MSG_PUB.Check_Msg_Level(
995: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
996: ) THEN
997: FND_MSG_PUB.Add_Exc_Msg(
998: p_pkg_name => g_pkg_name,
999: p_procedure_name => l_func_name

Line 997: FND_MSG_PUB.Add_Exc_Msg(

993: );
994: IF FND_MSG_PUB.Check_Msg_Level(
995: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
996: ) THEN
997: FND_MSG_PUB.Add_Exc_Msg(
998: p_pkg_name => g_pkg_name,
999: p_procedure_name => l_func_name
1000: );
1001: END IF;

Line 1151: IF FND_MSG_PUB.Check_Msg_Level(

1147: INL_LOGGING_PVT.Log_UnexpecError (
1148: p_module_name => g_module_name,
1149: p_procedure_name => l_func_name
1150: );
1151: IF FND_MSG_PUB.Check_Msg_Level(
1152: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1153: ) THEN
1154: FND_MSG_PUB.Add_Exc_Msg(
1155: p_pkg_name => g_pkg_name,

Line 1152: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1148: p_module_name => g_module_name,
1149: p_procedure_name => l_func_name
1150: );
1151: IF FND_MSG_PUB.Check_Msg_Level(
1152: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1153: ) THEN
1154: FND_MSG_PUB.Add_Exc_Msg(
1155: p_pkg_name => g_pkg_name,
1156: p_procedure_name => l_func_name

Line 1154: FND_MSG_PUB.Add_Exc_Msg(

1150: );
1151: IF FND_MSG_PUB.Check_Msg_Level(
1152: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1153: ) THEN
1154: FND_MSG_PUB.Add_Exc_Msg(
1155: p_pkg_name => g_pkg_name,
1156: p_procedure_name => l_func_name
1157: );
1158: END IF;

Line 1219: IF FND_MSG_PUB.Check_Msg_Level(

1215: INL_LOGGING_PVT.Log_UnexpecError (
1216: p_module_name => g_module_name,
1217: p_procedure_name => l_func_name
1218: );
1219: IF FND_MSG_PUB.Check_Msg_Level(
1220: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1221: ) THEN
1222: FND_MSG_PUB.Add_Exc_Msg(
1223: p_pkg_name => g_pkg_name,

Line 1220: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1216: p_module_name => g_module_name,
1217: p_procedure_name => l_func_name
1218: );
1219: IF FND_MSG_PUB.Check_Msg_Level(
1220: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1221: ) THEN
1222: FND_MSG_PUB.Add_Exc_Msg(
1223: p_pkg_name => g_pkg_name,
1224: p_procedure_name => l_func_name

Line 1222: FND_MSG_PUB.Add_Exc_Msg(

1218: );
1219: IF FND_MSG_PUB.Check_Msg_Level(
1220: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1221: ) THEN
1222: FND_MSG_PUB.Add_Exc_Msg(
1223: p_pkg_name => g_pkg_name,
1224: p_procedure_name => l_func_name
1225: );
1226: END IF;

Line 1328: IF FND_MSG_PUB.Check_Msg_Level(

1324: INL_LOGGING_PVT.Log_UnexpecError (
1325: p_module_name => g_module_name,
1326: p_procedure_name => l_func_name
1327: );
1328: IF FND_MSG_PUB.Check_Msg_Level(
1329: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1330: ) THEN
1331: FND_MSG_PUB.Add_Exc_Msg(
1332: p_pkg_name => g_pkg_name,

Line 1329: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1325: p_module_name => g_module_name,
1326: p_procedure_name => l_func_name
1327: );
1328: IF FND_MSG_PUB.Check_Msg_Level(
1329: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1330: ) THEN
1331: FND_MSG_PUB.Add_Exc_Msg(
1332: p_pkg_name => g_pkg_name,
1333: p_procedure_name => l_func_name

Line 1331: FND_MSG_PUB.Add_Exc_Msg(

1327: );
1328: IF FND_MSG_PUB.Check_Msg_Level(
1329: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1330: ) THEN
1331: FND_MSG_PUB.Add_Exc_Msg(
1332: p_pkg_name => g_pkg_name,
1333: p_procedure_name => l_func_name
1334: );
1335: END IF;

Line 1762: IF FND_MSG_PUB.Check_Msg_Level(

1758: INL_LOGGING_PVT.Log_UnexpecError (
1759: p_module_name => g_module_name,
1760: p_procedure_name => l_func_name
1761: );
1762: IF FND_MSG_PUB.Check_Msg_Level(
1763: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1764: ) THEN
1765: FND_MSG_PUB.Add_Exc_Msg(
1766: p_pkg_name => g_pkg_name,

Line 1763: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1759: p_module_name => g_module_name,
1760: p_procedure_name => l_func_name
1761: );
1762: IF FND_MSG_PUB.Check_Msg_Level(
1763: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1764: ) THEN
1765: FND_MSG_PUB.Add_Exc_Msg(
1766: p_pkg_name => g_pkg_name,
1767: p_procedure_name => l_func_name

Line 1765: FND_MSG_PUB.Add_Exc_Msg(

1761: );
1762: IF FND_MSG_PUB.Check_Msg_Level(
1763: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1764: ) THEN
1765: FND_MSG_PUB.Add_Exc_Msg(
1766: p_pkg_name => g_pkg_name,
1767: p_procedure_name => l_func_name
1768: );
1769: END IF;

Line 2033: IF FND_MSG_PUB.Check_Msg_Level(

2029: INL_LOGGING_PVT.Log_UnexpecError (
2030: p_module_name => g_module_name,
2031: p_procedure_name => l_func_name
2032: );
2033: IF FND_MSG_PUB.Check_Msg_Level(
2034: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2035: ) THEN
2036: FND_MSG_PUB.Add_Exc_Msg(
2037: p_pkg_name => g_pkg_name,

Line 2034: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2030: p_module_name => g_module_name,
2031: p_procedure_name => l_func_name
2032: );
2033: IF FND_MSG_PUB.Check_Msg_Level(
2034: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2035: ) THEN
2036: FND_MSG_PUB.Add_Exc_Msg(
2037: p_pkg_name => g_pkg_name,
2038: p_procedure_name => l_func_name

Line 2036: FND_MSG_PUB.Add_Exc_Msg(

2032: );
2033: IF FND_MSG_PUB.Check_Msg_Level(
2034: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2035: ) THEN
2036: FND_MSG_PUB.Add_Exc_Msg(
2037: p_pkg_name => g_pkg_name,
2038: p_procedure_name => l_func_name
2039: );
2040: END IF;

Line 2159: IF FND_MSG_PUB.Check_Msg_Level(

2155: INL_LOGGING_PVT.Log_UnexpecError (
2156: p_module_name => g_module_name,
2157: p_procedure_name => l_func_name
2158: );
2159: IF FND_MSG_PUB.Check_Msg_Level(
2160: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2161: ) THEN
2162: FND_MSG_PUB.Add_Exc_Msg(
2163: p_pkg_name => g_pkg_name,

Line 2160: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2156: p_module_name => g_module_name,
2157: p_procedure_name => l_func_name
2158: );
2159: IF FND_MSG_PUB.Check_Msg_Level(
2160: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2161: ) THEN
2162: FND_MSG_PUB.Add_Exc_Msg(
2163: p_pkg_name => g_pkg_name,
2164: p_procedure_name => l_func_name

Line 2162: FND_MSG_PUB.Add_Exc_Msg(

2158: );
2159: IF FND_MSG_PUB.Check_Msg_Level(
2160: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2161: ) THEN
2162: FND_MSG_PUB.Add_Exc_Msg(
2163: p_pkg_name => g_pkg_name,
2164: p_procedure_name => l_func_name
2165: );
2166: END IF;

Line 2306: IF FND_MSG_PUB.Check_Msg_Level(

2302: p_module_name => g_module_name,
2303: p_procedure_name => l_proc_name
2304: );
2305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2306: IF FND_MSG_PUB.Check_Msg_Level(
2307: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2308: ) THEN
2309: FND_MSG_PUB.Add_Exc_Msg(
2310: p_pkg_name => g_pkg_name,

Line 2307: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2303: p_procedure_name => l_proc_name
2304: );
2305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2306: IF FND_MSG_PUB.Check_Msg_Level(
2307: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2308: ) THEN
2309: FND_MSG_PUB.Add_Exc_Msg(
2310: p_pkg_name => g_pkg_name,
2311: p_procedure_name => l_proc_name

Line 2309: FND_MSG_PUB.Add_Exc_Msg(

2305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2306: IF FND_MSG_PUB.Check_Msg_Level(
2307: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2308: ) THEN
2309: FND_MSG_PUB.Add_Exc_Msg(
2310: p_pkg_name => g_pkg_name,
2311: p_procedure_name => l_proc_name
2312: );
2313: END IF;

Line 2685: IF FND_MSG_PUB.Check_Msg_Level(

2681: p_module_name => g_module_name,
2682: p_procedure_name => l_proc_name
2683: );
2684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2685: IF FND_MSG_PUB.Check_Msg_Level(
2686: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2687: ) THEN
2688: FND_MSG_PUB.Add_Exc_Msg(
2689: p_pkg_name => g_pkg_name,

Line 2686: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2682: p_procedure_name => l_proc_name
2683: );
2684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2685: IF FND_MSG_PUB.Check_Msg_Level(
2686: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2687: ) THEN
2688: FND_MSG_PUB.Add_Exc_Msg(
2689: p_pkg_name => g_pkg_name,
2690: p_procedure_name => l_proc_name

Line 2688: FND_MSG_PUB.Add_Exc_Msg(

2684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2685: IF FND_MSG_PUB.Check_Msg_Level(
2686: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2687: ) THEN
2688: FND_MSG_PUB.Add_Exc_Msg(
2689: p_pkg_name => g_pkg_name,
2690: p_procedure_name => l_proc_name
2691: );
2692: END IF;

Line 2939: IF FND_MSG_PUB.Check_Msg_Level(

2935: p_module_name => g_module_name,
2936: p_procedure_name => l_proc_name
2937: );
2938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2939: IF FND_MSG_PUB.Check_Msg_Level(
2940: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2941: ) THEN
2942: FND_MSG_PUB.Add_Exc_Msg(
2943: p_pkg_name => g_pkg_name,

Line 2940: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

2936: p_procedure_name => l_proc_name
2937: );
2938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2939: IF FND_MSG_PUB.Check_Msg_Level(
2940: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2941: ) THEN
2942: FND_MSG_PUB.Add_Exc_Msg(
2943: p_pkg_name => g_pkg_name,
2944: p_procedure_name => l_proc_name

Line 2942: FND_MSG_PUB.Add_Exc_Msg(

2938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2939: IF FND_MSG_PUB.Check_Msg_Level(
2940: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2941: ) THEN
2942: FND_MSG_PUB.Add_Exc_Msg(
2943: p_pkg_name => g_pkg_name,
2944: p_procedure_name => l_proc_name
2945: );
2946: END IF;

Line 3386: IF FND_MSG_PUB.Check_Msg_Level(

3382: p_module_name => g_module_name,
3383: p_procedure_name => l_proc_name
3384: );
3385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3386: IF FND_MSG_PUB.Check_Msg_Level(
3387: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3388: ) THEN
3389: FND_MSG_PUB.Add_Exc_Msg(
3390: p_pkg_name => g_pkg_name,

Line 3387: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3383: p_procedure_name => l_proc_name
3384: );
3385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3386: IF FND_MSG_PUB.Check_Msg_Level(
3387: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3388: ) THEN
3389: FND_MSG_PUB.Add_Exc_Msg(
3390: p_pkg_name => g_pkg_name,
3391: p_procedure_name => l_proc_name

Line 3389: FND_MSG_PUB.Add_Exc_Msg(

3385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3386: IF FND_MSG_PUB.Check_Msg_Level(
3387: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3388: ) THEN
3389: FND_MSG_PUB.Add_Exc_Msg(
3390: p_pkg_name => g_pkg_name,
3391: p_procedure_name => l_proc_name
3392: );
3393: END IF;

Line 3480: IF FND_MSG_PUB.Check_Msg_Level(

3476: p_module_name => g_module_name,
3477: p_procedure_name => l_proc_name
3478: );
3479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3480: IF FND_MSG_PUB.Check_Msg_Level(
3481: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3482: ) THEN
3483: FND_MSG_PUB.Add_Exc_Msg(
3484: p_pkg_name => g_pkg_name,

Line 3481: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3477: p_procedure_name => l_proc_name
3478: );
3479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3480: IF FND_MSG_PUB.Check_Msg_Level(
3481: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3482: ) THEN
3483: FND_MSG_PUB.Add_Exc_Msg(
3484: p_pkg_name => g_pkg_name,
3485: p_procedure_name => l_proc_name

Line 3483: FND_MSG_PUB.Add_Exc_Msg(

3479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3480: IF FND_MSG_PUB.Check_Msg_Level(
3481: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3482: ) THEN
3483: FND_MSG_PUB.Add_Exc_Msg(
3484: p_pkg_name => g_pkg_name,
3485: p_procedure_name => l_proc_name
3486: );
3487: END IF;

Line 3938: IF FND_MSG_PUB.Check_Msg_Level(

3934: p_module_name => g_module_name,
3935: p_procedure_name => l_proc_name
3936: );
3937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3938: IF FND_MSG_PUB.Check_Msg_Level(
3939: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3940: ) THEN
3941: FND_MSG_PUB.Add_Exc_Msg(
3942: p_pkg_name => g_pkg_name,

Line 3939: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

3935: p_procedure_name => l_proc_name
3936: );
3937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3938: IF FND_MSG_PUB.Check_Msg_Level(
3939: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3940: ) THEN
3941: FND_MSG_PUB.Add_Exc_Msg(
3942: p_pkg_name => g_pkg_name,
3943: p_procedure_name => l_proc_name

Line 3941: FND_MSG_PUB.Add_Exc_Msg(

3937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3938: IF FND_MSG_PUB.Check_Msg_Level(
3939: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3940: ) THEN
3941: FND_MSG_PUB.Add_Exc_Msg(
3942: p_pkg_name => g_pkg_name,
3943: p_procedure_name => l_proc_name
3944: );
3945: END IF;

Line 4380: IF FND_MSG_PUB.Check_Msg_Level(

4376: p_module_name => g_module_name,
4377: p_procedure_name => l_proc_name
4378: );
4379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4380: IF FND_MSG_PUB.Check_Msg_Level(
4381: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4382: ) THEN
4383: FND_MSG_PUB.Add_Exc_Msg(
4384: p_pkg_name => g_pkg_name,

Line 4381: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4377: p_procedure_name => l_proc_name
4378: );
4379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4380: IF FND_MSG_PUB.Check_Msg_Level(
4381: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4382: ) THEN
4383: FND_MSG_PUB.Add_Exc_Msg(
4384: p_pkg_name => g_pkg_name,
4385: p_procedure_name => l_proc_name

Line 4383: FND_MSG_PUB.Add_Exc_Msg(

4379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4380: IF FND_MSG_PUB.Check_Msg_Level(
4381: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4382: ) THEN
4383: FND_MSG_PUB.Add_Exc_Msg(
4384: p_pkg_name => g_pkg_name,
4385: p_procedure_name => l_proc_name
4386: );
4387: END IF;

Line 4461: IF FND_MSG_PUB.Check_Msg_Level(

4457: p_module_name => g_module_name,
4458: p_procedure_name => l_proc_name
4459: );
4460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4461: IF FND_MSG_PUB.Check_Msg_Level(
4462: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4463: ) THEN
4464: FND_MSG_PUB.Add_Exc_Msg(
4465: p_pkg_name => g_pkg_name,

Line 4462: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4458: p_procedure_name => l_proc_name
4459: );
4460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4461: IF FND_MSG_PUB.Check_Msg_Level(
4462: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4463: ) THEN
4464: FND_MSG_PUB.Add_Exc_Msg(
4465: p_pkg_name => g_pkg_name,
4466: p_procedure_name => l_proc_name

Line 4464: FND_MSG_PUB.Add_Exc_Msg(

4460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4461: IF FND_MSG_PUB.Check_Msg_Level(
4462: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4463: ) THEN
4464: FND_MSG_PUB.Add_Exc_Msg(
4465: p_pkg_name => g_pkg_name,
4466: p_procedure_name => l_proc_name
4467: );
4468: END IF;

Line 4675: IF FND_MSG_PUB.Check_Msg_Level(

4671: p_module_name => g_module_name,
4672: p_procedure_name => l_proc_name
4673: );
4674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4675: IF FND_MSG_PUB.Check_Msg_Level(
4676: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4677: ) THEN
4678: FND_MSG_PUB.Add_Exc_Msg(
4679: p_pkg_name => g_pkg_name,

Line 4676: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4672: p_procedure_name => l_proc_name
4673: );
4674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4675: IF FND_MSG_PUB.Check_Msg_Level(
4676: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4677: ) THEN
4678: FND_MSG_PUB.Add_Exc_Msg(
4679: p_pkg_name => g_pkg_name,
4680: p_procedure_name => l_proc_name

Line 4678: FND_MSG_PUB.Add_Exc_Msg(

4674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4675: IF FND_MSG_PUB.Check_Msg_Level(
4676: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4677: ) THEN
4678: FND_MSG_PUB.Add_Exc_Msg(
4679: p_pkg_name => g_pkg_name,
4680: p_procedure_name => l_proc_name
4681: );
4682: END IF;

Line 4797: IF FND_MSG_PUB.Check_Msg_Level(

4793: p_module_name => g_module_name,
4794: p_procedure_name => l_proc_name
4795: );
4796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4797: IF FND_MSG_PUB.Check_Msg_Level(
4798: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4799: ) THEN
4800: FND_MSG_PUB.Add_Exc_Msg(
4801: p_pkg_name => g_pkg_name,

Line 4798: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4794: p_procedure_name => l_proc_name
4795: );
4796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4797: IF FND_MSG_PUB.Check_Msg_Level(
4798: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4799: ) THEN
4800: FND_MSG_PUB.Add_Exc_Msg(
4801: p_pkg_name => g_pkg_name,
4802: p_procedure_name => l_proc_name

Line 4800: FND_MSG_PUB.Add_Exc_Msg(

4796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4797: IF FND_MSG_PUB.Check_Msg_Level(
4798: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4799: ) THEN
4800: FND_MSG_PUB.Add_Exc_Msg(
4801: p_pkg_name => g_pkg_name,
4802: p_procedure_name => l_proc_name
4803: );
4804: END IF;

Line 4919: IF FND_MSG_PUB.Check_Msg_Level(

4915: INL_LOGGING_PVT.Log_UnexpecError (
4916: p_module_name => g_module_name,
4917: p_procedure_name => l_func_name
4918: );
4919: IF FND_MSG_PUB.Check_Msg_Level(
4920: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4921: ) THEN
4922: FND_MSG_PUB.Add_Exc_Msg(
4923: p_pkg_name => g_pkg_name,

Line 4920: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

4916: p_module_name => g_module_name,
4917: p_procedure_name => l_func_name
4918: );
4919: IF FND_MSG_PUB.Check_Msg_Level(
4920: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4921: ) THEN
4922: FND_MSG_PUB.Add_Exc_Msg(
4923: p_pkg_name => g_pkg_name,
4924: p_procedure_name => l_func_name

Line 4922: FND_MSG_PUB.Add_Exc_Msg(

4918: );
4919: IF FND_MSG_PUB.Check_Msg_Level(
4920: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4921: ) THEN
4922: FND_MSG_PUB.Add_Exc_Msg(
4923: p_pkg_name => g_pkg_name,
4924: p_procedure_name => l_func_name
4925: );
4926: END IF;

Line 5018: IF FND_MSG_PUB.Check_Msg_Level(

5014: INL_LOGGING_PVT.Log_UnexpecError (
5015: p_module_name => g_module_name,
5016: p_procedure_name => l_func_name
5017: );
5018: IF FND_MSG_PUB.Check_Msg_Level(
5019: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5020: ) THEN
5021: FND_MSG_PUB.Add_Exc_Msg(
5022: p_pkg_name => g_pkg_name,

Line 5019: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

5015: p_module_name => g_module_name,
5016: p_procedure_name => l_func_name
5017: );
5018: IF FND_MSG_PUB.Check_Msg_Level(
5019: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5020: ) THEN
5021: FND_MSG_PUB.Add_Exc_Msg(
5022: p_pkg_name => g_pkg_name,
5023: p_procedure_name => l_func_name

Line 5021: FND_MSG_PUB.Add_Exc_Msg(

5017: );
5018: IF FND_MSG_PUB.Check_Msg_Level(
5019: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5020: ) THEN
5021: FND_MSG_PUB.Add_Exc_Msg(
5022: p_pkg_name => g_pkg_name,
5023: p_procedure_name => l_func_name
5024: );
5025: END IF;

Line 5501: IF FND_MSG_PUB.Check_Msg_Level(

5497: INL_LOGGING_PVT.Log_UnexpecError (
5498: p_module_name => g_module_name,
5499: p_procedure_name => l_func_name
5500: );
5501: IF FND_MSG_PUB.Check_Msg_Level(
5502: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5503: ) THEN
5504: FND_MSG_PUB.Add_Exc_Msg(
5505: p_pkg_name => g_pkg_name,

Line 5502: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

5498: p_module_name => g_module_name,
5499: p_procedure_name => l_func_name
5500: );
5501: IF FND_MSG_PUB.Check_Msg_Level(
5502: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5503: ) THEN
5504: FND_MSG_PUB.Add_Exc_Msg(
5505: p_pkg_name => g_pkg_name,
5506: p_procedure_name => l_func_name

Line 5504: FND_MSG_PUB.Add_Exc_Msg(

5500: );
5501: IF FND_MSG_PUB.Check_Msg_Level(
5502: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5503: ) THEN
5504: FND_MSG_PUB.Add_Exc_Msg(
5505: p_pkg_name => g_pkg_name,
5506: p_procedure_name => l_func_name
5507: );
5508: END IF;

Line 5676: IF FND_MSG_PUB.Check_Msg_Level(

5672: INL_LOGGING_PVT.Log_UnexpecError (
5673: p_module_name => g_module_name,
5674: p_procedure_name => l_func_name
5675: );
5676: IF FND_MSG_PUB.Check_Msg_Level(
5677: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5678: ) THEN
5679: FND_MSG_PUB.Add_Exc_Msg(
5680: p_pkg_name => g_pkg_name,

Line 5677: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

5673: p_module_name => g_module_name,
5674: p_procedure_name => l_func_name
5675: );
5676: IF FND_MSG_PUB.Check_Msg_Level(
5677: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5678: ) THEN
5679: FND_MSG_PUB.Add_Exc_Msg(
5680: p_pkg_name => g_pkg_name,
5681: p_procedure_name => l_func_name

Line 5679: FND_MSG_PUB.Add_Exc_Msg(

5675: );
5676: IF FND_MSG_PUB.Check_Msg_Level(
5677: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5678: ) THEN
5679: FND_MSG_PUB.Add_Exc_Msg(
5680: p_pkg_name => g_pkg_name,
5681: p_procedure_name => l_func_name
5682: );
5683: END IF;

Line 5815: IF FND_MSG_PUB.Check_Msg_Level(

5811: INL_LOGGING_PVT.Log_UnexpecError (
5812: p_module_name => g_module_name,
5813: p_procedure_name => l_func_name
5814: );
5815: IF FND_MSG_PUB.Check_Msg_Level(
5816: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5817: ) THEN
5818: FND_MSG_PUB.Add_Exc_Msg(
5819: p_pkg_name => g_pkg_name,

Line 5816: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

5812: p_module_name => g_module_name,
5813: p_procedure_name => l_func_name
5814: );
5815: IF FND_MSG_PUB.Check_Msg_Level(
5816: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5817: ) THEN
5818: FND_MSG_PUB.Add_Exc_Msg(
5819: p_pkg_name => g_pkg_name,
5820: p_procedure_name => l_func_name

Line 5818: FND_MSG_PUB.Add_Exc_Msg(

5814: );
5815: IF FND_MSG_PUB.Check_Msg_Level(
5816: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5817: ) THEN
5818: FND_MSG_PUB.Add_Exc_Msg(
5819: p_pkg_name => g_pkg_name,
5820: p_procedure_name => l_func_name
5821: );
5822: END IF;

Line 5963: IF FND_MSG_PUB.Check_Msg_Level(

5959: INL_LOGGING_PVT.Log_UnexpecError (
5960: p_module_name => g_module_name,
5961: p_procedure_name => l_func_name
5962: );
5963: IF FND_MSG_PUB.Check_Msg_Level(
5964: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5965: ) THEN
5966: FND_MSG_PUB.Add_Exc_Msg(
5967: p_pkg_name => g_pkg_name,

Line 5964: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

5960: p_module_name => g_module_name,
5961: p_procedure_name => l_func_name
5962: );
5963: IF FND_MSG_PUB.Check_Msg_Level(
5964: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5965: ) THEN
5966: FND_MSG_PUB.Add_Exc_Msg(
5967: p_pkg_name => g_pkg_name,
5968: p_procedure_name => l_func_name

Line 5966: FND_MSG_PUB.Add_Exc_Msg(

5962: );
5963: IF FND_MSG_PUB.Check_Msg_Level(
5964: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5965: ) THEN
5966: FND_MSG_PUB.Add_Exc_Msg(
5967: p_pkg_name => g_pkg_name,
5968: p_procedure_name => l_func_name
5969: );
5970: END IF;

Line 6197: IF FND_MSG_PUB.Check_Msg_Level(

6193: INL_LOGGING_PVT.Log_UnexpecError (
6194: p_module_name => g_module_name,
6195: p_procedure_name => l_func_name
6196: );
6197: IF FND_MSG_PUB.Check_Msg_Level(
6198: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6199: ) THEN
6200: FND_MSG_PUB.Add_Exc_Msg(
6201: p_pkg_name => g_pkg_name,

Line 6198: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

6194: p_module_name => g_module_name,
6195: p_procedure_name => l_func_name
6196: );
6197: IF FND_MSG_PUB.Check_Msg_Level(
6198: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6199: ) THEN
6200: FND_MSG_PUB.Add_Exc_Msg(
6201: p_pkg_name => g_pkg_name,
6202: p_procedure_name => l_func_name

Line 6200: FND_MSG_PUB.Add_Exc_Msg(

6196: );
6197: IF FND_MSG_PUB.Check_Msg_Level(
6198: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6199: ) THEN
6200: FND_MSG_PUB.Add_Exc_Msg(
6201: p_pkg_name => g_pkg_name,
6202: p_procedure_name => l_func_name
6203: );
6204: END IF;

Line 6550: IF FND_MSG_PUB.Check_Msg_Level(

6546: INL_LOGGING_PVT.Log_UnexpecError (
6547: p_module_name => g_module_name,
6548: p_procedure_name => l_func_name
6549: );
6550: IF FND_MSG_PUB.Check_Msg_Level(
6551: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6552: ) THEN
6553: FND_MSG_PUB.Add_Exc_Msg(
6554: p_pkg_name => g_pkg_name,

Line 6551: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

6547: p_module_name => g_module_name,
6548: p_procedure_name => l_func_name
6549: );
6550: IF FND_MSG_PUB.Check_Msg_Level(
6551: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6552: ) THEN
6553: FND_MSG_PUB.Add_Exc_Msg(
6554: p_pkg_name => g_pkg_name,
6555: p_procedure_name => l_func_name

Line 6553: FND_MSG_PUB.Add_Exc_Msg(

6549: );
6550: IF FND_MSG_PUB.Check_Msg_Level(
6551: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6552: ) THEN
6553: FND_MSG_PUB.Add_Exc_Msg(
6554: p_pkg_name => g_pkg_name,
6555: p_procedure_name => l_func_name
6556: );
6557: END IF;

Line 6831: IF FND_MSG_PUB.Check_Msg_Level(

6827: INL_LOGGING_PVT.Log_UnexpecError (
6828: p_module_name => g_module_name,
6829: p_procedure_name => l_func_name
6830: );
6831: IF FND_MSG_PUB.Check_Msg_Level(
6832: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6833: ) THEN
6834: FND_MSG_PUB.Add_Exc_Msg(
6835: p_pkg_name => g_pkg_name,

Line 6832: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

6828: p_module_name => g_module_name,
6829: p_procedure_name => l_func_name
6830: );
6831: IF FND_MSG_PUB.Check_Msg_Level(
6832: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6833: ) THEN
6834: FND_MSG_PUB.Add_Exc_Msg(
6835: p_pkg_name => g_pkg_name,
6836: p_procedure_name => l_func_name

Line 6834: FND_MSG_PUB.Add_Exc_Msg(

6830: );
6831: IF FND_MSG_PUB.Check_Msg_Level(
6832: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6833: ) THEN
6834: FND_MSG_PUB.Add_Exc_Msg(
6835: p_pkg_name => g_pkg_name,
6836: p_procedure_name => l_func_name
6837: );
6838: END IF;

Line 7051: IF FND_MSG_PUB.Check_Msg_Level(

7047: INL_LOGGING_PVT.Log_UnexpecError (
7048: p_module_name => g_module_name,
7049: p_procedure_name => l_func_name
7050: );
7051: IF FND_MSG_PUB.Check_Msg_Level(
7052: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7053: ) THEN
7054: FND_MSG_PUB.Add_Exc_Msg(
7055: p_pkg_name => g_pkg_name,

Line 7052: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

7048: p_module_name => g_module_name,
7049: p_procedure_name => l_func_name
7050: );
7051: IF FND_MSG_PUB.Check_Msg_Level(
7052: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7053: ) THEN
7054: FND_MSG_PUB.Add_Exc_Msg(
7055: p_pkg_name => g_pkg_name,
7056: p_procedure_name => l_func_name

Line 7054: FND_MSG_PUB.Add_Exc_Msg(

7050: );
7051: IF FND_MSG_PUB.Check_Msg_Level(
7052: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7053: ) THEN
7054: FND_MSG_PUB.Add_Exc_Msg(
7055: p_pkg_name => g_pkg_name,
7056: p_procedure_name => l_func_name
7057: );
7058: END IF;

Line 7132: IF FND_MSG_PUB.Check_Msg_Level(

7128: INL_LOGGING_PVT.Log_UnexpecError (
7129: p_module_name => g_module_name,
7130: p_procedure_name => l_func_name
7131: );
7132: IF FND_MSG_PUB.Check_Msg_Level(
7133: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7134: ) THEN
7135: FND_MSG_PUB.Add_Exc_Msg(
7136: p_pkg_name => g_pkg_name,

Line 7133: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

7129: p_module_name => g_module_name,
7130: p_procedure_name => l_func_name
7131: );
7132: IF FND_MSG_PUB.Check_Msg_Level(
7133: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7134: ) THEN
7135: FND_MSG_PUB.Add_Exc_Msg(
7136: p_pkg_name => g_pkg_name,
7137: p_procedure_name => l_func_name

Line 7135: FND_MSG_PUB.Add_Exc_Msg(

7131: );
7132: IF FND_MSG_PUB.Check_Msg_Level(
7133: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7134: ) THEN
7135: FND_MSG_PUB.Add_Exc_Msg(
7136: p_pkg_name => g_pkg_name,
7137: p_procedure_name => l_func_name
7138: );
7139: END IF;

Line 7592: IF FND_MSG_PUB.Check_Msg_Level(

7588: INL_LOGGING_PVT.Log_UnexpecError (
7589: p_module_name => g_module_name,
7590: p_procedure_name => l_func_name
7591: );
7592: IF FND_MSG_PUB.Check_Msg_Level(
7593: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7594: ) THEN
7595: FND_MSG_PUB.Add_Exc_Msg(
7596: p_pkg_name => g_pkg_name,

Line 7593: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

7589: p_module_name => g_module_name,
7590: p_procedure_name => l_func_name
7591: );
7592: IF FND_MSG_PUB.Check_Msg_Level(
7593: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7594: ) THEN
7595: FND_MSG_PUB.Add_Exc_Msg(
7596: p_pkg_name => g_pkg_name,
7597: p_procedure_name => l_func_name

Line 7595: FND_MSG_PUB.Add_Exc_Msg(

7591: );
7592: IF FND_MSG_PUB.Check_Msg_Level(
7593: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7594: ) THEN
7595: FND_MSG_PUB.Add_Exc_Msg(
7596: p_pkg_name => g_pkg_name,
7597: p_procedure_name => l_func_name
7598: );
7599: END IF;

Line 7958: IF FND_MSG_PUB.Check_Msg_Level(

7954: p_module_name => g_module_name,
7955: p_procedure_name => l_proc_name
7956: );
7957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7958: IF FND_MSG_PUB.Check_Msg_Level(
7959: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7960: ) THEN
7961: FND_MSG_PUB.Add_Exc_Msg(
7962: p_pkg_name => g_pkg_name,

Line 7959: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

7955: p_procedure_name => l_proc_name
7956: );
7957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7958: IF FND_MSG_PUB.Check_Msg_Level(
7959: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7960: ) THEN
7961: FND_MSG_PUB.Add_Exc_Msg(
7962: p_pkg_name => g_pkg_name,
7963: p_procedure_name => l_proc_name

Line 7961: FND_MSG_PUB.Add_Exc_Msg(

7957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7958: IF FND_MSG_PUB.Check_Msg_Level(
7959: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
7960: ) THEN
7961: FND_MSG_PUB.Add_Exc_Msg(
7962: p_pkg_name => g_pkg_name,
7963: p_procedure_name => l_proc_name
7964: );
7965: END IF;

Line 8036: IF FND_MSG_PUB.Check_Msg_Level(

8032: p_module_name => g_module_name,
8033: p_procedure_name => l_proc_name
8034: );
8035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8036: IF FND_MSG_PUB.Check_Msg_Level(
8037: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8038: ) THEN
8039: FND_MSG_PUB.Add_Exc_Msg(
8040: p_pkg_name => g_pkg_name,

Line 8037: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

8033: p_procedure_name => l_proc_name
8034: );
8035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8036: IF FND_MSG_PUB.Check_Msg_Level(
8037: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8038: ) THEN
8039: FND_MSG_PUB.Add_Exc_Msg(
8040: p_pkg_name => g_pkg_name,
8041: p_procedure_name => l_proc_name

Line 8039: FND_MSG_PUB.Add_Exc_Msg(

8035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8036: IF FND_MSG_PUB.Check_Msg_Level(
8037: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8038: ) THEN
8039: FND_MSG_PUB.Add_Exc_Msg(
8040: p_pkg_name => g_pkg_name,
8041: p_procedure_name => l_proc_name
8042: );
8043: END IF;

Line 8420: IF FND_MSG_PUB.Check_Msg_Level(

8416: p_module_name => g_module_name,
8417: p_procedure_name => l_proc_name
8418: );
8419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8420: IF FND_MSG_PUB.Check_Msg_Level(
8421: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8422: ) THEN
8423: FND_MSG_PUB.Add_Exc_Msg(
8424: p_pkg_name => g_pkg_name,

Line 8421: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

8417: p_procedure_name => l_proc_name
8418: );
8419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8420: IF FND_MSG_PUB.Check_Msg_Level(
8421: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8422: ) THEN
8423: FND_MSG_PUB.Add_Exc_Msg(
8424: p_pkg_name => g_pkg_name,
8425: p_procedure_name => l_proc_name

Line 8423: FND_MSG_PUB.Add_Exc_Msg(

8419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8420: IF FND_MSG_PUB.Check_Msg_Level(
8421: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8422: ) THEN
8423: FND_MSG_PUB.Add_Exc_Msg(
8424: p_pkg_name => g_pkg_name,
8425: p_procedure_name => l_proc_name
8426: );
8427: END IF;

Line 8657: IF FND_MSG_PUB.Check_Msg_Level(

8653: p_module_name => g_module_name,
8654: p_procedure_name => l_proc_name
8655: );
8656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8657: IF FND_MSG_PUB.Check_Msg_Level(
8658: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8659: ) THEN
8660: FND_MSG_PUB.Add_Exc_Msg(
8661: p_pkg_name => g_pkg_name,

Line 8658: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

8654: p_procedure_name => l_proc_name
8655: );
8656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8657: IF FND_MSG_PUB.Check_Msg_Level(
8658: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8659: ) THEN
8660: FND_MSG_PUB.Add_Exc_Msg(
8661: p_pkg_name => g_pkg_name,
8662: p_procedure_name => l_proc_name

Line 8660: FND_MSG_PUB.Add_Exc_Msg(

8656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8657: IF FND_MSG_PUB.Check_Msg_Level(
8658: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8659: ) THEN
8660: FND_MSG_PUB.Add_Exc_Msg(
8661: p_pkg_name => g_pkg_name,
8662: p_procedure_name => l_proc_name
8663: );
8664: END IF;

Line 8724: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.get (i, FND_API.g_false) );

8720: ELSIF l_msg_count > 1 THEN
8721: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_count|| ' warnings found.' );
8722: FOR i IN 1 ..l_msg_count
8723: LOOP
8724: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.get (i, FND_API.g_false) );
8725: END LOOP;
8726: retcode := 1;
8727: END IF;
8728: -- If any errors happen abort API.

Line 8808: FND_MSG_PUB.initialize;

8804: -- Standard Start of API savepoint
8805: SAVEPOINT Import_LCMShipments_PVT;
8806: -- Initialize message list if p_init_msg_list is set to TRUE.
8807: IF FND_API.to_Boolean(p_init_msg_list) THEN
8808: FND_MSG_PUB.initialize;
8809: END IF;
8810: -- Standard call to check for call compatibility
8811: IF NOT FND_API.Compatible_API_Call(
8812: p_current_version_number => l_api_version,

Line 8860: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;

8856: IF FND_API.To_Boolean(p_commit) THEN
8857: COMMIT WORK;
8858: END IF;
8859: -- Standard call to get message count and if count is 1, get message info.
8860: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false, p_count => x_msg_count, p_data => x_msg_data) ;
8861: -- Standard End of Procedure/Function Logging
8862: INL_LOGGING_PVT.Log_EndProc(
8863: p_module_name => g_module_name,
8864: p_procedure_name => l_api_name

Line 8875: FND_MSG_PUB.Count_And_Get(

8871: p_procedure_name => l_api_name
8872: );
8873: ROLLBACK TO Import_LCMShipments_PVT;
8874: x_return_status := FND_API.G_RET_STS_ERROR;
8875: FND_MSG_PUB.Count_And_Get(
8876: p_encoded => FND_API.g_false,
8877: p_count => x_msg_count,
8878: p_data => x_msg_data
8879: );

Line 8888: FND_MSG_PUB.Count_And_Get(

8884: p_procedure_name => l_api_name
8885: );
8886: ROLLBACK TO Import_LCMShipments_PVT;
8887: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8888: FND_MSG_PUB.Count_And_Get(
8889: p_encoded => FND_API.g_false,
8890: p_count => x_msg_count,
8891: p_data => x_msg_data
8892: );

Line 8901: IF FND_MSG_PUB.Check_Msg_Level(

8897: p_procedure_name => l_api_name
8898: );
8899: ROLLBACK TO Import_LCMShipments_PVT;
8900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8901: IF FND_MSG_PUB.Check_Msg_Level(
8902: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8903: ) THEN
8904: FND_MSG_PUB.Add_Exc_Msg(
8905: p_pkg_name => g_pkg_name,

Line 8902: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

8898: );
8899: ROLLBACK TO Import_LCMShipments_PVT;
8900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8901: IF FND_MSG_PUB.Check_Msg_Level(
8902: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8903: ) THEN
8904: FND_MSG_PUB.Add_Exc_Msg(
8905: p_pkg_name => g_pkg_name,
8906: p_procedure_name => l_api_name

Line 8904: FND_MSG_PUB.Add_Exc_Msg(

8900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8901: IF FND_MSG_PUB.Check_Msg_Level(
8902: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
8903: ) THEN
8904: FND_MSG_PUB.Add_Exc_Msg(
8905: p_pkg_name => g_pkg_name,
8906: p_procedure_name => l_api_name
8907: );
8908: END IF;

Line 8909: FND_MSG_PUB.Count_And_Get(

8905: p_pkg_name => g_pkg_name,
8906: p_procedure_name => l_api_name
8907: );
8908: END IF;
8909: FND_MSG_PUB.Count_And_Get(
8910: p_encoded => FND_API.g_false,
8911: p_count => x_msg_count,
8912: p_data => x_msg_data
8913: );

Line 8968: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.get (i, FND_API.g_false) );

8964: ELSIF l_msg_count > 1 THEN
8965: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_count|| ' warnings found.' );
8966: FOR i IN 1 ..l_msg_count
8967: LOOP
8968: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.get (i, FND_API.g_false) );
8969: END LOOP;
8970: retcode := 1;
8971: END IF;
8972: -- If any errors happen abort API.

Line 9051: FND_MSG_PUB.initialize;

9047: -- Standard Start of API savepoint
9048: SAVEPOINT Import_LCMMatches_PVT;
9049: -- Initialize message list if p_init_msg_list is set to TRUE.
9050: IF FND_API.to_Boolean(p_init_msg_list) THEN
9051: FND_MSG_PUB.initialize;
9052: END IF;
9053: -- Standard call to check for call compatibility
9054: IF NOT FND_API.Compatible_API_Call(
9055: p_current_version_number => l_api_version,

Line 9099: FND_MSG_PUB.Count_And_Get(

9095: IF FND_API.To_Boolean(p_commit) THEN
9096: COMMIT WORK;
9097: END IF;
9098: -- Standard call to get message count and if count is 1, get message info.
9099: FND_MSG_PUB.Count_And_Get(
9100: p_encoded => FND_API.g_false,
9101: p_count => x_msg_count,
9102: p_data => x_msg_data
9103: ) ;

Line 9118: FND_MSG_PUB.Count_And_Get(

9114: p_procedure_name => l_api_name
9115: );
9116: ROLLBACK TO Import_LCMMatches_PVT;
9117: x_return_status := FND_API.G_RET_STS_ERROR;
9118: FND_MSG_PUB.Count_And_Get(
9119: p_encoded => FND_API.g_false,
9120: p_count => x_msg_count,
9121: p_data => x_msg_data
9122: );

Line 9131: FND_MSG_PUB.Count_And_Get(

9127: p_procedure_name => l_api_name
9128: );
9129: ROLLBACK TO Import_LCMMatches_PVT;
9130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9131: FND_MSG_PUB.Count_And_Get(
9132: p_encoded => FND_API.g_false,
9133: p_count => x_msg_count,
9134: p_data => x_msg_data
9135: );

Line 9144: IF FND_MSG_PUB.Check_Msg_Level(

9140: p_procedure_name => l_api_name
9141: );
9142: ROLLBACK TO Import_LCMMatches_PVT;
9143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9144: IF FND_MSG_PUB.Check_Msg_Level(
9145: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9146: ) THEN
9147: FND_MSG_PUB.Add_Exc_Msg(
9148: p_pkg_name => g_pkg_name,

Line 9145: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

9141: );
9142: ROLLBACK TO Import_LCMMatches_PVT;
9143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9144: IF FND_MSG_PUB.Check_Msg_Level(
9145: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9146: ) THEN
9147: FND_MSG_PUB.Add_Exc_Msg(
9148: p_pkg_name => g_pkg_name,
9149: p_procedure_name => l_api_name

Line 9147: FND_MSG_PUB.Add_Exc_Msg(

9143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9144: IF FND_MSG_PUB.Check_Msg_Level(
9145: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9146: ) THEN
9147: FND_MSG_PUB.Add_Exc_Msg(
9148: p_pkg_name => g_pkg_name,
9149: p_procedure_name => l_api_name
9150: );
9151: END IF;

Line 9152: FND_MSG_PUB.Count_And_Get(

9148: p_pkg_name => g_pkg_name,
9149: p_procedure_name => l_api_name
9150: );
9151: END IF;
9152: FND_MSG_PUB.Count_And_Get(
9153: p_encoded => FND_API.g_false,
9154: p_count => x_msg_count,
9155: p_data => x_msg_data
9156: );