eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PO_VAL_CONSTANTS

Source


1 PACKAGE PO_VAL_CONSTANTS AS
2 /* $Header: PO_VAL_CONSTANTS.pls 120.3 2006/07/12 19:20:01 jinwang noship $ */
3 --------------------------------------------------------------------------
4 -- Header Validation ID Constants
5 --------------------------------------------------------------------------
6 -- Common
7 c_po_header_id_not_null CONSTANT NUMBER := 0;
8 c_po_header_id_unique CONSTANT NUMBER := 1;
9 c_end_date CONSTANT NUMBER := 2;
10 c_type_lookup_code_not_null CONSTANT NUMBER := 3;
11 c_type_lookup_code_valid CONSTANT NUMBER := 4;
12 c_revision_num CONSTANT NUMBER := 5;
13 c_document_num_unique CONSTANT NUMBER := 6;
14 c_document_num_not_null CONSTANT NUMBER := 7;
15 c_document_num_ge_zero CONSTANT NUMBER := 8;
16 c_document_num_valid CONSTANT NUMBER := 9;
17 c_currency_code_not_null CONSTANT NUMBER := 10;
18 c_currency_code_valid CONSTANT NUMBER := 11;
19 c_rate_null CONSTANT NUMBER := 12;
20 c_rate_type_null CONSTANT NUMBER := 13;
21 c_rate_date_null CONSTANT NUMBER := 14;
22 c_rate_not_null CONSTANT NUMBER := 15;
23 c_rate_ge_zero CONSTANT NUMBER := 16;
24 c_rate_type_not_null CONSTANT NUMBER := 17;
25 c_rate_valid CONSTANT NUMBER := 18;
26 c_rate_type_valid CONSTANT NUMBER := 19;
27 c_agent_id_not_null CONSTANT NUMBER := 20;
28 c_agent_id_valid CONSTANT NUMBER := 21;
29 c_vendor_not_null CONSTANT NUMBER := 22;
30 c_vendor_valid CONSTANT NUMBER := 23;
31 c_vendor_site_not_null CONSTANT NUMBER := 24;
32 c_vendor_site_valid CONSTANT NUMBER := 25;
33 c_vendor_contact_valid CONSTANT NUMBER := 26;
34 c_vendor_site_ccr_valid CONSTANT NUMBER := 27;
35 c_ship_to_location_id_not_null CONSTANT NUMBER := 28;
36 c_ship_to_location_id_valid CONSTANT NUMBER := 29;
37 c_bill_to_location_id_not_null CONSTANT NUMBER := 30;
38 c_bill_to_location_id_valid CONSTANT NUMBER := 31;
39 c_last_updated_by CONSTANT NUMBER := 32;
40 c_last_update_date CONSTANT NUMBER := 33;
41 c_release_num CONSTANT NUMBER := 34;
42 c_po_release_id CONSTANT NUMBER := 35;
43 c_release_date CONSTANT NUMBER := 36;
44 c_revised_date CONSTANT NUMBER := 37;
45 c_printed_date CONSTANT NUMBER := 38;
46 c_closed_date CONSTANT NUMBER := 39;
47 c_terms_id_header CONSTANT NUMBER := 40;
48 c_ship_via_lookup_code CONSTANT NUMBER := 41;
49 c_fob_lookup_code CONSTANT NUMBER := 42;
50 c_freight_terms_lookup_code CONSTANT NUMBER := 43;
51 c_shipping_control CONSTANT NUMBER := 44;
52 c_approval_status CONSTANT NUMBER := 45;
53 
54 -- Blanket
55 c_acceptance_required_flag CONSTANT NUMBER := 100;
56 c_confirming_order_flag CONSTANT NUMBER := 101;
57 c_acceptance_due_date CONSTANT NUMBER := 102;
58 c_amount_agreed CONSTANT NUMBER := 103;
59 c_firm_status_lookup_header CONSTANT NUMBER := 104;
60 c_cancel_flag CONSTANT NUMBER := 105;
61 c_closed_code CONSTANT NUMBER := 106;
62 c_print_count CONSTANT NUMBER := 107;
63 c_frozen_flag CONSTANT NUMBER := 108;
64 c_amount_to_encumber CONSTANT NUMBER := 109;
65 c_style_id_valid CONSTANT NUMBER := 110;
66 c_style_id_complex_work CONSTANT NUMBER := 111;
67 c_amount_limit_gt_zero CONSTANT NUMBER := 112;
68 c_amount_agreed_not_null CONSTANT NUMBER := 113;
69 c_amount_limit_gt_amt_agreed CONSTANT NUMBER := 114;
70 
71 
72 -- Quotation
73 c_quote_warning_delay CONSTANT NUMBER := 200;
74 c_approval_required_flag CONSTANT NUMBER := 201;
75 
76 --------------------------------------------------------------------------
77 -- Line Validation ID Constants
78 --------------------------------------------------------------------------
79 -- Common
80 c_release_num_null CONSTANT NUMBER := 300;
81 c_po_release_id_null CONSTANT NUMBER := 301;
82 c_closed_date_null CONSTANT NUMBER := 302;
83 c_contractor_name CONSTANT NUMBER := 303;
84 c_order_type_lookup_code CONSTANT NUMBER := 304;
85 c_job_id_null CONSTANT NUMBER := 305;
86 c_job_id_not_null CONSTANT NUMBER := 306;
87 c_job_id_valid CONSTANT NUMBER := 307;
88 c_job_id_valid_cat CONSTANT NUMBER := 308;
89 c_job_bg_id_not_cross_bg CONSTANT NUMBER := 309;
90 c_job_business_group_id_valid CONSTANT NUMBER := 310;
91 c_item_desc_not_null CONSTANT NUMBER := 311;
92 c_item_desc_not_updatable CONSTANT NUMBER := 312;
93 c_category_id_item CONSTANT NUMBER := 313;
94 c_category_id_not_null CONSTANT NUMBER := 314;
95 c_category_id_valid CONSTANT NUMBER := 315;
96 c_hazard_class_id_null CONSTANT NUMBER := 316;
97 c_hazard_class_id_valid CONSTANT NUMBER := 317;
98 c_un_number_id_null CONSTANT NUMBER := 318;
99 c_un_number_id_valid CONSTANT NUMBER := 319;
100 c_unit_meas_lookup_null CONSTANT NUMBER := 320;
101 c_unit_meas_lookup_not_null CONSTANT NUMBER := 321;
102 c_unit_meas_lookup_item CONSTANT NUMBER := 322;
103 c_unit_meas_lookup_valid CONSTANT NUMBER := 323;
104 c_unit_meas_lookup_svc_valid CONSTANT NUMBER := 324;
105 c_unit_meas_lookup_line_type CONSTANT NUMBER := 325;
106 c_unit_price_not_null CONSTANT NUMBER := 326;
107 c_unit_price_ge_zero CONSTANT NUMBER := 327;
108 c_unit_price_line_type CONSTANT NUMBER := 328;
109 c_unit_price_null CONSTANT NUMBER := 329;
110 c_item_id_not_null CONSTANT NUMBER := 330;
111 c_item_id_null CONSTANT NUMBER := 331;
112 c_item_id_valid CONSTANT NUMBER := 332;
113 c_item_id_op_valid CONSTANT NUMBER := 333;
114 c_item_revision_null CONSTANT NUMBER := 334;
115 c_item_revision_item CONSTANT NUMBER := 335;
116 c_line_type_id_not_null CONSTANT NUMBER := 336;
117 c_line_type_id_valid CONSTANT NUMBER := 337;
118 c_quantity_ge_zero CONSTANT NUMBER := 338;
119 c_quantity_null CONSTANT NUMBER := 339;
120 c_amount_null CONSTANT NUMBER := 340;
121 c_rate_type_no_usr CONSTANT NUMBER := 341;
122 c_line_num_not_null CONSTANT NUMBER := 342;
123 c_line_num_gt_zero CONSTANT NUMBER := 343;
124 c_line_num_unique CONSTANT NUMBER := 344;
125 c_po_line_id_not_null CONSTANT NUMBER := 345;
126 c_po_line_id_unique CONSTANT NUMBER := 346;
127 c_price_type_lookup_code CONSTANT NUMBER := 347;
128 c_line_sec_quantity_null CONSTANT NUMBER := 348;
129 c_line_sec_quantity_ge_zero CONSTANT NUMBER := 349;
130 c_line_sec_quantity_not_zero CONSTANT NUMBER := 350;
131 c_line_sec_quantity_not_reqd CONSTANT NUMBER := 351;
132 c_line_sec_quantity_no_req_uom CONSTANT NUMBER := 352;
133 c_line_sec_quantity_req_uom CONSTANT NUMBER := 353;
134 c_uom_update_not_null CONSTANT NUMBER := 354;
135 c_uom_update_valid CONSTANT NUMBER := 355;
136 c_unit_price_update_not_null CONSTANT NUMBER := 356;
137 c_unit_price_update_ge_zero CONSTANT NUMBER := 357;
138 c_item_desc_update_not_null CONSTANT NUMBER := 358;
139 c_item_desc_update_unupdatable CONSTANT NUMBER := 359;
140 c_ip_cat_id_update_not_null CONSTANT NUMBER := 360;
141 c_ip_cat_id_update_valid CONSTANT NUMBER := 361;
142 c_cat_id_update_not_null CONSTANT NUMBER := 362;
143 c_cat_id_update_not_updatable CONSTANT NUMBER := 363;
144 
145 -- Blanket
146 c_ga_flag_temp_labor CONSTANT NUMBER := 400;
147 c_ga_flag_op CONSTANT NUMBER := 401;
148 c_capital_expense_flag CONSTANT NUMBER := 402;
149 c_not_to_exceed_price_null CONSTANT NUMBER := 403;
150 c_not_to_exceed_price_valid CONSTANT NUMBER := 404;
151 c_amount_blanket CONSTANT NUMBER := 405;
152 c_expiration_date_blk_not_null CONSTANT NUMBER := 406;
153 c_expiration_date_blk_exc_hdr CONSTANT NUMBER := 407;
154 c_over_tolerance_err_flag_null CONSTANT NUMBER := 408;
155 c_ip_category_id_not_null CONSTANT NUMBER := 409;
156 c_ip_category_id_valid CONSTANT NUMBER := 410;
157 c_line_secondary_uom_not_null CONSTANT NUMBER := 411;
158 c_line_secondary_uom_null CONSTANT NUMBER := 412;
159 c_line_secondary_uom_correct CONSTANT NUMBER := 413;
160 c_line_preferred_grade CONSTANT NUMBER := 414;
161 c_line_preferred_grade_item CONSTANT NUMBER := 415;
162 c_line_preferred_grade_valid CONSTANT NUMBER := 416;
163 c_line_style_on_line_type CONSTANT NUMBER := 417;
164 c_line_style_on_purchase_basis CONSTANT NUMBER := 418;
165 c_negotiated_by_preparer CONSTANT NUMBER := 419;
166 c_nego_by_prep_update_not_null CONSTANT NUMBER := 420;
167 c_nego_by_prep_update_valid CONSTANT NUMBER := 421;
168 c_language CONSTANT NUMBER := 422;
169 c_amount_ge_zero CONSTANT NUMBER := 423;
170 
171 -- Quotation
172 c_over_tolerance_error_flag CONSTANT NUMBER := 500;
173 c_allow_price_override_null CONSTANT NUMBER := 501;
174 c_negotiated_by_preparer_null CONSTANT NUMBER := 502;
175 c_capital_expense_flag_null CONSTANT NUMBER := 503;
176 c_min_release_amount_null CONSTANT NUMBER := 504;
177 c_market_price_null CONSTANT NUMBER := 505;
178 c_committed_amount_null CONSTANT NUMBER := 506;
179 
180 -- Standard PO
181 c_amount_gt_zero CONSTANT NUMBER := 550;
182 
183 --------------------------------------------------------------------------
184 -- Line Location Validation ID Constants
185 --------------------------------------------------------------------------
186 -- Common
187 c_loc_need_by_date CONSTANT NUMBER := 600;
188 c_loc_promised_date CONSTANT NUMBER := 601;
189 c_loc_quantity CONSTANT NUMBER := 602;
190 c_loc_price_override_not_null CONSTANT NUMBER := 603;
191 c_loc_price_override_ge_zero CONSTANT NUMBER := 604;
192 c_loc_price_discount_not_null CONSTANT NUMBER := 605;
193 c_loc_price_discount_valid CONSTANT NUMBER := 606;
194 c_ship_to_organization_id CONSTANT NUMBER := 607;
195 c_loc_ship_to_loc_id_valid CONSTANT NUMBER := 608;
196 c_terms_id_line_loc CONSTANT NUMBER := 609;
197 c_shipment_num_not_null CONSTANT NUMBER := 610;
198 c_shipment_num_gt_zero CONSTANT NUMBER := 611;
199 c_shipment_num_unique CONSTANT NUMBER := 612;
200 c_loc_sec_quantity_null CONSTANT NUMBER := 613;
201 c_loc_sec_quantity_ge_zero CONSTANT NUMBER := 614;
202 c_loc_sec_quantity_not_zero CONSTANT NUMBER := 615;
203 c_loc_sec_quantity_not_reqd CONSTANT NUMBER := 616;
204 c_loc_sec_quantity_not_req_uom CONSTANT NUMBER := 617;
205 c_loc_sec_quantity_req_uom CONSTANT NUMBER := 618;
206 c_tax_name CONSTANT NUMBER := 619;
207 c_loc_quantity_ge_zero CONSTANT NUMBER := 620;
208 
209 -- Blanket
210 c_loc_from_date_ge_hdr_start CONSTANT NUMBER := 700;
211 c_loc_from_date_le_hdr_end CONSTANT NUMBER := 701;
212 c_loc_from_date_le_loc_end CONSTANT NUMBER := 702;
213 c_loc_from_date_le_line_end CONSTANT NUMBER := 703;
214 c_loc_end_date_le_line_end CONSTANT NUMBER := 704;
215 c_loc_end_date_le_hdr_end CONSTANT NUMBER := 705;
216 c_loc_end_date_ge_hdr_start CONSTANT NUMBER := 706;
217 c_shipment_type_not_null CONSTANT NUMBER := 707;
218 c_shipment_type_valid CONSTANT NUMBER := 708;
219 c_at_least_one_reqd_field CONSTANT NUMBER := 709;
220 c_need_by_date_null CONSTANT NUMBER := 710;
221 c_firm_flag_null CONSTANT NUMBER := 711;
222 c_freight_carrier_null CONSTANT NUMBER := 712;
223 c_fob_lookup_code_null CONSTANT NUMBER := 713;
224 c_freight_terms_null CONSTANT NUMBER := 714;
225 c_qty_rcv_tolerance_null CONSTANT NUMBER := 715;
226 c_receipt_reqd_flag_null CONSTANT NUMBER := 716;
227 c_inspection_reqd_flag_null CONSTANT NUMBER := 717;
228 c_receipt_days_except_null CONSTANT NUMBER := 718;
229 c_invoice_close_toler_null CONSTANT NUMBER := 719;
230 c_receive_close_toler_null CONSTANT NUMBER := 720;
231 c_days_early_rcpt_allowed_null CONSTANT NUMBER := 721;
232 c_days_late_rcpt_allowed_null CONSTANT NUMBER := 722;
233 c_enforce_shipto_loc_code_null CONSTANT NUMBER := 723;
234 c_allow_sub_receipts_flag_null CONSTANT NUMBER := 724;
235 c_promised_date_null CONSTANT NUMBER := 725;
236 c_receiving_routing_null CONSTANT NUMBER := 726;
237 c_loc_secondary_uom_null CONSTANT NUMBER := 727;
238 c_loc_secondary_uom_not_null CONSTANT NUMBER := 728;
239 c_loc_secondary_uom_correct CONSTANT NUMBER := 729;
240 c_loc_preferred_grade CONSTANT NUMBER := 730;
241 c_loc_preferred_grade_item CONSTANT NUMBER := 731;
242 c_loc_preferred_grade_valid CONSTANT NUMBER := 732;
243 c_loc_style_related_info CONSTANT NUMBER := 733;
244 c_price_break_not_allowed CONSTANT NUMBER := 734;
245 c_dates_cumulative_failed CONSTANT NUMBER := 735;
246 
247 -- Quotation
248 c_qty_ecv_exception_code CONSTANT NUMBER := 800;
249 c_loc_fob_lookup_code CONSTANT NUMBER := 801;
250 c_loc_freight_terms CONSTANT NUMBER := 802;
251 c_loc_freight_carrier CONSTANT NUMBER := 803;
252 
253 --------------------------------------------------------------------------
254 -- Price Differential Validation ID Constants
255 --------------------------------------------------------------------------
256 -- Common
257 c_price_type_not_null CONSTANT NUMBER := 900;
258 c_price_type_valid CONSTANT NUMBER := 901;
259 c_multiple_price_diff CONSTANT NUMBER := 902;
260 c_entity_type CONSTANT NUMBER := 903;
261 c_multiplier_not_null CONSTANT NUMBER := 904;
262 c_multiplier_null CONSTANT NUMBER := 905;
263 c_min_multiplier_null CONSTANT NUMBER := 906;
264 c_min_multiplier_not_null CONSTANT NUMBER := 907;
265 c_max_multiplier_null CONSTANT NUMBER := 908;
266 c_price_diff_style_info CONSTANT NUMBER := 909;
267 
268 ---------------------------------------------------------------------------
269 -- Validation ID Constants for errors not thrown by validation framework
270 --------------------------------------------------------------------------
271 c_line_type_derv CONSTANT NUMBER := 1000;
272 c_category_derv CONSTANT NUMBER := 1001;
273 c_ip_category_derv CONSTANT NUMBER := 1002;
274 c_job_name_derv CONSTANT NUMBER := 1003;
275 c_uom_code_derv CONSTANT NUMBER := 1004;
276 c_item_derv CONSTANT NUMBER := 1005;
277 c_ship_to_org_code_derv CONSTANT NUMBER := 1006;
278 c_ship_to_location_derv CONSTANT NUMBER := 1007;
279 c_part_num_derv CONSTANT NUMBER := 1008;
280 c_line_rec_valid CONSTANT NUMBER := 1009;
281 
282 END PO_VAL_CONSTANTS;