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.INVUPD1B dependencies on INVPUTLI

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

89: msi_ont_pricing_qty_source mtl_system_items.ont_pricing_qty_source%TYPE;
90: msi_dual_uom_deviation_high mtl_system_items.dual_uom_deviation_high%TYPE;
91: msi_dual_uom_deviation_low mtl_system_items.dual_uom_deviation_low%TYPE;
92:
93: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
94:
95:
96: BEGIN -- {
97:

Line 99: INVPUTLI.info('INVUPD1B.mtl_pr_assign_item_data_update: begin org_id=' || TO_CHAR(org_id));

95:
96: BEGIN -- {
97:
98: IF l_inv_debug_level IN(101, 102) THEN
99: INVPUTLI.info('INVUPD1B.mtl_pr_assign_item_data_update: begin org_id=' || TO_CHAR(org_id));
100: END IF;
101:
102: -- Added for Bug 4366615
103: FOR puom IN C_puom_records LOOP

Line 441: INVPUTLI.info('INVUPD1B.mtl_pr_assign_item_data_update: when OTHERS exception');

437: err_text);
438: RETURN (1);
439: WHEN OTHERS THEN
440: IF l_inv_debug_level IN(101, 102) THEN
441: INVPUTLI.info('INVUPD1B.mtl_pr_assign_item_data_update: when OTHERS exception');
442: END IF;
443: RETURN (1);
444: -- any other error other than no data found ?
445: END mtl_pr_assign_item_data_update; -- }

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

506: msi_rec msi_attr%rowtype;
507: attrib_error exception;
508: attr_noerr_flg number;
509:
510: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
511:
512: BEGIN --{
513:
514: attr_noerr_flg := 0;

Line 747: INVPUTLI.info('when OTHERS exception raised in mtl_validate_attr_upd');

743: close msii_attr;
744: return 1;
745: when OTHERS then
746: IF l_inv_debug_level IN(101, 102) THEN
747: INVPUTLI.info('when OTHERS exception raised in mtl_validate_attr_upd');
748: END IF;
749: close msi_attr;
750: close msii_attr;
751: return 1;

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

1060: INVALID_TEMPLATE_ERR EXCEPTION;
1061: ASS_ITEM_ERR EXCEPTION;
1062: ORG_TEMPLATE_ERR EXCEPTION;
1063: PARSE_ITEM_ERR EXCEPTION;
1064: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1065:
1066: BEGIN -- {
1067:
1068: IF l_inv_debug_level IN(101, 102) THEN

Line 1069: INVPUTLI.info('INVUPD1B: Inside chk_exist_copy_template_attr'|| '***orgid: ' || TO_CHAR(org_id));

1065:
1066: BEGIN -- {
1067:
1068: IF l_inv_debug_level IN(101, 102) THEN
1069: INVPUTLI.info('INVUPD1B: Inside chk_exist_copy_template_attr'|| '***orgid: ' || TO_CHAR(org_id));
1070: END IF;
1071:
1072: status_code := INVUPD1B.check_inv_item_id(
1073: org_id,

Line 1193: INVPUTLI.info('when OTHERS exception raised in chk_exist_copy_template_attr');

1189: EXCEPTION
1190:
1191: when OTHERS then
1192: IF l_inv_debug_level IN(101, 102) THEN
1193: INVPUTLI.info('when OTHERS exception raised in chk_exist_copy_template_attr');
1194: END IF;
1195: return (1);
1196:
1197: END chk_exist_copy_template_attr; -- }

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

1227: error_text VARCHAR2(250);
1228: l_process_flag_3 NUMBER := 3;
1229: dumm_status NUMBER;
1230: ret_code NUMBER := 0;
1231: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1232:
1233: BEGIN -- {
1234:
1235: IF l_inv_debug_level IN(101, 102) THEN

Line 1236: INVPUTLI.info('INVUPD1B: Inside check_inv_item_id'|| '***orgid: ' || TO_CHAR(org_id));

1232:
1233: BEGIN -- {
1234:
1235: IF l_inv_debug_level IN(101, 102) THEN
1236: INVPUTLI.info('INVUPD1B: Inside check_inv_item_id'|| '***orgid: ' || TO_CHAR(org_id));
1237: END IF;
1238:
1239: for rec in C_inv_item_id_records loop -- {
1240:

Line 1271: INVPUTLI.info('when OTHERS exception raised in check_inv_item_id');

1267: EXCEPTION
1268:
1269: when OTHERS then
1270: IF l_inv_debug_level IN(101, 102) THEN
1271: INVPUTLI.info('when OTHERS exception raised in check_inv_item_id');
1272: END IF;
1273: return (1);
1274:
1275: END check_inv_item_id; -- }

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

1304: err_temp VARCHAR2(1000);
1305: transaction_id_bind INTEGER;
1306: dummy_ret_code NUMBER;
1307:
1308: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1309:
1310: BEGIN -- {
1311:
1312: IF l_inv_debug_level IN(101, 102) THEN

Line 1313: INVPUTLI.info('INVUPD1B: Inside exists_in_msi'|| '***orgid: ' || TO_CHAR(org_id));

1309:
1310: BEGIN -- {
1311:
1312: IF l_inv_debug_level IN(101, 102) THEN
1313: INVPUTLI.info('INVUPD1B: Inside exists_in_msi'|| '***orgid: ' || TO_CHAR(org_id));
1314: END IF;
1315:
1316: if inv_item_id is null then -- {
1317:

Line 1318: dummy_ret_code := INVPUTLI.get_dynamic_sql_str(1, statement_temp, err_temp);

1314: END IF;
1315:
1316: if inv_item_id is null then -- {
1317:
1318: dummy_ret_code := INVPUTLI.get_dynamic_sql_str(1, statement_temp, err_temp);
1319: DSQL_statement := 'select msi.inventory_item_id
1320: from mtl_system_items_B msi,
1321: mtl_system_items_interface msii
1322: where msii.rowid = :row_id_bind

Line 1364: INVPUTLI.info('when OTHERS exception raised in exists_in_msi');

1360: return 0;
1361:
1362: when OTHERS then
1363: IF l_inv_debug_level IN(101, 102) THEN
1364: INVPUTLI.info('when OTHERS exception raised in exists_in_msi');
1365: END IF;
1366:
1367: if dbms_sql.is_open(DSQL_c) then -- {
1368: dbms_sql.close_cursor(DSQL_c);

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

1396: )
1397: return INTEGER
1398: IS
1399: tmp_org_id NUMBER;
1400: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1401: BEGIN -- {
1402:
1403: IF l_inv_debug_level IN(101, 102) THEN
1404: INVPUTLI.info('INVUPD1B: Inside exists_onhand_quantities'|| '***orgid: ' || TO_CHAR(org_id));

Line 1404: INVPUTLI.info('INVUPD1B: Inside exists_onhand_quantities'|| '***orgid: ' || TO_CHAR(org_id));

1400: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1401: BEGIN -- {
1402:
1403: IF l_inv_debug_level IN(101, 102) THEN
1404: INVPUTLI.info('INVUPD1B: Inside exists_onhand_quantities'|| '***orgid: ' || TO_CHAR(org_id));
1405: END IF;
1406:
1407:
1408:

Line 1427: INVPUTLI.info('when OTHERS exception raised in exists_onhand_quantities');

1423: return (1);
1424:
1425: when OTHERS then
1426: IF l_inv_debug_level IN(101, 102) THEN
1427: INVPUTLI.info('when OTHERS exception raised in exists_onhand_quantities');
1428: END IF;
1429: return (0);
1430:
1431: END exists_onhand_quantities; -- }

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

1451:
1452: tmp_org_id NUMBER;
1453: status NUMBER := 0;
1454:
1455: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1456:
1457: BEGIN -- {
1458:
1459: IF l_inv_debug_level IN(101, 102) THEN

Line 1460: INVPUTLI.info('INVUPD1B: Inside exists_onhand_child_qties'|| '***orgid: ' || TO_CHAR(org_id));

1456:
1457: BEGIN -- {
1458:
1459: IF l_inv_debug_level IN(101, 102) THEN
1460: INVPUTLI.info('INVUPD1B: Inside exists_onhand_child_qties'|| '***orgid: ' || TO_CHAR(org_id));
1461: END IF;
1462: -- if record is a master record
1463: select organization_id
1464: into tmp_org_id

Line 1490: INVPUTLI.info('when OTHERS exception raised in exists_onhand_child_qties');

1486: return (0);
1487:
1488: when OTHERS then
1489: IF l_inv_debug_level IN(101, 102) THEN
1490: INVPUTLI.info('when OTHERS exception raised in exists_onhand_child_qties');
1491: END IF;
1492: return (0);
1493:
1494: END exists_onhand_child_qties; -- }

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

1509:
1510: msi_record_temp MTL_SYSTEM_ITEMS_VL%ROWTYPE;
1511: msii_temp_data MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;
1512: l_process_flag_2 NUMBER := 2;
1513: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1514:
1515: BEGIN -- {
1516:
1517: IF l_inv_debug_level IN(101, 102) THEN

Line 1518: INVPUTLI.info('INVUPD1B: Inside copy_msi_to_msii'|| '***orgid: ' || TO_CHAR(org_id));

1514:
1515: BEGIN -- {
1516:
1517: IF l_inv_debug_level IN(101, 102) THEN
1518: INVPUTLI.info('INVUPD1B: Inside copy_msi_to_msii'|| '***orgid: ' || TO_CHAR(org_id));
1519: END IF;
1520:
1521: SELECT * INTO msi_record_temp
1522: FROM MTL_SYSTEM_ITEMS_VL MSI

Line 4053: INVPUTLI.info('when OTHERS exception raised in copy_msi_to_msii');

4049: EXCEPTION
4050:
4051: WHEN OTHERS THEN
4052: IF l_inv_debug_level IN(101, 102) THEN
4053: INVPUTLI.info('when OTHERS exception raised in copy_msi_to_msii');
4054: END IF;
4055: RETURN(1);
4056:
4057: END copy_msi_to_msii; -- }

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

4074: ret_code_create NUMBER := 1;
4075: ret_code_master NUMBER := 1;
4076: ret_code_child NUMBER := 1;
4077:
4078: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
4079:
4080: BEGIN -- {
4081:
4082: IF l_inv_debug_level IN(101, 102) THEN

Line 4083: INVPUTLI.info('INVUPD1B: Inside mtl_pr_validate_item_update'|| '***orgid: ' || TO_CHAR(org_id));

4079:
4080: BEGIN -- {
4081:
4082: IF l_inv_debug_level IN(101, 102) THEN
4083: INVPUTLI.info('INVUPD1B: Inside mtl_pr_validate_item_update'|| '***orgid: ' || TO_CHAR(org_id));
4084: END IF;
4085:
4086: ret_code_create := INVPVALI.mtl_pr_validate_item(
4087: org_id => org_id,

Line 4138: INVPUTLI.info('when OTHERS exception raised in mtl_pr_validate_item_update' || SQLERRM);

4134: EXCEPTION
4135:
4136: when OTHERS then
4137: IF l_inv_debug_level IN(101, 102) THEN
4138: INVPUTLI.info('when OTHERS exception raised in mtl_pr_validate_item_update' || SQLERRM);
4139: END IF;
4140:
4141: return (1);
4142: