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_SHIPMENT_PVT dependencies on STANDARD

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

146: l_msg_count NUMBER;
147: l_msg_data VARCHAR2 (2000) ;
148: l_debug_info VARCHAR2 (200) ;
149: BEGIN
150: -- Standard Beginning of Procedure/Function Logging
151: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
152: p_procedure_name => l_program_name) ;
153: -- Initialize return status to success
154: x_return_status := L_FND_RET_STS_SUCCESS;

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

224: L_FND_PROG_APPL_ID , /* 28 */
225: SYSDATE , /* 29 */
226: L_FND_CONC_REQUEST_ID /* 30 */
227: ) ;
228: -- Standard End of Procedure/Function Logging
229: INL_LOGGING_PVT.Log_EndProc(
230: p_module_name => g_module_name,
231: p_procedure_name => l_program_name
232: );

Line 235: -- Standard Expected Error Logging

231: p_procedure_name => l_program_name
232: );
233: EXCEPTION
234: WHEN L_FND_EXC_ERROR THEN
235: -- Standard Expected Error Logging
236: INL_LOGGING_PVT.Log_ExpecError(
237: p_module_name => g_module_name,
238: p_procedure_name => l_program_name
239: );

Line 242: -- Standard Unexpected Error Logging

238: p_procedure_name => l_program_name
239: );
240: x_return_status := L_FND_RET_STS_ERROR;
241: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
242: -- Standard Unexpected Error Logging
243: INL_LOGGING_PVT.Log_UnexpecError(
244: p_module_name => g_module_name,
245: p_procedure_name => l_program_name
246: );

Line 249: -- Standard Unexpected Error Logging

245: p_procedure_name => l_program_name
246: );
247: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
248: WHEN OTHERS THEN
249: -- Standard Unexpected Error Logging
250: INL_LOGGING_PVT.Log_UnexpecError(
251: p_module_name => g_module_name,
252: p_procedure_name => l_program_name
253: );

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

287: l_msg_count NUMBER;
288: l_msg_data VARCHAR2(2000);
289: l_debug_info VARCHAR2(200);
290: BEGIN
291: -- Standard Beginning of Procedure/Function Logging
292: INL_LOGGING_PVT.Log_BeginProc (
293: p_module_name => g_module_name,
294: p_procedure_name => l_program_name
295: );

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

317: WHERE ship_header_id = p_ship_header_id
318: AND ship_line_id = p_charge_line_id;
319: END IF;
320: END IF;
321: -- Standard End of Procedure/Function Logging
322: INL_LOGGING_PVT.Log_EndProc (
323: p_module_name => g_module_name,
324: p_procedure_name => l_program_name) ;
325: EXCEPTION

Line 327: -- Standard Expected Error Logging

323: p_module_name => g_module_name,
324: p_procedure_name => l_program_name) ;
325: EXCEPTION
326: WHEN L_FND_EXC_ERROR THEN
327: -- Standard Expected Error Logging
328: INL_LOGGING_PVT.Log_ExpecError (
329: p_module_name => g_module_name,
330: p_procedure_name => l_program_name) ;
331: x_return_status := L_FND_RET_STS_ERROR;

Line 333: -- Standard Unexpected Error Logging

329: p_module_name => g_module_name,
330: p_procedure_name => l_program_name) ;
331: x_return_status := L_FND_RET_STS_ERROR;
332: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
333: -- Standard Unexpected Error Logging
334: INL_LOGGING_PVT.Log_UnexpecError (
335: p_module_name => g_module_name,
336: p_procedure_name => l_program_name) ;
337: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 339: -- Standard Unexpected Error Logging

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

Line 401: -- Standard Start of API savepoint

397: BEGIN
398: INL_LOGGING_PVT.Log_BeginProc (
399: p_module_name => g_module_name,
400: p_procedure_name => l_api_name) ;
401: -- Standard Start of API savepoint
402: SAVEPOINT Complete_Shipment_PVT;
403: -- Initialize message list if p_init_msg_list is set to TRUE.
404: IF FND_API.to_Boolean (p_init_msg_list) THEN
405: FND_MSG_PUB.initialize;

Line 528: -- Standard check of p_commit.

524: last_updated_by = L_FND_USER_ID,
525: last_update_date = SYSDATE
526: WHERE ship_header_id = p_ship_header_id;
527:
528: -- Standard check of p_commit.
529: IF FND_API.To_Boolean (p_commit) THEN
530: COMMIT WORK;
531: END IF;
532: -- Standard call to get message count and if count is 1, get message info.

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

528: -- Standard check of p_commit.
529: IF FND_API.To_Boolean (p_commit) THEN
530: COMMIT WORK;
531: END IF;
532: -- Standard call to get message count and if count is 1, get message info.
533: FND_MSG_PUB.Count_And_Get (
534: p_encoded => L_FND_FALSE,
535: p_count => x_msg_count,
536: p_data => x_msg_data) ;

Line 666: -- Standard Start of API savepoint

662: BEGIN
663: INL_LOGGING_PVT.Log_BeginProc (
664: p_module_name => g_module_name,
665: p_procedure_name => l_api_name) ;
666: -- Standard Start of API savepoint
667: SAVEPOINT Set_ToRevalidate_PVT;
668: -- Initialize message list if p_init_msg_list is set to TRUE.
669: IF FND_API.to_Boolean (p_init_msg_list) THEN
670: FND_MSG_PUB.initialize;

Line 706: -- Standard check of p_commit.

702: UPDATE inl_ship_headers
703: SET ship_status_code = 'VALIDATION REQ'
704: WHERE ship_header_id = p_ship_header_id;
705: END IF;
706: -- Standard check of p_commit.
707: IF FND_API.To_Boolean (p_commit) THEN
708: COMMIT WORK;
709: END IF;
710: -- Standard call to get message count and if count is 1, get message info.

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

706: -- Standard check of p_commit.
707: IF FND_API.To_Boolean (p_commit) THEN
708: COMMIT WORK;
709: END IF;
710: -- Standard call to get message count and if count is 1, get message info.
711: FND_MSG_PUB.Count_And_Get (
712: p_encoded => L_FND_FALSE,
713: p_count => x_msg_count,
714: p_data => x_msg_data

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

994: l_unit_of_measure_rsl VARCHAR2(30);
995: l_converted_qty_rsl NUMBER;
996: l_total_quantity_rsl NUMBER := 0;
997: BEGIN
998: -- Standard Beginning of Procedure/Function Logging
999: INL_LOGGING_PVT.Log_BeginProc (
1000: p_module_name => g_module_name,
1001: p_procedure_name => l_api_name) ;
1002: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1124: -- Standard check of p_commit.

1120: p_module_name => g_module_name,
1121: p_procedure_name => l_api_name,
1122: p_var_name => 'p_unit_of_measure',
1123: p_var_value => p_unit_of_measure) ;
1124: -- Standard check of p_commit.
1125: IF FND_API.To_Boolean (p_commit) THEN
1126: COMMIT WORK;
1127: END IF;
1128: -- Standard call to get message count and if count is 1, get message info.

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

1124: -- Standard check of p_commit.
1125: IF FND_API.To_Boolean (p_commit) THEN
1126: COMMIT WORK;
1127: END IF;
1128: -- Standard call to get message count and if count is 1, get message info.
1129: FND_MSG_PUB.Count_And_Get (
1130: p_encoded => L_FND_FALSE,
1131: p_count => x_msg_count,
1132: p_data => x_msg_data) ;

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

1129: FND_MSG_PUB.Count_And_Get (
1130: p_encoded => L_FND_FALSE,
1131: p_count => x_msg_count,
1132: p_data => x_msg_data) ;
1133: -- Standard End of Procedure/Function Logging
1134: INL_LOGGING_PVT.Log_EndProc (
1135: p_module_name => g_module_name,
1136: p_procedure_name => l_api_name) ;
1137: EXCEPTION

Line 1139: -- Standard Expected Error Logging

1135: p_module_name => g_module_name,
1136: p_procedure_name => l_api_name) ;
1137: EXCEPTION
1138: WHEN L_FND_EXC_ERROR THEN
1139: -- Standard Expected Error Logging
1140: INL_LOGGING_PVT.Log_ExpecError (
1141: p_module_name => g_module_name,
1142: p_procedure_name => l_api_name) ;
1143: x_return_status := L_FND_RET_STS_ERROR;

Line 1149: -- Standard Unexpected Error Logging

1145: p_encoded => L_FND_FALSE,
1146: p_count => x_msg_count,
1147: p_data => x_msg_data) ;
1148: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
1149: -- Standard Unexpected Error Logging
1150: INL_LOGGING_PVT.Log_UnexpecError (
1151: p_module_name => g_module_name,
1152: p_procedure_name => l_api_name) ;
1153: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 1159: -- Standard Unexpected Error Logging

1155: p_encoded => L_FND_FALSE,
1156: p_count => x_msg_count,
1157: p_data => x_msg_data) ;
1158: WHEN OTHERS THEN
1159: -- Standard Unexpected Error Logging
1160: INL_LOGGING_PVT.Log_UnexpecError (
1161: p_module_name => g_module_name,
1162: p_procedure_name => l_api_name) ;
1163: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;

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

1229: l_msg_uom_tl VARCHAR2(30);
1230: l_pre_receive VARCHAR2(1);
1231: l_ship_qty_validation_inf_tbl ship_qty_validation_inf_tbl;
1232: BEGIN
1233: -- Standard Beginning of Procedure/Function Logging
1234: INL_LOGGING_PVT.Log_BeginProc (
1235: p_module_name => g_module_name,
1236: p_procedure_name => l_program_name) ;
1237: -- Initialize API return status to success

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

1712: l_po_converted_price NUMBER;
1713: l_p_converted_PUP NUMBER;
1714: l_po_UOM_code VARCHAR2(30);
1715: BEGIN
1716: -- Standard Beginning of Procedure/Function Logging
1717: INL_LOGGING_PVT.Log_BeginProc (
1718: p_module_name => g_module_name,
1719: p_procedure_name => l_program_name) ;
1720: -- Initialize API return status variables

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

2016: x_return_status => l_return_status) ;
2017: END IF;
2018: END IF;
2019: END IF;
2020: -- Standard End of Procedure/Function Logging
2021: INL_LOGGING_PVT.Log_EndProc (
2022: p_module_name => g_module_name,
2023: p_procedure_name => l_program_name) ;
2024: EXCEPTION

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

2100: l_ship_status_code VARCHAR2(30);
2101: l_pri_unit_price NUMBER;
2102:
2103: BEGIN
2104: -- Standard Beginning of Procedure/Function Logging
2105: INL_LOGGING_PVT.Log_BeginProc (
2106: p_module_name => g_module_name,
2107: p_procedure_name => l_program_name) ;
2108: -- Standard Start of API savepoint

Line 2108: -- Standard Start of API savepoint

2104: -- Standard Beginning of Procedure/Function Logging
2105: INL_LOGGING_PVT.Log_BeginProc (
2106: p_module_name => g_module_name,
2107: p_procedure_name => l_program_name) ;
2108: -- Standard Start of API savepoint
2109: SAVEPOINT Check_PoTolerances_PVT;
2110: -- Initialize message list if p_init_msg_list is set to TRUE.
2111: IF FND_API.to_Boolean (p_init_msg_list) THEN
2112: FND_MSG_PUB.initialize;

Line 2175: -- Standard check of p_commit.

2171: x_msg_count => l_msg_count,
2172: x_msg_data => l_msg_data);
2173: END;
2174:
2175: -- Standard check of p_commit.
2176: IF FND_API.To_Boolean (p_commit) THEN
2177: COMMIT WORK;
2178: END IF;
2179: -- Standard call to get message count and if count is 1, get message info.

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

2175: -- Standard check of p_commit.
2176: IF FND_API.To_Boolean (p_commit) THEN
2177: COMMIT WORK;
2178: END IF;
2179: -- Standard call to get message count and if count is 1, get message info.
2180: FND_MSG_PUB.Count_And_Get (
2181: p_encoded => L_FND_FALSE,
2182: p_count => x_msg_count,
2183: p_data => x_msg_data) ;

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

2180: FND_MSG_PUB.Count_And_Get (
2181: p_encoded => L_FND_FALSE,
2182: p_count => x_msg_count,
2183: p_data => x_msg_data) ;
2184: -- Standard End of Procedure/Function Logging
2185: INL_LOGGING_PVT.Log_EndProc (
2186: p_module_name => g_module_name,
2187: p_procedure_name => l_program_name) ;
2188: EXCEPTION

Line 2190: -- Standard Expected Error Logging

2186: p_module_name => g_module_name,
2187: p_procedure_name => l_program_name) ;
2188: EXCEPTION
2189: WHEN L_FND_EXC_ERROR THEN
2190: -- Standard Expected Error Logging
2191: INL_LOGGING_PVT.Log_ExpecError (
2192: p_module_name => g_module_name,
2193: p_procedure_name => l_program_name) ;
2194: ROLLBACK TO Check_PoTolerances_PVT;

Line 2201: -- Standard Unexpected Error Logging

2197: p_encoded => L_FND_FALSE,
2198: p_count => x_msg_count,
2199: p_data => x_msg_data) ;
2200: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
2201: -- Standard Unexpected Error Logging
2202: INL_LOGGING_PVT.Log_UnexpecError (
2203: p_module_name => g_module_name,
2204: p_procedure_name => l_program_name) ;
2205: ROLLBACK TO Check_PoTolerances_PVT;

Line 2212: -- Standard Unexpected Error Logging

2208: p_encoded => L_FND_FALSE,
2209: p_count => x_msg_count,
2210: p_data => x_msg_data) ;
2211: WHEN OTHERS THEN
2212: -- Standard Unexpected Error Logging
2213: INL_LOGGING_PVT.Log_UnexpecError (
2214: p_module_name => g_module_name,
2215: p_procedure_name => l_program_name) ;
2216: ROLLBACK TO Check_PoTolerances_PVT;

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

2289: l_debug_info VARCHAR2(200);
2290: l_return_validation_status VARCHAR2(30); -- SCM-051
2291: l_ship_status_code VARCHAR2(30);
2292: BEGIN
2293: -- Standard Beginning of Procedure/Function Logging
2294: INL_LOGGING_PVT.Log_BeginProc (
2295: p_module_name => g_module_name,
2296: p_procedure_name => l_program_name) ;
2297: -- Standard Start of API savepoint

Line 2297: -- Standard Start of API savepoint

2293: -- Standard Beginning of Procedure/Function Logging
2294: INL_LOGGING_PVT.Log_BeginProc (
2295: p_module_name => g_module_name,
2296: p_procedure_name => l_program_name) ;
2297: -- Standard Start of API savepoint
2298: SAVEPOINT Check_PoTolerances_PVT;
2299: -- Initialize message list if p_init_msg_list is set to TRUE.
2300: IF FND_API.to_Boolean (p_init_msg_list) THEN
2301: FND_MSG_PUB.initialize;

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

2374: RAISE L_FND_EXC_UNEXPECTED_ERROR;
2375: END IF;
2376: END IF;
2377:
2378: -- Standard call to get message count and if count is 1, get message info.
2379: FND_MSG_PUB.Count_And_Get (
2380: p_encoded => L_FND_FALSE,
2381: p_count => x_msg_count,
2382: p_data => x_msg_data) ;

Line 2413: -- Standard check of p_commit.

2409: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
2410: RAISE L_FND_EXC_UNEXPECTED_ERROR;
2411: END IF;
2412: END IF;
2413: -- Standard check of p_commit.
2414: IF FND_API.To_Boolean (p_commit) THEN
2415: COMMIT WORK;
2416: END IF;
2417: -- Standard call to get message count and if count is 1, get message info.

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

2413: -- Standard check of p_commit.
2414: IF FND_API.To_Boolean (p_commit) THEN
2415: COMMIT WORK;
2416: END IF;
2417: -- Standard call to get message count and if count is 1, get message info.
2418: FND_MSG_PUB.Count_And_Get (
2419: p_encoded => L_FND_FALSE,
2420: p_count => x_msg_count,
2421: p_data => x_msg_data) ;

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

2418: FND_MSG_PUB.Count_And_Get (
2419: p_encoded => L_FND_FALSE,
2420: p_count => x_msg_count,
2421: p_data => x_msg_data) ;
2422: -- Standard End of Procedure/Function Logging
2423: INL_LOGGING_PVT.Log_EndProc (
2424: p_module_name => g_module_name,
2425: p_procedure_name => l_program_name) ;
2426: EXCEPTION

Line 2428: -- Standard Expected Error Logging

2424: p_module_name => g_module_name,
2425: p_procedure_name => l_program_name) ;
2426: EXCEPTION
2427: WHEN L_FND_EXC_ERROR THEN
2428: -- Standard Expected Error Logging
2429: INL_LOGGING_PVT.Log_ExpecError (
2430: p_module_name => g_module_name,
2431: p_procedure_name => l_program_name) ;
2432: ROLLBACK TO Check_PoTolerances_PVT;

Line 2439: -- Standard Unexpected Error Logging

2435: p_encoded => L_FND_FALSE,
2436: p_count => x_msg_count,
2437: p_data => x_msg_data) ;
2438: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
2439: -- Standard Unexpected Error Logging
2440: INL_LOGGING_PVT.Log_UnexpecError (
2441: p_module_name => g_module_name,
2442: p_procedure_name => l_program_name) ;
2443: ROLLBACK TO Check_PoTolerances_PVT;

Line 2450: -- Standard Unexpected Error Logging

2446: p_encoded => L_FND_FALSE,
2447: p_count => x_msg_count,
2448: p_data => x_msg_data) ;
2449: WHEN OTHERS THEN
2450: -- Standard Unexpected Error Logging
2451: INL_LOGGING_PVT.Log_UnexpecError (
2452: p_module_name => g_module_name,
2453: p_procedure_name => l_program_name) ;
2454: ROLLBACK TO Check_PoTolerances_PVT;

Line 2570: -- Standard Expected Error Logging

2566: p_module_name => g_module_name,
2567: p_procedure_name => l_program_name) ;
2568: EXCEPTION
2569: WHEN L_FND_EXC_ERROR THEN
2570: -- Standard Expected Error Logging
2571: INL_LOGGING_PVT.Log_ExpecError (
2572: p_module_name => g_module_name,
2573: p_procedure_name => l_program_name) ;
2574: x_return_status := L_FND_RET_STS_ERROR;

Line 2576: -- Standard Unexpected Error Logging

2572: p_module_name => g_module_name,
2573: p_procedure_name => l_program_name) ;
2574: x_return_status := L_FND_RET_STS_ERROR;
2575: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
2576: -- Standard Unexpected Error Logging
2577: INL_LOGGING_PVT.Log_UnexpecError (
2578: p_module_name => g_module_name,
2579: p_procedure_name => l_program_name) ;
2580: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 2582: -- Standard Unexpected Error Logging

2578: p_module_name => g_module_name,
2579: p_procedure_name => l_program_name) ;
2580: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2581: WHEN OTHERS THEN
2582: -- Standard Unexpected Error Logging
2583: INL_LOGGING_PVT.Log_UnexpecError (
2584: p_module_name => g_module_name,
2585: p_procedure_name => l_program_name) ;
2586: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 2691: -- Standard Unexpected Error Logging

2687: p_module_name => g_module_name,
2688: p_procedure_name => l_program_name) ;
2689: EXCEPTION
2690: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
2691: -- Standard Unexpected Error Logging
2692: INL_LOGGING_PVT.Log_UnexpecError (
2693: p_module_name => g_module_name,
2694: p_procedure_name => l_program_name) ;
2695: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 2697: -- Standard Unexpected Error Logging

2693: p_module_name => g_module_name,
2694: p_procedure_name => l_program_name) ;
2695: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2696: WHEN OTHERS THEN
2697: -- Standard Unexpected Error Logging
2698: INL_LOGGING_PVT.Log_UnexpecError (
2699: p_module_name => g_module_name,
2700: p_procedure_name => l_program_name) ;
2701: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 2817: -- Standard Unexpected Error Logging

2813: p_module_name => g_module_name,
2814: p_procedure_name => l_program_name) ;
2815: EXCEPTION
2816: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
2817: -- Standard Unexpected Error Logging
2818: INL_LOGGING_PVT.Log_UnexpecError (
2819: p_module_name => g_module_name,
2820: p_procedure_name => l_program_name) ;
2821: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 2823: -- Standard Unexpected Error Logging

2819: p_module_name => g_module_name,
2820: p_procedure_name => l_program_name) ;
2821: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2822: WHEN OTHERS THEN
2823: -- Standard Unexpected Error Logging
2824: INL_LOGGING_PVT.Log_UnexpecError (
2825: p_module_name => g_module_name,
2826: p_procedure_name => l_program_name) ;
2827: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 3388: -- Standard Expected Error Logging

3384: p_procedure_name => l_program_name) ;
3385: --Bug#13987019 END
3386: EXCEPTION
3387: WHEN L_FND_EXC_ERROR THEN
3388: -- Standard Expected Error Logging
3389: INL_LOGGING_PVT.Log_ExpecError (
3390: p_module_name => g_module_name,
3391: p_procedure_name => l_program_name) ;
3392: x_return_status := L_FND_RET_STS_ERROR;

Line 3394: -- Standard Unexpected Error Logging

3390: p_module_name => g_module_name,
3391: p_procedure_name => l_program_name) ;
3392: x_return_status := L_FND_RET_STS_ERROR;
3393: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
3394: -- Standard Unexpected Error Logging
3395: INL_LOGGING_PVT.Log_UnexpecError (
3396: p_module_name => g_module_name,
3397: p_procedure_name => l_program_name) ;
3398: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 3400: -- Standard Unexpected Error Logging

3396: p_module_name => g_module_name,
3397: p_procedure_name => l_program_name) ;
3398: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
3399: WHEN OTHERS THEN
3400: -- Standard Unexpected Error Logging
3401: INL_LOGGING_PVT.Log_UnexpecError (
3402: p_module_name => g_module_name,
3403: p_procedure_name => l_program_name) ;
3404: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 3867: -- Standard Expected Error Logging

3863: p_module_name => g_module_name,
3864: p_procedure_name => l_program_name) ;
3865: EXCEPTION
3866: WHEN L_FND_EXC_ERROR THEN
3867: -- Standard Expected Error Logging
3868: INL_LOGGING_PVT.Log_ExpecError (
3869: p_module_name => g_module_name,
3870: p_procedure_name => l_program_name) ;
3871: x_return_status := L_FND_RET_STS_ERROR;

Line 3873: -- Standard Unexpected Error Logging

3869: p_module_name => g_module_name,
3870: p_procedure_name => l_program_name) ;
3871: x_return_status := L_FND_RET_STS_ERROR;
3872: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
3873: -- Standard Unexpected Error Logging
3874: INL_LOGGING_PVT.Log_UnexpecError (
3875: p_module_name => g_module_name,
3876: p_procedure_name => l_program_name) ;
3877: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 3879: -- Standard Unexpected Error Logging

3875: p_module_name => g_module_name,
3876: p_procedure_name => l_program_name) ;
3877: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
3878: WHEN OTHERS THEN
3879: -- Standard Unexpected Error Logging
3880: INL_LOGGING_PVT.Log_UnexpecError (
3881: p_module_name => g_module_name,
3882: p_procedure_name => l_program_name) ;
3883: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 4233: -- Standard Expected Error Logging

4229: END LOOP;
4230: END IF;
4231: EXCEPTION
4232: WHEN L_FND_EXC_ERROR THEN
4233: -- Standard Expected Error Logging
4234: INL_LOGGING_PVT.Log_ExpecError (
4235: p_module_name => g_module_name,
4236: p_procedure_name => l_program_name) ;
4237: x_return_status := L_FND_RET_STS_ERROR;

Line 4239: -- Standard Unexpected Error Logging

4235: p_module_name => g_module_name,
4236: p_procedure_name => l_program_name) ;
4237: x_return_status := L_FND_RET_STS_ERROR;
4238: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
4239: -- Standard Unexpected Error Logging
4240: INL_LOGGING_PVT.Log_UnexpecError (
4241: p_module_name => g_module_name,
4242: p_procedure_name => l_program_name) ;
4243: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 4245: -- Standard Unexpected Error Logging

4241: p_module_name => g_module_name,
4242: p_procedure_name => l_program_name) ;
4243: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
4244: WHEN OTHERS THEN
4245: -- Standard Unexpected Error Logging
4246: INL_LOGGING_PVT.Log_UnexpecError (
4247: p_module_name => g_module_name,
4248: p_procedure_name => l_program_name) ;
4249: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 4326: -- Standard Expected Error Logging

4322: p_procedure_name => l_program_name) ;
4323: RETURN l_boolean_to_char;
4324: EXCEPTION
4325: WHEN L_FND_EXC_ERROR THEN
4326: -- Standard Expected Error Logging
4327: INL_LOGGING_PVT.Log_ExpecError (
4328: p_module_name => g_module_name,
4329: p_procedure_name => l_program_name) ;
4330: x_return_status := L_FND_RET_STS_ERROR;

Line 4333: -- Standard Unexpected Error Logging

4329: p_procedure_name => l_program_name) ;
4330: x_return_status := L_FND_RET_STS_ERROR;
4331: RETURN 'FALSE';
4332: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
4333: -- Standard Unexpected Error Logging
4334: INL_LOGGING_PVT.Log_UnexpecError (
4335: p_module_name => g_module_name,
4336: p_procedure_name => l_program_name) ;
4337: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 4340: -- Standard Unexpected Error Logging

4336: p_procedure_name => l_program_name) ;
4337: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
4338: RETURN 'FALSE';
4339: WHEN OTHERS THEN
4340: -- Standard Unexpected Error Logging
4341: INL_LOGGING_PVT.Log_UnexpecError (
4342: p_module_name => g_module_name,
4343: p_procedure_name => l_program_name) ;
4344: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 4393: -- Standard Start of API savepoint

4389: BEGIN
4390: INL_LOGGING_PVT.Log_BeginProc (
4391: p_module_name => g_module_name,
4392: p_procedure_name => l_api_name) ;
4393: -- Standard Start of API savepoint
4394: SAVEPOINT Validate_Shipment_PVT;
4395: -- Initialize message list if p_init_msg_list is set to TRUE.
4396: IF FND_API.to_Boolean (p_init_msg_list) THEN
4397: FND_MSG_PUB.initialize;

Line 4481: -- Standard check of p_commit.

4477: last_updated_by = L_FND_USER_ID,
4478: last_update_date = SYSDATE
4479: WHERE ship_header_id = p_ship_header_id;
4480: END IF;
4481: -- Standard check of p_commit.
4482: IF FND_API.To_Boolean (p_commit) THEN
4483: COMMIT WORK;
4484: END IF;
4485: -- Standard call to get message count and if count is 1, get message info.

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

4481: -- Standard check of p_commit.
4482: IF FND_API.To_Boolean (p_commit) THEN
4483: COMMIT WORK;
4484: END IF;
4485: -- Standard call to get message count and if count is 1, get message info.
4486: FND_MSG_PUB.Count_And_Get (
4487: p_encoded => L_FND_FALSE,
4488: p_count => x_msg_count,
4489: p_data => x_msg_data) ;

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

4550: l_program_name CONSTANT VARCHAR2 (30) := 'Create_Assoc';
4551: l_return_status VARCHAR2 (1) ;
4552: l_debug_info VARCHAR2 (200) ;
4553: BEGIN
4554: -- Standard Beginning of Procedure/Function Logging
4555: INL_LOGGING_PVT.Log_BeginProc (
4556: p_module_name => g_module_name,
4557: p_procedure_name => l_program_name) ;
4558: -- Initialize return status to success

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

4627: p_module_name => g_module_name,
4628: p_procedure_name => l_program_name,
4629: p_var_name => 'p_new_line_id',
4630: p_var_value => p_new_line_id) ;
4631: -- Standard End of Procedure/Function Logging
4632: INL_LOGGING_PVT.Log_EndProc(
4633: p_module_name => g_module_name,
4634: p_procedure_name => l_program_name
4635: );

Line 4638: -- Standard Expected Error Logging

4634: p_procedure_name => l_program_name
4635: );
4636: EXCEPTION
4637: WHEN L_FND_EXC_ERROR THEN
4638: -- Standard Expected Error Logging
4639: INL_LOGGING_PVT.Log_ExpecError(
4640: p_module_name => g_module_name,
4641: p_procedure_name => l_program_name
4642: );

Line 4645: -- Standard Unexpected Error Logging

4641: p_procedure_name => l_program_name
4642: );
4643: x_return_status := L_FND_RET_STS_ERROR;
4644: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
4645: -- Standard Unexpected Error Logging
4646: INL_LOGGING_PVT.Log_UnexpecError(
4647: p_module_name => g_module_name,
4648: p_procedure_name => l_program_name
4649: );

Line 4652: -- Standard Unexpected Error Logging

4648: p_procedure_name => l_program_name
4649: );
4650: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
4651: WHEN OTHERS THEN
4652: -- Standard Unexpected Error Logging
4653: INL_LOGGING_PVT.Log_UnexpecError(
4654: p_module_name => g_module_name,
4655: p_procedure_name => l_program_name
4656: );

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

4691: l_debug_info VARCHAR2(200);
4692: l_tax_line_num NUMBER;
4693: l_adjustment_num NUMBER;
4694: BEGIN
4695: -- Standard Beginning of Procedure/Function Logging
4696: INL_LOGGING_PVT.Log_BeginProc (
4697: p_module_name => g_module_name,
4698: p_procedure_name => l_program_name
4699: );

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

4814: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
4815: RAISE L_FND_EXC_UNEXPECTED_ERROR;
4816: END IF;
4817: END IF;
4818: -- Standard End of Procedure/Function Logging
4819: INL_LOGGING_PVT.Log_EndProc(
4820: p_module_name => g_module_name,
4821: p_procedure_name => l_program_name
4822: );

Line 4825: -- Standard Expected Error Logging

4821: p_procedure_name => l_program_name
4822: );
4823: EXCEPTION
4824: WHEN L_FND_EXC_ERROR THEN
4825: -- Standard Expected Error Logging
4826: INL_LOGGING_PVT.Log_ExpecError(
4827: p_module_name => g_module_name,
4828: p_procedure_name => l_program_name
4829: );

Line 4832: -- Standard Unexpected Error Logging

4828: p_procedure_name => l_program_name
4829: );
4830: x_return_status := L_FND_RET_STS_ERROR;
4831: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
4832: -- Standard Unexpected Error Logging
4833: INL_LOGGING_PVT.Log_UnexpecError(
4834: p_module_name => g_module_name,
4835: p_procedure_name => l_program_name
4836: );

Line 4839: -- Standard Unexpected Error Logging

4835: p_procedure_name => l_program_name
4836: );
4837: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
4838: WHEN OTHERS THEN
4839: -- Standard Unexpected Error Logging
4840: INL_LOGGING_PVT.Log_UnexpecError(
4841: p_module_name => g_module_name,
4842: p_procedure_name => l_program_name
4843: );

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

4960: C_est_TL est_TL_Type;
4961: l_TxLn_Assoc inl_TxLn_Assoc_tp;
4962: l_new_tax_line_id NUMBER;
4963: BEGIN
4964: -- Standard Beginning of Procedure/Function Logging
4965: INL_LOGGING_PVT.Log_BeginProc (
4966: p_module_name => g_module_name,
4967: p_procedure_name => l_program_name
4968: );

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

5046: RAISE L_FND_EXC_UNEXPECTED_ERROR;
5047: END IF;
5048: END LOOP;
5049: END IF;
5050: -- Standard End of Procedure/Function Logging
5051: INL_LOGGING_PVT.Log_EndProc (
5052: p_module_name => g_module_name,
5053: p_procedure_name => l_program_name
5054: ) ;

Line 5057: -- Standard Expected Error Logging

5053: p_procedure_name => l_program_name
5054: ) ;
5055: EXCEPTION
5056: WHEN L_FND_EXC_ERROR THEN
5057: -- Standard Expected Error Logging
5058: INL_LOGGING_PVT.Log_ExpecError (
5059: p_module_name => g_module_name,
5060: p_procedure_name => l_program_name
5061: ) ;

Line 5064: -- Standard Unexpected Error Logging

5060: p_procedure_name => l_program_name
5061: ) ;
5062: x_return_status := L_FND_RET_STS_ERROR;
5063: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
5064: -- Standard Unexpected Error Logging
5065: INL_LOGGING_PVT.Log_UnexpecError (
5066: p_module_name => g_module_name,
5067: p_procedure_name => l_program_name
5068: ) ;

Line 5071: -- Standard Unexpected Error Logging

5067: p_procedure_name => l_program_name
5068: ) ;
5069: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
5070: WHEN OTHERS THEN
5071: -- Standard Unexpected Error Logging
5072: INL_LOGGING_PVT.Log_UnexpecError (
5073: p_module_name => g_module_name,
5074: p_procedure_name => l_program_name
5075: ) ;

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

5134: C_ori_TL ori_TL_Type;
5135: l_TxLn_Assoc inl_TxLn_Assoc_tp;
5136: l_new_tax_line_id NUMBER;
5137: BEGIN
5138: -- Standard Beginning of Procedure/Function Logging
5139: INL_LOGGING_PVT.Log_BeginProc (
5140: p_module_name => g_module_name,
5141: p_procedure_name => l_program_name
5142: );

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

5200: RAISE L_FND_EXC_UNEXPECTED_ERROR;
5201: END IF;
5202: END LOOP;
5203: END IF;
5204: -- Standard End of Procedure/Function Logging
5205: INL_LOGGING_PVT.Log_EndProc (
5206: p_module_name => g_module_name,
5207: p_procedure_name => l_program_name
5208: ) ;

Line 5211: -- Standard Expected Error Logging

5207: p_procedure_name => l_program_name
5208: ) ;
5209: EXCEPTION
5210: WHEN L_FND_EXC_ERROR THEN
5211: -- Standard Expected Error Logging
5212: INL_LOGGING_PVT.Log_ExpecError (
5213: p_module_name => g_module_name,
5214: p_procedure_name => l_program_name
5215: ) ;

Line 5218: -- Standard Unexpected Error Logging

5214: p_procedure_name => l_program_name
5215: ) ;
5216: x_return_status := L_FND_RET_STS_ERROR;
5217: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
5218: -- Standard Unexpected Error Logging
5219: INL_LOGGING_PVT.Log_UnexpecError (
5220: p_module_name => g_module_name,
5221: p_procedure_name => l_program_name
5222: ) ;

Line 5225: -- Standard Unexpected Error Logging

5221: p_procedure_name => l_program_name
5222: ) ;
5223: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
5224: WHEN OTHERS THEN
5225: -- Standard Unexpected Error Logging
5226: INL_LOGGING_PVT.Log_UnexpecError (
5227: p_module_name => g_module_name,
5228: p_procedure_name => l_program_name
5229: ) ;

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

5392: l_last_adj_sl last_adj_sl;
5393: -- /Bug 11775590
5394:
5395: BEGIN
5396: -- Standard Beginning of Procedure/Function Logging
5397: INL_LOGGING_PVT.Log_BeginProc (
5398: p_module_name => g_module_name,
5399: p_procedure_name => l_api_name
5400: ) ;

Line 5401: -- Standard Start of API savepoint

5397: INL_LOGGING_PVT.Log_BeginProc (
5398: p_module_name => g_module_name,
5399: p_procedure_name => l_api_name
5400: ) ;
5401: -- Standard Start of API savepoint
5402: SAVEPOINT Adjust_ShipLines_PVT;
5403: -- Initialize message list if p_init_msg_list is set to TRUE.
5404: IF FND_API.to_Boolean (p_init_msg_list) THEN
5405: FND_MSG_PUB.initialize;

Line 6170: -- Standard check of p_commit.

6166: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
6167: RAISE L_FND_EXC_UNEXPECTED_ERROR;
6168: END IF;
6169: END IF;
6170: -- Standard check of p_commit.
6171: IF FND_API.To_Boolean (p_commit) THEN
6172: COMMIT WORK;
6173: END IF;
6174: -- Standard call to get message count and if count is 1, get message info.

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

6170: -- Standard check of p_commit.
6171: IF FND_API.To_Boolean (p_commit) THEN
6172: COMMIT WORK;
6173: END IF;
6174: -- Standard call to get message count and if count is 1, get message info.
6175: FND_MSG_PUB.Count_And_Get (
6176: p_encoded => L_FND_FALSE,
6177: p_count => x_msg_count,
6178: p_data => x_msg_data

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

6176: p_encoded => L_FND_FALSE,
6177: p_count => x_msg_count,
6178: p_data => x_msg_data
6179: ) ;
6180: -- Standard End of Procedure/Function Logging
6181: INL_LOGGING_PVT.Log_EndProc (
6182: p_module_name => g_module_name,
6183: p_procedure_name => l_api_name
6184: ) ;

Line 6187: -- Standard Expected Error Logging

6183: p_procedure_name => l_api_name
6184: ) ;
6185: EXCEPTION
6186: WHEN L_FND_EXC_ERROR THEN
6187: -- Standard Expected Error Logging
6188: INL_LOGGING_PVT.Log_ExpecError (
6189: p_module_name => g_module_name,
6190: p_procedure_name => l_api_name
6191: ) ;

Line 6200: -- Standard Unexpected Error Logging

6196: p_count => x_msg_count,
6197: p_data => x_msg_data
6198: ) ;
6199: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
6200: -- Standard Unexpected Error Logging
6201: INL_LOGGING_PVT.Log_UnexpecError (
6202: p_module_name => g_module_name,
6203: p_procedure_name => l_api_name
6204: ) ;

Line 6213: -- Standard Unexpected Error Logging

6209: p_count => x_msg_count,
6210: p_data => x_msg_data
6211: ) ;
6212: WHEN OTHERS THEN
6213: -- Standard Unexpected Error Logging
6214: INL_LOGGING_PVT.Log_UnexpecError (
6215: p_module_name => g_module_name,
6216: p_procedure_name => l_api_name
6217: ) ;

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

6257: l_debug_info VARCHAR2 (200) ;
6258: l_charge_line_num NUMBER;
6259: l_adjustment_num NUMBER;
6260: BEGIN
6261: -- Standard Beginning of Procedure/Function Logging
6262: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name, p_procedure_name => l_program_name) ;
6263: -- Initialize return status to success
6264: x_return_status := L_FND_RET_STS_SUCCESS;
6265: --

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

6435: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
6436: RAISE L_FND_EXC_UNEXPECTED_ERROR;
6437: END IF;
6438: END IF;
6439: -- Standard End of Procedure/Function Logging
6440: INL_LOGGING_PVT.Log_EndProc(
6441: p_module_name => g_module_name,
6442: p_procedure_name => l_program_name
6443: );

Line 6446: -- Standard Expected Error Logging

6442: p_procedure_name => l_program_name
6443: );
6444: EXCEPTION
6445: WHEN L_FND_EXC_ERROR THEN
6446: -- Standard Expected Error Logging
6447: INL_LOGGING_PVT.Log_ExpecError(
6448: p_module_name => g_module_name,
6449: p_procedure_name => l_program_name
6450: );

Line 6453: -- Standard Unexpected Error Logging

6449: p_procedure_name => l_program_name
6450: );
6451: x_return_status := L_FND_RET_STS_ERROR;
6452: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
6453: -- Standard Unexpected Error Logging
6454: INL_LOGGING_PVT.Log_UnexpecError(
6455: p_module_name => g_module_name,
6456: p_procedure_name => l_program_name
6457: );

Line 6460: -- Standard Unexpected Error Logging

6456: p_procedure_name => l_program_name
6457: );
6458: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
6459: WHEN OTHERS THEN
6460: -- Standard Unexpected Error Logging
6461: INL_LOGGING_PVT.Log_UnexpecError(
6462: p_module_name => g_module_name,
6463: p_procedure_name => l_program_name
6464: );

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

6577: l_ChLn_Assoc inl_ChLn_Assoc_tp;
6578: l_new_charge_line_id NUMBER;
6579: l_level_charge_is_applied VARCHAR(5):= 'X';
6580: BEGIN
6581: -- Standard Beginning of Procedure/Function Logging
6582: INL_LOGGING_PVT.Log_BeginProc (
6583: p_module_name => g_module_name,
6584: p_procedure_name => l_program_name
6585: );

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

6690: RAISE L_FND_EXC_UNEXPECTED_ERROR;
6691: END IF;
6692: END LOOP;
6693: END IF;
6694: -- Standard End of Procedure/Function Logging
6695: INL_LOGGING_PVT.Log_EndProc (
6696: p_module_name => g_module_name,
6697: p_procedure_name => l_program_name
6698: ) ;

Line 6701: -- Standard Expected Error Logging

6697: p_procedure_name => l_program_name
6698: ) ;
6699: EXCEPTION
6700: WHEN L_FND_EXC_ERROR THEN
6701: -- Standard Expected Error Logging
6702: INL_LOGGING_PVT.Log_ExpecError (
6703: p_module_name => g_module_name,
6704: p_procedure_name => l_program_name
6705: ) ;

Line 6708: -- Standard Unexpected Error Logging

6704: p_procedure_name => l_program_name
6705: ) ;
6706: x_return_status := L_FND_RET_STS_ERROR;
6707: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
6708: -- Standard Unexpected Error Logging
6709: INL_LOGGING_PVT.Log_UnexpecError (
6710: p_module_name => g_module_name,
6711: p_procedure_name => l_program_name
6712: ) ;

Line 6715: -- Standard Unexpected Error Logging

6711: p_procedure_name => l_program_name
6712: ) ;
6713: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
6714: WHEN OTHERS THEN
6715: -- Standard Unexpected Error Logging
6716: INL_LOGGING_PVT.Log_UnexpecError (
6717: p_module_name => g_module_name,
6718: p_procedure_name => l_program_name
6719: ) ;

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

6851: l_ChLn_Assoc inl_ChLn_Assoc_tp;
6852: l_new_charge_line_id NUMBER;
6853: l_level_charge_is_applied VARCHAR(5):= 'X';
6854: BEGIN
6855: -- Standard Beginning of Procedure/Function Logging
6856: INL_LOGGING_PVT.Log_BeginProc (
6857: p_module_name => g_module_name,
6858: p_procedure_name => l_program_name
6859: );

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

6971: RAISE L_FND_EXC_UNEXPECTED_ERROR;
6972: END IF;
6973: END LOOP;
6974: END IF;
6975: -- Standard End of Procedure/Function Logging
6976: INL_LOGGING_PVT.Log_EndProc (
6977: p_module_name => g_module_name,
6978: p_procedure_name => l_program_name
6979: ) ;

Line 6982: -- Standard Expected Error Logging

6978: p_procedure_name => l_program_name
6979: ) ;
6980: EXCEPTION
6981: WHEN L_FND_EXC_ERROR THEN
6982: -- Standard Expected Error Logging
6983: INL_LOGGING_PVT.Log_ExpecError (
6984: p_module_name => g_module_name,
6985: p_procedure_name => l_program_name
6986: ) ;

Line 6989: -- Standard Unexpected Error Logging

6985: p_procedure_name => l_program_name
6986: ) ;
6987: x_return_status := L_FND_RET_STS_ERROR;
6988: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
6989: -- Standard Unexpected Error Logging
6990: INL_LOGGING_PVT.Log_UnexpecError (
6991: p_module_name => g_module_name,
6992: p_procedure_name => l_program_name
6993: ) ;

Line 6996: -- Standard Unexpected Error Logging

6992: p_procedure_name => l_program_name
6993: ) ;
6994: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
6995: WHEN OTHERS THEN
6996: -- Standard Unexpected Error Logging
6997: INL_LOGGING_PVT.Log_UnexpecError (
6998: p_module_name => g_module_name,
6999: p_procedure_name => l_program_name
7000: ) ;

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

7132: ELC_CLines_lst ELC_CLines_Type;
7133: l_ELC_ShouldBeCreatedFlag VARCHAR2(1);
7134: l_last_parentChargeLineID NUMBER;
7135: BEGIN
7136: -- Standard Beginning of Procedure/Function Logging
7137: INL_LOGGING_PVT.Log_BeginProc (
7138: p_module_name => g_module_name,
7139: p_procedure_name => l_program_name
7140: );

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

7806: END IF;
7807: END LOOP;
7808: END IF;
7809: END IF;
7810: -- Standard End of Procedure/Function Logging
7811: INL_LOGGING_PVT.Log_EndProc (
7812: p_module_name => g_module_name,
7813: p_procedure_name => l_program_name
7814: ) ;

Line 7817: -- Standard Expected Error Logging

7813: p_procedure_name => l_program_name
7814: ) ;
7815: EXCEPTION
7816: WHEN L_FND_EXC_ERROR THEN
7817: -- Standard Expected Error Logging
7818: INL_LOGGING_PVT.Log_ExpecError (
7819: p_module_name => g_module_name,
7820: p_procedure_name => l_program_name
7821: ) ;

Line 7824: -- Standard Unexpected Error Logging

7820: p_procedure_name => l_program_name
7821: ) ;
7822: x_return_status := L_FND_RET_STS_ERROR;
7823: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
7824: -- Standard Unexpected Error Logging
7825: INL_LOGGING_PVT.Log_UnexpecError (
7826: p_module_name => g_module_name,
7827: p_procedure_name => l_program_name
7828: ) ;

Line 7831: -- Standard Unexpected Error Logging

7827: p_procedure_name => l_program_name
7828: ) ;
7829: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
7830: WHEN OTHERS THEN
7831: -- Standard Unexpected Error Logging
7832: INL_LOGGING_PVT.Log_UnexpecError (
7833: p_module_name => g_module_name,
7834: p_procedure_name => l_program_name
7835: ) ;

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

7868: l_program_name CONSTANT VARCHAR2(30) := 'Handle_EstimChLinesPerMatch';
7869: l_return_status VARCHAR2(1);
7870: l_debug_info VARCHAR2(200);
7871: BEGIN
7872: -- Standard Beginning of Procedure/Function Logging
7873: INL_LOGGING_PVT.Log_BeginProc (
7874: p_module_name => g_module_name,
7875: p_procedure_name => l_program_name
7876: );

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

7916: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
7917: RAISE L_FND_EXC_UNEXPECTED_ERROR;
7918: END IF;
7919:
7920: -- Standard End of Procedure/Function Logging
7921: INL_LOGGING_PVT.Log_EndProc (
7922: p_module_name => g_module_name,
7923: p_procedure_name => l_program_name
7924: ) ;

Line 7927: -- Standard Expected Error Logging

7923: p_procedure_name => l_program_name
7924: ) ;
7925: EXCEPTION
7926: WHEN L_FND_EXC_ERROR THEN
7927: -- Standard Expected Error Logging
7928: INL_LOGGING_PVT.Log_ExpecError (
7929: p_module_name => g_module_name,
7930: p_procedure_name => l_program_name
7931: ) ;

Line 7934: -- Standard Unexpected Error Logging

7930: p_procedure_name => l_program_name
7931: ) ;
7932: x_return_status := L_FND_RET_STS_ERROR;
7933: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
7934: -- Standard Unexpected Error Logging
7935: INL_LOGGING_PVT.Log_UnexpecError (
7936: p_module_name => g_module_name,
7937: p_procedure_name => l_program_name
7938: ) ;

Line 7941: -- Standard Unexpected Error Logging

7937: p_procedure_name => l_program_name
7938: ) ;
7939: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
7940: WHEN OTHERS THEN
7941: -- Standard Unexpected Error Logging
7942: INL_LOGGING_PVT.Log_UnexpecError (
7943: p_module_name => g_module_name,
7944: p_procedure_name => l_program_name
7945: ) ;

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

8014: l_ChLn_Assoc inl_ChLn_Assoc_tp;
8015: l_garb NUMBER ; --BUG#8468830
8016:
8017: BEGIN
8018: -- Standard Beginning of Procedure/Function Logging
8019: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8020: -- Standard Start of API savepoint
8021: SAVEPOINT Adjust_ChargeLines_PVT;
8022: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 8020: -- Standard Start of API savepoint

8016:
8017: BEGIN
8018: -- Standard Beginning of Procedure/Function Logging
8019: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8020: -- Standard Start of API savepoint
8021: SAVEPOINT Adjust_ChargeLines_PVT;
8022: -- Initialize message list if p_init_msg_list is set to TRUE.
8023: IF FND_API.to_Boolean (p_init_msg_list) THEN
8024: FND_MSG_PUB.initialize;

Line 8354: -- Standard check of p_commit.

8350: RAISE L_FND_EXC_ERROR;
8351: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
8352: RAISE L_FND_EXC_UNEXPECTED_ERROR;
8353: END IF;
8354: -- Standard check of p_commit.
8355: IF FND_API.To_Boolean (p_commit) THEN
8356: COMMIT WORK;
8357: END IF;
8358: -- Standard call to get message count and if count is 1, get message info.

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

8354: -- Standard check of p_commit.
8355: IF FND_API.To_Boolean (p_commit) THEN
8356: COMMIT WORK;
8357: END IF;
8358: -- Standard call to get message count and if count is 1, get message info.
8359: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
8360: -- Standard End of Procedure/Function Logging
8361: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8362: EXCEPTION

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

8356: COMMIT WORK;
8357: END IF;
8358: -- Standard call to get message count and if count is 1, get message info.
8359: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
8360: -- Standard End of Procedure/Function Logging
8361: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8362: EXCEPTION
8363: WHEN L_FND_EXC_ERROR THEN
8364: -- Standard Expected Error Logging

Line 8364: -- Standard Expected Error Logging

8360: -- Standard End of Procedure/Function Logging
8361: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8362: EXCEPTION
8363: WHEN L_FND_EXC_ERROR THEN
8364: -- Standard Expected Error Logging
8365: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8366: ROLLBACK TO Adjust_ChargeLines_PVT;
8367: x_return_status := L_FND_RET_STS_ERROR;
8368: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;

Line 8370: -- Standard Unexpected Error Logging

8366: ROLLBACK TO Adjust_ChargeLines_PVT;
8367: x_return_status := L_FND_RET_STS_ERROR;
8368: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
8369: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
8370: -- Standard Unexpected Error Logging
8371: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8372: ROLLBACK TO Adjust_ChargeLines_PVT;
8373: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8374: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;

Line 8376: -- Standard Unexpected Error Logging

8372: ROLLBACK TO Adjust_ChargeLines_PVT;
8373: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
8374: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
8375: WHEN OTHERS THEN
8376: -- Standard Unexpected Error Logging
8377: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8378: ROLLBACK TO Adjust_ChargeLines_PVT;
8379: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
8380: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

8462: l_AssocLn inl_Assoc_tp;
8463: l_garb NUMBER ; --BUG#8468830
8464: l_prev_match_id NUMBER;
8465: BEGIN
8466: -- Standard Beginning of Procedure/Function Logging
8467: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8468: -- Standard Start of API savepoint
8469: SAVEPOINT Adjust_ChargeLines_PVT;
8470: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 8468: -- Standard Start of API savepoint

8464: l_prev_match_id NUMBER;
8465: BEGIN
8466: -- Standard Beginning of Procedure/Function Logging
8467: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8468: -- Standard Start of API savepoint
8469: SAVEPOINT Adjust_ChargeLines_PVT;
8470: -- Initialize message list if p_init_msg_list is set to TRUE.
8471: IF FND_API.to_Boolean (p_init_msg_list) THEN
8472: FND_MSG_PUB.initialize;

Line 8951: -- Standard check of p_commit.

8947: RAISE L_FND_EXC_ERROR;
8948: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
8949: RAISE L_FND_EXC_UNEXPECTED_ERROR;
8950: END IF;
8951: -- Standard check of p_commit.
8952: IF FND_API.To_Boolean (p_commit) THEN
8953: COMMIT WORK;
8954: END IF;
8955: -- Standard call to get message count and if count is 1, get message info.

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

8951: -- Standard check of p_commit.
8952: IF FND_API.To_Boolean (p_commit) THEN
8953: COMMIT WORK;
8954: END IF;
8955: -- Standard call to get message count and if count is 1, get message info.
8956: FND_MSG_PUB.Count_And_Get (p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
8957: -- Standard End of Procedure/Function Logging
8958: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8959: EXCEPTION

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

8953: COMMIT WORK;
8954: END IF;
8955: -- Standard call to get message count and if count is 1, get message info.
8956: FND_MSG_PUB.Count_And_Get (p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
8957: -- Standard End of Procedure/Function Logging
8958: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8959: EXCEPTION
8960: WHEN L_FND_EXC_ERROR THEN
8961: -- Standard Expected Error Logging

Line 8961: -- Standard Expected Error Logging

8957: -- Standard End of Procedure/Function Logging
8958: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8959: EXCEPTION
8960: WHEN L_FND_EXC_ERROR THEN
8961: -- Standard Expected Error Logging
8962: INL_LOGGING_PVT.Log_ExpecError (
8963: p_module_name => g_module_name,
8964: p_procedure_name => l_api_name) ;
8965: ROLLBACK TO Adjust_ChargeLines_PVT;

Line 8971: -- Standard Unexpected Error Logging

8967: FND_MSG_PUB.Count_And_Get (
8968: p_encoded => L_FND_FALSE,
8969: p_count => x_msg_count, p_data => x_msg_data) ;
8970: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
8971: -- Standard Unexpected Error Logging
8972: INL_LOGGING_PVT.Log_UnexpecError (
8973: p_module_name => g_module_name,
8974: p_procedure_name => l_api_name) ;
8975: ROLLBACK TO Adjust_ChargeLines_PVT;

Line 8982: -- Standard Unexpected Error Logging

8978: p_encoded => L_FND_FALSE,
8979: p_count => x_msg_count,
8980: p_data => x_msg_data) ;
8981: WHEN OTHERS THEN
8982: -- Standard Unexpected Error Logging
8983: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name, p_procedure_name => l_api_name) ;
8984: ROLLBACK TO Adjust_ChargeLines_PVT;
8985: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
8986: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

9048: l_ship_line_id NUMBER;
9049: l_new_tax_line_id NUMBER;
9050: l_garb NUMBER ; --BUG#8468830
9051: BEGIN
9052: -- Standard Beginning of Procedure/Function Logging
9053: INL_LOGGING_PVT.Log_BeginProc (
9054: p_module_name => g_module_name,
9055: p_procedure_name => l_api_name) ;
9056: -- Standard Start of API savepoint

Line 9056: -- Standard Start of API savepoint

9052: -- Standard Beginning of Procedure/Function Logging
9053: INL_LOGGING_PVT.Log_BeginProc (
9054: p_module_name => g_module_name,
9055: p_procedure_name => l_api_name) ;
9056: -- Standard Start of API savepoint
9057: SAVEPOINT Adjust_TaxLines_PVT;
9058: -- Initialize message list if p_init_msg_list is set to TRUE.
9059: IF FND_API.to_Boolean (p_init_msg_list) THEN
9060: FND_MSG_PUB.initialize;

Line 9221: -- Standard check of p_commit.

9217: RAISE L_FND_EXC_UNEXPECTED_ERROR;
9218: END IF;
9219: -- The estimated tax lines will made = 0 when as actual arrived on associated line
9220: -- i.e. when a charge became and actual value the estimated taxes will made 0 too
9221: -- Standard check of p_commit.
9222: IF FND_API.To_Boolean (p_commit) THEN
9223: COMMIT WORK;
9224: END IF;
9225: -- Standard call to get message count and if count is 1, get message info.

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

9221: -- Standard check of p_commit.
9222: IF FND_API.To_Boolean (p_commit) THEN
9223: COMMIT WORK;
9224: END IF;
9225: -- Standard call to get message count and if count is 1, get message info.
9226: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
9227: -- Standard End of Procedure/Function Logging
9228: INL_LOGGING_PVT.Log_EndProc (
9229: p_module_name => g_module_name,

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

9223: COMMIT WORK;
9224: END IF;
9225: -- Standard call to get message count and if count is 1, get message info.
9226: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
9227: -- Standard End of Procedure/Function Logging
9228: INL_LOGGING_PVT.Log_EndProc (
9229: p_module_name => g_module_name,
9230: p_procedure_name => l_api_name) ;
9231: EXCEPTION

Line 9233: -- Standard Expected Error Logging

9229: p_module_name => g_module_name,
9230: p_procedure_name => l_api_name) ;
9231: EXCEPTION
9232: WHEN L_FND_EXC_ERROR THEN
9233: -- Standard Expected Error Logging
9234: INL_LOGGING_PVT.Log_ExpecError (
9235: p_module_name => g_module_name,
9236: p_procedure_name => l_api_name) ;
9237: ROLLBACK TO Adjust_TaxLines_PVT;

Line 9243: -- Standard Unexpected Error Logging

9239: FND_MSG_PUB.Count_And_Get (
9240: p_encoded => L_FND_FALSE,
9241: p_count => x_msg_count, p_data => x_msg_data) ;
9242: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
9243: -- Standard Unexpected Error Logging
9244: INL_LOGGING_PVT.Log_UnexpecError (
9245: p_module_name => g_module_name,
9246: p_procedure_name => l_api_name) ;
9247: ROLLBACK TO Adjust_TaxLines_PVT;

Line 9254: -- Standard Unexpected Error Logging

9250: p_encoded => L_FND_FALSE,
9251: p_count => x_msg_count,
9252: p_data => x_msg_data) ;
9253: WHEN OTHERS THEN
9254: -- Standard Unexpected Error Logging
9255: INL_LOGGING_PVT.Log_UnexpecError (
9256: p_module_name => g_module_name,
9257: p_procedure_name => l_api_name) ;
9258: ROLLBACK TO Adjust_TaxLines_PVT;

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

9321: l_prev_match_amount_id NUMBER;
9322: l_count_new_matches NUMBER;
9323: l_garb NUMBER ; --BUG#8468830
9324: BEGIN
9325: -- Standard Beginning of Procedure/Function Logging
9326: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
9327: -- Standard Start of API savepoint
9328: SAVEPOINT Adjust_TaxLines_2_PVT;
9329: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 9327: -- Standard Start of API savepoint

9323: l_garb NUMBER ; --BUG#8468830
9324: BEGIN
9325: -- Standard Beginning of Procedure/Function Logging
9326: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
9327: -- Standard Start of API savepoint
9328: SAVEPOINT Adjust_TaxLines_2_PVT;
9329: -- Initialize message list if p_init_msg_list is set to TRUE.
9330: IF FND_API.to_Boolean (p_init_msg_list) THEN
9331: FND_MSG_PUB.initialize;

Line 9627: -- Standard check of p_commit.

9623: END IF;
9624: END IF;
9625: -- The estimated tax lines will made = 0 when as actual arrived on associated line
9626: -- i.e. when a charge became and actual value the estimated taxes will made 0 too
9627: -- Standard check of p_commit.
9628: IF FND_API.To_Boolean (p_commit) THEN
9629: COMMIT WORK;
9630: END IF;
9631: -- Standard call to get message count and if count is 1, get message info.

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

9627: -- Standard check of p_commit.
9628: IF FND_API.To_Boolean (p_commit) THEN
9629: COMMIT WORK;
9630: END IF;
9631: -- Standard call to get message count and if count is 1, get message info.
9632: FND_MSG_PUB.Count_And_Get (
9633: p_encoded => L_FND_FALSE,
9634: p_count => x_msg_count,
9635: p_data => x_msg_data) ;

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

9632: FND_MSG_PUB.Count_And_Get (
9633: p_encoded => L_FND_FALSE,
9634: p_count => x_msg_count,
9635: p_data => x_msg_data) ;
9636: -- Standard End of Procedure/Function Logging
9637: INL_LOGGING_PVT.Log_EndProc (
9638: p_module_name => g_module_name,
9639: p_procedure_name => l_api_name) ;
9640: EXCEPTION

Line 9642: -- Standard Expected Error Logging

9638: p_module_name => g_module_name,
9639: p_procedure_name => l_api_name) ;
9640: EXCEPTION
9641: WHEN L_FND_EXC_ERROR THEN
9642: -- Standard Expected Error Logging
9643: INL_LOGGING_PVT.Log_ExpecError (
9644: p_module_name => g_module_name,
9645: p_procedure_name => l_api_name) ;
9646: ROLLBACK TO Adjust_TaxLines_2_PVT;

Line 9653: -- Standard Unexpected Error Logging

9649: p_encoded => L_FND_FALSE,
9650: p_count => x_msg_count,
9651: p_data => x_msg_data) ;
9652: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
9653: -- Standard Unexpected Error Logging
9654: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
9655: ROLLBACK TO Adjust_TaxLines_2_PVT;
9656: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
9657: FND_MSG_PUB.Count_And_Get (

Line 9662: -- Standard Unexpected Error Logging

9658: p_encoded => L_FND_FALSE,
9659: p_count => x_msg_count,
9660: p_data => x_msg_data) ;
9661: WHEN OTHERS THEN
9662: -- Standard Unexpected Error Logging
9663: INL_LOGGING_PVT.Log_UnexpecError (
9664: p_module_name => g_module_name,
9665: p_procedure_name => l_api_name) ;
9666: ROLLBACK TO Adjust_TaxLines_2_PVT;

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

9804: l_match_ship_header_id_ind NUMBER :=0 ;
9805: l_adj_group_date_ant DATE; --OPM Integration
9806: l_adj_group_date DATE; --dependence
9807: BEGIN
9808: -- Standard Beginning of Procedure/Function Logging
9809: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
9810: -- Standard Start of API savepoint
9811: SAVEPOINT Adjust_Lines_PVT;
9812: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 9810: -- Standard Start of API savepoint

9806: l_adj_group_date DATE; --dependence
9807: BEGIN
9808: -- Standard Beginning of Procedure/Function Logging
9809: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
9810: -- Standard Start of API savepoint
9811: SAVEPOINT Adjust_Lines_PVT;
9812: -- Initialize message list if p_init_msg_list is set to TRUE.
9813: IF FND_API.to_Boolean (p_init_msg_list) THEN
9814: FND_MSG_PUB.initialize;

Line 10284: -- Standard check of p_commit.

10280: END IF;
10281: END IF;
10282: END;
10283: -- End of API Body
10284: -- Standard check of p_commit.
10285: IF FND_API.To_Boolean (p_commit) THEN
10286: COMMIT WORK;
10287: END IF;
10288: -- Standard call to get message count and if count is 1, get message info.

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

10284: -- Standard check of p_commit.
10285: IF FND_API.To_Boolean (p_commit) THEN
10286: COMMIT WORK;
10287: END IF;
10288: -- Standard call to get message count and if count is 1, get message info.
10289: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
10290: -- Standard End of Procedure/Function Logging
10291: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
10292: EXCEPTION

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

10286: COMMIT WORK;
10287: END IF;
10288: -- Standard call to get message count and if count is 1, get message info.
10289: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
10290: -- Standard End of Procedure/Function Logging
10291: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
10292: EXCEPTION
10293: WHEN L_FND_EXC_ERROR THEN
10294: -- Standard Expected Error Logging

Line 10294: -- Standard Expected Error Logging

10290: -- Standard End of Procedure/Function Logging
10291: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
10292: EXCEPTION
10293: WHEN L_FND_EXC_ERROR THEN
10294: -- Standard Expected Error Logging
10295: INL_LOGGING_PVT.Log_ExpecError (
10296: p_module_name => g_module_name,
10297: p_procedure_name => l_api_name) ;
10298: ROLLBACK TO Adjust_Lines_PVT;

Line 10305: -- Standard Unexpected Error Logging

10301: p_encoded => L_FND_FALSE,
10302: p_count => x_msg_count,
10303: p_data => x_msg_data) ;
10304: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
10305: -- Standard Unexpected Error Logging
10306: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
10307: ROLLBACK TO Adjust_Lines_PVT;
10308: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
10309: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;

Line 10311: -- Standard Unexpected Error Logging

10307: ROLLBACK TO Adjust_Lines_PVT;
10308: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
10309: FND_MSG_PUB.Count_And_Get ( p_encoded => L_FND_FALSE, p_count => x_msg_count, p_data => x_msg_data) ;
10310: WHEN OTHERS THEN
10311: -- Standard Unexpected Error Logging
10312: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
10313: ROLLBACK TO Adjust_Lines_PVT;
10314: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;
10315: IF FND_MSG_PUB.Check_Msg_Level (

Line 10367: -- Standard Start of API savepoint

10363:
10364: BEGIN
10365: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
10366: p_procedure_name => l_api_name);
10367: -- Standard Start of API savepoint
10368: SAVEPOINT Get_1aryQty_PVT;
10369: -- Initialize message list if p_init_msg_list is set to TRUE.
10370: IF FND_API.to_Boolean (p_init_msg_list) THEN
10371: FND_MSG_PUB.initialize;

Line 10465: -- Standard check of p_commit.

10461: p_var_name => 'x_1ary_qty',
10462: p_var_value => x_1ary_qty) ;
10463: END IF;
10464:
10465: -- Standard check of p_commit.
10466: IF FND_API.To_Boolean (p_commit) THEN
10467: COMMIT WORK;
10468: END IF;
10469: -- Standard call to get message count and if count is 1, get message info.

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

10465: -- Standard check of p_commit.
10466: IF FND_API.To_Boolean (p_commit) THEN
10467: COMMIT WORK;
10468: END IF;
10469: -- Standard call to get message count and if count is 1, get message info.
10470: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
10471: p_count => x_msg_count,
10472: p_data => x_msg_data) ;
10473: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,

Line 10544: -- Standard Start of API savepoint

10540:
10541: BEGIN
10542: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
10543: p_procedure_name => l_api_name);
10544: -- Standard Start of API savepoint
10545: SAVEPOINT Get_2aryQty_PVT;
10546: -- Initialize message list if p_init_msg_list is set to TRUE.
10547: IF FND_API.to_Boolean (p_init_msg_list) THEN
10548: FND_MSG_PUB.initialize;

Line 10645: -- Standard check of p_commit.

10641: p_var_name => 'x_2ary_qty',
10642: p_var_value => x_2ary_qty) ;
10643: END IF;
10644:
10645: -- Standard check of p_commit.
10646: IF FND_API.To_Boolean (p_commit) THEN
10647: COMMIT WORK;
10648: END IF;
10649: -- Standard call to get message count and if count is 1, get message info.

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

10645: -- Standard check of p_commit.
10646: IF FND_API.To_Boolean (p_commit) THEN
10647: COMMIT WORK;
10648: END IF;
10649: -- Standard call to get message count and if count is 1, get message info.
10650: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
10651: p_count => x_msg_count,
10652: p_data => x_msg_data) ;
10653: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,

Line 10741: -- Standard Start of API savepoint

10737: BEGIN
10738: INL_LOGGING_PVT.Log_BeginProc (
10739: p_module_name => g_module_name,
10740: p_procedure_name => l_api_name) ;
10741: -- Standard Start of API savepoint
10742: SAVEPOINT Get_1ary2aryQty_PVT;
10743: -- Initialize message list if p_init_msg_list is set to TRUE.
10744: IF FND_API.to_Boolean (p_init_msg_list) THEN
10745: FND_MSG_PUB.initialize;

Line 10966: -- Standard check of p_commit.

10962: p_var_value => x_2ary_qty) ;
10963: END IF;
10964: --==========
10965: */
10966: -- Standard check of p_commit.
10967: IF FND_API.To_Boolean (p_commit) THEN
10968: COMMIT WORK;
10969: END IF;
10970: -- Standard call to get message count and if count is 1, get message info.

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

10966: -- Standard check of p_commit.
10967: IF FND_API.To_Boolean (p_commit) THEN
10968: COMMIT WORK;
10969: END IF;
10970: -- Standard call to get message count and if count is 1, get message info.
10971: FND_MSG_PUB.Count_And_Get (
10972: p_encoded => L_FND_FALSE,
10973: p_count => x_msg_count,
10974: p_data => x_msg_data) ;

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

11025: l_available_qty NUMBER;
11026: l_tolerable_quantity NUMBER;
11027: l_unit_of_measure VARCHAR2(30);
11028: BEGIN
11029: -- Standard Beginning of Procedure/Function Logging
11030: INL_LOGGING_PVT.Log_BeginProc (
11031: p_module_name => g_module_name,
11032: p_procedure_name => l_program_name) ;
11033: -- Logging variables

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

11073: p_module_name => g_module_name,
11074: p_procedure_name => l_program_name,
11075: p_var_name => 'l_unit_of_measure',
11076: p_var_value => l_unit_of_measure) ;
11077: -- Standard End of Procedure/Function Logging
11078: INL_LOGGING_PVT.Log_EndProc (
11079: p_module_name => g_module_name,
11080: p_procedure_name => l_program_name) ;
11081: RETURN NVL(l_available_qty,0);

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

11165: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -00054);
11166:
11167: BEGIN
11168:
11169: -- Standard Beginning of Procedure/Function Logging
11170: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
11171: p_procedure_name => l_program_name) ;
11172: -- Standard Start of API savepoint
11173: SAVEPOINT Adjust_ELCLines_PVT;

Line 11172: -- Standard Start of API savepoint

11168:
11169: -- Standard Beginning of Procedure/Function Logging
11170: INL_LOGGING_PVT.Log_BeginProc(p_module_name => g_module_name,
11171: p_procedure_name => l_program_name) ;
11172: -- Standard Start of API savepoint
11173: SAVEPOINT Adjust_ELCLines_PVT;
11174: -- Initialize message list if p_init_msg_list is set to TRUE.
11175: IF FND_API.to_Boolean (p_init_msg_list) THEN
11176: FND_MSG_PUB.initialize;

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

11866:
11867: IF FND_API.To_Boolean (p_commit) THEN
11868: COMMIT WORK;
11869: END IF;
11870: -- Standard call to get message count and if count is 1, get message info.
11871: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
11872: p_count => x_msg_count,
11873: p_data => x_msg_data) ;
11874: -- Standard End of Procedure/Function Logging

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

11870: -- Standard call to get message count and if count is 1, get message info.
11871: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
11872: p_count => x_msg_count,
11873: p_data => x_msg_data) ;
11874: -- Standard End of Procedure/Function Logging
11875: INL_LOGGING_PVT.Log_EndProc (
11876: p_module_name => g_module_name,
11877: p_procedure_name => l_program_name);
11878:

Line 11885: -- Standard Expected Error Logging

11881: WHEN RESOURCE_BUSY THEN
11882: x_return_status := FND_API.g_ret_sts_error;
11883: FND_MESSAGE.set_name('INL','INL_CANNOT_EXEC_ELC_SUBMIT_LCK');
11884: FND_MSG_PUB.ADD;
11885: -- Standard Expected Error Logging
11886: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,
11887: p_procedure_name => l_program_name);
11888: ROLLBACK TO Adjust_ELCLines_PVT;
11889: x_return_status := L_FND_RET_STS_ERROR;

Line 11894: -- Standard Expected Error Logging

11890: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
11891: p_count => x_msg_count,
11892: p_data => x_msg_data);
11893: WHEN L_FND_EXC_ERROR THEN
11894: -- Standard Expected Error Logging
11895: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,
11896: p_procedure_name => l_program_name) ;
11897: ROLLBACK TO Adjust_ELCLines_PVT;
11898: x_return_status := L_FND_RET_STS_ERROR;

Line 11903: -- Standard Unexpected Error Logging

11899: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
11900: p_count => x_msg_count,
11901: p_data => x_msg_data) ;
11902: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
11903: -- Standard Unexpected Error Logging
11904: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
11905: p_procedure_name => l_program_name) ;
11906: ROLLBACK TO Adjust_ELCLines_PVT;
11907: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 11912: -- Standard Unexpected Error Logging

11908: FND_MSG_PUB.Count_And_Get(p_encoded => L_FND_FALSE,
11909: p_count => x_msg_count,
11910: p_data => x_msg_data) ;
11911: WHEN OTHERS THEN
11912: -- Standard Unexpected Error Logging
11913: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
11914: p_procedure_name => l_program_name) ;
11915: ROLLBACK TO Adjust_ELCLines_PVT;
11916: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;

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

11968: l_pending_update_flag VARCHAR2(1) ; -- SCM-051
11969: l_ship_num VARCHAR2(25); -- SCM-051
11970: l_rcv_running NUMBER; -- SCM-051
11971: BEGIN
11972: -- Standard Beginning of Procedure/Function Logging
11973: INL_LOGGING_PVT.Log_BeginProc (
11974: p_module_name => g_module_name,
11975: p_procedure_name => l_api_name) ;
11976: -- Standard Start of API savepoint

Line 11976: -- Standard Start of API savepoint

11972: -- Standard Beginning of Procedure/Function Logging
11973: INL_LOGGING_PVT.Log_BeginProc (
11974: p_module_name => g_module_name,
11975: p_procedure_name => l_api_name) ;
11976: -- Standard Start of API savepoint
11977: SAVEPOINT Run_Submit_PVT;
11978: -- Initialize message list if p_init_msg_list is set to TRUE.
11979: IF FND_API.to_Boolean (p_init_msg_list) THEN
11980: FND_MSG_PUB.initialize;

Line 12283: -- Standard check of p_commit.

12279: RAISE L_FND_EXC_ERROR;
12280: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
12281: RAISE L_FND_EXC_UNEXPECTED_ERROR;
12282: END IF;
12283: -- Standard check of p_commit.
12284: IF FND_API.To_Boolean (p_commit) THEN
12285: COMMIT WORK;
12286: END IF;
12287: -- Standard call to get message count and if count is 1, get message info.

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

12283: -- Standard check of p_commit.
12284: IF FND_API.To_Boolean (p_commit) THEN
12285: COMMIT WORK;
12286: END IF;
12287: -- Standard call to get message count and if count is 1, get message info.
12288: FND_MSG_PUB.Count_And_Get (
12289: p_encoded => L_FND_FALSE,
12290: p_count => x_msg_count,
12291: p_data => x_msg_data

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

12289: p_encoded => L_FND_FALSE,
12290: p_count => x_msg_count,
12291: p_data => x_msg_data
12292: ) ;
12293: -- Standard End of Procedure/Function Logging
12294: INL_LOGGING_PVT.Log_EndProc (
12295: p_module_name => g_module_name,
12296: p_procedure_name => l_api_name
12297: ) ;

Line 12300: -- Standard Expected Error Logging

12296: p_procedure_name => l_api_name
12297: ) ;
12298: EXCEPTION
12299: WHEN L_FND_EXC_ERROR THEN
12300: -- Standard Expected Error Logging
12301: INL_LOGGING_PVT.Log_ExpecError (
12302: p_module_name => g_module_name,
12303: p_procedure_name => l_api_name
12304: ) ;

Line 12313: -- Standard Unexpected Error Logging

12309: p_count => x_msg_count,
12310: p_data => x_msg_data
12311: ) ;
12312: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
12313: -- Standard Unexpected Error Logging
12314: INL_LOGGING_PVT.Log_UnexpecError (
12315: p_module_name => g_module_name,
12316: p_procedure_name => l_api_name
12317: ) ;

Line 12326: -- Standard Unexpected Error Logging

12322: p_count => x_msg_count,
12323: p_data => x_msg_data
12324: ) ;
12325: WHEN OTHERS THEN
12326: -- Standard Unexpected Error Logging
12327: INL_LOGGING_PVT.Log_UnexpecError (
12328: p_module_name => g_module_name,
12329: p_procedure_name => l_api_name
12330: ) ;

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

12405: -- Init conc. parameters
12406: errbuf := NULL;
12407: retcode := 0;
12408:
12409: -- Standard Beginning of Procedure/Function Logging
12410: INL_LOGGING_PVT.Log_BeginProc (
12411: p_module_name => g_module_name,
12412: p_procedure_name => l_program_name) ;
12413:

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

12631: mo_global.set_policy_context( l_previous_access_mode, l_previous_org_id);
12632: END IF;
12633: --Bug#10381495
12634:
12635: -- Standard End of Procedure/Function Logging
12636: INL_LOGGING_PVT.Log_EndProc (
12637: p_module_name => g_module_name,
12638: p_procedure_name => l_program_name) ;
12639: EXCEPTION

Line 12641: -- Standard Expected Error Logging

12637: p_module_name => g_module_name,
12638: p_procedure_name => l_program_name) ;
12639: EXCEPTION
12640: WHEN L_FND_EXC_ERROR THEN
12641: -- Standard Expected Error Logging
12642: INL_LOGGING_PVT.Log_ExpecError (
12643: p_module_name => g_module_name,
12644: p_procedure_name => l_program_name) ;
12645: --Bug#10381495

Line 12658: -- Standard Unexpected Error Logging

12654: --Bug#10381495
12655: retcode := 1;
12656: errbuf := errbuf ||' G_EXC_ERROR '||SQLERRM;
12657: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
12658: -- Standard Unexpected Error Logging
12659: INL_LOGGING_PVT.Log_UnexpecError (
12660: p_module_name => g_module_name,
12661: p_procedure_name => l_program_name) ;
12662: --Bug#10381495

Line 12675: -- Standard Unexpected Error Logging

12671: --Bug#10381495
12672: retcode := 2;
12673: errbuf := errbuf ||' G_EXC_UNEXPECTED_ERROR '||SQLERRM;
12674: WHEN OTHERS THEN
12675: -- Standard Unexpected Error Logging
12676: INL_LOGGING_PVT.Log_UnexpecError (
12677: p_module_name => g_module_name,
12678: p_procedure_name => l_program_name) ;
12679: --Bug#10381495

Line 12733: -- Standard Expected Error Logging

12729: p_procedure_name => l_program_name
12730: ) ;
12731: EXCEPTION
12732: WHEN L_FND_EXC_ERROR THEN
12733: -- Standard Expected Error Logging
12734: INL_LOGGING_PVT.Log_ExpecError (
12735: p_module_name => g_module_name,
12736: p_procedure_name => l_program_name
12737: ) ;

Line 12740: -- Standard Unexpected Error Logging

12736: p_procedure_name => l_program_name
12737: ) ;
12738: x_return_status := L_FND_RET_STS_ERROR;
12739: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
12740: -- Standard Unexpected Error Logging
12741: INL_LOGGING_PVT.Log_UnexpecError (
12742: p_module_name => g_module_name,
12743: p_procedure_name => l_program_name
12744: ) ;

Line 12747: -- Standard Unexpected Error Logging

12743: p_procedure_name => l_program_name
12744: ) ;
12745: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
12746: WHEN OTHERS THEN
12747: -- Standard Unexpected Error Logging
12748: INL_LOGGING_PVT.Log_UnexpecError (
12749: p_module_name => g_module_name,
12750: p_procedure_name => l_program_name
12751: ) ;

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

12807: AND a.from_parent_table_id = p_charge_line_id
12808: AND a.ship_header_id <> p_ship_header_id;
12809: r_affected_ship c_affected_ship%ROWTYPE;
12810: BEGIN
12811: -- Standard Beginning of Procedure/Function Logging
12812: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
12813: -- Standard Start of API savepoint
12814: SAVEPOINT Delete_ChargeAssoc_PVT;
12815: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 12813: -- Standard Start of API savepoint

12809: r_affected_ship c_affected_ship%ROWTYPE;
12810: BEGIN
12811: -- Standard Beginning of Procedure/Function Logging
12812: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name, p_procedure_name => l_api_name) ;
12813: -- Standard Start of API savepoint
12814: SAVEPOINT Delete_ChargeAssoc_PVT;
12815: -- Initialize message list if p_init_msg_list is set to TRUE.
12816: IF FND_API.to_Boolean (p_init_msg_list) THEN
12817: FND_MSG_PUB.initialize;

Line 12856: -- Standard check of p_commit.

12852: END IF;
12853: END LOOP;
12854: CLOSE c_affected_ship;
12855: END;
12856: -- Standard check of p_commit.
12857: IF FND_API.To_Boolean (p_commit) THEN
12858: COMMIT WORK;
12859: END IF;
12860: -- Standard call to get message count and if count is 1, get message info.

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

12856: -- Standard check of p_commit.
12857: IF FND_API.To_Boolean (p_commit) THEN
12858: COMMIT WORK;
12859: END IF;
12860: -- Standard call to get message count and if count is 1, get message info.
12861: FND_MSG_PUB.Count_And_Get (
12862: p_encoded => L_FND_FALSE,
12863: p_count => x_msg_count,
12864: p_data => x_msg_data) ;

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

12861: FND_MSG_PUB.Count_And_Get (
12862: p_encoded => L_FND_FALSE,
12863: p_count => x_msg_count,
12864: p_data => x_msg_data) ;
12865: -- Standard End of Procedure/Function Logging
12866: INL_LOGGING_PVT.Log_EndProc (
12867: p_module_name => g_module_name,
12868: p_procedure_name => l_api_name) ;
12869: EXCEPTION

Line 12871: -- Standard Expected Error Logging

12867: p_module_name => g_module_name,
12868: p_procedure_name => l_api_name) ;
12869: EXCEPTION
12870: WHEN L_FND_EXC_ERROR THEN
12871: -- Standard Expected Error Logging
12872: INL_LOGGING_PVT.Log_ExpecError (
12873: p_module_name => g_module_name,
12874: p_procedure_name => l_api_name) ;
12875: ROLLBACK TO Delete_ChargeAssoc_PVT;

Line 12882: -- Standard Unexpected Error Logging

12878: p_encoded => L_FND_FALSE,
12879: p_count => x_msg_count,
12880: p_data => x_msg_data) ;
12881: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
12882: -- Standard Unexpected Error Logging
12883: INL_LOGGING_PVT.Log_UnexpecError (
12884: p_module_name => g_module_name,
12885: p_procedure_name => l_api_name) ;
12886: ROLLBACK TO Delete_ChargeAssoc_PVT;

Line 12893: -- Standard Unexpected Error Logging

12889: p_encoded => L_FND_FALSE,
12890: p_count => x_msg_count,
12891: p_data => x_msg_data) ;
12892: WHEN OTHERS THEN
12893: -- Standard Unexpected Error Logging
12894: INL_LOGGING_PVT.Log_UnexpecError (
12895: p_module_name => g_module_name,
12896: p_procedure_name => l_api_name) ;
12897: ROLLBACK TO Delete_ChargeAssoc_PVT;

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

12937: l_nrec_tax_amt NUMBER;
12938:
12939: BEGIN
12940:
12941: -- Standard Beginning of Procedure/Function Logging
12942: INL_LOGGING_PVT.Log_BeginProc (
12943: p_module_name => g_module_name,
12944: p_procedure_name => l_program_name) ;
12945: -- Logging variables

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

13012: p_procedure_name => l_program_name,
13013: p_var_name => 'l_nrec_tax_amt',
13014: p_var_value => l_nrec_tax_amt) ;
13015:
13016: -- Standard End of Procedure/Function Logging
13017: INL_LOGGING_PVT.Log_EndProc (
13018: p_module_name => g_module_name,
13019: p_procedure_name => l_program_name) ;
13020: RETURN l_nrec_tax_amt;

Line 13023: -- Standard Unexpected Error Logging

13019: p_procedure_name => l_program_name) ;
13020: RETURN l_nrec_tax_amt;
13021: EXCEPTION
13022: WHEN OTHERS THEN
13023: -- Standard Unexpected Error Logging
13024: INL_LOGGING_PVT.Log_UnexpecError (
13025: p_module_name => g_module_name,
13026: p_procedure_name => l_program_name) ;
13027: IF FND_MSG_PUB.Check_Msg_Level (

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

13062: l_matched_charge_amt NUMBER;
13063:
13064: BEGIN
13065:
13066: -- Standard Beginning of Procedure/Function Logging
13067: INL_LOGGING_PVT.Log_BeginProc (
13068: p_module_name => g_module_name,
13069: p_procedure_name => l_program_name) ;
13070: -- Logging variables

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

13131: p_procedure_name => l_program_name,
13132: p_var_name => 'l_matched_charge_amt',
13133: p_var_value => l_matched_charge_amt) ;
13134:
13135: -- Standard End of Procedure/Function Logging
13136: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
13137: p_procedure_name => l_program_name) ;
13138: RETURN l_matched_charge_amt;
13139: EXCEPTION

Line 13141: -- Standard Unexpected Error Logging

13137: p_procedure_name => l_program_name) ;
13138: RETURN l_matched_charge_amt;
13139: EXCEPTION
13140: WHEN OTHERS THEN
13141: -- Standard Unexpected Error Logging
13142: INL_LOGGING_PVT.Log_UnexpecError (
13143: p_module_name => g_module_name,
13144: p_procedure_name => l_program_name) ;
13145: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

13178: l_matched_item_amt NUMBER;
13179:
13180: BEGIN
13181:
13182: -- Standard Beginning of Procedure/Function Logging
13183: INL_LOGGING_PVT.Log_BeginProc (
13184: p_module_name => g_module_name,
13185: p_procedure_name => l_program_name) ;
13186: -- Logging variables

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

13241: p_procedure_name => l_program_name,
13242: p_var_name => 'l_matched_item_amt',
13243: p_var_value => l_matched_item_amt) ;
13244:
13245: -- Standard End of Procedure/Function Logging
13246: INL_LOGGING_PVT.Log_EndProc (
13247: p_module_name => g_module_name,
13248: p_procedure_name => l_program_name) ;
13249: RETURN l_matched_item_amt;

Line 13252: -- Standard Unexpected Error Logging

13248: p_procedure_name => l_program_name) ;
13249: RETURN l_matched_item_amt;
13250: EXCEPTION
13251: WHEN OTHERS THEN
13252: -- Standard Unexpected Error Logging
13253: INL_LOGGING_PVT.Log_UnexpecError (
13254: p_module_name => g_module_name,
13255: p_procedure_name => l_program_name) ;
13256: IF FND_MSG_PUB.Check_Msg_Level (

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

13299: l_match_type_code VARCHAR2(15);
13300:
13301: BEGIN
13302:
13303: -- Standard Beginning of Procedure/Function Logging
13304: INL_LOGGING_PVT.Log_BeginProc (
13305: p_module_name => g_module_name,
13306: p_procedure_name => l_program_name) ;
13307: -- Logging variables

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

13403: p_procedure_name => l_program_name,
13404: p_var_name => 'l_matched_amt',
13405: p_var_value => l_matched_amt) ;
13406:
13407: -- Standard End of Procedure/Function Logging
13408: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
13409: p_procedure_name => l_program_name) ;
13410: RETURN l_matched_amt;
13411: EXCEPTION

Line 13413: -- Standard Unexpected Error Logging

13409: p_procedure_name => l_program_name) ;
13410: RETURN l_matched_amt;
13411: EXCEPTION
13412: WHEN OTHERS THEN
13413: -- Standard Unexpected Error Logging
13414: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
13415: p_procedure_name => l_program_name) ;
13416: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13417: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,

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

13449: l_program_name CONSTANT VARCHAR2(30) := 'Get_LastUpdateDateForShip';
13450: l_debug_info VARCHAR2(200);
13451:
13452: BEGIN
13453: -- Standard Beginning of Procedure/Function Logging
13454: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
13455: p_procedure_name => l_program_name) ;
13456: -- Logging variables
13457: INL_LOGGING_PVT.Log_Variable ( p_module_name => g_module_name,

Line 13503: -- Standard Unexpected Error Logging

13499: RETURN(ship_last_update_date);
13500:
13501: EXCEPTION
13502: WHEN OTHERS THEN
13503: -- Standard Unexpected Error Logging
13504: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
13505: p_procedure_name => l_program_name) ;
13506: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
13507: FND_MSG_PUB.Add_Exc_Msg ( p_pkg_name => g_pkg_name,

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

13557: l_error_message VARCHAR2(2000);
13558: l_item VARCHAR2(40); -- Bug #15927464
13559:
13560: BEGIN
13561: -- Standard Beginning of Procedure/Function Logging
13562: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
13563: p_procedure_name => l_api_name);
13564: -- Initialize message list if p_init_msg_list is set to TRUE.
13565: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 13644: -- Standard check of p_commit.

13640: END IF;
13641: END IF;
13642: -- Bug 15827165
13643:
13644: -- Standard check of p_commit.
13645: IF FND_API.To_Boolean (p_commit) THEN
13646: COMMIT WORK;
13647: END IF;
13648: -- Standard call to get message count and if count is 1, get message info.

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

13644: -- Standard check of p_commit.
13645: IF FND_API.To_Boolean (p_commit) THEN
13646: COMMIT WORK;
13647: END IF;
13648: -- Standard call to get message count and if count is 1, get message info.
13649: FND_MSG_PUB.Count_And_Get (
13650: p_encoded => L_FND_FALSE,
13651: p_count => x_msg_count,
13652: p_data => x_msg_data) ;

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

13649: FND_MSG_PUB.Count_And_Get (
13650: p_encoded => L_FND_FALSE,
13651: p_count => x_msg_count,
13652: p_data => x_msg_data) ;
13653: -- Standard End of Procedure/Function Logging
13654: INL_LOGGING_PVT.Log_EndProc (
13655: p_module_name => g_module_name,
13656: p_procedure_name => l_api_name) ;
13657: EXCEPTION

Line 13659: -- Standard Expected Error Logging

13655: p_module_name => g_module_name,
13656: p_procedure_name => l_api_name) ;
13657: EXCEPTION
13658: WHEN L_FND_EXC_ERROR THEN
13659: -- Standard Expected Error Logging
13660: INL_LOGGING_PVT.Log_ExpecError (
13661: p_module_name => g_module_name,
13662: p_procedure_name => l_api_name) ;
13663: x_return_status := L_FND_RET_STS_ERROR;

Line 13669: -- Standard Unexpected Error Logging

13665: p_encoded => L_FND_FALSE,
13666: p_count => x_msg_count,
13667: p_data => x_msg_data) ;
13668: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
13669: -- Standard Unexpected Error Logging
13670: INL_LOGGING_PVT.Log_UnexpecError (
13671: p_module_name => g_module_name,
13672: p_procedure_name => l_api_name) ;
13673: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 13679: -- Standard Unexpected Error Logging

13675: p_encoded => L_FND_FALSE,
13676: p_count => x_msg_count,
13677: p_data => x_msg_data) ;
13678: WHEN OTHERS THEN
13679: -- Standard Unexpected Error Logging
13680: INL_LOGGING_PVT.Log_UnexpecError (
13681: p_module_name => g_module_name,
13682: p_procedure_name => l_api_name) ;
13683: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;

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

13724: l_lot_number VARCHAR2(30);
13725: l_converted_qty NUMBER;
13726:
13727: BEGIN
13728: -- Standard Beginning of Procedure/Function Logging
13729: INL_LOGGING_PVT.Log_BeginProc (
13730: p_module_name => g_module_name,
13731: p_procedure_name => l_func_name) ;
13732: -- Logging variables

Line 13842: -- Standard Unexpected Error Logging

13838: END IF;
13839: RETURN l_converted_qty;
13840: EXCEPTION
13841: WHEN OTHERS THEN
13842: -- Standard Unexpected Error Logging
13843: INL_LOGGING_PVT.Log_UnexpecError (
13844: p_module_name => g_module_name,
13845: p_procedure_name => l_func_name) ;
13846: IF FND_MSG_PUB.Check_Msg_Level (

Line 13929: -- Standard Start of API savepoint

13925: BEGIN
13926: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
13927: p_procedure_name => l_program_name) ;
13928:
13929: -- Standard Start of API savepoint
13930: SAVEPOINT Discard_Updates_PVT;
13931:
13932: -- Initialize message list if p_init_msg_list is set to TRUE.
13933: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 14113: -- Standard check of p_commit.

14109: x_return_status := l_return_status;
14110: RAISE L_FND_EXC_UNEXPECTED_ERROR;
14111: END IF;
14112:
14113: -- Standard check of p_commit.
14114: IF FND_API.To_Boolean (p_commit) THEN
14115: COMMIT WORK;
14116: END IF;
14117:

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

14114: IF FND_API.To_Boolean (p_commit) THEN
14115: COMMIT WORK;
14116: END IF;
14117:
14118: -- Standard call to get message count and if count is 1, get message info.
14119: FND_MSG_PUB.Count_And_Get (p_encoded => L_FND_FALSE,
14120: p_count => x_msg_count,
14121: p_data => x_msg_data);
14122: