DBA Data[Home] [Help]

APPS.ARP_PROGRAM_GENERATE_BR dependencies on APP_EXCEPTION

Line 528: APP_EXCEPTION.raise_exception;

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

Line 933: APP_EXCEPTION.raise_exception;

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

Line 954: APP_EXCEPTION.raise_exception;

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

Line 1537: APP_EXCEPTION.raise_exception;

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

Line 3019: APP_EXCEPTION.raise_exception;

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

Line 3039: APP_EXCEPTION.raise_exception;

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);
3042: EXIT;
3043: END IF;

Line 3097: APP_EXCEPTION.raise_exception;

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

Line 3112: APP_EXCEPTION.raise_exception;

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);
3115: EXIT;
3116: END IF;

Line 3135: APP_EXCEPTION.raise_exception;

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

Line 3184: APP_EXCEPTION.raise_exception;

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

Line 3205: APP_EXCEPTION.raise_exception;

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
3207: program_debug(p_call,FND_MESSAGE.get);
3208: EXIT;
3209: END IF;

Line 3527: APP_EXCEPTION.raise_exception;

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
3529: program_debug(p_call,FND_MESSAGE.get);
3530: EXIT;
3531: END IF;

Line 3732: APP_EXCEPTION.raise_exception;

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

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

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

Line 3815: APP_EXCEPTION.raise_exception;

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

Line 3826: APP_EXCEPTION.raise_exception;

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*/
3829:
3830: END LOOP;

Line 3898: APP_EXCEPTION.raise_exception;

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

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

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

Line 3962: APP_EXCEPTION.raise_exception;

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

Line 3974: APP_EXCEPTION.raise_exception;

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

Line 4667: APP_EXCEPTION.raise_exception;

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

Line 4697: APP_EXCEPTION.raise_exception;

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

Line 4762: APP_EXCEPTION.raise_exception;

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

Line 4796: APP_EXCEPTION.raise_exception;

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

Line 4936: app_exception.raise_exception;

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

Line 4954: APP_EXCEPTION.raise_exception;

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

Line 5038: APP_EXCEPTION.raise_exception;

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

Line 5174: APP_EXCEPTION.raise_exception;

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