502:
503: WHEN OTHERS THEN
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: oe_debug_pub.add(' SQLERRM: '|| SQLERRM );
506: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
507: THEN
508: FND_MSG_PUB.Add_Exc_Msg
509: ( G_PKG_NAME
510: , 'Credit_check_with_payment_typ'
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: oe_debug_pub.add(' SQLERRM: '|| SQLERRM );
506: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
507: THEN
508: FND_MSG_PUB.Add_Exc_Msg
509: ( G_PKG_NAME
510: , 'Credit_check_with_payment_typ'
511: );
512: END IF;
946: IF G_debug_flag = 'Y' THEN
947: OE_DEBUG_PUB.ADD ('Exception : No org id via site_id ', 1);
948: END IF;
949:
950: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
951: THEN
952: FND_MSG_PUB.Add_Exc_Msg
953: ( G_PKG_NAME
954: , 'Get_Customer_Exposure'
948: END IF;
949:
950: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
951: THEN
952: FND_MSG_PUB.Add_Exc_Msg
953: ( G_PKG_NAME
954: , 'Get_Customer_Exposure'
955: );
956: END IF;
959: IF G_debug_flag = 'Y' THEN
960: OE_DEBUG_PUB.ADD ('Exception : Unexpected error in finding org id via site_id ', 1);
961: END IF;
962:
963: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
964: THEN
965: FND_MSG_PUB.Add_Exc_Msg
966: ( G_PKG_NAME
967: , 'Get_Customer_Exposure'
961: END IF;
962:
963: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
964: THEN
965: FND_MSG_PUB.Add_Exc_Msg
966: ( G_PKG_NAME
967: , 'Get_Customer_Exposure'
968: );
969: END IF;
1174: );
1175:
1176: WHEN OTHERS THEN
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1178: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1179: THEN
1180: FND_MSG_PUB.Add_Exc_Msg
1181: ( G_PKG_NAME
1182: , 'Get_Customer_Exposure'
1176: WHEN OTHERS THEN
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1178: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1179: THEN
1180: FND_MSG_PUB.Add_Exc_Msg
1181: ( G_PKG_NAME
1182: , 'Get_Customer_Exposure'
1183: );
1184: END IF;
1251:
1252: EXCEPTION
1253: WHEN OTHERS THEN
1254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1255: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1256: THEN
1257: FND_MSG_PUB.Add_Exc_Msg
1258: ( G_PKG_NAME
1259: , 'Get_Customer_Exposure'
1253: WHEN OTHERS THEN
1254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1255: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1256: THEN
1257: FND_MSG_PUB.Add_Exc_Msg
1258: ( G_PKG_NAME
1259: , 'Get_Customer_Exposure'
1260: );
1261: END IF;
1619:
1620: WHEN OTHERS THEN
1621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1622: x_result_out := 'FAIL' ;
1623: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1624: THEN
1625: FND_MSG_PUB.Add_Exc_Msg
1626: ( G_PKG_NAME
1627: , 'Check_Credit'
1621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1622: x_result_out := 'FAIL' ;
1623: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1624: THEN
1625: FND_MSG_PUB.Add_Exc_Msg
1626: ( G_PKG_NAME
1627: , 'Check_Credit'
1628: );
1629: END IF;
1691: IF G_debug_flag = 'Y' THEN
1692: OE_DEBUG_PUB.ADD ('Exception : Unexpected error from Set_Context ', 1);
1693: END IF;
1694:
1695: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1696: THEN
1697: FND_MSG_PUB.Add_Exc_Msg
1698: ( G_PKG_NAME
1699: , 'Set_Context'
1693: END IF;
1694:
1695: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1696: THEN
1697: FND_MSG_PUB.Add_Exc_Msg
1698: ( G_PKG_NAME
1699: , 'Set_Context'
1700: );
1701: END IF;