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_FP_GEN_PUB dependencies on PA_FP_GEN_PUB

Line 1: PACKAGE body PA_FP_GEN_PUB as

1: PACKAGE body PA_FP_GEN_PUB as
2: /* $Header: PAFPGNPB.pls 120.6.12010000.2 2009/06/25 11:01:43 rthumma ship $ */
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: PROCEDURE UPDATE_RES_DEFAULTS

Line 15: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_PUB.UPDATE_RES_DEFAULTS';

11: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
12: X_MSG_COUNT OUT NOCOPY NUMBER,
13: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
14:
15: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_PUB.UPDATE_RES_DEFAULTS';
16:
17: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
18: l_last_update_login NUMBER := FND_GLOBAL.login_id;
19: l_sysdate DATE := SYSDATE;

Line 116: PA_DEBUG.init_err_stack('PA_FP_GEN_PUB.UPDATE_RES_DEFAULTS');

112: X_MSG_COUNT := 0;
113: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
114:
115: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
116: PA_DEBUG.init_err_stack('PA_FP_GEN_PUB.UPDATE_RES_DEFAULTS');
117: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
118: pa_debug.set_curr_function( p_function => 'UPDATE_RES_DEFAULTS'
119: ,p_debug_mode => p_pa_debug_mode);
120: END IF;

Line 455: ( p_pkg_name => 'PA_FP_GEN_PUB'

451: x_msg_data := SUBSTR(SQLERRM,1,240);
452: -- dbms_output.put_line('inside excep create res asg');
453: -- dbms_output.put_line(SUBSTR(SQLERRM,1,240));
454: FND_MSG_PUB.add_exc_msg
455: ( p_pkg_name => 'PA_FP_GEN_PUB'
456: ,p_procedure_name => 'UPDATE_RES_DEFAULTS');
457:
458: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
459: PA_DEBUG.reset_err_stack;

Line 473: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_PUB.INCLUDE_CHANGE_DOCUMENT_WRP';

469: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
470: X_MSG_COUNT OUT NOCOPY NUMBER,
471: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
472:
473: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_PUB.INCLUDE_CHANGE_DOCUMENT_WRP';
474:
475: l_ci_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.PA_NUM_TBL_TYPE();
476: l_translated_msgs_tbl SYSTEM.pa_varchar2_2000_tbl_type;
477: l_translated_err_msg_count NUMBER;

Line 713: ( p_pkg_name => 'PA_FP_GEN_PUB'

709: WHEN OTHERS THEN
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: x_msg_data := SUBSTR(SQLERRM,1,240);
712: FND_MSG_PUB.add_exc_msg
713: ( p_pkg_name => 'PA_FP_GEN_PUB'
714: ,p_procedure_name => 'INCLUDE_CHANGE_DOCUMENT_WRP');
715: IF P_PA_DEBUG_MODE = 'Y' THEN
716: PA_DEBUG.Reset_Curr_Function;
717: END IF;

Line 731: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_PUB.UNSPENT_AMOUNT';

727: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
728: X_MSG_COUNT OUT NOCOPY NUMBER,
729: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
730:
731: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_PUB.UNSPENT_AMOUNT';
732:
733: l_fp_cols_rec_app_cost PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
734:
735: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 1469: ( p_pkg_name => 'PA_FP_GEN_PUB',

1465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1466: x_msg_count := 1;
1467: x_msg_data := substr(sqlerrm,1,240);
1468: FND_MSG_PUB.ADD_EXC_MSG
1469: ( p_pkg_name => 'PA_FP_GEN_PUB',
1470: p_procedure_name => 'UNSPENT_AMOUNT',
1471: p_error_text => substr(sqlerrm,1,240) );
1472:
1473: IF p_pa_debug_mode = 'Y' THEN

Line 1558: ( p_pkg_name => 'PA_FP_GEN_PUB'

1554: WHEN OTHERS THEN
1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1556: x_msg_data := SUBSTR(SQLERRM,1,240);
1557: FND_MSG_PUB.add_exc_msg
1558: ( p_pkg_name => 'PA_FP_GEN_PUB'
1559: ,p_procedure_name => 'UPD_WBS_ELEMENT_VERSION_ID');
1560: IF P_PA_DEBUG_MODE = 'Y' THEN
1561: PA_DEBUG.Reset_Curr_Function;
1562: END IF;

Line 1773: ( p_pkg_name => 'PA_FP_GEN_PUB'

1769: WHEN OTHERS THEN
1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1771: x_msg_data := SUBSTR(SQLERRM,1,240);
1772: FND_MSG_PUB.add_exc_msg
1773: ( p_pkg_name => 'PA_FP_GEN_PUB'
1774: ,p_procedure_name => 'PRORATE_UNALIGNED_PERIOD_AMTS');
1775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1776: END PRORATE_UNALIGNED_PERIOD_AMTS;
1777:

Line 1804: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_GEN_PUB.MAINTAIN_FIXED_DATE_SP';

1800: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1801: X_MSG_COUNT OUT NOCOPY NUMBER,
1802: X_MSG_DATA OUT NOCOPY VARCHAR2)
1803: IS
1804: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_GEN_PUB.MAINTAIN_FIXED_DATE_SP';
1805:
1806: /* String constant for the fixed date spread curve code */
1807: lc_FixedDate CONSTANT PA_SPREAD_CURVES_B.SPREAD_CURVE_CODE%TYPE := 'FIXED_DATE';
1808:

Line 1970: ( p_pkg_name => 'PA_FP_GEN_PUB',

1966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1967: x_msg_count := 1;
1968: x_msg_data := substr(sqlerrm,1,240);
1969: FND_MSG_PUB.ADD_EXC_MSG
1970: ( p_pkg_name => 'PA_FP_GEN_PUB',
1971: p_procedure_name => 'MAINTAIN_FIXED_DATE_SP',
1972: p_error_text => substr(sqlerrm,1,240) );
1973:
1974: IF p_pa_debug_mode = 'Y' THEN

Line 2011: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_GEN_PUB.' ||

2007: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2008: X_MSG_COUNT OUT NOCOPY NUMBER,
2009: X_MSG_DATA OUT NOCOPY VARCHAR2)
2010: IS
2011: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_GEN_PUB.' ||
2012: 'COPY_SRC_ATTRS_TO_TARGET_FCST';
2013: l_log_level CONSTANT PLS_INTEGER := 5;
2014:
2015: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

Line 2297: ( p_pkg_name => 'PA_FP_GEN_PUB',

2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2294: x_msg_count := 1;
2295: x_msg_data := substr(sqlerrm,1,240);
2296: FND_MSG_PUB.ADD_EXC_MSG
2297: ( p_pkg_name => 'PA_FP_GEN_PUB',
2298: p_procedure_name => 'COPY_SRC_ATTRS_TO_TARGET_FCST',
2299: p_error_text => substr(sqlerrm,1,240) );
2300:
2301: IF p_pa_debug_mode = 'Y' THEN

Line 2312: END PA_FP_GEN_PUB;

2308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2309:
2310: END COPY_SRC_ATTRS_TO_TARGET_FCST;
2311:
2312: END PA_FP_GEN_PUB;