DBA Data[Home] [Help]

APPS.GMD_OPERATION_ACTIVITIES_PVT dependencies on GMD_DEBUG

Line 71: gmd_debug.put_line('In insert_operation_activity private.');

67: l_retn_status VARCHAR2(30);
68:
69: BEGIN
70: IF (l_debug = 'Y') THEN
71: gmd_debug.put_line('In insert_operation_activity private.');
72: END IF;
73:
74: /* Initially let us assign the return status to success */
75: x_return_status := FND_API.g_ret_sts_success;

Line 87: gmd_debug.put_line('Begin Loop - in insert_operation_activity loop (private). '||

83: END IF;
84:
85: /* insert operation activities */
86: IF (l_debug = 'Y') THEN
87: gmd_debug.put_line('Begin Loop - in insert_operation_activity loop (private). '||
88: ' Curr Activity is ' || p_oprn_activity.activity);
89: END IF;
90:
91: insert into GMD_OPERATION_ACTIVITIES (

Line 187: gmd_debug.put_line('End insert_operation_activity private');

183: gmd_api_grp.user_id,
184: gmd_api_grp.user_id);
185:
186: IF (l_debug = 'Y') THEN
187: gmd_debug.put_line('End insert_operation_activity private');
188: END IF;
189:
190: EXCEPTION
191: WHEN setup_failure THEN

Line 227: gmd_debug.put_line(' In update_operation_activity private');

223: l_errmsg VARCHAR2(240);
224: setup_failure EXCEPTION;
225: BEGIN
226: IF (l_debug = 'Y') THEN
227: gmd_debug.put_line(' In update_operation_activity private');
228: END IF;
229:
230: /* Initially let us assign the return status to success */
231: x_return_status := FND_API.g_ret_sts_success;

Line 239: gmd_debug.put_line('Begin Loop - in update_operation_activity loop (private). '||

235: CLOSE retrieve_oprn_actv;
236:
237: FOR i IN 1 .. p_update_table.count LOOP
238: IF (l_debug = 'Y') THEN
239: gmd_debug.put_line('Begin Loop - in update_operation_activity loop (private). '||
240: 'Col to update is ' || p_update_table(i).p_col_to_update);
241: END IF;
242:
243: IF UPPER(p_update_table(i).p_col_to_update) = 'OFFSET_INTERVAL' THEN

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

321: END IF;
322:
323:
324: IF (l_debug = 'Y') THEN
325: gmd_debug.put_line('Update_operation_activity private - after set cols for activities tbl. Col to update is ' || p_update_table(i).p_col_to_update);
326: END IF;
327:
328: END LOOP;
329:

Line 340: gmd_debug.put_line('before update table - update_operation_activity private');

336: RAISE setup_failure;
337: END IF;
338:
339: IF (l_debug = 'Y') THEN
340: gmd_debug.put_line('before update table - update_operation_activity private');
341: END IF;
342:
343: update GMD_OPERATION_ACTIVITIES
344: set ACTIVITY = v_oprn_actv_update_rec.activity,

Line 390: gmd_debug.put_line('END of update_operation_activity private');

386: where oprn_line_id = p_oprn_line_id;
387: END IF;
388:
389: IF (l_debug = 'Y') THEN
390: gmd_debug.put_line('END of update_operation_activity private');
391: END IF;
392:
393: EXCEPTION
394: WHEN setup_failure THEN

Line 433: gmd_debug.put_line('END of delete_operation_activity PVT');

429: DELETE from GMD_OPERATION_RESOURCES
430: WHERE oprn_line_id = p_oprn_line_id;
431:
432: IF (l_debug = 'Y') THEN
433: gmd_debug.put_line('END of delete_operation_activity PVT');
434: END IF;
435:
436:
437: EXCEPTION