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_PLANNING_TRANSACTION_PUB dependencies on PA_FP_PLANNING_TRANSACTION_PUB

Line 1: PACKAGE body pa_fp_planning_transaction_pub AS

1: PACKAGE body pa_fp_planning_transaction_pub AS
2: /* $Header: PAFPPTPB.pls 120.33.12010000.5 2008/09/22 02:38:26 kmaddi ship $ */
3: g_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_PLANNING_TRANSACTION_PUB';
4:
5: --This pl/sql table will be used by the method get_rbs_element_id. This should not be used in other procedures

Line 3: g_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_PLANNING_TRANSACTION_PUB';

1: PACKAGE body pa_fp_planning_transaction_pub AS
2: /* $Header: PAFPPTPB.pls 120.33.12010000.5 2008/09/22 02:38:26 kmaddi ship $ */
3: g_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_PLANNING_TRANSACTION_PUB';
4:
5: --This pl/sql table will be used by the method get_rbs_element_id. This should not be used in other procedures
6: -- l_ra_id_rbs_element_id_map_tbl PA_PLSQL_DATATYPES.IdTabTyp;
7:

Line 1016: pa_fp_planning_transaction_pub.delete_planning_transactions

1012: pa_debug.write(l_module_name,pa_debug.g_err_stage, 5);
1013: END IF;
1014: --dbms_output.put_line('7.5');
1015:
1016: pa_fp_planning_transaction_pub.delete_planning_transactions
1017: (
1018: p_context => p_context
1019: ,p_calling_context => p_calling_context -- Added for Bug 6856934
1020: ,p_task_or_res => 'ASSIGNMENT'

Line 1176: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'

1172: WHEN OTHERS THEN
1173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1174: x_msg_count := 1;
1175: x_msg_data := SQLERRM;
1176: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
1177: ,p_procedure_name => 'Process_res_chg_Derv_calc_prms');
1178:
1179: IF l_debug_mode = 'Y' THEN
1180: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 1565: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

1561: ,PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET ) THEN
1562:
1563: IF l_debug_mode = 'Y' THEN
1564: pa_debug.g_err_stage:='p_context passed is '||p_context;
1565: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1566: END IF;
1567: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1568: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1569: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 1580: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

1576: IF (p_one_to_one_mapping_flag = 'Y'
1577: AND p_context = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_WORKPLAN) THEN
1578: IF l_debug_mode = 'Y' THEN
1579: pa_debug.g_err_stage:='p_one_to_one_mapping_flag passed as Y for WORKPLAN context :'||p_context;
1580: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1581: END IF;
1582: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1583: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1584: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 1596: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

1592: p_task_elem_version_id_tbl.COUNT <> p_resource_list_member_id_tbl.COUNT) THEN
1593:
1594: IF l_debug_mode = 'Y' THEN
1595: pa_debug.g_err_stage:='Table Count Mismatch for p_one_to_one_mapping_flag Y in : '||p_context;
1596: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1597: END IF;
1598: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1599: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1600: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 1612: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

1608: (p_planning_start_date_tbl.COUNT <> 0 OR p_planning_end_date_tbl.COUNT <> 0)) THEN
1609:
1610: IF l_debug_mode = 'Y' THEN
1611: pa_debug.g_err_stage:='Planning Date Passed when one to one mapping is N';
1612: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1613: END IF;
1614: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1615: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
1616: p_token1 => 'PROCEDURENAME',

Line 1629: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

1625: -- number of records
1626: IF (p_planning_start_date_tbl.COUNT <> p_planning_end_date_tbl.COUNT) THEN
1627: IF l_debug_mode = 'Y' THEN
1628: pa_debug.g_err_stage:='Planning Start Date - End Date MISMATCH p_context :'||p_context;
1629: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1630: END IF;
1631: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1632: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
1633: p_token1 => 'PROCEDURENAME',

Line 1646: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

1642: IF (p_planning_start_date_tbl.COUNT >0) THEN
1643: IF (p_planning_start_date_tbl.COUNT <> p_task_elem_version_id_tbl.COUNT) THEN
1644: IF l_debug_mode = 'Y' THEN
1645: pa_debug.g_err_stage:='Planning Start Date - Task Elem Mismatch :'||p_context;
1646: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1647: END IF;
1648: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1649: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
1650: p_token1 => 'PROCEDURENAME',

Line 1665: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

1661: IF p_one_to_one_mapping_flag = 'N' THEN
1662: IF p_skip_duplicates_flag = 'N' THEN
1663: IF l_debug_mode = 'Y' THEN
1664: pa_debug.g_err_stage:='Checking for duplicate rlm ids passed';
1665: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1666: END IF;
1667: IF p_resource_list_member_id_tbl.COUNT > 0 THEN
1668: FOR i IN p_resource_list_member_id_tbl.FIRST .. (p_resource_list_member_id_tbl.LAST-1) LOOP
1669: FOR j in (i+1) .. p_resource_list_member_id_tbl.LAST LOOP

Line 1673: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

1669: FOR j in (i+1) .. p_resource_list_member_id_tbl.LAST LOOP
1670: IF p_resource_list_member_id_tbl(j) = p_resource_list_member_id_tbl(i) THEN
1671: IF l_debug_mode = 'Y' THEN
1672: pa_debug.g_err_stage:='Dup RLM ID Passed';
1673: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1674: END IF;
1675: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1676: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
1677: p_token1 => 'PROCEDURENAME',

Line 1688: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

1684: END LOOP;
1685: END IF;
1686: IF l_debug_mode = 'Y' THEN
1687: pa_debug.g_err_stage:='Checking for duplicate elem ver ids passed';
1688: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1689: END IF;
1690: IF p_task_elem_version_id_tbl.COUNT > 0 THEN
1691: FOR i IN p_task_elem_version_id_tbl.FIRST .. (p_task_elem_version_id_tbl.LAST-1) LOOP
1692: FOR j in (i+1) .. p_task_elem_version_id_tbl.LAST LOOP

Line 1696: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

1692: FOR j in (i+1) .. p_task_elem_version_id_tbl.LAST LOOP
1693: IF p_task_elem_version_id_tbl(j) = p_task_elem_version_id_tbl(i) THEN
1694: IF l_debug_mode = 'Y' THEN
1695: pa_debug.g_err_stage:='Dup ELEM VER ID Passed';
1696: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1697: END IF;
1698: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1699: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
1700: p_token1 => 'PROCEDURENAME',

Line 1726: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

1722: (p_currency_code_tbl(i) = p_currency_code_tbl(j))) THEN
1723:
1724: IF l_debug_mode = 'Y' THEN
1725: pa_debug.g_err_stage:='Dup Rec passed - Curr Code (B/F) - will error out in Ins Stat';
1726: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1727: END IF;
1728: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1729: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
1730: p_token1 => 'PROCEDURENAME',

Line 1749: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

1745: (p_resource_list_member_id_tbl(i) = p_resource_list_member_id_tbl(j))) THEN
1746:
1747: IF l_debug_mode = 'Y' THEN
1748: pa_debug.g_err_stage:='Dup Rec passed - will error out in Ins Stat p_context :'||p_context;
1749: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1750: END IF;
1751: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1752: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
1753: p_token1 => 'PROCEDURENAME',

Line 1770: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

1766: IF l_debug_mode = 'Y' THEN
1767: IF p_task_elem_version_id_tbl.COUNT > 0 THEN
1768: FOR i in p_task_elem_version_id_tbl.FIRST .. p_task_elem_version_id_tbl.LAST LOOP
1769: pa_debug.g_err_stage:='p_task_elem_version_id_tbl :'||p_task_elem_version_id_tbl(i);
1770: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1771: END LOOP;
1772: END IF;
1773:
1774: IF p_resource_list_member_id_tbl.COUNT > 0 THEN

Line 1777: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

1773:
1774: IF p_resource_list_member_id_tbl.COUNT > 0 THEN
1775: FOR i in p_resource_list_member_id_tbl.FIRST .. p_resource_list_member_id_tbl.LAST LOOP
1776: pa_debug.g_err_stage:='p_resource_list_member_id_tbl :'||p_resource_list_member_id_tbl(i);
1777: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1778: END LOOP;
1779: END IF;
1780:
1781: IF p_currency_code_tbl.COUNT > 0 THEN

Line 1784: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

1780:
1781: IF p_currency_code_tbl.COUNT > 0 THEN
1782: FOR i in p_currency_code_tbl.FIRST .. p_currency_code_tbl.LAST LOOP
1783: pa_debug.g_err_stage:='p_currency_code_tbl :'||p_currency_code_tbl(i);
1784: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1785: END LOOP;
1786: END IF;
1787: END IF;
1788:

Line 1806: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

1802: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
1803:
1804: IF l_debug_mode = 'Y' THEN
1805: pa_debug.g_err_stage:='Extending all table lengths to the permissible values they would take - p_context = '||p_context;
1806: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1807: END IF;
1808:
1809: l_task_elem_rlm_tbl.extend(l_rlm_id_no_of_rows);
1810: l_proj_elem_rlm_tbl.extend(l_rlm_id_no_of_rows);

Line 1968: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

1964: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
1965:
1966: IF l_debug_mode = 'Y' THEN
1967: pa_debug.g_err_stage:='Validating input parameters - count of p_task_elem_version_id_tbl = '||l_elem_version_id_count;
1968: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1969: END IF;
1970:
1971: IF l_elem_version_id_count = 0 THEN
1972: l_trace_stage := 150;

Line 1976: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

1972: l_trace_stage := 150;
1973: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
1974: IF l_debug_mode = 'Y' THEN
1975: pa_debug.g_err_stage:='Validating input parameters - elem_version_id table is empty - p_context = '||p_context;
1976: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1977: --dbms_output.put_line('Tasks tbl is empty for BF -- returning');
1978: pa_debug.reset_curr_function;
1979: END IF;
1980: RETURN;

Line 1993: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

1989: (p_start_date_tbl.COUNT <> p_task_elem_version_id_tbl.COUNT) THEN
1990:
1991: IF l_debug_mode = 'Y' THEN
1992: pa_debug.g_err_stage:='Invalid pl/sql tables for start and end dates';
1993: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1994: END IF;
1995: --dbms_output.put_line('$$$$%%%');
1996: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1997: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 2012: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2008: l_rlm_id_tbl_count := p_resource_list_member_id_tbl.COUNT;
2009:
2010: IF l_debug_mode = 'Y' THEN
2011: pa_debug.g_err_stage:='Validating input parameters - count of p_resource_list_member_id_tbl = '||l_rlm_id_tbl_count;
2012: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2013: END IF;
2014:
2015: IF l_rlm_id_tbl_count = 0 THEN
2016:

Line 2019: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2015: IF l_rlm_id_tbl_count = 0 THEN
2016:
2017: IF l_debug_mode = 'Y' THEN
2018: pa_debug.g_err_stage:='Validating input parameters - Resource List Member Id table is empty - p_context = '||p_context;
2019: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2020: --dbms_output.put_line('Rlm tbl is empty for BF -- returning');
2021: pa_debug.reset_curr_function;
2022: END IF;
2023: RETURN;

Line 2035: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2031: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2032:
2033: IF l_debug_mode = 'Y' THEN
2034: pa_debug.g_err_stage:='Validating input parameters - checking for project id : ' || p_project_id;
2035: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2036: END IF;
2037:
2038: l_trace_stage := 50;
2039: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));

Line 2047: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2043: -------------------------------------------------------------------------------------------
2044: IF (p_project_id IS NULL) THEN
2045: IF l_debug_mode = 'Y' THEN
2046: pa_debug.g_err_stage:='p_project_id is null';
2047: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2048: END IF;
2049: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2050: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
2051: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 2072: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2068: IF p_struct_elem_version_id IS NULL THEN
2069:
2070: IF l_debug_mode = 'Y' THEN
2071: pa_debug.g_err_stage:='p_struct_elem_version_id is NULL and p_context = ' || p_context;
2072: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2073: END IF;
2074: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2075: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
2076: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 2085: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2081: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2082:
2083: IF l_debug_mode = 'Y' THEN
2084: pa_debug.g_err_stage:='calling pa_planning_transaction_utils.get_wp_budget_version_id p_struct_elem_version_id = ' || p_struct_elem_version_id;
2085: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2086: pa_debug.g_err_stage:='calling pa_planning_transaction_utils.get_wp_budget_version_id for deriving budget_version_id = ' || p_context;
2087: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2088: END IF;
2089:

Line 2087: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2083: IF l_debug_mode = 'Y' THEN
2084: pa_debug.g_err_stage:='calling pa_planning_transaction_utils.get_wp_budget_version_id p_struct_elem_version_id = ' || p_struct_elem_version_id;
2085: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2086: pa_debug.g_err_stage:='calling pa_planning_transaction_utils.get_wp_budget_version_id for deriving budget_version_id = ' || p_context;
2087: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2088: END IF;
2089:
2090: l_budget_version_id := pa_planning_transaction_utils.get_wp_budget_version_id(p_struct_elem_version_id);
2091:

Line 2094: pa_fp_planning_transaction_pub.add_wp_plan_type

2090: l_budget_version_id := pa_planning_transaction_utils.get_wp_budget_version_id(p_struct_elem_version_id);
2091:
2092: l_trace_stage := 90;
2093: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2094: pa_fp_planning_transaction_pub.add_wp_plan_type
2095: (p_src_project_id => p_project_id
2096: ,p_targ_project_id => p_project_id
2097: ,x_return_status => x_return_status
2098: ,x_msg_count => x_msg_count

Line 2106: pa_debug.g_err_stage:='Called API pa_fp_planning_transaction_pub.add_wp_plan_type api returned error';

2102:
2103: -- 4504452.Added this if codition to get the return status.
2104: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2105: IF l_debug_mode = 'Y' THEN
2106: pa_debug.g_err_stage:='Called API pa_fp_planning_transaction_pub.add_wp_plan_type api returned error';
2107: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2108: END IF;
2109: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2110: END IF;

Line 2107: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2103: -- 4504452.Added this if codition to get the return status.
2104: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2105: IF l_debug_mode = 'Y' THEN
2106: pa_debug.g_err_stage:='Called API pa_fp_planning_transaction_pub.add_wp_plan_type api returned error';
2107: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2108: END IF;
2109: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2110: END IF;
2111: -----------------------------------------------------

Line 2120: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2116: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2117:
2118: IF l_debug_mode = 'Y' THEN
2119: pa_debug.g_err_stage:='calling pa_fin_plan_pub.create_version api = ' || p_context;
2120: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2121: END IF;
2122:
2123: SELECT fin_plan_type_id
2124: INTO l_fin_plan_type_id

Line 2175: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2171: l_trace_stage := 120;
2172: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2173: IF l_debug_mode = 'Y' THEN
2174: pa_debug.g_err_stage:=' API pa_fin_plan_pub.create_version api return Status : '||l_return_status;
2175: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2176: pa_debug.g_err_stage:=' API pa_fin_plan_pub.create_version api l_budget_version_id : '||l_budget_version_id;
2177: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2178: pa_debug.g_err_stage:=' API pa_fin_plan_pub.create_version api l_proj_fp_options_id : '||l_proj_fp_options_id;
2179: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 2177: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2173: IF l_debug_mode = 'Y' THEN
2174: pa_debug.g_err_stage:=' API pa_fin_plan_pub.create_version api return Status : '||l_return_status;
2175: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2176: pa_debug.g_err_stage:=' API pa_fin_plan_pub.create_version api l_budget_version_id : '||l_budget_version_id;
2177: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2178: pa_debug.g_err_stage:=' API pa_fin_plan_pub.create_version api l_proj_fp_options_id : '||l_proj_fp_options_id;
2179: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2180: END IF;
2181:

Line 2179: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2175: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2176: pa_debug.g_err_stage:=' API pa_fin_plan_pub.create_version api l_budget_version_id : '||l_budget_version_id;
2177: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2178: pa_debug.g_err_stage:=' API pa_fin_plan_pub.create_version api l_proj_fp_options_id : '||l_proj_fp_options_id;
2179: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2180: END IF;
2181:
2182: l_trace_stage := 130;
2183: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));

Line 2188: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2184:
2185: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2186: IF l_debug_mode = 'Y' THEN
2187: pa_debug.g_err_stage:='Called API pa_fin_plan_pub.create_version api returned error';
2188: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2189: END IF;
2190: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2191: END IF;
2192:

Line 2197: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2193: END IF;
2194:
2195: IF l_debug_mode = 'Y' THEN
2196: pa_debug.g_err_stage:='l_budget_version_id, l_fin_plan_type_id = '||l_budget_version_id||','|| l_fin_plan_type_id;
2197: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2198: END IF;
2199:
2200: END IF;
2201:

Line 2209: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2205: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2206:
2207: IF l_debug_mode = 'Y' THEN
2208: pa_debug.g_err_stage:='Validating input parameters - count of p_task_elem_version_id_tbl = '||l_elem_version_id_count;
2209: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2210: END IF;
2211:
2212: IF l_elem_version_id_count = 0 THEN
2213: l_trace_stage := 150;

Line 2217: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2213: l_trace_stage := 150;
2214: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2215: IF l_debug_mode = 'Y' THEN
2216: pa_debug.g_err_stage:='Validating input parameters - elem_version_id table is empty - p_context = '||p_context;
2217: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2218: pa_debug.reset_curr_function;
2219: END IF;
2220: RETURN;
2221: END IF;

Line 2233: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2229: IF p_budget_version_id IS NULL THEN
2230:
2231: IF l_debug_mode = 'Y' THEN
2232: pa_debug.g_err_stage:='p_budget_version_id is null for p_context :' || p_context;
2233: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2234: END IF;
2235: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2236: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
2237: --dbms_output.put_line('bv id is null for BF');

Line 2251: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2247: END IF;
2248:
2249: IF l_debug_mode = 'Y' THEN
2250: pa_debug.g_err_stage:='Fetching resource List id - l_resource_list_id : ';
2251: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2252: END IF;
2253: l_trace_stage := 200;
2254: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2255: --dbms_output.put_line('2.3 '||l_budget_version_id);

Line 2267: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2263: WHERE fin_plan_version_id=l_budget_version_id;
2264:
2265: IF l_debug_mode = 'Y' THEN
2266: pa_debug.g_err_stage:='Fetching resource List id - l_resource_list_id : '|| l_resource_list_id;
2267: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2268: END IF;
2269:
2270: -- Fetching spread curve id for fixed date spread curve : Bug 3607061 - Starts
2271: BEGIN

Line 2274: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2270: -- Fetching spread curve id for fixed date spread curve : Bug 3607061 - Starts
2271: BEGIN
2272: IF l_debug_mode = 'Y' THEN
2273: pa_debug.g_err_stage:='Fetching spread curve id for fixed date spread curve';
2274: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2275: END IF;
2276: Select spread_curve_id
2277: into l_fixed_date_sp_id
2278: from pa_spread_curves_b

Line 2283: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2279: where spread_curve_code = 'FIXED_DATE';
2280:
2281: IF l_debug_mode = 'Y' THEN
2282: pa_debug.g_err_stage:='Fetching spread curve id l_fixed_date_sp_id:'||l_fixed_date_sp_id;
2283: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2284: END IF;
2285:
2286: EXCEPTION
2287: WHEN NO_DATA_FOUND THEN

Line 2290: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,5);

2286: EXCEPTION
2287: WHEN NO_DATA_FOUND THEN
2288: IF l_debug_mode = 'Y' THEN
2289: pa_debug.g_err_stage:='Fixed date spread curve not found in system';
2290: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,5);
2291: END IF;
2292: RAISE;
2293: END;
2294: -- Fetching spread curve id for fixed date spread curve : Bug 3607061 - Ends

Line 2313: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2309: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2310:
2311: IF l_debug_mode = 'Y' THEN
2312: pa_debug.g_err_stage:='Calling API pa_planning_transaction_utils.Get_Res_Class_Rlm_Ids';
2313: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2314: END IF;
2315:
2316: pa_planning_transaction_utils.Get_Res_Class_Rlm_Ids
2317: (p_project_id => p_project_id,

Line 2331: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2327: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2328: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2329: IF l_debug_mode = 'Y' THEN
2330: pa_debug.g_err_stage:='Called API pa_planning_transaction_utils.Get_Res_Class_Rlm_Ids api returned error';
2331: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2332: END IF;
2333: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2334: END IF;
2335:

Line 2341: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2337: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2338:
2339: IF l_debug_mode = 'Y' THEN
2340: pa_debug.g_err_stage:='l_people_res_class_rlm_id : '||l_people_res_class_rlm_id;
2341: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2342: END IF;
2343:
2344: l_eligible_rlm_ids_tbl(1) := l_people_res_class_rlm_id;
2345:

Line 2397: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2393: --------------------------------------------------------------------
2394:
2395: IF l_debug_mode = 'Y' THEN
2396: pa_debug.g_err_stage:='Calling API PA_PLANNING_RESOURCE_UTILS.get_resource_defaults';
2397: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2398: END IF;
2399:
2400: l_trace_stage := 300;
2401: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));

Line 2447: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2443: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2444:
2445: IF l_debug_mode = 'Y' THEN
2446: pa_debug.g_err_stage:='Called APIPA_PLANNING_RESOURCE_UTILS.get_resource_defaults api returned error';
2447: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2448: END IF;
2449: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2450:
2451: END IF;

Line 2457: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2453: IF l_debug_mode = 'Y' THEN
2454:
2455: IF l_eligible_rlm_ids_tbl.COUNT >0 THEN
2456: pa_debug.g_err_stage:='Parameters to PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs';
2457: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2458:
2459:
2460: pa_debug.g_err_stage:='p_budget_version_id '||l_budget_version_id;
2461: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 2461: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2457: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2458:
2459:
2460: pa_debug.g_err_stage:='p_budget_version_id '||l_budget_version_id;
2461: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2462:
2463: pa_debug.g_err_stage:='l_resource_list_id '||l_resource_list_id;
2464: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2465:

Line 2464: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2460: pa_debug.g_err_stage:='p_budget_version_id '||l_budget_version_id;
2461: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2462:
2463: pa_debug.g_err_stage:='l_resource_list_id '||l_resource_list_id;
2464: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2465:
2466: pa_debug.g_err_stage:='l_rbs_version_id '||l_rbs_version_id;
2467: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2468:

Line 2467: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2463: pa_debug.g_err_stage:='l_resource_list_id '||l_resource_list_id;
2464: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2465:
2466: pa_debug.g_err_stage:='l_rbs_version_id '||l_rbs_version_id;
2467: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2468:
2469: pa_debug.g_err_stage:='l_eligible_rlm_ids_tbl(1) '||l_eligible_rlm_ids_tbl(1);
2470: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2471:

Line 2470: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2466: pa_debug.g_err_stage:='l_rbs_version_id '||l_rbs_version_id;
2467: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2468:
2469: pa_debug.g_err_stage:='l_eligible_rlm_ids_tbl(1) '||l_eligible_rlm_ids_tbl(1);
2470: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2471:
2472: pa_debug.g_err_stage:='l_txn_src_typ_code_rbs_prm_tbl(1) '||l_txn_src_typ_code_rbs_prm_tbl(1);
2473: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2474:

Line 2473: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2469: pa_debug.g_err_stage:='l_eligible_rlm_ids_tbl(1) '||l_eligible_rlm_ids_tbl(1);
2470: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2471:
2472: pa_debug.g_err_stage:='l_txn_src_typ_code_rbs_prm_tbl(1) '||l_txn_src_typ_code_rbs_prm_tbl(1);
2473: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2474:
2475: pa_debug.g_err_stage:='l_person_id_tbl(1) '||l_person_id_tbl(1);
2476: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2477:

Line 2476: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2472: pa_debug.g_err_stage:='l_txn_src_typ_code_rbs_prm_tbl(1) '||l_txn_src_typ_code_rbs_prm_tbl(1);
2473: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2474:
2475: pa_debug.g_err_stage:='l_person_id_tbl(1) '||l_person_id_tbl(1);
2476: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2477:
2478: pa_debug.g_err_stage:='l_job_id_tbl(1) '||l_job_id_tbl(1);
2479: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2480:

Line 2479: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2475: pa_debug.g_err_stage:='l_person_id_tbl(1) '||l_person_id_tbl(1);
2476: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2477:
2478: pa_debug.g_err_stage:='l_job_id_tbl(1) '||l_job_id_tbl(1);
2479: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2480:
2481: pa_debug.g_err_stage:='l_organization_id_tbl(1) '||l_organization_id_tbl(1);
2482: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2483:

Line 2482: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2478: pa_debug.g_err_stage:='l_job_id_tbl(1) '||l_job_id_tbl(1);
2479: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2480:
2481: pa_debug.g_err_stage:='l_organization_id_tbl(1) '||l_organization_id_tbl(1);
2482: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2483:
2484: pa_debug.g_err_stage:='l_supplier_id_tbl(1) '||l_supplier_id_tbl(1);
2485: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2486:

Line 2485: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2481: pa_debug.g_err_stage:='l_organization_id_tbl(1) '||l_organization_id_tbl(1);
2482: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2483:
2484: pa_debug.g_err_stage:='l_supplier_id_tbl(1) '||l_supplier_id_tbl(1);
2485: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2486:
2487: pa_debug.g_err_stage:='l_expenditure_type_tbl(1) '||l_expenditure_type_tbl(1);
2488: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2489:

Line 2488: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2484: pa_debug.g_err_stage:='l_supplier_id_tbl(1) '||l_supplier_id_tbl(1);
2485: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2486:
2487: pa_debug.g_err_stage:='l_expenditure_type_tbl(1) '||l_expenditure_type_tbl(1);
2488: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2489:
2490: pa_debug.g_err_stage:='l_event_type_tbl(1) '||l_event_type_tbl(1);
2491: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2492:

Line 2491: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2487: pa_debug.g_err_stage:='l_expenditure_type_tbl(1) '||l_expenditure_type_tbl(1);
2488: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2489:
2490: pa_debug.g_err_stage:='l_event_type_tbl(1) '||l_event_type_tbl(1);
2491: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2492:
2493: pa_debug.g_err_stage:='l_expenditure_category_tbl(1) '||l_expenditure_category_tbl(1);
2494: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2495:

Line 2494: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2490: pa_debug.g_err_stage:='l_event_type_tbl(1) '||l_event_type_tbl(1);
2491: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2492:
2493: pa_debug.g_err_stage:='l_expenditure_category_tbl(1) '||l_expenditure_category_tbl(1);
2494: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2495:
2496: pa_debug.g_err_stage:='l_revenue_category_code_tbl(1) '||l_revenue_category_code_tbl(1);
2497: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2498:

Line 2497: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2493: pa_debug.g_err_stage:='l_expenditure_category_tbl(1) '||l_expenditure_category_tbl(1);
2494: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2495:
2496: pa_debug.g_err_stage:='l_revenue_category_code_tbl(1) '||l_revenue_category_code_tbl(1);
2497: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2498:
2499: pa_debug.g_err_stage:='l_project_role_id_tbl(1) '||l_project_role_id_tbl(1);
2500: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2501:

Line 2500: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2496: pa_debug.g_err_stage:='l_revenue_category_code_tbl(1) '||l_revenue_category_code_tbl(1);
2497: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2498:
2499: pa_debug.g_err_stage:='l_project_role_id_tbl(1) '||l_project_role_id_tbl(1);
2500: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2501:
2502: pa_debug.g_err_stage:='l_resource_class_code_tbl(1) '||l_resource_class_code_tbl(1);
2503: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2504:

Line 2503: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2499: pa_debug.g_err_stage:='l_project_role_id_tbl(1) '||l_project_role_id_tbl(1);
2500: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2501:
2502: pa_debug.g_err_stage:='l_resource_class_code_tbl(1) '||l_resource_class_code_tbl(1);
2503: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2504:
2505: pa_debug.g_err_stage:='l_item_category_id_tbl(1) '||l_item_category_id_tbl(1);
2506: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2507:

Line 2506: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2502: pa_debug.g_err_stage:='l_resource_class_code_tbl(1) '||l_resource_class_code_tbl(1);
2503: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2504:
2505: pa_debug.g_err_stage:='l_item_category_id_tbl(1) '||l_item_category_id_tbl(1);
2506: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2507:
2508: pa_debug.g_err_stage:='l_person_type_code_tbl(1) '||l_person_type_code_tbl(1);
2509: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2510:

Line 2509: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2505: pa_debug.g_err_stage:='l_item_category_id_tbl(1) '||l_item_category_id_tbl(1);
2506: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2507:
2508: pa_debug.g_err_stage:='l_person_type_code_tbl(1) '||l_person_type_code_tbl(1);
2509: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2510:
2511: pa_debug.g_err_stage:='l_bom_resource_id_tbl(1) '||l_bom_resource_id_tbl(1);
2512: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2513:

Line 2512: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2508: pa_debug.g_err_stage:='l_person_type_code_tbl(1) '||l_person_type_code_tbl(1);
2509: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2510:
2511: pa_debug.g_err_stage:='l_bom_resource_id_tbl(1) '||l_bom_resource_id_tbl(1);
2512: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2513:
2514: END IF;
2515:
2516:

Line 2549: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,'before PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs',3);

2545:
2546: --Call the RBS Mapping API only if the rbs version id is not null
2547: IF l_rbs_version_id IS NOT NULL THEN
2548:
2549: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,'before PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs',3);
2550:
2551: PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs(
2552: p_budget_version_id => l_budget_version_id
2553: ,p_resource_list_id => l_resource_list_id

Line 2590: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2586: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2587:
2588: IF l_debug_mode = 'Y' THEN
2589: pa_debug.g_err_stage:='Called API PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs returned error';
2590: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2591: END IF;
2592: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2593:
2594: END IF;

Line 2622: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2618: l_trace_stage := 340;
2619: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2620: IF l_debug_mode = 'Y' THEN
2621: pa_debug.g_err_stage:='Doing processing for TASK ASSIGNMENTS : p_context is'|| p_context;
2622: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2623: END IF;
2624: -------------------------------------------------------------------------
2625: -- To call Task Validation API we populate the PLSql tables with task
2626: -- and resource data.

Line 2631: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2627: -------------------------------------------------------------------------
2628:
2629: IF l_debug_mode = 'Y' THEN
2630: pa_debug.g_err_stage:='Populating PlSql table with Task Data';
2631: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2632: END IF;
2633:
2634: -----------------------------------------------------------------
2635: -- Populating Table of task_rec_type

Line 2680: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2676: -----------------------------------------------------------------
2677:
2678: IF l_debug_mode = 'Y' THEN
2679: pa_debug.g_err_stage:='Populating PlSql table with Resource Data';
2680: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2681: END IF;
2682:
2683: l_trace_stage := 380;
2684: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));

Line 2965: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2961: -- Calling Task validation API
2962: -------------------------------------------------
2963: IF l_debug_mode = 'Y' THEN
2964: pa_debug.g_err_stage:='Calling API pa_task_assignment_utils.Validate_Create_Assignment';
2965: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2966: END IF;
2967:
2968: l_trace_stage := 420;
2969: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));

Line 2987: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2983:
2984: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2985: IF l_debug_mode = 'Y' THEN
2986: pa_debug.g_err_stage:='Called API pa_task_assignment_utils.Validate_Create_Assignment returned error';
2987: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2988: END IF;
2989: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2990: END IF;
2991: IF l_debug_mode = 'Y' THEN

Line 2993: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

2989: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2990: END IF;
2991: IF l_debug_mode = 'Y' THEN
2992: pa_debug.g_err_stage:='Returned from pa_task_assignment_utils.Validate_Create_Assignment';
2993: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2994: END IF;
2995:
2996: l_trace_stage := 430;
2997: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));

Line 3015: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3011: -----------------------------------------------------------------------
3012:
3013: IF l_debug_mode = 'Y' THEN
3014: pa_debug.g_err_stage:='Deleting Data from all resource PLSql tables';
3015: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3016: END IF;
3017:
3018: l_trace_stage := 450;
3019: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));

Line 3029: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3025: -----------------------------------------------------------------------
3026:
3027: IF l_debug_mode = 'Y' THEN
3028: pa_debug.g_err_stage:='Populating resource data tables from the output parameter table l_resource_rec_tbl';
3029: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3030: END IF;
3031:
3032: FOR i IN l_resource_rec_tbl.FIRST .. l_resource_rec_tbl.LAST LOOP
3033: l_trace_stage := 460;

Line 3589: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3585: ------------------------------------------------------------------------------
3586:
3587: IF l_debug_mode = 'Y' THEN
3588: pa_debug.g_err_stage:='data is deleted in bulk from pa_budget_lines and pa_resource_assignment based on the resource_assignment_id ';
3589: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3590: END IF;
3591:
3592: END IF;
3593: --------------------------------------------------------------------------

Line 3602: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3598: -- Deriving Time Phased Code based on the budget version id and setting the spread amount flad
3599: -------------------------------------------------------------------------------------------------
3600: IF l_debug_mode = 'Y' THEN
3601: pa_debug.g_err_stage:='Deriving time phased code ';
3602: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3603: END IF;
3604:
3605: l_time_phased_code := pa_fin_plan_utils.get_time_phased_code(p_budget_version_id);
3606:

Line 3609: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3605: l_time_phased_code := pa_fin_plan_utils.get_time_phased_code(p_budget_version_id);
3606:
3607: IF l_debug_mode = 'Y' THEN
3608: pa_debug.g_err_stage:='Deriving time phased code l_time_phased_code: '||l_time_phased_code;
3609: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3610: END IF;
3611: l_trace_stage := 550;
3612: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
3613:

Line 3628: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3624: -- Deriving Proj Element Id based on element version id
3625: -------------------------------------------------------------------------------------------------
3626: IF l_debug_mode = 'Y' THEN
3627: pa_debug.g_err_stage:='Deriving Proj Element Id based on element version id';
3628: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3629: END IF;
3630:
3631: FOR i IN p_task_elem_version_id_tbl.FIRST .. p_task_elem_version_id_tbl.LAST LOOP
3632: l_trace_stage := 570;

Line 3641: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3637: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
3638: FETCH c_proj_element_id INTO l_proj_element_id;
3639: IF l_debug_mode = 'Y' THEN
3640: pa_debug.g_err_stage:='Deriving Proj Element Id based on element version id l_proj_element_id : '|| l_proj_element_id;
3641: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3642: END IF;
3643: l_proj_element_id_tbl(i) := l_proj_element_id;
3644: CLOSE c_proj_element_id;
3645: ELSE

Line 3654: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3650: END LOOP;
3651:
3652: IF l_debug_mode = 'Y' THEN
3653: pa_debug.g_err_stage:='Deriving Proj Element Id based on element version id l_proj_element_id_tbl cnt : '|| l_proj_element_id_tbl.COUNT;
3654: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3655: END IF;
3656: l_trace_stage := 600;
3657: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
3658:

Line 3669: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3665: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
3666:
3667: IF l_debug_mode = 'Y' THEN
3668: pa_debug.g_err_stage:='Deriving start date for task_element_version_ids';
3669: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3670: END IF;
3671:
3672: -- Bug 3793623 - Added new params p_planning_start_date_tbl and p_planning_end_date_tbl
3673: PA_PLANNING_TRANSACTION_UTILS.get_default_planning_dates

Line 3689: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ',pa_debug.g_err_stage, 3);

3685: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3686:
3687: IF l_debug_mode = 'Y' THEN
3688: pa_debug.g_err_stage:='Called API pafpptub.get_default_planning_dates returned error';
3689: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ',pa_debug.g_err_stage, 3);
3690: END IF;
3691: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3692: END IF;
3693:

Line 3724: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3720: -----------------------------------------------------------------------------------------------------
3721:
3722: IF l_debug_mode = 'Y' THEN
3723: pa_debug.g_err_stage:='BULK INSERTING DATA INTO PA_RESOURCE_ASSIGNMENTS ';
3724: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3725: END IF;
3726:
3727: l_call_calc_api := 'N';
3728:

Line 3804: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3800: -- NEEDED FOR DEBUGGIND ISSUE WITH BULK DTA INSERTION.
3801: -----------------------------------------------------
3802: /*
3803: pa_debug.g_err_stage:='l_proj_element_id_tbl :'||l_proj_element_id_tbl.COUNT;
3804: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3805: pa_debug.g_err_stage:='l_unit_of_measure_tbl :'||l_unit_of_measure_tbl.COUNT;
3806: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3807: pa_debug.g_err_stage:='p_task_elem_version_id_tbl :'||p_task_elem_version_id_tbl.COUNT;
3808: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3806: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3802: /*
3803: pa_debug.g_err_stage:='l_proj_element_id_tbl :'||l_proj_element_id_tbl.COUNT;
3804: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3805: pa_debug.g_err_stage:='l_unit_of_measure_tbl :'||l_unit_of_measure_tbl.COUNT;
3806: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3807: pa_debug.g_err_stage:='p_task_elem_version_id_tbl :'||p_task_elem_version_id_tbl.COUNT;
3808: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3809: pa_debug.g_err_stage:='l_start_date_tbl :'||p_start_date_tbl.COUNT;
3810: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3808: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3804: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3805: pa_debug.g_err_stage:='l_unit_of_measure_tbl :'||l_unit_of_measure_tbl.COUNT;
3806: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3807: pa_debug.g_err_stage:='p_task_elem_version_id_tbl :'||p_task_elem_version_id_tbl.COUNT;
3808: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3809: pa_debug.g_err_stage:='l_start_date_tbl :'||p_start_date_tbl.COUNT;
3810: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3811: pa_debug.g_err_stage:='l_end_date_tbl :'||p_end_date_tbl.COUNT;
3812: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3810: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3806: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3807: pa_debug.g_err_stage:='p_task_elem_version_id_tbl :'||p_task_elem_version_id_tbl.COUNT;
3808: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3809: pa_debug.g_err_stage:='l_start_date_tbl :'||p_start_date_tbl.COUNT;
3810: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3811: pa_debug.g_err_stage:='l_end_date_tbl :'||p_end_date_tbl.COUNT;
3812: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3813: pa_debug.g_err_stage:='l_etc_method_code_tbl :'||l_etc_method_code_tbl.COUNT;
3814: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3812: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3808: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3809: pa_debug.g_err_stage:='l_start_date_tbl :'||p_start_date_tbl.COUNT;
3810: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3811: pa_debug.g_err_stage:='l_end_date_tbl :'||p_end_date_tbl.COUNT;
3812: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3813: pa_debug.g_err_stage:='l_etc_method_code_tbl :'||l_etc_method_code_tbl.COUNT;
3814: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3815: pa_debug.g_err_stage:='l_res_type_code_tbl :'||l_res_type_code_tbl.COUNT;
3816: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3814: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3810: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3811: pa_debug.g_err_stage:='l_end_date_tbl :'||p_end_date_tbl.COUNT;
3812: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3813: pa_debug.g_err_stage:='l_etc_method_code_tbl :'||l_etc_method_code_tbl.COUNT;
3814: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3815: pa_debug.g_err_stage:='l_res_type_code_tbl :'||l_res_type_code_tbl.COUNT;
3816: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3817: pa_debug.g_err_stage:='l_fc_res_type_code_tbl :'||l_fc_res_type_code_tbl.COUNT;
3818: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3816: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3812: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3813: pa_debug.g_err_stage:='l_etc_method_code_tbl :'||l_etc_method_code_tbl.COUNT;
3814: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3815: pa_debug.g_err_stage:='l_res_type_code_tbl :'||l_res_type_code_tbl.COUNT;
3816: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3817: pa_debug.g_err_stage:='l_fc_res_type_code_tbl :'||l_fc_res_type_code_tbl.COUNT;
3818: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3819: pa_debug.g_err_stage:='l_resource_class_code_tbl :'||l_resource_class_code_tbl.COUNT;
3820: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3818: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3814: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3815: pa_debug.g_err_stage:='l_res_type_code_tbl :'||l_res_type_code_tbl.COUNT;
3816: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3817: pa_debug.g_err_stage:='l_fc_res_type_code_tbl :'||l_fc_res_type_code_tbl.COUNT;
3818: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3819: pa_debug.g_err_stage:='l_resource_class_code_tbl :'||l_resource_class_code_tbl.COUNT;
3820: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3821: pa_debug.g_err_stage:='l_organization_id_tbl :'||l_organization_id_tbl.COUNT;
3822: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3820: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3816: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3817: pa_debug.g_err_stage:='l_fc_res_type_code_tbl :'||l_fc_res_type_code_tbl.COUNT;
3818: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3819: pa_debug.g_err_stage:='l_resource_class_code_tbl :'||l_resource_class_code_tbl.COUNT;
3820: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3821: pa_debug.g_err_stage:='l_organization_id_tbl :'||l_organization_id_tbl.COUNT;
3822: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3823: pa_debug.g_err_stage:='l_job_id_tbl :'||l_job_id_tbl.COUNT;
3824: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3822: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3818: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3819: pa_debug.g_err_stage:='l_resource_class_code_tbl :'||l_resource_class_code_tbl.COUNT;
3820: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3821: pa_debug.g_err_stage:='l_organization_id_tbl :'||l_organization_id_tbl.COUNT;
3822: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3823: pa_debug.g_err_stage:='l_job_id_tbl :'||l_job_id_tbl.COUNT;
3824: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3825: pa_debug.g_err_stage:='l_person_id_tbl :'||l_person_id_tbl.COUNT;
3826: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3824: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3820: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3821: pa_debug.g_err_stage:='l_organization_id_tbl :'||l_organization_id_tbl.COUNT;
3822: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3823: pa_debug.g_err_stage:='l_job_id_tbl :'||l_job_id_tbl.COUNT;
3824: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3825: pa_debug.g_err_stage:='l_person_id_tbl :'||l_person_id_tbl.COUNT;
3826: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3827: pa_debug.g_err_stage:='l_revenue_category_code_tbl :'||l_revenue_category_code_tbl.COUNT;
3828: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3826: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3822: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3823: pa_debug.g_err_stage:='l_job_id_tbl :'||l_job_id_tbl.COUNT;
3824: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3825: pa_debug.g_err_stage:='l_person_id_tbl :'||l_person_id_tbl.COUNT;
3826: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3827: pa_debug.g_err_stage:='l_revenue_category_code_tbl :'||l_revenue_category_code_tbl.COUNT;
3828: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3829: pa_debug.g_err_stage:='l_expenditure_type_tbl :'||l_expenditure_type_tbl.COUNT;
3830: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3828: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3824: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3825: pa_debug.g_err_stage:='l_person_id_tbl :'||l_person_id_tbl.COUNT;
3826: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3827: pa_debug.g_err_stage:='l_revenue_category_code_tbl :'||l_revenue_category_code_tbl.COUNT;
3828: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3829: pa_debug.g_err_stage:='l_expenditure_type_tbl :'||l_expenditure_type_tbl.COUNT;
3830: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3831: pa_debug.g_err_stage:='l_expenditure_category_tbl :'||l_expenditure_category_tbl.COUNT;
3832: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3830: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3826: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3827: pa_debug.g_err_stage:='l_revenue_category_code_tbl :'||l_revenue_category_code_tbl.COUNT;
3828: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3829: pa_debug.g_err_stage:='l_expenditure_type_tbl :'||l_expenditure_type_tbl.COUNT;
3830: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3831: pa_debug.g_err_stage:='l_expenditure_category_tbl :'||l_expenditure_category_tbl.COUNT;
3832: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3833: pa_debug.g_err_stage:='l_non_labor_resource_tbl :'||l_non_labor_resource_tbl.COUNT;
3834: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3832: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3828: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3829: pa_debug.g_err_stage:='l_expenditure_type_tbl :'||l_expenditure_type_tbl.COUNT;
3830: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3831: pa_debug.g_err_stage:='l_expenditure_category_tbl :'||l_expenditure_category_tbl.COUNT;
3832: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3833: pa_debug.g_err_stage:='l_non_labor_resource_tbl :'||l_non_labor_resource_tbl.COUNT;
3834: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3835: pa_debug.g_err_stage:='l_event_type_tbl :'||l_event_type_tbl.COUNT;
3836: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3834: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3830: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3831: pa_debug.g_err_stage:='l_expenditure_category_tbl :'||l_expenditure_category_tbl.COUNT;
3832: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3833: pa_debug.g_err_stage:='l_non_labor_resource_tbl :'||l_non_labor_resource_tbl.COUNT;
3834: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3835: pa_debug.g_err_stage:='l_event_type_tbl :'||l_event_type_tbl.COUNT;
3836: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3837: pa_debug.g_err_stage:='l_supplier_id_tbl :'||l_supplier_id_tbl.COUNT;
3838: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3836: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3832: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3833: pa_debug.g_err_stage:='l_non_labor_resource_tbl :'||l_non_labor_resource_tbl.COUNT;
3834: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3835: pa_debug.g_err_stage:='l_event_type_tbl :'||l_event_type_tbl.COUNT;
3836: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3837: pa_debug.g_err_stage:='l_supplier_id_tbl :'||l_supplier_id_tbl.COUNT;
3838: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3839: pa_debug.g_err_stage:='l_inventory_item_id_tbl :'||l_inventory_item_id_tbl.COUNT;
3840: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3838: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3834: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3835: pa_debug.g_err_stage:='l_event_type_tbl :'||l_event_type_tbl.COUNT;
3836: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3837: pa_debug.g_err_stage:='l_supplier_id_tbl :'||l_supplier_id_tbl.COUNT;
3838: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3839: pa_debug.g_err_stage:='l_inventory_item_id_tbl :'||l_inventory_item_id_tbl.COUNT;
3840: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3841: pa_debug.g_err_stage:='l_bom_resource_id_tbl :'||l_bom_resource_id_tbl.COUNT;
3842: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3840: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3836: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3837: pa_debug.g_err_stage:='l_supplier_id_tbl :'||l_supplier_id_tbl.COUNT;
3838: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3839: pa_debug.g_err_stage:='l_inventory_item_id_tbl :'||l_inventory_item_id_tbl.COUNT;
3840: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3841: pa_debug.g_err_stage:='l_bom_resource_id_tbl :'||l_bom_resource_id_tbl.COUNT;
3842: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3843: pa_debug.g_err_stage:='l_inventory_item_id_tbl :'||l_inventory_item_id_tbl.COUNT;
3844: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3842: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3838: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3839: pa_debug.g_err_stage:='l_inventory_item_id_tbl :'||l_inventory_item_id_tbl.COUNT;
3840: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3841: pa_debug.g_err_stage:='l_bom_resource_id_tbl :'||l_bom_resource_id_tbl.COUNT;
3842: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3843: pa_debug.g_err_stage:='l_inventory_item_id_tbl :'||l_inventory_item_id_tbl.COUNT;
3844: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3845: pa_debug.g_err_stage:='l_item_category_id_tbl :'||l_item_category_id_tbl.COUNT;
3846: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3844: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3840: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3841: pa_debug.g_err_stage:='l_bom_resource_id_tbl :'||l_bom_resource_id_tbl.COUNT;
3842: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3843: pa_debug.g_err_stage:='l_inventory_item_id_tbl :'||l_inventory_item_id_tbl.COUNT;
3844: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3845: pa_debug.g_err_stage:='l_item_category_id_tbl :'||l_item_category_id_tbl.COUNT;
3846: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3847: pa_debug.g_err_stage:='l_mfc_cost_type_id_tbl :'||l_mfc_cost_type_id_tbl.COUNT;
3848: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3846: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3842: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3843: pa_debug.g_err_stage:='l_inventory_item_id_tbl :'||l_inventory_item_id_tbl.COUNT;
3844: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3845: pa_debug.g_err_stage:='l_item_category_id_tbl :'||l_item_category_id_tbl.COUNT;
3846: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3847: pa_debug.g_err_stage:='l_mfc_cost_type_id_tbl :'||l_mfc_cost_type_id_tbl.COUNT;
3848: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3849: pa_debug.g_err_stage:='l_rate_expenditure_type_tbl :'||l_rate_expenditure_type_tbl.COUNT;
3850: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3848: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3844: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3845: pa_debug.g_err_stage:='l_item_category_id_tbl :'||l_item_category_id_tbl.COUNT;
3846: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3847: pa_debug.g_err_stage:='l_mfc_cost_type_id_tbl :'||l_mfc_cost_type_id_tbl.COUNT;
3848: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3849: pa_debug.g_err_stage:='l_rate_expenditure_type_tbl :'||l_rate_expenditure_type_tbl.COUNT;
3850: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3851: pa_debug.g_err_stage:='l_rate_func_curr_code_tbl :'||l_rate_func_curr_code_tbl.COUNT;
3852: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3850: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3846: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3847: pa_debug.g_err_stage:='l_mfc_cost_type_id_tbl :'||l_mfc_cost_type_id_tbl.COUNT;
3848: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3849: pa_debug.g_err_stage:='l_rate_expenditure_type_tbl :'||l_rate_expenditure_type_tbl.COUNT;
3850: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3851: pa_debug.g_err_stage:='l_rate_func_curr_code_tbl :'||l_rate_func_curr_code_tbl.COUNT;
3852: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3853: pa_debug.g_err_stage:='l_rate_based_flag_tbl :'||l_rate_based_flag_tbl.COUNT;
3854: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3852: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3848: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3849: pa_debug.g_err_stage:='l_rate_expenditure_type_tbl :'||l_rate_expenditure_type_tbl.COUNT;
3850: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3851: pa_debug.g_err_stage:='l_rate_func_curr_code_tbl :'||l_rate_func_curr_code_tbl.COUNT;
3852: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3853: pa_debug.g_err_stage:='l_rate_based_flag_tbl :'||l_rate_based_flag_tbl.COUNT;
3854: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3855: pa_debug.g_err_stage:='l_resource_class_flag_tbl :'||l_resource_class_flag_tbl.COUNT;
3856: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3854: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3850: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3851: pa_debug.g_err_stage:='l_rate_func_curr_code_tbl :'||l_rate_func_curr_code_tbl.COUNT;
3852: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3853: pa_debug.g_err_stage:='l_rate_based_flag_tbl :'||l_rate_based_flag_tbl.COUNT;
3854: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3855: pa_debug.g_err_stage:='l_resource_class_flag_tbl :'||l_resource_class_flag_tbl.COUNT;
3856: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3857: pa_debug.g_err_stage:='l_named_role_tbl :'||l_named_role_tbl.COUNT;
3858: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3856: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3852: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3853: pa_debug.g_err_stage:='l_rate_based_flag_tbl :'||l_rate_based_flag_tbl.COUNT;
3854: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3855: pa_debug.g_err_stage:='l_resource_class_flag_tbl :'||l_resource_class_flag_tbl.COUNT;
3856: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3857: pa_debug.g_err_stage:='l_named_role_tbl :'||l_named_role_tbl.COUNT;
3858: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3859: pa_debug.g_err_stage:='l_incur_by_res_class_code_tbl :'||l_incur_by_res_class_code_tbl.COUNT;
3860: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3858: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3854: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3855: pa_debug.g_err_stage:='l_resource_class_flag_tbl :'||l_resource_class_flag_tbl.COUNT;
3856: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3857: pa_debug.g_err_stage:='l_named_role_tbl :'||l_named_role_tbl.COUNT;
3858: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3859: pa_debug.g_err_stage:='l_incur_by_res_class_code_tbl :'||l_incur_by_res_class_code_tbl.COUNT;
3860: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3861: pa_debug.g_err_stage:='l_budget_version_id :'||l_budget_version_id;
3862: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3860: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3856: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3857: pa_debug.g_err_stage:='l_named_role_tbl :'||l_named_role_tbl.COUNT;
3858: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3859: pa_debug.g_err_stage:='l_incur_by_res_class_code_tbl :'||l_incur_by_res_class_code_tbl.COUNT;
3860: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3861: pa_debug.g_err_stage:='l_budget_version_id :'||l_budget_version_id;
3862: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3863: pa_debug.g_err_stage:='p_project_id :'||p_project_id;
3864: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3862: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3858: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3859: pa_debug.g_err_stage:='l_incur_by_res_class_code_tbl :'||l_incur_by_res_class_code_tbl.COUNT;
3860: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3861: pa_debug.g_err_stage:='l_budget_version_id :'||l_budget_version_id;
3862: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3863: pa_debug.g_err_stage:='p_project_id :'||p_project_id;
3864: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3865: pa_debug.g_err_stage:='task_id :'||l_proj_element_id_tbl(i);
3866: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3864: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3860: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3861: pa_debug.g_err_stage:='l_budget_version_id :'||l_budget_version_id;
3862: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3863: pa_debug.g_err_stage:='p_project_id :'||p_project_id;
3864: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3865: pa_debug.g_err_stage:='task_id :'||l_proj_element_id_tbl(i);
3866: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3867: pa_debug.g_err_stage:='project_assignment_id : -1';
3868: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

Line 3866: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3862: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3863: pa_debug.g_err_stage:='p_project_id :'||p_project_id;
3864: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3865: pa_debug.g_err_stage:='task_id :'||l_proj_element_id_tbl(i);
3866: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3867: pa_debug.g_err_stage:='project_assignment_id : -1';
3868: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3869: pa_debug.g_err_stage:='RESOURCE_LIST_MEMBER_ID :'||l_people_res_class_rlm_id;
3870: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);*/

Line 3868: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3864: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3865: pa_debug.g_err_stage:='task_id :'||l_proj_element_id_tbl(i);
3866: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3867: pa_debug.g_err_stage:='project_assignment_id : -1';
3868: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3869: pa_debug.g_err_stage:='RESOURCE_LIST_MEMBER_ID :'||l_people_res_class_rlm_id;
3870: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);*/
3871:
3872: /* l_trace_stage := 761;

Line 3870: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);*/

3866: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3867: pa_debug.g_err_stage:='project_assignment_id : -1';
3868: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3869: pa_debug.g_err_stage:='RESOURCE_LIST_MEMBER_ID :'||l_people_res_class_rlm_id;
3870: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);*/
3871:
3872: /* l_trace_stage := 761;
3873: hr_utility.trace('l_proj_element_id_tbl(i) => '||to_char(l_proj_element_id_tbl(i)));
3874: hr_utility.trace('l_unit_of_measure_tbl(l_ppl_index) => '||to_char(l_unit_of_measure_tbl(l_ppl_index)));

Line 3912: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3908: l_ppl_index:=1; --This will be used in the bulk insert for people -- -- Bug 3749516
3909:
3910: IF l_debug_mode = 'Y' THEN
3911: pa_debug.g_err_stage:='BULK INSERTING DATA - p_context - Workplan :'||p_context ;
3912: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3913:
3914: pa_debug.g_err_stage:='BULK INSERTING Workplan DATA - rlm id :'||l_eligible_rlm_ids_tbl(l_ppl_index) ;
3915: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,6);
3916: END IF;

Line 3915: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,6);

3911: pa_debug.g_err_stage:='BULK INSERTING DATA - p_context - Workplan :'||p_context ;
3912: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3913:
3914: pa_debug.g_err_stage:='BULK INSERTING Workplan DATA - rlm id :'||l_eligible_rlm_ids_tbl(l_ppl_index) ;
3915: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,6);
3916: END IF;
3917:
3918: FOR i IN p_task_elem_version_id_tbl.FIRST .. p_task_elem_version_id_tbl.LAST LOOP
3919: IF ((p_planned_people_effort_tbl.EXISTS(i)) AND

Line 3950: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3946:
3947:
3948: IF l_debug_mode = 'Y' THEN
3949: pa_debug.g_err_stage:='AFTER PREPARING INS DATA :'||p_context ;
3950: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3951:
3952: IF l_ins_task_elem_version_id_tbl.COUNT >0 THEN
3953: FOR i in l_ins_task_elem_version_id_tbl.FIRST .. l_ins_task_elem_version_id_tbl.LAST LOOP
3954: pa_debug.g_err_stage:='l_ins_proj_element_id_tbl :'||l_ins_proj_element_id_tbl(i) ;

Line 3955: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3951:
3952: IF l_ins_task_elem_version_id_tbl.COUNT >0 THEN
3953: FOR i in l_ins_task_elem_version_id_tbl.FIRST .. l_ins_task_elem_version_id_tbl.LAST LOOP
3954: pa_debug.g_err_stage:='l_ins_proj_element_id_tbl :'||l_ins_proj_element_id_tbl(i) ;
3955: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3956:
3957: pa_debug.g_err_stage:='l_ins_task_elem_version_id_tbl :'||l_ins_task_elem_version_id_tbl(i) ;
3958: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3959:

Line 3958: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3954: pa_debug.g_err_stage:='l_ins_proj_element_id_tbl :'||l_ins_proj_element_id_tbl(i) ;
3955: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3956:
3957: pa_debug.g_err_stage:='l_ins_task_elem_version_id_tbl :'||l_ins_task_elem_version_id_tbl(i) ;
3958: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3959:
3960: pa_debug.g_err_stage:='l_ins_start_date_tbl :'||l_ins_start_date_tbl(i) ;
3961: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3962:

Line 3961: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3957: pa_debug.g_err_stage:='l_ins_task_elem_version_id_tbl :'||l_ins_task_elem_version_id_tbl(i) ;
3958: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3959:
3960: pa_debug.g_err_stage:='l_ins_start_date_tbl :'||l_ins_start_date_tbl(i) ;
3961: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3962:
3963: pa_debug.g_err_stage:='l_ins_end_date_tbl :'||l_ins_end_date_tbl(i) ;
3964: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3965: END LOOP;

Line 3964: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

3960: pa_debug.g_err_stage:='l_ins_start_date_tbl :'||l_ins_start_date_tbl(i) ;
3961: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3962:
3963: pa_debug.g_err_stage:='l_ins_end_date_tbl :'||l_ins_end_date_tbl(i) ;
3964: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3965: END LOOP;
3966: END IF;
3967: END IF;
3968:

Line 4150: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4146: l_trace_stage := 780;
4147: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
4148: IF l_debug_mode = 'Y' THEN
4149: pa_debug.g_err_stage:='BULK INSERTING DATA - WORPLAN - PEOPLE '||l_res_assignment_id_temp_tbl(k);
4150: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4151: END IF;
4152: l_quantity_tbl(l_index) := l_ins_cal_people_effort_tbl(k);
4153: l_res_assignment_id_tbl(l_index) := l_res_assignment_id_temp_tbl(k);
4154: -- IF l_spread_amounts_for_ver = 'Y' THEN

Line 4209: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4205: --------------------------------------------
4206: IF p_context = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_TASK THEN
4207: IF l_debug_mode = 'Y' THEN
4208: pa_debug.g_err_stage:='BULK INSERTING DATA - Context TASK p_context : '||p_context;
4209: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4210: END IF;
4211: --dbms_output.put_line('Inserting for TA');
4212: ---------------------------------------------------------
4213: -- BULK Inserting records into pa_resource_assignments

Line 4396: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4392:
4393: IF l_res_assignment_id_temp_tbl.COUNT <> l_eligible_rlm_ids_tbl.COUNT THEN
4394: IF l_debug_mode = 'Y' THEN
4395: pa_debug.g_err_stage:='For Budget and Forcast p_context - data mismatch';
4396: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4397: END IF;
4398: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4399: END IF;
4400: -----------------------------------------------------------------------

Line 4412: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4408: FOR k IN l_res_assignment_id_temp_tbl.FIRST .. l_res_assignment_id_temp_tbl.LAST LOOP
4409:
4410: IF l_debug_mode = 'Y' THEN
4411: pa_debug.g_err_stage:='BULK INSERTING DATA - TASK Setting DATA - raid count : '||l_res_assignment_id_temp_tbl.COUNT;
4412: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4413: END IF;
4414:
4415: l_res_assignment_id_tbl(l_index) := l_res_assignment_id_temp_tbl(k);
4416:

Line 4432: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4428: AND (p_burdened_cost_tbl(k) is NOT NULL))) THEN
4429:
4430: IF l_debug_mode = 'Y' THEN
4431: pa_debug.g_err_stage:='BULK INSERTING DATA - TASK spread amount flag';
4432: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4433: END IF;
4434: l_spread_amount_flags_tbl(l_index) := 'Y';
4435: l_call_calc_api := 'Y';
4436:

Line 4539: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4535:
4536: BEGIN
4537: IF l_debug_mode = 'Y' THEN
4538: pa_debug.g_err_stage:='BULK INSERTING DATA - Context TASK p_context : '||p_context;
4539: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4540:
4541: pa_debug.g_err_stage:='l_eligible_rlm_ids_tbl.count '||l_eligible_rlm_ids_tbl.count;
4542: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4543:

Line 4542: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4538: pa_debug.g_err_stage:='BULK INSERTING DATA - Context TASK p_context : '||p_context;
4539: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4540:
4541: pa_debug.g_err_stage:='l_eligible_rlm_ids_tbl.count '||l_eligible_rlm_ids_tbl.count;
4542: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4543:
4544: pa_debug.g_err_stage:='l_bf_quantity_tbl.count '||l_bf_quantity_tbl.count;
4545: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4546:

Line 4545: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4541: pa_debug.g_err_stage:='l_eligible_rlm_ids_tbl.count '||l_eligible_rlm_ids_tbl.count;
4542: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4543:
4544: pa_debug.g_err_stage:='l_bf_quantity_tbl.count '||l_bf_quantity_tbl.count;
4545: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4546:
4547: pa_debug.g_err_stage:='l_bf_raw_cost_tbl.count '||l_bf_raw_cost_tbl.count;
4548: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4549:

Line 4548: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4544: pa_debug.g_err_stage:='l_bf_quantity_tbl.count '||l_bf_quantity_tbl.count;
4545: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4546:
4547: pa_debug.g_err_stage:='l_bf_raw_cost_tbl.count '||l_bf_raw_cost_tbl.count;
4548: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4549:
4550: pa_debug.g_err_stage:='l_bf_burdened_cost_tbl.count '||l_bf_burdened_cost_tbl.count;
4551: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4552:

Line 4551: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4547: pa_debug.g_err_stage:='l_bf_raw_cost_tbl.count '||l_bf_raw_cost_tbl.count;
4548: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4549:
4550: pa_debug.g_err_stage:='l_bf_burdened_cost_tbl.count '||l_bf_burdened_cost_tbl.count;
4551: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4552:
4553: pa_debug.g_err_stage:='l_bf_revenue_tbl.count '||l_bf_revenue_tbl.count;
4554: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4555:

Line 4554: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4550: pa_debug.g_err_stage:='l_bf_burdened_cost_tbl.count '||l_bf_burdened_cost_tbl.count;
4551: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4552:
4553: pa_debug.g_err_stage:='l_bf_revenue_tbl.count '||l_bf_revenue_tbl.count;
4554: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4555:
4556: pa_debug.g_err_stage:='l_bf_currency_code_tbl.count '||l_bf_currency_code_tbl.count;
4557: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4558:

Line 4557: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4553: pa_debug.g_err_stage:='l_bf_revenue_tbl.count '||l_bf_revenue_tbl.count;
4554: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4555:
4556: pa_debug.g_err_stage:='l_bf_currency_code_tbl.count '||l_bf_currency_code_tbl.count;
4557: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4558:
4559: pa_debug.g_err_stage:='l_bf_cost_rate_tbl.count '||l_bf_cost_rate_tbl.count;
4560: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4561:

Line 4560: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4556: pa_debug.g_err_stage:='l_bf_currency_code_tbl.count '||l_bf_currency_code_tbl.count;
4557: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4558:
4559: pa_debug.g_err_stage:='l_bf_cost_rate_tbl.count '||l_bf_cost_rate_tbl.count;
4560: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4561:
4562: pa_debug.g_err_stage:='l_bf_bill_rate_tbl.count '||l_bf_bill_rate_tbl.count;
4563: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4564:

Line 4563: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4559: pa_debug.g_err_stage:='l_bf_cost_rate_tbl.count '||l_bf_cost_rate_tbl.count;
4560: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4561:
4562: pa_debug.g_err_stage:='l_bf_bill_rate_tbl.count '||l_bf_bill_rate_tbl.count;
4563: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4564:
4565: pa_debug.g_err_stage:='l_bf_burdened_rate_tbl.count '||l_bf_burdened_rate_tbl.count;
4566: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4567:

Line 4566: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4562: pa_debug.g_err_stage:='l_bf_bill_rate_tbl.count '||l_bf_bill_rate_tbl.count;
4563: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4564:
4565: pa_debug.g_err_stage:='l_bf_burdened_rate_tbl.count '||l_bf_burdened_rate_tbl.count;
4566: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4567:
4568:
4569: END IF;
4570:

Line 4779: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4775:
4776: IF (l_index + SQL%BULK_EXCEPTIONS.COUNT ) <> l_eligible_rlm_ids_tbl.COUNT THEN
4777:
4778: pa_debug.g_err_stage:='No of inserted records + No. of errored records is not equal to total no. of input records';
4779: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4780:
4781: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4782: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
4783: p_token1 => 'PROCEDURENAME',

Line 4875: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4871:
4872: ELSE
4873:
4874: pa_debug.g_err_stage:='No of duplicates found '||SQL%BULK_EXCEPTIONS.COUNT;
4875: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4876:
4877: RAISE;
4878:
4879: END IF;

Line 4885: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4881: END;
4882:
4883: IF l_debug_mode = 'Y' THEN
4884: pa_debug.g_err_stage:='FLAG 2 '||l_bf_ra_id_tbl.COUNT;
4885: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4886: END IF;
4887:
4888: -------------------------------------------------------------------------------
4889: --No of records in rlm id tbl should be equal to the no of records in ra id tb;

Line 4896: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4892: (p_skip_duplicates_flag = 'N') THEN
4893:
4894: IF l_debug_mode = 'Y' THEN
4895: pa_debug.g_err_stage:='INSIDE Bulk Data insert for budget/forecast';
4896: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4897:
4898: pa_debug.g_err_stage:='For Budget and Forcast p_context - data mismatch';
4899: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4900: END IF;

Line 4899: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4895: pa_debug.g_err_stage:='INSIDE Bulk Data insert for budget/forecast';
4896: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4897:
4898: pa_debug.g_err_stage:='For Budget and Forcast p_context - data mismatch';
4899: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4900: END IF;
4901: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4902:
4903: END IF;

Line 4959: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4955:
4956: IF l_amount_exists ='Y' THEN
4957: IF l_debug_mode = 'Y' THEN
4958: pa_debug.g_err_stage:='Amount exists and preparing the tbls for calc API';
4959: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4960: END IF;
4961:
4962: IF l_bf_currency_code_tbl.EXISTS(k) AND
4963: NVL(l_bf_currency_code_tbl(k),FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

Line 4969: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

4965: ELSE
4966:
4967: IF l_debug_mode = 'Y' THEN
4968: pa_debug.g_err_stage:='Currency code not passed when amounts are passed';
4969: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4970: END IF;
4971: --dbms_output.put_line('curr code not passed');
4972: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4973: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 5034: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

5030: IF l_debug_mode = 'Y' THEN
5031: IF l_res_assignment_id_tbl.COUNT > 0 THEN
5032: FOR i in l_res_assignment_id_tbl.FIRST .. l_res_assignment_id_tbl.LAST LOOP
5033: pa_debug.g_err_stage:='CALCULATE PARAM l_res_assignment_id_tbl :'||l_res_assignment_id_tbl(i);
5034: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5035:
5036: pa_debug.g_err_stage:='CALCULATE PARAM l_quantity_tbl :'||l_quantity_tbl(i);
5037: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5038:

Line 5037: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

5033: pa_debug.g_err_stage:='CALCULATE PARAM l_res_assignment_id_tbl :'||l_res_assignment_id_tbl(i);
5034: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5035:
5036: pa_debug.g_err_stage:='CALCULATE PARAM l_quantity_tbl :'||l_quantity_tbl(i);
5037: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5038:
5039: pa_debug.g_err_stage:='CALCULATE PARAM l_raw_cost_tbl :'||l_raw_cost_tbl(i);
5040: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5041:

Line 5040: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

5036: pa_debug.g_err_stage:='CALCULATE PARAM l_quantity_tbl :'||l_quantity_tbl(i);
5037: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5038:
5039: pa_debug.g_err_stage:='CALCULATE PARAM l_raw_cost_tbl :'||l_raw_cost_tbl(i);
5040: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5041:
5042: pa_debug.g_err_stage:='CALCULATE PARAM l_burdened_cost_tbl :'||l_burdened_cost_tbl(i);
5043: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5044:

Line 5043: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

5039: pa_debug.g_err_stage:='CALCULATE PARAM l_raw_cost_tbl :'||l_raw_cost_tbl(i);
5040: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5041:
5042: pa_debug.g_err_stage:='CALCULATE PARAM l_burdened_cost_tbl :'||l_burdened_cost_tbl(i);
5043: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5044:
5045: pa_debug.g_err_stage:='CALCULATE PARAM l_revenue_tbl :'||l_revenue_tbl(i);
5046: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5047:

Line 5046: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

5042: pa_debug.g_err_stage:='CALCULATE PARAM l_burdened_cost_tbl :'||l_burdened_cost_tbl(i);
5043: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5044:
5045: pa_debug.g_err_stage:='CALCULATE PARAM l_revenue_tbl :'||l_revenue_tbl(i);
5046: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5047:
5048: pa_debug.g_err_stage:='CALCULATE PARAM l_currency_code_tbl :'||l_currency_code_tbl(i);
5049: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5050:

Line 5049: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

5045: pa_debug.g_err_stage:='CALCULATE PARAM l_revenue_tbl :'||l_revenue_tbl(i);
5046: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5047:
5048: pa_debug.g_err_stage:='CALCULATE PARAM l_currency_code_tbl :'||l_currency_code_tbl(i);
5049: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5050:
5051: pa_debug.g_err_stage:='CALCULATE PARAM l_cost_rate_tbl :'||l_cost_rate_tbl(i);
5052: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5053:

Line 5052: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

5048: pa_debug.g_err_stage:='CALCULATE PARAM l_currency_code_tbl :'||l_currency_code_tbl(i);
5049: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5050:
5051: pa_debug.g_err_stage:='CALCULATE PARAM l_cost_rate_tbl :'||l_cost_rate_tbl(i);
5052: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5053:
5054: pa_debug.g_err_stage:='CALCULATE PARAM l_burden_multiplier_tbl :'||l_burden_multiplier_tbl(i);
5055: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5056:

Line 5055: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

5051: pa_debug.g_err_stage:='CALCULATE PARAM l_cost_rate_tbl :'||l_cost_rate_tbl(i);
5052: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5053:
5054: pa_debug.g_err_stage:='CALCULATE PARAM l_burden_multiplier_tbl :'||l_burden_multiplier_tbl(i);
5055: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5056:
5057: pa_debug.g_err_stage:='CALCULATE PARAM l_bill_rate_tbl :'||l_bill_rate_tbl(i);
5058: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5059: END LOOP;

Line 5058: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

5054: pa_debug.g_err_stage:='CALCULATE PARAM l_burden_multiplier_tbl :'||l_burden_multiplier_tbl(i);
5055: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5056:
5057: pa_debug.g_err_stage:='CALCULATE PARAM l_bill_rate_tbl :'||l_bill_rate_tbl(i);
5058: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5059: END LOOP;
5060: END IF;
5061: END IF;
5062:

Line 5093: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

5089:
5090: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5091: IF l_debug_mode = 'Y' THEN
5092: pa_debug.g_err_stage:='Called API PA_FP_CALC_PLAN_PKG.calculate api returned error';
5093: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5094: END IF;
5095:
5096: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5097: END IF;

Line 5122: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

5118:
5119: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5120: IF l_debug_mode = 'Y' THEN
5121: pa_debug.g_err_stage:='Called API PA_PROJ_TASK_STRUC_PUB.process_wbs_updates_wrp';
5122: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5123: END IF;
5124:
5125: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5126: END IF;

Line 5146: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage, 3);

5142:
5143: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5144: IF l_debug_mode = 'Y' THEN
5145: pa_debug.g_err_stage:='Called API PA_FIN_PLAN_PUB.create_default_plan_txn_rec returned error';
5146: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage, 3);
5147: END IF;
5148: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5149: END IF; /* 7161809 */
5150:

Line 5172: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage, 3);

5168: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5169:
5170: IF l_debug_mode = 'Y' THEN
5171: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
5172: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage, 3);
5173: END IF;
5174: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5175: END IF;
5176:

Line 5237: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage, 3);

5233: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5234:
5235: IF l_debug_mode = 'Y' THEN
5236: pa_debug.g_err_stage:='Called API pa_res_asg_currency_pub.maintain_data returned error';
5237: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage, 3);
5238: END IF;
5239: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5240: END IF; */
5241:

Line 5244: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

5240: END IF; */
5241:
5242: IF l_debug_mode = 'Y' THEN
5243: pa_debug.g_err_stage:='CALLED THE PA_FP_CALC_PLAN_PKG.CALCULATE API';
5244: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5245: pa_debug.reset_curr_function;
5246: END IF;
5247: EXCEPTION
5248:

Line 5277: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'

5273: ROLLBACK TO SAVEPOINT ADD_PLANNING_TRANS_SP;
5274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5275: x_msg_count := 1;
5276: x_msg_data := SQLERRM;
5277: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
5278: ,p_procedure_name => 'add_planning_transactions');
5279:
5280: IF l_debug_mode = 'Y' THEN
5281: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 5422: l_module_name VARCHAR2(100) := 'Update_Planning_Transactions' || 'pa.plsql.pa_fp_planning_transaction_pub';

5418: l_msg_index_out NUMBER;
5419: l_debug_mode VARCHAR2(1);
5420: l_debug_level3 CONSTANT NUMBER := 3;
5421: l_debug_level5 CONSTANT NUMBER := 5;
5422: l_module_name VARCHAR2(100) := 'Update_Planning_Transactions' || 'pa.plsql.pa_fp_planning_transaction_pub';
5423: l_loop_start NUMBER;
5424: l_loop_end NUMBER;
5425:
5426: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

Line 5713: pa_fp_planning_transaction_pub.add_planning_transactions

5709: END;
5710:
5711:
5712:
5713: pa_fp_planning_transaction_pub.add_planning_transactions
5714: (p_context =>'WORKPLAN'
5715: ,p_calling_context => p_calling_context -- Added for Bug 6856934
5716: ,p_project_id => l_project_id
5717: ,p_struct_elem_version_id => p_struct_elem_version_id

Line 5723: pa_debug.g_err_stage:='Called API pa_fp_planning_transaction_pub.add_planning_transaction api returned error';

5719: ,x_msg_data => l_msg_data
5720: ,x_msg_count => l_msg_count);
5721: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5722: IF l_debug_mode = 'Y' THEN
5723: pa_debug.g_err_stage:='Called API pa_fp_planning_transaction_pub.add_planning_transaction api returned error';
5724: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
5725: END IF;
5726: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5727: END IF;

Line 7396: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.update_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

7392:
7393: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7394: IF l_debug_mode = 'Y' THEN
7395: pa_debug.g_err_stage:='Called API PA_PROJ_TASK_STRUC_PUB.process_wbs_updates_wrp';
7396: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.update_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
7397: END IF;
7398:
7399: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7400: END IF;

Line 7457: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'

7453: WHEN OTHERS THEN
7454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7455: x_msg_count := 1;
7456: x_msg_data := SQLERRM;
7457: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
7458: ,p_procedure_name => 'Update_Planning_Transactions');
7459:
7460: IF l_debug_mode = 'Y' THEN
7461: pa_debug.g_err_stage:='Unexpected Error' || SQLERRM;

Line 8339: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.copy_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

8335:
8336: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8337: IF l_debug_mode = 'Y' THEN
8338: pa_debug.g_err_stage:='Called API PA_PROJ_TASK_STRUC_PUB.process_wbs_updates_wrp';
8339: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.copy_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
8340: END IF;
8341:
8342: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
8343: END IF;

Line 8441: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_planning_transaction_pub'

8437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8438: x_msg_count := 1;
8439: x_msg_data := SQLERRM;
8440:
8441: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_planning_transaction_pub'
8442: ,p_procedure_name => 'copy_planning_transactions');
8443:
8444: IF l_debug_mode = 'Y' THEN
8445: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 9971: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_planning_transaction_pub'

9967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9968: x_msg_count := 1;
9969: x_msg_data := SQLERRM;
9970:
9971: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_planning_transaction_pub'
9972: ,p_procedure_name => 'delete_planning_transactions');
9973:
9974: IF l_debug_mode = 'Y' THEN
9975: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 10031: PA_DEBUG.Set_Curr_Function( p_function => 'PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type',

10027: l_debug_mode := NVL(l_debug_mode, 'N');
10028: x_msg_count := 0;
10029: x_return_status := FND_API.G_RET_STS_SUCCESS;
10030: IF l_debug_mode = 'Y' THEN
10031: PA_DEBUG.Set_Curr_Function( p_function => 'PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type',
10032: p_debug_mode => l_debug_mode );
10033: END IF;
10034: ---------------------------------------------------------------
10035: -- validating input parameter p_project_id.

Line 10040: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);

10036: -- p_project_id cannot be passed as null.
10037: ---------------------------------------------------------------
10038: IF l_debug_mode = 'Y' THEN
10039: pa_debug.g_err_stage:='Validating input parameters';
10040: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);
10041: END IF;
10042:
10043: IF (p_src_project_id IS NULL) OR
10044: (p_targ_project_id IS NULL) THEN

Line 10047: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,5);

10043: IF (p_src_project_id IS NULL) OR
10044: (p_targ_project_id IS NULL) THEN
10045: IF l_debug_mode = 'Y' THEN
10046: pa_debug.g_err_stage:='Invalid Arguments Passed - src and targ Project Ids are null';
10047: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,5);
10048: END IF;
10049: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
10050: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
10051: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 10061: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);

10057: ---------------------------------------------------------------
10058:
10059: IF l_debug_mode = 'Y' THEN
10060: pa_debug.g_err_stage:='checking availability of a wp type';
10061: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);
10062: END IF;
10063:
10064: ---------------------------------------------------------
10065: -- In case of no data found, the exception handling block

Line 10080: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,1);

10076:
10077: WHEN NO_DATA_FOUND THEN
10078: IF l_debug_mode = 'Y' THEN
10079: pa_debug.g_err_stage :='No WORK PLAN TYPE present in the system';
10080: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,1);
10081: END IF;
10082:
10083: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
10084: p_msg_name => 'PA_FP_NO_WP_PLAN_TYPE' );

Line 10095: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);

10091: -- passed project_id
10092: ---------------------------------------------------------
10093: IF l_debug_mode = 'Y' THEN
10094: pa_debug.g_err_stage:='checking if wp type is already attched for project id';
10095: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);
10096: END IF;
10097:
10098: BEGIN -- BLOCK to check if workplan_type is already attched for the passed project_id - Starts
10099:

Line 10126: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);

10122: IF l_proj_wp_type_exists = 0 THEN
10123:
10124: IF l_debug_mode = 'Y' THEN
10125: pa_debug.g_err_stage:='Getting the fp option id for the wp plan type of the source project ';
10126: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);
10127: END IF;
10128:
10129: IF p_src_project_id <> p_targ_project_id THEN
10130:

Line 10149: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);

10145:
10146:
10147: IF l_debug_mode = 'Y' THEN
10148: pa_debug.g_err_stage:='Calling API pa_proj_fp_options_pub.create_fp_option';
10149: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);
10150: END IF;
10151:
10152: IF l_debug_mode = 'Y' THEN
10153: pa_debug.g_err_stage:='The source fp option id is '||l_src_fp_option_id;

Line 10154: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);

10150: END IF;
10151:
10152: IF l_debug_mode = 'Y' THEN
10153: pa_debug.g_err_stage:='The source fp option id is '||l_src_fp_option_id;
10154: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);
10155: END IF;
10156:
10157:
10158: pa_proj_fp_options_pub.Create_FP_Option (

Line 10173: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,5);

10169:
10170: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10171: IF l_debug_mode = 'Y' THEN
10172: pa_debug.g_err_stage:='Called API pa_proj_fp_options_pub.Create_FP_Option returned error';
10173: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,5);
10174: END IF;
10175: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
10176: END IF;
10177:

Line 10200: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,5);

10196:
10197: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10198: IF l_debug_mode = 'Y' THEN
10199: pa_debug.g_err_stage:='Called API PA_FP_TXN_CURRENCIES_PUB.COPY_FP_TXN_CURRENCIES returned error';
10200: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,5);
10201: END IF;
10202: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
10203: END IF;
10204:

Line 10235: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'

10231: WHEN OTHERS THEN
10232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10233: x_msg_count := 1;
10234: x_msg_data := SQLERRM;
10235: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
10236: ,p_procedure_name => 'PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type');
10237:
10238: IF l_debug_mode = 'Y' THEN
10239: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 10236: ,p_procedure_name => 'PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type');

10232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10233: x_msg_count := 1;
10234: x_msg_data := SQLERRM;
10235: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
10236: ,p_procedure_name => 'PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type');
10237:
10238: IF l_debug_mode = 'Y' THEN
10239: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
10240: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,5);

Line 10240: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,5);

10236: ,p_procedure_name => 'PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type');
10237:
10238: IF l_debug_mode = 'Y' THEN
10239: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
10240: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,5);
10241: pa_debug.reset_curr_function;
10242: END IF;
10243: RAISE;
10244:

Line 10294: l_module_name VARCHAR2(100):='pa.plsql.pa_fp_planning_transaction_pub.check_and_create_task_rec_info' ;

10290: l_error_msg_code VARCHAR2(30);
10291: l_msg_index_out NUMBER;
10292: l_return_status VARCHAR2(2000);
10293: l_debug_mode VARCHAR2(30);
10294: l_module_name VARCHAR2(100):='pa.plsql.pa_fp_planning_transaction_pub.check_and_create_task_rec_info' ;
10295: l_rec_exsists VARCHAR2(1);
10296: --End of variables used for debugging
10297:
10298:

Line 10629: pa_debug.g_err_stage:='Called API PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions ,api returned error';

10625: );
10626:
10627: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10628: IF l_debug_mode = 'Y' THEN
10629: pa_debug.g_err_stage:='Called API PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions ,api returned error';
10630: pa_debug.write( l_module_name,pa_debug.g_err_stage,5);
10631: END IF;
10632: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
10633: END IF;

Line 10664: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'

10660: WHEN OTHERS THEN
10661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10662: x_msg_count := 1;
10663: x_msg_data := SQLERRM;
10664: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
10665: ,p_procedure_name => 'check_and_create_task_rec_info');
10666:
10667: IF l_debug_mode = 'Y' THEN
10668: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 10776: p_function =>'PA_FP_PLANNING_TRANSACTION_PUB.Refresh_Plan_Txns'

10772:
10773: -- Set curr function
10774: IF l_debug_mode = 'Y' THEN
10775: PA_DEBUG.set_curr_function(
10776: p_function =>'PA_FP_PLANNING_TRANSACTION_PUB.Refresh_Plan_Txns'
10777: ,p_debug_mode => l_debug_mode );
10778: END IF;
10779: -- Check for business rules violations
10780:

Line 10856: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);

10852: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10853:
10854: IF l_debug_mode = 'Y' THEN
10855: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
10856: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
10857: END IF;
10858: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
10859: END IF;
10860:

Line 10891: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);

10887: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10888:
10889: IF l_debug_mode = 'Y' THEN
10890: pa_debug.g_err_stage:='Called API pa_res_asg_currency_pub.maintain_data returned error';
10891: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
10892: END IF;
10893: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
10894: END IF;
10895:

Line 10942: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);

10938: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10939:
10940: IF l_debug_mode = 'Y' THEN
10941: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
10942: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
10943: END IF;
10944: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
10945: END IF;
10946:

Line 10966: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);

10962: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
10963:
10964: IF l_debug_mode = 'Y' THEN
10965: pa_debug.g_err_stage:='Called API pa_res_asg_currency_pub.maintain_data returned error';
10966: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
10967: END IF;
10968: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
10969: END IF;
10970:

Line 11007: pa_debug.g_err_stage:='Calling pa_fp_planning_transaction_pub.create_default_task_plan_txns';

11003: IF l_res_list_uncategorized_flag = 'Y' THEN
11004: -- Insert default task planning trasaction for the version
11005:
11006: IF l_debug_mode = 'Y' THEN
11007: pa_debug.g_err_stage:='Calling pa_fp_planning_transaction_pub.create_default_task_plan_txns';
11008: pa_debug.write('Refresh_Plan_Txns: ' || g_module_name,pa_debug.g_err_stage,3);
11009: END IF;
11010:
11011: pa_fp_planning_transaction_pub.create_default_task_plan_txns (

Line 11011: pa_fp_planning_transaction_pub.create_default_task_plan_txns (

11007: pa_debug.g_err_stage:='Calling pa_fp_planning_transaction_pub.create_default_task_plan_txns';
11008: pa_debug.write('Refresh_Plan_Txns: ' || g_module_name,pa_debug.g_err_stage,3);
11009: END IF;
11010:
11011: pa_fp_planning_transaction_pub.create_default_task_plan_txns (
11012: p_budget_version_id => p_budget_version_id
11013: ,p_version_plan_level_code => budget_version_info_rec.fin_plan_level_code
11014: ,x_return_status => x_return_status
11015: ,x_msg_count => x_msg_count

Line 11102: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);

11098: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11099:
11100: IF l_debug_mode = 'Y' THEN
11101: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
11102: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
11103: END IF;
11104: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11105: END IF;
11106:

Line 11126: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);

11122: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11123:
11124: IF l_debug_mode = 'Y' THEN
11125: pa_debug.g_err_stage:='Called API pa_res_asg_currency_pub.maintain_data returned error';
11126: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
11127: END IF;
11128: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11129: END IF;
11130: END IF; --} IF l_delete_ra_id_tbl.COUNT > 0 THEN

Line 11276: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'

11272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11273: x_msg_count := 1;
11274: x_msg_data := SQLERRM;
11275:
11276: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
11277: ,p_procedure_name => 'Refresh_Plan_Txns');
11278:
11279: IF l_debug_mode = 'Y' THEN
11280: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 11306: l_module_name varchar2(100):= 'pa.plsql.pa_fp_planning_transaction_pub';

11302: ,X_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
11303: AS
11304:
11305:
11306: l_module_name varchar2(100):= 'pa.plsql.pa_fp_planning_transaction_pub';
11307:
11308: -- Start of variables used for debugging purpose
11309: l_msg_count NUMBER :=0;
11310: l_data VARCHAR2(2000);

Line 11484: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);

11480:
11481: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11482: IF l_debug_mode = 'Y' THEN
11483: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
11484: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);
11485: END IF;
11486: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11487: END IF;
11488:

Line 11499: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);

11495: EXCEPTION
11496: WHEN OTHERS THEN
11497: IF l_debug_mode = 'Y' THEN
11498: pa_debug.g_err_stage:='Error while fetching plan_class_code for the budget_version_id';
11499: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);
11500: END IF;
11501: RAISE;
11502: END;
11503:

Line 11539: pa_fp_planning_transaction_pub.add_planning_transactions (

11535:
11536: l_element_version_id_tbl.extend(1);
11537: l_element_version_id_tbl(1):= 0;
11538:
11539: pa_fp_planning_transaction_pub.add_planning_transactions (
11540: p_context => l_plan_class_code
11541: /* Passing calling module as creation version, since we dont want calculate api to be called */
11542: ,p_calling_module => 'CREATE_VERSION'
11543: ,p_project_id => version_info_rec.project_id

Line 11554: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);

11550:
11551: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11552: IF l_debug_mode = 'Y' THEN
11553: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
11554: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);
11555: END IF;
11556: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11557: END IF;
11558:

Line 11577: pa_fp_planning_transaction_pub.add_planning_transactions (

11573: LOOP
11574: FETCH top_tasks_cur BULK COLLECT INTO l_element_version_id_tbl LIMIT l_max_fetch_size;
11575:
11576: IF nvl(l_element_version_id_tbl.last,0) >= 1 THEN
11577: pa_fp_planning_transaction_pub.add_planning_transactions (
11578: p_context => l_plan_class_code
11579: /* Passing calling module as creation version, since we dont want calculate api to be called */
11580: ,p_calling_module => 'CREATE_VERSION'
11581: ,p_project_id => version_info_rec.project_id

Line 11593: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);

11589:
11590: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11591: IF l_debug_mode = 'Y' THEN
11592: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
11593: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);
11594: END IF;
11595: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11596: END IF;
11597: -- Exit if fetch size is less than 200

Line 11624: pa_fp_planning_transaction_pub.add_planning_transactions (

11620: LOOP
11621: FETCH lowest_tasks_cur BULK COLLECT INTO l_element_version_id_tbl LIMIT l_max_fetch_size;
11622:
11623: IF nvl(l_element_version_id_tbl.last,0) >= 1 THEN
11624: pa_fp_planning_transaction_pub.add_planning_transactions (
11625: p_context => l_plan_class_code
11626: /* Passing calling module as creation version, since we dont want calculate api to be called */
11627: ,p_calling_module => 'CREATE_VERSION'
11628: ,p_project_id => version_info_rec.project_id

Line 11639: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);

11635:
11636: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11637: IF l_debug_mode = 'Y' THEN
11638: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
11639: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);
11640: END IF;
11641: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11642: END IF;
11643: END IF;

Line 11686: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'

11682: WHEN Others THEN
11683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11684: x_msg_count := 1;
11685: x_msg_data := SQLERRM;
11686: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
11687: ,p_procedure_name => 'CREATE_DEFAULT_TASK_PLAN_TXNS');
11688: IF l_debug_mode = 'Y' THEN
11689: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
11690: pa_debug.write('Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);

Line 11889: p_function =>'PA_FP_PLANNING_TRANSACTION_PUB.REFRESH_WP_SETTINGS'

11885:
11886: -- Set curr function
11887: IF l_debug_mode = 'Y' THEN
11888: pa_debug.set_curr_function(
11889: p_function =>'PA_FP_PLANNING_TRANSACTION_PUB.REFRESH_WP_SETTINGS'
11890: ,p_debug_mode => l_debug_mode );
11891: END IF;
11892: -- Check for business rules violations
11893: IF l_debug_mode = 'Y' THEN

Line 12197: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions (

12193: END IF;
12194:
12195: IF nvl(l_res_assignment_id_tbl.count,0) > 0 THEN
12196: -- If there is any data to be deleted call delete_planning_txns api
12197: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions (
12198: p_context => 'TASK_ASSIGNMENT'
12199: ,p_task_or_res => 'ASSIGNMENT'
12200: ,p_element_version_id_tbl => l_task_version_id_tbl
12201: ,p_task_number_tbl => l_task_number_tbl

Line 12544: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'

12540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12541: x_msg_count := 1;
12542: x_msg_data := SQLERRM;
12543:
12544: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
12545: ,p_procedure_name => 'REFRESH_WP_SETTINGS');
12546:
12547: IF l_debug_mode = 'Y' THEN
12548: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 12678: p_value1 => 'pa_fp_planning_transaction_pub.Refresh_rbs_for_versions');

12674:
12675: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
12676: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
12677: p_token1 => 'PROCEDURENAME',
12678: p_value1 => 'pa_fp_planning_transaction_pub.Refresh_rbs_for_versions');
12679:
12680: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
12681:
12682: END IF;

Line 12897: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_planning_transaction_pub'

12893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12894: x_msg_count := 1;
12895: x_msg_data := SQLERRM;
12896:
12897: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_planning_transaction_pub'
12898: ,p_procedure_name => 'Refresh_rbs_for_versions');
12899:
12900: IF l_debug_mode = 'Y' THEN
12901: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 12939: END PA_FP_PLANNING_TRANSACTION_PUB;

12935: RETURN l_dup_exists;
12936:
12937: END DUP_EXISTS;
12938:
12939: END PA_FP_PLANNING_TRANSACTION_PUB;
12940: