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_COPY_ACTUALS_PUB dependencies on PA_FP_COPY_ACTUALS_PUB

Line 1: PACKAGE body PA_FP_COPY_ACTUALS_PUB as

1: PACKAGE body PA_FP_COPY_ACTUALS_PUB as
2: /* $Header: PAFPCAPB.pls 120.10.12020000.4 2013/05/23 07:28:09 bpottipa ship $ */
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: /**This procedure is called to copy actuals to budget version lines**/

Line 17: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_actuals_pub.copy_actuals';

13: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
14: X_MSG_COUNT OUT NOCOPY NUMBER,
15: X_MSG_DATA OUT NOCOPY VARCHAR2)
16: IS
17: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_actuals_pub.copy_actuals';
18: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
19: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
20: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
21: l_calendar_type_tab SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type();

Line 782: (p_msg => 'Before calling pa_fp_copy_actuals_pub.create_res_asg',

778: -- budget_version_id = p_budget_version_id;
779: --dbms_output.put_line('before calling cre res asg api: res_assign has: '||l_count);
780: IF P_PA_DEBUG_MODE = 'Y' THEN
781: pa_fp_gen_amount_utils.fp_debug
782: (p_msg => 'Before calling pa_fp_copy_actuals_pub.create_res_asg',
783: p_module_name => l_module_name,
784: p_log_level => 5);
785: END IF;
786: PA_FP_COPY_ACTUALS_PUB.CREATE_RES_ASG (

Line 786: PA_FP_COPY_ACTUALS_PUB.CREATE_RES_ASG (

782: (p_msg => 'Before calling pa_fp_copy_actuals_pub.create_res_asg',
783: p_module_name => l_module_name,
784: p_log_level => 5);
785: END IF;
786: PA_FP_COPY_ACTUALS_PUB.CREATE_RES_ASG (
787: P_PROJECT_ID => P_PROJECT_ID,
788: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
789: P_FP_COLS_REC => P_FP_COLS_REC,
790: X_RETURN_STATUS => x_return_status,

Line 813: PA_FP_COPY_ACTUALS_PUB.UPDATE_RES_ASG (

809: (p_msg => 'Before calling update_res_asg',
810: p_module_name => l_module_name,
811: p_log_level => 5);
812: END IF;
813: PA_FP_COPY_ACTUALS_PUB.UPDATE_RES_ASG (
814: P_PROJECT_ID => P_PROJECT_ID,
815: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
816: P_FP_COLS_REC => P_FP_COLS_REC,
817: X_RETURN_STATUS => x_return_status,

Line 1209: ( p_pkg_name => 'PA_FP_COPY_ACTUALS_PUB',

1205: x_msg_count := 1;
1206: x_msg_data := substr(sqlerrm,1,240);
1207: -- dbms_output.put_line('error msg :'||x_msg_data);
1208: FND_MSG_PUB.add_exc_msg
1209: ( p_pkg_name => 'PA_FP_COPY_ACTUALS_PUB',
1210: p_procedure_name => 'COPY_ACTUALS',
1211: p_error_text => substr(sqlerrm,1,240));
1212:
1213: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1234: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_actuals_pub.create_res_asg';

1230: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1231: X_MSG_COUNT OUT NOCOPY NUMBER,
1232: X_MSG_DATA OUT NOCOPY VARCHAR2)
1233: IS
1234: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_actuals_pub.create_res_asg';
1235:
1236: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
1237: l_res_plan_level VARCHAR2(15);
1238:

Line 1802: ( p_pkg_name => 'PA_FP_COPY_ACTUALS_PUB',

1798: x_msg_count := 1;
1799: x_msg_data := substr(sqlerrm,1,240);
1800: -- dbms_output.put_line('error msg :'||x_msg_data);
1801: FND_MSG_PUB.add_exc_msg
1802: ( p_pkg_name => 'PA_FP_COPY_ACTUALS_PUB',
1803: p_procedure_name => 'CREATE_RES_ASG',
1804: p_error_text => substr(sqlerrm,1,240));
1805:
1806: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1826: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_actuals_pub.update_res_asg';

1822: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1823: X_MSG_COUNT OUT NOCOPY NUMBER,
1824: X_MSG_DATA OUT NOCOPY VARCHAR2)
1825: IS
1826: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_actuals_pub.update_res_asg';
1827: l_res_plan_level VARCHAR2(15);
1828:
1829: l_count NUMBER;
1830: l_msg_count NUMBER;

Line 1972: ( p_pkg_name => 'PA_FP_COPY_ACTUALS_PUB',

1968: x_msg_count := 1;
1969: x_msg_data := substr(sqlerrm,1,240);
1970: -- dbms_output.put_line('error msg :'||x_msg_data);
1971: FND_MSG_PUB.add_exc_msg
1972: ( p_pkg_name => 'PA_FP_COPY_ACTUALS_PUB',
1973: p_procedure_name => 'UPDATE_RES_ASG',
1974: p_error_text => substr(sqlerrm,1,240));
1975:
1976: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2001: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_actuals_pub.collect_actuals';

1997: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1998: X_MSG_COUNT OUT NOCOPY NUMBER,
1999: X_MSG_DATA OUT NOCOPY VARCHAR2)
2000: IS
2001: l_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_copy_actuals_pub.collect_actuals';
2002: l_msg_count NUMBER;
2003: l_msg_data VARCHAR2(2000);
2004: l_data VARCHAR2(2000);
2005: l_msg_index_out NUMBER:=0;

Line 2999: ( p_pkg_name => 'PA_FP_COPY_ACTUALS_PUB',

2995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2996: x_msg_count := 1;
2997: x_msg_data := substr(sqlerrm,1,240);
2998: FND_MSG_PUB.add_exc_msg
2999: ( p_pkg_name => 'PA_FP_COPY_ACTUALS_PUB',
3000: p_procedure_name => 'COLLECT_ACTUALS',
3001: p_error_text => substr(sqlerrm,1,240));
3002:
3003: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3014: END PA_FP_COPY_ACTUALS_PUB;

3010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3011:
3012: END COLLECT_ACTUALS;
3013:
3014: END PA_FP_COPY_ACTUALS_PUB;