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

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

382: t_organization_id NUMBER;
383: t_inventory_item_id NUMBER;
384: l_attribute_name VARCHAR2(100);
385:
386: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
387:
388: tmp_xset_id NUMBER ; --5351611
389:
390: BEGIN

Line 393: INVPUTLI.info('INVUPD2B: Inside validate_item_update_master'|| '***orgid: ' || TO_CHAR(org_id));

389:
390: BEGIN
391:
392: IF l_inv_debug_level IN(101, 102) THEN
393: INVPUTLI.info('INVUPD2B: Inside validate_item_update_master'|| '***orgid: ' || TO_CHAR(org_id));
394: END IF;
395:
396: -- Set the attribute level for those attributes under master control.
397: -- Bug fix 3005880

Line 787: INVPUTLI.info(

783: -- No master record updates found
784: when OTHERS then
785: --bug #4251913: Included SQLCODE and SQLERRM to trap exception messages.
786: IF l_inv_debug_level IN(101, 102) THEN
787: INVPUTLI.info(
788: Substr(
789: 'When OTHERS exception raised in validate_item_update_master ' ||
790: SQLCODE ||
791: ' - ' ||

Line 823: INVPUTLI.info('INVUPD2 : Begin Check create auto child ' );

819: l_create_child BOOLEAN := FALSE;
820:
821: BEGIN
822:
823: INVPUTLI.info('INVUPD2 : Begin Check create auto child ' );
824: SELECT * INTO m_Item_rec
825: FROM mtl_system_items_interface
826: WHERE rowid = mast_rowid;
827:

Line 1409: INVPUTLI.info('INVUPD2B.check_create_child_records : Exception ' || SQLERRM );

1405: IF (c_master_attributes%ISOPEN) THEN
1406: CLOSE c_master_attributes;
1407: END IF;
1408: check_create_child := TRUE;
1409: INVPUTLI.info('INVUPD2B.check_create_child_records : Exception ' || SQLERRM );
1410:
1411: END Check_create_child_records;
1412:
1413: FUNCTION check_child_records

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

1451: org_id_temp NUMBER;
1452:
1453: l_created_child BOOLEAN := FALSE;
1454:
1455: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1456: l_check_create_child BOOLEAN; --Bug: 5437967
1457:
1458: BEGIN
1459:

Line 1461: INVPUTLI.info('INVUPD2B: Inside check_child_records'|| '***orgid: ' || TO_CHAR(org_id));

1457:
1458: BEGIN
1459:
1460: IF l_inv_debug_level IN(101, 102) THEN
1461: INVPUTLI.info('INVUPD2B: Inside check_child_records'|| '***orgid: ' || TO_CHAR(org_id));
1462: END IF;
1463:
1464: -- for each record in msi which is a child record of the item
1465:

Line 1533: INVPUTLI.info(

1529:
1530: when OTHERS then
1531: --bug #4251913 : Included SQLCODE and SQLERRM to trap exception messages.
1532: IF l_inv_debug_level IN(101, 102) THEN
1533: INVPUTLI.info(
1534: Substr('When OTHERS exception raised in check_child_records '||
1535: SQLCODE ||
1536: ' - ' ||
1537: SQLERRM,1,240));

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

1552: return INTEGER
1553: IS
1554: ret_code NUMBER;
1555:
1556: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1557: BEGIN
1558:
1559: IF l_inv_debug_level IN(101, 102) THEN
1560: INVPUTLI.info('INVUPD2B: Inside create_child_update_mast_attr'|| '***orgid: ' || TO_CHAR(org_id));

Line 1560: INVPUTLI.info('INVUPD2B: Inside create_child_update_mast_attr'|| '***orgid: ' || TO_CHAR(org_id));

1556: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1557: BEGIN
1558:
1559: IF l_inv_debug_level IN(101, 102) THEN
1560: INVPUTLI.info('INVUPD2B: Inside create_child_update_mast_attr'|| '***orgid: ' || TO_CHAR(org_id));
1561: END IF;
1562: -- Insert msi data onto MSII for child record.
1563: -- Need to verify these attributes.
1564: --

Line 2383: INVPUTLI.info(

2379:
2380: when OTHERS then
2381: --bug #4251913 : Included SQLCODE and SQLERRM to trap exception messages.
2382: IF l_inv_debug_level IN(101, 102) THEN
2383: INVPUTLI.info(
2384: Substr(
2385: 'when OTHERS exception raised in create_child_update_mast_attr ' ||
2386: SQLCODE ||
2387: ' - ' ||

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

2407: msii_master_temp mtl_system_items_interface%ROWTYPE;
2408:
2409: l_process_flag_2 NUMBER := 2;
2410:
2411: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
2412:
2413: BEGIN
2414:
2415: IF l_inv_debug_level IN(101, 102) THEN

Line 2416: INVPUTLI.info('INVUPD2B: Inside copy_master_to_child'|| '***orgid: ' || TO_CHAR(org_id));

2412:
2413: BEGIN
2414:
2415: IF l_inv_debug_level IN(101, 102) THEN
2416: INVPUTLI.info('INVUPD2B: Inside copy_master_to_child'|| '***orgid: ' || TO_CHAR(org_id));
2417: END IF;
2418:
2419: -- Get master record info into msii_master_temp
2420: --

Line 3404: INVPUTLI.info(

3400:
3401: when OTHERS then
3402: --bug #4251913 : Included SQLCODE and SQLERRM to trap exception messages.
3403: IF l_inv_debug_level IN(101, 102) THEN
3404: INVPUTLI.info(
3405: Substr(
3406: 'when OTHERS exception raised in copy_master_to_child ' ||
3407: SQLCODE ||
3408: ' - ' ||

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

3443: where MP.organization_id <> MP.master_organization_id);
3444:
3445: ret_code_update NUMBER := 1;
3446:
3447: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
3448:
3449: BEGIN -- {
3450:
3451: IF l_inv_debug_level IN(101, 102) THEN

Line 3452: INVPUTLI.info('INVUPD2B: Inside validate_item_update_child'|| '***orgid: ' || TO_CHAR(org_id));

3448:
3449: BEGIN -- {
3450:
3451: IF l_inv_debug_level IN(101, 102) THEN
3452: INVPUTLI.info('INVUPD2B: Inside validate_item_update_child'|| '***orgid: ' || TO_CHAR(org_id));
3453: END IF;
3454:
3455: for crec in C_msii_child_records loop -- {
3456: -- child record validation here

Line 3480: INVPUTLI.info(

3476: -- No child record updates found
3477: when OTHERS then
3478: --bug #4251913 : Included SQLCODE and SQLERRM to trap exception messages.
3479: IF l_inv_debug_level IN(101, 102) THEN
3480: INVPUTLI.info(
3481: Substr(
3482: 'when OTHERS exception raised in validate_item_update_child ' ||
3483: SQLCODE ||
3484: ' - ' ||

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

3573: stockable NUMBER; -- Bug 6501149
3574: lot_control NUMBER; -- Bug 6501149
3575: serial_control NUMBER; -- Bug 6501149
3576:
3577: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
3578: l_item_has_lot_comp NUMBER;
3579: BEGIN
3580:
3581: IF l_inv_debug_level IN(101, 102) THEN

Line 3582: INVPUTLI.info('INVUPD2B: Inside update_validations'|| '***orgid: ' || TO_CHAR(org_id));

3578: l_item_has_lot_comp NUMBER;
3579: BEGIN
3580:
3581: IF l_inv_debug_level IN(101, 102) THEN
3582: INVPUTLI.info('INVUPD2B: Inside update_validations'|| '***orgid: ' || TO_CHAR(org_id));
3583: END IF;
3584: -- initialize status = 0
3585: status := 0;
3586:

Line 3854: INVPUTLI.info('INVUPD2B: Inside update_validations: After Table Quries');

3850: X_serial_control => serial_control -- Bug 6501149
3851: );
3852:
3853: IF l_inv_debug_level IN(101, 102) THEN
3854: INVPUTLI.info('INVUPD2B: Inside update_validations: After Table Quries');
3855: END IF;
3856: -- validate LOT_CONTROL_CODE
3857: -- cannot update if there is onhand or transactions pending or lots exist
3858: if (msi_temp.lot_control_code <> msii_temp.lot_control_code) AND (onhand_lot = 1) then

Line 5046: INVPUTLI.info('INVUPD2B: Inside update_validations: 11.5.10 validations started');

5042: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5043: end if;
5044:
5045: IF l_inv_debug_level IN(101, 102) THEN
5046: INVPUTLI.info('INVUPD2B: Inside update_validations: 11.5.10 validations started');
5047: END IF;
5048: -- Added for 11.5.10
5049: -- validate OUTSIDE_OPERATION_FLAG, EAM_ITEM_TYPE, MTL_TRANSACTIONS_ENABLED_FLAG, STOCK_ENABLED_FLAG and INVENTORY_ASSET_FLAG
5050: -- validate Not updateable fields

Line 5087: INVPUTLI.info('INVUPD2B: Inside update_validations: VMI validations failed');

5083: l_column_name := 'INVENTORY_ASSET_FLAG';
5084: end if;
5085: if (l_column_name IS NOT NULL) then
5086: IF l_inv_debug_level IN(101, 102) THEN
5087: INVPUTLI.info('INVUPD2B: Inside update_validations: VMI validations failed');
5088: END IF;
5089:
5090: dumm_status := INVPUOPI.mtl_log_interface_err(
5091: org_id,

Line 5106: INVPUTLI.info('INVUPD2B: Inside update_validations: 11.5.10 validations Ended');

5102: err_text);
5103: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5104: end if;
5105: IF l_inv_debug_level IN(101, 102) THEN
5106: INVPUTLI.info('INVUPD2B: Inside update_validations: 11.5.10 validations Ended');
5107: END IF;
5108:
5109: /* Start Bug 3713912 */
5110: -- validate TRACKING_QUANTITY_IND

Line 5114: INVPUTLI.info('INVUPD2B: Inside update_validations: TRACKING_QUANTITY_IND onhand validations failed');

5110: -- validate TRACKING_QUANTITY_IND
5111: -- cannot update if there is onhand or transactions pending
5112: if (msi_temp.TRACKING_QUANTITY_IND <> msii_temp.TRACKING_QUANTITY_IND) AND (onhand_tracking_qty_ind = 1) then
5113: IF l_inv_debug_level IN(101, 102) THEN
5114: INVPUTLI.info('INVUPD2B: Inside update_validations: TRACKING_QUANTITY_IND onhand validations failed');
5115: END IF;
5116: dumm_status := INVPUOPI.mtl_log_interface_err(
5117: org_id,
5118: user_id,

Line 5134: INVPUTLI.info('INVUPD2B: Inside update_validations: TRACKING_QUANTITY_IND pending validations failed');

5130: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5131:
5132: elsif (msi_temp.TRACKING_QUANTITY_IND <> msii_temp.TRACKING_QUANTITY_IND) AND (pendadj_tracking_qty_ind = 1) then
5133: IF l_inv_debug_level IN(101, 102) THEN
5134: INVPUTLI.info('INVUPD2B: Inside update_validations: TRACKING_QUANTITY_IND pending validations failed');
5135: END IF;
5136: dumm_status := INVPUOPI.mtl_log_interface_err(
5137: org_id,
5138: user_id,

Line 5158: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_UOM_CODE onhand validations failed');

5154: -- validate SECONDARY_UOM_CODE
5155: -- cannot update if there is onhand or transactions pending
5156: if (msi_temp.SECONDARY_UOM_CODE <> msii_temp.SECONDARY_UOM_CODE) AND (onhand_secondary_uom = 1) then
5157: IF l_inv_debug_level IN(101, 102) THEN
5158: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_UOM_CODE onhand validations failed');
5159: END IF;
5160: dumm_status := INVPUOPI.mtl_log_interface_err(
5161: org_id,
5162: user_id,

Line 5178: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_UOM_CODE pending validations failed');

5174: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5175:
5176: elsif (msi_temp.SECONDARY_UOM_CODE <> msii_temp.SECONDARY_UOM_CODE) AND (pendadj_secondary_uom = 1) then
5177: IF l_inv_debug_level IN(101, 102) THEN
5178: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_UOM_CODE pending validations failed');
5179: END IF;
5180: dumm_status := INVPUOPI.mtl_log_interface_err(
5181: org_id,
5182: user_id,

Line 5202: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_DEFAULT_IND onhand validations failed');

5198: -- validate SECONDARY_DEFAULT_IND
5199: -- cannot update if there is onhand or transactions pending
5200: if (msi_temp.SECONDARY_DEFAULT_IND <> msii_temp.SECONDARY_DEFAULT_IND) AND (onhand_sec_default_ind = 1) then
5201: IF l_inv_debug_level IN(101, 102) THEN
5202: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_DEFAULT_IND onhand validations failed');
5203: END IF;
5204: dumm_status := INVPUOPI.mtl_log_interface_err(
5205: org_id,
5206: user_id,

Line 5222: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_DEFAULT_IND pending validations failed');

5218: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5219:
5220: elsif (msi_temp.SECONDARY_DEFAULT_IND <> msii_temp.SECONDARY_DEFAULT_IND) AND (pendadj_sec_default_ind = 1) then
5221: IF l_inv_debug_level IN(101, 102) THEN
5222: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_DEFAULT_IND pending validations failed');
5223: END IF;
5224: dumm_status := INVPUOPI.mtl_log_interface_err(
5225: org_id,
5226: user_id,

Line 5246: INVPUTLI.info('INVUPD2B: Inside update_validations: PRIMARY_UOM_CODE onhand validations failed');

5242: -- validate PRIMARY_UOM_CODE
5243: -- cannot update if there is onhand or transactions pending
5244: if (msi_temp.PRIMARY_UOM_CODE <> msii_temp.PRIMARY_UOM_CODE) AND (onhand_primary_uom = 1) then
5245: IF l_inv_debug_level IN(101, 102) THEN
5246: INVPUTLI.info('INVUPD2B: Inside update_validations: PRIMARY_UOM_CODE onhand validations failed');
5247: END IF;
5248: dumm_status := INVPUOPI.mtl_log_interface_err(
5249: org_id,
5250: user_id,

Line 5266: INVPUTLI.info('INVUPD2B: Inside update_validations: PRIMARY_UOM_CODE pending validations failed');

5262: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5263:
5264: elsif (msi_temp.PRIMARY_UOM_CODE <> msii_temp.PRIMARY_UOM_CODE) AND (pendadj_primary_uom = 1) then
5265: IF l_inv_debug_level IN(101, 102) THEN
5266: INVPUTLI.info('INVUPD2B: Inside update_validations: PRIMARY_UOM_CODE pending validations failed');
5267: END IF;
5268: dumm_status := INVPUOPI.mtl_log_interface_err(
5269: org_id,
5270: user_id,

Line 5290: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_HIGH onhand validations failed');

5286: -- validate DUAL_UOM_DEVIATION_HIGH
5287: -- cannot update if there is onhand or transactions pending
5288: if (msi_temp.DUAL_UOM_DEVIATION_HIGH <> msii_temp.DUAL_UOM_DEVIATION_HIGH) AND (onhand_deviation_high = 1) then
5289: IF l_inv_debug_level IN(101, 102) THEN
5290: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_HIGH onhand validations failed');
5291: END IF;
5292: dumm_status := INVPUOPI.mtl_log_interface_err(
5293: org_id,
5294: user_id,

Line 5310: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_HIGH pending validations failed');

5306: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5307:
5308: elsif (msi_temp.DUAL_UOM_DEVIATION_HIGH <> msii_temp.DUAL_UOM_DEVIATION_HIGH) AND (pendadj_deviation_high = 1) then
5309: IF l_inv_debug_level IN(101, 102) THEN
5310: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_HIGH pending validations failed');
5311: END IF;
5312: dumm_status := INVPUOPI.mtl_log_interface_err(
5313: org_id,
5314: user_id,

Line 5334: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_LOW onhand validations failed');

5330: -- validate DUAL_UOM_DEVIATION_LOW
5331: -- cannot update if there is onhand or transactions pending
5332: if (msi_temp.DUAL_UOM_DEVIATION_LOW <> msii_temp.DUAL_UOM_DEVIATION_LOW) AND (onhand_deviation_low = 1) then
5333: IF l_inv_debug_level IN(101, 102) THEN
5334: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_LOW onhand validations failed');
5335: END IF;
5336: dumm_status := INVPUOPI.mtl_log_interface_err(
5337: org_id,
5338: user_id,

Line 5354: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_LOW pending validations failed');

5350: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5351:
5352: elsif (msi_temp.DUAL_UOM_DEVIATION_LOW <> msii_temp.DUAL_UOM_DEVIATION_LOW) AND (pendadj_deviation_low = 1) then
5353: IF l_inv_debug_level IN(101, 102) THEN
5354: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_LOW pending validations failed');
5355: END IF;
5356: dumm_status := INVPUOPI.mtl_log_interface_err(
5357: org_id,
5358: user_id,

Line 5383: INVPUTLI.info(

5379:
5380: when OTHERS then
5381: --bug #4251913 : Included SQLCODE and SQLERRM to trap exception messages.
5382: IF l_inv_debug_level IN(101, 102) THEN
5383: INVPUTLI.info(
5384: Substr(
5385: 'when OTHERS exception raised in update_validations ' ||
5386: SQLCODE ||
5387: ' - ' ||

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

5549: l_return_status VARCHAR2(1);
5550: l_msg_text VARCHAR2(2000);
5551: l_cst_item_type NUMBER;
5552:
5553: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
5554: l_is_gdsn_batch NUMBER;
5555: org_name VARCHAR2(1000);
5556: error_msg VARCHAR2(1000);
5557: ext_flag NUMBER := 0;

Line 5583: INVPUTLI.info('INVUPD2B.inproit_process_item_update : begin');

5579: ,P_Set_id => xset_id);
5580: -- End 3637854 : Pending ECO check and sync lifecycles
5581:
5582: IF l_inv_debug_level IN(101, 102) THEN
5583: INVPUTLI.info('INVUPD2B.inproit_process_item_update : begin');
5584: END IF;
5585:
5586: -- Identify the current session language as Base ('B') or Installed ('I')
5587: --

Line 5758: INVPUTLI.info('INVUPD2B: inserting the item category assignments for default category sets ');

5754: (NVL(INV_EGO_REVISION_VALIDATE.Get_Process_Control(),'X')<> 'PLM_UI:Y') ) or
5755: (rec.contract_type <> rec.CONTRACT_ITEM_TYPE_CODE) then
5756:
5757: IF l_inv_debug_level IN(101, 102) THEN
5758: INVPUTLI.info('INVUPD2B: inserting the item category assignments for default category sets ');
5759: END IF;
5760:
5761: -- Creating item category assignments for the default category sets
5762: -- for the functional areas having the defining attribute enabled.

Line 6523: INVPUTLI.info(

6519:
6520: when OTHERS then
6521: --bug #4251913 : Included SQLCODE and SQLERRM to trap exception messages.
6522: IF l_inv_debug_level IN(101, 102) THEN
6523: INVPUTLI.info(
6524: Substr(
6525: 'when OTHERS exception raised in inproit_process_item_update' ||
6526: ' - Cursor C_lock_msi_records ' ||
6527: SQLCODE ||

Line 6542: INVPUTLI.info('INVUPD2B: Update: III' || item_csr.inventory_item_id ||

6538: --6417028 propagate item number update to all org hierarchies
6539: FOR item_csr IN c_item_number_updated
6540: LOOP
6541: IF l_inv_debug_level IN(101, 102) THEN
6542: INVPUTLI.info('INVUPD2B: Update: III' || item_csr.inventory_item_id ||
6543: 'segment1' || item_csr.segment1);
6544: END IF;
6545:
6546: UPDATE mtl_system_items_b

Line 6574: INVPUTLI.info('Ego Intf Table has rows '||cr.language || ' ' ||cr.column_value);

6570:
6571: -- Start fix for bug 7017691 Issue #4 Move out of the C_msii_processed_records
6572: -- loop
6573: FOR cr IN c_ego_intf_rows LOOP
6574: INVPUTLI.info('Ego Intf Table has rows '||cr.language || ' ' ||cr.column_value);
6575: UPDATE MTL_SYSTEM_ITEMS_TL
6576: SET DESCRIPTION = NVL(cr.column_value, DESCRIPTION),
6577: LAST_UPDATE_DATE = l_sysdate,
6578: LAST_UPDATED_BY = user_id,

Line 6625: --INVPUTLI.info('INVPPROC: Finished updating record in MSI with MSII record'|| xset_id);

6621: user_id);
6622: END LOOP;
6623: -- End of Bug 5190184
6624:
6625: --INVPUTLI.info('INVPPROC: Finished updating record in MSI with MSII record'|| xset_id);
6626:
6627: --2808277 : Start Revision Update support
6628:
6629:

Line 6725: INVPUTLI.info(

6721: err_text);
6722: WHEN OTHERS THEN
6723: --bug #4251913: Included SQLCODE and SQLERRM to trap exception messages.
6724: IF l_inv_debug_level IN(101, 102) THEN
6725: INVPUTLI.info(
6726: Substr(
6727: 'when OTHERS exception raised in inproit_process_item_update ' ||
6728: '- Cursor c_lock_rev_record ' ||
6729: SQLCODE ||

Line 6738: --INVPUTLI.info('INVPPROC: Finished updating record in MSI with MSII record'|| xset_id);

6734: END;
6735: END LOOP;
6736: --2808277 : End Revision Update support
6737:
6738: --INVPUTLI.info('INVPPROC: Finished updating record in MSI with MSII record'|| xset_id);
6739:
6740: -- set process_flags to 7
6741:
6742: table_name := 'MTL_SYSTEM_ITEMS_INTERFACE';

Line 6777: INVPUTLI.info(

6773: when OTHERS then
6774: --dbms_output.put_line(sqlerrm);
6775: --bug #4251913 : Included SQLCODE and SQLERRM to trap exception messages.
6776: IF l_inv_debug_level IN(101, 102) THEN
6777: INVPUTLI.info(
6778: Substr(
6779: 'when OTHERS exception raised in inproit_process_item_update ' ||
6780: SQLCODE ||
6781: ' - ' ||

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

6798: return INTEGER
6799: IS
6800: l_process_flag_3 NUMBER := 3;
6801:
6802: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
6803: BEGIN
6804:
6805: IF l_inv_debug_level IN(101, 102) THEN
6806: INVPUTLI.info('INVUPD2B: Inside set_process_flag3');

Line 6806: INVPUTLI.info('INVUPD2B: Inside set_process_flag3');

6802: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
6803: BEGIN
6804:
6805: IF l_inv_debug_level IN(101, 102) THEN
6806: INVPUTLI.info('INVUPD2B: Inside set_process_flag3');
6807: END IF;
6808: update MTL_SYSTEM_ITEMS_INTERFACE
6809: set PROCESS_FLAG = l_process_flag_3,
6810: request_id = reqst_id,

Line 6822: INVPUTLI.info(

6818:
6819: when OTHERS then
6820: --bug #4251913: Included SQLCODE and SQLERRM to trap exception messages.
6821: IF l_inv_debug_level IN(101, 102) THEN
6822: INVPUTLI.info(
6823: Substr(
6824: 'when OTHERS exception raised in set_process_flag3 ' ||
6825: SQLCODE ||
6826: ' - ' ||

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

6838: , error_text OUT NOCOPY VARCHAR2
6839: )
6840: return INTEGER
6841: IS
6842: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
6843: BEGIN
6844:
6845: IF l_inv_debug_level IN(101, 102) THEN
6846: INVPUTLI.info('INVUPD2B: inside get_message');

Line 6846: INVPUTLI.info('INVUPD2B: inside get_message');

6842: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
6843: BEGIN
6844:
6845: IF l_inv_debug_level IN(101, 102) THEN
6846: INVPUTLI.info('INVUPD2B: inside get_message');
6847: END IF;
6848: FND_MESSAGE.SET_NAME('INV', SUBSTRB(msg_name, 1,30));
6849: error_text := FND_MESSAGE.GET;
6850: return (0);

Line 6856: INVPUTLI.info( SUBSTRB('get_message: ' || SQLERRM, 1, 240) );

6852: EXCEPTION
6853:
6854: when OTHERS then
6855: IF l_inv_debug_level IN(101, 102) THEN
6856: INVPUTLI.info( SUBSTRB('get_message: ' || SQLERRM, 1, 240) );
6857: END IF;
6858: return (1);
6859:
6860: END get_message;