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_AD_SS_GEN_001 dependencies on IGS_GE_NUMBER

Line 169: IGS_GE_NUMBER.TO_CANN(c_adm_appl_rec.person_id),

165: p_adm_appl_number => l_admission_appl_number,
166: p_ss_adm_appl_number => c_adm_appl_rec.ss_adm_appl_id) THEN
167: logDetail('create_program ' || ' is successul ' ||
168: ' Person Id : ' ||
169: IGS_GE_NUMBER.TO_CANN(c_adm_appl_rec.person_id),
170: 'S');
171: END IF;
172:
173: ELSE

Line 720: IGS_GE_NUMBER.TO_CANN(p_person_id),

716: WHEN OTHERS THEN
717: logDetail('inside update_person_type' ||
718: 'Exception from IGS_PE_TYP_INSTANCES_PKG.insert_row ' ||
719: SQLERRM || 'person_id : ' ||
720: IGS_GE_NUMBER.TO_CANN(p_person_id),
721: 'S');
722: IF FND_MSG_PUB.Count_Msg < 1 THEN
723: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
724: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.update_person_type -'||SQLERRM);

Line 807: IGS_GE_NUMBER.TO_CANN(p_person_id),

803: WHEN OTHERS THEN
804: logDetail('Inside insert_unit_set_dtls' ||
805: 'Exception from IGS_AD_UNIT_SETS_PKG.insert_row ' ||
806: SQLERRM || 'person_id : ' ||
807: IGS_GE_NUMBER.TO_CANN(p_person_id),
808: 'S');
809: IF FND_MSG_PUB.Count_Msg < 1 THEN
810: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
811: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_unit_set_dtls -'||SQLERRM);

Line 871: IGS_GE_NUMBER.TO_CANN(p_person_id),

867:
868: logDetail('Inside insert_acad_interest' ||
869: 'Exception from IGS_AD_ACAD_INTEREST_PKG.insert_row ' ||
870: SQLERRM || 'person_id : ' ||
871: IGS_GE_NUMBER.TO_CANN(p_person_id),
872: 'S');
873: IF FND_MSG_PUB.Count_Msg < 1 THEN
874: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
875: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_acad_interest -'||SQLERRM);

Line 950: IGS_GE_NUMBER.TO_CANN(p_person_id),

946: WHEN OTHERS THEN
947: logDetail('Inside insert_applicant_intent' ||
948: 'Exception from IGS_AD_APP_INTENT_PKG.insert_row ' ||
949: SQLERRM || 'person_id : ' ||
950: IGS_GE_NUMBER.TO_CANN(p_person_id),
951: 'S');
952: IF FND_MSG_PUB.Count_Msg < 1 THEN
953: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
954: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_applicant_intent -'||SQLERRM);

Line 1009: IGS_GE_NUMBER.TO_CANN(p_person_id),

1005: WHEN OTHERS THEN
1006: logDetail('Inside insert_spl_talent' ||
1007: 'Exception from IGS_AD_SPL_TALENTS_PKG.insert_row ' ||
1008: SQLERRM || 'person_id : ' ||
1009: IGS_GE_NUMBER.TO_CANN(p_person_id),
1010: 'S');
1011: IF FND_MSG_PUB.Count_Msg < 1 THEN
1012: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1013: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_spl_talent -'||SQLERRM);

Line 1068: IGS_GE_NUMBER.TO_CANN(p_person_id),

1064: WHEN OTHERS THEN
1065: logDetail('Inside insert_special_interest' ||
1066: 'Exception from IGS_AD_SPL_INTERESTS_PKG.insert_row ' ||
1067: SQLERRM || 'person_id : ' ||
1068: IGS_GE_NUMBER.TO_CANN(p_person_id),
1069: 'S');
1070: IF FND_MSG_PUB.Count_Msg < 1 THEN
1071: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1072: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_special_interest -'||SQLERRM);

Line 1126: IGS_GE_NUMBER.TO_CANN(p_person_id),

1122: WHEN OTHERS THEN
1123: logDetail('Inside insert_othinst' ||
1124: 'Exception from IGS_AD_OTHER_INST_PKG.insert_row ' ||
1125: SQLERRM || 'person_id : ' ||
1126: IGS_GE_NUMBER.TO_CANN(p_person_id),
1127: 'S');
1128: IF FND_MSG_PUB.Count_Msg < 1 THEN
1129: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1130: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_othinst -'||SQLERRM);

Line 1193: 'person_id : ' || IGS_GE_NUMBER.TO_CANN(p_person_id),

1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: logDetail('insert_edugoal_details' ||
1192: 'Exception from IGS_AD_EDUGOAL_PKG.insert_row' || SQLERRM ||
1193: 'person_id : ' || IGS_GE_NUMBER.TO_CANN(p_person_id),
1194: 'S');
1195: IF FND_MSG_PUB.Count_Msg < 1 THEN
1196: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1197: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_edugoal_details -'||SQLERRM);

Line 1260: 'person_id : ' || IGS_GE_NUMBER.TO_CANN(p_person_id),

1256: END;
1257: EXCEPTION
1258: WHEN OTHERS THEN
1259: logDetail('insert igs_ss_adm_appl_stg' || SQLERRM ||
1260: 'person_id : ' || IGS_GE_NUMBER.TO_CANN(p_person_id),
1261: 'S');
1262: x_return_status := 'E';
1263: x_message_name := 'IGS_GE_UNHANDLED_EXP';
1264: IF FND_MSG_PUB.Count_Msg < 1 THEN

Line 1346: 'person_id : ' || IGS_GE_NUMBER.TO_CANN(p_person_id),

1342: END IF;
1343: EXCEPTION
1344: WHEN OTHERS THEN
1345: logDetail('insert igs_ss_appl_perstat' || SQLERRM ||
1346: 'person_id : ' || IGS_GE_NUMBER.TO_CANN(p_person_id),
1347: 'S');
1348: p_return_status := 'E';
1349: p_message_data := 'IGS_GE_UNHANDLED_EXP';
1350: IF FND_MSG_PUB.Count_Msg < 1 THEN

Line 1531: l_from_pk1_value := IGS_GE_NUMBER.TO_CANN(c_ss_appl_perstat_rec.SS_PERSTAT_ID);

1527: FETCH c_ad_appl_perstat INTO l_to_pk1_value;
1528: EXIT WHEN c_ad_appl_perstat%NOTFOUND;
1529: */
1530:
1531: l_from_pk1_value := IGS_GE_NUMBER.TO_CANN(c_ss_appl_perstat_rec.SS_PERSTAT_ID);
1532: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IGS_SS_APPL_PERSTAT',
1533: X_from_pk1_value => l_from_pk1_value,
1534: X_from_pk2_value => NULL,
1535: X_from_pk3_value => NULL,

Line 3366: 'person_id : ' || IGS_GE_NUMBER.TO_CANN(p_person_id),

3362: EXCEPTION
3363: WHEN OTHERS THEN
3364: logDetail('Inside insert_application_fee' ||
3365: 'Exception from IGS_AD_APP_REQ_PKG.insert_row ' || SQLERRM ||
3366: 'person_id : ' || IGS_GE_NUMBER.TO_CANN(p_person_id),
3367: 'S');
3368: IF FND_MSG_PUB.Count_Msg < 1 THEN
3369: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3370: Fnd_Message.Set_Token('NAME','IGS_AD_SS_GEN_001.insert_application_fee -'||SQLERRM);