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_R_PROJECT_RESOURCES_PVT dependencies on PA_RESOURCE_UTILS

Line 1844: pa_resource_utils.check_res_exists(

1840: from pa_resource_types
1841: where resource_type_code = p_resource_type;
1842:
1843: --Call check_res_exists procedure
1844: pa_resource_utils.check_res_exists(
1845: P_PARTY_ID => l_party_id,
1846: X_VALID => l_valid,
1847: X_RETURN_STATUS => l_return_status);
1848:

Line 2228: eRec.NAME := pa_resource_utils.get_person_name_no_date(P_PERSON_ID => eRec.person_id);

2224: IF P_DEBUG_MODE = 'Y' THEN
2225: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2226: END IF;
2227:
2228: eRec.NAME := pa_resource_utils.get_person_name_no_date(P_PERSON_ID => eRec.person_id);
2229: pa_debug.g_err_stage := 'NEW PERSON_NAME ==> ' || eRec.NAME;
2230: IF P_DEBUG_MODE = 'Y' THEN
2231: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
2232: END IF;

Line 2270: pa_resource_utils.check_res_exists(

2266: END IF;
2267: close cur_crmid;
2268:
2269: --Call check_res_exists procedure
2270: pa_resource_utils.check_res_exists(
2271: P_PERSON_ID => l_person_id,
2272: X_VALID => l_valid,
2273: X_RETURN_STATUS => l_return_status);
2274:

Line 2336: pa_resource_utils.get_person_name(

2332: ELSIF (p_scheduled_member_flag = 'Y') THEN
2333:
2334: --Call get_person_name procedure
2335: --to get supervisor name
2336: pa_resource_utils.get_person_name(
2337: P_PERSON_ID => eRec.supervisor_id,
2338: X_PERSON_NAME => l_supervisor_name,
2339: X_RETURN_STATUS => l_return_status);
2340:

Line 2345: pa_resource_utils.Check_Exp_Org (

2341: -- the organization of a scheduled member needs to belong to exp. hierarchy
2342: -- this condition calls the function and checks if this is true
2343:
2344: log_message('**** p_scheduled_member_flag = Y *****');
2345: pa_resource_utils.Check_Exp_Org (
2346: P_ORGANIZATION_ID => l_organization_id,
2347: X_VALID => l_valid,
2348: X_RETURN_STATUS => l_return_status);
2349:

Line 2404: pa_resource_utils.get_org_defaults (

2400: IF (l_exp_org = 'YES' AND l_job_utilization='Y') THEN
2401: log_message('** Resource belongs to an expenditure org **');
2402: --Call get_org_defaults procedure to get default
2403: --operating unit and default calendar for the organization
2404: pa_resource_utils.get_org_defaults (
2405: P_ORGANIZATION_ID => l_organization_id,
2406: X_DEFAULT_OU => l_default_ou,
2407: X_DEFAULT_CAL_ID => l_calendar_id,
2408: X_RETURN_STATUS => l_return_status);

Line 2411: pa_resource_utils.get_location_details (

2407: X_DEFAULT_CAL_ID => l_calendar_id,
2408: X_RETURN_STATUS => l_return_status);
2409:
2410: --Call get_location_details procedure
2411: pa_resource_utils.get_location_details (
2412: P_LOCATION_ID => eRec.location_id,
2413: X_ADDRESS_LINE_1 => l_address1,
2414: x_address_line_2 => l_address2,
2415: x_address_line_3 => l_address3,

Line 2434: pa_resource_utils.check_res_exists(

2430: SAVEPOINT timeline_save;
2431: END IF;
2432:
2433: --Call check_res_exists procedure
2434: pa_resource_utils.check_res_exists(
2435: P_PERSON_ID => l_person_id,
2436: X_VALID => l_valid,
2437: X_RETURN_STATUS => l_return_status);
2438:

Line 2670: log_message('before Calling pa_resource_utils.init_fte_sync_wf');

2666: IF (p_check_resource='N' OR (p_check_resource='Y' AND l_res_exists='NOT EXISTS')) THEN
2667:
2668:
2669: /*Call added for bug 5683340*/
2670: log_message('before Calling pa_resource_utils.init_fte_sync_wf');
2671: pa_resource_utils.init_fte_sync_wf( p_person_id => l_person_id,
2672: x_invol_term => l_invol_term,
2673: x_return_status => x_return_status,
2674: x_msg_data => x_msg_data,

Line 2671: pa_resource_utils.init_fte_sync_wf( p_person_id => l_person_id,

2667:
2668:
2669: /*Call added for bug 5683340*/
2670: log_message('before Calling pa_resource_utils.init_fte_sync_wf');
2671: pa_resource_utils.init_fte_sync_wf( p_person_id => l_person_id,
2672: x_invol_term => l_invol_term,
2673: x_return_status => x_return_status,
2674: x_msg_data => x_msg_data,
2675: x_msg_count => x_msg_count);

Line 2676: log_message('After Calling pa_resource_utils.init_fte_sync_wf, x_return_status: '||x_return_status); --bug 5683340

2672: x_invol_term => l_invol_term,
2673: x_return_status => x_return_status,
2674: x_msg_data => x_msg_data,
2675: x_msg_count => x_msg_count);
2676: log_message('After Calling pa_resource_utils.init_fte_sync_wf, x_return_status: '||x_return_status); --bug 5683340
2677:
2678: /*IF - ELSIF block added for bug 5683340*/
2679: IF ((l_invol_term = 'N') AND (x_return_status = FND_API.G_RET_STS_SUCCESS )) THEN
2680:

Line 2714: log_message(' Call to pa_resource_utils.init_fte_sync_wf errored in individual pull');

2710: RAISE FND_API.G_EXC_ERROR;
2711: END IF;
2712:
2713: ELSIF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN -- for bug 5683340
2714: log_message(' Call to pa_resource_utils.init_fte_sync_wf errored in individual pull');
2715: RAISE FND_API.G_EXC_ERROR;
2716:
2717: END IF ; --IF ((l_invol_term = 'N') AND (x_return_status = FND_API.G_RET_STS_SUCCESS )) bug 5683340
2718:

Line 3052: eRec.NAME := pa_resource_utils.get_person_name_no_date(P_PERSON_ID => eRec.person_id);

3048: IF P_DEBUG_MODE = 'Y' THEN
3049: pa_debug.write_file('start_crm_workflow: ' ||'LOG',pa_debug.g_err_stage);
3050: END IF;
3051:
3052: eRec.NAME := pa_resource_utils.get_person_name_no_date(P_PERSON_ID => eRec.person_id);
3053:
3054: pa_debug.g_err_stage := 'NEW PERSON_NAME ==> ' || eRec.NAME;
3055: IF P_DEBUG_MODE = 'Y' THEN
3056: pa_debug.write_file('start_crm_workflow: ' ||'LOG',pa_debug.g_err_stage);

Line 3080: if(pa_resource_utils.acquire_user_lock(l_person_id, 'Resource Pull') <> 0) then

3076: -- with the next record (this is done by raising
3077: -- expected error which stores the error msg in
3078: -- the pa_reporting_exceptions table)
3079: -------------------------------------------------
3080: if(pa_resource_utils.acquire_user_lock(l_person_id, 'Resource Pull') <> 0) then
3081: pa_debug.g_err_stage := 'Log: Unable to acquire LOCK for person_id = ' || l_person_id;
3082: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3083: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3084: END IF;

Line 3172: pa_resource_utils.get_person_name(

3168:
3169:
3170: --Call get_person_name procedure
3171: --to get supervisor name
3172: pa_resource_utils.get_person_name(
3173: P_PERSON_ID => eRec.supervisor_id,
3174: X_PERSON_NAME => l_supervisor_name,
3175: X_RETURN_STATUS => l_return_status);
3176:

Line 3179: pa_resource_utils.get_location_details (

3175: X_RETURN_STATUS => l_return_status);
3176:
3177:
3178: --Call get_location_details procedure
3179: pa_resource_utils.get_location_details (
3180: P_LOCATION_ID => eRec.location_id,
3181: X_ADDRESS_LINE_1 => l_address1,
3182: x_address_line_2 => l_address2,
3183: x_address_line_3 => l_address3,

Line 3196: PA_RESOURCE_UTILS.CHECK_RES_EXISTS(

3192: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3193: END IF;
3194:
3195: --Call check_res_exists procedure Added for bug 5046096
3196: PA_RESOURCE_UTILS.CHECK_RES_EXISTS(
3197: p_person_id => l_person_id,
3198: x_valid => l_valid,
3199: x_return_status => l_return_status);
3200:

Line 3452: pa_debug.g_err_stage := 'Log: Calling pa_resource_utils.init_fte_sync_wf for PersonId =' || to_char(l_person_id) ;

3448: END LOOP ;
3449: /*Code ends for Bug 6943551*/
3450:
3451: /*Call added for bug 5683340*/
3452: pa_debug.g_err_stage := 'Log: Calling pa_resource_utils.init_fte_sync_wf for PersonId =' || to_char(l_person_id) ;
3453: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3454: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3455: END IF;
3456:

Line 3457: log_message('Before Calling pa_resource_utils.init_fte_sync_wf');

3453: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3454: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3455: END IF;
3456:
3457: log_message('Before Calling pa_resource_utils.init_fte_sync_wf');
3458: pa_resource_utils.init_fte_sync_wf( p_person_id => l_person_id,
3459: x_invol_term => l_invol_term,
3460: -- x_return_status => x_return_status, -- Commenting For bug 4087022
3461: x_return_status => l_return_status,

Line 3458: pa_resource_utils.init_fte_sync_wf( p_person_id => l_person_id,

3454: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3455: END IF;
3456:
3457: log_message('Before Calling pa_resource_utils.init_fte_sync_wf');
3458: pa_resource_utils.init_fte_sync_wf( p_person_id => l_person_id,
3459: x_invol_term => l_invol_term,
3460: -- x_return_status => x_return_status, -- Commenting For bug 4087022
3461: x_return_status => l_return_status,
3462: x_msg_data => x_msg_data,

Line 3464: -- log_message('After Calling pa_resource_utils.init_fte_sync_wf, x_return_status: '||x_return_status); -- bug 5683340 ---- Commenting For bug 4087022

3460: -- x_return_status => x_return_status, -- Commenting For bug 4087022
3461: x_return_status => l_return_status,
3462: x_msg_data => x_msg_data,
3463: x_msg_count => x_msg_count);
3464: -- log_message('After Calling pa_resource_utils.init_fte_sync_wf, x_return_status: '||x_return_status); -- bug 5683340 ---- Commenting For bug 4087022
3465: log_message('After Calling pa_resource_utils.init_fte_sync_wf, l_return_status: '||l_return_status); -- bug 5683340
3466:
3467:
3468: pa_debug.g_err_stage := 'Log: After Calling pa_resource_utils.init_fte_sync_wf for PersonId =' || to_char(l_person_id) ;

Line 3465: log_message('After Calling pa_resource_utils.init_fte_sync_wf, l_return_status: '||l_return_status); -- bug 5683340

3461: x_return_status => l_return_status,
3462: x_msg_data => x_msg_data,
3463: x_msg_count => x_msg_count);
3464: -- log_message('After Calling pa_resource_utils.init_fte_sync_wf, x_return_status: '||x_return_status); -- bug 5683340 ---- Commenting For bug 4087022
3465: log_message('After Calling pa_resource_utils.init_fte_sync_wf, l_return_status: '||l_return_status); -- bug 5683340
3466:
3467:
3468: pa_debug.g_err_stage := 'Log: After Calling pa_resource_utils.init_fte_sync_wf for PersonId =' || to_char(l_person_id) ;
3469: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 3468: pa_debug.g_err_stage := 'Log: After Calling pa_resource_utils.init_fte_sync_wf for PersonId =' || to_char(l_person_id) ;

3464: -- log_message('After Calling pa_resource_utils.init_fte_sync_wf, x_return_status: '||x_return_status); -- bug 5683340 ---- Commenting For bug 4087022
3465: log_message('After Calling pa_resource_utils.init_fte_sync_wf, l_return_status: '||l_return_status); -- bug 5683340
3466:
3467:
3468: pa_debug.g_err_stage := 'Log: After Calling pa_resource_utils.init_fte_sync_wf for PersonId =' || to_char(l_person_id) ;
3469: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3470: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3471: END IF;
3472:

Line 3526: log_message(' Call to pa_resource_utils.init_fte_sync_wf errored in mass pull');

3522: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
3523: pa_debug.write_file('start_crm_workflow: ' || 'LOG',pa_debug.g_err_stage);
3524: END IF;
3525: l_per_success := 'N';
3526: log_message(' Call to pa_resource_utils.init_fte_sync_wf errored in mass pull');
3527: RAISE FND_API.G_EXC_ERROR;
3528:
3529: END IF ; --IF ((l_invol_term = 'N') AND (l_return_status = fnd_api.g_ret_sts_success ))
3530: