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 43: INL_LOGGING_PVT.Log_BeginProc (

39: l_in_loop BOOLEAN;
40:
41: BEGIN
42:
43: INL_LOGGING_PVT.Log_BeginProc (
44: p_module_name => g_module_name,
45: p_procedure_name => l_program_name);
46:
47: --

Line 53: INL_LOGGING_PVT.Log_Variable (

49: --
50: x_return_status := L_FND_RET_STS_SUCCESS;
51:
52: l_debug_info := 'p_ship_header_id';
53: INL_LOGGING_PVT.Log_Variable (
54: p_module_name => g_module_name,
55: p_procedure_name => l_program_name,
56: p_var_name => l_debug_info,
57: p_var_value => TO_CHAR(p_ship_header_id));

Line 60: INL_LOGGING_PVT.Log_Variable (

56: p_var_name => l_debug_info,
57: p_var_value => TO_CHAR(p_ship_header_id));
58:
59: l_debug_info := 'p_from_parent_table_name';
60: INL_LOGGING_PVT.Log_Variable (
61: p_module_name => g_module_name,
62: p_procedure_name => l_program_name,
63: p_var_name => l_debug_info,
64: p_var_value => p_from_parent_table_name);

Line 67: INL_LOGGING_PVT.Log_Variable (

63: p_var_name => l_debug_info,
64: p_var_value => p_from_parent_table_name);
65:
66: l_debug_info := 'p_from_parent_table_id';
67: INL_LOGGING_PVT.Log_Variable (
68: p_module_name => g_module_name,
69: p_procedure_name => l_program_name,
70: p_var_name => l_debug_info,
71: p_var_value => TO_CHAR(p_from_parent_table_id));

Line 85: INL_LOGGING_PVT.Log_Statement (

81: START WITH FROM_PARENT_TABLE_NAME = P_from_parent_table_name
82: AND FROM_PARENT_TABLE_ID = P_from_parent_table_id
83: CONNECT BY PRIOR TO_PARENT_TABLE_NAME = FROM_PARENT_TABLE_NAME
84: AND PRIOR TO_PARENT_TABLE_ID = FROM_PARENT_TABLE_ID;
85: INL_LOGGING_PVT.Log_Statement (
86: p_module_name => g_module_name,
87: p_procedure_name => l_program_name,
88: p_debug_info => 'IN LOOP association does not exist'
89: );

Line 93: INL_LOGGING_PVT.Log_Statement (

89: );
90: l_in_loop := FALSE;
91: EXCEPTION
92: WHEN LOOP_ERROR THEN
93: INL_LOGGING_PVT.Log_Statement (
94: p_module_name => g_module_name,
95: p_procedure_name => l_program_name,
96: p_debug_info => 'IN LOOP association exists'
97: );

Line 101: INL_LOGGING_PVT.Log_EndProc(

97: );
98: l_in_loop := TRUE;
99: END;
100:
101: INL_LOGGING_PVT.Log_EndProc(
102: p_module_name => g_module_name,
103: p_procedure_name => l_program_name);
104:
105: IF l_in_loop THEN

Line 160: INL_LOGGING_PVT.Log_BeginProc (

156: l_primary_uom_class VARCHAR2(10);
157: l_concatenated_segments VARCHAR2(40);
158:
159: BEGIN
160: INL_LOGGING_PVT.Log_BeginProc (
161: p_module_name => g_module_name,
162: p_procedure_name => l_program_name);
163:
164: l_debug_info := 'p_unit_price';

Line 165: INL_LOGGING_PVT.Log_Variable (

161: p_module_name => g_module_name,
162: p_procedure_name => l_program_name);
163:
164: l_debug_info := 'p_unit_price';
165: INL_LOGGING_PVT.Log_Variable (
166: p_module_name => g_module_name,
167: p_procedure_name => l_program_name,
168: p_var_name => l_debug_info,
169: p_var_value => TO_CHAR(p_unit_price));

Line 172: INL_LOGGING_PVT.Log_Variable (

168: p_var_name => l_debug_info,
169: p_var_value => TO_CHAR(p_unit_price));
170:
171: l_debug_info := 'p_organization_id';
172: INL_LOGGING_PVT.Log_Variable (
173: p_module_name => g_module_name,
174: p_procedure_name => l_program_name,
175: p_var_name => l_debug_info,
176: p_var_value => TO_CHAR(p_organization_id));

Line 179: INL_LOGGING_PVT.Log_Variable (

175: p_var_name => l_debug_info,
176: p_var_value => TO_CHAR(p_organization_id));
177:
178: l_debug_info := 'p_inventory_item_id';
179: INL_LOGGING_PVT.Log_Variable (
180: p_module_name => g_module_name,
181: p_procedure_name => l_program_name,
182: p_var_name => l_debug_info,
183: p_var_value => TO_CHAR(p_inventory_item_id));

Line 186: INL_LOGGING_PVT.Log_Variable (

182: p_var_name => l_debug_info,
183: p_var_value => TO_CHAR(p_inventory_item_id));
184:
185: l_debug_info := 'p_from_uom_code';
186: INL_LOGGING_PVT.Log_Variable (
187: p_module_name => g_module_name,
188: p_procedure_name => l_program_name,
189: p_var_name => l_debug_info,
190: p_var_value => p_from_uom_code);

Line 193: INL_LOGGING_PVT.Log_Variable (

189: p_var_name => l_debug_info,
190: p_var_value => p_from_uom_code);
191:
192: l_debug_info := 'p_to_uom_code';
193: INL_LOGGING_PVT.Log_Variable (
194: p_module_name => g_module_name,
195: p_procedure_name => l_program_name,
196: p_var_name => l_debug_info,
197: p_var_value => p_to_uom_code);

Line 211: INL_LOGGING_PVT.Log_Variable (

207: AND msi.organization_id = p_organization_id
208: AND msi.inventory_item_id = p_inventory_item_id;
209:
210: l_debug_info := 'l_primary_uom_code';
211: INL_LOGGING_PVT.Log_Variable (
212: p_module_name => g_module_name,
213: p_procedure_name => l_program_name,
214: p_var_name => l_debug_info,
215: p_var_value => l_primary_uom_code);

Line 217: INL_LOGGING_PVT.Log_Variable (

213: p_procedure_name => l_program_name,
214: p_var_name => l_debug_info,
215: p_var_value => l_primary_uom_code);
216: l_debug_info := 'l_primary_uom_class';
217: INL_LOGGING_PVT.Log_Variable (
218: p_module_name => g_module_name,
219: p_procedure_name => l_program_name,
220: p_var_name => l_debug_info,
221: p_var_value => l_primary_uom_class);

Line 223: INL_LOGGING_PVT.Log_Variable (

219: p_procedure_name => l_program_name,
220: p_var_name => l_debug_info,
221: p_var_value => l_primary_uom_class);
222: l_debug_info := 'l_concatenated_segments';
223: INL_LOGGING_PVT.Log_Variable (
224: p_module_name => g_module_name,
225: p_procedure_name => l_program_name,
226: p_var_name => l_debug_info,
227: p_var_value => l_concatenated_segments);

Line 235: INL_LOGGING_PVT.Log_Variable (

231: FROM mtl_units_of_measure
232: WHERE uom_code = p_from_uom_code;
233:
234: l_debug_info := 'l_from_uom_class';
235: INL_LOGGING_PVT.Log_Variable (
236: p_module_name => g_module_name,
237: p_procedure_name => l_program_name,
238: p_var_name => l_debug_info,
239: p_var_value => l_from_uom_class);

Line 246: INL_LOGGING_PVT.Log_Variable (

242: FROM mtl_units_of_measure
243: WHERE uom_code = p_to_uom_code;
244:
245: l_debug_info := 'l_to_uom_class';
246: INL_LOGGING_PVT.Log_Variable (
247: p_module_name => g_module_name,
248: p_procedure_name => l_program_name,
249: p_var_name => l_debug_info,
250: p_var_value => l_to_uom_class);

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

272: AND organization_id = p_organization_id
273: AND inventory_item_id = p_inventory_item_id;
274:
275: l_debug_info := 'l_converted_price';
276: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
277: p_procedure_name=> l_program_name,
278: p_var_name => l_debug_info,
279: p_var_value => l_converted_price);
280: ELSE

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

298: INTO l_converted_price
299: FROM dual;
300:
301: l_debug_info := 'l_converted_price';
302: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
303: p_procedure_name=> l_program_name,
304: p_var_name => l_debug_info,
305: p_var_value => l_converted_price);
306: END IF;

Line 310: INL_LOGGING_PVT.Log_UnexpecError (

306: END IF;
307: RETURN l_converted_price;
308: EXCEPTION
309: WHEN OTHERS THEN
310: INL_LOGGING_PVT.Log_UnexpecError (
311: p_module_name => g_module_name,
312: p_procedure_name => l_program_name);
313:
314: FND_MESSAGE.SET_NAME('INL','INL_ERR_QTY_CONV');

Line 381: INL_LOGGING_PVT.Log_BeginProc (

377: l_concatenated_segments VARCHAR2(240);
378: l_msg_data VARCHAR2(2000);
379:
380: BEGIN
381: INL_LOGGING_PVT.Log_BeginProc (
382: p_module_name => g_module_name,
383: p_procedure_name => l_program_name
384: );
385:

Line 387: INL_LOGGING_PVT.Log_Variable (

383: p_procedure_name => l_program_name
384: );
385:
386: l_debug_info := 'p_organization_id';
387: INL_LOGGING_PVT.Log_Variable (
388: p_module_name => g_module_name,
389: p_procedure_name => l_program_name,
390: p_var_name => l_debug_info,
391: p_var_value => TO_CHAR(p_organization_id)

Line 395: INL_LOGGING_PVT.Log_Variable (

391: p_var_value => TO_CHAR(p_organization_id)
392: );
393:
394: l_debug_info := 'p_inventory_item_id';
395: INL_LOGGING_PVT.Log_Variable (
396: p_module_name => g_module_name,
397: p_procedure_name => l_program_name,
398: p_var_name => l_debug_info,
399: p_var_value => TO_CHAR(p_inventory_item_id)

Line 403: INL_LOGGING_PVT.Log_Variable (

399: p_var_value => TO_CHAR(p_inventory_item_id)
400: );
401:
402: l_debug_info := 'p_qty';
403: INL_LOGGING_PVT.Log_Variable (
404: p_module_name => g_module_name,
405: p_procedure_name => l_program_name,
406: p_var_name => l_debug_info,
407: p_var_value => TO_CHAR(p_qty)

Line 411: INL_LOGGING_PVT.Log_Variable (

407: p_var_value => TO_CHAR(p_qty)
408: );
409:
410: l_debug_info := 'p_from_uom_code';
411: INL_LOGGING_PVT.Log_Variable (
412: p_module_name => g_module_name,
413: p_procedure_name => l_program_name,
414: p_var_name => l_debug_info,
415: p_var_value => p_from_uom_code

Line 419: INL_LOGGING_PVT.Log_Variable (

415: p_var_value => p_from_uom_code
416: );
417:
418: l_debug_info := 'p_to_uom_code';
419: INL_LOGGING_PVT.Log_Variable (
420: p_module_name => g_module_name,
421: p_procedure_name => l_program_name,
422: p_var_name => l_debug_info,
423: p_var_value => p_to_uom_code

Line 441: INL_LOGGING_PVT.Log_Variable (

437: AND msi.organization_id = p_organization_id
438: AND msi.inventory_item_id = p_inventory_item_id;
439:
440: l_debug_info := 'l_primary_uom_code';
441: INL_LOGGING_PVT.Log_Variable (
442: p_module_name => g_module_name,
443: p_procedure_name => l_program_name,
444: p_var_name => l_debug_info,
445: p_var_value => l_primary_uom_code

Line 449: INL_LOGGING_PVT.Log_Variable (

445: p_var_value => l_primary_uom_code
446: );
447:
448: l_debug_info := 'l_primary_uom_class';
449: INL_LOGGING_PVT.Log_Variable (
450: p_module_name => g_module_name,
451: p_procedure_name => l_program_name,
452: p_var_name => l_debug_info,
453: p_var_value => l_primary_uom_class

Line 462: INL_LOGGING_PVT.Log_Variable (

458: FROM mtl_units_of_measure
459: WHERE uom_code = p_from_uom_code;
460:
461: l_debug_info := 'l_allocation_uom_class';
462: INL_LOGGING_PVT.Log_Variable (
463: p_module_name => g_module_name,
464: p_procedure_name => l_program_name,
465: p_var_name => l_debug_info,
466: p_var_value => l_allocation_uom_class

Line 485: INL_LOGGING_PVT.Log_Statement (

481:
482: EXCEPTION
483: WHEN NO_DATA_FOUND THEN
484: l_debug_info := 'Conversion not found.';
485: INL_LOGGING_PVT.Log_Statement (
486: p_module_name => g_module_name,
487: p_procedure_name => l_program_name,
488: p_debug_info => l_debug_info
489: );

Line 493: INL_LOGGING_PVT.Log_Variable (

489: );
490: RAISE l_conv_not_found_excep;
491: END;
492: l_debug_info := 'l_primary_qty';
493: INL_LOGGING_PVT.Log_Variable (
494: p_module_name => g_module_name,
495: p_procedure_name => l_program_name,
496: p_var_name => l_debug_info,
497: p_var_value => TO_CHAR(l_primary_qty)

Line 506: INL_LOGGING_PVT.Log_Variable (

502: FROM mtl_units_of_measure
503: WHERE uom_code = P_to_uom_code;
504:
505: l_debug_info := 'l_to_allocation_uom_class';
506: INL_LOGGING_PVT.Log_Variable (
507: p_module_name => g_module_name,
508: p_procedure_name => l_program_name,
509: p_var_name => l_debug_info,
510: p_var_value => l_to_allocation_uom_class

Line 528: INL_LOGGING_PVT.Log_Statement (

524:
525: EXCEPTION
526: WHEN NO_DATA_FOUND THEN
527: l_debug_info := 'Conversion not found.';
528: INL_LOGGING_PVT.Log_Statement (
529: p_module_name => g_module_name,
530: p_procedure_name => l_program_name,
531: p_debug_info => l_debug_info
532: );

Line 537: INL_LOGGING_PVT.Log_Variable (

533: RAISE l_conv_not_found_excep;
534: END;
535:
536: l_debug_info := 'l_converted_qty';
537: INL_LOGGING_PVT.Log_Variable (
538: p_module_name => g_module_name,
539: p_procedure_name => l_program_name,
540: p_var_name => l_debug_info,
541: p_var_value => TO_CHAR(l_converted_qty)

Line 544: INL_LOGGING_PVT.Log_EndProc (

540: p_var_name => l_debug_info,
541: p_var_value => TO_CHAR(l_converted_qty)
542: );
543:
544: INL_LOGGING_PVT.Log_EndProc (
545: p_module_name => g_module_name,
546: p_procedure_name => l_program_name
547: );
548:

Line 553: INL_LOGGING_PVT.Log_Statement (

549: RETURN l_converted_qty;
550: EXCEPTION
551: WHEN l_conv_not_found_excep THEN
552: l_debug_info := 'l_conv_not_found_excep Exception.';
553: INL_LOGGING_PVT.Log_Statement (
554: p_module_name => g_module_name,
555: p_procedure_name => l_program_name,
556: p_debug_info => l_debug_info
557: );

Line 558: INL_LOGGING_PVT.Log_UnexpecError (

554: p_module_name => g_module_name,
555: p_procedure_name => l_program_name,
556: p_debug_info => l_debug_info
557: );
558: INL_LOGGING_PVT.Log_UnexpecError (
559: p_module_name => g_module_name,
560: p_procedure_name => l_program_name
561: );
562:

Line 592: INL_LOGGING_PVT.Log_UnexpecError (

588:
589: l_msg_data := FND_MESSAGE.GET;
590: RAISE_APPLICATION_ERROR (-20001, l_msg_data);
591: WHEN OTHERS THEN
592: INL_LOGGING_PVT.Log_UnexpecError (
593: p_module_name => g_module_name,
594: p_procedure_name => l_program_name
595: );
596:

Line 658: INL_LOGGING_PVT.Log_BeginProc (

654: l_conversion_rate NUMBER;
655: BEGIN
656:
657: l_Converted_amt := p_amt;
658: INL_LOGGING_PVT.Log_BeginProc (
659: p_module_name => g_module_name,
660: p_procedure_name => l_program_name);
661:
662: l_converted_amt := Converted_Amt(

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

670: RETURN l_Converted_Amt;
671:
672: EXCEPTION
673: WHEN OTHERS THEN
674: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
675: p_procedure_name => l_program_name);
676: FND_MESSAGE.SET_NAME('INL','INL_ERR_AMT_CONV');
677: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY_CODE',p_from_currency_code);
678: FND_MESSAGE.SET_TOKEN('TO_CURRENCY_CODE',p_to_currency_code);

Line 716: INL_LOGGING_PVT.Log_BeginProc (

712: l_converted_amt NUMBER;
713: l_conversion_rate NUMBER;
714:
715: BEGIN
716: INL_LOGGING_PVT.Log_BeginProc (
717: p_module_name => g_module_name,
718: p_procedure_name => l_program_name);
719:
720: l_Converted_Amt := p_amt;

Line 738: INL_LOGGING_PVT.Log_EndProc (

734: WHEN NO_DATA_FOUND THEN x_currency_conversion_rate := NULL;
735: END;
736: END IF;
737:
738: INL_LOGGING_PVT.Log_EndProc (
739: p_module_name => g_module_name,
740: p_procedure_name => l_program_name);
741:
742: RETURN l_Converted_Amt;

Line 745: INL_LOGGING_PVT.Log_UnexpecError (

741:
742: RETURN l_Converted_Amt;
743: EXCEPTION
744: WHEN OTHERS THEN
745: INL_LOGGING_PVT.Log_UnexpecError (
746: p_module_name => g_module_name,
747: p_procedure_name => l_program_name);
748: FND_MESSAGE.SET_NAME('INL','INL_ERR_AMT_CONV');
749: FND_MESSAGE.SET_TOKEN('FROM_CURRENCY_CODE',p_from_currency_code);

Line 871: INL_LOGGING_PVT.Log_BeginProc (

867: --
868: -- Obtains total amount to be passed to the Manage_Proportion routine
869: --
870: BEGIN
871: INL_LOGGING_PVT.Log_BeginProc (
872: p_module_name => g_module_name,
873: p_procedure_name => l_program_name);
874: --
875: -- Initialize return status to SUCCESS

Line 893: INL_LOGGING_PVT.Log_Statement(

889: FETCH assoc BULK COLLECT INTO assoc_List; --Bulk implem
890: CLOSE assoc;
891:
892: l_debug_info := 'Fetched '||NVL(assoc_List.COUNT, 0)||' association(s).';
893: INL_LOGGING_PVT.Log_Statement(
894: p_module_name => g_module_name,
895: p_procedure_name => l_program_name,
896: p_debug_info => l_debug_info
897: ) ;

Line 919: INL_LOGGING_PVT.Log_Variable (

915: AND (ABS(sl.adjustment_num) <= ABS(p_adjustment_num)
916: --- SCM-051
917: OR sl.ship_header_id <> p_ship_header_id) --Bug#10221931*
918: );
919: INL_LOGGING_PVT.Log_Variable (
920: p_module_name => g_module_name,
921: p_procedure_name => l_program_name,
922: p_var_name => 'A-l_count_aux',
923: p_var_value => l_count_aux);

Line 943: INL_LOGGING_PVT.Log_Variable (

939: AND (ABS(sl.adjustment_num) <= ABS(p_adjustment_num)
940: --- SCM-051
941: OR sl.ship_header_id <> p_ship_header_id) --Bug#10221931*
942: );
943: INL_LOGGING_PVT.Log_Variable (
944: p_module_name => g_module_name,
945: p_procedure_name => l_program_name,
946: p_var_name => 'B-l_count_aux',
947: p_var_value => l_count_aux);

Line 972: INL_LOGGING_PVT.Log_Variable (

968: OR sl.ship_header_id <> p_ship_header_id) --Bug#10221931*
969: );
970: END IF;
971:
972: INL_LOGGING_PVT.Log_Variable (
973: p_module_name => g_module_name,
974: p_procedure_name => l_program_name,
975: p_var_name => 'l_count_aux',
976: p_var_value => l_count_aux);

Line 987: INL_LOGGING_PVT.Log_Variable (

983: INTO l_inv_org_id
984: FROM inl_ship_headers_all
985: WHERE ship_header_id = p_ship_header_id;
986:
987: INL_LOGGING_PVT.Log_Variable (
988: p_module_name => g_module_name,
989: p_procedure_name => l_program_name,
990: p_var_name => 'l_inv_org_id',
991: p_var_value => l_inv_org_id);

Line 993: INL_LOGGING_PVT.Log_Variable (

989: p_procedure_name => l_program_name,
990: p_var_name => 'l_inv_org_id',
991: p_var_value => l_inv_org_id);
992:
993: INL_LOGGING_PVT.Log_Variable (
994: p_module_name => g_module_name,
995: p_procedure_name => l_program_name,
996: p_var_name => 'p_ship_header_id',
997: p_var_value => p_ship_header_id);

Line 999: INL_LOGGING_PVT.Log_Variable (

995: p_procedure_name => l_program_name,
996: p_var_name => 'p_ship_header_id',
997: p_var_value => p_ship_header_id);
998:
999: INL_LOGGING_PVT.Log_Variable (
1000: p_module_name => g_module_name,
1001: p_procedure_name => l_program_name,
1002: p_var_name => 'p_adjustment_num',
1003: p_var_value => p_adjustment_num);

Line 1005: INL_LOGGING_PVT.Log_Variable (

1001: p_procedure_name => l_program_name,
1002: p_var_name => 'p_adjustment_num',
1003: p_var_value => p_adjustment_num);
1004:
1005: INL_LOGGING_PVT.Log_Variable (
1006: p_module_name => g_module_name,
1007: p_procedure_name => l_program_name,
1008: p_var_name => 'p_from_component_name',
1009: p_var_value => p_from_component_name);

Line 1011: INL_LOGGING_PVT.Log_Variable (

1007: p_procedure_name => l_program_name,
1008: p_var_name => 'p_from_component_name',
1009: p_var_value => p_from_component_name);
1010:
1011: INL_LOGGING_PVT.Log_Variable (
1012: p_module_name => g_module_name,
1013: p_procedure_name => l_program_name,
1014: p_var_name => 'p_from_component_id',
1015: p_var_value => p_from_component_id);

Line 1017: INL_LOGGING_PVT.Log_Variable (

1013: p_procedure_name => l_program_name,
1014: p_var_name => 'p_from_component_id',
1015: p_var_value => p_from_component_id);
1016:
1017: INL_LOGGING_PVT.Log_Variable (
1018: p_module_name => g_module_name,
1019: p_procedure_name => l_program_name,
1020: p_var_name => 'p_to_component_name',
1021: p_var_value => p_to_component_name

Line 1024: INL_LOGGING_PVT.Log_Variable (

1020: p_var_name => 'p_to_component_name',
1021: p_var_value => p_to_component_name
1022: );
1023:
1024: INL_LOGGING_PVT.Log_Variable (
1025: p_module_name => g_module_name,
1026: p_procedure_name => l_program_name,
1027: p_var_name => 'p_to_component_id',
1028: p_var_value => p_to_component_name

Line 1031: INL_LOGGING_PVT.Log_Variable (

1027: p_var_name => 'p_to_component_id',
1028: p_var_value => p_to_component_name
1029: );
1030:
1031: INL_LOGGING_PVT.Log_Variable (
1032: p_module_name => g_module_name,
1033: p_procedure_name => l_program_name,
1034: p_var_name => 'p_allocation_basis',
1035: p_var_value => p_allocation_basis

Line 1038: INL_LOGGING_PVT.Log_Variable (

1034: p_var_name => 'p_allocation_basis',
1035: p_var_value => p_allocation_basis
1036: );
1037:
1038: INL_LOGGING_PVT.Log_Variable (
1039: p_module_name => g_module_name,
1040: p_procedure_name => l_program_name,
1041: p_var_name => 'p_allocation_uom_code',
1042: p_var_value => p_allocation_uom_code

Line 1055: INL_LOGGING_PVT.Log_Statement (

1051: -- This is for getting the total amount of each component that an associated amount
1052: -- refers to.
1053: --
1054: l_debug_info := 'p_to_component_name <> INL_SHIP_DISTS';
1055: INL_LOGGING_PVT.Log_Statement (
1056: p_module_name => g_module_name,
1057: p_procedure_name => l_program_name,
1058: p_debug_info => l_debug_info);
1059:

Line 1087: INL_LOGGING_PVT.Log_Variable (

1083: --- SCM-051
1084: OR sl.ship_header_id <> p_ship_header_id) --Bug#10221931*
1085: );
1086: l_debug_info := 'A-l_total_amt';
1087: INL_LOGGING_PVT.Log_Variable (
1088: p_module_name => g_module_name,
1089: p_procedure_name => l_program_name,
1090: p_var_name => l_debug_info,
1091: p_var_value => l_total_amt);

Line 1094: INL_LOGGING_PVT.Log_Variable (

1090: p_var_name => l_debug_info,
1091: p_var_value => l_total_amt);
1092:
1093: l_debug_info := 'A-l_count';
1094: INL_LOGGING_PVT.Log_Variable (
1095: p_module_name => g_module_name,
1096: p_procedure_name => l_program_name,
1097: p_var_name => l_debug_info,
1098: p_var_value => l_count);

Line 1124: INL_LOGGING_PVT.Log_Variable (

1120: --- SCM-051
1121: OR sl.ship_header_id <> p_ship_header_id) --Bug#10221931*
1122: );
1123: l_debug_info := 'B-l_total_amt';
1124: INL_LOGGING_PVT.Log_Variable (
1125: p_module_name => g_module_name,
1126: p_procedure_name => l_program_name,
1127: p_var_name => l_debug_info,
1128: p_var_value => l_total_amt);

Line 1131: INL_LOGGING_PVT.Log_Variable (

1127: p_var_name => l_debug_info,
1128: p_var_value => l_total_amt);
1129:
1130: l_debug_info := 'B-l_count';
1131: INL_LOGGING_PVT.Log_Variable (
1132: p_module_name => g_module_name,
1133: p_procedure_name => l_program_name,
1134: p_var_name => l_debug_info,
1135: p_var_value => l_count);

Line 1151: INL_LOGGING_PVT.Log_Variable (

1147: FROM inl_ship_lines_all ol
1148: WHERE ol.ship_line_id = assoc_List(iAssoc).to_parent_table_id;
1149:
1150: l_debug_info := 'C-l_total_amt';
1151: INL_LOGGING_PVT.Log_Variable (
1152: p_module_name => g_module_name,
1153: p_procedure_name => l_program_name,
1154: p_var_name => l_debug_info,
1155: p_var_value => l_total_amt);

Line 1158: INL_LOGGING_PVT.Log_Variable (

1154: p_var_name => l_debug_info,
1155: p_var_value => l_total_amt);
1156:
1157: l_debug_info := 'C-l_count';
1158: INL_LOGGING_PVT.Log_Variable (
1159: p_module_name => g_module_name,
1160: p_procedure_name => l_program_name,
1161: p_var_name => l_debug_info,
1162: p_var_value => l_count);

Line 1185: INL_LOGGING_PVT.Log_Variable (

1181: RAISE L_FND_EXC_ERROR;
1182: END IF;
1183:
1184: l_debug_info := 'D-l_total_amt';
1185: INL_LOGGING_PVT.Log_Variable (
1186: p_module_name => g_module_name,
1187: p_procedure_name => l_program_name,
1188: p_var_name => l_debug_info,
1189: p_var_value => l_total_amt);

Line 1192: INL_LOGGING_PVT.Log_Variable (

1188: p_var_name => l_debug_info,
1189: p_var_value => l_total_amt);
1190:
1191: l_debug_info := 'D-l_count';
1192: INL_LOGGING_PVT.Log_Variable (
1193: p_module_name => g_module_name,
1194: p_procedure_name => l_program_name,
1195: p_var_name => l_debug_info,
1196: p_var_value => l_count);

Line 1212: INL_LOGGING_PVT.Log_Variable (

1208: FND_MSG_PUB.Add;
1209: RAISE L_FND_EXC_ERROR;
1210: END IF;
1211: l_debug_info := 'E-l_total_amt';
1212: INL_LOGGING_PVT.Log_Variable (
1213: p_module_name => g_module_name,
1214: p_procedure_name => l_program_name,
1215: p_var_name => l_debug_info,
1216: p_var_value => l_total_amt);

Line 1219: INL_LOGGING_PVT.Log_Variable (

1215: p_var_name => l_debug_info,
1216: p_var_value => l_total_amt);
1217:
1218: l_debug_info := 'E-l_count';
1219: INL_LOGGING_PVT.Log_Variable (
1220: p_module_name => g_module_name,
1221: p_procedure_name => l_program_name,
1222: p_var_name => l_debug_info,
1223: p_var_value => l_count);

Line 1232: INL_LOGGING_PVT.Log_Statement (

1228: --
1229: -- This is for getting the total amount of each component the associated amount gets to.
1230: --
1231: l_debug_info := 'p_to_component_name = INL_SHIP_DISTS';
1232: INL_LOGGING_PVT.Log_Statement (
1233: p_module_name => g_module_name,
1234: p_procedure_name => l_program_name,
1235: p_debug_info => l_debug_info);
1236:

Line 1263: INL_LOGGING_PVT.Log_Variable (

1259: --- SCM-051
1260: OR sl.ship_header_id <> p_ship_header_id) --Bug#10221931*
1261: );
1262: l_debug_info := 'F-l_total_amt';
1263: INL_LOGGING_PVT.Log_Variable (
1264: p_module_name => g_module_name,
1265: p_procedure_name => l_program_name,
1266: p_var_name => l_debug_info,
1267: p_var_value => l_total_amt);

Line 1270: INL_LOGGING_PVT.Log_Variable (

1266: p_var_name => l_debug_info,
1267: p_var_value => l_total_amt);
1268:
1269: l_debug_info := 'F-l_count';
1270: INL_LOGGING_PVT.Log_Variable (
1271: p_module_name => g_module_name,
1272: p_procedure_name => l_program_name,
1273: p_var_name => l_debug_info,
1274: p_var_value => l_count);

Line 1282: INL_LOGGING_PVT.Log_Variable (

1278: l_count := l_count_aux;
1279: END IF;
1280: x_total_amt := l_total_amt;
1281: l_debug_info := 'x_total_amt';
1282: INL_LOGGING_PVT.Log_Variable (
1283: p_module_name => g_module_name,
1284: p_procedure_name => l_program_name,
1285: p_var_name => l_debug_info,
1286: p_var_value => TO_CHAR(x_total_amt));

Line 1292: INL_LOGGING_PVT.Log_Variable (

1288: IF l_count > 1 THEN
1289: x_do_proportion := 'Y';
1290: END IF;
1291: l_debug_info := 'x_do_proportion';
1292: INL_LOGGING_PVT.Log_Variable (
1293: p_module_name => g_module_name,
1294: p_procedure_name => l_program_name,
1295: p_var_name => l_debug_info,
1296: p_var_value => x_do_proportion);

Line 1298: INL_LOGGING_PVT.Log_EndProc (

1294: p_procedure_name => l_program_name,
1295: p_var_name => l_debug_info,
1296: p_var_value => x_do_proportion);
1297:
1298: INL_LOGGING_PVT.Log_EndProc (
1299: p_module_name => g_module_name,
1300: p_procedure_name => l_program_name);
1301:
1302: EXCEPTION

Line 1304: INL_LOGGING_PVT.Log_ExpecError (

1300: p_procedure_name => l_program_name);
1301:
1302: EXCEPTION
1303: WHEN L_FND_EXC_ERROR THEN
1304: INL_LOGGING_PVT.Log_ExpecError (
1305: p_module_name => g_module_name,
1306: p_procedure_name => l_program_name
1307: );
1308: x_return_status := L_FND_RET_STS_ERROR;

Line 1310: INL_LOGGING_PVT.Log_UnexpecError (

1306: p_procedure_name => l_program_name
1307: );
1308: x_return_status := L_FND_RET_STS_ERROR;
1309: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
1310: INL_LOGGING_PVT.Log_UnexpecError (
1311: p_module_name => g_module_name,
1312: p_procedure_name => l_program_name
1313: );
1314: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 1316: INL_LOGGING_PVT.Log_UnexpecError (

1312: p_procedure_name => l_program_name
1313: );
1314: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
1315: WHEN OTHERS THEN
1316: INL_LOGGING_PVT.Log_UnexpecError (
1317: p_module_name => g_module_name,
1318: p_procedure_name => l_program_name
1319: );
1320: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 1388: INL_LOGGING_PVT.Log_BeginProc (

1384: -- This routine is also called for prorating a final amount that gets to a
1385: -- landed cost component to its corresponding shipment lines.
1386:
1387: BEGIN
1388: INL_LOGGING_PVT.Log_BeginProc (
1389: p_module_name => g_module_name,
1390: p_procedure_name => l_program_name);
1391: --
1392: -- Initialize return status to SUCCESS

Line 1405: INL_LOGGING_PVT.Log_Variable (

1401: FROM inl_ship_headers_all
1402: WHERE ship_header_id = p_ship_header_id;
1403:
1404:
1405: INL_LOGGING_PVT.Log_Variable (
1406: p_module_name => g_module_name,
1407: p_procedure_name => l_program_name,
1408: p_var_name => 'p_ship_header_id',
1409: p_var_value => p_ship_header_id

Line 1412: INL_LOGGING_PVT.Log_Variable (

1408: p_var_name => 'p_ship_header_id',
1409: p_var_value => p_ship_header_id
1410: );
1411:
1412: INL_LOGGING_PVT.Log_Variable (
1413: p_module_name => g_module_name,
1414: p_procedure_name => l_program_name,
1415: p_var_name => 'p_adjustment_num',
1416: p_var_value => p_adjustment_num

Line 1419: INL_LOGGING_PVT.Log_Variable (

1415: p_var_name => 'p_adjustment_num',
1416: p_var_value => p_adjustment_num
1417: );
1418:
1419: INL_LOGGING_PVT.Log_Variable (
1420: p_module_name => g_module_name,
1421: p_procedure_name => l_program_name,
1422: p_var_name => 'p_from_component_name',
1423: p_var_value => p_from_component_name

Line 1426: INL_LOGGING_PVT.Log_Variable (

1422: p_var_name => 'p_from_component_name',
1423: p_var_value => p_from_component_name
1424: );
1425:
1426: INL_LOGGING_PVT.Log_Variable (
1427: p_module_name => g_module_name,
1428: p_procedure_name => l_program_name,
1429: p_var_name => 'p_from_component_id',
1430: p_var_value => p_from_component_id

Line 1433: INL_LOGGING_PVT.Log_Variable (

1429: p_var_name => 'p_from_component_id',
1430: p_var_value => p_from_component_id
1431: );
1432:
1433: INL_LOGGING_PVT.Log_Variable (
1434: p_module_name => g_module_name,
1435: p_procedure_name => l_program_name,
1436: p_var_name => 'p_to_component_name',
1437: p_var_value => p_to_component_name

Line 1440: INL_LOGGING_PVT.Log_Variable (

1436: p_var_name => 'p_to_component_name',
1437: p_var_value => p_to_component_name
1438: );
1439:
1440: INL_LOGGING_PVT.Log_Variable (
1441: p_module_name => g_module_name,
1442: p_procedure_name => l_program_name,
1443: p_var_name => 'p_to_component_id',
1444: p_var_value => p_to_component_id

Line 1447: INL_LOGGING_PVT.Log_Variable (

1443: p_var_name => 'p_to_component_id',
1444: p_var_value => p_to_component_id
1445: );
1446:
1447: INL_LOGGING_PVT.Log_Variable (
1448: p_module_name => g_module_name,
1449: p_procedure_name => l_program_name,
1450: p_var_name => 'p_allocation_basis',
1451: p_var_value => p_allocation_basis

Line 1454: INL_LOGGING_PVT.Log_Variable (

1450: p_var_name => 'p_allocation_basis',
1451: p_var_value => p_allocation_basis
1452: );
1453:
1454: INL_LOGGING_PVT.Log_Variable (
1455: p_module_name => g_module_name,
1456: p_procedure_name => l_program_name,
1457: p_var_name => 'p_allocation_uom_code',
1458: p_var_value => p_allocation_uom_code

Line 1461: INL_LOGGING_PVT.Log_Variable (

1457: p_var_name => 'p_allocation_uom_code',
1458: p_var_value => p_allocation_uom_code
1459: );
1460:
1461: INL_LOGGING_PVT.Log_Variable (
1462: p_module_name => g_module_name,
1463: p_procedure_name => l_program_name,
1464: p_var_name => 'p_to_component_name',
1465: p_var_value => p_to_component_name

Line 1468: INL_LOGGING_PVT.Log_Variable (

1464: p_var_name => 'p_to_component_name',
1465: p_var_value => p_to_component_name
1466: );
1467:
1468: INL_LOGGING_PVT.Log_Variable (
1469: p_module_name => g_module_name,
1470: p_procedure_name => l_program_name,
1471: p_var_name => 'p_total_amt',
1472: p_var_value => p_total_amt

Line 1562: INL_LOGGING_PVT.Log_Variable (

1558: END IF;
1559: END IF;
1560:
1561: l_debug_info := 'l_to_component_amt';
1562: INL_LOGGING_PVT.Log_Variable (
1563: p_module_name => g_module_name,
1564: p_procedure_name => l_program_name,
1565: p_var_name => l_debug_info,
1566: p_var_value => TO_CHAR(l_to_component_amt));

Line 1578: INL_LOGGING_PVT.Log_Statement (

1574: ELSE
1575: l_debug_info := 'Component not allocated';
1576: o_factor := 0;
1577: END IF;
1578: INL_LOGGING_PVT.Log_Statement (
1579: p_module_name => g_module_name,
1580: p_procedure_name => l_program_name,
1581: p_debug_info => l_debug_info);
1582: ELSE

Line 1595: INL_LOGGING_PVT.Log_Variable (

1591: END IF;
1592: END IF;
1593:
1594: l_debug_info := 'o_factor';
1595: INL_LOGGING_PVT.Log_Variable (
1596: p_module_name => g_module_name,
1597: p_procedure_name => l_program_name,
1598: p_var_name => l_debug_info,
1599: p_var_value => TO_CHAR(o_factor));

Line 1601: INL_LOGGING_PVT.Log_EndProc (

1597: p_procedure_name => l_program_name,
1598: p_var_name => l_debug_info,
1599: p_var_value => TO_CHAR(o_factor));
1600:
1601: INL_LOGGING_PVT.Log_EndProc (
1602: p_module_name => g_module_name,
1603: p_procedure_name => l_program_name);
1604:
1605: EXCEPTION

Line 1607: INL_LOGGING_PVT.Log_ExpecError (

1603: p_procedure_name => l_program_name);
1604:
1605: EXCEPTION
1606: WHEN L_FND_EXC_ERROR THEN
1607: INL_LOGGING_PVT.Log_ExpecError (
1608: p_module_name => g_module_name,
1609: p_procedure_name => l_program_name
1610: );
1611: x_return_status := L_FND_RET_STS_ERROR;

Line 1613: INL_LOGGING_PVT.Log_UnexpecError (

1609: p_procedure_name => l_program_name
1610: );
1611: x_return_status := L_FND_RET_STS_ERROR;
1612: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
1613: INL_LOGGING_PVT.Log_UnexpecError (
1614: p_module_name => g_module_name,
1615: p_procedure_name => l_program_name
1616: );
1617: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 1619: INL_LOGGING_PVT.Log_UnexpecError (

1615: p_procedure_name => l_program_name
1616: );
1617: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
1618: WHEN OTHERS THEN
1619: INL_LOGGING_PVT.Log_UnexpecError (
1620: p_module_name => g_module_name,
1621: p_procedure_name => l_program_name
1622: );
1623: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 1744: INL_LOGGING_PVT.Log_BeginProc (

1740: assoc_List assoc_ListType; --Bulk implem
1741:
1742: BEGIN
1743:
1744: INL_LOGGING_PVT.Log_BeginProc (
1745: p_module_name => g_module_name,
1746: p_procedure_name => l_program_name);
1747:
1748: --

Line 1753: INL_LOGGING_PVT.Log_Variable (

1749: -- Initialize return status to SUCCESS
1750: --
1751: x_return_status := L_FND_RET_STS_SUCCESS;
1752:
1753: INL_LOGGING_PVT.Log_Variable (
1754: p_module_name => g_module_name,
1755: p_procedure_name => l_program_name,
1756: p_var_name => 'p_ship_header_id',
1757: p_var_value => p_ship_header_id);

Line 1758: INL_LOGGING_PVT.Log_Variable (

1754: p_module_name => g_module_name,
1755: p_procedure_name => l_program_name,
1756: p_var_name => 'p_ship_header_id',
1757: p_var_value => p_ship_header_id);
1758: INL_LOGGING_PVT.Log_Variable (
1759: p_module_name => g_module_name,
1760: p_procedure_name => l_program_name,
1761: p_var_name => 'p_le_currency_code',
1762: p_var_value => p_le_currency_code);

Line 1763: INL_LOGGING_PVT.Log_Variable (

1759: p_module_name => g_module_name,
1760: p_procedure_name => l_program_name,
1761: p_var_name => 'p_le_currency_code',
1762: p_var_value => p_le_currency_code);
1763: INL_LOGGING_PVT.Log_Variable (
1764: p_module_name => g_module_name,
1765: p_procedure_name => l_program_name,
1766: p_var_name => 'p_association_id',
1767: p_var_value => p_association_id);

Line 1768: INL_LOGGING_PVT.Log_Variable (

1764: p_module_name => g_module_name,
1765: p_procedure_name => l_program_name,
1766: p_var_name => 'p_association_id',
1767: p_var_value => p_association_id);
1768: INL_LOGGING_PVT.Log_Variable (
1769: p_module_name => g_module_name,
1770: p_procedure_name => l_program_name,
1771: p_var_name => 'p_ship_line_id',
1772: p_var_value => p_ship_line_id);

Line 1773: INL_LOGGING_PVT.Log_Variable (

1769: p_module_name => g_module_name,
1770: p_procedure_name => l_program_name,
1771: p_var_name => 'p_ship_line_id',
1772: p_var_value => p_ship_line_id);
1773: INL_LOGGING_PVT.Log_Variable (
1774: p_module_name => g_module_name,
1775: p_procedure_name => l_program_name,
1776: p_var_name => 'p_amount',
1777: p_var_value => p_amount);

Line 1778: INL_LOGGING_PVT.Log_Variable (

1774: p_module_name => g_module_name,
1775: p_procedure_name => l_program_name,
1776: p_var_name => 'p_amount',
1777: p_var_value => p_amount);
1778: INL_LOGGING_PVT.Log_Variable (
1779: p_module_name => g_module_name,
1780: p_procedure_name => l_program_name,
1781: p_var_name => 'p_from_component_name',
1782: p_var_value => p_from_component_name);

Line 1783: INL_LOGGING_PVT.Log_Variable (

1779: p_module_name => g_module_name,
1780: p_procedure_name => l_program_name,
1781: p_var_name => 'p_from_component_name',
1782: p_var_value => p_from_component_name);
1783: INL_LOGGING_PVT.Log_Variable (
1784: p_module_name => g_module_name,
1785: p_procedure_name => l_program_name,
1786: p_var_name => 'p_from_component_id',
1787: p_var_value => p_from_component_id);

Line 1788: INL_LOGGING_PVT.Log_Variable (

1784: p_module_name => g_module_name,
1785: p_procedure_name => l_program_name,
1786: p_var_name => 'p_from_component_id',
1787: p_var_value => p_from_component_id);
1788: INL_LOGGING_PVT.Log_Variable (
1789: p_module_name => g_module_name,
1790: p_procedure_name => l_program_name,
1791: p_var_name => 'p_to_component_name',
1792: p_var_value => p_to_component_name);

Line 1793: INL_LOGGING_PVT.Log_Variable (

1789: p_module_name => g_module_name,
1790: p_procedure_name => l_program_name,
1791: p_var_name => 'p_to_component_name',
1792: p_var_value => p_to_component_name);
1793: INL_LOGGING_PVT.Log_Variable (
1794: p_module_name => g_module_name,
1795: p_procedure_name => l_program_name,
1796: p_var_name => 'p_to_component_id',
1797: p_var_value => p_to_component_id);

Line 1798: INL_LOGGING_PVT.Log_Variable (

1794: p_module_name => g_module_name,
1795: p_procedure_name => l_program_name,
1796: p_var_name => 'p_to_component_id',
1797: p_var_value => p_to_component_id);
1798: INL_LOGGING_PVT.Log_Variable (
1799: p_module_name => g_module_name,
1800: p_procedure_name => l_program_name,
1801: p_var_name => 'p_lc_flag',
1802: p_var_value => p_lc_flag);

Line 1803: INL_LOGGING_PVT.Log_Variable (

1799: p_module_name => g_module_name,
1800: p_procedure_name => l_program_name,
1801: p_var_name => 'p_lc_flag',
1802: p_var_value => p_lc_flag);
1803: INL_LOGGING_PVT.Log_Variable (
1804: p_module_name => g_module_name,
1805: p_procedure_name => l_program_name,
1806: p_var_name => 'p_adjustment_num',
1807: p_var_value => p_adjustment_num);

Line 1826: INL_LOGGING_PVT.Log_Variable (

1822: END;
1823: */
1824: l_ship_line_lc_flag := 'Y';
1825: --
1826: INL_LOGGING_PVT.Log_Variable (
1827: p_module_name => g_module_name,
1828: p_procedure_name => l_program_name,
1829: p_var_name => 'l_ship_line_lc_flag',
1830: p_var_value => l_ship_line_lc_flag);

Line 1845: INL_LOGGING_PVT.Log_Statement (

1841: END IF;
1842:
1843: -- Check whether the Ship Line of the allocation is associated to other Ship Lines
1844: l_debug_info := 'Check whether the Ship Line of the allocation is associated to other Ship Lines';
1845: INL_LOGGING_PVT.Log_Statement (
1846: p_module_name => g_module_name,
1847: p_procedure_name => l_program_name,
1848: p_debug_info => l_debug_info);
1849:

Line 1864: INL_LOGGING_PVT.Log_Statement(

1860: FETCH assoc BULK COLLECT INTO assoc_List; --Bulk implem
1861: CLOSE assoc;
1862:
1863: l_debug_info := 'Fetched '||NVL(assoc_List.COUNT, 0)||' association(s).';
1864: INL_LOGGING_PVT.Log_Statement(
1865: p_module_name => g_module_name,
1866: p_procedure_name => l_program_name,
1867: p_debug_info => l_debug_info
1868: ) ;

Line 1879: INL_LOGGING_PVT.Log_Statement (

1875:
1876: IF p_amount <> 0 THEN
1877: IF l_count = 1 THEN
1878: l_debug_info := 'Call Get_TotalAmt';
1879: INL_LOGGING_PVT.Log_Statement (
1880: p_module_name => g_module_name,
1881: p_procedure_name => l_program_name,
1882: p_debug_info => l_debug_info);
1883: Get_TotalAmt (

Line 1905: INL_LOGGING_PVT.Log_Statement (

1901: END IF;
1902: END IF;
1903: IF l_do_proportion = 'Y' THEN
1904: l_debug_info := 'Call Manage_Proportion';
1905: INL_LOGGING_PVT.Log_Statement (
1906: p_module_name => g_module_name,
1907: p_procedure_name => l_program_name,
1908: p_debug_info => l_debug_info);
1909: Manage_Proportion (

Line 1936: INL_LOGGING_PVT.Log_Variable (

1932: l_factor := 0;
1933: END IF;
1934:
1935: l_debug_info := 'l_factor';
1936: INL_LOGGING_PVT.Log_Variable (
1937: p_module_name => g_module_name,
1938: p_procedure_name => l_program_name,
1939: p_var_name => l_debug_info,
1940: p_var_value => TO_CHAR(l_factor));

Line 1943: INL_LOGGING_PVT.Log_Statement (

1939: p_var_name => l_debug_info,
1940: p_var_value => TO_CHAR(l_factor));
1941:
1942: l_debug_info := 'Inserting into inl_allocations';
1943: INL_LOGGING_PVT.Log_Statement (
1944: p_module_name => g_module_name,
1945: p_procedure_name => l_program_name,
1946: p_debug_info => l_debug_info);
1947:

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

1945: p_procedure_name => l_program_name,
1946: p_debug_info => l_debug_info);
1947:
1948: l_debug_info := 'assoc_List('||iAssoc||').to_parent_table_id';
1949: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1950: p_procedure_name => l_program_name,
1951: p_var_name => l_debug_info,
1952: p_var_value => TO_CHAR(assoc_List(iAssoc).to_parent_table_id));
1953:

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

1951: p_var_name => l_debug_info,
1952: p_var_value => TO_CHAR(assoc_List(iAssoc).to_parent_table_id));
1953:
1954: l_debug_info := 'p_amount * l_factor';
1955: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1956: p_procedure_name => l_program_name,
1957: p_var_name => l_debug_info,
1958: p_var_value => TO_CHAR(p_amount * l_factor));
1959:

Line 1986: INL_LOGGING_PVT.Log_Statement (

1982: END IF;
1983: END IF;
1984: IF l_count = 0 THEN
1985: l_debug_info := 'Inserting into inl_allocations';
1986: INL_LOGGING_PVT.Log_Statement (
1987: p_module_name => g_module_name,
1988: p_procedure_name => l_program_name,
1989: p_debug_info => l_debug_info);
1990: INL_LOGGING_PVT.Log_Variable (

Line 1990: INL_LOGGING_PVT.Log_Variable (

1986: INL_LOGGING_PVT.Log_Statement (
1987: p_module_name => g_module_name,
1988: p_procedure_name => l_program_name,
1989: p_debug_info => l_debug_info);
1990: INL_LOGGING_PVT.Log_Variable (
1991: p_module_name => g_module_name,
1992: p_procedure_name => l_program_name,
1993: p_var_name => 'p_ship_line_id',
1994: p_var_value => p_ship_line_id);

Line 1995: INL_LOGGING_PVT.Log_Variable (

1991: p_module_name => g_module_name,
1992: p_procedure_name => l_program_name,
1993: p_var_name => 'p_ship_line_id',
1994: p_var_value => p_ship_line_id);
1995: INL_LOGGING_PVT.Log_Variable (
1996: p_module_name => g_module_name,
1997: p_procedure_name => l_program_name,
1998: p_var_name => 'p_amount',
1999: p_var_value => p_amount);

Line 2039: INL_LOGGING_PVT.Log_EndProc (

2035: SYSDATE, /* 15 */
2036: L_FND_LOGIN_ID); /* 16 */
2037: END IF;
2038:
2039: INL_LOGGING_PVT.Log_EndProc (
2040: p_module_name => g_module_name,
2041: p_procedure_name => l_program_name);
2042:
2043: EXCEPTION

Line 2045: INL_LOGGING_PVT.Log_ExpecError (

2041: p_procedure_name => l_program_name);
2042:
2043: EXCEPTION
2044: WHEN L_FND_EXC_ERROR THEN
2045: INL_LOGGING_PVT.Log_ExpecError (
2046: p_module_name => g_module_name,
2047: p_procedure_name => l_program_name);
2048: x_return_status := L_FND_RET_STS_ERROR;
2049: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN

Line 2050: INL_LOGGING_PVT.Log_UnexpecError (

2046: p_module_name => g_module_name,
2047: p_procedure_name => l_program_name);
2048: x_return_status := L_FND_RET_STS_ERROR;
2049: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
2050: INL_LOGGING_PVT.Log_UnexpecError (
2051: p_module_name => g_module_name,
2052: p_procedure_name => l_program_name);
2053: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2054: WHEN OTHERS THEN

Line 2055: INL_LOGGING_PVT.Log_UnexpecError (

2051: p_module_name => g_module_name,
2052: p_procedure_name => l_program_name);
2053: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2054: WHEN OTHERS THEN
2055: INL_LOGGING_PVT.Log_UnexpecError (
2056: p_module_name => g_module_name,
2057: p_procedure_name => l_program_name);
2058: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2059: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2159: INL_LOGGING_PVT.Log_BeginProc (

2155: l_total_amt NUMBER;
2156: l_do_proportion VARCHAR2(1);
2157:
2158: BEGIN
2159: INL_LOGGING_PVT.Log_BeginProc (
2160: p_module_name => g_module_name,
2161: p_procedure_name => l_program_name);
2162: --
2163: -- Initialize return status to SUCCESS

Line 2166: INL_LOGGING_PVT.Log_Variable (

2162: --
2163: -- Initialize return status to SUCCESS
2164: --
2165: x_return_status := L_FND_RET_STS_SUCCESS;
2166: INL_LOGGING_PVT.Log_Variable (
2167: p_module_name => g_module_name,
2168: p_procedure_name => l_program_name,
2169: p_var_name => 'p_ship_header_id',
2170: p_var_value => p_ship_header_id);

Line 2171: INL_LOGGING_PVT.Log_Variable (

2167: p_module_name => g_module_name,
2168: p_procedure_name => l_program_name,
2169: p_var_name => 'p_ship_header_id',
2170: p_var_value => p_ship_header_id);
2171: INL_LOGGING_PVT.Log_Variable (
2172: p_module_name => g_module_name,
2173: p_procedure_name => l_program_name,
2174: p_var_name => 'p_le_currency_code',
2175: p_var_value => p_le_currency_code);

Line 2176: INL_LOGGING_PVT.Log_Variable (

2172: p_module_name => g_module_name,
2173: p_procedure_name => l_program_name,
2174: p_var_name => 'p_le_currency_code',
2175: p_var_value => p_le_currency_code);
2176: INL_LOGGING_PVT.Log_Variable (
2177: p_module_name => g_module_name,
2178: p_procedure_name => l_program_name,
2179: p_var_name => 'p_association_id',
2180: p_var_value => p_association_id);

Line 2181: INL_LOGGING_PVT.Log_Variable (

2177: p_module_name => g_module_name,
2178: p_procedure_name => l_program_name,
2179: p_var_name => 'p_association_id',
2180: p_var_value => p_association_id);
2181: INL_LOGGING_PVT.Log_Variable (
2182: p_module_name => g_module_name,
2183: p_procedure_name => l_program_name,
2184: p_var_name => 'p_allocation_basis',
2185: p_var_value => p_allocation_basis);

Line 2186: INL_LOGGING_PVT.Log_Variable (

2182: p_module_name => g_module_name,
2183: p_procedure_name => l_program_name,
2184: p_var_name => 'p_allocation_basis',
2185: p_var_value => p_allocation_basis);
2186: INL_LOGGING_PVT.Log_Variable (
2187: p_module_name => g_module_name,
2188: p_procedure_name => l_program_name,
2189: p_var_name => 'p_allocation_uom_code',
2190: p_var_value => p_allocation_uom_code);

Line 2191: INL_LOGGING_PVT.Log_Variable (

2187: p_module_name => g_module_name,
2188: p_procedure_name => l_program_name,
2189: p_var_name => 'p_allocation_uom_code',
2190: p_var_value => p_allocation_uom_code);
2191: INL_LOGGING_PVT.Log_Variable (
2192: p_module_name => g_module_name,
2193: p_procedure_name => l_program_name,
2194: p_var_name => 'p_amount',
2195: p_var_value => p_amount);

Line 2196: INL_LOGGING_PVT.Log_Variable (

2192: p_module_name => g_module_name,
2193: p_procedure_name => l_program_name,
2194: p_var_name => 'p_amount',
2195: p_var_value => p_amount);
2196: INL_LOGGING_PVT.Log_Variable (
2197: p_module_name => g_module_name,
2198: p_procedure_name => l_program_name,
2199: p_var_name => 'p_from_component_name',
2200: p_var_value => p_from_component_name);

Line 2201: INL_LOGGING_PVT.Log_Variable (

2197: p_module_name => g_module_name,
2198: p_procedure_name => l_program_name,
2199: p_var_name => 'p_from_component_name',
2200: p_var_value => p_from_component_name);
2201: INL_LOGGING_PVT.Log_Variable (
2202: p_module_name => g_module_name,
2203: p_procedure_name => l_program_name,
2204: p_var_name => 'p_from_component_id',
2205: p_var_value => p_from_component_id);

Line 2206: INL_LOGGING_PVT.Log_Variable (

2202: p_module_name => g_module_name,
2203: p_procedure_name => l_program_name,
2204: p_var_name => 'p_from_component_id',
2205: p_var_value => p_from_component_id);
2206: INL_LOGGING_PVT.Log_Variable (
2207: p_module_name => g_module_name,
2208: p_procedure_name => l_program_name,
2209: p_var_name => 'p_to_component_name',
2210: p_var_value => p_to_component_name);

Line 2211: INL_LOGGING_PVT.Log_Variable (

2207: p_module_name => g_module_name,
2208: p_procedure_name => l_program_name,
2209: p_var_name => 'p_to_component_name',
2210: p_var_value => p_to_component_name);
2211: INL_LOGGING_PVT.Log_Variable (
2212: p_module_name => g_module_name,
2213: p_procedure_name => l_program_name,
2214: p_var_name => 'p_to_component_id',
2215: p_var_value => p_to_component_id);

Line 2216: INL_LOGGING_PVT.Log_Variable (

2212: p_module_name => g_module_name,
2213: p_procedure_name => l_program_name,
2214: p_var_name => 'p_to_component_id',
2215: p_var_value => p_to_component_id);
2216: INL_LOGGING_PVT.Log_Variable (
2217: p_module_name => g_module_name,
2218: p_procedure_name => l_program_name,
2219: p_var_name => 'p_adjustment_num',
2220: p_var_value => p_adjustment_num);

Line 2254: INL_LOGGING_PVT.Log_Statement(

2250: FETCH dist BULK COLLECT INTO dist_List; --Bulk implem
2251: CLOSE dist;
2252:
2253: l_debug_info := 'Fetched '||NVL(dist_List.COUNT, 0)||' Line(s).';
2254: INL_LOGGING_PVT.Log_Statement(
2255: p_module_name => g_module_name,
2256: p_procedure_name => l_program_name,
2257: p_debug_info => l_debug_info
2258: ) ;

Line 2272: INL_LOGGING_PVT.Log_Statement (

2268: IF l_count = 1 THEN
2269: -- in case of FROM and TO in ('INL_SHIP_DISTS','INL_SHIP_LINES')
2270: -- AND FROM_id = TO_id it is about an allocation from one line to the same line
2271: l_debug_info := 'Call Get_TotalAmt';
2272: INL_LOGGING_PVT.Log_Statement (
2273: p_module_name => g_module_name,
2274: p_procedure_name => l_program_name,
2275: p_debug_info => l_debug_info);
2276: Get_TotalAmt (

Line 2298: INL_LOGGING_PVT.Log_Statement (

2294: END IF;
2295: END IF;
2296: IF l_do_proportion = 'Y' THEN
2297: l_debug_info := 'Call Manage_Proportion';
2298: INL_LOGGING_PVT.Log_Statement (
2299: p_module_name => g_module_name,
2300: p_procedure_name => l_program_name,
2301: p_debug_info => l_debug_info);
2302: Manage_Proportion (

Line 2352: INL_LOGGING_PVT.Log_EndProc (

2348:
2349: END LOOP;
2350: END IF;
2351: END IF;
2352: INL_LOGGING_PVT.Log_EndProc (
2353: p_module_name => g_module_name,
2354: p_procedure_name => l_program_name);
2355:
2356: EXCEPTION

Line 2358: INL_LOGGING_PVT.Log_ExpecError (

2354: p_procedure_name => l_program_name);
2355:
2356: EXCEPTION
2357: WHEN L_FND_EXC_ERROR THEN
2358: INL_LOGGING_PVT.Log_ExpecError (
2359: p_module_name => g_module_name,
2360: p_procedure_name => l_program_name);
2361: x_return_status := L_FND_RET_STS_ERROR;
2362: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN

Line 2363: INL_LOGGING_PVT.Log_UnexpecError (

2359: p_module_name => g_module_name,
2360: p_procedure_name => l_program_name);
2361: x_return_status := L_FND_RET_STS_ERROR;
2362: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
2363: INL_LOGGING_PVT.Log_UnexpecError (
2364: p_module_name => g_module_name,
2365: p_procedure_name => l_program_name);
2366: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2367: WHEN OTHERS THEN

Line 2368: INL_LOGGING_PVT.Log_UnexpecError (

2364: p_module_name => g_module_name,
2365: p_procedure_name => l_program_name);
2366: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2367: WHEN OTHERS THEN
2368: INL_LOGGING_PVT.Log_UnexpecError (
2369: p_module_name => g_module_name,
2370: p_procedure_name => l_program_name);
2371: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2372: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2559: INL_LOGGING_PVT.Log_BeginProc (

2555: l_total_amt NUMBER;
2556: l_do_proportion VARCHAR2(1);
2557: BEGIN
2558:
2559: INL_LOGGING_PVT.Log_BeginProc (
2560: p_module_name => g_module_name,
2561: p_procedure_name => l_program_name);
2562: --
2563: -- Initialize return status to SUCCESS

Line 2570: INL_LOGGING_PVT.Log_Variable (

2566: x_return_status := L_FND_RET_STS_SUCCESS;
2567:
2568: l_next_level_allocation := 'N';
2569:
2570: INL_LOGGING_PVT.Log_Variable (
2571: p_module_name => g_module_name,
2572: p_procedure_name => l_program_name,
2573: p_var_name => 'p_ship_header_id',
2574: p_var_value => p_ship_header_id);

Line 2575: INL_LOGGING_PVT.Log_Variable (

2571: p_module_name => g_module_name,
2572: p_procedure_name => l_program_name,
2573: p_var_name => 'p_ship_header_id',
2574: p_var_value => p_ship_header_id);
2575: INL_LOGGING_PVT.Log_Variable (
2576: p_module_name => g_module_name,
2577: p_procedure_name => l_program_name,
2578: p_var_name => 'p_le_currency_code',
2579: p_var_value => p_le_currency_code);

Line 2580: INL_LOGGING_PVT.Log_Variable (

2576: p_module_name => g_module_name,
2577: p_procedure_name => l_program_name,
2578: p_var_name => 'p_le_currency_code',
2579: p_var_value => p_le_currency_code);
2580: INL_LOGGING_PVT.Log_Variable (
2581: p_module_name => g_module_name,
2582: p_procedure_name => l_program_name,
2583: p_var_name => 'p_association_id',
2584: p_var_value => p_association_id);

Line 2585: INL_LOGGING_PVT.Log_Variable (

2581: p_module_name => g_module_name,
2582: p_procedure_name => l_program_name,
2583: p_var_name => 'p_association_id',
2584: p_var_value => p_association_id);
2585: INL_LOGGING_PVT.Log_Variable (
2586: p_module_name => g_module_name,
2587: p_procedure_name => l_program_name,
2588: p_var_name => 'p_allocation_basis',
2589: p_var_value => p_allocation_basis);

Line 2590: INL_LOGGING_PVT.Log_Variable (

2586: p_module_name => g_module_name,
2587: p_procedure_name => l_program_name,
2588: p_var_name => 'p_allocation_basis',
2589: p_var_value => p_allocation_basis);
2590: INL_LOGGING_PVT.Log_Variable (
2591: p_module_name => g_module_name,
2592: p_procedure_name => l_program_name,
2593: p_var_name => 'p_allocation_uom_code',
2594: p_var_value => p_allocation_uom_code);

Line 2595: INL_LOGGING_PVT.Log_Variable (

2591: p_module_name => g_module_name,
2592: p_procedure_name => l_program_name,
2593: p_var_name => 'p_allocation_uom_code',
2594: p_var_value => p_allocation_uom_code);
2595: INL_LOGGING_PVT.Log_Variable (
2596: p_module_name => g_module_name,
2597: p_procedure_name => l_program_name,
2598: p_var_name => 'p_amount',
2599: p_var_value => p_amount);

Line 2600: INL_LOGGING_PVT.Log_Variable (

2596: p_module_name => g_module_name,
2597: p_procedure_name => l_program_name,
2598: p_var_name => 'p_amount',
2599: p_var_value => p_amount);
2600: INL_LOGGING_PVT.Log_Variable (
2601: p_module_name => g_module_name,
2602: p_procedure_name => l_program_name,
2603: p_var_name => 'p_from_component_name',
2604: p_var_value => p_from_component_name);

Line 2605: INL_LOGGING_PVT.Log_Variable (

2601: p_module_name => g_module_name,
2602: p_procedure_name => l_program_name,
2603: p_var_name => 'p_from_component_name',
2604: p_var_value => p_from_component_name);
2605: INL_LOGGING_PVT.Log_Variable (
2606: p_module_name => g_module_name,
2607: p_procedure_name => l_program_name,
2608: p_var_name => 'p_from_component_id',
2609: p_var_value => p_from_component_id);

Line 2610: INL_LOGGING_PVT.Log_Variable (

2606: p_module_name => g_module_name,
2607: p_procedure_name => l_program_name,
2608: p_var_name => 'p_from_component_id',
2609: p_var_value => p_from_component_id);
2610: INL_LOGGING_PVT.Log_Variable (
2611: p_module_name => g_module_name,
2612: p_procedure_name => l_program_name,
2613: p_var_name => 'p_to_component_name',
2614: p_var_value => p_to_component_name);

Line 2615: INL_LOGGING_PVT.Log_Variable (

2611: p_module_name => g_module_name,
2612: p_procedure_name => l_program_name,
2613: p_var_name => 'p_to_component_name',
2614: p_var_value => p_to_component_name);
2615: INL_LOGGING_PVT.Log_Variable (
2616: p_module_name => g_module_name,
2617: p_procedure_name => l_program_name,
2618: p_var_name => 'p_to_component_id',
2619: p_var_value => p_to_component_id);

Line 2620: INL_LOGGING_PVT.Log_Variable (

2616: p_module_name => g_module_name,
2617: p_procedure_name => l_program_name,
2618: p_var_name => 'p_to_component_id',
2619: p_var_value => p_to_component_id);
2620: INL_LOGGING_PVT.Log_Variable (
2621: p_module_name => g_module_name,
2622: p_procedure_name => l_program_name,
2623: p_var_name => 'p_adjustment_num',
2624: p_var_value => p_adjustment_num);

Line 2631: INL_LOGGING_PVT.Log_Statement(

2627: FETCH component BULK COLLECT INTO component_List; --Bulk implem
2628: CLOSE component;
2629:
2630: l_debug_info := 'Fetched '||NVL(component_List.COUNT, 0)||' component(s).';
2631: INL_LOGGING_PVT.Log_Statement(
2632: p_module_name => g_module_name,
2633: p_procedure_name => l_program_name,
2634: p_debug_info => l_debug_info
2635: ) ;

Line 2650: INL_LOGGING_PVT.Log_Statement(

2646: FETCH assoc BULK COLLECT INTO assoc_List; --Bulk implem
2647: CLOSE assoc;
2648:
2649: l_debug_info := 'Fetched '||NVL(assoc_List.COUNT, 0)||' association(s).';
2650: INL_LOGGING_PVT.Log_Statement(
2651: p_module_name => g_module_name,
2652: p_procedure_name => l_program_name,
2653: p_debug_info => l_debug_info
2654: ) ;

Line 2667: INL_LOGGING_PVT.Log_Statement (

2663:
2664: IF p_amount <> 0 THEN
2665: IF l_count = 1 THEN
2666: l_debug_info := 'Call Get_TotalAmt';
2667: INL_LOGGING_PVT.Log_Statement (
2668: p_module_name => g_module_name,
2669: p_procedure_name => l_program_name,
2670: p_debug_info => l_debug_info);
2671: Get_TotalAmt (

Line 2693: INL_LOGGING_PVT.Log_Statement (

2689: END IF;
2690: END IF;
2691: IF l_do_proportion = 'Y' THEN
2692: l_debug_info := 'Call Manage_Proportion';
2693: INL_LOGGING_PVT.Log_Statement (
2694: p_module_name => g_module_name,
2695: p_procedure_name => l_program_name,
2696: p_debug_info => l_debug_info);
2697: Manage_Proportion (

Line 2754: INL_LOGGING_PVT.Log_Variable (

2750: END IF;
2751: END LOOP;
2752: END IF;
2753:
2754: INL_LOGGING_PVT.Log_Variable (
2755: p_module_name => g_module_name,
2756: p_procedure_name => l_program_name,
2757: p_var_name => 'p_to_component_name',
2758: p_var_value => p_to_component_name);

Line 2817: INL_LOGGING_PVT.Log_EndProc (

2813: END IF;
2814:
2815: END IF;
2816:
2817: INL_LOGGING_PVT.Log_EndProc (
2818: p_module_name => g_module_name,
2819: p_procedure_name => l_program_name);
2820:
2821: EXCEPTION

Line 2823: INL_LOGGING_PVT.Log_ExpecError (

2819: p_procedure_name => l_program_name);
2820:
2821: EXCEPTION
2822: WHEN L_FND_EXC_ERROR THEN
2823: INL_LOGGING_PVT.Log_ExpecError (
2824: p_module_name => g_module_name,
2825: p_procedure_name => l_program_name);
2826: x_return_status := L_FND_RET_STS_ERROR;
2827: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN

Line 2828: INL_LOGGING_PVT.Log_UnexpecError (

2824: p_module_name => g_module_name,
2825: p_procedure_name => l_program_name);
2826: x_return_status := L_FND_RET_STS_ERROR;
2827: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
2828: INL_LOGGING_PVT.Log_UnexpecError (
2829: p_module_name => g_module_name,
2830: p_procedure_name => l_program_name);
2831: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2832: WHEN OTHERS THEN

Line 2833: INL_LOGGING_PVT.Log_UnexpecError (

2829: p_module_name => g_module_name,
2830: p_procedure_name => l_program_name);
2831: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2832: WHEN OTHERS THEN
2833: INL_LOGGING_PVT.Log_UnexpecError (
2834: p_module_name => g_module_name,
2835: p_procedure_name => l_program_name);
2836: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2837: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2887: INL_LOGGING_PVT.Log_BeginProc (

2883: l_return_status VARCHAR2(1);
2884:
2885: BEGIN
2886:
2887: INL_LOGGING_PVT.Log_BeginProc (
2888: p_module_name => g_module_name,
2889: p_procedure_name => l_program_name);
2890: --
2891: -- Initialize return status to SUCCESS

Line 2897: INL_LOGGING_PVT.Log_Variable (

2893:
2894: x_return_status := L_FND_RET_STS_SUCCESS;
2895:
2896: l_debug_info := 'p_ship_header_id';
2897: INL_LOGGING_PVT.Log_Variable (
2898: p_module_name => g_module_name,
2899: p_procedure_name => l_program_name,
2900: p_var_name => l_debug_info,
2901: p_var_value => TO_CHAR(p_ship_header_id));

Line 2908: INL_LOGGING_PVT.Log_Statement(

2904: FETCH updalloc BULK COLLECT INTO updalloc_List; --Bulk implem
2905: CLOSE updalloc;
2906:
2907: l_debug_info := 'Fetched '||NVL(updalloc_List.COUNT, 0)||' record(s).';
2908: INL_LOGGING_PVT.Log_Statement(
2909: p_module_name => g_module_name,
2910: p_procedure_name => l_program_name,
2911: p_debug_info => l_debug_info
2912: ) ;

Line 2920: INL_LOGGING_PVT.Log_Statement (

2916: FOR iupdalloc IN 1 .. updalloc_List.COUNT --Bulk implem
2917: LOOP
2918:
2919: l_debug_info := 'Updating inl_allocations with parent_allocation_id';
2920: INL_LOGGING_PVT.Log_Statement (
2921: p_module_name => g_module_name,
2922: p_procedure_name => l_program_name,
2923: p_debug_info => l_debug_info);
2924:

Line 2947: INL_LOGGING_PVT.Log_Variable (

2943: WHERE a1.allocation_id = updalloc_List(iUpdAlloc).allocation_id
2944: AND a1.adjustment_num = updalloc_List(iUpdAlloc).adjustment_num;
2945:
2946: l_debug_info := 'updalloc_List(iUpdAlloc).allocation_id';
2947: INL_LOGGING_PVT.Log_Variable (
2948: p_module_name => g_module_name,
2949: p_procedure_name => l_program_name,
2950: p_var_name => l_debug_info,
2951: p_var_value => TO_CHAR(updalloc_List(iUpdAlloc).allocation_id));

Line 2954: INL_LOGGING_PVT.Log_Variable (

2950: p_var_name => l_debug_info,
2951: p_var_value => TO_CHAR(updalloc_List(iUpdAlloc).allocation_id));
2952:
2953: l_debug_info := 'updalloc_List(iUpdAlloc).adjustment_num';
2954: INL_LOGGING_PVT.Log_Variable (
2955: p_module_name => g_module_name,
2956: p_procedure_name => l_program_name,
2957: p_var_name => l_debug_info,
2958: p_var_value => TO_CHAR(updalloc_List(iUpdAlloc).adjustment_num));

Line 2962: INL_LOGGING_PVT.Log_EndProc (

2958: p_var_value => TO_CHAR(updalloc_List(iUpdAlloc).adjustment_num));
2959:
2960: END LOOP;
2961: END IF;
2962: INL_LOGGING_PVT.Log_EndProc (
2963: p_module_name => g_module_name,
2964: p_procedure_name => l_program_name);
2965:
2966: EXCEPTION

Line 2968: INL_LOGGING_PVT.Log_ExpecError (

2964: p_procedure_name => l_program_name);
2965:
2966: EXCEPTION
2967: WHEN L_FND_EXC_ERROR THEN
2968: INL_LOGGING_PVT.Log_ExpecError (
2969: p_module_name => g_module_name,
2970: p_procedure_name => l_program_name);
2971: x_return_status := L_FND_RET_STS_ERROR;
2972: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN

Line 2973: INL_LOGGING_PVT.Log_UnexpecError (

2969: p_module_name => g_module_name,
2970: p_procedure_name => l_program_name);
2971: x_return_status := L_FND_RET_STS_ERROR;
2972: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
2973: INL_LOGGING_PVT.Log_UnexpecError (
2974: p_module_name => g_module_name,
2975: p_procedure_name => l_program_name);
2976: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2977: WHEN OTHERS THEN

Line 2978: INL_LOGGING_PVT.Log_UnexpecError (

2974: p_module_name => g_module_name,
2975: p_procedure_name => l_program_name);
2976: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2977: WHEN OTHERS THEN
2978: INL_LOGGING_PVT.Log_UnexpecError (
2979: p_module_name => g_module_name,
2980: p_procedure_name => l_program_name);
2981: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2982: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

3299: --
3300:
3301: BEGIN
3302:
3303: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
3304: p_procedure_name => l_program_name);
3305: --
3306: -- Standard Start of API savepoint
3307: --

Line 3341: INL_LOGGING_PVT.Log_Statement (

3337: -- Get Functional Currency, Last Adjustment and Shipment Status
3338: --
3339:
3340: l_debug_info := 'Get Functional Currency, Last Adjustment and Shipment Status';
3341: INL_LOGGING_PVT.Log_Statement (
3342: p_module_name => g_module_name,
3343: p_procedure_name => l_program_name,
3344: p_debug_info => l_debug_info);
3345:

Line 3361: INL_LOGGING_PVT.Log_Variable (

3357: WHERE gl.ledger_id = l.ledger_id
3358: AND l.legal_entity_id = oh.legal_entity_id
3359: AND oh.ship_header_id = p_ship_header_id;
3360:
3361: INL_LOGGING_PVT.Log_Variable (
3362: p_module_name => g_module_name,
3363: p_procedure_name => l_program_name,
3364: p_var_name => 'l_le_currency_code',
3365: p_var_value => l_le_currency_code);

Line 3366: INL_LOGGING_PVT.Log_Variable (

3362: p_module_name => g_module_name,
3363: p_procedure_name => l_program_name,
3364: p_var_name => 'l_le_currency_code',
3365: p_var_value => l_le_currency_code);
3366: INL_LOGGING_PVT.Log_Variable (
3367: p_module_name => g_module_name,
3368: p_procedure_name => l_program_name,
3369: p_var_name => 'l_last_adjustment_num',
3370: p_var_value => l_last_adjustment_num);

Line 3371: INL_LOGGING_PVT.Log_Variable (

3367: p_module_name => g_module_name,
3368: p_procedure_name => l_program_name,
3369: p_var_name => 'l_last_adjustment_num',
3370: p_var_value => l_last_adjustment_num);
3371: INL_LOGGING_PVT.Log_Variable (
3372: p_module_name => g_module_name,
3373: p_procedure_name => l_program_name,
3374: p_var_name => 'l_ship_status_code',
3375: p_var_value => l_ship_status_code);

Line 3389: INL_LOGGING_PVT.Log_Variable (

3385: INTO l_first_adjustment_num
3386: FROM inl_allocations
3387: WHERE ship_header_id = p_ship_header_id;
3388:
3389: INL_LOGGING_PVT.Log_Variable (
3390: p_module_name => g_module_name,
3391: p_procedure_name => l_program_name,
3392: p_var_name => 'l_first_adjustment_num',
3393: p_var_value => l_first_adjustment_num);

Line 3419: INL_LOGGING_PVT.Log_Variable (

3415: ELSE
3416: l_first_adjustment_num := 0;
3417: END IF;
3418:
3419: INL_LOGGING_PVT.Log_Variable (
3420: p_module_name => g_module_name,
3421: p_procedure_name => l_program_name,
3422: p_var_name => 'l_first_adjustment_num',
3423: p_var_value => l_first_adjustment_num);

Line 3425: INL_LOGGING_PVT.Log_Variable (

3421: p_procedure_name => l_program_name,
3422: p_var_name => 'l_first_adjustment_num',
3423: p_var_value => l_first_adjustment_num);
3424:
3425: INL_LOGGING_PVT.Log_Variable (
3426: p_module_name => g_module_name,
3427: p_procedure_name => l_program_name,
3428: p_var_name => 'l_last_adjustment_num',
3429: p_var_value => l_last_adjustment_num);

Line 3438: INL_LOGGING_PVT.Log_Variable (

3434: --- SCM-051
3435: --- FOR i IN l_first_adjustment_num..l_last_adjustment_num LOOP
3436: l_i_adj := l_first_adjustment_num;
3437: LOOP
3438: INL_LOGGING_PVT.Log_Variable (
3439: p_module_name => g_module_name,
3440: p_procedure_name => l_program_name,
3441: p_var_name => 'l_i_adj',
3442: p_var_value => l_i_adj);

Line 3514: INL_LOGGING_PVT.Log_Variable (

3510: WHERE a.ship_header_id(+) = sh.ship_header_id
3511: AND sh.ship_header_id = p_ship_header_id
3512: ;
3513: --Bug#14081759 END
3514: INL_LOGGING_PVT.Log_Variable (
3515: p_module_name => g_module_name,
3516: p_procedure_name => l_program_name,
3517: p_var_name => 'l_current_adjustment_num',
3518: p_var_value => l_current_adjustment_num);

Line 3520: INL_LOGGING_PVT.Log_Variable (

3516: p_procedure_name => l_program_name,
3517: p_var_name => 'l_current_adjustment_num',
3518: p_var_value => l_current_adjustment_num);
3519: --- SCM-051
3520: INL_LOGGING_PVT.Log_Variable (
3521: p_module_name => g_module_name,
3522: p_procedure_name => l_program_name,
3523: p_var_name => 'l_i_adj',
3524: p_var_value => l_i_adj);

Line 3531: INL_LOGGING_PVT.Log_Variable (

3527: --- SCM-051
3528: IF ABS(l_i_adj) = ABS(l_current_adjustment_num) THEN
3529: --- SCM-051
3530: l_debug_info := 'l_first_adjustment_num';
3531: INL_LOGGING_PVT.Log_Variable (
3532: p_module_name => g_module_name,
3533: p_procedure_name => l_program_name,
3534: p_var_name => l_debug_info,
3535: p_var_value => l_first_adjustment_num);

Line 3537: INL_LOGGING_PVT.Log_Variable (

3533: p_procedure_name => l_program_name,
3534: p_var_name => l_debug_info,
3535: p_var_value => l_first_adjustment_num);
3536: l_debug_info := 'l_last_adjustment_num';
3537: INL_LOGGING_PVT.Log_Variable (
3538: p_module_name => g_module_name,
3539: p_procedure_name => l_program_name,
3540: p_var_name => l_debug_info,
3541: p_var_value => l_last_adjustment_num);

Line 3543: INL_LOGGING_PVT.Log_Variable (

3539: p_procedure_name => l_program_name,
3540: p_var_name => l_debug_info,
3541: p_var_value => l_last_adjustment_num);
3542: l_debug_info := 'l_current_adjustment_num';
3543: INL_LOGGING_PVT.Log_Variable (
3544: p_module_name => g_module_name,
3545: p_procedure_name => l_program_name,
3546: p_var_name => l_debug_info,
3547: p_var_value => l_current_adjustment_num);

Line 3557: INL_LOGGING_PVT.Log_Statement (

3553:
3554: IF l_current_adjustment_num = 0 THEN
3555:
3556: l_debug_info := 'Check for Associations in Loop';
3557: INL_LOGGING_PVT.Log_Statement (
3558: p_module_name => g_module_name,
3559: p_procedure_name => l_program_name,
3560: p_debug_info => l_debug_info);
3561:

Line 3568: INL_LOGGING_PVT.Log_Statement(

3564: FETCH assoc BULK COLLECT INTO assoc_List; --Bulk implem
3565: CLOSE assoc;
3566:
3567: l_debug_info := 'Fetched '||NVL(assoc_List.COUNT, 0)||' association(s).';
3568: INL_LOGGING_PVT.Log_Statement(
3569: p_module_name => g_module_name,
3570: p_procedure_name => l_program_name,
3571: p_debug_info => l_debug_info
3572: ) ;

Line 3606: INL_LOGGING_PVT.Log_Statement (

3602: -- Remove previous allocations
3603: --
3604:
3605: l_debug_info := 'Remove previous allocations';
3606: INL_LOGGING_PVT.Log_Statement (
3607: p_module_name => g_module_name,
3608: p_procedure_name => l_program_name,
3609: p_debug_info => l_debug_info);
3610:

Line 3616: INL_LOGGING_PVT.Log_Statement (

3612: WHERE ship_header_id = p_ship_header_id
3613: AND ABS(adjustment_num) = ABS(l_current_adjustment_num);
3614: --SCM-051
3615: l_debug_info:=l_debug_info||' => '||sql%ROWCOUNT;
3616: INL_LOGGING_PVT.Log_Statement (
3617: p_module_name => g_module_name,
3618: p_procedure_name => l_program_name,
3619: p_debug_info => l_debug_info);
3620: --SCM-051

Line 3626: INL_LOGGING_PVT.Log_Statement (

3622: -- STEP 1 - Allocation of Associated Amounts
3623: --
3624:
3625: l_debug_info := 'STEP 1: Allocation of Associated Amounts';
3626: INL_LOGGING_PVT.Log_Statement (
3627: p_module_name => g_module_name,
3628: p_procedure_name => l_program_name,
3629: p_debug_info => l_debug_info);
3630:

Line 3640: INL_LOGGING_PVT.Log_Statement(

3636: FETCH assoc BULK COLLECT INTO assoc_List; --Bulk implem
3637: CLOSE assoc;
3638:
3639: l_debug_info := 'Fetched '||NVL(assoc_List.COUNT, 0)||' association(s).';
3640: INL_LOGGING_PVT.Log_Statement(
3641: p_module_name => g_module_name,
3642: p_procedure_name => l_program_name,
3643: p_debug_info => l_debug_info
3644: ) ;

Line 3651: INL_LOGGING_PVT.Log_Statement (

3647: FOR iAssoc IN 1 .. assoc_List.COUNT --Bulk implem
3648: LOOP
3649:
3650: l_debug_info := 'Fetching Associations cursor';
3651: INL_LOGGING_PVT.Log_Statement (
3652: p_module_name => g_module_name,
3653: p_procedure_name => l_program_name,
3654: p_debug_info => l_debug_info);
3655:

Line 3661: INL_LOGGING_PVT.Log_Variable (

3657: l_from_amount := 0;
3658: l_to_amount := 0;
3659:
3660: l_debug_info := 'assoc_List(iAssoc).from_parent_table_name';
3661: INL_LOGGING_PVT.Log_Variable (
3662: p_module_name => g_module_name,
3663: p_procedure_name => l_program_name,
3664: p_var_name => l_debug_info,
3665: p_var_value => assoc_List(iAssoc).from_parent_table_name);

Line 3668: INL_LOGGING_PVT.Log_Variable (

3664: p_var_name => l_debug_info,
3665: p_var_value => assoc_List(iAssoc).from_parent_table_name);
3666:
3667: l_debug_info := 'assoc_List(iAssoc).from_parent_table_id';
3668: INL_LOGGING_PVT.Log_Variable (
3669: p_module_name => g_module_name,
3670: p_procedure_name => l_program_name,
3671: p_var_name => l_debug_info,
3672: p_var_value => TO_CHAR(assoc_List(iAssoc).from_parent_table_id));

Line 3675: INL_LOGGING_PVT.Log_Variable (

3671: p_var_name => l_debug_info,
3672: p_var_value => TO_CHAR(assoc_List(iAssoc).from_parent_table_id));
3673:
3674: l_debug_info := 'assoc_List(iAssoc).to_parent_table_name';
3675: INL_LOGGING_PVT.Log_Variable (
3676: p_module_name => g_module_name,
3677: p_procedure_name => l_program_name,
3678: p_var_name => l_debug_info,
3679: p_var_value => assoc_List(iAssoc).to_parent_table_name);

Line 3682: INL_LOGGING_PVT.Log_Variable (

3678: p_var_name => l_debug_info,
3679: p_var_value => assoc_List(iAssoc).to_parent_table_name);
3680:
3681: l_debug_info := 'assoc_List(iAssoc).to_parent_table_id';
3682: INL_LOGGING_PVT.Log_Variable (
3683: p_module_name => g_module_name,
3684: p_procedure_name => l_program_name,
3685: p_var_name => l_debug_info,
3686: p_var_value => TO_CHAR(assoc_List(iAssoc).to_parent_table_id));

Line 3689: INL_LOGGING_PVT.Log_Variable (

3685: p_var_name => l_debug_info,
3686: p_var_value => TO_CHAR(assoc_List(iAssoc).to_parent_table_id));
3687:
3688: l_debug_info := 'assoc_List(iAssoc).association_id';
3689: INL_LOGGING_PVT.Log_Variable (
3690: p_module_name => g_module_name,
3691: p_procedure_name => l_program_name,
3692: p_var_name => l_debug_info,
3693: p_var_value => assoc_List(iAssoc).association_id);

Line 3727: INL_LOGGING_PVT.Log_Variable (

3723: WHERE ol.ship_line_id = assoc_List(iAssoc).from_parent_table_id;
3724: END IF;
3725:
3726: l_debug_info := 'l_from_amount';
3727: INL_LOGGING_PVT.Log_Variable (
3728: p_module_name => g_module_name,
3729: p_procedure_name => l_program_name,
3730: p_var_name => l_debug_info,
3731: p_var_value => TO_CHAR(l_from_amount));

Line 3736: INL_LOGGING_PVT.Log_Variable (

3732:
3733: l_amount := l_from_amount;
3734:
3735: l_debug_info := 'l_amount';
3736: INL_LOGGING_PVT.Log_Variable (
3737: p_module_name => g_module_name,
3738: p_procedure_name => l_program_name,
3739: p_var_name => l_debug_info,
3740: p_var_value => TO_CHAR(l_amount));

Line 3749: INL_LOGGING_PVT.Log_Statement (

3745: THEN
3746: l_from_parent_table_name_brk := assoc_List(iAssoc).from_parent_table_name;
3747: l_from_parent_table_id_brk := assoc_List(iAssoc).from_parent_table_id;
3748: l_debug_info := 'Call Get_TotalAmt';
3749: INL_LOGGING_PVT.Log_Statement (
3750: p_module_name => g_module_name,
3751: p_procedure_name => l_program_name,
3752: p_debug_info => l_debug_info);
3753: Get_TotalAmt (

Line 3775: INL_LOGGING_PVT.Log_Statement (

3771: END IF;
3772: END IF;
3773: IF l_do_proportion = 'Y' THEN
3774: l_debug_info := 'Call Manage_Proportion';
3775: INL_LOGGING_PVT.Log_Statement (
3776: p_module_name => g_module_name,
3777: p_procedure_name => l_program_name,
3778: p_debug_info => l_debug_info);
3779: Manage_Proportion (

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

3804:
3805: l_amount := l_amount * l_factor;
3806:
3807: l_debug_info := 'Call to Control_Allocation';
3808: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
3809: p_procedure_name => l_program_name,
3810: p_debug_info => l_debug_info);
3811:
3812: Control_Allocation (

Line 3841: INL_LOGGING_PVT.Log_Statement (

3837: -- STEP 2 - Allocation of Not Associated Amounts
3838: --
3839:
3840: l_debug_info := 'STEP 2 - Allocation of Not Associated Amounts';
3841: INL_LOGGING_PVT.Log_Statement (
3842: p_module_name => g_module_name,
3843: p_procedure_name => l_program_name,
3844: p_debug_info => l_debug_info);
3845:

Line 3853: INL_LOGGING_PVT.Log_Statement(

3849: );
3850: FETCH dist BULK COLLECT INTO dist_List; --Bulk implem
3851: CLOSE dist;
3852: l_debug_info := 'Fetched '||NVL(dist_List.COUNT, 0)||' line(s).';
3853: INL_LOGGING_PVT.Log_Statement(
3854: p_module_name => g_module_name,
3855: p_procedure_name => l_program_name,
3856: p_debug_info => l_debug_info
3857: ) ;

Line 3867: INL_LOGGING_PVT.Log_Statement (

3863:
3864: l_count1 := 0;
3865:
3866: l_debug_info := 'Fetching Distributions cursor';
3867: INL_LOGGING_PVT.Log_Statement (
3868: p_module_name => g_module_name,
3869: p_procedure_name => l_program_name,
3870: p_debug_info => l_debug_info);
3871:

Line 3894: INL_LOGGING_PVT.Log_Variable (

3890: END IF;
3891: --Bug#9660084
3892:
3893: l_debug_info := 'dist_List('||iDist||').ship_line_id';
3894: INL_LOGGING_PVT.Log_Variable (
3895: p_module_name => g_module_name,
3896: p_procedure_name => l_program_name,
3897: p_var_name => l_debug_info,
3898: p_var_value => TO_CHAR(dist_List(iDist).ship_line_id));

Line 3900: INL_LOGGING_PVT.Log_Variable (

3896: p_procedure_name => l_program_name,
3897: p_var_name => l_debug_info,
3898: p_var_value => TO_CHAR(dist_List(iDist).ship_line_id));
3899:
3900: INL_LOGGING_PVT.Log_Variable (
3901: p_module_name => g_module_name,
3902: p_procedure_name => l_program_name,
3903: p_var_name => 'l_lc_flag',
3904: p_var_value => l_lc_flag);

Line 3959: INL_LOGGING_PVT.Log_Statement(

3955: );
3956: FETCH charge BULK COLLECT INTO charge_List; --Bulk implem
3957: CLOSE charge;
3958: l_debug_info := 'Fetched '||NVL(charge_List.COUNT, 0)||' charge(s).';
3959: INL_LOGGING_PVT.Log_Statement(
3960: p_module_name => g_module_name,
3961: p_procedure_name => l_program_name,
3962: p_debug_info => l_debug_info
3963: ) ;

Line 3996: INL_LOGGING_PVT.Log_Statement(

3992: );
3993: FETCH tax BULK COLLECT INTO tax_List; --Bulk implem
3994: CLOSE tax;
3995: l_debug_info := 'Fetched '||NVL(tax_List.COUNT, 0)||' tax(s).';
3996: INL_LOGGING_PVT.Log_Statement(
3997: p_module_name => g_module_name,
3998: p_procedure_name => l_program_name,
3999: p_debug_info => l_debug_info
4000: ) ;

Line 4062: INL_LOGGING_PVT.Log_EndProc (

4058: p_encoded => L_FND_FALSE,
4059: p_count => x_msg_count,
4060: p_data => x_msg_data);
4061:
4062: INL_LOGGING_PVT.Log_EndProc (
4063: p_module_name => g_module_name,
4064: p_procedure_name => l_program_name);
4065:
4066: EXCEPTION

Line 4068: INL_LOGGING_PVT.Log_ExpecError (

4064: p_procedure_name => l_program_name);
4065:
4066: EXCEPTION
4067: WHEN L_FND_EXC_ERROR THEN
4068: INL_LOGGING_PVT.Log_ExpecError (
4069: p_module_name => g_module_name,
4070: p_procedure_name => l_program_name);
4071: ROLLBACK TO Run_Calculation_PVT;
4072: x_return_status := L_FND_RET_STS_ERROR;

Line 4078: INL_LOGGING_PVT.Log_UnexpecError (

4074: p_encoded => L_FND_FALSE,
4075: p_count => x_msg_count,
4076: p_data => x_msg_data);
4077: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
4078: INL_LOGGING_PVT.Log_UnexpecError (
4079: p_module_name => g_module_name,
4080: p_procedure_name => l_program_name);
4081: ROLLBACK TO Run_Calculation_PVT;
4082: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 4088: INL_LOGGING_PVT.Log_UnexpecError (

4084: p_encoded => L_FND_FALSE,
4085: p_count => x_msg_count,
4086: p_data => x_msg_data);
4087: WHEN OTHERS THEN
4088: INL_LOGGING_PVT.Log_UnexpecError (
4089: p_module_name => g_module_name,
4090: p_procedure_name => l_program_name);
4091: ROLLBACK TO Run_Calculation_PVT;
4092: x_return_status := L_FND_RET_STS_UNEXP_ERROR ;