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.IBE_QUOTE_CHECKOUT_PVT dependencies on FND_API

Line 11: l_true VARCHAR2(1) := FND_API.G_TRUE;

7:
8: -- End of Comments
9:
10: -- Default number of records fetch per call
11: l_true VARCHAR2(1) := FND_API.G_TRUE;
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_Quote_Checkout_Pvt';
13: G_FILE_NAME CONSTANT VARCHAR2(12):= 'IBEVQASB.pls';
14: G_AUTH_ERROR CONSTANT NUMBER :=3;
15: PROCEDURE Authorize_Credit_Card(

Line 26: l_resource_id NUMBER := FND_API.G_MISS_NUM;

22: l_trxn_extension_id NUMBER;
23: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
24: l_payee_rec IBY_FNDCPT_TRXN_PUB.PayeeContext_rec_type;
25: l_party_id NUMBER;
26: l_resource_id NUMBER := FND_API.G_MISS_NUM;
27: l_org_type VARCHAR2(30) := 'OPERATING_UNIT';
28: l_payment_function VARCHAR2(30) := 'CUSTOMER_PAYMENT';
29: l_auth_result IBY_FNDCPT_TRXN_PUB.AuthResult_rec_type;
30: l_amount IBY_FNDCPT_TRXN_PUB.Amount_rec_type;

Line 95: IF(l_resource_id is not null AND l_resource_id <> FND_API.G_MISS_NUM AND l_party_id is not null

91: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_resource_id populated...'|| l_resource_id);
92: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_quote_source_code...'|| l_quote_source_code);
93: END IF;
94:
95: IF(l_resource_id is not null AND l_resource_id <> FND_API.G_MISS_NUM AND l_party_id is not null
96: and l_quote_source_code = 'Order Capture Quotes') THEN
97: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
98: IBE_UTIL.DEBUG('Authorize_Credit_Card: l_resource_id not null and is Order Capture Quote. Get the org_id');
99: END IF;

Line 165: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND l_response.result_code = 'AUTH_SUCCESS' THEN

161: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_data:'|| l_msg_data);
162: end if;
163: END IF;
164:
165: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND l_response.result_code = 'AUTH_SUCCESS' THEN
166:
167: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
168: IBE_UTIL.DEBUG('Authorize_Credit_Card:Authorization successful....Commiting the data');
169: END IF;

Line 178: x_return_status := FND_API.G_RET_STS_ERROR;

174: IBE_UTIL.DEBUG('Authorize_Credit_Card:CC Auth failed...!');
175: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_response.result_code = '|| l_response.result_code);
176: END IF;
177:
178: x_return_status := FND_API.G_RET_STS_ERROR;
179:
180: FND_MSG_PUB.initialize;
181: FND_MESSAGE.CLEAR;
182:

Line 204: RAISE FND_API.G_EXC_ERROR;

200: FND_MSG_PUB.ADD;
201:
202: END IF;
203:
204: RAISE FND_API.G_EXC_ERROR;
205: END IF;
206:
207: EXCEPTION
208: WHEN FND_API.G_EXC_ERROR THEN

Line 208: WHEN FND_API.G_EXC_ERROR THEN

204: RAISE FND_API.G_EXC_ERROR;
205: END IF;
206:
207: EXCEPTION
208: WHEN FND_API.G_EXC_ERROR THEN
209: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
210: IBE_Util.Debug('Expected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
211: END IF;
212:

Line 213: x_return_status := FND_API.G_RET_STS_ERROR;

209: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
210: IBE_Util.Debug('Expected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
211: END IF;
212:
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
215: p_count => x_msg_count ,
216: p_data => x_msg_data);
217: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 214: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

210: IBE_Util.Debug('Expected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
211: END IF;
212:
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
215: p_count => x_msg_count ,
216: p_data => x_msg_data);
217: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
218: IBE_Util.Debug('Expected exception count and data'||x_msg_count||'data = '||x_msg_data);

Line 220: RAISE FND_API.G_EXC_ERROR;

216: p_data => x_msg_data);
217: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
218: IBE_Util.Debug('Expected exception count and data'||x_msg_count||'data = '||x_msg_data);
219: END IF;
220: RAISE FND_API.G_EXC_ERROR;
221:
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
224: IBE_Util.Debug('Unexpected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');

Line 222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

218: IBE_Util.Debug('Expected exception count and data'||x_msg_count||'data = '||x_msg_data);
219: END IF;
220: RAISE FND_API.G_EXC_ERROR;
221:
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
224: IBE_Util.Debug('Unexpected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
225: END IF;
226:

Line 227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

223: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
224: IBE_Util.Debug('Unexpected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
225: END IF;
226:
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
229: p_count => x_msg_count ,
230: p_data => x_msg_data);
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 228: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

224: IBE_Util.Debug('Unexpected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
225: END IF;
226:
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
229: p_count => x_msg_count ,
230: p_data => x_msg_data);
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232:

Line 231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
229: p_count => x_msg_count ,
230: p_data => x_msg_data);
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232:
233: WHEN OTHERS THEN
234: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
235: IBE_Util.Debug('Unknown exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');

Line 238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

234: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
235: IBE_Util.Debug('Unknown exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
236: END IF;
237:
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
240: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
241: L_API_NAME);
242: END IF;

Line 243: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

239: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
240: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
241: L_API_NAME);
242: END IF;
243: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
244: p_count => x_msg_count ,
245: p_data => x_msg_data);
246:
247: END Authorize_Credit_Card;

Line 259: RETURN FND_API.G_TRUE;

255:
256: FUNCTION Boolean_To_GBoolean(p_Cond IN BOOLEAN) RETURN VARCHAR2 IS
257: BEGIN
258: IF p_Cond THEN
259: RETURN FND_API.G_TRUE;
260: ELSE
261: RETURN FND_API.G_FALSE;
262: END IF;
263: END Boolean_To_GBoolean;

Line 261: RETURN FND_API.G_FALSE;

257: BEGIN
258: IF p_Cond THEN
259: RETURN FND_API.G_TRUE;
260: ELSE
261: RETURN FND_API.G_FALSE;
262: END IF;
263: END Boolean_To_GBoolean;
264:
265: BEGIN

Line 277: IF px_submit_control_rec.book_flag = FND_API.G_MISS_CHAR --OR

273: IBE_Util.Debug('Submit_Control_Rec.Book_Flag=(' || px_submit_control_rec.book_flag || ')');
274: IBE_Util.Debug('FND_PROFILE(ASO_DEFAULT_ORDER_STATE)=(' || FND_PROFILE.Value('ASO_DEFAULT_ORDER_STATE') || ')');
275: END IF;
276:
277: IF px_submit_control_rec.book_flag = FND_API.G_MISS_CHAR --OR
278: -- px_submit_control_rec.book_flag = 'F'
279: -- shouldn't be defaulting if F is passed in
280: THEN
281: l_qte_payment_tbl := IBE_Quote_Misc_pvt.getHeaderPaymentTbl(p_qte_header_id);

Line 295: px_submit_control_rec.book_flag := FND_API.G_FALSE;

291: /*IF l_qte_payment_tbl(1).payment_ref_number IS NOT NULL THEN
292: px_submit_control_rec.book_flag :=
293: Boolean_To_GBoolean(FND_PROFILE.Value('ASO_DEFAULT_ORDER_STATE') = 'BOOKED');
294: ELSE
295: px_submit_control_rec.book_flag := FND_API.G_FALSE;
296: END IF;*/
297:
298: /*mannamra: Credit Card Consolidation changes: 1. We will no longer use payment_ref_number, which would
299: be the credit card number when payment type is credit_card,

Line 307: AND l_qte_payment_tbl(1).instr_assignment_id <> FND_API.G_MISS_NUM) THEN

303: not taking into consideration the case when only PO number
304: is passed.
305: */
306: IF (l_qte_payment_tbl(1).instr_assignment_id is not null
307: AND l_qte_payment_tbl(1).instr_assignment_id <> FND_API.G_MISS_NUM) THEN
308: px_submit_control_rec.book_flag :=
309: Boolean_To_GBoolean(FND_PROFILE.Value('ASO_DEFAULT_ORDER_STATE') = 'BOOKED');
310: ELSE
311: px_submit_control_rec.book_flag := FND_API.G_FALSE;

Line 311: px_submit_control_rec.book_flag := FND_API.G_FALSE;

307: AND l_qte_payment_tbl(1).instr_assignment_id <> FND_API.G_MISS_NUM) THEN
308: px_submit_control_rec.book_flag :=
309: Boolean_To_GBoolean(FND_PROFILE.Value('ASO_DEFAULT_ORDER_STATE') = 'BOOKED');
310: ELSE
311: px_submit_control_rec.book_flag := FND_API.G_FALSE;
312: END IF;
313:
314: ELSIF NVL(l_qte_payment_tbl(1).payment_type_code, 'CASH') IN ('CASH', 'CHECK') THEN
315: px_submit_control_rec.book_flag :=

Line 336: ,p_commit IN VARCHAR2 := FND_API.g_false

332: END Default_Order_State;
333:
334: PROCEDURE SubmitQuote(
335: p_api_version_number IN NUMBER
336: ,p_commit IN VARCHAR2 := FND_API.g_false
337: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
338: ,p_quote_Header_Id IN NUMBER
339: ,p_last_update_date in DATE := FND_API.G_MISS_DATE
340:

Line 337: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

333:
334: PROCEDURE SubmitQuote(
335: p_api_version_number IN NUMBER
336: ,p_commit IN VARCHAR2 := FND_API.g_false
337: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
338: ,p_quote_Header_Id IN NUMBER
339: ,p_last_update_date in DATE := FND_API.G_MISS_DATE
340:
341: ,p_sharee_party_Id IN NUMBER := FND_API.G_MISS_NUM

Line 339: ,p_last_update_date in DATE := FND_API.G_MISS_DATE

335: p_api_version_number IN NUMBER
336: ,p_commit IN VARCHAR2 := FND_API.g_false
337: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
338: ,p_quote_Header_Id IN NUMBER
339: ,p_last_update_date in DATE := FND_API.G_MISS_DATE
340:
341: ,p_sharee_party_Id IN NUMBER := FND_API.G_MISS_NUM
342: ,p_sharee_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
343: ,p_sharee_number IN NUMBER := FND_API.G_MISS_NUM

Line 341: ,p_sharee_party_Id IN NUMBER := FND_API.G_MISS_NUM

337: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
338: ,p_quote_Header_Id IN NUMBER
339: ,p_last_update_date in DATE := FND_API.G_MISS_DATE
340:
341: ,p_sharee_party_Id IN NUMBER := FND_API.G_MISS_NUM
342: ,p_sharee_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
343: ,p_sharee_number IN NUMBER := FND_API.G_MISS_NUM
344:
345: ,p_submit_Control_Rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type

Line 342: ,p_sharee_cust_account_id IN NUMBER := FND_API.G_MISS_NUM

338: ,p_quote_Header_Id IN NUMBER
339: ,p_last_update_date in DATE := FND_API.G_MISS_DATE
340:
341: ,p_sharee_party_Id IN NUMBER := FND_API.G_MISS_NUM
342: ,p_sharee_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
343: ,p_sharee_number IN NUMBER := FND_API.G_MISS_NUM
344:
345: ,p_submit_Control_Rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type
346: := ASO_QUOTE_PUB.G_MISS_Submit_Control_Rec

Line 343: ,p_sharee_number IN NUMBER := FND_API.G_MISS_NUM

339: ,p_last_update_date in DATE := FND_API.G_MISS_DATE
340:
341: ,p_sharee_party_Id IN NUMBER := FND_API.G_MISS_NUM
342: ,p_sharee_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
343: ,p_sharee_number IN NUMBER := FND_API.G_MISS_NUM
344:
345: ,p_submit_Control_Rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type
346: := ASO_QUOTE_PUB.G_MISS_Submit_Control_Rec
347:

Line 348: ,p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR

344:
345: ,p_submit_Control_Rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type
346: := ASO_QUOTE_PUB.G_MISS_Submit_Control_Rec
347:
348: ,p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR
349: ,p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR
350: ,p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR
351:
352: -- 9/17/02: added to control calling validate_user_update

Line 349: ,p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR

345: ,p_submit_Control_Rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type
346: := ASO_QUOTE_PUB.G_MISS_Submit_Control_Rec
347:
348: ,p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR
349: ,p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR
350: ,p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR
351:
352: -- 9/17/02: added to control calling validate_user_update
353: ,p_validate_user IN VARCHAR2 := FND_API.G_TRUE

Line 350: ,p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR

346: := ASO_QUOTE_PUB.G_MISS_Submit_Control_Rec
347:
348: ,p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR
349: ,p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR
350: ,p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR
351:
352: -- 9/17/02: added to control calling validate_user_update
353: ,p_validate_user IN VARCHAR2 := FND_API.G_TRUE
354: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM

Line 353: ,p_validate_user IN VARCHAR2 := FND_API.G_TRUE

349: ,p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR
350: ,p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR
351:
352: -- 9/17/02: added to control calling validate_user_update
353: ,p_validate_user IN VARCHAR2 := FND_API.G_TRUE
354: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
355:
356: ,x_order_header_rec OUT NOCOPY ASO_QUOTE_PUB.Order_Header_Rec_Type
357: --Mannamra: Added for bug 4716044

Line 354: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM

350: ,p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR
351:
352: -- 9/17/02: added to control calling validate_user_update
353: ,p_validate_user IN VARCHAR2 := FND_API.G_TRUE
354: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
355:
356: ,x_order_header_rec OUT NOCOPY ASO_QUOTE_PUB.Order_Header_Rec_Type
357: --Mannamra: Added for bug 4716044
358: ,x_hold_flag OUT NOCOPY VARCHAR2

Line 429: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,

425: BEGIN
426: -- Standard Start of API savepoint
427: SAVEPOINT SUBMITQUOTE_PVT;
428: -- Standard call to check for call compatibility.
429: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
430: P_Api_Version_Number,
431: L_API_NAME,
432: G_PKG_NAME )
433: THEN

Line 434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

430: P_Api_Version_Number,
431: L_API_NAME,
432: G_PKG_NAME )
433: THEN
434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
435: END IF;
436: -- Initialize message list IF p_init_msg_list is set to TRUE.
437: IF FND_API.to_Boolean( p_init_msg_list ) THEN
438: FND_MSG_PUB.initialize;

Line 437: IF FND_API.to_Boolean( p_init_msg_list ) THEN

433: THEN
434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
435: END IF;
436: -- Initialize message list IF p_init_msg_list is set to TRUE.
437: IF FND_API.to_Boolean( p_init_msg_list ) THEN
438: FND_MSG_PUB.initialize;
439: END IF;
440:
441: -- Initialize API return status to success

Line 442: x_return_status := FND_API.G_RET_STS_SUCCESS;

438: FND_MSG_PUB.initialize;
439: END IF;
440:
441: -- Initialize API return status to success
442: x_return_status := FND_API.G_RET_STS_SUCCESS;
443:
444: -- API body
445: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
446: IBE_UTIL.DEBUG('SUBMITQUOTE: Before Calling log_environment_info');

Line 460: if (fnd_api.to_boolean(p_validate_user)) then

456:
457: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
458: IBE_UTIL.DEBUG('Submit_Quote: p_validate_user flag='||p_validate_user);
459: END IF;
460: if (fnd_api.to_boolean(p_validate_user)) then
461: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
462: IBE_UTIL.DEBUG('Submit_Quote: before calling validate_user_update()');
463: END IF;
464: -- User Authentication

Line 466: p_init_msg_list => FND_API.G_TRUE

462: IBE_UTIL.DEBUG('Submit_Quote: before calling validate_user_update()');
463: END IF;
464: -- User Authentication
465: IBE_Quote_Misc_pvt.Validate_User_Update(
466: p_init_msg_list => FND_API.G_TRUE
467: ,p_quote_header_id => p_quote_Header_Id
468: ,p_quote_retrieval_number => p_sharee_number
469: ,p_validate_user => FND_API.G_TRUE
470: ,p_privilege_type_code => 'A'

Line 469: ,p_validate_user => FND_API.G_TRUE

465: IBE_Quote_Misc_pvt.Validate_User_Update(
466: p_init_msg_list => FND_API.G_TRUE
467: ,p_quote_header_id => p_quote_Header_Id
468: ,p_quote_retrieval_number => p_sharee_number
469: ,p_validate_user => FND_API.G_TRUE
470: ,p_privilege_type_code => 'A'
471: ,p_save_type => PLACE_ORDER
472: ,p_last_update_date => p_last_update_date
473: ,x_return_status => x_return_status

Line 477: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

473: ,x_return_status => x_return_status
474: ,x_msg_count => x_msg_count
475: ,x_msg_data => x_msg_data
476: );
477: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
478: RAISE FND_API.G_EXC_ERROR;
479: END IF;
480:
481: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 478: RAISE FND_API.G_EXC_ERROR;

474: ,x_msg_count => x_msg_count
475: ,x_msg_data => x_msg_data
476: );
477: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
478: RAISE FND_API.G_EXC_ERROR;
479: END IF;
480:
481: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 481: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

477: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
478: RAISE FND_API.G_EXC_ERROR;
479: END IF;
480:
481: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END IF;
484: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
485: IBE_UTIL.debug('SUBmit_quote: after calling validate_user_update()');

Line 482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

478: RAISE FND_API.G_EXC_ERROR;
479: END IF;
480:
481: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
482: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
483: END IF;
484: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
485: IBE_UTIL.debug('SUBmit_quote: after calling validate_user_update()');
486: END IF;

Line 491: AND p_sharee_number <> FND_API.G_MISS_NUM THEN

487: end if;
488:
489: l_qte_header_rec.quote_header_id := p_quote_header_id;
490: /*IF p_sharee_number IS NOT NULL
491: AND p_sharee_number <> FND_API.G_MISS_NUM THEN
492: -- save cart check permisson
493: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
494: IBE_Util.Debug('IBE_Quote_Save_pvt.Save() starts');
495: END IF;

Line 499: ,p_init_msg_list => FND_API.G_TRUE

495: END IF;
496:
497: IBE_Quote_Save_pvt.Save(
498: p_api_version_number => p_api_version_number
499: ,p_init_msg_list => FND_API.G_TRUE
500: ,p_commit => FND_API.G_FALSE
501: ,p_sharee_number => p_sharee_number
502: ,p_sharee_party_id => p_sharee_party_id
503: ,p_sharee_cust_account_id => p_sharee_cust_account_id

Line 500: ,p_commit => FND_API.G_FALSE

496:
497: IBE_Quote_Save_pvt.Save(
498: p_api_version_number => p_api_version_number
499: ,p_init_msg_list => FND_API.G_TRUE
500: ,p_commit => FND_API.G_FALSE
501: ,p_sharee_number => p_sharee_number
502: ,p_sharee_party_id => p_sharee_party_id
503: ,p_sharee_cust_account_id => p_sharee_cust_account_id
504: ,p_changeowner => fnd_api.g_true

Line 504: ,p_changeowner => fnd_api.g_true

500: ,p_commit => FND_API.G_FALSE
501: ,p_sharee_number => p_sharee_number
502: ,p_sharee_party_id => p_sharee_party_id
503: ,p_sharee_cust_account_id => p_sharee_cust_account_id
504: ,p_changeowner => fnd_api.g_true
505: ,p_qte_header_rec => l_qte_header_rec
506: ,x_quote_header_id => l_quote_header_id_tmp
507: ,x_last_update_date => l_last_update_date_tmp
508: ,x_return_status => x_return_status

Line 516: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

512: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
513: IBE_Util.Debug('IBE_Quote_Save_pvt.Save() finishes');
514: END IF;
515:
516: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
517: RAISE FND_API.G_EXC_ERROR;
518: END IF;
519:
520: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 517: RAISE FND_API.G_EXC_ERROR;

513: IBE_Util.Debug('IBE_Quote_Save_pvt.Save() finishes');
514: END IF;
515:
516: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
517: RAISE FND_API.G_EXC_ERROR;
518: END IF;
519:
520: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 520: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

516: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
517: RAISE FND_API.G_EXC_ERROR;
518: END IF;
519:
520: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: END IF;
523:
524: l_qte_header_rec.quote_header_id := l_quote_header_id_tmp;

Line 521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

517: RAISE FND_API.G_EXC_ERROR;
518: END IF;
519:
520: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: END IF;
523:
524: l_qte_header_rec.quote_header_id := l_quote_header_id_tmp;
525: l_qte_header_rec.last_update_date := l_last_update_date_tmp;

Line 602: p_user_type => FND_API.G_MISS_CHAR,

598:
599: IF (l_party_id is not null) THEN
600: IBE_WORKFLOW_PVT.get_name_details(
601: p_party_id => l_party_id,
602: p_user_type => FND_API.G_MISS_CHAR,
603: x_contact_first_name => l_person_first_name,
604: x_contact_last_name => l_person_last_name,
605: x_party_id => lx_party_id);
606: END IF;

Line 666: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

662: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
663: IBE_Util.Debug('After Authorize_Credit_Card checking the returned status');
664: END IF;
665:
666: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
667: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
668: IBE_Util.Debug('IBE_Quote_Checkout_Pvt.Authorize_Credit_Card(): Exp Error while entering the quote ');
669: END IF;
670:

Line 671: RAISE FND_API.G_EXC_ERROR;

667: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
668: IBE_Util.Debug('IBE_Quote_Checkout_Pvt.Authorize_Credit_Card(): Exp Error while entering the quote ');
669: END IF;
670:
671: RAISE FND_API.G_EXC_ERROR;
672: END IF;
673:
674: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
675: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 674: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

670:
671: RAISE FND_API.G_EXC_ERROR;
672: END IF;
673:
674: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
675: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
676: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Unexp Error while entering the quote ');
677: END IF;
678:

Line 679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

675: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
676: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Unexp Error while entering the quote ');
677: END IF;
678:
679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
680: END IF;
681: END IF;
682:
683: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 689: ,P_Init_Msg_List => FND_API.G_TRUE

685: END IF;
686:
687: ASO_Quote_Pub.Submit_quote(
688: P_Api_Version_Number => p_api_version_number
689: ,P_Init_Msg_List => FND_API.G_TRUE
690: ,P_Commit => FND_API.G_FALSE
691: ,p_control_rec => l_submit_control_rec
692: ,P_Qte_Header_Rec => l_qte_header_rec
693: ,x_order_header_rec => x_Order_Header_Rec

Line 690: ,P_Commit => FND_API.G_FALSE

686:
687: ASO_Quote_Pub.Submit_quote(
688: P_Api_Version_Number => p_api_version_number
689: ,P_Init_Msg_List => FND_API.G_TRUE
690: ,P_Commit => FND_API.G_FALSE
691: ,p_control_rec => l_submit_control_rec
692: ,P_Qte_Header_Rec => l_qte_header_rec
693: ,x_order_header_rec => x_Order_Header_Rec
694: ,x_return_status => x_return_status

Line 709: ,p_Init_Msg_List => FND_API.G_TRUE

705: END IF;
706:
707: ASO_Quote_Pub.Submit_Quote(
708: p_api_version_number => p_api_version_number
709: ,p_Init_Msg_List => FND_API.G_TRUE
710: ,p_control_rec => l_submit_control_rec
711: ,p_Qte_Header_Id => l_qte_header_rec.quote_header_id
712: ,x_order_header_rec => x_Order_Header_Rec
713: ,x_return_status => x_return_status

Line 725: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

721: l_msg_data := x_msg_data;
722: l_msg_count := x_msg_count;
723: l_return_status := x_return_status;
724:
725: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
726: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
727: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Error in submit quote');
728: END IF;
729:

Line 730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

726: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
727: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Error in submit quote');
728: END IF;
729:
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732:
733: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
734: IF ( l_submit_control_rec.book_flag = FND_API.G_TRUE

Line 733: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

729:
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732:
733: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
734: IF ( l_submit_control_rec.book_flag = FND_API.G_TRUE
735: AND FND_PROFILE.VALUE('IBE_ENTER_ORDER_ON_ERROR') = 'Y')
736: THEN
737: -- l_submit_control_rec := p_submit_control_rec;

Line 734: IF ( l_submit_control_rec.book_flag = FND_API.G_TRUE

730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
731: END IF;
732:
733: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
734: IF ( l_submit_control_rec.book_flag = FND_API.G_TRUE
735: AND FND_PROFILE.VALUE('IBE_ENTER_ORDER_ON_ERROR') = 'Y')
736: THEN
737: -- l_submit_control_rec := p_submit_control_rec;
738: l_submit_control_rec.book_flag := fnd_api.g_false;

Line 738: l_submit_control_rec.book_flag := fnd_api.g_false;

734: IF ( l_submit_control_rec.book_flag = FND_API.G_TRUE
735: AND FND_PROFILE.VALUE('IBE_ENTER_ORDER_ON_ERROR') = 'Y')
736: THEN
737: -- l_submit_control_rec := p_submit_control_rec;
738: l_submit_control_rec.book_flag := fnd_api.g_false;
739:
740: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
741: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() after book failure starts');
742: END IF;

Line 746: ,p_Init_Msg_List => FND_API.G_TRUE

742: END IF;
743:
744: ASO_Quote_Pub.Submit_Quote(
745: p_api_version_number => p_api_version_number
746: ,p_Init_Msg_List => FND_API.G_TRUE
747: ,p_control_rec => l_submit_control_rec
748: ,p_Qte_Header_Id => l_qte_header_rec.quote_header_id
749: ,x_order_header_rec => x_Order_Header_Rec
750: ,x_return_status => x_return_status

Line 758: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

754: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
755: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() after book failure finishes x_Order_Header_Rec.header_id '||x_Order_Header_Rec.ORDER_header_id);
756: END IF;
757:
758: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
759: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
760: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Exp Error while entering the quote ');
761: END IF;
762:

Line 763: RAISE FND_API.G_EXC_ERROR;

759: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
760: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Exp Error while entering the quote ');
761: END IF;
762:
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;
765:
766: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
767: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 766: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

762:
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;
765:
766: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
767: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
768: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Unexp Error while entering the quote ');
769: END IF;
770:

Line 771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

767: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
768: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Unexp Error while entering the quote ');
769: END IF;
770:
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: END IF;
773: ELSE
774:
775: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 778: RAISE FND_API.G_EXC_ERROR;

774:
775: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
776: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Error in submit quote');
777: END IF;
778: RAISE FND_API.G_EXC_ERROR;
779: END IF;
780: END IF;
781:
782: -------------------------------------------------------------------------------------

Line 794: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

790: ,x_return_status => x_return_status
791: ,x_msg_count => x_msg_count
792: ,x_msg_data => x_msg_data);
793:
794: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
795: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
796: IBE_Util.Debug('submitQuote: oe_holds_pub.check_holds has returned with an error '||x_msg_data);
797: END IF;
798:

Line 799: RAISE FND_API.G_EXC_ERROR;

795: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
796: IBE_Util.Debug('submitQuote: oe_holds_pub.check_holds has returned with an error '||x_msg_data);
797: END IF;
798:
799: RAISE FND_API.G_EXC_ERROR;
800: END IF;
801:
802: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
803: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 802: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

798:
799: RAISE FND_API.G_EXC_ERROR;
800: END IF;
801:
802: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
803: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
804: IBE_Util.Debug('submitQuote: oe_holds_pub.check_holds has returned with an error '||x_msg_data);
805: END IF;
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

802: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
803: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
804: IBE_Util.Debug('submitQuote: oe_holds_pub.check_holds has returned with an error '||x_msg_data);
805: END IF;
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: END IF;
808:
809: x_hold_flag := l_hold_flag;
810:

Line 818: p_init_msg_list => fnd_api.g_false ,

814: p_quote_header_id => p_quote_header_id ,
815: p_delete_context => 'IBE_SC_CART_ORDERED',
816: P_minisite_id => p_minisite_id ,
817: p_api_version => p_api_version_number ,
818: p_init_msg_list => fnd_api.g_false ,
819: p_commit => fnd_api.g_false ,
820: x_return_status => x_return_status ,
821: x_msg_count => x_msg_count ,
822: x_msg_data => x_msg_data );

Line 819: p_commit => fnd_api.g_false ,

815: p_delete_context => 'IBE_SC_CART_ORDERED',
816: P_minisite_id => p_minisite_id ,
817: p_api_version => p_api_version_number ,
818: p_init_msg_list => fnd_api.g_false ,
819: p_commit => fnd_api.g_false ,
820: x_return_status => x_return_status ,
821: x_msg_count => x_msg_count ,
822: x_msg_data => x_msg_data );
823:

Line 825: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

821: x_msg_count => x_msg_count ,
822: x_msg_data => x_msg_data );
823:
824:
825: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
826: RAISE FND_API.G_EXC_ERROR;
827: END IF;
828:
829: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 826: RAISE FND_API.G_EXC_ERROR;

822: x_msg_data => x_msg_data );
823:
824:
825: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
826: RAISE FND_API.G_EXC_ERROR;
827: END IF;
828:
829: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 829: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

825: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
826: RAISE FND_API.G_EXC_ERROR;
827: END IF;
828:
829: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
831: END IF;
832:
833:

Line 830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

826: RAISE FND_API.G_EXC_ERROR;
827: END IF;
828:
829: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
831: END IF;
832:
833:
834: IF p_reason_code <> FND_API.G_MISS_CHAR

Line 834: IF p_reason_code <> FND_API.G_MISS_CHAR

830: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
831: END IF;
832:
833:
834: IF p_reason_code <> FND_API.G_MISS_CHAR
835: AND p_reason_code IS NOT NULL THEN
836: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
837: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyForSalesAssistance() starts');
838: END IF;

Line 842: ,p_init_msg_list => FND_API.G_TRUE

838: END IF;
839:
840: IBE_Workflow_Pvt.NotifyForSalesAssistance(
841: p_api_version => p_api_version_number
842: ,p_init_msg_list => FND_API.G_TRUE
843: ,p_quote_id => l_qte_header_rec.quote_header_id
844: ,p_customer_comments => p_customer_comments
845: ,p_reason_code => p_reason_code
846: ,p_salesrep_email_id => p_salesrep_email_id

Line 854: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

850:
851: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
852: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyForSalesAssistance() finishes');
853: END IF;
854: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
855: RAISE FND_API.G_EXC_ERROR;
856: END IF;
857:
858: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 855: RAISE FND_API.G_EXC_ERROR;

851: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
852: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyForSalesAssistance() finishes');
853: END IF;
854: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
855: RAISE FND_API.G_EXC_ERROR;
856: END IF;
857:
858: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 858: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

854: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
855: RAISE FND_API.G_EXC_ERROR;
856: END IF;
857:
858: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
860: END IF;
861: ELSE
862:

Line 859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

855: RAISE FND_API.G_EXC_ERROR;
856: END IF;
857:
858: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
860: END IF;
861: ELSE
862:
863: /*This part is to bock notifications for application in maintenance mode(High Availability)*/

Line 875: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

871:
872: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
873: IBE_Util.Debug('JTF_HA_STATE_PKG.Get_Current_state finishes');
874: END IF;
875: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878:
879: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 876: RAISE FND_API.G_EXC_ERROR;

872: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
873: IBE_Util.Debug('JTF_HA_STATE_PKG.Get_Current_state finishes');
874: END IF;
875: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878:
879: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 879: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

875: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878:
879: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
881: END IF;
882: IF(l_current_state NOT IN (2,3,4,5)) THEN
883:

Line 880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878:
879: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
881: END IF;
882: IF(l_current_state NOT IN (2,3,4,5)) THEN
883:
884: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 888: IF (p_sharee_party_id = fnd_api.g_miss_num OR p_sharee_party_id IS NULL) THEN

884: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
885: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyOrderStatus() starts');
886: END IF;
887: /*This part is a fix for sending notifications to sharee*/
888: IF (p_sharee_party_id = fnd_api.g_miss_num OR p_sharee_party_id IS NULL) THEN
889: IBE_Workflow_Pvt.NotifyOrderStatus(
890: p_api_version => p_api_version_number
891: ,p_init_msg_list => FND_API.G_TRUE
892: ,p_quote_id => l_qte_header_rec.quote_header_id

Line 891: ,p_init_msg_list => FND_API.G_TRUE

887: /*This part is a fix for sending notifications to sharee*/
888: IF (p_sharee_party_id = fnd_api.g_miss_num OR p_sharee_party_id IS NULL) THEN
889: IBE_Workflow_Pvt.NotifyOrderStatus(
890: p_api_version => p_api_version_number
891: ,p_init_msg_list => FND_API.G_TRUE
892: ,p_quote_id => l_qte_header_rec.quote_header_id
893: ,p_status => l_return_status
894: ,p_errmsg_count => l_msg_count
895: ,p_errmsg_data => l_msg_data

Line 904: ,p_init_msg_list => FND_API.G_TRUE

900: ELSE
901: /*Sharee is present*/
902: IBE_Workflow_Pvt.NotifyOrderStatus(
903: p_api_version => p_api_version_number
904: ,p_init_msg_list => FND_API.G_TRUE
905: ,p_quote_id => l_qte_header_rec.quote_header_id
906: ,p_status => l_return_status
907: ,p_errmsg_count => l_msg_count
908: ,p_errmsg_data => l_msg_data

Line 920: ,p_init_msg_list => FND_API.G_TRUE

916: /* Book Order Error - Enter Order Success should notify user */
917: IF (l_return_status = 'E' and x_return_status = 'S') THEN
918: IBE_Workflow_Pvt.NotifyOrderStatus(
919: p_api_version => p_api_version_number
920: ,p_init_msg_list => FND_API.G_TRUE
921: ,p_quote_id => l_qte_header_rec.quote_header_id
922: ,p_status => 'S'
923: ,p_errmsg_count => l_msg_count
924: ,p_errmsg_data => l_msg_data

Line 935: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

931: END IF;--for l_current_state(HA)
932: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
933: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyOrderStatus() finishes');
934: END IF;
935: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
936: RAISE FND_API.G_EXC_ERROR;
937: END IF;
938:
939: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 936: RAISE FND_API.G_EXC_ERROR;

932: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
933: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyOrderStatus() finishes');
934: END IF;
935: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
936: RAISE FND_API.G_EXC_ERROR;
937: END IF;
938:
939: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 939: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

935: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
936: RAISE FND_API.G_EXC_ERROR;
937: END IF;
938:
939: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
941: END IF;
942: END IF;
943:

Line 940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

936: RAISE FND_API.G_EXC_ERROR;
937: END IF;
938:
939: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
941: END IF;
942: END IF;
943:
944: -- End of API body.

Line 946: IF FND_API.To_Boolean( p_commit ) THEN

942: END IF;
943:
944: -- End of API body.
945: -- Standard check of p_commit.
946: IF FND_API.To_Boolean( p_commit ) THEN
947: COMMIT WORK;
948: END IF;
949:
950: -- Standard call to get message count and IF count is 1, get message info.

Line 951: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

947: COMMIT WORK;
948: END IF;
949:
950: -- Standard call to get message count and IF count is 1, get message info.
951: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
952: p_count => x_msg_count ,
953: p_data => x_msg_data);
954: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
955: IBE_Util.Debug('End IBE_Quote_Checkout_Pvt.SubmitQuote()');

Line 959: WHEN FND_API.G_EXC_ERROR THEN

955: IBE_Util.Debug('End IBE_Quote_Checkout_Pvt.SubmitQuote()');
956: END IF;
957: --ibe_util.disable_debug;
958: EXCEPTION
959: WHEN FND_API.G_EXC_ERROR THEN
960: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
961: IBE_Util.Debug('Expected exception in IBE_Quote_Checkout_Pvt.SubmitQuote');
962: END IF;
963: ROLLBACK TO SUBMITQUOTE_PVT;

Line 964: x_return_status := FND_API.G_RET_STS_ERROR;

960: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
961: IBE_Util.Debug('Expected exception in IBE_Quote_Checkout_Pvt.SubmitQuote');
962: END IF;
963: ROLLBACK TO SUBMITQUOTE_PVT;
964: x_return_status := FND_API.G_RET_STS_ERROR;
965: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
966: p_count => x_msg_count ,
967: p_data => x_msg_data);
968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 965: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

961: IBE_Util.Debug('Expected exception in IBE_Quote_Checkout_Pvt.SubmitQuote');
962: END IF;
963: ROLLBACK TO SUBMITQUOTE_PVT;
964: x_return_status := FND_API.G_RET_STS_ERROR;
965: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
966: p_count => x_msg_count ,
967: p_data => x_msg_data);
968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
969: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

964: x_return_status := FND_API.G_RET_STS_ERROR;
965: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
966: p_count => x_msg_count ,
967: p_data => x_msg_data);
968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
969: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
970: IBE_Util.Debug('Unexpected exception in IBE_Quote_Checkout_Pvt.SubmitQuote');
971: END IF;
972:

Line 974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

970: IBE_Util.Debug('Unexpected exception in IBE_Quote_Checkout_Pvt.SubmitQuote');
971: END IF;
972:
973: ROLLBACK TO SUBMITQUOTE_PVT;
974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
975: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
976: p_count => x_msg_count ,
977: p_data => x_msg_data);
978: WHEN OTHERS THEN

Line 975: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

971: END IF;
972:
973: ROLLBACK TO SUBMITQUOTE_PVT;
974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
975: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
976: p_count => x_msg_count ,
977: p_data => x_msg_data);
978: WHEN OTHERS THEN
979: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

980: IBE_Util.Debug('Unknown exception in IBE_Quote_Checkout_Pvt.SubmitQuote');
981: END IF;
982:
983: ROLLBACK TO SUBMITQUOTE_PVT;
984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
985: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
986: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
987: L_API_NAME);
988: END IF;

Line 989: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,

985: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
986: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
987: L_API_NAME);
988: END IF;
989: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
990: p_count => x_msg_count ,
991: p_data => x_msg_data);
992: END SubmitQuote;
993: END IBE_Quote_Checkout_Pvt;