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

Line 57: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);

53: v_beg_bal_sggl_acc := NULL;
54: EXCEPTION
55: WHEN OTHERS THEN
56: v_log_text := SQLERRM;
57: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);
58: RAISE;
59:
60: END init_vars;
61:

Line 113: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);

109:
110: EXCEPTION WHEN OTHERS THEN
111: v_log_text := SQLERRM;
112: g_error_flag := 2;
113: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);
114: END; --edit_check_1
115:
116:
117: PROCEDURE edit_check_2 IS

Line 321: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);

317:
318: EXCEPTION WHEN OTHERS THEN
319: v_log_text := SQLERRM;
320: g_error_flag := 2;
321: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);
322: END; --edit_check_2
323:
324:
325: PROCEDURE edit_check_3 IS

Line 376: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);

372:
373: EXCEPTION WHEN OTHERS THEN
374: v_log_text := SQLERRM;
375: g_error_flag := 2;
376: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);
377: END; --edit_check_3
378:
379:
380: PROCEDURE edit_check_4 IS

Line 444: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);

440:
441: EXCEPTION WHEN OTHERS THEN
442: v_log_text := SQLERRM;
443: g_error_flag := 2;
444: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);
445: END; --edit_check_4
446:
447: PROCEDURE edit_check_5 IS
448: l_module_name VARCHAR2(200) := g_module_name || 'edit_check_5';

Line 504: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);

500:
501: EXCEPTION WHEN OTHERS THEN
502: v_log_text := SQLERRM;
503: g_error_flag := 2;
504: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);
505: END; --edit_check_5
506:
507:
508: PROCEDURE edit_check_6 (p_ledger_id NUMBER) IS

Line 600: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);

596:
597: EXCEPTION WHEN OTHERS THEN
598: v_log_text := SQLERRM;
599: g_error_flag := 2;
600: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);
601: END; --edit_check_6
602:
603:
604: PROCEDURE edit_check_7 IS

Line 668: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);

664:
665: EXCEPTION WHEN OTHERS THEN
666: v_log_text := SQLERRM;
667: g_error_flag := 2;
668: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);
669: END; -- edit_check_7
670:
671: PROCEDURE edit_check_8 IS
672: l_module_name VARCHAR2(200) := g_module_name || 'edit_check_8';

Line 948: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);

944: EXCEPTION
945: WHEN OTHERS THEN
946: v_log_text := SQLERRM;
947: g_error_flag := 2;
948: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);
949: END; --edit_check_8
950:
951: --CGAC ER
952: PROCEDURE edit_check_9(g_facts_run_quarter IN number) IS

Line 1043: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

1039:
1040: EXCEPTION WHEN OTHERS THEN
1041: v_log_text := SQLERRM;
1042: g_error_flag := 2;
1043: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
1044: l_module_name||'.final_exception',v_log_text);
1045: END; --edit_check_9
1046:
1047: -- Added the foll to fix bug 1974485

Line 1091: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);

1087:
1088: EXCEPTION WHEN OTHERS THEN
1089: v_log_text := SQLERRM;
1090: g_error_flag := 2;
1091: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);
1092: END; --edit_check_10
1093:
1094: PROCEDURE edit_check_11 IS
1095: l_module_name VARCHAR2(200) := g_module_name || 'edit_check_11';

Line 1271: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);

1267: v_log_text := SQLERRM;
1268: IF (g_error_flag = 0) THEN
1269: g_error_flag := 1;
1270: END IF;
1271: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);
1272: END; --edit_check_11
1273:
1274:
1275: PROCEDURE edit_check_12(p_facts_run_quarter number) IS

Line 1404: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);

1400:
1401: EXCEPTION WHEN OTHERS THEN
1402: v_log_text := SQLERRM;
1403: g_error_flag := 2;
1404: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);
1405:
1406: END; --edit_check_12
1407:
1408: PROCEDURE edit_check_13

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

1465: WHERE closing_acct_flag='Y'
1466: ORDER BY closing_grp;
1467:
1468: BEGIN
1469: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Entering Edit Check 13');
1471: END IF;
1472: --fnd_file.put_line(fnd_file.log , '********************** EDIT CHEK 13 BEGIN ************');
1473: init_vars;

Line 1470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Entering Edit Check 13');

1466: ORDER BY closing_grp;
1467:
1468: BEGIN
1469: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Entering Edit Check 13');
1471: END IF;
1472: --fnd_file.put_line(fnd_file.log , '********************** EDIT CHEK 13 BEGIN ************');
1473: init_vars;
1474: v_edit_check_number :=13;

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

1480: INTO exp_date
1481: FROM fv_treasury_symbols
1482: WHERE treasury_symbol_id = g_treasury_symbol_id;
1483:
1484: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1485: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Expiration date for treasury id '||g_treasury_symbol_id||' is '||exp_date);
1486: END IF;
1487: -- fnd_file.put_line(fnd_file.log , 'exp_date ::' || exp_date);
1488:

Line 1485: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Expiration date for treasury id '||g_treasury_symbol_id||' is '||exp_date);

1481: FROM fv_treasury_symbols
1482: WHERE treasury_symbol_id = g_treasury_symbol_id;
1483:
1484: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1485: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Expiration date for treasury id '||g_treasury_symbol_id||' is '||exp_date);
1486: END IF;
1487: -- fnd_file.put_line(fnd_file.log , 'exp_date ::' || exp_date);
1488:
1489: IF (exp_date IS NOT NULL) THEN

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

1507: whether_Exp := 'U';
1508: END IF;
1509: -- fnd_file.put_line(fnd_file.log , 'whether_Exp ::' || whether_Exp);
1510:
1511: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1512: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' Expired / Unexpired -'||whether_Exp);
1513: END IF;
1514:
1515: SELECT COUNT(*)

Line 1512: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' Expired / Unexpired -'||whether_Exp);

1508: END IF;
1509: -- fnd_file.put_line(fnd_file.log , 'whether_Exp ::' || whether_Exp);
1510:
1511: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1512: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' Expired / Unexpired -'||whether_Exp);
1513: END IF;
1514:
1515: SELECT COUNT(*)
1516: INTO l_temp_count

Line 1537: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'No data found for hard edit check flag for period year-'||g_period_year,v_log_text);

1533: FROM fv_facts2_Edit_params
1534: WHERE set_of_books_id = g_ledger_id;
1535: EXCEPTION
1536: WHEN NO_DATA_FOUND THEN
1537: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'No data found for hard edit check flag for period year-'||g_period_year,v_log_text);
1538: flg:='N';
1539: END;
1540:
1541: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1537: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'No data found for hard edit check flag for period year-'||g_period_year,v_log_text);
1538: flg:='N';
1539: END;
1540:
1541: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1542: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' Is hard edit 13 flag on Federal financial options form selected ? '||flg);
1543: END IF;
1544: --fnd_file.put_line(fnd_file.log , 'flg ::' || flg);
1545: /* Iterating over the closing_act_c and calculating the begining bal and end balance

Line 1542: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' Is hard edit 13 flag on Federal financial options form selected ? '||flg);

1538: flg:='N';
1539: END;
1540:
1541: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1542: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' Is hard edit 13 flag on Federal financial options form selected ? '||flg);
1543: END IF;
1544: --fnd_file.put_line(fnd_file.log , 'flg ::' || flg);
1545: /* Iterating over the closing_act_c and calculating the begining bal and end balance
1546: * Also populating the FV_FACTS_TEMP table.

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

1558:
1559: --fnd_file.put_line(fnd_file.log , 'beginning sgl account number ::Begining balance ::l_auth_type::l_closing_gp' || l_control_acct_num||
1560: --'::'||l_beg_bal||'::'||l_auth_type||'::'||l_closing_gp);
1561:
1562: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1563: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' l_control_acct_num ::l_closing_gp -- '|| l_control_acct_num||
1564: '::'||l_closing_gp);
1565: END IF;
1566:

Line 1563: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' l_control_acct_num ::l_closing_gp -- '|| l_control_acct_num||

1559: --fnd_file.put_line(fnd_file.log , 'beginning sgl account number ::Begining balance ::l_auth_type::l_closing_gp' || l_control_acct_num||
1560: --'::'||l_beg_bal||'::'||l_auth_type||'::'||l_closing_gp);
1561:
1562: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1563: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' l_control_acct_num ::l_closing_gp -- '|| l_control_acct_num||
1564: '::'||l_closing_gp);
1565: END IF;
1566:
1567: -- Retreiving the values for a beginning balances for the current year

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

1597: l_facts_insert_flg:='Y';
1598: --fnd_file.put_line(fnd_file.log ,'sum_ending_bal ::l_auth_type ::'||sum_ending_bal||':: null');
1599: END IF;
1600:
1601: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1602: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' l_facts_insert_flg :: Total Ending Balance -- '|| l_facts_insert_flg||
1603: '::'||sum_ending_bal);
1604: END IF;
1605:

Line 1602: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' l_facts_insert_flg :: Total Ending Balance -- '|| l_facts_insert_flg||

1598: --fnd_file.put_line(fnd_file.log ,'sum_ending_bal ::l_auth_type ::'||sum_ending_bal||':: null');
1599: END IF;
1600:
1601: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1602: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' l_facts_insert_flg :: Total Ending Balance -- '|| l_facts_insert_flg||
1603: '::'||sum_ending_bal);
1604: END IF;
1605:
1606: IF l_facts_insert_flg = 'Y' THEN

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

1625: g_error_flag :=1; -- Not a hard edit, so bulk file can be generated
1626: END IF;
1627: END IF;
1628:
1629: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1630: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' Error flag(1- optional edit fail,2- failed,3-passed) :: Total Ending Balance -- '|| g_error_flag||
1631: '::'||sum_ending_bal);
1632: END IF;
1633: -- To display layout when no value inserted

Line 1630: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' Error flag(1- optional edit fail,2- failed,3-passed) :: Total Ending Balance -- '|| g_error_flag||

1626: END IF;
1627: END IF;
1628:
1629: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1630: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' Error flag(1- optional edit fail,2- failed,3-passed) :: Total Ending Balance -- '|| g_error_flag||
1631: '::'||sum_ending_bal);
1632: END IF;
1633: -- To display layout when no value inserted
1634: -- in to fv_facts_temp table.

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

1660: v_log_text := 'Exception when others in Edit Check 13. SQLCODE: '|| SQLCODE ;
1661: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1662: v_log_text := 'SQLERRM: '|| SQLERRM ;
1663: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1664: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1665: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' Error flag(1- optional edit fail,2- failed,3-passed) :: Total Ending Balance -- '|| g_error_flag||
1666: '::'||sum_ending_bal);
1667: END IF;
1668: g_error_flag := 2;

Line 1665: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' Error flag(1- optional edit fail,2- failed,3-passed) :: Total Ending Balance -- '|| g_error_flag||

1661: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1662: v_log_text := 'SQLERRM: '|| SQLERRM ;
1663: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1664: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1665: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' Error flag(1- optional edit fail,2- failed,3-passed) :: Total Ending Balance -- '|| g_error_flag||
1666: '::'||sum_ending_bal);
1667: END IF;
1668: g_error_flag := 2;
1669: END edit_check_13;

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

1788: v_edit_check_number := 15;
1789: v_sgl_acct_number := NULL;
1790: g_error_flag := 0;
1791:
1792: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check 15');
1794: END IF;
1795:
1796: BEGIN

Line 1793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check 15');

1789: v_sgl_acct_number := NULL;
1790: g_error_flag := 0;
1791:
1792: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1793: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check 15');
1794: END IF;
1795:
1796: BEGIN
1797: FOR check_15_rec1 IN check_4397 LOOP

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

1827: v_edit_check_status := 'Passed';
1828: ELSE
1829: v_edit_check_status := 'Failed';
1830: g_error_flag := 2; --Hard Edit Failed so bulk file cannot be created
1831: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1832: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Hard edit failed for edit check 15');
1833: END IF;
1834: END IF;
1835: v_sgl_acct_number := '7Difference (Should be <= zero)';

Line 1832: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Hard edit failed for edit check 15');

1828: ELSE
1829: v_edit_check_status := 'Failed';
1830: g_error_flag := 2; --Hard Edit Failed so bulk file cannot be created
1831: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1832: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Hard edit failed for edit check 15');
1833: END IF;
1834: END IF;
1835: v_sgl_acct_number := '7Difference (Should be <= zero)';
1836: v_amount1 := (amt_4397 + amt_4157);

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

1878: v_edit_check_number := 16;
1879: v_sgl_acct_number := NULL;
1880: g_error_flag := 0;
1881:
1882: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1883: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check 16');
1884: END IF;
1885:
1886: BEGIN

Line 1883: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check 16');

1879: v_sgl_acct_number := NULL;
1880: g_error_flag := 0;
1881:
1882: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1883: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check 16');
1884: END IF;
1885:
1886: BEGIN
1887: FOR check_16_rec1 IN check_4398 LOOP

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

1917: v_edit_check_status := 'Passed';
1918: ELSE
1919: v_edit_check_status := 'Failed';
1920: g_error_flag := 2; --Hard Edit Failed so bulk file cannot be created
1921: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1922: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Hard edit failed for edit check 16');
1923: END IF;
1924: END IF;
1925: v_sgl_acct_number := '7Difference (Should be <= zero)';

Line 1922: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Hard edit failed for edit check 16');

1918: ELSE
1919: v_edit_check_status := 'Failed';
1920: g_error_flag := 2; --Hard Edit Failed so bulk file cannot be created
1921: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1922: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Hard edit failed for edit check 16');
1923: END IF;
1924: END IF;
1925: v_sgl_acct_number := '7Difference (Should be <= zero)';
1926: v_amount1 := (amt_4398 + amt_4158);

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

1969: v_sgl_acct_number := NULL;
1970: chk_17_1_sum := NULL;
1971: g_error_flag := 0;
1972:
1973: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1974: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check 17');
1975: END IF;
1976:
1977: FOR check1_rec IN chk17_1_4871_4971

Line 1974: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check 17');

1970: chk_17_1_sum := NULL;
1971: g_error_flag := 0;
1972:
1973: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1974: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check 17');
1975: END IF;
1976:
1977: FOR check1_rec IN chk17_1_4871_4971
1978: LOOP

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

2012: v_edit_check_status := 'Passed';
2013: ELSIF (chk_17_2_sum = 0 ) THEN
2014: v_edit_check_status := 'Failed';
2015: g_error_flag := 2; --Hard Edit Failed so bulk file cannot be created
2016: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2017: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Hard edit failed for edit check 17');
2018: END IF;
2019: ELSE
2020: v_edit_check_status := 'Failed';

Line 2017: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Hard edit failed for edit check 17');

2013: ELSIF (chk_17_2_sum = 0 ) THEN
2014: v_edit_check_status := 'Failed';
2015: g_error_flag := 2; --Hard Edit Failed so bulk file cannot be created
2016: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2017: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Hard edit failed for edit check 17');
2018: END IF;
2019: ELSE
2020: v_edit_check_status := 'Failed';
2021: g_error_flag := 2; --Hard Edit Failed so bulk file cannot be created

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

2018: END IF;
2019: ELSE
2020: v_edit_check_status := 'Failed';
2021: g_error_flag := 2; --Hard Edit Failed so bulk file cannot be created
2022: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2023: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Hard edit failed for edit check 17');
2024: END IF;
2025: END IF;
2026: ELSE

Line 2023: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Hard edit failed for edit check 17');

2019: ELSE
2020: v_edit_check_status := 'Failed';
2021: g_error_flag := 2; --Hard Edit Failed so bulk file cannot be created
2022: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2023: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Hard edit failed for edit check 17');
2024: END IF;
2025: END IF;
2026: ELSE
2027: v_edit_check_status := 'Not Needed';

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

2073: v_edit_check_number := 17.9;
2074: v_sgl_acct_number := NULL;
2075: g_error_flag := 0;
2076:
2077: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2078: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check Non Federal Exception');
2079: END IF;
2080:
2081: FOR check_18_rec IN check_18

Line 2078: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check Non Federal Exception');

2074: v_sgl_acct_number := NULL;
2075: g_error_flag := 0;
2076:
2077: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2078: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check Non Federal Exception');
2079: END IF;
2080:
2081: FOR check_18_rec IN check_18
2082: LOOP

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

2124: BEGIN
2125: init_vars;
2126: g_error_flag := 0;
2127:
2128: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2129: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check 18');
2130: END IF;
2131:
2132: /*Calculation for SF 133 Line 1700:

Line 2129: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check 18');

2125: init_vars;
2126: g_error_flag := 0;
2127:
2128: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2129: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check 18');
2130: END IF;
2131:
2132: /*Calculation for SF 133 Line 1700:
2133: 1)Accounts with 1700, 1800 checkbox checked on SF 133 Line Attribute Tab

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

2165: l_1700_status := 5;
2166: END IF;
2167: END IF;
2168:
2169: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2170: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2171: 'Line 1700 status:'|| l_1700_status);
2172: END IF;
2173:

Line 2170: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

2166: END IF;
2167: END IF;
2168:
2169: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2170: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2171: 'Line 1700 status:'|| l_1700_status);
2172: END IF;
2173:
2174: /*Calculation for SF 133 Line 1800:

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

2206: l_1800_status := 5;
2207: END IF;
2208: END IF;
2209:
2210: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2212: 'Line 1800 status:'|| l_1800_status);
2213: END IF;
2214:

Line 2211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

2207: END IF;
2208: END IF;
2209:
2210: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2212: 'Line 1800 status:'|| l_1800_status);
2213: END IF;
2214:
2215: /*Calculation for SF 133 Line 2004:

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

2250: l_2004_status := 5;
2251: END IF;
2252: END IF;
2253:
2254: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2255: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2256: 'Line 2004 status:'|| l_2004_status);
2257: END IF;
2258:

Line 2255: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

2251: END IF;
2252: END IF;
2253:
2254: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2255: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2256: 'Line 2004 status:'|| l_2004_status);
2257: END IF;
2258:
2259: /*Calculation for SF 133 Line 2004:

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

2294: l_2104_status := 5;
2295: END IF;
2296: END IF;
2297:
2298: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2299: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2300: 'Line 2104 status:'|| l_2104_status);
2301: END IF;
2302:

Line 2299: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

2295: END IF;
2296: END IF;
2297:
2298: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2299: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2300: 'Line 2104 status:'|| l_2104_status);
2301: END IF;
2302:
2303: -- Value of an individual sub edit status is 0,1,5 when status is not

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

2304: -- applicable(no entries),pass or fail.
2305: l_combined_status := l_1700_status + l_1800_status + l_2004_status
2306: + l_2104_status;
2307:
2308: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2309: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2310: 'Combined status:'|| l_combined_status);
2311: END IF;
2312:

Line 2309: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

2305: l_combined_status := l_1700_status + l_1800_status + l_2004_status
2306: + l_2104_status;
2307:
2308: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2309: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2310: 'Combined status:'|| l_combined_status);
2311: END IF;
2312:
2313: IF l_combined_status = 0 THEN

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

2384: BEGIN
2385: init_vars;
2386: g_error_flag := 0;
2387:
2388: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2389: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check 19');
2390: END IF;
2391:
2392: /*For PYA = "B:Backdated Adjustments to prior-year reporting",

Line 2389: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check 19');

2385: init_vars;
2386: g_error_flag := 0;
2387:
2388: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2389: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check 19');
2390: END IF;
2391:
2392: /*For PYA = "B:Backdated Adjustments to prior-year reporting",
2393: Sum of the ending balance of the budgetary accounts must equal "0".

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

2414: ELSE
2415: l_pyab_bud_status := 0;
2416: END IF;
2417:
2418: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2419: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2420: 'PYA = B, Budgetary accounts- status:'|| l_pyab_bud_status);
2421: END IF;
2422:

Line 2419: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

2415: l_pyab_bud_status := 0;
2416: END IF;
2417:
2418: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2419: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2420: 'PYA = B, Budgetary accounts- status:'|| l_pyab_bud_status);
2421: END IF;
2422:
2423: /*For PYA = "B:Backdated Adjustments to prior-year reporting",

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

2445: ELSE
2446: l_pyab_prop_status := 0;
2447: END IF;
2448:
2449: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2450: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2451: 'PYA = B, Proprietary accounts- status:'|| l_pyab_prop_status);
2452: END IF;
2453:

Line 2450: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

2446: l_pyab_prop_status := 0;
2447: END IF;
2448:
2449: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2450: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2451: 'PYA = B, Proprietary accounts- status:'|| l_pyab_prop_status);
2452: END IF;
2453:
2454: /*For PYA = "P:Non-Backdated Adjustments to prior-year reporting",

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

2476: ELSE
2477: l_pyap_bud_status := 0;
2478: END IF;
2479:
2480: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2481: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2482: 'PYA = P, Budgetary accounts- status:'|| l_pyap_bud_status);
2483: END IF;
2484:

Line 2481: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

2477: l_pyap_bud_status := 0;
2478: END IF;
2479:
2480: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2481: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2482: 'PYA = P, Budgetary accounts- status:'|| l_pyap_bud_status);
2483: END IF;
2484:
2485: /*For PYA = "P:Non-Backdated Adjustments to prior-year reporting",

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

2506: ELSE
2507: l_pyap_prop_status := 0;
2508: END IF;
2509:
2510: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2511: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2512: 'PYA = P, Proprietary accounts- status:'|| l_pyap_prop_status);
2513: END IF;
2514:

Line 2511: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

2507: l_pyap_prop_status := 0;
2508: END IF;
2509:
2510: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2511: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2512: 'PYA = P, Proprietary accounts- status:'|| l_pyap_prop_status);
2513: END IF;
2514:
2515: -- Value of an individual sub edit status is 0,1,5 when status is not

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

2516: -- applicable(no entries),pass or fail.
2517: l_combined_status := l_pyab_bud_status + l_pyab_prop_status + l_pyap_bud_status
2518: + l_pyap_prop_status;
2519:
2520: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2521: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2522: 'Combined status:'|| l_combined_status);
2523: END IF;
2524:

Line 2521: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

2517: l_combined_status := l_pyab_bud_status + l_pyab_prop_status + l_pyap_bud_status
2518: + l_pyap_prop_status;
2519:
2520: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2521: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
2522: 'Combined status:'|| l_combined_status);
2523: END IF;
2524:
2525: IF l_combined_status = 0 THEN

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

2592: init_vars;
2593: v_edit_check_number := 20;
2594: g_error_flag := 0;
2595:
2596: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2597: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check 20');
2598: END IF;
2599:
2600: FOR rec IN chk20

Line 2597: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check 20');

2593: v_edit_check_number := 20;
2594: g_error_flag := 0;
2595:
2596: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2597: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Begin edit check 20');
2598: END IF;
2599:
2600: FOR rec IN chk20
2601: LOOP

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

2629: l_status_4149 := 1;
2630: END IF;
2631: END IF;
2632:
2633: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2634: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Account: '||
2635: v_sgl_acct_number||' v_amount1: '||v_amount1||' v_amount2: '||v_amount2 );
2636: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'l_status_4201,
2637: l_status_4139, l_status_4149: '||l_status_4201||l_status_4139||l_status_4149);

Line 2634: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Account: '||

2630: END IF;
2631: END IF;
2632:
2633: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2634: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Account: '||
2635: v_sgl_acct_number||' v_amount1: '||v_amount1||' v_amount2: '||v_amount2 );
2636: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'l_status_4201,
2637: l_status_4139, l_status_4149: '||l_status_4201||l_status_4139||l_status_4149);
2638: END IF;

Line 2636: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'l_status_4201,

2632:
2633: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2634: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'Account: '||
2635: v_sgl_acct_number||' v_amount1: '||v_amount1||' v_amount2: '||v_amount2 );
2636: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name, 'l_status_4201,
2637: l_status_4139, l_status_4149: '||l_status_4201||l_status_4139||l_status_4149);
2638: END IF;
2639:
2640: END LOOP;

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

2690: INTO l_cancel_date, l_subclass_prefix_code
2691: FROM fv_treasury_symbols
2692: WHERE treasury_symbol_id = g_treasury_symbol_id;
2693:
2694: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2695: v_log_text := 'Edit Check process start...' ;
2696: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message1',v_log_text);
2697: v_log_text := ' ' ;
2698: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message1',v_log_text);

Line 2696: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message1',v_log_text);

2692: WHERE treasury_symbol_id = g_treasury_symbol_id;
2693:
2694: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2695: v_log_text := 'Edit Check process start...' ;
2696: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message1',v_log_text);
2697: v_log_text := ' ' ;
2698: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message1',v_log_text);
2699: END IF;
2700:

Line 2698: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message1',v_log_text);

2694: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2695: v_log_text := 'Edit Check process start...' ;
2696: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message1',v_log_text);
2697: v_log_text := ' ' ;
2698: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message1',v_log_text);
2699: END IF;
2700:
2701: edit_check_1;
2702: edit_check_2;

Line 2713: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error2',errbuf);

2709: retcode := g_error_flag;
2710: IF (retcode = 2) THEN
2711: errbuf := 'Hard Edit Check Failed';
2712: v_log_text := 'Hard Edit Check Failed.' ;
2713: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error2',errbuf);
2714:
2715: ELSE
2716: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2717: v_log_text := 'Edit Check Passed.' ;

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

2712: v_log_text := 'Hard Edit Check Failed.' ;
2713: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error2',errbuf);
2714:
2715: ELSE
2716: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2717: v_log_text := 'Edit Check Passed.' ;
2718: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2719: l_module_name||'.message4',v_log_text);
2720: END IF;

Line 2718: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,

2714:
2715: ELSE
2716: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2717: v_log_text := 'Edit Check Passed.' ;
2718: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2719: l_module_name||'.message4',v_log_text);
2720: END IF;
2721:
2722: END IF;

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

2753: else
2754:
2755: -- Changed log text for bug 2053780
2756:
2757: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2758: v_log_text := 'Edit Checks 4,5,6,7,10 and 11 are not needed' ;
2759: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message2',v_log_text);
2760: END IF;
2761:

Line 2759: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message2',v_log_text);

2755: -- Changed log text for bug 2053780
2756:
2757: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2758: v_log_text := 'Edit Checks 4,5,6,7,10 and 11 are not needed' ;
2759: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message2',v_log_text);
2760: END IF;
2761:
2762: v_log_text := ' ';
2763: v_edit_check_status := 'Not Needed';

Line 2866: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',errbuf);

2862: retcode := g_error_flag;
2863: if (retcode = 1) then
2864: errbuf := 'Soft Edit Check Failed.' ;
2865: v_log_text := 'Soft Edit Check Failed.' ;
2866: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',errbuf);
2867:
2868: elsif (retcode = 2) then
2869: errbuf := 'Hard Edit Check Failed';
2870: v_log_text := 'Hard Edit Check Failed.' ;

Line 2871: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error2',errbuf);

2867:
2868: elsif (retcode = 2) then
2869: errbuf := 'Hard Edit Check Failed';
2870: v_log_text := 'Hard Edit Check Failed.' ;
2871: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error2',errbuf);
2872:
2873: else
2874: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2875: v_log_text := 'Edit Check Passed.' ;

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

2870: v_log_text := 'Hard Edit Check Failed.' ;
2871: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error2',errbuf);
2872:
2873: else
2874: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2875: v_log_text := 'Edit Check Passed.' ;
2876: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message4',v_log_text);
2877: END IF;
2878: end if;

Line 2876: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message4',v_log_text);

2872:
2873: else
2874: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2875: v_log_text := 'Edit Check Passed.' ;
2876: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'.message4',v_log_text);
2877: END IF;
2878: end if;
2879: -- SF133 enhancement
2880: if (fv_sf133_noyear.sf133_runmode = 'NO' and fv_sf133_oneyear.sf133_runmode = 'NO')then

Line 2886: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);

2882: end if;
2883: EXCEPTION
2884: WHEN OTHERS THEN
2885: v_log_text := SQLERRM;
2886: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);
2887: RAISE;
2888: end; --perform_edit_checks
2889:
2890: -------------------------------------------------------------------------

Line 2914: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);

2910: EXCEPTION
2911: when others then
2912: v_log_text := SQLERRM;
2913: g_error_flag := sqlcode ;
2914: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);
2915: return;
2916: END; -- create_status_record
2917: -------------------------------------------------------------------------
2918: -- Procedure CREATE_LOG_RECORD

Line 2969: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);

2965: EXCEPTION
2966: When Others Then
2967: v_log_text := SQLERRM;
2968: g_error_flag := sqlcode ;
2969: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',v_log_text);
2970: return;
2971: END CREATE_LOG_RECORD ;
2972: ------------------------------------------
2973:

Line 3075: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'No data found for treasury symbol id '||g_treasury_symbol_id,v_log_text);

3071: WHERE treasury_symbol_id = g_treasury_symbol_id
3072: AND period_year <> g_period_year-1;
3073: EXCEPTION
3074: WHEN NO_DATA_FOUND THEN
3075: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'No data found for treasury symbol id '||g_treasury_symbol_id,v_log_text);
3076: END;
3077: /* SELECT COUNT(*)
3078: INTO l_count
3079: FROM fv_facts_temp tmp,