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

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

46:
47: BEGIN
48:
49: -- Standard Beginning of Procedure/Function Logging
50: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
51: p_procedure_name => l_api_name);
52:
53: -- Standard Start of API savepoint
54: SAVEPOINT Insert_LCMInterface_GRP;

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

73: BEGIN
74: l_current_shipment_header_id := -9999;
75: FOR i IN 1..p_lci_table.COUNT LOOP
76:
77: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
78: p_procedure_name => l_api_name,
79: p_var_name => 'p_lci_table(i).organization_id',
80: p_var_value => p_lci_table(i).organization_id);
81:

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

84: INTO l_user_defined_ship_num_code
85: FROM inl_parameters
86: WHERE organization_id = p_lci_table(i).organization_id;
87:
88: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
89: p_procedure_name => l_api_name,
90: p_var_name => 'l_user_defined_ship_num_code',
91: p_var_value => l_user_defined_ship_num_code);
92:

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

105: SELECT INL_INTERFACE_GROUPS_S.nextval
106: INTO l_group_id
107: FROM dual;
108:
109: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
110: p_procedure_name => l_api_name,
111: p_var_name => 'l_ship_header_int_id',
112: p_var_value => l_ship_header_int_id);
113:

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

184: SELECT INL_SHIP_LINES_INT_S.nextval
185: INTO l_ship_line_int_id
186: FROM dual;
187:
188: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
189: p_procedure_name => l_api_name,
190: p_var_name => 'l_ship_line_int_id',
191: p_var_value => l_ship_line_int_id);
192:

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

361: p_count => x_msg_count,
362: p_data => x_msg_data);
363:
364: -- Standard End of Procedure/Function Logging
365: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
366: p_procedure_name => l_api_name);
367:
368: EXCEPTION
369: WHEN FND_API.G_EXC_ERROR THEN

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

367:
368: EXCEPTION
369: WHEN FND_API.G_EXC_ERROR THEN
370: -- Standard Expected Error Logging
371: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
372: p_procedure_name => l_api_name);
373: ROLLBACK TO Insert_LCMInterface_GRP;
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

376: p_count => x_msg_count,
377: p_data => x_msg_data);
378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
379: -- Standard Unexpected Error Logging
380: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
381: p_procedure_name => l_api_name);
382: ROLLBACK TO Insert_LCMInterface_GRP;
383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
384: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

385: p_count => x_msg_count,
386: p_data => x_msg_data);
387: WHEN OTHERS THEN
388: -- Standard Unexpected Error Logging
389: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
390: p_procedure_name => l_api_name);
391: ROLLBACK TO Insert_LCMInterface_GRP;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
393: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 456: INL_LOGGING_PVT.Log_BeginProc (

452:
453: BEGIN
454:
455: -- Standard Beginning of Procedure/Function Logging
456: INL_LOGGING_PVT.Log_BeginProc (
457: p_module_name => g_module_name,
458: p_procedure_name => l_proc_name
459: );
460:

Line 461: INL_LOGGING_PVT.Log_Variable (

457: p_module_name => g_module_name,
458: p_procedure_name => l_proc_name
459: );
460:
461: INL_LOGGING_PVT.Log_Variable (
462: p_module_name => g_module_name,
463: p_procedure_name => l_proc_name,
464: p_var_name => 'p_int_rec.COUNT',
465: p_var_value => p_int_rec.COUNT

Line 481: INL_LOGGING_PVT.Log_Statement (

477: IF (currentHeaderId <> -9999)
478: THEN -- It is not the FIRST record
479:
480: -- Start processing of new shipment_header_id
481: INL_LOGGING_PVT.Log_Statement (
482: p_module_name => g_module_name,
483: p_procedure_name => l_proc_name,
484: p_debug_info => 'Update RTIs to LC_INTERFACED'
485: );

Line 503: INL_LOGGING_PVT.Log_Variable (

499:
500: SAVEPOINT headers;
501: END IF;
502:
503: INL_LOGGING_PVT.Log_Variable (
504: p_module_name => g_module_name,
505: p_procedure_name => l_proc_name,
506: p_var_name => 'p_int_rec(i).shipment_header_id',
507: p_var_value => p_int_rec(i).shipment_header_id

Line 510: INL_LOGGING_PVT.Log_Statement (

506: p_var_name => 'p_int_rec(i).shipment_header_id',
507: p_var_value => p_int_rec(i).shipment_header_id
508: );
509:
510: INL_LOGGING_PVT.Log_Statement (
511: p_module_name => g_module_name,
512: p_procedure_name => l_proc_name,
513: p_debug_info => 'Get RCV_SHIPMENT_HEADERS info.'
514: );

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

530: WHERE shipment_header_id = p_int_rec(i).shipment_header_id;
531:
532: -- BUG #8235596
533:
534: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
535: p_procedure_name => l_proc_name,
536: p_var_name => 'l_receipt_num',
537: p_var_value => l_receipt_num );
538:

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

539: IF(l_receipt_num IS NULL AND p_int_rec(i).header_interface_id IS NOT NULL) THEN
540:
541: -- If receipt num is NULL get it from rcv_headers_interface
542: l_debug_msg := 'Receipt num is NULL get it from rcv_headers_interface';
543: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
544: p_procedure_name => l_proc_name,
545: p_debug_info => l_debug_msg);
546:
547: SELECT receipt_num

Line 570: INL_LOGGING_PVT.Log_Variable (

566: FROM rcv_headers_interface
567: WHERE header_interface_id = p_int_rec(i).header_interface_id;
568: END IF;
569:
570: INL_LOGGING_PVT.Log_Variable (
571: p_module_name => g_module_name,
572: p_procedure_name => l_proc_name,
573: p_var_name => 'l_ship_to_org_id',
574: p_var_value => l_ship_to_org_id

Line 576: INL_LOGGING_PVT.Log_Variable (

572: p_procedure_name => l_proc_name,
573: p_var_name => 'l_ship_to_org_id',
574: p_var_value => l_ship_to_org_id
575: );
576: INL_LOGGING_PVT.Log_Variable (
577: p_module_name => g_module_name,
578: p_procedure_name => l_proc_name,
579: p_var_name => 'l_ship_to_location_id',
580: p_var_value => l_ship_to_location_id

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

578: p_procedure_name => l_proc_name,
579: p_var_name => 'l_ship_to_location_id',
580: p_var_value => l_ship_to_location_id
581: );
582: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
583: p_procedure_name => l_proc_name,
584: p_var_name => 'l_receipt_num',
585: p_var_value => l_receipt_num
586: );

Line 587: INL_LOGGING_PVT.Log_Variable (

583: p_procedure_name => l_proc_name,
584: p_var_name => 'l_receipt_num',
585: p_var_value => l_receipt_num
586: );
587: INL_LOGGING_PVT.Log_Variable (
588: p_module_name => g_module_name,
589: p_procedure_name => l_proc_name,
590: p_var_name => 'l_vendor_id',
591: p_var_value => l_vendor_id

Line 593: INL_LOGGING_PVT.Log_Variable (

589: p_procedure_name => l_proc_name,
590: p_var_name => 'l_vendor_id',
591: p_var_value => l_vendor_id
592: );
593: INL_LOGGING_PVT.Log_Variable (
594: p_module_name => g_module_name,
595: p_procedure_name => l_proc_name,
596: p_var_name => 'l_vendor_site_id',
597: p_var_value => l_vendor_site_id

Line 599: INL_LOGGING_PVT.Log_Statement (

595: p_procedure_name => l_proc_name,
596: p_var_name => 'l_vendor_site_id',
597: p_var_value => l_vendor_site_id
598: );
599: INL_LOGGING_PVT.Log_Statement (
600: p_module_name => g_module_name,
601: p_procedure_name => l_proc_name,
602: p_debug_info => 'Check Shipment Numbering mode. AUTOMATIC or MANUAL'
603: );

Line 604: INL_LOGGING_PVT.Log_Variable (

600: p_module_name => g_module_name,
601: p_procedure_name => l_proc_name,
602: p_debug_info => 'Check Shipment Numbering mode. AUTOMATIC or MANUAL'
603: );
604: INL_LOGGING_PVT.Log_Variable (
605: p_module_name => g_module_name,
606: p_procedure_name => l_proc_name,
607: p_var_name => 'l_user_defined_ship_num_code',
608: p_var_value => l_user_defined_ship_num_code

Line 610: INL_LOGGING_PVT.Log_Statement (

606: p_procedure_name => l_proc_name,
607: p_var_name => 'l_user_defined_ship_num_code',
608: p_var_value => l_user_defined_ship_num_code
609: );
610: INL_LOGGING_PVT.Log_Statement (
611: p_module_name => g_module_name,
612: p_procedure_name => l_proc_name,
613: p_debug_info => 'Get Operating Unit Id'
614: );

Line 620: INL_LOGGING_PVT.Log_Variable (

616: INTO l_org_id
617: FROM org_organization_definitions
618: WHERE organization_id = l_ship_to_org_id;
619:
620: INL_LOGGING_PVT.Log_Variable (
621: p_module_name => g_module_name,
622: p_procedure_name => l_proc_name,
623: p_var_name => 'l_org_id',
624: p_var_value => l_org_id

Line 629: INL_LOGGING_PVT.Log_Statement (

625: );
626:
627: l_ship_num := l_receipt_num;
628:
629: INL_LOGGING_PVT.Log_Statement (
630: p_module_name => g_module_name,
631: p_procedure_name => l_proc_name,
632: p_debug_info => 'Get Party Id from PO_VENDORS'
633: );

Line 639: INL_LOGGING_PVT.Log_Variable (

635: INTO l_party_id
636: FROM po_vendors
637: WHERE vendor_id = l_vendor_id;
638:
639: INL_LOGGING_PVT.Log_Variable (
640: p_module_name => g_module_name,
641: p_procedure_name => l_proc_name,
642: p_var_name => 'l_party_id',
643: p_var_value => l_party_id

Line 646: INL_LOGGING_PVT.Log_Statement (

642: p_var_name => 'l_party_id',
643: p_var_value => l_party_id
644: );
645:
646: INL_LOGGING_PVT.Log_Statement (
647: p_module_name => g_module_name,
648: p_procedure_name => l_proc_name,
649: p_debug_info => 'Get value from profile INL_SHIP_TYPE_ID_OI'
650: );

Line 654: INL_LOGGING_PVT.Log_Variable (

650: );
651:
652: l_ship_type_id := NVL(FND_PROFILE.VALUE('INL_SHIP_TYPE_ID_OI'),0);
653:
654: INL_LOGGING_PVT.Log_Variable (
655: p_module_name => g_module_name,
656: p_procedure_name => l_proc_name,
657: p_var_name => 'l_ship_type_id',
658: p_var_value => l_ship_type_id

Line 661: INL_LOGGING_PVT.Log_Statement (

657: p_var_name => 'l_ship_type_id',
658: p_var_value => l_ship_type_id
659: );
660:
661: INL_LOGGING_PVT.Log_Statement (
662: p_module_name => g_module_name,
663: p_procedure_name => l_proc_name,
664: p_debug_info => 'Get Legal Entity and Taxation Country'
665: );

Line 683: INL_LOGGING_PVT.Log_Variable (

679: AND hru.organization_id = ood.organization_id
680: AND gsb.set_of_books_id = ood.set_of_books_id
681: AND ood.organization_id = l_org_id;
682:
683: INL_LOGGING_PVT.Log_Variable (
684: p_module_name => g_module_name,
685: p_procedure_name => l_proc_name,
686: p_var_name => 'l_legal_entity_id',
687: p_var_value => l_legal_entity_id

Line 689: INL_LOGGING_PVT.Log_Variable (

685: p_procedure_name => l_proc_name,
686: p_var_name => 'l_legal_entity_id',
687: p_var_value => l_legal_entity_id
688: );
689: INL_LOGGING_PVT.Log_Variable (
690: p_module_name => g_module_name,
691: p_procedure_name => l_proc_name,
692: p_var_name => 'l_taxation_country',
693: p_var_value => l_taxation_country

Line 695: INL_LOGGING_PVT.Log_Variable (

691: p_procedure_name => l_proc_name,
692: p_var_name => 'l_taxation_country',
693: p_var_value => l_taxation_country
694: );
695: INL_LOGGING_PVT.Log_Variable (
696: p_module_name => g_module_name,
697: p_procedure_name => l_proc_name,
698: p_var_name => 'l_ship_header_int_id',
699: p_var_value => l_ship_header_int_id

Line 701: INL_LOGGING_PVT.Log_Variable (

697: p_procedure_name => l_proc_name,
698: p_var_name => 'l_ship_header_int_id',
699: p_var_value => l_ship_header_int_id
700: );
701: INL_LOGGING_PVT.Log_Variable (
702: p_module_name => g_module_name,
703: p_procedure_name => l_proc_name,
704: p_var_name => 'l_group_id',
705: p_var_value => l_group_id

Line 707: INL_LOGGING_PVT.Log_Statement (

703: p_procedure_name => l_proc_name,
704: p_var_name => 'l_group_id',
705: p_var_value => l_group_id
706: );
707: INL_LOGGING_PVT.Log_Statement (
708: p_module_name => g_module_name,
709: p_procedure_name => l_proc_name,
710: p_debug_info => 'Insert into inl_ship_headers_int table'
711: );

Line 742: INL_LOGGING_PVT.Log_Variable (

738: FROM po_vendor_sites_all pvs
739: WHERE pvs.vendor_site_id = l_vendor_site_id
740: AND pvs.org_id = p_int_rec(i).org_id;
741:
742: INL_LOGGING_PVT.Log_Variable (
743: p_module_name => g_module_name,
744: p_procedure_name => l_proc_name,
745: p_var_name => 'l_party_site_id',
746: p_var_value => l_party_site_id

Line 749: INL_LOGGING_PVT.Log_Statement (

745: p_var_name => 'l_party_site_id',
746: p_var_value => l_party_site_id
747: );
748:
749: INL_LOGGING_PVT.Log_Statement (
750: p_module_name => g_module_name,
751: p_procedure_name => l_proc_name,
752: p_debug_info => 'Get value to INL_SHIP_LINE_TYPE_ID'
753:

Line 763: INL_LOGGING_PVT.Log_Variable (

759: AND parent_table_id = l_ship_type_id
760: AND dflt_ship_line_type_flag='Y'
761: ;
762:
763: INL_LOGGING_PVT.Log_Variable (
764: p_module_name => g_module_name,
765: p_procedure_name => l_proc_name,
766: p_var_name => 'l_ship_line_type_id',
767: p_var_value => l_ship_line_type_id

Line 770: INL_LOGGING_PVT.Log_Statement (

766: p_var_name => 'l_ship_line_type_id',
767: p_var_value => l_ship_line_type_id
768: );
769:
770: INL_LOGGING_PVT.Log_Statement (
771: p_module_name => g_module_name,
772: p_procedure_name => l_proc_name,
773: p_debug_info => 'Get values from zx_lines_det_factors and po_line_locations_all'
774: );

Line 798: INL_LOGGING_PVT.Log_Variable (

794: AND zdf.trx_line_id = pll.line_location_id
795: AND zdf.entity_code = DECODE(pll.po_release_id,NULL,'PURCHASE_ORDER','RELEASE') --Bug 7680733
796: AND zdf.event_class_code = DECODE(pll.po_release_id,NULL,'PO_PA','RELEASE'); --Bug 7680733
797:
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_int_rec(i).po_line_location_id',
802: p_var_value => p_int_rec(i).po_line_location_id

Line 804: INL_LOGGING_PVT.Log_Variable (

800: p_procedure_name => l_proc_name,
801: p_var_name => 'p_int_rec(i).po_line_location_id',
802: p_var_value => p_int_rec(i).po_line_location_id
803: );
804: INL_LOGGING_PVT.Log_Variable (
805: p_module_name => g_module_name,
806: p_procedure_name => l_proc_name,
807: p_var_name => 'p_int_rec(i).currency_code',
808: p_var_value => p_int_rec(i).currency_code

Line 810: INL_LOGGING_PVT.Log_Variable (

806: p_procedure_name => l_proc_name,
807: p_var_name => 'p_int_rec(i).currency_code',
808: p_var_value => p_int_rec(i).currency_code
809: );
810: INL_LOGGING_PVT.Log_Variable (
811: p_module_name => g_module_name,
812: p_procedure_name => l_proc_name,
813: p_var_name => 'p_int_rec(i).item_id',
814: p_var_value => p_int_rec(i).item_id

Line 816: INL_LOGGING_PVT.Log_Variable (

812: p_procedure_name => l_proc_name,
813: p_var_name => 'p_int_rec(i).item_id',
814: p_var_value => p_int_rec(i).item_id
815: );
816: INL_LOGGING_PVT.Log_Variable (
817: p_module_name => g_module_name,
818: p_procedure_name => l_proc_name,
819: p_var_name => 'p_int_rec(i).quantity',
820: p_var_value => p_int_rec(i).quantity

Line 822: INL_LOGGING_PVT.Log_Variable (

818: p_procedure_name => l_proc_name,
819: p_var_name => 'p_int_rec(i).quantity',
820: p_var_value => p_int_rec(i).quantity
821: );
822: INL_LOGGING_PVT.Log_Variable (
823: p_module_name => g_module_name,
824: p_procedure_name => l_proc_name,
825: p_var_name => 'p_int_rec(i).po_unit_price',
826: p_var_value => p_int_rec(i).po_unit_price

Line 828: INL_LOGGING_PVT.Log_Variable (

824: p_procedure_name => l_proc_name,
825: p_var_name => 'p_int_rec(i).po_unit_price',
826: p_var_value => p_int_rec(i).po_unit_price
827: );
828: INL_LOGGING_PVT.Log_Variable (
829: p_module_name => g_module_name,
830: p_procedure_name => l_proc_name,
831: p_var_name => 'l_trx_business_category',
832: p_var_value => l_trx_business_category

Line 834: INL_LOGGING_PVT.Log_Variable (

830: p_procedure_name => l_proc_name,
831: p_var_name => 'l_trx_business_category',
832: p_var_value => l_trx_business_category
833: );
834: INL_LOGGING_PVT.Log_Variable (
835: p_module_name => g_module_name,
836: p_procedure_name => l_proc_name,
837: p_var_name => 'l_line_intended_use',
838: p_var_value => l_line_intended_use

Line 840: INL_LOGGING_PVT.Log_Variable (

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

Line 846: INL_LOGGING_PVT.Log_Variable (

842: p_procedure_name => l_proc_name,
843: p_var_name => 'l_product_fisc_classification',
844: p_var_value => l_product_fisc_classification
845: );
846: INL_LOGGING_PVT.Log_Variable (
847: p_module_name => g_module_name,
848: p_procedure_name => l_proc_name,
849: p_var_name => 'l_product_category',
850: p_var_value => l_product_category

Line 852: INL_LOGGING_PVT.Log_Variable (

848: p_procedure_name => l_proc_name,
849: p_var_name => 'l_product_category',
850: p_var_value => l_product_category
851: );
852: INL_LOGGING_PVT.Log_Variable (
853: p_module_name => g_module_name,
854: p_procedure_name => l_proc_name,
855: p_var_name => 'l_product_type',
856: p_var_value => l_product_type

Line 858: INL_LOGGING_PVT.Log_Variable (

854: p_procedure_name => l_proc_name,
855: p_var_name => 'l_product_type',
856: p_var_value => l_product_type
857: );
858: INL_LOGGING_PVT.Log_Variable (
859: p_module_name => g_module_name,
860: p_procedure_name => l_proc_name,
861: p_var_name => 'l_user_defined_fisc_class',
862: p_var_value => l_user_defined_fisc_class

Line 864: INL_LOGGING_PVT.Log_Variable (

860: p_procedure_name => l_proc_name,
861: p_var_name => 'l_user_defined_fisc_class',
862: p_var_value => l_user_defined_fisc_class
863: );
864: INL_LOGGING_PVT.Log_Variable (
865: p_module_name => g_module_name,
866: p_procedure_name => l_proc_name,
867: p_var_name => 'l_output_tax_classf_code',
868: p_var_value => l_output_tax_classf_code

Line 870: INL_LOGGING_PVT.Log_Statement (

866: p_procedure_name => l_proc_name,
867: p_var_name => 'l_output_tax_classf_code',
868: p_var_value => l_output_tax_classf_code
869: );
870: INL_LOGGING_PVT.Log_Statement (
871: p_module_name => g_module_name,
872: p_procedure_name => l_proc_name,
873: p_debug_info => 'Insert inl_ship_lines_int values in PL/SQL table.'
874: );

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

912: l_lci_table(i).line_interface_source_line_id := p_int_rec(i).interface_transaction_id;
913:
914: EXCEPTION
915: WHEN OTHERS THEN
916: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
917: p_procedure_name => l_proc_name
918: );
919: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
920: p_procedure_name => l_proc_name,

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

915: WHEN OTHERS THEN
916: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
917: p_procedure_name => l_proc_name
918: );
919: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
920: p_procedure_name => l_proc_name,
921: p_var_name => 'Error: ',
922: p_var_value => sqlcode ||' '||substr(SQLERRM, 1, 1000)
923: );

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

920: p_procedure_name => l_proc_name,
921: p_var_name => 'Error: ',
922: p_var_value => sqlcode ||' '||substr(SQLERRM, 1, 1000)
923: );
924: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
925: p_procedure_name => l_proc_name,
926: p_var_name => 'erroredHeaderId',
927: p_var_value => erroredHeaderId
928: );

Line 973: INL_LOGGING_PVT.Log_EndProc (

969: END LOOP;
970: END IF;
971:
972: -- Standard End of Procedure/Function Logging
973: INL_LOGGING_PVT.Log_EndProc (
974: p_module_name => g_module_name,
975: p_procedure_name => l_proc_name
976: );
977: EXCEPTION

Line 979: INL_LOGGING_PVT.Log_UnexpecError (

975: p_procedure_name => l_proc_name
976: );
977: EXCEPTION
978: WHEN OTHERS THEN
979: INL_LOGGING_PVT.Log_UnexpecError (
980: p_module_name => g_module_name,
981: p_procedure_name => l_proc_name
982: );
983: INL_LOGGING_PVT.Log_Statement (

Line 983: INL_LOGGING_PVT.Log_Statement (

979: INL_LOGGING_PVT.Log_UnexpecError (
980: p_module_name => g_module_name,
981: p_procedure_name => l_proc_name
982: );
983: INL_LOGGING_PVT.Log_Statement (
984: p_module_name => g_module_name,
985: p_procedure_name => l_proc_name,
986: p_debug_info => 'the error is: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000)
987: );

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

1036:
1037: BEGIN
1038:
1039: -- Standard Beginning of Procedure/Function Logging
1040: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1041: p_procedure_name => l_api_name) ;
1042:
1043: -- Standard Start of API savepoint
1044: SAVEPOINT Get_LandedCost_GRP;

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

1060: x_return_status := FND_API.G_RET_STS_SUCCESS;
1061:
1062: BEGIN
1063:
1064: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1065: p_procedure_name => l_api_name,
1066: p_debug_info => 'Before calling INL_LANDEDCOST_PUB.Get_LandedCost');
1067:
1068: INL_LANDEDCOST_PUB.Get_LandedCost (p_api_version => l_api_version,

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

1082: x_actual_charges => l_actual_charges,
1083: x_actual_taxes => l_actual_taxes,
1084: x_actual_unit_landed_cost => x_actual_unit_landed_cost);
1085:
1086: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1087: p_procedure_name => l_api_name,
1088: p_debug_info => 'After calling INL_LANDEDCOST_PUB.Get_LandedCost');
1089:
1090: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

1086: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1087: p_procedure_name => l_api_name,
1088: p_debug_info => 'After calling INL_LANDEDCOST_PUB.Get_LandedCost');
1089:
1090: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1091: p_procedure_name => l_api_name,
1092: p_var_name => 'INL_LANDEDCOST_PUB.Get_LandedCost Return Status: ',
1093: p_var_value => l_return_status);
1094:

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

1109: p_count => x_msg_count,
1110: p_data => x_msg_data) ;
1111:
1112: -- End of Procedure Logging
1113: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
1114: p_procedure_name => l_api_name) ;
1115:
1116: EXCEPTION
1117: WHEN FND_API.G_EXC_ERROR THEN

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

1115:
1116: EXCEPTION
1117: WHEN FND_API.G_EXC_ERROR THEN
1118: -- Standard Expected Error Logging
1119: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
1120: p_procedure_name => l_api_name) ;
1121: ROLLBACK TO Get_LandedCost_GRP;
1122: x_return_status := FND_API.G_RET_STS_ERROR;
1123: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

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

1124: p_count => x_msg_count,
1125: p_data => x_msg_data) ;
1126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1127: -- Standard Unexpected Error Logging
1128: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1129: p_procedure_name => l_api_name) ;
1130: ROLLBACK TO Get_LandedCost_GRP;
1131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1132: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

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

1133: p_count => x_msg_count,
1134: p_data => x_msg_data) ;
1135: WHEN OTHERS THEN
1136: -- Standard Unexpected Error Logging
1137: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1138: p_procedure_name => l_api_name) ;
1139: ROLLBACK TO Get_LandedCost_GRP;
1140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1141: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

1177:
1178: BEGIN
1179:
1180: -- Standard Beginning of Procedure/Function Logging
1181: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1182: p_procedure_name => l_api_name) ;
1183:
1184: FOR i IN 1..p_rti_rec.COUNT LOOP
1185: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

1181: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1182: p_procedure_name => l_api_name) ;
1183:
1184: FOR i IN 1..p_rti_rec.COUNT LOOP
1185: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1186: p_procedure_name => l_api_name,
1187: p_var_name => 'p_rti_rec(i).line_id',
1188: p_var_value => p_rti_rec(i).line_id);
1189:

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

1186: p_procedure_name => l_api_name,
1187: p_var_name => 'p_rti_rec(i).line_id',
1188: p_var_value => p_rti_rec(i).line_id);
1189:
1190: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1191: p_procedure_name => l_api_name,
1192: p_debug_info => 'Before calling INL_LANDEDCOST_PUB.Get_LandedCost');
1193:
1194: Get_LandedCost (p_api_version => l_api_version,

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

1199: x_msg_count => l_msg_count,
1200: x_msg_data => l_msg_data,
1201: x_actual_unit_landed_cost => l_actual_unit_landed_cost);
1202:
1203: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1204: p_procedure_name => l_api_name,
1205: p_debug_info => 'After calling INL_LANDEDCOST_PUB.Get_LandedCost');
1206:
1207: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

1203: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1204: p_procedure_name => l_api_name,
1205: p_debug_info => 'After calling INL_LANDEDCOST_PUB.Get_LandedCost');
1206:
1207: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1208: p_procedure_name => l_api_name,
1209: p_var_name => 'l_actual_unit_landed_cost',
1210: p_var_value => l_actual_unit_landed_cost);
1211:

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

1209: p_var_name => 'l_actual_unit_landed_cost',
1210: p_var_value => l_actual_unit_landed_cost);
1211:
1212: IF (l_actual_unit_landed_cost IS NOT NULL) THEN
1213: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1214: p_procedure_name => l_api_name,
1215: p_debug_info => 'Updating RTIs with the new landed cost');
1216:
1217: UPDATE rcv_transactions_interface

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

1226: AND transaction_type NOT IN('SHIP', 'RECEIVE', 'ACCEPT', 'REJECT','TRANSFER','UNORDERED')
1227: AND lcm_shipment_line_id IS NOT NULL
1228: AND lcm_shipment_line_id = p_rti_rec(i).line_id;
1229:
1230: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1231: p_procedure_name => l_api_name,
1232: p_var_name => 'RTIs updated',
1233: p_var_value => sql%rowcount);
1234: ELSE

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

1231: p_procedure_name => l_api_name,
1232: p_var_name => 'RTIs updated',
1233: p_var_value => sql%rowcount);
1234: ELSE
1235: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1236: p_procedure_name => l_api_name,
1237: p_debug_info => 'Setting RTIs to ERROR. Landed Cost is null.');
1238:
1239: UPDATE rcv_transactions_interface rti

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

1252: END IF;
1253: END LOOP;
1254:
1255: -- End of Procedure Logging
1256: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
1257: p_procedure_name => l_api_name) ;
1258: EXCEPTION
1259: WHEN OTHERS THEN
1260: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

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

1256: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
1257: p_procedure_name => l_api_name) ;
1258: EXCEPTION
1259: WHEN OTHERS THEN
1260: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1261: p_procedure_name => l_api_name);
1262: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1263: p_procedure_name => l_api_name,
1264: p_debug_info => 'the error is: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000));

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

1258: EXCEPTION
1259: WHEN OTHERS THEN
1260: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1261: p_procedure_name => l_api_name);
1262: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1263: p_procedure_name => l_api_name,
1264: p_debug_info => 'the error is: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000));
1265: UPDATE rcv_transactions_interface
1266: SET processing_status_code = 'ERROR'

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

1272: AND source_document_code = 'PO'
1273: AND transaction_type NOT IN ('SHIP', 'RECEIVE', 'ACCEPT', 'REJECT','TRANSFER','UNORDERED')
1274: AND lcm_shipment_line_id IS NOT NULL;
1275:
1276: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1277: p_procedure_name => l_api_name,
1278: p_debug_info => sql%rowcount || ' RTIs updated to Error');
1279: END Get_LandedCost;
1280:

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

1308: -- Initialize return status to success
1309: x_return_status := FND_API.G_RET_STS_SUCCESS;
1310:
1311: -- Standard Beginning of Procedure/Function Logging
1312: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1313: p_procedure_name => l_proc_name);
1314:
1315: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1316: p_procedure_name => l_proc_name,

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

1311: -- Standard Beginning of Procedure/Function Logging
1312: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1313: p_procedure_name => l_proc_name);
1314:
1315: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1316: p_procedure_name => l_proc_name,
1317: p_var_name => 'p_ship_lines_table.COUNT',
1318: p_var_value => p_ship_lines_table.COUNT);
1319:

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

1323: l_rti_lc_info_table(i).lcm_shipment_line_id := p_ship_lines_table(i).ship_line_id;
1324: l_rti_lc_info_table(i).unit_landed_cost := p_ship_lines_table(i).unit_landed_cost;
1325: END LOOP;
1326:
1327: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1328: p_procedure_name => l_proc_name,
1329: p_debug_info => 'Before calling RCV_UPDATE_RTI_LC.Update_RTI: ' || to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS'));
1330:
1331: RCV_UPDATE_RTI_LC.Update_RTI(p_int_rec => l_rti_lc_info_table,

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

1330:
1331: RCV_UPDATE_RTI_LC.Update_RTI(p_int_rec => l_rti_lc_info_table,
1332: x_lcm_int => l_rcv_int_table);
1333:
1334: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1335: p_procedure_name => l_proc_name,
1336: p_debug_info => 'After calling RCV_UPDATE_RTI_LC.Update_RTI: ' || to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS'));
1337:
1338: -- Standard End of Procedure/Function Logging

Line 1339: INL_logging_pvt.Log_EndProc (p_module_name => g_module_name,

1335: p_procedure_name => l_proc_name,
1336: p_debug_info => 'After calling RCV_UPDATE_RTI_LC.Update_RTI: ' || to_char(SYSDATE,'DD-MON-YYYY HH:MI:SS'));
1337:
1338: -- Standard End of Procedure/Function Logging
1339: INL_logging_pvt.Log_EndProc (p_module_name => g_module_name,
1340: p_procedure_name => l_proc_name);
1341:
1342: EXCEPTION
1343: WHEN FND_API.G_EXC_ERROR THEN

Line 1345: INL_LOGGING_PVT.Log_ExpecError (

1341:
1342: EXCEPTION
1343: WHEN FND_API.G_EXC_ERROR THEN
1344: -- Standard Expected Error Logging
1345: INL_LOGGING_PVT.Log_ExpecError (
1346: p_module_name => g_module_name,
1347: p_procedure_name => l_proc_name);
1348: x_return_status := FND_API.G_RET_STS_ERROR;
1349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1351: INL_LOGGING_PVT.Log_UnexpecError (

1347: p_procedure_name => l_proc_name);
1348: x_return_status := FND_API.G_RET_STS_ERROR;
1349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1350: -- Standard Unexpected Error Logging
1351: INL_LOGGING_PVT.Log_UnexpecError (
1352: p_module_name => g_module_name,
1353: p_procedure_name => l_proc_name);
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1355: WHEN OTHERS THEN

Line 1357: INL_LOGGING_PVT.Log_UnexpecError (

1353: p_procedure_name => l_proc_name);
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1355: WHEN OTHERS THEN
1356: -- Standard Unexpected Error Logging
1357: INL_LOGGING_PVT.Log_UnexpecError (
1358: p_module_name => g_module_name,
1359: p_procedure_name => l_proc_name);
1360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1361: IF FND_MSG_PUB.Check_Msg_Level(p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

1401:
1402: BEGIN
1403:
1404: -- Standard Beginning of Procedure/Function Logging
1405: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1406: p_procedure_name => l_api_name) ;
1407:
1408: -- Standard Start of API savepoint
1409: SAVEPOINT Call_StampLC_GRP;

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

1430: IF c_ship_lines%ISOPEN THEN
1431: CLOSE c_ship_lines;
1432: END IF;
1433:
1434: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1435: p_procedure_name => l_api_version,
1436: p_debug_info => 'Before calling Call_UpdateRCV');
1437:
1438: Call_UpdateRCV (p_ship_lines_table => l_ship_lines_table,

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

1437:
1438: Call_UpdateRCV (p_ship_lines_table => l_ship_lines_table,
1439: x_return_status => l_return_status);
1440:
1441: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1442: p_procedure_name => l_api_name,
1443: p_debug_info => 'After calling Call_UpdateRCV');
1444:
1445: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

1441: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1442: p_procedure_name => l_api_name,
1443: p_debug_info => 'After calling Call_UpdateRCV');
1444:
1445: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1446: p_procedure_name => l_api_name,
1447: p_var_name => 'Call_UpdateRCV l_return_status: ',
1448: p_var_value => l_return_status);
1449:

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

1464: p_count => x_msg_count,
1465: p_data => x_msg_data);
1466:
1467: -- End of Procedure Logging
1468: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
1469: p_procedure_name => l_api_name);
1470: EXCEPTION
1471: WHEN FND_API.G_EXC_ERROR THEN
1472: -- Standard Expected Error Logging

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

1469: p_procedure_name => l_api_name);
1470: EXCEPTION
1471: WHEN FND_API.G_EXC_ERROR THEN
1472: -- Standard Expected Error Logging
1473: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
1474: p_procedure_name => l_api_name);
1475: ROLLBACK TO Call_StampLC_GRP;
1476: x_return_status := FND_API.G_RET_STS_ERROR;
1477: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

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

1478: p_count => x_msg_count,
1479: p_data => x_msg_data);
1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1481: -- Standard Unexpected Error Logging
1482: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1483: p_procedure_name => l_api_name);
1484: ROLLBACK TO Call_StampLC_GRP;
1485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1486: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

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

1487: p_count => x_msg_count,
1488: p_data => x_msg_data) ;
1489: WHEN OTHERS THEN
1490: -- Standard Unexpected Error Logging
1491: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1492: p_procedure_name => l_api_name) ;
1493: ROLLBACK TO Call_StampLC_GRP;
1494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1495: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

1528: -- Initialize return status to success
1529: x_return_status := FND_API.G_RET_STS_SUCCESS;
1530:
1531: -- Standard Beginning of Procedure/Function Logging
1532: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1533: p_procedure_name => l_proc_name);
1534:
1535: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1536: p_procedure_name => l_proc_name,

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

1531: -- Standard Beginning of Procedure/Function Logging
1532: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1533: p_procedure_name => l_proc_name);
1534:
1535: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1536: p_procedure_name => l_proc_name,
1537: p_var_name => 'p_ship_lines_table.COUNT',
1538: p_var_value => p_ship_lines_table.COUNT);
1539:

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

1538: p_var_value => p_ship_lines_table.COUNT);
1539:
1540: FOR i IN 1..p_ship_lines_table.COUNT LOOP
1541:
1542: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1543: p_procedure_name => l_proc_name,
1544: p_var_name => 'l_ship_lines_table.EXTEND',
1545: p_var_value => 'l_ship_lines_table.EXTEND');
1546: l_ship_lines_table.EXTEND;

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

1571: END LOOP;
1572:
1573: IF l_ship_lines_table.FIRST IS NOT NULL THEN
1574:
1575: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1576: p_procedure_name => l_proc_name,
1577: p_debug_info => 'Before call RCV_INSERT_FROM_INL.insert_rcv_tables');
1578:
1579: RCV_INSERT_FROM_INL.insert_rcv_tables(p_int_rec => l_ship_lines_table,

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

1578:
1579: RCV_INSERT_FROM_INL.insert_rcv_tables(p_int_rec => l_ship_lines_table,
1580: p_ship_header_id => p_ship_header_id);
1581:
1582: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1583: p_procedure_name => l_proc_name,
1584: p_debug_info => 'After call RCV_INSERT_FROM_INL.insert_rcv_tables');
1585: END IF;
1586:

Line 1588: INL_logging_pvt.Log_EndProc (p_module_name => g_module_name,

1584: p_debug_info => 'After call RCV_INSERT_FROM_INL.insert_rcv_tables');
1585: END IF;
1586:
1587: -- Standard End of Procedure/Function Logging
1588: INL_logging_pvt.Log_EndProc (p_module_name => g_module_name,
1589: p_procedure_name => l_proc_name);
1590:
1591: EXCEPTION
1592: WHEN FND_API.G_EXC_ERROR THEN

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

1590:
1591: EXCEPTION
1592: WHEN FND_API.G_EXC_ERROR THEN
1593: -- Standard Expected Error Logging
1594: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,
1595: p_procedure_name => l_proc_name);
1596: x_return_status := FND_API.G_RET_STS_ERROR;
1597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1598: -- Standard Unexpected Error Logging

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

1595: p_procedure_name => l_proc_name);
1596: x_return_status := FND_API.G_RET_STS_ERROR;
1597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1598: -- Standard Unexpected Error Logging
1599: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
1600: p_procedure_name => l_proc_name);
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: WHEN OTHERS THEN
1603: -- Standard Unexpected Error Logging

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

1600: p_procedure_name => l_proc_name);
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: WHEN OTHERS THEN
1603: -- Standard Unexpected Error Logging
1604: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
1605: p_procedure_name => l_proc_name);
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1607: IF FND_MSG_PUB.Check_Msg_Level(p_message_level =>FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1608: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,

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

1648:
1649: BEGIN
1650:
1651: -- Standard Beginning of Procedure/Function Logging
1652: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1653: p_procedure_name => l_api_name);
1654:
1655: -- Standard Start of API savepoint
1656: SAVEPOINT Export_ToRCV_GRP;

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

1670:
1671: -- Initialize API RETURN status to success
1672: x_return_status := FND_API.G_RET_STS_SUCCESS;
1673:
1674: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1675: p_procedure_name => l_api_name,
1676: p_var_name => 'p_ship_header_id',
1677: p_var_value => p_ship_header_id);
1678:

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

1679: OPEN c_ship_lines(p_ship_header_id, 'PO', NULL);
1680: FETCH c_ship_lines BULK COLLECT INTO l_ship_lines_table;
1681:
1682: IF l_ship_lines_table.FIRST IS NOT NULL THEN
1683: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1684: p_procedure_name => l_api_name,
1685: p_debug_info => 'Before call Call_InsertRCV');
1686:
1687: Call_InsertRCV(p_ship_header_id => p_ship_header_id,

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

1694: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1696: END IF;
1697:
1698: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1699: p_procedure_name => l_api_name,
1700: p_debug_info => 'After call Call_InsertRCV');
1701:
1702: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,

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

1698: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1699: p_procedure_name => l_api_name,
1700: p_debug_info => 'After call Call_InsertRCV');
1701:
1702: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1703: p_procedure_name => l_api_name,
1704: p_var_name => 'Call_InsertRCV l_return_status:',
1705: p_var_value => l_return_status);
1706: END IF;

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

1717: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
1718: p_count => x_msg_count,
1719: p_data => x_msg_data) ;
1720: -- End of Procedure Logging
1721: INL_LOGGING_PVT.Log_EndProc(p_module_name => g_module_name,
1722: p_procedure_name => l_api_name) ;
1723: EXCEPTION
1724: WHEN FND_API.G_EXC_ERROR THEN
1725: -- Standard Expected Error Logging

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

1722: p_procedure_name => l_api_name) ;
1723: EXCEPTION
1724: WHEN FND_API.G_EXC_ERROR THEN
1725: -- Standard Expected Error Logging
1726: INL_LOGGING_PVT.Log_ExpecError(p_module_name => g_module_name,
1727: p_procedure_name => l_api_name) ;
1728: ROLLBACK TO Export_ToRCV_GRP;
1729: x_return_status := FND_API.G_RET_STS_ERROR;
1730: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

1731: p_count => x_msg_count,
1732: p_data => x_msg_data) ;
1733: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1734: -- Standard Unexpected Error Logging
1735: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
1736: p_procedure_name => l_api_name) ;
1737: ROLLBACK TO Export_ToRCV_GRP;
1738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1739: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

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

1740: p_count => x_msg_count,
1741: p_data => x_msg_data) ;
1742: WHEN OTHERS THEN
1743: -- Standard Unexpected Error Logging
1744: INL_LOGGING_PVT.Log_UnexpecError(p_module_name => g_module_name,
1745: p_procedure_name => l_api_name) ;
1746: ROLLBACK TO Export_ToRCV_GRP;
1747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1748: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

1813:
1814: BEGIN
1815:
1816: -- Standard Beginning of Procedure/Function Logging
1817: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1818: p_procedure_name => l_api_name) ;
1819:
1820: -- Standard Start of API savepoint
1821: SAVEPOINT Export_ToCST_GRP;

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

1841: CLOSE c_ship_ln_adj;
1842:
1843: FOR i IN ship_ln_list.FIRST .. ship_ln_list.LAST
1844: LOOP
1845: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1846: p_procedure_name => l_api_name,
1847: p_var_name => 'ship_ln_list(i).ship_line_id',
1848: p_var_value => ship_ln_list(i).ship_line_id);
1849:

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

1847: p_var_name => 'ship_ln_list(i).ship_line_id',
1848: p_var_value => ship_ln_list(i).ship_line_id);
1849:
1850: l_debug_info := 'Get the Prior Unit Landed Cost';
1851: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1852: p_procedure_name => l_api_name,
1853: p_debug_info => l_debug_info);
1854:
1855: -- Get the New Unit Landed Cost

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

1869: AND islv.ship_header_id = p_ship_header_id
1870: AND islv.ship_line_group_id = ship_ln_list(i).ship_line_group_id --Bug 7678900
1871: AND islv.ship_line_num = ship_ln_list(i).ship_line_num;
1872:
1873: INL_LOGGING_PVT.Log_Variable (p_module_name => g_module_name,
1874: p_procedure_name => l_api_name,
1875: p_var_name => 'l_prior_landed_cost',
1876: p_var_value => l_prior_landed_cost);
1877:

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

1878: -- Just INSERT those line which IN some way have had their costs changed
1879: IF l_prior_landed_cost <> l_new_landed_cost THEN
1880: l_current_date := SYSDATE;
1881: l_debug_info := 'Insert INTO CST_LC_ADJ_INTERFACE TABLE';
1882: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1883: p_procedure_name => l_api_name,
1884: p_debug_info => l_debug_info);
1885: INSERT INTO cst_lc_adj_interface (transaction_id,
1886: rcv_transaction_id,

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

1931: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,
1932: p_count => x_msg_count,
1933: p_data => x_msg_data) ;
1934: -- End of Procedure Logging
1935: INL_LOGGING_PVT.Log_EndProc ( p_module_name => g_module_name,
1936: p_procedure_name => l_api_name) ;
1937: EXCEPTION
1938: WHEN FND_API.G_EXC_ERROR THEN
1939: -- Standard Expected Error Logging

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

1936: p_procedure_name => l_api_name) ;
1937: EXCEPTION
1938: WHEN FND_API.G_EXC_ERROR THEN
1939: -- Standard Expected Error Logging
1940: INL_LOGGING_PVT.Log_ExpecError ( p_module_name => g_module_name,
1941: p_procedure_name => l_api_name) ;
1942: ROLLBACK TO Export_ToCST_GRP;
1943: x_return_status := FND_API.G_RET_STS_ERROR;
1944: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

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

1945: p_count => x_msg_count,
1946: p_data => x_msg_data) ;
1947: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1948: -- Standard Unexpected Error Logging
1949: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1950: p_procedure_name => l_api_name) ;
1951: ROLLBACK TO Export_ToCST_GRP;
1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1953: FND_MSG_PUB.Count_And_Get ( p_encoded => FND_API.g_false,

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

1954: p_count => x_msg_count,
1955: p_data => x_msg_data) ;
1956: WHEN OTHERS THEN
1957: -- Standard Unexpected Error Logging
1958: INL_LOGGING_PVT.Log_UnexpecError ( p_module_name => g_module_name,
1959: p_procedure_name => l_api_name) ;
1960: ROLLBACK TO Export_ToCST_GRP;
1961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1962: IF FND_MSG_PUB.Check_Msg_Level (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2017: INL_LOGGING_PVT.Log_BeginProc (

2013: l_debug_info VARCHAR2(200);
2014: BEGIN
2015:
2016: -- Standard Beginning of Procedure/Function Logging
2017: INL_LOGGING_PVT.Log_BeginProc (
2018: p_module_name => g_module_name,
2019: p_procedure_name => l_api_name
2020: );
2021: -- Standard Start of API savepoint

Line 2046: INL_LOGGING_PVT.Log_Statement (

2042: -- Api Body
2043:
2044: -- Standard Statement Level Procedure/Function Logging
2045: l_debug_info := 'Get currency info for the ship_line_id: ' || p_ship_line_id;
2046: INL_LOGGING_PVT.Log_Statement (
2047: p_module_name => g_module_name,
2048: p_procedure_name => l_api_name,
2049: p_debug_info => l_debug_info
2050: );

Line 2079: INL_LOGGING_PVT.Log_EndProc (

2075: p_count => x_msg_count,
2076: p_data => x_msg_data);
2077:
2078: -- Standard End of Procedure/Function Logging
2079: INL_LOGGING_PVT.Log_EndProc (
2080: p_module_name => g_module_name,
2081: p_procedure_name => l_api_name);
2082: EXCEPTION
2083: WHEN FND_API.G_EXC_ERROR THEN

Line 2085: INL_LOGGING_PVT.Log_ExpecError (

2081: p_procedure_name => l_api_name);
2082: EXCEPTION
2083: WHEN FND_API.G_EXC_ERROR THEN
2084: -- Standard Expected Error Logging
2085: INL_LOGGING_PVT.Log_ExpecError (
2086: p_module_name => g_module_name,
2087: p_procedure_name => l_api_name
2088: );
2089: ROLLBACK TO Get_CurrencyInfo_GRP;

Line 2098: INL_LOGGING_PVT.Log_UnexpecError (

2094: p_data => x_msg_data
2095: );
2096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2097: -- Standard Unexpected Error Logging
2098: INL_LOGGING_PVT.Log_UnexpecError (
2099: p_module_name => g_module_name,
2100: p_procedure_name => l_api_name);
2101: ROLLBACK TO Get_CurrencyInfo_GRP;
2102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2109: INL_LOGGING_PVT.Log_UnexpecError (

2105: p_count => x_msg_count,
2106: p_data => x_msg_data);
2107: WHEN OTHERS THEN
2108: -- Standard Unexpected Error Logging
2109: INL_LOGGING_PVT.Log_UnexpecError (
2110: p_module_name => g_module_name,
2111: p_procedure_name => l_api_name);
2112: ROLLBACK TO Get_CurrencyInfo_GRP;
2113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;