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 STANDARD

Line 59: -- Standard Beginning of Procedure/Function Logging

55: l_debug_info VARCHAR2(200) ;
56: l_ship_header_int_id NUMBER;
57: l_error_message VARCHAR2(2000) ;
58: BEGIN
59: -- Standard Beginning of Procedure/Function Logging
60: INL_LOGGING_PVT.Log_BeginProc(
61: p_module_name => g_module_name,
62: p_procedure_name => l_proc_name
63: ) ;

Line 243: -- Standard End of Procedure/Function Logging

239: fnd_global.prog_appl_id, /*27*/
240: SYSDATE, /*28*/
241: fnd_global.conc_request_id /*29*/
242: );
243: -- Standard End of Procedure/Function Logging
244: INL_LOGGING_PVT.Log_EndProc(
245: p_module_name => g_module_name,
246: p_procedure_name => l_proc_name
247: );

Line 250: -- Standard Expected Error Logging

246: p_procedure_name => l_proc_name
247: );
248: EXCEPTION
249: WHEN FND_API.G_EXC_ERROR THEN
250: -- Standard Expected Error Logging
251: INL_LOGGING_PVT.Log_ExpecError (
252: p_module_name => g_module_name,
253: p_procedure_name => l_proc_name
254: );

Line 257: -- Standard Unexpected Error Logging

253: p_procedure_name => l_proc_name
254: );
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: -- Standard Unexpected Error Logging
258: INL_LOGGING_PVT.Log_UnexpecError (
259: p_module_name => g_module_name,
260: p_procedure_name => l_proc_name
261: );

Line 264: -- Standard Unexpected Error Logging

260: p_procedure_name => l_proc_name
261: );
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263: WHEN OTHERS THEN
264: -- Standard Unexpected Error Logging
265: INL_LOGGING_PVT.Log_UnexpecError (
266: p_module_name => g_module_name,
267: p_procedure_name => l_proc_name
268: );

Line 302: -- Standard Beginning of Procedure/Function Logging

298: l_proc_name CONSTANT VARCHAR2(30):= 'Reset_InterfError';
299: l_return_status VARCHAR2(1);
300: l_debug_info VARCHAR2(200);
301: BEGIN
302: -- Standard Beginning of Procedure/Function Logging
303: INL_LOGGING_PVT.Log_BeginProc(
304: p_module_name => g_module_name,
305: p_procedure_name => l_proc_name
306: ) ;

Line 319: -- Standard End of Procedure/Function Logging

315: DELETE
316: FROM inl_interface_errors
317: WHERE parent_table_name = p_parent_table_name
318: AND parent_table_id = p_parent_table_id;
319: -- Standard End of Procedure/Function Logging
320: INL_LOGGING_PVT.Log_EndProc(
321: p_module_name => g_module_name,
322: p_procedure_name => l_proc_name
323: );

Line 326: -- Standard Expected Error Logging

322: p_procedure_name => l_proc_name
323: );
324: EXCEPTION
325: WHEN FND_API.G_EXC_ERROR THEN
326: -- Standard Expected Error Logging
327: INL_LOGGING_PVT.Log_ExpecError (
328: p_module_name => g_module_name,
329: p_procedure_name => l_proc_name
330: );

Line 333: -- Standard Unexpected Error Logging

329: p_procedure_name => l_proc_name
330: );
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
333: -- Standard Unexpected Error Logging
334: INL_LOGGING_PVT.Log_UnexpecError (
335: p_module_name => g_module_name,
336: p_procedure_name => l_proc_name
337: );

Line 340: -- Standard Unexpected Error Logging

336: p_procedure_name => l_proc_name
337: );
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: WHEN OTHERS THEN
340: -- Standard Unexpected Error Logging
341: INL_LOGGING_PVT.Log_UnexpecError (
342: p_module_name => g_module_name,
343: p_procedure_name => l_proc_name
344: );

Line 376: -- Standard Beginning of Procedure/Function Logging

372: l_return_status VARCHAR2(1) ;
373: l_debug_info VARCHAR2(200) ;
374: l_return_value NUMBER;
375: BEGIN
376: -- Standard Beginning of Procedure/Function Logging
377: INL_LOGGING_PVT.Log_BeginProc(
378: p_module_name => g_module_name,
379: p_procedure_name => l_proc_name
380: ) ;

Line 393: -- Standard End of Procedure/Function Logging

389: SELECT party_id
390: INTO l_return_value
391: FROM hz_parties
392: WHERE PARTY_NUMBER = p_party_number;
393: -- Standard End of Procedure/Function Logging
394: INL_LOGGING_PVT.Log_EndProc(
395: p_module_name => g_module_name,
396: p_procedure_name => l_proc_name
397: );

Line 401: -- Standard Expected Error Logging

397: );
398: RETURN l_return_value;
399: EXCEPTION
400: WHEN FND_API.G_EXC_ERROR THEN
401: -- Standard Expected Error Logging
402: INL_LOGGING_PVT.Log_ExpecError (
403: p_module_name => g_module_name,
404: p_procedure_name => l_proc_name
405: );

Line 409: -- Standard Unexpected Error Logging

405: );
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: RETURN 0;
408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
409: -- Standard Unexpected Error Logging
410: INL_LOGGING_PVT.Log_UnexpecError (
411: p_module_name => g_module_name,
412: p_procedure_name => l_proc_name
413: );

Line 417: -- Standard Unexpected Error Logging

413: );
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: RETURN 0;
416: WHEN OTHERS THEN
417: -- Standard Unexpected Error Logging
418: INL_LOGGING_PVT.Log_UnexpecError (
419: p_module_name => g_module_name,
420: p_procedure_name => l_proc_name
421: );

Line 455: -- Standard Beginning of Procedure/Function Logging

451: l_return_status VARCHAR2(1);
452: l_debug_info VARCHAR2(200);
453: l_return_value NUMBER;
454: BEGIN
455: -- Standard Beginning of Procedure/Function Logging
456: INL_LOGGING_PVT.Log_BeginProc(
457: p_module_name => g_module_name,
458: p_procedure_name => l_func_name
459: ) ;

Line 472: -- Standard End of Procedure/Function Logging

468: SELECT party_site_id
469: INTO l_return_value
470: FROM hz_party_sites
471: WHERE party_site_number = p_party_site_number;
472: -- Standard End of Procedure/Function Logging
473: INL_LOGGING_PVT.Log_EndProc(
474: p_module_name => g_module_name,
475: p_procedure_name => l_func_name
476: );

Line 480: -- Standard Expected Error Logging

476: );
477: RETURN l_return_value;
478: EXCEPTION
479: WHEN FND_API.G_EXC_ERROR THEN
480: -- Standard Expected Error Logging
481: INL_LOGGING_PVT.Log_ExpecError (
482: p_module_name => g_module_name,
483: p_procedure_name => l_func_name
484: );

Line 488: -- Standard Unexpected Error Logging

484: );
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: RETURN 0;
487: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
488: -- Standard Unexpected Error Logging
489: INL_LOGGING_PVT.Log_UnexpecError (
490: p_module_name => g_module_name,
491: p_procedure_name => l_func_name
492: );

Line 496: -- Standard Unexpected Error Logging

492: );
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
494: RETURN 0;
495: WHEN OTHERS THEN
496: -- Standard Unexpected Error Logging
497: INL_LOGGING_PVT.Log_UnexpecError (
498: p_module_name => g_module_name,
499: p_procedure_name => l_func_name
500: );

Line 540: -- Standard Beginning of Procedure/Function Logging

536: l_result VARCHAR2(1) := FND_API.G_TRUE;
537: l_return_status VARCHAR2(1) := FND_API.G_TRUE;
538: l_user_defined_ship_num_code VARCHAR2(30);
539: BEGIN
540: -- Standard Beginning of Procedure/Function Logging
541: INL_LOGGING_PVT.Log_BeginProc(
542: p_module_name => g_module_name,
543: p_procedure_name => l_func_name
544: ) ;

Line 606: -- Standard End of Procedure/Function Logging

602: END IF;
603: END IF;
604:
605: END IF;
606: -- Standard End of Procedure/Function Logging
607: INL_LOGGING_PVT.Log_EndProc(
608: p_module_name => g_module_name,
609: p_procedure_name => l_func_name
610: );

Line 614: -- Standard Expected Error Logging

610: );
611: RETURN FND_API.to_boolean(l_result) ;
612: EXCEPTION
613: WHEN FND_API.G_EXC_ERROR THEN
614: -- Standard Expected Error Logging
615: INL_LOGGING_PVT.Log_ExpecError (
616: p_module_name => g_module_name,
617: p_procedure_name => l_func_name
618: );

Line 621: -- Standard Unexpected Error Logging

617: p_procedure_name => l_func_name
618: );
619: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
621: -- Standard Unexpected Error Logging
622: INL_LOGGING_PVT.Log_UnexpecError (
623: p_module_name => g_module_name,
624: p_procedure_name => l_func_name
625: );

Line 628: -- Standard Unexpected Error Logging

624: p_procedure_name => l_func_name
625: );
626: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
627: WHEN OTHERS THEN
628: -- Standard Unexpected Error Logging
629: INL_LOGGING_PVT.Log_UnexpecError (
630: p_module_name => g_module_name,
631: p_procedure_name => l_func_name
632: );

Line 671: -- Standard Beginning of Procedure/Function Logging

667: l_return_status VARCHAR2(1) := FND_API.G_TRUE;
668:
669: l_ship_type_code VARCHAR2(400);
670: BEGIN
671: -- Standard Beginning of Procedure/Function Logging
672: INL_LOGGING_PVT.Log_BeginProc(
673: p_module_name => g_module_name,
674: p_procedure_name => l_func_name
675: ) ;

Line 717: -- Standard End of Procedure/Function Logging

713: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
715: END IF;
716: END;
717: -- Standard End of Procedure/Function Logging
718: INL_LOGGING_PVT.Log_EndProc(
719: p_module_name => g_module_name,
720: p_procedure_name => l_func_name
721: );

Line 725: -- Standard Expected Error Logging

721: );
722: RETURN FND_API.to_boolean(l_result) ;
723: EXCEPTION
724: WHEN FND_API.G_EXC_ERROR THEN
725: -- Standard Expected Error Logging
726: INL_LOGGING_PVT.Log_ExpecError (
727: p_module_name => g_module_name,
728: p_procedure_name => l_func_name
729: );

Line 732: -- Standard Unexpected Error Logging

728: p_procedure_name => l_func_name
729: );
730: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
732: -- Standard Unexpected Error Logging
733: INL_LOGGING_PVT.Log_UnexpecError (
734: p_module_name => g_module_name,
735: p_procedure_name => l_func_name
736: );

Line 739: -- Standard Unexpected Error Logging

735: p_procedure_name => l_func_name
736: );
737: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
738: WHEN OTHERS THEN
739: -- Standard Unexpected Error Logging
740: INL_LOGGING_PVT.Log_UnexpecError (
741: p_module_name => g_module_name,
742: p_procedure_name => l_func_name
743: );

Line 786: -- Standard Beginning of Procedure/Function Logging

782: l_return_status VARCHAR2(1) := FND_API.G_TRUE;
783:
784: l_ship_line_type_code VARCHAR2(400);
785: BEGIN
786: -- Standard Beginning of Procedure/Function Logging
787: INL_LOGGING_PVT.Log_BeginProc(
788: p_module_name => g_module_name,
789: p_procedure_name => l_func_name
790: ) ;

Line 838: -- Standard End of Procedure/Function Logging

834: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
836: END IF;
837: END;
838: -- Standard End of Procedure/Function Logging
839: INL_LOGGING_PVT.Log_EndProc(
840: p_module_name => g_module_name,
841: p_procedure_name => l_func_name
842: );

Line 846: -- Standard Expected Error Logging

842: );
843: RETURN FND_API.to_boolean(l_result) ;
844: EXCEPTION
845: WHEN FND_API.G_EXC_ERROR THEN
846: -- Standard Expected Error Logging
847: INL_LOGGING_PVT.Log_ExpecError (
848: p_module_name => g_module_name,
849: p_procedure_name => l_func_name
850: );

Line 853: -- Standard Unexpected Error Logging

849: p_procedure_name => l_func_name
850: );
851: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
853: -- Standard Unexpected Error Logging
854: INL_LOGGING_PVT.Log_UnexpecError (
855: p_module_name => g_module_name,
856: p_procedure_name => l_func_name
857: );

Line 860: -- Standard Unexpected Error Logging

856: p_procedure_name => l_func_name
857: );
858: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
859: WHEN OTHERS THEN
860: -- Standard Unexpected Error Logging
861: INL_LOGGING_PVT.Log_UnexpecError (
862: p_module_name => g_module_name,
863: p_procedure_name => l_func_name
864: );

Line 904: -- Standard Beginning of Procedure/Function Logging

900: l_msg_count NUMBER;
901: l_msg_data VARCHAR2(2000) ;
902: L_SYSDATE CONSTANT DATE := SYSDATE;
903: BEGIN
904: -- Standard Beginning of Procedure/Function Logging
905: INL_LOGGING_PVT.Log_BeginProc(
906: p_module_name => g_module_name,
907: p_procedure_name => l_func_name
908: ) ;

Line 967: -- Standard End of Procedure/Function Logging

963: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
965: END IF;
966: END IF;
967: -- Standard End of Procedure/Function Logging
968: INL_LOGGING_PVT.Log_EndProc(
969: p_module_name => g_module_name,
970: p_procedure_name => l_func_name
971: );

Line 975: -- Standard Expected Error Logging

971: );
972: RETURN FND_API.to_boolean(l_result) ;
973: EXCEPTION
974: WHEN FND_API.G_EXC_ERROR THEN
975: -- Standard Expected Error Logging
976: INL_LOGGING_PVT.Log_ExpecError (
977: p_module_name => g_module_name,
978: p_procedure_name => l_func_name
979: );

Line 982: -- Standard Unexpected Error Logging

978: p_procedure_name => l_func_name
979: );
980: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
982: -- Standard Unexpected Error Logging
983: INL_LOGGING_PVT.Log_UnexpecError (
984: p_module_name => g_module_name,
985: p_procedure_name => l_func_name
986: );

Line 989: -- Standard Unexpected Error Logging

985: p_procedure_name => l_func_name
986: );
987: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
988: WHEN OTHERS THEN
989: -- Standard Unexpected Error Logging
990: INL_LOGGING_PVT.Log_UnexpecError (
991: p_module_name => g_module_name,
992: p_procedure_name => l_func_name
993: );

Line 1033: -- Standard Beginning of Procedure/Function Logging

1029: l_return_status VARCHAR2(1) := FND_API.G_TRUE;
1030: l_msg_count NUMBER;
1031: l_msg_data VARCHAR2(2000) ;
1032: BEGIN
1033: -- Standard Beginning of Procedure/Function Logging
1034: INL_LOGGING_PVT.Log_BeginProc(
1035: p_module_name => g_module_name,
1036: p_procedure_name => l_func_name
1037: ) ;

Line 1124: -- Standard End of Procedure/Function Logging

1120: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1122: END IF;
1123: END IF;
1124: -- Standard End of Procedure/Function Logging
1125: INL_LOGGING_PVT.Log_EndProc(
1126: p_module_name => g_module_name,
1127: p_procedure_name => l_func_name
1128: );

Line 1132: -- Standard Expected Error Logging

1128: );
1129: RETURN FND_API.to_boolean(l_result) ;
1130: EXCEPTION
1131: WHEN FND_API.G_EXC_ERROR THEN
1132: -- Standard Expected Error Logging
1133: INL_LOGGING_PVT.Log_ExpecError (
1134: p_module_name => g_module_name,
1135: p_procedure_name => l_func_name
1136: );

Line 1139: -- Standard Unexpected Error Logging

1135: p_procedure_name => l_func_name
1136: );
1137: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
1138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1139: -- Standard Unexpected Error Logging
1140: INL_LOGGING_PVT.Log_UnexpecError (
1141: p_module_name => g_module_name,
1142: p_procedure_name => l_func_name
1143: );

Line 1146: -- Standard Unexpected Error Logging

1142: p_procedure_name => l_func_name
1143: );
1144: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
1145: WHEN OTHERS THEN
1146: -- Standard Unexpected Error Logging
1147: INL_LOGGING_PVT.Log_UnexpecError (
1148: p_module_name => g_module_name,
1149: p_procedure_name => l_func_name
1150: );

Line 1185: -- Standard Beginning of Procedure/Function Logging

1181: l_debug_info VARCHAR2(400) ;
1182: l_result VARCHAR2(1) := FND_API.G_TRUE;
1183: l_return_status VARCHAR2(1) ;
1184: BEGIN
1185: -- Standard Beginning of Procedure/Function Logging
1186: INL_LOGGING_PVT.Log_BeginProc(
1187: p_module_name => g_module_name,
1188: p_procedure_name => l_func_name
1189: ) ;

Line 1192: -- Standard End of Procedure/Function Logging

1188: p_procedure_name => l_func_name
1189: ) ;
1190: -- Initialize API return status to success
1191: x_return_status := FND_API.G_RET_STS_SUCCESS;
1192: -- Standard End of Procedure/Function Logging
1193: INL_LOGGING_PVT.Log_EndProc(
1194: p_module_name => g_module_name,
1195: p_procedure_name => l_func_name
1196: );

Line 1200: -- Standard Expected Error Logging

1196: );
1197: RETURN FND_API.to_boolean(l_result) ;
1198: EXCEPTION
1199: WHEN FND_API.G_EXC_ERROR THEN
1200: -- Standard Expected Error Logging
1201: INL_LOGGING_PVT.Log_ExpecError (
1202: p_module_name => g_module_name,
1203: p_procedure_name => l_func_name
1204: );

Line 1207: -- Standard Unexpected Error Logging

1203: p_procedure_name => l_func_name
1204: );
1205: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
1206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1207: -- Standard Unexpected Error Logging
1208: INL_LOGGING_PVT.Log_UnexpecError (
1209: p_module_name => g_module_name,
1210: p_procedure_name => l_func_name
1211: );

Line 1214: -- Standard Unexpected Error Logging

1210: p_procedure_name => l_func_name
1211: );
1212: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
1213: WHEN OTHERS THEN
1214: -- Standard Unexpected Error Logging
1215: INL_LOGGING_PVT.Log_UnexpecError (
1216: p_module_name => g_module_name,
1217: p_procedure_name => l_func_name
1218: );

Line 1262: -- Standard Beginning of Procedure/Function Logging

1258: l_aux NUMBER;
1259: l_status VARCHAR2(40) ;
1260: L_TRUNC_SYSDATE CONSTANT DATE := TRUNC(SYSDATE) ;
1261: BEGIN
1262: -- Standard Beginning of Procedure/Function Logging
1263: INL_LOGGING_PVT.Log_BeginProc(
1264: p_module_name => g_module_name,
1265: p_procedure_name => l_func_name
1266: ) ;

Line 1301: -- Standard End of Procedure/Function Logging

1297: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1299: END IF;
1300: END;
1301: -- Standard End of Procedure/Function Logging
1302: INL_LOGGING_PVT.Log_EndProc(
1303: p_module_name => g_module_name,
1304: p_procedure_name => l_func_name
1305: );

Line 1309: -- Standard Expected Error Logging

1305: );
1306: RETURN l_response;
1307: EXCEPTION
1308: WHEN FND_API.G_EXC_ERROR THEN
1309: -- Standard Expected Error Logging
1310: INL_LOGGING_PVT.Log_ExpecError (
1311: p_module_name => g_module_name,
1312: p_procedure_name => l_func_name
1313: );

Line 1316: -- Standard Unexpected Error Logging

1312: p_procedure_name => l_func_name
1313: );
1314: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
1315: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1316: -- Standard Unexpected Error Logging
1317: INL_LOGGING_PVT.Log_UnexpecError (
1318: p_module_name => g_module_name,
1319: p_procedure_name => l_func_name
1320: );

Line 1323: -- Standard Unexpected Error Logging

1319: p_procedure_name => l_func_name
1320: );
1321: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
1322: WHEN OTHERS THEN
1323: -- Standard Unexpected Error Logging
1324: INL_LOGGING_PVT.Log_UnexpecError (
1325: p_module_name => g_module_name,
1326: p_procedure_name => l_func_name
1327: );

Line 1368: -- Standard Beginning of Procedure/Function Logging

1364: l_response BOOLEAN := true;
1365: l_aux NUMBER;
1366: l_status VARCHAR2(40) ;
1367: BEGIN
1368: -- Standard Beginning of Procedure/Function Logging
1369: INL_LOGGING_PVT.Log_BeginProc(
1370: p_module_name => g_module_name,
1371: p_procedure_name => l_func_name
1372: ) ;

Line 1735: -- Standard End of Procedure/Function Logging

1731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1732: END IF;
1733: END IF;
1734: END IF;
1735: -- Standard End of Procedure/Function Logging
1736: INL_LOGGING_PVT.Log_EndProc(
1737: p_module_name => g_module_name,
1738: p_procedure_name => l_func_name
1739: );

Line 1743: -- Standard Expected Error Logging

1739: );
1740: RETURN l_response;
1741: EXCEPTION
1742: WHEN FND_API.G_EXC_ERROR THEN
1743: -- Standard Expected Error Logging
1744: INL_LOGGING_PVT.Log_ExpecError (
1745: p_module_name => g_module_name,
1746: p_procedure_name => l_func_name
1747: );

Line 1750: -- Standard Unexpected Error Logging

1746: p_procedure_name => l_func_name
1747: );
1748: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
1749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1750: -- Standard Unexpected Error Logging
1751: INL_LOGGING_PVT.Log_UnexpecError (
1752: p_module_name => g_module_name,
1753: p_procedure_name => l_func_name
1754: );

Line 1757: -- Standard Unexpected Error Logging

1753: p_procedure_name => l_func_name
1754: );
1755: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
1756: WHEN OTHERS THEN
1757: -- Standard Unexpected Error Logging
1758: INL_LOGGING_PVT.Log_UnexpecError (
1759: p_module_name => g_module_name,
1760: p_procedure_name => l_func_name
1761: );

Line 1810: -- Standard Beginning of Procedure/Function Logging

1806: l_debug_info VARCHAR2(400) ;
1807: l_result VARCHAR2(1) := FND_API.G_TRUE;
1808: l_response BOOLEAN;
1809: BEGIN
1810: -- Standard Beginning of Procedure/Function Logging
1811: INL_LOGGING_PVT.Log_BeginProc(
1812: p_module_name => g_module_name,
1813: p_procedure_name => l_func_name
1814: ) ;

Line 2006: -- Standard End of Procedure/Function Logging

2002: -- If unexpected errors happen abort
2003: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2005: END IF;
2006: -- Standard End of Procedure/Function Logging
2007: INL_LOGGING_PVT.Log_EndProc(
2008: p_module_name => g_module_name,
2009: p_procedure_name => l_func_name
2010: );

Line 2014: -- Standard Expected Error Logging

2010: );
2011: RETURN FND_API.to_boolean(l_result) ;
2012: EXCEPTION
2013: WHEN FND_API.G_EXC_ERROR THEN
2014: -- Standard Expected Error Logging
2015: INL_LOGGING_PVT.Log_ExpecError (
2016: p_module_name => g_module_name,
2017: p_procedure_name => l_func_name
2018: );

Line 2021: -- Standard Unexpected Error Logging

2017: p_procedure_name => l_func_name
2018: );
2019: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
2020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2021: -- Standard Unexpected Error Logging
2022: INL_LOGGING_PVT.Log_UnexpecError (
2023: p_module_name => g_module_name,
2024: p_procedure_name => l_func_name
2025: );

Line 2028: -- Standard Unexpected Error Logging

2024: p_procedure_name => l_func_name
2025: );
2026: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
2027: WHEN OTHERS THEN
2028: -- Standard Unexpected Error Logging
2029: INL_LOGGING_PVT.Log_UnexpecError (
2030: p_module_name => g_module_name,
2031: p_procedure_name => l_func_name
2032: );

Line 2073: -- Standard Beginning of Procedure/Function Logging

2069: l_debug_info VARCHAR2(400) ;
2070: l_result VARCHAR2(1) := FND_API.G_TRUE;
2071: l_response BOOLEAN;
2072: BEGIN
2073: -- Standard Beginning of Procedure/Function Logging
2074: INL_LOGGING_PVT.Log_BeginProc(
2075: p_module_name => g_module_name,
2076: p_procedure_name => l_func_name
2077: ) ;

Line 2132: -- Standard End of Procedure/Function Logging

2128: l_debug_info := l_debug_info||'FALSE';
2129: END IF;
2130:
2131:
2132: -- Standard End of Procedure/Function Logging
2133: INL_LOGGING_PVT.Log_EndProc(
2134: p_module_name => g_module_name,
2135: p_procedure_name => l_func_name
2136: );

Line 2140: -- Standard Expected Error Logging

2136: );
2137: RETURN FND_API.to_boolean(l_result) ;
2138: EXCEPTION
2139: WHEN FND_API.G_EXC_ERROR THEN
2140: -- Standard Expected Error Logging
2141: INL_LOGGING_PVT.Log_ExpecError (
2142: p_module_name => g_module_name,
2143: p_procedure_name => l_func_name
2144: );

Line 2147: -- Standard Unexpected Error Logging

2143: p_procedure_name => l_func_name
2144: );
2145: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
2146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2147: -- Standard Unexpected Error Logging
2148: INL_LOGGING_PVT.Log_UnexpecError (
2149: p_module_name => g_module_name,
2150: p_procedure_name => l_func_name
2151: );

Line 2154: -- Standard Unexpected Error Logging

2150: p_procedure_name => l_func_name
2151: );
2152: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
2153: WHEN OTHERS THEN
2154: -- Standard Unexpected Error Logging
2155: INL_LOGGING_PVT.Log_UnexpecError (
2156: p_module_name => g_module_name,
2157: p_procedure_name => l_func_name
2158: );

Line 2191: -- Standard Beginning of Procedure/Function Logging

2187: ) IS
2188: l_proc_name CONSTANT VARCHAR2(100) := 'Delete_Ship';
2189: l_debug_info VARCHAR2(2000) ;
2190: BEGIN
2191: -- Standard Beginning of Procedure/Function Logging
2192: INL_LOGGING_PVT.Log_BeginProc(
2193: p_module_name => g_module_name,
2194: p_procedure_name => l_proc_name
2195: ) ;

Line 2279: -- Standard End of Procedure/Function Logging

2275: p_procedure_name => l_proc_name,
2276: p_debug_info => l_debug_info
2277: ) ;
2278: DELETE FROM inl.inl_ship_headers_all WHERE ship_header_id = p_ship_header_id;
2279: -- Standard End of Procedure/Function Logging
2280: INL_LOGGING_PVT.Log_EndProc(
2281: p_module_name => g_module_name,
2282: p_procedure_name => l_proc_name
2283: );

Line 2286: -- Standard Expected Error Logging

2282: p_procedure_name => l_proc_name
2283: );
2284: EXCEPTION
2285: WHEN FND_API.G_EXC_ERROR THEN
2286: -- Standard Expected Error Logging
2287: INL_LOGGING_PVT.Log_ExpecError (
2288: p_module_name => g_module_name,
2289: p_procedure_name => l_proc_name
2290: );

Line 2293: -- Standard Unexpected Error Logging

2289: p_procedure_name => l_proc_name
2290: );
2291: x_return_status := FND_API.G_RET_STS_ERROR;
2292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2293: -- Standard Unexpected Error Logging
2294: INL_LOGGING_PVT.Log_UnexpecError (
2295: p_module_name => g_module_name,
2296: p_procedure_name => l_proc_name
2297: );

Line 2300: -- Standard Unexpected Error Logging

2296: p_procedure_name => l_proc_name
2297: );
2298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2299: WHEN OTHERS THEN
2300: -- Standard Unexpected Error Logging
2301: INL_LOGGING_PVT.Log_UnexpecError (
2302: p_module_name => g_module_name,
2303: p_procedure_name => l_proc_name
2304: );

Line 2403: -- Standard Beginning of Procedure/Function Logging

2399: l_proc_name CONSTANT VARCHAR2(100) := 'Import_Headers';
2400: l_debug_info VARCHAR2(2000) ;
2401: l_return_status VARCHAR2(1) ;
2402: BEGIN
2403: -- Standard Beginning of Procedure/Function Logging
2404: INL_LOGGING_PVT.Log_BeginProc(
2405: p_module_name => g_module_name,
2406: p_procedure_name => l_proc_name
2407: ) ;

Line 2658: -- Standard End of Procedure/Function Logging

2654: program_application_id = fnd_global.prog_appl_id
2655: WHERE ship_header_int_id = validHeaders_List(iHead).ship_header_int_id;
2656: END LOOP;
2657: END IF;
2658: -- Standard End of Procedure/Function Logging
2659: INL_LOGGING_PVT.Log_EndProc(
2660: p_module_name => g_module_name,
2661: p_procedure_name => l_proc_name
2662: );

Line 2665: -- Standard Expected Error Logging

2661: p_procedure_name => l_proc_name
2662: );
2663: EXCEPTION
2664: WHEN FND_API.G_EXC_ERROR THEN
2665: -- Standard Expected Error Logging
2666: INL_LOGGING_PVT.Log_ExpecError (
2667: p_module_name => g_module_name,
2668: p_procedure_name => l_proc_name
2669: );

Line 2672: -- Standard Unexpected Error Logging

2668: p_procedure_name => l_proc_name
2669: );
2670: x_return_status := FND_API.G_RET_STS_ERROR;
2671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2672: -- Standard Unexpected Error Logging
2673: INL_LOGGING_PVT.Log_UnexpecError (
2674: p_module_name => g_module_name,
2675: p_procedure_name => l_proc_name
2676: );

Line 2679: -- Standard Unexpected Error Logging

2675: p_procedure_name => l_proc_name
2676: );
2677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2678: WHEN OTHERS THEN
2679: -- Standard Unexpected Error Logging
2680: INL_LOGGING_PVT.Log_UnexpecError (
2681: p_module_name => g_module_name,
2682: p_procedure_name => l_proc_name
2683: );

Line 2718: -- Standard Beginning of Procedure/Function Logging

2714: IS
2715: l_proc_name CONSTANT VARCHAR2(100) := 'Handle_LineGroups';
2716: l_debug_info VARCHAR2(2000) ;
2717: BEGIN
2718: -- Standard Beginning of Procedure/Function Logging
2719: INL_LOGGING_PVT.Log_BeginProc(
2720: p_module_name => g_module_name,
2721: p_procedure_name => l_proc_name
2722: ) ;

Line 2912: -- Standard End of Procedure/Function Logging

2908: ) ;
2909:
2910: END;
2911: END IF;
2912: -- Standard End of Procedure/Function Logging
2913: INL_LOGGING_PVT.Log_EndProc(
2914: p_module_name => g_module_name,
2915: p_procedure_name => l_proc_name
2916: );

Line 2919: -- Standard Expected Error Logging

2915: p_procedure_name => l_proc_name
2916: );
2917: EXCEPTION
2918: WHEN FND_API.G_EXC_ERROR THEN
2919: -- Standard Expected Error Logging
2920: INL_LOGGING_PVT.Log_ExpecError (
2921: p_module_name => g_module_name,
2922: p_procedure_name => l_proc_name
2923: );

Line 2926: -- Standard Unexpected Error Logging

2922: p_procedure_name => l_proc_name
2923: );
2924: x_return_status := FND_API.G_RET_STS_ERROR;
2925: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2926: -- Standard Unexpected Error Logging
2927: INL_LOGGING_PVT.Log_UnexpecError (
2928: p_module_name => g_module_name,
2929: p_procedure_name => l_proc_name
2930: );

Line 2933: -- Standard Unexpected Error Logging

2929: p_procedure_name => l_proc_name
2930: );
2931: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2932: WHEN OTHERS THEN
2933: -- Standard Unexpected Error Logging
2934: INL_LOGGING_PVT.Log_UnexpecError (
2935: p_module_name => g_module_name,
2936: p_procedure_name => l_proc_name
2937: );

Line 2999: -- Standard Beginning of Procedure/Function Logging

2995: l_debug_info VARCHAR2(2000);
2996: l_return_status VARCHAR2(1);
2997: l_ship_line_id NUMBER;
2998: BEGIN
2999: -- Standard Beginning of Procedure/Function Logging
3000: INL_LOGGING_PVT.Log_BeginProc(
3001: p_module_name => g_module_name,
3002: p_procedure_name => l_proc_name
3003: ) ;

Line 3359: -- Standard End of Procedure/Function Logging

3355: END LOOP;
3356: END IF;
3357: END LOOP;
3358: END IF;
3359: -- Standard End of Procedure/Function Logging
3360: INL_LOGGING_PVT.Log_EndProc(
3361: p_module_name => g_module_name,
3362: p_procedure_name => l_proc_name
3363: );

Line 3366: -- Standard Expected Error Logging

3362: p_procedure_name => l_proc_name
3363: );
3364: EXCEPTION
3365: WHEN FND_API.G_EXC_ERROR THEN
3366: -- Standard Expected Error Logging
3367: INL_LOGGING_PVT.Log_ExpecError (
3368: p_module_name => g_module_name,
3369: p_procedure_name => l_proc_name
3370: );

Line 3373: -- Standard Unexpected Error Logging

3369: p_procedure_name => l_proc_name
3370: );
3371: x_return_status := FND_API.G_RET_STS_ERROR;
3372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3373: -- Standard Unexpected Error Logging
3374: INL_LOGGING_PVT.Log_UnexpecError (
3375: p_module_name => g_module_name,
3376: p_procedure_name => l_proc_name
3377: );

Line 3380: -- Standard Unexpected Error Logging

3376: p_procedure_name => l_proc_name
3377: );
3378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3379: WHEN OTHERS THEN
3380: -- Standard Unexpected Error Logging
3381: INL_LOGGING_PVT.Log_UnexpecError (
3382: p_module_name => g_module_name,
3383: p_procedure_name => l_proc_name
3384: );

Line 3427: -- Standard Beginning of Procedure/Function Logging

3423: l_proc_name CONSTANT VARCHAR2(100) := 'Set_existingMatchInfoFlag';
3424: l_debug_info VARCHAR2(2000) ;
3425: l_return_status VARCHAR2(1) ;
3426: BEGIN
3427: -- Standard Beginning of Procedure/Function Logging
3428: INL_LOGGING_PVT.Log_BeginProc(
3429: p_module_name => g_module_name,
3430: p_procedure_name => l_proc_name) ;
3431: -- Initialize API return status to success

Line 3453: -- Standard End of Procedure/Function Logging

3449: x_existing_match_info_flag:='Y';
3450: ELSE
3451: x_existing_match_info_flag:='N';
3452: END IF;
3453: -- Standard End of Procedure/Function Logging
3454: INL_logging_pvt.Log_EndProc(
3455: p_module_name => g_module_name,
3456: p_procedure_name => l_proc_name
3457: );

Line 3460: -- Standard Expected Error Logging

3456: p_procedure_name => l_proc_name
3457: );
3458: EXCEPTION
3459: WHEN FND_API.G_EXC_ERROR THEN
3460: -- Standard Expected Error Logging
3461: INL_LOGGING_PVT.Log_ExpecError (
3462: p_module_name => g_module_name,
3463: p_procedure_name => l_proc_name
3464: );

Line 3467: -- Standard Unexpected Error Logging

3463: p_procedure_name => l_proc_name
3464: );
3465: x_return_status := FND_API.G_RET_STS_ERROR;
3466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3467: -- Standard Unexpected Error Logging
3468: INL_LOGGING_PVT.Log_UnexpecError (
3469: p_module_name => g_module_name,
3470: p_procedure_name => l_proc_name
3471: );

Line 3474: -- Standard Unexpected Error Logging

3470: p_procedure_name => l_proc_name
3471: );
3472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3473: WHEN OTHERS THEN
3474: -- Standard Unexpected Error Logging
3475: INL_LOGGING_PVT.Log_UnexpecError (
3476: p_module_name => g_module_name,
3477: p_procedure_name => l_proc_name
3478: );

Line 3567: -- Standard Beginning of Procedure/Function Logging

3563: l_corr_from_parent_table_id NUMBER;
3564: l_currency_conversion_rate NUMBER;
3565:
3566: BEGIN
3567: -- Standard Beginning of Procedure/Function Logging
3568: INL_LOGGING_PVT.Log_BeginProc(
3569: p_module_name => g_module_name,
3570: p_procedure_name => l_proc_name) ;
3571:

Line 3911: -- Standard End of Procedure/Function Logging

3907: FROM inl_matches
3908: WHERE match_id = l_mat_par_mat_id_P;
3909: END IF;
3910: --
3911: -- Standard End of Procedure/Function Logging
3912: INL_logging_pvt.Log_EndProc(
3913: p_module_name => g_module_name,
3914: p_procedure_name => l_proc_name
3915: );

Line 3918: -- Standard Expected Error Logging

3914: p_procedure_name => l_proc_name
3915: );
3916: EXCEPTION
3917: WHEN FND_API.G_EXC_ERROR THEN
3918: -- Standard Expected Error Logging
3919: INL_LOGGING_PVT.Log_ExpecError (
3920: p_module_name => g_module_name,
3921: p_procedure_name => l_proc_name
3922: );

Line 3925: -- Standard Unexpected Error Logging

3921: p_procedure_name => l_proc_name
3922: );
3923: x_return_status := FND_API.G_RET_STS_ERROR;
3924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3925: -- Standard Unexpected Error Logging
3926: INL_LOGGING_PVT.Log_UnexpecError (
3927: p_module_name => g_module_name,
3928: p_procedure_name => l_proc_name
3929: );

Line 3932: -- Standard Unexpected Error Logging

3928: p_procedure_name => l_proc_name
3929: );
3930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3931: WHEN OTHERS THEN
3932: -- Standard Unexpected Error Logging
3933: INL_LOGGING_PVT.Log_UnexpecError (
3934: p_module_name => g_module_name,
3935: p_procedure_name => l_proc_name
3936: );

Line 4039: -- Standard Beginning of Procedure/Function Logging

4035: l_matched_curr_conversion_type VARCHAR2(30);
4036: l_matched_curr_conversion_date DATE;
4037: l_matched_curr_conversion_rate NUMBER;
4038: BEGIN
4039: -- Standard Beginning of Procedure/Function Logging
4040: INL_LOGGING_PVT.Log_BeginProc(
4041: p_module_name => g_module_name,
4042: p_procedure_name => l_proc_name
4043: ) ;

Line 4353: -- Standard End of Procedure/Function Logging

4349: m.program_application_id = fnd_global.prog_appl_id
4350: WHERE m.match_int_id = matchesToProcess_List(iMatch) .match_int_id;
4351: END LOOP;
4352: END IF;
4353: -- Standard End of Procedure/Function Logging
4354: INL_LOGGING_PVT.Log_EndProc(
4355: p_module_name => g_module_name,
4356: p_procedure_name => l_proc_name
4357: );

Line 4360: -- Standard Expected Error Logging

4356: p_procedure_name => l_proc_name
4357: );
4358: EXCEPTION
4359: WHEN FND_API.G_EXC_ERROR THEN
4360: -- Standard Expected Error Logging
4361: INL_LOGGING_PVT.Log_ExpecError (
4362: p_module_name => g_module_name,
4363: p_procedure_name => l_proc_name
4364: );

Line 4367: -- Standard Unexpected Error Logging

4363: p_procedure_name => l_proc_name
4364: );
4365: x_return_status := FND_API.G_RET_STS_ERROR;
4366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4367: -- Standard Unexpected Error Logging
4368: INL_LOGGING_PVT.Log_UnexpecError (
4369: p_module_name => g_module_name,
4370: p_procedure_name => l_proc_name
4371: );

Line 4374: -- Standard Unexpected Error Logging

4370: p_procedure_name => l_proc_name
4371: );
4372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4373: WHEN OTHERS THEN
4374: -- Standard Unexpected Error Logging
4375: INL_LOGGING_PVT.Log_UnexpecError (
4376: p_module_name => g_module_name,
4377: p_procedure_name => l_proc_name
4378: );

Line 4416: -- Standard Beginning of Procedure/Function Logging

4412: l_debug_info VARCHAR2(200) ;
4413: l_updated_flag VARCHAR2(1) ;
4414: l_return_status VARCHAR2(1) ;
4415: BEGIN
4416: -- Standard Beginning of Procedure/Function Logging
4417: INL_LOGGING_PVT.Log_BeginProc(
4418: p_module_name => g_module_name,
4419: p_procedure_name => l_proc_name
4420: ) ;

Line 4434: -- Standard End of Procedure/Function Logging

4430: AND hou.organization_id = sh.organization_id
4431: )
4432: WHERE sh.ship_header_int_id = p_ship_header_int_id
4433: AND sh.location_id IS NULL;
4434: -- Standard End of Procedure/Function Logging
4435: INL_LOGGING_PVT.Log_EndProc(
4436: p_module_name => g_module_name,
4437: p_procedure_name => l_proc_name
4438: );

Line 4441: -- Standard Expected Error Logging

4437: p_procedure_name => l_proc_name
4438: );
4439: EXCEPTION
4440: WHEN FND_API.G_EXC_ERROR THEN
4441: -- Standard Expected Error Logging
4442: INL_LOGGING_PVT.Log_ExpecError (
4443: p_module_name => g_module_name,
4444: p_procedure_name => l_proc_name
4445: );

Line 4448: -- Standard Unexpected Error Logging

4444: p_procedure_name => l_proc_name
4445: );
4446: x_return_status := FND_API.G_RET_STS_ERROR;
4447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4448: -- Standard Unexpected Error Logging
4449: INL_LOGGING_PVT.Log_UnexpecError (
4450: p_module_name => g_module_name,
4451: p_procedure_name => l_proc_name
4452: );

Line 4455: -- Standard Unexpected Error Logging

4451: p_procedure_name => l_proc_name
4452: );
4453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4454: WHEN OTHERS THEN
4455: -- Standard Unexpected Error Logging
4456: INL_LOGGING_PVT.Log_UnexpecError (
4457: p_module_name => g_module_name,
4458: p_procedure_name => l_proc_name
4459: );

Line 4551: -- Standard Beginning of Procedure/Function Logging

4547: AND processing_status_code = 'PENDING'; --'ERROR' IN CASE OF FAIL
4548: TYPE toDeriveLines_List_Type IS TABLE OF toDeriveLines%ROWTYPE;
4549: toDeriveLines_List toDeriveLines_List_Type ;
4550: BEGIN
4551: -- Standard Beginning of Procedure/Function Logging
4552: INL_LOGGING_PVT.Log_BeginProc(
4553: p_module_name => g_module_name,
4554: p_procedure_name => l_proc_name
4555: ) ;

Line 4648: -- Standard End of Procedure/Function Logging

4644: WHERE ship_line_int_id = toDeriveLines_list(i) .ship_line_int_id;
4645: END IF;
4646: END LOOP;
4647: END IF;
4648: -- Standard End of Procedure/Function Logging
4649: INL_LOGGING_PVT.Log_EndProc(
4650: p_module_name => g_module_name,
4651: p_procedure_name => l_proc_name
4652: );

Line 4655: -- Standard Expected Error Logging

4651: p_procedure_name => l_proc_name
4652: );
4653: EXCEPTION
4654: WHEN FND_API.G_EXC_ERROR THEN
4655: -- Standard Expected Error Logging
4656: INL_LOGGING_PVT.Log_ExpecError (
4657: p_module_name => g_module_name,
4658: p_procedure_name => l_proc_name
4659: );

Line 4662: -- Standard Unexpected Error Logging

4658: p_procedure_name => l_proc_name
4659: );
4660: x_return_status := FND_API.G_RET_STS_ERROR;
4661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4662: -- Standard Unexpected Error Logging
4663: INL_LOGGING_PVT.Log_UnexpecError (
4664: p_module_name => g_module_name,
4665: p_procedure_name => l_proc_name
4666: );

Line 4669: -- Standard Unexpected Error Logging

4665: p_procedure_name => l_proc_name
4666: );
4667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4668: WHEN OTHERS THEN
4669: -- Standard Unexpected Error Logging
4670: INL_LOGGING_PVT.Log_UnexpecError (
4671: p_module_name => g_module_name,
4672: p_procedure_name => l_proc_name
4673: );

Line 4719: -- Standard Beginning of Procedure/Function Logging

4715: l_debug_info VARCHAR2(200) ;
4716: l_return_status VARCHAR2(1) ;
4717: BEGIN
4718:
4719: -- Standard Beginning of Procedure/Function Logging
4720: INL_LOGGING_PVT.Log_BeginProc(
4721: p_module_name => g_module_name,
4722: p_procedure_name => l_proc_name
4723: ) ;

Line 4770: -- Standard End of Procedure/Function Logging

4766: AND from_parent_table_name = p_to_parent_table_name
4767: ;
4768: END IF;
4769:
4770: -- Standard End of Procedure/Function Logging
4771: INL_LOGGING_PVT.Log_EndProc(
4772: p_module_name => g_module_name,
4773: p_procedure_name => l_proc_name
4774: );

Line 4777: -- Standard Expected Error Logging

4773: p_procedure_name => l_proc_name
4774: );
4775: EXCEPTION
4776: WHEN FND_API.G_EXC_ERROR THEN
4777: -- Standard Expected Error Logging
4778: INL_LOGGING_PVT.Log_ExpecError (
4779: p_module_name => g_module_name,
4780: p_procedure_name => l_proc_name
4781: );

Line 4784: -- Standard Unexpected Error Logging

4780: p_procedure_name => l_proc_name
4781: );
4782: x_return_status := FND_API.G_RET_STS_ERROR;
4783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4784: -- Standard Unexpected Error Logging
4785: INL_LOGGING_PVT.Log_UnexpecError (
4786: p_module_name => g_module_name,
4787: p_procedure_name => l_proc_name
4788: );

Line 4791: -- Standard Unexpected Error Logging

4787: p_procedure_name => l_proc_name
4788: );
4789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4790: WHEN OTHERS THEN
4791: -- Standard Unexpected Error Logging
4792: INL_LOGGING_PVT.Log_UnexpecError (
4793: p_module_name => g_module_name,
4794: p_procedure_name => l_proc_name
4795: );

Line 4837: -- Standard Beginning of Procedure/Function Logging

4833: l_debug_info VARCHAR2(400) ;
4834: l_return_status VARCHAR2(1) ;
4835: l_result VARCHAR2(1) := FND_API.G_TRUE;
4836: BEGIN
4837: -- Standard Beginning of Procedure/Function Logging
4838: INL_LOGGING_PVT.Log_BeginProc(
4839: p_module_name => g_module_name,
4840: p_procedure_name => l_func_name
4841: ) ;

Line 4892: -- Standard End of Procedure/Function Logging

4888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4889: END IF;
4890: END IF;
4891: END IF;
4892: -- Standard End of Procedure/Function Logging
4893: INL_LOGGING_PVT.Log_EndProc(
4894: p_module_name => g_module_name,
4895: p_procedure_name => l_func_name
4896: );

Line 4900: -- Standard Expected Error Logging

4896: );
4897: RETURN FND_API.to_boolean(l_result) ;
4898: EXCEPTION
4899: WHEN FND_API.G_EXC_ERROR THEN
4900: -- Standard Expected Error Logging
4901: INL_LOGGING_PVT.Log_ExpecError (
4902: p_module_name => g_module_name,
4903: p_procedure_name => l_func_name
4904: );

Line 4907: -- Standard Unexpected Error Logging

4903: p_procedure_name => l_func_name
4904: );
4905: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
4906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4907: -- Standard Unexpected Error Logging
4908: INL_LOGGING_PVT.Log_UnexpecError (
4909: p_module_name => g_module_name,
4910: p_procedure_name => l_func_name
4911: );

Line 4914: -- Standard Unexpected Error Logging

4910: p_procedure_name => l_func_name
4911: );
4912: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
4913: WHEN OTHERS THEN
4914: -- Standard Unexpected Error Logging
4915: INL_LOGGING_PVT.Log_UnexpecError (
4916: p_module_name => g_module_name,
4917: p_procedure_name => l_func_name
4918: );

Line 4959: -- Standard Beginning of Procedure/Function Logging

4955: l_debug_info VARCHAR2(400) ;
4956: l_return_status VARCHAR2(1) ;
4957: l_result VARCHAR2(1) := FND_API.G_TRUE;
4958: BEGIN
4959: -- Standard Beginning of Procedure/Function Logging
4960: INL_LOGGING_PVT.Log_BeginProc(
4961: p_module_name => g_module_name,
4962: p_procedure_name => l_func_name
4963: ) ;

Line 4991: -- Standard End of Procedure/Function Logging

4987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4988: END IF;
4989: END IF;
4990: END IF;
4991: -- Standard End of Procedure/Function Logging
4992: INL_LOGGING_PVT.Log_EndProc(
4993: p_module_name => g_module_name,
4994: p_procedure_name => l_func_name
4995: );

Line 4999: -- Standard Expected Error Logging

4995: );
4996: RETURN FND_API.to_boolean(l_result) ;
4997: EXCEPTION
4998: WHEN FND_API.G_EXC_ERROR THEN
4999: -- Standard Expected Error Logging
5000: INL_LOGGING_PVT.Log_ExpecError (
5001: p_module_name => g_module_name,
5002: p_procedure_name => l_func_name
5003: );

Line 5006: -- Standard Unexpected Error Logging

5002: p_procedure_name => l_func_name
5003: );
5004: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
5005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5006: -- Standard Unexpected Error Logging
5007: INL_LOGGING_PVT.Log_UnexpecError (
5008: p_module_name => g_module_name,
5009: p_procedure_name => l_func_name
5010: );

Line 5013: -- Standard Unexpected Error Logging

5009: p_procedure_name => l_func_name
5010: );
5011: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
5012: WHEN OTHERS THEN
5013: -- Standard Unexpected Error Logging
5014: INL_LOGGING_PVT.Log_UnexpecError (
5015: p_module_name => g_module_name,
5016: p_procedure_name => l_func_name
5017: );

Line 5125: -- Standard Beginning of Procedure/Function Logging

5121: OI_matches_qty NUMBER;
5122: OI_matches_UOM_code VARCHAR2(3);
5123: OI_match_type_code VARCHAR2(30);
5124: BEGIN
5125: -- Standard Beginning of Procedure/Function Logging
5126: INL_LOGGING_PVT.Log_BeginProc(
5127: p_module_name => g_module_name,
5128: p_procedure_name => l_func_name
5129: ) ;

Line 5474: -- Standard End of Procedure/Function Logging

5470: p_module_name => g_module_name,
5471: p_procedure_name => l_func_name,
5472: p_debug_info => l_debug_info
5473: );
5474: -- Standard End of Procedure/Function Logging
5475: INL_LOGGING_PVT.Log_EndProc(
5476: p_module_name => g_module_name,
5477: p_procedure_name => l_func_name
5478: );

Line 5482: -- Standard Expected Error Logging

5478: );
5479: RETURN FND_API.to_boolean(l_result) ;
5480: EXCEPTION
5481: WHEN FND_API.G_EXC_ERROR THEN
5482: -- Standard Expected Error Logging
5483: INL_LOGGING_PVT.Log_ExpecError (
5484: p_module_name => g_module_name,
5485: p_procedure_name => l_func_name
5486: );

Line 5489: -- Standard Unexpected Error Logging

5485: p_procedure_name => l_func_name
5486: );
5487: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
5488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5489: -- Standard Unexpected Error Logging
5490: INL_LOGGING_PVT.Log_UnexpecError (
5491: p_module_name => g_module_name,
5492: p_procedure_name => l_func_name
5493: );

Line 5496: -- Standard Unexpected Error Logging

5492: p_procedure_name => l_func_name
5493: );
5494: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
5495: WHEN OTHERS THEN
5496: -- Standard Unexpected Error Logging
5497: INL_LOGGING_PVT.Log_UnexpecError (
5498: p_module_name => g_module_name,
5499: p_procedure_name => l_func_name
5500: );

Line 5545: -- Standard Beginning of Procedure/Function Logging

5541: l_debug_info VARCHAR2(400) ;
5542: l_return_status VARCHAR2(1) ;
5543: l_result VARCHAR2(1) := FND_API.G_TRUE;
5544: BEGIN
5545: -- Standard Beginning of Procedure/Function Logging
5546: INL_LOGGING_PVT.Log_BeginProc(
5547: p_module_name => g_module_name,
5548: p_procedure_name => l_func_name
5549: ) ;

Line 5649: -- Standard End of Procedure/Function Logging

5645: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5647: END IF;
5648: END IF;
5649: -- Standard End of Procedure/Function Logging
5650: INL_LOGGING_PVT.Log_EndProc(
5651: p_module_name => g_module_name,
5652: p_procedure_name => l_func_name
5653: );

Line 5657: -- Standard Expected Error Logging

5653: );
5654: RETURN FND_API.to_boolean(l_result) ;
5655: EXCEPTION
5656: WHEN FND_API.G_EXC_ERROR THEN
5657: -- Standard Expected Error Logging
5658: INL_LOGGING_PVT.Log_ExpecError (
5659: p_module_name => g_module_name,
5660: p_procedure_name => l_func_name
5661: );

Line 5664: -- Standard Unexpected Error Logging

5660: p_procedure_name => l_func_name
5661: );
5662: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
5663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5664: -- Standard Unexpected Error Logging
5665: INL_LOGGING_PVT.Log_UnexpecError (
5666: p_module_name => g_module_name,
5667: p_procedure_name => l_func_name
5668: );

Line 5671: -- Standard Unexpected Error Logging

5667: p_procedure_name => l_func_name
5668: );
5669: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
5670: WHEN OTHERS THEN
5671: -- Standard Unexpected Error Logging
5672: INL_LOGGING_PVT.Log_UnexpecError (
5673: p_module_name => g_module_name,
5674: p_procedure_name => l_func_name
5675: );

Line 5726: -- Standard Beginning of Procedure/Function Logging

5722: l_debug_info VARCHAR2(400) ;
5723: l_return_status VARCHAR2(1) ;
5724: l_result VARCHAR2(1) := FND_API.G_TRUE;
5725: BEGIN
5726: -- Standard Beginning of Procedure/Function Logging
5727: INL_LOGGING_PVT.Log_BeginProc(
5728: p_module_name => g_module_name,
5729: p_procedure_name => l_func_name
5730: ) ;

Line 5788: -- Standard End of Procedure/Function Logging

5784: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5786: END IF;
5787: END IF;
5788: -- Standard End of Procedure/Function Logging
5789: INL_LOGGING_PVT.Log_EndProc(
5790: p_module_name => g_module_name,
5791: p_procedure_name => l_func_name
5792: );

Line 5796: -- Standard Expected Error Logging

5792: );
5793: RETURN FND_API.to_boolean(l_result) ;
5794: EXCEPTION
5795: WHEN FND_API.G_EXC_ERROR THEN
5796: -- Standard Expected Error Logging
5797: INL_LOGGING_PVT.Log_ExpecError (
5798: p_module_name => g_module_name,
5799: p_procedure_name => l_func_name
5800: );

Line 5803: -- Standard Unexpected Error Logging

5799: p_procedure_name => l_func_name
5800: );
5801: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
5802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5803: -- Standard Unexpected Error Logging
5804: INL_LOGGING_PVT.Log_UnexpecError (
5805: p_module_name => g_module_name,
5806: p_procedure_name => l_func_name
5807: );

Line 5810: -- Standard Unexpected Error Logging

5806: p_procedure_name => l_func_name
5807: );
5808: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
5809: WHEN OTHERS THEN
5810: -- Standard Unexpected Error Logging
5811: INL_LOGGING_PVT.Log_UnexpecError (
5812: p_module_name => g_module_name,
5813: p_procedure_name => l_func_name
5814: );

Line 5854: -- Standard Beginning of Procedure/Function Logging

5850: l_return_status VARCHAR2(1) ;
5851: l_result VARCHAR2(1) := FND_API.G_TRUE;
5852: l_uom VARCHAR2(100) ;
5853: BEGIN
5854: -- Standard Beginning of Procedure/Function Logging
5855: INL_LOGGING_PVT.Log_BeginProc(
5856: p_module_name => g_module_name,
5857: p_procedure_name => l_func_name
5858: ) ;

Line 5936: -- Standard End of Procedure/Function Logging

5932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5933: END IF;
5934: END IF;
5935: END IF;
5936: -- Standard End of Procedure/Function Logging
5937: INL_LOGGING_PVT.Log_EndProc(
5938: p_module_name => g_module_name,
5939: p_procedure_name => l_func_name
5940: );

Line 5944: -- Standard Expected Error Logging

5940: );
5941: RETURN FND_API.to_boolean(l_result) ;
5942: EXCEPTION
5943: WHEN FND_API.G_EXC_ERROR THEN
5944: -- Standard Expected Error Logging
5945: INL_LOGGING_PVT.Log_ExpecError (
5946: p_module_name => g_module_name,
5947: p_procedure_name => l_func_name
5948: );

Line 5951: -- Standard Unexpected Error Logging

5947: p_procedure_name => l_func_name
5948: );
5949: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
5950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5951: -- Standard Unexpected Error Logging
5952: INL_LOGGING_PVT.Log_UnexpecError (
5953: p_module_name => g_module_name,
5954: p_procedure_name => l_func_name
5955: );

Line 5958: -- Standard Unexpected Error Logging

5954: p_procedure_name => l_func_name
5955: );
5956: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
5957: WHEN OTHERS THEN
5958: -- Standard Unexpected Error Logging
5959: INL_LOGGING_PVT.Log_UnexpecError (
5960: p_module_name => g_module_name,
5961: p_procedure_name => l_func_name
5962: );

Line 6006: -- Standard Beginning of Procedure/Function Logging

6002: l_return_status VARCHAR2(1) ;
6003: l_result VARCHAR2(1) := FND_API.G_TRUE;
6004: l_adj_alr_gen_flag VARCHAR2(1) ;
6005: BEGIN
6006: -- Standard Beginning of Procedure/Function Logging
6007: INL_LOGGING_PVT.Log_BeginProc(
6008: p_module_name => g_module_name,
6009: p_procedure_name => l_func_name
6010: ) ;

Line 6170: -- Standard End of Procedure/Function Logging

6166: END;
6167: END IF;
6168: END IF;
6169: END IF;
6170: -- Standard End of Procedure/Function Logging
6171: INL_LOGGING_PVT.Log_EndProc(
6172: p_module_name => g_module_name,
6173: p_procedure_name => l_func_name
6174: );

Line 6178: -- Standard Expected Error Logging

6174: );
6175: RETURN FND_API.to_boolean(l_result) ;
6176: EXCEPTION
6177: WHEN FND_API.G_EXC_ERROR THEN
6178: -- Standard Expected Error Logging
6179: INL_LOGGING_PVT.Log_ExpecError (
6180: p_module_name => g_module_name,
6181: p_procedure_name => l_func_name
6182: );

Line 6185: -- Standard Unexpected Error Logging

6181: p_procedure_name => l_func_name
6182: );
6183: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
6184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6185: -- Standard Unexpected Error Logging
6186: INL_LOGGING_PVT.Log_UnexpecError (
6187: p_module_name => g_module_name,
6188: p_procedure_name => l_func_name
6189: );

Line 6192: -- Standard Unexpected Error Logging

6188: p_procedure_name => l_func_name
6189: );
6190: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
6191: WHEN OTHERS THEN
6192: -- Standard Unexpected Error Logging
6193: INL_LOGGING_PVT.Log_UnexpecError (
6194: p_module_name => g_module_name,
6195: p_procedure_name => l_func_name
6196: );

Line 6251: -- Standard Beginning of Procedure/Function Logging

6247: l_SHidOk VARCHAR2(1) ;
6248: l_INT_importedOk VARCHAR2(1) ;
6249: l_matchTpCdOk VARCHAR2(1) ;
6250: BEGIN
6251: -- Standard Beginning of Procedure/Function Logging
6252: INL_LOGGING_PVT.Log_BeginProc(
6253: p_module_name => g_module_name,
6254: p_procedure_name => l_func_name
6255: ) ;

Line 6523: -- Standard End of Procedure/Function Logging

6519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6520: END IF;
6521: END IF;
6522: END IF;
6523: -- Standard End of Procedure/Function Logging
6524: INL_LOGGING_PVT.Log_EndProc(
6525: p_module_name => g_module_name,
6526: p_procedure_name => l_func_name
6527: );

Line 6531: -- Standard Expected Error Logging

6527: );
6528: RETURN FND_API.to_boolean(l_result) ;
6529: EXCEPTION
6530: WHEN FND_API.G_EXC_ERROR THEN
6531: -- Standard Expected Error Logging
6532: INL_LOGGING_PVT.Log_ExpecError (
6533: p_module_name => g_module_name,
6534: p_procedure_name => l_func_name
6535: );

Line 6538: -- Standard Unexpected Error Logging

6534: p_procedure_name => l_func_name
6535: );
6536: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
6537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6538: -- Standard Unexpected Error Logging
6539: INL_LOGGING_PVT.Log_UnexpecError (
6540: p_module_name => g_module_name,
6541: p_procedure_name => l_func_name
6542: );

Line 6545: -- Standard Unexpected Error Logging

6541: p_procedure_name => l_func_name
6542: );
6543: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
6544: WHEN OTHERS THEN
6545: -- Standard Unexpected Error Logging
6546: INL_LOGGING_PVT.Log_UnexpecError (
6547: p_module_name => g_module_name,
6548: p_procedure_name => l_func_name
6549: );

Line 6595: -- Standard Beginning of Procedure/Function Logging

6591: l_adj_already_generated_flag VARCHAR2(1) ;
6592: l_replace_estim_qty_flag VARCHAR2(1) ;
6593: l_other_REQF_Y_match_id NUMBER;
6594: BEGIN
6595: -- Standard Beginning of Procedure/Function Logging
6596: INL_LOGGING_PVT.Log_BeginProc(
6597: p_module_name => g_module_name,
6598: p_procedure_name => l_func_name
6599: ) ;

Line 6804: -- Standard End of Procedure/Function Logging

6800: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6802: END IF;
6803: END IF;
6804: -- Standard End of Procedure/Function Logging
6805: INL_LOGGING_PVT.Log_EndProc(
6806: p_module_name => g_module_name,
6807: p_procedure_name => l_func_name
6808: );

Line 6812: -- Standard Expected Error Logging

6808: );
6809: RETURN FND_API.to_boolean(l_result) ;
6810: EXCEPTION
6811: WHEN FND_API.G_EXC_ERROR THEN
6812: -- Standard Expected Error Logging
6813: INL_LOGGING_PVT.Log_ExpecError (
6814: p_module_name => g_module_name,
6815: p_procedure_name => l_func_name
6816: );

Line 6819: -- Standard Unexpected Error Logging

6815: p_procedure_name => l_func_name
6816: );
6817: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
6818: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6819: -- Standard Unexpected Error Logging
6820: INL_LOGGING_PVT.Log_UnexpecError (
6821: p_module_name => g_module_name,
6822: p_procedure_name => l_func_name
6823: );

Line 6826: -- Standard Unexpected Error Logging

6822: p_procedure_name => l_func_name
6823: );
6824: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
6825: WHEN OTHERS THEN
6826: -- Standard Unexpected Error Logging
6827: INL_LOGGING_PVT.Log_UnexpecError (
6828: p_module_name => g_module_name,
6829: p_procedure_name => l_func_name
6830: );

Line 6873: -- Standard Beginning of Procedure/Function Logging

6869: l_result VARCHAR2(1) := FND_API.G_TRUE;
6870: l_field VARCHAR2(30) ;
6871: l_field_id NUMBER;
6872: BEGIN
6873: -- Standard Beginning of Procedure/Function Logging
6874: INL_LOGGING_PVT.Log_BeginProc(
6875: p_module_name => g_module_name,
6876: p_procedure_name => l_func_name
6877: ) ;

Line 7024: -- Standard End of Procedure/Function Logging

7020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7021: END IF;
7022: END IF;
7023: END IF;
7024: -- Standard End of Procedure/Function Logging
7025: INL_LOGGING_PVT.Log_EndProc(
7026: p_module_name => g_module_name,
7027: p_procedure_name => l_func_name
7028: );

Line 7032: -- Standard Expected Error Logging

7028: );
7029: RETURN FND_API.to_boolean(l_result) ;
7030: EXCEPTION
7031: WHEN FND_API.G_EXC_ERROR THEN
7032: -- Standard Expected Error Logging
7033: INL_LOGGING_PVT.Log_ExpecError (
7034: p_module_name => g_module_name,
7035: p_procedure_name => l_func_name
7036: );

Line 7039: -- Standard Unexpected Error Logging

7035: p_procedure_name => l_func_name
7036: );
7037: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
7038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7039: -- Standard Unexpected Error Logging
7040: INL_LOGGING_PVT.Log_UnexpecError (
7041: p_module_name => g_module_name,
7042: p_procedure_name => l_func_name
7043: );

Line 7046: -- Standard Unexpected Error Logging

7042: p_procedure_name => l_func_name
7043: );
7044: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
7045: WHEN OTHERS THEN
7046: -- Standard Unexpected Error Logging
7047: INL_LOGGING_PVT.Log_UnexpecError (
7048: p_module_name => g_module_name,
7049: p_procedure_name => l_func_name
7050: );

Line 7088: -- Standard Beginning of Procedure/Function Logging

7084: l_parent_matched_curr_code VARCHAR2(15) ;
7085: l_parent_to_parent_table_name VARCHAR2(100) ;
7086: l_parent_to_parent_table_ID NUMBER;
7087: BEGIN
7088: -- Standard Beginning of Procedure/Function Logging
7089: INL_LOGGING_PVT.Log_BeginProc(
7090: p_module_name => g_module_name,
7091: p_procedure_name => l_func_name
7092: ) ;

Line 7105: -- Standard End of Procedure/Function Logging

7101: -- If unexpected errors happen abort
7102: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7104: END IF;
7105: -- Standard End of Procedure/Function Logging
7106: INL_LOGGING_PVT.Log_EndProc(
7107: p_module_name => g_module_name,
7108: p_procedure_name => l_func_name
7109: );

Line 7113: -- Standard Expected Error Logging

7109: );
7110: RETURN FND_API.to_boolean(x_result) ;
7111: EXCEPTION
7112: WHEN FND_API.G_EXC_ERROR THEN
7113: -- Standard Expected Error Logging
7114: INL_LOGGING_PVT.Log_ExpecError (
7115: p_module_name => g_module_name,
7116: p_procedure_name => l_func_name
7117: );

Line 7120: -- Standard Unexpected Error Logging

7116: p_procedure_name => l_func_name
7117: );
7118: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
7119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7120: -- Standard Unexpected Error Logging
7121: INL_LOGGING_PVT.Log_UnexpecError (
7122: p_module_name => g_module_name,
7123: p_procedure_name => l_func_name
7124: );

Line 7127: -- Standard Unexpected Error Logging

7123: p_procedure_name => l_func_name
7124: );
7125: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
7126: WHEN OTHERS THEN
7127: -- Standard Unexpected Error Logging
7128: INL_LOGGING_PVT.Log_UnexpecError (
7129: p_module_name => g_module_name,
7130: p_procedure_name => l_func_name
7131: );

Line 7169: -- Standard Beginning of Procedure/Function Logging

7165: l_parent_matched_curr_code VARCHAR2(15) ;
7166: l_parent_to_parent_table_name VARCHAR2(100) ;
7167: l_parent_to_parent_table_ID NUMBER;
7168: BEGIN
7169: -- Standard Beginning of Procedure/Function Logging
7170: INL_LOGGING_PVT.Log_BeginProc(
7171: p_module_name => g_module_name,
7172: p_procedure_name => l_func_name
7173: ) ;

Line 7565: -- Standard End of Procedure/Function Logging

7561: -- If unexpected errors happen abort
7562: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7564: END IF;
7565: -- Standard End of Procedure/Function Logging
7566: INL_LOGGING_PVT.Log_EndProc(
7567: p_module_name => g_module_name,
7568: p_procedure_name => l_func_name
7569: );

Line 7573: -- Standard Expected Error Logging

7569: );
7570: RETURN FND_API.to_boolean(x_result) ;
7571: EXCEPTION
7572: WHEN FND_API.G_EXC_ERROR THEN
7573: -- Standard Expected Error Logging
7574: INL_LOGGING_PVT.Log_ExpecError (
7575: p_module_name => g_module_name,
7576: p_procedure_name => l_func_name
7577: );

Line 7580: -- Standard Unexpected Error Logging

7576: p_procedure_name => l_func_name
7577: );
7578: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
7579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7580: -- Standard Unexpected Error Logging
7581: INL_LOGGING_PVT.Log_UnexpecError (
7582: p_module_name => g_module_name,
7583: p_procedure_name => l_func_name
7584: );

Line 7587: -- Standard Unexpected Error Logging

7583: p_procedure_name => l_func_name
7584: );
7585: RETURN FND_API.to_boolean(FND_API.G_FALSE) ;
7586: WHEN OTHERS THEN
7587: -- Standard Unexpected Error Logging
7588: INL_LOGGING_PVT.Log_UnexpecError (
7589: p_module_name => g_module_name,
7590: p_procedure_name => l_func_name
7591: );

Line 7689: -- Standard Beginning of Procedure/Function Logging

7685: l_import_validation BOOLEAN;
7686: l_amt_sum NUMBER;
7687: l_processing_status_code VARCHAR2(30) ;
7688: BEGIN
7689: -- Standard Beginning of Procedure/Function Logging
7690: INL_LOGGING_PVT.Log_BeginProc(
7691: p_module_name => g_module_name,
7692: p_procedure_name => l_proc_name
7693: ) ;

Line 7931: -- Standard End of Procedure/Function Logging

7927: END IF;
7928: END LOOP;
7929: END IF;
7930:
7931: -- Standard End of Procedure/Function Logging
7932: INL_LOGGING_PVT.Log_EndProc(
7933: p_module_name => g_module_name,
7934: p_procedure_name => l_proc_name
7935: );

Line 7938: -- Standard Expected Error Logging

7934: p_procedure_name => l_proc_name
7935: );
7936: EXCEPTION
7937: WHEN FND_API.G_EXC_ERROR THEN
7938: -- Standard Expected Error Logging
7939: INL_LOGGING_PVT.Log_ExpecError (
7940: p_module_name => g_module_name,
7941: p_procedure_name => l_proc_name
7942: );

Line 7945: -- Standard Unexpected Error Logging

7941: p_procedure_name => l_proc_name
7942: );
7943: x_return_status := FND_API.G_RET_STS_ERROR;
7944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7945: -- Standard Unexpected Error Logging
7946: INL_LOGGING_PVT.Log_UnexpecError (
7947: p_module_name => g_module_name,
7948: p_procedure_name => l_proc_name
7949: );

Line 7952: -- Standard Unexpected Error Logging

7948: p_procedure_name => l_proc_name
7949: );
7950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7951: WHEN OTHERS THEN
7952: -- Standard Unexpected Error Logging
7953: INL_LOGGING_PVT.Log_UnexpecError (
7954: p_module_name => g_module_name,
7955: p_procedure_name => l_proc_name
7956: );

Line 7988: -- Standard Beginning of Procedure/Function Logging

7984: l_proc_name CONSTANT VARCHAR2(100) := 'Run_MatchPostProcessor';
7985: l_return_status VARCHAR2(1) ;
7986: l_debug_info VARCHAR2(200) ;
7987: BEGIN
7988: -- Standard Beginning of Procedure/Function Logging
7989: INL_LOGGING_PVT.Log_BeginProc(
7990: p_module_name => g_module_name,
7991: p_procedure_name => l_proc_name
7992: ) ;

Line 8009: -- Standard End of Procedure/Function Logging

8005: RAISE FND_API.G_EXC_ERROR;
8006: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8008: END IF;
8009: -- Standard End of Procedure/Function Logging
8010: INL_LOGGING_PVT.Log_EndProc(
8011: p_module_name => g_module_name,
8012: p_procedure_name => l_proc_name
8013: );

Line 8016: -- Standard Expected Error Logging

8012: p_procedure_name => l_proc_name
8013: );
8014: EXCEPTION
8015: WHEN FND_API.G_EXC_ERROR THEN
8016: -- Standard Expected Error Logging
8017: INL_LOGGING_PVT.Log_ExpecError (
8018: p_module_name => g_module_name,
8019: p_procedure_name => l_proc_name
8020: );

Line 8023: -- Standard Unexpected Error Logging

8019: p_procedure_name => l_proc_name
8020: );
8021: x_return_status := FND_API.G_RET_STS_ERROR;
8022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8023: -- Standard Unexpected Error Logging
8024: INL_LOGGING_PVT.Log_UnexpecError (
8025: p_module_name => g_module_name,
8026: p_procedure_name => l_proc_name
8027: );

Line 8030: -- Standard Unexpected Error Logging

8026: p_procedure_name => l_proc_name
8027: );
8028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8029: WHEN OTHERS THEN
8030: -- Standard Unexpected Error Logging
8031: INL_LOGGING_PVT.Log_UnexpecError (
8032: p_module_name => g_module_name,
8033: p_procedure_name => l_proc_name
8034: );

Line 8130: -- Standard Beginning of Procedure/Function Logging

8126: l_organization_id NUMBER;
8127: l_org_id NUMBER;
8128: l_validation_flag VARCHAR2(1) ;
8129: BEGIN
8130: -- Standard Beginning of Procedure/Function Logging
8131: INL_LOGGING_PVT.Log_BeginProc(
8132: p_module_name => g_module_name,
8133: p_procedure_name => l_proc_name
8134: ) ;

Line 8393: -- Standard End of Procedure/Function Logging

8389: END IF;
8390: END IF;
8391: END LOOP;
8392: END IF;
8393: -- Standard End of Procedure/Function Logging
8394: INL_LOGGING_PVT.Log_EndProc(
8395: p_module_name => g_module_name,
8396: p_procedure_name => l_proc_name
8397: );

Line 8400: -- Standard Expected Error Logging

8396: p_procedure_name => l_proc_name
8397: );
8398: EXCEPTION
8399: WHEN FND_API.G_EXC_ERROR THEN
8400: -- Standard Expected Error Logging
8401: INL_LOGGING_PVT.Log_ExpecError (
8402: p_module_name => g_module_name,
8403: p_procedure_name => l_proc_name
8404: );

Line 8407: -- Standard Unexpected Error Logging

8403: p_procedure_name => l_proc_name
8404: );
8405: x_return_status := FND_API.G_RET_STS_ERROR;
8406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8407: -- Standard Unexpected Error Logging
8408: INL_LOGGING_PVT.Log_UnexpecError (
8409: p_module_name => g_module_name,
8410: p_procedure_name => l_proc_name
8411: );

Line 8414: -- Standard Unexpected Error Logging

8410: p_procedure_name => l_proc_name
8411: );
8412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8413: WHEN OTHERS THEN
8414: -- Standard Unexpected Error Logging
8415: INL_LOGGING_PVT.Log_UnexpecError (
8416: p_module_name => g_module_name,
8417: p_procedure_name => l_proc_name
8418: );

Line 8498: -- Standard Beginning of Procedure/Function Logging

8494: l_msg_count_validate NUMBER;
8495: l_ship_header_id NUMBER;
8496: l_mx_last_task_code VARCHAR2(30) ;
8497: BEGIN
8498: -- Standard Beginning of Procedure/Function Logging
8499: INL_LOGGING_PVT.Log_BeginProc(
8500: p_module_name => g_module_name,
8501: p_procedure_name => l_proc_name
8502: ) ;

Line 8630: -- Standard End of Procedure/Function Logging

8626: END IF;
8627: END LOOP;
8628: END IF;
8629: END IF;
8630: -- Standard End of Procedure/Function Logging
8631: INL_LOGGING_PVT.Log_EndProc(
8632: p_module_name => g_module_name,
8633: p_procedure_name => l_proc_name
8634: );

Line 8637: -- Standard Expected Error Logging

8633: p_procedure_name => l_proc_name
8634: );
8635: EXCEPTION
8636: WHEN FND_API.G_EXC_ERROR THEN
8637: -- Standard Expected Error Logging
8638: INL_LOGGING_PVT.Log_ExpecError (
8639: p_module_name => g_module_name,
8640: p_procedure_name => l_proc_name
8641: );

Line 8644: -- Standard Unexpected Error Logging

8640: p_procedure_name => l_proc_name
8641: );
8642: x_return_status := FND_API.G_RET_STS_ERROR;
8643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8644: -- Standard Unexpected Error Logging
8645: INL_LOGGING_PVT.Log_UnexpecError (
8646: p_module_name => g_module_name,
8647: p_procedure_name => l_proc_name
8648: );

Line 8651: -- Standard Unexpected Error Logging

8647: p_procedure_name => l_proc_name
8648: );
8649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8650: WHEN OTHERS THEN
8651: -- Standard Unexpected Error Logging
8652: INL_LOGGING_PVT.Log_UnexpecError (
8653: p_module_name => g_module_name,
8654: p_procedure_name => l_proc_name
8655: );

Line 8696: -- Standard Beginning of Procedure/Function Logging

8692: l_msg_count NUMBER;
8693: BEGIN
8694: errbuf := NULL;
8695: retcode := 0;
8696: -- Standard Beginning of Procedure/Function Logging
8697: INL_LOGGING_PVT.Log_BeginProc(
8698: p_module_name => g_module_name,
8699: p_procedure_name => l_proc_name
8700: ) ;

Line 8734: -- Standard End of Procedure/Function Logging

8730: RAISE FND_API.G_EXC_ERROR;
8731: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8733: END IF;
8734: -- Standard End of Procedure/Function Logging
8735: INL_LOGGING_PVT.Log_EndProc(
8736: p_module_name => g_module_name,
8737: p_procedure_name => l_proc_name
8738: );

Line 8741: -- Standard Expected Error Logging

8737: p_procedure_name => l_proc_name
8738: );
8739: EXCEPTION
8740: WHEN FND_API.G_EXC_ERROR THEN
8741: -- Standard Expected Error Logging
8742: INL_LOGGING_PVT.Log_ExpecError (
8743: p_module_name => g_module_name,
8744: p_procedure_name => l_proc_name
8745: );

Line 8748: -- Standard Unexpected Error Logging

8744: p_procedure_name => l_proc_name
8745: );
8746: retcode := 1;
8747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8748: -- Standard Unexpected Error Logging
8749: INL_LOGGING_PVT.Log_UnexpecError(
8750: p_module_name => g_module_name,
8751: p_procedure_name => l_proc_name
8752: );

Line 8755: -- Standard Unexpected Error Logging

8751: p_procedure_name => l_proc_name
8752: );
8753: retcode := 2;
8754: WHEN OTHERS THEN
8755: -- Standard Unexpected Error Logging
8756: INL_LOGGING_PVT.Log_UnexpecError(
8757: p_module_name => g_module_name,
8758: p_procedure_name => l_proc_name
8759: );

Line 8799: -- Standard Beginning of Procedure/Function Logging

8795: l_msg_count NUMBER;
8796: l_msg_data VARCHAR2(2000);
8797: l_debug_info VARCHAR2(200);
8798: BEGIN
8799: -- Standard Beginning of Procedure/Function Logging
8800: INL_LOGGING_PVT.Log_BeginProc(
8801: p_module_name => g_module_name,
8802: p_procedure_name => l_api_name
8803: ) ;

Line 8804: -- Standard Start of API savepoint

8800: INL_LOGGING_PVT.Log_BeginProc(
8801: p_module_name => g_module_name,
8802: p_procedure_name => l_api_name
8803: ) ;
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;

Line 8810: -- Standard call to check for call compatibility

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,
8813: p_caller_version_number => p_api_version,
8814: p_api_name => l_api_name,

Line 8855: -- Standard check of p_commit.

8851: RAISE FND_API.G_EXC_ERROR;
8852: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8854: END IF;
8855: -- Standard check of p_commit.
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.

Line 8859: -- Standard call to get message count and if count is 1, get message info.

8855: -- Standard check of p_commit.
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,

Line 8861: -- Standard End of Procedure/Function Logging

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
8865: );

Line 8868: -- Standard Expected Error Logging

8864: p_procedure_name => l_api_name
8865: );
8866: EXCEPTION
8867: WHEN FND_API.G_EXC_ERROR THEN
8868: -- Standard Expected Error Logging
8869: INL_LOGGING_PVT.Log_ExpecError (
8870: p_module_name => g_module_name,
8871: p_procedure_name => l_api_name
8872: );

Line 8881: -- Standard Unexpected Error Logging

8877: p_count => x_msg_count,
8878: p_data => x_msg_data
8879: );
8880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8881: -- Standard Unexpected Error Logging
8882: INL_LOGGING_PVT.Log_UnexpecError (
8883: p_module_name => g_module_name,
8884: p_procedure_name => l_api_name
8885: );

Line 8894: -- Standard Unexpected Error Logging

8890: p_count => x_msg_count,
8891: p_data => x_msg_data
8892: );
8893: WHEN OTHERS THEN
8894: -- Standard Unexpected Error Logging
8895: INL_LOGGING_PVT.Log_UnexpecError (
8896: p_module_name => g_module_name,
8897: p_procedure_name => l_api_name
8898: );

Line 8943: -- Standard Beginning of Procedure/Function Logging

8939: l_msg_count NUMBER;
8940: BEGIN
8941: errbuf := NULL;
8942: retcode := 0;
8943: -- Standard Beginning of Procedure/Function Logging
8944: INL_LOGGING_PVT.Log_BeginProc(
8945: p_module_name => g_module_name,
8946: p_procedure_name => l_proc_name
8947: ) ;

Line 8978: -- Standard End of Procedure/Function Logging

8974: RAISE FND_API.G_EXC_ERROR;
8975: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8977: END IF;
8978: -- Standard End of Procedure/Function Logging
8979: INL_LOGGING_PVT.Log_EndProc(
8980: p_module_name => g_module_name,
8981: p_procedure_name => l_proc_name
8982: );

Line 8985: -- Standard Expected Error Logging

8981: p_procedure_name => l_proc_name
8982: );
8983: EXCEPTION
8984: WHEN FND_API.G_EXC_ERROR THEN
8985: -- Standard Expected Error Logging
8986: INL_LOGGING_PVT.Log_ExpecError (
8987: p_module_name => g_module_name,
8988: p_procedure_name => l_proc_name
8989: );

Line 8992: -- Standard Unexpected Error Logging

8988: p_procedure_name => l_proc_name
8989: );
8990: retcode := 1;
8991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8992: -- Standard Unexpected Error Logging
8993: INL_LOGGING_PVT.Log_UnexpecError(
8994: p_module_name => g_module_name,
8995: p_procedure_name => l_proc_name
8996: );

Line 8999: -- Standard Unexpected Error Logging

8995: p_procedure_name => l_proc_name
8996: );
8997: retcode := 2;
8998: WHEN OTHERS THEN
8999: -- Standard Unexpected Error Logging
9000: INL_LOGGING_PVT.Log_UnexpecError(
9001: p_module_name => g_module_name,
9002: p_procedure_name => l_proc_name
9003: );

Line 9041: -- Standard Beginning of Procedure/Function Logging

9037: l_msg_count NUMBER;
9038: l_msg_data VARCHAR2(2000) ;
9039: l_debug_info VARCHAR2(200) ;
9040: BEGIN
9041: -- Standard Beginning of Procedure/Function Logging
9042: INL_LOGGING_PVT.Log_BeginProc(
9043: p_module_name => g_module_name,
9044: p_procedure_name => l_api_name
9045: ) ;

Line 9047: -- Standard Start of API savepoint

9043: p_module_name => g_module_name,
9044: p_procedure_name => l_api_name
9045: ) ;
9046:
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;

Line 9053: -- Standard call to check for call compatibility

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,
9056: p_caller_version_number => p_api_version,
9057: p_api_name => l_api_name,

Line 9094: -- Standard check of p_commit.

9090: RAISE FND_API.G_EXC_ERROR;
9091: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
9092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9093: END IF;
9094: -- Standard check of p_commit.
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.

Line 9098: -- Standard call to get message count and if count is 1, get message info.

9094: -- Standard check of p_commit.
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

Line 9104: -- Standard End of Procedure/Function Logging

9100: p_encoded => FND_API.g_false,
9101: p_count => x_msg_count,
9102: p_data => x_msg_data
9103: ) ;
9104: -- Standard End of Procedure/Function Logging
9105: INL_LOGGING_PVT.Log_EndProc(
9106: p_module_name => g_module_name,
9107: p_procedure_name => l_api_name
9108: );

Line 9111: -- Standard Expected Error Logging

9107: p_procedure_name => l_api_name
9108: );
9109: EXCEPTION
9110: WHEN FND_API.G_EXC_ERROR THEN
9111: -- Standard Expected Error Logging
9112: INL_LOGGING_PVT.Log_ExpecError (
9113: p_module_name => g_module_name,
9114: p_procedure_name => l_api_name
9115: );

Line 9124: -- Standard Unexpected Error Logging

9120: p_count => x_msg_count,
9121: p_data => x_msg_data
9122: );
9123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9124: -- Standard Unexpected Error Logging
9125: INL_LOGGING_PVT.Log_UnexpecError (
9126: p_module_name => g_module_name,
9127: p_procedure_name => l_api_name
9128: );

Line 9137: -- Standard Unexpected Error Logging

9133: p_count => x_msg_count,
9134: p_data => x_msg_data
9135: );
9136: WHEN OTHERS THEN
9137: -- Standard Unexpected Error Logging
9138: INL_LOGGING_PVT.Log_UnexpecError (
9139: p_module_name => g_module_name,
9140: p_procedure_name => l_api_name
9141: );