DBA Data[Home] [Help]

APPS.ARP_PROC_RCT_UTIL dependencies on APP_EXCEPTION

Line 616: APP_EXCEPTION.RAISE_EXCEPTION;

612: IF PG_DEBUG in ('Y', 'C') THEN
613: arp_util.debug('round_mcd_recs: ' || 'error updating ar_mc_misc_cash_dists');
614: arp_util.debug('round_mcd_recs: ' || 'SQLCODE = ' || SQLCODE || SQLERRM);
615: END IF;
616: APP_EXCEPTION.RAISE_EXCEPTION;
617: END;
618: */
619: END IF;
620:

Line 736: APP_EXCEPTION.RAISE_EXCEPTION;

732: EXCEPTION
733: WHEN OTHERS THEN
734: arp_util.debug('error deleting ar_mc_misc_cash_dists');
735: arp_util.debug('SQLCODE = ' || SQLCODE || SQLERRM);
736: APP_EXCEPTION.RAISE_EXCEPTION;
737: END;
738: */
739: -- check if receipt amount is zero. If yes, don't create any
740: -- distributions

Line 834: APP_EXCEPTION.Raise_Exception;

830: -- Fix 1341201, Added rollback
831: IF not fnd_flex_keyval.enabled_flag THEN
832: rollback;
833: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
834: APP_EXCEPTION.Raise_Exception;
835: -- Thirdly, check if the key flex is valid for this date.
836: --
837: ELSIF p_gl_date NOT between nvl(fnd_flex_keyval.start_date,p_gl_date)
838: and nvl(fnd_flex_keyval.end_date,p_gl_date) THEN

Line 841: APP_EXCEPTION.Raise_Exception;

837: ELSIF p_gl_date NOT between nvl(fnd_flex_keyval.start_date,p_gl_date)
838: and nvl(fnd_flex_keyval.end_date,p_gl_date) THEN
839: rollback;
840: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
841: APP_EXCEPTION.Raise_Exception;
842: END IF;
843: END IF;
844:
845: arp_misc_cash_dist_pkg.insert_p(l_misc_cash_dist_rec, l_dummy);

Line 1129: APP_EXCEPTION.Raise_Exception;

1125: END IF;
1126: EXCEPTION
1127: WHEN NO_DATA_FOUND THEN
1128: FND_MESSAGE.Set_Name('AR', 'AR_NO_ACTIVITY_FOUND');
1129: APP_EXCEPTION.Raise_Exception;
1130: END;
1131: --
1132: IF (l_old_trx_code_combination_id IS NOT NULL) THEN
1133: l_old_recs_auto_flag := TRUE;

Line 1166: APP_EXCEPTION.Raise_Exception;

1162: END IF;
1163: EXCEPTION
1164: WHEN NO_DATA_FOUND THEN
1165: FND_MESSAGE.Set_Name('AR', 'AR_NO_ACTIVITY_FOUND');
1166: APP_EXCEPTION.Raise_Exception;
1167: END;
1168: --
1169: IF (l_trx_code_combination_id IS NOT NULL) THEN
1170: l_new_recs_auto_flag := TRUE;

Line 1627: APP_EXCEPTION.Raise_Exception;

1623: -- Secondly, check is the key flex is enabled.
1624: --
1625: IF not fnd_flex_keyval.enabled_flag THEN
1626: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
1627: APP_EXCEPTION.Raise_Exception;
1628: -- Thirdly, check if the key flex is valid for this date.
1629: --
1630: ELSIF p_gl_date NOT between nvl(fnd_flex_keyval.start_date,p_gl_date)
1631: and nvl(fnd_flex_keyval.end_date,p_gl_date) THEN

Line 1633: APP_EXCEPTION.Raise_Exception;

1629: --
1630: ELSIF p_gl_date NOT between nvl(fnd_flex_keyval.start_date,p_gl_date)
1631: and nvl(fnd_flex_keyval.end_date,p_gl_date) THEN
1632: FND_MESSAGE.Set_Name('AR', 'AR_GL_ACCOUNT_INVALID');
1633: APP_EXCEPTION.Raise_Exception;
1634: END IF;
1635: END IF;
1636:
1637: /* store the misc cash dist id for use in MRC call */