DBA Data[Home] [Help]

APPS.ARP_PROCESS_APPLICATION dependencies on APP_EXCEPTION

Line 242: APP_EXCEPTION.raise_exception;

238: WHEN OTHERS
239: THEN
240: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');
241: FND_MSG_PUB.Add;
242: APP_EXCEPTION.raise_exception;
243: END;
244:
245: arp_app_pkg.fetch_p( p_ra_id, l_ra_rec );
246: --apandit Bug : 2641517

Line 271: APP_EXCEPTION.raise_exception;

267: WHEN OTHERS
268: THEN
269: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');
270: FND_MSG_PUB.Add;
271: APP_EXCEPTION.raise_exception;
272: END;
273:
274: IF NVL(p_called_from,'NONE') not in ('RISK_UNELIMINATED','BR_REMITTED',
275: 'BR_FACTORED_WITH_RECOURSE','BR_FACTORED_WITHOUT_RECOURSE','ARXRWAPP')

Line 304: APP_EXCEPTION.raise_exception;

300: TRUE, NULL, NULL );
301:
302: ELSE
303: fnd_message.set_name( 'AR', 'AR_CBK_FAIL');
304: APP_EXCEPTION.raise_exception;
305: END IF;
306:
307: --snambiar for receipt chargeback,we need to reverse the chargeback also
308: --associated with the activity application.

Line 320: APP_EXCEPTION.raise_exception;

316: NULL,
317: NULL );
318: ELSE
319: fnd_message.set_name( 'AR', 'AR_CBK_FAIL');
320: APP_EXCEPTION.raise_exception;
321: END IF;
322:
323: ELSIF (l_ra_rec.applied_payment_schedule_id in (-6 , -9 )) THEN --Bug 5532825 Added -9 for CCCB
324:

Line 337: APP_EXCEPTION.raise_exception;

333: p_reversal_comments=>l_ra_rec.comments,
334: p_called_from=>p_called_from);
335: ELSE
336: fnd_message.set_name( 'AR', 'AR_RW_CCR_REMITTED');
337: APP_EXCEPTION.raise_exception;
338: END IF;
339: END IF;
340:
341: END IF; --l_ra_rec.applied_payment_schedule_id

Line 647: APP_EXCEPTION.raise_exception;

643: WHEN OTHERS
644: THEN
645: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');
646: FND_MSG_PUB.Add;
647: APP_EXCEPTION.raise_exception;
648: END;
649:
650: arp_app_pkg.fetch_p( pn_ra_id, lr_ra_rec );
651:

Line 932: APP_EXCEPTION.INVALID_ARGUMENT(

928:
929: -- First check that all required arguments have some value
930: IF (pn_ra_id IS NULL)
931: THEN
932: APP_EXCEPTION.INVALID_ARGUMENT(
933: 'ARP_PROCESS_APPLICATION.UPDATE_SELECTED_TRANSACTION'
934: , 'PN_RA_ID'
935: , 'NULL');
936: ELSIF (pn_amount_applied IS NULL)

Line 938: APP_EXCEPTION.INVALID_ARGUMENT(

934: , 'PN_RA_ID'
935: , 'NULL');
936: ELSIF (pn_amount_applied IS NULL)
937: THEN
938: APP_EXCEPTION.INVALID_ARGUMENT(
939: 'ARP_PROCESS_APPLICATION.UPDATE_SELECTED_TRANSACTION'
940: , 'pn_amount_applied'
941: , 'NULL');
942: END IF;

Line 945: APP_EXCEPTION.INVALID_ARGUMENT(

941: , 'NULL');
942: END IF;
943:
944: IF (pc_invoice_currency_code IS NULL) THEN
945: APP_EXCEPTION.INVALID_ARGUMENT(
946: 'ARP_PROCESS_APPLICATION.UPDATE_SELECTED_TRANSACTION'
947: , 'pc_invoice_currency_code'
948: , 'NULL');
949: ELSIF (pc_invoice_currency_code <> functional_curr) AND

Line 951: APP_EXCEPTION.INVALID_ARGUMENT(

947: , 'pc_invoice_currency_code'
948: , 'NULL');
949: ELSIF (pc_invoice_currency_code <> functional_curr) AND
950: (pn_invoice_exchange_rate IS NULL) THEN
951: APP_EXCEPTION.INVALID_ARGUMENT(
952: 'ARP_PROCESS_APPLICATION.UPDATE_SELECTED_TRANSACTION'
953: , 'pn_invoice_exchange_rate'
954: , 'NULL');
955: END IF;

Line 958: APP_EXCEPTION.INVALID_ARGUMENT(

954: , 'NULL');
955: END IF;
956:
957: IF (pc_receipt_currency_code IS NULL) THEN
958: APP_EXCEPTION.INVALID_ARGUMENT(
959: 'ARP_PROCESS_APPLICATION.UPDATE_SELECTED_TRANSACTION'
960: , 'pc_receipt_currency_code'
961: , 'NULL');
962: ELSIF (pc_receipt_currency_code <> functional_curr) AND

Line 964: APP_EXCEPTION.INVALID_ARGUMENT(

960: , 'pc_receipt_currency_code'
961: , 'NULL');
962: ELSIF (pc_receipt_currency_code <> functional_curr) AND
963: (pn_receipt_exchange_rate IS NULL) THEN
964: APP_EXCEPTION.INVALID_ARGUMENT(
965: 'ARP_PROCESS_APPLICATION.UPDATE_SELECTED_TRANSACTION'
966: , 'pn_receipt_exchange_rate'
967: , 'NULL');
968: END IF;

Line 982: APP_EXCEPTION.raise_exception;

978: WHEN OTHERS
979: THEN
980: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');
981: FND_MSG_PUB.Add;
982: APP_EXCEPTION.raise_exception;
983: END;
984: arp_app_pkg.fetch_p( pn_ra_id, lr_ra_rec );
985:
986: -- Before we update the APP row, we need to calculate the change in amount

Line 1086: APP_EXCEPTION.raise_exception;

1082: WHEN OTHERS
1083: THEN
1084: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');
1085: FND_MSG_PUB.Add;
1086: APP_EXCEPTION.raise_exception;
1087: END;
1088:
1089: -- Fetch the UNAPP row.
1090: arp_app_pkg.fetch_p( ln_unapp_ra_id, lr_ra_rec );

Line 1137: app_exception.raise_exception;

1133: arp_debug.debug( '-- pc_module_name = '||pc_module_name);
1134: arp_debug.debug( '-- pc_module_version = '||pc_module_version);
1135: END IF;
1136:
1137: app_exception.raise_exception;
1138: -- RAISE;
1139: END update_selected_transaction;
1140: --
1141: /*===========================================================================+

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

1161: | NOTES |
1162: | |
1163: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1164: | 1/2/1995 Harri Kaukovuo Added more messages to point out NOCOPY where
1165: | the problems is (changed app_exception.raise
1166: | to APP_EXCEPTION.INVALID_ARGUMENT).
1167: | 2/2/1996 Harri Kaukovuo Fixed procedure to pass module name
1168: +===========================================================================*/
1169: PROCEDURE validate_args(

Line 1166: | to APP_EXCEPTION.INVALID_ARGUMENT).

1162: | |
1163: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1164: | 1/2/1995 Harri Kaukovuo Added more messages to point out NOCOPY where
1165: | the problems is (changed app_exception.raise
1166: | to APP_EXCEPTION.INVALID_ARGUMENT).
1167: | 2/2/1996 Harri Kaukovuo Fixed procedure to pass module name
1168: +===========================================================================*/
1169: PROCEDURE validate_args(
1170: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,

Line 1181: APP_EXCEPTION.INVALID_ARGUMENT(

1177: END IF;
1178:
1179: IF (p_ra_id IS NULL)
1180: THEN
1181: APP_EXCEPTION.INVALID_ARGUMENT(
1182: 'ARP_PROCESS_APPLICATION'
1183: , 'P_RA_ID'
1184: , 'NULL');
1185:

Line 1193: APP_EXCEPTION.INVALID_ARGUMENT(

1189: NULL;
1190:
1191: ELSIF (p_reversal_gl_date IS NULL)
1192: THEN
1193: APP_EXCEPTION.INVALID_ARGUMENT(
1194: 'ARP_PROCESS_APPLICATION'
1195: , 'P_REVERSAL_GL_DATE'
1196: , 'NULL');
1197:

Line 1200: APP_EXCEPTION.INVALID_ARGUMENT(

1196: , 'NULL');
1197:
1198: ELSIF (p_reversal_date IS NULL)
1199: THEN
1200: APP_EXCEPTION.INVALID_ARGUMENT(
1201: 'ARP_PROCESS_APPLICATION'
1202: , 'P_REVERSAL_DATE'
1203: , 'NULL');
1204: END IF;

Line 2734: APP_EXCEPTION.raise_exception;

2730: END IF;
2731: --
2732: IF ( p_ra_id is NULL ) THEN
2733: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
2734: APP_EXCEPTION.raise_exception;
2735: END IF;
2736: --
2737: IF PG_DEBUG in ('Y', 'C') THEN
2738: arp_debug.debug( 'arp_process_application.validate_args_appdel()-' );

Line 3113: APP_EXCEPTION.raise_exception;

3109: --
3110: IF ( p_ra_id IS NULL OR p_reversal_gl_date IS NULL OR
3111: p_select_flag IS NULL ) THEN
3112: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
3113: APP_EXCEPTION.raise_exception;
3114: END IF;
3115: --
3116: IF ( p_select_flag <> TRUE ) THEN
3117: IF ( p_cr_id IS NULL OR p_ps_id IS NULL ) THEN

Line 3119: APP_EXCEPTION.raise_exception;

3115: --
3116: IF ( p_select_flag <> TRUE ) THEN
3117: IF ( p_cr_id IS NULL OR p_ps_id IS NULL ) THEN
3118: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
3119: APP_EXCEPTION.raise_exception;
3120: END IF;
3121: END IF;
3122: --
3123: IF PG_DEBUG in ('Y', 'C') THEN

Line 3515: APP_EXCEPTION.raise_exception;

3511: when no_data_found then
3512: null;
3513: when too_many_rows then
3514: FND_MESSAGE.set_name ('AR', 'AR_RW_PAID_INVOICE_TWICE' );
3515: APP_EXCEPTION.raise_exception;
3516: END;
3517: END IF;
3518:
3519: /* Bug fix 1659928

Line 3545: APP_EXCEPTION.raise_exception;

3541: AND arp_deduction.overapplication_indicator(l_inv_orig_amount,
3542: l_inv_bal_amount,
3543: l_effective_amount_applied) ='Y' THEN
3544: FND_MESSAGE.set_name ('AR', 'AR_CKAP_OVERAPP' );
3545: APP_EXCEPTION.raise_exception;
3546: END IF;
3547:
3548: /* End bug fix 1659928 */
3549:

Line 3710: APP_EXCEPTION.raise_exception;

3706: when no_data_found then
3707: null;
3708: when claim_multi_assign then
3709: FND_MESSAGE.set_name ('AR', 'AR_RW_APP_CLAIM_MULTI_ASSIGN' );
3710: APP_EXCEPTION.raise_exception;
3711: END;
3712:
3713: END IF;
3714:

Line 4536: APP_EXCEPTION.raise_exception;

4532: p_invoice_ps_id IS NULL OR
4533: p_apply_date IS NULL OR
4534: p_gl_date IS NULL ) THEN
4535: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
4536: APP_EXCEPTION.raise_exception;
4537: END IF;
4538: --
4539: IF ( p_amount_applied IS NULL AND
4540: p_earned_discount_taken IS NULL AND

Line 4543: APP_EXCEPTION.raise_exception;

4539: IF ( p_amount_applied IS NULL AND
4540: p_earned_discount_taken IS NULL AND
4541: p_unearned_discount_taken IS NULL ) THEN
4542: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
4543: APP_EXCEPTION.raise_exception;
4544: END IF;
4545:
4546: ------------------------------------------------------------------
4547: -- Check that if the currency code of the receipt is different to

Line 4557: APP_EXCEPTION.raise_exception;

4553: AND (SIGN(p_invoice_ps_id) <> -1) AND
4554: ( p_amount_applied_from is NULL OR
4555: p_trans_to_receipt_rate is NULL ) ) THEN
4556: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
4557: APP_EXCEPTION.raise_exception;
4558: END IF;
4559:
4560:
4561: IF PG_DEBUG in ('Y', 'C') THEN

Line 4770: APP_EXCEPTION.raise_exception;

4766: when no_data_found then
4767: null;
4768: when too_many_rows then
4769: FND_MESSAGE.set_name ('AR', 'AR_RW_PAID_INVOICE_TWICE' );
4770: APP_EXCEPTION.raise_exception;
4771: END;
4772:
4773: /* Bug fix 1659928
4774: Check if the payment schedule of this transaction is over applied and

Line 4790: APP_EXCEPTION.raise_exception;

4786: AND arp_deduction.overapplication_indicator(l_inv_orig_amount,
4787: l_inv_bal_amount,
4788: l_effective_amount_applied) ='Y' THEN
4789: FND_MESSAGE.set_name ('AR', 'AR_CKAP_OVERAPP' );
4790: APP_EXCEPTION.raise_exception;
4791: END IF;
4792:
4793: /* End bug fix 1659928 */
4794:

Line 5104: APP_EXCEPTION.raise_exception;

5100: IF ( p_cm_ps_id IS NULL OR p_invoice_ps_id IS NULL OR
5101: p_apply_date IS NULL OR p_gl_date IS NULL OR
5102: p_amount_applied IS NULL ) THEN
5103: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
5104: APP_EXCEPTION.raise_exception;
5105: END IF;
5106: --
5107: IF PG_DEBUG in ('Y', 'C') THEN
5108: arp_debug.debug(

Line 5610: APP_EXCEPTION.raise_exception;

5606: --
5607: IF ( p_ps_id IS NULL OR p_apply_date IS NULL OR
5608: p_gl_date IS NULL OR p_amount_applied IS NULL ) THEN
5609: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
5610: APP_EXCEPTION.raise_exception;
5611: END IF;
5612: --
5613: IF PG_DEBUG in ('Y', 'C') THEN
5614: arp_debug.debug(

Line 6105: app_exception.raise_exception;

6101: END IF;
6102: FND_MSG_PUB.Get (FND_MSG_PUB.G_FIRST, FND_API.G_TRUE,
6103: l_msg_data, l_msg_index);
6104: FND_MESSAGE.Set_Encoded (l_msg_data);
6105: app_exception.raise_exception;
6106:
6107: WHEN OTHERS THEN
6108: IF PG_DEBUG in ('Y', 'C') THEN
6109: arp_debug.debug( 'API EXCEPTION: ' ||

Line 6599: APP_EXCEPTION.raise_exception;

6595: IF ( p_ps_id IS NULL OR p_apply_date IS NULL OR p_gl_date IS NULL OR p_amount_applied IS NULL
6596: OR p_receivables_trx_id IS NULL OR p_application_ps_id IS NULL
6597: OR (p_receivables_trx_id <> -16 AND p_application_ps_id > -1) ) THEN
6598: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
6599: APP_EXCEPTION.raise_exception;
6600: END IF;
6601: IF p_application_ps_id IN (-2) AND p_link_to_customer_trx_id IS NULL THEN
6602: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
6603: APP_EXCEPTION.raise_exception;

Line 6603: APP_EXCEPTION.raise_exception;

6599: APP_EXCEPTION.raise_exception;
6600: END IF;
6601: IF p_application_ps_id IN (-2) AND p_link_to_customer_trx_id IS NULL THEN
6602: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
6603: APP_EXCEPTION.raise_exception;
6604: END IF;
6605:
6606: IF PG_DEBUG in ('Y', 'C') THEN
6607: arp_debug.debug( 'arp_process_application.validate_activity_args()-' );

Line 6841: APP_EXCEPTION.raise_exception;

6837: OR (p_application_ps_id = (-5) and p_activity_type <> 'ADJUST' )
6838: OR (p_application_ps_id = (-8) and p_activity_type <> 'CM_REFUND' )
6839: THEN
6840: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
6841: APP_EXCEPTION.raise_exception;
6842:
6843: END IF;
6844:
6845: IF PG_DEBUG in ('Y', 'C') THEN

Line 7210: APP_EXCEPTION.raise_exception;

7206: null;
7207: WHEN too_many_rows THEN
7208: x_return_status := FND_API.G_RET_STS_ERROR;
7209: FND_MESSAGE.set_name ('AR', 'AR_RW_APP_CLAIM_MULTI_ASSIGN' );
7210: APP_EXCEPTION.raise_exception;
7211: END;
7212: END IF;
7213:
7214: -- Get the current amount that is 'on account' application for this receipt.

Line 8558: app_exception.raise_exception;

8554: END IF;
8555: FND_MSG_PUB.Get (FND_MSG_PUB.G_FIRST, FND_API.G_TRUE,
8556: l_msg_data, l_msg_index);
8557: FND_MESSAGE.Set_Encoded (l_msg_data);
8558: app_exception.raise_exception;
8559:
8560: WHEN OTHERS THEN
8561: IF PG_DEBUG in ('Y', 'C') THEN
8562: arp_debug.debug('EXCEPTION: arp_process_application.reverse_action_misc_receipt'

Line 8611: APP_EXCEPTION.raise_exception;

8607: EXCEPTION
8608: WHEN OTHERS THEN
8609: FND_MESSAGE.set_name('AR','AR_RW_INVALID_CLAIM_ID');
8610: FND_MESSAGE.set_token('CLAIM_ID',p_claim_id);
8611: APP_EXCEPTION.raise_exception;
8612: END;
8613: IF PG_DEBUG in ('Y', 'C') THEN
8614: arp_debug.debug( 'arp_process_application.get_claim_status()-' );
8615: END IF;