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

APPS.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 626: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND

622: OE_DEBUG_PUB.ADD('Check_Credit return status = '||l_return_status);
623: --
624: -- Insert the result into the temporary table
625: --
626: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
627: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
628: THEN
629: Insert_In_Temp_Table(f_release_header_id, 'PASS');
630: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR

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

626: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
627: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
628: THEN
629: Insert_In_Temp_Table(f_release_header_id, 'PASS');
630: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
631: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
632: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
633: THEN
634: Insert_In_Temp_Table(f_release_header_id, 'FAIL');

Line 631: (l_return_status = FND_API.G_RET_STS_SUCCESS AND

627: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
628: THEN
629: Insert_In_Temp_Table(f_release_header_id, 'PASS');
630: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
631: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
632: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
633: THEN
634: Insert_In_Temp_Table(f_release_header_id, 'FAIL');
635: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 635: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

631: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
632: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
633: THEN
634: Insert_In_Temp_Table(f_release_header_id, 'FAIL');
635: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
636: Insert_In_Temp_Table(f_release_header_id, 'ERROR');
637: END IF;
638: END LOOP;
639:

Line 671: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND

667: OE_DEBUG_PUB.ADD('Check_Credit return status = '||l_return_status);
668: --
669: -- Insert the result into the temporary table
670: --
671: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
672: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
673: THEN
674: Insert_In_Temp_Table(f_hold_header_id, 'PASS');
675: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR

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

671: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
672: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
673: THEN
674: Insert_In_Temp_Table(f_hold_header_id, 'PASS');
675: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
676: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
677: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
678: THEN
679: Insert_In_Temp_Table(f_hold_header_id, 'FAIL');

Line 676: (l_return_status = FND_API.G_RET_STS_SUCCESS AND

672: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
673: THEN
674: Insert_In_Temp_Table(f_hold_header_id, 'PASS');
675: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
676: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
677: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
678: THEN
679: Insert_In_Temp_Table(f_hold_header_id, 'FAIL');
680: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 680: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

676: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
677: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
678: THEN
679: Insert_In_Temp_Table(f_hold_header_id, 'FAIL');
680: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
681: Insert_In_Temp_Table(f_hold_header_id, 'ERROR');
682: END IF;
683: END LOOP;
684: --

Line 740: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND

736: OE_DEBUG_PUB.ADD('Check_Credit return status = '||l_return_status);
737: --
738: -- Insert the result into the temporary table
739: --
740: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
741: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
742: THEN
743: Insert_In_Temp_Table(f_release_header_id, 'PASS');
744: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR

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

740: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
741: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
742: THEN
743: Insert_In_Temp_Table(f_release_header_id, 'PASS');
744: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
745: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
746: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
747: THEN
748: Insert_In_Temp_Table(f_release_header_id, 'FAIL');

Line 745: (l_return_status = FND_API.G_RET_STS_SUCCESS AND

741: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
742: THEN
743: Insert_In_Temp_Table(f_release_header_id, 'PASS');
744: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
745: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
746: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
747: THEN
748: Insert_In_Temp_Table(f_release_header_id, 'FAIL');
749: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 749: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

745: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
746: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
747: THEN
748: Insert_In_Temp_Table(f_release_header_id, 'FAIL');
749: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
750: Insert_In_Temp_Table(f_release_header_id, 'ERROR');
751: END IF;
752: END LOOP;
753:

Line 783: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND

779: OE_DEBUG_PUB.ADD('Check_Credit return status = '||l_return_status);
780: --
781: -- Insert the result into the temporary table
782: --
783: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
784: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
785: THEN
786: Insert_In_Temp_Table(f_hold_header_id, 'PASS');
787: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR

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

783: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
784: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
785: THEN
786: Insert_In_Temp_Table(f_hold_header_id, 'PASS');
787: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
788: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
789: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
790: THEN
791: Insert_In_Temp_Table(f_hold_header_id, 'FAIL');

Line 788: (l_return_status = FND_API.G_RET_STS_SUCCESS AND

784: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
785: THEN
786: Insert_In_Temp_Table(f_hold_header_id, 'PASS');
787: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
788: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
789: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
790: THEN
791: Insert_In_Temp_Table(f_hold_header_id, 'FAIL');
792: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 792: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

788: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
789: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
790: THEN
791: Insert_In_Temp_Table(f_hold_header_id, 'FAIL');
792: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
793: Insert_In_Temp_Table(f_hold_header_id, 'ERROR');
794: END IF;
795: END LOOP;
796: END LOOP;

Line 828: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND

824: --
825: -- Insert the results into the temporary table
826: --
827: OE_DEBUG_PUB.ADD('Right before inserting into temp table');
828: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
829: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
830: THEN
831: Insert_In_Temp_Table(p_header_id, 'PASS');
832: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR

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

828: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
829: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
830: THEN
831: Insert_In_Temp_Table(p_header_id, 'PASS');
832: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
833: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
834: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
835: THEN
836: Insert_In_Temp_Table(p_header_id, 'FAIL');

Line 833: (l_return_status = FND_API.G_RET_STS_SUCCESS AND

829: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
830: THEN
831: Insert_In_Temp_Table(p_header_id, 'PASS');
832: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
833: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
834: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
835: THEN
836: Insert_In_Temp_Table(p_header_id, 'FAIL');
837: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 837: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

833: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
834: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
835: THEN
836: Insert_In_Temp_Table(p_header_id, 'FAIL');
837: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
838: Insert_In_Temp_Table(p_header_id, 'ERROR');
839: END IF;
840: OE_DEBUG_PUB.ADD('Release: Right after inserting into temp table');
841:

Line 856: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND

852: --
853: -- Insert the results into the temporary table
854: --
855: OE_DEBUG_PUB.ADD('Right before inserting into temp table');
856: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
857: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
858: THEN
859: Insert_In_Temp_Table(p_header_id, 'PASS');
860: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR

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

856: IF (l_return_status = FND_API.G_RET_STS_SUCCESS AND
857: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
858: THEN
859: Insert_In_Temp_Table(p_header_id, 'PASS');
860: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
861: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
862: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
863: THEN
864: Insert_In_Temp_Table(p_header_id, 'FAIL');

Line 861: (l_return_status = FND_API.G_RET_STS_SUCCESS AND

857: (l_result_out = 'PASS' OR l_result_out = 'PASS_REL')) --bug# 5187621
858: THEN
859: Insert_In_Temp_Table(p_header_id, 'PASS');
860: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) OR
861: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
862: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
863: THEN
864: Insert_In_Temp_Table(p_header_id, 'FAIL');
865: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 865: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

861: (l_return_status = FND_API.G_RET_STS_SUCCESS AND
862: (l_result_out = 'FAIL' OR l_result_out = 'FAIL_HOLD' OR l_result_out = 'FAIL_NONE')) --bug# 5187621
863: THEN
864: Insert_In_Temp_Table(p_header_id, 'FAIL');
865: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
866: Insert_In_Temp_Table(p_header_id, 'ERROR');
867: END IF;
868: OE_DEBUG_PUB.ADD('Hold: Right after inserting into temp table');
869: END IF;

Line 958: x_return_status := FND_API.G_RET_STS_SUCCESS;

954:
955:
956: BEGIN
957: OE_DEBUG_PUB.ADD('IN Get_Unchecked_Exposure ');
958: x_return_status := FND_API.G_RET_STS_SUCCESS;
959:
960:
961: ---get credit check rule record
962: OE_CREDIT_CHECK_UTIL.GET_credit_check_rule

Line 1104: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1100: END LOOP;
1101:
1102: ---bug fix 2439029
1103:
1104: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105:
1106: x_return_status:='C';
1107:
1108: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

Line 1108: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

1104: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105:
1106: x_return_status:='C';
1107:
1108: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1109: THEN
1110: RAISE FND_API.G_EXC_ERROR;
1111: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1112: THEN

Line 1110: RAISE FND_API.G_EXC_ERROR;

1106: x_return_status:='C';
1107:
1108: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1109: THEN
1110: RAISE FND_API.G_EXC_ERROR;
1111: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1112: THEN
1113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1114: END IF;

Line 1111: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1107:
1108: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1109: THEN
1110: RAISE FND_API.G_EXC_ERROR;
1111: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1112: THEN
1113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1114: END IF;
1115:

Line 1113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1109: THEN
1110: RAISE FND_API.G_EXC_ERROR;
1111: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1112: THEN
1113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1114: END IF;
1115:
1116: ----non pre-calculate exposure
1117: ELSIF l_credit_check_rule_rec.quick_cr_check_flag ='N'

Line 1257: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1253: END LOOP;
1254:
1255: ---bug fix 2439029
1256:
1257: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1258:
1259: x_return_status:='C';
1260:
1261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

Line 1261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

1257: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1258:
1259: x_return_status:='C';
1260:
1261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1262: THEN
1263: RAISE FND_API.G_EXC_ERROR;
1264: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1265: THEN

Line 1263: RAISE FND_API.G_EXC_ERROR;

1259: x_return_status:='C';
1260:
1261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1262: THEN
1263: RAISE FND_API.G_EXC_ERROR;
1264: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1265: THEN
1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1267: END IF;

Line 1264: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1260:
1261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1262: THEN
1263: RAISE FND_API.G_EXC_ERROR;
1264: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1265: THEN
1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1267: END IF;
1268:

Line 1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1262: THEN
1263: RAISE FND_API.G_EXC_ERROR;
1264: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1265: THEN
1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1267: END IF;
1268:
1269: ----non pre-calculate exposure
1270: ELSIF l_credit_check_rule_rec.quick_cr_check_flag ='N'

Line 1339: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1335: END LOOP;
1336:
1337: ---bug fix 2439029
1338:
1339: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1340:
1341: x_return_status:='C';
1342:
1343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

Line 1343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

1339: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1340:
1341: x_return_status:='C';
1342:
1343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1344: THEN
1345: RAISE FND_API.G_EXC_ERROR;
1346: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1347: THEN

Line 1345: RAISE FND_API.G_EXC_ERROR;

1341: x_return_status:='C';
1342:
1343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1344: THEN
1345: RAISE FND_API.G_EXC_ERROR;
1346: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1347: THEN
1348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1349: END IF;

Line 1346: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1342:
1343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1344: THEN
1345: RAISE FND_API.G_EXC_ERROR;
1346: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1347: THEN
1348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1349: END IF;
1350:

Line 1348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1344: THEN
1345: RAISE FND_API.G_EXC_ERROR;
1346: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1347: THEN
1348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1349: END IF;
1350:
1351: END IF;
1352:

Line 1476: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1472: END LOOP;
1473:
1474: ---bug fix 2439029
1475:
1476: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1477:
1478: x_return_status:='C';
1479:
1480: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

Line 1480: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

1476: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1477:
1478: x_return_status:='C';
1479:
1480: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1481: THEN
1482: RAISE FND_API.G_EXC_ERROR;
1483: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1484: THEN

Line 1482: RAISE FND_API.G_EXC_ERROR;

1478: x_return_status:='C';
1479:
1480: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1481: THEN
1482: RAISE FND_API.G_EXC_ERROR;
1483: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1484: THEN
1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1486: END IF;

Line 1483: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1479:
1480: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1481: THEN
1482: RAISE FND_API.G_EXC_ERROR;
1483: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1484: THEN
1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1486: END IF;
1487:

Line 1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1481: THEN
1482: RAISE FND_API.G_EXC_ERROR;
1483: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1484: THEN
1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1486: END IF;
1487:
1488: ----non pre-calculate exposure
1489: ELSIF l_credit_check_rule_rec.quick_cr_check_flag ='N'

Line 1561: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1557: END LOOP;
1558:
1559: ---bug fix 2439029
1560:
1561: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1562:
1563: x_return_status:='C';
1564:
1565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

Line 1565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

1561: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1562:
1563: x_return_status:='C';
1564:
1565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1566: THEN
1567: RAISE FND_API.G_EXC_ERROR;
1568: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1569: THEN

Line 1567: RAISE FND_API.G_EXC_ERROR;

1563: x_return_status:='C';
1564:
1565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1566: THEN
1567: RAISE FND_API.G_EXC_ERROR;
1568: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1569: THEN
1570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1571: END IF;

Line 1568: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1564:
1565: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1566: THEN
1567: RAISE FND_API.G_EXC_ERROR;
1568: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1569: THEN
1570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1571: END IF;
1572:

Line 1570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1566: THEN
1567: RAISE FND_API.G_EXC_ERROR;
1568: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1569: THEN
1570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1571: END IF;
1572:
1573: END IF;
1574:

Line 1589: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

1585: ( G_PKG_NAME
1586: , 'Get_unchecked_exposure'
1587: );
1588: END IF;
1589: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1590:
1591:
1592:
1593: END Get_unchecked_exposure;

Line 1926: l_return_status := FND_API.G_RET_STS_SUCCESS;

1922: BEGIN
1923:
1924:
1925: OE_DEBUG_PUB.ADD('IN OEXRCRCB:Credit_exposure_report_utils ');
1926: l_return_status := FND_API.G_RET_STS_SUCCESS;
1927: l_global_exposure_flag := 'N' ;
1928:
1929: ----get base currency=currency of the current operating unit
1930: l_base_currency:=OE_CREDIT_CHECK_UTIL.Get_GL_currency;

Line 2054: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

2050: l_return_status1:='C';
2051:
2052: EXIT;
2053:
2054: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2055: THEN
2056: RAISE FND_API.G_EXC_ERROR;
2057: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2058: THEN

Line 2056: RAISE FND_API.G_EXC_ERROR;

2052: EXIT;
2053:
2054: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2055: THEN
2056: RAISE FND_API.G_EXC_ERROR;
2057: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2058: THEN
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: END IF;

Line 2057: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2053:
2054: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2055: THEN
2056: RAISE FND_API.G_EXC_ERROR;
2057: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2058: THEN
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: END IF;
2061:

Line 2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2055: THEN
2056: RAISE FND_API.G_EXC_ERROR;
2057: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2058: THEN
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: END IF;
2061:
2062: -----calculate available credit
2063: l_party_available:=party_prof_csr_rec.party_overall_limit - l_party_total_exposure;

Line 2214: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

2210: l_return_status1:='C';
2211:
2212: EXIT;
2213:
2214: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2215: THEN
2216: RAISE FND_API.G_EXC_ERROR;
2217: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2218: THEN

Line 2216: RAISE FND_API.G_EXC_ERROR;

2212: EXIT;
2213:
2214: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2215: THEN
2216: RAISE FND_API.G_EXC_ERROR;
2217: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2218: THEN
2219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2220: END IF;

Line 2217: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2213:
2214: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2215: THEN
2216: RAISE FND_API.G_EXC_ERROR;
2217: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2218: THEN
2219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2220: END IF;
2221:

Line 2219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2215: THEN
2216: RAISE FND_API.G_EXC_ERROR;
2217: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2218: THEN
2219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2220: END IF;
2221:
2222: OE_DEBUG_PUB.ADD('Check if the party has any credit profiles ');
2223: -----check if the party has any credit profiles

Line 2394: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

2390: l_return_status1:='C';
2391:
2392: EXIT;
2393:
2394: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2395: THEN
2396: RAISE FND_API.G_EXC_ERROR;
2397: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2398: THEN

Line 2396: RAISE FND_API.G_EXC_ERROR;

2392: EXIT;
2393:
2394: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2395: THEN
2396: RAISE FND_API.G_EXC_ERROR;
2397: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2398: THEN
2399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2400: END IF;

Line 2397: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2393:
2394: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2395: THEN
2396: RAISE FND_API.G_EXC_ERROR;
2397: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2398: THEN
2399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2400: END IF;
2401:

Line 2399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2395: THEN
2396: RAISE FND_API.G_EXC_ERROR;
2397: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2398: THEN
2399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2400: END IF;
2401:
2402: -----calculate available credit
2403: l_party_available:=party_prof_csr_rec.party_overall_limit - l_party_total_exposure;

Line 2553: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

2549: l_return_status1:='C';
2550:
2551: EXIT;
2552:
2553: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2554: THEN
2555: RAISE FND_API.G_EXC_ERROR;
2556: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2557: THEN

Line 2555: RAISE FND_API.G_EXC_ERROR;

2551: EXIT;
2552:
2553: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2554: THEN
2555: RAISE FND_API.G_EXC_ERROR;
2556: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2557: THEN
2558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2559: END IF;

Line 2556: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2552:
2553: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2554: THEN
2555: RAISE FND_API.G_EXC_ERROR;
2556: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2557: THEN
2558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2559: END IF;
2560:

Line 2558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2554: THEN
2555: RAISE FND_API.G_EXC_ERROR;
2556: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2557: THEN
2558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2559: END IF;
2560:
2561: OE_DEBUG_PUB.ADD('Check if the party has any credit profiles ');
2562: -----check if the party has any credit profiles

Line 2679: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

2675: l_return_status1:='C';
2676:
2677: EXIT;
2678:
2679: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2680: THEN
2681: RAISE FND_API.G_EXC_ERROR;
2682: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2683: THEN

Line 2681: RAISE FND_API.G_EXC_ERROR;

2677: EXIT;
2678:
2679: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2680: THEN
2681: RAISE FND_API.G_EXC_ERROR;
2682: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2683: THEN
2684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2685: END IF;

Line 2682: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2678:
2679: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2680: THEN
2681: RAISE FND_API.G_EXC_ERROR;
2682: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2683: THEN
2684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2685: END IF;
2686:

Line 2684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2680: THEN
2681: RAISE FND_API.G_EXC_ERROR;
2682: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2683: THEN
2684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2685: END IF;
2686:
2687: -----calculate available credit
2688: l_cust_available:=cust_prof_csr_rec.cust_overall_limit - l_cust_total_exposure;

Line 2850: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

2846: l_return_status1:='C';
2847:
2848: EXIT;
2849:
2850: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2851: THEN
2852: RAISE FND_API.G_EXC_ERROR;
2853: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2854: THEN

Line 2852: RAISE FND_API.G_EXC_ERROR;

2848: EXIT;
2849:
2850: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2851: THEN
2852: RAISE FND_API.G_EXC_ERROR;
2853: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2854: THEN
2855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2856: END IF;

Line 2853: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2849:
2850: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2851: THEN
2852: RAISE FND_API.G_EXC_ERROR;
2853: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2854: THEN
2855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2856: END IF;
2857:

Line 2855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2851: THEN
2852: RAISE FND_API.G_EXC_ERROR;
2853: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2854: THEN
2855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2856: END IF;
2857:
2858: OE_DEBUG_PUB.ADD('Check if the customer has any credit profiles ');
2859: -----check if the customer has any credit profiles

Line 2993: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

2989: l_return_status1:='C';
2990:
2991: EXIT;
2992:
2993: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2994: THEN
2995: RAISE FND_API.G_EXC_ERROR;
2996: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2997: THEN

Line 2995: RAISE FND_API.G_EXC_ERROR;

2991: EXIT;
2992:
2993: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2994: THEN
2995: RAISE FND_API.G_EXC_ERROR;
2996: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2997: THEN
2998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2999: END IF;

Line 2996: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

2992:
2993: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
2994: THEN
2995: RAISE FND_API.G_EXC_ERROR;
2996: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2997: THEN
2998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2999: END IF;
3000:

Line 2998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2994: THEN
2995: RAISE FND_API.G_EXC_ERROR;
2996: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
2997: THEN
2998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2999: END IF;
3000:
3001: -----calculate available credit
3002: l_party_available:=party_prof_csr_rec.party_overall_limit - l_party_total_exposure;

Line 3154: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

3150: l_return_status1:='C';
3151:
3152: EXIT;
3153:
3154: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3155: THEN
3156: RAISE FND_API.G_EXC_ERROR;
3157: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3158: THEN

Line 3156: RAISE FND_API.G_EXC_ERROR;

3152: EXIT;
3153:
3154: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3155: THEN
3156: RAISE FND_API.G_EXC_ERROR;
3157: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3158: THEN
3159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3160: END IF;

Line 3157: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

3153:
3154: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3155: THEN
3156: RAISE FND_API.G_EXC_ERROR;
3157: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3158: THEN
3159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3160: END IF;
3161:

Line 3159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3155: THEN
3156: RAISE FND_API.G_EXC_ERROR;
3157: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3158: THEN
3159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3160: END IF;
3161:
3162: OE_DEBUG_PUB.ADD('Check if the party has any credit profiles ');
3163: -----check if the party has any credit profiles

Line 3282: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

3278: l_return_status1:='C';
3279:
3280: EXIT;
3281:
3282: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3283: THEN
3284: RAISE FND_API.G_EXC_ERROR;
3285: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3286: THEN

Line 3284: RAISE FND_API.G_EXC_ERROR;

3280: EXIT;
3281:
3282: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3283: THEN
3284: RAISE FND_API.G_EXC_ERROR;
3285: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3286: THEN
3287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3288: END IF;

Line 3285: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

3281:
3282: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3283: THEN
3284: RAISE FND_API.G_EXC_ERROR;
3285: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3286: THEN
3287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3288: END IF;
3289:

Line 3287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3283: THEN
3284: RAISE FND_API.G_EXC_ERROR;
3285: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3286: THEN
3287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3288: END IF;
3289:
3290: -----calculate available credit
3291: l_cust_available:=cust_prof_csr_rec.cust_overall_limit - l_cust_total_exposure;

Line 3451: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

3447: l_return_status1:='C';
3448:
3449: EXIT;
3450:
3451: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3452: THEN
3453: RAISE FND_API.G_EXC_ERROR;
3454: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3455: THEN

Line 3453: RAISE FND_API.G_EXC_ERROR;

3449: EXIT;
3450:
3451: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3452: THEN
3453: RAISE FND_API.G_EXC_ERROR;
3454: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3455: THEN
3456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3457: END IF;

Line 3454: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

3450:
3451: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3452: THEN
3453: RAISE FND_API.G_EXC_ERROR;
3454: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3455: THEN
3456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3457: END IF;
3458:

Line 3456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3452: THEN
3453: RAISE FND_API.G_EXC_ERROR;
3454: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3455: THEN
3456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3457: END IF;
3458:
3459: OE_DEBUG_PUB.ADD('Check if the customer has any credit profiles ');
3460: -----check if the customer has any credit profiles

Line 3783: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

3779: l_return_status1:='C';
3780:
3781: EXIT;
3782:
3783: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3784: THEN
3785: RAISE FND_API.G_EXC_ERROR;
3786: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3787: THEN

Line 3785: RAISE FND_API.G_EXC_ERROR;

3781: EXIT;
3782:
3783: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3784: THEN
3785: RAISE FND_API.G_EXC_ERROR;
3786: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3787: THEN
3788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3789: END IF;

Line 3786: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

3782:
3783: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3784: THEN
3785: RAISE FND_API.G_EXC_ERROR;
3786: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3787: THEN
3788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3789: END IF;
3790:

Line 3788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3784: THEN
3785: RAISE FND_API.G_EXC_ERROR;
3786: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3787: THEN
3788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3789: END IF;
3790:
3791: -----calculate available credit
3792: l_cust_available:=cust_prof_csr_rec.cust_overall_limit - l_cust_total_exposure;

Line 3952: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

3948: l_return_status1:='C';
3949:
3950: EXIT;
3951:
3952: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3953: THEN
3954: RAISE FND_API.G_EXC_ERROR;
3955: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3956: THEN

Line 3954: RAISE FND_API.G_EXC_ERROR;

3950: EXIT;
3951:
3952: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3953: THEN
3954: RAISE FND_API.G_EXC_ERROR;
3955: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3956: THEN
3957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3958: END IF;

Line 3955: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

3951:
3952: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
3953: THEN
3954: RAISE FND_API.G_EXC_ERROR;
3955: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3956: THEN
3957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3958: END IF;
3959:

Line 3957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3953: THEN
3954: RAISE FND_API.G_EXC_ERROR;
3955: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
3956: THEN
3957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3958: END IF;
3959:
3960: OE_DEBUG_PUB.ADD('Check if the customer has any credit profiles ');
3961: -----check if the customer has any credit profiles

Line 4087: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

4083: l_return_status1:='C';
4084:
4085: EXIT;
4086:
4087: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
4088: THEN
4089: RAISE FND_API.G_EXC_ERROR;
4090: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4091: THEN

Line 4089: RAISE FND_API.G_EXC_ERROR;

4085: EXIT;
4086:
4087: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
4088: THEN
4089: RAISE FND_API.G_EXC_ERROR;
4090: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4091: THEN
4092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4093: END IF;

Line 4090: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

4086:
4087: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
4088: THEN
4089: RAISE FND_API.G_EXC_ERROR;
4090: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4091: THEN
4092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4093: END IF;
4094:

Line 4092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4088: THEN
4089: RAISE FND_API.G_EXC_ERROR;
4090: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4091: THEN
4092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4093: END IF;
4094:
4095: -----calculate available credit
4096: l_site_available:=site_prof_csr_rec.site_overall_limit - l_site_total_exposure;

Line 4231: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

4227: l_return_status1:='C';
4228:
4229: EXIT;
4230:
4231: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
4232: THEN
4233: RAISE FND_API.G_EXC_ERROR;
4234: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4235: THEN

Line 4233: RAISE FND_API.G_EXC_ERROR;

4229: EXIT;
4230:
4231: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
4232: THEN
4233: RAISE FND_API.G_EXC_ERROR;
4234: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4235: THEN
4236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4237: END IF;

Line 4234: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

4230:
4231: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
4232: THEN
4233: RAISE FND_API.G_EXC_ERROR;
4234: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4235: THEN
4236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4237: END IF;
4238:

Line 4236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4232: THEN
4233: RAISE FND_API.G_EXC_ERROR;
4234: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
4235: THEN
4236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4237: END IF;
4238:
4239: OE_DEBUG_PUB.ADD('Check if the customer site has any credit profiles ');
4240: