APPS.WIP_MASS_LOAD_PROCESSOR dependencies on WIP_CONSTANTS

Line 16: ((process_phase = WIP_CONSTANTS.ML_COMPLETE and

12: select rowid, interface_id, header_id
13: from wip_job_schedule_interface
14: where
15: group_id = p_group_id and
16: ((process_phase = WIP_CONSTANTS.ML_COMPLETE and
17: process_status = WIP_CONSTANTS.ML_COMPLETE))
18: for update ;
19:
20: BEGIN

Line 17: process_status = WIP_CONSTANTS.ML_COMPLETE))

13: from wip_job_schedule_interface
14: where
15: group_id = p_group_id and
16: ((process_phase = WIP_CONSTANTS.ML_COMPLETE and
17: process_status = WIP_CONSTANTS.ML_COMPLETE))
18: for update ;
19:
20: BEGIN
21:

Line 53: WIP_CONSTANTS.UNRELEASED,

49: (P_Wip_Entity_Id,
50: P_Organization_Id,
51: NULL, NULL,
52: P_Class_Code,
53: WIP_CONSTANTS.UNRELEASED,
54: P_New_Status_Type,
55: x_dummy,
56: nvl(P_Release_Date,sysdate)); /* 2424987 */
57:

Line 77: /* Bug 4955616. Removed WIP_CONSTANTS.CANCELLED from new status list and added to old status list*/

73: BEGIN
74:
75: /* bug#3388658: added more combination of new and old job status
76: types instead of just P_New_Status_Type=RELEASED */
77: /* Bug 4955616. Removed WIP_CONSTANTS.CANCELLED from new status list and added to old status list*/
78: IF(P_New_Status_Type IN (WIP_CONSTANTS.RELEASED,
79: WIP_CONSTANTS.COMP_CHRG,
80: WIP_CONSTANTS.HOLD) AND
81: P_Old_Status_Type IN (WIP_CONSTANTS.UNRELEASED,

Line 78: IF(P_New_Status_Type IN (WIP_CONSTANTS.RELEASED,

74:
75: /* bug#3388658: added more combination of new and old job status
76: types instead of just P_New_Status_Type=RELEASED */
77: /* Bug 4955616. Removed WIP_CONSTANTS.CANCELLED from new status list and added to old status list*/
78: IF(P_New_Status_Type IN (WIP_CONSTANTS.RELEASED,
79: WIP_CONSTANTS.COMP_CHRG,
80: WIP_CONSTANTS.HOLD) AND
81: P_Old_Status_Type IN (WIP_CONSTANTS.UNRELEASED,
82: WIP_CONSTANTS.FAIL_BOM,

Line 79: WIP_CONSTANTS.COMP_CHRG,

75: /* bug#3388658: added more combination of new and old job status
76: types instead of just P_New_Status_Type=RELEASED */
77: /* Bug 4955616. Removed WIP_CONSTANTS.CANCELLED from new status list and added to old status list*/
78: IF(P_New_Status_Type IN (WIP_CONSTANTS.RELEASED,
79: WIP_CONSTANTS.COMP_CHRG,
80: WIP_CONSTANTS.HOLD) AND
81: P_Old_Status_Type IN (WIP_CONSTANTS.UNRELEASED,
82: WIP_CONSTANTS.FAIL_BOM,
83: WIP_CONSTANTS.FAIL_ROUT,

Line 80: WIP_CONSTANTS.HOLD) AND

76: types instead of just P_New_Status_Type=RELEASED */
77: /* Bug 4955616. Removed WIP_CONSTANTS.CANCELLED from new status list and added to old status list*/
78: IF(P_New_Status_Type IN (WIP_CONSTANTS.RELEASED,
79: WIP_CONSTANTS.COMP_CHRG,
80: WIP_CONSTANTS.HOLD) AND
81: P_Old_Status_Type IN (WIP_CONSTANTS.UNRELEASED,
82: WIP_CONSTANTS.FAIL_BOM,
83: WIP_CONSTANTS.FAIL_ROUT,
84: WIP_CONSTANTS.PEND_SCHED,

Line 81: P_Old_Status_Type IN (WIP_CONSTANTS.UNRELEASED,

77: /* Bug 4955616. Removed WIP_CONSTANTS.CANCELLED from new status list and added to old status list*/
78: IF(P_New_Status_Type IN (WIP_CONSTANTS.RELEASED,
79: WIP_CONSTANTS.COMP_CHRG,
80: WIP_CONSTANTS.HOLD) AND
81: P_Old_Status_Type IN (WIP_CONSTANTS.UNRELEASED,
82: WIP_CONSTANTS.FAIL_BOM,
83: WIP_CONSTANTS.FAIL_ROUT,
84: WIP_CONSTANTS.PEND_SCHED,
85: WIP_CONSTANTS.CANCELLED)) THEN

Line 82: WIP_CONSTANTS.FAIL_BOM,

78: IF(P_New_Status_Type IN (WIP_CONSTANTS.RELEASED,
79: WIP_CONSTANTS.COMP_CHRG,
80: WIP_CONSTANTS.HOLD) AND
81: P_Old_Status_Type IN (WIP_CONSTANTS.UNRELEASED,
82: WIP_CONSTANTS.FAIL_BOM,
83: WIP_CONSTANTS.FAIL_ROUT,
84: WIP_CONSTANTS.PEND_SCHED,
85: WIP_CONSTANTS.CANCELLED)) THEN
86: ML_Release(P_Wip_Entity_Id,

Line 83: WIP_CONSTANTS.FAIL_ROUT,

79: WIP_CONSTANTS.COMP_CHRG,
80: WIP_CONSTANTS.HOLD) AND
81: P_Old_Status_Type IN (WIP_CONSTANTS.UNRELEASED,
82: WIP_CONSTANTS.FAIL_BOM,
83: WIP_CONSTANTS.FAIL_ROUT,
84: WIP_CONSTANTS.PEND_SCHED,
85: WIP_CONSTANTS.CANCELLED)) THEN
86: ML_Release(P_Wip_Entity_Id,
87: P_Organization_Id,

Line 84: WIP_CONSTANTS.PEND_SCHED,

80: WIP_CONSTANTS.HOLD) AND
81: P_Old_Status_Type IN (WIP_CONSTANTS.UNRELEASED,
82: WIP_CONSTANTS.FAIL_BOM,
83: WIP_CONSTANTS.FAIL_ROUT,
84: WIP_CONSTANTS.PEND_SCHED,
85: WIP_CONSTANTS.CANCELLED)) THEN
86: ML_Release(P_Wip_Entity_Id,
87: P_Organization_Id,
88: P_Class_Code,

Line 85: WIP_CONSTANTS.CANCELLED)) THEN

81: P_Old_Status_Type IN (WIP_CONSTANTS.UNRELEASED,
82: WIP_CONSTANTS.FAIL_BOM,
83: WIP_CONSTANTS.FAIL_ROUT,
84: WIP_CONSTANTS.PEND_SCHED,
85: WIP_CONSTANTS.CANCELLED)) THEN
86: ML_Release(P_Wip_Entity_Id,
87: P_Organization_Id,
88: P_Class_Code,
89: P_New_Status_Type,

Line 94: ELSIF(P_New_Status_Type = WIP_CONSTANTS.UNRELEASED) THEN

90: P_Success_Flag,
91: P_Error_Msg,
92: nvl(P_Release_Date,sysdate)); /* 2424987 */
93:
94: ELSIF(P_New_Status_Type = WIP_CONSTANTS.UNRELEASED) THEN
95: WIP_UNRELEASE.Unrelease(P_Organization_Id,
96: P_Wip_Entity_Id,
97: NULL,
98: NULL,

Line 117: SET PROCESS_STATUS = WIP_CONSTANTS.ERROR

113: error_text varchar2(500);
114: BEGIN
115:
116: UPDATE WIP_JOB_SCHEDULE_INTERFACE
117: SET PROCESS_STATUS = WIP_CONSTANTS.ERROR
118: WHERE GROUP_ID = P_Group_Id
119: AND PROCESS_PHASE <> WIP_CONSTANTS.ML_COMPLETE;
120:
121: err_num := SQLCODE;

Line 119: AND PROCESS_PHASE <> WIP_CONSTANTS.ML_COMPLETE;

115:
116: UPDATE WIP_JOB_SCHEDULE_INTERFACE
117: SET PROCESS_STATUS = WIP_CONSTANTS.ERROR
118: WHERE GROUP_ID = P_Group_Id
119: AND PROCESS_PHASE <> WIP_CONSTANTS.ML_COMPLETE;
120:
121: err_num := SQLCODE;
122: error_text := SUBSTR(SQLERRM, 1, 500);
123:

Line 139: AND PROCESS_PHASE <> WIP_CONSTANTS.ML_COMPLETE;

135: created_by, last_update_login,
136: last_updated_by
137: FROM WIP_JOB_SCHEDULE_INTERFACE
138: WHERE GROUP_ID = P_Group_Id
139: AND PROCESS_PHASE <> WIP_CONSTANTS.ML_COMPLETE;
140:
141: END Raise_Sql_Error;
142:
143: END WIP_MASS_LOAD_PROCESSOR;