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_ASSIGNMENTS_PUB dependencies on PA_UTILS

Line 285: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

281: -- 5130421 End
282:
283: --Start Bug 3249669 : Check for profile option PA: Global Week Start Day being set.
284: IF NVL(FND_PROFILE.value('PA_GLOBAL_WEEK_START_DAY'),'N') = 'N' THEN
285: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
286: ,p_msg_name => 'PA_GLOBAL_WEEK_START_DAY_ERR' );
287: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
288: END IF;
289: --End Bug 3249669 : Check for profile option PA: Global Week Start Day being set.

Line 679: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

675: ,x_error_message_code => l_error_message_code );
676:
677:
678: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
679: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
680: ,p_msg_name => l_error_message_code );
681: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
682: END IF;
683:

Line 685: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

681: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
682: END IF;
683:
684: IF l_schedulable_flag <> 'Y' THEN
685: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
686: ,p_msg_name => 'PA_ROLE_NOT_SCHEDULABLE' );
687: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
688: return;
689: END IF;

Line 737: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

733: FETCH get_project_defaults INTO l_assignment_rec.work_type_id, l_assignment_rec.calendar_id, l_assignment_rec.location_id, l_location_country_code;
734:
735: IF get_project_defaults%NOTFOUND THEN
736:
737: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
738: ,p_msg_name => 'PA_CANNOT_GET_PROJ_DEFAULTS');
739: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
740:
741: END IF;

Line 752: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

748: FND_PROFILE.Get('PA_START_STAFFED_ASGMT_STATUS',l_assignment_rec.status_code);
749:
750: IF l_assignment_rec.status_code IS NULL THEN
751:
752: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
753: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
754: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
755:
756: END IF;

Line 1287: PA_UTILS.Add_Message ('PA', 'PA_INV_STAFF_OWNER');

1283: ,x_return_status => l_return_status
1284: ,x_error_message_code => l_error_message_code);
1285:
1286: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_resource_type_id <> 101 THEN
1287: PA_UTILS.Add_Message ('PA', 'PA_INV_STAFF_OWNER');
1288: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1289: END IF;
1290:
1291: l_return_status := FND_API.G_MISS_CHAR;

Line 1307: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1303: --Check that resource calendar percent is between 0 and 100 if calender type is resource.
1304: --
1305: IF l_assignment_rec.calendar_type = 'RESOURCE' AND
1306: (l_assignment_rec.resource_calendar_percent IS NULL OR l_assignment_rec.resource_calendar_percent < 0 OR l_assignment_rec.resource_calendar_percent > 100) THEN
1307: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1308: ,p_msg_name => 'PA_CALENDAR_PERCENT_INVALID');
1309: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1310: END IF;
1311:

Line 2317: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2313: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2314:
2315: ELSIF check_record_version%NOTFOUND THEN
2316:
2317: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2318: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
2319: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2320:
2321: ELSE

Line 2327: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

2323: FND_PROFILE.Get('PA_DEF_FILLED_ASGMT_STATUS',l_default_filled_status_code);
2324:
2325: IF l_default_filled_status_code IS NULL THEN
2326:
2327: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
2328: ,p_msg_name => 'PA_FILLED_STATUS_NOT_DEFINED');
2329: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2330:
2331: ELSE

Line 2483: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2479: l_return_status := PA_PROJECT_UTILS.Check_prj_stus_action_allowed
2480: ( x_project_status_code => l_status_codes(l_index)
2481: ,x_action_code => 'OPEN_ASGMT_ASSIGN_RESOURCES');
2482: IF l_return_status <> 'Y' THEN
2483: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2484: ,p_msg_name => 'PA_ASGN_NOT_ALLOWED_FOR_STUS');
2485: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2486: l_status_controls_valid := 'N';
2487: EXIT;

Line 2729: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2725: ,x_msg_count => l_msg_count
2726: ,x_msg_data => l_msg_data);
2727:
2728: ELSE
2729: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2730: ,p_msg_name => 'PA_FAILED_TO_CREATE_OPEN_ASGN');
2731: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2732: END IF;
2733: --

Line 3676: PA_UTILS.Add_Message( p_app_short_name => 'PA'

3672: l_assignment_rec.calendar_type <> FND_API.G_MISS_CHAR) AND
3673: (PA_STARTUP.G_Calling_Application <> 'SELF_SERVICE' OR PA_STARTUP.G_Calling_Application IS NULL) THEN
3674:
3675: /*
3676: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3677: ,p_msg_name => 'PA_SCH_UPDATE_NOT_ALLOWED');
3678: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3679: */
3680: NULL;

Line 3694: PA_UTILS.Add_Message( p_app_short_name => 'PA'

3690: (p_resource_id <> FND_API.G_MISS_NUM OR p_resource_id IS NULL) OR
3691: (p_resource_name <> FND_API.G_MISS_CHAR OR p_resource_name IS NULL) OR
3692: (p_resource_source_id <> FND_API.G_MISS_NUM OR p_resource_source_id IS NULL)) THEN
3693:
3694: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3695: ,p_msg_name => 'PA_RES_OR_ROLE_NOT_ALLOWED');
3696: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3697:
3698:

Line 3728: PA_UTILS.Add_Message( p_app_short_name => 'PA'

3724: FETCH check_record_version INTO l_assignment_rec.assignment_row_id, l_assignment_rec.apprvl_status_code;
3725:
3726: IF PA_ASGMT_WFSTD.is_approval_pending(p_assignment_id => l_assignment_rec.assignment_id) = 'Y' THEN
3727:
3728: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3729: ,p_msg_name => 'PA_WF_APPROVAL_PENDING');
3730: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3731: l_pending_wf_check := 'N';
3732:

Line 3736: PA_UTILS.Add_Message( p_app_short_name => 'PA'

3732:
3733:
3734: ELSIF (check_record_version%NOTFOUND ) THEN
3735:
3736: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3737: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
3738: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3739: l_record_version_check := 'N';
3740:

Line 3787: PA_UTILS.Add_Message( p_app_short_name => 'PA'

3783: ,x_status_code => l_assignment_rec.status_code
3784: ,x_return_status => l_return_status
3785: ,x_error_message_code => l_error_message_code);
3786: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3787: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3788: , p_msg_name => l_error_message_code);
3789: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3790: END IF;
3791:

Line 3823: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

3819: ,x_calendar_id => l_assignment_rec.calendar_id
3820: ,x_return_status => l_return_status
3821: ,x_error_message_code => l_error_message_code );
3822: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3823: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
3824: ,p_msg_name => l_error_message_code );
3825: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3826: END IF;
3827: l_return_status := FND_API.G_MISS_CHAR;

Line 3842: l_assignment_rec.project_id := PA_UTILS.GetProjId (x_project_num => p_project_number);

3838:
3839: -- Do all Value to ID conversions and validations
3840: IF (l_assignment_rec.project_id IS NULL OR l_assignment_rec.project_id = FND_API.G_MISS_NUM)
3841: AND (p_project_number IS NOT NULL AND p_project_number <> FND_API.G_MISS_CHAR) THEN
3842: l_assignment_rec.project_id := PA_UTILS.GetProjId (x_project_num => p_project_number);
3843: END IF;
3844:
3845: IF (p_asgn_update_mode <> 'MASS_ONLINE') THEN
3846: IF l_assignment_rec.start_date IS NULL OR l_assignment_rec.start_date = FND_API.G_MISS_DATE THEN

Line 3891: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

3887: ,x_country_code => l_location_country_code
3888: ,x_return_status => l_return_status
3889: ,x_error_message_code => l_error_message_code );
3890: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3891: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
3892: ,p_msg_name => l_error_message_code );
3893: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3894: END IF;
3895: l_return_status := FND_API.G_MISS_CHAR;

Line 3901: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

3897:
3898: -- if country is not passed in, but region/city is passed in, give an error.
3899: ELSIF (p_location_city IS NOT NULL AND p_location_city <> FND_API.G_MISS_CHAR) OR
3900: (p_location_region IS NOT NULL AND p_location_region <> FND_API.G_MISS_CHAR) THEN
3901: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
3902: ,p_msg_name => 'PA_COUNTRY_INVALID');
3903: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3904:
3905: --Bug 1795160: when user empty the location fields, the location id needs to be nulled out.

Line 3925: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

3921: ,x_valid => l_valid_flag
3922: ,x_return_status => l_return_status
3923: ,x_error_message_code => l_error_message_code );
3924: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3925: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
3926: ,p_msg_name => l_error_message_code );
3927: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3928: END IF;
3929: l_return_status := FND_API.G_MISS_CHAR;

Line 3938: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

3934: ,x_valid => l_valid_flag
3935: ,x_return_status => l_return_status
3936: ,x_error_message_code => l_error_message_code );
3937: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3938: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
3939: ,p_msg_name => l_error_message_code );
3940: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3941: END IF;
3942: l_return_status := FND_API.G_MISS_CHAR;

Line 3949: PA_UTILS.Add_Message( p_app_short_name => 'PA'

3945: --
3946: -- Check that max job level is >= min job level
3947: --
3948: IF l_assignment_rec.min_resource_job_level > l_assignment_rec.max_resource_job_level THEN
3949: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3950: ,p_msg_name => 'PA_MIN_JL_GREATER_THAN_MAX');
3951: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3952: END IF;
3953:

Line 3961: PA_UTILS.Add_Message( p_app_short_name => 'PA'

3957: -- Validate Candidate Score Match Weightings
3958: --
3959: IF (l_assignment_rec.comp_match_weighting <> FND_API.G_MISS_NUM AND l_assignment_rec.comp_match_weighting IS NOT NULL) THEN
3960: IF l_assignment_rec.comp_match_weighting < 0 OR l_assignment_rec.comp_match_weighting > 100 THEN
3961: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3962: ,p_msg_name => 'PA_INVALID_MATCH_WEIGHTING');
3963: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3964: END IF;
3965: END IF;

Line 3969: PA_UTILS.Add_Message( p_app_short_name => 'PA'

3965: END IF;
3966:
3967: IF (l_assignment_rec.avail_match_weighting <> FND_API.G_MISS_NUM AND l_assignment_rec.avail_match_weighting IS NOT NULL) THEN
3968: IF l_assignment_rec.avail_match_weighting < 0 OR l_assignment_rec.avail_match_weighting > 100 THEN
3969: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3970: ,p_msg_name => 'PA_INVALID_MATCH_WEIGHTING');
3971: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3972: END IF;
3973: END IF;

Line 3977: PA_UTILS.Add_Message( p_app_short_name => 'PA'

3973: END IF;
3974:
3975: IF (l_assignment_rec.job_level_match_weighting <> FND_API.G_MISS_NUM AND l_assignment_rec.job_level_match_weighting IS NOT NULL) THEN
3976: IF l_assignment_rec.job_level_match_weighting < 0 OR l_assignment_rec.job_level_match_weighting > 100 THEN
3977: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3978: ,p_msg_name => 'PA_INVALID_MATCH_WEIGHTING');
3979: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3980: END IF;
3981: END IF;

Line 3992: PA_UTILS.Add_Message( p_app_short_name => 'PA'

3988:
3989: IF l_assignment_rec.search_min_availability < 0 OR
3990: l_assignment_rec.search_min_availability > 100 THEN
3991:
3992: PA_UTILS.Add_Message( p_app_short_name => 'PA'
3993: ,p_msg_name => 'PA_MIN_AVAIL_INVALID');
3994: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
3995: END IF;
3996: END IF;

Line 4006: PA_UTILS.Add_Message( p_app_short_name => 'PA'

4002:
4003: IF l_assignment_rec.search_min_candidate_score < 0 OR
4004: l_assignment_rec.search_min_candidate_score > 100 THEN
4005:
4006: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4007: ,p_msg_name => 'PA_MIN_CAN_SCORE_INVALID');
4008: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4009: END IF;
4010: END IF;

Line 4033: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4029: END IF;
4030: -- Bug: 4537865
4031:
4032: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4033: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4034: ,p_msg_name => l_error_message_code );
4035: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4036: ELSE
4037:

Line 4049: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4045: x_return_status => l_return_status,
4046: x_error_message_code => l_error_message_code);
4047:
4048: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4049: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4050: ,p_msg_name => l_error_message_code );
4051: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4052: END IF;
4053:

Line 4078: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4074: END IF;
4075: -- Bug: 4537865
4076:
4077: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4078: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4079: ,p_msg_name => l_error_message_code );
4080: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4081: ELSE
4082:

Line 4094: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4090: x_return_status => l_return_status,
4091: x_error_message_code => l_error_message_code);
4092:
4093: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4094: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4095: ,p_msg_name => l_error_message_code );
4096: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4097: END IF;
4098:

Line 4119: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4115: x_return_status => l_return_status,
4116: x_error_message_code => l_error_message_code);
4117:
4118: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4119: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4120: ,p_msg_name => l_error_message_code );
4121: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4122: END IF;
4123: l_return_status := FND_API.G_MISS_CHAR;

Line 4146: PA_UTILS.Add_Message ('PA', 'PA_INV_STAFF_OWNER');

4142: ,x_return_status => l_return_status
4143: ,x_error_message_code => l_error_message_code);
4144:
4145: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_resource_type_id <> 101 THEN
4146: PA_UTILS.Add_Message ('PA', 'PA_INV_STAFF_OWNER');
4147: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4148: END IF;
4149:
4150: l_return_status := FND_API.G_MISS_CHAR;

Line 4175: PA_UTILS.Add_Message( p_app_short_name => 'PA'

4171: END IF;
4172: --Bug:4537865
4173:
4174: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4175: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4176: ,p_msg_name => 'PA_CURR_NOT_VALID');
4177: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4178: END IF;
4179: l_return_status := FND_API.G_MISS_CHAR;

Line 4204: PA_UTILS.Add_Message( p_app_short_name => 'PA'

4200: END IF;
4201: -- Bug: 4537865
4202:
4203: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4204: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4205: ,p_msg_name => 'PA_CURR_NOT_VALID');
4206: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4207: END IF;
4208: l_return_status := FND_API.G_MISS_CHAR;

Line 4219: PA_UTILS.Add_Message( p_app_short_name => 'PA'

4215: --
4216: IF l_assignment_rec.tp_rate_override <> FND_API.G_MISS_NUM AND l_assignment_rec.tp_rate_override IS NOT NULL THEN
4217:
4218: IF l_assignment_rec.tp_rate_override < 0 THEN -- Bug 3198183
4219: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4220: ,p_msg_name => 'PA_INVALID_TP_RATE_OVRD');
4221: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4222: END IF;
4223: END IF;

Line 4231: PA_UTILS.Add_Message( p_app_short_name => 'PA'

4227: --
4228: IF l_assignment_rec.bill_rate_override <> FND_API.G_MISS_NUM AND l_assignment_rec.bill_rate_override IS NOT NULL THEN
4229:
4230: IF l_assignment_rec.bill_rate_override <= 0 THEN
4231: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4232: ,p_msg_name => 'PA_INVALID_BILL_RATE_OVRD');
4233: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4234: END IF;
4235: END IF;

Line 4244: PA_UTILS.Add_Message( p_app_short_name => 'PA'

4240: IF l_assignment_rec.markup_percent_override <> FND_API.G_MISS_NUM AND l_assignment_rec.markup_percent_override IS NOT NULL THEN
4241:
4242: IF l_assignment_rec.markup_percent_override < 0 THEN
4243:
4244: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4245: ,p_msg_name => 'PA_INVALID_MARKUP_PERCENT');
4246: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4247: END IF;
4248:

Line 4259: PA_UTILS.Add_Message( p_app_short_name => 'PA'

4255: IF (l_assignment_rec.discount_percentage <> FND_API.G_MISS_NUM AND l_assignment_rec.discount_percentage IS NOT NULL) THEN
4256:
4257: IF (l_assignment_rec.discount_percentage < 0 OR l_assignment_rec.discount_percentage > 100)THEN
4258:
4259: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4260: ,p_msg_name => 'PA_INVALID_DISCOUNT_PERCENT');
4261: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4262: END IF;
4263:

Line 4275: PA_UTILS.Add_Message( p_app_short_name => 'PA'

4271: IF (l_rate_discount_reason_flag ='Y' AND (l_br_override_flag ='Y' OR l_br_discount_override_flag='Y') AND
4272: ((l_assignment_rec.discount_percentage <> FND_API.G_MISS_NUM AND l_assignment_rec.discount_percentage IS NOT NULL) OR
4273: (l_assignment_rec.discount_percentage <> FND_API.G_MISS_NUM AND l_assignment_rec.discount_percentage IS NOT NULL) OR
4274: (l_assignment_rec.discount_percentage <> FND_API.G_MISS_NUM AND l_assignment_rec.discount_percentage IS NOT NULL))) THEN
4275: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4276: ,p_msg_name => 'PA_RATE_DISC_REASON_REQUIRED');
4277: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4278:
4279: END IF;

Line 4290: PA_UTILS.Add_Message( p_app_short_name => 'PA'

4286: IF l_assignment_rec.tp_percent_applied_override <> FND_API.G_MISS_NUM AND l_assignment_rec.tp_percent_applied_override IS NOT NULL THEN
4287:
4288: IF l_assignment_rec.tp_percent_applied_override < 0 THEN
4289:
4290: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4291: ,p_msg_name => 'PA_INVALID_APPLY_BASIS_PERCENT');
4292: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4293: END IF;
4294:

Line 4315: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4311: END IF;
4312: -- Bug: 4537865
4313:
4314: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4315: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4316: ,p_msg_name => l_error_message_code );
4317: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4318: END IF;
4319: l_return_status := FND_API.G_MISS_CHAR;

Line 4362: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4358: ,x_error_message_code => l_error_message_code );
4359:
4360: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4361:
4362: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4363: ,p_msg_name => l_error_message_code );
4364: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4365: END IF;
4366: l_return_status := FND_API.G_MISS_CHAR;

Line 4389: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4385: ,x_work_type_id => l_assignment_rec.work_type_id
4386: ,x_return_status => l_return_status
4387: ,x_error_message_code => l_error_message_code );
4388: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4389: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4390: ,p_msg_name => l_error_message_code );
4391: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4392: --dbms_output.put_line('work type error');
4393:

Line 4408: PA_UTILS.Add_Message( p_app_short_name => 'PA'

4404: ,X_ERROR_MESSAGE_CODE => l_error_message_code);
4405: --dbms_output.put_line('after check work type');
4406:
4407: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4408: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4409: ,p_msg_name => l_error_message_code );
4410: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4411: END IF;
4412:

Line 4439: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4435: l_assignment_rec.staffing_priority_code := l_new_staffing_priority_code;
4436: END IF;
4437: -- Bug: 4537865
4438: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4439: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4440: ,p_msg_name => l_error_message_code );
4441: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4442: END IF;
4443: l_return_status := FND_API.G_MISS_CHAR;

Line 4467: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4463: ,x_sys_link_func => l_assignment_rec.expenditure_type_class
4464: ,x_return_status => l_return_status
4465: ,x_error_message_code=> l_error_message_code) ;
4466: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4467: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4468: ,p_msg_name => l_error_message_code );
4469: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4470: --dbms_output.put_line('expenditure type class error1');
4471:

Line 4486: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4482: OPEN get_expenditure_type_class;
4483: FETCH get_expenditure_type_class INTO l_assignment_rec.expenditure_type_class;
4484:
4485: IF get_expenditure_type_class%NOTFOUND THEN
4486: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4487: ,p_msg_name => 'PA_EXPTYPE_INVALID' );
4488: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4489: END IF;
4490: CLOSE get_expenditure_type_class;

Line 4512: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4508: ,x_return_status => l_return_status
4509: ,x_error_message_code => l_error_message_code);
4510:
4511: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4512: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4513: ,p_msg_name => l_error_message_code );
4514: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4515: --dbms_output.put_line('expenditure type error');
4516:

Line 4575: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4571: x_organization_id =>l_assignment_rec.expenditure_organization_id,
4572: x_return_status => l_return_status,
4573: x_error_msg_code =>l_error_message_code );
4574: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4575: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4576: ,p_msg_name => 'PA_EXP_ORG_INVALID');
4577: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4578:
4579: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 4584: l_valid_flag := PA_UTILS2.CheckExpOrg (x_org_id => l_assignment_rec.expenditure_organization_id,

4580:
4581: IF (p_asgn_update_mode <> 'MASS_ONLINE') THEN
4582:
4583: --check a valid expenditure organization
4584: l_valid_flag := PA_UTILS2.CheckExpOrg (x_org_id => l_assignment_rec.expenditure_organization_id,
4585: x_txn_date => l_assignment_rec.start_date);
4586:
4587: IF l_valid_flag <> 'Y' THEN
4588: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

Line 4588: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4584: l_valid_flag := PA_UTILS2.CheckExpOrg (x_org_id => l_assignment_rec.expenditure_organization_id,
4585: x_txn_date => l_assignment_rec.start_date);
4586:
4587: IF l_valid_flag <> 'Y' THEN
4588: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4589: ,p_msg_name => 'PA_INVALID_EXP_ORG');
4590: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4591: --dbms_output.put_line('orgn id error2:'||l_valid_flag);
4592:

Line 4619: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4615: ,x_return_status => l_return_status
4616: ,x_error_message_code => l_error_message_code );
4617:
4618: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4619: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4620: ,p_msg_name => l_error_message_code );
4621: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4622: --dbms_output.put_line('job group error1');
4623:

Line 4647: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4643: ,x_return_status => l_return_status
4644: ,x_error_message_code => l_error_message_code);
4645:
4646: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4647: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4648: ,p_msg_name => l_error_message_code );
4649: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4650: --dbms_output.put_line('job error1');
4651:

Line 4669: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4665: ,p_job_group_id => l_assignment_rec.fcst_job_group_id
4666: ,x_return_status => l_return_status
4667: ,x_error_message_code => l_error_message_code);
4668: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4669: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4670: ,p_msg_name => l_error_message_code );
4671: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4672: --dbms_output.put_line('job relation error1');
4673: END IF;

Line 4696: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4692: x_return_status => l_return_status,
4693: x_error_msg_code =>l_error_message_code );
4694:
4695: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4696: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4697: ,p_msg_name => 'PA_EXP_OU_INVALID' );
4698: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4699:
4700: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 4711: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4707: pa_hr_update_api.check_exp_OU(p_org_id =>l_assignment_rec.expenditure_org_id
4708: ,x_return_status =>l_return_status
4709: ,x_error_message_code =>l_error_message_code ) ;
4710: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4711: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4712: ,p_msg_name => l_error_message_code );
4713: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4714: --dbms_output.put_line('OU id error1');
4715:

Line 4776: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4772: x_msg_count => l_msg_count,
4773: x_msg_data => l_msg_data);
4774:
4775: IF l_ret_code = FND_API.G_FALSE THEN
4776: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4777: ,p_msg_name => 'PA_ADD_ADMIN_ASMT_SECURITY' );
4778: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4779: END IF;
4780: END IF;

Line 4797: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

4793: x_msg_count => l_msg_count,
4794: x_msg_data => l_msg_data);
4795:
4796: IF l_ret_code = FND_API.G_FALSE THEN
4797: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4798: ,p_msg_name => 'PA_ADD_ADMIN_ASMT_SECURITY' );
4799: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4800: END IF;
4801: END IF;

Line 4975: PA_UTILS.Add_Message( p_app_short_name => 'PA'

4971: FETCH check_source_assignment INTO l_assignment_id;
4972: CLOSE check_source_assignment;
4973: IF l_assignment_id IS NOT NULL THEN
4974:
4975: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4976: ,p_msg_name => 'PA_ASGN_AS_SOURCE_ASGN');
4977: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4978: x_return_status := FND_API.G_RET_STS_ERROR;
4979:

Line 4987: PA_UTILS.Add_Message( p_app_short_name => 'PA'

4983: OPEN check_record_version;
4984: FETCH check_record_version INTO l_assignment_row_id, l_project_party_id, l_project_id;
4985: CLOSE check_record_version;
4986: IF l_assignment_row_id IS NULL THEN
4987: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4988: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
4989: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4990: x_return_status := FND_API.G_RET_STS_ERROR;
4991:

Line 5004: PA_UTILS.Add_Message( p_app_short_name => 'PA'

5000: OPEN check_team_template_wf;
5001: FETCH check_team_template_wf INTO l_workflow_in_progress_flag;
5002: CLOSE check_team_template_wf;
5003: IF l_workflow_in_progress_flag = 'Y' THEN
5004: PA_UTILS.Add_Message( p_app_short_name => 'PA'
5005: ,p_msg_name => 'PA_NO_REQ_WF');
5006: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5007: x_return_status := FND_API.G_RET_STS_ERROR;
5008:

Line 6738: pa_utils.add_message (p_app_short_name => 'PA',

6734: p_object_name => 'PA_PROJECT_ASSIGNMENTS',
6735: p_object_key => p_assignment_id);
6736:
6737: IF l_return_code <> FND_API.G_TRUE THEN
6738: pa_utils.add_message (p_app_short_name => 'PA',
6739: p_msg_name => 'PA_UPD_ASGN_BASIC_INFO');
6740: END IF;
6741: END IF;
6742: END;

Line 6782: pa_utils.add_message (p_app_short_name => 'PA',

6778: p_object_name => 'PA_PROJECT_ASSIGNMENTS',
6779: p_object_key => p_assignment_id);
6780:
6781: IF l_return_code <> FND_API.G_TRUE THEN
6782: pa_utils.add_message (p_app_short_name => 'PA',
6783: p_msg_name => 'PA_UPD_ASGN_CANDIDATE');
6784: END IF;
6785: END IF;
6786: END;

Line 6826: pa_utils.add_message (p_app_short_name => 'PA',

6822: p_object_name => 'PA_PROJECT_ASSIGNMENTS',
6823: p_object_key => p_assignment_id);
6824:
6825: IF l_return_code <> FND_API.G_TRUE THEN
6826: pa_utils.add_message (p_app_short_name => 'PA',
6827: p_msg_name => 'PA_UPD_ASGN_FIN_INFO');
6828: END IF;
6829: END IF;
6830: END;