DBA Data[Home] [Help]

APPS.IGS_AD_SS_GEN_001 dependencies on IGS_AD_UNIT_SETS_PKG

Line 741: FLOW: IGS_AD_UNIT_SETS_PKG.insert_row

737: /*****************************************************************************************
738: Created By: [email protected]
739: Date Created : 11-DEC-2001
740: Purpose: 1. Inserts Unit Set Details (Major1/Major2)
741: FLOW: IGS_AD_UNIT_SETS_PKG.insert_row
742: Known limitations,enhancements,remarks:
743: Change History
744: Who When What
745: nshee 29-OCT-2002 Modified it, now it inserts data from desired unit sets and not the major1/major2.

Line 779: logDetail('Before call to IGS_AD_UNIT_SETS_PKG.insert_row', 'S');

775: CLOSE c_nxt_rank;*/
776:
777: FOR c_des_unit_sets_rec IN c_des_unit_sets LOOP
778: IF c_des_unit_sets_rec.unit_set_cd IS NOT NULL THEN
779: logDetail('Before call to IGS_AD_UNIT_SETS_PKG.insert_row', 'S');
780: l_rowid := '';
781: l_unit_set_id := 0;
782:
783:

Line 789: IGS_AD_UNIT_SETS_PKG.insert_row(x_rowid => l_rowid,

785: THEN
786: lv_mode := 'S';
787: END IF;
788:
789: IGS_AD_UNIT_SETS_PKG.insert_row(x_rowid => l_rowid,
790: x_unit_set_id => l_unit_set_id,
791: x_person_id => p_person_id,
792: x_admission_appl_number => p_adm_appl_number,
793: x_nominated_course_cd => p_nominated_course_cd,

Line 805: 'Exception from IGS_AD_UNIT_SETS_PKG.insert_row ' ||

801: END LOOP;
802: EXCEPTION
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