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 749: INVPUTLI.info('INVPVALI.validate_item_revs: validation error: conflict with MIRI');

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

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

831: set process_flag = l_process_flag_3
832: where rowid = cr.rowid;
833:
834: IF l_inv_debug_level IN(101, 102) THEN
835: INVPUTLI.info('INVPVALI.validate_item_revs: validation error: conflict with MIR');
836: END IF;
837:
838: status := INVPUOPI.mtl_log_interface_err(
839: cr.organization_id,

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

1122: )
1123: RETURN INTEGER
1124: IS
1125: status NUMBER := 0;
1126: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1127: l_process_control VARCHAR2(2000) := NULL; --Used by EGO API only for internal flow control
1128:
1129: BEGIN
1130:

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

1130:
1131: l_process_control := INV_EGO_REVISION_VALIDATE.Get_Process_Control;
1132:
1133: IF l_inv_debug_level IN(101, 102) THEN
1134: INVPUTLI.info('INVPVALI: first sta..set_id'||to_char(xset_id)||'org'||to_char(org_id)||'all'||to_char(all_org));
1135: END IF;
1136:
1137: if (xset_id < 900000000000) then
1138:

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

1136:
1137: if (xset_id < 900000000000) then
1138:
1139: IF l_inv_debug_level IN(101, 102) THEN
1140: INVPUTLI.info('INVPVALI: before INVPVALM.validate_item_org1');
1141: END IF;
1142: status := INVPVALM.validate_item_org1(
1143: org_id,
1144: all_org,

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

1153:
1154: if ( (status = 0) and (xset_id < 900000000000) ) then
1155:
1156: IF l_inv_debug_level IN(101, 102) THEN
1157: INVPUTLI.info('INVPVALI: before INVPALM2.validate_item_org4');
1158: END IF;
1159: status := INVPVLM2.validate_item_org4(
1160: org_id,
1161: all_org,

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

1170:
1171: if ( status = 0 and xset_id < 900000000000 ) then
1172:
1173: IF l_inv_debug_level IN(101, 102) THEN
1174: INVPUTLI.info('INVPVALI: before INVPVLM3.validate_item_org7');
1175: END IF;
1176: status := INVPVLM3.validate_item_org7(
1177: org_id,
1178: all_org,

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

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

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

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

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

1215:
1216: if (status = 0) then
1217:
1218: IF l_inv_debug_level IN(101, 102) THEN
1219: INVPUTLI.info('INVPVALI: before INVPVHDR.validate_item_header'||to_char(xset_id)||'org'||to_char(org_id)||'all'||to_char(all_org));
1220: END IF;
1221: status := INVPVHDR.validate_item_header(
1222: org_id,
1223: all_org,

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

1232:
1233: if (status = 0) then
1234:
1235: IF l_inv_debug_level IN(101, 102) THEN
1236: INVPUTLI.info('INVPVALI: before INVPVDR2.validate_item_header2');
1237: END IF;
1238:
1239: status := INVPVDR2.validate_item_header2(
1240: org_id,

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

1250:
1251: if (status = 0) then
1252:
1253: IF l_inv_debug_level IN(101, 102) THEN
1254: INVPUTLI.info('INVPVALI: before INVPVDR3.validate_item_header3');
1255: END IF;
1256:
1257: status := INVPVDR3.validate_item_header3(
1258: org_id,

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

1268:
1269: if (status = 0) then
1270:
1271: IF l_inv_debug_level IN(101, 102) THEN
1272: INVPUTLI.info('INVPVALI: before INVPVDR4.validate_item_header4');
1273: END IF;
1274:
1275:
1276: status := INVPVDR4.validate_item_header4(

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

1287:
1288: if (status = 0) then
1289:
1290: IF l_inv_debug_level IN(101, 102) THEN
1291: INVPUTLI.info('INVPVALI: before INVPVDR5.validate_item_header5');
1292: END IF;
1293:
1294: status := INVPVDR5.validate_item_header5(
1295: org_id,

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

1305:
1306: if (status = 0) then
1307:
1308: IF l_inv_debug_level IN(101, 102) THEN
1309: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before INVPVDR6.validate_item_header6');
1310: END IF;
1311: status := INVPVDR6.validate_item_header6 (
1312: org_id,
1313: all_org,

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

1319: err_text,
1320: xset_id);
1321:
1322: IF l_inv_debug_level IN(101, 102) THEN
1323: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: after INVPVDR6.validate_item_header6');
1324: END IF;
1325: end if;
1326:
1327:

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

1328: /* Start Bug 3713912 */
1329: if (status = 0) then
1330:
1331: IF l_inv_debug_level IN(101, 102) THEN
1332: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before INVPVDR7.validate_item_header7');
1333: END IF;
1334:
1335: status := INVPVDR7.validate_item_header7 (
1336: org_id,

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

1343: err_text,
1344: xset_id);
1345:
1346: IF l_inv_debug_level IN(101, 102) THEN
1347: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: after INVPVDR7.validate_item_header7');
1348: END IF;
1349: end if;
1350: /* End Bug 3713912 */
1351:

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

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

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

1366: ,P_Set_Id => xset_id
1367: ,X_Err_Text => err_text);
1368:
1369: IF l_inv_debug_level IN(101, 102) THEN
1370: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: INV_EGO_REVISION_VALIDATE.validate_items_lifecycle');
1371: END IF;
1372: END IF;
1373: -- End 2777118 : Lifecycle and Phase validations for IOI
1374:

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

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

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

1394: err_text,
1395: xset_id );
1396:
1397: IF l_inv_debug_level IN(101, 102) THEN
1398: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: after validate_item_revs');
1399: END IF;
1400:
1401: -- end if;
1402: IF l_inv_debug_level IN(101, 102) THEN

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

1399: END IF;
1400:
1401: -- end if;
1402: IF l_inv_debug_level IN(101, 102) THEN
1403: INVPUTLI.info('INVPVALI.mtl_pr_validate_item: before validate_items_catalog_group');
1404: END IF;
1405:
1406: --5208102
1407: INV_EGO_REVISION_VALIDATE.Insert_Revision_UserAttr(P_Set_id=>xset_id);