eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BLANKET_UTIL dependencies on OE_DELAYED_REQUESTS_PVT

Line 301: IF oe_delayed_requests_pvt.g_delayed_requests(I).param1 IS NULL THEN

297:
298: if l_debug_level > 0 then
299: oe_debug_pub.add('Blanket In create price list');
300: end if;
301: IF oe_delayed_requests_pvt.g_delayed_requests(I).param1 IS NULL THEN
302: RETURN;
303: END IF;
304:
305: gpr_price_list_rec.list_header_id := FND_API.G_MISS_NUM;

Line 306: gpr_price_list_rec.name := oe_delayed_requests_pvt.g_delayed_requests(I).param1;

302: RETURN;
303: END IF;
304:
305: gpr_price_list_rec.list_header_id := FND_API.G_MISS_NUM;
306: gpr_price_list_rec.name := oe_delayed_requests_pvt.g_delayed_requests(I).param1;
307: gpr_price_list_rec.list_type_code := 'PRL';
308: gpr_price_list_rec.list_source_code := 'BLKT';
309: -- gpr_price_list_rec.description := oe_delayed_requests_pvt.g_delayed_requests(I).paramtext1;
310: gpr_price_list_rec.currency_code := oe_delayed_requests_pvt.g_delayed_requests(I).param2;

Line 309: -- gpr_price_list_rec.description := oe_delayed_requests_pvt.g_delayed_requests(I).paramtext1;

305: gpr_price_list_rec.list_header_id := FND_API.G_MISS_NUM;
306: gpr_price_list_rec.name := oe_delayed_requests_pvt.g_delayed_requests(I).param1;
307: gpr_price_list_rec.list_type_code := 'PRL';
308: gpr_price_list_rec.list_source_code := 'BLKT';
309: -- gpr_price_list_rec.description := oe_delayed_requests_pvt.g_delayed_requests(I).paramtext1;
310: gpr_price_list_rec.currency_code := oe_delayed_requests_pvt.g_delayed_requests(I).param2;
311: --11i10 Pricing Changes Start
312: if oe_code_control.get_code_release_level >= '110510' then
313: gpr_price_list_rec.list_source_code := 'BSO';

Line 310: gpr_price_list_rec.currency_code := oe_delayed_requests_pvt.g_delayed_requests(I).param2;

306: gpr_price_list_rec.name := oe_delayed_requests_pvt.g_delayed_requests(I).param1;
307: gpr_price_list_rec.list_type_code := 'PRL';
308: gpr_price_list_rec.list_source_code := 'BLKT';
309: -- gpr_price_list_rec.description := oe_delayed_requests_pvt.g_delayed_requests(I).paramtext1;
310: gpr_price_list_rec.currency_code := oe_delayed_requests_pvt.g_delayed_requests(I).param2;
311: --11i10 Pricing Changes Start
312: if oe_code_control.get_code_release_level >= '110510' then
313: gpr_price_list_rec.list_source_code := 'BSO';
314: gpr_price_list_rec.orig_system_header_ref :=

Line 315: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;

311: --11i10 Pricing Changes Start
312: if oe_code_control.get_code_release_level >= '110510' then
313: gpr_price_list_rec.list_source_code := 'BSO';
314: gpr_price_list_rec.orig_system_header_ref :=
315: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;
316: gpr_price_list_rec.shareable_flag := 'N';
317: gpr_price_list_rec.sold_to_org_id :=
318: oe_delayed_requests_pvt.g_delayed_requests(I).param7;
319: -- Add blanket header qualifier

Line 318: oe_delayed_requests_pvt.g_delayed_requests(I).param7;

314: gpr_price_list_rec.orig_system_header_ref :=
315: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;
316: gpr_price_list_rec.shareable_flag := 'N';
317: gpr_price_list_rec.sold_to_org_id :=
318: oe_delayed_requests_pvt.g_delayed_requests(I).param7;
319: -- Add blanket header qualifier
320: l_qualifiers_tbl(1).excluder_flag := 'N';
321: l_qualifiers_tbl(1).comparison_operator_code := '=';
322: l_qualifiers_tbl(1).qualifier_context := 'ORDER';

Line 327: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;

323: l_qualifiers_tbl(1).qualifier_precedence := 700;
324: l_qualifiers_tbl(1).qualifier_attribute := 'QUALIFIER_ATTRIBUTE5';
325: -- Blanket Header ID is the qualifier attribute value
326: l_qualifiers_tbl(1).qualifier_attr_value :=
327: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;
328: l_qualifiers_tbl(1).qualifier_grouping_no := 1;
329: l_qualifiers_tbl(1).operation := QP_GLOBALS.G_OPR_CREATE;
330: end if;
331: --11i10 Pricing Changes End

Line 337: lheader_id := oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;

333: gpr_price_list_rec.operation := QP_GLOBALS.G_OPR_CREATE;
334: --MOAC changes to force the PL tobe created in a ORG
335: gpr_price_list_rec.org_id := mo_global.get_current_org_id;
336: gpr_price_list_rec.global_flag := 'N';
337: lheader_id := oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;
338:
339: I := oe_delayed_requests_pvt.g_delayed_requests.first;
340:
341: WHILE I IS NOT NULL

Line 339: I := oe_delayed_requests_pvt.g_delayed_requests.first;

335: gpr_price_list_rec.org_id := mo_global.get_current_org_id;
336: gpr_price_list_rec.global_flag := 'N';
337: lheader_id := oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;
338:
339: I := oe_delayed_requests_pvt.g_delayed_requests.first;
340:
341: WHILE I IS NOT NULL
342: LOOP
343: IF oe_delayed_requests_pvt.g_delayed_requests(I).request_type = 'CREATE_BLANKET_PRICE_LIST'

Line 343: IF oe_delayed_requests_pvt.g_delayed_requests(I).request_type = 'CREATE_BLANKET_PRICE_LIST'

339: I := oe_delayed_requests_pvt.g_delayed_requests.first;
340:
341: WHILE I IS NOT NULL
342: LOOP
343: IF oe_delayed_requests_pvt.g_delayed_requests(I).request_type = 'CREATE_BLANKET_PRICE_LIST'
344: AND
345: oe_delayed_requests_pvt.g_delayed_requests(I).entity_code =
346: oe_blanket_pub.g_entity_blanket_LINE THEN
347: if l_debug_level > 0 then

Line 345: oe_delayed_requests_pvt.g_delayed_requests(I).entity_code =

341: WHILE I IS NOT NULL
342: LOOP
343: IF oe_delayed_requests_pvt.g_delayed_requests(I).request_type = 'CREATE_BLANKET_PRICE_LIST'
344: AND
345: oe_delayed_requests_pvt.g_delayed_requests(I).entity_code =
346: oe_blanket_pub.g_entity_blanket_LINE THEN
347: if l_debug_level > 0 then
348: oe_debug_pub.add('Blanket In create price list - line');
349: end if;

Line 350: IF oe_delayed_requests_pvt.g_delayed_requests(I).param1 IS NULL THEN

346: oe_blanket_pub.g_entity_blanket_LINE THEN
347: if l_debug_level > 0 then
348: oe_debug_pub.add('Blanket In create price list - line');
349: end if;
350: IF oe_delayed_requests_pvt.g_delayed_requests(I).param1 IS NULL THEN
351: if l_debug_level > 0 then
352: oe_debug_pub.add('Blanket In Skip');
353: end if;
354: GOTO SKIP_LINE;

Line 356: g_line_id_tbl(K).line_id := oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;

352: oe_debug_pub.add('Blanket In Skip');
353: end if;
354: GOTO SKIP_LINE;
355: END IF;
356: g_line_id_tbl(K).line_id := oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;
357:
358: gpr_price_list_line_tbl(K).list_line_id := FND_API.G_MISS_NUM;
359: gpr_price_list_line_tbl(K).list_line_type_code := 'PLL';
360: gpr_price_list_line_tbl(K).operation := QP_GLOBALS.G_OPR_CREATE;

Line 361: gpr_price_list_line_tbl(K).operand := oe_delayed_requests_pvt.g_delayed_requests(I).param1;

357:
358: gpr_price_list_line_tbl(K).list_line_id := FND_API.G_MISS_NUM;
359: gpr_price_list_line_tbl(K).list_line_type_code := 'PLL';
360: gpr_price_list_line_tbl(K).operation := QP_GLOBALS.G_OPR_CREATE;
361: gpr_price_list_line_tbl(K).operand := oe_delayed_requests_pvt.g_delayed_requests(I).param1;
362: gpr_price_list_line_tbl(K).arithmetic_operator := 'UNIT_PRICE';
363:
364: -- Bug 3209215, Issue 9.1
365: -- Pass precedence value on price list lines

Line 373: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CAT' THEN

369: gpr_pricing_attr_tbl(K).list_line_id := FND_API.G_MISS_NUM;
370: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE_CONTEXT := 'ITEM';
371:
372:
373: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CAT' THEN
374:
375: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE2';
376: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
377:

Line 376: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;

372:
373: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CAT' THEN
374:
375: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE2';
376: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
377:
378: ELSIF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'ALL' THEN
379:
380: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE3';

Line 378: ELSIF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'ALL' THEN

374:
375: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE2';
376: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
377:
378: ELSIF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'ALL' THEN
379:
380: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE3';
381: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := 'ALL';
382:

Line 386: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;

382:
383: ELSE
384:
385: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE1';
386: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
387:
388: -- 11i10 Pricing Change
389: -- Send customer item on price list line record
390: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CUST'

Line 390: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CUST'

386: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
387:
388: -- 11i10 Pricing Change
389: -- Send customer item on price list line record
390: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CUST'
391: AND OE_Code_Control.Get_Code_Release_Level >= '110510'
392: THEN
393: gpr_price_list_line_tbl(K).customer_item_id :=
394: oe_delayed_requests_pvt.g_delayed_requests(I).param8;

Line 394: oe_delayed_requests_pvt.g_delayed_requests(I).param8;

390: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CUST'
391: AND OE_Code_Control.Get_Code_Release_Level >= '110510'
392: THEN
393: gpr_price_list_line_tbl(K).customer_item_id :=
394: oe_delayed_requests_pvt.g_delayed_requests(I).param8;
395: oe_debug_pub.add('sending cust item id :'||
396: gpr_price_list_line_tbl(K).customer_item_id);
397: END IF;
398:

Line 403: gpr_pricing_attr_tbl(K).PRODUCT_UOM_CODE := oe_delayed_requests_pvt.g_delayed_requests(I).param2;

399: END IF;
400:
401:
402:
403: gpr_pricing_attr_tbl(K).PRODUCT_UOM_CODE := oe_delayed_requests_pvt.g_delayed_requests(I).param2;
404: gpr_pricing_attr_tbl(K).EXCLUDER_FLAG := 'N';
405: gpr_pricing_attr_tbl(K).ATTRIBUTE_GROUPING_NO := 1;
406: gpr_pricing_attr_tbl(K).PRICE_LIST_LINE_INDEX := K;
407: gpr_pricing_attr_tbl(K).operation := QP_GLOBALS.G_OPR_CREATE;

Line 410: oe_delayed_requests_pvt.g_delayed_requests.delete(I);

406: gpr_pricing_attr_tbl(K).PRICE_LIST_LINE_INDEX := K;
407: gpr_pricing_attr_tbl(K).operation := QP_GLOBALS.G_OPR_CREATE;
408: k:= K+1;
409: << SKIP_LINE >>
410: oe_delayed_requests_pvt.g_delayed_requests.delete(I);
411: END IF;
412: I := oe_delayed_requests_pvt.g_delayed_requests.next(I);
413:
414: END LOOP;

Line 412: I := oe_delayed_requests_pvt.g_delayed_requests.next(I);

408: k:= K+1;
409: << SKIP_LINE >>
410: oe_delayed_requests_pvt.g_delayed_requests.delete(I);
411: END IF;
412: I := oe_delayed_requests_pvt.g_delayed_requests.next(I);
413:
414: END LOOP;
415:
416: /*

Line 429: gpr_qualifiers_tbl(K).qualifier_attr_value := oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;

425: gpr_qualifiers_tbl(K).qualifier_context := 'ORDER';
426: gpr_qualifiers_tbl(K).qualifier_attribute := 'QUALIFIER_ATTRIBUTE6';
427: gpr_qualifiers_tbl(K).comparison_operator_code := '=';
428: -- Blanket Line ID is the qualifier attribute value
429: gpr_qualifiers_tbl(K).qualifier_attr_value := oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;
430: oe_debug_pub.add('entity id :'||oe_delayed_requests_pvt.g_delayed_requests(I).entity_id);
431: gpr_qualifiers_tbl(K).operation := QP_GLOBALS.G_OPR_CREATE;
432: END IF;
433: */

Line 430: oe_debug_pub.add('entity id :'||oe_delayed_requests_pvt.g_delayed_requests(I).entity_id);

426: gpr_qualifiers_tbl(K).qualifier_attribute := 'QUALIFIER_ATTRIBUTE6';
427: gpr_qualifiers_tbl(K).comparison_operator_code := '=';
428: -- Blanket Line ID is the qualifier attribute value
429: gpr_qualifiers_tbl(K).qualifier_attr_value := oe_delayed_requests_pvt.g_delayed_requests(I).entity_id;
430: oe_debug_pub.add('entity id :'||oe_delayed_requests_pvt.g_delayed_requests(I).entity_id);
431: gpr_qualifiers_tbl(K).operation := QP_GLOBALS.G_OPR_CREATE;
432: END IF;
433: */
434:

Line 628: /*IF oe_delayed_requests_pvt.g_delayed_requests(I).param3 IS NULL THEN

624: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
625: --
626: BEGIN
627: --begin commented the below if statement for bug 4762658
628: /*IF oe_delayed_requests_pvt.g_delayed_requests(I).param3 IS NULL THEN
629: RETURN;
630: END IF;*/
631: --end for bug 4762658
632: --for bug 3229225

Line 633: IF (oe_delayed_requests_pvt.g_delayed_requests(I).param1 IS NULL OR oe_delayed_requests_pvt.g_delayed_requests(I).param1=FND_API.G_MISS_NUM)

629: RETURN;
630: END IF;*/
631: --end for bug 4762658
632: --for bug 3229225
633: IF (oe_delayed_requests_pvt.g_delayed_requests(I).param1 IS NULL OR oe_delayed_requests_pvt.g_delayed_requests(I).param1=FND_API.G_MISS_NUM)
634: THEN
635: IF l_debug_level > 0
636: THEN
637: oe_debug_pub.add('Skip for null values');

Line 639: oe_delayed_requests_pvt.g_delayed_requests.delete(I);

635: IF l_debug_level > 0
636: THEN
637: oe_debug_pub.add('Skip for null values');
638: END IF;
639: oe_delayed_requests_pvt.g_delayed_requests.delete(I);
640: GOTO SKIP_LINE1;
641: END IF;
642:
643: gpr_price_list_line_tbl(K).list_line_id := FND_API.G_MISS_NUM;

Line 646: gpr_price_list_line_tbl(K).operand := oe_delayed_requests_pvt.g_delayed_requests(I).param1;

642:
643: gpr_price_list_line_tbl(K).list_line_id := FND_API.G_MISS_NUM;
644: gpr_price_list_line_tbl(K).list_line_type_code := 'PLL';
645: gpr_price_list_line_tbl(K).operation := QP_GLOBALS.G_OPR_CREATE;
646: gpr_price_list_line_tbl(K).operand := oe_delayed_requests_pvt.g_delayed_requests(I).param1;
647: gpr_price_list_line_tbl(K).arithmetic_operator := 'UNIT_PRICE';
648: gpr_price_list_line_tbl(K).list_header_id :=
649: oe_delayed_requests_pvt.g_delayed_requests(I).param5 ;
650: -- Bug 3209215, Issue 9.1

Line 649: oe_delayed_requests_pvt.g_delayed_requests(I).param5 ;

645: gpr_price_list_line_tbl(K).operation := QP_GLOBALS.G_OPR_CREATE;
646: gpr_price_list_line_tbl(K).operand := oe_delayed_requests_pvt.g_delayed_requests(I).param1;
647: gpr_price_list_line_tbl(K).arithmetic_operator := 'UNIT_PRICE';
648: gpr_price_list_line_tbl(K).list_header_id :=
649: oe_delayed_requests_pvt.g_delayed_requests(I).param5 ;
650: -- Bug 3209215, Issue 9.1
651: -- Pass precedence value on price list lines
652: gpr_price_list_line_tbl(K).product_precedence := 1;
653:

Line 657: oe_delayed_requests_pvt.g_delayed_requests(I).param5;

653:
654: gpr_pricing_attr_tbl(K).pricing_attribute_id := FND_API.G_MISS_NUM;
655: gpr_pricing_attr_tbl(K).list_line_id := FND_API.G_MISS_NUM;
656: gpr_pricing_attr_tbl(K).list_header_id :=
657: oe_delayed_requests_pvt.g_delayed_requests(I).param5;
658: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE_CONTEXT := 'ITEM';
659:
660: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CAT' THEN
661:

Line 660: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CAT' THEN

656: gpr_pricing_attr_tbl(K).list_header_id :=
657: oe_delayed_requests_pvt.g_delayed_requests(I).param5;
658: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE_CONTEXT := 'ITEM';
659:
660: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CAT' THEN
661:
662: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE2';
663: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
664:

Line 663: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;

659:
660: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CAT' THEN
661:
662: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE2';
663: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
664:
665: ELSIF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'ALL' THEN
666:
667: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE3';

Line 665: ELSIF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'ALL' THEN

661:
662: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE2';
663: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
664:
665: ELSIF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'ALL' THEN
666:
667: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE3';
668: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := 'ALL';
669:

Line 673: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;

669:
670: ELSE
671:
672: gpr_pricing_attr_tbl(K).PRODUCT_ATTRIBUTE := 'PRICING_ATTRIBUTE1';
673: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
674:
675: -- 11i10 Pricing Change
676: -- Send customer item on price list line record
677: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CUST'

Line 677: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CUST'

673: gpr_pricing_attr_tbl(K).PRODUCT_ATTR_VALUE := oe_delayed_requests_pvt.g_delayed_requests(I).param3;
674:
675: -- 11i10 Pricing Change
676: -- Send customer item on price list line record
677: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CUST'
678: AND OE_Code_Control.Get_Code_Release_Level >= '110510'
679: THEN
680: gpr_price_list_line_tbl(K).customer_item_id :=
681: oe_delayed_requests_pvt.g_delayed_requests(I).param8;

Line 681: oe_delayed_requests_pvt.g_delayed_requests(I).param8;

677: IF oe_delayed_requests_pvt.g_delayed_requests(I).param4 = 'CUST'
678: AND OE_Code_Control.Get_Code_Release_Level >= '110510'
679: THEN
680: gpr_price_list_line_tbl(K).customer_item_id :=
681: oe_delayed_requests_pvt.g_delayed_requests(I).param8;
682: oe_debug_pub.add('sending cust item id :'||
683: gpr_price_list_line_tbl(K).customer_item_id);
684: END IF;
685:

Line 688: gpr_pricing_attr_tbl(K).PRODUCT_UOM_CODE := oe_delayed_requests_pvt.g_delayed_requests(I).param2;

684: END IF;
685:
686: END IF;
687:
688: gpr_pricing_attr_tbl(K).PRODUCT_UOM_CODE := oe_delayed_requests_pvt.g_delayed_requests(I).param2;
689: gpr_pricing_attr_tbl(K).EXCLUDER_FLAG := 'N';
690: gpr_pricing_attr_tbl(K).ATTRIBUTE_GROUPING_NO := 1;
691: gpr_pricing_attr_tbl(K).PRICE_LIST_LINE_INDEX := K;
692: gpr_pricing_attr_tbl(K).operation := QP_GLOBALS.G_OPR_CREATE;

Line 694: --oe_delayed_requests_pvt.g_delayed_requests.delete(I);

690: gpr_pricing_attr_tbl(K).ATTRIBUTE_GROUPING_NO := 1;
691: gpr_pricing_attr_tbl(K).PRICE_LIST_LINE_INDEX := K;
692: gpr_pricing_attr_tbl(K).operation := QP_GLOBALS.G_OPR_CREATE;
693:
694: --oe_delayed_requests_pvt.g_delayed_requests.delete(I);
695:
696: QP_PRICE_LIST_GRP.Process_Price_List
697: ( p_api_version_number => 1
698: , p_init_msg_list => FND_API.G_FALSE

Line 778: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id ;

774: price_list_id = ppr_price_list_line_tbl(1).list_header_id,
775: lock_control = lock_control + 1
776: WHERE
777: line_id =
778: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id ;
779:
780: Update oe_blanket_lines_ext
781: set qp_list_line_id = ppr_price_list_line_tbl(1).list_line_id
782: WHERE

Line 784: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id ;

780: Update oe_blanket_lines_ext
781: set qp_list_line_id = ppr_price_list_line_tbl(1).list_line_id
782: WHERE
783: line_id =
784: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id ;
785:
786: << SKIP_LINE1 >>
787: g_new_price_list := false;
788: EXCEPTION

Line 837: gpr_price_list_line_tbl(K).list_line_id := oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param1 ;

833: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
834: --
835: BEGIN
836: x_return_status:= FND_API.G_RET_STS_SUCCESS;
837: gpr_price_list_line_tbl(K).list_line_id := oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param1 ;
838: gpr_price_list_line_tbl(K).operation := QP_GLOBALS.G_OPR_UPDATE;
839: gpr_price_list_line_tbl(K).list_header_id :=
840: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;
841: gpr_price_list_line_tbl(K).end_date_active :=sysdate;

Line 840: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;

836: x_return_status:= FND_API.G_RET_STS_SUCCESS;
837: gpr_price_list_line_tbl(K).list_line_id := oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param1 ;
838: gpr_price_list_line_tbl(K).operation := QP_GLOBALS.G_OPR_UPDATE;
839: gpr_price_list_line_tbl(K).list_header_id :=
840: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;
841: gpr_price_list_line_tbl(K).end_date_active :=sysdate;
842:
843: IF((NOT IS_BLANKET_PRICE_LIST(p_price_list_id => oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param3
844: ,p_blanket_header_id =>oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param4 ))

Line 843: IF((NOT IS_BLANKET_PRICE_LIST(p_price_list_id => oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param3

839: gpr_price_list_line_tbl(K).list_header_id :=
840: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;
841: gpr_price_list_line_tbl(K).end_date_active :=sysdate;
842:
843: IF((NOT IS_BLANKET_PRICE_LIST(p_price_list_id => oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param3
844: ,p_blanket_header_id =>oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param4 ))
845: AND (gpr_price_list_line_tbl(K).list_line_id is not null))
846: THEN
847: QP_PRICE_LIST_GRP.Process_Price_List

Line 844: ,p_blanket_header_id =>oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param4 ))

840: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;
841: gpr_price_list_line_tbl(K).end_date_active :=sysdate;
842:
843: IF((NOT IS_BLANKET_PRICE_LIST(p_price_list_id => oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param3
844: ,p_blanket_header_id =>oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).Param4 ))
845: AND (gpr_price_list_line_tbl(K).list_line_id is not null))
846: THEN
847: QP_PRICE_LIST_GRP.Process_Price_List
848: ( p_api_version_number => 1

Line 877: WHERE line_id = oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id ;

873: END IF;
874:
875: Update oe_blanket_lines_ext
876: set qp_list_line_id = Null
877: WHERE line_id = oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id ;
878: END IF;
879:
880:
881: EXCEPTION

Line 2388: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>

2384: fnd_message.set_token('ATTRIBUTE',
2385: OE_Order_UTIL.Get_Attribute_Name('LINE_NUMBER'));
2386: OE_MSG_PUB.Add;
2387: ELSE
2388: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
2389: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2390: p_Entity_Id => p_line_rec.line_id,
2391: p_requesting_entity_code =>
2392: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

Line 2469: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>

2465: oe_debug_pub.add('before logging request for item uniqueness');
2466: end if;
2467:
2468: --validate item uniqueness
2469: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>
2470: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,
2471: p_Entity_Id => p_line_rec.line_id,
2472: p_requesting_entity_code =>
2473: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

Line 2728: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>

2724: END IF;
2725:
2726: IF NOT OE_GLOBALS.EQUAL (p_line_rec.end_date_active, l_old_line_rec.end_date_active) THEN
2727: --validate item uniqueness
2728: OE_Delayed_Requests_Pvt.Log_Request(p_Entity_Code =>
2729: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE ,
2730: p_Entity_Id => p_line_rec.line_id,
2731: p_requesting_entity_code =>
2732: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

Line 2917: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>

2913: --for bug 3229225.Commented out NOCOPY /* file.sql.39 change */ the If condition and added modified condition
2914: -- IF p_line_rec.unit_list_price IS NOT NULL
2915: IF NOT OE_GLOBALS.EQUAL(p_line_rec.unit_list_price,p_old_line_rec.unit_list_price)
2916: THEN
2917: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
2918: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2919: p_Entity_Id => p_line_rec.line_id,
2920: p_requesting_entity_code =>
2921: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

Line 2995: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>

2991: if l_debug_level > 0 then
2992: oe_debug_pub.add('log ADD_BLANKET_PRICE_LIST_LINE');
2993: end if;
2994:
2995: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
2996: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
2997: p_Entity_Id => p_line_rec.line_id,
2998: p_requesting_entity_code =>
2999: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

Line 3044: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>

3040: oe_debug_pub.add('qp list line id :'||p_line_rec.qp_list_line_id);
3041: oe_debug_pub.add('Log delayed request: CLEAR_BLANKET_PRICE_LIST_LINE');
3042: end if;
3043:
3044: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
3045: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3046: p_Entity_Id => p_line_rec.line_id,
3047: p_requesting_entity_code =>
3048: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

Line 3089: oe_delayed_requests_pvt.Log_request

3085: oe_msg_pub.add;
3086: x_return_status := FND_API.G_RET_STS_ERROR;
3087: ELSE
3088: -- Log delayed request to create new modifier list line
3089: oe_delayed_requests_pvt.Log_request
3090: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,
3091: p_Entity_Id => p_line_rec.line_id,
3092: p_requesting_entity_code =>
3093: OE_BLANKET_pub.G_ENTITY_BLANKET_LINE,

Line 3913: OE_Delayed_Requests_PVT.Log_Request

3909: x_return_status := l_return_status;
3910: END IF;
3911:
3912: IF NOT OE_GLOBALS.Equal(x_return_status, FND_API.G_RET_STS_ERROR) THEN
3913: OE_Delayed_Requests_PVT.Log_Request
3914: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
3915: ,p_Entity_Id => p_header_rec.header_id
3916: ,p_requesting_entity_code =>
3917: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER

Line 3943: OE_Delayed_Requests_PVT.Log_Request

3939: THEN
3940: if (NOT OE_GLOBALS.Equal(p_header_rec.start_date_active,l_old_header_rec.start_date_active) OR
3941: NOT OE_GLOBALS.Equal(p_header_rec.end_date_active,l_old_header_rec.end_date_active))
3942: THEN
3943: OE_Delayed_Requests_PVT.Log_Request
3944: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
3945: ,p_Entity_Id => p_header_rec.header_id
3946: ,p_requesting_entity_code =>
3947: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER

Line 3965: OE_Delayed_Requests_PVT.Log_Request

3961: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
3962: THEN
3963: if (NOT OE_GLOBALS.Equal(p_header_rec.sold_to_org_id,l_old_header_rec.sold_to_org_id) and
3964: p_header_rec.operation = oe_globals.g_opr_update) THEN
3965: OE_Delayed_Requests_PVT.Log_Request
3966: (p_entity_code => OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER
3967: ,p_Entity_Id => p_header_rec.header_id
3968: ,p_param1 => p_header_rec.sold_to_org_id
3969: ,p_requesting_entity_code =>

Line 3989: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>

3985: l_new_pl_name := p_header_rec.new_price_list_name;
3986: else
3987: l_new_pl_name := p_header_rec.price_list_name;
3988: end if;
3989: oe_delayed_requests_pvt.Log_request(p_Entity_Code =>
3990: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER,
3991: p_Entity_Id => p_header_rec.header_id,
3992: p_requesting_entity_code =>
3993: OE_BLANKET_pub.G_ENTITY_BLANKET_HEADER,

Line 4015: oe_delayed_requests_pvt.Log_request

4011:
4012: -- 11i10 Pricing Changes
4013: -- Log request to create new modifier
4014: IF g_new_modifier_list THEN
4015: oe_delayed_requests_pvt.Log_request
4016: (p_entity_code => oe_blanket_pub.g_entity_blanket_header,
4017: p_Entity_Id => p_header_rec.header_id,
4018: p_requesting_entity_code =>
4019: oe_blanket_pub.g_entity_blanket_header,

Line 7132: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

7128: x_return_status := FND_API.G_RET_STS_SUCCESS;
7129:
7130: -- Process Header requests
7131:
7132: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
7133: (p_entity_code => OE_BLANKET_PUB.G_ENTITY_BLANKET_HEADER
7134: ,p_delete => FND_API.G_TRUE
7135: ,x_return_status => l_return_status
7136: );

Line 7145: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

7141: END IF;
7142:
7143: -- Process Line Level Request
7144:
7145: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
7146: (p_entity_code => OE_BLANKET_PUB.G_ENTITY_BLANKET_LINE
7147: ,p_delete => FND_API.G_TRUE
7148: ,x_return_status => l_return_status
7149: );

Line 7269: OE_Delayed_Requests_PVT.Clear_Request(lx_return_status); --bug 4691643

7265:
7266: EXCEPTION
7267:
7268: WHEN FND_API.G_EXC_ERROR THEN
7269: OE_Delayed_Requests_PVT.Clear_Request(lx_return_status); --bug 4691643
7270: x_return_status := FND_API.G_RET_STS_ERROR;
7271:
7272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7273: OE_Delayed_Requests_PVT.Clear_Request(lx_return_status); --bug 4691643

Line 7273: OE_Delayed_Requests_PVT.Clear_Request(lx_return_status); --bug 4691643

7269: OE_Delayed_Requests_PVT.Clear_Request(lx_return_status); --bug 4691643
7270: x_return_status := FND_API.G_RET_STS_ERROR;
7271:
7272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7273: OE_Delayed_Requests_PVT.Clear_Request(lx_return_status); --bug 4691643
7274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7275:
7276: WHEN OTHERS THEN
7277: OE_Delayed_Requests_PVT.Clear_Request(lx_return_status); --bug 4691643

Line 7277: OE_Delayed_Requests_PVT.Clear_Request(lx_return_status); --bug 4691643

7273: OE_Delayed_Requests_PVT.Clear_Request(lx_return_status); --bug 4691643
7274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7275:
7276: WHEN OTHERS THEN
7277: OE_Delayed_Requests_PVT.Clear_Request(lx_return_status); --bug 4691643
7278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7279:
7280: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7281: THEN

Line 7302: IF oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2 < 1 THEN

7298: --
7299: BEGIN
7300: x_return_status := FND_API.G_RET_STS_SUCCESS;
7301:
7302: IF oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2 < 1 THEN
7303: l_valid := 'N';
7304: ELSE
7305: BEGIN
7306: SELECT 'N'

Line 7310: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2

7306: SELECT 'N'
7307: INTO l_valid
7308: FROM oe_blanket_lines L
7309: WHERE L.line_number =
7310: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2
7311: AND L.header_id =
7312: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1
7313: AND L.line_id <>
7314: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id;

Line 7312: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1

7308: FROM oe_blanket_lines L
7309: WHERE L.line_number =
7310: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2
7311: AND L.header_id =
7312: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1
7313: AND L.line_id <>
7314: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id;
7315:
7316: EXCEPTION

Line 7314: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id;

7310: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2
7311: AND L.header_id =
7312: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1
7313: AND L.line_id <>
7314: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id;
7315:
7316: EXCEPTION
7317: WHEN no_data_found THEN
7318: l_valid := 'Y';

Line 7384: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id;

7380:
7381: x_return_status := FND_API.G_RET_STS_SUCCESS;
7382:
7383: l_line_id :=
7384: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id;
7385: l_item_id :=
7386: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1;
7387: l_header_id :=
7388: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;

Line 7386: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1;

7382:
7383: l_line_id :=
7384: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id;
7385: l_item_id :=
7386: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1;
7387: l_header_id :=
7388: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;
7389: l_item_identifier_type :=
7390: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param3;

Line 7388: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;

7384: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id;
7385: l_item_id :=
7386: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1;
7387: l_header_id :=
7388: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;
7389: l_item_identifier_type :=
7390: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param3;
7391:
7392: l_ordered_item_id :=

Line 7390: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param3;

7386: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param1;
7387: l_header_id :=
7388: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param2;
7389: l_item_identifier_type :=
7390: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param3;
7391:
7392: l_ordered_item_id :=
7393: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param4;
7394:

Line 7393: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param4;

7389: l_item_identifier_type :=
7390: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param3;
7391:
7392: l_ordered_item_id :=
7393: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param4;
7394:
7395: l_ordered_item :=
7396: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param5;
7397:

Line 7396: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param5;

7392: l_ordered_item_id :=
7393: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param4;
7394:
7395: l_ordered_item :=
7396: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).param5;
7397:
7398:
7399:
7400: l_start_date_active :=

Line 7401: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).date_param1;

7397:
7398:
7399:
7400: l_start_date_active :=
7401: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).date_param1;
7402: l_end_date_active :=
7403: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).date_param2;
7404:
7405: if l_debug_level > 0 then

Line 7403: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).date_param2;

7399:
7400: l_start_date_active :=
7401: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).date_param1;
7402: l_end_date_active :=
7403: oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).date_param2;
7404:
7405: if l_debug_level > 0 then
7406: oe_debug_pub.add('In validate Item Uniqueness');
7407: oe_debug_pub.add('item identifier type :'|| l_item_identifier_type);