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 425: INVPUTLI.info('INVUPD1B.mtl_pr_assign_item_data_update: when OTHERS exception');

421: err_text);
422: RETURN (1);
423: WHEN OTHERS THEN
424: IF l_inv_debug_level IN(101, 102) THEN
425: INVPUTLI.info('INVUPD1B.mtl_pr_assign_item_data_update: when OTHERS exception');
426: END IF;
427: RETURN (1);
428: -- any other error other than no data found ?
429: END mtl_pr_assign_item_data_update; -- }

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

490: msi_rec msi_attr%rowtype;
491: attrib_error exception;
492: attr_noerr_flg number;
493:
494: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
495:
496: BEGIN --{
497:
498: attr_noerr_flg := 0;

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

727: close msii_attr;
728: return 1;
729: when OTHERS then
730: IF l_inv_debug_level IN(101, 102) THEN
731: INVPUTLI.info('when OTHERS exception raised in mtl_validate_attr_upd');
732: END IF;
733: close msi_attr;
734: close msii_attr;
735: return 1;

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

1044: INVALID_TEMPLATE_ERR EXCEPTION;
1045: ASS_ITEM_ERR EXCEPTION;
1046: ORG_TEMPLATE_ERR EXCEPTION;
1047: PARSE_ITEM_ERR EXCEPTION;
1048: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1049:
1050: BEGIN -- {
1051:
1052: IF l_inv_debug_level IN(101, 102) THEN

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

1049:
1050: BEGIN -- {
1051:
1052: IF l_inv_debug_level IN(101, 102) THEN
1053: INVPUTLI.info('INVUPD1B: Inside chk_exist_copy_template_attr'|| '***orgid: ' || TO_CHAR(org_id));
1054: END IF;
1055:
1056: status_code := INVUPD1B.check_inv_item_id(
1057: org_id,

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

1173: EXCEPTION
1174:
1175: when OTHERS then
1176: IF l_inv_debug_level IN(101, 102) THEN
1177: INVPUTLI.info('when OTHERS exception raised in chk_exist_copy_template_attr');
1178: END IF;
1179: return (1);
1180:
1181: END chk_exist_copy_template_attr; -- }

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

1211: error_text VARCHAR2(250);
1212: l_process_flag_3 NUMBER := 3;
1213: dumm_status NUMBER;
1214: ret_code NUMBER := 0;
1215: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1216:
1217: BEGIN -- {
1218:
1219: IF l_inv_debug_level IN(101, 102) THEN

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

1216:
1217: BEGIN -- {
1218:
1219: IF l_inv_debug_level IN(101, 102) THEN
1220: INVPUTLI.info('INVUPD1B: Inside check_inv_item_id'|| '***orgid: ' || TO_CHAR(org_id));
1221: END IF;
1222:
1223: for rec in C_inv_item_id_records loop -- {
1224:

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

1251: EXCEPTION
1252:
1253: when OTHERS then
1254: IF l_inv_debug_level IN(101, 102) THEN
1255: INVPUTLI.info('when OTHERS exception raised in check_inv_item_id');
1256: END IF;
1257: return (1);
1258:
1259: END check_inv_item_id; -- }

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

1288: err_temp VARCHAR2(1000);
1289: transaction_id_bind INTEGER;
1290: dummy_ret_code NUMBER;
1291:
1292: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1293:
1294: BEGIN -- {
1295:
1296: IF l_inv_debug_level IN(101, 102) THEN

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

1293:
1294: BEGIN -- {
1295:
1296: IF l_inv_debug_level IN(101, 102) THEN
1297: INVPUTLI.info('INVUPD1B: Inside exists_in_msi'|| '***orgid: ' || TO_CHAR(org_id));
1298: END IF;
1299:
1300: if inv_item_id is null then -- {
1301:

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

1298: END IF;
1299:
1300: if inv_item_id is null then -- {
1301:
1302: dummy_ret_code := INVPUTLI.get_dynamic_sql_str(1, statement_temp, err_temp);
1303: DSQL_statement := 'select msi.inventory_item_id
1304: from mtl_system_items_B msi,
1305: mtl_system_items_interface msii
1306: where msii.rowid = :row_id_bind

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

1344: return 0;
1345:
1346: when OTHERS then
1347: IF l_inv_debug_level IN(101, 102) THEN
1348: INVPUTLI.info('when OTHERS exception raised in exists_in_msi');
1349: END IF;
1350:
1351: if dbms_sql.is_open(DSQL_c) then -- {
1352: dbms_sql.close_cursor(DSQL_c);

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

1380: )
1381: return INTEGER
1382: IS
1383: tmp_org_id NUMBER;
1384: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1385: BEGIN -- {
1386:
1387: IF l_inv_debug_level IN(101, 102) THEN
1388: INVPUTLI.info('INVUPD1B: Inside exists_onhand_quantities'|| '***orgid: ' || TO_CHAR(org_id));

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

1384: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1385: BEGIN -- {
1386:
1387: IF l_inv_debug_level IN(101, 102) THEN
1388: INVPUTLI.info('INVUPD1B: Inside exists_onhand_quantities'|| '***orgid: ' || TO_CHAR(org_id));
1389: END IF;
1390:
1391:
1392:

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

1407: return (1);
1408:
1409: when OTHERS then
1410: IF l_inv_debug_level IN(101, 102) THEN
1411: INVPUTLI.info('when OTHERS exception raised in exists_onhand_quantities');
1412: END IF;
1413: return (0);
1414:
1415: END exists_onhand_quantities; -- }

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

1435:
1436: tmp_org_id NUMBER;
1437: status NUMBER := 0;
1438:
1439: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1440:
1441: BEGIN -- {
1442:
1443: IF l_inv_debug_level IN(101, 102) THEN

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

1440:
1441: BEGIN -- {
1442:
1443: IF l_inv_debug_level IN(101, 102) THEN
1444: INVPUTLI.info('INVUPD1B: Inside exists_onhand_child_qties'|| '***orgid: ' || TO_CHAR(org_id));
1445: END IF;
1446: -- if record is a master record
1447: select organization_id
1448: into tmp_org_id

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

1470: return (0);
1471:
1472: when OTHERS then
1473: IF l_inv_debug_level IN(101, 102) THEN
1474: INVPUTLI.info('when OTHERS exception raised in exists_onhand_child_qties');
1475: END IF;
1476: return (0);
1477:
1478: END exists_onhand_child_qties; -- }

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

1493:
1494: msi_record_temp MTL_SYSTEM_ITEMS_VL%ROWTYPE;
1495: msii_temp_data MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;
1496: l_process_flag_2 NUMBER := 2;
1497: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1498:
1499: BEGIN -- {
1500:
1501: IF l_inv_debug_level IN(101, 102) THEN

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

1498:
1499: BEGIN -- {
1500:
1501: IF l_inv_debug_level IN(101, 102) THEN
1502: INVPUTLI.info('INVUPD1B: Inside copy_msi_to_msii'|| '***orgid: ' || TO_CHAR(org_id));
1503: END IF;
1504:
1505: SELECT * INTO msi_record_temp
1506: FROM MTL_SYSTEM_ITEMS_VL MSI

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

4022: EXCEPTION
4023:
4024: WHEN OTHERS THEN
4025: IF l_inv_debug_level IN(101, 102) THEN
4026: INVPUTLI.info('when OTHERS exception raised in copy_msi_to_msii');
4027: END IF;
4028: RETURN(1);
4029:
4030: END copy_msi_to_msii; -- }

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

4047: ret_code_create NUMBER := 1;
4048: ret_code_master NUMBER := 1;
4049: ret_code_child NUMBER := 1;
4050:
4051: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
4052:
4053: BEGIN -- {
4054:
4055: IF l_inv_debug_level IN(101, 102) THEN

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

4052:
4053: BEGIN -- {
4054:
4055: IF l_inv_debug_level IN(101, 102) THEN
4056: INVPUTLI.info('INVUPD1B: Inside mtl_pr_validate_item_update'|| '***orgid: ' || TO_CHAR(org_id));
4057: END IF;
4058:
4059: ret_code_create := INVPVALI.mtl_pr_validate_item(
4060: org_id => org_id,

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

4107: EXCEPTION
4108:
4109: when OTHERS then
4110: IF l_inv_debug_level IN(101, 102) THEN
4111: INVPUTLI.info('when OTHERS exception raised in mtl_pr_validate_item_update' || SQLERRM);
4112: END IF;
4113:
4114: return (1);
4115: