DBA Data[Home] [Help]

APPS.CSM_UNDO_PKG dependencies on FND_API

Line 278: x_return_status := FND_API.G_RET_STS_SUCCESS;

274: CSM_UTIL_PKG.log( g_object_name || '.APPLY_UNDO:'
275: || ' Task Assignment ID :' || l_task_assignment_id
276: || 'UNDO Failed.User Invalid',
277: g_object_name || '.APPLY_UNDO',FND_LOG.LEVEL_ERROR );
278: x_return_status := FND_API.G_RET_STS_SUCCESS;
279: RETURN;
280: END IF;
281:
282:

Line 299: x_return_status := FND_API.G_RET_STS_SUCCESS;

295: CSM_UTIL_PKG.log( g_object_name || '.APPLY_UNDO:'
296: || ' Task Assignment ID :' || l_task_assignment_id
297: || 'is no longer assigned to the user. UNDO Failed',
298: g_object_name || '.APPLY_UNDO',FND_LOG.LEVEL_ERROR );
299: x_return_status := FND_API.G_RET_STS_SUCCESS;
300: ELSE
301: --Task Assignment Markdirty
302: l_mark_dirty := asg_Download.mark_dirty (p_pub_item => 'CSM_TASK_ASSIGNMENTS',
303: p_accessid => l_access_id,

Line 676: x_return_status := FND_API.G_RET_STS_SUCCESS;

672: END IF;--Pub item
673: END LOOP;
674:
675: -- success
676: x_return_status := FND_API.G_RET_STS_SUCCESS;
677:
678: EXCEPTION WHEN OTHERS THEN
679: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UNDO:' ||g_object_name || '.APPLY_UNDO',
680: FND_LOG.LEVEL_EXCEPTION );

Line 681: x_return_status := FND_API.G_RET_STS_ERROR;

677:
678: EXCEPTION WHEN OTHERS THEN
679: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UNDO:' ||g_object_name || '.APPLY_UNDO',
680: FND_LOG.LEVEL_EXCEPTION );
681: x_return_status := FND_API.G_RET_STS_ERROR;
682: END APPLY_UNDO;
683:
684:
685:

Line 699: x_return_status := FND_API.G_RET_STS_SUCCESS;

695: l_rc BOOLEAN;
696: l_access_id NUMBER;
697: BEGIN
698: /*** initialize return status and message list ***/
699: x_return_status := FND_API.G_RET_STS_SUCCESS;
700: FND_MSG_PUB.INITIALIZE;
701:
702: CSM_UTIL_PKG.LOG('Entering CSM_UNDO_PKG.APPLY_RECORD for PK1 Value ' || p_record.PK1_VALUE ,
703: 'CSM_UNDO_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

Line 726: x_return_status := FND_API.G_RET_STS_ERROR;

722: , p_token_name1 => 'DML'
723: , p_token_value1 => p_record.dmltype$$
724: );
725:
726: x_return_status := FND_API.G_RET_STS_ERROR;
727: END IF;
728:
729: CSM_UTIL_PKG.LOG('Leaving CSM_UNDO_PKG.APPLY_RECORD for Undo Request ID ' || p_record.PK1_VALUE ,
730: 'CSM_UNDO_PKG.APPLY_RECORD',FND_LOG.LEVEL_PROCEDURE);

Line 740: x_return_status := FND_API.G_RET_STS_ERROR;

736: );
737: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_RECORD: ' || sqlerrm
738: || ' for Undo Request ID ' || p_record.PK1_VALUE ,'CSM_UNDO_PKG.APPLY_RECORD',FND_LOG.LEVEL_EXCEPTION);
739:
740: x_return_status := FND_API.G_RET_STS_ERROR;
741:
742: END APPLY_RECORD;
743:
744: /***

Line 765: x_return_status := FND_API.G_RET_STS_SUCCESS;

761: BEGIN
762: CSM_UTIL_PKG.LOG('Entering CSM_UNDO_PKG.APPLY_CLIENT_CHANGES ',
763: 'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
764: g_debug_level := p_debug_level;
765: x_return_status := FND_API.G_RET_STS_SUCCESS;
766:
767: /*** loop through all the records in inqueue ***/
768: FOR r_client_undo_rec IN c_client_undo( p_user_name, p_tranid) LOOP
769: --SAVEPOINT save_rec ;

Line 779: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN

775: , l_process_status
776: );
777:
778: /*** was record processed successfully? ***/
779: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
780: /*** Yes -> Reject record from inqueue ***/
781: CSM_UTIL_PKG.REJECT_RECORD
782: (
783: p_user_name,

Line 793: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

789: l_error_msg,
790: l_process_status
791: );
792: /*** was delete successful? ***/
793: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
794: /*** no -> rollback ***/
795: CSM_UTIL_PKG.LOG
796: ( 'Reject record failed, rolling back to savepoint'
797: || ' for PK ' || r_client_undo_rec.REQUEST_ID ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 799: x_return_status := FND_API.G_RET_STS_ERROR;

795: CSM_UTIL_PKG.LOG
796: ( 'Reject record failed, rolling back to savepoint'
797: || ' for PK ' || r_client_undo_rec.REQUEST_ID ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
798: ROLLBACK TO save_rec;
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: END IF;
801: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
802: /*** Record was not applied successfully -> defer and reject records ***/
803: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'

Line 801: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN

797: || ' for PK ' || r_client_undo_rec.REQUEST_ID ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
798: ROLLBACK TO save_rec;
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: END IF;
801: ELSIF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
802: /*** Record was not applied successfully -> defer and reject records ***/
803: csm_util_pkg.log( 'Record not processed successfully, deferring and rejecting record'
804: || ' for PK ' || r_client_undo_rec.REQUEST_ID ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
805:

Line 819: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN

815: , l_process_status
816: );
817:
818: /*** Was defer successful? ***/
819: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
820: /*** no -> rollback ***/
821: CSM_UTIL_PKG.LOG
822: ( 'Reject record failed, No rolling back to savepoint'
823: || ' for PK ' || r_client_undo_rec.REQUEST_ID ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here

Line 825: x_return_status := FND_API.G_RET_STS_ERROR;

821: CSM_UTIL_PKG.LOG
822: ( 'Reject record failed, No rolling back to savepoint'
823: || ' for PK ' || r_client_undo_rec.REQUEST_ID ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_ERROR); -- put PK column here
824: ROLLBACK TO save_rec;
825: x_return_status := FND_API.G_RET_STS_ERROR;
826: END IF;
827: END IF;
828:
829: END LOOP;

Line 839: x_return_status := FND_API.G_RET_STS_ERROR;

835: /*** catch and log exceptions ***/
836: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_CLIENT_CHANGES: ' || sqlerrm
837: ,'CSM_UNDO_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
838:
839: x_return_status := FND_API.G_RET_STS_ERROR;
840:
841: END APPLY_CLIENT_CHANGES;
842:
843: