DBA Data[Home] [Help]

APPS.GMD_OPERATIONS_PVT dependencies on GMD_DEBUG

Line 57: gmd_debug.put_line(' In insert_operation private');

53: l_rowid VARCHAR2(30);
54: setup_failure EXCEPTION;
55: BEGIN
56: IF (l_debug = 'Y') THEN
57: gmd_debug.put_line(' In insert_operation private');
58: END IF;
59:
60: /* Initially let us assign the return status to success */
61: x_return_status := FND_API.g_ret_sts_success;

Line 125: gmd_debug.put_line('END of Insert_operation private');

121: X_LAST_UPDATED_BY => gmd_api_grp.user_id,
122: X_LAST_UPDATE_LOGIN => gmd_api_grp.login_id);
123:
124: IF (l_debug = 'Y') THEN
125: gmd_debug.put_line('END of Insert_operation private');
126: END IF;
127:
128: EXCEPTION
129: WHEN setup_failure THEN

Line 184: gmd_debug.put_line(' In update_operation private');

180: AND r.delete_mark = 0;
181:
182: BEGIN
183: IF (l_debug = 'Y') THEN
184: gmd_debug.put_line(' In update_operation private');
185: END IF;
186:
187: /* Initially let us assign the return status to success */
188: x_return_status := FND_API.g_ret_sts_success;

Line 217: gmd_debug.put_line('The eff_start_date for operation prior to update = '||

213: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'OPRN_DESC' THEN
214: v_update_rec.oprn_desc := p_update_table(i).p_value;
215: ELSIF UPPER(p_update_table(i).p_col_to_update) like '%START_DATE%' THEN
216: IF (l_debug = 'Y') THEN
217: gmd_debug.put_line('The eff_start_date for operation prior to update = '||
218: p_update_table(i).p_value);
219: END IF;
220: v_update_rec.effective_start_date
221: := FND_DATE.canonical_to_date(p_update_table(i).p_value);

Line 224: gmd_debug.put_line('The eff_end_date for operation prior to update = '||

220: v_update_rec.effective_start_date
221: := FND_DATE.canonical_to_date(p_update_table(i).p_value);
222: ELSIF UPPER(p_update_table(i).p_col_to_update) like '%END_DATE%' THEN
223: IF (l_debug = 'Y') THEN
224: gmd_debug.put_line('The eff_end_date for operation prior to update = '||
225: p_update_table(i).p_value) ;
226: END IF;
227: v_update_rec.effective_end_date
228: := FND_DATE.canonical_to_date(p_update_table(i).p_value);

Line 299: gmd_debug.put_line('The oprn id = '||v_update_rec.oprn_id);

295: END IF;
296:
297: -- Compare Oprn start dtae with Routing Start Dtae
298: If (l_debug = 'Y') THEN
299: gmd_debug.put_line('The oprn id = '||v_update_rec.oprn_id);
300: END IF;
301:
302: IF UPPER(p_update_table(i).p_col_to_update) like '%START_DATE%' THEN
303: OPEN get_rt_start_end_dates(v_update_rec.oprn_id);

Line 312: gmd_debug.put_line('In OPeration Pvt - Comparing OPrn start date '||

308: END IF;
309:
310: IF l_rt_start_date IS NOT NULL THEN
311: IF (l_debug = 'Y') THEN
312: gmd_debug.put_line('In OPeration Pvt - Comparing OPrn start date '||
313: ' with routing start date '||
314: 'Operation start and Rout Start date = '||
315: v_update_rec.effective_start_date||' - '||l_rt_start_date);
316:

Line 342: gmd_debug.put_line('In OPeration Pvt - Comparing Oprn end date '||

338: END IF;
339:
340: IF l_rt_start_date IS NOT NULL THEN
341: IF (l_debug = 'Y') THEN
342: gmd_debug.put_line('In OPeration Pvt - Comparing Oprn end date '||
343: ' with routing end date '||
344: 'Oprn end date and Rout end date = '||
345: v_update_rec.effective_end_date||' - '||l_rt_end_date);
346:

Line 372: gmd_debug.put_line('effective start date must be less then end date');

368: IF v_update_rec.effective_end_date IS NOT NULL THEN
369: /* Effective end date must be greater than start date, otherwise give error */
370: IF v_update_rec.effective_start_date > v_update_rec.effective_end_date THEN
371: IF (l_debug = 'Y') THEN
372: gmd_debug.put_line('effective start date must be less then end date');
373: END IF;
374: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');
375: FND_MSG_PUB.ADD;
376: RAISE inv_operation;