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_ENGINE_GRP dependencies on FND_API

Line 522: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

518: , x_msg_data => l_msg_data
519: , x_return_status => x_return_status
520: );
521:
522: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
523: RAISE FND_API.G_EXC_ERROR;
524: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: END IF;

Line 523: RAISE FND_API.G_EXC_ERROR;

519: , x_return_status => x_return_status
520: );
521:
522: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
523: RAISE FND_API.G_EXC_ERROR;
524: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: END IF;
527:

Line 524: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

520: );
521:
522: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
523: RAISE FND_API.G_EXC_ERROR;
524: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: END IF;
527:
528: IF l_hold_result = FND_API.G_TRUE

Line 525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

521:
522: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
523: RAISE FND_API.G_EXC_ERROR;
524: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: END IF;
527:
528: IF l_hold_result = FND_API.G_TRUE
529: THEN

Line 528: IF l_hold_result = FND_API.G_TRUE

524: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
526: END IF;
527:
528: IF l_hold_result = FND_API.G_TRUE
529: THEN
530: OE_DEBUG_PUB.Add('OEXVCRHB: Hold already applied on Header ID:' ||
531: p_header_id );
532: ELSE

Line 541: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

537: OE_DEBUG_PUB.Add('Call OE_Holds_PUB.Apply_Holds' );
538:
539: OE_Holds_PUB.Apply_Holds
540: ( p_api_version => 1.0
541: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
542: , p_hold_source_rec => l_hold_source_rec
543: , x_msg_count => l_msg_count
544: , x_msg_data => l_msg_data
545: , x_return_status => x_return_status

Line 548: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

544: , x_msg_data => l_msg_data
545: , x_return_status => x_return_status
546: );
547:
548: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
549: RAISE FND_API.G_EXC_ERROR;
550: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
552: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 549: RAISE FND_API.G_EXC_ERROR;

545: , x_return_status => x_return_status
546: );
547:
548: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
549: RAISE FND_API.G_EXC_ERROR;
550: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
552: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
553: OE_DEBUG_PUB.ADD('OEXPCRGB: Credit check hold applied on header_ID: '

Line 550: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

546: );
547:
548: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
549: RAISE FND_API.G_EXC_ERROR;
550: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
552: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
553: OE_DEBUG_PUB.ADD('OEXPCRGB: Credit check hold applied on header_ID: '
554: ||p_header_id, 1);

Line 551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

547:
548: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
549: RAISE FND_API.G_EXC_ERROR;
550: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
552: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
553: OE_DEBUG_PUB.ADD('OEXPCRGB: Credit check hold applied on header_ID: '
554: ||p_header_id, 1);
555: END IF;

Line 552: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

548: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
549: RAISE FND_API.G_EXC_ERROR;
550: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
552: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
553: OE_DEBUG_PUB.ADD('OEXPCRGB: Credit check hold applied on header_ID: '
554: ||p_header_id, 1);
555: END IF;
556: END IF; -- Check hold exist

Line 566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

562:
563: EXCEPTION
564:
565: WHEN OTHERS THEN
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
567: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
568: OE_MSG_PUB.Add_Exc_Msg
569: ( G_PKG_NAME
570: , 'Apply_exception_hold'

Line 674: x_return_status := FND_API.G_RET_STS_SUCCESS;

670: l_result_out VARCHAR2(100);
671: l_cc_hold_comment VARCHAR2(2000):= NULL;
672:
673: BEGIN
674: x_return_status := FND_API.G_RET_STS_SUCCESS;
675:
676: IF G_debug_flag = 'Y'
677: THEN
678: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Credit_check_with_payment_typ ',1);

Line 709: IF x_return_status = FND_API.G_RET_STS_ERROR

705: THEN
706: OE_DEBUG_PUB.ADD('x_return_status '|| x_return_status );
707: END IF;
708:
709: IF x_return_status = FND_API.G_RET_STS_ERROR
710: THEN
711: -- Assign the status to SUCCESS as the order will
712: -- put on hold when the status is error
713: -- GL currency conversion

Line 715: x_return_status := FND_API.G_RET_STS_SUCCESS ;

711: -- Assign the status to SUCCESS as the order will
712: -- put on hold when the status is error
713: -- GL currency conversion
714:
715: x_return_status := FND_API.G_RET_STS_SUCCESS ;
716:
717: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
719: END IF;

Line 717: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

713: -- GL currency conversion
714:
715: x_return_status := FND_API.G_RET_STS_SUCCESS ;
716:
717: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
719: END IF;
720:
721: IF G_debug_flag = 'Y'

Line 718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

714:
715: x_return_status := FND_API.G_RET_STS_SUCCESS ;
716:
717: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
719: END IF;
720:
721: IF G_debug_flag = 'Y'
722: THEN

Line 732: WHEN FND_API.G_EXC_ERROR THEN

728: Oe_Globals.G_calling_source:= 'WSH'; --8478151
729:
730: EXCEPTION
731:
732: WHEN FND_API.G_EXC_ERROR THEN
733: Oe_Globals.G_calling_source:= 'WSH'; --8478151
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: oe_debug_pub.add(' SQLERRM: '|| SQLERRM );
736: OE_MSG_PUB.Count_And_Get

Line 734: x_return_status := FND_API.G_RET_STS_ERROR;

730: EXCEPTION
731:
732: WHEN FND_API.G_EXC_ERROR THEN
733: Oe_Globals.G_calling_source:= 'WSH'; --8478151
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: oe_debug_pub.add(' SQLERRM: '|| SQLERRM );
736: OE_MSG_PUB.Count_And_Get
737: ( p_count => l_msg_count,
738: p_data => l_msg_data

Line 741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

737: ( p_count => l_msg_count,
738: p_data => l_msg_data
739: );
740:
741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
742: Oe_Globals.G_calling_source:= 'WSH'; --8478151
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
744: oe_debug_pub.add(' SQLERRM: '|| SQLERRM );
745: OE_MSG_PUB.Count_And_Get

Line 743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

739: );
740:
741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
742: Oe_Globals.G_calling_source:= 'WSH'; --8478151
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
744: oe_debug_pub.add(' SQLERRM: '|| SQLERRM );
745: OE_MSG_PUB.Count_And_Get
746: ( p_count => l_msg_count,
747: p_data => l_msg_data

Line 752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

748: );
749:
750: WHEN OTHERS THEN
751: Oe_Globals.G_calling_source:= 'WSH'; --8478151
752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
753: oe_debug_pub.add(' SQLERRM: '|| SQLERRM );
754: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
755: THEN
756: FND_MSG_PUB.Add_Exc_Msg

Line 834: x_return_status := FND_API.G_RET_STS_SUCCESS;

830: OE_DEBUG_PUB.ADD('p_credit_check_rule_id => '|| p_credit_check_rule_id );
831: OE_DEBUG_PUB.ADD('p_need_exposure_details => '|| p_need_exposure_details );
832: END IF;
833:
834: x_return_status := FND_API.G_RET_STS_SUCCESS;
835: l_global_exposure_flag := 'N' ;
836:
837:
838: ---get credit check rule record

Line 968: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

964: END LOOP;
965:
966: x_return_status:='C';
967:
968: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
969: THEN
970: RAISE FND_API.G_EXC_ERROR;
971: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
972: THEN

Line 970: RAISE FND_API.G_EXC_ERROR;

966: x_return_status:='C';
967:
968: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
969: THEN
970: RAISE FND_API.G_EXC_ERROR;
971: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
972: THEN
973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;

Line 971: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

967:
968: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
969: THEN
970: RAISE FND_API.G_EXC_ERROR;
971: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
972: THEN
973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;
975:

Line 973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

969: THEN
970: RAISE FND_API.G_EXC_ERROR;
971: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
972: THEN
973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;
975:
976: -----------End party ----
977: ---customer level exposure

Line 1106: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1110: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

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

Line 1112: RAISE FND_API.G_EXC_ERROR;

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

Line 1113: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

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

Line 1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1163: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1159: END LOOP;
1160:
1161: ---bug fix 2439029
1162:
1163: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1164:
1165: x_return_status:='C';
1166:
1167: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

Line 1167: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

1163: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1164:
1165: x_return_status:='C';
1166:
1167: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1168: THEN
1169: RAISE FND_API.G_EXC_ERROR;
1170: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1171: THEN

Line 1169: RAISE FND_API.G_EXC_ERROR;

1165: x_return_status:='C';
1166:
1167: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1168: THEN
1169: RAISE FND_API.G_EXC_ERROR;
1170: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1171: THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: END IF;

Line 1170: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1166:
1167: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1168: THEN
1169: RAISE FND_API.G_EXC_ERROR;
1170: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1171: THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: END IF;
1174:

Line 1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1168: THEN
1169: RAISE FND_API.G_EXC_ERROR;
1170: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1171: THEN
1172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1173: END IF;
1174:
1175: END IF;
1176:

Line 1219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1215: , 'Get_Customer_Exposure'
1216: );
1217: END IF;
1218:
1219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1220: END ;
1221:
1222: MO_GLOBAL.Set_Policy_Context('S', l_org_id) ;
1223:

Line 1330: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1326: END LOOP;
1327:
1328: ---bug fix 2439029
1329:
1330: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1331:
1332: x_return_status:='C';
1333:
1334: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

Line 1334: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

1330: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1331:
1332: x_return_status:='C';
1333:
1334: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1335: THEN
1336: RAISE FND_API.G_EXC_ERROR;
1337: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1338: THEN

Line 1336: RAISE FND_API.G_EXC_ERROR;

1332: x_return_status:='C';
1333:
1334: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1335: THEN
1336: RAISE FND_API.G_EXC_ERROR;
1337: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1338: THEN
1339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1340: END IF;

Line 1337: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1333:
1334: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1335: THEN
1336: RAISE FND_API.G_EXC_ERROR;
1337: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1338: THEN
1339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1340: END IF;
1341:

Line 1339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1335: THEN
1336: RAISE FND_API.G_EXC_ERROR;
1337: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1338: THEN
1339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1340: END IF;
1341:
1342: ----non pre-calculate exposure
1343: ELSIF l_credit_check_rule_rec.quick_cr_check_flag ='N'

Line 1387: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1383: END LOOP;
1384:
1385: ---bug fix 2439029
1386:
1387: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1388:
1389: x_return_status:='C';
1390:
1391:

Line 1392: ELSIF l_return_status = FND_API.G_RET_STS_ERROR

1388:
1389: x_return_status:='C';
1390:
1391:
1392: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1393: THEN
1394: RAISE FND_API.G_EXC_ERROR;
1395: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1396: THEN

Line 1394: RAISE FND_API.G_EXC_ERROR;

1390:
1391:
1392: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1393: THEN
1394: RAISE FND_API.G_EXC_ERROR;
1395: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1396: THEN
1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1398: END IF;

Line 1395: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

1391:
1392: ELSIF l_return_status = FND_API.G_RET_STS_ERROR
1393: THEN
1394: RAISE FND_API.G_EXC_ERROR;
1395: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1396: THEN
1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1398: END IF;
1399: END IF;

Line 1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1393: THEN
1394: RAISE FND_API.G_EXC_ERROR;
1395: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1396: THEN
1397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1398: END IF;
1399: END IF;
1400:
1401: END IF;

Line 1410: WHEN FND_API.G_EXC_ERROR THEN

1406: END IF;
1407:
1408: EXCEPTION
1409:
1410: WHEN FND_API.G_EXC_ERROR THEN
1411: x_return_status := FND_API.G_RET_STS_ERROR;
1412: OE_MSG_PUB.Count_And_Get
1413: ( p_count => l_msg_count,
1414: p_data => l_msg_data

Line 1411: x_return_status := FND_API.G_RET_STS_ERROR;

1407:
1408: EXCEPTION
1409:
1410: WHEN FND_API.G_EXC_ERROR THEN
1411: x_return_status := FND_API.G_RET_STS_ERROR;
1412: OE_MSG_PUB.Count_And_Get
1413: ( p_count => l_msg_count,
1414: p_data => l_msg_data
1415: );

Line 1417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1413: ( p_count => l_msg_count,
1414: p_data => l_msg_data
1415: );
1416:
1417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1419: OE_MSG_PUB.Count_And_Get
1420: ( p_count => l_msg_count,
1421: p_data => l_msg_data

Line 1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1414: p_data => l_msg_data
1415: );
1416:
1417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1419: OE_MSG_PUB.Count_And_Get
1420: ( p_count => l_msg_count,
1421: p_data => l_msg_data
1422: );

Line 1425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1421: p_data => l_msg_data
1422: );
1423:
1424: WHEN OTHERS THEN
1425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1426: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1427: THEN
1428: FND_MSG_PUB.Add_Exc_Msg
1429: ( G_PKG_NAME

Line 1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1498: END IF;
1499:
1500: EXCEPTION
1501: WHEN OTHERS THEN
1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1503: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1504: THEN
1505: FND_MSG_PUB.Add_Exc_Msg
1506: ( G_PKG_NAME

Line 1554: x_return_status := FND_API.G_RET_STS_SUCCESS;

1550: l_header_rec OE_Order_PUB.Header_Rec_Type;
1551:
1552: BEGIN
1553:
1554: x_return_status := FND_API.G_RET_STS_SUCCESS;
1555:
1556: IF G_debug_flag = 'Y'
1557: THEN
1558: OE_DEBUG_PUB.ADD('OEXPCRGB: IN Check_Credit ',1);

Line 1704: IF NVL(p_delayed_request, FND_API.G_FALSE) = FND_API.G_TRUE and p_calling_action = 'SHIPPING' THEN

1700: = 'LINE'
1701: THEN
1702:
1703: --8478151
1704: IF NVL(p_delayed_request, FND_API.G_FALSE) = FND_API.G_TRUE and p_calling_action = 'SHIPPING' THEN
1705: Oe_Globals.G_calling_source:= 'ONT';
1706: END IF;
1707: --8478151
1708:

Line 1734: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1730: END IF;
1731:
1732: -- Moved calling_action check to outside of status check
1733: IF p_calling_action <> 'EXTERNAL' THEN
1734: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1735:
1736:
1737: Apply_exception_hold
1738: ( p_header_id => p_header_id

Line 1748: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1744: OE_DEBUG_PUB.ADD('Apply_exception_hold x_return_status => '
1745: || x_return_status );
1746: END IF;
1747:
1748: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1749: THEN
1750: x_return_status := FND_API.G_RET_STS_ERROR;
1751: ELSE
1752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1750: x_return_status := FND_API.G_RET_STS_ERROR;

1746: END IF;
1747:
1748: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1749: THEN
1750: x_return_status := FND_API.G_RET_STS_ERROR;
1751: ELSE
1752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1753: END IF;
1754: END IF; -- apply exception hold

Line 1752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1748: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1749: THEN
1750: x_return_status := FND_API.G_RET_STS_ERROR;
1751: ELSE
1752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1753: END IF;
1754: END IF; -- apply exception hold
1755: -- set result out to FAIL when credit check failed or
1756: -- when an exception occurred and a hold was successfully placed

Line 1758: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1754: END IF; -- apply exception hold
1755: -- set result out to FAIL when credit check failed or
1756: -- when an exception occurred and a hold was successfully placed
1757:
1758: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1759: x_result_out := 'FAIL' ;
1760: END IF;
1761: ELSE -- for the case of EXTERNAL credit check
1762: -- x_return_status is either SUCCESS, ERROR or UNEXP_ERROR

Line 1769: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1765: -- In this case, don't attempt to place credit hold
1766: -- set return status to SUCCESS with result_out=FAIL to indicate that
1767: -- credit checking completed successfully, even though
1768: -- the result_out is failure.
1769: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1770:
1771: IF G_debug_flag = 'Y'
1772: THEN
1773: OE_DEBUG_PUB.ADD( ' x_return_status = '|| x_return_status );

Line 1779: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1775: OE_Credit_Engine_GRP.G_currency_error_msg );
1776: END IF;
1777: END IF;
1778:
1779: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1780: x_result_out := 'FAIL';
1781: x_return_status := FND_API.G_RET_STS_SUCCESS;
1782: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1783: x_result_out := 'FAIL';

Line 1781: x_return_status := FND_API.G_RET_STS_SUCCESS;

1777: END IF;
1778:
1779: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1780: x_result_out := 'FAIL';
1781: x_return_status := FND_API.G_RET_STS_SUCCESS;
1782: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1783: x_result_out := 'FAIL';
1784: END IF;
1785: -- for success, default is PASS

Line 1782: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1778:
1779: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1780: x_result_out := 'FAIL';
1781: x_return_status := FND_API.G_RET_STS_SUCCESS;
1782: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1783: x_result_out := 'FAIL';
1784: END IF;
1785: -- for success, default is PASS
1786: END IF;

Line 1817: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

1813: OE_DEBUG_PUB.ADD('x_return_status = '|| x_return_status );
1814: OE_DEBUG_PUB.ADD('line hold count =>'||OE_Credit_Check_lines_PVT.G_line_hold_count);
1815: END IF;
1816:
1817: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1818: THEN
1819:
1820: OE_DEBUG_PUB.ADD('send failed ');
1821:

Line 1822: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1818: THEN
1819:
1820: OE_DEBUG_PUB.ADD('send failed ');
1821:
1822: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1823:
1824: OE_DEBUG_PUB.ADD(' after assign x_return_status = '
1825: || x_return_status );
1826: END IF;

Line 1861: WHEN FND_API.G_EXC_ERROR THEN

1857: Oe_Globals.G_calling_source:= 'WSH'; --8478151
1858:
1859: EXCEPTION
1860:
1861: WHEN FND_API.G_EXC_ERROR THEN
1862: Oe_Globals.G_calling_source:= 'WSH'; --8478151
1863: x_return_status := FND_API.G_RET_STS_ERROR;
1864: x_result_out := 'FAIL' ;
1865: OE_MSG_PUB.Count_And_Get

Line 1863: x_return_status := FND_API.G_RET_STS_ERROR;

1859: EXCEPTION
1860:
1861: WHEN FND_API.G_EXC_ERROR THEN
1862: Oe_Globals.G_calling_source:= 'WSH'; --8478151
1863: x_return_status := FND_API.G_RET_STS_ERROR;
1864: x_result_out := 'FAIL' ;
1865: OE_MSG_PUB.Count_And_Get
1866: ( p_count => x_msg_count,
1867: p_data => x_msg_data

Line 1870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1866: ( p_count => x_msg_count,
1867: p_data => x_msg_data
1868: );
1869:
1870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1871: Oe_Globals.G_calling_source:= 'WSH'; --8478151
1872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1873: x_result_out := 'FAIL' ;
1874: OE_MSG_PUB.Count_And_Get

Line 1872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1868: );
1869:
1870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1871: Oe_Globals.G_calling_source:= 'WSH'; --8478151
1872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1873: x_result_out := 'FAIL' ;
1874: OE_MSG_PUB.Count_And_Get
1875: ( p_count => x_msg_count,
1876: p_data => x_msg_data

Line 1881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1877: );
1878:
1879: WHEN OTHERS THEN
1880: Oe_Globals.G_calling_source:= 'WSH'; --8478151
1881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1882: x_result_out := 'FAIL' ;
1883: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1884: THEN
1885: FND_MSG_PUB.Add_Exc_Msg

Line 1926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1922: ELSE
1923: IF G_debug_flag = 'Y' THEN
1924: oe_debug_pub.add('OEXPCRGB: Unexpected error in setting org context where Customer Exposure flag is ''''N', 1 );
1925: END IF;
1926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1927: END IF;
1928:
1929: OE_CREDIT_CHECK_UTIL.G_org_id := l_org_id ;
1930:

Line 1934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1930:
1931: IF l_org_id IS NULL THEN
1932: Fnd_Message.set_name('FND','MO_ORG_REQUIRED');
1933: Oe_Msg_Pub.Add;
1934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1935: END IF;
1936:
1937: EXCEPTION
1938: WHEN NO_DATA_FOUND

Line 1963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1959: , 'Set_Context'
1960: );
1961: END IF;
1962:
1963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1964:
1965: END Set_context ;
1966:
1967: /* End MOAC CREDIT CHECK CHANGE */