eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PROGRAM_GENERATE_BR dependencies on FND_MESSAGE

Line 525: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

521:
522:
523: ELSE
524: g_field := 'p_call';
525: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
526: FND_MESSAGE.set_token('PROCEDURE','auto_create_br_program');
527: FND_MESSAGE.set_token('PARAMETER', g_field);
528: APP_EXCEPTION.raise_exception;
529: END IF;

Line 526: FND_MESSAGE.set_token('PROCEDURE','auto_create_br_program');

522:
523: ELSE
524: g_field := 'p_call';
525: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
526: FND_MESSAGE.set_token('PROCEDURE','auto_create_br_program');
527: FND_MESSAGE.set_token('PARAMETER', g_field);
528: APP_EXCEPTION.raise_exception;
529: END IF;
530:

Line 527: FND_MESSAGE.set_token('PARAMETER', g_field);

523: ELSE
524: g_field := 'p_call';
525: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
526: FND_MESSAGE.set_token('PROCEDURE','auto_create_br_program');
527: FND_MESSAGE.set_token('PARAMETER', g_field);
528: APP_EXCEPTION.raise_exception;
529: END IF;
530:
531: --Temporary table Drop

Line 542: FND_MESSAGE.SET_NAME('AR','AR_BR_INVALID_TRX_WARNING');

538: THEN
539: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
540: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
541:
542: FND_MESSAGE.SET_NAME('AR','AR_BR_INVALID_TRX_WARNING');
543: l_error_mesg := FND_MESSAGE.GET;
544: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_mesg);
545:
546: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 543: l_error_mesg := FND_MESSAGE.GET;

539: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
540: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
541:
542: FND_MESSAGE.SET_NAME('AR','AR_BR_INVALID_TRX_WARNING');
543: l_error_mesg := FND_MESSAGE.GET;
544: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_mesg);
545:
546: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
547: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 932: FND_MESSAGE.set_name('AR','AR_BR_MAT_BEFORE_ISSUE_DATE');

928: --------------------------------------------------------------
929: -- Validations
930: --------------------------------------------------------------
931: IF NVL(p_maturity_date,l_issue_date) < l_issue_date THEN
932: FND_MESSAGE.set_name('AR','AR_BR_MAT_BEFORE_ISSUE_DATE');
933: APP_EXCEPTION.raise_exception;
934: END IF;
935:
936: -- The GL date will follow defaulting by first trying the issue date, then following open period rules

Line 952: FND_MESSAGE.set_name('AR', 'GENERIC_MESSAGE');

948: arp_global.program_application_id, -- p_application-id
949: l_gl_date,
950: l_default_rule_used,
951: l_error_message) = FALSE) THEN
952: FND_MESSAGE.set_name('AR', 'GENERIC_MESSAGE');
953: FND_MESSAGE.set_token('GENERIC_TEXT',l_error_message);
954: APP_EXCEPTION.raise_exception;
955: END IF;
956:

Line 953: FND_MESSAGE.set_token('GENERIC_TEXT',l_error_message);

949: l_gl_date,
950: l_default_rule_used,
951: l_error_message) = FALSE) THEN
952: FND_MESSAGE.set_name('AR', 'GENERIC_MESSAGE');
953: FND_MESSAGE.set_token('GENERIC_TEXT',l_error_message);
954: APP_EXCEPTION.raise_exception;
955: END IF;
956:
957: -- Insert the batch header in RA_BATCHES and the criteria in AR_SELECTION_CRITERIA

Line 1535: FND_MESSAGE.set_name('AR','AR_BR_INVALID_GROUPING_RULE');

1531: l_trx_select_statement := 'SELECT DISTINCT ps.payment_schedule_id '||
1532: l_suffixe_select_statement||
1533: ' ORDER BY ps.payment_schedule_id ';
1534: ELSE
1535: FND_MESSAGE.set_name('AR','AR_BR_INVALID_GROUPING_RULE');
1536: FND_MESSAGE.set_token('GROUPING_RULE',l_receipt_creation_rule_code);
1537: APP_EXCEPTION.raise_exception;
1538: END IF;
1539:

Line 1536: FND_MESSAGE.set_token('GROUPING_RULE',l_receipt_creation_rule_code);

1532: l_suffixe_select_statement||
1533: ' ORDER BY ps.payment_schedule_id ';
1534: ELSE
1535: FND_MESSAGE.set_name('AR','AR_BR_INVALID_GROUPING_RULE');
1536: FND_MESSAGE.set_token('GROUPING_RULE',l_receipt_creation_rule_code);
1537: APP_EXCEPTION.raise_exception;
1538: END IF;
1539:
1540: -- bug 3888842

Line 3018: FND_MESSAGE.set_name('AR', 'AR_BR_AMOUNT_INCORRECT');

3014: BR cannot be created because total exceeds BR range amount
3015: ------------------------------------------------------------*/
3016: IF (l_br_amount NOT BETWEEN p_br_min_acctd_amount AND p_br_max_acctd_amount) THEN
3017: IF p_call = 3 THEN
3018: FND_MESSAGE.set_name('AR', 'AR_BR_AMOUNT_INCORRECT');
3019: APP_EXCEPTION.raise_exception;
3020: ELSE
3021: EXIT;
3022: END IF;

Line 3037: FND_MESSAGE.set_name('AR', 'AR_BR_ONLY_DR_CR');

3033: BR cannot be created because only transactions with IMMEDIATE term will be picked
3034: -----------------------------------------------------------------------------------*/
3035:
3036: IF (l_excluded_rec_nimm > 0) AND (l_tot_rec_nimm = l_excluded_rec_nimm) THEN
3037: FND_MESSAGE.set_name('AR', 'AR_BR_ONLY_DR_CR');
3038: IF p_call = 3 THEN
3039: APP_EXCEPTION.raise_exception;
3040: ELSE
3041: program_debug(p_call,FND_MESSAGE.get);

Line 3041: program_debug(p_call,FND_MESSAGE.get);

3037: FND_MESSAGE.set_name('AR', 'AR_BR_ONLY_DR_CR');
3038: IF p_call = 3 THEN
3039: APP_EXCEPTION.raise_exception;
3040: ELSE
3041: program_debug(p_call,FND_MESSAGE.get);
3042: EXIT;
3043: END IF;
3044: END IF;
3045:

Line 3095: FND_MESSAGE.set_name('AR','AR_NO_PROFILE_VALUE');

3091: program_debug(p_call, 'The Bill receivable can not be created because ' ||
3092: 'the Batch_source_id is NULL ');
3093: END IF;
3094: IF p_call = 3 THEN
3095: FND_MESSAGE.set_name('AR','AR_NO_PROFILE_VALUE');
3096: FND_MESSAGE.set_token('PROFILE','AR: Bills Receivable Batch Source');
3097: APP_EXCEPTION.raise_exception;
3098: END IF;
3099: EXIT;

Line 3096: FND_MESSAGE.set_token('PROFILE','AR: Bills Receivable Batch Source');

3092: 'the Batch_source_id is NULL ');
3093: END IF;
3094: IF p_call = 3 THEN
3095: FND_MESSAGE.set_name('AR','AR_NO_PROFILE_VALUE');
3096: FND_MESSAGE.set_token('PROFILE','AR: Bills Receivable Batch Source');
3097: APP_EXCEPTION.raise_exception;
3098: END IF;
3099: EXIT;
3100:

Line 3109: fnd_message.set_name('AR','AR_BR_MANUAL_BATCH_SOURCE');

3105: OPEN bs_details(l_batch_source_id);
3106: FETCH bs_details INTO rec_bs;
3107:
3108: IF (rec_bs.auto_trx_numbering_flag = 'N') then
3109: fnd_message.set_name('AR','AR_BR_MANUAL_BATCH_SOURCE');
3110: fnd_message.set_token('BATCH_SOURCE_NAME',rec_bs.name);
3111: IF p_call = 3 THEN
3112: APP_EXCEPTION.raise_exception;
3113: ELSE

Line 3110: fnd_message.set_token('BATCH_SOURCE_NAME',rec_bs.name);

3106: FETCH bs_details INTO rec_bs;
3107:
3108: IF (rec_bs.auto_trx_numbering_flag = 'N') then
3109: fnd_message.set_name('AR','AR_BR_MANUAL_BATCH_SOURCE');
3110: fnd_message.set_token('BATCH_SOURCE_NAME',rec_bs.name);
3111: IF p_call = 3 THEN
3112: APP_EXCEPTION.raise_exception;
3113: ELSE
3114: program_debug(p_call,FND_MESSAGE.get);

Line 3114: program_debug(p_call,FND_MESSAGE.get);

3110: fnd_message.set_token('BATCH_SOURCE_NAME',rec_bs.name);
3111: IF p_call = 3 THEN
3112: APP_EXCEPTION.raise_exception;
3113: ELSE
3114: program_debug(p_call,FND_MESSAGE.get);
3115: EXIT;
3116: END IF;
3117: END IF;
3118:

Line 3132: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

3128: ELSIF (p_call = 3) THEN
3129: l_created_from := 'ARXTWMAI.fmx';
3130: ELSE
3131: g_field := 'p_call';
3132: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
3133: FND_MESSAGE.set_token('PROCEDURE','create_BR');
3134: FND_MESSAGE.set_token('PARAMETER', g_field);
3135: APP_EXCEPTION.raise_exception;
3136: END IF;

Line 3133: FND_MESSAGE.set_token('PROCEDURE','create_BR');

3129: l_created_from := 'ARXTWMAI.fmx';
3130: ELSE
3131: g_field := 'p_call';
3132: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
3133: FND_MESSAGE.set_token('PROCEDURE','create_BR');
3134: FND_MESSAGE.set_token('PARAMETER', g_field);
3135: APP_EXCEPTION.raise_exception;
3136: END IF;
3137:

Line 3134: FND_MESSAGE.set_token('PARAMETER', g_field);

3130: ELSE
3131: g_field := 'p_call';
3132: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
3133: FND_MESSAGE.set_token('PROCEDURE','create_BR');
3134: FND_MESSAGE.set_token('PARAMETER', g_field);
3135: APP_EXCEPTION.raise_exception;
3136: END IF;
3137:
3138: -- set BR Maturity date

Line 3182: FND_MESSAGE.set_name('AR','AR_BR_INVALID_MAT_DATE_RULE');

3178: l_br_maturity_date := l_due_date_imm;
3179: END IF;
3180:
3181: ELSE
3182: FND_MESSAGE.set_name('AR','AR_BR_INVALID_MAT_DATE_RULE');
3183: FND_MESSAGE.set_token('MAT_DATE_RULE',p_maturity_date_rule_code);
3184: APP_EXCEPTION.raise_exception;
3185: END IF;
3186:

Line 3183: FND_MESSAGE.set_token('MAT_DATE_RULE',p_maturity_date_rule_code);

3179: END IF;
3180:
3181: ELSE
3182: FND_MESSAGE.set_name('AR','AR_BR_INVALID_MAT_DATE_RULE');
3183: FND_MESSAGE.set_token('MAT_DATE_RULE',p_maturity_date_rule_code);
3184: APP_EXCEPTION.raise_exception;
3185: END IF;
3186:
3187: ELSE

Line 3199: FND_MESSAGE.set_name('AR','AR_BR_INCORRECT_MATURITY_DT');

3195: A bill receivable must not be created when the maturity date is prior to the issue date
3196: -----------------------------------------------------------------------------------------*/
3197:
3198: IF (TO_DATE(l_br_maturity_date,'DD/MM/RR') < TO_DATE(l_issue_date,'DD/MM/RR')) THEN
3199: FND_MESSAGE.set_name('AR','AR_BR_INCORRECT_MATURITY_DT');
3200: --Int'l Calendar Project
3201: FND_MESSAGE.set_token('MATURITY_DT',fnd_date.date_to_chardate(l_br_maturity_date, calendar_aware=> FND_DATE.calendar_aware_alt));
3202: FND_MESSAGE.set_token('ISSUE_DT',fnd_date.date_to_chardate(l_issue_date, calendar_aware=> FND_DATE.calendar_aware_alt));
3203:

Line 3201: FND_MESSAGE.set_token('MATURITY_DT',fnd_date.date_to_chardate(l_br_maturity_date, calendar_aware=> FND_DATE.calendar_aware_alt));

3197:
3198: IF (TO_DATE(l_br_maturity_date,'DD/MM/RR') < TO_DATE(l_issue_date,'DD/MM/RR')) THEN
3199: FND_MESSAGE.set_name('AR','AR_BR_INCORRECT_MATURITY_DT');
3200: --Int'l Calendar Project
3201: FND_MESSAGE.set_token('MATURITY_DT',fnd_date.date_to_chardate(l_br_maturity_date, calendar_aware=> FND_DATE.calendar_aware_alt));
3202: FND_MESSAGE.set_token('ISSUE_DT',fnd_date.date_to_chardate(l_issue_date, calendar_aware=> FND_DATE.calendar_aware_alt));
3203:
3204: IF p_call = 3 THEN
3205: APP_EXCEPTION.raise_exception;

Line 3202: FND_MESSAGE.set_token('ISSUE_DT',fnd_date.date_to_chardate(l_issue_date, calendar_aware=> FND_DATE.calendar_aware_alt));

3198: IF (TO_DATE(l_br_maturity_date,'DD/MM/RR') < TO_DATE(l_issue_date,'DD/MM/RR')) THEN
3199: FND_MESSAGE.set_name('AR','AR_BR_INCORRECT_MATURITY_DT');
3200: --Int'l Calendar Project
3201: FND_MESSAGE.set_token('MATURITY_DT',fnd_date.date_to_chardate(l_br_maturity_date, calendar_aware=> FND_DATE.calendar_aware_alt));
3202: FND_MESSAGE.set_token('ISSUE_DT',fnd_date.date_to_chardate(l_issue_date, calendar_aware=> FND_DATE.calendar_aware_alt));
3203:
3204: IF p_call = 3 THEN
3205: APP_EXCEPTION.raise_exception;
3206: ELSE

Line 3207: program_debug(p_call,FND_MESSAGE.get);

3203:
3204: IF p_call = 3 THEN
3205: APP_EXCEPTION.raise_exception;
3206: ELSE
3207: program_debug(p_call,FND_MESSAGE.get);
3208: EXIT;
3209: END IF;
3210:
3211: END IF;

Line 3522: FND_MESSAGE.set_name('AR','AR_BR_INCORRECT_MATURITY_DT');

3518:
3519: A bill receivable must not be created when the maturity date is prior to the issue date
3520:
3521: IF (TO_DATE(l_br_maturity_date,'DD/MM/RR') < TO_DATE(l_issue_date,'DD/MM/RR')) THEN
3522: FND_MESSAGE.set_name('AR','AR_BR_INCORRECT_MATURITY_DT');
3523: FND_MESSAGE.set_token('MATURITY_DT',l_br_maturity_date);
3524: FND_MESSAGE.set_token('ISSUE_DT',l_issue_date);
3525:
3526: IF p_call = 3 THEN

Line 3523: FND_MESSAGE.set_token('MATURITY_DT',l_br_maturity_date);

3519: A bill receivable must not be created when the maturity date is prior to the issue date
3520:
3521: IF (TO_DATE(l_br_maturity_date,'DD/MM/RR') < TO_DATE(l_issue_date,'DD/MM/RR')) THEN
3522: FND_MESSAGE.set_name('AR','AR_BR_INCORRECT_MATURITY_DT');
3523: FND_MESSAGE.set_token('MATURITY_DT',l_br_maturity_date);
3524: FND_MESSAGE.set_token('ISSUE_DT',l_issue_date);
3525:
3526: IF p_call = 3 THEN
3527: APP_EXCEPTION.raise_exception;

Line 3524: FND_MESSAGE.set_token('ISSUE_DT',l_issue_date);

3520:
3521: IF (TO_DATE(l_br_maturity_date,'DD/MM/RR') < TO_DATE(l_issue_date,'DD/MM/RR')) THEN
3522: FND_MESSAGE.set_name('AR','AR_BR_INCORRECT_MATURITY_DT');
3523: FND_MESSAGE.set_token('MATURITY_DT',l_br_maturity_date);
3524: FND_MESSAGE.set_token('ISSUE_DT',l_issue_date);
3525:
3526: IF p_call = 3 THEN
3527: APP_EXCEPTION.raise_exception;
3528: ELSE

Line 3529: program_debug(p_call,FND_MESSAGE.get);

3525:
3526: IF p_call = 3 THEN
3527: APP_EXCEPTION.raise_exception;
3528: ELSE
3529: program_debug(p_call,FND_MESSAGE.get);
3530: EXIT;
3531: END IF;
3532:
3533: END IF;

Line 3730: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');

3726: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3727: program_debug(p_call,'EXCEPTION AR_BILLS_CREATION_PUB.Create_BR_Header()- unexpected error');
3728: END IF;
3729: IF p_call = 3 THEN
3730: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3731: END IF;
3732: APP_EXCEPTION.raise_exception;
3733: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3734: l_msg_data := FND_MESSAGE.Get;

Line 3734: l_msg_data := FND_MESSAGE.Get;

3730: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3731: END IF;
3732: APP_EXCEPTION.raise_exception;
3733: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3734: l_msg_data := FND_MESSAGE.Get;
3735: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3736: program_debug(p_call,'EXCEPTION AR_BILLS_CREATION_PUB.Create_BR_Header() ' || '- error :'||l_msg_data);
3737: END IF;
3738: ROLLBACK TO create_BR_SVP2;

Line 3740: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');

3736: program_debug(p_call,'EXCEPTION AR_BILLS_CREATION_PUB.Create_BR_Header() ' || '- error :'||l_msg_data);
3737: END IF;
3738: ROLLBACK TO create_BR_SVP2;
3739: IF p_call = 3 THEN
3740: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3741: END IF;
3742: APP_EXCEPTION.raise_exception; /* Bug3472744 Moved this from inside p_call=3 */
3743: -- EXIT; /* Bug 3472744 Commented the EXIT */
3744: END IF;

Line 3813: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');

3809: program_debug(p_call,'EXCEPTION NIMM : AR_BILLS_CREATION_PUB.create_br_assignment() ' ||
3810: '- unexpected error ');
3811: END IF;
3812: IF p_call = 3 THEN
3813: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3814: END IF;
3815: APP_EXCEPTION.raise_exception;
3816: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3817: l_msg_data := FND_MESSAGE.Get;

Line 3817: l_msg_data := FND_MESSAGE.Get;

3813: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3814: END IF;
3815: APP_EXCEPTION.raise_exception;
3816: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3817: l_msg_data := FND_MESSAGE.Get;
3818: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3819: program_debug(p_call,'EXCEPTION NIMM : AR_BILLS_CREATION_PUB.create_br_assignment() ' ||
3820: ' - error :'||l_msg_data);
3821: END IF;

Line 3824: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');

3820: ' - error :'||l_msg_data);
3821: END IF;
3822: ROLLBACK TO create_BR_SVP2;
3823: IF p_call = 3 THEN
3824: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3825: END IF;
3826: APP_EXCEPTION.raise_exception;
3827: END IF;
3828: END; /* create_br_assignment_nimm block change6*/

Line 3896: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');

3892: program_debug(p_call,'EXCEPTION IMM: AR_BILLS_CREATION_PUB.create_br_assignment() ' ||
3893: '- unexpected error ');
3894: END IF;
3895: IF p_call = 3 THEN
3896: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3897: END IF;
3898: APP_EXCEPTION.raise_exception;
3899: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3900: l_msg_data := FND_MESSAGE.Get;

Line 3900: l_msg_data := FND_MESSAGE.Get;

3896: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3897: END IF;
3898: APP_EXCEPTION.raise_exception;
3899: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3900: l_msg_data := FND_MESSAGE.Get;
3901: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3902: program_debug(p_call,'EXCEPTION IMM: AR_BILLS_CREATION_PUB.create_br_assignment() ' ||
3903: ' - error :'||l_msg_data);
3904: END IF;

Line 3907: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');

3903: ' - error :'||l_msg_data);
3904: END IF;
3905: ROLLBACK TO create_BR_SVP2;
3906: IF p_call = 3 THEN
3907: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3908: END IF;
3909: APP_EXCEPTION.raise_exception; /* Bug3472744 Moved this from inside p_call=3 */
3910: -- EXIT; /* Bug 3472744 Commented the exit */
3911: END IF;

Line 3960: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');

3956: 'EXCEPTION AR_BILLS_CREATION_PUB.complete_BR() ' ||
3957: ' - unexpected error ');
3958: END IF;
3959: IF p_call = 3 THEN
3960: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3961: END IF;
3962: APP_EXCEPTION.raise_exception;
3963: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3964: l_msg_data := FND_MESSAGE.Get;

Line 3964: l_msg_data := FND_MESSAGE.Get;

3960: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3961: END IF;
3962: APP_EXCEPTION.raise_exception;
3963: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3964: l_msg_data := FND_MESSAGE.Get;
3965: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3966: program_debug(p_call,
3967: '>>>> EXCEPTION AR_BILLS_CREATION_PUB.complete_BR() ' ||
3968: '- error :'||l_msg_data);

Line 3972: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');

3968: '- error :'||l_msg_data);
3969: END IF;
3970: ROLLBACK TO create_BR_SVP2;
3971: IF p_call = 3 THEN
3972: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3973: END IF;
3974: APP_EXCEPTION.raise_exception;
3975: -- EXIT;
3976: END IF;

Line 4664: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

4660:
4661: -- parameter p_batch_id mustn't be NULL
4662: IF (p_batch_id IS NULL) THEN
4663: g_field := 'p_batch_id';
4664: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
4665: FND_MESSAGE.set_token('PROCEDURE','run_report_pvt');
4666: FND_MESSAGE.set_token('PARAMETER', g_field);
4667: APP_EXCEPTION.raise_exception;
4668: END IF;

Line 4665: FND_MESSAGE.set_token('PROCEDURE','run_report_pvt');

4661: -- parameter p_batch_id mustn't be NULL
4662: IF (p_batch_id IS NULL) THEN
4663: g_field := 'p_batch_id';
4664: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
4665: FND_MESSAGE.set_token('PROCEDURE','run_report_pvt');
4666: FND_MESSAGE.set_token('PARAMETER', g_field);
4667: APP_EXCEPTION.raise_exception;
4668: END IF;
4669:

Line 4666: FND_MESSAGE.set_token('PARAMETER', g_field);

4662: IF (p_batch_id IS NULL) THEN
4663: g_field := 'p_batch_id';
4664: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
4665: FND_MESSAGE.set_token('PROCEDURE','run_report_pvt');
4666: FND_MESSAGE.set_token('PARAMETER', g_field);
4667: APP_EXCEPTION.raise_exception;
4668: END IF;
4669:
4670: -- parameter l_version must be 'D' for detail

Line 4695: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');

4691: ,l_version
4692: ,arp_global.request_id);
4693:
4694: IF (l_request_id = 0) THEN
4695: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
4696: FND_MESSAGE.set_token('PROCEDURE','ARP_PROGRAM_BR_REMIT.run_report_pvt');
4697: APP_EXCEPTION.raise_exception;
4698: ELSE
4699: FND_FILE.PUT_LINE(FND_FILE.LOG,'Submitted Request : '||to_char(l_request_id));

Line 4696: FND_MESSAGE.set_token('PROCEDURE','ARP_PROGRAM_BR_REMIT.run_report_pvt');

4692: ,arp_global.request_id);
4693:
4694: IF (l_request_id = 0) THEN
4695: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
4696: FND_MESSAGE.set_token('PROCEDURE','ARP_PROGRAM_BR_REMIT.run_report_pvt');
4697: APP_EXCEPTION.raise_exception;
4698: ELSE
4699: FND_FILE.PUT_LINE(FND_FILE.LOG,'Submitted Request : '||to_char(l_request_id));
4700: END IF;

Line 4759: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

4755:
4756: -- parameter p_object_id mustn't be NULL
4757: IF (p_object_id IS NULL) THEN
4758: g_field := 'p_object_id';
4759: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
4760: FND_MESSAGE.set_token('PROCEDURE','print_BR_pvt');
4761: FND_MESSAGE.set_token('PARAMETER', g_field);
4762: APP_EXCEPTION.raise_exception;
4763: END IF;

Line 4760: FND_MESSAGE.set_token('PROCEDURE','print_BR_pvt');

4756: -- parameter p_object_id mustn't be NULL
4757: IF (p_object_id IS NULL) THEN
4758: g_field := 'p_object_id';
4759: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
4760: FND_MESSAGE.set_token('PROCEDURE','print_BR_pvt');
4761: FND_MESSAGE.set_token('PARAMETER', g_field);
4762: APP_EXCEPTION.raise_exception;
4763: END IF;
4764:

Line 4761: FND_MESSAGE.set_token('PARAMETER', g_field);

4757: IF (p_object_id IS NULL) THEN
4758: g_field := 'p_object_id';
4759: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
4760: FND_MESSAGE.set_token('PROCEDURE','print_BR_pvt');
4761: FND_MESSAGE.set_token('PARAMETER', g_field);
4762: APP_EXCEPTION.raise_exception;
4763: END IF;
4764:
4765:

Line 4794: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');

4790: ,NULL
4791: ,arp_global.set_of_books_id);
4792:
4793: IF (l_request_id = 0) THEN
4794: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
4795: FND_MESSAGE.set_token('PROCEDURE','ARP_PROGRAM_BR_REMIT.print_BR_pvt');
4796: APP_EXCEPTION.raise_exception;
4797: ELSE
4798: FND_FILE.PUT_LINE(FND_FILE.LOG,'Submitted Request : '||to_char(l_request_id));

Line 4795: FND_MESSAGE.set_token('PROCEDURE','ARP_PROGRAM_BR_REMIT.print_BR_pvt');

4791: ,arp_global.set_of_books_id);
4792:
4793: IF (l_request_id = 0) THEN
4794: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
4795: FND_MESSAGE.set_token('PROCEDURE','ARP_PROGRAM_BR_REMIT.print_BR_pvt');
4796: APP_EXCEPTION.raise_exception;
4797: ELSE
4798: FND_FILE.PUT_LINE(FND_FILE.LOG,'Submitted Request : '||to_char(l_request_id));
4799: END IF;

Line 4933: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');

4929: -- Validations
4930: -------------------------------------------------------------------------
4931: IF p_customer_trx_id IS NULL THEN
4932: g_field := 'p_customer_trx_id';
4933: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
4934: FND_MESSAGE.set_token('PROCEDURE','auto_create_br_API');
4935: FND_MESSAGE.set_token('PARAMETER', g_field);
4936: app_exception.raise_exception;
4937: END IF;

Line 4934: FND_MESSAGE.set_token('PROCEDURE','auto_create_br_API');

4930: -------------------------------------------------------------------------
4931: IF p_customer_trx_id IS NULL THEN
4932: g_field := 'p_customer_trx_id';
4933: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
4934: FND_MESSAGE.set_token('PROCEDURE','auto_create_br_API');
4935: FND_MESSAGE.set_token('PARAMETER', g_field);
4936: app_exception.raise_exception;
4937: END IF;
4938:

Line 4935: FND_MESSAGE.set_token('PARAMETER', g_field);

4931: IF p_customer_trx_id IS NULL THEN
4932: g_field := 'p_customer_trx_id';
4933: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
4934: FND_MESSAGE.set_token('PROCEDURE','auto_create_br_API');
4935: FND_MESSAGE.set_token('PARAMETER', g_field);
4936: app_exception.raise_exception;
4937: END IF;
4938:
4939: /*Bug2290332: Reset Variable Storing No of BR Created */

Line 4952: FND_MESSAGE.set_name('AR','AR_BR_INVALID_TRANSACTION');

4948: l_maturity_date_rule_code, l_br_min_acctd_amount, l_br_max_acctd_amount,
4949: l_invoice_currency_code, l_customer_bank_account_id, l_le_id;
4950:
4951: IF (c_receipt_method%NOTFOUND) THEN
4952: FND_MESSAGE.set_name('AR','AR_BR_INVALID_TRANSACTION');
4953: FND_MESSAGE.set_token('TRX',p_customer_trx_id);
4954: APP_EXCEPTION.raise_exception;
4955: END IF;
4956:

Line 4953: FND_MESSAGE.set_token('TRX',p_customer_trx_id);

4949: l_invoice_currency_code, l_customer_bank_account_id, l_le_id;
4950:
4951: IF (c_receipt_method%NOTFOUND) THEN
4952: FND_MESSAGE.set_name('AR','AR_BR_INVALID_TRANSACTION');
4953: FND_MESSAGE.set_token('TRX',p_customer_trx_id);
4954: APP_EXCEPTION.raise_exception;
4955: END IF;
4956:
4957: CLOSE c_receipt_method;

Line 5036: FND_MESSAGE.set_name('AR','AR_BR_INVALID_GROUPING_RULE');

5032: l_trx_select_statement := 'SELECT DISTINCT ps.payment_schedule_id '||
5033: l_suffixe_select_statement||
5034: ' ORDER BY ps.payment_schedule_id ';
5035: ELSE
5036: FND_MESSAGE.set_name('AR','AR_BR_INVALID_GROUPING_RULE');
5037: FND_MESSAGE.set_token('GROUPING_RULE',l_receipt_creation_rule_code);
5038: APP_EXCEPTION.raise_exception;
5039: END IF;
5040:

Line 5037: FND_MESSAGE.set_token('GROUPING_RULE',l_receipt_creation_rule_code);

5033: l_suffixe_select_statement||
5034: ' ORDER BY ps.payment_schedule_id ';
5035: ELSE
5036: FND_MESSAGE.set_name('AR','AR_BR_INVALID_GROUPING_RULE');
5037: FND_MESSAGE.set_token('GROUPING_RULE',l_receipt_creation_rule_code);
5038: APP_EXCEPTION.raise_exception;
5039: END IF;
5040:
5041: IF PG_DEBUG in ('Y', 'C') THEN

Line 5173: FND_MESSAGE.set_name('AR','AR_BR_NOT_VALID_CONDITION');

5169: END IF;
5170:
5171: /*Bug2290332*/
5172: IF g_num_br_created = 0 THEN
5173: FND_MESSAGE.set_name('AR','AR_BR_NOT_VALID_CONDITION');
5174: APP_EXCEPTION.raise_exception;
5175: END IF;
5176:
5177: --Temporary table Drop