[Home] [Help]
87: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
88: END IF;
89:
90: FORALL i IN 1 .. p_id_tbl.COUNT
91: INSERT INTO po_validation_results_gt
92: (result_set_id,
93: result_type,
94: entity_type,
95: entity_id,
254: -- Bug 14017950 - Enabling OSP line type for GBPA - PDOI will now import OSP lines for GBPA.
255: -- Bug 14017950 - Enabling OSP line type for GBPA - for CLM , OSP line type import is not enabled.
256: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y' THEN
257: FORALL i IN 1 .. p_id_tbl.COUNT
258: INSERT INTO po_validation_results_gt
259: (result_set_id,
260: result_type,
261: entity_type,
262: entity_id,
533: --check that job_id is valid within the relevant business group.
534: IF NVL(hr_general.get_xbg_profile, 'N') = 'N' THEN
535: -- xbg profile is N or job business_group_id is null
536: FORALL i IN 1 .. p_id_tbl.COUNT
537: INSERT INTO po_validation_results_gt
538: (result_set_id,
539: result_type,
540: entity_type,
541: entity_id,
578: END IF;
579: ELSE
580: -- Cross Business group profile is 'Y'
581: FORALL i IN 1 .. p_id_tbl.COUNT
582: INSERT INTO po_validation_results_gt
583: (result_set_id,
584: result_type,
585: entity_type,
586: entity_id,
627: END IF;
628:
629: -- job must be valid for the specified category
630: FORALL i IN 1 .. p_id_tbl.COUNT
631: INSERT INTO po_validation_results_gt
632: (result_set_id,
633: result_type,
634: entity_type,
635: entity_id,
707:
708: IF NVL(hr_general.get_xbg_profile, 'N') = 'N' THEN
709: -- xbg profile is N but job_business_group_id not in FSP
710: FORALL i IN 1 .. p_id_tbl.COUNT
711: INSERT INTO po_validation_results_gt
712: (result_set_id,
713: result_type,
714: entity_type,
715: entity_id,
737: END IF;
738: ELSE
739: -- Cross Business group profile is 'Y', need to validate job business group id
740: FORALL i IN 1 .. p_id_tbl.COUNT
741: INSERT INTO po_validation_results_gt
742: (result_set_id,
743: result_type,
744: entity_type,
745: entity_id,
877: END IF;
878: END LOOP;
879:
880: FORALL i IN 1 .. p_id_tbl.COUNT
881: INSERT INTO po_validation_results_gt
882: (result_set_id,
883: result_type,
884: entity_type,
885: entity_id,
968: END IF;
969: END LOOP;
970:
971: FORALL i IN 1 .. p_id_tbl.COUNT
972: INSERT INTO po_validation_results_gt
973: (result_set_id,
974: result_type,
975: entity_type,
976: entity_id,
1078:
1079: -- If order_type_lookup_code is Quantity and outside_operation flag is 'Y'
1080: -- , then the item_id cannot be null
1081: FORALL i IN 1 .. p_id_tbl.COUNT
1082: INSERT INTO po_validation_results_gt
1083: (result_set_id,
1084: result_type,
1085: entity_type,
1086: entity_id,
1111: END IF;
1112:
1113: -- if item id is not null, it has to exist in mtl_system_items table
1114: FORALL i IN 1 .. p_id_tbl.COUNT
1115: INSERT INTO po_validation_results_gt
1116: (result_set_id,
1117: result_type,
1118: entity_type,
1119: entity_id,
1203:
1204: /* Bug 5366732 Modified the inner query to select item description from mtl_system_items_tl instead of from mtl_system_items */
1205: x_result_type := po_validations.c_result_type_success;
1206: FORALL i IN 1 .. p_id_tbl.COUNT
1207: INSERT INTO po_validation_results_gt
1208: (result_set_id,
1209: result_type,
1210: entity_type,
1211: entity_id,
1326: END IF;
1327: END LOOP;
1328:
1329: FORALL i IN 1 .. p_id_tbl.COUNT
1330: INSERT INTO po_validation_results_gt
1331: (result_set_id,
1332: result_type,
1333: entity_type,
1334: entity_id,
1372: END IF;
1373:
1374: -- check to see if x_uom_code is valid in po_units_of_measure_val_v
1375: FORALL i IN 1 .. p_id_tbl.COUNT
1376: INSERT INTO po_validation_results_gt
1377: (result_set_id,
1378: result_type,
1379: entity_type,
1380: entity_id,
1407: END IF;
1408:
1409: -- validation for AMOUNT based line type
1410: FORALL i IN 1 .. p_id_tbl.COUNT
1411: INSERT INTO po_validation_results_gt
1412: (result_set_id,
1413: result_type,
1414: entity_type,
1415: entity_id,
1448:
1449: -- validation for 'RATE' based line
1450: l_service_uom_class := NVL(FND_PROFILE.value('PO_RATE_UOM_CLASS'), '999');
1451: FORALL i IN 1 .. p_id_tbl.COUNT
1452: INSERT INTO po_validation_results_gt
1453: (result_set_id,
1454: result_type,
1455: entity_type,
1456: entity_id,
1549:
1550: -- check to see if there are x_item_revision exists in mtl_item_revisions
1551: -- table
1552: FORALL i IN 1 .. p_id_tbl.COUNT
1553: INSERT INTO po_validation_results_gt
1554: (result_set_id,
1555: result_type,
1556: entity_type,
1557: entity_id,
1661: WHERE functional_area_id = 2); /*** purchasing***/
1662:
1663: -- Validate if X_category_id belong to the X_item
1664: FORALL i IN 1 .. p_id_tbl.COUNT
1665: INSERT INTO po_validation_results_gt
1666: (result_set_id,
1667: result_type,
1668: entity_type,
1669: entity_id,
1711: END IF;
1712:
1713: IF x_flag = 'Y' THEN
1714: FORALL i IN 1 .. p_id_tbl.COUNT
1715: INSERT INTO po_validation_results_gt
1716: (result_set_id,
1717: result_type,
1718: entity_type,
1719: entity_id,
1752: x_result_type := po_validations.c_result_type_failure;
1753: END IF;
1754: ELSE
1755: FORALL i IN 1 .. p_id_tbl.COUNT
1756: INSERT INTO po_validation_results_gt
1757: (result_set_id,
1758: result_type,
1759: entity_type,
1760: entity_id,
1850: x_result_type => x_result_type);
1851:
1852: -- Validate if x_category_id is valid if not empty
1853: FORALL i IN 1 .. p_id_tbl.COUNT
1854: INSERT INTO po_validation_results_gt
1855: (result_set_id,
1856: result_type,
1857: entity_type,
1858: entity_id,
1979: INTO X_li_unit_price
1980: FROM po_line_types_b plt
1981: WHERE p_line_type_id_tbl(i) = plt.line_type_id;
1982:
1983: INSERT INTO po_validation_results_gt
1984: (result_set_id,
1985: result_type,
1986: entity_type,
1987: entity_id,
2018: x_result_type := po_validations.c_result_type_failure;
2019: END IF;
2020:
2021: ELSE
2022: INSERT INTO po_validation_results_gt
2023: (result_set_id,
2024: result_type,
2025: entity_type,
2026: entity_id,
2328: -- Log error if there's line number duplicate in draft table as well
2329:
2330: -- check for uniqueness
2331: FORALL i IN 1 .. p_id_tbl.COUNT
2332: INSERT INTO po_validation_results_gt
2333: (result_set_id,
2334: result_type,
2335: entity_type,
2336: entity_id,
2411: END IF;
2412:
2413: x_result_type := po_validations.c_result_type_success;
2414: FORALL i IN 1 .. p_id_tbl.COUNT
2415: INSERT INTO po_validation_results_gt
2416: (result_set_id,
2417: result_type,
2418: entity_type,
2419: entity_id,
2486: END IF;
2487:
2488: x_result_type := po_validations.c_result_type_success;
2489: FORALL i IN 1 .. p_id_tbl.COUNT
2490: INSERT INTO po_validation_results_gt
2491: (result_set_id,
2492: result_type,
2493: entity_type,
2494: entity_id,
2564: x_result_type := po_validations.c_result_type_success;
2565:
2566: -- validate line_type_id is valid for the given style
2567: FORALL i IN 1 .. p_id_tbl.COUNT
2568: INSERT INTO po_validation_results_gt
2569: (result_set_id,
2570: result_type,
2571: entity_type,
2572: entity_id,
2606: END IF;
2607:
2608: -- validate the purchase_basis is valid for the given style
2609: FORALL i IN 1 .. p_id_tbl.COUNT
2610: INSERT INTO po_validation_results_gt
2611: (result_set_id,
2612: result_type,
2613: entity_type,
2614: entity_id,
2681: END IF;
2682:
2683: x_result_type := po_validations.c_result_type_success;
2684: FORALL i IN 1 .. p_id_tbl.COUNT
2685: INSERT INTO po_validation_results_gt
2686: (result_set_id,
2687: result_type,
2688: entity_type,
2689: entity_id,
2842: END IF;
2843:
2844: x_result_type := po_validations.c_result_type_success;
2845: FORALL i IN 1 .. p_id_tbl.COUNT
2846: INSERT INTO po_validation_results_gt
2847: (result_set_id,
2848: result_type,
2849: entity_type,
2850: entity_id,
3046: -- If price break lookup code is provided, it has to be a valid lookup
3047: -- code
3048: x_result_type := po_validations.c_result_type_success;
3049: FORALL i IN 1 .. p_id_tbl.COUNT
3050: INSERT INTO po_validation_results_gt
3051: (result_set_id,
3052: result_type,
3053: entity_type,
3054: entity_id,
3233: END LOOP;
3234:
3235: -- Validate if x_category_id is valid if not empty
3236: FORALL i IN 1 .. p_id_tbl.COUNT
3237: INSERT INTO po_validation_results_gt
3238: (result_set_id,
3239: result_type,
3240: entity_type,
3241: entity_id,
3327: --- Bug#13936604: Changing line UOM on BPA using the upload program, the error occurs
3328: --- that specified value is inactive or invalid even when the UOM passed is valid.
3329:
3330: FORALL i IN 1 .. p_id_tbl.COUNT
3331: INSERT INTO po_validation_results_gt
3332: (result_set_id,
3333: result_type,
3334: entity_type,
3335: entity_id,
3437: /* Bug 5366732 Modified the inner query to select item description from mtl_system_items_tl instead of from mtl_system_items */
3438:
3439:
3440: FORALL i IN 1 .. p_id_tbl.COUNT
3441: INSERT INTO po_validation_results_gt
3442: (result_set_id,
3443: result_type,
3444: entity_type,
3445: entity_id,
3666: END IF;
3667: END LOOP;
3668:
3669: FORALL i IN 1 .. p_id_tbl.COUNT
3670: INSERT INTO po_validation_results_gt
3671: (result_set_id,
3672: result_type,
3673: entity_type,
3674: entity_id,
3786:
3787: -- bug5258790
3788: -- For fixed price line update, unit price has to be NULL
3789: FORALL i IN 1..p_id_tbl.COUNT
3790: INSERT INTO po_validation_results_gt
3791: (result_set_id,
3792: result_type,
3793: entity_type,
3794: entity_id,
3830:
3831: -- bug5008026
3832: -- Make sure that the new price does not exceed price limit
3833: FORALL i IN 1 .. p_id_tbl.COUNT
3834: INSERT INTO po_validation_results_gt
3835: (result_set_id,
3836: result_type,
3837: entity_type,
3838: entity_id,
3866:
3867: -- Enhanced Pricing Start
3868: -- For line with price adjustments, the unit_price should not changed
3869: FORALL i IN 1..p_id_tbl.COUNT
3870: INSERT INTO po_validation_results_gt
3871: (result_set_id,
3872: result_type,
3873: entity_type,
3874: entity_id,
3943:
3944: -- bug5258790
3945: -- For fixed price line update, unit price has to be NULL
3946: FORALL i IN 1..p_id_tbl.COUNT
3947: INSERT INTO po_validation_results_gt
3948: (result_set_id,
3949: result_type,
3950: entity_type,
3951: entity_id,