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_CLCHSN_DTLS_PKG

Line 200: igf_sl_clchsn_dtls_pkg.insert_row

196: ' Change record type: ' ||'07 - Loan Period/Grade Level/Anticipated Completion Date Change' ||
197: ' Change code : ' ||'A - Loan Period Change '
198: );
199:
200: igf_sl_clchsn_dtls_pkg.insert_row
201: (
202: x_rowid => l_v_rowid,
203: x_clchgsnd_id => l_n_clchgsnd_id,
204: x_award_id => l_n_award_id,

Line 273: igf_sl_clchsn_dtls_pkg.update_row

269: ' Change_field_code : ' ||'LOAN_PER_BEGIN_DT' ||
270: ' Change record type: ' ||'07 - Loan Period/Grade Level/Anticipated Completion Date Change' ||
271: ' Change code : ' ||'A - Loan Period Change '
272: );
273: igf_sl_clchsn_dtls_pkg.update_row
274: (
275: x_rowid => l_v_rowid ,
276: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
277: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 341: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

337: log_to_fnd(p_v_module => 'create_loan_chg_rec ',
338: p_v_string => ' validation of the Change record failed for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
339: );
340: log_to_fnd(p_v_module => 'create_loan_chg_rec',
341: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
342: );
343: igf_sl_clchsn_dtls_pkg.update_row
344: (
345: x_rowid => l_v_rowid ,

Line 343: igf_sl_clchsn_dtls_pkg.update_row

339: );
340: log_to_fnd(p_v_module => 'create_loan_chg_rec',
341: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
342: );
343: igf_sl_clchsn_dtls_pkg.update_row
344: (
345: x_rowid => l_v_rowid ,
346: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
347: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 425: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

421: p_v_string => ' Change record to be deleted ' ||
422: ' Award Id : ' ||l_n_award_id ||
423: ' loan number : ' ||l_v_loan_number
424: );
425: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
426: log_to_fnd(p_v_module => 'create_loan_chg_rec ',
427: p_v_string => ' Change record deleted successfully' ||
428: ' Award Id : ' ||l_n_award_id ||
429: ' loan number : ' ||l_v_loan_number

Line 472: igf_sl_clchsn_dtls_pkg.insert_row

468: ' Change_field_code : ' ||'LOAN_PER_END_DT' ||
469: ' Change record type: ' ||'07 - Loan Period/Grade Level/Anticipated Completion Date Change' ||
470: ' Change code : ' ||'A - Loan Period Change '
471: );
472: igf_sl_clchsn_dtls_pkg.insert_row
473: (
474: x_rowid => l_v_rowid ,
475: x_clchgsnd_id => l_n_clchgsnd_id ,
476: x_award_id => p_new_loan_rec.award_id ,

Line 545: igf_sl_clchsn_dtls_pkg.update_row

541: ' Change_field_code : ' ||'LOAN_PER_END_DT' ||
542: ' Change record type : ' ||'07 - Loan Period/Grade Level/Anticipated Completion Date Change' ||
543: ' Change code : ' ||'A - Loan Period Change '
544: );
545: igf_sl_clchsn_dtls_pkg.update_row
546: (
547: x_rowid => l_v_rowid ,
548: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
549: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 613: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

609: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);
610: END LOOP;
611: */
612: log_to_fnd(p_v_module => 'create_loan_chg_rec',
613: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
614: );
615: igf_sl_clchsn_dtls_pkg.update_row
616: (
617: x_rowid => l_v_rowid ,

Line 615: igf_sl_clchsn_dtls_pkg.update_row

611: */
612: log_to_fnd(p_v_module => 'create_loan_chg_rec',
613: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
614: );
615: igf_sl_clchsn_dtls_pkg.update_row
616: (
617: x_rowid => l_v_rowid ,
618: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
619: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 691: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

687: p_v_string => ' Change record to be deleted ' ||
688: ' Award Id : ' ||l_n_award_id ||
689: ' loan number : ' ||l_v_loan_number
690: );
691: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
692: log_to_fnd(p_v_module => 'create_loan_chg_rec ',
693: p_v_string => ' Change record deleted successfully ' ||
694: ' Award Id : ' ||l_n_award_id ||
695: ' loan number : ' ||l_v_loan_number

Line 906: igf_sl_clchsn_dtls_pkg.insert_row

902: ' Change_field_code : ' ||'ANTICIP_COML_DT' ||
903: ' Change record type : ' ||'07 - Loan Period/Grade Level/Anticipated Completion Date Change' ||
904: ' Change code : ' ||'C - Anticipated Completion Date Change '
905: );
906: igf_sl_clchsn_dtls_pkg.insert_row
907: (
908: x_rowid => l_v_rowid ,
909: x_clchgsnd_id => l_n_clchgsnd_id ,
910: x_award_id => l_n_award_id ,

Line 970: igf_sl_clchsn_dtls_pkg.update_row

966: p_v_message_name := NULL;
967: ELSE
968: CLOSE c_igf_sl_clchsn_dtls;
969: rec_c_igf_sl_clchsn_dtls := get_sl_clchsn_dtls ( p_rowid => l_v_rowid);
970: igf_sl_clchsn_dtls_pkg.update_row
971: (
972: x_rowid => l_v_rowid ,
973: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
974: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 1038: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

1034: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);
1035: END LOOP;
1036: */
1037: log_to_fnd(p_v_module => 'create_lor_chg_rec',
1038: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
1039: );
1040: igf_sl_clchsn_dtls_pkg.update_row
1041: (
1042: x_rowid => l_v_rowid ,

Line 1040: igf_sl_clchsn_dtls_pkg.update_row

1036: */
1037: log_to_fnd(p_v_module => 'create_lor_chg_rec',
1038: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
1039: );
1040: igf_sl_clchsn_dtls_pkg.update_row
1041: (
1042: x_rowid => l_v_rowid ,
1043: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
1044: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 1120: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

1116: p_v_string => ' Change record to be deleted ' ||
1117: ' Award Id : ' || l_n_award_id ||
1118: ' loan number : ' || l_v_loan_number
1119: );
1120: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
1121: log_to_fnd(p_v_module => 'create_lor_chg_rec ',
1122: p_v_string => ' Change record deleted successfully ' ||
1123: ' Award Id : ' || l_n_award_id ||
1124: ' loan number : ' || l_v_loan_number

Line 1168: igf_sl_clchsn_dtls_pkg.insert_row

1164: ' Change_field_code : ' ||'GRADE_LEVEL_CODE' ||
1165: ' Change record type : ' ||'07 - Loan Period/Grade Level/Anticipated Completion Date Change' ||
1166: ' Change code : ' ||'B - Grade Level Change '
1167: );
1168: igf_sl_clchsn_dtls_pkg.insert_row
1169: (
1170: x_rowid => l_v_rowid ,
1171: x_clchgsnd_id => l_n_clchgsnd_id ,
1172: x_award_id => l_n_award_id ,

Line 1241: igf_sl_clchsn_dtls_pkg.update_row

1237: ' Change_field_code : ' ||'GRADE_LEVEL_CODE' ||
1238: ' Change record type : ' ||'07 - Loan Period/Grade Level/Anticipated Completion Date Change'||
1239: ' Change code : ' ||'B - Grade Level Change '
1240: );
1241: igf_sl_clchsn_dtls_pkg.update_row
1242: (
1243: x_rowid => l_v_rowid ,
1244: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
1245: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 1309: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

1305: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);
1306: END LOOP;
1307: */
1308: log_to_fnd(p_v_module => 'create_lor_chg_rec',
1309: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
1310: );
1311: igf_sl_clchsn_dtls_pkg.update_row
1312: (
1313: x_rowid => l_v_rowid ,

Line 1311: igf_sl_clchsn_dtls_pkg.update_row

1307: */
1308: log_to_fnd(p_v_module => 'create_lor_chg_rec',
1309: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
1310: );
1311: igf_sl_clchsn_dtls_pkg.update_row
1312: (
1313: x_rowid => l_v_rowid ,
1314: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
1315: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 1390: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

1386: p_v_string => ' Change record to be deleted' ||
1387: ' Award Id : ' ||l_n_award_id ||
1388: ' loan number : ' ||l_v_loan_number
1389: );
1390: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
1391: log_to_fnd(p_v_module => 'create_lor_chg_rec ',
1392: p_v_string => ' Change record deleted successfully' ||
1393: ' Award Id : ' ||l_n_award_id ||
1394: ' loan number : ' ||l_v_loan_number

Line 1636: igf_sl_clchsn_dtls_pkg.insert_row

1632: FETCH c_igf_sl_clchsn_dtls INTO l_v_rowid;
1633: IF c_igf_sl_clchsn_dtls%NOTFOUND THEN
1634: l_v_rowid := NULL;
1635: l_n_clchgsnd_id := NULL;
1636: igf_sl_clchsn_dtls_pkg.insert_row
1637: (
1638: x_rowid => l_v_rowid ,
1639: x_clchgsnd_id => l_n_clchgsnd_id ,
1640: x_award_id => l_n_award_id ,

Line 1724: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

1720: p_v_string => ' fullY reinstated Change record to be deleted ' ||
1721: ' Award Id : ' ||l_n_award_id ||
1722: ' loan number : ' ||l_v_loan_number
1723: );
1724: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
1725: log_to_fnd(p_v_module => ' create_awd_chg_rec ',
1726: p_v_string => ' Change record deleted successfully ' ||
1727: ' Award Id : ' ||l_n_award_id ||
1728: ' loan number : ' ||l_v_loan_number

Line 1753: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

1749: p_v_string => ' Loan Increase Change record to be deleted ' ||
1750: ' Award Id : ' ||l_n_award_id ||
1751: ' loan number : ' ||l_v_loan_number
1752: );
1753: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
1754: log_to_fnd(p_v_module => ' create_awd_chg_rec ',
1755: p_v_string => ' Change record deleted successfully ' ||
1756: ' Award Id : ' ||l_n_award_id ||
1757: ' loan number : ' ||l_v_loan_number

Line 1835: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

1831: p_v_string => ' Loan Increase Change record to be deleted ' ||
1832: ' Award Id : ' ||l_n_award_id ||
1833: ' loan number : ' ||l_v_loan_number
1834: );
1835: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
1836: log_to_fnd(p_v_module => ' create_awd_chg_rec ',
1837: p_v_string => ' Change record deleted successfully ' ||
1838: ' Award Id : ' ||l_n_award_id ||
1839: ' loan number : ' ||l_v_loan_number

Line 1881: igf_sl_clchsn_dtls_pkg.insert_row

1877: ' Change_field_code : ' ||'AWARD_AMOUNT' ||
1878: ' Change record type : ' ||'08 - Loan Cancellation' ||
1879: ' change code : ' ||'B - Full Loan Reinstatement'
1880: );
1881: igf_sl_clchsn_dtls_pkg.insert_row
1882: (
1883: x_rowid => l_v_rowid ,
1884: x_clchgsnd_id => l_n_clchgsnd_id ,
1885: x_award_id => l_n_award_id ,

Line 1951: igf_sl_clchsn_dtls_pkg.update_row

1947: ' Change_field_code : ' ||'AWARD_AMOUNT' ||
1948: ' Change record type : ' ||'08 - Loan Reinstatement'||
1949: ' Change code : ' ||'B - Loan Reinstatement '
1950: );
1951: igf_sl_clchsn_dtls_pkg.update_row
1952: (
1953: x_rowid => l_v_rowid ,
1954: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
1955: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 2018: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

2014: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);
2015: END LOOP;
2016: */
2017: log_to_fnd(p_v_module => ' create_awd_chg_rec',
2018: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
2019: );
2020: igf_sl_clchsn_dtls_pkg.update_row
2021: (
2022: x_rowid => l_v_rowid ,

Line 2020: igf_sl_clchsn_dtls_pkg.update_row

2016: */
2017: log_to_fnd(p_v_module => ' create_awd_chg_rec',
2018: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
2019: );
2020: igf_sl_clchsn_dtls_pkg.update_row
2021: (
2022: x_rowid => l_v_rowid ,
2023: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
2024: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 2097: igf_sl_clchsn_dtls_pkg.insert_row

2093: ' Change_field_code : ' ||'AWARD_AMOUNT' ||
2094: ' Change record type : ' ||'08 - Loan Cancellation' ||
2095: ' change code : ' ||'B - Full Loan Reinstatement'
2096: );
2097: igf_sl_clchsn_dtls_pkg.insert_row
2098: (
2099: x_rowid => l_v_rowid ,
2100: x_clchgsnd_id => l_n_clchgsnd_id ,
2101: x_award_id => l_n_award_id ,

Line 2167: igf_sl_clchsn_dtls_pkg.update_row

2163: ' Change_field_code : ' ||'AWARD_AMOUNT' ||
2164: ' Change record type : ' ||'08 - Loan Reinstatement'||
2165: ' Change code : ' ||'B - Loan Reinstatement '
2166: );
2167: igf_sl_clchsn_dtls_pkg.update_row
2168: (
2169: x_rowid => l_v_rowid ,
2170: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
2171: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 2234: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

2230: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);
2231: END LOOP;
2232: */
2233: log_to_fnd(p_v_module => ' create_awd_chg_rec',
2234: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
2235: );
2236: igf_sl_clchsn_dtls_pkg.update_row
2237: (
2238: x_rowid => l_v_rowid ,

Line 2236: igf_sl_clchsn_dtls_pkg.update_row

2232: */
2233: log_to_fnd(p_v_module => ' create_awd_chg_rec',
2234: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
2235: );
2236: igf_sl_clchsn_dtls_pkg.update_row
2237: (
2238: x_rowid => l_v_rowid ,
2239: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
2240: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 2308: igf_sl_clchsn_dtls_pkg.insert_row

2304: ' Change_field_code : ' ||'AWARD_AMOUNT' ||
2305: ' Change record type : ' ||'24 - Loan Increase' ||
2306: ' change code : ' ||'A - Loan Increase '
2307: );
2308: igf_sl_clchsn_dtls_pkg.insert_row
2309: (
2310: x_rowid => l_v_rowid ,
2311: x_clchgsnd_id => l_n_clchgsnd_id ,
2312: x_award_id => l_n_award_id ,

Line 2380: igf_sl_clchsn_dtls_pkg.update_row

2376: ' Change_field_code : ' ||'AWARD_AMOUNT' ||
2377: ' Change record type : ' ||'24 - Loan Increase'||
2378: ' Change code : ' ||'A - LOan Increase '
2379: );
2380: igf_sl_clchsn_dtls_pkg.update_row
2381: (
2382: x_rowid => l_v_rowid ,
2383: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
2384: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 2448: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

2444: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);
2445: END LOOP;
2446: */
2447: log_to_fnd(p_v_module => ' create_awd_chg_rec',
2448: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
2449: );
2450: igf_sl_clchsn_dtls_pkg.update_row
2451: (
2452: x_rowid => l_v_rowid ,

Line 2450: igf_sl_clchsn_dtls_pkg.update_row

2446: */
2447: log_to_fnd(p_v_module => ' create_awd_chg_rec',
2448: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
2449: );
2450: igf_sl_clchsn_dtls_pkg.update_row
2451: (
2452: x_rowid => l_v_rowid ,
2453: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
2454: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 2523: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

2519: p_v_string => ' full loan cancellation Change record to be deleted ' ||
2520: ' Award Id : ' ||l_n_award_id ||
2521: ' loan number : ' ||l_v_loan_number
2522: );
2523: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
2524: log_to_fnd(p_v_module => ' create_awd_chg_rec ',
2525: p_v_string => ' full loan cancellation Change record deleted successfully ' ||
2526: ' Award Id : ' ||l_n_award_id ||
2527: ' loan number : ' ||l_v_loan_number

Line 2569: igf_sl_clchsn_dtls_pkg.insert_row

2565: ' Change_field_code : ' ||'AWARD_AMOUNT' ||
2566: ' Change record type : ' ||'24 - Loan Increase' ||
2567: ' change code : ' ||'A - Loan Increase '
2568: );
2569: igf_sl_clchsn_dtls_pkg.insert_row
2570: (
2571: x_rowid => l_v_rowid ,
2572: x_clchgsnd_id => l_n_clchgsnd_id ,
2573: x_award_id => l_n_award_id ,

Line 2641: igf_sl_clchsn_dtls_pkg.update_row

2637: ' Change_field_code : ' ||'AWARD_AMOUNT' ||
2638: ' Change record type : ' ||'24 - Loan Increase'||
2639: ' Change code : ' ||'A - LOan Increase '
2640: );
2641: igf_sl_clchsn_dtls_pkg.update_row
2642: (
2643: x_rowid => l_v_rowid ,
2644: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
2645: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 2708: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

2704: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);
2705: END LOOP;
2706: */
2707: log_to_fnd(p_v_module => ' create_awd_chg_rec',
2708: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
2709: );
2710: igf_sl_clchsn_dtls_pkg.update_row
2711: (
2712: x_rowid => l_v_rowid ,

Line 2710: igf_sl_clchsn_dtls_pkg.update_row

2706: */
2707: log_to_fnd(p_v_module => ' create_awd_chg_rec',
2708: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
2709: );
2710: igf_sl_clchsn_dtls_pkg.update_row
2711: (
2712: x_rowid => l_v_rowid ,
2713: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
2714: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 2791: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

2787: p_v_string => ' @24 Change record to be deleted ' ||
2788: ' Award Id : ' ||l_n_award_id ||
2789: ' loan number : ' ||l_v_loan_number
2790: );
2791: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
2792: log_to_fnd(p_v_module => 'create_awd_chg_rec',
2793: p_v_string => ' @24 Change record deleted successfully' ||
2794: ' Award Id : ' ||l_n_award_id ||
2795: ' loan number : ' ||l_v_loan_number

Line 3045: igf_sl_clchsn_dtls_pkg.insert_row

3041: ' Change_field_code : ' ||'DISB_DATE' ||
3042: ' Change record type : ' ||'09 - Disbursement Cancellation/Change' ||
3043: ' Change code : ' ||'B - Disbursement Date Change '
3044: );
3045: igf_sl_clchsn_dtls_pkg.insert_row
3046: (
3047: x_rowid => l_v_rowid ,
3048: x_clchgsnd_id => l_n_clchgsnd_id ,
3049: x_award_id => l_n_award_id ,

Line 3118: igf_sl_clchsn_dtls_pkg.update_row

3114: ' Change record type: ' ||'09 - Disbursement Cancellation/Change' ||
3115: ' Change code : ' ||'B - Disbursement Date Change ' ||
3116: ' new disb date : ' || l_d_new_disb_date
3117: );
3118: igf_sl_clchsn_dtls_pkg.update_row
3119: (
3120: x_rowid => l_v_rowid ,
3121: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
3122: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 3188: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

3184: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
3185: p_v_string => ' validation of the Change record failed for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
3186: );
3187: log_to_fnd(p_v_module => ' create_disb_chg_rec',
3188: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
3189: );
3190: igf_sl_clchsn_dtls_pkg.update_row
3191: (
3192: x_rowid => l_v_rowid ,

Line 3190: igf_sl_clchsn_dtls_pkg.update_row

3186: );
3187: log_to_fnd(p_v_module => ' create_disb_chg_rec',
3188: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
3189: );
3190: igf_sl_clchsn_dtls_pkg.update_row
3191: (
3192: x_rowid => l_v_rowid ,
3193: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
3194: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 3278: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

3274: ' Award Id : '||l_n_award_id ||
3275: ' Disb Num : '||l_n_disb_num ||
3276: ' New disb Date: '||l_d_new_disb_date
3277: );
3278: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
3279: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
3280: p_v_string => ' Change record deleted Successfully' ||
3281: ' Award Id : '||l_n_award_id ||
3282: ' Disb Num : '||l_n_disb_num ||

Line 3330: igf_sl_clchsn_dtls_pkg.insert_row

3326: ' Change_field_code : ' ||'DISB_HOLD_REL_IND' ||
3327: ' Change record type: ' ||'09 - Disbursement Cancellation/Change' ||
3328: ' Change code : ' ||'E - Disbursement Hold Release Change '
3329: );
3330: igf_sl_clchsn_dtls_pkg.insert_row
3331: (
3332: x_rowid => l_v_rowid ,
3333: x_clchgsnd_id => l_n_clchgsnd_id ,
3334: x_award_id => l_n_award_id ,

Line 3403: igf_sl_clchsn_dtls_pkg.update_row

3399: ' Change record type : ' ||'09 - Disbursement Cancellation/Change' ||
3400: ' Change code : ' ||'E - Disbursement Hold Release Change ' ||
3401: ' new hold release ind: ' || l_c_new_hold_rel_ind
3402: );
3403: igf_sl_clchsn_dtls_pkg.update_row
3404: (
3405: x_rowid => l_v_rowid,
3406: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
3407: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 3473: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

3469: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
3470: p_v_string => ' validation of the Change record failed for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
3471: );
3472: log_to_fnd(p_v_module => ' create_disb_chg_rec',
3473: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
3474: );
3475: igf_sl_clchsn_dtls_pkg.update_row
3476: (
3477: x_rowid => l_v_rowid ,

Line 3475: igf_sl_clchsn_dtls_pkg.update_row

3471: );
3472: log_to_fnd(p_v_module => ' create_disb_chg_rec',
3473: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
3474: );
3475: igf_sl_clchsn_dtls_pkg.update_row
3476: (
3477: x_rowid => l_v_rowid ,
3478: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
3479: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 3560: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

3556: ' Award Id : '||l_n_award_id ||
3557: ' Disb Num : '||l_n_disb_num ||
3558: ' new hold release ind: '||l_c_new_hold_rel_ind
3559: );
3560: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
3561: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
3562: p_v_string => ' Change record to be deleted successfully'||
3563: ' Award Id : '||l_n_award_id ||
3564: ' Disb Num : '||l_n_disb_num ||

Line 3632: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

3628: ' loan number : ' ||l_v_loan_number||
3629: ' Disb Number : ' ||l_n_disb_num ||
3630: ' change_code_txt : ' ||'AI'
3631: );
3632: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
3633: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
3634: p_v_string => ' Change record deleted successfully ' ||
3635: ' Award Id : ' ||l_n_award_id ||
3636: ' loan number : ' ||l_v_loan_number||

Line 3667: igf_sl_clchsn_dtls_pkg.insert_row

3663: ' Change_field_code : ' ||'DISB_AMOUNT' ||
3664: ' Change record type: ' ||'09 - Disbursement Cancellation/Change' ||
3665: ' Change code : ' ||l_v_change_code_txt
3666: );
3667: igf_sl_clchsn_dtls_pkg.insert_row
3668: (
3669: x_rowid => l_v_rowid ,
3670: x_clchgsnd_id => l_n_clchgsnd_id ,
3671: x_award_id => l_n_award_id ,

Line 3746: igf_sl_clchsn_dtls_pkg.update_row

3742: IF rec_c_igf_sl_clchsn_dtls.change_code_txt = 'ADI' THEN
3743: l_d_disb_cancel_dt := TRUNC(SYSDATE);
3744: l_n_disb_cancel_amt := NVL((rec_c_igf_sl_clchsn_dtls.old_amt - l_n_new_disb_accepted_amt),0);
3745: END IF;
3746: igf_sl_clchsn_dtls_pkg.update_row
3747: (
3748: x_rowid => l_v_rowid ,
3749: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
3750: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 3819: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

3815: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
3816: p_v_string => ' validation of the Change record failed for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
3817: );
3818: log_to_fnd(p_v_module => ' create_disb_chg_rec',
3819: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
3820: );
3821: igf_sl_clchsn_dtls_pkg.update_row
3822: (
3823: x_rowid => l_v_rowid ,

Line 3821: igf_sl_clchsn_dtls_pkg.update_row

3817: );
3818: log_to_fnd(p_v_module => ' create_disb_chg_rec',
3819: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
3820: );
3821: igf_sl_clchsn_dtls_pkg.update_row
3822: (
3823: x_rowid => l_v_rowid ,
3824: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
3825: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 3912: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

3908: ' Loan number : ' ||rec_c_igf_sl_clchsn_dtls.loan_number_txt ||
3909: ' Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id ||
3910: ' Change Code : ' ||rec_c_igf_sl_clchsn_dtls.change_code_txt
3911: );
3912: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
3913: log_to_fnd(p_v_module => ' create_disb_chg_rec',
3914: p_v_string => ' Change record deleted successfully ' ||
3915: ' Award Id : ' ||l_n_award_id ||
3916: ' Disb Num : ' ||l_n_disb_num ||

Line 3966: igf_sl_clchsn_dtls_pkg.insert_row

3962: ' Change_field_code : ' ||'DISB_AMOUNT' ||
3963: ' Change record type: ' ||'09 - Disbursement Cancellation/Change' ||
3964: ' Change code : ' ||'C - Disbursement Reinstatement '
3965: );
3966: igf_sl_clchsn_dtls_pkg.insert_row
3967: (
3968: x_rowid => l_v_rowid ,
3969: x_clchgsnd_id => l_n_clchgsnd_id ,
3970: x_award_id => l_n_award_id ,

Line 4039: igf_sl_clchsn_dtls_pkg.update_row

4035: ' Change record type : ' ||'09 - Disbursement Cancellation/Change' ||
4036: ' Change code : ' ||'C - Disbursement Reinstatement ' ||
4037: ' new disb Amount : ' ||l_n_new_disb_accepted_amt
4038: );
4039: igf_sl_clchsn_dtls_pkg.update_row
4040: (
4041: x_rowid => l_v_rowid ,
4042: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
4043: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 4112: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

4108: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
4109: p_v_string => ' validation of the Change record failed for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
4110: );
4111: log_to_fnd(p_v_module => ' create_disb_chg_rec',
4112: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
4113: );
4114: igf_sl_clchsn_dtls_pkg.update_row
4115: (
4116: x_rowid => l_v_rowid ,

Line 4114: igf_sl_clchsn_dtls_pkg.update_row

4110: );
4111: log_to_fnd(p_v_module => ' create_disb_chg_rec',
4112: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
4113: );
4114: igf_sl_clchsn_dtls_pkg.update_row
4115: (
4116: x_rowid => l_v_rowid ,
4117: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
4118: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 4202: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

4198: ' Award Id : '||l_n_award_id ||
4199: ' Disb Num : '||l_n_disb_num ||
4200: ' New disb Amount: '||l_n_new_disb_accepted_amt
4201: );
4202: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
4203: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
4204: p_v_string => ' Change record to be deleted successfully' ||
4205: ' Award Id : '||l_n_award_id ||
4206: ' Disb Num : '||l_n_disb_num ||

Line 4257: igf_sl_clchsn_dtls_pkg.insert_row

4253: ' Change_field_code : ' ||'DISB_DATE' ||
4254: ' Change record type : ' ||'09 - Disbursement Cancellation/Change' ||
4255: ' Change code : ' ||'C - Disbursement Reinstatement '
4256: );
4257: igf_sl_clchsn_dtls_pkg.insert_row
4258: (
4259: x_rowid => l_v_rowid ,
4260: x_clchgsnd_id => l_n_clchgsnd_id ,
4261: x_award_id => l_n_award_id ,

Line 4330: igf_sl_clchsn_dtls_pkg.update_row

4326: ' Change record type: ' ||'09 - Disbursement Cancellation/Change' ||
4327: ' Change code : ' ||'B - Disbursement Date Change ' ||
4328: ' new disb date : ' || l_d_new_disb_date
4329: );
4330: igf_sl_clchsn_dtls_pkg.update_row
4331: (
4332: x_rowid => l_v_rowid ,
4333: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
4334: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 4400: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

4396: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
4397: p_v_string => ' validation of the Change record failed for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
4398: );
4399: log_to_fnd(p_v_module => ' create_disb_chg_rec',
4400: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
4401: );
4402: igf_sl_clchsn_dtls_pkg.update_row
4403: (
4404: x_rowid => l_v_rowid ,

Line 4402: igf_sl_clchsn_dtls_pkg.update_row

4398: );
4399: log_to_fnd(p_v_module => ' create_disb_chg_rec',
4400: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
4401: );
4402: igf_sl_clchsn_dtls_pkg.update_row
4403: (
4404: x_rowid => l_v_rowid ,
4405: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
4406: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 4490: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

4486: ' Award Id : '||l_n_award_id ||
4487: ' Disb Num : '||l_n_disb_num ||
4488: ' New disb Date: '||l_d_new_disb_date
4489: );
4490: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
4491: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
4492: p_v_string => ' Change record deleted Successfully' ||
4493: ' Award Id : '||l_n_award_id ||
4494: ' Disb Num : '||l_n_disb_num ||

Line 4550: igf_sl_clchsn_dtls_pkg.insert_row

4546: ' Change_field_code : ' ||'DISB_AMOUNT' ||
4547: ' Change record type: ' ||'10 - Disbursement Notification / Change' ||
4548: ' Change code : ' ||'C-Full or Partial Reinstatement'
4549: );
4550: igf_sl_clchsn_dtls_pkg.insert_row
4551: (
4552: x_rowid => l_v_rowid ,
4553: x_clchgsnd_id => l_n_clchgsnd_id ,
4554: x_award_id => l_n_award_id ,

Line 4623: igf_sl_clchsn_dtls_pkg.update_row

4619: ' Change record type: ' ||'10 - Disbursement Notification / Change' ||
4620: ' Change code : ' ||'C-Full or Partial Reinstatement' ||
4621: ' new disb Amount : ' ||l_n_new_disb_accepted_amt
4622: );
4623: igf_sl_clchsn_dtls_pkg.update_row
4624: (
4625: x_rowid => l_v_rowid ,
4626: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
4627: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 4696: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

4692: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
4693: p_v_string => ' validation of the Change record failed for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
4694: );
4695: log_to_fnd(p_v_module => ' create_disb_chg_rec',
4696: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
4697: );
4698: igf_sl_clchsn_dtls_pkg.update_row
4699: (
4700: x_rowid => l_v_rowid ,

Line 4698: igf_sl_clchsn_dtls_pkg.update_row

4694: );
4695: log_to_fnd(p_v_module => ' create_disb_chg_rec',
4696: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
4697: );
4698: igf_sl_clchsn_dtls_pkg.update_row
4699: (
4700: x_rowid => l_v_rowid ,
4701: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
4702: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 4785: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

4781: ' Award Id : ' ||l_n_award_id ||
4782: ' Disb Num : ' ||l_n_disb_num ||
4783: ' new disb Amount: ' ||l_n_new_disb_accepted_amt
4784: );
4785: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
4786: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
4787: p_v_string => ' Change record to be deleted succesfully' ||
4788: ' Award Id : ' ||l_n_award_id ||
4789: ' Disb Num : ' ||l_n_disb_num ||

Line 4842: igf_sl_clchsn_dtls_pkg.insert_row

4838: ' Change code : ' ||'B-Full or Partial Reissue' ||
4839: ' new disb Amount : ' ||l_n_new_disb_accepted_amt
4840: );
4841:
4842: igf_sl_clchsn_dtls_pkg.insert_row
4843: (
4844: x_rowid => l_v_rowid ,
4845: x_clchgsnd_id => l_n_clchgsnd_id ,
4846: x_award_id => l_n_award_id ,

Line 4915: igf_sl_clchsn_dtls_pkg.update_row

4911: ' Change record type: ' ||'10 - Disbursement Notification / Change' ||
4912: ' Change code : ' ||'B-Full or Partial Reissue' ||
4913: ' new disb Amount : ' ||l_n_new_disb_accepted_amt
4914: );
4915: igf_sl_clchsn_dtls_pkg.update_row
4916: (
4917: x_rowid => l_v_rowid ,
4918: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
4919: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 4985: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

4981: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
4982: p_v_string => ' validation of the Change record failed for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
4983: );
4984: log_to_fnd(p_v_module => ' create_disb_chg_rec',
4985: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
4986: );
4987: igf_sl_clchsn_dtls_pkg.update_row
4988: (
4989: x_rowid => l_v_rowid ,

Line 4987: igf_sl_clchsn_dtls_pkg.update_row

4983: );
4984: log_to_fnd(p_v_module => ' create_disb_chg_rec',
4985: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
4986: );
4987: igf_sl_clchsn_dtls_pkg.update_row
4988: (
4989: x_rowid => l_v_rowid ,
4990: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
4991: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 5075: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

5071: ' Award Id : ' ||l_n_award_id ||
5072: ' Disb Num : ' ||l_n_disb_num ||
5073: ' new disb Amount: ' ||l_n_new_disb_accepted_amt
5074: );
5075: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
5076: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
5077: p_v_string => ' Change record to be deleted succesfully' ||
5078: ' Award Id : ' ||l_n_award_id ||
5079: ' Disb Num : ' ||l_n_disb_num ||

Line 5130: igf_sl_clchsn_dtls_pkg.insert_row

5126: ' Change code : ' ||'A-Full or Partial Cancellation' ||
5127: ' new disb Amount : ' ||l_n_new_disb_accepted_amt
5128: );
5129:
5130: igf_sl_clchsn_dtls_pkg.insert_row
5131: (
5132: x_rowid => l_v_rowid ,
5133: x_clchgsnd_id => l_n_clchgsnd_id ,
5134: x_award_id => l_n_award_id ,

Line 5203: igf_sl_clchsn_dtls_pkg.update_row

5199: ' Change record type: ' ||'10 - Disbursement Notification / Change' ||
5200: ' Change code : ' ||'A-Full or Partial Cancellation' ||
5201: ' new disb Amount : ' ||l_n_new_disb_accepted_amt
5202: );
5203: igf_sl_clchsn_dtls_pkg.update_row
5204: (
5205: x_rowid => l_v_rowid ,
5206: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
5207: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 5273: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

5269: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
5270: p_v_string => ' validation of the Change record failed for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
5271: );
5272: log_to_fnd(p_v_module => ' create_disb_chg_rec',
5273: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
5274: );
5275: igf_sl_clchsn_dtls_pkg.update_row
5276: (
5277: x_rowid => l_v_rowid ,

Line 5275: igf_sl_clchsn_dtls_pkg.update_row

5271: );
5272: log_to_fnd(p_v_module => ' create_disb_chg_rec',
5273: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
5274: );
5275: igf_sl_clchsn_dtls_pkg.update_row
5276: (
5277: x_rowid => l_v_rowid ,
5278: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
5279: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 5363: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

5359: ' Award Id : ' ||l_n_award_id ||
5360: ' Disb Num : ' ||l_n_disb_num ||
5361: ' new disb Amount: ' ||l_n_new_disb_accepted_amt
5362: );
5363: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
5364: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
5365: p_v_string => ' Change record to be deleted succesfully' ||
5366: ' Award Id : ' ||l_n_award_id ||
5367: ' Disb Num : ' ||l_n_disb_num ||

Line 5416: igf_sl_clchsn_dtls_pkg.insert_row

5412: ' Change_field_code : ' ||'DISB_DATE' ||
5413: ' Change record type : ' ||'10 - Disbursement Notification / Change' ||
5414: ' Change code : ' ||'C - Full or Partial Reinstatement '
5415: );
5416: igf_sl_clchsn_dtls_pkg.insert_row
5417: (
5418: x_rowid => l_v_rowid ,
5419: x_clchgsnd_id => l_n_clchgsnd_id ,
5420: x_award_id => l_n_award_id ,

Line 5489: igf_sl_clchsn_dtls_pkg.update_row

5485: ' Change record type : ' ||'10 - Disbursement Notification / Change' ||
5486: ' Change code : ' ||'C - Full or Partial Reinstatement ' ||
5487: ' new disb date : ' || l_d_new_disb_date
5488: );
5489: igf_sl_clchsn_dtls_pkg.update_row
5490: (
5491: x_rowid => l_v_rowid ,
5492: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
5493: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 5559: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

5555: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
5556: p_v_string => ' validation of the Change record failed for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
5557: );
5558: log_to_fnd(p_v_module => ' create_disb_chg_rec',
5559: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
5560: );
5561: igf_sl_clchsn_dtls_pkg.update_row
5562: (
5563: x_rowid => l_v_rowid ,

Line 5561: igf_sl_clchsn_dtls_pkg.update_row

5557: );
5558: log_to_fnd(p_v_module => ' create_disb_chg_rec',
5559: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
5560: );
5561: igf_sl_clchsn_dtls_pkg.update_row
5562: (
5563: x_rowid => l_v_rowid ,
5564: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
5565: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 5649: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

5645: ' Award Id : '||l_n_award_id ||
5646: ' Disb Num : '||l_n_disb_num ||
5647: ' New disb Date: '||l_d_new_disb_date
5648: );
5649: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
5650: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
5651: p_v_string => ' Change record deleted Successfully' ||
5652: ' Award Id : '||l_n_award_id ||
5653: ' Disb Num : '||l_n_disb_num ||

Line 5703: igf_sl_clchsn_dtls_pkg.insert_row

5699: ' Change_field_code : ' ||'DISB_DATE' ||
5700: ' Change record type : ' ||'10 - Disbursement Notification / Change' ||
5701: ' Change code : ' ||'B - Full or Partial Reissue '
5702: );
5703: igf_sl_clchsn_dtls_pkg.insert_row
5704: (
5705: x_rowid => l_v_rowid ,
5706: x_clchgsnd_id => l_n_clchgsnd_id ,
5707: x_award_id => l_n_award_id ,

Line 5776: igf_sl_clchsn_dtls_pkg.update_row

5772: ' Change record type : ' ||'10 - Disbursement Notification / Change' ||
5773: ' Change code : ' ||'B - Full or Partial Reissue ' ||
5774: ' new disb date : ' || l_d_new_disb_date
5775: );
5776: igf_sl_clchsn_dtls_pkg.update_row
5777: (
5778: x_rowid => l_v_rowid ,
5779: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
5780: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 5846: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

5842: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
5843: p_v_string => ' validation of the Change record failed for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
5844: );
5845: log_to_fnd(p_v_module => ' create_disb_chg_rec',
5846: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
5847: );
5848: igf_sl_clchsn_dtls_pkg.update_row
5849: (
5850: x_rowid => l_v_rowid ,

Line 5848: igf_sl_clchsn_dtls_pkg.update_row

5844: );
5845: log_to_fnd(p_v_module => ' create_disb_chg_rec',
5846: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
5847: );
5848: igf_sl_clchsn_dtls_pkg.update_row
5849: (
5850: x_rowid => l_v_rowid ,
5851: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
5852: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 5936: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

5932: ' Award Id : '||l_n_award_id ||
5933: ' Disb Num : '||l_n_disb_num ||
5934: ' New disb Date: '||l_d_new_disb_date
5935: );
5936: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
5937: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
5938: p_v_string => ' Change record deleted Successfully' ||
5939: ' Award Id : '||l_n_award_id ||
5940: ' Disb Num : '||l_n_disb_num ||

Line 5990: igf_sl_clchsn_dtls_pkg.insert_row

5986: ' Change_field_code : ' ||'DISB_DATE' ||
5987: ' Change record type : ' ||'10 - Disbursement Notification / Change' ||
5988: ' Change code : ' ||'A - Full or Partial Cancellation '
5989: );
5990: igf_sl_clchsn_dtls_pkg.insert_row
5991: (
5992: x_rowid => l_v_rowid ,
5993: x_clchgsnd_id => l_n_clchgsnd_id ,
5994: x_award_id => l_n_award_id ,

Line 6063: igf_sl_clchsn_dtls_pkg.update_row

6059: ' Change record type : ' ||'10 - Disbursement Notification / Change' ||
6060: ' Change code : ' ||'A - Full or Partial Cancellation ' ||
6061: ' new disb date : ' || l_d_new_disb_date
6062: );
6063: igf_sl_clchsn_dtls_pkg.update_row
6064: (
6065: x_rowid => l_v_rowid ,
6066: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
6067: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 6133: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

6129: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
6130: p_v_string => ' validation of the Change record failed for Change send id: ' ||rec_c_igf_sl_clchsn_dtls.clchgsnd_id
6131: );
6132: log_to_fnd(p_v_module => ' create_disb_chg_rec',
6133: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
6134: );
6135: igf_sl_clchsn_dtls_pkg.update_row
6136: (
6137: x_rowid => l_v_rowid ,

Line 6135: igf_sl_clchsn_dtls_pkg.update_row

6131: );
6132: log_to_fnd(p_v_module => ' create_disb_chg_rec',
6133: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
6134: );
6135: igf_sl_clchsn_dtls_pkg.update_row
6136: (
6137: x_rowid => l_v_rowid ,
6138: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
6139: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 6223: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);

6219: ' Award Id : '||l_n_award_id ||
6220: ' Disb Num : '||l_n_disb_num ||
6221: ' New disb Date: '||l_d_new_disb_date
6222: );
6223: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => l_v_rowid);
6224: log_to_fnd(p_v_module => ' create_disb_chg_rec ',
6225: p_v_string => ' Change record deleted Successfully' ||
6226: ' Award Id : '||l_n_award_id ||
6227: ' Disb Num : '||l_n_disb_num ||