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.

APPS.GMO_VALIDATE_BATCH_GRP dependencies on GMO_CONSTANTS_GRP

Line 78: -- - 1. GMO_CONSTANTS_GRP.ENTITY_BATCH for validating a batch

74: -- Default = FND_API.G_FALSE
75:
76: -- P_ENTITY_NAME(Required) - VARCHAR2 - The entity to be validated. It takes only the following values.
77:
78: -- - 1. GMO_CONSTANTS_GRP.ENTITY_BATCH for validating a batch
79:
80: -- - 2. GMO_CONSTANTS_GRP.ENTITY_OPERATION for validating a batch step.
81:
82: -- - If any other value is provided then the API will error out.

Line 80: -- - 2. GMO_CONSTANTS_GRP.ENTITY_OPERATION for validating a batch step.

76: -- P_ENTITY_NAME(Required) - VARCHAR2 - The entity to be validated. It takes only the following values.
77:
78: -- - 1. GMO_CONSTANTS_GRP.ENTITY_BATCH for validating a batch
79:
80: -- - 2. GMO_CONSTANTS_GRP.ENTITY_OPERATION for validating a batch step.
81:
82: -- - If any other value is provided then the API will error out.
83:
84:

Line 114: where ((GMO_CONSTANTS_GRP.ENTITY_BATCH = P_ENTITY_NAME AND batch_id = p_entity_key) OR

110: INSTRUNCTION_EXCEPTION EXCEPTION;
111: cursor c_get_steps is
112: select batch_id, batchstep_id
113: from gme_batch_steps
114: where ((GMO_CONSTANTS_GRP.ENTITY_BATCH = P_ENTITY_NAME AND batch_id = p_entity_key) OR
115: (GMO_CONSTANTS_GRP.ENTITY_OPERATION = P_ENTITY_NAME AND batchstep_id = p_entity_key));
116:
117: cursor c_get_activities is
118: select batchstep_activity_id

Line 115: (GMO_CONSTANTS_GRP.ENTITY_OPERATION = P_ENTITY_NAME AND batchstep_id = p_entity_key));

111: cursor c_get_steps is
112: select batch_id, batchstep_id
113: from gme_batch_steps
114: where ((GMO_CONSTANTS_GRP.ENTITY_BATCH = P_ENTITY_NAME AND batch_id = p_entity_key) OR
115: (GMO_CONSTANTS_GRP.ENTITY_OPERATION = P_ENTITY_NAME AND batchstep_id = p_entity_key));
116:
117: cursor c_get_activities is
118: select batchstep_activity_id
119: from gme_batch_step_activities

Line 164: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,

160: EXIT WHEN c_get_steps%NOTFOUND;
161:
162: -- Check for pending mandatory instructions
163:
164: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
165: P_ENTITY_KEY => l_batchstep_id,
166: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
167: x_msg_data => x_msg_data )
168: THEN

Line 166: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

162: -- Check for pending mandatory instructions
163:
164: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
165: P_ENTITY_KEY => l_batchstep_id,
166: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
167: x_msg_data => x_msg_data )
168: THEN
169: close c_get_steps;
170: RAISE INSTRUCTIONS_PENDING;

Line 184: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,

180: EXIT WHEN c_get_activities%NOTFOUND;
181:
182: -- Check for pending mandatory instructions
183:
184: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
185: P_ENTITY_KEY => l_batchstep_activity_id,
186: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
187: x_msg_data => x_msg_data)
188: THEN

Line 186: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

182: -- Check for pending mandatory instructions
183:
184: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
185: P_ENTITY_KEY => l_batchstep_activity_id,
186: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
187: x_msg_data => x_msg_data)
188: THEN
189: close c_get_activities;
190: RAISE INSTRUCTIONS_PENDING;

Line 204: IF NOT IS_PIS_PENDING(P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,

200: EXIT WHEN c_get_resources%NOTFOUND;
201:
202: -- Check for pending mandatory instructions
203:
204: IF NOT IS_PIS_PENDING(P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
205: P_ENTITY_KEY => l_batchstep_resource_id,
206: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
207: x_msg_data => x_msg_data)
208: THEN

Line 206: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

202: -- Check for pending mandatory instructions
203:
204: IF NOT IS_PIS_PENDING(P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
205: P_ENTITY_KEY => l_batchstep_resource_id,
206: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
207: x_msg_data => x_msg_data)
208: THEN
209: close c_get_resources;
210: RAISE INSTRUCTIONS_PENDING;

Line 222: IF GMO_CONSTANTS_GRP.ENTITY_BATCH = P_ENTITY_NAME THEN

218: END LOOP;
219: close c_get_steps;
220:
221: -- Process material lines
222: IF GMO_CONSTANTS_GRP.ENTITY_BATCH = P_ENTITY_NAME THEN
223: open c_get_materials;
224: LOOP
225: FETCH c_get_materials into l_material_detail_id;
226: EXIT WHEN c_get_materials%NOTFOUND;

Line 229: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,

225: FETCH c_get_materials into l_material_detail_id;
226: EXIT WHEN c_get_materials%NOTFOUND;
227:
228: -- Check for pending mandatory instructions
229: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
230: P_ENTITY_KEY => l_material_detail_id,
231: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
232: x_msg_data => x_msg_data)
233: THEN

Line 231: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

227:
228: -- Check for pending mandatory instructions
229: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
230: P_ENTITY_KEY => l_material_detail_id,
231: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
232: x_msg_data => x_msg_data)
233: THEN
234: close c_get_materials;
235: RAISE INSTRUCTIONS_PENDING;

Line 285: ELSIF GMO_CONSTANTS_GRP.ENTITY_OPERATION = P_ENTITY_NAME THEN

281: IF l_ncm_count > 0 THEN
282: raise NCM_NOT_CLOSED;
283: END IF;
284:
285: ELSIF GMO_CONSTANTS_GRP.ENTITY_OPERATION = P_ENTITY_NAME THEN
286: l_batchstep_id := p_entity_key;
287: open c_get_step_materials;
288: LOOP
289: FETCH c_get_step_materials into l_material_detail_id;

Line 293: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,

289: FETCH c_get_step_materials into l_material_detail_id;
290: EXIT WHEN c_get_step_materials%NOTFOUND;
291:
292: -- Check for pending mandatory instructions
293: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
294: P_ENTITY_KEY => l_material_detail_id,
295: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
296: x_msg_data => x_msg_data)
297: THEN

Line 295: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

291:
292: -- Check for pending mandatory instructions
293: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
294: P_ENTITY_KEY => l_material_detail_id,
295: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
296: x_msg_data => x_msg_data)
297: THEN
298: close c_get_step_materials;
299: RAISE INSTRUCTIONS_PENDING;