APPS.ARP_ARXVASUM dependencies on ARP_ARXVASUM

Line 1: PACKAGE BODY ARP_ARXVASUM AS

1: PACKAGE BODY ARP_ARXVASUM AS
2: /* $Header: ARCESUMB.pls 120.5 2005/10/30 04:14:10 appldev ship $ */
3:
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5:

Line 1096: arp_standard.debug( 'ARP_ARXVASUM.get_protested_BR()+ ');

1092: p_min_acc_unit IN NUMBER,
1093: p_status IN ar_payment_schedules.status%TYPE) IS
1094: BEGIN
1095: IF PG_DEBUG in ('Y', 'C') THEN
1096: arp_standard.debug( 'ARP_ARXVASUM.get_protested_BR()+ ');
1097: END IF;
1098:
1099: select decode(p_currency_code,
1100: NULL , NULL , nvl(sum(ps.amount_due_remaining),0)

Line 1127: arp_standard.debug( 'ARP_ARXVASUM.get_protested_BR()- ');

1123: AND ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)
1124: AND ps.status = nvl(p_status, ps.status);
1125:
1126: IF PG_DEBUG in ('Y', 'C') THEN
1127: arp_standard.debug( 'ARP_ARXVASUM.get_protested_BR()- ');
1128: END IF;
1129:
1130: EXCEPTION
1131: WHEN OTHERS THEN

Line 1133: arp_standard.debug( 'Exception: ARP_ARXVASUM.get_protested_BR ');

1129:
1130: EXCEPTION
1131: WHEN OTHERS THEN
1132: IF PG_DEBUG in ('Y', 'C') THEN
1133: arp_standard.debug( 'Exception: ARP_ARXVASUM.get_protested_BR ');
1134: END IF;
1135: RAISE;
1136:
1137: END get_protested_BR;

Line 1155: arp_standard.debug( 'ARP_ARXVASUM.get_unpaid_BR()+ ');

1151: p_status IN ar_payment_schedules.status%TYPE) IS
1152: BEGIN
1153:
1154: IF PG_DEBUG in ('Y', 'C') THEN
1155: arp_standard.debug( 'ARP_ARXVASUM.get_unpaid_BR()+ ');
1156: END IF;
1157:
1158: select decode(p_currency_code,
1159: NULL , NULL , nvl(sum(ps.amount_due_remaining),0)

Line 1186: arp_standard.debug( 'ARP_ARXVASUM.get_unpaid_BR()- ');

1182: AND ps.invoice_currency_code = nvl(p_currency_code, ps.invoice_currency_code)
1183: AND ps.status = nvl(p_status, ps.status);
1184:
1185: IF PG_DEBUG in ('Y', 'C') THEN
1186: arp_standard.debug( 'ARP_ARXVASUM.get_unpaid_BR()- ');
1187: END IF;
1188:
1189: EXCEPTION
1190: WHEN OTHERS THEN

Line 1192: arp_standard.debug( 'Exception: ARP_ARXVASUM.get_unpaid_BR');

1188:
1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: IF PG_DEBUG in ('Y', 'C') THEN
1192: arp_standard.debug( 'Exception: ARP_ARXVASUM.get_unpaid_BR');
1193: END IF;
1194: RAISE;
1195:
1196: END get_unpaid_BR;

Line 1213: arp_standard.debug( 'ARP_ARXVASUM.get_pend_acceptance_BR()+ ');

1209: p_min_acc_unit IN NUMBER) IS
1210: BEGIN
1211:
1212: IF PG_DEBUG in ('Y', 'C') THEN
1213: arp_standard.debug( 'ARP_ARXVASUM.get_pend_acceptance_BR()+ ');
1214: END IF;
1215:
1216: select decode(p_currency_code,
1217: NULL , NULL , nvl(sum(ctl.extended_amount),0)

Line 1245: arp_standard.debug( 'ARP_ARXVASUM.get_pend_acceptance_BR()- ');

1241: and nvl(ct.drawee_site_use_id, -10) = nvl(p_site_use_id, nvl(ct.drawee_site_use_id, -10) )
1242: and ctl.customer_trx_id = ct.customer_trx_id;
1243:
1244: IF PG_DEBUG in ('Y', 'C') THEN
1245: arp_standard.debug( 'ARP_ARXVASUM.get_pend_acceptance_BR()- ');
1246: END IF;
1247:
1248: EXCEPTION
1249: WHEN OTHERS THEN

Line 1251: arp_standard.debug( 'Exception: ARP_ARXVASUM.get_pend_acceptance_BR ');

1247:
1248: EXCEPTION
1249: WHEN OTHERS THEN
1250: IF PG_DEBUG in ('Y', 'C') THEN
1251: arp_standard.debug( 'Exception: ARP_ARXVASUM.get_pend_acceptance_BR ');
1252: END IF;
1253: RAISE;
1254:
1255: END get_pend_acceptance_BR;