APPS.OE_EXPORT_COMPLIANCE_WF dependencies on APP_EXCEPTION

Line 63: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

59: where line_id = l_top_model_line_id
60: for update; --commented for bug 6415831 -- nowait;
61: END IF;
62: EXCEPTION
63: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
64: IF l_debug_level > 0 THEN
65: oe_debug_pub.add('OEXWECSB.pls: unable to lock the line:'||l_top_model_line_id,1);
66: END IF;
67: resultout := 'COMPLETE:INCOMPLETE';

Line 400: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

396:
397: Oe_debug_pub.ADD('Lock on dbi taken.');
398:
399: EXCEPTION
400: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
401: IF l_debug_level > 0 THEN
402: oe_debug_pub.add('OEXWECSB.pls: unable to lock the line', 1);
403: END IF;
404: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 469: APP_EXCEPTION.Raise_Exception;

465:
466: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
467: OE_STANDARD_WF.Save_Messages;
468: OE_STANDARD_WF.Clear_Msg_Context;
469: APP_EXCEPTION.Raise_Exception;
470: END IF;
471:
472: resultout := 'COMPLETE:OVERRIDE';
473: OE_STANDARD_WF.Save_Messages;

Line 613: APP_EXCEPTION.Raise_Exception;

609: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
610: resultout := 'COMPLETE:INCOMPLETE';
611: OE_STANDARD_WF.Save_Messages;
612: OE_STANDARD_WF.Clear_Msg_Context;
613: APP_EXCEPTION.Raise_Exception;
614: END IF;
615:
616: resultout := 'COMPLETE:SCREENING_ERROR';
617: OE_STANDARD_WF.Save_Messages;

Line 663: APP_EXCEPTION.Raise_Exception;

659: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
660: resultout := 'COMPLETE:INCOMPLETE';
661: OE_STANDARD_WF.Save_Messages;
662: OE_STANDARD_WF.Clear_Msg_Context;
663: APP_EXCEPTION.Raise_Exception;
664: END IF;
665:
666: resultout := 'COMPLETE:HOLD_APPLIED';
667: OE_STANDARD_WF.Save_Messages;

Line 712: APP_EXCEPTION.Raise_Exception;

708: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
709: resultout := 'COMPLETE:INCOMPLETE';
710: OE_STANDARD_WF.Save_Messages;
711: OE_STANDARD_WF.Clear_Msg_Context;
712: APP_EXCEPTION.Raise_Exception;
713: END IF;
714:
715: resultout := 'COMPLETE:HOLD_APPLIED';
716: OE_STANDARD_WF.Save_Messages;

Line 731: APP_EXCEPTION.Raise_Exception;

727: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
728: resultout := 'COMPLETE:INCOMPLETE';
729: OE_STANDARD_WF.Save_Messages;
730: OE_STANDARD_WF.Clear_Msg_Context;
731: APP_EXCEPTION.Raise_Exception;
732: END IF;
733:
734: resultout := 'COMPLETE:COMPLETE';
735: OE_STANDARD_WF.Save_Messages;