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_SC_BULK_ASSIGN dependencies on FND_USER

Line 250: CURSOR Fnd_User_Check_C(Prsn_id NUMBER) IS

246: l_Inf_date VARCHAR2(11);
247: l_user_roles_param VARCHAR2(4000);
248: l_group_type IGS_PE_PERSID_GROUP_V.group_type%TYPE;
249:
250: CURSOR Fnd_User_Check_C(Prsn_id NUMBER) IS
251: SELECT user_id,user_name, customer_id, employee_id
252: FROM FND_USER
253: WHERE Person_party_id = Prsn_id AND
254: SYSDATE BETWEEN START_DATE AND NVL(END_DATE,SYSDATE+1);

Line 252: FROM FND_USER

248: l_group_type IGS_PE_PERSID_GROUP_V.group_type%TYPE;
249:
250: CURSOR Fnd_User_Check_C(Prsn_id NUMBER) IS
251: SELECT user_id,user_name, customer_id, employee_id
252: FROM FND_USER
253: WHERE Person_party_id = Prsn_id AND
254: SYSDATE BETWEEN START_DATE AND NVL(END_DATE,SYSDATE+1);
255:
256: CURSOR IGS_SC_DUP_C(prsnId NUMBER,usrAttrId NUMBER,usrAttrVal VARCHAR2) IS

Line 265: SELECT 1, START_DATE /while assigning roles check if person is associated with mul FND USER /

261: user_attrib_value = usrAttrVal;
262:
263: CURSOR DUP_ROLES_CHK_C(UserId NUMBER,RoleName VARCHAR2,RolrOrgSystem VARCHAR2,
264: RoleOrgSysId NUMBER, UsrOrgSystem VARCHAR2,UsrName VARCHAR2) IS
265: SELECT 1, START_DATE /*while assigning roles check if person is associated with mul FND USER */
266: FROM WF_LOCAL_USER_ROLES
267: WHERE user_orig_system_id =UserId AND
268: user_name=UsrName AND
269: role_name= RoleName AND

Line 400: /* Check Whether user id FND USER otherwise put a error msg in the error log and skip assignment */

396: END IF;
397: LOOP
398: FETCH c_cur_query INTO r_rec_query;
399: EXIT WHEN c_cur_query%NOTFOUND;
400: /* Check Whether user id FND USER otherwise put a error msg in the error log and skip assignment */
401: OPEN Fnd_User_Check_C(r_rec_query.Person_id);
402: FETCH Fnd_User_Check_C INTO l_User_Id,l_user_name, l_cust_id, l_emp_id;
403:
404: IF Fnd_User_Check_C%FOUND THEN

Line 401: OPEN Fnd_User_Check_C(r_rec_query.Person_id);

397: LOOP
398: FETCH c_cur_query INTO r_rec_query;
399: EXIT WHEN c_cur_query%NOTFOUND;
400: /* Check Whether user id FND USER otherwise put a error msg in the error log and skip assignment */
401: OPEN Fnd_User_Check_C(r_rec_query.Person_id);
402: FETCH Fnd_User_Check_C INTO l_User_Id,l_user_name, l_cust_id, l_emp_id;
403:
404: IF Fnd_User_Check_C%FOUND THEN
405: /* IF User is a FND USER then carry out the assignment*/

Line 402: FETCH Fnd_User_Check_C INTO l_User_Id,l_user_name, l_cust_id, l_emp_id;

398: FETCH c_cur_query INTO r_rec_query;
399: EXIT WHEN c_cur_query%NOTFOUND;
400: /* Check Whether user id FND USER otherwise put a error msg in the error log and skip assignment */
401: OPEN Fnd_User_Check_C(r_rec_query.Person_id);
402: FETCH Fnd_User_Check_C INTO l_User_Id,l_user_name, l_cust_id, l_emp_id;
403:
404: IF Fnd_User_Check_C%FOUND THEN
405: /* IF User is a FND USER then carry out the assignment*/
406:

Line 404: IF Fnd_User_Check_C%FOUND THEN

400: /* Check Whether user id FND USER otherwise put a error msg in the error log and skip assignment */
401: OPEN Fnd_User_Check_C(r_rec_query.Person_id);
402: FETCH Fnd_User_Check_C INTO l_User_Id,l_user_name, l_cust_id, l_emp_id;
403:
404: IF Fnd_User_Check_C%FOUND THEN
405: /* IF User is a FND USER then carry out the assignment*/
406:
407: --IMP logic --simran.
408: IF l_emp_id IS NOT NULL and l_cust_id IS NULL THEN

Line 405: /* IF User is a FND USER then carry out the assignment*/

401: OPEN Fnd_User_Check_C(r_rec_query.Person_id);
402: FETCH Fnd_User_Check_C INTO l_User_Id,l_user_name, l_cust_id, l_emp_id;
403:
404: IF Fnd_User_Check_C%FOUND THEN
405: /* IF User is a FND USER then carry out the assignment*/
406:
407: --IMP logic --simran.
408: IF l_emp_id IS NOT NULL and l_cust_id IS NULL THEN
409: l_wf_orig_id := l_emp_id;

Line 550: /First check if the user has multiple FND USer associated since cursor is already open-refetch it. /

546: END LOOP;
547: END IF;
548:
549: IF l_usrroles_array IS NOT NULL THEN
550: /*First check if the user has multiple FND USer associated since cursor is already open-refetch it. */
551: FETCH Fnd_User_Check_C INTO l_sec_User_Id,l_sec_User_Name,l_sec_cust_id, l_sec_emp_id;
552:
553: --skpandey.Bug: 4583789
554: IF Fnd_User_Check_C%FOUND THEN

Line 551: FETCH Fnd_User_Check_C INTO l_sec_User_Id,l_sec_User_Name,l_sec_cust_id, l_sec_emp_id;

547: END IF;
548:
549: IF l_usrroles_array IS NOT NULL THEN
550: /*First check if the user has multiple FND USer associated since cursor is already open-refetch it. */
551: FETCH Fnd_User_Check_C INTO l_sec_User_Id,l_sec_User_Name,l_sec_cust_id, l_sec_emp_id;
552:
553: --skpandey.Bug: 4583789
554: IF Fnd_User_Check_C%FOUND THEN
555: OPEN get_person_num (r_rec_query.Person_Id);

Line 554: IF Fnd_User_Check_C%FOUND THEN

550: /*First check if the user has multiple FND USer associated since cursor is already open-refetch it. */
551: FETCH Fnd_User_Check_C INTO l_sec_User_Id,l_sec_User_Name,l_sec_cust_id, l_sec_emp_id;
552:
553: --skpandey.Bug: 4583789
554: IF Fnd_User_Check_C%FOUND THEN
555: OPEN get_person_num (r_rec_query.Person_Id);
556: FETCH get_person_num INTO l_person_num;
557: CLOSE get_person_num;
558: FND_MESSAGE.SET_NAME('IGS','IGS_SC_MUL_FND_USER');

Line 558: FND_MESSAGE.SET_NAME('IGS','IGS_SC_MUL_FND_USER');

554: IF Fnd_User_Check_C%FOUND THEN
555: OPEN get_person_num (r_rec_query.Person_Id);
556: FETCH get_person_num INTO l_person_num;
557: CLOSE get_person_num;
558: FND_MESSAGE.SET_NAME('IGS','IGS_SC_MUL_FND_USER');
559: FND_MESSAGE.SET_TOKEN('PERS_NUM',l_person_num);
560: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
561: ELSE
562:

Line 577: -- IMP: FND_USER has cust_id , person_party_id and emp_id. If person is from HZ the cust = pp_id

573: IF l_enddate_array(i) IS NOT NULL THEN
574: l_start_date:=igs_ge_date.igsdate((l_startdate_array(i) ));
575: END IF;
576:
577: -- IMP: FND_USER has cust_id , person_party_id and emp_id. If person is from HZ the cust = pp_id
578: -- If person is from HR then cust is null and emp_id is not null
579: -- User WF APIs to verify if the user has any roles. First Check if user already has this role associated
580: -- get the role name, note its an igs role, so partion would be 0.
581:

Line 651: END IF; -- Fnd_User_Check_C%FOUND

647:
648:
649: --CLOSE DUP_ROLES_CHK_C;
650: END LOOP; -- l_usrroles_array
651: END IF; -- Fnd_User_Check_C%FOUND
652: END IF; -- l_usrroles_array
653: ELSE -- Fnd_User_Check_C%FOUND
654: OPEN get_person_num (r_rec_query.Person_Id);
655: FETCH get_person_num INTO l_person_num;

Line 653: ELSE -- Fnd_User_Check_C%FOUND

649: --CLOSE DUP_ROLES_CHK_C;
650: END LOOP; -- l_usrroles_array
651: END IF; -- Fnd_User_Check_C%FOUND
652: END IF; -- l_usrroles_array
653: ELSE -- Fnd_User_Check_C%FOUND
654: OPEN get_person_num (r_rec_query.Person_Id);
655: FETCH get_person_num INTO l_person_num;
656: CLOSE get_person_num;
657: FND_MESSAGE.SET_NAME('IGS','IGS_SC_NO_FND_USER');

Line 657: FND_MESSAGE.SET_NAME('IGS','IGS_SC_NO_FND_USER');

653: ELSE -- Fnd_User_Check_C%FOUND
654: OPEN get_person_num (r_rec_query.Person_Id);
655: FETCH get_person_num INTO l_person_num;
656: CLOSE get_person_num;
657: FND_MESSAGE.SET_NAME('IGS','IGS_SC_NO_FND_USER');
658: FND_MESSAGE.SET_TOKEN('PERS_NUM',l_person_num);
659: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
660: END IF; /*END of IF of FND_USER */
661: CLOSE Fnd_User_Check_C;

Line 660: END IF; /END of IF of FND_USER /

656: CLOSE get_person_num;
657: FND_MESSAGE.SET_NAME('IGS','IGS_SC_NO_FND_USER');
658: FND_MESSAGE.SET_TOKEN('PERS_NUM',l_person_num);
659: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
660: END IF; /*END of IF of FND_USER */
661: CLOSE Fnd_User_Check_C;
662:
663: END LOOP; -- c_cur_query
664: CLOSE c_cur_query;

Line 661: CLOSE Fnd_User_Check_C;

657: FND_MESSAGE.SET_NAME('IGS','IGS_SC_NO_FND_USER');
658: FND_MESSAGE.SET_TOKEN('PERS_NUM',l_person_num);
659: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
660: END IF; /*END of IF of FND_USER */
661: CLOSE Fnd_User_Check_C;
662:
663: END LOOP; -- c_cur_query
664: CLOSE c_cur_query;
665: END LOOP;

Line 694: IF Fnd_User_Check_C%isopen then

690: retcode := 2;
691: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
692: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
693:
694: IF Fnd_User_Check_C%isopen then
695: CLOSE Fnd_User_Check_C;
696: END IF;
697:
698: IF GET_ROLE_NAME_C%isopen then

Line 695: CLOSE Fnd_User_Check_C;

691: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
692: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
693:
694: IF Fnd_User_Check_C%isopen then
695: CLOSE Fnd_User_Check_C;
696: END IF;
697:
698: IF GET_ROLE_NAME_C%isopen then
699: CLOSE GET_ROLE_NAME_C;

Line 722: IF Fnd_User_Check_C%isopen then

718: retcode := 2;
719: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
720: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
721:
722: IF Fnd_User_Check_C%isopen then
723: CLOSE Fnd_User_Check_C;
724: END IF;
725:
726: IF GET_ROLE_NAME_C%isopen then

Line 723: CLOSE Fnd_User_Check_C;

719: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
720: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
721:
722: IF Fnd_User_Check_C%isopen then
723: CLOSE Fnd_User_Check_C;
724: END IF;
725:
726: IF GET_ROLE_NAME_C%isopen then
727: CLOSE GET_ROLE_NAME_C;