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.AHL_PRD_OPERATIONS_PVT dependencies on FND_API

Line 113: p_x_prd_workoper_rec.wip_entity_id = FND_API.G_MISS_NUM ) AND

109: l_job_actual_end_date;
110: CLOSE get_workorder_rec;
111:
112: IF ( ( p_x_prd_workoper_rec.wip_entity_id IS NULL OR
113: p_x_prd_workoper_rec.wip_entity_id = FND_API.G_MISS_NUM ) AND
114: l_job_wip_entity_id IS NOT NULL ) THEN
115: p_x_prd_workoper_rec.wip_entity_id := l_job_wip_entity_id;
116: END IF;
117:

Line 119: p_x_prd_workoper_rec.organization_id = FND_API.G_MISS_NUM ) THEN

115: p_x_prd_workoper_rec.wip_entity_id := l_job_wip_entity_id;
116: END IF;
117:
118: IF ( p_x_prd_workoper_rec.organization_id IS NULL OR
119: p_x_prd_workoper_rec.organization_id = FND_API.G_MISS_NUM ) THEN
120: p_x_prd_workoper_rec.organization_id := l_job_organization_id;
121: END IF;
122:
123: IF ( G_DEBUG = 'Y' ) THEN

Line 143: p_init_msg_list => FND_API.G_FALSE,

139: IF l_qa_inspection_type IS NOT NULL THEN
140: AHL_QA_RESULTS_PVT.get_qa_plan
141: (
142: p_api_version => 1.0,
143: p_init_msg_list => FND_API.G_FALSE,
144: p_commit => FND_API.G_FALSE,
145: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
146: p_default => FND_API.G_FALSE,
147: p_module_type => NULL,

Line 144: p_commit => FND_API.G_FALSE,

140: AHL_QA_RESULTS_PVT.get_qa_plan
141: (
142: p_api_version => 1.0,
143: p_init_msg_list => FND_API.G_FALSE,
144: p_commit => FND_API.G_FALSE,
145: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
146: p_default => FND_API.G_FALSE,
147: p_module_type => NULL,
148: x_return_status => l_return_status,

Line 145: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

141: (
142: p_api_version => 1.0,
143: p_init_msg_list => FND_API.G_FALSE,
144: p_commit => FND_API.G_FALSE,
145: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
146: p_default => FND_API.G_FALSE,
147: p_module_type => NULL,
148: x_return_status => l_return_status,
149: x_msg_count => l_msg_count,

Line 146: p_default => FND_API.G_FALSE,

142: p_api_version => 1.0,
143: p_init_msg_list => FND_API.G_FALSE,
144: p_commit => FND_API.G_FALSE,
145: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
146: p_default => FND_API.G_FALSE,
147: p_module_type => NULL,
148: x_return_status => l_return_status,
149: x_msg_count => l_msg_count,
150: x_msg_data => l_msg_data,

Line 159: p_x_prd_workoper_rec.scheduled_start_date <> FND_API.G_MISS_DATE AND

155: );
156: END IF;
157:
158: IF ( p_x_prd_workoper_rec.scheduled_start_date IS NOT NULL AND
159: p_x_prd_workoper_rec.scheduled_start_date <> FND_API.G_MISS_DATE AND
160: l_job_scheduled_start_date IS NOT NULL AND
161: TRUNC( p_x_prd_workoper_rec.scheduled_start_date ) = TRUNC( l_job_scheduled_start_date ) ) THEN
162: p_x_prd_workoper_rec.scheduled_start_date := l_job_scheduled_start_date;
163: IF ( p_x_prd_workoper_rec.scheduled_start_hr IS NULL OR

Line 164: p_x_prd_workoper_rec.scheduled_start_hr = FND_API.G_MISS_NUM)

160: l_job_scheduled_start_date IS NOT NULL AND
161: TRUNC( p_x_prd_workoper_rec.scheduled_start_date ) = TRUNC( l_job_scheduled_start_date ) ) THEN
162: p_x_prd_workoper_rec.scheduled_start_date := l_job_scheduled_start_date;
163: IF ( p_x_prd_workoper_rec.scheduled_start_hr IS NULL OR
164: p_x_prd_workoper_rec.scheduled_start_hr = FND_API.G_MISS_NUM)
165: THEN
166: p_x_prd_workoper_rec.scheduled_start_hr := TO_NUMBER( TO_CHAR( l_job_scheduled_start_date, 'HH24' ) );
167: END IF;
168:

Line 170: p_x_prd_workoper_rec.scheduled_start_mi = FND_API.G_MISS_NUM)

166: p_x_prd_workoper_rec.scheduled_start_hr := TO_NUMBER( TO_CHAR( l_job_scheduled_start_date, 'HH24' ) );
167: END IF;
168:
169: IF( p_x_prd_workoper_rec.scheduled_start_mi IS NULL OR
170: p_x_prd_workoper_rec.scheduled_start_mi = FND_API.G_MISS_NUM)
171: THEN
172: p_x_prd_workoper_rec.scheduled_start_mi := TO_NUMBER( TO_CHAR( l_job_scheduled_start_date, 'MI' ) );
173: END IF;
174: END IF;

Line 177: p_x_prd_workoper_rec.scheduled_end_date <> FND_API.G_MISS_DATE AND

173: END IF;
174: END IF;
175:
176: IF ( p_x_prd_workoper_rec.scheduled_end_date IS NOT NULL AND
177: p_x_prd_workoper_rec.scheduled_end_date <> FND_API.G_MISS_DATE AND
178: l_job_scheduled_end_date IS NOT NULL AND
179: TRUNC( p_x_prd_workoper_rec.scheduled_end_date ) = TRUNC( l_job_scheduled_end_date ) ) THEN
180: p_x_prd_workoper_rec.scheduled_end_date := l_job_scheduled_end_date;
181: IF ( p_x_prd_workoper_rec.scheduled_end_hr IS NULL OR

Line 182: p_x_prd_workoper_rec.scheduled_end_hr = FND_API.G_MISS_NUM)

178: l_job_scheduled_end_date IS NOT NULL AND
179: TRUNC( p_x_prd_workoper_rec.scheduled_end_date ) = TRUNC( l_job_scheduled_end_date ) ) THEN
180: p_x_prd_workoper_rec.scheduled_end_date := l_job_scheduled_end_date;
181: IF ( p_x_prd_workoper_rec.scheduled_end_hr IS NULL OR
182: p_x_prd_workoper_rec.scheduled_end_hr = FND_API.G_MISS_NUM)
183: THEN
184: p_x_prd_workoper_rec.scheduled_end_hr := TO_NUMBER( TO_CHAR( l_job_scheduled_end_date, 'HH24' ) );
185: END IF;
186:

Line 188: p_x_prd_workoper_rec.scheduled_end_mi = FND_API.G_MISS_NUM)

184: p_x_prd_workoper_rec.scheduled_end_hr := TO_NUMBER( TO_CHAR( l_job_scheduled_end_date, 'HH24' ) );
185: END IF;
186:
187: IF ( p_x_prd_workoper_rec.scheduled_end_mi IS NULL OR
188: p_x_prd_workoper_rec.scheduled_end_mi = FND_API.G_MISS_NUM)
189: THEN
190: p_x_prd_workoper_rec.scheduled_end_mi := TO_NUMBER( TO_CHAR( l_job_scheduled_end_date, 'MI' ) );
191: END IF;
192: ELSIF ( p_x_prd_workoper_rec.scheduled_end_date IS NOT NULL AND

Line 193: p_x_prd_workoper_rec.scheduled_end_date <> FND_API.G_MISS_DATE AND

189: THEN
190: p_x_prd_workoper_rec.scheduled_end_mi := TO_NUMBER( TO_CHAR( l_job_scheduled_end_date, 'MI' ) );
191: END IF;
192: ELSIF ( p_x_prd_workoper_rec.scheduled_end_date IS NOT NULL AND
193: p_x_prd_workoper_rec.scheduled_end_date <> FND_API.G_MISS_DATE AND
194: l_job_scheduled_start_date IS NOT NULL AND
195: TRUNC( p_x_prd_workoper_rec.scheduled_end_date ) = TRUNC( l_job_scheduled_start_date ) ) THEN
196: p_x_prd_workoper_rec.scheduled_end_date := l_job_scheduled_start_date;
197: IF ( p_x_prd_workoper_rec.scheduled_end_hr IS NULL OR

Line 198: p_x_prd_workoper_rec.scheduled_end_hr = FND_API.G_MISS_NUM)

194: l_job_scheduled_start_date IS NOT NULL AND
195: TRUNC( p_x_prd_workoper_rec.scheduled_end_date ) = TRUNC( l_job_scheduled_start_date ) ) THEN
196: p_x_prd_workoper_rec.scheduled_end_date := l_job_scheduled_start_date;
197: IF ( p_x_prd_workoper_rec.scheduled_end_hr IS NULL OR
198: p_x_prd_workoper_rec.scheduled_end_hr = FND_API.G_MISS_NUM)
199: THEN
200: p_x_prd_workoper_rec.scheduled_end_hr := TO_NUMBER( TO_CHAR( l_job_scheduled_start_date, 'HH24' ) );
201: END IF;
202:

Line 204: p_x_prd_workoper_rec.scheduled_end_mi = FND_API.G_MISS_NUM)

200: p_x_prd_workoper_rec.scheduled_end_hr := TO_NUMBER( TO_CHAR( l_job_scheduled_start_date, 'HH24' ) );
201: END IF;
202:
203: IF ( p_x_prd_workoper_rec.scheduled_end_mi IS NULL OR
204: p_x_prd_workoper_rec.scheduled_end_mi = FND_API.G_MISS_NUM)
205: THEN
206: p_x_prd_workoper_rec.scheduled_end_mi := TO_NUMBER( TO_CHAR( l_job_scheduled_start_date, 'MI' ) );
207: END IF;
208: END IF;

Line 211: p_x_prd_workoper_rec.actual_start_date <> FND_API.G_MISS_DATE AND

207: END IF;
208: END IF;
209:
210: IF ( p_x_prd_workoper_rec.actual_start_date IS NOT NULL AND
211: p_x_prd_workoper_rec.actual_start_date <> FND_API.G_MISS_DATE AND
212: l_job_actual_start_date IS NOT NULL AND
213: TRUNC( p_x_prd_workoper_rec.actual_start_date ) = TRUNC( l_job_actual_start_date ) ) THEN
214: p_x_prd_workoper_rec.actual_start_date := l_job_actual_start_date;
215: p_x_prd_workoper_rec.actual_start_hr := TO_NUMBER( TO_CHAR( l_job_actual_start_date, 'HH24' ) );

Line 220: p_x_prd_workoper_rec.actual_end_date <> FND_API.G_MISS_DATE AND

216: p_x_prd_workoper_rec.actual_start_mi := TO_NUMBER( TO_CHAR( l_job_actual_start_date, 'MI' ) );
217: END IF;
218:
219: IF ( p_x_prd_workoper_rec.actual_end_date IS NOT NULL AND
220: p_x_prd_workoper_rec.actual_end_date <> FND_API.G_MISS_DATE AND
221: l_job_actual_end_date IS NOT NULL AND
222: TRUNC( p_x_prd_workoper_rec.actual_end_date ) = TRUNC( l_job_actual_end_date ) ) THEN
223: p_x_prd_workoper_rec.actual_end_date := l_job_actual_end_date;
224: p_x_prd_workoper_rec.actual_end_hr := TO_NUMBER( TO_CHAR( l_job_actual_end_date, 'HH24' ) );

Line 227: p_x_prd_workoper_rec.actual_end_date <> FND_API.G_MISS_DATE AND

223: p_x_prd_workoper_rec.actual_end_date := l_job_actual_end_date;
224: p_x_prd_workoper_rec.actual_end_hr := TO_NUMBER( TO_CHAR( l_job_actual_end_date, 'HH24' ) );
225: p_x_prd_workoper_rec.actual_end_mi := TO_NUMBER( TO_CHAR( l_job_scheduled_end_date, 'MI' ) );
226: ELSIF ( p_x_prd_workoper_rec.actual_end_date IS NOT NULL AND
227: p_x_prd_workoper_rec.actual_end_date <> FND_API.G_MISS_DATE AND
228: l_job_actual_start_date IS NOT NULL AND
229: TRUNC( p_x_prd_workoper_rec.actual_end_date ) = TRUNC( l_job_actual_start_date ) ) THEN
230: p_x_prd_workoper_rec.actual_end_date := l_job_actual_start_date;
231: p_x_prd_workoper_rec.actual_end_hr := TO_NUMBER( TO_CHAR( l_job_actual_start_date, 'HH24' ) );

Line 256: IF p_x_prd_workoper_rec.SCHEDULED_START_DATE=FND_API.G_MISS_DATE THEN

252: OPEN get_operation_rec(p_x_prd_workoper_rec.WORKORDER_OPERATION_ID);
253: FETCH get_operation_rec INTO l_old_operation_rec;
254: CLOSE get_operation_rec;
255: IF(p_module_type IS NULL OR p_module_type NOT IN ('OAF','JSP'))THEN
256: IF p_x_prd_workoper_rec.SCHEDULED_START_DATE=FND_API.G_MISS_DATE THEN
257: p_x_prd_workoper_rec.SCHEDULED_START_DATE:=NULL;
258: ELSIF p_x_prd_workoper_rec.SCHEDULED_START_DATE IS NULL THEN
259: p_x_prd_workoper_rec.SCHEDULED_START_DATE:=l_old_operation_rec.SCHEDULED_START_DATE;
260: END IF;

Line 261: IF p_x_prd_workoper_rec.SCHEDULED_START_HR=FND_API.G_MISS_NUM THEN

257: p_x_prd_workoper_rec.SCHEDULED_START_DATE:=NULL;
258: ELSIF p_x_prd_workoper_rec.SCHEDULED_START_DATE IS NULL THEN
259: p_x_prd_workoper_rec.SCHEDULED_START_DATE:=l_old_operation_rec.SCHEDULED_START_DATE;
260: END IF;
261: IF p_x_prd_workoper_rec.SCHEDULED_START_HR=FND_API.G_MISS_NUM THEN
262: p_x_prd_workoper_rec.SCHEDULED_START_HR:=NULL;
263: ELSIF p_x_prd_workoper_rec.SCHEDULED_START_HR IS NULL THEN
264: p_x_prd_workoper_rec.SCHEDULED_START_HR:=l_old_operation_rec.SCHEDULED_START_HR;
265: END IF;

Line 267: IF p_x_prd_workoper_rec.SCHEDULED_START_MI=FND_API.G_MISS_NUM THEN

263: ELSIF p_x_prd_workoper_rec.SCHEDULED_START_HR IS NULL THEN
264: p_x_prd_workoper_rec.SCHEDULED_START_HR:=l_old_operation_rec.SCHEDULED_START_HR;
265: END IF;
266:
267: IF p_x_prd_workoper_rec.SCHEDULED_START_MI=FND_API.G_MISS_NUM THEN
268: p_x_prd_workoper_rec.SCHEDULED_START_MI:=NULL;
269: ELSIF p_x_prd_workoper_rec.SCHEDULED_START_MI IS NULL THEN
270: p_x_prd_workoper_rec.SCHEDULED_START_MI:=l_old_operation_rec.SCHEDULED_START_MI;
271: END IF;

Line 273: IF p_x_prd_workoper_rec.SCHEDULED_END_DATE=FND_API.G_MISS_DATE THEN

269: ELSIF p_x_prd_workoper_rec.SCHEDULED_START_MI IS NULL THEN
270: p_x_prd_workoper_rec.SCHEDULED_START_MI:=l_old_operation_rec.SCHEDULED_START_MI;
271: END IF;
272:
273: IF p_x_prd_workoper_rec.SCHEDULED_END_DATE=FND_API.G_MISS_DATE THEN
274: p_x_prd_workoper_rec.SCHEDULED_END_DATE:=NULL;
275: ELSIF p_x_prd_workoper_rec.SCHEDULED_END_DATE IS NULL THEN
276: p_x_prd_workoper_rec.SCHEDULED_END_DATE:=l_old_operation_rec.SCHEDULED_END_DATE;
277: END IF;

Line 279: IF p_x_prd_workoper_rec.SCHEDULED_END_HR=FND_API.G_MISS_NUM THEN

275: ELSIF p_x_prd_workoper_rec.SCHEDULED_END_DATE IS NULL THEN
276: p_x_prd_workoper_rec.SCHEDULED_END_DATE:=l_old_operation_rec.SCHEDULED_END_DATE;
277: END IF;
278:
279: IF p_x_prd_workoper_rec.SCHEDULED_END_HR=FND_API.G_MISS_NUM THEN
280: p_x_prd_workoper_rec.SCHEDULED_END_HR:=NULL;
281: ELSIF p_x_prd_workoper_rec.SCHEDULED_END_HR IS NULL THEN
282: p_x_prd_workoper_rec.SCHEDULED_END_HR:=l_old_operation_rec.SCHEDULED_END_HR;
283: END IF;

Line 285: IF p_x_prd_workoper_rec.SCHEDULED_END_MI=FND_API.G_MISS_NUM THEN

281: ELSIF p_x_prd_workoper_rec.SCHEDULED_END_HR IS NULL THEN
282: p_x_prd_workoper_rec.SCHEDULED_END_HR:=l_old_operation_rec.SCHEDULED_END_HR;
283: END IF;
284:
285: IF p_x_prd_workoper_rec.SCHEDULED_END_MI=FND_API.G_MISS_NUM THEN
286: p_x_prd_workoper_rec.SCHEDULED_END_MI:=NULL;
287: ELSIF p_x_prd_workoper_rec.SCHEDULED_END_MI IS NULL THEN
288: p_x_prd_workoper_rec.SCHEDULED_END_MI:=l_old_operation_rec.SCHEDULED_END_MI;
289: END IF;

Line 291: IF p_x_prd_workoper_rec.ACTUAL_START_DATE=FND_API.G_MISS_DATE THEN

287: ELSIF p_x_prd_workoper_rec.SCHEDULED_END_MI IS NULL THEN
288: p_x_prd_workoper_rec.SCHEDULED_END_MI:=l_old_operation_rec.SCHEDULED_END_MI;
289: END IF;
290:
291: IF p_x_prd_workoper_rec.ACTUAL_START_DATE=FND_API.G_MISS_DATE THEN
292: p_x_prd_workoper_rec.ACTUAL_START_DATE:=NULL;
293: ELSIF p_x_prd_workoper_rec.ACTUAL_START_DATE IS NULL THEN
294: p_x_prd_workoper_rec.ACTUAL_START_DATE:=l_old_operation_rec.ACTUAL_START_DATE;
295: END IF;

Line 297: IF p_x_prd_workoper_rec.ACTUAL_START_HR=FND_API.G_MISS_NUM THEN

293: ELSIF p_x_prd_workoper_rec.ACTUAL_START_DATE IS NULL THEN
294: p_x_prd_workoper_rec.ACTUAL_START_DATE:=l_old_operation_rec.ACTUAL_START_DATE;
295: END IF;
296:
297: IF p_x_prd_workoper_rec.ACTUAL_START_HR=FND_API.G_MISS_NUM THEN
298: p_x_prd_workoper_rec.ACTUAL_START_HR:=NULL;
299: ELSIF p_x_prd_workoper_rec.ACTUAL_START_HR IS NULL THEN
300: p_x_prd_workoper_rec.ACTUAL_START_HR:=l_old_operation_rec.ACTUAL_START_HR;
301: END IF;

Line 303: IF p_x_prd_workoper_rec.ACTUAL_START_MI=FND_API.G_MISS_NUM THEN

299: ELSIF p_x_prd_workoper_rec.ACTUAL_START_HR IS NULL THEN
300: p_x_prd_workoper_rec.ACTUAL_START_HR:=l_old_operation_rec.ACTUAL_START_HR;
301: END IF;
302:
303: IF p_x_prd_workoper_rec.ACTUAL_START_MI=FND_API.G_MISS_NUM THEN
304: p_x_prd_workoper_rec.ACTUAL_START_MI:=NULL;
305: ELSIF p_x_prd_workoper_rec.ACTUAL_START_MI IS NULL THEN
306: p_x_prd_workoper_rec.ACTUAL_START_MI:=l_old_operation_rec.ACTUAL_START_MI;
307: END IF;

Line 309: IF p_x_prd_workoper_rec.ACTUAL_END_DATE=FND_API.G_MISS_DATE THEN

305: ELSIF p_x_prd_workoper_rec.ACTUAL_START_MI IS NULL THEN
306: p_x_prd_workoper_rec.ACTUAL_START_MI:=l_old_operation_rec.ACTUAL_START_MI;
307: END IF;
308:
309: IF p_x_prd_workoper_rec.ACTUAL_END_DATE=FND_API.G_MISS_DATE THEN
310: p_x_prd_workoper_rec.ACTUAL_END_DATE:=NULL;
311: ELSIF p_x_prd_workoper_rec.ACTUAL_END_DATE IS NULL THEN
312: p_x_prd_workoper_rec.ACTUAL_END_DATE:=l_old_operation_rec.ACTUAL_END_DATE;
313: END IF;

Line 315: IF p_x_prd_workoper_rec.ACTUAL_END_HR=FND_API.G_MISS_NUM THEN

311: ELSIF p_x_prd_workoper_rec.ACTUAL_END_DATE IS NULL THEN
312: p_x_prd_workoper_rec.ACTUAL_END_DATE:=l_old_operation_rec.ACTUAL_END_DATE;
313: END IF;
314:
315: IF p_x_prd_workoper_rec.ACTUAL_END_HR=FND_API.G_MISS_NUM THEN
316: p_x_prd_workoper_rec.ACTUAL_END_HR:=NULL;
317: ELSIF p_x_prd_workoper_rec.ACTUAL_END_HR IS NULL THEN
318: p_x_prd_workoper_rec.ACTUAL_END_HR:=l_old_operation_rec.ACTUAL_END_HR;
319: END IF;

Line 321: IF p_x_prd_workoper_rec.ACTUAL_END_MI=FND_API.G_MISS_NUM THEN

317: ELSIF p_x_prd_workoper_rec.ACTUAL_END_HR IS NULL THEN
318: p_x_prd_workoper_rec.ACTUAL_END_HR:=l_old_operation_rec.ACTUAL_END_HR;
319: END IF;
320:
321: IF p_x_prd_workoper_rec.ACTUAL_END_MI=FND_API.G_MISS_NUM THEN
322: p_x_prd_workoper_rec.ACTUAL_END_MI:=NULL;
323: ELSIF p_x_prd_workoper_rec.ACTUAL_END_MI IS NULL THEN
324: p_x_prd_workoper_rec.ACTUAL_END_MI:=l_old_operation_rec.ACTUAL_END_MI;
325: END IF;

Line 328: IF p_x_prd_workoper_rec.SCHEDULED_START_HR=FND_API.G_MISS_NUM THEN

324: p_x_prd_workoper_rec.ACTUAL_END_MI:=l_old_operation_rec.ACTUAL_END_MI;
325: END IF;
326: ELSIF p_module_type = 'JSP' THEN
327: IF p_x_prd_workoper_rec.SCHEDULED_START_DATE IS NOT NULL THEN
328: IF p_x_prd_workoper_rec.SCHEDULED_START_HR=FND_API.G_MISS_NUM THEN
329: p_x_prd_workoper_rec.SCHEDULED_START_HR:=NULL;
330: ELSIF p_x_prd_workoper_rec.SCHEDULED_START_HR IS NULL THEN
331: p_x_prd_workoper_rec.SCHEDULED_START_HR:=l_old_operation_rec.SCHEDULED_START_HR;
332: END IF;

Line 333: IF p_x_prd_workoper_rec.SCHEDULED_START_MI=FND_API.G_MISS_NUM THEN

329: p_x_prd_workoper_rec.SCHEDULED_START_HR:=NULL;
330: ELSIF p_x_prd_workoper_rec.SCHEDULED_START_HR IS NULL THEN
331: p_x_prd_workoper_rec.SCHEDULED_START_HR:=l_old_operation_rec.SCHEDULED_START_HR;
332: END IF;
333: IF p_x_prd_workoper_rec.SCHEDULED_START_MI=FND_API.G_MISS_NUM THEN
334: p_x_prd_workoper_rec.SCHEDULED_START_MI:=NULL;
335: ELSIF p_x_prd_workoper_rec.SCHEDULED_START_MI IS NULL THEN
336: p_x_prd_workoper_rec.SCHEDULED_START_MI:=l_old_operation_rec.SCHEDULED_START_MI;
337: END IF;

Line 341: IF p_x_prd_workoper_rec.SCHEDULED_END_HR=FND_API.G_MISS_NUM THEN

337: END IF;
338: END IF;
339:
340: IF p_x_prd_workoper_rec.SCHEDULED_END_DATE IS NOT NULL THEN
341: IF p_x_prd_workoper_rec.SCHEDULED_END_HR=FND_API.G_MISS_NUM THEN
342: p_x_prd_workoper_rec.SCHEDULED_END_HR:=NULL;
343: ELSIF p_x_prd_workoper_rec.SCHEDULED_END_HR IS NULL THEN
344: p_x_prd_workoper_rec.SCHEDULED_END_HR:=l_old_operation_rec.SCHEDULED_END_HR;
345: END IF;

Line 346: IF p_x_prd_workoper_rec.SCHEDULED_END_MI=FND_API.G_MISS_NUM THEN

342: p_x_prd_workoper_rec.SCHEDULED_END_HR:=NULL;
343: ELSIF p_x_prd_workoper_rec.SCHEDULED_END_HR IS NULL THEN
344: p_x_prd_workoper_rec.SCHEDULED_END_HR:=l_old_operation_rec.SCHEDULED_END_HR;
345: END IF;
346: IF p_x_prd_workoper_rec.SCHEDULED_END_MI=FND_API.G_MISS_NUM THEN
347: p_x_prd_workoper_rec.SCHEDULED_END_MI:=NULL;
348: ELSIF p_x_prd_workoper_rec.SCHEDULED_END_MI IS NULL THEN
349: p_x_prd_workoper_rec.SCHEDULED_END_MI:=l_old_operation_rec.SCHEDULED_END_MI;
350: END IF;

Line 354: IF p_x_prd_workoper_rec.ACTUAL_START_HR=FND_API.G_MISS_NUM THEN

350: END IF;
351: END IF;
352:
353: IF p_x_prd_workoper_rec.ACTUAL_START_DATE IS NOT NULL THEN
354: IF p_x_prd_workoper_rec.ACTUAL_START_HR=FND_API.G_MISS_NUM THEN
355: p_x_prd_workoper_rec.ACTUAL_START_HR:=NULL;
356: ELSIF p_x_prd_workoper_rec.ACTUAL_START_HR IS NULL THEN
357: p_x_prd_workoper_rec.ACTUAL_START_HR:=l_old_operation_rec.ACTUAL_START_HR;
358: END IF;

Line 360: IF p_x_prd_workoper_rec.ACTUAL_START_MI=FND_API.G_MISS_NUM THEN

356: ELSIF p_x_prd_workoper_rec.ACTUAL_START_HR IS NULL THEN
357: p_x_prd_workoper_rec.ACTUAL_START_HR:=l_old_operation_rec.ACTUAL_START_HR;
358: END IF;
359:
360: IF p_x_prd_workoper_rec.ACTUAL_START_MI=FND_API.G_MISS_NUM THEN
361: p_x_prd_workoper_rec.ACTUAL_START_MI:=NULL;
362: ELSIF p_x_prd_workoper_rec.ACTUAL_START_MI IS NULL THEN
363: p_x_prd_workoper_rec.ACTUAL_START_MI:=l_old_operation_rec.ACTUAL_START_MI;
364: END IF;

Line 368: IF p_x_prd_workoper_rec.ACTUAL_END_HR=FND_API.G_MISS_NUM THEN

364: END IF;
365: END IF;
366:
367: IF p_x_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL THEN
368: IF p_x_prd_workoper_rec.ACTUAL_END_HR=FND_API.G_MISS_NUM THEN
369: p_x_prd_workoper_rec.ACTUAL_END_HR:=NULL;
370: ELSIF p_x_prd_workoper_rec.ACTUAL_END_HR IS NULL THEN
371: p_x_prd_workoper_rec.ACTUAL_END_HR:=l_old_operation_rec.ACTUAL_END_HR;
372: END IF;

Line 373: IF p_x_prd_workoper_rec.ACTUAL_END_MI=FND_API.G_MISS_NUM THEN

369: p_x_prd_workoper_rec.ACTUAL_END_HR:=NULL;
370: ELSIF p_x_prd_workoper_rec.ACTUAL_END_HR IS NULL THEN
371: p_x_prd_workoper_rec.ACTUAL_END_HR:=l_old_operation_rec.ACTUAL_END_HR;
372: END IF;
373: IF p_x_prd_workoper_rec.ACTUAL_END_MI=FND_API.G_MISS_NUM THEN
374: p_x_prd_workoper_rec.ACTUAL_END_MI:=NULL;
375: ELSIF p_x_prd_workoper_rec.ACTUAL_END_MI IS NULL THEN
376: p_x_prd_workoper_rec.ACTUAL_END_MI:=l_old_operation_rec.ACTUAL_END_MI;
377: END IF;

Line 381: IF p_x_prd_workoper_rec.DEPARTMENT_ID= FND_API.G_MISS_NUM THEN

377: END IF;
378: END IF;
379: END IF;
380:
381: IF p_x_prd_workoper_rec.DEPARTMENT_ID= FND_API.G_MISS_NUM THEN
382: p_x_prd_workoper_rec.DEPARTMENT_ID:=NULL;
383: ELSIF p_x_prd_workoper_rec.DEPARTMENT_ID IS NULL THEN
384: p_x_prd_workoper_rec.DEPARTMENT_ID:=l_old_operation_rec.DEPARTMENT_ID;
385: END IF;

Line 387: IF p_x_prd_workoper_rec.DEPARTMENT_NAME= FND_API.G_MISS_CHAR THEN

383: ELSIF p_x_prd_workoper_rec.DEPARTMENT_ID IS NULL THEN
384: p_x_prd_workoper_rec.DEPARTMENT_ID:=l_old_operation_rec.DEPARTMENT_ID;
385: END IF;
386:
387: IF p_x_prd_workoper_rec.DEPARTMENT_NAME= FND_API.G_MISS_CHAR THEN
388: p_x_prd_workoper_rec.DEPARTMENT_NAME:=NULL;
389: ELSIF p_x_prd_workoper_rec.DEPARTMENT_NAME IS NULL THEN
390: p_x_prd_workoper_rec.DEPARTMENT_NAME:=l_old_operation_rec.DEPARTMENT_NAME;
391: END IF;

Line 393: IF p_x_prd_workoper_rec.STATUS_CODE= FND_API.G_MISS_CHAR THEN

389: ELSIF p_x_prd_workoper_rec.DEPARTMENT_NAME IS NULL THEN
390: p_x_prd_workoper_rec.DEPARTMENT_NAME:=l_old_operation_rec.DEPARTMENT_NAME;
391: END IF;
392:
393: IF p_x_prd_workoper_rec.STATUS_CODE= FND_API.G_MISS_CHAR THEN
394: p_x_prd_workoper_rec.STATUS_CODE:=NULL;
395: ELSIF p_x_prd_workoper_rec.STATUS_CODE IS NULL THEN
396: p_x_prd_workoper_rec.STATUS_CODE:=l_old_operation_rec.STATUS_CODE;
397: END IF;

Line 399: IF p_x_prd_workoper_rec.STATUS_MEANING= FND_API.G_MISS_CHAR THEN

395: ELSIF p_x_prd_workoper_rec.STATUS_CODE IS NULL THEN
396: p_x_prd_workoper_rec.STATUS_CODE:=l_old_operation_rec.STATUS_CODE;
397: END IF;
398:
399: IF p_x_prd_workoper_rec.STATUS_MEANING= FND_API.G_MISS_CHAR THEN
400: p_x_prd_workoper_rec.STATUS_MEANING:=NULL;
401: ELSIF p_x_prd_workoper_rec.STATUS_MEANING IS NULL THEN
402: p_x_prd_workoper_rec.STATUS_MEANING:=l_old_operation_rec.STATUS;
403: END IF;

Line 405: IF p_x_prd_workoper_rec.OPERATION_ID= FND_API.G_MISS_NUM THEN

401: ELSIF p_x_prd_workoper_rec.STATUS_MEANING IS NULL THEN
402: p_x_prd_workoper_rec.STATUS_MEANING:=l_old_operation_rec.STATUS;
403: END IF;
404:
405: IF p_x_prd_workoper_rec.OPERATION_ID= FND_API.G_MISS_NUM THEN
406: p_x_prd_workoper_rec.OPERATION_ID:=NULL;
407: ELSIF p_x_prd_workoper_rec.OPERATION_ID IS NULL THEN
408: p_x_prd_workoper_rec.OPERATION_ID:=l_old_operation_rec.OPERATION_ID;
409: END IF;

Line 411: IF p_x_prd_workoper_rec.OPERATION_CODE= FND_API.G_MISS_CHAR THEN

407: ELSIF p_x_prd_workoper_rec.OPERATION_ID IS NULL THEN
408: p_x_prd_workoper_rec.OPERATION_ID:=l_old_operation_rec.OPERATION_ID;
409: END IF;
410:
411: IF p_x_prd_workoper_rec.OPERATION_CODE= FND_API.G_MISS_CHAR THEN
412: p_x_prd_workoper_rec.OPERATION_CODE:=NULL;
413: ELSIF p_x_prd_workoper_rec.OPERATION_CODE IS NULL THEN
414: p_x_prd_workoper_rec.OPERATION_CODE:=l_old_operation_rec.OPERATION_CODE;
415: END IF;

Line 417: IF p_x_prd_workoper_rec.OPERATION_TYPE_CODE= FND_API.G_MISS_CHAR THEN

413: ELSIF p_x_prd_workoper_rec.OPERATION_CODE IS NULL THEN
414: p_x_prd_workoper_rec.OPERATION_CODE:=l_old_operation_rec.OPERATION_CODE;
415: END IF;
416:
417: IF p_x_prd_workoper_rec.OPERATION_TYPE_CODE= FND_API.G_MISS_CHAR THEN
418: p_x_prd_workoper_rec.OPERATION_TYPE_CODE:=NULL;
419: ELSIF p_x_prd_workoper_rec.OPERATION_TYPE_CODE IS NULL THEN
420: p_x_prd_workoper_rec.OPERATION_TYPE_CODE:=l_old_operation_rec.OPERATION_TYPE_CODE;
421: END IF;

Line 423: IF p_x_prd_workoper_rec.OPERATION_TYPE= FND_API.G_MISS_CHAR THEN

419: ELSIF p_x_prd_workoper_rec.OPERATION_TYPE_CODE IS NULL THEN
420: p_x_prd_workoper_rec.OPERATION_TYPE_CODE:=l_old_operation_rec.OPERATION_TYPE_CODE;
421: END IF;
422:
423: IF p_x_prd_workoper_rec.OPERATION_TYPE= FND_API.G_MISS_CHAR THEN
424: p_x_prd_workoper_rec.OPERATION_TYPE:=NULL;
425: ELSIF p_x_prd_workoper_rec.OPERATION_TYPE IS NULL THEN
426: p_x_prd_workoper_rec.OPERATION_TYPE:=l_old_operation_rec.OPERATION_TYPE;
427: END IF;

Line 429: IF p_x_prd_workoper_rec.PLAN_ID= FND_API.G_MISS_NUM THEN

425: ELSIF p_x_prd_workoper_rec.OPERATION_TYPE IS NULL THEN
426: p_x_prd_workoper_rec.OPERATION_TYPE:=l_old_operation_rec.OPERATION_TYPE;
427: END IF;
428:
429: IF p_x_prd_workoper_rec.PLAN_ID= FND_API.G_MISS_NUM THEN
430: p_x_prd_workoper_rec.PLAN_ID:=NULL;
431: ELSIF p_x_prd_workoper_rec.PLAN_ID IS NULL THEN
432: p_x_prd_workoper_rec.PLAN_ID:=l_old_operation_rec.PLAN_ID;
433: END IF;

Line 435: IF p_x_prd_workoper_rec.COLLECTION_ID= FND_API.G_MISS_NUM THEN

431: ELSIF p_x_prd_workoper_rec.PLAN_ID IS NULL THEN
432: p_x_prd_workoper_rec.PLAN_ID:=l_old_operation_rec.PLAN_ID;
433: END IF;
434:
435: IF p_x_prd_workoper_rec.COLLECTION_ID= FND_API.G_MISS_NUM THEN
436: p_x_prd_workoper_rec.COLLECTION_ID:=NULL;
437: ELSIF p_x_prd_workoper_rec.COLLECTION_ID IS NULL THEN
438: p_x_prd_workoper_rec.COLLECTION_ID:=l_old_operation_rec.COLLECTION_ID;
439: END IF;

Line 441: IF p_x_prd_workoper_rec.OPERATION_DESCRIPTION= FND_API.G_MISS_CHAR THEN

437: ELSIF p_x_prd_workoper_rec.COLLECTION_ID IS NULL THEN
438: p_x_prd_workoper_rec.COLLECTION_ID:=l_old_operation_rec.COLLECTION_ID;
439: END IF;
440:
441: IF p_x_prd_workoper_rec.OPERATION_DESCRIPTION= FND_API.G_MISS_CHAR THEN
442: p_x_prd_workoper_rec.OPERATION_DESCRIPTION:=NULL;
443: ELSIF p_x_prd_workoper_rec.OPERATION_DESCRIPTION IS NULL THEN
444: p_x_prd_workoper_rec.OPERATION_DESCRIPTION:=l_old_operation_rec.DESCRIPTION;
445: END IF;

Line 447: IF p_x_prd_workoper_rec.ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR THEN

443: ELSIF p_x_prd_workoper_rec.OPERATION_DESCRIPTION IS NULL THEN
444: p_x_prd_workoper_rec.OPERATION_DESCRIPTION:=l_old_operation_rec.DESCRIPTION;
445: END IF;
446:
447: IF p_x_prd_workoper_rec.ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR THEN
448: p_x_prd_workoper_rec.ATTRIBUTE_CATEGORY:=NULL;
449: ELSIF p_x_prd_workoper_rec.ATTRIBUTE_CATEGORY IS NULL THEN
450: p_x_prd_workoper_rec.ATTRIBUTE_CATEGORY:=l_old_operation_rec.ATTRIBUTE_CATEGORY;
451: END IF;

Line 453: IF p_x_prd_workoper_rec.ATTRIBUTE1= FND_API.G_MISS_CHAR THEN

449: ELSIF p_x_prd_workoper_rec.ATTRIBUTE_CATEGORY IS NULL THEN
450: p_x_prd_workoper_rec.ATTRIBUTE_CATEGORY:=l_old_operation_rec.ATTRIBUTE_CATEGORY;
451: END IF;
452:
453: IF p_x_prd_workoper_rec.ATTRIBUTE1= FND_API.G_MISS_CHAR THEN
454: p_x_prd_workoper_rec.ATTRIBUTE1:=NULL;
455: ELSIF p_x_prd_workoper_rec.ATTRIBUTE1 IS NULL THEN
456: p_x_prd_workoper_rec.ATTRIBUTE1:=l_old_operation_rec.ATTRIBUTE1;
457: END IF;

Line 459: IF p_x_prd_workoper_rec.ATTRIBUTE2= FND_API.G_MISS_CHAR THEN

455: ELSIF p_x_prd_workoper_rec.ATTRIBUTE1 IS NULL THEN
456: p_x_prd_workoper_rec.ATTRIBUTE1:=l_old_operation_rec.ATTRIBUTE1;
457: END IF;
458:
459: IF p_x_prd_workoper_rec.ATTRIBUTE2= FND_API.G_MISS_CHAR THEN
460: p_x_prd_workoper_rec.ATTRIBUTE2:=NULL;
461: ELSIF p_x_prd_workoper_rec.ATTRIBUTE2 IS NULL THEN
462: p_x_prd_workoper_rec.ATTRIBUTE2:=l_old_operation_rec.ATTRIBUTE2;
463: END IF;

Line 465: IF p_x_prd_workoper_rec.ATTRIBUTE3= FND_API.G_MISS_CHAR THEN

461: ELSIF p_x_prd_workoper_rec.ATTRIBUTE2 IS NULL THEN
462: p_x_prd_workoper_rec.ATTRIBUTE2:=l_old_operation_rec.ATTRIBUTE2;
463: END IF;
464:
465: IF p_x_prd_workoper_rec.ATTRIBUTE3= FND_API.G_MISS_CHAR THEN
466: p_x_prd_workoper_rec.ATTRIBUTE3:=NULL;
467: ELSIF p_x_prd_workoper_rec.ATTRIBUTE3 IS NULL THEN
468: p_x_prd_workoper_rec.ATTRIBUTE3:=l_old_operation_rec.ATTRIBUTE3;
469: END IF;

Line 471: IF p_x_prd_workoper_rec.ATTRIBUTE4= FND_API.G_MISS_CHAR THEN

467: ELSIF p_x_prd_workoper_rec.ATTRIBUTE3 IS NULL THEN
468: p_x_prd_workoper_rec.ATTRIBUTE3:=l_old_operation_rec.ATTRIBUTE3;
469: END IF;
470:
471: IF p_x_prd_workoper_rec.ATTRIBUTE4= FND_API.G_MISS_CHAR THEN
472: p_x_prd_workoper_rec.ATTRIBUTE4:=NULL;
473: ELSIF p_x_prd_workoper_rec.ATTRIBUTE4 IS NULL THEN
474: p_x_prd_workoper_rec.ATTRIBUTE4:=l_old_operation_rec.ATTRIBUTE4;
475: END IF;

Line 477: IF p_x_prd_workoper_rec.ATTRIBUTE5= FND_API.G_MISS_CHAR THEN

473: ELSIF p_x_prd_workoper_rec.ATTRIBUTE4 IS NULL THEN
474: p_x_prd_workoper_rec.ATTRIBUTE4:=l_old_operation_rec.ATTRIBUTE4;
475: END IF;
476:
477: IF p_x_prd_workoper_rec.ATTRIBUTE5= FND_API.G_MISS_CHAR THEN
478: p_x_prd_workoper_rec.ATTRIBUTE5:=NULL;
479: ELSIF p_x_prd_workoper_rec.ATTRIBUTE5 IS NULL THEN
480: p_x_prd_workoper_rec.ATTRIBUTE5:=l_old_operation_rec.ATTRIBUTE5;
481: END IF;

Line 483: IF p_x_prd_workoper_rec.ATTRIBUTE6= FND_API.G_MISS_CHAR THEN

479: ELSIF p_x_prd_workoper_rec.ATTRIBUTE5 IS NULL THEN
480: p_x_prd_workoper_rec.ATTRIBUTE5:=l_old_operation_rec.ATTRIBUTE5;
481: END IF;
482:
483: IF p_x_prd_workoper_rec.ATTRIBUTE6= FND_API.G_MISS_CHAR THEN
484: p_x_prd_workoper_rec.ATTRIBUTE6:=NULL;
485: ELSIF p_x_prd_workoper_rec.ATTRIBUTE6 IS NULL THEN
486: p_x_prd_workoper_rec.ATTRIBUTE6:=l_old_operation_rec.ATTRIBUTE6;
487: END IF;

Line 489: IF p_x_prd_workoper_rec.ATTRIBUTE7= FND_API.G_MISS_CHAR THEN

485: ELSIF p_x_prd_workoper_rec.ATTRIBUTE6 IS NULL THEN
486: p_x_prd_workoper_rec.ATTRIBUTE6:=l_old_operation_rec.ATTRIBUTE6;
487: END IF;
488:
489: IF p_x_prd_workoper_rec.ATTRIBUTE7= FND_API.G_MISS_CHAR THEN
490: p_x_prd_workoper_rec.ATTRIBUTE7:=NULL;
491: ELSIF p_x_prd_workoper_rec.ATTRIBUTE7 IS NULL THEN
492: p_x_prd_workoper_rec.ATTRIBUTE7:=l_old_operation_rec.ATTRIBUTE7;
493: END IF;

Line 495: IF p_x_prd_workoper_rec.ATTRIBUTE8= FND_API.G_MISS_CHAR THEN

491: ELSIF p_x_prd_workoper_rec.ATTRIBUTE7 IS NULL THEN
492: p_x_prd_workoper_rec.ATTRIBUTE7:=l_old_operation_rec.ATTRIBUTE7;
493: END IF;
494:
495: IF p_x_prd_workoper_rec.ATTRIBUTE8= FND_API.G_MISS_CHAR THEN
496: p_x_prd_workoper_rec.ATTRIBUTE8:=NULL;
497: ELSIF p_x_prd_workoper_rec.ATTRIBUTE8 IS NULL THEN
498: p_x_prd_workoper_rec.ATTRIBUTE8:=l_old_operation_rec.ATTRIBUTE8;
499: END IF;

Line 501: IF p_x_prd_workoper_rec.ATTRIBUTE9= FND_API.G_MISS_CHAR THEN

497: ELSIF p_x_prd_workoper_rec.ATTRIBUTE8 IS NULL THEN
498: p_x_prd_workoper_rec.ATTRIBUTE8:=l_old_operation_rec.ATTRIBUTE8;
499: END IF;
500:
501: IF p_x_prd_workoper_rec.ATTRIBUTE9= FND_API.G_MISS_CHAR THEN
502: p_x_prd_workoper_rec.ATTRIBUTE9:=NULL;
503: ELSIF p_x_prd_workoper_rec.ATTRIBUTE9 IS NULL THEN
504: p_x_prd_workoper_rec.ATTRIBUTE9:=l_old_operation_rec.ATTRIBUTE9;
505: END IF;

Line 507: IF p_x_prd_workoper_rec.ATTRIBUTE10= FND_API.G_MISS_CHAR THEN

503: ELSIF p_x_prd_workoper_rec.ATTRIBUTE9 IS NULL THEN
504: p_x_prd_workoper_rec.ATTRIBUTE9:=l_old_operation_rec.ATTRIBUTE9;
505: END IF;
506:
507: IF p_x_prd_workoper_rec.ATTRIBUTE10= FND_API.G_MISS_CHAR THEN
508: p_x_prd_workoper_rec.ATTRIBUTE10:=NULL;
509: ELSIF p_x_prd_workoper_rec.ATTRIBUTE10 IS NULL THEN
510: p_x_prd_workoper_rec.ATTRIBUTE10:=l_old_operation_rec.ATTRIBUTE10;
511: END IF;

Line 513: IF p_x_prd_workoper_rec.ATTRIBUTE11= FND_API.G_MISS_CHAR THEN

509: ELSIF p_x_prd_workoper_rec.ATTRIBUTE10 IS NULL THEN
510: p_x_prd_workoper_rec.ATTRIBUTE10:=l_old_operation_rec.ATTRIBUTE10;
511: END IF;
512:
513: IF p_x_prd_workoper_rec.ATTRIBUTE11= FND_API.G_MISS_CHAR THEN
514: p_x_prd_workoper_rec.ATTRIBUTE11:=NULL;
515: ELSIF p_x_prd_workoper_rec.ATTRIBUTE11 IS NULL THEN
516: p_x_prd_workoper_rec.ATTRIBUTE11:=l_old_operation_rec.ATTRIBUTE11;
517: END IF;

Line 519: IF p_x_prd_workoper_rec.ATTRIBUTE12= FND_API.G_MISS_CHAR THEN

515: ELSIF p_x_prd_workoper_rec.ATTRIBUTE11 IS NULL THEN
516: p_x_prd_workoper_rec.ATTRIBUTE11:=l_old_operation_rec.ATTRIBUTE11;
517: END IF;
518:
519: IF p_x_prd_workoper_rec.ATTRIBUTE12= FND_API.G_MISS_CHAR THEN
520: p_x_prd_workoper_rec.ATTRIBUTE12:=NULL;
521: ELSIF p_x_prd_workoper_rec.ATTRIBUTE12 IS NULL THEN
522: p_x_prd_workoper_rec.ATTRIBUTE12:=l_old_operation_rec.ATTRIBUTE12;
523: END IF;

Line 525: IF p_x_prd_workoper_rec.ATTRIBUTE13= FND_API.G_MISS_CHAR THEN

521: ELSIF p_x_prd_workoper_rec.ATTRIBUTE12 IS NULL THEN
522: p_x_prd_workoper_rec.ATTRIBUTE12:=l_old_operation_rec.ATTRIBUTE12;
523: END IF;
524:
525: IF p_x_prd_workoper_rec.ATTRIBUTE13= FND_API.G_MISS_CHAR THEN
526: p_x_prd_workoper_rec.ATTRIBUTE13:=NULL;
527: ELSIF p_x_prd_workoper_rec.ATTRIBUTE13 IS NULL THEN
528: p_x_prd_workoper_rec.ATTRIBUTE13:=l_old_operation_rec.ATTRIBUTE13;
529: END IF;

Line 531: IF p_x_prd_workoper_rec.ATTRIBUTE14= FND_API.G_MISS_CHAR THEN

527: ELSIF p_x_prd_workoper_rec.ATTRIBUTE13 IS NULL THEN
528: p_x_prd_workoper_rec.ATTRIBUTE13:=l_old_operation_rec.ATTRIBUTE13;
529: END IF;
530:
531: IF p_x_prd_workoper_rec.ATTRIBUTE14= FND_API.G_MISS_CHAR THEN
532: p_x_prd_workoper_rec.ATTRIBUTE14:=NULL;
533: ELSIF p_x_prd_workoper_rec.ATTRIBUTE14 IS NULL THEN
534: p_x_prd_workoper_rec.ATTRIBUTE14:=l_old_operation_rec.ATTRIBUTE14;
535: END IF;

Line 537: IF p_x_prd_workoper_rec.ATTRIBUTE15= FND_API.G_MISS_CHAR THEN

533: ELSIF p_x_prd_workoper_rec.ATTRIBUTE14 IS NULL THEN
534: p_x_prd_workoper_rec.ATTRIBUTE14:=l_old_operation_rec.ATTRIBUTE14;
535: END IF;
536:
537: IF p_x_prd_workoper_rec.ATTRIBUTE15= FND_API.G_MISS_CHAR THEN
538: p_x_prd_workoper_rec.ATTRIBUTE15:=NULL;
539: ELSIF p_x_prd_workoper_rec.ATTRIBUTE15 IS NULL THEN
540: p_x_prd_workoper_rec.ATTRIBUTE15:=l_old_operation_rec.ATTRIBUTE15;
541: END IF;

Line 543: IF p_x_prd_workoper_rec.WORKORDER_OPERATION_ID= FND_API.G_MISS_NUM THEN

539: ELSIF p_x_prd_workoper_rec.ATTRIBUTE15 IS NULL THEN
540: p_x_prd_workoper_rec.ATTRIBUTE15:=l_old_operation_rec.ATTRIBUTE15;
541: END IF;
542:
543: IF p_x_prd_workoper_rec.WORKORDER_OPERATION_ID= FND_API.G_MISS_NUM THEN
544: p_x_prd_workoper_rec.WORKORDER_OPERATION_ID:=NULL;
545: ELSIF p_x_prd_workoper_rec.WORKORDER_OPERATION_ID IS NULL THEN
546: p_x_prd_workoper_rec.WORKORDER_OPERATION_ID:=l_old_operation_rec.WORKORDER_OPERATION_ID;
547: END IF;

Line 549: IF p_x_prd_workoper_rec.ORGANIZATION_ID= FND_API.G_MISS_NUM THEN

545: ELSIF p_x_prd_workoper_rec.WORKORDER_OPERATION_ID IS NULL THEN
546: p_x_prd_workoper_rec.WORKORDER_OPERATION_ID:=l_old_operation_rec.WORKORDER_OPERATION_ID;
547: END IF;
548:
549: IF p_x_prd_workoper_rec.ORGANIZATION_ID= FND_API.G_MISS_NUM THEN
550: p_x_prd_workoper_rec.ORGANIZATION_ID:=NULL;
551: ELSIF p_x_prd_workoper_rec.ORGANIZATION_ID IS NULL THEN
552: p_x_prd_workoper_rec.ORGANIZATION_ID:=l_old_operation_rec.ORGANIZATION_ID;
553: END IF;

Line 555: IF p_x_prd_workoper_rec.OPERATION_SEQUENCE_NUM= FND_API.G_MISS_NUM THEN

551: ELSIF p_x_prd_workoper_rec.ORGANIZATION_ID IS NULL THEN
552: p_x_prd_workoper_rec.ORGANIZATION_ID:=l_old_operation_rec.ORGANIZATION_ID;
553: END IF;
554:
555: IF p_x_prd_workoper_rec.OPERATION_SEQUENCE_NUM= FND_API.G_MISS_NUM THEN
556: p_x_prd_workoper_rec.OPERATION_SEQUENCE_NUM:=NULL;
557: ELSIF p_x_prd_workoper_rec.OPERATION_SEQUENCE_NUM IS NULL THEN
558: p_x_prd_workoper_rec.OPERATION_SEQUENCE_NUM:=l_old_operation_rec.OPERATION_SEQUENCE_NUM;
559: END IF;

Line 561: IF p_x_prd_workoper_rec.WORKORDER_ID= FND_API.G_MISS_NUM THEN

557: ELSIF p_x_prd_workoper_rec.OPERATION_SEQUENCE_NUM IS NULL THEN
558: p_x_prd_workoper_rec.OPERATION_SEQUENCE_NUM:=l_old_operation_rec.OPERATION_SEQUENCE_NUM;
559: END IF;
560:
561: IF p_x_prd_workoper_rec.WORKORDER_ID= FND_API.G_MISS_NUM THEN
562: p_x_prd_workoper_rec.WORKORDER_ID:=NULL;
563: ELSIF p_x_prd_workoper_rec.WORKORDER_ID IS NULL THEN
564: p_x_prd_workoper_rec.WORKORDER_ID:=l_old_operation_rec.WORKORDER_ID;
565: END IF;

Line 567: IF p_x_prd_workoper_rec.WIP_ENTITY_ID= FND_API.G_MISS_NUM THEN

563: ELSIF p_x_prd_workoper_rec.WORKORDER_ID IS NULL THEN
564: p_x_prd_workoper_rec.WORKORDER_ID:=l_old_operation_rec.WORKORDER_ID;
565: END IF;
566:
567: IF p_x_prd_workoper_rec.WIP_ENTITY_ID= FND_API.G_MISS_NUM THEN
568: p_x_prd_workoper_rec.WIP_ENTITY_ID:=NULL;
569: ELSIF p_x_prd_workoper_rec.WIP_ENTITY_ID IS NULL THEN
570: p_x_prd_workoper_rec.WIP_ENTITY_ID:=l_old_operation_rec.WIP_ENTITY_ID;
571: END IF;

Line 573: IF p_x_prd_workoper_rec.OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM THEN

569: ELSIF p_x_prd_workoper_rec.WIP_ENTITY_ID IS NULL THEN
570: p_x_prd_workoper_rec.WIP_ENTITY_ID:=l_old_operation_rec.WIP_ENTITY_ID;
571: END IF;
572:
573: IF p_x_prd_workoper_rec.OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM THEN
574: p_x_prd_workoper_rec.OBJECT_VERSION_NUMBER:=NULL;
575: ELSIF p_x_prd_workoper_rec.OBJECT_VERSION_NUMBER IS NULL THEN
576: p_x_prd_workoper_rec.OBJECT_VERSION_NUMBER:=l_old_operation_rec.OBJECT_VERSION_NUMBER;
577: END IF;

Line 579: IF p_x_prd_workoper_rec.LAST_UPDATE_DATE=FND_API.G_MISS_DATE THEN

575: ELSIF p_x_prd_workoper_rec.OBJECT_VERSION_NUMBER IS NULL THEN
576: p_x_prd_workoper_rec.OBJECT_VERSION_NUMBER:=l_old_operation_rec.OBJECT_VERSION_NUMBER;
577: END IF;
578:
579: IF p_x_prd_workoper_rec.LAST_UPDATE_DATE=FND_API.G_MISS_DATE THEN
580: p_x_prd_workoper_rec.LAST_UPDATE_DATE:=NULL;
581: ELSIF p_x_prd_workoper_rec.LAST_UPDATE_DATE IS NULL THEN
582: p_x_prd_workoper_rec.LAST_UPDATE_DATE:=l_old_operation_rec.LAST_UPDATE_DATE;
583: END IF;

Line 585: IF p_x_prd_workoper_rec.LAST_UPDATED_BY= FND_API.G_MISS_NUM THEN

581: ELSIF p_x_prd_workoper_rec.LAST_UPDATE_DATE IS NULL THEN
582: p_x_prd_workoper_rec.LAST_UPDATE_DATE:=l_old_operation_rec.LAST_UPDATE_DATE;
583: END IF;
584:
585: IF p_x_prd_workoper_rec.LAST_UPDATED_BY= FND_API.G_MISS_NUM THEN
586: p_x_prd_workoper_rec.LAST_UPDATED_BY:=NULL;
587: ELSIF p_x_prd_workoper_rec.LAST_UPDATED_BY IS NULL THEN
588: p_x_prd_workoper_rec.LAST_UPDATED_BY:=l_old_operation_rec.LAST_UPDATED_BY;
589: END IF;

Line 591: IF p_x_prd_workoper_rec.CREATION_DATE=FND_API.G_MISS_DATE THEN

587: ELSIF p_x_prd_workoper_rec.LAST_UPDATED_BY IS NULL THEN
588: p_x_prd_workoper_rec.LAST_UPDATED_BY:=l_old_operation_rec.LAST_UPDATED_BY;
589: END IF;
590:
591: IF p_x_prd_workoper_rec.CREATION_DATE=FND_API.G_MISS_DATE THEN
592: p_x_prd_workoper_rec.CREATION_DATE:=NULL;
593: ELSIF p_x_prd_workoper_rec.CREATION_DATE IS NULL THEN
594: p_x_prd_workoper_rec.CREATION_DATE:=l_old_operation_rec.CREATION_DATE;
595: END IF;

Line 597: IF p_x_prd_workoper_rec.CREATED_BY= FND_API.G_MISS_NUM THEN

593: ELSIF p_x_prd_workoper_rec.CREATION_DATE IS NULL THEN
594: p_x_prd_workoper_rec.CREATION_DATE:=l_old_operation_rec.CREATION_DATE;
595: END IF;
596:
597: IF p_x_prd_workoper_rec.CREATED_BY= FND_API.G_MISS_NUM THEN
598: p_x_prd_workoper_rec.CREATED_BY:=NULL;
599: ELSIF p_x_prd_workoper_rec.CREATED_BY IS NULL THEN
600: p_x_prd_workoper_rec.CREATED_BY:=l_old_operation_rec.CREATED_BY;
601: END IF;

Line 603: IF p_x_prd_workoper_rec.LAST_UPDATE_LOGIN= FND_API.G_MISS_NUM THEN

599: ELSIF p_x_prd_workoper_rec.CREATED_BY IS NULL THEN
600: p_x_prd_workoper_rec.CREATED_BY:=l_old_operation_rec.CREATED_BY;
601: END IF;
602:
603: IF p_x_prd_workoper_rec.LAST_UPDATE_LOGIN= FND_API.G_MISS_NUM THEN
604: p_x_prd_workoper_rec.LAST_UPDATE_LOGIN:=NULL;
605: ELSIF p_x_prd_workoper_rec.LAST_UPDATE_LOGIN IS NULL THEN
606: p_x_prd_workoper_rec.LAST_UPDATE_LOGIN:=l_old_operation_rec.LAST_UPDATE_LOGIN;
607: END IF;

Line 706: p_operation_code <> FND_API.G_MISS_CHAR

702: --AND p_operation_id IS NULL
703: AND
704: p_operation_code IS NOT NULL
705: AND
706: p_operation_code <> FND_API.G_MISS_CHAR
707: )
708: THEN
709: OPEN c_get_wo_op(p_wo_op_id);
710: FETCH c_get_wo_op INTO l_existing_op_code;

Line 820: p_x_prd_workoper_rec.OPERATION_CODE<>FND_API.G_MISS_CHAR THEN

816: BEGIN
817: /*
818: -- Bug # 6717357 -- start
819: IF p_x_prd_workoper_rec.OPERATION_CODE IS NOT NULL AND
820: p_x_prd_workoper_rec.OPERATION_CODE<>FND_API.G_MISS_CHAR THEN
821: OPEN get_operation(p_x_prd_workoper_rec.OPERATION_CODE);
822: FETCH get_operation INTO p_x_prd_workoper_rec.OPERATION_ID;
823:
824: IF get_operation%NOTFOUND THEN

Line 856: p_x_prd_workoper_rec.department_name<>FND_API.G_MISS_CHAR THEN

852: p_x_prd_workoper_rec.OPERATION_ID := l_operation_id;
853: END IF;
854: -- Added following code for Bug # 6717357 -- End
855: IF p_x_prd_workoper_rec.department_name IS NOT NULL AND
856: p_x_prd_workoper_rec.department_name<>FND_API.G_MISS_CHAR THEN
857: OPEN get_department(p_x_prd_workoper_rec.department_name,p_x_prd_workoper_rec.organization_id);
858: FETCH get_department INTO l_dept_rec;
859:
860: IF get_department%NOTFOUND THEN

Line 872: p_x_prd_workoper_rec.OPERATION_TYPE<>FND_API.G_MISS_CHAR THEN

868: CLOSE get_department;
869: END IF;
870:
871: IF p_x_prd_workoper_rec.OPERATION_TYPE IS NOT NULL AND
872: p_x_prd_workoper_rec.OPERATION_TYPE<>FND_API.G_MISS_CHAR THEN
873: OPEN get_operation_type(p_x_prd_workoper_rec.OPERATION_TYPE);
874: FETCH get_operation_type INTO p_x_prd_workoper_rec.OPERATION_TYPE_CODE;
875:
876: IF get_operation_type%NOTFOUND THEN

Line 894: p_x_prd_workoper_rec.SCHEDULED_START_DATE <> FND_API.G_MISS_DATE THEN

890: AHL_DEBUG_PUB.debug( 'p_x_prd_workoper_rec.SCHEDULED_START_DATE : ' || to_char(p_x_prd_workoper_rec.SCHEDULED_START_DATE,'DD-MON-YY hh24:mi:ss') );
891: END IF;
892:
893: IF p_x_prd_workoper_rec.SCHEDULED_START_DATE IS NOT NULL AND
894: p_x_prd_workoper_rec.SCHEDULED_START_DATE <> FND_API.G_MISS_DATE THEN
895:
896: l_sec := TO_CHAR(p_x_prd_workoper_rec.SCHEDULED_START_DATE, 'ss');
897: IF(l_sec = '00' AND p_module_type <> 'OAF' ) THEN
898: l_sec := l_sch_start_sec;

Line 912: p_x_prd_workoper_rec.SCHEDULED_END_DATE <> FND_API.G_MISS_DATE THEN

908: END IF;
909: END IF;
910:
911: IF p_x_prd_workoper_rec.SCHEDULED_END_DATE IS NOT NULL AND
912: p_x_prd_workoper_rec.SCHEDULED_END_DATE <> FND_API.G_MISS_DATE THEN
913:
914: l_sec := TO_CHAR(p_x_prd_workoper_rec.SCHEDULED_END_DATE, 'ss');
915: IF(l_sec = '00' AND p_module_type <> 'OAF' ) THEN
916: l_sec := l_sch_end_sec;

Line 935: p_x_prd_workoper_rec.ACTUAL_START_DATE <> FND_API.G_MISS_DATE THEN

931: FETCH get_op_act_sec INTO l_act_start_sec, l_act_end_sec;
932: CLOSE get_op_act_sec;
933:
934: IF p_x_prd_workoper_rec.ACTUAL_START_DATE IS NOT NULL AND
935: p_x_prd_workoper_rec.ACTUAL_START_DATE <> FND_API.G_MISS_DATE THEN
936:
937: l_sec := TO_CHAR(p_x_prd_workoper_rec.ACTUAL_START_DATE, 'ss');
938: IF(l_sec = '00' AND p_module_type <> 'OAF' ) THEN
939: l_sec := l_act_start_sec;

Line 953: p_x_prd_workoper_rec.ACTUAL_END_DATE <> FND_API.G_MISS_DATE THEN

949: END IF;
950: END IF;
951:
952: IF p_x_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL AND
953: p_x_prd_workoper_rec.ACTUAL_END_DATE <> FND_API.G_MISS_DATE THEN
954:
955: l_sec := TO_CHAR(p_x_prd_workoper_rec.ACTUAL_END_DATE, 'ss');
956: IF(l_sec = '00' AND p_module_type <> 'OAF' ) THEN
957: l_sec := l_act_end_sec;

Line 1075: IF l_return_status = FND_API.G_TRUE THEN

1071: -- ACL Changes
1072: /*l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => p_prd_workoper_rec.workorder_id, p_ue_id => NULL,
1073: p_visit_id => NULL,
1074: p_item_instance_id => NULL);
1075: IF l_return_status = FND_API.G_TRUE THEN
1076: IF p_prd_workoper_rec.dml_operation='C' THEN
1077: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_OP_CRT_UNTLCKD');
1078: ELSIF p_prd_workoper_rec.dml_operation='U' THEN
1079: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_OP_UPD_UNTLCKD');

Line 1082: RAISE FND_API.G_EXC_ERROR;

1078: ELSIF p_prd_workoper_rec.dml_operation='U' THEN
1079: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_OP_UPD_UNTLCKD');
1080: END IF;
1081: FND_MSG_PUB.ADD;
1082: RAISE FND_API.G_EXC_ERROR;
1083: END IF;
1084: */
1085: -- rroy
1086: -- ACL Changes

Line 1089: p_prd_workoper_rec.DEPARTMENT_ID=FND_API.G_MISS_NUM THEN

1085: -- rroy
1086: -- ACL Changes
1087:
1088: IF p_prd_workoper_rec.DEPARTMENT_ID IS NULL OR
1089: p_prd_workoper_rec.DEPARTMENT_ID=FND_API.G_MISS_NUM THEN
1090: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_DEPT_ID_NULL');
1091: FND_MSG_PUB.ADD;
1092: END IF;
1093:

Line 1095: p_prd_workoper_rec.SCHEDULED_START_DATE=FND_API.G_MISS_DATE THEN

1091: FND_MSG_PUB.ADD;
1092: END IF;
1093:
1094: IF p_prd_workoper_rec.SCHEDULED_START_DATE IS NULL OR
1095: p_prd_workoper_rec.SCHEDULED_START_DATE=FND_API.G_MISS_DATE THEN
1096: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_SCHEDSTART_DT_NULL');
1097: FND_MSG_PUB.ADD;
1098: ELSIF p_prd_workoper_rec.SCHEDULED_END_DATE IS NULL OR
1099: p_prd_workoper_rec.SCHEDULED_END_DATE=FND_API.G_MISS_DATE THEN

Line 1099: p_prd_workoper_rec.SCHEDULED_END_DATE=FND_API.G_MISS_DATE THEN

1095: p_prd_workoper_rec.SCHEDULED_START_DATE=FND_API.G_MISS_DATE THEN
1096: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_SCHEDSTART_DT_NULL');
1097: FND_MSG_PUB.ADD;
1098: ELSIF p_prd_workoper_rec.SCHEDULED_END_DATE IS NULL OR
1099: p_prd_workoper_rec.SCHEDULED_END_DATE=FND_API.G_MISS_DATE THEN
1100: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_SCHEDEND_DT_NULL');
1101: FND_MSG_PUB.ADD;
1102: ELSIF NVL(p_prd_workoper_rec.SCHEDULED_START_DATE,SYSDATE) > NVL(p_prd_workoper_rec.SCHEDULED_END_DATE,SYSDATE) THEN
1103: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_SCHEDDTS_INVALID_DT');

Line 1108: p_prd_workoper_rec.ACTUAL_START_DATE <> FND_API.G_MISS_DATE AND

1104: FND_MSG_PUB.ADD;
1105: END IF;
1106:
1107: IF p_prd_workoper_rec.ACTUAL_START_DATE IS NOT NULL AND
1108: p_prd_workoper_rec.ACTUAL_START_DATE <> FND_API.G_MISS_DATE AND
1109: p_prd_workoper_rec.ACTUAL_START_DATE > SYSDATE THEN
1110: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_STRT_DT_INVALID');
1111: FND_MSG_PUB.ADD;
1112: END IF;

Line 1115: p_prd_workoper_rec.ACTUAL_START_DATE=FND_API.G_MISS_DATE) AND

1111: FND_MSG_PUB.ADD;
1112: END IF;
1113:
1114: IF (p_prd_workoper_rec.ACTUAL_START_DATE IS NULL OR
1115: p_prd_workoper_rec.ACTUAL_START_DATE=FND_API.G_MISS_DATE) AND
1116: (p_prd_workoper_rec.ACTUAL_END_DATE<>FND_API.G_MISS_DATE AND
1117: p_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL) THEN
1118: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_START_DT_NULL');
1119: FND_MESSAGE.SET_TOKEN('RECORD',p_prd_workoper_rec.operation_sequence_num,false);

Line 1116: (p_prd_workoper_rec.ACTUAL_END_DATE<>FND_API.G_MISS_DATE AND

1112: END IF;
1113:
1114: IF (p_prd_workoper_rec.ACTUAL_START_DATE IS NULL OR
1115: p_prd_workoper_rec.ACTUAL_START_DATE=FND_API.G_MISS_DATE) AND
1116: (p_prd_workoper_rec.ACTUAL_END_DATE<>FND_API.G_MISS_DATE AND
1117: p_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL) THEN
1118: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_START_DT_NULL');
1119: FND_MESSAGE.SET_TOKEN('RECORD',p_prd_workoper_rec.operation_sequence_num,false);
1120: FND_MSG_PUB.ADD;

Line 1124: p_prd_workoper_rec.ACTUAL_START_DATE<>FND_API.G_MISS_DATE AND

1120: FND_MSG_PUB.ADD;
1121: END IF;
1122:
1123: IF p_prd_workoper_rec.ACTUAL_START_DATE IS NOT NULL AND
1124: p_prd_workoper_rec.ACTUAL_START_DATE<>FND_API.G_MISS_DATE AND
1125: p_prd_workoper_rec.ACTUAL_END_DATE<>FND_API.G_MISS_DATE AND
1126: p_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL AND
1127: p_prd_workoper_rec.ACTUAL_START_DATE > p_prd_workoper_rec.ACTUAL_END_DATE THEN
1128: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_SE_DT_INVALID');

Line 1125: p_prd_workoper_rec.ACTUAL_END_DATE<>FND_API.G_MISS_DATE AND

1121: END IF;
1122:
1123: IF p_prd_workoper_rec.ACTUAL_START_DATE IS NOT NULL AND
1124: p_prd_workoper_rec.ACTUAL_START_DATE<>FND_API.G_MISS_DATE AND
1125: p_prd_workoper_rec.ACTUAL_END_DATE<>FND_API.G_MISS_DATE AND
1126: p_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL AND
1127: p_prd_workoper_rec.ACTUAL_START_DATE > p_prd_workoper_rec.ACTUAL_END_DATE THEN
1128: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_SE_DT_INVALID');
1129: FND_MSG_PUB.ADD;

Line 1133: p_prd_workoper_rec.ACTUAL_END_DATE <> FND_API.G_MISS_DATE AND

1129: FND_MSG_PUB.ADD;
1130: END IF;
1131:
1132: IF p_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL AND
1133: p_prd_workoper_rec.ACTUAL_END_DATE <> FND_API.G_MISS_DATE AND
1134: TRUNC( p_prd_workoper_rec.ACTUAL_END_DATE ) > TRUNC( SYSDATE ) THEN
1135: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_END_DT_INVALID');
1136: FND_MSG_PUB.ADD;
1137: END IF;

Line 1145: p_prd_workoper_rec.actual_start_date <> FND_API.G_MISS_DATE AND

1141: FETCH get_wo_actual_dates INTO l_wo_actual_start_date, l_wo_actual_end_date;
1142: CLOSE get_wo_actual_dates;
1143:
1144: IF ( p_prd_workoper_rec.actual_start_date IS NOT NULL AND
1145: p_prd_workoper_rec.actual_start_date <> FND_API.G_MISS_DATE AND
1146: l_wo_actual_start_date IS NOT NULL AND
1147: p_prd_workoper_rec.actual_start_date < l_wo_actual_start_date ) THEN
1148: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_OP_WO_ST_DT' );
1149: FND_MSG_PUB.add;

Line 1153: p_prd_workoper_rec.actual_end_date <> FND_API.G_MISS_DATE AND

1149: FND_MSG_PUB.add;
1150: END IF;
1151:
1152: IF ( p_prd_workoper_rec.actual_end_date IS NOT NULL AND
1153: p_prd_workoper_rec.actual_end_date <> FND_API.G_MISS_DATE AND
1154: l_wo_actual_end_date IS NOT NULL AND
1155: p_prd_workoper_rec.actual_end_date > l_wo_actual_end_date ) THEN
1156: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_OP_WO_END_DT' );
1157: FND_MSG_PUB.add;

Line 1161: p_prd_workoper_rec.OPERATION_SEQUENCE_NUM=FND_API.G_MISS_NUM THEN

1157: FND_MSG_PUB.add;
1158: END IF;
1159:
1160: IF p_prd_workoper_rec.OPERATION_SEQUENCE_NUM IS NULL OR
1161: p_prd_workoper_rec.OPERATION_SEQUENCE_NUM=FND_API.G_MISS_NUM THEN
1162: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_SEQ_NULL');
1163: FND_MSG_PUB.ADD;
1164: ELSIF p_prd_workoper_rec.OPERATION_SEQUENCE_NUM <=0 THEN
1165: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_SEQ_NEGZERO');

Line 1182: p_prd_workoper_rec.WORKORDER_OPERATION_ID=FND_API.G_MISS_NUM THEN

1178: END IF;
1179:
1180: IF p_prd_workoper_rec.dml_operation='U' THEN
1181: IF p_prd_workoper_rec.WORKORDER_OPERATION_ID IS NULL OR
1182: p_prd_workoper_rec.WORKORDER_OPERATION_ID=FND_API.G_MISS_NUM THEN
1183: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_OPERID_NULL');
1184: FND_MSG_PUB.ADD;
1185: END IF;
1186: END IF;

Line 1189: p_prd_workoper_rec.ORGANIZATION_ID<>FND_API.G_MISS_NUM AND

1185: END IF;
1186: END IF;
1187:
1188: IF p_prd_workoper_rec.ORGANIZATION_ID IS NOT NULL AND
1189: p_prd_workoper_rec.ORGANIZATION_ID<>FND_API.G_MISS_NUM AND
1190: p_prd_workoper_rec.DEPARTMENT_ID IS NOT NULL AND
1191: p_prd_workoper_rec.DEPARTMENT_ID<>FND_API.G_MISS_NUM THEN
1192: OPEN validate_department(p_prd_workoper_rec.DEPARTMENT_ID,p_prd_workoper_rec.ORGANIZATION_ID);
1193: FETCH validate_department INTO l_eam_enabled_flag;

Line 1191: p_prd_workoper_rec.DEPARTMENT_ID<>FND_API.G_MISS_NUM THEN

1187:
1188: IF p_prd_workoper_rec.ORGANIZATION_ID IS NOT NULL AND
1189: p_prd_workoper_rec.ORGANIZATION_ID<>FND_API.G_MISS_NUM AND
1190: p_prd_workoper_rec.DEPARTMENT_ID IS NOT NULL AND
1191: p_prd_workoper_rec.DEPARTMENT_ID<>FND_API.G_MISS_NUM THEN
1192: OPEN validate_department(p_prd_workoper_rec.DEPARTMENT_ID,p_prd_workoper_rec.ORGANIZATION_ID);
1193: FETCH validate_department INTO l_eam_enabled_flag;
1194:
1195: IF validate_department%NOTFOUND THEN

Line 1210: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1206:
1207: PROCEDURE process_operations
1208: (
1209: p_api_version IN NUMBER := 1.0,
1210: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1211: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1212: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1213: p_default IN VARCHAR2 := FND_API.G_FALSE,
1214: p_module_type IN VARCHAR2,

Line 1211: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1207: PROCEDURE process_operations
1208: (
1209: p_api_version IN NUMBER := 1.0,
1210: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1211: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1212: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1213: p_default IN VARCHAR2 := FND_API.G_FALSE,
1214: p_module_type IN VARCHAR2,
1215: p_wip_mass_load_flag IN VARCHAR2,

Line 1212: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1208: (
1209: p_api_version IN NUMBER := 1.0,
1210: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1211: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1212: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1213: p_default IN VARCHAR2 := FND_API.G_FALSE,
1214: p_module_type IN VARCHAR2,
1215: p_wip_mass_load_flag IN VARCHAR2,
1216: x_return_status OUT NOCOPY VARCHAR2,

Line 1213: p_default IN VARCHAR2 := FND_API.G_FALSE,

1209: p_api_version IN NUMBER := 1.0,
1210: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1211: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1212: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1213: p_default IN VARCHAR2 := FND_API.G_FALSE,
1214: p_module_type IN VARCHAR2,
1215: p_wip_mass_load_flag IN VARCHAR2,
1216: x_return_status OUT NOCOPY VARCHAR2,
1217: x_msg_count OUT NOCOPY NUMBER,

Line 1249: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

1245: BEGIN
1246: SAVEPOINT process_operations_PVT;
1247:
1248: -- Initialize message list IF p_init_msg_list is set to TRUE.
1249: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1250: p_api_version,
1251: l_api_name,G_PKG_NAME) THEN
1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1253: END IF;

Line 1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1248: -- Initialize message list IF p_init_msg_list is set to TRUE.
1249: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1250: p_api_version,
1251: l_api_name,G_PKG_NAME) THEN
1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1253: END IF;
1254:
1255: IF FND_API.to_boolean(p_init_msg_list) THEN
1256: FND_MSG_PUB.initialize;

Line 1255: IF FND_API.to_boolean(p_init_msg_list) THEN

1251: l_api_name,G_PKG_NAME) THEN
1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1253: END IF;
1254:
1255: IF FND_API.to_boolean(p_init_msg_list) THEN
1256: FND_MSG_PUB.initialize;
1257: END IF;
1258:
1259: x_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 1259: x_return_status:=FND_API.G_RET_STS_SUCCESS;

1255: IF FND_API.to_boolean(p_init_msg_list) THEN
1256: FND_MSG_PUB.initialize;
1257: END IF;
1258:
1259: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1260:
1261: IF G_DEBUG='Y' THEN
1262: AHL_DEBUG_PUB.enable_debug;
1263: END IF;

Line 1269: IF FND_API.to_boolean(p_default) THEN

1265: IF ( G_DEBUG = 'Y' ) THEN
1266: AHL_DEBUG_PUB.debug( l_api_name || ' - Total number of Operations - ' || p_x_prd_operation_tbl.COUNT );
1267: END IF;
1268:
1269: IF FND_API.to_boolean(p_default) THEN
1270: IF p_x_prd_operation_tbl.COUNT >0 THEN
1271: FOR i in p_x_prd_operation_tbl.FIRST..p_x_prd_operation_tbl.LAST
1272: LOOP
1273:

Line 1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1316: l_msg_count:=FND_MSG_PUB.count_msg;
1317:
1318: IF l_msg_count > 0 THEN
1319: x_msg_count := l_msg_count;
1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1321: IF p_wip_mass_load_flag<>'Y' THEN
1322: RETURN;
1323: END IF;
1324: END IF;

Line 1331: x_return_status:=FND_API.G_RET_STS_SUCCESS;

1327:
1328: IF p_x_prd_operation_tbl.COUNT >0 THEN
1329: FOR i IN p_x_prd_operation_tbl.FIRST..p_x_prd_operation_tbl.LAST
1330: LOOP
1331: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1332:
1333: IF ( G_DEBUG = 'Y' ) THEN
1334: AHL_DEBUG_PUB.debug( l_api_name || ' - Before validate_operation' );
1335: END IF;

Line 1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1341:
1342: l_msg_count:=FND_MSG_PUB.count_msg;
1343: IF l_msg_count > 0 THEN
1344: x_msg_count := l_msg_count;
1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1346: END IF;
1347:
1348: IF x_return_status=FND_API.G_RET_STS_SUCCESS THEN
1349:

Line 1348: IF x_return_status=FND_API.G_RET_STS_SUCCESS THEN

1344: x_msg_count := l_msg_count;
1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1346: END IF;
1347:
1348: IF x_return_status=FND_API.G_RET_STS_SUCCESS THEN
1349:
1350: IF p_x_prd_operation_tbl(i).dml_operation='C' THEN
1351:
1352: IF ( G_DEBUG = 'Y' ) THEN

Line 1457: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1453: (
1454: p_workorder_id => p_x_prd_operation_tbl(I).WORKORDER_ID,
1455: p_workorder_op_id => p_x_prd_operation_tbl(I).WORKORDER_OPERATION_ID,
1456: p_new_status_code => p_x_prd_operation_tbl(I).STATUS_CODE,
1457: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1458: p_default => FND_API.G_TRUE,
1459: p_module_type => Null,
1460: x_return_status => l_return_status
1461: );

Line 1458: p_default => FND_API.G_TRUE,

1454: p_workorder_id => p_x_prd_operation_tbl(I).WORKORDER_ID,
1455: p_workorder_op_id => p_x_prd_operation_tbl(I).WORKORDER_OPERATION_ID,
1456: p_new_status_code => p_x_prd_operation_tbl(I).STATUS_CODE,
1457: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1458: p_default => FND_API.G_TRUE,
1459: p_module_type => Null,
1460: x_return_status => l_return_status
1461: );
1462: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

Line 1462: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1458: p_default => FND_API.G_TRUE,
1459: p_module_type => Null,
1460: x_return_status => l_return_status
1461: );
1462: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;
1465: END IF;
1466: --sukhwsin::VEE Code Changes - end

Line 1463: RAISE FND_API.G_EXC_ERROR;

1459: p_module_type => Null,
1460: x_return_status => l_return_status
1461: );
1462: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;
1465: END IF;
1466: --sukhwsin::VEE Code Changes - end
1467: UPDATE AHL_WORKORDER_OPERATIONS SET

Line 1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1506: l_msg_count:=FND_MSG_PUB.count_msg;
1507:
1508: IF l_msg_count > 0 THEN
1509: x_msg_count := l_msg_count;
1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1511:
1512: IF p_wip_mass_load_flag='Y' THEN
1513: RAISE FND_API.G_EXC_ERROR;
1514: ELSE

Line 1513: RAISE FND_API.G_EXC_ERROR;

1509: x_msg_count := l_msg_count;
1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1511:
1512: IF p_wip_mass_load_flag='Y' THEN
1513: RAISE FND_API.G_EXC_ERROR;
1514: ELSE
1515: RETURN;
1516: END IF;
1517:

Line 1529: p_init_msg_list => FND_API.G_TRUE ,

1525:
1526: AHL_EAM_JOB_PVT.update_job_operations
1527: (
1528: p_api_version => 1.0 ,
1529: p_init_msg_list => FND_API.G_TRUE ,
1530: p_commit => FND_API.G_FALSE ,
1531: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
1532: p_default => FND_API.G_TRUE ,
1533: p_module_type => NULL ,

Line 1530: p_commit => FND_API.G_FALSE ,

1526: AHL_EAM_JOB_PVT.update_job_operations
1527: (
1528: p_api_version => 1.0 ,
1529: p_init_msg_list => FND_API.G_TRUE ,
1530: p_commit => FND_API.G_FALSE ,
1531: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
1532: p_default => FND_API.G_TRUE ,
1533: p_module_type => NULL ,
1534: x_return_status => l_return_status ,

Line 1531: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,

1527: (
1528: p_api_version => 1.0 ,
1529: p_init_msg_list => FND_API.G_TRUE ,
1530: p_commit => FND_API.G_FALSE ,
1531: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
1532: p_default => FND_API.G_TRUE ,
1533: p_module_type => NULL ,
1534: x_return_status => l_return_status ,
1535: x_msg_count => l_msg_count ,

Line 1532: p_default => FND_API.G_TRUE ,

1528: p_api_version => 1.0 ,
1529: p_init_msg_list => FND_API.G_TRUE ,
1530: p_commit => FND_API.G_FALSE ,
1531: p_validation_level => FND_API.G_VALID_LEVEL_FULL ,
1532: p_default => FND_API.G_TRUE ,
1533: p_module_type => NULL ,
1534: x_return_status => l_return_status ,
1535: x_msg_count => l_msg_count ,
1536: x_msg_data => l_msg_data ,

Line 1543: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1539: p_material_req_tbl => l_material_tbl ,
1540: p_resource_req_tbl => l_resource_tbl
1541: );
1542:
1543: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: END IF;
1546: END IF; -- IF p_wip_mass_load_flag='Y' THEN
1547:

Line 1544: RAISE FND_API.G_EXC_ERROR;

1540: p_resource_req_tbl => l_resource_tbl
1541: );
1542:
1543: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: END IF;
1546: END IF; -- IF p_wip_mass_load_flag='Y' THEN
1547:
1548: -- R12

Line 1555: p_init_msg_list => FND_API.G_TRUE,

1551: IF l_prd_operation_tbl.COUNT > 0 THEN
1552: FOR j in l_prd_operation_tbl.FIRST..l_prd_operation_tbl.LAST LOOP
1553: AHL_COMPLETIONS_PVT.complete_operation
1554: (p_api_version => 1.0,
1555: p_init_msg_list => FND_API.G_TRUE,
1556: p_commit => FND_API.G_FALSE,
1557: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1558: p_default => FND_API.G_FALSE,
1559: x_return_status => l_return_status,

Line 1556: p_commit => FND_API.G_FALSE,

1552: FOR j in l_prd_operation_tbl.FIRST..l_prd_operation_tbl.LAST LOOP
1553: AHL_COMPLETIONS_PVT.complete_operation
1554: (p_api_version => 1.0,
1555: p_init_msg_list => FND_API.G_TRUE,
1556: p_commit => FND_API.G_FALSE,
1557: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1558: p_default => FND_API.G_FALSE,
1559: x_return_status => l_return_status,
1560: x_msg_count => l_msg_count,

Line 1557: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1553: AHL_COMPLETIONS_PVT.complete_operation
1554: (p_api_version => 1.0,
1555: p_init_msg_list => FND_API.G_TRUE,
1556: p_commit => FND_API.G_FALSE,
1557: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1558: p_default => FND_API.G_FALSE,
1559: x_return_status => l_return_status,
1560: x_msg_count => l_msg_count,
1561: x_msg_data => l_msg_data,

Line 1558: p_default => FND_API.G_FALSE,

1554: (p_api_version => 1.0,
1555: p_init_msg_list => FND_API.G_TRUE,
1556: p_commit => FND_API.G_FALSE,
1557: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1558: p_default => FND_API.G_FALSE,
1559: x_return_status => l_return_status,
1560: x_msg_count => l_msg_count,
1561: x_msg_data => l_msg_data,
1562: p_workorder_operation_id => l_prd_operation_tbl(j).workorder_operation_id,

Line 1565: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1561: x_msg_data => l_msg_data,
1562: p_workorder_operation_id => l_prd_operation_tbl(j).workorder_operation_id,
1563: p_object_version_no => l_prd_operation_tbl(j).object_version_number
1564: );
1565: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1566: RAISE FND_API.G_EXC_ERROR;
1567: END IF;
1568: END LOOP;
1569: END IF; -- IF l_prd_operation_tbl.COUNT > 0 THEN

Line 1566: RAISE FND_API.G_EXC_ERROR;

1562: p_workorder_operation_id => l_prd_operation_tbl(j).workorder_operation_id,
1563: p_object_version_no => l_prd_operation_tbl(j).object_version_number
1564: );
1565: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1566: RAISE FND_API.G_EXC_ERROR;
1567: END IF;
1568: END LOOP;
1569: END IF; -- IF l_prd_operation_tbl.COUNT > 0 THEN
1570:

Line 1572: IF FND_API.TO_BOOLEAN(p_commit) THEN

1568: END LOOP;
1569: END IF; -- IF l_prd_operation_tbl.COUNT > 0 THEN
1570:
1571:
1572: IF FND_API.TO_BOOLEAN(p_commit) THEN
1573: COMMIT;
1574: END IF;
1575:
1576: IF ( G_DEBUG = 'Y' ) THEN

Line 1585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1581: AHL_DEBUG_PUB.disable_debug;
1582: END IF;
1583:
1584: EXCEPTION
1585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1586: ROLLBACK TO process_operations_PVT;
1587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1588: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1589: p_count => x_msg_count,

Line 1587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1583:
1584: EXCEPTION
1585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1586: ROLLBACK TO process_operations_PVT;
1587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1588: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1589: p_count => x_msg_count,
1590: p_data => x_msg_data);
1591: WHEN FND_API.G_EXC_ERROR THEN

Line 1588: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1584: EXCEPTION
1585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1586: ROLLBACK TO process_operations_PVT;
1587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1588: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1589: p_count => x_msg_count,
1590: p_data => x_msg_data);
1591: WHEN FND_API.G_EXC_ERROR THEN
1592: ROLLBACK TO process_operations_PVT;

Line 1591: WHEN FND_API.G_EXC_ERROR THEN

1587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1588: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1589: p_count => x_msg_count,
1590: p_data => x_msg_data);
1591: WHEN FND_API.G_EXC_ERROR THEN
1592: ROLLBACK TO process_operations_PVT;
1593: x_return_status := FND_API.G_RET_STS_ERROR;
1594: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1595: p_count => x_msg_count,

Line 1593: x_return_status := FND_API.G_RET_STS_ERROR;

1589: p_count => x_msg_count,
1590: p_data => x_msg_data);
1591: WHEN FND_API.G_EXC_ERROR THEN
1592: ROLLBACK TO process_operations_PVT;
1593: x_return_status := FND_API.G_RET_STS_ERROR;
1594: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1595: p_count => x_msg_count,
1596: p_data => x_msg_data);
1597:

Line 1594: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1590: p_data => x_msg_data);
1591: WHEN FND_API.G_EXC_ERROR THEN
1592: ROLLBACK TO process_operations_PVT;
1593: x_return_status := FND_API.G_RET_STS_ERROR;
1594: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1595: p_count => x_msg_count,
1596: p_data => x_msg_data);
1597:
1598: WHEN OTHERS THEN

Line 1600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1596: p_data => x_msg_data);
1597:
1598: WHEN OTHERS THEN
1599: ROLLBACK TO process_operations_PVT;
1600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1601: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1602: FND_MSG_PUB.add_exc_msg(p_pkg_name =>g_pkg_name,
1603: p_procedure_name =>l_api_name,
1604: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1607: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1603: p_procedure_name =>l_api_name,
1604: p_error_text => SUBSTR(SQLERRM,1,240));
1605:
1606: END IF;
1607: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1608: p_count => x_msg_count,
1609: p_data => x_msg_data);
1610:
1611: END;

Line 1632: p_date_hh24 <> FND_API.G_MISS_NUM ) THEN

1628: l_minutes := TO_CHAR(p_date, 'mi');
1629: l_date := p_date;
1630:
1631: IF ( p_date_hh24 IS NOT NULL AND
1632: p_date_hh24 <> FND_API.G_MISS_NUM ) THEN
1633: l_hour := p_date_hh24;
1634: END IF;
1635:
1636: IF ( p_date_mi IS NOT NULL AND

Line 1637: p_date_mi <> FND_API.G_MISS_NUM ) THEN

1633: l_hour := p_date_hh24;
1634: END IF;
1635:
1636: IF ( p_date_mi IS NOT NULL AND
1637: p_date_mi <> FND_API.G_MISS_NUM ) THEN
1638: l_minutes := p_date_mi;
1639: END IF;
1640:
1641: IF(p_date_ss IS NOT NULL AND

Line 1642: p_date_ss <> FND_API.G_MISS_NUM) THEN

1638: l_minutes := p_date_mi;
1639: END IF;
1640:
1641: IF(p_date_ss IS NOT NULL AND
1642: p_date_ss <> FND_API.G_MISS_NUM) THEN
1643: l_sec := p_date_ss;
1644: END IF;
1645:
1646: IF ( l_hour <> '00' OR l_minutes <> '00' OR l_sec <> '00') THEN