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.6 2008/01/09 10:36:12 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.6 2008/01/09 10:36:12 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 622: aso_debug_pub.add('ASO_PRICING_INT:In Pricing Item: p_qte_header_rec.quote_status_id'

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

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

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

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

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

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

653: p_pricing_event => l_pricing_event,
654: p_header_rec => p_qte_header_rec,
655: px_req_line_tbl => l_Req_line_tbl);
656:
657: ASO_PRICING_INT.G_LINE_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec(
658: p_qte_line_rec => p_qte_line_rec,
659: p_qte_line_dtl_rec => p_qte_line_dtl_rec,
660: p_shipment_rec => p_ln_shipment_rec);
661:

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

702: l_control_rec.GSA_CHECK_FLAG := 'Y';
703: l_control_rec.GSA_DUP_CHECK_FLAG := 'Y';
704: ELSE
705: l_pricing_event := NVL(p_control_rec.pricing_event,'LINE');
706: ASO_PRICING_INT.G_LINE_REC := ASO_PRICING_CORE_PVT.Set_Global_Rec (
707: p_qte_line_rec => p_qte_line_rec,
708: p_qte_line_dtl_rec => p_qte_line_dtl_rec,
709: p_shipment_rec => p_ln_shipment_rec);
710:

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

750: l_control_rec.GSA_CHECK_FLAG := 'Y';
751: l_control_rec.GSA_DUP_CHECK_FLAG := 'Y';
752: END IF;
753: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
754: aso_debug_pub.add('ASO_PRICING_INT:In Pricing Item: l_control_rec.pricing_event'
755: ||l_control_rec.pricing_event,1,'Y');
756: aso_debug_pub.add('ASO_PRICING_INT:In Pricing Item: l_request_type'||l_request_type,1,'Y');
757: END IF;
758:

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

752: END IF;
753: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
754: aso_debug_pub.add('ASO_PRICING_INT:In Pricing Item: l_control_rec.pricing_event'
755: ||l_control_rec.pricing_event,1,'Y');
756: aso_debug_pub.add('ASO_PRICING_INT:In Pricing Item: l_request_type'||l_request_type,1,'Y');
757: END IF;
758:
759:
760: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */

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

792: x_return_status => x_return_status,
793: x_return_status_text => l_return_status_text);
794:
795: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
796: aso_debug_pub.add('ASO_PRICING_INT:Price Request Status from Pricing Item:'||x_return_status,1,'Y');
797: END IF;
798:
799: ASO_PRICING_INT.G_LINE_REC := NULL;
800: ASO_PRICING_INT.G_HEADER_REC := NULL;

Line 799: ASO_PRICING_INT.G_LINE_REC := NULL;

795: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
796: aso_debug_pub.add('ASO_PRICING_INT:Price Request Status from Pricing Item:'||x_return_status,1,'Y');
797: END IF;
798:
799: ASO_PRICING_INT.G_LINE_REC := NULL;
800: ASO_PRICING_INT.G_HEADER_REC := NULL;
801:
802: i := lx_req_line_tbl.FIRST;
803: WHILE i IS NOT NULL LOOP

Line 800: ASO_PRICING_INT.G_HEADER_REC := NULL;

796: aso_debug_pub.add('ASO_PRICING_INT:Price Request Status from Pricing Item:'||x_return_status,1,'Y');
797: END IF;
798:
799: ASO_PRICING_INT.G_LINE_REC := NULL;
800: ASO_PRICING_INT.G_HEADER_REC := NULL;
801:
802: i := lx_req_line_tbl.FIRST;
803: WHILE i IS NOT NULL LOOP
804: lx_req_line_rec := lx_req_line_tbl(i);

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

814: x_return_status := FND_API.G_RET_STS_ERROR;
815: END IF;
816:
817: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
818: aso_debug_pub.add('ASO_PRICING_INT:Fnd_Profile Value for GSA:'
819: ||FND_PROFILE.value('ASO_GSA_PRICING'), 1, 'N');
820: aso_debug_pub.add('ASO_PRICING_INT:After price request in pricing_item for line id '
821: ||lx_req_line_rec.line_id ||'status code '||lx_req_line_rec.status_code, 1, 'N');
822: END IF;

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

816:
817: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
818: aso_debug_pub.add('ASO_PRICING_INT:Fnd_Profile Value for GSA:'
819: ||FND_PROFILE.value('ASO_GSA_PRICING'), 1, 'N');
820: aso_debug_pub.add('ASO_PRICING_INT:After price request in pricing_item for line id '
821: ||lx_req_line_rec.line_id ||'status code '||lx_req_line_rec.status_code, 1, 'N');
822: END IF;
823:
824: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

825: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
828: FND_MESSAGE.Set_Name('ASO', 'ASO_API_UNEXP_ERROR');
829: FND_MESSAGE.Set_Token('ROW', 'ASO_PRICING_INT AFTER PRICING CALL', TRUE);
830: FND_MSG_PUB.ADD;
831: END IF;
832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
833: ELSE

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

842: END IF;
843: i := lx_req_line_tbl.NEXT(i);
844: END LOOP;
845: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
846: aso_debug_pub.add('ASO_PRICING_INT:Before Copy_Request_To_Line in pricing_item', 1, 'Y');
847: END IF;
848: ASO_PRICING_CALLBACK_PVT.Copy_Request_To_Line (
849: p_req_line_tbl => lx_req_line_tbl,
850: p_req_line_qual => lx_Req_qual_tbl,

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

860: x_price_adj_tbl => x_price_adj_tbl,
861: x_price_adj_attr_tbl => x_price_adj_attr_tbl,
862: x_price_adj_rltship_tbl => x_price_adj_rltship_tbl);
863: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
864: aso_debug_pub.add('ASO_PRICING_INT:after Copy_Request_To_Line in pricing_item', 1, 'Y');
865: END IF;
866:
867: -- Standard check for p_commit
868: IF FND_API.to_Boolean( p_commit )

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

971:
972: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
973:
974: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
975: aso_debug_pub.add('ASO_PRICING_INT:Start of Pricing Order.....',1,'Y');
976: END IF;
977:
978: -- Initialize message list if p_init_msg_list is set to TRUE.
979: IF FND_API.to_Boolean( p_init_msg_list )

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

978: -- Initialize message list if p_init_msg_list is set to TRUE.
979: IF FND_API.to_Boolean( p_init_msg_list )
980: THEN
981: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
982: aso_debug_pub.add('ASO_PRICING_INT:Begin FND_API.to_Boolean'||p_init_msg_list, 1, 'Y');
983: END IF;
984: FND_MSG_PUB.initialize;
985: END IF;
986:

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

988:
989: ASO_PRICING_CORE_PVT.Initialize_Global_Tables;
990:
991: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
992: aso_debug_pub.add('ASO_PRICING_INT:p_control_rec.request_type:'||p_control_rec.request_type,1,'Y');
993: aso_debug_pub.add('ASO_PRICING_INT:p_control_rec.pricing_event:'||p_control_rec.pricing_event,1,'Y');
994: END IF;
995: l_request_type := p_control_rec.request_type;
996: l_pricing_event := p_control_rec.pricing_event;

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

989: ASO_PRICING_CORE_PVT.Initialize_Global_Tables;
990:
991: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
992: aso_debug_pub.add('ASO_PRICING_INT:p_control_rec.request_type:'||p_control_rec.request_type,1,'Y');
993: aso_debug_pub.add('ASO_PRICING_INT:p_control_rec.pricing_event:'||p_control_rec.pricing_event,1,'Y');
994: END IF;
995: l_request_type := p_control_rec.request_type;
996: l_pricing_event := p_control_rec.pricing_event;
997:

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

995: l_request_type := p_control_rec.request_type;
996: l_pricing_event := p_control_rec.pricing_event;
997:
998: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
999: aso_debug_pub.add('ASO_PRICING_INT:Pricing Order Code Path Determination Flag - PRICE_CONFIG_FLAG:'
1000: || p_control_rec.PRICE_CONFIG_FLAG,1,'Y');
1001: aso_debug_pub.add('ASO_PRICING_INT:p_qte_line_tbl.count:'||nvl(p_qte_line_tbl.count,0),1,'Y');
1002: END IF;
1003: If p_control_rec.PRICE_CONFIG_FLAG = 'Y' then

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

997:
998: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
999: aso_debug_pub.add('ASO_PRICING_INT:Pricing Order Code Path Determination Flag - PRICE_CONFIG_FLAG:'
1000: || p_control_rec.PRICE_CONFIG_FLAG,1,'Y');
1001: aso_debug_pub.add('ASO_PRICING_INT:p_qte_line_tbl.count:'||nvl(p_qte_line_tbl.count,0),1,'Y');
1002: END IF;
1003: If p_control_rec.PRICE_CONFIG_FLAG = 'Y' then
1004: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1005: aso_debug_pub.add('ASO_PRICING_INT:Before Pricing Request Configurator Code Path Begins',1,'Y');

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

1001: aso_debug_pub.add('ASO_PRICING_INT:p_qte_line_tbl.count:'||nvl(p_qte_line_tbl.count,0),1,'Y');
1002: END IF;
1003: If p_control_rec.PRICE_CONFIG_FLAG = 'Y' then
1004: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1005: aso_debug_pub.add('ASO_PRICING_INT:Before Pricing Request Configurator Code Path Begins',1,'Y');
1006: END IF;
1007:
1008: ASO_PRICING_CALLBACK_PVT.Config_Callback_Pricing_Order(
1009: P_Api_Version_Number => P_Api_Version_Number,

Line 1038: 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');

1034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1035: END IF;
1036:
1037: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1038: 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');
1039: If x_qte_line_tbl.count > 0 then
1040: For i in 1..x_qte_line_tbl.count loop
1041: 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');
1042: 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 1041: 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');

1037: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1038: 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');
1039: If x_qte_line_tbl.count > 0 then
1040: For i in 1..x_qte_line_tbl.count loop
1041: 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');
1042: 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');
1043: 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');
1044: End Loop;
1045: End If;

Line 1042: 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');

1038: 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');
1039: If x_qte_line_tbl.count > 0 then
1040: For i in 1..x_qte_line_tbl.count loop
1041: 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');
1042: 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');
1043: 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');
1044: End Loop;
1045: End If;
1046:

Line 1043: 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');

1039: If x_qte_line_tbl.count > 0 then
1040: For i in 1..x_qte_line_tbl.count loop
1041: 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');
1042: 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');
1043: 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');
1044: End Loop;
1045: End If;
1046:
1047: END IF;-- ASO_DEBUG_PUB.G_Debug_Flag = 'Y'

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

1047: END IF;-- ASO_DEBUG_PUB.G_Debug_Flag = 'Y'
1048:
1049: Else
1050: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1051: aso_debug_pub.add('ASO_PRICING_INT: p_control_rec.price_mode: '||NVL(p_control_rec.price_mode,'NULL'),1,'Y');
1052: END IF;
1053:
1054: --Non Configurator Code Path
1055:

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

1120: End If;--NVL(p_control_rec.price_mode,'ENTIRE_QUOTE') = 'ENTIRE_QUOTE'
1121:
1122:
1123: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1124: aso_debug_pub.add('ASO_PRICING_INT:After Entire_Quote:lx_qte_line_tbl.count:'||nvl(lx_qte_line_tbl.count,0),1,'Y');
1125: END IF;
1126:
1127: x_qte_line_tbl:= p_qte_line_tbl;
1128:

Line 1137: 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');

1133: end If;
1134: End if;--p_control_rec.PRICE_CONFIG_FLAG = 'Y'
1135:
1136: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1137: 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');
1138: END IF;
1139:
1140: FND_MSG_PUB.Count_And_Get
1141: ( p_encoded => 'F',

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

1145:
1146: for l in 1 .. x_msg_count loop
1147: x_msg_data := fnd_msg_pub.get( p_msg_index => l, p_encoded => 'F');
1148: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1149: aso_debug_pub.add('ASO_PRICING_INT:Messge count and get '||x_msg_data, 1, 'Y');
1150: aso_debug_pub.add('ASO_PRICING_INT:Messge count and get '||x_msg_count, 1, 'Y');
1151: END IF;
1152: end loop;
1153:

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

1146: for l in 1 .. x_msg_count loop
1147: x_msg_data := fnd_msg_pub.get( p_msg_index => l, p_encoded => 'F');
1148: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1149: aso_debug_pub.add('ASO_PRICING_INT:Messge count and get '||x_msg_data, 1, 'Y');
1150: aso_debug_pub.add('ASO_PRICING_INT:Messge count and get '||x_msg_count, 1, 'Y');
1151: END IF;
1152: end loop;
1153:
1154: EXCEPTION

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

1153:
1154: EXCEPTION
1155: WHEN FND_API.G_EXC_ERROR THEN
1156: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1157: aso_debug_pub.add('ASO_PRICING_INT:after inside EXCEPTION return status'||x_return_status, 1, 'Y');
1158: END IF;
1159: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1160: P_API_NAME => L_API_NAME
1161: ,P_PKG_NAME => G_PKG_NAME

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

1331: /*Removed the Complex Delete Statement with UNION bug 2585468 */
1332: DELETE from ASO_PRICE_ADJ_RELATIONSHIPS
1333: WHERE quote_line_id = p_qte_line_id;
1334: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1335: aso_debug_pub.add('ASO_PRICING_INT:Rltd adj Lines deleted '||sql%ROWCOUNT,1,'Y');
1336: END IF;
1337:
1338:
1339: DELETE FROM ASO_PRICE_ADJUSTMENTS

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

1338:
1339: DELETE FROM ASO_PRICE_ADJUSTMENTS
1340: WHERE quote_line_id = p_qte_line_id;
1341: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1342: aso_debug_pub.add('ASO_PRICING_INT:ADJ Lines deleted '||sql%ROWCOUNT,1,'Y');
1343: END IF;
1344:
1345: FOR i IN 1..lx_qte_line_tbl.count LOOP
1346: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(lx_qte_line_tbl(i).quote_line_id);

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

1354: p_price_adj_attr_tbl => lx_price_adj_attr_tbl,
1355: p_price_adj_rltship_tbl => lx_price_adj_rltship_tbl);
1356:
1357: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1358: aso_debug_pub.add('ASO_PRICING_INT:Pricing Item Ends if the second Pricing Item was called...',1,'Y');
1359: END IF;
1360:
1361: -- Standard check for p_commit
1362: IF FND_API.to_Boolean( p_commit )

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

1486: FND_MSG_PUB.initialize;
1487: END IF;
1488:
1489: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1490: aso_debug_pub.add('ASO_PRICING_INT:In Pricing Order with hdr Id', 1, 'Y');
1491: END IF;
1492:
1493: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1494:

Line 1505: ASO_PRICING_INT.Pricing_Order(

1501: IF l_shipment_tbl.count = 1 THEN
1502: l_shipment_rec := l_shipment_tbl(1);
1503: END IF;
1504: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(p_qte_header_id, null);
1505: ASO_PRICING_INT.Pricing_Order(
1506: P_Api_Version_Number => 1.0,
1507: P_Init_Msg_List => FND_API.G_FALSE,
1508: P_Commit => FND_API.G_FALSE,
1509: p_control_rec => p_control_rec,

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

1664: CLOSE get_req_date;
1665:
1666: x_request_date := FND_DATE.DATE_TO_CANONICAL(l_request_date);
1667: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1668: aso_debug_pub.add('ASO_PRICING_INT:In Get_Line_Request_date'||x_request_date, 1, 'Y');
1669: END IF;
1670: RETURN x_request_date;
1671: END Get_line_Request_date;
1672:

Line 1740: End ASO_PRICING_INT;

1736: RETURN l_pmnt_term_id;
1737: END Get_line_Payment_term;
1738:
1739:
1740: End ASO_PRICING_INT;