DBA Data[Home] [Help]

APPS.ARP_PROCESS_APPLICATION dependencies on APP_EXCEPTION

Line 237: APP_EXCEPTION.raise_exception;

233: WHEN OTHERS
234: THEN
235: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');
236: FND_MSG_PUB.Add;
237: APP_EXCEPTION.raise_exception;
238: END;
239:
240: arp_app_pkg.fetch_p( p_ra_id, l_ra_rec );
241: --apandit Bug : 2641517

Line 286: APP_EXCEPTION.raise_exception;

282: TRUE, NULL, NULL );
283:
284: ELSE
285: fnd_message.set_name( 'AR', 'AR_CBK_FAIL');
286: APP_EXCEPTION.raise_exception;
287: END IF;
288:
289: --snambiar for receipt chargeback,we need to reverse the chargeback also
290: --associated with the activity application.

Line 302: APP_EXCEPTION.raise_exception;

298: NULL,
299: NULL );
300: ELSE
301: fnd_message.set_name( 'AR', 'AR_CBK_FAIL');
302: APP_EXCEPTION.raise_exception;
303: END IF;
304:
305: ELSIF (l_ra_rec.applied_payment_schedule_id in (-6 , -9 )) THEN --Bug 5532825 Added -9 for CCCB
306:

Line 319: APP_EXCEPTION.raise_exception;

315: p_reversal_comments=>l_ra_rec.comments,
316: p_called_from=>p_called_from);
317: ELSE
318: fnd_message.set_name( 'AR', 'AR_RW_CCR_REMITTED');
319: APP_EXCEPTION.raise_exception;
320: END IF;
321: END IF;
322:
323: END IF; --l_ra_rec.applied_payment_schedule_id

Line 616: APP_EXCEPTION.raise_exception;

612: WHEN OTHERS
613: THEN
614: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');
615: FND_MSG_PUB.Add;
616: APP_EXCEPTION.raise_exception;
617: END;
618:
619: arp_app_pkg.fetch_p( pn_ra_id, lr_ra_rec );
620:

Line 895: APP_EXCEPTION.INVALID_ARGUMENT(

891:
892: -- First check that all required arguments have some value
893: IF (pn_ra_id IS NULL)
894: THEN
895: APP_EXCEPTION.INVALID_ARGUMENT(
896: 'ARP_PROCESS_APPLICATION.UPDATE_SELECTED_TRANSACTION'
897: , 'PN_RA_ID'
898: , 'NULL');
899: ELSIF (pn_amount_applied IS NULL)

Line 901: APP_EXCEPTION.INVALID_ARGUMENT(

897: , 'PN_RA_ID'
898: , 'NULL');
899: ELSIF (pn_amount_applied IS NULL)
900: THEN
901: APP_EXCEPTION.INVALID_ARGUMENT(
902: 'ARP_PROCESS_APPLICATION.UPDATE_SELECTED_TRANSACTION'
903: , 'pn_amount_applied'
904: , 'NULL');
905: END IF;

Line 908: APP_EXCEPTION.INVALID_ARGUMENT(

904: , 'NULL');
905: END IF;
906:
907: IF (pc_invoice_currency_code IS NULL) THEN
908: APP_EXCEPTION.INVALID_ARGUMENT(
909: 'ARP_PROCESS_APPLICATION.UPDATE_SELECTED_TRANSACTION'
910: , 'pc_invoice_currency_code'
911: , 'NULL');
912: ELSIF (pc_invoice_currency_code <> functional_curr) AND

Line 914: APP_EXCEPTION.INVALID_ARGUMENT(

910: , 'pc_invoice_currency_code'
911: , 'NULL');
912: ELSIF (pc_invoice_currency_code <> functional_curr) AND
913: (pn_invoice_exchange_rate IS NULL) THEN
914: APP_EXCEPTION.INVALID_ARGUMENT(
915: 'ARP_PROCESS_APPLICATION.UPDATE_SELECTED_TRANSACTION'
916: , 'pn_invoice_exchange_rate'
917: , 'NULL');
918: END IF;

Line 921: APP_EXCEPTION.INVALID_ARGUMENT(

917: , 'NULL');
918: END IF;
919:
920: IF (pc_receipt_currency_code IS NULL) THEN
921: APP_EXCEPTION.INVALID_ARGUMENT(
922: 'ARP_PROCESS_APPLICATION.UPDATE_SELECTED_TRANSACTION'
923: , 'pc_receipt_currency_code'
924: , 'NULL');
925: ELSIF (pc_receipt_currency_code <> functional_curr) AND

Line 927: APP_EXCEPTION.INVALID_ARGUMENT(

923: , 'pc_receipt_currency_code'
924: , 'NULL');
925: ELSIF (pc_receipt_currency_code <> functional_curr) AND
926: (pn_receipt_exchange_rate IS NULL) THEN
927: APP_EXCEPTION.INVALID_ARGUMENT(
928: 'ARP_PROCESS_APPLICATION.UPDATE_SELECTED_TRANSACTION'
929: , 'pn_receipt_exchange_rate'
930: , 'NULL');
931: END IF;

Line 945: APP_EXCEPTION.raise_exception;

941: WHEN OTHERS
942: THEN
943: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');
944: FND_MSG_PUB.Add;
945: APP_EXCEPTION.raise_exception;
946: END;
947: arp_app_pkg.fetch_p( pn_ra_id, lr_ra_rec );
948:
949: -- Before we update the APP row, we need to calculate the change in amount

Line 1049: APP_EXCEPTION.raise_exception;

1045: WHEN OTHERS
1046: THEN
1047: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');
1048: FND_MSG_PUB.Add;
1049: APP_EXCEPTION.raise_exception;
1050: END;
1051:
1052: -- Fetch the UNAPP row.
1053: arp_app_pkg.fetch_p( ln_unapp_ra_id, lr_ra_rec );

Line 1100: app_exception.raise_exception;

1096: arp_standard.debug('update_selected_transaction: ' || '-- pc_module_name = '||pc_module_name);
1097: arp_standard.debug('update_selected_transaction: ' || '-- pc_module_version = '||pc_module_version);
1098: END IF;
1099:
1100: app_exception.raise_exception;
1101: -- RAISE;
1102: END update_selected_transaction;
1103: --
1104: /*===========================================================================+

Line 1128: | the problems is (changed app_exception.raise

1124: | NOTES |
1125: | |
1126: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1127: | 1/2/1995 Harri Kaukovuo Added more messages to point out NOCOPY where
1128: | the problems is (changed app_exception.raise
1129: | to APP_EXCEPTION.INVALID_ARGUMENT).
1130: | 2/2/1996 Harri Kaukovuo Fixed procedure to pass module name
1131: +===========================================================================*/
1132: PROCEDURE validate_args(

Line 1129: | to APP_EXCEPTION.INVALID_ARGUMENT).

1125: | |
1126: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1127: | 1/2/1995 Harri Kaukovuo Added more messages to point out NOCOPY where
1128: | the problems is (changed app_exception.raise
1129: | to APP_EXCEPTION.INVALID_ARGUMENT).
1130: | 2/2/1996 Harri Kaukovuo Fixed procedure to pass module name
1131: +===========================================================================*/
1132: PROCEDURE validate_args(
1133: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,

Line 1144: APP_EXCEPTION.INVALID_ARGUMENT(

1140: END IF;
1141:
1142: IF (p_ra_id IS NULL)
1143: THEN
1144: APP_EXCEPTION.INVALID_ARGUMENT(
1145: 'ARP_PROCESS_APPLICATION'
1146: , 'P_RA_ID'
1147: , 'NULL');
1148:

Line 1156: APP_EXCEPTION.INVALID_ARGUMENT(

1152: NULL;
1153:
1154: ELSIF (p_reversal_gl_date IS NULL)
1155: THEN
1156: APP_EXCEPTION.INVALID_ARGUMENT(
1157: 'ARP_PROCESS_APPLICATION'
1158: , 'P_REVERSAL_GL_DATE'
1159: , 'NULL');
1160:

Line 1163: APP_EXCEPTION.INVALID_ARGUMENT(

1159: , 'NULL');
1160:
1161: ELSIF (p_reversal_date IS NULL)
1162: THEN
1163: APP_EXCEPTION.INVALID_ARGUMENT(
1164: 'ARP_PROCESS_APPLICATION'
1165: , 'P_REVERSAL_DATE'
1166: , 'NULL');
1167: END IF;

Line 2639: APP_EXCEPTION.raise_exception;

2635: END IF;
2636: --
2637: IF ( p_ra_id is NULL ) THEN
2638: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
2639: APP_EXCEPTION.raise_exception;
2640: END IF;
2641: --
2642: IF PG_DEBUG in ('Y', 'C') THEN
2643: arp_standard.debug( 'arp_process_application.validate_args_appdel()-' );

Line 3009: APP_EXCEPTION.raise_exception;

3005: --
3006: IF ( p_ra_id IS NULL OR p_reversal_gl_date IS NULL OR
3007: p_select_flag IS NULL ) THEN
3008: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
3009: APP_EXCEPTION.raise_exception;
3010: END IF;
3011: --
3012: IF ( p_select_flag <> TRUE ) THEN
3013: IF ( p_cr_id IS NULL OR p_ps_id IS NULL ) THEN

Line 3015: APP_EXCEPTION.raise_exception;

3011: --
3012: IF ( p_select_flag <> TRUE ) THEN
3013: IF ( p_cr_id IS NULL OR p_ps_id IS NULL ) THEN
3014: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
3015: APP_EXCEPTION.raise_exception;
3016: END IF;
3017: END IF;
3018: --
3019: IF PG_DEBUG in ('Y', 'C') THEN

Line 3397: APP_EXCEPTION.raise_exception;

3393: when no_data_found then
3394: null;
3395: when too_many_rows then
3396: FND_MESSAGE.set_name ('AR', 'AR_RW_PAID_INVOICE_TWICE' );
3397: APP_EXCEPTION.raise_exception;
3398: END;
3399:
3400: /* Bug fix 1659928
3401: Check if the payment schedule of this transaction is over applied and

Line 3418: APP_EXCEPTION.raise_exception;

3414: AND arp_deduction.overapplication_indicator(l_inv_orig_amount,
3415: l_inv_bal_amount,
3416: l_effective_amount_applied) ='Y' THEN
3417: FND_MESSAGE.set_name ('AR', 'AR_CKAP_OVERAPP' );
3418: APP_EXCEPTION.raise_exception;
3419: END IF;
3420:
3421: /* End bug fix 1659928 */
3422:

Line 3527: APP_EXCEPTION.raise_exception;

3523: when no_data_found then
3524: null;
3525: when claim_multi_assign then
3526: FND_MESSAGE.set_name ('AR', 'AR_RW_APP_CLAIM_MULTI_ASSIGN' );
3527: APP_EXCEPTION.raise_exception;
3528: END;
3529:
3530: END IF;
3531: -- Step 1, update the cash receipt in the payment schedule table.

Line 4245: APP_EXCEPTION.raise_exception;

4241: p_invoice_ps_id IS NULL OR
4242: p_apply_date IS NULL OR
4243: p_gl_date IS NULL ) THEN
4244: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
4245: APP_EXCEPTION.raise_exception;
4246: END IF;
4247: --
4248: IF ( p_amount_applied IS NULL AND
4249: p_earned_discount_taken IS NULL AND

Line 4252: APP_EXCEPTION.raise_exception;

4248: IF ( p_amount_applied IS NULL AND
4249: p_earned_discount_taken IS NULL AND
4250: p_unearned_discount_taken IS NULL ) THEN
4251: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
4252: APP_EXCEPTION.raise_exception;
4253: END IF;
4254:
4255: ------------------------------------------------------------------
4256: -- Check that if the currency code of the receipt is different to

Line 4266: APP_EXCEPTION.raise_exception;

4262: AND (SIGN(p_invoice_ps_id) <> -1) AND
4263: ( p_amount_applied_from is NULL OR
4264: p_trans_to_receipt_rate is NULL ) ) THEN
4265: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
4266: APP_EXCEPTION.raise_exception;
4267: END IF;
4268:
4269:
4270: IF PG_DEBUG in ('Y', 'C') THEN

Line 4472: APP_EXCEPTION.raise_exception;

4468: when no_data_found then
4469: null;
4470: when too_many_rows then
4471: FND_MESSAGE.set_name ('AR', 'AR_RW_PAID_INVOICE_TWICE' );
4472: APP_EXCEPTION.raise_exception;
4473: END;
4474:
4475: /* Bug fix 1659928
4476: Check if the payment schedule of this transaction is over applied and

Line 4492: APP_EXCEPTION.raise_exception;

4488: AND arp_deduction.overapplication_indicator(l_inv_orig_amount,
4489: l_inv_bal_amount,
4490: l_effective_amount_applied) ='Y' THEN
4491: FND_MESSAGE.set_name ('AR', 'AR_CKAP_OVERAPP' );
4492: APP_EXCEPTION.raise_exception;
4493: END IF;
4494:
4495: /* End bug fix 1659928 */
4496:

Line 4764: APP_EXCEPTION.raise_exception;

4760: IF ( p_cm_ps_id IS NULL OR p_invoice_ps_id IS NULL OR
4761: p_apply_date IS NULL OR p_gl_date IS NULL OR
4762: p_amount_applied IS NULL ) THEN
4763: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
4764: APP_EXCEPTION.raise_exception;
4765: END IF;
4766: --
4767: IF PG_DEBUG in ('Y', 'C') THEN
4768: arp_standard.debug(

Line 5262: APP_EXCEPTION.raise_exception;

5258: --
5259: IF ( p_ps_id IS NULL OR p_apply_date IS NULL OR
5260: p_gl_date IS NULL OR p_amount_applied IS NULL ) THEN
5261: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
5262: APP_EXCEPTION.raise_exception;
5263: END IF;
5264: --
5265: IF PG_DEBUG in ('Y', 'C') THEN
5266: arp_standard.debug(

Line 5754: app_exception.raise_exception;

5750: END IF;
5751: FND_MSG_PUB.Get (FND_MSG_PUB.G_FIRST, FND_API.G_TRUE,
5752: l_msg_data, l_msg_index);
5753: FND_MESSAGE.Set_Encoded (l_msg_data);
5754: app_exception.raise_exception;
5755:
5756: WHEN OTHERS THEN
5757: IF PG_DEBUG in ('Y', 'C') THEN
5758: arp_util.debug( 'API EXCEPTION: ' ||

Line 6247: APP_EXCEPTION.raise_exception;

6243: IF ( p_ps_id IS NULL OR p_apply_date IS NULL OR p_gl_date IS NULL OR p_amount_applied IS NULL
6244: OR p_receivables_trx_id IS NULL OR p_application_ps_id IS NULL
6245: OR (p_receivables_trx_id <> -16 AND p_application_ps_id > -1) ) THEN
6246: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
6247: APP_EXCEPTION.raise_exception;
6248: END IF;
6249: IF p_application_ps_id IN (-2) AND p_link_to_customer_trx_id IS NULL THEN
6250: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
6251: APP_EXCEPTION.raise_exception;

Line 6251: APP_EXCEPTION.raise_exception;

6247: APP_EXCEPTION.raise_exception;
6248: END IF;
6249: IF p_application_ps_id IN (-2) AND p_link_to_customer_trx_id IS NULL THEN
6250: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
6251: APP_EXCEPTION.raise_exception;
6252: END IF;
6253:
6254: IF PG_DEBUG in ('Y', 'C') THEN
6255: arp_standard.debug( 'arp_process_application.validate_activity_args()-' );

Line 6489: APP_EXCEPTION.raise_exception;

6485: OR (p_application_ps_id = (-5) and p_activity_type <> 'ADJUST' )
6486: OR (p_application_ps_id = (-8) and p_activity_type <> 'CM_REFUND' )
6487: THEN
6488: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
6489: APP_EXCEPTION.raise_exception;
6490:
6491: END IF;
6492:
6493: IF PG_DEBUG in ('Y', 'C') THEN

Line 6858: APP_EXCEPTION.raise_exception;

6854: null;
6855: WHEN too_many_rows THEN
6856: x_return_status := FND_API.G_RET_STS_ERROR;
6857: FND_MESSAGE.set_name ('AR', 'AR_RW_APP_CLAIM_MULTI_ASSIGN' );
6858: APP_EXCEPTION.raise_exception;
6859: END;
6860: END IF;
6861:
6862: -- Get the current amount that is 'on account' application for this receipt.

Line 8091: app_exception.raise_exception;

8087: END IF;
8088: FND_MSG_PUB.Get (FND_MSG_PUB.G_FIRST, FND_API.G_TRUE,
8089: l_msg_data, l_msg_index);
8090: FND_MESSAGE.Set_Encoded (l_msg_data);
8091: app_exception.raise_exception;
8092:
8093: WHEN OTHERS THEN
8094: IF PG_DEBUG in ('Y', 'C') THEN
8095: arp_util.debug('EXCEPTION: arp_process_application.reverse_action_misc_receipt'

Line 8144: APP_EXCEPTION.raise_exception;

8140: EXCEPTION
8141: WHEN OTHERS THEN
8142: FND_MESSAGE.set_name('AR','AR_RW_INVALID_CLAIM_ID');
8143: FND_MESSAGE.set_token('CLAIM_ID',p_claim_id);
8144: APP_EXCEPTION.raise_exception;
8145: END;
8146: IF PG_DEBUG in ('Y', 'C') THEN
8147: arp_standard.debug( 'arp_process_application.get_claim_status()-' );
8148: END IF;