APPS.GME_RESOURCE_ENGINE_PVT dependencies on GME_DEBUG

Line 90: IF g_debug <= gme_debug.g_log_procedure THEN

86: l_line_index BINARY_INTEGER := 1;
87: l_cursor BINARY_INTEGER;
88: l_debug VARCHAR2 (2000);
89: BEGIN
90: IF g_debug <= gme_debug.g_log_procedure THEN
91: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
92: || l_api_name);
93: END IF;
94:

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

87: l_cursor BINARY_INTEGER;
88: l_debug VARCHAR2 (2000);
89: BEGIN
90: IF g_debug <= gme_debug.g_log_procedure THEN
91: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
92: || l_api_name);
93: END IF;
94:
95: /* Initialize API return status to sucess */

Line 141: IF g_debug <= gme_debug.g_log_procedure THEN

137: END LOOP;
138:
139: CLOSE get_rsrc;
140:
141: IF g_debug <= gme_debug.g_log_procedure THEN
142: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
143: END IF;
144: EXCEPTION
145: WHEN fnd_api.g_exc_error THEN

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

138:
139: CLOSE get_rsrc;
140:
141: IF g_debug <= gme_debug.g_log_procedure THEN
142: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
143: END IF;
144: EXCEPTION
145: WHEN fnd_api.g_exc_error THEN
146: x_return_status := fnd_api.g_ret_sts_error;

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

146: x_return_status := fnd_api.g_ret_sts_error;
147: WHEN fnd_api.g_exc_unexpected_error THEN
148: x_return_status := fnd_api.g_ret_sts_unexp_error;
149:
150: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
151: gme_debug.put_line ('IN UN ' || SQLERRM);
152: END IF;
153: WHEN OTHERS THEN
154: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 151: gme_debug.put_line ('IN UN ' || SQLERRM);

147: WHEN fnd_api.g_exc_unexpected_error THEN
148: x_return_status := fnd_api.g_ret_sts_unexp_error;
149:
150: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
151: gme_debug.put_line ('IN UN ' || SQLERRM);
152: END IF;
153: WHEN OTHERS THEN
154: IF g_debug <= gme_debug.g_log_unexpected THEN
155: gme_debug.put_line ( 'When others exception in '

Line 154: IF g_debug <= gme_debug.g_log_unexpected THEN

150: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
151: gme_debug.put_line ('IN UN ' || SQLERRM);
152: END IF;
153: WHEN OTHERS THEN
154: IF g_debug <= gme_debug.g_log_unexpected THEN
155: gme_debug.put_line ( 'When others exception in '
156: || g_pkg_name
157: || '.'
158: || l_api_name

Line 155: gme_debug.put_line ( 'When others exception in '

151: gme_debug.put_line ('IN UN ' || SQLERRM);
152: END IF;
153: WHEN OTHERS THEN
154: IF g_debug <= gme_debug.g_log_unexpected THEN
155: gme_debug.put_line ( 'When others exception in '
156: || g_pkg_name
157: || '.'
158: || l_api_name
159: || ' Error is '

Line 189: IF g_debug <= gme_debug.g_log_procedure THEN

185: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_RESOURCE_TRANS';
186: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
187: l_gme_tran_rec gme_resource_txns_gtmp%ROWTYPE;
188: BEGIN
189: IF g_debug <= gme_debug.g_log_procedure THEN
190: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
191: || l_api_name);
192: END IF;
193:

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

186: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
187: l_gme_tran_rec gme_resource_txns_gtmp%ROWTYPE;
188: BEGIN
189: IF g_debug <= gme_debug.g_log_procedure THEN
190: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
191: || l_api_name);
192: END IF;
193:
194: l_gme_tran_rec := p_tran_rec;

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

193:
194: l_gme_tran_rec := p_tran_rec;
195:
196: /* Now Call the INSERT rec DML Layer */
197: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
198: gme_debug.put_line ('Calling Insert Resource TXNS rec');
199: gme_debug.put_line ('Resources +> ' || p_tran_rec.resources);
200: END IF;
201:

Line 198: gme_debug.put_line ('Calling Insert Resource TXNS rec');

194: l_gme_tran_rec := p_tran_rec;
195:
196: /* Now Call the INSERT rec DML Layer */
197: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
198: gme_debug.put_line ('Calling Insert Resource TXNS rec');
199: gme_debug.put_line ('Resources +> ' || p_tran_rec.resources);
200: END IF;
201:
202: l_gme_tran_rec.action_code := 'ADD';

Line 199: gme_debug.put_line ('Resources +> ' || p_tran_rec.resources);

195:
196: /* Now Call the INSERT rec DML Layer */
197: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
198: gme_debug.put_line ('Calling Insert Resource TXNS rec');
199: gme_debug.put_line ('Resources +> ' || p_tran_rec.resources);
200: END IF;
201:
202: l_gme_tran_rec.action_code := 'ADD';
203:

Line 212: IF g_debug <= gme_debug.g_log_procedure THEN

208: END IF;
209:
210: x_return_status := l_return_status;
211:
212: IF g_debug <= gme_debug.g_log_procedure THEN
213: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
214: END IF;
215: EXCEPTION
216: WHEN fnd_api.g_exc_error THEN

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

209:
210: x_return_status := l_return_status;
211:
212: IF g_debug <= gme_debug.g_log_procedure THEN
213: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
214: END IF;
215: EXCEPTION
216: WHEN fnd_api.g_exc_error THEN
217: x_return_status := fnd_api.g_ret_sts_error;

Line 221: IF g_debug <= gme_debug.g_log_unexpected THEN

217: x_return_status := fnd_api.g_ret_sts_error;
218: WHEN fnd_api.g_exc_unexpected_error THEN
219: x_return_status := fnd_api.g_ret_sts_unexp_error;
220: WHEN OTHERS THEN
221: IF g_debug <= gme_debug.g_log_unexpected THEN
222: gme_debug.put_line ( 'When others exception in '
223: || g_pkg_name
224: || '.'
225: || l_api_name

Line 222: gme_debug.put_line ( 'When others exception in '

218: WHEN fnd_api.g_exc_unexpected_error THEN
219: x_return_status := fnd_api.g_ret_sts_unexp_error;
220: WHEN OTHERS THEN
221: IF g_debug <= gme_debug.g_log_unexpected THEN
222: gme_debug.put_line ( 'When others exception in '
223: || g_pkg_name
224: || '.'
225: || l_api_name
226: || ' Error is '

Line 254: IF g_debug <= gme_debug.g_log_procedure THEN

250: l_gme_tran_rec gme_resource_txns_gtmp%ROWTYPE;
251: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_RESOURCE_TRANS';
252: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
253: BEGIN
254: IF g_debug <= gme_debug.g_log_procedure THEN
255: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
256: || l_api_name);
257: END IF;
258:

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

251: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_RESOURCE_TRANS';
252: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
253: BEGIN
254: IF g_debug <= gme_debug.g_log_procedure THEN
255: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
256: || l_api_name);
257: END IF;
258:
259: l_gme_tran_rec := p_tran_rec;

Line 275: IF g_debug <= gme_debug.g_log_procedure THEN

271: END IF;
272:
273: x_return_status := l_return_status;
274:
275: IF g_debug <= gme_debug.g_log_procedure THEN
276: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
277: END IF;
278: EXCEPTION
279: WHEN fnd_api.g_exc_error THEN

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

272:
273: x_return_status := l_return_status;
274:
275: IF g_debug <= gme_debug.g_log_procedure THEN
276: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
277: END IF;
278: EXCEPTION
279: WHEN fnd_api.g_exc_error THEN
280: x_return_status := fnd_api.g_ret_sts_error;

Line 284: IF g_debug <= gme_debug.g_log_unexpected THEN

280: x_return_status := fnd_api.g_ret_sts_error;
281: WHEN fnd_api.g_exc_unexpected_error THEN
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: WHEN OTHERS THEN
284: IF g_debug <= gme_debug.g_log_unexpected THEN
285: gme_debug.put_line ( 'When others exception in '
286: || g_pkg_name
287: || '.'
288: || l_api_name

Line 285: gme_debug.put_line ( 'When others exception in '

281: WHEN fnd_api.g_exc_unexpected_error THEN
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: WHEN OTHERS THEN
284: IF g_debug <= gme_debug.g_log_unexpected THEN
285: gme_debug.put_line ( 'When others exception in '
286: || g_pkg_name
287: || '.'
288: || l_api_name
289: || ' Error is '

Line 317: IF g_debug <= gme_debug.g_log_procedure THEN

313: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_RESOURCE_TRANS';
314: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
315: l_gme_tran_rec gme_resource_txns_gtmp%ROWTYPE;
316: BEGIN
317: IF g_debug <= gme_debug.g_log_procedure THEN
318: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
319: || l_api_name);
320: END IF;
321:

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

314: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
315: l_gme_tran_rec gme_resource_txns_gtmp%ROWTYPE;
316: BEGIN
317: IF g_debug <= gme_debug.g_log_procedure THEN
318: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
319: || l_api_name);
320: END IF;
321:
322: l_gme_tran_rec := p_tran_rec;

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

325: l_gme_tran_rec.action_code := 'UPD';
326: END IF;
327:
328: /* Now Call the UPDATE rec DML Layer */
329: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
330: gme_debug.put_line ( 'Calling UPDATE rec trans id:'
331: || TO_CHAR (p_tran_rec.poc_trans_id) );
332: END IF;
333:

Line 330: gme_debug.put_line ( 'Calling UPDATE rec trans id:'

326: END IF;
327:
328: /* Now Call the UPDATE rec DML Layer */
329: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
330: gme_debug.put_line ( 'Calling UPDATE rec trans id:'
331: || TO_CHAR (p_tran_rec.poc_trans_id) );
332: END IF;
333:
334: IF NOT gme_resource_txns_gtmp_dbl.update_row

Line 341: IF g_debug <= gme_debug.g_log_procedure THEN

337: END IF;
338:
339: x_return_status := l_return_status;
340:
341: IF g_debug <= gme_debug.g_log_procedure THEN
342: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
343: END IF;
344: EXCEPTION
345: WHEN fnd_api.g_exc_error THEN

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

338:
339: x_return_status := l_return_status;
340:
341: IF g_debug <= gme_debug.g_log_procedure THEN
342: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
343: END IF;
344: EXCEPTION
345: WHEN fnd_api.g_exc_error THEN
346: x_return_status := fnd_api.g_ret_sts_error;

Line 350: IF g_debug <= gme_debug.g_log_unexpected THEN

346: x_return_status := fnd_api.g_ret_sts_error;
347: WHEN fnd_api.g_exc_unexpected_error THEN
348: x_return_status := fnd_api.g_ret_sts_unexp_error;
349: WHEN OTHERS THEN
350: IF g_debug <= gme_debug.g_log_unexpected THEN
351: gme_debug.put_line ( 'When others exception in '
352: || g_pkg_name
353: || '.'
354: || l_api_name

Line 351: gme_debug.put_line ( 'When others exception in '

347: WHEN fnd_api.g_exc_unexpected_error THEN
348: x_return_status := fnd_api.g_ret_sts_unexp_error;
349: WHEN OTHERS THEN
350: IF g_debug <= gme_debug.g_log_unexpected THEN
351: gme_debug.put_line ( 'When others exception in '
352: || g_pkg_name
353: || '.'
354: || l_api_name
355: || ' Error is '

Line 444: IF g_debug <= gme_debug.g_log_procedure THEN

440: l_message_count NUMBER;
441: l_message_list VARCHAR2(2000);
442:
443: BEGIN
444: IF g_debug <= gme_debug.g_log_procedure THEN
445: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
446: || l_api_name);
447: END IF;
448:

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

441: l_message_list VARCHAR2(2000);
442:
443: BEGIN
444: IF g_debug <= gme_debug.g_log_procedure THEN
445: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
446: || l_api_name);
447: END IF;
448:
449: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

445: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
446: || l_api_name);
447: END IF;
448:
449: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
450: gme_debug.display_resource_gtmp (NULL, NULL, p_batch_id);
451: END IF;
452:
453: l_debug := 'Doc Id = > ' || p_batch_id;

Line 450: gme_debug.display_resource_gtmp (NULL, NULL, p_batch_id);

446: || l_api_name);
447: END IF;
448:
449: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
450: gme_debug.display_resource_gtmp (NULL, NULL, p_batch_id);
451: END IF;
452:
453: l_debug := 'Doc Id = > ' || p_batch_id;
454:

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

559: /*Populating the reverse_id of the reversed transaction with the poc_trans_id
560: of the original transaction*/
561: l_prev_rec.reverse_id := l_in_tran_rec.poc_trans_id;
562:
563: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
564: gme_debug.put_line
565: ( g_pkg_name
566: || '.'
567: || l_api_name

Line 564: gme_debug.put_line

560: of the original transaction*/
561: l_prev_rec.reverse_id := l_in_tran_rec.poc_trans_id;
562:
563: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
564: gme_debug.put_line
565: ( g_pkg_name
566: || '.'
567: || l_api_name
568: || ' UPD action code: poc_trans_id of the original transaction is '

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

598: --Bug#4917189 Susruth D. Added below updated to make sure only we update the reverse_id but not any
599: -- other column for the original txn which is reversed.
600: -- l_in_tran_rec.reverse_id := l_prev_rec.poc_trans_id;
601:
602: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
603: gme_debug.put_line
604: ( g_pkg_name
605: || '.'
606: || l_api_name

Line 603: gme_debug.put_line

599: -- other column for the original txn which is reversed.
600: -- l_in_tran_rec.reverse_id := l_prev_rec.poc_trans_id;
601:
602: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
603: gme_debug.put_line
604: ( g_pkg_name
605: || '.'
606: || l_api_name
607: || ' UPD action code: poc_trans_id of the reversal txn is '

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

698: INTO l_in_tran_rec;
699:
700: CLOSE cur_get_prev_rec;
701:
702: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
703: gme_debug.put_line
704: ( g_pkg_name
705: || '.'
706: || l_api_name

Line 703: gme_debug.put_line

699:
700: CLOSE cur_get_prev_rec;
701:
702: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
703: gme_debug.put_line
704: ( g_pkg_name
705: || '.'
706: || l_api_name
707: || ' DEL action code: poc_trans_id of the original transaction is '

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

707: || ' DEL action code: poc_trans_id of the original transaction is '
708: || l_in_tran_rec.poc_trans_id);
709: END IF;
710:
711: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
712: gme_debug.put_line('IN DEL dates');
713: gme_debug.put_line('l_tran_rec.trans_date is '||l_tran_rec.trans_date);
714: gme_debug.put_line('ORIGINAL l_in_tran_rec.trans_date is '||l_in_tran_rec.trans_date);
715: gme_debug.put_line('gme_common_pvt.g_ib_timestamp_set is '||gme_common_pvt.g_ib_timestamp_set);

Line 712: gme_debug.put_line('IN DEL dates');

708: || l_in_tran_rec.poc_trans_id);
709: END IF;
710:
711: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
712: gme_debug.put_line('IN DEL dates');
713: gme_debug.put_line('l_tran_rec.trans_date is '||l_tran_rec.trans_date);
714: gme_debug.put_line('ORIGINAL l_in_tran_rec.trans_date is '||l_in_tran_rec.trans_date);
715: gme_debug.put_line('gme_common_pvt.g_ib_timestamp_set is '||gme_common_pvt.g_ib_timestamp_set);
716: END IF;

Line 713: gme_debug.put_line('l_tran_rec.trans_date is '||l_tran_rec.trans_date);

709: END IF;
710:
711: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
712: gme_debug.put_line('IN DEL dates');
713: gme_debug.put_line('l_tran_rec.trans_date is '||l_tran_rec.trans_date);
714: gme_debug.put_line('ORIGINAL l_in_tran_rec.trans_date is '||l_in_tran_rec.trans_date);
715: gme_debug.put_line('gme_common_pvt.g_ib_timestamp_set is '||gme_common_pvt.g_ib_timestamp_set);
716: END IF;
717:

Line 714: gme_debug.put_line('ORIGINAL l_in_tran_rec.trans_date is '||l_in_tran_rec.trans_date);

710:
711: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
712: gme_debug.put_line('IN DEL dates');
713: gme_debug.put_line('l_tran_rec.trans_date is '||l_tran_rec.trans_date);
714: gme_debug.put_line('ORIGINAL l_in_tran_rec.trans_date is '||l_in_tran_rec.trans_date);
715: gme_debug.put_line('gme_common_pvt.g_ib_timestamp_set is '||gme_common_pvt.g_ib_timestamp_set);
716: END IF;
717:
718: -- Note: l_in_tran_rec.trans_date is the original trans record prior to any change from DB

Line 715: gme_debug.put_line('gme_common_pvt.g_ib_timestamp_set is '||gme_common_pvt.g_ib_timestamp_set);

711: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
712: gme_debug.put_line('IN DEL dates');
713: gme_debug.put_line('l_tran_rec.trans_date is '||l_tran_rec.trans_date);
714: gme_debug.put_line('ORIGINAL l_in_tran_rec.trans_date is '||l_in_tran_rec.trans_date);
715: gme_debug.put_line('gme_common_pvt.g_ib_timestamp_set is '||gme_common_pvt.g_ib_timestamp_set);
716: END IF;
717:
718: -- Note: l_in_tran_rec.trans_date is the original trans record prior to any change from DB
719: -- l_tran_rec.trans_date is the current data changed by the user on form or IB

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

764: --Bug#4917189 Susruth D. Added below updated to make sure only we update the reverse_id but not any
765: -- other column for the original txn which is reversed.
766: /*l_in_tran_rec.reverse_id := l_tran_rec.poc_trans_id;*/
767:
768: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
769: gme_debug.put_line
770: ( g_pkg_name
771: || '.'
772: || l_api_name

Line 769: gme_debug.put_line

765: -- other column for the original txn which is reversed.
766: /*l_in_tran_rec.reverse_id := l_tran_rec.poc_trans_id;*/
767:
768: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
769: gme_debug.put_line
770: ( g_pkg_name
771: || '.'
772: || l_api_name
773: || ' DEL action code: poc_trans_id of the reversal txn is '

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

813: -- Bug 8751983 - Reset the global variables.
814: gme_common_pvt.g_ib_timestamp_set := 0;
815: gme_common_pvt.g_ib_timestamp_date := NULL;
816:
817: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
818: gme_debug.display_resource_gtmp (NULL, NULL, p_batch_id);
819: END IF;
820:
821: x_return_status := l_return_status;

Line 818: gme_debug.display_resource_gtmp (NULL, NULL, p_batch_id);

814: gme_common_pvt.g_ib_timestamp_set := 0;
815: gme_common_pvt.g_ib_timestamp_date := NULL;
816:
817: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
818: gme_debug.display_resource_gtmp (NULL, NULL, p_batch_id);
819: END IF;
820:
821: x_return_status := l_return_status;
822:

Line 823: IF g_debug <= gme_debug.g_log_procedure THEN

819: END IF;
820:
821: x_return_status := l_return_status;
822:
823: IF g_debug <= gme_debug.g_log_procedure THEN
824: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
825: END IF;
826: EXCEPTION
827: WHEN fnd_api.g_exc_error THEN

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

820:
821: x_return_status := l_return_status;
822:
823: IF g_debug <= gme_debug.g_log_procedure THEN
824: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
825: END IF;
826: EXCEPTION
827: WHEN fnd_api.g_exc_error THEN
828: x_return_status := fnd_api.g_ret_sts_error;

Line 834: IF g_debug <= gme_debug.g_log_unexpected THEN

830: x_return_status := fnd_api.g_ret_sts_error;
831: WHEN update_failure THEN
832: x_return_status := fnd_api.g_ret_sts_error;
833: WHEN OTHERS THEN
834: IF g_debug <= gme_debug.g_log_unexpected THEN
835: gme_debug.put_line ( 'When others exception in '
836: || g_pkg_name
837: || '.'
838: || l_api_name

Line 835: gme_debug.put_line ( 'When others exception in '

831: WHEN update_failure THEN
832: x_return_status := fnd_api.g_ret_sts_error;
833: WHEN OTHERS THEN
834: IF g_debug <= gme_debug.g_log_unexpected THEN
835: gme_debug.put_line ( 'When others exception in '
836: || g_pkg_name
837: || '.'
838: || l_api_name
839: || ' Error is '

Line 862: IF g_debug <= gme_debug.g_log_procedure THEN

858: ,p_resource_rec OUT NOCOPY gme_resource_txns%ROWTYPE)
859: IS
860: l_api_name CONSTANT VARCHAR2 (30) := 'build_resource_tran';
861: BEGIN
862: IF g_debug <= gme_debug.g_log_procedure THEN
863: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
864: || l_api_name);
865: END IF;
866:

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

859: IS
860: l_api_name CONSTANT VARCHAR2 (30) := 'build_resource_tran';
861: BEGIN
862: IF g_debug <= gme_debug.g_log_procedure THEN
863: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
864: || l_api_name);
865: END IF;
866:
867: p_resource_rec.organization_id := p_tmp_rec.organization_id;

Line 937: IF g_debug <= gme_debug.g_log_procedure THEN

933:
934:
935:
936:
937: IF g_debug <= gme_debug.g_log_procedure THEN
938: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
939: END IF;
940: --Bug2804440
941: EXCEPTION

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

934:
935:
936:
937: IF g_debug <= gme_debug.g_log_procedure THEN
938: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
939: END IF;
940: --Bug2804440
941: EXCEPTION
942: WHEN OTHERS THEN

Line 943: IF g_debug <= gme_debug.g_log_unexpected THEN

939: END IF;
940: --Bug2804440
941: EXCEPTION
942: WHEN OTHERS THEN
943: IF g_debug <= gme_debug.g_log_unexpected THEN
944: gme_debug.put_line ( 'When others exception in '
945: || g_pkg_name
946: || '.'
947: || l_api_name

Line 944: gme_debug.put_line ( 'When others exception in '

940: --Bug2804440
941: EXCEPTION
942: WHEN OTHERS THEN
943: IF g_debug <= gme_debug.g_log_unexpected THEN
944: gme_debug.put_line ( 'When others exception in '
945: || g_pkg_name
946: || '.'
947: || l_api_name
948: || ' Error is '

Line 992: IF g_debug <= gme_debug.g_log_procedure THEN

988: l_line_index BINARY_INTEGER := 1;
989: l_cursor BINARY_INTEGER;
990: bad_keys EXCEPTION;
991: BEGIN
992: IF g_debug <= gme_debug.g_log_procedure THEN
993: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
994: || l_api_name);
995: END IF;
996:

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

989: l_cursor BINARY_INTEGER;
990: bad_keys EXCEPTION;
991: BEGIN
992: IF g_debug <= gme_debug.g_log_procedure THEN
993: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
994: || l_api_name);
995: END IF;
996:
997: /* Initialize API return status to sucess */

Line 1073: IF g_debug <= gme_debug.g_log_procedure THEN

1069: END LOOP;
1070:
1071: CLOSE get_rsrc;
1072:
1073: IF g_debug <= gme_debug.g_log_procedure THEN
1074: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1075: END IF;
1076: EXCEPTION
1077: WHEN fnd_api.g_exc_error THEN

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

1070:
1071: CLOSE get_rsrc;
1072:
1073: IF g_debug <= gme_debug.g_log_procedure THEN
1074: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1075: END IF;
1076: EXCEPTION
1077: WHEN fnd_api.g_exc_error THEN
1078: x_return_status := fnd_api.g_ret_sts_error;

Line 1084: IF g_debug <= gme_debug.g_log_unexpected THEN

1080: x_return_status := fnd_api.g_ret_sts_unexp_error;
1081: WHEN bad_keys THEN
1082: x_return_status := fnd_api.g_ret_sts_error;
1083: WHEN OTHERS THEN
1084: IF g_debug <= gme_debug.g_log_unexpected THEN
1085: gme_debug.put_line ( 'When others exception in '
1086: || g_pkg_name
1087: || '.'
1088: || l_api_name

Line 1085: gme_debug.put_line ( 'When others exception in '

1081: WHEN bad_keys THEN
1082: x_return_status := fnd_api.g_ret_sts_error;
1083: WHEN OTHERS THEN
1084: IF g_debug <= gme_debug.g_log_unexpected THEN
1085: gme_debug.put_line ( 'When others exception in '
1086: || g_pkg_name
1087: || '.'
1088: || l_api_name
1089: || ' Error is '

Line 1173: IF g_debug <= gme_debug.g_log_procedure THEN

1169: l_message_count NUMBER;
1170: l_message_list VARCHAR2(2000);
1171:
1172: BEGIN
1173: IF g_debug <= gme_debug.g_log_procedure THEN
1174: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1175: || l_api_name);
1176: END IF;
1177:

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

1170: l_message_list VARCHAR2(2000);
1171:
1172: BEGIN
1173: IF g_debug <= gme_debug.g_log_procedure THEN
1174: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1175: || l_api_name);
1176: END IF;
1177:
1178: /* There is no public layer for this package so adding initialize right here *

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

1175: || l_api_name);
1176: END IF;
1177:
1178: /* There is no public layer for this package so adding initialize right here *
1179: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1180: gme_debug.log_initialize('RESOURCE_TXN');
1181: END IF;
1182:
1183: /* Initialize return status to success */

Line 1180: gme_debug.log_initialize('RESOURCE_TXN');

1176: END IF;
1177:
1178: /* There is no public layer for this package so adding initialize right here *
1179: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1180: gme_debug.log_initialize('RESOURCE_TXN');
1181: END IF;
1182:
1183: /* Initialize return status to success */
1184: x_return_status := fnd_api.g_ret_sts_success;

Line 1475: IF g_debug <= gme_debug.g_log_procedure THEN

1471: END IF; /*action code check */
1472: END IF; /*p_step_resources_rec.capacity_constraint = 1 */
1473: /*Bug#5231180 End */
1474:
1475: IF g_debug <= gme_debug.g_log_procedure THEN
1476: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1477: END IF;
1478: EXCEPTION
1479: WHEN gmf_cost_failure THEN

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

1472: END IF; /*p_step_resources_rec.capacity_constraint = 1 */
1473: /*Bug#5231180 End */
1474:
1475: IF g_debug <= gme_debug.g_log_procedure THEN
1476: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1477: END IF;
1478: EXCEPTION
1479: WHEN gmf_cost_failure THEN
1480: -- Bug 5903208

Line 1486: IF g_debug <= gme_debug.g_log_unexpected THEN

1482:
1483: WHEN fnd_api.g_exc_error THEN
1484: x_return_status := fnd_api.g_ret_sts_error;
1485: WHEN OTHERS THEN
1486: IF g_debug <= gme_debug.g_log_unexpected THEN
1487: gme_debug.put_line ( 'When others exception in '
1488: || g_pkg_name
1489: || '.'
1490: || l_api_name

Line 1487: gme_debug.put_line ( 'When others exception in '

1483: WHEN fnd_api.g_exc_error THEN
1484: x_return_status := fnd_api.g_ret_sts_error;
1485: WHEN OTHERS THEN
1486: IF g_debug <= gme_debug.g_log_unexpected THEN
1487: gme_debug.put_line ( 'When others exception in '
1488: || g_pkg_name
1489: || '.'
1490: || l_api_name
1491: || ' Error is '

Line 1523: IF g_debug <= gme_debug.g_log_procedure THEN

1519: ,x_return_status OUT NOCOPY VARCHAR2)
1520: IS
1521: l_api_name CONSTANT VARCHAR2 (30) := 'validate_resource';
1522: BEGIN
1523: IF g_debug <= gme_debug.g_log_procedure THEN
1524: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1525: || l_api_name);
1526: END IF;
1527:

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

1520: IS
1521: l_api_name CONSTANT VARCHAR2 (30) := 'validate_resource';
1522: BEGIN
1523: IF g_debug <= gme_debug.g_log_procedure THEN
1524: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1525: || l_api_name);
1526: END IF;
1527:
1528: /* Initialize return status to success */

Line 1649: IF g_debug <= gme_debug.g_log_procedure THEN

1645: check_primary_resource (p_step_resources_rec => p_step_resources_rec
1646: ,x_return_status => x_return_status);
1647: END IF;
1648: */
1649: IF g_debug <= gme_debug.g_log_procedure THEN
1650: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1651: END IF;
1652: EXCEPTION
1653: WHEN fnd_api.g_exc_error THEN

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

1646: ,x_return_status => x_return_status);
1647: END IF;
1648: */
1649: IF g_debug <= gme_debug.g_log_procedure THEN
1650: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1651: END IF;
1652: EXCEPTION
1653: WHEN fnd_api.g_exc_error THEN
1654: x_return_status := fnd_api.g_ret_sts_error;

Line 1656: IF g_debug <= gme_debug.g_log_unexpected THEN

1652: EXCEPTION
1653: WHEN fnd_api.g_exc_error THEN
1654: x_return_status := fnd_api.g_ret_sts_error;
1655: WHEN OTHERS THEN
1656: IF g_debug <= gme_debug.g_log_unexpected THEN
1657: gme_debug.put_line ( 'When others exception in '
1658: || g_pkg_name
1659: || '.'
1660: || l_api_name

Line 1657: gme_debug.put_line ( 'When others exception in '

1653: WHEN fnd_api.g_exc_error THEN
1654: x_return_status := fnd_api.g_ret_sts_error;
1655: WHEN OTHERS THEN
1656: IF g_debug <= gme_debug.g_log_unexpected THEN
1657: gme_debug.put_line ( 'When others exception in '
1658: || g_pkg_name
1659: || '.'
1660: || l_api_name
1661: || ' Error is '

Line 1724: IF g_debug <= gme_debug.g_log_procedure THEN

1720: l_step_id gme_batch_steps.batchstep_id%TYPE;
1721: --Rishi 3446787/3020345 end
1722: l_count NUMBER (5);
1723: BEGIN
1724: IF g_debug <= gme_debug.g_log_procedure THEN
1725: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1726: || l_api_name);
1727: END IF;
1728:

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

1721: --Rishi 3446787/3020345 end
1722: l_count NUMBER (5);
1723: BEGIN
1724: IF g_debug <= gme_debug.g_log_procedure THEN
1725: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1726: || l_api_name);
1727: END IF;
1728:
1729: /* Initialize return status to success */

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

1759:
1760: CLOSE cur_get_batchstep_no;
1761:
1762: --Rishi 3446787/3020345 end
1763: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1764: gme_debug.put_line ( ' Activity:'
1765: || p_step_resources_rec.batchstep_activity_id
1766: || ' Resource:'
1767: || p_step_resources_rec.batchstep_resource_id

Line 1764: gme_debug.put_line ( ' Activity:'

1760: CLOSE cur_get_batchstep_no;
1761:
1762: --Rishi 3446787/3020345 end
1763: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1764: gme_debug.put_line ( ' Activity:'
1765: || p_step_resources_rec.batchstep_activity_id
1766: || ' Resource:'
1767: || p_step_resources_rec.batchstep_resource_id
1768: || ' Count:'

Line 1788: IF g_debug <= gme_debug.g_log_procedure THEN

1784: fnd_msg_pub.ADD;
1785: RAISE fnd_api.g_exc_error;
1786: END IF;
1787:
1788: IF g_debug <= gme_debug.g_log_procedure THEN
1789: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1790: END IF;
1791: EXCEPTION
1792: WHEN fnd_api.g_exc_error THEN

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

1785: RAISE fnd_api.g_exc_error;
1786: END IF;
1787:
1788: IF g_debug <= gme_debug.g_log_procedure THEN
1789: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1790: END IF;
1791: EXCEPTION
1792: WHEN fnd_api.g_exc_error THEN
1793: x_return_status := fnd_api.g_ret_sts_error;

Line 1795: IF g_debug <= gme_debug.g_log_unexpected THEN

1791: EXCEPTION
1792: WHEN fnd_api.g_exc_error THEN
1793: x_return_status := fnd_api.g_ret_sts_error;
1794: WHEN OTHERS THEN
1795: IF g_debug <= gme_debug.g_log_unexpected THEN
1796: gme_debug.put_line ( 'When others exception in '
1797: || g_pkg_name
1798: || '.'
1799: || l_api_name

Line 1796: gme_debug.put_line ( 'When others exception in '

1792: WHEN fnd_api.g_exc_error THEN
1793: x_return_status := fnd_api.g_ret_sts_error;
1794: WHEN OTHERS THEN
1795: IF g_debug <= gme_debug.g_log_unexpected THEN
1796: gme_debug.put_line ( 'When others exception in '
1797: || g_pkg_name
1798: || '.'
1799: || l_api_name
1800: || ' Error is '

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

1854: FOR batchsteps IN cur_get_batch_steps LOOP
1855: FOR activities IN
1856: cur_get_batchstep_activities (p_batch_id
1857: ,batchsteps.batchstep_id) LOOP
1858: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1859: gme_debug.put_line ( ' Activity:'
1860: || activities.batchstep_activity_id);
1861: END IF;
1862:

Line 1859: gme_debug.put_line ( ' Activity:'

1855: FOR activities IN
1856: cur_get_batchstep_activities (p_batch_id
1857: ,batchsteps.batchstep_id) LOOP
1858: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1859: gme_debug.put_line ( ' Activity:'
1860: || activities.batchstep_activity_id);
1861: END IF;
1862:
1863: OPEN cur_get_prim_rsrc_count (activities.batchstep_activity_id);

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

1866: INTO l_count;
1867:
1868: CLOSE cur_get_prim_rsrc_count;
1869:
1870: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1871: gme_debug.put_line (' Count:' || l_count);
1872: END IF;
1873:
1874: IF (l_count > 1) THEN

Line 1871: gme_debug.put_line (' Count:' || l_count);

1867:
1868: CLOSE cur_get_prim_rsrc_count;
1869:
1870: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1871: gme_debug.put_line (' Count:' || l_count);
1872: END IF;
1873:
1874: IF (l_count > 1) THEN
1875: fnd_message.set_name ('GME', 'GME_ONE_PRIM_RSRC');

Line 1939: IF g_debug <= gme_debug.g_log_procedure THEN

1935:
1936: l_status NUMBER (5);
1937: l_tot_usage NUMBER;
1938: BEGIN
1939: IF g_debug <= gme_debug.g_log_procedure THEN
1940: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1941: || l_api_name);
1942: END IF;
1943:

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

1936: l_status NUMBER (5);
1937: l_tot_usage NUMBER;
1938: BEGIN
1939: IF g_debug <= gme_debug.g_log_procedure THEN
1940: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1941: || l_api_name);
1942: END IF;
1943:
1944: /* Initialize return status to success */

Line 1982: IF g_debug <= gme_debug.g_log_procedure THEN

1978:
1979: x_step_resources_rec.actual_rsrc_usage := l_tot_usage;
1980: END IF;
1981:
1982: IF g_debug <= gme_debug.g_log_procedure THEN
1983: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1984: END IF;
1985: EXCEPTION
1986: WHEN fnd_api.g_exc_error THEN

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

1979: x_step_resources_rec.actual_rsrc_usage := l_tot_usage;
1980: END IF;
1981:
1982: IF g_debug <= gme_debug.g_log_procedure THEN
1983: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1984: END IF;
1985: EXCEPTION
1986: WHEN fnd_api.g_exc_error THEN
1987: x_return_status := fnd_api.g_ret_sts_error;

Line 1989: IF g_debug <= gme_debug.g_log_unexpected THEN

1985: EXCEPTION
1986: WHEN fnd_api.g_exc_error THEN
1987: x_return_status := fnd_api.g_ret_sts_error;
1988: WHEN OTHERS THEN
1989: IF g_debug <= gme_debug.g_log_unexpected THEN
1990: gme_debug.put_line ( 'When others exception in '
1991: || g_pkg_name
1992: || '.'
1993: || l_api_name

Line 1990: gme_debug.put_line ( 'When others exception in '

1986: WHEN fnd_api.g_exc_error THEN
1987: x_return_status := fnd_api.g_ret_sts_error;
1988: WHEN OTHERS THEN
1989: IF g_debug <= gme_debug.g_log_unexpected THEN
1990: gme_debug.put_line ( 'When others exception in '
1991: || g_pkg_name
1992: || '.'
1993: || l_api_name
1994: || ' Error is '

Line 2186: IF g_debug <= gme_debug.g_log_procedure THEN

2182: asqc_update_rsrc_api_error EXCEPTION;
2183: asqc_ovrd_end_txn_api_error EXCEPTION;
2184: rtxn_for_updinv_not_allowed EXCEPTION;
2185: BEGIN
2186: IF g_debug <= gme_debug.g_log_procedure THEN
2187: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2188: || l_api_name);
2189: END IF;
2190:

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

2183: asqc_ovrd_end_txn_api_error EXCEPTION;
2184: rtxn_for_updinv_not_allowed EXCEPTION;
2185: BEGIN
2186: IF g_debug <= gme_debug.g_log_procedure THEN
2187: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2188: || l_api_name);
2189: END IF;
2190:
2191: /* Initially let us assign the return status to success */

Line 2559: IF g_debug <= gme_debug.g_log_procedure THEN

2555: END IF;
2556:
2557: x_batch_header_rec := l_batch_header;
2558:
2559: IF g_debug <= gme_debug.g_log_procedure THEN
2560: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2561: END IF;
2562: EXCEPTION
2563: WHEN invalid_date OR close_period_err OR step_status_asqc_error OR asqc_update_rsrc_api_error OR asqc_ovrd_end_txn_api_error OR fnd_api.g_exc_error THEN

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

2556:
2557: x_batch_header_rec := l_batch_header;
2558:
2559: IF g_debug <= gme_debug.g_log_procedure THEN
2560: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2561: END IF;
2562: EXCEPTION
2563: WHEN invalid_date OR close_period_err OR step_status_asqc_error OR asqc_update_rsrc_api_error OR asqc_ovrd_end_txn_api_error OR fnd_api.g_exc_error THEN
2564: x_return_status := fnd_api.g_ret_sts_error;

Line 2580: IF g_debug <= gme_debug.g_log_unexpected THEN

2576: fnd_message.set_name ('GMA', 'SY_REASONCODE');
2577: fnd_msg_pub.ADD;
2578: x_return_status := fnd_api.g_ret_sts_error;
2579: WHEN OTHERS THEN
2580: IF g_debug <= gme_debug.g_log_unexpected THEN
2581: gme_debug.put_line ( 'When others exception in '
2582: || g_pkg_name
2583: || '.'
2584: || l_api_name

Line 2581: gme_debug.put_line ( 'When others exception in '

2577: fnd_msg_pub.ADD;
2578: x_return_status := fnd_api.g_ret_sts_error;
2579: WHEN OTHERS THEN
2580: IF g_debug <= gme_debug.g_log_unexpected THEN
2581: gme_debug.put_line ( 'When others exception in '
2582: || g_pkg_name
2583: || '.'
2584: || l_api_name
2585: || ' Error is '

Line 2661: IF g_debug <= gme_debug.g_log_procedure THEN

2657: rsrc_txn_insert_err EXCEPTION;
2658: error_load_trans EXCEPTION;
2659: update_rsrc_txn_err EXCEPTION;
2660: BEGIN
2661: IF g_debug <= gme_debug.g_log_procedure THEN
2662: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2663: || l_api_name);
2664: END IF;
2665:

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

2658: error_load_trans EXCEPTION;
2659: update_rsrc_txn_err EXCEPTION;
2660: BEGIN
2661: IF g_debug <= gme_debug.g_log_procedure THEN
2662: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2663: || l_api_name);
2664: END IF;
2665:
2666: /* Initially let us assign the return status to success */

Line 2683: IF g_debug <= gme_debug.g_log_procedure THEN

2679: RAISE validation_failure;
2680: END IF;
2681: --END IF;
2682:
2683: IF g_debug <= gme_debug.g_log_procedure THEN
2684: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
2685: || g_pkg_name
2686: || '.'
2687: || l_api_name);

Line 2684: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '

2680: END IF;
2681: --END IF;
2682:
2683: IF g_debug <= gme_debug.g_log_procedure THEN
2684: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
2685: || g_pkg_name
2686: || '.'
2687: || l_api_name);
2688: END IF;

Line 2713: IF g_debug <= gme_debug.g_log_procedure THEN

2709: ,x_reason_id => l_reason_id
2710: ,x_return_status => x_return_status
2711: ,x_trans_date => l_trans_date);
2712:
2713: IF g_debug <= gme_debug.g_log_procedure THEN
2714: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
2715: || g_pkg_name
2716: || '.'
2717: || l_api_name);

Line 2714: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '

2710: ,x_return_status => x_return_status
2711: ,x_trans_date => l_trans_date);
2712:
2713: IF g_debug <= gme_debug.g_log_procedure THEN
2714: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
2715: || g_pkg_name
2716: || '.'
2717: || l_api_name);
2718: END IF;

Line 2740: IF g_debug <= gme_debug.g_log_statement THEN

2736:
2737: IF l_return_status <> x_return_status THEN
2738: RAISE error_load_trans;
2739: END IF;
2740: IF g_debug <= gme_debug.g_log_statement THEN
2741: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Transactions Loaded '||l_rsrc_trans_count);
2742: END IF;
2743:
2744: l_rsrc_txn_rec.line_id := l_line_id;

Line 2741: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Transactions Loaded '||l_rsrc_trans_count);

2737: IF l_return_status <> x_return_status THEN
2738: RAISE error_load_trans;
2739: END IF;
2740: IF g_debug <= gme_debug.g_log_statement THEN
2741: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Transactions Loaded '||l_rsrc_trans_count);
2742: END IF;
2743:
2744: l_rsrc_txn_rec.line_id := l_line_id;
2745: gme_resource_engine_pvt.fetch_active_resources

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

2833: ,l_rsrc_txn_rec) ) THEN
2834: RAISE rsrc_txn_insert_err;
2835: END IF;
2836:
2837: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2838: --Rishi Varma 3896510/3865212
2839: /*Replaced hardcoded value '157' for batch_id with l_batch_header.batch_id*/
2840: gme_debug.display_resource_gtmp (NULL, NULL
2841: ,l_batch_header.batch_id);

Line 2840: gme_debug.display_resource_gtmp (NULL, NULL

2836:
2837: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2838: --Rishi Varma 3896510/3865212
2839: /*Replaced hardcoded value '157' for batch_id with l_batch_header.batch_id*/
2840: gme_debug.display_resource_gtmp (NULL, NULL
2841: ,l_batch_header.batch_id);
2842: END IF;
2843:
2844: l_step_resources.batchstep_resource_id := l_rsrc_txn_rec.line_id;

Line 2864: IF g_debug <= gme_debug.g_log_procedure THEN

2860: x_rsrc_txn_rec.poc_trans_id := l_rsrc_txn_rec.poc_trans_id;
2861: x_rsrc_txn_rec.doc_id := l_rsrc_txn_rec.doc_id;
2862: x_rsrc_txn_rec.line_id := l_rsrc_txn_rec.line_id;
2863:
2864: IF g_debug <= gme_debug.g_log_procedure THEN
2865: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2866: END IF;
2867: EXCEPTION
2868: WHEN validation_failure OR error_load_trans THEN

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

2861: x_rsrc_txn_rec.doc_id := l_rsrc_txn_rec.doc_id;
2862: x_rsrc_txn_rec.line_id := l_rsrc_txn_rec.line_id;
2863:
2864: IF g_debug <= gme_debug.g_log_procedure THEN
2865: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2866: END IF;
2867: EXCEPTION
2868: WHEN validation_failure OR error_load_trans THEN
2869: x_return_status := fnd_api.g_ret_sts_error;

Line 2875: IF g_debug <= gme_debug.g_log_unexpected THEN

2871: x_return_status := fnd_api.g_ret_sts_error;
2872: WHEN rsrc_fetch_err OR rsrc_update_err THEN
2873: x_return_status := fnd_api.g_ret_sts_error;
2874: WHEN OTHERS THEN
2875: IF g_debug <= gme_debug.g_log_unexpected THEN
2876: gme_debug.put_line ( 'When others exception in '
2877: || g_pkg_name
2878: || '.'
2879: || l_api_name

Line 2876: gme_debug.put_line ( 'When others exception in '

2872: WHEN rsrc_fetch_err OR rsrc_update_err THEN
2873: x_return_status := fnd_api.g_ret_sts_error;
2874: WHEN OTHERS THEN
2875: IF g_debug <= gme_debug.g_log_unexpected THEN
2876: gme_debug.put_line ( 'When others exception in '
2877: || g_pkg_name
2878: || '.'
2879: || l_api_name
2880: || ' Error is '

Line 2971: IF g_debug <= gme_debug.g_log_procedure THEN

2967: l_msg_count NUMBER;
2968: l_msg_data VARCHAR2(2000);
2969:
2970: BEGIN
2971: IF g_debug <= gme_debug.g_log_procedure THEN
2972: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2973: || l_api_name);
2974: END IF;
2975:

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

2968: l_msg_data VARCHAR2(2000);
2969:
2970: BEGIN
2971: IF g_debug <= gme_debug.g_log_procedure THEN
2972: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2973: || l_api_name);
2974: END IF;
2975:
2976: /* Initially let us assign the return status to success */

Line 2995: IF g_debug <= gme_debug.g_log_procedure THEN

2991: --END IF;
2992:
2993: l_rsrc_txn_rec := x_rsrc_txn_rec;
2994:
2995: IF g_debug <= gme_debug.g_log_procedure THEN
2996: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
2997: || g_pkg_name
2998: || '.'
2999: || l_api_name);

Line 2996: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '

2992:
2993: l_rsrc_txn_rec := x_rsrc_txn_rec;
2994:
2995: IF g_debug <= gme_debug.g_log_procedure THEN
2996: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
2997: || g_pkg_name
2998: || '.'
2999: || l_api_name);
3000: END IF;

Line 3025: IF g_debug <= gme_debug.g_log_procedure THEN

3021: ,x_reason_id => l_reason_id
3022: ,x_return_status => x_return_status
3023: ,x_trans_date => l_trans_date);
3024:
3025: IF g_debug <= gme_debug.g_log_procedure THEN
3026: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
3027: || g_pkg_name
3028: || '.'
3029: || l_api_name);

Line 3026: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '

3022: ,x_return_status => x_return_status
3023: ,x_trans_date => l_trans_date);
3024:
3025: IF g_debug <= gme_debug.g_log_procedure THEN
3026: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
3027: || g_pkg_name
3028: || '.'
3029: || l_api_name);
3030: END IF;

Line 3149: IF g_debug <= gme_debug.g_log_procedure THEN

3145:
3146: --22APR02 Pawan Kumar bug 2912743 added poc_trans_id
3147: -- Assigning the value of poc_trans_id
3148: ---x_poc_trans_id := l_resource_txns.poc_trans_id;
3149: IF g_debug <= gme_debug.g_log_procedure THEN
3150: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3151: END IF;
3152: EXCEPTION
3153: WHEN gmf_cost_failure OR rsrc_txn_fetch_err THEN

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

3146: --22APR02 Pawan Kumar bug 2912743 added poc_trans_id
3147: -- Assigning the value of poc_trans_id
3148: ---x_poc_trans_id := l_resource_txns.poc_trans_id;
3149: IF g_debug <= gme_debug.g_log_procedure THEN
3150: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3151: END IF;
3152: EXCEPTION
3153: WHEN gmf_cost_failure OR rsrc_txn_fetch_err THEN
3154: -- Bug 9506856

Line 3161: IF g_debug <= gme_debug.g_log_unexpected THEN

3157: x_return_status := fnd_api.g_ret_sts_error;
3158: WHEN rsrc_fetch_err OR rsrc_update_err OR reduce_pend_usage_err THEN
3159: x_return_status := fnd_api.g_ret_sts_error;
3160: WHEN OTHERS THEN
3161: IF g_debug <= gme_debug.g_log_unexpected THEN
3162: gme_debug.put_line ( 'When others exception in '
3163: || g_pkg_name
3164: || '.'
3165: || l_api_name

Line 3162: gme_debug.put_line ( 'When others exception in '

3158: WHEN rsrc_fetch_err OR rsrc_update_err OR reduce_pend_usage_err THEN
3159: x_return_status := fnd_api.g_ret_sts_error;
3160: WHEN OTHERS THEN
3161: IF g_debug <= gme_debug.g_log_unexpected THEN
3162: gme_debug.put_line ( 'When others exception in '
3163: || g_pkg_name
3164: || '.'
3165: || l_api_name
3166: || ' Error is '

Line 3262: IF g_debug <= gme_debug.g_log_procedure THEN

3258: l_msg_count NUMBER;
3259: l_msg_data VARCHAR2(2000);
3260:
3261: BEGIN
3262: IF g_debug <= gme_debug.g_log_procedure THEN
3263: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3264: || l_api_name);
3265: END IF;
3266:

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

3259: l_msg_data VARCHAR2(2000);
3260:
3261: BEGIN
3262: IF g_debug <= gme_debug.g_log_procedure THEN
3263: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3264: || l_api_name);
3265: END IF;
3266:
3267: /* Initially let us assign the return status to success */

Line 3285: IF g_debug <= gme_debug.g_log_procedure THEN

3281: END IF;
3282: --END IF;
3283: l_rsrc_txn_rec := x_rsrc_txn_rec;
3284:
3285: IF g_debug <= gme_debug.g_log_procedure THEN
3286: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
3287: || g_pkg_name
3288: || '.'
3289: || l_api_name);

Line 3286: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '

3282: --END IF;
3283: l_rsrc_txn_rec := x_rsrc_txn_rec;
3284:
3285: IF g_debug <= gme_debug.g_log_procedure THEN
3286: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
3287: || g_pkg_name
3288: || '.'
3289: || l_api_name);
3290: END IF;

Line 3317: IF g_debug <= gme_debug.g_log_procedure THEN

3313: ,
3314: --Rishi Varma B3856541 02-09-2004
3315: x_trans_date => l_trans_date);
3316:
3317: IF g_debug <= gme_debug.g_log_procedure THEN
3318: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
3319: || g_pkg_name
3320: || '.'
3321: || l_api_name);

Line 3318: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '

3314: --Rishi Varma B3856541 02-09-2004
3315: x_trans_date => l_trans_date);
3316:
3317: IF g_debug <= gme_debug.g_log_procedure THEN
3318: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
3319: || g_pkg_name
3320: || '.'
3321: || l_api_name);
3322: END IF;

Line 3482: IF g_debug <= gme_debug.g_log_procedure THEN

3478: --22APR02 Pawan Kumar bug 2912743 added poc_trans_id
3479: -- Assigning the value of poc_trans_id
3480:
3481: ---x_poc_trans_id := l_resource_txns.poc_trans_id;
3482: IF g_debug <= gme_debug.g_log_procedure THEN
3483: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3484: END IF;
3485: EXCEPTION
3486: WHEN gmf_cost_failure OR rsrc_txn_fetch_err THEN

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

3479: -- Assigning the value of poc_trans_id
3480:
3481: ---x_poc_trans_id := l_resource_txns.poc_trans_id;
3482: IF g_debug <= gme_debug.g_log_procedure THEN
3483: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3484: END IF;
3485: EXCEPTION
3486: WHEN gmf_cost_failure OR rsrc_txn_fetch_err THEN
3487: -- Bug 9506856

Line 3496: IF g_debug <= gme_debug.g_log_unexpected THEN

3492: x_return_status := fnd_api.g_ret_sts_error;
3493: WHEN uom_conversion_err THEN
3494: x_return_status := fnd_api.g_ret_sts_error;
3495: WHEN OTHERS THEN
3496: IF g_debug <= gme_debug.g_log_unexpected THEN
3497: gme_debug.put_line ( 'When others exception in '
3498: || g_pkg_name
3499: || '.'
3500: || l_api_name

Line 3497: gme_debug.put_line ( 'When others exception in '

3493: WHEN uom_conversion_err THEN
3494: x_return_status := fnd_api.g_ret_sts_error;
3495: WHEN OTHERS THEN
3496: IF g_debug <= gme_debug.g_log_unexpected THEN
3497: gme_debug.put_line ( 'When others exception in '
3498: || g_pkg_name
3499: || '.'
3500: || l_api_name
3501: || ' Error is '

Line 3563: IF g_debug <= gme_debug.g_log_procedure THEN

3559: l_trans_date DATE;
3560: validation_failure EXCEPTION;
3561: rsrc_txn_insert_err EXCEPTION;
3562: BEGIN
3563: IF g_debug <= gme_debug.g_log_procedure THEN
3564: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3565: || l_api_name);
3566: END IF;
3567:

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

3560: validation_failure EXCEPTION;
3561: rsrc_txn_insert_err EXCEPTION;
3562: BEGIN
3563: IF g_debug <= gme_debug.g_log_procedure THEN
3564: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3565: || l_api_name);
3566: END IF;
3567:
3568: /* Initially let us assign the return status to success */

Line 3591: IF g_debug <= gme_debug.g_log_procedure THEN

3587:
3588: /* Initially let us assign the return status to success */
3589: l_return_status := fnd_api.g_ret_sts_success;
3590:
3591: IF g_debug <= gme_debug.g_log_procedure THEN
3592: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
3593: || g_pkg_name
3594: || '.'
3595: || l_api_name);

Line 3592: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '

3588: /* Initially let us assign the return status to success */
3589: l_return_status := fnd_api.g_ret_sts_success;
3590:
3591: IF g_debug <= gme_debug.g_log_procedure THEN
3592: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
3593: || g_pkg_name
3594: || '.'
3595: || l_api_name);
3596: END IF;

Line 3621: IF g_debug <= gme_debug.g_log_procedure THEN

3617: ,x_reason_id => l_reason_id
3618: ,x_return_status => l_return_status
3619: ,x_trans_date => l_trans_date);
3620:
3621: IF g_debug <= gme_debug.g_log_procedure THEN
3622: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
3623: || g_pkg_name
3624: || '.'
3625: || l_api_name);

Line 3622: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '

3618: ,x_return_status => l_return_status
3619: ,x_trans_date => l_trans_date);
3620:
3621: IF g_debug <= gme_debug.g_log_procedure THEN
3622: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
3623: || g_pkg_name
3624: || '.'
3625: || l_api_name);
3626: END IF;

Line 3652: IF g_debug <= gme_debug.g_log_procedure THEN

3648: l_rsrc_txn_rec.resources := l_resources;
3649: l_rsrc_txn_rec.resource_usage := 0;
3650: l_rsrc_txn_rec.trans_qty_um := l_usage_uom;
3651:
3652: IF g_debug <= gme_debug.g_log_procedure THEN
3653: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_trans_date ' || l_trans_date);
3654: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrc_txn_rec.trans_date ' || p_rsrc_txn_rec.trans_date);
3655: END IF;
3656:

Line 3653: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_trans_date ' || l_trans_date);

3649: l_rsrc_txn_rec.resource_usage := 0;
3650: l_rsrc_txn_rec.trans_qty_um := l_usage_uom;
3651:
3652: IF g_debug <= gme_debug.g_log_procedure THEN
3653: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_trans_date ' || l_trans_date);
3654: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrc_txn_rec.trans_date ' || p_rsrc_txn_rec.trans_date);
3655: END IF;
3656:
3657: IF l_trans_date IS NOT NULL THEN

Line 3654: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrc_txn_rec.trans_date ' || p_rsrc_txn_rec.trans_date);

3650: l_rsrc_txn_rec.trans_qty_um := l_usage_uom;
3651:
3652: IF g_debug <= gme_debug.g_log_procedure THEN
3653: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_trans_date ' || l_trans_date);
3654: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrc_txn_rec.trans_date ' || p_rsrc_txn_rec.trans_date);
3655: END IF;
3656:
3657: IF l_trans_date IS NOT NULL THEN
3658: l_rsrc_txn_rec.trans_date := l_trans_date;

Line 3689: IF g_debug <= gme_debug.g_log_procedure THEN

3685: ,x_rsrc_txn_rec) ) THEN
3686: RAISE rsrc_txn_insert_err;
3687: END IF;
3688:
3689: IF g_debug <= gme_debug.g_log_procedure THEN
3690: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name|| ' with return status '||x_return_status);
3691: END IF;
3692: EXCEPTION
3693: WHEN validation_failure OR rsrc_txn_insert_err THEN

Line 3690: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name|| ' with return status '||x_return_status);

3686: RAISE rsrc_txn_insert_err;
3687: END IF;
3688:
3689: IF g_debug <= gme_debug.g_log_procedure THEN
3690: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name|| ' with return status '||x_return_status);
3691: END IF;
3692: EXCEPTION
3693: WHEN validation_failure OR rsrc_txn_insert_err THEN
3694: x_return_status := fnd_api.g_ret_sts_error;

Line 3696: IF g_debug <= gme_debug.g_log_unexpected THEN

3692: EXCEPTION
3693: WHEN validation_failure OR rsrc_txn_insert_err THEN
3694: x_return_status := fnd_api.g_ret_sts_error;
3695: WHEN OTHERS THEN
3696: IF g_debug <= gme_debug.g_log_unexpected THEN
3697: gme_debug.put_line ( 'When others exception in '
3698: || g_pkg_name
3699: || '.'
3700: || l_api_name

Line 3697: gme_debug.put_line ( 'When others exception in '

3693: WHEN validation_failure OR rsrc_txn_insert_err THEN
3694: x_return_status := fnd_api.g_ret_sts_error;
3695: WHEN OTHERS THEN
3696: IF g_debug <= gme_debug.g_log_unexpected THEN
3697: gme_debug.put_line ( 'When others exception in '
3698: || g_pkg_name
3699: || '.'
3700: || l_api_name
3701: || ' Error is '

Line 3790: IF g_debug <= gme_debug.g_log_procedure THEN

3786: invalid_txn_for_end EXCEPTION;
3787: expected_error EXCEPTION;
3788: rsrc_txn_ins_err EXCEPTION;
3789: BEGIN
3790: IF g_debug <= gme_debug.g_log_procedure THEN
3791: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3792: || l_api_name);
3793: END IF;
3794:

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

3787: expected_error EXCEPTION;
3788: rsrc_txn_ins_err EXCEPTION;
3789: BEGIN
3790: IF g_debug <= gme_debug.g_log_procedure THEN
3791: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3792: || l_api_name);
3793: END IF;
3794:
3795: /* Initially let us assign the return status to success */

Line 3916: IF g_debug <= gme_debug.g_log_procedure THEN

3912: l_instance_id := p_rsrc_txn_rec.instance_id;
3913: END IF;
3914: /* siva end */
3915:
3916: IF g_debug <= gme_debug.g_log_procedure THEN
3917: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
3918: || g_pkg_name
3919: || '.'
3920: || l_api_name);

Line 3917: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '

3913: END IF;
3914: /* siva end */
3915:
3916: IF g_debug <= gme_debug.g_log_procedure THEN
3917: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
3918: || g_pkg_name
3919: || '.'
3920: || l_api_name);
3921: END IF;

Line 3947: IF g_debug <= gme_debug.g_log_procedure THEN

3943: ,x_reason_id => x_reason_id
3944: ,x_return_status => x_return_status
3945: ,x_trans_date => x_trans_date);
3946:
3947: IF g_debug <= gme_debug.g_log_procedure THEN
3948: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
3949: || g_pkg_name
3950: || '.'
3951: || l_api_name);

Line 3948: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '

3944: ,x_return_status => x_return_status
3945: ,x_trans_date => x_trans_date);
3946:
3947: IF g_debug <= gme_debug.g_log_procedure THEN
3948: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
3949: || g_pkg_name
3950: || '.'
3951: || l_api_name);
3952: END IF;

Line 4002: IF g_debug <= gme_debug.g_log_procedure THEN

3998: l_rsrc_txn_rec.attribute30 := x_rsrc_txn_rec.attribute30;
3999: -- END IF;
4000:
4001: --Begin Bug#3479669
4002: IF g_debug <= gme_debug.g_log_procedure THEN
4003: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
4004: || l_api_name);
4005: END IF;
4006:

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

3999: -- END IF;
4000:
4001: --Begin Bug#3479669
4002: IF g_debug <= gme_debug.g_log_procedure THEN
4003: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
4004: || l_api_name);
4005: END IF;
4006:
4007: IF l_rsrc_txn_rec.posted_ind = 1 THEN

Line 4025: IF g_debug <= gme_debug.g_log_procedure THEN

4021:
4022: x_rsrc_txn_rec := l_rsrc_txn_rec ;
4023:
4024: --Begin Bug#3479669
4025: IF g_debug <= gme_debug.g_log_procedure THEN
4026: gme_debug.put_line ( 'Entering api '
4027: || g_pkg_name
4028: || '.'
4029: || l_api_name);

Line 4026: gme_debug.put_line ( 'Entering api '

4022: x_rsrc_txn_rec := l_rsrc_txn_rec ;
4023:
4024: --Begin Bug#3479669
4025: IF g_debug <= gme_debug.g_log_procedure THEN
4026: gme_debug.put_line ( 'Entering api '
4027: || g_pkg_name
4028: || '.'
4029: || l_api_name);
4030: END IF;

Line 4082: IF g_debug <= gme_debug.g_log_procedure THEN

4078: (p_batch_step_resources => l_step_resources) THEN
4079: RAISE rsrc_update_err;
4080: END IF;
4081:
4082: IF g_debug <= gme_debug.g_log_procedure THEN
4083: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
4084: END IF;
4085: EXCEPTION
4086: WHEN expected_error OR missing_profile_option THEN

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

4079: RAISE rsrc_update_err;
4080: END IF;
4081:
4082: IF g_debug <= gme_debug.g_log_procedure THEN
4083: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
4084: END IF;
4085: EXCEPTION
4086: WHEN expected_error OR missing_profile_option THEN
4087: x_return_status := fnd_api.g_ret_sts_error;

Line 4100: IF g_debug <= gme_debug.g_log_unexpected THEN

4096: x_return_status := fnd_api.g_ret_sts_error;
4097: WHEN rsrc_fetch_err OR rsrc_txn_fetch_err OR rsrc_update_err OR reduce_pend_usage_err THEN
4098: x_return_status := fnd_api.g_ret_sts_error;
4099: WHEN OTHERS THEN
4100: IF g_debug <= gme_debug.g_log_unexpected THEN
4101: gme_debug.put_line ( 'When others exception in '
4102: || g_pkg_name
4103: || '.'
4104: || l_api_name

Line 4101: gme_debug.put_line ( 'When others exception in '

4097: WHEN rsrc_fetch_err OR rsrc_txn_fetch_err OR rsrc_update_err OR reduce_pend_usage_err THEN
4098: x_return_status := fnd_api.g_ret_sts_error;
4099: WHEN OTHERS THEN
4100: IF g_debug <= gme_debug.g_log_unexpected THEN
4101: gme_debug.put_line ( 'When others exception in '
4102: || g_pkg_name
4103: || '.'
4104: || l_api_name
4105: || ' Error is '