DBA Data[Home] [Help]

APPS.GMD_OPERATION_RESOURCES_PVT dependencies on GMD_DEBUG

Line 77: gmd_debug.put_line('In insert_operation_resources public.');

73: l_activity gmd_activities.activity%TYPE;
74:
75: BEGIN
76: IF (l_debug = 'Y') THEN
77: gmd_debug.put_line('In insert_operation_resources public.');
78: END IF;
79:
80: /* Initially let us assign the return status to success */
81: x_return_status := FND_API.g_ret_sts_success;

Line 216: gmd_debug.put_line('End insert oprn rsrc loop - insert_operation_rsrc private');

212: gmd_api_grp.user_id,
213: gmd_api_grp.user_id);
214: END LOOP;
215: IF (l_debug = 'Y') THEN
216: gmd_debug.put_line('End insert oprn rsrc loop - insert_operation_rsrc private');
217: END IF;
218:
219: EXCEPTION
220: WHEN FND_API.G_EXC_ERROR THEN

Line 268: gmd_debug.put_line('Start of update_operation_rsrc PVT');

264: x_return_status := FND_API.g_ret_sts_success;
265:
266: IF (l_debug = 'Y') THEN
267:
268: gmd_debug.put_line('Start of update_operation_rsrc PVT');
269: END IF;
270:
271: OPEN get_resource_info(p_oprn_line_id, p_resources);
272: FETCH get_resource_info INTO v_oprn_rsrc_update_rec;

Line 278: gmd_debug.put_line('Begin Loop - in update_operation_rsrc loop (private). Col to update is ' || p_update_table(i).p_col_to_update);

274:
275: FOR i IN 1 .. p_update_table.count LOOP
276: IF (l_debug = 'Y') THEN
277:
278: gmd_debug.put_line('Begin Loop - in update_operation_rsrc loop (private). Col to update is ' || p_update_table(i).p_col_to_update);
279: END IF;
280:
281: IF UPPER(p_update_table(i).p_col_to_update) = 'RESOURCE_USAGE' THEN
282: v_oprn_rsrc_update_rec.resource_usage := p_update_table(i).p_value;

Line 367: gmd_debug.put_line('Update_operation_rsrc private - after set cols for rsrc tbl. Col to update is ' || p_update_table(i).p_col_to_update);

363: END IF;
364:
365: IF (l_debug = 'Y') THEN
366:
367: gmd_debug.put_line('Update_operation_rsrc private - after set cols for rsrc tbl. Col to update is ' || p_update_table(i).p_col_to_update);
368: END IF;
369:
370: END LOOP;
371:

Line 385: gmd_debug.put_line('before update table - update_operation_rsrc private');

381: END IF;
382:
383: IF (l_debug = 'Y') THEN
384:
385: gmd_debug.put_line('before update table - update_operation_rsrc private');
386: END IF;
387:
388: update GMD_OPERATION_RESOURCES
389: set RESOURCE_USAGE = v_oprn_rsrc_update_rec.resource_usage,

Line 442: gmd_debug.put_line('END of update_operation_resource PVT');

438:
439:
440: IF (l_debug = 'Y') THEN
441:
442: gmd_debug.put_line('END of update_operation_resource PVT');
443: END IF;
444:
445: EXCEPTION
446: WHEN setup_failure THEN

Line 492: gmd_debug.put_line('START of delete_operation_resources PVT');

488: RAISE setup_failure;
489: END IF;
490:
491: IF (l_debug = 'Y') THEN
492: gmd_debug.put_line('START of delete_operation_resources PVT');
493: END IF;
494:
495: DELETE from GMD_OPERATION_RESOURCES
496: WHERE oprn_line_id = p_oprn_line_id

Line 501: gmd_debug.put_line('END of delete_operation_resources PVT');

497: and resources = p_resources;
498:
499: IF (l_debug = 'Y') THEN
500:
501: gmd_debug.put_line('END of delete_operation_resources PVT');
502: END IF;
503:
504: EXCEPTION
505: WHEN setup_failure THEN