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

[Home] [Help]

APPS.OE_CREDIT_CHECK_RPT dependencies on FND_API

Line 157: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS ;

153:
154: l_msg_count NUMBER := 0 ;
155: l_msg_data VARCHAR2(2000):= NULL ;
156: l_result_out VARCHAR2(30) := NULL ;
157: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS ;
158: l_cc_limit_used VARCHAR2(30) := NULL ;
159: l_cc_profile_used VARCHAR2(30) := NULL ;
160: l_count NUMBER := 0;
161: l_cc_hold_comment VARCHAR2(2000):= NULL;

Line 634: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND

630: OE_DEBUG_PUB.ADD('Check_Credit return status = '||l_return_status);
631: --
632: -- Insert the result into the temporary table
633: --
634: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
635: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
636: THEN
637: Insert_In_Temp_Table(f_release_header_id, 'PASS');
638: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR

Line 638: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR

634: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
635: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
636: THEN
637: Insert_In_Temp_Table(f_release_header_id, 'PASS');
638: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
639: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
640: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
641: THEN
642: Insert_In_Temp_Table(f_release_header_id, 'FAIL');

Line 639: (l_return_status = FND_API.G_RET_STS_SUCCESS AND

635: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
636: THEN
637: Insert_In_Temp_Table(f_release_header_id, 'PASS');
638: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
639: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
640: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
641: THEN
642: Insert_In_Temp_Table(f_release_header_id, 'FAIL');
643: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 643: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

639: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
640: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
641: THEN
642: Insert_In_Temp_Table(f_release_header_id, 'FAIL');
643: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
644: Insert_In_Temp_Table(f_release_header_id, 'ERROR');
645: END IF;
646: END LOOP;
647:

Line 679: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND

675: OE_DEBUG_PUB.ADD('Check_Credit return status = '||l_return_status);
676: --
677: -- Insert the result into the temporary table
678: --
679: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
680: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
681: THEN
682: Insert_In_Temp_Table(f_hold_header_id, 'PASS');
683: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR

Line 683: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR

679: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
680: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
681: THEN
682: Insert_In_Temp_Table(f_hold_header_id, 'PASS');
683: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
684: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
685: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
686: THEN
687: Insert_In_Temp_Table(f_hold_header_id, 'FAIL');

Line 684: (l_return_status = FND_API.G_RET_STS_SUCCESS AND

680: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
681: THEN
682: Insert_In_Temp_Table(f_hold_header_id, 'PASS');
683: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
684: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
685: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
686: THEN
687: Insert_In_Temp_Table(f_hold_header_id, 'FAIL');
688: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 688: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

684: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
685: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
686: THEN
687: Insert_In_Temp_Table(f_hold_header_id, 'FAIL');
688: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
689: Insert_In_Temp_Table(f_hold_header_id, 'ERROR');
690: END IF;
691: END LOOP;
692: --

Line 748: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND

744: OE_DEBUG_PUB.ADD('Check_Credit return status = '||l_return_status);
745: --
746: -- Insert the result into the temporary table
747: --
748: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
749: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
750: THEN
751: Insert_In_Temp_Table(f_release_header_id, 'PASS');
752: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR

Line 752: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR

748: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
749: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
750: THEN
751: Insert_In_Temp_Table(f_release_header_id, 'PASS');
752: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
753: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
754: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
755: THEN
756: Insert_In_Temp_Table(f_release_header_id, 'FAIL');

Line 753: (l_return_status = FND_API.G_RET_STS_SUCCESS AND

749: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
750: THEN
751: Insert_In_Temp_Table(f_release_header_id, 'PASS');
752: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
753: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
754: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
755: THEN
756: Insert_In_Temp_Table(f_release_header_id, 'FAIL');
757: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 757: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

753: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
754: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
755: THEN
756: Insert_In_Temp_Table(f_release_header_id, 'FAIL');
757: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
758: Insert_In_Temp_Table(f_release_header_id, 'ERROR');
759: END IF;
760: END LOOP;
761:

Line 791: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND

787: OE_DEBUG_PUB.ADD('Check_Credit return status = '||l_return_status);
788: --
789: -- Insert the result into the temporary table
790: --
791: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
792: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
793: THEN
794: Insert_In_Temp_Table(f_hold_header_id, 'PASS');
795: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR

Line 795: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR

791: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
792: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
793: THEN
794: Insert_In_Temp_Table(f_hold_header_id, 'PASS');
795: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
796: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
797: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
798: THEN
799: Insert_In_Temp_Table(f_hold_header_id, 'FAIL');

Line 796: (l_return_status = FND_API.G_RET_STS_SUCCESS AND

792: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
793: THEN
794: Insert_In_Temp_Table(f_hold_header_id, 'PASS');
795: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
796: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
797: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
798: THEN
799: Insert_In_Temp_Table(f_hold_header_id, 'FAIL');
800: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 800: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

796: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
797: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
798: THEN
799: Insert_In_Temp_Table(f_hold_header_id, 'FAIL');
800: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
801: Insert_In_Temp_Table(f_hold_header_id, 'ERROR');
802: END IF;
803: END LOOP;
804: END LOOP;

Line 836: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND

832: --
833: -- Insert the results into the temporary table
834: --
835: OE_DEBUG_PUB.ADD('Right before inserting into temp table');
836: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
837: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
838: THEN
839: Insert_In_Temp_Table(p_header_id, 'PASS');
840: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR

Line 840: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR

836: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
837: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
838: THEN
839: Insert_In_Temp_Table(p_header_id, 'PASS');
840: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
841: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
842: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
843: THEN
844: Insert_In_Temp_Table(p_header_id, 'FAIL');

Line 841: (l_return_status = FND_API.G_RET_STS_SUCCESS AND

837: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
838: THEN
839: Insert_In_Temp_Table(p_header_id, 'PASS');
840: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
841: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
842: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
843: THEN
844: Insert_In_Temp_Table(p_header_id, 'FAIL');
845: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 845: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

841: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
842: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
843: THEN
844: Insert_In_Temp_Table(p_header_id, 'FAIL');
845: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
846: Insert_In_Temp_Table(p_header_id, 'ERROR');
847: END IF;
848: OE_DEBUG_PUB.ADD('Release: Right after inserting into temp table');
849:

Line 864: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND

860: --
861: -- Insert the results into the temporary table
862: --
863: OE_DEBUG_PUB.ADD('Right before inserting into temp table');
864: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
865: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
866: THEN
867: Insert_In_Temp_Table(p_header_id, 'PASS');
868: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR

Line 868: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR

864: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
865: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
866: THEN
867: Insert_In_Temp_Table(p_header_id, 'PASS');
868: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
869: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
870: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
871: THEN
872: Insert_In_Temp_Table(p_header_id, 'FAIL');

Line 869: (l_return_status = FND_API.G_RET_STS_SUCCESS AND

865: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
866: THEN
867: Insert_In_Temp_Table(p_header_id, 'PASS');
868: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
869: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
870: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
871: THEN
872: Insert_In_Temp_Table(p_header_id, 'FAIL');
873: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 873: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

869: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
870: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
871: THEN
872: Insert_In_Temp_Table(p_header_id, 'FAIL');
873: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
874: Insert_In_Temp_Table(p_header_id, 'ERROR');
875: END IF;
876: OE_DEBUG_PUB.ADD('Hold: Right after inserting into temp table');
877: END IF;

Line 966: x_return_status := FND_API.G_RET_STS_SUCCESS;

962:
963:
964: BEGIN
965: OE_DEBUG_PUB.ADD('IN Get_Unchecked_Exposure ');
966: x_return_status := FND_API.G_RET_STS_SUCCESS;
967:
968:
969: ---get credit check rule record
970: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule

Line 1112: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1108: END LOOP;
1109:
1110: ---bug fix 2439029
1111:
1112: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1113:
1114: x_return_status:='C';
1115:
1116: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

Line 1116: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

1112: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1113:
1114: x_return_status:='C';
1115:
1116: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1117: THEN
1118: RAISE FND_API.G_EXC_ERROR;
1119: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1120: THEN

Line 1118: RAISE FND_API.G_EXC_ERROR;

1114: x_return_status:='C';
1115:
1116: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1117: THEN
1118: RAISE FND_API.G_EXC_ERROR;
1119: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1120: THEN
1121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1122: END IF;

Line 1119: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1115:
1116: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1117: THEN
1118: RAISE FND_API.G_EXC_ERROR;
1119: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1120: THEN
1121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1122: END IF;
1123:

Line 1121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1117: THEN
1118: RAISE FND_API.G_EXC_ERROR;
1119: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1120: THEN
1121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1122: END IF;
1123:
1124: ----non pre-calculate exposure
1125: ELSIF l_credit_check_rule_rec.quick_cr_check_flag ='N'

Line 1265: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1261: END LOOP;
1262:
1263: ---bug fix 2439029
1264:
1265: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266:
1267: x_return_status:='C';
1268:
1269: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

Line 1269: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

1265: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266:
1267: x_return_status:='C';
1268:
1269: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1270: THEN
1271: RAISE FND_API.G_EXC_ERROR;
1272: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1273: THEN

Line 1271: RAISE FND_API.G_EXC_ERROR;

1267: x_return_status:='C';
1268:
1269: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1270: THEN
1271: RAISE FND_API.G_EXC_ERROR;
1272: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1273: THEN
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1275: END IF;

Line 1272: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1268:
1269: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1270: THEN
1271: RAISE FND_API.G_EXC_ERROR;
1272: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1273: THEN
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1275: END IF;
1276:

Line 1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1270: THEN
1271: RAISE FND_API.G_EXC_ERROR;
1272: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1273: THEN
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1275: END IF;
1276:
1277: ----non pre-calculate exposure
1278: ELSIF l_credit_check_rule_rec.quick_cr_check_flag ='N'

Line 1347: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1343: END LOOP;
1344:
1345: ---bug fix 2439029
1346:
1347: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1348:
1349: x_return_status:='C';
1350:
1351: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

Line 1351: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

1347: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1348:
1349: x_return_status:='C';
1350:
1351: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1352: THEN
1353: RAISE FND_API.G_EXC_ERROR;
1354: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1355: THEN

Line 1353: RAISE FND_API.G_EXC_ERROR;

1349: x_return_status:='C';
1350:
1351: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1352: THEN
1353: RAISE FND_API.G_EXC_ERROR;
1354: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1355: THEN
1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1357: END IF;

Line 1354: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1350:
1351: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1352: THEN
1353: RAISE FND_API.G_EXC_ERROR;
1354: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1355: THEN
1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1357: END IF;
1358:

Line 1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1352: THEN
1353: RAISE FND_API.G_EXC_ERROR;
1354: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1355: THEN
1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1357: END IF;
1358:
1359: END IF;
1360:

Line 1484: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1480: END LOOP;
1481:
1482: ---bug fix 2439029
1483:
1484: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1485:
1486: x_return_status:='C';
1487:
1488: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

Line 1488: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

1484: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1485:
1486: x_return_status:='C';
1487:
1488: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1489: THEN
1490: RAISE FND_API.G_EXC_ERROR;
1491: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1492: THEN

Line 1490: RAISE FND_API.G_EXC_ERROR;

1486: x_return_status:='C';
1487:
1488: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1489: THEN
1490: RAISE FND_API.G_EXC_ERROR;
1491: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1492: THEN
1493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1494: END IF;

Line 1491: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1487:
1488: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1489: THEN
1490: RAISE FND_API.G_EXC_ERROR;
1491: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1492: THEN
1493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1494: END IF;
1495:

Line 1493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1489: THEN
1490: RAISE FND_API.G_EXC_ERROR;
1491: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1492: THEN
1493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1494: END IF;
1495:
1496: ----non pre-calculate exposure
1497: ELSIF l_credit_check_rule_rec.quick_cr_check_flag ='N'

Line 1569: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1565: END LOOP;
1566:
1567: ---bug fix 2439029
1568:
1569: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570:
1571: x_return_status:='C';
1572:
1573: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

Line 1573: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

1569: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570:
1571: x_return_status:='C';
1572:
1573: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1574: THEN
1575: RAISE FND_API.G_EXC_ERROR;
1576: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1577: THEN

Line 1575: RAISE FND_API.G_EXC_ERROR;

1571: x_return_status:='C';
1572:
1573: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1574: THEN
1575: RAISE FND_API.G_EXC_ERROR;
1576: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1577: THEN
1578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1579: END IF;

Line 1576: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1572:
1573: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1574: THEN
1575: RAISE FND_API.G_EXC_ERROR;
1576: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1577: THEN
1578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1579: END IF;
1580:

Line 1578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1574: THEN
1575: RAISE FND_API.G_EXC_ERROR;
1576: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1577: THEN
1578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1579: END IF;
1580:
1581: END IF;
1582:

Line 1597: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1593: ( G_PKG_NAME
1594: , 'Get_unchecked_exposure'
1595: );
1596: END IF;
1597: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1598:
1599:
1600:
1601: END Get_unchecked_exposure;

Line 1937: l_return_status := FND_API.G_RET_STS_SUCCESS;

1933: BEGIN
1934:
1935:
1936: OE_DEBUG_PUB.ADD('IN OEXRCRCB:Credit_exposure_report_utils ');
1937: l_return_status := FND_API.G_RET_STS_SUCCESS;
1938: l_global_exposure_flag := 'N' ;
1939:
1940: ----get base currency=currency of the current operating unit
1941: l_base_currency:=OE_CREDIT_CHECK_UTIL.Get_GL_currency;

Line 2065: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

2061: l_return_status1:='C';
2062:
2063: EXIT;
2064:
2065: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2066: THEN
2067: RAISE FND_API.G_EXC_ERROR;
2068: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2069: THEN

Line 2067: RAISE FND_API.G_EXC_ERROR;

2063: EXIT;
2064:
2065: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2066: THEN
2067: RAISE FND_API.G_EXC_ERROR;
2068: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2069: THEN
2070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2071: END IF;

Line 2068: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2064:
2065: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2066: THEN
2067: RAISE FND_API.G_EXC_ERROR;
2068: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2069: THEN
2070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2071: END IF;
2072:

Line 2070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2066: THEN
2067: RAISE FND_API.G_EXC_ERROR;
2068: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2069: THEN
2070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2071: END IF;
2072:
2073: -----calculate available credit
2074: l_party_available:=party_prof_csr_rec.party_overall_limit - l_party_total_exposure;

Line 2225: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

2221: l_return_status1:='C';
2222:
2223: EXIT;
2224:
2225: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2226: THEN
2227: RAISE FND_API.G_EXC_ERROR;
2228: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2229: THEN

Line 2227: RAISE FND_API.G_EXC_ERROR;

2223: EXIT;
2224:
2225: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2226: THEN
2227: RAISE FND_API.G_EXC_ERROR;
2228: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2229: THEN
2230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2231: END IF;

Line 2228: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2224:
2225: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2226: THEN
2227: RAISE FND_API.G_EXC_ERROR;
2228: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2229: THEN
2230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2231: END IF;
2232:

Line 2230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2226: THEN
2227: RAISE FND_API.G_EXC_ERROR;
2228: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2229: THEN
2230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2231: END IF;
2232:
2233: OE_DEBUG_PUB.ADD('Check if the party has any credit profiles ');
2234: -----check if the party has any credit profiles

Line 2406: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

2402: l_return_status1:='C';
2403:
2404: EXIT;
2405:
2406: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2407: THEN
2408: RAISE FND_API.G_EXC_ERROR;
2409: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2410: THEN

Line 2408: RAISE FND_API.G_EXC_ERROR;

2404: EXIT;
2405:
2406: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2407: THEN
2408: RAISE FND_API.G_EXC_ERROR;
2409: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2410: THEN
2411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2412: END IF;

Line 2409: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2405:
2406: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2407: THEN
2408: RAISE FND_API.G_EXC_ERROR;
2409: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2410: THEN
2411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2412: END IF;
2413:

Line 2411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2407: THEN
2408: RAISE FND_API.G_EXC_ERROR;
2409: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2410: THEN
2411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2412: END IF;
2413:
2414: -----calculate available credit
2415: l_party_available:=party_prof_csr_rec.party_overall_limit - l_party_total_exposure;

Line 2565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

2561: l_return_status1:='C';
2562:
2563: EXIT;
2564:
2565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2566: THEN
2567: RAISE FND_API.G_EXC_ERROR;
2568: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2569: THEN

Line 2567: RAISE FND_API.G_EXC_ERROR;

2563: EXIT;
2564:
2565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2566: THEN
2567: RAISE FND_API.G_EXC_ERROR;
2568: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2569: THEN
2570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2571: END IF;

Line 2568: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2564:
2565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2566: THEN
2567: RAISE FND_API.G_EXC_ERROR;
2568: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2569: THEN
2570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2571: END IF;
2572:

Line 2570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2566: THEN
2567: RAISE FND_API.G_EXC_ERROR;
2568: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2569: THEN
2570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2571: END IF;
2572:
2573: OE_DEBUG_PUB.ADD('Check if the party has any credit profiles ');
2574: -----check if the party has any credit profiles

Line 2692: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

2688: l_return_status1:='C';
2689:
2690: EXIT;
2691:
2692: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2693: THEN
2694: RAISE FND_API.G_EXC_ERROR;
2695: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2696: THEN

Line 2694: RAISE FND_API.G_EXC_ERROR;

2690: EXIT;
2691:
2692: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2693: THEN
2694: RAISE FND_API.G_EXC_ERROR;
2695: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2696: THEN
2697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2698: END IF;

Line 2695: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2691:
2692: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2693: THEN
2694: RAISE FND_API.G_EXC_ERROR;
2695: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2696: THEN
2697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2698: END IF;
2699:

Line 2697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2693: THEN
2694: RAISE FND_API.G_EXC_ERROR;
2695: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2696: THEN
2697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2698: END IF;
2699:
2700: -----calculate available credit
2701: l_cust_available:=cust_prof_csr_rec.cust_overall_limit - l_cust_total_exposure;

Line 2863: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

2859: l_return_status1:='C';
2860:
2861: EXIT;
2862:
2863: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2864: THEN
2865: RAISE FND_API.G_EXC_ERROR;
2866: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2867: THEN

Line 2865: RAISE FND_API.G_EXC_ERROR;

2861: EXIT;
2862:
2863: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2864: THEN
2865: RAISE FND_API.G_EXC_ERROR;
2866: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2867: THEN
2868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2869: END IF;

Line 2866: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2862:
2863: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2864: THEN
2865: RAISE FND_API.G_EXC_ERROR;
2866: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2867: THEN
2868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2869: END IF;
2870:

Line 2868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2864: THEN
2865: RAISE FND_API.G_EXC_ERROR;
2866: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2867: THEN
2868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2869: END IF;
2870:
2871: OE_DEBUG_PUB.ADD('Check if the customer has any credit profiles ');
2872: -----check if the customer has any credit profiles

Line 3007: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

3003: l_return_status1:='C';
3004:
3005: EXIT;
3006:
3007: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3008: THEN
3009: RAISE FND_API.G_EXC_ERROR;
3010: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3011: THEN

Line 3009: RAISE FND_API.G_EXC_ERROR;

3005: EXIT;
3006:
3007: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3008: THEN
3009: RAISE FND_API.G_EXC_ERROR;
3010: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3011: THEN
3012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3013: END IF;

Line 3010: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

3006:
3007: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3008: THEN
3009: RAISE FND_API.G_EXC_ERROR;
3010: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3011: THEN
3012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3013: END IF;
3014:

Line 3012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3008: THEN
3009: RAISE FND_API.G_EXC_ERROR;
3010: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3011: THEN
3012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3013: END IF;
3014:
3015: -----calculate available credit
3016: l_party_available:=party_prof_csr_rec.party_overall_limit - l_party_total_exposure;

Line 3168: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

3164: l_return_status1:='C';
3165:
3166: EXIT;
3167:
3168: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3169: THEN
3170: RAISE FND_API.G_EXC_ERROR;
3171: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3172: THEN

Line 3170: RAISE FND_API.G_EXC_ERROR;

3166: EXIT;
3167:
3168: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3169: THEN
3170: RAISE FND_API.G_EXC_ERROR;
3171: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3172: THEN
3173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3174: END IF;

Line 3171: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

3167:
3168: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3169: THEN
3170: RAISE FND_API.G_EXC_ERROR;
3171: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3172: THEN
3173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3174: END IF;
3175:

Line 3173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3169: THEN
3170: RAISE FND_API.G_EXC_ERROR;
3171: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3172: THEN
3173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3174: END IF;
3175:
3176: OE_DEBUG_PUB.ADD('Check if the party has any credit profiles ');
3177: -----check if the party has any credit profiles

Line 3297: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

3293: l_return_status1:='C';
3294:
3295: EXIT;
3296:
3297: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3298: THEN
3299: RAISE FND_API.G_EXC_ERROR;
3300: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3301: THEN

Line 3299: RAISE FND_API.G_EXC_ERROR;

3295: EXIT;
3296:
3297: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3298: THEN
3299: RAISE FND_API.G_EXC_ERROR;
3300: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3301: THEN
3302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3303: END IF;

Line 3300: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

3296:
3297: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3298: THEN
3299: RAISE FND_API.G_EXC_ERROR;
3300: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3301: THEN
3302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3303: END IF;
3304:

Line 3302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3298: THEN
3299: RAISE FND_API.G_EXC_ERROR;
3300: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3301: THEN
3302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3303: END IF;
3304:
3305: -----calculate available credit
3306: l_cust_available:=cust_prof_csr_rec.cust_overall_limit - l_cust_total_exposure;

Line 3466: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

3462: l_return_status1:='C';
3463:
3464: EXIT;
3465:
3466: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3467: THEN
3468: RAISE FND_API.G_EXC_ERROR;
3469: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3470: THEN

Line 3468: RAISE FND_API.G_EXC_ERROR;

3464: EXIT;
3465:
3466: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3467: THEN
3468: RAISE FND_API.G_EXC_ERROR;
3469: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3470: THEN
3471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3472: END IF;

Line 3469: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

3465:
3466: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3467: THEN
3468: RAISE FND_API.G_EXC_ERROR;
3469: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3470: THEN
3471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3472: END IF;
3473:

Line 3471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3467: THEN
3468: RAISE FND_API.G_EXC_ERROR;
3469: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3470: THEN
3471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3472: END IF;
3473:
3474: OE_DEBUG_PUB.ADD('Check if the customer has any credit profiles ');
3475: -----check if the customer has any credit profiles

Line 3808: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

3804: l_return_status1:='C';
3805:
3806: EXIT;
3807:
3808: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3809: THEN
3810: RAISE FND_API.G_EXC_ERROR;
3811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3812: THEN

Line 3810: RAISE FND_API.G_EXC_ERROR;

3806: EXIT;
3807:
3808: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3809: THEN
3810: RAISE FND_API.G_EXC_ERROR;
3811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3812: THEN
3813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3814: END IF;

Line 3811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

3807:
3808: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3809: THEN
3810: RAISE FND_API.G_EXC_ERROR;
3811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3812: THEN
3813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3814: END IF;
3815:

Line 3813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3809: THEN
3810: RAISE FND_API.G_EXC_ERROR;
3811: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3812: THEN
3813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3814: END IF;
3815:
3816: -----calculate available credit
3817: l_cust_available:=cust_prof_csr_rec.cust_overall_limit - l_cust_total_exposure;

Line 3977: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

3973: l_return_status1:='C';
3974:
3975: EXIT;
3976:
3977: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3978: THEN
3979: RAISE FND_API.G_EXC_ERROR;
3980: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3981: THEN

Line 3979: RAISE FND_API.G_EXC_ERROR;

3975: EXIT;
3976:
3977: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3978: THEN
3979: RAISE FND_API.G_EXC_ERROR;
3980: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3981: THEN
3982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3983: END IF;

Line 3980: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

3976:
3977: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3978: THEN
3979: RAISE FND_API.G_EXC_ERROR;
3980: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3981: THEN
3982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3983: END IF;
3984:

Line 3982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3978: THEN
3979: RAISE FND_API.G_EXC_ERROR;
3980: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3981: THEN
3982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3983: END IF;
3984:
3985: OE_DEBUG_PUB.ADD('Check if the customer has any credit profiles ');
3986: -----check if the customer has any credit profiles

Line 4113: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

4109: l_return_status1:='C';
4110:
4111: EXIT;
4112:
4113: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
4114: THEN
4115: RAISE FND_API.G_EXC_ERROR;
4116: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4117: THEN

Line 4115: RAISE FND_API.G_EXC_ERROR;

4111: EXIT;
4112:
4113: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
4114: THEN
4115: RAISE FND_API.G_EXC_ERROR;
4116: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4117: THEN
4118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4119: END IF;

Line 4116: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

4112:
4113: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
4114: THEN
4115: RAISE FND_API.G_EXC_ERROR;
4116: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4117: THEN
4118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4119: END IF;
4120:

Line 4118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4114: THEN
4115: RAISE FND_API.G_EXC_ERROR;
4116: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4117: THEN
4118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4119: END IF;
4120:
4121: -----calculate available credit
4122: l_site_available:=site_prof_csr_rec.site_overall_limit - l_site_total_exposure;

Line 4257: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

4253: l_return_status1:='C';
4254:
4255: EXIT;
4256:
4257: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
4258: THEN
4259: RAISE FND_API.G_EXC_ERROR;
4260: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4261: THEN

Line 4259: RAISE FND_API.G_EXC_ERROR;

4255: EXIT;
4256:
4257: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
4258: THEN
4259: RAISE FND_API.G_EXC_ERROR;
4260: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4261: THEN
4262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4263: END IF;

Line 4260: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

4256:
4257: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
4258: THEN
4259: RAISE FND_API.G_EXC_ERROR;
4260: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4261: THEN
4262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4263: END IF;
4264:

Line 4262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4258: THEN
4259: RAISE FND_API.G_EXC_ERROR;
4260: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4261: THEN
4262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4263: END IF;
4264:
4265: OE_DEBUG_PUB.ADD('Check if the customer site has any credit profiles ');
4266: