DBA Data[Home] [Help]

APPS.ARP_PROCESS_APPLICATION dependencies on FND_MESSAGE

Line 240: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');

236: arp_app_pkg.lock_p( p_ra_id );
237: 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:

Line 269: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');

265: END IF;
266: 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:

Line 303: fnd_message.set_name( 'AR', 'AR_CBK_FAIL');

299: p_reversal_gl_date, p_reversal_date,
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

Line 319: fnd_message.set_name( 'AR', 'AR_CBK_FAIL');

315: p_reversal_date,
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

Line 336: fnd_message.set_name( 'AR', 'AR_RW_CCR_REMITTED');

332: p_reversal_date=>p_reversal_gl_date,
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:

Line 645: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');

641: arp_app_pkg.lock_p( pn_ra_id );
642: 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:

Line 980: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');

976: arp_app_pkg.lock_p( pn_ra_id );
977: 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 );

Line 1084: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');

1080: arp_app_pkg.lock_p( ln_unapp_ra_id );
1081: 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:

Line 2733: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

2729: arp_debug.debug( 'arp_process_application.validate_args_appdel()+' );
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

Line 3112: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

3108: END IF;
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

Line 3118: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

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
3118: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
3119: APP_EXCEPTION.raise_exception;
3120: END IF;
3121: END IF;
3122: --

Line 3514: FND_MESSAGE.set_name ('AR', 'AR_RW_PAID_INVOICE_TWICE' );

3510: 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:

Line 3544: FND_MESSAGE.set_name ('AR', 'AR_CKAP_OVERAPP' );

3540: IF l_allow_over_application ='N'
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 */

Line 3709: FND_MESSAGE.set_name ('AR', 'AR_RW_APP_CLAIM_MULTI_ASSIGN' );

3705: 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;

Line 4535: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

4531: IF ( p_receipt_ps_id IS NULL OR
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

Line 4542: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

4538: --
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: ------------------------------------------------------------------

Line 4556: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

4552: IF ( p_receipt_currency_code <> p_invoice_currency_code
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:

Line 4769: FND_MESSAGE.set_name ('AR', 'AR_RW_PAID_INVOICE_TWICE' );

4765: 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

Line 4789: FND_MESSAGE.set_name ('AR', 'AR_CKAP_OVERAPP' );

4785: IF l_allow_over_application ='N'
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 */

Line 5103: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

5099: --
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

Line 5609: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

5605: END IF;
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

Line 6104: FND_MESSAGE.Set_Encoded (l_msg_data);

6100: ||SQLERRM);
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

Line 6598: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

6594:
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' );

Line 6602: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

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;
6604: END IF;
6605:
6606: IF PG_DEBUG in ('Y', 'C') THEN

Line 6840: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

6836: OR (p_application_ps_id = (-6) and p_activity_type <> 'CCREFUND' )
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:

Line 7209: FND_MESSAGE.set_name ('AR', 'AR_RW_APP_CLAIM_MULTI_ASSIGN' );

7205: WHEN no_data_found THEN
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:

Line 8108: fnd_message.set_name('AR', 'AR_RW_APP_TRX_CLAIM_NOTE');

8104: END IF;
8105: --Bug 1812334 : ar_notes entry needs to be created also when the claim is cancelled.
8106:
8107: IF p_flag = 'CREATE' THEN
8108: fnd_message.set_name('AR', 'AR_RW_APP_TRX_CLAIM_NOTE');
8109: fnd_message.set_token('RECEIPT_NUM',p_receipt_number);
8110: fnd_message.set_token('CLAIM_NUM',p_claim_number);
8111: ELSIF p_flag = 'CANCEL' THEN
8112: fnd_message.set_name('AR', 'AR_RW_APP_TRX_CLAIM_CANCL_NOTE');

Line 8109: fnd_message.set_token('RECEIPT_NUM',p_receipt_number);

8105: --Bug 1812334 : ar_notes entry needs to be created also when the claim is cancelled.
8106:
8107: IF p_flag = 'CREATE' THEN
8108: fnd_message.set_name('AR', 'AR_RW_APP_TRX_CLAIM_NOTE');
8109: fnd_message.set_token('RECEIPT_NUM',p_receipt_number);
8110: fnd_message.set_token('CLAIM_NUM',p_claim_number);
8111: ELSIF p_flag = 'CANCEL' THEN
8112: fnd_message.set_name('AR', 'AR_RW_APP_TRX_CLAIM_CANCL_NOTE');
8113: fnd_message.set_token('CLAIM_NUM',p_claim_number);

Line 8110: fnd_message.set_token('CLAIM_NUM',p_claim_number);

8106:
8107: IF p_flag = 'CREATE' THEN
8108: fnd_message.set_name('AR', 'AR_RW_APP_TRX_CLAIM_NOTE');
8109: fnd_message.set_token('RECEIPT_NUM',p_receipt_number);
8110: fnd_message.set_token('CLAIM_NUM',p_claim_number);
8111: ELSIF p_flag = 'CANCEL' THEN
8112: fnd_message.set_name('AR', 'AR_RW_APP_TRX_CLAIM_CANCL_NOTE');
8113: fnd_message.set_token('CLAIM_NUM',p_claim_number);
8114: ELSIF p_flag = 'CLOSE' THEN --Add for bug 13464283

Line 8112: fnd_message.set_name('AR', 'AR_RW_APP_TRX_CLAIM_CANCL_NOTE');

8108: fnd_message.set_name('AR', 'AR_RW_APP_TRX_CLAIM_NOTE');
8109: fnd_message.set_token('RECEIPT_NUM',p_receipt_number);
8110: fnd_message.set_token('CLAIM_NUM',p_claim_number);
8111: ELSIF p_flag = 'CANCEL' THEN
8112: fnd_message.set_name('AR', 'AR_RW_APP_TRX_CLAIM_CANCL_NOTE');
8113: fnd_message.set_token('CLAIM_NUM',p_claim_number);
8114: ELSIF p_flag = 'CLOSE' THEN --Add for bug 13464283
8115: fnd_message.set_name('AR', 'AR_RW_APP_TRX_CLAIM_CLOSE_NOTE');
8116: fnd_message.set_token('CLAIM_NUM',p_claim_number);

Line 8113: fnd_message.set_token('CLAIM_NUM',p_claim_number);

8109: fnd_message.set_token('RECEIPT_NUM',p_receipt_number);
8110: fnd_message.set_token('CLAIM_NUM',p_claim_number);
8111: ELSIF p_flag = 'CANCEL' THEN
8112: fnd_message.set_name('AR', 'AR_RW_APP_TRX_CLAIM_CANCL_NOTE');
8113: fnd_message.set_token('CLAIM_NUM',p_claim_number);
8114: ELSIF p_flag = 'CLOSE' THEN --Add for bug 13464283
8115: fnd_message.set_name('AR', 'AR_RW_APP_TRX_CLAIM_CLOSE_NOTE');
8116: fnd_message.set_token('CLAIM_NUM',p_claim_number);
8117: END IF;

Line 8115: fnd_message.set_name('AR', 'AR_RW_APP_TRX_CLAIM_CLOSE_NOTE');

8111: ELSIF p_flag = 'CANCEL' THEN
8112: fnd_message.set_name('AR', 'AR_RW_APP_TRX_CLAIM_CANCL_NOTE');
8113: fnd_message.set_token('CLAIM_NUM',p_claim_number);
8114: ELSIF p_flag = 'CLOSE' THEN --Add for bug 13464283
8115: fnd_message.set_name('AR', 'AR_RW_APP_TRX_CLAIM_CLOSE_NOTE');
8116: fnd_message.set_token('CLAIM_NUM',p_claim_number);
8117: END IF;
8118:
8119: /* bug 3161148, need to pass only 240 characters as that is the

Line 8116: fnd_message.set_token('CLAIM_NUM',p_claim_number);

8112: fnd_message.set_name('AR', 'AR_RW_APP_TRX_CLAIM_CANCL_NOTE');
8113: fnd_message.set_token('CLAIM_NUM',p_claim_number);
8114: ELSIF p_flag = 'CLOSE' THEN --Add for bug 13464283
8115: fnd_message.set_name('AR', 'AR_RW_APP_TRX_CLAIM_CLOSE_NOTE');
8116: fnd_message.set_token('CLAIM_NUM',p_claim_number);
8117: END IF;
8118:
8119: /* bug 3161148, need to pass only 240 characters as that is the
8120: limit on the column in the table. */

Line 8121: l_text := substrb(fnd_message.get,1,240);

8117: END IF;
8118:
8119: /* bug 3161148, need to pass only 240 characters as that is the
8120: limit on the column in the table. */
8121: l_text := substrb(fnd_message.get,1,240);
8122:
8123: l_user_id := arp_standard.profile.user_id;
8124: l_last_update_login := arp_standard.profile.last_update_login;
8125: l_sysdate := SYSDATE;

Line 8557: FND_MESSAGE.Set_Encoded (l_msg_data);

8553: ||SQLERRM);
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

Line 8609: FND_MESSAGE.set_name('AR','AR_RW_INVALID_CLAIM_ID');

8605: INTO x_claim_status
8606: USING p_claim_id;
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

Line 8610: FND_MESSAGE.set_token('CLAIM_ID',p_claim_id);

8606: USING p_claim_id;
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()-' );

Line 9180: FND_MESSAGE.SET_NAME('AR', 'AR_REG_CM_UNAPP_COMMENTS');

9176: INTO l_trx_number
9177: FROM ra_customer_trx
9178: WHERE customer_Trx_id = p_app_cust_Trx_id;
9179:
9180: FND_MESSAGE.SET_NAME('AR', 'AR_REG_CM_UNAPP_COMMENTS');
9181: FND_MESSAGE.SET_TOKEN('INVOICE_NUMBER', l_trx_number);
9182: l_message_text := fnd_message.get;
9183:
9184: UPDATE ra_cust_trx_line_gl_dist

Line 9181: FND_MESSAGE.SET_TOKEN('INVOICE_NUMBER', l_trx_number);

9177: FROM ra_customer_trx
9178: WHERE customer_Trx_id = p_app_cust_Trx_id;
9179:
9180: FND_MESSAGE.SET_NAME('AR', 'AR_REG_CM_UNAPP_COMMENTS');
9181: FND_MESSAGE.SET_TOKEN('INVOICE_NUMBER', l_trx_number);
9182: l_message_text := fnd_message.get;
9183:
9184: UPDATE ra_cust_trx_line_gl_dist
9185: SET comments = comments || l_message_text

Line 9182: l_message_text := fnd_message.get;

9178: WHERE customer_Trx_id = p_app_cust_Trx_id;
9179:
9180: FND_MESSAGE.SET_NAME('AR', 'AR_REG_CM_UNAPP_COMMENTS');
9181: FND_MESSAGE.SET_TOKEN('INVOICE_NUMBER', l_trx_number);
9182: l_message_text := fnd_message.get;
9183:
9184: UPDATE ra_cust_trx_line_gl_dist
9185: SET comments = comments || l_message_text
9186: WHERE customer_trx_id = p_cust_trx_id