DBA Data[Home] [Help]

APPS.ARP_PROGRAM_GENERATE_BR dependencies on APP_EXCEPTION

Line 508: APP_EXCEPTION.raise_exception;

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
512: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;

Line 914: APP_EXCEPTION.raise_exception;

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
918: IF (arp_util.validate_and_default_gl_date(p_batch_date, -- gl_date

Line 935: APP_EXCEPTION.raise_exception;

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
939: arp_process_br_batches.insert_batch('FNDRSRUN', -- p_form_name

Line 1515: APP_EXCEPTION.raise_exception;

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
1519: if l_print AND (p_call <> 3 OR PG_DEBUG in ('Y', 'C')) THEN

Line 2877: APP_EXCEPTION.raise_exception;

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

Line 2897: APP_EXCEPTION.raise_exception;

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);
2900: EXIT;
2901: END IF;

Line 2955: APP_EXCEPTION.raise_exception;

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

Line 2970: APP_EXCEPTION.raise_exception;

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);
2973: EXIT;
2974: END IF;

Line 2993: APP_EXCEPTION.raise_exception;

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
2997: IF (l_maturity_date IS NULL) THEN

Line 3042: APP_EXCEPTION.raise_exception;

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
3046: l_br_maturity_date := l_maturity_date;

Line 3062: APP_EXCEPTION.raise_exception;

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
3064: program_debug(p_call,FND_MESSAGE.get);
3065: EXIT;
3066: END IF;

Line 3368: APP_EXCEPTION.raise_exception;

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
3370: program_debug(p_call,FND_MESSAGE.get);
3371: EXIT;
3372: END IF;

Line 3573: APP_EXCEPTION.raise_exception;

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;
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);

Line 3583: APP_EXCEPTION.raise_exception; /* Bug3472744 Moved this from inside p_call=3 */

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;
3586: END ; /* create_br_header block change6*/
3587:

Line 3656: APP_EXCEPTION.raise_exception;

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;
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() ' ||

Line 3667: APP_EXCEPTION.raise_exception;

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*/
3670:
3671: END LOOP;

Line 3739: APP_EXCEPTION.raise_exception;

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;
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() ' ||

Line 3750: APP_EXCEPTION.raise_exception; /* Bug3472744 Moved this from inside p_call=3 */

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;
3753: END ; /* create_br_assignment_imm block change6*/
3754:

Line 3803: APP_EXCEPTION.raise_exception;

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;
3806: IF p_call <> 3 OR PG_DEBUG in ('Y', 'C') THEN
3807: program_debug(p_call,

Line 3815: APP_EXCEPTION.raise_exception;

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;
3818: END ; /* complete_br block change6 */
3819:

Line 4508: APP_EXCEPTION.raise_exception;

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
4512: SELECT LOOKUP_CODE, MEANING

Line 4538: APP_EXCEPTION.raise_exception;

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

Line 4603: APP_EXCEPTION.raise_exception;

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:
4607: IF p_call <> 3 THEN

Line 4637: APP_EXCEPTION.raise_exception;

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

Line 4777: app_exception.raise_exception;

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 */
4781: g_num_br_created := 0;

Line 4795: APP_EXCEPTION.raise_exception;

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

Line 4879: APP_EXCEPTION.raise_exception;

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
4883: arp_util.debug('l_trx_select_statement = ' || l_trx_select_statement);

Line 5015: APP_EXCEPTION.raise_exception;

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
5019: ARP_PROGRAM_GENERATE_BR.drop_tmp_table;