APPS.WIP_JOB_DTLS_VALIDATIONS dependencies on WIP_CONSTANTS

Line 10: and wjdi.process_phase = wip_constants.ml_validation

6: select interface_id
7: from wip_job_dtls_interface wjdi
8: where wjdi.group_id = p_group_id
9: and wjdi.parent_header_id = p_parent_header_id
10: and wjdi.process_phase = wip_constants.ml_validation
11: and wjdi.process_status in (wip_constants.running, wip_constants.warning)
12: and not exists (select 1
13: from wip_job_schedule_interface wjsi
14: where wjdi.group_id = wjsi.group_id

Line 11: and wjdi.process_status in (wip_constants.running, wip_constants.warning)

7: from wip_job_dtls_interface wjdi
8: where wjdi.group_id = p_group_id
9: and wjdi.parent_header_id = p_parent_header_id
10: and wjdi.process_phase = wip_constants.ml_validation
11: and wjdi.process_status in (wip_constants.running, wip_constants.warning)
12: and not exists (select 1
13: from wip_job_schedule_interface wjsi
14: where wjdi.group_id = wjsi.group_id
15: and wjdi.parent_header_id = wjsi.header_id);

Line 21: and wjdi.process_phase = wip_constants.ml_validation

17: cursor c_wdj_invalid_rows is
18: select interface_id
19: from wip_job_dtls_interface wjdi
20: where wjdi.group_id = p_group_id
21: and wjdi.process_phase = wip_constants.ml_validation
22: and wjdi.process_status in (wip_constants.running,
23: wip_constants.warning)
24: and not exists (select 1
25: from wip_discrete_jobs wdj

Line 22: and wjdi.process_status in (wip_constants.running,

18: select interface_id
19: from wip_job_dtls_interface wjdi
20: where wjdi.group_id = p_group_id
21: and wjdi.process_phase = wip_constants.ml_validation
22: and wjdi.process_status in (wip_constants.running,
23: wip_constants.warning)
24: and not exists (select 1
25: from wip_discrete_jobs wdj
26: where wjdi.wip_entity_id = wdj.wip_entity_id

Line 23: wip_constants.warning)

19: from wip_job_dtls_interface wjdi
20: where wjdi.group_id = p_group_id
21: and wjdi.process_phase = wip_constants.ml_validation
22: and wjdi.process_status in (wip_constants.running,
23: wip_constants.warning)
24: and not exists (select 1
25: from wip_discrete_jobs wdj
26: where wjdi.wip_entity_id = wdj.wip_entity_id
27: and wjdi.organization_id = wdj.organization_id);

Line 70: set process_status = wip_constants.error

66:
67: if(l_error_exists) then
68: if(wip_job_details.std_alone = 1) then
69: update wip_job_dtls_interface wjdi
70: set process_status = wip_constants.error
71: where wjdi.group_id = p_group_id
72: and process_phase = wip_constants.ml_validation
73: and process_status in (wip_constants.running,
74: wip_constants.warning)

Line 72: and process_phase = wip_constants.ml_validation

68: if(wip_job_details.std_alone = 1) then
69: update wip_job_dtls_interface wjdi
70: set process_status = wip_constants.error
71: where wjdi.group_id = p_group_id
72: and process_phase = wip_constants.ml_validation
73: and process_status in (wip_constants.running,
74: wip_constants.warning)
75: and not exists (select 1
76: from wip_discrete_jobs wdj

Line 73: and process_status in (wip_constants.running,

69: update wip_job_dtls_interface wjdi
70: set process_status = wip_constants.error
71: where wjdi.group_id = p_group_id
72: and process_phase = wip_constants.ml_validation
73: and process_status in (wip_constants.running,
74: wip_constants.warning)
75: and not exists (select 1
76: from wip_discrete_jobs wdj
77: where wjdi.wip_entity_id = wdj.wip_entity_id

Line 74: wip_constants.warning)

70: set process_status = wip_constants.error
71: where wjdi.group_id = p_group_id
72: and process_phase = wip_constants.ml_validation
73: and process_status in (wip_constants.running,
74: wip_constants.warning)
75: and not exists (select 1
76: from wip_discrete_jobs wdj
77: where wjdi.wip_entity_id = wdj.wip_entity_id
78: and wjdi.organization_id = wdj.organization_id);

Line 81: set process_status = wip_constants.error

77: where wjdi.wip_entity_id = wdj.wip_entity_id
78: and wjdi.organization_id = wdj.organization_id);
79: else
80: update wip_job_dtls_interface wjdi
81: set process_status = wip_constants.error
82: where group_id = p_group_id
83: and parent_header_id = p_parent_header_id
84: and process_phase = wip_constants.ml_validation
85: and process_status in (wip_constants.running,

Line 84: and process_phase = wip_constants.ml_validation

80: update wip_job_dtls_interface wjdi
81: set process_status = wip_constants.error
82: where group_id = p_group_id
83: and parent_header_id = p_parent_header_id
84: and process_phase = wip_constants.ml_validation
85: and process_status in (wip_constants.running,
86: wip_constants.warning)
87: and not exists (select 1
88: from wip_job_schedule_interface wjsi

Line 85: and process_status in (wip_constants.running,

81: set process_status = wip_constants.error
82: where group_id = p_group_id
83: and parent_header_id = p_parent_header_id
84: and process_phase = wip_constants.ml_validation
85: and process_status in (wip_constants.running,
86: wip_constants.warning)
87: and not exists (select 1
88: from wip_job_schedule_interface wjsi
89: where wjsi.group_id = p_group_id

Line 86: wip_constants.warning)

82: where group_id = p_group_id
83: and parent_header_id = p_parent_header_id
84: and process_phase = wip_constants.ml_validation
85: and process_status in (wip_constants.running,
86: wip_constants.warning)
87: and not exists (select 1
88: from wip_job_schedule_interface wjsi
89: where wjsi.group_id = p_group_id
90: and wjdi.parent_header_id = wjsi.header_id);

Line 102: and wjdi.process_phase = wip_constants.ml_validation

98: select interface_id
99: from wip_job_dtls_interface wjdi
100: where wjdi.group_id = p_group_id
101: and wjdi.parent_header_id = p_parent_header_id
102: and wjdi.process_phase = wip_constants.ml_validation
103: and wjdi.process_status in (wip_constants.running,
104: wip_constants.warning)
105: and not exists (select 1
106: from wip_discrete_jobs wdj

Line 103: and wjdi.process_status in (wip_constants.running,

99: from wip_job_dtls_interface wjdi
100: where wjdi.group_id = p_group_id
101: and wjdi.parent_header_id = p_parent_header_id
102: and wjdi.process_phase = wip_constants.ml_validation
103: and wjdi.process_status in (wip_constants.running,
104: wip_constants.warning)
105: and not exists (select 1
106: from wip_discrete_jobs wdj
107: where wjdi.wip_entity_id = wdj.wip_entity_id

Line 104: wip_constants.warning)

100: where wjdi.group_id = p_group_id
101: and wjdi.parent_header_id = p_parent_header_id
102: and wjdi.process_phase = wip_constants.ml_validation
103: and wjdi.process_status in (wip_constants.running,
104: wip_constants.warning)
105: and not exists (select 1
106: from wip_discrete_jobs wdj
107: where wjdi.wip_entity_id = wdj.wip_entity_id
108: and wjdi.organization_id = wdj.organization_id

Line 109: and wdj.status_type in (wip_constants.unreleased,

105: and not exists (select 1
106: from wip_discrete_jobs wdj
107: where wjdi.wip_entity_id = wdj.wip_entity_id
108: and wjdi.organization_id = wdj.organization_id
109: and wdj.status_type in (wip_constants.unreleased,
110: wip_constants.released,
111: wip_constants.comp_chrg,
112: wip_constants.hold));
113: l_error_exists boolean := false;

Line 110: wip_constants.released,

106: from wip_discrete_jobs wdj
107: where wjdi.wip_entity_id = wdj.wip_entity_id
108: and wjdi.organization_id = wdj.organization_id
109: and wdj.status_type in (wip_constants.unreleased,
110: wip_constants.released,
111: wip_constants.comp_chrg,
112: wip_constants.hold));
113: l_error_exists boolean := false;
114: begin

Line 111: wip_constants.comp_chrg,

107: where wjdi.wip_entity_id = wdj.wip_entity_id
108: and wjdi.organization_id = wdj.organization_id
109: and wdj.status_type in (wip_constants.unreleased,
110: wip_constants.released,
111: wip_constants.comp_chrg,
112: wip_constants.hold));
113: l_error_exists boolean := false;
114: begin
115:

Line 112: wip_constants.hold));

108: and wjdi.organization_id = wdj.organization_id
109: and wdj.status_type in (wip_constants.unreleased,
110: wip_constants.released,
111: wip_constants.comp_chrg,
112: wip_constants.hold));
113: l_error_exists boolean := false;
114: begin
115:
116: -- 1: unreleased, no charges allowed

Line 133: set process_status = wip_constants.error

129: end if;
130:
131: if(l_error_exists) then
132: update wip_job_dtls_interface wjdi
133: set process_status = wip_constants.error
134: where group_id = p_group_id
135: and parent_header_id = p_parent_header_id
136: and process_phase = wip_constants.ml_validation
137: and process_status in (wip_constants.running,

Line 136: and process_phase = wip_constants.ml_validation

132: update wip_job_dtls_interface wjdi
133: set process_status = wip_constants.error
134: where group_id = p_group_id
135: and parent_header_id = p_parent_header_id
136: and process_phase = wip_constants.ml_validation
137: and process_status in (wip_constants.running,
138: wip_constants.warning)
139: and not exists (select 1
140: from wip_discrete_jobs wdj

Line 137: and process_status in (wip_constants.running,

133: set process_status = wip_constants.error
134: where group_id = p_group_id
135: and parent_header_id = p_parent_header_id
136: and process_phase = wip_constants.ml_validation
137: and process_status in (wip_constants.running,
138: wip_constants.warning)
139: and not exists (select 1
140: from wip_discrete_jobs wdj
141: where wjdi.wip_entity_id = wdj.wip_entity_id

Line 138: wip_constants.warning)

134: where group_id = p_group_id
135: and parent_header_id = p_parent_header_id
136: and process_phase = wip_constants.ml_validation
137: and process_status in (wip_constants.running,
138: wip_constants.warning)
139: and not exists (select 1
140: from wip_discrete_jobs wdj
141: where wjdi.wip_entity_id = wdj.wip_entity_id
142: and wjdi.organization_id = wdj.organization_id

Line 143: and wdj.status_type in (wip_constants.unreleased,

139: and not exists (select 1
140: from wip_discrete_jobs wdj
141: where wjdi.wip_entity_id = wdj.wip_entity_id
142: and wjdi.organization_id = wdj.organization_id
143: and wdj.status_type in (wip_constants.unreleased,
144: wip_constants.released,
145: wip_constants.comp_chrg,
146: wip_constants.hold));
147: end if;

Line 144: wip_constants.released,

140: from wip_discrete_jobs wdj
141: where wjdi.wip_entity_id = wdj.wip_entity_id
142: and wjdi.organization_id = wdj.organization_id
143: and wdj.status_type in (wip_constants.unreleased,
144: wip_constants.released,
145: wip_constants.comp_chrg,
146: wip_constants.hold));
147: end if;
148: end job_status;

Line 145: wip_constants.comp_chrg,

141: where wjdi.wip_entity_id = wdj.wip_entity_id
142: and wjdi.organization_id = wdj.organization_id
143: and wdj.status_type in (wip_constants.unreleased,
144: wip_constants.released,
145: wip_constants.comp_chrg,
146: wip_constants.hold));
147: end if;
148: end job_status;
149:

Line 146: wip_constants.hold));

142: and wjdi.organization_id = wdj.organization_id
143: and wdj.status_type in (wip_constants.unreleased,
144: wip_constants.released,
145: wip_constants.comp_chrg,
146: wip_constants.hold));
147: end if;
148: end job_status;
149:
150: procedure is_firm (p_group_id number,

Line 157: and wjdi.process_phase = wip_constants.ml_validation

153: select interface_id
154: from wip_job_dtls_interface wjdi
155: where wjdi.group_id = p_group_id
156: and wjdi.parent_header_id = p_parent_header_id
157: and wjdi.process_phase = wip_constants.ml_validation
158: and wjdi.process_status in (wip_constants.running,
159: wip_constants.warning)
160: and exists (select 1
161: from wip_discrete_jobs wdj

Line 158: and wjdi.process_status in (wip_constants.running,

154: from wip_job_dtls_interface wjdi
155: where wjdi.group_id = p_group_id
156: and wjdi.parent_header_id = p_parent_header_id
157: and wjdi.process_phase = wip_constants.ml_validation
158: and wjdi.process_status in (wip_constants.running,
159: wip_constants.warning)
160: and exists (select 1
161: from wip_discrete_jobs wdj
162: where wjdi.wip_entity_id = wdj.wip_entity_id

Line 159: wip_constants.warning)

155: where wjdi.group_id = p_group_id
156: and wjdi.parent_header_id = p_parent_header_id
157: and wjdi.process_phase = wip_constants.ml_validation
158: and wjdi.process_status in (wip_constants.running,
159: wip_constants.warning)
160: and exists (select 1
161: from wip_discrete_jobs wdj
162: where wjdi.wip_entity_id = wdj.wip_entity_id
163: and wjdi.organization_id = wdj.organization_id

Line 164: and wdj.status_type in (wip_constants.unreleased,

160: and exists (select 1
161: from wip_discrete_jobs wdj
162: where wjdi.wip_entity_id = wdj.wip_entity_id
163: and wjdi.organization_id = wdj.organization_id
164: and wdj.status_type in (wip_constants.unreleased,
165: wip_constants.released,
166: wip_constants.comp_chrg,
167: wip_constants.hold)
168: and wdj.firm_planned_flag = wip_constants.yes);

Line 165: wip_constants.released,

161: from wip_discrete_jobs wdj
162: where wjdi.wip_entity_id = wdj.wip_entity_id
163: and wjdi.organization_id = wdj.organization_id
164: and wdj.status_type in (wip_constants.unreleased,
165: wip_constants.released,
166: wip_constants.comp_chrg,
167: wip_constants.hold)
168: and wdj.firm_planned_flag = wip_constants.yes);
169:

Line 166: wip_constants.comp_chrg,

162: where wjdi.wip_entity_id = wdj.wip_entity_id
163: and wjdi.organization_id = wdj.organization_id
164: and wdj.status_type in (wip_constants.unreleased,
165: wip_constants.released,
166: wip_constants.comp_chrg,
167: wip_constants.hold)
168: and wdj.firm_planned_flag = wip_constants.yes);
169:
170: l_error_exists boolean := false;

Line 167: wip_constants.hold)

163: and wjdi.organization_id = wdj.organization_id
164: and wdj.status_type in (wip_constants.unreleased,
165: wip_constants.released,
166: wip_constants.comp_chrg,
167: wip_constants.hold)
168: and wdj.firm_planned_flag = wip_constants.yes);
169:
170: l_error_exists boolean := false;
171: begin

Line 168: and wdj.firm_planned_flag = wip_constants.yes);

164: and wdj.status_type in (wip_constants.unreleased,
165: wip_constants.released,
166: wip_constants.comp_chrg,
167: wip_constants.hold)
168: and wdj.firm_planned_flag = wip_constants.yes);
169:
170: l_error_exists boolean := false;
171: begin
172: -- If firmed, we can't do any further change

Line 186: set process_status = wip_constants.error

182: end if;
183:
184: if(l_error_exists) then
185: update wip_job_dtls_interface wjdi
186: set process_status = wip_constants.error
187: where group_id = p_group_id
188: and parent_header_id = p_parent_header_id
189: and process_phase = wip_constants.ml_validation
190: and process_status in (wip_constants.running,

Line 189: and process_phase = wip_constants.ml_validation

185: update wip_job_dtls_interface wjdi
186: set process_status = wip_constants.error
187: where group_id = p_group_id
188: and parent_header_id = p_parent_header_id
189: and process_phase = wip_constants.ml_validation
190: and process_status in (wip_constants.running,
191: wip_constants.warning)
192: and exists (select 1
193: from wip_discrete_jobs wdj

Line 190: and process_status in (wip_constants.running,

186: set process_status = wip_constants.error
187: where group_id = p_group_id
188: and parent_header_id = p_parent_header_id
189: and process_phase = wip_constants.ml_validation
190: and process_status in (wip_constants.running,
191: wip_constants.warning)
192: and exists (select 1
193: from wip_discrete_jobs wdj
194: where wjdi.wip_entity_id = wdj.wip_entity_id

Line 191: wip_constants.warning)

187: where group_id = p_group_id
188: and parent_header_id = p_parent_header_id
189: and process_phase = wip_constants.ml_validation
190: and process_status in (wip_constants.running,
191: wip_constants.warning)
192: and exists (select 1
193: from wip_discrete_jobs wdj
194: where wjdi.wip_entity_id = wdj.wip_entity_id
195: and wjdi.organization_id = wdj.organization_id

Line 196: and wdj.status_type in (wip_constants.unreleased,

192: and exists (select 1
193: from wip_discrete_jobs wdj
194: where wjdi.wip_entity_id = wdj.wip_entity_id
195: and wjdi.organization_id = wdj.organization_id
196: and wdj.status_type in (wip_constants.unreleased,
197: wip_constants.released,
198: wip_constants.comp_chrg,
199: wip_constants.hold)
200: and wdj.firm_planned_flag = wip_constants.yes);

Line 197: wip_constants.released,

193: from wip_discrete_jobs wdj
194: where wjdi.wip_entity_id = wdj.wip_entity_id
195: and wjdi.organization_id = wdj.organization_id
196: and wdj.status_type in (wip_constants.unreleased,
197: wip_constants.released,
198: wip_constants.comp_chrg,
199: wip_constants.hold)
200: and wdj.firm_planned_flag = wip_constants.yes);
201: end if;

Line 198: wip_constants.comp_chrg,

194: where wjdi.wip_entity_id = wdj.wip_entity_id
195: and wjdi.organization_id = wdj.organization_id
196: and wdj.status_type in (wip_constants.unreleased,
197: wip_constants.released,
198: wip_constants.comp_chrg,
199: wip_constants.hold)
200: and wdj.firm_planned_flag = wip_constants.yes);
201: end if;
202: end is_firm;

Line 199: wip_constants.hold)

195: and wjdi.organization_id = wdj.organization_id
196: and wdj.status_type in (wip_constants.unreleased,
197: wip_constants.released,
198: wip_constants.comp_chrg,
199: wip_constants.hold)
200: and wdj.firm_planned_flag = wip_constants.yes);
201: end if;
202: end is_firm;
203:

Line 200: and wdj.firm_planned_flag = wip_constants.yes);

196: and wdj.status_type in (wip_constants.unreleased,
197: wip_constants.released,
198: wip_constants.comp_chrg,
199: wip_constants.hold)
200: and wdj.firm_planned_flag = wip_constants.yes);
201: end if;
202: end is_firm;
203:
204: procedure op_seq_num(p_group_id IN number,

Line 220: and wjdi.process_phase = wip_constants.ml_validation

216: select interface_id
217: from wip_job_dtls_interface wjdi
218: where wjdi.group_id = p_group_id
219: and wjdi.parent_header_id = p_parent_header_id
220: and wjdi.process_phase = wip_constants.ml_validation
221: and wjdi.process_status in (wip_constants.running,
222: wip_constants.warning)
223: and ( wjdi.load_type in (wip_job_details.wip_resource,
224: wip_job_details.wip_sub_res,

Line 221: and wjdi.process_status in (wip_constants.running,

217: from wip_job_dtls_interface wjdi
218: where wjdi.group_id = p_group_id
219: and wjdi.parent_header_id = p_parent_header_id
220: and wjdi.process_phase = wip_constants.ml_validation
221: and wjdi.process_status in (wip_constants.running,
222: wip_constants.warning)
223: and ( wjdi.load_type in (wip_job_details.wip_resource,
224: wip_job_details.wip_sub_res,
225: wip_job_details.wip_res_usage)

Line 222: wip_constants.warning)

218: where wjdi.group_id = p_group_id
219: and wjdi.parent_header_id = p_parent_header_id
220: and wjdi.process_phase = wip_constants.ml_validation
221: and wjdi.process_status in (wip_constants.running,
222: wip_constants.warning)
223: and ( wjdi.load_type in (wip_job_details.wip_resource,
224: wip_job_details.wip_sub_res,
225: wip_job_details.wip_res_usage)
226:

Line 241: and wjdi.process_phase = wip_constants.ml_validation

237: cursor c_wdj_invalid_rows is
238: select interface_id
239: from wip_job_dtls_interface wjdi
240: where wjdi.group_id = p_group_id
241: and wjdi.process_phase = wip_constants.ml_validation
242: and wjdi.process_status in (wip_constants.running,
243: wip_constants.warning)
244: and wjdi.wip_entity_id = p_wip_entity_id
245: and wjdi.organization_id = p_organization_id

Line 242: and wjdi.process_status in (wip_constants.running,

238: select interface_id
239: from wip_job_dtls_interface wjdi
240: where wjdi.group_id = p_group_id
241: and wjdi.process_phase = wip_constants.ml_validation
242: and wjdi.process_status in (wip_constants.running,
243: wip_constants.warning)
244: and wjdi.wip_entity_id = p_wip_entity_id
245: and wjdi.organization_id = p_organization_id
246: and ( wjdi.load_type in (wip_job_details.wip_resource,

Line 243: wip_constants.warning)

239: from wip_job_dtls_interface wjdi
240: where wjdi.group_id = p_group_id
241: and wjdi.process_phase = wip_constants.ml_validation
242: and wjdi.process_status in (wip_constants.running,
243: wip_constants.warning)
244: and wjdi.wip_entity_id = p_wip_entity_id
245: and wjdi.organization_id = p_organization_id
246: and ( wjdi.load_type in (wip_job_details.wip_resource,
247: wip_job_details.wip_sub_res,

Line 274: and process_phase = wip_constants.ml_validation

270: into l_num_first_op_rows
271: from wip_job_dtls_interface
272: where group_id = p_group_id
273: and parent_header_id = p_parent_header_id
274: and process_phase = wip_constants.ml_validation
275: and process_status in (wip_constants.running,wip_constants.warning)
276: and wip_entity_id = p_wip_entity_id
277: and organization_id = p_organization_id
278: and load_type = wip_job_details.wip_mtl_requirement

Line 275: and process_status in (wip_constants.running,wip_constants.warning)

271: from wip_job_dtls_interface
272: where group_id = p_group_id
273: and parent_header_id = p_parent_header_id
274: and process_phase = wip_constants.ml_validation
275: and process_status in (wip_constants.running,wip_constants.warning)
276: and wip_entity_id = p_wip_entity_id
277: and organization_id = p_organization_id
278: and load_type = wip_job_details.wip_mtl_requirement
279: and substitution_type = wip_job_details.wip_add

Line 294: and process_phase = wip_constants.ml_validation

290: update wip_job_dtls_interface
291: set operation_seq_num = l_first_op_seq_num
292: where group_id = p_group_id
293: and parent_header_id = p_parent_header_id
294: and process_phase = wip_constants.ml_validation
295: and process_status in (wip_constants.running, wip_constants.warning)
296: and wip_entity_id = p_wip_entity_id
297: and organization_id = p_organization_id
298: and load_type = wip_job_details.wip_mtl_requirement

Line 295: and process_status in (wip_constants.running, wip_constants.warning)

291: set operation_seq_num = l_first_op_seq_num
292: where group_id = p_group_id
293: and parent_header_id = p_parent_header_id
294: and process_phase = wip_constants.ml_validation
295: and process_status in (wip_constants.running, wip_constants.warning)
296: and wip_entity_id = p_wip_entity_id
297: and organization_id = p_organization_id
298: and load_type = wip_job_details.wip_mtl_requirement
299: and substitution_type = wip_job_details.wip_add

Line 344: set process_status = wip_constants.error

340:
341: if(l_error_exists) then
342: if(wip_job_details.std_alone = 1) then
343: update wip_job_dtls_interface wjdi
344: set process_status = wip_constants.error
345: where group_id = p_group_id
346: and process_phase = wip_constants.ml_validation
347: and process_status in (wip_constants.running,
348: wip_constants.warning)

Line 346: and process_phase = wip_constants.ml_validation

342: if(wip_job_details.std_alone = 1) then
343: update wip_job_dtls_interface wjdi
344: set process_status = wip_constants.error
345: where group_id = p_group_id
346: and process_phase = wip_constants.ml_validation
347: and process_status in (wip_constants.running,
348: wip_constants.warning)
349: and wip_entity_id = p_wip_entity_id
350: and organization_id = p_organization_id

Line 347: and process_status in (wip_constants.running,

343: update wip_job_dtls_interface wjdi
344: set process_status = wip_constants.error
345: where group_id = p_group_id
346: and process_phase = wip_constants.ml_validation
347: and process_status in (wip_constants.running,
348: wip_constants.warning)
349: and wip_entity_id = p_wip_entity_id
350: and organization_id = p_organization_id
351: and ( load_type in (wip_job_details.wip_resource,

Line 348: wip_constants.warning)

344: set process_status = wip_constants.error
345: where group_id = p_group_id
346: and process_phase = wip_constants.ml_validation
347: and process_status in (wip_constants.running,
348: wip_constants.warning)
349: and wip_entity_id = p_wip_entity_id
350: and organization_id = p_organization_id
351: and ( load_type in (wip_job_details.wip_resource,
352: wip_job_details.wip_sub_res,

Line 366: set process_status = wip_constants.error

362: and wjdi.organization_id = wo.organization_id
363: and wjdi.operation_seq_num = wo.operation_seq_num);
364: else
365: update wip_job_dtls_interface wjdi
366: set process_status = wip_constants.error
367: where group_id = p_group_id
368: and parent_header_id = p_parent_header_id
369: and process_phase = wip_constants.ml_validation
370: and process_status in (wip_constants.running,

Line 369: and process_phase = wip_constants.ml_validation

365: update wip_job_dtls_interface wjdi
366: set process_status = wip_constants.error
367: where group_id = p_group_id
368: and parent_header_id = p_parent_header_id
369: and process_phase = wip_constants.ml_validation
370: and process_status in (wip_constants.running,
371: wip_constants.warning)
372: and ( load_type in (wip_job_details.wip_resource,
373: wip_job_details.wip_sub_res,

Line 370: and process_status in (wip_constants.running,

366: set process_status = wip_constants.error
367: where group_id = p_group_id
368: and parent_header_id = p_parent_header_id
369: and process_phase = wip_constants.ml_validation
370: and process_status in (wip_constants.running,
371: wip_constants.warning)
372: and ( load_type in (wip_job_details.wip_resource,
373: wip_job_details.wip_sub_res,
374: wip_job_details.wip_res_usage)

Line 371: wip_constants.warning)

367: where group_id = p_group_id
368: and parent_header_id = p_parent_header_id
369: and process_phase = wip_constants.ml_validation
370: and process_status in (wip_constants.running,
371: wip_constants.warning)
372: and ( load_type in (wip_job_details.wip_resource,
373: wip_job_details.wip_sub_res,
374: wip_job_details.wip_res_usage)
375:

Line 399: and wjdi.process_phase = wip_constants.ml_validation

395: select interface_id
396: from wip_job_dtls_interface wjdi
397: where wjdi.group_id = p_group_id
398: and wjdi.parent_header_id = p_parent_header_id
399: and wjdi.process_phase = wip_constants.ml_validation
400: and wjdi.process_status in (wip_constants.running,
401: wip_constants.warning)
402: and wjdi.wip_entity_id = p_wip_entity_id
403: and wjdi.organization_id = p_organization_id

Line 400: and wjdi.process_status in (wip_constants.running,

396: from wip_job_dtls_interface wjdi
397: where wjdi.group_id = p_group_id
398: and wjdi.parent_header_id = p_parent_header_id
399: and wjdi.process_phase = wip_constants.ml_validation
400: and wjdi.process_status in (wip_constants.running,
401: wip_constants.warning)
402: and wjdi.wip_entity_id = p_wip_entity_id
403: and wjdi.organization_id = p_organization_id
404: and ( wjdi.load_type not in (1, 2, 3, 4, 5, 6, 7, WIP_JOB_DETAILS.WIP_RES_INSTANCE, WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE) -- load_type must be resource or material

Line 401: wip_constants.warning)

397: where wjdi.group_id = p_group_id
398: and wjdi.parent_header_id = p_parent_header_id
399: and wjdi.process_phase = wip_constants.ml_validation
400: and wjdi.process_status in (wip_constants.running,
401: wip_constants.warning)
402: and wjdi.wip_entity_id = p_wip_entity_id
403: and wjdi.organization_id = p_organization_id
404: and ( wjdi.load_type not in (1, 2, 3, 4, 5, 6, 7, WIP_JOB_DETAILS.WIP_RES_INSTANCE, WIP_JOB_DETAILS.WIP_RES_INSTANCE_USAGE) -- load_type must be resource or material
405:

Line 429: set process_status = wip_constants.error

425: end loop;
426:
427: if(l_error_exists) then
428: update wip_job_dtls_interface
429: set process_status = wip_constants.error
430: where group_id = p_group_id
431: and parent_header_id = p_parent_header_id
432: and process_phase = wip_constants.ml_validation
433: and process_status in (wip_constants.running,

Line 432: and process_phase = wip_constants.ml_validation

428: update wip_job_dtls_interface
429: set process_status = wip_constants.error
430: where group_id = p_group_id
431: and parent_header_id = p_parent_header_id
432: and process_phase = wip_constants.ml_validation
433: and process_status in (wip_constants.running,
434: wip_constants.warning)
435: and wip_entity_id = p_wip_entity_id
436: and organization_id = p_organization_id

Line 433: and process_status in (wip_constants.running,

429: set process_status = wip_constants.error
430: where group_id = p_group_id
431: and parent_header_id = p_parent_header_id
432: and process_phase = wip_constants.ml_validation
433: and process_status in (wip_constants.running,
434: wip_constants.warning)
435: and wip_entity_id = p_wip_entity_id
436: and organization_id = p_organization_id
437: and ( load_type not in (1, 2, 3, 4, 5)

Line 434: wip_constants.warning)

430: where group_id = p_group_id
431: and parent_header_id = p_parent_header_id
432: and process_phase = wip_constants.ml_validation
433: and process_status in (wip_constants.running,
434: wip_constants.warning)
435: and wip_entity_id = p_wip_entity_id
436: and organization_id = p_organization_id
437: and ( load_type not in (1, 2, 3, 4, 5)
438: or substitution_type not in (1, 2, 3));

Line 453: and wjdi.process_phase = wip_constants.ml_validation

449: select interface_id
450: from wip_job_dtls_interface wjdi
451: where wjdi.group_id = p_group_id
452: and wjdi.parent_header_id = p_parent_header_id
453: and wjdi.process_phase = wip_constants.ml_validation
454: and wjdi.process_status in (wip_constants.running,
455: wip_constants.warning)
456: and wjdi.wip_entity_id = p_wip_entity_id
457: and wjdi.organization_id = p_organization_id

Line 454: and wjdi.process_status in (wip_constants.running,

450: from wip_job_dtls_interface wjdi
451: where wjdi.group_id = p_group_id
452: and wjdi.parent_header_id = p_parent_header_id
453: and wjdi.process_phase = wip_constants.ml_validation
454: and wjdi.process_status in (wip_constants.running,
455: wip_constants.warning)
456: and wjdi.wip_entity_id = p_wip_entity_id
457: and wjdi.organization_id = p_organization_id
458: and not exists (select 1

Line 455: wip_constants.warning)

451: where wjdi.group_id = p_group_id
452: and wjdi.parent_header_id = p_parent_header_id
453: and wjdi.process_phase = wip_constants.ml_validation
454: and wjdi.process_status in (wip_constants.running,
455: wip_constants.warning)
456: and wjdi.wip_entity_id = p_wip_entity_id
457: and wjdi.organization_id = p_organization_id
458: and not exists (select 1
459: from fnd_user_view fu

Line 484: set process_status = wip_constants.error

480: end loop;
481:
482: if(l_error_exists) then
483: update wip_job_dtls_interface wjdi
484: set process_status = wip_constants.error
485: where group_id = p_group_id
486: and parent_header_id = p_parent_header_id
487: and process_phase = wip_constants.ml_validation
488: and process_status in (wip_constants.running,

Line 487: and process_phase = wip_constants.ml_validation

483: update wip_job_dtls_interface wjdi
484: set process_status = wip_constants.error
485: where group_id = p_group_id
486: and parent_header_id = p_parent_header_id
487: and process_phase = wip_constants.ml_validation
488: and process_status in (wip_constants.running,
489: wip_constants.warning)
490: and wip_entity_id = p_wip_entity_id
491: and organization_id = p_organization_id

Line 488: and process_status in (wip_constants.running,

484: set process_status = wip_constants.error
485: where group_id = p_group_id
486: and parent_header_id = p_parent_header_id
487: and process_phase = wip_constants.ml_validation
488: and process_status in (wip_constants.running,
489: wip_constants.warning)
490: and wip_entity_id = p_wip_entity_id
491: and organization_id = p_organization_id
492: and not exists (select 1

Line 489: wip_constants.warning)

485: where group_id = p_group_id
486: and parent_header_id = p_parent_header_id
487: and process_phase = wip_constants.ml_validation
488: and process_status in (wip_constants.running,
489: wip_constants.warning)
490: and wip_entity_id = p_wip_entity_id
491: and organization_id = p_organization_id
492: and not exists (select 1
493: from fnd_user_view fu

Line 508: and wjdi.process_phase = wip_constants.ml_validation

504: select interface_id
505: from wip_job_dtls_interface wjdi
506: where wjdi.group_id = p_group_id
507: and wjdi.parent_header_id = p_parent_header_id
508: and wjdi.process_phase = wip_constants.ml_validation
509: and wjdi.process_status in (wip_constants.running,
510: wip_constants.warning)
511: and wjdi.wip_entity_id = p_wip_entity_id
512: and wjdi.organization_id = p_organization_id

Line 509: and wjdi.process_status in (wip_constants.running,

505: from wip_job_dtls_interface wjdi
506: where wjdi.group_id = p_group_id
507: and wjdi.parent_header_id = p_parent_header_id
508: and wjdi.process_phase = wip_constants.ml_validation
509: and wjdi.process_status in (wip_constants.running,
510: wip_constants.warning)
511: and wjdi.wip_entity_id = p_wip_entity_id
512: and wjdi.organization_id = p_organization_id
513: and not exists (select 1

Line 510: wip_constants.warning)

506: where wjdi.group_id = p_group_id
507: and wjdi.parent_header_id = p_parent_header_id
508: and wjdi.process_phase = wip_constants.ml_validation
509: and wjdi.process_status in (wip_constants.running,
510: wip_constants.warning)
511: and wjdi.wip_entity_id = p_wip_entity_id
512: and wjdi.organization_id = p_organization_id
513: and not exists (select 1
514: from fnd_user_view fu

Line 539: set process_status = wip_constants.error

535: end loop;
536:
537: if(l_error_exists) then
538: update wip_job_dtls_interface wjdi
539: set process_status = wip_constants.error
540: where group_id = p_group_id
541: and parent_header_id = p_parent_header_id
542: and process_phase = wip_constants.ml_validation
543: and process_status in (wip_constants.running,

Line 542: and process_phase = wip_constants.ml_validation

538: update wip_job_dtls_interface wjdi
539: set process_status = wip_constants.error
540: where group_id = p_group_id
541: and parent_header_id = p_parent_header_id
542: and process_phase = wip_constants.ml_validation
543: and process_status in (wip_constants.running,
544: wip_constants.warning)
545: and wip_entity_id = p_wip_entity_id
546: and organization_id = p_organization_id

Line 543: and process_status in (wip_constants.running,

539: set process_status = wip_constants.error
540: where group_id = p_group_id
541: and parent_header_id = p_parent_header_id
542: and process_phase = wip_constants.ml_validation
543: and process_status in (wip_constants.running,
544: wip_constants.warning)
545: and wip_entity_id = p_wip_entity_id
546: and organization_id = p_organization_id
547: and not exists (select 1

Line 544: wip_constants.warning)

540: where group_id = p_group_id
541: and parent_header_id = p_parent_header_id
542: and process_phase = wip_constants.ml_validation
543: and process_status in (wip_constants.running,
544: wip_constants.warning)
545: and wip_entity_id = p_wip_entity_id
546: and organization_id = p_organization_id
547: and not exists (select 1
548: from fnd_user_view fu

Line 568: and wjdi.process_phase = wip_constants.ml_validation

564: select interface_id
565: from wip_job_dtls_interface wjdi
566: where wjdi.group_id = p_group_id
567: and wjdi.parent_header_id = p_parent_header_id
568: and wjdi.process_phase = wip_constants.ml_validation
569: and wjdi.process_status in (wip_constants.running,
570: wip_constants.warning)
571: and wjdi.wip_entity_id = p_wip_entity_id
572: and wjdi.organization_id = p_organization_id

Line 569: and wjdi.process_status in (wip_constants.running,

565: from wip_job_dtls_interface wjdi
566: where wjdi.group_id = p_group_id
567: and wjdi.parent_header_id = p_parent_header_id
568: and wjdi.process_phase = wip_constants.ml_validation
569: and wjdi.process_status in (wip_constants.running,
570: wip_constants.warning)
571: and wjdi.wip_entity_id = p_wip_entity_id
572: and wjdi.organization_id = p_organization_id
573: and exists (select 1

Line 570: wip_constants.warning)

566: where wjdi.group_id = p_group_id
567: and wjdi.parent_header_id = p_parent_header_id
568: and wjdi.process_phase = wip_constants.ml_validation
569: and wjdi.process_status in (wip_constants.running,
570: wip_constants.warning)
571: and wjdi.wip_entity_id = p_wip_entity_id
572: and wjdi.organization_id = p_organization_id
573: and exists (select 1
574: from wip_job_dtls_interface wjdi2

Line 577: and wjdi2.process_status = wip_constants.error

573: and exists (select 1
574: from wip_job_dtls_interface wjdi2
575: where wjdi2.group_id = wjdi.group_id
576: and wjdi2.parent_header_id = wjdi.parent_header_id
577: and wjdi2.process_status = wip_constants.error
578: and wjdi2.wip_entity_id = wjdi.wip_entity_id
579: and wjdi2.organization_id = wjdi.organization_id);
580: l_error_exists boolean := false;
581: begin

Line 592: set process_status = wip_constants.error

588: p_error_type => wip_jdi_utils.msg_error);
589: end loop;
590: if(l_error_exists) then
591: update wip_job_dtls_interface wjdi
592: set process_status = wip_constants.error
593: where group_id = p_group_id
594: and parent_header_id = p_parent_header_id
595: and process_phase = wip_constants.ml_validation
596: and process_status in (wip_constants.running,

Line 595: and process_phase = wip_constants.ml_validation

591: update wip_job_dtls_interface wjdi
592: set process_status = wip_constants.error
593: where group_id = p_group_id
594: and parent_header_id = p_parent_header_id
595: and process_phase = wip_constants.ml_validation
596: and process_status in (wip_constants.running,
597: wip_constants.warning)
598: and wip_entity_id = p_wip_entity_id
599: and organization_id = p_organization_id

Line 596: and process_status in (wip_constants.running,

592: set process_status = wip_constants.error
593: where group_id = p_group_id
594: and parent_header_id = p_parent_header_id
595: and process_phase = wip_constants.ml_validation
596: and process_status in (wip_constants.running,
597: wip_constants.warning)
598: and wip_entity_id = p_wip_entity_id
599: and organization_id = p_organization_id
600: and exists (select 1

Line 597: wip_constants.warning)

593: where group_id = p_group_id
594: and parent_header_id = p_parent_header_id
595: and process_phase = wip_constants.ml_validation
596: and process_status in (wip_constants.running,
597: wip_constants.warning)
598: and wip_entity_id = p_wip_entity_id
599: and organization_id = p_organization_id
600: and exists (select 1
601: from wip_job_dtls_interface wjdi2

Line 604: and wjdi2.process_status = wip_constants.error

600: and exists (select 1
601: from wip_job_dtls_interface wjdi2
602: where wjdi2.group_id = wjdi.group_id
603: and wjdi2.parent_header_id = wjdi.parent_header_id
604: and wjdi2.process_status = wip_constants.error
605: and wjdi2.wip_entity_id = wjdi.wip_entity_id
606: and wjdi2.organization_id = wjdi.organization_id);
607: end if;
608: end error_all_if_any;