APPS.ASO_PRICING_CORE_PVT dependencies on FND_API

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

297: l_line_rec.ORDER_LINE_TYPE_ID := p_qte_line_rec.ORDER_LINE_TYPE_ID;
298: l_line_rec.INVOICE_TO_PARTY_SITE_ID := p_qte_line_rec.INVOICE_TO_PARTY_SITE_ID;
299: -- added for sourcing rule match on 06/06/01
300: If l_line_rec.INVOICE_TO_PARTY_SITE_ID is NULL
301: OR l_line_rec.INVOICE_TO_PARTY_SITE_ID = fnd_api.g_miss_num then
302: l_line_rec.INVOICE_TO_PARTY_SITE_ID := ASO_PRICING_INT.G_HEADER_REC.INVOICE_TO_PARTY_SITE_ID;
303: End if;
304: l_line_rec.INVOICE_TO_PARTY_ID := p_qte_line_rec.INVOICE_TO_PARTY_ID;
305: l_line_rec.ORGANIZATION_ID := p_qte_line_rec.ORGANIZATION_ID;

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

308: l_line_rec.UOM_CODE := p_qte_line_rec.UOM_CODE;
309: l_line_rec.MARKETING_SOURCE_CODE_ID := p_qte_line_rec.MARKETING_SOURCE_CODE_ID;
310: l_line_rec.PRICE_LIST_ID := p_qte_line_rec.PRICE_LIST_ID;
311: -- added for sourcing rule match on 06/06/01
312: If (l_line_rec.PRICE_LIST_ID is NULL OR l_line_rec.PRICE_LIST_ID = fnd_api.g_miss_num) then
313: l_line_rec.PRICE_LIST_ID := ASO_PRICING_INT.G_HEADER_REC.PRICE_LIST_ID;
314: End If;
315:
316: If (NVL(p_qte_line_rec.PRICING_LINE_TYPE_INDICATOR,'X') = 'F') then

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

333: l_line_rec.SELLING_PRICE_CHANGE := p_qte_line_rec.SELLING_PRICE_CHANGE;
334: l_line_rec.PRICING_LINE_TYPE_INDICATOR := p_qte_line_rec.PRICING_LINE_TYPE_INDICATOR;
335: l_line_rec.MINISITE_ID := p_qte_line_rec.MINISITE_ID;
336: l_line_rec.AGREEMENT_ID := p_qte_line_rec.AGREEMENT_ID;
337: If (l_line_rec.AGREEMENT_ID is NULL OR l_line_rec.AGREEMENT_ID = fnd_api.g_miss_num) then
338: l_line_rec.AGREEMENT_ID := ASO_PRICING_INT.G_HEADER_REC.CONTRACT_ID;
339: End If;
340: l_line_rec.ATTRIBUTE_CATEGORY := p_qte_line_rec.ATTRIBUTE_CATEGORY;
341: l_line_rec.ATTRIBUTE1 := p_qte_line_rec.ATTRIBUTE1;

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

372:
373: l_line_rec.PROMISE_DATE := p_shipment_rec.PROMISE_DATE;
374: l_line_rec.REQUEST_DATE := p_shipment_rec.REQUEST_DATE;
375: If l_line_rec.REQUEST_DATE is NULL
376: OR l_line_rec.REQUEST_DATE = fnd_api.g_miss_date then
377: l_line_rec.REQUEST_DATE := ASO_PRICING_INT.G_HEADER_REC.REQUEST_DATE;
378: End If;
379: l_line_rec.SCHEDULE_SHIP_DATE := p_shipment_rec.SCHEDULE_SHIP_DATE;
380: l_line_rec.SHIP_TO_PARTY_SITE_ID := p_shipment_rec.SHIP_TO_PARTY_SITE_ID;

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

379: l_line_rec.SCHEDULE_SHIP_DATE := p_shipment_rec.SCHEDULE_SHIP_DATE;
380: l_line_rec.SHIP_TO_PARTY_SITE_ID := p_shipment_rec.SHIP_TO_PARTY_SITE_ID;
381: -- added for sourcing rule match on 06/06/01
382: if l_line_rec.SHIP_TO_PARTY_SITE_ID is NULL
383: OR l_line_rec.SHIP_TO_PARTY_SITE_ID = fnd_api.g_miss_num then
384: l_line_rec.SHIP_TO_PARTY_SITE_ID := ASO_PRICING_INT.G_HEADER_REC.SHIP_TO_PARTY_SITE_ID;
385: End if;
386: l_line_rec.SHIP_TO_PARTY_ID := p_shipment_rec.SHIP_TO_PARTY_ID;
387: l_line_rec.SHIP_PARTIAL_FLAG := p_shipment_rec.SHIP_PARTIAL_FLAG;

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

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

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

394: End If;
395: l_line_rec.FREIGHT_TERMS_CODE := p_shipment_rec.FREIGHT_TERMS_CODE;
396: -- added for sourcing rule match on 06/06/01
397: If l_line_rec.FREIGHT_TERMS_CODE is NULL
398: OR l_line_rec.FREIGHT_TERMS_CODE = fnd_api.g_miss_char then
399: l_line_rec.FREIGHT_TERMS_CODE := ASO_PRICING_INT.G_HEADER_REC.FREIGHT_TERMS_CODE;
400: End If;
401: l_line_rec.FREIGHT_CARRIER_CODE := p_shipment_rec.FREIGHT_CARRIER_CODE;
402: If l_line_rec.FREIGHT_CARRIER_CODE is NULL

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

399: l_line_rec.FREIGHT_TERMS_CODE := ASO_PRICING_INT.G_HEADER_REC.FREIGHT_TERMS_CODE;
400: End If;
401: l_line_rec.FREIGHT_CARRIER_CODE := p_shipment_rec.FREIGHT_CARRIER_CODE;
402: If l_line_rec.FREIGHT_CARRIER_CODE is NULL
403: OR l_line_rec.FREIGHT_CARRIER_CODE = fnd_api.g_miss_char then
404: l_line_rec.FREIGHT_CARRIER_CODE := ASO_PRICING_INT.G_HEADER_REC.FREIGHT_CARRIER_CODE;
405: End If;
406: l_line_rec.FOB_CODE := p_shipment_rec.FOB_CODE;
407: If l_line_rec.FOB_CODE is NULL

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

404: l_line_rec.FREIGHT_CARRIER_CODE := ASO_PRICING_INT.G_HEADER_REC.FREIGHT_CARRIER_CODE;
405: End If;
406: l_line_rec.FOB_CODE := p_shipment_rec.FOB_CODE;
407: If l_line_rec.FOB_CODE is NULL
408: OR l_line_rec.FOB_CODE = fnd_api.g_miss_char then
409: l_line_rec.FOB_CODE := ASO_PRICING_INT.G_HEADER_REC.FOB_CODE;
410: End If;
411: l_line_rec.SHIPPING_INSTRUCTIONS := p_shipment_rec.SHIPPING_INSTRUCTIONS;
412: l_line_rec.PACKING_INSTRUCTIONS := p_shipment_rec.PACKING_INSTRUCTIONS;

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

417: l_line_rec.SHIPMENT_PRIORITY_CODE := p_shipment_rec.SHIPMENT_PRIORITY_CODE;
418: --education change: added to check model id
419: --Changed again to fix the bundle item bug fix: changed to obtain the model via cursor
420: --rather than using the get_top_model_item_id() function.
421: If l_line_rec.MODEL_ID is NULL OR l_line_rec.MODEL_ID = fnd_api.g_miss_num then
422: OPEN C_top_model_item_id( p_qte_line_dtl_rec.CONFIG_HEADER_ID,
423: p_qte_line_dtl_rec.CONFIG_REVISION_NUM);
424: FETCH C_top_model_item_id INTO l_inventory_item_id;
425: CLOSE C_top_model_item_id;

Line 471: AND p_quote_header_id <> FND_API.G_MISS_NUM)

467: QP_LIST_LINES B
468: WHERE lines.line_id = p_quote_header_id
469: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
470: AND (p_quote_header_id IS NOT NULL
471: AND p_quote_header_id <> FND_API.G_MISS_NUM)
472: AND lines.line_index = a.line_index
473: AND A.CREATED_FROM_LIST_LINE_TYPE = QP_PREQ_GRP.G_TERMS_SUBSTITUTION
474: AND a.applied_flag = G_YES_FLAG
475: AND a.modifier_level_code = G_ORDER_LEVEL

Line 492: AND p_quote_header_id <> FND_API.G_MISS_NUM)

488: RA_TERMS_B ratv
489: WHERE lines.line_id = p_quote_header_id
490: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
491: AND (p_quote_header_id IS NOT NULL
492: AND p_quote_header_id <> FND_API.G_MISS_NUM)
493: AND lines.line_index = a.line_index
494: AND b.substitution_attribute = G_QUAL_ATTRIBUTE1
495: AND A.CREATED_FROM_LIST_LINE_TYPE = QP_PREQ_GRP.G_TERMS_SUBSTITUTION
496: AND a.applied_flag = G_YES_FLAG

Line 515: AND p_quote_header_id <> FND_API.G_MISS_NUM)

511: QP_LIST_LINES B
512: WHERE lines.line_id = p_quote_header_id
513: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
514: AND (p_quote_header_id IS NOT NULL
515: AND p_quote_header_id <> FND_API.G_MISS_NUM)
516: AND lines.line_index = a.line_index
517: AND b.substitution_attribute = G_QUAL_ATTRIBUTE11
518: AND A.CREATED_FROM_LIST_LINE_TYPE = QP_PREQ_GRP.G_TERMS_SUBSTITUTION
519: AND a.applied_flag = G_YES_FLAG

Line 537: AND p_quote_header_id <> FND_API.G_MISS_NUM)

533: fnd_lookup_values olk
534: WHERE lines.line_id = p_quote_header_id
535: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
536: AND (p_quote_header_id IS NOT NULL
537: AND p_quote_header_id <> FND_API.G_MISS_NUM)
538: AND lines.line_index = a.line_index
539: AND b.substitution_attribute = G_QUAL_ATTRIBUTE10
540: AND A.CREATED_FROM_LIST_LINE_TYPE = G_TERMS_SUBSTITUTION
541: AND a.applied_flag = G_YES_FLAG

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

617: IF l_payment_id IS NOT NULL THEN
618: UPDATE ASO_PAYMENTS
619: SET payment_term_id = payment_term_id_from
620: WHERE quote_header_id = p_quote_header_id
621: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
622: AND quote_line_id IS NULL;
623: END IF;
624: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
625: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Payment Rows Updated : '||sql%ROWCOUNT,1,'Y');

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

698: THEN
699: UPDATE ASO_PAYMENTS
700: SET payment_term_id = l_req_payment_term_id
701: WHERE quote_header_id = p_quote_header_id
702: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
703: AND quote_line_id IS NULL;
704: END IF;
705: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
706: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Payment Rows Updated : '||sql%ROWCOUNT,1,'Y');

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

730: THEN
731: UPDATE ASO_SHIPMENTS aso
732: SET aso.ship_method_code = ship_method_code_from
733: WHERE quote_header_id = p_quote_header_id
734: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
735: AND quote_line_id IS NULL;
736: END IF;
737: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
738: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Ship Method Code Rows Updated : '||sql%ROWCOUNT,1,'Y');

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

819: THEN
820: UPDATE ASO_SHIPMENTS aso
821: SET aso.ship_method_code = l_req_ship_method_code
822: WHERE quote_header_id = p_quote_header_id
823: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
824: AND quote_line_id IS NULL
825: AND ('S' = (ASO_VALIDATE_PVT.Validate_ShipMethods('T', l_req_ship_method_code,
826: aso.ship_from_org_id, p_quote_header_id, NULL)));
827: END IF;

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

851: IF l_freight_shipment_id IS NOT NULL THEN
852: UPDATE ASO_SHIPMENTS aso
853: SET aso.freight_terms_code = freight_terms_code_from
854: WHERE quote_header_id = p_quote_header_id
855: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
856: AND quote_line_id IS NULL;
857: END IF;
858: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
859: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Freight Terms Code Rows Updated : '||sql%ROWCOUNT,1,'Y');

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

939: IF l_freight_shipment_id IS NOT NULL or lx_freight_shipment_id IS NOT NULL THEN
940: UPDATE ASO_SHIPMENTS aso
941: SET aso.freight_terms_code = l_req_freight_terms_code
942: WHERE quote_header_id = p_quote_header_id
943: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
944: AND quote_line_id IS NULL;
945: END IF;
946: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
947: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Freight Terms Code Rows Updated : '||sql%ROWCOUNT,1,'Y');

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

977: QP_LIST_LINES B
978: WHERE lines.line_id = p_quote_line_id
979: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
980: AND (lines.line_id IS NOT NULL
981: AND lines.line_id <> FND_API.G_MISS_NUM)
982: AND lines.line_index = a.line_index
983: AND A.CREATED_FROM_LIST_LINE_TYPE = QP_PREQ_GRP.G_TERMS_SUBSTITUTION
984: AND a.applied_flag = G_YES_FLAG
985: AND a.modifier_level_code = G_LINE_LEVEL

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

997: QP_LIST_LINES B
998: WHERE lines.line_id = p_quote_line_id
999: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
1000: AND (lines.line_id IS NOT NULL
1001: AND lines.line_id <> FND_API.G_MISS_NUM)
1002: AND lines.line_index = a.line_index
1003: AND b.substitution_attribute = G_QUAL_ATTRIBUTE11
1004: AND A.CREATED_FROM_LIST_LINE_TYPE = QP_PREQ_GRP.G_TERMS_SUBSTITUTION
1005: AND a.applied_flag = G_YES_FLAG

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

1019: fnd_lookup_values olk
1020: WHERE lines.line_id = p_quote_line_id
1021: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
1022: AND (lines.line_id IS NOT NULL
1023: AND lines.line_id <> FND_API.G_MISS_NUM)
1024: AND lines.line_index = a.line_index
1025: AND b.substitution_attribute = G_QUAL_ATTRIBUTE10
1026: AND A.CREATED_FROM_LIST_LINE_TYPE = G_TERMS_SUBSTITUTION
1027: AND a.applied_flag = G_YES_FLAG

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

1067: RA_TERMS_B ratv
1068: WHERE lines.line_id = p_quote_line_id
1069: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
1070: AND (lines.line_id IS NOT NULL
1071: AND lines.line_id <> FND_API.G_MISS_NUM)
1072: AND lines.line_index = a.line_index
1073: AND b.substitution_attribute = G_QUAL_ATTRIBUTE1
1074: AND A.CREATED_FROM_LIST_LINE_TYPE = QP_PREQ_GRP.G_TERMS_SUBSTITUTION
1075: AND a.applied_flag = G_YES_FLAG

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 = ship_method_code_from
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: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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 = ship_method_code_from
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: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1239: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Ship Method Code Rows Updated : '||sql%ROWCOUNT,1,'Y');
1240: END IF;

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

1245: END IF;
1246: UPDATE ASO_SHIPMENTS aso
1247: SET aso.ship_method_code = l_req_ship_method_code
1248: WHERE aso.quote_header_id = p_quote_header_id
1249: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1250: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1251: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1252: AND aso.quote_line_id IS NOT NULL
1253: AND ('S' = (ASO_VALIDATE_PVT.Validate_ShipMethods('T', l_req_ship_method_code,

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

1247: SET aso.ship_method_code = l_req_ship_method_code
1248: WHERE aso.quote_header_id = p_quote_header_id
1249: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1250: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1251: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1252: AND aso.quote_line_id IS NOT NULL
1253: AND ('S' = (ASO_VALIDATE_PVT.Validate_ShipMethods('T', l_req_ship_method_code,
1254: aso.ship_from_org_id, p_quote_header_id, l_qte_ln_rec.quote_line_id)));
1255: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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 = freight_terms_code_from
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 = freight_terms_code_from
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 1290: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)

1286: END IF;
1287: UPDATE ASO_SHIPMENTS aso
1288: SET aso.freight_terms_code = l_req_freight_terms_code
1289: WHERE aso.quote_header_id = p_quote_header_id
1290: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1291: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1292: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1293: AND aso.quote_line_id IS NOT NULL;
1294: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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

1288: SET aso.freight_terms_code = l_req_freight_terms_code
1289: WHERE aso.quote_header_id = p_quote_header_id
1290: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1291: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1292: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1293: AND aso.quote_line_id IS NOT NULL;
1294: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1295: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Freight Terms Code Rows Updated : '||sql%ROWCOUNT,1,'Y');
1296: 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 = ship_method_code_from
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: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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 = ship_method_code_from
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: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1449: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Ship Method Code Rows Updated : '||sql%ROWCOUNT,1,'Y');
1450: END IF;

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

1455: END IF;
1456: UPDATE ASO_SHIPMENTS aso
1457: SET aso.ship_method_code = l_req_ship_method_code
1458: WHERE aso.quote_header_id = p_quote_header_id
1459: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1460: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1461: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1462: AND aso.quote_line_id IS NOT NULL
1463: AND ('S' = (ASO_VALIDATE_PVT.Validate_ShipMethods('T', l_req_ship_method_code,

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

1457: SET aso.ship_method_code = l_req_ship_method_code
1458: WHERE aso.quote_header_id = p_quote_header_id
1459: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1460: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1461: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1462: AND aso.quote_line_id IS NOT NULL
1463: AND ('S' = (ASO_VALIDATE_PVT.Validate_ShipMethods('T', l_req_ship_method_code,
1464: aso.ship_from_org_id, p_quote_header_id, l_qte_ln_rec.quote_line_id)));
1465: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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 = freight_terms_code_from
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 = freight_terms_code_from
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 1500: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)

1496: END IF;
1497: UPDATE ASO_SHIPMENTS aso
1498: SET aso.freight_terms_code = l_req_freight_terms_code
1499: WHERE aso.quote_header_id = p_quote_header_id
1500: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1501: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1502: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1503: AND aso.quote_line_id IS NOT NULL;
1504: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

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

1498: SET aso.freight_terms_code = l_req_freight_terms_code
1499: WHERE aso.quote_header_id = p_quote_header_id
1500: AND (p_quote_header_id IS NOT NULL AND p_quote_header_id <> FND_API.G_MISS_NUM)
1501: AND aso.quote_line_id = l_qte_ln_rec.quote_line_id
1502: AND (l_qte_ln_rec.quote_line_id IS NOT NULL AND l_qte_ln_rec.quote_line_id <> FND_API.G_MISS_NUM)
1503: AND aso.quote_line_id IS NOT NULL;
1504: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
1505: aso_debug_pub.add('ASO_PRICING_CORE_PVT: No of Freight Terms Code Rows Updated : '||sql%ROWCOUNT,1,'Y');
1506: END IF;

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

6220:
6221: G_ATTR_LINE_INDEX_tbl(l_counter) := l_line_index;
6222: G_ATTR_LINE_DETAIL_INDEX_tbl(l_counter) := NULL;
6223: G_ATTR_ATTRIBUTE_LEVEL_tbl(l_counter) := QP_PREQ_GRP.G_LINE_LEVEL;
6224: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
6225: G_ATTR_VALIDATED_FLAG_tbl(l_counter) := QP_PREQ_GRP.G_NOT_VALIDATED;
6226: ELSE
6227: G_ATTR_VALIDATED_FLAG_tbl(l_counter) := QP_PREQ_GRP.G_VALIDATED;
6228: END IF;

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

6269:
6270: G_ATTR_LINE_INDEX_tbl(l_counter) := l_line_index;
6271: G_ATTR_LINE_DETAIL_INDEX_tbl(l_counter) := NULL;
6272: G_ATTR_ATTRIBUTE_LEVEL_tbl(l_counter) := QP_PREQ_GRP.G_LINE_LEVEL;
6273: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
6274: G_ATTR_VALIDATED_FLAG_tbl(l_counter) := QP_PREQ_GRP.G_NOT_VALIDATED;
6275: ELSE
6276: G_ATTR_VALIDATED_FLAG_tbl(l_counter) := QP_PREQ_GRP.G_VALIDATED;
6277: END IF;

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

6318:
6319: G_ATTR_LINE_INDEX_tbl(l_counter) := l_line_index;
6320: G_ATTR_LINE_DETAIL_INDEX_tbl(l_counter) := NULL;
6321: G_ATTR_ATTRIBUTE_LEVEL_tbl(l_counter) := QP_PREQ_GRP.G_LINE_LEVEL;
6322: IF NVL(ASO_PRICING_INT.G_HEADER_REC.quote_status_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
6323: G_ATTR_VALIDATED_FLAG_tbl(l_counter) := QP_PREQ_GRP.G_NOT_VALIDATED;
6324: ELSE
6325: G_ATTR_VALIDATED_FLAG_tbl(l_counter) := QP_PREQ_GRP.G_VALIDATED;
6326: END IF;

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

6388: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6389: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Copy_Header_To_Req: ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE:'
6390: ||ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE,1,'Y');
6391: END IF;
6392: if NVL(ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
6393: G_PRICING_EFFECTIVE_DATE_TBL(px_index_counter) := trunc(sysdate);
6394: else
6395: G_PRICING_EFFECTIVE_DATE_TBL(px_index_counter) := trunc(ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE);
6396: end if;

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

6454: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6455: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Copy_Line_To_Request: G_HEADER_REC.PRICE_FROZEN_DATE:'
6456: ||ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE,1,'Y');
6457: END IF;
6458: if NVL(ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE THEN
6459: G_PRICING_EFFECTIVE_DATE_TBL(px_index_counter) := trunc(sysdate);
6460: else
6461: G_PRICING_EFFECTIVE_DATE_TBL(px_index_counter) := trunc(ASO_PRICING_INT.G_HEADER_REC.PRICE_FROZEN_DATE);
6462: end if;

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

6468: G_LINE_UOM_CODE_TBL(px_index_counter) := ASO_PRICING_INT.G_LINE_REC.uom_code;
6469: G_REQUEST_TYPE_CODE_TBL(px_index_counter) := p_Request_Type;
6470: -- Added for Service Item after pathcset E
6471: If ASO_PRICING_INT.G_LINE_REC.service_period is not null
6472: AND ASO_PRICING_INT.G_LINE_REC.service_period <> fnd_api.g_miss_char then
6473: If (ASO_PRICING_INT.G_LINE_REC.service_period = ASO_PRICING_INT.G_LINE_REC.uom_code) Then
6474: G_UOM_QUANTITY_TBL(px_index_counter) := ASO_PRICING_INT.G_LINE_REC.service_duration;
6475: G_CONTRACT_START_DATE_TBL(px_index_counter) := ASO_PRICING_INT.G_LINE_REC.start_date_active;
6476: G_CONTRACT_END_DATE_TBL(px_index_counter) := ASO_PRICING_INT.G_LINE_REC.end_date_active;

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

6513: End If;
6514: G_PRICED_QUANTITY_TBL(px_index_counter) := ASO_PRICING_INT.G_LINE_REC.pricing_quantity;
6515: G_PRICED_UOM_CODE_TBL(px_index_counter) := ASO_PRICING_INT.G_LINE_REC.pricing_quantity_uom;
6516: G_CURRENCY_CODE_TBL(px_index_counter) := ASO_PRICING_INT.G_LINE_REC.currency_code;
6517: If ASO_PRICING_INT.G_LINE_REC.line_list_price <> FND_API.G_MISS_NUM Then
6518: G_UNIT_PRICE_TBL(px_index_counter) := ASO_PRICING_INT.G_LINE_REC.line_list_price;
6519: Else
6520: G_UNIT_PRICE_TBL(px_index_counter) := NULL;
6521: End If;

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

6519: Else
6520: G_UNIT_PRICE_TBL(px_index_counter) := NULL;
6521: End If;
6522: G_PERCENT_PRICE_TBL(px_index_counter) := null;
6523: If NVL(ASO_PRICING_INT.G_LINE_REC.line_list_price,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then
6524: G_ADJUSTED_UNIT_PRICE_TBL(px_index_counter) := ASO_PRICING_INT.G_LINE_REC.line_list_price;
6525: else
6526: G_ADJUSTED_UNIT_PRICE_TBL(px_index_counter) := null;
6527: end if;

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

8750: END Print_Global_Data_Rltships;
8751:
8752: PROCEDURE Populate_QP_Temp_Tables
8753: IS
8754: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
8755: l_return_status_text varchar2(240) ;
8756: i NUMBER;
8757:
8758: BEGIN

Line 8804: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

8800: p_CONTRACT_END_DATE =>G_CONTRACT_END_DATE_TBL,
8801: x_status_code =>l_return_status,
8802: x_status_text =>l_return_status_text);
8803:
8804: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8805: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
8806: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Error in insert_lines2',1,'Y');
8807: aso_debug_pub.add('ASO_PRICING_CORE_PVT:l_return_status_text:'||l_return_status_text,1,'Y');
8808: END IF;

Line 8809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8805: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
8806: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Error in insert_lines2',1,'Y');
8807: aso_debug_pub.add('ASO_PRICING_CORE_PVT:l_return_status_text:'||l_return_status_text,1,'Y');
8808: END IF;
8809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8810: END IF;
8811:
8812: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN
8813: QP_PREQ_GRP.INSERT_LINE_ATTRS2

Line 8847: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

8843: p_PRIMARY_UOM_FLAG_TBL => G_ATTR_PRIMARY_UOM_FLAG_TBL,
8844: x_status_code => l_return_status,
8845: x_status_text => l_return_status_text );
8846:
8847: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8848: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
8849: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Error inserting into line attrs'||sqlerrm,1,'Y');
8850: END IF;
8851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8847: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8848: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
8849: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Error inserting into line attrs'||sqlerrm,1,'Y');
8850: END IF;
8851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8852: END IF;
8853:
8854: END IF;
8855:

Line 8918: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

8914: p_PRICE_ADJUSTMENT_ID => G_LDET_PRICE_ADJ_ID_TBL,
8915: x_status_code => l_return_status,
8916: x_status_text => l_return_status_text);
8917:
8918: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8919: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
8920: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Error inserting into adj ldets'||sqlerrm,1,'Y');
8921: END IF;
8922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8918: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8919: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
8920: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Error inserting into adj ldets'||sqlerrm,1,'Y');
8921: END IF;
8922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8923: END IF;
8924:
8925: END IF;--G_LDET_LINE_DTL_INDEX_TBL
8926:

Line 8942: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

8938: p_RELATED_LIST_LINE_ID => G_RLTD_RLTD_LST_LN_ID_DEF_TBL,
8939: x_status_code => l_return_status,
8940: x_status_text => l_return_status_text);
8941:
8942: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8943: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
8944: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Error inserting into adj relationship'||sqlerrm,1,'Y');
8945: END IF;
8946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 8946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8942: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
8943: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
8944: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Error inserting into adj relationship'||sqlerrm,1,'Y');
8945: END IF;
8946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8947: END IF;
8948:
8949: END IF;--G_RLTD_LINE_INDEX_TBL
8950:

Line 8957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8953: END IF;
8954:
8955: EXCEPTION
8956: WHEN OTHERS THEN
8957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8958:
8959: END Populate_QP_Temp_Tables;
8960:
8961:

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

8960:
8961:
8962: PROCEDURE Delete_Promotion (
8963: P_Api_Version_Number IN NUMBER,
8964: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8965: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
8966: p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
8967: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
8968: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

8961:
8962: PROCEDURE Delete_Promotion (
8963: P_Api_Version_Number IN NUMBER,
8964: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
8965: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
8966: p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
8967: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
8968: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
8969: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 9020: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

9016: -- Standard Start of API savepoint
9017: SAVEPOINT Delete_Promotion_PVT;
9018:
9019: -- Standard call to check for call compatibility.
9020: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
9021: p_api_version_number,
9022: l_api_name,
9023: G_PKG_NAME)
9024: THEN

Line 9025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9021: p_api_version_number,
9022: l_api_name,
9023: G_PKG_NAME)
9024: THEN
9025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9026: END IF;
9027:
9028:
9029: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 9030: IF FND_API.to_Boolean( p_init_msg_list )

9026: END IF;
9027:
9028:
9029: -- Initialize message list if p_init_msg_list is set to TRUE.
9030: IF FND_API.to_Boolean( p_init_msg_list )
9031: THEN
9032: FND_MSG_PUB.initialize;
9033: END IF;
9034:

Line 9035: x_return_status := FND_API.G_RET_STS_SUCCESS;

9031: THEN
9032: FND_MSG_PUB.initialize;
9033: END IF;
9034:
9035: x_return_status := FND_API.G_RET_STS_SUCCESS;
9036: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9037: aso_debug_pub.add('ASO_PRICING_CORE_PVT:p_price_attr_tbl.count:'||nvl(p_price_attr_tbl.count,0),1,'Y');
9038: END IF;
9039:

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

9054: END IF;
9055:
9056: If p_price_attr_tbl(i).price_attribute_id is not null then
9057: If ((p_price_attr_tbl(i).pricing_attribute1 IS NULL
9058: OR p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR)
9059: AND
9060: (p_price_attr_tbl(i).pricing_attribute2 IS NULL
9061: OR p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR))
9062: OR (p_price_attr_tbl(i).flex_title = 'QP_ATTR_DEFNS_PRICING'

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

9057: If ((p_price_attr_tbl(i).pricing_attribute1 IS NULL
9058: OR p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR)
9059: AND
9060: (p_price_attr_tbl(i).pricing_attribute2 IS NULL
9061: OR p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR))
9062: OR (p_price_attr_tbl(i).flex_title = 'QP_ATTR_DEFNS_PRICING'
9063: OR (p_price_attr_tbl(i).flex_title = FND_API.G_MISS_CHAR
9064: OR p_price_attr_tbl(i).flex_title IS NULL)) then
9065: /*Deleting the attributes or promotions from Istore*/

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

9059: AND
9060: (p_price_attr_tbl(i).pricing_attribute2 IS NULL
9061: OR p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR))
9062: OR (p_price_attr_tbl(i).flex_title = 'QP_ATTR_DEFNS_PRICING'
9063: OR (p_price_attr_tbl(i).flex_title = FND_API.G_MISS_CHAR
9064: OR p_price_attr_tbl(i).flex_title IS NULL)) then
9065: /*Deleting the attributes or promotions from Istore*/
9066: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9067: 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 9075: OR (p_price_attr_tbl(i).quote_header_id = FND_API.G_MISS_NUM) THEN

9071: else
9072: --We will require at least quote_header_id AND (price_attr1 OR price_attr2 value)
9073: --Check if there is a header id
9074: If (p_price_attr_tbl(i).quote_header_id IS NULL)
9075: OR (p_price_attr_tbl(i).quote_header_id = FND_API.G_MISS_NUM) THEN
9076: x_return_status := FND_API.G_RET_STS_ERROR;
9077: RAISE FND_API.G_EXC_ERROR;
9078: END If;
9079:

Line 9076: x_return_status := FND_API.G_RET_STS_ERROR;

9072: --We will require at least quote_header_id AND (price_attr1 OR price_attr2 value)
9073: --Check if there is a header id
9074: If (p_price_attr_tbl(i).quote_header_id IS NULL)
9075: OR (p_price_attr_tbl(i).quote_header_id = FND_API.G_MISS_NUM) THEN
9076: x_return_status := FND_API.G_RET_STS_ERROR;
9077: RAISE FND_API.G_EXC_ERROR;
9078: END If;
9079:
9080: If (p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR

Line 9077: RAISE FND_API.G_EXC_ERROR;

9073: --Check if there is a header id
9074: If (p_price_attr_tbl(i).quote_header_id IS NULL)
9075: OR (p_price_attr_tbl(i).quote_header_id = FND_API.G_MISS_NUM) THEN
9076: x_return_status := FND_API.G_RET_STS_ERROR;
9077: RAISE FND_API.G_EXC_ERROR;
9078: END If;
9079:
9080: If (p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR
9081: OR p_price_attr_tbl(i).pricing_attribute1 is null)

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

9076: x_return_status := FND_API.G_RET_STS_ERROR;
9077: RAISE FND_API.G_EXC_ERROR;
9078: END If;
9079:
9080: If (p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR
9081: OR p_price_attr_tbl(i).pricing_attribute1 is null)
9082: AND (p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR
9083: OR p_price_attr_tbl(i).pricing_attribute2 is null ) THEN
9084: x_return_status := FND_API.G_RET_STS_ERROR;

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

9078: END If;
9079:
9080: If (p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR
9081: OR p_price_attr_tbl(i).pricing_attribute1 is null)
9082: AND (p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR
9083: OR p_price_attr_tbl(i).pricing_attribute2 is null ) THEN
9084: x_return_status := FND_API.G_RET_STS_ERROR;
9085: RAISE FND_API.G_EXC_ERROR;
9086: End If;

Line 9084: x_return_status := FND_API.G_RET_STS_ERROR;

9080: If (p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR
9081: OR p_price_attr_tbl(i).pricing_attribute1 is null)
9082: AND (p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR
9083: OR p_price_attr_tbl(i).pricing_attribute2 is null ) THEN
9084: x_return_status := FND_API.G_RET_STS_ERROR;
9085: RAISE FND_API.G_EXC_ERROR;
9086: End If;
9087:
9088: If (p_price_attr_tbl(i).quote_line_id IS NULL

Line 9085: RAISE FND_API.G_EXC_ERROR;

9081: OR p_price_attr_tbl(i).pricing_attribute1 is null)
9082: AND (p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR
9083: OR p_price_attr_tbl(i).pricing_attribute2 is null ) THEN
9084: x_return_status := FND_API.G_RET_STS_ERROR;
9085: RAISE FND_API.G_EXC_ERROR;
9086: End If;
9087:
9088: If (p_price_attr_tbl(i).quote_line_id IS NULL
9089: OR p_price_attr_tbl(i).quote_line_id = FND_API.G_MISS_NUM) then

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

9085: RAISE FND_API.G_EXC_ERROR;
9086: End If;
9087:
9088: If (p_price_attr_tbl(i).quote_line_id IS NULL
9089: OR p_price_attr_tbl(i).quote_line_id = FND_API.G_MISS_NUM) then
9090: /*Delete all the header level adjustments*/
9091:
9092: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9093: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Deleting header level adjustments',1,'Y');

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

9092: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9093: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Deleting header level adjustments',1,'Y');
9094: END IF;
9095: If (p_price_attr_tbl(i).pricing_attribute2 is null
9096: OR p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR) then
9097:
9098: /*Delete all the adjustment record with the modifier_header_id*/
9099: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9100: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Deleting header level adjustments with the modifier_header_id',1,'Y');

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

9110: End Loop;
9111: CLOSE C_get_adj_id_HdrH;
9112:
9113: Elsif (p_price_attr_tbl(i).pricing_attribute1 is null
9114: OR p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR) then
9115:
9116: /*Delete all the adjustment record with the modifier_line_id*/
9117: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9118: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Deleting header level adjustments with the modifier_line_id',1,'Y');

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

9138: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Deleting line level adjustments',1,'Y');
9139: END IF;
9140:
9141: If (p_price_attr_tbl(i).pricing_attribute2 is null
9142: OR p_price_attr_tbl(i).pricing_attribute2 = FND_API.G_MISS_CHAR) then
9143:
9144: /*Delete all the adjustment record with the modifier_header_id*/
9145: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9146: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Deleting line level adjustments with the modifier_header_id',1,'Y');

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

9159:
9160: CLOSE C_get_adj_id_LnH;
9161:
9162: Elsif (p_price_attr_tbl(i).pricing_attribute1 is null
9163: OR p_price_attr_tbl(i).pricing_attribute1 = FND_API.G_MISS_CHAR) then
9164:
9165: /*Delete all the adjustment record with the modifier_line_id*/
9166: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9167: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Deleting line level adjustments with the modifier_line_id',1,'Y');

Line 9210: IF FND_API.to_Boolean( p_commit ) THEN

9206: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Delete_Promotion Ends', 1, 'Y');
9207: END IF;
9208:
9209: -- Standard check for p_commit
9210: IF FND_API.to_Boolean( p_commit ) THEN
9211: COMMIT WORK;
9212: END IF;
9213:
9214: FND_MSG_PUB.Count_And_Get

Line 9219: WHEN FND_API.G_EXC_ERROR THEN

9215: ( p_count => x_msg_count,
9216: p_data => x_msg_data
9217: );
9218: EXCEPTION
9219: WHEN FND_API.G_EXC_ERROR THEN
9220: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9221: P_API_NAME => L_API_NAME
9222: ,P_PKG_NAME => G_PKG_NAME
9223: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 9231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9227: ,X_MSG_COUNT => X_MSG_COUNT
9228: ,X_MSG_DATA => X_MSG_DATA
9229: ,X_RETURN_STATUS => X_RETURN_STATUS);
9230:
9231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9232: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9233: P_API_NAME => L_API_NAME
9234: ,P_PKG_NAME => G_PKG_NAME
9235: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

9256:
9257:
9258: PROCEDURE Copy_Price_To_Quote(
9259: P_Api_Version_Number IN NUMBER,
9260: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9261: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
9262: P_control_rec IN ASO_PRICING_INT.Pricing_Control_Rec_Type,
9263: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
9264: P_Insert_Type IN VARCHAR2 := 'HDR',

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

9257:
9258: PROCEDURE Copy_Price_To_Quote(
9259: P_Api_Version_Number IN NUMBER,
9260: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
9261: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
9262: P_control_rec IN ASO_PRICING_INT.Pricing_Control_Rec_Type,
9263: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
9264: P_Insert_Type IN VARCHAR2 := 'HDR',
9265: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 9296: fnd_api.g_ret_sts_unexp_error,

9292: QP_PREQ_GRP.g_status_invalid_price_list,
9293: QP_PREQ_GRP.g_sts_lhs_not_found,
9294: QP_PREQ_GRP.g_status_formula_error,
9295: QP_PREQ_GRP.g_status_other_errors,
9296: fnd_api.g_ret_sts_unexp_error,
9297: fnd_api.g_ret_sts_error,
9298: QP_PREQ_GRP.g_status_calc_error,
9299: QP_PREQ_GRP.g_status_uom_failure,
9300: QP_PREQ_GRP.g_status_invalid_uom,

Line 9297: fnd_api.g_ret_sts_error,

9293: QP_PREQ_GRP.g_sts_lhs_not_found,
9294: QP_PREQ_GRP.g_status_formula_error,
9295: QP_PREQ_GRP.g_status_other_errors,
9296: fnd_api.g_ret_sts_unexp_error,
9297: fnd_api.g_ret_sts_error,
9298: QP_PREQ_GRP.g_status_calc_error,
9299: QP_PREQ_GRP.g_status_uom_failure,
9300: QP_PREQ_GRP.g_status_invalid_uom,
9301: QP_PREQ_GRP.g_status_dup_price_list,

Line 9351: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

9347:
9348:
9349: BEGIN
9350: -- Standard call to check for call compatibility.
9351: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
9352: p_api_version_number,
9353: l_api_name,
9354: G_PKG_NAME)
9355: THEN

Line 9356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9352: p_api_version_number,
9353: l_api_name,
9354: G_PKG_NAME)
9355: THEN
9356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9357: END IF;
9358:
9359:
9360: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 9361: IF FND_API.to_Boolean( p_init_msg_list )

9357: END IF;
9358:
9359:
9360: -- Initialize message list if p_init_msg_list is set to TRUE.
9361: IF FND_API.to_Boolean( p_init_msg_list )
9362: THEN
9363: FND_MSG_PUB.initialize;
9364: END IF;
9365:

Line 9371: x_return_status := FND_API.G_RET_STS_SUCCESS;

9367: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Start Copy_Price_To_Quote ',1,'Y');
9368: aso_debug_pub.add('ASO_PRICING_CORE_PVT:P_control_rec.price_mode:'||P_control_rec.price_mode,1,'Y');
9369: aso_debug_pub.add('ASO_PRICING_CORE_PVT:p_insert_type:'||p_insert_type,1,'Y');
9370: END IF;
9371: x_return_status := FND_API.G_RET_STS_SUCCESS;
9372: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9373: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Post_Price_Request for p_qte_header_rec.quote_header_id'
9374: ||p_qte_header_rec.quote_header_id,1,'Y');
9375: END IF;

Line 9397: x_return_status := FND_API.G_RET_STS_ERROR;

9393: ||C_status_code_rec.pricing_status_code,1,'Y');
9394: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Inside c_status_code cursor pricing_status_text:'
9395: ||C_status_code_rec.pricing_status_text,1,'Y');
9396: END IF;
9397: x_return_status := FND_API.G_RET_STS_ERROR;
9398: l_message_text := C_status_code_rec.pricing_status_code || ': '||C_status_code_rec.pricing_status_text;
9399:
9400: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
9401: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');

Line 9405: RAISE FND_API.G_EXC_ERROR;

9401: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
9402: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_message_text, 1,255), FALSE);
9403: FND_MSG_PUB.ADD;
9404: END IF;
9405: RAISE FND_API.G_EXC_ERROR;
9406: END LOOP;
9407:
9408: l_profile_value := FND_PROFILE.value('ASO_GSA_PRICING');
9409: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 9417: x_return_status := FND_API.G_RET_STS_ERROR;

9413: FOR C_status_code_GSA_rec in C_status_code_GSA LOOP
9414: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
9415: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Inside GSA error',1,'Y');
9416: END IF;
9417: x_return_status := FND_API.G_RET_STS_ERROR;
9418: FND_MESSAGE.Set_Name('ASO', 'GSA Violation in Pricing');
9419: FND_MSG_PUB.ADD;
9420: RAISE FND_API.G_EXC_ERROR;
9421: END LOOP;

Line 9420: RAISE FND_API.G_EXC_ERROR;

9416: END IF;
9417: x_return_status := FND_API.G_RET_STS_ERROR;
9418: FND_MESSAGE.Set_Name('ASO', 'GSA Violation in Pricing');
9419: FND_MSG_PUB.ADD;
9420: RAISE FND_API.G_EXC_ERROR;
9421: END LOOP;
9422: ELSE
9423: FOR C_status_code_GSA_rec in C_status_code_GSA LOOP
9424: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 10421: IF FND_API.to_Boolean( p_commit ) THEN

10417: end if;
10418: *******************************************/
10419:
10420: -- Standard check for p_commit
10421: IF FND_API.to_Boolean( p_commit ) THEN
10422: COMMIT WORK;
10423: END IF;
10424:
10425: FND_MSG_PUB.Count_And_Get

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

10496:
10497:
10498: PROCEDURE Process_Charges(
10499: P_Api_Version_Number IN NUMBER,
10500: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
10501: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
10502: P_control_rec IN ASO_PRICING_INT.Pricing_Control_Rec_Type,
10503: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
10504: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

10497:
10498: PROCEDURE Process_Charges(
10499: P_Api_Version_Number IN NUMBER,
10500: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
10501: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
10502: P_control_rec IN ASO_PRICING_INT.Pricing_Control_Rec_Type,
10503: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
10504: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
10505: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 10528: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

10524: ls_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
10525:
10526: BEGIN
10527: -- Standard call to check for call compatibility.
10528: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
10529: p_api_version_number,
10530: l_api_name,
10531: G_PKG_NAME)
10532: THEN

Line 10533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10529: p_api_version_number,
10530: l_api_name,
10531: G_PKG_NAME)
10532: THEN
10533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10534: END IF;
10535:
10536:
10537: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 10538: IF FND_API.to_Boolean( p_init_msg_list )

10534: END IF;
10535:
10536:
10537: -- Initialize message list if p_init_msg_list is set to TRUE.
10538: IF FND_API.to_Boolean( p_init_msg_list )
10539: THEN
10540: FND_MSG_PUB.initialize;
10541: END IF;
10542:

Line 10547: x_return_status := FND_API.G_RET_STS_SUCCESS;

10543: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10544: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Start Process_Charges ',1,'Y');
10545: END IF;
10546:
10547: x_return_status := FND_API.G_RET_STS_SUCCESS;
10548: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10549: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Start Process_Charges:p_control_rec.pricing_event: '
10550: ||p_control_rec.pricing_event,1,'Y');
10551: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Start Process_Charges:p_control_rec.calculate_flag: '

Line 10622: IF FND_API.to_Boolean( p_commit ) THEN

10618:
10619: END If;--If (p_control_rec.pricing_event = 'BATCH') OR (p_control_rec.pricing_event = 'ORDER')
10620:
10621: -- Standard check for p_commit
10622: IF FND_API.to_Boolean( p_commit ) THEN
10623: COMMIT WORK;
10624: END IF;
10625:
10626: FND_MSG_PUB.Count_And_Get

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

10647:
10648:
10649: PROCEDURE Process_PRG(
10650: P_Api_Version_Number IN NUMBER,
10651: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
10652: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
10653: P_control_rec IN ASO_PRICING_INT.Pricing_Control_Rec_Type,
10654: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
10655: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

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

10648:
10649: PROCEDURE Process_PRG(
10650: P_Api_Version_Number IN NUMBER,
10651: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
10652: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
10653: P_control_rec IN ASO_PRICING_INT.Pricing_Control_Rec_Type,
10654: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
10655: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
10656: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 10913: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

10909:
10910: BEGIN
10911:
10912: -- Standard call to check for call compatibility.
10913: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
10914: p_api_version_number,
10915: l_api_name,
10916: G_PKG_NAME)
10917: THEN

Line 10918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10914: p_api_version_number,
10915: l_api_name,
10916: G_PKG_NAME)
10917: THEN
10918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10919: END IF;
10920:
10921:
10922: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 10923: IF FND_API.to_Boolean( p_init_msg_list )

10919: END IF;
10920:
10921:
10922: -- Initialize message list if p_init_msg_list is set to TRUE.
10923: IF FND_API.to_Boolean( p_init_msg_list )
10924: THEN
10925: FND_MSG_PUB.initialize;
10926: END IF;
10927:

Line 10932: x_return_status := FND_API.G_RET_STS_SUCCESS;

10928: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
10929: aso_debug_pub.add('ASO_PRICING_CORE_PVT:Start Process_PRG ',1,'Y');
10930: END IF;
10931:
10932: x_return_status := FND_API.G_RET_STS_SUCCESS;
10933:
10934: l_line_counter := 1;
10935: l_adj_counter := 1;
10936: l_rltn_counter := 1;

Line 11221: x_return_status := FND_API.G_RET_STS_ERROR;

11217:
11218: l_qte_header_rec.last_update_date := l_last_update_date;
11219:
11220: exception when no_data_found then
11221: x_return_status := FND_API.G_RET_STS_ERROR;
11222: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11223: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
11224: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
11225: FND_MSG_PUB.ADD;

Line 11227: raise FND_API.G_EXC_ERROR;

11223: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
11224: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
11225: FND_MSG_PUB.ADD;
11226: END IF;
11227: raise FND_API.G_EXC_ERROR;
11228: end;
11229:
11230: -- Setting up the Control record for Update quote
11231: l_def_profile_value := FND_PROFILE.value('ASO_ENABLE_DEFAULTING_RULE');

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

11233: aso_debug_pub.add('ASO_PRICING_CORE_PVT:l_def_profile_value - ASO_ENABLE_DEFAULTING_RULE:'||l_def_profile_value,1,'Y');
11234: END IF;
11235: If l_def_profile_value = 'Y' then
11236: l_pub_control_rec.DEFAULTING_FWK_FLAG := 'Y';
11237: l_pub_control_rec.DEFAULTING_FLAG := FND_API.G_TRUE;
11238: l_pub_control_rec.APPLICATION_TYPE_CODE := 'QUOTING HTML';/* Need to be changed if iStore uptakes defaulting. It should be input parameter */
11239: Else
11240: l_pub_control_rec.DEFAULTING_FWK_FLAG := 'N';
11241: l_pub_control_rec.DEFAULTING_FLAG := FND_API.G_FALSE;

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

11237: l_pub_control_rec.DEFAULTING_FLAG := FND_API.G_TRUE;
11238: l_pub_control_rec.APPLICATION_TYPE_CODE := 'QUOTING HTML';/* Need to be changed if iStore uptakes defaulting. It should be input parameter */
11239: Else
11240: l_pub_control_rec.DEFAULTING_FWK_FLAG := 'N';
11241: l_pub_control_rec.DEFAULTING_FLAG := FND_API.G_FALSE;
11242: End If;
11243:
11244: ASO_QUOTE_PUB.Update_Quote(
11245: p_api_version_number => 1.0,

Line 11246: p_init_msg_list => fnd_api.g_false,

11242: End If;
11243:
11244: ASO_QUOTE_PUB.Update_Quote(
11245: p_api_version_number => 1.0,
11246: p_init_msg_list => fnd_api.g_false,
11247: p_commit => fnd_api.g_false,
11248: P_Validation_Level => FND_API.G_VALID_LEVEL_NONE,
11249: P_Control_Rec => l_pub_control_rec,
11250: p_qte_header_rec => l_qte_header_rec,

Line 11247: p_commit => fnd_api.g_false,

11243:
11244: ASO_QUOTE_PUB.Update_Quote(
11245: p_api_version_number => 1.0,
11246: p_init_msg_list => fnd_api.g_false,
11247: p_commit => fnd_api.g_false,
11248: P_Validation_Level => FND_API.G_VALID_LEVEL_NONE,
11249: P_Control_Rec => l_pub_control_rec,
11250: p_qte_header_rec => l_qte_header_rec,
11251: p_qte_line_tbl => l_qte_line_tbl,

Line 11248: P_Validation_Level => FND_API.G_VALID_LEVEL_NONE,

11244: ASO_QUOTE_PUB.Update_Quote(
11245: p_api_version_number => 1.0,
11246: p_init_msg_list => fnd_api.g_false,
11247: p_commit => fnd_api.g_false,
11248: P_Validation_Level => FND_API.G_VALID_LEVEL_NONE,
11249: P_Control_Rec => l_pub_control_rec,
11250: p_qte_header_rec => l_qte_header_rec,
11251: p_qte_line_tbl => l_qte_line_tbl,
11252: p_price_adjustment_Tbl => l_price_adjustment_Tbl,

Line 11287: IF x_return_status = FND_API.G_RET_STS_ERROR then

11283: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After Update Quote X_Return_Status:'||X_Return_Status,1,'Y');
11284: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After Update Quote X_Msg_Count:'||X_Msg_Count,1,'Y');
11285: END IF;
11286:
11287: IF x_return_status = FND_API.G_RET_STS_ERROR then
11288: raise FND_API.G_EXC_ERROR;
11289: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
11290: raise FND_API.G_EXC_UNEXPECTED_ERROR;
11291: END IF;

Line 11288: raise FND_API.G_EXC_ERROR;

11284: aso_debug_pub.add('ASO_PRICING_CORE_PVT:After Update Quote X_Msg_Count:'||X_Msg_Count,1,'Y');
11285: END IF;
11286:
11287: IF x_return_status = FND_API.G_RET_STS_ERROR then
11288: raise FND_API.G_EXC_ERROR;
11289: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
11290: raise FND_API.G_EXC_UNEXPECTED_ERROR;
11291: END IF;
11292:

Line 11289: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

11285: END IF;
11286:
11287: IF x_return_status = FND_API.G_RET_STS_ERROR then
11288: raise FND_API.G_EXC_ERROR;
11289: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
11290: raise FND_API.G_EXC_UNEXPECTED_ERROR;
11291: END IF;
11292:
11293: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 11290: raise FND_API.G_EXC_UNEXPECTED_ERROR;

11286:
11287: IF x_return_status = FND_API.G_RET_STS_ERROR then
11288: raise FND_API.G_EXC_ERROR;
11289: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
11290: raise FND_API.G_EXC_UNEXPECTED_ERROR;
11291: END IF;
11292:
11293: IF aso_debug_pub.g_debug_flag = 'Y' THEN
11294: For i in 1..lx_Qte_Line_Tbl.count loop

Line 11536: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

11532: (p_control_rec =>l_req_control_rec
11533: ,x_return_status =>l_return_status
11534: ,x_return_status_Text =>l_return_status_Text
11535: );
11536: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11537: x_return_status := l_return_status;
11538: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
11539: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
11540: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_return_status_text, 1,255), FALSE);

Line 11543: RAISE FND_API.G_EXC_ERROR;

11539: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
11540: FND_MESSAGE.Set_Token('MSG_TXT', substr(l_return_status_text, 1,255), FALSE);
11541: FND_MSG_PUB.ADD;
11542: END IF;
11543: RAISE FND_API.G_EXC_ERROR;
11544: END IF;
11545:
11546: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
11547: aso_debug_pub.add('ASO_PRICING_CORE_PVT: End of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');

Line 11557: P_Init_Msg_List => FND_API.G_FALSE,

11553: END IF;
11554:
11555: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
11556: P_Api_Version_Number => 1.0,
11557: P_Init_Msg_List => FND_API.G_FALSE,
11558: P_Commit => FND_API.G_FALSE,
11559: p_control_rec => p_control_rec,
11560: p_qte_header_rec => p_qte_header_rec,
11561: p_insert_type => 'NO_HDR',

Line 11558: P_Commit => FND_API.G_FALSE,

11554:
11555: ASO_PRICING_CORE_PVT.Copy_Price_To_Quote(
11556: P_Api_Version_Number => 1.0,
11557: P_Init_Msg_List => FND_API.G_FALSE,
11558: P_Commit => FND_API.G_FALSE,
11559: p_control_rec => p_control_rec,
11560: p_qte_header_rec => p_qte_header_rec,
11561: p_insert_type => 'NO_HDR',
11562: x_return_status => x_return_status,

Line 11582: P_Init_Msg_List => FND_API.G_FALSE,

11578: END IF;
11579: If (p_control_rec.price_mode = 'ENTIRE_QUOTE') then
11580: ASO_PRICING_FLOWS_PVT.Price_Entire_Quote(
11581: P_Api_Version_Number => P_Api_Version_Number,
11582: P_Init_Msg_List => FND_API.G_FALSE,
11583: P_Commit => FND_API.G_FALSE,
11584: p_control_rec => p_control_rec,
11585: p_qte_header_rec => p_qte_header_rec,
11586: p_qte_line_tbl => ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl,

Line 11583: P_Commit => FND_API.G_FALSE,

11579: If (p_control_rec.price_mode = 'ENTIRE_QUOTE') then
11580: ASO_PRICING_FLOWS_PVT.Price_Entire_Quote(
11581: P_Api_Version_Number => P_Api_Version_Number,
11582: P_Init_Msg_List => FND_API.G_FALSE,
11583: P_Commit => FND_API.G_FALSE,
11584: p_control_rec => p_control_rec,
11585: p_qte_header_rec => p_qte_header_rec,
11586: p_qte_line_tbl => ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl,
11587: p_internal_call_flag => 'Y',

Line 11596: P_Init_Msg_List => FND_API.G_FALSE,

11592: Else
11593: /**CHANGE_LINE****/
11594: ASO_PRICING_FLOWS_PVT.Price_Quote_With_Change_Lines(
11595: P_Api_Version_Number => P_Api_Version_Number,
11596: P_Init_Msg_List => FND_API.G_FALSE,
11597: P_Commit => FND_API.G_FALSE,
11598: p_control_rec => p_control_rec,
11599: p_qte_header_rec => p_qte_header_rec,
11600: p_qte_line_tbl => ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl,

Line 11597: P_Commit => FND_API.G_FALSE,

11593: /**CHANGE_LINE****/
11594: ASO_PRICING_FLOWS_PVT.Price_Quote_With_Change_Lines(
11595: P_Api_Version_Number => P_Api_Version_Number,
11596: P_Init_Msg_List => FND_API.G_FALSE,
11597: P_Commit => FND_API.G_FALSE,
11598: p_control_rec => p_control_rec,
11599: p_qte_header_rec => p_qte_header_rec,
11600: p_qte_line_tbl => ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl,
11601: p_internal_call_flag => 'Y',

Line 11613: IF FND_API.to_Boolean( p_commit ) THEN

11609:
11610: end if;--l_track_var = 'Y'
11611:
11612: -- Standard check for p_commit
11613: IF FND_API.to_Boolean( p_commit ) THEN
11614: COMMIT WORK;
11615: END IF;
11616:
11617: FND_MSG_PUB.Count_And_Get