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.INV_CONSIGNED_DIAGNOSTICS_PROC dependencies on INV_LOG_UTIL

Line 53: INV_LOG_UTIL.trace

49: BEGIN
50:
51: IF g_debug = 1
52: THEN
53: INV_LOG_UTIL.trace
54: ( 'Into return from get_uom_code ' || p_uom ,null,9);
55: END IF;
56: l_uom_code := NULL ;
57:

Line 80: INV_LOG_UTIL.trace

76: END IF;
77:
78: IF g_debug = 1
79: THEN
80: INV_LOG_UTIL.trace
81: ( 'about to return from get_uom_code ' || l_uom_code ,null,9);
82: END IF;
83:
84: RETURN( l_uom_code );

Line 100: INV_LOG_UTIL.trace

96: BEGIN
97:
98: IF g_debug = 1
99: THEN
100: INV_LOG_UTIL.trace
101: ( '>> Update_Consumption_Date',null,9);
102: END IF;
103:
104: UPDATE mtl_consigned_diag_errors mcde

Line 119: INV_LOG_UTIL.trace

115:
116:
117: IF g_debug = 1
118: THEN
119: INV_LOG_UTIL.trace
120: ( '>> Update_Consumption_Date',null,9);
121: END IF;
122:
123:

Line 130: INV_LOG_UTIL.trace

126:
127: WHEN OTHERS THEN
128: IF g_debug = 1
129: THEN
130: INV_LOG_UTIL.trace
131: ( 'SQLERRM: '|| SQLERRM,9 );
132:
133: INV_LOG_UTIL.trace
134: ( 'OTHERS exception ',

Line 133: INV_LOG_UTIL.trace

129: THEN
130: INV_LOG_UTIL.trace
131: ( 'SQLERRM: '|| SQLERRM,9 );
132:
133: INV_LOG_UTIL.trace
134: ( 'OTHERS exception ',
135: 'Update_Consumption_Date',9);
136: END IF;
137:

Line 153: INV_LOG_UTIL.trace

149: BEGIN
150:
151: IF g_debug = 1
152: THEN
153: INV_LOG_UTIL.trace
154: ( '>> Purge_diagnostics_passed_rec' ,9);
155: END IF;
156:
157: DELETE FROM

Line 165: INV_LOG_UTIL.trace

161:
162:
163: IF g_debug = 1
164: THEN
165: INV_LOG_UTIL.trace
166: ( '<<< Purge_diagnostics_passed_rec' ,9);
167: END IF;
168:
169:

Line 176: INV_LOG_UTIL.trace

172:
173: WHEN OTHERS THEN
174: IF g_debug = 1
175: THEN
176: INV_LOG_UTIL.trace
177: ( 'SQLERRM: '|| SQLERRM,9 );
178:
179: INV_LOG_UTIL.trace
180: ( 'OTHERS exception ',

Line 179: INV_LOG_UTIL.trace

175: THEN
176: INV_LOG_UTIL.trace
177: ( 'SQLERRM: '|| SQLERRM,9 );
178:
179: INV_LOG_UTIL.trace
180: ( 'OTHERS exception ',
181: 'Purge_diagnostics_passed_rec' ,9);
182: END IF;
183:

Line 199: INV_LOG_UTIL.trace

195:
196: BEGIN
197: IF g_debug = 1
198: THEN
199: INV_LOG_UTIL.trace
200: ( 'Start Move records ','Process_Validated_Record',9);
201: INV_LOG_UTIL.trace
202: ( 'p_record_type => '|| p_record_type,9);
203: END IF;

Line 201: INV_LOG_UTIL.trace

197: IF g_debug = 1
198: THEN
199: INV_LOG_UTIL.trace
200: ( 'Start Move records ','Process_Validated_Record',9);
201: INV_LOG_UTIL.trace
202: ( 'p_record_type => '|| p_record_type,9);
203: END IF;
204:
205: BEGIN

Line 283: INV_LOG_UTIL.trace

279: );
280:
281: IF g_debug = 1
282: THEN
283: INV_LOG_UTIL.trace
284: ( 'Phase 2',9);
285: END IF;
286:
287: UPDATE mtl_consigned_diag_errors mcde

Line 382: INV_LOG_UTIL.trace

378: and mcdet.record_type = 2;
379:
380: IF g_debug = 1
381: THEN
382: INV_LOG_UTIL.trace
383: ( 'Phase 2 ',9);
384: END IF;
385:
386:

Line 411: INV_LOG_UTIL.trace

407: WHEN NO_DATA_FOUND
408: THEN
409: IF g_debug = 1
410: THEN
411: INV_LOG_UTIL.trace
412: ( 'No data Found Exception ','Process_Validated_Record',9);
413: END IF;
414: END ;
415:

Line 418: INV_LOG_UTIL.trace

414: END ;
415:
416: IF g_debug = 1
417: THEN
418: INV_LOG_UTIL.trace
419: ( '<< OUT Moving records ','Process_Validated_Record',9);
420: END IF;
421:
422: EXCEPTION

Line 427: INV_LOG_UTIL.trace

423:
424: WHEN OTHERS THEN
425: IF g_debug = 1
426: THEN
427: INV_LOG_UTIL.trace
428: ( 'SQLERRM: '|| SQLERRM,9 );
429:
430: INV_LOG_UTIL.trace
431: ( 'OTHERS exception ',

Line 430: INV_LOG_UTIL.trace

426: THEN
427: INV_LOG_UTIL.trace
428: ( 'SQLERRM: '|| SQLERRM,9 );
429:
430: INV_LOG_UTIL.trace
431: ( 'OTHERS exception ',
432: 'Process_Validated_Record' ,9);
433: END IF;
434:

Line 588: INV_LOG_UTIL.trace

584: THEN
585: l_buyer_id := NULL;
586: IF g_debug = 1
587: THEN
588: INV_LOG_UTIL.trace
589: ( 'C_buyer NO result ',null,9);
590: END IF;
591: END IF ;
592:

Line 605: INV_LOG_UTIL.trace

601: END ;
602:
603: IF g_debug = 1
604: THEN
605: INV_LOG_UTIL.trace
606: ( 'l_buyer_id => '|| l_buyer_id ,9);
607: END IF;
608:
609:

Line 618: INV_LOG_UTIL.trace

614: WHEN OTHERS THEN
615: IF g_debug = 1
616: THEN
617:
618: INV_LOG_UTIL.trace
619: ( 'SQLERRM: '|| SQLERRM,9 );
620:
621: INV_LOG_UTIL.trace
622: ( 'OTHERS exception ',

Line 621: INV_LOG_UTIL.trace

617:
618: INV_LOG_UTIL.trace
619: ( 'SQLERRM: '|| SQLERRM,9 );
620:
621: INV_LOG_UTIL.trace
622: ( 'OTHERS exception ',
623: 'get_buyer',9);
624: END IF;
625:

Line 675: INV_LOG_UTIL.trace

671:
672: x_error_code := NULL;
673: IF g_debug = 1
674: THEN
675: INV_LOG_UTIL.trace
676: ( '>> IN validate_consumption_txn' ,
677: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
678:
679: INV_LOG_UTIL.trace

Line 679: INV_LOG_UTIL.trace

675: INV_LOG_UTIL.trace
676: ( '>> IN validate_consumption_txn' ,
677: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
678:
679: INV_LOG_UTIL.trace
680: ( 'p_organization_id => '|| p_organization_id ,
681: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
682:
683: INV_LOG_UTIL.trace

Line 683: INV_LOG_UTIL.trace

679: INV_LOG_UTIL.trace
680: ( 'p_organization_id => '|| p_organization_id ,
681: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
682:
683: INV_LOG_UTIL.trace
684: ( 'p_inventory_item_id => '|| p_inventory_item_id ,
685: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
686:
687: INV_LOG_UTIL.trace

Line 687: INV_LOG_UTIL.trace

683: INV_LOG_UTIL.trace
684: ( 'p_inventory_item_id => '|| p_inventory_item_id ,
685: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
686:
687: INV_LOG_UTIL.trace
688: ( 'p_owning_organization_id => '|| p_owning_organization_id ,
689: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
690:
691: INV_LOG_UTIL.trace

Line 691: INV_LOG_UTIL.trace

687: INV_LOG_UTIL.trace
688: ( 'p_owning_organization_id => '|| p_owning_organization_id ,
689: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
690:
691: INV_LOG_UTIL.trace
692: ( 'p_revision => '|| p_revision ,
693: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
694: INV_LOG_UTIL.trace
695: ( 'p_po_header_id => '|| p_po_header_id ,

Line 694: INV_LOG_UTIL.trace

690:
691: INV_LOG_UTIL.trace
692: ( 'p_revision => '|| p_revision ,
693: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
694: INV_LOG_UTIL.trace
695: ( 'p_po_header_id => '|| p_po_header_id ,
696: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
697: END IF;
698:

Line 727: INV_LOG_UTIL.trace

723: l_blanket_total_amount := NULL;
724:
725: IF g_debug = 1
726: THEN
727: INV_LOG_UTIL.trace
728: ( 'x_error_code => '|| x_error_code ,
729: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
730: INV_LOG_UTIL.trace
731: ( 'l_blanket_total_amount => '|| l_blanket_total_amount ,

Line 730: INV_LOG_UTIL.trace

726: THEN
727: INV_LOG_UTIL.trace
728: ( 'x_error_code => '|| x_error_code ,
729: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
730: INV_LOG_UTIL.trace
731: ( 'l_blanket_total_amount => '|| l_blanket_total_amount ,
732: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
733: INV_LOG_UTIL.trace
734: ( '<< OUT validate_consumption_txn' ,

Line 733: INV_LOG_UTIL.trace

729: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
730: INV_LOG_UTIL.trace
731: ( 'l_blanket_total_amount => '|| l_blanket_total_amount ,
732: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
733: INV_LOG_UTIL.trace
734: ( '<< OUT validate_consumption_txn' ,
735: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
736: END IF;
737:

Line 745: INV_LOG_UTIL.trace

741: WHEN OTHERS THEN
742: IF g_debug = 1
743: THEN
744:
745: INV_LOG_UTIL.trace
746: ( 'SQLERRM: '|| SQLERRM,9 );
747:
748: INV_LOG_UTIL.trace
749: ( 'OTHERS exception ',

Line 748: INV_LOG_UTIL.trace

744:
745: INV_LOG_UTIL.trace
746: ( 'SQLERRM: '|| SQLERRM,9 );
747:
748: INV_LOG_UTIL.trace
749: ( 'OTHERS exception ',
750: 'get_buyer',9);
751: END IF;
752:

Line 789: INV_LOG_UTIL.trace

785:
786: BEGIN
787: IF g_debug = 1
788: THEN
789: INV_LOG_UTIL.trace
790: ( '******************************************** ' ,
791: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
792: INV_LOG_UTIL.trace
793: ( '>>> IN Consumption_Advice_diagnostics' ,

Line 792: INV_LOG_UTIL.trace

788: THEN
789: INV_LOG_UTIL.trace
790: ( '******************************************** ' ,
791: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
792: INV_LOG_UTIL.trace
793: ( '>>> IN Consumption_Advice_diagnostics' ,
794: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
795: INV_LOG_UTIL.trace
796: ( 'p_error_record_id => '|| p_error_record_id ,

Line 795: INV_LOG_UTIL.trace

791: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
792: INV_LOG_UTIL.trace
793: ( '>>> IN Consumption_Advice_diagnostics' ,
794: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
795: INV_LOG_UTIL.trace
796: ( 'p_error_record_id => '|| p_error_record_id ,
797: 'Consumption_Advice_diagnostics ',9);
798: END IF;
799:

Line 806: INV_LOG_UTIL.trace

802: IF p_error_record_id IS NULL
803: THEN
804: IF g_debug = 1
805: THEN
806: INV_LOG_UTIL.trace
807: ( 'REGULAR - Before Insert into mtl_consigned_diag_temp' ,
808: 'Consumption_Advice_diagnostics',9);
809: END IF;
810:

Line 836: INV_LOG_UTIL.trace

832:
833: ELSE
834: IF g_debug = 1
835: THEN
836: INV_LOG_UTIL.trace
837: ( 'REVALIDATE - Before Insert into mtl_consigned_diag_temp' ,
838: 'Consumption_Advice_diagnostics',9);
839: END IF;
840:

Line 863: INV_LOG_UTIL.trace

859: END IF;
860:
861: IF g_debug = 1
862: THEN
863: INV_LOG_UTIL.trace
864: ( 'after Insert into mtl_consigned_diag_temp' ,
865: 'Consumption_Advice_diagnostics',9);
866: END IF;
867:

Line 873: INV_LOG_UTIL.trace

869: FOR l_cad_temp_rec IN C_cad_temp
870: LOOP
871: IF g_debug = 1
872: THEN
873: INV_LOG_UTIL.trace
874: ( 'ORGANIZATION_ID => '|| l_cad_temp_rec.ORGANIZATION_ID ,null
875: ,9);
876: INV_LOG_UTIL.trace
877: ( 'INVENTORY_ITEM_ID => '|| l_cad_temp_rec.INVENTORY_ITEM_ID

Line 876: INV_LOG_UTIL.trace

872: THEN
873: INV_LOG_UTIL.trace
874: ( 'ORGANIZATION_ID => '|| l_cad_temp_rec.ORGANIZATION_ID ,null
875: ,9);
876: INV_LOG_UTIL.trace
877: ( 'INVENTORY_ITEM_ID => '|| l_cad_temp_rec.INVENTORY_ITEM_ID
878: ,null
879: ,9);
880: INV_LOG_UTIL.trace

Line 880: INV_LOG_UTIL.trace

876: INV_LOG_UTIL.trace
877: ( 'INVENTORY_ITEM_ID => '|| l_cad_temp_rec.INVENTORY_ITEM_ID
878: ,null
879: ,9);
880: INV_LOG_UTIL.trace
881: ( 'OWNING_ORGANIZATION_ID => '|| l_cad_temp_rec.OWNING_ORGANIZATION_ID
882: ,null
883: ,9);
884:

Line 885: INV_LOG_UTIL.trace

881: ( 'OWNING_ORGANIZATION_ID => '|| l_cad_temp_rec.OWNING_ORGANIZATION_ID
882: ,null
883: ,9);
884:
885: INV_LOG_UTIL.trace
886: ( 'po_header_id => '|| l_cad_temp_rec.po_header_id
887: ,null
888: ,9);
889:

Line 890: INV_LOG_UTIL.trace

886: ( 'po_header_id => '|| l_cad_temp_rec.po_header_id
887: ,null
888: ,9);
889:
890: INV_LOG_UTIL.trace
891: ( 'Calling validate_consumption_txn ' ,
892: 'Consumption_Advice_diagnostics',9);
893: END IF;
894:

Line 913: INV_LOG_UTIL.trace

909: );
910:
911: IF (g_debug = 1)
912: THEN
913: INV_LOG_UTIL.trace
914: ( 'Out validate_consumption_txn ',
915: 'Consumption_Advice_diagnostics'
916: , 9
917: );

Line 919: INV_LOG_UTIL.trace

915: 'Consumption_Advice_diagnostics'
916: , 9
917: );
918:
919: INV_LOG_UTIL.trace
920: ( 'l_error_code => '|| l_error_code
921: ,'Consumption_Advice_diagnostics'
922: , 9);
923: END IF;

Line 965: INV_LOG_UTIL.trace

961: l_error_type := NULL ;
962:
963: IF (g_debug = 1)
964: THEN
965: INV_LOG_UTIL.trace
966: ( 'after UPDATE mtl_consigned_diag_temp '
967: ,'Consumption_Advice_diagnostics'
968: , 9
969: );

Line 978: INV_LOG_UTIL.trace

974: END LOOP;
975:
976: IF (g_debug = 1)
977: THEN
978: INV_LOG_UTIL.trace
979: ( 'after the temp table LOOP',
980: 'Consumption_Advice_diagnostics'
981: , 9
982: );

Line 1000: INV_LOG_UTIL.trace

996:
997:
998: IF g_debug = 1
999: THEN
1000: INV_LOG_UTIL.trace
1001: ( '******************************************** ' ,
1002: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
1003: INV_LOG_UTIL.trace
1004: ( '<<< OUT Consumption_Advice_diagnostics' ,

Line 1003: INV_LOG_UTIL.trace

999: THEN
1000: INV_LOG_UTIL.trace
1001: ( '******************************************** ' ,
1002: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
1003: INV_LOG_UTIL.trace
1004: ( '<<< OUT Consumption_Advice_diagnostics' ,
1005: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
1006: END IF;
1007:

Line 1014: INV_LOG_UTIL.trace

1010: WHEN OTHERS THEN
1011: IF g_debug = 1
1012: THEN
1013:
1014: INV_LOG_UTIL.trace
1015: ( 'SQLERRM: '|| SQLERRM,9 );
1016:
1017: INV_LOG_UTIL.trace
1018: ( 'Error in Consumption_Advice_diagnostics' ,

Line 1017: INV_LOG_UTIL.trace

1013:
1014: INV_LOG_UTIL.trace
1015: ( 'SQLERRM: '|| SQLERRM,9 );
1016:
1017: INV_LOG_UTIL.trace
1018: ( 'Error in Consumption_Advice_diagnostics' ,
1019: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
1020: END IF;
1021:

Line 1072: INV_LOG_UTIL.trace

1068:
1069: BEGIN
1070: IF g_debug = 1
1071: THEN
1072: INV_LOG_UTIL.trace
1073: ( '++++++++++++++++++++++++++++++++++++++++' ,
1074: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
1075: INV_LOG_UTIL.trace
1076: ( '>>> IN Ownership_transfer_diagnostics',

Line 1075: INV_LOG_UTIL.trace

1071: THEN
1072: INV_LOG_UTIL.trace
1073: ( '++++++++++++++++++++++++++++++++++++++++' ,
1074: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
1075: INV_LOG_UTIL.trace
1076: ( '>>> IN Ownership_transfer_diagnostics',
1077: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
1078: INV_LOG_UTIL.trace
1079: ( 'p_error_record_id => '|| p_error_record_id ,

Line 1078: INV_LOG_UTIL.trace

1074: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
1075: INV_LOG_UTIL.trace
1076: ( '>>> IN Ownership_transfer_diagnostics',
1077: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
1078: INV_LOG_UTIL.trace
1079: ( 'p_error_record_id => '|| p_error_record_id ,
1080: 'Ownership_transfer_diagnostics' ,9);
1081: END IF;
1082:

Line 1090: INV_LOG_UTIL.trace

1086: IF p_error_record_id is NULL
1087: THEN
1088: IF g_debug = 1
1089: THEN
1090: INV_LOG_UTIL.trace
1091: ( ' REgular - Before Insert into Temp ',
1092: 'Ownership_transfer_diagnostics' ,9);
1093: END IF;
1094:

Line 1113: INV_LOG_UTIL.trace

1109:
1110: ELSE
1111: IF g_debug = 1
1112: THEN
1113: INV_LOG_UTIL.trace
1114: ( ' REvalidate - Before Insert into Temp ',
1115: 'Ownership_transfer_diagnostics' ,9);
1116: END IF;
1117:

Line 1138: INV_LOG_UTIL.trace

1134: END IF;
1135:
1136: IF g_debug = 1
1137: THEN
1138: INV_LOG_UTIL.trace
1139: ( 'after Insert into MCDET TEMP table ',
1140: 'Ownership_transfer_diagnostics' ,9);
1141: END IF;
1142:

Line 1148: INV_LOG_UTIL.trace

1144: LOOP
1145: IF g_debug = 1
1146: THEN
1147:
1148: INV_LOG_UTIL.trace
1149: ( 'ORGANIZATION_ID => '|| l_moqd_temp_rec.ORGANIZATION_ID ,null
1150: ,9);
1151: INV_LOG_UTIL.trace
1152: ( 'INVENTORY_ITEM_ID => '|| l_moqd_temp_rec.INVENTORY_ITEM_ID

Line 1151: INV_LOG_UTIL.trace

1147:
1148: INV_LOG_UTIL.trace
1149: ( 'ORGANIZATION_ID => '|| l_moqd_temp_rec.ORGANIZATION_ID ,null
1150: ,9);
1151: INV_LOG_UTIL.trace
1152: ( 'INVENTORY_ITEM_ID => '|| l_moqd_temp_rec.INVENTORY_ITEM_ID
1153: ,null
1154: ,9);
1155: INV_LOG_UTIL.trace

Line 1155: INV_LOG_UTIL.trace

1151: INV_LOG_UTIL.trace
1152: ( 'INVENTORY_ITEM_ID => '|| l_moqd_temp_rec.INVENTORY_ITEM_ID
1153: ,null
1154: ,9);
1155: INV_LOG_UTIL.trace
1156: ( 'OWNING_ORGANIZATION_ID => '|| l_moqd_temp_rec.OWNING_ORGANIZATION_ID
1157: ,null
1158: ,9);
1159: INV_LOG_UTIL.trace

Line 1159: INV_LOG_UTIL.trace

1155: INV_LOG_UTIL.trace
1156: ( 'OWNING_ORGANIZATION_ID => '|| l_moqd_temp_rec.OWNING_ORGANIZATION_ID
1157: ,null
1158: ,9);
1159: INV_LOG_UTIL.trace
1160: ( 'Calling Process_Financial_Info ' ,
1161: 'Ownership_transfer_diagnostics' ,9);
1162: END IF;
1163:

Line 1218: INV_LOG_UTIL.trace

1214: l_purchasing_uom_code := get_uom_code( p_uom => l_purchasing_uom);
1215:
1216: IF (g_debug = 1)
1217: THEN
1218: INV_LOG_UTIL.trace
1219: ( 'Out of Process_Financial_Info - Diagnostics ',
1220: 'Ownership_transfer_diagnostics'
1221: , 9
1222: );

Line 1223: INV_LOG_UTIL.trace

1219: ( 'Out of Process_Financial_Info - Diagnostics ',
1220: 'Ownership_transfer_diagnostics'
1221: , 9
1222: );
1223: INV_LOG_UTIL.trace
1224: ( 'l_error_code =>' || l_error_code ,'INV_THIRD_PARTY_STOCK_PVT'
1225: , 9);
1226: INV_LOG_UTIL.trace
1227: ( 'po_header_id => '|| l_po_id ,null

Line 1226: INV_LOG_UTIL.trace

1222: );
1223: INV_LOG_UTIL.trace
1224: ( 'l_error_code =>' || l_error_code ,'INV_THIRD_PARTY_STOCK_PVT'
1225: , 9);
1226: INV_LOG_UTIL.trace
1227: ( 'po_header_id => '|| l_po_id ,null
1228: , 9);
1229: INV_LOG_UTIL.trace
1230: ( 'l_error_po_id => '|| l_error_po_id, null

Line 1229: INV_LOG_UTIL.trace

1225: , 9);
1226: INV_LOG_UTIL.trace
1227: ( 'po_header_id => '|| l_po_id ,null
1228: , 9);
1229: INV_LOG_UTIL.trace
1230: ( 'l_error_po_id => '|| l_error_po_id, null
1231: , 9);
1232: INV_LOG_UTIL.trace
1233: ( 'l_account_id => '|| l_account_id, null

Line 1232: INV_LOG_UTIL.trace

1228: , 9);
1229: INV_LOG_UTIL.trace
1230: ( 'l_error_po_id => '|| l_error_po_id, null
1231: , 9);
1232: INV_LOG_UTIL.trace
1233: ( 'l_account_id => '|| l_account_id, null
1234: , 9);
1235: INV_LOG_UTIL.trace
1236: ( 'l_return_status => '|| l_return_status ,'INV_THIRD_PARTY_STOCK_PVT'

Line 1235: INV_LOG_UTIL.trace

1231: , 9);
1232: INV_LOG_UTIL.trace
1233: ( 'l_account_id => '|| l_account_id, null
1234: , 9);
1235: INV_LOG_UTIL.trace
1236: ( 'l_return_status => '|| l_return_status ,'INV_THIRD_PARTY_STOCK_PVT'
1237: , 9);
1238: INV_LOG_UTIL.trace
1239: ( 'l_primary_uom =>' || l_primary_uom ,'INV_THIRD_PARTY_STOCK_PVT'

Line 1238: INV_LOG_UTIL.trace

1234: , 9);
1235: INV_LOG_UTIL.trace
1236: ( 'l_return_status => '|| l_return_status ,'INV_THIRD_PARTY_STOCK_PVT'
1237: , 9);
1238: INV_LOG_UTIL.trace
1239: ( 'l_primary_uom =>' || l_primary_uom ,'INV_THIRD_PARTY_STOCK_PVT'
1240: , 9);
1241:
1242: INV_LOG_UTIL.trace

Line 1242: INV_LOG_UTIL.trace

1238: INV_LOG_UTIL.trace
1239: ( 'l_primary_uom =>' || l_primary_uom ,'INV_THIRD_PARTY_STOCK_PVT'
1240: , 9);
1241:
1242: INV_LOG_UTIL.trace
1243: ( 'l_purchasing_uom =>' || l_purchasing_uom ,'INV_THIRD_PARTY_STOCK_PVT'
1244: , 9);
1245: INV_LOG_UTIL.trace
1246: ( 'l_primary_uom_code =>' || l_primary_uom_code ,

Line 1245: INV_LOG_UTIL.trace

1241:
1242: INV_LOG_UTIL.trace
1243: ( 'l_purchasing_uom =>' || l_purchasing_uom ,'INV_THIRD_PARTY_STOCK_PVT'
1244: , 9);
1245: INV_LOG_UTIL.trace
1246: ( 'l_primary_uom_code =>' || l_primary_uom_code ,
1247: 'INV_THIRD_PARTY_STOCK_PVT'
1248: , 9);
1249:

Line 1250: INV_LOG_UTIL.trace

1246: ( 'l_primary_uom_code =>' || l_primary_uom_code ,
1247: 'INV_THIRD_PARTY_STOCK_PVT'
1248: , 9);
1249:
1250: INV_LOG_UTIL.trace
1251: ( 'l_purchasing_uom_code =>' || l_purchasing_uom_code ,
1252: 'INV_THIRD_PARTY_STOCK_PVT'
1253: , 9);
1254: END IF;

Line 1317: INV_LOG_UTIL.trace

1313: l_purchasing_uom_code := NULL ;
1314:
1315: IF (g_debug = 1)
1316: THEN
1317: INV_LOG_UTIL.trace
1318: ( 'after UPDATE mtl_consigned_diag_temp '
1319: ,'Ownership_transfer_diagnostics'
1320: , 9
1321: );

Line 1328: INV_LOG_UTIL.trace

1324: END LOOP;
1325:
1326: IF (g_debug = 1)
1327: THEN
1328: INV_LOG_UTIL.trace
1329: ( 'after the temp table LOOP',
1330: 'Ownership_transfer_diagnostics'
1331: , 9
1332: );

Line 1361: INV_LOG_UTIL.trace

1357:
1358:
1359: IF g_debug = 1
1360: THEN
1361: INV_LOG_UTIL.trace
1362: ( '++++++++++++++++++++++++++++++++++++++++' ,
1363: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
1364: INV_LOG_UTIL.trace
1365: ( '<<< OUT Ownership_transfer_diagnostics',

Line 1364: INV_LOG_UTIL.trace

1360: THEN
1361: INV_LOG_UTIL.trace
1362: ( '++++++++++++++++++++++++++++++++++++++++' ,
1363: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
1364: INV_LOG_UTIL.trace
1365: ( '<<< OUT Ownership_transfer_diagnostics',
1366: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
1367: END IF;
1368:

Line 1377: INV_LOG_UTIL.trace

1373: WHEN OTHERS THEN
1374: IF g_debug = 1
1375: THEN
1376:
1377: INV_LOG_UTIL.trace
1378: ( 'SQLERRM: '|| SQLERRM,9 );
1379:
1380: INV_LOG_UTIL.trace
1381: ( 'Error in Ownership_transfer_diagnostics',

Line 1380: INV_LOG_UTIL.trace

1376:
1377: INV_LOG_UTIL.trace
1378: ( 'SQLERRM: '|| SQLERRM,9 );
1379:
1380: INV_LOG_UTIL.trace
1381: ( 'Error in Ownership_transfer_diagnostics',
1382: 'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
1383: END IF;
1384:

Line 1408: INV_LOG_UTIL.trace

1404: BEGIN
1405:
1406: IF g_debug = 1
1407: THEN
1408: INV_LOG_UTIL.trace
1409: ( '>> Revalidate_error_record' ,'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
1410: INV_LOG_UTIL.trace
1411: ( 'p_error_record_id => '|| p_error_record_id,null,9);
1412: END IF;

Line 1410: INV_LOG_UTIL.trace

1406: IF g_debug = 1
1407: THEN
1408: INV_LOG_UTIL.trace
1409: ( '>> Revalidate_error_record' ,'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
1410: INV_LOG_UTIL.trace
1411: ( 'p_error_record_id => '|| p_error_record_id,null,9);
1412: END IF;
1413:
1414: g_revalidate_error_code := NULL ;

Line 1438: INV_LOG_UTIL.trace

1434: l_request_id := NULL;
1435:
1436: IF g_debug = 1
1437: THEN
1438: INV_LOG_UTIL.trace
1439: ( '<< out Revalidate_error_record'
1440: ,'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
1441: END IF;
1442: END ;

Line 1450: INV_LOG_UTIL.trace

1446: g_request_id := l_request_id ;
1447:
1448: IF g_debug = 1
1449: THEN
1450: INV_LOG_UTIL.trace
1451: ( 'l_record_type => '|| l_record_type,null,9) ;
1452: INV_LOG_UTIL.trace
1453: ( 'l_request_id => '|| l_request_id,null,9);
1454: INV_LOG_UTIL.trace

Line 1452: INV_LOG_UTIL.trace

1448: IF g_debug = 1
1449: THEN
1450: INV_LOG_UTIL.trace
1451: ( 'l_record_type => '|| l_record_type,null,9) ;
1452: INV_LOG_UTIL.trace
1453: ( 'l_request_id => '|| l_request_id,null,9);
1454: INV_LOG_UTIL.trace
1455: ( 'g_request_id => '|| g_request_id,null,9);
1456: END IF;

Line 1454: INV_LOG_UTIL.trace

1450: INV_LOG_UTIL.trace
1451: ( 'l_record_type => '|| l_record_type,null,9) ;
1452: INV_LOG_UTIL.trace
1453: ( 'l_request_id => '|| l_request_id,null,9);
1454: INV_LOG_UTIL.trace
1455: ( 'g_request_id => '|| g_request_id,null,9);
1456: END IF;
1457:
1458:

Line 1472: INV_LOG_UTIL.trace

1468: END IF;
1469:
1470: IF g_debug = 1
1471: THEN
1472: INV_LOG_UTIL.trace
1473: ( 'g_revalidate_error_code => '|| g_revalidate_error_code,null,9);
1474: END IF;
1475:
1476: BEGIN

Line 1498: INV_LOG_UTIL.trace

1494: COMMIT;
1495:
1496: IF g_debug = 1
1497: THEN
1498: INV_LOG_UTIL.trace
1499: ( 'Out of validation ',null,9);
1500: END IF;
1501: END IF;
1502:

Line 1507: INV_LOG_UTIL.trace

1503: g_revalidate_error_code := NULL;
1504:
1505: IF g_debug = 1
1506: THEN
1507: INV_LOG_UTIL.trace
1508: ( 'x_result_out => '|| x_result_out ,
1509: 'Revalidate_error_record',9);
1510: INV_LOG_UTIL.trace
1511: ( '<< out Revalidate_error_record' ,'INV_CONSIGNED_DIAGNOSTICS_PROC',9);

Line 1510: INV_LOG_UTIL.trace

1506: THEN
1507: INV_LOG_UTIL.trace
1508: ( 'x_result_out => '|| x_result_out ,
1509: 'Revalidate_error_record',9);
1510: INV_LOG_UTIL.trace
1511: ( '<< out Revalidate_error_record' ,'INV_CONSIGNED_DIAGNOSTICS_PROC',9);
1512: END IF;
1513:
1514:

Line 1519: INV_LOG_UTIL.trace

1515:
1516: EXCEPTION
1517:
1518: WHEN OTHERS THEN
1519: INV_LOG_UTIL.trace
1520: ( 'SQLERRM: '|| SQLERRM,9 );
1521:
1522: IF g_debug = 1
1523: THEN

Line 1524: INV_LOG_UTIL.trace

1520: ( 'SQLERRM: '|| SQLERRM,9 );
1521:
1522: IF g_debug = 1
1523: THEN
1524: INV_LOG_UTIL.trace
1525: ( 'OTHERS exception ',
1526: 'Revalidate_error_record',9);
1527: END IF;
1528:

Line 1577: INV_LOG_UTIL.trace

1573: l_msg_count := NULL;
1574:
1575: IF g_debug = 1
1576: THEN
1577: INV_LOG_UTIL.trace
1578: ( '>> INVRCIDB: IN Consigned_diagnostics ',
1579: 'INV_CONSIGNED_DIAGNOSTICS_PROC' , 9);
1580:
1581: END IF;

Line 1597: INV_LOG_UTIL.trace

1593: COMMIT;
1594:
1595: IF g_debug = 1
1596: THEN
1597: INV_LOG_UTIL.trace
1598: ( 'Completed the conc program diagnostics ' ,
1599: 'INV_CONSIGNED_DIAGNOSTICS_PROC' , 9);
1600: INV_LOG_UTIL.trace
1601: ( 'p_send_notification => '|| p_send_notification ,

Line 1600: INV_LOG_UTIL.trace

1596: THEN
1597: INV_LOG_UTIL.trace
1598: ( 'Completed the conc program diagnostics ' ,
1599: 'INV_CONSIGNED_DIAGNOSTICS_PROC' , 9);
1600: INV_LOG_UTIL.trace
1601: ( 'p_send_notification => '|| p_send_notification ,
1602: 'INV_CONSIGNED_DIAGNOSTICS_PROC' , 9);
1603:
1604: INV_LOG_UTIL.trace

Line 1604: INV_LOG_UTIL.trace

1600: INV_LOG_UTIL.trace
1601: ( 'p_send_notification => '|| p_send_notification ,
1602: 'INV_CONSIGNED_DIAGNOSTICS_PROC' , 9);
1603:
1604: INV_LOG_UTIL.trace
1605: ( 'p_notification_resend_days => '|| p_notification_resend_days ,
1606: 'INV_CONSIGNED_DIAGNOSTICS_PROC' , 9);
1607: END IF;
1608:

Line 1624: INV_LOG_UTIL.trace

1620: );
1621:
1622: IF g_debug = 1
1623: THEN
1624: INV_LOG_UTIL.trace
1625: ( 'Completed the Notification process' ,
1626: 'INV_CONSIGNED_DIAGNOSTICS_PROC' , 9);
1627:
1628: INV_LOG_UTIL.trace

Line 1628: INV_LOG_UTIL.trace

1624: INV_LOG_UTIL.trace
1625: ( 'Completed the Notification process' ,
1626: 'INV_CONSIGNED_DIAGNOSTICS_PROC' , 9);
1627:
1628: INV_LOG_UTIL.trace
1629: ( 'l_return_status => '|| l_return_status ,
1630: 'INV_CONSIGNED_DIAGNOSTICS_PROC' , 9);
1631:
1632: INV_LOG_UTIL.trace

Line 1632: INV_LOG_UTIL.trace

1628: INV_LOG_UTIL.trace
1629: ( 'l_return_status => '|| l_return_status ,
1630: 'INV_CONSIGNED_DIAGNOSTICS_PROC' , 9);
1631:
1632: INV_LOG_UTIL.trace
1633: ( 'x_msg_count => '|| l_msg_count ,
1634: 'INV_CONSIGNED_DIAGNOSTICS_PROC' , 9);
1635:
1636: INV_LOG_UTIL.trace( 'Error=> '||

Line 1636: INV_LOG_UTIL.trace( 'Error=> '||

1632: INV_LOG_UTIL.trace
1633: ( 'x_msg_count => '|| l_msg_count ,
1634: 'INV_CONSIGNED_DIAGNOSTICS_PROC' , 9);
1635:
1636: INV_LOG_UTIL.trace( 'Error=> '||
1637: substrb(FND_MSG_PUB.Get(p_encoded =>
1638: FND_API.G_FALSE),1,500),
1639: 9 );
1640: END IF;

Line 1645: INV_LOG_UTIL.trace

1641: END IF;
1642:
1643: IF g_debug = 1
1644: THEN
1645: INV_LOG_UTIL.trace
1646: ( '<< INVRCIDB: OUT Consigned_diagnostics',
1647: 'INV_CONSIGNED_DIAGNOSTICS_PROC' ,9);
1648:
1649: END IF;

Line 1655: INV_LOG_UTIL.trace

1651:
1652: EXCEPTION
1653:
1654: WHEN OTHERS THEN
1655: INV_LOG_UTIL.trace
1656: ( 'SQLERRM: '|| SQLERRM,9 );
1657:
1658: INV_LOG_UTIL.trace
1659: ( 'Error in Consigned_diagnostics' ,'INVRCIDB', 9);

Line 1658: INV_LOG_UTIL.trace

1654: WHEN OTHERS THEN
1655: INV_LOG_UTIL.trace
1656: ( 'SQLERRM: '|| SQLERRM,9 );
1657:
1658: INV_LOG_UTIL.trace
1659: ( 'Error in Consigned_diagnostics' ,'INVRCIDB', 9);
1660:
1661: INV_LOG_UTIL.trace( 'Error=> '||
1662: substrb(FND_MSG_PUB.Get(p_encoded =>

Line 1661: INV_LOG_UTIL.trace( 'Error=> '||

1657:
1658: INV_LOG_UTIL.trace
1659: ( 'Error in Consigned_diagnostics' ,'INVRCIDB', 9);
1660:
1661: INV_LOG_UTIL.trace( 'Error=> '||
1662: substrb(FND_MSG_PUB.Get(p_encoded =>
1663: FND_API.G_FALSE),1,500),9 );
1664:
1665: rollback;