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 182: PA_UTILS.Add_Message( p_app_short_name => 'PA'

178: ,x_return_status => x_return_status
179: ,x_msg_count => x_msg_count
180: ,x_msg_data => x_msg_data);
181: ELSE
182: PA_UTILS.Add_Message( p_app_short_name => 'PA'
183: ,p_msg_name => 'PA_CI_NO_OWNER');
184: x_return_status := 'E';
185: END IF;
186: END IF;

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

190: l_reason_code := p_reason_code;
191: IF (l_classification_code IS NULL OR l_reason_code IS NULL )
192: THEN
193: IF (l_classification_code IS NULL) THEN
194: PA_UTILS.Add_Message( p_app_short_name => 'PA'
195: ,p_msg_name => 'PA_CI_NO_CLASSIFICATION_CODE');
196: x_return_status := 'E';
197: END IF;
198: IF (l_reason_code IS NULL) THEN

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

195: ,p_msg_name => 'PA_CI_NO_CLASSIFICATION_CODE');
196: x_return_status := 'E';
197: END IF;
198: IF (l_reason_code IS NULL) THEN
199: PA_UTILS.Add_Message( p_app_short_name => 'PA'
200: ,p_msg_name => 'PA_CI_NO_REASON_CODE');
201: x_return_status := 'E';
202: END IF;
203: END IF;

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

212: where element_name = p_object_name
213: and project_id = p_project_id;
214:
215: exception when TOO_MANY_ROWS then
216: PA_UTILS.Add_Message( p_app_short_name => 'PA'
217: ,p_msg_name => 'PA_OBJECT_NAME_MULTIPLE');
218: x_return_status := 'E';
219:
220: when OTHERS then

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

217: ,p_msg_name => 'PA_OBJECT_NAME_MULTIPLE');
218: x_return_status := 'E';
219:
220: when OTHERS then
221: PA_UTILS.Add_Message( p_app_short_name => 'PA'
222: ,p_msg_name => 'PA_OBJECT_NAME_INV');
223: x_return_status := 'E';
224: end;
225:

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

443: ,x_return_status => x_return_status
444: ,x_msg_count => x_msg_count
445: ,x_msg_data => x_msg_data);
446: ELSE
447: PA_UTILS.Add_Message( p_app_short_name => 'PA'
448: ,p_msg_name => 'PA_CI_NO_OWNER');
449: x_return_status := 'E';
450: END IF;
451: END IF;

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

455: l_reason_code := p_reason_code;
456: IF (l_classification_code IS NULL OR l_reason_code IS NULL )
457: THEN
458: IF (l_classification_code IS NULL) THEN
459: PA_UTILS.Add_Message( p_app_short_name => 'PA'
460: ,p_msg_name => 'PA_CI_NO_CLASSIFICATION_CODE');
461: x_return_status := 'E';
462: END IF;
463: IF (l_reason_code IS NULL) THEN

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

460: ,p_msg_name => 'PA_CI_NO_CLASSIFICATION_CODE');
461: x_return_status := 'E';
462: END IF;
463: IF (l_reason_code IS NULL) THEN
464: PA_UTILS.Add_Message( p_app_short_name => 'PA'
465: ,p_msg_name => 'PA_CI_NO_REASON_CODE');
466: x_return_status := 'E';
467: END IF;
468: END IF;

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

474:
475: if (l_owner_id <> l_curr_owner_id) then
476: l_chgowner_allowed := pa_ci_security_pkg.check_change_owner_access(p_ci_id);
477: if (l_chgowner_allowed <> 'T') then
478: PA_UTILS.Add_Message( p_app_short_name => 'PA'
479: ,p_msg_name => 'PA_CI_OWNER_CHG_NOT_ALLOWED');
480: x_return_status := 'E';
481: /* Code added for Bug#4050242, starts here */
482: else

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

481: /* Code added for Bug#4050242, starts here */
482: else
483: l_to_owner_allowed := pa_ci_security_pkg.is_to_owner_allowed(p_ci_id, l_owner_id);
484: if (l_to_owner_allowed <> 'T') then
485: PA_UTILS.Add_Message( p_app_short_name => 'PA'
486: ,p_msg_name => 'PA_CI_TO_OWNER_NOT_ALLOWED');
487: x_return_status := 'E';
488: end if;
489: /* Code added for Bug#4050242, ends here */

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

491:
492: -- Bug 3650877: Commneted this check for the owner id.
493:
494: --elsif (l_owner_id = l_curr_owner_id) then
495: -- PA_UTILS.Add_Message( p_app_short_name => 'PA'
496: -- ,p_msg_name => 'PA_CI_CHANGE_OWNER_INVALID');
497: -- x_return_status := 'E';
498: end if;
499: /* Code added for Bug#3297238, ends here */

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

507: where element_name = p_object_name
508: and project_id = p_project_id;
509:
510: exception when TOO_MANY_ROWS then
511: PA_UTILS.Add_Message( p_app_short_name => 'PA'
512: ,p_msg_name => 'PA_OBJECT_NAME_MULTIPLE');
513: x_return_status := 'E';
514:
515: when OTHERS then

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

512: ,p_msg_name => 'PA_OBJECT_NAME_MULTIPLE');
513: x_return_status := 'E';
514:
515: when OTHERS then
516: PA_UTILS.Add_Message( p_app_short_name => 'PA'
517: ,p_msg_name => 'PA_OBJECT_NAME_INV');
518: x_return_status := 'E';
519: end;
520:

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

656: fetch valid_ci into l_status_code;
657:
658: if (valid_ci%notfound) then
659: --- invalid ci_id error
660: PA_UTILS.Add_Message( p_app_short_name => 'PA'
661: ,p_msg_name => 'PA_CI_INVALID_ITEM');
662: x_return_status := FND_API.G_RET_STS_ERROR;
663: else
664: if (l_status_code <> 'CI_DRAFT') then

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

662: x_return_status := FND_API.G_RET_STS_ERROR;
663: else
664: if (l_status_code <> 'CI_DRAFT') then
665: --- invalid status error
666: PA_UTILS.Add_Message( p_app_short_name => 'PA'
667: ,p_msg_name => 'PA_CI_ONLY_DRAFT_DEL');
668: x_return_status := FND_API.G_RET_STS_ERROR;
669: end if;
670: end if;