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.EAM_WO_NETWORK_VALIDATE_PVT dependencies on FND_MESSAGE

Line 310: FND_MESSAGE.CLEAR;

306: l_stmt_num := 70;
307:
308: IF p_output_errors = 'Y' THEN
309:
310: FND_MESSAGE.CLEAR;
311:
312: FOR type_1 IN exception_writer_cur(l_top_level_object_id, l_top_level_object_type_id, 1,3)
313: LOOP
314: l_stmt_num := 80;

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

312: FOR type_1 IN exception_writer_cur(l_top_level_object_id, l_top_level_object_type_id, 1,3)
313: LOOP
314: l_stmt_num := 80;
315:
316: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
317: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
318: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
319: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
320: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);

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

313: LOOP
314: l_stmt_num := 80;
315:
316: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
317: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
318: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
319: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
320: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
321: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));

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

314: l_stmt_num := 80;
315:
316: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
317: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
318: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
319: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
320: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
321: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
322: 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 319: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));

315:
316: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
317: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
318: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
319: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
320: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
321: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
322: 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;
323:

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

316: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
317: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
318: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
319: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
320: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
321: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
322: 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;
323:
324: IF type_1.parent_job IS NOT NULL THEN

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

317: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
318: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
319: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
320: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
321: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
322: 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;
323:
324: IF type_1.parent_job IS NOT NULL THEN
325:

Line 322: 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;

318: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
319: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
320: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
321: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
322: 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;
323:
324: IF type_1.parent_job IS NOT NULL THEN
325:
326: IF l_wo_relationship_exc_tbl.COUNT = 0 THEN

Line 332: FND_MESSAGE.CLEAR;

328: ELSE
329: l_wo_relationship_exc_tbl(l_wo_relationship_exc_tbl.LAST+1) :=l_exception_msg;
330: END IF;
331: l_exception_msg := NULL;
332: FND_MESSAGE.CLEAR;
333:
334: END IF;
335:
336: END LOOP;

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

340: IF type_2.parent_job IS NOT NULL THEN
341:
342: l_stmt_num := 90;
343:
344: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
345: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
346: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
347: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
348: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));

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

341:
342: l_stmt_num := 90;
343:
344: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
345: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
346: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
347: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
348: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
349: l_exception_msg := FND_MESSAGE.GET;

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

342: l_stmt_num := 90;
343:
344: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
345: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
346: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
347: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
348: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
349: l_exception_msg := FND_MESSAGE.GET;
350:

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

343:
344: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
345: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
346: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
347: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
348: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
349: l_exception_msg := FND_MESSAGE.GET;
350:
351: IF l_wo_relationship_exc_tbl.COUNT =0 Then

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

344: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
345: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
346: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
347: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
348: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
349: l_exception_msg := FND_MESSAGE.GET;
350:
351: IF l_wo_relationship_exc_tbl.COUNT =0 Then
352: l_wo_relationship_exc_tbl(1) :=l_exception_msg;

Line 349: l_exception_msg := FND_MESSAGE.GET;

345: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
346: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
347: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
348: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
349: l_exception_msg := FND_MESSAGE.GET;
350:
351: IF l_wo_relationship_exc_tbl.COUNT =0 Then
352: l_wo_relationship_exc_tbl(1) :=l_exception_msg;
353: ELSE

Line 358: FND_MESSAGE.CLEAR;

354: l_wo_relationship_exc_tbl(l_wo_relationship_exc_tbl.LAST+1) :=l_exception_msg;
355: END if;
356:
357: l_exception_msg := NULL;
358: FND_MESSAGE.CLEAR;
359:
360: END IF;
361: END LOOP;
362: END IF; -- END IF for p_output_errors = 'Y'

Line 381: FND_MESSAGE.CLEAR;

377: connect by parent_object_id = prior child_object_id);
378:
379: l_stmt_num := 100;
380:
381: FND_MESSAGE.CLEAR;
382:
383: FOR type_1 IN exception_writer_cur(l_top_level_object_id, l_top_level_object_type_id, 1,to_number(null))
384: LOOP
385: l_stmt_num := 110;

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

383: FOR type_1 IN exception_writer_cur(l_top_level_object_id, l_top_level_object_type_id, 1,to_number(null))
384: LOOP
385: l_stmt_num := 110;
386:
387: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
388: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
389: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
390: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
391: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);

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

384: LOOP
385: l_stmt_num := 110;
386:
387: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
388: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
389: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
390: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
391: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
392: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));

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

385: l_stmt_num := 110;
386:
387: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
388: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
389: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
390: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
391: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
392: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
393: 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 390: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));

386:
387: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
388: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
389: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
390: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
391: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
392: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
393: 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;
394:

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

387: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_1_NETWORK_ERROR');
388: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
389: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
390: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
391: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
392: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
393: 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;
394:
395:

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

388: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_1.parent_job);
389: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
390: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
391: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
392: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
393: 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;
394:
395:
396: if type_1.parent_job is not null then

Line 393: 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;

389: FND_MESSAGE.SET_TOKEN('PARENT_START_DATE',TO_CHAR(type_1.parent_start_date, 'DD-MON-YYYY HH24:MM:SS'));
390: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_1.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
391: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_1.child_job);
392: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_1.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
393: 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;
394:
395:
396: if type_1.parent_job is not null then
397:

Line 460: FND_MESSAGE.CLEAR;

456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
457: END;
458:
459: l_exception_msg := NULL;
460: FND_MESSAGE.CLEAR;
461:
462: end if;
463:
464: END LOOP;

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

468: if type_2.parent_job is not null then
469:
470: l_stmt_num := 120;
471:
472: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
473: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
474: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
475: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
476: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));

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

469:
470: l_stmt_num := 120;
471:
472: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
473: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
474: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
475: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
476: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
477: l_exception_msg := FND_MESSAGE.GET;

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

470: l_stmt_num := 120;
471:
472: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
473: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
474: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
475: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
476: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
477: l_exception_msg := FND_MESSAGE.GET;
478:

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

471:
472: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
473: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
474: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
475: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
476: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
477: l_exception_msg := FND_MESSAGE.GET;
478:
479:

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

472: FND_MESSAGE.SET_NAME('EAM','EAM_TYPE_2_NETWORK_ERROR');
473: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
474: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
475: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
476: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
477: l_exception_msg := FND_MESSAGE.GET;
478:
479:
480: BEGIN

Line 477: l_exception_msg := FND_MESSAGE.GET;

473: FND_MESSAGE.SET_TOKEN('PARENT_JOB',type_2.parent_job);
474: FND_MESSAGE.SET_TOKEN('PARENT_COMPLETION_DATE',TO_CHAR(type_2.parent_completion_date, 'DD-MON-YYYY HH24:MM:SS'));
475: FND_MESSAGE.SET_TOKEN('CHILD_JOB',type_2.child_job);
476: FND_MESSAGE.SET_TOKEN('CHILD_START_DATE',TO_CHAR(type_2.child_start_date, 'DD-MON-YYYY HH24:MM:SS'));
477: l_exception_msg := FND_MESSAGE.GET;
478:
479:
480: BEGIN
481: INSERT INTO WIP_SCHEDULING_EXCEPTIONS

Line 543: FND_MESSAGE.CLEAR;

539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
540: END;
541:
542: l_exception_msg := NULL;
543: FND_MESSAGE.CLEAR;
544:
545: end if;
546: END LOOP;
547:

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

1139: END IF;
1140:
1141: IF l_WipEntityId_tbl.COUNT > 0 THEN
1142: FOR tbl_counter IN l_WipEntityId_tbl.FIRST..l_WipEntityId_tbl.LAST LOOP
1143: FND_MESSAGE.SET_NAME('EAM','EAM_WO_REL_STATUS_ERROR');
1144: FND_MESSAGE.SET_TOKEN('PARENT_JOB',p_work_object_id);
1145: FND_MESSAGE.SET_TOKEN('PARENT_STATUS',l_wo_status_meaning);
1146: FND_MESSAGE.SET_TOKEN('CHILD_JOB',l_WipEntityId_tbl(tbl_counter));
1147: FND_MESSAGE.SET_TOKEN('CHILD_STATUS',l_workorder_status_tbl(tbl_counter));

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

1140:
1141: IF l_WipEntityId_tbl.COUNT > 0 THEN
1142: FOR tbl_counter IN l_WipEntityId_tbl.FIRST..l_WipEntityId_tbl.LAST LOOP
1143: FND_MESSAGE.SET_NAME('EAM','EAM_WO_REL_STATUS_ERROR');
1144: FND_MESSAGE.SET_TOKEN('PARENT_JOB',p_work_object_id);
1145: FND_MESSAGE.SET_TOKEN('PARENT_STATUS',l_wo_status_meaning);
1146: FND_MESSAGE.SET_TOKEN('CHILD_JOB',l_WipEntityId_tbl(tbl_counter));
1147: FND_MESSAGE.SET_TOKEN('CHILD_STATUS',l_workorder_status_tbl(tbl_counter));
1148: l_exception_msg := FND_MESSAGE.GET;

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

1141: IF l_WipEntityId_tbl.COUNT > 0 THEN
1142: FOR tbl_counter IN l_WipEntityId_tbl.FIRST..l_WipEntityId_tbl.LAST LOOP
1143: FND_MESSAGE.SET_NAME('EAM','EAM_WO_REL_STATUS_ERROR');
1144: FND_MESSAGE.SET_TOKEN('PARENT_JOB',p_work_object_id);
1145: FND_MESSAGE.SET_TOKEN('PARENT_STATUS',l_wo_status_meaning);
1146: FND_MESSAGE.SET_TOKEN('CHILD_JOB',l_WipEntityId_tbl(tbl_counter));
1147: FND_MESSAGE.SET_TOKEN('CHILD_STATUS',l_workorder_status_tbl(tbl_counter));
1148: l_exception_msg := FND_MESSAGE.GET;
1149:

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

1142: FOR tbl_counter IN l_WipEntityId_tbl.FIRST..l_WipEntityId_tbl.LAST LOOP
1143: FND_MESSAGE.SET_NAME('EAM','EAM_WO_REL_STATUS_ERROR');
1144: FND_MESSAGE.SET_TOKEN('PARENT_JOB',p_work_object_id);
1145: FND_MESSAGE.SET_TOKEN('PARENT_STATUS',l_wo_status_meaning);
1146: FND_MESSAGE.SET_TOKEN('CHILD_JOB',l_WipEntityId_tbl(tbl_counter));
1147: FND_MESSAGE.SET_TOKEN('CHILD_STATUS',l_workorder_status_tbl(tbl_counter));
1148: l_exception_msg := FND_MESSAGE.GET;
1149:
1150: IF p_wo_relationship_exc_tbl.COUNT =0 Then

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

1143: FND_MESSAGE.SET_NAME('EAM','EAM_WO_REL_STATUS_ERROR');
1144: FND_MESSAGE.SET_TOKEN('PARENT_JOB',p_work_object_id);
1145: FND_MESSAGE.SET_TOKEN('PARENT_STATUS',l_wo_status_meaning);
1146: FND_MESSAGE.SET_TOKEN('CHILD_JOB',l_WipEntityId_tbl(tbl_counter));
1147: FND_MESSAGE.SET_TOKEN('CHILD_STATUS',l_workorder_status_tbl(tbl_counter));
1148: l_exception_msg := FND_MESSAGE.GET;
1149:
1150: IF p_wo_relationship_exc_tbl.COUNT =0 Then
1151: p_wo_relationship_exc_tbl(1) :=l_exception_msg;

Line 1148: l_exception_msg := FND_MESSAGE.GET;

1144: FND_MESSAGE.SET_TOKEN('PARENT_JOB',p_work_object_id);
1145: FND_MESSAGE.SET_TOKEN('PARENT_STATUS',l_wo_status_meaning);
1146: FND_MESSAGE.SET_TOKEN('CHILD_JOB',l_WipEntityId_tbl(tbl_counter));
1147: FND_MESSAGE.SET_TOKEN('CHILD_STATUS',l_workorder_status_tbl(tbl_counter));
1148: l_exception_msg := FND_MESSAGE.GET;
1149:
1150: IF p_wo_relationship_exc_tbl.COUNT =0 Then
1151: p_wo_relationship_exc_tbl(1) :=l_exception_msg;
1152: ELSE