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_COST dependencies on PA_COST

Line 1: PACKAGE BODY PA_COST as

1: PACKAGE BODY PA_COST as
2: /* $Header: PAXCSRTB.pls 120.5.12010000.2 2009/02/16 10:42:52 amehrotr ship $ */
3:
4: l_exp_func_curr_code_null EXCEPTION;
5: l_project_curr_code_null EXCEPTION; /* Added for Org Forecasting */

Line 113: PA_COST_RATE_PUB.get_labor_rate(p_person_id =>P_person_id

109:
110: pa_cc_utils.log_message('p_person_id = '||p_person_id||' P_Item_date = '||to_char(trunc(P_Item_date),'DD-MON-YY'));
111: pa_cc_utils.log_message('l_expend_organization_id = '||l_expend_organization_id||' l_exp_org_id = '||l_exp_org_id);
112:
113: PA_COST_RATE_PUB.get_labor_rate(p_person_id =>P_person_id
114: ,p_txn_date =>P_Item_date
115: ,p_calling_module =>'STAFFED'
116: ,p_org_id =>l_exp_org_id /*2879644*/
117: ,x_job_id =>l_job_id

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

323: x_msg_count := 1;
324: x_msg_data := SUBSTR(SQLERRM,1,30);
325: /* Checking error condition. Added for bug 2218386 */
326: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
327: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */
328: p_procedure_name => 'Get_Raw_Cost');
329: RAISE;
330: END IF;
331: END Get_Raw_Cost;

Line 375: FROM pa_cost_dist_overrides CDO,

371:
372:
373: SELECT OVERRIDE_TO_ORGANIZATION_ID
374: INTO l_x_override_to_org_id
375: FROM pa_cost_dist_overrides CDO,
376: pa_expenditure_types ET
377: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
378: AND CDO.person_id = P_person_id
379: AND CDO.project_id = P_project_id

Line 403: FROM pa_cost_dist_overrides CDO

399: /*Removed pa_expenditure_types from 'from' clause as it is not used Bug # 2634995 */
400:
401: SELECT OVERRIDE_TO_ORGANIZATION_ID
402: INTO l_x_override_to_org_id
403: FROM pa_cost_dist_overrides CDO
404: --,pa_expenditure_types ET
405: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
406: AND CDO.person_id = P_person_id
407: AND CDO.project_id = P_project_id

Line 432: FROM pa_cost_dist_overrides CDO,

428:
429:
430: SELECT OVERRIDE_TO_ORGANIZATION_ID
431: INTO l_x_override_to_org_id
432: FROM pa_cost_dist_overrides CDO,
433: pa_expenditure_types ET
434: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
435: AND CDO.project_id = P_project_id
436: AND CDO.override_from_organization_id = P_incurred_by_organz_id

Line 464: FROM pa_cost_dist_overrides CDO

460: /*Removed pa_expenditure_types from 'from' clause as it is not used Bug # 2634995 */
461:
462: SELECT OVERRIDE_TO_ORGANIZATION_ID
463: INTO l_x_override_to_org_id
464: FROM pa_cost_dist_overrides CDO
465: --,pa_expenditure_types ET
466: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
467: AND CDO.project_id = P_project_id
468: AND CDO.override_from_organization_id = P_incurred_by_organz_id

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

508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: x_msg_count := 1;
510: x_msg_data := SUBSTR(SQLERRM,1,30);
511: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
512: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */
513: p_procedure_name => 'Override_exp_organization');
514: END IF;
515:
516: END Override_exp_organization;

Line 677: pa_cost_plus.get_cost_plus_structure(l_burden_sch_revision_id,

673: l_burden_sch_revision_id := l_x_burden_sch_revision_id;
674:
675: print_msg('Calling get_cost_plus_structure API');
676:
677: pa_cost_plus.get_cost_plus_structure(l_burden_sch_revision_id,
678: l_x_cp_structure ,
679: l_x_status ,
680: l_x_stage
681: );

Line 699: pa_cost_plus.get_cost_base(P_expenditure_type ,

695: l_cp_structure := l_x_cp_structure;
696:
697: print_msg('Calling get_cost_base API');
698:
699: pa_cost_plus.get_cost_base(P_expenditure_type ,
700: l_cp_structure ,
701: l_x_cost_base ,
702: l_x_status ,
703: l_x_stage

Line 733: pa_cost_plus.get_compiled_multiplier(l_expenditure_org_id ,

729: l_cost_base := l_x_cost_base;
730:
731: print_msg('Calling get_compiled_multiplier API');
732:
733: pa_cost_plus.get_compiled_multiplier(l_expenditure_org_id ,
734: l_cost_base ,
735: l_burden_sch_revision_id ,
736: l_x_compiled_multiplier ,
737: l_x_status ,

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

875: x_msg_data := SUBSTR(SQLERRM,1,30);
876: print_msg('Others Exception:l_x_stage['||l_x_stage||']'||SQLERRM||SQLCODE);
877: /* Checking error condition. Added for bug 2218386 */
878: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
879: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */
880: p_procedure_name => 'Get_Burden_cost');
881: RAISE;
882: END IF;
883:

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

1553: x_msg_count := 1;
1554: x_msg_data := SUBSTR(SQLERRM,1,30);
1555: /* Checking error condition. Added for bug 2218386 */
1556: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
1557: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */
1558: p_procedure_name => 'Get_Converted_Cost_Amounts');
1559: RAISE;
1560: END IF;
1561: END Get_Converted_Cost_Amounts;

Line 1720: pa_cost_plus.get_revision_by_date(l_burden_sch_id,

1716:
1717:
1718: IF (l_burden_sch_id IS NOT NULL) THEN
1719:
1720: pa_cost_plus.get_revision_by_date(l_burden_sch_id,
1721: l_burden_sch_fixed_date,
1722: p_item_date,
1723: l_x_burden_sch_revision_id,
1724: l_x_status,

Line 1821: pa_cost_plus.get_revision_by_date(l_burden_sch_id,

1817: IF (l_burden_sch_id IS NOT NULL) THEN
1818:
1819: -- Get the project override schedule id and fixed date
1820:
1821: pa_cost_plus.get_revision_by_date(l_burden_sch_id,
1822: l_burden_sch_fixed_date,
1823: p_item_date,
1824: l_x_burden_sch_revision_id,
1825: l_x_status,

Line 1893: pa_cost_plus.get_revision_by_date(l_burden_sch_id,

1889:
1890:
1891: IF (l_burden_sch_id IS NOT NULL) THEN
1892:
1893: pa_cost_plus.get_revision_by_date(l_burden_sch_id,
1894: l_burden_sch_fixed_date,
1895: p_item_date,
1896: l_x_burden_sch_revision_id,
1897: l_x_status,

Line 1948: pa_cost_plus.get_revision_by_date(l_burden_sch_id,

1944:
1945:
1946: IF (l_burden_sch_id IS NOT NULL) THEN
1947:
1948: pa_cost_plus.get_revision_by_date(l_burden_sch_id,
1949: l_burden_sch_fixed_date,
1950: p_item_date,
1951: l_x_burden_sch_revision_id,
1952: l_x_status,

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

2012: x_msg_count := 1;
2013: x_msg_data := SUBSTR(SQLERRM,1,30);
2014: /* Checking error condition. Added for bug 2218386 */
2015: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
2016: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */
2017: p_procedure_name => 'Get_Schedule_Id');
2018: END IF;
2019:
2020: END get_schedule_id;

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

2093: BEGIN
2094:
2095: g_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
2096: --Initialize the error stack
2097: PA_DEBUG.init_err_stack('PA_COST.Requirement_raw_cost');
2098:
2099: PA_DEBUG.SET_PROCESS( x_process => 'PLSQL'
2100: ,x_write_file => 'LOG'
2101: ,x_debug_mode => g_debug_mode

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

2153: /***LCE changes***/
2154:
2155: l_expend_organization_id := P_expend_organization_id;
2156:
2157: print_msg('Calling PA_COST_RATE_PUB.get_labor_rate API');
2158:
2159: PA_COST_RATE_PUB.get_labor_rate(p_person_id =>NULL
2160: ,p_txn_date =>P_Item_date
2161: ,p_calling_module =>'REQUIREMENT'

Line 2159: PA_COST_RATE_PUB.get_labor_rate(p_person_id =>NULL

2155: l_expend_organization_id := P_expend_organization_id;
2156:
2157: print_msg('Calling PA_COST_RATE_PUB.get_labor_rate API');
2158:
2159: PA_COST_RATE_PUB.get_labor_rate(p_person_id =>NULL
2160: ,p_txn_date =>P_Item_date
2161: ,p_calling_module =>'REQUIREMENT'
2162: ,p_org_id =>l_expend_organization_id /*5511578*/
2163: ,x_job_id =>px_proj_cost_job_id

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

2376: x_msg_count := 1;
2377: x_msg_data := SUBSTR(SQLERRM,1,30);
2378: /* Checking error condition. Added for bug 2218386 */
2379: IF (NVL(PA_RATE_PVT_PKG.G_add_error_to_stack_flag,'Y') = 'Y') THEN
2380: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_COST', /* Moved this here to fix bug 2434663 */
2381: p_procedure_name => 'Requirement_raw_cost');
2382: RAISE;
2383: END IF;
2384: END Requirement_raw_cost;

Line 2387: END PA_COST;

2383: END IF;
2384: END Requirement_raw_cost;
2385:
2386:
2387: END PA_COST;