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_FILE

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 189: FND_FILE.NEW_LINE(FND_FILE.LOG,2); / writes 2 new line characters /

185: END IF;
186:
187: log_messages(RPAD(lookup_desc('IGS_PE_HOLDS','START_DT'),20)||':',IGS_GE_DATE.IGSCHARDT(l_start_date));
188:
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') ;

Line 228: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_str_0);

224: RPAD(lookup_desc('IGS_PE_HOLDS','CAL_TYPE'),15)||
225: RPAD(lookup_desc('IGS_PE_HOLDS','SEQ_NUM'),17)||
226: RPAD(lookup_desc('IGS_PE_HOLDS','START_DT'),11);
227:
228: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_str_0);
229: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
230:
231: --get the query for the members in the group passed
232: L_str := igs_pe_dynamic_persid_group.get_dynamic_sql(p_pid_group,l_status, l_group_type);

Line 229: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

225: RPAD(lookup_desc('IGS_PE_HOLDS','SEQ_NUM'),17)||
226: RPAD(lookup_desc('IGS_PE_HOLDS','START_DT'),11);
227:
228: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_str_0);
229: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
230:
231: --get the query for the members in the group passed
232: L_str := igs_pe_dynamic_persid_group.get_dynamic_sql(p_pid_group,l_status, l_group_type);
233: IF l_status <> 'S' THEN

Line 255: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_str_1);

251: RPAD(p_hold_type,12) ||
252: NVL(RPAD(l_cal_type,15),' ')||
253: NVL(RPAD(TO_CHAR(l_seq_num),17),' ')||
254: RPAD(IGS_GE_DATE.IGSCHARDT(l_start_date),11) ;
255: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_str_1);
256:
257: igs_pe_pers_encumb_pkg.insert_row
258: (
259: x_mode => 'R' ,

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 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 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 457: FND_FILE.NEW_LINE(FND_FILE.LOG,2); / writes 2 new line characters /

453: END IF;
454:
455: log_messages(RPAD(lookup_desc('IGS_PE_HOLDS','START_DT'),20)||':',IGS_GE_DATE.IGSCHARDT(l_start_date));
456: log_messages(RPAD(lookup_desc('IGS_PE_HOLDS','EXPIRY_DT'),20)||':',IGS_GE_DATE.IGSCHARDT(l_expiry_date));
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') ;

Line 497: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_str_0);

493:
494: l_msg_str_0 := RPAD(lookup_desc('IGS_PE_HOLDS','PERSON'),30) ||
495: RPAD(lookup_desc('IGS_PE_HOLDS','NAME'),452);
496:
497: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_str_0);
498: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
499:
500: --get the query for the members in the group passed
501: L_str := igs_pe_dynamic_persid_group.get_dynamic_sql(p_pid_group,l_status, l_group_type); -- skpandey

Line 498: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

494: l_msg_str_0 := RPAD(lookup_desc('IGS_PE_HOLDS','PERSON'),30) ||
495: RPAD(lookup_desc('IGS_PE_HOLDS','NAME'),452);
496:
497: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_str_0);
498: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
499:
500: --get the query for the members in the group passed
501: L_str := igs_pe_dynamic_persid_group.get_dynamic_sql(p_pid_group,l_status, l_group_type); -- skpandey
502: IF l_status <> 'S' THEN

Line 520: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_str_1);

516: BEGIN
517: l_msg_str_1 := RPAD(r_rec_query.person_number,30) ||
518: RPAD(nvl(r_rec_query.full_name,' '),452);
519:
520: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_str_1);
521:
522: OPEN c_igs_pe_pers_encumb( cp_person_id => r_rec_query.person_id ,
523: cp_hold_type => p_hold_type ,
524: cp_start_dt => l_start_date

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 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';