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_LANDEDCOST_PVT dependencies on INL_LOGGING_PVT

Line 32: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,

28: l_in_loop BOOLEAN;
29:
30: BEGIN
31:
32: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
33: p_procedure_name => l_function_name);
34:
35: --
36: -- Initialize return status to SUCCESS

Line 41: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

37: --
38: x_return_status := FND_API.G_RET_STS_SUCCESS;
39:
40: l_debug_info := 'p_ship_header_id';
41: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
42: p_procedure_name => l_function_name,
43: p_var_name => l_debug_info,
44: p_var_value => TO_CHAR(p_ship_header_id));
45:

Line 47: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

43: p_var_name => l_debug_info,
44: p_var_value => TO_CHAR(p_ship_header_id));
45:
46: l_debug_info := 'p_from_parent_table_name';
47: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
48: p_procedure_name => l_function_name,
49: p_var_name => l_debug_info,
50: p_var_value => p_from_parent_table_name);
51:

Line 53: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

49: p_var_name => l_debug_info,
50: p_var_value => p_from_parent_table_name);
51:
52: l_debug_info := 'p_from_parent_table_id';
53: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
54: p_procedure_name => l_function_name,
55: p_var_name => l_debug_info,
56: p_var_value => TO_CHAR(p_from_parent_table_id));
57:

Line 74: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

70: WHEN LOOP_ERROR THEN
71: l_in_loop := TRUE;
72: END;
73:
74: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
75: p_procedure_name => l_function_name);
76:
77: IF l_in_loop THEN
78: RETURN TRUE;

Line 131: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,

127: l_primary_uom_class VARCHAR2(10);
128: l_concatenated_segments VARCHAR2(40);
129:
130: BEGIN
131: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
132: p_procedure_name => l_function_name);
133:
134: l_debug_info := 'p_unit_price';
135: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

Line 135: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

131: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
132: p_procedure_name => l_function_name);
133:
134: l_debug_info := 'p_unit_price';
135: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
136: p_procedure_name => l_function_name,
137: p_var_name => l_debug_info,
138: p_var_value => TO_CHAR(p_unit_price));
139:

Line 141: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

137: p_var_name => l_debug_info,
138: p_var_value => TO_CHAR(p_unit_price));
139:
140: l_debug_info := 'p_organization_id';
141: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
142: p_procedure_name => l_function_name,
143: p_var_name => l_debug_info,
144: p_var_value => TO_CHAR(p_organization_id));
145:

Line 147: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

143: p_var_name => l_debug_info,
144: p_var_value => TO_CHAR(p_organization_id));
145:
146: l_debug_info := 'p_inventory_item_id';
147: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
148: p_procedure_name => l_function_name,
149: p_var_name => l_debug_info,
150: p_var_value => TO_CHAR(p_inventory_item_id));
151:

Line 153: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

149: p_var_name => l_debug_info,
150: p_var_value => TO_CHAR(p_inventory_item_id));
151:
152: l_debug_info := 'p_from_uom_code';
153: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
154: p_procedure_name => l_function_name,
155: p_var_name => l_debug_info,
156: p_var_value => p_from_uom_code);
157:

Line 159: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

155: p_var_name => l_debug_info,
156: p_var_value => p_from_uom_code);
157:
158: l_debug_info := 'p_to_uom_code';
159: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
160: p_procedure_name => l_function_name,
161: p_var_name => l_debug_info,
162: p_var_value => p_to_uom_code);
163: SELECT msi.primary_uom_code,

Line 176: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

172: AND msi.organization_id = p_organization_id
173: AND msi.inventory_item_id = p_inventory_item_id;
174:
175: l_debug_info := 'l_primary_uom_code';
176: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
177: p_procedure_name => l_function_name,
178: p_var_name => l_debug_info,
179: p_var_value => l_primary_uom_code);
180: l_debug_info := 'l_primary_uom_class';

Line 181: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

177: p_procedure_name => l_function_name,
178: p_var_name => l_debug_info,
179: p_var_value => l_primary_uom_code);
180: l_debug_info := 'l_primary_uom_class';
181: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
182: p_procedure_name => l_function_name,
183: p_var_name => l_debug_info,
184: p_var_value => l_primary_uom_class);
185: l_debug_info := 'l_concatenated_segments';

Line 186: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

182: p_procedure_name => l_function_name,
183: p_var_name => l_debug_info,
184: p_var_value => l_primary_uom_class);
185: l_debug_info := 'l_concatenated_segments';
186: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
187: p_procedure_name => l_function_name,
188: p_var_name => l_debug_info,
189: p_var_value => l_concatenated_segments);
190:

Line 197: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

193: FROM mtl_units_of_measure
194: WHERE uom_code = p_from_uom_code;
195:
196: l_debug_info := 'l_from_uom_class';
197: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
198: p_procedure_name => l_function_name,
199: p_var_name => l_debug_info,
200: p_var_value => l_from_uom_class);
201: SELECT uom_class

Line 207: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

203: FROM mtl_units_of_measure
204: WHERE uom_code = p_to_uom_code;
205:
206: l_debug_info := 'l_to_uom_class';
207: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
208: p_procedure_name => l_function_name,
209: p_var_name => l_debug_info,
210: p_var_value => l_to_uom_class);
211:

Line 236: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

232: AND organization_id = p_organization_id
233: AND inventory_item_id = p_inventory_item_id;
234:
235: l_debug_info := 'l_converted_price';
236: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
237: p_procedure_name => l_function_name,
238: p_var_name => l_debug_info,
239: p_var_value => l_converted_price);
240: ELSE

Line 262: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

258: INTO l_converted_price
259: FROM dual;
260:
261: l_debug_info := 'l_converted_price';
262: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
263: p_procedure_name => l_function_name,
264: p_var_name => l_debug_info,
265: p_var_value => l_converted_price);
266: END IF;

Line 270: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

266: END IF;
267: RETURN l_converted_price;
268: EXCEPTION
269: WHEN OTHERS THEN
270: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
271: p_procedure_name => l_function_name);
272:
273: FND_MESSAGE.SET_NAME('INL','INL_ERR_QTY_CONV');
274: FND_MESSAGE.SET_TOKEN('CONCATENATED_SEGMENTS',l_concatenated_segments);

Line 315: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,

311: l_concatenated_segments VARCHAR2(240);
312: l_msg_data VARCHAR2(2000);
313:
314: BEGIN
315: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
316: p_procedure_name => l_function_name);
317:
318: l_debug_info := 'p_organization_id';
319: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

Line 319: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

315: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
316: p_procedure_name => l_function_name);
317:
318: l_debug_info := 'p_organization_id';
319: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
320: p_procedure_name => l_function_name,
321: p_var_name => l_debug_info,
322: p_var_value => TO_CHAR(p_organization_id));
323:

Line 325: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

321: p_var_name => l_debug_info,
322: p_var_value => TO_CHAR(p_organization_id));
323:
324: l_debug_info := 'p_inventory_item_id';
325: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
326: p_procedure_name => l_function_name,
327: p_var_name => l_debug_info,
328: p_var_value => TO_CHAR(p_inventory_item_id));
329:

Line 331: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

327: p_var_name => l_debug_info,
328: p_var_value => TO_CHAR(p_inventory_item_id));
329:
330: l_debug_info := 'p_qty';
331: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
332: p_procedure_name => l_function_name,
333: p_var_name => l_debug_info,
334: p_var_value => TO_CHAR(p_qty));
335:

Line 337: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

333: p_var_name => l_debug_info,
334: p_var_value => TO_CHAR(p_qty));
335:
336: l_debug_info := 'p_from_uom_code';
337: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
338: p_procedure_name => l_function_name,
339: p_var_name => l_debug_info,
340: p_var_value => p_from_uom_code);
341:

Line 343: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

339: p_var_name => l_debug_info,
340: p_var_value => p_from_uom_code);
341:
342: l_debug_info := 'p_to_uom_code';
343: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
344: p_procedure_name => l_function_name,
345: p_var_name => l_debug_info,
346: p_var_value => p_to_uom_code);
347:

Line 361: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

357: AND msi.organization_id = p_organization_id
358: AND msi.inventory_item_id = p_inventory_item_id;
359:
360: l_debug_info := 'l_primary_uom_code';
361: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
362: p_procedure_name => l_function_name,
363: p_var_name => l_debug_info,
364: p_var_value => l_primary_uom_code);
365:

Line 367: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

363: p_var_name => l_debug_info,
364: p_var_value => l_primary_uom_code);
365:
366: l_debug_info := 'l_primary_uom_class';
367: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
368: p_procedure_name => l_function_name,
369: p_var_name => l_debug_info,
370: p_var_value => l_primary_uom_class);
371:

Line 378: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

374: FROM mtl_units_of_measure
375: WHERE uom_code = p_from_uom_code;
376:
377: l_debug_info := 'l_allocation_uom_class';
378: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
379: p_procedure_name => l_function_name,
380: p_var_name => l_debug_info,
381: p_var_value => l_allocation_uom_class);
382:

Line 394: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

390: AND inventory_item_id = p_inventory_item_id
391: AND organization_id = p_organization_id;
392:
393: l_debug_info := 'l_primary_qty';
394: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
395: p_procedure_name => l_function_name,
396: p_var_name => l_debug_info,
397: p_var_value => TO_CHAR(l_primary_qty));
398:

Line 405: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

401: FROM mtl_units_of_measure
402: WHERE uom_code = P_to_uom_code;
403:
404: l_debug_info := 'l_to_allocation_uom_class';
405: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
406: p_procedure_name => l_function_name,
407: p_var_name => l_debug_info,
408: p_var_value => l_to_allocation_uom_class);
409:

Line 422: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

418: AND organization_id = p_organization_id;
419:
420:
421: l_debug_info := 'l_converted_qty';
422: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
423: p_procedure_name => l_function_name,
424: p_var_name => l_debug_info,
425: p_var_value => TO_CHAR(l_converted_qty));
426:

Line 427: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

423: p_procedure_name => l_function_name,
424: p_var_name => l_debug_info,
425: p_var_value => TO_CHAR(l_converted_qty));
426:
427: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
428: p_procedure_name => l_function_name);
429:
430: RETURN l_converted_qty;
431: EXCEPTION

Line 433: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

429:
430: RETURN l_converted_qty;
431: EXCEPTION
432: WHEN OTHERS THEN
433: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
434: p_procedure_name => l_function_name);
435:
436: FND_MESSAGE.SET_NAME('INL','INL_ERR_QTY_CONV');
437: FND_MESSAGE.SET_TOKEN('CONCATENATED_SEGMENTS',l_concatenated_segments);

Line 474: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,

470: l_conversion_rate NUMBER;
471: BEGIN
472:
473: l_Converted_amt := p_amt;
474: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
475: p_procedure_name => l_function_name);
476:
477: l_converted_amt := Converted_Amt(p_amt => p_amt,
478: p_from_currency_code => p_from_currency_code,

Line 488: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

484: RETURN l_Converted_Amt;
485:
486: EXCEPTION
487: WHEN OTHERS THEN
488: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
489: p_procedure_name => l_function_name);
490: FND_MESSAGE.SET_NAME('INL','INL_ERR_AMT_CONV');
491: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY_CODE',p_from_currency_code);
492: FND_MESSAGE.SET_TOKEN('TO_CURRENCY_CODE',p_to_currency_code);

Line 530: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,

526: l_converted_amt NUMBER;
527: l_conversion_rate NUMBER;
528:
529: BEGIN
530: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
531: p_procedure_name => l_function_name);
532:
533: l_Converted_Amt := p_amt;
534: IF p_from_currency_code <> p_to_currency_code THEN

Line 546: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

542: AND conversion_type = p_currency_conversion_type
543: AND TRUNC(conversion_date) = TRUNC(p_currency_conversion_date);
544: END IF;
545:
546: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
547: p_procedure_name => l_function_name);
548:
549: RETURN l_Converted_Amt;
550: EXCEPTION

Line 552: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

548:
549: RETURN l_Converted_Amt;
550: EXCEPTION
551: WHEN OTHERS THEN
552: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
553: p_procedure_name => l_function_name);
554: FND_MESSAGE.SET_NAME('INL','INL_ERR_AMT_CONV');
555: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY_CODE',p_from_currency_code);
556: FND_MESSAGE.SET_TOKEN('TO_CURRENCY_CODE',p_to_currency_code);

Line 629: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,

625: -- landed cost component to its corresponding shipment lines.
626:
627: BEGIN
628:
629: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
630: p_procedure_name => l_procedure_name);
631:
632: --
633: -- Initialize return status to SUCCESS

Line 651: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

647:
648: l_total_amt := 0;
649:
650: l_debug_info := 'p_ship_header_id';
651: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
652: p_procedure_name => l_procedure_name,
653: p_var_name => l_debug_info,
654: p_var_value => TO_CHAR(p_ship_header_id));
655:

Line 657: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

653: p_var_name => l_debug_info,
654: p_var_value => TO_CHAR(p_ship_header_id));
655:
656: l_debug_info := 'p_from_component_name';
657: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
658: p_procedure_name => l_procedure_name,
659: p_var_name => l_debug_info,
660: p_var_value => p_from_component_name);
661:

Line 663: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

659: p_var_name => l_debug_info,
660: p_var_value => p_from_component_name);
661:
662: l_debug_info := 'p_from_component_id';
663: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
664: p_procedure_name => l_procedure_name,
665: p_var_name => l_debug_info,
666: p_var_value => TO_CHAR(p_from_component_id));
667:

Line 669: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

665: p_var_name => l_debug_info,
666: p_var_value => TO_CHAR(p_from_component_id));
667:
668: l_debug_info := 'p_to_component_name';
669: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
670: p_procedure_name => l_procedure_name,
671: p_var_name => l_debug_info,
672: p_var_value => p_to_component_name);
673:

Line 675: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

671: p_var_name => l_debug_info,
672: p_var_value => p_to_component_name);
673:
674: l_debug_info := 'p_to_component_id';
675: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
676: p_procedure_name => l_procedure_name,
677: p_var_name => l_debug_info,
678: p_var_value => TO_CHAR(p_to_component_id));
679:

Line 681: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

677: p_var_name => l_debug_info,
678: p_var_value => TO_CHAR(p_to_component_id));
679:
680: l_debug_info := 'p_allocation_basis';
681: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
682: p_procedure_name => l_procedure_name,
683: p_var_name => l_debug_info,
684: p_var_value => TO_CHAR(p_allocation_basis));
685:

Line 687: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

683: p_var_name => l_debug_info,
684: p_var_value => TO_CHAR(p_allocation_basis));
685:
686: l_debug_info := 'p_allocation_uom_code';
687: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
688: p_procedure_name => l_procedure_name,
689: p_var_name => l_debug_info,
690: p_var_value => TO_CHAR(p_allocation_uom_code));
691:

Line 693: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

689: p_var_name => l_debug_info,
690: p_var_value => TO_CHAR(p_allocation_uom_code));
691:
692: l_debug_info := 'p_to_component_name';
693: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
694: p_procedure_name => l_procedure_name,
695: p_var_name => l_debug_info,
696: p_var_value => p_to_component_name);
697:

Line 783: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

779: END LOOP;
780: CLOSE assoc;
781:
782: l_debug_info := 'NOT INL_SHIP_DISTS l_total_amt';
783: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
784: p_procedure_name => l_procedure_name,
785: p_var_name => l_debug_info,
786: p_var_value => TO_CHAR(l_total_amt));
787:

Line 807: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

803: AND ol.ship_line_group_id = DECODE(p_from_component_name,'INL_SHIP_LINE_GROUPS',p_from_component_id,ol.ship_line_group_id)
804: AND ol.ship_line_id = DECODE(p_from_component_name,'INL_SHIP_LINES',p_from_component_id,ol.ship_line_id)
805: AND ol.ship_header_id = p_ship_header_id;
806: l_debug_info := 'INL_SHIP_DISTS l_total_amt';
807: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
808: p_procedure_name => l_procedure_name,
809: p_var_name => l_debug_info,
810: p_var_value => TO_CHAR(l_total_amt));
811:

Line 886: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

882: END IF;
883: END IF;
884:
885: l_debug_info := 'l_to_component_amt';
886: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
887: p_procedure_name => l_procedure_name,
888: p_var_name => l_debug_info,
889: p_var_value => TO_CHAR(l_to_component_amt));
890:

Line 901: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

897: ELSE
898: l_debug_info := 'Component not allocated';
899: o_factor := 0;
900: END IF;
901: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
902: p_procedure_name => l_procedure_name,
903: p_debug_info => l_debug_info);
904: ELSE
905: o_factor := l_to_component_amt/l_total_amt;

Line 917: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

913: END IF;
914: END IF;
915:
916: l_debug_info := 'o_factor';
917: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
918: p_procedure_name => l_procedure_name,
919: p_var_name => l_debug_info,
920: p_var_value => TO_CHAR(o_factor));
921:

Line 922: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

918: p_procedure_name => l_procedure_name,
919: p_var_name => l_debug_info,
920: p_var_value => TO_CHAR(o_factor));
921:
922: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
923: p_procedure_name => l_procedure_name);
924:
925: EXCEPTION
926: WHEN FND_API.G_EXC_ERROR THEN

Line 927: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

923: p_procedure_name => l_procedure_name);
924:
925: EXCEPTION
926: WHEN FND_API.G_EXC_ERROR THEN
927: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
928: p_procedure_name => l_procedure_name);
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
931: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 931: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

927: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
928: p_procedure_name => l_procedure_name);
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
931: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
932: p_procedure_name => l_procedure_name);
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: WHEN OTHERS THEN
935: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 935: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

931: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
932: p_procedure_name => l_procedure_name);
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: WHEN OTHERS THEN
935: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
936: p_procedure_name => l_procedure_name);
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
939: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_procedure_name);

Line 1018: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,

1014:
1015: BEGIN
1016:
1017:
1018: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1019: p_procedure_name => l_procedure_name);
1020:
1021: --
1022: -- Initialize return status to SUCCESS

Line 1028: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1024:
1025: x_return_status := FND_API.G_RET_STS_SUCCESS;
1026:
1027: l_debug_info := 'p_ship_header_id';
1028: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1029: p_procedure_name => l_procedure_name,
1030: p_var_name => l_debug_info,
1031: p_var_value => TO_CHAR(p_ship_header_id));
1032:

Line 1034: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1030: p_var_name => l_debug_info,
1031: p_var_value => TO_CHAR(p_ship_header_id));
1032:
1033: l_debug_info := 'p_le_currency_code';
1034: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1035: p_procedure_name => l_procedure_name,
1036: p_var_name => l_debug_info,
1037: p_var_value => p_le_currency_code);
1038:

Line 1040: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1036: p_var_name => l_debug_info,
1037: p_var_value => p_le_currency_code);
1038:
1039: l_debug_info := 'p_association_id';
1040: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1041: p_procedure_name => l_procedure_name,
1042: p_var_name => l_debug_info,
1043: p_var_value => TO_CHAR(p_association_id));
1044:

Line 1046: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1042: p_var_name => l_debug_info,
1043: p_var_value => TO_CHAR(p_association_id));
1044:
1045: l_debug_info := 'p_ship_line_id';
1046: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1047: p_procedure_name => l_procedure_name,
1048: p_var_name => l_debug_info,
1049: p_var_value => TO_CHAR(p_ship_line_id));
1050:

Line 1052: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1048: p_var_name => l_debug_info,
1049: p_var_value => TO_CHAR(p_ship_line_id));
1050:
1051: l_debug_info := 'p_amount';
1052: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1053: p_procedure_name => l_procedure_name,
1054: p_var_name => l_debug_info,
1055: p_var_value => TO_CHAR(p_amount));
1056:

Line 1058: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1054: p_var_name => l_debug_info,
1055: p_var_value => TO_CHAR(p_amount));
1056:
1057: l_debug_info := 'p_from_component_name';
1058: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1059: p_procedure_name => l_procedure_name,
1060: p_var_name => l_debug_info,
1061: p_var_value => p_from_component_name);
1062:

Line 1064: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1060: p_var_name => l_debug_info,
1061: p_var_value => p_from_component_name);
1062:
1063: l_debug_info := 'p_from_component_id';
1064: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1065: p_procedure_name => l_procedure_name,
1066: p_var_name => l_debug_info,
1067: p_var_value => TO_CHAR(p_from_component_id));
1068:

Line 1070: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1066: p_var_name => l_debug_info,
1067: p_var_value => TO_CHAR(p_from_component_id));
1068:
1069: l_debug_info := 'p_to_component_name';
1070: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1071: p_procedure_name => l_procedure_name,
1072: p_var_name => l_debug_info,
1073: p_var_value => p_to_component_name);
1074:

Line 1076: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1072: p_var_name => l_debug_info,
1073: p_var_value => p_to_component_name);
1074:
1075: l_debug_info := 'p_to_component_id';
1076: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1077: p_procedure_name => l_procedure_name,
1078: p_var_name => l_debug_info,
1079: p_var_value => TO_CHAR(p_to_component_id));
1080:

Line 1082: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1078: p_var_name => l_debug_info,
1079: p_var_value => TO_CHAR(p_to_component_id));
1080:
1081: l_debug_info := 'p_lc_flag';
1082: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1083: p_procedure_name => l_procedure_name,
1084: p_var_name => l_debug_info,
1085: p_var_value => p_lc_flag);
1086:

Line 1088: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1084: p_var_name => l_debug_info,
1085: p_var_value => p_lc_flag);
1086:
1087: l_debug_info := 'p_adjustment_num';
1088: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1089: p_procedure_name => l_procedure_name,
1090: p_var_name => l_debug_info,
1091: p_var_value => TO_CHAR(p_adjustment_num));
1092: -- bug 7660824

Line 1111: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1107: l_ship_line_lc_flag := 'Y';
1108: --
1109:
1110: l_debug_info := 'l_ship_line_lc_flag';
1111: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1112: p_procedure_name => l_procedure_name,
1113: p_var_name => l_debug_info,
1114: p_var_value => l_ship_line_lc_flag);
1115:

Line 1130: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1126:
1127:
1128: -- Check whether the Ship Line of the allocation is associated to other Ship Lines
1129: l_debug_info := 'Check whether the Ship Line of the allocation is associated to other Ship Lines';
1130: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1131: p_procedure_name => l_procedure_name,
1132: p_debug_info => l_debug_info);
1133:
1134: l_count := 0;

Line 1142: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1138: EXIT WHEN assoc%NOTFOUND;
1139: l_count := l_count + 1;
1140:
1141: l_debug_info := 'Calling Manage_Proportion';
1142: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1143: p_procedure_name => l_procedure_name,
1144: p_debug_info => l_debug_info);
1145:
1146: Manage_Proportion (p_ship_header_id,

Line 1164: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1161: END IF;
1162:
1163: l_debug_info := 'l_factor';
1164: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1165: p_procedure_name => l_procedure_name,
1166: p_var_name => l_debug_info,
1167: p_var_value => TO_CHAR(l_factor));
1168:

Line 1170: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1166: p_var_name => l_debug_info,
1167: p_var_value => TO_CHAR(l_factor));
1168:
1169: l_debug_info := 'Inserting into inl_allocations';
1170: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1171: p_procedure_name => l_procedure_name,
1172: p_debug_info => l_debug_info);
1173:
1174: l_debug_info := 'rec_assoc.to_parent_table_id';

Line 1175: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1171: p_procedure_name => l_procedure_name,
1172: p_debug_info => l_debug_info);
1173:
1174: l_debug_info := 'rec_assoc.to_parent_table_id';
1175: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1176: p_procedure_name => l_procedure_name,
1177: p_var_name => l_debug_info,
1178: p_var_value => TO_CHAR(rec_assoc.to_parent_table_id));
1179:

Line 1181: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1177: p_var_name => l_debug_info,
1178: p_var_value => TO_CHAR(rec_assoc.to_parent_table_id));
1179:
1180: l_debug_info := 'p_amount * l_factor';
1181: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1182: p_procedure_name => l_procedure_name,
1183: p_var_name => l_debug_info,
1184: p_var_value => TO_CHAR(p_amount * l_factor));
1185:

Line 1213: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1209:
1210: IF l_count = 0 THEN
1211:
1212: l_debug_info := 'Inserting into inl_allocations';
1213: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1214: p_procedure_name => l_procedure_name,
1215: p_debug_info => l_debug_info);
1216:
1217: l_debug_info := 'p_ship_line_id';

Line 1218: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1214: p_procedure_name => l_procedure_name,
1215: p_debug_info => l_debug_info);
1216:
1217: l_debug_info := 'p_ship_line_id';
1218: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1219: p_procedure_name => l_procedure_name,
1220: p_var_name => l_debug_info,
1221: p_var_value => TO_CHAR(p_ship_line_id));
1222:

Line 1224: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1220: p_var_name => l_debug_info,
1221: p_var_value => TO_CHAR(p_ship_line_id));
1222:
1223: l_debug_info := 'p_amount';
1224: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1225: p_procedure_name => l_procedure_name,
1226: p_var_name => l_debug_info,
1227: p_var_value => TO_CHAR(p_amount));
1228:

Line 1265: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

1261: SYSDATE,
1262: fnd_global.login_id);
1263: END IF;
1264:
1265: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1266: p_procedure_name => l_procedure_name);
1267:
1268: EXCEPTION
1269: WHEN FND_API.G_EXC_ERROR THEN

Line 1270: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

1266: p_procedure_name => l_procedure_name);
1267:
1268: EXCEPTION
1269: WHEN FND_API.G_EXC_ERROR THEN
1270: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1271: p_procedure_name => l_procedure_name);
1272: x_return_status := FND_API.G_RET_STS_ERROR;
1273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1274: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 1274: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

1270: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1271: p_procedure_name => l_procedure_name);
1272: x_return_status := FND_API.G_RET_STS_ERROR;
1273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1274: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1275: p_procedure_name => l_procedure_name);
1276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1277: WHEN OTHERS THEN
1278: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 1278: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

1274: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1275: p_procedure_name => l_procedure_name);
1276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1277: WHEN OTHERS THEN
1278: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1279: p_procedure_name => l_procedure_name);
1280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1281: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1282: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_procedure_name);

Line 1347: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,

1343: l_return_status VARCHAR2(1);
1344:
1345: BEGIN
1346:
1347: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1348: p_procedure_name => l_procedure_name);
1349:
1350: --
1351: -- Initialize return status to SUCCESS

Line 1357: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1353:
1354: x_return_status := FND_API.G_RET_STS_SUCCESS;
1355:
1356: l_debug_info := 'p_ship_header_id';
1357: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1358: p_procedure_name => l_procedure_name,
1359: p_var_name => l_debug_info,
1360: p_var_value => TO_CHAR(p_ship_header_id));
1361:

Line 1363: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1359: p_var_name => l_debug_info,
1360: p_var_value => TO_CHAR(p_ship_header_id));
1361:
1362: l_debug_info := 'p_le_currency_code';
1363: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1364: p_procedure_name => l_procedure_name,
1365: p_var_name => l_debug_info,
1366: p_var_value => p_le_currency_code);
1367:

Line 1369: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1365: p_var_name => l_debug_info,
1366: p_var_value => p_le_currency_code);
1367:
1368: l_debug_info := 'p_association_id';
1369: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1370: p_procedure_name => l_procedure_name,
1371: p_var_name => l_debug_info,
1372: p_var_value => TO_CHAR(p_association_id));
1373:

Line 1375: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1371: p_var_name => l_debug_info,
1372: p_var_value => TO_CHAR(p_association_id));
1373:
1374: l_debug_info := 'p_allocation_basis';
1375: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1376: p_procedure_name => l_procedure_name,
1377: p_var_name => l_debug_info,
1378: p_var_value => p_allocation_basis);
1379:

Line 1381: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1377: p_var_name => l_debug_info,
1378: p_var_value => p_allocation_basis);
1379:
1380: l_debug_info := 'p_allocation_uom_code';
1381: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1382: p_procedure_name => l_procedure_name,
1383: p_var_name => l_debug_info,
1384: p_var_value => p_allocation_uom_code);
1385:

Line 1387: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1383: p_var_name => l_debug_info,
1384: p_var_value => p_allocation_uom_code);
1385:
1386: l_debug_info := 'p_amount';
1387: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1388: p_procedure_name => l_procedure_name,
1389: p_var_name => l_debug_info,
1390: p_var_value => TO_CHAR(p_amount));
1391:

Line 1393: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1389: p_var_name => l_debug_info,
1390: p_var_value => TO_CHAR(p_amount));
1391:
1392: l_debug_info := 'p_from_component_name';
1393: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1394: p_procedure_name => l_procedure_name,
1395: p_var_name => l_debug_info,
1396: p_var_value => p_from_component_name);
1397:

Line 1399: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1395: p_var_name => l_debug_info,
1396: p_var_value => p_from_component_name);
1397:
1398: l_debug_info := 'p_from_component_id';
1399: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1400: p_procedure_name => l_procedure_name,
1401: p_var_name => l_debug_info,
1402: p_var_value => TO_CHAR(p_from_component_id));
1403:

Line 1405: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1401: p_var_name => l_debug_info,
1402: p_var_value => TO_CHAR(p_from_component_id));
1403:
1404: l_debug_info := 'p_to_component_name';
1405: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1406: p_procedure_name => l_procedure_name,
1407: p_var_name => l_debug_info,
1408: p_var_value => p_to_component_name);
1409:

Line 1411: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1407: p_var_name => l_debug_info,
1408: p_var_value => p_to_component_name);
1409:
1410: l_debug_info := 'p_to_component_id';
1411: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1412: p_procedure_name => l_procedure_name,
1413: p_var_name => l_debug_info,
1414: p_var_value => TO_CHAR(p_to_component_id));
1415:

Line 1417: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1413: p_var_name => l_debug_info,
1414: p_var_value => TO_CHAR(p_to_component_id));
1415:
1416: l_debug_info := 'p_adjustment_num';
1417: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1418: p_procedure_name => l_procedure_name,
1419: p_var_name => l_debug_info,
1420: p_var_value => TO_CHAR(p_adjustment_num));
1421:

Line 1466: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

1462:
1463: END LOOP;
1464: CLOSE dist;
1465:
1466: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1467: p_procedure_name => l_procedure_name);
1468:
1469: EXCEPTION
1470: WHEN FND_API.G_EXC_ERROR THEN

Line 1471: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

1467: p_procedure_name => l_procedure_name);
1468:
1469: EXCEPTION
1470: WHEN FND_API.G_EXC_ERROR THEN
1471: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1472: p_procedure_name => l_procedure_name);
1473: x_return_status := FND_API.G_RET_STS_ERROR;
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1475: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 1475: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

1471: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1472: p_procedure_name => l_procedure_name);
1473: x_return_status := FND_API.G_RET_STS_ERROR;
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1475: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1476: p_procedure_name => l_procedure_name);
1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1478: WHEN OTHERS THEN
1479: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 1479: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

1475: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1476: p_procedure_name => l_procedure_name);
1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1478: WHEN OTHERS THEN
1479: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1480: p_procedure_name => l_procedure_name);
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1483: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_procedure_name);

Line 1577: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,

1573: l_return_status VARCHAR2(1);
1574:
1575: BEGIN
1576:
1577: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1578: p_procedure_name => l_procedure_name);
1579: --
1580: -- Initialize return status to SUCCESS
1581: --

Line 1588: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1584:
1585: l_next_level_allocation := 'N';
1586:
1587: l_debug_info := 'p_ship_header_id';
1588: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1589: p_procedure_name => l_procedure_name,
1590: p_var_name => l_debug_info,
1591: p_var_value => TO_CHAR(p_ship_header_id));
1592:

Line 1594: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1590: p_var_name => l_debug_info,
1591: p_var_value => TO_CHAR(p_ship_header_id));
1592:
1593: l_debug_info := 'p_le_currency_code';
1594: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1595: p_procedure_name => l_procedure_name,
1596: p_var_name => l_debug_info,
1597: p_var_value => p_le_currency_code);
1598:

Line 1600: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1596: p_var_name => l_debug_info,
1597: p_var_value => p_le_currency_code);
1598:
1599: l_debug_info := 'p_association_id';
1600: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1601: p_procedure_name => l_procedure_name,
1602: p_var_name => l_debug_info,
1603: p_var_value => TO_CHAR(p_association_id));
1604:

Line 1606: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1602: p_var_name => l_debug_info,
1603: p_var_value => TO_CHAR(p_association_id));
1604:
1605: l_debug_info := 'p_allocation_basis';
1606: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1607: p_procedure_name => l_procedure_name,
1608: p_var_name => l_debug_info,
1609: p_var_value => p_allocation_basis);
1610:

Line 1612: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1608: p_var_name => l_debug_info,
1609: p_var_value => p_allocation_basis);
1610:
1611: l_debug_info := 'p_allocation_uom_code';
1612: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1613: p_procedure_name => l_procedure_name,
1614: p_var_name => l_debug_info,
1615: p_var_value => p_allocation_uom_code);
1616:

Line 1618: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1614: p_var_name => l_debug_info,
1615: p_var_value => p_allocation_uom_code);
1616:
1617: l_debug_info := 'p_amount';
1618: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1619: p_procedure_name => l_procedure_name,
1620: p_var_name => l_debug_info,
1621: p_var_value => TO_CHAR(p_amount));
1622:

Line 1624: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1620: p_var_name => l_debug_info,
1621: p_var_value => TO_CHAR(p_amount));
1622:
1623: l_debug_info := 'p_from_component_name';
1624: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1625: p_procedure_name => l_procedure_name,
1626: p_var_name => l_debug_info,
1627: p_var_value => p_from_component_name);
1628:

Line 1630: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1626: p_var_name => l_debug_info,
1627: p_var_value => p_from_component_name);
1628:
1629: l_debug_info := 'p_from_component_id';
1630: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1631: p_procedure_name => l_procedure_name,
1632: p_var_name => l_debug_info,
1633: p_var_value => TO_CHAR(p_from_component_id));
1634:

Line 1636: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1632: p_var_name => l_debug_info,
1633: p_var_value => TO_CHAR(p_from_component_id));
1634:
1635: l_debug_info := 'p_to_component_name';
1636: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1637: p_procedure_name => l_procedure_name,
1638: p_var_name => l_debug_info,
1639: p_var_value => p_to_component_name);
1640:

Line 1642: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1638: p_var_name => l_debug_info,
1639: p_var_value => p_to_component_name);
1640:
1641: l_debug_info := 'p_to_component_id';
1642: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1643: p_procedure_name => l_procedure_name,
1644: p_var_name => l_debug_info,
1645: p_var_value => TO_CHAR(p_to_component_id));
1646:

Line 1648: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1644: p_var_name => l_debug_info,
1645: p_var_value => TO_CHAR(p_to_component_id));
1646:
1647: l_debug_info := 'p_adjustment_num';
1648: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1649: p_procedure_name => l_procedure_name,
1650: p_var_name => l_debug_info,
1651: p_var_value => TO_CHAR(p_adjustment_num));
1652:

Line 1666: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1662:
1663: l_next_level_allocation := 'Y';
1664:
1665: l_debug_info := 'Call Proportion procedure ';
1666: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1667: p_procedure_name => l_procedure_name,
1668: p_debug_info => l_debug_info);
1669:
1670: Manage_Proportion (p_ship_header_id,

Line 1717: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1713: END LOOP;
1714: CLOSE component;
1715:
1716: l_debug_info := 'p_to_component_name';
1717: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1718: p_procedure_name => l_procedure_name,
1719: p_var_name => l_debug_info,
1720: p_var_value => p_to_component_name);
1721:

Line 1768: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

1764: END IF;
1765:
1766: END IF;
1767:
1768: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1769: p_procedure_name => l_procedure_name);
1770:
1771: EXCEPTION
1772: WHEN FND_API.G_EXC_ERROR THEN

Line 1773: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

1769: p_procedure_name => l_procedure_name);
1770:
1771: EXCEPTION
1772: WHEN FND_API.G_EXC_ERROR THEN
1773: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1774: p_procedure_name => l_procedure_name);
1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1777: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 1777: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

1773: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1774: p_procedure_name => l_procedure_name);
1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1777: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1778: p_procedure_name => l_procedure_name);
1779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1780: WHEN OTHERS THEN
1781: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 1781: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

1777: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1778: p_procedure_name => l_procedure_name);
1779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1780: WHEN OTHERS THEN
1781: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1782: p_procedure_name => l_procedure_name);
1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1784: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1785: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_procedure_name);

Line 1827: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,

1823: l_return_status VARCHAR2(1);
1824:
1825: BEGIN
1826:
1827: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1828: p_procedure_name => l_procedure_name);
1829: --
1830: -- Initialize return status to SUCCESS
1831: --

Line 1836: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1832:
1833: x_return_status := FND_API.G_RET_STS_SUCCESS;
1834:
1835: l_debug_info := 'p_ship_header_id';
1836: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1837: p_procedure_name => l_procedure_name,
1838: p_var_name => l_debug_info,
1839: p_var_value => TO_CHAR(p_ship_header_id));
1840:

Line 1847: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1843: FETCH updalloc INTO rec_updalloc;
1844: EXIT WHEN updalloc%NOTFOUND;
1845:
1846: l_debug_info := 'Updating inl_allocations with parent_allocation_id';
1847: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1848: p_procedure_name => l_procedure_name,
1849: p_debug_info => l_debug_info);
1850:
1851: UPDATE inl_allocations a1

Line 1872: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1868: WHERE a1.allocation_id = rec_updalloc.allocation_id
1869: AND a1.adjustment_num = rec_updalloc.adjustment_num;
1870:
1871: l_debug_info := 'rec_updalloc.allocation_id';
1872: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1873: p_procedure_name => l_procedure_name,
1874: p_var_name => l_debug_info,
1875: p_var_value => TO_CHAR(rec_updalloc.allocation_id));
1876:

Line 1878: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

1874: p_var_name => l_debug_info,
1875: p_var_value => TO_CHAR(rec_updalloc.allocation_id));
1876:
1877: l_debug_info := 'rec_updalloc.adjustment_num';
1878: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1879: p_procedure_name => l_procedure_name,
1880: p_var_name => l_debug_info,
1881: p_var_value => TO_CHAR(rec_updalloc.adjustment_num));
1882:

Line 1886: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

1882:
1883: END LOOP;
1884: CLOSE updalloc;
1885:
1886: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1887: p_procedure_name => l_procedure_name);
1888:
1889: EXCEPTION
1890: WHEN FND_API.G_EXC_ERROR THEN

Line 1891: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

1887: p_procedure_name => l_procedure_name);
1888:
1889: EXCEPTION
1890: WHEN FND_API.G_EXC_ERROR THEN
1891: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1892: p_procedure_name => l_procedure_name);
1893: x_return_status := FND_API.G_RET_STS_ERROR;
1894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1895: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 1895: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

1891: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1892: p_procedure_name => l_procedure_name);
1893: x_return_status := FND_API.G_RET_STS_ERROR;
1894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1895: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1896: p_procedure_name => l_procedure_name);
1897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1898: WHEN OTHERS THEN
1899: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 1899: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

1895: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1896: p_procedure_name => l_procedure_name);
1897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1898: WHEN OTHERS THEN
1899: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1900: p_procedure_name => l_procedure_name);
1901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1902: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1903: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_procedure_name);

Line 2053: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,

2049: --
2050:
2051: BEGIN
2052:
2053: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
2054: p_procedure_name => l_api_name);
2055: --
2056: -- Standard Start of API savepoint
2057: --

Line 2100: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

2096:
2097: IF l_adjustment_num = 0 THEN
2098:
2099: l_debug_info := 'Check for Associations in Loop';
2100: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2101: p_procedure_name => l_api_name,
2102: p_debug_info => l_debug_info);
2103:
2104: OPEN assoc;

Line 2136: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

2132: -- Remove previous allocations
2133: --
2134:
2135: l_debug_info := 'Remove previous allocations';
2136: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2137: p_procedure_name => l_api_name,
2138: p_debug_info => l_debug_info);
2139:
2140: DELETE FROM INL_allocations

Line 2156: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

2152: -- Get Functional Currency
2153: --
2154:
2155: l_debug_info := 'Get Functional Currency';
2156: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2157: p_procedure_name => l_api_name,
2158: p_debug_info => l_debug_info);
2159:
2160: SELECT DISTINCT gl.currency_code

Line 2174: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

2170: -- STEP 1 - Allocation of Associated Amounts
2171: --
2172:
2173: l_debug_info := 'STEP 1: Allocation of Associated Amounts';
2174: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2175: p_procedure_name => l_api_name,
2176: p_debug_info => l_debug_info);
2177:
2178: OPEN assoc;

Line 2184: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

2180: FETCH assoc INTO rec_assoc;
2181: EXIT WHEN assoc%NOTFOUND;
2182:
2183: l_debug_info := 'Fetching Associations cursor';
2184: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2185: p_procedure_name => l_api_name,
2186: p_debug_info => l_debug_info);
2187:
2188: l_amount := 0;

Line 2193: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

2189: l_from_amount := 0;
2190: l_to_amount := 0;
2191:
2192: l_debug_info := 'rec_assoc.from_parent_table_name';
2193: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
2194: p_procedure_name => l_api_name,
2195: p_var_name => l_debug_info,
2196: p_var_value => rec_assoc.from_parent_table_name);
2197:

Line 2199: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

2195: p_var_name => l_debug_info,
2196: p_var_value => rec_assoc.from_parent_table_name);
2197:
2198: l_debug_info := 'rec_assoc.from_parent_table_id';
2199: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
2200: p_procedure_name => l_api_name,
2201: p_var_name => l_debug_info,
2202: p_var_value => TO_CHAR(rec_assoc.from_parent_table_id));
2203:

Line 2206: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

2202: p_var_value => TO_CHAR(rec_assoc.from_parent_table_id));
2203:
2204:
2205: l_debug_info := 'rec_assoc.to_parent_table_name';
2206: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
2207: p_procedure_name => l_api_name,
2208: p_var_name => l_debug_info,
2209: p_var_value => rec_assoc.to_parent_table_name);
2210:

Line 2213: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

2209: p_var_value => rec_assoc.to_parent_table_name);
2210:
2211:
2212: l_debug_info := 'rec_assoc.to_parent_table_id';
2213: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
2214: p_procedure_name => l_api_name,
2215: p_var_name => l_debug_info,
2216: p_var_value => TO_CHAR(rec_assoc.to_parent_table_id));
2217:

Line 2219: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

2215: p_var_name => l_debug_info,
2216: p_var_value => TO_CHAR(rec_assoc.to_parent_table_id));
2217:
2218: l_debug_info := 'rec_assoc.association_id';
2219: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
2220: p_procedure_name => l_api_name,
2221: p_var_name => l_debug_info,
2222: p_var_value => rec_assoc.association_id);
2223:

Line 2253: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

2249: WHERE ship_line_id = rec_assoc.from_parent_table_id;
2250: END IF;
2251:
2252: l_debug_info := 'l_from_amount';
2253: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
2254: p_procedure_name => l_api_name,
2255: p_var_name => l_debug_info,
2256: p_var_value => TO_CHAR(l_from_amount));
2257:

Line 2259: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

2255: p_var_name => l_debug_info,
2256: p_var_value => TO_CHAR(l_from_amount));
2257:
2258: l_debug_info := 'rec_assoc.to_parent_table_name';
2259: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
2260: p_procedure_name => l_api_name,
2261: p_var_name => l_debug_info,
2262: p_var_value => rec_assoc.to_parent_table_name);
2263:

Line 2267: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

2263:
2264: l_amount := l_from_amount;
2265:
2266: l_debug_info := 'l_amount';
2267: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
2268: p_procedure_name => l_api_name,
2269: p_var_name => l_debug_info,
2270: p_var_value => TO_CHAR(l_amount));
2271:

Line 2274: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

2270: p_var_value => TO_CHAR(l_amount));
2271:
2272:
2273: l_debug_info := 'Call to Manage_Proportion';
2274: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2275: p_procedure_name => l_api_name,
2276: p_debug_info => l_debug_info);
2277:
2278: Manage_Proportion (rec_assoc.ship_header_id,

Line 2298: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

2294:
2295: l_amount := l_amount * l_factor;
2296:
2297: l_debug_info := 'Call to Control_Allocation';
2298: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2299: p_procedure_name => l_api_name,
2300: p_debug_info => l_debug_info);
2301:
2302: Control_Allocation (rec_assoc.ship_header_id,

Line 2328: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

2324: -- STEP 2 - Allocation of Not Associated Amounts
2325: --
2326:
2327: l_debug_info := 'STEP 2 - Allocation of Not Associated Amounts';
2328: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2329: p_procedure_name => l_api_name,
2330: p_debug_info => l_debug_info);
2331:
2332: l_count := 0;

Line 2342: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

2338:
2339: l_count := 0;
2340:
2341: l_debug_info := 'Fetching Distributions cursor';
2342: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2343: p_procedure_name => l_api_name,
2344: p_debug_info => l_debug_info);
2345:
2346: SELECT COUNT(*) + l_count

Line 2361: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

2357:
2358: SELECT DECODE(l_count,0,'Y','N') INTO l_lc_flag FROM DUAL;
2359:
2360: l_debug_info := 'rec_dist.ship_line_id';
2361: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
2362: p_procedure_name => l_api_name,
2363: p_var_name => l_debug_info,
2364: p_var_value => TO_CHAR(rec_dist.ship_line_id));
2365:

Line 2367: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

2363: p_var_name => l_debug_info,
2364: p_var_value => TO_CHAR(rec_dist.ship_line_id));
2365:
2366: l_debug_info := 'l_lc_flag';
2367: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
2368: p_procedure_name => l_api_name,
2369: p_var_name => l_debug_info,
2370: p_var_value => l_lc_flag);
2371:

Line 2492: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

2488: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.g_false,
2489: p_count => x_msg_count,
2490: p_data => x_msg_data);
2491:
2492: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
2493: p_procedure_name => l_api_name);
2494:
2495: EXCEPTION
2496: WHEN FND_API.G_EXC_ERROR THEN

Line 2497: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

2493: p_procedure_name => l_api_name);
2494:
2495: EXCEPTION
2496: WHEN FND_API.G_EXC_ERROR THEN
2497: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
2498: p_procedure_name => l_api_name);
2499: ROLLBACK TO Run_Calculation_PVT;
2500: x_return_status := FND_API.G_RET_STS_ERROR;
2501: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 2505: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

2501: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2502: p_count => x_msg_count,
2503: p_data => x_msg_data);
2504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2505: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2506: p_procedure_name => l_api_name);
2507: ROLLBACK TO Run_Calculation_PVT;
2508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2509: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 2513: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

2509: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2510: p_count => x_msg_count,
2511: p_data => x_msg_data);
2512: WHEN OTHERS THEN
2513: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2514: p_procedure_name => l_api_name);
2515: ROLLBACK TO Run_Calculation_PVT;
2516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2517: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)