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) or
18: (kanban_card_id is not null))
19: for update ;
20:

Line 17: process_status = WIP_CONSTANTS.ML_COMPLETE) or

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) or
18: (kanban_card_id is not null))
19: for update ;
20:
21: BEGIN

Line 54: WIP_CONSTANTS.UNRELEASED,

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

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

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

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

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

Line 80: WIP_CONSTANTS.COMP_CHRG,

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

Line 81: WIP_CONSTANTS.HOLD) AND

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

Line 82: P_Old_Status_Type IN (WIP_CONSTANTS.UNRELEASED,

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

Line 83: WIP_CONSTANTS.FAIL_BOM,

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

Line 84: WIP_CONSTANTS.FAIL_ROUT,

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

Line 85: WIP_CONSTANTS.PEND_SCHED,

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

Line 86: WIP_CONSTANTS.CANCELLED)) THEN

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

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

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

Line 118: SET PROCESS_STATUS = WIP_CONSTANTS.ERROR

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

Line 120: AND PROCESS_PHASE <> WIP_CONSTANTS.ML_COMPLETE;

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

Line 140: AND PROCESS_PHASE <> WIP_CONSTANTS.ML_COMPLETE;

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