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.

[Home] [Help]

APPS.EAM_WO_NETWORK_VALIDATE_PVT dependencies on FND_MESSAGE

Line 297: FND_MESSAGE.CLEAR;

293: l_stmt_num := 70;
294:
295: IF p_output_errors = 'Y' THEN
296:
297: FND_MESSAGE.CLEAR;
298:
299: FOR type_1 IN exception_writer_cur(l_top_level_object_id, l_top_level_object_type_id, 1,3)
300: LOOP
301: l_stmt_num := 80;

Line 303: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');

299: FOR type_1 IN exception_writer_cur(l_top_level_object_id, l_top_level_object_type_id, 1,3)
300: LOOP
301: l_stmt_num := 80;
302:
303: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
304: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
305: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
306: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
307: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);

Line 304: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);

300: LOOP
301: l_stmt_num := 80;
302:
303: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
304: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
305: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
306: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
307: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
308: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));

Line 305: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));

301: l_stmt_num := 80;
302:
303: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
304: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
305: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
306: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
307: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
308: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
309: FND_MESSAGE.SET_TOKEN('CHILD_COMPLETION_DATE',TO_CHAR(type_1.child_completion_date, 'DD-MON-YYYY HH24:MM:SS')); l_exception_msg := FND_MESSAGE.GET;

Line 306: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));

302:
303: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
304: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
305: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
306: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
307: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
308: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
309: FND_MESSAGE.SET_TOKEN('CHILD_COMPLETION_DATE',TO_CHAR(type_1.child_completion_date, 'DD-MON-YYYY HH24:MM:SS')); l_exception_msg := FND_MESSAGE.GET;
310:

Line 307: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);

303: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
304: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
305: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
306: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
307: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
308: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
309: FND_MESSAGE.SET_TOKEN('CHILD_COMPLETION_DATE',TO_CHAR(type_1.child_completion_date, 'DD-MON-YYYY HH24:MM:SS')); l_exception_msg := FND_MESSAGE.GET;
310:
311: IF type_1.parent_job IS NOT NULL THEN

Line 308: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));

304: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
305: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
306: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
307: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
308: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
309: FND_MESSAGE.SET_TOKEN('CHILD_COMPLETION_DATE',TO_CHAR(type_1.child_completion_date, 'DD-MON-YYYY HH24:MM:SS')); l_exception_msg := FND_MESSAGE.GET;
310:
311: IF type_1.parent_job IS NOT NULL THEN
312:

Line 309: FND_MESSAGE.SET_TOKEN('CHILD_COMPLETION_DATE',TO_CHAR(type_1.child_completion_date, 'DD-MON-YYYY HH24:MM:SS')); l_exception_msg := FND_MESSAGE.GET;

305: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
306: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
307: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
308: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
309: FND_MESSAGE.SET_TOKEN('CHILD_COMPLETION_DATE',TO_CHAR(type_1.child_completion_date, 'DD-MON-YYYY HH24:MM:SS')); l_exception_msg := FND_MESSAGE.GET;
310:
311: IF type_1.parent_job IS NOT NULL THEN
312:
313: IF l_wo_relationship_exc_tbl.COUNT = 0 THEN

Line 319: FND_MESSAGE.CLEAR;

315: ELSE
316: l_wo_relationship_exc_tbl(l_wo_relationship_exc_tbl.LAST+1) :=l_exception_msg;
317: END IF;
318: l_exception_msg := NULL;
319: FND_MESSAGE.CLEAR;
320:
321: END IF;
322:
323: END LOOP;

Line 331: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');

327: IF type_2.parent_job IS NOT NULL THEN
328:
329: l_stmt_num := 90;
330:
331: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
332: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
333: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
334: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
335: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));

Line 332: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);

328:
329: l_stmt_num := 90;
330:
331: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
332: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
333: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
334: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
335: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
336: l_exception_msg := FND_MESSAGE.GET;

Line 333: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));

329: l_stmt_num := 90;
330:
331: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
332: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
333: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
334: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
335: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
336: l_exception_msg := FND_MESSAGE.GET;
337:

Line 334: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);

330:
331: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
332: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
333: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
334: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
335: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
336: l_exception_msg := FND_MESSAGE.GET;
337:
338: IF l_wo_relationship_exc_tbl.COUNT =0 Then

Line 335: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));

331: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
332: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
333: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
334: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
335: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
336: l_exception_msg := FND_MESSAGE.GET;
337:
338: IF l_wo_relationship_exc_tbl.COUNT =0 Then
339: l_wo_relationship_exc_tbl(1) :=l_exception_msg;

Line 336: l_exception_msg := FND_MESSAGE.GET;

332: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
333: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
334: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
335: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
336: l_exception_msg := FND_MESSAGE.GET;
337:
338: IF l_wo_relationship_exc_tbl.COUNT =0 Then
339: l_wo_relationship_exc_tbl(1) :=l_exception_msg;
340: ELSE

Line 345: FND_MESSAGE.CLEAR;

341: l_wo_relationship_exc_tbl(l_wo_relationship_exc_tbl.LAST+1) :=l_exception_msg;
342: END if;
343:
344: l_exception_msg := NULL;
345: FND_MESSAGE.CLEAR;
346:
347: END IF;
348: END LOOP;
349: END IF; -- END IF for p_output_errors = 'Y'

Line 368: FND_MESSAGE.CLEAR;

364: connect by parent_object_id = prior child_object_id);
365:
366: l_stmt_num := 100;
367:
368: FND_MESSAGE.CLEAR;
369:
370: FOR type_1 IN exception_writer_cur(l_top_level_object_id, l_top_level_object_type_id, 1,to_number(null))
371: LOOP
372: l_stmt_num := 110;

Line 374: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');

370: FOR type_1 IN exception_writer_cur(l_top_level_object_id, l_top_level_object_type_id, 1,to_number(null))
371: LOOP
372: l_stmt_num := 110;
373:
374: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
375: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
376: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
377: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
378: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);

Line 375: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);

371: LOOP
372: l_stmt_num := 110;
373:
374: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
375: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
376: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
377: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
378: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
379: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));

Line 376: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));

372: l_stmt_num := 110;
373:
374: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
375: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
376: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
377: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
378: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
379: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
380: FND_MESSAGE.SET_TOKEN('CHILD_COMPLETION_DATE',TO_CHAR(type_1.child_completion_date, 'DD-MON-YYYY HH24:MM:SS')); l_exception_msg := FND_MESSAGE.GET;

Line 377: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));

373:
374: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
375: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
376: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
377: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
378: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
379: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
380: FND_MESSAGE.SET_TOKEN('CHILD_COMPLETION_DATE',TO_CHAR(type_1.child_completion_date, 'DD-MON-YYYY HH24:MM:SS')); l_exception_msg := FND_MESSAGE.GET;
381:

Line 378: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);

374: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
375: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
376: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
377: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
378: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
379: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
380: FND_MESSAGE.SET_TOKEN('CHILD_COMPLETION_DATE',TO_CHAR(type_1.child_completion_date, 'DD-MON-YYYY HH24:MM:SS')); l_exception_msg := FND_MESSAGE.GET;
381:
382:

Line 379: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));

375: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
376: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
377: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
378: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
379: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
380: FND_MESSAGE.SET_TOKEN('CHILD_COMPLETION_DATE',TO_CHAR(type_1.child_completion_date, 'DD-MON-YYYY HH24:MM:SS')); l_exception_msg := FND_MESSAGE.GET;
381:
382:
383: if type_1.parent_job is not null then

Line 380: FND_MESSAGE.SET_TOKEN('CHILD_COMPLETION_DATE',TO_CHAR(type_1.child_completion_date, 'DD-MON-YYYY HH24:MM:SS')); l_exception_msg := FND_MESSAGE.GET;

376: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
377: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
378: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
379: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
380: FND_MESSAGE.SET_TOKEN('CHILD_COMPLETION_DATE',TO_CHAR(type_1.child_completion_date, 'DD-MON-YYYY HH24:MM:SS')); l_exception_msg := FND_MESSAGE.GET;
381:
382:
383: if type_1.parent_job is not null then
384:

Line 447: FND_MESSAGE.CLEAR;

443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: END;
445:
446: l_exception_msg := NULL;
447: FND_MESSAGE.CLEAR;
448:
449: end if;
450:
451: END LOOP;

Line 459: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');

455: if type_2.parent_job is not null then
456:
457: l_stmt_num := 120;
458:
459: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
460: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
461: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
462: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
463: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));

Line 460: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);

456:
457: l_stmt_num := 120;
458:
459: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
460: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
461: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
462: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
463: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
464: l_exception_msg := FND_MESSAGE.GET;

Line 461: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));

457: l_stmt_num := 120;
458:
459: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
460: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
461: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
462: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
463: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
464: l_exception_msg := FND_MESSAGE.GET;
465:

Line 462: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);

458:
459: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
460: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
461: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
462: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
463: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
464: l_exception_msg := FND_MESSAGE.GET;
465:
466:

Line 463: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));

459: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
460: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
461: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
462: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
463: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
464: l_exception_msg := FND_MESSAGE.GET;
465:
466:
467: BEGIN

Line 464: l_exception_msg := FND_MESSAGE.GET;

460: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
461: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
462: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
463: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
464: l_exception_msg := FND_MESSAGE.GET;
465:
466:
467: BEGIN
468: INSERT INTO WIP_SCHEDULING_EXCEPTIONS

Line 530: FND_MESSAGE.CLEAR;

526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END;
528:
529: l_exception_msg := NULL;
530: FND_MESSAGE.CLEAR;
531:
532: end if;
533: END LOOP;
534:

Line 1120: FND_MESSAGE.SET_NAME('EAM','EAM_WO_REL_STATUS_ERROR');

1116: END IF;
1117:
1118: IF l_WipEntityId_tbl.COUNT > 0 THEN
1119: FOR tbl_counter IN l_WipEntityId_tbl.FIRST..l_WipEntityId_tbl.LAST LOOP
1120: FND_MESSAGE.SET_NAME('EAM','EAM_WO_REL_STATUS_ERROR');
1121: FND_MESSAGE.SET_TOKEN('PARENT_JOB',p_work_object_id);
1122: FND_MESSAGE.SET_TOKEN('PARENT_STATUS',l_wo_status_meaning);
1123: FND_MESSAGE.SET_TOKEN('CHILD_JOB',l_WipEntityId_tbl(tbl_counter));
1124: FND_MESSAGE.SET_TOKEN('CHILD_STATUS',l_workorder_status_tbl(tbl_counter));

Line 1121: FND_MESSAGE.SET_TOKEN('PARENT_JOB',p_work_object_id);

1117:
1118: IF l_WipEntityId_tbl.COUNT > 0 THEN
1119: FOR tbl_counter IN l_WipEntityId_tbl.FIRST..l_WipEntityId_tbl.LAST LOOP
1120: FND_MESSAGE.SET_NAME('EAM','EAM_WO_REL_STATUS_ERROR');
1121: FND_MESSAGE.SET_TOKEN('PARENT_JOB',p_work_object_id);
1122: FND_MESSAGE.SET_TOKEN('PARENT_STATUS',l_wo_status_meaning);
1123: FND_MESSAGE.SET_TOKEN('CHILD_JOB',l_WipEntityId_tbl(tbl_counter));
1124: FND_MESSAGE.SET_TOKEN('CHILD_STATUS',l_workorder_status_tbl(tbl_counter));
1125: l_exception_msg := FND_MESSAGE.GET;

Line 1122: FND_MESSAGE.SET_TOKEN('PARENT_STATUS',l_wo_status_meaning);

1118: IF l_WipEntityId_tbl.COUNT > 0 THEN
1119: FOR tbl_counter IN l_WipEntityId_tbl.FIRST..l_WipEntityId_tbl.LAST LOOP
1120: FND_MESSAGE.SET_NAME('EAM','EAM_WO_REL_STATUS_ERROR');
1121: FND_MESSAGE.SET_TOKEN('PARENT_JOB',p_work_object_id);
1122: FND_MESSAGE.SET_TOKEN('PARENT_STATUS',l_wo_status_meaning);
1123: FND_MESSAGE.SET_TOKEN('CHILD_JOB',l_WipEntityId_tbl(tbl_counter));
1124: FND_MESSAGE.SET_TOKEN('CHILD_STATUS',l_workorder_status_tbl(tbl_counter));
1125: l_exception_msg := FND_MESSAGE.GET;
1126:

Line 1123: FND_MESSAGE.SET_TOKEN('CHILD_JOB',l_WipEntityId_tbl(tbl_counter));

1119: FOR tbl_counter IN l_WipEntityId_tbl.FIRST..l_WipEntityId_tbl.LAST LOOP
1120: FND_MESSAGE.SET_NAME('EAM','EAM_WO_REL_STATUS_ERROR');
1121: FND_MESSAGE.SET_TOKEN('PARENT_JOB',p_work_object_id);
1122: FND_MESSAGE.SET_TOKEN('PARENT_STATUS',l_wo_status_meaning);
1123: FND_MESSAGE.SET_TOKEN('CHILD_JOB',l_WipEntityId_tbl(tbl_counter));
1124: FND_MESSAGE.SET_TOKEN('CHILD_STATUS',l_workorder_status_tbl(tbl_counter));
1125: l_exception_msg := FND_MESSAGE.GET;
1126:
1127: IF p_wo_relationship_exc_tbl.COUNT =0 Then

Line 1124: FND_MESSAGE.SET_TOKEN('CHILD_STATUS',l_workorder_status_tbl(tbl_counter));

1120: FND_MESSAGE.SET_NAME('EAM','EAM_WO_REL_STATUS_ERROR');
1121: FND_MESSAGE.SET_TOKEN('PARENT_JOB',p_work_object_id);
1122: FND_MESSAGE.SET_TOKEN('PARENT_STATUS',l_wo_status_meaning);
1123: FND_MESSAGE.SET_TOKEN('CHILD_JOB',l_WipEntityId_tbl(tbl_counter));
1124: FND_MESSAGE.SET_TOKEN('CHILD_STATUS',l_workorder_status_tbl(tbl_counter));
1125: l_exception_msg := FND_MESSAGE.GET;
1126:
1127: IF p_wo_relationship_exc_tbl.COUNT =0 Then
1128: p_wo_relationship_exc_tbl(1) :=l_exception_msg;

Line 1125: l_exception_msg := FND_MESSAGE.GET;

1121: FND_MESSAGE.SET_TOKEN('PARENT_JOB',p_work_object_id);
1122: FND_MESSAGE.SET_TOKEN('PARENT_STATUS',l_wo_status_meaning);
1123: FND_MESSAGE.SET_TOKEN('CHILD_JOB',l_WipEntityId_tbl(tbl_counter));
1124: FND_MESSAGE.SET_TOKEN('CHILD_STATUS',l_workorder_status_tbl(tbl_counter));
1125: l_exception_msg := FND_MESSAGE.GET;
1126:
1127: IF p_wo_relationship_exc_tbl.COUNT =0 Then
1128: p_wo_relationship_exc_tbl(1) :=l_exception_msg;
1129: ELSE