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_ASSIGNMENT_PROGRESS_PUB dependencies on PA_PROGRESS_UTILS

Line 597: l_prog_pa_period_name := PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date);

593:
594: --moved this up for bug 3675107
595: ---4457403, added begin/end block to handle no_data_found exception
596: begin
597: l_prog_pa_period_name := PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date);
598: l_prog_gl_period_name := PA_PROGRESS_UTILS.Prog_Get_gl_Period_Name(p_as_of_date);
599: exception
600: WHEN OTHERS THEN
601: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

Line 598: l_prog_gl_period_name := PA_PROGRESS_UTILS.Prog_Get_gl_Period_Name(p_as_of_date);

594: --moved this up for bug 3675107
595: ---4457403, added begin/end block to handle no_data_found exception
596: begin
597: l_prog_pa_period_name := PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date);
598: l_prog_gl_period_name := PA_PROGRESS_UTILS.Prog_Get_gl_Period_Name(p_as_of_date);
599: exception
600: WHEN OTHERS THEN
601: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
602: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');

Line 944: IF PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, p_task_id)) = 'CANCELLED'

940: END IF;
941: */
942: -- Bug 16573693 End
943: ---- if status is CANCELLED
944: IF PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, p_task_id)) = 'CANCELLED'
945: THEN
946: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
947: ,p_msg_name => 'PA_TP_ASSG_CANT_NTER_PRG_CNCEL');
948: x_msg_data := 'PA_TP_ASSG_CANT_NTER_PRG_CNCEL';

Line 956: IF PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, p_task_id)) = 'ON HOLD'

952: ---- if status is CANCELLED
953:
954: /* Commented by rtarway for BUG 3762650
955: ---- if status is ON HOLD
956: IF PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, p_task_id)) = 'ON HOLD'
957: THEN
958: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
959: ,p_msg_name => 'PA_TP_ASSG_CANT_NTER_PRG_ONHOLD');
960: x_msg_data := 'PA_TP_ASSG_CANT_NTER_PRG_ONHOLD';

Line 1406: l_last_progress_date := PA_PROGRESS_UTILS.GET_LATEST_AS_OF_DATE(

1402: END IF;
1403: END IF;
1404:
1405:
1406: l_last_progress_date := PA_PROGRESS_UTILS.GET_LATEST_AS_OF_DATE(
1407: p_task_id => p_task_id
1408: ,p_project_id => p_project_id
1409: --,p_object_id => l_assignment_id --bug# 3764224 Changes for RLM
1410: ,p_object_id => l_resource_list_member_id

Line 1421: l_working_aod := PA_PROGRESS_UTILS.Working_version_exist(

1417: IF g1_debug_mode = 'Y' THEN
1418: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_last_progress_date: '||l_last_progress_date, x_Log_Level=> 3);
1419: END IF;
1420:
1421: l_working_aod := PA_PROGRESS_UTILS.Working_version_exist(
1422: --p_task_id => l_assignment_id --bug# 3764224 Changes for RLM
1423: p_task_id => p_task_id
1424: ,p_project_id => p_project_id
1425: ,p_object_type => l_object_type

Line 1436: l_progress_exists_on_aod := PA_PROGRESS_UTILS.check_prog_exists_on_aod(

1432: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_working_aod: '||l_working_aod, x_Log_Level=> 3);
1433: END IF;
1434:
1435:
1436: l_progress_exists_on_aod := PA_PROGRESS_UTILS.check_prog_exists_on_aod(
1437: p_project_id => p_project_id
1438: ,p_object_type => l_object_type
1439: ,p_object_version_id => l_object_version_id
1440: --,p_task_id => l_assignment_id --bug# 3764224 Changes for RLM

Line 1497: --AND PA_PROGRESS_UTILS.CHECK_VALID_AS_OF_DATE( p_as_of_date, p_project_id, l_assignment_id, l_object_type ) = 'N'

1493: --bug 3994165, commmenting as as of date validation is not required
1494: /*IF p_calling_module <> 'AMG' -- Bug 3627315
1495: AND p_calling_module <> 'TASK_PROG_DET_PAGE' -- Bug 3627315
1496: --bug# 3764224 Added for RLM
1497: --AND PA_PROGRESS_UTILS.CHECK_VALID_AS_OF_DATE( p_as_of_date, p_project_id, l_assignment_id, l_object_type ) = 'N'
1498: AND PA_PROGRESS_UTILS.CHECK_VALID_AS_OF_DATE( p_as_of_date, p_project_id, l_resource_list_member_id, l_object_type, p_task_id ) = 'N'
1499: AND nvl(l_last_progress_date,p_as_of_date + 1 ) <> p_as_of_date
1500: THEN
1501: --Add message

Line 1498: AND PA_PROGRESS_UTILS.CHECK_VALID_AS_OF_DATE( p_as_of_date, p_project_id, l_resource_list_member_id, l_object_type, p_task_id ) = 'N'

1494: /*IF p_calling_module <> 'AMG' -- Bug 3627315
1495: AND p_calling_module <> 'TASK_PROG_DET_PAGE' -- Bug 3627315
1496: --bug# 3764224 Added for RLM
1497: --AND PA_PROGRESS_UTILS.CHECK_VALID_AS_OF_DATE( p_as_of_date, p_project_id, l_assignment_id, l_object_type ) = 'N'
1498: AND PA_PROGRESS_UTILS.CHECK_VALID_AS_OF_DATE( p_as_of_date, p_project_id, l_resource_list_member_id, l_object_type, p_task_id ) = 'N'
1499: AND nvl(l_last_progress_date,p_as_of_date + 1 ) <> p_as_of_date
1500: THEN
1501: --Add message
1502: --Invalid as of date

Line 1668: PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier(

1664: BEGIN
1665: IF g1_debug_mode = 'Y' THEN
1666: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'Calling Get_Res_txn_Cost_Rate', x_Log_Level=> 3);
1667: END IF;
1668: PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier(
1669: P_res_list_mem_id => l_resource_list_member_id
1670: ,P_project_id => p_project_id
1671: ,P_task_id => p_task_id --bug 3860575
1672: ,p_as_of_date => p_as_of_date --bug 3901289

Line 1698: p_error_text => SUBSTRB('PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier1:'||SQLERRM,1,240));

1694: EXCEPTION
1695: WHEN OTHERS THEN
1696: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSIGNMENT_PROGRESS_PUB',
1697: p_procedure_name => 'UPDATE_ASSIGNMENT_PROGRESS',
1698: p_error_text => SUBSTRB('PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier1:'||SQLERRM,1,240));
1699: RAISE FND_API.G_EXC_ERROR;
1700:
1701: END;
1702:

Line 1713: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(

1709:
1710: -- Bug 3696429 currency conversion for resource Satish 03-JUL-2004 start
1711: IF l_txn_currency_code <> l_res_cur_code
1712: THEN
1713: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
1714: p_project_id => p_project_id
1715: ,p_task_id => p_task_id
1716: --,p_as_of_date => SYSDATE
1717: ,p_as_of_date => p_as_of_date --bug 3901289

Line 1746: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(

1742: END IF;
1743:
1744: IF l_res_raw_rate <> l_res_burden_rate
1745: THEN
1746: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
1747: p_project_id => p_project_id
1748: ,p_task_id => p_task_id
1749: -- ,p_as_of_date => SYSDATE
1750: ,p_as_of_date => p_as_of_date --bug 3901289

Line 1794: PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier(

1790: -- IF l_etc_effort_this_period IS NOT NULL --maansari6/14 bug 3784733 need to call this api even for non-rate based assgns to get the burden multiplier.
1791: --bug 4334545
1792: if (l_etc_effort_this_period is not null and (l_etc_effort_this_period <> 0 or l_etc_raw_cost_this_period <> 0)) then
1793: BEGIN
1794: PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier(
1795: P_res_list_mem_id => l_resource_list_member_id
1796: ,P_project_id => p_project_id
1797: ,P_task_id => p_task_id --bug 3860575
1798: ,p_as_of_date => p_as_of_date --bug 3901289

Line 1823: p_error_text => SUBSTRB('PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier2:'||SQLERRM,1,240));

1819: EXCEPTION
1820: WHEN OTHERS THEN
1821: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSIGNMENT_PROGRESS_PUB',
1822: p_procedure_name => 'UPDATE_ASSIGNMENT_PROGRESS',
1823: p_error_text => SUBSTRB('PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier2:'||SQLERRM,1,240));
1824: RAISE FND_API.G_EXC_ERROR;
1825:
1826: END;
1827:

Line 1838: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(

1834: -- Bug 3784874 currency conversion for ETC Start
1835: --IF l_txn_currency_code <> l_res_cur_code
1836: IF l_txn_currency_code <> l_plan_res_cur_code -- 06-sep-2004,3860575 Satish
1837: THEN
1838: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
1839: p_project_id => p_project_id
1840: ,p_task_id => p_task_id
1841: -- ,p_as_of_date => SYSDATE
1842: ,p_as_of_date => p_as_of_date --bug 3901289

Line 1871: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(

1867: END IF;
1868:
1869: IF l_plan_res_raw_rate <> l_plan_res_burden_rate
1870: THEN
1871: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
1872: p_project_id => p_project_id
1873: ,p_task_id => p_task_id
1874: -- ,p_as_of_date => SYSDATE
1875: ,p_as_of_date => p_as_of_date --bug 3901289

Line 1943: PA_PROGRESS_UTILS.GET_TXN_COST_FOR_EFFORT(

1939: IF g1_debug_mode = 'Y' THEN
1940: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'calling effort to cost for actual', x_Log_Level=> 3);
1941: END IF;
1942:
1943: PA_PROGRESS_UTILS.GET_TXN_COST_FOR_EFFORT(
1944: p_project_id => p_project_id
1945: ,p_res_list_memb_id_tbl => l_res_list_memb_id_tbl
1946: ,P_res_effort_tbl => l_res_effort_tbl
1947: ,P_res_txn_cost_tbl => l_res_txn_cost_tbl

Line 2003: PA_PROGRESS_UTILS.GET_TXN_COST_FOR_EFFORT(

1999: IF g1_debug_mode = 'Y' THEN
2000: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'calling effort to cost for etc', x_Log_Level=> 3);
2001: END IF;
2002:
2003: PA_PROGRESS_UTILS.GET_TXN_COST_FOR_EFFORT(
2004: p_project_id => p_project_id
2005: ,p_res_list_memb_id_tbl => l_res_list_memb_id_tbl
2006: ,P_res_effort_tbl => l_etc_res_effort_tbl
2007: ,P_res_txn_cost_tbl => l_etc_res_txn_cost_tbl

Line 2096: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(

2092:
2093: IF NVL(l_track_wp_cost_flag, 'Y') = 'Y' THEN -- Bug 3801745
2094:
2095: IF l_act_txn_raw_cost IS NOT NULL AND l_act_txn_raw_cost <> 0 THEN
2096: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
2097: p_project_id => p_project_id
2098: ,p_task_id => p_task_id
2099: -- ,p_as_of_date => SYSDATE
2100: ,p_as_of_date => p_as_of_date --bug 3901289

Line 2123: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(

2119: THEN
2120: RAISE FND_API.G_EXC_ERROR;
2121: END IF;
2122: -- Raw Cost Changes Begin
2123: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
2124: p_project_id => p_project_id
2125: ,p_task_id => p_task_id
2126: -- ,p_as_of_date => SYSDATE
2127: ,p_as_of_date => p_as_of_date --bug 3901289

Line 2170: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(

2166: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_act_projfunc_raw_cost'||l_act_projfunc_raw_cost, x_Log_Level=> 3);
2167: END IF;
2168:
2169: IF l_etc_txn_raw_cost IS NOT NULL AND l_etc_txn_raw_cost <> 0 THEN
2170: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
2171: p_project_id => p_project_id
2172: ,p_task_id => p_task_id
2173: -- ,p_as_of_date => SYSDATE
2174: ,p_as_of_date => p_as_of_date --bug 3901289

Line 2200: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(

2196: THEN
2197: RAISE FND_API.G_EXC_ERROR;
2198: END IF;
2199: -- Raw Cost Changes Begin
2200: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
2201: p_project_id => p_project_id
2202: ,p_task_id => p_task_id
2203: -- ,p_as_of_date => SYSDATE
2204: ,p_as_of_date => p_as_of_date --bug 3901289

Line 2580: PA_PROGRESS_UTILS.get_last_etc_all(

2576: IF (p_action='PUBLISH' AND (l_act_txn_raw_cost IS NOT NULL OR l_actual_effort_this_period IS NOT NULL
2577: OR l_etc_txn_raw_cost IS NOT NULL OR l_etc_effort_this_period IS NOT NULL)) --bug etc was not getting pushed to PJI due to this statement.
2578: THEN
2579: -- Raw Cost Changes : Added Burden parameters
2580: PA_PROGRESS_UTILS.get_last_etc_all(
2581: p_project_id => p_project_id
2582: ,p_object_id => p_object_id
2583: ,p_object_type => l_object_type
2584: ,p_as_of_date => p_as_of_date

Line 2868: --DEBUG_DJ('Calling PA_PROGRESS_UTILS.get_prog_rollup_id 2966');

2864: IF g1_debug_mode = 'Y' THEN
2865: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'INSERTED IN PPC', x_Log_Level=> 3);
2866: END IF;
2867:
2868: --DEBUG_DJ('Calling PA_PROGRESS_UTILS.get_prog_rollup_id 2966');
2869: l_PROGRESS_ROLLUP_ID := PA_PROGRESS_UTILS.get_prog_rollup_id(
2870: p_project_id => p_project_id
2871: --,p_object_id => l_assignment_id --bug# 3764224 Changes for RLM
2872: ,p_object_id => l_resource_list_member_id

Line 2869: l_PROGRESS_ROLLUP_ID := PA_PROGRESS_UTILS.get_prog_rollup_id(

2865: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'INSERTED IN PPC', x_Log_Level=> 3);
2866: END IF;
2867:
2868: --DEBUG_DJ('Calling PA_PROGRESS_UTILS.get_prog_rollup_id 2966');
2869: l_PROGRESS_ROLLUP_ID := PA_PROGRESS_UTILS.get_prog_rollup_id(
2870: p_project_id => p_project_id
2871: --,p_object_id => l_assignment_id --bug# 3764224 Changes for RLM
2872: ,p_object_id => l_resource_list_member_id
2873: ,p_object_type => l_object_type

Line 3195: --DEBUG_DJ('Calling PA_PROGRESS_UTILS.get_ppc_id 3293');

3191: -- There is issue in UI, after calling API under Recalculate, it should incrment the VO record version number
3192:
3193: -- IF p_percent_complete_id IS NULL OR p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3194: -- THEN
3195: --DEBUG_DJ('Calling PA_PROGRESS_UTILS.get_ppc_id 3293');
3196: l_percent_complete_id := PA_PROGRESS_UTILS.get_ppc_id(
3197: p_project_id => p_project_id
3198: --,p_object_id => l_assignment_id --bug# 3764224 Changes for RLM
3199: ,p_object_id => l_resource_list_member_id

Line 3196: l_percent_complete_id := PA_PROGRESS_UTILS.get_ppc_id(

3192:
3193: -- IF p_percent_complete_id IS NULL OR p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3194: -- THEN
3195: --DEBUG_DJ('Calling PA_PROGRESS_UTILS.get_ppc_id 3293');
3196: l_percent_complete_id := PA_PROGRESS_UTILS.get_ppc_id(
3197: p_project_id => p_project_id
3198: --,p_object_id => l_assignment_id --bug# 3764224 Changes for RLM
3199: ,p_object_id => l_resource_list_member_id
3200: ,p_object_type => l_object_type

Line 3208: --DEBUG_DJ('Out of PA_PROGRESS_UTILS.get_ppc_id 3293 || ' || l_percent_complete_id);

3204: ,p_task_id => p_task_id --bug# 3764224 Added for RLM
3205: ,p_cbs_element_id => l_cbs_element_id --Added for 16200605
3206:
3207: );
3208: --DEBUG_DJ('Out of PA_PROGRESS_UTILS.get_ppc_id 3293 || ' || l_percent_complete_id);
3209: -- FPM Dev CR 3 Getting Record Version Number too
3210: BEGIN
3211: SELECT record_version_number into l_record_version_number
3212: FROM pa_percent_completes

Line 3281: l_PROGRESS_ROLLUP_ID := PA_PROGRESS_UTILS.get_prog_rollup_id(

3277:
3278:
3279:
3280: --update progress rollup
3281: l_PROGRESS_ROLLUP_ID := PA_PROGRESS_UTILS.get_prog_rollup_id(
3282: p_project_id => p_project_id
3283: --,p_object_id => l_assignment_id --bug# 3764224 Changes for RLM
3284: ,p_object_id => l_resource_list_member_id
3285: ,p_object_type => l_object_type