APPS.GMD_QMREJ dependencies on GMD_DEBUG

Line 146: gmd_debug.log_initialize('Samplerej');

142: BEGIN
143:
144:
145: IF (l_debug = 'Y') THEN
146: gmd_debug.log_initialize('Samplerej');
147: END IF;
148:
149: open get_from_role ;
150: fetch get_from_role into l_from_role ;

Line 178: gmd_debug.put_line('Organization Code ' || l_orgn_code);

174: CLOSE common_fields2;
175: END IF;
176:
177: IF (l_debug = 'Y') THEN
178: gmd_debug.put_line('Organization Code ' || l_orgn_code);
179: gmd_debug.put_line('Sample Type ' || l_sample_type);
180: gmd_debug.put_line('Sample Source' || l_sample_source);
181: END IF;
182:

Line 179: gmd_debug.put_line('Sample Type ' || l_sample_type);

175: END IF;
176:
177: IF (l_debug = 'Y') THEN
178: gmd_debug.put_line('Organization Code ' || l_orgn_code);
179: gmd_debug.put_line('Sample Type ' || l_sample_type);
180: gmd_debug.put_line('Sample Source' || l_sample_source);
181: END IF;
182:
183: /* check to see if Stability or Resource/Location Sample */

Line 180: gmd_debug.put_line('Sample Source' || l_sample_source);

176:
177: IF (l_debug = 'Y') THEN
178: gmd_debug.put_line('Organization Code ' || l_orgn_code);
179: gmd_debug.put_line('Sample Type ' || l_sample_type);
180: gmd_debug.put_line('Sample Source' || l_sample_source);
181: END IF;
182:
183: /* check to see if Stability or Resource/Location Sample */
184: open C3;

Line 189: gmd_debug.put_line('Sample source type ' || l_source);

185: fetch C3 into l_source, l_ss_id ;
186: close C3 ;
187:
188: IF (l_debug = 'Y') THEN
189: gmd_debug.put_line('Sample source type ' || l_source);
190: gmd_debug.put_line('Stability Study ID ' || l_ss_id);
191: END IF;
192:
193: if (l_source = 'T') then

Line 190: gmd_debug.put_line('Stability Study ID ' || l_ss_id);

186: close C3 ;
187:
188: IF (l_debug = 'Y') THEN
189: gmd_debug.put_line('Sample source type ' || l_source);
190: gmd_debug.put_line('Stability Study ID ' || l_ss_id);
191: END IF;
192:
193: if (l_source = 'T') then
194: /* This is a stabiliy study sample */

Line 217: gmd_debug.put_line('Checking approvers ');

213: end if;
214: end if;
215:
216: IF (l_debug = 'Y') THEN
217: gmd_debug.put_line('Checking approvers ');
218: END IF;
219:
220: /* Set Form Attribute to the sampling event */
221: l_form := 'GMDQSAMPLES_F:SAMPLING_EVENT_ID="'||l_event_key||'"';

Line 246: gmd_debug.put_line('Found approvers ');

242: select user_name into l_user from fnd_user where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
243: end if;
244:
245: IF (l_debug = 'Y') THEN
246: gmd_debug.put_line('Found approvers ');
247: END IF;
248:
249: l_itemtype:='GMDQMREJ';
250: l_itemkey:=l_event_key||'-'||to_char(sysdate,'dd/mm/yy hh:mi:ss');

Line 361: gmd_debug.put_line('created workflow process ');

357:
358: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
359:
360: IF (l_debug = 'Y') THEN
361: gmd_debug.put_line('created workflow process ');
362: END IF;
363:
364:
365: end if; /* No approver condition */