[Home] [Help]
275: l_debug_info VARCHAR2(2000) ;
276: l_ship_header_int_id NUMBER;
277: l_error_message VARCHAR2(2000) ;
278: BEGIN
279: -- Standard Beginning of Procedure/Function Logging
280: INL_LOGGING_PVT.Log_BeginProc(
281: p_module_name => g_module_name,
282: p_procedure_name => l_program_name) ;
283: -- Initialize API return status to success
445: L_FND_PROG_APPL_ID, /*27*/
446: SYSDATE, /*28*/
447: L_FND_CONC_REQUEST_ID /*29*/
448: );
449: -- Standard End of Procedure/Function Logging
450: INL_LOGGING_PVT.Log_EndProc(
451: p_module_name => g_module_name,
452: p_procedure_name => l_program_name);
453:
452: p_procedure_name => l_program_name);
453:
454: EXCEPTION
455: WHEN L_FND_EXC_ERROR THEN
456: -- Standard Expected Error Logging
457: INL_LOGGING_PVT.Log_ExpecError (
458: p_module_name => g_module_name,
459: p_procedure_name => l_program_name);
460: x_return_status := L_FND_RET_STS_ERROR;
458: p_module_name => g_module_name,
459: p_procedure_name => l_program_name);
460: x_return_status := L_FND_RET_STS_ERROR;
461: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
462: -- Standard Unexpected Error Logging
463: INL_LOGGING_PVT.Log_UnexpecError (
464: p_module_name => g_module_name,
465: p_procedure_name => l_program_name);
466: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
464: p_module_name => g_module_name,
465: p_procedure_name => l_program_name);
466: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
467: WHEN OTHERS THEN
468: -- Standard Unexpected Error Logging
469: INL_LOGGING_PVT.Log_UnexpecError (
470: p_module_name => g_module_name,
471: p_procedure_name => l_program_name);
472: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
500: l_program_name CONSTANT VARCHAR2(30):= 'Reset_InterfError';
501: l_return_status VARCHAR2(1);
502: l_debug_info VARCHAR2(200);
503: BEGIN
504: -- Standard Beginning of Procedure/Function Logging
505: INL_LOGGING_PVT.Log_BeginProc(
506: p_module_name => g_module_name,
507: p_procedure_name => l_program_name
508: ) ;
517: DELETE
518: FROM inl_interface_errors
519: WHERE parent_table_name = p_parent_table_name
520: AND parent_table_id = p_parent_table_id;
521: -- Standard End of Procedure/Function Logging
522: INL_LOGGING_PVT.Log_EndProc(
523: p_module_name => g_module_name,
524: p_procedure_name => l_program_name);
525: EXCEPTION
523: p_module_name => g_module_name,
524: p_procedure_name => l_program_name);
525: EXCEPTION
526: WHEN L_FND_EXC_ERROR THEN
527: -- Standard Expected Error Logging
528: INL_LOGGING_PVT.Log_ExpecError (
529: p_module_name => g_module_name,
530: p_procedure_name => l_program_name);
531: x_return_status := L_FND_RET_STS_ERROR;
529: p_module_name => g_module_name,
530: p_procedure_name => l_program_name);
531: x_return_status := L_FND_RET_STS_ERROR;
532: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
533: -- Standard Unexpected Error Logging
534: INL_LOGGING_PVT.Log_UnexpecError (
535: p_module_name => g_module_name,
536: p_procedure_name => l_program_name);
537: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
535: p_module_name => g_module_name,
536: p_procedure_name => l_program_name);
537: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
538: WHEN OTHERS THEN
539: -- Standard Unexpected Error Logging
540: INL_LOGGING_PVT.Log_UnexpecError (
541: p_module_name => g_module_name,
542: p_procedure_name => l_program_name);
543: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
570: l_return_status VARCHAR2(1) ;
571: l_debug_info VARCHAR2(200) ;
572: l_return_value NUMBER;
573: BEGIN
574: -- Standard Beginning of Procedure/Function Logging
575: INL_LOGGING_PVT.Log_BeginProc(
576: p_module_name => g_module_name,
577: p_procedure_name => l_program_name
578: ) ;
587: SELECT party_id
588: INTO l_return_value
589: FROM hz_parties
590: WHERE PARTY_NUMBER = p_party_number;
591: -- Standard End of Procedure/Function Logging
592: INL_LOGGING_PVT.Log_EndProc(
593: p_module_name => g_module_name,
594: p_procedure_name => l_program_name
595: );
595: );
596: RETURN l_return_value;
597: EXCEPTION
598: WHEN L_FND_EXC_ERROR THEN
599: -- Standard Expected Error Logging
600: INL_LOGGING_PVT.Log_ExpecError (
601: p_module_name => g_module_name,
602: p_procedure_name => l_program_name
603: );
603: );
604: x_return_status := L_FND_RET_STS_ERROR;
605: RETURN 0;
606: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
607: -- Standard Unexpected Error Logging
608: INL_LOGGING_PVT.Log_UnexpecError (
609: p_module_name => g_module_name,
610: p_procedure_name => l_program_name
611: );
611: );
612: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
613: RETURN 0;
614: WHEN OTHERS THEN
615: -- Standard Unexpected Error Logging
616: INL_LOGGING_PVT.Log_UnexpecError (
617: p_module_name => g_module_name,
618: p_procedure_name => l_program_name
619: );
649: l_return_status VARCHAR2(1);
650: l_debug_info VARCHAR2(200);
651: l_return_value NUMBER;
652: BEGIN
653: -- Standard Beginning of Procedure/Function Logging
654: INL_LOGGING_PVT.Log_BeginProc(
655: p_module_name => g_module_name,
656: p_procedure_name => l_program_name
657: ) ;
666: SELECT party_site_id
667: INTO l_return_value
668: FROM hz_party_sites
669: WHERE party_site_number = p_party_site_number;
670: -- Standard End of Procedure/Function Logging
671: INL_LOGGING_PVT.Log_EndProc(
672: p_module_name => g_module_name,
673: p_procedure_name => l_program_name
674: );
674: );
675: RETURN l_return_value;
676: EXCEPTION
677: WHEN L_FND_EXC_ERROR THEN
678: -- Standard Expected Error Logging
679: INL_LOGGING_PVT.Log_ExpecError (
680: p_module_name => g_module_name,
681: p_procedure_name => l_program_name
682: );
682: );
683: x_return_status := L_FND_RET_STS_ERROR;
684: RETURN 0;
685: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
686: -- Standard Unexpected Error Logging
687: INL_LOGGING_PVT.Log_UnexpecError (
688: p_module_name => g_module_name,
689: p_procedure_name => l_program_name
690: );
690: );
691: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
692: RETURN 0;
693: WHEN OTHERS THEN
694: -- Standard Unexpected Error Logging
695: INL_LOGGING_PVT.Log_UnexpecError (
696: p_module_name => g_module_name,
697: p_procedure_name => l_program_name
698: );
751: l_check_numeric NUMBER;
752: l_valid_ship_num NUMBER;
753:
754: BEGIN
755: -- Standard Beginning of Procedure/Function Logging
756: INL_LOGGING_PVT.Log_BeginProc(
757: p_module_name => g_module_name,
758: p_procedure_name => l_program_name) ;
759: -- Initialize API return status to success
1019: END IF;
1020: END IF;
1021: END IF;
1022: END IF;
1023: -- Standard End of Procedure/Function Logging
1024: INL_LOGGING_PVT.Log_EndProc(
1025: p_module_name => g_module_name,
1026: p_procedure_name => l_program_name);
1027: RETURN FND_API.to_boolean(l_result) ;
1027: RETURN FND_API.to_boolean(l_result) ;
1028:
1029: EXCEPTION
1030: WHEN L_FND_EXC_ERROR THEN
1031: -- Standard Expected Error Logging
1032: INL_LOGGING_PVT.Log_ExpecError (
1033: p_module_name => g_module_name,
1034: p_procedure_name => l_program_name);
1035: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1033: p_module_name => g_module_name,
1034: p_procedure_name => l_program_name);
1035: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1036: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
1037: -- Standard Unexpected Error Logging
1038: INL_LOGGING_PVT.Log_UnexpecError (
1039: p_module_name => g_module_name,
1040: p_procedure_name => l_program_name);
1041: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1039: p_module_name => g_module_name,
1040: p_procedure_name => l_program_name);
1041: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1042: WHEN OTHERS THEN
1043: -- Standard Unexpected Error Logging
1044: INL_LOGGING_PVT.Log_UnexpecError (
1045: p_module_name => g_module_name,
1046: p_procedure_name => l_program_name);
1047: IF FND_MSG_PUB.Check_Msg_Level(
1090: l_count_alw_ln_types NUMBER;
1091: l_count_alw_src_types NUMBER;
1092:
1093: BEGIN
1094: -- Standard Beginning of Procedure/Function Logging
1095: INL_LOGGING_PVT.Log_BeginProc(
1096: p_module_name => g_module_name,
1097: p_procedure_name => l_program_name) ;
1098: -- Initialize API return status to success
1245: RAISE L_FND_EXC_UNEXPECTED_ERROR;
1246: END IF;
1247: END IF;
1248: END IF;
1249: -- Standard End of Procedure/Function Logging
1250: INL_LOGGING_PVT.Log_EndProc(
1251: p_module_name => g_module_name,
1252: p_procedure_name => l_program_name);
1253: RETURN FND_API.to_boolean(l_result) ;
1252: p_procedure_name => l_program_name);
1253: RETURN FND_API.to_boolean(l_result) ;
1254: EXCEPTION
1255: WHEN L_FND_EXC_ERROR THEN
1256: -- Standard Expected Error Logging
1257: INL_LOGGING_PVT.Log_ExpecError (
1258: p_module_name => g_module_name,
1259: p_procedure_name => l_program_name);
1260: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1258: p_module_name => g_module_name,
1259: p_procedure_name => l_program_name);
1260: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1261: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
1262: -- Standard Unexpected Error Logging
1263: INL_LOGGING_PVT.Log_UnexpecError (
1264: p_module_name => g_module_name,
1265: p_procedure_name => l_program_name);
1266: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1321: l_count_alw_party_type NUMBER;
1322: l_count_alw_party_usg NUMBER;
1323:
1324: BEGIN
1325: -- Standard Beginning of Procedure/Function Logging
1326: INL_LOGGING_PVT.Log_BeginProc(
1327: p_module_name => g_module_name,
1328: p_procedure_name => l_program_name) ;
1329: -- Initialize API return status to success
1485: RAISE L_FND_EXC_UNEXPECTED_ERROR;
1486: END IF;
1487: END IF;
1488: END IF;
1489: -- Standard End of Procedure/Function Logging
1490: INL_LOGGING_PVT.Log_EndProc(
1491: p_module_name => g_module_name,
1492: p_procedure_name => l_program_name);
1493: RETURN FND_API.to_boolean(l_response) ;
1492: p_procedure_name => l_program_name);
1493: RETURN FND_API.to_boolean(l_response) ;
1494: EXCEPTION
1495: WHEN L_FND_EXC_ERROR THEN
1496: -- Standard Expected Error Logging
1497: INL_LOGGING_PVT.Log_ExpecError (
1498: p_module_name => g_module_name,
1499: p_procedure_name => l_program_name);
1500: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1498: p_module_name => g_module_name,
1499: p_procedure_name => l_program_name);
1500: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1501: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
1502: -- Standard Unexpected Error Logging
1503: INL_LOGGING_PVT.Log_UnexpecError (
1504: p_module_name => g_module_name,
1505: p_procedure_name => l_program_name);
1506: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1562: l_count_belongs_party NUMBER;
1563: l_count_alw_party NUMBER;
1564:
1565: BEGIN
1566: -- Standard Beginning of Procedure/Function Logging
1567: INL_LOGGING_PVT.Log_BeginProc(
1568: p_module_name => g_module_name,
1569: p_procedure_name => l_program_name) ;
1570: -- Initialize API return status to success
1767: RAISE L_FND_EXC_UNEXPECTED_ERROR;
1768: END IF;
1769: END IF;
1770: END IF;
1771: -- Standard End of Procedure/Function Logging
1772: INL_LOGGING_PVT.Log_EndProc(
1773: p_module_name => g_module_name,
1774: p_procedure_name => l_program_name);
1775: RETURN FND_API.to_boolean(l_response) ;
1774: p_procedure_name => l_program_name);
1775: RETURN FND_API.to_boolean(l_response) ;
1776: EXCEPTION
1777: WHEN L_FND_EXC_ERROR THEN
1778: -- Standard Expected Error Logging
1779: INL_LOGGING_PVT.Log_ExpecError (
1780: p_module_name => g_module_name,
1781: p_procedure_name => l_program_name);
1782: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1780: p_module_name => g_module_name,
1781: p_procedure_name => l_program_name);
1782: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1783: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
1784: -- Standard Unexpected Error Logging
1785: INL_LOGGING_PVT.Log_UnexpecError (
1786: p_module_name => g_module_name,
1787: p_procedure_name => l_program_name);
1788: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1838: l_count_alw_party_type NUMBER;
1839: l_count_alw_party_usg NUMBER;
1840:
1841: BEGIN
1842: -- Standard Beginning of Procedure/Function Logging
1843: INL_LOGGING_PVT.Log_BeginProc(
1844: p_module_name => g_module_name,
1845: p_procedure_name => l_program_name) ;
1846: -- Initialize API return status to success
1920: ood.organization_code = x_src_organization_code
1921: ;
1922: END IF;
1923:
1924: -- Standard End of Procedure/Function Logging
1925: INL_LOGGING_PVT.Log_EndProc(
1926: p_module_name => g_module_name,
1927: p_procedure_name => l_program_name);
1928: RETURN FND_API.to_boolean(l_result) ;
1927: p_procedure_name => l_program_name);
1928: RETURN FND_API.to_boolean(l_result) ;
1929: EXCEPTION
1930: WHEN L_FND_EXC_ERROR THEN
1931: -- Standard Expected Error Logging
1932: INL_LOGGING_PVT.Log_ExpecError (
1933: p_module_name => g_module_name,
1934: p_procedure_name => l_program_name);
1935: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1933: p_module_name => g_module_name,
1934: p_procedure_name => l_program_name);
1935: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1936: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
1937: -- Standard Unexpected Error Logging
1938: INL_LOGGING_PVT.Log_UnexpecError (
1939: p_module_name => g_module_name,
1940: p_procedure_name => l_program_name);
1941: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1995: l_colum_value VARCHAR2(30):= x_ship_line_group_num;
1996: l_valid_ln_group NUMBER;
1997:
1998: BEGIN
1999: -- Standard Beginning of Procedure/Function Logging
2000: INL_LOGGING_PVT.Log_BeginProc(
2001: p_module_name => g_module_name,
2002: p_procedure_name => l_program_name) ;
2003: -- Initialize API return status to success
2185: p_var_name => 'x_ship_line_group_id',
2186: p_var_value => x_ship_line_group_id) ;
2187:
2188:
2189: -- Standard End of Procedure/Function Logging
2190: INL_LOGGING_PVT.Log_EndProc(
2191: p_module_name => g_module_name,
2192: p_procedure_name => l_program_name);
2193: RETURN FND_API.to_boolean(l_result) ;
2192: p_procedure_name => l_program_name);
2193: RETURN FND_API.to_boolean(l_result) ;
2194: EXCEPTION
2195: WHEN L_FND_EXC_ERROR THEN
2196: -- Standard Expected Error Logging
2197: INL_LOGGING_PVT.Log_ExpecError (
2198: p_module_name => g_module_name,
2199: p_procedure_name => l_program_name);
2200: RETURN FND_API.to_boolean(L_FND_FALSE) ;
2198: p_module_name => g_module_name,
2199: p_procedure_name => l_program_name);
2200: RETURN FND_API.to_boolean(L_FND_FALSE) ;
2201: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
2202: -- Standard Unexpected Error Logging
2203: INL_LOGGING_PVT.Log_UnexpecError (
2204: p_module_name => g_module_name,
2205: p_procedure_name => l_program_name);
2206: RETURN FND_API.to_boolean(L_FND_FALSE) ;
2204: p_module_name => g_module_name,
2205: p_procedure_name => l_program_name);
2206: RETURN FND_API.to_boolean(L_FND_FALSE) ;
2207: WHEN OTHERS THEN
2208: -- Standard Unexpected Error Logging
2209: INL_LOGGING_PVT.Log_UnexpecError (
2210: p_module_name => g_module_name,
2211: p_procedure_name => l_program_name);
2212: IF FND_MSG_PUB.Check_Msg_Level(
2255: l_count_ship_ln_num_exist NUMBER;
2256: l_column_name VARCHAR2(30);
2257: l_colum_value VARCHAR2(30);
2258: BEGIN
2259: -- Standard Beginning of Procedure/Function Logging
2260: INL_LOGGING_PVT.Log_BeginProc(
2261: p_module_name => g_module_name,
2262: p_procedure_name => l_program_name) ;
2263: -- Initialize API return status to success
2367: END IF;
2368: END;
2369: END IF;
2370:
2371: -- Standard End of Procedure/Function Logging
2372: INL_LOGGING_PVT.Log_EndProc(
2373: p_module_name => g_module_name,
2374: p_procedure_name => l_program_name);
2375: RETURN FND_API.to_boolean(l_response) ;
2374: p_procedure_name => l_program_name);
2375: RETURN FND_API.to_boolean(l_response) ;
2376: EXCEPTION
2377: WHEN L_FND_EXC_ERROR THEN
2378: -- Standard Expected Error Logging
2379: INL_LOGGING_PVT.Log_ExpecError (
2380: p_module_name => g_module_name,
2381: p_procedure_name => l_program_name);
2382: RETURN FND_API.to_boolean(L_FND_FALSE) ;
2380: p_module_name => g_module_name,
2381: p_procedure_name => l_program_name);
2382: RETURN FND_API.to_boolean(L_FND_FALSE) ;
2383: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
2384: -- Standard Unexpected Error Logging
2385: INL_LOGGING_PVT.Log_UnexpecError (
2386: p_module_name => g_module_name,
2387: p_procedure_name => l_program_name);
2388: RETURN FND_API.to_boolean(L_FND_FALSE) ;
2446: l_column_name VARCHAR2(30);
2447: l_column_value VARCHAR2(30);
2448:
2449: BEGIN
2450: -- Standard Beginning of Procedure/Function Logging
2451: INL_LOGGING_PVT.Log_BeginProc(
2452: p_module_name => g_module_name,
2453: p_procedure_name => l_program_name) ;
2454: -- Initialize API return status to success
2616: END IF;
2617: END IF;
2618: END IF;
2619:
2620: -- Standard End of Procedure/Function Logging
2621: INL_LOGGING_PVT.Log_EndProc(
2622: p_module_name => g_module_name,
2623: p_procedure_name => l_program_name);
2624: RETURN FND_API.to_boolean(l_result);
2623: p_procedure_name => l_program_name);
2624: RETURN FND_API.to_boolean(l_result);
2625: EXCEPTION
2626: WHEN L_FND_EXC_ERROR THEN
2627: -- Standard Expected Error Logging
2628: INL_LOGGING_PVT.Log_ExpecError (
2629: p_module_name => g_module_name,
2630: p_procedure_name => l_program_name);
2631: RETURN FND_API.to_boolean(L_FND_FALSE) ;
2629: p_module_name => g_module_name,
2630: p_procedure_name => l_program_name);
2631: RETURN FND_API.to_boolean(L_FND_FALSE) ;
2632: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
2633: -- Standard Unexpected Error Logging
2634: INL_LOGGING_PVT.Log_UnexpecError (
2635: p_module_name => g_module_name,
2636: p_procedure_name => l_program_name);
2637: RETURN FND_API.to_boolean(L_FND_FALSE) ;
2679: l_return_status VARCHAR2(1) := L_FND_TRUE;
2680: l_count_alw_src_type NUMBER;
2681:
2682: BEGIN
2683: -- Standard Beginning of Procedure/Function Logging
2684: INL_LOGGING_PVT.Log_BeginProc(
2685: p_module_name => g_module_name,
2686: p_procedure_name => l_program_name) ;
2687: -- Initialize API return status to success
2731: RAISE L_FND_EXC_UNEXPECTED_ERROR;
2732: END IF;
2733: END IF;
2734:
2735: -- Standard End of Procedure/Function Logging
2736: INL_LOGGING_PVT.Log_EndProc(
2737: p_module_name => g_module_name,
2738: p_procedure_name => l_program_name);
2739: RETURN FND_API.to_boolean(l_result) ;
2738: p_procedure_name => l_program_name);
2739: RETURN FND_API.to_boolean(l_result) ;
2740: EXCEPTION
2741: WHEN L_FND_EXC_ERROR THEN
2742: -- Standard Expected Error Logging
2743: INL_LOGGING_PVT.Log_ExpecError (
2744: p_module_name => g_module_name,
2745: p_procedure_name => l_program_name);
2746: RETURN FND_API.to_boolean(L_FND_FALSE) ;
2744: p_module_name => g_module_name,
2745: p_procedure_name => l_program_name);
2746: RETURN FND_API.to_boolean(L_FND_FALSE) ;
2747: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
2748: -- Standard Unexpected Error Logging
2749: INL_LOGGING_PVT.Log_UnexpecError (
2750: p_module_name => g_module_name,
2751: p_procedure_name => l_program_name);
2752: RETURN FND_API.to_boolean(L_FND_FALSE);
2750: p_module_name => g_module_name,
2751: p_procedure_name => l_program_name);
2752: RETURN FND_API.to_boolean(L_FND_FALSE);
2753: WHEN OTHERS THEN
2754: -- Standard Unexpected Error Logging
2755: INL_LOGGING_PVT.Log_UnexpecError (
2756: p_module_name => g_module_name,
2757: p_procedure_name => l_program_name);
2758: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2801: l_count_curr_code_valid NUMBER;
2802: l_func_currency_code VARCHAR2(15) ;
2803: l_count_conv_tp_valid NUMBER;
2804: BEGIN
2805: -- Standard Beginning of Procedure/Function Logging
2806: INL_LOGGING_PVT.Log_BeginProc(
2807: p_module_name => g_module_name,
2808: p_procedure_name => l_program_name) ;
2809: -- Initialize API return status to success
3113: END IF;
3114: END;
3115: END IF;
3116: END IF;
3117: -- Standard End of Procedure/Function Logging
3118: INL_LOGGING_PVT.Log_EndProc(
3119: p_module_name => g_module_name,
3120: p_procedure_name => l_program_name);
3121: RETURN FND_API.to_boolean(l_response) ;
3120: p_procedure_name => l_program_name);
3121: RETURN FND_API.to_boolean(l_response) ;
3122: EXCEPTION
3123: WHEN L_FND_EXC_ERROR THEN
3124: -- Standard Expected Error Logging
3125: INL_LOGGING_PVT.Log_ExpecError (
3126: p_module_name => g_module_name,
3127: p_procedure_name => l_program_name);
3128: RETURN FND_API.to_boolean(L_FND_FALSE) ;
3126: p_module_name => g_module_name,
3127: p_procedure_name => l_program_name);
3128: RETURN FND_API.to_boolean(L_FND_FALSE) ;
3129: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
3130: -- Standard Unexpected Error Logging
3131: INL_LOGGING_PVT.Log_UnexpecError (
3132: p_module_name => g_module_name,
3133: p_procedure_name => l_program_name);
3134: RETURN FND_API.to_boolean(L_FND_FALSE);
3132: p_module_name => g_module_name,
3133: p_procedure_name => l_program_name);
3134: RETURN FND_API.to_boolean(L_FND_FALSE);
3135: WHEN OTHERS THEN
3136: -- Standard Unexpected Error Logging
3137: INL_LOGGING_PVT.Log_UnexpecError (
3138: p_module_name => g_module_name,
3139: p_procedure_name => l_program_name);
3140: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
3180: l_column_name VARCHAR2(30);
3181: l_column_value VARCHAR2(30);
3182:
3183: BEGIN
3184: -- Standard Beginning of Procedure/Function Logging
3185: INL_LOGGING_PVT.Log_BeginProc(
3186: p_module_name => g_module_name,
3187: p_procedure_name => l_program_name) ;
3188: -- Initialize API return status to success
3250: OR msi.concatenated_segments = x_inv_item_name)
3251: ;
3252: END IF;
3253:
3254: -- Standard End of Procedure/Function Logging
3255: INL_LOGGING_PVT.Log_EndProc(
3256: p_module_name => g_module_name,
3257: p_procedure_name => l_program_name);
3258: RETURN FND_API.to_boolean(L_FND_TRUE) ;
3257: p_procedure_name => l_program_name);
3258: RETURN FND_API.to_boolean(L_FND_TRUE) ;
3259: EXCEPTION
3260: WHEN L_FND_EXC_ERROR THEN
3261: -- Standard Expected Error Logging
3262: INL_LOGGING_PVT.Log_ExpecError (
3263: p_module_name => g_module_name,
3264: p_procedure_name => l_program_name);
3265: RETURN FND_API.to_boolean(L_FND_FALSE) ;
3263: p_module_name => g_module_name,
3264: p_procedure_name => l_program_name);
3265: RETURN FND_API.to_boolean(L_FND_FALSE) ;
3266: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
3267: -- Standard Unexpected Error Logging
3268: INL_LOGGING_PVT.Log_UnexpecError (
3269: p_module_name => g_module_name,
3270: p_procedure_name => l_program_name);
3271: RETURN FND_API.to_boolean(L_FND_FALSE);
3314: l_return_status VARCHAR2(1) := L_FND_TRUE;
3315: l_count_txn_uom_valid NUMBER;
3316:
3317: BEGIN
3318: -- Standard Beginning of Procedure/Function Logging
3319: INL_LOGGING_PVT.Log_BeginProc(
3320: p_module_name => g_module_name,
3321: p_procedure_name => l_program_name) ;
3322: -- Initialize API return status to success
3366: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
3367: RAISE L_FND_EXC_UNEXPECTED_ERROR;
3368: END IF;
3369: END IF;
3370: -- Standard End of Procedure/Function Logging
3371: INL_LOGGING_PVT.Log_EndProc(
3372: p_module_name => g_module_name,
3373: p_procedure_name => l_program_name);
3374: RETURN FND_API.to_boolean(l_result) ;
3373: p_procedure_name => l_program_name);
3374: RETURN FND_API.to_boolean(l_result) ;
3375: EXCEPTION
3376: WHEN L_FND_EXC_ERROR THEN
3377: -- Standard Expected Error Logging
3378: INL_LOGGING_PVT.Log_ExpecError (
3379: p_module_name => g_module_name,
3380: p_procedure_name => l_program_name);
3381: RETURN FND_API.to_boolean(L_FND_FALSE) ;
3379: p_module_name => g_module_name,
3380: p_procedure_name => l_program_name);
3381: RETURN FND_API.to_boolean(L_FND_FALSE) ;
3382: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
3383: -- Standard Unexpected Error Logging
3384: INL_LOGGING_PVT.Log_UnexpecError (
3385: p_module_name => g_module_name,
3386: p_procedure_name => l_program_name);
3387: RETURN FND_API.to_boolean(L_FND_FALSE) ;
3385: p_module_name => g_module_name,
3386: p_procedure_name => l_program_name);
3387: RETURN FND_API.to_boolean(L_FND_FALSE) ;
3388: WHEN OTHERS THEN
3389: -- Standard Unexpected Error Logging
3390: INL_LOGGING_PVT.Log_UnexpecError (
3391: p_module_name => g_module_name,
3392: p_procedure_name => l_program_name);
3393: IF FND_MSG_PUB.Check_Msg_Level(
3468: l_rcv_uom_code VARCHAR2(3); -- Bug 11710754
3469: l_po_uom_code VARCHAR2(25); -- Bug 11710754
3470: l_po_unit_price NUMBER; -- Bug 11710754
3471: BEGIN
3472: -- Standard Beginning of Procedure/Function Logging
3473: INL_LOGGING_PVT.Log_BeginProc(
3474: p_module_name => g_module_name,
3475: p_procedure_name => l_program_name) ;
3476: -- Initialize API return status to success
3894: END IF;
3895: END IF;
3896: -- /Bug #8932386
3897: END IF;
3898: -- Standard End of Procedure/Function Logging
3899: INL_LOGGING_PVT.Log_EndProc(
3900: p_module_name => g_module_name,
3901: p_procedure_name => l_program_name);
3902: RETURN FND_API.to_boolean(l_result) ;
3901: p_procedure_name => l_program_name);
3902: RETURN FND_API.to_boolean(l_result) ;
3903: EXCEPTION
3904: WHEN L_FND_EXC_ERROR THEN
3905: -- Standard Expected Error Logging
3906: x_return_status := L_FND_RET_STS_ERROR;
3907: INL_LOGGING_PVT.Log_ExpecError (
3908: p_module_name => g_module_name,
3909: p_procedure_name => l_program_name);
3909: p_procedure_name => l_program_name);
3910: RETURN FND_API.to_boolean(L_FND_FALSE) ;
3911: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
3912: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
3913: -- Standard Unexpected Error Logging
3914: INL_LOGGING_PVT.Log_UnexpecError (
3915: p_module_name => g_module_name,
3916: p_procedure_name => l_program_name);
3917: RETURN FND_API.to_boolean(L_FND_FALSE) ;
3916: p_procedure_name => l_program_name);
3917: RETURN FND_API.to_boolean(L_FND_FALSE) ;
3918: WHEN OTHERS THEN
3919: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
3920: -- Standard Unexpected Error Logging
3921: INL_LOGGING_PVT.Log_UnexpecError (
3922: p_module_name => g_module_name,
3923: p_procedure_name => l_program_name);
3924: IF FND_MSG_PUB.Check_Msg_Level(
3955: l_result VARCHAR2(1) := L_FND_TRUE;
3956: l_return_status VARCHAR2(1) := L_FND_TRUE;
3957:
3958: BEGIN
3959: -- Standard Beginning of Procedure/Function Logging
3960: INL_LOGGING_PVT.Log_BeginProc(
3961: p_module_name => g_module_name,
3962: p_procedure_name => l_program_name) ;
3963: -- Initialize API return status to success
4004: RAISE L_FND_EXC_UNEXPECTED_ERROR;
4005: END IF;
4006: END IF;
4007:
4008: -- Standard End of Procedure/Function Logging
4009: INL_LOGGING_PVT.Log_EndProc(
4010: p_module_name => g_module_name,
4011: p_procedure_name => l_program_name);
4012: RETURN FND_API.to_boolean(l_result) ;
4011: p_procedure_name => l_program_name);
4012: RETURN FND_API.to_boolean(l_result) ;
4013: EXCEPTION
4014: WHEN L_FND_EXC_ERROR THEN
4015: -- Standard Expected Error Logging
4016: INL_LOGGING_PVT.Log_ExpecError (
4017: p_module_name => g_module_name,
4018: p_procedure_name => l_program_name);
4019: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4017: p_module_name => g_module_name,
4018: p_procedure_name => l_program_name);
4019: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4020: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
4021: -- Standard Unexpected Error Logging
4022: INL_LOGGING_PVT.Log_UnexpecError (
4023: p_module_name => g_module_name,
4024: p_procedure_name => l_program_name);
4025: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4023: p_module_name => g_module_name,
4024: p_procedure_name => l_program_name);
4025: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4026: WHEN OTHERS THEN
4027: -- Standard Unexpected Error Logging
4028: INL_LOGGING_PVT.Log_UnexpecError (
4029: p_module_name => g_module_name,
4030: p_procedure_name => l_program_name);
4031: IF FND_MSG_PUB.Check_Msg_Level(
4062: l_result VARCHAR2(1) := L_FND_TRUE;
4063: l_return_status VARCHAR2(1) := L_FND_TRUE;
4064:
4065: BEGIN
4066: -- Standard Beginning of Procedure/Function Logging
4067: INL_LOGGING_PVT.Log_BeginProc(
4068: p_module_name => g_module_name,
4069: p_procedure_name => l_program_name) ;
4070: -- Initialize API return status to success
4108: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
4109: RAISE L_FND_EXC_UNEXPECTED_ERROR;
4110: END IF;
4111: END IF;
4112: -- Standard End of Procedure/Function Logging
4113: INL_LOGGING_PVT.Log_EndProc(
4114: p_module_name => g_module_name,
4115: p_procedure_name => l_program_name);
4116: RETURN FND_API.to_boolean(l_result) ;
4115: p_procedure_name => l_program_name);
4116: RETURN FND_API.to_boolean(l_result) ;
4117: EXCEPTION
4118: WHEN L_FND_EXC_ERROR THEN
4119: -- Standard Expected Error Logging
4120: INL_LOGGING_PVT.Log_ExpecError (
4121: p_module_name => g_module_name,
4122: p_procedure_name => l_program_name);
4123: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4121: p_module_name => g_module_name,
4122: p_procedure_name => l_program_name);
4123: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4124: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
4125: -- Standard Unexpected Error Logging
4126: INL_LOGGING_PVT.Log_UnexpecError (
4127: p_module_name => g_module_name,
4128: p_procedure_name => l_program_name);
4129: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4127: p_module_name => g_module_name,
4128: p_procedure_name => l_program_name);
4129: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4130: WHEN OTHERS THEN
4131: -- Standard Unexpected Error Logging
4132: INL_LOGGING_PVT.Log_UnexpecError (
4133: p_module_name => g_module_name,
4134: p_procedure_name => l_program_name);
4135: IF FND_MSG_PUB.Check_Msg_Level(
4193: -- l_user_def_ship_num_code VARCHAR2(25); -- Bug #9198199
4194: -- l_count_lcm_as_service NUMBER; -- Bug #9198199
4195:
4196: BEGIN
4197: -- Standard Beginning of Procedure/Function Logging
4198: INL_LOGGING_PVT.Log_BeginProc(
4199: p_module_name => g_module_name,
4200: p_procedure_name => l_program_name) ;
4201:
4425: END IF;
4426: END IF;
4427: END IF;
4428:
4429: -- Standard End of Procedure/Function Logging
4430: INL_LOGGING_PVT.Log_EndProc(
4431: p_module_name => g_module_name,
4432: p_procedure_name => l_program_name);
4433:
4433:
4434: RETURN FND_API.to_boolean(l_result) ;
4435: EXCEPTION
4436: WHEN L_FND_EXC_ERROR THEN
4437: -- Standard Expected Error Logging
4438: INL_LOGGING_PVT.Log_ExpecError (
4439: p_module_name => g_module_name,
4440: p_procedure_name => l_program_name);
4441: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4439: p_module_name => g_module_name,
4440: p_procedure_name => l_program_name);
4441: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4442: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
4443: -- Standard Unexpected Error Logging
4444: INL_LOGGING_PVT.Log_UnexpecError (
4445: p_module_name => g_module_name,
4446: p_procedure_name => l_program_name);
4447: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4502: l_column_value VARCHAR2(30);
4503: l_count_loc_org NUMBER;
4504:
4505: BEGIN
4506: -- Standard Beginning of Procedure/Function Logging
4507: INL_LOGGING_PVT.Log_BeginProc(
4508: p_module_name => g_module_name,
4509: p_procedure_name => l_program_name) ;
4510: -- Initialize API return status to success
4702: END IF;
4703: END IF;
4704: END IF;
4705:
4706: -- Standard End of Procedure/Function Logging
4707: INL_LOGGING_PVT.Log_EndProc(
4708: p_module_name => g_module_name,
4709: p_procedure_name => l_program_name);
4710:
4710:
4711: RETURN FND_API.to_boolean(l_result) ;
4712: EXCEPTION
4713: WHEN L_FND_EXC_ERROR THEN
4714: -- Standard Expected Error Logging
4715: INL_LOGGING_PVT.Log_ExpecError (
4716: p_module_name => g_module_name,
4717: p_procedure_name => l_program_name);
4718: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4716: p_module_name => g_module_name,
4717: p_procedure_name => l_program_name);
4718: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4719: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
4720: -- Standard Unexpected Error Logging
4721: INL_LOGGING_PVT.Log_UnexpecError (
4722: p_module_name => g_module_name,
4723: p_procedure_name => l_program_name);
4724: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4782: l_validate_inv_item BOOLEAN := TRUE;
4783: l_validate_txn_uom_code BOOLEAN := TRUE;
4784: BEGIN
4785:
4786: -- Standard Beginning of Procedure/Function Logging
4787: INL_LOGGING_PVT.Log_BeginProc(
4788: p_module_name => g_module_name,
4789: p_procedure_name => l_program_name) ;
4790: -- Initialize API return status to success
5947:
5948: END IF;
5949: END LOOP;
5950:
5951: -- Standard End of Procedure/Function Logging
5952: INL_LOGGING_PVT.Log_EndProc(
5953: p_module_name => g_module_name,
5954: p_procedure_name => l_program_name);
5955: RETURN l_response;
5954: p_procedure_name => l_program_name);
5955: RETURN l_response;
5956: EXCEPTION
5957: WHEN L_FND_EXC_ERROR THEN
5958: -- Standard Expected Error Logging
5959: INL_LOGGING_PVT.Log_ExpecError (
5960: p_module_name => g_module_name,
5961: p_procedure_name => l_program_name);
5962: RETURN FND_API.to_boolean(L_FND_FALSE) ;
5960: p_module_name => g_module_name,
5961: p_procedure_name => l_program_name);
5962: RETURN FND_API.to_boolean(L_FND_FALSE) ;
5963: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
5964: -- Standard Unexpected Error Logging
5965: INL_LOGGING_PVT.Log_UnexpecError (
5966: p_module_name => g_module_name,
5967: p_procedure_name => l_program_name);
5968: RETURN FND_API.to_boolean(L_FND_FALSE) ;
5966: p_module_name => g_module_name,
5967: p_procedure_name => l_program_name);
5968: RETURN FND_API.to_boolean(L_FND_FALSE) ;
5969: WHEN OTHERS THEN
5970: -- Standard Unexpected Error Logging
5971: INL_LOGGING_PVT.Log_UnexpecError (
5972: p_module_name => g_module_name,
5973: p_procedure_name => l_program_name);
5974: IF FND_MSG_PUB.Check_Msg_Level(
6009: l_return_status VARCHAR2(1) := L_FND_TRUE;
6010: l_ship_line_src_type_code VARCHAR2(10);
6011:
6012: BEGIN
6013: -- Standard Beginning of Procedure/Function Logging
6014: INL_LOGGING_PVT.Log_BeginProc(
6015: p_module_name => g_module_name,
6016: p_procedure_name => l_program_name) ;
6017: -- Initialize API return status to success
6086: IF l_return_status <> L_FND_RET_STS_SUCCESS THEN
6087: RAISE L_FND_EXC_UNEXPECTED_ERROR;
6088: END IF;
6089: END IF;
6090: -- Standard End of Procedure/Function Logging
6091: INL_LOGGING_PVT.Log_EndProc(
6092: p_module_name => g_module_name,
6093: p_procedure_name => l_program_name);
6094: RETURN l_response;
6093: p_procedure_name => l_program_name);
6094: RETURN l_response;
6095: EXCEPTION
6096: WHEN L_FND_EXC_ERROR THEN
6097: -- Standard Expected Error Logging
6098: INL_LOGGING_PVT.Log_ExpecError (
6099: p_module_name => g_module_name,
6100: p_procedure_name => l_program_name);
6101: RETURN FND_API.to_boolean(L_FND_FALSE) ;
6099: p_module_name => g_module_name,
6100: p_procedure_name => l_program_name);
6101: RETURN FND_API.to_boolean(L_FND_FALSE) ;
6102: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
6103: -- Standard Unexpected Error Logging
6104: INL_LOGGING_PVT.Log_UnexpecError (
6105: p_module_name => g_module_name,
6106: p_procedure_name => l_program_name);
6107: RETURN FND_API.to_boolean(L_FND_FALSE) ;
6105: p_module_name => g_module_name,
6106: p_procedure_name => l_program_name);
6107: RETURN FND_API.to_boolean(L_FND_FALSE) ;
6108: WHEN OTHERS THEN
6109: -- Standard Unexpected Error Logging
6110: INL_LOGGING_PVT.Log_UnexpecError (
6111: p_module_name => g_module_name,
6112: p_procedure_name => l_program_name);
6113: IF FND_MSG_PUB.Check_Msg_Level(
6163: l_ship_line_int_id NUMBER;
6164:
6165: BEGIN
6166:
6167: -- Standard Beginning of Procedure/Function Logging
6168: INL_LOGGING_PVT.Log_BeginProc(
6169: p_module_name => g_module_name,
6170: p_procedure_name => l_program_name) ;
6171: -- Initialize API return status to success
6428: END IF;
6429: END IF;
6430:
6431:
6432: -- Standard End of Procedure/Function Logging
6433: INL_LOGGING_PVT.Log_EndProc(
6434: p_module_name => g_module_name,
6435: p_procedure_name => l_program_name);
6436: RETURN l_response;
6435: p_procedure_name => l_program_name);
6436: RETURN l_response;
6437: EXCEPTION
6438: WHEN L_FND_EXC_ERROR THEN
6439: -- Standard Expected Error Logging
6440: INL_LOGGING_PVT.Log_ExpecError (
6441: p_module_name => g_module_name,
6442: p_procedure_name => l_program_name);
6443: RETURN FND_API.to_boolean(L_FND_FALSE) ;
6441: p_module_name => g_module_name,
6442: p_procedure_name => l_program_name);
6443: RETURN FND_API.to_boolean(L_FND_FALSE) ;
6444: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
6445: -- Standard Unexpected Error Logging
6446: INL_LOGGING_PVT.Log_UnexpecError (
6447: p_module_name => g_module_name,
6448: p_procedure_name => l_program_name);
6449: RETURN FND_API.to_boolean(L_FND_FALSE) ;
6447: p_module_name => g_module_name,
6448: p_procedure_name => l_program_name);
6449: RETURN FND_API.to_boolean(L_FND_FALSE) ;
6450: WHEN OTHERS THEN
6451: -- Standard Unexpected Error Logging
6452: INL_LOGGING_PVT.Log_UnexpecError (
6453: p_module_name => g_module_name,
6454: p_procedure_name => l_program_name);
6455: IF FND_MSG_PUB.Check_Msg_Level(
6506: l_organization_id NUMBER;
6507: l_ship_line_int_id NUMBER;
6508: BEGIN
6509:
6510: -- Standard Beginning of Procedure/Function Logging
6511: INL_LOGGING_PVT.Log_BeginProc(
6512: p_module_name => g_module_name,
6513: p_procedure_name => l_program_name) ;
6514: -- Initialize API return status to success
6795: RAISE L_FND_EXC_UNEXPECTED_ERROR;
6796: END IF;
6797: END IF;
6798:
6799: -- Standard End of Procedure/Function Logging
6800: INL_LOGGING_PVT.Log_EndProc(
6801: p_module_name => g_module_name,
6802: p_procedure_name => l_program_name);
6803: RETURN l_response;
6802: p_procedure_name => l_program_name);
6803: RETURN l_response;
6804: EXCEPTION
6805: WHEN L_FND_EXC_ERROR THEN
6806: -- Standard Expected Error Logging
6807: INL_LOGGING_PVT.Log_ExpecError (
6808: p_module_name => g_module_name,
6809: p_procedure_name => l_program_name);
6810: RETURN FND_API.to_boolean(L_FND_FALSE) ;
6808: p_module_name => g_module_name,
6809: p_procedure_name => l_program_name);
6810: RETURN FND_API.to_boolean(L_FND_FALSE) ;
6811: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
6812: -- Standard Unexpected Error Logging
6813: INL_LOGGING_PVT.Log_UnexpecError (
6814: p_module_name => g_module_name,
6815: p_procedure_name => l_program_name);
6816: RETURN FND_API.to_boolean(L_FND_FALSE) ;
6814: p_module_name => g_module_name,
6815: p_procedure_name => l_program_name);
6816: RETURN FND_API.to_boolean(L_FND_FALSE) ;
6817: WHEN OTHERS THEN
6818: -- Standard Unexpected Error Logging
6819: INL_LOGGING_PVT.Log_UnexpecError (
6820: p_module_name => g_module_name,
6821: p_procedure_name => l_program_name);
6822: IF FND_MSG_PUB.Check_Msg_Level(
6866: l_validate_txn_uom_code BOOLEAN := TRUE;
6867:
6868: BEGIN
6869:
6870: -- Standard Beginning of Procedure/Function Logging
6871: INL_LOGGING_PVT.Log_BeginProc(
6872: p_module_name => g_module_name,
6873: p_procedure_name => l_program_name) ;
6874: -- Initialize API return status to success
7612: END IF;
7613:
7614: END LOOP;
7615:
7616: -- Standard End of Procedure/Function Logging
7617: INL_LOGGING_PVT.Log_EndProc(
7618: p_module_name => g_module_name,
7619: p_procedure_name => l_program_name);
7620: RETURN l_response;
7619: p_procedure_name => l_program_name);
7620: RETURN l_response;
7621: EXCEPTION
7622: WHEN L_FND_EXC_ERROR THEN
7623: -- Standard Expected Error Logging
7624: INL_LOGGING_PVT.Log_ExpecError (
7625: p_module_name => g_module_name,
7626: p_procedure_name => l_program_name);
7627: RETURN FND_API.to_boolean(L_FND_FALSE) ;
7625: p_module_name => g_module_name,
7626: p_procedure_name => l_program_name);
7627: RETURN FND_API.to_boolean(L_FND_FALSE) ;
7628: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
7629: -- Standard Unexpected Error Logging
7630: INL_LOGGING_PVT.Log_UnexpecError (
7631: p_module_name => g_module_name,
7632: p_procedure_name => l_program_name);
7633: RETURN FND_API.to_boolean(L_FND_FALSE) ;
7631: p_module_name => g_module_name,
7632: p_procedure_name => l_program_name);
7633: RETURN FND_API.to_boolean(L_FND_FALSE) ;
7634: WHEN OTHERS THEN
7635: -- Standard Unexpected Error Logging
7636: INL_LOGGING_PVT.Log_UnexpecError (
7637: p_module_name => g_module_name,
7638: p_procedure_name => l_program_name);
7639: IF FND_MSG_PUB.Check_Msg_Level(
7672: l_response BOOLEAN := TRUE;
7673: l_count_ln_proc_error NUMBER;
7674: BEGIN
7675:
7676: -- Standard Beginning of Procedure/Function Logging
7677: INL_LOGGING_PVT.Log_BeginProc(
7678: p_module_name => g_module_name,
7679: p_procedure_name => l_program_name) ;
7680: -- Initialize API return status to success
7729: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
7730: RAISE L_FND_EXC_UNEXPECTED_ERROR;
7731: END IF;
7732: END IF;
7733: -- Standard End of Procedure/Function Logging
7734: INL_LOGGING_PVT.Log_EndProc(
7735: p_module_name => g_module_name,
7736: p_procedure_name => l_program_name);
7737: RETURN l_response;
7736: p_procedure_name => l_program_name);
7737: RETURN l_response;
7738: EXCEPTION
7739: WHEN L_FND_EXC_ERROR THEN
7740: -- Standard Expected Error Logging
7741: INL_LOGGING_PVT.Log_ExpecError (
7742: p_module_name => g_module_name,
7743: p_procedure_name => l_program_name);
7744: RETURN FND_API.to_boolean(L_FND_FALSE) ;
7742: p_module_name => g_module_name,
7743: p_procedure_name => l_program_name);
7744: RETURN FND_API.to_boolean(L_FND_FALSE) ;
7745: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
7746: -- Standard Unexpected Error Logging
7747: INL_LOGGING_PVT.Log_UnexpecError (
7748: p_module_name => g_module_name,
7749: p_procedure_name => l_program_name);
7750: RETURN FND_API.to_boolean(L_FND_FALSE) ;
7748: p_module_name => g_module_name,
7749: p_procedure_name => l_program_name);
7750: RETURN FND_API.to_boolean(L_FND_FALSE) ;
7751: WHEN OTHERS THEN
7752: -- Standard Unexpected Error Logging
7753: INL_LOGGING_PVT.Log_UnexpecError (
7754: p_module_name => g_module_name,
7755: p_procedure_name => l_program_name);
7756: IF FND_MSG_PUB.Check_Msg_Level(
7787: l_return_status VARCHAR2(1) := L_FND_TRUE;
7788: l_count_ln_src_tp_code NUMBER;
7789:
7790: BEGIN
7791: -- Standard Beginning of Procedure/Function Logging
7792: INL_LOGGING_PVT.Log_BeginProc(
7793: p_module_name => g_module_name,
7794: p_procedure_name => l_program_name) ;
7795: -- Initialize API return status to success
7843: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
7844: RAISE L_FND_EXC_UNEXPECTED_ERROR;
7845: END IF;
7846: END IF;
7847: -- Standard End of Procedure/Function Logging
7848: INL_LOGGING_PVT.Log_EndProc(
7849: p_module_name => g_module_name,
7850: p_procedure_name => l_program_name);
7851: RETURN l_response;
7850: p_procedure_name => l_program_name);
7851: RETURN l_response;
7852: EXCEPTION
7853: WHEN L_FND_EXC_ERROR THEN
7854: -- Standard Expected Error Logging
7855: INL_LOGGING_PVT.Log_ExpecError (
7856: p_module_name => g_module_name,
7857: p_procedure_name => l_program_name);
7858: RETURN FND_API.to_boolean(L_FND_FALSE) ;
7856: p_module_name => g_module_name,
7857: p_procedure_name => l_program_name);
7858: RETURN FND_API.to_boolean(L_FND_FALSE) ;
7859: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
7860: -- Standard Unexpected Error Logging
7861: INL_LOGGING_PVT.Log_UnexpecError (
7862: p_module_name => g_module_name,
7863: p_procedure_name => l_program_name);
7864: RETURN FND_API.to_boolean(L_FND_FALSE) ;
7862: p_module_name => g_module_name,
7863: p_procedure_name => l_program_name);
7864: RETURN FND_API.to_boolean(L_FND_FALSE) ;
7865: WHEN OTHERS THEN
7866: -- Standard Unexpected Error Logging
7867: INL_LOGGING_PVT.Log_UnexpecError (
7868: p_module_name => g_module_name,
7869: p_procedure_name => l_program_name);
7870: IF FND_MSG_PUB.Check_Msg_Level(
7927: l_column_null VARCHAR2(300);
7928: l_column_nnull VARCHAR2(300);
7929:
7930: BEGIN
7931: -- Standard Beginning of Procedure/Function Logging
7932: INL_LOGGING_PVT.Log_BeginProc(
7933: p_module_name => g_module_name,
7934: p_procedure_name => l_program_name) ;
7935: -- Initialize API return status to success
8059: p_procedure_name => l_program_name,
8060: p_var_name => 'x_ship_num',
8061: p_var_value => x_ship_num);
8062:
8063: -- Standard End of Procedure/Function Logging
8064: INL_LOGGING_PVT.Log_EndProc(
8065: p_module_name => g_module_name,
8066: p_procedure_name => l_program_name);
8067: RETURN l_response;
8066: p_procedure_name => l_program_name);
8067: RETURN l_response;
8068: EXCEPTION
8069: WHEN L_FND_EXC_ERROR THEN
8070: -- Standard Expected Error Logging
8071: INL_LOGGING_PVT.Log_ExpecError (
8072: p_module_name => g_module_name,
8073: p_procedure_name => l_program_name);
8074: RETURN FND_API.to_boolean(L_FND_FALSE) ;
8072: p_module_name => g_module_name,
8073: p_procedure_name => l_program_name);
8074: RETURN FND_API.to_boolean(L_FND_FALSE) ;
8075: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
8076: -- Standard Unexpected Error Logging
8077: INL_LOGGING_PVT.Log_UnexpecError (
8078: p_module_name => g_module_name,
8079: p_procedure_name => l_program_name);
8080: RETURN FND_API.to_boolean(L_FND_FALSE) ;
8078: p_module_name => g_module_name,
8079: p_procedure_name => l_program_name);
8080: RETURN FND_API.to_boolean(L_FND_FALSE) ;
8081: WHEN OTHERS THEN
8082: -- Standard Unexpected Error Logging
8083: INL_LOGGING_PVT.Log_UnexpecError (
8084: p_module_name => g_module_name,
8085: p_procedure_name => l_program_name);
8086: IF FND_MSG_PUB.Check_Msg_Level(
8115: ) IS
8116: l_program_name CONSTANT VARCHAR2(100) := 'Delete_Ship';
8117: l_debug_info VARCHAR2(2000) ;
8118: BEGIN
8119: -- Standard Beginning of Procedure/Function Logging
8120: INL_LOGGING_PVT.Log_BeginProc(
8121: p_module_name => g_module_name,
8122: p_procedure_name => l_program_name) ;
8123: -- Initialize API return status to success
8358: p_var_name => 'sql%rowcount',
8359: p_var_value => sql%rowcount
8360: );
8361:
8362: -- Standard End of Procedure/Function Logging
8363: INL_LOGGING_PVT.Log_EndProc(
8364: p_module_name => g_module_name,
8365: p_procedure_name => l_program_name);
8366: EXCEPTION
8364: p_module_name => g_module_name,
8365: p_procedure_name => l_program_name);
8366: EXCEPTION
8367: WHEN L_FND_EXC_ERROR THEN
8368: -- Standard Expected Error Logging
8369: INL_LOGGING_PVT.Log_ExpecError (
8370: p_module_name => g_module_name,
8371: p_procedure_name => l_program_name );
8372: x_return_status := L_FND_RET_STS_ERROR;
8370: p_module_name => g_module_name,
8371: p_procedure_name => l_program_name );
8372: x_return_status := L_FND_RET_STS_ERROR;
8373: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
8374: -- Standard Unexpected Error Logging
8375: INL_LOGGING_PVT.Log_UnexpecError (
8376: p_module_name => g_module_name,
8377: p_procedure_name => l_program_name);
8378: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8376: p_module_name => g_module_name,
8377: p_procedure_name => l_program_name);
8378: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8379: WHEN OTHERS THEN
8380: -- Standard Unexpected Error Logging
8381: INL_LOGGING_PVT.Log_UnexpecError (
8382: p_module_name => g_module_name,
8383: p_procedure_name => l_program_name);
8384: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8413: ) IS
8414: l_program_name CONSTANT VARCHAR2(100) := 'Handle_LineGroups';
8415: l_debug_info VARCHAR2(2000) ;
8416: BEGIN
8417: -- Standard Beginning of Procedure/Function Logging
8418: INL_LOGGING_PVT.Log_BeginProc(
8419: p_module_name => g_module_name,
8420: p_procedure_name => l_program_name) ;
8421:
8664: attribute15 = NVL(x_ship_ln_int_rec.attribute15_lg ,attribute15 )
8665: WHERE ship_line_group_id = x_ship_ln_int_rec.ship_line_group_id
8666: ;
8667: END IF;
8668: -- Standard End of Procedure/Function Logging
8669: INL_LOGGING_PVT.Log_EndProc(
8670: p_module_name => g_module_name,
8671: p_procedure_name => l_program_name);
8672: EXCEPTION
8670: p_module_name => g_module_name,
8671: p_procedure_name => l_program_name);
8672: EXCEPTION
8673: WHEN L_FND_EXC_ERROR THEN
8674: -- Standard Expected Error Logging
8675: INL_LOGGING_PVT.Log_ExpecError (
8676: p_module_name => g_module_name,
8677: p_procedure_name => l_program_name);
8678: x_return_status := L_FND_RET_STS_ERROR;
8676: p_module_name => g_module_name,
8677: p_procedure_name => l_program_name);
8678: x_return_status := L_FND_RET_STS_ERROR;
8679: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
8680: -- Standard Unexpected Error Logging
8681: INL_LOGGING_PVT.Log_UnexpecError (
8682: p_module_name => g_module_name,
8683: p_procedure_name => l_program_name);
8684: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8682: p_module_name => g_module_name,
8683: p_procedure_name => l_program_name);
8684: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8685: WHEN OTHERS THEN
8686: -- Standard Unexpected Error Logging
8687: INL_LOGGING_PVT.Log_UnexpecError (
8688: p_module_name => g_module_name,
8689: p_procedure_name => l_program_name);
8690: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8725: l_msg_data VARCHAR2(2000) ;
8726: l_msg_count NUMBER;
8727:
8728: BEGIN
8729: -- Standard Beginning of Procedure/Function Logging
8730: INL_LOGGING_PVT.Log_BeginProc(
8731: p_module_name => g_module_name,
8732: p_procedure_name => l_program_name) ;
8733: -- Initialize API return status to success
8795: RAISE L_FND_EXC_UNEXPECTED_ERROR;
8796: END IF;
8797: END IF;
8798:
8799: -- Standard End of Procedure/Function Logging
8800: INL_LOGGING_PVT.Log_EndProc(
8801: p_module_name => g_module_name,
8802: p_procedure_name => l_program_name);
8803:
8802: p_procedure_name => l_program_name);
8803:
8804: EXCEPTION
8805: WHEN L_FND_EXC_ERROR THEN
8806: -- Standard Expected Error Logging
8807: INL_LOGGING_PVT.Log_ExpecError (
8808: p_module_name => g_module_name,
8809: p_procedure_name => l_program_name);
8810: x_return_status := L_FND_RET_STS_ERROR;
8808: p_module_name => g_module_name,
8809: p_procedure_name => l_program_name);
8810: x_return_status := L_FND_RET_STS_ERROR;
8811: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
8812: -- Standard Unexpected Error Logging
8813: INL_LOGGING_PVT.Log_UnexpecError (
8814: p_module_name => g_module_name,
8815: p_procedure_name => l_program_name);
8816: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8814: p_module_name => g_module_name,
8815: p_procedure_name => l_program_name);
8816: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8817: WHEN OTHERS THEN
8818: -- Standard Unexpected Error Logging
8819: INL_LOGGING_PVT.Log_UnexpecError (
8820: p_module_name => g_module_name,
8821: p_procedure_name => l_program_name);
8822: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8858: l_debug_info VARCHAR2(2000);
8859: l_return_status VARCHAR2(1);
8860:
8861: BEGIN
8862: -- Standard Beginning of Procedure/Function Logging
8863: INL_LOGGING_PVT.Log_BeginProc(
8864: p_module_name => g_module_name,
8865: p_procedure_name => l_program_name) ;
8866: -- Initialize API return status to success
9198: program_application_id = L_FND_PROG_APPL_ID
9199: WHERE ship_line_int_id = x_ship_ln_int_lst(l_ship_ln_int_idx).ship_line_int_id ;
9200: END LOOP;
9201:
9202: -- Standard End of Procedure/Function Logging
9203: INL_LOGGING_PVT.Log_EndProc(
9204: p_module_name => g_module_name,
9205: p_procedure_name => l_program_name);
9206: EXCEPTION
9204: p_module_name => g_module_name,
9205: p_procedure_name => l_program_name);
9206: EXCEPTION
9207: WHEN L_FND_EXC_ERROR THEN
9208: -- Standard Expected Error Logging
9209: INL_LOGGING_PVT.Log_ExpecError (
9210: p_module_name => g_module_name,
9211: p_procedure_name => l_program_name);
9212: x_return_status := L_FND_RET_STS_ERROR;
9210: p_module_name => g_module_name,
9211: p_procedure_name => l_program_name);
9212: x_return_status := L_FND_RET_STS_ERROR;
9213: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
9214: -- Standard Unexpected Error Logging
9215: INL_LOGGING_PVT.Log_UnexpecError (
9216: p_module_name => g_module_name,
9217: p_procedure_name => l_program_name);
9218: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
9216: p_module_name => g_module_name,
9217: p_procedure_name => l_program_name);
9218: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
9219: WHEN OTHERS THEN
9220: -- Standard Unexpected Error Logging
9221: INL_LOGGING_PVT.Log_UnexpecError (
9222: p_module_name => g_module_name,
9223: p_procedure_name => l_program_name);
9224: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
9258: l_program_name CONSTANT VARCHAR2(100) := 'Import_Headers';
9259: l_debug_info VARCHAR2(2000);
9260: l_return_status VARCHAR2(1);
9261: BEGIN
9262: -- Standard Beginning of Procedure/Function Logging
9263: INL_LOGGING_PVT.Log_BeginProc(
9264: p_module_name => g_module_name,
9265: p_procedure_name => l_program_name) ;
9266:
9508:
9509: -- Bug 16310024
9510: x_ship_hdr_int_rec.ship_num := l_ship_num;
9511:
9512: -- Standard End of Procedure/Function Logging
9513: INL_LOGGING_PVT.Log_EndProc(
9514: p_module_name => g_module_name,
9515: p_procedure_name => l_program_name);
9516: EXCEPTION
9514: p_module_name => g_module_name,
9515: p_procedure_name => l_program_name);
9516: EXCEPTION
9517: WHEN L_FND_EXC_ERROR THEN
9518: -- Standard Expected Error Logging
9519: INL_LOGGING_PVT.Log_ExpecError (
9520: p_module_name => g_module_name,
9521: p_procedure_name => l_program_name);
9522: x_return_status := L_FND_RET_STS_ERROR;
9520: p_module_name => g_module_name,
9521: p_procedure_name => l_program_name);
9522: x_return_status := L_FND_RET_STS_ERROR;
9523: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
9524: -- Standard Unexpected Error Logging
9525: INL_LOGGING_PVT.Log_UnexpecError (
9526: p_module_name => g_module_name,
9527: p_procedure_name => l_program_name);
9528: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
9526: p_module_name => g_module_name,
9527: p_procedure_name => l_program_name);
9528: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
9529: WHEN OTHERS THEN
9530: -- Standard Unexpected Error Logging
9531: INL_LOGGING_PVT.Log_UnexpecError (
9532: p_module_name => g_module_name,
9533: p_procedure_name => l_program_name);
9534: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
9571: l_program_name CONSTANT VARCHAR2(100) := 'Set_existingMatchInfoFlag';
9572: l_debug_info VARCHAR2(2000) ;
9573: l_return_status VARCHAR2(1) ;
9574: BEGIN
9575: -- Standard Beginning of Procedure/Function Logging
9576: INL_LOGGING_PVT.Log_BeginProc(
9577: p_module_name => g_module_name,
9578: p_procedure_name => l_program_name) ;
9579: -- Initialize API return status to success
9597: x_existing_match_info_flag:='Y';
9598: ELSE
9599: x_existing_match_info_flag:='N';
9600: END IF;
9601: -- Standard End of Procedure/Function Logging
9602: INL_LOGGING_PVT.Log_EndProc(
9603: p_module_name => g_module_name,
9604: p_procedure_name => l_program_name
9605: );
9604: p_procedure_name => l_program_name
9605: );
9606: EXCEPTION
9607: WHEN L_FND_EXC_ERROR THEN
9608: -- Standard Expected Error Logging
9609: INL_LOGGING_PVT.Log_ExpecError (
9610: p_module_name => g_module_name,
9611: p_procedure_name => l_program_name
9612: );
9611: p_procedure_name => l_program_name
9612: );
9613: x_return_status := L_FND_RET_STS_ERROR;
9614: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
9615: -- Standard Unexpected Error Logging
9616: INL_LOGGING_PVT.Log_UnexpecError (
9617: p_module_name => g_module_name,
9618: p_procedure_name => l_program_name
9619: );
9618: p_procedure_name => l_program_name
9619: );
9620: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
9621: WHEN OTHERS THEN
9622: -- Standard Unexpected Error Logging
9623: INL_LOGGING_PVT.Log_UnexpecError (
9624: p_module_name => g_module_name,
9625: p_procedure_name => l_program_name
9626: );
9712: l_corr_from_parent_table_id NUMBER;
9713: l_currency_conversion_rate NUMBER;
9714:
9715: BEGIN
9716: -- Standard Beginning of Procedure/Function Logging
9717: INL_LOGGING_PVT.Log_BeginProc(
9718: p_module_name => g_module_name,
9719: p_procedure_name => l_program_name) ;
9720:
10056: FROM inl_matches
10057: WHERE match_id = l_mat_par_mat_id_P;
10058: END IF;
10059: --
10060: -- Standard End of Procedure/Function Logging
10061: INL_LOGGING_PVT.Log_EndProc(
10062: p_module_name => g_module_name,
10063: p_procedure_name => l_program_name
10064: );
10063: p_procedure_name => l_program_name
10064: );
10065: EXCEPTION
10066: WHEN L_FND_EXC_ERROR THEN
10067: -- Standard Expected Error Logging
10068: INL_LOGGING_PVT.Log_ExpecError (
10069: p_module_name => g_module_name,
10070: p_procedure_name => l_program_name
10071: );
10070: p_procedure_name => l_program_name
10071: );
10072: x_return_status := L_FND_RET_STS_ERROR;
10073: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
10074: -- Standard Unexpected Error Logging
10075: INL_LOGGING_PVT.Log_UnexpecError (
10076: p_module_name => g_module_name,
10077: p_procedure_name => l_program_name
10078: );
10077: p_procedure_name => l_program_name
10078: );
10079: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
10080: WHEN OTHERS THEN
10081: -- Standard Unexpected Error Logging
10082: INL_LOGGING_PVT.Log_UnexpecError (
10083: p_module_name => g_module_name,
10084: p_procedure_name => l_program_name
10085: );
10154: prorates_affctdByItem_lin c_prorates_affctdByItem_Type;
10155:
10156: l_count_unproc_match NUMBER; --Bug#14044298
10157: BEGIN
10158: -- Standard Beginning of Procedure/Function Logging
10159: INL_LOGGING_PVT.Log_BeginProc(
10160: p_module_name => g_module_name,
10161: p_procedure_name => l_program_name
10162: ) ;
10248: RAISE L_FND_EXC_UNEXPECTED_ERROR;
10249: END IF;
10250: END IF;
10251: --
10252: -- Standard End of Procedure/Function Logging
10253: INL_LOGGING_PVT.Log_EndProc(
10254: p_module_name => g_module_name,
10255: p_procedure_name => l_program_name
10256: );
10255: p_procedure_name => l_program_name
10256: );
10257: EXCEPTION
10258: WHEN L_FND_EXC_ERROR THEN
10259: -- Standard Expected Error Logging
10260: INL_LOGGING_PVT.Log_ExpecError (
10261: p_module_name => g_module_name,
10262: p_procedure_name => l_program_name
10263: );
10262: p_procedure_name => l_program_name
10263: );
10264: x_return_status := L_FND_RET_STS_ERROR;
10265: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
10266: -- Standard Unexpected Error Logging
10267: INL_LOGGING_PVT.Log_UnexpecError (
10268: p_module_name => g_module_name,
10269: p_procedure_name => l_program_name
10270: );
10269: p_procedure_name => l_program_name
10270: );
10271: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
10272: WHEN OTHERS THEN
10273: -- Standard Unexpected Error Logging
10274: INL_LOGGING_PVT.Log_UnexpecError (
10275: p_module_name => g_module_name,
10276: p_procedure_name => l_program_name
10277: );
10484: l_resource_busy BOOLEAN := FALSE;
10485: l_lock_error BOOLEAN := FALSE;
10486:
10487: BEGIN
10488: -- Standard Beginning of Procedure/Function Logging
10489: INL_LOGGING_PVT.Log_BeginProc(
10490: p_module_name => g_module_name,
10491: p_procedure_name => l_program_name
10492: ) ;
11009: IF l_lock_error THEN
11010: RAISE L_FND_EXC_ERROR;
11011: END IF;
11012: */
11013: -- Standard End of Procedure/Function Logging
11014: INL_LOGGING_PVT.Log_EndProc(
11015: p_module_name => g_module_name,
11016: p_procedure_name => l_program_name
11017: );
11016: p_procedure_name => l_program_name
11017: );
11018: EXCEPTION
11019: WHEN L_FND_EXC_ERROR THEN
11020: -- Standard Expected Error Logging
11021: INL_LOGGING_PVT.Log_ExpecError (
11022: p_module_name => g_module_name,
11023: p_procedure_name => l_program_name
11024: );
11033: mo_global.set_policy_context( l_previous_access_mode, l_previous_org_id);
11034: END IF;
11035: --Bug#10381495
11036: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
11037: -- Standard Unexpected Error Logging
11038: INL_LOGGING_PVT.Log_UnexpecError (
11039: p_module_name => g_module_name,
11040: p_procedure_name => l_program_name
11041: );
11050: mo_global.set_policy_context( l_previous_access_mode, l_previous_org_id);
11051: END IF;
11052: --Bug#10381495
11053: WHEN OTHERS THEN
11054: -- Standard Unexpected Error Logging
11055: INL_LOGGING_PVT.Log_UnexpecError (
11056: p_module_name => g_module_name,
11057: p_procedure_name => l_program_name
11058: );
11111: l_debug_info VARCHAR2(200) ;
11112: l_return_status VARCHAR2(1) ;
11113: BEGIN
11114:
11115: -- Standard Beginning of Procedure/Function Logging
11116: INL_LOGGING_PVT.Log_BeginProc(
11117: p_module_name => g_module_name,
11118: p_procedure_name => l_program_name
11119: ) ;
11162: AND from_parent_table_name = p_to_parent_table_name
11163: ;
11164: END IF;
11165:
11166: -- Standard End of Procedure/Function Logging
11167: INL_LOGGING_PVT.Log_EndProc(
11168: p_module_name => g_module_name,
11169: p_procedure_name => l_program_name
11170: );
11169: p_procedure_name => l_program_name
11170: );
11171: EXCEPTION
11172: WHEN L_FND_EXC_ERROR THEN
11173: -- Standard Expected Error Logging
11174: INL_LOGGING_PVT.Log_ExpecError (
11175: p_module_name => g_module_name,
11176: p_procedure_name => l_program_name
11177: );
11176: p_procedure_name => l_program_name
11177: );
11178: x_return_status := L_FND_RET_STS_ERROR;
11179: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
11180: -- Standard Unexpected Error Logging
11181: INL_LOGGING_PVT.Log_UnexpecError (
11182: p_module_name => g_module_name,
11183: p_procedure_name => l_program_name
11184: );
11183: p_procedure_name => l_program_name
11184: );
11185: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
11186: WHEN OTHERS THEN
11187: -- Standard Unexpected Error Logging
11188: INL_LOGGING_PVT.Log_UnexpecError (
11189: p_module_name => g_module_name,
11190: p_procedure_name => l_program_name
11191: );
11231: l_result VARCHAR2(1) := L_FND_TRUE;
11232: l_allocation_basis VARCHAR2(30);
11233: l_allocation_basis_uom_class VARCHAR2(30);
11234: BEGIN
11235: -- Standard Beginning of Procedure/Function Logging
11236: INL_LOGGING_PVT.Log_BeginProc(
11237: p_module_name => g_module_name,
11238: p_procedure_name => l_program_name
11239: ) ;
11329: RAISE L_FND_EXC_UNEXPECTED_ERROR;
11330: END IF;
11331: END IF;
11332: END IF;
11333: -- Standard End of Procedure/Function Logging
11334: INL_LOGGING_PVT.Log_EndProc(
11335: p_module_name => g_module_name,
11336: p_procedure_name => l_program_name
11337: );
11337: );
11338: RETURN FND_API.to_boolean(l_result) ;
11339: EXCEPTION
11340: WHEN L_FND_EXC_ERROR THEN
11341: -- Standard Expected Error Logging
11342: INL_LOGGING_PVT.Log_ExpecError (
11343: p_module_name => g_module_name,
11344: p_procedure_name => l_program_name
11345: );
11344: p_procedure_name => l_program_name
11345: );
11346: RETURN FND_API.to_boolean(L_FND_FALSE) ;
11347: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
11348: -- Standard Unexpected Error Logging
11349: INL_LOGGING_PVT.Log_UnexpecError (
11350: p_module_name => g_module_name,
11351: p_procedure_name => l_program_name
11352: );
11351: p_procedure_name => l_program_name
11352: );
11353: RETURN FND_API.to_boolean(L_FND_FALSE) ;
11354: WHEN OTHERS THEN
11355: -- Standard Unexpected Error Logging
11356: INL_LOGGING_PVT.Log_UnexpecError (
11357: p_module_name => g_module_name,
11358: p_procedure_name => l_program_name
11359: );
11396: l_debug_info VARCHAR2(400) ;
11397: l_return_status VARCHAR2(1) ;
11398: l_result VARCHAR2(1) := L_FND_TRUE;
11399: BEGIN
11400: -- Standard Beginning of Procedure/Function Logging
11401: INL_LOGGING_PVT.Log_BeginProc(
11402: p_module_name => g_module_name,
11403: p_procedure_name => l_program_name
11404: ) ;
11428: RAISE L_FND_EXC_UNEXPECTED_ERROR;
11429: END IF;
11430: END IF;
11431: END IF;
11432: -- Standard End of Procedure/Function Logging
11433: INL_LOGGING_PVT.Log_EndProc(
11434: p_module_name => g_module_name,
11435: p_procedure_name => l_program_name
11436: );
11436: );
11437: RETURN FND_API.to_boolean(l_result) ;
11438: EXCEPTION
11439: WHEN L_FND_EXC_ERROR THEN
11440: -- Standard Expected Error Logging
11441: INL_LOGGING_PVT.Log_ExpecError (
11442: p_module_name => g_module_name,
11443: p_procedure_name => l_program_name
11444: );
11443: p_procedure_name => l_program_name
11444: );
11445: RETURN FND_API.to_boolean(L_FND_FALSE) ;
11446: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
11447: -- Standard Unexpected Error Logging
11448: INL_LOGGING_PVT.Log_UnexpecError (
11449: p_module_name => g_module_name,
11450: p_procedure_name => l_program_name
11451: );
11450: p_procedure_name => l_program_name
11451: );
11452: RETURN FND_API.to_boolean(L_FND_FALSE) ;
11453: WHEN OTHERS THEN
11454: -- Standard Unexpected Error Logging
11455: INL_LOGGING_PVT.Log_UnexpecError (
11456: p_module_name => g_module_name,
11457: p_procedure_name => l_program_name
11458: );
11562: OI_matches_qty NUMBER;
11563: OI_matches_UOM_code VARCHAR2(3);
11564: OI_match_type_code VARCHAR2(30);
11565: BEGIN
11566: -- Standard Beginning of Procedure/Function Logging
11567: INL_LOGGING_PVT.Log_BeginProc(
11568: p_module_name => g_module_name,
11569: p_procedure_name => l_program_name
11570: ) ;
11926: p_module_name => g_module_name,
11927: p_procedure_name => l_program_name,
11928: p_debug_info => l_debug_info
11929: );
11930: -- Standard End of Procedure/Function Logging
11931: INL_LOGGING_PVT.Log_EndProc(
11932: p_module_name => g_module_name,
11933: p_procedure_name => l_program_name
11934: );
11934: );
11935: RETURN FND_API.to_boolean(l_result) ;
11936: EXCEPTION
11937: WHEN L_FND_EXC_ERROR THEN
11938: -- Standard Expected Error Logging
11939: INL_LOGGING_PVT.Log_ExpecError (
11940: p_module_name => g_module_name,
11941: p_procedure_name => l_program_name
11942: );
11941: p_procedure_name => l_program_name
11942: );
11943: RETURN FND_API.to_boolean(L_FND_FALSE) ;
11944: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
11945: -- Standard Unexpected Error Logging
11946: INL_LOGGING_PVT.Log_UnexpecError (
11947: p_module_name => g_module_name,
11948: p_procedure_name => l_program_name
11949: );
11948: p_procedure_name => l_program_name
11949: );
11950: RETURN FND_API.to_boolean(L_FND_FALSE) ;
11951: WHEN OTHERS THEN
11952: -- Standard Unexpected Error Logging
11953: INL_LOGGING_PVT.Log_UnexpecError (
11954: p_module_name => g_module_name,
11955: p_procedure_name => l_program_name
11956: );
11997: l_debug_info VARCHAR2(400) ;
11998: l_return_status VARCHAR2(1) ;
11999: l_result VARCHAR2(1) := L_FND_TRUE;
12000: BEGIN
12001: -- Standard Beginning of Procedure/Function Logging
12002: INL_LOGGING_PVT.Log_BeginProc(
12003: p_module_name => g_module_name,
12004: p_procedure_name => l_program_name
12005: ) ;
12101: IF l_return_status <> L_FND_RET_STS_SUCCESS THEN
12102: RAISE L_FND_EXC_UNEXPECTED_ERROR;
12103: END IF;
12104: END IF;
12105: -- Standard End of Procedure/Function Logging
12106: INL_LOGGING_PVT.Log_EndProc(
12107: p_module_name => g_module_name,
12108: p_procedure_name => l_program_name
12109: );
12109: );
12110: RETURN FND_API.to_boolean(l_result) ;
12111: EXCEPTION
12112: WHEN L_FND_EXC_ERROR THEN
12113: -- Standard Expected Error Logging
12114: INL_LOGGING_PVT.Log_ExpecError (
12115: p_module_name => g_module_name,
12116: p_procedure_name => l_program_name
12117: );
12116: p_procedure_name => l_program_name
12117: );
12118: RETURN FND_API.to_boolean(L_FND_FALSE) ;
12119: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
12120: -- Standard Unexpected Error Logging
12121: INL_LOGGING_PVT.Log_UnexpecError (
12122: p_module_name => g_module_name,
12123: p_procedure_name => l_program_name
12124: );
12123: p_procedure_name => l_program_name
12124: );
12125: RETURN FND_API.to_boolean(L_FND_FALSE) ;
12126: WHEN OTHERS THEN
12127: -- Standard Unexpected Error Logging
12128: INL_LOGGING_PVT.Log_UnexpecError (
12129: p_module_name => g_module_name,
12130: p_procedure_name => l_program_name
12131: );
12178: l_debug_info VARCHAR2(400) ;
12179: l_return_status VARCHAR2(1) ;
12180: l_result VARCHAR2(1) := L_FND_TRUE;
12181: BEGIN
12182: -- Standard Beginning of Procedure/Function Logging
12183: INL_LOGGING_PVT.Log_BeginProc(
12184: p_module_name => g_module_name,
12185: p_procedure_name => l_program_name
12186: ) ;
12240: IF l_return_status <> L_FND_RET_STS_SUCCESS THEN
12241: RAISE L_FND_EXC_UNEXPECTED_ERROR;
12242: END IF;
12243: END IF;
12244: -- Standard End of Procedure/Function Logging
12245: INL_LOGGING_PVT.Log_EndProc(
12246: p_module_name => g_module_name,
12247: p_procedure_name => l_program_name
12248: );
12248: );
12249: RETURN FND_API.to_boolean(l_result) ;
12250: EXCEPTION
12251: WHEN L_FND_EXC_ERROR THEN
12252: -- Standard Expected Error Logging
12253: INL_LOGGING_PVT.Log_ExpecError (
12254: p_module_name => g_module_name,
12255: p_procedure_name => l_program_name
12256: );
12255: p_procedure_name => l_program_name
12256: );
12257: RETURN FND_API.to_boolean(L_FND_FALSE) ;
12258: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
12259: -- Standard Unexpected Error Logging
12260: INL_LOGGING_PVT.Log_UnexpecError (
12261: p_module_name => g_module_name,
12262: p_procedure_name => l_program_name
12263: );
12262: p_procedure_name => l_program_name
12263: );
12264: RETURN FND_API.to_boolean(L_FND_FALSE) ;
12265: WHEN OTHERS THEN
12266: -- Standard Unexpected Error Logging
12267: INL_LOGGING_PVT.Log_UnexpecError (
12268: p_module_name => g_module_name,
12269: p_procedure_name => l_program_name
12270: );
12321: RESOURCE_BUSY EXCEPTION;
12322: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -00054);
12323:
12324: BEGIN
12325: -- Standard Beginning of Procedure/Function Logging
12326: INL_LOGGING_PVT.Log_BeginProc(
12327: p_module_name => g_module_name,
12328: p_procedure_name => l_program_name
12329: ) ;
12643: RAISE L_FND_EXC_UNEXPECTED_ERROR;
12644: END IF;
12645: END IF;
12646: END IF;
12647: -- Standard End of Procedure/Function Logging
12648: INL_LOGGING_PVT.Log_EndProc(
12649: p_module_name => g_module_name,
12650: p_procedure_name => l_program_name
12651: );
12663: FND_MESSAGE.set_name('INL','INL_ERR_OI_CHK_LCK_SHIPMENT');
12664: FND_MESSAGE.set_token('GROUP_ID',l_group_id);
12665: FND_MSG_PUB.ADD;
12666:
12667: -- Standard Expected Error Logging
12668: INL_LOGGING_PVT.Log_ExpecError (
12669: p_module_name => g_module_name,
12670: p_procedure_name => l_program_name);
12671: RETURN FND_API.to_boolean(L_FND_FALSE);
12669: p_module_name => g_module_name,
12670: p_procedure_name => l_program_name);
12671: RETURN FND_API.to_boolean(L_FND_FALSE);
12672: WHEN L_FND_EXC_ERROR THEN
12673: -- Standard Expected Error Logging
12674: INL_LOGGING_PVT.Log_ExpecError (
12675: p_module_name => g_module_name,
12676: p_procedure_name => l_program_name
12677: );
12676: p_procedure_name => l_program_name
12677: );
12678: RETURN FND_API.to_boolean(L_FND_FALSE) ;
12679: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
12680: -- Standard Unexpected Error Logging
12681: INL_LOGGING_PVT.Log_UnexpecError (
12682: p_module_name => g_module_name,
12683: p_procedure_name => l_program_name
12684: );
12683: p_procedure_name => l_program_name
12684: );
12685: RETURN FND_API.to_boolean(L_FND_FALSE) ;
12686: WHEN OTHERS THEN
12687: -- Standard Unexpected Error Logging
12688: INL_LOGGING_PVT.Log_UnexpecError (
12689: p_module_name => g_module_name,
12690: p_procedure_name => l_program_name
12691: );
12729: l_return_status VARCHAR2(1) ;
12730: l_result VARCHAR2(1) := L_FND_TRUE;
12731: l_uom VARCHAR2(100) ;
12732: BEGIN
12733: -- Standard Beginning of Procedure/Function Logging
12734: INL_LOGGING_PVT.Log_BeginProc(
12735: p_module_name => g_module_name,
12736: p_procedure_name => l_program_name
12737: ) ;
12811: RAISE L_FND_EXC_UNEXPECTED_ERROR;
12812: END IF;
12813: END IF;
12814: END IF;
12815: -- Standard End of Procedure/Function Logging
12816: INL_LOGGING_PVT.Log_EndProc(
12817: p_module_name => g_module_name,
12818: p_procedure_name => l_program_name
12819: );
12819: );
12820: RETURN FND_API.to_boolean(l_result) ;
12821: EXCEPTION
12822: WHEN L_FND_EXC_ERROR THEN
12823: -- Standard Expected Error Logging
12824: INL_LOGGING_PVT.Log_ExpecError (
12825: p_module_name => g_module_name,
12826: p_procedure_name => l_program_name
12827: );
12826: p_procedure_name => l_program_name
12827: );
12828: RETURN FND_API.to_boolean(L_FND_FALSE) ;
12829: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
12830: -- Standard Unexpected Error Logging
12831: INL_LOGGING_PVT.Log_UnexpecError (
12832: p_module_name => g_module_name,
12833: p_procedure_name => l_program_name
12834: );
12833: p_procedure_name => l_program_name
12834: );
12835: RETURN FND_API.to_boolean(L_FND_FALSE) ;
12836: WHEN OTHERS THEN
12837: -- Standard Unexpected Error Logging
12838: INL_LOGGING_PVT.Log_UnexpecError (
12839: p_module_name => g_module_name,
12840: p_procedure_name => l_program_name
12841: );
12881: l_return_status VARCHAR2(1) ;
12882: l_result VARCHAR2(1) := L_FND_TRUE;
12883: l_adj_alr_gen_flag VARCHAR2(1) ;
12884: BEGIN
12885: -- Standard Beginning of Procedure/Function Logging
12886: INL_LOGGING_PVT.Log_BeginProc(
12887: p_module_name => g_module_name,
12888: p_procedure_name => l_program_name
12889: ) ;
13045: END;
13046: END IF;
13047: END IF;
13048: END IF;
13049: -- Standard End of Procedure/Function Logging
13050: INL_LOGGING_PVT.Log_EndProc(
13051: p_module_name => g_module_name,
13052: p_procedure_name => l_program_name
13053: );
13053: );
13054: RETURN FND_API.to_boolean(l_result) ;
13055: EXCEPTION
13056: WHEN L_FND_EXC_ERROR THEN
13057: -- Standard Expected Error Logging
13058: INL_LOGGING_PVT.Log_ExpecError (
13059: p_module_name => g_module_name,
13060: p_procedure_name => l_program_name
13061: );
13060: p_procedure_name => l_program_name
13061: );
13062: RETURN FND_API.to_boolean(L_FND_FALSE) ;
13063: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
13064: -- Standard Unexpected Error Logging
13065: INL_LOGGING_PVT.Log_UnexpecError (
13066: p_module_name => g_module_name,
13067: p_procedure_name => l_program_name
13068: );
13067: p_procedure_name => l_program_name
13068: );
13069: RETURN FND_API.to_boolean(L_FND_FALSE) ;
13070: WHEN OTHERS THEN
13071: -- Standard Unexpected Error Logging
13072: INL_LOGGING_PVT.Log_UnexpecError (
13073: p_module_name => g_module_name,
13074: p_procedure_name => l_program_name
13075: );
13126: l_SHidOk VARCHAR2(1) ;
13127: l_INT_importedOk VARCHAR2(1) ;
13128: l_matchTpCdOk VARCHAR2(1) ;
13129: BEGIN
13130: -- Standard Beginning of Procedure/Function Logging
13131: INL_LOGGING_PVT.Log_BeginProc(
13132: p_module_name => g_module_name,
13133: p_procedure_name => l_program_name
13134: ) ;
13474: RAISE L_FND_EXC_UNEXPECTED_ERROR;
13475: END IF;
13476: END IF;
13477: END IF;
13478: -- Standard End of Procedure/Function Logging
13479: INL_LOGGING_PVT.Log_EndProc(
13480: p_module_name => g_module_name,
13481: p_procedure_name => l_program_name
13482: );
13482: );
13483: RETURN FND_API.to_boolean(l_result) ;
13484: EXCEPTION
13485: WHEN L_FND_EXC_ERROR THEN
13486: -- Standard Expected Error Logging
13487: INL_LOGGING_PVT.Log_ExpecError (
13488: p_module_name => g_module_name,
13489: p_procedure_name => l_program_name
13490: );
13489: p_procedure_name => l_program_name
13490: );
13491: RETURN FND_API.to_boolean(L_FND_FALSE) ;
13492: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
13493: -- Standard Unexpected Error Logging
13494: INL_LOGGING_PVT.Log_UnexpecError (
13495: p_module_name => g_module_name,
13496: p_procedure_name => l_program_name
13497: );
13496: p_procedure_name => l_program_name
13497: );
13498: RETURN FND_API.to_boolean(L_FND_FALSE) ;
13499: WHEN OTHERS THEN
13500: -- Standard Unexpected Error Logging
13501: INL_LOGGING_PVT.Log_UnexpecError (
13502: p_module_name => g_module_name,
13503: p_procedure_name => l_program_name
13504: );
13546: l_adj_already_generated_flag VARCHAR2(1) ;
13547: l_replace_estim_qty_flag VARCHAR2(1) ;
13548: l_other_REQF_Y_match_id NUMBER;
13549: BEGIN
13550: -- Standard Beginning of Procedure/Function Logging
13551: INL_LOGGING_PVT.Log_BeginProc(
13552: p_module_name => g_module_name,
13553: p_procedure_name => l_program_name
13554: ) ;
13755: IF l_return_status <> L_FND_RET_STS_SUCCESS THEN
13756: RAISE L_FND_EXC_UNEXPECTED_ERROR;
13757: END IF;
13758: END IF;
13759: -- Standard End of Procedure/Function Logging
13760: INL_LOGGING_PVT.Log_EndProc(
13761: p_module_name => g_module_name,
13762: p_procedure_name => l_program_name
13763: );
13763: );
13764: RETURN FND_API.to_boolean(l_result) ;
13765: EXCEPTION
13766: WHEN L_FND_EXC_ERROR THEN
13767: -- Standard Expected Error Logging
13768: INL_LOGGING_PVT.Log_ExpecError (
13769: p_module_name => g_module_name,
13770: p_procedure_name => l_program_name
13771: );
13770: p_procedure_name => l_program_name
13771: );
13772: RETURN FND_API.to_boolean(L_FND_FALSE) ;
13773: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
13774: -- Standard Unexpected Error Logging
13775: INL_LOGGING_PVT.Log_UnexpecError (
13776: p_module_name => g_module_name,
13777: p_procedure_name => l_program_name
13778: );
13777: p_procedure_name => l_program_name
13778: );
13779: RETURN FND_API.to_boolean(L_FND_FALSE) ;
13780: WHEN OTHERS THEN
13781: -- Standard Unexpected Error Logging
13782: INL_LOGGING_PVT.Log_UnexpecError (
13783: p_module_name => g_module_name,
13784: p_procedure_name => l_program_name
13785: );
13824: l_result VARCHAR2(1) := L_FND_TRUE;
13825: l_field VARCHAR2(30) ;
13826: l_field_id NUMBER;
13827: BEGIN
13828: -- Standard Beginning of Procedure/Function Logging
13829: INL_LOGGING_PVT.Log_BeginProc(
13830: p_module_name => g_module_name,
13831: p_procedure_name => l_program_name
13832: ) ;
13975: RAISE L_FND_EXC_UNEXPECTED_ERROR;
13976: END IF;
13977: END IF;
13978: END IF;
13979: -- Standard End of Procedure/Function Logging
13980: INL_LOGGING_PVT.Log_EndProc(
13981: p_module_name => g_module_name,
13982: p_procedure_name => l_program_name
13983: );
13983: );
13984: RETURN FND_API.to_boolean(l_result) ;
13985: EXCEPTION
13986: WHEN L_FND_EXC_ERROR THEN
13987: -- Standard Expected Error Logging
13988: INL_LOGGING_PVT.Log_ExpecError (
13989: p_module_name => g_module_name,
13990: p_procedure_name => l_program_name
13991: );
13990: p_procedure_name => l_program_name
13991: );
13992: RETURN FND_API.to_boolean(L_FND_FALSE) ;
13993: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
13994: -- Standard Unexpected Error Logging
13995: INL_LOGGING_PVT.Log_UnexpecError (
13996: p_module_name => g_module_name,
13997: p_procedure_name => l_program_name
13998: );
13997: p_procedure_name => l_program_name
13998: );
13999: RETURN FND_API.to_boolean(L_FND_FALSE) ;
14000: WHEN OTHERS THEN
14001: -- Standard Unexpected Error Logging
14002: INL_LOGGING_PVT.Log_UnexpecError (
14003: p_module_name => g_module_name,
14004: p_procedure_name => l_program_name
14005: );
14040: l_parent_matched_curr_code VARCHAR2(15) ;
14041: l_parent_to_parent_table_name VARCHAR2(100) ;
14042: l_parent_to_parent_table_ID NUMBER;
14043: BEGIN
14044: -- Standard Beginning of Procedure/Function Logging
14045: INL_LOGGING_PVT.Log_BeginProc(
14046: p_module_name => g_module_name,
14047: p_procedure_name => l_program_name
14048: ) ;
14474: IF l_return_status <> L_FND_RET_STS_SUCCESS THEN
14475: RAISE L_FND_EXC_UNEXPECTED_ERROR;
14476: END IF;
14477: */
14478: -- Standard End of Procedure/Function Logging
14479: INL_LOGGING_PVT.Log_EndProc(
14480: p_module_name => g_module_name,
14481: p_procedure_name => l_program_name
14482: );
14482: );
14483: RETURN FND_API.to_boolean(x_result) ;
14484: EXCEPTION
14485: WHEN L_FND_EXC_ERROR THEN
14486: -- Standard Expected Error Logging
14487: INL_LOGGING_PVT.Log_ExpecError (
14488: p_module_name => g_module_name,
14489: p_procedure_name => l_program_name
14490: );
14489: p_procedure_name => l_program_name
14490: );
14491: RETURN FND_API.to_boolean(L_FND_FALSE) ;
14492: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
14493: -- Standard Unexpected Error Logging
14494: INL_LOGGING_PVT.Log_UnexpecError (
14495: p_module_name => g_module_name,
14496: p_procedure_name => l_program_name
14497: );
14496: p_procedure_name => l_program_name
14497: );
14498: RETURN FND_API.to_boolean(L_FND_FALSE) ;
14499: WHEN OTHERS THEN
14500: -- Standard Unexpected Error Logging
14501: INL_LOGGING_PVT.Log_UnexpecError (
14502: p_module_name => g_module_name,
14503: p_procedure_name => l_program_name
14504: );
14541: l_lock_name VARCHAR2(50) := 'select_MatchesToProc';
14542: l_lock_handle VARCHAR2(100);
14543: l_lock_status NUMBER;
14544: BEGIN
14545: -- Standard Beginning of Procedure/Function Logging
14546: INL_LOGGING_PVT.Log_BeginProc(
14547: p_module_name => g_module_name,
14548: p_procedure_name => l_program_name
14549: ) ;
14712: p_module_name => g_module_name,
14713: p_procedure_name => l_program_name,
14714: p_debug_info => l_return_value||' selected records');
14715:
14716: -- Standard check of p_commit.
14717: IF FND_API.To_Boolean(p_commit) THEN
14718: COMMIT WORK;
14719: END IF;
14720:
14725: RETURN l_return_value;
14726:
14727: EXCEPTION
14728: WHEN L_FND_EXC_ERROR THEN
14729: -- Standard Expected Error Logging
14730: INL_LOGGING_PVT.Log_ExpecError (
14731: p_module_name => g_module_name,
14732: p_procedure_name => l_program_name
14733: );
14736: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
14737: END IF;
14738: RETURN 0;
14739: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
14740: -- Standard Unexpected Error Logging
14741: INL_LOGGING_PVT.Log_UnexpecError (
14742: p_module_name => g_module_name,
14743: p_procedure_name => l_program_name
14744: );
14747: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
14748: END IF;
14749: RETURN 0;
14750: WHEN OTHERS THEN
14751: -- Standard Unexpected Error Logging
14752: INL_LOGGING_PVT.Log_UnexpecError (
14753: p_module_name => g_module_name,
14754: p_procedure_name => l_program_name
14755: );
14862: l_max_match_int_id NUMBER; --Bug#16198838/14707257
14863: l_max_match_int_id2 NUMBER; --Bug#16198838/14707257
14864:
14865: BEGIN
14866: -- Standard Beginning of Procedure/Function Logging
14867: INL_LOGGING_PVT.Log_BeginProc(
14868: p_module_name => g_module_name,
14869: p_procedure_name => l_program_name
14870: ) ;
15142: END IF;
15143:
15144: --Bug#11794442
15145: END LOOP;
15146: -- Standard check of p_commit.
15147: IF FND_API.To_Boolean(p_commit) THEN
15148: COMMIT WORK;
15149: END IF;
15150:
15229: EXIT;
15230: END IF;
15231: END LOOP; --Bug#11794442
15232:
15233: -- Standard End of Procedure/Function Logging
15234: INL_LOGGING_PVT.Log_EndProc(
15235: p_module_name => g_module_name,
15236: p_procedure_name => l_program_name
15237: );
15236: p_procedure_name => l_program_name
15237: );
15238: EXCEPTION
15239: WHEN L_FND_EXC_ERROR THEN
15240: -- Standard Expected Error Logging
15241: INL_LOGGING_PVT.Log_ExpecError (
15242: p_module_name => g_module_name,
15243: p_procedure_name => l_program_name
15244: );
15243: p_procedure_name => l_program_name
15244: );
15245: x_return_status := L_FND_RET_STS_ERROR;
15246: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
15247: -- Standard Unexpected Error Logging
15248: INL_LOGGING_PVT.Log_UnexpecError (
15249: p_module_name => g_module_name,
15250: p_procedure_name => l_program_name
15251: );
15250: p_procedure_name => l_program_name
15251: );
15252: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
15253: WHEN OTHERS THEN
15254: -- Standard Unexpected Error Logging
15255: INL_LOGGING_PVT.Log_UnexpecError (
15256: p_module_name => g_module_name,
15257: p_procedure_name => l_program_name
15258: );
15311: TYPE shipToDelete_ListType IS TABLE OF c_shipToDelete%ROWTYPE;
15312: shipToDelete_List shipToDelete_ListType;
15313:
15314: BEGIN
15315: -- Standard Beginning of Procedure/Function Logging
15316: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
15317: p_procedure_name => l_program_name ) ;
15318:
15319: -- Standard Start of API savepoint
15315: -- Standard Beginning of Procedure/Function Logging
15316: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
15317: p_procedure_name => l_program_name ) ;
15318:
15319: -- Standard Start of API savepoint
15320: SAVEPOINT Purge_LCMShipInt_PVT;
15321:
15322: -- Initialize message list if p_init_msg_list is set to TRUE.
15323: IF FND_API.to_Boolean(p_init_msg_list) THEN
15323: IF FND_API.to_Boolean(p_init_msg_list) THEN
15324: FND_MSG_PUB.initialize;
15325: END IF;
15326:
15327: -- Standard call to check for call compatibility
15328: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
15329: p_caller_version_number => p_api_version,
15330: p_api_name => l_program_name,
15331: p_pkg_name => g_pkg_name)
15368:
15369: END LOOP;
15370: END IF;
15371:
15372: -- Standard check of p_commit.
15373: IF FND_API.To_Boolean(p_commit) THEN
15374: COMMIT WORK;
15375: END IF;
15376:
15373: IF FND_API.To_Boolean(p_commit) THEN
15374: COMMIT WORK;
15375: END IF;
15376:
15377: -- Standard call to get message count and if count is 1, get message info.
15378: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
15379: p_count => x_msg_count,
15380: p_data => x_msg_data) ;
15381:
15378: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
15379: p_count => x_msg_count,
15380: p_data => x_msg_data) ;
15381:
15382: -- Standard End of Procedure/Function Logging
15383: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
15384: p_procedure_name => l_program_name);
15385:
15386: EXCEPTION
15384: p_procedure_name => l_program_name);
15385:
15386: EXCEPTION
15387: WHEN L_FND_EXC_ERROR THEN
15388: -- Standard Expected Error Logging
15389: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
15390: p_procedure_name => l_program_name);
15391: ROLLBACK TO Purge_LCMShipInt_PVT;
15392: x_return_status := L_FND_RET_STS_ERROR;
15393: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
15394: p_count => x_msg_count,
15395: p_data => x_msg_data);
15396: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
15397: -- Standard Unexpected Error Logging
15398: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
15399: p_procedure_name => l_program_name);
15400: ROLLBACK TO Purge_LCMShipInt_PVT;
15401: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
15402: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
15403: p_count => x_msg_count,
15404: p_data => x_msg_data);
15405: WHEN OTHERS THEN
15406: -- Standard Unexpected Error Logging
15407: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
15408: p_procedure_name => l_program_name);
15409: ROLLBACK TO Purge_LCMShipInt_PVT;
15410: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
15457: l_debug_info VARCHAR2(200);
15458:
15459: BEGIN
15460:
15461: -- Standard Beginning of Procedure/Function Logging
15462: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
15463: p_procedure_name => l_program_name ) ;
15464:
15465: -- Standard Start of API savepoint
15461: -- Standard Beginning of Procedure/Function Logging
15462: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
15463: p_procedure_name => l_program_name ) ;
15464:
15465: -- Standard Start of API savepoint
15466: SAVEPOINT Purge_LCMMatchesInt_PVT;
15467:
15468: -- Initialize message list if p_init_msg_list is set to TRUE.
15469: IF FND_API.to_Boolean(p_init_msg_list) THEN
15469: IF FND_API.to_Boolean(p_init_msg_list) THEN
15470: FND_MSG_PUB.initialize;
15471: END IF;
15472:
15473: -- Standard call to check for call compatibility
15474: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,
15475: p_caller_version_number => p_api_version,
15476: p_api_name => l_program_name,
15477: p_pkg_name => g_pkg_name)
15496: DELETE FROM inl_matches_int
15497: WHERE (p_group_id IS NULL OR group_id = p_group_id)
15498: AND processing_status_code = 'COMPLETED';
15499:
15500: -- Standard check of p_commit.
15501: IF FND_API.To_Boolean(p_commit) THEN
15502: COMMIT WORK;
15503: END IF;
15504:
15501: IF FND_API.To_Boolean(p_commit) THEN
15502: COMMIT WORK;
15503: END IF;
15504:
15505: -- Standard call to get message count and if count is 1, get message info.
15506: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
15507: p_count => x_msg_count,
15508: p_data => x_msg_data) ;
15509:
15506: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
15507: p_count => x_msg_count,
15508: p_data => x_msg_data) ;
15509:
15510: -- Standard End of Procedure/Function Logging
15511: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
15512: p_procedure_name => l_program_name);
15513:
15514: EXCEPTION
15512: p_procedure_name => l_program_name);
15513:
15514: EXCEPTION
15515: WHEN L_FND_EXC_ERROR THEN
15516: -- Standard Expected Error Logging
15517: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
15518: p_procedure_name => l_program_name);
15519: ROLLBACK TO Purge_LCMMatchesInt_PVT;
15520: x_return_status := L_FND_RET_STS_ERROR;
15521: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
15522: p_count => x_msg_count,
15523: p_data => x_msg_data);
15524: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
15525: -- Standard Unexpected Error Logging
15526: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
15527: p_procedure_name => l_program_name);
15528: ROLLBACK TO Purge_LCMMatchesInt_PVT;
15529: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
15530: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
15531: p_count => x_msg_count,
15532: p_data => x_msg_data);
15533: WHEN OTHERS THEN
15534: -- Standard Unexpected Error Logging
15535: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
15536: p_procedure_name => l_program_name);
15537: ROLLBACK TO Purge_LCMMatchesInt_PVT;
15538: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
15573: l_msg_count NUMBER;
15574: l_init_msg_list VARCHAR2(2000) := L_FND_FALSE;
15575:
15576: BEGIN
15577: -- Standard Beginning of Procedure/Function Logging
15578: INL_LOGGING_PVT.Log_BeginProc(
15579: p_module_name => g_module_name,
15580: p_procedure_name => l_program_name
15581: ) ;
15598: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
15599: RAISE L_FND_EXC_UNEXPECTED_ERROR;
15600: END IF;
15601:
15602: -- Standard check of p_commit.
15603: IF FND_API.To_Boolean(p_commit) THEN
15604: COMMIT WORK;
15605: END IF;
15606:
15621: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
15622: RAISE L_FND_EXC_UNEXPECTED_ERROR;
15623: END IF;
15624:
15625: -- Standard End of Procedure/Function Logging
15626: INL_LOGGING_PVT.Log_EndProc(
15627: p_module_name => g_module_name,
15628: p_procedure_name => l_program_name
15629: );
15628: p_procedure_name => l_program_name
15629: );
15630: EXCEPTION
15631: WHEN L_FND_EXC_ERROR THEN
15632: -- Standard Expected Error Logging
15633: INL_LOGGING_PVT.Log_ExpecError (
15634: p_module_name => g_module_name,
15635: p_procedure_name => l_program_name
15636: );
15635: p_procedure_name => l_program_name
15636: );
15637: x_return_status := L_FND_RET_STS_ERROR;
15638: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
15639: -- Standard Unexpected Error Logging
15640: INL_LOGGING_PVT.Log_UnexpecError (
15641: p_module_name => g_module_name,
15642: p_procedure_name => l_program_name
15643: );
15642: p_procedure_name => l_program_name
15643: );
15644: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
15645: WHEN OTHERS THEN
15646: -- Standard Unexpected Error Logging
15647: INL_LOGGING_PVT.Log_UnexpecError (
15648: p_module_name => g_module_name,
15649: p_procedure_name => l_program_name
15650: );
15692: retcode := 0;
15693: g_records_processed := 0;
15694: g_records_inserted := 0;
15695:
15696: -- Standard Beginning of Procedure/Function Logging
15697: INL_LOGGING_PVT.Log_BeginProc(
15698: p_module_name => g_module_name,
15699: p_procedure_name => l_program_name) ;
15700:
15742: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
15743: RAISE L_FND_EXC_UNEXPECTED_ERROR;
15744: END IF;
15745:
15746: -- Standard End of Procedure/Function Logging
15747: INL_LOGGING_PVT.Log_EndProc(
15748: p_module_name => g_module_name,
15749: p_procedure_name => l_program_name);
15750:
15749: p_procedure_name => l_program_name);
15750:
15751: EXCEPTION
15752: WHEN L_FND_EXC_ERROR THEN
15753: -- Standard Expected Error Logging
15754: INL_LOGGING_PVT.Log_ExpecError (
15755: p_module_name => g_module_name,
15756: p_procedure_name => l_program_name);
15757: retcode := 1;
15756: p_procedure_name => l_program_name);
15757: retcode := 1;
15758: errbuf := errbuf ||' G_EXC_ERROR '||SQLERRM;
15759: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
15760: -- Standard Unexpected Error Logging
15761: INL_LOGGING_PVT.Log_UnexpecError(
15762: p_module_name => g_module_name,
15763: p_procedure_name => l_program_name);
15764: retcode := 2;
15763: p_procedure_name => l_program_name);
15764: retcode := 2;
15765: errbuf := errbuf ||' G_EXC_UNEXPECTED_ERROR '||SQLERRM;
15766: WHEN OTHERS THEN
15767: -- Standard Unexpected Error Logging
15768: INL_LOGGING_PVT.Log_UnexpecError(
15769: p_module_name => g_module_name,
15770: p_procedure_name => l_program_name);
15771: retcode := 2;
15804: retcode := 0;
15805: g_records_processed := 0;
15806: g_records_inserted := 0;
15807:
15808: -- Standard Beginning of Procedure/Function Logging
15809: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
15810: p_procedure_name => l_program_name);
15811:
15812: l_debug_info := 'Call Import_LCMMatches';
15850: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
15851: RAISE L_FND_EXC_UNEXPECTED_ERROR;
15852: END IF;
15853:
15854: -- Standard End of Procedure/Function Logging
15855: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
15856: p_procedure_name => l_program_name);
15857: EXCEPTION
15858: WHEN L_FND_EXC_ERROR THEN
15855: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
15856: p_procedure_name => l_program_name);
15857: EXCEPTION
15858: WHEN L_FND_EXC_ERROR THEN
15859: -- Standard Expected Error Logging
15860: INL_LOGGING_PVT.Log_ExpecError (
15861: p_module_name => g_module_name,
15862: p_procedure_name => l_program_name
15863: );
15862: p_procedure_name => l_program_name
15863: );
15864: retcode := 1;
15865: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
15866: -- Standard Unexpected Error Logging
15867: INL_LOGGING_PVT.Log_UnexpecError(
15868: p_module_name => g_module_name,
15869: p_procedure_name => l_program_name
15870: );
15869: p_procedure_name => l_program_name
15870: );
15871: retcode := 2;
15872: WHEN OTHERS THEN
15873: -- Standard Unexpected Error Logging
15874: INL_LOGGING_PVT.Log_UnexpecError(
15875: p_module_name => g_module_name,
15876: p_procedure_name => l_program_name
15877: );
15912: l_msg_count NUMBER;
15913: l_msg_data VARCHAR2(2000) ;
15914: l_debug_info VARCHAR2(200) ;
15915: BEGIN
15916: -- Standard Beginning of Procedure/Function Logging
15917: INL_LOGGING_PVT.Log_BeginProc(
15918: p_module_name => g_module_name,
15919: p_procedure_name => l_program_name
15920: ) ;
15918: p_module_name => g_module_name,
15919: p_procedure_name => l_program_name
15920: ) ;
15921:
15922: -- Standard Start of API savepoint
15923: SAVEPOINT Import_LCMMatches_PVT;
15924: -- Initialize message list if p_init_msg_list is set to TRUE.
15925: IF FND_API.to_Boolean(p_init_msg_list) THEN
15926: FND_MSG_PUB.initialize;
15924: -- Initialize message list if p_init_msg_list is set to TRUE.
15925: IF FND_API.to_Boolean(p_init_msg_list) THEN
15926: FND_MSG_PUB.initialize;
15927: END IF;
15928: -- Standard call to check for call compatibility
15929: IF NOT FND_API.Compatible_API_Call(
15930: p_current_version_number => l_api_version,
15931: p_caller_version_number => p_api_version,
15932: p_api_name => l_program_name,
15970: RAISE L_FND_EXC_ERROR;
15971: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
15972: RAISE L_FND_EXC_UNEXPECTED_ERROR;
15973: END IF;
15974: -- Standard check of p_commit.
15975: IF FND_API.To_Boolean(p_commit) THEN
15976: COMMIT WORK;
15977: END IF;
15978: -- Standard call to get message count and if count is 1, get message info.
15974: -- Standard check of p_commit.
15975: IF FND_API.To_Boolean(p_commit) THEN
15976: COMMIT WORK;
15977: END IF;
15978: -- Standard call to get message count and if count is 1, get message info.
15979: FND_MSG_PUB.Count_And_Get(
15980: p_encoded => L_FND_FALSE,
15981: p_count => x_msg_count,
15982: p_data => x_msg_data
15980: p_encoded => L_FND_FALSE,
15981: p_count => x_msg_count,
15982: p_data => x_msg_data
15983: ) ;
15984: -- Standard End of Procedure/Function Logging
15985: INL_LOGGING_PVT.Log_EndProc(
15986: p_module_name => g_module_name,
15987: p_procedure_name => l_program_name
15988: );
15987: p_procedure_name => l_program_name
15988: );
15989: EXCEPTION
15990: WHEN L_FND_EXC_ERROR THEN
15991: -- Standard Expected Error Logging
15992: INL_LOGGING_PVT.Log_ExpecError (
15993: p_module_name => g_module_name,
15994: p_procedure_name => l_program_name
15995: );
16000: p_count => x_msg_count,
16001: p_data => x_msg_data
16002: );
16003: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
16004: -- Standard Unexpected Error Logging
16005: INL_LOGGING_PVT.Log_UnexpecError (
16006: p_module_name => g_module_name,
16007: p_procedure_name => l_program_name
16008: );
16013: p_count => x_msg_count,
16014: p_data => x_msg_data
16015: );
16016: WHEN OTHERS THEN
16017: -- Standard Unexpected Error Logging
16018: INL_LOGGING_PVT.Log_UnexpecError (
16019: p_module_name => g_module_name,
16020: p_procedure_name => l_program_name
16021: );
16066: l_lock_name VARCHAR2(50) := 'select_LCMShipToProc';
16067: l_lock_handle VARCHAR2(100);
16068: l_lock_status NUMBER;
16069: BEGIN
16070: -- Standard Beginning of Procedure/Function Logging
16071: INL_LOGGING_PVT.Log_BeginProc(
16072: p_module_name => g_module_name,
16073: p_procedure_name => l_program_name
16074: ) ;
16133: RETURN l_return_value;
16134:
16135: EXCEPTION
16136: WHEN L_FND_EXC_ERROR THEN
16137: -- Standard Expected Error Logging
16138: INL_LOGGING_PVT.Log_ExpecError (
16139: p_module_name => g_module_name,
16140: p_procedure_name => l_program_name
16141: );
16144: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
16145: END IF;
16146: RETURN 0;
16147: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
16148: -- Standard Unexpected Error Logging
16149: INL_LOGGING_PVT.Log_UnexpecError (
16150: p_module_name => g_module_name,
16151: p_procedure_name => l_program_name
16152: );
16155: l_lock_status := DBMS_LOCK.Release(l_lock_handle);
16156: END IF;
16157: RETURN 0;
16158: WHEN OTHERS THEN
16159: -- Standard Unexpected Error Logging
16160: INL_LOGGING_PVT.Log_UnexpecError (
16161: p_module_name => g_module_name,
16162: p_procedure_name => l_program_name
16163: );
16196:
16197: l_count_records NUMBER;
16198:
16199: BEGIN
16200: -- Standard Beginning of Procedure/Function Logging
16201: INL_LOGGING_PVT.Log_BeginProc(
16202: p_module_name => g_module_name,
16203: p_procedure_name => l_program_name
16204: ) ;
16294: FROM inl_ship_lines_int l
16295: WHERE l.ship_header_int_id = h.ship_header_int_id
16296: AND ROWNUM < 2);
16297: END IF;
16298: -- Standard End of Procedure/Function Logging
16299: INL_LOGGING_PVT.Log_EndProc(
16300: p_module_name => g_module_name,
16301: p_procedure_name => l_program_name);
16302:
16302:
16303: RETURN NVL(sql%ROWCOUNT,0);
16304: EXCEPTION
16305: WHEN L_FND_EXC_ERROR THEN
16306: -- Standard Expected Error Logging
16307: INL_LOGGING_PVT.Log_ExpecError (
16308: p_module_name => g_module_name,
16309: p_procedure_name => l_program_name
16310: );
16310: );
16311: x_return_status := L_FND_RET_STS_ERROR;
16312: RETURN 0;
16313: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
16314: -- Standard Unexpected Error Logging
16315: INL_LOGGING_PVT.Log_UnexpecError (
16316: p_module_name => g_module_name,
16317: p_procedure_name => l_program_name
16318: );
16318: );
16319: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
16320: RETURN 0;
16321: WHEN OTHERS THEN
16322: -- Standard Unexpected Error Logging
16323: INL_LOGGING_PVT.Log_UnexpecError (
16324: p_module_name => g_module_name,
16325: p_procedure_name => l_program_name
16326: );
16360: l_response_int BOOLEAN := TRUE;
16361: l_response BOOLEAN := TRUE;
16362: l_ship_header_id NUMBER;
16363: BEGIN
16364: -- Standard Beginning of Procedure/Function Logging
16365: INL_LOGGING_PVT.Log_BeginProc(
16366: p_module_name => g_module_name,
16367: p_procedure_name => l_program_name) ;
16368: -- Initialize API return status to success
16607:
16608: END IF;
16609: END IF;
16610:
16611: -- Standard End of Procedure/Function Logging
16612: INL_LOGGING_PVT.Log_EndProc(
16613: p_module_name => g_module_name,
16614: p_procedure_name => l_program_name);
16615: RETURN l_response;
16614: p_procedure_name => l_program_name);
16615: RETURN l_response;
16616: EXCEPTION
16617: WHEN L_FND_EXC_ERROR THEN
16618: -- Standard Expected Error Logging
16619: INL_LOGGING_PVT.Log_ExpecError (
16620: p_module_name => g_module_name,
16621: p_procedure_name => l_program_name);
16622: RETURN FND_API.to_boolean(L_FND_FALSE) ;
16620: p_module_name => g_module_name,
16621: p_procedure_name => l_program_name);
16622: RETURN FND_API.to_boolean(L_FND_FALSE) ;
16623: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
16624: -- Standard Unexpected Error Logging
16625: INL_LOGGING_PVT.Log_UnexpecError (
16626: p_module_name => g_module_name,
16627: p_procedure_name => l_program_name);
16628: RETURN FND_API.to_boolean(L_FND_FALSE) ;
16626: p_module_name => g_module_name,
16627: p_procedure_name => l_program_name);
16628: RETURN FND_API.to_boolean(L_FND_FALSE) ;
16629: WHEN OTHERS THEN
16630: -- Standard Unexpected Error Logging
16631: INL_LOGGING_PVT.Log_UnexpecError (
16632: p_module_name => g_module_name,
16633: p_procedure_name => l_program_name);
16634: IF FND_MSG_PUB.Check_Msg_Level(
16681: l_response_int BOOLEAN := TRUE;
16682: l_response BOOLEAN := TRUE;
16683:
16684: BEGIN
16685: -- Standard Beginning of Procedure/Function Logging
16686: INL_LOGGING_PVT.Log_BeginProc(
16687: p_module_name => g_module_name,
16688: p_procedure_name => l_program_name) ;
16689: -- Initialize API return status to success
16737: p_procedure_name => l_program_name,
16738: p_var_name => 'l_response_int',
16739: p_var_value => l_debug_info);
16740:
16741: -- Standard End of Procedure/Function Logging
16742: INL_LOGGING_PVT.Log_EndProc(
16743: p_module_name => g_module_name,
16744: p_procedure_name => l_program_name);
16745: RETURN l_response;
16744: p_procedure_name => l_program_name);
16745: RETURN l_response;
16746: EXCEPTION
16747: WHEN L_FND_EXC_ERROR THEN
16748: -- Standard Expected Error Logging
16749: INL_LOGGING_PVT.Log_ExpecError (
16750: p_module_name => g_module_name,
16751: p_procedure_name => l_program_name);
16752: RETURN FND_API.to_boolean(L_FND_FALSE) ;
16750: p_module_name => g_module_name,
16751: p_procedure_name => l_program_name);
16752: RETURN FND_API.to_boolean(L_FND_FALSE) ;
16753: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
16754: -- Standard Unexpected Error Logging
16755: INL_LOGGING_PVT.Log_UnexpecError (
16756: p_module_name => g_module_name,
16757: p_procedure_name => l_program_name);
16758: RETURN FND_API.to_boolean(L_FND_FALSE) ;
16756: p_module_name => g_module_name,
16757: p_procedure_name => l_program_name);
16758: RETURN FND_API.to_boolean(L_FND_FALSE) ;
16759: WHEN OTHERS THEN
16760: -- Standard Unexpected Error Logging
16761: INL_LOGGING_PVT.Log_UnexpecError (
16762: p_module_name => g_module_name,
16763: p_procedure_name => l_program_name);
16764: IF FND_MSG_PUB.Check_Msg_Level(
16848: l_organization_id NUMBER;
16849: l_rule_package_name VARCHAR2(100);
16850: -- Bug #16310024
16851: BEGIN
16852: -- Standard Beginning of Procedure/Function Logging
16853: INL_LOGGING_PVT.Log_BeginProc(
16854: p_module_name => g_module_name,
16855: p_procedure_name => l_program_name) ;
16856: -- Standard Start of API savepoint
16852: -- Standard Beginning of Procedure/Function Logging
16853: INL_LOGGING_PVT.Log_BeginProc(
16854: p_module_name => g_module_name,
16855: p_procedure_name => l_program_name) ;
16856: -- Standard Start of API savepoint
16857: SAVEPOINT Import_LCMShipments_PVT;
16858: -- Initialize message list if p_init_msg_list is set to TRUE.
16859: IF FND_API.to_Boolean(p_init_msg_list) THEN
16860: FND_MSG_PUB.initialize;
16858: -- Initialize message list if p_init_msg_list is set to TRUE.
16859: IF FND_API.to_Boolean(p_init_msg_list) THEN
16860: FND_MSG_PUB.initialize;
16861: END IF;
16862: -- Standard call to check for call compatibility
16863: IF NOT FND_API.Compatible_API_Call(
16864: p_current_version_number => l_api_version,
16865: p_caller_version_number => p_api_version,
16866: p_api_name => l_program_name,
17481: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
17482: RAISE L_FND_EXC_UNEXPECTED_ERROR;
17483: END IF;
17484:
17485: -- Standard check of p_commit.
17486: IF FND_API.To_Boolean(p_commit) THEN
17487: COMMIT WORK;
17488: END IF;
17489: -- Standard call to get message count and if count is 1, get message info.
17485: -- Standard check of p_commit.
17486: IF FND_API.To_Boolean(p_commit) THEN
17487: COMMIT WORK;
17488: END IF;
17489: -- Standard call to get message count and if count is 1, get message info.
17490: FND_MSG_PUB.Count_And_Get(
17491: p_encoded => L_FND_FALSE,
17492: p_count => x_msg_count,
17493: p_data => x_msg_data) ;
17490: FND_MSG_PUB.Count_And_Get(
17491: p_encoded => L_FND_FALSE,
17492: p_count => x_msg_count,
17493: p_data => x_msg_data) ;
17494: -- Standard End of Procedure/Function Logging
17495: INL_LOGGING_PVT.Log_EndProc(
17496: p_module_name => g_module_name,
17497: p_procedure_name => l_program_name);
17498:
17497: p_procedure_name => l_program_name);
17498:
17499: EXCEPTION
17500: WHEN L_FND_EXC_ERROR THEN
17501: -- Standard Expected Error Logging
17502: INL_LOGGING_PVT.Log_ExpecError (
17503: p_module_name => g_module_name,
17504: p_procedure_name => l_program_name);
17505: ROLLBACK TO Import_LCMShipments_PVT;
17518: mo_global.set_policy_context( l_previous_access_mode, l_previous_org_id);
17519: END IF;
17520: --Bug#10381495
17521: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
17522: -- Standard Unexpected Error Logging
17523: INL_LOGGING_PVT.Log_UnexpecError (
17524: p_module_name => g_module_name,
17525: p_procedure_name => l_program_name);
17526: ROLLBACK TO Import_LCMShipments_PVT;
17539: mo_global.set_policy_context( l_previous_access_mode, l_previous_org_id);
17540: END IF;
17541: --Bug#10381495
17542: WHEN OTHERS THEN
17543: -- Standard Unexpected Error Logging
17544: INL_LOGGING_PVT.Log_UnexpecError (
17545: p_module_name => g_module_name,
17546: p_procedure_name => l_program_name);
17547: ROLLBACK TO Import_LCMShipments_PVT;
17605: TYPE matches_int_error IS TABLE OF c_matches_int_error%ROWTYPE;
17606: l_matches_int_error matches_int_error;
17607:
17608: BEGIN
17609: -- Standard Beginning of Procedure/Function Logging
17610: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
17611: p_procedure_name => l_program_name);
17612:
17613: INL_LOGGING_PVT.Log_Variable(p_module_name => g_module_name,
17667: WHERE group_id = l_matches_int_error(i).group_id;
17668: END IF;
17669: END LOOP;
17670: END IF;
17671: -- Standard End of Procedure/Function Logging
17672: INL_LOGGING_PVT.Log_EndProc(
17673: p_module_name => g_module_name,
17674: p_procedure_name => l_program_name);
17675: EXCEPTION
17673: p_module_name => g_module_name,
17674: p_procedure_name => l_program_name);
17675: EXCEPTION
17676: WHEN L_FND_EXC_ERROR THEN
17677: -- Standard Expected Error Logging
17678: INL_LOGGING_PVT.Log_ExpecError (
17679: p_module_name => g_module_name,
17680: p_procedure_name => l_program_name);
17681: x_return_status := L_FND_RET_STS_ERROR;
17679: p_module_name => g_module_name,
17680: p_procedure_name => l_program_name);
17681: x_return_status := L_FND_RET_STS_ERROR;
17682: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
17683: -- Standard Unexpected Error Logging
17684: INL_LOGGING_PVT.Log_UnexpecError (
17685: p_module_name => g_module_name,
17686: p_procedure_name => l_program_name);
17687: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
17685: p_module_name => g_module_name,
17686: p_procedure_name => l_program_name);
17687: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
17688: WHEN OTHERS THEN
17689: -- Standard Unexpected Error Logging
17690: INL_LOGGING_PVT.Log_UnexpecError (
17691: p_module_name => g_module_name,
17692: p_procedure_name => l_program_name);
17693: x_return_status := L_FND_RET_STS_UNEXP_ERROR;