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 2007/02/06 10:00:11 dthakker 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 700: ( p_pkg_name => 'PA_FP_GEN_PUB'

696: WHEN OTHERS THEN
697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
698: x_msg_data := SUBSTR(SQLERRM,1,240);
699: FND_MSG_PUB.add_exc_msg
700: ( p_pkg_name => 'PA_FP_GEN_PUB'
701: ,p_procedure_name => 'INCLUDE_CHANGE_DOCUMENT_WRP');
702: IF P_PA_DEBUG_MODE = 'Y' THEN
703: PA_DEBUG.Reset_Curr_Function;
704: END IF;

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

714: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
715: X_MSG_COUNT OUT NOCOPY NUMBER,
716: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
717:
718: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_PUB.UNSPENT_AMOUNT';
719:
720: l_fp_cols_rec_app_cost PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
721:
722: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

Line 1456: ( p_pkg_name => 'PA_FP_GEN_PUB',

1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1453: x_msg_count := 1;
1454: x_msg_data := substr(sqlerrm,1,240);
1455: FND_MSG_PUB.ADD_EXC_MSG
1456: ( p_pkg_name => 'PA_FP_GEN_PUB',
1457: p_procedure_name => 'UNSPENT_AMOUNT',
1458: p_error_text => substr(sqlerrm,1,240) );
1459:
1460: IF p_pa_debug_mode = 'Y' THEN

Line 1545: ( p_pkg_name => 'PA_FP_GEN_PUB'

1541: WHEN OTHERS THEN
1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1543: x_msg_data := SUBSTR(SQLERRM,1,240);
1544: FND_MSG_PUB.add_exc_msg
1545: ( p_pkg_name => 'PA_FP_GEN_PUB'
1546: ,p_procedure_name => 'UPD_WBS_ELEMENT_VERSION_ID');
1547: IF P_PA_DEBUG_MODE = 'Y' THEN
1548: PA_DEBUG.Reset_Curr_Function;
1549: END IF;

Line 1760: ( p_pkg_name => 'PA_FP_GEN_PUB'

1756: WHEN OTHERS THEN
1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1758: x_msg_data := SUBSTR(SQLERRM,1,240);
1759: FND_MSG_PUB.add_exc_msg
1760: ( p_pkg_name => 'PA_FP_GEN_PUB'
1761: ,p_procedure_name => 'PRORATE_UNALIGNED_PERIOD_AMTS');
1762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1763: END PRORATE_UNALIGNED_PERIOD_AMTS;
1764:

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

1787: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1788: X_MSG_COUNT OUT NOCOPY NUMBER,
1789: X_MSG_DATA OUT NOCOPY VARCHAR2)
1790: IS
1791: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_GEN_PUB.MAINTAIN_FIXED_DATE_SP';
1792:
1793: /* String constant for the fixed date spread curve code */
1794: lc_FixedDate CONSTANT PA_SPREAD_CURVES_B.SPREAD_CURVE_CODE%TYPE := 'FIXED_DATE';
1795:

Line 1957: ( p_pkg_name => 'PA_FP_GEN_PUB',

1953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1954: x_msg_count := 1;
1955: x_msg_data := substr(sqlerrm,1,240);
1956: FND_MSG_PUB.ADD_EXC_MSG
1957: ( p_pkg_name => 'PA_FP_GEN_PUB',
1958: p_procedure_name => 'MAINTAIN_FIXED_DATE_SP',
1959: p_error_text => substr(sqlerrm,1,240) );
1960:
1961: IF p_pa_debug_mode = 'Y' THEN

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

1994: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1995: X_MSG_COUNT OUT NOCOPY NUMBER,
1996: X_MSG_DATA OUT NOCOPY VARCHAR2)
1997: IS
1998: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_GEN_PUB.' ||
1999: 'COPY_SRC_ATTRS_TO_TARGET_FCST';
2000: l_log_level CONSTANT PLS_INTEGER := 5;
2001:
2002: l_stru_sharing_code PA_PROJECTS_ALL.STRUCTURE_SHARING_CODE%TYPE;

Line 2284: ( p_pkg_name => 'PA_FP_GEN_PUB',

2280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2281: x_msg_count := 1;
2282: x_msg_data := substr(sqlerrm,1,240);
2283: FND_MSG_PUB.ADD_EXC_MSG
2284: ( p_pkg_name => 'PA_FP_GEN_PUB',
2285: p_procedure_name => 'COPY_SRC_ATTRS_TO_TARGET_FCST',
2286: p_error_text => substr(sqlerrm,1,240) );
2287:
2288: IF p_pa_debug_mode = 'Y' THEN

Line 2299: END PA_FP_GEN_PUB;

2295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2296:
2297: END COPY_SRC_ATTRS_TO_TARGET_FCST;
2298:
2299: END PA_FP_GEN_PUB;