APPS.IGS_AS_CGR_WF_PKG dependencies on FND_API

Line 83: IF l_return_status <> fnd_api.g_ret_sts_success THEN

79: WHEN NO_DATA_FOUND THEN
80: resultout := 'FAILURE';
81: RETURN;
82: END;
83: IF l_return_status <> fnd_api.g_ret_sts_success THEN
84: RAISE fnd_api.g_exc_error;
85: END IF;
86: /* ########################################################################
87: Consulting Solution : Organizations / Institutions will set their organization's hierarchy, to

Line 84: RAISE fnd_api.g_exc_error;

80: resultout := 'FAILURE';
81: RETURN;
82: END;
83: IF l_return_status <> fnd_api.g_ret_sts_success THEN
84: RAISE fnd_api.g_exc_error;
85: END IF;
86: /* ########################################################################
87: Consulting Solution : Organizations / Institutions will set their organization's hierarchy, to
88: whom this notification has to be sent .

Line 102: WHEN fnd_api.g_exc_error THEN

98: resultout := 'FAILURE';
99: RETURN;
100: END IF;
101: EXCEPTION
102: WHEN fnd_api.g_exc_error THEN
103: --If execution error, rollback all database changes, generate message text
104: --and return failure status to the WF
105: ROLLBACK TO select_approver;
106: resultout := 'FAILURE';

Line 293: IF l_return_status <> fnd_api.g_ret_sts_success THEN

289: x_release_date => NULL,
290: x_manual_override_flag => 'N',
291: x_show_on_academic_histry_flag => 'Y'
292: );
293: IF l_return_status <> fnd_api.g_ret_sts_success THEN
294: RAISE fnd_api.g_exc_error;
295: END IF;
296: /****************** Start : Repeat Process / Translation / Finalization Process ***********/
297: igs_as_finalize_grade.finalize_process (

Line 294: RAISE fnd_api.g_exc_error;

290: x_manual_override_flag => 'N',
291: x_show_on_academic_histry_flag => 'Y'
292: );
293: IF l_return_status <> fnd_api.g_ret_sts_success THEN
294: RAISE fnd_api.g_exc_error;
295: END IF;
296: /****************** Start : Repeat Process / Translation / Finalization Process ***********/
297: igs_as_finalize_grade.finalize_process (
298: l_uoo_id,

Line 318: WHEN fnd_api.g_exc_error THEN

314: resultout := 'N';
315: RETURN;
316: END IF;
317: EXCEPTION
318: WHEN fnd_api.g_exc_error THEN
319: --If execution error, rollback all database changes, generate message text
320: --and return failure status to the WF
321: ROLLBACK TO approve_request;
322: resultout := 'N';

Line 364: IF l_return_status <> fnd_api.g_ret_sts_success THEN

360: AND course_cd = l_course_cd
361: AND uoo_id = l_uoo_id
362: AND current_status = 'IN PROGRESS';
363: /**************************End : Updating Change Grade Request Table *********************/
364: IF l_return_status <> fnd_api.g_ret_sts_success THEN
365: RAISE fnd_api.g_exc_error;
366: END IF;
367: EXCEPTION
368: WHEN fnd_api.g_exc_error THEN

Line 365: RAISE fnd_api.g_exc_error;

361: AND uoo_id = l_uoo_id
362: AND current_status = 'IN PROGRESS';
363: /**************************End : Updating Change Grade Request Table *********************/
364: IF l_return_status <> fnd_api.g_ret_sts_success THEN
365: RAISE fnd_api.g_exc_error;
366: END IF;
367: EXCEPTION
368: WHEN fnd_api.g_exc_error THEN
369: --If execution error, rollback all database changes, generate message text

Line 368: WHEN fnd_api.g_exc_error THEN

364: IF l_return_status <> fnd_api.g_ret_sts_success THEN
365: RAISE fnd_api.g_exc_error;
366: END IF;
367: EXCEPTION
368: WHEN fnd_api.g_exc_error THEN
369: --If execution error, rollback all database changes, generate message text
370: --and return failure status to the WF
371: ROLLBACK TO approve_request;
372: WHEN OTHERS THEN

Line 412: IF l_return_status <> fnd_api.g_ret_sts_success THEN

408: AND course_cd = l_course_cd
409: AND uoo_id = l_uoo_id
410: AND current_status = 'IN PROGRESS';
411: /**************************End : Updating Change Grade Request Table *************************/
412: IF l_return_status <> fnd_api.g_ret_sts_success THEN
413: RAISE fnd_api.g_exc_error;
414: END IF;
415: EXCEPTION
416: WHEN fnd_api.g_exc_error THEN

Line 413: RAISE fnd_api.g_exc_error;

409: AND uoo_id = l_uoo_id
410: AND current_status = 'IN PROGRESS';
411: /**************************End : Updating Change Grade Request Table *************************/
412: IF l_return_status <> fnd_api.g_ret_sts_success THEN
413: RAISE fnd_api.g_exc_error;
414: END IF;
415: EXCEPTION
416: WHEN fnd_api.g_exc_error THEN
417: --If execution error, rollback all database changes, generate message text

Line 416: WHEN fnd_api.g_exc_error THEN

412: IF l_return_status <> fnd_api.g_ret_sts_success THEN
413: RAISE fnd_api.g_exc_error;
414: END IF;
415: EXCEPTION
416: WHEN fnd_api.g_exc_error THEN
417: --If execution error, rollback all database changes, generate message text
418: --and return failure status to the WF
419: ROLLBACK TO approve_request;
420: WHEN OTHERS THEN