DBA Data[Home] [Help]

APPS.ARP_PROC_RCT_UTIL dependencies on APP_EXCEPTION

Line 601: APP_EXCEPTION.RAISE_EXCEPTION;

597: IF PG_DEBUG in ('Y', 'C') THEN
598: arp_util.debug('round_mcd_recs: ' || 'error updating ar_mc_misc_cash_dists');
599: arp_util.debug('round_mcd_recs: ' || 'SQLCODE = ' || SQLCODE || SQLERRM);
600: END IF;
601: APP_EXCEPTION.RAISE_EXCEPTION;
602: END;
603: */
604: END IF;
605:

Line 721: APP_EXCEPTION.RAISE_EXCEPTION;

717: EXCEPTION
718: WHEN OTHERS THEN
719: arp_util.debug('error deleting ar_mc_misc_cash_dists');
720: arp_util.debug('SQLCODE = ' || SQLCODE || SQLERRM);
721: APP_EXCEPTION.RAISE_EXCEPTION;
722: END;
723: */
724: -- check if receipt amount is zero. If yes, don't create any
725: -- distributions

Line 819: APP_EXCEPTION.Raise_Exception;

815: -- Fix 1341201, Added rollback
816: IF not fnd_flex_keyval.enabled_flag THEN
817: rollback;
818: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
819: APP_EXCEPTION.Raise_Exception;
820: -- Thirdly, check if the key flex is valid for this date.
821: --
822: ELSIF p_gl_date NOT between nvl(fnd_flex_keyval.start_date,p_gl_date)
823: and nvl(fnd_flex_keyval.end_date,p_gl_date) THEN

Line 826: APP_EXCEPTION.Raise_Exception;

822: ELSIF p_gl_date NOT between nvl(fnd_flex_keyval.start_date,p_gl_date)
823: and nvl(fnd_flex_keyval.end_date,p_gl_date) THEN
824: rollback;
825: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
826: APP_EXCEPTION.Raise_Exception;
827: END IF;
828: END IF;
829:
830: arp_misc_cash_dist_pkg.insert_p(l_misc_cash_dist_rec, l_dummy);

Line 1114: APP_EXCEPTION.Raise_Exception;

1110: END IF;
1111: EXCEPTION
1112: WHEN NO_DATA_FOUND THEN
1113: FND_MESSAGE.Set_Name('AR', 'AR_NO_ACTIVITY_FOUND');
1114: APP_EXCEPTION.Raise_Exception;
1115: END;
1116: --
1117: IF (l_old_trx_code_combination_id IS NOT NULL) THEN
1118: l_old_recs_auto_flag := TRUE;

Line 1151: APP_EXCEPTION.Raise_Exception;

1147: END IF;
1148: EXCEPTION
1149: WHEN NO_DATA_FOUND THEN
1150: FND_MESSAGE.Set_Name('AR', 'AR_NO_ACTIVITY_FOUND');
1151: APP_EXCEPTION.Raise_Exception;
1152: END;
1153: --
1154: IF (l_trx_code_combination_id IS NOT NULL) THEN
1155: l_new_recs_auto_flag := TRUE;

Line 1612: APP_EXCEPTION.Raise_Exception;

1608: -- Secondly, check is the key flex is enabled.
1609: --
1610: IF not fnd_flex_keyval.enabled_flag THEN
1611: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
1612: APP_EXCEPTION.Raise_Exception;
1613: -- Thirdly, check if the key flex is valid for this date.
1614: --
1615: ELSIF p_gl_date NOT between nvl(fnd_flex_keyval.start_date,p_gl_date)
1616: and nvl(fnd_flex_keyval.end_date,p_gl_date) THEN

Line 1618: APP_EXCEPTION.Raise_Exception;

1614: --
1615: ELSIF p_gl_date NOT between nvl(fnd_flex_keyval.start_date,p_gl_date)
1616: and nvl(fnd_flex_keyval.end_date,p_gl_date) THEN
1617: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
1618: APP_EXCEPTION.Raise_Exception;
1619: END IF;
1620: END IF;
1621:
1622: /* store the misc cash dist id for use in MRC call */