APPS.OKL_AUTO_CASH_APPL_RULES_PVT dependencies on OKL_API

Line 368: OKL_API.set_message( p_app_name => G_APP_NAME

364: log_debug('l_inv_to_rct_rate = '||l_inv_to_rct_rate);
365:
366: IF l_currency_code = l_inv_curr_Code THEN
367: IF l_amount_app_from IS NULL AND l_amount_app_to IS NULL THEN
368: OKL_API.set_message( p_app_name => G_APP_NAME
369: ,p_msg_name => 'OKL_BPD_INVALID_PARAMS'
370: );
371: RAISE G_EXCEPTION_HALT_VALIDATION;
372: ELSIF l_amount_app_from IS NULL THEN

Line 380: OKL_API.set_message( p_app_name => G_APP_NAME

376: END IF;
377: ELSE
378: IF l_amount_app_from IS NOT NULL AND l_amount_app_to IS NOT NULL AND l_inv_to_rct_rate IS NOT NULL THEN
379: IF ( l_amount_app_to * l_inv_to_rct_rate) <> l_amount_app_from THEN
380: OKL_API.set_message( p_app_name => G_APP_NAME
381: ,p_msg_name => 'OKL_BPD_PARAMS_MISMATCH'
382: );
383: END IF;
384: IF l_inv_to_rct_rate <> 0 and ( ( l_amount_app_from / l_inv_to_rct_rate) <> l_amount_app_to) THEN

Line 385: OKL_API.set_message( p_app_name => G_APP_NAME

381: ,p_msg_name => 'OKL_BPD_PARAMS_MISMATCH'
382: );
383: END IF;
384: IF l_inv_to_rct_rate <> 0 and ( ( l_amount_app_from / l_inv_to_rct_rate) <> l_amount_app_to) THEN
385: OKL_API.set_message( p_app_name => G_APP_NAME
386: ,p_msg_name => 'OKL_BPD_PARAMS_MISMATCH'
387: );
388: END IF;
389: END IF;

Line 393: OKL_API.set_message( p_app_name => G_APP_NAME

389: END IF;
390: /* l_cross_curr_enabled := nvl(FND_PROFILE.value('AR_ENABLE_CROSS_CURRENCY'),'N');
391: log_debug('l_cross_curr_enabled = '||l_cross_curr_enabled);
392: IF l_cross_curr_enabled <> 'Y' THEN
393: OKL_API.set_message( p_app_name => G_APP_NAME
394: ,p_msg_name => 'OKL_BPD_CROSS_CURR_NA'
395: );
396: RAISE G_EXCEPTION_HALT_VALIDATION;
397: ELSE*/

Line 402: OKL_API.set_message( p_app_name => G_APP_NAME

398: IF l_inv_to_rct_rate is null THEN
399: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
400: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
401: IF l_exchange_rate_type IS NULL THEN
402: OKL_API.set_message( p_app_name => G_APP_NAME
403: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
404: );
405: RAISE G_EXCEPTION_HALT_VALIDATION;
406: ELSE

Line 416: x_return_status := okl_api.G_RET_STS_ERROR;

412:
413: IF l_conversion_rate IN (0,-1) THEN
414:
415: -- Message Text: No exchange rate defined
416: x_return_status := okl_api.G_RET_STS_ERROR;
417: okl_api.set_message( p_app_name => G_APP_NAME,
418: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
419: RAISE G_EXCEPTION_HALT_VALIDATION;
420: END IF;

Line 417: okl_api.set_message( p_app_name => G_APP_NAME,

413: IF l_conversion_rate IN (0,-1) THEN
414:
415: -- Message Text: No exchange rate defined
416: x_return_status := okl_api.G_RET_STS_ERROR;
417: okl_api.set_message( p_app_name => G_APP_NAME,
418: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
419: RAISE G_EXCEPTION_HALT_VALIDATION;
420: END IF;
421: END IF;

Line 427: OKL_API.set_message( p_app_name => G_APP_NAME

423: l_conversion_rate := l_inv_to_rct_rate;
424: END IF;
425: log_debug('l_conversion_rate ='||l_conversion_rate);
426: IF l_amount_app_from IS NULL AND l_amount_app_to IS NULL THEN
427: OKL_API.set_message( p_app_name => G_APP_NAME
428: ,p_msg_name => 'OKL_BPD_INVALID_PARAMS'
429: );
430: RAISE G_EXCEPTION_HALT_VALIDATION;
431: ELSIF l_amount_app_from IS NULL THEN

Line 574: OKL_API.set_message( p_app_name => G_APP_NAME

570: IF l_inv_to_rct_rate is null THEN
571: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
572: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
573: IF l_exchange_rate_type IS NULL THEN
574: OKL_API.set_message( p_app_name => G_APP_NAME
575: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
576: );
577: RAISE G_EXCEPTION_HALT_VALIDATION;
578: ELSE

Line 588: x_return_status := okl_api.G_RET_STS_ERROR;

584:
585: IF l_conversion_rate IN (0,-1) THEN
586:
587: -- Message Text: No exchange rate defined
588: x_return_status := okl_api.G_RET_STS_ERROR;
589: okl_api.set_message( p_app_name => G_APP_NAME,
590: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
591: RAISE G_EXCEPTION_HALT_VALIDATION;
592: END IF;

Line 589: okl_api.set_message( p_app_name => G_APP_NAME,

585: IF l_conversion_rate IN (0,-1) THEN
586:
587: -- Message Text: No exchange rate defined
588: x_return_status := okl_api.G_RET_STS_ERROR;
589: okl_api.set_message( p_app_name => G_APP_NAME,
590: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
591: RAISE G_EXCEPTION_HALT_VALIDATION;
592: END IF;
593: END IF;

Line 640: OKL_API.set_message( p_app_name => G_APP_NAME

636: IF l_inv_to_rct_rate is null THEN
637: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
638: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
639: IF l_exchange_rate_type IS NULL THEN
640: OKL_API.set_message( p_app_name => G_APP_NAME
641: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
642: );
643: RAISE G_EXCEPTION_HALT_VALIDATION;
644: ELSE

Line 654: x_return_status := okl_api.G_RET_STS_ERROR;

650:
651: IF l_conversion_rate IN (0,-1) THEN
652:
653: -- Message Text: No exchange rate defined
654: x_return_status := okl_api.G_RET_STS_ERROR;
655: okl_api.set_message( p_app_name => G_APP_NAME,
656: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
657: RAISE G_EXCEPTION_HALT_VALIDATION;
658: END IF;

Line 655: okl_api.set_message( p_app_name => G_APP_NAME,

651: IF l_conversion_rate IN (0,-1) THEN
652:
653: -- Message Text: No exchange rate defined
654: x_return_status := okl_api.G_RET_STS_ERROR;
655: okl_api.set_message( p_app_name => G_APP_NAME,
656: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
657: RAISE G_EXCEPTION_HALT_VALIDATION;
658: END IF;
659: END IF;

Line 706: OKL_API.set_message( p_app_name => G_APP_NAME

702: IF l_inv_to_rct_rate is null THEN
703: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
704: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
705: IF l_exchange_rate_type IS NULL THEN
706: OKL_API.set_message( p_app_name => G_APP_NAME
707: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
708: );
709: RAISE G_EXCEPTION_HALT_VALIDATION;
710: ELSE

Line 720: x_return_status := okl_api.G_RET_STS_ERROR;

716:
717: IF l_conversion_rate IN (0,-1) THEN
718:
719: -- Message Text: No exchange rate defined
720: x_return_status := okl_api.G_RET_STS_ERROR;
721: okl_api.set_message( p_app_name => G_APP_NAME,
722: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
723: RAISE G_EXCEPTION_HALT_VALIDATION;
724: END IF;

Line 721: okl_api.set_message( p_app_name => G_APP_NAME,

717: IF l_conversion_rate IN (0,-1) THEN
718:
719: -- Message Text: No exchange rate defined
720: x_return_status := okl_api.G_RET_STS_ERROR;
721: okl_api.set_message( p_app_name => G_APP_NAME,
722: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
723: RAISE G_EXCEPTION_HALT_VALIDATION;
724: END IF;
725: END IF;

Line 748: OKL_API.set_message( p_app_name => G_APP_NAME

744: IF l_inv_to_rct_rate is null THEN
745: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
746: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
747: IF l_exchange_rate_type IS NULL THEN
748: OKL_API.set_message( p_app_name => G_APP_NAME
749: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
750: );
751: RAISE G_EXCEPTION_HALT_VALIDATION;
752: ELSE

Line 762: x_return_status := okl_api.G_RET_STS_ERROR;

758:
759: IF l_conversion_rate IN (0,-1) THEN
760:
761: -- Message Text: No exchange rate defined
762: x_return_status := okl_api.G_RET_STS_ERROR;
763: okl_api.set_message( p_app_name => G_APP_NAME,
764: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
765: RAISE G_EXCEPTION_HALT_VALIDATION;
766: END IF;

Line 763: okl_api.set_message( p_app_name => G_APP_NAME,

759: IF l_conversion_rate IN (0,-1) THEN
760:
761: -- Message Text: No exchange rate defined
762: x_return_status := okl_api.G_RET_STS_ERROR;
763: okl_api.set_message( p_app_name => G_APP_NAME,
764: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
765: RAISE G_EXCEPTION_HALT_VALIDATION;
766: END IF;
767: END IF;

Line 820: OKL_API.set_message( p_app_name => G_APP_NAME

816: IF l_inv_to_rct_rate is null THEN
817: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
818: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
819: IF l_exchange_rate_type IS NULL THEN
820: OKL_API.set_message( p_app_name => G_APP_NAME
821: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
822: );
823: RAISE G_EXCEPTION_HALT_VALIDATION;
824: ELSE

Line 834: x_return_status := okl_api.G_RET_STS_ERROR;

830:
831: IF l_conversion_rate IN (0,-1) THEN
832:
833: -- Message Text: No exchange rate defined
834: x_return_status := okl_api.G_RET_STS_ERROR;
835: okl_api.set_message( p_app_name => G_APP_NAME,
836: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
837: RAISE G_EXCEPTION_HALT_VALIDATION;
838: END IF;

Line 835: okl_api.set_message( p_app_name => G_APP_NAME,

831: IF l_conversion_rate IN (0,-1) THEN
832:
833: -- Message Text: No exchange rate defined
834: x_return_status := okl_api.G_RET_STS_ERROR;
835: okl_api.set_message( p_app_name => G_APP_NAME,
836: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
837: RAISE G_EXCEPTION_HALT_VALIDATION;
838: END IF;
839: END IF;

Line 1001: OKL_API.set_message( p_app_name => G_APP_NAME

997: IF l_inv_to_rct_rate is null THEN
998: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
999: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
1000: IF l_exchange_rate_type IS NULL THEN
1001: OKL_API.set_message( p_app_name => G_APP_NAME
1002: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
1003: );
1004: RAISE G_EXCEPTION_HALT_VALIDATION;
1005: ELSE

Line 1015: x_return_status := okl_api.G_RET_STS_ERROR;

1011:
1012: IF l_conversion_rate IN (0,-1) THEN
1013:
1014: -- Message Text: No exchange rate defined
1015: x_return_status := okl_api.G_RET_STS_ERROR;
1016: okl_api.set_message( p_app_name => G_APP_NAME,
1017: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
1018: RAISE G_EXCEPTION_HALT_VALIDATION;
1019: END IF;

Line 1016: okl_api.set_message( p_app_name => G_APP_NAME,

1012: IF l_conversion_rate IN (0,-1) THEN
1013:
1014: -- Message Text: No exchange rate defined
1015: x_return_status := okl_api.G_RET_STS_ERROR;
1016: okl_api.set_message( p_app_name => G_APP_NAME,
1017: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
1018: RAISE G_EXCEPTION_HALT_VALIDATION;
1019: END IF;
1020: END IF;

Line 1101: OKL_API.set_message( p_app_name => G_APP_NAME

1097: IF l_inv_to_rct_rate is null THEN
1098: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
1099: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
1100: IF l_exchange_rate_type IS NULL THEN
1101: OKL_API.set_message( p_app_name => G_APP_NAME
1102: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
1103: );
1104: RAISE G_EXCEPTION_HALT_VALIDATION;
1105: ELSE

Line 1115: x_return_status := okl_api.G_RET_STS_ERROR;

1111:
1112: IF l_conversion_rate IN (0,-1) THEN
1113:
1114: -- Message Text: No exchange rate defined
1115: x_return_status := okl_api.G_RET_STS_ERROR;
1116: okl_api.set_message( p_app_name => G_APP_NAME,
1117: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
1118: RAISE G_EXCEPTION_HALT_VALIDATION;
1119: END IF;

Line 1116: okl_api.set_message( p_app_name => G_APP_NAME,

1112: IF l_conversion_rate IN (0,-1) THEN
1113:
1114: -- Message Text: No exchange rate defined
1115: x_return_status := okl_api.G_RET_STS_ERROR;
1116: okl_api.set_message( p_app_name => G_APP_NAME,
1117: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
1118: RAISE G_EXCEPTION_HALT_VALIDATION;
1119: END IF;
1120: END IF;

Line 1175: OKL_API.set_message( p_app_name => G_APP_NAME

1171: IF l_inv_to_rct_rate is null THEN
1172: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
1173: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
1174: IF l_exchange_rate_type IS NULL THEN
1175: OKL_API.set_message( p_app_name => G_APP_NAME
1176: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
1177: );
1178: RAISE G_EXCEPTION_HALT_VALIDATION;
1179: ELSE

Line 1189: x_return_status := okl_api.G_RET_STS_ERROR;

1185:
1186: IF l_conversion_rate IN (0,-1) THEN
1187:
1188: -- Message Text: No exchange rate defined
1189: x_return_status := okl_api.G_RET_STS_ERROR;
1190: okl_api.set_message( p_app_name => G_APP_NAME,
1191: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
1192: RAISE G_EXCEPTION_HALT_VALIDATION;
1193: END IF;

Line 1190: okl_api.set_message( p_app_name => G_APP_NAME,

1186: IF l_conversion_rate IN (0,-1) THEN
1187:
1188: -- Message Text: No exchange rate defined
1189: x_return_status := okl_api.G_RET_STS_ERROR;
1190: okl_api.set_message( p_app_name => G_APP_NAME,
1191: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
1192: RAISE G_EXCEPTION_HALT_VALIDATION;
1193: END IF;
1194: END IF;

Line 1240: OKL_API.set_message( p_app_name => G_APP_NAME

1236: IF l_inv_to_rct_rate is null THEN
1237: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
1238: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
1239: IF l_exchange_rate_type IS NULL THEN
1240: OKL_API.set_message( p_app_name => G_APP_NAME
1241: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
1242: );
1243: RAISE G_EXCEPTION_HALT_VALIDATION;
1244: ELSE

Line 1254: x_return_status := okl_api.G_RET_STS_ERROR;

1250:
1251: IF l_conversion_rate IN (0,-1) THEN
1252:
1253: -- Message Text: No exchange rate defined
1254: x_return_status := okl_api.G_RET_STS_ERROR;
1255: okl_api.set_message( p_app_name => G_APP_NAME,
1256: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
1257: RAISE G_EXCEPTION_HALT_VALIDATION;
1258: END IF;

Line 1255: okl_api.set_message( p_app_name => G_APP_NAME,

1251: IF l_conversion_rate IN (0,-1) THEN
1252:
1253: -- Message Text: No exchange rate defined
1254: x_return_status := okl_api.G_RET_STS_ERROR;
1255: okl_api.set_message( p_app_name => G_APP_NAME,
1256: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
1257: RAISE G_EXCEPTION_HALT_VALIDATION;
1258: END IF;
1259: END IF;

Line 1282: OKL_API.set_message( p_app_name => G_APP_NAME

1278: IF l_inv_to_rct_rate is null THEN
1279: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
1280: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
1281: IF l_exchange_rate_type IS NULL THEN
1282: OKL_API.set_message( p_app_name => G_APP_NAME
1283: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
1284: );
1285: RAISE G_EXCEPTION_HALT_VALIDATION;
1286: ELSE

Line 1296: x_return_status := okl_api.G_RET_STS_ERROR;

1292:
1293: IF l_conversion_rate IN (0,-1) THEN
1294:
1295: -- Message Text: No exchange rate defined
1296: x_return_status := okl_api.G_RET_STS_ERROR;
1297: okl_api.set_message( p_app_name => G_APP_NAME,
1298: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
1299: RAISE G_EXCEPTION_HALT_VALIDATION;
1300: END IF;

Line 1297: okl_api.set_message( p_app_name => G_APP_NAME,

1293: IF l_conversion_rate IN (0,-1) THEN
1294:
1295: -- Message Text: No exchange rate defined
1296: x_return_status := okl_api.G_RET_STS_ERROR;
1297: okl_api.set_message( p_app_name => G_APP_NAME,
1298: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
1299: RAISE G_EXCEPTION_HALT_VALIDATION;
1300: END IF;
1301: END IF;

Line 1353: OKL_API.set_message( p_app_name => G_APP_NAME

1349: IF l_inv_to_rct_rate is null THEN
1350: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
1351: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
1352: IF l_exchange_rate_type IS NULL THEN
1353: OKL_API.set_message( p_app_name => G_APP_NAME
1354: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
1355: );
1356: RAISE G_EXCEPTION_HALT_VALIDATION;
1357: ELSE

Line 1367: x_return_status := okl_api.G_RET_STS_ERROR;

1363:
1364: IF l_conversion_rate IN (0,-1) THEN
1365:
1366: -- Message Text: No exchange rate defined
1367: x_return_status := okl_api.G_RET_STS_ERROR;
1368: okl_api.set_message( p_app_name => G_APP_NAME,
1369: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
1370: RAISE G_EXCEPTION_HALT_VALIDATION;
1371: END IF;

Line 1368: okl_api.set_message( p_app_name => G_APP_NAME,

1364: IF l_conversion_rate IN (0,-1) THEN
1365:
1366: -- Message Text: No exchange rate defined
1367: x_return_status := okl_api.G_RET_STS_ERROR;
1368: okl_api.set_message( p_app_name => G_APP_NAME,
1369: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
1370: RAISE G_EXCEPTION_HALT_VALIDATION;
1371: END IF;
1372: END IF;

Line 1446: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1442:
1443: x_onacc_amount :=l_onacc_amount;
1444: x_unapply_amount :=l_unapply_amount;
1445:
1446: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1447: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1448: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1449: RAISE OKL_API.G_EXCEPTION_ERROR;
1450: END IF;

Line 1447: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1443: x_onacc_amount :=l_onacc_amount;
1444: x_unapply_amount :=l_unapply_amount;
1445:
1446: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1447: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1448: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1449: RAISE OKL_API.G_EXCEPTION_ERROR;
1450: END IF;
1451: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1448: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1444: x_unapply_amount :=l_unapply_amount;
1445:
1446: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1447: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1448: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1449: RAISE OKL_API.G_EXCEPTION_ERROR;
1450: END IF;
1451: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1452: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done execution of OKL_AUTO_CASH_APPL_RULES_PVT.auto_cashapp_for_arinv ...');

Line 1449: RAISE OKL_API.G_EXCEPTION_ERROR;

1445:
1446: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1447: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1448: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1449: RAISE OKL_API.G_EXCEPTION_ERROR;
1450: END IF;
1451: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1452: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done execution of OKL_AUTO_CASH_APPL_RULES_PVT.auto_cashapp_for_arinv ...');
1453: END IF;

Line 1454: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1450: END IF;
1451: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1452: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done execution of OKL_AUTO_CASH_APPL_RULES_PVT.auto_cashapp_for_arinv ...');
1453: END IF;
1454: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1455: EXCEPTION
1456: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1457: x_return_status := OKL_API.G_RET_STS_ERROR;
1458: x_appl_tbl.delete;

Line 1457: x_return_status := OKL_API.G_RET_STS_ERROR;

1453: END IF;
1454: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1455: EXCEPTION
1456: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1457: x_return_status := OKL_API.G_RET_STS_ERROR;
1458: x_appl_tbl.delete;
1459:
1460: WHEN No_Open_Invoices_Exception THEN
1461: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1466: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1462: x_appl_tbl.delete;
1463:
1464: WHEN OTHERS THEN
1465: x_appl_tbl.DELETE;
1466: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1467: x_msg_count := l_msg_count ;
1468: x_msg_data := l_msg_data ;
1469:
1470:

Line 1712: OKL_API.set_message( p_app_name => G_APP_NAME

1708: log_debug('l_amount_app_to = '||l_amount_app_to);
1709: log_debug('l_inv_to_rct_rate = '||l_inv_to_rct_rate);
1710: IF l_currency_code = l_inv_curr_Code THEN
1711: IF l_amount_app_from IS NULL AND l_amount_app_to IS NULL THEN
1712: OKL_API.set_message( p_app_name => G_APP_NAME
1713: ,p_msg_name => 'OKL_BPD_INVALID_PARAMS'
1714: );
1715: RAISE G_EXCEPTION_HALT_VALIDATION;
1716: ELSIF l_amount_app_from IS NULL THEN

Line 1724: OKL_API.set_message( p_app_name => G_APP_NAME

1720: END IF;
1721: ELSE
1722: IF l_amount_app_from IS NOT NULL AND l_amount_app_to IS NOT NULL AND l_inv_to_rct_rate IS NOT NULL THEN
1723: IF ( l_amount_app_to * l_inv_to_rct_rate) <> l_amount_app_from THEN
1724: OKL_API.set_message( p_app_name => G_APP_NAME
1725: ,p_msg_name => 'OKL_BPD_PARAMS_MISMATCH'
1726: );
1727: END IF;
1728: IF l_inv_to_rct_rate <> 0 and ( ( l_amount_app_from / l_inv_to_rct_rate) <> l_amount_app_to) THEN

Line 1729: OKL_API.set_message( p_app_name => G_APP_NAME

1725: ,p_msg_name => 'OKL_BPD_PARAMS_MISMATCH'
1726: );
1727: END IF;
1728: IF l_inv_to_rct_rate <> 0 and ( ( l_amount_app_from / l_inv_to_rct_rate) <> l_amount_app_to) THEN
1729: OKL_API.set_message( p_app_name => G_APP_NAME
1730: ,p_msg_name => 'OKL_BPD_PARAMS_MISMATCH'
1731: );
1732: END IF;
1733: END IF;

Line 1737: OKL_API.set_message( p_app_name => G_APP_NAME

1733: END IF;
1734: l_cross_curr_enabled := nvl(FND_PROFILE.value('AR_ENABLE_CROSS_CURRENCY'),'N');
1735: log_debug('l_cross_curr_enabled = '||l_cross_curr_enabled);
1736: /* IF l_cross_curr_enabled <> 'Y' THEN
1737: OKL_API.set_message( p_app_name => G_APP_NAME
1738: ,p_msg_name => 'OKL_BPD_CROSS_CURR_NA'
1739: );
1740: RAISE G_EXCEPTION_HALT_VALIDATION;
1741: ELSE*/

Line 1746: OKL_API.set_message( p_app_name => G_APP_NAME

1742: IF l_inv_to_rct_rate is null THEN
1743: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
1744: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
1745: IF l_exchange_rate_type IS NULL THEN
1746: OKL_API.set_message( p_app_name => G_APP_NAME
1747: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
1748: );
1749: RAISE G_EXCEPTION_HALT_VALIDATION;
1750: ELSE

Line 1760: x_return_status := okl_api.G_RET_STS_ERROR;

1756:
1757: IF l_conversion_rate IN (0,-1) THEN
1758:
1759: -- Message Text: No exchange rate defined
1760: x_return_status := okl_api.G_RET_STS_ERROR;
1761: okl_api.set_message( p_app_name => G_APP_NAME,
1762: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
1763: RAISE G_EXCEPTION_HALT_VALIDATION;
1764: END IF;

Line 1761: okl_api.set_message( p_app_name => G_APP_NAME,

1757: IF l_conversion_rate IN (0,-1) THEN
1758:
1759: -- Message Text: No exchange rate defined
1760: x_return_status := okl_api.G_RET_STS_ERROR;
1761: okl_api.set_message( p_app_name => G_APP_NAME,
1762: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
1763: RAISE G_EXCEPTION_HALT_VALIDATION;
1764: END IF;
1765: END IF;

Line 1771: OKL_API.set_message( p_app_name => G_APP_NAME

1767: l_conversion_rate := l_inv_to_rct_rate;
1768: END IF;
1769: log_debug('l_conversion_rate ='||l_conversion_rate);
1770: IF l_amount_app_from IS NULL AND l_amount_app_to IS NULL THEN
1771: OKL_API.set_message( p_app_name => G_APP_NAME
1772: ,p_msg_name => 'OKL_BPD_INVALID_PARAMS'
1773: );
1774: RAISE G_EXCEPTION_HALT_VALIDATION;
1775: ELSIF l_amount_app_from IS NULL THEN

Line 1810: RAISE OKL_API.G_EXCEPTION_ERROR;

1806: --raise an exception
1807: -- sosharma Modified the check for bug 9771644
1808: /* IF l_dflt_tolerance IS NULL OR l_dflt_under_payment IS NULL
1809: OR l_dflt_over_payment IS NULL OR l_dflt_receipt_msmtch IS NULL THEN
1810: RAISE OKL_API.G_EXCEPTION_ERROR;
1811: END IF;*/
1812:
1813: IF l_dflt_tolerance IS NULL OR l_dflt_under_payment IS NULL
1814: OR l_dflt_over_payment IS NULL THEN

Line 1815: RAISE OKL_API.G_EXCEPTION_ERROR;

1811: END IF;*/
1812:
1813: IF l_dflt_tolerance IS NULL OR l_dflt_under_payment IS NULL
1814: OR l_dflt_over_payment IS NULL THEN
1815: RAISE OKL_API.G_EXCEPTION_ERROR;
1816: END IF;
1817:
1818: -- START OKL CASH APPLICATION.
1819: IF l_contract_num IS NOT NULL THEN

Line 1953: OKL_API.set_message( p_app_name => G_APP_NAME

1949: IF l_inv_to_rct_rate is null THEN
1950: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
1951: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
1952: IF l_exchange_rate_type IS NULL THEN
1953: OKL_API.set_message( p_app_name => G_APP_NAME
1954: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
1955: );
1956: RAISE G_EXCEPTION_HALT_VALIDATION;
1957: ELSE

Line 1967: x_return_status := okl_api.G_RET_STS_ERROR;

1963:
1964: IF l_conversion_rate IN (0,-1) THEN
1965:
1966: -- Message Text: No exchange rate defined
1967: x_return_status := okl_api.G_RET_STS_ERROR;
1968: okl_api.set_message( p_app_name => G_APP_NAME,
1969: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
1970: RAISE G_EXCEPTION_HALT_VALIDATION;
1971: END IF;

Line 1968: okl_api.set_message( p_app_name => G_APP_NAME,

1964: IF l_conversion_rate IN (0,-1) THEN
1965:
1966: -- Message Text: No exchange rate defined
1967: x_return_status := okl_api.G_RET_STS_ERROR;
1968: okl_api.set_message( p_app_name => G_APP_NAME,
1969: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
1970: RAISE G_EXCEPTION_HALT_VALIDATION;
1971: END IF;
1972: END IF;

Line 2024: OKL_API.set_message( p_app_name => G_APP_NAME

2020: IF l_inv_to_rct_rate is null THEN
2021: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
2022: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
2023: IF l_exchange_rate_type IS NULL THEN
2024: OKL_API.set_message( p_app_name => G_APP_NAME
2025: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
2026: );
2027: RAISE G_EXCEPTION_HALT_VALIDATION;
2028: ELSE

Line 2038: x_return_status := okl_api.G_RET_STS_ERROR;

2034:
2035: IF l_conversion_rate IN (0,-1) THEN
2036:
2037: -- Message Text: No exchange rate defined
2038: x_return_status := okl_api.G_RET_STS_ERROR;
2039: okl_api.set_message( p_app_name => G_APP_NAME,
2040: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
2041: RAISE G_EXCEPTION_HALT_VALIDATION;
2042: END IF;

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

2035: IF l_conversion_rate IN (0,-1) THEN
2036:
2037: -- Message Text: No exchange rate defined
2038: x_return_status := okl_api.G_RET_STS_ERROR;
2039: okl_api.set_message( p_app_name => G_APP_NAME,
2040: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
2041: RAISE G_EXCEPTION_HALT_VALIDATION;
2042: END IF;
2043: END IF;

Line 2075: --RAISE OKL_API.G_EXCEPTION_ERROR;

2071: -- Message Text: No prorated transaction types
2072: --x_return_status := OKC_API.G_RET_STS_ERROR;
2073: --OKC_API.set_message( p_app_name => G_APP_NAME,
2074: -- p_msg_name => 'OKL_BPD_NO_PRORATED_STRMS');
2075: --RAISE OKL_API.G_EXCEPTION_ERROR;
2076: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Pro-rate invoice total is zero or null');
2077: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2078: x_appl_tbl.delete;
2079: RETURN;

Line 2094: OKL_API.set_message( p_app_name => G_APP_NAME

2090: IF l_inv_to_rct_rate is null THEN
2091: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
2092: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
2093: IF l_exchange_rate_type IS NULL THEN
2094: OKL_API.set_message( p_app_name => G_APP_NAME
2095: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
2096: );
2097: RAISE G_EXCEPTION_HALT_VALIDATION;
2098: ELSE

Line 2108: x_return_status := okl_api.G_RET_STS_ERROR;

2104:
2105: IF l_conversion_rate IN (0,-1) THEN
2106:
2107: -- Message Text: No exchange rate defined
2108: x_return_status := okl_api.G_RET_STS_ERROR;
2109: okl_api.set_message( p_app_name => G_APP_NAME,
2110: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
2111: RAISE G_EXCEPTION_HALT_VALIDATION;
2112: END IF;

Line 2109: okl_api.set_message( p_app_name => G_APP_NAME,

2105: IF l_conversion_rate IN (0,-1) THEN
2106:
2107: -- Message Text: No exchange rate defined
2108: x_return_status := okl_api.G_RET_STS_ERROR;
2109: okl_api.set_message( p_app_name => G_APP_NAME,
2110: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
2111: RAISE G_EXCEPTION_HALT_VALIDATION;
2112: END IF;
2113: END IF;

Line 2136: OKL_API.set_message( p_app_name => G_APP_NAME

2132: IF l_inv_to_rct_rate is null THEN
2133: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
2134: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
2135: IF l_exchange_rate_type IS NULL THEN
2136: OKL_API.set_message( p_app_name => G_APP_NAME
2137: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
2138: );
2139: RAISE G_EXCEPTION_HALT_VALIDATION;
2140: ELSE

Line 2150: x_return_status := okl_api.G_RET_STS_ERROR;

2146:
2147: IF l_conversion_rate IN (0,-1) THEN
2148:
2149: -- Message Text: No exchange rate defined
2150: x_return_status := okl_api.G_RET_STS_ERROR;
2151: okl_api.set_message( p_app_name => G_APP_NAME,
2152: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
2153: RAISE G_EXCEPTION_HALT_VALIDATION;
2154: END IF;

Line 2151: okl_api.set_message( p_app_name => G_APP_NAME,

2147: IF l_conversion_rate IN (0,-1) THEN
2148:
2149: -- Message Text: No exchange rate defined
2150: x_return_status := okl_api.G_RET_STS_ERROR;
2151: okl_api.set_message( p_app_name => G_APP_NAME,
2152: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
2153: RAISE G_EXCEPTION_HALT_VALIDATION;
2154: END IF;
2155: END IF;

Line 2201: OKL_API.set_message( p_app_name => G_APP_NAME

2197: IF l_inv_to_rct_rate is null THEN
2198: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
2199: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
2200: IF l_exchange_rate_type IS NULL THEN
2201: OKL_API.set_message( p_app_name => G_APP_NAME
2202: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
2203: );
2204: RAISE G_EXCEPTION_HALT_VALIDATION;
2205: ELSE

Line 2215: x_return_status := okl_api.G_RET_STS_ERROR;

2211:
2212: IF l_conversion_rate IN (0,-1) THEN
2213:
2214: -- Message Text: No exchange rate defined
2215: x_return_status := okl_api.G_RET_STS_ERROR;
2216: okl_api.set_message( p_app_name => G_APP_NAME,
2217: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
2218: RAISE G_EXCEPTION_HALT_VALIDATION;
2219: END IF;

Line 2216: okl_api.set_message( p_app_name => G_APP_NAME,

2212: IF l_conversion_rate IN (0,-1) THEN
2213:
2214: -- Message Text: No exchange rate defined
2215: x_return_status := okl_api.G_RET_STS_ERROR;
2216: okl_api.set_message( p_app_name => G_APP_NAME,
2217: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
2218: RAISE G_EXCEPTION_HALT_VALIDATION;
2219: END IF;
2220: END IF;

Line 2288: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2284:
2285: x_onacc_amount :=l_onacc_amount;
2286: x_unapply_amount :=l_unapply_amount;
2287:
2288: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2289: EXCEPTION
2290: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2291: x_appl_tbl.DELETE;
2292: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 2292: x_return_status := OKL_API.G_RET_STS_ERROR;

2288: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2289: EXCEPTION
2290: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2291: x_appl_tbl.DELETE;
2292: x_return_status := OKL_API.G_RET_STS_ERROR;
2293: x_appl_tbl.delete;
2294: WHEN OTHERS THEN
2295: x_appl_tbl.DELETE;
2296: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 2296: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

2292: x_return_status := OKL_API.G_RET_STS_ERROR;
2293: x_appl_tbl.delete;
2294: WHEN OTHERS THEN
2295: x_appl_tbl.DELETE;
2296: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2297: x_msg_count := l_msg_count;
2298: x_msg_data := sqlerrm;
2299: END auto_cashapp_for_contract;
2300:

Line 2413: RAISE OKL_API.G_EXCEPTION_ERROR;

2409: --If default cash application rule is not defined then
2410: --raise an exception
2411: IF l_dflt_tolerance IS NULL OR l_dflt_under_payment IS NULL
2412: OR l_dflt_over_payment IS NULL OR l_dflt_receipt_msmtch IS NULL THEN
2413: RAISE OKL_API.G_EXCEPTION_ERROR;
2414: END IF;
2415:
2416: -- START OKL CASH APPLICATION.
2417:

Line 2524: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2520: --For bug 8521220 - by NIKSHAH
2521: --x_onacc_amount :=l_onacc_amount;
2522: x_onacc_amount := 0;
2523:
2524: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2525: --to be coded -onacc
2526:
2527: EXCEPTION
2528: WHEN OTHERS THEN

Line 2530: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

2526:
2527: EXCEPTION
2528: WHEN OTHERS THEN
2529: x_appl_tbl.DELETE;
2530: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2531: x_msg_count := l_msg_count;
2532: x_msg_data := sqlerrm;
2533: END receipt_mismatch;
2534:

Line 3207: OKL_API.set_message( p_app_name => G_APP_NAME

3203: log_debug('l_amount_app_to = '||l_amount_app_to);
3204: log_debug('l_inv_to_rct_rate = '||l_inv_to_rct_rate);
3205: IF l_currency_code = l_inv_curr_Code THEN
3206: IF l_amount_app_from IS NULL AND l_amount_app_to IS NULL THEN
3207: OKL_API.set_message( p_app_name => G_APP_NAME
3208: ,p_msg_name => 'OKL_BPD_INVALID_PARAMS'
3209: );
3210: RAISE G_EXCEPTION_HALT_VALIDATION;
3211: ELSIF l_amount_app_from IS NULL THEN

Line 3219: OKL_API.set_message( p_app_name => G_APP_NAME

3215: END IF;
3216: ELSE
3217: IF l_amount_app_from IS NOT NULL AND l_amount_app_to IS NOT NULL AND l_inv_to_rct_rate IS NOT NULL THEN
3218: IF ( l_amount_app_to * l_inv_to_rct_rate) <> l_amount_app_from THEN
3219: OKL_API.set_message( p_app_name => G_APP_NAME
3220: ,p_msg_name => 'OKL_BPD_PARAMS_MISMATCH'
3221: );
3222: END IF;
3223: IF l_inv_to_rct_rate <> 0 and ( ( l_amount_app_from / l_inv_to_rct_rate) <> l_amount_app_to) THEN

Line 3224: OKL_API.set_message( p_app_name => G_APP_NAME

3220: ,p_msg_name => 'OKL_BPD_PARAMS_MISMATCH'
3221: );
3222: END IF;
3223: IF l_inv_to_rct_rate <> 0 and ( ( l_amount_app_from / l_inv_to_rct_rate) <> l_amount_app_to) THEN
3224: OKL_API.set_message( p_app_name => G_APP_NAME
3225: ,p_msg_name => 'OKL_BPD_PARAMS_MISMATCH'
3226: );
3227: END IF;
3228: END IF;

Line 3232: OKL_API.set_message( p_app_name => G_APP_NAME

3228: END IF;
3229: /* l_cross_curr_enabled := nvl(FND_PROFILE.value('AR_ENABLE_CROSS_CURRENCY'),'N');
3230: log_debug('l_cross_curr_enabled = '||l_cross_curr_enabled);
3231: IF l_cross_curr_enabled <> 'Y' THEN
3232: OKL_API.set_message( p_app_name => G_APP_NAME
3233: ,p_msg_name => 'OKL_BPD_CROSS_CURR_NA'
3234: );
3235: RAISE G_EXCEPTION_HALT_VALIDATION;
3236: ELSE*/

Line 3241: OKL_API.set_message( p_app_name => G_APP_NAME

3237: IF l_inv_to_rct_rate is null THEN
3238: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3239: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3240: IF l_exchange_rate_type IS NULL THEN
3241: OKL_API.set_message( p_app_name => G_APP_NAME
3242: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
3243: );
3244: RAISE G_EXCEPTION_HALT_VALIDATION;
3245: ELSE

Line 3255: x_return_status := okl_api.G_RET_STS_ERROR;

3251:
3252: IF l_conversion_rate IN (0,-1) THEN
3253:
3254: -- Message Text: No exchange rate defined
3255: x_return_status := okl_api.G_RET_STS_ERROR;
3256: okl_api.set_message( p_app_name => G_APP_NAME,
3257: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3258: RAISE G_EXCEPTION_HALT_VALIDATION;
3259: END IF;

Line 3256: okl_api.set_message( p_app_name => G_APP_NAME,

3252: IF l_conversion_rate IN (0,-1) THEN
3253:
3254: -- Message Text: No exchange rate defined
3255: x_return_status := okl_api.G_RET_STS_ERROR;
3256: okl_api.set_message( p_app_name => G_APP_NAME,
3257: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3258: RAISE G_EXCEPTION_HALT_VALIDATION;
3259: END IF;
3260: END IF;

Line 3266: OKL_API.set_message( p_app_name => G_APP_NAME

3262: l_conversion_rate := l_inv_to_rct_rate;
3263: END IF;
3264: log_debug('l_conversion_rate ='||l_conversion_rate);
3265: IF l_amount_app_from IS NULL AND l_amount_app_to IS NULL THEN
3266: OKL_API.set_message( p_app_name => G_APP_NAME
3267: ,p_msg_name => 'OKL_BPD_INVALID_PARAMS'
3268: );
3269: RAISE G_EXCEPTION_HALT_VALIDATION;
3270: ELSIF l_amount_app_from IS NULL THEN

Line 3410: OKL_API.set_message( p_app_name => G_APP_NAME

3406: IF l_inv_to_rct_rate is null THEN
3407: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3408: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3409: IF l_exchange_rate_type IS NULL THEN
3410: OKL_API.set_message( p_app_name => G_APP_NAME
3411: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
3412: );
3413: RAISE G_EXCEPTION_HALT_VALIDATION;
3414: ELSE

Line 3424: x_return_status := okl_api.G_RET_STS_ERROR;

3420:
3421: IF l_conversion_rate IN (0,-1) THEN
3422:
3423: -- Message Text: No exchange rate defined
3424: x_return_status := okl_api.G_RET_STS_ERROR;
3425: okl_api.set_message( p_app_name => G_APP_NAME,
3426: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3427: RAISE G_EXCEPTION_HALT_VALIDATION;
3428: END IF;

Line 3425: okl_api.set_message( p_app_name => G_APP_NAME,

3421: IF l_conversion_rate IN (0,-1) THEN
3422:
3423: -- Message Text: No exchange rate defined
3424: x_return_status := okl_api.G_RET_STS_ERROR;
3425: okl_api.set_message( p_app_name => G_APP_NAME,
3426: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3427: RAISE G_EXCEPTION_HALT_VALIDATION;
3428: END IF;
3429: END IF;

Line 3482: OKL_API.set_message( p_app_name => G_APP_NAME

3478: IF l_inv_to_rct_rate is null THEN
3479: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3480: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3481: IF l_exchange_rate_type IS NULL THEN
3482: OKL_API.set_message( p_app_name => G_APP_NAME
3483: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
3484: );
3485: RAISE G_EXCEPTION_HALT_VALIDATION;
3486: ELSE

Line 3496: x_return_status := okl_api.G_RET_STS_ERROR;

3492:
3493: IF l_conversion_rate IN (0,-1) THEN
3494:
3495: -- Message Text: No exchange rate defined
3496: x_return_status := okl_api.G_RET_STS_ERROR;
3497: okl_api.set_message( p_app_name => G_APP_NAME,
3498: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3499: RAISE G_EXCEPTION_HALT_VALIDATION;
3500: END IF;

Line 3497: okl_api.set_message( p_app_name => G_APP_NAME,

3493: IF l_conversion_rate IN (0,-1) THEN
3494:
3495: -- Message Text: No exchange rate defined
3496: x_return_status := okl_api.G_RET_STS_ERROR;
3497: okl_api.set_message( p_app_name => G_APP_NAME,
3498: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3499: RAISE G_EXCEPTION_HALT_VALIDATION;
3500: END IF;
3501: END IF;

Line 3554: OKL_API.set_message( p_app_name => G_APP_NAME

3550: IF l_inv_to_rct_rate is null THEN
3551: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3552: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3553: IF l_exchange_rate_type IS NULL THEN
3554: OKL_API.set_message( p_app_name => G_APP_NAME
3555: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
3556: );
3557: RAISE G_EXCEPTION_HALT_VALIDATION;
3558: ELSE

Line 3568: x_return_status := okl_api.G_RET_STS_ERROR;

3564:
3565: IF l_conversion_rate IN (0,-1) THEN
3566:
3567: -- Message Text: No exchange rate defined
3568: x_return_status := okl_api.G_RET_STS_ERROR;
3569: okl_api.set_message( p_app_name => G_APP_NAME,
3570: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3571: RAISE G_EXCEPTION_HALT_VALIDATION;
3572: END IF;

Line 3569: okl_api.set_message( p_app_name => G_APP_NAME,

3565: IF l_conversion_rate IN (0,-1) THEN
3566:
3567: -- Message Text: No exchange rate defined
3568: x_return_status := okl_api.G_RET_STS_ERROR;
3569: okl_api.set_message( p_app_name => G_APP_NAME,
3570: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3571: RAISE G_EXCEPTION_HALT_VALIDATION;
3572: END IF;
3573: END IF;

Line 3596: OKL_API.set_message( p_app_name => G_APP_NAME

3592: IF l_inv_to_rct_rate is null THEN
3593: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3594: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3595: IF l_exchange_rate_type IS NULL THEN
3596: OKL_API.set_message( p_app_name => G_APP_NAME
3597: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
3598: );
3599: RAISE G_EXCEPTION_HALT_VALIDATION;
3600: ELSE

Line 3610: x_return_status := okl_api.G_RET_STS_ERROR;

3606:
3607: IF l_conversion_rate IN (0,-1) THEN
3608:
3609: -- Message Text: No exchange rate defined
3610: x_return_status := okl_api.G_RET_STS_ERROR;
3611: okl_api.set_message( p_app_name => G_APP_NAME,
3612: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3613: RAISE G_EXCEPTION_HALT_VALIDATION;
3614: END IF;

Line 3611: okl_api.set_message( p_app_name => G_APP_NAME,

3607: IF l_conversion_rate IN (0,-1) THEN
3608:
3609: -- Message Text: No exchange rate defined
3610: x_return_status := okl_api.G_RET_STS_ERROR;
3611: okl_api.set_message( p_app_name => G_APP_NAME,
3612: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3613: RAISE G_EXCEPTION_HALT_VALIDATION;
3614: END IF;
3615: END IF;

Line 3665: OKL_API.set_message( p_app_name => G_APP_NAME

3661: IF l_inv_to_rct_rate is null THEN
3662: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3663: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3664: IF l_exchange_rate_type IS NULL THEN
3665: OKL_API.set_message( p_app_name => G_APP_NAME
3666: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
3667: );
3668: RAISE G_EXCEPTION_HALT_VALIDATION;
3669: ELSE

Line 3679: x_return_status := okl_api.G_RET_STS_ERROR;

3675:
3676: IF l_conversion_rate IN (0,-1) THEN
3677:
3678: -- Message Text: No exchange rate defined
3679: x_return_status := okl_api.G_RET_STS_ERROR;
3680: okl_api.set_message( p_app_name => G_APP_NAME,
3681: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3682: RAISE G_EXCEPTION_HALT_VALIDATION;
3683: END IF;

Line 3680: okl_api.set_message( p_app_name => G_APP_NAME,

3676: IF l_conversion_rate IN (0,-1) THEN
3677:
3678: -- Message Text: No exchange rate defined
3679: x_return_status := okl_api.G_RET_STS_ERROR;
3680: okl_api.set_message( p_app_name => G_APP_NAME,
3681: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3682: RAISE G_EXCEPTION_HALT_VALIDATION;
3683: END IF;
3684: END IF;

Line 3906: OKL_API.set_message( p_app_name => G_APP_NAME

3902: IF l_inv_to_rct_rate is null THEN
3903: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3904: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3905: IF l_exchange_rate_type IS NULL THEN
3906: OKL_API.set_message( p_app_name => G_APP_NAME
3907: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
3908: );
3909: RAISE G_EXCEPTION_HALT_VALIDATION;
3910: ELSE

Line 3920: x_return_status := okl_api.G_RET_STS_ERROR;

3916:
3917: IF l_conversion_rate IN (0,-1) THEN
3918:
3919: -- Message Text: No exchange rate defined
3920: x_return_status := okl_api.G_RET_STS_ERROR;
3921: okl_api.set_message( p_app_name => G_APP_NAME,
3922: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3923: RAISE G_EXCEPTION_HALT_VALIDATION;
3924: END IF;

Line 3921: okl_api.set_message( p_app_name => G_APP_NAME,

3917: IF l_conversion_rate IN (0,-1) THEN
3918:
3919: -- Message Text: No exchange rate defined
3920: x_return_status := okl_api.G_RET_STS_ERROR;
3921: okl_api.set_message( p_app_name => G_APP_NAME,
3922: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3923: RAISE G_EXCEPTION_HALT_VALIDATION;
3924: END IF;
3925: END IF;

Line 3975: OKL_API.set_message( p_app_name => G_APP_NAME

3971: IF l_inv_to_rct_rate is null THEN
3972: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3973: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3974: IF l_exchange_rate_type IS NULL THEN
3975: OKL_API.set_message( p_app_name => G_APP_NAME
3976: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
3977: );
3978: RAISE G_EXCEPTION_HALT_VALIDATION;
3979: ELSE

Line 3989: x_return_status := okl_api.G_RET_STS_ERROR;

3985:
3986: IF l_conversion_rate IN (0,-1) THEN
3987:
3988: -- Message Text: No exchange rate defined
3989: x_return_status := okl_api.G_RET_STS_ERROR;
3990: okl_api.set_message( p_app_name => G_APP_NAME,
3991: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3992: RAISE G_EXCEPTION_HALT_VALIDATION;
3993: END IF;

Line 3990: okl_api.set_message( p_app_name => G_APP_NAME,

3986: IF l_conversion_rate IN (0,-1) THEN
3987:
3988: -- Message Text: No exchange rate defined
3989: x_return_status := okl_api.G_RET_STS_ERROR;
3990: okl_api.set_message( p_app_name => G_APP_NAME,
3991: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3992: RAISE G_EXCEPTION_HALT_VALIDATION;
3993: END IF;
3994: END IF;

Line 4043: OKL_API.set_message( p_app_name => G_APP_NAME

4039: IF l_inv_to_rct_rate is null THEN
4040: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
4041: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
4042: IF l_exchange_rate_type IS NULL THEN
4043: OKL_API.set_message( p_app_name => G_APP_NAME
4044: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
4045: );
4046: RAISE G_EXCEPTION_HALT_VALIDATION;
4047: ELSE

Line 4057: x_return_status := okl_api.G_RET_STS_ERROR;

4053:
4054: IF l_conversion_rate IN (0,-1) THEN
4055:
4056: -- Message Text: No exchange rate defined
4057: x_return_status := okl_api.G_RET_STS_ERROR;
4058: okl_api.set_message( p_app_name => G_APP_NAME,
4059: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
4060: RAISE G_EXCEPTION_HALT_VALIDATION;
4061: END IF;

Line 4058: okl_api.set_message( p_app_name => G_APP_NAME,

4054: IF l_conversion_rate IN (0,-1) THEN
4055:
4056: -- Message Text: No exchange rate defined
4057: x_return_status := okl_api.G_RET_STS_ERROR;
4058: okl_api.set_message( p_app_name => G_APP_NAME,
4059: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
4060: RAISE G_EXCEPTION_HALT_VALIDATION;
4061: END IF;
4062: END IF;

Line 4122: OKL_API.set_message( p_app_name => G_APP_NAME

4118: IF l_inv_to_rct_rate is null THEN
4119: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
4120: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
4121: IF l_exchange_rate_type IS NULL THEN
4122: OKL_API.set_message( p_app_name => G_APP_NAME
4123: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
4124: );
4125: RAISE G_EXCEPTION_HALT_VALIDATION;
4126: ELSE

Line 4136: x_return_status := okl_api.G_RET_STS_ERROR;

4132:
4133: IF l_conversion_rate IN (0,-1) THEN
4134:
4135: -- Message Text: No exchange rate defined
4136: x_return_status := okl_api.G_RET_STS_ERROR;
4137: okl_api.set_message( p_app_name => G_APP_NAME,
4138: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
4139: RAISE G_EXCEPTION_HALT_VALIDATION;
4140: END IF;

Line 4137: okl_api.set_message( p_app_name => G_APP_NAME,

4133: IF l_conversion_rate IN (0,-1) THEN
4134:
4135: -- Message Text: No exchange rate defined
4136: x_return_status := okl_api.G_RET_STS_ERROR;
4137: okl_api.set_message( p_app_name => G_APP_NAME,
4138: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
4139: RAISE G_EXCEPTION_HALT_VALIDATION;
4140: END IF;
4141: END IF;

Line 4230: x_return_status := OKL_API.G_RET_STS_SUCCESS;

4226: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Done execution of OKL_AUTO_CASH_APPL_RULES_pvt.auto_cash_app_for_consinv ...');
4227:
4228:
4229: END IF;
4230: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4231:
4232: x_onacc_amount:= l_onacc_amount ;
4233: x_unapply_amount:= l_unapply_amount;
4234:

Line 4239: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

4235: EXCEPTION
4236:
4237: WHEN OTHERS THEN
4238: x_appl_tbl.DELETE;
4239: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
4240: x_msg_count := l_msg_count;
4241: x_msg_data := l_msg_data;
4242:
4243: END auto_cashapp_for_consinv;