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_PRICING_INT dependencies on ASO_PRICING_INT

Line 1: PACKAGE BODY ASO_PRICING_INT AS

1: PACKAGE BODY ASO_PRICING_INT AS
2: /* $Header: asoiprcb.pls 120.7 2011/09/16 07:07:37 rassharm ship $ */
3: -- Start of Comments
4: -- Package name : ASO_PRICING_INT
5: -- Purpose :

Line 4: -- Package name : ASO_PRICING_INT

1: PACKAGE BODY ASO_PRICING_INT AS
2: /* $Header: asoiprcb.pls 120.7 2011/09/16 07:07:37 rassharm ship $ */
3: -- Start of Comments
4: -- Package name : ASO_PRICING_INT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_PRICING_INT';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_PRICING_INT';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asoiprcb.pls';
13:
14:
15: FUNCTION Set_Global_Rec (

Line 517: aso_debug_pub.add('ASO_PRICING_INT:In Get_quote_amount: x_quote_amount:'||x_quote_amount,1,'Y');

513: END IF;
514:
515: x_quote_amount:=FND_NUMBER.NUMBER_TO_CANONICAL(NVL(l_quote_amount,0));
516: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
517: aso_debug_pub.add('ASO_PRICING_INT:In Get_quote_amount: x_quote_amount:'||x_quote_amount,1,'Y');
518: END IF;
519: RETURN x_quote_amount;
520:
521: END Get_quote_Amount;

Line 624: aso_debug_pub.add('ASO_PRICING_INT:In Pricing Item: p_qte_header_rec.quote_status_id'

620:
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622: l_request_type := NVL(p_control_rec.request_type,'ASO');
623: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
624: aso_debug_pub.add('ASO_PRICING_INT:In Pricing Item: p_qte_header_rec.quote_status_id'
625: ||p_qte_header_rec.quote_status_id,1,'Y');
626: END IF;
627: -- Bug No 6510202. Header rec needs to be intialized since the header rec frozen date is passed
628: -- to line rec price effective date which would be picked by pricing for selecting the correct price list

Line 629: ASO_PRICING_INT.G_HEADER_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (

625: ||p_qte_header_rec.quote_status_id,1,'Y');
626: END IF;
627: -- Bug No 6510202. Header rec needs to be intialized since the header rec frozen date is passed
628: -- to line rec price effective date which would be picked by pricing for selecting the correct price list
629: ASO_PRICING_INT.G_HEADER_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
630: p_qte_header_rec => p_qte_header_rec,
631: p_shipment_rec => p_hd_shipment_rec);
632:
633: IF NVL(p_qte_header_rec.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

Line 636: /* ASO_PRICING_INT.G_HEADER_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (

632:
633: IF NVL(p_qte_header_rec.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
634: l_pricing_event := 'BATCH'; --p_control_rec.pricing_event;
635: -- commented for bug no 6510202
636: /* ASO_PRICING_INT.G_HEADER_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
637: p_qte_header_rec => p_qte_header_rec,
638: p_shipment_rec => p_hd_shipment_rec);
639: */
640:

Line 664: ASO_PRICING_INT.G_LINE_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec(

660: p_pricing_event => l_pricing_event,
661: p_header_rec => p_qte_header_rec,
662: px_req_line_tbl => l_Req_line_tbl);
663:
664: ASO_PRICING_INT.G_LINE_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec(
665: p_qte_line_rec => p_qte_line_rec,
666: p_qte_line_dtl_rec => p_qte_line_dtl_rec,
667: p_shipment_rec => p_ln_shipment_rec);
668:

Line 717: ASO_PRICING_INT.G_LINE_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (

713: l_control_rec.GSA_CHECK_FLAG := 'Y';
714: l_control_rec.GSA_DUP_CHECK_FLAG := 'Y';
715: ELSE
716: l_pricing_event := NVL(p_control_rec.pricing_event,'LINE');
717: ASO_PRICING_INT.G_LINE_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
718: p_qte_line_rec => p_qte_line_rec,
719: p_qte_line_dtl_rec => p_qte_line_dtl_rec,
720: p_shipment_rec => p_ln_shipment_rec);
721:

Line 769: aso_debug_pub.add('ASO_PRICING_INT:In Pricing Item: l_control_rec.pricing_event'

765: l_control_rec.GSA_CHECK_FLAG := 'Y';
766: l_control_rec.GSA_DUP_CHECK_FLAG := 'Y';
767: END IF;
768: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
769: aso_debug_pub.add('ASO_PRICING_INT:In Pricing Item: l_control_rec.pricing_event'
770: ||l_control_rec.pricing_event,1,'Y');
771: aso_debug_pub.add('ASO_PRICING_INT:In Pricing Item: l_request_type'||l_request_type,1,'Y');
772: END IF;
773:

Line 771: aso_debug_pub.add('ASO_PRICING_INT:In Pricing Item: l_request_type'||l_request_type,1,'Y');

767: END IF;
768: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
769: aso_debug_pub.add('ASO_PRICING_INT:In Pricing Item: l_control_rec.pricing_event'
770: ||l_control_rec.pricing_event,1,'Y');
771: aso_debug_pub.add('ASO_PRICING_INT:In Pricing Item: l_request_type'||l_request_type,1,'Y');
772: END IF;
773:
774:
775: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */

Line 811: aso_debug_pub.add('ASO_PRICING_INT:Price Request Status from Pricing Item:'||x_return_status,1,'Y');

807: x_return_status => x_return_status,
808: x_return_status_text => l_return_status_text);
809:
810: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
811: aso_debug_pub.add('ASO_PRICING_INT:Price Request Status from Pricing Item:'||x_return_status,1,'Y');
812: END IF;
813:
814: ASO_PRICING_INT.G_LINE_REC := NULL;
815: ASO_PRICING_INT.G_HEADER_REC := NULL;

Line 814: ASO_PRICING_INT.G_LINE_REC := NULL;

810: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
811: aso_debug_pub.add('ASO_PRICING_INT:Price Request Status from Pricing Item:'||x_return_status,1,'Y');
812: END IF;
813:
814: ASO_PRICING_INT.G_LINE_REC := NULL;
815: ASO_PRICING_INT.G_HEADER_REC := NULL;
816:
817: i := lx_req_line_tbl.FIRST;
818: WHILE i IS NOT NULL LOOP

Line 815: ASO_PRICING_INT.G_HEADER_REC := NULL;

811: aso_debug_pub.add('ASO_PRICING_INT:Price Request Status from Pricing Item:'||x_return_status,1,'Y');
812: END IF;
813:
814: ASO_PRICING_INT.G_LINE_REC := NULL;
815: ASO_PRICING_INT.G_HEADER_REC := NULL;
816:
817: i := lx_req_line_tbl.FIRST;
818: WHILE i IS NOT NULL LOOP
819: lx_req_line_rec := lx_req_line_tbl(i);

Line 833: aso_debug_pub.add('ASO_PRICING_INT:Fnd_Profile Value for GSA:'

829: x_return_status := FND_API.G_RET_STS_ERROR;
830: END IF;
831:
832: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
833: aso_debug_pub.add('ASO_PRICING_INT:Fnd_Profile Value for GSA:'
834: ||FND_PROFILE.value('ASO_GSA_PRICING'), 1, 'N');
835: aso_debug_pub.add('ASO_PRICING_INT:After price request in pricing_item for line id '
836: ||lx_req_line_rec.line_id ||'status code '||lx_req_line_rec.status_code, 1, 'N');
837: END IF;

Line 835: aso_debug_pub.add('ASO_PRICING_INT:After price request in pricing_item for line id '

831:
832: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
833: aso_debug_pub.add('ASO_PRICING_INT:Fnd_Profile Value for GSA:'
834: ||FND_PROFILE.value('ASO_GSA_PRICING'), 1, 'N');
835: aso_debug_pub.add('ASO_PRICING_INT:After price request in pricing_item for line id '
836: ||lx_req_line_rec.line_id ||'status code '||lx_req_line_rec.status_code, 1, 'N');
837: END IF;
838:
839: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 844: FND_MESSAGE.Set_Token('ROW', 'ASO_PRICING_INT AFTER PRICING CALL', TRUE);

840: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
842: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
843: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
844: FND_MESSAGE.Set_Token('ROW', 'ASO_PRICING_INT AFTER PRICING CALL', TRUE);
845: FND_MSG_PUB.ADD;
846: END IF;
847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
848: ELSE

Line 861: aso_debug_pub.add('ASO_PRICING_INT:Before Copy_Request_To_Line in pricing_item', 1, 'Y');

857: END IF;
858: i := lx_req_line_tbl.NEXT(i);
859: END LOOP;
860: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
861: aso_debug_pub.add('ASO_PRICING_INT:Before Copy_Request_To_Line in pricing_item', 1, 'Y');
862: END IF;
863: ASO_PRICING_CALLBACK_PVT.Copy_Request_To_Line (
864: p_req_line_tbl => lx_req_line_tbl,
865: p_req_line_qual => lx_Req_qual_tbl,

Line 879: aso_debug_pub.add('ASO_PRICING_INT:after Copy_Request_To_Line in pricing_item', 1, 'Y');

875: x_price_adj_tbl => x_price_adj_tbl,
876: x_price_adj_attr_tbl => x_price_adj_attr_tbl,
877: x_price_adj_rltship_tbl => x_price_adj_rltship_tbl);
878: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
879: aso_debug_pub.add('ASO_PRICING_INT:after Copy_Request_To_Line in pricing_item', 1, 'Y');
880: END IF;
881:
882: -- Standard check for p_commit
883: IF FND_API.to_Boolean( p_commit )

Line 990: aso_debug_pub.add('ASO_PRICING_INT:Start of Pricing Order.....',1,'Y');

986:
987: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
988:
989: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
990: aso_debug_pub.add('ASO_PRICING_INT:Start of Pricing Order.....',1,'Y');
991: END IF;
992:
993: -- Initialize message list if p_init_msg_list is set to TRUE.
994: IF FND_API.to_Boolean( p_init_msg_list )

Line 997: aso_debug_pub.add('ASO_PRICING_INT:Begin FND_API.to_Boolean'||p_init_msg_list, 1, 'Y');

993: -- Initialize message list if p_init_msg_list is set to TRUE.
994: IF FND_API.to_Boolean( p_init_msg_list )
995: THEN
996: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
997: aso_debug_pub.add('ASO_PRICING_INT:Begin FND_API.to_Boolean'||p_init_msg_list, 1, 'Y');
998: END IF;
999: FND_MSG_PUB.initialize;
1000: END IF;
1001:

Line 1007: aso_debug_pub.add('ASO_PRICING_INT:p_control_rec.request_type:'||p_control_rec.request_type,1,'Y');

1003:
1004: ASO_PRICING_CORE_PVT.Initialize_Global_Tables;
1005:
1006: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1007: aso_debug_pub.add('ASO_PRICING_INT:p_control_rec.request_type:'||p_control_rec.request_type,1,'Y');
1008: aso_debug_pub.add('ASO_PRICING_INT:p_control_rec.pricing_event:'||p_control_rec.pricing_event,1,'Y');
1009: END IF;
1010: l_request_type := p_control_rec.request_type;
1011: l_pricing_event := p_control_rec.pricing_event;

Line 1008: aso_debug_pub.add('ASO_PRICING_INT:p_control_rec.pricing_event:'||p_control_rec.pricing_event,1,'Y');

1004: ASO_PRICING_CORE_PVT.Initialize_Global_Tables;
1005:
1006: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1007: aso_debug_pub.add('ASO_PRICING_INT:p_control_rec.request_type:'||p_control_rec.request_type,1,'Y');
1008: aso_debug_pub.add('ASO_PRICING_INT:p_control_rec.pricing_event:'||p_control_rec.pricing_event,1,'Y');
1009: END IF;
1010: l_request_type := p_control_rec.request_type;
1011: l_pricing_event := p_control_rec.pricing_event;
1012:

Line 1014: aso_debug_pub.add('ASO_PRICING_INT:Pricing Order Code Path Determination Flag - PRICE_CONFIG_FLAG:'

1010: l_request_type := p_control_rec.request_type;
1011: l_pricing_event := p_control_rec.pricing_event;
1012:
1013: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1014: aso_debug_pub.add('ASO_PRICING_INT:Pricing Order Code Path Determination Flag - PRICE_CONFIG_FLAG:'
1015: || p_control_rec.PRICE_CONFIG_FLAG,1,'Y');
1016: aso_debug_pub.add('ASO_PRICING_INT:p_qte_line_tbl.count:'||nvl(p_qte_line_tbl.count,0),1,'Y');
1017: END IF;
1018: If p_control_rec.PRICE_CONFIG_FLAG = 'Y' then

Line 1016: aso_debug_pub.add('ASO_PRICING_INT:p_qte_line_tbl.count:'||nvl(p_qte_line_tbl.count,0),1,'Y');

1012:
1013: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1014: aso_debug_pub.add('ASO_PRICING_INT:Pricing Order Code Path Determination Flag - PRICE_CONFIG_FLAG:'
1015: || p_control_rec.PRICE_CONFIG_FLAG,1,'Y');
1016: aso_debug_pub.add('ASO_PRICING_INT:p_qte_line_tbl.count:'||nvl(p_qte_line_tbl.count,0),1,'Y');
1017: END IF;
1018: If p_control_rec.PRICE_CONFIG_FLAG = 'Y' then
1019: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1020: aso_debug_pub.add('ASO_PRICING_INT:Before Pricing Request Configurator Code Path Begins',1,'Y');

Line 1020: aso_debug_pub.add('ASO_PRICING_INT:Before Pricing Request Configurator Code Path Begins',1,'Y');

1016: aso_debug_pub.add('ASO_PRICING_INT:p_qte_line_tbl.count:'||nvl(p_qte_line_tbl.count,0),1,'Y');
1017: END IF;
1018: If p_control_rec.PRICE_CONFIG_FLAG = 'Y' then
1019: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1020: aso_debug_pub.add('ASO_PRICING_INT:Before Pricing Request Configurator Code Path Begins',1,'Y');
1021: END IF;
1022:
1023: ASO_PRICING_CALLBACK_PVT.Config_Callback_Pricing_Order(
1024: P_Api_Version_Number => P_Api_Version_Number,

Line 1053: aso_debug_pub.add('ASO_PRICING_INT:After Config_Callback_Pricing_Order:x_qte_line_tbl.count:'||nvl(x_qte_line_tbl.count,0),1,'Y');

1049: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1050: END IF;
1051:
1052: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1053: aso_debug_pub.add('ASO_PRICING_INT:After Config_Callback_Pricing_Order:x_qte_line_tbl.count:'||nvl(x_qte_line_tbl.count,0),1,'Y');
1054: If x_qte_line_tbl.count > 0 then
1055: For i in 1..x_qte_line_tbl.count loop
1056: aso_debug_pub.add('ASO_PRICING_INT:x_qte_line_tbl('||i||').LINE_LIST_PRICE: '||x_qte_line_tbl(i).LINE_LIST_PRICE,1,'Y');
1057: aso_debug_pub.add('ASO_PRICING_INT:x_qte_line_tbl('||i||').LINE_QUOTE_PRICE: '||x_qte_line_tbl(i).LINE_QUOTE_PRICE,1,'Y');

Line 1056: aso_debug_pub.add('ASO_PRICING_INT:x_qte_line_tbl('||i||').LINE_LIST_PRICE: '||x_qte_line_tbl(i).LINE_LIST_PRICE,1,'Y');

1052: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1053: aso_debug_pub.add('ASO_PRICING_INT:After Config_Callback_Pricing_Order:x_qte_line_tbl.count:'||nvl(x_qte_line_tbl.count,0),1,'Y');
1054: If x_qte_line_tbl.count > 0 then
1055: For i in 1..x_qte_line_tbl.count loop
1056: aso_debug_pub.add('ASO_PRICING_INT:x_qte_line_tbl('||i||').LINE_LIST_PRICE: '||x_qte_line_tbl(i).LINE_LIST_PRICE,1,'Y');
1057: aso_debug_pub.add('ASO_PRICING_INT:x_qte_line_tbl('||i||').LINE_QUOTE_PRICE: '||x_qte_line_tbl(i).LINE_QUOTE_PRICE,1,'Y');
1058: aso_debug_pub.add('ASO_PRICING_INT:x_qte_line_tbl('||i||').INVENTORY_ITEM_ID: '||x_qte_line_tbl(i).INVENTORY_ITEM_ID,1,'Y');
1059: End Loop;
1060: End If;

Line 1057: aso_debug_pub.add('ASO_PRICING_INT:x_qte_line_tbl('||i||').LINE_QUOTE_PRICE: '||x_qte_line_tbl(i).LINE_QUOTE_PRICE,1,'Y');

1053: aso_debug_pub.add('ASO_PRICING_INT:After Config_Callback_Pricing_Order:x_qte_line_tbl.count:'||nvl(x_qte_line_tbl.count,0),1,'Y');
1054: If x_qte_line_tbl.count > 0 then
1055: For i in 1..x_qte_line_tbl.count loop
1056: aso_debug_pub.add('ASO_PRICING_INT:x_qte_line_tbl('||i||').LINE_LIST_PRICE: '||x_qte_line_tbl(i).LINE_LIST_PRICE,1,'Y');
1057: aso_debug_pub.add('ASO_PRICING_INT:x_qte_line_tbl('||i||').LINE_QUOTE_PRICE: '||x_qte_line_tbl(i).LINE_QUOTE_PRICE,1,'Y');
1058: aso_debug_pub.add('ASO_PRICING_INT:x_qte_line_tbl('||i||').INVENTORY_ITEM_ID: '||x_qte_line_tbl(i).INVENTORY_ITEM_ID,1,'Y');
1059: End Loop;
1060: End If;
1061:

Line 1058: aso_debug_pub.add('ASO_PRICING_INT:x_qte_line_tbl('||i||').INVENTORY_ITEM_ID: '||x_qte_line_tbl(i).INVENTORY_ITEM_ID,1,'Y');

1054: If x_qte_line_tbl.count > 0 then
1055: For i in 1..x_qte_line_tbl.count loop
1056: aso_debug_pub.add('ASO_PRICING_INT:x_qte_line_tbl('||i||').LINE_LIST_PRICE: '||x_qte_line_tbl(i).LINE_LIST_PRICE,1,'Y');
1057: aso_debug_pub.add('ASO_PRICING_INT:x_qte_line_tbl('||i||').LINE_QUOTE_PRICE: '||x_qte_line_tbl(i).LINE_QUOTE_PRICE,1,'Y');
1058: aso_debug_pub.add('ASO_PRICING_INT:x_qte_line_tbl('||i||').INVENTORY_ITEM_ID: '||x_qte_line_tbl(i).INVENTORY_ITEM_ID,1,'Y');
1059: End Loop;
1060: End If;
1061:
1062: END IF;-- ASO_DEBUG_PUB.G_Debug_Flag = 'Y'

Line 1066: aso_debug_pub.add('ASO_PRICING_INT: p_control_rec.price_mode: '||NVL(p_control_rec.price_mode,'NULL'),1,'Y');

1062: END IF;-- ASO_DEBUG_PUB.G_Debug_Flag = 'Y'
1063:
1064: Else
1065: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1066: aso_debug_pub.add('ASO_PRICING_INT: p_control_rec.price_mode: '||NVL(p_control_rec.price_mode,'NULL'),1,'Y');
1067: END IF;
1068:
1069: --Non Configurator Code Path
1070:

Line 1139: aso_debug_pub.add('ASO_PRICING_INT:After Entire_Quote:lx_qte_line_tbl.count:'||nvl(lx_qte_line_tbl.count,0),1,'Y');

1135: End If;--NVL(p_control_rec.price_mode,'ENTIRE_QUOTE') = 'ENTIRE_QUOTE'
1136:
1137:
1138: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1139: aso_debug_pub.add('ASO_PRICING_INT:After Entire_Quote:lx_qte_line_tbl.count:'||nvl(lx_qte_line_tbl.count,0),1,'Y');
1140: END IF;
1141:
1142: x_qte_line_tbl:= p_qte_line_tbl;
1143:

Line 1152: aso_debug_pub.add('ASO_PRICING_INT:End of Pricing Order:x_qte_line_tbl.count:'||nvl(x_qte_line_tbl.count,0),1,'Y');

1148: end If;
1149: End if;--p_control_rec.PRICE_CONFIG_FLAG = 'Y'
1150:
1151: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1152: aso_debug_pub.add('ASO_PRICING_INT:End of Pricing Order:x_qte_line_tbl.count:'||nvl(x_qte_line_tbl.count,0),1,'Y');
1153: END IF;
1154:
1155: FND_MSG_PUB.Count_And_Get
1156: ( p_encoded => 'F',

Line 1164: aso_debug_pub.add('ASO_PRICING_INT:Messge count and get '||x_msg_data, 1, 'Y');

1160:
1161: for l in 1 .. x_msg_count loop
1162: x_msg_data := fnd_msg_pub.get( p_msg_index => l, p_encoded => 'F');
1163: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1164: aso_debug_pub.add('ASO_PRICING_INT:Messge count and get '||x_msg_data, 1, 'Y');
1165: aso_debug_pub.add('ASO_PRICING_INT:Messge count and get '||x_msg_count, 1, 'Y');
1166: END IF;
1167: end loop;
1168:

Line 1165: aso_debug_pub.add('ASO_PRICING_INT:Messge count and get '||x_msg_count, 1, 'Y');

1161: for l in 1 .. x_msg_count loop
1162: x_msg_data := fnd_msg_pub.get( p_msg_index => l, p_encoded => 'F');
1163: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1164: aso_debug_pub.add('ASO_PRICING_INT:Messge count and get '||x_msg_data, 1, 'Y');
1165: aso_debug_pub.add('ASO_PRICING_INT:Messge count and get '||x_msg_count, 1, 'Y');
1166: END IF;
1167: end loop;
1168:
1169: EXCEPTION

Line 1172: aso_debug_pub.add('ASO_PRICING_INT:after inside EXCEPTION return status'||x_return_status, 1, 'Y');

1168:
1169: EXCEPTION
1170: WHEN FND_API.G_EXC_ERROR THEN
1171: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1172: aso_debug_pub.add('ASO_PRICING_INT:after inside EXCEPTION return status'||x_return_status, 1, 'Y');
1173: END IF;
1174: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1175: P_API_NAME => L_API_NAME
1176: ,P_PKG_NAME => G_PKG_NAME

Line 1350: aso_debug_pub.add('ASO_PRICING_INT:Rltd adj Lines deleted '||sql%ROWCOUNT,1,'Y');

1346: /*Removed the Complex Delete Statement with UNION bug 2585468 */
1347: DELETE from ASO_PRICE_ADJ_RELATIONSHIPS
1348: WHERE quote_line_id = p_qte_line_id;
1349: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1350: aso_debug_pub.add('ASO_PRICING_INT:Rltd adj Lines deleted '||sql%ROWCOUNT,1,'Y');
1351: END IF;
1352:
1353:
1354: DELETE FROM ASO_PRICE_ADJUSTMENTS

Line 1357: aso_debug_pub.add('ASO_PRICING_INT:ADJ Lines deleted '||sql%ROWCOUNT,1,'Y');

1353:
1354: DELETE FROM ASO_PRICE_ADJUSTMENTS
1355: WHERE quote_line_id = p_qte_line_id;
1356: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1357: aso_debug_pub.add('ASO_PRICING_INT:ADJ Lines deleted '||sql%ROWCOUNT,1,'Y');
1358: END IF;
1359:
1360: FOR i IN 1..lx_qte_line_tbl.count LOOP
1361: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(lx_qte_line_tbl(i).quote_line_id);

Line 1373: aso_debug_pub.add('ASO_PRICING_INT:Pricing Item Ends if the second Pricing Item was called...',1,'Y');

1369: p_price_adj_attr_tbl => lx_price_adj_attr_tbl,
1370: p_price_adj_rltship_tbl => lx_price_adj_rltship_tbl);
1371:
1372: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1373: aso_debug_pub.add('ASO_PRICING_INT:Pricing Item Ends if the second Pricing Item was called...',1,'Y');
1374: END IF;
1375:
1376: -- Standard check for p_commit
1377: IF FND_API.to_Boolean( p_commit )

Line 1505: aso_debug_pub.add('ASO_PRICING_INT:In Pricing Order with hdr Id', 1, 'Y');

1501: FND_MSG_PUB.initialize;
1502: END IF;
1503:
1504: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1505: aso_debug_pub.add('ASO_PRICING_INT:In Pricing Order with hdr Id', 1, 'Y');
1506: END IF;
1507:
1508: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1509:

Line 1520: ASO_PRICING_INT.Pricing_Order(

1516: IF l_shipment_tbl.count = 1 THEN
1517: l_shipment_rec := l_shipment_tbl(1);
1518: END IF;
1519: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(p_qte_header_id, null);
1520: ASO_PRICING_INT.Pricing_Order(
1521: P_Api_Version_Number => 1.0,
1522: P_Init_Msg_List => FND_API.G_FALSE,
1523: P_Commit => FND_API.G_FALSE,
1524: p_control_rec => p_control_rec,

Line 1683: aso_debug_pub.add('ASO_PRICING_INT:In Get_Line_Request_date'||x_request_date, 1, 'Y');

1679: CLOSE get_req_date;
1680:
1681: x_request_date := FND_DATE.DATE_TO_CANONICAL(l_request_date);
1682: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1683: aso_debug_pub.add('ASO_PRICING_INT:In Get_Line_Request_date'||x_request_date, 1, 'Y');
1684: END IF;
1685: RETURN x_request_date;
1686: END Get_line_Request_date;
1687:

Line 1755: End ASO_PRICING_INT;

1751: RETURN l_pmnt_term_id;
1752: END Get_line_Payment_term;
1753:
1754:
1755: End ASO_PRICING_INT;