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.

[Home] [Help]

APPS.PA_COST dependencies on PA_COST

Line 1: PACKAGE BODY PA_COST as

1: PACKAGE BODY PA_COST as
2: /* $Header: PAXCSRTB.pls 120.3.12000000.3 2007/07/16 14:25:21 byeturi ship $ */
3:
4: l_exp_func_curr_code_null EXCEPTION;
5: l_project_curr_code_null EXCEPTION; /* Added for Org Forecasting */

Line 110: PA_COST_RATE_PUB.get_labor_rate(p_person_id =>P_person_id

106:
107: l_expend_organization_id := P_expend_organization_id;
108: l_exp_org_id := P_expenditure_org_id; /*2879644*/
109:
110: PA_COST_RATE_PUB.get_labor_rate(p_person_id =>P_person_id
111: ,p_txn_date =>P_Item_date
112: ,p_calling_module =>'STAFFED'
113: ,p_org_id =>l_exp_org_id /*2879644*/
114: ,x_job_id =>l_job_id

Line 302: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */

298: x_msg_count := 1;
299: x_msg_data := SUBSTR(SQLERRM,1,30);
300: /* Checking error condition. Added for bug 2218386 */
301: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
302: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */
303: p_procedure_name => 'Get_Raw_Cost');
304: RAISE;
305: END IF;
306: END Get_Raw_Cost;

Line 350: FROM pa_cost_dist_overrides CDO,

346:
347:
348: SELECT OVERRIDE_TO_ORGANIZATION_ID
349: INTO l_x_override_to_org_id
350: FROM pa_cost_dist_overrides CDO,
351: pa_expenditure_types ET
352: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
353: AND CDO.person_id = P_person_id
354: AND CDO.project_id = P_project_id

Line 378: FROM pa_cost_dist_overrides CDO

374: /*Removed pa_expenditure_types from 'from' clause as it is not used Bug # 2634995 */
375:
376: SELECT OVERRIDE_TO_ORGANIZATION_ID
377: INTO l_x_override_to_org_id
378: FROM pa_cost_dist_overrides CDO
379: --,pa_expenditure_types ET
380: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
381: AND CDO.person_id = P_person_id
382: AND CDO.project_id = P_project_id

Line 407: FROM pa_cost_dist_overrides CDO,

403:
404:
405: SELECT OVERRIDE_TO_ORGANIZATION_ID
406: INTO l_x_override_to_org_id
407: FROM pa_cost_dist_overrides CDO,
408: pa_expenditure_types ET
409: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
410: AND CDO.project_id = P_project_id
411: AND CDO.override_from_organization_id = P_incurred_by_organz_id

Line 439: FROM pa_cost_dist_overrides CDO

435: /*Removed pa_expenditure_types from 'from' clause as it is not used Bug # 2634995 */
436:
437: SELECT OVERRIDE_TO_ORGANIZATION_ID
438: INTO l_x_override_to_org_id
439: FROM pa_cost_dist_overrides CDO
440: --,pa_expenditure_types ET
441: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
442: AND CDO.project_id = P_project_id
443: AND CDO.override_from_organization_id = P_incurred_by_organz_id

Line 487: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */

483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: x_msg_count := 1;
485: x_msg_data := SUBSTR(SQLERRM,1,30);
486: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
487: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */
488: p_procedure_name => 'Override_exp_organization');
489: END IF;
490:
491: END Override_exp_organization;

Line 644: pa_cost_plus.get_cost_plus_structure(l_burden_sch_revision_id,

640: l_burden_sch_revision_id := l_x_burden_sch_revision_id;
641:
642: print_msg('Calling get_cost_plus_structure API');
643:
644: pa_cost_plus.get_cost_plus_structure(l_burden_sch_revision_id,
645: l_x_cp_structure ,
646: l_x_status ,
647: l_x_stage
648: );

Line 666: pa_cost_plus.get_cost_base(P_expenditure_type ,

662: l_cp_structure := l_x_cp_structure;
663:
664: print_msg('Calling get_cost_base API');
665:
666: pa_cost_plus.get_cost_base(P_expenditure_type ,
667: l_cp_structure ,
668: l_x_cost_base ,
669: l_x_status ,
670: l_x_stage

Line 700: pa_cost_plus.get_compiled_multiplier(l_expenditure_org_id ,

696: l_cost_base := l_x_cost_base;
697:
698: print_msg('Calling get_compiled_multiplier API');
699:
700: pa_cost_plus.get_compiled_multiplier(l_expenditure_org_id ,
701: l_cost_base ,
702: l_burden_sch_revision_id ,
703: l_x_compiled_multiplier ,
704: l_x_status ,

Line 846: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */

842: x_msg_data := SUBSTR(SQLERRM,1,30);
843: print_msg('Others Exception:l_x_stage['||l_x_stage||']'||SQLERRM||SQLCODE);
844: /* Checking error condition. Added for bug 2218386 */
845: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
846: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */
847: p_procedure_name => 'Get_Burden_cost');
848: RAISE;
849: END IF;
850:

Line 1524: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */

1520: x_msg_count := 1;
1521: x_msg_data := SUBSTR(SQLERRM,1,30);
1522: /* Checking error condition. Added for bug 2218386 */
1523: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
1524: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */
1525: p_procedure_name => 'Get_Converted_Cost_Amounts');
1526: RAISE;
1527: END IF;
1528: END Get_Converted_Cost_Amounts;

Line 1687: pa_cost_plus.get_revision_by_date(l_burden_sch_id,

1683:
1684:
1685: IF (l_burden_sch_id IS NOT NULL) THEN
1686:
1687: pa_cost_plus.get_revision_by_date(l_burden_sch_id,
1688: l_burden_sch_fixed_date,
1689: p_item_date,
1690: l_x_burden_sch_revision_id,
1691: l_x_status,

Line 1788: pa_cost_plus.get_revision_by_date(l_burden_sch_id,

1784: IF (l_burden_sch_id IS NOT NULL) THEN
1785:
1786: -- Get the project override schedule id and fixed date
1787:
1788: pa_cost_plus.get_revision_by_date(l_burden_sch_id,
1789: l_burden_sch_fixed_date,
1790: p_item_date,
1791: l_x_burden_sch_revision_id,
1792: l_x_status,

Line 1860: pa_cost_plus.get_revision_by_date(l_burden_sch_id,

1856:
1857:
1858: IF (l_burden_sch_id IS NOT NULL) THEN
1859:
1860: pa_cost_plus.get_revision_by_date(l_burden_sch_id,
1861: l_burden_sch_fixed_date,
1862: p_item_date,
1863: l_x_burden_sch_revision_id,
1864: l_x_status,

Line 1915: pa_cost_plus.get_revision_by_date(l_burden_sch_id,

1911:
1912:
1913: IF (l_burden_sch_id IS NOT NULL) THEN
1914:
1915: pa_cost_plus.get_revision_by_date(l_burden_sch_id,
1916: l_burden_sch_fixed_date,
1917: p_item_date,
1918: l_x_burden_sch_revision_id,
1919: l_x_status,

Line 1983: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */

1979: x_msg_count := 1;
1980: x_msg_data := SUBSTR(SQLERRM,1,30);
1981: /* Checking error condition. Added for bug 2218386 */
1982: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
1983: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */
1984: p_procedure_name => 'Get_Schedule_Id');
1985: END IF;
1986:
1987: END get_schedule_id;

Line 2064: PA_DEBUG.init_err_stack('PA_COST.Requirement_raw_cost');

2060: BEGIN
2061:
2062: g_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
2063: --Initialize the error stack
2064: PA_DEBUG.init_err_stack('PA_COST.Requirement_raw_cost');
2065:
2066: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
2067: ,x_write_file => 'LOG'
2068: ,x_debug_mode => g_debug_mode

Line 2124: print_msg('Calling PA_COST_RATE_PUB.get_labor_rate API');

2120: /***LCE changes***/
2121:
2122: l_expend_organization_id := P_expend_organization_id;
2123:
2124: print_msg('Calling PA_COST_RATE_PUB.get_labor_rate API');
2125:
2126: PA_COST_RATE_PUB.get_labor_rate(p_person_id =>NULL
2127: ,p_txn_date =>P_Item_date
2128: ,p_calling_module =>'REQUIREMENT'

Line 2126: PA_COST_RATE_PUB.get_labor_rate(p_person_id =>NULL

2122: l_expend_organization_id := P_expend_organization_id;
2123:
2124: print_msg('Calling PA_COST_RATE_PUB.get_labor_rate API');
2125:
2126: PA_COST_RATE_PUB.get_labor_rate(p_person_id =>NULL
2127: ,p_txn_date =>P_Item_date
2128: ,p_calling_module =>'REQUIREMENT'
2129: ,p_org_id =>l_expend_organization_id /*5511578*/
2130: ,x_job_id =>px_proj_cost_job_id

Line 2347: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */

2343: x_msg_count := 1;
2344: x_msg_data := SUBSTR(SQLERRM,1,30);
2345: /* Checking error condition. Added for bug 2218386 */
2346: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
2347: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */
2348: p_procedure_name => 'Requirement_raw_cost');
2349: RAISE;
2350: END IF;
2351: END Requirement_raw_cost;

Line 2354: END PA_COST;

2350: END IF;
2351: END Requirement_raw_cost;
2352:
2353:
2354: END PA_COST;