APPS.GME_RESOURCE_ENGINE_PVT dependencies on GME_DEBUG

Line 68: IF g_debug <= gme_debug.g_log_procedure THEN

64: l_line_index BINARY_INTEGER := 1;
65: l_cursor BINARY_INTEGER;
66: l_debug VARCHAR2 (2000);
67: BEGIN
68: IF g_debug <= gme_debug.g_log_procedure THEN
69: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
70: || l_api_name);
71: END IF;
72:

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

65: l_cursor BINARY_INTEGER;
66: l_debug VARCHAR2 (2000);
67: BEGIN
68: IF g_debug <= gme_debug.g_log_procedure THEN
69: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
70: || l_api_name);
71: END IF;
72:
73: /* Initialize API return status to sucess */

Line 119: IF g_debug <= gme_debug.g_log_procedure THEN

115: END LOOP;
116:
117: CLOSE get_rsrc;
118:
119: IF g_debug <= gme_debug.g_log_procedure THEN
120: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
121: END IF;
122: EXCEPTION
123: WHEN fnd_api.g_exc_error THEN

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

116:
117: CLOSE get_rsrc;
118:
119: IF g_debug <= gme_debug.g_log_procedure THEN
120: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
121: END IF;
122: EXCEPTION
123: WHEN fnd_api.g_exc_error THEN
124: x_return_status := fnd_api.g_ret_sts_error;

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

124: x_return_status := fnd_api.g_ret_sts_error;
125: WHEN fnd_api.g_exc_unexpected_error THEN
126: x_return_status := fnd_api.g_ret_sts_unexp_error;
127:
128: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
129: gme_debug.put_line ('IN UN ' || SQLERRM);
130: END IF;
131: WHEN OTHERS THEN
132: IF g_debug <= gme_debug.g_log_unexpected THEN

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

125: WHEN fnd_api.g_exc_unexpected_error THEN
126: x_return_status := fnd_api.g_ret_sts_unexp_error;
127:
128: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
129: gme_debug.put_line ('IN UN ' || SQLERRM);
130: END IF;
131: WHEN OTHERS THEN
132: IF g_debug <= gme_debug.g_log_unexpected THEN
133: gme_debug.put_line ( 'When others exception in '

Line 132: IF g_debug <= gme_debug.g_log_unexpected THEN

128: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
129: gme_debug.put_line ('IN UN ' || SQLERRM);
130: END IF;
131: WHEN OTHERS THEN
132: IF g_debug <= gme_debug.g_log_unexpected THEN
133: gme_debug.put_line ( 'When others exception in '
134: || g_pkg_name
135: || '.'
136: || l_api_name

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

129: gme_debug.put_line ('IN UN ' || SQLERRM);
130: END IF;
131: WHEN OTHERS THEN
132: IF g_debug <= gme_debug.g_log_unexpected THEN
133: gme_debug.put_line ( 'When others exception in '
134: || g_pkg_name
135: || '.'
136: || l_api_name
137: || ' Error is '

Line 167: IF g_debug <= gme_debug.g_log_procedure THEN

163: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_RESOURCE_TRANS';
164: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
165: l_gme_tran_rec gme_resource_txns_gtmp%ROWTYPE;
166: BEGIN
167: IF g_debug <= gme_debug.g_log_procedure THEN
168: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
169: || l_api_name);
170: END IF;
171:

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

164: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
165: l_gme_tran_rec gme_resource_txns_gtmp%ROWTYPE;
166: BEGIN
167: IF g_debug <= gme_debug.g_log_procedure THEN
168: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
169: || l_api_name);
170: END IF;
171:
172: l_gme_tran_rec := p_tran_rec;

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

171:
172: l_gme_tran_rec := p_tran_rec;
173:
174: /* Now Call the INSERT rec DML Layer */
175: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
176: gme_debug.put_line ('Calling Insert Resource TXNS rec');
177: gme_debug.put_line ('Resources +> ' || p_tran_rec.resources);
178: END IF;
179:

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

172: l_gme_tran_rec := p_tran_rec;
173:
174: /* Now Call the INSERT rec DML Layer */
175: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
176: gme_debug.put_line ('Calling Insert Resource TXNS rec');
177: gme_debug.put_line ('Resources +> ' || p_tran_rec.resources);
178: END IF;
179:
180: l_gme_tran_rec.action_code := 'ADD';

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

173:
174: /* Now Call the INSERT rec DML Layer */
175: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
176: gme_debug.put_line ('Calling Insert Resource TXNS rec');
177: gme_debug.put_line ('Resources +> ' || p_tran_rec.resources);
178: END IF;
179:
180: l_gme_tran_rec.action_code := 'ADD';
181:

Line 190: IF g_debug <= gme_debug.g_log_procedure THEN

186: END IF;
187:
188: x_return_status := l_return_status;
189:
190: IF g_debug <= gme_debug.g_log_procedure THEN
191: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
192: END IF;
193: EXCEPTION
194: WHEN fnd_api.g_exc_error THEN

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

187:
188: x_return_status := l_return_status;
189:
190: IF g_debug <= gme_debug.g_log_procedure THEN
191: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
192: END IF;
193: EXCEPTION
194: WHEN fnd_api.g_exc_error THEN
195: x_return_status := fnd_api.g_ret_sts_error;

Line 199: IF g_debug <= gme_debug.g_log_unexpected THEN

195: x_return_status := fnd_api.g_ret_sts_error;
196: WHEN fnd_api.g_exc_unexpected_error THEN
197: x_return_status := fnd_api.g_ret_sts_unexp_error;
198: WHEN OTHERS THEN
199: IF g_debug <= gme_debug.g_log_unexpected THEN
200: gme_debug.put_line ( 'When others exception in '
201: || g_pkg_name
202: || '.'
203: || l_api_name

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

196: WHEN fnd_api.g_exc_unexpected_error THEN
197: x_return_status := fnd_api.g_ret_sts_unexp_error;
198: WHEN OTHERS THEN
199: IF g_debug <= gme_debug.g_log_unexpected THEN
200: gme_debug.put_line ( 'When others exception in '
201: || g_pkg_name
202: || '.'
203: || l_api_name
204: || ' Error is '

Line 232: IF g_debug <= gme_debug.g_log_procedure THEN

228: l_gme_tran_rec gme_resource_txns_gtmp%ROWTYPE;
229: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_RESOURCE_TRANS';
230: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
231: BEGIN
232: IF g_debug <= gme_debug.g_log_procedure THEN
233: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
234: || l_api_name);
235: END IF;
236:

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

229: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_RESOURCE_TRANS';
230: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
231: BEGIN
232: IF g_debug <= gme_debug.g_log_procedure THEN
233: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
234: || l_api_name);
235: END IF;
236:
237: l_gme_tran_rec := p_tran_rec;

Line 253: IF g_debug <= gme_debug.g_log_procedure THEN

249: END IF;
250:
251: x_return_status := l_return_status;
252:
253: IF g_debug <= gme_debug.g_log_procedure THEN
254: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
255: END IF;
256: EXCEPTION
257: WHEN fnd_api.g_exc_error THEN

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

250:
251: x_return_status := l_return_status;
252:
253: IF g_debug <= gme_debug.g_log_procedure THEN
254: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
255: END IF;
256: EXCEPTION
257: WHEN fnd_api.g_exc_error THEN
258: x_return_status := fnd_api.g_ret_sts_error;

Line 262: IF g_debug <= gme_debug.g_log_unexpected THEN

258: x_return_status := fnd_api.g_ret_sts_error;
259: WHEN fnd_api.g_exc_unexpected_error THEN
260: x_return_status := fnd_api.g_ret_sts_unexp_error;
261: WHEN OTHERS THEN
262: IF g_debug <= gme_debug.g_log_unexpected THEN
263: gme_debug.put_line ( 'When others exception in '
264: || g_pkg_name
265: || '.'
266: || l_api_name

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

259: WHEN fnd_api.g_exc_unexpected_error THEN
260: x_return_status := fnd_api.g_ret_sts_unexp_error;
261: WHEN OTHERS THEN
262: IF g_debug <= gme_debug.g_log_unexpected THEN
263: gme_debug.put_line ( 'When others exception in '
264: || g_pkg_name
265: || '.'
266: || l_api_name
267: || ' Error is '

Line 295: IF g_debug <= gme_debug.g_log_procedure THEN

291: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_RESOURCE_TRANS';
292: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
293: l_gme_tran_rec gme_resource_txns_gtmp%ROWTYPE;
294: BEGIN
295: IF g_debug <= gme_debug.g_log_procedure THEN
296: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
297: || l_api_name);
298: END IF;
299:

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

292: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
293: l_gme_tran_rec gme_resource_txns_gtmp%ROWTYPE;
294: BEGIN
295: IF g_debug <= gme_debug.g_log_procedure THEN
296: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
297: || l_api_name);
298: END IF;
299:
300: l_gme_tran_rec := p_tran_rec;

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

303: l_gme_tran_rec.action_code := 'UPD';
304: END IF;
305:
306: /* Now Call the UPDATE rec DML Layer */
307: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
308: gme_debug.put_line ( 'Calling UPDATE rec trans id:'
309: || TO_CHAR (p_tran_rec.poc_trans_id) );
310: END IF;
311:

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

304: END IF;
305:
306: /* Now Call the UPDATE rec DML Layer */
307: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
308: gme_debug.put_line ( 'Calling UPDATE rec trans id:'
309: || TO_CHAR (p_tran_rec.poc_trans_id) );
310: END IF;
311:
312: IF NOT gme_resource_txns_gtmp_dbl.update_row

Line 319: IF g_debug <= gme_debug.g_log_procedure THEN

315: END IF;
316:
317: x_return_status := l_return_status;
318:
319: IF g_debug <= gme_debug.g_log_procedure THEN
320: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
321: END IF;
322: EXCEPTION
323: WHEN fnd_api.g_exc_error THEN

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

316:
317: x_return_status := l_return_status;
318:
319: IF g_debug <= gme_debug.g_log_procedure THEN
320: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
321: END IF;
322: EXCEPTION
323: WHEN fnd_api.g_exc_error THEN
324: x_return_status := fnd_api.g_ret_sts_error;

Line 328: IF g_debug <= gme_debug.g_log_unexpected THEN

324: x_return_status := fnd_api.g_ret_sts_error;
325: WHEN fnd_api.g_exc_unexpected_error THEN
326: x_return_status := fnd_api.g_ret_sts_unexp_error;
327: WHEN OTHERS THEN
328: IF g_debug <= gme_debug.g_log_unexpected THEN
329: gme_debug.put_line ( 'When others exception in '
330: || g_pkg_name
331: || '.'
332: || l_api_name

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

325: WHEN fnd_api.g_exc_unexpected_error THEN
326: x_return_status := fnd_api.g_ret_sts_unexp_error;
327: WHEN OTHERS THEN
328: IF g_debug <= gme_debug.g_log_unexpected THEN
329: gme_debug.put_line ( 'When others exception in '
330: || g_pkg_name
331: || '.'
332: || l_api_name
333: || ' Error is '

Line 415: IF g_debug <= gme_debug.g_log_procedure THEN

411: l_message_count NUMBER;
412: l_message_list VARCHAR2(2000);
413:
414: BEGIN
415: IF g_debug <= gme_debug.g_log_procedure THEN
416: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
417: || l_api_name);
418: END IF;
419:

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

412: l_message_list VARCHAR2(2000);
413:
414: BEGIN
415: IF g_debug <= gme_debug.g_log_procedure THEN
416: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
417: || l_api_name);
418: END IF;
419:
420: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

416: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
417: || l_api_name);
418: END IF;
419:
420: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
421: gme_debug.display_resource_gtmp (NULL, NULL, p_batch_id);
422: END IF;
423:
424: l_debug := 'Doc Id = > ' || p_batch_id;

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

417: || l_api_name);
418: END IF;
419:
420: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
421: gme_debug.display_resource_gtmp (NULL, NULL, p_batch_id);
422: END IF;
423:
424: l_debug := 'Doc Id = > ' || p_batch_id;
425:

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

506: /*Populating the reverse_id of the reversed transaction with the poc_trans_id
507: of the original transaction*/
508: l_prev_rec.reverse_id := l_in_tran_rec.poc_trans_id;
509:
510: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
511: gme_debug.put_line
512: ( g_pkg_name
513: || '.'
514: || l_api_name

Line 511: gme_debug.put_line

507: of the original transaction*/
508: l_prev_rec.reverse_id := l_in_tran_rec.poc_trans_id;
509:
510: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
511: gme_debug.put_line
512: ( g_pkg_name
513: || '.'
514: || l_api_name
515: || ' UPD action code: poc_trans_id of the original transaction is '

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

533: --Bug#4917189 Susruth D. Added below updated to make sure only we update the reverse_id but not any
534: -- other column for the original txn which is reversed.
535: -- l_in_tran_rec.reverse_id := l_prev_rec.poc_trans_id;
536:
537: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
538: gme_debug.put_line
539: ( g_pkg_name
540: || '.'
541: || l_api_name

Line 538: gme_debug.put_line

534: -- other column for the original txn which is reversed.
535: -- l_in_tran_rec.reverse_id := l_prev_rec.poc_trans_id;
536:
537: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
538: gme_debug.put_line
539: ( g_pkg_name
540: || '.'
541: || l_api_name
542: || ' UPD action code: poc_trans_id of the reversal txn is '

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

633: INTO l_in_tran_rec;
634:
635: CLOSE cur_get_prev_rec;
636:
637: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
638: gme_debug.put_line
639: ( g_pkg_name
640: || '.'
641: || l_api_name

Line 638: gme_debug.put_line

634:
635: CLOSE cur_get_prev_rec;
636:
637: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
638: gme_debug.put_line
639: ( g_pkg_name
640: || '.'
641: || l_api_name
642: || ' DEL action code: poc_trans_id of the original transaction is '

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

661: --Bug#4917189 Susruth D. Added below updated to make sure only we update the reverse_id but not any
662: -- other column for the original txn which is reversed.
663: /*l_in_tran_rec.reverse_id := l_tran_rec.poc_trans_id;*/
664:
665: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
666: gme_debug.put_line
667: ( g_pkg_name
668: || '.'
669: || l_api_name

Line 666: gme_debug.put_line

662: -- other column for the original txn which is reversed.
663: /*l_in_tran_rec.reverse_id := l_tran_rec.poc_trans_id;*/
664:
665: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
666: gme_debug.put_line
667: ( g_pkg_name
668: || '.'
669: || l_api_name
670: || ' DEL action code: poc_trans_id of the reversal txn is '

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

706: END IF;
707: END IF;
708: END LOOP;
709:
710: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
711: gme_debug.display_resource_gtmp (NULL, NULL, p_batch_id);
712: END IF;
713:
714: x_return_status := l_return_status;

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

707: END IF;
708: END LOOP;
709:
710: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
711: gme_debug.display_resource_gtmp (NULL, NULL, p_batch_id);
712: END IF;
713:
714: x_return_status := l_return_status;
715:

Line 716: IF g_debug <= gme_debug.g_log_procedure THEN

712: END IF;
713:
714: x_return_status := l_return_status;
715:
716: IF g_debug <= gme_debug.g_log_procedure THEN
717: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
718: END IF;
719: EXCEPTION
720: WHEN fnd_api.g_exc_error THEN

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

713:
714: x_return_status := l_return_status;
715:
716: IF g_debug <= gme_debug.g_log_procedure THEN
717: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
718: END IF;
719: EXCEPTION
720: WHEN fnd_api.g_exc_error THEN
721: x_return_status := fnd_api.g_ret_sts_error;

Line 727: IF g_debug <= gme_debug.g_log_unexpected THEN

723: x_return_status := fnd_api.g_ret_sts_error;
724: WHEN update_failure THEN
725: x_return_status := fnd_api.g_ret_sts_error;
726: WHEN OTHERS THEN
727: IF g_debug <= gme_debug.g_log_unexpected THEN
728: gme_debug.put_line ( 'When others exception in '
729: || g_pkg_name
730: || '.'
731: || l_api_name

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

724: WHEN update_failure THEN
725: x_return_status := fnd_api.g_ret_sts_error;
726: WHEN OTHERS THEN
727: IF g_debug <= gme_debug.g_log_unexpected THEN
728: gme_debug.put_line ( 'When others exception in '
729: || g_pkg_name
730: || '.'
731: || l_api_name
732: || ' Error is '

Line 755: IF g_debug <= gme_debug.g_log_procedure THEN

751: ,p_resource_rec OUT NOCOPY gme_resource_txns%ROWTYPE)
752: IS
753: l_api_name CONSTANT VARCHAR2 (30) := 'build_resource_tran';
754: BEGIN
755: IF g_debug <= gme_debug.g_log_procedure THEN
756: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
757: || l_api_name);
758: END IF;
759:

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

752: IS
753: l_api_name CONSTANT VARCHAR2 (30) := 'build_resource_tran';
754: BEGIN
755: IF g_debug <= gme_debug.g_log_procedure THEN
756: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
757: || l_api_name);
758: END IF;
759:
760: p_resource_rec.organization_id := p_tmp_rec.organization_id;

Line 830: IF g_debug <= gme_debug.g_log_procedure THEN

826:
827:
828:
829:
830: IF g_debug <= gme_debug.g_log_procedure THEN
831: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
832: END IF;
833: --Bug2804440
834: EXCEPTION

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

827:
828:
829:
830: IF g_debug <= gme_debug.g_log_procedure THEN
831: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
832: END IF;
833: --Bug2804440
834: EXCEPTION
835: WHEN OTHERS THEN

Line 836: IF g_debug <= gme_debug.g_log_unexpected THEN

832: END IF;
833: --Bug2804440
834: EXCEPTION
835: WHEN OTHERS THEN
836: IF g_debug <= gme_debug.g_log_unexpected THEN
837: gme_debug.put_line ( 'When others exception in '
838: || g_pkg_name
839: || '.'
840: || l_api_name

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

833: --Bug2804440
834: EXCEPTION
835: WHEN OTHERS THEN
836: IF g_debug <= gme_debug.g_log_unexpected THEN
837: gme_debug.put_line ( 'When others exception in '
838: || g_pkg_name
839: || '.'
840: || l_api_name
841: || ' Error is '

Line 881: IF g_debug <= gme_debug.g_log_procedure THEN

877: l_line_index BINARY_INTEGER := 1;
878: l_cursor BINARY_INTEGER;
879: bad_keys EXCEPTION;
880: BEGIN
881: IF g_debug <= gme_debug.g_log_procedure THEN
882: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
883: || l_api_name);
884: END IF;
885:

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

878: l_cursor BINARY_INTEGER;
879: bad_keys EXCEPTION;
880: BEGIN
881: IF g_debug <= gme_debug.g_log_procedure THEN
882: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
883: || l_api_name);
884: END IF;
885:
886: /* Initialize API return status to sucess */

Line 957: IF g_debug <= gme_debug.g_log_procedure THEN

953: END LOOP;
954:
955: CLOSE get_rsrc;
956:
957: IF g_debug <= gme_debug.g_log_procedure THEN
958: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
959: END IF;
960: EXCEPTION
961: WHEN fnd_api.g_exc_error THEN

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

954:
955: CLOSE get_rsrc;
956:
957: IF g_debug <= gme_debug.g_log_procedure THEN
958: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
959: END IF;
960: EXCEPTION
961: WHEN fnd_api.g_exc_error THEN
962: x_return_status := fnd_api.g_ret_sts_error;

Line 968: IF g_debug <= gme_debug.g_log_unexpected THEN

964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965: WHEN bad_keys THEN
966: x_return_status := fnd_api.g_ret_sts_error;
967: WHEN OTHERS THEN
968: IF g_debug <= gme_debug.g_log_unexpected THEN
969: gme_debug.put_line ( 'When others exception in '
970: || g_pkg_name
971: || '.'
972: || l_api_name

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

965: WHEN bad_keys THEN
966: x_return_status := fnd_api.g_ret_sts_error;
967: WHEN OTHERS THEN
968: IF g_debug <= gme_debug.g_log_unexpected THEN
969: gme_debug.put_line ( 'When others exception in '
970: || g_pkg_name
971: || '.'
972: || l_api_name
973: || ' Error is '

Line 1057: IF g_debug <= gme_debug.g_log_procedure THEN

1053: l_message_count NUMBER;
1054: l_message_list VARCHAR2(2000);
1055:
1056: BEGIN
1057: IF g_debug <= gme_debug.g_log_procedure THEN
1058: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1059: || l_api_name);
1060: END IF;
1061:

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

1054: l_message_list VARCHAR2(2000);
1055:
1056: BEGIN
1057: IF g_debug <= gme_debug.g_log_procedure THEN
1058: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1059: || l_api_name);
1060: END IF;
1061:
1062: /* There is no public layer for this package so adding initialize right here *

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

1059: || l_api_name);
1060: END IF;
1061:
1062: /* There is no public layer for this package so adding initialize right here *
1063: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1064: gme_debug.log_initialize('RESOURCE_TXN');
1065: END IF;
1066:
1067: /* Initialize return status to success */

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

1060: END IF;
1061:
1062: /* There is no public layer for this package so adding initialize right here *
1063: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1064: gme_debug.log_initialize('RESOURCE_TXN');
1065: END IF;
1066:
1067: /* Initialize return status to success */
1068: x_return_status := fnd_api.g_ret_sts_success;

Line 1355: IF g_debug <= gme_debug.g_log_procedure THEN

1351: END IF; /*action code check */
1352: END IF; /*p_step_resources_rec.capacity_constraint = 1 */
1353: /*Bug#5231180 End */
1354:
1355: IF g_debug <= gme_debug.g_log_procedure THEN
1356: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1357: END IF;
1358: EXCEPTION
1359: WHEN gmf_cost_failure THEN

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

1352: END IF; /*p_step_resources_rec.capacity_constraint = 1 */
1353: /*Bug#5231180 End */
1354:
1355: IF g_debug <= gme_debug.g_log_procedure THEN
1356: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1357: END IF;
1358: EXCEPTION
1359: WHEN gmf_cost_failure THEN
1360: -- Bug 5903208

Line 1366: IF g_debug <= gme_debug.g_log_unexpected THEN

1362:
1363: WHEN fnd_api.g_exc_error THEN
1364: x_return_status := fnd_api.g_ret_sts_error;
1365: WHEN OTHERS THEN
1366: IF g_debug <= gme_debug.g_log_unexpected THEN
1367: gme_debug.put_line ( 'When others exception in '
1368: || g_pkg_name
1369: || '.'
1370: || l_api_name

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

1363: WHEN fnd_api.g_exc_error THEN
1364: x_return_status := fnd_api.g_ret_sts_error;
1365: WHEN OTHERS THEN
1366: IF g_debug <= gme_debug.g_log_unexpected THEN
1367: gme_debug.put_line ( 'When others exception in '
1368: || g_pkg_name
1369: || '.'
1370: || l_api_name
1371: || ' Error is '

Line 1403: IF g_debug <= gme_debug.g_log_procedure THEN

1399: ,x_return_status OUT NOCOPY VARCHAR2)
1400: IS
1401: l_api_name CONSTANT VARCHAR2 (30) := 'validate_resource';
1402: BEGIN
1403: IF g_debug <= gme_debug.g_log_procedure THEN
1404: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1405: || l_api_name);
1406: END IF;
1407:

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

1400: IS
1401: l_api_name CONSTANT VARCHAR2 (30) := 'validate_resource';
1402: BEGIN
1403: IF g_debug <= gme_debug.g_log_procedure THEN
1404: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1405: || l_api_name);
1406: END IF;
1407:
1408: /* Initialize return status to success */

Line 1529: IF g_debug <= gme_debug.g_log_procedure THEN

1525: check_primary_resource (p_step_resources_rec => p_step_resources_rec
1526: ,x_return_status => x_return_status);
1527: END IF;
1528: */
1529: IF g_debug <= gme_debug.g_log_procedure THEN
1530: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1531: END IF;
1532: EXCEPTION
1533: WHEN fnd_api.g_exc_error THEN

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

1526: ,x_return_status => x_return_status);
1527: END IF;
1528: */
1529: IF g_debug <= gme_debug.g_log_procedure THEN
1530: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1531: END IF;
1532: EXCEPTION
1533: WHEN fnd_api.g_exc_error THEN
1534: x_return_status := fnd_api.g_ret_sts_error;

Line 1536: IF g_debug <= gme_debug.g_log_unexpected THEN

1532: EXCEPTION
1533: WHEN fnd_api.g_exc_error THEN
1534: x_return_status := fnd_api.g_ret_sts_error;
1535: WHEN OTHERS THEN
1536: IF g_debug <= gme_debug.g_log_unexpected THEN
1537: gme_debug.put_line ( 'When others exception in '
1538: || g_pkg_name
1539: || '.'
1540: || l_api_name

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

1533: WHEN fnd_api.g_exc_error THEN
1534: x_return_status := fnd_api.g_ret_sts_error;
1535: WHEN OTHERS THEN
1536: IF g_debug <= gme_debug.g_log_unexpected THEN
1537: gme_debug.put_line ( 'When others exception in '
1538: || g_pkg_name
1539: || '.'
1540: || l_api_name
1541: || ' Error is '

Line 1604: IF g_debug <= gme_debug.g_log_procedure THEN

1600: l_step_id gme_batch_steps.batchstep_id%TYPE;
1601: --Rishi 3446787/3020345 end
1602: l_count NUMBER (5);
1603: BEGIN
1604: IF g_debug <= gme_debug.g_log_procedure THEN
1605: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1606: || l_api_name);
1607: END IF;
1608:

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

1601: --Rishi 3446787/3020345 end
1602: l_count NUMBER (5);
1603: BEGIN
1604: IF g_debug <= gme_debug.g_log_procedure THEN
1605: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1606: || l_api_name);
1607: END IF;
1608:
1609: /* Initialize return status to success */

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

1639:
1640: CLOSE cur_get_batchstep_no;
1641:
1642: --Rishi 3446787/3020345 end
1643: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1644: gme_debug.put_line ( ' Activity:'
1645: || p_step_resources_rec.batchstep_activity_id
1646: || ' Resource:'
1647: || p_step_resources_rec.batchstep_resource_id

Line 1644: gme_debug.put_line ( ' Activity:'

1640: CLOSE cur_get_batchstep_no;
1641:
1642: --Rishi 3446787/3020345 end
1643: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1644: gme_debug.put_line ( ' Activity:'
1645: || p_step_resources_rec.batchstep_activity_id
1646: || ' Resource:'
1647: || p_step_resources_rec.batchstep_resource_id
1648: || ' Count:'

Line 1668: IF g_debug <= gme_debug.g_log_procedure THEN

1664: fnd_msg_pub.ADD;
1665: RAISE fnd_api.g_exc_error;
1666: END IF;
1667:
1668: IF g_debug <= gme_debug.g_log_procedure THEN
1669: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1670: END IF;
1671: EXCEPTION
1672: WHEN fnd_api.g_exc_error THEN

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

1665: RAISE fnd_api.g_exc_error;
1666: END IF;
1667:
1668: IF g_debug <= gme_debug.g_log_procedure THEN
1669: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1670: END IF;
1671: EXCEPTION
1672: WHEN fnd_api.g_exc_error THEN
1673: x_return_status := fnd_api.g_ret_sts_error;

Line 1675: IF g_debug <= gme_debug.g_log_unexpected THEN

1671: EXCEPTION
1672: WHEN fnd_api.g_exc_error THEN
1673: x_return_status := fnd_api.g_ret_sts_error;
1674: WHEN OTHERS THEN
1675: IF g_debug <= gme_debug.g_log_unexpected THEN
1676: gme_debug.put_line ( 'When others exception in '
1677: || g_pkg_name
1678: || '.'
1679: || l_api_name

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

1672: WHEN fnd_api.g_exc_error THEN
1673: x_return_status := fnd_api.g_ret_sts_error;
1674: WHEN OTHERS THEN
1675: IF g_debug <= gme_debug.g_log_unexpected THEN
1676: gme_debug.put_line ( 'When others exception in '
1677: || g_pkg_name
1678: || '.'
1679: || l_api_name
1680: || ' Error is '

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

1734: FOR batchsteps IN cur_get_batch_steps LOOP
1735: FOR activities IN
1736: cur_get_batchstep_activities (p_batch_id
1737: ,batchsteps.batchstep_id) LOOP
1738: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1739: gme_debug.put_line ( ' Activity:'
1740: || activities.batchstep_activity_id);
1741: END IF;
1742:

Line 1739: gme_debug.put_line ( ' Activity:'

1735: FOR activities IN
1736: cur_get_batchstep_activities (p_batch_id
1737: ,batchsteps.batchstep_id) LOOP
1738: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1739: gme_debug.put_line ( ' Activity:'
1740: || activities.batchstep_activity_id);
1741: END IF;
1742:
1743: OPEN cur_get_prim_rsrc_count (activities.batchstep_activity_id);

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

1746: INTO l_count;
1747:
1748: CLOSE cur_get_prim_rsrc_count;
1749:
1750: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1751: gme_debug.put_line (' Count:' || l_count);
1752: END IF;
1753:
1754: IF (l_count > 1) THEN

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

1747:
1748: CLOSE cur_get_prim_rsrc_count;
1749:
1750: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1751: gme_debug.put_line (' Count:' || l_count);
1752: END IF;
1753:
1754: IF (l_count > 1) THEN
1755: fnd_message.set_name ('GME', 'GME_ONE_PRIM_RSRC');

Line 1819: IF g_debug <= gme_debug.g_log_procedure THEN

1815:
1816: l_status NUMBER (5);
1817: l_tot_usage NUMBER;
1818: BEGIN
1819: IF g_debug <= gme_debug.g_log_procedure THEN
1820: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1821: || l_api_name);
1822: END IF;
1823:

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

1816: l_status NUMBER (5);
1817: l_tot_usage NUMBER;
1818: BEGIN
1819: IF g_debug <= gme_debug.g_log_procedure THEN
1820: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1821: || l_api_name);
1822: END IF;
1823:
1824: /* Initialize return status to success */

Line 1862: IF g_debug <= gme_debug.g_log_procedure THEN

1858:
1859: x_step_resources_rec.actual_rsrc_usage := l_tot_usage;
1860: END IF;
1861:
1862: IF g_debug <= gme_debug.g_log_procedure THEN
1863: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1864: END IF;
1865: EXCEPTION
1866: WHEN fnd_api.g_exc_error THEN

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

1859: x_step_resources_rec.actual_rsrc_usage := l_tot_usage;
1860: END IF;
1861:
1862: IF g_debug <= gme_debug.g_log_procedure THEN
1863: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1864: END IF;
1865: EXCEPTION
1866: WHEN fnd_api.g_exc_error THEN
1867: x_return_status := fnd_api.g_ret_sts_error;

Line 1869: IF g_debug <= gme_debug.g_log_unexpected THEN

1865: EXCEPTION
1866: WHEN fnd_api.g_exc_error THEN
1867: x_return_status := fnd_api.g_ret_sts_error;
1868: WHEN OTHERS THEN
1869: IF g_debug <= gme_debug.g_log_unexpected THEN
1870: gme_debug.put_line ( 'When others exception in '
1871: || g_pkg_name
1872: || '.'
1873: || l_api_name

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

1866: WHEN fnd_api.g_exc_error THEN
1867: x_return_status := fnd_api.g_ret_sts_error;
1868: WHEN OTHERS THEN
1869: IF g_debug <= gme_debug.g_log_unexpected THEN
1870: gme_debug.put_line ( 'When others exception in '
1871: || g_pkg_name
1872: || '.'
1873: || l_api_name
1874: || ' Error is '

Line 2066: IF g_debug <= gme_debug.g_log_procedure THEN

2062: asqc_update_rsrc_api_error EXCEPTION;
2063: asqc_ovrd_end_txn_api_error EXCEPTION;
2064: rtxn_for_updinv_not_allowed EXCEPTION;
2065: BEGIN
2066: IF g_debug <= gme_debug.g_log_procedure THEN
2067: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2068: || l_api_name);
2069: END IF;
2070:

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

2063: asqc_ovrd_end_txn_api_error EXCEPTION;
2064: rtxn_for_updinv_not_allowed EXCEPTION;
2065: BEGIN
2066: IF g_debug <= gme_debug.g_log_procedure THEN
2067: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2068: || l_api_name);
2069: END IF;
2070:
2071: /* Initially let us assign the return status to success */

Line 2436: IF g_debug <= gme_debug.g_log_procedure THEN

2432: END IF;
2433:
2434: x_batch_header_rec := l_batch_header;
2435:
2436: IF g_debug <= gme_debug.g_log_procedure THEN
2437: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2438: END IF;
2439: EXCEPTION
2440: 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 2437: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

2433:
2434: x_batch_header_rec := l_batch_header;
2435:
2436: IF g_debug <= gme_debug.g_log_procedure THEN
2437: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2438: END IF;
2439: EXCEPTION
2440: 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
2441: x_return_status := fnd_api.g_ret_sts_error;

Line 2457: IF g_debug <= gme_debug.g_log_unexpected THEN

2453: fnd_message.set_name ('GMA', 'SY_REASONCODE');
2454: fnd_msg_pub.ADD;
2455: x_return_status := fnd_api.g_ret_sts_error;
2456: WHEN OTHERS THEN
2457: IF g_debug <= gme_debug.g_log_unexpected THEN
2458: gme_debug.put_line ( 'When others exception in '
2459: || g_pkg_name
2460: || '.'
2461: || l_api_name

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

2454: fnd_msg_pub.ADD;
2455: x_return_status := fnd_api.g_ret_sts_error;
2456: WHEN OTHERS THEN
2457: IF g_debug <= gme_debug.g_log_unexpected THEN
2458: gme_debug.put_line ( 'When others exception in '
2459: || g_pkg_name
2460: || '.'
2461: || l_api_name
2462: || ' Error is '

Line 2538: IF g_debug <= gme_debug.g_log_procedure THEN

2534: rsrc_txn_insert_err EXCEPTION;
2535: error_load_trans EXCEPTION;
2536: update_rsrc_txn_err EXCEPTION;
2537: BEGIN
2538: IF g_debug <= gme_debug.g_log_procedure THEN
2539: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2540: || l_api_name);
2541: END IF;
2542:

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

2535: error_load_trans EXCEPTION;
2536: update_rsrc_txn_err EXCEPTION;
2537: BEGIN
2538: IF g_debug <= gme_debug.g_log_procedure THEN
2539: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2540: || l_api_name);
2541: END IF;
2542:
2543: /* Initially let us assign the return status to success */

Line 2560: IF g_debug <= gme_debug.g_log_procedure THEN

2556: RAISE validation_failure;
2557: END IF;
2558: --END IF;
2559:
2560: IF g_debug <= gme_debug.g_log_procedure THEN
2561: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
2562: || g_pkg_name
2563: || '.'
2564: || l_api_name);

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

2557: END IF;
2558: --END IF;
2559:
2560: IF g_debug <= gme_debug.g_log_procedure THEN
2561: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
2562: || g_pkg_name
2563: || '.'
2564: || l_api_name);
2565: END IF;

Line 2590: IF g_debug <= gme_debug.g_log_procedure THEN

2586: ,x_reason_id => l_reason_id
2587: ,x_return_status => x_return_status
2588: ,x_trans_date => l_trans_date);
2589:
2590: IF g_debug <= gme_debug.g_log_procedure THEN
2591: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
2592: || g_pkg_name
2593: || '.'
2594: || l_api_name);

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

2587: ,x_return_status => x_return_status
2588: ,x_trans_date => l_trans_date);
2589:
2590: IF g_debug <= gme_debug.g_log_procedure THEN
2591: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
2592: || g_pkg_name
2593: || '.'
2594: || l_api_name);
2595: END IF;

Line 2617: IF g_debug <= gme_debug.g_log_statement THEN

2613:
2614: IF l_return_status <> x_return_status THEN
2615: RAISE error_load_trans;
2616: END IF;
2617: IF g_debug <= gme_debug.g_log_statement THEN
2618: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Transactions Loaded '||l_rsrc_trans_count);
2619: END IF;
2620:
2621: l_rsrc_txn_rec.line_id := l_line_id;

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

2614: IF l_return_status <> x_return_status THEN
2615: RAISE error_load_trans;
2616: END IF;
2617: IF g_debug <= gme_debug.g_log_statement THEN
2618: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Transactions Loaded '||l_rsrc_trans_count);
2619: END IF;
2620:
2621: l_rsrc_txn_rec.line_id := l_line_id;
2622: gme_resource_engine_pvt.fetch_active_resources

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

2710: ,l_rsrc_txn_rec) ) THEN
2711: RAISE rsrc_txn_insert_err;
2712: END IF;
2713:
2714: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2715: --Rishi Varma 3896510/3865212
2716: /*Replaced hardcoded value '157' for batch_id with l_batch_header.batch_id*/
2717: gme_debug.display_resource_gtmp (NULL, NULL
2718: ,l_batch_header.batch_id);

Line 2717: gme_debug.display_resource_gtmp (NULL, NULL

2713:
2714: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2715: --Rishi Varma 3896510/3865212
2716: /*Replaced hardcoded value '157' for batch_id with l_batch_header.batch_id*/
2717: gme_debug.display_resource_gtmp (NULL, NULL
2718: ,l_batch_header.batch_id);
2719: END IF;
2720:
2721: l_step_resources.batchstep_resource_id := l_rsrc_txn_rec.line_id;

Line 2741: IF g_debug <= gme_debug.g_log_procedure THEN

2737: x_rsrc_txn_rec.poc_trans_id := l_rsrc_txn_rec.poc_trans_id;
2738: x_rsrc_txn_rec.doc_id := l_rsrc_txn_rec.doc_id;
2739: x_rsrc_txn_rec.line_id := l_rsrc_txn_rec.line_id;
2740:
2741: IF g_debug <= gme_debug.g_log_procedure THEN
2742: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2743: END IF;
2744: EXCEPTION
2745: WHEN validation_failure OR error_load_trans THEN

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

2738: x_rsrc_txn_rec.doc_id := l_rsrc_txn_rec.doc_id;
2739: x_rsrc_txn_rec.line_id := l_rsrc_txn_rec.line_id;
2740:
2741: IF g_debug <= gme_debug.g_log_procedure THEN
2742: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2743: END IF;
2744: EXCEPTION
2745: WHEN validation_failure OR error_load_trans THEN
2746: x_return_status := fnd_api.g_ret_sts_error;

Line 2752: IF g_debug <= gme_debug.g_log_unexpected THEN

2748: x_return_status := fnd_api.g_ret_sts_error;
2749: WHEN rsrc_fetch_err OR rsrc_update_err THEN
2750: x_return_status := fnd_api.g_ret_sts_error;
2751: WHEN OTHERS THEN
2752: IF g_debug <= gme_debug.g_log_unexpected THEN
2753: gme_debug.put_line ( 'When others exception in '
2754: || g_pkg_name
2755: || '.'
2756: || l_api_name

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

2749: WHEN rsrc_fetch_err OR rsrc_update_err THEN
2750: x_return_status := fnd_api.g_ret_sts_error;
2751: WHEN OTHERS THEN
2752: IF g_debug <= gme_debug.g_log_unexpected THEN
2753: gme_debug.put_line ( 'When others exception in '
2754: || g_pkg_name
2755: || '.'
2756: || l_api_name
2757: || ' Error is '

Line 2837: IF g_debug <= gme_debug.g_log_procedure THEN

2833: rsrc_txn_insert_err EXCEPTION;
2834: reduce_pend_usage_err EXCEPTION;
2835: error_load_trans EXCEPTION;
2836: BEGIN
2837: IF g_debug <= gme_debug.g_log_procedure THEN
2838: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2839: || l_api_name);
2840: END IF;
2841:

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

2834: reduce_pend_usage_err EXCEPTION;
2835: error_load_trans EXCEPTION;
2836: BEGIN
2837: IF g_debug <= gme_debug.g_log_procedure THEN
2838: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
2839: || l_api_name);
2840: END IF;
2841:
2842: /* Initially let us assign the return status to success */

Line 2861: IF g_debug <= gme_debug.g_log_procedure THEN

2857: --END IF;
2858:
2859: l_rsrc_txn_rec := x_rsrc_txn_rec;
2860:
2861: IF g_debug <= gme_debug.g_log_procedure THEN
2862: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
2863: || g_pkg_name
2864: || '.'
2865: || l_api_name);

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

2858:
2859: l_rsrc_txn_rec := x_rsrc_txn_rec;
2860:
2861: IF g_debug <= gme_debug.g_log_procedure THEN
2862: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
2863: || g_pkg_name
2864: || '.'
2865: || l_api_name);
2866: END IF;

Line 2891: IF g_debug <= gme_debug.g_log_procedure THEN

2887: ,x_reason_id => l_reason_id
2888: ,x_return_status => x_return_status
2889: ,x_trans_date => l_trans_date);
2890:
2891: IF g_debug <= gme_debug.g_log_procedure THEN
2892: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
2893: || g_pkg_name
2894: || '.'
2895: || l_api_name);

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

2888: ,x_return_status => x_return_status
2889: ,x_trans_date => l_trans_date);
2890:
2891: IF g_debug <= gme_debug.g_log_procedure THEN
2892: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
2893: || g_pkg_name
2894: || '.'
2895: || l_api_name);
2896: END IF;

Line 2993: IF g_debug <= gme_debug.g_log_procedure THEN

2989:
2990: --22APR02 Pawan Kumar bug 2912743 added poc_trans_id
2991: -- Assigning the value of poc_trans_id
2992: ---x_poc_trans_id := l_resource_txns.poc_trans_id;
2993: IF g_debug <= gme_debug.g_log_procedure THEN
2994: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2995: END IF;
2996: EXCEPTION
2997: WHEN validation_failure OR error_load_trans OR rsrc_txn_insert_err THEN

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

2990: --22APR02 Pawan Kumar bug 2912743 added poc_trans_id
2991: -- Assigning the value of poc_trans_id
2992: ---x_poc_trans_id := l_resource_txns.poc_trans_id;
2993: IF g_debug <= gme_debug.g_log_procedure THEN
2994: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2995: END IF;
2996: EXCEPTION
2997: WHEN validation_failure OR error_load_trans OR rsrc_txn_insert_err THEN
2998: x_return_status := fnd_api.g_ret_sts_error;

Line 3002: IF g_debug <= gme_debug.g_log_unexpected THEN

2998: x_return_status := fnd_api.g_ret_sts_error;
2999: WHEN rsrc_fetch_err OR rsrc_update_err OR reduce_pend_usage_err THEN
3000: x_return_status := fnd_api.g_ret_sts_error;
3001: WHEN OTHERS THEN
3002: IF g_debug <= gme_debug.g_log_unexpected THEN
3003: gme_debug.put_line ( 'When others exception in '
3004: || g_pkg_name
3005: || '.'
3006: || l_api_name

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

2999: WHEN rsrc_fetch_err OR rsrc_update_err OR reduce_pend_usage_err THEN
3000: x_return_status := fnd_api.g_ret_sts_error;
3001: WHEN OTHERS THEN
3002: IF g_debug <= gme_debug.g_log_unexpected THEN
3003: gme_debug.put_line ( 'When others exception in '
3004: || g_pkg_name
3005: || '.'
3006: || l_api_name
3007: || ' Error is '

Line 3092: IF g_debug <= gme_debug.g_log_procedure THEN

3088: rsrc_txn_insert_err EXCEPTION;
3089: reduce_pend_usage_err EXCEPTION;
3090: error_load_trans EXCEPTION;
3091: BEGIN
3092: IF g_debug <= gme_debug.g_log_procedure THEN
3093: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3094: || l_api_name);
3095: END IF;
3096:

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

3089: reduce_pend_usage_err EXCEPTION;
3090: error_load_trans EXCEPTION;
3091: BEGIN
3092: IF g_debug <= gme_debug.g_log_procedure THEN
3093: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3094: || l_api_name);
3095: END IF;
3096:
3097: /* Initially let us assign the return status to success */

Line 3115: IF g_debug <= gme_debug.g_log_procedure THEN

3111: END IF;
3112: --END IF;
3113: l_rsrc_txn_rec := x_rsrc_txn_rec;
3114:
3115: IF g_debug <= gme_debug.g_log_procedure THEN
3116: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
3117: || g_pkg_name
3118: || '.'
3119: || l_api_name);

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

3112: --END IF;
3113: l_rsrc_txn_rec := x_rsrc_txn_rec;
3114:
3115: IF g_debug <= gme_debug.g_log_procedure THEN
3116: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
3117: || g_pkg_name
3118: || '.'
3119: || l_api_name);
3120: END IF;

Line 3147: IF g_debug <= gme_debug.g_log_procedure THEN

3143: ,
3144: --Rishi Varma B3856541 02-09-2004
3145: x_trans_date => l_trans_date);
3146:
3147: IF g_debug <= gme_debug.g_log_procedure THEN
3148: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
3149: || g_pkg_name
3150: || '.'
3151: || l_api_name);

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

3144: --Rishi Varma B3856541 02-09-2004
3145: x_trans_date => l_trans_date);
3146:
3147: IF g_debug <= gme_debug.g_log_procedure THEN
3148: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
3149: || g_pkg_name
3150: || '.'
3151: || l_api_name);
3152: END IF;

Line 3290: IF g_debug <= gme_debug.g_log_procedure THEN

3286: --22APR02 Pawan Kumar bug 2912743 added poc_trans_id
3287: -- Assigning the value of poc_trans_id
3288:
3289: ---x_poc_trans_id := l_resource_txns.poc_trans_id;
3290: IF g_debug <= gme_debug.g_log_procedure THEN
3291: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3292: END IF;
3293: EXCEPTION
3294: WHEN validation_failure OR missing_profile_option OR error_load_trans OR rsrc_txn_insert_err THEN

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

3287: -- Assigning the value of poc_trans_id
3288:
3289: ---x_poc_trans_id := l_resource_txns.poc_trans_id;
3290: IF g_debug <= gme_debug.g_log_procedure THEN
3291: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3292: END IF;
3293: EXCEPTION
3294: WHEN validation_failure OR missing_profile_option OR error_load_trans OR rsrc_txn_insert_err THEN
3295: x_return_status := fnd_api.g_ret_sts_error;

Line 3301: IF g_debug <= gme_debug.g_log_unexpected THEN

3297: x_return_status := fnd_api.g_ret_sts_error;
3298: WHEN uom_conversion_err THEN
3299: x_return_status := fnd_api.g_ret_sts_error;
3300: WHEN OTHERS THEN
3301: IF g_debug <= gme_debug.g_log_unexpected THEN
3302: gme_debug.put_line ( 'When others exception in '
3303: || g_pkg_name
3304: || '.'
3305: || l_api_name

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

3298: WHEN uom_conversion_err THEN
3299: x_return_status := fnd_api.g_ret_sts_error;
3300: WHEN OTHERS THEN
3301: IF g_debug <= gme_debug.g_log_unexpected THEN
3302: gme_debug.put_line ( 'When others exception in '
3303: || g_pkg_name
3304: || '.'
3305: || l_api_name
3306: || ' Error is '

Line 3368: IF g_debug <= gme_debug.g_log_procedure THEN

3364: l_trans_date DATE;
3365: validation_failure EXCEPTION;
3366: rsrc_txn_insert_err EXCEPTION;
3367: BEGIN
3368: IF g_debug <= gme_debug.g_log_procedure THEN
3369: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3370: || l_api_name);
3371: END IF;
3372:

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

3365: validation_failure EXCEPTION;
3366: rsrc_txn_insert_err EXCEPTION;
3367: BEGIN
3368: IF g_debug <= gme_debug.g_log_procedure THEN
3369: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3370: || l_api_name);
3371: END IF;
3372:
3373: /* Initially let us assign the return status to success */

Line 3396: IF g_debug <= gme_debug.g_log_procedure THEN

3392:
3393: /* Initially let us assign the return status to success */
3394: l_return_status := fnd_api.g_ret_sts_success;
3395:
3396: IF g_debug <= gme_debug.g_log_procedure THEN
3397: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
3398: || g_pkg_name
3399: || '.'
3400: || l_api_name);

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

3393: /* Initially let us assign the return status to success */
3394: l_return_status := fnd_api.g_ret_sts_success;
3395:
3396: IF g_debug <= gme_debug.g_log_procedure THEN
3397: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
3398: || g_pkg_name
3399: || '.'
3400: || l_api_name);
3401: END IF;

Line 3426: IF g_debug <= gme_debug.g_log_procedure THEN

3422: ,x_reason_id => l_reason_id
3423: ,x_return_status => l_return_status
3424: ,x_trans_date => l_trans_date);
3425:
3426: IF g_debug <= gme_debug.g_log_procedure THEN
3427: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
3428: || g_pkg_name
3429: || '.'
3430: || l_api_name);

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

3423: ,x_return_status => l_return_status
3424: ,x_trans_date => l_trans_date);
3425:
3426: IF g_debug <= gme_debug.g_log_procedure THEN
3427: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
3428: || g_pkg_name
3429: || '.'
3430: || l_api_name);
3431: END IF;

Line 3457: IF g_debug <= gme_debug.g_log_procedure THEN

3453: l_rsrc_txn_rec.resources := l_resources;
3454: l_rsrc_txn_rec.resource_usage := 0;
3455: l_rsrc_txn_rec.trans_qty_um := l_usage_uom;
3456:
3457: IF g_debug <= gme_debug.g_log_procedure THEN
3458: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_trans_date ' || l_trans_date);
3459: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrc_txn_rec.trans_date ' || p_rsrc_txn_rec.trans_date);
3460: END IF;
3461:

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

3454: l_rsrc_txn_rec.resource_usage := 0;
3455: l_rsrc_txn_rec.trans_qty_um := l_usage_uom;
3456:
3457: IF g_debug <= gme_debug.g_log_procedure THEN
3458: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_trans_date ' || l_trans_date);
3459: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrc_txn_rec.trans_date ' || p_rsrc_txn_rec.trans_date);
3460: END IF;
3461:
3462: IF l_trans_date IS NOT NULL THEN

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

3455: l_rsrc_txn_rec.trans_qty_um := l_usage_uom;
3456:
3457: IF g_debug <= gme_debug.g_log_procedure THEN
3458: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_trans_date ' || l_trans_date);
3459: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrc_txn_rec.trans_date ' || p_rsrc_txn_rec.trans_date);
3460: END IF;
3461:
3462: IF l_trans_date IS NOT NULL THEN
3463: l_rsrc_txn_rec.trans_date := l_trans_date;

Line 3494: IF g_debug <= gme_debug.g_log_procedure THEN

3490: ,x_rsrc_txn_rec) ) THEN
3491: RAISE rsrc_txn_insert_err;
3492: END IF;
3493:
3494: IF g_debug <= gme_debug.g_log_procedure THEN
3495: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name|| ' with return status '||x_return_status);
3496: END IF;
3497: EXCEPTION
3498: WHEN validation_failure OR rsrc_txn_insert_err THEN

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

3491: RAISE rsrc_txn_insert_err;
3492: END IF;
3493:
3494: IF g_debug <= gme_debug.g_log_procedure THEN
3495: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name|| ' with return status '||x_return_status);
3496: END IF;
3497: EXCEPTION
3498: WHEN validation_failure OR rsrc_txn_insert_err THEN
3499: x_return_status := fnd_api.g_ret_sts_error;

Line 3501: IF g_debug <= gme_debug.g_log_unexpected THEN

3497: EXCEPTION
3498: WHEN validation_failure OR rsrc_txn_insert_err THEN
3499: x_return_status := fnd_api.g_ret_sts_error;
3500: WHEN OTHERS THEN
3501: IF g_debug <= gme_debug.g_log_unexpected THEN
3502: gme_debug.put_line ( 'When others exception in '
3503: || g_pkg_name
3504: || '.'
3505: || l_api_name

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

3498: WHEN validation_failure OR rsrc_txn_insert_err THEN
3499: x_return_status := fnd_api.g_ret_sts_error;
3500: WHEN OTHERS THEN
3501: IF g_debug <= gme_debug.g_log_unexpected THEN
3502: gme_debug.put_line ( 'When others exception in '
3503: || g_pkg_name
3504: || '.'
3505: || l_api_name
3506: || ' Error is '

Line 3595: IF g_debug <= gme_debug.g_log_procedure THEN

3591: invalid_txn_for_end EXCEPTION;
3592: expected_error EXCEPTION;
3593: rsrc_txn_ins_err EXCEPTION;
3594: BEGIN
3595: IF g_debug <= gme_debug.g_log_procedure THEN
3596: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3597: || l_api_name);
3598: END IF;
3599:

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

3592: expected_error EXCEPTION;
3593: rsrc_txn_ins_err EXCEPTION;
3594: BEGIN
3595: IF g_debug <= gme_debug.g_log_procedure THEN
3596: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3597: || l_api_name);
3598: END IF;
3599:
3600: /* Initially let us assign the return status to success */

Line 3721: IF g_debug <= gme_debug.g_log_procedure THEN

3717: l_instance_id := p_rsrc_txn_rec.instance_id;
3718: END IF;
3719: /* siva end */
3720:
3721: IF g_debug <= gme_debug.g_log_procedure THEN
3722: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
3723: || g_pkg_name
3724: || '.'
3725: || l_api_name);

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

3718: END IF;
3719: /* siva end */
3720:
3721: IF g_debug <= gme_debug.g_log_procedure THEN
3722: gme_debug.put_line ( 'before calling validate_rsrc_txn_param '
3723: || g_pkg_name
3724: || '.'
3725: || l_api_name);
3726: END IF;

Line 3752: IF g_debug <= gme_debug.g_log_procedure THEN

3748: ,x_reason_id => x_reason_id
3749: ,x_return_status => x_return_status
3750: ,x_trans_date => x_trans_date);
3751:
3752: IF g_debug <= gme_debug.g_log_procedure THEN
3753: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
3754: || g_pkg_name
3755: || '.'
3756: || l_api_name);

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

3749: ,x_return_status => x_return_status
3750: ,x_trans_date => x_trans_date);
3751:
3752: IF g_debug <= gme_debug.g_log_procedure THEN
3753: gme_debug.put_line ( 'after calling validate_rsrc_txn_param '
3754: || g_pkg_name
3755: || '.'
3756: || l_api_name);
3757: END IF;

Line 3807: IF g_debug <= gme_debug.g_log_procedure THEN

3803: l_rsrc_txn_rec.attribute30 := x_rsrc_txn_rec.attribute30;
3804: -- END IF;
3805:
3806: --Begin Bug#3479669
3807: IF g_debug <= gme_debug.g_log_procedure THEN
3808: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3809: || l_api_name);
3810: END IF;
3811:

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

3804: -- END IF;
3805:
3806: --Begin Bug#3479669
3807: IF g_debug <= gme_debug.g_log_procedure THEN
3808: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
3809: || l_api_name);
3810: END IF;
3811:
3812: IF l_rsrc_txn_rec.posted_ind = 1 THEN

Line 3830: IF g_debug <= gme_debug.g_log_procedure THEN

3826:
3827: x_rsrc_txn_rec := l_rsrc_txn_rec ;
3828:
3829: --Begin Bug#3479669
3830: IF g_debug <= gme_debug.g_log_procedure THEN
3831: gme_debug.put_line ( 'Entering api '
3832: || g_pkg_name
3833: || '.'
3834: || l_api_name);

Line 3831: gme_debug.put_line ( 'Entering api '

3827: x_rsrc_txn_rec := l_rsrc_txn_rec ;
3828:
3829: --Begin Bug#3479669
3830: IF g_debug <= gme_debug.g_log_procedure THEN
3831: gme_debug.put_line ( 'Entering api '
3832: || g_pkg_name
3833: || '.'
3834: || l_api_name);
3835: END IF;

Line 3887: IF g_debug <= gme_debug.g_log_procedure THEN

3883: (p_batch_step_resources => l_step_resources) THEN
3884: RAISE rsrc_update_err;
3885: END IF;
3886:
3887: IF g_debug <= gme_debug.g_log_procedure THEN
3888: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3889: END IF;
3890: EXCEPTION
3891: WHEN expected_error OR missing_profile_option THEN

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

3884: RAISE rsrc_update_err;
3885: END IF;
3886:
3887: IF g_debug <= gme_debug.g_log_procedure THEN
3888: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
3889: END IF;
3890: EXCEPTION
3891: WHEN expected_error OR missing_profile_option THEN
3892: x_return_status := fnd_api.g_ret_sts_error;

Line 3905: IF g_debug <= gme_debug.g_log_unexpected THEN

3901: x_return_status := fnd_api.g_ret_sts_error;
3902: WHEN rsrc_fetch_err OR rsrc_txn_fetch_err OR rsrc_update_err OR reduce_pend_usage_err THEN
3903: x_return_status := fnd_api.g_ret_sts_error;
3904: WHEN OTHERS THEN
3905: IF g_debug <= gme_debug.g_log_unexpected THEN
3906: gme_debug.put_line ( 'When others exception in '
3907: || g_pkg_name
3908: || '.'
3909: || l_api_name

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

3902: WHEN rsrc_fetch_err OR rsrc_txn_fetch_err OR rsrc_update_err OR reduce_pend_usage_err THEN
3903: x_return_status := fnd_api.g_ret_sts_error;
3904: WHEN OTHERS THEN
3905: IF g_debug <= gme_debug.g_log_unexpected THEN
3906: gme_debug.put_line ( 'When others exception in '
3907: || g_pkg_name
3908: || '.'
3909: || l_api_name
3910: || ' Error is '