DBA Data[Home] [Help]

APPS.INVPVALI dependencies on INVPUTLI

Line 263: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452

259:
260: l_item_approved mtl_system_items_b.approval_status%TYPE := NULL;
261: l_item_trans_type mtl_system_items_interface.transaction_type%TYPE := NULL;
262:
263: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
264: l_process_control VARCHAR2(2000) := NULL; --Used by EGO API only for internal flow control
265: l_is_gdsn_batch NUMBER;
266:
267: /* Bug 7513461*/

Line 468: INVPUTLI.info('INVPVALI.Security skipped for Item Org:' || cr.inventory_item_id || '-' || cr.organization_id );

464: end if;
465: END IF; --has privilege
466: ELSE
467: IF l_inv_debug_level IN(101, 102) THEN
468: INVPUTLI.info('INVPVALI.Security skipped for Item Org:' || cr.inventory_item_id || '-' || cr.organization_id );
469: END IF;
470: END IF; --created_by
471:
472: end loop;

Line 744: INVPUTLI.info('INVPVALI.validate_item_revs: validation error: conflict with MIRI');

740: and set_process_id = xset_id
741: and revision = cr.revision;--Bug: 2593490
742:
743: IF l_inv_debug_level IN(101, 102) THEN
744: INVPUTLI.info('INVPVALI.validate_item_revs: validation error: conflict with MIRI');
745: END IF;
746: status := INVPUOPI.mtl_log_interface_err(
747: cr.organization_id,
748: user_id,

Line 830: INVPUTLI.info('INVPVALI.validate_item_revs: validation error: conflict with MIR');

826: set process_flag = l_process_flag_3
827: where rowid = cr.rowid;
828:
829: IF l_inv_debug_level IN(101, 102) THEN
830: INVPUTLI.info('INVPVALI.validate_item_revs: validation error: conflict with MIR');
831: END IF;
832:
833: status := INVPUOPI.mtl_log_interface_err(
834: cr.organization_id,

Line 1121: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452

1117: )
1118: RETURN INTEGER
1119: IS
1120: status NUMBER := 0;
1121: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1122: l_process_control VARCHAR2(2000) := NULL; --Used by EGO API only for internal flow control
1123:
1124: BEGIN
1125:

Line 1129: INVPUTLI.info('INVPVALI: first sta..set_id'||to_char(xset_id)||'org'||to_char(org_id)||'all'||to_char(all_org));

1125:
1126: l_process_control := INV_EGO_REVISION_VALIDATE.Get_Process_Control;
1127:
1128: IF l_inv_debug_level IN(101, 102) THEN
1129: INVPUTLI.info('INVPVALI: first sta..set_id'||to_char(xset_id)||'org'||to_char(org_id)||'all'||to_char(all_org));
1130: END IF;
1131:
1132: if (xset_id < 900000000000) then
1133:

Line 1135: INVPUTLI.info('INVPVALI: before INVPVALM.validate_item_org1');

1131:
1132: if (xset_id < 900000000000) then
1133:
1134: IF l_inv_debug_level IN(101, 102) THEN
1135: INVPUTLI.info('INVPVALI: before INVPVALM.validate_item_org1');
1136: END IF;
1137: status := INVPVALM.validate_item_org1(
1138: org_id,
1139: all_org,

Line 1152: INVPUTLI.info('INVPVALI: before INVPALM2.validate_item_org4');

1148:
1149: if ( (status = 0) and (xset_id < 900000000000) ) then
1150:
1151: IF l_inv_debug_level IN(101, 102) THEN
1152: INVPUTLI.info('INVPVALI: before INVPALM2.validate_item_org4');
1153: END IF;
1154: status := INVPVLM2.validate_item_org4(
1155: org_id,
1156: all_org,

Line 1169: INVPUTLI.info('INVPVALI: before INVPVLM3.validate_item_org7');

1165:
1166: if ( status = 0 and xset_id < 900000000000 ) then
1167:
1168: IF l_inv_debug_level IN(101, 102) THEN
1169: INVPUTLI.info('INVPVALI: before INVPVLM3.validate_item_org7');
1170: END IF;
1171: status := INVPVLM3.validate_item_org7(
1172: org_id,
1173: all_org,

Line 1190: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before INV_EGO_REVISION_VALIDATE.validate_item_user_privileges');

1186: -- Bug 5218491 - Modified the IF clause : Changed <> to = in the below check
1187: IF (INSTR(NVL(l_process_control,'PLM_UI:N'),'PLM_UI:Y') = 0 )
1188: THEN
1189: IF l_inv_debug_level IN(101, 102) THEN
1190: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before INV_EGO_REVISION_VALIDATE.validate_item_user_privileges');
1191: END IF;
1192:
1193: status := INV_EGO_REVISION_VALIDATE.validate_item_user_privileges(
1194: P_Org_Id => org_id

Line 1205: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: INV_EGO_REVISION_VALIDATE.validate_item_user_privileges');

1201: ,P_Set_Id => xset_id
1202: ,X_Err_Text => err_text);
1203:
1204: IF l_inv_debug_level IN(101, 102) THEN
1205: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: INV_EGO_REVISION_VALIDATE.validate_item_user_privileges');
1206: END IF;
1207: END IF;
1208: end if;
1209: --End : Check for data security and user privileges

Line 1214: INVPUTLI.info('INVPVALI: before INVPVHDR.validate_item_header'||to_char(xset_id)||'org'||to_char(org_id)||'all'||to_char(all_org));

1210:
1211: if (status = 0) then
1212:
1213: IF l_inv_debug_level IN(101, 102) THEN
1214: INVPUTLI.info('INVPVALI: before INVPVHDR.validate_item_header'||to_char(xset_id)||'org'||to_char(org_id)||'all'||to_char(all_org));
1215: END IF;
1216: status := INVPVHDR.validate_item_header(
1217: org_id,
1218: all_org,

Line 1231: INVPUTLI.info('INVPVALI: before INVPVDR2.validate_item_header2');

1227:
1228: if (status = 0) then
1229:
1230: IF l_inv_debug_level IN(101, 102) THEN
1231: INVPUTLI.info('INVPVALI: before INVPVDR2.validate_item_header2');
1232: END IF;
1233:
1234: status := INVPVDR2.validate_item_header2(
1235: org_id,

Line 1249: INVPUTLI.info('INVPVALI: before INVPVDR3.validate_item_header3');

1245:
1246: if (status = 0) then
1247:
1248: IF l_inv_debug_level IN(101, 102) THEN
1249: INVPUTLI.info('INVPVALI: before INVPVDR3.validate_item_header3');
1250: END IF;
1251:
1252: status := INVPVDR3.validate_item_header3(
1253: org_id,

Line 1267: INVPUTLI.info('INVPVALI: before INVPVDR4.validate_item_header4');

1263:
1264: if (status = 0) then
1265:
1266: IF l_inv_debug_level IN(101, 102) THEN
1267: INVPUTLI.info('INVPVALI: before INVPVDR4.validate_item_header4');
1268: END IF;
1269:
1270:
1271: status := INVPVDR4.validate_item_header4(

Line 1286: INVPUTLI.info('INVPVALI: before INVPVDR5.validate_item_header5');

1282:
1283: if (status = 0) then
1284:
1285: IF l_inv_debug_level IN(101, 102) THEN
1286: INVPUTLI.info('INVPVALI: before INVPVDR5.validate_item_header5');
1287: END IF;
1288:
1289: status := INVPVDR5.validate_item_header5(
1290: org_id,

Line 1304: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before INVPVDR6.validate_item_header6');

1300:
1301: if (status = 0) then
1302:
1303: IF l_inv_debug_level IN(101, 102) THEN
1304: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before INVPVDR6.validate_item_header6');
1305: END IF;
1306: status := INVPVDR6.validate_item_header6 (
1307: org_id,
1308: all_org,

Line 1318: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: after INVPVDR6.validate_item_header6');

1314: err_text,
1315: xset_id);
1316:
1317: IF l_inv_debug_level IN(101, 102) THEN
1318: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: after INVPVDR6.validate_item_header6');
1319: END IF;
1320: end if;
1321:
1322:

Line 1327: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before INVPVDR7.validate_item_header7');

1323: /* Start Bug 3713912 */
1324: if (status = 0) then
1325:
1326: IF l_inv_debug_level IN(101, 102) THEN
1327: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before INVPVDR7.validate_item_header7');
1328: END IF;
1329:
1330: status := INVPVDR7.validate_item_header7 (
1331: org_id,

Line 1342: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: after INVPVDR7.validate_item_header7');

1338: err_text,
1339: xset_id);
1340:
1341: IF l_inv_debug_level IN(101, 102) THEN
1342: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: after INVPVDR7.validate_item_header7');
1343: END IF;
1344: end if;
1345: /* End Bug 3713912 */
1346:

Line 1351: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before INV_EGO_REVISION_VALIDATE.validate_items_lifecycle');

1347:
1348: -- Start 2777118 : Lifecycle and Phase validations for IOI
1349: IF (status = 0) THEN
1350: IF l_inv_debug_level IN(101, 102) THEN
1351: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before INV_EGO_REVISION_VALIDATE.validate_items_lifecycle');
1352: END IF;
1353: status := INV_EGO_REVISION_VALIDATE.validate_items_lifecycle(
1354: P_Org_Id => org_id
1355: ,P_All_Org => all_org

Line 1365: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: INV_EGO_REVISION_VALIDATE.validate_items_lifecycle');

1361: ,P_Set_Id => xset_id
1362: ,X_Err_Text => err_text);
1363:
1364: IF l_inv_debug_level IN(101, 102) THEN
1365: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: INV_EGO_REVISION_VALIDATE.validate_items_lifecycle');
1366: END IF;
1367: END IF;
1368: -- End 2777118 : Lifecycle and Phase validations for IOI
1369:

Line 1378: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before validate_item_revs');

1374: --Bug:3531430 Validate Item revs irrespective of item is succeeded or not.
1375: -- if (status = 0) then
1376:
1377: IF l_inv_debug_level IN(101, 102) THEN
1378: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before validate_item_revs');
1379: END IF;
1380:
1381: status := INVPVALI.validate_item_revs (
1382: org_id,

Line 1393: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: after validate_item_revs');

1389: err_text,
1390: xset_id );
1391:
1392: IF l_inv_debug_level IN(101, 102) THEN
1393: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: after validate_item_revs');
1394: END IF;
1395:
1396: -- end if;
1397: IF l_inv_debug_level IN(101, 102) THEN

Line 1398: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before validate_items_catalog_group');

1394: END IF;
1395:
1396: -- end if;
1397: IF l_inv_debug_level IN(101, 102) THEN
1398: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before validate_items_catalog_group');
1399: END IF;
1400:
1401: --5208102
1402: INV_EGO_REVISION_VALIDATE.Insert_Revision_UserAttr(P_Set_id=>xset_id);