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

Line 1091: || valid person in system or not. If valid and has an fnd user then return

1087: /******************************************************************************************
1088: || Created By : smanglm
1089: || Created On : 2003/01/15
1090: || Purpose : The procedure is to validate that the student passed by 3rd party s/w is
1091: || valid person in system or not. If valid and has an fnd user then return
1092: || the person id and the user defined person type for system type of 'STUDENT'.
1093: || Change History :
1094: || Who When What
1095: || (reverse chronological order - newest change first)

Line 1096: || bdeviset 14-APR-2005 changed cursor c_vld_fnd_user for bug # 4303661

1092: || the person id and the user defined person type for system type of 'STUDENT'.
1093: || Change History :
1094: || Who When What
1095: || (reverse chronological order - newest change first)
1096: || bdeviset 14-APR-2005 changed cursor c_vld_fnd_user for bug # 4303661
1097: ******************************************************************************************/
1098:
1099: IS
1100: /*

Line 1112: CURSOR c_vld_fnd_user (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

1108:
1109: /*
1110: cursor to validate that person is valid apps user in system
1111: */
1112: CURSOR c_vld_fnd_user (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1113: SELECT user_id
1114: FROM fnd_user
1115: WHERE person_party_id = cp_person_id;
1116: l_vld_fnd_user_id fnd_user.user_id%TYPE;

Line 1114: FROM fnd_user

1110: cursor to validate that person is valid apps user in system
1111: */
1112: CURSOR c_vld_fnd_user (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1113: SELECT user_id
1114: FROM fnd_user
1115: WHERE person_party_id = cp_person_id;
1116: l_vld_fnd_user_id fnd_user.user_id%TYPE;
1117:
1118: /*

Line 1116: l_vld_fnd_user_id fnd_user.user_id%TYPE;

1112: CURSOR c_vld_fnd_user (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1113: SELECT user_id
1114: FROM fnd_user
1115: WHERE person_party_id = cp_person_id;
1116: l_vld_fnd_user_id fnd_user.user_id%TYPE;
1117:
1118: /*
1119: cursor to validate that the person number is a valid 'STUDENT' in the system
1120: */

Line 1137: CURSOR c_fnd_user_dtls (cp_user_id fnd_user_resp_groups.user_id%TYPE) IS

1133:
1134: /*
1135: cursor to fetch the RESP_ID and RESP_APPL_ID against the user_id
1136: */
1137: CURSOR c_fnd_user_dtls (cp_user_id fnd_user_resp_groups.user_id%TYPE) IS
1138: SELECT responsibility_id,
1139: responsibility_application_id,
1140: security_group_id
1141: FROM fnd_user_resp_groups

Line 1141: FROM fnd_user_resp_groups

1137: CURSOR c_fnd_user_dtls (cp_user_id fnd_user_resp_groups.user_id%TYPE) IS
1138: SELECT responsibility_id,
1139: responsibility_application_id,
1140: security_group_id
1141: FROM fnd_user_resp_groups
1142: WHERE user_id = cp_user_id
1143: AND SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);
1144: rec_fnd_user_dtls c_fnd_user_dtls%ROWTYPE;
1145:

Line 1144: rec_fnd_user_dtls c_fnd_user_dtls%ROWTYPE;

1140: security_group_id
1141: FROM fnd_user_resp_groups
1142: WHERE user_id = cp_user_id
1143: AND SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);
1144: rec_fnd_user_dtls c_fnd_user_dtls%ROWTYPE;
1145:
1146: BEGIN
1147: /*
1148: Set the out parameter p_error_message as null and p_ret_status as 'TRUE'

Line 1179: OPEN c_vld_fnd_user (l_vld_person_id);

1175: CLOSE c_vld_person;
1176: /*
1177: validate that person is valid apps user in system
1178: */
1179: OPEN c_vld_fnd_user (l_vld_person_id);
1180: FETCH c_vld_fnd_user INTO l_vld_fnd_user_id;
1181: IF c_vld_fnd_user%NOTFOUND THEN
1182: CLOSE c_vld_fnd_user;
1183: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PERSON_NOT_FND_USER');

Line 1180: FETCH c_vld_fnd_user INTO l_vld_fnd_user_id;

1176: /*
1177: validate that person is valid apps user in system
1178: */
1179: OPEN c_vld_fnd_user (l_vld_person_id);
1180: FETCH c_vld_fnd_user INTO l_vld_fnd_user_id;
1181: IF c_vld_fnd_user%NOTFOUND THEN
1182: CLOSE c_vld_fnd_user;
1183: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PERSON_NOT_FND_USER');
1184: FND_MSG_PUB.ADD;

Line 1181: IF c_vld_fnd_user%NOTFOUND THEN

1177: validate that person is valid apps user in system
1178: */
1179: OPEN c_vld_fnd_user (l_vld_person_id);
1180: FETCH c_vld_fnd_user INTO l_vld_fnd_user_id;
1181: IF c_vld_fnd_user%NOTFOUND THEN
1182: CLOSE c_vld_fnd_user;
1183: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PERSON_NOT_FND_USER');
1184: FND_MSG_PUB.ADD;
1185: p_error_message := 'IGS_EN_PERSON_NOT_FND_USER';

Line 1182: CLOSE c_vld_fnd_user;

1178: */
1179: OPEN c_vld_fnd_user (l_vld_person_id);
1180: FETCH c_vld_fnd_user INTO l_vld_fnd_user_id;
1181: IF c_vld_fnd_user%NOTFOUND THEN
1182: CLOSE c_vld_fnd_user;
1183: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PERSON_NOT_FND_USER');
1184: FND_MSG_PUB.ADD;
1185: p_error_message := 'IGS_EN_PERSON_NOT_FND_USER';
1186: p_ret_status := 'FALSE';

Line 1183: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PERSON_NOT_FND_USER');

1179: OPEN c_vld_fnd_user (l_vld_person_id);
1180: FETCH c_vld_fnd_user INTO l_vld_fnd_user_id;
1181: IF c_vld_fnd_user%NOTFOUND THEN
1182: CLOSE c_vld_fnd_user;
1183: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PERSON_NOT_FND_USER');
1184: FND_MSG_PUB.ADD;
1185: p_error_message := 'IGS_EN_PERSON_NOT_FND_USER';
1186: p_ret_status := 'FALSE';
1187: RETURN;

Line 1185: p_error_message := 'IGS_EN_PERSON_NOT_FND_USER';

1181: IF c_vld_fnd_user%NOTFOUND THEN
1182: CLOSE c_vld_fnd_user;
1183: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PERSON_NOT_FND_USER');
1184: FND_MSG_PUB.ADD;
1185: p_error_message := 'IGS_EN_PERSON_NOT_FND_USER';
1186: p_ret_status := 'FALSE';
1187: RETURN;
1188: END IF;
1189: CLOSE c_vld_fnd_user;

Line 1189: CLOSE c_vld_fnd_user;

1185: p_error_message := 'IGS_EN_PERSON_NOT_FND_USER';
1186: p_ret_status := 'FALSE';
1187: RETURN;
1188: END IF;
1189: CLOSE c_vld_fnd_user;
1190: /*
1191: Validate that the person number is a valid 'STUDENT' in the system
1192: */
1193: OPEN c_vld_student (l_vld_person_id);

Line 1207: OPEN c_fnd_user_dtls (l_vld_fnd_user_id);

1203: CLOSE c_vld_student;
1204: /*
1205: fetch the RESP_ID and RESP_APPL_ID against the user_id
1206: */
1207: OPEN c_fnd_user_dtls (l_vld_fnd_user_id);
1208: FETCH c_fnd_user_dtls INTO rec_fnd_user_dtls;
1209: IF c_fnd_user_dtls%NOTFOUND THEN
1210: CLOSE c_fnd_user_dtls;
1211: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PERSON_NO_RESP');

Line 1208: FETCH c_fnd_user_dtls INTO rec_fnd_user_dtls;

1204: /*
1205: fetch the RESP_ID and RESP_APPL_ID against the user_id
1206: */
1207: OPEN c_fnd_user_dtls (l_vld_fnd_user_id);
1208: FETCH c_fnd_user_dtls INTO rec_fnd_user_dtls;
1209: IF c_fnd_user_dtls%NOTFOUND THEN
1210: CLOSE c_fnd_user_dtls;
1211: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PERSON_NO_RESP');
1212: FND_MSG_PUB.ADD;

Line 1209: IF c_fnd_user_dtls%NOTFOUND THEN

1205: fetch the RESP_ID and RESP_APPL_ID against the user_id
1206: */
1207: OPEN c_fnd_user_dtls (l_vld_fnd_user_id);
1208: FETCH c_fnd_user_dtls INTO rec_fnd_user_dtls;
1209: IF c_fnd_user_dtls%NOTFOUND THEN
1210: CLOSE c_fnd_user_dtls;
1211: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PERSON_NO_RESP');
1212: FND_MSG_PUB.ADD;
1213: p_error_message := 'IGS_EN_PERSON_NO_RESP';

Line 1210: CLOSE c_fnd_user_dtls;

1206: */
1207: OPEN c_fnd_user_dtls (l_vld_fnd_user_id);
1208: FETCH c_fnd_user_dtls INTO rec_fnd_user_dtls;
1209: IF c_fnd_user_dtls%NOTFOUND THEN
1210: CLOSE c_fnd_user_dtls;
1211: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PERSON_NO_RESP');
1212: FND_MSG_PUB.ADD;
1213: p_error_message := 'IGS_EN_PERSON_NO_RESP';
1214: p_ret_status := 'FALSE';

Line 1217: CLOSE c_fnd_user_dtls;

1213: p_error_message := 'IGS_EN_PERSON_NO_RESP';
1214: p_ret_status := 'FALSE';
1215: RETURN;
1216: END IF;
1217: CLOSE c_fnd_user_dtls;
1218:
1219: /*
1220: set the apps context
1221: */

Line 1224: user_id => l_vld_fnd_user_id,

1220: set the apps context
1221: */
1222: fnd_global.apps_initialize
1223: (
1224: user_id => l_vld_fnd_user_id,
1225: resp_id => rec_fnd_user_dtls.responsibility_id,
1226: resp_appl_id => rec_fnd_user_dtls.responsibility_application_id,
1227: security_group_id => rec_fnd_user_dtls.security_group_id
1228: );

Line 1225: resp_id => rec_fnd_user_dtls.responsibility_id,

1221: */
1222: fnd_global.apps_initialize
1223: (
1224: user_id => l_vld_fnd_user_id,
1225: resp_id => rec_fnd_user_dtls.responsibility_id,
1226: resp_appl_id => rec_fnd_user_dtls.responsibility_application_id,
1227: security_group_id => rec_fnd_user_dtls.security_group_id
1228: );
1229:

Line 1226: resp_appl_id => rec_fnd_user_dtls.responsibility_application_id,

1222: fnd_global.apps_initialize
1223: (
1224: user_id => l_vld_fnd_user_id,
1225: resp_id => rec_fnd_user_dtls.responsibility_id,
1226: resp_appl_id => rec_fnd_user_dtls.responsibility_application_id,
1227: security_group_id => rec_fnd_user_dtls.security_group_id
1228: );
1229:
1230: /*

Line 1227: security_group_id => rec_fnd_user_dtls.security_group_id

1223: (
1224: user_id => l_vld_fnd_user_id,
1225: resp_id => rec_fnd_user_dtls.responsibility_id,
1226: resp_appl_id => rec_fnd_user_dtls.responsibility_application_id,
1227: security_group_id => rec_fnd_user_dtls.security_group_id
1228: );
1229:
1230: /*
1231: assign obtained values to OUT parameters