APPS.IGS_AV_GEN_001 dependencies on IGS_AV_GEN_001

Line 1: PACKAGE BODY IGS_AV_GEN_001 AS

1: PACKAGE BODY IGS_AV_GEN_001 AS
2: /* $Header: IGSAV01B.pls 120.12 2006/05/04 00:02:26 amanohar ship $ */
3:
4:
5: /******************************************************************

Line 143: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_AV_GEN_001.advp_del_adv_stnd','Deleted unit basis for'||v_unit_all.av_stnd_unit_id );

139: X_ROWID => v_unit_basis_all.rowid );
140: END LOOP;
141:
142: IF (fnd_log.level_statement >=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
143: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_AV_GEN_001.advp_del_adv_stnd','Deleted unit basis for'||v_unit_all.av_stnd_unit_id );
144: END IF;
145:
146: FOR v_alt_unt_all IN c_alt_unt_all(v_unit_all.av_stnd_unit_id)
147: LOOP

Line 158: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_AV_GEN_001.advp_del_adv_stnd','Deleted unit');

154: X_ROWID => v_unit_all.rowid );
155:
156:
157: IF (fnd_log.level_statement >=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
158: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_AV_GEN_001.advp_del_adv_stnd','Deleted unit');
159: END IF;
160:
161: END LOOP;
162:

Line 174: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_AV_GEN_001.advp_del_adv_stnd','Deleted unit level basis'||v_unit_lvl_all.av_stnd_unit_lvl_id);

170: X_ROWID => v_ulvlbasis_all.rowid );
171: END LOOP;
172:
173: IF (fnd_log.level_statement >=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
174: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_AV_GEN_001.advp_del_adv_stnd','Deleted unit level basis'||v_unit_lvl_all.av_stnd_unit_lvl_id);
175: END IF;
176:
177: igs_av_stnd_unit_lvl_pkg.DELETE_ROW (
178: X_ROWID => v_unit_lvl_all.rowid );

Line 182: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_AV_GEN_001.advp_del_adv_stnd','Deleted unit level');

178: X_ROWID => v_unit_lvl_all.rowid );
179:
180:
181: IF (fnd_log.level_statement >=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
182: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_AV_GEN_001.advp_del_adv_stnd','Deleted unit level');
183: END IF;
184:
185: END LOOP;
186:

Line 193: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_AV_GEN_001.advp_del_adv_stnd','Deleted from IGS_AV_ADV_STANDING_ALL');

189: igs_av_adv_standing_pkg.DELETE_ROW (
190: X_ROWID => v_adv_all.rowid );
191:
192: IF (fnd_log.level_statement >=FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
193: fnd_log.string( fnd_log.level_statement, 'igs.plsql.IGS_AV_GEN_001.advp_del_adv_stnd','Deleted from IGS_AV_ADV_STANDING_ALL');
194: END IF;
195:
196: END LOOP;
197:

Line 232: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ADVP_DEL_ADV_STND');

228: END;
229: EXCEPTION
230: WHEN OTHERS THEN
231: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
232: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ADVP_DEL_ADV_STND');
233: Igs_Ge_Msg_Stack.Add;
234: App_Exception.Raise_Exception;
235: END advp_del_adv_stnd;
236:

Line 1210: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ADVP_UPD_AS_PE_GRANT');

1206: END;
1207: EXCEPTION
1208: WHEN OTHERS THEN
1209: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1210: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ADVP_UPD_AS_PE_GRANT');
1211: Igs_Ge_Msg_Stack.Add;
1212:
1213: lv_param_values := To_Char(p_person_id)||p_course_cd||To_Char(p_version_number)||
1214: FND_DATE.DATE_TO_DISPLAYDATE(p_granted_dt)||p_process_type||p_s_log_type||

Line 1560: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ENRPL_DELETE_SUA_RECS');

1556: END IF;
1557: EXCEPTION
1558: WHEN OTHERS THEN
1559: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1560: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ENRPL_DELETE_SUA_RECS');
1561: Igs_Ge_Msg_Stack.Add;
1562: App_Exception.Raise_Exception;
1563: END;
1564: END enrpl_delete_sua_recs;

Line 1748: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ADVP_UPD_SUA_ADVSTND');

1744: RETURN TRUE;
1745: EXCEPTION
1746: WHEN OTHERS THEN
1747: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1748: Fnd_Message.Set_Token('NAME','IGS_AV_GEN_001.ADVP_UPD_SUA_ADVSTND');
1749: Igs_Ge_Msg_Stack.Add;
1750: App_Exception.Raise_Exception;
1751: END;
1752: END advp_upd_sua_advstnd;

Line 2351: END IGS_AV_GEN_001;

2347: END adv_cal_creditpts;
2348:
2349:
2350:
2351: END IGS_AV_GEN_001;