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.IGF_SL_CL_CREATE_CHG dependencies on IGF_SL_CL_CREATE_CHG

Line 1: PACKAGE BODY igf_sl_cl_create_chg AS

1: PACKAGE BODY igf_sl_cl_create_chg AS
2: /* $Header: IGFSL22B.pls 120.1 2006/04/21 04:07:10 bvisvana noship $ */
3: ------------------------------------------------------------------
4: --Created by : Sanil Madathil, Oracle IDC
5: --Date created: 10 October 2004

Line 100: SAVEPOINT igf_sl_cl_create_chg_sp;

96: PRAGMA EXCEPTION_INIT(e_resource_busy,-00054);
97:
98: BEGIN
99:
100: SAVEPOINT igf_sl_cl_create_chg_sp;
101: log_to_fnd(p_v_module => 'create_loan_chg_rec',
102: p_v_string => ' Entered Procedure create_loan_chg_rec: The input parameters are ' ||
103: ' new reference of Award Id : ' ||p_new_loan_rec.award_id ||
104: ' new reference of Loan Id : ' ||p_new_loan_rec.loan_id ||

Line 706: ROLLBACK TO igf_sl_cl_create_chg_sp;

702: END IF;--end of if condition for checking if change record should be created or not
703:
704: EXCEPTION
705: WHEN e_resource_busy THEN
706: ROLLBACK TO igf_sl_cl_create_chg_sp;
707: log_to_fnd(p_v_module => 'create_loan_chg_rec',
708: p_v_string => ' e resource busy exception ' || SQLERRM
709: );
710: p_b_return_status := FALSE;

Line 714: ROLLBACK TO igf_sl_cl_create_chg_sp;

710: p_b_return_status := FALSE;
711: p_v_message_name := 'IGS_GE_RECORD_LOCKED';
712: RETURN;
713: WHEN e_valid_edits THEN
714: ROLLBACK TO igf_sl_cl_create_chg_sp;
715: log_to_fnd(p_v_module => 'create_loan_chg_rec',
716: p_v_string => ' e_valid_edits exception handler. change record validation raised errors '||l_v_message_name
717: );
718: p_b_return_status := FALSE;

Line 723: ROLLBACK TO igf_sl_cl_create_chg_sp;

719: p_v_message_name := l_v_message_name;
720: igf_sl_cl_chg_prc.g_message_tokens := l_d_message_tokens;
721: RETURN;
722: WHEN OTHERS THEN
723: ROLLBACK TO igf_sl_cl_create_chg_sp;
724: log_to_fnd(p_v_module => 'create_loan_chg_rec',
725: p_v_string => ' when others exception handler' ||SQLERRM
726: );
727: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');

Line 728: fnd_message.set_token('NAME','igf_sl_cl_create_chg.create_loan_chg_rec');

724: log_to_fnd(p_v_module => 'create_loan_chg_rec',
725: p_v_string => ' when others exception handler' ||SQLERRM
726: );
727: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
728: fnd_message.set_token('NAME','igf_sl_cl_create_chg.create_loan_chg_rec');
729: igs_ge_msg_stack.add;
730: app_exception.raise_exception;
731:
732: END create_loan_chg_rec;

Line 804: SAVEPOINT igf_sl_cl_create_chg_lor_sp;

800: l_d_message_tokens igf_sl_cl_chg_prc.token_tab%TYPE;
801: PRAGMA EXCEPTION_INIT(e_resource_busy,-00054);
802:
803: BEGIN
804: SAVEPOINT igf_sl_cl_create_chg_lor_sp;
805:
806: log_to_fnd(p_v_module => 'create_lor_chg_rec',
807: p_v_string => ' Entered Procedure create_lor_chg_rec: The input parameters are ' ||
808: ' new reference of origination id : ' ||p_new_lor_rec.origination_id ||

Line 1406: ROLLBACK TO igf_sl_cl_create_chg_lor_sp;

1402: END IF; --end of if condition for checking if change record should be created or not
1403:
1404: EXCEPTION
1405: WHEN e_resource_busy THEN
1406: ROLLBACK TO igf_sl_cl_create_chg_lor_sp;
1407: log_to_fnd(p_v_module => 'create_lor_chg_rec',
1408: p_v_string => ' e resource busy exception '||SQLERRM
1409: );
1410: p_b_return_status := FALSE;

Line 1414: ROLLBACK TO igf_sl_cl_create_chg_lor_sp;

1410: p_b_return_status := FALSE;
1411: p_v_message_name := 'IGS_GE_RECORD_LOCKED';
1412: RETURN;
1413: WHEN e_valid_edits THEN
1414: ROLLBACK TO igf_sl_cl_create_chg_lor_sp;
1415: log_to_fnd(p_v_module => 'create_lor_chg_rec',
1416: p_v_string => ' e_valid_edits exception handler. change record validation raised errors '||l_v_message_name
1417: );
1418: p_b_return_status := FALSE;

Line 1423: ROLLBACK TO igf_sl_cl_create_chg_lor_sp;

1419: p_v_message_name := l_v_message_name;
1420: igf_sl_cl_chg_prc.g_message_tokens := l_d_message_tokens;
1421: RETURN;
1422: WHEN OTHERS THEN
1423: ROLLBACK TO igf_sl_cl_create_chg_lor_sp;
1424: log_to_fnd(p_v_module => 'create_lor_chg_rec',
1425: p_v_string => ' when others exception handler'||SQLERRM
1426: );
1427: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');

Line 1428: fnd_message.set_token('NAME','igf_sl_cl_create_chg.create_lor_chg_rec');

1424: log_to_fnd(p_v_module => 'create_lor_chg_rec',
1425: p_v_string => ' when others exception handler'||SQLERRM
1426: );
1427: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1428: fnd_message.set_token('NAME','igf_sl_cl_create_chg.create_lor_chg_rec');
1429: igs_ge_msg_stack.add;
1430: app_exception.raise_exception;
1431:
1432: END create_lor_chg_rec;

Line 1519: SAVEPOINT igf_sl_cl_create_chg_awd_sp;

1515: PRAGMA EXCEPTION_INIT(e_resource_busy,-00054);
1516:
1517: BEGIN
1518:
1519: SAVEPOINT igf_sl_cl_create_chg_awd_sp;
1520:
1521: log_to_fnd(p_v_module => 'create_awd_chg_rec',
1522: p_v_string => ' Entered Procedure. The input parameters are ' ||
1523: ' new reference of Award Id : ' ||p_n_award_id ||

Line 2807: ROLLBACK TO igf_sl_cl_create_chg_awd_sp;

2803: END IF;
2804: END IF;
2805: EXCEPTION
2806: WHEN e_resource_busy THEN
2807: ROLLBACK TO igf_sl_cl_create_chg_awd_sp;
2808: log_to_fnd(p_v_module => 'create_awd_chg_rec',
2809: p_v_string => ' eresource busy exception handler ' ||SQLERRM
2810: );
2811: p_b_return_status := FALSE;

Line 2815: ROLLBACK TO igf_sl_cl_create_chg_awd_sp;

2811: p_b_return_status := FALSE;
2812: p_v_message_name := 'IGS_GE_RECORD_LOCKED';
2813: RETURN;
2814: WHEN e_valid_edits THEN
2815: ROLLBACK TO igf_sl_cl_create_chg_awd_sp;
2816: log_to_fnd(p_v_module => 'create_awd_chg_rec',
2817: p_v_string => ' e_valid_edits exception handler change record validation raised errors '||l_v_message_name
2818: );
2819: p_b_return_status := FALSE;

Line 2824: ROLLBACK TO igf_sl_cl_create_chg_awd_sp;

2820: p_v_message_name := l_v_message_name;
2821: igf_sl_cl_chg_prc.g_message_tokens := l_d_message_tokens;
2822: RETURN;
2823: WHEN OTHERS THEN
2824: ROLLBACK TO igf_sl_cl_create_chg_awd_sp;
2825: log_to_fnd(p_v_module => 'create_awd_chg_rec',
2826: p_v_string => ' when others exception handler ' ||SQLERRM
2827: );
2828: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');

Line 2829: fnd_message.set_token('NAME','igf_sl_cl_create_chg.create_awd_chg_rec');

2825: log_to_fnd(p_v_module => 'create_awd_chg_rec',
2826: p_v_string => ' when others exception handler ' ||SQLERRM
2827: );
2828: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
2829: fnd_message.set_token('NAME','igf_sl_cl_create_chg.create_awd_chg_rec');
2830: igs_ge_msg_stack.add;
2831: app_exception.raise_exception;
2832:
2833: END create_awd_chg_rec;

Line 2924: SAVEPOINT igf_sl_cl_create_chg_disb_sp;

2920: l_d_message_tokens igf_sl_cl_chg_prc.token_tab%TYPE;
2921: PRAGMA EXCEPTION_INIT(e_resource_busy,-00054);
2922:
2923: BEGIN
2924: SAVEPOINT igf_sl_cl_create_chg_disb_sp;
2925: log_to_fnd(p_v_module => 'create_disb_chg_rec',
2926: p_v_string => ' Entered Procedure create_disb_chg_rec: The input parameters are ' ||
2927: ' new reference of Award Id : ' ||p_new_disb_rec.award_id ||
2928: ' new reference of disb num : ' ||p_new_disb_rec.disb_num ||

Line 6243: ROLLBACK TO igf_sl_cl_create_chg_disb_sp;

6239: END IF;
6240:
6241: EXCEPTION
6242: WHEN e_resource_busy THEN
6243: ROLLBACK TO igf_sl_cl_create_chg_disb_sp;
6244: log_to_fnd(p_v_module => ' Procedure create_disb_chg_rec: e resource busy exception',
6245: p_v_string => SQLERRM
6246: );
6247: p_b_return_status := FALSE;

Line 6251: ROLLBACK TO igf_sl_cl_create_chg_disb_sp;

6247: p_b_return_status := FALSE;
6248: p_v_message_name := 'IGS_GE_RECORD_LOCKED';
6249: RETURN;
6250: WHEN e_valid_edits THEN
6251: ROLLBACK TO igf_sl_cl_create_chg_disb_sp;
6252: log_to_fnd(p_v_module => 'Procedure create_disb_chg_rec: validation edits exception handler',
6253: p_v_string => ' change record validation raised errors '||l_v_message_name
6254: );
6255: p_b_return_status := FALSE;

Line 6260: ROLLBACK TO igf_sl_cl_create_chg_disb_sp;

6256: p_v_message_name := l_v_message_name;
6257: igf_sl_cl_chg_prc.g_message_tokens := l_d_message_tokens;
6258: RETURN;
6259: WHEN OTHERS THEN
6260: ROLLBACK TO igf_sl_cl_create_chg_disb_sp;
6261: log_to_fnd(p_v_module => 'Procedure create_disb_chg_rec: when others exception handler',
6262: p_v_string => SQLERRM
6263: );
6264: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');

Line 6265: fnd_message.set_token('NAME','igf_sl_cl_create_chg.create_disb_chg_rec');

6261: log_to_fnd(p_v_module => 'Procedure create_disb_chg_rec: when others exception handler',
6262: p_v_string => SQLERRM
6263: );
6264: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
6265: fnd_message.set_token('NAME','igf_sl_cl_create_chg.create_disb_chg_rec');
6266: igs_ge_msg_stack.add;
6267: app_exception.raise_exception;
6268:
6269: END create_disb_chg_rec;

Line 6292: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_sl_cl_create_chg.'||p_v_module, p_v_string);

6288: --Who When What
6289: ------------------------------------------------------------------
6290: BEGIN
6291: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6292: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_sl_cl_create_chg.'||p_v_module, p_v_string);
6293: END IF;
6294: END log_to_fnd;
6295:
6296: FUNCTION get_sl_clchsn_dtls ( p_rowid ROWID)

Line 6327: END igf_sl_cl_create_chg;

6323: CLOSE c_sl_clchsn_dtls ;
6324: RETURN rec_sl_clchsn_dtls;
6325: END get_sl_clchsn_dtls;
6326:
6327: END igf_sl_cl_create_chg;