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.

[Home] [Help]

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 398: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 461: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 478: If x_return_status <> FND_API.G_RET_STS_SUCCESS then

474: End if;
475:
476: log_message('Create_txn_lines_in_bc_balance:After calling Sweeper,RetSts = '||x_return_status);
477:
478: If x_return_status <> FND_API.G_RET_STS_SUCCESS then
479: GOTO no_processing;
480: End If;
481: End If;
482:

Line 569: If x_return_status <> FND_API.G_RET_STS_SUCCESS then

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

Line 650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

646: IF c_delbal%ISOPEN THEN
647: close c_delbal;
648: END IF;
649:
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
651: x_error_message_code := (SQLCODE||' '||SQLERRM);
652: log_message('Create_txn_lines_in_bc_balance: x_error_message_code'||x_error_message_code);
653: RAISE;
654: END Create_txn_lines_in_bc_balance;

Line 682: x_ret_status := FND_API.G_RET_STS_SUCCESS;

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

Line 732: x_ret_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 785: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

872:
873: IF c_bdgt_bal%ISOPEN THEN
874: close c_bdgt_bal;
875: END IF;
876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
877: x_error_message_code := (SQLCODE||' '||SQLERRM);
878: log_message('Establish_bc_balances: x_error_message_code'||x_error_message_code);
879: RAISE;
880: END Establish_bc_balances;

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

985: and bc_rev_event_id is not null;
986:
987: BEGIN
988:
989: --x_return_status := FND_API.G_RET_STS_SUCCESS;
990: --l_return_status := FND_API.G_RET_STS_SUCCESS; /*Bug 3794994 */
991:
992: -----------------------------------------------+
993: -- 0.0: initalize ...

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

986:
987: BEGIN
988:
989: --x_return_status := FND_API.G_RET_STS_SUCCESS;
990: --l_return_status := FND_API.G_RET_STS_SUCCESS; /*Bug 3794994 */
991:
992: -----------------------------------------------+
993: -- 0.0: initalize ...
994: -----------------------------------------------+

Line 1018: x_return_status := FND_API.G_RET_STS_SUCCESS;

1014: WHERE project_id = p_project_id;
1015:
1016: If l_template_flag = 'Y' then
1017: log_message('check_or_reserve_funds called for template project ..exit with success');
1018: x_return_status := FND_API.G_RET_STS_SUCCESS;
1019: RETURN;
1020: End If;
1021:
1022: x_dual_bdgt_cntrl_flag := 'N';

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

1195: X_Return_Status => l_return_status,
1196: X_Msg_Count => l_msg_count,
1197: X_Msg_Data => l_msg_data) ;
1198:
1199: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1200: RAISE l_budget_processing_failure;
1201: END IF ;
1202:
1203: END IF; --IF (nvl(l_balance_type,'E') <> 'B' THEN -- 4.1

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

1332:
1333: g_procedure_name := 'check_or_reserve_funds';
1334: log_message('After calling Establish_Bc_Balances,x_return_status:'||x_return_status);
1335:
1336: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1337: RAISE l_budget_processing_failure ;
1338: END IF;
1339:
1340: log_message('Calling maintain_bal_fchk');

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

1350: X_ERROR_MESSAGE_CODE => l_msg_data) ;
1351:
1352: log_message('After Calling maintain_bal_fchk,x_return_status:'||x_return_status);
1353:
1354: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1355: RAISE l_budget_processing_failure ;
1356: Else
1357:
1358: -- Update pa_bc_packets.status_code = 'A'

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

1398: X_Return_Status => l_return_status,
1399: X_Msg_Count => l_msg_count,
1400: X_Msg_Data => l_msg_data) ;
1401:
1402: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1403: RAISE l_budget_processing_failure ;
1404: END IF ;
1405:
1406: ============================================================== */

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

1476: X_Return_Status => l_return_status,
1477: X_Msg_Count => l_msg_count,
1478: X_Msg_Data => l_msg_data) ;
1479:
1480: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1481: RAISE l_budget_processing_failure ;
1482: END IF ;
1483:
1484: -- ## 2.2 Call Establish_bc_balances

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

1494:
1495: g_procedure_name := 'check_or_reserve_funds';
1496:
1497: log_message('After Establish_Bc_Balances,x_return_status:'||x_return_status);
1498: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1499: RAISE l_budget_processing_failure ;
1500: END IF;
1501:
1502: -- ## 2.3 Call PA FCK ..

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

1511: P_BDGT_INTG_FLAG => 'Y',
1512: X_RETURN_STATUS => l_return_status,
1513: X_ERROR_MESSAGE_CODE => l_msg_data) ;
1514:
1515: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1516: RAISE l_budget_processing_failure ;
1517: END IF ;
1518:
1519: --End If; -- re-baseline check ..

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

1631: X_Return_Status => l_return_status,
1632: X_Msg_Count => l_msg_count,
1633: X_Msg_Data => l_msg_data) ;
1634:
1635: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1636: RAISE l_budget_processing_failure ;
1637: END IF ;
1638:
1639: log_message('Calling Establish_Bc_Balances');

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

1648:
1649: g_procedure_name := 'check_or_reserve_funds';
1650:
1651: log_message('After Establish_Bc_Balances,x_return_status:'||x_return_status);
1652: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1653: RAISE l_budget_processing_failure ;
1654: END IF;
1655: --END Bug 6524116
1656:

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

1669: P_BDGT_INTG_FLAG => 'Y',
1670: X_RETURN_STATUS => l_return_status,
1671: X_ERROR_MESSAGE_CODE => l_msg_data) ;
1672:
1673: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1674: RAISE l_budget_processing_failure ;
1675: END IF ;
1676:
1677: --End IF; -- rebaseline

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

1733: X_Return_Status => l_return_status,
1734: X_Msg_Count => l_msg_count,
1735: X_Msg_Data => l_msg_data) ;
1736:
1737: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1738:
1739: RAISE l_top_down_bdgt_failed;
1740:
1741: END IF ;

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

1752: X_Return_Status => l_return_status,
1753: X_Msg_Count => l_msg_count,
1754: X_Msg_Data => l_msg_data) ;
1755:
1756: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1757: RAISE l_budget_processing_failure ;
1758: END IF ;
1759:
1760: log_message('Calling Establish_Bc_Balances');

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

1769:
1770: g_procedure_name := 'check_or_reserve_funds';
1771:
1772: log_message('After Establish_Bc_Balances,x_return_status:'||x_return_status);
1773: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1774: RAISE l_budget_processing_failure ;
1775: END IF;
1776: --END BUG 6524116
1777:

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

1791: P_BDGT_INTG_FLAG => 'Y',
1792: X_RETURN_STATUS => l_return_status,
1793: X_ERROR_MESSAGE_CODE => l_msg_data) ;
1794:
1795: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1796:
1797: RAISE l_top_down_bdgt_failed;
1798: END IF ;
1799: --End If; -- rebaseline

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

1810: X_Return_Status => l_return_status,
1811: X_Msg_Count => l_msg_count,
1812: X_Msg_Data => l_msg_data) ;
1813:
1814: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1815: RAISE l_dual_mode_acct_gen_failed ;
1816: END IF ;
1817:
1818: -- ------------------------------------------------------------+

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

1826: X_Return_Status => l_return_status,
1827: X_Msg_Count => l_msg_count,
1828: X_Msg_Data => l_msg_data) ;
1829:
1830: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1831: RAISE l_dual_mode_acct_gen_failed ;
1832: END IF ;
1833: */
1834:

Line 1949: l_return_status := FND_API.G_RET_STS_SUCCESS;

1945:
1946:
1947: -- ## RETURN STATUS .. PASSED :)
1948:
1949: l_return_status := FND_API.G_RET_STS_SUCCESS;
1950: x_return_status := l_return_status;
1951:
1952: log_message('exiting check_reserve_funds .........') ;
1953: log_message('l_return_status.........'||l_return_status) ;

Line 1962: x_return_status := FND_API.G_RET_STS_ERROR;

1958:
1959: g_procedure_name := 'check_or_reserve_funds';
1960: log_message(' Exception: l_cbc_not_supported');
1961:
1962: x_return_status := FND_API.G_RET_STS_ERROR;
1963:
1964: PA_UTILS.Add_Message('PA', l_msg_data);
1965: x_msg_data := l_msg_data;
1966: x_msg_count := 1;

Line 1986: x_return_status := FND_API.G_RET_STS_ERROR;

1982: x_msg_data => x_msg_data);
1983: END IF;
1984:
1985: -- This should be set at the end .. do not change this position ..
1986: x_return_status := FND_API.G_RET_STS_ERROR;
1987:
1988: PA_UTILS.Add_Message('PA', l_msg_data);
1989: x_msg_data := l_msg_data;
1990: x_msg_count := 3; -- made to 3 so that it can read all message buffers

Line 2014: x_return_status := FND_API.G_RET_STS_ERROR;

2010: p_status_code=>'R');
2011: END IF;
2012:
2013: -- This should be set at the end .. do not change this position ..
2014: x_return_status := FND_API.G_RET_STS_ERROR;
2015:
2016: PA_UTILS.Add_Message('PA', l_msg_data);
2017: x_msg_data := l_msg_data;
2018: x_msg_count := 3; -- made to 3 so that it can read all message buffers

Line 2035: x_return_status := FND_API.G_RET_STS_ERROR;

2031: x_msg_data => x_msg_data);
2032: END IF;
2033:
2034: -- This should be set at the end .. do not change this position ..
2035: x_return_status := FND_API.G_RET_STS_ERROR;
2036:
2037: PA_UTILS.Add_Message('PA', l_msg_data);
2038: x_msg_data := l_msg_data;
2039: x_msg_count := 3; -- made to 3 so that it can read all message buffers

Line 2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2061:
2062: END IF;
2063:
2064: -- This should be set at the end .. do not change this position ..
2065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2066:
2067: -- Following code was modified to enhance error handling
2068: -- If there is an exception raised, g_msg_data may be populated
2069: -- (like in create_events_and_fundscheck)

Line 2190: x_return_status := FND_API.G_RET_STS_SUCCESS;

2186:
2187: l_rel_status NUMBER;
2188: BEGIN
2189:
2190: x_return_status := FND_API.G_RET_STS_SUCCESS;
2191:
2192: OPEN C_BUDGET_CONTROL ;
2193:
2194: FETCH C_BUDGET_CONTROL INTO

Line 2282: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

2278: THEN
2279: X_Fck_Req_Flag := 'R'; -- Indicates that Year End Rollover is in progress
2280: X_Bdgt_Intg_Flag := 'R'; -- Indicates that Year End Rollover is in progress
2281: END IF;
2282: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2283: END IF;
2284: END;
2285:
2286: EXCEPTION

Line 2288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2284: END;
2285:
2286: EXCEPTION
2287: WHEN OTHERS THEN
2288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2289: x_msg_count := 1;
2290: x_msg_data := substr(SQLERRM,1,240);
2291: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGET_FUND_PKG',
2292: p_procedure_name => 'get_budget_ctrl_options');

Line 2319: x_return_status := FND_API.G_RET_STS_SUCCESS;

2315: IS
2316: l_msg_index_out NUMBER;
2317: BEGIN
2318:
2319: x_return_status := FND_API.G_RET_STS_SUCCESS;
2320:
2321: UPDATE PA_BUDGET_ACCT_LINES
2322: SET curr_ver_available_amount = curr_ver_available_amount - p_amount
2323: WHERE budget_version_id = p_budget_version_id

Line 2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2326:
2327: EXCEPTION
2328: WHEN OTHERS THEN
2329:
2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2331: x_msg_count := 1;
2332: x_msg_data := substr(SQLERRM,1,240);
2333: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGET_FUND_PKG',
2334: p_procedure_name => 'upd_bdgt_acct_bal');

Line 2372: x_return_status := FND_API.G_RET_STS_SUCCESS;

2368:
2369: BEGIN
2370:
2371: log_message('Entering upd_bdgt_acct_bal_no_fck ..... ');
2372: x_return_status := FND_API.G_RET_STS_SUCCESS;
2373:
2374: log_message('budget_version_id '||to_char(p_budget_version_id));
2375: UPDATE PA_BUDGET_ACCT_LINES
2376: SET curr_ver_available_amount = (curr_ver_budget_amount - prev_ver_budget_amount

Line 2385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2381: log_message('Existing upd_bdgt_acct_bal_no_fck ..... ');
2382:
2383: EXCEPTION
2384: WHEN OTHERS THEN
2385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2386: x_msg_count := 1;
2387: x_msg_data := substr(SQLERRM,1,240);
2388: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGET_FUND_PKG',
2389: p_procedure_name => 'upd_bdgt_acct_bal_no_fck');

Line 2452: x_return_status := FND_API.G_RET_STS_SUCCESS;

2448: x_msg_data OUT NOCOPY VARCHAR2 )
2449: IS
2450: BEGIN
2451:
2452: x_return_status := FND_API.G_RET_STS_SUCCESS;
2453:
2454: insert into PA_BUDGETARY_CONTROL_OPTIONS
2455: (
2456: PROJECT_TYPE,

Line 2506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2502: EXCEPTION
2503: WHEN NO_DATA_FOUND THEN
2504: null;
2505: WHEN OTHERS THEN
2506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2507: x_msg_count := 1;
2508: x_msg_data := substr(SQLERRM,1,240);
2509: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGET_FUND_PKG',
2510: p_procedure_name => 'copy_budgetary_controls');

Line 2530: x_return_status := FND_API.G_RET_STS_SUCCESS;

2526: l_temp_ret_status NUMBER;
2527: PRAGMA AUTONOMOUS_TRANSACTION;
2528: BEGIN
2529:
2530: x_return_status := FND_API.G_RET_STS_SUCCESS;
2531:
2532: log_message('entering release_bc_lock ..... ');
2533:
2534: l_temp_ret_status := pa_debug.release_user_lock('BSLNFCHKLOCK:'||to_char(p_project_id));

Line 2543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2539: log_message('exiting release_bc_lock ..... ');
2540:
2541: EXCEPTION
2542: WHEN OTHERS THEN
2543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2544: x_msg_count := 1;
2545: x_msg_data := substr(SQLERRM,1,240);
2546: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGET_FUND_PKG',
2547: p_procedure_name => 'release_bc_lock');

Line 3002: ,p_init_msg_list => FND_API.G_FALSE

2998: from dual;
2999:
3000: PSA_BC_XLA_PUB.Budgetary_Control
3001: (p_api_version => 1.0
3002: ,p_init_msg_list => FND_API.G_FALSE
3003: ,x_return_status => l_return_status
3004: ,x_msg_count => l_msg_count
3005: ,x_msg_data => l_msg_data
3006: ,p_application_id => 275