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_SOURCING_PVT dependencies on ASO_DEBUG_PUB

Line 75: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

71: if l_ship_to_cust_account_id is not null OR l_ship_to_cust_account_id <> fnd_api.G_MISS_NUM then
72: l_cust_account_id := l_ship_to_cust_account_id;
73: end if;
74:
75: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
76: aso_debug_pub.add('cust account = ' || l_cust_account_id,1,'N');
77: aso_debug_pub.add('ship party site = ' || l_ship_party_site_id,1,'N');
78: END IF;
79: IF l_cust_account_id is not NULL

Line 76: aso_debug_pub.add('cust account = ' || l_cust_account_id,1,'N');

72: l_cust_account_id := l_ship_to_cust_account_id;
73: end if;
74:
75: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
76: aso_debug_pub.add('cust account = ' || l_cust_account_id,1,'N');
77: aso_debug_pub.add('ship party site = ' || l_ship_party_site_id,1,'N');
78: END IF;
79: IF l_cust_account_id is not NULL
80: AND l_ship_party_site_id is not NULL THEN

Line 77: aso_debug_pub.add('ship party site = ' || l_ship_party_site_id,1,'N');

73: end if;
74:
75: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
76: aso_debug_pub.add('cust account = ' || l_cust_account_id,1,'N');
77: aso_debug_pub.add('ship party site = ' || l_ship_party_site_id,1,'N');
78: END IF;
79: IF l_cust_account_id is not NULL
80: AND l_ship_party_site_id is not NULL THEN
81:

Line 140: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

136:
137: if l_ship_to_cust_account_id is not null OR l_ship_to_cust_account_id <> fnd_api.G_MISS_NUM then
138: l_cust_account_id := l_ship_to_cust_account_id;
139: end if;
140: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
141: aso_debug_pub.add('cust account = ' || l_cust_account_id,1,'N');
142: aso_debug_pub.add('party site = ' || l_ship_party_site_id,1,'N');
143: END IF;
144:

Line 141: aso_debug_pub.add('cust account = ' || l_cust_account_id,1,'N');

137: if l_ship_to_cust_account_id is not null OR l_ship_to_cust_account_id <> fnd_api.G_MISS_NUM then
138: l_cust_account_id := l_ship_to_cust_account_id;
139: end if;
140: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
141: aso_debug_pub.add('cust account = ' || l_cust_account_id,1,'N');
142: aso_debug_pub.add('party site = ' || l_ship_party_site_id,1,'N');
143: END IF;
144:
145: IF l_cust_account_id is not NULL

Line 142: aso_debug_pub.add('party site = ' || l_ship_party_site_id,1,'N');

138: l_cust_account_id := l_ship_to_cust_account_id;
139: end if;
140: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
141: aso_debug_pub.add('cust account = ' || l_cust_account_id,1,'N');
142: aso_debug_pub.add('party site = ' || l_ship_party_site_id,1,'N');
143: END IF;
144:
145: IF l_cust_account_id is not NULL
146: AND l_ship_party_site_id is not NULL THEN

Line 207: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

203: if l_invoice_to_cust_account_id is not null OR l_invoice_to_cust_account_id <> fnd_api.G_MISS_NUM then
204: l_cust_account_id := l_invoice_to_cust_account_id;
205: end if;
206:
207: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
208: aso_debug_pub.add('cust account = ' || l_cust_account_id,1,'N');
209: aso_debug_pub.add('invoice party site = ' || l_invoice_party_site_id,1,'N');
210: END IF;
211:

Line 208: aso_debug_pub.add('cust account = ' || l_cust_account_id,1,'N');

204: l_cust_account_id := l_invoice_to_cust_account_id;
205: end if;
206:
207: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
208: aso_debug_pub.add('cust account = ' || l_cust_account_id,1,'N');
209: aso_debug_pub.add('invoice party site = ' || l_invoice_party_site_id,1,'N');
210: END IF;
211:
212:

Line 209: aso_debug_pub.add('invoice party site = ' || l_invoice_party_site_id,1,'N');

205: end if;
206:
207: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
208: aso_debug_pub.add('cust account = ' || l_cust_account_id,1,'N');
209: aso_debug_pub.add('invoice party site = ' || l_invoice_party_site_id,1,'N');
210: END IF;
211:
212:
213: IF l_cust_account_id is not NULL

Line 276: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

272: if l_invoice_to_cust_account_id is not null OR l_invoice_to_cust_account_id <> fnd_api.G_MISS_NUM then
273: l_cust_account_id := l_invoice_to_cust_account_id;
274: end if;
275:
276: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
277: aso_debug_pub.add('cust account = ' || l_cust_account_id,1,'N');
278: aso_debug_pub.add('invoice party site = ' || l_invoice_party_site_id,1,'N');
279: END IF;
280:

Line 277: aso_debug_pub.add('cust account = ' || l_cust_account_id,1,'N');

273: l_cust_account_id := l_invoice_to_cust_account_id;
274: end if;
275:
276: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
277: aso_debug_pub.add('cust account = ' || l_cust_account_id,1,'N');
278: aso_debug_pub.add('invoice party site = ' || l_invoice_party_site_id,1,'N');
279: END IF;
280:
281: IF l_cust_account_id is not NULL

Line 278: aso_debug_pub.add('invoice party site = ' || l_invoice_party_site_id,1,'N');

274: end if;
275:
276: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
277: aso_debug_pub.add('cust account = ' || l_cust_account_id,1,'N');
278: aso_debug_pub.add('invoice party site = ' || l_invoice_party_site_id,1,'N');
279: END IF;
280:
281: IF l_cust_account_id is not NULL
282: AND l_invoice_party_site_id is not NULL THEN

Line 753: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

749: WHERE
750: quote_header_id = p_qte_header_id and quote_line_id IS null;
751: l_pmnt_term_id NUMBER;
752: BEGIN
753: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
754: aso_debug_pub.add('Inside Get_line_Payment_term',1,'N');
755: aso_debug_pub.add('p_qte_header_id: '||nvl(to_char(p_qte_header_id),'null'),1,'N');
756: END IF;
757: OPEN get_pmnt_term;

Line 754: aso_debug_pub.add('Inside Get_line_Payment_term',1,'N');

750: quote_header_id = p_qte_header_id and quote_line_id IS null;
751: l_pmnt_term_id NUMBER;
752: BEGIN
753: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
754: aso_debug_pub.add('Inside Get_line_Payment_term',1,'N');
755: aso_debug_pub.add('p_qte_header_id: '||nvl(to_char(p_qte_header_id),'null'),1,'N');
756: END IF;
757: OPEN get_pmnt_term;
758: fetch get_pmnt_term into l_pmnt_term_id;

Line 755: aso_debug_pub.add('p_qte_header_id: '||nvl(to_char(p_qte_header_id),'null'),1,'N');

751: l_pmnt_term_id NUMBER;
752: BEGIN
753: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
754: aso_debug_pub.add('Inside Get_line_Payment_term',1,'N');
755: aso_debug_pub.add('p_qte_header_id: '||nvl(to_char(p_qte_header_id),'null'),1,'N');
756: END IF;
757: OPEN get_pmnt_term;
758: fetch get_pmnt_term into l_pmnt_term_id;
759: CLOSE get_pmnt_term;

Line 760: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

756: END IF;
757: OPEN get_pmnt_term;
758: fetch get_pmnt_term into l_pmnt_term_id;
759: CLOSE get_pmnt_term;
760: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
761: aso_debug_pub.add('Inside Get_line_Payment_term'||l_pmnt_term_id,1,'N');
762: END IF;
763: RETURN l_pmnt_term_id;
764: END Get_Payment_term;

Line 761: aso_debug_pub.add('Inside Get_line_Payment_term'||l_pmnt_term_id,1,'N');

757: OPEN get_pmnt_term;
758: fetch get_pmnt_term into l_pmnt_term_id;
759: CLOSE get_pmnt_term;
760: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
761: aso_debug_pub.add('Inside Get_line_Payment_term'||l_pmnt_term_id,1,'N');
762: END IF;
763: RETURN l_pmnt_term_id;
764: END Get_Payment_term;
765:

Line 780: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

776: WHERE
777: quote_line_id = p_qte_line_id;
778: l_pmnt_term_id NUMBER;
779: BEGIN
780: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
781: aso_debug_pub.add('Inside Get_line_Payment_term',1,'N');
782: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_qte_line_id),'null'),1,'N');
783: aso_debug_pub.add('p_qte_header_id: '||nvl(to_char(p_qte_header_id),'null'),1,'N');
784: END IF;

Line 781: aso_debug_pub.add('Inside Get_line_Payment_term',1,'N');

777: quote_line_id = p_qte_line_id;
778: l_pmnt_term_id NUMBER;
779: BEGIN
780: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
781: aso_debug_pub.add('Inside Get_line_Payment_term',1,'N');
782: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_qte_line_id),'null'),1,'N');
783: aso_debug_pub.add('p_qte_header_id: '||nvl(to_char(p_qte_header_id),'null'),1,'N');
784: END IF;
785: OPEN get_pmnt_term;

Line 782: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_qte_line_id),'null'),1,'N');

778: l_pmnt_term_id NUMBER;
779: BEGIN
780: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
781: aso_debug_pub.add('Inside Get_line_Payment_term',1,'N');
782: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_qte_line_id),'null'),1,'N');
783: aso_debug_pub.add('p_qte_header_id: '||nvl(to_char(p_qte_header_id),'null'),1,'N');
784: END IF;
785: OPEN get_pmnt_term;
786: fetch get_pmnt_term into l_pmnt_term_id;

Line 783: aso_debug_pub.add('p_qte_header_id: '||nvl(to_char(p_qte_header_id),'null'),1,'N');

779: BEGIN
780: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
781: aso_debug_pub.add('Inside Get_line_Payment_term',1,'N');
782: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_qte_line_id),'null'),1,'N');
783: aso_debug_pub.add('p_qte_header_id: '||nvl(to_char(p_qte_header_id),'null'),1,'N');
784: END IF;
785: OPEN get_pmnt_term;
786: fetch get_pmnt_term into l_pmnt_term_id;
787: CLOSE get_pmnt_term;

Line 795: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

791: fetch get_hdr_pmnt_term into l_pmnt_term_id;
792: CLOSE get_hdr_pmnt_term;
793: end if;
794:
795: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
796: aso_debug_pub.add('Inside Get_line_Payment_term'||l_pmnt_term_id,1,'N');
797: END IF;
798: RETURN l_pmnt_term_id;
799: END Get_line_Payment_term;

Line 796: aso_debug_pub.add('Inside Get_line_Payment_term'||l_pmnt_term_id,1,'N');

792: CLOSE get_hdr_pmnt_term;
793: end if;
794:
795: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
796: aso_debug_pub.add('Inside Get_line_Payment_term'||l_pmnt_term_id,1,'N');
797: END IF;
798: RETURN l_pmnt_term_id;
799: END Get_line_Payment_term;
800:

Line 820: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

816:
817: x_freight_terms_code VARCHAR2(30);
818:
819: BEGIN
820: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
821: aso_debug_pub.add('Get_freight_terms_code - Begin ',1,'Y');
822: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_qte_line_id),'null'),1,'N');
823: END IF;
824:

Line 821: aso_debug_pub.add('Get_freight_terms_code - Begin ',1,'Y');

817: x_freight_terms_code VARCHAR2(30);
818:
819: BEGIN
820: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
821: aso_debug_pub.add('Get_freight_terms_code - Begin ',1,'Y');
822: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_qte_line_id),'null'),1,'N');
823: END IF;
824:
825: OPEN C_line_freight_terms_code;

Line 822: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_qte_line_id),'null'),1,'N');

818:
819: BEGIN
820: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
821: aso_debug_pub.add('Get_freight_terms_code - Begin ',1,'Y');
822: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_qte_line_id),'null'),1,'N');
823: END IF;
824:
825: OPEN C_line_freight_terms_code;
826: FETCH C_line_freight_terms_code INTO x_freight_terms_code;

Line 828: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

824:
825: OPEN C_line_freight_terms_code;
826: FETCH C_line_freight_terms_code INTO x_freight_terms_code;
827:
828: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
829: aso_debug_pub.add('Line Level x_freight_terms_code: '||nvl(x_freight_terms_code,'null'),1,'N');
830: END IF;
831:
832: IF (C_line_freight_terms_code%NOTFOUND) THEN

Line 829: aso_debug_pub.add('Line Level x_freight_terms_code: '||nvl(x_freight_terms_code,'null'),1,'N');

825: OPEN C_line_freight_terms_code;
826: FETCH C_line_freight_terms_code INTO x_freight_terms_code;
827:
828: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
829: aso_debug_pub.add('Line Level x_freight_terms_code: '||nvl(x_freight_terms_code,'null'),1,'N');
830: END IF;
831:
832: IF (C_line_freight_terms_code%NOTFOUND) THEN
833:

Line 834: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

830: END IF;
831:
832: IF (C_line_freight_terms_code%NOTFOUND) THEN
833:
834: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
835: aso_debug_pub.add('Inside first IF statement ',1,'N');
836: END IF;
837:
838: CLOSE C_line_freight_terms_code;

Line 835: aso_debug_pub.add('Inside first IF statement ',1,'N');

831:
832: IF (C_line_freight_terms_code%NOTFOUND) THEN
833:
834: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
835: aso_debug_pub.add('Inside first IF statement ',1,'N');
836: END IF;
837:
838: CLOSE C_line_freight_terms_code;
839:

Line 843: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

839:
840: OPEN C_hdr_freight_terms_code;
841: FETCH C_hdr_freight_terms_code INTO x_freight_terms_code;
842:
843: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
844: aso_debug_pub.add('Header Level x_freight_terms_code: '||nvl(x_freight_terms_code,'null'),1,'N');
845: END IF;
846:
847: IF (C_hdr_freight_terms_code%FOUND AND (x_freight_terms_code <> FND_API.G_MISS_CHAR)) THEN

Line 844: aso_debug_pub.add('Header Level x_freight_terms_code: '||nvl(x_freight_terms_code,'null'),1,'N');

840: OPEN C_hdr_freight_terms_code;
841: FETCH C_hdr_freight_terms_code INTO x_freight_terms_code;
842:
843: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
844: aso_debug_pub.add('Header Level x_freight_terms_code: '||nvl(x_freight_terms_code,'null'),1,'N');
845: END IF;
846:
847: IF (C_hdr_freight_terms_code%FOUND AND (x_freight_terms_code <> FND_API.G_MISS_CHAR)) THEN
848: CLOSE C_hdr_freight_terms_code;

Line 886: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

882: x_ship_method_code VARCHAR2(30);
883:
884: BEGIN
885:
886: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
887: aso_debug_pub.add('Get_shipping_method_code - Begin ',1,'Y');
888: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_qte_line_id),'null'),1,'N');
889: END IF;
890:

Line 887: aso_debug_pub.add('Get_shipping_method_code - Begin ',1,'Y');

883:
884: BEGIN
885:
886: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
887: aso_debug_pub.add('Get_shipping_method_code - Begin ',1,'Y');
888: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_qte_line_id),'null'),1,'N');
889: END IF;
890:
891: OPEN C_line_ship_method_code;

Line 888: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_qte_line_id),'null'),1,'N');

884: BEGIN
885:
886: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
887: aso_debug_pub.add('Get_shipping_method_code - Begin ',1,'Y');
888: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_qte_line_id),'null'),1,'N');
889: END IF;
890:
891: OPEN C_line_ship_method_code;
892: FETCH C_line_ship_method_code INTO x_ship_method_code;

Line 894: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

890:
891: OPEN C_line_ship_method_code;
892: FETCH C_line_ship_method_code INTO x_ship_method_code;
893:
894: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
895: aso_debug_pub.add('Line Level x_ship_method_code: '||nvl(x_ship_method_code,'null'),1,'N');
896: END IF;
897:
898: IF (C_line_ship_method_code%NOTFOUND) THEN

Line 895: aso_debug_pub.add('Line Level x_ship_method_code: '||nvl(x_ship_method_code,'null'),1,'N');

891: OPEN C_line_ship_method_code;
892: FETCH C_line_ship_method_code INTO x_ship_method_code;
893:
894: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
895: aso_debug_pub.add('Line Level x_ship_method_code: '||nvl(x_ship_method_code,'null'),1,'N');
896: END IF;
897:
898: IF (C_line_ship_method_code%NOTFOUND) THEN
899:

Line 900: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

896: END IF;
897:
898: IF (C_line_ship_method_code%NOTFOUND) THEN
899:
900: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
901: aso_debug_pub.add('Inside first IF statement ',1,'N');
902: END IF;
903:
904: CLOSE C_line_ship_method_code;

Line 901: aso_debug_pub.add('Inside first IF statement ',1,'N');

897:
898: IF (C_line_ship_method_code%NOTFOUND) THEN
899:
900: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
901: aso_debug_pub.add('Inside first IF statement ',1,'N');
902: END IF;
903:
904: CLOSE C_line_ship_method_code;
905: OPEN C_hdr_ship_method_code;

Line 908: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

904: CLOSE C_line_ship_method_code;
905: OPEN C_hdr_ship_method_code;
906: FETCH C_hdr_ship_method_code INTO x_ship_method_code;
907:
908: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
909: aso_debug_pub.add('Header Level x_ship_method_code: '||nvl(x_ship_method_code,'null'),1,'N');
910: END IF;
911:
912: IF (C_hdr_ship_method_code%FOUND AND (x_ship_method_code <> FND_API.G_MISS_CHAR)) THEN

Line 909: aso_debug_pub.add('Header Level x_ship_method_code: '||nvl(x_ship_method_code,'null'),1,'N');

905: OPEN C_hdr_ship_method_code;
906: FETCH C_hdr_ship_method_code INTO x_ship_method_code;
907:
908: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
909: aso_debug_pub.add('Header Level x_ship_method_code: '||nvl(x_ship_method_code,'null'),1,'N');
910: END IF;
911:
912: IF (C_hdr_ship_method_code%FOUND AND (x_ship_method_code <> FND_API.G_MISS_CHAR)) THEN
913: CLOSE C_hdr_ship_method_code;

Line 954: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

950: where quote_line_id = x_top_model_line_id;
951:
952:
953: BEGIN
954: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
955: aso_debug_pub.add('Get_top_model_item_id - Begin ',1,'Y');
956: aso_debug_pub.add('Get_top_model_item_id G_LINE_REC.MODEL_ID '||ASO_PRICING_INT.G_LINE_REC.MODEL_ID,1,'Y');
957: END IF;
958: /* iStore Cataloge is directly setting G_LINE_REC.model_id,Hence we need to return the same value*/

Line 955: aso_debug_pub.add('Get_top_model_item_id - Begin ',1,'Y');

951:
952:
953: BEGIN
954: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
955: aso_debug_pub.add('Get_top_model_item_id - Begin ',1,'Y');
956: aso_debug_pub.add('Get_top_model_item_id G_LINE_REC.MODEL_ID '||ASO_PRICING_INT.G_LINE_REC.MODEL_ID,1,'Y');
957: END IF;
958: /* iStore Cataloge is directly setting G_LINE_REC.model_id,Hence we need to return the same value*/
959: IF ASO_PRICING_INT.G_LINE_REC.MODEL_ID IS NOT NULL AND ASO_PRICING_INT.G_LINE_REC.MODEL_ID <> FND_API.G_MISS_NUM THEN

Line 956: aso_debug_pub.add('Get_top_model_item_id G_LINE_REC.MODEL_ID '||ASO_PRICING_INT.G_LINE_REC.MODEL_ID,1,'Y');

952:
953: BEGIN
954: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
955: aso_debug_pub.add('Get_top_model_item_id - Begin ',1,'Y');
956: aso_debug_pub.add('Get_top_model_item_id G_LINE_REC.MODEL_ID '||ASO_PRICING_INT.G_LINE_REC.MODEL_ID,1,'Y');
957: END IF;
958: /* iStore Cataloge is directly setting G_LINE_REC.model_id,Hence we need to return the same value*/
959: IF ASO_PRICING_INT.G_LINE_REC.MODEL_ID IS NOT NULL AND ASO_PRICING_INT.G_LINE_REC.MODEL_ID <> FND_API.G_MISS_NUM THEN
960: Return ASO_PRICING_INT.G_LINE_REC.MODEL_ID;

Line 962: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

958: /* iStore Cataloge is directly setting G_LINE_REC.model_id,Hence we need to return the same value*/
959: IF ASO_PRICING_INT.G_LINE_REC.MODEL_ID IS NOT NULL AND ASO_PRICING_INT.G_LINE_REC.MODEL_ID <> FND_API.G_MISS_NUM THEN
960: Return ASO_PRICING_INT.G_LINE_REC.MODEL_ID;
961: END IF;
962: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
963: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_qte_line_id),'null'),1,'N');
964: END IF;
965:
966: x_top_model_line_id := p_qte_line_id;

Line 963: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_qte_line_id),'null'),1,'N');

959: IF ASO_PRICING_INT.G_LINE_REC.MODEL_ID IS NOT NULL AND ASO_PRICING_INT.G_LINE_REC.MODEL_ID <> FND_API.G_MISS_NUM THEN
960: Return ASO_PRICING_INT.G_LINE_REC.MODEL_ID;
961: END IF;
962: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
963: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_qte_line_id),'null'),1,'N');
964: END IF;
965:
966: x_top_model_line_id := p_qte_line_id;
967:

Line 971: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

967:
968: OPEN C_top_model_line_id(x_top_model_line_id);
969: FETCH C_top_model_line_id INTO lv_quote_line_id;
970:
971: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
972: aso_debug_pub.add('Before loop - lv_quote_line_id: '||nvl(to_char(lv_quote_line_id),'null'),1,'N');
973: END IF;
974:
975: IF (C_top_model_line_id%NOTFOUND) THEN

Line 972: aso_debug_pub.add('Before loop - lv_quote_line_id: '||nvl(to_char(lv_quote_line_id),'null'),1,'N');

968: OPEN C_top_model_line_id(x_top_model_line_id);
969: FETCH C_top_model_line_id INTO lv_quote_line_id;
970:
971: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
972: aso_debug_pub.add('Before loop - lv_quote_line_id: '||nvl(to_char(lv_quote_line_id),'null'),1,'N');
973: END IF;
974:
975: IF (C_top_model_line_id%NOTFOUND) THEN
976: CLOSE C_top_model_line_id;

Line 986: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

982: Loop
983: OPEN C_top_model_line_id(x_top_model_line_id);
984: FETCH C_top_model_line_id INTO lv_quote_line_id;
985:
986: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
987: aso_debug_pub.add('Inside Loop - lv_quote_line_id: '||nvl(to_char(lv_quote_line_id),'null'),1,'N');
988: END IF;
989:
990: IF (C_top_model_line_id%NOTFOUND) THEN

Line 987: aso_debug_pub.add('Inside Loop - lv_quote_line_id: '||nvl(to_char(lv_quote_line_id),'null'),1,'N');

983: OPEN C_top_model_line_id(x_top_model_line_id);
984: FETCH C_top_model_line_id INTO lv_quote_line_id;
985:
986: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
987: aso_debug_pub.add('Inside Loop - lv_quote_line_id: '||nvl(to_char(lv_quote_line_id),'null'),1,'N');
988: END IF;
989:
990: IF (C_top_model_line_id%NOTFOUND) THEN
991: CLOSE C_top_model_line_id;

Line 1031: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1027: AND l.organization_id = i.organization_id
1028: AND i.shippable_item_flag = 'Y' );
1029:
1030: BEGIN
1031: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1032: aso_debug_pub.add('Inside Get_header_ship_flag',1,'N');
1033: aso_debug_pub.add('p_qte_header_id: '||nvl(to_char(p_qte_header_id),'null'),1,'N');
1034: END IF;
1035:

Line 1032: aso_debug_pub.add('Inside Get_header_ship_flag',1,'N');

1028: AND i.shippable_item_flag = 'Y' );
1029:
1030: BEGIN
1031: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1032: aso_debug_pub.add('Inside Get_header_ship_flag',1,'N');
1033: aso_debug_pub.add('p_qte_header_id: '||nvl(to_char(p_qte_header_id),'null'),1,'N');
1034: END IF;
1035:
1036: --SELECT count(*)

Line 1033: aso_debug_pub.add('p_qte_header_id: '||nvl(to_char(p_qte_header_id),'null'),1,'N');

1029:
1030: BEGIN
1031: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1032: aso_debug_pub.add('Inside Get_header_ship_flag',1,'N');
1033: aso_debug_pub.add('p_qte_header_id: '||nvl(to_char(p_qte_header_id),'null'),1,'N');
1034: END IF;
1035:
1036: --SELECT count(*)
1037: -- INTO x_count

Line 1060: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1056: else
1057: x_shippable_item_flag:='N';
1058: end if;
1059: end loop;
1060: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1061: aso_debug_pub.add('x_shippable_item_flag: '||x_shippable_item_flag,1,'N');
1062: END IF;
1063:
1064: RETURN x_shippable_item_flag;

Line 1061: aso_debug_pub.add('x_shippable_item_flag: '||x_shippable_item_flag,1,'N');

1057: x_shippable_item_flag:='N';
1058: end if;
1059: end loop;
1060: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1061: aso_debug_pub.add('x_shippable_item_flag: '||x_shippable_item_flag,1,'N');
1062: END IF;
1063:
1064: RETURN x_shippable_item_flag;
1065: EXCEPTION

Line 1072: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1068:
1069: -- EXCEPTION
1070: -- WHEN no_data_found THEN
1071: -- x_shippable_item_flag := null;
1072: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1073: aso_debug_pub.add('Inside Get_header_ship_flag '||x_shippable_item_flag,1,'N');
1074: END IF;
1075:
1076: END get_header_ship_flag;

Line 1073: aso_debug_pub.add('Inside Get_header_ship_flag '||x_shippable_item_flag,1,'N');

1069: -- EXCEPTION
1070: -- WHEN no_data_found THEN
1071: -- x_shippable_item_flag := null;
1072: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1073: aso_debug_pub.add('Inside Get_header_ship_flag '||x_shippable_item_flag,1,'N');
1074: END IF;
1075:
1076: END get_header_ship_flag;
1077:

Line 1091: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1087: FROM aso_quote_line_details qld
1088: WHERE qld.quote_line_id = l_quote_line_id ;
1089:
1090: BEGIN
1091: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1092: aso_debug_pub.add('Inside Get_Parent_List_price',1,'N');
1093: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_quote_line_id),'null'),1,'N');
1094: END IF;
1095: OPEN c_get(p_quote_line_id );

Line 1092: aso_debug_pub.add('Inside Get_Parent_List_price',1,'N');

1088: WHERE qld.quote_line_id = l_quote_line_id ;
1089:
1090: BEGIN
1091: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1092: aso_debug_pub.add('Inside Get_Parent_List_price',1,'N');
1093: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_quote_line_id),'null'),1,'N');
1094: END IF;
1095: OPEN c_get(p_quote_line_id );
1096: FETCH c_get INTO l_SERVICE_REF_TYPE_CODE,l_service_ref_line_id;

Line 1093: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_quote_line_id),'null'),1,'N');

1089:
1090: BEGIN
1091: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1092: aso_debug_pub.add('Inside Get_Parent_List_price',1,'N');
1093: aso_debug_pub.add('p_qte_line_id: '||nvl(to_char(p_quote_line_id),'null'),1,'N');
1094: END IF;
1095: OPEN c_get(p_quote_line_id );
1096: FETCH c_get INTO l_SERVICE_REF_TYPE_CODE,l_service_ref_line_id;
1097:

Line 1110: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1106: from oe_order_lines_All
1107: where line_id = l_service_ref_line_id;
1108: END IF;
1109: Close c_get;
1110: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1111: aso_debug_pub.add('Inside Get_Parent_List_price'||x_list_price,1,'N');
1112: END IF;
1113: return x_list_price;
1114: EXCEPTION

Line 1111: aso_debug_pub.add('Inside Get_Parent_List_price'||x_list_price,1,'N');

1107: where line_id = l_service_ref_line_id;
1108: END IF;
1109: Close c_get;
1110: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1111: aso_debug_pub.add('Inside Get_Parent_List_price'||x_list_price,1,'N');
1112: END IF;
1113: return x_list_price;
1114: EXCEPTION
1115: WHEN OTHERS THEN

Line 1125: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1121: FUNCTION Get_Minisite_Id RETURN NUMBER
1122: IS
1123: x_minisite_id NUMBER := NULL;
1124: BEGIN
1125: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1126: aso_debug_pub.add('Start of Get_Minisite_Id...',1,'N');
1127: aso_debug_pub.add('G_HEADER_REC.minisite_id: '||nvl(to_char(ASO_PRICING_INT.G_HEADER_REC.minisite_id),'null'),1,'N');
1128: aso_debug_pub.add('G_LINE_REC.minisite_id: '||nvl(to_char(ASO_PRICING_INT.G_LINE_REC.minisite_id),'null'),1,'N');
1129: END IF;

Line 1126: aso_debug_pub.add('Start of Get_Minisite_Id...',1,'N');

1122: IS
1123: x_minisite_id NUMBER := NULL;
1124: BEGIN
1125: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1126: aso_debug_pub.add('Start of Get_Minisite_Id...',1,'N');
1127: aso_debug_pub.add('G_HEADER_REC.minisite_id: '||nvl(to_char(ASO_PRICING_INT.G_HEADER_REC.minisite_id),'null'),1,'N');
1128: aso_debug_pub.add('G_LINE_REC.minisite_id: '||nvl(to_char(ASO_PRICING_INT.G_LINE_REC.minisite_id),'null'),1,'N');
1129: END IF;
1130: IF ASO_PRICING_INT.G_LINE_REC.MINISITE_ID IS NOT NULL AND

Line 1127: aso_debug_pub.add('G_HEADER_REC.minisite_id: '||nvl(to_char(ASO_PRICING_INT.G_HEADER_REC.minisite_id),'null'),1,'N');

1123: x_minisite_id NUMBER := NULL;
1124: BEGIN
1125: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1126: aso_debug_pub.add('Start of Get_Minisite_Id...',1,'N');
1127: aso_debug_pub.add('G_HEADER_REC.minisite_id: '||nvl(to_char(ASO_PRICING_INT.G_HEADER_REC.minisite_id),'null'),1,'N');
1128: aso_debug_pub.add('G_LINE_REC.minisite_id: '||nvl(to_char(ASO_PRICING_INT.G_LINE_REC.minisite_id),'null'),1,'N');
1129: END IF;
1130: IF ASO_PRICING_INT.G_LINE_REC.MINISITE_ID IS NOT NULL AND
1131: ASO_PRICING_INT.G_LINE_REC.MINISITE_ID <> FND_API.G_MISS_NUM

Line 1128: aso_debug_pub.add('G_LINE_REC.minisite_id: '||nvl(to_char(ASO_PRICING_INT.G_LINE_REC.minisite_id),'null'),1,'N');

1124: BEGIN
1125: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1126: aso_debug_pub.add('Start of Get_Minisite_Id...',1,'N');
1127: aso_debug_pub.add('G_HEADER_REC.minisite_id: '||nvl(to_char(ASO_PRICING_INT.G_HEADER_REC.minisite_id),'null'),1,'N');
1128: aso_debug_pub.add('G_LINE_REC.minisite_id: '||nvl(to_char(ASO_PRICING_INT.G_LINE_REC.minisite_id),'null'),1,'N');
1129: END IF;
1130: IF ASO_PRICING_INT.G_LINE_REC.MINISITE_ID IS NOT NULL AND
1131: ASO_PRICING_INT.G_LINE_REC.MINISITE_ID <> FND_API.G_MISS_NUM
1132: THEN

Line 1139: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

1135: ASO_PRICING_INT.G_HEADER_REC.MINISITE_ID <> FND_API.G_MISS_NUM
1136: THEN
1137: x_minisite_id := ASO_PRICING_INT.G_HEADER_REC.MINISITE_ID;
1138: END IF;
1139: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1140: aso_debug_pub.add('After Get_Minisite_Id...x_minisite_id :'||x_minisite_id,1,'N');
1141: END IF;
1142: RETURN x_minisite_id;
1143: EXCEPTION

Line 1140: aso_debug_pub.add('After Get_Minisite_Id...x_minisite_id :'||x_minisite_id,1,'N');

1136: THEN
1137: x_minisite_id := ASO_PRICING_INT.G_HEADER_REC.MINISITE_ID;
1138: END IF;
1139: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1140: aso_debug_pub.add('After Get_Minisite_Id...x_minisite_id :'||x_minisite_id,1,'N');
1141: END IF;
1142: RETURN x_minisite_id;
1143: EXCEPTION
1144: WHEN OTHERS THEN