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_CHG_PRC

Line 92: l_d_message_tokens igf_sl_cl_chg_prc.token_tab%TYPE;

88: l_v_sqlstmt VARCHAR2(32767);
89: l_v_rowid ROWID;
90: l_v_message_name fnd_new_messages.message_name%TYPE;
91: l_b_return_status BOOLEAN;
92: l_d_message_tokens igf_sl_cl_chg_prc.token_tab%TYPE;
93:
94: e_valid_edits EXCEPTION;
95: e_resource_busy EXCEPTION;
96: PRAGMA EXCEPTION_INIT(e_resource_busy,-00054);

Line 247: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

243: -- all the required fields are populated or not for a change record
244: log_to_fnd(p_v_module => ' create_loan_chg_rec ',
245: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
246: );
247: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
248: p_b_return_status => l_b_return_status,
249: p_v_message_name => l_v_message_name,
250: p_t_message_tokens => l_d_message_tokens
251: );

Line 320: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,

316: -- all the required fields are populated or not for a change record
317: log_to_fnd(p_v_module => 'create_loan_chg_rec ',
318: p_v_string => ' validating the Change record for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
319: );
320: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,
321: p_b_return_status => l_b_return_status,
322: p_v_message_name => l_v_message_name,
323: p_t_message_tokens => l_d_message_tokens
324: );

Line 330: igf_sl_cl_chg_prc.parse_tokens(

326: IF NOT(l_b_return_status) THEN
327: -- substring of the out bound parameter l_v_message_name is carried
328: -- out since it can expect either IGS OR IGF message
329: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
330: igf_sl_cl_chg_prc.parse_tokens(
331: p_t_message_tokens => l_d_message_tokens);
332: /*
333: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
334: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);

Line 519: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

515: -- all the required fields are populated or not for a change record
516: log_to_fnd(p_v_module => 'create_loan_chg_rec ',
517: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
518: );
519: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
520: p_b_return_status => l_b_return_status,
521: p_v_message_name => l_v_message_name,
522: p_t_message_tokens => l_d_message_tokens
523: );

Line 592: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,

588: -- all the required fields are populated or not for a change record
589: log_to_fnd(p_v_module => 'create_loan_chg_rec ',
590: p_v_string => ' validating the Change record for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
591: );
592: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,
593: p_b_return_status => l_b_return_status,
594: p_v_message_name => l_v_message_name,
595: p_t_message_tokens => l_d_message_tokens
596: );

Line 605: igf_sl_cl_chg_prc.parse_tokens(

601: );
602: -- substring of the out bound parameter l_v_message_name is carried
603: -- out since it can expect either IGS OR IGF message
604: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
605: igf_sl_cl_chg_prc.parse_tokens(
606: p_t_message_tokens => l_d_message_tokens);
607: /*
608: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
609: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);

Line 720: igf_sl_cl_chg_prc.g_message_tokens := l_d_message_tokens;

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;
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',

Line 800: l_d_message_tokens igf_sl_cl_chg_prc.token_tab%TYPE;

796: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
797:
798: e_valid_edits EXCEPTION;
799: e_resource_busy EXCEPTION;
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;

Line 953: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

949: -- all the required fields are populated or not for a change record
950: log_to_fnd(p_v_module => 'create_lor_chg_rec ',
951: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
952: );
953: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
954: p_b_return_status => l_b_return_status,
955: p_v_message_name => l_v_message_name,
956: p_t_message_tokens => l_d_message_tokens
957: );

Line 1017: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,

1013: -- all the required fields are populated or not for a change record
1014: log_to_fnd(p_v_module => 'create_lor_chg_rec ',
1015: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
1016: );
1017: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,
1018: p_b_return_status => l_b_return_status,
1019: p_v_message_name => l_v_message_name,
1020: p_t_message_tokens => l_d_message_tokens
1021: );

Line 1030: igf_sl_cl_chg_prc.parse_tokens(

1026: );
1027: -- substring of the out bound parameter l_v_message_name is carried
1028: -- out since it can expect either IGS OR IGF message
1029: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
1030: igf_sl_cl_chg_prc.parse_tokens(
1031: p_t_message_tokens => l_d_message_tokens);
1032: /*
1033: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
1034: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);

Line 1215: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

1211: -- all the required fields are populated or not for a change record
1212: log_to_fnd(p_v_module => 'create_lor_chg_rec ',
1213: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
1214: );
1215: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
1216: p_b_return_status => l_b_return_status,
1217: p_v_message_name => l_v_message_name,
1218: p_t_message_tokens => l_d_message_tokens
1219: );

Line 1288: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,

1284: -- all the required fields are populated or not for a change record
1285: log_to_fnd(p_v_module => 'create_lor_chg_rec ',
1286: p_v_string => ' validating the Change record for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
1287: );
1288: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,
1289: p_b_return_status => l_b_return_status,
1290: p_v_message_name => l_v_message_name,
1291: p_t_message_tokens => l_d_message_tokens
1292: );

Line 1301: igf_sl_cl_chg_prc.parse_tokens(

1297: );
1298: -- substring of the out bound parameter l_v_message_name is carried
1299: -- out since it can expect either IGS OR IGF message
1300: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
1301: igf_sl_cl_chg_prc.parse_tokens(
1302: p_t_message_tokens => l_d_message_tokens);
1303: /*
1304: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
1305: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);

Line 1420: igf_sl_cl_chg_prc.g_message_tokens := l_d_message_tokens;

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;
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',

Line 1514: l_d_message_tokens igf_sl_cl_chg_prc.token_tab%TYPE;

1510: l_v_status_code igf_sl_clchsn_dtls.status_code%TYPE;
1511:
1512: e_valid_edits EXCEPTION;
1513: e_resource_busy EXCEPTION;
1514: l_d_message_tokens igf_sl_cl_chg_prc.token_tab%TYPE;
1515: PRAGMA EXCEPTION_INIT(e_resource_busy,-00054);
1516:
1517: BEGIN
1518:

Line 1683: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

1679: -- all the required fields are populated or not for a change record
1680: log_to_fnd(p_v_module => ' create_awd_chg_rec ',
1681: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
1682: );
1683: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
1684: p_b_return_status => l_b_return_status,
1685: p_v_message_name => l_v_message_name,
1686: p_t_message_tokens => l_d_message_tokens
1687: );

Line 1928: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

1924: -- all the required fields are populated or not for a change record
1925: log_to_fnd(p_v_module => ' create_awd_chg_rec ',
1926: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
1927: );
1928: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
1929: p_b_return_status => l_b_return_status,
1930: p_v_message_name => l_v_message_name,
1931: p_t_message_tokens => l_d_message_tokens
1932: );

Line 1998: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,

1994: -- all the required fields are populated or not for a change record
1995: log_to_fnd(p_v_module => ' create_awd_chg_rec ',
1996: p_v_string => ' validating the Change record for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
1997: );
1998: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,
1999: p_b_return_status => l_b_return_status,
2000: p_v_message_name => l_v_message_name,
2001: p_t_message_tokens => l_d_message_tokens
2002: );

Line 2010: igf_sl_cl_chg_prc.parse_tokens(

2006: );
2007: -- substring of the out bound parameter l_v_message_name is carried
2008: -- out since it can expect either IGS OR IGF message
2009: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
2010: igf_sl_cl_chg_prc.parse_tokens(
2011: p_t_message_tokens => l_d_message_tokens);
2012: /*
2013: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
2014: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);

Line 2144: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

2140: -- all the required fields are populated or not for a change record
2141: log_to_fnd(p_v_module => ' create_awd_chg_rec ',
2142: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
2143: );
2144: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
2145: p_b_return_status => l_b_return_status,
2146: p_v_message_name => l_v_message_name,
2147: p_t_message_tokens => l_d_message_tokens
2148: );

Line 2214: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,

2210: -- all the required fields are populated or not for a change record
2211: log_to_fnd(p_v_module => ' create_awd_chg_rec ',
2212: p_v_string => ' validating the Change record for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
2213: );
2214: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,
2215: p_b_return_status => l_b_return_status,
2216: p_v_message_name => l_v_message_name,
2217: p_t_message_tokens => l_d_message_tokens
2218: );

Line 2226: igf_sl_cl_chg_prc.parse_tokens(

2222: );
2223: -- substring of the out bound parameter l_v_message_name is carried
2224: -- out since it can expect either IGS OR IGF message
2225: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
2226: igf_sl_cl_chg_prc.parse_tokens(
2227: p_t_message_tokens => l_d_message_tokens);
2228: /*
2229: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
2230: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);

Line 2355: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

2351: -- all the required fields are populated or not for a change record
2352: log_to_fnd(p_v_module => ' create_awd_chg_rec ',
2353: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
2354: );
2355: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
2356: p_b_return_status => l_b_return_status,
2357: p_v_message_name => l_v_message_name,
2358: p_t_message_tokens => l_d_message_tokens
2359: );

Line 2427: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,

2423: -- all the required fields are populated or not for a change record
2424: log_to_fnd(p_v_module => ' create_awd_chg_rec ',
2425: p_v_string => ' validating the Change record for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
2426: );
2427: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,
2428: p_b_return_status => l_b_return_status,
2429: p_v_message_name => l_v_message_name,
2430: p_t_message_tokens => l_d_message_tokens
2431: );

Line 2440: igf_sl_cl_chg_prc.parse_tokens(

2436: );
2437: -- substring of the out bound parameter l_v_message_name is carried
2438: -- out since it can expect either IGS OR IGF message
2439: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
2440: igf_sl_cl_chg_prc.parse_tokens(
2441: p_t_message_tokens => l_d_message_tokens);
2442: /*
2443: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
2444: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);

Line 2616: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

2612: -- all the required fields are populated or not for a change record
2613: log_to_fnd(p_v_module => ' create_awd_chg_rec ',
2614: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
2615: );
2616: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
2617: p_b_return_status => l_b_return_status,
2618: p_v_message_name => l_v_message_name,
2619: p_t_message_tokens => l_d_message_tokens
2620: );

Line 2688: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,

2684: -- all the required fields are populated or not for a change record
2685: log_to_fnd(p_v_module => ' create_awd_chg_rec ',
2686: p_v_string => ' validating the Change record for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
2687: );
2688: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,
2689: p_b_return_status => l_b_return_status,
2690: p_v_message_name => l_v_message_name,
2691: p_t_message_tokens => l_d_message_tokens
2692: );

Line 2700: igf_sl_cl_chg_prc.parse_tokens(

2696: );
2697: -- substring of the out bound parameter l_v_message_name is carried
2698: -- out since it can expect either IGS OR IGF message
2699: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
2700: igf_sl_cl_chg_prc.parse_tokens(
2701: p_t_message_tokens => l_d_message_tokens);
2702: /*
2703: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
2704: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);

Line 2821: igf_sl_cl_chg_prc.g_message_tokens := l_d_message_tokens;

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;
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',

Line 2920: l_d_message_tokens igf_sl_cl_chg_prc.token_tab%TYPE;

2916: l_v_fund_return_mthd_code igf_aw_awd_disb_all.fund_return_mthd_code%TYPE;
2917:
2918: e_valid_edits EXCEPTION;
2919: e_resource_busy EXCEPTION;
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;

Line 3092: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

3088: -- all the required fields are populated or not for a change record
3089: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
3090: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
3091: );
3092: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
3093: p_b_return_status => l_b_return_status,
3094: p_v_message_name => l_v_message_name,
3095: p_t_message_tokens => l_d_message_tokens
3096: );

Line 3167: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,

3163: p_v_string => ' validating the Change record for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
3164: );
3165: l_v_message_name := NULL;
3166: l_b_return_status := TRUE;
3167: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,
3168: p_b_return_status => l_b_return_status,
3169: p_v_message_name => l_v_message_name,
3170: p_t_message_tokens => l_d_message_tokens
3171: );

Line 3177: igf_sl_cl_chg_prc.parse_tokens(

3173: IF NOT(l_b_return_status) THEN
3174: -- substring of the out bound parameter l_v_message_name is carried
3175: -- out since it can expect either IGS OR IGF message
3176: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
3177: igf_sl_cl_chg_prc.parse_tokens(
3178: p_t_message_tokens => l_d_message_tokens);
3179: /*
3180: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
3181: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);

Line 3377: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

3373: -- all the required fields are populated or not for a change record
3374: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
3375: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
3376: );
3377: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
3378: p_b_return_status => l_b_return_status,
3379: p_v_message_name => l_v_message_name,
3380: p_t_message_tokens => l_d_message_tokens
3381: );

Line 3452: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,

3448: p_v_string => ' validating the Change record for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
3449: );
3450: l_v_message_name := NULL;
3451: l_b_return_status := TRUE;
3452: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,
3453: p_b_return_status => l_b_return_status,
3454: p_v_message_name => l_v_message_name,
3455: p_t_message_tokens => l_d_message_tokens
3456: );

Line 3462: igf_sl_cl_chg_prc.parse_tokens(

3458: IF NOT(l_b_return_status) THEN
3459: -- substring of the out bound parameter l_v_message_name is carried
3460: -- out since it can expect either IGS OR IGF message
3461: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
3462: igf_sl_cl_chg_prc.parse_tokens(
3463: p_t_message_tokens => l_d_message_tokens);
3464: /*
3465: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
3466: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);

Line 3714: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

3710: -- all the required fields are populated or not for a change record
3711: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
3712: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
3713: );
3714: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
3715: p_b_return_status => l_b_return_status,
3716: p_v_message_name => l_v_message_name,
3717: p_t_message_tokens => l_d_message_tokens
3718: );

Line 3795: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,

3791: p_v_string => ' validating the Change record for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
3792: );
3793: l_v_message_name := NULL;
3794: l_b_return_status := TRUE;
3795: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,
3796: p_b_return_status => l_b_return_status,
3797: p_v_message_name => l_v_message_name,
3798: p_t_message_tokens => l_d_message_tokens
3799: );

Line 3808: igf_sl_cl_chg_prc.parse_tokens(

3804: );
3805: -- substring of the out bound parameter l_v_message_name is carried
3806: -- out since it can expect either IGS OR IGF message
3807: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
3808: igf_sl_cl_chg_prc.parse_tokens(
3809: p_t_message_tokens => l_d_message_tokens);
3810: /*
3811: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
3812: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);

Line 4013: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

4009: -- all the required fields are populated or not for a change record
4010: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
4011: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
4012: );
4013: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
4014: p_b_return_status => l_b_return_status,
4015: p_v_message_name => l_v_message_name,
4016: p_t_message_tokens => l_d_message_tokens
4017: );

Line 4088: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,

4084: p_v_string => ' validating the Change record for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
4085: );
4086: l_v_message_name := NULL;
4087: l_b_return_status := TRUE;
4088: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,
4089: p_b_return_status => l_b_return_status,
4090: p_v_message_name => l_v_message_name,
4091: p_t_message_tokens => l_d_message_tokens
4092: );

Line 4101: igf_sl_cl_chg_prc.parse_tokens(

4097: );
4098: -- substring of the out bound parameter l_v_message_name is carried
4099: -- out since it can expect either IGS OR IGF message
4100: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
4101: igf_sl_cl_chg_prc.parse_tokens(
4102: p_t_message_tokens => l_d_message_tokens);
4103: /*
4104: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
4105: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);

Line 4304: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

4300: -- all the required fields are populated or not for a change record
4301: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
4302: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
4303: );
4304: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
4305: p_b_return_status => l_b_return_status,
4306: p_v_message_name => l_v_message_name,
4307: p_t_message_tokens => l_d_message_tokens
4308: );

Line 4379: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,

4375: p_v_string => ' validating the Change record for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
4376: );
4377: l_v_message_name := NULL;
4378: l_b_return_status := TRUE;
4379: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,
4380: p_b_return_status => l_b_return_status,
4381: p_v_message_name => l_v_message_name,
4382: p_t_message_tokens => l_d_message_tokens
4383: );

Line 4389: igf_sl_cl_chg_prc.parse_tokens(

4385: IF NOT(l_b_return_status) THEN
4386: -- substring of the out bound parameter l_v_message_name is carried
4387: -- out since it can expect either IGS OR IGF message
4388: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
4389: igf_sl_cl_chg_prc.parse_tokens(
4390: p_t_message_tokens => l_d_message_tokens);
4391: /*
4392: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
4393: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);

Line 4597: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

4593: -- all the required fields are populated or not for a change record
4594: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
4595: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
4596: );
4597: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
4598: p_b_return_status => l_b_return_status,
4599: p_v_message_name => l_v_message_name,
4600: p_t_message_tokens => l_d_message_tokens
4601: );

Line 4672: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,

4668: p_v_string => ' validating the Change record for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
4669: );
4670: l_v_message_name := NULL;
4671: l_b_return_status := TRUE;
4672: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,
4673: p_b_return_status => l_b_return_status,
4674: p_v_message_name => l_v_message_name,
4675: p_t_message_tokens => l_d_message_tokens
4676: );

Line 4685: igf_sl_cl_chg_prc.parse_tokens(

4681: );
4682: -- substring of the out bound parameter l_v_message_name is carried
4683: -- out since it can expect either IGS OR IGF message
4684: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
4685: igf_sl_cl_chg_prc.parse_tokens(
4686: p_t_message_tokens => l_d_message_tokens);
4687: /*
4688: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
4689: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);

Line 4889: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

4885: -- all the required fields are populated or not for a change record
4886: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
4887: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
4888: );
4889: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
4890: p_b_return_status => l_b_return_status,
4891: p_v_message_name => l_v_message_name,
4892: p_t_message_tokens => l_d_message_tokens
4893: );

Line 4964: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,

4960: p_v_string => ' validating the Change record for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
4961: );
4962: l_v_message_name := NULL;
4963: l_b_return_status := TRUE;
4964: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,
4965: p_b_return_status => l_b_return_status,
4966: p_v_message_name => l_v_message_name,
4967: p_t_message_tokens => l_d_message_tokens
4968: );

Line 4974: igf_sl_cl_chg_prc.parse_tokens(

4970: IF NOT(l_b_return_status) THEN
4971: -- substring of the out bound parameter l_v_message_name is carried
4972: -- out since it can expect either IGS OR IGF message
4973: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
4974: igf_sl_cl_chg_prc.parse_tokens(
4975: p_t_message_tokens => l_d_message_tokens);
4976: /*
4977: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
4978: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);

Line 5177: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

5173: -- all the required fields are populated or not for a change record
5174: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
5175: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
5176: );
5177: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
5178: p_b_return_status => l_b_return_status,
5179: p_v_message_name => l_v_message_name,
5180: p_t_message_tokens => l_d_message_tokens
5181: );

Line 5252: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,

5248: p_v_string => ' validating the Change record for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
5249: );
5250: l_v_message_name := NULL;
5251: l_b_return_status := TRUE;
5252: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,
5253: p_b_return_status => l_b_return_status,
5254: p_v_message_name => l_v_message_name,
5255: p_t_message_tokens => l_d_message_tokens
5256: );

Line 5262: igf_sl_cl_chg_prc.parse_tokens(

5258: IF NOT(l_b_return_status) THEN
5259: -- substring of the out bound parameter l_v_message_name is carried
5260: -- out since it can expect either IGS OR IGF message
5261: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
5262: igf_sl_cl_chg_prc.parse_tokens(
5263: p_t_message_tokens => l_d_message_tokens);
5264: /*
5265: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
5266: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);

Line 5463: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

5459: -- all the required fields are populated or not for a change record
5460: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
5461: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
5462: );
5463: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
5464: p_b_return_status => l_b_return_status,
5465: p_v_message_name => l_v_message_name,
5466: p_t_message_tokens => l_d_message_tokens
5467: );

Line 5538: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,

5534: p_v_string => ' validating the Change record for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
5535: );
5536: l_v_message_name := NULL;
5537: l_b_return_status := TRUE;
5538: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,
5539: p_b_return_status => l_b_return_status,
5540: p_v_message_name => l_v_message_name,
5541: p_t_message_tokens => l_d_message_tokens
5542: );

Line 5548: igf_sl_cl_chg_prc.parse_tokens(

5544: IF NOT(l_b_return_status) THEN
5545: -- substring of the out bound parameter l_v_message_name is carried
5546: -- out since it can expect either IGS OR IGF message
5547: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
5548: igf_sl_cl_chg_prc.parse_tokens(
5549: p_t_message_tokens => l_d_message_tokens);
5550: /*
5551: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
5552: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);

Line 5750: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

5746: -- all the required fields are populated or not for a change record
5747: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
5748: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
5749: );
5750: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
5751: p_b_return_status => l_b_return_status,
5752: p_v_message_name => l_v_message_name,
5753: p_t_message_tokens => l_d_message_tokens
5754: );

Line 5825: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,

5821: p_v_string => ' validating the Change record for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
5822: );
5823: l_v_message_name := NULL;
5824: l_b_return_status := TRUE;
5825: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,
5826: p_b_return_status => l_b_return_status,
5827: p_v_message_name => l_v_message_name,
5828: p_t_message_tokens => l_d_message_tokens
5829: );

Line 5835: igf_sl_cl_chg_prc.parse_tokens(

5831: IF NOT(l_b_return_status) THEN
5832: -- substring of the out bound parameter l_v_message_name is carried
5833: -- out since it can expect either IGS OR IGF message
5834: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
5835: igf_sl_cl_chg_prc.parse_tokens(
5836: p_t_message_tokens => l_d_message_tokens);
5837: /*
5838: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
5839: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);

Line 6037: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,

6033: -- all the required fields are populated or not for a change record
6034: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
6035: p_v_string => ' validating the Change record for Change send id: ' ||l_n_clchgsnd_id
6036: );
6037: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => l_n_clchgsnd_id,
6038: p_b_return_status => l_b_return_status,
6039: p_v_message_name => l_v_message_name,
6040: p_t_message_tokens => l_d_message_tokens
6041: );

Line 6112: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,

6108: p_v_string => ' validating the Change record for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
6109: );
6110: l_v_message_name := NULL;
6111: l_b_return_status := TRUE;
6112: igf_sl_cl_chg_prc.validate_chg (p_n_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id,
6113: p_b_return_status => l_b_return_status,
6114: p_v_message_name => l_v_message_name,
6115: p_t_message_tokens => l_d_message_tokens
6116: );

Line 6122: igf_sl_cl_chg_prc.parse_tokens(

6118: IF NOT(l_b_return_status) THEN
6119: -- substring of the out bound parameter l_v_message_name is carried
6120: -- out since it can expect either IGS OR IGF message
6121: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
6122: igf_sl_cl_chg_prc.parse_tokens(
6123: p_t_message_tokens => l_d_message_tokens);
6124: /*
6125: FOR token_counter IN l_d_message_tokens.FIRST..l_d_message_tokens.LAST LOOP
6126: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);

Line 6257: igf_sl_cl_chg_prc.g_message_tokens := l_d_message_tokens;

6253: p_v_string => ' change record validation raised errors '||l_v_message_name
6254: );
6255: p_b_return_status := FALSE;
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',