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 INVUPD1B

Line 1: PACKAGE BODY INVUPD1B AS -- {

1: PACKAGE BODY INVUPD1B AS -- {
2: /* $Header: INVUPD1B.pls 120.29.12020000.4 2013/01/23 08:46:29 lmai ship $ */
3: -- Values used in IOI to indicate an attribute update to NULL.
4: --
5: g_Upd_Null_CHAR VARCHAR2(1) := '!';

Line 2: /* $Header: INVUPD1B.pls 120.29.12020000.4 2013/01/23 08:46:29 lmai ship $ */

1: PACKAGE BODY INVUPD1B AS -- {
2: /* $Header: INVUPD1B.pls 120.29.12020000.4 2013/01/23 08:46:29 lmai ship $ */
3: -- Values used in IOI to indicate an attribute update to NULL.
4: --
5: g_Upd_Null_CHAR VARCHAR2(1) := '!';
6: g_Upd_Null_NUM NUMBER := -999999;

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 277: IF (INVUPD1B.exists_onhand_quantities(t_organization_id, t_inventory_item_id) <> 1

273: AND rec.COSTING_ENABLED_FLAG IS NULL
274: AND rec.INVENTORY_ASSET_FLAG IS NULL )
275: THEN -- {
276: -- if onhand quantities exist or transactions pending then
277: IF (INVUPD1B.exists_onhand_quantities(t_organization_id, t_inventory_item_id) <> 1
278: AND INVUPD1B.exists_onhand_child_qties(t_organization_id, t_inventory_item_id) <> 1 )
279: THEN -- {
280: -- copy msi data to msii record for ``missing'' attributes, also set process_ flag = 2
281: dumm_status := INVUPD1B.copy_msi_to_msii(rec.rowid,t_organization_id, t_inventory_item_id);

Line 278: AND INVUPD1B.exists_onhand_child_qties(t_organization_id, t_inventory_item_id) <> 1 )

274: AND rec.INVENTORY_ASSET_FLAG IS NULL )
275: THEN -- {
276: -- if onhand quantities exist or transactions pending then
277: IF (INVUPD1B.exists_onhand_quantities(t_organization_id, t_inventory_item_id) <> 1
278: AND INVUPD1B.exists_onhand_child_qties(t_organization_id, t_inventory_item_id) <> 1 )
279: THEN -- {
280: -- copy msi data to msii record for ``missing'' attributes, also set process_ flag = 2
281: dumm_status := INVUPD1B.copy_msi_to_msii(rec.rowid,t_organization_id, t_inventory_item_id);
282: rtn_status := INVPULI4.assign_status_attributes(rec.inventory_item_id,rec.organization_id,err_text,xset_id,rec.rowid);

Line 281: dumm_status := INVUPD1B.copy_msi_to_msii(rec.rowid,t_organization_id, t_inventory_item_id);

277: IF (INVUPD1B.exists_onhand_quantities(t_organization_id, t_inventory_item_id) <> 1
278: AND INVUPD1B.exists_onhand_child_qties(t_organization_id, t_inventory_item_id) <> 1 )
279: THEN -- {
280: -- copy msi data to msii record for ``missing'' attributes, also set process_ flag = 2
281: dumm_status := INVUPD1B.copy_msi_to_msii(rec.rowid,t_organization_id, t_inventory_item_id);
282: rtn_status := INVPULI4.assign_status_attributes(rec.inventory_item_id,rec.organization_id,err_text,xset_id,rec.rowid);
283: IF rtn_status = 0 THEN
284: status_code := 1;
285: ELSE

Line 291: upd_status := INVUPD1B.mtl_validate_attr_upd(

287: END IF;
288:
289: ELSE -- } {
290: -- Check for dependencies of attributes being updated
291: upd_status := INVUPD1B.mtl_validate_attr_upd(
292: rec.organization_id,
293: rec.inventory_item_id,
294: rec.rowid,
295: attr_err_mesg_name);

Line 317: dumm_status := INVUPD1B.copy_msi_to_msii(rec.rowid,t_organization_id,t_inventory_item_id);

313: err_text);
314:
315: upd_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
316: ELSE
317: dumm_status := INVUPD1B.copy_msi_to_msii(rec.rowid,t_organization_id,t_inventory_item_id);
318: rtn_status := INVPULI4.assign_status_attributes(rec.inventory_item_id,rec.organization_id,err_text,xset_id,rec.rowid);
319: IF rtn_status = 0 THEN
320: status_code := 1;
321: ELSE

Line 328: dumm_status := INVUPD1B.copy_msi_to_msii(rec.rowid, t_organization_id, t_inventory_item_id);

324: END IF; --}
325: END IF; -- }
326: ELSE -- no onhand qties exist and no transactions pending -- } {
327: -- copy msi data to msii record for ``missing'' attributes, also set process_flag = 2
328: dumm_status := INVUPD1B.copy_msi_to_msii(rec.rowid, t_organization_id, t_inventory_item_id);
329: rtn_status := INVPULI4.assign_status_attributes(rec.inventory_item_id,rec.organization_id,err_text,xset_id,rec.rowid);
330: IF rtn_status = 0 THEN
331: status_code := 1;
332: ELSE

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 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 1072: status_code := INVUPD1B.check_inv_item_id(

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,
1074: all_org,
1075: prog_appid,
1076: prog_id,

Line 1103: if ( INVUPD1B.exists_in_msi(

1099: raise PARSE_ITEM_ERR;
1100: end if; -- }
1101: end if; -- }
1102:
1103: if ( INVUPD1B.exists_in_msi(
1104: rec.ROWID,
1105: t_organization_id,
1106: t_inventory_item_id,
1107: prog_appid,

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 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 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 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 1471: status := INVUPD1B.exists_onhand_quantities(rec.INVENTORY_ITEM_ID, rec.ORGANIZATION_ID);

1467: AND MP.master_organization_id = org_id;
1468:
1469: for rec in C_child_msi_records loop -- {
1470:
1471: status := INVUPD1B.exists_onhand_quantities(rec.INVENTORY_ITEM_ID, rec.ORGANIZATION_ID);
1472: exit when status = 1;
1473:
1474: end loop; -- }
1475:

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 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 4476: err_text := 'INVUPD1B.assign_item_rev_data_update: bad return status from INVPUOPI.mtl_pr_parse_flex_name, please check mtl_interface_errors with transaction_id:'||tran_id;

4472: RETURN (0);
4473:
4474: EXCEPTION
4475: WHEN ASSIGN_ERROR THEN
4476: err_text := 'INVUPD1B.assign_item_rev_data_update: bad return status from INVPUOPI.mtl_pr_parse_flex_name, please check mtl_interface_errors with transaction_id:'||tran_id;
4477: RETURN (1);
4478: WHEN LOGGING_ERROR THEN
4479: err_text := 'INVUPD1B.assign_item_rev_data_update: exception happen when calling INVPUOPI.mtl_log_interface_err'||err_text;
4480: RETURN (1);

Line 4479: err_text := 'INVUPD1B.assign_item_rev_data_update: exception happen when calling INVPUOPI.mtl_log_interface_err'||err_text;

4475: WHEN ASSIGN_ERROR THEN
4476: err_text := 'INVUPD1B.assign_item_rev_data_update: bad return status from INVPUOPI.mtl_pr_parse_flex_name, please check mtl_interface_errors with transaction_id:'||tran_id;
4477: RETURN (1);
4478: WHEN LOGGING_ERROR THEN
4479: err_text := 'INVUPD1B.assign_item_rev_data_update: exception happen when calling INVPUOPI.mtl_log_interface_err'||err_text;
4480: RETURN (1);
4481: WHEN OTHERS THEN
4482: err_text := substr('INVUPD1B.assign_item_rev_data_update: ' || SQLERRM, 1,2000);
4483: RETURN (1);

Line 4482: err_text := substr('INVUPD1B.assign_item_rev_data_update: ' || SQLERRM, 1,2000);

4478: WHEN LOGGING_ERROR THEN
4479: err_text := 'INVUPD1B.assign_item_rev_data_update: exception happen when calling INVPUOPI.mtl_log_interface_err'||err_text;
4480: RETURN (1);
4481: WHEN OTHERS THEN
4482: err_text := substr('INVUPD1B.assign_item_rev_data_update: ' || SQLERRM, 1,2000);
4483: RETURN (1);
4484: END assign_item_rev_data_update;
4485: --End Bug: 2808277 Supporting Item Revision Update
4486:

Line 4488: end INVUPD1B; -- }

4484: END assign_item_rev_data_update;
4485: --End Bug: 2808277 Supporting Item Revision Update
4486:
4487:
4488: end INVUPD1B; -- }