DBA Data[Home] [Help]

APPS.GMD_ACTIVITIES_PVT dependencies on GMD_DEBUG

Line 64: gmd_debug.put_line(' In insert_activity private');

60: setup_failure EXCEPTION;
61: duplicate_activity EXCEPTION;
62: BEGIN
63: IF (l_debug = 'Y') THEN
64: gmd_debug.put_line(' In insert_activity private');
65: END IF;
66:
67: /* Initially let us assign the return status to success */
68: x_return_status := FND_API.g_ret_sts_success;

Line 79: gmd_debug.put_line('Begin Loop - in insert_activity loop (private). Curr Activity is ' || p_activity_tbl(i).activity);

75: END IF;
76:
77: FOR i IN 1 .. p_activity_tbl.count LOOP
78: IF (l_debug = 'Y') THEN
79: gmd_debug.put_line('Begin Loop - in insert_activity loop (private). Curr Activity is ' || p_activity_tbl(i).activity);
80: END IF;
81:
82: /* Check for duplicate activity */
83: OPEN Cur_check_activity(p_activity_tbl(i).activity);

Line 87: gmd_debug.put_line('duplicate activity');

83: OPEN Cur_check_activity(p_activity_tbl(i).activity);
84: FETCH Cur_check_activity INTO l_exist;
85: IF (Cur_check_activity%FOUND) THEN
86: IF (l_debug = 'Y') THEN
87: gmd_debug.put_line('duplicate activity');
88: END IF;
89: gmd_api_grp.log_message ('GMD_DUPLICATE_ACTIVITY', 'ACTIVITY',p_activity_tbl(i).activity);
90: CLOSE Cur_check_activity;
91: RAISE duplicate_activity;

Line 109: gmd_debug.put_line('End Loop - insert_activity private');

105: X_LAST_UPDATE_DATE => sysdate,
106: X_LAST_UPDATED_BY => gmd_api_grp.user_id,
107: X_LAST_UPDATE_LOGIN => gmd_api_grp.user_id);
108: IF (l_debug = 'Y') THEN
109: gmd_debug.put_line('End Loop - insert_activity private');
110: END IF;
111: END LOOP;
112:
113: IF (l_debug = 'Y') THEN

Line 114: gmd_debug.put_line('END of Insert_activity private');

110: END IF;
111: END LOOP;
112:
113: IF (l_debug = 'Y') THEN
114: gmd_debug.put_line('END of Insert_activity private');
115: END IF;
116:
117: EXCEPTION
118: WHEN setup_failure OR duplicate_activity THEN

Line 163: gmd_debug.put_line(' In update_activity private');

159:
160:
161: BEGIN
162: IF (l_debug = 'Y') THEN
163: gmd_debug.put_line(' In update_activity private');
164: END IF;
165:
166: /* Initially let us assign the return status to success */
167: x_return_status := FND_API.g_ret_sts_success;

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

183: CLOSE retrieve_activity_table_values;
184:
185: FOR i IN 1 .. p_update_table.count LOOP
186: IF (l_debug = 'Y') THEN
187: gmd_debug.put_line('Begin Loop - in update_activity loop (private). Col to update is ' || p_update_table(i).p_col_to_update);
188: END IF;
189: IF UPPER(p_update_table(i).p_col_to_update) = 'COST_ANALYSIS_CODE' THEN
190: v_update_rec.cost_analysis_code := p_update_table(i).p_value;
191: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'DELETE_MARK' THEN

Line 214: gmd_debug.put_line('END of update_activity private');

210: ,X_LAST_UPDATED_BY => gmd_api_grp.user_id
211: ,X_LAST_UPDATE_LOGIN => gmd_api_grp.login_id);
212:
213: IF (l_debug = 'Y') THEN
214: gmd_debug.put_line('END of update_activity private');
215: END IF;
216:
217: EXCEPTION
218: WHEN setup_failure OR inv_activity_err THEN