APPS.OKL_RECEIPTS_PVT dependencies on OKL_API

Line 55: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

51:
52: l_applic_month VARCHAR2(10);
53: l_gl_month VARCHAR2(10);
54: l_counter VARCHAR2(1);
55: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
56: l_gl_date DATE;
57:
58: --get gl date from open accounting period
59: CURSOR c_get_gl_date(cp_date IN DATE) IS SELECT * from (

Line 112: l_return_status := OKL_API.G_RET_STS_ERROR;

108:
109: EXCEPTION
110:
111: WHEN G_EXCEPTION_HALT_VALIDATION THEN
112: l_return_status := OKL_API.G_RET_STS_ERROR;
113: RETURN l_return_status;
114:
115: WHEN OTHERS THEN
116: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 116: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

112: l_return_status := OKL_API.G_RET_STS_ERROR;
113: RETURN l_return_status;
114:
115: WHEN OTHERS THEN
116: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
117: Okl_api.set_message( p_app_name => g_app_name
118: , p_msg_name => g_unexpected_error
119: , p_token1 => g_sqlcode_token
120: , p_token1_value => SQLCODE

Line 117: Okl_api.set_message( p_app_name => g_app_name

113: RETURN l_return_status;
114:
115: WHEN OTHERS THEN
116: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
117: Okl_api.set_message( p_app_name => g_app_name
118: , p_msg_name => g_unexpected_error
119: , p_token1 => g_sqlcode_token
120: , p_token1_value => SQLCODE
121: , p_token2 => g_sqlerrm_token

Line 131: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

127:
128: FUNCTION validate_amount_to_apply(p_amt_to_apply IN nUMBER)
129: RETURN VARCHAR2 is
130:
131: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
132:
133: BEGIN
134: log_debug( 'In amount to apply');
135: log_debug( 'In amount to apply: amount to appli is'||p_amt_to_apply);

Line 137: OKL_API.set_message( p_app_name => G_APP_NAME,

133: BEGIN
134: log_debug( 'In amount to apply');
135: log_debug( 'In amount to apply: amount to appli is'||p_amt_to_apply);
136: IF p_amt_to_apply < 0 THEN
137: OKL_API.set_message( p_app_name => G_APP_NAME,
138: p_msg_name => 'OKL_RCPT_AMT_TO_APPLY_GT_ZERO');
139:
140: RAISE G_EXCEPTION_HALT_VALIDATION;
141: END IF;

Line 147: l_return_status := OKL_API.G_RET_STS_ERROR;

143: RETURN l_return_status;
144:
145: EXCEPTION
146: WHEN G_EXCEPTION_HALT_VALIDATION THEN
147: l_return_status := OKL_API.G_RET_STS_ERROR;
148: RETURN l_return_status;
149:
150: WHEN OTHERS THEN
151: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

Line 151: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

147: l_return_status := OKL_API.G_RET_STS_ERROR;
148: RETURN l_return_status;
149:
150: WHEN OTHERS THEN
151: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
152: OKL_API.Set_Message(p_app_name => G_APP_NAME,
153: p_msg_name => G_UNEXPECTED_ERROR,
154: p_token1 => G_SQLCODE_TOKEN,
155: p_token1_value => SQLCODE,

Line 152: OKL_API.Set_Message(p_app_name => G_APP_NAME,

148: RETURN l_return_status;
149:
150: WHEN OTHERS THEN
151: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
152: OKL_API.Set_Message(p_app_name => G_APP_NAME,
153: p_msg_name => G_UNEXPECTED_ERROR,
154: p_token1 => G_SQLCODE_TOKEN,
155: p_token1_value => SQLCODE,
156: p_token2 => G_SQLERRM_TOKEN,

Line 165: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

161:
162: FUNCTION validate_cash_receipt_id(p_cash_receipt_id IN NUMBER)
163: RETURN VARCHAR2 is
164:
165: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
166: l_cash_receipt_flag NUMBER DEFAULT NULL;
167:
168: CURSOR csr_validate_cash_rcpt_id(l_cash_rcpt_id IN NUMBER) IS
169: SELECT '1'

Line 179: OKL_API.set_message( p_app_name => G_APP_NAME,

175: FETCH csr_validate_cash_rcpt_id INTO l_cash_receipt_flag;
176: CLOSE csr_validate_cash_rcpt_id;
177:
178: IF l_cash_receipt_flag IS NULL THEN
179: OKL_API.set_message( p_app_name => G_APP_NAME,
180: p_msg_name => 'OKL_RCPT_INV_CASH_RCPT');
181: RAISE G_EXCEPTION_HALT_VALIDATION;
182: END IF;
183:

Line 188: l_return_status := OKL_API.G_RET_STS_ERROR;

184: RETURN l_return_status;
185:
186: EXCEPTION
187: WHEN G_EXCEPTION_HALT_VALIDATION THEN
188: l_return_status := OKL_API.G_RET_STS_ERROR;
189: RETURN l_return_status;
190:
191: WHEN OTHERS THEN
192: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

Line 192: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;

188: l_return_status := OKL_API.G_RET_STS_ERROR;
189: RETURN l_return_status;
190:
191: WHEN OTHERS THEN
192: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
193: OKL_API.Set_Message(p_app_name => G_APP_NAME,
194: p_msg_name => G_UNEXPECTED_ERROR,
195: p_token1 => G_SQLCODE_TOKEN,
196: p_token1_value => SQLCODE,

Line 193: OKL_API.Set_Message(p_app_name => G_APP_NAME,

189: RETURN l_return_status;
190:
191: WHEN OTHERS THEN
192: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR ;
193: OKL_API.Set_Message(p_app_name => G_APP_NAME,
194: p_msg_name => G_UNEXPECTED_ERROR,
195: p_token1 => G_SQLCODE_TOKEN,
196: p_token1_value => SQLCODE,
197: p_token2 => G_SQLERRM_TOKEN,

Line 226: x_return_status VARCHAR2(1) DEFAULT OKL_API.G_RET_STS_SUCCESS;

222: l_rcpt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT TRUNC(p_rcpt_rec.receipt_date);
223: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT p_rcpt_rec.gl_date;
224: l_org_id OKL_TRX_CSH_RECEIPT_V.ORG_ID%TYPE DEFAULT p_rcpt_rec.org_id;
225: l_dup_rcpt_flag NUMBER DEFAULT NULL;
226: x_return_status VARCHAR2(1) DEFAULT OKL_API.G_RET_STS_SUCCESS;
227: l_api_name CONSTANT VARCHAR2(30) := 'validate_receipt_attributes';
228: l_remittance_bank_account_id NUMBER DEFAULT p_rcpt_rec.remittance_bank_account_id;
229:
230: l_rcpt_rec rcpt_rec_type := p_rcpt_rec;

Line 261: Elsif ((l_customer_id IS NULL OR l_customer_id = OKL_API.G_MISS_NUM ) AND

257: p_msg_name =>'OKL_BPD_MISSING_FIELDS');
258:
259: RAISE G_EXCEPTION_HALT_VALIDATION;
260: -- Begin - varangan - Bug#6353486 - Sprint3 -Receipts
261: Elsif ((l_customer_id IS NULL OR l_customer_id = OKL_API.G_MISS_NUM ) AND
262: (l_customer_num IS NULL OR l_customer_num = okl_api.g_miss_char) AND
263: (l_rcpt_rec.create_mode <> 'UNAPPLIED' ) ) then
264:
265: -- Message Text: A value must be entered for - COL_NAME.

Line 262: (l_customer_num IS NULL OR l_customer_num = okl_api.g_miss_char) AND

258:
259: RAISE G_EXCEPTION_HALT_VALIDATION;
260: -- Begin - varangan - Bug#6353486 - Sprint3 -Receipts
261: Elsif ((l_customer_id IS NULL OR l_customer_id = OKL_API.G_MISS_NUM ) AND
262: (l_customer_num IS NULL OR l_customer_num = okl_api.g_miss_char) AND
263: (l_rcpt_rec.create_mode <> 'UNAPPLIED' ) ) then
264:
265: -- Message Text: A value must be entered for - COL_NAME.
266: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 288: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

284: log_debug('Receipt Amount validations are done');
285:
286: x_return_status := validate_gl_date(l_gl_date);
287:
288: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
289: RAISE G_EXCEPTION_HALT_VALIDATION;
290: END IF;
291:
292: log_debug('GL_DATE validations are done : ' || x_return_status);

Line 298: x_return_status := OKL_API.G_RET_STS_ERROR;

294: RETURN x_return_status;
295: log_debug('validate_receipt_attributes end');
296: EXCEPTION
297: WHEN G_EXCEPTION_HALT_VALIDATION THEN
298: x_return_status := OKL_API.G_RET_STS_ERROR;
299: RETURN x_return_status;
300:
301: WHEN OTHERS THEN
302: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 302: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

298: x_return_status := OKL_API.G_RET_STS_ERROR;
299: RETURN x_return_status;
300:
301: WHEN OTHERS THEN
302: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
303: Okl_api.set_message( p_app_name => g_app_name
304: , p_msg_name => g_unexpected_error
305: , p_token1 => g_sqlcode_token
306: , p_token1_value => SQLCODE

Line 303: Okl_api.set_message( p_app_name => g_app_name

299: RETURN x_return_status;
300:
301: WHEN OTHERS THEN
302: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
303: Okl_api.set_message( p_app_name => g_app_name
304: , p_msg_name => g_unexpected_error
305: , p_token1 => g_sqlcode_token
306: , p_token1_value => SQLCODE
307: , p_token2 => g_sqlerrm_token

Line 422: x_rcpt_curr_conv_rec.x_return_status := okl_api.g_ret_sts_success;

418: x_rcpt_curr_conv_rec.receipt_currency_code := l_receipt_currency_code;
419: x_rcpt_curr_conv_rec.currency_conv_type := l_currency_conv_type;
420: x_rcpt_curr_conv_rec.currency_conv_date := l_currency_conv_date;
421: x_rcpt_curr_conv_rec.currency_conv_rate := l_currency_conv_rate;
422: x_rcpt_curr_conv_rec.x_return_status := okl_api.g_ret_sts_success;
423: RETURN x_rcpt_curr_conv_rec;
424: EXCEPTION
425:
426: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 427: x_rcpt_curr_conv_rec.x_return_status := OKL_API.G_RET_STS_ERROR;

423: RETURN x_rcpt_curr_conv_rec;
424: EXCEPTION
425:
426: WHEN G_EXCEPTION_HALT_VALIDATION THEN
427: x_rcpt_curr_conv_rec.x_return_status := OKL_API.G_RET_STS_ERROR;
428: RETURN x_rcpt_curr_conv_rec;
429:
430: WHEN OTHERS THEN
431: x_rcpt_curr_conv_rec.x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 431: x_rcpt_curr_conv_rec.x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

427: x_rcpt_curr_conv_rec.x_return_status := OKL_API.G_RET_STS_ERROR;
428: RETURN x_rcpt_curr_conv_rec;
429:
430: WHEN OTHERS THEN
431: x_rcpt_curr_conv_rec.x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
432: Okl_api.set_message( p_app_name => g_app_name
433: , p_msg_name => g_unexpected_error
434: , p_token1 => g_sqlcode_token
435: , p_token1_value => SQLCODE

Line 432: Okl_api.set_message( p_app_name => g_app_name

428: RETURN x_rcpt_curr_conv_rec;
429:
430: WHEN OTHERS THEN
431: x_rcpt_curr_conv_rec.x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
432: Okl_api.set_message( p_app_name => g_app_name
433: , p_msg_name => g_unexpected_error
434: , p_token1 => g_sqlcode_token
435: , p_token1_value => SQLCODE
436: , p_token2 => g_sqlerrm_token

Line 454: x_return_status := okl_api.g_ret_sts_success;

450: x_rcpt_curr_conv_rec rcpt_curr_conv_rec_type;
451:
452: BEGIN
453: log_debug('validate_receipt_details start +');
454: x_return_status := okl_api.g_ret_sts_success;
455: log_debug('p_rcpt_rec.cash_receipt_id = '||p_rcpt_rec.cash_receipt_id);
456: IF p_rcpt_rec.cash_receipt_id IS NULL THEN
457: --do create mode validations
458: log_debug('p_rcpt_rec.RECEIPT_NUMBER = '||p_rcpt_rec.RECEIPT_NUMBER);

Line 459: IF p_rcpt_rec.RECEIPT_NUMBER IS NULL OR p_rcpt_rec.RECEIPT_NUMBER = OKL_API.G_MISS_CHAR THEN

455: log_debug('p_rcpt_rec.cash_receipt_id = '||p_rcpt_rec.cash_receipt_id);
456: IF p_rcpt_rec.cash_receipt_id IS NULL THEN
457: --do create mode validations
458: log_debug('p_rcpt_rec.RECEIPT_NUMBER = '||p_rcpt_rec.RECEIPT_NUMBER);
459: IF p_rcpt_rec.RECEIPT_NUMBER IS NULL OR p_rcpt_rec.RECEIPT_NUMBER = OKL_API.G_MISS_CHAR THEN
460: p_rcpt_rec.RECEIPT_NUMBER := to_char(sysdate, 'MONDDYYYYHH24MISS');
461: END IF;
462: log_debug('calling validate_receipt_attributes');
463: x_return_status := validate_receipt_attributes(p_rcpt_rec);

Line 465: IF x_return_status = OKL_API.G_RET_STS_SUCCESS THEN

461: END IF;
462: log_debug('calling validate_receipt_attributes');
463: x_return_status := validate_receipt_attributes(p_rcpt_rec);
464: log_debug('RETURN status FROM validate_receipt_attributes = '|| x_return_status);
465: IF x_return_status = OKL_API.G_RET_STS_SUCCESS THEN
466: l_rcpt_curr_conv_rec.receipt_currency_code := p_rcpt_rec.currency_code;
467: l_rcpt_curr_conv_rec.receipt_date := p_rcpt_rec.receipt_date;
468: l_rcpt_curr_conv_rec.currency_conv_date := p_rcpt_rec.exchange_date;
469: l_rcpt_curr_conv_rec.currency_conv_type := p_rcpt_rec.exchange_rate_type;

Line 478: IF p_rcpt_rec.customer_id = okl_api.g_miss_num THEN

474: log_debug('RETURN status FROM validate_currency_conv_params = '|| x_return_status);
475: p_rcpt_rec.exchange_date := x_rcpt_curr_conv_rec.currency_conv_date;
476: p_rcpt_rec.exchange_rate_type := x_rcpt_curr_conv_rec.currency_conv_type;
477: p_rcpt_rec.exchange_rate := x_rcpt_curr_conv_rec.currency_conv_rate;
478: IF p_rcpt_rec.customer_id = okl_api.g_miss_num THEN
479: p_rcpt_rec.customer_id := NULL;
480: END IF;
481: IF p_rcpt_rec.customer_number = okl_api.g_miss_char THEN
482: p_rcpt_rec.customer_number := NULL;

Line 481: IF p_rcpt_rec.customer_number = okl_api.g_miss_char THEN

477: p_rcpt_rec.exchange_rate := x_rcpt_curr_conv_rec.currency_conv_rate;
478: IF p_rcpt_rec.customer_id = okl_api.g_miss_num THEN
479: p_rcpt_rec.customer_id := NULL;
480: END IF;
481: IF p_rcpt_rec.customer_number = okl_api.g_miss_char THEN
482: p_rcpt_rec.customer_number := NULL;
483: END IF;
484: ELSE
485: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 488: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

484: ELSE
485: RAISE G_EXCEPTION_HALT_VALIDATION;
486: END IF;
487:
488: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
489: RAISE G_EXCEPTION_HALT_VALIDATION;
490: END IF;
491:
492: ELSE

Line 502: x_return_status := OKL_API.G_RET_STS_ERROR;

498: log_debug('validate_receipt_details end -');
499: EXCEPTION
500:
501: WHEN G_EXCEPTION_HALT_VALIDATION THEN
502: x_return_status := OKL_API.G_RET_STS_ERROR;
503:
504: WHEN OTHERS THEN
505: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
506: Okl_api.set_message( p_app_name => g_app_name

Line 505: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

501: WHEN G_EXCEPTION_HALT_VALIDATION THEN
502: x_return_status := OKL_API.G_RET_STS_ERROR;
503:
504: WHEN OTHERS THEN
505: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
506: Okl_api.set_message( p_app_name => g_app_name
507: , p_msg_name => g_unexpected_error
508: , p_token1 => g_sqlcode_token
509: , p_token1_value => SQLCODE

Line 506: Okl_api.set_message( p_app_name => g_app_name

502: x_return_status := OKL_API.G_RET_STS_ERROR;
503:
504: WHEN OTHERS THEN
505: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
506: Okl_api.set_message( p_app_name => g_app_name
507: , p_msg_name => g_unexpected_error
508: , p_token1 => g_sqlcode_token
509: , p_token1_value => SQLCODE
510: , p_token2 => g_sqlerrm_token

Line 614: OKL_API.set_message( p_app_name => G_APP_NAME,

610: FETCH c_get_orig_freight_amount INTO l_orig_freight_amount;
611: CLOSE c_get_orig_freight_amount;
612: l_total_freight_amount := l_total_freight_amount + l_appl_tbl(i).inv_hdr_rec.freight_amount;
613: IF l_appl_tbl(i).inv_hdr_rec.freight_amount > l_orig_freight_amount THEN
614: OKL_API.set_message( p_app_name => G_APP_NAME,
615: p_msg_name => 'OKL_RCPT_LN_AMT_GT_OUTSTD_AMT',
616: p_token1 => 'AMT_TO_APPLY',
617: p_token1_value => l_appl_tbl(i).inv_hdr_rec.freight_amount,
618: p_token2 => 'OUTSTD_AMOUNT',

Line 630: OKL_API.set_message( p_app_name => G_APP_NAME,

626: FETCH c_get_orig_charges_amount INTO l_orig_charges_amount;
627: CLOSE c_get_orig_charges_amount;
628: l_total_charges_amount := l_total_charges_amount + l_appl_tbl(i).inv_hdr_rec.charges_amount;
629: IF l_appl_tbl(i).inv_hdr_rec.charges_amount > l_orig_charges_amount THEN
630: OKL_API.set_message( p_app_name => G_APP_NAME,
631: p_msg_name => 'OKL_RCPT_LN_AMT_GT_OUTSTD_AMT',
632: p_token1 => 'AMT_TO_APPLY',
633: p_token1_value => l_appl_tbl(i).inv_hdr_rec.charges_amount,
634: p_token2 => 'OUTSTD_AMOUNT',

Line 644: IF x_return_status = OKL_API.G_RET_STS_SUCCESS THEN

640: IF l_appl_tbl(i).inv_lines_tbl.COUNT > 0 THEN
641: FOR j in l_appl_tbl(i).inv_lines_tbl.FIRST..l_appl_tbl(i).inv_lines_tbl.LAST LOOP
642: x_return_status := validate_amount_to_apply(l_appl_tbl(i).inv_lines_tbl(j).amount_applied);
643: log_debug( 'RETURN Status FROM validate_amount_to_apply = '|| x_return_status);
644: IF x_return_status = OKL_API.G_RET_STS_SUCCESS THEN
645:
646: log_debug( 'l_line_orig_amount FROM validate_receipt_applications = '|| l_line_orig_amount);
647: log_debug( 'l_appl_tbl(i).inv_lines_tbl(j).amount_applied FROM validate_receipt_applications = '|| l_appl_tbl(i).inv_lines_tbl(j).amount_applied);
648:

Line 654: OKL_API.set_message( p_app_name => G_APP_NAME,

650: l_line_orig_amount := Okl_Billing_Util_Pvt.invoice_line_amount_orig(
651: l_appl_tbl(i).inv_hdr_rec.invoice_id,l_appl_tbl(i).inv_lines_tbl(j).invoice_line_id);
652:
653: IF l_appl_tbl(i).inv_lines_tbl(j).amount_applied > l_line_orig_amount THEN
654: OKL_API.set_message( p_app_name => G_APP_NAME,
655: p_msg_name => 'OKL_RCPT_LN_AMT_GT_OUTSTD_AMT',
656: p_token1 => 'AMT_TO_APPLY',
657: p_token1_value => l_appl_tbl(i).inv_lines_tbl(j).amount_applied,
658: p_token2 => 'OUTSTD_AMOUNT',

Line 743: OKL_API.set_message( p_app_name => G_APP_NAME,

739: log_debug( 'receipt amount in validation FROM validate_receipt_applications = '|| l_rcpt_amount);
740:
741: IF (l_total_outstanding_amount + l_onacc_amount +
742: l_total_charges_amount + l_total_freight_amount) > l_rcpt_amount THEN
743: OKL_API.set_message( p_app_name => G_APP_NAME,
744: p_msg_name => 'OKL_RCPT_TOT_AMT_GT_UNAPP_AMT');
745:
746: RAISE G_EXCEPTION_HALT_VALIDATION;
747: END IF;

Line 752: x_return_status := OKL_API.G_RET_STS_ERROR;

748:
749: EXCEPTION
750:
751: WHEN G_EXCEPTION_HALT_VALIDATION THEN
752: x_return_status := OKL_API.G_RET_STS_ERROR;
753:
754: WHEN OTHERS THEN
755: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
756: Okl_api.set_message( p_app_name => g_app_name

Line 755: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

751: WHEN G_EXCEPTION_HALT_VALIDATION THEN
752: x_return_status := OKL_API.G_RET_STS_ERROR;
753:
754: WHEN OTHERS THEN
755: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
756: Okl_api.set_message( p_app_name => g_app_name
757: , p_msg_name => g_unexpected_error
758: , p_token1 => g_sqlcode_token
759: , p_token1_value => SQLCODE

Line 756: Okl_api.set_message( p_app_name => g_app_name

752: x_return_status := OKL_API.G_RET_STS_ERROR;
753:
754: WHEN OTHERS THEN
755: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
756: Okl_api.set_message( p_app_name => g_app_name
757: , p_msg_name => g_unexpected_error
758: , p_token1 => g_sqlcode_token
759: , p_token1_value => SQLCODE
760: , p_token2 => g_sqlerrm_token

Line 770: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false,

766: -- If the customer account passed, then it will create an Unapplied receipt
767: -- If the customer account value is null, then it will create an Unidentified receipt
768: PROCEDURE create_unapplied_receipt
769: (p_api_version IN NUMBER,
770: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false,
771: x_return_status OUT NOCOPY VARCHAR2,
772: x_msg_count OUT NOCOPY NUMBER,
773: x_msg_data OUT NOCOPY VARCHAR2,
774: p_rcpt_rec IN RCPT_REC_TYPE,

Line 778: l_init_msg_list VARCHAR2(1) := okl_api.g_false;

774: p_rcpt_rec IN RCPT_REC_TYPE,
775: x_cash_receipt_id OUT NOCOPY NUMBER)
776: IS
777: l_api_version NUMBER := 1.0;
778: l_init_msg_list VARCHAR2(1) := okl_api.g_false;
779: l_return_status VARCHAR2(1);
780: l_msg_count NUMBER;
781: l_msg_data VARCHAR2(2000);
782: l_api_name CONSTANT VARCHAR2(30) := 'create_unapplied_receipt';

Line 787: l_return_status := okl_api.start_activity(l_api_name,

783: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
784: l_rcpt_rec RCPT_REC_TYPE;
785: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;
786: BEGIN
787: l_return_status := okl_api.start_activity(l_api_name,
788: g_pkg_name,
789: p_init_msg_list,
790: l_api_version,
791: p_api_version,

Line 795: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

791: p_api_version,
792: '_PVT',
793: l_return_status);
794:
795: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
796: RAISE okl_api.g_exception_unexpected_error;
797: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
798: RAISE okl_api.g_exception_error;
799: END IF;

Line 796: RAISE okl_api.g_exception_unexpected_error;

792: '_PVT',
793: l_return_status);
794:
795: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
796: RAISE okl_api.g_exception_unexpected_error;
797: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
798: RAISE okl_api.g_exception_error;
799: END IF;
800: l_rcpt_rec := p_rcpt_rec;

Line 797: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

793: l_return_status);
794:
795: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
796: RAISE okl_api.g_exception_unexpected_error;
797: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
798: RAISE okl_api.g_exception_error;
799: END IF;
800: l_rcpt_rec := p_rcpt_rec;
801: l_attribute_rec.attribute_category := l_rcpt_rec.dff_attribute_category;

Line 798: RAISE okl_api.g_exception_error;

794:
795: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
796: RAISE okl_api.g_exception_unexpected_error;
797: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
798: RAISE okl_api.g_exception_error;
799: END IF;
800: l_rcpt_rec := p_rcpt_rec;
801: l_attribute_rec.attribute_category := l_rcpt_rec.dff_attribute_category;
802: l_attribute_rec.attribute1 := l_rcpt_rec.dff_attribute1;

Line 845: IF x_return_status <> okl_api.g_ret_sts_success THEN

841: x_cash_receipt_id := l_cash_receipt_id;
842:
843: x_return_status := l_return_status;
844:
845: IF x_return_status <> okl_api.g_ret_sts_success THEN
846: -- Message Text: Error creating receipt in AR
847:
848: x_return_status := okl_api.g_ret_sts_error;
849:

Line 848: x_return_status := okl_api.g_ret_sts_error;

844:
845: IF x_return_status <> okl_api.g_ret_sts_success THEN
846: -- Message Text: Error creating receipt in AR
847:
848: x_return_status := okl_api.g_ret_sts_error;
849:
850: okl_api.set_message(p_app_name => g_app_name,p_msg_name => 'OKL_BPD_ERR_CRT_RCT_AR');
851:
852: RAISE g_exception_halt_validation;

Line 850: okl_api.set_message(p_app_name => g_app_name,p_msg_name => 'OKL_BPD_ERR_CRT_RCT_AR');

846: -- Message Text: Error creating receipt in AR
847:
848: x_return_status := okl_api.g_ret_sts_error;
849:
850: okl_api.set_message(p_app_name => g_app_name,p_msg_name => 'OKL_BPD_ERR_CRT_RCT_AR');
851:
852: RAISE g_exception_halt_validation;
853: END IF;
854:

Line 856: okl_api.end_activity(l_msg_count,l_msg_data);

852: RAISE g_exception_halt_validation;
853: END IF;
854:
855:
856: okl_api.end_activity(l_msg_count,l_msg_data);
857:
858: x_msg_data := l_msg_data;
859:
860: x_msg_count := l_msg_count;

Line 863: x_return_status := okl_api.g_ret_sts_error;

859:
860: x_msg_count := l_msg_count;
861: EXCEPTION
862: WHEN g_exception_halt_validation THEN
863: x_return_status := okl_api.g_ret_sts_error;
864: WHEN OKL_API.G_EXCEPTION_ERROR THEN
865: x_return_status := OKL_API.HANDLE_EXCEPTIONS
866: (
867: l_api_name,

Line 864: WHEN OKL_API.G_EXCEPTION_ERROR THEN

860: x_msg_count := l_msg_count;
861: EXCEPTION
862: WHEN g_exception_halt_validation THEN
863: x_return_status := okl_api.g_ret_sts_error;
864: WHEN OKL_API.G_EXCEPTION_ERROR THEN
865: x_return_status := OKL_API.HANDLE_EXCEPTIONS
866: (
867: l_api_name,
868: G_PKG_NAME,

Line 865: x_return_status := OKL_API.HANDLE_EXCEPTIONS

861: EXCEPTION
862: WHEN g_exception_halt_validation THEN
863: x_return_status := okl_api.g_ret_sts_error;
864: WHEN OKL_API.G_EXCEPTION_ERROR THEN
865: x_return_status := OKL_API.HANDLE_EXCEPTIONS
866: (
867: l_api_name,
868: G_PKG_NAME,
869: 'OKL_API.G_RET_STS_ERROR',

Line 869: 'OKL_API.G_RET_STS_ERROR',

865: x_return_status := OKL_API.HANDLE_EXCEPTIONS
866: (
867: l_api_name,
868: G_PKG_NAME,
869: 'OKL_API.G_RET_STS_ERROR',
870: x_msg_count,
871: x_msg_data,
872: '_PVT'
873: );

Line 876: x_return_status := OKL_API.HANDLE_EXCEPTIONS

872: '_PVT'
873: );
874:
875: WHEN OTHERS THEN
876: x_return_status := OKL_API.HANDLE_EXCEPTIONS
877: (
878: l_api_name,
879: G_PKG_NAME,
880: 'OTHERS',

Line 885: Okl_api.set_message( p_app_name => g_app_name

881: x_msg_count,
882: x_msg_data,
883: '_PVT'
884: );
885: Okl_api.set_message( p_app_name => g_app_name
886: , p_msg_name => g_unexpected_error
887: , p_token1 => g_sqlcode_token
888: , p_token1_value => SQLCODE
889: , p_token2 => g_sqlerrm_token

Line 896: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false,

892: END create_unapplied_receipt;
893:
894: PROCEDURE create_onaccount_receipt
895: (p_api_version IN NUMBER,
896: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false,
897: x_return_status OUT NOCOPY VARCHAR2,
898: x_msg_count OUT NOCOPY NUMBER,
899: x_msg_data OUT NOCOPY VARCHAR2,
900: p_cons_bill_id IN okl_cnsld_ar_hdrs_v.id%TYPE DEFAULT NULL,

Line 907: l_init_msg_list VARCHAR2(1) := okl_api.g_false;

903: p_rcpt_rec IN RCPT_REC_TYPE,
904: x_cash_receipt_id OUT NOCOPY NUMBER)
905: IS
906: l_api_version NUMBER := 1.0;
907: l_init_msg_list VARCHAR2(1) := okl_api.g_false;
908: l_return_status VARCHAR2(1);
909: l_msg_count NUMBER;
910: l_msg_data VARCHAR2(2000);
911: l_api_name CONSTANT VARCHAR2(30) := 'create_onaccount_receipt';

Line 917: l_return_status := okl_api.start_activity(l_api_name,

913: l_rcpt_rec RCPT_REC_TYPE;
914: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type;
915: BEGIN
916: log_debug('create_onaccount_receipt start ');
917: l_return_status := okl_api.start_activity(l_api_name,
918: g_pkg_name,
919: p_init_msg_list,
920: l_api_version,
921: p_api_version,

Line 925: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

921: p_api_version,
922: '_PVT',
923: l_return_status);
924:
925: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
926: RAISE okl_api.g_exception_unexpected_error;
927: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
928: RAISE okl_api.g_exception_error;
929: END IF;

Line 926: RAISE okl_api.g_exception_unexpected_error;

922: '_PVT',
923: l_return_status);
924:
925: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
926: RAISE okl_api.g_exception_unexpected_error;
927: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
928: RAISE okl_api.g_exception_error;
929: END IF;
930:

Line 927: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

923: l_return_status);
924:
925: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
926: RAISE okl_api.g_exception_unexpected_error;
927: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
928: RAISE okl_api.g_exception_error;
929: END IF;
930:
931: l_rcpt_rec := p_rcpt_rec;

Line 928: RAISE okl_api.g_exception_error;

924:
925: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
926: RAISE okl_api.g_exception_unexpected_error;
927: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
928: RAISE okl_api.g_exception_error;
929: END IF;
930:
931: l_rcpt_rec := p_rcpt_rec;
932:

Line 942: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

938: x_msg_data => l_msg_data,
939: p_rcpt_rec => l_rcpt_rec,
940: x_cash_receipt_id => x_cash_receipt_id);
941: log_debug( 'RETURN Status FROM create_unapplied_receipt = '|| l_return_status);
942: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
943: RAISE okl_api.g_exception_unexpected_error;
944: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
945: RAISE okl_api.g_exception_error;
946: END IF;

Line 943: RAISE okl_api.g_exception_unexpected_error;

939: p_rcpt_rec => l_rcpt_rec,
940: x_cash_receipt_id => x_cash_receipt_id);
941: log_debug( 'RETURN Status FROM create_unapplied_receipt = '|| l_return_status);
942: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
943: RAISE okl_api.g_exception_unexpected_error;
944: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
945: RAISE okl_api.g_exception_error;
946: END IF;
947: l_cash_receipt_id:=x_cash_receipt_id;

Line 944: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

940: x_cash_receipt_id => x_cash_receipt_id);
941: log_debug( 'RETURN Status FROM create_unapplied_receipt = '|| l_return_status);
942: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
943: RAISE okl_api.g_exception_unexpected_error;
944: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
945: RAISE okl_api.g_exception_error;
946: END IF;
947: l_cash_receipt_id:=x_cash_receipt_id;
948:

Line 945: RAISE okl_api.g_exception_error;

941: log_debug( 'RETURN Status FROM create_unapplied_receipt = '|| l_return_status);
942: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
943: RAISE okl_api.g_exception_unexpected_error;
944: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
945: RAISE okl_api.g_exception_error;
946: END IF;
947: l_cash_receipt_id:=x_cash_receipt_id;
948:
949: Ar_receipt_api_pub.Apply_on_account( p_api_version => l_api_version

Line 967: IF x_return_status <> okl_api.g_ret_sts_success THEN

963: x_cash_receipt_id := l_cash_receipt_id;
964:
965: x_return_status := l_return_status;
966:
967: IF x_return_status <> okl_api.g_ret_sts_success THEN
968: -- Message Text: Error creating receipt in AR
969:
970: x_return_status := okl_api.g_ret_sts_error;
971:

Line 970: x_return_status := okl_api.g_ret_sts_error;

966:
967: IF x_return_status <> okl_api.g_ret_sts_success THEN
968: -- Message Text: Error creating receipt in AR
969:
970: x_return_status := okl_api.g_ret_sts_error;
971:
972: -- okl_api.set_message(p_app_name => g_app_name,p_msg_name => 'OKL_BPD_ERR_CRT_RCT_AR');
973:
974: RAISE g_exception_halt_validation;

Line 972: -- okl_api.set_message(p_app_name => g_app_name,p_msg_name => 'OKL_BPD_ERR_CRT_RCT_AR');

968: -- Message Text: Error creating receipt in AR
969:
970: x_return_status := okl_api.g_ret_sts_error;
971:
972: -- okl_api.set_message(p_app_name => g_app_name,p_msg_name => 'OKL_BPD_ERR_CRT_RCT_AR');
973:
974: RAISE g_exception_halt_validation;
975: END IF;
976:

Line 978: okl_api.end_activity(x_msg_count,x_msg_data);

974: RAISE g_exception_halt_validation;
975: END IF;
976:
977:
978: okl_api.end_activity(x_msg_count,x_msg_data);
979:
980: x_msg_data := l_msg_data;
981:
982: x_msg_count := l_msg_count;

Line 985: x_return_status := okl_api.g_ret_sts_error;

981:
982: x_msg_count := l_msg_count;
983: EXCEPTION
984: WHEN g_exception_halt_validation THEN
985: x_return_status := okl_api.g_ret_sts_error;
986: WHEN OKL_API.G_EXCEPTION_ERROR THEN
987: x_return_status := OKL_API.HANDLE_EXCEPTIONS
988: (
989: l_api_name,

Line 986: WHEN OKL_API.G_EXCEPTION_ERROR THEN

982: x_msg_count := l_msg_count;
983: EXCEPTION
984: WHEN g_exception_halt_validation THEN
985: x_return_status := okl_api.g_ret_sts_error;
986: WHEN OKL_API.G_EXCEPTION_ERROR THEN
987: x_return_status := OKL_API.HANDLE_EXCEPTIONS
988: (
989: l_api_name,
990: G_PKG_NAME,

Line 987: x_return_status := OKL_API.HANDLE_EXCEPTIONS

983: EXCEPTION
984: WHEN g_exception_halt_validation THEN
985: x_return_status := okl_api.g_ret_sts_error;
986: WHEN OKL_API.G_EXCEPTION_ERROR THEN
987: x_return_status := OKL_API.HANDLE_EXCEPTIONS
988: (
989: l_api_name,
990: G_PKG_NAME,
991: 'OKL_API.G_RET_STS_ERROR',

Line 991: 'OKL_API.G_RET_STS_ERROR',

987: x_return_status := OKL_API.HANDLE_EXCEPTIONS
988: (
989: l_api_name,
990: G_PKG_NAME,
991: 'OKL_API.G_RET_STS_ERROR',
992: x_msg_count,
993: x_msg_data,
994: '_PVT'
995: );

Line 998: x_return_status := OKL_API.HANDLE_EXCEPTIONS

994: '_PVT'
995: );
996:
997: WHEN OTHERS THEN
998: x_return_status := OKL_API.HANDLE_EXCEPTIONS
999: (
1000: l_api_name,
1001: G_PKG_NAME,
1002: 'OTHERS',

Line 1007: Okl_api.set_message( p_app_name => g_app_name

1003: x_msg_count,
1004: x_msg_data,
1005: '_PVT'
1006: );
1007: Okl_api.set_message( p_app_name => g_app_name
1008: , p_msg_name => g_unexpected_error
1009: , p_token1 => g_sqlcode_token
1010: , p_token1_value => SQLCODE
1011: , p_token2 => g_sqlerrm_token

Line 1017: ,p_init_msg_list IN VARCHAR2 DEFAULT OkL_Api.G_FALSE

1013: ) ;
1014: END create_onaccount_receipt;
1015:
1016: PROCEDURE unapply_receipt ( p_api_version IN NUMBER
1017: ,p_init_msg_list IN VARCHAR2 DEFAULT OkL_Api.G_FALSE
1018: ,x_return_status OUT NOCOPY VARCHAR2
1019: ,x_msg_count OUT NOCOPY NUMBER
1020: ,x_msg_data OUT NOCOPY VARCHAR2
1021: ,p_customer_trx_id IN NUMBER DEFAULT NULL -- cash receipt id

Line 1031: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

1027: -- DECLARE Local Variables
1028: ---------------------------
1029:
1030: l_api_version NUMBER := 1.0;
1031: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
1032: l_return_status VARCHAR2(1);
1033: l_msg_count NUMBER;
1034: l_msg_data VARCHAR2(2000);
1035: l_api_name CONSTANT VARCHAR2(30) := 'unapply_receipt';

Line 1069: l_return_status := OKL_API.G_RET_STS_SUCCESS;

1065: AND CASH_RECEIPT_ID = cp_csh_rcpt_id;
1066: -------------------------------------------------------------------------------
1067: */
1068: BEGIN
1069: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1070:
1071: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
1072: l_return_status := OKL_API.START_ACTIVITY(
1073: p_api_name => l_api_name

Line 1072: l_return_status := OKL_API.START_ACTIVITY(

1068: BEGIN
1069: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1070:
1071: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
1072: l_return_status := OKL_API.START_ACTIVITY(
1073: p_api_name => l_api_name
1074: , p_pkg_name => G_PKG_NAME
1075: , p_init_msg_list => p_init_msg_list
1076: , l_api_version => l_api_version

Line 1081: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1077: , p_api_version => p_api_version
1078: , p_api_type => '_PVT'
1079: , x_return_status => x_return_status);
1080: -- check if activity started successfully
1081: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1082: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1083: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1084: RAISE OKL_API.G_EXCEPTION_ERROR;
1085: END IF;

Line 1082: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1078: , p_api_type => '_PVT'
1079: , x_return_status => x_return_status);
1080: -- check if activity started successfully
1081: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1082: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1083: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1084: RAISE OKL_API.G_EXCEPTION_ERROR;
1085: END IF;
1086:

Line 1083: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1079: , x_return_status => x_return_status);
1080: -- check if activity started successfully
1081: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1082: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1083: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1084: RAISE OKL_API.G_EXCEPTION_ERROR;
1085: END IF;
1086:
1087:

Line 1084: RAISE OKL_API.G_EXCEPTION_ERROR;

1080: -- check if activity started successfully
1081: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1082: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1083: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1084: RAISE OKL_API.G_EXCEPTION_ERROR;
1085: END IF;
1086:
1087:
1088: OPEN c_ver_dup_applic (l_customer_trx_id, l_cash_receipt_id);

Line 1105: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1101: ,p_reversal_gl_date => null
1102: ,p_org_id => l_org_id
1103: );
1104:
1105: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1107: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1108: RAISE OKL_API.G_EXCEPTION_ERROR;
1109: END IF;

Line 1106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1102: ,p_org_id => l_org_id
1103: );
1104:
1105: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1107: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1108: RAISE OKL_API.G_EXCEPTION_ERROR;
1109: END IF;
1110: END IF;

Line 1107: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1103: );
1104:
1105: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1107: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1108: RAISE OKL_API.G_EXCEPTION_ERROR;
1109: END IF;
1110: END IF;
1111:

Line 1108: RAISE OKL_API.G_EXCEPTION_ERROR;

1104:
1105: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1107: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1108: RAISE OKL_API.G_EXCEPTION_ERROR;
1109: END IF;
1110: END IF;
1111:
1112: -- commit the savepoint

Line 1113: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

1109: END IF;
1110: END IF;
1111:
1112: -- commit the savepoint
1113: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1114:
1115: x_return_status := l_return_status;
1116:
1117: EXCEPTION

Line 1118: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1114:
1115: x_return_status := l_return_status;
1116:
1117: EXCEPTION
1118: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1119: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1120: (
1121: l_api_name,
1122: G_PKG_NAME,

Line 1119: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1115: x_return_status := l_return_status;
1116:
1117: EXCEPTION
1118: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1119: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1120: (
1121: l_api_name,
1122: G_PKG_NAME,
1123: 'OKL_API.G_RET_STS_ERROR',

Line 1123: 'OKL_API.G_RET_STS_ERROR',

1119: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1120: (
1121: l_api_name,
1122: G_PKG_NAME,
1123: 'OKL_API.G_RET_STS_ERROR',
1124: x_msg_count,
1125: x_msg_data,
1126: '_PVT'
1127: );

Line 1130: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1126: '_PVT'
1127: );
1128:
1129: WHEN OTHERS THEN
1130: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1131: (
1132: l_api_name,
1133: G_PKG_NAME,
1134: 'OTHERS',

Line 1139: Okl_api.set_message( p_app_name => g_app_name

1135: x_msg_count,
1136: x_msg_data,
1137: '_PVT'
1138: );
1139: Okl_api.set_message( p_app_name => g_app_name
1140: , p_msg_name => g_unexpected_error
1141: , p_token1 => g_sqlcode_token
1142: , p_token1_value => SQLCODE
1143: , p_token2 => g_sqlerrm_token

Line 1150: ,p_init_msg_list IN VARCHAR2 DEFAULT OkL_Api.G_FALSE

1146:
1147: END unapply_receipt;
1148:
1149: PROCEDURE apply_receipt( p_api_version IN NUMBER
1150: ,p_init_msg_list IN VARCHAR2 DEFAULT OkL_Api.G_FALSE
1151: ,x_return_status OUT NOCOPY VARCHAR2
1152: ,x_msg_count OUT NOCOPY NUMBER
1153: ,x_msg_data OUT NOCOPY VARCHAR2
1154: ,p_cash_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE

Line 1171: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

1167: -- DECLARE Local Variables
1168: ---------------------------
1169:
1170: l_api_version NUMBER := 1.0;
1171: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
1172: l_return_status VARCHAR2(1);
1173: l_msg_count NUMBER;
1174: l_msg_data VARCHAR2(2000);
1175: l_api_name CONSTANT VARCHAR2(30) := 'apply_receipt';

Line 1239: l_return_status := OKL_API.G_RET_STS_SUCCESS;

1235: --End - handle onaccount - varangan - 6353486
1236:
1237: BEGIN
1238: log_debug('okl_receipts_pvt.apply_receipt start');
1239: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1240:
1241: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
1242: l_return_status := OKL_API.START_ACTIVITY(
1243: p_api_name => l_api_name

Line 1242: l_return_status := OKL_API.START_ACTIVITY(

1238: log_debug('okl_receipts_pvt.apply_receipt start');
1239: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1240:
1241: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
1242: l_return_status := OKL_API.START_ACTIVITY(
1243: p_api_name => l_api_name
1244: , p_pkg_name => G_PKG_NAME
1245: , p_init_msg_list => p_init_msg_list
1246: , l_api_version => l_api_version

Line 1251: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1247: , p_api_version => p_api_version
1248: , p_api_type => '_PVT'
1249: , x_return_status => x_return_status);
1250: -- check if activity started successfully
1251: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1252: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1253: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1254: RAISE OKL_API.G_EXCEPTION_ERROR;
1255: END IF;

Line 1252: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1248: , p_api_type => '_PVT'
1249: , x_return_status => x_return_status);
1250: -- check if activity started successfully
1251: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1252: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1253: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1254: RAISE OKL_API.G_EXCEPTION_ERROR;
1255: END IF;
1256:

Line 1253: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1249: , x_return_status => x_return_status);
1250: -- check if activity started successfully
1251: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1252: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1253: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1254: RAISE OKL_API.G_EXCEPTION_ERROR;
1255: END IF;
1256:
1257: IF l_llca_tbl.COUNT > 0 AND l_llca_tbl(l_llca_tbl.FIRST).invoice_line_id IS NOT NULL THEN

Line 1254: RAISE OKL_API.G_EXCEPTION_ERROR;

1250: -- check if activity started successfully
1251: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1252: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1253: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1254: RAISE OKL_API.G_EXCEPTION_ERROR;
1255: END IF;
1256:
1257: IF l_llca_tbl.COUNT > 0 AND l_llca_tbl(l_llca_tbl.FIRST).invoice_line_id IS NOT NULL THEN
1258: OPEN c_get_cust_trx_id(l_llca_tbl(l_llca_tbl.FIRST).invoice_line_id);

Line 1278: OKL_API.set_message( p_app_name => G_APP_NAME,

1274: l_apply_rcpt_date := l_inv_due_date;
1275: END IF;
1276:
1277: /* IF trunc(l_rcpt_date) > trunc(sysdate) THEN
1278: OKL_API.set_message( p_app_name => G_APP_NAME,
1279: p_msg_name => 'OKL_RCPT_INVLD_APPLN_DATE');
1280: RAISE OKL_API.G_EXCEPTION_ERROR;
1281: END IF;
1282: */

Line 1280: RAISE OKL_API.G_EXCEPTION_ERROR;

1276:
1277: /* IF trunc(l_rcpt_date) > trunc(sysdate) THEN
1278: OKL_API.set_message( p_app_name => G_APP_NAME,
1279: p_msg_name => 'OKL_RCPT_INVLD_APPLN_DATE');
1280: RAISE OKL_API.G_EXCEPTION_ERROR;
1281: END IF;
1282: */
1283:
1284: --udhenuko Commented this code as we fetch the conversion rate directly as input.

Line 1300: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1296: p_cash_receipt_id => l_cash_receipt_id,
1297: p_customer_trx_id => l_customer_trx_id,
1298: p_org_id => l_org_id);
1299: log_debug('return status of unapply_receipt = '||l_return_status);
1300: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1301: RAISE okl_api.g_exception_unexpected_error;
1302: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1303: RAISE okl_api.g_exception_error;
1304: END IF;

Line 1301: RAISE okl_api.g_exception_unexpected_error;

1297: p_customer_trx_id => l_customer_trx_id,
1298: p_org_id => l_org_id);
1299: log_debug('return status of unapply_receipt = '||l_return_status);
1300: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1301: RAISE okl_api.g_exception_unexpected_error;
1302: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1303: RAISE okl_api.g_exception_error;
1304: END IF;
1305:

Line 1302: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1298: p_org_id => l_org_id);
1299: log_debug('return status of unapply_receipt = '||l_return_status);
1300: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1301: RAISE okl_api.g_exception_unexpected_error;
1302: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1303: RAISE okl_api.g_exception_error;
1304: END IF;
1305:
1306: log_debug('l_llca_tbl.count = '||l_llca_tbl.COUNT);

Line 1303: RAISE okl_api.g_exception_error;

1299: log_debug('return status of unapply_receipt = '||l_return_status);
1300: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1301: RAISE okl_api.g_exception_unexpected_error;
1302: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1303: RAISE okl_api.g_exception_error;
1304: END IF;
1305:
1306: log_debug('l_llca_tbl.count = '||l_llca_tbl.COUNT);
1307: IF l_llca_tbl.COUNT > 0 THEN

Line 1376: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1372: );
1373: log_debug('Return status of AR_RECEIPT_API_PUB.apply = '|| l_return_status);
1374: END IF;
1375:
1376: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1377: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1378: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1379: RAISE OKL_API.G_EXCEPTION_ERROR;
1380: END IF;

Line 1377: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1373: log_debug('Return status of AR_RECEIPT_API_PUB.apply = '|| l_return_status);
1374: END IF;
1375:
1376: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1377: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1378: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1379: RAISE OKL_API.G_EXCEPTION_ERROR;
1380: END IF;
1381: END IF;

Line 1378: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1374: END IF;
1375:
1376: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1377: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1378: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1379: RAISE OKL_API.G_EXCEPTION_ERROR;
1380: END IF;
1381: END IF;
1382: END IF;

Line 1379: RAISE OKL_API.G_EXCEPTION_ERROR;

1375:
1376: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1377: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1378: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1379: RAISE OKL_API.G_EXCEPTION_ERROR;
1380: END IF;
1381: END IF;
1382: END IF;
1383:

Line 1384: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

1380: END IF;
1381: END IF;
1382: END IF;
1383:
1384: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1385:
1386: x_return_status := l_return_status;
1387: log_debug('okl_receipts_pvt.apply_receipt end');
1388: EXCEPTION

Line 1389: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1385:
1386: x_return_status := l_return_status;
1387: log_debug('okl_receipts_pvt.apply_receipt end');
1388: EXCEPTION
1389: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1390: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1391: (
1392: l_api_name,
1393: G_PKG_NAME,

Line 1390: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1386: x_return_status := l_return_status;
1387: log_debug('okl_receipts_pvt.apply_receipt end');
1388: EXCEPTION
1389: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1390: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1391: (
1392: l_api_name,
1393: G_PKG_NAME,
1394: 'OKL_API.G_RET_STS_ERROR',

Line 1394: 'OKL_API.G_RET_STS_ERROR',

1390: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1391: (
1392: l_api_name,
1393: G_PKG_NAME,
1394: 'OKL_API.G_RET_STS_ERROR',
1395: x_msg_count,
1396: x_msg_data,
1397: '_PVT'
1398: );

Line 1401: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1397: '_PVT'
1398: );
1399:
1400: WHEN OTHERS THEN
1401: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1402: (
1403: l_api_name,
1404: G_PKG_NAME,
1405: 'OTHERS',

Line 1410: Okl_api.set_message( p_app_name => g_app_name

1406: x_msg_count,
1407: x_msg_data,
1408: '_PVT'
1409: );
1410: Okl_api.set_message( p_app_name => g_app_name
1411: , p_msg_name => g_unexpected_error
1412: , p_token1 => g_sqlcode_token
1413: , p_token1_value => SQLCODE
1414: , p_token2 => g_sqlerrm_token

Line 1425: ,p_init_msg_list IN VARCHAR2 DEFAULT OkL_Api.G_FALSE

1421: -- Procedure to Handle Updation of On-Account Amount from Application Page
1422: ************************************************************************************/
1423:
1424: PROCEDURE handle_onacc_update( p_api_version IN NUMBER
1425: ,p_init_msg_list IN VARCHAR2 DEFAULT OkL_Api.G_FALSE
1426: ,x_return_status OUT NOCOPY VARCHAR2
1427: ,x_msg_count OUT NOCOPY NUMBER
1428: ,x_msg_data OUT NOCOPY VARCHAR2
1429: ,p_cash_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE

Line 1442: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

1438: -- DECLARE Local Variables
1439: ---------------------------
1440:
1441: l_api_version NUMBER := 1.0;
1442: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
1443: l_return_status VARCHAR2(1);
1444: l_msg_count NUMBER;
1445: l_msg_data VARCHAR2(2000);
1446: l_api_name CONSTANT VARCHAR2(30) := 'handle_onacc_update';

Line 1480: l_return_status := OKL_API.G_RET_STS_SUCCESS;

1476: --End - handle onaccount - varangan - 6353486
1477:
1478: BEGIN
1479: log_debug('okl_receipts_pvt.Unapply_on_account start');
1480: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1481:
1482: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
1483: l_return_status := OKL_API.START_ACTIVITY(
1484: p_api_name => l_api_name

Line 1483: l_return_status := OKL_API.START_ACTIVITY(

1479: log_debug('okl_receipts_pvt.Unapply_on_account start');
1480: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1481:
1482: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
1483: l_return_status := OKL_API.START_ACTIVITY(
1484: p_api_name => l_api_name
1485: , p_pkg_name => G_PKG_NAME
1486: , p_init_msg_list => p_init_msg_list
1487: , l_api_version => l_api_version

Line 1492: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1488: , p_api_version => p_api_version
1489: , p_api_type => '_PVT'
1490: , x_return_status => x_return_status);
1491: -- check if activity started successfully
1492: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1493: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1494: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1495: RAISE OKL_API.G_EXCEPTION_ERROR;
1496: END IF;

Line 1493: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1489: , p_api_type => '_PVT'
1490: , x_return_status => x_return_status);
1491: -- check if activity started successfully
1492: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1493: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1494: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1495: RAISE OKL_API.G_EXCEPTION_ERROR;
1496: END IF;
1497:

Line 1494: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1490: , x_return_status => x_return_status);
1491: -- check if activity started successfully
1492: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1493: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1494: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1495: RAISE OKL_API.G_EXCEPTION_ERROR;
1496: END IF;
1497:
1498:

Line 1495: RAISE OKL_API.G_EXCEPTION_ERROR;

1491: -- check if activity started successfully
1492: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1493: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1494: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1495: RAISE OKL_API.G_EXCEPTION_ERROR;
1496: END IF;
1497:
1498:
1499: --Check if there is existing on-account amount

Line 1520: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1516: p_reversal_gl_date => NULL,
1517: p_org_id => l_org_id
1518: );
1519: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
1520: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1522: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1523: RAISE OKL_API.G_EXCEPTION_ERROR;
1524: END IF;

Line 1521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1517: p_org_id => l_org_id
1518: );
1519: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
1520: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1522: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1523: RAISE OKL_API.G_EXCEPTION_ERROR;
1524: END IF;
1525: END IF;

Line 1522: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1518: );
1519: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
1520: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1522: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1523: RAISE OKL_API.G_EXCEPTION_ERROR;
1524: END IF;
1525: END IF;
1526: END IF;

Line 1523: RAISE OKL_API.G_EXCEPTION_ERROR;

1519: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
1520: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1522: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1523: RAISE OKL_API.G_EXCEPTION_ERROR;
1524: END IF;
1525: END IF;
1526: END IF;
1527: -- Check if any On-Account amount to be applied

Line 1546: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1542: ,p_apply_gl_date => l_gl_date
1543: ,p_org_id => l_org_id
1544: );
1545: log_debug('Return status of AR_RECEIPT_API_PUB.Apply_on_account = '|| l_return_status);
1546: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1548: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1549: RAISE OKL_API.G_EXCEPTION_ERROR;
1550: END IF;

Line 1547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1543: ,p_org_id => l_org_id
1544: );
1545: log_debug('Return status of AR_RECEIPT_API_PUB.Apply_on_account = '|| l_return_status);
1546: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1548: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1549: RAISE OKL_API.G_EXCEPTION_ERROR;
1550: END IF;
1551: END IF;

Line 1548: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1544: );
1545: log_debug('Return status of AR_RECEIPT_API_PUB.Apply_on_account = '|| l_return_status);
1546: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1548: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1549: RAISE OKL_API.G_EXCEPTION_ERROR;
1550: END IF;
1551: END IF;
1552:

Line 1549: RAISE OKL_API.G_EXCEPTION_ERROR;

1545: log_debug('Return status of AR_RECEIPT_API_PUB.Apply_on_account = '|| l_return_status);
1546: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1548: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1549: RAISE OKL_API.G_EXCEPTION_ERROR;
1550: END IF;
1551: END IF;
1552:
1553: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 1553: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

1549: RAISE OKL_API.G_EXCEPTION_ERROR;
1550: END IF;
1551: END IF;
1552:
1553: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1554:
1555: x_return_status := l_return_status;
1556: log_debug('okl_receipts_pvt.handle_onacc_update end');
1557: EXCEPTION

Line 1558: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1554:
1555: x_return_status := l_return_status;
1556: log_debug('okl_receipts_pvt.handle_onacc_update end');
1557: EXCEPTION
1558: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1559: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1560: (
1561: l_api_name,
1562: G_PKG_NAME,

Line 1559: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1555: x_return_status := l_return_status;
1556: log_debug('okl_receipts_pvt.handle_onacc_update end');
1557: EXCEPTION
1558: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1559: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1560: (
1561: l_api_name,
1562: G_PKG_NAME,
1563: 'OKL_API.G_RET_STS_ERROR',

Line 1563: 'OKL_API.G_RET_STS_ERROR',

1559: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1560: (
1561: l_api_name,
1562: G_PKG_NAME,
1563: 'OKL_API.G_RET_STS_ERROR',
1564: x_msg_count,
1565: x_msg_data,
1566: '_PVT'
1567: );

Line 1570: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1566: '_PVT'
1567: );
1568:
1569: WHEN OTHERS THEN
1570: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1571: (
1572: l_api_name,
1573: G_PKG_NAME,
1574: 'OTHERS',

Line 1579: Okl_api.set_message( p_app_name => g_app_name

1575: x_msg_count,
1576: x_msg_data,
1577: '_PVT'
1578: );
1579: Okl_api.set_message( p_app_name => g_app_name
1580: , p_msg_name => g_unexpected_error
1581: , p_token1 => g_sqlcode_token
1582: , p_token1_value => SQLCODE
1583: , p_token2 => g_sqlerrm_token

Line 1592: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false,

1588:
1589:
1590: PROCEDURE handle_receipt
1591: (p_api_version IN NUMBER,
1592: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false,
1593: x_return_status OUT NOCOPY VARCHAR2,
1594: x_msg_count OUT NOCOPY NUMBER,
1595: x_msg_data OUT NOCOPY VARCHAR2,
1596: p_rcpt_rec IN RCPT_REC_TYPE,

Line 1603: l_init_msg_list VARCHAR2(1) := okl_api.g_true;

1599: IS
1600:
1601: l_rcpt_rec RCPT_REC_TYPE DEFAULT p_rcpt_rec;
1602: l_api_version NUMBER := 1.0;
1603: l_init_msg_list VARCHAR2(1) := okl_api.g_true;
1604: l_return_status VARCHAR2(1);
1605: l_msg_count NUMBER;
1606: l_msg_data VARCHAR2(2000);
1607: l_api_name CONSTANT VARCHAR2(30) := 'handle_receipt';

Line 1710: l_return_status := okl_api.start_activity(l_api_name,

1706:
1707: BEGIN
1708: log_debug('okl_receipts_pvt.handle_receipts start +');
1709:
1710: l_return_status := okl_api.start_activity(l_api_name,
1711: g_pkg_name,
1712: p_init_msg_list,
1713: l_api_version,
1714: p_api_version,

Line 1718: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1714: p_api_version,
1715: '_PVT',
1716: l_return_status);
1717:
1718: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1719: RAISE okl_api.g_exception_unexpected_error;
1720: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1721: RAISE okl_api.g_exception_error;
1722: END IF;

Line 1719: RAISE okl_api.g_exception_unexpected_error;

1715: '_PVT',
1716: l_return_status);
1717:
1718: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1719: RAISE okl_api.g_exception_unexpected_error;
1720: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1721: RAISE okl_api.g_exception_error;
1722: END IF;
1723: log_debug('calling validate_receipt_details');

Line 1720: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1716: l_return_status);
1717:
1718: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1719: RAISE okl_api.g_exception_unexpected_error;
1720: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1721: RAISE okl_api.g_exception_error;
1722: END IF;
1723: log_debug('calling validate_receipt_details');
1724: validate_receipt_details( x_return_status => l_return_status,

Line 1721: RAISE okl_api.g_exception_error;

1717:
1718: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1719: RAISE okl_api.g_exception_unexpected_error;
1720: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1721: RAISE okl_api.g_exception_error;
1722: END IF;
1723: log_debug('calling validate_receipt_details');
1724: validate_receipt_details( x_return_status => l_return_status,
1725: p_rcpt_rec => l_rcpt_rec);

Line 1727: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1723: log_debug('calling validate_receipt_details');
1724: validate_receipt_details( x_return_status => l_return_status,
1725: p_rcpt_rec => l_rcpt_rec);
1726: log_debug( 'RETURN Status FROM validate_receipt_details = '|| l_return_status);
1727: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1728: RAISE okl_api.g_exception_unexpected_error;
1729: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1730: RAISE okl_api.g_exception_error;
1731: END IF;

Line 1728: RAISE okl_api.g_exception_unexpected_error;

1724: validate_receipt_details( x_return_status => l_return_status,
1725: p_rcpt_rec => l_rcpt_rec);
1726: log_debug( 'RETURN Status FROM validate_receipt_details = '|| l_return_status);
1727: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1728: RAISE okl_api.g_exception_unexpected_error;
1729: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1730: RAISE okl_api.g_exception_error;
1731: END IF;
1732:

Line 1729: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1725: p_rcpt_rec => l_rcpt_rec);
1726: log_debug( 'RETURN Status FROM validate_receipt_details = '|| l_return_status);
1727: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1728: RAISE okl_api.g_exception_unexpected_error;
1729: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1730: RAISE okl_api.g_exception_error;
1731: END IF;
1732:
1733: IF l_rcpt_rec.cash_receipt_id is NULL OR l_rcpt_rec.cash_receipt_id = okl_api.g_miss_num THEN

Line 1730: RAISE okl_api.g_exception_error;

1726: log_debug( 'RETURN Status FROM validate_receipt_details = '|| l_return_status);
1727: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1728: RAISE okl_api.g_exception_unexpected_error;
1729: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1730: RAISE okl_api.g_exception_error;
1731: END IF;
1732:
1733: IF l_rcpt_rec.cash_receipt_id is NULL OR l_rcpt_rec.cash_receipt_id = okl_api.g_miss_num THEN
1734: log_debug('l_rcpt_rec.CREATE_MODE = '||l_rcpt_rec.CREATE_MODE);

Line 1733: IF l_rcpt_rec.cash_receipt_id is NULL OR l_rcpt_rec.cash_receipt_id = okl_api.g_miss_num THEN

1729: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1730: RAISE okl_api.g_exception_error;
1731: END IF;
1732:
1733: IF l_rcpt_rec.cash_receipt_id is NULL OR l_rcpt_rec.cash_receipt_id = okl_api.g_miss_num THEN
1734: log_debug('l_rcpt_rec.CREATE_MODE = '||l_rcpt_rec.CREATE_MODE);
1735: IF l_rcpt_rec.CREATE_MODE = 'ONACCOUNT' OR l_rcpt_rec.CREATE_MODE = 'ADVANCED' THEN
1736: log_debug('calling create_onaccount_receipt');
1737: create_onaccount_receipt(p_api_version => l_api_version,

Line 1745: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1741: x_msg_data => l_msg_data,
1742: p_rcpt_rec => l_rcpt_rec,
1743: x_cash_receipt_id => x_cash_receipt_id);
1744: log_debug( 'RETURN Status FROM create_onaccount_receipt = '|| l_return_status);
1745: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1746: RAISE okl_api.g_exception_unexpected_error;
1747: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1748: RAISE okl_api.g_exception_error;
1749: END IF;

Line 1746: RAISE okl_api.g_exception_unexpected_error;

1742: p_rcpt_rec => l_rcpt_rec,
1743: x_cash_receipt_id => x_cash_receipt_id);
1744: log_debug( 'RETURN Status FROM create_onaccount_receipt = '|| l_return_status);
1745: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1746: RAISE okl_api.g_exception_unexpected_error;
1747: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1748: RAISE okl_api.g_exception_error;
1749: END IF;
1750: l_cash_receipt_id:=x_cash_receipt_id;

Line 1747: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1743: x_cash_receipt_id => x_cash_receipt_id);
1744: log_debug( 'RETURN Status FROM create_onaccount_receipt = '|| l_return_status);
1745: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1746: RAISE okl_api.g_exception_unexpected_error;
1747: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1748: RAISE okl_api.g_exception_error;
1749: END IF;
1750: l_cash_receipt_id:=x_cash_receipt_id;
1751: ELSIF l_rcpt_rec.CREATE_MODE = 'UNAPPLIED' THEN -- This mode is for both Unapplied and Unidentified receipts

Line 1748: RAISE okl_api.g_exception_error;

1744: log_debug( 'RETURN Status FROM create_onaccount_receipt = '|| l_return_status);
1745: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1746: RAISE okl_api.g_exception_unexpected_error;
1747: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1748: RAISE okl_api.g_exception_error;
1749: END IF;
1750: l_cash_receipt_id:=x_cash_receipt_id;
1751: ELSIF l_rcpt_rec.CREATE_MODE = 'UNAPPLIED' THEN -- This mode is for both Unapplied and Unidentified receipts
1752: log_debug('calling create_unapplied_receipt');

Line 1761: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1757: x_msg_data => l_msg_data,
1758: p_rcpt_rec => l_rcpt_rec,
1759: x_cash_receipt_id => x_cash_receipt_id);
1760: log_debug( 'RETURN Status FROM create_unapplied_receipt = '|| l_return_status);
1761: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1762: RAISE okl_api.g_exception_unexpected_error;
1763: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1764: RAISE okl_api.g_exception_error;
1765: END IF;

Line 1762: RAISE okl_api.g_exception_unexpected_error;

1758: p_rcpt_rec => l_rcpt_rec,
1759: x_cash_receipt_id => x_cash_receipt_id);
1760: log_debug( 'RETURN Status FROM create_unapplied_receipt = '|| l_return_status);
1761: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1762: RAISE okl_api.g_exception_unexpected_error;
1763: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1764: RAISE okl_api.g_exception_error;
1765: END IF;
1766: l_cash_receipt_id:=x_cash_receipt_id;

Line 1763: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1759: x_cash_receipt_id => x_cash_receipt_id);
1760: log_debug( 'RETURN Status FROM create_unapplied_receipt = '|| l_return_status);
1761: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1762: RAISE okl_api.g_exception_unexpected_error;
1763: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1764: RAISE okl_api.g_exception_error;
1765: END IF;
1766: l_cash_receipt_id:=x_cash_receipt_id;
1767: END IF;

Line 1764: RAISE okl_api.g_exception_error;

1760: log_debug( 'RETURN Status FROM create_unapplied_receipt = '|| l_return_status);
1761: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1762: RAISE okl_api.g_exception_unexpected_error;
1763: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1764: RAISE okl_api.g_exception_error;
1765: END IF;
1766: l_cash_receipt_id:=x_cash_receipt_id;
1767: END IF;
1768:

Line 1772: OKL_API.set_message( p_app_name => G_APP_NAME,

1768:
1769: IF l_rcpt_rec.CREATE_MODE = 'ADVANCED' THEN
1770: log_debug( 'GL date not equal = ');
1771: IF l_appl_tbl.count > 1 THEN
1772: OKL_API.set_message( p_app_name => G_APP_NAME,
1773: p_msg_name => 'OKL_RCPT_ONE_CONTRACT_REQD');
1774: RAISE G_EXCEPTION_HALT_VALIDATION;
1775: END IF;
1776: END IF;

Line 1784: IF l_rcpt_rec.customer_id IS NOT NULL AND l_rcpt_rec.customer_id <> okl_api.g_miss_num THEN

1780: OPEN get_rcpt_sts(l_rcpt_rec.cash_receipt_id);
1781: FETCH get_rcpt_sts INTO l_rcpt_status;
1782: CLOSE get_rcpt_sts;
1783: IF l_rcpt_status = 'UNID' THEN
1784: IF l_rcpt_rec.customer_id IS NOT NULL AND l_rcpt_rec.customer_id <> okl_api.g_miss_num THEN
1785:
1786: Ar_receipt_update_api_pub.update_receipt_unid_to_unapp(
1787: p_api_version => l_api_version
1788: ,p_init_msg_list => l_init_msg_list

Line 1797: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1793: ,p_pay_from_customer => l_rcpt_rec.customer_id
1794: ,x_status => x_status
1795: ,p_customer_bank_account_id => l_rcpt_rec.customer_bank_account_id
1796: );
1797: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1798: RAISE okl_api.g_exception_unexpected_error;
1799: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1800: RAISE okl_api.g_exception_error;
1801: END IF;

Line 1798: RAISE okl_api.g_exception_unexpected_error;

1794: ,x_status => x_status
1795: ,p_customer_bank_account_id => l_rcpt_rec.customer_bank_account_id
1796: );
1797: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1798: RAISE okl_api.g_exception_unexpected_error;
1799: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1800: RAISE okl_api.g_exception_error;
1801: END IF;
1802: END IF;

Line 1799: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1795: ,p_customer_bank_account_id => l_rcpt_rec.customer_bank_account_id
1796: );
1797: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1798: RAISE okl_api.g_exception_unexpected_error;
1799: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1800: RAISE okl_api.g_exception_error;
1801: END IF;
1802: END IF;
1803: END IF;

Line 1800: RAISE okl_api.g_exception_error;

1796: );
1797: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1798: RAISE okl_api.g_exception_unexpected_error;
1799: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1800: RAISE okl_api.g_exception_error;
1801: END IF;
1802: END IF;
1803: END IF;
1804: END IF;

Line 1848: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1844: ,l_rcav_tbl
1845: ,x_rctv_rec
1846: ,x_rcav_tbl);
1847: log_debug('Return status of Okl_Rct_Pub.create_internal_trans = '|| l_return_status);
1848: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1849: RAISE okl_api.g_exception_unexpected_error;
1850: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1851: RAISE okl_api.g_exception_error;
1852: END IF;

Line 1849: RAISE okl_api.g_exception_unexpected_error;

1845: ,x_rctv_rec
1846: ,x_rcav_tbl);
1847: log_debug('Return status of Okl_Rct_Pub.create_internal_trans = '|| l_return_status);
1848: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1849: RAISE okl_api.g_exception_unexpected_error;
1850: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1851: RAISE okl_api.g_exception_error;
1852: END IF;
1853: log_debug('l_appl_tbl(i).contract_id : '||l_appl_tbl(i).contract_id);

Line 1850: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1846: ,x_rcav_tbl);
1847: log_debug('Return status of Okl_Rct_Pub.create_internal_trans = '|| l_return_status);
1848: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1849: RAISE okl_api.g_exception_unexpected_error;
1850: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1851: RAISE okl_api.g_exception_error;
1852: END IF;
1853: log_debug('l_appl_tbl(i).contract_id : '||l_appl_tbl(i).contract_id);
1854: log_debug('l_appl_tbl(i).con_inv_id : '||l_appl_tbl(i).con_inv_id);

Line 1851: RAISE okl_api.g_exception_error;

1847: log_debug('Return status of Okl_Rct_Pub.create_internal_trans = '|| l_return_status);
1848: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1849: RAISE okl_api.g_exception_unexpected_error;
1850: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1851: RAISE okl_api.g_exception_error;
1852: END IF;
1853: log_debug('l_appl_tbl(i).contract_id : '||l_appl_tbl(i).contract_id);
1854: log_debug('l_appl_tbl(i).con_inv_id : '||l_appl_tbl(i).con_inv_id);
1855: log_debug('l_appl_tbl(i).ar_inv_id : '||l_appl_tbl(i).ar_inv_id);

Line 1856: IF l_appl_tbl(i).contract_id IS NOT NULL and l_appl_tbl(i).contract_id <> okl_api.g_miss_num THEN

1852: END IF;
1853: log_debug('l_appl_tbl(i).contract_id : '||l_appl_tbl(i).contract_id);
1854: log_debug('l_appl_tbl(i).con_inv_id : '||l_appl_tbl(i).con_inv_id);
1855: log_debug('l_appl_tbl(i).ar_inv_id : '||l_appl_tbl(i).ar_inv_id);
1856: IF l_appl_tbl(i).contract_id IS NOT NULL and l_appl_tbl(i).contract_id <> okl_api.g_miss_num THEN
1857: l_rxh_rec.source_id := l_cash_receipt_id;
1858: l_rxh_rec.khr_id := l_appl_tbl(i).contract_id;
1859: log_debug(' okl_sla_acc_sources_pvt.populate_sources');
1860: okl_sla_acc_sources_pvt.populate_sources(

Line 1870: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1866: ,x_msg_data => l_msg_data
1867: );
1868:
1869: log_debug('Return status of okl_sla_acc_sources_pvt.populate_sources = '|| l_return_status);
1870: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1871: RAISE okl_api.g_exception_unexpected_error;
1872: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1873: RAISE okl_api.g_exception_error;
1874: END IF;

Line 1871: RAISE okl_api.g_exception_unexpected_error;

1867: );
1868:
1869: log_debug('Return status of okl_sla_acc_sources_pvt.populate_sources = '|| l_return_status);
1870: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1871: RAISE okl_api.g_exception_unexpected_error;
1872: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1873: RAISE okl_api.g_exception_error;
1874: END IF;
1875: END IF;

Line 1872: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1868:
1869: log_debug('Return status of okl_sla_acc_sources_pvt.populate_sources = '|| l_return_status);
1870: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1871: RAISE okl_api.g_exception_unexpected_error;
1872: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1873: RAISE okl_api.g_exception_error;
1874: END IF;
1875: END IF;
1876: ELSIF l_appl_tbl(i).contract_id is not null then

Line 1873: RAISE okl_api.g_exception_error;

1869: log_debug('Return status of okl_sla_acc_sources_pvt.populate_sources = '|| l_return_status);
1870: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1871: RAISE okl_api.g_exception_unexpected_error;
1872: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1873: RAISE okl_api.g_exception_error;
1874: END IF;
1875: END IF;
1876: ELSIF l_appl_tbl(i).contract_id is not null then
1877: OPEN c_cont_num(l_appl_tbl(i).contract_id,l_org_id);

Line 1900: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1896: );
1897: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract');
1898: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);
1899: log_debug('l_unapply_amount = '||l_unapply_amount);
1900: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1901: RAISE okl_api.g_exception_unexpected_error;
1902: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1903: RAISE okl_api.g_exception_error;
1904: END IF;

Line 1901: RAISE okl_api.g_exception_unexpected_error;

1897: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract');
1898: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);
1899: log_debug('l_unapply_amount = '||l_unapply_amount);
1900: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1901: RAISE okl_api.g_exception_unexpected_error;
1902: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1903: RAISE okl_api.g_exception_error;
1904: END IF;
1905: l_okl_rcpt_tbl:=x_okl_rcpt_tbl;

Line 1902: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1898: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);
1899: log_debug('l_unapply_amount = '||l_unapply_amount);
1900: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1901: RAISE okl_api.g_exception_unexpected_error;
1902: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1903: RAISE okl_api.g_exception_error;
1904: END IF;
1905: l_okl_rcpt_tbl:=x_okl_rcpt_tbl;
1906: log_debug( 'l_okl_rcpt_tbl= count '|| x_okl_rcpt_tbl.count);

Line 1903: RAISE okl_api.g_exception_error;

1899: log_debug('l_unapply_amount = '||l_unapply_amount);
1900: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1901: RAISE okl_api.g_exception_unexpected_error;
1902: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1903: RAISE okl_api.g_exception_error;
1904: END IF;
1905: l_okl_rcpt_tbl:=x_okl_rcpt_tbl;
1906: log_debug( 'l_okl_rcpt_tbl= count '|| x_okl_rcpt_tbl.count);
1907: IF l_final_appl_tbl.COUNT>0 THEN

Line 1943: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1939: );
1940: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv');
1941: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);
1942: log_debug('l_unapply_amount = '||l_unapply_amount);
1943: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1944: RAISE okl_api.g_exception_unexpected_error;
1945: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1946: RAISE okl_api.g_exception_error;
1947: END IF;

Line 1944: RAISE okl_api.g_exception_unexpected_error;

1940: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv');
1941: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);
1942: log_debug('l_unapply_amount = '||l_unapply_amount);
1943: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1944: RAISE okl_api.g_exception_unexpected_error;
1945: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1946: RAISE okl_api.g_exception_error;
1947: END IF;
1948: l_okl_rcpt_tbl:=x_okl_rcpt_tbl;

Line 1945: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1941: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);
1942: log_debug('l_unapply_amount = '||l_unapply_amount);
1943: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1944: RAISE okl_api.g_exception_unexpected_error;
1945: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1946: RAISE okl_api.g_exception_error;
1947: END IF;
1948: l_okl_rcpt_tbl:=x_okl_rcpt_tbl;
1949: IF l_final_appl_tbl.COUNT>0 THEN

Line 1946: RAISE okl_api.g_exception_error;

1942: log_debug('l_unapply_amount = '||l_unapply_amount);
1943: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1944: RAISE okl_api.g_exception_unexpected_error;
1945: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1946: RAISE okl_api.g_exception_error;
1947: END IF;
1948: l_okl_rcpt_tbl:=x_okl_rcpt_tbl;
1949: IF l_final_appl_tbl.COUNT>0 THEN
1950: l_final_count:=l_final_appl_tbl.LAST+1;

Line 1985: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1981: x_onacc_amount => l_apply_onacc_amount,
1982: x_unapply_amount =>l_unapply_amount
1983: );
1984: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv');
1985: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1986: RAISE okl_api.g_exception_unexpected_error;
1987: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1988: RAISE okl_api.g_exception_error;
1989: END IF;

Line 1986: RAISE okl_api.g_exception_unexpected_error;

1982: x_unapply_amount =>l_unapply_amount
1983: );
1984: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv');
1985: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1986: RAISE okl_api.g_exception_unexpected_error;
1987: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1988: RAISE okl_api.g_exception_error;
1989: END IF;
1990:

Line 1987: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1983: );
1984: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv');
1985: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1986: RAISE okl_api.g_exception_unexpected_error;
1987: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1988: RAISE okl_api.g_exception_error;
1989: END IF;
1990:
1991: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);

Line 1988: RAISE okl_api.g_exception_error;

1984: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv');
1985: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1986: RAISE okl_api.g_exception_unexpected_error;
1987: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1988: RAISE okl_api.g_exception_error;
1989: END IF;
1990:
1991: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);
1992: log_debug('l_unapply_amount = '||l_unapply_amount);

Line 2029: OKL_API.set_message( p_app_name => G_APP_NAME,

2025: l_appl_tbl(i).gl_date IS NOT NULL THEN
2026:
2027: IF l_final_appl_tbl(k).inv_hdr_rec.gl_date <> l_appl_tbl(i).gl_date THEN
2028: log_debug( 'GL date not equal = ');
2029: OKL_API.set_message( p_app_name => G_APP_NAME,
2030: p_msg_name => 'OKL_RCPT_INVLD_GL_DATE_FOR_INV');
2031: RAISE G_EXCEPTION_HALT_VALIDATION;
2032: END IF;
2033: END IF;

Line 2039: OKL_API.set_message( p_app_name => G_APP_NAME,

2035: l_appl_tbl(i).trans_to_receipt_rate IS NOT NULL THEN
2036:
2037: IF l_final_appl_tbl(k).inv_hdr_rec.trans_to_receipt_rate <> l_appl_tbl(i).trans_to_receipt_rate THEN
2038: log_debug( 'GL date not equal = ');
2039: OKL_API.set_message( p_app_name => G_APP_NAME,
2040: p_msg_name => 'OKL_RCPT_INVLD_RATE_FOR_INV');
2041: RAISE G_EXCEPTION_HALT_VALIDATION;
2042: END IF;
2043: END IF;

Line 2097: OKL_API.set_message( p_app_name => G_APP_NAME,

2093: IF l_final_appl_tbl(k).inv_hdr_rec.invoice_id=l_appl_tbl(i).ar_inv_id THEN
2094: IF l_final_appl_tbl(k).inv_hdr_rec.gl_date IS NOT NULL AND
2095: l_appl_tbl(i).gl_date IS NOT NULL THEN
2096: IF l_final_appl_tbl(k).inv_hdr_rec.gl_date <> l_appl_tbl(i).gl_date THEN
2097: OKL_API.set_message( p_app_name => G_APP_NAME,
2098: p_msg_name => 'OKL_RCPT_INVLD_GL_DATE_FOR_INV');
2099: RAISE G_EXCEPTION_HALT_VALIDATION;
2100: END IF;
2101: END IF;

Line 2105: OKL_API.set_message( p_app_name => G_APP_NAME,

2101: END IF;
2102: IF l_final_appl_tbl(k).inv_hdr_rec.trans_to_receipt_rate IS NOT NULL AND
2103: l_appl_tbl(i).trans_to_receipt_rate IS NOT NULL THEN
2104: IF l_final_appl_tbl(k).inv_hdr_rec.trans_to_receipt_rate <> l_appl_tbl(i).trans_to_receipt_rate THEN
2105: OKL_API.set_message( p_app_name => G_APP_NAME,
2106: p_msg_name => 'OKL_RCPT_INVLD_RATE_FOR_INV');
2107: RAISE G_EXCEPTION_HALT_VALIDATION;
2108: END IF;
2109: END IF;

Line 2140: If (l_original_onacc_amount Is Null) Or (l_original_onacc_amount = okl_api.g_miss_num) Then

2136: END IF;
2137: END LOOP;
2138: END IF;
2139: -- Updating the On-Acc variables, if it is null/g_miss_num
2140: If (l_original_onacc_amount Is Null) Or (l_original_onacc_amount = okl_api.g_miss_num) Then
2141: l_original_onacc_amount:= 0;
2142: End If;
2143: If (l_apply_onacc_amount Is Null) Or (l_apply_onacc_amount = okl_api.g_miss_num) Then
2144: l_apply_onacc_amount:=0;

Line 2143: If (l_apply_onacc_amount Is Null) Or (l_apply_onacc_amount = okl_api.g_miss_num) Then

2139: -- Updating the On-Acc variables, if it is null/g_miss_num
2140: If (l_original_onacc_amount Is Null) Or (l_original_onacc_amount = okl_api.g_miss_num) Then
2141: l_original_onacc_amount:= 0;
2142: End If;
2143: If (l_apply_onacc_amount Is Null) Or (l_apply_onacc_amount = okl_api.g_miss_num) Then
2144: l_apply_onacc_amount:=0;
2145: End If;
2146:
2147: log_debug('In the final count before looping'||l_final_appl_tbl.COUNT);

Line 2164: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2160: P_onacc_amount => l_apply_onacc_amount,
2161: x_return_status => l_return_status );
2162:
2163: log_debug( 'RETURN Status FROM validate_receipt_applications = '|| l_return_status);
2164: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2165: RAISE okl_api.g_exception_unexpected_error;
2166: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2167: RAISE okl_api.g_exception_error;
2168: END IF;

Line 2165: RAISE okl_api.g_exception_unexpected_error;

2161: x_return_status => l_return_status );
2162:
2163: log_debug( 'RETURN Status FROM validate_receipt_applications = '|| l_return_status);
2164: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2165: RAISE okl_api.g_exception_unexpected_error;
2166: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2167: RAISE okl_api.g_exception_error;
2168: END IF;
2169: */

Line 2166: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2162:
2163: log_debug( 'RETURN Status FROM validate_receipt_applications = '|| l_return_status);
2164: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2165: RAISE okl_api.g_exception_unexpected_error;
2166: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2167: RAISE okl_api.g_exception_error;
2168: END IF;
2169: */
2170: -- unapply all the applications first which are changing, so that the amount is available for application

Line 2167: RAISE okl_api.g_exception_error;

2163: log_debug( 'RETURN Status FROM validate_receipt_applications = '|| l_return_status);
2164: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2165: RAISE okl_api.g_exception_unexpected_error;
2166: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2167: RAISE okl_api.g_exception_error;
2168: END IF;
2169: */
2170: -- unapply all the applications first which are changing, so that the amount is available for application
2171: FOR i IN l_final_appl_tbl.FIRST..l_final_appl_tbl.LAST LOOP

Line 2177: IF l_freight_amount = OKL_API.G_MISS_NUM OR l_freight_amount = 0 THEN

2173: --any invoice lines are there or not. If no then create one invoice line
2174: --with applied amount 0. Otherwise keep as it is.
2175:
2176: l_freight_amount := l_final_appl_tbl(i).inv_hdr_rec.freight_amount;
2177: IF l_freight_amount = OKL_API.G_MISS_NUM OR l_freight_amount = 0 THEN
2178: l_freight_amount := NULL;
2179: END IF;
2180: l_charges_amount := l_final_appl_tbl(i).inv_hdr_rec.charges_amount;
2181: IF l_charges_amount = OKL_API.G_MISS_NUM OR l_charges_amount = 0 THEN

Line 2181: IF l_charges_amount = OKL_API.G_MISS_NUM OR l_charges_amount = 0 THEN

2177: IF l_freight_amount = OKL_API.G_MISS_NUM OR l_freight_amount = 0 THEN
2178: l_freight_amount := NULL;
2179: END IF;
2180: l_charges_amount := l_final_appl_tbl(i).inv_hdr_rec.charges_amount;
2181: IF l_charges_amount = OKL_API.G_MISS_NUM OR l_charges_amount = 0 THEN
2182: l_charges_amount := NULL;
2183: END IF;
2184: IF (l_freight_amount IS NOT NULL OR l_charges_amount IS NOT NULL) AND
2185: l_final_appl_tbl(i).inv_lines_tbl.count = 0 THEN

Line 2218: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2214: p_cash_receipt_id => l_cash_receipt_id,
2215: p_customer_trx_id => l_final_appl_tbl(i).inv_hdr_rec.invoice_id,
2216: p_org_id => l_org_id);
2217: log_debug('return status of unapply_receipt = '||l_return_status);
2218: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2219: RAISE okl_api.g_exception_unexpected_error;
2220: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2221: RAISE okl_api.g_exception_error;
2222: END IF;

Line 2219: RAISE okl_api.g_exception_unexpected_error;

2215: p_customer_trx_id => l_final_appl_tbl(i).inv_hdr_rec.invoice_id,
2216: p_org_id => l_org_id);
2217: log_debug('return status of unapply_receipt = '||l_return_status);
2218: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2219: RAISE okl_api.g_exception_unexpected_error;
2220: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2221: RAISE okl_api.g_exception_error;
2222: END IF;
2223: END IF;

Line 2220: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2216: p_org_id => l_org_id);
2217: log_debug('return status of unapply_receipt = '||l_return_status);
2218: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2219: RAISE okl_api.g_exception_unexpected_error;
2220: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2221: RAISE okl_api.g_exception_error;
2222: END IF;
2223: END IF;
2224: END IF;

Line 2221: RAISE okl_api.g_exception_error;

2217: log_debug('return status of unapply_receipt = '||l_return_status);
2218: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2219: RAISE okl_api.g_exception_unexpected_error;
2220: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2221: RAISE okl_api.g_exception_error;
2222: END IF;
2223: END IF;
2224: END IF;
2225: END LOOP;

Line 2246: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2242: p_reversal_gl_date => NULL,
2243: p_org_id => l_org_id
2244: );
2245: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
2246: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2247: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2248: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2249: RAISE OKL_API.G_EXCEPTION_ERROR;
2250: END IF;

Line 2247: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2243: p_org_id => l_org_id
2244: );
2245: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
2246: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2247: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2248: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2249: RAISE OKL_API.G_EXCEPTION_ERROR;
2250: END IF;
2251: END IF;

Line 2248: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2244: );
2245: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
2246: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2247: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2248: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2249: RAISE OKL_API.G_EXCEPTION_ERROR;
2250: END IF;
2251: END IF;
2252: END IF;

Line 2249: RAISE OKL_API.G_EXCEPTION_ERROR;

2245: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
2246: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2247: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2248: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2249: RAISE OKL_API.G_EXCEPTION_ERROR;
2250: END IF;
2251: END IF;
2252: END IF;
2253: FOR i IN l_final_appl_tbl.FIRST..l_final_appl_tbl.LAST LOOP

Line 2259: IF l_freight_amount = OKL_API.G_MISS_NUM OR l_freight_amount = 0 THEN

2255: --any invoice lines are there or not. If no then create one invoice line
2256: --with applied amount 0. Otherwise keep as it is.
2257: --this code has been moved in above loop where we do unapplication, so commenting it out here
2258: /* l_freight_amount := l_final_appl_tbl(i).inv_hdr_rec.freight_amount;
2259: IF l_freight_amount = OKL_API.G_MISS_NUM OR l_freight_amount = 0 THEN
2260: l_freight_amount := NULL;
2261: END IF;
2262: l_charges_amount := l_final_appl_tbl(i).inv_hdr_rec.charges_amount;
2263: IF l_charges_amount = OKL_API.G_MISS_NUM OR l_charges_amount = 0 THEN

Line 2263: IF l_charges_amount = OKL_API.G_MISS_NUM OR l_charges_amount = 0 THEN

2259: IF l_freight_amount = OKL_API.G_MISS_NUM OR l_freight_amount = 0 THEN
2260: l_freight_amount := NULL;
2261: END IF;
2262: l_charges_amount := l_final_appl_tbl(i).inv_hdr_rec.charges_amount;
2263: IF l_charges_amount = OKL_API.G_MISS_NUM OR l_charges_amount = 0 THEN
2264: l_charges_amount := NULL;
2265: END IF;
2266: IF (l_freight_amount IS NOT NULL OR l_charges_amount IS NOT NULL) AND
2267: l_final_appl_tbl(i).inv_lines_tbl.count = 0 THEN

Line 2303: okl_api.set_message

2299: --Modified usage of profile with AR system options
2300: l_exchange_rate_type := cross_currency_rate_type(l_org_id); --fnd_profile.VALUE ('AR_CROSS_CURRENCY_RATE_TYPE');
2301: IF l_exchange_rate_type IS NULL
2302: THEN
2303: okl_api.set_message
2304: (p_app_name => g_app_name,
2305: p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
2306: );
2307: RAISE g_exception_halt_validation;

Line 2348: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2344: ,p_gl_date => l_rcpt_rec.gl_date
2345: ,p_trans_to_receipt_rate => l_final_appl_tbl(i).inv_hdr_rec.trans_to_receipt_rate
2346: );
2347:
2348: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2349: RAISE okl_api.g_exception_unexpected_error;
2350: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2351: RAISE okl_api.g_exception_error;
2352: END IF;

Line 2349: RAISE okl_api.g_exception_unexpected_error;

2345: ,p_trans_to_receipt_rate => l_final_appl_tbl(i).inv_hdr_rec.trans_to_receipt_rate
2346: );
2347:
2348: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2349: RAISE okl_api.g_exception_unexpected_error;
2350: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2351: RAISE okl_api.g_exception_error;
2352: END IF;
2353: END IF;

Line 2350: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2346: );
2347:
2348: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2349: RAISE okl_api.g_exception_unexpected_error;
2350: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2351: RAISE okl_api.g_exception_error;
2352: END IF;
2353: END IF;
2354: ELSE

Line 2351: RAISE okl_api.g_exception_error;

2347:
2348: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2349: RAISE okl_api.g_exception_unexpected_error;
2350: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2351: RAISE okl_api.g_exception_error;
2352: END IF;
2353: END IF;
2354: ELSE
2355: l_final_appl_tbl(i).inv_hdr_rec.trans_to_receipt_rate := NULL;

Line 2369: OKL_API.set_message( p_app_name => G_APP_NAME,

2365: If l_original_onacc_amount <> l_apply_onacc_amount Then
2366: --Validate the On-Account Amount
2367: IF l_appl_tbl.count = 0 THEN
2368: If l_rcpt_rec.amount < l_apply_onacc_amount THEN
2369: OKL_API.set_message( p_app_name => G_APP_NAME,
2370: p_msg_name => 'OKL_RCPT_TOT_AMT_GT_UNAPP_AMT');
2371:
2372: RAISE G_EXCEPTION_HALT_VALIDATION;
2373: END IF;

Line 2389: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2385: ,p_apply_onacc_amount => l_apply_onacc_amount
2386: ,p_receipt_date => l_rcpt_rec.receipt_date
2387: ,p_gl_date => l_rcpt_rec.gl_date);
2388:
2389: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2390: RAISE okl_api.g_exception_unexpected_error;
2391: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2392: RAISE okl_api.g_exception_error;
2393: END IF;

Line 2390: RAISE okl_api.g_exception_unexpected_error;

2386: ,p_receipt_date => l_rcpt_rec.receipt_date
2387: ,p_gl_date => l_rcpt_rec.gl_date);
2388:
2389: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2390: RAISE okl_api.g_exception_unexpected_error;
2391: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2392: RAISE okl_api.g_exception_error;
2393: END IF;
2394: END IF;

Line 2391: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2387: ,p_gl_date => l_rcpt_rec.gl_date);
2388:
2389: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2390: RAISE okl_api.g_exception_unexpected_error;
2391: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2392: RAISE okl_api.g_exception_error;
2393: END IF;
2394: END IF;
2395:

Line 2392: RAISE okl_api.g_exception_error;

2388:
2389: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2390: RAISE okl_api.g_exception_unexpected_error;
2391: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2392: RAISE okl_api.g_exception_error;
2393: END IF;
2394: END IF;
2395:
2396: --End - Handle On-Account Application

Line 2398: okl_api.end_activity(l_msg_count,l_msg_data);

2394: END IF;
2395:
2396: --End - Handle On-Account Application
2397:
2398: okl_api.end_activity(l_msg_count,l_msg_data);
2399: x_msg_data := l_msg_data;
2400: x_msg_count := l_msg_count;
2401: x_return_status := l_return_status;
2402: log_debug('okl_receipts_pvt.handle_receipt End -');

Line 2405: x_return_status := okl_api.g_ret_sts_error;

2401: x_return_status := l_return_status;
2402: log_debug('okl_receipts_pvt.handle_receipt End -');
2403: EXCEPTION
2404: WHEN g_exception_halt_validation THEN
2405: x_return_status := okl_api.g_ret_sts_error;
2406: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2407: (
2408: l_api_name,
2409: G_PKG_NAME,

Line 2406: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2402: log_debug('okl_receipts_pvt.handle_receipt End -');
2403: EXCEPTION
2404: WHEN g_exception_halt_validation THEN
2405: x_return_status := okl_api.g_ret_sts_error;
2406: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2407: (
2408: l_api_name,
2409: G_PKG_NAME,
2410: 'OKL_API.G_RET_STS_ERROR',

Line 2410: 'OKL_API.G_RET_STS_ERROR',

2406: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2407: (
2408: l_api_name,
2409: G_PKG_NAME,
2410: 'OKL_API.G_RET_STS_ERROR',
2411: x_msg_count,
2412: x_msg_data,
2413: '_PVT'
2414: );

Line 2415: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2411: x_msg_count,
2412: x_msg_data,
2413: '_PVT'
2414: );
2415: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2416: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2417: (
2418: l_api_name,
2419: G_PKG_NAME,

Line 2416: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2412: x_msg_data,
2413: '_PVT'
2414: );
2415: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2416: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2417: (
2418: l_api_name,
2419: G_PKG_NAME,
2420: 'OKL_API.G_RET_STS_ERROR',

Line 2420: 'OKL_API.G_RET_STS_ERROR',

2416: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2417: (
2418: l_api_name,
2419: G_PKG_NAME,
2420: 'OKL_API.G_RET_STS_ERROR',
2421: x_msg_count,
2422: x_msg_data,
2423: '_PVT'
2424: );

Line 2427: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2423: '_PVT'
2424: );
2425:
2426: WHEN OTHERS THEN
2427: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2428: (
2429: l_api_name,
2430: G_PKG_NAME,
2431: 'OTHERS',

Line 2436: Okl_api.set_message( p_app_name => g_app_name

2432: x_msg_count,
2433: x_msg_data,
2434: '_PVT'
2435: );
2436: Okl_api.set_message( p_app_name => g_app_name
2437: , p_msg_name => g_unexpected_error
2438: , p_token1 => g_sqlcode_token
2439: , p_token1_value => SQLCODE
2440: , p_token2 => g_sqlerrm_token

Line 2464: Okl_Api.Set_Message(p_app_name => Okl_Api.G_APP_NAME,

2460:
2461: RETURN l_cc_rate_type;
2462: EXCEPTION
2463: WHEN OTHERS THEN
2464: Okl_Api.Set_Message(p_app_name => Okl_Api.G_APP_NAME,
2465: p_msg_name => 'OKL_UNEXPECTED_ERROR',
2466: p_token1 => 'OKL_SQLCODE',
2467: p_token1_value => SQLCODE,
2468: p_token2 => 'OKL_SQLERRM',