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

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

52: l_allocation_uom_code VARCHAR(30);
53:
54: BEGIN
55: -- Standard Beginning of Procedure/Function Logging
56: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
57: p_procedure_name => l_proc_name);
58:
59: -- Initialize API return status to success
60: x_return_status := L_FND_RET_STS_SUCCESS;

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

59: -- Initialize API return status to success
60: x_return_status := L_FND_RET_STS_SUCCESS;
61:
62: l_debug_info := 'Get the Allocation Basis and UOM Code';
63: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
64: p_procedure_name => l_proc_name,
65: p_debug_info => l_debug_info);
66: SELECT icv.allocation_basis,
67: ab.base_uom_code

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

74: AND icv.charge_line_type_id (+) = icl.charge_line_type_id
75: AND icl.charge_line_id = p_from_parent_table_id;
76:
77: l_debug_info := 'Insert into INL Associations table';
78: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
79: p_procedure_name => l_proc_name,
80: p_debug_info => l_debug_info);
81:
82: INSERT INTO inl_associations(

Line 113: INL_LOGGING_PVT.Log_EndProc (

109: L_FND_LOGIN_ID
110: );
111:
112: -- Standard End of Procedure/Function Logging
113: INL_LOGGING_PVT.Log_EndProc (
114: p_module_name => g_module_name,
115: p_procedure_name => l_proc_name
116: );
117: EXCEPTION

Line 220: INL_LOGGING_PVT.Log_BeginProc (

216: l_charge_line_num NUMBER;
217:
218: BEGIN
219: -- Standard Beginning of Procedure/Function Logging
220: INL_LOGGING_PVT.Log_BeginProc (
221: p_module_name => g_module_name,
222: p_procedure_name => l_proc_name
223: );
224:

Line 229: INL_LOGGING_PVT.Log_Statement (

225: -- Initialize API return status to success
226: x_return_status := L_FND_RET_STS_SUCCESS;
227:
228: l_debug_info := 'Get the Charge Line ID';
229: INL_LOGGING_PVT.Log_Statement (
230: p_module_name => g_module_name,
231: p_procedure_name => l_proc_name,
232: p_debug_info => l_debug_info
233: );

Line 240: INL_LOGGING_PVT.Log_Statement (

236: INTO l_charge_line_id
237: FROM dual;
238:
239: l_debug_info := 'Get the Charge Line Number';
240: INL_LOGGING_PVT.Log_Statement (
241: p_module_name => g_module_name,
242: p_procedure_name => l_proc_name,
243: p_debug_info => l_debug_info
244: );

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

251: AND ias.from_parent_table_id = icl.charge_line_id
252: AND ias.ship_header_id = p_ship_header_id;
253:
254: l_debug_info := 'Insert into INL Charge Line table.';
255: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
256: p_procedure_name => l_proc_name,
257: p_debug_info => l_debug_info);
258:
259: INSERT INTO inl_charge_lines(

Line 344: INL_LOGGING_PVT.Log_Statement (

340: L_FND_LOGIN_ID
341: );
342:
343: l_debug_info := 'Call Insert_Association(...)';
344: INL_LOGGING_PVT.Log_Statement (
345: p_module_name => g_module_name,
346: p_procedure_name => l_proc_name,
347: p_debug_info => l_debug_info
348: );

Line 365: INL_LOGGING_PVT.Log_EndProc (

361: RAISE L_FND_EXC_UNEXPECTED_ERROR;
362: END IF;
363:
364: -- Standard End of Procedure/Function Logging
365: INL_LOGGING_PVT.Log_EndProc (
366: p_module_name => g_module_name,
367: p_procedure_name => l_proc_name
368: );
369: EXCEPTION

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

368: );
369: EXCEPTION
370: WHEN OTHERS THEN
371: -- Standard Unexpected Error Logging
372: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
373: p_procedure_name => l_proc_name);
374: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
375: IF FND_MSG_PUB.Check_Msg_Level(p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
376: FND_MSG_PUB.Add_Exc_Msg(

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

443:
444: BEGIN
445:
446: -- Begin the procedure
447: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
448: p_procedure_name => l_proc_name);
449: -- Init return status
450: x_return_status := L_FND_RET_STS_SUCCESS;
451:

Line 477: INL_LOGGING_PVT.Log_EndProc (

473: po_advanced_price_pvt.g_hdr.source_org_id := p_source_org_id;
474: po_advanced_price_pvt.g_hdr.expected_receipt_date := p_expected_receipt_date;
475:
476: -- End the procedure
477: INL_LOGGING_PVT.Log_EndProc (
478: p_module_name => g_module_name,
479: p_procedure_name => l_proc_name
480: );
481: EXCEPTION

Line 483: INL_LOGGING_PVT.Log_UnexpecError (

479: p_procedure_name => l_proc_name
480: );
481: EXCEPTION
482: WHEN OTHERS THEN
483: INL_LOGGING_PVT.Log_UnexpecError (
484: p_module_name => g_module_name,
485: p_procedure_name => l_proc_name
486: );
487: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

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

552:
553: BEGIN
554:
555: -- Begin the procedure
556: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
557: p_procedure_name => l_proc_name);
558: -- Init return status
559: x_return_status := L_FND_RET_STS_SUCCESS;
560:

Line 587: INL_LOGGING_PVT.Log_EndProc (

583: po_advanced_price_pvt.g_line.unit_price := p_unit_price;
584: po_advanced_price_pvt.g_line.quantity := p_quantity;
585:
586: -- End the procedure
587: INL_LOGGING_PVT.Log_EndProc (
588: p_module_name => g_module_name,
589: p_procedure_name => l_proc_name
590: );
591: EXCEPTION

Line 593: INL_LOGGING_PVT.Log_UnexpecError (

589: p_procedure_name => l_proc_name
590: );
591: EXCEPTION
592: WHEN OTHERS THEN
593: INL_LOGGING_PVT.Log_UnexpecError (
594: p_module_name => g_module_name,
595: p_procedure_name => l_proc_name
596: );
597: x_return_status := L_FND_RET_STS_UNEXP_ERROR;

Line 689: INL_LOGGING_PVT.Log_BeginProc (

685: l_cost_factor_valid VARCHAR2(1):='T'; -- Bug #9274538
686:
687: BEGIN
688: -- Begin the procedure
689: INL_LOGGING_PVT.Log_BeginProc (
690: p_module_name => g_module_name,
691: p_procedure_name => l_proc_name);
692:
693: -- Init return status

Line 698: INL_LOGGING_PVT.Log_Variable (

694: x_return_status := L_FND_RET_STS_SUCCESS;
695:
696: IF l_log_all_input_var = 'Y'
697: THEN
698: INL_LOGGING_PVT.Log_Variable (
699: p_module_name => g_module_name,
700: p_procedure_name => l_proc_name,
701: p_var_name => 'p_ship_ln_group_rec.ship_line_group_id ',
702: p_var_value => p_ship_ln_group_rec.ship_line_group_id );

Line 703: INL_LOGGING_PVT.Log_Variable (

699: p_module_name => g_module_name,
700: p_procedure_name => l_proc_name,
701: p_var_name => 'p_ship_ln_group_rec.ship_line_group_id ',
702: p_var_value => p_ship_ln_group_rec.ship_line_group_id );
703: INL_LOGGING_PVT.Log_Variable (
704: p_module_name => g_module_name,
705: p_procedure_name => l_proc_name,
706: p_var_name => 'p_ship_ln_group_rec.org_id ',
707: p_var_value => p_ship_ln_group_rec.org_id );

Line 708: INL_LOGGING_PVT.Log_Variable (

704: p_module_name => g_module_name,
705: p_procedure_name => l_proc_name,
706: p_var_name => 'p_ship_ln_group_rec.org_id ',
707: p_var_value => p_ship_ln_group_rec.org_id );
708: INL_LOGGING_PVT.Log_Variable (
709: p_module_name => g_module_name,
710: p_procedure_name => l_proc_name,
711: p_var_name => 'p_ship_ln_group_rec.p_order_header_id ',
712: p_var_value => p_ship_ln_group_rec.p_order_header_id );

Line 713: INL_LOGGING_PVT.Log_Variable (

709: p_module_name => g_module_name,
710: p_procedure_name => l_proc_name,
711: p_var_name => 'p_ship_ln_group_rec.p_order_header_id ',
712: p_var_value => p_ship_ln_group_rec.p_order_header_id );
713: INL_LOGGING_PVT.Log_Variable (
714: p_module_name => g_module_name,
715: p_procedure_name => l_proc_name,
716: p_var_name => 'p_ship_ln_group_rec.supplier_id ',
717: p_var_value => p_ship_ln_group_rec.supplier_id );

Line 718: INL_LOGGING_PVT.Log_Variable (

714: p_module_name => g_module_name,
715: p_procedure_name => l_proc_name,
716: p_var_name => 'p_ship_ln_group_rec.supplier_id ',
717: p_var_value => p_ship_ln_group_rec.supplier_id );
718: INL_LOGGING_PVT.Log_Variable (
719: p_module_name => g_module_name,
720: p_procedure_name => l_proc_name,
721: p_var_name => 'p_ship_ln_group_rec.supplier_site_id ',
722: p_var_value => p_ship_ln_group_rec.supplier_site_id );

Line 723: INL_LOGGING_PVT.Log_Variable (

719: p_module_name => g_module_name,
720: p_procedure_name => l_proc_name,
721: p_var_name => 'p_ship_ln_group_rec.supplier_site_id ',
722: p_var_value => p_ship_ln_group_rec.supplier_site_id );
723: INL_LOGGING_PVT.Log_Variable (
724: p_module_name => g_module_name,
725: p_procedure_name => l_proc_name,
726: p_var_name => 'p_ship_ln_group_rec.creation_date ',
727: p_var_value => p_ship_ln_group_rec.creation_date );

Line 728: INL_LOGGING_PVT.Log_Variable (

724: p_module_name => g_module_name,
725: p_procedure_name => l_proc_name,
726: p_var_name => 'p_ship_ln_group_rec.creation_date ',
727: p_var_value => p_ship_ln_group_rec.creation_date );
728: INL_LOGGING_PVT.Log_Variable (
729: p_module_name => g_module_name,
730: p_procedure_name => l_proc_name,
731: p_var_name => 'p_ship_ln_group_rec.order_type ',
732: p_var_value => p_ship_ln_group_rec.order_type );

Line 733: INL_LOGGING_PVT.Log_Variable (

729: p_module_name => g_module_name,
730: p_procedure_name => l_proc_name,
731: p_var_name => 'p_ship_ln_group_rec.order_type ',
732: p_var_value => p_ship_ln_group_rec.order_type );
733: INL_LOGGING_PVT.Log_Variable (
734: p_module_name => g_module_name,
735: p_procedure_name => l_proc_name,
736: p_var_name => 'p_ship_ln_group_rec.ship_to_location_id ',
737: p_var_value => p_ship_ln_group_rec.ship_to_location_id );

Line 738: INL_LOGGING_PVT.Log_Variable (

734: p_module_name => g_module_name,
735: p_procedure_name => l_proc_name,
736: p_var_name => 'p_ship_ln_group_rec.ship_to_location_id ',
737: p_var_value => p_ship_ln_group_rec.ship_to_location_id );
738: INL_LOGGING_PVT.Log_Variable (
739: p_module_name => g_module_name,
740: p_procedure_name => l_proc_name,
741: p_var_name => 'p_ship_ln_group_rec.ship_to_org_id ',
742: p_var_value => p_ship_ln_group_rec.ship_to_org_id );

Line 743: INL_LOGGING_PVT.Log_Variable (

739: p_module_name => g_module_name,
740: p_procedure_name => l_proc_name,
741: p_var_name => 'p_ship_ln_group_rec.ship_to_org_id ',
742: p_var_value => p_ship_ln_group_rec.ship_to_org_id );
743: INL_LOGGING_PVT.Log_Variable (
744: p_module_name => g_module_name,
745: p_procedure_name => l_proc_name,
746: p_var_name => 'p_ship_ln_group_rec.shipment_header_id ',
747: p_var_value => p_ship_ln_group_rec.shipment_header_id );

Line 748: INL_LOGGING_PVT.Log_Variable (

744: p_module_name => g_module_name,
745: p_procedure_name => l_proc_name,
746: p_var_name => 'p_ship_ln_group_rec.shipment_header_id ',
747: p_var_value => p_ship_ln_group_rec.shipment_header_id );
748: INL_LOGGING_PVT.Log_Variable (
749: p_module_name => g_module_name,
750: p_procedure_name => l_proc_name,
751: p_var_name => 'p_ship_ln_group_rec.hazard_class ',
752: p_var_value => p_ship_ln_group_rec.hazard_class );

Line 753: INL_LOGGING_PVT.Log_Variable (

749: p_module_name => g_module_name,
750: p_procedure_name => l_proc_name,
751: p_var_name => 'p_ship_ln_group_rec.hazard_class ',
752: p_var_value => p_ship_ln_group_rec.hazard_class );
753: INL_LOGGING_PVT.Log_Variable (
754: p_module_name => g_module_name,
755: p_procedure_name => l_proc_name,
756: p_var_name => 'p_ship_ln_group_rec.hazard_code ',
757: p_var_value => p_ship_ln_group_rec.hazard_code );

Line 758: INL_LOGGING_PVT.Log_Variable (

754: p_module_name => g_module_name,
755: p_procedure_name => l_proc_name,
756: p_var_name => 'p_ship_ln_group_rec.hazard_code ',
757: p_var_value => p_ship_ln_group_rec.hazard_code );
758: INL_LOGGING_PVT.Log_Variable (
759: p_module_name => g_module_name,
760: p_procedure_name => l_proc_name,
761: p_var_name => 'p_ship_ln_group_rec.shipped_date ',
762: p_var_value => p_ship_ln_group_rec.shipped_date );

Line 763: INL_LOGGING_PVT.Log_Variable (

759: p_module_name => g_module_name,
760: p_procedure_name => l_proc_name,
761: p_var_name => 'p_ship_ln_group_rec.shipped_date ',
762: p_var_value => p_ship_ln_group_rec.shipped_date );
763: INL_LOGGING_PVT.Log_Variable (
764: p_module_name => g_module_name,
765: p_procedure_name => l_proc_name,
766: p_var_name => 'p_ship_ln_group_rec.shipment_num ',
767: p_var_value => p_ship_ln_group_rec.shipment_num );

Line 768: INL_LOGGING_PVT.Log_Variable (

764: p_module_name => g_module_name,
765: p_procedure_name => l_proc_name,
766: p_var_name => 'p_ship_ln_group_rec.shipment_num ',
767: p_var_value => p_ship_ln_group_rec.shipment_num );
768: INL_LOGGING_PVT.Log_Variable (
769: p_module_name => g_module_name,
770: p_procedure_name => l_proc_name,
771: p_var_name => 'p_ship_ln_group_rec.carrier_method ',
772: p_var_value => p_ship_ln_group_rec.carrier_method );

Line 773: INL_LOGGING_PVT.Log_Variable (

769: p_module_name => g_module_name,
770: p_procedure_name => l_proc_name,
771: p_var_name => 'p_ship_ln_group_rec.carrier_method ',
772: p_var_value => p_ship_ln_group_rec.carrier_method );
773: INL_LOGGING_PVT.Log_Variable (
774: p_module_name => g_module_name,
775: p_procedure_name => l_proc_name,
776: p_var_name => 'p_ship_ln_group_rec.packaging_code ',
777: p_var_value => p_ship_ln_group_rec.packaging_code );

Line 778: INL_LOGGING_PVT.Log_Variable (

774: p_module_name => g_module_name,
775: p_procedure_name => l_proc_name,
776: p_var_name => 'p_ship_ln_group_rec.packaging_code ',
777: p_var_value => p_ship_ln_group_rec.packaging_code );
778: INL_LOGGING_PVT.Log_Variable (
779: p_module_name => g_module_name,
780: p_procedure_name => l_proc_name,
781: p_var_name => 'p_ship_ln_group_rec.freight_carrier_code ',
782: p_var_value => p_ship_ln_group_rec.freight_code );

Line 783: INL_LOGGING_PVT.Log_Variable (

779: p_module_name => g_module_name,
780: p_procedure_name => l_proc_name,
781: p_var_name => 'p_ship_ln_group_rec.freight_carrier_code ',
782: p_var_value => p_ship_ln_group_rec.freight_code );
783: INL_LOGGING_PVT.Log_Variable (
784: p_module_name => g_module_name,
785: p_procedure_name => l_proc_name,
786: p_var_name => 'p_ship_ln_group_rec.freight_terms ',
787: p_var_value => p_ship_ln_group_rec.freight_terms );

Line 788: INL_LOGGING_PVT.Log_Variable (

784: p_module_name => g_module_name,
785: p_procedure_name => l_proc_name,
786: p_var_name => 'p_ship_ln_group_rec.freight_terms ',
787: p_var_value => p_ship_ln_group_rec.freight_terms );
788: INL_LOGGING_PVT.Log_Variable (
789: p_module_name => g_module_name,
790: p_procedure_name => l_proc_name,
791: p_var_name => 'p_ship_ln_group_rec.currency_code ',
792: p_var_value => p_ship_ln_group_rec.currency_code );

Line 793: INL_LOGGING_PVT.Log_Variable (

789: p_module_name => g_module_name,
790: p_procedure_name => l_proc_name,
791: p_var_name => 'p_ship_ln_group_rec.currency_code ',
792: p_var_value => p_ship_ln_group_rec.currency_code );
793: INL_LOGGING_PVT.Log_Variable (
794: p_module_name => g_module_name,
795: p_procedure_name => l_proc_name,
796: p_var_name => 'p_ship_ln_group_rec.rate ',
797: p_var_value => p_ship_ln_group_rec.rate );

Line 798: INL_LOGGING_PVT.Log_Variable (

794: p_module_name => g_module_name,
795: p_procedure_name => l_proc_name,
796: p_var_name => 'p_ship_ln_group_rec.rate ',
797: p_var_value => p_ship_ln_group_rec.rate );
798: INL_LOGGING_PVT.Log_Variable (
799: p_module_name => g_module_name,
800: p_procedure_name => l_proc_name,
801: p_var_name => 'p_ship_ln_group_rec.rate_type ',
802: p_var_value => p_ship_ln_group_rec.rate_type );

Line 803: INL_LOGGING_PVT.Log_Variable (

799: p_module_name => g_module_name,
800: p_procedure_name => l_proc_name,
801: p_var_name => 'p_ship_ln_group_rec.rate_type ',
802: p_var_value => p_ship_ln_group_rec.rate_type );
803: INL_LOGGING_PVT.Log_Variable (
804: p_module_name => g_module_name,
805: p_procedure_name => l_proc_name,
806: p_var_name => 'p_ship_ln_group_rec.source_org_id ',
807: p_var_value => p_ship_ln_group_rec.source_org_id );

Line 808: INL_LOGGING_PVT.Log_Variable (

804: p_module_name => g_module_name,
805: p_procedure_name => l_proc_name,
806: p_var_name => 'p_ship_ln_group_rec.source_org_id ',
807: p_var_value => p_ship_ln_group_rec.source_org_id );
808: INL_LOGGING_PVT.Log_Variable (
809: p_module_name => g_module_name,
810: p_procedure_name => l_proc_name,
811: p_var_name => 'p_ship_ln_group_rec.expected_receipt_date ',
812: p_var_value => p_ship_ln_group_rec.expected_receipt_date );

Line 813: INL_LOGGING_PVT.Log_Variable (

809: p_module_name => g_module_name,
810: p_procedure_name => l_proc_name,
811: p_var_name => 'p_ship_ln_group_rec.expected_receipt_date ',
812: p_var_value => p_ship_ln_group_rec.expected_receipt_date );
813: INL_LOGGING_PVT.Log_Variable (
814: p_module_name => g_module_name,
815: p_procedure_name => l_proc_name,
816: p_var_name => 'p_ship_ln_group_rec.request_type ',
817: p_var_value => 'Have not' );

Line 818: INL_LOGGING_PVT.Log_Variable (

814: p_module_name => g_module_name,
815: p_procedure_name => l_proc_name,
816: p_var_name => 'p_ship_ln_group_rec.request_type ',
817: p_var_value => 'Have not' );
818: INL_LOGGING_PVT.Log_Variable (
819: p_module_name => g_module_name,
820: p_procedure_name => l_proc_name,
821: p_var_name => 'p_ship_ln_group_rec.pricing_event ',
822: p_var_value => 'Have not');

Line 823: INL_LOGGING_PVT.Log_Variable (

819: p_module_name => g_module_name,
820: p_procedure_name => l_proc_name,
821: p_var_name => 'p_ship_ln_group_rec.pricing_event ',
822: p_var_value => 'Have not');
823: INL_LOGGING_PVT.Log_Variable (
824: p_module_name => g_module_name,
825: p_procedure_name => l_proc_name,
826: p_var_name => 'p_ship_ln_group_rec.qp_curr_conv_type ',
827: p_var_value => 'Have not' );

Line 830: INL_LOGGING_PVT.Log_Variable (

826: p_var_name => 'p_ship_ln_group_rec.qp_curr_conv_type ',
827: p_var_value => 'Have not' );
828:
829: FOR l IN 1..p_ship_ln_tbl.COUNT LOOP
830: INL_LOGGING_PVT.Log_Variable (
831: p_module_name => g_module_name,
832: p_procedure_name => l_proc_name,
833: p_var_name => 'l: ',
834: p_var_value => l );

Line 835: INL_LOGGING_PVT.Log_Variable (

831: p_module_name => g_module_name,
832: p_procedure_name => l_proc_name,
833: p_var_name => 'l: ',
834: p_var_value => l );
835: INL_LOGGING_PVT.Log_Variable (
836: p_module_name => g_module_name,
837: p_procedure_name => l_proc_name,
838: p_var_name => 'p_ship_ln_tbl(l).order_line_id ',
839: p_var_value => p_ship_ln_tbl(l).order_line_id );

Line 840: INL_LOGGING_PVT.Log_Variable (

836: p_module_name => g_module_name,
837: p_procedure_name => l_proc_name,
838: p_var_name => 'p_ship_ln_tbl(l).order_line_id ',
839: p_var_value => p_ship_ln_tbl(l).order_line_id );
840: INL_LOGGING_PVT.Log_Variable (
841: p_module_name => g_module_name,
842: p_procedure_name => l_proc_name,
843: p_var_name => 'p_ship_ln_tbl(l).agreement_type ',
844: p_var_value => p_ship_ln_tbl(l).agreement_type );

Line 845: INL_LOGGING_PVT.Log_Variable (

841: p_module_name => g_module_name,
842: p_procedure_name => l_proc_name,
843: p_var_name => 'p_ship_ln_tbl(l).agreement_type ',
844: p_var_value => p_ship_ln_tbl(l).agreement_type );
845: INL_LOGGING_PVT.Log_Variable (
846: p_module_name => g_module_name,
847: p_procedure_name => l_proc_name,
848: p_var_name => 'p_ship_ln_tbl(l).agreement_id ',
849: p_var_value => p_ship_ln_tbl(l).agreement_id );

Line 850: INL_LOGGING_PVT.Log_Variable (

846: p_module_name => g_module_name,
847: p_procedure_name => l_proc_name,
848: p_var_name => 'p_ship_ln_tbl(l).agreement_id ',
849: p_var_value => p_ship_ln_tbl(l).agreement_id );
850: INL_LOGGING_PVT.Log_Variable (
851: p_module_name => g_module_name,
852: p_procedure_name => l_proc_name,
853: p_var_name => 'p_ship_ln_tbl(l).agreement_line_id ',
854: p_var_value => p_ship_ln_tbl(l).agreement_line_id );

Line 855: INL_LOGGING_PVT.Log_Variable (

851: p_module_name => g_module_name,
852: p_procedure_name => l_proc_name,
853: p_var_name => 'p_ship_ln_tbl(l).agreement_line_id ',
854: p_var_value => p_ship_ln_tbl(l).agreement_line_id );
855: INL_LOGGING_PVT.Log_Variable (
856: p_module_name => g_module_name,
857: p_procedure_name => l_proc_name,
858: p_var_name => 'p_ship_ln_tbl(l).supplier_id ',
859: p_var_value => p_ship_ln_tbl(l).supplier_id );

Line 860: INL_LOGGING_PVT.Log_Variable (

856: p_module_name => g_module_name,
857: p_procedure_name => l_proc_name,
858: p_var_name => 'p_ship_ln_tbl(l).supplier_id ',
859: p_var_value => p_ship_ln_tbl(l).supplier_id );
860: INL_LOGGING_PVT.Log_Variable (
861: p_module_name => g_module_name,
862: p_procedure_name => l_proc_name,
863: p_var_name => 'p_ship_ln_tbl(l).supplier_site_id ',
864: p_var_value => p_ship_ln_tbl(l).supplier_site_id );

Line 865: INL_LOGGING_PVT.Log_Variable (

861: p_module_name => g_module_name,
862: p_procedure_name => l_proc_name,
863: p_var_name => 'p_ship_ln_tbl(l).supplier_site_id ',
864: p_var_value => p_ship_ln_tbl(l).supplier_site_id );
865: INL_LOGGING_PVT.Log_Variable (
866: p_module_name => g_module_name,
867: p_procedure_name => l_proc_name,
868: p_var_name => 'p_ship_ln_tbl(l).ship_to_location_id ',
869: p_var_value => p_ship_ln_tbl(l).ship_to_location_id );

Line 870: INL_LOGGING_PVT.Log_Variable (

866: p_module_name => g_module_name,
867: p_procedure_name => l_proc_name,
868: p_var_name => 'p_ship_ln_tbl(l).ship_to_location_id ',
869: p_var_value => p_ship_ln_tbl(l).ship_to_location_id );
870: INL_LOGGING_PVT.Log_Variable (
871: p_module_name => g_module_name,
872: p_procedure_name => l_proc_name,
873: p_var_name => 'p_ship_ln_tbl(l).ship_to_org_id ',
874: p_var_value => p_ship_ln_tbl(l).ship_to_org_id );

Line 875: INL_LOGGING_PVT.Log_Variable (

871: p_module_name => g_module_name,
872: p_procedure_name => l_proc_name,
873: p_var_name => 'p_ship_ln_tbl(l).ship_to_org_id ',
874: p_var_value => p_ship_ln_tbl(l).ship_to_org_id );
875: INL_LOGGING_PVT.Log_Variable (
876: p_module_name => g_module_name,
877: p_procedure_name => l_proc_name,
878: p_var_name => 'p_ship_ln_tbl(l).supplier_item_num ',
879: p_var_value => p_ship_ln_tbl(l).supplier_item_num );

Line 880: INL_LOGGING_PVT.Log_Variable (

876: p_module_name => g_module_name,
877: p_procedure_name => l_proc_name,
878: p_var_name => 'p_ship_ln_tbl(l).supplier_item_num ',
879: p_var_value => p_ship_ln_tbl(l).supplier_item_num );
880: INL_LOGGING_PVT.Log_Variable (
881: p_module_name => g_module_name,
882: p_procedure_name => l_proc_name,
883: p_var_name => 'p_ship_ln_tbl(l).item_revision ',
884: p_var_value => p_ship_ln_tbl(l).item_revision );

Line 885: INL_LOGGING_PVT.Log_Variable (

881: p_module_name => g_module_name,
882: p_procedure_name => l_proc_name,
883: p_var_name => 'p_ship_ln_tbl(l).item_revision ',
884: p_var_value => p_ship_ln_tbl(l).item_revision );
885: INL_LOGGING_PVT.Log_Variable (
886: p_module_name => g_module_name,
887: p_procedure_name => l_proc_name,
888: p_var_name => 'p_ship_ln_tbl(l).item_id ',
889: p_var_value => p_ship_ln_tbl(l).item_id );

Line 890: INL_LOGGING_PVT.Log_Variable (

886: p_module_name => g_module_name,
887: p_procedure_name => l_proc_name,
888: p_var_name => 'p_ship_ln_tbl(l).item_id ',
889: p_var_value => p_ship_ln_tbl(l).item_id );
890: INL_LOGGING_PVT.Log_Variable (
891: p_module_name => g_module_name,
892: p_procedure_name => l_proc_name,
893: p_var_name => 'p_ship_ln_tbl(l).category_id ',
894: p_var_value => p_ship_ln_tbl(l).category_id );

Line 895: INL_LOGGING_PVT.Log_Variable (

891: p_module_name => g_module_name,
892: p_procedure_name => l_proc_name,
893: p_var_name => 'p_ship_ln_tbl(l).category_id ',
894: p_var_value => p_ship_ln_tbl(l).category_id );
895: INL_LOGGING_PVT.Log_Variable (
896: p_module_name => g_module_name,
897: p_procedure_name => l_proc_name,
898: p_var_name => 'p_ship_ln_tbl(l).rate ',
899: p_var_value => p_ship_ln_tbl(l).rate );

Line 900: INL_LOGGING_PVT.Log_Variable (

896: p_module_name => g_module_name,
897: p_procedure_name => l_proc_name,
898: p_var_name => 'p_ship_ln_tbl(l).rate ',
899: p_var_value => p_ship_ln_tbl(l).rate );
900: INL_LOGGING_PVT.Log_Variable (
901: p_module_name => g_module_name,
902: p_procedure_name => l_proc_name,
903: p_var_name => 'p_ship_ln_tbl(l).rate_type ',
904: p_var_value => p_ship_ln_tbl(l).rate_type );

Line 905: INL_LOGGING_PVT.Log_Variable (

901: p_module_name => g_module_name,
902: p_procedure_name => l_proc_name,
903: p_var_name => 'p_ship_ln_tbl(l).rate_type ',
904: p_var_value => p_ship_ln_tbl(l).rate_type );
905: INL_LOGGING_PVT.Log_Variable (
906: p_module_name => g_module_name,
907: p_procedure_name => l_proc_name,
908: p_var_name => 'p_ship_ln_tbl(l).currency_code ',
909: p_var_value => p_ship_ln_tbl(l).currency_code );

Line 910: INL_LOGGING_PVT.Log_Variable (

906: p_module_name => g_module_name,
907: p_procedure_name => l_proc_name,
908: p_var_name => 'p_ship_ln_tbl(l).currency_code ',
909: p_var_value => p_ship_ln_tbl(l).currency_code );
910: INL_LOGGING_PVT.Log_Variable (
911: p_module_name => g_module_name,
912: p_procedure_name => l_proc_name,
913: p_var_name => 'p_ship_ln_tbl(l).need_by_date ',
914: p_var_value => p_ship_ln_tbl(l).need_by_date );

Line 915: INL_LOGGING_PVT.Log_Variable (

911: p_module_name => g_module_name,
912: p_procedure_name => l_proc_name,
913: p_var_name => 'p_ship_ln_tbl(l).need_by_date ',
914: p_var_value => p_ship_ln_tbl(l).need_by_date );
915: INL_LOGGING_PVT.Log_Variable (
916: p_module_name => g_module_name,
917: p_procedure_name => l_proc_name,
918: p_var_name => 'p_ship_ln_tbl(l).shipment_line_id ',
919: p_var_value => p_ship_ln_tbl(l).shipment_line_id );

Line 920: INL_LOGGING_PVT.Log_Variable (

916: p_module_name => g_module_name,
917: p_procedure_name => l_proc_name,
918: p_var_name => 'p_ship_ln_tbl(l).shipment_line_id ',
919: p_var_value => p_ship_ln_tbl(l).shipment_line_id );
920: INL_LOGGING_PVT.Log_Variable (
921: p_module_name => g_module_name,
922: p_procedure_name => l_proc_name,
923: p_var_name => 'p_ship_ln_tbl(l).primary_unit_of_measure',
924: p_var_value => p_ship_ln_tbl(l).primary_unit_of_measure);

Line 925: INL_LOGGING_PVT.Log_Variable (

921: p_module_name => g_module_name,
922: p_procedure_name => l_proc_name,
923: p_var_name => 'p_ship_ln_tbl(l).primary_unit_of_measure',
924: p_var_value => p_ship_ln_tbl(l).primary_unit_of_measure);
925: INL_LOGGING_PVT.Log_Variable (
926: p_module_name => g_module_name,
927: p_procedure_name => l_proc_name,
928: p_var_name => 'p_ship_ln_tbl(l).to_organization_id ',
929: p_var_value => p_ship_ln_tbl(l).to_organization_id );

Line 930: INL_LOGGING_PVT.Log_Variable (

926: p_module_name => g_module_name,
927: p_procedure_name => l_proc_name,
928: p_var_name => 'p_ship_ln_tbl(l).to_organization_id ',
929: p_var_value => p_ship_ln_tbl(l).to_organization_id );
930: INL_LOGGING_PVT.Log_Variable (
931: p_module_name => g_module_name,
932: p_procedure_name => l_proc_name,
933: p_var_name => 'p_ship_ln_tbl(l).unit_of_measure ',
934: p_var_value => p_ship_ln_tbl(l).unit_of_measure );

Line 935: INL_LOGGING_PVT.Log_Variable (

931: p_module_name => g_module_name,
932: p_procedure_name => l_proc_name,
933: p_var_name => 'p_ship_ln_tbl(l).unit_of_measure ',
934: p_var_value => p_ship_ln_tbl(l).unit_of_measure );
935: INL_LOGGING_PVT.Log_Variable (
936: p_module_name => g_module_name,
937: p_procedure_name => l_proc_name,
938: p_var_name => 'p_ship_ln_tbl(l).source_document_code ',
939: p_var_value => p_ship_ln_tbl(l).source_document_code );

Line 940: INL_LOGGING_PVT.Log_Variable (

936: p_module_name => g_module_name,
937: p_procedure_name => l_proc_name,
938: p_var_name => 'p_ship_ln_tbl(l).source_document_code ',
939: p_var_value => p_ship_ln_tbl(l).source_document_code );
940: INL_LOGGING_PVT.Log_Variable (
941: p_module_name => g_module_name,
942: p_procedure_name => l_proc_name,
943: p_var_name => 'p_ship_ln_tbl(l).unit_price ',
944: p_var_value => p_ship_ln_tbl(l).unit_price );

Line 945: INL_LOGGING_PVT.Log_Variable (

941: p_module_name => g_module_name,
942: p_procedure_name => l_proc_name,
943: p_var_name => 'p_ship_ln_tbl(l).unit_price ',
944: p_var_value => p_ship_ln_tbl(l).unit_price );
945: INL_LOGGING_PVT.Log_Variable (
946: p_module_name => g_module_name,
947: p_procedure_name => l_proc_name,
948: p_var_name => 'p_ship_ln_tbl(l).quantity ',
949: p_var_value => p_ship_ln_tbl(l).quantity );

Line 950: INL_LOGGING_PVT.Log_Variable (

946: p_module_name => g_module_name,
947: p_procedure_name => l_proc_name,
948: p_var_name => 'p_ship_ln_tbl(l).quantity ',
949: p_var_value => p_ship_ln_tbl(l).quantity );
950: INL_LOGGING_PVT.Log_Variable (
951: p_module_name => g_module_name,
952: p_procedure_name => l_proc_name,
953: p_var_name => 'p_ship_ln_tbl(l).primary_quantity ',
954: p_var_value => p_ship_ln_tbl(l).primary_quantity );--BUG#8928845

Line 960: INL_LOGGING_PVT.Log_Statement (

956: END IF;
957:
958: -- Bug #8304106
959: l_debug_info := 'Check profile QP_LICENSED_FOR_PRODUCT';
960: INL_LOGGING_PVT.Log_Statement (
961: p_module_name => g_module_name,
962: p_procedure_name => l_proc_name,
963: p_debug_info => l_debug_info);
964:

Line 967: INL_LOGGING_PVT.Log_Variable (

963: p_debug_info => l_debug_info);
964:
965: FND_PROFILE.get('QP_LICENSED_FOR_PRODUCT',l_qp_license);
966:
967: INL_LOGGING_PVT.Log_Variable (
968: p_module_name => g_module_name,
969: p_procedure_name => l_proc_name,
970: p_var_name => 'l_qp_license',
971: p_var_value => l_qp_license);

Line 982: INL_LOGGING_PVT.Log_Statement (

978: RAISE L_FND_EXC_ERROR;
979: END IF;
980:
981: l_debug_info := 'Call QP_PRICE_REQUEST_CONTEXT.set_request_id';
982: INL_LOGGING_PVT.Log_Statement (
983: p_module_name => g_module_name,
984: p_procedure_name => l_proc_name,
985: p_debug_info => l_debug_info);
986:

Line 993: INL_LOGGING_PVT.Log_Statement (

989: -- pricing engine call.
990: QP_PRICE_REQUEST_CONTEXT.set_request_id;
991:
992: l_debug_info := 'Initialize the Global HDR Structure and QP Context';
993: INL_LOGGING_PVT.Log_Statement (
994: p_module_name => g_module_name,
995: p_procedure_name => l_proc_name,
996: p_debug_info => l_debug_info);
997:

Line 1024: INL_LOGGING_PVT.Log_Statement (

1020: p_expected_receipt_date => p_ship_ln_group_rec.expected_receipt_date,
1021: x_return_status => l_return_status);
1022:
1023: l_debug_info := 'Call QP_ATTR_MAPPING_PUB.Build_Contexts for HEADER';
1024: INL_LOGGING_PVT.Log_Statement (
1025: p_module_name => g_module_name,
1026: p_procedure_name => l_proc_name,
1027: p_debug_info => l_debug_info);
1028:

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

1072: l_list_price_overide_flag_tbl(l_line_index) := 'O';
1073: l_line_index := l_line_index + 1;
1074:
1075: l_debug_info := 'Loop to initialize the Global LINE Structure and QP Context';
1076: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1077: p_procedure_name => l_proc_name,
1078: p_debug_info => l_debug_info);
1079:
1080: FOR j IN 1..p_ship_ln_tbl.COUNT LOOP

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

1078: p_debug_info => l_debug_info);
1079:
1080: FOR j IN 1..p_ship_ln_tbl.COUNT LOOP
1081: l_debug_info := 'Call Populate_LineRecord';
1082: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1083: p_procedure_name => l_proc_name,
1084: p_debug_info => l_debug_info);
1085:
1086: -- Populate the Global Line Structure

Line 1113: INL_LOGGING_PVT.Log_Statement (

1109: p_quantity => p_ship_ln_tbl(j).quantity,
1110: x_return_status => l_return_status);
1111:
1112: l_debug_info := 'Call QP_ATTR_MAPPING_PUB.Build_Contexts for each LINE';
1113: INL_LOGGING_PVT.Log_Statement (
1114: p_module_name => g_module_name,
1115: p_procedure_name => l_proc_name,
1116: p_debug_info => l_debug_info);
1117:

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

1169: l_line_index := l_line_index + 1;
1170: END LOOP;
1171:
1172: l_debug_info := 'Call QP_PREQ_GRP.INSERT_LINES2 to insert into qp_preq_lines_tmp table';
1173: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1174: p_procedure_name => l_proc_name,
1175: p_debug_info => l_debug_info);
1176:
1177: -- Insert the request lines into the pricing temporary table qp_preq_lines_tmp

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

1226: RAISE L_FND_EXC_ERROR;
1227: END IF;
1228:
1229: l_debug_info := 'Populate Control Record variables for Pricing Request Call';
1230: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1231: p_procedure_name => l_proc_name,
1232: p_debug_info => l_debug_info);
1233:
1234: l_control_rec.calculate_flag := 'Y';

Line 1248: INL_LOGGING_PVT.Log_Statement (

1244: l_control_rec.function_currency := p_ship_ln_group_rec.currency_code;
1245: l_control_rec.get_freight_flag := 'N';
1246:
1247: l_debug_info := 'Call QP_PREQ_PUB.PRICE_REQUEST';
1248: INL_LOGGING_PVT.Log_Statement (
1249: p_module_name => g_module_name,
1250: p_procedure_name => l_proc_name,
1251: p_debug_info => l_debug_info
1252: );

Line 1275: INL_LOGGING_PVT.Log_Statement (

1271:
1272: -- Access the QP qp_ldets_v view to retrieve the freight charge info.
1273: FOR k IN 1..l_line_index-1 LOOP
1274: l_debug_info := 'Access the QP qp_ldets_v view to retrieve the freight charge info.';
1275: INL_LOGGING_PVT.Log_Statement (
1276: p_module_name => g_module_name,
1277: p_procedure_name => l_proc_name,
1278: p_debug_info => l_debug_info
1279: );

Line 1299: INL_LOGGING_PVT.Log_Statement (

1295: l_qp_cost_table(k).freight_charge_rec_tbl := l_freight_charge_rec_tbl;
1296: l_qp_cost_table(k).line_id := l_line_id_tbl(k);
1297:
1298: l_debug_info := 'Get pricing_status_code and pricing_status_text from qp_preq_lines_tmp';
1299: INL_LOGGING_PVT.Log_Statement (
1300: p_module_name => g_module_name,
1301: p_procedure_name => l_proc_name,
1302: p_debug_info => l_debug_info
1303: );

Line 1314: INL_LOGGING_PVT.Log_Statement (

1310: WHERE line_index = k;
1311: END LOOP;
1312:
1313: l_debug_info := 'Check if the l_qp_cost_table has records';
1314: INL_LOGGING_PVT.Log_Statement (
1315: p_module_name => g_module_name,
1316: p_procedure_name => l_proc_name,
1317: p_debug_info => l_debug_info
1318: );

Line 1322: INL_LOGGING_PVT.Log_Statement (

1318: );
1319:
1320: IF l_qp_cost_table.COUNT < 1 THEN
1321: l_debug_info := 'l_qp_cost_table has no records';
1322: INL_LOGGING_PVT.Log_Statement (
1323: p_module_name => g_module_name,
1324: p_procedure_name => l_proc_name,
1325: p_debug_info => l_debug_info
1326: );

Line 1330: INL_LOGGING_PVT.Log_Statement (

1326: );
1327: END IF;
1328:
1329: l_debug_info := 'Iterate through all returned l_qp_cost_table records';
1330: INL_LOGGING_PVT.Log_Statement (
1331: p_module_name => g_module_name,
1332: p_procedure_name => l_proc_name,
1333: p_debug_info => l_debug_info
1334: );

Line 1340: INL_LOGGING_PVT.Log_Statement (

1336: FOR k IN 1 .. l_qp_cost_table.COUNT LOOP
1337: BEGIN
1338: IF l_qp_cost_table(k).freight_charge_rec_tbl.COUNT < 1 THEN
1339: l_debug_info := 'The l_no_freight_charge has no records';
1340: INL_LOGGING_PVT.Log_Statement (
1341: p_module_name => g_module_name,
1342: p_procedure_name => l_proc_name,
1343: p_debug_info => l_debug_info
1344: );

Line 1350: INL_LOGGING_PVT.Log_Statement (

1346: END IF;
1347:
1348: l_freight_charge_tbl := l_qp_cost_table(k).freight_charge_rec_tbl;
1349: l_debug_info := 'Iterate through all returned l_freight_charge_tbl records';
1350: INL_LOGGING_PVT.Log_Statement (
1351: p_module_name => g_module_name,
1352: p_procedure_name => l_proc_name,
1353: p_debug_info => l_debug_info
1354: );

Line 1358: INL_LOGGING_PVT.Log_Statement (

1354: );
1355:
1356: FOR n IN 1 .. l_freight_charge_tbl.COUNT LOOP
1357: l_debug_info := 'Call PON_CF_TYPE_GRP.get_cost_factor_details';
1358: INL_LOGGING_PVT.Log_Statement (
1359: p_module_name => g_module_name,
1360: p_procedure_name => l_proc_name,
1361: p_debug_info => l_debug_info
1362: );

Line 1364: INL_LOGGING_PVT.Log_Variable (

1360: p_procedure_name => l_proc_name,
1361: p_debug_info => l_debug_info
1362: );
1363:
1364: INL_LOGGING_PVT.Log_Variable (
1365: p_module_name => g_module_name,
1366: p_procedure_name => l_proc_name,
1367: p_var_name => 'l_freight_charge_tbl(n).charge_type_code',
1368: p_var_value => nvl(l_freight_charge_tbl(n).charge_type_code,'NULL'));

Line 1385: INL_LOGGING_PVT.Log_Variable (

1381: WHERE qcl.lookup_code = l_freight_charge_tbl(n).charge_type_code
1382: AND qcl.lookup_type = 'FREIGHT_COST_TYPE';
1383: END IF;
1384:
1385: INL_LOGGING_PVT.Log_Variable (
1386: p_module_name => g_module_name,
1387: p_procedure_name => l_proc_name,
1388: p_var_name => 'l_qp_charge_lookup',
1389: p_var_value => NVL(l_qp_charge_lookup,0));

Line 1394: INL_LOGGING_PVT.Log_Statement (

1390:
1391: IF (NVL(l_qp_charge_lookup,0) > 0) THEN
1392: l_debug_info := 'LCM only accepts cost factors for charges. Charge ' || l_freight_charge_tbl(n).charge_type_code||
1393: ' cannot be generated.' ;
1394: INL_LOGGING_PVT.Log_Statement (
1395: p_module_name => g_module_name,
1396: p_procedure_name => l_proc_name,
1397: p_debug_info => l_debug_info);
1398: ELSE -- Bug #9274538

Line 1407: INL_LOGGING_PVT.Log_Statement (

1403: WHEN OTHERS THEN
1404: l_cost_factor_valid := 'F';
1405: l_debug_info := 'Cost Factor ' || l_freight_charge_tbl(n).charge_type_code ||
1406: ' is not valid and will not be generated.' ;
1407: INL_LOGGING_PVT.Log_Statement (
1408: p_module_name => g_module_name,
1409: p_procedure_name => l_proc_name,
1410: p_debug_info => l_debug_info);
1411: END;

Line 1413: INL_LOGGING_PVT.Log_Variable (

1409: p_procedure_name => l_proc_name,
1410: p_debug_info => l_debug_info);
1411: END;
1412:
1413: INL_LOGGING_PVT.Log_Variable (
1414: p_module_name => g_module_name,
1415: p_procedure_name => l_proc_name,
1416: p_var_name => 'l_cost_factor_valid',
1417: p_var_value => l_cost_factor_valid);

Line 1421: INL_LOGGING_PVT.Log_Variable (

1417: p_var_value => l_cost_factor_valid);
1418:
1419: IF l_cost_factor_valid = 'T' THEN -- Bug #9274538
1420:
1421: INL_LOGGING_PVT.Log_Variable (
1422: p_module_name => g_module_name,
1423: p_procedure_name => l_proc_name,
1424: p_var_name => 'l_freight_charge_tbl(n).freight_charge',
1425: p_var_value => l_freight_charge_tbl(n).freight_charge);

Line 1427: INL_LOGGING_PVT.Log_Variable (

1423: p_procedure_name => l_proc_name,
1424: p_var_name => 'l_freight_charge_tbl(n).freight_charge',
1425: p_var_value => l_freight_charge_tbl(n).freight_charge);
1426:
1427: INL_LOGGING_PVT.Log_Variable (
1428: p_module_name => g_module_name,
1429: p_procedure_name => l_proc_name,
1430: p_var_name => 'l_freight_charge_tbl(n).pricing_status_code',
1431: p_var_value => nvl(l_freight_charge_tbl(n).pricing_status_code,'NULL'));

Line 1433: INL_LOGGING_PVT.Log_Variable (

1429: p_procedure_name => l_proc_name,
1430: p_var_name => 'l_freight_charge_tbl(n).pricing_status_code',
1431: p_var_value => nvl(l_freight_charge_tbl(n).pricing_status_code,'NULL'));
1432:
1433: INL_LOGGING_PVT.Log_Variable (
1434: p_module_name => g_module_name,
1435: p_procedure_name => l_proc_name,
1436: p_var_name => 'l_freight_charge_tbl(n).pricing_status_text',
1437: p_var_value => nvl(l_freight_charge_tbl(n).pricing_status_text,'NULL'));

Line 1439: INL_LOGGING_PVT.Log_Variable (

1435: p_procedure_name => l_proc_name,
1436: p_var_name => 'l_freight_charge_tbl(n).pricing_status_text',
1437: p_var_value => nvl(l_freight_charge_tbl(n).pricing_status_text,'NULL'));
1438:
1439: INL_LOGGING_PVT.Log_Variable (
1440: p_module_name => g_module_name,
1441: p_procedure_name => l_proc_name,
1442: p_var_name => 'l_freight_charge_tbl(n).modifier_level_code',
1443: p_var_value => nvl(l_freight_charge_tbl(n).modifier_level_code,'NULL'));

Line 1445: INL_LOGGING_PVT.Log_Variable (

1441: p_procedure_name => l_proc_name,
1442: p_var_name => 'l_freight_charge_tbl(n).modifier_level_code',
1443: p_var_value => nvl(l_freight_charge_tbl(n).modifier_level_code,'NULL'));
1444:
1445: INL_LOGGING_PVT.Log_Variable (
1446: p_module_name => g_module_name,
1447: p_procedure_name => l_proc_name,
1448: p_var_name => 'l_freight_charge_tbl(n).override_flag',
1449: p_var_value => nvl(l_freight_charge_tbl(n).override_flag,'NULL'));

Line 1451: INL_LOGGING_PVT.Log_Variable (

1447: p_procedure_name => l_proc_name,
1448: p_var_name => 'l_freight_charge_tbl(n).override_flag',
1449: p_var_value => nvl(l_freight_charge_tbl(n).override_flag,'NULL'));
1450:
1451: INL_LOGGING_PVT.Log_Variable (
1452: p_module_name => g_module_name,
1453: p_procedure_name => l_proc_name,
1454: p_var_name => 'l_freight_charge_tbl(n).operand_calculation_code',
1455: p_var_value => nvl(l_freight_charge_tbl(n).operand_calculation_code,'NULL'));

Line 1457: INL_LOGGING_PVT.Log_Variable (

1453: p_procedure_name => l_proc_name,
1454: p_var_name => 'l_freight_charge_tbl(n).operand_calculation_code',
1455: p_var_value => nvl(l_freight_charge_tbl(n).operand_calculation_code,'NULL'));
1456:
1457: INL_LOGGING_PVT.Log_Variable (
1458: p_module_name => g_module_name,
1459: p_procedure_name => l_proc_name,
1460: p_var_name => 'l_cost_factor_details.price_element_type_id',
1461: p_var_value => l_cost_factor_details.price_element_type_id);

Line 1463: INL_LOGGING_PVT.Log_Variable (

1459: p_procedure_name => l_proc_name,
1460: p_var_name => 'l_cost_factor_details.price_element_type_id',
1461: p_var_value => l_cost_factor_details.price_element_type_id);
1462:
1463: INL_LOGGING_PVT.Log_Variable (
1464: p_module_name => g_module_name,
1465: p_procedure_name => l_proc_name,
1466: p_var_name => 'l_cost_factor_details.cost_component_class_id',
1467: p_var_value => l_cost_factor_details.cost_component_class_id);

Line 1469: INL_LOGGING_PVT.Log_Variable (

1465: p_procedure_name => l_proc_name,
1466: p_var_name => 'l_cost_factor_details.cost_component_class_id',
1467: p_var_value => l_cost_factor_details.cost_component_class_id);
1468:
1469: INL_LOGGING_PVT.Log_Variable (
1470: p_module_name => g_module_name,
1471: p_procedure_name => l_proc_name,
1472: p_var_name => 'l_cost_factor_details.cost_analysis_code',
1473: p_var_value => nvl(l_cost_factor_details.cost_analysis_code,'NULL'));

Line 1475: INL_LOGGING_PVT.Log_Variable (

1471: p_procedure_name => l_proc_name,
1472: p_var_name => 'l_cost_factor_details.cost_analysis_code',
1473: p_var_value => nvl(l_cost_factor_details.cost_analysis_code,'NULL'));
1474:
1475: INL_LOGGING_PVT.Log_Variable (
1476: p_module_name => g_module_name,
1477: p_procedure_name => l_proc_name,
1478: p_var_name => 'l_cost_factor_details.cost_acquisition_code',
1479: p_var_value => nvl(l_cost_factor_details.cost_acquisition_code,'NULL'));

Line 1481: INL_LOGGING_PVT.Log_Variable (

1477: p_procedure_name => l_proc_name,
1478: p_var_name => 'l_cost_factor_details.cost_acquisition_code',
1479: p_var_value => nvl(l_cost_factor_details.cost_acquisition_code,'NULL'));
1480:
1481: INL_LOGGING_PVT.Log_Variable (
1482: p_module_name => g_module_name,
1483: p_procedure_name => l_proc_name,
1484: p_var_name => 'l_cost_factor_details.price_element_code',
1485: p_var_value => nvl(l_cost_factor_details.price_element_code,'NULL'));

Line 1487: INL_LOGGING_PVT.Log_Variable (

1483: p_procedure_name => l_proc_name,
1484: p_var_name => 'l_cost_factor_details.price_element_code',
1485: p_var_value => nvl(l_cost_factor_details.price_element_code,'NULL'));
1486:
1487: INL_LOGGING_PVT.Log_Variable (
1488: p_module_name => g_module_name,
1489: p_procedure_name => l_proc_name,
1490: p_var_name => 'l_cost_factor_details.pricing_basis',
1491: p_var_value => nvl(l_cost_factor_details.pricing_basis,'NULL'));

Line 1493: INL_LOGGING_PVT.Log_Variable (

1489: p_procedure_name => l_proc_name,
1490: p_var_name => 'l_cost_factor_details.pricing_basis',
1491: p_var_value => nvl(l_cost_factor_details.pricing_basis,'NULL'));
1492:
1493: INL_LOGGING_PVT.Log_Variable (
1494: p_module_name => g_module_name,
1495: p_procedure_name => l_proc_name,
1496: p_var_name => 'l_cost_factor_details.allocation_basis',
1497: p_var_value => nvl(l_cost_factor_details.allocation_basis,'NULL'));

Line 1499: INL_LOGGING_PVT.Log_Variable (

1495: p_procedure_name => l_proc_name,
1496: p_var_name => 'l_cost_factor_details.allocation_basis',
1497: p_var_value => nvl(l_cost_factor_details.allocation_basis,'NULL'));
1498:
1499: INL_LOGGING_PVT.Log_Variable (
1500: p_module_name => g_module_name,
1501: p_procedure_name => l_proc_name,
1502: p_var_name => 'l_cost_factor_details.invoice_line_type',
1503: p_var_value => nvl(l_cost_factor_details.invoice_line_type,'NULL'));

Line 1506: INL_LOGGING_PVT.Log_Variable (

1502: p_var_name => 'l_cost_factor_details.invoice_line_type',
1503: p_var_value => nvl(l_cost_factor_details.invoice_line_type,'NULL'));
1504:
1505: IF l_freight_charge_tbl(n).modifier_level_code = 'LINE' THEN
1506: INL_LOGGING_PVT.Log_Variable (
1507: p_module_name => g_module_name,
1508: p_procedure_name => l_proc_name,
1509: p_var_name => 'k',
1510: p_var_value => k);

Line 1512: INL_LOGGING_PVT.Log_Variable (

1508: p_procedure_name => l_proc_name,
1509: p_var_name => 'k',
1510: p_var_value => k);
1511:
1512: INL_LOGGING_PVT.Log_Variable (
1513: p_module_name => g_module_name,
1514: p_procedure_name => l_proc_name,
1515: p_var_name => 'l_qp_cost_table(k).line_id',
1516: p_var_value => l_qp_cost_table(k).line_id);

Line 1518: INL_LOGGING_PVT.Log_Variable (

1514: p_procedure_name => l_proc_name,
1515: p_var_name => 'l_qp_cost_table(k).line_id',
1516: p_var_value => l_qp_cost_table(k).line_id);
1517:
1518: INL_LOGGING_PVT.Log_Variable (
1519: p_module_name => g_module_name,
1520: p_procedure_name => l_proc_name,
1521: p_var_name => 'l_line_quantities(l_qp_cost_table(k).line_id',
1522: p_var_value => to_char(l_line_quantities(l_qp_cost_table(k).line_id)));

Line 1524: INL_LOGGING_PVT.Log_Variable (

1520: p_procedure_name => l_proc_name,
1521: p_var_name => 'l_line_quantities(l_qp_cost_table(k).line_id',
1522: p_var_value => to_char(l_line_quantities(l_qp_cost_table(k).line_id)));
1523:
1524: INL_LOGGING_PVT.Log_Variable (
1525: p_module_name => g_module_name,
1526: p_procedure_name => l_proc_name,
1527: p_var_name => 'l_line_1ary_quantities(l_qp_cost_table(k).line_id',
1528: p_var_value => to_char(l_line_1ary_quantities(l_qp_cost_table(k).line_id)));

Line 1532: INL_LOGGING_PVT.Log_Statement (

1528: p_var_value => to_char(l_line_1ary_quantities(l_qp_cost_table(k).line_id)));
1529: END IF;
1530:
1531: l_debug_info := 'Populate the x_charge_ln_tbl type table';
1532: INL_LOGGING_PVT.Log_Statement (
1533: p_module_name => g_module_name,
1534: p_procedure_name => l_proc_name,
1535: p_debug_info => l_debug_info);
1536:

Line 1568: INL_LOGGING_PVT.Log_Statement (

1564: END LOOP;
1565: EXCEPTION
1566: WHEN l_no_freight_charge THEN
1567: l_debug_info := 'No QP charge for the line : ' || l_qp_cost_table(k).line_id;
1568: INL_LOGGING_PVT.Log_Statement (
1569: p_module_name => g_module_name,
1570: p_procedure_name => l_proc_name,
1571: p_debug_info => l_debug_info
1572: );

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

1573: END;
1574: END LOOP;
1575:
1576: -- End the procedure
1577: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1578: p_procedure_name => l_proc_name);
1579: EXCEPTION
1580: WHEN L_FND_EXC_ERROR THEN
1581: --raised expected error: assume raiser already pushed onto the stack

Line 1590: INL_LOGGING_PVT.Log_Statement (

1586: FND_MESSAGE.set_name('INL', 'INL_ERR_QP_PRICE_API');
1587: FND_MESSAGE.set_token('ERROR_TEXT',l_exception_msg);
1588:
1589: l_debug_info := 'Erro: ' || sqlerrm;
1590: INL_LOGGING_PVT.Log_Statement (
1591: p_module_name => g_module_name,
1592: p_procedure_name => l_proc_name,
1593: p_debug_info => l_debug_info);
1594:

Line 1605: INL_LOGGING_PVT.Log_Statement (

1601: FND_MESSAGE.set_name('INL', 'INL_ERR_QP_PRICE_API');
1602: FND_MESSAGE.set_token('ERROR_TEXT',l_exception_msg);
1603:
1604: l_debug_info := 'Erro: ' || sqlerrm;
1605: INL_LOGGING_PVT.Log_Statement (
1606: p_module_name => g_module_name,
1607: p_procedure_name => l_proc_name,
1608: p_debug_info => l_debug_info);
1609:

Line 1619: INL_LOGGING_PVT.Log_Statement (

1615: FND_MESSAGE.set_name('INL', 'INL_ERR_QP_PRICE_API');
1616: FND_MESSAGE.set_token('ERROR_TEXT',l_exception_msg);
1617:
1618: l_debug_info := 'Erro: ' || sqlerrm;
1619: INL_LOGGING_PVT.Log_Statement (
1620: p_module_name => g_module_name,
1621: p_procedure_name => l_proc_name,
1622: p_debug_info => l_debug_info);
1623:

Line 1662: INL_LOGGING_PVT.Log_BeginProc (

1658: l_get_rcv_head_info VARCHAR2(1) := 'Y';
1659: ln_index NUMBER;
1660: BEGIN
1661: -- Begin the procedure
1662: INL_LOGGING_PVT.Log_BeginProc (
1663: p_module_name => g_module_name,
1664: p_procedure_name => l_proc_name);
1665: -- Init return status
1666: x_return_status := L_FND_RET_STS_SUCCESS;

Line 1669: INL_LOGGING_PVT.Log_Statement (

1665: -- Init return status
1666: x_return_status := L_FND_RET_STS_SUCCESS;
1667:
1668: l_debug_info := 'Populate a Shipment Line Group record type';
1669: INL_LOGGING_PVT.Log_Statement (
1670: p_module_name => g_module_name,
1671: p_procedure_name => l_proc_name,
1672: p_debug_info => l_debug_info);
1673: -- Populate header dependent variables

Line 1696: INL_LOGGING_PVT.Log_Statement (

1692:
1693: ln_index := p_ship_ln_tbl.FIRST;
1694: FOR i IN 1 .. p_ship_ln_group_tbl.COUNT LOOP
1695: l_debug_info := 'Populate line group dependent variables';
1696: INL_LOGGING_PVT.Log_Statement (
1697: p_module_name => g_module_name,
1698: p_procedure_name => l_proc_name,
1699: p_debug_info => l_debug_info);
1700:

Line 1708: INL_LOGGING_PVT.Log_Statement (

1704: l_ship_ln_group_rec.shipment_header_id := p_ship_ln_group_tbl(i).ship_line_group_id;
1705: l_ship_ln_group_rec.ship_line_group_id := p_ship_ln_group_tbl(i).ship_line_group_id;
1706: FOR l IN ln_index..p_ship_ln_tbl.COUNT LOOP
1707: l_debug_info := 'Populate lines dependent variables ('||l||')';
1708: INL_LOGGING_PVT.Log_Statement (
1709: p_module_name => g_module_name,
1710: p_procedure_name => l_proc_name,
1711: p_debug_info => l_debug_info);
1712:

Line 1726: INL_LOGGING_PVT.Log_Variable (

1722: l_ship_ln_tbl(l - ln_index + 1).primary_unit_of_measure := p_ship_ln_tbl(l).primary_uom_code;
1723: l_ship_ln_tbl(l - ln_index + 1).unit_of_measure := p_ship_ln_tbl(l).txn_uom_code;
1724: l_ship_ln_tbl(l - ln_index + 1).source_document_code := p_ship_ln_group_tbl(i).src_type_code;
1725:
1726: INL_LOGGING_PVT.Log_Variable (
1727: p_module_name => g_module_name,
1728: p_procedure_name => l_proc_name,
1729: p_var_name => 'l_ship_ln_group_rec.currency_code',
1730: p_var_value => l_ship_ln_group_rec.currency_code);

Line 1732: INL_LOGGING_PVT.Log_Variable (

1728: p_procedure_name => l_proc_name,
1729: p_var_name => 'l_ship_ln_group_rec.currency_code',
1730: p_var_value => l_ship_ln_group_rec.currency_code);
1731:
1732: INL_LOGGING_PVT.Log_Variable (
1733: p_module_name => g_module_name,
1734: p_procedure_name => l_proc_name,
1735: p_var_name => 'p_ship_ln_tbl(l).currency_code',
1736: p_var_value => p_ship_ln_tbl(l).currency_code);

Line 1744: INL_LOGGING_PVT.Log_Variable (

1740: l_ship_ln_tbl(l - ln_index + 1).rate := p_ship_ln_tbl(l).currency_conversion_rate;
1741: l_ship_ln_tbl(l - ln_index + 1).unit_price := p_ship_ln_tbl(l).txn_unit_price;
1742: ELSE
1743:
1744: INL_LOGGING_PVT.Log_Variable (
1745: p_module_name => g_module_name,
1746: p_procedure_name => l_proc_name,
1747: p_var_name => 'l_ship_ln_group_rec.qp_curr_conv_type',
1748: p_var_value => l_ship_ln_group_rec.qp_curr_conv_type);

Line 1750: INL_LOGGING_PVT.Log_Variable (

1746: p_procedure_name => l_proc_name,
1747: p_var_name => 'l_ship_ln_group_rec.qp_curr_conv_type',
1748: p_var_value => l_ship_ln_group_rec.qp_curr_conv_type);
1749:
1750: INL_LOGGING_PVT.Log_Variable (
1751: p_module_name => g_module_name,
1752: p_procedure_name => l_proc_name,
1753: p_var_name => 'l_qp_curr_conv_date',
1754: p_var_value => l_qp_curr_conv_date);

Line 1764: INL_LOGGING_PVT.Log_Variable (

1760: l_ship_ln_group_rec.qp_curr_conv_type,
1761: l_qp_curr_conv_date,
1762: l_ship_ln_tbl(l - ln_index + 1).rate);
1763: END IF;
1764: INL_LOGGING_PVT.Log_Variable (
1765: p_module_name => g_module_name,
1766: p_procedure_name => l_proc_name,
1767: p_var_name => 'l_ship_ln_tbl(l - ln_index + 1).rate',
1768: p_var_value => l_ship_ln_tbl(l - ln_index + 1).rate);

Line 1770: INL_LOGGING_PVT.Log_Variable (

1766: p_procedure_name => l_proc_name,
1767: p_var_name => 'l_ship_ln_tbl(l - ln_index + 1).rate',
1768: p_var_value => l_ship_ln_tbl(l - ln_index + 1).rate);
1769:
1770: INL_LOGGING_PVT.Log_Variable (
1771: p_module_name => g_module_name,
1772: p_procedure_name => l_proc_name,
1773: p_var_name => 'l_ship_ln_tbl(l - ln_index + 1).unit_price',
1774: p_var_value => l_ship_ln_tbl(l - ln_index + 1).unit_price);

Line 1787: INL_LOGGING_PVT.Log_Variable (

1783: l_ship_ln_tbl(l - ln_index + 1).quantity := p_ship_ln_tbl(l).txn_qty;
1784:
1785: l_ship_ln_tbl(l - ln_index + 1).primary_quantity := p_ship_ln_tbl(l).primary_qty; --BUG#8928845
1786:
1787: INL_LOGGING_PVT.Log_Variable (
1788: p_module_name => g_module_name,
1789: p_procedure_name => l_proc_name,
1790: p_var_name => 'p_ship_ln_group_tbl(i).src_type_code',
1791: p_var_value => p_ship_ln_group_tbl(i).src_type_code);

Line 1795: INL_LOGGING_PVT.Log_Variable (

1791: p_var_value => p_ship_ln_group_tbl(i).src_type_code);
1792:
1793: IF p_ship_ln_group_tbl(i).src_type_code = 'PO'
1794: THEN
1795: INL_LOGGING_PVT.Log_Variable (
1796: p_module_name => g_module_name,
1797: p_procedure_name => l_proc_name,
1798: p_var_name => 'l_ship_ln_group_rec.supplier_id',
1799: p_var_value => l_ship_ln_group_rec.supplier_id);

Line 1801: INL_LOGGING_PVT.Log_Variable (

1797: p_procedure_name => l_proc_name,
1798: p_var_name => 'l_ship_ln_group_rec.supplier_id',
1799: p_var_value => l_ship_ln_group_rec.supplier_id);
1800:
1801: INL_LOGGING_PVT.Log_Variable (
1802: p_module_name => g_module_name,
1803: p_procedure_name => l_proc_name,
1804: p_var_name => 'p_ship_ln_tbl(l).ship_line_source_id',
1805: p_var_value => p_ship_ln_tbl(l).ship_line_source_id);

Line 1861: INL_LOGGING_PVT.Log_Variable (

1857: AND pll.line_location_id = p_ship_ln_tbl(l).ship_line_source_id;
1858: END IF;
1859: END IF;
1860:
1861: INL_LOGGING_PVT.Log_Variable (
1862: p_module_name => g_module_name,
1863: p_procedure_name => l_proc_name,
1864: p_var_name => 'p_ship_header_rec.rcv_enabled_flag',
1865: p_var_value => p_ship_header_rec.rcv_enabled_flag);

Line 1868: INL_LOGGING_PVT.Log_Variable (

1864: p_var_name => 'p_ship_header_rec.rcv_enabled_flag',
1865: p_var_value => p_ship_header_rec.rcv_enabled_flag);
1866:
1867:
1868: INL_LOGGING_PVT.Log_Variable (
1869: p_module_name => g_module_name,
1870: p_procedure_name => l_proc_name,
1871: p_var_name => 'p_ship_ln_tbl(l).ship_line_id',
1872: p_var_value => p_ship_ln_tbl(l).ship_line_id);

Line 2015: INL_LOGGING_PVT.Log_Statement (

2011: END IF;
2012: END LOOP;
2013:
2014: l_debug_info := 'Call Get_ChargesFromQP(...)';
2015: INL_LOGGING_PVT.Log_Statement (
2016: p_module_name => g_module_name,
2017: p_procedure_name => l_proc_name,
2018: p_debug_info => l_debug_info);
2019:

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

2036:
2037: END LOOP;
2038:
2039: -- End the procedure
2040: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
2041: p_procedure_name => l_proc_name);
2042: EXCEPTION
2043: WHEN L_FND_EXC_ERROR THEN
2044: --raised expected error: assume raiser already pushed onto the stack

Line 2097: INL_LOGGING_PVT.Log_BeginProc(

2093: l_simul_ship_line_id NUMBER;
2094: BEGIN
2095:
2096: -- Standard Beginning of Procedure/Function Logging
2097: INL_LOGGING_PVT.Log_BeginProc(
2098: p_module_name => g_module_name,
2099: p_procedure_name => l_func_name) ;
2100:
2101: -- Initialize API return status to success

Line 2104: INL_LOGGING_PVT.Log_Variable(

2100:
2101: -- Initialize API return status to success
2102: x_return_status := L_FND_RET_STS_SUCCESS;
2103:
2104: INL_LOGGING_PVT.Log_Variable(
2105: p_module_name => g_module_name,
2106: p_procedure_name => l_func_name,
2107: p_var_name => 'p_ship_line_id',
2108: p_var_value => p_ship_line_id);

Line 2117: INL_LOGGING_PVT.Log_Variable(

2113: l_ship_line_source_id
2114: FROM inl_ship_lines sl
2115: WHERE sl.ship_line_id = p_ship_line_id;
2116:
2117: INL_LOGGING_PVT.Log_Variable(
2118: p_module_name => g_module_name,
2119: p_procedure_name => l_func_name,
2120: p_var_name => 'l_ship_line_src_type_code',
2121: p_var_value => l_ship_line_src_type_code);

Line 2123: INL_LOGGING_PVT.Log_Variable(

2119: p_procedure_name => l_func_name,
2120: p_var_name => 'l_ship_line_src_type_code',
2121: p_var_value => l_ship_line_src_type_code);
2122:
2123: INL_LOGGING_PVT.Log_Variable(
2124: p_module_name => g_module_name,
2125: p_procedure_name => l_func_name,
2126: p_var_name => 'l_ship_line_source_id',
2127: p_var_value => l_ship_line_source_id);

Line 2130: INL_LOGGING_PVT.Log_Statement(

2126: p_var_name => 'l_ship_line_source_id',
2127: p_var_value => l_ship_line_source_id);
2128:
2129: l_debug_info := 'Get the simulated Shipment Line Id';
2130: INL_LOGGING_PVT.Log_Statement(
2131: p_module_name => g_module_name,
2132: p_procedure_name => l_func_name,
2133: p_debug_info => l_debug_info);
2134:

Line 2174: INL_LOGGING_PVT.Log_Variable(

2170: -- Shipment Line could not have simulated shipment line
2171: WHEN NO_DATA_FOUND THEN NULL;
2172: END;
2173:
2174: INL_LOGGING_PVT.Log_Variable(
2175: p_module_name => g_module_name,
2176: p_procedure_name => l_func_name,
2177: p_var_name => 'l_simul_ship_line_id',
2178: p_var_value => l_simul_ship_line_id);

Line 2181: INL_LOGGING_PVT.Log_EndProc(

2177: p_var_name => 'l_simul_ship_line_id',
2178: p_var_value => l_simul_ship_line_id);
2179:
2180: -- Standard End of Procedure/Function Logging
2181: INL_LOGGING_PVT.Log_EndProc(
2182: p_module_name => g_module_name,
2183: p_procedure_name => l_func_name);
2184:
2185: RETURN l_simul_ship_line_id;

Line 2190: INL_LOGGING_PVT.Log_ExpecError (

2186:
2187: EXCEPTION
2188: WHEN L_FND_EXC_ERROR THEN
2189: -- Standard Expected Error Logging
2190: INL_LOGGING_PVT.Log_ExpecError (
2191: p_module_name => g_module_name,
2192: p_procedure_name => l_func_name);
2193: RETURN NULL;
2194: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN

Line 2196: INL_LOGGING_PVT.Log_UnexpecError (

2192: p_procedure_name => l_func_name);
2193: RETURN NULL;
2194: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
2195: -- Standard Unexpected Error Logging
2196: INL_LOGGING_PVT.Log_UnexpecError (
2197: p_module_name => g_module_name,
2198: p_procedure_name => l_func_name);
2199: RETURN NULL;
2200: WHEN OTHERS THEN

Line 2202: INL_LOGGING_PVT.Log_UnexpecError (

2198: p_procedure_name => l_func_name);
2199: RETURN NULL;
2200: WHEN OTHERS THEN
2201: -- Standard Unexpected Error Logging
2202: INL_LOGGING_PVT.Log_UnexpecError (
2203: p_module_name => g_module_name,
2204: p_procedure_name => l_func_name);
2205: IF FND_MSG_PUB.Check_Msg_Level(
2206: p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 2292: INL_LOGGING_PVT.Log_BeginProc (

2288: l_charge_ln_index NUMBER := NVL(x_charge_ln_tbl.count,0) + 1;
2289:
2290: BEGIN
2291: -- Begin the procedure
2292: INL_LOGGING_PVT.Log_BeginProc (
2293: p_module_name => g_module_name,
2294: p_procedure_name => l_proc_name);
2295:
2296: -- Init return status

Line 2299: INL_LOGGING_PVT.Log_Variable(

2295:
2296: -- Init return status
2297: x_return_status := L_FND_RET_STS_SUCCESS;
2298:
2299: INL_LOGGING_PVT.Log_Variable(
2300: p_module_name => g_module_name,
2301: p_procedure_name => l_proc_name,
2302: p_var_name => 'p_ship_header_id',
2303: p_var_value => p_ship_header_id);

Line 2323: INL_LOGGING_PVT.Log_Variable(

2319: ELSIF l_return_status = L_FND_RET_STS_UNEXP_ERROR THEN
2320: RAISE L_FND_EXC_UNEXPECTED_ERROR;
2321: END IF;
2322:
2323: INL_LOGGING_PVT.Log_Variable(
2324: p_module_name => g_module_name,
2325: p_procedure_name => l_proc_name,
2326: p_var_name => 'l_simul_ship_line_id',
2327: p_var_value => l_simul_ship_line_id);

Line 2338: INL_LOGGING_PVT.Log_Variable(

2334: financials_system_parameters fsp
2335: WHERE gl.set_of_books_id = fsp.set_of_books_id
2336: AND fsp.org_id = ship_ln_list(i).org_id;
2337:
2338: INL_LOGGING_PVT.Log_Variable(
2339: p_module_name => g_module_name,
2340: p_procedure_name => l_proc_name,
2341: p_var_name => 'l_func_currency_code',
2342: p_var_value => l_func_currency_code);

Line 2349: INL_LOGGING_PVT.Log_Variable(

2345: OPEN c_charge_ln(l_simul_ship_line_id);
2346: FETCH c_charge_ln BULK COLLECT INTO charge_ln_list;
2347: CLOSE c_charge_ln;
2348:
2349: INL_LOGGING_PVT.Log_Variable(
2350: p_module_name => g_module_name,
2351: p_procedure_name => l_proc_name,
2352: p_var_name => 'charge_ln_list.COUNT,',
2353: p_var_value => NVL(charge_ln_list.COUNT,0));

Line 2358: INL_LOGGING_PVT.Log_Statement (

2354:
2355: FOR j IN 1 .. charge_ln_list.COUNT
2356: LOOP
2357: l_debug_info := 'Collect data to be passed to Insert_ChargeLines' ;
2358: INL_LOGGING_PVT.Log_Statement (
2359: p_module_name => g_module_name,
2360: p_procedure_name => l_proc_name,
2361: p_debug_info => l_debug_info);
2362:

Line 2363: INL_LOGGING_PVT.Log_Variable(

2359: p_module_name => g_module_name,
2360: p_procedure_name => l_proc_name,
2361: p_debug_info => l_debug_info);
2362:
2363: INL_LOGGING_PVT.Log_Variable(
2364: p_module_name => g_module_name,
2365: p_procedure_name => l_proc_name,
2366: p_var_name => 'ship_ln_list(i).primary_qty',
2367: p_var_value => ship_ln_list(i).primary_qty);

Line 2369: INL_LOGGING_PVT.Log_Variable(

2365: p_procedure_name => l_proc_name,
2366: p_var_name => 'ship_ln_list(i).primary_qty',
2367: p_var_value => ship_ln_list(i).primary_qty);
2368:
2369: INL_LOGGING_PVT.Log_Variable(
2370: p_module_name => g_module_name,
2371: p_procedure_name => l_proc_name,
2372: p_var_name => 'charge_ln_list(j).unit_charge_amt',
2373: p_var_value => charge_ln_list(j).unit_charge_amt);

Line 2411: INL_LOGGING_PVT.Log_Variable(

2407: x_charge_ln_tbl(l_charge_ln_index).poo_location_id := charge_ln_list(j).poo_location_id;
2408: x_charge_ln_tbl(l_charge_ln_index).to_parent_table_name := 'INL_SHIP_LINES';
2409: x_charge_ln_tbl(l_charge_ln_index).to_parent_table_id := ship_ln_list(i).ship_line_id;
2410:
2411: INL_LOGGING_PVT.Log_Variable(
2412: p_module_name => g_module_name,
2413: p_procedure_name => l_proc_name,
2414: p_var_name => 'x_charge_ln_tbl(l_charge_ln_index).charge_amt',
2415: p_var_value => x_charge_ln_tbl(l_charge_ln_index).charge_amt);

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

2425: END IF;
2426: END LOOP;
2427: END IF;
2428: -- End the procedure
2429: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
2430: p_procedure_name => l_proc_name);
2431:
2432: EXCEPTION
2433: WHEN L_FND_EXC_ERROR THEN

Line 2435: INL_LOGGING_PVT.Log_ExpecError (

2431:
2432: EXCEPTION
2433: WHEN L_FND_EXC_ERROR THEN
2434: -- Standard Expected Error Logging
2435: INL_LOGGING_PVT.Log_ExpecError (
2436: p_module_name => g_module_name,
2437: p_procedure_name => l_proc_name);
2438: x_return_status := L_FND_RET_STS_ERROR;
2439: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN

Line 2441: INL_LOGGING_PVT.Log_UnexpecError (

2437: p_procedure_name => l_proc_name);
2438: x_return_status := L_FND_RET_STS_ERROR;
2439: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
2440: -- Standard Unexpected Error Logging
2441: INL_LOGGING_PVT.Log_UnexpecError (
2442: p_module_name => g_module_name,
2443: p_procedure_name => l_proc_name);
2444: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2445: WHEN OTHERS THEN

Line 2447: INL_LOGGING_PVT.Log_UnexpecError (

2443: p_procedure_name => l_proc_name);
2444: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2445: WHEN OTHERS THEN
2446: -- Standard Unexpected Error Logging
2447: INL_LOGGING_PVT.Log_UnexpecError (
2448: p_module_name => g_module_name,
2449: p_procedure_name => l_proc_name);
2450: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2451: IF FND_MSG_PUB.Check_Msg_Level(

Line 2519: INL_LOGGING_PVT.Log_BeginProc (

2515:
2516: BEGIN
2517:
2518: -- Standard Beginning of Procedure/Function Logging
2519: INL_LOGGING_PVT.Log_BeginProc (
2520: p_module_name => g_module_name,
2521: p_procedure_name => l_api_name);
2522:
2523: -- Standard Start of API savepoint

Line 2573: INL_LOGGING_PVT.Log_Statement (

2569: -- Initialize API return status to success
2570: x_return_status := L_FND_RET_STS_SUCCESS;
2571:
2572: l_debug_info := 'Getting all Shipment Line Groups from a given Shipment Header ID';
2573: INL_LOGGING_PVT.Log_Statement (
2574: p_module_name => g_module_name,
2575: p_procedure_name => l_api_name,
2576: p_debug_info => l_debug_info);
2577:

Line 2581: INL_LOGGING_PVT.Log_Statement (

2577:
2578: -- Error if exist any estimated charge associated to different Shipment
2579: -- this situation is not covered yet
2580: l_debug_info := 'Verifying if there is charge with dual association.';
2581: INL_LOGGING_PVT.Log_Statement (
2582: p_module_name => g_module_name,
2583: p_procedure_name => l_api_name,
2584: p_debug_info => l_debug_info);
2585:

Line 2599: INL_LOGGING_PVT.Log_Variable (

2595: WHERE ia2.from_parent_table_name = 'INL_CHARGE_LINES'
2596: AND ia2.from_parent_table_id = ias.from_parent_table_id
2597: AND ia2.ship_header_id <> p_ship_header_id);
2598: IF NVL(l_count_dual_assoc,0) > 0 THEN
2599: INL_LOGGING_PVT.Log_Variable (
2600: p_module_name => g_module_name,
2601: p_procedure_name => l_api_name,
2602: p_var_name => 'l_count_dual_assoc',
2603: p_var_value => l_count_dual_assoc);

Line 2606: INL_LOGGING_PVT.Log_Statement (

2602: p_var_name => 'l_count_dual_assoc',
2603: p_var_value => l_count_dual_assoc);
2604:
2605: l_debug_info := 'No data found in Shipment Line Groups / Shipment Line. Raising expected error.';
2606: INL_LOGGING_PVT.Log_Statement (
2607: p_module_name => g_module_name,
2608: p_procedure_name => l_api_name,
2609: p_debug_info => l_debug_info);
2610:

Line 2618: INL_LOGGING_PVT.Log_Statement (

2614: END IF;
2615:
2616: --as recomended in TDD: Delete all CHARGES and ASSOCIATIONS
2617: l_debug_info := 'Deleting CHARGES and ASSOCIATIONS.';
2618: INL_LOGGING_PVT.Log_Statement (
2619: p_module_name => g_module_name,
2620: p_procedure_name => l_api_name,
2621: p_debug_info => l_debug_info);
2622: /* --Bug#9660056

Line 2643: INL_LOGGING_PVT.Log_Statement (

2639: AND ias.from_parent_table_id = icl.charge_line_id );
2640: --Bug#9660056
2641:
2642: l_debug_info := 'Deleted '|| SQL%ROWCOUNT||' CHARGE LINES.';
2643: INL_LOGGING_PVT.Log_Statement (
2644: p_module_name => g_module_name,
2645: p_procedure_name => l_api_name,
2646: p_debug_info => l_debug_info);
2647:

Line 2654: INL_LOGGING_PVT.Log_Statement (

2650: WHERE ias.from_parent_table_name = 'INL_CHARGE_LINES'
2651: AND ias.ship_header_id = p_ship_header_id;
2652:
2653: l_debug_info := 'Deleted '|| SQL%ROWCOUNT||' ASSOCIATION LINES.';
2654: INL_LOGGING_PVT.Log_Statement (
2655: p_module_name => g_module_name,
2656: p_procedure_name => l_api_name,
2657: p_debug_info => l_debug_info);
2658:

Line 2671: INL_LOGGING_PVT.Log_Variable (

2667: FROM inl_ship_line_groups lg
2668: WHERE lg.ship_header_id = p_ship_header_id
2669: ORDER BY ship_line_group_id; -- line in the same order
2670:
2671: INL_LOGGING_PVT.Log_Variable (
2672: p_module_name => g_module_name,
2673: p_procedure_name => l_api_name,
2674: p_var_name => 'l_ship_ln_group_tbl.COUNT',
2675: p_var_value => l_ship_ln_group_tbl.COUNT);

Line 2683: INL_LOGGING_PVT.Log_Variable (

2679: FROM inl_adj_ship_lines_v sl
2680: WHERE sl.ship_header_id = p_ship_header_id
2681: ORDER BY ship_line_group_id, ship_line_num;
2682:
2683: INL_LOGGING_PVT.Log_Variable (
2684: p_module_name => g_module_name,
2685: p_procedure_name => l_api_name,
2686: p_var_name => 'l_ship_ln_tbl.COUNT',
2687: p_var_value => l_ship_ln_tbl.COUNT);

Line 2693: INL_LOGGING_PVT.Log_Statement (

2689:
2690: IF NVL(l_ship_ln_group_tbl.COUNT, 0) = 0 OR
2691: NVL(l_ship_ln_tbl.COUNT, 0) = 0 THEN
2692: l_debug_info := 'No data found in Shipment Lines or Shipment Line Groups. Raising expected error.';
2693: INL_LOGGING_PVT.Log_Statement (
2694: p_module_name => g_module_name,
2695: p_procedure_name => l_api_name,
2696: p_debug_info => l_debug_info);
2697: FND_MESSAGE.SET_NAME('INL','INL_ERR_CHAR_LN_GEN');

Line 2709: INL_LOGGING_PVT.Log_Variable (

2705: x_charge_ln_tbl => l_charge_ln_tbl,
2706: x_override_default_processing => l_override_default_processing,
2707: x_return_status => l_return_status);
2708:
2709: INL_LOGGING_PVT.Log_Variable (
2710: p_module_name => g_module_name,
2711: p_procedure_name => l_api_name,
2712: p_var_name => 'l_charge_ln_tbl.COUNT',
2713: p_var_value => l_charge_ln_tbl.COUNT);

Line 2726: INL_LOGGING_PVT.Log_Statement (

2722: -- Check whether Charges Hook override
2723: -- the default Generate Charges processing.
2724: IF NOT (l_override_default_processing) THEN
2725: l_debug_info := 'l_override_default_processing is false';
2726: INL_LOGGING_PVT.Log_Statement (
2727: p_module_name => g_module_name,
2728: p_procedure_name => l_api_name,
2729: p_debug_info => l_debug_info);
2730:

Line 2732: INL_LOGGING_PVT.Log_Statement (

2728: p_procedure_name => l_api_name,
2729: p_debug_info => l_debug_info);
2730:
2731: l_debug_info := 'Check if Shipment is simulated';
2732: INL_LOGGING_PVT.Log_Statement (
2733: p_module_name => g_module_name,
2734: p_procedure_name => l_api_name,
2735: p_debug_info => l_debug_info);
2736:

Line 2737: INL_LOGGING_PVT.Log_Variable (

2733: p_module_name => g_module_name,
2734: p_procedure_name => l_api_name,
2735: p_debug_info => l_debug_info);
2736:
2737: INL_LOGGING_PVT.Log_Variable (
2738: p_module_name => g_module_name,
2739: p_procedure_name => l_api_name,
2740: p_var_name => 'l_ship_header_rec.simulation_id',
2741: p_var_value => l_ship_header_rec.simulation_id);

Line 2746: INL_LOGGING_PVT.Log_Statement (

2742:
2743: IF l_ship_header_rec.simulation_id IS NULL THEN -- Bug# 9279355
2744: -- Is not a simulated shipment
2745: l_debug_info := 'Shipment is no simulated, then checking its simulations.';
2746: INL_LOGGING_PVT.Log_Statement (
2747: p_module_name => g_module_name,
2748: p_procedure_name => l_api_name,
2749: p_debug_info => l_debug_info);
2750:

Line 2767: INL_LOGGING_PVT.Log_Variable (

2763: AND sl2.ship_line_source_id = sl1.ship_line_source_id
2764: AND sl2.ship_header_id <> sl1.ship_header_id
2765: AND sl1.ship_header_id = p_ship_header_id;
2766:
2767: INL_LOGGING_PVT.Log_Variable (
2768: p_module_name => g_module_name,
2769: p_procedure_name => l_api_name,
2770: p_var_name => 'l_firm_simulation',
2771: p_var_value => l_firm_simulation);

Line 2775: INL_LOGGING_PVT.Log_Statement (

2771: p_var_value => l_firm_simulation);
2772:
2773: IF NVL(l_firm_simulation,0) > 0 THEN
2774: l_debug_info := 'Exists Firmed Simulation for the Shipment. Get charges from Simulated Shipment';
2775: INL_LOGGING_PVT.Log_Statement (
2776: p_module_name => g_module_name,
2777: p_procedure_name => l_api_name,
2778: p_debug_info => l_debug_info);
2779:

Line 2792: INL_LOGGING_PVT.Log_Statement (

2788: RAISE L_FND_EXC_UNEXPECTED_ERROR;
2789: END IF;
2790: ELSE
2791: l_debug_info := 'There is NO Firmed Simulation for the Shipment. Get charges from QP';
2792: INL_LOGGING_PVT.Log_Statement (
2793: p_module_name => g_module_name,
2794: p_procedure_name => l_api_name,
2795: p_debug_info => l_debug_info);
2796:

Line 2798: INL_LOGGING_PVT.Log_Statement (

2794: p_procedure_name => l_api_name,
2795: p_debug_info => l_debug_info);
2796:
2797: l_debug_info := 'Call Prepare_AndGetChargesFromQP(...)';
2798: INL_LOGGING_PVT.Log_Statement (
2799: p_module_name => g_module_name,
2800: p_procedure_name => l_api_name,
2801: p_debug_info => l_debug_info);
2802:

Line 2820: INL_LOGGING_PVT.Log_Statement (

2816: END IF;
2817: END IF;
2818: ELSE
2819: l_debug_info := 'Simulated Shipment. Call Prepare_AndGetChargesFromQP(...)';
2820: INL_LOGGING_PVT.Log_Statement (
2821: p_module_name => g_module_name,
2822: p_procedure_name => l_api_name,
2823: p_debug_info => l_debug_info);
2824:

Line 2843: INL_LOGGING_PVT.Log_Statement (

2839: END IF;
2840: END IF;
2841:
2842: l_debug_info := 'Check whether Charge Lines were generated and populated into l_charge_ln_tbl';
2843: INL_LOGGING_PVT.Log_Statement (
2844: p_module_name => g_module_name,
2845: p_procedure_name => l_api_name,
2846: p_debug_info => l_debug_info);
2847:

Line 2853: INL_LOGGING_PVT.Log_Statement (

2849: -- Check if Charges got generated by QP
2850: IF l_charge_ln_tbl.COUNT < 1 AND NOT(l_override_default_processing) AND
2851: NVL(l_firm_simulation,0) = 0 THEN
2852: l_debug_info := 'No Charges have been generated by Advanced Pricing';
2853: INL_LOGGING_PVT.Log_Statement (
2854: p_module_name => g_module_name,
2855: p_procedure_name => l_api_name,
2856: p_debug_info => l_debug_info);
2857: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_NO_CH_LN_QP_CALL') ;

Line 2864: INL_LOGGING_PVT.Log_Statement (

2860: ELSIF l_charge_ln_tbl.COUNT < 1 AND NOT(l_override_default_processing) AND
2861: NVL(l_firm_simulation,0) > 0 THEN
2862: -- Charges have not been copied from FIRMED simulated shipment
2863: l_debug_info := 'Charges have not been copied from FIRMED simulated shipment';
2864: INL_LOGGING_PVT.Log_Statement (
2865: p_module_name => g_module_name,
2866: p_procedure_name => l_api_name,
2867: p_debug_info => l_debug_info);
2868: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_NO_CH_LN_FIRMED_SHIP') ;

Line 2873: INL_LOGGING_PVT.Log_Statement (

2869: FND_MSG_PUB.ADD;
2870: RAISE L_FND_EXC_ERROR;
2871: ELSIF l_charge_ln_tbl.COUNT < 1 AND l_override_default_processing THEN
2872: l_debug_info := 'No Charges have been generated by the Custom Hook';
2873: INL_LOGGING_PVT.Log_Statement (
2874: p_module_name => g_module_name,
2875: p_procedure_name => l_api_name,
2876: p_debug_info => l_debug_info);
2877: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_NO_CH_LN_HOOK_CALL') ;

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

2882: -- Iterate through all generated Charges to insert
2883: -- into INL Charge Lines and INL Associations table
2884: FOR j IN 1 .. l_charge_ln_tbl.COUNT LOOP
2885: l_debug_info := 'Call Insert_ChargeLines(...)';
2886: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2887: p_procedure_name => l_api_name,
2888: p_debug_info => l_debug_info);
2889:
2890: INL_LOGGING_PVT.Log_Variable (

Line 2890: INL_LOGGING_PVT.Log_Variable (

2886: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
2887: p_procedure_name => l_api_name,
2888: p_debug_info => l_debug_info);
2889:
2890: INL_LOGGING_PVT.Log_Variable (
2891: p_module_name => g_module_name,
2892: p_procedure_name => l_api_name,
2893: p_var_name => 'l_charge_ln_tbl(j).charge_amt',
2894: p_var_value => l_charge_ln_tbl(j).charge_amt);

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

2950: p_count => x_msg_count,
2951: p_data => x_msg_data);
2952:
2953: -- Standard End of Procedure/Function Logging
2954: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
2955: p_procedure_name => l_api_name);
2956:
2957: EXCEPTION
2958: WHEN L_FND_EXC_ERROR THEN

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

2956:
2957: EXCEPTION
2958: WHEN L_FND_EXC_ERROR THEN
2959: -- Standard Expected Error Logging
2960: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
2961: p_procedure_name => l_api_name);
2962: ROLLBACK TO Generate_Charges_PVT;
2963: x_return_status := L_FND_RET_STS_ERROR;
2964: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

2965: p_count => x_msg_count,
2966: p_data => x_msg_data);
2967: WHEN L_FND_EXC_UNEXPECTED_ERROR THEN
2968: -- Standard Unexpected Error Logging
2969: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2970: p_procedure_name => l_api_name);
2971: ROLLBACK TO Generate_Charges_PVT;
2972: x_return_status := L_FND_RET_STS_UNEXP_ERROR;
2973: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

2974: p_count => x_msg_count,
2975: p_data => x_msg_data);
2976: WHEN OTHERS THEN
2977: -- Standard Unexpected Error Logging
2978: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2979: p_procedure_name => l_api_name);
2980: ROLLBACK TO Generate_Charges_PVT;
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)