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_GTAS_TRX_REGISTER dependencies on FND_LOG

Line 520: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

516: EXCEPTION
517: WHEN OTHERS THEN
518: g_error_buf := SQLERRM;
519: g_error_code := -1;
520: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
521: l_module||'.final_exception',g_error_buf);
522:
523: END check_prc_map_seg;
524: -------------------------------------------------------------------------------

Line 784: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,p_errbuf);

780: */
781: ELSE
782: p_retcode := 1;
783: p_errbuf := '** No Data Found for the Transaction Register Process **';
784: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,p_errbuf);
785: log(l_module, p_errbuf);
786: RETURN;
787: END IF;
788: END;

Line 806: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,p_errbuf);

802: p_errbuf := 'Transaction Register Process completed with warning
803: because the Public Law, Advance,
804: and Transfer attribute columns are not established on
805: the Define System Parameters Form.';
806: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,p_errbuf);
807: log(l_module, l_module||' '||p_errbuf);
808: COMMIT;
809: RETURN;
810: ELSE

Line 813: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

809: RETURN;
810: ELSE
811: p_retcode := 0;
812: p_errbuf := '** Transaction Register Process completed Successfully **';
813: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
814: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module,p_errbuf);
815: log(l_module, l_module||' '||p_errbuf);
816: END IF;
817: COMMIT;

Line 814: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module,p_errbuf);

810: ELSE
811: p_retcode := 0;
812: p_errbuf := '** Transaction Register Process completed Successfully **';
813: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
814: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module,p_errbuf);
815: log(l_module, l_module||' '||p_errbuf);
816: END IF;
817: COMMIT;
818: RETURN;

Line 829: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

825: p_errbuf := '** Transaction Register Process Failed ** '||SQLERRM;
826: p_retcode := 2;
827: ROLLBACK;
828: log(l_module, l_module||' .final_exception'||g_error_buf);
829: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
830: l_module||'.final_exception',g_error_buf);
831: END main;
832:
833: -- ------------------------------------------------------------------

Line 860: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);

856: WHEN NO_DATA_FOUND THEN
857: g_error_code := 2;
858: g_error_buf := 'Period Set name not found for set of books '
859: ||to_char(g_set_of_books_id);
860: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);
861: RETURN;
862: WHEN OTHERS THEN
863: g_error_code := SQLCODE ;
864: g_error_buf := SQLERRM ||

Line 867: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);

863: g_error_code := SQLCODE ;
864: g_error_buf := SQLERRM ||
865: ' -- Error in Get_Period_Year procedure,while getting the '
866: ||'period set name.' ;
867: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);
868: RETURN;
869: END;
870:
871: BEGIN

Line 883: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);

879: g_error_code := 2;
880: g_error_buf := 'Period Year not found for the set of books '
881: ||to_char(g_set_of_books_id) ||
882: ' and the period set name '||l_period_set_name;
883: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);
884: RETURN;
885: WHEN OTHERS THEN
886: g_error_code := SQLCODE ;
887: g_error_buf := SQLERRM ||

Line 890: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);

886: g_error_code := SQLCODE ;
887: g_error_buf := SQLERRM ||
888: ' -- Error in Get_Period_Year procedure,'||
889: ' while getting the period year.' ;
890: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);
891: RETURN;
892: END;
893:
894: log(l_module,'Period Year: '||G_PERIOD_YEAR);

Line 909: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);

905: WHEN NO_DATA_FOUND THEN
906: g_error_code := 2;
907: g_error_buf := 'Start Date not defined for the period name '
908: ||p_period_from;
909: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);
910: RETURN;
911: WHEN OTHERS THEN
912: g_error_code := SQLCODE ;
913: g_error_buf := SQLERRM ||

Line 917: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);

913: g_error_buf := SQLERRM ||
914: ' -- Error in Get_Period_Year procedure, '||
915: 'while getting the start date for the from period '
916: ||p_period_from ;
917: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);
918: RETURN;
919: END;
920:
921: -- From Period Start Date

Line 937: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);

933: WHEN NO_DATA_FOUND THEN
934: g_error_code := 2;
935: g_error_buf := 'End Date not defined for the period name '
936: ||p_period_to;
937: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);
938: RETURN;
939: WHEN OTHERS THEN
940: g_error_code := SQLCODE ;
941: g_error_buf := SQLERRM ||

Line 945: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);

941: g_error_buf := SQLERRM ||
942: ' -- Error in Get_Period_Year procedure, '||
943: 'while getting the end date for the to period '||
944: p_period_to ;
945: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);
946: RETURN;
947: END; -- To Period End Date
948:
949: -- Setting up the retcode

Line 957: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||

953: WHEN OTHERS THEN
954: g_error_code := SQLCODE ;
955: g_error_buf := SQLERRM ||
956: ' -- Error in Get_Period_Year procedure.' ;
957: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||
958: '.final_exception',g_error_buf);
959: RETURN;
960: END get_period_year;
961:

Line 990: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);

986: g_error_code := 2;
987: g_error_buf := 'PROCESS PERIOD INFO - period_num corresponding '||
988: 'to From Period Name ' || g_from_period_name ||
989: ' not found.';
990: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);
991: RETURN;
992: WHEN OTHERS THEN
993: g_error_code := SQLCODE ;
994: g_error_buf := SQLERRM ||

Line 998: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);

994: g_error_buf := SQLERRM ||
995: 'PROCESS PERIOD INFO - Error when getting '||
996: 'min(period_num) from gl_period_statuses '||
997: 'for From Period Name '|| g_from_period_name;
998: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);
999: RETURN;
1000: END;
1001:
1002: BEGIN

Line 1016: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);

1012: g_error_code := 2;
1013: g_error_buf := 'PROCESS PERIOD INFO - period corresponding '||
1014: 'to To Period Name ' || g_to_period_name ||
1015: ' not found.';
1016: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);
1017: RETURN;
1018: WHEN OTHERS THEN
1019: g_error_code := SQLCODE ;
1020: g_error_buf := SQLERRM ||

Line 1024: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);

1020: g_error_buf := SQLERRM ||
1021: 'PROCESS PERIOD INFO - Error when getting '||
1022: 'max(period_num) from gl_period_statuses for '||
1023: 'To Period Name '|| g_to_period_name;
1024: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);
1025: RETURN;
1026: END;
1027: -- END IF;
1028: -- Setting up the retcode

Line 1035: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.final_exception',g_error_buf);

1031: WHEN OTHERS THEN
1032: g_error_code := SQLCODE ;
1033: g_error_buf := SQLERRM ||
1034: ' -- Error in Process_Period_Info procedure.' ;
1035: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.final_exception',g_error_buf);
1036: RETURN;
1037: END process_period_info;
1038: -- -------------------------------------------------------------
1039: -- PROCEDURE GET QUALIFIER SEGMENTS

Line 1062: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);

1058: );
1059:
1060: IF (l_error_code) THEN
1061: g_error_code := 2 ;
1062: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);
1063: RETURN;
1064: END IF;
1065:
1066: log(l_module,'Balancing segment: '||G_BAL_SEGMENT_NAME);

Line 1084: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);

1080: EXCEPTION
1081: WHEN NO_DATA_FOUND THEN
1082: g_error_code := 2 ;
1083: g_error_buf := 'GET QUALIFIER SEGMENTS - flex_value_set_id not found';
1084: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);
1085: RETURN;
1086: WHEN TOO_MANY_ROWS THEN
1087: g_error_code := 2 ;
1088: g_error_buf := 'GET QUALIFIER SEGMENTS - More than one ' ||

Line 1090: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);

1086: WHEN TOO_MANY_ROWS THEN
1087: g_error_code := 2 ;
1088: g_error_buf := 'GET QUALIFIER SEGMENTS - More than one ' ||
1089: 'row returned while getting flex_value_set_id';
1090: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);
1091: RETURN;
1092: WHEN OTHERS THEN
1093: g_error_code := SQLCODE;
1094: g_error_buf := SQLERRM ||

Line 1097: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);

1093: g_error_code := SQLCODE;
1094: g_error_buf := SQLERRM ||
1095: '-- GET QUALIFIER SEGMENTS Error '||
1096: 'when getting acct_value_set_id';
1097: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);
1098: RETURN;
1099: END;
1100:
1101: -- Setting up the retcode

Line 1109: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

1105: WHEN OTHERS THEN
1106: g_error_code := SQLCODE ;
1107: g_error_buf := SQLERRM ||
1108: ' -- Error in Get_QualIFier_Segments procedure.' ;
1109: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
1110: l_module||'.final_exception',g_error_buf);
1111: RETURN;
1112: END get_qualifier_segments;
1113:

Line 1425: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

1421: EXCEPTION
1422: WHEN NO_DATA_FOUND THEN
1423: log(l_module, 'Please set up the Budget Fiscal Year
1424: Segment Mapping for period year '||g_period_year);
1425: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
1426: 'Please set up the Budget Fiscal Year Segment
1427: Mapping for period year '||g_period_year);
1428: RAISE;
1429: END;

Line 1452: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);

1448: WHEN NO_DATA_FOUND THEN
1449: g_error_code := -1;
1450: g_error_buf := l_module||' - When no data found error: '||SQLERRM;
1451: log(l_module, l_module||' '||g_error_buf);
1452: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);
1453: return;
1454:
1455: WHEN OTHERS THEN
1456: g_error_code := -1;

Line 1459: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);

1455: WHEN OTHERS THEN
1456: g_error_code := -1;
1457: g_error_buf := l_module||' - When others error: '||SQLERRM;
1458: log(l_module, l_module||' '||g_error_buf);
1459: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);
1460: RETURN;
1461: END LOAD_GTAS_ATTRIBUTES ;
1462: -- -------------------------------------------------------------------
1463: -- PROCEDURE JOURNAL_PROCESS

Line 1617: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);

1613: g_error_buf := SQLERRM ||
1614: ' -- Error in Journal_Process'||
1615: ' procedure due to Open_Cursor.';
1616: log(l_module, l_module||g_error_buf);
1617: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);
1618: RETURN;
1619: END;
1620: BEGIN
1621: SELECT 'X', factsI_journal_attribute,

Line 1665: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);

1661: g_error_buf := 'Error in Journal_Process procedure - Journal '||
1662: 'Trading Partner and other Parameters not '||
1663: 'defined on System Parameter form';
1664: log(l_module, l_module||g_error_buf);
1665: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,g_error_buf);
1666: RETURN;
1667: WHEN OTHERS THEN
1668: g_error_code := SQLCODE;
1669: g_error_buf := SQLERRM ||

Line 1672: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);

1668: g_error_code := SQLCODE;
1669: g_error_buf := SQLERRM ||
1670: ' -- Error in Journal_Process procedure.' ;
1671: log(l_module, l_module||g_error_buf);
1672: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);
1673: RETURN;
1674: END;
1675:
1676: -- Get cohort Info

Line 1707: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.select1',g_error_buf);

1703: WHEN Others THEN
1704: g_error_code := SQLCODE;
1705: g_error_buf := SQLERRM ;
1706: log(l_module, l_module||'.select1'||g_error_buf);
1707: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.select1',g_error_buf);
1708: RETURN;
1709: End;
1710:
1711: -- Load segments array table

Line 1919: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.select1',g_error_buf);

1915: g_error_buf := SQLERRM ||
1916: ' -- Error in Journal_Process procedure due '||
1917: 'to cursor Parse.';
1918: log(l_module, l_module||'.select1'||g_error_buf);
1919: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.select1',g_error_buf);
1920: RETURN;
1921: END;
1922:
1923: -- Bind the variables

Line 2080: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.message1',G_ERROR_BUF);

2076: g_error_code := SQLCODE;
2077: g_error_buf := SQLERRM ||
2078: ' -- Error in Journal_Process procedure due '||
2079: 'to cursor Execute.';
2080: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.message1',G_ERROR_BUF);
2081: RETURN;
2082: END;
2083: i := 0;
2084: LOOP

Line 2928: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,

2924: EXCEPTION
2925: WHEN NO_DATA_FOUND THEN
2926: log(l_module,'.select_1: NO DATA FOUND !!');
2927: WHEN INVALID_NUMBER THEN
2928: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,
2929: 'Invalid Number passed to REFERENCE_2');
2930: END;
2931: ELSE
2932: log(l_module,' REFERENCE_2 I.E. INVOICE_ID IS NULL');

Line 2966: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,

2962: ' is Purchasing and category'||
2963: ' is Receiving!!');
2964:
2965: WHEN INVALID_NUMBER THEN
2966: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,
2967: 'Invalid Number passed to REFERENCE_5');
2968: END;
2969: ELSE
2970: IF (l_reference_2 IS NULL) THEN

Line 2999: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,

2995: log(l_module,'NO DATA FOUND WHEN SOURCE IS'||
2996: ' Purchasing and category'||
2997: ' is Purchases!!');
2998: WHEN INVALID_NUMBER THEN
2999: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,
3000: 'Invalid Number passed to REFERENCE_2');
3001: END;
3002: ELSE
3003: log(l_module, 'REFERENCE_2 I.E. PO HEADER ID is NULL');

Line 3080: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,

3076: WHEN NO_DATA_FOUND THEN
3077: log(l_module||'.message_22',' NO DATA FOUND !!');
3078:
3079: WHEN INVALID_NUMBER THEN
3080: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module,
3081: 'Invalid Number passed to REFERENCE_3');
3082: END;
3083: ELSE
3084: log(l_module,'REFERENCE_3 I.E. CHECK_ID IS NULL');

Line 3292: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.final_exception',g_error_buf);

3288: g_error_code := 2 ;
3289: g_error_buf := 'JOURNAL PROCESSES - Exception Main (Others) - ' ||
3290: to_char(sqlcode) || ' - ' || SQLERRM;
3291: log(l_module, l_module||'.final_exception'||' '||g_error_buf);
3292: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.final_exception',g_error_buf);
3293: END JOURNAL_PROCESS;
3294: -- -------------------------------------------------------------------
3295: -- PROCEDURE GET_DOC_INFO
3296: -- -------------------------------------------------------------------

Line 4239: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

4235: WHEN OTHERS THEN
4236: g_error_code := SQLCODE;
4237: g_error_buf := SQLERRM ||
4238: ' Error in Get_Doc_Info Procedure.' ;
4239: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
4240: l_module||'.final_exception',g_error_buf);
4241: RETURN;
4242: END GET_DOC_INFO;
4243: -- -------------------------------------------------------------------

Line 4278: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||

4274: WHEN OTHERS THEN
4275: g_error_code := SQLCODE ;
4276: g_error_buf := SQLERRM ||
4277: ' -- Error in Get_Doc_User procedure.' ;
4278: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||
4279: '.final_exception',g_error_buf);
4280: RETURN;
4281: END GET_DOC_USER;
4282: -- -------------------------------------------------------------------

Line 4355: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

4351: EXCEPTION
4352: WHEN OTHERS THEN
4353: g_error_code := SQLCODE ;
4354: g_error_buf := SQLERRM;
4355: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
4356: l_module||'.final_exception',g_error_buf);
4357: RAISE;
4358:
4359: END reset_gtas_attributes ;

Line 4393: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

4389: p_reporting_type := NULL;
4390: WHEN OTHERS THEN
4391: g_error_code := sqlcode ;
4392: g_error_buf := sqlerrm ;
4393: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
4394: l_module||'.final_exception',g_error_buf);
4395: RETURN ;
4396: END get_ussgl_info ;
4397: -- --------------------------------------------------------------------

Line 4461: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

4457: NULL;
4458: WHEN OTHERS THEN
4459: g_error_code := sqlcode;
4460: g_error_buf := sqlerrm;
4461: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
4462: l_module||'.exception_1',g_error_buf);
4463: END;
4464:
4465: IF (l_row_exists IS NULL)

Line 4486: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

4482: WHEN NO_DATA_FOUND THEN NULL;
4483: WHEN OTHERS THEN
4484: g_error_code := sqlcode;
4485: g_error_buf := sqlerrm;
4486: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
4487: l_module||'.exception_2',g_error_buf);
4488: END;
4489: EXCEPTION
4490: WHEN OTHERS THEN

Line 4508: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

4504: DBMS_SQL.CLOSE_CURSOR(l_fund_cursor);
4505: g_error_code := 2 ;
4506: g_error_buf := 'GET FUND GROUP INFO - Exception (Others) - ' ||
4507: to_char(sqlcode) || ' - ' || sqlerrm ;
4508: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
4509: l_module||'.final_exception',g_error_buf);
4510: END get_fund_group_info ;
4511: -- --------------------------------------------------------------------
4512: -- PROCEDURE POPULATE_TABLE

Line 4692: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.final_exception',g_error_buf);

4688: EXCEPTION
4689: WHEN OTHERS THEN
4690: g_error_code := SQLCODE ;
4691: g_error_buf := 'POPULATE TABLE procedure, Error Occured -- ' || SQLERRM;
4692: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module||'.final_exception',g_error_buf);
4693: log(l_module, l_module||'.final_exception '||g_error_buf);
4694: END populate_table;
4695: -- -------------------------------------------------------------------
4696: -- PROCEDURE PURGE_GTAS_TRANSACTIONS

Line 4716: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

4712: WHEN OTHERS THEN
4713: g_error_code := sqlcode ;
4714: g_error_buf := sqlerrm ||
4715: 'PURGE DATA';
4716: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
4717: l_module||'.final_exception',g_error_buf);
4718: log(l_module, l_module||'.final_exception '||g_error_buf);
4719: RETURN ;
4720: END purge_gtas_transactions ;

Line 4783: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

4779: RETURN ;
4780: WHEN OTHERS THEN
4781: g_error_code := SQLCODE ;
4782: g_error_buf := SQLERRM;
4783: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
4784: l_module||'.final_exception',g_error_buf);
4785: RETURN;
4786: END;
4787: log(l_module, 'End');

Line 4836: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

4832: WHEN NO_DATA_FOUND THEN
4833: g_error_code := -1 ;
4834: g_error_buf := 'No Financing Account found for
4835: the passed Treasury Symbol [GET_COHORT_INFO] ' ;
4836: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
4837: l_module||'.exception1',g_error_buf);
4838: RETURN;
4839: WHEN TOO_MANY_ROWS THEN
4840: g_error_code := -1 ;

Line 4843: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

4839: WHEN TOO_MANY_ROWS THEN
4840: g_error_code := -1 ;
4841: g_error_buf := 'More than one Financing Account
4842: returned for the passed Treasury Symbol [GET_COHORT_INFO]' ;
4843: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
4844: l_module||'.exception2',g_error_buf);
4845: RETURN;
4846: WHEN OTHERS THEN
4847: g_error_code := SQLCODE ;

Line 4849: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

4845: RETURN;
4846: WHEN OTHERS THEN
4847: g_error_code := SQLCODE ;
4848: g_error_buf := 'WHEN OTHERS IN [GET_COHORT_INFO]'||SQLERRM;
4849: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
4850: l_module||'.final_exception',g_error_buf);
4851: RETURN;
4852: END get_cohort_info ;
4853: --------------------------------------------------------------------------------

Line 5095: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

5091: EXCEPTION
5092: WHEN OTHERS THEN
5093: g_error_buf := SQLERRM;
5094: g_error_code := -1;
5095: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
5096: l_module||'.final_exception',g_error_buf);
5097: log(l_module, l_module||'.final_exception '||g_error_buf);
5098: END group_po_rec_lines ;
5099:

Line 5138: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

5134: WHEN OTHERS THEN
5135: g_error_buf := SQLERRM;
5136: g_error_code := -1;
5137: log(l_module, l_module||' .final_exception'||g_error_buf);
5138: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
5139: l_module||'.final_exception',g_error_buf);
5140: END get_trx_part_from_reimb;
5141:
5142: --------------------------------------------------------------------------------

Line 5185: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

5181: g_error_buf := SQLERRM;
5182: g_error_code := -1;
5183: log(l_module, l_module||' .final_exception'||
5184: g_error_buf);
5185: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
5186: l_module||'.final_exception',g_error_buf);
5187: END get_fnf_from_reimb;
5188:
5189: --------------------------------------------------------------------------------

Line 5380: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

5376: EXCEPTION
5377: WHEN OTHERS THEN
5378: g_error_buf := SQLERRM;
5379: g_error_code := -1;
5380: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
5381: l_module||'.final_exception',g_error_buf);
5382: log(l_module, l_module||'.final_exception '||g_error_buf);
5383: END group_payables_lines;
5384: --------------------------------------------------------------------------------

Line 5388: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5384: --------------------------------------------------------------------------------
5385: PROCEDURE LOG(module IN VARCHAR2, message_line IN VARCHAR2) IS
5386:
5387: BEGIN
5388: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5389: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, module, message_line);
5390: END IF;
5391: EXCEPTION
5392: WHEN OTHERS THEN

Line 5389: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, module, message_line);

5385: PROCEDURE LOG(module IN VARCHAR2, message_line IN VARCHAR2) IS
5386:
5387: BEGIN
5388: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5389: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, module, message_line);
5390: END IF;
5391: EXCEPTION
5392: WHEN OTHERS THEN
5393: FV_UTILITY.LOG_MESG('When others error in module: log: '||sqlerrm);

Line 5430: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

5426: EXCEPTION
5427: WHEN OTHERS THEN
5428: g_error_buf := SQLERRM;
5429: g_error_code := -1;
5430: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
5431: l_module||g_error_buf);
5432: log(l_module, l_module||g_error_buf);
5433: END BUILD_WHERE_CLAUSES;
5434: --------------------------------------------------------------------------------

Line 5889: FV_UTILITY.LOG_MESG (FND_LOG.LEVEL_ERROR, l_module,g_error_buf);

5885: log(l_module,'End: ');
5886: EXCEPTION WHEN OTHERS THEN
5887: g_error_code := SQLCODE;
5888: g_error_buf := l_module||' - When others error: '||SQLERRM;
5889: FV_UTILITY.LOG_MESG (FND_LOG.LEVEL_ERROR, l_module,g_error_buf);
5890: END GET_AUTHORITY_TYPE_CODE;
5891: --------------------------------------------------------------------------------
5892: PROCEDURE GET_BUDGET_IMPACT_IND(p_je_batch_id IN NUMBER,
5893: p_je_header_id IN NUMBER,

Line 6022: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);

6018: WHEN Others THEN
6019: g_error_code := -1 ;
6020: g_error_buf := l_module||' - When others exception - ' ||
6021: TO_CHAR(SQLCODE) || ' - ' ||SQLERRM ;
6022: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);
6023: END get_account_type;
6024: --------------------------------------------------------------------------------
6025: BEGIN
6026: g_module := 'fv.plsql.FV_GTAS_TRX_REGISTER.';