102:
103: begin
104:
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: /*
431: set current_audit_flag = 'N'
432: where ci_id = p_ci_id;
433:
434: -- Reset the error stack when returning to the calling program
435: PA_DEBUG.Reset_Err_Stack;
436:
437:
438: EXCEPTION
439: WHEN G_EXCEPTION_ERROR THEN
509: where ci_id =p_ci_id );
510: BEGIN
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
572: commit;
573: END IF;
574: */
575: -- Reset the error stack when returning to the calling program
576: PA_DEBUG.Reset_Err_Stack;
577:
578:
579:
580: EXCEPTION
678:
679: BEGIN
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
794: commit;
795: END IF;
796: */
797: -- Reset the error stack when returning to the calling program
798: PA_DEBUG.Reset_Err_Stack;
799:
800: EXCEPTION
801: WHEN G_EXCEPTION_ERROR THEN
802: ROLLBACK TO copy_change_doc;
845:
846: BEGIN
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
878: commit;
879: END IF;
880:
881: -- Reset the error stack when returning to the calling program
882: PA_DEBUG.Reset_Err_Stack;
883:
884: EXCEPTION
885: WHEN G_EXCEPTION_ERROR THEN
886: ROLLBACK TO update_comments;