DBA Data[Home] [Help]

APPS.GMDQSPEC_APPROVAL_WF_PKG dependencies on GMD_DEBUG

Line 174: gmd_debug.log_initialize('Specapproval');

170: begin
171:
172:
173: IF (l_debug = 'Y') THEN
174: gmd_debug.log_initialize('Specapproval');
175: gmd_debug.put_line('Spec ID ' || lSpecId);
176: gmd_debug.put_line('Start ' || lStartStatus);
177: gmd_debug.put_line('End ' || lTargetStatus);
178: END IF;

Line 175: gmd_debug.put_line('Spec ID ' || lSpecId);

171:
172:
173: IF (l_debug = 'Y') THEN
174: gmd_debug.log_initialize('Specapproval');
175: gmd_debug.put_line('Spec ID ' || lSpecId);
176: gmd_debug.put_line('Start ' || lStartStatus);
177: gmd_debug.put_line('End ' || lTargetStatus);
178: END IF;
179:

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

172:
173: IF (l_debug = 'Y') THEN
174: gmd_debug.log_initialize('Specapproval');
175: gmd_debug.put_line('Spec ID ' || lSpecId);
176: gmd_debug.put_line('Start ' || lStartStatus);
177: gmd_debug.put_line('End ' || lTargetStatus);
178: END IF;
179:
180: open get_from_role ;

Line 177: gmd_debug.put_line('End ' || lTargetStatus);

173: IF (l_debug = 'Y') THEN
174: gmd_debug.log_initialize('Specapproval');
175: gmd_debug.put_line('Spec ID ' || lSpecId);
176: gmd_debug.put_line('Start ' || lStartStatus);
177: gmd_debug.put_line('End ' || lTargetStatus);
178: END IF;
179:
180: open get_from_role ;
181: fetch get_from_role into l_from_role ;

Line 221: gmd_debug.put_line('No approvers ');

217: raise APPLICATION_ERROR;
218: END IF;
219:
220: IF (l_debug = 'Y') THEN
221: gmd_debug.put_line('No approvers ');
222: END IF;
223:
224: p_resultout := 'COMPLETE:N';
225:

Line 247: gmd_debug.put_line('Requesting approvers');

243: -- Update status to pending
244: --
245:
246: IF (l_debug = 'Y') THEN
247: gmd_debug.put_line('Requesting approvers');
248: gmd_debug.put_line('Final Status ' || lTargetStatus);
249: END IF;
250:
251: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_SPECIFICATIONS_B'

Line 248: gmd_debug.put_line('Final Status ' || lTargetStatus);

244: --
245:
246: IF (l_debug = 'Y') THEN
247: gmd_debug.put_line('Requesting approvers');
248: gmd_debug.put_line('Final Status ' || lTargetStatus);
249: END IF;
250:
251: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_SPECIFICATIONS_B'
252: , p_id => lSpecId

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

265: raise APPLICATION_ERROR;
266: END IF;
267:
268: IF (l_debug = 'Y') THEN
269: gmd_debug.put_line('Setting up workflow attributes');
270: END IF;
271:
272: l_requester := GET_FND_USER_NAME(disp_attr_rec.LAST_UPDATED_BY);
273: l_owner := GET_FND_USER_NAME(disp_attr_rec.OWNER_ID);

Line 480: gmd_debug.put_line('Finished approvers; changing status');

476: -- change status of the object to target status
477: --
478:
479: IF (l_debug = 'Y') THEN
480: gmd_debug.put_line('Finished approvers; changing status');
481: gmd_debug.put_line('Final Status ' || lTargetStatus);
482: END IF;
483:
484: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_SPECIFICATIONS_B'

Line 481: gmd_debug.put_line('Final Status ' || lTargetStatus);

477: --
478:
479: IF (l_debug = 'Y') THEN
480: gmd_debug.put_line('Finished approvers; changing status');
481: gmd_debug.put_line('Final Status ' || lTargetStatus);
482: END IF;
483:
484: GMD_SPEC_GRP.change_status( p_table_name => 'GMD_SPECIFICATIONS_B'
485: , p_id => lSpecId