56: l_api_name CONSTANT VARCHAR2(30) := 'validate_org_ids';
57: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
58: l_progress VARCHAR2(3) := '000';
59:
60: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
61: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
62:
63: l_err_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
64: l_err_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
57: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
58: l_progress VARCHAR2(3) := '000';
59:
60: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
61: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
62:
63: l_err_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
64: l_err_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
65: i NUMBER;
59:
60: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
61: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
62:
63: l_err_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
64: l_err_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
65: i NUMBER;
66:
67: l_ou_name HR_ALL_ORGANIZATION_UNITS_TL.name%TYPE;
60: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
61: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
62:
63: l_err_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
64: l_err_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
65: i NUMBER;
66:
67: l_ou_name HR_ALL_ORGANIZATION_UNITS_TL.name%TYPE;
68:
466: l_progress VARCHAR2(3) := '000';
467:
468: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
469:
470: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
471: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
472: l_err_currency_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
473:
474: l_index NUMBER;
467:
468: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
469:
470: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
471: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
472: l_err_currency_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
473:
474: l_index NUMBER;
475: i NUMBER;
468: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
469:
470: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
471: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
472: l_err_currency_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
473:
474: l_index NUMBER;
475: i NUMBER;
476: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
472: l_err_currency_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
473:
474: l_index NUMBER;
475: i NUMBER;
476: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
477: BEGIN
478: l_progress := '010';
479: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
480:
619: l_progress VARCHAR2(3) := '000';
620:
621: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
622:
623: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
624: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
625: l_vendor_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
626: l_vendor_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
627: l_vendor_site_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
620:
621: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
622:
623: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
624: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
625: l_vendor_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
626: l_vendor_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
627: l_vendor_site_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
628: l_vendor_site_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
621: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
622:
623: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
624: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
625: l_vendor_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
626: l_vendor_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
627: l_vendor_site_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
628: l_vendor_site_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
629: l_vendor_contact_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
622:
623: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
624: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
625: l_vendor_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
626: l_vendor_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
627: l_vendor_site_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
628: l_vendor_site_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
629: l_vendor_contact_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
630:
623: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
624: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
625: l_vendor_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
626: l_vendor_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
627: l_vendor_site_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
628: l_vendor_site_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
629: l_vendor_contact_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
630:
631: l_return_status VARCHAR2(1);
624: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
625: l_vendor_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
626: l_vendor_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
627: l_vendor_site_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
628: l_vendor_site_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
629: l_vendor_contact_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
630:
631: l_return_status VARCHAR2(1);
632: l_msg_count NUMBER;
625: l_vendor_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
626: l_vendor_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
627: l_vendor_site_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
628: l_vendor_site_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR15;
629: l_vendor_contact_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
630:
631: l_return_status VARCHAR2(1);
632: l_msg_count NUMBER;
633: l_msg_data VARCHAR2(2000);
633: l_msg_data VARCHAR2(2000);
634: l_ccr_status VARCHAR2(1);
635: l_error_code NUMBER;
636:
637: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
638: l_index NUMBER;
639: i NUMBER;
640:
641: -- If the profile option 'Enable Transaction Code' is set to 'Yes',
1164: l_progress VARCHAR2(3) := '000';
1165:
1166: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1167:
1168: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1169: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1170: l_err_ship_to_loc_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1171:
1172: l_index NUMBER;
1165:
1166: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1167:
1168: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1169: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1170: l_err_ship_to_loc_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1171:
1172: l_index NUMBER;
1173: i NUMBER;
1166: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1167:
1168: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1169: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1170: l_err_ship_to_loc_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1171:
1172: l_index NUMBER;
1173: i NUMBER;
1174: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1170: l_err_ship_to_loc_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1171:
1172: l_index NUMBER;
1173: i NUMBER;
1174: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1175:
1176: l_location_name HR_LOCATIONS_ALL_TL.location_code%TYPE;
1177: BEGIN
1178: l_progress := '010';
1362: l_progress VARCHAR2(3) := '000';
1363:
1364: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1365:
1366: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1367: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1368: l_err_bill_to_loc_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1369:
1370: l_index NUMBER;
1363:
1364: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1365:
1366: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1367: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1368: l_err_bill_to_loc_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1369:
1370: l_index NUMBER;
1371: i NUMBER;
1364: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1365:
1366: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1367: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1368: l_err_bill_to_loc_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1369:
1370: l_index NUMBER;
1371: i NUMBER;
1372: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1368: l_err_bill_to_loc_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1369:
1370: l_index NUMBER;
1371: i NUMBER;
1372: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1373:
1374: l_location_name HR_LOCATIONS_ALL_TL.location_code%TYPE;
1375: BEGIN
1376: l_progress := '010';
1627: l_progress VARCHAR2(3) := '000';
1628:
1629: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1630:
1631: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1632: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1633: l_err_fob_lookup_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1634:
1635: l_index NUMBER;
1628:
1629: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1630:
1631: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1632: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1633: l_err_fob_lookup_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1634:
1635: l_index NUMBER;
1636: i NUMBER;
1629: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1630:
1631: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1632: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1633: l_err_fob_lookup_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1634:
1635: l_index NUMBER;
1636: i NUMBER;
1637: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1633: l_err_fob_lookup_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1634:
1635: l_index NUMBER;
1636: i NUMBER;
1637: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1638:
1639: l_lookup_meaning PO_LOOKUP_CODES.displayed_field%TYPE;
1640: BEGIN
1641: l_progress := '010';
1762: l_progress VARCHAR2(3) := '000';
1763:
1764: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1765:
1766: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1767: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1768: l_err_ship_via_luc_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1769:
1770: l_index NUMBER;
1763:
1764: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1765:
1766: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1767: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1768: l_err_ship_via_luc_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1769:
1770: l_index NUMBER;
1771: i NUMBER;
1764: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1765:
1766: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1767: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1768: l_err_ship_via_luc_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1769:
1770: l_index NUMBER;
1771: i NUMBER;
1772: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1768: l_err_ship_via_luc_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1769:
1770: l_index NUMBER;
1771: i NUMBER;
1772: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1773: BEGIN
1774: l_progress := '010';
1775: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1776: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Validating a defaulted field -- SHIP_VIA_LOOKUP_CODE (freight_carrier)'); END IF;
1886: l_progress VARCHAR2(3) := '000';
1887:
1888: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1889:
1890: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1891: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1892: l_err_freight_terms_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1893:
1894: l_index NUMBER;
1887:
1888: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1889:
1890: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1891: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1892: l_err_freight_terms_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1893:
1894: l_index NUMBER;
1895: i NUMBER;
1888: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
1889:
1890: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1891: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1892: l_err_freight_terms_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1893:
1894: l_index NUMBER;
1895: i NUMBER;
1896: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1892: l_err_freight_terms_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
1893:
1894: l_index NUMBER;
1895: i NUMBER;
1896: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1897:
1898: l_lookup_meaning PO_LOOKUP_CODES.displayed_field%TYPE;
1899: BEGIN
1900: l_progress := '010';
2087: l_progress VARCHAR2(3) := '000';
2088:
2089: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
2090:
2091: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2092: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2093: l_err_terms_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2094:
2095: l_index NUMBER;
2088:
2089: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
2090:
2091: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2092: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2093: l_err_terms_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2094:
2095: l_index NUMBER;
2096: i NUMBER;
2089: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
2090:
2091: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2092: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2093: l_err_terms_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2094:
2095: l_index NUMBER;
2096: i NUMBER;
2097: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2093: l_err_terms_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2094:
2095: l_index NUMBER;
2096: i NUMBER;
2097: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2098:
2099: l_terms_name AP_TERMS_TL.name%TYPE;
2100: BEGIN
2101: l_progress := '010';
2223: l_progress VARCHAR2(3) := '000';
2224:
2225: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
2226:
2227: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2228: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2229: l_err_shipping_control_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
2230:
2231: l_index NUMBER;
2224:
2225: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
2226:
2227: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2228: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2229: l_err_shipping_control_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
2230:
2231: l_index NUMBER;
2232: i NUMBER;
2225: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
2226:
2227: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2228: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2229: l_err_shipping_control_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
2230:
2231: l_index NUMBER;
2232: i NUMBER;
2233: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2229: l_err_shipping_control_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
2230:
2231: l_index NUMBER;
2232: i NUMBER;
2233: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2234:
2235: l_lookup_meaning PO_LOOKUP_CODES.displayed_field%TYPE;
2236: BEGIN
2237: l_progress := '010';
2359: l_progress VARCHAR2(3) := '000';
2360:
2361: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
2362:
2363: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2364: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2365: l_err_rate_type_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
2366:
2367: l_index NUMBER;
2360:
2361: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
2362:
2363: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2364: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2365: l_err_rate_type_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
2366:
2367: l_index NUMBER;
2368: i NUMBER;
2361: l_size NUMBER := p_headers_rec.interface_header_id.COUNT;
2362:
2363: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2364: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2365: l_err_rate_type_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
2366:
2367: l_index NUMBER;
2368: i NUMBER;
2369: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2365: l_err_rate_type_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR30;
2366:
2367: l_index NUMBER;
2368: i NUMBER;
2369: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2370: BEGIN
2371: l_progress := '010';
2372: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2373:
2664: l_progress VARCHAR2(3) := '000';
2665:
2666: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2667:
2668: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2669: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2670: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2671: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2672:
2665:
2666: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2667:
2668: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2669: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2670: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2671: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2672:
2673: l_index NUMBER;
2666: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2667:
2668: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2669: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2670: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2671: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2672:
2673: l_index NUMBER;
2674: i NUMBER;
2667:
2668: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2669: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2670: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2671: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2672:
2673: l_index NUMBER;
2674: i NUMBER;
2675: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2671: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2672:
2673: l_index NUMBER;
2674: i NUMBER;
2675: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2676: BEGIN
2677: l_progress := '010';
2678: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2679:
2802: l_progress VARCHAR2(3) := '000';
2803:
2804: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2805:
2806: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2807: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2808: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2809: l_item_description_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
2810:
2803:
2804: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2805:
2806: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2807: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2808: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2809: l_item_description_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
2810:
2811: l_index NUMBER;
2804: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2805:
2806: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2807: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2808: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2809: l_item_description_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
2810:
2811: l_index NUMBER;
2812: i NUMBER;
2805:
2806: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2807: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2808: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2809: l_item_description_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
2810:
2811: l_index NUMBER;
2812: i NUMBER;
2813: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2809: l_item_description_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR240;
2810:
2811: l_index NUMBER;
2812: i NUMBER;
2813: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2814: BEGIN
2815: l_progress := '010';
2816: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2817:
2929: l_progress VARCHAR2(3) := '000';
2930:
2931: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2932:
2933: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2934: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2935: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2936: l_unit_of_measure_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
2937: l_uom_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
2930:
2931: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2932:
2933: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2934: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2935: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2936: l_unit_of_measure_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
2937: l_uom_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
2938:
2931: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
2932:
2933: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2934: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2935: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2936: l_unit_of_measure_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
2937: l_uom_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
2938:
2939: l_index NUMBER;
2932:
2933: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2934: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2935: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2936: l_unit_of_measure_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
2937: l_uom_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
2938:
2939: l_index NUMBER;
2940: i NUMBER;
2933: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2934: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2935: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2936: l_unit_of_measure_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR25;
2937: l_uom_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
2938:
2939: l_index NUMBER;
2940: i NUMBER;
2941: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2937: l_uom_code_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
2938:
2939: l_index NUMBER;
2940: i NUMBER;
2941: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2942: BEGIN
2943: l_progress := '010';
2944: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
2945:
3188: l_progress VARCHAR2(3) := '000';
3189:
3190: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
3191:
3192: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3193: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3194: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3195: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3196: l_item_revision_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
3189:
3190: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
3191:
3192: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3193: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3194: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3195: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3196: l_item_revision_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
3197:
3190: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
3191:
3192: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3193: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3194: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3195: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3196: l_item_revision_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
3197:
3198: l_index NUMBER;
3191:
3192: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3193: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3194: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3195: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3196: l_item_revision_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
3197:
3198: l_index NUMBER;
3199: i NUMBER;
3192: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3193: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3194: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3195: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3196: l_item_revision_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
3197:
3198: l_index NUMBER;
3199: i NUMBER;
3200: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3196: l_item_revision_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR3;
3197:
3198: l_index NUMBER;
3199: i NUMBER;
3200: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3201: BEGIN
3202: l_progress := '010';
3203: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
3204:
3510: l_progress VARCHAR2(3) := '000';
3511:
3512: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
3513:
3514: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3515: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3516: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3517: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3518: l_category_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3511:
3512: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
3513:
3514: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3515: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3516: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3517: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3518: l_category_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3519: l_category_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR2000;
3512: l_size NUMBER := p_lines_rec.interface_line_id.COUNT;
3513:
3514: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3515: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3516: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3517: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3518: l_category_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3519: l_category_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR2000;
3520:
3513:
3514: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3515: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3516: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3517: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3518: l_category_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3519: l_category_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR2000;
3520:
3521: l_index NUMBER;
3514: l_interface_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3515: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3516: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3517: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3518: l_category_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3519: l_category_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR2000;
3520:
3521: l_index NUMBER;
3522: i NUMBER;
3515: l_interface_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3516: l_indexes PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3517: l_item_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3518: l_category_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3519: l_category_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR2000;
3520:
3521: l_index NUMBER;
3522: i NUMBER;
3523: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3519: l_category_name_list PO_R12_CAT_UPG_TYPES.PO_TBL_VARCHAR2000;
3520:
3521: l_index NUMBER;
3522: i NUMBER;
3523: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3524:
3525: l_validate_flag MTL_CATEGORY_SETS_V.validate_flag%TYPE;
3526: l_category_set_id MTL_CATEGORY_SETS_V.category_set_id%TYPE;
3527:
4132: l_api_name CONSTANT VARCHAR2(30) := 'validate_create_action';
4133: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
4134: l_progress VARCHAR2(3) := '000';
4135:
4136: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4137: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4138: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4139: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4140: BEGIN
4133: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
4134: l_progress VARCHAR2(3) := '000';
4135:
4136: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4137: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4138: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4139: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4140: BEGIN
4141: l_progress := '010';
4134: l_progress VARCHAR2(3) := '000';
4135:
4136: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4137: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4138: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4139: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4140: BEGIN
4141: l_progress := '010';
4142: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
4135:
4136: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4137: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4138: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4139: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4140: BEGIN
4141: l_progress := '010';
4142: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
4143:
4618: l_api_name CONSTANT VARCHAR2(30) := 'validate_add_action';
4619: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
4620: l_progress VARCHAR2(3) := '000';
4621:
4622: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4623: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4624: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4625: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4626: BEGIN
4619: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
4620: l_progress VARCHAR2(3) := '000';
4621:
4622: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4623: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4624: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4625: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4626: BEGIN
4627: l_progress := '010';
4620: l_progress VARCHAR2(3) := '000';
4621:
4622: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4623: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4624: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4625: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4626: BEGIN
4627: l_progress := '010';
4628: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
4621:
4622: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4623: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4624: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4625: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4626: BEGIN
4627: l_progress := '010';
4628: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
4629:
4849: l_api_name CONSTANT VARCHAR2(30) := 'validate_update_action';
4850: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
4851: l_progress VARCHAR2(3) := '000';
4852:
4853: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4854: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4855: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4856: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4857: BEGIN
4850: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
4851: l_progress VARCHAR2(3) := '000';
4852:
4853: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4854: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4855: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4856: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4857: BEGIN
4858: l_progress := '010';
4851: l_progress VARCHAR2(3) := '000';
4852:
4853: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4854: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4855: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4856: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4857: BEGIN
4858: l_progress := '010';
4859: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
4852:
4853: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4854: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4855: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4856: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
4857: BEGIN
4858: l_progress := '010';
4859: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
4860:
5185: l_api_name CONSTANT VARCHAR2(30) := 'validate_delete_action';
5186: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
5187: l_progress VARCHAR2(3) := '000';
5188:
5189: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5190: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5191: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5192: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5193:
5186: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
5187: l_progress VARCHAR2(3) := '000';
5188:
5189: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5190: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5191: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5192: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5193:
5194: l_base_language FND_LANGUAGES.language_code%TYPE;
5187: l_progress VARCHAR2(3) := '000';
5188:
5189: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5190: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5191: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5192: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5193:
5194: l_base_language FND_LANGUAGES.language_code%TYPE;
5195: BEGIN
5188:
5189: l_err_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5190: l_err_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5191: l_err_attr_values_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5192: l_err_attr_values_tlp_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
5193:
5194: l_base_language FND_LANGUAGES.language_code%TYPE;
5195: BEGIN
5196: l_progress := '010';