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.INVPVDR4 dependencies on INVPUOPI

Line 110: dumm_status := INVPUOPI.mtl_log_interface_err(

106: cr.bom_item_type <> 3 AND
107: cr.bom_item_type <> 4 AND
108: cr.bom_item_type <> 5)
109: THEN
110: dumm_status := INVPUOPI.mtl_log_interface_err(
111: cr.organization_id,
112: user_id,
113: login_id,
114: prog_appid,

Line 137: dumm_status := INVPUOPI.mtl_log_interface_err(

133: cr.wip_supply_type <> 4 AND
134: cr.wip_supply_type <> 5 AND
135: cr.wip_supply_type <> 6)
136: THEN
137: dumm_status := INVPUOPI.mtl_log_interface_err(
138: cr.organization_id,
139: user_id,
140: login_id,
141: prog_appid,

Line 161: dumm_status := INVPUOPI.mtl_log_interface_err(

157: IF (cr.allowed_units_lookup_code <> 1 and
158: cr.allowed_units_lookup_code <> 2 and
159: cr.allowed_units_lookup_code <> 3)
160: THEN
161: dumm_status := INVPUOPI.mtl_log_interface_err(
162: cr.organization_id,
163: user_id,
164: login_id,
165: prog_appid,

Line 187: dumm_status := INVPUOPI.mtl_log_interface_err(

183: cr.inventory_planning_code <> 2 AND
184: cr.inventory_planning_code <> 6 AND
185: cr.inventory_planning_code <> 7)
186: THEN
187: dumm_status := INVPUOPI.mtl_log_interface_err(
188: cr.organization_id,
189: user_id,
190: login_id,
191: prog_appid,

Line 208: dumm_status := INVPUOPI.mtl_log_interface_err(

204: END IF;
205:
206: -- validate lookup
207: IF (cr.planning_make_buy_code <> 1 AND cr.planning_make_buy_code <> 2) THEN
208: dumm_status := INVPUOPI.mtl_log_interface_err(
209: cr.organization_id,
210: user_id,
211: login_id,
212: prog_appid,

Line 230: dumm_status := INVPUOPI.mtl_log_interface_err(

226:
227:
228: -- validate lookup
229: IF (cr.rounding_control_type <> 1 AND cr.rounding_control_type <> 2) THEN
230: dumm_status := INVPUOPI.mtl_log_interface_err(
231: cr.organization_id,
232: user_id,
233: login_id,
234: prog_appid,

Line 251: dumm_status := INVPUOPI.mtl_log_interface_err(

247: END IF;
248:
249: -- validate lookup
250: IF (cr.mrp_safety_stock_code <> 1 AND cr.mrp_safety_stock_code <> 2) THEN
251: dumm_status := INVPUOPI.mtl_log_interface_err(
252: cr.organization_id,
253: user_id,
254: login_id,
255: prog_appid,

Line 272: dumm_status := INVPUOPI.mtl_log_interface_err(

268: END IF;
269:
270: -- validate lookup
271: IF (cr.reservable_type <> 1 AND cr.reservable_type <> 2) THEN
272: dumm_status := INVPUOPI.mtl_log_interface_err(
273: cr.organization_id,
274: user_id,
275: login_id,
276: prog_appid,

Line 296: dumm_status := INVPUOPI.mtl_log_interface_err(

292: IF (cr.response_time_period_code <> 'DAY' AND
293: cr.response_time_period_code <> 'HOU' AND
294: cr.response_time_period_code <> 'WEE')
295: THEN
296: dumm_status := INVPUOPI.mtl_log_interface_err(
297: cr.organization_id,
298: user_id,
299: login_id,
300: prog_appid,

Line 319: dumm_status := INVPUOPI.mtl_log_interface_err(

315: -- validate lookup
316: IF (cr.new_revision_code <> 'NOTIFY' AND
317: cr.new_revision_code <> 'SEND_AUTOMATIC')
318: THEN
319: dumm_status := INVPUOPI.mtl_log_interface_err(
320: cr.organization_id,
321: user_id,
322: login_id,
323: prog_appid,

Line 341: dumm_status := INVPUOPI.mtl_log_interface_err(

337:
338: -- validate lookup /*NP 12OCT94 ASS, RES changed to ASSEMBLY, RESOURCE */
339: IF (cr.outside_operation_uom_type <> 'ASSEMBLY' AND
340: cr.outside_operation_uom_type <> 'RESOURCE') THEN
341: dumm_status := INVPUOPI.mtl_log_interface_err(
342: cr.organization_id,
343: user_id,
344: login_id,
345: prog_appid,

Line 366: dumm_status := INVPUOPI.mtl_log_interface_err(

362: cr.auto_reduce_mps <> 2 AND
363: cr.auto_reduce_mps <> 3 AND
364: cr.auto_reduce_mps <> 4)
365: THEN
366: dumm_status := INVPUOPI.mtl_log_interface_err(
367: cr.organization_id,
368: user_id,
369: login_id,
370: prog_appid,

Line 388: dumm_status := INVPUOPI.mtl_log_interface_err(

384:
385:
386: -- validate lookup mrp_planning_code
387: IF (cr.mrp_planning_code not in (3,4,6,7,8,9)) THEN
388: dumm_status := INVPUOPI.mtl_log_interface_err(
389: cr.organization_id,
390: user_id,
391: login_id,
392: prog_appid,

Line 409: dumm_status := INVPUOPI.mtl_log_interface_err(

405: END IF;
406:
407: -- Validate purchasing_tax_code
408: IF ( (cr.taxable_flag <> 'Y') AND (cr.purchasing_tax_code IS NOT NULL) ) THEN
409: dumm_status := INVPUOPI.mtl_log_interface_err(
410: cr.organization_id,
411: user_id,
412: login_id,
413: prog_appid,

Line 451: dumm_status := INVPUOPI.mtl_log_interface_err(

447: AND ORGANIZATION_ID=cr.organization_id)))
448: AND ROWNUM = 1;
449: EXCEPTION
450: WHEN NO_DATA_FOUND THEN
451: dumm_status := INVPUOPI.mtl_log_interface_err(
452: cr.organization_id,
453: user_id,
454: login_id,
455: prog_appid,

Line 474: dumm_status := INVPUOPI.mtl_log_interface_err(

470:
471: -- bug 2843301 Validate Market and List Price.
472:
473: IF (nvl(cr.MARKET_PRICE, 0) < 0 ) THEN
474: dumm_status := INVPUOPI.mtl_log_interface_err(
475: cr.organization_id,
476: user_id,
477: login_id,
478: prog_appid,

Line 494: dumm_status := INVPUOPI.mtl_log_interface_err(

490: status := 1;
491: END IF;
492:
493: IF (NVL(cr.LIST_PRICE_PER_UNIT, 0) < 0 ) THEN
494: dumm_status := INVPUOPI.mtl_log_interface_err(
495: cr.organization_id,
496: user_id,
497: login_id,
498: prog_appid,

Line 515: dumm_status := INVPUOPI.mtl_log_interface_err(

511: END IF;
512:
513: -- validate lookup
514: IF (cr.return_inspection_requirement <> 1 AND cr.return_inspection_requirement <> 2) THEN
515: dumm_status := INVPUOPI.mtl_log_interface_err(
516: cr.organization_id,
517: user_id,
518: login_id,
519: prog_appid,

Line 539: dumm_status := INVPUOPI.mtl_log_interface_err(

535: IF (cr.ato_forecast_control <> 1 AND
536: cr.ato_forecast_control <> 2 AND
537: cr.ato_forecast_control <> 3)
538: THEN
539: dumm_status := INVPUOPI.mtl_log_interface_err(
540: cr.organization_id,
541: user_id,
542: login_id,
543: prog_appid,

Line 563: dumm_status := INVPUOPI.mtl_log_interface_err(

559: -- Bug 3969864 - Anmurali
560: -- validate CUMULATIVE_TOTAL_LEAD_TIME
561: -- length should not exceed 42 digits
562: IF (LENGTH(TO_CHAR(cr.cumulative_total_lead_time)) > 42 ) THEN
563: dumm_status := INVPUOPI.mtl_log_interface_err(
564: cr.organization_id,
565: user_id,
566: login_id,
567: prog_appid,

Line 586: dumm_status := INVPUOPI.mtl_log_interface_err(

582: -- Bug 5724477
583: -- validate CUM_MANUFACTURING_LEAD_TIME
584: -- length should not exceed 42 digits
585: IF (length(to_char(cr.CUM_MANUFACTURING_LEAD_TIME)) > 42 ) THEN
586: dumm_status := INVPUOPI.mtl_log_interface_err(
587: cr.organization_id,
588: user_id,
589: login_id,
590: prog_appid,

Line 609: dumm_status := INVPUOPI.mtl_log_interface_err(

605:
606: -- Validate Coverage Template value Added as part of 11.5.9 ENH.
607: IF (cr.COVERAGE_SCHEDULE_ID IS NOT NULL ) THEN
608: IF (cr.contract_item_type_code IS NULL ) THEN
609: dumm_status := INVPUOPI.mtl_log_interface_err(
610: cr.organization_id,
611: user_id,
612: login_id,
613: prog_appid,

Line 654: dumm_status := INVPUOPI.mtl_log_interface_err

650: AND SYSDATE BETWEEN NVL(start_date, SYSDATE-1) AND NVL(end_date, SYSDATE+1);
651: END IF;
652: EXCEPTION
653: WHEN NO_DATA_FOUND THEN
654: dumm_status := INVPUOPI.mtl_log_interface_err
655: ( cr.organization_id,
656: user_id, login_id, prog_appid, prog_id, request_id,
657: cr.TRANSACTION_ID, error_msg,
658: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 669: dumm_status := INVPUOPI.mtl_log_interface_err(

665: END;
666: END IF;
667: -- Bug: 2811878 This validation will be in 11.5.10 in IOI
668: ELSIF(cr.CONTRACT_ITEM_TYPE_CODE IN ('SERVICE', 'WARRANTY')) THEN
669: dumm_status := INVPUOPI.mtl_log_interface_err(
670: cr.organization_id,
671: user_id,
672: login_id,
673: prog_appid,

Line 693: dumm_status := INVPUOPI.mtl_log_interface_err(

689: IF (cr.COMMS_NL_TRACKABLE_FLAG = 'Y' AND
690: --Bug: 2696647 Subscription Items can be Installed Base trackable
691: cr.contract_item_type_code IN ('SERVICE','WARRANTY','USAGE'))
692: THEN
693: dumm_status := INVPUOPI.mtl_log_interface_err(
694: cr.organization_id,
695: user_id,
696: login_id,
697: prog_appid,

Line 716: dumm_status := INVPUOPI.mtl_log_interface_err(

712: --Start 3416621 Subscription should be IB trackble
713: IF (cr.contract_item_type_code = 'SUBSCRIPTION' AND
714: NVL(cr.COMMS_NL_TRACKABLE_FLAG,'N') <> 'Y')
715: THEN
716: dumm_status := INVPUOPI.mtl_log_interface_err(
717: cr.organization_id,
718: user_id,
719: login_id,
720: prog_appid,

Line 740: dumm_status := INVPUOPI.mtl_log_interface_err(

736: --Added for 11.5.10
737: IF (NVL(cr.COMMS_NL_TRACKABLE_FLAG,'N') = 'N' AND
738: NVL(cr.asset_creation_code,'0') = '1')
739: THEN
740: dumm_status := INVPUOPI.mtl_log_interface_err(
741: cr.organization_id,
742: user_id,
743: login_id,
744: prog_appid,

Line 764: dumm_status := INVPUOPI.mtl_log_interface_err(

760: IF (NVL(cr.COMMS_NL_TRACKABLE_FLAG,'N') <> 'Y' AND
761: cr.CONTRACT_ITEM_TYPE_CODE IS NULL AND
762: cr.SERVICEABLE_PRODUCT_FLAG = 'Y')
763: THEN
764: dumm_status := INVPUOPI.mtl_log_interface_err(
765: cr.organization_id,
766: user_id,
767: login_id,
768: prog_appid,

Line 786: dumm_status := INVPUOPI.mtl_log_interface_err(

782: /*
783: --Validate LOT_SUBSTITUTION_ENABLED
784: --Added validation for new attributes as part of 11.5.9
785: IF ( cr.LOT_SUBSTITUTION_ENABLED = 'Y' AND NVL(cr.LOT_CONTROL_CODE,1)=1) THEN
786: dumm_status := INVPUOPI.mtl_log_interface_err(
787: cr.organization_id,
788: user_id,
789: login_id,
790: prog_appid,

Line 812: dumm_status := INVPUOPI.mtl_log_interface_err

808: IF ( cr.LOT_SUBSTITUTION_ENABLED IS NOT NULL AND cr.LOT_SUBSTITUTION_ENABLED NOT IN ( 'Y','N') )THEN
809: l_col_name := 'LOT_SUBSTITUTION_ENABLED';
810: l_msg_name := 'INV_NOT_VALID_FLAG';
811:
812: dumm_status := INVPUOPI.mtl_log_interface_err
813: ( cr.organization_id,
814: user_id, login_id, prog_appid, prog_id, request_id,
815: cr.TRANSACTION_ID, error_msg,
816: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 827: dumm_status := INVPUOPI.mtl_log_interface_err(

823: END IF; -- LOT_SUBSTITUTION_ENABLED is not null
824:
825: /*Bug: 5140047 Commenting out this validation as this is duplicate.
826: IF ( cr.LOT_SUBSTITUTION_ENABLED = 'Y' AND NVL(cr.LOT_CONTROL_CODE,1)=1) THEN
827: dumm_status := INVPUOPI.mtl_log_interface_err(
828: cr.organization_id,
829: user_id,
830: login_id,
831: prog_appid,

Line 850: dumm_status := INVPUOPI.mtl_log_interface_err(

846: -- Lot Subsitution flag must be either NULL or 'Y'
847: --BEGIN : Fix for Bug# 2760857 (PPEDDAMA)
848: --Begin : ***Validate LOT_TRANSLATE_ENABLED***
849: IF ( cr.LOT_TRANSLATE_ENABLED IS NOT NULL AND cr.LOT_TRANSLATE_ENABLED NOT IN ( 'Y','N') )THEN
850: dumm_status := INVPUOPI.mtl_log_interface_err(
851: cr.organization_id,
852: user_id,
853: login_id,
854: prog_appid,

Line 870: dumm_status := INVPUOPI.mtl_log_interface_err(

866: status := 1;
867: END IF; -- LOT_TRANSLATE_ENABLED is not null AND <> 'Y'
868:
869: IF ( cr.LOT_TRANSLATE_ENABLED = 'Y' AND NVL(cr.LOT_CONTROL_CODE,1)=1) THEN
870: dumm_status := INVPUOPI.mtl_log_interface_err(
871: cr.organization_id,
872: user_id,
873: login_id,
874: prog_appid,

Line 892: dumm_status := INVPUOPI.mtl_log_interface_err(

888: --End : ***Validate LOT_TRANSLATE_ENABLED***
889:
890: --Begin : ***Validate LOT_SPLIT_ENABLED***
891: IF ( cr.LOT_SPLIT_ENABLED IS NOT NULL AND cr.LOT_SPLIT_ENABLED NOT IN ( 'Y','N') )THEN
892: dumm_status := INVPUOPI.mtl_log_interface_err(
893: cr.organization_id,
894: user_id,
895: login_id,
896: prog_appid,

Line 912: dumm_status := INVPUOPI.mtl_log_interface_err(

908: status := 1;
909: END IF;-- LOT_SPLIT_ENABLED is not null AND <> 'Y'
910:
911: IF ( cr.LOT_SPLIT_ENABLED = 'Y' AND NVL(cr.LOT_CONTROL_CODE,1)=1) THEN
912: dumm_status := INVPUOPI.mtl_log_interface_err(
913: cr.organization_id,
914: user_id,
915: login_id,
916: prog_appid,

Line 934: dumm_status := INVPUOPI.mtl_log_interface_err(

930: --End : ***Validate LOT_SPLIT_ENABLED***
931:
932: --Begin : ***Validate LOT_MERGE_ENABLED***
933: IF ( cr.LOT_MERGE_ENABLED IS NOT NULL AND cr.LOT_MERGE_ENABLED NOT IN ( 'Y','N') )THEN
934: dumm_status := INVPUOPI.mtl_log_interface_err(
935: cr.organization_id,
936: user_id,
937: login_id,
938: prog_appid,

Line 954: dumm_status := INVPUOPI.mtl_log_interface_err(

950: status := 1;
951: END IF;-- LOT_MERGE_ENABLED is not null AND <> 'Y'
952:
953: IF ( cr.LOT_MERGE_ENABLED = 'Y' AND NVL(cr.LOT_CONTROL_CODE,1)=1) THEN
954: dumm_status := INVPUOPI.mtl_log_interface_err(
955: cr.organization_id,
956: user_id,
957: login_id,
958: prog_appid,

Line 979: dumm_status := INVPUOPI.mtl_log_interface_err(

975: --Bug No: 3285381 Modified IF st.
976: IF ( NVL(cr.MINIMUM_LICENSE_QUANTITY,1) < 1 OR
977: NVL(cr.MINIMUM_LICENSE_QUANTITY,1) <> CEIL(NVL(cr.MINIMUM_LICENSE_QUANTITY,1)) )
978: THEN
979: dumm_status := INVPUOPI.mtl_log_interface_err(
980: cr.organization_id,
981: user_id,
982: login_id,
983: prog_appid,

Line 999: dumm_status := INVPUOPI.mtl_log_interface_err(

995: status := 1;
996: END IF; -- MINIMUM_LICENSE_QUANTITY < 1
997:
998: IF ( NVL(cr.COMMS_NL_TRACKABLE_FLAG,'N') <> 'Y' AND cr.IB_ITEM_INSTANCE_CLASS IS NOT NULL) THEN
999: dumm_status := INVPUOPI.mtl_log_interface_err(
1000: cr.organization_id,
1001: user_id,
1002: login_id,
1003: prog_appid,

Line 1027: dumm_status := INVPUOPI.mtl_log_interface_err

1023: FETCH c_fndlookup_exists INTO temp;
1024: CLOSE c_fndlookup_exists;
1025:
1026: IF temp IS NULL THEN
1027: dumm_status := INVPUOPI.mtl_log_interface_err
1028: ( cr.organization_id,
1029: user_id, login_id, prog_appid, prog_id, request_id,
1030: cr.TRANSACTION_ID, error_msg,
1031: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1046: dumm_status := INVPUOPI.mtl_log_interface_err(

1042: IF ( cr.CONFIG_MODEL_TYPE IS NOT NULL AND
1043: NOT ( cr.BOM_ITEM_TYPE = 1 AND
1044: cr.CUSTOMER_ORDER_ENABLED_FLAG = 'Y' ) )
1045: THEN
1046: dumm_status := INVPUOPI.mtl_log_interface_err(
1047: cr.organization_id,
1048: user_id,
1049: login_id,
1050: prog_appid,

Line 1068: dumm_status := INVPUOPI.mtl_log_interface_err(

1064:
1065: -- CONFIG_MODEL_TYPE "Network Container Model" (N) cannot be
1066: -- Installed Base trackable item.
1067: IF ( NVL(cr.COMMS_NL_TRACKABLE_FLAG,'N') = 'Y' AND cr.CONFIG_MODEL_TYPE = 'N' ) THEN
1068: dumm_status := INVPUOPI.mtl_log_interface_err(
1069: cr.organization_id,
1070: user_id,
1071: login_id,
1072: prog_appid,

Line 1096: dumm_status := INVPUOPI.mtl_log_interface_err

1092: FETCH c_fndlookup_exists INTO temp;
1093: CLOSE c_fndlookup_exists;
1094:
1095: IF temp IS NULL THEN
1096: dumm_status := INVPUOPI.mtl_log_interface_err
1097: ( cr.organization_id,
1098: user_id, login_id, prog_appid, prog_id, request_id,
1099: cr.TRANSACTION_ID, error_msg,
1100: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1118: dumm_status := INVPUOPI.mtl_log_interface_err(

1114: OPEN c_fndlookup_exists('IBE_ITEM_STATUS',cr.WEB_STATUS);
1115: FETCH c_fndlookup_exists INTO temp;
1116: CLOSE c_fndlookup_exists;
1117: IF temp IS NULL THEN
1118: dumm_status := INVPUOPI.mtl_log_interface_err(
1119: cr.organization_id,
1120: user_id,
1121: login_id,
1122: prog_appid,

Line 1176: dumm_status := INVPUOPI.mtl_log_interface_err

1172: RAISE no_data_found;
1173: END IF;
1174: EXCEPTION
1175: WHEN no_data_found THEN
1176: dumm_status := INVPUOPI.mtl_log_interface_err
1177: ( cr.organization_id,
1178: user_id, login_id, prog_appid, prog_id, request_id,
1179: cr.TRANSACTION_ID, error_msg,
1180: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1194: dumm_status := INVPUOPI.mtl_log_interface_err

1190: IF ( NOT ( cr.INVENTORY_ITEM_FLAG = 'Y' ) ) THEN
1191: l_col_name := 'INVENTORY_ITEM_FLAG';
1192: l_msg_name := 'INV_EAM_ITEM_TYPE_PF_INV';
1193:
1194: dumm_status := INVPUOPI.mtl_log_interface_err
1195: ( cr.organization_id,
1196: user_id, login_id, prog_appid, prog_id, request_id,
1197: cr.TRANSACTION_ID, error_msg,
1198: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1217: dumm_status := INVPUOPI.mtl_log_interface_err

1213: THEN
1214: l_col_name := 'COMMS_NL_TRACKABLE_FLAG';
1215: l_msg_name := 'INV_EAM_IB_TRACKABLE';
1216:
1217: dumm_status := INVPUOPI.mtl_log_interface_err
1218: (cr.organization_id,
1219: user_id,
1220: login_id,
1221: prog_appid,

Line 1241: dumm_status := INVPUOPI.mtl_log_interface_err

1237: IF ( cr.EAM_ITEM_TYPE = 1 AND NOT ( cr.EFFECTIVITY_CONTROL = 2 ) ) THEN
1238: l_col_name := 'EFFECTIVITY_CONTROL';
1239: l_msg_name := 'INV_EAM_ASSET_UNIT_CONTROL';
1240:
1241: dumm_status := INVPUOPI.mtl_log_interface_err
1242: ( cr.organization_id,
1243: user_id, login_id, prog_appid, prog_id, request_id,
1244: cr.TRANSACTION_ID, error_msg,
1245: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1262: dumm_status := INVPUOPI.mtl_log_interface_err

1258: IF ( cr.EAM_ITEM_TYPE = 1 AND cr.SERIAL_NUMBER_CONTROL_CODE NOT IN (2,5)) THEN
1259: l_col_name := 'SERIAL_NUMBER_CONTROL_CODE';
1260: l_msg_name := 'INV_EAM_ASSET_GRP_NO_SERIAL';
1261:
1262: dumm_status := INVPUOPI.mtl_log_interface_err
1263: ( cr.organization_id,
1264: user_id, login_id, prog_appid, prog_id, request_id,
1265: cr.TRANSACTION_ID, error_msg,
1266: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1285: dumm_status := INVPUOPI.mtl_log_interface_err

1281: THEN
1282: l_col_name := 'SERIAL_NUMBER_CONTROL_CODE';
1283: l_msg_name := 'INV_EAM_ACTIVITY_NEVER_SERIAL';
1284:
1285: dumm_status := INVPUOPI.mtl_log_interface_err
1286: ( cr.organization_id,
1287: user_id, login_id, prog_appid, prog_id, request_id,
1288: cr.TRANSACTION_ID, error_msg,
1289: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1316: dumm_status := INVPUOPI.mtl_log_interface_err

1312: (cr.BOM_ITEM_TYPE in (1,2) OR cr.BOM_ENABLED_FLAG='Y' ) )
1313: THEN
1314: l_col_name := 'TRACKING_QUANTITY_IND';
1315: l_msg_name := 'INV_TRACKING_OPM_BOM_ATTR';
1316: dumm_status := INVPUOPI.mtl_log_interface_err
1317: ( cr.organization_id,
1318: user_id,
1319: login_id,
1320: prog_appid,

Line 1352: dumm_status := INVPUOPI.mtl_log_interface_err

1348: FETCH c_mfglookup_exists INTO temp;
1349: CLOSE c_mfglookup_exists;
1350:
1351: IF (temp IS NULL) THEN
1352: dumm_status := INVPUOPI.mtl_log_interface_err
1353: ( cr.organization_id,user_id, login_id, prog_appid,
1354: prog_id, request_id,cr.TRANSACTION_ID, error_msg,
1355: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',l_msg_name,err_text );
1356: IF dumm_status < 0 THEN

Line 1374: dumm_status := INVPUOPI.mtl_log_interface_err

1370: OPEN c_mfglookup_exists('MTL_EAM_ACTIVITY_CAUSE',cr.EAM_ACTIVITY_CAUSE_CODE);
1371: FETCH c_mfglookup_exists INTO temp;
1372: CLOSE c_mfglookup_exists;
1373: IF (temp IS NULL) THEN
1374: dumm_status := INVPUOPI.mtl_log_interface_err
1375: ( cr.organization_id,
1376: user_id, login_id, prog_appid, prog_id, request_id,
1377: cr.TRANSACTION_ID, error_msg,
1378: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1399: dumm_status := INVPUOPI.mtl_log_interface_err

1395: OPEN c_mfglookup_exists('BOM_EAM_SHUTDOWN_TYPE',cr.EAM_ACT_SHUTDOWN_STATUS);
1396: FETCH c_mfglookup_exists INTO temp;
1397: CLOSE c_mfglookup_exists;
1398: IF (temp IS NULL) THEN
1399: dumm_status := INVPUOPI.mtl_log_interface_err
1400: ( cr.organization_id,
1401: user_id, login_id, prog_appid, prog_id, request_id,
1402: cr.TRANSACTION_ID, error_msg,
1403: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1422: dumm_status := INVPUOPI.mtl_log_interface_err

1418: OR cr.EAM_ACT_NOTIFICATION_FLAG IN ('Y', 'N') ))
1419: THEN
1420: l_col_name := 'EAM_ACT_NOTIFICATION_FLAG';
1421: l_msg_name := 'INV_IOI_FLAG_Y_N';
1422: dumm_status := INVPUOPI.mtl_log_interface_err
1423: ( cr.organization_id,
1424: user_id, login_id, prog_appid, prog_id, request_id,
1425: cr.TRANSACTION_ID, error_msg,
1426: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1450: dumm_status := INVPUOPI.mtl_log_interface_err

1446: FETCH c_fndlookup_exists INTO temp;
1447: CLOSE c_fndlookup_exists;
1448:
1449: IF temp IS NULL THEN
1450: dumm_status := INVPUOPI.mtl_log_interface_err
1451: ( cr.organization_id,
1452: user_id, login_id, prog_appid, prog_id, request_id,
1453: cr.TRANSACTION_ID, error_msg,
1454: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1472: dumm_status := INVPUOPI.mtl_log_interface_err

1468: IF ( cr.EAM_ACTIVITY_TYPE_CODE IS NOT NULL ) THEN
1469: l_col_name := 'EAM_ACTIVITY_TYPE_CODE';
1470: l_msg_name := 'INV_EAM_NON_ACT_ACT_TYPE';
1471:
1472: dumm_status := INVPUOPI.mtl_log_interface_err
1473: ( cr.organization_id,
1474: user_id, login_id, prog_appid, prog_id, request_id,
1475: cr.TRANSACTION_ID, error_msg,
1476: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1492: dumm_status := INVPUOPI.mtl_log_interface_err

1488:
1489: l_col_name := 'EAM_ACTIVITY_CAUSE_CODE';
1490: l_msg_name := 'INV_EAM_NON_ACT_ACT_CAUSE';
1491:
1492: dumm_status := INVPUOPI.mtl_log_interface_err
1493: ( cr.organization_id,
1494: user_id, login_id, prog_appid, prog_id, request_id,
1495: cr.TRANSACTION_ID, error_msg,
1496: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1512: dumm_status := INVPUOPI.mtl_log_interface_err

1508:
1509: l_col_name := 'EAM_ACT_SHUTDOWN_STATUS';
1510: l_msg_name := 'INV_EAM_NON_ACT_ACT_SHUTDOWN';
1511:
1512: dumm_status := INVPUOPI.mtl_log_interface_err
1513: ( cr.organization_id,
1514: user_id, login_id, prog_appid, prog_id, request_id,
1515: cr.TRANSACTION_ID, error_msg,
1516: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1532: dumm_status := INVPUOPI.mtl_log_interface_err

1528:
1529: l_col_name := 'EAM_ACT_NOTIFICATION_FLAG';
1530: l_msg_name := 'INV_EAM_NON_ACT_ACT_NOTIF_FLAG';
1531:
1532: dumm_status := INVPUOPI.mtl_log_interface_err
1533: ( cr.organization_id,
1534: user_id, login_id, prog_appid, prog_id, request_id,
1535: cr.TRANSACTION_ID, error_msg,
1536: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1551: dumm_status := INVPUOPI.mtl_log_interface_err

1547: IF ( cr.EAM_ACTIVITY_SOURCE_CODE IS NOT NULL ) THEN
1548: l_col_name := 'EAM_ACTIVITY_SOURCE_CODE';
1549: l_msg_name := 'INV_EAM_NON_ACT_ACT_SOURCE';
1550:
1551: dumm_status := INVPUOPI.mtl_log_interface_err
1552: ( cr.organization_id,
1553: user_id, login_id, prog_appid, prog_id, request_id,
1554: cr.TRANSACTION_ID, error_msg,
1555: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1583: dumm_status := INVPUOPI.mtl_log_interface_err

1579: AND ENABLED_FLAG = 'Y';
1580:
1581: EXCEPTION
1582: WHEN no_data_found THEN
1583: dumm_status := INVPUOPI.mtl_log_interface_err
1584: (cr.organization_id,
1585: user_id, login_id, prog_appid, prog_id, request_id,
1586: cr.TRANSACTION_ID, error_msg,
1587: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1602: dumm_status := INVPUOPI.mtl_log_interface_err

1598:
1599: IF (cr.PURCHASING_ENABLED_FLAG <>'Y' OR cr.PURCHASING_ENABLED_FLAG IS NULL) THEN
1600: l_msg_name := 'INV_PURCHASING_SO_SOURCE_TYPE';
1601: l_col_name := 'DEFAULT_SO_SOURCE_TYPE';
1602: dumm_status := INVPUOPI.mtl_log_interface_err
1603: (cr.organization_id,
1604: user_id, login_id, prog_appid, prog_id, request_id,
1605: cr.TRANSACTION_ID, error_msg,
1606: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1617: dumm_status := INVPUOPI.mtl_log_interface_err

1613:
1614: IF (cr.SHIP_MODEL_COMPLETE_FLAG ='Y') THEN
1615: l_msg_name := 'INV_DEFAULT_SO_SOURCE_TYPE_EXT';
1616: l_col_name := 'DEFAULT_SO_SOURCE_TYPE';
1617: dumm_status := INVPUOPI.mtl_log_interface_err
1618: (cr.organization_id,
1619: user_id, login_id, prog_appid, prog_id, request_id,
1620: cr.TRANSACTION_ID, error_msg,
1621: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1654: dumm_status := INVPUOPI.mtl_log_interface_err

1650: END IF;
1651:
1652: IF l_col_name IS NOT NULL THEN
1653: l_msg_name := 'INV_INVALID_ATTR_COL_VALUE';
1654: dumm_status := INVPUOPI.mtl_log_interface_err
1655: (cr.organization_id,
1656: user_id, login_id, prog_appid, prog_id, request_id,
1657: cr.TRANSACTION_ID, error_msg,
1658: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1679: dumm_status := INVPUOPI.mtl_log_interface_err

1675: l_msg_name := 'INV_IOI_SUBS_WIN_DAYS_NULL';
1676: END IF;
1677:
1678: IF l_col_name IS NOT NULL THEN
1679: dumm_status := INVPUOPI.mtl_log_interface_err
1680: (cr.organization_id,
1681: user_id, login_id, prog_appid, prog_id, request_id,
1682: cr.TRANSACTION_ID, error_msg,
1683: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1714: dumm_status := INVPUOPI.mtl_log_interface_err

1710: l_msg_name := 'INV_IOI_DIMENSION_UOM_MISSING';
1711: END IF;
1712:
1713: IF l_col_name IS NOT NULL THEN
1714: dumm_status := INVPUOPI.mtl_log_interface_err
1715: (cr.organization_id,
1716: user_id, login_id, prog_appid, prog_id, request_id,
1717: cr.TRANSACTION_ID, error_msg,
1718: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1743: dumm_status := INVPUOPI.mtl_log_interface_err

1739:
1740:
1741: EXCEPTION
1742: WHEN no_data_found THEN
1743: dumm_status := INVPUOPI.mtl_log_interface_err
1744: ( cr.organization_id,
1745: user_id, login_id, prog_appid, prog_id, request_id,
1746: cr.TRANSACTION_ID,
1747: error_msg,

Line 1813: dumm_status := INVPUOPI.mtl_log_interface_err(

1809: WHEN LOGGING_ERR THEN
1810: return (dumm_status);
1811:
1812: WHEN VALIDATE_ERR THEN
1813: dumm_status := INVPUOPI.mtl_log_interface_err(
1814: l_org_id,
1815: user_id,
1816: login_id,
1817: prog_appid,