DBA Data[Home] [Help]

APPS.GMD_QM_UOM dependencies on GMD_DEBUG

Line 247: gmd_debug.log_initialize('UomConv');

243: BEGIN
244:
245:
246: IF (l_debug = 'Y') THEN
247: gmd_debug.log_initialize('UomConv');
248: END IF;
249:
250: IF (l_debug = 'Y') THEN
251: gmd_debug.put_line('Event Name ' || l_event_name);

Line 251: gmd_debug.put_line('Event Name ' || l_event_name);

247: gmd_debug.log_initialize('UomConv');
248: END IF;
249:
250: IF (l_debug = 'Y') THEN
251: gmd_debug.put_line('Event Name ' || l_event_name);
252: gmd_debug.put_line('Event Key ' || l_event_key);
253: END IF;
254:
255: open get_from_role ;

Line 252: gmd_debug.put_line('Event Key ' || l_event_key);

248: END IF;
249:
250: IF (l_debug = 'Y') THEN
251: gmd_debug.put_line('Event Name ' || l_event_name);
252: gmd_debug.put_line('Event Key ' || l_event_key);
253: END IF;
254:
255: open get_from_role ;
256: fetch get_from_role into l_from_role ;

Line 275: gmd_debug.put_line('Getting data from cursors ');

271: wf_log_pkg.string(6, 'Dummy','Before Fetching the values. Inside the Loop');
272:
273:
274: IF (l_debug = 'Y') THEN
275: gmd_debug.put_line('Getting data from cursors ');
276: END IF;
277:
278:
279: Fetch C1 into l_item_id,

Line 355: gmd_debug.put_line('l_source ' || l_source);

351: close get_owner_name;
352:
353:
354: IF (l_debug = 'Y') THEN
355: gmd_debug.put_line('l_source ' || l_source);
356: END IF;
357:
358: if (l_source = 'R') or (l_source = 'L') then
359: /* Resource source */

Line 380: gmd_debug.put_line('checking approvers ');

376: --BUG#3676227
377: l_prop_conv_base_recip :=to_number(substr(to_char(1.0 / l_prop_conv_base),1,30));
378:
379: IF (l_debug = 'Y') THEN
380: gmd_debug.put_line('checking approvers ');
381: END IF;
382:
383: /* Start the Workflow for the Given Combination */
384: ame_api.clearAllApprovals(applicationIdIn => l_application_id,

Line 406: gmd_debug.put_line('User Name ' || l_user);

402: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
403: end if;
404:
405: IF (l_debug = 'Y') THEN
406: gmd_debug.put_line('User Name ' || l_user);
407: END IF;
408:
409: /* In the case there is a lot_id, we should send a notification. in the
410: case there is a lot_no with not sublot_no but item is not sublot

Line 417: gmd_debug.put_line('Case where lot defined and not sublot ctrl ');

413: to loop through each of the sublots and send a different notification */
414: if (l_lot_no is not null ) then
415:
416: IF (l_debug = 'Y') THEN
417: gmd_debug.put_line('Case where lot defined and not sublot ctrl ');
418: END IF;
419:
420: /* Need to check if UOM conversion already exists */
421: l_conversion_id := NULL;

Line 584: gmd_debug.put_line('Case where lot not defined ');

580:
581: elsif(l_parent_lot_no is not null) then
582:
583: IF (l_debug = 'Y') THEN
584: gmd_debug.put_line('Case where lot not defined ');
585: END IF;
586: open get_child_lots (l_item_id, l_orgn_id,l_parent_lot_no);
587:
588: loop