205: if x_return_status <> FND_API.g_ret_sts_success then
206: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
207: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - non success status from IBE_ADDRESS_V2PVT.valid_usages: ' || x_return_status);
208: END IF;
209: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
210: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Settings - IBE_ADDRESS_V2PVT.valid_usages' );
211: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
212: FND_MSG_PUB.Add;
213: if x_return_status = FND_API.G_RET_STS_ERROR then
206: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
207: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - non success status from IBE_ADDRESS_V2PVT.valid_usages: ' || x_return_status);
208: END IF;
209: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
210: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Settings - IBE_ADDRESS_V2PVT.valid_usages' );
211: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
212: FND_MSG_PUB.Add;
213: if x_return_status = FND_API.G_RET_STS_ERROR then
214: RAISE FND_API.G_EXC_ERROR;
207: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - non success status from IBE_ADDRESS_V2PVT.valid_usages: ' || x_return_status);
208: END IF;
209: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
210: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Settings - IBE_ADDRESS_V2PVT.valid_usages' );
211: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
212: FND_MSG_PUB.Add;
213: if x_return_status = FND_API.G_RET_STS_ERROR then
214: RAISE FND_API.G_EXC_ERROR;
215: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
251: if x_return_status <> FND_API.g_ret_sts_success then
252: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
253: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - non success status from IBE_ADDRESS_V2PVT.valid_usages: ' || x_return_status);
254: END IF;
255: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
256: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Settings - IBE_ADDRESS_V2PVT.valid_usages' );
257: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
258: FND_MSG_PUB.Add;
259: if x_return_status = FND_API.G_RET_STS_ERROR then
252: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
253: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - non success status from IBE_ADDRESS_V2PVT.valid_usages: ' || x_return_status);
254: END IF;
255: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
256: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Settings - IBE_ADDRESS_V2PVT.valid_usages' );
257: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
258: FND_MSG_PUB.Add;
259: if x_return_status = FND_API.G_RET_STS_ERROR then
260: RAISE FND_API.G_EXC_ERROR;
253: ibe_util.debug('ibe_ord_oneclick_pvt.Get_Settings - non success status from IBE_ADDRESS_V2PVT.valid_usages: ' || x_return_status);
254: END IF;
255: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
256: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Settings - IBE_ADDRESS_V2PVT.valid_usages' );
257: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
258: FND_MSG_PUB.Add;
259: if x_return_status = FND_API.G_RET_STS_ERROR then
260: RAISE FND_API.G_EXC_ERROR;
261: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
490: cust_account_id = p_acct_id and
491: object_version_number = p_OBJECT_VERSION_NUMBER;
492:
493: IF (SQL%NOTFOUND) THEN
494: FND_MESSAGE.Set_Name('IBE', 'IBE_SAVE_ERROR');
495: FND_MSG_PUB.Add;
496: RAISE FND_API.G_EXC_ERROR;
497: END IF;
498: end if;
904: ibe_util.debug('Back from IBE_Quote_Save_pvt.SAVE ' || to_char(sysdate,'DD-MON-YYYY:HH24:MI:SS') || ' quote_header_id: ' || to_char(lx_quote_header_id));
905: END IF;
906: IF x_return_status <> FND_API.g_ret_sts_success THEN
907: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
908: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Quote_Save_pvt.SAVE: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
909: END IF;
910: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Quote_Save_pvt.SAVE' );
911: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
912: FND_MSG_PUB.Add;
906: IF x_return_status <> FND_API.g_ret_sts_success THEN
907: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
908: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Quote_Save_pvt.SAVE: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
909: END IF;
910: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Quote_Save_pvt.SAVE' );
911: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
912: FND_MSG_PUB.Add;
913: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
914: RAISE FND_API.G_EXC_ERROR;
907: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
908: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Quote_Save_pvt.SAVE: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
909: END IF;
910: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Quote_Save_pvt.SAVE' );
911: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
912: FND_MSG_PUB.Add;
913: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
914: RAISE FND_API.G_EXC_ERROR;
915: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1034: END IF;
1035:
1036: IF x_return_status <> FND_API.g_ret_sts_success THEN
1037: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1038: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Shop_List_PVT.Save_Quote_From_Lists: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1039: END IF;
1040: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_Lists' );
1041: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1042: FND_MSG_PUB.Add;
1036: IF x_return_status <> FND_API.g_ret_sts_success THEN
1037: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1038: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Shop_List_PVT.Save_Quote_From_Lists: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1039: END IF;
1040: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_Lists' );
1041: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1042: FND_MSG_PUB.Add;
1043: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1044: RAISE FND_API.G_EXC_ERROR;
1037: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1038: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Shop_List_PVT.Save_Quote_From_Lists: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1039: END IF;
1040: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_Lists' );
1041: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1042: FND_MSG_PUB.Add;
1043: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1044: RAISE FND_API.G_EXC_ERROR;
1045: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1084: END IF;
1085:
1086: if x_return_status <> FND_API.g_ret_sts_success then
1087: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1088: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Shop_List_PVT.Save_Quote_From_List_Items: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1089: END IF;
1090: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1091: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_List_Items' );
1092: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1086: if x_return_status <> FND_API.g_ret_sts_success then
1087: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1088: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Shop_List_PVT.Save_Quote_From_List_Items: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1089: END IF;
1090: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1091: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_List_Items' );
1092: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1093: FND_MSG_PUB.Add;
1094: if x_return_status = FND_API.G_RET_STS_ERROR then
1087: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1088: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Shop_List_PVT.Save_Quote_From_List_Items: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1089: END IF;
1090: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1091: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_List_Items' );
1092: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1093: FND_MSG_PUB.Add;
1094: if x_return_status = FND_API.G_RET_STS_ERROR then
1095: RAISE FND_API.G_EXC_ERROR;
1088: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Shop_List_PVT.Save_Quote_From_List_Items: ' || x_return_status); FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1089: END IF;
1090: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1091: FND_MESSAGE.SET_TOKEN ( '0' , 'Express_Buy_Order - IBE_Shop_List_PVT.Save_Quote_From_List_Items' );
1092: FND_MESSAGE.SET_TOKEN ( '1' , x_return_status );
1093: FND_MSG_PUB.Add;
1094: if x_return_status = FND_API.G_RET_STS_ERROR then
1095: RAISE FND_API.G_EXC_ERROR;
1096: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1374: if lx_return_status <> FND_API.g_ret_sts_success then
1375: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1376: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Quote_Save_pvt.SAVE: ' || lx_return_status);
1377: END IF;
1378: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1379: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Express_Items_Settings - IBE_Quote_Save_pvt.SAVE for nonconsolidation' );
1380: FND_MESSAGE.SET_TOKEN ( '1' , lx_return_status );
1381: FND_MSG_PUB.Add;
1382: if lx_return_status = FND_API.G_RET_STS_ERROR then
1375: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1376: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Quote_Save_pvt.SAVE: ' || lx_return_status);
1377: END IF;
1378: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1379: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Express_Items_Settings - IBE_Quote_Save_pvt.SAVE for nonconsolidation' );
1380: FND_MESSAGE.SET_TOKEN ( '1' , lx_return_status );
1381: FND_MSG_PUB.Add;
1382: if lx_return_status = FND_API.G_RET_STS_ERROR then
1383: RAISE FND_API.G_EXC_ERROR;
1376: ibe_util.debug('ibe_ord_oneclick_pvt.Express_Buy_Order - non success status from IBE_Quote_Save_pvt.SAVE: ' || lx_return_status);
1377: END IF;
1378: FND_MESSAGE.SET_NAME('IBE','IBE_EXPR_PLSQL_API_ERROR');
1379: FND_MESSAGE.SET_TOKEN ( '0' , 'Get_Express_Items_Settings - IBE_Quote_Save_pvt.SAVE for nonconsolidation' );
1380: FND_MESSAGE.SET_TOKEN ( '1' , lx_return_status );
1381: FND_MSG_PUB.Add;
1382: if lx_return_status = FND_API.G_RET_STS_ERROR then
1383: RAISE FND_API.G_EXC_ERROR;
1384: elsif lx_return_status = FND_API.G_RET_STS_UNEXP_ERROR then