APPS.GMDQSVRS_APPROVAL_WF_PKG dependencies on GMD_DEBUG

Line 343: gmd_debug.log_initialize('SpecVRApp');

339: begin
340:
341:
342: IF (l_debug = 'Y') THEN
343: gmd_debug.log_initialize('SpecVRApp');
344: gmd_debug.put_line('Spec VR Id ' || lSpecVRId );
345: gmd_debug.put_line('Start Status ' || lStartStatus);
346: gmd_debug.put_line('Target Status ' || lTargetStatus);
347: END IF;

Line 344: gmd_debug.put_line('Spec VR Id ' || lSpecVRId );

340:
341:
342: IF (l_debug = 'Y') THEN
343: gmd_debug.log_initialize('SpecVRApp');
344: gmd_debug.put_line('Spec VR Id ' || lSpecVRId );
345: gmd_debug.put_line('Start Status ' || lStartStatus);
346: gmd_debug.put_line('Target Status ' || lTargetStatus);
347: END IF;
348:

Line 345: gmd_debug.put_line('Start Status ' || lStartStatus);

341:
342: IF (l_debug = 'Y') THEN
343: gmd_debug.log_initialize('SpecVRApp');
344: gmd_debug.put_line('Spec VR Id ' || lSpecVRId );
345: gmd_debug.put_line('Start Status ' || lStartStatus);
346: gmd_debug.put_line('Target Status ' || lTargetStatus);
347: END IF;
348:
349: open get_from_role ;

Line 346: gmd_debug.put_line('Target Status ' || lTargetStatus);

342: IF (l_debug = 'Y') THEN
343: gmd_debug.log_initialize('SpecVRApp');
344: gmd_debug.put_line('Spec VR Id ' || lSpecVRId );
345: gmd_debug.put_line('Start Status ' || lStartStatus);
346: gmd_debug.put_line('Target Status ' || lTargetStatus);
347: END IF;
348:
349: open get_from_role ;
350: fetch get_from_role into l_from_role ;

Line 373: gmd_debug.put_line('Getting approver ');

369: -- Get the next approver who need to approve the trasaction
370: --
371:
372: IF (l_debug = 'Y') THEN
373: gmd_debug.put_line('Getting approver ');
374: END IF;
375:
376: ame_api.getNextApprover(applicationIdIn => applicationId,
377: transactionIdIn => lSpecVRId,

Line 385: gmd_debug.put_line('No approver required');

381: IF nextApprover.user_id IS NULL and nextApprover.person_id IS NULL
382: THEN
383:
384: IF (l_debug = 'Y') THEN
385: gmd_debug.put_line('No approver required');
386: END IF;
387:
388: --
389: -- Means either no AME rule is matching for this transaction ID or Approver list is empty.

Line 413: gmd_debug.put_line('Approver required');

409: -- We got the first approver from AME
410: --
411:
412: IF (l_debug = 'Y') THEN
413: gmd_debug.put_line('Approver required');
414: END IF;
415:
416: IF nextApprover.person_id IS NOT NULL THEN
417: --

Line 444: gmd_debug.put_line('Spec Type ' || l_spec_type);

440: -- Get attributes Required for display
441:
442:
443: IF (l_debug = 'Y') THEN
444: gmd_debug.put_line('Spec Type ' || l_spec_type);
445: END IF;
446:
447:
448: /*==============================================

Line 533: gmd_debug.put_line('Setting workflow attributes');

529: lStartStatus_DESC := GMDQSPEC_APPROVAL_WF_PKG.GET_STATUS_MEANING(lStartStatus,'S');
530: lTargetStatus_DESC:= GMDQSPEC_APPROVAL_WF_PKG.GET_STATUS_MEANING(lTargetStatus,'S');
531:
532: IF (l_debug = 'Y') THEN
533: gmd_debug.put_line('Setting workflow attributes');
534: END IF;
535:
536: /* Depending on whether the Spec VR is for an item or monitor, fill out the
537: tokenized message and set it in the workflow */

Line 668: gmd_debug.put_line('Finished workflow attributes');

664: avalue => 1);
665: p_resultout := 'COMPLETE:Y';
666:
667: IF (l_debug = 'Y') THEN
668: gmd_debug.put_line('Finished workflow attributes');
669: END IF;
670:
671: ELSE
672: WF_CORE.CONTEXT ('GMDQSPEC_APPROVAL_WF_PKG','is_approval_req',p_itemtype,p_itemkey,api_err_mesg );

Line 765: gmd_debug.put_line('No more approvers required');

761: -- change status of the object to target status
762: --
763:
764: IF (l_debug = 'Y') THEN
765: gmd_debug.put_line('No more approvers required');
766: END IF;
767:
768: GMD_SPEC_GRP.change_status( p_table_name => l_TABLE_NAME
769: , p_id => lSpecVRId

Line 783: gmd_debug.put_line('There is still more approvers required');

779: p_resultout := 'COMPLETE:N';
780: ELSE
781:
782: IF (l_debug = 'Y') THEN
783: gmd_debug.put_line('There is still more approvers required');
784: END IF;
785:
786:
787: IF nextApprover.person_id IS NOT NULL THEN