APPS.ASO_PRICING_CORE_PVT dependencies on FND_API

Line 294: OR l_line_rec.INVOICE_TO_PARTY_SITE_ID = fnd_api.g_miss_num then

290: l_line_rec.ORDER_LINE_TYPE_ID := p_qte_line_rec.ORDER_LINE_TYPE_ID;
291: l_line_rec.INVOICE_TO_PARTY_SITE_ID := p_qte_line_rec.INVOICE_TO_PARTY_SITE_ID;
292: -- added for sourcing rule match on 06/06/01
293: If l_line_rec.INVOICE_TO_PARTY_SITE_ID is NULL
294: OR l_line_rec.INVOICE_TO_PARTY_SITE_ID = fnd_api.g_miss_num then
295: l_line_rec.INVOICE_TO_PARTY_SITE_ID := ASO_PRICING_INT.G_HEADER_REC.INVOICE_TO_PARTY_SITE_ID;
296: End if;
297: l_line_rec.INVOICE_TO_PARTY_ID := p_qte_line_rec.INVOICE_TO_PARTY_ID;
298: l_line_rec.ORGANIZATION_ID := p_qte_line_rec.ORGANIZATION_ID;

Line 305: If (l_line_rec.PRICE_LIST_ID is NULL OR l_line_rec.PRICE_LIST_ID = fnd_api.g_miss_num) then

301: l_line_rec.UOM_CODE := p_qte_line_rec.UOM_CODE;
302: l_line_rec.MARKETING_SOURCE_CODE_ID := p_qte_line_rec.MARKETING_SOURCE_CODE_ID;
303: l_line_rec.PRICE_LIST_ID := p_qte_line_rec.PRICE_LIST_ID;
304: -- added for sourcing rule match on 06/06/01
305: If (l_line_rec.PRICE_LIST_ID is NULL OR l_line_rec.PRICE_LIST_ID = fnd_api.g_miss_num) then
306: l_line_rec.PRICE_LIST_ID := ASO_PRICING_INT.G_HEADER_REC.PRICE_LIST_ID;
307: End If;
308:
309: If (NVL(p_qte_line_rec.PRICING_LINE_TYPE_INDICATOR,'X') = 'F') then

Line 330: If (l_line_rec.AGREEMENT_ID is NULL OR l_line_rec.AGREEMENT_ID = fnd_api.g_miss_num) then

326: l_line_rec.SELLING_PRICE_CHANGE := p_qte_line_rec.SELLING_PRICE_CHANGE;
327: l_line_rec.PRICING_LINE_TYPE_INDICATOR := p_qte_line_rec.PRICING_LINE_TYPE_INDICATOR;
328: l_line_rec.MINISITE_ID := p_qte_line_rec.MINISITE_ID;
329: l_line_rec.AGREEMENT_ID := p_qte_line_rec.AGREEMENT_ID;
330: If (l_line_rec.AGREEMENT_ID is NULL OR l_line_rec.AGREEMENT_ID = fnd_api.g_miss_num) then
331: l_line_rec.AGREEMENT_ID := ASO_PRICING_INT.G_HEADER_REC.CONTRACT_ID;
332: End If;
333: l_line_rec.ATTRIBUTE_CATEGORY := p_qte_line_rec.ATTRIBUTE_CATEGORY;
334: l_line_rec.ATTRIBUTE1 := p_qte_line_rec.ATTRIBUTE1;

Line 369: OR l_line_rec.REQUEST_DATE = fnd_api.g_miss_date then

365:
366: l_line_rec.PROMISE_DATE := p_shipment_rec.PROMISE_DATE;
367: l_line_rec.REQUEST_DATE := p_shipment_rec.REQUEST_DATE;
368: If l_line_rec.REQUEST_DATE is NULL
369: OR l_line_rec.REQUEST_DATE = fnd_api.g_miss_date then
370: l_line_rec.REQUEST_DATE := ASO_PRICING_INT.G_HEADER_REC.REQUEST_DATE;
371: End If;
372: l_line_rec.SCHEDULE_SHIP_DATE := p_shipment_rec.SCHEDULE_SHIP_DATE;
373: l_line_rec.SHIP_TO_PARTY_SITE_ID := p_shipment_rec.SHIP_TO_PARTY_SITE_ID;

Line 376: OR l_line_rec.SHIP_TO_PARTY_SITE_ID = fnd_api.g_miss_num then

372: l_line_rec.SCHEDULE_SHIP_DATE := p_shipment_rec.SCHEDULE_SHIP_DATE;
373: l_line_rec.SHIP_TO_PARTY_SITE_ID := p_shipment_rec.SHIP_TO_PARTY_SITE_ID;
374: -- added for sourcing rule match on 06/06/01
375: if l_line_rec.SHIP_TO_PARTY_SITE_ID is NULL
376: OR l_line_rec.SHIP_TO_PARTY_SITE_ID = fnd_api.g_miss_num then
377: l_line_rec.SHIP_TO_PARTY_SITE_ID := ASO_PRICING_INT.G_HEADER_REC.SHIP_TO_PARTY_SITE_ID;
378: End if;
379: l_line_rec.SHIP_TO_PARTY_ID := p_shipment_rec.SHIP_TO_PARTY_ID;
380: l_line_rec.SHIP_PARTIAL_FLAG := p_shipment_rec.SHIP_PARTIAL_FLAG;

Line 385: OR l_line_rec.SHIP_METHOD_CODE = fnd_api.g_miss_char then

381: l_line_rec.SHIP_SET_ID := p_shipment_rec.SHIP_SET_ID;
382: l_line_rec.SHIP_METHOD_CODE := p_shipment_rec.SHIP_METHOD_CODE;
383: -- added for sourcing rule match on 06/06/01
384: If l_line_rec.SHIP_METHOD_CODE is NULL
385: OR l_line_rec.SHIP_METHOD_CODE = fnd_api.g_miss_char then
386: l_line_rec.SHIP_METHOD_CODE := ASO_PRICING_INT.G_HEADER_REC.SHIP_METHOD_CODE;
387: End If;
388: l_line_rec.FREIGHT_TERMS_CODE := p_shipment_rec.FREIGHT_TERMS_CODE;
389: -- added for sourcing rule match on 06/06/01

Line 391: OR l_line_rec.FREIGHT_TERMS_CODE = fnd_api.g_miss_char then

387: End If;
388: l_line_rec.FREIGHT_TERMS_CODE := p_shipment_rec.FREIGHT_TERMS_CODE;
389: -- added for sourcing rule match on 06/06/01
390: If l_line_rec.FREIGHT_TERMS_CODE is NULL
391: OR l_line_rec.FREIGHT_TERMS_CODE = fnd_api.g_miss_char then
392: l_line_rec.FREIGHT_TERMS_CODE := ASO_PRICING_INT.G_HEADER_REC.FREIGHT_TERMS_CODE;
393: End If;
394: l_line_rec.FREIGHT_CARRIER_CODE := p_shipment_rec.FREIGHT_CARRIER_CODE;
395: If l_line_rec.FREIGHT_CARRIER_CODE is NULL

Line 396: OR l_line_rec.FREIGHT_CARRIER_CODE = fnd_api.g_miss_char then

392: l_line_rec.FREIGHT_TERMS_CODE := ASO_PRICING_INT.G_HEADER_REC.FREIGHT_TERMS_CODE;
393: End If;
394: l_line_rec.FREIGHT_CARRIER_CODE := p_shipment_rec.FREIGHT_CARRIER_CODE;
395: If l_line_rec.FREIGHT_CARRIER_CODE is NULL
396: OR l_line_rec.FREIGHT_CARRIER_CODE = fnd_api.g_miss_char then
397: l_line_rec.FREIGHT_CARRIER_CODE := ASO_PRICING_INT.G_HEADER_REC.FREIGHT_CARRIER_CODE;
398: End If;
399: l_line_rec.FOB_CODE := p_shipment_rec.FOB_CODE;
400: If l_line_rec.FOB_CODE is NULL

Line 401: OR l_line_rec.FOB_CODE = fnd_api.g_miss_char then

397: l_line_rec.FREIGHT_CARRIER_CODE := ASO_PRICING_INT.G_HEADER_REC.FREIGHT_CARRIER_CODE;
398: End If;
399: l_line_rec.FOB_CODE := p_shipment_rec.FOB_CODE;
400: If l_line_rec.FOB_CODE is NULL
401: OR l_line_rec.FOB_CODE = fnd_api.g_miss_char then
402: l_line_rec.FOB_CODE := ASO_PRICING_INT.G_HEADER_REC.FOB_CODE;
403: End If;
404: l_line_rec.SHIPPING_INSTRUCTIONS := p_shipment_rec.SHIPPING_INSTRUCTIONS;
405: l_line_rec.PACKING_INSTRUCTIONS := p_shipment_rec.PACKING_INSTRUCTIONS;

Line 414: If l_line_rec.MODEL_ID is NULL OR l_line_rec.MODEL_ID = fnd_api.g_miss_num then

410: l_line_rec.SHIPMENT_PRIORITY_CODE := p_shipment_rec.SHIPMENT_PRIORITY_CODE;
411: --education change: added to check model id
412: --Changed again to fix the bundle item bug fix: changed to obtain the model via cursor
413: --rather than using the get_top_model_item_id() function.
414: If l_line_rec.MODEL_ID is NULL OR l_line_rec.MODEL_ID = fnd_api.g_miss_num then
415: OPEN C_top_model_item_id( p_qte_line_dtl_rec.CONFIG_HEADER_ID,
416: p_qte_line_dtl_rec.CONFIG_REVISION_NUM);
417: FETCH C_top_model_item_id INTO l_inventory_item_id;
418: CLOSE C_top_model_item_id;

Line 456: AND p_quote_header_id <> FND_API.G_MISS_NUM)

452: QP_LIST_LINES B
453: WHERE lines.line_id = p_quote_header_id
454: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
455: AND (p_quote_header_id IS NOT NULL
456: AND p_quote_header_id <> FND_API.G_MISS_NUM)
457: AND lines.line_index = a.line_index
458: AND A.CREATED_FROM_LIST_LINE_TYPE = QP_PREQ_GRP.G_TERMS_SUBSTITUTION
459: AND a.applied_flag = G_YES_FLAG
460: AND a.modifier_level_code = G_ORDER_LEVEL

Line 477: AND p_quote_header_id <> FND_API.G_MISS_NUM)

473: RA_TERMS_B ratv
474: WHERE lines.line_id = p_quote_header_id
475: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
476: AND (p_quote_header_id IS NOT NULL
477: AND p_quote_header_id <> FND_API.G_MISS_NUM)
478: AND lines.line_index = a.line_index
479: AND b.substitution_attribute = G_QUAL_ATTRIBUTE1
480: AND A.CREATED_FROM_LIST_LINE_TYPE = QP_PREQ_GRP.G_TERMS_SUBSTITUTION
481: AND a.applied_flag = G_YES_FLAG

Line 500: AND p_quote_header_id <> FND_API.G_MISS_NUM)

496: QP_LIST_LINES B
497: WHERE lines.line_id = p_quote_header_id
498: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
499: AND (p_quote_header_id IS NOT NULL
500: AND p_quote_header_id <> FND_API.G_MISS_NUM)
501: AND lines.line_index = a.line_index
502: AND b.substitution_attribute = G_QUAL_ATTRIBUTE11
503: AND A.CREATED_FROM_LIST_LINE_TYPE = QP_PREQ_GRP.G_TERMS_SUBSTITUTION
504: AND a.applied_flag = G_YES_FLAG

Line 522: AND p_quote_header_id <> FND_API.G_MISS_NUM)

518: fnd_lookup_values olk
519: WHERE lines.line_id = p_quote_header_id
520: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
521: AND (p_quote_header_id IS NOT NULL
522: AND p_quote_header_id <> FND_API.G_MISS_NUM)
523: AND lines.line_index = a.line_index
524: AND b.substitution_attribute = G_QUAL_ATTRIBUTE10
525: AND A.CREATED_FROM_LIST_LINE_TYPE = G_TERMS_SUBSTITUTION
526: AND a.applied_flag = G_YES_FLAG

Line 606: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)

602: IF l_payment_id IS NOT NULL THEN
603: UPDATE ASO_PAYMENTS
604: SET payment_term_id = payment_term_id_from
605: WHERE quote_header_id = p_quote_header_id
606: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
607: AND quote_line_id IS NULL;
608: END IF;
609: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
610: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Payment Rows Updated : '||sql%ROWCOUNT,1,'Y');

Line 687: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)

683: THEN
684: UPDATE ASO_PAYMENTS
685: SET payment_term_id = l_req_payment_term_id
686: WHERE quote_header_id = p_quote_header_id
687: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
688: AND quote_line_id IS NULL;
689: END IF;
690: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
691: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Payment Rows Updated : '||sql%ROWCOUNT,1,'Y');

Line 719: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)

715: THEN
716: UPDATE ASO_SHIPMENTS aso
717: SET aso.ship_method_code = ship_method_code_from
718: WHERE quote_header_id = p_quote_header_id
719: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
720: AND quote_line_id IS NULL;
721: END IF;
722: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
723: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Ship Method Code Rows Updated : '||sql%ROWCOUNT,1,'Y');

Line 808: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)

804: THEN
805: UPDATE ASO_SHIPMENTS aso
806: SET aso.ship_method_code = l_req_ship_method_code
807: WHERE quote_header_id = p_quote_header_id
808: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
809: AND quote_line_id IS NULL
810: AND ('S' = (ASO_VALIDATE_PVT.Validate_ShipMethods('T', l_req_ship_method_code,
811: aso.ship_from_org_id, p_quote_header_id, NULL)));
812: END IF;

Line 840: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)

836: IF l_freight_shipment_id IS NOT NULL THEN
837: UPDATE ASO_SHIPMENTS aso
838: SET aso.freight_terms_code = freight_terms_code_from
839: WHERE quote_header_id = p_quote_header_id
840: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
841: AND quote_line_id IS NULL;
842: END IF;
843: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
844: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Freight Terms Code Rows Updated : '||sql%ROWCOUNT,1,'Y');

Line 928: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)

924: IF l_freight_shipment_id IS NOT NULL or lx_freight_shipment_id IS NOT NULL THEN
925: UPDATE ASO_SHIPMENTS aso
926: SET aso.freight_terms_code = l_req_freight_terms_code
927: WHERE quote_header_id = p_quote_header_id
928: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
929: AND quote_line_id IS NULL;
930: END IF;
931: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
932: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Freight Terms Code Rows Updated : '||sql%ROWCOUNT,1,'Y');

Line 966: AND lines.line_id <> FND_API.G_MISS_NUM)

962: QP_LIST_LINES B
963: WHERE lines.line_id = p_quote_line_id
964: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
965: AND (lines.line_id IS NOT NULL
966: AND lines.line_id <> FND_API.G_MISS_NUM)
967: AND lines.line_index = a.line_index
968: AND A.CREATED_FROM_LIST_LINE_TYPE = QP_PREQ_GRP.G_TERMS_SUBSTITUTION
969: AND a.applied_flag = G_YES_FLAG
970: AND a.modifier_level_code = G_LINE_LEVEL

Line 986: AND lines.line_id <> FND_API.G_MISS_NUM)

982: QP_LIST_LINES B
983: WHERE lines.line_id = p_quote_line_id
984: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
985: AND (lines.line_id IS NOT NULL
986: AND lines.line_id <> FND_API.G_MISS_NUM)
987: AND lines.line_index = a.line_index
988: AND b.substitution_attribute = G_QUAL_ATTRIBUTE11
989: AND A.CREATED_FROM_LIST_LINE_TYPE = QP_PREQ_GRP.G_TERMS_SUBSTITUTION
990: AND a.applied_flag = G_YES_FLAG

Line 1008: AND lines.line_id <> FND_API.G_MISS_NUM)

1004: fnd_lookup_values olk
1005: WHERE lines.line_id = p_quote_line_id
1006: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
1007: AND (lines.line_id IS NOT NULL
1008: AND lines.line_id <> FND_API.G_MISS_NUM)
1009: AND lines.line_index = a.line_index
1010: AND b.substitution_attribute = G_QUAL_ATTRIBUTE10
1011: AND A.CREATED_FROM_LIST_LINE_TYPE = G_TERMS_SUBSTITUTION
1012: AND a.applied_flag = G_YES_FLAG

Line 1056: AND lines.line_id <> FND_API.G_MISS_NUM)

1052: RA_TERMS_B ratv
1053: WHERE lines.line_id = p_quote_line_id
1054: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
1055: AND (lines.line_id IS NOT NULL
1056: AND lines.line_id <> FND_API.G_MISS_NUM)
1057: AND lines.line_index = a.line_index
1058: AND b.substitution_attribute = G_QUAL_ATTRIBUTE1
1059: AND A.CREATED_FROM_LIST_LINE_TYPE = QP_PREQ_GRP.G_TERMS_SUBSTITUTION
1060: AND a.applied_flag = G_YES_FLAG

Line 1219: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)

1215: END IF;
1216: UPDATE ASO_SHIPMENTS aso
1217: SET aso.ship_method_code = ship_method_code_from
1218: WHERE aso.quote_header_id = p_quote_header_id
1219: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1220: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1221: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1222: AND aso.quote_line_id IS NOT NULL;
1223: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1221: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)

1217: SET aso.ship_method_code = ship_method_code_from
1218: WHERE aso.quote_header_id = p_quote_header_id
1219: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1220: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1221: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1222: AND aso.quote_line_id IS NOT NULL;
1223: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1224: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Ship Method Code Rows Updated : '||sql%ROWCOUNT,1,'Y');
1225: END IF;

Line 1234: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)

1230: END IF;
1231: UPDATE ASO_SHIPMENTS aso
1232: SET aso.ship_method_code = l_req_ship_method_code
1233: WHERE aso.quote_header_id = p_quote_header_id
1234: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1235: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1236: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1237: AND aso.quote_line_id IS NOT NULL
1238: AND ('S' = (ASO_VALIDATE_PVT.Validate_ShipMethods('T', l_req_ship_method_code,

Line 1236: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)

1232: SET aso.ship_method_code = l_req_ship_method_code
1233: WHERE aso.quote_header_id = p_quote_header_id
1234: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1235: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1236: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1237: AND aso.quote_line_id IS NOT NULL
1238: AND ('S' = (ASO_VALIDATE_PVT.Validate_ShipMethods('T', l_req_ship_method_code,
1239: aso.ship_from_org_id, p_quote_header_id, l_qte_ln_rec.quote_line_id)));
1240: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1260: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)

1256: END IF;
1257: UPDATE ASO_SHIPMENTS aso
1258: SET aso.freight_terms_code = freight_terms_code_from
1259: WHERE aso.quote_header_id = p_quote_header_id
1260: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1261: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1262: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1263: AND aso.quote_line_id IS NOT NULL;
1264: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1262: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)

1258: SET aso.freight_terms_code = freight_terms_code_from
1259: WHERE aso.quote_header_id = p_quote_header_id
1260: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1261: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1262: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1263: AND aso.quote_line_id IS NOT NULL;
1264: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1265: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Freight Terms Code Rows Updated : '||sql%ROWCOUNT,1,'Y');
1266: END IF;

Line 1275: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)

1271: END IF;
1272: UPDATE ASO_SHIPMENTS aso
1273: SET aso.freight_terms_code = l_req_freight_terms_code
1274: WHERE aso.quote_header_id = p_quote_header_id
1275: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1276: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1277: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1278: AND aso.quote_line_id IS NOT NULL;
1279: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1277: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)

1273: SET aso.freight_terms_code = l_req_freight_terms_code
1274: WHERE aso.quote_header_id = p_quote_header_id
1275: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1276: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1277: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1278: AND aso.quote_line_id IS NOT NULL;
1279: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1280: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Freight Terms Code Rows Updated : '||sql%ROWCOUNT,1,'Y');
1281: END IF;

Line 1429: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)

1425: END IF;
1426: UPDATE ASO_SHIPMENTS aso
1427: SET aso.ship_method_code = ship_method_code_from
1428: WHERE aso.quote_header_id = p_quote_header_id
1429: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1430: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1431: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1432: AND aso.quote_line_id IS NOT NULL;
1433: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1431: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)

1427: SET aso.ship_method_code = ship_method_code_from
1428: WHERE aso.quote_header_id = p_quote_header_id
1429: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1430: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1431: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1432: AND aso.quote_line_id IS NOT NULL;
1433: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1434: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Ship Method Code Rows Updated : '||sql%ROWCOUNT,1,'Y');
1435: END IF;

Line 1444: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)

1440: END IF;
1441: UPDATE ASO_SHIPMENTS aso
1442: SET aso.ship_method_code = l_req_ship_method_code
1443: WHERE aso.quote_header_id = p_quote_header_id
1444: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1445: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1446: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1447: AND aso.quote_line_id IS NOT NULL
1448: AND ('S' = (ASO_VALIDATE_PVT.Validate_ShipMethods('T', l_req_ship_method_code,

Line 1446: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)

1442: SET aso.ship_method_code = l_req_ship_method_code
1443: WHERE aso.quote_header_id = p_quote_header_id
1444: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1445: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1446: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1447: AND aso.quote_line_id IS NOT NULL
1448: AND ('S' = (ASO_VALIDATE_PVT.Validate_ShipMethods('T', l_req_ship_method_code,
1449: aso.ship_from_org_id, p_quote_header_id, l_qte_ln_rec.quote_line_id)));
1450: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1470: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)

1466: END IF;
1467: UPDATE ASO_SHIPMENTS aso
1468: SET aso.freight_terms_code = freight_terms_code_from
1469: WHERE aso.quote_header_id = p_quote_header_id
1470: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1471: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1472: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1473: AND aso.quote_line_id IS NOT NULL;
1474: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1472: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)

1468: SET aso.freight_terms_code = freight_terms_code_from
1469: WHERE aso.quote_header_id = p_quote_header_id
1470: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1471: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1472: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1473: AND aso.quote_line_id IS NOT NULL;
1474: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1475: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Freight Terms Code Rows Updated : '||sql%ROWCOUNT,1,'Y');
1476: END IF;

Line 1485: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)

1481: END IF;
1482: UPDATE ASO_SHIPMENTS aso
1483: SET aso.freight_terms_code = l_req_freight_terms_code
1484: WHERE aso.quote_header_id = p_quote_header_id
1485: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1486: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1487: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1488: AND aso.quote_line_id IS NOT NULL;
1489: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1487: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)

1483: SET aso.freight_terms_code = l_req_freight_terms_code
1484: WHERE aso.quote_header_id = p_quote_header_id
1485: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1486: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1487: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1488: AND aso.quote_line_id IS NOT NULL;
1489: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1490: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Freight Terms Code Rows Updated : '||sql%ROWCOUNT,1,'Y');
1491: END IF;

Line 6209: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

6205:
6206: G_ATTR_LINE_INDEX_tbl(l_counter) := l_line_index;
6207: G_ATTR_LINE_DETAIL_INDEX_tbl(l_counter) := NULL;
6208: G_ATTR_ATTRIBUTE_LEVEL_tbl(l_counter) := QP_PREQ_GRP.G_LINE_LEVEL;
6209: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
6210: G_ATTR_VALIDATED_FLAG_tbl(l_counter) := QP_PREQ_GRP.G_NOT_VALIDATED;
6211: ELSE
6212: G_ATTR_VALIDATED_FLAG_tbl(l_counter) := QP_PREQ_GRP.G_VALIDATED;
6213: END IF;

Line 6258: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

6254:
6255: G_ATTR_LINE_INDEX_tbl(l_counter) := l_line_index;
6256: G_ATTR_LINE_DETAIL_INDEX_tbl(l_counter) := NULL;
6257: G_ATTR_ATTRIBUTE_LEVEL_tbl(l_counter) := QP_PREQ_GRP.G_LINE_LEVEL;
6258: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
6259: G_ATTR_VALIDATED_FLAG_tbl(l_counter) := QP_PREQ_GRP.G_NOT_VALIDATED;
6260: ELSE
6261: G_ATTR_VALIDATED_FLAG_tbl(l_counter) := QP_PREQ_GRP.G_VALIDATED;
6262: END IF;

Line 6307: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

6303:
6304: G_ATTR_LINE_INDEX_tbl(l_counter) := l_line_index;
6305: G_ATTR_LINE_DETAIL_INDEX_tbl(l_counter) := NULL;
6306: G_ATTR_ATTRIBUTE_LEVEL_tbl(l_counter) := QP_PREQ_GRP.G_LINE_LEVEL;
6307: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
6308: G_ATTR_VALIDATED_FLAG_tbl(l_counter) := QP_PREQ_GRP.G_NOT_VALIDATED;
6309: ELSE
6310: G_ATTR_VALIDATED_FLAG_tbl(l_counter) := QP_PREQ_GRP.G_VALIDATED;
6311: END IF;

Line 6377: if NVL(ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN

6373: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6374: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Copy_Header_To_Req: ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE:'
6375: ||ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE,1,'Y');
6376: END IF;
6377: if NVL(ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
6378: G_PRICING_EFFECTIVE_DATE_TBL(px_index_counter) := trunc(sysdate);
6379: else
6380: G_PRICING_EFFECTIVE_DATE_TBL(px_index_counter) := trunc(ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE);
6381: end if;

Line 6443: if NVL(ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN

6439: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6440: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Copy_Line_To_Request: G_HEADER_REC.PRICE_FROZEN_DATE:'
6441: ||ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE,1,'Y');
6442: END IF;
6443: if NVL(ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
6444: G_PRICING_EFFECTIVE_DATE_TBL(px_index_counter) := trunc(sysdate);
6445: else
6446: G_PRICING_EFFECTIVE_DATE_TBL(px_index_counter) := trunc(ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE);
6447: end if;

Line 6457: AND ASO_PRICING_INT.G_LINE_REC.service_period <> fnd_api.g_miss_char then

6453: G_LINE_UOM_CODE_TBL(px_index_counter) := ASO_PRICING_INT.G_LINE_REC.uom_code;
6454: G_REQUEST_TYPE_CODE_TBL(px_index_counter) := p_Request_Type;
6455: -- Added for Service Item after pathcset E
6456: If ASO_PRICING_INT.G_LINE_REC.service_period is not null
6457: AND ASO_PRICING_INT.G_LINE_REC.service_period <> fnd_api.g_miss_char then
6458: If (ASO_PRICING_INT.G_LINE_REC.service_period = ASO_PRICING_INT.G_LINE_REC.uom_code) Then
6459: G_UOM_QUANTITY_TBL(px_index_counter) := ASO_PRICING_INT.G_LINE_REC.service_duration;
6460: G_CONTRACT_START_DATE_TBL(px_index_counter) := ASO_PRICING_INT.G_LINE_REC.start_date_active;
6461: G_CONTRACT_END_DATE_TBL(px_index_counter) := ASO_PRICING_INT.G_LINE_REC.end_date_active;

Line 6502: If ASO_PRICING_INT.G_LINE_REC.line_list_price <> FND_API.G_MISS_NUM Then

6498: End If;
6499: G_PRICED_QUANTITY_TBL(px_index_counter) := ASO_PRICING_INT.G_LINE_REC.pricing_quantity;
6500: G_PRICED_UOM_CODE_TBL(px_index_counter) := ASO_PRICING_INT.G_LINE_REC.pricing_quantity_uom;
6501: G_CURRENCY_CODE_TBL(px_index_counter) := ASO_PRICING_INT.G_LINE_REC.currency_code;
6502: If ASO_PRICING_INT.G_LINE_REC.line_list_price <> FND_API.G_MISS_NUM Then
6503: G_UNIT_PRICE_TBL(px_index_counter) := ASO_PRICING_INT.G_LINE_REC.line_list_price;
6504: Else
6505: G_UNIT_PRICE_TBL(px_index_counter) := NULL;
6506: End If;

Line 6508: If NVL(ASO_PRICING_INT.G_LINE_REC.line_list_price,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then

6504: Else
6505: G_UNIT_PRICE_TBL(px_index_counter) := NULL;
6506: End If;
6507: G_PERCENT_PRICE_TBL(px_index_counter) := null;
6508: If NVL(ASO_PRICING_INT.G_LINE_REC.line_list_price,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then
6509: G_ADJUSTED_UNIT_PRICE_TBL(px_index_counter) := ASO_PRICING_INT.G_LINE_REC.line_list_price;
6510: else
6511: G_ADJUSTED_UNIT_PRICE_TBL(px_index_counter) := null;
6512: end if;

Line 8738: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

8734: END Print_Global_Data_Rltships;
8735:
8736: PROCEDURE Populate_QP_Temp_Tables
8737: IS
8738: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
8739: l_return_status_text varchar2(240) ;
8740: i NUMBER;
8741:
8742: BEGIN

Line 8788: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

8784: p_CONTRACT_END_DATE =>G_CONTRACT_END_DATE_TBL,
8785: x_status_code =>l_return_status,
8786: x_status_text =>l_return_status_text);
8787:
8788: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8789: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
8790: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Error in insert_lines2',1,'Y');
8791: aso_debug_pub.add('ASO_PRICING_CORE_PVT:l_return_status_text:'||l_return_status_text,1,'Y');
8792: END IF;

Line 8793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8789: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
8790: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Error in insert_lines2',1,'Y');
8791: aso_debug_pub.add('ASO_PRICING_CORE_PVT:l_return_status_text:'||l_return_status_text,1,'Y');
8792: END IF;
8793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8794: END IF;
8795:
8796: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN
8797: QP_PREQ_GRP.INSERT_LINE_ATTRS2

Line 8831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

8827: p_PRIMARY_UOM_FLAG_TBL => G_ATTR_PRIMARY_UOM_FLAG_TBL,
8828: x_status_code => l_return_status,
8829: x_status_text => l_return_status_text );
8830:
8831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8832: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
8833: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Error inserting into line attrs'||sqlerrm,1,'Y');
8834: END IF;
8835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8832: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
8833: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Error inserting into line attrs'||sqlerrm,1,'Y');
8834: END IF;
8835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8836: END IF;
8837:
8838: END IF;
8839:

Line 8902: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

8898: p_PRICE_ADJUSTMENT_ID => G_LDET_PRICE_ADJ_ID_TBL,
8899: x_status_code => l_return_status,
8900: x_status_text => l_return_status_text);
8901:
8902: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8903: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
8904: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Error inserting into adj ldets'||sqlerrm,1,'Y');
8905: END IF;
8906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8902: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8903: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
8904: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Error inserting into adj ldets'||sqlerrm,1,'Y');
8905: END IF;
8906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8907: END IF;
8908:
8909: END IF;--G_LDET_LINE_DTL_INDEX_TBL
8910:

Line 8926: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

8922: p_RELATED_LIST_LINE_ID => G_RLTD_RLTD_LST_LN_ID_DEF_TBL,
8923: x_status_code => l_return_status,
8924: x_status_text => l_return_status_text);
8925:
8926: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8927: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
8928: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Error inserting into adj relationship'||sqlerrm,1,'Y');
8929: END IF;
8930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8926: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8927: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
8928: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Error inserting into adj relationship'||sqlerrm,1,'Y');
8929: END IF;
8930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8931: END IF;
8932:
8933: END IF;--G_RLTD_LINE_INDEX_TBL
8934:

Line 8941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8937: END IF;
8938:
8939: EXCEPTION
8940: WHEN OTHERS THEN
8941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8942:
8943: END Populate_QP_Temp_Tables;
8944:
8945:

Line 8948: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

8944:
8945:
8946: PROCEDURE Delete_Promotion (
8947: P_Api_Version_Number IN NUMBER,
8948: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8949: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
8950: p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
8951: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
8952: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 8949: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

8945:
8946: PROCEDURE Delete_Promotion (
8947: P_Api_Version_Number IN NUMBER,
8948: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8949: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
8950: p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
8951: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
8952: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
8953: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 9004: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

9000: -- Standard Start of API savepoint
9001: SAVEPOINT Delete_Promotion_PVT;
9002:
9003: -- Standard call to check for call compatibility.
9004: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
9005: p_api_version_number,
9006: l_api_name,
9007: G_PKG_NAME)
9008: THEN

Line 9009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9005: p_api_version_number,
9006: l_api_name,
9007: G_PKG_NAME)
9008: THEN
9009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9010: END IF;
9011:
9012:
9013: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 9014: IF FND_API.to_Boolean( p_init_msg_list )

9010: END IF;
9011:
9012:
9013: -- Initialize message list if p_init_msg_list is set to TRUE.
9014: IF FND_API.to_Boolean( p_init_msg_list )
9015: THEN
9016: FND_MSG_PUB.initialize;
9017: END IF;
9018:

Line 9019: x_return_status := FND_API.G_RET_STS_SUCCESS;

9015: THEN
9016: FND_MSG_PUB.initialize;
9017: END IF;
9018:
9019: x_return_status := FND_API.G_RET_STS_SUCCESS;
9020: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9021: aso_debug_pub.add('ASO_PRICING_CORE_PVT:p_price_attr_tbl.count:'||nvl(p_price_attr_tbl.count,0),1,'Y');
9022: END IF;
9023:

Line 9042: OR p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR)

9038: END IF;
9039:
9040: If p_price_attr_tbl(i).price_attribute_id is not null then
9041: If ((p_price_attr_tbl(i).pricing_attribute1 IS NULL
9042: OR p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR)
9043: AND
9044: (p_price_attr_tbl(i).pricing_attribute2 IS NULL
9045: OR p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR))
9046: OR (p_price_attr_tbl(i).flex_title = 'QP_ATTR_DEFNS_PRICING'

Line 9045: OR p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR))

9041: If ((p_price_attr_tbl(i).pricing_attribute1 IS NULL
9042: OR p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR)
9043: AND
9044: (p_price_attr_tbl(i).pricing_attribute2 IS NULL
9045: OR p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR))
9046: OR (p_price_attr_tbl(i).flex_title = 'QP_ATTR_DEFNS_PRICING'
9047: OR (p_price_attr_tbl(i).flex_title = FND_API.G_MISS_CHAR
9048: OR p_price_attr_tbl(i).flex_title IS NULL)) then
9049: /*Deleting the attributes or promotions from Istore*/

Line 9047: OR (p_price_attr_tbl(i).flex_title = FND_API.G_MISS_CHAR

9043: AND
9044: (p_price_attr_tbl(i).pricing_attribute2 IS NULL
9045: OR p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR))
9046: OR (p_price_attr_tbl(i).flex_title = 'QP_ATTR_DEFNS_PRICING'
9047: OR (p_price_attr_tbl(i).flex_title = FND_API.G_MISS_CHAR
9048: OR p_price_attr_tbl(i).flex_title IS NULL)) then
9049: /*Deleting the attributes or promotions from Istore*/
9050: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9051: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Deleting Price attributes or promocodes from Istorewith Price_attribute_id:'||p_price_attr_tbl(i).Price_attribute_id,1,'Y');

Line 9059: OR (p_price_attr_tbl(i).quote_header_id = FND_API.G_MISS_NUM) THEN

9055: else
9056: --We will require at least quote_header_id AND (price_attr1 OR price_attr2 value)
9057: --Check if there is a header id
9058: If (p_price_attr_tbl(i).quote_header_id IS NULL)
9059: OR (p_price_attr_tbl(i).quote_header_id = FND_API.G_MISS_NUM) THEN
9060: x_return_status := FND_API.G_RET_STS_ERROR;
9061: RAISE FND_API.G_EXC_ERROR;
9062: END If;
9063:

Line 9060: x_return_status := FND_API.G_RET_STS_ERROR;

9056: --We will require at least quote_header_id AND (price_attr1 OR price_attr2 value)
9057: --Check if there is a header id
9058: If (p_price_attr_tbl(i).quote_header_id IS NULL)
9059: OR (p_price_attr_tbl(i).quote_header_id = FND_API.G_MISS_NUM) THEN
9060: x_return_status := FND_API.G_RET_STS_ERROR;
9061: RAISE FND_API.G_EXC_ERROR;
9062: END If;
9063:
9064: If (p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR

Line 9061: RAISE FND_API.G_EXC_ERROR;

9057: --Check if there is a header id
9058: If (p_price_attr_tbl(i).quote_header_id IS NULL)
9059: OR (p_price_attr_tbl(i).quote_header_id = FND_API.G_MISS_NUM) THEN
9060: x_return_status := FND_API.G_RET_STS_ERROR;
9061: RAISE FND_API.G_EXC_ERROR;
9062: END If;
9063:
9064: If (p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR
9065: OR p_price_attr_tbl(i).pricing_attribute1 is null)

Line 9064: If (p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR

9060: x_return_status := FND_API.G_RET_STS_ERROR;
9061: RAISE FND_API.G_EXC_ERROR;
9062: END If;
9063:
9064: If (p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR
9065: OR p_price_attr_tbl(i).pricing_attribute1 is null)
9066: AND (p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR
9067: OR p_price_attr_tbl(i).pricing_attribute2 is null ) THEN
9068: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9066: AND (p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR

9062: END If;
9063:
9064: If (p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR
9065: OR p_price_attr_tbl(i).pricing_attribute1 is null)
9066: AND (p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR
9067: OR p_price_attr_tbl(i).pricing_attribute2 is null ) THEN
9068: x_return_status := FND_API.G_RET_STS_ERROR;
9069: RAISE FND_API.G_EXC_ERROR;
9070: End If;

Line 9068: x_return_status := FND_API.G_RET_STS_ERROR;

9064: If (p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR
9065: OR p_price_attr_tbl(i).pricing_attribute1 is null)
9066: AND (p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR
9067: OR p_price_attr_tbl(i).pricing_attribute2 is null ) THEN
9068: x_return_status := FND_API.G_RET_STS_ERROR;
9069: RAISE FND_API.G_EXC_ERROR;
9070: End If;
9071:
9072: If (p_price_attr_tbl(i).quote_line_id IS NULL

Line 9069: RAISE FND_API.G_EXC_ERROR;

9065: OR p_price_attr_tbl(i).pricing_attribute1 is null)
9066: AND (p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR
9067: OR p_price_attr_tbl(i).pricing_attribute2 is null ) THEN
9068: x_return_status := FND_API.G_RET_STS_ERROR;
9069: RAISE FND_API.G_EXC_ERROR;
9070: End If;
9071:
9072: If (p_price_attr_tbl(i).quote_line_id IS NULL
9073: OR p_price_attr_tbl(i).quote_line_id = FND_API.G_MISS_NUM) then

Line 9073: OR p_price_attr_tbl(i).quote_line_id = FND_API.G_MISS_NUM) then

9069: RAISE FND_API.G_EXC_ERROR;
9070: End If;
9071:
9072: If (p_price_attr_tbl(i).quote_line_id IS NULL
9073: OR p_price_attr_tbl(i).quote_line_id = FND_API.G_MISS_NUM) then
9074: /*Delete all the header level adjustments*/
9075:
9076: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9077: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Deleting header level adjustments',1,'Y');

Line 9080: OR p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR) then

9076: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9077: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Deleting header level adjustments',1,'Y');
9078: END IF;
9079: If (p_price_attr_tbl(i).pricing_attribute2 is null
9080: OR p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR) then
9081:
9082: /*Delete all the adjustment record with the modifier_header_id*/
9083: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9084: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Deleting header level adjustments with the modifier_header_id',1,'Y');

Line 9098: OR p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR) then

9094: End Loop;
9095: CLOSE C_get_adj_id_HdrH;
9096:
9097: Elsif (p_price_attr_tbl(i).pricing_attribute1 is null
9098: OR p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR) then
9099:
9100: /*Delete all the adjustment record with the modifier_line_id*/
9101: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9102: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Deleting header level adjustments with the modifier_line_id',1,'Y');

Line 9126: OR p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR) then

9122: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Deleting line level adjustments',1,'Y');
9123: END IF;
9124:
9125: If (p_price_attr_tbl(i).pricing_attribute2 is null
9126: OR p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR) then
9127:
9128: /*Delete all the adjustment record with the modifier_header_id*/
9129: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9130: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Deleting line level adjustments with the modifier_header_id',1,'Y');

Line 9147: OR p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR) then

9143:
9144: CLOSE C_get_adj_id_LnH;
9145:
9146: Elsif (p_price_attr_tbl(i).pricing_attribute1 is null
9147: OR p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR) then
9148:
9149: /*Delete all the adjustment record with the modifier_line_id*/
9150: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9151: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Deleting line level adjustments with the modifier_line_id',1,'Y');

Line 9194: IF FND_API.to_Boolean( p_commit ) THEN

9190: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Delete_Promotion Ends', 1, 'Y');
9191: END IF;
9192:
9193: -- Standard check for p_commit
9194: IF FND_API.to_Boolean( p_commit ) THEN
9195: COMMIT WORK;
9196: END IF;
9197:
9198: FND_MSG_PUB.Count_And_Get

Line 9203: WHEN FND_API.G_EXC_ERROR THEN

9199: ( p_count => x_msg_count,
9200: p_data => x_msg_data
9201: );
9202: EXCEPTION
9203: WHEN FND_API.G_EXC_ERROR THEN
9204: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9205: P_API_NAME => L_API_NAME
9206: ,P_PKG_NAME => G_PKG_NAME
9207: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 9215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9211: ,X_MSG_COUNT => X_MSG_COUNT
9212: ,X_MSG_DATA => X_MSG_DATA
9213: ,X_RETURN_STATUS => X_RETURN_STATUS);
9214:
9215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9216: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9217: P_API_NAME => L_API_NAME
9218: ,P_PKG_NAME => G_PKG_NAME
9219: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 9244: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

9240:
9241:
9242: PROCEDURE Copy_Price_To_Quote(
9243: P_Api_Version_Number IN NUMBER,
9244: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9245: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
9246: P_control_rec IN ASO_PRICING_INT.Pricing_Control_Rec_Type,
9247: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
9248: P_Insert_Type IN VARCHAR2 := 'HDR',

Line 9245: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

9241:
9242: PROCEDURE Copy_Price_To_Quote(
9243: P_Api_Version_Number IN NUMBER,
9244: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9245: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
9246: P_control_rec IN ASO_PRICING_INT.Pricing_Control_Rec_Type,
9247: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
9248: P_Insert_Type IN VARCHAR2 := 'HDR',
9249: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 9280: fnd_api.g_ret_sts_unexp_error,

9276: QP_PREQ_GRP.g_status_invalid_price_list,
9277: QP_PREQ_GRP.g_sts_lhs_not_found,
9278: QP_PREQ_GRP.g_status_formula_error,
9279: QP_PREQ_GRP.g_status_other_errors,
9280: fnd_api.g_ret_sts_unexp_error,
9281: fnd_api.g_ret_sts_error,
9282: QP_PREQ_GRP.g_status_calc_error,
9283: QP_PREQ_GRP.g_status_uom_failure,
9284: QP_PREQ_GRP.g_status_invalid_uom,

Line 9281: fnd_api.g_ret_sts_error,

9277: QP_PREQ_GRP.g_sts_lhs_not_found,
9278: QP_PREQ_GRP.g_status_formula_error,
9279: QP_PREQ_GRP.g_status_other_errors,
9280: fnd_api.g_ret_sts_unexp_error,
9281: fnd_api.g_ret_sts_error,
9282: QP_PREQ_GRP.g_status_calc_error,
9283: QP_PREQ_GRP.g_status_uom_failure,
9284: QP_PREQ_GRP.g_status_invalid_uom,
9285: QP_PREQ_GRP.g_status_dup_price_list,

Line 9335: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

9331:
9332:
9333: BEGIN
9334: -- Standard call to check for call compatibility.
9335: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
9336: p_api_version_number,
9337: l_api_name,
9338: G_PKG_NAME)
9339: THEN

Line 9340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9336: p_api_version_number,
9337: l_api_name,
9338: G_PKG_NAME)
9339: THEN
9340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9341: END IF;
9342:
9343:
9344: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 9345: IF FND_API.to_Boolean( p_init_msg_list )

9341: END IF;
9342:
9343:
9344: -- Initialize message list if p_init_msg_list is set to TRUE.
9345: IF FND_API.to_Boolean( p_init_msg_list )
9346: THEN
9347: FND_MSG_PUB.initialize;
9348: END IF;
9349:

Line 9355: x_return_status := FND_API.G_RET_STS_SUCCESS;

9351: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Start Copy_Price_To_Quote ',1,'Y');
9352: aso_debug_pub.add('ASO_PRICING_CORE_PVT:P_control_rec.price_mode:'||P_control_rec.price_mode,1,'Y');
9353: aso_debug_pub.add('ASO_PRICING_CORE_PVT:p_insert_type:'||p_insert_type,1,'Y');
9354: END IF;
9355: x_return_status := FND_API.G_RET_STS_SUCCESS;
9356: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9357: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Post_Price_Request for p_qte_header_rec.quote_header_id'
9358: ||p_qte_header_rec.quote_header_id,1,'Y');
9359: END IF;

Line 9381: x_return_status := FND_API.G_RET_STS_ERROR;

9377: ||C_status_code_rec.pricing_status_code,1,'Y');
9378: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Inside c_status_code cursor pricing_status_text:'
9379: ||C_status_code_rec.pricing_status_text,1,'Y');
9380: END IF;
9381: x_return_status := FND_API.G_RET_STS_ERROR;
9382: l_message_text := C_status_code_rec.pricing_status_code || ': '||C_status_code_rec.pricing_status_text;
9383:
9384: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9385: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');

Line 9389: RAISE FND_API.G_EXC_ERROR;

9385: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
9386: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_message_text, 1,255), FALSE);
9387: FND_MSG_PUB.ADD;
9388: END IF;
9389: RAISE FND_API.G_EXC_ERROR;
9390: END LOOP;
9391:
9392: l_profile_value := FND_PROFILE.value('ASO_GSA_PRICING');
9393: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 9401: x_return_status := FND_API.G_RET_STS_ERROR;

9397: FOR C_status_code_GSA_rec in C_status_code_GSA LOOP
9398: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9399: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Inside GSA error',1,'Y');
9400: END IF;
9401: x_return_status := FND_API.G_RET_STS_ERROR;
9402: FND_MESSAGE.Set_Name('ASO', 'GSA Violation in Pricing');
9403: FND_MSG_PUB.ADD;
9404: RAISE FND_API.G_EXC_ERROR;
9405: END LOOP;

Line 9404: RAISE FND_API.G_EXC_ERROR;

9400: END IF;
9401: x_return_status := FND_API.G_RET_STS_ERROR;
9402: FND_MESSAGE.Set_Name('ASO', 'GSA Violation in Pricing');
9403: FND_MSG_PUB.ADD;
9404: RAISE FND_API.G_EXC_ERROR;
9405: END LOOP;
9406: ELSE
9407: FOR C_status_code_GSA_rec in C_status_code_GSA LOOP
9408: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 10404: IF FND_API.to_Boolean( p_commit ) THEN

10400: end if;
10401: *******************************************/
10402:
10403: -- Standard check for p_commit
10404: IF FND_API.to_Boolean( p_commit ) THEN
10405: COMMIT WORK;
10406: END IF;
10407:
10408: FND_MSG_PUB.Count_And_Get

Line 10483: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

10479:
10480:
10481: PROCEDURE Process_Charges(
10482: P_Api_Version_Number IN NUMBER,
10483: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
10484: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
10485: P_control_rec IN ASO_PRICING_INT.Pricing_Control_Rec_Type,
10486: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
10487: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 10484: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

10480:
10481: PROCEDURE Process_Charges(
10482: P_Api_Version_Number IN NUMBER,
10483: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
10484: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
10485: P_control_rec IN ASO_PRICING_INT.Pricing_Control_Rec_Type,
10486: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
10487: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
10488: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 10511: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

10507: ls_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
10508:
10509: BEGIN
10510: -- Standard call to check for call compatibility.
10511: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
10512: p_api_version_number,
10513: l_api_name,
10514: G_PKG_NAME)
10515: THEN

Line 10516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10512: p_api_version_number,
10513: l_api_name,
10514: G_PKG_NAME)
10515: THEN
10516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10517: END IF;
10518:
10519:
10520: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 10521: IF FND_API.to_Boolean( p_init_msg_list )

10517: END IF;
10518:
10519:
10520: -- Initialize message list if p_init_msg_list is set to TRUE.
10521: IF FND_API.to_Boolean( p_init_msg_list )
10522: THEN
10523: FND_MSG_PUB.initialize;
10524: END IF;
10525:

Line 10530: x_return_status := FND_API.G_RET_STS_SUCCESS;

10526: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10527: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Start Process_Charges ',1,'Y');
10528: END IF;
10529:
10530: x_return_status := FND_API.G_RET_STS_SUCCESS;
10531: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10532: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Start Process_Charges:p_control_rec.pricing_event: '
10533: ||p_control_rec.pricing_event,1,'Y');
10534: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Start Process_Charges:p_control_rec.calculate_flag: '

Line 10605: IF FND_API.to_Boolean( p_commit ) THEN

10601:
10602: END If;--If (p_control_rec.pricing_event = 'BATCH') OR (p_control_rec.pricing_event = 'ORDER')
10603:
10604: -- Standard check for p_commit
10605: IF FND_API.to_Boolean( p_commit ) THEN
10606: COMMIT WORK;
10607: END IF;
10608:
10609: FND_MSG_PUB.Count_And_Get

Line 10634: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

10630:
10631:
10632: PROCEDURE Process_PRG(
10633: P_Api_Version_Number IN NUMBER,
10634: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
10635: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
10636: P_control_rec IN ASO_PRICING_INT.Pricing_Control_Rec_Type,
10637: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
10638: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 10635: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

10631:
10632: PROCEDURE Process_PRG(
10633: P_Api_Version_Number IN NUMBER,
10634: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
10635: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
10636: P_control_rec IN ASO_PRICING_INT.Pricing_Control_Rec_Type,
10637: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
10638: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
10639: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 10896: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

10892:
10893: BEGIN
10894:
10895: -- Standard call to check for call compatibility.
10896: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
10897: p_api_version_number,
10898: l_api_name,
10899: G_PKG_NAME)
10900: THEN

Line 10901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10897: p_api_version_number,
10898: l_api_name,
10899: G_PKG_NAME)
10900: THEN
10901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10902: END IF;
10903:
10904:
10905: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 10906: IF FND_API.to_Boolean( p_init_msg_list )

10902: END IF;
10903:
10904:
10905: -- Initialize message list if p_init_msg_list is set to TRUE.
10906: IF FND_API.to_Boolean( p_init_msg_list )
10907: THEN
10908: FND_MSG_PUB.initialize;
10909: END IF;
10910:

Line 10915: x_return_status := FND_API.G_RET_STS_SUCCESS;

10911: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10912: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Start Process_PRG ',1,'Y');
10913: END IF;
10914:
10915: x_return_status := FND_API.G_RET_STS_SUCCESS;
10916:
10917: l_line_counter := 1;
10918: l_adj_counter := 1;
10919: l_rltn_counter := 1;

Line 11204: x_return_status := FND_API.G_RET_STS_ERROR;

11200:
11201: l_qte_header_rec.last_update_date := l_last_update_date;
11202:
11203: exception when no_data_found then
11204: x_return_status := FND_API.G_RET_STS_ERROR;
11205: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11206: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
11207: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
11208: FND_MSG_PUB.ADD;

Line 11210: raise FND_API.G_EXC_ERROR;

11206: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
11207: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
11208: FND_MSG_PUB.ADD;
11209: END IF;
11210: raise FND_API.G_EXC_ERROR;
11211: end;
11212:
11213: -- Setting up the Control record for Update quote
11214: l_def_profile_value := FND_PROFILE.value('ASO_ENABLE_DEFAULTING_RULE');

Line 11220: l_pub_control_rec.DEFAULTING_FLAG := FND_API.G_TRUE;

11216: aso_debug_pub.add('ASO_PRICING_CORE_PVT:l_def_profile_value - ASO_ENABLE_DEFAULTING_RULE:'||l_def_profile_value,1,'Y');
11217: END IF;
11218: If l_def_profile_value = 'Y' then
11219: l_pub_control_rec.DEFAULTING_FWK_FLAG := 'Y';
11220: l_pub_control_rec.DEFAULTING_FLAG := FND_API.G_TRUE;
11221: l_pub_control_rec.APPLICATION_TYPE_CODE := 'QUOTING HTML';/* Need to be changed if iStore uptakes defaulting. It should be input parameter */
11222: Else
11223: l_pub_control_rec.DEFAULTING_FWK_FLAG := 'N';
11224: l_pub_control_rec.DEFAULTING_FLAG := FND_API.G_FALSE;

Line 11224: l_pub_control_rec.DEFAULTING_FLAG := FND_API.G_FALSE;

11220: l_pub_control_rec.DEFAULTING_FLAG := FND_API.G_TRUE;
11221: l_pub_control_rec.APPLICATION_TYPE_CODE := 'QUOTING HTML';/* Need to be changed if iStore uptakes defaulting. It should be input parameter */
11222: Else
11223: l_pub_control_rec.DEFAULTING_FWK_FLAG := 'N';
11224: l_pub_control_rec.DEFAULTING_FLAG := FND_API.G_FALSE;
11225: End If;
11226:
11227: ASO_QUOTE_PUB.Update_Quote(
11228: p_api_version_number => 1.0,

Line 11229: p_init_msg_list => fnd_api.g_false,

11225: End If;
11226:
11227: ASO_QUOTE_PUB.Update_Quote(
11228: p_api_version_number => 1.0,
11229: p_init_msg_list => fnd_api.g_false,
11230: p_commit => fnd_api.g_false,
11231: P_Validation_Level => FND_API.G_VALID_LEVEL_NONE,
11232: P_Control_Rec => l_pub_control_rec,
11233: p_qte_header_rec => l_qte_header_rec,

Line 11230: p_commit => fnd_api.g_false,

11226:
11227: ASO_QUOTE_PUB.Update_Quote(
11228: p_api_version_number => 1.0,
11229: p_init_msg_list => fnd_api.g_false,
11230: p_commit => fnd_api.g_false,
11231: P_Validation_Level => FND_API.G_VALID_LEVEL_NONE,
11232: P_Control_Rec => l_pub_control_rec,
11233: p_qte_header_rec => l_qte_header_rec,
11234: p_qte_line_tbl => l_qte_line_tbl,

Line 11231: P_Validation_Level => FND_API.G_VALID_LEVEL_NONE,

11227: ASO_QUOTE_PUB.Update_Quote(
11228: p_api_version_number => 1.0,
11229: p_init_msg_list => fnd_api.g_false,
11230: p_commit => fnd_api.g_false,
11231: P_Validation_Level => FND_API.G_VALID_LEVEL_NONE,
11232: P_Control_Rec => l_pub_control_rec,
11233: p_qte_header_rec => l_qte_header_rec,
11234: p_qte_line_tbl => l_qte_line_tbl,
11235: p_price_adjustment_Tbl => l_price_adjustment_Tbl,

Line 11270: IF x_return_status = FND_API.G_RET_STS_ERROR then

11266: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After Update Quote X_Return_Status:'||X_Return_Status,1,'Y');
11267: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After Update Quote X_Msg_Count:'||X_Msg_Count,1,'Y');
11268: END IF;
11269:
11270: IF x_return_status = FND_API.G_RET_STS_ERROR then
11271: raise FND_API.G_EXC_ERROR;
11272: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
11273: raise FND_API.G_EXC_UNEXPECTED_ERROR;
11274: END IF;

Line 11271: raise FND_API.G_EXC_ERROR;

11267: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After Update Quote X_Msg_Count:'||X_Msg_Count,1,'Y');
11268: END IF;
11269:
11270: IF x_return_status = FND_API.G_RET_STS_ERROR then
11271: raise FND_API.G_EXC_ERROR;
11272: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
11273: raise FND_API.G_EXC_UNEXPECTED_ERROR;
11274: END IF;
11275:

Line 11272: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

11268: END IF;
11269:
11270: IF x_return_status = FND_API.G_RET_STS_ERROR then
11271: raise FND_API.G_EXC_ERROR;
11272: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
11273: raise FND_API.G_EXC_UNEXPECTED_ERROR;
11274: END IF;
11275:
11276: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 11273: raise FND_API.G_EXC_UNEXPECTED_ERROR;

11269:
11270: IF x_return_status = FND_API.G_RET_STS_ERROR then
11271: raise FND_API.G_EXC_ERROR;
11272: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
11273: raise FND_API.G_EXC_UNEXPECTED_ERROR;
11274: END IF;
11275:
11276: IF aso_debug_pub.g_debug_flag = 'Y' THEN
11277: For i in 1..lx_Qte_Line_Tbl.count loop

Line 11519: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

11515: (p_control_rec =>l_req_control_rec
11516: ,x_return_status =>l_return_status
11517: ,x_return_status_Text =>l_return_status_Text
11518: );
11519: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11520: x_return_status := l_return_status;
11521: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11522: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
11523: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_return_status_text, 1,255), FALSE);

Line 11526: RAISE FND_API.G_EXC_ERROR;

11522: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
11523: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_return_status_text, 1,255), FALSE);
11524: FND_MSG_PUB.ADD;
11525: END IF;
11526: RAISE FND_API.G_EXC_ERROR;
11527: END IF;
11528:
11529: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
11530: aso_debug_pub.add('ASO_PRICING_CORE_PVT: End of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');

Line 11540: P_Init_Msg_List => FND_API.G_FALSE,

11536: END IF;
11537:
11538: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
11539: P_Api_Version_Number => 1.0,
11540: P_Init_Msg_List => FND_API.G_FALSE,
11541: P_Commit => FND_API.G_FALSE,
11542: p_control_rec => p_control_rec,
11543: p_qte_header_rec => p_qte_header_rec,
11544: p_insert_type => 'NO_HDR',

Line 11541: P_Commit => FND_API.G_FALSE,

11537:
11538: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
11539: P_Api_Version_Number => 1.0,
11540: P_Init_Msg_List => FND_API.G_FALSE,
11541: P_Commit => FND_API.G_FALSE,
11542: p_control_rec => p_control_rec,
11543: p_qte_header_rec => p_qte_header_rec,
11544: p_insert_type => 'NO_HDR',
11545: x_return_status => x_return_status,

Line 11565: P_Init_Msg_List => FND_API.G_FALSE,

11561: END IF;
11562: If (p_control_rec.price_mode = 'ENTIRE_QUOTE') then
11563: ASO_PRICING_FLOWS_PVT.Price_Entire_Quote(
11564: P_Api_Version_Number => P_Api_Version_Number,
11565: P_Init_Msg_List => FND_API.G_FALSE,
11566: P_Commit => FND_API.G_FALSE,
11567: p_control_rec => p_control_rec,
11568: p_qte_header_rec => p_qte_header_rec,
11569: p_qte_line_tbl => ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl,

Line 11566: P_Commit => FND_API.G_FALSE,

11562: If (p_control_rec.price_mode = 'ENTIRE_QUOTE') then
11563: ASO_PRICING_FLOWS_PVT.Price_Entire_Quote(
11564: P_Api_Version_Number => P_Api_Version_Number,
11565: P_Init_Msg_List => FND_API.G_FALSE,
11566: P_Commit => FND_API.G_FALSE,
11567: p_control_rec => p_control_rec,
11568: p_qte_header_rec => p_qte_header_rec,
11569: p_qte_line_tbl => ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl,
11570: p_internal_call_flag => 'Y',

Line 11579: P_Init_Msg_List => FND_API.G_FALSE,

11575: Else
11576: /**CHANGE_LINE****/
11577: ASO_PRICING_FLOWS_PVT.Price_Quote_With_Change_Lines(
11578: P_Api_Version_Number => P_Api_Version_Number,
11579: P_Init_Msg_List => FND_API.G_FALSE,
11580: P_Commit => FND_API.G_FALSE,
11581: p_control_rec => p_control_rec,
11582: p_qte_header_rec => p_qte_header_rec,
11583: p_qte_line_tbl => ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl,

Line 11580: P_Commit => FND_API.G_FALSE,

11576: /**CHANGE_LINE****/
11577: ASO_PRICING_FLOWS_PVT.Price_Quote_With_Change_Lines(
11578: P_Api_Version_Number => P_Api_Version_Number,
11579: P_Init_Msg_List => FND_API.G_FALSE,
11580: P_Commit => FND_API.G_FALSE,
11581: p_control_rec => p_control_rec,
11582: p_qte_header_rec => p_qte_header_rec,
11583: p_qte_line_tbl => ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl,
11584: p_internal_call_flag => 'Y',

Line 11596: IF FND_API.to_Boolean( p_commit ) THEN

11592:
11593: end if;--l_track_var = 'Y'
11594:
11595: -- Standard check for p_commit
11596: IF FND_API.to_Boolean( p_commit ) THEN
11597: COMMIT WORK;
11598: END IF;
11599:
11600: FND_MSG_PUB.Count_And_Get