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 FV_UTILITY

Line 237: -- fv_utility.debug_mesg('[TS MAIN]'||SQLERRM);

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:
241:

Line 243: -- fv_utility.debug_mesg('PURGING TEMP TABLE');

239: End ; -- TS
240:
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 ;

Line 250: -- fv_utility.debug_mesg('DERVING QUALIFIER');

246: PURGE_FACTS_TRANSACTIONS ;
247: End If ;
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 ;

Line 257: -- fv_utility.debug_mesg('GET COHORT INFO');

253: GET_QUALIFIER_SEGMENTS ;
254: End If ;
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 ;

Line 265: -- fv_utility.debug_mesg('GET PERIOD INFO');

261: End If ;
262:
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 ;

Line 272: -- fv_utility.debug_mesg('START MAIN PROCESS');

268: GET_PERIOD_INFO ;
269: End If ;
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;

Line 287: -- fv_utility.debug_mesg('WHEN OTHERS ERROR: IN [MAIN]'||SQLERRM||SQLCODE);

283:
284: EXCEPTION
285: -- Exception Processing
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 ;

Line 317: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN PURGE DATA:'||SQLERRM||SQLCODE);

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:
321: -- -------------------------------------------------------------------

Line 391: -- fv_utility.debug_mesg('ACCOUNT:'||v_acc_seg_Name||' BAL SEGMENT:'||v_bal_seg_name);

387:
388: v_acc_seg_name := upper(v_acc_seg_name) ;
389: v_bal_seg_name := upper(v_bal_seg_name) ;
390:
391: -- fv_utility.debug_mesg('ACCOUNT:'||v_acc_seg_Name||' BAL SEGMENT:'||v_bal_seg_name);
392:
393:
394: EXCEPTION
395: when invalid_segment then

Line 399: -- fv_utility.debug_mesg(' INVALID SEGMENT [GET_SEGMENT_INFO]');

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;
403:

Line 408: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN [GET_QUALIFIER_SEGMENT]'||SQLERRM);

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:
412: -- -------------------------------------------------------------------

Line 445: -- fv_utility.debug_mesg('NO DATA FOUND ERROR IN [GET PERIOD_INFO-1]');

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:
449: When TOO_MANY_ROWS Then

Line 454: -- fv_utility.debug_mesg('TOO MANY ROWS ERROR IN [GET PERIOD_INFO-1]');

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
458:

Line 464: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN [GET PERIOD_INFO-MAIN]'||SQLERRM);

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:
468:

Line 506: -- fv_utility.debug_mesg('NO DATA FOUND ERROR IN [GET_COHORT_INFO]'||SQLERRM);

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 ;
510: vp_errbuf := 'More than one Financing Account returned for the

Line 513: -- fv_utility.debug_mesg('TOO MANY ROWS ERROR IN [GET_COHORT_INFO]'||SQLERRM);

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 ;
517: vp_errbuf := 'WHEN OTHERS IN [GET_COHORT_INFO]'||SQLERRM;

Line 519: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN [GET_COHORT_INFO]'||SQLERRM);

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 ;
523:

Line 669: -- fv_utility.debug_mesg(' START MAIN PROCESS ');

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 ;
673: Exception

Line 678: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN MAIN CURSOR OPEN'||SQLERRM);

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:
682: If v_cohort_seg_name IS NOT NULL Then

Line 739: -- fv_utility.debug_mesg('ERROR IN MAIN CURSOR PARSE'||SQLERRM);

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 ;
743:

Line 757: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN MAIN CURSOR EXECUTE:'||SQLERRM);

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:
761: fnd_message.set_Name('FV', 'Processing starts.') ;

Line 781: -- fv_utility.debug_mesg(vp_errbuf);

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;
783: exit;
784: ELSE
785: vl_count := vl_count + 1;

Line 869: -- fv_utility.debug_mesg('Account:'||v_acct_num);

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);
872: -----------------------------------------------------------------------------
873: vl_attributes_found := 'N' ;

Line 870: -- fv_utility.debug_mesg('Fund Va:'||v_fund_val);

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);
872: -----------------------------------------------------------------------------
873: vl_attributes_found := 'N' ;
874:

Line 871: -- fv_utility.debug_mesg('Amount :'||vl_main_amount);

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);
872: -----------------------------------------------------------------------------
873: vl_attributes_found := 'N' ;
874:
875: RESET_ATTRIBUTES ;

Line 897: -- fv_utility.debug_mesg('NO PROBLEM*** GET PARENT ATTRIBUTES');

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

Line 912: -- fv_utility.debug_mesg(' IN RET CODE 2 *');

908: END IF;
909: End ;
910:
911: If vp_retcode <> 0 Then
912: -- fv_utility.debug_mesg('******** IN RET CODE 2 *********');
913: Return ;
914: End If ;
915:
916: -- Creating FACTS Record with Beginning Balance

Line 934: -- fv_utility.debug_mesg(' IN RET CODE 3 *');

930:
931: CREATE_TBAL_RECORD ;
932:
933: If vp_retcode <> 0 Then
934: -- fv_utility.debug_mesg('******** IN RET CODE 3 *********');
935: Return ;
936: End If ;
937:
938: End loop;

Line 957: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN SUB CURSOR OPEN'||SQLERRM);

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
961: vl_period_start_dt := to_char(vp_start_date,'DD-MON-YYYY');

Line 964: -- fv_utility.debug_mesg('PERIOD START DATE:'||vl_period_start_dt);

960: -- Change the Date format to have DD-MON-YYYY
961: vl_period_start_dt := to_char(vp_start_date,'DD-MON-YYYY');
962: vl_period_end_dt := to_char(vp_end_date,'DD-MON-YYYY');
963:
964: -- fv_utility.debug_mesg('PERIOD START DATE:'||vl_period_start_dt);
965: -- fv_utility.debug_mesg('PERIOD END DATE:'||vl_period_end_dt);
966:
967: /* This is the cursor we need to look into for the dates conflict */
968:

Line 965: -- fv_utility.debug_mesg('PERIOD END DATE:'||vl_period_end_dt);

961: vl_period_start_dt := to_char(vp_start_date,'DD-MON-YYYY');
962: vl_period_end_dt := to_char(vp_end_date,'DD-MON-YYYY');
963:
964: -- fv_utility.debug_mesg('PERIOD START DATE:'||vl_period_start_dt);
965: -- fv_utility.debug_mesg('PERIOD END DATE:'||vl_period_end_dt);
966:
967: /* This is the cursor we need to look into for the dates conflict */
968:
969: /* and glh.Je_Source = nvl(:vp_source,glh.Je_Source)

Line 1078: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN SUB CURSOR PARSE:'||SQLERRM);

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:
1082: dbms_sql.define_column(vl_legis_cursor, 1, p_je_header_id);

Line 1119: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN SUB CURSOR EXECUTE'||SQLERRM);

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;
1123: LOOP -- Innner Loop

Line 1154: -- fv_utility.debug_mesg('EXITING SUB LOOP');

1150:
1151: RESET_ATTRIBUTES ;
1152:
1153: IF dbms_sql.fetch_rows(vl_legis_cursor) = 0 then
1154: -- fv_utility.debug_mesg('***EXITING SUB LOOP***');
1155: exit;
1156: ELSE
1157: -- Fetch the Records into Variables
1158: dbms_sql.column_value(vl_legis_cursor, 1, p_je_header_id );

Line 1202: -- fv_utility.debug_mesg('NO PROBLEM*** GET PARENT ATTRIBUTES');

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

Line 1232: -- fv_utility.debug_mesg('Inside Amount:'||to_char(vl_legis_amount));

1228: else
1229: va_cohort := substr(vl_cohort_yr,1,2);
1230: End if;
1231:
1232: -- fv_utility.debug_mesg('Inside Amount:'||to_char(vl_legis_amount));
1233: -- fv_utility.debug_mesg('Cohort Year :'||vl_cohort_yr);
1234: -- Add the Code call the doc Info Procedure
1235: -- Create 2 new varbles to hold the info
1236: -- Reset the variables and finally add the variable to put in the temp table.

Line 1233: -- fv_utility.debug_mesg('Cohort Year :'||vl_cohort_yr);

1229: va_cohort := substr(vl_cohort_yr,1,2);
1230: End if;
1231:
1232: -- fv_utility.debug_mesg('Inside Amount:'||to_char(vl_legis_amount));
1233: -- fv_utility.debug_mesg('Cohort Year :'||vl_cohort_yr);
1234: -- Add the Code call the doc Info Procedure
1235: -- Create 2 new varbles to hold the info
1236: -- Reset the variables and finally add the variable to put in the temp table.
1237: -- bganesan

Line 1584: -- fv_utility.debug_mesg(' IN RET CODE 4 *');

1580:
1581: CREATE_TBAL_RECORD ;
1582:
1583: If vp_retcode <> 0 Then
1584: -- fv_utility.debug_mesg('******** IN RET CODE 4 *********');
1585: Return ;
1586: End If ;
1587: -------------- Normal Processing ----------------
1588: ELSE -- Legis Flag

Line 1606: -- fv_utility.debug_mesg(' IN RET CODE 5 *');

1602: */
1603:
1604: CREATE_TBAL_RECORD ;
1605: If vp_retcode <> 0 Then
1606: -- fv_utility.debug_mesg('******** IN RET CODE 5 *********');
1607: Return ;
1608: End If ;
1609: END IF; -- Legis Flag
1610: END LOOP; -- Inner Loop

Line 1611: -- fv_utility.debug_mesg('*DONE SUB LOOP **');

1607: Return ;
1608: End If ;
1609: END IF; -- Legis Flag
1610: END LOOP; -- Inner Loop
1611: -- fv_utility.debug_mesg('***DONE SUB LOOP ****');
1612: EXCEPTION
1613: -- Process any Exceptions in Legislative Indicator
1614: -- Processing
1615: When Others Then

Line 1620: -- fv_utility.debug_mesg('WHEN OTHERS IN SUB LOOP'||SQLERRM);

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: -----------------------------------------------------------------
1624: -- Submitting Transaction Registar Report

Line 1639: -- fv_utility.debug_mesg('Concurrent Request Id For FACTS Transaction

1635: v_pagebreak3,v_pagebreak3_low,v_pagebreak3_high,
1636: vp_currency_code) ;
1637:
1638: -- if concurrent request submission failed then abort process
1639: -- fv_utility.debug_mesg('Concurrent Request Id For FACTS Transaction
1640: -- Register Report : ' || vl_req_id);
1641:
1642: if vl_req_id = 0 then
1643: vp_errbuf := 'Error submitting Transaction Register Balance with Attributes Report ';

Line 1662: -- fv_utility.debug_mesg('WHEN OTHERS IN PROCESS TBAL TRANSACTION:'||SQLERRM);

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:
1666: -- -------------------------------------------------------------------

Line 1727: -- fv_utility.debug_mesg('ERROR NO DATA FOUND [LOAD_FACTS_ATTRIBUTES]'||vp_errbuf);

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 ;
1731: vp_errbuf := sqlerrm ;

Line 1733: -- fv_utility.debug_mesg('WHEN OTHERS ERROR IN [LOAD_FACTS_ATTRIBUTES]'||SQLERRM);

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:
1737:

Line 1762: -- fv_utility.debug_mesg('NO DATA FOUND '||vp_errbuf);

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
1766: vp_retcode := sqlcode ;

Line 1769: -- fv_utility.debug_mesg('WHEN OTHERS'||vp_errbuf);

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:
1773:

Line 1878: -- -- fv_utility.debug_mesg('NO DATA FOUND'||vp_errbuf);

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;
1882: End ;

Line 1927: -- fv_utility.debug_mesg('WHEN OTHERS'||vp_errbuf);

1923: EXCEPTION
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:

Line 2020: -- fv_utility.debug_mesg('WHEN NO DATA FOUND'||vp_errbuf);

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 */
2024:

Line 2168: -- fv_utility.debug_mesg('WHEN OTHERS'||vp_errbuf);

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:
2172: ----

Line 2500: fv_utility.debug_mesg(' Ref2 is NULL ...');

2496:
2497: --LGOEL: Added exception handler for statement below
2498: IF (p_reference2 is null) then
2499: IF (l_debug = 'Y') THEN
2500: fv_utility.debug_mesg(' Ref2 is NULL ...');
2501: END IF;
2502: lv_document_num := p_refer4;
2503: ELSE
2504: -- Bug 2532729 Start

Line 2528: fv_utility.debug_mesg(' Processing a Misc Receipt');

2524:
2525: IF (p_je_category_name = 'Misc Receipts')
2526: THEN
2527: IF (l_debug = 'Y') THEN
2528: fv_utility.debug_mesg(' Processing a Misc Receipt');
2529: END IF;
2530: p_refer2 := p_ref2;
2531: l_cash_receipt_hist_id := p_reference5;
2532: ELSE

Line 2534: fv_utility.debug_mesg(' Processing a Trade Receipt or Other');

2530: p_refer2 := p_ref2;
2531: l_cash_receipt_hist_id := p_reference5;
2532: ELSE
2533: IF (l_debug = 'Y') THEN
2534: fv_utility.debug_mesg(' Processing a Trade Receipt or Other');
2535: END IF;
2536: p_refer2 := p_reference2;
2537: l_cash_receipt_hist_id := SUBSTR(p_ref2, INSTR(p_ref2,'C')+1, LENGTH(p_ref2));
2538: END IF;

Line 2541: fv_utility.debug_mesg(' Cash receipt id = '||p_refer2);

2537: l_cash_receipt_hist_id := SUBSTR(p_ref2, INSTR(p_ref2,'C')+1, LENGTH(p_ref2));
2538: END IF;
2539:
2540: IF (l_debug = 'Y') THEN
2541: fv_utility.debug_mesg(' Cash receipt id = '||p_refer2);
2542: fv_utility.debug_mesg(' Cash receipt hist id = ' ||l_cash_receipt_hist_id);
2543: END IF;
2544:
2545: OPEN Receivables_Hist;

Line 2542: fv_utility.debug_mesg(' Cash receipt hist id = ' ||l_cash_receipt_hist_id);

2538: END IF;
2539:
2540: IF (l_debug = 'Y') THEN
2541: fv_utility.debug_mesg(' Cash receipt id = '||p_refer2);
2542: fv_utility.debug_mesg(' Cash receipt hist id = ' ||l_cash_receipt_hist_id);
2543: END IF;
2544:
2545: OPEN Receivables_Hist;
2546: FETCH Receivables_Hist INTO l_rev_exists;

Line 2571: fv_utility.debug_mesg(' Cash Receipt Hist Id exits in Ar_Cash_Receipt_History_All ... REVERSAL');

2567:
2568: IF (l_rev_exists = 'Y')
2569: THEN
2570: IF (l_debug = 'Y') THEN
2571: fv_utility.debug_mesg(' Cash Receipt Hist Id exits in Ar_Cash_Receipt_History_All ... REVERSAL');
2572: END IF;
2573: END IF;
2574: END IF;
2575:

Line 2588: fv_utility.debug_mesg(' Cash Receipt Hist Id exits in Ar_Receivable_Applications_All: ' ||l_cash_receipt_hist_id);

2584: THEN
2585: l_cash_receipt_hist_id := l_temp_cr_hist_id;
2586:
2587: IF (l_debug = 'Y') THEN
2588: fv_utility.debug_mesg(' Cash Receipt Hist Id exits in Ar_Receivable_Applications_All: ' ||l_cash_receipt_hist_id);
2589: END IF;
2590:
2591: -- Use cash_receipt_history_id obtained above to find if a row exits in Ar_Cash_Receipts_All
2592: OPEN Receivables_Exists;

Line 2599: fv_utility.debug_mesg(' Cash Receipt Hist Id exits in Ar_Cash_Receipt_History_All: ' ||l_cash_receipt_hist_id);

2595:
2596: IF (l_rev_exists = 'Y')
2597: THEN
2598: IF (l_debug = 'Y') THEN
2599: fv_utility.debug_mesg(' Cash Receipt Hist Id exits in Ar_Cash_Receipt_History_All: ' ||l_cash_receipt_hist_id);
2600: END IF;
2601:
2602: l_rev_exists := 'N';
2603:

Line 2612: fv_utility.debug_mesg(' Reversal Cash Receipt Hist Id exists ... REVERSAL');

2608:
2609: IF (l_rev_exists = 'Y')
2610: THEN
2611: IF (l_debug = 'Y') THEN
2612: fv_utility.debug_mesg(' Reversal Cash Receipt Hist Id exists ... REVERSAL');
2613: END IF;
2614: END IF;
2615:
2616: END IF;

Line 2629: fv_utility.debug_mesg(' Cash Receipt Hist Id exits in Ar_Misc_Cash_Distributions_All: ' ||l_cash_receipt_hist_id);

2625:
2626: IF (l_rev_exists = 'Y')
2627: THEN
2628: IF (l_debug = 'Y') THEN
2629: fv_utility.debug_mesg(' Cash Receipt Hist Id exits in Ar_Misc_Cash_Distributions_All: ' ||l_cash_receipt_hist_id);
2630: END IF;
2631:
2632: l_rev_exists := 'N';
2633:

Line 2642: fv_utility.debug_mesg(' Misc Cash Disc Id has Reverse value in created from ... REVERSAL');

2638:
2639: IF (l_rev_exists = 'Y')
2640: THEN
2641: IF (l_debug = 'Y') THEN
2642: fv_utility.debug_mesg(' Misc Cash Disc Id has Reverse value in created from ... REVERSAL');
2643: END IF;
2644: END IF;
2645:
2646: END IF;

Line 2706: -- fv_utility.debug_mesg('P_Doc_Num 11:'||lv_document_num);

2702: -- Check for values
2703: -- If not put default
2704:
2705: -- Test
2706: -- fv_utility.debug_mesg('P_Doc_Num 11:'||lv_document_num);
2707: -- fv_utility.debug_mesg('P_Doc_Date11:'||lv_Doc_Date);
2708: --
2709: IF lv_document_num IS NULL THEN
2710: lv_document_num := P_Name;

Line 2707: -- fv_utility.debug_mesg('P_Doc_Date11:'||lv_Doc_Date);

2703: -- If not put default
2704:
2705: -- Test
2706: -- fv_utility.debug_mesg('P_Doc_Num 11:'||lv_document_num);
2707: -- fv_utility.debug_mesg('P_Doc_Date11:'||lv_Doc_Date);
2708: --
2709: IF lv_document_num IS NULL THEN
2710: lv_document_num := P_Name;
2711: END IF;

Line 2734: -- fv_utility.debug_mesg('Je_Source_Name:'||P_Je_Source_Name);

2730: P_Doc_Date:= lv_Doc_Date;
2731: P_doc_created_by := lv_doc_created_by;
2732: P_doc_creation_date := lv_doc_creation_date ;
2733:
2734: -- fv_utility.debug_mesg('Je_Source_Name:'||P_Je_Source_Name);
2735: -- fv_utility.debug_mesg('Je_Category_Name:'||P_Je_Category_Name);
2736: -- fv_utility.debug_mesg('P_Reference1:'||P_Reference1);
2737: -- fv_utility.debug_mesg('P_Reference2:'||P_Reference2);
2738: -- fv_utility.debug_mesg('P_Reference3:'||P_Reference3);

Line 2735: -- fv_utility.debug_mesg('Je_Category_Name:'||P_Je_Category_Name);

2731: P_doc_created_by := lv_doc_created_by;
2732: P_doc_creation_date := lv_doc_creation_date ;
2733:
2734: -- fv_utility.debug_mesg('Je_Source_Name:'||P_Je_Source_Name);
2735: -- fv_utility.debug_mesg('Je_Category_Name:'||P_Je_Category_Name);
2736: -- fv_utility.debug_mesg('P_Reference1:'||P_Reference1);
2737: -- fv_utility.debug_mesg('P_Reference2:'||P_Reference2);
2738: -- fv_utility.debug_mesg('P_Reference3:'||P_Reference3);
2739: -- fv_utility.debug_mesg('P_Reference4:'||P_Reference4);

Line 2736: -- fv_utility.debug_mesg('P_Reference1:'||P_Reference1);

2732: P_doc_creation_date := lv_doc_creation_date ;
2733:
2734: -- fv_utility.debug_mesg('Je_Source_Name:'||P_Je_Source_Name);
2735: -- fv_utility.debug_mesg('Je_Category_Name:'||P_Je_Category_Name);
2736: -- fv_utility.debug_mesg('P_Reference1:'||P_Reference1);
2737: -- fv_utility.debug_mesg('P_Reference2:'||P_Reference2);
2738: -- fv_utility.debug_mesg('P_Reference3:'||P_Reference3);
2739: -- fv_utility.debug_mesg('P_Reference4:'||P_Reference4);
2740: -- fv_utility.debug_mesg('P_Reference5:'||P_Reference5);+

Line 2737: -- fv_utility.debug_mesg('P_Reference2:'||P_Reference2);

2733:
2734: -- fv_utility.debug_mesg('Je_Source_Name:'||P_Je_Source_Name);
2735: -- fv_utility.debug_mesg('Je_Category_Name:'||P_Je_Category_Name);
2736: -- fv_utility.debug_mesg('P_Reference1:'||P_Reference1);
2737: -- fv_utility.debug_mesg('P_Reference2:'||P_Reference2);
2738: -- fv_utility.debug_mesg('P_Reference3:'||P_Reference3);
2739: -- fv_utility.debug_mesg('P_Reference4:'||P_Reference4);
2740: -- fv_utility.debug_mesg('P_Reference5:'||P_Reference5);+
2741: -- fv_utility.debug_mesg('P_Name:'||P_Name);

Line 2738: -- fv_utility.debug_mesg('P_Reference3:'||P_Reference3);

2734: -- fv_utility.debug_mesg('Je_Source_Name:'||P_Je_Source_Name);
2735: -- fv_utility.debug_mesg('Je_Category_Name:'||P_Je_Category_Name);
2736: -- fv_utility.debug_mesg('P_Reference1:'||P_Reference1);
2737: -- fv_utility.debug_mesg('P_Reference2:'||P_Reference2);
2738: -- fv_utility.debug_mesg('P_Reference3:'||P_Reference3);
2739: -- fv_utility.debug_mesg('P_Reference4:'||P_Reference4);
2740: -- fv_utility.debug_mesg('P_Reference5:'||P_Reference5);+
2741: -- fv_utility.debug_mesg('P_Name:'||P_Name);
2742: -- fv_utility.debug_mesg('P_Date:'||P_Date);

Line 2739: -- fv_utility.debug_mesg('P_Reference4:'||P_Reference4);

2735: -- fv_utility.debug_mesg('Je_Category_Name:'||P_Je_Category_Name);
2736: -- fv_utility.debug_mesg('P_Reference1:'||P_Reference1);
2737: -- fv_utility.debug_mesg('P_Reference2:'||P_Reference2);
2738: -- fv_utility.debug_mesg('P_Reference3:'||P_Reference3);
2739: -- fv_utility.debug_mesg('P_Reference4:'||P_Reference4);
2740: -- fv_utility.debug_mesg('P_Reference5:'||P_Reference5);+
2741: -- fv_utility.debug_mesg('P_Name:'||P_Name);
2742: -- fv_utility.debug_mesg('P_Date:'||P_Date);
2743: -- fv_utility.debug_mesg('P_Doc_Num:'||P_Doc_Num);

Line 2740: -- fv_utility.debug_mesg('P_Reference5:'||P_Reference5);+

2736: -- fv_utility.debug_mesg('P_Reference1:'||P_Reference1);
2737: -- fv_utility.debug_mesg('P_Reference2:'||P_Reference2);
2738: -- fv_utility.debug_mesg('P_Reference3:'||P_Reference3);
2739: -- fv_utility.debug_mesg('P_Reference4:'||P_Reference4);
2740: -- fv_utility.debug_mesg('P_Reference5:'||P_Reference5);+
2741: -- fv_utility.debug_mesg('P_Name:'||P_Name);
2742: -- fv_utility.debug_mesg('P_Date:'||P_Date);
2743: -- fv_utility.debug_mesg('P_Doc_Num:'||P_Doc_Num);
2744: -- fv_utility.debug_mesg('P_Doc_Date:'||P_Doc_Date);

Line 2741: -- fv_utility.debug_mesg('P_Name:'||P_Name);

2737: -- fv_utility.debug_mesg('P_Reference2:'||P_Reference2);
2738: -- fv_utility.debug_mesg('P_Reference3:'||P_Reference3);
2739: -- fv_utility.debug_mesg('P_Reference4:'||P_Reference4);
2740: -- fv_utility.debug_mesg('P_Reference5:'||P_Reference5);+
2741: -- fv_utility.debug_mesg('P_Name:'||P_Name);
2742: -- fv_utility.debug_mesg('P_Date:'||P_Date);
2743: -- fv_utility.debug_mesg('P_Doc_Num:'||P_Doc_Num);
2744: -- fv_utility.debug_mesg('P_Doc_Date:'||P_Doc_Date);
2745: -- fv_utility.debug_mesg('********************************');

Line 2742: -- fv_utility.debug_mesg('P_Date:'||P_Date);

2738: -- fv_utility.debug_mesg('P_Reference3:'||P_Reference3);
2739: -- fv_utility.debug_mesg('P_Reference4:'||P_Reference4);
2740: -- fv_utility.debug_mesg('P_Reference5:'||P_Reference5);+
2741: -- fv_utility.debug_mesg('P_Name:'||P_Name);
2742: -- fv_utility.debug_mesg('P_Date:'||P_Date);
2743: -- fv_utility.debug_mesg('P_Doc_Num:'||P_Doc_Num);
2744: -- fv_utility.debug_mesg('P_Doc_Date:'||P_Doc_Date);
2745: -- fv_utility.debug_mesg('********************************');
2746:

Line 2743: -- fv_utility.debug_mesg('P_Doc_Num:'||P_Doc_Num);

2739: -- fv_utility.debug_mesg('P_Reference4:'||P_Reference4);
2740: -- fv_utility.debug_mesg('P_Reference5:'||P_Reference5);+
2741: -- fv_utility.debug_mesg('P_Name:'||P_Name);
2742: -- fv_utility.debug_mesg('P_Date:'||P_Date);
2743: -- fv_utility.debug_mesg('P_Doc_Num:'||P_Doc_Num);
2744: -- fv_utility.debug_mesg('P_Doc_Date:'||P_Doc_Date);
2745: -- fv_utility.debug_mesg('********************************');
2746:
2747:

Line 2744: -- fv_utility.debug_mesg('P_Doc_Date:'||P_Doc_Date);

2740: -- fv_utility.debug_mesg('P_Reference5:'||P_Reference5);+
2741: -- fv_utility.debug_mesg('P_Name:'||P_Name);
2742: -- fv_utility.debug_mesg('P_Date:'||P_Date);
2743: -- fv_utility.debug_mesg('P_Doc_Num:'||P_Doc_Num);
2744: -- fv_utility.debug_mesg('P_Doc_Date:'||P_Doc_Date);
2745: -- fv_utility.debug_mesg('********************************');
2746:
2747:
2748:

Line 2745: -- fv_utility.debug_mesg('********************************');

2741: -- fv_utility.debug_mesg('P_Name:'||P_Name);
2742: -- fv_utility.debug_mesg('P_Date:'||P_Date);
2743: -- fv_utility.debug_mesg('P_Doc_Num:'||P_Doc_Num);
2744: -- fv_utility.debug_mesg('P_Doc_Date:'||P_Doc_Date);
2745: -- fv_utility.debug_mesg('********************************');
2746:
2747:
2748:
2749: EXCEPTION

Line 2754: -- fv_utility.debug_mesg('WHEN OTHERS'||vp_errbuf);

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:
2758: -- -------------------------------------------------------------------