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.PA_BUDGET_FUND_PKG dependencies on FND_API

Line 117: x_return_status := FND_API.G_RET_STS_SUCCESS;

113:
114: BEGIN
115:
116: log_message('Entering cc_funds_chk_rsrv API .........') ;
117: x_return_status := FND_API.G_RET_STS_SUCCESS;
118:
119: SELECT imp.set_of_books_id, sob.currency_code, SOB.PERIOD_SET_NAME
120: INTO l_set_of_books_id, l_currency_code, l_period_set_name
121: FROM PA_IMPLEMENTATIONS_all IMP, GL_SETS_OF_BOOKS SOB

Line 402: x_return_status := FND_API.G_RET_STS_ERROR;

398:
399: EXCEPTION
400: WHEN l_cc_funds_resv_fail THEN
401: PA_UTILS.Add_Message('PA', 'PA_BC_CC_FNDS_RESV_FAIL');
402: x_return_status := FND_API.G_RET_STS_ERROR;
403: x_msg_data := 'PA_BC_CC_FNDS_RESV_FAIL';
404: x_msg_count := 1;
405: WHEN OTHERS THEN
406: log_message('Error in cc_funds_chk_rsrv ... '||SQLERRM);

Line 407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

403: x_msg_data := 'PA_BC_CC_FNDS_RESV_FAIL';
404: x_msg_count := 1;
405: WHEN OTHERS THEN
406: log_message('Error in cc_funds_chk_rsrv ... '||SQLERRM);
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: x_msg_count := 1;
409: x_msg_data := substr(SQLERRM,1,240);
410: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGET_FUND_PKG',
411: p_procedure_name => 'cc_funds_chk_rsrv');

Line 465: x_return_status := FND_API.G_RET_STS_SUCCESS;

461: g_procedure_name := 'Create_txn_lines_in_bc_balance';
462: log_message('Create_txn_lines_in_bc_balance:Start');
463:
464: --Initialize the return status to success
465: x_return_status := FND_API.G_RET_STS_SUCCESS;
466:
467: log_message('Create_txn_lines_in_bc_balance: Is it a re-baseline:'||g_cost_rebaseline_flag);
468:
469: If ( g_processing_mode = 'BASELINE' and g_cost_rebaseline_flag = 'Y') then

Line 482: If x_return_status <> FND_API.G_RET_STS_SUCCESS then

478: End if;
479:
480: log_message('Create_txn_lines_in_bc_balance:After calling Sweeper,RetSts = '||x_return_status);
481:
482: If x_return_status <> FND_API.G_RET_STS_SUCCESS then
483: GOTO no_processing;
484: End If;
485: End If;
486:

Line 573: If x_return_status <> FND_API.G_RET_STS_SUCCESS then

569:
570: log_message('Create_txn_lines_in_bc_balance:After calling get gl periods,RetSts = '||x_return_status);
571: log_message('Create_txn_lines_in_bc_balance:Insert Close Period Balances, TabCount = '||l_tab_count);
572:
573: If x_return_status <> FND_API.G_RET_STS_SUCCESS then
574: log_message('Create_txn_lines_in_bc_balance: PA_FUNDS_CONTROL_UTILS.get_gl_periods failed');
575: GOTO no_processing;
576: End If;
577:

Line 654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

650: IF c_delbal%ISOPEN THEN
651: close c_delbal;
652: END IF;
653:
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655: x_error_message_code := (SQLCODE||' '||SQLERRM);
656: log_message('Create_txn_lines_in_bc_balance: x_error_message_code'||x_error_message_code);
657: RAISE;
658: END Create_txn_lines_in_bc_balance;

Line 686: x_ret_status := FND_API.G_RET_STS_SUCCESS;

682: g_procedure_name := 'Create_bgt_lines_in_bc_balance';
683: log_message('Create_bgt_lines_in_bc_balance: Start');
684: l_login_id := FND_GLOBAL.LOGIN_ID;
685: l_date := SYSDATE;
686: x_ret_status := FND_API.G_RET_STS_SUCCESS;
687:
688: FORALL i in t_task_id.FIRST..t_task_id.LAST
689: insert into pa_bc_balances(
690: PROJECT_ID,

Line 736: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR ;

732: WHEN OTHERS THEN
733: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_BUDGET_FUND_PKG'
734: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
735:
736: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR ;
737: x_err_message_code := (SQLCODE||' '||SQLERRM);
738: log_message('Create_bgt_lines_in_bc_balance: x_err_message_code'||x_err_message_code);
739: RAISE;
740: End Create_bgt_lines_in_bc_balance;

Line 789: x_return_status := FND_API.G_RET_STS_SUCCESS;

785: g_procedure_name := 'Establish_bc_balances';
786: log_message('Establish_bc_balances:Start');
787:
788: --Initialize the return status to success
789: x_return_status := FND_API.G_RET_STS_SUCCESS;
790:
791: log_message('Establish_bc_balances: Get SOB_ID');
792:
793: select to_number(set_of_books_id) into l_sob_id from pa_implementations_all

Line 880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

876:
877: IF c_bdgt_bal%ISOPEN THEN
878: close c_bdgt_bal;
879: END IF;
880: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
881: x_error_message_code := (SQLCODE||' '||SQLERRM);
882: log_message('Establish_bc_balances: x_error_message_code'||x_error_message_code);
883: RAISE;
884: END Establish_bc_balances;

Line 995: --x_return_status := FND_API.G_RET_STS_SUCCESS;

991: and bc_rev_event_id is not null;
992:
993: BEGIN
994:
995: --x_return_status := FND_API.G_RET_STS_SUCCESS;
996: --l_return_status := FND_API.G_RET_STS_SUCCESS; /*Bug 3794994 */
997:
998: -----------------------------------------------+
999: -- 0.0: initalize ...

Line 996: --l_return_status := FND_API.G_RET_STS_SUCCESS; /Bug 3794994 /

992:
993: BEGIN
994:
995: --x_return_status := FND_API.G_RET_STS_SUCCESS;
996: --l_return_status := FND_API.G_RET_STS_SUCCESS; /*Bug 3794994 */
997:
998: -----------------------------------------------+
999: -- 0.0: initalize ...
1000: -----------------------------------------------+

Line 1024: x_return_status := FND_API.G_RET_STS_SUCCESS;

1020: WHERE project_id = p_project_id;
1021:
1022: If l_template_flag = 'Y' then
1023: log_message('check_or_reserve_funds called for template project ..exit with success');
1024: x_return_status := FND_API.G_RET_STS_SUCCESS;
1025: RETURN;
1026: End If;
1027:
1028: x_dual_bdgt_cntrl_flag := 'N';

Line 1213: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1209: X_Return_Status => l_return_status,
1210: X_Msg_Count => l_msg_count,
1211: X_Msg_Data => l_msg_data) ;
1212:
1213: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1214: RAISE l_budget_processing_failure;
1215: END IF ;
1216:
1217: END IF; --IF (nvl(l_balance_type,'E') <> 'B' THEN -- 4.1

Line 1395: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1391:
1392: g_procedure_name := 'check_or_reserve_funds';
1393: log_message('After calling Establish_Bc_Balances,x_return_status:'||x_return_status);
1394:
1395: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1396: RAISE l_budget_processing_failure ;
1397: END IF;
1398:
1399: log_message('Calling maintain_bal_fchk');

Line 1413: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1409: X_ERROR_MESSAGE_CODE => l_msg_data) ;
1410:
1411: log_message('After Calling maintain_bal_fchk,x_return_status:'||x_return_status);
1412:
1413: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1414: RAISE l_budget_processing_failure ;
1415: Else
1416:
1417: -- Update pa_bc_packets.status_code = 'A'

Line 1461: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1457: X_Return_Status => l_return_status,
1458: X_Msg_Count => l_msg_count,
1459: X_Msg_Data => l_msg_data) ;
1460:
1461: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1462: RAISE l_budget_processing_failure ;
1463: END IF ;
1464:
1465: ============================================================== */

Line 1541: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1537: X_Msg_Data => l_msg_data) ;
1538:
1539: log_message('After calling PA_BUDGET_ACCOUNT_PKG.Gen_Acct_All_Lines, l_return_status:'||l_return_status);
1540:
1541: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1542: RAISE l_budget_processing_failure ;
1543: END IF ;
1544:
1545: -- ## 2.2 Call Establish_bc_balances

Line 1559: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1555:
1556: g_procedure_name := 'check_or_reserve_funds';
1557:
1558: log_message('After Establish_Bc_Balances,x_return_status:'||x_return_status);
1559: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1560: RAISE l_budget_processing_failure ;
1561: END IF;
1562:
1563: -- ## 2.3 Call PA FCK ..

Line 1578: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1574: X_ERROR_MESSAGE_CODE => l_msg_data) ;
1575:
1576: log_message('After calling pa_bgt_baseline_pkg.maintain_bal_fchk, l_return_status:'||l_return_status);
1577:
1578: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1579: RAISE l_budget_processing_failure ;
1580: END IF ;
1581:
1582: --End If; -- re-baseline check ..

Line 1702: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1698: X_Msg_Data => l_msg_data) ;
1699:
1700: log_message('After calling PA_BUDGET_ACCOUNT_PKG.Gen_Acct_All_Lines, l_return_status:'||l_return_status);
1701:
1702: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1703: RAISE l_budget_processing_failure ;
1704: END IF ;
1705:
1706: log_message('Calling Establish_Bc_Balances');

Line 1719: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1715:
1716: g_procedure_name := 'check_or_reserve_funds';
1717:
1718: log_message('After Establish_Bc_Balances,x_return_status:'||x_return_status);
1719: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1720: RAISE l_budget_processing_failure ;
1721: END IF;
1722: --END Bug 6524116
1723:

Line 1742: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1738: X_ERROR_MESSAGE_CODE => l_msg_data) ;
1739:
1740: log_message('After calling pa_bgt_baseline_pkg.maintain_bal_fchk, l_return_status:'||l_return_status);
1741:
1742: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1743: RAISE l_budget_processing_failure ;
1744: END IF ;
1745:
1746: --End IF; -- rebaseline

Line 1811: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1807: X_Msg_Data => l_msg_data) ;
1808:
1809: log_message('After calling pa_budgetary_controls_pkg.bud_ctrl_create, l_return_status:'||l_return_status);
1810:
1811: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1812:
1813: RAISE l_top_down_bdgt_failed;
1814:
1815: END IF ;

Line 1832: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1828: X_Msg_Data => l_msg_data) ;
1829:
1830: log_message('After calling PA_BUDGET_ACCOUNT_PKG.Gen_Acct_All_Lines, l_return_status:'||l_return_status);
1831:
1832: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1833: RAISE l_budget_processing_failure ;
1834: END IF ;
1835:
1836: log_message('Calling Establish_Bc_Balances');

Line 1849: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1845:
1846: g_procedure_name := 'check_or_reserve_funds';
1847:
1848: log_message('After Establish_Bc_Balances,x_return_status:'||x_return_status);
1849: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1850: RAISE l_budget_processing_failure ;
1851: END IF;
1852: --END BUG 6524116
1853:

Line 1873: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1869: X_ERROR_MESSAGE_CODE => l_msg_data) ;
1870:
1871: log_message('After calling pa_bgt_baseline_pkg.maintain_bal_fchk, l_return_status:'||l_return_status);
1872:
1873: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1874:
1875: RAISE l_top_down_bdgt_failed;
1876: END IF ;
1877: --End If; -- rebaseline

Line 1892: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1888: X_Return_Status => l_return_status,
1889: X_Msg_Count => l_msg_count,
1890: X_Msg_Data => l_msg_data) ;
1891:
1892: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1893: RAISE l_dual_mode_acct_gen_failed ;
1894: END IF ;
1895:
1896: -- ------------------------------------------------------------+

Line 1908: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1904: X_Return_Status => l_return_status,
1905: X_Msg_Count => l_msg_count,
1906: X_Msg_Data => l_msg_data) ;
1907:
1908: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1909: RAISE l_dual_mode_acct_gen_failed ;
1910: END IF ;
1911: */
1912:

Line 2033: l_return_status := FND_API.G_RET_STS_SUCCESS;

2029:
2030:
2031: -- ## RETURN STATUS .. PASSED :)
2032:
2033: l_return_status := FND_API.G_RET_STS_SUCCESS;
2034: x_return_status := l_return_status;
2035:
2036: log_message('exiting check_reserve_funds .........') ;
2037: log_message('l_return_status.........'||l_return_status) ;

Line 2046: x_return_status := FND_API.G_RET_STS_ERROR;

2042:
2043: g_procedure_name := 'check_or_reserve_funds';
2044: log_message(' Exception: l_cbc_not_supported');
2045:
2046: x_return_status := FND_API.G_RET_STS_ERROR;
2047:
2048: PA_UTILS.Add_Message('PA', l_msg_data);
2049: x_msg_data := l_msg_data;
2050: x_msg_count := 1;

Line 2070: x_return_status := FND_API.G_RET_STS_ERROR;

2066: x_msg_data => x_msg_data);
2067: END IF;
2068:
2069: -- This should be set at the end .. do not change this position ..
2070: x_return_status := FND_API.G_RET_STS_ERROR;
2071:
2072: PA_UTILS.Add_Message('PA', l_msg_data);
2073: x_msg_data := l_msg_data;
2074: x_msg_count := 3; -- made to 3 so that it can read all message buffers

Line 2098: x_return_status := FND_API.G_RET_STS_ERROR;

2094: p_status_code=>'R');
2095: END IF;
2096:
2097: -- This should be set at the end .. do not change this position ..
2098: x_return_status := FND_API.G_RET_STS_ERROR;
2099:
2100: PA_UTILS.Add_Message('PA', l_msg_data);
2101: x_msg_data := l_msg_data;
2102: x_msg_count := 3; -- made to 3 so that it can read all message buffers

Line 2119: x_return_status := FND_API.G_RET_STS_ERROR;

2115: x_msg_data => x_msg_data);
2116: END IF;
2117:
2118: -- This should be set at the end .. do not change this position ..
2119: x_return_status := FND_API.G_RET_STS_ERROR;
2120:
2121: PA_UTILS.Add_Message('PA', l_msg_data);
2122: x_msg_data := l_msg_data;
2123: x_msg_count := 3; -- made to 3 so that it can read all message buffers

Line 2149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2145:
2146: END IF;
2147:
2148: -- This should be set at the end .. do not change this position ..
2149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2150:
2151: -- Following code was modified to enhance error handling
2152: -- If there is an exception raised, g_msg_data may be populated
2153: -- (like in create_events_and_fundscheck)

Line 2274: x_return_status := FND_API.G_RET_STS_SUCCESS;

2270:
2271: l_rel_status NUMBER;
2272: BEGIN
2273:
2274: x_return_status := FND_API.G_RET_STS_SUCCESS;
2275:
2276: log_message('Inside get_budget_ctrl_options');
2277:
2278: OPEN C_BUDGET_CONTROL ;

Line 2371: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

2367: THEN
2368: X_Fck_Req_Flag := 'R'; -- Indicates that Year End Rollover is in progress
2369: X_Bdgt_Intg_Flag := 'R'; -- Indicates that Year End Rollover is in progress
2370: END IF;
2371: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2372: END IF;
2373: END;
2374:
2375: EXCEPTION

Line 2377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2373: END;
2374:
2375: EXCEPTION
2376: WHEN OTHERS THEN
2377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2378: x_msg_count := 1;
2379: x_msg_data := substr(SQLERRM,1,240);
2380: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGET_FUND_PKG',
2381: p_procedure_name => 'get_budget_ctrl_options');

Line 2408: x_return_status := FND_API.G_RET_STS_SUCCESS;

2404: IS
2405: l_msg_index_out NUMBER;
2406: BEGIN
2407:
2408: x_return_status := FND_API.G_RET_STS_SUCCESS;
2409:
2410: log_message('Inside upd_bdgt_acct_bal');
2411:
2412: UPDATE PA_BUDGET_ACCT_LINES

Line 2423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2419:
2420: EXCEPTION
2421: WHEN OTHERS THEN
2422: log_message('Inside OTHER Exception handler of upd_bdgt_acct_bal');
2423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2424: x_msg_count := 1;
2425: x_msg_data := substr(SQLERRM,1,240);
2426: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGET_FUND_PKG',
2427: p_procedure_name => 'upd_bdgt_acct_bal');

Line 2465: x_return_status := FND_API.G_RET_STS_SUCCESS;

2461:
2462: BEGIN
2463:
2464: log_message('Entering upd_bdgt_acct_bal_no_fck ..... ');
2465: x_return_status := FND_API.G_RET_STS_SUCCESS;
2466:
2467: log_message('budget_version_id '||to_char(p_budget_version_id));
2468: UPDATE PA_BUDGET_ACCT_LINES
2469: SET curr_ver_available_amount = (curr_ver_budget_amount - prev_ver_budget_amount

Line 2478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2474: log_message('Existing upd_bdgt_acct_bal_no_fck ..... ');
2475:
2476: EXCEPTION
2477: WHEN OTHERS THEN
2478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2479: x_msg_count := 1;
2480: x_msg_data := substr(SQLERRM,1,240);
2481: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGET_FUND_PKG',
2482: p_procedure_name => 'upd_bdgt_acct_bal_no_fck');

Line 2547: x_return_status := FND_API.G_RET_STS_SUCCESS;

2543: x_msg_data OUT NOCOPY VARCHAR2 )
2544: IS
2545: BEGIN
2546:
2547: x_return_status := FND_API.G_RET_STS_SUCCESS;
2548:
2549: log_message('Inside copy_budgetary_controls');
2550: log_message('Inserting records in PA_BUDGETARY_CONTROL_OPTIONS table');
2551: insert into PA_BUDGETARY_CONTROL_OPTIONS

Line 2603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2599: EXCEPTION
2600: WHEN NO_DATA_FOUND THEN
2601: null;
2602: WHEN OTHERS THEN
2603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2604: x_msg_count := 1;
2605: x_msg_data := substr(SQLERRM,1,240);
2606: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGET_FUND_PKG',
2607: p_procedure_name => 'copy_budgetary_controls');

Line 2627: x_return_status := FND_API.G_RET_STS_SUCCESS;

2623: l_temp_ret_status NUMBER;
2624: PRAGMA AUTONOMOUS_TRANSACTION;
2625: BEGIN
2626:
2627: x_return_status := FND_API.G_RET_STS_SUCCESS;
2628:
2629: log_message('entering release_bc_lock ..... ');
2630:
2631: l_temp_ret_status := pa_debug.release_user_lock('BSLNFCHKLOCK:'||to_char(p_project_id));

Line 2640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2636: log_message('exiting release_bc_lock ..... ');
2637:
2638: EXCEPTION
2639: WHEN OTHERS THEN
2640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2641: x_msg_count := 1;
2642: x_msg_data := substr(SQLERRM,1,240);
2643: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGET_FUND_PKG',
2644: p_procedure_name => 'release_bc_lock');

Line 3110: ,p_init_msg_list => FND_API.G_FALSE

3106: from dual;
3107:
3108: PSA_BC_XLA_PUB.Budgetary_Control
3109: (p_api_version => 1.0
3110: ,p_init_msg_list => FND_API.G_FALSE
3111: ,x_return_status => l_return_status
3112: ,x_msg_count => l_msg_count
3113: ,x_msg_data => l_msg_data
3114: ,p_application_id => 275