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_AD_APP_REQ

Line 18: igs_ad_app_req_pkg.insert_row in insert_application_fee()

14: in SS Applicant Floe, for the IGS.M build
15: abhiskum 21-Mar-2005 Removed call to Update_Appl_Ofres_Inst() in process_OneStop2 for Bug 4234911.
16: pathipat 17-Jun-2003 Enh 2831587 FI210 Credit Card Fund Transfer build
17: Modified procedure update_ad_offer_resp_and_fee() and call to
18: igs_ad_app_req_pkg.insert_row in insert_application_fee()
19: smadathi 29-Nov-2002 Enh#2584986.Modifications done in procedures update_ad_offer_resp_and_fee.
20: vvutukur 26-Nov-2002 Enh#2584986.Modifications done in procedures update_ad_offer_resp_and_fee,
21: insert_application_fee.
22: nshee 29-Aug-2002 Bug 2395510 added 6 columns as part of deferments build

Line 86: PROCEDURE insert_application_fee(p_person_id IN igs_ad_app_req.person_id%TYPE,

82: p_admission_appl_number IN IGS_AD_APPL_PERSTAT.admission_appl_number%TYPE,
83: x_return_status OUT NOCOPY VARCHAR2);
84: -- Bug # 2389273 [ APPLICATION FEE SAVED IN SS IS NOT SAVED TO FORMS ]
85: --** added by nshee
86: PROCEDURE insert_application_fee(p_person_id IN igs_ad_app_req.person_id%TYPE,
87: p_adm_appl_id IN igs_ss_app_req_stg.ss_adm_appl_id%TYPE,
88: p_adm_appl_number IN igs_ad_app_req.admission_appl_number%TYPE);
89: --** end of addtion by nshee
90:

Line 88: p_adm_appl_number IN igs_ad_app_req.admission_appl_number%TYPE);

84: -- Bug # 2389273 [ APPLICATION FEE SAVED IN SS IS NOT SAVED TO FORMS ]
85: --** added by nshee
86: PROCEDURE insert_application_fee(p_person_id IN igs_ad_app_req.person_id%TYPE,
87: p_adm_appl_id IN igs_ss_app_req_stg.ss_adm_appl_id%TYPE,
88: p_adm_appl_number IN igs_ad_app_req.admission_appl_number%TYPE);
89: --** end of addtion by nshee
90:
91:
92: -- begin apadegal

Line 1713: l_revenue_acct_code igs_ad_app_req.REV_ACCOUNT_CD%TYPE;

1709: x_message_data OUT NOCOPY VARCHAR2) AS
1710:
1711: l_fee_amount NUMBER;
1712: l_msg_count NUMBER;
1713: l_revenue_acct_code igs_ad_app_req.REV_ACCOUNT_CD%TYPE;
1714: l_cash_acct_code igs_ad_app_req.CASH_ACCOUNT_CD%TYPE;
1715: l_revenue_acct_ccid igs_ad_app_req.REV_GL_CCID%TYPE;
1716: l_cash_acct_ccid igs_ad_app_req.CASH_GL_CCID%TYPE;
1717:

Line 1714: l_cash_acct_code igs_ad_app_req.CASH_ACCOUNT_CD%TYPE;

1710:
1711: l_fee_amount NUMBER;
1712: l_msg_count NUMBER;
1713: l_revenue_acct_code igs_ad_app_req.REV_ACCOUNT_CD%TYPE;
1714: l_cash_acct_code igs_ad_app_req.CASH_ACCOUNT_CD%TYPE;
1715: l_revenue_acct_ccid igs_ad_app_req.REV_GL_CCID%TYPE;
1716: l_cash_acct_ccid igs_ad_app_req.CASH_GL_CCID%TYPE;
1717:
1718:

Line 1715: l_revenue_acct_ccid igs_ad_app_req.REV_GL_CCID%TYPE;

1711: l_fee_amount NUMBER;
1712: l_msg_count NUMBER;
1713: l_revenue_acct_code igs_ad_app_req.REV_ACCOUNT_CD%TYPE;
1714: l_cash_acct_code igs_ad_app_req.CASH_ACCOUNT_CD%TYPE;
1715: l_revenue_acct_ccid igs_ad_app_req.REV_GL_CCID%TYPE;
1716: l_cash_acct_ccid igs_ad_app_req.CASH_GL_CCID%TYPE;
1717:
1718:
1719: BEGIN

Line 1716: l_cash_acct_ccid igs_ad_app_req.CASH_GL_CCID%TYPE;

1712: l_msg_count NUMBER;
1713: l_revenue_acct_code igs_ad_app_req.REV_ACCOUNT_CD%TYPE;
1714: l_cash_acct_code igs_ad_app_req.CASH_ACCOUNT_CD%TYPE;
1715: l_revenue_acct_ccid igs_ad_app_req.REV_GL_CCID%TYPE;
1716: l_cash_acct_ccid igs_ad_app_req.CASH_GL_CCID%TYPE;
1717:
1718:
1719: BEGIN
1720:

Line 3291: PROCEDURE insert_application_fee(p_person_id IN igs_ad_app_req.person_id%TYPE,

3287: l_late_ind);
3288: END validate_prog_inst;
3289:
3290: -- Bug # 2389273 [ APPLICATION FEE SAVED IN SS IS NOT SAVED TO FORMS ]
3291: PROCEDURE insert_application_fee(p_person_id IN igs_ad_app_req.person_id%TYPE,
3292: p_adm_appl_id IN igs_ss_app_req_stg.ss_adm_appl_id%TYPE,
3293: p_adm_appl_number IN igs_ad_app_req.admission_appl_number%TYPE) AS
3294: /*----------------------------------------------------------------------------
3295: || Created By :

Line 3293: p_adm_appl_number IN igs_ad_app_req.admission_appl_number%TYPE) AS

3289:
3290: -- Bug # 2389273 [ APPLICATION FEE SAVED IN SS IS NOT SAVED TO FORMS ]
3291: PROCEDURE insert_application_fee(p_person_id IN igs_ad_app_req.person_id%TYPE,
3292: p_adm_appl_id IN igs_ss_app_req_stg.ss_adm_appl_id%TYPE,
3293: p_adm_appl_number IN igs_ad_app_req.admission_appl_number%TYPE) AS
3294: /*----------------------------------------------------------------------------
3295: || Created By :
3296: || Created On :
3297: || Purpose :

Line 3303: || Added 3 new params in call to igs_ad_app_req_pkg.insert_row

3299: || Change History :
3300: || Who When What
3301: || (reverse chronological order - newest change first)
3302: || pathipat 17-Jun-2003 Enh 2831587 - FI210 Credit Card Fund Transfer build
3303: || Added 3 new params in call to igs_ad_app_req_pkg.insert_row
3304: ||vvutukur 26-Nov-2002 Enh#2584986.Added 11 new parameters to the call to igs_ad_app_req_pkg.insert_row
3305: || (attributing to credit card details,Accounting information and the GL_DATE)
3306: || as part of GL Interface Build and passed NULL to all of them.
3307: ----------------------------------------------------------------------------*/

Line 3304: ||vvutukur 26-Nov-2002 Enh#2584986.Added 11 new parameters to the call to igs_ad_app_req_pkg.insert_row

3300: || Who When What
3301: || (reverse chronological order - newest change first)
3302: || pathipat 17-Jun-2003 Enh 2831587 - FI210 Credit Card Fund Transfer build
3303: || Added 3 new params in call to igs_ad_app_req_pkg.insert_row
3304: ||vvutukur 26-Nov-2002 Enh#2584986.Added 11 new parameters to the call to igs_ad_app_req_pkg.insert_row
3305: || (attributing to credit card details,Accounting information and the GL_DATE)
3306: || as part of GL Interface Build and passed NULL to all of them.
3307: ----------------------------------------------------------------------------*/
3308:

Line 3310: l_app_req_id igs_ad_app_req.app_req_id%TYPE;

3306: || as part of GL Interface Build and passed NULL to all of them.
3307: ----------------------------------------------------------------------------*/
3308:
3309: l_rowid VARCHAR2(25);
3310: l_app_req_id igs_ad_app_req.app_req_id%TYPE;
3311:
3312: CURSOR c_appl_fee IS
3313: SELECT ss_app_req_id,
3314: applicant_fee_type,

Line 3333: logDetail('Before call to IGS_AD_APP_REQ_PKG.insert_row', 'S');

3329: END IF;
3330: logHeader('insert_application_fee', 'S');
3331: FOR c_appl_fee_rec IN c_appl_fee LOOP
3332: IF c_appl_fee_rec.ss_app_req_id IS NOT NULL THEN
3333: logDetail('Before call to IGS_AD_APP_REQ_PKG.insert_row', 'S');
3334: igs_ad_app_req_pkg.insert_row(x_rowid => l_rowid,
3335: x_app_req_id => l_app_req_id,
3336: x_person_id => p_person_id,
3337: x_admission_appl_number => p_adm_appl_number,

Line 3334: igs_ad_app_req_pkg.insert_row(x_rowid => l_rowid,

3330: logHeader('insert_application_fee', 'S');
3331: FOR c_appl_fee_rec IN c_appl_fee LOOP
3332: IF c_appl_fee_rec.ss_app_req_id IS NOT NULL THEN
3333: logDetail('Before call to IGS_AD_APP_REQ_PKG.insert_row', 'S');
3334: igs_ad_app_req_pkg.insert_row(x_rowid => l_rowid,
3335: x_app_req_id => l_app_req_id,
3336: x_person_id => p_person_id,
3337: x_admission_appl_number => p_adm_appl_number,
3338: x_applicant_fee_type => c_appl_fee_rec.applicant_fee_type,

Line 3365: 'Exception from IGS_AD_APP_REQ_PKG.insert_row ' || SQLERRM ||

3361: END LOOP;
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');