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 388: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452

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

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

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

Line 791: INVPUTLI.info(

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

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

826: l_create_child BOOLEAN := FALSE;
827:
828: BEGIN
829:
830: INVPUTLI.info('INVUPD2 : Begin Check create auto child ' );
831: SELECT * INTO m_Item_rec
832: FROM mtl_system_items_interface
833: WHERE rowid = mast_rowid;
834:

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

1436: CLOSE c_master_attributes;
1437: END IF;
1438: */
1439: check_create_child := TRUE;
1440: INVPUTLI.info('INVUPD2B.check_create_child_records : Exception ' || SQLERRM );
1441:
1442: END Check_create_child_records;
1443:
1444: FUNCTION check_child_records

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

1482: org_id_temp NUMBER;
1483:
1484: l_created_child BOOLEAN := FALSE;
1485:
1486: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1487: l_check_create_child BOOLEAN; --Bug: 5437967
1488:
1489: BEGIN
1490:

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

1488:
1489: BEGIN
1490:
1491: IF l_inv_debug_level IN(101, 102) THEN
1492: INVPUTLI.info('INVUPD2B: Inside check_child_records'|| '***orgid: ' || TO_CHAR(org_id));
1493: END IF;
1494:
1495: -- Bug 10404086 : Start
1496: Check_create_child_records(mast_rowid => master_row_id,

Line 1579: INVPUTLI.info(

1575:
1576: when OTHERS then
1577: --bug #4251913 : Included SQLCODE and SQLERRM to trap exception messages.
1578: IF l_inv_debug_level IN(101, 102) THEN
1579: INVPUTLI.info(
1580: Substr('When OTHERS exception raised in check_child_records '||
1581: SQLCODE ||
1582: ' - ' ||
1583: SQLERRM,1,240));

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

1598: return INTEGER
1599: IS
1600: ret_code NUMBER;
1601:
1602: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1603: BEGIN
1604:
1605: IF l_inv_debug_level IN(101, 102) THEN
1606: INVPUTLI.info('INVUPD2B: Inside create_child_update_mast_attr'|| '***orgid: ' || TO_CHAR(org_id));

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

1602: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
1603: BEGIN
1604:
1605: IF l_inv_debug_level IN(101, 102) THEN
1606: INVPUTLI.info('INVUPD2B: Inside create_child_update_mast_attr'|| '***orgid: ' || TO_CHAR(org_id));
1607: END IF;
1608: -- Insert msi data onto MSII for child record.
1609: -- Need to verify these attributes.
1610: --

Line 2431: INVPUTLI.info(

2427:
2428: when OTHERS then
2429: --bug #4251913 : Included SQLCODE and SQLERRM to trap exception messages.
2430: IF l_inv_debug_level IN(101, 102) THEN
2431: INVPUTLI.info(
2432: Substr(
2433: 'when OTHERS exception raised in create_child_update_mast_attr ' ||
2434: SQLCODE ||
2435: ' - ' ||

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

2455: msii_master_temp mtl_system_items_interface%ROWTYPE;
2456:
2457: l_process_flag_2 NUMBER := 2;
2458:
2459: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
2460:
2461: BEGIN
2462:
2463: IF l_inv_debug_level IN(101, 102) THEN

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

2460:
2461: BEGIN
2462:
2463: IF l_inv_debug_level IN(101, 102) THEN
2464: INVPUTLI.info('INVUPD2B: Inside copy_master_to_child'|| '***orgid: ' || TO_CHAR(org_id));
2465: END IF;
2466:
2467: -- Get master record info into msii_master_temp
2468: --

Line 3457: INVPUTLI.info(

3453:
3454: when OTHERS then
3455: --bug #4251913 : Included SQLCODE and SQLERRM to trap exception messages.
3456: IF l_inv_debug_level IN(101, 102) THEN
3457: INVPUTLI.info(
3458: Substr(
3459: 'when OTHERS exception raised in copy_master_to_child ' ||
3460: SQLCODE ||
3461: ' - ' ||

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

3496: where MP.organization_id <> MP.master_organization_id);
3497:
3498: ret_code_update NUMBER := 1;
3499:
3500: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
3501:
3502: BEGIN -- {
3503:
3504: IF l_inv_debug_level IN(101, 102) THEN

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

3501:
3502: BEGIN -- {
3503:
3504: IF l_inv_debug_level IN(101, 102) THEN
3505: INVPUTLI.info('INVUPD2B: Inside validate_item_update_child'|| '***orgid: ' || TO_CHAR(org_id));
3506: END IF;
3507:
3508: for crec in C_msii_child_records loop -- {
3509: -- child record validation here

Line 3533: INVPUTLI.info(

3529: -- No child record updates found
3530: when OTHERS then
3531: --bug #4251913 : Included SQLCODE and SQLERRM to trap exception messages.
3532: IF l_inv_debug_level IN(101, 102) THEN
3533: INVPUTLI.info(
3534: Substr(
3535: 'when OTHERS exception raised in validate_item_update_child ' ||
3536: SQLCODE ||
3537: ' - ' ||

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

3628: serial_control NUMBER; -- Bug 6501149
3629: open_shipment_lot NUMBER; -- Bug 9043779
3630: open_shipment_serial NUMBER; -- Bug 9043779
3631:
3632: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
3633: l_item_has_lot_comp NUMBER;
3634: costing_level NUMBER;
3635: invetory_asset_flag_level NUMBER;
3636: BEGIN

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

3635: invetory_asset_flag_level NUMBER;
3636: BEGIN
3637:
3638: IF l_inv_debug_level IN(101, 102) THEN
3639: INVPUTLI.info('INVUPD2B: Inside update_validations'|| '***orgid: ' || TO_CHAR(org_id));
3640: END IF;
3641: -- initialize status = 0
3642: status := 0;
3643:

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

3959: X_open_shipment_serial => open_shipment_serial -- Bug 9043779
3960: );
3961:
3962: IF l_inv_debug_level IN(101, 102) THEN
3963: INVPUTLI.info('INVUPD2B: Inside update_validations: After Table Quries');
3964: END IF;
3965: -- validate LOT_CONTROL_CODE
3966: -- cannot update if there is onhand or transactions pending or lots exist
3967: if (msi_temp.lot_control_code <> msii_temp.lot_control_code) AND (onhand_lot = 1) then

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

5245: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5246: end if;
5247:
5248: IF l_inv_debug_level IN(101, 102) THEN
5249: INVPUTLI.info('INVUPD2B: Inside update_validations: 11.5.10 validations started');
5250: END IF;
5251: -- Added for 11.5.10
5252: -- validate OUTSIDE_OPERATION_FLAG, EAM_ITEM_TYPE, MTL_TRANSACTIONS_ENABLED_FLAG, STOCK_ENABLED_FLAG and INVENTORY_ASSET_FLAG
5253: -- validate Not updateable fields

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

5307: l_column_name := 'INVENTORY_ASSET_FLAG';
5308: end if;
5309: if (l_column_name IS NOT NULL) then
5310: IF l_inv_debug_level IN(101, 102) THEN
5311: INVPUTLI.info('INVUPD2B: Inside update_validations: VMI validations failed');
5312: END IF;
5313:
5314: dumm_status := INVPUOPI.mtl_log_interface_err(
5315: org_id,

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

5326: err_text);
5327: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5328: end if;
5329: IF l_inv_debug_level IN(101, 102) THEN
5330: INVPUTLI.info('INVUPD2B: Inside update_validations: 11.5.10 validations Ended');
5331: END IF;
5332:
5333: /* Start Bug 3713912 */
5334: -- validate TRACKING_QUANTITY_IND

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

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

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

5354: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5355:
5356: elsif (msi_temp.TRACKING_QUANTITY_IND <> msii_temp.TRACKING_QUANTITY_IND) AND (pendadj_tracking_qty_ind = 1) then
5357: IF l_inv_debug_level IN(101, 102) THEN
5358: INVPUTLI.info('INVUPD2B: Inside update_validations: TRACKING_QUANTITY_IND pending validations failed');
5359: END IF;
5360: dumm_status := INVPUOPI.mtl_log_interface_err(
5361: org_id,
5362: user_id,

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

5378: -- validate SECONDARY_UOM_CODE
5379: -- cannot update if there is onhand or transactions pending
5380: if (msi_temp.SECONDARY_UOM_CODE <> msii_temp.SECONDARY_UOM_CODE) AND (onhand_secondary_uom = 1) then
5381: IF l_inv_debug_level IN(101, 102) THEN
5382: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_UOM_CODE onhand validations failed');
5383: END IF;
5384: dumm_status := INVPUOPI.mtl_log_interface_err(
5385: org_id,
5386: user_id,

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

5398: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5399:
5400: elsif (msi_temp.SECONDARY_UOM_CODE <> msii_temp.SECONDARY_UOM_CODE) AND (pendadj_secondary_uom = 1) then
5401: IF l_inv_debug_level IN(101, 102) THEN
5402: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_UOM_CODE pending validations failed');
5403: END IF;
5404: dumm_status := INVPUOPI.mtl_log_interface_err(
5405: org_id,
5406: user_id,

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

5422: -- validate SECONDARY_DEFAULT_IND
5423: -- cannot update if there is onhand or transactions pending
5424: if (msi_temp.SECONDARY_DEFAULT_IND <> msii_temp.SECONDARY_DEFAULT_IND) AND (onhand_sec_default_ind = 1) then
5425: IF l_inv_debug_level IN(101, 102) THEN
5426: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_DEFAULT_IND onhand validations failed');
5427: END IF;
5428: dumm_status := INVPUOPI.mtl_log_interface_err(
5429: org_id,
5430: user_id,

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

5442: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5443:
5444: elsif (msi_temp.SECONDARY_DEFAULT_IND <> msii_temp.SECONDARY_DEFAULT_IND) AND (pendadj_sec_default_ind = 1) then
5445: IF l_inv_debug_level IN(101, 102) THEN
5446: INVPUTLI.info('INVUPD2B: Inside update_validations: SECONDARY_DEFAULT_IND pending validations failed');
5447: END IF;
5448: dumm_status := INVPUOPI.mtl_log_interface_err(
5449: org_id,
5450: user_id,

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

5466: -- validate PRIMARY_UOM_CODE
5467: -- cannot update if there is onhand or transactions pending
5468: if (msi_temp.PRIMARY_UOM_CODE <> msii_temp.PRIMARY_UOM_CODE) AND (onhand_primary_uom = 1) then
5469: IF l_inv_debug_level IN(101, 102) THEN
5470: INVPUTLI.info('INVUPD2B: Inside update_validations: PRIMARY_UOM_CODE onhand validations failed');
5471: END IF;
5472: dumm_status := INVPUOPI.mtl_log_interface_err(
5473: org_id,
5474: user_id,

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

5486: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5487:
5488: elsif (msi_temp.PRIMARY_UOM_CODE <> msii_temp.PRIMARY_UOM_CODE) AND (pendadj_primary_uom = 1) then
5489: IF l_inv_debug_level IN(101, 102) THEN
5490: INVPUTLI.info('INVUPD2B: Inside update_validations: PRIMARY_UOM_CODE pending validations failed');
5491: END IF;
5492: dumm_status := INVPUOPI.mtl_log_interface_err(
5493: org_id,
5494: user_id,

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

5510: -- validate DUAL_UOM_DEVIATION_HIGH
5511: -- cannot update if there is onhand or transactions pending
5512: if (msi_temp.DUAL_UOM_DEVIATION_HIGH <> msii_temp.DUAL_UOM_DEVIATION_HIGH) AND (onhand_deviation_high = 1) then
5513: IF l_inv_debug_level IN(101, 102) THEN
5514: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_HIGH onhand validations failed');
5515: END IF;
5516: dumm_status := INVPUOPI.mtl_log_interface_err(
5517: org_id,
5518: user_id,

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

5530: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5531:
5532: elsif (msi_temp.DUAL_UOM_DEVIATION_HIGH <> msii_temp.DUAL_UOM_DEVIATION_HIGH) AND (pendadj_deviation_high = 1) then
5533: IF l_inv_debug_level IN(101, 102) THEN
5534: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_HIGH pending validations failed');
5535: END IF;
5536: dumm_status := INVPUOPI.mtl_log_interface_err(
5537: org_id,
5538: user_id,

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

5554: -- validate DUAL_UOM_DEVIATION_LOW
5555: -- cannot update if there is onhand or transactions pending
5556: if (msi_temp.DUAL_UOM_DEVIATION_LOW <> msii_temp.DUAL_UOM_DEVIATION_LOW) AND (onhand_deviation_low = 1) then
5557: IF l_inv_debug_level IN(101, 102) THEN
5558: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_LOW onhand validations failed');
5559: END IF;
5560: dumm_status := INVPUOPI.mtl_log_interface_err(
5561: org_id,
5562: user_id,

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

5574: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5575:
5576: elsif (msi_temp.DUAL_UOM_DEVIATION_LOW <> msii_temp.DUAL_UOM_DEVIATION_LOW) AND (pendadj_deviation_low = 1) then
5577: IF l_inv_debug_level IN(101, 102) THEN
5578: INVPUTLI.info('INVUPD2B: Inside update_validations: DUAL_UOM_DEVIATION_LOW pending validations failed');
5579: END IF;
5580: dumm_status := INVPUOPI.mtl_log_interface_err(
5581: org_id,
5582: user_id,

Line 5628: INVPUTLI.info(

5624:
5625: when OTHERS then
5626: --bug #4251913 : Included SQLCODE and SQLERRM to trap exception messages.
5627: IF l_inv_debug_level IN(101, 102) THEN
5628: INVPUTLI.info(
5629: Substr(
5630: 'when OTHERS exception raised in update_validations ' ||
5631: SQLCODE ||
5632: ' - ' ||

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

5822: l_return_status VARCHAR2(1);
5823: l_msg_text VARCHAR2(2000);
5824: l_cst_item_type NUMBER;
5825:
5826: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
5827: l_is_gdsn_batch NUMBER;
5828: org_name VARCHAR2(1000);
5829: error_msg VARCHAR2(1000);
5830: ext_flag NUMBER := 0;

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

5857: ,P_Set_id => xset_id);
5858: -- End 3637854 : Pending ECO check and sync lifecycles
5859:
5860: IF l_inv_debug_level IN(101, 102) THEN
5861: INVPUTLI.info('INVUPD2B.inproit_process_item_update : begin');
5862: END IF;
5863:
5864: -- Identify the current session language as Base ('B') or Installed ('I')
5865: --

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

6068: (NVL(INV_EGO_REVISION_VALIDATE.Get_Process_Control(),'X')<> 'PLM_UI:Y') ) or
6069: (rec.contract_type <> rec.CONTRACT_ITEM_TYPE_CODE) then
6070:
6071: IF l_inv_debug_level IN(101, 102) THEN
6072: INVPUTLI.info('INVUPD2B: inserting the item category assignments for default category sets ');
6073: END IF;
6074:
6075: -- Creating item category assignments for the default category sets
6076: -- for the functional areas having the defining attribute enabled.

Line 6957: INVPUTLI.info(

6953:
6954: when OTHERS then
6955: --bug #4251913 : Included SQLCODE and SQLERRM to trap exception messages.
6956: IF l_inv_debug_level IN(101, 102) THEN
6957: INVPUTLI.info(
6958: Substr(
6959: 'when OTHERS exception raised in inproit_process_item_update' ||
6960: ' - Cursor C_lock_msi_records ' ||
6961: SQLCODE ||

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

6972: --6417028 propagate item number update to all org hierarchies
6973: FOR item_csr IN c_item_number_updated
6974: LOOP
6975: IF l_inv_debug_level IN(101, 102) THEN
6976: INVPUTLI.info('INVUPD2B: Update: III' || item_csr.inventory_item_id ||
6977: 'segment1' || item_csr.segment1);
6978: END IF;
6979:
6980: UPDATE mtl_system_items_b

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

7004:
7005: -- Start fix for bug 7017691 Issue #4 Move out of the C_msii_processed_records
7006: -- loop
7007: FOR cr IN c_ego_intf_rows LOOP
7008: INVPUTLI.info('Ego Intf Table has rows '||cr.language || ' ' ||cr.column_value);
7009: UPDATE MTL_SYSTEM_ITEMS_TL
7010: SET DESCRIPTION = NVL(cr.column_value, DESCRIPTION),
7011: LAST_UPDATE_DATE = l_sysdate,
7012: LAST_UPDATED_BY = user_id,

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

7055: user_id);
7056: END LOOP;
7057: -- End of Bug 5190184
7058:
7059: --INVPUTLI.info('INVPPROC: Finished updating record in MSI with MSII record'|| xset_id);
7060:
7061: --2808277 : Start Revision Update support
7062:
7063:

Line 7200: INVPUTLI.info(

7196: err_text);
7197: WHEN OTHERS THEN
7198: --bug #4251913: Included SQLCODE and SQLERRM to trap exception messages.
7199: IF l_inv_debug_level IN(101, 102) THEN
7200: INVPUTLI.info(
7201: Substr(
7202: 'when OTHERS exception raised in inproit_process_item_update ' ||
7203: '- Cursor c_lock_rev_record ' ||
7204: SQLCODE ||

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

7209: END;
7210: END LOOP;
7211: --2808277 : End Revision Update support
7212:
7213: --INVPUTLI.info('INVPPROC: Finished updating record in MSI with MSII record'|| xset_id);
7214:
7215: -- set process_flags to 7
7216:
7217: table_name := 'MTL_SYSTEM_ITEMS_INTERFACE';

Line 7252: INVPUTLI.info(

7248: when OTHERS then
7249: --dbms_output.put_line(sqlerrm);
7250: --bug #4251913 : Included SQLCODE and SQLERRM to trap exception messages.
7251: IF l_inv_debug_level IN(101, 102) THEN
7252: INVPUTLI.info(
7253: Substr(
7254: 'when OTHERS exception raised in inproit_process_item_update ' ||
7255: SQLCODE ||
7256: ' - ' ||

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

7273: return INTEGER
7274: IS
7275: l_process_flag_3 NUMBER := 3;
7276:
7277: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
7278: BEGIN
7279:
7280: IF l_inv_debug_level IN(101, 102) THEN
7281: INVPUTLI.info('INVUPD2B: Inside set_process_flag3');

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

7277: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
7278: BEGIN
7279:
7280: IF l_inv_debug_level IN(101, 102) THEN
7281: INVPUTLI.info('INVUPD2B: Inside set_process_flag3');
7282: END IF;
7283: update MTL_SYSTEM_ITEMS_INTERFACE
7284: set PROCESS_FLAG = l_process_flag_3,
7285: request_id = reqst_id,

Line 7297: INVPUTLI.info(

7293:
7294: when OTHERS then
7295: --bug #4251913: Included SQLCODE and SQLERRM to trap exception messages.
7296: IF l_inv_debug_level IN(101, 102) THEN
7297: INVPUTLI.info(
7298: Substr(
7299: 'when OTHERS exception raised in set_process_flag3 ' ||
7300: SQLCODE ||
7301: ' - ' ||

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

7313: , error_text OUT NOCOPY VARCHAR2
7314: )
7315: return INTEGER
7316: IS
7317: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
7318: BEGIN
7319:
7320: IF l_inv_debug_level IN(101, 102) THEN
7321: INVPUTLI.info('INVUPD2B: inside get_message');

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

7317: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
7318: BEGIN
7319:
7320: IF l_inv_debug_level IN(101, 102) THEN
7321: INVPUTLI.info('INVUPD2B: inside get_message');
7322: END IF;
7323: FND_MESSAGE.SET_NAME('INV', SUBSTRB(msg_name, 1,30));
7324: error_text := FND_MESSAGE.GET;
7325: return (0);

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

7327: EXCEPTION
7328:
7329: when OTHERS then
7330: IF l_inv_debug_level IN(101, 102) THEN
7331: INVPUTLI.info( SUBSTRB('get_message: ' || SQLERRM, 1, 240) );
7332: END IF;
7333: return (1);
7334:
7335: END get_message;