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.23.12010000.4 2008/11/26 00:59:33 akbharga 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.23.12010000.4 2008/11/26 00:59:33 akbharga ship $ */

1: PACKAGE BODY INVUPD1B AS -- {
2: /* $Header: INVUPD1B.pls 120.23.12010000.4 2008/11/26 00:59:33 akbharga 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 261: IF (INVUPD1B.exists_onhand_quantities(t_organization_id, t_inventory_item_id) <> 1

257: AND rec.COSTING_ENABLED_FLAG IS NULL
258: AND rec.INVENTORY_ASSET_FLAG IS NULL )
259: THEN -- {
260: -- if onhand quantities exist or transactions pending then
261: IF (INVUPD1B.exists_onhand_quantities(t_organization_id, t_inventory_item_id) <> 1
262: AND INVUPD1B.exists_onhand_child_qties(t_organization_id, t_inventory_item_id) <> 1 )
263: THEN -- {
264: -- copy msi data to msii record for ``missing'' attributes, also set process_ flag = 2
265: dumm_status := INVUPD1B.copy_msi_to_msii(rec.rowid,t_organization_id, t_inventory_item_id);

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

258: AND rec.INVENTORY_ASSET_FLAG IS NULL )
259: THEN -- {
260: -- if onhand quantities exist or transactions pending then
261: IF (INVUPD1B.exists_onhand_quantities(t_organization_id, t_inventory_item_id) <> 1
262: AND INVUPD1B.exists_onhand_child_qties(t_organization_id, t_inventory_item_id) <> 1 )
263: THEN -- {
264: -- copy msi data to msii record for ``missing'' attributes, also set process_ flag = 2
265: dumm_status := INVUPD1B.copy_msi_to_msii(rec.rowid,t_organization_id, t_inventory_item_id);
266: rtn_status := INVPULI4.assign_status_attributes(rec.inventory_item_id,rec.organization_id,err_text,xset_id,rec.rowid);

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

261: IF (INVUPD1B.exists_onhand_quantities(t_organization_id, t_inventory_item_id) <> 1
262: AND INVUPD1B.exists_onhand_child_qties(t_organization_id, t_inventory_item_id) <> 1 )
263: THEN -- {
264: -- copy msi data to msii record for ``missing'' attributes, also set process_ flag = 2
265: dumm_status := INVUPD1B.copy_msi_to_msii(rec.rowid,t_organization_id, t_inventory_item_id);
266: rtn_status := INVPULI4.assign_status_attributes(rec.inventory_item_id,rec.organization_id,err_text,xset_id,rec.rowid);
267: IF rtn_status = 0 THEN
268: status_code := 1;
269: ELSE

Line 275: upd_status := INVUPD1B.mtl_validate_attr_upd(

271: END IF;
272:
273: ELSE -- } {
274: -- Check for dependencies of attributes being updated
275: upd_status := INVUPD1B.mtl_validate_attr_upd(
276: rec.organization_id,
277: rec.inventory_item_id,
278: rec.rowid,
279: attr_err_mesg_name);

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

297: err_text);
298:
299: upd_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
300: ELSE
301: dumm_status := INVUPD1B.copy_msi_to_msii(rec.rowid,t_organization_id,t_inventory_item_id);
302: rtn_status := INVPULI4.assign_status_attributes(rec.inventory_item_id,rec.organization_id,err_text,xset_id,rec.rowid);
303: IF rtn_status = 0 THEN
304: status_code := 1;
305: ELSE

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

308: END IF; --}
309: END IF; -- }
310: ELSE -- no onhand qties exist and no transactions pending -- } {
311: -- copy msi data to msii record for ``missing'' attributes, also set process_flag = 2
312: dumm_status := INVUPD1B.copy_msi_to_msii(rec.rowid, t_organization_id, t_inventory_item_id);
313: rtn_status := INVPULI4.assign_status_attributes(rec.inventory_item_id,rec.organization_id,err_text,xset_id,rec.rowid);
314: IF rtn_status = 0 THEN
315: status_code := 1;
316: ELSE

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

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,
1058: all_org,
1059: prog_appid,
1060: prog_id,

Line 1087: if ( INVUPD1B.exists_in_msi(

1083: raise PARSE_ITEM_ERR;
1084: end if; -- }
1085: end if; -- }
1086:
1087: if ( INVUPD1B.exists_in_msi(
1088: rec.ROWID,
1089: t_organization_id,
1090: t_inventory_item_id,
1091: prog_appid,

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

1451: AND MP.master_organization_id = org_id;
1452:
1453: for rec in C_child_msi_records loop -- {
1454:
1455: status := INVUPD1B.exists_onhand_quantities(rec.INVENTORY_ITEM_ID, rec.ORGANIZATION_ID);
1456: exit when status = 1;
1457:
1458: end loop; -- }
1459:

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 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 4453: end INVUPD1B; -- }

4449: END assign_item_rev_data_update;
4450: --End Bug: 2808277 Supporting Item Revision Update
4451:
4452:
4453: end INVUPD1B; -- }