DBA Data[Home] [Help]

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 671: IF l_request_type = QP_GLOBALS.G_VALIDATE_SELLING_ROUNDING

667: END IF; --Java Engine Installed
668:
669: --pattern
670:
671: IF l_request_type = QP_GLOBALS.G_VALIDATE_SELLING_ROUNDING
672: THEN
673: oe_debug_pub.add('processing req VALIDATE_SELLING_ROUNDING');
674: QP_DELAYED_REQUESTS_UTIL.validate_selling_rounding(
675: p_currency_header_id => l_entity_id,

Line 687: IF l_request_type = QP_GLOBALS.G_CHECK_SEGMENT_LEVEL_IN_GROUP

683: RAISE FND_API.G_EXC_ERROR;
684: END IF;
685:
686:
687: IF l_request_type = QP_GLOBALS.G_CHECK_SEGMENT_LEVEL_IN_GROUP
688: THEN
689: oe_debug_pub.add('processing req CHECK_SEGMENT_LEVEL_IN_GROUP');
690: QP_DELAYED_REQUESTS_UTIL.check_segment_level_in_group(
691: p_list_line_id => l_entity_id,

Line 703: IF l_request_type = QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL

699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;
702:
703: IF l_request_type = QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL
704: THEN
705: oe_debug_pub.add('processing req CHECK_LINE_FOR_HEADER_QUAL');
706: QP_DELAYED_REQUESTS_UTIL.CHECK_LINE_FOR_HEADER_QUAL(
707: p_list_header_id => l_entity_id,

Line 719: IF l_request_type = QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS THEN

715: RAISE FND_API.G_EXC_ERROR;
716: END IF;
717:
718: -- Hierarchical Categories (sfiresto)
719: IF l_request_type = QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS THEN
720: oe_debug_pub.add('processing req CHECK_ENABLED_FUNC_AREAS');
721: QP_DELAYED_REQUESTS_UTIL.Check_Enabled_Func_Areas(
722: p_pte_source_system_id => l_entity_id,
723: x_return_status => l_return_status);

Line 737: if l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD then

733: --hw
734: -- delayed request for changed lines
735: if QP_PERF_PVT.enabled = 'Y' then
736:
737: if l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD then
738: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_ADD');
739: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_add(
740: p_list_line_id => l_entity_id,
741: p_list_header_id => l_request_rec.param2,

Line 744: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL then

740: p_list_line_id => l_entity_id,
741: p_list_header_id => l_request_rec.param2,
742: p_pricing_phase_id => l_request_rec.param1,
743: x_return_status => l_return_status);
744: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL then
745: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_DEL');
746: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_del(
747: p_list_line_id => l_entity_id,
748: p_list_header_id => l_request_rec.param2,

Line 753: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH then

749: p_pricing_phase_id => l_request_rec.param1,
750: p_product_attribute => l_request_rec.param3,
751: p_product_attr_value => l_request_rec.param4,
752: x_return_status => l_return_status);
753: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH then
754: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_PHASE');
755: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_ph(
756: p_list_line_id => l_entity_id,
757: p_list_header_id => l_request_rec.param2,

Line 761: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT then

757: p_list_header_id => l_request_rec.param2,
758: p_pricing_phase_id => l_request_rec.param1,
759: p_old_pricing_phase_id => l_request_rec.param3,
760: x_return_status => l_return_status);
761: elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT then
762: oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_ACTIVE');
763: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_act(
764: p_list_header_id => l_entity_id,
765: p_active_flag => l_request_rec.param1,

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

763: QP_DELAYED_REQUESTS_UTIL.update_changed_lines_act(
764: p_list_header_id => l_entity_id,
765: p_active_flag => l_request_rec.param1,
766: x_return_status => l_return_status);
767: --hvop elsif l_request_type = QP_GLOBALS.G_UPDATE_HVOP then
768: oe_debug_pub.add('processing req G_UPDATE_HVOP')
769: ;
770: QP_DELAYED_REQUESTS_UTIL.HVOP_Pricing_Setup(x_return_status => l_return_status);
771: --hvop

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

1369: oe_debug_pub.add('Entering Procedure Process_Delayed_Requests in Package QP_Delayed_Requests_Pvt');
1370:
1371: -- Process requests as per the dependency
1372: -- This procedure processes all requests.
1373: -- For each request type defined in QP_GLOBALS
1374: -- write one code block as shown below.
1375:
1376: -- start bug2091362
1377: Process_Request_for_ReqType

Line 1378: (p_request_type =>QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES

1374: -- write one code block as shown below.
1375:
1376: -- start bug2091362
1377: Process_Request_for_ReqType
1378: (p_request_type =>QP_GLOBALS.G_DUPLICATE_MODIFIER_LINES
1379: ,p_delete => FND_API.G_TRUE
1380: ,x_return_status => l_return_status
1381: );
1382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1392: (p_request_type =>QP_GLOBALS.G_DUPLICATE_LIST_LINES

1388: -- end bug2091362
1389:
1390:
1391: Process_Request_for_ReqType
1392: (p_request_type =>QP_GLOBALS.G_DUPLICATE_LIST_LINES
1393: ,p_delete => FND_API.G_TRUE
1394: ,x_return_status => l_return_status
1395: );
1396: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1406: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE

1402:
1403: /*included by spgopal for performance problem, to include phase_id and header_idinfo in qp_pricing_attributes table*/
1404:
1405: Process_Request_for_ReqType
1406: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE
1407: ,p_delete => FND_API.G_TRUE
1408: ,x_return_status => l_return_status
1409: );
1410: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1420: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE

1416:
1417: /*included by spgopal for pricing phase seeded data over-write problem to update the denormalised columns in QP_PRICING_PHASES*/
1418:
1419: Process_Request_for_ReqType
1420: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE
1421: ,p_delete => FND_API.G_TRUE
1422: ,x_return_status => l_return_status
1423: );
1424: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1433: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE

1429:
1430: /*fix for bug 1501138*/
1431: /*
1432: Process_Request_for_ReqType
1433: (p_request_type =>QP_GLOBALS.G_UPDATE_PRICING_PHASE
1434: ,p_delete => FND_API.G_TRUE
1435: ,x_return_status => l_return_status
1436: );
1437: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1446: (p_request_type =>QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS

1442:
1443: */
1444:
1445: Process_Request_for_ReqType
1446: (p_request_type =>QP_GLOBALS.G_MULTIPLE_PRICE_BREAK_ATTRS
1447: ,p_delete => FND_API.G_TRUE
1448: ,x_return_status => l_return_status
1449: );
1450: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1458: (p_request_type => QP_GLOBALS.G_MIXED_QUAL_SEG_LEVELS

1454: END IF;
1455:
1456:
1457: Process_Request_for_ReqType
1458: (p_request_type => QP_GLOBALS.G_MIXED_QUAL_SEG_LEVELS
1459: ,p_delete => FND_API.G_TRUE
1460: ,x_return_status => l_return_status
1461: );
1462: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1470: (p_request_type =>QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS

1466: END IF;
1467:
1468:
1469: Process_Request_for_ReqType
1470: (p_request_type =>QP_GLOBALS.G_OVERLAPPING_PRICE_BREAKS
1471: ,p_delete => FND_API.G_TRUE
1472: ,x_return_status => l_return_status
1473: );
1474: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1482: (p_request_type =>QP_GLOBALS.G_MAINTAIN_QUALIFIER_DEN_COLS

1478: END IF;
1479:
1480:
1481: Process_Request_for_ReqType
1482: (p_request_type =>QP_GLOBALS.G_MAINTAIN_QUALIFIER_DEN_COLS
1483: ,p_delete => FND_API.G_TRUE
1484: ,x_return_status => l_return_status
1485: );
1486: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1493: (p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND

1489: RAISE FND_API.G_EXC_ERROR;
1490: END IF;
1491:
1492: Process_Request_for_ReqType
1493: (p_request_type =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND
1494: ,p_delete => FND_API.G_TRUE
1495: ,x_return_status => l_return_status
1496: );
1497: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1504: (p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND

1500: RAISE FND_API.G_EXC_ERROR;
1501: END IF;
1502:
1503: Process_Request_for_ReqType
1504: (p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND
1505: ,p_delete => FND_API.G_TRUE
1506: ,x_return_status => l_return_status
1507: );
1508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1515: (p_request_type =>QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS

1511: RAISE FND_API.G_EXC_ERROR;
1512: END IF;
1513:
1514: Process_Request_for_ReqType
1515: (p_request_type =>QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS
1516: ,p_delete => FND_API.G_TRUE
1517: ,x_return_status => l_return_status
1518: );
1519: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1526: (p_request_type =>QP_GLOBALS.G_UPDATE_QUALIFIER_STATUS

1522: RAISE FND_API.G_EXC_ERROR;
1523: END IF;
1524:
1525: Process_Request_for_ReqType
1526: (p_request_type =>QP_GLOBALS.G_UPDATE_QUALIFIER_STATUS
1527: ,p_delete => FND_API.G_TRUE
1528: ,x_return_status => l_return_status
1529: );
1530: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1537: (p_request_type =>QP_GLOBALS.G_CREATE_SECURITY_PRIVILEGE

1533: RAISE FND_API.G_EXC_ERROR;
1534: END IF;
1535:
1536: Process_Request_for_ReqType
1537: (p_request_type =>QP_GLOBALS.G_CREATE_SECURITY_PRIVILEGE
1538: ,p_delete => FND_API.G_TRUE
1539: ,x_return_status => l_return_status
1540: );
1541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1548: (p_request_type =>QP_GLOBALS.G_UPDATE_ATTRIBUTE_STATUS

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

Line 1559: (p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND

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

Line 1570: (p_request_type =>QP_GLOBALS.G_MAINTAIN_LIST_HEADER_PHASES

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

Line 1581: (p_request_type =>QP_GLOBALS.G_MAINTAIN_FACTOR_LIST_ATTRS

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

Line 1593: (p_request_type =>QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL

1589: END IF;
1590:
1591: -- mkarya for attribute manager
1592: Process_Request_for_ReqType
1593: (p_request_type =>QP_GLOBALS.G_CHECK_LINE_FOR_HEADER_QUAL
1594: ,p_delete => FND_API.G_TRUE
1595: ,x_return_status => l_return_status
1596: );
1597: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1605: (p_request_type =>QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS

1601: END IF;
1602:
1603: -- Hierarchical Categories (sfiresto)
1604: Process_Request_for_ReqType
1605: (p_request_type =>QP_GLOBALS.G_CHECK_ENABLED_FUNC_AREAS
1606: ,p_delete => FND_API.G_TRUE
1607: ,x_return_status => l_return_status
1608: );
1609: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1621: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD

1617:
1618: -- delayed request for changed lines
1619: if QP_PERF_PVT.enabled = 'Y' then
1620: Process_Request_for_ReqType
1621: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD
1622: ,p_delete => FND_API.G_TRUE
1623: ,x_return_status => l_return_status
1624: );
1625: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1632: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL

1628: RAISE FND_API.G_EXC_ERROR;
1629: END IF;
1630:
1631: Process_Request_for_ReqType
1632: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL
1633: ,p_delete => FND_API.G_TRUE
1634: ,x_return_status => l_return_status
1635: );
1636: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1643: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT

1639: RAISE FND_API.G_EXC_ERROR;
1640: END IF;
1641:
1642: Process_Request_for_ReqType
1643: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT
1644: ,p_delete => FND_API.G_TRUE
1645: ,x_return_status => l_return_status
1646: );
1647: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1654: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH

1650: RAISE FND_API.G_EXC_ERROR;
1651: END IF;
1652:
1653: Process_Request_for_ReqType
1654: (p_request_type =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH
1655: ,p_delete => FND_API.G_TRUE
1656: ,x_return_status => l_return_status
1657: );
1658: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1669: (p_request_type =>QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN

1665:
1666: -- mkarya for pattern delayed requests
1667: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Installed = 'Y' THEN
1668: Process_Request_for_ReqType
1669: (p_request_type =>QP_GLOBALS.G_MAINTAIN_HEADER_PATTERN
1670: ,p_delete => FND_API.G_TRUE
1671: ,x_return_status => l_return_status
1672: );
1673:

Line 1681: (p_request_type =>QP_GLOBALS.G_MAINTAIN_LINE_PATTERN

1677: RAISE FND_API.G_EXC_ERROR;
1678: END IF;
1679:
1680: Process_Request_for_ReqType
1681: (p_request_type =>QP_GLOBALS.G_MAINTAIN_LINE_PATTERN
1682: ,p_delete => FND_API.G_TRUE
1683: ,x_return_status => l_return_status
1684: );
1685:

Line 1693: (p_request_type =>QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN

1689: RAISE FND_API.G_EXC_ERROR;
1690: END IF;
1691:
1692: Process_Request_for_ReqType
1693: (p_request_type =>QP_GLOBALS.G_MAINTAIN_PRODUCT_PATTERN
1694: ,p_delete => FND_API.G_TRUE
1695: ,x_return_status => l_return_status
1696: );
1697: