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 1809: RAISE OKL_API.G_EXCEPTION_ERROR;

1805: --If default cash application rule is not defined then
1806: --raise an exception
1807: IF l_dflt_tolerance IS NULL OR l_dflt_under_payment IS NULL
1808: OR l_dflt_over_payment IS NULL OR l_dflt_receipt_msmtch IS NULL THEN
1809: RAISE OKL_API.G_EXCEPTION_ERROR;
1810: END IF;
1811:
1812: -- START OKL CASH APPLICATION.
1813: IF l_contract_num IS NOT NULL THEN

Line 1947: OKL_API.set_message( p_app_name => G_APP_NAME

1943: IF l_inv_to_rct_rate is null THEN
1944: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
1945: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
1946: IF l_exchange_rate_type IS NULL THEN
1947: OKL_API.set_message( p_app_name => G_APP_NAME
1948: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
1949: );
1950: RAISE G_EXCEPTION_HALT_VALIDATION;
1951: ELSE

Line 1961: x_return_status := okl_api.G_RET_STS_ERROR;

1957:
1958: IF l_conversion_rate IN (0,-1) THEN
1959:
1960: -- Message Text: No exchange rate defined
1961: x_return_status := okl_api.G_RET_STS_ERROR;
1962: okl_api.set_message( p_app_name => G_APP_NAME,
1963: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
1964: RAISE G_EXCEPTION_HALT_VALIDATION;
1965: END IF;

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

1958: IF l_conversion_rate IN (0,-1) THEN
1959:
1960: -- Message Text: No exchange rate defined
1961: x_return_status := okl_api.G_RET_STS_ERROR;
1962: okl_api.set_message( p_app_name => G_APP_NAME,
1963: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
1964: RAISE G_EXCEPTION_HALT_VALIDATION;
1965: END IF;
1966: END IF;

Line 2018: OKL_API.set_message( p_app_name => G_APP_NAME

2014: IF l_inv_to_rct_rate is null THEN
2015: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
2016: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
2017: IF l_exchange_rate_type IS NULL THEN
2018: OKL_API.set_message( p_app_name => G_APP_NAME
2019: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
2020: );
2021: RAISE G_EXCEPTION_HALT_VALIDATION;
2022: ELSE

Line 2032: x_return_status := okl_api.G_RET_STS_ERROR;

2028:
2029: IF l_conversion_rate IN (0,-1) THEN
2030:
2031: -- Message Text: No exchange rate defined
2032: x_return_status := okl_api.G_RET_STS_ERROR;
2033: okl_api.set_message( p_app_name => G_APP_NAME,
2034: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
2035: RAISE G_EXCEPTION_HALT_VALIDATION;
2036: END IF;

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

2029: IF l_conversion_rate IN (0,-1) THEN
2030:
2031: -- Message Text: No exchange rate defined
2032: x_return_status := okl_api.G_RET_STS_ERROR;
2033: okl_api.set_message( p_app_name => G_APP_NAME,
2034: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
2035: RAISE G_EXCEPTION_HALT_VALIDATION;
2036: END IF;
2037: END IF;

Line 2069: --RAISE OKL_API.G_EXCEPTION_ERROR;

2065: -- Message Text: No prorated transaction types
2066: --x_return_status := OKC_API.G_RET_STS_ERROR;
2067: --OKC_API.set_message( p_app_name => G_APP_NAME,
2068: -- p_msg_name => 'OKL_BPD_NO_PRORATED_STRMS');
2069: --RAISE OKL_API.G_EXCEPTION_ERROR;
2070: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Pro-rate invoice total is zero or null');
2071: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2072: x_appl_tbl.delete;
2073: RETURN;

Line 2088: OKL_API.set_message( p_app_name => G_APP_NAME

2084: IF l_inv_to_rct_rate is null THEN
2085: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
2086: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
2087: IF l_exchange_rate_type IS NULL THEN
2088: OKL_API.set_message( p_app_name => G_APP_NAME
2089: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
2090: );
2091: RAISE G_EXCEPTION_HALT_VALIDATION;
2092: ELSE

Line 2102: x_return_status := okl_api.G_RET_STS_ERROR;

2098:
2099: IF l_conversion_rate IN (0,-1) THEN
2100:
2101: -- Message Text: No exchange rate defined
2102: x_return_status := okl_api.G_RET_STS_ERROR;
2103: okl_api.set_message( p_app_name => G_APP_NAME,
2104: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
2105: RAISE G_EXCEPTION_HALT_VALIDATION;
2106: END IF;

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

2099: IF l_conversion_rate IN (0,-1) THEN
2100:
2101: -- Message Text: No exchange rate defined
2102: x_return_status := okl_api.G_RET_STS_ERROR;
2103: okl_api.set_message( p_app_name => G_APP_NAME,
2104: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
2105: RAISE G_EXCEPTION_HALT_VALIDATION;
2106: END IF;
2107: END IF;

Line 2130: OKL_API.set_message( p_app_name => G_APP_NAME

2126: IF l_inv_to_rct_rate is null THEN
2127: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
2128: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
2129: IF l_exchange_rate_type IS NULL THEN
2130: OKL_API.set_message( p_app_name => G_APP_NAME
2131: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
2132: );
2133: RAISE G_EXCEPTION_HALT_VALIDATION;
2134: ELSE

Line 2144: x_return_status := okl_api.G_RET_STS_ERROR;

2140:
2141: IF l_conversion_rate IN (0,-1) THEN
2142:
2143: -- Message Text: No exchange rate defined
2144: x_return_status := okl_api.G_RET_STS_ERROR;
2145: okl_api.set_message( p_app_name => G_APP_NAME,
2146: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
2147: RAISE G_EXCEPTION_HALT_VALIDATION;
2148: END IF;

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

2141: IF l_conversion_rate IN (0,-1) THEN
2142:
2143: -- Message Text: No exchange rate defined
2144: x_return_status := okl_api.G_RET_STS_ERROR;
2145: okl_api.set_message( p_app_name => G_APP_NAME,
2146: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
2147: RAISE G_EXCEPTION_HALT_VALIDATION;
2148: END IF;
2149: END IF;

Line 2195: OKL_API.set_message( p_app_name => G_APP_NAME

2191: IF l_inv_to_rct_rate is null THEN
2192: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
2193: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
2194: IF l_exchange_rate_type IS NULL THEN
2195: OKL_API.set_message( p_app_name => G_APP_NAME
2196: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
2197: );
2198: RAISE G_EXCEPTION_HALT_VALIDATION;
2199: ELSE

Line 2209: x_return_status := okl_api.G_RET_STS_ERROR;

2205:
2206: IF l_conversion_rate IN (0,-1) THEN
2207:
2208: -- Message Text: No exchange rate defined
2209: x_return_status := okl_api.G_RET_STS_ERROR;
2210: okl_api.set_message( p_app_name => G_APP_NAME,
2211: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
2212: RAISE G_EXCEPTION_HALT_VALIDATION;
2213: END IF;

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

2206: IF l_conversion_rate IN (0,-1) THEN
2207:
2208: -- Message Text: No exchange rate defined
2209: x_return_status := okl_api.G_RET_STS_ERROR;
2210: okl_api.set_message( p_app_name => G_APP_NAME,
2211: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
2212: RAISE G_EXCEPTION_HALT_VALIDATION;
2213: END IF;
2214: END IF;

Line 2282: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2278:
2279: x_onacc_amount :=l_onacc_amount;
2280: x_unapply_amount :=l_unapply_amount;
2281:
2282: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2283: EXCEPTION
2284: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2285: x_appl_tbl.DELETE;
2286: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 2286: x_return_status := OKL_API.G_RET_STS_ERROR;

2282: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2283: EXCEPTION
2284: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2285: x_appl_tbl.DELETE;
2286: x_return_status := OKL_API.G_RET_STS_ERROR;
2287: x_appl_tbl.delete;
2288: WHEN OTHERS THEN
2289: x_appl_tbl.DELETE;
2290: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 2290: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

2286: x_return_status := OKL_API.G_RET_STS_ERROR;
2287: x_appl_tbl.delete;
2288: WHEN OTHERS THEN
2289: x_appl_tbl.DELETE;
2290: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2291: x_msg_count := l_msg_count;
2292: x_msg_data := sqlerrm;
2293: END auto_cashapp_for_contract;
2294:

Line 2407: RAISE OKL_API.G_EXCEPTION_ERROR;

2403: --If default cash application rule is not defined then
2404: --raise an exception
2405: IF l_dflt_tolerance IS NULL OR l_dflt_under_payment IS NULL
2406: OR l_dflt_over_payment IS NULL OR l_dflt_receipt_msmtch IS NULL THEN
2407: RAISE OKL_API.G_EXCEPTION_ERROR;
2408: END IF;
2409:
2410: -- START OKL CASH APPLICATION.
2411:

Line 2514: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2510: x_appl_tbl := l_appl_tbl;
2511: END IF;
2512:
2513: x_onacc_amount :=l_onacc_amount;
2514: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2515: --to be coded -onacc
2516:
2517: EXCEPTION
2518: WHEN OTHERS THEN

Line 2520: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

2516:
2517: EXCEPTION
2518: WHEN OTHERS THEN
2519: x_appl_tbl.DELETE;
2520: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2521: x_msg_count := l_msg_count;
2522: x_msg_data := sqlerrm;
2523: END receipt_mismatch;
2524:

Line 3197: OKL_API.set_message( p_app_name => G_APP_NAME

3193: log_debug('l_amount_app_to = '||l_amount_app_to);
3194: log_debug('l_inv_to_rct_rate = '||l_inv_to_rct_rate);
3195: IF l_currency_code = l_inv_curr_Code THEN
3196: IF l_amount_app_from IS NULL AND l_amount_app_to IS NULL THEN
3197: OKL_API.set_message( p_app_name => G_APP_NAME
3198: ,p_msg_name => 'OKL_BPD_INVALID_PARAMS'
3199: );
3200: RAISE G_EXCEPTION_HALT_VALIDATION;
3201: ELSIF l_amount_app_from IS NULL THEN

Line 3209: OKL_API.set_message( p_app_name => G_APP_NAME

3205: END IF;
3206: ELSE
3207: 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
3208: IF ( l_amount_app_to * l_inv_to_rct_rate) <> l_amount_app_from THEN
3209: OKL_API.set_message( p_app_name => G_APP_NAME
3210: ,p_msg_name => 'OKL_BPD_PARAMS_MISMATCH'
3211: );
3212: END IF;
3213: IF l_inv_to_rct_rate <> 0 and ( ( l_amount_app_from / l_inv_to_rct_rate) <> l_amount_app_to) THEN

Line 3214: OKL_API.set_message( p_app_name => G_APP_NAME

3210: ,p_msg_name => 'OKL_BPD_PARAMS_MISMATCH'
3211: );
3212: END IF;
3213: IF l_inv_to_rct_rate <> 0 and ( ( l_amount_app_from / l_inv_to_rct_rate) <> l_amount_app_to) THEN
3214: OKL_API.set_message( p_app_name => G_APP_NAME
3215: ,p_msg_name => 'OKL_BPD_PARAMS_MISMATCH'
3216: );
3217: END IF;
3218: END IF;

Line 3222: OKL_API.set_message( p_app_name => G_APP_NAME

3218: END IF;
3219: /* l_cross_curr_enabled := nvl(FND_PROFILE.value('AR_ENABLE_CROSS_CURRENCY'),'N');
3220: log_debug('l_cross_curr_enabled = '||l_cross_curr_enabled);
3221: IF l_cross_curr_enabled <> 'Y' THEN
3222: OKL_API.set_message( p_app_name => G_APP_NAME
3223: ,p_msg_name => 'OKL_BPD_CROSS_CURR_NA'
3224: );
3225: RAISE G_EXCEPTION_HALT_VALIDATION;
3226: ELSE*/

Line 3231: OKL_API.set_message( p_app_name => G_APP_NAME

3227: IF l_inv_to_rct_rate is null THEN
3228: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3229: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3230: IF l_exchange_rate_type IS NULL THEN
3231: OKL_API.set_message( p_app_name => G_APP_NAME
3232: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
3233: );
3234: RAISE G_EXCEPTION_HALT_VALIDATION;
3235: ELSE

Line 3245: x_return_status := okl_api.G_RET_STS_ERROR;

3241:
3242: IF l_conversion_rate IN (0,-1) THEN
3243:
3244: -- Message Text: No exchange rate defined
3245: x_return_status := okl_api.G_RET_STS_ERROR;
3246: okl_api.set_message( p_app_name => G_APP_NAME,
3247: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3248: RAISE G_EXCEPTION_HALT_VALIDATION;
3249: END IF;

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

3242: IF l_conversion_rate IN (0,-1) THEN
3243:
3244: -- Message Text: No exchange rate defined
3245: x_return_status := okl_api.G_RET_STS_ERROR;
3246: okl_api.set_message( p_app_name => G_APP_NAME,
3247: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3248: RAISE G_EXCEPTION_HALT_VALIDATION;
3249: END IF;
3250: END IF;

Line 3256: OKL_API.set_message( p_app_name => G_APP_NAME

3252: l_conversion_rate := l_inv_to_rct_rate;
3253: END IF;
3254: log_debug('l_conversion_rate ='||l_conversion_rate);
3255: IF l_amount_app_from IS NULL AND l_amount_app_to IS NULL THEN
3256: OKL_API.set_message( p_app_name => G_APP_NAME
3257: ,p_msg_name => 'OKL_BPD_INVALID_PARAMS'
3258: );
3259: RAISE G_EXCEPTION_HALT_VALIDATION;
3260: ELSIF l_amount_app_from IS NULL THEN

Line 3400: OKL_API.set_message( p_app_name => G_APP_NAME

3396: IF l_inv_to_rct_rate is null THEN
3397: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3398: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3399: IF l_exchange_rate_type IS NULL THEN
3400: OKL_API.set_message( p_app_name => G_APP_NAME
3401: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
3402: );
3403: RAISE G_EXCEPTION_HALT_VALIDATION;
3404: ELSE

Line 3414: x_return_status := okl_api.G_RET_STS_ERROR;

3410:
3411: IF l_conversion_rate IN (0,-1) THEN
3412:
3413: -- Message Text: No exchange rate defined
3414: x_return_status := okl_api.G_RET_STS_ERROR;
3415: okl_api.set_message( p_app_name => G_APP_NAME,
3416: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3417: RAISE G_EXCEPTION_HALT_VALIDATION;
3418: END IF;

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

3411: IF l_conversion_rate IN (0,-1) THEN
3412:
3413: -- Message Text: No exchange rate defined
3414: x_return_status := okl_api.G_RET_STS_ERROR;
3415: okl_api.set_message( p_app_name => G_APP_NAME,
3416: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3417: RAISE G_EXCEPTION_HALT_VALIDATION;
3418: END IF;
3419: END IF;

Line 3472: OKL_API.set_message( p_app_name => G_APP_NAME

3468: IF l_inv_to_rct_rate is null THEN
3469: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3470: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3471: IF l_exchange_rate_type IS NULL THEN
3472: OKL_API.set_message( p_app_name => G_APP_NAME
3473: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
3474: );
3475: RAISE G_EXCEPTION_HALT_VALIDATION;
3476: ELSE

Line 3486: x_return_status := okl_api.G_RET_STS_ERROR;

3482:
3483: IF l_conversion_rate IN (0,-1) THEN
3484:
3485: -- Message Text: No exchange rate defined
3486: x_return_status := okl_api.G_RET_STS_ERROR;
3487: okl_api.set_message( p_app_name => G_APP_NAME,
3488: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3489: RAISE G_EXCEPTION_HALT_VALIDATION;
3490: END IF;

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

3483: IF l_conversion_rate IN (0,-1) THEN
3484:
3485: -- Message Text: No exchange rate defined
3486: x_return_status := okl_api.G_RET_STS_ERROR;
3487: okl_api.set_message( p_app_name => G_APP_NAME,
3488: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3489: RAISE G_EXCEPTION_HALT_VALIDATION;
3490: END IF;
3491: END IF;

Line 3544: OKL_API.set_message( p_app_name => G_APP_NAME

3540: IF l_inv_to_rct_rate is null THEN
3541: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3542: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3543: IF l_exchange_rate_type IS NULL THEN
3544: OKL_API.set_message( p_app_name => G_APP_NAME
3545: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
3546: );
3547: RAISE G_EXCEPTION_HALT_VALIDATION;
3548: ELSE

Line 3558: x_return_status := okl_api.G_RET_STS_ERROR;

3554:
3555: IF l_conversion_rate IN (0,-1) THEN
3556:
3557: -- Message Text: No exchange rate defined
3558: x_return_status := okl_api.G_RET_STS_ERROR;
3559: okl_api.set_message( p_app_name => G_APP_NAME,
3560: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3561: RAISE G_EXCEPTION_HALT_VALIDATION;
3562: END IF;

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

3555: IF l_conversion_rate IN (0,-1) THEN
3556:
3557: -- Message Text: No exchange rate defined
3558: x_return_status := okl_api.G_RET_STS_ERROR;
3559: okl_api.set_message( p_app_name => G_APP_NAME,
3560: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3561: RAISE G_EXCEPTION_HALT_VALIDATION;
3562: END IF;
3563: END IF;

Line 3586: OKL_API.set_message( p_app_name => G_APP_NAME

3582: IF l_inv_to_rct_rate is null THEN
3583: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3584: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3585: IF l_exchange_rate_type IS NULL THEN
3586: OKL_API.set_message( p_app_name => G_APP_NAME
3587: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
3588: );
3589: RAISE G_EXCEPTION_HALT_VALIDATION;
3590: ELSE

Line 3600: x_return_status := okl_api.G_RET_STS_ERROR;

3596:
3597: IF l_conversion_rate IN (0,-1) THEN
3598:
3599: -- Message Text: No exchange rate defined
3600: x_return_status := okl_api.G_RET_STS_ERROR;
3601: okl_api.set_message( p_app_name => G_APP_NAME,
3602: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3603: RAISE G_EXCEPTION_HALT_VALIDATION;
3604: END IF;

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

3597: IF l_conversion_rate IN (0,-1) THEN
3598:
3599: -- Message Text: No exchange rate defined
3600: x_return_status := okl_api.G_RET_STS_ERROR;
3601: okl_api.set_message( p_app_name => G_APP_NAME,
3602: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3603: RAISE G_EXCEPTION_HALT_VALIDATION;
3604: END IF;
3605: END IF;

Line 3655: OKL_API.set_message( p_app_name => G_APP_NAME

3651: IF l_inv_to_rct_rate is null THEN
3652: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3653: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3654: IF l_exchange_rate_type IS NULL THEN
3655: OKL_API.set_message( p_app_name => G_APP_NAME
3656: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
3657: );
3658: RAISE G_EXCEPTION_HALT_VALIDATION;
3659: ELSE

Line 3669: x_return_status := okl_api.G_RET_STS_ERROR;

3665:
3666: IF l_conversion_rate IN (0,-1) THEN
3667:
3668: -- Message Text: No exchange rate defined
3669: x_return_status := okl_api.G_RET_STS_ERROR;
3670: okl_api.set_message( p_app_name => G_APP_NAME,
3671: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3672: RAISE G_EXCEPTION_HALT_VALIDATION;
3673: END IF;

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

3666: IF l_conversion_rate IN (0,-1) THEN
3667:
3668: -- Message Text: No exchange rate defined
3669: x_return_status := okl_api.G_RET_STS_ERROR;
3670: okl_api.set_message( p_app_name => G_APP_NAME,
3671: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3672: RAISE G_EXCEPTION_HALT_VALIDATION;
3673: END IF;
3674: END IF;

Line 3896: OKL_API.set_message( p_app_name => G_APP_NAME

3892: IF l_inv_to_rct_rate is null THEN
3893: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3894: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3895: IF l_exchange_rate_type IS NULL THEN
3896: OKL_API.set_message( p_app_name => G_APP_NAME
3897: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
3898: );
3899: RAISE G_EXCEPTION_HALT_VALIDATION;
3900: ELSE

Line 3910: x_return_status := okl_api.G_RET_STS_ERROR;

3906:
3907: IF l_conversion_rate IN (0,-1) THEN
3908:
3909: -- Message Text: No exchange rate defined
3910: x_return_status := okl_api.G_RET_STS_ERROR;
3911: okl_api.set_message( p_app_name => G_APP_NAME,
3912: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3913: RAISE G_EXCEPTION_HALT_VALIDATION;
3914: END IF;

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

3907: IF l_conversion_rate IN (0,-1) THEN
3908:
3909: -- Message Text: No exchange rate defined
3910: x_return_status := okl_api.G_RET_STS_ERROR;
3911: okl_api.set_message( p_app_name => G_APP_NAME,
3912: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3913: RAISE G_EXCEPTION_HALT_VALIDATION;
3914: END IF;
3915: END IF;

Line 3965: OKL_API.set_message( p_app_name => G_APP_NAME

3961: IF l_inv_to_rct_rate is null THEN
3962: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
3963: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
3964: IF l_exchange_rate_type IS NULL THEN
3965: OKL_API.set_message( p_app_name => G_APP_NAME
3966: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
3967: );
3968: RAISE G_EXCEPTION_HALT_VALIDATION;
3969: ELSE

Line 3979: x_return_status := okl_api.G_RET_STS_ERROR;

3975:
3976: IF l_conversion_rate IN (0,-1) THEN
3977:
3978: -- Message Text: No exchange rate defined
3979: x_return_status := okl_api.G_RET_STS_ERROR;
3980: okl_api.set_message( p_app_name => G_APP_NAME,
3981: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3982: RAISE G_EXCEPTION_HALT_VALIDATION;
3983: END IF;

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

3976: IF l_conversion_rate IN (0,-1) THEN
3977:
3978: -- Message Text: No exchange rate defined
3979: x_return_status := okl_api.G_RET_STS_ERROR;
3980: okl_api.set_message( p_app_name => G_APP_NAME,
3981: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
3982: RAISE G_EXCEPTION_HALT_VALIDATION;
3983: END IF;
3984: END IF;

Line 4033: OKL_API.set_message( p_app_name => G_APP_NAME

4029: IF l_inv_to_rct_rate is null THEN
4030: l_exchange_rate_type :=OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);-- FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
4031: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
4032: IF l_exchange_rate_type IS NULL THEN
4033: OKL_API.set_message( p_app_name => G_APP_NAME
4034: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
4035: );
4036: RAISE G_EXCEPTION_HALT_VALIDATION;
4037: ELSE

Line 4047: x_return_status := okl_api.G_RET_STS_ERROR;

4043:
4044: IF l_conversion_rate IN (0,-1) THEN
4045:
4046: -- Message Text: No exchange rate defined
4047: x_return_status := okl_api.G_RET_STS_ERROR;
4048: okl_api.set_message( p_app_name => G_APP_NAME,
4049: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
4050: RAISE G_EXCEPTION_HALT_VALIDATION;
4051: END IF;

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

4044: IF l_conversion_rate IN (0,-1) THEN
4045:
4046: -- Message Text: No exchange rate defined
4047: x_return_status := okl_api.G_RET_STS_ERROR;
4048: okl_api.set_message( p_app_name => G_APP_NAME,
4049: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
4050: RAISE G_EXCEPTION_HALT_VALIDATION;
4051: END IF;
4052: END IF;

Line 4112: OKL_API.set_message( p_app_name => G_APP_NAME

4108: IF l_inv_to_rct_rate is null THEN
4109: l_exchange_rate_type := OKL_RECEIPTS_PVT.cross_currency_rate_type(p_org_id);--FND_PROFILE.value('AR_CROSS_CURRENCY_RATE_TYPE');
4110: log_debug('l_exchange_rate_type = '||l_exchange_rate_type);
4111: IF l_exchange_rate_type IS NULL THEN
4112: OKL_API.set_message( p_app_name => G_APP_NAME
4113: ,p_msg_name => 'OKL_BPD_CONV_TYPE_NOT_FOUND'
4114: );
4115: RAISE G_EXCEPTION_HALT_VALIDATION;
4116: ELSE

Line 4126: x_return_status := okl_api.G_RET_STS_ERROR;

4122:
4123: IF l_conversion_rate IN (0,-1) THEN
4124:
4125: -- Message Text: No exchange rate defined
4126: x_return_status := okl_api.G_RET_STS_ERROR;
4127: okl_api.set_message( p_app_name => G_APP_NAME,
4128: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
4129: RAISE G_EXCEPTION_HALT_VALIDATION;
4130: END IF;

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

4123: IF l_conversion_rate IN (0,-1) THEN
4124:
4125: -- Message Text: No exchange rate defined
4126: x_return_status := okl_api.G_RET_STS_ERROR;
4127: okl_api.set_message( p_app_name => G_APP_NAME,
4128: p_msg_name => 'OKL_BPD_NO_EXCHANGE_RATE');
4129: RAISE G_EXCEPTION_HALT_VALIDATION;
4130: END IF;
4131: END IF;

Line 4220: x_return_status := OKL_API.G_RET_STS_SUCCESS;

4216: 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 ...');
4217:
4218:
4219: END IF;
4220: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4221:
4222: x_onacc_amount:= l_onacc_amount ;
4223: x_unapply_amount:= l_unapply_amount;
4224:

Line 4229: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

4225: EXCEPTION
4226:
4227: WHEN OTHERS THEN
4228: x_appl_tbl.DELETE;
4229: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
4230: x_msg_count := l_msg_count;
4231: x_msg_data := l_msg_data;
4232:
4233: END auto_cashapp_for_consinv;