APPS.M4R_7B1_WSM_IN dependencies on WSM_LOT_JOB_INTERFACE

Line 1480: g_exception_tracking_msg := 'Querying WSM_LOT_JOB_INTERFACE for Errors';

1476: IF (g_debug_level <= 1) THEN
1477: cln_debug_pub.Add('l_err_msg1 : ' || l_err_msg1, 1);
1478: END IF;
1479: */
1480: g_exception_tracking_msg := 'Querying WSM_LOT_JOB_INTERFACE for Errors';
1481:
1482: SELECT PROCESS_STATUS,ERROR_MSG
1483: INTO l_interface_status,l_err_msg2
1484: FROM WSM_LOT_JOB_INTERFACE

Line 1484: FROM WSM_LOT_JOB_INTERFACE

1480: g_exception_tracking_msg := 'Querying WSM_LOT_JOB_INTERFACE for Errors';
1481:
1482: SELECT PROCESS_STATUS,ERROR_MSG
1483: INTO l_interface_status,l_err_msg2
1484: FROM WSM_LOT_JOB_INTERFACE
1485: WHERE header_id = l_header_id;
1486:
1487: IF (g_debug_level <= 1) THEN
1488: cln_debug_pub.Add('l_interface_status : ' || l_interface_status, 1);

Line 1655: SELECT wsm_lot_job_interface_s.NEXTVAL

1651: SELECT wsm_lot_sm_ifc_header_s.NEXTVAL
1652: INTO l_header_id
1653: FROM DUAL;
1654:
1655: SELECT wsm_lot_job_interface_s.NEXTVAL
1656: INTO l_group_id
1657: FROM DUAL;
1658:
1659: IF ((p_hdr_rec.first_unit_start_date IS NOT NULL ) AND (p_hdr_rec.scheduled_completion_date IS NOT NULL ))THEN

Line 1780: INTO WSM_LOT_JOB_INTERFACE ( MODE_FLAG,

1776: cln_debug_pub.Add('-------- Values successfully inserted into WSM_STARTING_LOTS_INTERFACE --------',1);
1777: END IF;
1778:
1779: INSERT
1780: INTO WSM_LOT_JOB_INTERFACE ( MODE_FLAG,
1781: HEADER_ID,
1782: GROUP_ID,
1783: LAST_UPDATE_DATE,
1784: LAST_UPDATED_BY,

Line 1835: cln_debug_pub.Add('-------- Values successfully inserted into WSM_LOT_JOB_INTERFACE --------',1);

1831: l_sch_method,
1832: 'Y');
1833:
1834: IF (g_debug_level <= 1) THEN
1835: cln_debug_pub.Add('-------- Values successfully inserted into WSM_LOT_JOB_INTERFACE --------',1);
1836: END IF;
1837:
1838: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'LOT_NUMBER',p_hdr_rec.lot_number);
1839: wf_engine.SetItemAttrText('M4R7B1OI',p_item_key,'INV_ITEM_CODE',p_hdr_rec.starting_lot_item_code);

Line 4501: g_exception_tracking_msg := 'Querying WSM_LOT_JOB_INTERFACE for errors';

4497: IF l_waiting_rows = 1 THEN
4498:
4499: BEGIN
4500:
4501: g_exception_tracking_msg := 'Querying WSM_LOT_JOB_INTERFACE for errors';
4502:
4503: SELECT PROCESS_STATUS,ERROR_MSG
4504: INTO l_interface_status,l_err_msg
4505: FROM WSM_LOT_JOB_INTERFACE

Line 4505: FROM WSM_LOT_JOB_INTERFACE

4501: g_exception_tracking_msg := 'Querying WSM_LOT_JOB_INTERFACE for errors';
4502:
4503: SELECT PROCESS_STATUS,ERROR_MSG
4504: INTO l_interface_status,l_err_msg
4505: FROM WSM_LOT_JOB_INTERFACE
4506: WHERE header_id = l_rec.group_id;
4507:
4508: IF (g_debug_level <= 1) THEN
4509: cln_debug_pub.Add('l_interface_status : ' || l_interface_status, 1);