DBA Data[Home] [Help]

APPS.GME_RELEASE_BATCH_STEP_PVT dependencies on GME_DEBUG

Line 44: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

40: l_batch_step_rec gme_batch_steps%ROWTYPE;
41: --Bug#5109119
42: l_in_batch_header_rec gme_batch_header%ROWTYPE;
43: BEGIN
44: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
45: gme_debug.g_log_procedure THEN
46: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
47: || l_api_name);
48: gme_debug.put_line ( g_pkg_name

Line 45: gme_debug.g_log_procedure THEN

41: --Bug#5109119
42: l_in_batch_header_rec gme_batch_header%ROWTYPE;
43: BEGIN
44: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
45: gme_debug.g_log_procedure THEN
46: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
47: || l_api_name);
48: gme_debug.put_line ( g_pkg_name
49: || '.'

Line 46: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

42: l_in_batch_header_rec gme_batch_header%ROWTYPE;
43: BEGIN
44: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
45: gme_debug.g_log_procedure THEN
46: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
47: || l_api_name);
48: gme_debug.put_line ( g_pkg_name
49: || '.'
50: || l_api_name

Line 48: gme_debug.put_line ( g_pkg_name

44: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
45: gme_debug.g_log_procedure THEN
46: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
47: || l_api_name);
48: gme_debug.put_line ( g_pkg_name
49: || '.'
50: || l_api_name
51: || ' Releasing batch_step_id='
52: || p_batch_step_rec.batchstep_id);

Line 113: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

109: END IF;
110: END IF;
111:
112:
113: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
114: gme_debug.g_log_procedure THEN
115: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
116: END IF;
117: EXCEPTION

Line 114: gme_debug.g_log_procedure THEN

110: END IF;
111:
112:
113: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
114: gme_debug.g_log_procedure THEN
115: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
116: END IF;
117: EXCEPTION
118: WHEN error_release_batch OR error_release_step_rec THEN

Line 115: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

111:
112:
113: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
114: gme_debug.g_log_procedure THEN
115: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
116: END IF;
117: EXCEPTION
118: WHEN error_release_batch OR error_release_step_rec THEN
119: NULL;

Line 123: IF g_debug <= gme_debug.g_log_procedure THEN

119: NULL;
120: WHEN OTHERS THEN
121: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
122:
123: IF g_debug <= gme_debug.g_log_procedure THEN
124: gme_debug.put_line ( 'Unexpected error: '
125: || g_pkg_name
126: || '.'
127: || l_api_name

Line 124: gme_debug.put_line ( 'Unexpected error: '

120: WHEN OTHERS THEN
121: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
122:
123: IF g_debug <= gme_debug.g_log_procedure THEN
124: gme_debug.put_line ( 'Unexpected error: '
125: || g_pkg_name
126: || '.'
127: || l_api_name
128: || ': '

Line 173: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

169: l_msg_stack VARCHAR2 (2000);
170: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
171: l_batch_step_rec gme_batch_steps%ROWTYPE;
172: BEGIN
173: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
174: gme_debug.g_log_procedure THEN
175: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
176: || l_api_name);
177: gme_debug.put_line (g_pkg_name

Line 174: gme_debug.g_log_procedure THEN

170: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
171: l_batch_step_rec gme_batch_steps%ROWTYPE;
172: BEGIN
173: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
174: gme_debug.g_log_procedure THEN
175: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
176: || l_api_name);
177: gme_debug.put_line (g_pkg_name
178: || '.'

Line 175: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

171: l_batch_step_rec gme_batch_steps%ROWTYPE;
172: BEGIN
173: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
174: gme_debug.g_log_procedure THEN
175: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
176: || l_api_name);
177: gme_debug.put_line (g_pkg_name
178: || '.'
179: || l_api_name

Line 177: gme_debug.put_line (g_pkg_name

173: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
174: gme_debug.g_log_procedure THEN
175: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
176: || l_api_name);
177: gme_debug.put_line (g_pkg_name
178: || '.'
179: || l_api_name
180: || ' Release step recursive batch_step_id='
181: || p_batch_step_rec.batchstep_id);

Line 182: gme_debug.put_line(g_pkg_name

178: || '.'
179: || l_api_name
180: || ' Release step recursive batch_step_id='
181: || p_batch_step_rec.batchstep_id);
182: gme_debug.put_line(g_pkg_name
183: || '.'
184: || l_api_name
185: || ' step actual start date='
186: || to_char(p_batch_step_rec.actual_start_date,'YYYY-MON-DD HH24:MI:SS'));

Line 225: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

221: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
222: x_return_status := gme_common_pvt.g_exceptions_err;
223: END IF;
224:
225: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
226: gme_debug.put_line
227: ('Calling release step line to complete ingredient transactions...');
228: gme_debug.put_line ('for step = ' || x_batch_step_rec.batchstep_id);
229: END IF;

Line 226: gme_debug.put_line

222: x_return_status := gme_common_pvt.g_exceptions_err;
223: END IF;
224:
225: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
226: gme_debug.put_line
227: ('Calling release step line to complete ingredient transactions...');
228: gme_debug.put_line ('for step = ' || x_batch_step_rec.batchstep_id);
229: END IF;
230:

Line 228: gme_debug.put_line ('for step = ' || x_batch_step_rec.batchstep_id);

224:
225: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
226: gme_debug.put_line
227: ('Calling release step line to complete ingredient transactions...');
228: gme_debug.put_line ('for step = ' || x_batch_step_rec.batchstep_id);
229: END IF;
230:
231: release_step_line (p_batch_step_rec => p_batch_step_rec
232: ,x_batch_step_rec => x_batch_step_rec

Line 279: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

275: ,p_event_key => TO_CHAR
276: (x_batch_step_rec.batchstep_id) );
277: END IF;
278:
279: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
280: gme_debug.g_log_procedure THEN
281: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
282: END IF;
283: EXCEPTION

Line 280: gme_debug.g_log_procedure THEN

276: (x_batch_step_rec.batchstep_id) );
277: END IF;
278:
279: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
280: gme_debug.g_log_procedure THEN
281: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
282: END IF;
283: EXCEPTION
284: WHEN error_validation THEN

Line 281: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

277: END IF;
278:
279: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
280: gme_debug.g_log_procedure THEN
281: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
282: END IF;
283: EXCEPTION
284: WHEN error_validation THEN
285: NULL;

Line 293: IF g_debug <= gme_debug.g_log_procedure THEN

289: NULL;
290: WHEN OTHERS THEN
291: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
292:
293: IF g_debug <= gme_debug.g_log_procedure THEN
294: gme_debug.put_line ( 'Unexpected error: '
295: || g_pkg_name
296: || '.'
297: || l_api_name

Line 294: gme_debug.put_line ( 'Unexpected error: '

290: WHEN OTHERS THEN
291: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
292:
293: IF g_debug <= gme_debug.g_log_procedure THEN
294: gme_debug.put_line ( 'Unexpected error: '
295: || g_pkg_name
296: || '.'
297: || l_api_name
298: || ': '

Line 336: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

332: --Bug#5109119
333: error_close_period EXCEPTION;
334: error_future_date EXCEPTION;
335: BEGIN
336: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
337: gme_debug.g_log_procedure THEN
338: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
339: || l_api_name);
340: gme_debug.put_line ( g_pkg_name

Line 337: gme_debug.g_log_procedure THEN

333: error_close_period EXCEPTION;
334: error_future_date EXCEPTION;
335: BEGIN
336: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
337: gme_debug.g_log_procedure THEN
338: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
339: || l_api_name);
340: gme_debug.put_line ( g_pkg_name
341: || '.'

Line 338: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

334: error_future_date EXCEPTION;
335: BEGIN
336: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
337: gme_debug.g_log_procedure THEN
338: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
339: || l_api_name);
340: gme_debug.put_line ( g_pkg_name
341: || '.'
342: || l_api_name

Line 340: gme_debug.put_line ( g_pkg_name

336: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
337: gme_debug.g_log_procedure THEN
338: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
339: || l_api_name);
340: gme_debug.put_line ( g_pkg_name
341: || '.'
342: || l_api_name
343: || ' Processing batch_step_id='
344: || p_batch_step_rec.batchstep_id);

Line 367: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

363:
364: /* Get the immediate dependent steps for the current step */
365: FOR l_dep_step_rec IN cur_get_dep_steps (p_batch_step_rec.batchstep_id
366: ,p_batch_header_rec.batch_id) LOOP
367: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
368: gme_debug.put_line ( g_pkg_name
369: || '.'
370: || l_api_name
371: || 'fetched dep step '

Line 368: gme_debug.put_line ( g_pkg_name

364: /* Get the immediate dependent steps for the current step */
365: FOR l_dep_step_rec IN cur_get_dep_steps (p_batch_step_rec.batchstep_id
366: ,p_batch_header_rec.batch_id) LOOP
367: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
368: gme_debug.put_line ( g_pkg_name
369: || '.'
370: || l_api_name
371: || 'fetched dep step '
372: || l_dep_step_rec.dep_step_id);

Line 373: gme_debug.put_line ( g_pkg_name

369: || '.'
370: || l_api_name
371: || 'fetched dep step '
372: || l_dep_step_rec.dep_step_id);
373: gme_debug.put_line ( g_pkg_name
374: || '.'
375: || l_api_name
376: || 'steprelease_type = '
377: || l_dep_step_rec.steprelease_type);

Line 378: gme_debug.put_line ( g_pkg_name

374: || '.'
375: || l_api_name
376: || 'steprelease_type = '
377: || l_dep_step_rec.steprelease_type);
378: gme_debug.put_line ( g_pkg_name
379: || '.'
380: || l_api_name
381: || 'dep_type = '
382: || l_dep_step_rec.dep_type);

Line 383: gme_debug.put_line ( g_pkg_name

379: || '.'
380: || l_api_name
381: || 'dep_type = '
382: || l_dep_step_rec.dep_type);
383: gme_debug.put_line ( g_pkg_name
384: || '.'
385: || l_api_name
386: || 'standard_delay = '
387: || l_dep_step_rec.standard_delay);

Line 388: gme_debug.put_line ( g_pkg_name

384: || '.'
385: || l_api_name
386: || 'standard_delay = '
387: || l_dep_step_rec.standard_delay);
388: gme_debug.put_line ( g_pkg_name
389: || '.'
390: || l_api_name
391: || 'step_status = '
392: || l_dep_step_rec.step_status);

Line 504: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

500: l_first_step_start_date > p_batch_step_rec.actual_start_date THEN
501: l_first_step_start_date := p_batch_step_rec.actual_start_date;
502: END IF;
503:
504: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
505: gme_debug.g_log_procedure THEN
506: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
507: END IF;
508: EXCEPTION

Line 505: gme_debug.g_log_procedure THEN

501: l_first_step_start_date := p_batch_step_rec.actual_start_date;
502: END IF;
503:
504: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
505: gme_debug.g_log_procedure THEN
506: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
507: END IF;
508: EXCEPTION
509: --Bug#5109119 Begin

Line 506: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

502: END IF;
503:
504: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
505: gme_debug.g_log_procedure THEN
506: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
507: END IF;
508: EXCEPTION
509: --Bug#5109119 Begin
510: WHEN error_close_period THEN

Line 526: IF g_debug <= gme_debug.g_log_procedure THEN

522: NULL;
523: WHEN OTHERS THEN
524: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
525:
526: IF g_debug <= gme_debug.g_log_procedure THEN
527: gme_debug.put_line ( 'Unexpected error: '
528: || g_pkg_name
529: || '.'
530: || l_api_name

Line 527: gme_debug.put_line ( 'Unexpected error: '

523: WHEN OTHERS THEN
524: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
525:
526: IF g_debug <= gme_debug.g_log_procedure THEN
527: gme_debug.put_line ( 'Unexpected error: '
528: || g_pkg_name
529: || '.'
530: || l_api_name
531: || ': '

Line 566: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

562: l_batch_step_rec gme_batch_steps%ROWTYPE;
563: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
564: batch_step_upd_err EXCEPTION;
565: BEGIN
566: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
567: gme_debug.g_log_procedure THEN
568: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
569: || l_api_name);
570: gme_debug.put_line ( g_pkg_name

Line 567: gme_debug.g_log_procedure THEN

563: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
564: batch_step_upd_err EXCEPTION;
565: BEGIN
566: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
567: gme_debug.g_log_procedure THEN
568: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
569: || l_api_name);
570: gme_debug.put_line ( g_pkg_name
571: || '.'

Line 568: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

564: batch_step_upd_err EXCEPTION;
565: BEGIN
566: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
567: gme_debug.g_log_procedure THEN
568: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
569: || l_api_name);
570: gme_debug.put_line ( g_pkg_name
571: || '.'
572: || l_api_name

Line 570: gme_debug.put_line ( g_pkg_name

566: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
567: gme_debug.g_log_procedure THEN
568: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
569: || l_api_name);
570: gme_debug.put_line ( g_pkg_name
571: || '.'
572: || l_api_name
573: || ' Release step line batchstep_id='
574: || p_batch_step_rec.batchstep_id);

Line 612: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

608: ,last_update_date = gme_common_pvt.g_timestamp
609: ,last_update_login = gme_common_pvt.g_login_id
610: WHERE batchstep_id = x_batch_step_rec.batchstep_id;
611:
612: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
613: gme_debug.g_log_procedure THEN
614: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
615: END IF;
616: EXCEPTION

Line 613: gme_debug.g_log_procedure THEN

609: ,last_update_login = gme_common_pvt.g_login_id
610: WHERE batchstep_id = x_batch_step_rec.batchstep_id;
611:
612: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
613: gme_debug.g_log_procedure THEN
614: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
615: END IF;
616: EXCEPTION
617: WHEN batch_step_upd_err THEN

Line 614: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

610: WHERE batchstep_id = x_batch_step_rec.batchstep_id;
611:
612: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
613: gme_debug.g_log_procedure THEN
614: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
615: END IF;
616: EXCEPTION
617: WHEN batch_step_upd_err THEN
618: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'

Line 624: IF g_debug <= gme_debug.g_log_procedure THEN

620: x_return_status := fnd_api.g_ret_sts_unexp_error;
621: WHEN OTHERS THEN
622: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
623:
624: IF g_debug <= gme_debug.g_log_procedure THEN
625: gme_debug.put_line ( 'Unexpected error: '
626: || g_pkg_name
627: || '.'
628: || l_api_name

Line 625: gme_debug.put_line ( 'Unexpected error: '

621: WHEN OTHERS THEN
622: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
623:
624: IF g_debug <= gme_debug.g_log_procedure THEN
625: gme_debug.put_line ( 'Unexpected error: '
626: || g_pkg_name
627: || '.'
628: || l_api_name
629: || ': '

Line 658: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

654: l_matl_dtl_tab gme_common_pvt.material_details_tab;
655: l_consume BOOLEAN;
656: error_process_ing EXCEPTION;
657: BEGIN
658: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
659: gme_debug.g_log_procedure THEN
660: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
661: || l_api_name);
662: gme_debug.put_line ( g_pkg_name

Line 659: gme_debug.g_log_procedure THEN

655: l_consume BOOLEAN;
656: error_process_ing EXCEPTION;
657: BEGIN
658: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
659: gme_debug.g_log_procedure THEN
660: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
661: || l_api_name);
662: gme_debug.put_line ( g_pkg_name
663: || '.'

Line 660: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

656: error_process_ing EXCEPTION;
657: BEGIN
658: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
659: gme_debug.g_log_procedure THEN
660: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
661: || l_api_name);
662: gme_debug.put_line ( g_pkg_name
663: || '.'
664: || l_api_name

Line 662: gme_debug.put_line ( g_pkg_name

658: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
659: gme_debug.g_log_procedure THEN
660: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
661: || l_api_name);
662: gme_debug.put_line ( g_pkg_name
663: || '.'
664: || l_api_name
665: || ' Releasing ingredients for step_id='
666: || p_batch_step_rec.batchstep_id);

Line 703: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

699: x_return_status := gme_common_pvt.g_exceptions_err;
700: END IF;
701: END LOOP;
702:
703: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
704: gme_debug.g_log_procedure THEN
705: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
706: END IF;
707: EXCEPTION

Line 704: gme_debug.g_log_procedure THEN

700: END IF;
701: END LOOP;
702:
703: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
704: gme_debug.g_log_procedure THEN
705: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
706: END IF;
707: EXCEPTION
708: WHEN error_process_ing THEN

Line 705: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

701: END LOOP;
702:
703: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
704: gme_debug.g_log_procedure THEN
705: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
706: END IF;
707: EXCEPTION
708: WHEN error_process_ing THEN
709: NULL;

Line 713: IF g_debug <= gme_debug.g_log_procedure THEN

709: NULL;
710: WHEN OTHERS THEN
711: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
712:
713: IF g_debug <= gme_debug.g_log_procedure THEN
714: gme_debug.put_line ( 'Unexpected error: '
715: || g_pkg_name
716: || '.'
717: || l_api_name

Line 714: gme_debug.put_line ( 'Unexpected error: '

710: WHEN OTHERS THEN
711: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
712:
713: IF g_debug <= gme_debug.g_log_procedure THEN
714: gme_debug.put_line ( 'Unexpected error: '
715: || g_pkg_name
716: || '.'
717: || l_api_name
718: || ': '

Line 754: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

750: --Bug#5109119
751: error_close_period EXCEPTION;
752: error_vr_dates EXCEPTION;
753: BEGIN
754: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
755: gme_debug.g_log_procedure THEN
756: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
757: || l_api_name);
758: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' batchstep_id = '||p_batch_step_rec.batchstep_id);

Line 755: gme_debug.g_log_procedure THEN

751: error_close_period EXCEPTION;
752: error_vr_dates EXCEPTION;
753: BEGIN
754: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
755: gme_debug.g_log_procedure THEN
756: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
757: || l_api_name);
758: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' batchstep_id = '||p_batch_step_rec.batchstep_id);
759: END IF;

Line 756: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

752: error_vr_dates EXCEPTION;
753: BEGIN
754: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
755: gme_debug.g_log_procedure THEN
756: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
757: || l_api_name);
758: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' batchstep_id = '||p_batch_step_rec.batchstep_id);
759: END IF;
760:

Line 758: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' batchstep_id = '||p_batch_step_rec.batchstep_id);

754: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
755: gme_debug.g_log_procedure THEN
756: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
757: || l_api_name);
758: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' batchstep_id = '||p_batch_step_rec.batchstep_id);
759: END IF;
760:
761: x_return_status := fnd_api.g_ret_sts_success;
762:

Line 824: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

820: ,p_trans_date => x_batch_step_rec.actual_start_date) THEN
821: RAISE error_close_period;
822: END IF;
823:
824: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
825: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'actual_cmplt_date='||to_char(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
826: END IF;
827:
828: -- Enforce Step Dependency Checks

Line 825: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'actual_cmplt_date='||to_char(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));

821: RAISE error_close_period;
822: END IF;
823:
824: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
825: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'actual_cmplt_date='||to_char(x_batch_step_rec.actual_cmplt_date,'DD-MON-YYYY HH24:MI:SS'));
826: END IF;
827:
828: -- Enforce Step Dependency Checks
829: IF p_batch_header_rec.enforce_step_dependency = 1 THEN

Line 853: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

849: IF x_return_status <> fnd_api.g_ret_sts_success THEN
850: RAISE error_validation;
851: END IF;
852:
853: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
854: gme_debug.g_log_procedure THEN
855: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
856: END IF;
857:

Line 854: gme_debug.g_log_procedure THEN

850: RAISE error_validation;
851: END IF;
852:
853: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
854: gme_debug.g_log_procedure THEN
855: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
856: END IF;
857:
858: EXCEPTION

Line 855: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

851: END IF;
852:
853: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
854: gme_debug.g_log_procedure THEN
855: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
856: END IF;
857:
858: EXCEPTION
859: --Bug#5109119

Line 876: IF g_debug <= gme_debug.g_log_procedure THEN

872: x_return_status := FND_API.G_RET_STS_ERROR;
873: WHEN OTHERS THEN
874: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
875:
876: IF g_debug <= gme_debug.g_log_procedure THEN
877: gme_debug.put_line ( 'Unexpected error: '
878: || g_pkg_name
879: || '.'
880: || l_api_name

Line 877: gme_debug.put_line ( 'Unexpected error: '

873: WHEN OTHERS THEN
874: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
875:
876: IF g_debug <= gme_debug.g_log_procedure THEN
877: gme_debug.put_line ( 'Unexpected error: '
878: || g_pkg_name
879: || '.'
880: || l_api_name
881: || ': '