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 IGS_PE_GEN_001

Line 123: --pkpatel 8-APR-2003 Bug 2804863 igs_pe_gen_001.g_hold_validation variable was set to 'N' at the beginning and 'Y' at the end.

119: -- Added the check to consider only the active members of the person ID group
120: -- Call the user defined exception instead of app_exception.raise_exception, so that
121: -- the message Unhandled Exception does not come for business validations failed
122: --ssawhney 17-feb-2003 Bug 2758856 external holds design change, ENCUMB TBH parameter added.
123: --pkpatel 8-APR-2003 Bug 2804863 igs_pe_gen_001.g_hold_validation variable was set to 'N' at the beginning and 'Y' at the end.
124: --gmaheswa 29-OCT-2003 Bug 3198795 Introducing DYNAMIC PERSON ID group functionality
125: --asbala 5-JAN-2003 3338759, Changes mentioned along with bug no. in corresponding places
126: --skpandey 02-FEB-2006 Bug#4937960: Changed call to igs_get_dynamic_sql to get_dynamic_sql as a part of literal fix
127: -------------------------------------------------------------------

Line 166: igs_pe_gen_001.g_hold_validation := 'N';

162: IGS_GE_GEN_003.set_org_id(p_org_id) ; /** sets the orgid **/
163: retcode := 0 ; /** initialises the out NOCOPY parameter to 0 **/
164:
165: -- Set the variable to 'N' to prevent the security level validation to happen for each record.
166: igs_pe_gen_001.g_hold_validation := 'N';
167:
168: IF p_term IS NOT NULL THEN
169: l_cal_type := TRIM(SUBSTR(p_term,1,10)) ;
170: l_seq_num := FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(p_term,-6)) ; --3338759: To get the 6-digit sequence number

Line 207: igs_pe_gen_001.get_hold_auth(FND_GLOBAL.USER_ID,

203: END IF;
204:
205: -- Validate that the person who has logged in has a party account and
206: -- is a STAFF. If he fails any of the above then is not authorized to release the hold.
207: igs_pe_gen_001.get_hold_auth(FND_GLOBAL.USER_ID,
208: l_person_id,
209: l_person_number,
210: l_person_name,
211: l_message_name);

Line 322: igs_pe_gen_001.g_hold_validation := 'Y';

318: END ;
319: END IF;
320: END LOOP ;
321: CLOSE c_cur_query;
322: igs_pe_gen_001.g_hold_validation := 'Y';
323:
324: EXCEPTION
325: WHEN NO_DATA_FOUND THEN
326: retcode := 2;

Line 327: igs_pe_gen_001.g_hold_validation := 'Y';

323:
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;

Line 332: 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);
334:
335: WHEN OTHERS THEN
336: retcode := 2;

Line 337: 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';
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 **/

Line 371: --pkpatel 8-APR-2003 Bug 2804863 igs_pe_gen_001.g_hold_validation variable was set to 'N' at the beginning and 'Y' at the end.

367: -- Removed the parameter p_authorizing_id
368: -- Added the check to consider only the active members of the person ID group
369: -- Call the user defined exception instead of app_exception.raise_exception, so that
370: -- the message Unhandled Exception does not come for business validations failed
371: --pkpatel 8-APR-2003 Bug 2804863 igs_pe_gen_001.g_hold_validation variable was set to 'N' at the beginning and 'Y' at the end.
372: -- Added the call of igs_pe_gen_001.get_hold_auth
373: --gmaheswa 29-OCT-2003 Bug 3198795 Introducing DYNAMIC PERSON ID group functionality
374: --skpandey 12-JAN-2006 Bug#4937960
375: -- Changed c_igs_pe_pers_encumb Cursor definition to optimize query

Line 372: -- Added the call of igs_pe_gen_001.get_hold_auth

368: -- Added the check to consider only the active members of the person ID group
369: -- Call the user defined exception instead of app_exception.raise_exception, so that
370: -- the message Unhandled Exception does not come for business validations failed
371: --pkpatel 8-APR-2003 Bug 2804863 igs_pe_gen_001.g_hold_validation variable was set to 'N' at the beginning and 'Y' at the end.
372: -- Added the call of igs_pe_gen_001.get_hold_auth
373: --gmaheswa 29-OCT-2003 Bug 3198795 Introducing DYNAMIC PERSON ID group functionality
374: --skpandey 12-JAN-2006 Bug#4937960
375: -- Changed c_igs_pe_pers_encumb Cursor definition to optimize query
376: --skpandey 02-FEB-2006 Bug#4937960: Changed call to igs_get_dynamic_sql to get_dynamic_sql as a part of literal fix

Line 432: igs_pe_gen_001.g_hold_validation := 'N';

428: IGS_GE_GEN_003.set_org_id(p_org_id) ; /** sets the orgid **/
429: retcode := 0 ; /** initialises the out NOCOPY parameter to 0 **/
430:
431: -- Set the variable to 'N' to prevent the security level validation to happen for each record.
432: igs_pe_gen_001.g_hold_validation := 'N';
433:
434: IF p_term IS NOT NULL THEN
435: l_cal_type := TRIM(SUBSTR(p_term,1,10)) ;
436: l_seq_num := FND_NUMBER.CANONICAL_TO_NUMBER(SUBSTR(p_term,-6)); --3338759: To get the 6-digit sequence number

Line 482: igs_pe_gen_001.get_hold_auth(FND_GLOBAL.USER_ID,

478: END IF;
479:
480: -- Validate that the person who has logged in has a party account and
481: -- is a STAFF. If he fails any of the above then is not authorized to release the hold.
482: igs_pe_gen_001.get_hold_auth(FND_GLOBAL.USER_ID,
483: l_person_id,
484: l_person_number,
485: l_person_name,
486: l_message_name);

Line 543: igs_pe_gen_001.release_hold

539: -- must be a Staff
540: -- must have logged in with the same responsibility as the Authorizer has logged in to create the Hold.
541: SAVEPOINT sp_release;
542:
543: igs_pe_gen_001.release_hold
544: (p_resp_id => l_resp_id,
545: p_fnd_user_id => l_fnd_user_id,
546: p_person_id => r_rec_query.person_id,
547: p_encumbrance_type => p_hold_type,

Line 571: igs_pe_gen_001.g_hold_validation := 'Y';

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';
572:
573: EXCEPTION
574: WHEN NO_DATA_FOUND THEN
575: retcode := 2;

Line 576: igs_pe_gen_001.g_hold_validation := 'Y';

572:
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

Line 582: igs_pe_gen_001.g_hold_validation := 'Y';

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';
583: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
584:
585: WHEN OTHERS THEN
586: retcode := 2;

Line 587: 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';
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;