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 551: l_prog_pa_period_name := PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date);

547:
548: --moved this up for bug 3675107
549: ---4457403, added begin/end block to handle no_data_found exception
550: begin
551: l_prog_pa_period_name := PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date);
552: l_prog_gl_period_name := PA_PROGRESS_UTILS.Prog_Get_gl_Period_Name(p_as_of_date);
553: exception
554: WHEN OTHERS THEN
555: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',

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

548: --moved this up for bug 3675107
549: ---4457403, added begin/end block to handle no_data_found exception
550: begin
551: l_prog_pa_period_name := PA_PROGRESS_UTILS.Prog_Get_Pa_Period_Name(p_as_of_date);
552: l_prog_gl_period_name := PA_PROGRESS_UTILS.Prog_Get_gl_Period_Name(p_as_of_date);
553: exception
554: WHEN OTHERS THEN
555: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
556: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');

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

867: */
868:
869:
870: ---- if status is CANCELLED
871: IF PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, p_task_id)) = 'CANCELLED'
872: THEN
873: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
874: ,p_msg_name => 'PA_TP_ASSG_CANT_NTER_PRG_CNCEL');
875: x_msg_data := 'PA_TP_ASSG_CANT_NTER_PRG_CNCEL';

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

879: ---- if status is CANCELLED
880:
881: /* Commented by rtarway for BUG 3762650
882: ---- if status is ON HOLD
883: IF PA_PROGRESS_UTILS.get_system_task_status(PA_PROGRESS_UTILS.get_task_status( p_project_id, p_task_id)) = 'ON HOLD'
884: THEN
885: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
886: ,p_msg_name => 'PA_TP_ASSG_CANT_NTER_PRG_ONHOLD');
887: x_msg_data := 'PA_TP_ASSG_CANT_NTER_PRG_ONHOLD';

Line 1299: l_last_progress_date := PA_PROGRESS_UTILS.GET_LATEST_AS_OF_DATE(

1295: END IF;
1296: END IF;
1297:
1298:
1299: l_last_progress_date := PA_PROGRESS_UTILS.GET_LATEST_AS_OF_DATE(
1300: p_task_id => p_task_id
1301: ,p_project_id => p_project_id
1302: --,p_object_id => l_assignment_id --bug# 3764224 Changes for RLM
1303: ,p_object_id => l_resource_list_member_id

Line 1313: l_working_aod := PA_PROGRESS_UTILS.Working_version_exist(

1309: IF g1_debug_mode = 'Y' THEN
1310: 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);
1311: END IF;
1312:
1313: l_working_aod := PA_PROGRESS_UTILS.Working_version_exist(
1314: --p_task_id => l_assignment_id --bug# 3764224 Changes for RLM
1315: p_task_id => p_task_id
1316: ,p_project_id => p_project_id
1317: ,p_object_type => l_object_type

Line 1327: l_progress_exists_on_aod := PA_PROGRESS_UTILS.check_prog_exists_on_aod(

1323: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'l_working_aod: '||l_working_aod, x_Log_Level=> 3);
1324: END IF;
1325:
1326:
1327: l_progress_exists_on_aod := PA_PROGRESS_UTILS.check_prog_exists_on_aod(
1328: p_project_id => p_project_id
1329: ,p_object_type => l_object_type
1330: ,p_object_version_id => l_object_version_id
1331: --,p_task_id => l_assignment_id --bug# 3764224 Changes for RLM

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

1383: --bug 3994165, commmenting as as of date validation is not required
1384: /*IF p_calling_module <> 'AMG' -- Bug 3627315
1385: AND p_calling_module <> 'TASK_PROG_DET_PAGE' -- Bug 3627315
1386: --bug# 3764224 Added for RLM
1387: --AND PA_PROGRESS_UTILS.CHECK_VALID_AS_OF_DATE( p_as_of_date, p_project_id, l_assignment_id, l_object_type ) = 'N'
1388: 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'
1389: AND nvl(l_last_progress_date,p_as_of_date + 1 ) <> p_as_of_date
1390: THEN
1391: --Add message

Line 1388: 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'

1384: /*IF p_calling_module <> 'AMG' -- Bug 3627315
1385: AND p_calling_module <> 'TASK_PROG_DET_PAGE' -- Bug 3627315
1386: --bug# 3764224 Added for RLM
1387: --AND PA_PROGRESS_UTILS.CHECK_VALID_AS_OF_DATE( p_as_of_date, p_project_id, l_assignment_id, l_object_type ) = 'N'
1388: 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'
1389: AND nvl(l_last_progress_date,p_as_of_date + 1 ) <> p_as_of_date
1390: THEN
1391: --Add message
1392: --Invalid as of date

Line 1554: PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier(

1550: BEGIN
1551: IF g1_debug_mode = 'Y' THEN
1552: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'Calling Get_Res_txn_Cost_Rate', x_Log_Level=> 3);
1553: END IF;
1554: PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier(
1555: P_res_list_mem_id => l_resource_list_member_id
1556: ,P_project_id => p_project_id
1557: ,P_task_id => p_task_id --bug 3860575
1558: ,p_as_of_date => p_as_of_date --bug 3901289

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

1580: EXCEPTION
1581: WHEN OTHERS THEN
1582: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSIGNMENT_PROGRESS_PUB',
1583: p_procedure_name => 'UPDATE_ASSIGNMENT_PROGRESS',
1584: p_error_text => SUBSTRB('PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier1:'||SQLERRM,1,240));
1585: RAISE FND_API.G_EXC_ERROR;
1586:
1587: END;
1588:

Line 1599: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(

1595:
1596: -- Bug 3696429 currency conversion for resource Satish 03-JUL-2004 start
1597: IF l_txn_currency_code <> l_res_cur_code
1598: THEN
1599: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
1600: p_project_id => p_project_id
1601: ,p_task_id => p_task_id
1602: --,p_as_of_date => SYSDATE
1603: ,p_as_of_date => p_as_of_date --bug 3901289

Line 1632: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(

1628: END IF;
1629:
1630: IF l_res_raw_rate <> l_res_burden_rate
1631: THEN
1632: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
1633: p_project_id => p_project_id
1634: ,p_task_id => p_task_id
1635: -- ,p_as_of_date => SYSDATE
1636: ,p_as_of_date => p_as_of_date --bug 3901289

Line 1680: PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier(

1676: -- 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.
1677: --bug 4334545
1678: 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
1679: BEGIN
1680: PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier(
1681: P_res_list_mem_id => l_resource_list_member_id
1682: ,P_project_id => p_project_id
1683: ,P_task_id => p_task_id --bug 3860575
1684: ,p_as_of_date => p_as_of_date --bug 3901289

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

1705: EXCEPTION
1706: WHEN OTHERS THEN
1707: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_ASSIGNMENT_PROGRESS_PUB',
1708: p_procedure_name => 'UPDATE_ASSIGNMENT_PROGRESS',
1709: p_error_text => SUBSTRB('PA_PROGRESS_UTILS.Get_Res_Rate_Burden_Multiplier2:'||SQLERRM,1,240));
1710: RAISE FND_API.G_EXC_ERROR;
1711:
1712: END;
1713:

Line 1724: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(

1720: -- Bug 3784874 currency conversion for ETC Start
1721: --IF l_txn_currency_code <> l_res_cur_code
1722: IF l_txn_currency_code <> l_plan_res_cur_code -- 06-sep-2004,3860575 Satish
1723: THEN
1724: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
1725: p_project_id => p_project_id
1726: ,p_task_id => p_task_id
1727: -- ,p_as_of_date => SYSDATE
1728: ,p_as_of_date => p_as_of_date --bug 3901289

Line 1757: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(

1753: END IF;
1754:
1755: IF l_plan_res_raw_rate <> l_plan_res_burden_rate
1756: THEN
1757: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
1758: p_project_id => p_project_id
1759: ,p_task_id => p_task_id
1760: -- ,p_as_of_date => SYSDATE
1761: ,p_as_of_date => p_as_of_date --bug 3901289

Line 1829: PA_PROGRESS_UTILS.GET_TXN_COST_FOR_EFFORT(

1825: IF g1_debug_mode = 'Y' THEN
1826: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'calling effort to cost for actual', x_Log_Level=> 3);
1827: END IF;
1828:
1829: PA_PROGRESS_UTILS.GET_TXN_COST_FOR_EFFORT(
1830: p_project_id => p_project_id
1831: ,p_res_list_memb_id_tbl => l_res_list_memb_id_tbl
1832: ,P_res_effort_tbl => l_res_effort_tbl
1833: ,P_res_txn_cost_tbl => l_res_txn_cost_tbl

Line 1889: PA_PROGRESS_UTILS.GET_TXN_COST_FOR_EFFORT(

1885: IF g1_debug_mode = 'Y' THEN
1886: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'calling effort to cost for etc', x_Log_Level=> 3);
1887: END IF;
1888:
1889: PA_PROGRESS_UTILS.GET_TXN_COST_FOR_EFFORT(
1890: p_project_id => p_project_id
1891: ,p_res_list_memb_id_tbl => l_res_list_memb_id_tbl
1892: ,P_res_effort_tbl => l_etc_res_effort_tbl
1893: ,P_res_txn_cost_tbl => l_etc_res_txn_cost_tbl

Line 1982: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(

1978:
1979: IF NVL(l_track_wp_cost_flag, 'Y') = 'Y' THEN -- Bug 3801745
1980:
1981: IF l_act_txn_raw_cost IS NOT NULL AND l_act_txn_raw_cost <> 0 THEN
1982: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
1983: p_project_id => p_project_id
1984: ,p_task_id => p_task_id
1985: -- ,p_as_of_date => SYSDATE
1986: ,p_as_of_date => p_as_of_date --bug 3901289

Line 2009: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(

2005: THEN
2006: RAISE FND_API.G_EXC_ERROR;
2007: END IF;
2008: -- Raw Cost Changes Begin
2009: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
2010: p_project_id => p_project_id
2011: ,p_task_id => p_task_id
2012: -- ,p_as_of_date => SYSDATE
2013: ,p_as_of_date => p_as_of_date --bug 3901289

Line 2056: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(

2052: 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);
2053: END IF;
2054:
2055: IF l_etc_txn_raw_cost IS NOT NULL AND l_etc_txn_raw_cost <> 0 THEN
2056: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
2057: p_project_id => p_project_id
2058: ,p_task_id => p_task_id
2059: -- ,p_as_of_date => SYSDATE
2060: ,p_as_of_date => p_as_of_date --bug 3901289

Line 2086: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(

2082: THEN
2083: RAISE FND_API.G_EXC_ERROR;
2084: END IF;
2085: -- Raw Cost Changes Begin
2086: PA_PROGRESS_UTILS.CONVERT_CURRENCY_AMOUNTS(
2087: p_project_id => p_project_id
2088: ,p_task_id => p_task_id
2089: -- ,p_as_of_date => SYSDATE
2090: ,p_as_of_date => p_as_of_date --bug 3901289

Line 2466: PA_PROGRESS_UTILS.get_last_etc_all(

2462: IF (p_action='PUBLISH' AND (l_act_txn_raw_cost IS NOT NULL OR l_actual_effort_this_period IS NOT NULL
2463: 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.
2464: THEN
2465: -- Raw Cost Changes : Added Burden parameters
2466: PA_PROGRESS_UTILS.get_last_etc_all(
2467: p_project_id => p_project_id
2468: ,p_object_id => p_object_id
2469: ,p_object_type => l_object_type
2470: ,p_as_of_date => p_as_of_date

Line 2746: l_PROGRESS_ROLLUP_ID := PA_PROGRESS_UTILS.get_prog_rollup_id(

2742: pa_debug.write(x_Module=>'PA_ASSIGNMENT_PROGRESS_PUB.UPDATE_ASSIGNMENT_PROGRESS', x_Msg => 'INSERTED IN PPC', x_Log_Level=> 3);
2743: END IF;
2744:
2745:
2746: l_PROGRESS_ROLLUP_ID := PA_PROGRESS_UTILS.get_prog_rollup_id(
2747: p_project_id => p_project_id
2748: --,p_object_id => l_assignment_id --bug# 3764224 Changes for RLM
2749: ,p_object_id => l_resource_list_member_id
2750: ,p_object_type => l_object_type

Line 3069: l_percent_complete_id := PA_PROGRESS_UTILS.get_ppc_id(

3065: -- There is issue in UI, after calling API under Recalculate, it should incrment the VO record version number
3066:
3067: -- IF p_percent_complete_id IS NULL OR p_percent_complete_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3068: -- THEN
3069: l_percent_complete_id := PA_PROGRESS_UTILS.get_ppc_id(
3070: p_project_id => p_project_id
3071: --,p_object_id => l_assignment_id --bug# 3764224 Changes for RLM
3072: ,p_object_id => l_resource_list_member_id
3073: ,p_object_type => l_object_type

Line 3149: l_PROGRESS_ROLLUP_ID := PA_PROGRESS_UTILS.get_prog_rollup_id(

3145:
3146:
3147:
3148: --update progress rollup
3149: l_PROGRESS_ROLLUP_ID := PA_PROGRESS_UTILS.get_prog_rollup_id(
3150: p_project_id => p_project_id
3151: --,p_object_id => l_assignment_id --bug# 3764224 Changes for RLM
3152: ,p_object_id => l_resource_list_member_id
3153: ,p_object_type => l_object_type