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.ASO_SUBMIT_QUOTE_PVT dependencies on ASO_DEBUG_PUB

Line 226: IF aso_debug_pub.g_debug_flag = 'Y' THEN

222: FND_MSG_PUB.Add;
223: END IF;
224:
225: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
226: IF aso_debug_pub.g_debug_flag = 'Y' THEN
227: aso_debug_pub.add('Before call to printing login info details', 1, 'Y');
228: ASO_UTILITY_PVT.print_login_info;
229: aso_debug_pub.add('After call to printing login info details', 1, 'Y');
230: END IF;

Line 227: aso_debug_pub.add('Before call to printing login info details', 1, 'Y');

223: END IF;
224:
225: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
226: IF aso_debug_pub.g_debug_flag = 'Y' THEN
227: aso_debug_pub.add('Before call to printing login info details', 1, 'Y');
228: ASO_UTILITY_PVT.print_login_info;
229: aso_debug_pub.add('After call to printing login info details', 1, 'Y');
230: END IF;
231:

Line 229: aso_debug_pub.add('After call to printing login info details', 1, 'Y');

225: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
226: IF aso_debug_pub.g_debug_flag = 'Y' THEN
227: aso_debug_pub.add('Before call to printing login info details', 1, 'Y');
228: ASO_UTILITY_PVT.print_login_info;
229: aso_debug_pub.add('After call to printing login info details', 1, 'Y');
230: END IF;
231:
232: -- Change Done By Girish
233: -- Procedure added to validate the operating unit

Line 256: IF aso_debug_pub.g_debug_flag = 'Y' THEN

252: RAISE FND_API.G_EXC_ERROR;
253: END IF;
254: -- ******************************************************************
255:
256: IF aso_debug_pub.g_debug_flag = 'Y' THEN
257: aso_debug_pub.add('Submit_Q: Begin ', 1, 'N');
258: aso_debug_pub.add('l_om_defaulting_prof: '||l_om_defaulting_prof,1,'N');
259: END IF;
260:

Line 257: aso_debug_pub.add('Submit_Q: Begin ', 1, 'N');

253: END IF;
254: -- ******************************************************************
255:
256: IF aso_debug_pub.g_debug_flag = 'Y' THEN
257: aso_debug_pub.add('Submit_Q: Begin ', 1, 'N');
258: aso_debug_pub.add('l_om_defaulting_prof: '||l_om_defaulting_prof,1,'N');
259: END IF;
260:
261: -- vtariker - Check Whether record has been changed

Line 258: aso_debug_pub.add('l_om_defaulting_prof: '||l_om_defaulting_prof,1,'N');

254: -- ******************************************************************
255:
256: IF aso_debug_pub.g_debug_flag = 'Y' THEN
257: aso_debug_pub.add('Submit_Q: Begin ', 1, 'N');
258: aso_debug_pub.add('l_om_defaulting_prof: '||l_om_defaulting_prof,1,'N');
259: END IF;
260:
261: -- vtariker - Check Whether record has been changed
262: OPEN C_Get_Update_Date(P_Qte_Header_Rec.Quote_Header_Id);

Line 265: IF aso_debug_pub.g_debug_flag = 'Y' THEN

261: -- vtariker - Check Whether record has been changed
262: OPEN C_Get_Update_Date(P_Qte_Header_Rec.Quote_Header_Id);
263: FETCH C_Get_Update_Date INTO l_last_upd_date;
264:
265: IF aso_debug_pub.g_debug_flag = 'Y' THEN
266: aso_debug_pub.add('Submit_Q: l_last_upd_date: '||l_last_upd_date, 1, 'N');
267: aso_debug_pub.add('Submit_Q: p_qte_header_rec.last_update_date: '||p_qte_header_rec.last_update_date, 1, 'N');
268: END IF;
269:

Line 266: aso_debug_pub.add('Submit_Q: l_last_upd_date: '||l_last_upd_date, 1, 'N');

262: OPEN C_Get_Update_Date(P_Qte_Header_Rec.Quote_Header_Id);
263: FETCH C_Get_Update_Date INTO l_last_upd_date;
264:
265: IF aso_debug_pub.g_debug_flag = 'Y' THEN
266: aso_debug_pub.add('Submit_Q: l_last_upd_date: '||l_last_upd_date, 1, 'N');
267: aso_debug_pub.add('Submit_Q: p_qte_header_rec.last_update_date: '||p_qte_header_rec.last_update_date, 1, 'N');
268: END IF;
269:
270: IF (C_Get_Update_Date%NOTFOUND) OR

Line 267: aso_debug_pub.add('Submit_Q: p_qte_header_rec.last_update_date: '||p_qte_header_rec.last_update_date, 1, 'N');

263: FETCH C_Get_Update_Date INTO l_last_upd_date;
264:
265: IF aso_debug_pub.g_debug_flag = 'Y' THEN
266: aso_debug_pub.add('Submit_Q: l_last_upd_date: '||l_last_upd_date, 1, 'N');
267: aso_debug_pub.add('Submit_Q: p_qte_header_rec.last_update_date: '||p_qte_header_rec.last_update_date, 1, 'N');
268: END IF;
269:
270: IF (C_Get_Update_Date%NOTFOUND) OR
271: (l_last_upd_date IS NULL OR l_last_upd_date = FND_API.G_MISS_DATE) THEN

Line 430: IF aso_debug_pub.g_debug_flag = 'Y' THEN

426: END IF;
427: RAISE FND_API.G_EXC_ERROR;
428: END IF;
429:
430: IF aso_debug_pub.g_debug_flag = 'Y' THEN
431: aso_debug_pub.add('Submit_Q: After validate_status_transition: ORDER SUBMITEED ', 1, 'N');
432: END IF;
433: -- end of hyang quote_status
434:

Line 431: aso_debug_pub.add('Submit_Q: After validate_status_transition: ORDER SUBMITEED ', 1, 'N');

427: RAISE FND_API.G_EXC_ERROR;
428: END IF;
429:
430: IF aso_debug_pub.g_debug_flag = 'Y' THEN
431: aso_debug_pub.add('Submit_Q: After validate_status_transition: ORDER SUBMITEED ', 1, 'N');
432: END IF;
433: -- end of hyang quote_status
434:
435: FOR count_main in c_line_relation(p_qte_header_rec.quote_header_id) LOOP

Line 454: IF aso_debug_pub.g_debug_flag = 'Y' THEN

450: l_hd_price_adj_tbl := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Hdr_Rows(
451: p_qte_header_id => p_qte_header_rec.quote_header_id,
452: p_qte_line_id => NULL);
453:
454: IF aso_debug_pub.g_debug_flag = 'Y' THEN
455: aso_debug_pub.add('Submit_Q: After hd_price_adj_tbl ', 1, 'N');
456: aso_debug_pub.add('Submit_Q: After l_hd_price_adj_tbl.count: '||l_hd_price_adj_tbl.count, 1, 'N');
457: END IF;
458:

Line 455: aso_debug_pub.add('Submit_Q: After hd_price_adj_tbl ', 1, 'N');

451: p_qte_header_id => p_qte_header_rec.quote_header_id,
452: p_qte_line_id => NULL);
453:
454: IF aso_debug_pub.g_debug_flag = 'Y' THEN
455: aso_debug_pub.add('Submit_Q: After hd_price_adj_tbl ', 1, 'N');
456: aso_debug_pub.add('Submit_Q: After l_hd_price_adj_tbl.count: '||l_hd_price_adj_tbl.count, 1, 'N');
457: END IF;
458:
459: -- pbh/prg

Line 456: aso_debug_pub.add('Submit_Q: After l_hd_price_adj_tbl.count: '||l_hd_price_adj_tbl.count, 1, 'N');

452: p_qte_line_id => NULL);
453:
454: IF aso_debug_pub.g_debug_flag = 'Y' THEN
455: aso_debug_pub.add('Submit_Q: After hd_price_adj_tbl ', 1, 'N');
456: aso_debug_pub.add('Submit_Q: After l_hd_price_adj_tbl.count: '||l_hd_price_adj_tbl.count, 1, 'N');
457: END IF;
458:
459: -- pbh/prg
460: l_hd_Price_Adj_Attr_Tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(

Line 463: IF aso_debug_pub.g_debug_flag = 'Y' THEN

459: -- pbh/prg
460: l_hd_Price_Adj_Attr_Tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(
461: p_price_adj_tbl => l_hd_price_adj_tbl);
462:
463: IF aso_debug_pub.g_debug_flag = 'Y' THEN
464: aso_debug_pub.add('vtariker: After l_hd_Price_Adj_Attr_Tbl.count: '||l_hd_Price_Adj_Attr_Tbl.count, 1, 'N');
465: END IF;
466: -- pbh/prg
467:

Line 464: aso_debug_pub.add('vtariker: After l_hd_Price_Adj_Attr_Tbl.count: '||l_hd_Price_Adj_Attr_Tbl.count, 1, 'N');

460: l_hd_Price_Adj_Attr_Tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(
461: p_price_adj_tbl => l_hd_price_adj_tbl);
462:
463: IF aso_debug_pub.g_debug_flag = 'Y' THEN
464: aso_debug_pub.add('vtariker: After l_hd_Price_Adj_Attr_Tbl.count: '||l_hd_Price_Adj_Attr_Tbl.count, 1, 'N');
465: END IF;
466: -- pbh/prg
467:
468: l_hd_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(

Line 498: IF aso_debug_pub.g_debug_flag = 'Y' THEN

494: l_hd_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(
495: p_qte_header_id => p_qte_header_rec.quote_header_id,
496: p_qte_line_id => NULL);
497:
498: IF aso_debug_pub.g_debug_flag = 'Y' THEN
499: aso_debug_pub.add('Submit_Q: After hd_shipment_tbl init ', 1, 'N');
500: END IF;
501:
502: l_hd_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(

Line 499: aso_debug_pub.add('Submit_Q: After hd_shipment_tbl init ', 1, 'N');

495: p_qte_header_id => p_qte_header_rec.quote_header_id,
496: p_qte_line_id => NULL);
497:
498: IF aso_debug_pub.g_debug_flag = 'Y' THEN
499: aso_debug_pub.add('Submit_Q: After hd_shipment_tbl init ', 1, 'N');
500: END IF;
501:
502: l_hd_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(
503: P_Shipment_Tbl => l_hd_shipment_tbl);

Line 515: aso_debug_pub.add('Submit_Quote - P_Control_Rec.application_type_code : ' || P_Control_Rec.application_type_code,1,'N');

511: p_qte_line_id => NULL) ;
512:
513:
514: /* Start : Code Change done for Bug 13391823 */
515: aso_debug_pub.add('Submit_Quote - P_Control_Rec.application_type_code : ' || P_Control_Rec.application_type_code,1,'N');
516:
517: If P_Control_Rec.application_type_code <> 'QUOTING FORM' Then
518:
519: /* End : Code Change done for Bug 13391823 */

Line 523: IF aso_debug_pub.g_debug_flag = 'Y' THEN

519: /* End : Code Change done for Bug 13391823 */
520:
521: /* ER 3177722 */
522: l_order_status_prof:=fnd_profile.value('ASO_DEFAULT_ORDER_STATE');
523: IF aso_debug_pub.g_debug_flag = 'Y' THEN
524: aso_debug_pub.add('Submit_Quote - l_order_status_prof: '||l_order_status_prof, 1, 'N');
525: END IF;
526: if l_order_status_prof='ENTERED' then
527: select count(*) into l_mdl_count

Line 524: aso_debug_pub.add('Submit_Quote - l_order_status_prof: '||l_order_status_prof, 1, 'N');

520:
521: /* ER 3177722 */
522: l_order_status_prof:=fnd_profile.value('ASO_DEFAULT_ORDER_STATE');
523: IF aso_debug_pub.g_debug_flag = 'Y' THEN
524: aso_debug_pub.add('Submit_Quote - l_order_status_prof: '||l_order_status_prof, 1, 'N');
525: END IF;
526: if l_order_status_prof='ENTERED' then
527: select count(*) into l_mdl_count
528: from aso_Quote_lines_all

Line 531: IF aso_debug_pub.g_debug_flag = 'Y' THEN

527: select count(*) into l_mdl_count
528: from aso_Quote_lines_all
529: where quote_header_id=p_qte_header_rec.quote_header_id
530: and item_type_code='MDL';
531: IF aso_debug_pub.g_debug_flag = 'Y' THEN
532: aso_debug_pub.add('Submit_Quote - mdl.count: '||to_char(l_mdl_count), 1, 'N');
533: END IF;
534:
535: if l_mdl_count>0 then

Line 532: aso_debug_pub.add('Submit_Quote - mdl.count: '||to_char(l_mdl_count), 1, 'N');

528: from aso_Quote_lines_all
529: where quote_header_id=p_qte_header_rec.quote_header_id
530: and item_type_code='MDL';
531: IF aso_debug_pub.g_debug_flag = 'Y' THEN
532: aso_debug_pub.add('Submit_Quote - mdl.count: '||to_char(l_mdl_count), 1, 'N');
533: END IF;
534:
535: if l_mdl_count>0 then
536:

Line 550: IF aso_debug_pub.g_debug_flag = 'Y' THEN

546: end if;-- l_update_allowed_flag
547:
548:
549:
550: IF aso_debug_pub.g_debug_flag = 'Y' THEN
551: aso_debug_pub.add('Submit_Quote - l_Update_Allowed_Flg: '||l_Update_Allowed_Flg, 1, 'N');
552:
553: END IF;
554: ASO_QUOTE_PUB.validate_model_configuration

Line 551: aso_debug_pub.add('Submit_Quote - l_Update_Allowed_Flg: '||l_Update_Allowed_Flg, 1, 'N');

547:
548:
549:
550: IF aso_debug_pub.g_debug_flag = 'Y' THEN
551: aso_debug_pub.add('Submit_Quote - l_Update_Allowed_Flg: '||l_Update_Allowed_Flg, 1, 'N');
552:
553: END IF;
554: ASO_QUOTE_PUB.validate_model_configuration
555: (

Line 569: IF aso_debug_pub.g_debug_flag = 'Y' THEN

565: X_Msg_Count => x_msg_count,
566: X_Msg_Data => x_msg_data
567: );
568:
569: IF aso_debug_pub.g_debug_flag = 'Y' THEN
570: aso_debug_pub.add('Submit_Quote -After ASO_QUOTE_PUB.validate_model_configuration return status: '||X_Return_Status, 1, 'N');
571: END IF;
572:
573: if (X_Return_Status = FND_API.G_RET_STS_SUCCESS) and (lx_config_tbl.count>0) then

Line 570: aso_debug_pub.add('Submit_Quote -After ASO_QUOTE_PUB.validate_model_configuration return status: '||X_Return_Status, 1, 'N');

566: X_Msg_Data => x_msg_data
567: );
568:
569: IF aso_debug_pub.g_debug_flag = 'Y' THEN
570: aso_debug_pub.add('Submit_Quote -After ASO_QUOTE_PUB.validate_model_configuration return status: '||X_Return_Status, 1, 'N');
571: END IF;
572:
573: if (X_Return_Status = FND_API.G_RET_STS_SUCCESS) and (lx_config_tbl.count>0) then
574:

Line 575: IF aso_debug_pub.g_debug_flag = 'Y' THEN

571: END IF;
572:
573: if (X_Return_Status = FND_API.G_RET_STS_SUCCESS) and (lx_config_tbl.count>0) then
574:
575: IF aso_debug_pub.g_debug_flag = 'Y' THEN
576: aso_debug_pub.add('Submit_Quote -After ASO_QUOTE_PUB.validate_model_configuration sucess lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
577: END IF;
578: l_ct_invalid:=0;
579: l_ct_changed:=0;

Line 576: aso_debug_pub.add('Submit_Quote -After ASO_QUOTE_PUB.validate_model_configuration sucess lx_config_tbl: '||lx_config_tbl.count, 1, 'N');

572:
573: if (X_Return_Status = FND_API.G_RET_STS_SUCCESS) and (lx_config_tbl.count>0) then
574:
575: IF aso_debug_pub.g_debug_flag = 'Y' THEN
576: aso_debug_pub.add('Submit_Quote -After ASO_QUOTE_PUB.validate_model_configuration sucess lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
577: END IF;
578: l_ct_invalid:=0;
579: l_ct_changed:=0;
580: for i in 1..lx_config_tbl.count loop

Line 596: IF aso_debug_pub.g_debug_flag = 'Y' THEN

592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
593: FND_MESSAGE.Set_Name('ASO', 'ASO_CHANGED_MODEL_LINES_REVIEW');
594: FND_MSG_PUB.ADD;
595: END IF;
596: IF aso_debug_pub.g_debug_flag = 'Y' THEN
597: aso_debug_pub.add('rassharm Submit_Quote -After ASO_QUOTE_PUB.validate_model_configuration sucess user defined exception: ', 1, 'N');
598: END IF;
599: RAISE l_warning_config_exception;
600:

Line 597: aso_debug_pub.add('rassharm Submit_Quote -After ASO_QUOTE_PUB.validate_model_configuration sucess user defined exception: ', 1, 'N');

593: FND_MESSAGE.Set_Name('ASO', 'ASO_CHANGED_MODEL_LINES_REVIEW');
594: FND_MSG_PUB.ADD;
595: END IF;
596: IF aso_debug_pub.g_debug_flag = 'Y' THEN
597: aso_debug_pub.add('rassharm Submit_Quote -After ASO_QUOTE_PUB.validate_model_configuration sucess user defined exception: ', 1, 'N');
598: END IF;
599: RAISE l_warning_config_exception;
600:
601:

Line 624: IF aso_debug_pub.g_debug_flag = 'Y' THEN

620: ASO_LINE_NUM_INT.RESET_LINE_NUM;
621:
622: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_Submit (p_qte_header_rec.quote_header_id);
623:
624: IF aso_debug_pub.g_debug_flag = 'Y' THEN
625: aso_debug_pub.add('Submit_Quote - qte_line_tbl.count: '||to_char(l_qte_line_tbl.count), 1, 'N');
626: END IF;
627:
628: FOR i IN 1..l_qte_line_tbl.count LOOP

Line 625: aso_debug_pub.add('Submit_Quote - qte_line_tbl.count: '||to_char(l_qte_line_tbl.count), 1, 'N');

621:
622: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_Submit (p_qte_header_rec.quote_header_id);
623:
624: IF aso_debug_pub.g_debug_flag = 'Y' THEN
625: aso_debug_pub.add('Submit_Quote - qte_line_tbl.count: '||to_char(l_qte_line_tbl.count), 1, 'N');
626: END IF;
627:
628: FOR i IN 1..l_qte_line_tbl.count LOOP
629: l_qte_line_id := l_qte_line_tbl(i).quote_line_id;

Line 631: IF aso_debug_pub.g_debug_flag = 'Y' THEN

627:
628: FOR i IN 1..l_qte_line_tbl.count LOOP
629: l_qte_line_id := l_qte_line_tbl(i).quote_line_id;
630:
631: IF aso_debug_pub.g_debug_flag = 'Y' THEN
632: aso_debug_pub.add('Submit_Quote - l_qte_line_id: '||l_qte_line_id, 1, 'N');
633: END IF;
634: -- 2469621 vtariker
635: IF l_qte_line_tbl(i).item_type_code = 'MDL' THEN

Line 632: aso_debug_pub.add('Submit_Quote - l_qte_line_id: '||l_qte_line_id, 1, 'N');

628: FOR i IN 1..l_qte_line_tbl.count LOOP
629: l_qte_line_id := l_qte_line_tbl(i).quote_line_id;
630:
631: IF aso_debug_pub.g_debug_flag = 'Y' THEN
632: aso_debug_pub.add('Submit_Quote - l_qte_line_id: '||l_qte_line_id, 1, 'N');
633: END IF;
634: -- 2469621 vtariker
635: IF l_qte_line_tbl(i).item_type_code = 'MDL' THEN
636:

Line 649: IF aso_debug_pub.g_debug_flag = 'Y' THEN

645: END IF;
646: CLOSE C_Get_Config_Flag;
647: RAISE FND_API.G_EXC_ERROR;
648: ELSE
649: IF aso_debug_pub.g_debug_flag = 'Y' THEN
650: aso_debug_pub.add('Submit_Quote - l_complete_config: '||l_complete_config, 1, 'N');
651: aso_debug_pub.add('Submit_Quote - l_valid_config: '||l_valid_config, 1, 'N');
652: aso_debug_pub.add('Submit_Quote - l_instance_id: '||l_instance_id, 1, 'N');
653: END IF;

Line 650: aso_debug_pub.add('Submit_Quote - l_complete_config: '||l_complete_config, 1, 'N');

646: CLOSE C_Get_Config_Flag;
647: RAISE FND_API.G_EXC_ERROR;
648: ELSE
649: IF aso_debug_pub.g_debug_flag = 'Y' THEN
650: aso_debug_pub.add('Submit_Quote - l_complete_config: '||l_complete_config, 1, 'N');
651: aso_debug_pub.add('Submit_Quote - l_valid_config: '||l_valid_config, 1, 'N');
652: aso_debug_pub.add('Submit_Quote - l_instance_id: '||l_instance_id, 1, 'N');
653: END IF;
654:

Line 651: aso_debug_pub.add('Submit_Quote - l_valid_config: '||l_valid_config, 1, 'N');

647: RAISE FND_API.G_EXC_ERROR;
648: ELSE
649: IF aso_debug_pub.g_debug_flag = 'Y' THEN
650: aso_debug_pub.add('Submit_Quote - l_complete_config: '||l_complete_config, 1, 'N');
651: aso_debug_pub.add('Submit_Quote - l_valid_config: '||l_valid_config, 1, 'N');
652: aso_debug_pub.add('Submit_Quote - l_instance_id: '||l_instance_id, 1, 'N');
653: END IF;
654:
655: IF (l_instance_id IS NULL) OR (l_instance_id = FND_API.G_MISS_NUM) THEN -- 2498776 vtariker

Line 652: aso_debug_pub.add('Submit_Quote - l_instance_id: '||l_instance_id, 1, 'N');

648: ELSE
649: IF aso_debug_pub.g_debug_flag = 'Y' THEN
650: aso_debug_pub.add('Submit_Quote - l_complete_config: '||l_complete_config, 1, 'N');
651: aso_debug_pub.add('Submit_Quote - l_valid_config: '||l_valid_config, 1, 'N');
652: aso_debug_pub.add('Submit_Quote - l_instance_id: '||l_instance_id, 1, 'N');
653: END IF;
654:
655: IF (l_instance_id IS NULL) OR (l_instance_id = FND_API.G_MISS_NUM) THEN -- 2498776 vtariker
656:

Line 720: IF aso_debug_pub.g_debug_flag = 'Y' THEN

716: -- pbh/prg
717: l_ln_price_adj_rltship_tbl
718: := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Rltship_Rows(
719: l_tmp_price_adj_tbl(j).price_adjustment_id, i, l_ln_price_adj_rltship_tbl);
720: IF aso_debug_pub.g_debug_flag = 'Y' THEN
721: aso_debug_pub.add('Submit_Q: After l_ln_Price_Adj_Rltship_tbl.count: '||l_ln_Price_Adj_Rltship_tbl.count, 1, 'N');
722: END IF;
723: -- pbh/prg
724:

Line 721: aso_debug_pub.add('Submit_Q: After l_ln_Price_Adj_Rltship_tbl.count: '||l_ln_Price_Adj_Rltship_tbl.count, 1, 'N');

717: l_ln_price_adj_rltship_tbl
718: := ASO_SUBMIT_QUOTE_PVT.Query_Price_Adj_Rltship_Rows(
719: l_tmp_price_adj_tbl(j).price_adjustment_id, i, l_ln_price_adj_rltship_tbl);
720: IF aso_debug_pub.g_debug_flag = 'Y' THEN
721: aso_debug_pub.add('Submit_Q: After l_ln_Price_Adj_Rltship_tbl.count: '||l_ln_Price_Adj_Rltship_tbl.count, 1, 'N');
722: END IF;
723: -- pbh/prg
724:
725: -- 2800749 vtariker

Line 749: IF aso_debug_pub.g_debug_flag = 'Y' THEN

745: l_tmp_payment_tbl(j).payment_term_id := FND_API.G_MISS_NUM;
746: end if;
747: end if;
748: l_ln_payment_tbl(l_index) := l_tmp_payment_tbl(j);
749: IF aso_debug_pub.g_debug_flag = 'Y' THEN
750: aso_debug_pub.add('Submit_Q: l_tmp_payment_tbl:l_index '||l_index, 1, 'N');
751: aso_debug_pub.add('Submit_Q: l_tmp_payment_tbl(j).qte_line_index '||l_tmp_payment_tbl(j).qte_line_index, 1, 'N');
752: END IF;
753:

Line 750: aso_debug_pub.add('Submit_Q: l_tmp_payment_tbl:l_index '||l_index, 1, 'N');

746: end if;
747: end if;
748: l_ln_payment_tbl(l_index) := l_tmp_payment_tbl(j);
749: IF aso_debug_pub.g_debug_flag = 'Y' THEN
750: aso_debug_pub.add('Submit_Q: l_tmp_payment_tbl:l_index '||l_index, 1, 'N');
751: aso_debug_pub.add('Submit_Q: l_tmp_payment_tbl(j).qte_line_index '||l_tmp_payment_tbl(j).qte_line_index, 1, 'N');
752: END IF;
753:
754: -- l_index := l_index+1;

Line 751: aso_debug_pub.add('Submit_Q: l_tmp_payment_tbl(j).qte_line_index '||l_tmp_payment_tbl(j).qte_line_index, 1, 'N');

747: end if;
748: l_ln_payment_tbl(l_index) := l_tmp_payment_tbl(j);
749: IF aso_debug_pub.g_debug_flag = 'Y' THEN
750: aso_debug_pub.add('Submit_Q: l_tmp_payment_tbl:l_index '||l_index, 1, 'N');
751: aso_debug_pub.add('Submit_Q: l_tmp_payment_tbl(j).qte_line_index '||l_tmp_payment_tbl(j).qte_line_index, 1, 'N');
752: END IF;
753:
754: -- l_index := l_index+1;
755: END LOOP;

Line 790: aso_debug_pub.add('vtariker: l_ln_Price_Adj_Attr_Tbl.count: '||l_ln_Price_Adj_Attr_Tbl.count, 1, 'N');

786: END LOOP; -- Line_Tbl loop
787:
788: -- pbh/prg
789: l_ln_Price_Adj_Attr_Tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(l_ln_price_adj_tbl);
790: aso_debug_pub.add('vtariker: l_ln_Price_Adj_Attr_Tbl.count: '||l_ln_Price_Adj_Attr_Tbl.count, 1, 'N');
791: -- pbh/prg
792:
793: /*** Will not be required after CC condolidation
794: OPEN C_check_pymnt_type(p_qte_header_rec.quote_header_id);

Line 803: IF aso_debug_pub.g_debug_flag = 'Y' THEN

799: EXIT;
800: END IF;
801:
802: IF l_payment_type_code = 'CREDIT_CARD' THEN
803: IF aso_debug_pub.g_debug_flag = 'Y' THEN
804: aso_debug_pub.add('Submit_Quote - payment_type is CC ', 1, 'N');
805: END IF;
806:
807: IF NVL(FND_PROFILE.Value('ASO_CC_AUTHORIZATION_ENABLED'), 'N') = 'Y' THEN

Line 804: aso_debug_pub.add('Submit_Quote - payment_type is CC ', 1, 'N');

800: END IF;
801:
802: IF l_payment_type_code = 'CREDIT_CARD' THEN
803: IF aso_debug_pub.g_debug_flag = 'Y' THEN
804: aso_debug_pub.add('Submit_Quote - payment_type is CC ', 1, 'N');
805: END IF;
806:
807: IF NVL(FND_PROFILE.Value('ASO_CC_AUTHORIZATION_ENABLED'), 'N') = 'Y' THEN
808: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 808: IF aso_debug_pub.g_debug_flag = 'Y' THEN

804: aso_debug_pub.add('Submit_Quote - payment_type is CC ', 1, 'N');
805: END IF;
806:
807: IF NVL(FND_PROFILE.Value('ASO_CC_AUTHORIZATION_ENABLED'), 'N') = 'Y' THEN
808: IF aso_debug_pub.g_debug_flag = 'Y' THEN
809: aso_debug_pub.add('Submit_Q: CC_Authorization_enabled ', 1, 'N');
810: END IF;
811:
812: IF p_control_rec.CVV2 IS NOT NULL AND p_control_rec.CVV2 <> FND_API.G_MISS_CHAR THEN

Line 809: aso_debug_pub.add('Submit_Q: CC_Authorization_enabled ', 1, 'N');

805: END IF;
806:
807: IF NVL(FND_PROFILE.Value('ASO_CC_AUTHORIZATION_ENABLED'), 'N') = 'Y' THEN
808: IF aso_debug_pub.g_debug_flag = 'Y' THEN
809: aso_debug_pub.add('Submit_Q: CC_Authorization_enabled ', 1, 'N');
810: END IF;
811:
812: IF p_control_rec.CVV2 IS NOT NULL AND p_control_rec.CVV2 <> FND_API.G_MISS_CHAR THEN
813:

Line 814: IF aso_debug_pub.g_debug_flag = 'Y' THEN

810: END IF;
811:
812: IF p_control_rec.CVV2 IS NOT NULL AND p_control_rec.CVV2 <> FND_API.G_MISS_CHAR THEN
813:
814: IF aso_debug_pub.g_debug_flag = 'Y' THEN
815: aso_debug_pub.add('Submit_Q: Before Authorize_payment p_control_rec.CVV2: '|| p_control_rec.CVV2, 1, 'N');
816: END IF;
817: FOR i in 1..l_hd_payment_tbl.count LOOP
818: l_hd_payment_tbl(i).CVV2 := p_control_rec.CVV2;

Line 815: aso_debug_pub.add('Submit_Q: Before Authorize_payment p_control_rec.CVV2: '|| p_control_rec.CVV2, 1, 'N');

811:
812: IF p_control_rec.CVV2 IS NOT NULL AND p_control_rec.CVV2 <> FND_API.G_MISS_CHAR THEN
813:
814: IF aso_debug_pub.g_debug_flag = 'Y' THEN
815: aso_debug_pub.add('Submit_Q: Before Authorize_payment p_control_rec.CVV2: '|| p_control_rec.CVV2, 1, 'N');
816: END IF;
817: FOR i in 1..l_hd_payment_tbl.count LOOP
818: l_hd_payment_tbl(i).CVV2 := p_control_rec.CVV2;
819: END LOOP;

Line 834: IF aso_debug_pub.g_debug_flag = 'Y' THEN

830: X_Msg_Data => X_Msg_Data );
831:
832: l_hd_payment_tbl := l_hd_payment_tbl_out;
833:
834: IF aso_debug_pub.g_debug_flag = 'Y' THEN
835: aso_debug_pub.add('Submit_Q: After Authorize_payment x_return_status: '|| x_return_status, 1, 'N');
836: END IF;
837: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
838: RAISE FND_API.G_EXC_ERROR;

Line 835: aso_debug_pub.add('Submit_Q: After Authorize_payment x_return_status: '|| x_return_status, 1, 'N');

831:
832: l_hd_payment_tbl := l_hd_payment_tbl_out;
833:
834: IF aso_debug_pub.g_debug_flag = 'Y' THEN
835: aso_debug_pub.add('Submit_Q: After Authorize_payment x_return_status: '|| x_return_status, 1, 'N');
836: END IF;
837: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
838: RAISE FND_API.G_EXC_ERROR;
839: END IF;

Line 853: IF aso_debug_pub.g_debug_flag = 'Y' THEN

849: OPEN C_Check_Qte_Status (l_qte_header_rec.quote_header_id);
850: FETCH C_Check_Qte_Status INTO l_istore_source;
851: CLOSE C_Check_Qte_Status;
852:
853: IF aso_debug_pub.g_debug_flag = 'Y' THEN
854: aso_debug_pub.add('Submit_Q: Before Assign_Team: l_qte_header_rec.resource_id: ' || l_qte_header_rec.resource_id, 1, 'Y');
855: aso_debug_pub.add('Submit_Q: Before Assign_Team: l_istore_source: ' || l_istore_source, 1, 'Y');
856: END IF;
857:

Line 854: aso_debug_pub.add('Submit_Q: Before Assign_Team: l_qte_header_rec.resource_id: ' || l_qte_header_rec.resource_id, 1, 'Y');

850: FETCH C_Check_Qte_Status INTO l_istore_source;
851: CLOSE C_Check_Qte_Status;
852:
853: IF aso_debug_pub.g_debug_flag = 'Y' THEN
854: aso_debug_pub.add('Submit_Q: Before Assign_Team: l_qte_header_rec.resource_id: ' || l_qte_header_rec.resource_id, 1, 'Y');
855: aso_debug_pub.add('Submit_Q: Before Assign_Team: l_istore_source: ' || l_istore_source, 1, 'Y');
856: END IF;
857:
858: IF l_istore_source <> 'Y' OR (l_istore_source = 'Y' AND

Line 855: aso_debug_pub.add('Submit_Q: Before Assign_Team: l_istore_source: ' || l_istore_source, 1, 'Y');

851: CLOSE C_Check_Qte_Status;
852:
853: IF aso_debug_pub.g_debug_flag = 'Y' THEN
854: aso_debug_pub.add('Submit_Q: Before Assign_Team: l_qte_header_rec.resource_id: ' || l_qte_header_rec.resource_id, 1, 'Y');
855: aso_debug_pub.add('Submit_Q: Before Assign_Team: l_istore_source: ' || l_istore_source, 1, 'Y');
856: END IF;
857:
858: IF l_istore_source <> 'Y' OR (l_istore_source = 'Y' AND
859: (l_qte_header_rec.resource_id IS NOT NULL AND l_qte_header_rec.resource_id <> FND_API.G_MISS_NUM)) THEN

Line 932: IF aso_debug_pub.g_debug_flag = 'Y' THEN

928: FETCH C_payment_amount into l_payment_amount;
929: CLOSE C_payment_amount;
930:
931: l_Qte_Header_Rec.payment_amount := l_payment_amount;
932: IF aso_debug_pub.g_debug_flag = 'Y' THEN
933: aso_debug_pub.add('Submit_Quote - before create_order l_payment_amount: '||l_payment_amount, 1, 'Y');
934: END IF;
935:
936: ASO_ORDER_INT.Create_order(

Line 933: aso_debug_pub.add('Submit_Quote - before create_order l_payment_amount: '||l_payment_amount, 1, 'Y');

929: CLOSE C_payment_amount;
930:
931: l_Qte_Header_Rec.payment_amount := l_payment_amount;
932: IF aso_debug_pub.g_debug_flag = 'Y' THEN
933: aso_debug_pub.add('Submit_Quote - before create_order l_payment_amount: '||l_payment_amount, 1, 'Y');
934: END IF;
935:
936: ASO_ORDER_INT.Create_order(
937: P_Api_Version => 1.0,

Line 973: IF aso_debug_pub.g_debug_flag = 'Y' THEN

969: X_Order_Line_Tbl => lx_Order_Line_Tbl,
970: X_Return_Status => X_Return_Status,
971: X_Msg_Count => X_Msg_Count,
972: X_Msg_Data => X_Msg_Data);
973: IF aso_debug_pub.g_debug_flag = 'Y' THEN
974: aso_debug_pub.add('Submit_Q: After Create_Order x_return_status: '||x_return_status, 1, 'N');
975: END IF;
976: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
977: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 974: aso_debug_pub.add('Submit_Q: After Create_Order x_return_status: '||x_return_status, 1, 'N');

970: X_Return_Status => X_Return_Status,
971: X_Msg_Count => X_Msg_Count,
972: X_Msg_Data => X_Msg_Data);
973: IF aso_debug_pub.g_debug_flag = 'Y' THEN
974: aso_debug_pub.add('Submit_Q: After Create_Order x_return_status: '||x_return_status, 1, 'N');
975: END IF;
976: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
977: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
978: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_ORDERING');

Line 994: IF aso_debug_pub.g_debug_flag = 'Y' THEN

990: -- is not booked. We raise an error in case the order is not booked.
991: /** Bug# 4045135. Removing this check since deferred scheduling may book orders at a later stage.
992: IF x_return_status = FND_API.G_RET_STS_SUCCESS
993: AND l_order_control_rec.BOOK_FLAG = FND_API.G_TRUE THEN
994: IF aso_debug_pub.g_debug_flag = 'Y' THEN
995: aso_debug_pub.add('Submit_Q: After create_order Success and Book_flag = true ', 1, 'N');
996: END IF;
997: OPEN C_book_flag;
998: FETCH C_book_flag into l_book_flag;

Line 995: aso_debug_pub.add('Submit_Q: After create_order Success and Book_flag = true ', 1, 'N');

991: /** Bug# 4045135. Removing this check since deferred scheduling may book orders at a later stage.
992: IF x_return_status = FND_API.G_RET_STS_SUCCESS
993: AND l_order_control_rec.BOOK_FLAG = FND_API.G_TRUE THEN
994: IF aso_debug_pub.g_debug_flag = 'Y' THEN
995: aso_debug_pub.add('Submit_Q: After create_order Success and Book_flag = true ', 1, 'N');
996: END IF;
997: OPEN C_book_flag;
998: FETCH C_book_flag into l_book_flag;
999: IF C_book_flag%NOTFOUND THEN

Line 1010: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1006: END IF;
1007: **/
1008:
1009: -- EDU
1010: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1011: aso_debug_pub.add('Submit_Quote - before ASO_EDUCATION_INT.Update_OTA_With_OrderLine ', 1, 'N');
1012: END IF;
1013: ASO_EDUCATION_INT.Update_OTA_With_OrderLine(
1014: P_Init_Msg_List => FND_API.G_FALSE,

Line 1011: aso_debug_pub.add('Submit_Quote - before ASO_EDUCATION_INT.Update_OTA_With_OrderLine ', 1, 'N');

1007: **/
1008:
1009: -- EDU
1010: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1011: aso_debug_pub.add('Submit_Quote - before ASO_EDUCATION_INT.Update_OTA_With_OrderLine ', 1, 'N');
1012: END IF;
1013: ASO_EDUCATION_INT.Update_OTA_With_OrderLine(
1014: P_Init_Msg_List => FND_API.G_FALSE,
1015: P_Commit => FND_API.G_FALSE,

Line 1020: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1016: P_Order_Line_Tbl => lx_order_line_tbl,
1017: X_Return_Status => x_return_status,
1018: X_Msg_Count => x_msg_count,
1019: X_Msg_Data => x_msg_data);
1020: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1021: aso_debug_pub.add('Submit_Quote - after ASO_EDUCATION_INT.Update_OTA_With_OrderLine: '||x_return_status, 1, 'N');
1022: END IF;
1023: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1024: RAISE FND_API.G_EXC_ERROR;

Line 1021: aso_debug_pub.add('Submit_Quote - after ASO_EDUCATION_INT.Update_OTA_With_OrderLine: '||x_return_status, 1, 'N');

1017: X_Return_Status => x_return_status,
1018: X_Msg_Count => x_msg_count,
1019: X_Msg_Data => x_msg_data);
1020: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1021: aso_debug_pub.add('Submit_Quote - after ASO_EDUCATION_INT.Update_OTA_With_OrderLine: '||x_return_status, 1, 'N');
1022: END IF;
1023: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1024: RAISE FND_API.G_EXC_ERROR;
1025: END IF;

Line 1054: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1050: X_MSG_COUNT => X_MSG_COUNT ,
1051: X_MSG_DATA => X_MSG_DATA
1052: );
1053:
1054: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1055: aso_debug_pub.add('Submit_Q: After Create_Related_Obj x_return_status: '||x_return_status, 1, 'N');
1056: END IF;
1057: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1058: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1055: aso_debug_pub.add('Submit_Q: After Create_Related_Obj x_return_status: '||x_return_status, 1, 'N');

1051: X_MSG_DATA => X_MSG_DATA
1052: );
1053:
1054: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1055: aso_debug_pub.add('Submit_Q: After Create_Related_Obj x_return_status: '||x_return_status, 1, 'N');
1056: END IF;
1057: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1058: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1059: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_CREATE_RLTN');

Line 1114: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1110: P_Order_Line_Id => lx_order_line_tbl(i).order_line_id,
1111: X_Return_Status => x_Return_Status,
1112: X_Msg_Count => X_Msg_Count,
1113: X_Msg_Data => X_Msg_Data );
1114: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1115: aso_debug_pub.add('Submit_Q: After Update_Inst_Details x_return_status: '||x_return_status, 1, 'N');
1116: END IF;
1117: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1118: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1115: aso_debug_pub.add('Submit_Q: After Update_Inst_Details x_return_status: '||x_return_status, 1, 'N');

1111: X_Return_Status => x_Return_Status,
1112: X_Msg_Count => X_Msg_Count,
1113: X_Msg_Data => X_Msg_Data );
1114: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1115: aso_debug_pub.add('Submit_Q: After Update_Inst_Details x_return_status: '||x_return_status, 1, 'N');
1116: END IF;
1117: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1118: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1119: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_UPDATE_INST');

Line 1147: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1143: X_Return_Status => x_Return_Status,
1144: X_Msg_Count => X_Msg_Count,
1145: X_Msg_Data => X_Msg_Data,
1146: X_new_RESERVATION_ID => l_reservation_id);
1147: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1148: aso_debug_pub.add('Submit_Q: After Transfer_Reservation x_return_status: '||x_return_status, 1, 'N');
1149: END IF;
1150: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1151: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1148: aso_debug_pub.add('Submit_Q: After Transfer_Reservation x_return_status: '||x_return_status, 1, 'N');

1144: X_Msg_Count => X_Msg_Count,
1145: X_Msg_Data => X_Msg_Data,
1146: X_new_RESERVATION_ID => l_reservation_id);
1147: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1148: aso_debug_pub.add('Submit_Q: After Transfer_Reservation x_return_status: '||x_return_status, 1, 'N');
1149: END IF;
1150: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1151: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1152: FND_MESSAGE.Set_Name('ASO', 'ASO_API_ERROR_IN_TRANS_RSV');

Line 1164: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1160: END IF;
1161: END IF;
1162: END IF;
1163: END LOOP; -- lx_order_line_tbl
1164: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1165: aso_debug_pub.add('Submit_Q: After lx_order_line_tbl loop x_return_status: '||x_return_status, 1, 'N');
1166: END IF;
1167:
1168:

Line 1165: aso_debug_pub.add('Submit_Q: After lx_order_line_tbl loop x_return_status: '||x_return_status, 1, 'N');

1161: END IF;
1162: END IF;
1163: END LOOP; -- lx_order_line_tbl
1164: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1165: aso_debug_pub.add('Submit_Q: After lx_order_line_tbl loop x_return_status: '||x_return_status, 1, 'N');
1166: END IF;
1167:
1168:
1169: -- lx_return_status := x_return_status -- 1966456

Line 1182: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1178: ,x_return_status => x_return_status
1179: ,x_msg_count => x_msg_count
1180: ,x_msg_data => x_msg_data
1181: );
1182: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1183: aso_debug_pub.add('Submit_Q: After Copy_Attachments_to_order x_return_status: '||x_return_status, 1, 'N');
1184: END IF;
1185: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1186: RAISE FND_API.G_EXC_ERROR;

Line 1183: aso_debug_pub.add('Submit_Q: After Copy_Attachments_to_order x_return_status: '||x_return_status, 1, 'N');

1179: ,x_msg_count => x_msg_count
1180: ,x_msg_data => x_msg_data
1181: );
1182: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1183: aso_debug_pub.add('Submit_Q: After Copy_Attachments_to_order x_return_status: '||x_return_status, 1, 'N');
1184: END IF;
1185: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1186: RAISE FND_API.G_EXC_ERROR;
1187: END if;

Line 1196: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1192: -- x_return_status := lx_return_status; -- 1966456
1193:
1194: -- Changes for High Availability
1195:
1196: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1197: aso_debug_pub.add('Submit_Q: HA Test 10 ', 1, 'N');
1198: END IF;
1199:
1200: JTF_HA_STATE_PKG.GET_CURRENT_STATE (

Line 1197: aso_debug_pub.add('Submit_Q: HA Test 10 ', 1, 'N');

1193:
1194: -- Changes for High Availability
1195:
1196: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1197: aso_debug_pub.add('Submit_Q: HA Test 10 ', 1, 'N');
1198: END IF;
1199:
1200: JTF_HA_STATE_PKG.GET_CURRENT_STATE (
1201: X_CURRENT_STATE => X_Current_State,

Line 1204: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1200: JTF_HA_STATE_PKG.GET_CURRENT_STATE (
1201: X_CURRENT_STATE => X_Current_State,
1202: X_RETURN_STATUS => X_Return_Status);
1203:
1204: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1205: aso_debug_pub.add('Submit_Q: After JTF_HA_STATE_PKG.GET_CURRENT_STATE x_return_status: '||x_return_status, 1, 'N');
1206: END IF;
1207: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN
1208:

Line 1205: aso_debug_pub.add('Submit_Q: After JTF_HA_STATE_PKG.GET_CURRENT_STATE x_return_status: '||x_return_status, 1, 'N');

1201: X_CURRENT_STATE => X_Current_State,
1202: X_RETURN_STATUS => X_Return_Status);
1203:
1204: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1205: aso_debug_pub.add('Submit_Q: After JTF_HA_STATE_PKG.GET_CURRENT_STATE x_return_status: '||x_return_status, 1, 'N');
1206: END IF;
1207: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN
1208:
1209: IF X_Current_State IN (3,4) THEN

Line 1211: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1207: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN
1208:
1209: IF X_Current_State IN (3,4) THEN
1210:
1211: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1212: aso_debug_pub.add('Submit_Q: In HA: X_Current_State: '||X_Current_State, 1, 'N');
1213: END IF;
1214: ROLLBACK TO SUBMIT_QUOTE_PVT;
1215:

Line 1212: aso_debug_pub.add('Submit_Q: In HA: X_Current_State: '||X_Current_State, 1, 'N');

1208:
1209: IF X_Current_State IN (3,4) THEN
1210:
1211: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1212: aso_debug_pub.add('Submit_Q: In HA: X_Current_State: '||X_Current_State, 1, 'N');
1213: END IF;
1214: ROLLBACK TO SUBMIT_QUOTE_PVT;
1215:
1216: ASO_SUBMIT_QUOTE_PVT.Raise_Quote_Event (

Line 1221: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1217: P_Quote_Header_Id => p_qte_header_rec.quote_header_id,
1218: P_Control_Rec => p_control_rec,
1219: X_Return_Status => x_return_status );
1220:
1221: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1222: aso_debug_pub.add('Submit_Q: Raise_Quote_Event: X_Current_State: '||X_Current_State, 1, 'N');
1223: END IF;
1224: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN
1225:

Line 1222: aso_debug_pub.add('Submit_Q: Raise_Quote_Event: X_Current_State: '||X_Current_State, 1, 'N');

1218: P_Control_Rec => p_control_rec,
1219: X_Return_Status => x_return_status );
1220:
1221: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1222: aso_debug_pub.add('Submit_Q: Raise_Quote_Event: X_Current_State: '||X_Current_State, 1, 'N');
1223: END IF;
1224: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN
1225:
1226: UPDATE ASO_QUOTE_HEADERS_ALL

Line 1243: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1239:
1240: END IF;
1241: -- HA
1242:
1243: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1244: aso_debug_pub.add('Submit_Q: End of submit_quote x_return_status: '||x_return_status, 1, 'N');
1245: END IF;
1246:
1247: -- Debug Message

Line 1244: aso_debug_pub.add('Submit_Q: End of submit_quote x_return_status: '||x_return_status, 1, 'N');

1240: END IF;
1241: -- HA
1242:
1243: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1244: aso_debug_pub.add('Submit_Q: End of submit_quote x_return_status: '||x_return_status, 1, 'N');
1245: END IF;
1246:
1247: -- Debug Message
1248: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 1318: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1314: WHEN l_warning_config_exception THEN
1315:
1316: Begin
1317: COMMIT WORK;
1318: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1319: aso_debug_pub.add('Submit_Quote: Commited configuration data End of submit_quote in User defined exception block l_warning_config_exception ', 1, 'N');
1320: END IF;
1321: Exception
1322: WHEN NO_DATA_FOUND THEN

Line 1319: aso_debug_pub.add('Submit_Quote: Commited configuration data End of submit_quote in User defined exception block l_warning_config_exception ', 1, 'N');

1315:
1316: Begin
1317: COMMIT WORK;
1318: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1319: aso_debug_pub.add('Submit_Quote: Commited configuration data End of submit_quote in User defined exception block l_warning_config_exception ', 1, 'N');
1320: END IF;
1321: Exception
1322: WHEN NO_DATA_FOUND THEN
1323: NULL;

Line 1333: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1329: ( p_count => x_msg_count,
1330: p_data => x_msg_data
1331: );
1332:
1333: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1334: aso_debug_pub.add('Submit_Quote: End of submit_quote in User defined exception block l_warning_config_exception ', 1, 'N');
1335: END IF;
1336:
1337:

Line 1334: aso_debug_pub.add('Submit_Quote: End of submit_quote in User defined exception block l_warning_config_exception ', 1, 'N');

1330: p_data => x_msg_data
1331: );
1332:
1333: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1334: aso_debug_pub.add('Submit_Quote: End of submit_quote in User defined exception block l_warning_config_exception ', 1, 'N');
1335: END IF;
1336:
1337:
1338: WHEN OTHERS THEN

Line 1475: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1471: BEGIN
1472: --Fix for bug 5714535. Setting the output table structure directly instead of
1473: --setting it through the local record structure.
1474:
1475: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1476: aso_debug_pub.add('Begin ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows', 1, 'N');
1477: END IF;
1478:
1479: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN

Line 1476: aso_debug_pub.add('Begin ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows', 1, 'N');

1472: --Fix for bug 5714535. Setting the output table structure directly instead of
1473: --setting it through the local record structure.
1474:
1475: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1476: aso_debug_pub.add('Begin ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows', 1, 'N');
1477: END IF;
1478:
1479: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
1480:

Line 1483: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1479: IF P_Qte_Line_Id is NULL or P_Qte_Line_Id = FND_API.G_MISS_NUM THEN
1480:
1481: FOR tax_rec IN c_tax1 LOOP
1482: l_tax_det_count := lx_tax_detail_tbl.COUNT+1;
1483: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1484: aso_debug_pub.add('Query_Tax_Detail_Rows - l_tax_det_count: ' || l_tax_det_count, 1, 'N');
1485: END IF;
1486:
1487: lx_tax_detail_tbl(l_tax_det_count).TAX_DETAIL_ID := tax_rec.TAX_DETAIL_ID;

Line 1484: aso_debug_pub.add('Query_Tax_Detail_Rows - l_tax_det_count: ' || l_tax_det_count, 1, 'N');

1480:
1481: FOR tax_rec IN c_tax1 LOOP
1482: l_tax_det_count := lx_tax_detail_tbl.COUNT+1;
1483: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1484: aso_debug_pub.add('Query_Tax_Detail_Rows - l_tax_det_count: ' || l_tax_det_count, 1, 'N');
1485: END IF;
1486:
1487: lx_tax_detail_tbl(l_tax_det_count).TAX_DETAIL_ID := tax_rec.TAX_DETAIL_ID;
1488: lx_tax_detail_tbl(l_tax_det_count).CREATION_DATE := tax_rec.CREATION_DATE;

Line 1577: IF aso_debug_pub.g_debug_flag = 'Y' THEN

1573: -- lx_tax_detail_tbl(lx_tax_detail_tbl.COUNT+1) := l_tax_detail_rec;
1574: END LOOP;
1575: END IF;
1576:
1577: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1578: aso_debug_pub.add('ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows - end', 1, 'N');
1579: END IF;
1580: RETURN lx_tax_detail_tbl;
1581: END Query_Tax_Detail_Rows;

Line 1578: aso_debug_pub.add('ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows - end', 1, 'N');

1574: END LOOP;
1575: END IF;
1576:
1577: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1578: aso_debug_pub.add('ASO_SUBMIT_QUOTE_PVT.Query_Tax_Detail_Rows - end', 1, 'N');
1579: END IF;
1580: RETURN lx_tax_detail_tbl;
1581: END Query_Tax_Detail_Rows;
1582:

Line 3578: IF aso_debug_pub.g_debug_flag = 'Y' THEN

3574: l_Event wf_event_t;
3575:
3576: BEGIN
3577:
3578: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3579: aso_debug_pub.add('Raise_Quote_Event: P_Quote_Header_id: '||P_Quote_Header_id, 1, 'N');
3580: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Calculate_Price: '||P_Control_Rec.Calculate_Price, 1, 'N');
3581: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Book_Flag: '||P_Control_Rec.Book_Flag, 1, 'N');
3582: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Server_Id: '||P_Control_Rec.Server_Id, 1, 'N');

Line 3579: aso_debug_pub.add('Raise_Quote_Event: P_Quote_Header_id: '||P_Quote_Header_id, 1, 'N');

3575:
3576: BEGIN
3577:
3578: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3579: aso_debug_pub.add('Raise_Quote_Event: P_Quote_Header_id: '||P_Quote_Header_id, 1, 'N');
3580: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Calculate_Price: '||P_Control_Rec.Calculate_Price, 1, 'N');
3581: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Book_Flag: '||P_Control_Rec.Book_Flag, 1, 'N');
3582: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Server_Id: '||P_Control_Rec.Server_Id, 1, 'N');
3583: END IF;

Line 3580: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Calculate_Price: '||P_Control_Rec.Calculate_Price, 1, 'N');

3576: BEGIN
3577:
3578: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3579: aso_debug_pub.add('Raise_Quote_Event: P_Quote_Header_id: '||P_Quote_Header_id, 1, 'N');
3580: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Calculate_Price: '||P_Control_Rec.Calculate_Price, 1, 'N');
3581: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Book_Flag: '||P_Control_Rec.Book_Flag, 1, 'N');
3582: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Server_Id: '||P_Control_Rec.Server_Id, 1, 'N');
3583: END IF;
3584:

Line 3581: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Book_Flag: '||P_Control_Rec.Book_Flag, 1, 'N');

3577:
3578: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3579: aso_debug_pub.add('Raise_Quote_Event: P_Quote_Header_id: '||P_Quote_Header_id, 1, 'N');
3580: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Calculate_Price: '||P_Control_Rec.Calculate_Price, 1, 'N');
3581: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Book_Flag: '||P_Control_Rec.Book_Flag, 1, 'N');
3582: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Server_Id: '||P_Control_Rec.Server_Id, 1, 'N');
3583: END IF;
3584:
3585: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line 3582: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Server_Id: '||P_Control_Rec.Server_Id, 1, 'N');

3578: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3579: aso_debug_pub.add('Raise_Quote_Event: P_Quote_Header_id: '||P_Quote_Header_id, 1, 'N');
3580: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Calculate_Price: '||P_Control_Rec.Calculate_Price, 1, 'N');
3581: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Book_Flag: '||P_Control_Rec.Book_Flag, 1, 'N');
3582: aso_debug_pub.add('Raise_Quote_Event: P_Control_Rec.Server_Id: '||P_Control_Rec.Server_Id, 1, 'N');
3583: END IF;
3584:
3585: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
3586:

Line 3647: IF aso_debug_pub.g_debug_flag = 'Y' THEN

3643: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
3644:
3645: BEGIN
3646:
3647: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3648: aso_debug_pub.add('Quote_Order_High_Availability: P_Quote_Header_id: '||P_Quote_Header_id, 1, 'N');
3649: aso_debug_pub.add('Quote_Order_High_Availability: P_Book_Flag: '||P_Book_Flag, 1, 'N');
3650: aso_debug_pub.add('Quote_Order_High_Availability: P_Calculate_Flag: '||P_Calculate_Flag, 1, 'N');
3651: aso_debug_pub.add('Quote_Order_High_Availability: P_Server_Id: '||P_Server_Id, 1, 'N');

Line 3648: aso_debug_pub.add('Quote_Order_High_Availability: P_Quote_Header_id: '||P_Quote_Header_id, 1, 'N');

3644:
3645: BEGIN
3646:
3647: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3648: aso_debug_pub.add('Quote_Order_High_Availability: P_Quote_Header_id: '||P_Quote_Header_id, 1, 'N');
3649: aso_debug_pub.add('Quote_Order_High_Availability: P_Book_Flag: '||P_Book_Flag, 1, 'N');
3650: aso_debug_pub.add('Quote_Order_High_Availability: P_Calculate_Flag: '||P_Calculate_Flag, 1, 'N');
3651: aso_debug_pub.add('Quote_Order_High_Availability: P_Server_Id: '||P_Server_Id, 1, 'N');
3652: END IF;

Line 3649: aso_debug_pub.add('Quote_Order_High_Availability: P_Book_Flag: '||P_Book_Flag, 1, 'N');

3645: BEGIN
3646:
3647: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3648: aso_debug_pub.add('Quote_Order_High_Availability: P_Quote_Header_id: '||P_Quote_Header_id, 1, 'N');
3649: aso_debug_pub.add('Quote_Order_High_Availability: P_Book_Flag: '||P_Book_Flag, 1, 'N');
3650: aso_debug_pub.add('Quote_Order_High_Availability: P_Calculate_Flag: '||P_Calculate_Flag, 1, 'N');
3651: aso_debug_pub.add('Quote_Order_High_Availability: P_Server_Id: '||P_Server_Id, 1, 'N');
3652: END IF;
3653:

Line 3650: aso_debug_pub.add('Quote_Order_High_Availability: P_Calculate_Flag: '||P_Calculate_Flag, 1, 'N');

3646:
3647: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3648: aso_debug_pub.add('Quote_Order_High_Availability: P_Quote_Header_id: '||P_Quote_Header_id, 1, 'N');
3649: aso_debug_pub.add('Quote_Order_High_Availability: P_Book_Flag: '||P_Book_Flag, 1, 'N');
3650: aso_debug_pub.add('Quote_Order_High_Availability: P_Calculate_Flag: '||P_Calculate_Flag, 1, 'N');
3651: aso_debug_pub.add('Quote_Order_High_Availability: P_Server_Id: '||P_Server_Id, 1, 'N');
3652: END IF;
3653:
3654: l_Control_Rec.Book_Flag := P_Book_Flag;

Line 3651: aso_debug_pub.add('Quote_Order_High_Availability: P_Server_Id: '||P_Server_Id, 1, 'N');

3647: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3648: aso_debug_pub.add('Quote_Order_High_Availability: P_Quote_Header_id: '||P_Quote_Header_id, 1, 'N');
3649: aso_debug_pub.add('Quote_Order_High_Availability: P_Book_Flag: '||P_Book_Flag, 1, 'N');
3650: aso_debug_pub.add('Quote_Order_High_Availability: P_Calculate_Flag: '||P_Calculate_Flag, 1, 'N');
3651: aso_debug_pub.add('Quote_Order_High_Availability: P_Server_Id: '||P_Server_Id, 1, 'N');
3652: END IF;
3653:
3654: l_Control_Rec.Book_Flag := P_Book_Flag;
3655: l_Control_Rec.Calculate_Price := P_Calculate_Flag;