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

APPS.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 1247: l_return_status := OKL_API.G_RET_STS_SUCCESS;

1243: -- bug 6642572 .. get the error messages from gt table .. end
1244:
1245: BEGIN
1246: log_debug('okl_receipts_pvt.apply_receipt start');
1247: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1248:
1249: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
1250: l_return_status := OKL_API.START_ACTIVITY(
1251: p_api_name => l_api_name

Line 1250: l_return_status := OKL_API.START_ACTIVITY(

1246: log_debug('okl_receipts_pvt.apply_receipt start');
1247: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1248:
1249: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
1250: l_return_status := OKL_API.START_ACTIVITY(
1251: p_api_name => l_api_name
1252: , p_pkg_name => G_PKG_NAME
1253: , p_init_msg_list => p_init_msg_list
1254: , l_api_version => l_api_version

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

1255: , p_api_version => p_api_version
1256: , p_api_type => '_PVT'
1257: , x_return_status => x_return_status);
1258: -- check if activity started successfully
1259: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1260: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1261: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1262: RAISE OKL_API.G_EXCEPTION_ERROR;
1263: END IF;

Line 1260: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1256: , p_api_type => '_PVT'
1257: , x_return_status => x_return_status);
1258: -- check if activity started successfully
1259: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1260: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1261: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1262: RAISE OKL_API.G_EXCEPTION_ERROR;
1263: END IF;
1264:

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

1257: , x_return_status => x_return_status);
1258: -- check if activity started successfully
1259: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1260: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1261: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1262: RAISE OKL_API.G_EXCEPTION_ERROR;
1263: END IF;
1264:
1265: IF l_llca_tbl.COUNT > 0 AND l_llca_tbl(l_llca_tbl.FIRST).invoice_line_id IS NOT NULL THEN

Line 1262: RAISE OKL_API.G_EXCEPTION_ERROR;

1258: -- check if activity started successfully
1259: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1260: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1261: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1262: RAISE OKL_API.G_EXCEPTION_ERROR;
1263: END IF;
1264:
1265: IF l_llca_tbl.COUNT > 0 AND l_llca_tbl(l_llca_tbl.FIRST).invoice_line_id IS NOT NULL THEN
1266: OPEN c_get_cust_trx_id(l_llca_tbl(l_llca_tbl.FIRST).invoice_line_id);

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

1282: l_apply_rcpt_date := l_inv_due_date;
1283: END IF;
1284:
1285: /* IF trunc(l_rcpt_date) > trunc(sysdate) THEN
1286: OKL_API.set_message( p_app_name => G_APP_NAME,
1287: p_msg_name => 'OKL_RCPT_INVLD_APPLN_DATE');
1288: RAISE OKL_API.G_EXCEPTION_ERROR;
1289: END IF;
1290: */

Line 1288: RAISE OKL_API.G_EXCEPTION_ERROR;

1284:
1285: /* IF trunc(l_rcpt_date) > trunc(sysdate) THEN
1286: OKL_API.set_message( p_app_name => G_APP_NAME,
1287: p_msg_name => 'OKL_RCPT_INVLD_APPLN_DATE');
1288: RAISE OKL_API.G_EXCEPTION_ERROR;
1289: END IF;
1290: */
1291:
1292: --udhenuko Commented this code as we fetch the conversion rate directly as input.

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

1304: p_cash_receipt_id => l_cash_receipt_id,
1305: p_customer_trx_id => l_customer_trx_id,
1306: p_org_id => l_org_id);
1307: log_debug('return status of unapply_receipt = '||l_return_status);
1308: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1309: RAISE okl_api.g_exception_unexpected_error;
1310: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1311: RAISE okl_api.g_exception_error;
1312: END IF;

Line 1309: RAISE okl_api.g_exception_unexpected_error;

1305: p_customer_trx_id => l_customer_trx_id,
1306: p_org_id => l_org_id);
1307: log_debug('return status of unapply_receipt = '||l_return_status);
1308: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1309: RAISE okl_api.g_exception_unexpected_error;
1310: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1311: RAISE okl_api.g_exception_error;
1312: END IF;
1313:

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

1306: p_org_id => l_org_id);
1307: log_debug('return status of unapply_receipt = '||l_return_status);
1308: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1309: RAISE okl_api.g_exception_unexpected_error;
1310: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1311: RAISE okl_api.g_exception_error;
1312: END IF;
1313:
1314: log_debug('l_llca_tbl.count = '||l_llca_tbl.COUNT);

Line 1311: RAISE okl_api.g_exception_error;

1307: log_debug('return status of unapply_receipt = '||l_return_status);
1308: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1309: RAISE okl_api.g_exception_unexpected_error;
1310: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1311: RAISE okl_api.g_exception_error;
1312: END IF;
1313:
1314: log_debug('l_llca_tbl.count = '||l_llca_tbl.COUNT);
1315: IF l_llca_tbl.COUNT > 0 THEN

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

1380: );
1381: log_debug('Return status of AR_RECEIPT_API_PUB.apply = '|| l_return_status);
1382: END IF;
1383:
1384: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1386: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1387: RAISE OKL_API.G_EXCEPTION_ERROR;
1388: END IF;

Line 1385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1381: log_debug('Return status of AR_RECEIPT_API_PUB.apply = '|| l_return_status);
1382: END IF;
1383:
1384: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1386: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1387: RAISE OKL_API.G_EXCEPTION_ERROR;
1388: END IF;
1389: END IF;

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

1382: END IF;
1383:
1384: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1386: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1387: RAISE OKL_API.G_EXCEPTION_ERROR;
1388: END IF;
1389: END IF;
1390: END IF;

Line 1387: RAISE OKL_API.G_EXCEPTION_ERROR;

1383:
1384: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1386: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1387: RAISE OKL_API.G_EXCEPTION_ERROR;
1388: END IF;
1389: END IF;
1390: END IF;
1391:

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

1388: END IF;
1389: END IF;
1390: END IF;
1391:
1392: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1393:
1394: x_return_status := l_return_status;
1395: log_debug('okl_receipts_pvt.apply_receipt end');
1396:

Line 1399: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1395: log_debug('okl_receipts_pvt.apply_receipt end');
1396:
1397: EXCEPTION
1398:
1399: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1400: -- bug 6642572 .. get the error messages and set the stack. start
1401: if nvl(l_msg_count, 0) = 0 or l_msg_count = OKL_API.g_miss_num then
1402: open get_err_csr;
1403: loop

Line 1401: if nvl(l_msg_count, 0) = 0 or l_msg_count = OKL_API.g_miss_num then

1397: EXCEPTION
1398:
1399: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1400: -- bug 6642572 .. get the error messages and set the stack. start
1401: if nvl(l_msg_count, 0) = 0 or l_msg_count = OKL_API.g_miss_num then
1402: open get_err_csr;
1403: loop
1404: fetch get_err_csr into l_err_rec;
1405: exit when get_err_csr%NOTFOUND;

Line 1407: Okl_Api.SET_MESSAGE(p_app_name => 'FND',

1403: loop
1404: fetch get_err_csr into l_err_rec;
1405: exit when get_err_csr%NOTFOUND;
1406:
1407: Okl_Api.SET_MESSAGE(p_app_name => 'FND',
1408: p_msg_name => 'FND_GENERIC_MESSAGE',
1409: p_token1 => 'MESSAGE',
1410: p_token1_value => l_err_rec.error_message);
1411:

Line 1418: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1414: close get_err_csr;
1415: end if;
1416: -- bug 6642572 .. get the error messages and set the stack . end
1417:
1418: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1419: (
1420: l_api_name,
1421: G_PKG_NAME,
1422: 'OKL_API.G_RET_STS_ERROR',

Line 1422: 'OKL_API.G_RET_STS_ERROR',

1418: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1419: (
1420: l_api_name,
1421: G_PKG_NAME,
1422: 'OKL_API.G_RET_STS_ERROR',
1423: x_msg_count,
1424: x_msg_data,
1425: '_PVT'
1426: );

Line 1429: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1425: '_PVT'
1426: );
1427:
1428: -- bug 6642572 .. get the error messages and set the stack. start
1429: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1430: if nvl(l_msg_count, 0) = 0 or l_msg_count = OKL_API.g_miss_num then
1431: open get_err_csr;
1432: loop
1433: fetch get_err_csr into l_err_rec;

Line 1430: if nvl(l_msg_count, 0) = 0 or l_msg_count = OKL_API.g_miss_num then

1426: );
1427:
1428: -- bug 6642572 .. get the error messages and set the stack. start
1429: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1430: if nvl(l_msg_count, 0) = 0 or l_msg_count = OKL_API.g_miss_num then
1431: open get_err_csr;
1432: loop
1433: fetch get_err_csr into l_err_rec;
1434: exit when get_err_csr%NOTFOUND;

Line 1436: Okl_Api.SET_MESSAGE(p_app_name => 'FND',

1432: loop
1433: fetch get_err_csr into l_err_rec;
1434: exit when get_err_csr%NOTFOUND;
1435:
1436: Okl_Api.SET_MESSAGE(p_app_name => 'FND',
1437: p_msg_name => 'FND_GENERIC_MESSAGE',
1438: p_token1 => 'MESSAGE',
1439: p_token1_value => l_err_rec.error_message);
1440:

Line 1446: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1442: end loop;
1443: close get_err_csr;
1444: end if;
1445:
1446: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1447: (
1448: l_api_name,
1449: G_PKG_NAME,
1450: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1450: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1446: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1447: (
1448: l_api_name,
1449: G_PKG_NAME,
1450: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1451: x_msg_count,
1452: x_msg_data,
1453: '_PVT'
1454: );

Line 1458: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1454: );
1455: -- bug 6642572 .. get the error messages and set the stack . end
1456:
1457: WHEN OTHERS THEN
1458: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1459: (
1460: l_api_name,
1461: G_PKG_NAME,
1462: 'OTHERS',

Line 1467: Okl_api.set_message( p_app_name => g_app_name

1463: x_msg_count,
1464: x_msg_data,
1465: '_PVT'
1466: );
1467: Okl_api.set_message( p_app_name => g_app_name
1468: , p_msg_name => g_unexpected_error
1469: , p_token1 => g_sqlcode_token
1470: , p_token1_value => SQLCODE
1471: , p_token2 => g_sqlerrm_token

Line 1482: ,p_init_msg_list IN VARCHAR2 DEFAULT OkL_Api.G_FALSE

1478: -- Procedure to Handle Updation of On-Account Amount from Application Page
1479: ************************************************************************************/
1480:
1481: PROCEDURE handle_onacc_update( p_api_version IN NUMBER
1482: ,p_init_msg_list IN VARCHAR2 DEFAULT OkL_Api.G_FALSE
1483: ,x_return_status OUT NOCOPY VARCHAR2
1484: ,x_msg_count OUT NOCOPY NUMBER
1485: ,x_msg_data OUT NOCOPY VARCHAR2
1486: ,p_cash_receipt_id IN AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE

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

1495: -- DECLARE Local Variables
1496: ---------------------------
1497:
1498: l_api_version NUMBER := 1.0;
1499: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
1500: l_return_status VARCHAR2(1);
1501: l_msg_count NUMBER;
1502: l_msg_data VARCHAR2(2000);
1503: l_api_name CONSTANT VARCHAR2(30) := 'handle_onacc_update';

Line 1537: l_return_status := OKL_API.G_RET_STS_SUCCESS;

1533: --End - handle onaccount - varangan - 6353486
1534:
1535: BEGIN
1536: log_debug('okl_receipts_pvt.Unapply_on_account start');
1537: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1538:
1539: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
1540: l_return_status := OKL_API.START_ACTIVITY(
1541: p_api_name => l_api_name

Line 1540: l_return_status := OKL_API.START_ACTIVITY(

1536: log_debug('okl_receipts_pvt.Unapply_on_account start');
1537: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1538:
1539: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
1540: l_return_status := OKL_API.START_ACTIVITY(
1541: p_api_name => l_api_name
1542: , p_pkg_name => G_PKG_NAME
1543: , p_init_msg_list => p_init_msg_list
1544: , l_api_version => l_api_version

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

1545: , p_api_version => p_api_version
1546: , p_api_type => '_PVT'
1547: , x_return_status => x_return_status);
1548: -- check if activity started successfully
1549: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1550: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1551: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1552: RAISE OKL_API.G_EXCEPTION_ERROR;
1553: END IF;

Line 1550: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1546: , p_api_type => '_PVT'
1547: , x_return_status => x_return_status);
1548: -- check if activity started successfully
1549: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1550: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1551: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1552: RAISE OKL_API.G_EXCEPTION_ERROR;
1553: END IF;
1554:

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

1547: , x_return_status => x_return_status);
1548: -- check if activity started successfully
1549: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1550: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1551: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1552: RAISE OKL_API.G_EXCEPTION_ERROR;
1553: END IF;
1554:
1555:

Line 1552: RAISE OKL_API.G_EXCEPTION_ERROR;

1548: -- check if activity started successfully
1549: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1550: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1551: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1552: RAISE OKL_API.G_EXCEPTION_ERROR;
1553: END IF;
1554:
1555:
1556: --Check if there is existing on-account amount

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

1573: p_reversal_gl_date => NULL,
1574: p_org_id => l_org_id
1575: );
1576: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
1577: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1578: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1579: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1580: RAISE OKL_API.G_EXCEPTION_ERROR;
1581: END IF;

Line 1578: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1574: p_org_id => l_org_id
1575: );
1576: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
1577: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1578: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1579: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1580: RAISE OKL_API.G_EXCEPTION_ERROR;
1581: END IF;
1582: END IF;

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

1575: );
1576: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
1577: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1578: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1579: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1580: RAISE OKL_API.G_EXCEPTION_ERROR;
1581: END IF;
1582: END IF;
1583: END IF;

Line 1580: RAISE OKL_API.G_EXCEPTION_ERROR;

1576: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
1577: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1578: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1579: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1580: RAISE OKL_API.G_EXCEPTION_ERROR;
1581: END IF;
1582: END IF;
1583: END IF;
1584: -- Check if any On-Account amount to be applied

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

1599: ,p_apply_gl_date => l_gl_date
1600: ,p_org_id => l_org_id
1601: );
1602: log_debug('Return status of AR_RECEIPT_API_PUB.Apply_on_account = '|| l_return_status);
1603: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1605: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1606: RAISE OKL_API.G_EXCEPTION_ERROR;
1607: END IF;

Line 1604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1600: ,p_org_id => l_org_id
1601: );
1602: log_debug('Return status of AR_RECEIPT_API_PUB.Apply_on_account = '|| l_return_status);
1603: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1605: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1606: RAISE OKL_API.G_EXCEPTION_ERROR;
1607: END IF;
1608: END IF;

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

1601: );
1602: log_debug('Return status of AR_RECEIPT_API_PUB.Apply_on_account = '|| l_return_status);
1603: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1605: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1606: RAISE OKL_API.G_EXCEPTION_ERROR;
1607: END IF;
1608: END IF;
1609:

Line 1606: RAISE OKL_API.G_EXCEPTION_ERROR;

1602: log_debug('Return status of AR_RECEIPT_API_PUB.Apply_on_account = '|| l_return_status);
1603: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1605: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1606: RAISE OKL_API.G_EXCEPTION_ERROR;
1607: END IF;
1608: END IF;
1609:
1610: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

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

1606: RAISE OKL_API.G_EXCEPTION_ERROR;
1607: END IF;
1608: END IF;
1609:
1610: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1611:
1612: x_return_status := l_return_status;
1613: log_debug('okl_receipts_pvt.handle_onacc_update end');
1614: EXCEPTION

Line 1615: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1611:
1612: x_return_status := l_return_status;
1613: log_debug('okl_receipts_pvt.handle_onacc_update end');
1614: EXCEPTION
1615: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1616: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1617: (
1618: l_api_name,
1619: G_PKG_NAME,

Line 1616: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1612: x_return_status := l_return_status;
1613: log_debug('okl_receipts_pvt.handle_onacc_update end');
1614: EXCEPTION
1615: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1616: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1617: (
1618: l_api_name,
1619: G_PKG_NAME,
1620: 'OKL_API.G_RET_STS_ERROR',

Line 1620: 'OKL_API.G_RET_STS_ERROR',

1616: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1617: (
1618: l_api_name,
1619: G_PKG_NAME,
1620: 'OKL_API.G_RET_STS_ERROR',
1621: x_msg_count,
1622: x_msg_data,
1623: '_PVT'
1624: );

Line 1627: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1623: '_PVT'
1624: );
1625:
1626: WHEN OTHERS THEN
1627: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1628: (
1629: l_api_name,
1630: G_PKG_NAME,
1631: 'OTHERS',

Line 1636: Okl_api.set_message( p_app_name => g_app_name

1632: x_msg_count,
1633: x_msg_data,
1634: '_PVT'
1635: );
1636: Okl_api.set_message( p_app_name => g_app_name
1637: , p_msg_name => g_unexpected_error
1638: , p_token1 => g_sqlcode_token
1639: , p_token1_value => SQLCODE
1640: , p_token2 => g_sqlerrm_token

Line 1649: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false,

1645:
1646:
1647: PROCEDURE handle_receipt
1648: (p_api_version IN NUMBER,
1649: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false,
1650: x_return_status OUT NOCOPY VARCHAR2,
1651: x_msg_count OUT NOCOPY NUMBER,
1652: x_msg_data OUT NOCOPY VARCHAR2,
1653: p_rcpt_rec IN RCPT_REC_TYPE,

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

1656: IS
1657:
1658: l_rcpt_rec RCPT_REC_TYPE DEFAULT p_rcpt_rec;
1659: l_api_version NUMBER := 1.0;
1660: l_init_msg_list VARCHAR2(1) := okl_api.g_true;
1661: l_return_status VARCHAR2(1);
1662: l_msg_count NUMBER;
1663: l_msg_data VARCHAR2(2000);
1664: l_api_name CONSTANT VARCHAR2(30) := 'handle_receipt';

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

1763:
1764: BEGIN
1765: log_debug('okl_receipts_pvt.handle_receipts start +');
1766:
1767: l_return_status := okl_api.start_activity(l_api_name,
1768: g_pkg_name,
1769: p_init_msg_list,
1770: l_api_version,
1771: p_api_version,

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

1771: p_api_version,
1772: '_PVT',
1773: l_return_status);
1774:
1775: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1776: RAISE okl_api.g_exception_unexpected_error;
1777: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1778: RAISE okl_api.g_exception_error;
1779: END IF;

Line 1776: RAISE okl_api.g_exception_unexpected_error;

1772: '_PVT',
1773: l_return_status);
1774:
1775: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1776: RAISE okl_api.g_exception_unexpected_error;
1777: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1778: RAISE okl_api.g_exception_error;
1779: END IF;
1780: log_debug('calling validate_receipt_details');

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

1773: l_return_status);
1774:
1775: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1776: RAISE okl_api.g_exception_unexpected_error;
1777: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1778: RAISE okl_api.g_exception_error;
1779: END IF;
1780: log_debug('calling validate_receipt_details');
1781: validate_receipt_details( x_return_status => l_return_status,

Line 1778: RAISE okl_api.g_exception_error;

1774:
1775: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1776: RAISE okl_api.g_exception_unexpected_error;
1777: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1778: RAISE okl_api.g_exception_error;
1779: END IF;
1780: log_debug('calling validate_receipt_details');
1781: validate_receipt_details( x_return_status => l_return_status,
1782: p_rcpt_rec => l_rcpt_rec);

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

1780: log_debug('calling validate_receipt_details');
1781: validate_receipt_details( x_return_status => l_return_status,
1782: p_rcpt_rec => l_rcpt_rec);
1783: log_debug( 'RETURN Status FROM validate_receipt_details = '|| l_return_status);
1784: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1785: RAISE okl_api.g_exception_unexpected_error;
1786: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1787: RAISE okl_api.g_exception_error;
1788: END IF;

Line 1785: RAISE okl_api.g_exception_unexpected_error;

1781: validate_receipt_details( x_return_status => l_return_status,
1782: p_rcpt_rec => l_rcpt_rec);
1783: log_debug( 'RETURN Status FROM validate_receipt_details = '|| l_return_status);
1784: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1785: RAISE okl_api.g_exception_unexpected_error;
1786: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1787: RAISE okl_api.g_exception_error;
1788: END IF;
1789:

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

1782: p_rcpt_rec => l_rcpt_rec);
1783: log_debug( 'RETURN Status FROM validate_receipt_details = '|| l_return_status);
1784: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1785: RAISE okl_api.g_exception_unexpected_error;
1786: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1787: RAISE okl_api.g_exception_error;
1788: END IF;
1789:
1790: IF l_rcpt_rec.cash_receipt_id is NULL OR l_rcpt_rec.cash_receipt_id = okl_api.g_miss_num THEN

Line 1787: RAISE okl_api.g_exception_error;

1783: log_debug( 'RETURN Status FROM validate_receipt_details = '|| l_return_status);
1784: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1785: RAISE okl_api.g_exception_unexpected_error;
1786: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1787: RAISE okl_api.g_exception_error;
1788: END IF;
1789:
1790: IF l_rcpt_rec.cash_receipt_id is NULL OR l_rcpt_rec.cash_receipt_id = okl_api.g_miss_num THEN
1791: log_debug('l_rcpt_rec.CREATE_MODE = '||l_rcpt_rec.CREATE_MODE);

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

1786: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1787: RAISE okl_api.g_exception_error;
1788: END IF;
1789:
1790: IF l_rcpt_rec.cash_receipt_id is NULL OR l_rcpt_rec.cash_receipt_id = okl_api.g_miss_num THEN
1791: log_debug('l_rcpt_rec.CREATE_MODE = '||l_rcpt_rec.CREATE_MODE);
1792: IF l_rcpt_rec.CREATE_MODE = 'ONACCOUNT' OR l_rcpt_rec.CREATE_MODE = 'ADVANCED' THEN
1793: log_debug('calling create_onaccount_receipt');
1794: create_onaccount_receipt(p_api_version => l_api_version,

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

1798: x_msg_data => l_msg_data,
1799: p_rcpt_rec => l_rcpt_rec,
1800: x_cash_receipt_id => x_cash_receipt_id);
1801: log_debug( 'RETURN Status FROM create_onaccount_receipt = '|| l_return_status);
1802: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1803: RAISE okl_api.g_exception_unexpected_error;
1804: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1805: RAISE okl_api.g_exception_error;
1806: END IF;

Line 1803: RAISE okl_api.g_exception_unexpected_error;

1799: p_rcpt_rec => l_rcpt_rec,
1800: x_cash_receipt_id => x_cash_receipt_id);
1801: log_debug( 'RETURN Status FROM create_onaccount_receipt = '|| l_return_status);
1802: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1803: RAISE okl_api.g_exception_unexpected_error;
1804: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1805: RAISE okl_api.g_exception_error;
1806: END IF;
1807: l_cash_receipt_id:=x_cash_receipt_id;

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

1800: x_cash_receipt_id => x_cash_receipt_id);
1801: log_debug( 'RETURN Status FROM create_onaccount_receipt = '|| l_return_status);
1802: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1803: RAISE okl_api.g_exception_unexpected_error;
1804: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1805: RAISE okl_api.g_exception_error;
1806: END IF;
1807: l_cash_receipt_id:=x_cash_receipt_id;
1808: ELSIF l_rcpt_rec.CREATE_MODE = 'UNAPPLIED' THEN -- This mode is for both Unapplied and Unidentified receipts

Line 1805: RAISE okl_api.g_exception_error;

1801: log_debug( 'RETURN Status FROM create_onaccount_receipt = '|| l_return_status);
1802: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1803: RAISE okl_api.g_exception_unexpected_error;
1804: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1805: RAISE okl_api.g_exception_error;
1806: END IF;
1807: l_cash_receipt_id:=x_cash_receipt_id;
1808: ELSIF l_rcpt_rec.CREATE_MODE = 'UNAPPLIED' THEN -- This mode is for both Unapplied and Unidentified receipts
1809: log_debug('calling create_unapplied_receipt');

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

1814: x_msg_data => l_msg_data,
1815: p_rcpt_rec => l_rcpt_rec,
1816: x_cash_receipt_id => x_cash_receipt_id);
1817: log_debug( 'RETURN Status FROM create_unapplied_receipt = '|| l_return_status);
1818: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1819: RAISE okl_api.g_exception_unexpected_error;
1820: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1821: RAISE okl_api.g_exception_error;
1822: END IF;

Line 1819: RAISE okl_api.g_exception_unexpected_error;

1815: p_rcpt_rec => l_rcpt_rec,
1816: x_cash_receipt_id => x_cash_receipt_id);
1817: log_debug( 'RETURN Status FROM create_unapplied_receipt = '|| l_return_status);
1818: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1819: RAISE okl_api.g_exception_unexpected_error;
1820: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1821: RAISE okl_api.g_exception_error;
1822: END IF;
1823: l_cash_receipt_id:=x_cash_receipt_id;

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

1816: x_cash_receipt_id => x_cash_receipt_id);
1817: log_debug( 'RETURN Status FROM create_unapplied_receipt = '|| l_return_status);
1818: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1819: RAISE okl_api.g_exception_unexpected_error;
1820: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1821: RAISE okl_api.g_exception_error;
1822: END IF;
1823: l_cash_receipt_id:=x_cash_receipt_id;
1824: END IF;

Line 1821: RAISE okl_api.g_exception_error;

1817: log_debug( 'RETURN Status FROM create_unapplied_receipt = '|| l_return_status);
1818: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1819: RAISE okl_api.g_exception_unexpected_error;
1820: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1821: RAISE okl_api.g_exception_error;
1822: END IF;
1823: l_cash_receipt_id:=x_cash_receipt_id;
1824: END IF;
1825:

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

1825:
1826: IF l_rcpt_rec.CREATE_MODE = 'ADVANCED' THEN
1827: log_debug( 'GL date not equal = ');
1828: IF l_appl_tbl.count > 1 THEN
1829: OKL_API.set_message( p_app_name => G_APP_NAME,
1830: p_msg_name => 'OKL_RCPT_ONE_CONTRACT_REQD');
1831: RAISE G_EXCEPTION_HALT_VALIDATION;
1832: END IF;
1833: END IF;

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

1837: OPEN get_rcpt_sts(l_rcpt_rec.cash_receipt_id);
1838: FETCH get_rcpt_sts INTO l_rcpt_status;
1839: CLOSE get_rcpt_sts;
1840: IF l_rcpt_status = 'UNID' THEN
1841: IF l_rcpt_rec.customer_id IS NOT NULL AND l_rcpt_rec.customer_id <> okl_api.g_miss_num THEN
1842:
1843: Ar_receipt_update_api_pub.update_receipt_unid_to_unapp(
1844: p_api_version => l_api_version
1845: ,p_init_msg_list => l_init_msg_list

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

1850: ,p_pay_from_customer => l_rcpt_rec.customer_id
1851: ,x_status => x_status
1852: ,p_customer_bank_account_id => l_rcpt_rec.customer_bank_account_id
1853: );
1854: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1855: RAISE okl_api.g_exception_unexpected_error;
1856: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1857: RAISE okl_api.g_exception_error;
1858: END IF;

Line 1855: RAISE okl_api.g_exception_unexpected_error;

1851: ,x_status => x_status
1852: ,p_customer_bank_account_id => l_rcpt_rec.customer_bank_account_id
1853: );
1854: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1855: RAISE okl_api.g_exception_unexpected_error;
1856: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1857: RAISE okl_api.g_exception_error;
1858: END IF;
1859: END IF;

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

1852: ,p_customer_bank_account_id => l_rcpt_rec.customer_bank_account_id
1853: );
1854: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1855: RAISE okl_api.g_exception_unexpected_error;
1856: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1857: RAISE okl_api.g_exception_error;
1858: END IF;
1859: END IF;
1860: END IF;

Line 1857: RAISE okl_api.g_exception_error;

1853: );
1854: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1855: RAISE okl_api.g_exception_unexpected_error;
1856: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1857: RAISE okl_api.g_exception_error;
1858: END IF;
1859: END IF;
1860: END IF;
1861: END IF;

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

1901: ,l_rcav_tbl
1902: ,x_rctv_rec
1903: ,x_rcav_tbl);
1904: log_debug('Return status of Okl_Rct_Pub.create_internal_trans = '|| l_return_status);
1905: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1906: RAISE okl_api.g_exception_unexpected_error;
1907: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1908: RAISE okl_api.g_exception_error;
1909: END IF;

Line 1906: RAISE okl_api.g_exception_unexpected_error;

1902: ,x_rctv_rec
1903: ,x_rcav_tbl);
1904: log_debug('Return status of Okl_Rct_Pub.create_internal_trans = '|| l_return_status);
1905: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1906: RAISE okl_api.g_exception_unexpected_error;
1907: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1908: RAISE okl_api.g_exception_error;
1909: END IF;
1910: log_debug('l_appl_tbl(i).contract_id : '||l_appl_tbl(i).contract_id);

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

1903: ,x_rcav_tbl);
1904: log_debug('Return status of Okl_Rct_Pub.create_internal_trans = '|| l_return_status);
1905: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1906: RAISE okl_api.g_exception_unexpected_error;
1907: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1908: RAISE okl_api.g_exception_error;
1909: END IF;
1910: log_debug('l_appl_tbl(i).contract_id : '||l_appl_tbl(i).contract_id);
1911: log_debug('l_appl_tbl(i).con_inv_id : '||l_appl_tbl(i).con_inv_id);

Line 1908: RAISE okl_api.g_exception_error;

1904: log_debug('Return status of Okl_Rct_Pub.create_internal_trans = '|| l_return_status);
1905: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1906: RAISE okl_api.g_exception_unexpected_error;
1907: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1908: RAISE okl_api.g_exception_error;
1909: END IF;
1910: log_debug('l_appl_tbl(i).contract_id : '||l_appl_tbl(i).contract_id);
1911: log_debug('l_appl_tbl(i).con_inv_id : '||l_appl_tbl(i).con_inv_id);
1912: log_debug('l_appl_tbl(i).ar_inv_id : '||l_appl_tbl(i).ar_inv_id);

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

1909: END IF;
1910: log_debug('l_appl_tbl(i).contract_id : '||l_appl_tbl(i).contract_id);
1911: log_debug('l_appl_tbl(i).con_inv_id : '||l_appl_tbl(i).con_inv_id);
1912: log_debug('l_appl_tbl(i).ar_inv_id : '||l_appl_tbl(i).ar_inv_id);
1913: IF l_appl_tbl(i).contract_id IS NOT NULL and l_appl_tbl(i).contract_id <> okl_api.g_miss_num THEN
1914: l_rxh_rec.source_id := l_cash_receipt_id;
1915: l_rxh_rec.khr_id := l_appl_tbl(i).contract_id;
1916: log_debug(' okl_sla_acc_sources_pvt.populate_sources');
1917: okl_sla_acc_sources_pvt.populate_sources(

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

1923: ,x_msg_data => l_msg_data
1924: );
1925:
1926: log_debug('Return status of okl_sla_acc_sources_pvt.populate_sources = '|| l_return_status);
1927: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1928: RAISE okl_api.g_exception_unexpected_error;
1929: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1930: RAISE okl_api.g_exception_error;
1931: END IF;

Line 1928: RAISE okl_api.g_exception_unexpected_error;

1924: );
1925:
1926: log_debug('Return status of okl_sla_acc_sources_pvt.populate_sources = '|| l_return_status);
1927: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1928: RAISE okl_api.g_exception_unexpected_error;
1929: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1930: RAISE okl_api.g_exception_error;
1931: END IF;
1932: END IF;

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

1925:
1926: log_debug('Return status of okl_sla_acc_sources_pvt.populate_sources = '|| l_return_status);
1927: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1928: RAISE okl_api.g_exception_unexpected_error;
1929: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1930: RAISE okl_api.g_exception_error;
1931: END IF;
1932: END IF;
1933: ELSIF l_appl_tbl(i).contract_id is not null then

Line 1930: RAISE okl_api.g_exception_error;

1926: log_debug('Return status of okl_sla_acc_sources_pvt.populate_sources = '|| l_return_status);
1927: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1928: RAISE okl_api.g_exception_unexpected_error;
1929: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1930: RAISE okl_api.g_exception_error;
1931: END IF;
1932: END IF;
1933: ELSIF l_appl_tbl(i).contract_id is not null then
1934: OPEN c_cont_num(l_appl_tbl(i).contract_id,l_org_id);

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

1953: );
1954: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract');
1955: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);
1956: log_debug('l_unapply_amount = '||l_unapply_amount);
1957: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1958: RAISE okl_api.g_exception_unexpected_error;
1959: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1960: RAISE okl_api.g_exception_error;
1961: END IF;

Line 1958: RAISE okl_api.g_exception_unexpected_error;

1954: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_contract');
1955: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);
1956: log_debug('l_unapply_amount = '||l_unapply_amount);
1957: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1958: RAISE okl_api.g_exception_unexpected_error;
1959: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1960: RAISE okl_api.g_exception_error;
1961: END IF;
1962: l_okl_rcpt_tbl:=x_okl_rcpt_tbl;

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

1955: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);
1956: log_debug('l_unapply_amount = '||l_unapply_amount);
1957: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1958: RAISE okl_api.g_exception_unexpected_error;
1959: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1960: RAISE okl_api.g_exception_error;
1961: END IF;
1962: l_okl_rcpt_tbl:=x_okl_rcpt_tbl;
1963: log_debug( 'l_okl_rcpt_tbl= count '|| x_okl_rcpt_tbl.count);

Line 1960: RAISE okl_api.g_exception_error;

1956: log_debug('l_unapply_amount = '||l_unapply_amount);
1957: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1958: RAISE okl_api.g_exception_unexpected_error;
1959: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1960: RAISE okl_api.g_exception_error;
1961: END IF;
1962: l_okl_rcpt_tbl:=x_okl_rcpt_tbl;
1963: log_debug( 'l_okl_rcpt_tbl= count '|| x_okl_rcpt_tbl.count);
1964: IF l_final_appl_tbl.COUNT>0 THEN

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

1996: );
1997: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv');
1998: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);
1999: log_debug('l_unapply_amount = '||l_unapply_amount);
2000: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2001: RAISE okl_api.g_exception_unexpected_error;
2002: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2003: RAISE okl_api.g_exception_error;
2004: END IF;

Line 2001: RAISE okl_api.g_exception_unexpected_error;

1997: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_consinv');
1998: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);
1999: log_debug('l_unapply_amount = '||l_unapply_amount);
2000: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2001: RAISE okl_api.g_exception_unexpected_error;
2002: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2003: RAISE okl_api.g_exception_error;
2004: END IF;
2005: l_okl_rcpt_tbl:=x_okl_rcpt_tbl;

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

1998: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);
1999: log_debug('l_unapply_amount = '||l_unapply_amount);
2000: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2001: RAISE okl_api.g_exception_unexpected_error;
2002: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2003: RAISE okl_api.g_exception_error;
2004: END IF;
2005: l_okl_rcpt_tbl:=x_okl_rcpt_tbl;
2006: IF l_final_appl_tbl.COUNT>0 THEN

Line 2003: RAISE okl_api.g_exception_error;

1999: log_debug('l_unapply_amount = '||l_unapply_amount);
2000: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2001: RAISE okl_api.g_exception_unexpected_error;
2002: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2003: RAISE okl_api.g_exception_error;
2004: END IF;
2005: l_okl_rcpt_tbl:=x_okl_rcpt_tbl;
2006: IF l_final_appl_tbl.COUNT>0 THEN
2007: l_final_count:=l_final_appl_tbl.LAST+1;

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

2038: x_onacc_amount => l_apply_onacc_amount,
2039: x_unapply_amount =>l_unapply_amount
2040: );
2041: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv');
2042: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2043: RAISE okl_api.g_exception_unexpected_error;
2044: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2045: RAISE okl_api.g_exception_error;
2046: END IF;

Line 2043: RAISE okl_api.g_exception_unexpected_error;

2039: x_unapply_amount =>l_unapply_amount
2040: );
2041: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv');
2042: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2043: RAISE okl_api.g_exception_unexpected_error;
2044: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2045: RAISE okl_api.g_exception_error;
2046: END IF;
2047:

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

2040: );
2041: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv');
2042: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2043: RAISE okl_api.g_exception_unexpected_error;
2044: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2045: RAISE okl_api.g_exception_error;
2046: END IF;
2047:
2048: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);

Line 2045: RAISE okl_api.g_exception_error;

2041: log_debug('After okl_auto_cash_appl_rules_pvt.auto_cashapp_for_arinv');
2042: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2043: RAISE okl_api.g_exception_unexpected_error;
2044: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2045: RAISE okl_api.g_exception_error;
2046: END IF;
2047:
2048: log_debug('l_apply_onacc_amount = '||l_apply_onacc_amount);
2049: log_debug('l_unapply_amount = '||l_unapply_amount);

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

2082: l_appl_tbl(i).gl_date IS NOT NULL THEN
2083:
2084: IF l_final_appl_tbl(k).inv_hdr_rec.gl_date <> l_appl_tbl(i).gl_date THEN
2085: log_debug( 'GL date not equal = ');
2086: OKL_API.set_message( p_app_name => G_APP_NAME,
2087: p_msg_name => 'OKL_RCPT_INVLD_GL_DATE_FOR_INV');
2088: RAISE G_EXCEPTION_HALT_VALIDATION;
2089: END IF;
2090: END IF;

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

2092: l_appl_tbl(i).trans_to_receipt_rate IS NOT NULL THEN
2093:
2094: IF l_final_appl_tbl(k).inv_hdr_rec.trans_to_receipt_rate <> l_appl_tbl(i).trans_to_receipt_rate THEN
2095: log_debug( 'GL date not equal = ');
2096: OKL_API.set_message( p_app_name => G_APP_NAME,
2097: p_msg_name => 'OKL_RCPT_INVLD_RATE_FOR_INV');
2098: RAISE G_EXCEPTION_HALT_VALIDATION;
2099: END IF;
2100: END IF;

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

2150: IF l_final_appl_tbl(k).inv_hdr_rec.invoice_id=l_appl_tbl(i).ar_inv_id THEN
2151: IF l_final_appl_tbl(k).inv_hdr_rec.gl_date IS NOT NULL AND
2152: l_appl_tbl(i).gl_date IS NOT NULL THEN
2153: IF l_final_appl_tbl(k).inv_hdr_rec.gl_date <> l_appl_tbl(i).gl_date THEN
2154: OKL_API.set_message( p_app_name => G_APP_NAME,
2155: p_msg_name => 'OKL_RCPT_INVLD_GL_DATE_FOR_INV');
2156: RAISE G_EXCEPTION_HALT_VALIDATION;
2157: END IF;
2158: END IF;

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

2158: END IF;
2159: IF l_final_appl_tbl(k).inv_hdr_rec.trans_to_receipt_rate IS NOT NULL AND
2160: l_appl_tbl(i).trans_to_receipt_rate IS NOT NULL THEN
2161: IF l_final_appl_tbl(k).inv_hdr_rec.trans_to_receipt_rate <> l_appl_tbl(i).trans_to_receipt_rate THEN
2162: OKL_API.set_message( p_app_name => G_APP_NAME,
2163: p_msg_name => 'OKL_RCPT_INVLD_RATE_FOR_INV');
2164: RAISE G_EXCEPTION_HALT_VALIDATION;
2165: END IF;
2166: END IF;

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

2193: END IF;
2194: END LOOP;
2195: END IF;
2196: -- Updating the On-Acc variables, if it is null/g_miss_num
2197: If (l_original_onacc_amount Is Null) Or (l_original_onacc_amount = okl_api.g_miss_num) Then
2198: l_original_onacc_amount:= 0;
2199: End If;
2200: If (l_apply_onacc_amount Is Null) Or (l_apply_onacc_amount = okl_api.g_miss_num) Then
2201: l_apply_onacc_amount:=0;

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

2196: -- Updating the On-Acc variables, if it is null/g_miss_num
2197: If (l_original_onacc_amount Is Null) Or (l_original_onacc_amount = okl_api.g_miss_num) Then
2198: l_original_onacc_amount:= 0;
2199: End If;
2200: If (l_apply_onacc_amount Is Null) Or (l_apply_onacc_amount = okl_api.g_miss_num) Then
2201: l_apply_onacc_amount:=0;
2202: End If;
2203:
2204: log_debug('In the final count before looping'||l_final_appl_tbl.COUNT);

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

2217: P_onacc_amount => l_apply_onacc_amount,
2218: x_return_status => l_return_status );
2219:
2220: log_debug( 'RETURN Status FROM validate_receipt_applications = '|| l_return_status);
2221: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2222: RAISE okl_api.g_exception_unexpected_error;
2223: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2224: RAISE okl_api.g_exception_error;
2225: END IF;

Line 2222: RAISE okl_api.g_exception_unexpected_error;

2218: x_return_status => l_return_status );
2219:
2220: log_debug( 'RETURN Status FROM validate_receipt_applications = '|| l_return_status);
2221: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2222: RAISE okl_api.g_exception_unexpected_error;
2223: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2224: RAISE okl_api.g_exception_error;
2225: END IF;
2226: */

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

2219:
2220: log_debug( 'RETURN Status FROM validate_receipt_applications = '|| l_return_status);
2221: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2222: RAISE okl_api.g_exception_unexpected_error;
2223: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2224: RAISE okl_api.g_exception_error;
2225: END IF;
2226: */
2227: -- unapply all the applications first which are changing, so that the amount is available for application

Line 2224: RAISE okl_api.g_exception_error;

2220: log_debug( 'RETURN Status FROM validate_receipt_applications = '|| l_return_status);
2221: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2222: RAISE okl_api.g_exception_unexpected_error;
2223: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2224: RAISE okl_api.g_exception_error;
2225: END IF;
2226: */
2227: -- unapply all the applications first which are changing, so that the amount is available for application
2228: FOR i IN l_final_appl_tbl.FIRST..l_final_appl_tbl.LAST LOOP

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

2230: --any invoice lines are there or not. If no then create one invoice line
2231: --with applied amount 0. Otherwise keep as it is.
2232:
2233: l_freight_amount := l_final_appl_tbl(i).inv_hdr_rec.freight_amount;
2234: IF l_freight_amount = OKL_API.G_MISS_NUM OR l_freight_amount = 0 THEN
2235: l_freight_amount := NULL;
2236: END IF;
2237: l_charges_amount := l_final_appl_tbl(i).inv_hdr_rec.charges_amount;
2238: IF l_charges_amount = OKL_API.G_MISS_NUM OR l_charges_amount = 0 THEN

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

2234: IF l_freight_amount = OKL_API.G_MISS_NUM OR l_freight_amount = 0 THEN
2235: l_freight_amount := NULL;
2236: END IF;
2237: l_charges_amount := l_final_appl_tbl(i).inv_hdr_rec.charges_amount;
2238: IF l_charges_amount = OKL_API.G_MISS_NUM OR l_charges_amount = 0 THEN
2239: l_charges_amount := NULL;
2240: END IF;
2241: IF (l_freight_amount IS NOT NULL OR l_charges_amount IS NOT NULL) AND
2242: l_final_appl_tbl(i).inv_lines_tbl.count = 0 THEN

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

2271: p_cash_receipt_id => l_cash_receipt_id,
2272: p_customer_trx_id => l_final_appl_tbl(i).inv_hdr_rec.invoice_id,
2273: p_org_id => l_org_id);
2274: log_debug('return status of unapply_receipt = '||l_return_status);
2275: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2276: RAISE okl_api.g_exception_unexpected_error;
2277: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2278: RAISE okl_api.g_exception_error;
2279: END IF;

Line 2276: RAISE okl_api.g_exception_unexpected_error;

2272: p_customer_trx_id => l_final_appl_tbl(i).inv_hdr_rec.invoice_id,
2273: p_org_id => l_org_id);
2274: log_debug('return status of unapply_receipt = '||l_return_status);
2275: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2276: RAISE okl_api.g_exception_unexpected_error;
2277: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2278: RAISE okl_api.g_exception_error;
2279: END IF;
2280: END IF;

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

2273: p_org_id => l_org_id);
2274: log_debug('return status of unapply_receipt = '||l_return_status);
2275: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2276: RAISE okl_api.g_exception_unexpected_error;
2277: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2278: RAISE okl_api.g_exception_error;
2279: END IF;
2280: END IF;
2281: END IF;

Line 2278: RAISE okl_api.g_exception_error;

2274: log_debug('return status of unapply_receipt = '||l_return_status);
2275: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2276: RAISE okl_api.g_exception_unexpected_error;
2277: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2278: RAISE okl_api.g_exception_error;
2279: END IF;
2280: END IF;
2281: END IF;
2282: END LOOP;

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

2299: p_reversal_gl_date => NULL,
2300: p_org_id => l_org_id
2301: );
2302: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
2303: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2304: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2305: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2306: RAISE OKL_API.G_EXCEPTION_ERROR;
2307: END IF;

Line 2304: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2300: p_org_id => l_org_id
2301: );
2302: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
2303: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2304: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2305: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2306: RAISE OKL_API.G_EXCEPTION_ERROR;
2307: END IF;
2308: END IF;

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

2301: );
2302: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
2303: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2304: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2305: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2306: RAISE OKL_API.G_EXCEPTION_ERROR;
2307: END IF;
2308: END IF;
2309: END IF;

Line 2306: RAISE OKL_API.G_EXCEPTION_ERROR;

2302: log_debug('Return status of AR_RECEIPT_API_PUB.Unapply_on_account = '|| l_return_status);
2303: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2304: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2305: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2306: RAISE OKL_API.G_EXCEPTION_ERROR;
2307: END IF;
2308: END IF;
2309: END IF;
2310: FOR i IN l_final_appl_tbl.FIRST..l_final_appl_tbl.LAST LOOP

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

2312: --any invoice lines are there or not. If no then create one invoice line
2313: --with applied amount 0. Otherwise keep as it is.
2314: --this code has been moved in above loop where we do unapplication, so commenting it out here
2315: /* l_freight_amount := l_final_appl_tbl(i).inv_hdr_rec.freight_amount;
2316: IF l_freight_amount = OKL_API.G_MISS_NUM OR l_freight_amount = 0 THEN
2317: l_freight_amount := NULL;
2318: END IF;
2319: l_charges_amount := l_final_appl_tbl(i).inv_hdr_rec.charges_amount;
2320: IF l_charges_amount = OKL_API.G_MISS_NUM OR l_charges_amount = 0 THEN

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

2316: IF l_freight_amount = OKL_API.G_MISS_NUM OR l_freight_amount = 0 THEN
2317: l_freight_amount := NULL;
2318: END IF;
2319: l_charges_amount := l_final_appl_tbl(i).inv_hdr_rec.charges_amount;
2320: IF l_charges_amount = OKL_API.G_MISS_NUM OR l_charges_amount = 0 THEN
2321: l_charges_amount := NULL;
2322: END IF;
2323: IF (l_freight_amount IS NOT NULL OR l_charges_amount IS NOT NULL) AND
2324: l_final_appl_tbl(i).inv_lines_tbl.count = 0 THEN

Line 2360: okl_api.set_message

2356: --Modified usage of profile with AR system options
2357: l_exchange_rate_type := cross_currency_rate_type(l_org_id); --fnd_profile.VALUE ('AR_CROSS_CURRENCY_RATE_TYPE');
2358: IF l_exchange_rate_type IS NULL
2359: THEN
2360: okl_api.set_message
2361: (p_app_name => g_app_name,
2362: p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
2363: );
2364: RAISE g_exception_halt_validation;

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

2401: ,p_gl_date => l_rcpt_rec.gl_date
2402: ,p_trans_to_receipt_rate => l_final_appl_tbl(i).inv_hdr_rec.trans_to_receipt_rate
2403: );
2404:
2405: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2406: RAISE okl_api.g_exception_unexpected_error;
2407: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2408: RAISE okl_api.g_exception_error;
2409: END IF;

Line 2406: RAISE okl_api.g_exception_unexpected_error;

2402: ,p_trans_to_receipt_rate => l_final_appl_tbl(i).inv_hdr_rec.trans_to_receipt_rate
2403: );
2404:
2405: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2406: RAISE okl_api.g_exception_unexpected_error;
2407: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2408: RAISE okl_api.g_exception_error;
2409: END IF;
2410: END IF;

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

2403: );
2404:
2405: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2406: RAISE okl_api.g_exception_unexpected_error;
2407: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2408: RAISE okl_api.g_exception_error;
2409: END IF;
2410: END IF;
2411: ELSE

Line 2408: RAISE okl_api.g_exception_error;

2404:
2405: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2406: RAISE okl_api.g_exception_unexpected_error;
2407: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2408: RAISE okl_api.g_exception_error;
2409: END IF;
2410: END IF;
2411: ELSE
2412: l_final_appl_tbl(i).inv_hdr_rec.trans_to_receipt_rate := NULL;

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

2422: If l_original_onacc_amount <> l_apply_onacc_amount Then
2423: --Validate the On-Account Amount
2424: IF l_appl_tbl.count = 0 THEN
2425: If l_rcpt_rec.amount < l_apply_onacc_amount THEN
2426: OKL_API.set_message( p_app_name => G_APP_NAME,
2427: p_msg_name => 'OKL_RCPT_TOT_AMT_GT_UNAPP_AMT');
2428:
2429: RAISE G_EXCEPTION_HALT_VALIDATION;
2430: END IF;

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

2442: ,p_apply_onacc_amount => l_apply_onacc_amount
2443: ,p_receipt_date => l_rcpt_rec.receipt_date
2444: ,p_gl_date => l_rcpt_rec.gl_date);
2445:
2446: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2447: RAISE okl_api.g_exception_unexpected_error;
2448: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2449: RAISE okl_api.g_exception_error;
2450: END IF;

Line 2447: RAISE okl_api.g_exception_unexpected_error;

2443: ,p_receipt_date => l_rcpt_rec.receipt_date
2444: ,p_gl_date => l_rcpt_rec.gl_date);
2445:
2446: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2447: RAISE okl_api.g_exception_unexpected_error;
2448: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2449: RAISE okl_api.g_exception_error;
2450: END IF;
2451: END IF;

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

2444: ,p_gl_date => l_rcpt_rec.gl_date);
2445:
2446: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2447: RAISE okl_api.g_exception_unexpected_error;
2448: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2449: RAISE okl_api.g_exception_error;
2450: END IF;
2451: END IF;
2452:

Line 2449: RAISE okl_api.g_exception_error;

2445:
2446: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2447: RAISE okl_api.g_exception_unexpected_error;
2448: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2449: RAISE okl_api.g_exception_error;
2450: END IF;
2451: END IF;
2452:
2453: --End - Handle On-Account Application

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

2451: END IF;
2452:
2453: --End - Handle On-Account Application
2454:
2455: okl_api.end_activity(l_msg_count,l_msg_data);
2456: x_msg_data := l_msg_data;
2457: x_msg_count := l_msg_count;
2458: x_return_status := l_return_status;
2459: log_debug('okl_receipts_pvt.handle_receipt End -');

Line 2462: x_return_status := okl_api.g_ret_sts_error;

2458: x_return_status := l_return_status;
2459: log_debug('okl_receipts_pvt.handle_receipt End -');
2460: EXCEPTION
2461: WHEN g_exception_halt_validation THEN
2462: x_return_status := okl_api.g_ret_sts_error;
2463: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2464: (
2465: l_api_name,
2466: G_PKG_NAME,

Line 2463: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2459: log_debug('okl_receipts_pvt.handle_receipt End -');
2460: EXCEPTION
2461: WHEN g_exception_halt_validation THEN
2462: x_return_status := okl_api.g_ret_sts_error;
2463: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2464: (
2465: l_api_name,
2466: G_PKG_NAME,
2467: 'OKL_API.G_RET_STS_ERROR',

Line 2467: 'OKL_API.G_RET_STS_ERROR',

2463: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2464: (
2465: l_api_name,
2466: G_PKG_NAME,
2467: 'OKL_API.G_RET_STS_ERROR',
2468: x_msg_count,
2469: x_msg_data,
2470: '_PVT'
2471: );

Line 2472: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2468: x_msg_count,
2469: x_msg_data,
2470: '_PVT'
2471: );
2472: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2473: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2474: (
2475: l_api_name,
2476: G_PKG_NAME,

Line 2473: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2469: x_msg_data,
2470: '_PVT'
2471: );
2472: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2473: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2474: (
2475: l_api_name,
2476: G_PKG_NAME,
2477: 'OKL_API.G_RET_STS_ERROR',

Line 2477: 'OKL_API.G_RET_STS_ERROR',

2473: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2474: (
2475: l_api_name,
2476: G_PKG_NAME,
2477: 'OKL_API.G_RET_STS_ERROR',
2478: x_msg_count,
2479: x_msg_data,
2480: '_PVT'
2481: );

Line 2484: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2480: '_PVT'
2481: );
2482:
2483: WHEN OTHERS THEN
2484: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2485: (
2486: l_api_name,
2487: G_PKG_NAME,
2488: 'OTHERS',

Line 2493: Okl_api.set_message( p_app_name => g_app_name

2489: x_msg_count,
2490: x_msg_data,
2491: '_PVT'
2492: );
2493: Okl_api.set_message( p_app_name => g_app_name
2494: , p_msg_name => g_unexpected_error
2495: , p_token1 => g_sqlcode_token
2496: , p_token1_value => SQLCODE
2497: , p_token2 => g_sqlerrm_token

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

2517:
2518: RETURN l_cc_rate_type;
2519: EXCEPTION
2520: WHEN OTHERS THEN
2521: Okl_Api.Set_Message(p_app_name => Okl_Api.G_APP_NAME,
2522: p_msg_name => 'OKL_UNEXPECTED_ERROR',
2523: p_token1 => 'OKL_SQLCODE',
2524: p_token1_value => SQLCODE,
2525: p_token2 => 'OKL_SQLERRM',