DBA Data[Home] [Help]

APPS.PA_CONTROL_ITEMS_PUB dependencies on PA_UTILS

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

30:
31:
32: EXCEPTION
33: when TOO_MANY_ROWS then
34: PA_UTILS.Add_Message( p_app_short_name => 'PA'
35: ,p_msg_name => 'PA_OWNER_NAME_MULTIPLE');
36: x_return_status := 'E';
37: when NO_DATA_FOUND then
38: l_party_id := NULL;

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

36: x_return_status := 'E';
37: when NO_DATA_FOUND then
38: l_party_id := NULL;
39: when OTHERS then
40: PA_UTILS.Add_Message( p_app_short_name => 'PA'
41: ,p_msg_name => 'PA_CI_NO_OWNER');
42: x_return_status := 'E';
43: END;
44:

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

59:
60: x_party_id := l_party_id;
61:
62: exception when TOO_MANY_ROWS then
63: PA_UTILS.Add_Message( p_app_short_name => 'PA'
64: ,p_msg_name => 'PA_OWNER_NAME_MULTIPLE');
65: x_return_status := 'E';
66:
67: when OTHERS then

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

64: ,p_msg_name => 'PA_OWNER_NAME_MULTIPLE');
65: x_return_status := 'E';
66:
67: when OTHERS then
68: PA_UTILS.Add_Message( p_app_short_name => 'PA'
69: ,p_msg_name => 'PA_CI_NO_OWNER');
70: x_return_status := 'E';
71:
72: end getPartyIdFromName;

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

194: ,x_return_status => x_return_status
195: ,x_msg_count => x_msg_count
196: ,x_msg_data => x_msg_data);
197: ELSE
198: PA_UTILS.Add_Message( p_app_short_name => 'PA'
199: ,p_msg_name => 'PA_CI_NO_OWNER');
200: x_return_status := 'E';
201: END IF;
202: END IF;

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

206: l_reason_code := p_reason_code;
207: IF (l_classification_code IS NULL OR l_reason_code IS NULL )
208: THEN
209: IF (l_classification_code IS NULL) THEN
210: PA_UTILS.Add_Message( p_app_short_name => 'PA'
211: ,p_msg_name => 'PA_CI_NO_CLASSIFICATION_CODE');
212: x_return_status := 'E';
213: END IF;
214: IF (l_reason_code IS NULL) THEN

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

211: ,p_msg_name => 'PA_CI_NO_CLASSIFICATION_CODE');
212: x_return_status := 'E';
213: END IF;
214: IF (l_reason_code IS NULL) THEN
215: PA_UTILS.Add_Message( p_app_short_name => 'PA'
216: ,p_msg_name => 'PA_CI_NO_REASON_CODE');
217: x_return_status := 'E';
218: END IF;
219: END IF;

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

228: where element_name = p_object_name
229: and project_id = p_project_id;
230:
231: exception when TOO_MANY_ROWS then
232: PA_UTILS.Add_Message( p_app_short_name => 'PA'
233: ,p_msg_name => 'PA_OBJECT_NAME_MULTIPLE');
234: x_return_status := 'E';
235:
236: when OTHERS then

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

233: ,p_msg_name => 'PA_OBJECT_NAME_MULTIPLE');
234: x_return_status := 'E';
235:
236: when OTHERS then
237: PA_UTILS.Add_Message( p_app_short_name => 'PA'
238: ,p_msg_name => 'PA_OBJECT_NAME_INV');
239: x_return_status := 'E';
240: end;
241:

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

487: ,x_return_status => x_return_status
488: ,x_msg_count => x_msg_count
489: ,x_msg_data => x_msg_data);
490: ELSE
491: PA_UTILS.Add_Message( p_app_short_name => 'PA'
492: ,p_msg_name => 'PA_CI_NO_OWNER');
493: x_return_status := 'E';
494: END IF;
495: END IF;

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

499: l_reason_code := p_reason_code;
500: IF (l_classification_code IS NULL OR l_reason_code IS NULL )
501: THEN
502: IF (l_classification_code IS NULL) THEN
503: PA_UTILS.Add_Message( p_app_short_name => 'PA'
504: ,p_msg_name => 'PA_CI_NO_CLASSIFICATION_CODE');
505: x_return_status := 'E';
506: END IF;
507: IF (l_reason_code IS NULL) THEN

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

504: ,p_msg_name => 'PA_CI_NO_CLASSIFICATION_CODE');
505: x_return_status := 'E';
506: END IF;
507: IF (l_reason_code IS NULL) THEN
508: PA_UTILS.Add_Message( p_app_short_name => 'PA'
509: ,p_msg_name => 'PA_CI_NO_REASON_CODE');
510: x_return_status := 'E';
511: END IF;
512: END IF;

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

518:
519: if (l_owner_id <> l_curr_owner_id) then
520: l_chgowner_allowed := pa_ci_security_pkg.check_change_owner_access(p_ci_id);
521: if (l_chgowner_allowed <> 'T') then
522: PA_UTILS.Add_Message( p_app_short_name => 'PA'
523: ,p_msg_name => 'PA_CI_OWNER_CHG_NOT_ALLOWED');
524: x_return_status := 'E';
525: /* Code added for Bug#4050242, starts here */
526: else

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

525: /* Code added for Bug#4050242, starts here */
526: else
527: l_to_owner_allowed := pa_ci_security_pkg.is_to_owner_allowed(p_ci_id, l_owner_id);
528: if (l_to_owner_allowed <> 'T') then
529: PA_UTILS.Add_Message( p_app_short_name => 'PA'
530: ,p_msg_name => 'PA_CI_TO_OWNER_NOT_ALLOWED');
531: x_return_status := 'E';
532: end if;
533: /* Code added for Bug#4050242, ends here */

Line 539: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'

535:
536: -- Bug 3650877: Commneted this check for the owner id.
537:
538: --elsif (l_owner_id = l_curr_owner_id) then
539: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'
540: -- ,p_msg_name => 'PA_CI_CHANGE_OWNER_INVALID');
541: -- x_return_status := 'E';
542: end if;
543: /* Code added for Bug#3297238, ends here */

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

551: where element_name = p_object_name
552: and project_id = p_project_id;
553:
554: exception when TOO_MANY_ROWS then
555: PA_UTILS.Add_Message( p_app_short_name => 'PA'
556: ,p_msg_name => 'PA_OBJECT_NAME_MULTIPLE');
557: x_return_status := 'E';
558:
559: when OTHERS then

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

556: ,p_msg_name => 'PA_OBJECT_NAME_MULTIPLE');
557: x_return_status := 'E';
558:
559: when OTHERS then
560: PA_UTILS.Add_Message( p_app_short_name => 'PA'
561: ,p_msg_name => 'PA_OBJECT_NAME_INV');
562: x_return_status := 'E';
563: end;
564:

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

713: fetch valid_ci into l_status_code;
714:
715: if (valid_ci%notfound) then
716: --- invalid ci_id error
717: PA_UTILS.Add_Message( p_app_short_name => 'PA'
718: ,p_msg_name => 'PA_CI_INVALID_ITEM');
719: x_return_status := FND_API.G_RET_STS_ERROR;
720: else
721: if (l_status_code <> 'CI_DRAFT') then

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

719: x_return_status := FND_API.G_RET_STS_ERROR;
720: else
721: if (l_status_code <> 'CI_DRAFT') then
722: --- invalid status error
723: PA_UTILS.Add_Message( p_app_short_name => 'PA'
724: ,p_msg_name => 'PA_CI_ONLY_DRAFT_DEL');
725: x_return_status := FND_API.G_RET_STS_ERROR;
726: end if;
727: end if;