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 450: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 473: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 493: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 514: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 538: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 562: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 585: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 608: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 653: dumm_status := INVPUOPI.mtl_log_interface_err

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

Line 668: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 692: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 715: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 739: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 763: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 785: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 809: dumm_status := INVPUOPI.mtl_log_interface_err

805: IF ( cr.LOT_SUBSTITUTION_ENABLED IS NOT NULL AND cr.LOT_SUBSTITUTION_ENABLED <> 'Y' )THEN
806: l_col_name := 'LOT_SUBSTITUTION_ENABLED';
807: l_msg_name := 'INV_NOT_VALID_FLAG';
808:
809: dumm_status := INVPUOPI.mtl_log_interface_err
810: ( cr.organization_id,
811: user_id, login_id, prog_appid, prog_id, request_id,
812: cr.TRANSACTION_ID, error_msg,
813: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 824: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 847: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 867: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 889: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 909: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 931: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 951: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 976: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 996: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 1024: dumm_status := INVPUOPI.mtl_log_interface_err

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

Line 1043: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 1065: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 1093: dumm_status := INVPUOPI.mtl_log_interface_err

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

Line 1115: dumm_status := INVPUOPI.mtl_log_interface_err(

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

Line 1170: dumm_status := INVPUOPI.mtl_log_interface_err

1166: RAISE no_data_found;
1167: END IF;
1168: EXCEPTION
1169: WHEN no_data_found THEN
1170: dumm_status := INVPUOPI.mtl_log_interface_err
1171: ( cr.organization_id,
1172: user_id, login_id, prog_appid, prog_id, request_id,
1173: cr.TRANSACTION_ID, error_msg,
1174: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1188: dumm_status := INVPUOPI.mtl_log_interface_err

1184: IF ( NOT ( cr.INVENTORY_ITEM_FLAG = 'Y' ) ) THEN
1185: l_col_name := 'INVENTORY_ITEM_FLAG';
1186: l_msg_name := 'INV_EAM_ITEM_TYPE_PF_INV';
1187:
1188: dumm_status := INVPUOPI.mtl_log_interface_err
1189: ( cr.organization_id,
1190: user_id, login_id, prog_appid, prog_id, request_id,
1191: cr.TRANSACTION_ID, error_msg,
1192: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1211: dumm_status := INVPUOPI.mtl_log_interface_err

1207: THEN
1208: l_col_name := 'COMMS_NL_TRACKABLE_FLAG';
1209: l_msg_name := 'INV_EAM_IB_TRACKABLE';
1210:
1211: dumm_status := INVPUOPI.mtl_log_interface_err
1212: (cr.organization_id,
1213: user_id,
1214: login_id,
1215: prog_appid,

Line 1235: dumm_status := INVPUOPI.mtl_log_interface_err

1231: IF ( cr.EAM_ITEM_TYPE = 1 AND NOT ( cr.EFFECTIVITY_CONTROL = 2 ) ) THEN
1232: l_col_name := 'EFFECTIVITY_CONTROL';
1233: l_msg_name := 'INV_EAM_ASSET_UNIT_CONTROL';
1234:
1235: dumm_status := INVPUOPI.mtl_log_interface_err
1236: ( cr.organization_id,
1237: user_id, login_id, prog_appid, prog_id, request_id,
1238: cr.TRANSACTION_ID, error_msg,
1239: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1256: dumm_status := INVPUOPI.mtl_log_interface_err

1252: IF ( cr.EAM_ITEM_TYPE = 1 AND cr.SERIAL_NUMBER_CONTROL_CODE NOT IN (2,5)) THEN
1253: l_col_name := 'SERIAL_NUMBER_CONTROL_CODE';
1254: l_msg_name := 'INV_EAM_ASSET_GRP_NO_SERIAL';
1255:
1256: dumm_status := INVPUOPI.mtl_log_interface_err
1257: ( cr.organization_id,
1258: user_id, login_id, prog_appid, prog_id, request_id,
1259: cr.TRANSACTION_ID, error_msg,
1260: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1279: dumm_status := INVPUOPI.mtl_log_interface_err

1275: THEN
1276: l_col_name := 'SERIAL_NUMBER_CONTROL_CODE';
1277: l_msg_name := 'INV_EAM_ACTIVITY_NEVER_SERIAL';
1278:
1279: dumm_status := INVPUOPI.mtl_log_interface_err
1280: ( cr.organization_id,
1281: user_id, login_id, prog_appid, prog_id, request_id,
1282: cr.TRANSACTION_ID, error_msg,
1283: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1309: dumm_status := INVPUOPI.mtl_log_interface_err

1305: (cr.BOM_ITEM_TYPE in (1,2) OR cr.BOM_ENABLED_FLAG='Y' ) )
1306: THEN
1307: l_col_name := 'TRACKING_QUANTITY_IND';
1308: l_msg_name := 'INV_TRACKING_OPM_BOM_ATTR';
1309: dumm_status := INVPUOPI.mtl_log_interface_err
1310: ( cr.organization_id,
1311: user_id,
1312: login_id,
1313: prog_appid,

Line 1345: dumm_status := INVPUOPI.mtl_log_interface_err

1341: FETCH c_mfglookup_exists INTO temp;
1342: CLOSE c_mfglookup_exists;
1343:
1344: IF (temp IS NULL) THEN
1345: dumm_status := INVPUOPI.mtl_log_interface_err
1346: ( cr.organization_id,user_id, login_id, prog_appid,
1347: prog_id, request_id,cr.TRANSACTION_ID, error_msg,
1348: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',l_msg_name,err_text );
1349: IF dumm_status < 0 THEN

Line 1367: dumm_status := INVPUOPI.mtl_log_interface_err

1363: OPEN c_mfglookup_exists('MTL_EAM_ACTIVITY_CAUSE',cr.EAM_ACTIVITY_CAUSE_CODE);
1364: FETCH c_mfglookup_exists INTO temp;
1365: CLOSE c_mfglookup_exists;
1366: IF (temp IS NULL) THEN
1367: dumm_status := INVPUOPI.mtl_log_interface_err
1368: ( cr.organization_id,
1369: user_id, login_id, prog_appid, prog_id, request_id,
1370: cr.TRANSACTION_ID, error_msg,
1371: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1392: dumm_status := INVPUOPI.mtl_log_interface_err

1388: OPEN c_mfglookup_exists('BOM_EAM_SHUTDOWN_TYPE',cr.EAM_ACT_SHUTDOWN_STATUS);
1389: FETCH c_mfglookup_exists INTO temp;
1390: CLOSE c_mfglookup_exists;
1391: IF (temp IS NULL) THEN
1392: dumm_status := INVPUOPI.mtl_log_interface_err
1393: ( cr.organization_id,
1394: user_id, login_id, prog_appid, prog_id, request_id,
1395: cr.TRANSACTION_ID, error_msg,
1396: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1415: dumm_status := INVPUOPI.mtl_log_interface_err

1411: OR cr.EAM_ACT_NOTIFICATION_FLAG IN ('Y', 'N') ))
1412: THEN
1413: l_col_name := 'EAM_ACT_NOTIFICATION_FLAG';
1414: l_msg_name := 'INV_IOI_FLAG_Y_N';
1415: dumm_status := INVPUOPI.mtl_log_interface_err
1416: ( cr.organization_id,
1417: user_id, login_id, prog_appid, prog_id, request_id,
1418: cr.TRANSACTION_ID, error_msg,
1419: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1443: dumm_status := INVPUOPI.mtl_log_interface_err

1439: FETCH c_fndlookup_exists INTO temp;
1440: CLOSE c_fndlookup_exists;
1441:
1442: IF temp IS NULL THEN
1443: dumm_status := INVPUOPI.mtl_log_interface_err
1444: ( cr.organization_id,
1445: user_id, login_id, prog_appid, prog_id, request_id,
1446: cr.TRANSACTION_ID, error_msg,
1447: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1465: dumm_status := INVPUOPI.mtl_log_interface_err

1461: IF ( cr.EAM_ACTIVITY_TYPE_CODE IS NOT NULL ) THEN
1462: l_col_name := 'EAM_ACTIVITY_TYPE_CODE';
1463: l_msg_name := 'INV_EAM_NON_ACT_ACT_TYPE';
1464:
1465: dumm_status := INVPUOPI.mtl_log_interface_err
1466: ( cr.organization_id,
1467: user_id, login_id, prog_appid, prog_id, request_id,
1468: cr.TRANSACTION_ID, error_msg,
1469: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1485: dumm_status := INVPUOPI.mtl_log_interface_err

1481:
1482: l_col_name := 'EAM_ACTIVITY_CAUSE_CODE';
1483: l_msg_name := 'INV_EAM_NON_ACT_ACT_CAUSE';
1484:
1485: dumm_status := INVPUOPI.mtl_log_interface_err
1486: ( cr.organization_id,
1487: user_id, login_id, prog_appid, prog_id, request_id,
1488: cr.TRANSACTION_ID, error_msg,
1489: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1505: dumm_status := INVPUOPI.mtl_log_interface_err

1501:
1502: l_col_name := 'EAM_ACT_SHUTDOWN_STATUS';
1503: l_msg_name := 'INV_EAM_NON_ACT_ACT_SHUTDOWN';
1504:
1505: dumm_status := INVPUOPI.mtl_log_interface_err
1506: ( cr.organization_id,
1507: user_id, login_id, prog_appid, prog_id, request_id,
1508: cr.TRANSACTION_ID, error_msg,
1509: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1525: dumm_status := INVPUOPI.mtl_log_interface_err

1521:
1522: l_col_name := 'EAM_ACT_NOTIFICATION_FLAG';
1523: l_msg_name := 'INV_EAM_NON_ACT_ACT_NOTIF_FLAG';
1524:
1525: dumm_status := INVPUOPI.mtl_log_interface_err
1526: ( cr.organization_id,
1527: user_id, login_id, prog_appid, prog_id, request_id,
1528: cr.TRANSACTION_ID, error_msg,
1529: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1544: dumm_status := INVPUOPI.mtl_log_interface_err

1540: IF ( cr.EAM_ACTIVITY_SOURCE_CODE IS NOT NULL ) THEN
1541: l_col_name := 'EAM_ACTIVITY_SOURCE_CODE';
1542: l_msg_name := 'INV_EAM_NON_ACT_ACT_SOURCE';
1543:
1544: dumm_status := INVPUOPI.mtl_log_interface_err
1545: ( cr.organization_id,
1546: user_id, login_id, prog_appid, prog_id, request_id,
1547: cr.TRANSACTION_ID, error_msg,
1548: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1576: dumm_status := INVPUOPI.mtl_log_interface_err

1572: AND ENABLED_FLAG = 'Y';
1573:
1574: EXCEPTION
1575: WHEN no_data_found THEN
1576: dumm_status := INVPUOPI.mtl_log_interface_err
1577: (cr.organization_id,
1578: user_id, login_id, prog_appid, prog_id, request_id,
1579: cr.TRANSACTION_ID, error_msg,
1580: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1595: dumm_status := INVPUOPI.mtl_log_interface_err

1591:
1592: IF (cr.PURCHASING_ENABLED_FLAG <>'Y' OR cr.PURCHASING_ENABLED_FLAG IS NULL) THEN
1593: l_msg_name := 'INV_PURCHASING_SO_SOURCE_TYPE';
1594: l_col_name := 'DEFAULT_SO_SOURCE_TYPE';
1595: dumm_status := INVPUOPI.mtl_log_interface_err
1596: (cr.organization_id,
1597: user_id, login_id, prog_appid, prog_id, request_id,
1598: cr.TRANSACTION_ID, error_msg,
1599: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1610: dumm_status := INVPUOPI.mtl_log_interface_err

1606:
1607: IF (cr.SHIP_MODEL_COMPLETE_FLAG ='Y') THEN
1608: l_msg_name := 'INV_DEFAULT_SO_SOURCE_TYPE_EXT';
1609: l_col_name := 'DEFAULT_SO_SOURCE_TYPE';
1610: dumm_status := INVPUOPI.mtl_log_interface_err
1611: (cr.organization_id,
1612: user_id, login_id, prog_appid, prog_id, request_id,
1613: cr.TRANSACTION_ID, error_msg,
1614: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1647: dumm_status := INVPUOPI.mtl_log_interface_err

1643: END IF;
1644:
1645: IF l_col_name IS NOT NULL THEN
1646: l_msg_name := 'INV_INVALID_ATTR_COL_VALUE';
1647: dumm_status := INVPUOPI.mtl_log_interface_err
1648: (cr.organization_id,
1649: user_id, login_id, prog_appid, prog_id, request_id,
1650: cr.TRANSACTION_ID, error_msg,
1651: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1672: dumm_status := INVPUOPI.mtl_log_interface_err

1668: l_msg_name := 'INV_IOI_SUBS_WIN_DAYS_NULL';
1669: END IF;
1670:
1671: IF l_col_name IS NOT NULL THEN
1672: dumm_status := INVPUOPI.mtl_log_interface_err
1673: (cr.organization_id,
1674: user_id, login_id, prog_appid, prog_id, request_id,
1675: cr.TRANSACTION_ID, error_msg,
1676: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1707: dumm_status := INVPUOPI.mtl_log_interface_err

1703: l_msg_name := 'INV_IOI_DIMENSION_UOM_MISSING';
1704: END IF;
1705:
1706: IF l_col_name IS NOT NULL THEN
1707: dumm_status := INVPUOPI.mtl_log_interface_err
1708: (cr.organization_id,
1709: user_id, login_id, prog_appid, prog_id, request_id,
1710: cr.TRANSACTION_ID, error_msg,
1711: l_col_name, 'MTL_SYSTEM_ITEMS_INTERFACE',

Line 1736: dumm_status := INVPUOPI.mtl_log_interface_err

1732:
1733:
1734: EXCEPTION
1735: WHEN no_data_found THEN
1736: dumm_status := INVPUOPI.mtl_log_interface_err
1737: ( cr.organization_id,
1738: user_id, login_id, prog_appid, prog_id, request_id,
1739: cr.TRANSACTION_ID,
1740: error_msg,

Line 1805: dumm_status := INVPUOPI.mtl_log_interface_err(

1801: WHEN LOGGING_ERR THEN
1802: return (dumm_status);
1803:
1804: WHEN VALIDATE_ERR THEN
1805: dumm_status := INVPUOPI.mtl_log_interface_err(
1806: l_org_id,
1807: user_id,
1808: login_id,
1809: prog_appid,