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

Line 236: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

232: WHEN NO_DATA_FOUND Then
233: vp_retcode := -1 ;
234: vp_errbuf := 'Treasury Symbol Id cannot be found for the Treasury
235: Symbol - '|| vp_treasury_symbol || ' [ MAIN ] ' ;
236: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
237: -- fv_utility.debug_mesg('[TS MAIN]'||SQLERRM);
238: Return ;
239: End ; -- TS
240:

Line 245: fnd_file.put_line(fnd_file.log, fnd_message.get) ;

241:
242: If vp_retcode = 0 Then
243: -- fv_utility.debug_mesg('PURGING TEMP TABLE');
244: fnd_message.set_Name('FV', 'Purging FACTS Temp....') ;
245: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
246: PURGE_FACTS_TRANSACTIONS ;
247: End If ;
248:
249: If vp_retcode = 0 Then

Line 252: fnd_file.put_line(fnd_file.log, fnd_message.get) ;

248:
249: If vp_retcode = 0 Then
250: -- fv_utility.debug_mesg('DERVING QUALIFIER');
251: fnd_message.set_Name('FV', 'Deriving Qualifier Seg....') ;
252: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
253: GET_QUALIFIER_SEGMENTS ;
254: End If ;
255:
256: If vp_retcode = 0 Then

Line 259: fnd_file.put_line(fnd_file.log, fnd_message.get) ;

255:
256: If vp_retcode = 0 Then
257: -- fv_utility.debug_mesg('GET COHORT INFO');
258: fnd_message.set_Name('FV','Deriving Treasury Sym Info');
259: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
260: GET_COHORT_INFO ;
261: End If ;
262:
263:

Line 267: fnd_file.put_line(fnd_file.log, fnd_message.get) ;

263:
264: If vp_retcode = 0 Then
265: -- fv_utility.debug_mesg('GET PERIOD INFO');
266: fnd_message.set_Name('FV', 'Deriving Period Info') ;
267: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
268: GET_PERIOD_INFO ;
269: End If ;
270:
271: If vp_retcode = 0 Then

Line 274: fnd_file.put_line(fnd_file.log, fnd_message.get) ;

270:
271: If vp_retcode = 0 Then
272: -- fv_utility.debug_mesg('START MAIN PROCESS');
273: fnd_message.set_Name('FV', 'FACTS Main Process.....') ;
274: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
275: PROCESS_TBAL_TRANSACTIONS ;
276: COMMIT;
277: Else
278: ROLLBACK;

Line 290: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

286: When Others Then
287: -- fv_utility.debug_mesg('WHEN OTHERS ERROR: IN [MAIN]'||SQLERRM||SQLCODE);
288: vp_retcode := sqlcode ;
289: vp_errbuf := sqlerrm || ' [MAIN] ' ;
290: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
291: END MAIN ;
292:
293: -- -------------------------------------------------------------------
294: -- PROCEDURE PURGE_FACTS_TRANSACTIONS

Line 316: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

312: Null ;
313: When Others Then
314: vp_retcode := sqlcode ;
315: vp_errbuf := sqlerrm ;
316: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
317: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN PURGE DATA:'||SQLERRM||SQLCODE);
318: Return ;
319: END PURGE_FACTS_TRANSACTIONS ;
320:

Line 398: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

394: EXCEPTION
395: when invalid_segment then
396: vp_retcode := -1;
397: vp_errbuf := 'Cannot Read the Balancing and account segments';
398: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
399: -- fv_utility.debug_mesg(' INVALID SEGMENT [GET_SEGMENT_INFO]');
400:
401: rollback;
402: return;

Line 407: fnd_file.put_line(fnd_file.log,vp_errbuf) ;

403:
404: when others then
405: vp_retcode := sqlcode;
406: vp_errbuf := sqlerrm ;
407: fnd_file.put_line(fnd_file.log,vp_errbuf) ;
408: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN [GET_QUALIFIER_SEGMENT]'||SQLERRM);
409: return;
410: END GET_QUALIFIER_SEGMENTS ;
411:

Line 444: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

440: When NO_DATA_FOUND Then
441: vp_retcode := -1 ;
442: vp_errbuf := 'Error Getting Beginning Period Information
443: [GET_PERIOD_INFO]' ;
444: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
445: -- fv_utility.debug_mesg('NO DATA FOUND ERROR IN [GET PERIOD_INFO-1]');
446:
447: Return ;
448:

Line 453: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

449: When TOO_MANY_ROWS Then
450: vp_retcode := -1 ;
451: vp_errbuf := 'More than one Beginning Period Returned !!
452: [GET_PERIOD_INFO]' ;
453: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
454: -- fv_utility.debug_mesg('TOO MANY ROWS ERROR IN [GET PERIOD_INFO-1]');
455: Return ;
456: End ;
457: EXCEPTION

Line 463: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

459: -- Exception Processing
460: When Others Then
461: vp_retcode := sqlcode ;
462: vp_errbuf := sqlerrm || ' [GET_PERIOD_INFO] ' ;
463: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
464: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN [GET PERIOD_INFO-MAIN]'||SQLERRM);
465: Return ;
466: END GET_PERIOD_INFO ;
467:

Line 505: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

501: When NO_DATA_FOUND Then
502: vp_retcode := -1 ;
503: vp_errbuf := 'No Financing Account found for the passed
504: Treasury Symbol [GET_COHORT_INFO] ' ;
505: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
506: -- fv_utility.debug_mesg('NO DATA FOUND ERROR IN [GET_COHORT_INFO]'||SQLERRM);
507: return;
508: When TOO_MANY_ROWS Then
509: vp_retcode := -1 ;

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

508: When TOO_MANY_ROWS Then
509: vp_retcode := -1 ;
510: vp_errbuf := 'More than one Financing Account returned for the
511: passed Treasury Symbol [GET_COHORT_INFO]' ;
512: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
513: -- fv_utility.debug_mesg('TOO MANY ROWS ERROR IN [GET_COHORT_INFO]'||SQLERRM);
514: return;
515: When OTHERS Then
516: vp_retcode := SQLCODE ;

Line 518: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

514: return;
515: When OTHERS Then
516: vp_retcode := SQLCODE ;
517: vp_errbuf := 'WHEN OTHERS IN [GET_COHORT_INFO]'||SQLERRM;
518: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
519: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN [GET_COHORT_INFO]'||SQLERRM);
520: return;
521:
522: END GET_COHORT_INFO ;

Line 668: fnd_file.put_line(fnd_file.log, fnd_message.get) ;

664: END IF;
665:
666:
667: fnd_message.set_Name('FV', 'Selecting FACTS Trans...') ;
668: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
669: -- fv_utility.debug_mesg('**** START MAIN PROCESS ****');
670:
671: Begin
672: vl_main_cursor := DBMS_SQL.OPEN_CURSOR ;

Line 677: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

673: Exception
674: When Others Then
675: vp_retcode := sqlcode ;
676: VP_ERRBUF := sqlerrm ;
677: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
678: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN MAIN CURSOR OPEN'||SQLERRM);
679: Return ;
680: End ;
681:

Line 730: fnd_file.put_line(fnd_file.log,vl_main_select);

726: END IF;
727:
728: vl_main_select := vl_main_select || ' ORDER BY GLCC.' || v_acc_seg_name;
729:
730: fnd_file.put_line(fnd_file.log,vl_main_select);
731:
732: Begin
733: dbms_sql.parse(vl_main_cursor, vl_main_select, DBMS_SQL.V7) ;
734: Exception

Line 738: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

734: Exception
735: When Others Then
736: vp_retcode := sqlcode ;
737: VP_ERRBUF := sqlerrm ;
738: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
739: -- fv_utility.debug_mesg('ERROR IN MAIN CURSOR PARSE'||SQLERRM);
740:
741: Return ;
742: End ;

Line 756: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

752: Exception
753: When Others Then
754: vp_retcode := sqlcode ;
755: VP_ERRBUF := sqlerrm ;
756: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
757: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN MAIN CURSOR EXECUTE:'||SQLERRM);
758: Return ;
759: End ;
760:

Line 762: fnd_file.put_line(fnd_file.log, fnd_message.get) ;

758: Return ;
759: End ;
760:
761: fnd_message.set_Name('FV', 'Processing starts.') ;
762: fnd_file.put_line(fnd_file.log, fnd_message.get) ;
763:
764: LOOP --Main Select Loop
765:
766: -- Reset the Cursor Variable

Line 778: fnd_file.put_line(fnd_file.log, vp_errbuf);

774:
775: IF vl_main_fetch = 0 then
776: IF vl_count = 0 Then
777: VP_ERRBUF := 'No Data found for FACTS II process';
778: fnd_file.put_line(fnd_file.log, vp_errbuf);
779: VP_ERRBUF := 'No Data found for FACTS II Transaction Register' ||':'||v_begin_period_num||'Year:'||v_fiscal_year
780: ||'SOB:'||vp_set_of_books_id||'TS:'||vp_treasury_Symbol;
781: -- fv_utility.debug_mesg(vp_errbuf);
782: END IF;

Line 803: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

799: Exception
800: When Others Then
801: vp_retcode := sqlcode ;
802: VP_ERRBUF := sqlerrm || '[From Main Cursor ]';
803: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
804: Return ;
805: End ;
806:
807:

Line 838: fnd_file.put_line(fnd_file.log, vl_amount_select) ;

834: --pkpatel :Bug 1553095(Solution Altered)
835: -- ' AND glb.currency_code = '|| '''' || g_currency_code || '''';
836:
837:
838: fnd_file.put_line(fnd_file.log, vl_amount_select) ;
839: Begin
840: dbms_sql.parse(vl_amount_cursor,vl_amount_select,DBMS_SQL.V7);
841:
842: Exception

Line 846: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

842: Exception
843: When Others Then
844: vp_retcode := sqlcode ;
845: VP_ERRBUF := sqlerrm || '[ Parsing vl_amount_cursor ]' ;
846: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
847: Return ;
848: End ;
849:
850: dbms_sql.define_column(vl_amount_cursor, 1, vl_new_amount);

Line 858: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

854: Exception
855: When Others Then
856: vp_retcode := sqlcode ;
857: VP_ERRBUF := sqlerrm || '[ Open vl_amount_cursor]' ;
858: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
859: Return ;
860: End ;
861:
862: vl_amount_fetch := dbms_sql.fetch_rows(vl_amount_cursor) ;

Line 867: fnd_file.put_line(fnd_file.log,v_acct_num || ' amount: ' || to_char(vl_main_amount)) ;

863: dbms_sql.column_Value(vl_amount_cursor, 1, vl_new_amount );
864: End;
865: vl_main_amount := vl_new_amount;
866:
867: fnd_file.put_line(fnd_file.log,v_acct_num || ' amount: ' || to_char(vl_main_amount)) ;
868: -----------------------------------------------------------------------------
869: -- fv_utility.debug_mesg('Account:'||v_acct_num);
870: -- fv_utility.debug_mesg('Fund Va:'||v_fund_val);
871: -- fv_utility.debug_mesg('Amount :'||vl_main_amount);

Line 894: -- fnd_file.put_line(fnd_file.log, vp_errbuf) ;

890: -- and can be used to get FACTS attributes.
891: LOAD_FACTS_ATTRIBUTES (v_acct_num, v_fund_val) ;
892: vl_attributes_found := 'Y' ;
893: --VP_ERRBUF := 'LOAD ATTRIBUTES FOR ACCT:'||v_acct_num||'-'||v_fund_val;
894: -- fnd_file.put_line(fnd_file.log, vp_errbuf) ;
895: Exception
896: WHEN NO_DATA_FOUND Then
897: -- fv_utility.debug_mesg('NO PROBLEM*** GET PARENT ATTRIBUTES');
898: --Reset the vl_sgl_acct_num

Line 902: -- fnd_file.put_line(fnd_file.log, vp_errbuf) ;

898: --Reset the vl_sgl_acct_num
899: vl_sgl_acct_num := Null;
900: GET_SGL_PARENT(v_acct_num, vl_sgl_acct_num) ;
901: -- VP_ERRBUF := 'LOAD ATTRIBUTES NO DATA:'||v_acct_num||'-'||vl_sgl_acct_num;
902: -- fnd_file.put_line(fnd_file.log, vp_errbuf) ;
903: IF vl_sgl_acct_num IS NULL Then
904: vl_attributes_found := 'N' ;
905: ELSE
906: vl_attributes_found := 'Y' ;

Line 956: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

952: Exception
953: When Others Then
954: vp_retcode := sqlcode ;
955: VP_ERRBUF := sqlerrm ;
956: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
957: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN SUB CURSOR OPEN'||SQLERRM);
958: Return ;
959: End ;
960: -- Change the Date format to have DD-MON-YYYY

Line 994: fnd_file.put_line(FND_FILE.LOG, 'Fiscal yr Segment '||v_fyr_segment_name);

990: INTO v_fyr_segment_name
991: FROM fv_pya_fiscalyear_segment
992: WHERE set_of_books_id = vp_set_of_books_id;
993:
994: fnd_file.put_line(FND_FILE.LOG, 'Fiscal yr Segment '||v_fyr_segment_name);
995:
996: Exception
997: WHEN Others THEN
998: vp_retcode := sqlcode ;

Line 1000: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

996: Exception
997: WHEN Others THEN
998: vp_retcode := sqlcode ;
999: VP_ERRBUF := sqlerrm ;
1000: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
1001:
1002: End;
1003:
1004: -- Bug 2512646 END

Line 1070: fnd_file.put_line(fnd_file.log,vl_legis_select);

1066:
1067: IF v_pagebreak1 IS NOT NULL THEN
1068: vl_legis_select := vl_legis_select || ')';
1069: END IF;
1070: fnd_file.put_line(fnd_file.log,vl_legis_select);
1071: Begin
1072: dbms_sql.parse(vl_legis_cursor,vl_legis_select,DBMS_SQL.V7);
1073: Exception
1074: When Others Then

Line 1077: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

1073: Exception
1074: When Others Then
1075: vp_retcode := sqlcode ;
1076: VP_ERRBUF := sqlerrm ;
1077: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
1078: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN SUB CURSOR PARSE:'||SQLERRM);
1079: Return ;
1080: End ;
1081:

Line 1118: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

1114: Exception
1115: When Others Then
1116: vp_retcode := sqlcode ;
1117: VP_ERRBUF := 'BAB'||sqlerrm ;
1118: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
1119: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN SUB CURSOR EXECUTE'||SQLERRM);
1120: Return ;
1121: End ;
1122: vll_inner_count := 0;

Line 1199: '-'||v_fund_val; fnd_file.put_line(fnd_file.log, vp_errbuf) ; */

1195: -- and can be used to get FACTS attributes.
1196: LOAD_FACTS_ATTRIBUTES (v_acct_num, v_fund_val) ;
1197: vl_attributes_found := 'Y' ;
1198: /* VP_ERRBUF := 'LOAD ATTRIBUTES FOR ACCT:'||v_acct_num||
1199: '-'||v_fund_val; fnd_file.put_line(fnd_file.log, vp_errbuf) ; */
1200: Exception
1201: WHEN NO_DATA_FOUND Then
1202: -- fv_utility.debug_mesg('NO PROBLEM*** GET PARENT ATTRIBUTES');
1203: --Reset the vl_sgl_acct_num

Line 1207: -- fnd_file.put_line(fnd_file.log, vp_errbuf) ;

1203: --Reset the vl_sgl_acct_num
1204: vl_sgl_acct_num := Null;
1205: GET_SGL_PARENT(v_acct_num, vl_sgl_acct_num) ;
1206: -- VP_ERRBUF := 'LOAD ATTRIBUTES NO DATA:'||v_acct_num||'-'||vl_sgl_acct_num;
1207: -- fnd_file.put_line(fnd_file.log, vp_errbuf) ;
1208: IF vl_sgl_acct_num IS NULL Then
1209: vl_attributes_found := 'N' ;
1210: ELSE
1211: vl_attributes_found := 'Y' ;

Line 1298: fnd_file.put_line(FND_FILE.LOG, ' BEFORE Acct - ' || v_acct_num || 'Fund - '

1294: -- bganesan
1295: -- Fixed Bug # 1326774
1296: -- June 13, 2000
1297:
1298: fnd_file.put_line(FND_FILE.LOG, ' BEFORE Acct - ' || v_acct_num || 'Fund - '
1299: || v_fund_val || ' Flag ' || va_public_law_code_flag
1300: || ' Value '|| va_public_law_code_val) ;
1301:
1302: If vl_attributes_found = 'Y' then

Line 1334: -- fnd_file.put_line(fnd_file.log, 'Legis1') ;

1330:
1331: -- Get the Transaction Type Value
1332: Begin
1333:
1334: -- fnd_file.put_line(fnd_file.log, 'Legis1') ;
1335: Select transaction_type_id
1336: Into vl_tran_type
1337: From Fv_be_trx_dtls
1338: where transaction_id = vl_legis_ref1

Line 1342: --fnd_file.put_line(fnd_file.log, 'legis2') ;

1338: where transaction_id = vl_legis_ref1
1339: and set_of_books_id = vp_set_of_books_id ;
1340:
1341:
1342: --fnd_file.put_line(fnd_file.log, 'legis2') ;
1343: -- Get the Legislation Indicator Value from
1344: -- fv_be_transaction_types table.
1345: Select legislative_indicator
1346: into va_legis_ind_val

Line 1354: -- fnd_file.put_line(fnd_file.log, 'Legis No data') ;

1350:
1351:
1352: Exception
1353: When NO_DATA_FOUND Then
1354: -- fnd_file.put_line(fnd_file.log, 'Legis No data') ;
1355: va_legis_ind_val := 'A' ;
1356: When INVALID_NUMBER Then
1357: va_legis_ind_val := 'A' ;
1358: End ;

Line 1377: fnd_file.put_line(fnd_file.log,

1373: WHERE transaction_id = vl_legis_ref1
1374: AND set_of_books_id = vp_set_of_books_id ;
1375:
1376: IF v_debug THEN
1377: fnd_file.put_line(fnd_file.log,
1378: 'Advance Type - '||
1379: nvl(va_advance_type_val, 'Advance Type Null')) ;
1380: END IF ;
1381:

Line 1419: fnd_file.put_line(fnd_file.log,

1415: WHERE transaction_id = vl_legis_ref1
1416: AND set_of_books_id = vp_set_of_books_id ;
1417:
1418: IF v_debug THEN
1419: fnd_file.put_line(fnd_file.log,
1420: 'Transfer Dept ID - '||
1421: nvl(va_transfer_dept_id, 'Transfer Dept ID Null')) ;
1422: fnd_file.put_line(fnd_file.log,
1423: 'Transfer Main Acct - '||

Line 1422: fnd_file.put_line(fnd_file.log,

1418: IF v_debug THEN
1419: fnd_file.put_line(fnd_file.log,
1420: 'Transfer Dept ID - '||
1421: nvl(va_transfer_dept_id, 'Transfer Dept ID Null')) ;
1422: fnd_file.put_line(fnd_file.log,
1423: 'Transfer Main Acct - '||
1424: nvl(va_transfer_main_acct, 'Transfer Main Acct Null')) ;
1425:
1426: END IF ;

Line 1469: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

1465: vp_retcode := sqlcode ;
1466: vp_errbuf := ' Error! No Attributes Definied for the Account - ' ||
1467: vl_sgl_acct_num || ' [PROCESS_TBAL_TRANSCTIONS]'||sqlerrm ;
1468:
1469: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
1470: Return ;
1471:
1472: END;
1473:

Line 1506: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

1502: When Others Then
1503: vp_retcode := sqlcode ;
1504: vp_errbuf := sqlerrm ||
1505: ' [ PROCESS_TBAL_TRANSCTIONS vl_disbursements_flag - ] ' ;
1506: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
1507: Return ;
1508: END;
1509:
1510: END IF;

Line 1527: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

1523: When Others Then
1524: vp_retcode := sqlcode ;
1525: vp_errbuf := sqlerrm ||
1526: ' [ PROCESS_TBAL_TRANSCTIONS - v_time_frame ] ' ;
1527: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
1528: --Return ;
1529: END;
1530:
1531: IF v_time_frame = 'NO_YEAR'

Line 1551: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

1547: When Others Then
1548: vp_retcode := sqlcode ;
1549: vp_errbuf := sqlerrm ||
1550: ' [ PROCESS_TBAL_TRANSCTIONS vl_fyr_segment_value - ] ' ;
1551: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
1552: --Return ;
1553: END;
1554:
1555: IF vl_fyr_segment_value IS NOT NULL THEN

Line 1619: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

1615: When Others Then
1616: vp_retcode := sqlcode ;
1617: vp_errbuf := sqlerrm ||
1618: ' [ PROCESS_TBAL_TRANSCTIONS- ] ' ;
1619: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
1620: -- fv_utility.debug_mesg('WHEN OTHERS IN SUB LOOP'||SQLERRM);
1621: Return ;
1622: End ;
1623: -----------------------------------------------------------------

Line 1645: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

1641:
1642: if vl_req_id = 0 then
1643: vp_errbuf := 'Error submitting Transaction Register Balance with Attributes Report ';
1644: vp_retcode := -1 ;
1645: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
1646: Else
1647: vp_errbuf:= 'Transaction Register Report submitted successfully with the Request ID : '||
1648: to_char(vl_req_id) ;
1649: fnd_file.put_line(fnd_file.log, vp_errbuf);

Line 1649: fnd_file.put_line(fnd_file.log, vp_errbuf);

1645: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
1646: Else
1647: vp_errbuf:= 'Transaction Register Report submitted successfully with the Request ID : '||
1648: to_char(vl_req_id) ;
1649: fnd_file.put_line(fnd_file.log, vp_errbuf);
1650: IF vl_print_option THEN
1651: vp_errbuf:= 'Transaction Register Report will be send for printing to printer: '||vl_printer_name;
1652: fnd_file.put_line(fnd_file.log,vp_errbuf);
1653: END IF;

Line 1652: fnd_file.put_line(fnd_file.log,vp_errbuf);

1648: to_char(vl_req_id) ;
1649: fnd_file.put_line(fnd_file.log, vp_errbuf);
1650: IF vl_print_option THEN
1651: vp_errbuf:= 'Transaction Register Report will be send for printing to printer: '||vl_printer_name;
1652: fnd_file.put_line(fnd_file.log,vp_errbuf);
1653: END IF;
1654: end if;
1655:
1656: EXCEPTION

Line 1661: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

1657:
1658: When Others Then
1659: vp_retcode := sqlcode ;
1660: vp_errbuf := 'WHEN OTHERS IN PROCESS TBAL TRANSACTION:'||sqlerrm ;
1661: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
1662: -- fv_utility.debug_mesg('WHEN OTHERS IN PROCESS TBAL TRANSACTION:'||SQLERRM);
1663:
1664: END PROCESS_TBAL_TRANSACTIONS ;
1665:

Line 1726: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

1722: When NO_DATA_FOUND Then
1723: vp_retcode := -1 ;
1724: vp_errbuf := 'Error! No Attributes Definied for the Account - ' ||
1725: v_acct_num || ' [LOAD_FACTS_ATTRIBURES]' ;
1726: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
1727: -- fv_utility.debug_mesg('ERROR NO DATA FOUND [LOAD_FACTS_ATTRIBUTES]'||vp_errbuf);
1728: return;
1729: When Others Then
1730: vp_retcode := sqlcode ;

Line 1732: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

1728: return;
1729: When Others Then
1730: vp_retcode := sqlcode ;
1731: vp_errbuf := sqlerrm ;
1732: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
1733: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN [LOAD_FACTS_ATTRIBUTES]'||SQLERRM);
1734: return;
1735: End ;
1736:

Line 1761: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

1757: When NO_DATA_FOUND Then
1758: --vp_retcode := -1 ;
1759: vp_errbuf := 'Error getting Fund Category value for the fund - '||
1760: fund_val || ' [LOAD_FACTS_ATTRIBURES]' ;
1761: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
1762: -- fv_utility.debug_mesg('NO DATA FOUND '||vp_errbuf);
1763: --return;
1764:
1765: When Others Then

Line 1768: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

1764:
1765: When Others Then
1766: vp_retcode := sqlcode ;
1767: vp_errbuf := sqlerrm || ' [LOAD_FACTS_ATTRIBURES]' ;
1768: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
1769: -- fv_utility.debug_mesg('WHEN OTHERS'||vp_errbuf);
1770: return;
1771: End ;
1772:

Line 1877: -- fnd_file.put_line(fnd_file.log, vp_errbuf) ;

1873: When NO_DATA_FOUND then
1874: -- vp_retcode := -1 ;
1875: -- vp_errbuf := 'Error Getting BEA Category/Borrowing Source
1876: -- values [LOAD_FACTS_ATTRIBUTES]' ;
1877: -- fnd_file.put_line(fnd_file.log, vp_errbuf) ;
1878: -- -- fv_utility.debug_mesg('NO DATA FOUND'||vp_errbuf);
1879: -- return;
1880: va_bea_category_val := Null;
1881: va_borrowing_source_val := Null;

Line 1928: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

1924: When Others Then
1925: vp_retcode := sqlcode ;
1926: vp_errbuf := sqlerrm || ' [LOAD_FACTS_ATTRIBUTES]' ;
1927: -- fv_utility.debug_mesg('WHEN OTHERS'||vp_errbuf);
1928: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
1929:
1930: END LOAD_FACTS_ATTRIBUTES ;
1931:
1932:

Line 2012: --fnd_file.put_line(fnd_file.log, vp_errbuf) ;

2008: and id_flex_code = 'GL#'
2009: and id_flex_num = v_chart_of_accounts_id;
2010:
2011: --vp_errbuf := 'SGL Value Set Id :'||to_Char(vl_acc_val_set_id);
2012: --fnd_file.put_line(fnd_file.log, vp_errbuf) ;
2013:
2014: Exception
2015: When NO_DATA_FOUND Then
2016: vp_retcode := -1 ;

Line 2019: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

2015: When NO_DATA_FOUND Then
2016: vp_retcode := -1 ;
2017: vp_errbuf := 'Error getting Value Set Id for segment'
2018: ||v_acc_seg_name||' [GET_SGL_PARENT]' ;
2019: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
2020: -- fv_utility.debug_mesg('WHEN NO DATA FOUND'||vp_errbuf);
2021:
2022: return;
2023: End ; /* Value Set Id */

Line 2029: -- fnd_file.put_line(fnd_file.log, vp_errbuf) ;

2025: -- Finding the parent of the Account Number in GL
2026: Begin /* Finding Parent From GL */
2027: -- Finding the parent
2028: --vp_errbuf := 'SGL Parent Account Before:'||sgl_acct_num||'-'||acct_num;
2029: -- fnd_file.put_line(fnd_file.log, vp_errbuf) ;
2030: Select parent_flex_value
2031: Into sgl_acct_num
2032: From fnd_flex_value_hierarchies
2033: where (ACCT_NUM Between child_flex_value_low

Line 2043: --fnd_file.put_line(fnd_file.log, vp_errbuf) ;

2039: From fv_facts_ussgl_accounts
2040: Where ussgl_account = parent_flex_value);
2041:
2042: --vp_errbuf := 'SGL Parent Account:'||sgl_acct_num||'-'||acct_num;
2043: --fnd_file.put_line(fnd_file.log, vp_errbuf) ;
2044: Begin
2045: -- Look for parent in FV_FACTS_ATTRIBUTES table
2046: Select 'X'
2047: Into vl_exists

Line 2053: --fnd_file.put_line(fnd_file.log, vp_errbuf) ;

2049: where facts_acct_number = sgl_acct_num
2050: and set_of_books_id = vp_set_of_books_id;
2051:
2052: --vp_errbuf := 'SQL Account Exists:'||vl_exists;
2053: --fnd_file.put_line(fnd_file.log, vp_errbuf) ;
2054: -- Return the account Number
2055: Return ;
2056: Exception
2057: When NO_DATA_FOUND then

Line 2060: -- fnd_file.put_line(fnd_file.log, vp_errbuf) ;

2056: Exception
2057: When NO_DATA_FOUND then
2058: sgl_acct_num := NULL ;
2059: -- vp_errbuf := 'SGL NO DATA'||vl_exists;
2060: -- fnd_file.put_line(fnd_file.log, vp_errbuf) ;
2061: Return ;
2062: End ;
2063: Exception
2064: When NO_DATA_FOUND or TOO_MANY_ROWS Then

Line 2067: -- fnd_file.put_line(fnd_file.log, vp_errbuf) ;

2063: Exception
2064: When NO_DATA_FOUND or TOO_MANY_ROWS Then
2065: -- No Parent Exists or Too Many Parents. Return Nulls
2066: -- vp_errbuf := sqlerrm || ' [GET SGL ACCOUNT]' ;
2067: -- fnd_file.put_line(fnd_file.log, vp_errbuf) ;
2068: Return ;
2069: When OTHERS Then
2070: -- vp_errbuf := sqlerrm || ' [GET SGL ACCOUNT]' ;
2071: -- fnd_file.put_line(fnd_file.log, vp_errbuf) ;

Line 2071: -- fnd_file.put_line(fnd_file.log, vp_errbuf) ;

2067: -- fnd_file.put_line(fnd_file.log, vp_errbuf) ;
2068: Return ;
2069: When OTHERS Then
2070: -- vp_errbuf := sqlerrm || ' [GET SGL ACCOUNT]' ;
2071: -- fnd_file.put_line(fnd_file.log, vp_errbuf) ;
2072: Return;
2073: End ;
2074:
2075: End GET_SGL_PARENT ;

Line 2167: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

2163: EXCEPTION
2164: When Others Then
2165: vp_retcode := sqlcode ;
2166: vp_errbuf := sqlerrm || ' [CREATE_TBAL_RECORD] ' ;
2167: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
2168: -- fv_utility.debug_mesg('WHEN OTHERS'||vp_errbuf);
2169: return;
2170: END CREATE_TBAL_RECORD ;
2171:

Line 2753: fnd_file.put_line(fnd_file.log, vp_errbuf) ;

2749: EXCEPTION
2750: When Others Then
2751: vp_retcode := sqlcode ;
2752: vp_errbuf := sqlerrm || ' [GET_DOC_INFO] ' ;
2753: fnd_file.put_line(fnd_file.log, vp_errbuf) ;
2754: -- fv_utility.debug_mesg('WHEN OTHERS'||vp_errbuf);
2755: return;
2756: END GET_DOC_INFO;
2757: