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

Line 90: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');

86: --Change History:
87: --Who When What
88: -------------------------------------------------------------------
89: BEGIN
90: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');
91: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);
92: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val) ;
93: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
94: END log_messages ;

Line 91: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);

87: --Who When What
88: -------------------------------------------------------------------
89: BEGIN
90: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');
91: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);
92: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val) ;
93: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
94: END log_messages ;
95:

Line 92: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val) ;

88: -------------------------------------------------------------------
89: BEGIN
90: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');
91: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);
92: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val) ;
93: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
94: END log_messages ;
95:
96: PROCEDURE set_prsid_grp_holds ( errbuf OUT NOCOPY VARCHAR2 ,

Line 93: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

89: BEGIN
90: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');
91: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);
92: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val) ;
93: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
94: END log_messages ;
95:
96: PROCEDURE set_prsid_grp_holds ( errbuf OUT NOCOPY VARCHAR2 ,
97: retcode OUT NOCOPY NUMBER ,

Line 193: FND_MESSAGE.SET_NAME('IGS','IGS_PE_TERM_OR_START_DT') ;

189: FND_FILE.NEW_LINE(FND_FILE.LOG,2); /** writes 2 new line characters **/
190:
191: -- if both start date and term parameters are passed as null , error out NOCOPY of the process
192: IF p_start_dt IS NULL AND p_term IS NULL THEN
193: FND_MESSAGE.SET_NAME('IGS','IGS_PE_TERM_OR_START_DT') ;
194: IGS_GE_MSG_STACK.ADD;
195: RAISE l_error_exception;
196: END IF;
197:

Line 200: FND_MESSAGE.SET_NAME('IGS','IGS_PE_TERM_OR_START_DT') ;

196: END IF;
197:
198: -- if both start date and term parameters are passed as not null's , error out NOCOPY of the process
199: IF p_start_dt IS NOT NULL AND p_term IS NOT NULL THEN
200: FND_MESSAGE.SET_NAME('IGS','IGS_PE_TERM_OR_START_DT') ;
201: IGS_GE_MSG_STACK.ADD;
202: RAISE l_error_exception;
203: END IF;
204:

Line 214: FND_MESSAGE.SET_NAME('IGS',l_message_name) ;

210: l_person_name,
211: l_message_name);
212:
213: IF l_message_name IS NOT NULL THEN
214: FND_MESSAGE.SET_NAME('IGS',l_message_name) ;
215: IGS_GE_MSG_STACK.ADD;
216: RAISE l_error_exception;
217: END IF;
218:

Line 278: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

274:
275: EXCEPTION
276: WHEN OTHERS THEN
277: l_err_raised := TRUE ;
278: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
279: ROLLBACK TO sp_person; -- 3338759: Rollback to SAVEPOINT sp_person in case of exception
280: END ;
281:
282: IF NOT (l_err_raised) THEN

Line 294: FND_MESSAGE.SET_NAME('IGS',l_message_name) ;

290: l_message_name
291: ) = FALSE
292: THEN
293: ROLLBACK TO sp_person;
294: FND_MESSAGE.SET_NAME('IGS',l_message_name) ;
295: IGS_GE_MSG_STACK.ADD;
296: RAISE l_error_exception ;
297: END IF;
298:

Line 310: FND_MESSAGE.SET_NAME('IGS',l_message_name) ;

306: l_message_string
307: ) ;
308: IF l_message_name IS NOT NULL THEN
309: ROLLBACK TO sp_person;
310: FND_MESSAGE.SET_NAME('IGS',l_message_name) ;
311: IGS_GE_MSG_STACK.ADD;
312: RAISE l_error_exception ;
313: END IF;
314:

Line 317: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

313: END IF;
314:
315: EXCEPTION
316: WHEN OTHERS THEN
317: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
318: END ;
319: END IF;
320: END LOOP ;
321: CLOSE c_cur_query;

Line 328: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PERSID_GROUP_EXP') ;

324: EXCEPTION
325: WHEN NO_DATA_FOUND THEN
326: retcode := 2;
327: igs_pe_gen_001.g_hold_validation := 'Y';
328: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PERSID_GROUP_EXP') ;
329: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
330: WHEN l_error_exception THEN
331: retcode := 2;
332: igs_pe_gen_001.g_hold_validation := 'Y';

Line 329: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

325: WHEN NO_DATA_FOUND THEN
326: retcode := 2;
327: igs_pe_gen_001.g_hold_validation := 'Y';
328: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PERSID_GROUP_EXP') ;
329: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
330: WHEN l_error_exception THEN
331: retcode := 2;
332: igs_pe_gen_001.g_hold_validation := 'Y';
333: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

Line 333: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

329: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
330: WHEN l_error_exception THEN
331: retcode := 2;
332: igs_pe_gen_001.g_hold_validation := 'Y';
333: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
334:
335: WHEN OTHERS THEN
336: retcode := 2;
337: igs_pe_gen_001.g_hold_validation := 'Y';

Line 338: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

334:
335: WHEN OTHERS THEN
336: retcode := 2;
337: igs_pe_gen_001.g_hold_validation := 'Y';
338: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
339: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL ;
340:
341: END set_prsid_grp_holds ; /** procedure ends here **/
342:

Line 461: FND_MESSAGE.SET_NAME('IGS','IGS_PE_TERM_OR_START_EXP_DT') ;

457: FND_FILE.NEW_LINE(FND_FILE.LOG,2); /** writes 2 new line characters **/
458:
459: -- if both start date and term parameters are passed as null , error out of the process
460: IF ((p_start_dt IS NULL OR p_expiry_dt IS NULL) AND p_term IS NULL) THEN
461: FND_MESSAGE.SET_NAME('IGS','IGS_PE_TERM_OR_START_EXP_DT') ;
462: IGS_GE_MSG_STACK.ADD;
463: RAISE l_error_exception;
464: END IF;
465:

Line 468: FND_MESSAGE.SET_NAME('IGS','IGS_PE_TERM_OR_START_EXP_DT') ;

464: END IF;
465:
466: -- if both start date and term parameters are passed as not null's , error out of the process
467: IF ((p_start_dt IS NOT NULL OR p_expiry_dt IS NOT NULL) AND p_term IS NOT NULL) THEN
468: FND_MESSAGE.SET_NAME('IGS','IGS_PE_TERM_OR_START_EXP_DT') ;
469: IGS_GE_MSG_STACK.ADD;
470: RAISE l_error_exception;
471: END IF;
472:

Line 475: FND_MESSAGE.SET_NAME('IGS','IGS_EN_EXPDT_GE_STDT') ;

471: END IF;
472:
473: -- check if expirt date is less than start date
474: IF l_expiry_date < l_start_date THEN
475: FND_MESSAGE.SET_NAME('IGS','IGS_EN_EXPDT_GE_STDT') ;
476: IGS_GE_MSG_STACK.ADD;
477: RAISE l_error_exception;
478: END IF;
479:

Line 489: FND_MESSAGE.SET_NAME('IGS',l_message_name) ;

485: l_person_name,
486: l_message_name);
487:
488: IF l_message_name IS NOT NULL THEN
489: FND_MESSAGE.SET_NAME('IGS',l_message_name) ;
490: IGS_GE_MSG_STACK.ADD;
491: RAISE l_error_exception;
492: END IF;
493:

Line 529: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PERS_ENCUMB_NOTEXIST') ;

525: );
526: FETCH c_igs_pe_pers_encumb INTO l_c_igs_pe_pers_encumb ;
527: IF c_igs_pe_pers_encumb%NOTFOUND THEN
528: CLOSE c_igs_pe_pers_encumb ;
529: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PERS_ENCUMB_NOTEXIST') ;
530: IGS_GE_MSG_STACK.ADD;
531: RAISE l_ignore_exception; -- 3338759: To stop further processing and log the message
532: END IF;
533: CLOSE c_igs_pe_pers_encumb ;

Line 558: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

554: WHEN OTHERS THEN
555: -- 3338759: Rollback to SAVEPOINT sp_release in case of exception
556: ROLLBACK TO sp_release;
557: retcode := 2;
558: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
559: END ;
560: EXCEPTION
561: WHEN l_error_exception THEN
562: retcode := 2;

Line 563: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

559: END ;
560: EXCEPTION
561: WHEN l_error_exception THEN
562: retcode := 2;
563: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
564:
565: WHEN l_ignore_exception THEN -- 3338759: when this exception is thrown, only the error is to be logged
566: -- the concurrent program should not error out
567: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

Line 567: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

563: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
564:
565: WHEN l_ignore_exception THEN -- 3338759: when this exception is thrown, only the error is to be logged
566: -- the concurrent program should not error out
567: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
568: END ;
569: END LOOP ;
570: CLOSE c_cur_query;
571: igs_pe_gen_001.g_hold_validation := 'Y';

Line 577: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PERSID_GROUP_EXP') ;

573: EXCEPTION
574: WHEN NO_DATA_FOUND THEN
575: retcode := 2;
576: igs_pe_gen_001.g_hold_validation := 'Y';
577: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PERSID_GROUP_EXP') ;
578: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
579:
580: WHEN l_error_exception THEN
581: retcode := 2;

Line 578: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

574: WHEN NO_DATA_FOUND THEN
575: retcode := 2;
576: igs_pe_gen_001.g_hold_validation := 'Y';
577: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PERSID_GROUP_EXP') ;
578: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
579:
580: WHEN l_error_exception THEN
581: retcode := 2;
582: igs_pe_gen_001.g_hold_validation := 'Y';

Line 583: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

579:
580: WHEN l_error_exception THEN
581: retcode := 2;
582: igs_pe_gen_001.g_hold_validation := 'Y';
583: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
584:
585: WHEN OTHERS THEN
586: retcode := 2;
587: igs_pe_gen_001.g_hold_validation := 'Y';

Line 588: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

584:
585: WHEN OTHERS THEN
586: retcode := 2;
587: igs_pe_gen_001.g_hold_validation := 'Y';
588: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
589: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL ;
590: END rel_prsid_grp_holds ; /** procedure ends here **/
591: END igs_pe_set_rem_holds;