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

Line 101: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

97: Exception
98: When others then
99: FND_MESSAGE.Set_Name ('XTR','XTR_NO_CLOSE_PER_PARAM');
100: FND_MESSAGE.Set_Token ('COMPANY_CODE', in_company);
101: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
102: Return null;
103: End GET_CLOSED_PERIOD_PARAM;
104:
105:

Line 271: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

267: -- Issue info message at beginning of each batch being processed.
268:
269: FND_MESSAGE.Set_Name ('XTR','XTR_START_GEN_BID');
270: FND_MESSAGE.Set_Token ('BID', p_curr_batch_id);
271: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
272:
273: -- End addition for 2404342.
274:
275: Open BATCH_PERIOD;

Line 295: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

291: If CHK_JOURNAL_GEN%FOUND then
292: Close CHK_JOURNAL_GEN;
293: FND_MESSAGE.Set_Name('XTR', 'XTR_JOURNAL_GEN');
294: FND_MESSAGE.Set_Token('BATCH', p_curr_batch_id);
295: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
296: l_retcode := greatest(l_retcode,1);
297: l_warn_flag := TRUE;
298: Else
299: Close CHK_JOURNAL_GEN;

Line 389: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

385: -- Issue info message at end of each batch being processed.
386:
387: FND_MESSAGE.Set_Name ('XTR','XTR_END_GEN_BID');
388: FND_MESSAGE.Set_Token ('BID', p_curr_batch_id);
389: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
390:
391: -- End addition for 2404342.
392:
393: Fetch BATCH_SEQ into p_curr_batch_id;

Line 467: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

463: EXCEPTION
464: when ex_journal_gen then
465: FND_MESSAGE.Set_Name('XTR', 'XTR_JOURNAL_GEN');
466: FND_MESSAGE.Set_Token('BATCH', p_curr_batch_id);
467: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
468: retcode := greatest(l_retcode,2);
469: -- APP_EXCEPTION.Raise_exception; -- Removed for 2404342. Interferring with new wrapper procedure JOURNALS' put_line.
470: when ex_accrls_auth then
471: FND_MESSAGE.Set_Name('XTR', 'XTR_ACCRLS_AUTH');

Line 473: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

469: -- APP_EXCEPTION.Raise_exception; -- Removed for 2404342. Interferring with new wrapper procedure JOURNALS' put_line.
470: when ex_accrls_auth then
471: FND_MESSAGE.Set_Name('XTR', 'XTR_ACCRLS_AUTH');
472: FND_MESSAGE.Set_Token('BATCH', p_curr_batch_id);
473: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
474: retcode := greatest(l_retcode,2);
475: -- APP_EXCEPTION.Raise_exception; -- Removed for 2404342. Interferring with new wrapper procedure JOURNALS' put_line.
476: when ex_early_batch then
477: FND_MESSAGE.Set_Name('XTR', 'XTR_EARLY_BATCH');

Line 480: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

476: when ex_early_batch then
477: FND_MESSAGE.Set_Name('XTR', 'XTR_EARLY_BATCH');
478: FND_MESSAGE.Set_Token('PRE_BATCH', l_pre_batch_id);
479: FND_MESSAGE.Set_Token('CUR_BATCH', p_curr_batch_id);
480: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
481: retcode := greatest(l_retcode,2);
482: -- APP_EXCEPTION.Raise_exception; -- Removed for 2404342. Interferring with new wrapper procedure JOURNALS' put_line.
483: END Do_Journal_Process;
484:

Line 1223: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

1219: when OTHERS then
1220: FND_MESSAGE.Set_Name ('XTR','XTR_UNHANDLED_EXCEPTION');
1221: FND_MESSAGE.Set_Token ('PROCEDURE','GEN_JOURNALS:VALIDATED');
1222: FND_MESSAGE.Set_Token ('EVENT','INSERT_INTO_TEMP_TABLE');
1223: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
1224: End;
1225: End If;
1226: return l_ret_value;
1227:

Line 1247: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

1243: when OTHERS then
1244: FND_MESSAGE.Set_Name ('XTR','XTR_UNHANDLED_EXCEPTION');
1245: FND_MESSAGE.Set_Token ('PROCEDURE','GEN_JOURNALS:VALIDATED');
1246: FND_MESSAGE.Set_Token ('EVENT','Inserting non-validated deal/transaction number into temp table.');
1247: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
1248: End;
1249: return FALSE;
1250: End;
1251:

Line 1263: FND_FILE.Put_Line (FND_FILE.Log, null);

1259: Begin
1260: Open UNVAL_DEALS;
1261: Fetch UNVAL_DEALS into unval_deals_rec;
1262: If (UNVAL_DEALS%FOUND) then
1263: FND_FILE.Put_Line (FND_FILE.Log, null);
1264: FND_MESSAGE.Set_Name ('XTR','XTR_UNVAL_DEALS_LIST');
1265: FND_FILE.Put_Line (FND_FILE.Log, FND_MESSAGE.Get);
1266: FND_FILE.Put_Line (FND_FILE.Log, null);
1267: While (UNVAL_DEALS%FOUND)

Line 1265: FND_FILE.Put_Line (FND_FILE.Log, FND_MESSAGE.Get);

1261: Fetch UNVAL_DEALS into unval_deals_rec;
1262: If (UNVAL_DEALS%FOUND) then
1263: FND_FILE.Put_Line (FND_FILE.Log, null);
1264: FND_MESSAGE.Set_Name ('XTR','XTR_UNVAL_DEALS_LIST');
1265: FND_FILE.Put_Line (FND_FILE.Log, FND_MESSAGE.Get);
1266: FND_FILE.Put_Line (FND_FILE.Log, null);
1267: While (UNVAL_DEALS%FOUND)
1268: Loop
1269: FND_MESSAGE.Set_Name ('XTR','XTR_UNVAL_DEALS');

Line 1266: FND_FILE.Put_Line (FND_FILE.Log, null);

1262: If (UNVAL_DEALS%FOUND) then
1263: FND_FILE.Put_Line (FND_FILE.Log, null);
1264: FND_MESSAGE.Set_Name ('XTR','XTR_UNVAL_DEALS_LIST');
1265: FND_FILE.Put_Line (FND_FILE.Log, FND_MESSAGE.Get);
1266: FND_FILE.Put_Line (FND_FILE.Log, null);
1267: While (UNVAL_DEALS%FOUND)
1268: Loop
1269: FND_MESSAGE.Set_Name ('XTR','XTR_UNVAL_DEALS');
1270: FND_MESSAGE.Set_Token ('DEAL_TYPE', unval_deals_rec.deal_type);

Line 1273: FND_FILE.Put_Line (FND_FILE.Log, FND_MESSAGE.Get);

1269: FND_MESSAGE.Set_Name ('XTR','XTR_UNVAL_DEALS');
1270: FND_MESSAGE.Set_Token ('DEAL_TYPE', unval_deals_rec.deal_type);
1271: FND_MESSAGE.Set_Token ('DEAL_NO', rtrim(to_char(unval_deals_rec.deal_number)));
1272: FND_MESSAGE.Set_Token ('TRANS_NO', rtrim(to_char(unval_deals_rec.trans_number)));
1273: FND_FILE.Put_Line (FND_FILE.Log, FND_MESSAGE.Get);
1274: Fetch UNVAL_DEALS into unval_deals_rec;
1275: End Loop;
1276: End If;
1277: Close UNVAL_DEALS;

Line 1422: --FND_FILE.Put_Line (FND_FILE.LOG, 'Q2 '||to_char(q2_rec.transaction_number));

1418:
1419: if l_create_journal = 'Y' then
1420:
1421: --start bug 2804548
1422: --FND_FILE.Put_Line (FND_FILE.LOG, 'Q2 '||to_char(q2_rec.transaction_number));
1423: if q2_rec.deal_type in ('BOND','EXP') and
1424: q2_rec.transaction_number is not null then
1425: v_ChkCpnRateReset_in.deal_type:=q2_rec.deal_type;
1426: v_ChkCpnRateReset_in.transaction_no:=q2_rec.transaction_number;

Line 1435: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

1431: --print out a warning message.
1432: if not v_ChkCpnRateReset_out.yes then
1433: FND_MESSAGE.Set_Name ('XTR','XTR_COUPON_RESET_DEAL');
1434: FND_MESSAGE.Set_Token ('DEAL_NO',v_ChkCpnRateReset_out.deal_no);
1435: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
1436: --1336492 g_gen_journal_retcode:=1;
1437:
1438: -- 1336492 modification.
1439: l_ret_value := greatest(l_ret_value,1);

Line 1507: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

1503: when GL_CURRENCY_API.INVALID_CURRENCY then
1504: FND_MESSAGE.Set_Name ('XTR','XTR_2206');
1505: FND_MESSAGE.Set_Token ('CURR1',Q2_REC.currency);
1506: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
1507: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
1508:
1509: --1336492 l_error_flag := 'Y';
1510:
1511: -- 1336492 modification, replaces above l_error_flag.

Line 1524: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);

1520: FND_MESSAGE.Set_Token ('CURR1',Q2_REC.currency);
1521: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
1522: FND_MESSAGE.Set_Token ('XCHG_DATE',to_char(Q2_REC.amount_date));
1523: FND_MESSAGE.Set_Token ('C_TYPE', nvl(l_pty_user_convert_type,l_pty_convert_type));
1524: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);
1525:
1526: --1336492 l_error_flag := 'Y';
1527:
1528: -- 1336492 modification, replaces above l_error_flag.

Line 1593: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);

1589: when OTHERS then
1590: FND_MESSAGE.Set_Name ('XTR','XTR_UNHANDLED_EXCEPTION');
1591: FND_MESSAGE.Set_Token ('PROCEDURE','GEN_JOURNALS');
1592: FND_MESSAGE.Set_Token ('EVENT','Inserting journal into table.');
1593: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);
1594:
1595: -- 1336492 addition.
1596: l_ret_value := 2;
1597: END;

Line 1790: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

1786: --print out a warning message.
1787: if not v_ChkCpnRateReset_out.yes then
1788: FND_MESSAGE.Set_Name ('XTR','XTR_COUPON_RESET_DEAL');
1789: FND_MESSAGE.Set_Token ('DEAL_NO',v_ChkCpnRateReset_out.deal_no);
1790: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
1791: --1336492 g_gen_journal_retcode:=1;
1792:
1793: -- 1336492. Replaces above g_gen_journal_retcode.
1794: l_ret_value := greatest(l_ret_value,1);

Line 1830: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

1826: when GL_CURRENCY_API.INVALID_CURRENCY then
1827: FND_MESSAGE.Set_Name ('XTR','XTR_2206');
1828: FND_MESSAGE.Set_Token ('CURR1',Q3_REC.currency);
1829: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
1830: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
1831: --1336492 l_error_flag := 'Y';
1832:
1833: -- 1336492. Replaces l_error_flag.
1834: l_ret_value := greatest(l_ret_value,2);

Line 1845: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);

1841: FND_MESSAGE.Set_Token ('CURR1',Q3_REC.currency);
1842: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
1843: FND_MESSAGE.Set_Token ('XCHG_DATE',to_char(Q3_REC.amount_date));
1844: FND_MESSAGE.Set_Token ('C_TYPE', nvl(l_pty_user_convert_type,l_pty_convert_type));
1845: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);
1846: --1336492 l_error_flag := 'Y';
1847:
1848: -- 1336492. Replaces l_error_flag.
1849: l_ret_value := greatest(l_ret_value,2);

Line 1914: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);

1910: when OTHERS then
1911: FND_MESSAGE.Set_Name ('XTR','XTR_UNHANDLED_EXCEPTION');
1912: FND_MESSAGE.Set_Token ('PROCEDURE','GEN_JOURNALS');
1913: FND_MESSAGE.Set_Token ('EVENT','Inserting exposure journal into table.');
1914: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);
1915:
1916: -- 1336492.
1917: l_ret_value := greatest(l_ret_value,2);
1918: END;

Line 1998: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);

1994: when OTHERS then
1995: FND_MESSAGE.Set_Name ('XTR','XTR_UNHANDLED_EXCEPTION');
1996: FND_MESSAGE.Set_Token ('PROCEDURE','GEN_JOURNALS');
1997: FND_MESSAGE.Set_Token ('EVENT','Inserting exposure journal into table.');
1998: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);
1999:
2000: -- 1336492.
2001: l_ret_value := greatest(l_ret_value,2);
2002:

Line 2123: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

2119: when GL_CURRENCY_API.INVALID_CURRENCY then
2120: FND_MESSAGE.Set_Name ('XTR','XTR_2206');
2121: FND_MESSAGE.Set_Token ('CURR1',Q4_REC.currency);
2122: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
2123: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
2124: --1336492 l_error_flag := 'Y';
2125: l_ret_value := greatest(l_ret_value,2);
2126: Goto NEXT_Q4;
2127:

Line 2134: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);

2130: FND_MESSAGE.Set_Token ('CURR1',Q4_REC.currency);
2131: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
2132: FND_MESSAGE.Set_Token ('XCHG_DATE',to_char(Q4_REC.amount_date));
2133: FND_MESSAGE.Set_Token ('C_TYPE', nvl(l_pty_user_convert_type,l_pty_convert_type));
2134: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);
2135: --1336492 l_error_flag := 'Y';
2136: l_ret_value := greatest(l_ret_value,2);
2137: Goto NEXT_Q4;
2138: END;

Line 2197: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);

2193: when OTHERS then
2194: FND_MESSAGE.Set_Name ('XTR','XTR_UNHANDLED_EXCEPTION');
2195: FND_MESSAGE.Set_Token ('PROCEDURE','GEN_JOURNALS');
2196: FND_MESSAGE.Set_Token ('EVENT','Inserting accruals journal into table');
2197: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);
2198:
2199: -- 1336492.
2200: l_ret_value := greatest(l_ret_value,2);
2201: END;

Line 2318: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

2314: when GL_CURRENCY_API.INVALID_CURRENCY then
2315: FND_MESSAGE.Set_Name ('XTR','XTR_2206');
2316: FND_MESSAGE.Set_Token ('CURR1',Q5_REC.reval_currency);
2317: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
2318: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
2319: --1336492 l_error_flag := 'Y';
2320: l_ret_value := greatest(l_ret_value,2);
2321: Goto NEXT_Q5;
2322:

Line 2329: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);

2325: FND_MESSAGE.Set_Token ('CURR1',Q5_REC.reval_currency);
2326: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
2327: FND_MESSAGE.Set_Token ('XCHG_DATE',to_char(Q5_REC.journal_date));
2328: FND_MESSAGE.Set_Token ('C_TYPE', nvl(l_pty_user_convert_type,l_pty_convert_type));
2329: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);
2330: --1336492 l_error_flag := 'Y';
2331: l_ret_value := greatest(l_ret_value,2);
2332: Goto NEXT_Q5;
2333: END;

Line 2417: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);

2413: when OTHERS then
2414: FND_MESSAGE.Set_Name ('XTR','XTR_UNHANDLED_EXCEPTION');
2415: FND_MESSAGE.Set_Token ('PROCEDURE','GEN_JOURNALS');
2416: FND_MESSAGE.Set_Token ('EVENT','Inserting revaluation journal into table');
2417: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);
2418:
2419: END;
2420:
2421:

Line 2491: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);

2487: when OTHERS then
2488: FND_MESSAGE.Set_Name ('XTR','XTR_UNHANDLED_EXCEPTION');
2489: FND_MESSAGE.Set_Token ('PROCEDURE','GEN_JOURNALS');
2490: FND_MESSAGE.Set_Token ('EVENT','Inserting revaluation journal into table');
2491: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);
2492:
2493: -- 1336492.
2494: l_ret_value := greatest(l_ret_value,2);
2495: END;

Line 2623: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

2619: when GL_CURRENCY_API.INVALID_CURRENCY then
2620: FND_MESSAGE.Set_Name ('XTR','XTR_2206');
2621: FND_MESSAGE.Set_Token ('CURR1',Q6_REC.reval_currency);
2622: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
2623: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
2624: l_ret_value := greatest(l_ret_value,2);
2625: Goto NEXT_Q6;
2626:
2627: when GL_CURRENCY_API.NO_RATE then

Line 2633: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);

2629: FND_MESSAGE.Set_Token ('CURR1',Q6_REC.reval_currency);
2630: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
2631: FND_MESSAGE.Set_Token ('XCHG_DATE',to_char(Q6_REC.journal_date));
2632: FND_MESSAGE.Set_Token ('C_TYPE', nvl(l_pty_user_convert_type,l_pty_convert_type));
2633: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);
2634: l_ret_value := greatest(l_ret_value,2);
2635: Goto NEXT_Q6;
2636: END;
2637:

Line 2719: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);

2715: when OTHERS then
2716: FND_MESSAGE.Set_Name ('XTR','XTR_UNHANDLED_EXCEPTION');
2717: FND_MESSAGE.Set_Token ('PROCEDURE','GEN_JOURNALS');
2718: FND_MESSAGE.Set_Token ('EVENT','Inserting revaluation journal into table');
2719: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);
2720:
2721: END;
2722:
2723:

Line 2786: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);

2782:
2783: if Q6_REC.reval_eff_flag = 'T' then
2784: FND_MESSAGE.set_name('XTR', 'XTR_HEDGE_JOURNAL_TREAT');
2785: FND_MESSAGE.Set_Token ('DEAL_NO', Q6_REC.deal_number);
2786: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);
2787: End if;
2788:
2789: EXCEPTION
2790: when DUP_VAL_ON_INDEX then

Line 2796: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);

2792: when OTHERS then
2793: FND_MESSAGE.Set_Name ('XTR','XTR_UNHANDLED_EXCEPTION');
2794: FND_MESSAGE.Set_Token ('PROCEDURE','GEN_JOURNALS');
2795: FND_MESSAGE.Set_Token ('EVENT','Inserting revaluation journal into table');
2796: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);
2797: l_ret_value := greatest(l_ret_value,2);
2798: END;
2799:
2800: End if; -- Fx in SOB currency

Line 2875: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

2871: when GL_CURRENCY_API.INVALID_CURRENCY then
2872: FND_MESSAGE.Set_Name ('XTR','XTR_2206');
2873: FND_MESSAGE.Set_Token ('CURR1',Q7_REC.reval_currency);
2874: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
2875: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
2876: l_ret_value := greatest(l_ret_value,2);
2877: Goto NEXT_Q7;
2878:
2879: when GL_CURRENCY_API.NO_RATE then

Line 2885: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);

2881: FND_MESSAGE.Set_Token ('CURR1',Q7_REC.reval_currency);
2882: FND_MESSAGE.Set_Token ('CURR2',l_sob_currency);
2883: FND_MESSAGE.Set_Token ('XCHG_DATE',to_char(Q7_REC.journal_date));
2884: FND_MESSAGE.Set_Token ('C_TYPE', nvl(l_pty_user_convert_type,l_pty_convert_type));
2885: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);
2886: l_ret_value := greatest(l_ret_value,2);
2887: Goto NEXT_Q7;
2888: END;
2889: BEGIN

Line 2947: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);

2943: when OTHERS then
2944: FND_MESSAGE.Set_Name ('XTR','XTR_UNHANDLED_EXCEPTION');
2945: FND_MESSAGE.Set_Token ('PROCEDURE','GEN_JOURNALS');
2946: FND_MESSAGE.Set_Token ('EVENT','Inserting revaluation journal into table');
2947: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);
2948: l_ret_value := greatest(l_ret_value,2);
2949: END;
2950:
2951: End If; -- If zero amounts.

Line 3022: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);

3018: when OTHERS then
3019: FND_MESSAGE.Set_Name ('XTR','XTR_UNHANDLED_EXCEPTION');
3020: FND_MESSAGE.Set_Token ('PROCEDURE','GEN_JOURNALS');
3021: FND_MESSAGE.Set_Token ('EVENT','Inserting batch event record into table');
3022: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.get);
3023: PRT_UNVAL_DEALS; -- added for 1336492.
3024: Rollback;
3025: return 2; -- modified for 1336492.
3026: END;

Line 3410: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

3406: -- related journal generation request.
3407:
3408: FND_MESSAGE.Set_Name ('XTR','XTR_NO_CUTOFF_DATE');
3409: FND_MESSAGE.Set_Token ('COMPANY_CODE', l_company_code);
3410: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
3411: l_retcode := greatest(l_retcode,2);
3412:
3413: Elsif (p_batch_id_from is not null and p_batch_id_to is not null) then
3414:

Line 3423: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

3419:
3420: FND_MESSAGE.Set_Name ('XTR','XTR_INVALID_PARAMETER_COMBO');
3421: FND_MESSAGE.Set_Token ('BID_FROM', to_char(p_batch_id_from));
3422: FND_MESSAGE.Set_Token ('BID_TO', to_char(p_batch_id_to));
3423: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
3424: l_retcode := greatest(l_retcode,2);
3425:
3426: Elsif (p_cutoff_date is not null) then
3427:

Line 3437: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

3433:
3434: FND_MESSAGE.Set_Name ('XTR','XTR_START_GEN_JRNL_BY_DATE');
3435: FND_MESSAGE.Set_Token ('COMPANY_CODE', l_company_code);
3436: FND_MESSAGE.Set_Token ('CUTOFF_DATE', p_cutoff_date);
3437: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
3438:
3439: Do_Journal_Process
3440: (l_sub_errbuf,
3441: l_sub_retcode,

Line 3453: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

3449:
3450: FND_MESSAGE.Set_Name ('XTR','XTR_END_GEN_JRNL_BY_DATE');
3451: FND_MESSAGE.Set_Token ('COMPANY_CODE', l_company_code);
3452: FND_MESSAGE.Set_Token ('CUTOFF_DATE', p_cutoff_date);
3453: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
3454:
3455: Fetch USER_COMPANIES into l_company_code, l_sob_id;
3456: End Loop;
3457: Close USER_COMPANIES;

Line 3477: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

3473: FND_MESSAGE.Set_Name ('XTR','XTR_START_GEN_JRNL_BY_BID');
3474: FND_MESSAGE.Set_Token ('COMPANY_CODE', l_company_code);
3475: FND_MESSAGE.Set_Token ('BID_FROM', to_char(p_batch_id_from));
3476: FND_MESSAGE.Set_Token ('BID_TO', to_char(p_batch_id_to));
3477: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
3478:
3479: Do_Journal_Process
3480: (l_sub_errbuf,
3481: l_sub_retcode,

Line 3494: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

3490: FND_MESSAGE.Set_Name ('XTR','XTR_END_GEN_JRNL_BY_BID');
3491: FND_MESSAGE.Set_Token ('COMPANY_CODE', l_company_code);
3492: FND_MESSAGE.Set_Token ('BID_FROM', to_char(p_batch_id_from));
3493: FND_MESSAGE.Set_Token ('BID_TO', to_char(p_batch_id_to));
3494: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
3495:
3496: Fetch USER_COMPANIES into l_company_code, l_sob_id;
3497: End Loop;
3498: Close USER_COMPANIES;

Line 3518: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

3514: -- Start journal transfer process for company.
3515:
3516: FND_MESSAGE.Set_Name ('XTR','XTR_START_XFER_JRNL');
3517: FND_MESSAGE.Set_Token ('COMPANY_CODE', l_company_code);
3518: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
3519:
3520: -- If no specific closed period posting denoted, use per company parameter.
3521: -- Otherwise, use the user overridden value.
3522:

Line 3597: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

3593: l_sub_retcode := 1;
3594: FND_MESSAGE.Set_Name ('XTR','XTR_START_XFER_JRNL_BATCH');
3595: FND_MESSAGE.Set_Token ('COMPANY_CODE', l_company_code);
3596: FND_MESSAGE.Set_Token ('BID', to_char(l_next_bid));
3597: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
3598: FND_MESSAGE.Set_Name ('XTR','XTR_CONC_DIFF_ACCTG');
3599: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
3600: FND_MESSAGE.Set_Name ('XTR','XTR_END_XFER_JRNL_BATCH');
3601: FND_MESSAGE.Set_Token ('COMPANY_CODE', l_company_code);

Line 3599: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

3595: FND_MESSAGE.Set_Token ('COMPANY_CODE', l_company_code);
3596: FND_MESSAGE.Set_Token ('BID', to_char(l_next_bid));
3597: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
3598: FND_MESSAGE.Set_Name ('XTR','XTR_CONC_DIFF_ACCTG');
3599: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
3600: FND_MESSAGE.Set_Name ('XTR','XTR_END_XFER_JRNL_BATCH');
3601: FND_MESSAGE.Set_Token ('COMPANY_CODE', l_company_code);
3602: FND_MESSAGE.Set_Token ('BID', to_char(l_next_bid));
3603: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

Line 3603: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

3599: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
3600: FND_MESSAGE.Set_Name ('XTR','XTR_END_XFER_JRNL_BATCH');
3601: FND_MESSAGE.Set_Token ('COMPANY_CODE', l_company_code);
3602: FND_MESSAGE.Set_Token ('BID', to_char(l_next_bid));
3603: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
3604: l_retcode := greatest(l_retcode, l_sub_retcode);
3605: Else
3606:
3607: XTR_ORACLE_FIN_INTERFACES_P.Transfer_Jnls

Line 3638: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);

3634: End If;
3635:
3636: FND_MESSAGE.Set_Name ('XTR','XTR_END_XFER_JRNL');
3637: FND_MESSAGE.Set_Token ('COMPANY_CODE', l_company_code);
3638: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
3639:
3640: Fetch USER_COMPANIES into l_company_code, l_sob_id;
3641: End Loop;
3642: End If;