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.QP_DELAYED_REQUESTS_PVT dependencies on QP_GLOBALS

Line 284: IF l_request_type = QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS

280: RAISE FND_API.G_EXC_ERROR;
281: END IF;
282:
283:
284: IF l_request_type = QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS
285: THEN
286: oe_debug_pub.add('Processing check_mult_price_break_attrs');
287: QP_DELAYED_REQUESTS_UTIL.Check_Mult_Price_Break_Attrs(
288: p_parent_list_line_id => l_request_rec.param1,

Line 299: IF l_request_type = QP_GLOBALS.G_MIXED_QUAL_SEG_LEVELS

295: RAISE FND_API.G_EXC_ERROR;
296: END IF;
297:
298:
299: IF l_request_type = QP_GLOBALS.G_MIXED_QUAL_SEG_LEVELS
300: THEN
301: oe_debug_pub.add('Processing check_mult_price_break_attrs');
302: QP_DELAYED_REQUESTS_UTIL.Check_Mixed_Qual_Seg_Levels(
303: x_return_status => l_return_status,

Line 338: IF l_request_type = QP_Globals.G_UPGRADE_PRICE_BREAKS

334: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
335: RAISE FND_API.G_EXC_ERROR;
336: END IF;
337:
338: IF l_request_type = QP_Globals.G_UPGRADE_PRICE_BREAKS
339: THEN
340: QP_DELAYED_REQUESTS_UTIL.Upgrade_Price_Breaks
341: ( p_pbh_id => l_entity_id
342: ,p_list_line_no => l_request_rec.param1

Line 374: IF l_request_type = QP_GLOBALS.G_MAINTAIN_QUALIFIER_DEN_COLS

370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:
373:
374: IF l_request_type = QP_GLOBALS.G_MAINTAIN_QUALIFIER_DEN_COLS
375: THEN
376: QP_DELAYED_REQUESTS_UTIL.Maintain_Qualifier_Den_Cols(
377: p_list_header_id => l_entity_id,
378: x_return_status => l_return_status);

Line 387: IF l_request_type = QP_GLOBALS.G_UPDATE_LIST_QUAL_IND

383: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
384: RAISE FND_API.G_EXC_ERROR;
385: END IF;
386:
387: IF l_request_type = QP_GLOBALS.G_UPDATE_LIST_QUAL_IND
388: THEN
389:
390: --dbms_output.put_line('calling list qualification indicator');
391: QP_DELAYED_REQUESTS_UTIL.Update_List_Qualification_Ind

Line 402: IF l_request_type = QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS

398: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
399: RAISE FND_API.G_EXC_ERROR;
400: END IF;
401:
402: IF l_request_type = QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS
403: THEN
404:
405: --dbms_output.put_line('calling UPDATE_LIMITS_COLUMNS');
406: QP_DELAYED_REQUESTS_UTIL.Update_Limits_Columns

Line 417: IF l_request_type = QP_GLOBALS.G_UPDATE_QUALIFIER_STATUS

413: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416:
417: IF l_request_type = QP_GLOBALS.G_UPDATE_QUALIFIER_STATUS
418: THEN
419: --dbms_output.put_line('calling UPDATE_QUALIFIER_STATUS ');
420: QP_DELAYED_REQUESTS_UTIL.Update_Qualifier_Status
421: ( p_list_header_id => l_entity_id

Line 432: IF l_request_type = QP_GLOBALS.G_CREATE_SECURITY_PRIVILEGE

428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
431:
432: IF l_request_type = QP_GLOBALS.G_CREATE_SECURITY_PRIVILEGE
433: THEN
434: --dbms_output.put_line('calling CREATE_SECURITY_PRIVILEGE ');
435: QP_DELAYED_REQUESTS_UTIL.Create_Security_Privilege
436: ( p_list_header_id => l_entity_id

Line 447: IF l_request_type = QP_GLOBALS.G_UPDATE_ATTRIBUTE_STATUS

443: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
444: RAISE FND_API.G_EXC_ERROR;
445: END IF;
446:
447: IF l_request_type = QP_GLOBALS.G_UPDATE_ATTRIBUTE_STATUS
448: THEN
449: --dbms_output.put_line('calling UPDATE_ATTRIBUTE_STATUS ');
450: QP_DELAYED_REQUESTS_UTIL.Update_Attribute_Status
451: ( p_list_header_id => l_entity_id

Line 466: IF l_request_type = QP_GLOBALS.G_UPDATE_CHILD_BREAKS

462: RAISE FND_API.G_EXC_ERROR;
463: END IF;
464:
465:
466: IF l_request_type = QP_GLOBALS.G_UPDATE_CHILD_BREAKS
467: THEN
468: QP_DELAYED_REQUESTS_UTIL.update_child_break_lines(
469: p_list_line_id => l_entity_id,
470: x_return_status => l_return_status);

Line 479: IF l_request_type = QP_GLOBALS.G_UPDATE_CHILD_PRICING_ATTR

475: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
476: RAISE FND_API.G_EXC_ERROR;
477: END IF;
478:
479: IF l_request_type = QP_GLOBALS.G_UPDATE_CHILD_PRICING_ATTR
480: THEN
481: QP_DELAYED_REQUESTS_UTIL.update_child_pricing_attr(
482: x_return_status => l_return_status,
483: p_list_line_id => l_entity_id);

Line 494: IF l_request_type = QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE

490: END IF;
491:
492: /*included by spgopal for performance problem, to include phase_id and header_idinfo in qp_pricing_attributes table*/
493:
494: IF l_request_type = QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE
495: THEN
496: BEGIN --[Bug 4457903] Call update_pricing_attr_phase only if
497: --the line id is present in the QP_LIST_LINES table
498: SELECT 1 into l_count from QP_LIST_LINES

Line 519: IF l_request_type = QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS

515: RAISE FND_API.G_EXC_ERROR;
516: END IF;
517:
518: --Added by rchellam on 29-AUG-2001. POSCO Change.
519: IF l_request_type = QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS
520: THEN
521: QP_DELAYED_REQUESTS_UTIL.Maintain_Factor_List_Attrs(
522: p_list_line_id => l_entity_id,
523: x_return_status => l_return_status);

Line 533: IF l_request_type = QP_GLOBALS.G_WARN_SAME_QUALIFIER_GROUP

529: RAISE FND_API.G_EXC_ERROR;
530: END IF;
531:
532: /*fix for bug 1501138*/
533: IF l_request_type = QP_GLOBALS.G_WARN_SAME_QUALIFIER_GROUP
534: THEN
535: oe_debug_pub.add('qual context'||l_request_rec.param3||' attr '||l_request_rec.param4||' grp no '||l_request_rec.param2);
536:
537: /*

Line 558: IF l_request_type = QP_GLOBALS.G_UPDATE_LINE_QUAL_IND

554: RAISE FND_API.G_EXC_ERROR;
555: END IF;
556:
557:
558: IF l_request_type = QP_GLOBALS.G_UPDATE_LINE_QUAL_IND
559: THEN
560:
561: --dbms_output.put_line('calling line qualification indicator');
562: QP_DELAYED_REQUESTS_UTIL.Update_Line_Qualification_Ind

Line 575: IF l_request_type = QP_GLOBALS.G_UPDATE_PRICING_PHASE

571: END IF;
572:
573: /*included by spgopal for pricing phase seeded data over-write problem to update the denormalised columns in QP_PRICING_PHASES*/
574:
575: IF l_request_type = QP_GLOBALS.G_UPDATE_PRICING_PHASE
576: THEN
577: oe_debug_pub.add('processing req UPDATE_PRICING_PHASE');
578: QP_DELAYED_REQUESTS_UTIL.update_pricing_phase(
579: p_pricing_phase_id => l_request_rec.param1,

Line 593: IF l_request_type = QP_GLOBALS.G_UPDATE_MANUAL_MODIFIER_FLAG

589: RAISE FND_API.G_EXC_ERROR;
590: END IF;
591:
592: -- Essilor Fix bug 2789138
593: IF l_request_type = QP_GLOBALS.G_UPDATE_MANUAL_MODIFIER_FLAG
594: THEN
595: oe_debug_pub.add('processing req UPDATE_MANUAL_MODIFIER_FLAG');
596: QP_DELAYED_REQUESTS_UTIL.Update_manual_modifier_flag(
597: p_pricing_phase_id => l_request_rec.param1,

Line 609: IF l_request_type = QP_GLOBALS.G_UPDATE_HVOP

605: RAISE FND_API.G_EXC_ERROR;
606: END IF;
607:
608: --hvop
609: IF l_request_type = QP_GLOBALS.G_UPDATE_HVOP
610: THEN
611: oe_debug_pub.add('processing req UPDATE_HVOP');
612: QP_DELAYED_REQUESTS_UTIL.HVOP_Pricing_Setup (x_return_status => l_return_status);
613: END IF;

Line 625: IF l_request_type = QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN THEN

621:
622: --pattern
623: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
624:
625: IF l_request_type = QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN THEN
626: oe_debug_pub.add('Processing req Attribute Groups');
627: QP_DELAYED_REQUESTS_UTIL.maintain_header_pattern(
628: p_list_header_id => l_request_rec.entity_Id
629: , p_qualifier_group => l_request_rec.request_unique_key1

Line 638: IF l_request_type = QP_GLOBALS.G_MAINTAIN_LINE_PATTERN THEN

634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
635: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
636: RAISE FND_API.G_EXC_ERROR;
637: END IF;
638: IF l_request_type = QP_GLOBALS.G_MAINTAIN_LINE_PATTERN THEN
639: oe_debug_pub.add('Processing req Attribute Groups');
640: QP_DELAYED_REQUESTS_UTIL.maintain_line_pattern(
641: p_list_header_id => l_request_rec.entity_Id
642: , p_list_line_id => l_request_rec.request_unique_key1

Line 653: IF l_request_type = QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN THEN

649: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
650: RAISE FND_API.G_EXC_ERROR;
651: END IF;
652:
653: IF l_request_type = QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN THEN
654: oe_debug_pub.add('Processing req Attribute Groups');
655: QP_DELAYED_REQUESTS_UTIL.maintain_product_pattern(
656: p_list_header_id => l_request_rec.entity_Id
657: , p_list_line_id => l_request_rec.request_unique_key1

Line 681: oe_debug_pub.ADD('JAGAN REQUIRED ENTITY CODE IS : ' || QP_GLOBALS.G_ENTITY_MODIFIER_LIST ||','|| QP_GLOBALS.G_ENTITY_MODIFIERS);

677: oe_debug_pub.ADD('JAGAN JAVA ENGINE INSTALLED : ' || QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed);
678: oe_debug_pub.ADD('JAGAN QP PATTERN SEARCH : ' || FND_PROFILE.VALUE('QP_PATTERN_SEARCH'));
679: oe_debug_pub.ADD('JAGAN REQUEST TYPE : ' || l_request_type);
680: oe_debug_pub.ADD('JAGAN ENTITY CODE : ' || l_entity_code);
681: oe_debug_pub.ADD('JAGAN REQUIRED ENTITY CODE IS : ' || QP_GLOBALS.G_ENTITY_MODIFIER_LIST ||','|| QP_GLOBALS.G_ENTITY_MODIFIERS);
682:
683: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
684: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
685: --AND ( l_entity_code = QP_GLOBALS.G_ENTITY_MODIFIER_LIST OR l_entity_code = QP_GLOBALS.G_ENTITY_MODIFIERS OR l_entity_code = QP_GLOBALS.G_ENTITY_ALL) THEN

Line 685: --AND ( l_entity_code = QP_GLOBALS.G_ENTITY_MODIFIER_LIST OR l_entity_code = QP_GLOBALS.G_ENTITY_MODIFIERS OR l_entity_code = QP_GLOBALS.G_ENTITY_ALL) THEN

681: oe_debug_pub.ADD('JAGAN REQUIRED ENTITY CODE IS : ' || QP_GLOBALS.G_ENTITY_MODIFIER_LIST ||','|| QP_GLOBALS.G_ENTITY_MODIFIERS);
682:
683: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
684: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
685: --AND ( l_entity_code = QP_GLOBALS.G_ENTITY_MODIFIER_LIST OR l_entity_code = QP_GLOBALS.G_ENTITY_MODIFIERS OR l_entity_code = QP_GLOBALS.G_ENTITY_ALL) THEN
686:
687: IF l_request_type = QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN THEN
688: oe_debug_pub.add('Processing req Attribute Groups');
689: QP_DELAYED_REQUESTS_UTIL.maintain_header_pattern(

Line 687: IF l_request_type = QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN THEN

683: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
684: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
685: --AND ( l_entity_code = QP_GLOBALS.G_ENTITY_MODIFIER_LIST OR l_entity_code = QP_GLOBALS.G_ENTITY_MODIFIERS OR l_entity_code = QP_GLOBALS.G_ENTITY_ALL) THEN
686:
687: IF l_request_type = QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN THEN
688: oe_debug_pub.add('Processing req Attribute Groups');
689: QP_DELAYED_REQUESTS_UTIL.maintain_header_pattern(
690: p_list_header_id => l_request_rec.entity_Id
691: , p_qualifier_group => l_request_rec.request_unique_key1

Line 701: IF l_request_type = QP_GLOBALS.G_MAINTAIN_LINE_PATTERN THEN

697: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
698: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
699: RAISE FND_API.G_EXC_ERROR;
700: END IF;
701: IF l_request_type = QP_GLOBALS.G_MAINTAIN_LINE_PATTERN THEN
702: oe_debug_pub.add('Processing req Attribute Groups');
703: QP_DELAYED_REQUESTS_UTIL.maintain_line_pattern(
704: p_list_header_id => l_request_rec.entity_Id
705: , p_list_line_id => l_request_rec.request_unique_key1

Line 717: IF l_request_type = QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN THEN

713: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;
716:
717: IF l_request_type = QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN THEN
718: oe_debug_pub.add('Processing req Attribute Groups');
719: QP_DELAYED_REQUESTS_UTIL.maintain_product_pattern(
720: p_list_header_id => l_request_rec.entity_Id
721: , p_list_line_id => l_request_rec.request_unique_key1

Line 736: IF l_request_type = QP_GLOBALS.G_VALIDATE_SELLING_ROUNDING

732: END IF; --pl/sql pattern search profile on
733: END IF; --Java Engine Installed
734:
735: --pattern
736: IF l_request_type = QP_GLOBALS.G_VALIDATE_SELLING_ROUNDING
737: THEN
738: oe_debug_pub.add('processing req VALIDATE_SELLING_ROUNDING');
739: QP_DELAYED_REQUESTS_UTIL.validate_selling_rounding(
740: p_currency_header_id => l_entity_id,

Line 752: IF l_request_type = QP_GLOBALS.G_CHECK_SEGMENT_LEVEL_IN_GROUP

748: RAISE FND_API.G_EXC_ERROR;
749: END IF;
750:
751:
752: IF l_request_type = QP_GLOBALS.G_CHECK_SEGMENT_LEVEL_IN_GROUP
753: THEN
754: oe_debug_pub.add('processing req CHECK_SEGMENT_LEVEL_IN_GROUP');
755: QP_DELAYED_REQUESTS_UTIL.check_segment_level_in_group(
756: p_list_line_id => l_entity_id,

Line 768: IF l_request_type = QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL

764: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
765: RAISE FND_API.G_EXC_ERROR;
766: END IF;
767:
768: IF l_request_type = QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL
769: THEN
770: oe_debug_pub.add('processing req CHECK_LINE_FOR_HEADER_QUAL');
771: QP_DELAYED_REQUESTS_UTIL.CHECK_LINE_FOR_HEADER_QUAL(
772: p_list_header_id => l_entity_id,

Line 784: IF l_request_type = QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS THEN

780: RAISE FND_API.G_EXC_ERROR;
781: END IF;
782:
783: -- Hierarchical Categories (sfiresto)
784: IF l_request_type = QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS THEN
785: oe_debug_pub.add('processing req CHECK_ENABLED_FUNC_AREAS');
786: QP_DELAYED_REQUESTS_UTIL.Check_Enabled_Func_Areas(
787: p_pte_source_system_id => l_entity_id,
788: x_return_status => l_return_status);

Line 802: if l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD then

798: --hw
799: -- delayed request for changed lines
800: if QP_PERF_PVT.enabled = 'Y' then
801:
802: if l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD then
803: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_ADD');
804: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_add(
805: p_list_line_id => l_entity_id,
806: p_list_header_id => l_request_rec.param2,

Line 809: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL then

805: p_list_line_id => l_entity_id,
806: p_list_header_id => l_request_rec.param2,
807: p_pricing_phase_id => l_request_rec.param1,
808: x_return_status => l_return_status);
809: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL then
810: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_DEL');
811: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_del(
812: p_list_line_id => l_entity_id,
813: p_list_header_id => l_request_rec.param2,

Line 818: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH then

814: p_pricing_phase_id => l_request_rec.param1,
815: p_product_attribute => l_request_rec.param3,
816: p_product_attr_value => l_request_rec.param4,
817: x_return_status => l_return_status);
818: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH then
819: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_PHASE');
820: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_ph(
821: p_list_line_id => l_entity_id,
822: p_list_header_id => l_request_rec.param2,

Line 826: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT then

822: p_list_header_id => l_request_rec.param2,
823: p_pricing_phase_id => l_request_rec.param1,
824: p_old_pricing_phase_id => l_request_rec.param3,
825: x_return_status => l_return_status);
826: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT then
827: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_ACTIVE');
828: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_act(
829: p_list_header_id => l_entity_id,
830: p_active_flag => l_request_rec.param1,

Line 832: --hvop elsif l_request_type = QP_GLOBALS.G_UPDATE_HVOP then

828: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_act(
829: p_list_header_id => l_entity_id,
830: p_active_flag => l_request_rec.param1,
831: x_return_status => l_return_status);
832: --hvop elsif l_request_type = QP_GLOBALS.G_UPDATE_HVOP then
833: oe_debug_pub.add('processing req G_UPDATE_HVOP')
834: ;
835: QP_DELAYED_REQUESTS_UTIL.HVOP_Pricing_Setup(x_return_status => l_return_status);
836: --hvop

Line 1438: -- For each request type defined in QP_GLOBALS

1434: oe_debug_pub.add('Entering Procedure Process_Delayed_Requests in Package QP_Delayed_Requests_Pvt');
1435:
1436: -- Process requests as per the dependency
1437: -- This procedure processes all requests.
1438: -- For each request type defined in QP_GLOBALS
1439: -- write one code block as shown below.
1440:
1441: -- start bug2091362
1442: Process_Request_for_ReqType

Line 1443: (p_request_type =>QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES

1439: -- write one code block as shown below.
1440:
1441: -- start bug2091362
1442: Process_Request_for_ReqType
1443: (p_request_type =>QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES
1444: ,p_delete => FND_API.G_TRUE
1445: ,x_return_status => l_return_status
1446: );
1447: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1457: (p_request_type =>QP_GLOBALS.G_DUPLICATE_LIST_LINES

1453: -- end bug2091362
1454:
1455:
1456: Process_Request_for_ReqType
1457: (p_request_type =>QP_GLOBALS.G_DUPLICATE_LIST_LINES
1458: ,p_delete => FND_API.G_TRUE
1459: ,x_return_status => l_return_status
1460: );
1461: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1471: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE

1467:
1468: /*included by spgopal for performance problem, to include phase_id and header_idinfo in qp_pricing_attributes table*/
1469:
1470: Process_Request_for_ReqType
1471: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE
1472: ,p_delete => FND_API.G_TRUE
1473: ,x_return_status => l_return_status
1474: );
1475: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1485: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE

1481:
1482: /*included by spgopal for pricing phase seeded data over-write problem to update the denormalised columns in QP_PRICING_PHASES*/
1483:
1484: Process_Request_for_ReqType
1485: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE
1486: ,p_delete => FND_API.G_TRUE
1487: ,x_return_status => l_return_status
1488: );
1489: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1498: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE

1494:
1495: /*fix for bug 1501138*/
1496: /*
1497: Process_Request_for_ReqType
1498: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE
1499: ,p_delete => FND_API.G_TRUE
1500: ,x_return_status => l_return_status
1501: );
1502: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1511: (p_request_type =>QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS

1507:
1508: */
1509:
1510: Process_Request_for_ReqType
1511: (p_request_type =>QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS
1512: ,p_delete => FND_API.G_TRUE
1513: ,x_return_status => l_return_status
1514: );
1515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1523: (p_request_type => QP_GLOBALS.G_MIXED_QUAL_SEG_LEVELS

1519: END IF;
1520:
1521:
1522: Process_Request_for_ReqType
1523: (p_request_type => QP_GLOBALS.G_MIXED_QUAL_SEG_LEVELS
1524: ,p_delete => FND_API.G_TRUE
1525: ,x_return_status => l_return_status
1526: );
1527: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1535: (p_request_type =>QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS

1531: END IF;
1532:
1533:
1534: Process_Request_for_ReqType
1535: (p_request_type =>QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS
1536: ,p_delete => FND_API.G_TRUE
1537: ,x_return_status => l_return_status
1538: );
1539: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1547: (p_request_type =>QP_GLOBALS.G_MAINTAIN_QUALIFIER_DEN_COLS

1543: END IF;
1544:
1545:
1546: Process_Request_for_ReqType
1547: (p_request_type =>QP_GLOBALS.G_MAINTAIN_QUALIFIER_DEN_COLS
1548: ,p_delete => FND_API.G_TRUE
1549: ,x_return_status => l_return_status
1550: );
1551: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1558: (p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND

1554: RAISE FND_API.G_EXC_ERROR;
1555: END IF;
1556:
1557: Process_Request_for_ReqType
1558: (p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND
1559: ,p_delete => FND_API.G_TRUE
1560: ,x_return_status => l_return_status
1561: );
1562: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1569: (p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND

1565: RAISE FND_API.G_EXC_ERROR;
1566: END IF;
1567:
1568: Process_Request_for_ReqType
1569: (p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND
1570: ,p_delete => FND_API.G_TRUE
1571: ,x_return_status => l_return_status
1572: );
1573: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1580: (p_request_type =>QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS

1576: RAISE FND_API.G_EXC_ERROR;
1577: END IF;
1578:
1579: Process_Request_for_ReqType
1580: (p_request_type =>QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS
1581: ,p_delete => FND_API.G_TRUE
1582: ,x_return_status => l_return_status
1583: );
1584: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1591: (p_request_type =>QP_GLOBALS.G_UPDATE_QUALIFIER_STATUS

1587: RAISE FND_API.G_EXC_ERROR;
1588: END IF;
1589:
1590: Process_Request_for_ReqType
1591: (p_request_type =>QP_GLOBALS.G_UPDATE_QUALIFIER_STATUS
1592: ,p_delete => FND_API.G_TRUE
1593: ,x_return_status => l_return_status
1594: );
1595: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1602: (p_request_type =>QP_GLOBALS.G_CREATE_SECURITY_PRIVILEGE

1598: RAISE FND_API.G_EXC_ERROR;
1599: END IF;
1600:
1601: Process_Request_for_ReqType
1602: (p_request_type =>QP_GLOBALS.G_CREATE_SECURITY_PRIVILEGE
1603: ,p_delete => FND_API.G_TRUE
1604: ,x_return_status => l_return_status
1605: );
1606: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1613: (p_request_type =>QP_GLOBALS.G_UPDATE_ATTRIBUTE_STATUS

1609: RAISE FND_API.G_EXC_ERROR;
1610: END IF;
1611:
1612: Process_Request_for_ReqType
1613: (p_request_type =>QP_GLOBALS.G_UPDATE_ATTRIBUTE_STATUS
1614: ,p_delete => FND_API.G_TRUE
1615: ,x_return_status => l_return_status
1616: );
1617: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1624: (p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND

1620: RAISE FND_API.G_EXC_ERROR;
1621: END IF;
1622:
1623: Process_Request_for_ReqType
1624: (p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND
1625: ,p_delete => FND_API.G_TRUE
1626: ,x_return_status => l_return_status
1627: );
1628: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1635: (p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES

1631: RAISE FND_API.G_EXC_ERROR;
1632: END IF;
1633:
1634: Process_Request_for_ReqType
1635: (p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES
1636: ,p_delete => FND_API.G_TRUE
1637: ,x_return_status => l_return_status
1638: );
1639: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1646: (p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS

1642: RAISE FND_API.G_EXC_ERROR;
1643: END IF;
1644:
1645: Process_Request_for_ReqType
1646: (p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS
1647: ,p_delete => FND_API.G_TRUE
1648: ,x_return_status => l_return_status
1649: );
1650: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1658: (p_request_type =>QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL

1654: END IF;
1655:
1656: -- mkarya for attribute manager
1657: Process_Request_for_ReqType
1658: (p_request_type =>QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL
1659: ,p_delete => FND_API.G_TRUE
1660: ,x_return_status => l_return_status
1661: );
1662: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1670: (p_request_type =>QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS

1666: END IF;
1667:
1668: -- Hierarchical Categories (sfiresto)
1669: Process_Request_for_ReqType
1670: (p_request_type =>QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS
1671: ,p_delete => FND_API.G_TRUE
1672: ,x_return_status => l_return_status
1673: );
1674: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1686: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD

1682:
1683: -- delayed request for changed lines
1684: if QP_PERF_PVT.enabled = 'Y' then
1685: Process_Request_for_ReqType
1686: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD
1687: ,p_delete => FND_API.G_TRUE
1688: ,x_return_status => l_return_status
1689: );
1690: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1697: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL

1693: RAISE FND_API.G_EXC_ERROR;
1694: END IF;
1695:
1696: Process_Request_for_ReqType
1697: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL
1698: ,p_delete => FND_API.G_TRUE
1699: ,x_return_status => l_return_status
1700: );
1701: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1708: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT

1704: RAISE FND_API.G_EXC_ERROR;
1705: END IF;
1706:
1707: Process_Request_for_ReqType
1708: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT
1709: ,p_delete => FND_API.G_TRUE
1710: ,x_return_status => l_return_status
1711: );
1712: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1719: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH

1715: RAISE FND_API.G_EXC_ERROR;
1716: END IF;
1717:
1718: Process_Request_for_ReqType
1719: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH
1720: ,p_delete => FND_API.G_TRUE
1721: ,x_return_status => l_return_status
1722: );
1723: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1734: (p_request_type =>QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN

1730:
1731: -- mkarya for pattern delayed requests
1732: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1733: Process_Request_for_ReqType
1734: (p_request_type =>QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN
1735: ,p_delete => FND_API.G_TRUE
1736: ,x_return_status => l_return_status
1737: );
1738:

Line 1746: (p_request_type =>QP_GLOBALS.G_MAINTAIN_LINE_PATTERN

1742: RAISE FND_API.G_EXC_ERROR;
1743: END IF;
1744:
1745: Process_Request_for_ReqType
1746: (p_request_type =>QP_GLOBALS.G_MAINTAIN_LINE_PATTERN
1747: ,p_delete => FND_API.G_TRUE
1748: ,x_return_status => l_return_status
1749: );
1750:

Line 1758: (p_request_type =>QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN

1754: RAISE FND_API.G_EXC_ERROR;
1755: END IF;
1756:
1757: Process_Request_for_ReqType
1758: (p_request_type =>QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN
1759: ,p_delete => FND_API.G_TRUE
1760: ,x_return_status => l_return_status
1761: );
1762:

Line 1778: (p_request_type =>QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN

1774: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'N' THEN
1775: IF FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'M' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'P' OR FND_PROFILE.VALUE('QP_PATTERN_SEARCH') = 'B' THEN
1776:
1777: Process_Request_for_ReqType
1778: (p_request_type =>QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN
1779: ,p_delete => FND_API.G_TRUE
1780: ,x_return_status => l_return_status
1781: );
1782:

Line 1790: (p_request_type =>QP_GLOBALS.G_MAINTAIN_LINE_PATTERN

1786: RAISE FND_API.G_EXC_ERROR;
1787: END IF;
1788:
1789: Process_Request_for_ReqType
1790: (p_request_type =>QP_GLOBALS.G_MAINTAIN_LINE_PATTERN
1791: ,p_delete => FND_API.G_TRUE
1792: ,x_return_status => l_return_status
1793: );
1794:

Line 1802: (p_request_type =>QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN

1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;
1800:
1801: Process_Request_for_ReqType
1802: (p_request_type =>QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN
1803: ,p_delete => FND_API.G_TRUE
1804: ,x_return_status => l_return_status
1805: );
1806: