DBA Data[Home] [Help]

APPS.GMD_GME_INT dependencies on GMD_DEBUG

Line 90: gmd_debug.log_initialize('GMDGMEInt');

86:
87: BEGIN
88:
89: IF (l_debug = 'Y') THEN
90: gmd_debug.log_initialize('GMDGMEInt');
91: gmd_debug.put_line('Entering GMD_GME_INT.check_qc') ;
92: END IF;
93:
94: -- p_resultout := 'F' = No sample Required

Line 91: gmd_debug.put_line('Entering GMD_GME_INT.check_qc') ;

87: BEGIN
88:
89: IF (l_debug = 'Y') THEN
90: gmd_debug.log_initialize('GMDGMEInt');
91: gmd_debug.put_line('Entering GMD_GME_INT.check_qc') ;
92: END IF;
93:
94: -- p_resultout := 'F' = No sample Required
95: -- p_resultout := 'S' = Sample Required

Line 111: gmd_debug.put_line('recipe ID ' || p_recipeid);

107:
108:
109:
110: IF (l_debug = 'Y') THEN
111: gmd_debug.put_line('recipe ID ' || p_recipeid);
112: gmd_debug.put_line('routing ID ' || p_routingid);
113: gmd_debug.put_line('routing step ID ' || p_routingstepid);
114: gmd_debug.put_line('organization_id ' || p_organization_id);
115: END IF;

Line 112: gmd_debug.put_line('routing ID ' || p_routingid);

108:
109:
110: IF (l_debug = 'Y') THEN
111: gmd_debug.put_line('recipe ID ' || p_recipeid);
112: gmd_debug.put_line('routing ID ' || p_routingid);
113: gmd_debug.put_line('routing step ID ' || p_routingstepid);
114: gmd_debug.put_line('organization_id ' || p_organization_id);
115: END IF;
116:

Line 113: gmd_debug.put_line('routing step ID ' || p_routingstepid);

109:
110: IF (l_debug = 'Y') THEN
111: gmd_debug.put_line('recipe ID ' || p_recipeid);
112: gmd_debug.put_line('routing ID ' || p_routingid);
113: gmd_debug.put_line('routing step ID ' || p_routingstepid);
114: gmd_debug.put_line('organization_id ' || p_organization_id);
115: END IF;
116:
117: /* For a given recipe id, routing id, routingstepid combination */

Line 114: gmd_debug.put_line('organization_id ' || p_organization_id);

110: IF (l_debug = 'Y') THEN
111: gmd_debug.put_line('recipe ID ' || p_recipeid);
112: gmd_debug.put_line('routing ID ' || p_routingid);
113: gmd_debug.put_line('routing step ID ' || p_routingstepid);
114: gmd_debug.put_line('organization_id ' || p_organization_id);
115: END IF;
116:
117: /* For a given recipe id, routing id, routingstepid combination */
118: OPEN C1(p_routingid,p_routingstepid,p_recipeid);

Line 161: gmd_debug.put_line('Checking if WIP Spec exists ');

157: l_wip_spec.formulaline_id := l_formulaline_id; --Bug#6379386
158: l_step_id := l_routingstepid;
159:
160: IF (l_debug = 'Y') THEN
161: gmd_debug.put_line('Checking if WIP Spec exists ');
162: END IF;
163:
164: IF GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC(
165: p_wip_spec_rec => l_wip_spec,

Line 172: gmd_debug.put_line('WIP Spec exists ');

168: x_return_status => l_return_status,
169: x_message_data => l_msg_data) THEN
170:
171: IF (l_debug = 'Y') THEN
172: gmd_debug.put_line('WIP Spec exists ');
173: END IF;
174: -- changes start for Bug No.14033362
175:
176: OPEN get_batch_step_status(l_spec_vr_id);

Line 181: gmd_debug.put_line('l_control_batch_step_ind ' || l_control_batch_step_ind);

177: FETCH get_batch_step_status
178: into l_control_batch_step_ind ;
179: CLOSE get_batch_step_status;
180: IF (l_debug = 'Y') THEN
181: gmd_debug.put_line('l_control_batch_step_ind ' || l_control_batch_step_ind);
182: END IF;
183:
184: IF l_control_batch_step_ind = 'Y' then
185: IF (l_debug = 'Y') THEN

Line 186: gmd_debug.put_line('l_control_batch_step_ind = Y so p_resultout = S');

182: END IF;
183:
184: IF l_control_batch_step_ind = 'Y' then
185: IF (l_debug = 'Y') THEN
186: gmd_debug.put_line('l_control_batch_step_ind = Y so p_resultout = S');
187: END IF;
188:
189: p_resultout:='S';
190: EXIT;

Line 196: gmd_debug.put_line('GMD_BATCH_STEP_SMPL_REQD = Y so p_resultout = S');

192: ELSE
193:
194: IF NVL(FND_PROFILE.VALUE('GMD_BATCH_STEP_SMPL_REQD'), 'N') = 'Y' THEN
195: IF (l_debug = 'Y') THEN
196: gmd_debug.put_line('GMD_BATCH_STEP_SMPL_REQD = Y so p_resultout = S');
197: END IF;
198:
199: p_resultout := 'S';
200: EXIT ;

Line 203: gmd_debug.put_line('GMD_BATCH_STEP_SMPL_REQD = N so p_resultout = F');

199: p_resultout := 'S';
200: EXIT ;
201: ELSE
202: IF (l_debug = 'Y') THEN
203: gmd_debug.put_line('GMD_BATCH_STEP_SMPL_REQD = N so p_resultout = F');
204: END IF;
205:
206: p_resultout := 'F';
207: END IF; -- IF NVL(FND_PROFILE.VALUE('GMD_BATCH_STEP_SMPL_REQD'), 'N') = 'Y' THEN

Line 215: gmd_debug.put_line('WIP Spec does NOT exists ');

211:
212:
213: ELSE -- IF GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC(
214: IF (l_debug = 'Y') THEN
215: gmd_debug.put_line('WIP Spec does NOT exists ');
216: gmd_debug.put_line('p_resultout = F');
217: END IF;
218:
219: p_resultout:='F';

Line 216: gmd_debug.put_line('p_resultout = F');

212:
213: ELSE -- IF GMD_SPEC_MATCH_GRP.FIND_WIP_SPEC(
214: IF (l_debug = 'Y') THEN
215: gmd_debug.put_line('WIP Spec does NOT exists ');
216: gmd_debug.put_line('p_resultout = F');
217: END IF;
218:
219: p_resultout:='F';
220:

Line 235: gmd_debug.put_line('p_resultout ' || p_resultout);

231: p_resultout:='F';
232: end if ;
233:
234: IF (l_debug = 'Y') THEN
235: gmd_debug.put_line('p_resultout ' || p_resultout);
236: END IF;
237:
238:
239: EXCEPTION