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.AP_TRIAL_BALANCE_PKG dependencies on FND_FILE

Line 65: fnd_file.put_line (fnd_file.log, 'Stage :001 - Into Process_Trial_Balance');

61: future_dated_pmts_used BOOLEAN;
62:
63: BEGIN
64:
65: fnd_file.put_line (fnd_file.log, 'Stage :001 - Into Process_Trial_Balance');
66: fnd_file.put_line (fnd_file.log, 'Stage :002 - Delete Existing ap_trial_bal'
67: ||' records.');
68:
69: DELETE FROM ap_trial_bal;

Line 66: fnd_file.put_line (fnd_file.log, 'Stage :002 - Delete Existing ap_trial_bal'

62:
63: BEGIN
64:
65: fnd_file.put_line (fnd_file.log, 'Stage :001 - Into Process_Trial_Balance');
66: fnd_file.put_line (fnd_file.log, 'Stage :002 - Delete Existing ap_trial_bal'
67: ||' records.');
68:
69: DELETE FROM ap_trial_bal;
70:

Line 71: fnd_file.put_line (fnd_file.log, 'Stage :003 - Insert AP_Trial_Bal Info.');

67: ||' records.');
68:
69: DELETE FROM ap_trial_bal;
70:
71: fnd_file.put_line (fnd_file.log, 'Stage :003 - Insert AP_Trial_Bal Info.');
72:
73: IF (p_from_date IS NULL) THEN
74:
75: fnd_file.put_line (fnd_file.log, 'Stage :004 - Into From Date Null Case');

Line 75: fnd_file.put_line (fnd_file.log, 'Stage :004 - Into From Date Null Case');

71: fnd_file.put_line (fnd_file.log, 'Stage :003 - Insert AP_Trial_Bal Info.');
72:
73: IF (p_from_date IS NULL) THEN
74:
75: fnd_file.put_line (fnd_file.log, 'Stage :004 - Into From Date Null Case');
76:
77: IF (Insert_AP_Trial_Bal (p_accounting_date,
78: p_request_id,
79: p_reporting_entity_id,

Line 87: fnd_file.put_line (fnd_file.log, 'Stage :005 - Verify Future Dated '

83: RETURN FALSE;
84:
85: END IF;
86:
87: fnd_file.put_line (fnd_file.log, 'Stage :005 - Verify Future Dated '
88: ||'Payments Used.');
89:
90: future_dated_pmts_used := Use_Future_Dated(p_org_where_asp,
91: p_debug_switch);

Line 93: fnd_file.put_line (fnd_file.log, 'Stage :006 - Insert Future Dated if '

89:
90: future_dated_pmts_used := Use_Future_Dated(p_org_where_asp,
91: p_debug_switch);
92:
93: fnd_file.put_line (fnd_file.log, 'Stage :006 - Insert Future Dated if '
94: ||' applicable.');
95:
96: IF (future_dated_pmts_used) THEN
97:

Line 98: fnd_file.put_line (fnd_file.log, 'Stage :007 - Into Insert Future Dated '

94: ||' applicable.');
95:
96: IF (future_dated_pmts_used) THEN
97:
98: fnd_file.put_line (fnd_file.log, 'Stage :007 - Into Insert Future Dated '
99: ||'Payments Block');
100:
101: IF (Insert_Future_Dated (p_accounting_date,
102: p_request_id,

Line 113: fnd_file.put_line (fnd_file.log, 'Stage :008 - Negative Balances');

109: END IF;
110:
111: END IF;
112:
113: fnd_file.put_line (fnd_file.log, 'Stage :008 - Negative Balances');
114:
115: IF (NVL(p_neg_bal_only,'N') = 'Y') THEN
116:
117: fnd_file.put_line (fnd_file.log, 'Stage :009 - Into Negative Balances'

Line 117: fnd_file.put_line (fnd_file.log, 'Stage :009 - Into Negative Balances'

113: fnd_file.put_line (fnd_file.log, 'Stage :008 - Negative Balances');
114:
115: IF (NVL(p_neg_bal_only,'N') = 'Y') THEN
116:
117: fnd_file.put_line (fnd_file.log, 'Stage :009 - Into Negative Balances'
118: ||' Block');
119:
120: IF (Process_Neg_Bal (p_request_id) <> TRUE) THEN
121:

Line 130: fnd_file.put_line (fnd_file.log, 'Stage :010 - Into From Date Case');

126: END IF;
127:
128: ELSE
129:
130: fnd_file.put_line (fnd_file.log, 'Stage :010 - Into From Date Case');
131:
132: IF (Insert_AP_Trial_Bal (p_accounting_date,
133: p_from_date,
134: p_request_id,

Line 143: fnd_file.put_line (fnd_file.log, 'Stage :011 - Verify Future Dated '

139: RETURN FALSE;
140:
141: END IF;
142:
143: fnd_file.put_line (fnd_file.log, 'Stage :011 - Verify Future Dated '
144: ||'Payments Used.');
145:
146: future_dated_pmts_used := Use_Future_Dated(p_org_where_asp,
147: p_debug_switch);

Line 149: fnd_file.put_line (fnd_file.log, 'Stage :012 - Insert Future Dated if '

145:
146: future_dated_pmts_used := Use_Future_Dated(p_org_where_asp,
147: p_debug_switch);
148:
149: fnd_file.put_line (fnd_file.log, 'Stage :012 - Insert Future Dated if '
150: ||' applicable.');
151:
152: IF (future_dated_pmts_used) THEN
153:

Line 154: fnd_file.put_line (fnd_file.log, 'Stage :013 - Into Insert Future Dated '

150: ||' applicable.');
151:
152: IF (future_dated_pmts_used) THEN
153:
154: fnd_file.put_line (fnd_file.log, 'Stage :013 - Into Insert Future Dated '
155: ||'Payments Block');
156:
157: IF (Insert_Future_Dated (p_accounting_date,
158: p_from_date,

Line 169: fnd_file.put_line (fnd_file.log, 'Stage :014 - Negative Balances');

165: END IF;
166:
167: END IF;
168:
169: fnd_file.put_line (fnd_file.log, 'Stage :014 - Negative Balances');
170:
171: IF (NVL(p_neg_bal_only,'N') = 'Y') THEN
172:
173: fnd_file.put_line (fnd_file.log, 'Stage :015 - Into Negative Balances'

Line 173: fnd_file.put_line (fnd_file.log, 'Stage :015 - Into Negative Balances'

169: fnd_file.put_line (fnd_file.log, 'Stage :014 - Negative Balances');
170:
171: IF (NVL(p_neg_bal_only,'N') = 'Y') THEN
172:
173: fnd_file.put_line (fnd_file.log, 'Stage :015 - Into Negative Balances'
174: ||' Block');
175:
176: IF (Process_Neg_Bal (p_request_id) <> TRUE) THEN
177:

Line 192: fnd_file.put_line(fnd_file.log,'Error Occured in Process_Trial_Balance'

188: EXCEPTION
189:
190: WHEN OTHERS THEN
191:
192: fnd_file.put_line(fnd_file.log,'Error Occured in Process_Trial_Balance'
193: ||' Function.');
194: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
195: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
196:

Line 194: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));

190: WHEN OTHERS THEN
191:
192: fnd_file.put_line(fnd_file.log,'Error Occured in Process_Trial_Balance'
193: ||' Function.');
194: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
195: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
196:
197: RETURN FALSE;
198:

Line 195: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);

191:
192: fnd_file.put_line(fnd_file.log,'Error Occured in Process_Trial_Balance'
193: ||' Function.');
194: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
195: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
196:
197: RETURN FALSE;
198:
199:

Line 240: fnd_file.put_line (fnd_file.log, 'Stage :016 - Into Insert_AP_Trial_Bal');

236: l_sql_stmt VARCHAR2(32000);
237:
238: BEGIN
239:
240: fnd_file.put_line (fnd_file.log, 'Stage :016 - Into Insert_AP_Trial_Bal');
241:
242: l_sql_stmt:= 'INSERT INTO ap_trial_bal '
243: || ' SELECT alb.invoice_id invoice_id, '
244: || ' alb.code_combination_id code_combination_id, '

Line 266: fnd_file.put_line(fnd_file.log,l_sql_stmt);

262: || ' '||p_request_id||' '
263: || ' HAVING SUM (accounted_cr) <> SUM (accounted_dr) ';
264:
265: IF (p_debug_switch IN ('y','Y')) THEN
266: fnd_file.put_line(fnd_file.log,l_sql_stmt);
267: END IF;
268:
269: EXECUTE IMMEDIATE l_sql_stmt;
270:

Line 277: fnd_file.put_line(fnd_file.log,'Error Occured in Insert_AP_Trial_Bal'

273: EXCEPTION
274:
275: WHEN OTHERS THEN
276:
277: fnd_file.put_line(fnd_file.log,'Error Occured in Insert_AP_Trial_Bal'
278: ||' Function.');
279: IF (p_debug_switch IN ('y','Y')) THEN
280: fnd_file.put_line(fnd_file.log,l_sql_stmt);
281: END IF;

Line 280: fnd_file.put_line(fnd_file.log,l_sql_stmt);

276:
277: fnd_file.put_line(fnd_file.log,'Error Occured in Insert_AP_Trial_Bal'
278: ||' Function.');
279: IF (p_debug_switch IN ('y','Y')) THEN
280: fnd_file.put_line(fnd_file.log,l_sql_stmt);
281: END IF;
282: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
283: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
284:

Line 282: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));

278: ||' Function.');
279: IF (p_debug_switch IN ('y','Y')) THEN
280: fnd_file.put_line(fnd_file.log,l_sql_stmt);
281: END IF;
282: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
283: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
284:
285: RETURN FALSE;
286:

Line 283: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);

279: IF (p_debug_switch IN ('y','Y')) THEN
280: fnd_file.put_line(fnd_file.log,l_sql_stmt);
281: END IF;
282: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
283: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
284:
285: RETURN FALSE;
286:
287: END Insert_AP_Trial_Bal;

Line 308: fnd_file.put_line (fnd_file.log, 'Stage :017 - Into Insert_AP_Trial_Bal');

304: l_sql_stmt VARCHAR2(32000);
305:
306: BEGIN
307:
308: fnd_file.put_line (fnd_file.log, 'Stage :017 - Into Insert_AP_Trial_Bal');
309:
310: l_sql_stmt := 'INSERT INTO ap_trial_bal '
311: || ' SELECT alb.invoice_id invoice_id, '
312: || ' alb.code_combination_id code_combination_id, '

Line 337: fnd_file.put_line(fnd_file.log,l_sql_stmt);

333: || ' '||p_request_id||' '
334: || ' HAVING SUM (accounted_cr) <> SUM (accounted_dr) ';
335:
336: IF (p_debug_switch IN ('y','Y')) THEN
337: fnd_file.put_line(fnd_file.log,l_sql_stmt);
338: END IF;
339:
340: EXECUTE IMMEDIATE l_sql_stmt;
341:

Line 349: fnd_file.put_line(fnd_file.log,'Error Occured in Insert_AP_Trial_Bal'

345: EXCEPTION
346:
347: WHEN OTHERS THEN
348:
349: fnd_file.put_line(fnd_file.log,'Error Occured in Insert_AP_Trial_Bal'
350: ||' Function.');
351: IF (p_debug_switch IN ('y','Y')) THEN
352: fnd_file.put_line(fnd_file.log,l_sql_stmt);
353: END IF;

Line 352: fnd_file.put_line(fnd_file.log,l_sql_stmt);

348:
349: fnd_file.put_line(fnd_file.log,'Error Occured in Insert_AP_Trial_Bal'
350: ||' Function.');
351: IF (p_debug_switch IN ('y','Y')) THEN
352: fnd_file.put_line(fnd_file.log,l_sql_stmt);
353: END IF;
354: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
355: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
356: RETURN FALSE;

Line 354: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));

350: ||' Function.');
351: IF (p_debug_switch IN ('y','Y')) THEN
352: fnd_file.put_line(fnd_file.log,l_sql_stmt);
353: END IF;
354: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
355: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
356: RETURN FALSE;
357:
358: END Insert_AP_Trial_Bal;

Line 355: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);

351: IF (p_debug_switch IN ('y','Y')) THEN
352: fnd_file.put_line(fnd_file.log,l_sql_stmt);
353: END IF;
354: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
355: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
356: RETURN FALSE;
357:
358: END Insert_AP_Trial_Bal;
359:

Line 395: fnd_file.put_line (fnd_file.log, 'Stage :018 - Into Insert_Future_Dated');

391: l_sql_stmt_1 VARCHAR2(32000);
392:
393: BEGIN
394:
395: fnd_file.put_line (fnd_file.log, 'Stage :018 - Into Insert_Future_Dated');
396: fnd_file.put_line (fnd_file.log, 'Stage :019 - Gain Loss At Payment '
397: ||'Line Level');
398:
399: l_sql_stmt_1 := 'INSERT INTO ap_trial_bal '

Line 396: fnd_file.put_line (fnd_file.log, 'Stage :019 - Gain Loss At Payment '

392:
393: BEGIN
394:
395: fnd_file.put_line (fnd_file.log, 'Stage :018 - Into Insert_Future_Dated');
396: fnd_file.put_line (fnd_file.log, 'Stage :019 - Gain Loss At Payment '
397: ||'Line Level');
398:
399: l_sql_stmt_1 := 'INSERT INTO ap_trial_bal '
400: || '(( '

Line 498: fnd_file.put_line(fnd_file.log,l_sql_stmt_1);

494: || ' ) '
495: || ') ';
496:
497: IF (p_debug_switch IN ('y','Y')) THEN
498: fnd_file.put_line(fnd_file.log,l_sql_stmt_1);
499: END IF;
500:
501: EXECUTE IMMEDIATE l_sql_stmt_1;
502:

Line 509: fnd_file.put_line(fnd_file.log,'Error Occured in Insert_Future_Dated'

505: EXCEPTION
506:
507: WHEN OTHERS THEN
508:
509: fnd_file.put_line(fnd_file.log,'Error Occured in Insert_Future_Dated'
510: ||' Function.');
511: IF (p_debug_switch IN ('y','Y')) THEN
512: fnd_file.put_line(fnd_file.log,l_sql_stmt);
513: fnd_file.put_line(fnd_file.log,l_sql_stmt_1);

Line 512: fnd_file.put_line(fnd_file.log,l_sql_stmt);

508:
509: fnd_file.put_line(fnd_file.log,'Error Occured in Insert_Future_Dated'
510: ||' Function.');
511: IF (p_debug_switch IN ('y','Y')) THEN
512: fnd_file.put_line(fnd_file.log,l_sql_stmt);
513: fnd_file.put_line(fnd_file.log,l_sql_stmt_1);
514: END IF;
515: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
516: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);

Line 513: fnd_file.put_line(fnd_file.log,l_sql_stmt_1);

509: fnd_file.put_line(fnd_file.log,'Error Occured in Insert_Future_Dated'
510: ||' Function.');
511: IF (p_debug_switch IN ('y','Y')) THEN
512: fnd_file.put_line(fnd_file.log,l_sql_stmt);
513: fnd_file.put_line(fnd_file.log,l_sql_stmt_1);
514: END IF;
515: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
516: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
517: RETURN FALSE;

Line 515: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));

511: IF (p_debug_switch IN ('y','Y')) THEN
512: fnd_file.put_line(fnd_file.log,l_sql_stmt);
513: fnd_file.put_line(fnd_file.log,l_sql_stmt_1);
514: END IF;
515: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
516: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
517: RETURN FALSE;
518:
519: END Insert_Future_Dated;

Line 516: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);

512: fnd_file.put_line(fnd_file.log,l_sql_stmt);
513: fnd_file.put_line(fnd_file.log,l_sql_stmt_1);
514: END IF;
515: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
516: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
517: RETURN FALSE;
518:
519: END Insert_Future_Dated;
520:

Line 543: fnd_file.put_line (fnd_file.log, 'Stage :020 - Into Insert_Future_Dated');

539: l_sql_stmt_1 VARCHAR2(32000);
540:
541: BEGIN
542:
543: fnd_file.put_line (fnd_file.log, 'Stage :020 - Into Insert_Future_Dated');
544: fnd_file.put_line (fnd_file.log, 'Stage :021 - Gain Loss At Payment '
545: ||'Line Level');
546: l_sql_stmt_1 := 'INSERT INTO ap_trial_bal '
547: || '(( '

Line 544: fnd_file.put_line (fnd_file.log, 'Stage :021 - Gain Loss At Payment '

540:
541: BEGIN
542:
543: fnd_file.put_line (fnd_file.log, 'Stage :020 - Into Insert_Future_Dated');
544: fnd_file.put_line (fnd_file.log, 'Stage :021 - Gain Loss At Payment '
545: ||'Line Level');
546: l_sql_stmt_1 := 'INSERT INTO ap_trial_bal '
547: || '(( '
548: || ' SELECT /*+ full(aeh) '

Line 647: fnd_file.put_line(fnd_file.log,l_sql_stmt_1);

643: || ' ) '
644: || ') ';
645:
646: IF (p_debug_switch IN ('y','Y')) THEN
647: fnd_file.put_line(fnd_file.log,l_sql_stmt_1);
648: END IF;
649:
650: EXECUTE IMMEDIATE l_sql_stmt_1;
651:

Line 658: fnd_file.put_line(fnd_file.log,'Error Occured in Insert_Future_Dated'

654: EXCEPTION
655:
656: WHEN OTHERS THEN
657:
658: fnd_file.put_line(fnd_file.log,'Error Occured in Insert_Future_Dated'
659: ||' Function.');
660: IF (p_debug_switch IN ('y','Y')) THEN
661: fnd_file.put_line(fnd_file.log,l_sql_stmt);
662: fnd_file.put_line(fnd_file.log,l_sql_stmt_1);

Line 661: fnd_file.put_line(fnd_file.log,l_sql_stmt);

657:
658: fnd_file.put_line(fnd_file.log,'Error Occured in Insert_Future_Dated'
659: ||' Function.');
660: IF (p_debug_switch IN ('y','Y')) THEN
661: fnd_file.put_line(fnd_file.log,l_sql_stmt);
662: fnd_file.put_line(fnd_file.log,l_sql_stmt_1);
663: END IF;
664: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
665: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);

Line 662: fnd_file.put_line(fnd_file.log,l_sql_stmt_1);

658: fnd_file.put_line(fnd_file.log,'Error Occured in Insert_Future_Dated'
659: ||' Function.');
660: IF (p_debug_switch IN ('y','Y')) THEN
661: fnd_file.put_line(fnd_file.log,l_sql_stmt);
662: fnd_file.put_line(fnd_file.log,l_sql_stmt_1);
663: END IF;
664: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
665: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
666: RETURN FALSE;

Line 664: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));

660: IF (p_debug_switch IN ('y','Y')) THEN
661: fnd_file.put_line(fnd_file.log,l_sql_stmt);
662: fnd_file.put_line(fnd_file.log,l_sql_stmt_1);
663: END IF;
664: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
665: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
666: RETURN FALSE;
667:
668: END Insert_Future_Dated;

Line 665: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);

661: fnd_file.put_line(fnd_file.log,l_sql_stmt);
662: fnd_file.put_line(fnd_file.log,l_sql_stmt_1);
663: END IF;
664: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
665: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
666: RETURN FALSE;
667:
668: END Insert_Future_Dated;
669:

Line 684: fnd_file.put_line (fnd_file.log, 'Stage :024 - Into Process_Neg_Bal');

680: RETURN BOOLEAN IS
681:
682: BEGIN
683:
684: fnd_file.put_line (fnd_file.log, 'Stage :024 - Into Process_Neg_Bal');
685:
686: DELETE FROM ap_trial_bal
687: WHERE (code_combination_id,
688: vendor_id,

Line 713: fnd_file.put_line(fnd_file.log,'Error Occured in Process_Neg_Bal'

709: EXCEPTION
710:
711: WHEN OTHERS THEN
712:
713: fnd_file.put_line(fnd_file.log,'Error Occured in Process_Neg_Bal'
714: ||' Function.');
715: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
716: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
717: RETURN FALSE;

Line 715: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));

711: WHEN OTHERS THEN
712:
713: fnd_file.put_line(fnd_file.log,'Error Occured in Process_Neg_Bal'
714: ||' Function.');
715: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
716: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
717: RETURN FALSE;
718:
719: END Process_Neg_Bal;

Line 716: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);

712:
713: fnd_file.put_line(fnd_file.log,'Error Occured in Process_Neg_Bal'
714: ||' Function.');
715: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
716: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
717: RETURN FALSE;
718:
719: END Process_Neg_Bal;
720:

Line 747: fnd_file.put_line(fnd_file.log,l_sql_stmt);

743: || 'WHERE asp.future_dated_pmt_liab_relief = ''MATURITY'' '
744: || p_org_where_asp;
745:
746: IF (p_debug_switch IN ('y','Y')) THEN
747: fnd_file.put_line(fnd_file.log,l_sql_stmt);
748: END IF;
749:
750: EXECUTE IMMEDIATE l_sql_stmt INTO l_is_future_dated;
751:

Line 762: fnd_file.put_line(fnd_file.log,'Error Occured in Use_Future_Dated'

758: EXCEPTION
759:
760: WHEN OTHERS THEN
761:
762: fnd_file.put_line(fnd_file.log,'Error Occured in Use_Future_Dated'
763: ||' Function.');
764: IF (p_debug_switch IN ('y','Y')) THEN
765: fnd_file.put_line(fnd_file.log,l_sql_stmt);
766: END IF;

Line 765: fnd_file.put_line(fnd_file.log,l_sql_stmt);

761:
762: fnd_file.put_line(fnd_file.log,'Error Occured in Use_Future_Dated'
763: ||' Function.');
764: IF (p_debug_switch IN ('y','Y')) THEN
765: fnd_file.put_line(fnd_file.log,l_sql_stmt);
766: END IF;
767: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
768: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
769:

Line 767: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));

763: ||' Function.');
764: IF (p_debug_switch IN ('y','Y')) THEN
765: fnd_file.put_line(fnd_file.log,l_sql_stmt);
766: END IF;
767: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
768: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
769:
770: END Use_Future_Dated;
771:

Line 768: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);

764: IF (p_debug_switch IN ('y','Y')) THEN
765: fnd_file.put_line(fnd_file.log,l_sql_stmt);
766: END IF;
767: fnd_file.put_line(fnd_file.log,'Error Code: '||to_char(SQLCODE));
768: fnd_file.put_line(fnd_file.log,'Error Message: '||SQLERRM);
769:
770: END Use_Future_Dated;
771:
772: /*=============================================================================

Line 828: fnd_file.put_line(fnd_file.log,'Into Insert_AP_Liability_Balance Procedure');

824: l_gl_transfer_run_id xla_gl_transfer_batches_all.gl_transfer_run_id%TYPE;
825:
826: BEGIN
827:
828: fnd_file.put_line(fnd_file.log,'Into Insert_AP_Liability_Balance Procedure');
829:
830: fnd_file.put_line(fnd_file.log,'Open transfer_info cursor');
831:
832: OPEN transfer_info;

Line 830: fnd_file.put_line(fnd_file.log,'Open transfer_info cursor');

826: BEGIN
827:
828: fnd_file.put_line(fnd_file.log,'Into Insert_AP_Liability_Balance Procedure');
829:
830: fnd_file.put_line(fnd_file.log,'Open transfer_info cursor');
831:
832: OPEN transfer_info;
833:
834: LOOP

Line 839: fnd_file.put_line(fnd_file.log,'Insert ap_liability_balance for every'

835:
836: FETCH transfer_info INTO l_gl_transfer_run_id;
837: EXIT WHEN transfer_info%NOTFOUND;
838:
839: fnd_file.put_line(fnd_file.log,'Insert ap_liability_balance for every'
840: ||'gl_transfer_run_id');
841:
842: fnd_file.put_line(fnd_file.log,'Processing gl_transfer_run_id : '
843: ||l_gl_transfer_run_id);

Line 842: fnd_file.put_line(fnd_file.log,'Processing gl_transfer_run_id : '

838:
839: fnd_file.put_line(fnd_file.log,'Insert ap_liability_balance for every'
840: ||'gl_transfer_run_id');
841:
842: fnd_file.put_line(fnd_file.log,'Processing gl_transfer_run_id : '
843: ||l_gl_transfer_run_id);
844:
845: INSERT INTO ap_liability_balance
846: (ae_line_id,

Line 911: fnd_file.put_line(fnd_file.log,'Update AE Headers trial_balance_flag');

907: AND aeh.gl_transfer_flag = 'Y'
908: AND aeh.gl_transfer_run_id = l_gl_transfer_run_id
909: );
910:
911: fnd_file.put_line(fnd_file.log,'Update AE Headers trial_balance_flag');
912:
913: IF (Update_Trial_Balance_Flag (l_gl_transfer_run_id) <> TRUE) THEN
914:
915: RETURN FALSE;

Line 919: fnd_file.put_line(fnd_file.log,'Processed gl_transfer_run_id : '

915: RETURN FALSE;
916:
917: END IF;
918:
919: fnd_file.put_line(fnd_file.log,'Processed gl_transfer_run_id : '
920: ||l_gl_transfer_run_id);
921:
922: END LOOP;
923:

Line 924: fnd_file.put_line(fnd_file.log,'Close transfer_info cursor');

920: ||l_gl_transfer_run_id);
921:
922: END LOOP;
923:
924: fnd_file.put_line(fnd_file.log,'Close transfer_info cursor');
925:
926: CLOSE transfer_info;
927:
928: RETURN (TRUE);

Line 934: fnd_file.put_line(fnd_file.log,'Error Occured in '

930: EXCEPTION
931:
932: WHEN OTHERS THEN
933:
934: fnd_file.put_line(fnd_file.log,'Error Occured in '
935: ||'Insert_AP_Liability_Balance '
936: ||'Procedure');
937: fnd_file.put_line(fnd_file.log, 'Error Code: '||SQLCODE);
938: fnd_file.put_line(fnd_file.log, 'Error Message: '|| SQLERRM);

Line 937: fnd_file.put_line(fnd_file.log, 'Error Code: '||SQLCODE);

933:
934: fnd_file.put_line(fnd_file.log,'Error Occured in '
935: ||'Insert_AP_Liability_Balance '
936: ||'Procedure');
937: fnd_file.put_line(fnd_file.log, 'Error Code: '||SQLCODE);
938: fnd_file.put_line(fnd_file.log, 'Error Message: '|| SQLERRM);
939:
940: IF transfer_info%ISOPEN THEN
941: CLOSE transfer_info;

Line 938: fnd_file.put_line(fnd_file.log, 'Error Message: '|| SQLERRM);

934: fnd_file.put_line(fnd_file.log,'Error Occured in '
935: ||'Insert_AP_Liability_Balance '
936: ||'Procedure');
937: fnd_file.put_line(fnd_file.log, 'Error Code: '||SQLCODE);
938: fnd_file.put_line(fnd_file.log, 'Error Message: '|| SQLERRM);
939:
940: IF transfer_info%ISOPEN THEN
941: CLOSE transfer_info;
942: END IF;

Line 963: fnd_file.put_line(fnd_file.log, 'Into Update_Trial_Balance_Flag Procedure');

959: RETURN BOOLEAN IS
960:
961: BEGIN
962:
963: fnd_file.put_line(fnd_file.log, 'Into Update_Trial_Balance_Flag Procedure');
964: fnd_file.put_line(fnd_file.log, 'Updating AE Headers for '
965: ||p_gl_transfer_run_id);
966:
967: UPDATE ap_ae_headers_all

Line 964: fnd_file.put_line(fnd_file.log, 'Updating AE Headers for '

960:
961: BEGIN
962:
963: fnd_file.put_line(fnd_file.log, 'Into Update_Trial_Balance_Flag Procedure');
964: fnd_file.put_line(fnd_file.log, 'Updating AE Headers for '
965: ||p_gl_transfer_run_id);
966:
967: UPDATE ap_ae_headers_all
968: SET trial_balance_flag = 'Y'

Line 977: fnd_file.put_line(fnd_file.log, 'Error Occured in Update_Trial_Balance_Flag'

973:
974: EXCEPTION
975:
976: WHEN OTHERS THEN
977: fnd_file.put_line(fnd_file.log, 'Error Occured in Update_Trial_Balance_Flag'
978: ||' Procedure while processing '
979: ||' the following gl_transfer_run_id: '
980: || p_gl_transfer_run_id);
981: fnd_file.put_line(fnd_file.log, 'Error Code: '||SQLCODE);

Line 981: fnd_file.put_line(fnd_file.log, 'Error Code: '||SQLCODE);

977: fnd_file.put_line(fnd_file.log, 'Error Occured in Update_Trial_Balance_Flag'
978: ||' Procedure while processing '
979: ||' the following gl_transfer_run_id: '
980: || p_gl_transfer_run_id);
981: fnd_file.put_line(fnd_file.log, 'Error Code: '||SQLCODE);
982: fnd_file.put_line(fnd_file.log, 'Error Message: '|| SQLERRM);
983: RETURN FALSE;
984:
985: END Update_Trial_Balance_Flag;

Line 982: fnd_file.put_line(fnd_file.log, 'Error Message: '|| SQLERRM);

978: ||' Procedure while processing '
979: ||' the following gl_transfer_run_id: '
980: || p_gl_transfer_run_id);
981: fnd_file.put_line(fnd_file.log, 'Error Code: '||SQLCODE);
982: fnd_file.put_line(fnd_file.log, 'Error Message: '|| SQLERRM);
983: RETURN FALSE;
984:
985: END Update_Trial_Balance_Flag;
986: