349: x_old_MODIFIER_LIST_rec := l_old_MODIFIER_LIST_rec;
350:
351: oe_debug_pub.add('manoj - value of called_from_ui before delete_reqs_for_deleted_entity = ' || l_control_rec.called_from_ui);
352: -- mkarya If process_modifiers has been called from public package, then ONLY call
353: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
354: if l_control_rec.called_from_ui = 'N' then
355: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
356: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
357: p_entity_id => l_MODIFIER_LIST_rec.list_header_id,
351: oe_debug_pub.add('manoj - value of called_from_ui before delete_reqs_for_deleted_entity = ' || l_control_rec.called_from_ui);
352: -- mkarya If process_modifiers has been called from public package, then ONLY call
353: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
354: if l_control_rec.called_from_ui = 'N' then
355: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
356: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
357: p_entity_id => l_MODIFIER_LIST_rec.list_header_id,
358: x_return_status => l_return_status );
359: end if;
366: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
367: x_old_MODIFIER_LIST_rec := l_old_MODIFIER_LIST_rec;
368:
369: -- mkarya If process_modifiers has been called from public package, then ONLY call
370: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
371: if l_control_rec.called_from_ui = 'N' then
372: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
373: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
374: p_entity_id => l_MODIFIER_LIST_rec.list_header_id,
368:
369: -- mkarya If process_modifiers has been called from public package, then ONLY call
370: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
371: if l_control_rec.called_from_ui = 'N' then
372: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
373: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
374: p_entity_id => l_MODIFIER_LIST_rec.list_header_id,
375: x_return_status => l_return_status );
376: end if;
391: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
392: x_old_MODIFIER_LIST_rec := l_old_MODIFIER_LIST_rec;
393:
394: -- mkarya If process_modifiers has been called from public package, then ONLY call
395: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
396: if l_control_rec.called_from_ui = 'N' then
397: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
398: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
399: p_entity_id => l_MODIFIER_LIST_rec.list_header_id,
393:
394: -- mkarya If process_modifiers has been called from public package, then ONLY call
395: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
396: if l_control_rec.called_from_ui = 'N' then
397: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
398: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
399: p_entity_id => l_MODIFIER_LIST_rec.list_header_id,
400: x_return_status => l_return_status );
401: end if;
450: or l_MODIFIERS_rec.modifier_level_code = 'LINEGROUP'
451: or (l_MODIFIERS_rec.rltd_modifier_grp_type = 'BENEFIT'
452: and l_MODIFIERS_rec.list_line_type_code = 'DIS'))) then
453:
454: qp_delayed_requests_pvt.log_request(
455: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
456: p_entity_id => l_MODIFIERS_rec.list_line_id,
457: p_requesting_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
458: p_requesting_entity_id => l_MODIFIERS_rec.list_line_id,
705: ( p_list_line_id => l_MODIFIERS_rec.list_line_id
706: );
707:
708: --- Code for delete ends here. Log delayed service request here.
709: qp_delayed_requests_PVT.log_request(
710: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
711: p_param1 => l_modifiers_rec.list_header_id,
712: p_entity_id => l_modifiers_rec.list_line_id,
713: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
768: , null
769: , null
770: );
771:
772: qp_delayed_requests_PVT.log_request(
773: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
774: p_entity_id => l_modifiers_rec.list_line_id,
775: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
776: p_requesting_entity_id => l_modifiers_rec.list_line_id,
880: , null
881: , null
882: );
883:
884: qp_delayed_requests_PVT.log_request(
885: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
886: p_entity_id => l_modifiers_rec.list_line_id,
887: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
888: p_requesting_entity_id => l_modifiers_rec.list_line_id,
893:
894: END IF; -- G_OPR_CREATE
895: --- Code for update an create ends here. Log delayed servuce request here.
896:
897: qp_delayed_requests_PVT.log_request(
898: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
899: p_entity_id => l_modifiers_rec.list_line_id,
900: p_param1 => l_modifiers_rec.list_header_id,
901: p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS,
925: l_MODIFIERS_tbl(I) := l_MODIFIERS_rec;
926: l_old_MODIFIERS_tbl(I) := l_old_MODIFIERS_rec;
927:
928: -- mkarya If process_modifiers has been called from public package, then ONLY call
929: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
930: if l_control_rec.called_from_ui = 'N' then
931: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
932: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
933: p_entity_id => l_MODIFIERS_rec.list_line_id,
927:
928: -- mkarya If process_modifiers has been called from public package, then ONLY call
929: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
930: if l_control_rec.called_from_ui = 'N' then
931: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
932: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
933: p_entity_id => l_MODIFIERS_rec.list_line_id,
934: x_return_status => l_return_status );
935:
932: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
933: p_entity_id => l_MODIFIERS_rec.list_line_id,
934: x_return_status => l_return_status );
935:
936: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
937: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
938: p_entity_id => l_MODIFIERS_rec.list_line_id,
939: x_return_status => l_return_status );
940:
937: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
938: p_entity_id => l_MODIFIERS_rec.list_line_id,
939: x_return_status => l_return_status );
940:
941: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
942: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
943: p_entity_id => l_MODIFIERS_rec.list_header_id,
944: x_return_status => l_return_status );
945:
942: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
943: p_entity_id => l_MODIFIERS_rec.list_header_id,
944: x_return_status => l_return_status );
945:
946: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
947: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
948: p_entity_id => l_MODIFIERS_rec.list_line_id,
949: x_return_status => l_return_status );
950: end if;
958: l_MODIFIERS_tbl(I) := l_MODIFIERS_rec;
959: l_old_MODIFIERS_tbl(I) := l_old_MODIFIERS_rec;
960:
961: -- mkarya If process_modifiers has been called from public package, then ONLY call
962: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
963: if l_control_rec.called_from_ui = 'N' then
964: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
965: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
966: p_entity_id => l_MODIFIERS_rec.list_line_id,
960:
961: -- mkarya If process_modifiers has been called from public package, then ONLY call
962: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
963: if l_control_rec.called_from_ui = 'N' then
964: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
965: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
966: p_entity_id => l_MODIFIERS_rec.list_line_id,
967: x_return_status => l_return_status );
968:
965: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
966: p_entity_id => l_MODIFIERS_rec.list_line_id,
967: x_return_status => l_return_status );
968:
969: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
970: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
971: p_entity_id => l_MODIFIERS_rec.list_line_id,
972: x_return_status => l_return_status );
973:
970: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
971: p_entity_id => l_MODIFIERS_rec.list_line_id,
972: x_return_status => l_return_status );
973:
974: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
975: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
976: p_entity_id => l_MODIFIERS_rec.list_header_id,
977: x_return_status => l_return_status );
978:
975: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
976: p_entity_id => l_MODIFIERS_rec.list_header_id,
977: x_return_status => l_return_status );
978:
979: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
980: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
981: p_entity_id => l_MODIFIERS_rec.list_line_id,
982: x_return_status => l_return_status );
983: end if;
998: );
999: END IF;
1000:
1001: -- mkarya If process_modifiers has been called from public package, then ONLY call
1002: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1003: if l_control_rec.called_from_ui = 'N' then
1004: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1005: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1006: p_entity_id => l_MODIFIERS_rec.list_line_id,
1000:
1001: -- mkarya If process_modifiers has been called from public package, then ONLY call
1002: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1003: if l_control_rec.called_from_ui = 'N' then
1004: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1005: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1006: p_entity_id => l_MODIFIERS_rec.list_line_id,
1007: x_return_status => l_return_status );
1008:
1005: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1006: p_entity_id => l_MODIFIERS_rec.list_line_id,
1007: x_return_status => l_return_status );
1008:
1009: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1010: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1011: p_entity_id => l_MODIFIERS_rec.list_line_id,
1012: x_return_status => l_return_status );
1013:
1010: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1011: p_entity_id => l_MODIFIERS_rec.list_line_id,
1012: x_return_status => l_return_status );
1013:
1014: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1015: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1016: p_entity_id => l_MODIFIERS_rec.list_header_id,
1017: x_return_status => l_return_status );
1018:
1015: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1016: p_entity_id => l_MODIFIERS_rec.list_header_id,
1017: x_return_status => l_return_status );
1018:
1019: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1020: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
1021: p_entity_id => l_MODIFIERS_rec.list_line_id,
1022: x_return_status => l_return_status );
1023: end if;
1321: l_QUALIFIERS_tbl(I) := l_QUALIFIERS_rec;
1322: l_old_QUALIFIERS_tbl(I) := l_old_QUALIFIERS_rec;
1323:
1324: -- mkarya If process_modifiers has been called from public package, then ONLY call
1325: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1326: if l_control_rec.called_from_ui = 'N' then
1327: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1328: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1329: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1323:
1324: -- mkarya If process_modifiers has been called from public package, then ONLY call
1325: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1326: if l_control_rec.called_from_ui = 'N' then
1327: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1328: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1329: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1330: x_return_status => l_return_status );
1331:
1328: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1329: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1330: x_return_status => l_return_status );
1331:
1332: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1333: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1334: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1335: x_return_status => l_return_status );
1336:
1333: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1334: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1335: x_return_status => l_return_status );
1336:
1337: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1338: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1339: p_entity_id => l_QUALIFIERS_rec.qualifier_id,
1340: x_return_status => l_return_status );
1341: end if;
1349: l_QUALIFIERS_tbl(I) := l_QUALIFIERS_rec;
1350: l_old_QUALIFIERS_tbl(I) := l_old_QUALIFIERS_rec;
1351:
1352: -- mkarya If process_modifiers has been called from public package, then ONLY call
1353: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1354: if l_control_rec.called_from_ui = 'N' then
1355: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1356: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1357: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1351:
1352: -- mkarya If process_modifiers has been called from public package, then ONLY call
1353: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1354: if l_control_rec.called_from_ui = 'N' then
1355: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1356: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1357: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1358: x_return_status => l_return_status );
1359:
1356: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1357: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1358: x_return_status => l_return_status );
1359:
1360: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1361: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1362: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1363: x_return_status => l_return_status );
1364:
1361: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1362: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1363: x_return_status => l_return_status );
1364:
1365: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1366: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1367: p_entity_id => l_QUALIFIERS_rec.qualifier_id,
1368: x_return_status => l_return_status );
1369: end if;
1384: );
1385: END IF;
1386:
1387: -- mkarya If process_modifiers has been called from public package, then ONLY call
1388: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1389: if l_control_rec.called_from_ui = 'N' then
1390: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1391: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1392: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1386:
1387: -- mkarya If process_modifiers has been called from public package, then ONLY call
1388: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1389: if l_control_rec.called_from_ui = 'N' then
1390: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1391: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1392: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1393: x_return_status => l_return_status );
1394:
1391: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1392: p_entity_id => l_QUALIFIERS_rec.list_header_id,
1393: x_return_status => l_return_status );
1394:
1395: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1396: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1397: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1398: x_return_status => l_return_status );
1399:
1396: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1397: p_entity_id => l_QUALIFIERS_rec.list_line_id,
1398: x_return_status => l_return_status );
1399:
1400: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1401: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1402: p_entity_id => l_QUALIFIERS_rec.qualifier_id,
1403: x_return_status => l_return_status );
1404: end if;
1589: WHEN OTHERS THEN
1590: l_continuous_price_break_flag := NULL;
1591: END;
1592:
1593: qp_delayed_requests_PVT.log_request
1594: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
1595: , p_entity_id => l_PRICING_ATTR_REC.list_line_id
1596: , p_param1 =>l_parent_list_line_id
1597: , p_param2 => l_continuous_price_break_flag
1767: IF l_status = 'T' THEN
1768:
1769: oe_debug_pub.add('calling log request for ob from private ');
1770: oe_debug_pub.add('list_line_id is '||l_parent_list_line_id);
1771: qp_delayed_requests_PVT.log_request
1772: ( p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
1773: , p_entity_id => l_parent_list_line_id
1774: , p_param1 =>l_list_line_type_code
1775: , p_requesting_entity_code=> QP_GLOBALS.G_ENTITY_MODIFIERS
1836:
1837: oe_debug_pub.add('manoj - value of called_from_ui before delete_reqs_for_deleted_entity = ' || l_control_rec.called_from_ui);
1838: --dbms_output.put_line('manoj - pricing_attr- value of called_from_ui before delete_reqs_for_deleted_entity = ' || l_control_rec.called_from_ui);
1839: -- mkarya If process_modifiers has been called from public package, then ONLY call
1840: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1841: if l_control_rec.called_from_ui = 'N' then
1842: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1843: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1844: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1838: --dbms_output.put_line('manoj - pricing_attr- value of called_from_ui before delete_reqs_for_deleted_entity = ' || l_control_rec.called_from_ui);
1839: -- mkarya If process_modifiers has been called from public package, then ONLY call
1840: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1841: if l_control_rec.called_from_ui = 'N' then
1842: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1843: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1844: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1845: x_return_status => l_return_status );
1846:
1843: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1844: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1845: x_return_status => l_return_status );
1846:
1847: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1848: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1849: p_entity_id => l_parent_list_line_id,
1850: x_return_status => l_return_status );
1851:
1848: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1849: p_entity_id => l_parent_list_line_id,
1850: x_return_status => l_return_status );
1851:
1852: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1853: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1854: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1855: x_return_status => l_return_status );
1856:
1853: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1854: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1855: x_return_status => l_return_status );
1856:
1857: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1858: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1859: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1860: x_return_status => l_return_status );
1861: end if;
1869: l_PRICING_ATTR_tbl(I) := l_PRICING_ATTR_rec;
1870: l_old_PRICING_ATTR_tbl(I) := l_old_PRICING_ATTR_rec;
1871:
1872: -- mkarya If process_modifiers has been called from public package, then ONLY call
1873: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1874: if l_control_rec.called_from_ui = 'N' then
1875: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1876: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1877: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1871:
1872: -- mkarya If process_modifiers has been called from public package, then ONLY call
1873: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1874: if l_control_rec.called_from_ui = 'N' then
1875: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1876: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1877: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1878: x_return_status => l_return_status );
1879:
1876: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1877: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1878: x_return_status => l_return_status );
1879:
1880: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1881: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1882: p_entity_id => l_parent_list_line_id,
1883: x_return_status => l_return_status );
1884:
1881: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1882: p_entity_id => l_parent_list_line_id,
1883: x_return_status => l_return_status );
1884:
1885: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1886: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1887: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1888: x_return_status => l_return_status );
1889:
1886: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1887: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1888: x_return_status => l_return_status );
1889:
1890: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1891: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1892: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1893: x_return_status => l_return_status );
1894: end if;
1909: );
1910: END IF;
1911:
1912: -- mkarya If process_modifiers has been called from public package, then ONLY call
1913: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1914: if l_control_rec.called_from_ui = 'N' then
1915: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1916: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1917: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1911:
1912: -- mkarya If process_modifiers has been called from public package, then ONLY call
1913: -- qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1914: if l_control_rec.called_from_ui = 'N' then
1915: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1916: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1917: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1918: x_return_status => l_return_status );
1919:
1916: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR,
1917: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1918: x_return_status => l_return_status );
1919:
1920: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1921: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1922: p_entity_id => l_parent_list_line_id,
1923: x_return_status => l_return_status );
1924:
1921: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1922: p_entity_id => l_parent_list_line_id,
1923: x_return_status => l_return_status );
1924:
1925: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1926: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1927: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1928: x_return_status => l_return_status );
1929:
1926: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS,
1927: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1928: x_return_status => l_return_status );
1929:
1930: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1931: (p_entity_code => QP_GLOBALS.G_ENTITY_ALL,
1932: p_entity_id => l_PRICING_ATTR_rec.list_line_id,
1933: x_return_status => l_return_status );
1934: end if;
2139: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_MODIFIER_LIST)
2140: THEN
2141:
2142: -- FOR QUALIFICATION_IND
2143: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2144: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST
2145: ,p_delete => FND_API.G_TRUE
2146: ,x_return_status => l_return_status
2147: );
2200: oe_debug_pub.add('here1');
2201: --NULL;
2202:
2203: -- FOR QUALIFICATION_IND
2204: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2205: (p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
2206: ,p_delete => FND_API.G_TRUE
2207: ,x_return_status => l_return_status
2208: );
2255: THEN
2256:
2257: oe_debug_pub.add('here5');
2258: -- FOR CHECK_SEGMENT_LEVEL_IN_GROUP
2259: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2260: (p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS
2261: ,p_delete => FND_API.G_TRUE
2262: ,x_return_status => l_return_status
2263: );
2333: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_PRICING_ATTR)
2334: THEN
2335:
2336:
2337: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2338: (p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
2339: ,p_delete => FND_API.G_TRUE
2340: ,x_return_status => l_return_status
2341: );
2355: IF p_control_rec.process AND
2356: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL
2357: THEN
2358: -- FOR QUALIFICATION_IND
2359: QP_DELAYED_REQUESTS_PVT.Process_Delayed_Requests
2360: (
2361: x_return_status => l_return_status
2362: );
2363: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2366: RAISE FND_API.G_EXC_ERROR;
2367: END IF;
2368: /*
2369: oe_debug_pub.add('calling process_request');
2370: QP_delayed_requests_pvt.process_request_for_entity(p_entity_code =>QP_GLOBALS.G_ENTITY_MODIFIER_LIST,
2371: x_return_status=>l_return_status);
2372:
2373: oe_debug_pub.add('return status after calling process_request' || l_return_status);
2374:
2398: p_control_rec.process_entity = QP_GLOBALS.G_ENTITY_ALL
2399: THEN
2400: oe_debug_pub.add('Before processing delayed request for duplicate modifiers');
2401: -- FOR Duplicate Modifier Lines
2402: QP_DELAYED_REQUESTS_PVT.Process_Delayed_Requests
2403: (
2404: x_return_status => l_return_status
2405: );
2406:
2548: oe_debug_pub.add('manoj - value of called_from_ui before clear_request = ' || p_control_rec.called_from_ui);
2549: --dbms_output.put_line('manoj - value of called_from_ui before clear_request = ' || p_control_rec.called_from_ui);
2550: -- mkarya If process_modifiers has been called from public package, then ONLY call clear_request
2551: if p_control_rec.called_from_ui = 'N' then
2552: qp_delayed_requests_pvt.Clear_Request
2553: (x_return_status => l_return_status);
2554: end if;
2555:
2556: -- Get message count and data
2565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2566:
2567: -- mkarya If process_modifiers has been called from public package, then ONLY call clear_request
2568: if p_control_rec.called_from_ui = 'N' then
2569: qp_delayed_requests_pvt.Clear_Request
2570: (x_return_status => l_return_status);
2571: end if;
2572:
2573: -- Get message count and data
2592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2593:
2594: -- mkarya If process_modifiers has been called from public package, then ONLY call clear_request
2595: if p_control_rec.called_from_ui = 'N' then
2596: qp_delayed_requests_pvt.Clear_Request
2597: (x_return_status => l_return_status);
2598: end if;
2599:
2600: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)