DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_UTILS

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

316: -- 5130421 End
317:
318: --Start Bug 3249669 : Check for profile option PA: Global Week Start Day being set.
319: IF NVL(FND_PROFILE.value('PA_GLOBAL_WEEK_START_DAY'),'N') = 'N' THEN
320: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
321: ,p_msg_name => 'PA_GLOBAL_WEEK_START_DAY_ERR' );
322: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
323: END IF;
324: --End Bug 3249669 : Check for profile option PA: Global Week Start Day being set.

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

710: ,x_error_message_code => l_error_message_code );
711:
712:
713: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
714: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
715: ,p_msg_name => l_error_message_code );
716: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
717: END IF;
718:

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

716: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
717: END IF;
718:
719: IF l_schedulable_flag <> 'Y' THEN
720: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
721: ,p_msg_name => 'PA_ROLE_NOT_SCHEDULABLE' );
722: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
723: return;
724: END IF;

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

768: 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;
769:
770: IF get_project_defaults%NOTFOUND THEN
771:
772: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
773: ,p_msg_name => 'PA_CANNOT_GET_PROJ_DEFAULTS');
774: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
775:
776: END IF;

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

783: FND_PROFILE.Get('PA_START_STAFFED_ASGMT_STATUS',l_assignment_rec.status_code);
784:
785: IF l_assignment_rec.status_code IS NULL THEN
786:
787: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
788: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
789: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
790:
791: END IF;

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

1318: ,x_return_status => l_return_status
1319: ,x_error_message_code => l_error_message_code);
1320:
1321: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_resource_type_id <> 101 THEN
1322: PA_UTILS.Add_Message ('PA', 'PA_INV_STAFF_OWNER');
1323: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1324: END IF;
1325:
1326: l_return_status := FND_API.G_MISS_CHAR;

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

1338: --Check that resource calendar percent is between 0 and 100 if calender type is resource.
1339: --
1340: IF l_assignment_rec.calendar_type = 'RESOURCE' AND
1341: (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
1342: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1343: ,p_msg_name => 'PA_CALENDAR_PERCENT_INVALID');
1344: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
1345: END IF;
1346:

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

1573: END IF;
1574: --added for 13336768
1575: IF (l_assignment_rec.calendar_type = 'OTHER' AND p_calendar_name is null AND l_assignment_rec.calendar_id is NULL)
1576: THEN
1577: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1578: ,p_msg_name => 'PA_OTHER_CALENDAR_NULL');
1579: RAISE FND_API.G_EXC_ERROR;
1580: END IF;
1581: --end for 13336768

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

2378: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2379:
2380: ELSIF check_record_version%NOTFOUND THEN
2381:
2382: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2383: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
2384: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2385:
2386: ELSE

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

2388: FND_PROFILE.Get('PA_DEF_FILLED_ASGMT_STATUS',l_default_filled_status_code);
2389:
2390: IF l_default_filled_status_code IS NULL THEN
2391:
2392: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
2393: ,p_msg_name => 'PA_FILLED_STATUS_NOT_DEFINED');
2394: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2395:
2396: ELSE

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

2544: l_return_status := PA_PROJECT_UTILS.Check_prj_stus_action_allowed
2545: ( x_project_status_code => l_status_codes(l_index)
2546: ,x_action_code => 'OPEN_ASGMT_ASSIGN_RESOURCES');
2547: IF l_return_status <> 'Y' THEN
2548: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2549: ,p_msg_name => 'PA_ASGN_NOT_ALLOWED_FOR_STUS');
2550: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2551: l_status_controls_valid := 'N';
2552: EXIT;

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

2790: ,x_msg_count => l_msg_count
2791: ,x_msg_data => l_msg_data);
2792:
2793: ELSE
2794: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2795: ,p_msg_name => 'PA_FAILED_TO_CREATE_OPEN_ASGN');
2796: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2797: END IF;
2798: --

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

4599: (PA_STARTUP.G_Calling_Application <> 'SELF_SERVICE' OR PA_STARTUP.G_Calling_Application IS NULL) /*AND
4600: PA_ASSIGNMENTS_PUB.G_update_assignment_bulk_call <> 'Y' */ THEN -- Bug 8233045
4601:
4602: /*
4603: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4604: ,p_msg_name => 'PA_SCH_UPDATE_NOT_ALLOWED');
4605: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4606: */
4607:

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

4618: (p_resource_id <> FND_API.G_MISS_NUM OR p_resource_id IS NULL) OR
4619: (p_resource_name <> FND_API.G_MISS_CHAR OR p_resource_name IS NULL) OR
4620: (p_resource_source_id <> FND_API.G_MISS_NUM OR p_resource_source_id IS NULL) ) THEN
4621:
4622: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4623: ,p_msg_name => 'PA_RES_OR_ROLE_NOT_ALLOWED');
4624: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4625:
4626:

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

4666:
4667:
4668: IF PA_ASGMT_WFSTD.is_approval_pending(p_assignment_id => l_assignment_rec.assignment_id) = 'Y' THEN
4669:
4670: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4671: ,p_msg_name => 'PA_WF_APPROVAL_PENDING');
4672: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4673: l_pending_wf_check := 'N';
4674:

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

4675:
4676: /* bug 8233045: GSI ER, skipping the following validation only when call is in bulk mode. This might need to be revisited later */
4677: ELSIF ((check_record_version%NOTFOUND )) THEN
4678:
4679: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4680: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
4681: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4682: l_record_version_check := 'N';
4683:

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

4728: ,x_return_status => l_return_status
4729: ,x_error_message_code => l_error_message_code);
4730:
4731: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4732: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4733: , p_msg_name => l_error_message_code);
4734: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4735: END IF;
4736:

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

4760: ,x_calendar_id => l_assignment_rec.calendar_id
4761: ,x_return_status => l_return_status
4762: ,x_error_message_code => l_error_message_code );
4763: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4764: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4765: ,p_msg_name => l_error_message_code );
4766: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4767: END IF;
4768: l_return_status := FND_API.G_MISS_CHAR;

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

4777:
4778: -- Do all Value to ID conversions and validations
4779: IF (l_assignment_rec.project_id IS NULL OR l_assignment_rec.project_id = FND_API.G_MISS_NUM)
4780: AND (p_project_number IS NOT NULL AND p_project_number <> FND_API.G_MISS_CHAR) THEN
4781: l_assignment_rec.project_id := PA_UTILS.GetProjId (x_project_num => p_project_number);
4782: END IF;
4783: IF (p_asgn_update_mode <> 'MASS_ONLINE') THEN
4784: IF l_assignment_rec.start_date IS NULL OR l_assignment_rec.start_date = FND_API.G_MISS_DATE THEN
4785: --

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

4823: ,x_country_code => l_location_country_code
4824: ,x_return_status => l_return_status
4825: ,x_error_message_code => l_error_message_code );
4826: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4827: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4828: ,p_msg_name => l_error_message_code );
4829: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4830: END IF;
4831: l_return_status := FND_API.G_MISS_CHAR;

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

4833:
4834: -- if country is not passed in, but region/city is passed in, give an error.
4835: ELSIF (p_location_city IS NOT NULL AND p_location_city <> FND_API.G_MISS_CHAR) OR
4836: (p_location_region IS NOT NULL AND p_location_region <> FND_API.G_MISS_CHAR) THEN
4837: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4838: ,p_msg_name => 'PA_COUNTRY_INVALID');
4839: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4840:
4841: --Bug 1795160: when user empty the location fields, the location id needs to be nulled out.

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

4858: ,x_valid => l_valid_flag
4859: ,x_return_status => l_return_status
4860: ,x_error_message_code => l_error_message_code );
4861: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4862: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4863: ,p_msg_name => l_error_message_code );
4864: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4865: END IF;
4866: l_return_status := FND_API.G_MISS_CHAR;

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

4871: ,x_valid => l_valid_flag
4872: ,x_return_status => l_return_status
4873: ,x_error_message_code => l_error_message_code );
4874: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4875: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4876: ,p_msg_name => l_error_message_code );
4877: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4878: END IF;
4879: l_return_status := FND_API.G_MISS_CHAR;

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

4883: --
4884: -- Check that max job level is >= min job level
4885: --
4886: IF l_assignment_rec.min_resource_job_level > l_assignment_rec.max_resource_job_level THEN
4887: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4888: ,p_msg_name => 'PA_MIN_JL_GREATER_THAN_MAX');
4889: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4890: END IF;
4891:

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

4896: IF (l_assignment_rec.comp_match_weighting <> FND_API.G_MISS_NUM AND l_assignment_rec.comp_match_weighting IS NOT NULL)
4897:
4898: THEN
4899: IF l_assignment_rec.comp_match_weighting < 0 OR l_assignment_rec.comp_match_weighting > 100 THEN
4900: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4901: ,p_msg_name => 'PA_INVALID_MATCH_WEIGHTING');
4902: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4903: END IF;
4904: END IF;

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

4904: END IF;
4905:
4906: IF (l_assignment_rec.avail_match_weighting <> FND_API.G_MISS_NUM AND l_assignment_rec.avail_match_weighting IS NOT NULL) THEN
4907: IF l_assignment_rec.avail_match_weighting < 0 OR l_assignment_rec.avail_match_weighting > 100 THEN
4908: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4909: ,p_msg_name => 'PA_INVALID_MATCH_WEIGHTING');
4910: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4911: END IF;
4912: END IF;

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

4914: IF (l_assignment_rec.job_level_match_weighting <> FND_API.G_MISS_NUM AND l_assignment_rec.job_level_match_weighting IS NOT
4915:
4916: NULL) THEN
4917: IF l_assignment_rec.job_level_match_weighting < 0 OR l_assignment_rec.job_level_match_weighting > 100 THEN
4918: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4919: ,p_msg_name => 'PA_INVALID_MATCH_WEIGHTING');
4920: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4921: END IF;
4922: END IF;

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

4928: IF l_assignment_rec.search_min_availability <> FND_API.G_MISS_NUM AND l_assignment_rec.search_min_availability IS NOT NULL THEN
4929: IF l_assignment_rec.search_min_availability < 0 OR
4930: l_assignment_rec.search_min_availability > 100 THEN
4931:
4932: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4933: ,p_msg_name => 'PA_MIN_AVAIL_INVALID');
4934: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4935: END IF;
4936: END IF;

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

4943: NULL THEN
4944: IF l_assignment_rec.search_min_candidate_score < 0 OR
4945: l_assignment_rec.search_min_candidate_score > 100 THEN
4946:
4947: PA_UTILS.Add_Message( p_app_short_name => 'PA'
4948: ,p_msg_name => 'PA_MIN_CAN_SCORE_INVALID');
4949: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4950: END IF;
4951: END IF;

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

4972: END IF;
4973: -- Bug: 4537865
4974:
4975: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4976: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4977: ,p_msg_name => l_error_message_code );
4978: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4979: ELSE
4980:

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

4988: x_return_status => l_return_status,
4989: x_error_message_code => l_error_message_code);
4990:
4991: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4992: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
4993: ,p_msg_name => l_error_message_code );
4994: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
4995: END IF;
4996: END IF;

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

5017: END IF;
5018: -- Bug: 4537865
5019:
5020: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5021: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
5022: ,p_msg_name => l_error_message_code );
5023: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5024: ELSE
5025:

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

5033: x_return_status => l_return_status,
5034: x_error_message_code => l_error_message_code);
5035:
5036: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5037: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
5038: ,p_msg_name => l_error_message_code );
5039: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5040: END IF;
5041:

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

5059: x_return_status => l_return_status,
5060: x_error_message_code => l_error_message_code);
5061:
5062: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5063: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
5064: ,p_msg_name => l_error_message_code );
5065: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5066: END IF;
5067: l_return_status := FND_API.G_MISS_CHAR;

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

5087: ,x_return_status => l_return_status
5088: ,x_error_message_code => l_error_message_code);
5089:
5090: IF l_return_status <> FND_API.G_RET_STS_SUCCESS OR l_resource_type_id <> 101 THEN
5091: PA_UTILS.Add_Message ('PA', 'PA_INV_STAFF_OWNER');
5092: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5093: END IF;
5094:
5095: l_return_status := FND_API.G_MISS_CHAR;

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

5116: END IF;
5117: --Bug:4537865
5118:
5119: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5120: PA_UTILS.Add_Message( p_app_short_name => 'PA'
5121: ,p_msg_name => 'PA_CURR_NOT_VALID');
5122: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5123: END IF;
5124: l_return_status := FND_API.G_MISS_CHAR;

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

5145: END IF;
5146: -- Bug: 4537865
5147:
5148: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5149: PA_UTILS.Add_Message( p_app_short_name => 'PA'
5150: ,p_msg_name => 'PA_CURR_NOT_VALID');
5151: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5152: END IF;
5153: l_return_status := FND_API.G_MISS_CHAR;

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

5160: --
5161: IF l_assignment_rec.tp_rate_override <> FND_API.G_MISS_NUM AND l_assignment_rec.tp_rate_override IS NOT NULL THEN
5162:
5163: IF l_assignment_rec.tp_rate_override < 0 THEN -- Bug 3198183
5164: PA_UTILS.Add_Message( p_app_short_name => 'PA'
5165: ,p_msg_name => 'PA_INVALID_TP_RATE_OVRD');
5166: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5167: END IF;
5168: END IF;

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

5172: --
5173: IF l_assignment_rec.bill_rate_override <> FND_API.G_MISS_NUM AND l_assignment_rec.bill_rate_override IS NOT NULL THEN
5174:
5175: IF l_assignment_rec.bill_rate_override <= 0 THEN
5176: PA_UTILS.Add_Message( p_app_short_name => 'PA'
5177: ,p_msg_name => 'PA_INVALID_BILL_RATE_OVRD');
5178: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5179: END IF;
5180: END IF;

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

5187: THEN
5188:
5189: IF l_assignment_rec.markup_percent_override < 0 THEN
5190:
5191: PA_UTILS.Add_Message( p_app_short_name => 'PA'
5192: ,p_msg_name => 'PA_INVALID_MARKUP_PERCENT');
5193: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5194: END IF;
5195:

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

5202: IF (l_assignment_rec.discount_percentage <> FND_API.G_MISS_NUM AND l_assignment_rec.discount_percentage IS NOT NULL) THEN
5203:
5204: IF (l_assignment_rec.discount_percentage < 0 OR l_assignment_rec.discount_percentage > 100)THEN
5205:
5206: PA_UTILS.Add_Message( p_app_short_name => 'PA'
5207: ,p_msg_name => 'PA_INVALID_DISCOUNT_PERCENT');
5208: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5209: END IF;
5210:

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

5224: ((l_assignment_rec.discount_percentage <> FND_API.G_MISS_NUM AND l_assignment_rec.discount_percentage IS NOT NULL) OR
5225: (l_assignment_rec.discount_percentage <> FND_API.G_MISS_NUM AND l_assignment_rec.discount_percentage IS NOT NULL) OR
5226: (l_assignment_rec.discount_percentage <> FND_API.G_MISS_NUM AND l_assignment_rec.discount_percentage IS NOT NULL))) THEN
5227:
5228: PA_UTILS.Add_Message( p_app_short_name => 'PA'
5229: ,p_msg_name => 'PA_RATE_DISC_REASON_REQUIRED');
5230: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5231:
5232: END IF;

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

5241: NULL THEN
5242:
5243: IF l_assignment_rec.tp_percent_applied_override < 0 THEN
5244:
5245: PA_UTILS.Add_Message( p_app_short_name => 'PA'
5246: ,p_msg_name => 'PA_INVALID_APPLY_BASIS_PERCENT');
5247: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5248: END IF;
5249:

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

5270:
5271: -- Bug: 4537865
5272:
5273: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5274: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
5275: ,p_msg_name => l_error_message_code );
5276: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5277: END IF;
5278: l_return_status := FND_API.G_MISS_CHAR;

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

5324: ,x_error_message_code => l_error_message_code );
5325:
5326: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5327:
5328: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
5329: ,p_msg_name => l_error_message_code );
5330: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5331: END IF;
5332: l_return_status := FND_API.G_MISS_CHAR;

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

5352: ,x_work_type_id => l_assignment_rec.work_type_id
5353: ,x_return_status => l_return_status
5354: ,x_error_message_code => l_error_message_code );
5355: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5356: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
5357: ,p_msg_name => l_error_message_code );
5358: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5359: --dbms_output.put_line('work type error');
5360:

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

5374:
5375: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5376:
5377:
5378: PA_UTILS.Add_Message( p_app_short_name => 'PA'
5379: ,p_msg_name => l_error_message_code );
5380: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5381: END IF;
5382:

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

5404: l_assignment_rec.staffing_priority_code := l_new_staffing_priority_code;
5405: END IF;
5406: -- Bug: 4537865
5407: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5408: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
5409: ,p_msg_name => l_error_message_code );
5410: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5411: END IF;
5412: l_return_status := FND_API.G_MISS_CHAR;

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

5434: ,x_error_message_code=> l_error_message_code) ;
5435: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5436:
5437:
5438: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
5439: ,p_msg_name => l_error_message_code );
5440: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5441: --dbms_output.put_line('expenditure type class error1');
5442:

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

5453: OPEN get_expenditure_type_class;
5454: FETCH get_expenditure_type_class INTO l_assignment_rec.expenditure_type_class;
5455:
5456: IF get_expenditure_type_class%NOTFOUND THEN
5457: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
5458: ,p_msg_name => 'PA_EXPTYPE_INVALID' );
5459: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5460: END IF;
5461: CLOSE get_expenditure_type_class;

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

5480: ,x_return_status => l_return_status
5481: ,x_error_message_code => l_error_message_code);
5482:
5483: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5484: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
5485: ,p_msg_name => l_error_message_code );
5486: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5487: --dbms_output.put_line('expenditure type error');
5488:

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

5545: x_organization_id =>l_assignment_rec.expenditure_organization_id,
5546: x_return_status => l_return_status,
5547: x_error_msg_code =>l_error_message_code );
5548: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5549: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
5550: ,p_msg_name => 'PA_EXP_ORG_INVALID');
5551: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5552:
5553: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

5553: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5554: IF (p_asgn_update_mode <> 'MASS_ONLINE') THEN
5555:
5556: --check a valid expenditure organization
5557: l_valid_flag := PA_UTILS2.CheckExpOrg (x_org_id => l_assignment_rec.expenditure_organization_id,
5558: x_txn_date => l_assignment_rec.start_date);
5559:
5560: IF l_valid_flag <> 'Y' THEN
5561:

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

5558: x_txn_date => l_assignment_rec.start_date);
5559:
5560: IF l_valid_flag <> 'Y' THEN
5561:
5562: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
5563: ,p_msg_name => 'PA_INVALID_EXP_ORG');
5564: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5565: --dbms_output.put_line('orgn id error2:'||l_valid_flag);
5566:

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

5590: ,x_return_status => l_return_status
5591: ,x_error_message_code => l_error_message_code );
5592:
5593: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5594: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
5595: ,p_msg_name => l_error_message_code );
5596: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5597: --dbms_output.put_line('job group error1');
5598:

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

5619: ,x_return_status => l_return_status
5620: ,x_error_message_code => l_error_message_code);
5621:
5622: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5623: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
5624: ,p_msg_name => l_error_message_code );
5625: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5626: --dbms_output.put_line('job error1');
5627:

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

5640: ,p_job_group_id => l_assignment_rec.fcst_job_group_id
5641: ,x_return_status => l_return_status
5642: ,x_error_message_code => l_error_message_code);
5643: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5644: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
5645: ,p_msg_name => l_error_message_code );
5646: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5647: --dbms_output.put_line('job relation error1');
5648: END IF;

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

5668: x_return_status => l_return_status,
5669: x_error_msg_code =>l_error_message_code );
5670:
5671: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5672: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
5673: ,p_msg_name => 'PA_EXP_OU_INVALID' );
5674: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5675:
5676: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

5683: pa_hr_update_api.check_exp_OU(p_org_id =>l_assignment_rec.expenditure_org_id
5684: ,x_return_status =>l_return_status
5685: ,x_error_message_code =>l_error_message_code ) ;
5686: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5687: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
5688: ,p_msg_name => l_error_message_code );
5689: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5690: --dbms_output.put_line('OU id error1');
5691:

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

5745: x_msg_count => l_msg_count,
5746: x_msg_data => l_msg_data);
5747:
5748: IF l_ret_code = FND_API.G_FALSE THEN
5749: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
5750: ,p_msg_name => 'PA_ADD_ADMIN_ASMT_SECURITY' );
5751: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5752: END IF;
5753: END IF;

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

5765: x_msg_count => l_msg_count,
5766: x_msg_data => l_msg_data);
5767:
5768: IF l_ret_code = FND_API.G_FALSE THEN
5769: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
5770: ,p_msg_name => 'PA_ADD_ADMIN_ASMT_SECURITY' );
5771: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5772: END IF;
5773: END IF;

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

5947: FETCH check_source_assignment INTO l_assignment_id;
5948: CLOSE check_source_assignment;
5949: IF l_assignment_id IS NOT NULL THEN
5950:
5951: PA_UTILS.Add_Message( p_app_short_name => 'PA'
5952: ,p_msg_name => 'PA_ASGN_AS_SOURCE_ASGN');
5953: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5954: x_return_status := FND_API.G_RET_STS_ERROR;
5955:

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

5959: OPEN check_record_version;
5960: FETCH check_record_version INTO l_assignment_row_id, l_project_party_id, l_project_id;
5961: CLOSE check_record_version;
5962: IF l_assignment_row_id IS NULL THEN
5963: PA_UTILS.Add_Message( p_app_short_name => 'PA'
5964: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
5965: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5966: x_return_status := FND_API.G_RET_STS_ERROR;
5967:

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

5976: OPEN check_team_template_wf;
5977: FETCH check_team_template_wf INTO l_workflow_in_progress_flag;
5978: CLOSE check_team_template_wf;
5979: IF l_workflow_in_progress_flag = 'Y' THEN
5980: PA_UTILS.Add_Message( p_app_short_name => 'PA'
5981: ,p_msg_name => 'PA_NO_REQ_WF');
5982: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
5983: x_return_status := FND_API.G_RET_STS_ERROR;
5984:

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

7710: p_object_name => 'PA_PROJECT_ASSIGNMENTS',
7711: p_object_key => p_assignment_id);
7712:
7713: IF l_return_code <> FND_API.G_TRUE THEN
7714: pa_utils.add_message (p_app_short_name => 'PA',
7715: p_msg_name => 'PA_UPD_ASGN_BASIC_INFO');
7716: END IF;
7717: END IF;
7718: END;

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

7754: p_object_name => 'PA_PROJECT_ASSIGNMENTS',
7755: p_object_key => p_assignment_id);
7756:
7757: IF l_return_code <> FND_API.G_TRUE THEN
7758: pa_utils.add_message (p_app_short_name => 'PA',
7759: p_msg_name => 'PA_UPD_ASGN_CANDIDATE');
7760: END IF;
7761: END IF;
7762: END;

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

7798: p_object_name => 'PA_PROJECT_ASSIGNMENTS',
7799: p_object_key => p_assignment_id);
7800:
7801: IF l_return_code <> FND_API.G_TRUE THEN
7802: pa_utils.add_message (p_app_short_name => 'PA',
7803: p_msg_name => 'PA_UPD_ASGN_FIN_INFO');
7804: END IF;
7805: END IF;
7806: END;