[Home] [Help]
PACKAGE: APPS.WSH_ACTIONS_LEVELS
Source
1 PACKAGE WSH_ACTIONS_LEVELS as
2 /* $Header: WSHACLVS.pls 120.0 2005/05/26 17:18:29 appldev noship $ */
3
4 c_sdebug CONSTANT NUMBER := wsh_debug_sv.c_level1;
5 c_debug CONSTANT NUMBER := wsh_debug_sv.c_level2;
6
7 C_ACTION_ENABLED_LVL CONSTANT NUMBER := 1;
8 C_LOCK_RECORDS_LVL CONSTANT NUMBER := 2;
9 C_DLVY_ACTION_ENABLED_LVL CONSTANT NUMBER := 3;
10 C_DECIMAL_QUANTITY_LVL CONSTANT NUMBER := 4;
11 C_DLVY_DEFAULTS_LVL CONSTANT NUMBER := 5;
12 C_TRIP_NAME_LVL CONSTANT NUMBER := 6;
13 C_STOP_NAME_LVL CONSTANT NUMBER := 7;
14 C_SEQ_NUM_LVL CONSTANT NUMBER := 8;
15 C_CHECK_UNASSIGN_LVL CONSTANT NUMBER := 9;
16 C_DOCUMENT_SETS_LVL CONSTANT NUMBER := 10;
17 C_TRIP_STOP_VALIDATION_LVL CONSTANT NUMBER := 11;
18 C_STOP_DEFAULTS_LVL CONSTANT NUMBER := 12;
19 C_LOCATION_LVL CONSTANT NUMBER := 13;
20 C_TRIP_SMC_LVL CONSTANT NUMBER := 14;
21 C_BOL_NUM_LVL CONSTANT NUMBER := 15;
22 C_CHK_UPDATE_STATUS_LVL CONSTANT NUMBER := 16;
23 C_FREIGHT_COST_TYPE_LVL CONSTANT NUMBER := 17;
24 C_FREIGHT_UNIT_AMT_LVL CONSTANT NUMBER := 18;
25 C_FREIGHT_CONV_RATE_LVL CONSTANT NUMBER := 19;
26 C_FREIGHT_CURR_CODE_LVL CONSTANT NUMBER := 20;
27 C_PARENT_ENTITY_LVL CONSTANT NUMBER := 21;
28 C_CONTAINER_STATUS_LVL CONSTANT NUMBER := 22;
29 C_CONTAINER_ORG_LVL CONSTANT NUMBER := 23;
30 C_CONT_DLVY_LVL CONSTANT NUMBER := 24;
31 C_TRIP_STATUS_LVL CONSTANT NUMBER := 25;
32 C_PLANNED_TRIP_LVL CONSTANT NUMBER := 26;
33 C_WEIGHT_UOM_LVL CONSTANT NUMBER := 27;
34 C_VOLUME_UOM_LVL CONSTANT NUMBER := 28;
35 C_ARR_DEP_DATES_LVL CONSTANT NUMBER := 29;
36 C_DISABLED_LIST_LVL CONSTANT NUMBER := 30;
37 C_ARR_AFTER_TRIP_LVL CONSTANT NUMBER := 31;
38 C_VEH_ORG_LVL CONSTANT NUMBER := 32;
39 C_TRIP_MOT_LVL CONSTANT NUMBER := 33;
40 C_SERVICE_LVL CONSTANT NUMBER := 34;
41 C_CARRIER_LVL CONSTANT NUMBER := 35;
42 C_VEH_ITEM_LVL CONSTANT NUMBER := 36;
43 C_CONSOL_ALLW_LVL CONSTANT NUMBER := 37;
44 --Following levels Added by KVENKATE for delivery details
45 C_GROSS_WEIGHT_LVL CONSTANT NUMBER := 38;
46 C_NET_WEIGHT_LVL CONSTANT NUMBER := 39;
47 C_VOLUME_LVL CONSTANT NUMBER := 40;
48 C_CUSTOMER_LVL CONSTANT NUMBER := 41;
49 C_SHIP_FROM_ORG_LVL CONSTANT NUMBER := 42;
50 C_SHIP_TO_ORG_LVL CONSTANT NUMBER := 43;
51 C_DELV_TO_ORG_LVL CONSTANT NUMBER := 44;
52 C_INTMED_SHIP_ORG_LVL CONSTANT NUMBER := 45;
53 C_TOL_ABOVE_LVL CONSTANT NUMBER := 46;
54 C_TOL_BELOW_LVL CONSTANT NUMBER := 47;
55 C_SHIP_QTY_LVL CONSTANT NUMBER := 48;
56 C_CC_QTY_LVL CONSTANT NUMBER := 49;
57 C_SERIAL_NUM_LVL CONSTANT NUMBER := 50;
58 C_SMC_LVL CONSTANT NUMBER := 51;
59 C_FREIGHT_TERMS_LVL CONSTANT NUMBER := 52;
60 C_FOB_LVL CONSTANT NUMBER := 53;
61 C_DEP_PLAN_LVL CONSTANT NUMBER := 54;
62 C_SHIP_MOD_COMP_LVL CONSTANT NUMBER := 55;
63 C_REL_STATUS_LVL CONSTANT NUMBER := 56;
64 C_SUB_INV_LVL CONSTANT NUMBER := 57;
65 C_REVISION_LVL CONSTANT NUMBER := 58;
66 C_LOCATOR_LVL CONSTANT NUMBER := 59;
67 C_LOT_NUMBER_LVL CONSTANT NUMBER := 60;
68 C_SOLD_CONTACT_LVL CONSTANT NUMBER := 61;
69 C_SHIP_CONTACT_LVL CONSTANT NUMBER := 62;
70 C_DELIVER_CONTACT_LVL CONSTANT NUMBER := 63;
71 C_INTMED_SHIP_CONTACT_LVL CONSTANT NUMBER := 64;
72 C_CONT_ITEM_LVL CONSTANT NUMBER := 65;
73 C_MASTER_SER_NUM_LVL CONSTANT NUMBER := 66;
74 -- I Harmonization: rvishnuv ******* Delivery
75 C_DELIVERY_NAME_LVL CONSTANT NUMBER := 67;
76 C_ORGANIZATION_LVL CONSTANT NUMBER := 68;
77 C_LOADING_ORDER_LVL CONSTANT NUMBER := 69;
78 C_SHIP_FROM_LOC_LVL CONSTANT NUMBER := 70;
79 C_SHIP_TO_LOC_LVL CONSTANT NUMBER := 71;
80 C_INTMD_SHIPTO_LOC_LVL CONSTANT NUMBER := 72;
81 C_POOLED_SHIPTO_LOC_LVL CONSTANT NUMBER := 73;
82 C_DLVY_ORG_LVL CONSTANT NUMBER := 74;
83 C_FREIGHT_CARRIER_LVL CONSTANT NUMBER := 75;
84 C_FOB_LOC_LVL CONSTANT NUMBER := 76;
85 C_ROUTE_EXPORT_TXN_LVL CONSTANT NUMBER := 77;
86 C_CURRENCY_LVL CONSTANT NUMBER := 78;
87 C_NUMBER_OF_LPN_LVL CONSTANT NUMBER := 79;
88 C_DERIVE_DELIVERY_UOM_LVL CONSTANT NUMBER := 80;
89
90 -- HW Harmonization project for OPM. Added qty2
91 C_SHIP_QTY2_LVL CONSTANT NUMBER := 81;
92 C_CC_QTY2_LVL CONSTANT NUMBER := 82;
93 --I Harmonization KVENKATE
94 C_DET_INSPECT_FLAG_LVL CONSTANT NUMBER := 83;
95 C_MASTER_LPN_ITEM_LVL CONSTANT NUMBER := 84;
96 C_DETAIL_LPN_ITEM_LVL CONSTANT NUMBER := 85;
97
98 -- I Harmonization: rvishnuv ******** Delivery
99 C_PRINT_LABEL_LVL CONSTANT NUMBER := 86;
100 -- sperera ALCOA fix
101 C_TRIP_CONFIRM_DEFAULT_LVL CONSTANT NUMBER :=87;
102 -- kvenkate
103 C_LOCK_RELATED_ENTITIES_LVL CONSTANT NUMBER := 88;
104 --bms
105 C_VALIDATE_CONSTRAINTS_LVL CONSTANT NUMBER := 89;
106 --bms
107 C_VALIDATE_FREIGHT_CLASS_LVL CONSTANT NUMBER := 90;
108 C_VALIDATE_OM_QTY_WT_VOL_LVL CONSTANT NUMBER := 91;
109 C_VALIDATE_OKE_NULL_FIELDS_LVL CONSTANT NUMBER := 92;
110 C_VALIDATE_OM_MIS_LVL CONSTANT NUMBER := 93;
111 C_VALIDATE_OKE_MIS_LVL CONSTANT NUMBER := 94;
112 C_POPULATE_ORGANIZATION_ID CONSTANT NUMBER := 95;
113 C_GET_SHIP_FROM_LOC_LVL CONSTANT NUMBER := 96;
114 C_GET_SHIPTO_LOC_LVL CONSTANT NUMBER := 97;
115 C_GET_DELIVER_TO_LOC_LVL CONSTANT NUMBER := 98;
116 C_GET_INTMED_SHIPTO_LOC_LVL CONSTANT NUMBER := 99;
117 C_VALIDATE_SHIPTO_LOC_LVL CONSTANT NUMBER := 100;
118 C_VALIDATE_SHIP_FROM_LOC_LVL CONSTANT NUMBER := 101;
119 C_DEFAULT_FLEX_LVL CONSTANT NUMBER := 102;
120 C_DEFAULT_CONTAINEER_LVL CONSTANT NUMBER := 103;
121 C_CREATE_MIXED_TRIP_LVL CONSTANT NUMBER := 104; -- J-IB-NPARIKH
122 C_CREATE_MIXED_STOP_LVL CONSTANT NUMBER := 105; -- J-IB-NPARIKH
123 -- J-IB-ANVISWAN
124 C_PO_CHECK_ORGID_LVL CONSTANT NUMBER := 106;
125 C_PO_DEFAULT_SHIPFROM_LVL CONSTANT NUMBER := 107;
126 C_PO_VALIDATE_MAN_FIELDS_LVL CONSTANT NUMBER := 108;
127 C_PO_DERIVE_DROPSHIP_LVL CONSTANT NUMBER := 109;
128 C_PO_VALIDATE_SHPTO_LOC_LVL CONSTANT NUMBER := 110;
129 C_PO_VALIDATE_FOB_LVL CONSTANT NUMBER := 111;
130 C_PO_VALIDATE_FR_TERMS_LVL CONSTANT NUMBER := 112;
131 C_PO_CALC_WT_VOL_LVL CONSTANT NUMBER := 113;
132 C_PO_GET_OPM_QTY_LVL CONSTANT NUMBER := 114;
133 C_PO_DEFAULT_FLEX_LVL CONSTANT NUMBER := 115;
134 C_PLAN_ARR_DATE_LVL CONSTANT NUMBER := 116; -- J-Stop Sequence Change-CSUN
135 C_WMS_CONTAINERS_LVL CONSTANT NUMBER := 117; -- K-LPN Conv
136
137
138
139
140 g_validation_level_tab wsh_util_core.id_tab_type;
141
142 PROCEDURE set_validation_level_on (
143 p_entity IN VARCHAR2,
144 x_return_status OUT NOCOPY VARCHAR2
145 );
146
147 PROCEDURE set_validation_level_off (
148 p_entity IN VARCHAR2,
149 x_return_status OUT NOCOPY VARCHAR2
150 );
151
152
153 PROCEDURE set_validation_level (
154 p_entity IN VARCHAR2,
155 p_caller IN VARCHAR2,
156 p_phase IN NUMBER,
157 p_action IN VARCHAR2,
158 x_return_status OUT NOCOPY VARCHAR2
159 );
160
161 END WSH_ACTIONS_LEVELS;