143: IF PG_DEBUG in ('Y', 'C') THEN
144: arp_standard.debug('ARP_BALANCE_CHK.Check_Transaction_Balance - OUT_OF_BALANCE');
145: END IF;
146: fnd_message.set_name('AR','AR_AMOUNTS_NO_MATCH');
147: app_exception.raise_exception;
148: WHEN NO_DATA_FOUND THEN
149: /* Case for invoice with rules */
150: IF PG_DEBUG in ('Y', 'C') THEN
151: arp_standard.debug( 'ARP_BALANCE_CHK.Check_Transaction_Balance - NO_DATA_FOUND' );
360: END IF;
361:
362: fnd_message.set_token ( token => 'GENERIC_TEXT',
363: value => 'The Value Is Incorrect for '||l_corruption_string ||' .Please Contact Oracle Support');
364: app_exception.raise_exception;
365: END;
366: END IF;
367:
368: IF PG_DEBUG in ('Y', 'C') THEN
384: else
385: fnd_message.set_name('AR','AR_AMOUNTS_NO_MATCH');
386: end if;
387:
388: app_exception.raise_exception;
389:
390: WHEN ps_data_corrupted THEN
391: app_exception.raise_exception;
392:
387:
388: app_exception.raise_exception;
389:
390: WHEN ps_data_corrupted THEN
391: app_exception.raise_exception;
392:
393: WHEN OTHERS THEN
394: IF PG_DEBUG in ('Y', 'C') THEN
395: arp_standard.debug('ARP_BALANCE_CHK.CHECK_RECP_BALANCE - OTHERS');
672: END IF;
673:
674: fnd_message.set_token ( token => 'GENERIC_TEXT',
675: value => 'The Value Is Incorrect for '||l_corruption_string ||' .Please Contact Oracle Support');
676: app_exception.raise_exception;
677: END;
678: END IF;
679:
680: IF PG_DEBUG in ('Y', 'C') THEN
706: else
707: fnd_message.set_name('AR','AR_AMOUNTS_NO_MATCH');
708: end if;
709:
710: app_exception.raise_exception;
711:
712: WHEN amount_mismatch THEN
713: IF PG_DEBUG in ('Y', 'C') THEN
714: arp_standard.debug('ARP_BALANCE_CHK.CHECK_ADJ_BALANCE -AMOUNT_MISMATCH');
716: arp_standard.debug('Amount = '||l_amount);
717: arp_standard.debug('Sum of Buckets = '||l_calc_amount);
718: END IF;
719: fnd_message.set_name('AR','AR_ADJ_AMT_NO_MATCH');
720: app_exception.raise_exception;
721:
722: WHEN ps_data_corrupted THEN
723: app_exception.raise_exception;
724:
719: fnd_message.set_name('AR','AR_ADJ_AMT_NO_MATCH');
720: app_exception.raise_exception;
721:
722: WHEN ps_data_corrupted THEN
723: app_exception.raise_exception;
724:
725: WHEN OTHERS THEN
726: IF PG_DEBUG in ('Y', 'C') THEN
727: arp_standard.debug('ARP_BALANCE_CHK.CHECK_RECP_BALANCE - OTHERS');
869: END IF;
870:
871: fnd_message.set_token ( token => 'GENERIC_TEXT',
872: value => 'The Value Is Incorrect for '||l_corruption_string ||' .Please Contact Oracle Support');
873: app_exception.raise_exception;
874: END;
875: ELSE
876: ARP_BALANCE_CHECK.P_reg_cm := 'N';
877: END IF;
906: else
907: fnd_message.set_name('AR','AR_AMOUNTS_NO_MATCH');
908: end if;
909:
910: app_exception.raise_exception;
911:
912:
913: WHEN OTHERS THEN
914: IF PG_DEBUG in ('Y', 'C') THEN
1032: else
1033: fnd_message.set_name('AR','AR_AMOUNTS_NO_MATCH');
1034: end if;
1035:
1036: app_exception.raise_exception;
1037:
1038: WHEN OTHERS THEN
1039: IF PG_DEBUG in ('Y', 'C') THEN
1040: arp_standard.debug('ARP_BALANCE_CHK.CHECK_APPLN_BALANCE - OTHERS -> for Receipt Applications');
1374: IF PG_DEBUG in ('Y', 'C') THEN
1375: arp_standard.debug('ARP_BALANCE_CHK.Check_Line_Level_Transaction_Balance - OUT_OF_BALANCE');
1376: END IF;
1377: fnd_message.set_name('AR','AR_AMOUNTS_NO_MATCH');
1378: app_exception.raise_exception;
1379: WHEN NO_DATA_FOUND THEN
1380: /* Case for invoice with rules */
1381: IF PG_DEBUG in ('Y', 'C') THEN
1382: arp_standard.debug( 'ARP_BALANCE_CHK.Check_Line_Level_Transaction_Balance - NO_DATA_FOUND' );