eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INL_INTERFACE_PVT dependencies on FND_API

Line 14: L_FND_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success; --Bug#9660043

10:
11: L_FND_EXC_ERROR EXCEPTION; --Bug#9660043
12: L_FND_EXC_UNEXPECTED_ERROR EXCEPTION; --Bug#9660043
13:
14: L_FND_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success; --Bug#9660043
15: L_FND_RET_STS_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error; --Bug#9660043
16: L_FND_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;--Bug#9660043
17:
18: CURSOR c_ship_hdr_int

Line 15: L_FND_RET_STS_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error; --Bug#9660043

11: L_FND_EXC_ERROR EXCEPTION; --Bug#9660043
12: L_FND_EXC_UNEXPECTED_ERROR EXCEPTION; --Bug#9660043
13:
14: L_FND_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success; --Bug#9660043
15: L_FND_RET_STS_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error; --Bug#9660043
16: L_FND_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;--Bug#9660043
17:
18: CURSOR c_ship_hdr_int
19: IS

Line 16: L_FND_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;--Bug#9660043

12: L_FND_EXC_UNEXPECTED_ERROR EXCEPTION; --Bug#9660043
13:
14: L_FND_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_success; --Bug#9660043
15: L_FND_RET_STS_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_error; --Bug#9660043
16: L_FND_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;--Bug#9660043
17:
18: CURSOR c_ship_hdr_int
19: IS
20: SELECT

Line 1027: RETURN FND_API.to_boolean(l_result) ;

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) ;
1028:
1029: EXCEPTION
1030: WHEN L_FND_EXC_ERROR THEN
1031: -- Standard Expected Error Logging

Line 1035: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 1041: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
1042: WHEN OTHERS THEN
1043: -- Standard Unexpected Error Logging
1044: INL_LOGGING_PVT.Log_UnexpecError (
1045: p_module_name => g_module_name,

Line 1054: RETURN FND_API.to_boolean(L_FND_FALSE) ;

1050: FND_MSG_PUB.Add_Exc_Msg(
1051: p_pkg_name => g_pkg_name,
1052: p_procedure_name => l_program_name);
1053: END IF;
1054: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1055: END Validate_ShipNum;
1056:
1057: -- Utility name : Validate_ShipType
1058: -- Type : Private

Line 1253: RETURN FND_API.to_boolean(l_result) ;

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) ;
1254: EXCEPTION
1255: WHEN L_FND_EXC_ERROR THEN
1256: -- Standard Expected Error Logging
1257: INL_LOGGING_PVT.Log_ExpecError (

Line 1260: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 1266: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
1267: WHEN OTHERS THEN
1268: -- Add a line into inl_ship_errors
1269: Handle_InterfError(
1270: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

Line 1283: RETURN FND_API.to_boolean(L_FND_FALSE) ;

1279: RAISE L_FND_EXC_ERROR;
1280: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
1281: RAISE L_FND_EXC_UNEXPECTED_ERROR;
1282: END IF;
1283: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1284: END Validate_ShipType;
1285:
1286: -- Utility name : Validate_Party
1287: -- Type : Private

Line 1493: RETURN FND_API.to_boolean(l_response) ;

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) ;
1494: EXCEPTION
1495: WHEN L_FND_EXC_ERROR THEN
1496: -- Standard Expected Error Logging
1497: INL_LOGGING_PVT.Log_ExpecError (

Line 1500: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 1506: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
1507: WHEN OTHERS THEN
1508: -- Add a line into inl_ship_errors
1509: Handle_InterfError(
1510: p_parent_table_name => 'INL_SHIP_LINES_INT',

Line 1523: RETURN FND_API.to_boolean(L_FND_FALSE) ;

1519: RAISE L_FND_EXC_ERROR;
1520: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
1521: RAISE L_FND_EXC_UNEXPECTED_ERROR;
1522: END IF;
1523: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1524: END Validate_Party;
1525:
1526: -- Utility name : Validate_PartySite
1527: -- Type : Private

Line 1775: RETURN FND_API.to_boolean(l_response) ;

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) ;
1776: EXCEPTION
1777: WHEN L_FND_EXC_ERROR THEN
1778: -- Standard Expected Error Logging
1779: INL_LOGGING_PVT.Log_ExpecError (

Line 1782: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 1788: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
1789: WHEN OTHERS THEN
1790: -- Add a line into inl_ship_errors
1791: Handle_InterfError(
1792: p_parent_table_name => 'INL_SHIP_LINES_INT',

Line 1805: RETURN FND_API.to_boolean(L_FND_FALSE);

1801: RAISE L_FND_EXC_ERROR;
1802: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
1803: RAISE L_FND_EXC_UNEXPECTED_ERROR;
1804: END IF;
1805: RETURN FND_API.to_boolean(L_FND_FALSE);
1806: END Validate_PartySite;
1807:
1808: -- Utility name : Validate_SrcOrganization
1809: -- Type : Private

Line 1928: RETURN FND_API.to_boolean(l_result) ;

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) ;
1929: EXCEPTION
1930: WHEN L_FND_EXC_ERROR THEN
1931: -- Standard Expected Error Logging
1932: INL_LOGGING_PVT.Log_ExpecError (

Line 1935: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 1941: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
1942: WHEN OTHERS THEN
1943: -- Add a line into inl_ship_errors
1944: Handle_InterfError(
1945: p_parent_table_name => 'INL_SHIP_LINES_INT',

Line 1957: RETURN FND_API.to_boolean(L_FND_FALSE) ;

1953: RAISE L_FND_EXC_ERROR;
1954: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
1955: RAISE L_FND_EXC_UNEXPECTED_ERROR;
1956: END IF;
1957: RETURN FND_API.to_boolean(L_FND_FALSE) ;
1958: END Validate_SrcOrganization;
1959:
1960: -- Utility name : Validate_ShipLineGrpNum
1961: -- Type : Private

Line 2193: RETURN FND_API.to_boolean(l_result) ;

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) ;
2194: EXCEPTION
2195: WHEN L_FND_EXC_ERROR THEN
2196: -- Standard Expected Error Logging
2197: INL_LOGGING_PVT.Log_ExpecError (

Line 2200: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 2206: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
2207: WHEN OTHERS THEN
2208: -- Standard Unexpected Error Logging
2209: INL_LOGGING_PVT.Log_UnexpecError (
2210: p_module_name => g_module_name,

Line 2219: RETURN FND_API.to_boolean(L_FND_FALSE) ;

2215: FND_MSG_PUB.Add_Exc_Msg(
2216: p_pkg_name => g_pkg_name,
2217: p_procedure_name => l_program_name);
2218: END IF;
2219: RETURN FND_API.to_boolean(L_FND_FALSE) ;
2220: END Validate_ShipLineGrpNum;
2221:
2222: -- Utility name : Validate_ShipLineNum
2223: -- Type : Private

Line 2375: RETURN FND_API.to_boolean(l_response) ;

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) ;
2376: EXCEPTION
2377: WHEN L_FND_EXC_ERROR THEN
2378: -- Standard Expected Error Logging
2379: INL_LOGGING_PVT.Log_ExpecError (

Line 2382: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 2388: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
2389: WHEN OTHERS THEN
2390: -- Add a line into inl_ship_errors
2391: Handle_InterfError(
2392: p_parent_table_name => 'INL_SHIP_LINES_INT',

Line 2404: RETURN FND_API.to_boolean(L_FND_FALSE) ;

2400: RAISE L_FND_EXC_ERROR;
2401: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
2402: RAISE L_FND_EXC_UNEXPECTED_ERROR;
2403: END IF;
2404: RETURN FND_API.to_boolean(L_FND_FALSE) ;
2405: END Validate_ShipLineNum;
2406:
2407: -- Utility name : Validate_ShipLineType
2408: -- Type : Private

Line 2624: RETURN FND_API.to_boolean(l_result);

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);
2625: EXCEPTION
2626: WHEN L_FND_EXC_ERROR THEN
2627: -- Standard Expected Error Logging
2628: INL_LOGGING_PVT.Log_ExpecError (

Line 2631: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 2637: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
2638: WHEN OTHERS THEN
2639: -- Add a line into inl_ship_errors
2640: Handle_InterfError(
2641: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

Line 2654: RETURN FND_API.to_boolean(L_FND_FALSE) ;

2650: RAISE L_FND_EXC_ERROR;
2651: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
2652: RAISE L_FND_EXC_UNEXPECTED_ERROR;
2653: END IF;
2654: RETURN FND_API.to_boolean(L_FND_FALSE) ;
2655: END Validate_ShipLineType;
2656:
2657: -- Utility name : Validate_ShipLnSrcTypeCode
2658: -- Type : Private

Line 2739: RETURN FND_API.to_boolean(l_result) ;

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) ;
2740: EXCEPTION
2741: WHEN L_FND_EXC_ERROR THEN
2742: -- Standard Expected Error Logging
2743: INL_LOGGING_PVT.Log_ExpecError (

Line 2746: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 2752: RETURN FND_API.to_boolean(L_FND_FALSE);

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);
2753: WHEN OTHERS THEN
2754: -- Standard Unexpected Error Logging
2755: INL_LOGGING_PVT.Log_UnexpecError (
2756: p_module_name => g_module_name,

Line 3121: RETURN FND_API.to_boolean(l_response) ;

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) ;
3122: EXCEPTION
3123: WHEN L_FND_EXC_ERROR THEN
3124: -- Standard Expected Error Logging
3125: INL_LOGGING_PVT.Log_ExpecError (

Line 3128: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 3134: RETURN FND_API.to_boolean(L_FND_FALSE);

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);
3135: WHEN OTHERS THEN
3136: -- Standard Unexpected Error Logging
3137: INL_LOGGING_PVT.Log_UnexpecError (
3138: p_module_name => g_module_name,

Line 3258: RETURN FND_API.to_boolean(L_FND_TRUE) ;

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) ;
3259: EXCEPTION
3260: WHEN L_FND_EXC_ERROR THEN
3261: -- Standard Expected Error Logging
3262: INL_LOGGING_PVT.Log_ExpecError (

Line 3265: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 3271: RETURN FND_API.to_boolean(L_FND_FALSE);

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);
3272: WHEN OTHERS THEN
3273: -- Add a line into inl_ship_errors
3274: Handle_InterfError(
3275: p_parent_table_name => 'INL_SHIP_LINES_INT',

Line 3288: RETURN FND_API.to_boolean(L_FND_FALSE);

3284: RAISE L_FND_EXC_ERROR;
3285: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
3286: RAISE L_FND_EXC_UNEXPECTED_ERROR;
3287: END IF;
3288: RETURN FND_API.to_boolean(L_FND_FALSE);
3289: END Validate_InvItemId;
3290:
3291: -- Utility name : Validate_TxnUomCode
3292: -- Type : Private

Line 3374: RETURN FND_API.to_boolean(l_result) ;

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) ;
3375: EXCEPTION
3376: WHEN L_FND_EXC_ERROR THEN
3377: -- Standard Expected Error Logging
3378: INL_LOGGING_PVT.Log_ExpecError (

Line 3381: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 3387: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
3388: WHEN OTHERS THEN
3389: -- Standard Unexpected Error Logging
3390: INL_LOGGING_PVT.Log_UnexpecError (
3391: p_module_name => g_module_name,

Line 3400: RETURN FND_API.to_boolean(L_FND_FALSE) ;

3396: FND_MSG_PUB.Add_Exc_Msg(
3397: p_pkg_name => g_pkg_name,
3398: p_procedure_name => l_program_name);
3399: END IF;
3400: RETURN FND_API.to_boolean(L_FND_FALSE) ;
3401: END Validate_TxnUomCode;
3402:
3403: -- Utility name : Validate_PriSecFields
3404: -- Type : Private

Line 3902: RETURN FND_API.to_boolean(l_result) ;

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) ;
3903: EXCEPTION
3904: WHEN L_FND_EXC_ERROR THEN
3905: -- Standard Expected Error Logging
3906: x_return_status := L_FND_RET_STS_ERROR;

Line 3910: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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);
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 (

Line 3917: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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 (

Line 3931: RETURN FND_API.to_boolean(L_FND_FALSE) ;

3927: FND_MSG_PUB.Add_Exc_Msg(
3928: p_pkg_name => g_pkg_name,
3929: p_procedure_name => l_program_name);
3930: END IF;
3931: RETURN FND_API.to_boolean(L_FND_FALSE) ;
3932: END Validate_PriSecFields;
3933:
3934: -- Utility name : Validate_LandedCostFlag
3935: -- Type : Private

Line 4012: RETURN FND_API.to_boolean(l_result) ;

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) ;
4013: EXCEPTION
4014: WHEN L_FND_EXC_ERROR THEN
4015: -- Standard Expected Error Logging
4016: INL_LOGGING_PVT.Log_ExpecError (

Line 4019: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 4025: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
4026: WHEN OTHERS THEN
4027: -- Standard Unexpected Error Logging
4028: INL_LOGGING_PVT.Log_UnexpecError (
4029: p_module_name => g_module_name,

Line 4038: RETURN FND_API.to_boolean(L_FND_FALSE) ;

4034: FND_MSG_PUB.Add_Exc_Msg(
4035: p_pkg_name => g_pkg_name,
4036: p_procedure_name => l_program_name);
4037: END IF;
4038: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4039: END Validate_LandedCostFlag;
4040:
4041: -- Utility name : Validate_AllocEnabledFlag
4042: -- Type : Private

Line 4116: RETURN FND_API.to_boolean(l_result) ;

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) ;
4117: EXCEPTION
4118: WHEN L_FND_EXC_ERROR THEN
4119: -- Standard Expected Error Logging
4120: INL_LOGGING_PVT.Log_ExpecError (

Line 4123: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 4129: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
4130: WHEN OTHERS THEN
4131: -- Standard Unexpected Error Logging
4132: INL_LOGGING_PVT.Log_UnexpecError (
4133: p_module_name => g_module_name,

Line 4142: RETURN FND_API.to_boolean(L_FND_FALSE) ;

4138: FND_MSG_PUB.Add_Exc_Msg(
4139: p_pkg_name => g_pkg_name,
4140: p_procedure_name => l_program_name);
4141: END IF;
4142: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4143: END Validate_AllocEnabledFlag;
4144:
4145: -- Utility name : Validate_Organization
4146: -- Type : Private

Line 4434: RETURN FND_API.to_boolean(l_result) ;

4430: INL_LOGGING_PVT.Log_EndProc(
4431: p_module_name => g_module_name,
4432: p_procedure_name => l_program_name);
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 (

Line 4441: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 4447: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
4448: WHEN OTHERS THEN
4449: -- Add a line into inl_ship_errors
4450: Handle_InterfError(
4451: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

Line 4463: RETURN FND_API.to_boolean(L_FND_FALSE) ;

4459: RAISE L_FND_EXC_ERROR;
4460: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
4461: RAISE L_FND_EXC_UNEXPECTED_ERROR;
4462: END IF;
4463: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4464: END Validate_Organization;
4465:
4466: -- Utility name : Validate_Location
4467: -- Type : Private

Line 4711: RETURN FND_API.to_boolean(l_result) ;

4707: INL_LOGGING_PVT.Log_EndProc(
4708: p_module_name => g_module_name,
4709: p_procedure_name => l_program_name);
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 (

Line 4718: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 4724: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
4725: WHEN OTHERS THEN
4726: -- Add a line into inl_ship_errors
4727: Handle_InterfError(
4728: p_parent_table_name => 'INL_SHIP_HEADERS_INT',

Line 4741: RETURN FND_API.to_boolean(L_FND_FALSE) ;

4737: RAISE L_FND_EXC_ERROR;
4738: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
4739: RAISE L_FND_EXC_UNEXPECTED_ERROR;
4740: END IF;
4741: RETURN FND_API.to_boolean(L_FND_FALSE) ;
4742: END Validate_Location;
4743:
4744: -- Utility name : Validate_LnCreateTrxType
4745: -- Type : Private

Line 5962: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 5968: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
5969: WHEN OTHERS THEN
5970: -- Standard Unexpected Error Logging
5971: INL_LOGGING_PVT.Log_UnexpecError (
5972: p_module_name => g_module_name,

Line 5981: RETURN FND_API.to_boolean(L_FND_FALSE) ;

5977: FND_MSG_PUB.Add_Exc_Msg(
5978: p_pkg_name => g_pkg_name,
5979: p_procedure_name => l_program_name);
5980: END IF;
5981: RETURN FND_API.to_boolean(L_FND_FALSE) ;
5982:
5983: END Validate_LnCreateTrxType;
5984:
5985: -- Utility name : Validate_RcvEnabledFlag

Line 6101: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 6107: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
6108: WHEN OTHERS THEN
6109: -- Standard Unexpected Error Logging
6110: INL_LOGGING_PVT.Log_UnexpecError (
6111: p_module_name => g_module_name,

Line 6120: RETURN FND_API.to_boolean(L_FND_FALSE) ;

6116: FND_MSG_PUB.Add_Exc_Msg(
6117: p_pkg_name => g_pkg_name,
6118: p_procedure_name => l_program_name);
6119: END IF;
6120: RETURN FND_API.to_boolean(L_FND_FALSE) ;
6121: END Validate_RcvEnabledFlag;
6122:
6123: -- Utility name : Validate_HdrCreateTrxType
6124: -- Type : Private

Line 6443: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 6449: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
6450: WHEN OTHERS THEN
6451: -- Standard Unexpected Error Logging
6452: INL_LOGGING_PVT.Log_UnexpecError (
6453: p_module_name => g_module_name,

Line 6462: RETURN FND_API.to_boolean(L_FND_FALSE) ;

6458: FND_MSG_PUB.Add_Exc_Msg(
6459: p_pkg_name => g_pkg_name,
6460: p_procedure_name => l_program_name);
6461: END IF;
6462: RETURN FND_API.to_boolean(L_FND_FALSE) ;
6463:
6464: END Validate_HdrCreateTrxType;
6465:
6466: -- Utility name : Validate_HdrUpdateTrxType

Line 6810: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 6816: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
6817: WHEN OTHERS THEN
6818: -- Standard Unexpected Error Logging
6819: INL_LOGGING_PVT.Log_UnexpecError (
6820: p_module_name => g_module_name,

Line 6829: RETURN FND_API.to_boolean(L_FND_FALSE) ;

6825: FND_MSG_PUB.Add_Exc_Msg(
6826: p_pkg_name => g_pkg_name,
6827: p_procedure_name => l_program_name);
6828: END IF;
6829: RETURN FND_API.to_boolean(L_FND_FALSE) ;
6830: END Validate_HdrUpdateTrxType;
6831:
6832: -- Utility name : Validate_LnUpdateTrxType
6833: -- Type : Private

Line 7627: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 7633: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
7634: WHEN OTHERS THEN
7635: -- Standard Unexpected Error Logging
7636: INL_LOGGING_PVT.Log_UnexpecError (
7637: p_module_name => g_module_name,

Line 7646: RETURN FND_API.to_boolean(L_FND_FALSE) ;

7642: FND_MSG_PUB.Add_Exc_Msg(
7643: p_pkg_name => g_pkg_name,
7644: p_procedure_name => l_program_name);
7645: END IF;
7646: RETURN FND_API.to_boolean(L_FND_FALSE) ;
7647: END Validate_LnUpdateTrxType;
7648:
7649: -- Utility name : Validate_AllProcessingStatus
7650: -- Type : Private

Line 7744: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 7750: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
7751: WHEN OTHERS THEN
7752: -- Standard Unexpected Error Logging
7753: INL_LOGGING_PVT.Log_UnexpecError (
7754: p_module_name => g_module_name,

Line 7763: RETURN FND_API.to_boolean(L_FND_FALSE) ;

7759: FND_MSG_PUB.Add_Exc_Msg(
7760: p_pkg_name => g_pkg_name,
7761: p_procedure_name => l_program_name);
7762: END IF;
7763: RETURN FND_API.to_boolean(L_FND_FALSE) ;
7764: END Validate_AllProcessingStatus;
7765:
7766: -- Utility name : Validate_AllShipLnSrcTypeCode
7767: -- Type : Private

Line 7858: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 7864: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
7865: WHEN OTHERS THEN
7866: -- Standard Unexpected Error Logging
7867: INL_LOGGING_PVT.Log_UnexpecError (
7868: p_module_name => g_module_name,

Line 7877: RETURN FND_API.to_boolean(L_FND_FALSE) ;

7873: FND_MSG_PUB.Add_Exc_Msg(
7874: p_pkg_name => g_pkg_name,
7875: p_procedure_name => l_program_name);
7876: END IF;
7877: RETURN FND_API.to_boolean(L_FND_FALSE) ;
7878: END Validate_AllShipLnSrcTypeCode;
7879:
7880:
7881: -- Utility name : Validate_HdrTrxType

Line 8074: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 8080: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
8081: WHEN OTHERS THEN
8082: -- Standard Unexpected Error Logging
8083: INL_LOGGING_PVT.Log_UnexpecError (
8084: p_module_name => g_module_name,

Line 8093: RETURN FND_API.to_boolean(L_FND_FALSE) ;

8089: FND_MSG_PUB.Add_Exc_Msg(
8090: p_pkg_name => g_pkg_name,
8091: p_procedure_name => l_program_name);
8092: END IF;
8093: RETURN FND_API.to_boolean(L_FND_FALSE) ;
8094: END Validate_HdrTrxType;
8095:
8096: -- Utility name : Delete_Ship
8097: -- Type : Private

Line 11338: RETURN FND_API.to_boolean(l_result) ;

11334: INL_LOGGING_PVT.Log_EndProc(
11335: p_module_name => g_module_name,
11336: p_procedure_name => l_program_name
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 (

Line 11346: RETURN FND_API.to_boolean(L_FND_FALSE) ;

11342: INL_LOGGING_PVT.Log_ExpecError (
11343: p_module_name => g_module_name,
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,

Line 11353: RETURN FND_API.to_boolean(L_FND_FALSE) ;

11349: INL_LOGGING_PVT.Log_UnexpecError (
11350: p_module_name => g_module_name,
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,

Line 11368: RETURN FND_API.to_boolean(L_FND_FALSE) ;

11364: p_pkg_name => g_pkg_name,
11365: p_procedure_name => l_program_name
11366: );
11367: END IF;
11368: RETURN FND_API.to_boolean(L_FND_FALSE) ;
11369: END Validate_MatchChLnTpID;
11370: -- Funct name : Validate_MatchFlags
11371: -- Type : Private
11372: -- Function : Validate Matching Flags

Line 11437: RETURN FND_API.to_boolean(l_result) ;

11433: INL_LOGGING_PVT.Log_EndProc(
11434: p_module_name => g_module_name,
11435: p_procedure_name => l_program_name
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 (

Line 11445: RETURN FND_API.to_boolean(L_FND_FALSE) ;

11441: INL_LOGGING_PVT.Log_ExpecError (
11442: p_module_name => g_module_name,
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,

Line 11452: RETURN FND_API.to_boolean(L_FND_FALSE) ;

11448: INL_LOGGING_PVT.Log_UnexpecError (
11449: p_module_name => g_module_name,
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,

Line 11467: RETURN FND_API.to_boolean(L_FND_FALSE) ;

11463: p_pkg_name => g_pkg_name,
11464: p_procedure_name => l_program_name
11465: );
11466: END IF;
11467: RETURN FND_API.to_boolean(L_FND_FALSE) ;
11468: END Validate_MatchFlags;
11469: -- Funct name : Validate_MatchQty
11470: -- Type : Private
11471: -- Function : Validate a given Match Quantity

Line 11935: RETURN FND_API.to_boolean(l_result) ;

11931: INL_LOGGING_PVT.Log_EndProc(
11932: p_module_name => g_module_name,
11933: p_procedure_name => l_program_name
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 (

Line 11943: RETURN FND_API.to_boolean(L_FND_FALSE) ;

11939: INL_LOGGING_PVT.Log_ExpecError (
11940: p_module_name => g_module_name,
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,

Line 11950: RETURN FND_API.to_boolean(L_FND_FALSE) ;

11946: INL_LOGGING_PVT.Log_UnexpecError (
11947: p_module_name => g_module_name,
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,

Line 11965: RETURN FND_API.to_boolean(L_FND_FALSE) ;

11961: p_pkg_name => g_pkg_name,
11962: p_procedure_name => l_program_name
11963: );
11964: END IF;
11965: RETURN FND_API.to_boolean(L_FND_FALSE) ;
11966: END Validate_MatchQty;
11967: -- Funct name : Validate_MatchTax
11968: -- Type : Private
11969: -- Function : Validate a given Match Tax

Line 12110: RETURN FND_API.to_boolean(l_result) ;

12106: INL_LOGGING_PVT.Log_EndProc(
12107: p_module_name => g_module_name,
12108: p_procedure_name => l_program_name
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 (

Line 12118: RETURN FND_API.to_boolean(L_FND_FALSE) ;

12114: INL_LOGGING_PVT.Log_ExpecError (
12115: p_module_name => g_module_name,
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,

Line 12125: RETURN FND_API.to_boolean(L_FND_FALSE) ;

12121: INL_LOGGING_PVT.Log_UnexpecError (
12122: p_module_name => g_module_name,
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,

Line 12140: RETURN FND_API.to_boolean(L_FND_FALSE) ;

12136: p_pkg_name => g_pkg_name,
12137: p_procedure_name => l_program_name
12138: );
12139: END IF;
12140: RETURN FND_API.to_boolean(L_FND_FALSE) ;
12141: END Validate_MatchTax;
12142: -- Funct name : Validate_MatchAmt
12143: -- Type : Private
12144: -- Function : Validate a given Match Amount

Line 12249: RETURN FND_API.to_boolean(l_result) ;

12245: INL_LOGGING_PVT.Log_EndProc(
12246: p_module_name => g_module_name,
12247: p_procedure_name => l_program_name
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 (

Line 12257: RETURN FND_API.to_boolean(L_FND_FALSE) ;

12253: INL_LOGGING_PVT.Log_ExpecError (
12254: p_module_name => g_module_name,
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,

Line 12264: RETURN FND_API.to_boolean(L_FND_FALSE) ;

12260: INL_LOGGING_PVT.Log_UnexpecError (
12261: p_module_name => g_module_name,
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,

Line 12279: RETURN FND_API.to_boolean(L_FND_FALSE) ;

12275: p_pkg_name => g_pkg_name,
12276: p_procedure_name => l_program_name
12277: );
12278: END IF;
12279: RETURN FND_API.to_boolean(L_FND_FALSE) ;
12280: END Validate_MatchAmt;
12281: --/ SCM-051 Begin
12282: -- Funct name : Validate_MatchElcOnGoing
12283: -- Type : Private

Line 12652: RETURN FND_API.to_boolean(l_result) ;

12648: INL_LOGGING_PVT.Log_EndProc(
12649: p_module_name => g_module_name,
12650: p_procedure_name => l_program_name
12651: );
12652: RETURN FND_API.to_boolean(l_result) ;
12653: EXCEPTION
12654: --Handling deadlock with proper error message
12655: WHEN RESOURCE_BUSY THEN
12656:

Line 12662: x_return_status := FND_API.g_ret_sts_error;

12658: INTO l_group_id
12659: FROM inl_matches_int m
12660: WHERE m.match_int_id = p_match_int_id;
12661:
12662: x_return_status := FND_API.g_ret_sts_error;
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:

Line 12671: RETURN FND_API.to_boolean(L_FND_FALSE);

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);
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,

Line 12678: RETURN FND_API.to_boolean(L_FND_FALSE) ;

12674: INL_LOGGING_PVT.Log_ExpecError (
12675: p_module_name => g_module_name,
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,

Line 12685: RETURN FND_API.to_boolean(L_FND_FALSE) ;

12681: INL_LOGGING_PVT.Log_UnexpecError (
12682: p_module_name => g_module_name,
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,

Line 12700: RETURN FND_API.to_boolean(L_FND_FALSE) ;

12696: p_pkg_name => g_pkg_name,
12697: p_procedure_name => l_program_name
12698: );
12699: END IF;
12700: RETURN FND_API.to_boolean(L_FND_FALSE) ;
12701: END Validate_MatchElcOnGoing;
12702: --/ SCM-051 End
12703:
12704: -- Funct name : Validate_MatchUOM

Line 12820: RETURN FND_API.to_boolean(l_result) ;

12816: INL_LOGGING_PVT.Log_EndProc(
12817: p_module_name => g_module_name,
12818: p_procedure_name => l_program_name
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 (

Line 12828: RETURN FND_API.to_boolean(L_FND_FALSE) ;

12824: INL_LOGGING_PVT.Log_ExpecError (
12825: p_module_name => g_module_name,
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,

Line 12835: RETURN FND_API.to_boolean(L_FND_FALSE) ;

12831: INL_LOGGING_PVT.Log_UnexpecError (
12832: p_module_name => g_module_name,
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,

Line 12850: RETURN FND_API.to_boolean(L_FND_FALSE) ;

12846: p_pkg_name => g_pkg_name,
12847: p_procedure_name => l_program_name
12848: );
12849: END IF;
12850: RETURN FND_API.to_boolean(L_FND_FALSE) ;
12851: END Validate_MatchUOM;
12852: -- Funct name : Validate_MatchMatIDS
12853: -- Type : Private
12854: -- Function : Validate Match Id and Parent Match Id

Line 13054: RETURN FND_API.to_boolean(l_result) ;

13050: INL_LOGGING_PVT.Log_EndProc(
13051: p_module_name => g_module_name,
13052: p_procedure_name => l_program_name
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 (

Line 13062: RETURN FND_API.to_boolean(L_FND_FALSE) ;

13058: INL_LOGGING_PVT.Log_ExpecError (
13059: p_module_name => g_module_name,
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,

Line 13069: RETURN FND_API.to_boolean(L_FND_FALSE) ;

13065: INL_LOGGING_PVT.Log_UnexpecError (
13066: p_module_name => g_module_name,
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,

Line 13084: RETURN FND_API.to_boolean(L_FND_FALSE) ;

13080: p_pkg_name => g_pkg_name,
13081: p_procedure_name => l_program_name
13082: );
13083: END IF;
13084: RETURN FND_API.to_boolean(L_FND_FALSE) ;
13085: END Validate_MatchMatIDS;
13086: -- Funct name : Validate_MatchToParTab
13087: -- Type : Private
13088: -- Function : Validate Match To_Parent values

Line 13483: RETURN FND_API.to_boolean(l_result) ;

13479: INL_LOGGING_PVT.Log_EndProc(
13480: p_module_name => g_module_name,
13481: p_procedure_name => l_program_name
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 (

Line 13491: RETURN FND_API.to_boolean(L_FND_FALSE) ;

13487: INL_LOGGING_PVT.Log_ExpecError (
13488: p_module_name => g_module_name,
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,

Line 13498: RETURN FND_API.to_boolean(L_FND_FALSE) ;

13494: INL_LOGGING_PVT.Log_UnexpecError (
13495: p_module_name => g_module_name,
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,

Line 13513: RETURN FND_API.to_boolean(L_FND_FALSE) ;

13509: p_pkg_name => g_pkg_name,
13510: p_procedure_name => l_program_name
13511: );
13512: END IF;
13513: RETURN FND_API.to_boolean(L_FND_FALSE) ;
13514: END Validate_MatchToParTab;
13515: -- Funct name : Validate_MatchTrxType
13516: -- Type : Private
13517: -- Function : Validate Match Transaction Type

Line 13764: RETURN FND_API.to_boolean(l_result) ;

13760: INL_LOGGING_PVT.Log_EndProc(
13761: p_module_name => g_module_name,
13762: p_procedure_name => l_program_name
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 (

Line 13772: RETURN FND_API.to_boolean(L_FND_FALSE) ;

13768: INL_LOGGING_PVT.Log_ExpecError (
13769: p_module_name => g_module_name,
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,

Line 13779: RETURN FND_API.to_boolean(L_FND_FALSE) ;

13775: INL_LOGGING_PVT.Log_UnexpecError (
13776: p_module_name => g_module_name,
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,

Line 13794: RETURN FND_API.to_boolean(L_FND_FALSE) ;

13790: p_pkg_name => g_pkg_name,
13791: p_procedure_name => l_program_name
13792: );
13793: END IF;
13794: RETURN FND_API.to_boolean(L_FND_FALSE) ;
13795: END Validate_MatchTrxType;
13796: -- Funct Name : Validate_MatchParty
13797: -- Type : Private
13798: -- Function : Validate Match Party and Party Site

Line 13984: RETURN FND_API.to_boolean(l_result) ;

13980: INL_LOGGING_PVT.Log_EndProc(
13981: p_module_name => g_module_name,
13982: p_procedure_name => l_program_name
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 (

Line 13992: RETURN FND_API.to_boolean(L_FND_FALSE) ;

13988: INL_LOGGING_PVT.Log_ExpecError (
13989: p_module_name => g_module_name,
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,

Line 13999: RETURN FND_API.to_boolean(L_FND_FALSE) ;

13995: INL_LOGGING_PVT.Log_UnexpecError (
13996: p_module_name => g_module_name,
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,

Line 14014: RETURN FND_API.to_boolean(L_FND_FALSE) ;

14010: p_pkg_name => g_pkg_name,
14011: p_procedure_name => l_program_name
14012: );
14013: END IF;
14014: RETURN FND_API.to_boolean(L_FND_FALSE) ;
14015: END Validate_MatchParty;
14016:
14017: -- Utility name : Validate_MatchInt
14018: -- Type : Private

Line 14483: RETURN FND_API.to_boolean(x_result) ;

14479: INL_LOGGING_PVT.Log_EndProc(
14480: p_module_name => g_module_name,
14481: p_procedure_name => l_program_name
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 (

Line 14491: RETURN FND_API.to_boolean(L_FND_FALSE) ;

14487: INL_LOGGING_PVT.Log_ExpecError (
14488: p_module_name => g_module_name,
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,

Line 14498: RETURN FND_API.to_boolean(L_FND_FALSE) ;

14494: INL_LOGGING_PVT.Log_UnexpecError (
14495: p_module_name => g_module_name,
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,

Line 14513: RETURN FND_API.to_boolean(L_FND_FALSE) ;

14509: p_pkg_name => g_pkg_name,
14510: p_procedure_name => l_program_name
14511: );
14512: END IF;
14513: RETURN FND_API.to_boolean(L_FND_FALSE) ;
14514: END Validate_MatchInt;
14515:
14516: -- Utility name : Select_MatchesToProc --Bug#11794442
14517: -- Type : Private

Line 14587: RAISE FND_API.G_EXC_ERROR;

14583: p_module_name => g_module_name,
14584: p_procedure_name => l_program_name,
14585: p_debug_info => 'Failled to get the lock '||l_lock_name||' status: '||l_lock_status);
14586:
14587: RAISE FND_API.G_EXC_ERROR;
14588: END IF;
14589:
14590: UPDATE inl_matches_int m
14591: SET m.request_id = l_fnd_conc_request_id_int

Line 14717: IF FND_API.To_Boolean(p_commit) THEN

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:
14721: -- Release the lock

Line 15147: IF FND_API.To_Boolean(p_commit) THEN

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:
15151: ELSE

Line 15323: IF FND_API.to_Boolean(p_init_msg_list) THEN

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
15324: FND_MSG_PUB.initialize;
15325: END IF;
15326:
15327: -- Standard call to check for call compatibility

Line 15328: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

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)
15332: THEN

Line 15373: IF FND_API.To_Boolean(p_commit) THEN

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:
15377: -- Standard call to get message count and if count is 1, get message info.

Line 15469: IF FND_API.to_Boolean(p_init_msg_list) THEN

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
15470: FND_MSG_PUB.initialize;
15471: END IF;
15472:
15473: -- Standard call to check for call compatibility

Line 15474: IF NOT FND_API.Compatible_API_Call(p_current_version_number => l_api_version,

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)
15478: THEN

Line 15501: IF FND_API.To_Boolean(p_commit) THEN

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:
15505: -- Standard call to get message count and if count is 1, get message info.

Line 15603: IF FND_API.To_Boolean(p_commit) 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:
15607: -- Bug #8264437

Line 15925: IF FND_API.to_Boolean(p_init_msg_list) THEN

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;
15927: END IF;
15928: -- Standard call to check for call compatibility
15929: IF NOT FND_API.Compatible_API_Call(

Line 15929: IF NOT FND_API.Compatible_API_Call(

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,
15933: p_pkg_name => g_pkg_name)

Line 15975: IF FND_API.To_Boolean(p_commit) THEN

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.
15979: FND_MSG_PUB.Count_And_Get(

Line 16112: RAISE FND_API.G_EXC_ERROR;

16108: p_module_name => g_module_name,
16109: p_procedure_name => l_program_name,
16110: p_debug_info => 'Failled to get the lock '||l_lock_name||' status: '||l_lock_status);
16111:
16112: RAISE FND_API.G_EXC_ERROR;
16113: END IF;
16114:
16115: UPDATE inl_ship_headers_int
16116: SET request_id = l_fnd_conc_request_id_int

Line 16622: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 16628: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
16629: WHEN OTHERS THEN
16630: -- Standard Unexpected Error Logging
16631: INL_LOGGING_PVT.Log_UnexpecError (
16632: p_module_name => g_module_name,

Line 16641: RETURN FND_API.to_boolean(L_FND_FALSE) ;

16637: FND_MSG_PUB.Add_Exc_Msg(
16638: p_pkg_name => g_pkg_name,
16639: p_procedure_name => l_program_name);
16640: END IF;
16641: RETURN FND_API.to_boolean(L_FND_FALSE) ;
16642: END Validate_shipHdrInt;
16643:
16644: -- Utility name : Validate_shipLinInt
16645: -- Type : Private

Line 16752: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
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,

Line 16758: RETURN FND_API.to_boolean(L_FND_FALSE) ;

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) ;
16759: WHEN OTHERS THEN
16760: -- Standard Unexpected Error Logging
16761: INL_LOGGING_PVT.Log_UnexpecError (
16762: p_module_name => g_module_name,

Line 16771: RETURN FND_API.to_boolean(L_FND_FALSE) ;

16767: FND_MSG_PUB.Add_Exc_Msg(
16768: p_pkg_name => g_pkg_name,
16769: p_procedure_name => l_program_name);
16770: END IF;
16771: RETURN FND_API.to_boolean(L_FND_FALSE) ;
16772: END Validate_shipLinInt;
16773:
16774: -- API name : Import_LCMShipments
16775: -- Type : Public

Line 16859: IF FND_API.to_Boolean(p_init_msg_list) THEN

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;
16861: END IF;
16862: -- Standard call to check for call compatibility
16863: IF NOT FND_API.Compatible_API_Call(

Line 16863: IF NOT FND_API.Compatible_API_Call(

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,
16867: p_pkg_name => g_pkg_name ) THEN

Line 16921: IF FND_API.To_Boolean(p_commit) THEN

16917: p_procedure_name => l_program_name,
16918: p_debug_info => l_debug_info
16919: );
16920:
16921: IF FND_API.To_Boolean(p_commit) THEN
16922: l_commit_cycle := NVL(FND_PROFILE.VALUE('INL_SHIP_IMPORT_COMMIT_CYCLE'),'F'); -- dependence
16923: END IF;
16924:
16925: */

Line 16927: IF FND_API.To_Boolean(p_commit) THEN

16923: END IF;
16924:
16925: */
16926:
16927: IF FND_API.To_Boolean(p_commit) THEN
16928: l_commit_cycle := 'P';
16929: END IF;
16930:
16931: -- <#Bug /8979947>

Line 17486: IF FND_API.To_Boolean(p_commit) 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.
17490: FND_MSG_PUB.Count_And_Get(