DBA Data[Home] [Help]

APPS.ARP_PROGRAM_GENERATE_BR dependencies on FND_MESSAGE

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

501:
502:
503: ELSE
504: g_field := 'p_call';
505: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
506: FND_MESSAGE.set_token('PROCEDURE','auto_create_br_program');
507: FND_MESSAGE.set_token('PARAMETER', g_field);
508: APP_EXCEPTION.raise_exception;
509: END IF;

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

502:
503: ELSE
504: g_field := 'p_call';
505: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
506: FND_MESSAGE.set_token('PROCEDURE','auto_create_br_program');
507: FND_MESSAGE.set_token('PARAMETER', g_field);
508: APP_EXCEPTION.raise_exception;
509: END IF;
510:

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

503: ELSE
504: g_field := 'p_call';
505: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
506: FND_MESSAGE.set_token('PROCEDURE','auto_create_br_program');
507: FND_MESSAGE.set_token('PARAMETER', g_field);
508: APP_EXCEPTION.raise_exception;
509: END IF;
510:
511: --Temporary table Drop

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

518: THEN
519: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
520: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
521:
522: FND_MESSAGE.SET_NAME('AR','AR_BR_INVALID_TRX_WARNING');
523: l_error_mesg := FND_MESSAGE.GET;
524: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_mesg);
525:
526: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

Line 523: l_error_mesg := FND_MESSAGE.GET;

519: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
520: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
521:
522: FND_MESSAGE.SET_NAME('AR','AR_BR_INVALID_TRX_WARNING');
523: l_error_mesg := FND_MESSAGE.GET;
524: FND_FILE.PUT_LINE(FND_FILE.LOG, l_error_mesg);
525:
526: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
527: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

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

909: --------------------------------------------------------------
910: -- Validations
911: --------------------------------------------------------------
912: IF NVL(p_maturity_date,l_issue_date) < l_issue_date THEN
913: FND_MESSAGE.set_name('AR','AR_BR_MAT_BEFORE_ISSUE_DATE');
914: APP_EXCEPTION.raise_exception;
915: END IF;
916:
917: -- The GL date will follow defaulting by first trying the issue date, then following open period rules

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

929: arp_global.program_application_id, -- p_application-id
930: l_gl_date,
931: l_default_rule_used,
932: l_error_message) = FALSE) THEN
933: FND_MESSAGE.set_name('AR', 'GENERIC_MESSAGE');
934: FND_MESSAGE.set_token('GENERIC_TEXT',l_error_message);
935: APP_EXCEPTION.raise_exception;
936: END IF;
937:

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

930: l_gl_date,
931: l_default_rule_used,
932: l_error_message) = FALSE) THEN
933: FND_MESSAGE.set_name('AR', 'GENERIC_MESSAGE');
934: FND_MESSAGE.set_token('GENERIC_TEXT',l_error_message);
935: APP_EXCEPTION.raise_exception;
936: END IF;
937:
938: -- Insert the batch header in RA_BATCHES and the criteria in AR_SELECTION_CRITERIA

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

1509: l_trx_select_statement := 'SELECT DISTINCT ps.payment_schedule_id '||
1510: l_suffixe_select_statement||
1511: ' ORDER BY ps.payment_schedule_id ';
1512: ELSE
1513: FND_MESSAGE.set_name('AR','AR_BR_INVALID_GROUPING_RULE');
1514: FND_MESSAGE.set_token('GROUPING_RULE',l_receipt_creation_rule_code);
1515: APP_EXCEPTION.raise_exception;
1516: END IF;
1517:

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

1510: l_suffixe_select_statement||
1511: ' ORDER BY ps.payment_schedule_id ';
1512: ELSE
1513: FND_MESSAGE.set_name('AR','AR_BR_INVALID_GROUPING_RULE');
1514: FND_MESSAGE.set_token('GROUPING_RULE',l_receipt_creation_rule_code);
1515: APP_EXCEPTION.raise_exception;
1516: END IF;
1517:
1518: -- bug 3888842

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

2872: BR cannot be created because total exceeds BR range amount
2873: ------------------------------------------------------------*/
2874: IF (l_br_amount NOT BETWEEN p_br_min_acctd_amount AND p_br_max_acctd_amount) THEN
2875: IF p_call = 3 THEN
2876: FND_MESSAGE.set_name('AR', 'AR_BR_AMOUNT_INCORRECT');
2877: APP_EXCEPTION.raise_exception;
2878: ELSE
2879: EXIT;
2880: END IF;

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

2891: BR cannot be created because only transactions with IMMEDIATE term will be picked
2892: -----------------------------------------------------------------------------------*/
2893:
2894: IF (l_excluded_rec_nimm > 0) AND (l_tot_rec_nimm = l_excluded_rec_nimm) THEN
2895: FND_MESSAGE.set_name('AR', 'AR_BR_ONLY_DR_CR');
2896: IF p_call = 3 THEN
2897: APP_EXCEPTION.raise_exception;
2898: ELSE
2899: program_debug(p_call,FND_MESSAGE.get);

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

2895: FND_MESSAGE.set_name('AR', 'AR_BR_ONLY_DR_CR');
2896: IF p_call = 3 THEN
2897: APP_EXCEPTION.raise_exception;
2898: ELSE
2899: program_debug(p_call,FND_MESSAGE.get);
2900: EXIT;
2901: END IF;
2902: END IF;
2903:

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

2949: program_debug(p_call, 'The Bill receivable can not be created because ' ||
2950: 'the Batch_source_id is NULL ');
2951: END IF;
2952: IF p_call = 3 THEN
2953: FND_MESSAGE.set_name('AR','AR_NO_PROFILE_VALUE');
2954: FND_MESSAGE.set_token('PROFILE','AR: Bills Receivable Batch Source');
2955: APP_EXCEPTION.raise_exception;
2956: END IF;
2957: EXIT;

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

2950: 'the Batch_source_id is NULL ');
2951: END IF;
2952: IF p_call = 3 THEN
2953: FND_MESSAGE.set_name('AR','AR_NO_PROFILE_VALUE');
2954: FND_MESSAGE.set_token('PROFILE','AR: Bills Receivable Batch Source');
2955: APP_EXCEPTION.raise_exception;
2956: END IF;
2957: EXIT;
2958:

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

2963: OPEN bs_details(l_batch_source_id);
2964: FETCH bs_details INTO rec_bs;
2965:
2966: IF (rec_bs.auto_trx_numbering_flag = 'N') then
2967: fnd_message.set_name('AR','AR_BR_MANUAL_BATCH_SOURCE');
2968: fnd_message.set_token('BATCH_SOURCE_NAME',rec_bs.name);
2969: IF p_call = 3 THEN
2970: APP_EXCEPTION.raise_exception;
2971: ELSE

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

2964: FETCH bs_details INTO rec_bs;
2965:
2966: IF (rec_bs.auto_trx_numbering_flag = 'N') then
2967: fnd_message.set_name('AR','AR_BR_MANUAL_BATCH_SOURCE');
2968: fnd_message.set_token('BATCH_SOURCE_NAME',rec_bs.name);
2969: IF p_call = 3 THEN
2970: APP_EXCEPTION.raise_exception;
2971: ELSE
2972: program_debug(p_call,FND_MESSAGE.get);

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

2968: fnd_message.set_token('BATCH_SOURCE_NAME',rec_bs.name);
2969: IF p_call = 3 THEN
2970: APP_EXCEPTION.raise_exception;
2971: ELSE
2972: program_debug(p_call,FND_MESSAGE.get);
2973: EXIT;
2974: END IF;
2975: END IF;
2976:

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

2986: ELSIF (p_call = 3) THEN
2987: l_created_from := 'ARXTWMAI.fmx';
2988: ELSE
2989: g_field := 'p_call';
2990: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
2991: FND_MESSAGE.set_token('PROCEDURE','create_BR');
2992: FND_MESSAGE.set_token('PARAMETER', g_field);
2993: APP_EXCEPTION.raise_exception;
2994: END IF;

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

2987: l_created_from := 'ARXTWMAI.fmx';
2988: ELSE
2989: g_field := 'p_call';
2990: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
2991: FND_MESSAGE.set_token('PROCEDURE','create_BR');
2992: FND_MESSAGE.set_token('PARAMETER', g_field);
2993: APP_EXCEPTION.raise_exception;
2994: END IF;
2995:

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

2988: ELSE
2989: g_field := 'p_call';
2990: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
2991: FND_MESSAGE.set_token('PROCEDURE','create_BR');
2992: FND_MESSAGE.set_token('PARAMETER', g_field);
2993: APP_EXCEPTION.raise_exception;
2994: END IF;
2995:
2996: -- set BR Maturity date

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

3036: l_br_maturity_date := l_due_date_imm;
3037: END IF;
3038:
3039: ELSE
3040: FND_MESSAGE.set_name('AR','AR_BR_INVALID_MAT_DATE_RULE');
3041: FND_MESSAGE.set_token('MAT_DATE_RULE',p_maturity_date_rule_code);
3042: APP_EXCEPTION.raise_exception;
3043: END IF;
3044:

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

3037: END IF;
3038:
3039: ELSE
3040: FND_MESSAGE.set_name('AR','AR_BR_INVALID_MAT_DATE_RULE');
3041: FND_MESSAGE.set_token('MAT_DATE_RULE',p_maturity_date_rule_code);
3042: APP_EXCEPTION.raise_exception;
3043: END IF;
3044:
3045: ELSE

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

3053: A bill receivable must not be created when the maturity date is prior to the issue date
3054: -----------------------------------------------------------------------------------------*/
3055:
3056: IF (TO_DATE(l_br_maturity_date,'DD/MM/RR') < TO_DATE(l_issue_date,'DD/MM/RR')) THEN
3057: FND_MESSAGE.set_name('AR','AR_BR_INCORRECT_MATURITY_DT');
3058: FND_MESSAGE.set_token('MATURITY_DT',l_br_maturity_date);
3059: FND_MESSAGE.set_token('ISSUE_DT',l_issue_date);
3060:
3061: IF p_call = 3 THEN

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

3054: -----------------------------------------------------------------------------------------*/
3055:
3056: IF (TO_DATE(l_br_maturity_date,'DD/MM/RR') < TO_DATE(l_issue_date,'DD/MM/RR')) THEN
3057: FND_MESSAGE.set_name('AR','AR_BR_INCORRECT_MATURITY_DT');
3058: FND_MESSAGE.set_token('MATURITY_DT',l_br_maturity_date);
3059: FND_MESSAGE.set_token('ISSUE_DT',l_issue_date);
3060:
3061: IF p_call = 3 THEN
3062: APP_EXCEPTION.raise_exception;

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

3055:
3056: IF (TO_DATE(l_br_maturity_date,'DD/MM/RR') < TO_DATE(l_issue_date,'DD/MM/RR')) THEN
3057: FND_MESSAGE.set_name('AR','AR_BR_INCORRECT_MATURITY_DT');
3058: FND_MESSAGE.set_token('MATURITY_DT',l_br_maturity_date);
3059: FND_MESSAGE.set_token('ISSUE_DT',l_issue_date);
3060:
3061: IF p_call = 3 THEN
3062: APP_EXCEPTION.raise_exception;
3063: ELSE

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

3060:
3061: IF p_call = 3 THEN
3062: APP_EXCEPTION.raise_exception;
3063: ELSE
3064: program_debug(p_call,FND_MESSAGE.get);
3065: EXIT;
3066: END IF;
3067:
3068: END IF;

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

3359:
3360: A bill receivable must not be created when the maturity date is prior to the issue date
3361:
3362: IF (TO_DATE(l_br_maturity_date,'DD/MM/RR') < TO_DATE(l_issue_date,'DD/MM/RR')) THEN
3363: FND_MESSAGE.set_name('AR','AR_BR_INCORRECT_MATURITY_DT');
3364: FND_MESSAGE.set_token('MATURITY_DT',l_br_maturity_date);
3365: FND_MESSAGE.set_token('ISSUE_DT',l_issue_date);
3366:
3367: IF p_call = 3 THEN

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

3360: A bill receivable must not be created when the maturity date is prior to the issue date
3361:
3362: IF (TO_DATE(l_br_maturity_date,'DD/MM/RR') < TO_DATE(l_issue_date,'DD/MM/RR')) THEN
3363: FND_MESSAGE.set_name('AR','AR_BR_INCORRECT_MATURITY_DT');
3364: FND_MESSAGE.set_token('MATURITY_DT',l_br_maturity_date);
3365: FND_MESSAGE.set_token('ISSUE_DT',l_issue_date);
3366:
3367: IF p_call = 3 THEN
3368: APP_EXCEPTION.raise_exception;

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

3361:
3362: IF (TO_DATE(l_br_maturity_date,'DD/MM/RR') < TO_DATE(l_issue_date,'DD/MM/RR')) THEN
3363: FND_MESSAGE.set_name('AR','AR_BR_INCORRECT_MATURITY_DT');
3364: FND_MESSAGE.set_token('MATURITY_DT',l_br_maturity_date);
3365: FND_MESSAGE.set_token('ISSUE_DT',l_issue_date);
3366:
3367: IF p_call = 3 THEN
3368: APP_EXCEPTION.raise_exception;
3369: ELSE

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

3366:
3367: IF p_call = 3 THEN
3368: APP_EXCEPTION.raise_exception;
3369: ELSE
3370: program_debug(p_call,FND_MESSAGE.get);
3371: EXIT;
3372: END IF;
3373:
3374: END IF;

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

3567: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3568: program_debug(p_call,'EXCEPTION AR_BILLS_CREATION_PUB.Create_BR_Header()- unexpected error');
3569: END IF;
3570: IF p_call = 3 THEN
3571: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3572: END IF;
3573: APP_EXCEPTION.raise_exception;
3574: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3575: l_msg_data := FND_MESSAGE.Get;

Line 3575: l_msg_data := FND_MESSAGE.Get;

3571: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3572: END IF;
3573: APP_EXCEPTION.raise_exception;
3574: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3575: l_msg_data := FND_MESSAGE.Get;
3576: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3577: program_debug(p_call,'EXCEPTION AR_BILLS_CREATION_PUB.Create_BR_Header() ' || '- error :'||l_msg_data);
3578: END IF;
3579: ROLLBACK TO create_BR_SVP2;

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

3577: program_debug(p_call,'EXCEPTION AR_BILLS_CREATION_PUB.Create_BR_Header() ' || '- error :'||l_msg_data);
3578: END IF;
3579: ROLLBACK TO create_BR_SVP2;
3580: IF p_call = 3 THEN
3581: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3582: END IF;
3583: APP_EXCEPTION.raise_exception; /* Bug3472744 Moved this from inside p_call=3 */
3584: -- EXIT; /* Bug 3472744 Commented the EXIT */
3585: END IF;

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

3650: program_debug(p_call,'EXCEPTION NIMM : AR_BILLS_CREATION_PUB.create_br_assignment() ' ||
3651: '- unexpected error ');
3652: END IF;
3653: IF p_call = 3 THEN
3654: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3655: END IF;
3656: APP_EXCEPTION.raise_exception;
3657: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3658: l_msg_data := FND_MESSAGE.Get;

Line 3658: l_msg_data := FND_MESSAGE.Get;

3654: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3655: END IF;
3656: APP_EXCEPTION.raise_exception;
3657: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3658: l_msg_data := FND_MESSAGE.Get;
3659: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3660: program_debug(p_call,'EXCEPTION NIMM : AR_BILLS_CREATION_PUB.create_br_assignment() ' ||
3661: ' - error :'||l_msg_data);
3662: END IF;

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

3661: ' - error :'||l_msg_data);
3662: END IF;
3663: ROLLBACK TO create_BR_SVP2;
3664: IF p_call = 3 THEN
3665: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3666: END IF;
3667: APP_EXCEPTION.raise_exception;
3668: END IF;
3669: END; /* create_br_assignment_nimm block change6*/

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

3733: program_debug(p_call,'EXCEPTION IMM: AR_BILLS_CREATION_PUB.create_br_assignment() ' ||
3734: '- unexpected error ');
3735: END IF;
3736: IF p_call = 3 THEN
3737: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3738: END IF;
3739: APP_EXCEPTION.raise_exception;
3740: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3741: l_msg_data := FND_MESSAGE.Get;

Line 3741: l_msg_data := FND_MESSAGE.Get;

3737: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3738: END IF;
3739: APP_EXCEPTION.raise_exception;
3740: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3741: l_msg_data := FND_MESSAGE.Get;
3742: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3743: program_debug(p_call,'EXCEPTION IMM: AR_BILLS_CREATION_PUB.create_br_assignment() ' ||
3744: ' - error :'||l_msg_data);
3745: END IF;

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

3744: ' - error :'||l_msg_data);
3745: END IF;
3746: ROLLBACK TO create_BR_SVP2;
3747: IF p_call = 3 THEN
3748: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3749: END IF;
3750: APP_EXCEPTION.raise_exception; /* Bug3472744 Moved this from inside p_call=3 */
3751: -- EXIT; /* Bug 3472744 Commented the exit */
3752: END IF;

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

3797: 'EXCEPTION AR_BILLS_CREATION_PUB.complete_BR() ' ||
3798: ' - unexpected error ');
3799: END IF;
3800: IF p_call = 3 THEN
3801: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3802: END IF;
3803: APP_EXCEPTION.raise_exception;
3804: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3805: l_msg_data := FND_MESSAGE.Get;

Line 3805: l_msg_data := FND_MESSAGE.Get;

3801: FND_MESSAGE.set_name('AR','AR_BR_CANNOT_CREATE_BR');
3802: END IF;
3803: APP_EXCEPTION.raise_exception;
3804: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3805: l_msg_data := FND_MESSAGE.Get;
3806: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3807: program_debug(p_call,
3808: '>>>> EXCEPTION AR_BILLS_CREATION_PUB.complete_BR() ' ||
3809: '- error :'||l_msg_data);

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

3809: '- error :'||l_msg_data);
3810: END IF;
3811: ROLLBACK TO create_BR_SVP2;
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: -- EXIT;
3817: END IF;

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

4501:
4502: -- parameter p_batch_id mustn't be NULL
4503: IF (p_batch_id IS NULL) THEN
4504: g_field := 'p_batch_id';
4505: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
4506: FND_MESSAGE.set_token('PROCEDURE','run_report_pvt');
4507: FND_MESSAGE.set_token('PARAMETER', g_field);
4508: APP_EXCEPTION.raise_exception;
4509: END IF;

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

4502: -- parameter p_batch_id mustn't be NULL
4503: IF (p_batch_id IS NULL) THEN
4504: g_field := 'p_batch_id';
4505: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
4506: FND_MESSAGE.set_token('PROCEDURE','run_report_pvt');
4507: FND_MESSAGE.set_token('PARAMETER', g_field);
4508: APP_EXCEPTION.raise_exception;
4509: END IF;
4510:

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

4503: IF (p_batch_id IS NULL) THEN
4504: g_field := 'p_batch_id';
4505: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
4506: FND_MESSAGE.set_token('PROCEDURE','run_report_pvt');
4507: FND_MESSAGE.set_token('PARAMETER', g_field);
4508: APP_EXCEPTION.raise_exception;
4509: END IF;
4510:
4511: -- parameter l_version must be 'D' for detail

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

4532: ,l_version
4533: ,arp_global.request_id);
4534:
4535: IF (l_request_id = 0) THEN
4536: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
4537: FND_MESSAGE.set_token('PROCEDURE','ARP_PROGRAM_BR_REMIT.run_report_pvt');
4538: APP_EXCEPTION.raise_exception;
4539: ELSE
4540: FND_FILE.PUT_LINE(FND_FILE.LOG,'Submitted Request : '||to_char(l_request_id));

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

4533: ,arp_global.request_id);
4534:
4535: IF (l_request_id = 0) THEN
4536: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
4537: FND_MESSAGE.set_token('PROCEDURE','ARP_PROGRAM_BR_REMIT.run_report_pvt');
4538: APP_EXCEPTION.raise_exception;
4539: ELSE
4540: FND_FILE.PUT_LINE(FND_FILE.LOG,'Submitted Request : '||to_char(l_request_id));
4541: END IF;

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

4596:
4597: -- parameter p_object_id mustn't be NULL
4598: IF (p_object_id IS NULL) THEN
4599: g_field := 'p_object_id';
4600: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
4601: FND_MESSAGE.set_token('PROCEDURE','print_BR_pvt');
4602: FND_MESSAGE.set_token('PARAMETER', g_field);
4603: APP_EXCEPTION.raise_exception;
4604: END IF;

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

4597: -- parameter p_object_id mustn't be NULL
4598: IF (p_object_id IS NULL) THEN
4599: g_field := 'p_object_id';
4600: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
4601: FND_MESSAGE.set_token('PROCEDURE','print_BR_pvt');
4602: FND_MESSAGE.set_token('PARAMETER', g_field);
4603: APP_EXCEPTION.raise_exception;
4604: END IF;
4605:

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

4598: IF (p_object_id IS NULL) THEN
4599: g_field := 'p_object_id';
4600: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
4601: FND_MESSAGE.set_token('PROCEDURE','print_BR_pvt');
4602: FND_MESSAGE.set_token('PARAMETER', g_field);
4603: APP_EXCEPTION.raise_exception;
4604: END IF;
4605:
4606:

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

4631: ,NULL
4632: ,arp_global.set_of_books_id);
4633:
4634: IF (l_request_id = 0) THEN
4635: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
4636: FND_MESSAGE.set_token('PROCEDURE','ARP_PROGRAM_BR_REMIT.print_BR_pvt');
4637: APP_EXCEPTION.raise_exception;
4638: ELSE
4639: FND_FILE.PUT_LINE(FND_FILE.LOG,'Submitted Request : '||to_char(l_request_id));

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

4632: ,arp_global.set_of_books_id);
4633:
4634: IF (l_request_id = 0) THEN
4635: FND_MESSAGE.set_name('AR','AR_BR_BATCH_SUBMIT_FAILED');
4636: FND_MESSAGE.set_token('PROCEDURE','ARP_PROGRAM_BR_REMIT.print_BR_pvt');
4637: APP_EXCEPTION.raise_exception;
4638: ELSE
4639: FND_FILE.PUT_LINE(FND_FILE.LOG,'Submitted Request : '||to_char(l_request_id));
4640: END IF;

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

4770: -- Validations
4771: -------------------------------------------------------------------------
4772: IF p_customer_trx_id IS NULL THEN
4773: g_field := 'p_customer_trx_id';
4774: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
4775: FND_MESSAGE.set_token('PROCEDURE','auto_create_br_API');
4776: FND_MESSAGE.set_token('PARAMETER', g_field);
4777: app_exception.raise_exception;
4778: END IF;

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

4771: -------------------------------------------------------------------------
4772: IF p_customer_trx_id IS NULL THEN
4773: g_field := 'p_customer_trx_id';
4774: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
4775: FND_MESSAGE.set_token('PROCEDURE','auto_create_br_API');
4776: FND_MESSAGE.set_token('PARAMETER', g_field);
4777: app_exception.raise_exception;
4778: END IF;
4779:

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

4772: IF p_customer_trx_id IS NULL THEN
4773: g_field := 'p_customer_trx_id';
4774: FND_MESSAGE.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
4775: FND_MESSAGE.set_token('PROCEDURE','auto_create_br_API');
4776: FND_MESSAGE.set_token('PARAMETER', g_field);
4777: app_exception.raise_exception;
4778: END IF;
4779:
4780: /*Bug2290332: Reset Variable Storing No of BR Created */

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

4789: l_maturity_date_rule_code, l_br_min_acctd_amount, l_br_max_acctd_amount,
4790: l_invoice_currency_code, l_customer_bank_account_id, l_le_id;
4791:
4792: IF (c_receipt_method%NOTFOUND) THEN
4793: FND_MESSAGE.set_name('AR','AR_BR_INVALID_TRANSACTION');
4794: FND_MESSAGE.set_token('TRX',p_customer_trx_id);
4795: APP_EXCEPTION.raise_exception;
4796: END IF;
4797:

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

4790: l_invoice_currency_code, l_customer_bank_account_id, l_le_id;
4791:
4792: IF (c_receipt_method%NOTFOUND) THEN
4793: FND_MESSAGE.set_name('AR','AR_BR_INVALID_TRANSACTION');
4794: FND_MESSAGE.set_token('TRX',p_customer_trx_id);
4795: APP_EXCEPTION.raise_exception;
4796: END IF;
4797:
4798: CLOSE c_receipt_method;

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

4873: l_trx_select_statement := 'SELECT DISTINCT ps.payment_schedule_id '||
4874: l_suffixe_select_statement||
4875: ' ORDER BY ps.payment_schedule_id ';
4876: ELSE
4877: FND_MESSAGE.set_name('AR','AR_BR_INVALID_GROUPING_RULE');
4878: FND_MESSAGE.set_token('GROUPING_RULE',l_receipt_creation_rule_code);
4879: APP_EXCEPTION.raise_exception;
4880: END IF;
4881:

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

4874: l_suffixe_select_statement||
4875: ' ORDER BY ps.payment_schedule_id ';
4876: ELSE
4877: FND_MESSAGE.set_name('AR','AR_BR_INVALID_GROUPING_RULE');
4878: FND_MESSAGE.set_token('GROUPING_RULE',l_receipt_creation_rule_code);
4879: APP_EXCEPTION.raise_exception;
4880: END IF;
4881:
4882: IF PG_DEBUG in ('Y', 'C') THEN

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

5010: END IF;
5011:
5012: /*Bug2290332*/
5013: IF g_num_br_created = 0 THEN
5014: FND_MESSAGE.set_name('AR','AR_BR_NOT_VALID_CONDITION');
5015: APP_EXCEPTION.raise_exception;
5016: END IF;
5017:
5018: --Temporary table Drop