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 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 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 159: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,

155: EXIT WHEN c_get_steps%NOTFOUND;
156:
157: -- Check for pending mandatory instructions
158:
159: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
160: P_ENTITY_KEY => l_batchstep_id,
161: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
162: x_msg_data => x_msg_data )
163: THEN

Line 161: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

157: -- Check for pending mandatory instructions
158:
159: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_OPERATION,
160: P_ENTITY_KEY => l_batchstep_id,
161: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
162: x_msg_data => x_msg_data )
163: THEN
164: close c_get_steps;
165: RAISE INSTRUCTIONS_PENDING;

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

175: EXIT WHEN c_get_activities%NOTFOUND;
176:
177: -- Check for pending mandatory instructions
178:
179: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
180: P_ENTITY_KEY => l_batchstep_activity_id,
181: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
182: x_msg_data => x_msg_data)
183: THEN

Line 181: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

177: -- Check for pending mandatory instructions
178:
179: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_ACTIVITY,
180: P_ENTITY_KEY => l_batchstep_activity_id,
181: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
182: x_msg_data => x_msg_data)
183: THEN
184: close c_get_activities;
185: RAISE INSTRUCTIONS_PENDING;

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

195: EXIT WHEN c_get_resources%NOTFOUND;
196:
197: -- Check for pending mandatory instructions
198:
199: IF NOT IS_PIS_PENDING(P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
200: P_ENTITY_KEY => l_batchstep_resource_id,
201: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
202: x_msg_data => x_msg_data)
203: THEN

Line 201: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

197: -- Check for pending mandatory instructions
198:
199: IF NOT IS_PIS_PENDING(P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_RESOURCE,
200: P_ENTITY_KEY => l_batchstep_resource_id,
201: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
202: x_msg_data => x_msg_data)
203: THEN
204: close c_get_resources;
205: RAISE INSTRUCTIONS_PENDING;

Line 217: IF GMO_CONSTANTS_GRP.ENTITY_BATCH = P_ENTITY_NAME THEN

213: END LOOP;
214: close c_get_steps;
215:
216: -- Process material lines
217: IF GMO_CONSTANTS_GRP.ENTITY_BATCH = P_ENTITY_NAME THEN
218: open c_get_materials;
219: LOOP
220: FETCH c_get_materials into l_material_detail_id;
221: EXIT WHEN c_get_materials%NOTFOUND;

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

220: FETCH c_get_materials into l_material_detail_id;
221: EXIT WHEN c_get_materials%NOTFOUND;
222:
223: -- Check for pending mandatory instructions
224: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
225: P_ENTITY_KEY => l_material_detail_id,
226: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
227: x_msg_data => x_msg_data)
228: THEN

Line 226: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

222:
223: -- Check for pending mandatory instructions
224: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
225: P_ENTITY_KEY => l_material_detail_id,
226: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
227: x_msg_data => x_msg_data)
228: THEN
229: close c_get_materials;
230: RAISE INSTRUCTIONS_PENDING;

Line 280: ELSIF GMO_CONSTANTS_GRP.ENTITY_OPERATION = P_ENTITY_NAME THEN

276: IF l_ncm_count > 0 THEN
277: raise NCM_NOT_CLOSED;
278: END IF;
279:
280: ELSIF GMO_CONSTANTS_GRP.ENTITY_OPERATION = P_ENTITY_NAME THEN
281: l_batchstep_id := p_entity_key;
282: open c_get_step_materials;
283: LOOP
284: FETCH c_get_step_materials into l_material_detail_id;

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

284: FETCH c_get_step_materials into l_material_detail_id;
285: EXIT WHEN c_get_step_materials%NOTFOUND;
286:
287: -- Check for pending mandatory instructions
288: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
289: P_ENTITY_KEY => l_material_detail_id,
290: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
291: x_msg_data => x_msg_data)
292: THEN

Line 290: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,

286:
287: -- Check for pending mandatory instructions
288: IF NOT IS_PIS_PENDING (P_ENTITY_NAME => GMO_CONSTANTS_GRP.ENTITY_MATERIAL,
289: P_ENTITY_KEY => l_material_detail_id,
290: P_INSTRUCTION_TYPE => GMO_CONSTANTS_GRP.VBATCH_INSTRUCTION_TYPE,
291: x_msg_data => x_msg_data)
292: THEN
293: close c_get_step_materials;
294: RAISE INSTRUCTIONS_PENDING;