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.63.12020000.10 2013/05/29 09:50:22 bpottipa 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.63.12020000.10 2013/05/29 09:50:22 bpottipa 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 1072: pa_fp_planning_transaction_pub.delete_planning_transactions

1068: pa_debug.write(l_module_name,pa_debug.g_err_stage, 5);
1069: END IF;
1070: --dbms_output.put_line('7.5');
1071:
1072: pa_fp_planning_transaction_pub.delete_planning_transactions
1073: (
1074: p_context => p_context
1075: ,p_calling_context => p_calling_context -- Added for Bug 6856934
1076: ,p_task_or_res => 'ASSIGNMENT'

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

1228: WHEN OTHERS THEN
1229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1230: x_msg_count := 1;
1231: x_msg_data := SQLERRM;
1232: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
1233: ,p_procedure_name => 'Process_res_chg_Derv_calc_prms');
1234:
1235: IF l_debug_mode = 'Y' THEN
1236: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

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

1668: ,PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET ) THEN
1669:
1670: IF l_debug_mode = 'Y' THEN
1671: pa_debug.g_err_stage:='p_context passed is '||p_context;
1672: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1673: END IF;
1674: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1675: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1676: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

1683: IF (p_one_to_one_mapping_flag = 'Y'
1684: AND p_context = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_WORKPLAN) THEN
1685: IF l_debug_mode = 'Y' THEN
1686: pa_debug.g_err_stage:='p_one_to_one_mapping_flag passed as Y for WORKPLAN context :'||p_context;
1687: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1688: END IF;
1689: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1690: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1691: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

1699: p_task_elem_version_id_tbl.COUNT <> p_resource_list_member_id_tbl.COUNT) THEN
1700:
1701: IF l_debug_mode = 'Y' THEN
1702: pa_debug.g_err_stage:='Table Count Mismatch for p_one_to_one_mapping_flag Y in : '||p_context;
1703: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1704: END IF;
1705: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1706: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1707: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

1715: (p_planning_start_date_tbl.COUNT <> 0 OR p_planning_end_date_tbl.COUNT <> 0)) THEN
1716:
1717: IF l_debug_mode = 'Y' THEN
1718: pa_debug.g_err_stage:='Planning Date Passed when one to one mapping is N';
1719: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1720: END IF;
1721: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1722: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
1723: p_token1 => 'PROCEDURENAME',

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

1732: -- number of records
1733: IF (p_planning_start_date_tbl.COUNT <> p_planning_end_date_tbl.COUNT) THEN
1734: IF l_debug_mode = 'Y' THEN
1735: pa_debug.g_err_stage:='Planning Start Date - End Date MISMATCH p_context :'||p_context;
1736: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1737: END IF;
1738: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1739: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
1740: p_token1 => 'PROCEDURENAME',

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

1749: IF (p_planning_start_date_tbl.COUNT >0) THEN
1750: IF (p_planning_start_date_tbl.COUNT <> p_task_elem_version_id_tbl.COUNT) THEN
1751: IF l_debug_mode = 'Y' THEN
1752: pa_debug.g_err_stage:='Planning Start Date - Task Elem Mismatch :'||p_context;
1753: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1754: END IF;
1755: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1756: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
1757: p_token1 => 'PROCEDURENAME',

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

1786: IF p_one_to_one_mapping_flag = 'N' THEN
1787: IF p_skip_duplicates_flag = 'N' THEN
1788: IF l_debug_mode = 'Y' THEN
1789: pa_debug.g_err_stage:='Checking for duplicate rlm ids passed';
1790: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1791: END IF;
1792: IF p_resource_list_member_id_tbl.COUNT > 0 THEN
1793: FOR i IN p_resource_list_member_id_tbl.FIRST .. (p_resource_list_member_id_tbl.LAST-1) LOOP
1794: FOR j in (i+1) .. p_resource_list_member_id_tbl.LAST LOOP

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

1795: IF p_resource_list_member_id_tbl(j) = p_resource_list_member_id_tbl(i) THEN
1796: IF (l_prj_cbs_enabled = 'N' OR p_cbs_element_id_tbl.count <1) THEN
1797: IF l_debug_mode = 'Y' THEN
1798: pa_debug.g_err_stage:='Dup RLM ID Passed';
1799: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1800: END IF;
1801: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1802: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
1803: p_token1 => 'PROCEDURENAME',

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

1808: ELSE
1809: IF p_cbs_element_id_tbl(j) = p_cbs_element_id_tbl(i) THEN
1810: IF l_debug_mode = 'Y' THEN
1811: pa_debug.g_err_stage:='Dup RLM ID Passed';
1812: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1813: END IF;
1814: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1815: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
1816: p_token1 => 'PROCEDURENAME',

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

1825: END LOOP;
1826: END IF;
1827: IF l_debug_mode = 'Y' THEN
1828: pa_debug.g_err_stage:='Checking for duplicate elem ver ids passed';
1829: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1830: END IF;
1831: IF p_task_elem_version_id_tbl.COUNT > 0 THEN
1832: FOR i IN p_task_elem_version_id_tbl.FIRST .. (p_task_elem_version_id_tbl.LAST-1) LOOP
1833: FOR j in (i+1) .. p_task_elem_version_id_tbl.LAST LOOP

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

1833: FOR j in (i+1) .. p_task_elem_version_id_tbl.LAST LOOP
1834: IF p_task_elem_version_id_tbl(j) = p_task_elem_version_id_tbl(i) THEN
1835: IF l_debug_mode = 'Y' THEN
1836: pa_debug.g_err_stage:='Dup ELEM VER ID Passed';
1837: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1838: END IF;
1839: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1840: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
1841: p_token1 => 'PROCEDURENAME',

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

1865: IF p_currency_code_tbl(i) = p_currency_code_tbl(j) THEN
1866: IF (l_prj_cbs_enabled = 'N' OR p_cbs_element_id_tbl.count <1) THEN
1867: IF l_debug_mode = 'Y' THEN
1868: pa_debug.g_err_stage:='Dup Rec passed - Curr Code (B/F) - will error out in Ins Stat';
1869: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1870: END IF;
1871: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1872: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
1873: p_token1 => 'PROCEDURENAME',

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

1878: ELSE
1879: IF p_cbs_element_id_tbl(j) = p_cbs_element_id_tbl(i) THEN
1880: IF l_debug_mode = 'Y' THEN
1881: pa_debug.g_err_stage:='Dup Rec passed - Curr Code (B/F) - will error out in Ins Stat';
1882: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1883: END IF;
1884: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1885: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
1886: p_token1 => 'PROCEDURENAME',

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

1894: ELSE
1895: IF (l_prj_cbs_enabled = 'N' OR p_cbs_element_id_tbl.count <1) THEN
1896: IF l_debug_mode = 'Y' THEN
1897: pa_debug.g_err_stage:='Dup Rec passed - Curr Code (B/F) - will error out in Ins Stat';
1898: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1899: END IF;
1900: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1901: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
1902: p_token1 => 'PROCEDURENAME',

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

1907: ELSE
1908: IF p_cbs_element_id_tbl(j) = p_cbs_element_id_tbl(i) THEN
1909: IF l_debug_mode = 'Y' THEN
1910: pa_debug.g_err_stage:='Dup Rec passed - Curr Code (B/F) - will error out in Ins Stat';
1911: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1912: END IF;
1913: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1914: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
1915: p_token1 => 'PROCEDURENAME',

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

1935: (p_resource_list_member_id_tbl(i) = p_resource_list_member_id_tbl(j))) THEN
1936: IF (l_prj_cbs_enabled = 'N' OR p_cbs_element_id_tbl.count <1) THEN
1937: IF l_debug_mode = 'Y' THEN
1938: pa_debug.g_err_stage:='Dup Rec passed - will error out in Ins Stat p_context :'||p_context;
1939: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1940: END IF;
1941: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1942: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
1943: p_token1 => 'PROCEDURENAME',

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

1948: ELSE
1949: IF p_cbs_element_id_tbl(j) = p_cbs_element_id_tbl(i) THEN
1950: IF l_debug_mode = 'Y' THEN
1951: pa_debug.g_err_stage:='Dup Rec passed - will error out in Ins Stat p_context :'||p_context;
1952: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1953: END IF;
1954: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1955: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
1956: p_token1 => 'PROCEDURENAME',

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

1971: IF l_debug_mode = 'Y' THEN
1972: IF p_task_elem_version_id_tbl.COUNT > 0 THEN
1973: FOR i in p_task_elem_version_id_tbl.FIRST .. p_task_elem_version_id_tbl.LAST LOOP
1974: pa_debug.g_err_stage:='p_task_elem_version_id_tbl :'||p_task_elem_version_id_tbl(i);
1975: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1976: END LOOP;
1977: END IF;
1978:
1979: IF p_resource_list_member_id_tbl.COUNT > 0 THEN

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

1978:
1979: IF p_resource_list_member_id_tbl.COUNT > 0 THEN
1980: FOR i in p_resource_list_member_id_tbl.FIRST .. p_resource_list_member_id_tbl.LAST LOOP
1981: pa_debug.g_err_stage:='p_resource_list_member_id_tbl :'||p_resource_list_member_id_tbl(i);
1982: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1983: END LOOP;
1984: END IF;
1985:
1986: IF p_currency_code_tbl.COUNT > 0 THEN

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

1985:
1986: IF p_currency_code_tbl.COUNT > 0 THEN
1987: FOR i in p_currency_code_tbl.FIRST .. p_currency_code_tbl.LAST LOOP
1988: pa_debug.g_err_stage:='p_currency_code_tbl :'||p_currency_code_tbl(i);
1989: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
1990: END LOOP;
1991: END IF;
1992: END IF;
1993:

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

2007: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2008:
2009: IF l_debug_mode = 'Y' THEN
2010: pa_debug.g_err_stage:='Extending all table lengths to the permissible values they would take - p_context = '||p_context;
2011: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2012: END IF;
2013:
2014: l_task_elem_rlm_tbl.extend(l_rlm_id_no_of_rows);
2015: l_proj_elem_rlm_tbl.extend(l_rlm_id_no_of_rows);

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

2192: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2193:
2194: IF l_debug_mode = 'Y' THEN
2195: pa_debug.g_err_stage:='Validating input parameters - count of p_task_elem_version_id_tbl = '||l_elem_version_id_count;
2196: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2197: END IF;
2198:
2199: IF l_elem_version_id_count = 0 THEN
2200: l_trace_stage := 150;

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

2200: l_trace_stage := 150;
2201: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2202: IF l_debug_mode = 'Y' THEN
2203: pa_debug.g_err_stage:='Validating input parameters - elem_version_id table is empty - p_context = '||p_context;
2204: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2205: --dbms_output.put_line('Tasks tbl is empty for BF -- returning');
2206: pa_debug.reset_curr_function;
2207: END IF;
2208: RETURN;

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

2217: (p_start_date_tbl.COUNT <> p_task_elem_version_id_tbl.COUNT) THEN
2218:
2219: IF l_debug_mode = 'Y' THEN
2220: pa_debug.g_err_stage:='Invalid pl/sql tables for start and end dates';
2221: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2222: END IF;
2223: --dbms_output.put_line('$$$$%%%');
2224: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2225: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

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

2236: l_rlm_id_tbl_count := p_resource_list_member_id_tbl.COUNT;
2237:
2238: IF l_debug_mode = 'Y' THEN
2239: pa_debug.g_err_stage:='Validating input parameters - count of p_resource_list_member_id_tbl = '||l_rlm_id_tbl_count;
2240: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2241: END IF;
2242:
2243: IF l_rlm_id_tbl_count = 0 THEN
2244:

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

2243: IF l_rlm_id_tbl_count = 0 THEN
2244:
2245: IF l_debug_mode = 'Y' THEN
2246: pa_debug.g_err_stage:='Validating input parameters - Resource List Member Id table is empty - p_context = '||p_context;
2247: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2248: --dbms_output.put_line('Rlm tbl is empty for BF -- returning');
2249: pa_debug.reset_curr_function;
2250: END IF;
2251: RETURN;

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

2259: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2260:
2261: IF l_debug_mode = 'Y' THEN
2262: pa_debug.g_err_stage:='Validating input parameters - checking for project id : ' || p_project_id;
2263: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2264: END IF;
2265:
2266: l_trace_stage := 50;
2267: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));

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

2271: -------------------------------------------------------------------------------------------
2272: IF (p_project_id IS NULL) THEN
2273: IF l_debug_mode = 'Y' THEN
2274: pa_debug.g_err_stage:='p_project_id is null';
2275: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2276: END IF;
2277: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2278: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
2279: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

2296: IF p_struct_elem_version_id IS NULL THEN
2297:
2298: IF l_debug_mode = 'Y' THEN
2299: pa_debug.g_err_stage:='p_struct_elem_version_id is NULL and p_context = ' || p_context;
2300: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2301: END IF;
2302: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2303: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
2304: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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 pa_planning_transaction_utils.get_wp_budget_version_id p_struct_elem_version_id = ' || p_struct_elem_version_id;
2313: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2314: pa_debug.g_err_stage:='calling pa_planning_transaction_utils.get_wp_budget_version_id for deriving budget_version_id = ' || p_context;
2315: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2316: END IF;
2317:

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

2311: IF l_debug_mode = 'Y' THEN
2312: 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;
2313: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2314: pa_debug.g_err_stage:='calling pa_planning_transaction_utils.get_wp_budget_version_id for deriving budget_version_id = ' || p_context;
2315: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2316: END IF;
2317:
2318: l_budget_version_id := pa_planning_transaction_utils.get_wp_budget_version_id(p_struct_elem_version_id);
2319:

Line 2322: pa_fp_planning_transaction_pub.add_wp_plan_type

2318: l_budget_version_id := pa_planning_transaction_utils.get_wp_budget_version_id(p_struct_elem_version_id);
2319:
2320: l_trace_stage := 90;
2321: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2322: pa_fp_planning_transaction_pub.add_wp_plan_type
2323: (p_src_project_id => p_project_id
2324: ,p_targ_project_id => p_project_id
2325: ,x_return_status => x_return_status
2326: ,x_msg_count => x_msg_count

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

2330:
2331: -- 4504452.Added this if codition to get the return status.
2332: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2333: IF l_debug_mode = 'Y' THEN
2334: pa_debug.g_err_stage:='Called API pa_fp_planning_transaction_pub.add_wp_plan_type api returned error';
2335: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2336: END IF;
2337: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2338: END IF;

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

2331: -- 4504452.Added this if codition to get the return status.
2332: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2333: IF l_debug_mode = 'Y' THEN
2334: pa_debug.g_err_stage:='Called API pa_fp_planning_transaction_pub.add_wp_plan_type api returned error';
2335: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2336: END IF;
2337: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2338: END IF;
2339: -----------------------------------------------------

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

2344: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2345:
2346: IF l_debug_mode = 'Y' THEN
2347: pa_debug.g_err_stage:='calling pa_fin_plan_pub.create_version api = ' || p_context;
2348: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2349: END IF;
2350:
2351: SELECT fin_plan_type_id
2352: INTO l_fin_plan_type_id

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

2399: l_trace_stage := 120;
2400: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2401: IF l_debug_mode = 'Y' THEN
2402: pa_debug.g_err_stage:=' API pa_fin_plan_pub.create_version api return Status : '||l_return_status;
2403: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2404: pa_debug.g_err_stage:=' API pa_fin_plan_pub.create_version api l_budget_version_id : '||l_budget_version_id;
2405: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2406: pa_debug.g_err_stage:=' API pa_fin_plan_pub.create_version api l_proj_fp_options_id : '||l_proj_fp_options_id;
2407: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

2401: IF l_debug_mode = 'Y' THEN
2402: pa_debug.g_err_stage:=' API pa_fin_plan_pub.create_version api return Status : '||l_return_status;
2403: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2404: pa_debug.g_err_stage:=' API pa_fin_plan_pub.create_version api l_budget_version_id : '||l_budget_version_id;
2405: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2406: pa_debug.g_err_stage:=' API pa_fin_plan_pub.create_version api l_proj_fp_options_id : '||l_proj_fp_options_id;
2407: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2408: END IF;
2409:

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

2403: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2404: pa_debug.g_err_stage:=' API pa_fin_plan_pub.create_version api l_budget_version_id : '||l_budget_version_id;
2405: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2406: pa_debug.g_err_stage:=' API pa_fin_plan_pub.create_version api l_proj_fp_options_id : '||l_proj_fp_options_id;
2407: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2408: END IF;
2409:
2410: l_trace_stage := 130;
2411: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));

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

2412:
2413: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2414: IF l_debug_mode = 'Y' THEN
2415: pa_debug.g_err_stage:='Called API pa_fin_plan_pub.create_version api returned error';
2416: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2417: END IF;
2418: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2419: END IF;
2420:

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

2421: END IF;
2422:
2423: IF l_debug_mode = 'Y' THEN
2424: pa_debug.g_err_stage:='l_budget_version_id, l_fin_plan_type_id = '||l_budget_version_id||','|| l_fin_plan_type_id;
2425: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2426: END IF;
2427:
2428: END IF;
2429:

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

2433: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2434:
2435: IF l_debug_mode = 'Y' THEN
2436: pa_debug.g_err_stage:='Validating input parameters - count of p_task_elem_version_id_tbl = '||l_elem_version_id_count;
2437: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2438: END IF;
2439:
2440: IF l_elem_version_id_count = 0 THEN
2441: l_trace_stage := 150;

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

2441: l_trace_stage := 150;
2442: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2443: IF l_debug_mode = 'Y' THEN
2444: pa_debug.g_err_stage:='Validating input parameters - elem_version_id table is empty - p_context = '||p_context;
2445: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2446: pa_debug.reset_curr_function;
2447: END IF;
2448: RETURN;
2449: END IF;

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

2457: IF p_budget_version_id IS NULL THEN
2458:
2459: IF l_debug_mode = 'Y' THEN
2460: pa_debug.g_err_stage:='p_budget_version_id is null for p_context :' || p_context;
2461: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2462: END IF;
2463: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2464: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
2465: --dbms_output.put_line('bv id is null for BF');

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

2475: END IF;
2476:
2477: IF l_debug_mode = 'Y' THEN
2478: pa_debug.g_err_stage:='Fetching resource List id - l_resource_list_id : ';
2479: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2480: END IF;
2481: l_trace_stage := 200;
2482: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2483: --dbms_output.put_line('2.3 '||l_budget_version_id);

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

2491: WHERE fin_plan_version_id=l_budget_version_id;
2492:
2493: IF l_debug_mode = 'Y' THEN
2494: pa_debug.g_err_stage:='Fetching resource List id - l_resource_list_id : '|| l_resource_list_id;
2495: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2496: END IF;
2497:
2498: -- Fetching spread curve id for fixed date spread curve : Bug 3607061 - Starts
2499: BEGIN

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

2498: -- Fetching spread curve id for fixed date spread curve : Bug 3607061 - Starts
2499: BEGIN
2500: IF l_debug_mode = 'Y' THEN
2501: pa_debug.g_err_stage:='Fetching spread curve id for fixed date spread curve';
2502: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2503: END IF;
2504: Select spread_curve_id
2505: into l_fixed_date_sp_id
2506: from pa_spread_curves_b

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

2507: where spread_curve_code = 'FIXED_DATE';
2508:
2509: IF l_debug_mode = 'Y' THEN
2510: pa_debug.g_err_stage:='Fetching spread curve id l_fixed_date_sp_id:'||l_fixed_date_sp_id;
2511: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2512: END IF;
2513:
2514: EXCEPTION
2515: WHEN NO_DATA_FOUND THEN

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

2514: EXCEPTION
2515: WHEN NO_DATA_FOUND THEN
2516: IF l_debug_mode = 'Y' THEN
2517: pa_debug.g_err_stage:='Fixed date spread curve not found in system';
2518: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,5);
2519: END IF;
2520: RAISE;
2521: END;
2522: -- Fetching spread curve id for fixed date spread curve : Bug 3607061 - Ends

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

2537: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2538:
2539: IF l_debug_mode = 'Y' THEN
2540: pa_debug.g_err_stage:='Calling API pa_planning_transaction_utils.Get_Res_Class_Rlm_Ids';
2541: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2542: END IF;
2543:
2544: pa_planning_transaction_utils.Get_Res_Class_Rlm_Ids
2545: (p_project_id => p_project_id,

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

2555: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2556: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2557: IF l_debug_mode = 'Y' THEN
2558: pa_debug.g_err_stage:='Called API pa_planning_transaction_utils.Get_Res_Class_Rlm_Ids api returned error';
2559: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2560: END IF;
2561: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2562: END IF;
2563:

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

2565: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2566:
2567: IF l_debug_mode = 'Y' THEN
2568: pa_debug.g_err_stage:='l_people_res_class_rlm_id : '||l_people_res_class_rlm_id;
2569: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2570: END IF;
2571:
2572: l_eligible_rlm_ids_tbl(1) := l_people_res_class_rlm_id;
2573:

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

2621: --------------------------------------------------------------------
2622:
2623: IF l_debug_mode = 'Y' THEN
2624: pa_debug.g_err_stage:='Calling API PA_PLANNING_RESOURCE_UTILS.get_resource_defaults';
2625: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2626: END IF;
2627:
2628: l_trace_stage := 300;
2629: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));

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

2671: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2672:
2673: IF l_debug_mode = 'Y' THEN
2674: pa_debug.g_err_stage:='Called APIPA_PLANNING_RESOURCE_UTILS.get_resource_defaults api returned error';
2675: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2676: END IF;
2677: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2678:
2679: END IF;

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

2681: IF l_debug_mode = 'Y' THEN
2682:
2683: IF l_eligible_rlm_ids_tbl.COUNT >0 THEN
2684: pa_debug.g_err_stage:='Parameters to PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs';
2685: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2686:
2687:
2688: pa_debug.g_err_stage:='p_budget_version_id '||l_budget_version_id;
2689: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

2685: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2686:
2687:
2688: pa_debug.g_err_stage:='p_budget_version_id '||l_budget_version_id;
2689: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2690:
2691: pa_debug.g_err_stage:='l_resource_list_id '||l_resource_list_id;
2692: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2693:

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

2688: pa_debug.g_err_stage:='p_budget_version_id '||l_budget_version_id;
2689: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2690:
2691: pa_debug.g_err_stage:='l_resource_list_id '||l_resource_list_id;
2692: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2693:
2694: pa_debug.g_err_stage:='l_rbs_version_id '||l_rbs_version_id;
2695: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2696:

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

2691: pa_debug.g_err_stage:='l_resource_list_id '||l_resource_list_id;
2692: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2693:
2694: pa_debug.g_err_stage:='l_rbs_version_id '||l_rbs_version_id;
2695: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2696:
2697: pa_debug.g_err_stage:='l_eligible_rlm_ids_tbl(1) '||l_eligible_rlm_ids_tbl(1);
2698: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2699:

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

2694: pa_debug.g_err_stage:='l_rbs_version_id '||l_rbs_version_id;
2695: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2696:
2697: pa_debug.g_err_stage:='l_eligible_rlm_ids_tbl(1) '||l_eligible_rlm_ids_tbl(1);
2698: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2699:
2700: pa_debug.g_err_stage:='l_txn_src_typ_code_rbs_prm_tbl(1) '||l_txn_src_typ_code_rbs_prm_tbl(1);
2701: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2702:

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

2697: pa_debug.g_err_stage:='l_eligible_rlm_ids_tbl(1) '||l_eligible_rlm_ids_tbl(1);
2698: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2699:
2700: pa_debug.g_err_stage:='l_txn_src_typ_code_rbs_prm_tbl(1) '||l_txn_src_typ_code_rbs_prm_tbl(1);
2701: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2702:
2703: pa_debug.g_err_stage:='l_person_id_tbl(1) '||l_person_id_tbl(1);
2704: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2705:

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

2700: pa_debug.g_err_stage:='l_txn_src_typ_code_rbs_prm_tbl(1) '||l_txn_src_typ_code_rbs_prm_tbl(1);
2701: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2702:
2703: pa_debug.g_err_stage:='l_person_id_tbl(1) '||l_person_id_tbl(1);
2704: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2705:
2706: pa_debug.g_err_stage:='l_job_id_tbl(1) '||l_job_id_tbl(1);
2707: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2708:

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

2703: pa_debug.g_err_stage:='l_person_id_tbl(1) '||l_person_id_tbl(1);
2704: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2705:
2706: pa_debug.g_err_stage:='l_job_id_tbl(1) '||l_job_id_tbl(1);
2707: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2708:
2709: pa_debug.g_err_stage:='l_organization_id_tbl(1) '||l_organization_id_tbl(1);
2710: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2711:

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

2706: pa_debug.g_err_stage:='l_job_id_tbl(1) '||l_job_id_tbl(1);
2707: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2708:
2709: pa_debug.g_err_stage:='l_organization_id_tbl(1) '||l_organization_id_tbl(1);
2710: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2711:
2712: pa_debug.g_err_stage:='l_supplier_id_tbl(1) '||l_supplier_id_tbl(1);
2713: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2714:

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

2709: pa_debug.g_err_stage:='l_organization_id_tbl(1) '||l_organization_id_tbl(1);
2710: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2711:
2712: pa_debug.g_err_stage:='l_supplier_id_tbl(1) '||l_supplier_id_tbl(1);
2713: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2714:
2715: pa_debug.g_err_stage:='l_expenditure_type_tbl(1) '||l_expenditure_type_tbl(1);
2716: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2717:

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

2712: pa_debug.g_err_stage:='l_supplier_id_tbl(1) '||l_supplier_id_tbl(1);
2713: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2714:
2715: pa_debug.g_err_stage:='l_expenditure_type_tbl(1) '||l_expenditure_type_tbl(1);
2716: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2717:
2718: pa_debug.g_err_stage:='l_event_type_tbl(1) '||l_event_type_tbl(1);
2719: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2720:

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

2715: pa_debug.g_err_stage:='l_expenditure_type_tbl(1) '||l_expenditure_type_tbl(1);
2716: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2717:
2718: pa_debug.g_err_stage:='l_event_type_tbl(1) '||l_event_type_tbl(1);
2719: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2720:
2721: pa_debug.g_err_stage:='l_expenditure_category_tbl(1) '||l_expenditure_category_tbl(1);
2722: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2723:

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

2718: pa_debug.g_err_stage:='l_event_type_tbl(1) '||l_event_type_tbl(1);
2719: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2720:
2721: pa_debug.g_err_stage:='l_expenditure_category_tbl(1) '||l_expenditure_category_tbl(1);
2722: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2723:
2724: pa_debug.g_err_stage:='l_revenue_category_code_tbl(1) '||l_revenue_category_code_tbl(1);
2725: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2726:

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

2721: pa_debug.g_err_stage:='l_expenditure_category_tbl(1) '||l_expenditure_category_tbl(1);
2722: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2723:
2724: pa_debug.g_err_stage:='l_revenue_category_code_tbl(1) '||l_revenue_category_code_tbl(1);
2725: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2726:
2727: pa_debug.g_err_stage:='l_project_role_id_tbl(1) '||l_project_role_id_tbl(1);
2728: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2729:

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

2724: pa_debug.g_err_stage:='l_revenue_category_code_tbl(1) '||l_revenue_category_code_tbl(1);
2725: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2726:
2727: pa_debug.g_err_stage:='l_project_role_id_tbl(1) '||l_project_role_id_tbl(1);
2728: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2729:
2730: pa_debug.g_err_stage:='l_resource_class_code_tbl(1) '||l_resource_class_code_tbl(1);
2731: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2732:

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

2727: pa_debug.g_err_stage:='l_project_role_id_tbl(1) '||l_project_role_id_tbl(1);
2728: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2729:
2730: pa_debug.g_err_stage:='l_resource_class_code_tbl(1) '||l_resource_class_code_tbl(1);
2731: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2732:
2733: pa_debug.g_err_stage:='l_item_category_id_tbl(1) '||l_item_category_id_tbl(1);
2734: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2735:

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

2730: pa_debug.g_err_stage:='l_resource_class_code_tbl(1) '||l_resource_class_code_tbl(1);
2731: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2732:
2733: pa_debug.g_err_stage:='l_item_category_id_tbl(1) '||l_item_category_id_tbl(1);
2734: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2735:
2736: pa_debug.g_err_stage:='l_person_type_code_tbl(1) '||l_person_type_code_tbl(1);
2737: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2738:

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

2733: pa_debug.g_err_stage:='l_item_category_id_tbl(1) '||l_item_category_id_tbl(1);
2734: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2735:
2736: pa_debug.g_err_stage:='l_person_type_code_tbl(1) '||l_person_type_code_tbl(1);
2737: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2738:
2739: pa_debug.g_err_stage:='l_bom_resource_id_tbl(1) '||l_bom_resource_id_tbl(1);
2740: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2741:

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

2736: pa_debug.g_err_stage:='l_person_type_code_tbl(1) '||l_person_type_code_tbl(1);
2737: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2738:
2739: pa_debug.g_err_stage:='l_bom_resource_id_tbl(1) '||l_bom_resource_id_tbl(1);
2740: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2741:
2742: END IF;
2743:
2744:

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

2795:
2796: --Call the RBS Mapping API only if the rbs version id is not null
2797: IF l_rbs_version_id IS NOT NULL THEN
2798:
2799: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,'before PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs',3);
2800:
2801: PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs(
2802: p_budget_version_id => l_budget_version_id
2803: ,p_resource_list_id => l_resource_list_id

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

2837: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2838:
2839: IF l_debug_mode = 'Y' THEN
2840: pa_debug.g_err_stage:='Called API PA_RLMI_RBS_MAP_PUB.Map_Rlmi_Rbs returned error';
2841: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2842: END IF;
2843: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2844:
2845: END IF;

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

2870: l_trace_stage := 340;
2871: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
2872: IF l_debug_mode = 'Y' THEN
2873: pa_debug.g_err_stage:='Doing processing for TASK ASSIGNMENTS : p_context is'|| p_context;
2874: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2875: END IF;
2876: -------------------------------------------------------------------------
2877: -- To call Task Validation API we populate the PLSql tables with task
2878: -- and resource data.

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

2879: -------------------------------------------------------------------------
2880:
2881: IF l_debug_mode = 'Y' THEN
2882: pa_debug.g_err_stage:='Populating PlSql table with Task Data';
2883: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2884: END IF;
2885:
2886: -----------------------------------------------------------------
2887: -- Populating Table of task_rec_type

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

2928: -----------------------------------------------------------------
2929:
2930: IF l_debug_mode = 'Y' THEN
2931: pa_debug.g_err_stage:='Populating PlSql table with Resource Data';
2932: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
2933: END IF;
2934:
2935: l_trace_stage := 380;
2936: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));

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

3223: -- Calling Task validation API
3224: -------------------------------------------------
3225: IF l_debug_mode = 'Y' THEN
3226: pa_debug.g_err_stage:='Calling API pa_task_assignment_utils.Validate_Create_Assignment';
3227: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3228: END IF;
3229:
3230: l_trace_stage := 420;
3231: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));

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

3245:
3246: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3247: IF l_debug_mode = 'Y' THEN
3248: pa_debug.g_err_stage:='Called API pa_task_assignment_utils.Validate_Create_Assignment returned error';
3249: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3250: END IF;
3251: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3252: END IF;
3253: IF l_debug_mode = 'Y' THEN

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

3251: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3252: END IF;
3253: IF l_debug_mode = 'Y' THEN
3254: pa_debug.g_err_stage:='Returned from pa_task_assignment_utils.Validate_Create_Assignment';
3255: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3256: END IF;
3257:
3258: l_trace_stage := 430;
3259: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));

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

3273: -----------------------------------------------------------------------
3274:
3275: IF l_debug_mode = 'Y' THEN
3276: pa_debug.g_err_stage:='Deleting Data from all resource PLSql tables';
3277: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3278: END IF;
3279:
3280: l_trace_stage := 450;
3281: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));

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

3287: -----------------------------------------------------------------------
3288:
3289: IF l_debug_mode = 'Y' THEN
3290: pa_debug.g_err_stage:='Populating resource data tables from the output parameter table l_resource_rec_tbl';
3291: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3292: END IF;
3293:
3294: FOR i IN l_resource_rec_tbl.FIRST .. l_resource_rec_tbl.LAST LOOP
3295: l_trace_stage := 460;

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

3864: ------------------------------------------------------------------------------
3865:
3866: IF l_debug_mode = 'Y' THEN
3867: pa_debug.g_err_stage:='data is deleted in bulk from pa_budget_lines and pa_resource_assignment based on the resource_assignment_id ';
3868: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3869: END IF;
3870:
3871: END IF;
3872: --------------------------------------------------------------------------

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

3877: -- Deriving Time Phased Code based on the budget version id and setting the spread amount flad
3878: -------------------------------------------------------------------------------------------------
3879: IF l_debug_mode = 'Y' THEN
3880: pa_debug.g_err_stage:='Deriving time phased code ';
3881: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3882: END IF;
3883:
3884: l_time_phased_code := pa_fin_plan_utils.get_time_phased_code(p_budget_version_id);
3885:

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

3884: l_time_phased_code := pa_fin_plan_utils.get_time_phased_code(p_budget_version_id);
3885:
3886: IF l_debug_mode = 'Y' THEN
3887: pa_debug.g_err_stage:='Deriving time phased code l_time_phased_code: '||l_time_phased_code;
3888: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3889: END IF;
3890: l_trace_stage := 550;
3891: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
3892:

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

3903: -- Deriving Proj Element Id based on element version id
3904: -------------------------------------------------------------------------------------------------
3905: IF l_debug_mode = 'Y' THEN
3906: pa_debug.g_err_stage:='Deriving Proj Element Id based on element version id';
3907: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3908: END IF;
3909:
3910: FOR i IN p_task_elem_version_id_tbl.FIRST .. p_task_elem_version_id_tbl.LAST LOOP
3911: l_trace_stage := 570;

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

3916: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
3917: FETCH c_proj_element_id INTO l_proj_element_id;
3918: IF l_debug_mode = 'Y' THEN
3919: pa_debug.g_err_stage:='Deriving Proj Element Id based on element version id l_proj_element_id : '|| l_proj_element_id;
3920: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3921: END IF;
3922: l_proj_element_id_tbl(i) := l_proj_element_id;
3923: CLOSE c_proj_element_id;
3924:

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

3936: END IF;
3937: IF l_alt_tsk_valid = 'N' THEN
3938: IF l_debug_mode = 'Y' THEN
3939: pa_debug.g_err_stage:='Cost Code for the given task is not valid : '|| l_proj_element_id;
3940: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3941: END IF;
3942: END IF;
3943: END IF;
3944:

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

3950: END LOOP;
3951:
3952: IF l_debug_mode = 'Y' THEN
3953: 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;
3954: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3955: END IF;
3956: l_trace_stage := 600;
3957: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
3958:

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

3965: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
3966:
3967: IF l_debug_mode = 'Y' THEN
3968: pa_debug.g_err_stage:='Deriving start date for task_element_version_ids';
3969: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
3970: END IF;
3971:
3972: -- Bug 3793623 - Added new params p_planning_start_date_tbl and p_planning_end_date_tbl
3973: PA_PLANNING_TRANSACTION_UTILS.get_default_planning_dates

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

3985: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3986:
3987: IF l_debug_mode = 'Y' THEN
3988: pa_debug.g_err_stage:='Called API pafpptub.get_default_planning_dates returned error';
3989: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ',pa_debug.g_err_stage, 3);
3990: END IF;
3991: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3992: END IF;
3993:

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

4020: -----------------------------------------------------------------------------------------------------
4021:
4022: IF l_debug_mode = 'Y' THEN
4023: pa_debug.g_err_stage:='BULK INSERTING DATA INTO PA_RESOURCE_ASSIGNMENTS ';
4024: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4025: END IF;
4026:
4027: l_call_calc_api := 'N';
4028:

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

4133: -- NEEDED FOR DEBUGGIND ISSUE WITH BULK DTA INSERTION.
4134: -----------------------------------------------------
4135: /*
4136: pa_debug.g_err_stage:='l_proj_element_id_tbl :'||l_proj_element_id_tbl.COUNT;
4137: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4138: pa_debug.g_err_stage:='l_unit_of_measure_tbl :'||l_unit_of_measure_tbl.COUNT;
4139: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4140: pa_debug.g_err_stage:='p_task_elem_version_id_tbl :'||p_task_elem_version_id_tbl.COUNT;
4141: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4135: /*
4136: pa_debug.g_err_stage:='l_proj_element_id_tbl :'||l_proj_element_id_tbl.COUNT;
4137: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4138: pa_debug.g_err_stage:='l_unit_of_measure_tbl :'||l_unit_of_measure_tbl.COUNT;
4139: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4140: pa_debug.g_err_stage:='p_task_elem_version_id_tbl :'||p_task_elem_version_id_tbl.COUNT;
4141: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4142: pa_debug.g_err_stage:='l_start_date_tbl :'||p_start_date_tbl.COUNT;
4143: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4137: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4138: pa_debug.g_err_stage:='l_unit_of_measure_tbl :'||l_unit_of_measure_tbl.COUNT;
4139: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4140: pa_debug.g_err_stage:='p_task_elem_version_id_tbl :'||p_task_elem_version_id_tbl.COUNT;
4141: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4142: pa_debug.g_err_stage:='l_start_date_tbl :'||p_start_date_tbl.COUNT;
4143: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4144: pa_debug.g_err_stage:='l_end_date_tbl :'||p_end_date_tbl.COUNT;
4145: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4139: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4140: pa_debug.g_err_stage:='p_task_elem_version_id_tbl :'||p_task_elem_version_id_tbl.COUNT;
4141: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4142: pa_debug.g_err_stage:='l_start_date_tbl :'||p_start_date_tbl.COUNT;
4143: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4144: pa_debug.g_err_stage:='l_end_date_tbl :'||p_end_date_tbl.COUNT;
4145: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4146: pa_debug.g_err_stage:='l_etc_method_code_tbl :'||l_etc_method_code_tbl.COUNT;
4147: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4141: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4142: pa_debug.g_err_stage:='l_start_date_tbl :'||p_start_date_tbl.COUNT;
4143: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4144: pa_debug.g_err_stage:='l_end_date_tbl :'||p_end_date_tbl.COUNT;
4145: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4146: pa_debug.g_err_stage:='l_etc_method_code_tbl :'||l_etc_method_code_tbl.COUNT;
4147: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4148: pa_debug.g_err_stage:='l_res_type_code_tbl :'||l_res_type_code_tbl.COUNT;
4149: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4143: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4144: pa_debug.g_err_stage:='l_end_date_tbl :'||p_end_date_tbl.COUNT;
4145: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4146: pa_debug.g_err_stage:='l_etc_method_code_tbl :'||l_etc_method_code_tbl.COUNT;
4147: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4148: pa_debug.g_err_stage:='l_res_type_code_tbl :'||l_res_type_code_tbl.COUNT;
4149: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4150: pa_debug.g_err_stage:='l_fc_res_type_code_tbl :'||l_fc_res_type_code_tbl.COUNT;
4151: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4145: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4146: pa_debug.g_err_stage:='l_etc_method_code_tbl :'||l_etc_method_code_tbl.COUNT;
4147: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4148: pa_debug.g_err_stage:='l_res_type_code_tbl :'||l_res_type_code_tbl.COUNT;
4149: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4150: pa_debug.g_err_stage:='l_fc_res_type_code_tbl :'||l_fc_res_type_code_tbl.COUNT;
4151: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4152: pa_debug.g_err_stage:='l_resource_class_code_tbl :'||l_resource_class_code_tbl.COUNT;
4153: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4147: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4148: pa_debug.g_err_stage:='l_res_type_code_tbl :'||l_res_type_code_tbl.COUNT;
4149: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4150: pa_debug.g_err_stage:='l_fc_res_type_code_tbl :'||l_fc_res_type_code_tbl.COUNT;
4151: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4152: pa_debug.g_err_stage:='l_resource_class_code_tbl :'||l_resource_class_code_tbl.COUNT;
4153: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4154: pa_debug.g_err_stage:='l_organization_id_tbl :'||l_organization_id_tbl.COUNT;
4155: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4149: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4150: pa_debug.g_err_stage:='l_fc_res_type_code_tbl :'||l_fc_res_type_code_tbl.COUNT;
4151: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4152: pa_debug.g_err_stage:='l_resource_class_code_tbl :'||l_resource_class_code_tbl.COUNT;
4153: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4154: pa_debug.g_err_stage:='l_organization_id_tbl :'||l_organization_id_tbl.COUNT;
4155: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4156: pa_debug.g_err_stage:='l_job_id_tbl :'||l_job_id_tbl.COUNT;
4157: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4151: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4152: pa_debug.g_err_stage:='l_resource_class_code_tbl :'||l_resource_class_code_tbl.COUNT;
4153: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4154: pa_debug.g_err_stage:='l_organization_id_tbl :'||l_organization_id_tbl.COUNT;
4155: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4156: pa_debug.g_err_stage:='l_job_id_tbl :'||l_job_id_tbl.COUNT;
4157: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4158: pa_debug.g_err_stage:='l_person_id_tbl :'||l_person_id_tbl.COUNT;
4159: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4153: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4154: pa_debug.g_err_stage:='l_organization_id_tbl :'||l_organization_id_tbl.COUNT;
4155: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4156: pa_debug.g_err_stage:='l_job_id_tbl :'||l_job_id_tbl.COUNT;
4157: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4158: pa_debug.g_err_stage:='l_person_id_tbl :'||l_person_id_tbl.COUNT;
4159: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4160: pa_debug.g_err_stage:='l_revenue_category_code_tbl :'||l_revenue_category_code_tbl.COUNT;
4161: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4155: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4156: pa_debug.g_err_stage:='l_job_id_tbl :'||l_job_id_tbl.COUNT;
4157: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4158: pa_debug.g_err_stage:='l_person_id_tbl :'||l_person_id_tbl.COUNT;
4159: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4160: pa_debug.g_err_stage:='l_revenue_category_code_tbl :'||l_revenue_category_code_tbl.COUNT;
4161: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4162: pa_debug.g_err_stage:='l_expenditure_type_tbl :'||l_expenditure_type_tbl.COUNT;
4163: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4157: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4158: pa_debug.g_err_stage:='l_person_id_tbl :'||l_person_id_tbl.COUNT;
4159: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4160: pa_debug.g_err_stage:='l_revenue_category_code_tbl :'||l_revenue_category_code_tbl.COUNT;
4161: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4162: pa_debug.g_err_stage:='l_expenditure_type_tbl :'||l_expenditure_type_tbl.COUNT;
4163: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4164: pa_debug.g_err_stage:='l_expenditure_category_tbl :'||l_expenditure_category_tbl.COUNT;
4165: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4159: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4160: pa_debug.g_err_stage:='l_revenue_category_code_tbl :'||l_revenue_category_code_tbl.COUNT;
4161: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4162: pa_debug.g_err_stage:='l_expenditure_type_tbl :'||l_expenditure_type_tbl.COUNT;
4163: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4164: pa_debug.g_err_stage:='l_expenditure_category_tbl :'||l_expenditure_category_tbl.COUNT;
4165: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4166: pa_debug.g_err_stage:='l_non_labor_resource_tbl :'||l_non_labor_resource_tbl.COUNT;
4167: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4161: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4162: pa_debug.g_err_stage:='l_expenditure_type_tbl :'||l_expenditure_type_tbl.COUNT;
4163: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4164: pa_debug.g_err_stage:='l_expenditure_category_tbl :'||l_expenditure_category_tbl.COUNT;
4165: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4166: pa_debug.g_err_stage:='l_non_labor_resource_tbl :'||l_non_labor_resource_tbl.COUNT;
4167: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4168: pa_debug.g_err_stage:='l_event_type_tbl :'||l_event_type_tbl.COUNT;
4169: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4163: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4164: pa_debug.g_err_stage:='l_expenditure_category_tbl :'||l_expenditure_category_tbl.COUNT;
4165: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4166: pa_debug.g_err_stage:='l_non_labor_resource_tbl :'||l_non_labor_resource_tbl.COUNT;
4167: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4168: pa_debug.g_err_stage:='l_event_type_tbl :'||l_event_type_tbl.COUNT;
4169: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4170: pa_debug.g_err_stage:='l_supplier_id_tbl :'||l_supplier_id_tbl.COUNT;
4171: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4165: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4166: pa_debug.g_err_stage:='l_non_labor_resource_tbl :'||l_non_labor_resource_tbl.COUNT;
4167: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4168: pa_debug.g_err_stage:='l_event_type_tbl :'||l_event_type_tbl.COUNT;
4169: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4170: pa_debug.g_err_stage:='l_supplier_id_tbl :'||l_supplier_id_tbl.COUNT;
4171: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4172: pa_debug.g_err_stage:='l_inventory_item_id_tbl :'||l_inventory_item_id_tbl.COUNT;
4173: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4167: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4168: pa_debug.g_err_stage:='l_event_type_tbl :'||l_event_type_tbl.COUNT;
4169: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4170: pa_debug.g_err_stage:='l_supplier_id_tbl :'||l_supplier_id_tbl.COUNT;
4171: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4172: pa_debug.g_err_stage:='l_inventory_item_id_tbl :'||l_inventory_item_id_tbl.COUNT;
4173: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4174: pa_debug.g_err_stage:='l_bom_resource_id_tbl :'||l_bom_resource_id_tbl.COUNT;
4175: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4169: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4170: pa_debug.g_err_stage:='l_supplier_id_tbl :'||l_supplier_id_tbl.COUNT;
4171: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4172: pa_debug.g_err_stage:='l_inventory_item_id_tbl :'||l_inventory_item_id_tbl.COUNT;
4173: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4174: pa_debug.g_err_stage:='l_bom_resource_id_tbl :'||l_bom_resource_id_tbl.COUNT;
4175: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4176: pa_debug.g_err_stage:='l_inventory_item_id_tbl :'||l_inventory_item_id_tbl.COUNT;
4177: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4171: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4172: pa_debug.g_err_stage:='l_inventory_item_id_tbl :'||l_inventory_item_id_tbl.COUNT;
4173: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4174: pa_debug.g_err_stage:='l_bom_resource_id_tbl :'||l_bom_resource_id_tbl.COUNT;
4175: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4176: pa_debug.g_err_stage:='l_inventory_item_id_tbl :'||l_inventory_item_id_tbl.COUNT;
4177: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4178: pa_debug.g_err_stage:='l_item_category_id_tbl :'||l_item_category_id_tbl.COUNT;
4179: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4173: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4174: pa_debug.g_err_stage:='l_bom_resource_id_tbl :'||l_bom_resource_id_tbl.COUNT;
4175: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4176: pa_debug.g_err_stage:='l_inventory_item_id_tbl :'||l_inventory_item_id_tbl.COUNT;
4177: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4178: pa_debug.g_err_stage:='l_item_category_id_tbl :'||l_item_category_id_tbl.COUNT;
4179: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4180: pa_debug.g_err_stage:='l_mfc_cost_type_id_tbl :'||l_mfc_cost_type_id_tbl.COUNT;
4181: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4175: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4176: pa_debug.g_err_stage:='l_inventory_item_id_tbl :'||l_inventory_item_id_tbl.COUNT;
4177: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4178: pa_debug.g_err_stage:='l_item_category_id_tbl :'||l_item_category_id_tbl.COUNT;
4179: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4180: pa_debug.g_err_stage:='l_mfc_cost_type_id_tbl :'||l_mfc_cost_type_id_tbl.COUNT;
4181: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4182: pa_debug.g_err_stage:='l_rate_expenditure_type_tbl :'||l_rate_expenditure_type_tbl.COUNT;
4183: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4177: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4178: pa_debug.g_err_stage:='l_item_category_id_tbl :'||l_item_category_id_tbl.COUNT;
4179: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4180: pa_debug.g_err_stage:='l_mfc_cost_type_id_tbl :'||l_mfc_cost_type_id_tbl.COUNT;
4181: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4182: pa_debug.g_err_stage:='l_rate_expenditure_type_tbl :'||l_rate_expenditure_type_tbl.COUNT;
4183: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4184: pa_debug.g_err_stage:='l_rate_func_curr_code_tbl :'||l_rate_func_curr_code_tbl.COUNT;
4185: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4179: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4180: pa_debug.g_err_stage:='l_mfc_cost_type_id_tbl :'||l_mfc_cost_type_id_tbl.COUNT;
4181: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4182: pa_debug.g_err_stage:='l_rate_expenditure_type_tbl :'||l_rate_expenditure_type_tbl.COUNT;
4183: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4184: pa_debug.g_err_stage:='l_rate_func_curr_code_tbl :'||l_rate_func_curr_code_tbl.COUNT;
4185: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4186: pa_debug.g_err_stage:='l_rate_based_flag_tbl :'||l_rate_based_flag_tbl.COUNT;
4187: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4181: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4182: pa_debug.g_err_stage:='l_rate_expenditure_type_tbl :'||l_rate_expenditure_type_tbl.COUNT;
4183: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4184: pa_debug.g_err_stage:='l_rate_func_curr_code_tbl :'||l_rate_func_curr_code_tbl.COUNT;
4185: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4186: pa_debug.g_err_stage:='l_rate_based_flag_tbl :'||l_rate_based_flag_tbl.COUNT;
4187: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4188: pa_debug.g_err_stage:='l_resource_class_flag_tbl :'||l_resource_class_flag_tbl.COUNT;
4189: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4183: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4184: pa_debug.g_err_stage:='l_rate_func_curr_code_tbl :'||l_rate_func_curr_code_tbl.COUNT;
4185: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4186: pa_debug.g_err_stage:='l_rate_based_flag_tbl :'||l_rate_based_flag_tbl.COUNT;
4187: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4188: pa_debug.g_err_stage:='l_resource_class_flag_tbl :'||l_resource_class_flag_tbl.COUNT;
4189: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4190: pa_debug.g_err_stage:='l_named_role_tbl :'||l_named_role_tbl.COUNT;
4191: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4185: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4186: pa_debug.g_err_stage:='l_rate_based_flag_tbl :'||l_rate_based_flag_tbl.COUNT;
4187: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4188: pa_debug.g_err_stage:='l_resource_class_flag_tbl :'||l_resource_class_flag_tbl.COUNT;
4189: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4190: pa_debug.g_err_stage:='l_named_role_tbl :'||l_named_role_tbl.COUNT;
4191: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4192: pa_debug.g_err_stage:='l_incur_by_res_class_code_tbl :'||l_incur_by_res_class_code_tbl.COUNT;
4193: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4187: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4188: pa_debug.g_err_stage:='l_resource_class_flag_tbl :'||l_resource_class_flag_tbl.COUNT;
4189: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4190: pa_debug.g_err_stage:='l_named_role_tbl :'||l_named_role_tbl.COUNT;
4191: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4192: pa_debug.g_err_stage:='l_incur_by_res_class_code_tbl :'||l_incur_by_res_class_code_tbl.COUNT;
4193: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4194: pa_debug.g_err_stage:='l_budget_version_id :'||l_budget_version_id;
4195: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4189: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4190: pa_debug.g_err_stage:='l_named_role_tbl :'||l_named_role_tbl.COUNT;
4191: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4192: pa_debug.g_err_stage:='l_incur_by_res_class_code_tbl :'||l_incur_by_res_class_code_tbl.COUNT;
4193: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4194: pa_debug.g_err_stage:='l_budget_version_id :'||l_budget_version_id;
4195: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4196: pa_debug.g_err_stage:='p_project_id :'||p_project_id;
4197: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4191: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4192: pa_debug.g_err_stage:='l_incur_by_res_class_code_tbl :'||l_incur_by_res_class_code_tbl.COUNT;
4193: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4194: pa_debug.g_err_stage:='l_budget_version_id :'||l_budget_version_id;
4195: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4196: pa_debug.g_err_stage:='p_project_id :'||p_project_id;
4197: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4198: pa_debug.g_err_stage:='task_id :'||l_proj_element_id_tbl(i);
4199: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4193: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4194: pa_debug.g_err_stage:='l_budget_version_id :'||l_budget_version_id;
4195: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4196: pa_debug.g_err_stage:='p_project_id :'||p_project_id;
4197: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4198: pa_debug.g_err_stage:='task_id :'||l_proj_element_id_tbl(i);
4199: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4200: pa_debug.g_err_stage:='project_assignment_id : -1';
4201: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);

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

4195: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4196: pa_debug.g_err_stage:='p_project_id :'||p_project_id;
4197: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4198: pa_debug.g_err_stage:='task_id :'||l_proj_element_id_tbl(i);
4199: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4200: pa_debug.g_err_stage:='project_assignment_id : -1';
4201: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4202: pa_debug.g_err_stage:='RESOURCE_LIST_MEMBER_ID :'||l_people_res_class_rlm_id;
4203: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);*/

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

4197: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4198: pa_debug.g_err_stage:='task_id :'||l_proj_element_id_tbl(i);
4199: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4200: pa_debug.g_err_stage:='project_assignment_id : -1';
4201: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4202: pa_debug.g_err_stage:='RESOURCE_LIST_MEMBER_ID :'||l_people_res_class_rlm_id;
4203: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);*/
4204:
4205: /* l_trace_stage := 761;

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

4199: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4200: pa_debug.g_err_stage:='project_assignment_id : -1';
4201: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4202: pa_debug.g_err_stage:='RESOURCE_LIST_MEMBER_ID :'||l_people_res_class_rlm_id;
4203: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);*/
4204:
4205: /* l_trace_stage := 761;
4206: hr_utility.trace('l_proj_element_id_tbl(i) => '||to_char(l_proj_element_id_tbl(i)));
4207: hr_utility.trace('l_unit_of_measure_tbl(l_ppl_index) => '||to_char(l_unit_of_measure_tbl(l_ppl_index)));

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

4241: l_ppl_index:=1; --This will be used in the bulk insert for people -- -- Bug 3749516
4242:
4243: IF l_debug_mode = 'Y' THEN
4244: pa_debug.g_err_stage:='BULK INSERTING DATA - p_context - Workplan :'||p_context ;
4245: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4246:
4247: pa_debug.g_err_stage:='BULK INSERTING Workplan DATA - rlm id :'||l_eligible_rlm_ids_tbl(l_ppl_index) ;
4248: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,6);
4249: END IF;

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

4244: pa_debug.g_err_stage:='BULK INSERTING DATA - p_context - Workplan :'||p_context ;
4245: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4246:
4247: pa_debug.g_err_stage:='BULK INSERTING Workplan DATA - rlm id :'||l_eligible_rlm_ids_tbl(l_ppl_index) ;
4248: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,6);
4249: END IF;
4250: -- gboomina Bug 8586393 - start
4251: -- Get 'Assignment same as Task Duration' flag from workplan attribute
4252: -- and default it for hidden task assignments

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

4302:
4303:
4304: IF l_debug_mode = 'Y' THEN
4305: pa_debug.g_err_stage:='AFTER PREPARING INS DATA :'||p_context ;
4306: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4307:
4308: IF l_ins_task_elem_version_id_tbl.COUNT >0 THEN
4309: FOR i in l_ins_task_elem_version_id_tbl.FIRST .. l_ins_task_elem_version_id_tbl.LAST LOOP
4310: pa_debug.g_err_stage:='l_ins_proj_element_id_tbl :'||l_ins_proj_element_id_tbl(i) ;

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

4307:
4308: IF l_ins_task_elem_version_id_tbl.COUNT >0 THEN
4309: FOR i in l_ins_task_elem_version_id_tbl.FIRST .. l_ins_task_elem_version_id_tbl.LAST LOOP
4310: pa_debug.g_err_stage:='l_ins_proj_element_id_tbl :'||l_ins_proj_element_id_tbl(i) ;
4311: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4312:
4313: pa_debug.g_err_stage:='l_ins_task_elem_version_id_tbl :'||l_ins_task_elem_version_id_tbl(i) ;
4314: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4315:

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

4310: pa_debug.g_err_stage:='l_ins_proj_element_id_tbl :'||l_ins_proj_element_id_tbl(i) ;
4311: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4312:
4313: pa_debug.g_err_stage:='l_ins_task_elem_version_id_tbl :'||l_ins_task_elem_version_id_tbl(i) ;
4314: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4315:
4316: pa_debug.g_err_stage:='l_ins_start_date_tbl :'||l_ins_start_date_tbl(i) ;
4317: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4318:

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

4313: pa_debug.g_err_stage:='l_ins_task_elem_version_id_tbl :'||l_ins_task_elem_version_id_tbl(i) ;
4314: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4315:
4316: pa_debug.g_err_stage:='l_ins_start_date_tbl :'||l_ins_start_date_tbl(i) ;
4317: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4318:
4319: pa_debug.g_err_stage:='l_ins_end_date_tbl :'||l_ins_end_date_tbl(i) ;
4320: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4321: END LOOP;

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

4316: pa_debug.g_err_stage:='l_ins_start_date_tbl :'||l_ins_start_date_tbl(i) ;
4317: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4318:
4319: pa_debug.g_err_stage:='l_ins_end_date_tbl :'||l_ins_end_date_tbl(i) ;
4320: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4321: END LOOP;
4322: END IF;
4323: END IF;
4324:

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

4508: l_trace_stage := 780;
4509: -- hr_utility.trace('PA_FP_PLAN_TXN_PUB.add_planning_transactions: '||to_char(l_trace_stage));
4510: IF l_debug_mode = 'Y' THEN
4511: pa_debug.g_err_stage:='BULK INSERTING DATA - WORPLAN - PEOPLE '||l_res_assignment_id_temp_tbl(k);
4512: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4513: END IF;
4514: l_quantity_tbl(l_index) := l_ins_cal_people_effort_tbl(k);
4515: l_res_assignment_id_tbl(l_index) := l_res_assignment_id_temp_tbl(k);
4516: -- IF l_spread_amounts_for_ver = 'Y' THEN

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

4567: --------------------------------------------
4568: IF p_context = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_TASK THEN
4569: IF l_debug_mode = 'Y' THEN
4570: pa_debug.g_err_stage:='BULK INSERTING DATA - Context TASK p_context : '||p_context;
4571: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4572: END IF;
4573:
4574: -- Bug 12384023: Deriving job_id based on assignment start date :start
4575: FOR j IN l_eligible_rlm_ids_tbl.FIRST .. l_eligible_rlm_ids_tbl.LAST LOOP

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

4575: FOR j IN l_eligible_rlm_ids_tbl.FIRST .. l_eligible_rlm_ids_tbl.LAST LOOP
4576:
4577: IF l_debug_mode = 'Y' THEN
4578: pa_debug.g_err_stage:='PA_PLANNING_RESOURCE_UTILS: default_job l_job_id_tbl(j) : '||l_job_id_tbl(j);
4579: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4580: END IF;
4581:
4582: l_job_id_temp := NULL; --bug#13566990
4583:

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

4596: END IF;
4597:
4598: IF l_debug_mode = 'Y' THEN
4599: pa_debug.g_err_stage:='l_job_id_tbl(j) : '||l_job_id_tbl(j);
4600: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4601: END IF;
4602:
4603: END LOOP;
4604: -- Bug 12384023: Deriving job_id based on assignment start date :end

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

4789:
4790: IF l_res_assignment_id_temp_tbl.COUNT <> l_eligible_rlm_ids_tbl.COUNT THEN
4791: IF l_debug_mode = 'Y' THEN
4792: pa_debug.g_err_stage:='For Budget and Forcast p_context - data mismatch';
4793: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4794: END IF;
4795: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4796: END IF;
4797: -----------------------------------------------------------------------

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

4809: FOR k IN l_res_assignment_id_temp_tbl.FIRST .. l_res_assignment_id_temp_tbl.LAST LOOP
4810:
4811: IF l_debug_mode = 'Y' THEN
4812: pa_debug.g_err_stage:='BULK INSERTING DATA - TASK Setting DATA - raid count : '||l_res_assignment_id_temp_tbl.COUNT;
4813: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4814: END IF;
4815:
4816: -- Bug 8370812 - Moved inside the IF loop
4817: -- l_res_assignment_id_tbl(l_index) := l_res_assignment_id_temp_tbl(k);

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

4830: AND (p_burdened_cost_tbl(k) is NOT NULL))) THEN
4831:
4832: IF l_debug_mode = 'Y' THEN
4833: pa_debug.g_err_stage:='BULK INSERTING DATA - TASK spread amount flag';
4834: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4835: END IF;
4836:
4837: -- Bug 8370812
4838: l_res_assignment_id_tbl(l_index) := l_res_assignment_id_temp_tbl(k);

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

4956:
4957: BEGIN
4958: IF l_debug_mode = 'Y' THEN
4959: pa_debug.g_err_stage:='BULK INSERTING DATA - Context TASK p_context : '||p_context;
4960: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4961:
4962: pa_debug.g_err_stage:='l_eligible_rlm_ids_tbl.count '||l_eligible_rlm_ids_tbl.count;
4963: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4964:

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

4959: pa_debug.g_err_stage:='BULK INSERTING DATA - Context TASK p_context : '||p_context;
4960: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4961:
4962: pa_debug.g_err_stage:='l_eligible_rlm_ids_tbl.count '||l_eligible_rlm_ids_tbl.count;
4963: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4964:
4965: pa_debug.g_err_stage:='l_bf_quantity_tbl.count '||l_bf_quantity_tbl.count;
4966: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4967:

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

4962: pa_debug.g_err_stage:='l_eligible_rlm_ids_tbl.count '||l_eligible_rlm_ids_tbl.count;
4963: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4964:
4965: pa_debug.g_err_stage:='l_bf_quantity_tbl.count '||l_bf_quantity_tbl.count;
4966: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4967:
4968: pa_debug.g_err_stage:='l_bf_raw_cost_tbl.count '||l_bf_raw_cost_tbl.count;
4969: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4970:

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

4965: pa_debug.g_err_stage:='l_bf_quantity_tbl.count '||l_bf_quantity_tbl.count;
4966: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4967:
4968: pa_debug.g_err_stage:='l_bf_raw_cost_tbl.count '||l_bf_raw_cost_tbl.count;
4969: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4970:
4971: pa_debug.g_err_stage:='l_bf_burdened_cost_tbl.count '||l_bf_burdened_cost_tbl.count;
4972: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4973:

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

4968: pa_debug.g_err_stage:='l_bf_raw_cost_tbl.count '||l_bf_raw_cost_tbl.count;
4969: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4970:
4971: pa_debug.g_err_stage:='l_bf_burdened_cost_tbl.count '||l_bf_burdened_cost_tbl.count;
4972: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4973:
4974: pa_debug.g_err_stage:='l_bf_revenue_tbl.count '||l_bf_revenue_tbl.count;
4975: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4976:

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

4971: pa_debug.g_err_stage:='l_bf_burdened_cost_tbl.count '||l_bf_burdened_cost_tbl.count;
4972: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4973:
4974: pa_debug.g_err_stage:='l_bf_revenue_tbl.count '||l_bf_revenue_tbl.count;
4975: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4976:
4977: pa_debug.g_err_stage:='l_bf_currency_code_tbl.count '||l_bf_currency_code_tbl.count;
4978: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4979:

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

4974: pa_debug.g_err_stage:='l_bf_revenue_tbl.count '||l_bf_revenue_tbl.count;
4975: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4976:
4977: pa_debug.g_err_stage:='l_bf_currency_code_tbl.count '||l_bf_currency_code_tbl.count;
4978: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4979:
4980: pa_debug.g_err_stage:='l_bf_cost_rate_tbl.count '||l_bf_cost_rate_tbl.count;
4981: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4982:

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

4977: pa_debug.g_err_stage:='l_bf_currency_code_tbl.count '||l_bf_currency_code_tbl.count;
4978: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4979:
4980: pa_debug.g_err_stage:='l_bf_cost_rate_tbl.count '||l_bf_cost_rate_tbl.count;
4981: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4982:
4983: pa_debug.g_err_stage:='l_bf_bill_rate_tbl.count '||l_bf_bill_rate_tbl.count;
4984: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4985:

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

4980: pa_debug.g_err_stage:='l_bf_cost_rate_tbl.count '||l_bf_cost_rate_tbl.count;
4981: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4982:
4983: pa_debug.g_err_stage:='l_bf_bill_rate_tbl.count '||l_bf_bill_rate_tbl.count;
4984: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4985:
4986: pa_debug.g_err_stage:='l_bf_burdened_rate_tbl.count '||l_bf_burdened_rate_tbl.count;
4987: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4988:

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

4983: pa_debug.g_err_stage:='l_bf_bill_rate_tbl.count '||l_bf_bill_rate_tbl.count;
4984: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4985:
4986: pa_debug.g_err_stage:='l_bf_burdened_rate_tbl.count '||l_bf_burdened_rate_tbl.count;
4987: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
4988:
4989:
4990: END IF;
4991:

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

5364:
5365: IF (l_index + SQL%BULK_EXCEPTIONS.COUNT ) <> l_eligible_rlm_ids_tbl.COUNT THEN
5366:
5367: pa_debug.g_err_stage:='No of inserted records + No. of errored records is not equal to total no. of input records';
5368: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5369:
5370: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5371: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
5372: p_token1 => 'PROCEDURENAME',

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

5463:
5464: IF (l_index + SQL%BULK_EXCEPTIONS.COUNT ) <> l_eligible_rlm_ids_tbl.COUNT THEN
5465:
5466: pa_debug.g_err_stage:='No of inserted records + No. of errored records is not equal to total no. of input records';
5467: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5468:
5469: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5470: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
5471: p_token1 => 'PROCEDURENAME',

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

5489:
5490: ELSE
5491:
5492: pa_debug.g_err_stage:='No of duplicates found '||SQL%BULK_EXCEPTIONS.COUNT;
5493: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5494:
5495: RAISE;
5496:
5497: END IF;

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

5499: END;
5500:
5501: IF l_debug_mode = 'Y' THEN
5502: pa_debug.g_err_stage:='FLAG 2 '||l_bf_ra_id_tbl.COUNT;
5503: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5504: END IF;
5505:
5506: -------------------------------------------------------------------------------
5507: --No of records in rlm id tbl should be equal to the no of records in ra id tb;

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

5510: (p_skip_duplicates_flag = 'N') THEN
5511:
5512: IF l_debug_mode = 'Y' THEN
5513: pa_debug.g_err_stage:='INSIDE Bulk Data insert for budget/forecast';
5514: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5515:
5516: pa_debug.g_err_stage:='For Budget and Forcast p_context - data mismatch';
5517: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5518: END IF;

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

5513: pa_debug.g_err_stage:='INSIDE Bulk Data insert for budget/forecast';
5514: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5515:
5516: pa_debug.g_err_stage:='For Budget and Forcast p_context - data mismatch';
5517: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5518: END IF;
5519: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5520:
5521: END IF;

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

5573:
5574: IF l_amount_exists ='Y' THEN
5575: IF l_debug_mode = 'Y' THEN
5576: pa_debug.g_err_stage:='Amount exists and preparing the tbls for calc API';
5577: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5578: END IF;
5579:
5580: IF l_bf_currency_code_tbl.EXISTS(k) AND
5581: NVL(l_bf_currency_code_tbl(k),FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

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

5583: ELSE
5584:
5585: IF l_debug_mode = 'Y' THEN
5586: pa_debug.g_err_stage:='Currency code not passed when amounts are passed';
5587: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5588: END IF;
5589: --dbms_output.put_line('curr code not passed');
5590: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5591: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

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

5648: IF l_debug_mode = 'Y' THEN
5649: IF l_res_assignment_id_tbl.COUNT > 0 THEN
5650: FOR i in l_res_assignment_id_tbl.FIRST .. l_res_assignment_id_tbl.LAST LOOP
5651: pa_debug.g_err_stage:='CALCULATE PARAM l_res_assignment_id_tbl :'||l_res_assignment_id_tbl(i);
5652: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5653:
5654: pa_debug.g_err_stage:='CALCULATE PARAM l_quantity_tbl :'||l_quantity_tbl(i);
5655: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5656:

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

5651: pa_debug.g_err_stage:='CALCULATE PARAM l_res_assignment_id_tbl :'||l_res_assignment_id_tbl(i);
5652: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5653:
5654: pa_debug.g_err_stage:='CALCULATE PARAM l_quantity_tbl :'||l_quantity_tbl(i);
5655: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5656:
5657: pa_debug.g_err_stage:='CALCULATE PARAM l_raw_cost_tbl :'||l_raw_cost_tbl(i);
5658: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5659:

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

5654: pa_debug.g_err_stage:='CALCULATE PARAM l_quantity_tbl :'||l_quantity_tbl(i);
5655: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5656:
5657: pa_debug.g_err_stage:='CALCULATE PARAM l_raw_cost_tbl :'||l_raw_cost_tbl(i);
5658: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5659:
5660: pa_debug.g_err_stage:='CALCULATE PARAM l_burdened_cost_tbl :'||l_burdened_cost_tbl(i);
5661: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5662:

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

5657: pa_debug.g_err_stage:='CALCULATE PARAM l_raw_cost_tbl :'||l_raw_cost_tbl(i);
5658: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5659:
5660: pa_debug.g_err_stage:='CALCULATE PARAM l_burdened_cost_tbl :'||l_burdened_cost_tbl(i);
5661: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5662:
5663: pa_debug.g_err_stage:='CALCULATE PARAM l_revenue_tbl :'||l_revenue_tbl(i);
5664: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5665:

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

5660: pa_debug.g_err_stage:='CALCULATE PARAM l_burdened_cost_tbl :'||l_burdened_cost_tbl(i);
5661: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5662:
5663: pa_debug.g_err_stage:='CALCULATE PARAM l_revenue_tbl :'||l_revenue_tbl(i);
5664: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5665:
5666: pa_debug.g_err_stage:='CALCULATE PARAM l_currency_code_tbl :'||l_currency_code_tbl(i);
5667: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5668:

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

5663: pa_debug.g_err_stage:='CALCULATE PARAM l_revenue_tbl :'||l_revenue_tbl(i);
5664: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5665:
5666: pa_debug.g_err_stage:='CALCULATE PARAM l_currency_code_tbl :'||l_currency_code_tbl(i);
5667: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5668:
5669: pa_debug.g_err_stage:='CALCULATE PARAM l_cost_rate_tbl :'||l_cost_rate_tbl(i);
5670: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5671:

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

5666: pa_debug.g_err_stage:='CALCULATE PARAM l_currency_code_tbl :'||l_currency_code_tbl(i);
5667: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5668:
5669: pa_debug.g_err_stage:='CALCULATE PARAM l_cost_rate_tbl :'||l_cost_rate_tbl(i);
5670: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5671:
5672: pa_debug.g_err_stage:='CALCULATE PARAM l_burden_multiplier_tbl :'||l_burden_multiplier_tbl(i);
5673: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5674:

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

5669: pa_debug.g_err_stage:='CALCULATE PARAM l_cost_rate_tbl :'||l_cost_rate_tbl(i);
5670: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5671:
5672: pa_debug.g_err_stage:='CALCULATE PARAM l_burden_multiplier_tbl :'||l_burden_multiplier_tbl(i);
5673: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5674:
5675: pa_debug.g_err_stage:='CALCULATE PARAM l_bill_rate_tbl :'||l_bill_rate_tbl(i);
5676: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5677: END LOOP;

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

5672: pa_debug.g_err_stage:='CALCULATE PARAM l_burden_multiplier_tbl :'||l_burden_multiplier_tbl(i);
5673: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5674:
5675: pa_debug.g_err_stage:='CALCULATE PARAM l_bill_rate_tbl :'||l_bill_rate_tbl(i);
5676: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5677: END LOOP;
5678: END IF;
5679: END IF;
5680:

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

5707:
5708: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5709: IF l_debug_mode = 'Y' THEN
5710: pa_debug.g_err_stage:='Called API PA_FP_CALC_PLAN_PKG.calculate api returned error';
5711: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5712: END IF;
5713:
5714: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5715: END IF;

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

5754:
5755: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5756: IF l_debug_mode = 'Y' THEN
5757: pa_debug.g_err_stage:='Called API PA_PROJ_TASK_STRUC_PUB.process_wbs_updates_wrp';
5758: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5759: END IF;
5760:
5761: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5762: END IF;

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

5795:
5796: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5797: IF l_debug_mode = 'Y' THEN
5798: pa_debug.g_err_stage:='Called API PA_FIN_PLAN_PUB.create_default_plan_txn_rec returned error';
5799: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage, 3);
5800: END IF;
5801: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5802: END IF; /* 7161809 */
5803:

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

5821: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5822:
5823: IF l_debug_mode = 'Y' THEN
5824: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
5825: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage, 3);
5826: END IF;
5827: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5828: END IF;
5829:

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

5888: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5889:
5890: IF l_debug_mode = 'Y' THEN
5891: pa_debug.g_err_stage:='Called API pa_res_asg_currency_pub.maintain_data returned error';
5892: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage, 3);
5893: END IF;
5894: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5895: END IF; */
5896:

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

5895: END IF; */
5896:
5897: IF l_debug_mode = 'Y' THEN
5898: pa_debug.g_err_stage:='CALLED THE PA_FP_CALC_PLAN_PKG.CALCULATE API';
5899: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
5900: pa_debug.reset_curr_function;
5901: END IF;
5902: EXCEPTION
5903:

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

5928: ROLLBACK TO SAVEPOINT ADD_PLANNING_TRANS_SP;
5929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5930: x_msg_count := 1;
5931: x_msg_data := SQLERRM;
5932: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
5933: ,p_procedure_name => 'add_planning_transactions');
5934:
5935: IF l_debug_mode = 'Y' THEN
5936: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

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

6074: l_msg_index_out NUMBER;
6075: l_debug_mode VARCHAR2(1);
6076: l_debug_level3 CONSTANT NUMBER := 3;
6077: l_debug_level5 CONSTANT NUMBER := 5;
6078: l_module_name VARCHAR2(100) := 'Update_Planning_Transactions' || 'pa.plsql.pa_fp_planning_transaction_pub';
6079: l_loop_start NUMBER;
6080: l_loop_end NUMBER;
6081:
6082: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

Line 6382: pa_fp_planning_transaction_pub.add_planning_transactions

6378: END;
6379:
6380:
6381:
6382: pa_fp_planning_transaction_pub.add_planning_transactions
6383: (p_context =>'WORKPLAN'
6384: ,p_calling_context => p_calling_context -- Added for Bug 6856934
6385: ,p_project_id => l_project_id
6386: ,p_struct_elem_version_id => p_struct_elem_version_id

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

6388: ,x_msg_data => l_msg_data
6389: ,x_msg_count => l_msg_count);
6390: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6391: IF l_debug_mode = 'Y' THEN
6392: pa_debug.g_err_stage:='Called API pa_fp_planning_transaction_pub.add_planning_transaction api returned error';
6393: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
6394: END IF;
6395: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6396: END IF;

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

8218:
8219: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8220: IF l_debug_mode = 'Y' THEN
8221: pa_debug.g_err_stage:='Called API PA_PROJ_TASK_STRUC_PUB.process_wbs_updates_wrp';
8222: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.update_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
8223: END IF;
8224:
8225: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
8226: END IF;

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

8279: WHEN OTHERS THEN
8280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8281: x_msg_count := 1;
8282: x_msg_data := SQLERRM;
8283: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
8284: ,p_procedure_name => 'Update_Planning_Transactions');
8285:
8286: IF l_debug_mode = 'Y' THEN
8287: pa_debug.g_err_stage:='Unexpected Error' || SQLERRM;

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

9161:
9162: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
9163: IF l_debug_mode = 'Y' THEN
9164: pa_debug.g_err_stage:='Called API PA_PROJ_TASK_STRUC_PUB.process_wbs_updates_wrp';
9165: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.copy_planning_transactions: ' || g_module_name,pa_debug.g_err_stage,3);
9166: END IF;
9167:
9168: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
9169: END IF;

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

9263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9264: x_msg_count := 1;
9265: x_msg_data := SQLERRM;
9266:
9267: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_planning_transaction_pub'
9268: ,p_procedure_name => 'copy_planning_transactions');
9269:
9270: IF l_debug_mode = 'Y' THEN
9271: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

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

10833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10834: x_msg_count := 1;
10835: x_msg_data := SQLERRM;
10836:
10837: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_planning_transaction_pub'
10838: ,p_procedure_name => 'delete_planning_transactions');
10839:
10840: IF l_debug_mode = 'Y' THEN
10841: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

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

10893: l_debug_mode := NVL(l_debug_mode, 'N');
10894: x_msg_count := 0;
10895: x_return_status := FND_API.G_RET_STS_SUCCESS;
10896: IF l_debug_mode = 'Y' THEN
10897: PA_DEBUG.Set_Curr_Function( p_function => 'PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type',
10898: p_debug_mode => l_debug_mode );
10899: END IF;
10900: ---------------------------------------------------------------
10901: -- validating input parameter p_project_id.

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

10902: -- p_project_id cannot be passed as null.
10903: ---------------------------------------------------------------
10904: IF l_debug_mode = 'Y' THEN
10905: pa_debug.g_err_stage:='Validating input parameters';
10906: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);
10907: END IF;
10908:
10909: IF (p_src_project_id IS NULL) OR
10910: (p_targ_project_id IS NULL) THEN

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

10909: IF (p_src_project_id IS NULL) OR
10910: (p_targ_project_id IS NULL) THEN
10911: IF l_debug_mode = 'Y' THEN
10912: pa_debug.g_err_stage:='Invalid Arguments Passed - src and targ Project Ids are null';
10913: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,5);
10914: END IF;
10915: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
10916: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
10917: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

10923: ---------------------------------------------------------------
10924:
10925: IF l_debug_mode = 'Y' THEN
10926: pa_debug.g_err_stage:='checking availability of a wp type';
10927: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);
10928: END IF;
10929:
10930: ---------------------------------------------------------
10931: -- In case of no data found, the exception handling block

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

10942:
10943: WHEN NO_DATA_FOUND THEN
10944: IF l_debug_mode = 'Y' THEN
10945: pa_debug.g_err_stage :='No WORK PLAN TYPE present in the system';
10946: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,1);
10947: END IF;
10948:
10949: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
10950: p_msg_name => 'PA_FP_NO_WP_PLAN_TYPE' );

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

10957: -- passed project_id
10958: ---------------------------------------------------------
10959: IF l_debug_mode = 'Y' THEN
10960: pa_debug.g_err_stage:='checking if wp type is already attched for project id';
10961: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);
10962: END IF;
10963:
10964: BEGIN -- BLOCK to check if workplan_type is already attched for the passed project_id - Starts
10965:

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

10988: IF l_proj_wp_type_exists = 0 THEN
10989:
10990: IF l_debug_mode = 'Y' THEN
10991: pa_debug.g_err_stage:='Getting the fp option id for the wp plan type of the source project ';
10992: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);
10993: END IF;
10994:
10995: IF p_src_project_id <> p_targ_project_id THEN
10996:

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

11011:
11012:
11013: IF l_debug_mode = 'Y' THEN
11014: pa_debug.g_err_stage:='Calling API pa_proj_fp_options_pub.create_fp_option';
11015: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);
11016: END IF;
11017:
11018: IF l_debug_mode = 'Y' THEN
11019: pa_debug.g_err_stage:='The source fp option id is '||l_src_fp_option_id;

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

11016: END IF;
11017:
11018: IF l_debug_mode = 'Y' THEN
11019: pa_debug.g_err_stage:='The source fp option id is '||l_src_fp_option_id;
11020: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,3);
11021: END IF;
11022:
11023:
11024: pa_proj_fp_options_pub.Create_FP_Option (

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

11035:
11036: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11037: IF l_debug_mode = 'Y' THEN
11038: pa_debug.g_err_stage:='Called API pa_proj_fp_options_pub.Create_FP_Option returned error';
11039: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,5);
11040: END IF;
11041: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11042: END IF;
11043:

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

11062:
11063: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11064: IF l_debug_mode = 'Y' THEN
11065: pa_debug.g_err_stage:='Called API PA_FP_TXN_CURRENCIES_PUB.COPY_FP_TXN_CURRENCIES returned error';
11066: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,5);
11067: END IF;
11068: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11069: END IF;
11070:

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

11097: WHEN OTHERS THEN
11098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11099: x_msg_count := 1;
11100: x_msg_data := SQLERRM;
11101: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
11102: ,p_procedure_name => 'PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type');
11103:
11104: IF l_debug_mode = 'Y' THEN
11105: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

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

11098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11099: x_msg_count := 1;
11100: x_msg_data := SQLERRM;
11101: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
11102: ,p_procedure_name => 'PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type');
11103:
11104: IF l_debug_mode = 'Y' THEN
11105: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
11106: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,5);

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

11102: ,p_procedure_name => 'PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type');
11103:
11104: IF l_debug_mode = 'Y' THEN
11105: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
11106: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Add_wp_plan_type: ' || g_module_name,pa_debug.g_err_stage,5);
11107: pa_debug.reset_curr_function;
11108: END IF;
11109: RAISE;
11110:

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

11156: l_error_msg_code VARCHAR2(30);
11157: l_msg_index_out NUMBER;
11158: l_return_status VARCHAR2(2000);
11159: l_debug_mode VARCHAR2(30);
11160: l_module_name VARCHAR2(100):='pa.plsql.pa_fp_planning_transaction_pub.check_and_create_task_rec_info' ;
11161: l_rec_exsists VARCHAR2(1);
11162: --End of variables used for debugging
11163:
11164:

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

11491: );
11492:
11493: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11494: IF l_debug_mode = 'Y' THEN
11495: pa_debug.g_err_stage:='Called API PA_FP_PLANNING_TRANSACTION_PUB.add_planning_transactions ,api returned error';
11496: pa_debug.write( l_module_name,pa_debug.g_err_stage,5);
11497: END IF;
11498: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11499: END IF;

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

11526: WHEN OTHERS THEN
11527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11528: x_msg_count := 1;
11529: x_msg_data := SQLERRM;
11530: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
11531: ,p_procedure_name => 'check_and_create_task_rec_info');
11532:
11533: IF l_debug_mode = 'Y' THEN
11534: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 11643: p_function =>'PA_FP_PLANNING_TRANSACTION_PUB.Refresh_Plan_Txns'

11639:
11640: -- Set curr function
11641: IF l_debug_mode = 'Y' THEN
11642: PA_DEBUG.set_curr_function(
11643: p_function =>'PA_FP_PLANNING_TRANSACTION_PUB.Refresh_Plan_Txns'
11644: ,p_debug_mode => l_debug_mode );
11645: END IF;
11646: -- Check for business rules violations
11647:

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

11719: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11720:
11721: IF l_debug_mode = 'Y' THEN
11722: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
11723: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
11724: END IF;
11725: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11726: END IF;
11727:

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

11754: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11755:
11756: IF l_debug_mode = 'Y' THEN
11757: pa_debug.g_err_stage:='Called API pa_res_asg_currency_pub.maintain_data returned error';
11758: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
11759: END IF;
11760: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11761: END IF;
11762:

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

11805: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11806:
11807: IF l_debug_mode = 'Y' THEN
11808: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
11809: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
11810: END IF;
11811: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11812: END IF;
11813:

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

11829: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11830:
11831: IF l_debug_mode = 'Y' THEN
11832: pa_debug.g_err_stage:='Called API pa_res_asg_currency_pub.maintain_data returned error';
11833: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
11834: END IF;
11835: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11836: END IF;
11837:

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

11870: IF l_res_list_uncategorized_flag = 'Y' THEN
11871: -- Insert default task planning trasaction for the version
11872:
11873: IF l_debug_mode = 'Y' THEN
11874: pa_debug.g_err_stage:='Calling pa_fp_planning_transaction_pub.create_default_task_plan_txns';
11875: pa_debug.write('Refresh_Plan_Txns: ' || g_module_name,pa_debug.g_err_stage,3);
11876: END IF;
11877:
11878: pa_fp_planning_transaction_pub.create_default_task_plan_txns (

Line 11878: pa_fp_planning_transaction_pub.create_default_task_plan_txns (

11874: pa_debug.g_err_stage:='Calling pa_fp_planning_transaction_pub.create_default_task_plan_txns';
11875: pa_debug.write('Refresh_Plan_Txns: ' || g_module_name,pa_debug.g_err_stage,3);
11876: END IF;
11877:
11878: pa_fp_planning_transaction_pub.create_default_task_plan_txns (
11879: p_budget_version_id => p_budget_version_id
11880: ,p_version_plan_level_code => budget_version_info_rec.fin_plan_level_code
11881: ,x_return_status => x_return_status
11882: ,x_msg_count => x_msg_count

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

11972: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11973:
11974: IF l_debug_mode = 'Y' THEN
11975: pa_debug.g_err_stage:='Called API pa_fp_gen_amount_utils.get_plan_version_dtls returned error';
11976: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
11977: END IF;
11978: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11979: END IF;
11980:

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

11996: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11997:
11998: IF l_debug_mode = 'Y' THEN
11999: pa_debug.g_err_stage:='Called API pa_res_asg_currency_pub.maintain_data returned error';
12000: pa_debug.WRITE('pa_fp_planning_transaction_pub.Refresh_Plan_Txns',pa_debug.g_err_stage, 3);
12001: END IF;
12002: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
12003: END IF;
12004: END IF; --} IF l_delete_ra_id_tbl.COUNT > 0 THEN

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

12146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12147: x_msg_count := 1;
12148: x_msg_data := SQLERRM;
12149:
12150: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
12151: ,p_procedure_name => 'Refresh_Plan_Txns');
12152:
12153: IF l_debug_mode = 'Y' THEN
12154: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

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

12176: ,X_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
12177: AS
12178:
12179:
12180: l_module_name varchar2(100):= 'pa.plsql.pa_fp_planning_transaction_pub';
12181:
12182: -- Start of variables used for debugging purpose
12183: l_msg_count NUMBER :=0;
12184: l_data VARCHAR2(2000);

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

12354:
12355: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12356: IF l_debug_mode = 'Y' THEN
12357: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
12358: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);
12359: END IF;
12360: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
12361: END IF;
12362:

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

12369: EXCEPTION
12370: WHEN OTHERS THEN
12371: IF l_debug_mode = 'Y' THEN
12372: pa_debug.g_err_stage:='Error while fetching plan_class_code for the budget_version_id';
12373: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);
12374: END IF;
12375: RAISE;
12376: END;
12377:

Line 12413: pa_fp_planning_transaction_pub.add_planning_transactions (

12409:
12410: l_element_version_id_tbl.extend(1);
12411: l_element_version_id_tbl(1):= 0;
12412:
12413: pa_fp_planning_transaction_pub.add_planning_transactions (
12414: p_context => l_plan_class_code
12415: /* Passing calling module as creation version, since we dont want calculate api to be called */
12416: ,p_calling_module => 'CREATE_VERSION'
12417: ,p_project_id => version_info_rec.project_id

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

12424:
12425: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12426: IF l_debug_mode = 'Y' THEN
12427: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
12428: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);
12429: END IF;
12430: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
12431: END IF;
12432:

Line 12451: pa_fp_planning_transaction_pub.add_planning_transactions (

12447: LOOP
12448: FETCH top_tasks_cur BULK COLLECT INTO l_element_version_id_tbl LIMIT l_max_fetch_size;
12449:
12450: IF nvl(l_element_version_id_tbl.last,0) >= 1 THEN
12451: pa_fp_planning_transaction_pub.add_planning_transactions (
12452: p_context => l_plan_class_code
12453: /* Passing calling module as creation version, since we dont want calculate api to be called */
12454: ,p_calling_module => 'CREATE_VERSION'
12455: ,p_project_id => version_info_rec.project_id

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

12463:
12464: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12465: IF l_debug_mode = 'Y' THEN
12466: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
12467: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);
12468: END IF;
12469: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
12470: END IF;
12471: -- Exit if fetch size is less than 200

Line 12498: pa_fp_planning_transaction_pub.add_planning_transactions (

12494: LOOP
12495: FETCH lowest_tasks_cur BULK COLLECT INTO l_element_version_id_tbl LIMIT l_max_fetch_size;
12496:
12497: IF nvl(l_element_version_id_tbl.last,0) >= 1 THEN
12498: pa_fp_planning_transaction_pub.add_planning_transactions (
12499: p_context => l_plan_class_code
12500: /* Passing calling module as creation version, since we dont want calculate api to be called */
12501: ,p_calling_module => 'CREATE_VERSION'
12502: ,p_project_id => version_info_rec.project_id

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

12509:
12510: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
12511: IF l_debug_mode = 'Y' THEN
12512: pa_debug.g_err_stage:='Called API PA_PLANNING_TRANSACTION_UTILS.Get_Res_Class_Rlm_Ids api returned error';
12513: pa_debug.write('PA_FP_PLANNING_TRANSACTION_PUB.Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);
12514: END IF;
12515: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
12516: END IF;
12517: END IF;

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

12556: WHEN Others THEN
12557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12558: x_msg_count := 1;
12559: x_msg_data := SQLERRM;
12560: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
12561: ,p_procedure_name => 'CREATE_DEFAULT_TASK_PLAN_TXNS');
12562: IF l_debug_mode = 'Y' THEN
12563: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
12564: pa_debug.write('Create_Default_Task_Plan_Txns: ' || l_module_name,pa_debug.g_err_stage,5);

Line 12776: p_function =>'PA_FP_PLANNING_TRANSACTION_PUB.REFRESH_WP_SETTINGS'

12772:
12773: -- Set curr function
12774: IF l_debug_mode = 'Y' THEN
12775: pa_debug.set_curr_function(
12776: p_function =>'PA_FP_PLANNING_TRANSACTION_PUB.REFRESH_WP_SETTINGS'
12777: ,p_debug_mode => l_debug_mode );
12778: END IF;
12779: -- Check for business rules violations
12780: IF l_debug_mode = 'Y' THEN

Line 13098: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions (

13094: END IF;
13095:
13096: IF nvl(l_res_assignment_id_tbl.count,0) > 0 THEN
13097: -- If there is any data to be deleted call delete_planning_txns api
13098: PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions (
13099: p_context => 'TASK_ASSIGNMENT'
13100: ,p_task_or_res => 'ASSIGNMENT'
13101: ,p_element_version_id_tbl => l_task_version_id_tbl
13102: ,p_task_number_tbl => l_task_number_tbl

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

13441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13442: x_msg_count := 1;
13443: x_msg_data := SQLERRM;
13444:
13445: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PLANNING_TRANSACTION_PUB'
13446: ,p_procedure_name => 'REFRESH_WP_SETTINGS');
13447:
13448: IF l_debug_mode = 'Y' THEN
13449: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

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

13575:
13576: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
13577: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
13578: p_token1 => 'PROCEDURENAME',
13579: p_value1 => 'pa_fp_planning_transaction_pub.Refresh_rbs_for_versions');
13580:
13581: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
13582:
13583: END IF;

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

13794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13795: x_msg_count := 1;
13796: x_msg_data := SQLERRM;
13797:
13798: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_planning_transaction_pub'
13799: ,p_procedure_name => 'Refresh_rbs_for_versions');
13800:
13801: IF l_debug_mode = 'Y' THEN
13802: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 13840: END PA_FP_PLANNING_TRANSACTION_PUB;

13836: RETURN l_dup_exists;
13837:
13838: END DUP_EXISTS;
13839:
13840: END PA_FP_PLANNING_TRANSACTION_PUB;
13841: