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 102: IF(l_resource_id is not null AND l_resource_id <> FND_API.G_MISS_NUM AND l_party_id is not null

98: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_quote_source_code...'|| l_quote_source_code);
99: IBE_UTIL.DEBUG(' bug 16466998 Authorize_Credit_Card:l_cust_account_id...'|| l_cust_account_id);
100: END IF;
101:
102: IF(l_resource_id is not null AND l_resource_id <> FND_API.G_MISS_NUM AND l_party_id is not null
103: and l_quote_source_code = 'Order Capture Quotes') THEN
104: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
105: IBE_UTIL.DEBUG('Authorize_Credit_Card: l_resource_id not null and is Order Capture Quote. Get the org_id');
106: END IF;

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

173: IBE_UTIL.DEBUG('Authorize_Credit_Card: x_msg_data:'|| l_msg_data);
174: end if;
175: END IF;
176:
177: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND l_response.result_code = 'AUTH_SUCCESS' THEN
178:
179: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
180: IBE_UTIL.DEBUG('Authorize_Credit_Card:Authorization successful....Commiting the data');
181: END IF;

Line 190: x_return_status := FND_API.G_RET_STS_ERROR;

186: IBE_UTIL.DEBUG('Authorize_Credit_Card:CC Auth failed...!');
187: IBE_UTIL.DEBUG('Authorize_Credit_Card:l_response.result_code = '|| l_response.result_code);
188: END IF;
189:
190: x_return_status := FND_API.G_RET_STS_ERROR;
191:
192: FND_MSG_PUB.initialize;
193: FND_MESSAGE.CLEAR;
194:

Line 216: RAISE FND_API.G_EXC_ERROR;

212: FND_MSG_PUB.ADD;
213:
214: END IF;
215:
216: RAISE FND_API.G_EXC_ERROR;
217: END IF;
218:
219: EXCEPTION
220: WHEN FND_API.G_EXC_ERROR THEN

Line 220: WHEN FND_API.G_EXC_ERROR THEN

216: RAISE FND_API.G_EXC_ERROR;
217: END IF;
218:
219: EXCEPTION
220: WHEN FND_API.G_EXC_ERROR THEN
221: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
222: IBE_Util.Debug('Expected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
223: END IF;
224:

Line 225: x_return_status := FND_API.G_RET_STS_ERROR;

221: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
222: IBE_Util.Debug('Expected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
223: END IF;
224:
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count ,
228: p_data => x_msg_data);
229: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

222: IBE_Util.Debug('Expected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
223: END IF;
224:
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count ,
228: p_data => x_msg_data);
229: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
230: IBE_Util.Debug('Expected exception count and data'||x_msg_count||'data = '||x_msg_data);

Line 232: RAISE FND_API.G_EXC_ERROR;

228: p_data => x_msg_data);
229: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
230: IBE_Util.Debug('Expected exception count and data'||x_msg_count||'data = '||x_msg_data);
231: END IF;
232: RAISE FND_API.G_EXC_ERROR;
233:
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
236: IBE_Util.Debug('Unexpected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');

Line 234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

230: IBE_Util.Debug('Expected exception count and data'||x_msg_count||'data = '||x_msg_data);
231: END IF;
232: RAISE FND_API.G_EXC_ERROR;
233:
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
236: IBE_Util.Debug('Unexpected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
237: END IF;
238:

Line 239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

235: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
236: IBE_Util.Debug('Unexpected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
237: END IF;
238:
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
241: p_count => x_msg_count ,
242: p_data => x_msg_data);
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

236: IBE_Util.Debug('Unexpected exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
237: END IF;
238:
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
241: p_count => x_msg_count ,
242: p_data => x_msg_data);
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244:

Line 243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
241: p_count => x_msg_count ,
242: p_data => x_msg_data);
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244:
245: WHEN OTHERS THEN
246: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
247: IBE_Util.Debug('Unknown exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');

Line 250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

246: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
247: IBE_Util.Debug('Unknown exception in IBE_Quote_Checkout_Pvt.Authorize_Credit_Card');
248: END IF;
249:
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
251: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
252: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
253: L_API_NAME);
254: END IF;

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

251: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
252: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
253: L_API_NAME);
254: END IF;
255: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
256: p_count => x_msg_count ,
257: p_data => x_msg_data);
258:
259: END Authorize_Credit_Card;

Line 271: RETURN FND_API.G_TRUE;

267:
268: FUNCTION Boolean_To_GBoolean(p_Cond IN BOOLEAN) RETURN VARCHAR2 IS
269: BEGIN
270: IF p_Cond THEN
271: RETURN FND_API.G_TRUE;
272: ELSE
273: RETURN FND_API.G_FALSE;
274: END IF;
275: END Boolean_To_GBoolean;

Line 273: RETURN FND_API.G_FALSE;

269: BEGIN
270: IF p_Cond THEN
271: RETURN FND_API.G_TRUE;
272: ELSE
273: RETURN FND_API.G_FALSE;
274: END IF;
275: END Boolean_To_GBoolean;
276:
277: BEGIN

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

285: IBE_Util.Debug('Submit_Control_Rec.Book_Flag=(' || px_submit_control_rec.book_flag || ')');
286: IBE_Util.Debug('FND_PROFILE(ASO_DEFAULT_ORDER_STATE)=(' || FND_PROFILE.Value('ASO_DEFAULT_ORDER_STATE') || ')');
287: END IF;
288:
289: IF px_submit_control_rec.book_flag = FND_API.G_MISS_CHAR --OR
290: -- px_submit_control_rec.book_flag = 'F'
291: -- shouldn't be defaulting if F is passed in
292: THEN
293: l_qte_payment_tbl := IBE_Quote_Misc_pvt.getHeaderPaymentTbl(p_qte_header_id);

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

303: /*IF l_qte_payment_tbl(1).payment_ref_number IS NOT NULL THEN
304: px_submit_control_rec.book_flag :=
305: Boolean_To_GBoolean(FND_PROFILE.Value('ASO_DEFAULT_ORDER_STATE') = 'BOOKED');
306: ELSE
307: px_submit_control_rec.book_flag := FND_API.G_FALSE;
308: END IF;*/
309:
310: /*mannamra: Credit Card Consolidation changes: 1. We will no longer use payment_ref_number, which would
311: be the credit card number when payment type is credit_card,

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

315: not taking into consideration the case when only PO number
316: is passed.
317: */
318: IF (l_qte_payment_tbl(1).instr_assignment_id is not null
319: AND l_qte_payment_tbl(1).instr_assignment_id <> FND_API.G_MISS_NUM) THEN
320: px_submit_control_rec.book_flag :=
321: Boolean_To_GBoolean(FND_PROFILE.Value('ASO_DEFAULT_ORDER_STATE') = 'BOOKED');
322: ELSE
323: px_submit_control_rec.book_flag := FND_API.G_FALSE;

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

319: AND l_qte_payment_tbl(1).instr_assignment_id <> FND_API.G_MISS_NUM) THEN
320: px_submit_control_rec.book_flag :=
321: Boolean_To_GBoolean(FND_PROFILE.Value('ASO_DEFAULT_ORDER_STATE') = 'BOOKED');
322: ELSE
323: px_submit_control_rec.book_flag := FND_API.G_FALSE;
324: END IF;
325:
326: ELSIF NVL(l_qte_payment_tbl(1).payment_type_code, 'CASH') IN ('CASH', 'CHECK') THEN
327: px_submit_control_rec.book_flag :=

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

344: END Default_Order_State;
345:
346: PROCEDURE SubmitQuote(
347: p_api_version_number IN NUMBER
348: ,p_commit IN VARCHAR2 := FND_API.g_false
349: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
350: ,p_quote_Header_Id IN NUMBER
351: ,p_last_update_date in DATE := FND_API.G_MISS_DATE
352:

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

345:
346: PROCEDURE SubmitQuote(
347: p_api_version_number IN NUMBER
348: ,p_commit IN VARCHAR2 := FND_API.g_false
349: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
350: ,p_quote_Header_Id IN NUMBER
351: ,p_last_update_date in DATE := FND_API.G_MISS_DATE
352:
353: ,p_sharee_party_Id IN NUMBER := FND_API.G_MISS_NUM

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

347: p_api_version_number IN NUMBER
348: ,p_commit IN VARCHAR2 := FND_API.g_false
349: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
350: ,p_quote_Header_Id IN NUMBER
351: ,p_last_update_date in DATE := FND_API.G_MISS_DATE
352:
353: ,p_sharee_party_Id IN NUMBER := FND_API.G_MISS_NUM
354: ,p_sharee_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
355: ,p_sharee_number IN NUMBER := FND_API.G_MISS_NUM

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

349: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
350: ,p_quote_Header_Id IN NUMBER
351: ,p_last_update_date in DATE := FND_API.G_MISS_DATE
352:
353: ,p_sharee_party_Id IN NUMBER := FND_API.G_MISS_NUM
354: ,p_sharee_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
355: ,p_sharee_number IN NUMBER := FND_API.G_MISS_NUM
356:
357: ,p_submit_Control_Rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type

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

350: ,p_quote_Header_Id IN NUMBER
351: ,p_last_update_date in DATE := FND_API.G_MISS_DATE
352:
353: ,p_sharee_party_Id IN NUMBER := FND_API.G_MISS_NUM
354: ,p_sharee_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
355: ,p_sharee_number IN NUMBER := FND_API.G_MISS_NUM
356:
357: ,p_submit_Control_Rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type
358: := ASO_QUOTE_PUB.G_MISS_Submit_Control_Rec

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

351: ,p_last_update_date in DATE := FND_API.G_MISS_DATE
352:
353: ,p_sharee_party_Id IN NUMBER := FND_API.G_MISS_NUM
354: ,p_sharee_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
355: ,p_sharee_number IN NUMBER := FND_API.G_MISS_NUM
356:
357: ,p_submit_Control_Rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type
358: := ASO_QUOTE_PUB.G_MISS_Submit_Control_Rec
359:

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

356:
357: ,p_submit_Control_Rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type
358: := ASO_QUOTE_PUB.G_MISS_Submit_Control_Rec
359:
360: ,p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR
361: ,p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR
362: ,p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR
363:
364: -- 9/17/02: added to control calling validate_user_update

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

357: ,p_submit_Control_Rec IN ASO_QUOTE_PUB.Submit_Control_Rec_Type
358: := ASO_QUOTE_PUB.G_MISS_Submit_Control_Rec
359:
360: ,p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR
361: ,p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR
362: ,p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR
363:
364: -- 9/17/02: added to control calling validate_user_update
365: ,p_validate_user IN VARCHAR2 := FND_API.G_TRUE

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

358: := ASO_QUOTE_PUB.G_MISS_Submit_Control_Rec
359:
360: ,p_customer_comments IN VARCHAR2 := FND_API.G_MISS_CHAR
361: ,p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR
362: ,p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR
363:
364: -- 9/17/02: added to control calling validate_user_update
365: ,p_validate_user IN VARCHAR2 := FND_API.G_TRUE
366: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM

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

361: ,p_reason_code IN VARCHAR2 := FND_API.G_MISS_CHAR
362: ,p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR
363:
364: -- 9/17/02: added to control calling validate_user_update
365: ,p_validate_user IN VARCHAR2 := FND_API.G_TRUE
366: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
367:
368: ,x_order_header_rec OUT NOCOPY ASO_QUOTE_PUB.Order_Header_Rec_Type
369: --Mannamra: Added for bug 4716044

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

362: ,p_salesrep_email_id IN VARCHAR2 := FND_API.G_MISS_CHAR
363:
364: -- 9/17/02: added to control calling validate_user_update
365: ,p_validate_user IN VARCHAR2 := FND_API.G_TRUE
366: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
367:
368: ,x_order_header_rec OUT NOCOPY ASO_QUOTE_PUB.Order_Header_Rec_Type
369: --Mannamra: Added for bug 4716044
370: ,x_hold_flag OUT NOCOPY VARCHAR2

Line 442: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,

438: BEGIN
439: -- Standard Start of API savepoint
440: SAVEPOINT SUBMITQUOTE_PVT;
441: -- Standard call to check for call compatibility.
442: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,
443: P_Api_Version_Number,
444: L_API_NAME,
445: G_PKG_NAME )
446: THEN

Line 447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

443: P_Api_Version_Number,
444: L_API_NAME,
445: G_PKG_NAME )
446: THEN
447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448: END IF;
449: -- Initialize message list IF p_init_msg_list is set to TRUE.
450: IF FND_API.to_Boolean( p_init_msg_list ) THEN
451: FND_MSG_PUB.initialize;

Line 450: IF FND_API.to_Boolean( p_init_msg_list ) THEN

446: THEN
447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448: END IF;
449: -- Initialize message list IF p_init_msg_list is set to TRUE.
450: IF FND_API.to_Boolean( p_init_msg_list ) THEN
451: FND_MSG_PUB.initialize;
452: END IF;
453:
454: -- Initialize API return status to success

Line 455: x_return_status := FND_API.G_RET_STS_SUCCESS;

451: FND_MSG_PUB.initialize;
452: END IF;
453:
454: -- Initialize API return status to success
455: x_return_status := FND_API.G_RET_STS_SUCCESS;
456:
457: -- API body
458: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
459: IBE_UTIL.DEBUG('SUBMITQUOTE: Before Calling log_environment_info');

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

469:
470: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
471: IBE_UTIL.DEBUG('Submit_Quote: p_validate_user flag='||p_validate_user);
472: END IF;
473: if (fnd_api.to_boolean(p_validate_user)) then
474: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
475: IBE_UTIL.DEBUG('Submit_Quote: before calling validate_user_update()');
476: END IF;
477: -- User Authentication

Line 479: p_init_msg_list => FND_API.G_TRUE

475: IBE_UTIL.DEBUG('Submit_Quote: before calling validate_user_update()');
476: END IF;
477: -- User Authentication
478: IBE_Quote_Misc_pvt.Validate_User_Update(
479: p_init_msg_list => FND_API.G_TRUE
480: ,p_quote_header_id => p_quote_Header_Id
481: ,p_quote_retrieval_number => p_sharee_number
482: ,p_validate_user => FND_API.G_TRUE
483: ,p_privilege_type_code => 'A'

Line 482: ,p_validate_user => FND_API.G_TRUE

478: IBE_Quote_Misc_pvt.Validate_User_Update(
479: p_init_msg_list => FND_API.G_TRUE
480: ,p_quote_header_id => p_quote_Header_Id
481: ,p_quote_retrieval_number => p_sharee_number
482: ,p_validate_user => FND_API.G_TRUE
483: ,p_privilege_type_code => 'A'
484: ,p_save_type => PLACE_ORDER
485: ,p_last_update_date => p_last_update_date
486: ,x_return_status => x_return_status

Line 490: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

486: ,x_return_status => x_return_status
487: ,x_msg_count => x_msg_count
488: ,x_msg_data => x_msg_data
489: );
490: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:
494: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 491: RAISE FND_API.G_EXC_ERROR;

487: ,x_msg_count => x_msg_count
488: ,x_msg_data => x_msg_data
489: );
490: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:
494: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 494: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

490: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:
494: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END IF;
497: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
498: IBE_UTIL.debug('SUBmit_quote: after calling validate_user_update()');

Line 495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:
494: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END IF;
497: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
498: IBE_UTIL.debug('SUBmit_quote: after calling validate_user_update()');
499: END IF;

Line 504: AND p_sharee_number <> FND_API.G_MISS_NUM THEN

500: end if;
501:
502: l_qte_header_rec.quote_header_id := p_quote_header_id;
503: /*IF p_sharee_number IS NOT NULL
504: AND p_sharee_number <> FND_API.G_MISS_NUM THEN
505: -- save cart check permisson
506: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
507: IBE_Util.Debug('IBE_Quote_Save_pvt.Save() starts');
508: END IF;

Line 512: ,p_init_msg_list => FND_API.G_TRUE

508: END IF;
509:
510: IBE_Quote_Save_pvt.Save(
511: p_api_version_number => p_api_version_number
512: ,p_init_msg_list => FND_API.G_TRUE
513: ,p_commit => FND_API.G_FALSE
514: ,p_sharee_number => p_sharee_number
515: ,p_sharee_party_id => p_sharee_party_id
516: ,p_sharee_cust_account_id => p_sharee_cust_account_id

Line 513: ,p_commit => FND_API.G_FALSE

509:
510: IBE_Quote_Save_pvt.Save(
511: p_api_version_number => p_api_version_number
512: ,p_init_msg_list => FND_API.G_TRUE
513: ,p_commit => FND_API.G_FALSE
514: ,p_sharee_number => p_sharee_number
515: ,p_sharee_party_id => p_sharee_party_id
516: ,p_sharee_cust_account_id => p_sharee_cust_account_id
517: ,p_changeowner => fnd_api.g_true

Line 517: ,p_changeowner => fnd_api.g_true

513: ,p_commit => FND_API.G_FALSE
514: ,p_sharee_number => p_sharee_number
515: ,p_sharee_party_id => p_sharee_party_id
516: ,p_sharee_cust_account_id => p_sharee_cust_account_id
517: ,p_changeowner => fnd_api.g_true
518: ,p_qte_header_rec => l_qte_header_rec
519: ,x_quote_header_id => l_quote_header_id_tmp
520: ,x_last_update_date => l_last_update_date_tmp
521: ,x_return_status => x_return_status

Line 529: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

525: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
526: IBE_Util.Debug('IBE_Quote_Save_pvt.Save() finishes');
527: END IF;
528:
529: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
530: RAISE FND_API.G_EXC_ERROR;
531: END IF;
532:
533: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 530: RAISE FND_API.G_EXC_ERROR;

526: IBE_Util.Debug('IBE_Quote_Save_pvt.Save() finishes');
527: END IF;
528:
529: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
530: RAISE FND_API.G_EXC_ERROR;
531: END IF;
532:
533: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 533: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

529: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
530: RAISE FND_API.G_EXC_ERROR;
531: END IF;
532:
533: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
535: END IF;
536:
537: l_qte_header_rec.quote_header_id := l_quote_header_id_tmp;

Line 534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

530: RAISE FND_API.G_EXC_ERROR;
531: END IF;
532:
533: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
535: END IF;
536:
537: l_qte_header_rec.quote_header_id := l_quote_header_id_tmp;
538: l_qte_header_rec.last_update_date := l_last_update_date_tmp;

Line 615: p_user_type => FND_API.G_MISS_CHAR,

611:
612: IF (l_party_id is not null) THEN
613: IBE_WORKFLOW_PVT.get_name_details(
614: p_party_id => l_party_id,
615: p_user_type => FND_API.G_MISS_CHAR,
616: x_contact_first_name => l_person_first_name,
617: x_contact_last_name => l_person_last_name,
618: x_party_id => lx_party_id);
619: END IF;

Line 680: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

676: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
677: IBE_Util.Debug('After Authorize_Credit_Card checking the returned status');
678: END IF;
679:
680: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
681: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
682: IBE_Util.Debug('IBE_Quote_Checkout_Pvt.Authorize_Credit_Card(): Exp Error while entering the quote ');
683: END IF;
684:

Line 685: RAISE FND_API.G_EXC_ERROR;

681: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
682: IBE_Util.Debug('IBE_Quote_Checkout_Pvt.Authorize_Credit_Card(): Exp Error while entering the quote ');
683: END IF;
684:
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;
687:
688: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
689: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 688: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

684:
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;
687:
688: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
689: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
690: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Unexp Error while entering the quote ');
691: END IF;
692:

Line 693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

689: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
690: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Unexp Error while entering the quote ');
691: END IF;
692:
693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
694: END IF;
695: END IF;
696:
697: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 703: ,P_Init_Msg_List => FND_API.G_TRUE

699: END IF;
700:
701: ASO_Quote_Pub.Submit_quote(
702: P_Api_Version_Number => p_api_version_number
703: ,P_Init_Msg_List => FND_API.G_TRUE
704: ,P_Commit => FND_API.G_FALSE
705: ,p_control_rec => l_submit_control_rec
706: ,P_Qte_Header_Rec => l_qte_header_rec
707: ,x_order_header_rec => x_Order_Header_Rec

Line 704: ,P_Commit => FND_API.G_FALSE

700:
701: ASO_Quote_Pub.Submit_quote(
702: P_Api_Version_Number => p_api_version_number
703: ,P_Init_Msg_List => FND_API.G_TRUE
704: ,P_Commit => FND_API.G_FALSE
705: ,p_control_rec => l_submit_control_rec
706: ,P_Qte_Header_Rec => l_qte_header_rec
707: ,x_order_header_rec => x_Order_Header_Rec
708: ,x_return_status => x_return_status

Line 767: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

763: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
764: IBE_Util.Debug('Else:After Authorize_Credit_Card checking the returned status');
765: END IF;
766:
767: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
768: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
769: IBE_Util.Debug('Else:IBE_Quote_Checkout_Pvt.Authorize_Credit_Card(): Exp Error while entering the quote ');
770: END IF;
771:

Line 772: RAISE FND_API.G_EXC_ERROR;

768: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
769: IBE_Util.Debug('Else:IBE_Quote_Checkout_Pvt.Authorize_Credit_Card(): Exp Error while entering the quote ');
770: END IF;
771:
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774:
775: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
776: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 775: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

771:
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774:
775: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
776: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
777: IBE_Util.Debug('Else:ASO_Quote_Pub.Submit_Quote(): Unexp Error while entering the quote ');
778: END IF;
779:

Line 780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

776: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
777: IBE_Util.Debug('Else:ASO_Quote_Pub.Submit_Quote(): Unexp Error while entering the quote ');
778: END IF;
779:
780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
781: END IF;
782: END IF;
783:
784: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 794: ,p_Init_Msg_List => FND_API.G_TRUE

790:
791:
792: ASO_Quote_Pub.Submit_Quote(
793: p_api_version_number => p_api_version_number
794: ,p_Init_Msg_List => FND_API.G_TRUE
795: ,p_control_rec => l_submit_control_rec
796: ,p_Qte_Header_Id => l_qte_header_rec.quote_header_id
797: ,x_order_header_rec => x_Order_Header_Rec
798: ,x_return_status => x_return_status

Line 810: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

806: l_msg_data := x_msg_data;
807: l_msg_count := x_msg_count;
808: l_return_status := x_return_status;
809:
810: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
811: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
812: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Error in submit quote');
813: END IF;
814:

Line 815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

811: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
812: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Error in submit quote');
813: END IF;
814:
815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
816: END IF;
817:
818: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
819: IF ( l_submit_control_rec.book_flag = FND_API.G_TRUE

Line 818: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

814:
815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
816: END IF;
817:
818: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
819: IF ( l_submit_control_rec.book_flag = FND_API.G_TRUE
820: AND FND_PROFILE.VALUE('IBE_ENTER_ORDER_ON_ERROR') = 'Y')
821: THEN
822: -- l_submit_control_rec := p_submit_control_rec;

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

815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
816: END IF;
817:
818: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
819: IF ( l_submit_control_rec.book_flag = FND_API.G_TRUE
820: AND FND_PROFILE.VALUE('IBE_ENTER_ORDER_ON_ERROR') = 'Y')
821: THEN
822: -- l_submit_control_rec := p_submit_control_rec;
823: l_submit_control_rec.book_flag := fnd_api.g_false;

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

819: IF ( l_submit_control_rec.book_flag = FND_API.G_TRUE
820: AND FND_PROFILE.VALUE('IBE_ENTER_ORDER_ON_ERROR') = 'Y')
821: THEN
822: -- l_submit_control_rec := p_submit_control_rec;
823: l_submit_control_rec.book_flag := fnd_api.g_false;
824:
825: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
826: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote() after book failure starts');
827: END IF;

Line 831: ,p_Init_Msg_List => FND_API.G_TRUE

827: END IF;
828:
829: ASO_Quote_Pub.Submit_Quote(
830: p_api_version_number => p_api_version_number
831: ,p_Init_Msg_List => FND_API.G_TRUE
832: ,p_control_rec => l_submit_control_rec
833: ,p_Qte_Header_Id => l_qte_header_rec.quote_header_id
834: ,x_order_header_rec => x_Order_Header_Rec
835: ,x_return_status => x_return_status

Line 843: IF x_return_status = FND_API.G_RET_STS_ERROR THEN -- bug 12754581, scnagara

839: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
840: 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);
841: END IF;
842:
843: IF x_return_status = FND_API.G_RET_STS_ERROR THEN -- bug 12754581, scnagara
844: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
845: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Exp Error while entering the quote ');
846: END IF;
847:

Line 848: RAISE FND_API.G_EXC_ERROR;

844: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
845: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Exp Error while entering the quote ');
846: END IF;
847:
848: RAISE FND_API.G_EXC_ERROR;
849: END IF;
850:
851: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
852: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 851: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

847:
848: RAISE FND_API.G_EXC_ERROR;
849: END IF;
850:
851: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
852: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
853: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Unexp Error while entering the quote ');
854: END IF;
855:

Line 856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

852: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
853: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Unexp Error while entering the quote ');
854: END IF;
855:
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: END IF;
858: ELSE
859:
860: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 863: RAISE FND_API.G_EXC_ERROR;

859:
860: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
861: IBE_Util.Debug('ASO_Quote_Pub.Submit_Quote(): Error in submit quote');
862: END IF;
863: RAISE FND_API.G_EXC_ERROR;
864: END IF;
865: END IF;
866:
867: -------------------------------------------------------------------------------------

Line 879: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

875: ,x_return_status => x_return_status
876: ,x_msg_count => x_msg_count
877: ,x_msg_data => x_msg_data);
878:
879: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
880: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
881: IBE_Util.Debug('submitQuote: oe_holds_pub.check_holds has returned with an error '||x_msg_data);
882: END IF;
883:

Line 884: RAISE FND_API.G_EXC_ERROR;

880: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
881: IBE_Util.Debug('submitQuote: oe_holds_pub.check_holds has returned with an error '||x_msg_data);
882: END IF;
883:
884: RAISE FND_API.G_EXC_ERROR;
885: END IF;
886:
887: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
888: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 887: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

883:
884: RAISE FND_API.G_EXC_ERROR;
885: END IF;
886:
887: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
888: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
889: IBE_Util.Debug('submitQuote: oe_holds_pub.check_holds has returned with an error '||x_msg_data);
890: END IF;
891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

887: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
888: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
889: IBE_Util.Debug('submitQuote: oe_holds_pub.check_holds has returned with an error '||x_msg_data);
890: END IF;
891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
892: END IF;
893:
894: x_hold_flag := l_hold_flag;
895:

Line 903: p_init_msg_list => fnd_api.g_false ,

899: p_quote_header_id => p_quote_header_id ,
900: p_delete_context => 'IBE_SC_CART_ORDERED',
901: P_minisite_id => p_minisite_id ,
902: p_api_version => p_api_version_number ,
903: p_init_msg_list => fnd_api.g_false ,
904: p_commit => fnd_api.g_false ,
905: x_return_status => x_return_status ,
906: x_msg_count => x_msg_count ,
907: x_msg_data => x_msg_data );

Line 904: p_commit => fnd_api.g_false ,

900: p_delete_context => 'IBE_SC_CART_ORDERED',
901: P_minisite_id => p_minisite_id ,
902: p_api_version => p_api_version_number ,
903: p_init_msg_list => fnd_api.g_false ,
904: p_commit => fnd_api.g_false ,
905: x_return_status => x_return_status ,
906: x_msg_count => x_msg_count ,
907: x_msg_data => x_msg_data );
908:

Line 910: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

906: x_msg_count => x_msg_count ,
907: x_msg_data => x_msg_data );
908:
909:
910: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
911: RAISE FND_API.G_EXC_ERROR;
912: END IF;
913:
914: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 911: RAISE FND_API.G_EXC_ERROR;

907: x_msg_data => x_msg_data );
908:
909:
910: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
911: RAISE FND_API.G_EXC_ERROR;
912: END IF;
913:
914: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 914: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

910: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
911: RAISE FND_API.G_EXC_ERROR;
912: END IF;
913:
914: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
916: END IF;
917:
918:

Line 915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

911: RAISE FND_API.G_EXC_ERROR;
912: END IF;
913:
914: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
916: END IF;
917:
918:
919: IF p_reason_code <> FND_API.G_MISS_CHAR

Line 919: IF p_reason_code <> FND_API.G_MISS_CHAR

915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
916: END IF;
917:
918:
919: IF p_reason_code <> FND_API.G_MISS_CHAR
920: AND p_reason_code IS NOT NULL THEN
921: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
922: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyForSalesAssistance() starts');
923: END IF;

Line 927: ,p_init_msg_list => FND_API.G_TRUE

923: END IF;
924:
925: IBE_Workflow_Pvt.NotifyForSalesAssistance(
926: p_api_version => p_api_version_number
927: ,p_init_msg_list => FND_API.G_TRUE
928: ,p_quote_id => l_qte_header_rec.quote_header_id
929: ,p_customer_comments => p_customer_comments
930: ,p_reason_code => p_reason_code
931: ,p_salesrep_email_id => p_salesrep_email_id

Line 939: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

935:
936: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
937: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyForSalesAssistance() finishes');
938: END IF;
939: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
940: RAISE FND_API.G_EXC_ERROR;
941: END IF;
942:
943: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 940: RAISE FND_API.G_EXC_ERROR;

936: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
937: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyForSalesAssistance() finishes');
938: END IF;
939: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
940: RAISE FND_API.G_EXC_ERROR;
941: END IF;
942:
943: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 943: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

939: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
940: RAISE FND_API.G_EXC_ERROR;
941: END IF;
942:
943: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
945: END IF;
946: ELSE
947:

Line 944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

940: RAISE FND_API.G_EXC_ERROR;
941: END IF;
942:
943: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
945: END IF;
946: ELSE
947:
948: /*This part is to bock notifications for application in maintenance mode(High Availability)*/

Line 960: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

956:
957: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
958: IBE_Util.Debug('JTF_HA_STATE_PKG.Get_Current_state finishes');
959: END IF;
960: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
961: RAISE FND_API.G_EXC_ERROR;
962: END IF;
963:
964: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 961: RAISE FND_API.G_EXC_ERROR;

957: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
958: IBE_Util.Debug('JTF_HA_STATE_PKG.Get_Current_state finishes');
959: END IF;
960: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
961: RAISE FND_API.G_EXC_ERROR;
962: END IF;
963:
964: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 964: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

960: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
961: RAISE FND_API.G_EXC_ERROR;
962: END IF;
963:
964: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
966: END IF;
967: IF(l_current_state NOT IN (2,3,4,5)) THEN
968:

Line 965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

961: RAISE FND_API.G_EXC_ERROR;
962: END IF;
963:
964: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
966: END IF;
967: IF(l_current_state NOT IN (2,3,4,5)) THEN
968:
969: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

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

969: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
970: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyOrderStatus() starts');
971: END IF;
972: /*This part is a fix for sending notifications to sharee*/
973: IF (p_sharee_party_id = fnd_api.g_miss_num OR p_sharee_party_id IS NULL) THEN
974: IBE_Workflow_Pvt.NotifyOrderStatus(
975: p_api_version => p_api_version_number
976: ,p_init_msg_list => FND_API.G_TRUE
977: ,p_quote_id => l_qte_header_rec.quote_header_id

Line 976: ,p_init_msg_list => FND_API.G_TRUE

972: /*This part is a fix for sending notifications to sharee*/
973: IF (p_sharee_party_id = fnd_api.g_miss_num OR p_sharee_party_id IS NULL) THEN
974: IBE_Workflow_Pvt.NotifyOrderStatus(
975: p_api_version => p_api_version_number
976: ,p_init_msg_list => FND_API.G_TRUE
977: ,p_quote_id => l_qte_header_rec.quote_header_id
978: ,p_status => l_return_status
979: ,p_errmsg_count => l_msg_count
980: ,p_errmsg_data => l_msg_data

Line 989: ,p_init_msg_list => FND_API.G_TRUE

985: ELSE
986: /*Sharee is present*/
987: IBE_Workflow_Pvt.NotifyOrderStatus(
988: p_api_version => p_api_version_number
989: ,p_init_msg_list => FND_API.G_TRUE
990: ,p_quote_id => l_qte_header_rec.quote_header_id
991: ,p_status => l_return_status
992: ,p_errmsg_count => l_msg_count
993: ,p_errmsg_data => l_msg_data

Line 1005: ,p_init_msg_list => FND_API.G_TRUE

1001: /* Book Order Error - Enter Order Success should notify user */
1002: IF (l_return_status = 'E' and x_return_status = 'S') THEN
1003: IBE_Workflow_Pvt.NotifyOrderStatus(
1004: p_api_version => p_api_version_number
1005: ,p_init_msg_list => FND_API.G_TRUE
1006: ,p_quote_id => l_qte_header_rec.quote_header_id
1007: ,p_status => 'S'
1008: ,p_errmsg_count => l_msg_count
1009: ,p_errmsg_data => l_msg_data

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

1016: END IF;--for l_current_state(HA)
1017: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1018: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyOrderStatus() finishes');
1019: END IF;
1020: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1021: RAISE FND_API.G_EXC_ERROR;
1022: END IF;
1023:
1024: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1021: RAISE FND_API.G_EXC_ERROR;

1017: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1018: IBE_Util.Debug('IBE_Workflow_Pvt.NotifyOrderStatus() finishes');
1019: END IF;
1020: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1021: RAISE FND_API.G_EXC_ERROR;
1022: END IF;
1023:
1024: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1020: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1021: RAISE FND_API.G_EXC_ERROR;
1022: END IF;
1023:
1024: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1026: END IF;
1027: END IF;
1028:

Line 1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1021: RAISE FND_API.G_EXC_ERROR;
1022: END IF;
1023:
1024: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1026: END IF;
1027: END IF;
1028:
1029: -- End of API body.

Line 1031: IF FND_API.To_Boolean( p_commit ) THEN

1027: END IF;
1028:
1029: -- End of API body.
1030: -- Standard check of p_commit.
1031: IF FND_API.To_Boolean( p_commit ) THEN
1032: COMMIT WORK;
1033: END IF;
1034:
1035: -- Standard call to get message count and IF count is 1, get message info.

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

1032: COMMIT WORK;
1033: END IF;
1034:
1035: -- Standard call to get message count and IF count is 1, get message info.
1036: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1037: p_count => x_msg_count ,
1038: p_data => x_msg_data);
1039: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1040: IBE_Util.Debug('End IBE_Quote_Checkout_Pvt.SubmitQuote()');

Line 1044: WHEN FND_API.G_EXC_ERROR THEN

1040: IBE_Util.Debug('End IBE_Quote_Checkout_Pvt.SubmitQuote()');
1041: END IF;
1042: --ibe_util.disable_debug;
1043: EXCEPTION
1044: WHEN FND_API.G_EXC_ERROR THEN
1045: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1046: IBE_Util.Debug('Expected exception in IBE_Quote_Checkout_Pvt.SubmitQuote');
1047: END IF;
1048: ROLLBACK TO SUBMITQUOTE_PVT;

Line 1049: x_return_status := FND_API.G_RET_STS_ERROR;

1045: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1046: IBE_Util.Debug('Expected exception in IBE_Quote_Checkout_Pvt.SubmitQuote');
1047: END IF;
1048: ROLLBACK TO SUBMITQUOTE_PVT;
1049: x_return_status := FND_API.G_RET_STS_ERROR;
1050: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1051: p_count => x_msg_count ,
1052: p_data => x_msg_data);
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1046: IBE_Util.Debug('Expected exception in IBE_Quote_Checkout_Pvt.SubmitQuote');
1047: END IF;
1048: ROLLBACK TO SUBMITQUOTE_PVT;
1049: x_return_status := FND_API.G_RET_STS_ERROR;
1050: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1051: p_count => x_msg_count ,
1052: p_data => x_msg_data);
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1049: x_return_status := FND_API.G_RET_STS_ERROR;
1050: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1051: p_count => x_msg_count ,
1052: p_data => x_msg_data);
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1055: IBE_Util.Debug('Unexpected exception in IBE_Quote_Checkout_Pvt.SubmitQuote');
1056: END IF;
1057:

Line 1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1055: IBE_Util.Debug('Unexpected exception in IBE_Quote_Checkout_Pvt.SubmitQuote');
1056: END IF;
1057:
1058: ROLLBACK TO SUBMITQUOTE_PVT;
1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1060: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1061: p_count => x_msg_count ,
1062: p_data => x_msg_data);
1063: WHEN OTHERS THEN

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

1056: END IF;
1057:
1058: ROLLBACK TO SUBMITQUOTE_PVT;
1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1060: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1061: p_count => x_msg_count ,
1062: p_data => x_msg_data);
1063: WHEN OTHERS THEN
1064: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1065: IBE_Util.Debug('Unknown exception in IBE_Quote_Checkout_Pvt.SubmitQuote');
1066: END IF;
1067:
1068: ROLLBACK TO SUBMITQUOTE_PVT;
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1071: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1072: L_API_NAME);
1073: END IF;

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

1070: IF FND_Msg_Pub.Check_Msg_Level(FND_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1071: FND_Msg_Pub.Add_Exc_Msg(G_PKG_NAME,
1072: L_API_NAME);
1073: END IF;
1074: FND_Msg_Pub.Count_And_Get(p_encoded => FND_API.G_FALSE,
1075: p_count => x_msg_count ,
1076: p_data => x_msg_data);
1077: END SubmitQuote;
1078: END IBE_Quote_Checkout_Pvt;