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_COPY_CHANGE_DOC_PVT dependencies on FND_API

Line 109: x_return_status := FND_API.G_RET_STS_SUCCESS;

105: -- Initialize the Error Stack
106: PA_DEBUG.init_err_stack('PA_COPY_CHANGE_DOC_PVT.COPY_CONTROL_ITEM');
107:
108: -- Initialize the return status to success
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110: /*
111: IF p_commit = FND_API.g_true THEN
112: SAVEPOINT COPY_CONTROL_ITEM;
113: END IF;

Line 111: IF p_commit = FND_API.g_true THEN

107:
108: -- Initialize the return status to success
109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110: /*
111: IF p_commit = FND_API.g_true THEN
112: SAVEPOINT COPY_CONTROL_ITEM;
113: END IF;
114: */
115:

Line 122: x_return_status := FND_API.G_RET_STS_ERROR;

118: if c_from_item%NOTFOUND then
119: close c_from_item;
120: PA_UTILS.Add_Message( p_app_short_name => 'PA'
121: ,p_msg_name => 'PA_CI_NO_FROM_ITEM');
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: end if;
124: close c_from_item;
125:
126: PA_CONTROL_ITEMS_PKG.INSERT_ROW (

Line 196: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

192: ,copy_from_row.CHANGE_APPROVER --added for bug 9108474
193: );
194:
195:
196: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
197: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
198: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
199: RAISE G_EXCEPTION_ERROR;
200: END IF;

Line 198: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

194:
195:
196: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
197: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
198: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
199: RAISE G_EXCEPTION_ERROR;
200: END IF;
201:
202: x_ci_id := lx_ci_id;

Line 206: if (x_return_status = FND_API.g_ret_sts_success) then

202: x_ci_id := lx_ci_id;
203:
204:
205: ------- copy impacts
206: if (x_return_status = FND_API.g_ret_sts_success) then
207: pa_ci_impacts_util.copy_impact(p_validate_only => 'F',
208: p_init_msg_list => 'F',
209: P_DEST_CI_ID => x_ci_id,
210: P_Source_ci_id => p_ci_id,

Line 217: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

213: x_msg_count => x_msg_count,
214: x_msg_data => x_msg_data);
215: end if;
216:
217: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
218: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
219: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
220: RAISE G_EXCEPTION_ERROR;
221: END IF;

Line 219: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

215: end if;
216:
217: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
218: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
219: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
220: RAISE G_EXCEPTION_ERROR;
221: END IF;
222:
223: FOR ci_obj_id_to1 IN c_obj_id_to1

Line 249: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

245: p_pm_product_code => NULL,
246: x_object_relationship_id => x_relationship_id,
247: x_return_status => x_return_status);
248:
249: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
250: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
251: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
252: RAISE G_EXCEPTION_ERROR;
253: END IF;

Line 251: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

247: x_return_status => x_return_status);
248:
249: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
250: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
251: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
252: RAISE G_EXCEPTION_ERROR;
253: END IF;
254:
255: END LOOP;

Line 268: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

264: x_return_status => x_return_status,
265: x_msg_count => x_msg_count,
266: x_msg_data => x_msg_data);
267:
268: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
269: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
270: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
271: RAISE G_EXCEPTION_ERROR;
272: END IF;

Line 270: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

266: x_msg_data => x_msg_data);
267:
268: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
269: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
270: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
271: RAISE G_EXCEPTION_ERROR;
272: END IF;
273:
274: --Copying related items

Line 284: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

280: x_return_status => x_return_status,
281: x_msg_count => x_msg_count,
282: x_msg_data => x_msg_data);
283:
284: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
285: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
286: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
287: RAISE G_EXCEPTION_ERROR;
288: END IF;

Line 286: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

282: x_msg_data => x_msg_data);
283:
284: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
285: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
286: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
287: RAISE G_EXCEPTION_ERROR;
288: END IF;
289:
290: FOR ci_actions_from IN c_action_from

Line 312: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

308: P_LAST_UPDATE_DATE => sysdate,
309: P_LAST_UPDATE_LOGIN => fnd_global.user_id,
310: P_RECORD_VERSION_NUMBER => ci_actions_from.RECORD_VERSION_NUMBER);
311:
312: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
313: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
314: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
315: RAISE G_EXCEPTION_ERROR;
316: END IF;

Line 314: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

310: P_RECORD_VERSION_NUMBER => ci_actions_from.RECORD_VERSION_NUMBER);
311:
312: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
313: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
314: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
315: RAISE G_EXCEPTION_ERROR;
316: END IF;
317:
318: FOR ci_comments_from IN c_comments_from(ci_actions_from.CI_ACTION_ID)

Line 333: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

329: P_LAST_UPDATE_DATE => trunc(sysdate),
330: P_LAST_UPDATE_LOGIN => fnd_global.user_id,
331: P_CI_ACTION_ID => l_action_id);
332:
333: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
334: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
335: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
336: RAISE G_EXCEPTION_ERROR;
337: END IF;

Line 335: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

331: P_CI_ACTION_ID => l_action_id);
332:
333: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
334: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
335: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
336: RAISE G_EXCEPTION_ERROR;
337: END IF;
338:
339: END LOOP;

Line 359: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

355: P_LAST_UPDATE_DATE => trunc(sysdate),
356: P_LAST_UPDATE_LOGIN => fnd_global.user_id,
357: P_CI_ACTION_ID => null);
358:
359: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
360: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
361: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
362: RAISE G_EXCEPTION_ERROR;
363: END IF;

Line 361: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

357: P_CI_ACTION_ID => null);
358:
359: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
360: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
361: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
362: RAISE G_EXCEPTION_ERROR;
363: END IF;
364:
365: END LOOP;

Line 413: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

409: ,p_ci_status => null
410: ,x_return_status => x_return_status
411: ,x_error_msg_code => x_error_msg_code );
412:
413: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
414: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
415: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
416: RAISE G_EXCEPTION_ERROR;
417: END IF;

Line 415: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

411: ,x_error_msg_code => x_error_msg_code );
412:
413: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
414: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
415: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
416: RAISE G_EXCEPTION_ERROR;
417: END IF;
418:
419: END LOOP;

Line 441: x_return_status := FND_API.G_RET_STS_ERROR;

437:
438: EXCEPTION
439: WHEN G_EXCEPTION_ERROR THEN
440: ROLLBACK TO copy_change_doc;
441: x_return_status := FND_API.G_RET_STS_ERROR;
442: FND_MSG_PUB.Count_And_Get
443: (p_count => x_msg_count,
444: p_data => x_msg_data);
445: RAISE;

Line 449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

445: RAISE;
446:
447: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
448: ROLLBACK TO copy_change_doc;
449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450: FND_MSG_PUB.Count_And_Get
451: (p_count => x_msg_count,
452: p_data => x_msg_data);
453: RAISE;

Line 457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

453: RAISE;
454:
455: WHEN OTHERS THEN
456: --ROLLBACK TO copy_change_doc;
457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
458: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_COPY_CHANGE_DOC_PVT',
459: p_procedure_name => 'COPY_CONTROL_ITEM',
460: p_error_text => SUBSTRB(SQLERRM,1,240));
461:

Line 472: p_init_msg_list IN VARCHAR2 := fnd_api.g_true

468:
469: END COPY_CONTROL_ITEM;
470:
471: procedure copy_change_doc(
472: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
473: ,p_commit IN VARCHAR2 := FND_API.g_false
474: ,p_validate_only IN VARCHAR2 := FND_API.g_true
475: ,p_ci_id IN NUMBER
476: ,p_ci_number IN VARCHAR2

Line 473: ,p_commit IN VARCHAR2 := FND_API.g_false

469: END COPY_CONTROL_ITEM;
470:
471: procedure copy_change_doc(
472: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
473: ,p_commit IN VARCHAR2 := FND_API.g_false
474: ,p_validate_only IN VARCHAR2 := FND_API.g_true
475: ,p_ci_id IN NUMBER
476: ,p_ci_number IN VARCHAR2
477: ,p_version_comments IN VARCHAR2

Line 474: ,p_validate_only IN VARCHAR2 := FND_API.g_true

470:
471: procedure copy_change_doc(
472: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
473: ,p_commit IN VARCHAR2 := FND_API.g_false
474: ,p_validate_only IN VARCHAR2 := FND_API.g_true
475: ,p_ci_id IN NUMBER
476: ,p_ci_number IN VARCHAR2
477: ,p_version_comments IN VARCHAR2
478: ,x_ci_id OUT NOCOPY NUMBER

Line 515: x_return_status := FND_API.G_RET_STS_SUCCESS;

511:
512: -- Initialize the Error Stack
513: PA_DEBUG.init_err_stack('PA_COPY_CHANGE_DOC_PVT.COPY_CHANGE_DOC');
514:
515: x_return_status := FND_API.G_RET_STS_SUCCESS;
516:
517: -- Issue API savepoint if the transaction is to be committed
518:
519: --IF p_commit = FND_API.g_true THEN

Line 519: --IF p_commit = FND_API.g_true THEN

515: x_return_status := FND_API.G_RET_STS_SUCCESS;
516:
517: -- Issue API savepoint if the transaction is to be committed
518:
519: --IF p_commit = FND_API.g_true THEN
520: SAVEPOINT copy_change_doc;
521: --END IF;
522:
523: IF p_init_msg_list = FND_API.g_true THEN

Line 523: IF p_init_msg_list = FND_API.g_true THEN

519: --IF p_commit = FND_API.g_true THEN
520: SAVEPOINT copy_change_doc;
521: --END IF;
522:
523: IF p_init_msg_list = FND_API.g_true THEN
524: fnd_msg_pub.initialize;
525: END IF;
526:
527: open c_ci_approved;

Line 534: x_return_status := FND_API.G_RET_STS_ERROR;

530:
531: if (l_sts_yn = 'Y') then
532: PA_UTILS.Add_Message( p_app_short_name => 'PA'
533: ,p_msg_name => 'PA_ALL_NO_UPDATE_RECORD');
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
536: end if;
537:
538: open c_vers_num;

Line 544: x_return_status := FND_API.G_RET_STS_ERROR;

540: if c_vers_num%NOTFOUND then
541: close c_vers_num;
542: PA_UTILS.Add_Message( p_app_short_name => 'PA'
543: ,p_msg_name => 'PA_CI_NO_VERSION_FOUND');
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
546: end if;
547: close c_vers_num;
548:

Line 565: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

561: );
562: x_ci_id := lx_ci_id;
563: x_version_number := lx_version_number;
564:
565: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
566: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
567: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
568: RAISE G_EXCEPTION_ERROR;
569: END IF;

Line 567: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

563: x_version_number := lx_version_number;
564:
565: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
566: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
567: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
568: RAISE G_EXCEPTION_ERROR;
569: END IF;
570: /*
571: IF (p_commit = FND_API.g_true and x_return_status = 'S') THEN

Line 571: IF (p_commit = FND_API.g_true and x_return_status = 'S') THEN

567: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
568: RAISE G_EXCEPTION_ERROR;
569: END IF;
570: /*
571: IF (p_commit = FND_API.g_true and x_return_status = 'S') THEN
572: commit;
573: END IF;
574: */
575: -- Reset the error stack when returning to the calling program

Line 583: x_return_status := FND_API.G_RET_STS_ERROR;

579:
580: EXCEPTION
581: WHEN G_EXCEPTION_ERROR THEN
582: ROLLBACK TO copy_change_doc;
583: x_return_status := FND_API.G_RET_STS_ERROR;
584: FND_MSG_PUB.Count_And_Get
585: (p_count => x_msg_count,
586: p_data => x_msg_data);
587:

Line 591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

587:
588:
589: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
590: ROLLBACK TO copy_change_doc;
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: FND_MSG_PUB.Count_And_Get
593: (p_count => x_msg_count,
594: p_data => x_msg_data);
595:

Line 598: --IF p_commit = FND_API.g_true THEN

594: p_data => x_msg_data);
595:
596:
597: WHEN OTHERS THEN
598: --IF p_commit = FND_API.g_true THEN
599: ROLLBACK TO copy_change_doc;
600: --END IF;
601:
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

598: --IF p_commit = FND_API.g_true THEN
599: ROLLBACK TO copy_change_doc;
600: --END IF;
601:
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
603: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_COPY_CHANGE_DOC_PVT',
604: p_procedure_name => 'copy_change_doc',
605: p_error_text => SUBSTRB(SQLERRM,1,240));
606:

Line 613: p_init_msg_list IN VARCHAR2 := fnd_api.g_true

609:
610: END copy_change_doc;
611:
612: procedure copy_change_doc(
613: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
614: ,p_commit IN VARCHAR2 := FND_API.g_false
615: ,p_validate_only IN VARCHAR2 := FND_API.g_true
616:
617: ,p_ci_id IN NUMBER

Line 614: ,p_commit IN VARCHAR2 := FND_API.g_false

610: END copy_change_doc;
611:
612: procedure copy_change_doc(
613: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
614: ,p_commit IN VARCHAR2 := FND_API.g_false
615: ,p_validate_only IN VARCHAR2 := FND_API.g_true
616:
617: ,p_ci_id IN NUMBER
618: ,p_src_ci_id IN NUMBER

Line 615: ,p_validate_only IN VARCHAR2 := FND_API.g_true

611:
612: procedure copy_change_doc(
613: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
614: ,p_commit IN VARCHAR2 := FND_API.g_false
615: ,p_validate_only IN VARCHAR2 := FND_API.g_true
616:
617: ,p_ci_id IN NUMBER
618: ,p_src_ci_id IN NUMBER
619: ,x_ci_id OUT NOCOPY NUMBER

Line 684: x_return_status := FND_API.G_RET_STS_SUCCESS;

680:
681: -- Initialize the Error Stack
682: PA_DEBUG.init_err_stack('PA_COPY_CHANGE_DOC_PVT.COPY_CHANGE_DOC');
683:
684: x_return_status := FND_API.G_RET_STS_SUCCESS;
685:
686: -- Issue API savepoint if the transaction is to be committed
687:
688: -- IF p_commit = FND_API.g_true THEN

Line 688: -- IF p_commit = FND_API.g_true THEN

684: x_return_status := FND_API.G_RET_STS_SUCCESS;
685:
686: -- Issue API savepoint if the transaction is to be committed
687:
688: -- IF p_commit = FND_API.g_true THEN
689: SAVEPOINT copy_change_doc;
690: -- END IF;
691:
692: IF p_init_msg_list = FND_API.g_true THEN

Line 692: IF p_init_msg_list = FND_API.g_true THEN

688: -- IF p_commit = FND_API.g_true THEN
689: SAVEPOINT copy_change_doc;
690: -- END IF;
691:
692: IF p_init_msg_list = FND_API.g_true THEN
693: fnd_msg_pub.initialize;
694: END IF;
695:
696: -- throw error for approved change docs

Line 701: x_return_status := FND_API.G_RET_STS_ERROR;

697:
698: IF( p_src_ci_id is null) THEN
699: PA_UTILS.Add_Message( p_app_short_name => 'PA'
700: ,p_msg_name => 'PA_SRC_CI_ID_IS_NULL');
701: x_return_status := FND_API.G_RET_STS_ERROR;
702: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
703: END IF;
704:
705: open c_ci_approved;

Line 712: x_return_status := FND_API.G_RET_STS_ERROR;

708:
709: if (l_sts_yn = 'Y') then
710: PA_UTILS.Add_Message( p_app_short_name => 'PA'
711: ,p_msg_name => 'PA_ALL_NO_UPDATE_RECORD');
712: x_return_status := FND_API.G_RET_STS_ERROR;
713: RAISE G_EXCEPTION_ERROR;
714: end if;
715:
716: open c_vers_num;

Line 722: x_return_status := FND_API.G_RET_STS_ERROR;

718: if c_vers_num%NOTFOUND then
719: close c_vers_num;
720: PA_UTILS.Add_Message( p_app_short_name => 'PA'
721: ,p_msg_name => 'PA_CI_NO_VERSION_FOUND');
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
724: end if;
725: close c_vers_num;
726:

Line 779: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

775: );
776: x_ci_id := lx_ci_id;
777: x_version_number := lx_version_number;
778:
779: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
780: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
781: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
782: RAISE G_EXCEPTION_ERROR;
783: END IF;

Line 781: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

777: x_version_number := lx_version_number;
778:
779: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
780: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
781: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
782: RAISE G_EXCEPTION_ERROR;
783: END IF;
784:
785: PA_CHNGE_DOC_POLICY_PVT.SET_CHNGE_DOC_VERS; -- sets policy to n

Line 793: IF (p_commit = FND_API.g_true and x_return_status = 'S') THEN

789: where ci_id = p_src_ci_id;
790:
791: PA_CHNGE_DOC_POLICY_PVT.RESET_CHNGE_DOC_VERS; -- sets policy to y
792: /*
793: IF (p_commit = FND_API.g_true and x_return_status = 'S') THEN
794: commit;
795: END IF;
796: */
797: -- Reset the error stack when returning to the calling program

Line 803: x_return_status := FND_API.G_RET_STS_ERROR;

799:
800: EXCEPTION
801: WHEN G_EXCEPTION_ERROR THEN
802: ROLLBACK TO copy_change_doc;
803: x_return_status := FND_API.G_RET_STS_ERROR;
804: FND_MSG_PUB.Count_And_Get
805: (p_count => x_msg_count,
806: p_data => x_msg_data);
807:

Line 811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

807:
808:
809: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
810: ROLLBACK TO copy_change_doc;
811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
812: FND_MSG_PUB.Count_And_Get
813: (p_count => x_msg_count,
814: p_data => x_msg_data);
815:

Line 818: --IF p_commit = FND_API.g_true THEN

814: p_data => x_msg_data);
815:
816:
817: WHEN OTHERS THEN
818: --IF p_commit = FND_API.g_true THEN
819: ROLLBACK TO copy_change_doc;
820: --END IF;
821:
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

818: --IF p_commit = FND_API.g_true THEN
819: ROLLBACK TO copy_change_doc;
820: --END IF;
821:
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
823: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_COPY_CHANGE_DOC_PVT',
824: p_procedure_name => 'copy_change_doc',
825: p_error_text => SUBSTRB(SQLERRM,1,240));
826:

Line 832: p_init_msg_list IN VARCHAR2 := fnd_api.g_true

828: p_data => x_msg_data);
829:
830: END copy_change_doc;
831: procedure update_comments(
832: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
833: ,p_commit IN VARCHAR2 := FND_API.g_false
834: ,p_validate_only IN VARCHAR2 := FND_API.g_true
835:
836: ,p_ci_id IN NUMBER

Line 833: ,p_commit IN VARCHAR2 := FND_API.g_false

829:
830: END copy_change_doc;
831: procedure update_comments(
832: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
833: ,p_commit IN VARCHAR2 := FND_API.g_false
834: ,p_validate_only IN VARCHAR2 := FND_API.g_true
835:
836: ,p_ci_id IN NUMBER
837: ,p_version_comments IN VARCHAR2

Line 834: ,p_validate_only IN VARCHAR2 := FND_API.g_true

830: END copy_change_doc;
831: procedure update_comments(
832: p_init_msg_list IN VARCHAR2 := fnd_api.g_true
833: ,p_commit IN VARCHAR2 := FND_API.g_false
834: ,p_validate_only IN VARCHAR2 := FND_API.g_true
835:
836: ,p_ci_id IN NUMBER
837: ,p_version_comments IN VARCHAR2
838:

Line 851: x_return_status := FND_API.G_RET_STS_SUCCESS;

847:
848: -- Initialize the Error Stack
849: PA_DEBUG.init_err_stack('PA_COPY_CHANGE_DOC_PVT.update_comments');
850:
851: x_return_status := FND_API.G_RET_STS_SUCCESS;
852:
853: -- Issue API savepoint if the transaction is to be committed
854:
855: --IF p_commit = FND_API.g_true THEN

Line 855: --IF p_commit = FND_API.g_true THEN

851: x_return_status := FND_API.G_RET_STS_SUCCESS;
852:
853: -- Issue API savepoint if the transaction is to be committed
854:
855: --IF p_commit = FND_API.g_true THEN
856: SAVEPOINT update_comments;
857: --END IF;
858:
859: IF p_init_msg_list = FND_API.g_true THEN

Line 859: IF p_init_msg_list = FND_API.g_true THEN

855: --IF p_commit = FND_API.g_true THEN
856: SAVEPOINT update_comments;
857: --END IF;
858:
859: IF p_init_msg_list = FND_API.g_true THEN
860: fnd_msg_pub.initialize;
861: END IF;
862:
863: IF( p_ci_id is null) THEN

Line 866: x_return_status := FND_API.G_RET_STS_ERROR;

862:
863: IF( p_ci_id is null) THEN
864: PA_UTILS.Add_Message( p_app_short_name => 'PA'
865: ,p_msg_name => 'PA_CI_ID_IS_NULL');
866: x_return_status := FND_API.G_RET_STS_ERROR;
867: END IF;
868:
869: PA_CHNGE_DOC_POLICY_PVT.SET_CHNGE_DOC_VERS; -- sets to N end;
870:

Line 877: IF (p_commit = FND_API.g_true and x_return_status = 'S') THEN

873: where ci_id = p_ci_id;
874:
875: PA_CHNGE_DOC_POLICY_PVT.RESET_CHNGE_DOC_VERS; -- sets to Y
876:
877: IF (p_commit = FND_API.g_true and x_return_status = 'S') THEN
878: commit;
879: END IF;
880:
881: -- Reset the error stack when returning to the calling program

Line 887: x_return_status := FND_API.G_RET_STS_ERROR;

883:
884: EXCEPTION
885: WHEN G_EXCEPTION_ERROR THEN
886: ROLLBACK TO update_comments;
887: x_return_status := FND_API.G_RET_STS_ERROR;
888: FND_MSG_PUB.Count_And_Get
889: (p_count => x_msg_count,
890: p_data => x_msg_data);
891:

Line 895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

891:
892:
893: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
894: ROLLBACK TO update_comments;
895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
896: FND_MSG_PUB.Count_And_Get
897: (p_count => x_msg_count,
898: p_data => x_msg_data);
899:

Line 902: --IF p_commit = FND_API.g_true THEN

898: p_data => x_msg_data);
899:
900:
901: WHEN OTHERS THEN
902: --IF p_commit = FND_API.g_true THEN
903: ROLLBACK TO update_comments;
904: --END IF;
905:
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

902: --IF p_commit = FND_API.g_true THEN
903: ROLLBACK TO update_comments;
904: --END IF;
905:
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
907: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_COPY_CHANGE_DOC_PVT',
908: p_procedure_name => 'update_comments',
909: p_error_text => SUBSTRB(SQLERRM,1,240));
910: