eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_RESOURCE_ENGINE_PVT dependencies on FND_API

Line 63: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

59:
60: get_rsrc query_ref;
61: l_where VARCHAR2 (2000);
62: l_api_name CONSTANT VARCHAR2 (30) := 'FETCH_ALL_TRANS';
63: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
64: l_line_index BINARY_INTEGER := 1;
65: l_cursor BINARY_INTEGER;
66: l_debug VARCHAR2 (2000);
67: BEGIN

Line 74: x_return_status := fnd_api.g_ret_sts_success;

70: || l_api_name);
71: END IF;
72:
73: /* Initialize API return status to sucess */
74: x_return_status := fnd_api.g_ret_sts_success;
75:
76: -- Determine if any of the key values are present
77: IF ( (p_resource_rec.poc_trans_id IS NOT NULL)
78: OR (p_resource_rec.poc_trans_id <> fnd_api.g_miss_num) ) THEN

Line 78: OR (p_resource_rec.poc_trans_id <> fnd_api.g_miss_num) ) THEN

74: x_return_status := fnd_api.g_ret_sts_success;
75:
76: -- Determine if any of the key values are present
77: IF ( (p_resource_rec.poc_trans_id IS NOT NULL)
78: OR (p_resource_rec.poc_trans_id <> fnd_api.g_miss_num) ) THEN
79: l_debug := 'Build Where Clause Cursor Ref 1';
80: l_where := 'POC_TRANS_ID =:poc_trans_id ';
81: l_cursor := 1;
82: ELSIF ( (p_resource_rec.doc_id IS NOT NULL)

Line 83: OR (p_resource_rec.doc_id <> fnd_api.g_miss_num) ) THEN

79: l_debug := 'Build Where Clause Cursor Ref 1';
80: l_where := 'POC_TRANS_ID =:poc_trans_id ';
81: l_cursor := 1;
82: ELSIF ( (p_resource_rec.doc_id IS NOT NULL)
83: OR (p_resource_rec.doc_id <> fnd_api.g_miss_num) ) THEN
84: l_debug := 'Build Where Clause Cursor Ref 2';
85: l_where := ' DOC_ID =:doc_id';
86: l_cursor := 2;
87: ELSE

Line 123: WHEN fnd_api.g_exc_error THEN

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;
125: WHEN fnd_api.g_exc_unexpected_error THEN
126: x_return_status := fnd_api.g_ret_sts_unexp_error;
127:

Line 124: x_return_status := fnd_api.g_ret_sts_error;

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;
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

Line 125: WHEN fnd_api.g_exc_unexpected_error THEN

121: END IF;
122: EXCEPTION
123: WHEN fnd_api.g_exc_error 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);

Line 126: x_return_status := fnd_api.g_ret_sts_unexp_error;

122: EXCEPTION
123: WHEN fnd_api.g_exc_error 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;

Line 141: x_return_status := fnd_api.g_ret_sts_unexp_error;

137: || ' Error is '
138: || SQLERRM);
139: END IF;
140:
141: x_return_status := fnd_api.g_ret_sts_unexp_error;
142: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
143: END fetch_all_resources;
144:
145: /*===========================================================================================

Line 164: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

160: ,x_tran_rec OUT NOCOPY gme_resource_txns_gtmp%ROWTYPE
161: ,x_return_status OUT NOCOPY VARCHAR2)
162: IS
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 || '.'

Line 185: RAISE fnd_api.g_exc_error;

181:
182: IF NOT gme_resource_txns_gtmp_dbl.insert_row
183: (p_resource_txns => l_gme_tran_rec
184: ,x_resource_txns => x_tran_rec) THEN
185: RAISE fnd_api.g_exc_error;
186: END IF;
187:
188: x_return_status := l_return_status;
189:

Line 194: WHEN fnd_api.g_exc_error THEN

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;
196: WHEN fnd_api.g_exc_unexpected_error THEN
197: x_return_status := fnd_api.g_ret_sts_unexp_error;
198: WHEN OTHERS THEN

Line 195: x_return_status := fnd_api.g_ret_sts_error;

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;
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

Line 196: WHEN fnd_api.g_exc_unexpected_error THEN

192: END IF;
193: EXCEPTION
194: WHEN fnd_api.g_exc_error 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 '

Line 197: x_return_status := fnd_api.g_ret_sts_unexp_error;

193: EXCEPTION
194: WHEN fnd_api.g_exc_error 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

Line 208: x_return_status := fnd_api.g_ret_sts_unexp_error;

204: || ' Error is '
205: || SQLERRM);
206: END IF;
207:
208: x_return_status := fnd_api.g_ret_sts_unexp_error;
209: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
210: END create_resource_trans;
211:
212: /*===========================================================================================

Line 230: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

226: ,x_return_status OUT NOCOPY VARCHAR2)
227: IS
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);

Line 247: RAISE fnd_api.g_exc_error;

243: l_gme_tran_rec.action_code := 'DEL';
244:
245: IF NOT gme_resource_txns_gtmp_dbl.update_row
246: (p_resource_txns => l_gme_tran_rec) THEN
247: RAISE fnd_api.g_exc_error;
248: END IF;
249: END IF;
250:
251: x_return_status := l_return_status;

Line 257: WHEN fnd_api.g_exc_error THEN

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;
259: WHEN fnd_api.g_exc_unexpected_error THEN
260: x_return_status := fnd_api.g_ret_sts_unexp_error;
261: WHEN OTHERS THEN

Line 258: x_return_status := fnd_api.g_ret_sts_error;

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;
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

Line 259: WHEN fnd_api.g_exc_unexpected_error THEN

255: END IF;
256: EXCEPTION
257: WHEN fnd_api.g_exc_error 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 '

Line 260: x_return_status := fnd_api.g_ret_sts_unexp_error;

256: EXCEPTION
257: WHEN fnd_api.g_exc_error 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

Line 271: x_return_status := fnd_api.g_ret_sts_unexp_error;

267: || ' Error is '
268: || SQLERRM);
269: END IF;
270:
271: x_return_status := fnd_api.g_ret_sts_unexp_error;
272: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
273: END delete_resource_trans;
274:
275: /*===========================================================================================

Line 292: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

288: p_tran_rec IN gme_resource_txns_gtmp%ROWTYPE
289: ,x_return_status OUT NOCOPY VARCHAR2)
290: IS
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 || '.'

Line 314: RAISE fnd_api.g_exc_error;

310: END IF;
311:
312: IF NOT gme_resource_txns_gtmp_dbl.update_row
313: (p_resource_txns => l_gme_tran_rec) THEN
314: RAISE fnd_api.g_exc_error;
315: END IF;
316:
317: x_return_status := l_return_status;
318:

Line 323: WHEN fnd_api.g_exc_error THEN

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;
325: WHEN fnd_api.g_exc_unexpected_error THEN
326: x_return_status := fnd_api.g_ret_sts_unexp_error;
327: WHEN OTHERS THEN

Line 324: x_return_status := fnd_api.g_ret_sts_error;

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;
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

Line 325: WHEN fnd_api.g_exc_unexpected_error THEN

321: END IF;
322: EXCEPTION
323: WHEN fnd_api.g_exc_error 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 '

Line 326: x_return_status := fnd_api.g_ret_sts_unexp_error;

322: EXCEPTION
323: WHEN fnd_api.g_exc_error 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

Line 337: x_return_status := fnd_api.g_ret_sts_unexp_error;

333: || ' Error is '
334: || SQLERRM);
335: END IF;
336:
337: x_return_status := fnd_api.g_ret_sts_unexp_error;
338: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
339: END update_resource_trans;
340:
341: /*===========================================================================================

Line 460: RAISE fnd_api.g_exc_error;

456: (p_org_id => l_org_id
457: ,p_trans_date => l_trans_date
458: ,x_trans_date => l_tran_rec.trans_date
459: ,x_period_id => l_period_id) THEN
460: RAISE fnd_api.g_exc_error;
461: END IF;
462:
463:
464: --Rishi Varma B3856541 02-09-2004 end

Line 476: p_init_msg_list => FND_API.G_FALSE,

472: -- Bug 5903208 - Make call to GMF for actual costing
473: --
474: GMF_LAYERS.Create_Resource_Layers
475: ( p_api_version => 1.0,
476: p_init_msg_list => FND_API.G_FALSE,
477: p_rsrc_rec => l_tran_rec,
478: p_doc_qty => l_tran_rec.resource_usage,
479: p_doc_um => l_tran_rec.trans_qty_um,
480: x_return_status => l_return_status,

Line 484: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

480: x_return_status => l_return_status,
481: x_msg_count => l_msg_count,
482: x_msg_data => l_msg_data);
483:
484: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
485: THEN
486: RAISE gmf_cost_failure;
487: END IF;
488: -- End Bug 5903208

Line 526: RAISE fnd_api.g_exc_error;

522: (p_org_id => l_org_id
523: ,p_trans_date => l_trans_date
524: ,x_trans_date => l_prev_rec.trans_date
525: ,x_period_id => l_period_id) THEN
526: RAISE fnd_api.g_exc_error;
527: END IF;
528:
529: IF NOT gme_resource_txns_dbl.insert_row (l_prev_rec
530: ,l_prev_rec) THEN

Line 559: p_init_msg_list => FND_API.G_FALSE,

555: -- Bug 5903208 - Make call to GMF for actual costing
556: --
557: GMF_LAYERS.Create_Resource_Layers
558: ( p_api_version => 1.0,
559: p_init_msg_list => FND_API.G_FALSE,
560: p_rsrc_rec => l_prev_rec,
561: p_doc_qty => l_prev_rec.resource_usage,
562: p_doc_um => l_prev_rec.trans_qty_um,
563: x_return_status => l_return_status,

Line 567: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

563: x_return_status => l_return_status,
564: x_msg_count => l_msg_count,
565: x_msg_data => l_msg_data);
566:
567: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
568: THEN
569: RAISE gmf_cost_failure;
570: END IF;
571: -- End Bug 5903208

Line 584: RAISE fnd_api.g_exc_error;

580: (p_org_id => l_org_id
581: ,p_trans_date => l_trans_date
582: ,x_trans_date => l_tran_rec.trans_date
583: ,x_period_id => l_period_id) THEN
584: RAISE fnd_api.g_exc_error;
585: END IF;
586:
587: IF NOT gme_resource_txns_dbl.insert_row (l_tran_rec
588: ,l_tran_rec) THEN

Line 598: p_init_msg_list => FND_API.G_FALSE,

594: -- Bug 5903208 - Make call to GMF for actual costing
595: --
596: GMF_LAYERS.Create_Resource_Layers
597: ( p_api_version => 1.0,
598: p_init_msg_list => FND_API.G_FALSE,
599: p_rsrc_rec => l_tran_rec,
600: p_doc_qty => l_tran_rec.resource_usage,
601: p_doc_um => l_tran_rec.trans_qty_um,
602: x_return_status => l_return_status,

Line 606: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

602: x_return_status => l_return_status,
603: x_msg_count => l_msg_count,
604: x_msg_data => l_msg_data);
605:
606: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
607: THEN
608: RAISE gmf_cost_failure;
609: END IF;
610: -- End Bug 5903208

Line 654: RAISE fnd_api.g_exc_error;

650: (p_org_id => l_org_id
651: ,p_trans_date => l_trans_date
652: ,x_trans_date => l_tran_rec.trans_date
653: ,x_period_id => l_period_id) THEN
654: RAISE fnd_api.g_exc_error;
655: END IF;
656:
657: IF NOT gme_resource_txns_dbl.insert_row (l_tran_rec
658: ,l_tran_rec) THEN

Line 686: p_init_msg_list => FND_API.G_FALSE,

682: -- Bug 5903208 - Make call to GMF for actual costing
683: --
684: GMF_LAYERS.Create_Resource_Layers
685: ( p_api_version => 1.0,
686: p_init_msg_list => FND_API.G_FALSE,
687: p_rsrc_rec => l_tran_rec,
688: p_doc_qty => l_tran_rec.resource_usage,
689: p_doc_um => l_tran_rec.trans_qty_um,
690: x_return_status => l_return_status,

Line 694: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

690: x_return_status => l_return_status,
691: x_msg_count => l_msg_count,
692: x_msg_data => l_msg_data);
693:
694: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
695: THEN
696: RAISE gmf_cost_failure;
697: END IF;
698: -- End Bug 5903208

Line 720: WHEN fnd_api.g_exc_error THEN

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;
722: WHEN insert_failure THEN
723: x_return_status := fnd_api.g_ret_sts_error;
724: WHEN update_failure THEN

Line 721: x_return_status := fnd_api.g_ret_sts_error;

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;
722: WHEN insert_failure 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;

Line 723: x_return_status := fnd_api.g_ret_sts_error;

719: EXCEPTION
720: WHEN fnd_api.g_exc_error THEN
721: x_return_status := fnd_api.g_ret_sts_error;
722: WHEN insert_failure 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

Line 725: x_return_status := fnd_api.g_ret_sts_error;

721: x_return_status := fnd_api.g_ret_sts_error;
722: WHEN insert_failure 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

Line 736: x_return_status := fnd_api.g_ret_sts_unexp_error;

732: || ' Error is '
733: || SQLERRM);
734: END IF;
735:
736: x_return_status := fnd_api.g_ret_sts_unexp_error;
737: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
738: END consolidate_batch_resources;
739:
740: /*===========================================================================================

Line 876: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

872:
873: get_rsrc query_ref;
874: l_where VARCHAR2 (2000);
875: l_api_name CONSTANT VARCHAR2 (30) := 'FETCH_ACTIVE_RESOURCES';
876: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
877: l_line_index BINARY_INTEGER := 1;
878: l_cursor BINARY_INTEGER;
879: bad_keys EXCEPTION;
880: BEGIN

Line 887: x_return_status := fnd_api.g_ret_sts_success;

883: || l_api_name);
884: END IF;
885:
886: /* Initialize API return status to sucess */
887: x_return_status := fnd_api.g_ret_sts_success;
888:
889: -- Determine if any of the key values are present
890: IF (p_resource_rec.poc_trans_id IS NOT NULL) THEN
891: l_where := 'POC_TRANS_ID =:poc_trans_id ';

Line 961: WHEN fnd_api.g_exc_error THEN

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;
963: WHEN fnd_api.g_exc_unexpected_error THEN
964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965: WHEN bad_keys THEN

Line 962: x_return_status := fnd_api.g_ret_sts_error;

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;
963: WHEN fnd_api.g_exc_unexpected_error 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;

Line 963: WHEN fnd_api.g_exc_unexpected_error THEN

959: END IF;
960: EXCEPTION
961: WHEN fnd_api.g_exc_error THEN
962: x_return_status := fnd_api.g_ret_sts_error;
963: WHEN fnd_api.g_exc_unexpected_error 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

Line 964: x_return_status := fnd_api.g_ret_sts_unexp_error;

960: EXCEPTION
961: WHEN fnd_api.g_exc_error THEN
962: x_return_status := fnd_api.g_ret_sts_error;
963: WHEN fnd_api.g_exc_unexpected_error 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

Line 966: x_return_status := fnd_api.g_ret_sts_error;

962: x_return_status := fnd_api.g_ret_sts_error;
963: WHEN fnd_api.g_exc_unexpected_error 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

Line 977: x_return_status := fnd_api.g_ret_sts_unexp_error;

973: || ' Error is '
974: || SQLERRM);
975: END IF;
976:
977: x_return_status := fnd_api.g_ret_sts_unexp_error;
978: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
979: END fetch_active_resources;
980:
981: /*===========================================================================================

Line 1068: x_return_status := fnd_api.g_ret_sts_success;

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;
1069: x_step_resources_rec := p_step_resources_rec;
1070: l_batch_step.batchstep_id := x_step_resources_rec.batchstep_id;
1071:
1072: IF NOT gme_batch_steps_dbl.fetch_row (p_batch_step => l_batch_step

Line 1074: RAISE fnd_api.g_exc_error;

1070: l_batch_step.batchstep_id := x_step_resources_rec.batchstep_id;
1071:
1072: IF NOT gme_batch_steps_dbl.fetch_row (p_batch_step => l_batch_step
1073: ,x_batch_step => l_batch_step) THEN
1074: RAISE fnd_api.g_exc_error;
1075: END IF;
1076:
1077: l_step_activity.batchstep_activity_id :=
1078: p_step_resources_rec.batchstep_activity_id;

Line 1083: RAISE fnd_api.g_exc_error;

1079:
1080: IF NOT gme_batch_step_activities_dbl.fetch_row
1081: (p_batch_step_activities => l_step_activity
1082: ,x_batch_step_activities => l_step_activity) THEN
1083: RAISE fnd_api.g_exc_error;
1084: END IF;
1085:
1086: l_batch_header.batch_id := x_step_resources_rec.batch_id;
1087:

Line 1090: RAISE fnd_api.g_exc_error;

1086: l_batch_header.batch_id := x_step_resources_rec.batch_id;
1087:
1088: IF NOT gme_batch_header_dbl.fetch_row (p_batch_header => l_batch_header
1089: ,x_batch_header => l_batch_header) THEN
1090: RAISE fnd_api.g_exc_error;
1091: END IF;
1092:
1093: /* If automatic step qty calculation is set for the batch then */
1094: /* we have to compute the usage fields */

Line 1168: RAISE fnd_api.g_exc_error;

1164: ,p_check_prim_rsrc => p_check_prim_rsrc
1165: ,x_return_status => l_return_status);
1166:
1167: IF l_return_status <> x_return_status THEN
1168: RAISE fnd_api.g_exc_error;
1169: END IF;
1170: END IF;
1171:
1172: /* Since this procedure is called from the forms

Line 1187: RAISE FND_API.g_exc_error;

1183: /*
1184: GME_RESOURCE_ENGINE_PVT.check_primary_resource (p_step_resources_rec => x_step_resources_rec
1185: ,x_return_status => l_return_status);
1186: IF l_return_status <> x_return_status THEN
1187: RAISE FND_API.g_exc_error;
1188: END IF;
1189: */
1190: IF NOT (gme_batch_step_resources_dbl.insert_row
1191: (p_batch_step_resources => x_step_resources_rec

Line 1193: RAISE fnd_api.g_exc_error;

1189: */
1190: IF NOT (gme_batch_step_resources_dbl.insert_row
1191: (p_batch_step_resources => x_step_resources_rec
1192: ,x_batch_step_resources => x_step_resources_rec) ) THEN
1193: RAISE fnd_api.g_exc_error;
1194: END IF;
1195: END IF;
1196:
1197: IF p_action_code IN ('INSERT', 'UPDATE') THEN

Line 1205: RAISE fnd_api.g_exc_error;

1201: (p_batch_step_resources_rec => x_step_resources_rec
1202: ,x_return_status => l_return_status);
1203:
1204: IF l_return_status <> x_return_status THEN
1205: RAISE fnd_api.g_exc_error;
1206: END IF;
1207: ELSIF l_batch_step.step_status > 1
1208: AND NVL (x_step_resources_rec.actual_rsrc_usage, -1) >= 0 THEN
1209: gme_update_step_qty_pvt.adjust_actual_usage

Line 1214: RAISE fnd_api.g_exc_error;

1210: (p_batch_step_resources_rec => x_step_resources_rec
1211: ,x_return_status => l_return_status);
1212:
1213: IF l_return_status <> x_return_status THEN
1214: RAISE fnd_api.g_exc_error;
1215: END IF;
1216: END IF; /* IF l_batch_step.step_status = 1 */
1217: END IF; /* IF l_batch_header.update_inventory_ind = 'Y' */
1218:

Line 1225: p_init_msg_list => FND_API.G_FALSE,

1221: --
1222: IF p_action_code = 'INSERT' THEN
1223: GMF_VIB.Update_Batch_Requirements
1224: ( p_api_version => 1.0,
1225: p_init_msg_list => FND_API.G_FALSE,
1226: p_batch_id => l_batch_header.batch_id,
1227: x_return_status => l_return_status,
1228: x_msg_count => l_message_count,
1229: x_msg_data => l_message_list);

Line 1231: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

1227: x_return_status => l_return_status,
1228: x_msg_count => l_message_count,
1229: x_msg_data => l_message_list);
1230:
1231: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1232: THEN
1233: RAISE gmf_cost_failure;
1234: END IF;
1235: END IF;

Line 1245: RAISE FND_API.g_exc_error;

1241: /*
1242: GME_RESOURCE_ENGINE_PVT.check_primary_resource (p_step_resources_rec => x_step_resources_rec
1243: ,x_return_status => l_return_status);
1244: IF l_return_status <> x_return_status THEN
1245: RAISE FND_API.g_exc_error;
1246: END IF;
1247: */
1248: gme_delete_batch_step_pvt.delete_resource
1249: (p_batch_step_resources_rec => x_step_resources_rec

Line 1253: RAISE fnd_api.g_exc_error;

1249: (p_batch_step_resources_rec => x_step_resources_rec
1250: ,x_return_status => l_return_status);
1251:
1252: IF l_return_status <> x_return_status THEN
1253: RAISE fnd_api.g_exc_error;
1254: END IF;
1255:
1256: -- Bug 5043868 - Make call to GMF for actual costing data
1257: -- recording when deleting a resource from the form or api.

Line 1260: p_init_msg_list => FND_API.G_FALSE,

1256: -- Bug 5043868 - Make call to GMF for actual costing data
1257: -- recording when deleting a resource from the form or api.
1258: GMF_VIB.Update_Batch_Requirements
1259: ( p_api_version => 1.0,
1260: p_init_msg_list => FND_API.G_FALSE,
1261: p_batch_id => l_batch_header.batch_id,
1262: x_return_status => l_return_status,
1263: x_msg_count => l_message_count,
1264: x_msg_data => l_message_list);

Line 1266: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

1262: x_return_status => l_return_status,
1263: x_msg_count => l_message_count,
1264: x_msg_data => l_message_list);
1265:
1266: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1267: THEN
1268: RAISE gmf_cost_failure;
1269: END IF;
1270: -- End Bug 5903208

Line 1280: RAISE fnd_api.g_exc_error;

1276: /* deducted from the pending resource transactions */
1277: IF p_action_code = 'UPDATE' THEN
1278: IF NOT (gme_batch_step_resources_dbl.update_row
1279: (p_batch_step_resources => x_step_resources_rec) ) THEN
1280: RAISE fnd_api.g_exc_error;
1281: END IF;
1282:
1283: x_step_resources_rec.last_updated_by := gme_common_pvt.g_user_ident;
1284: x_step_resources_rec.last_update_date := gme_common_pvt.g_timestamp;

Line 1296: RAISE fnd_api.g_exc_error;

1292: gme_common_pvt.setup (p_org_id => l_batch_header.ORGANIZATION_ID --1381
1293: ,p_org_code => NULL);
1294:
1295: IF NOT gme_common_pvt.g_setup_done THEN
1296: RAISE fnd_api.g_exc_error;
1297: END IF;
1298:
1299: OPEN cur_get_rsrc(x_step_resources_rec.resources);
1300: FETCH cur_get_rsrc INTO l_rsrc_rec;

Line 1335: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1331: p_batch_id => l_batch_step.batch_id
1332: ,p_batchstep_id => l_batch_step.batchstep_id
1333: ,x_return_status => l_return_status);
1334:
1335: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1336: RAISE error_in_clear_charges;
1337: END IF;
1338: END IF;
1339:

Line 1348: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1344: ,p_cal_type => 'R'
1345: ,x_batchstep_rec => x_batch_step
1346: ,x_return_status => l_return_status );
1347:
1348: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1349: RAISE fnd_api.g_exc_error;
1350: END IF;
1351: END IF; /*action code check */
1352: END IF; /*p_step_resources_rec.capacity_constraint = 1 */

Line 1349: RAISE fnd_api.g_exc_error;

1345: ,x_batchstep_rec => x_batch_step
1346: ,x_return_status => l_return_status );
1347:
1348: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1349: RAISE fnd_api.g_exc_error;
1350: END IF;
1351: END IF; /*action code check */
1352: END IF; /*p_step_resources_rec.capacity_constraint = 1 */
1353: /*Bug#5231180 End */

Line 1361: x_return_status := FND_API.G_RET_STS_ERROR;

1357: END IF;
1358: EXCEPTION
1359: WHEN gmf_cost_failure THEN
1360: -- Bug 5903208
1361: x_return_status := FND_API.G_RET_STS_ERROR;
1362:
1363: WHEN fnd_api.g_exc_error THEN
1364: x_return_status := fnd_api.g_ret_sts_error;
1365: WHEN OTHERS THEN

Line 1363: WHEN fnd_api.g_exc_error THEN

1359: WHEN gmf_cost_failure THEN
1360: -- Bug 5903208
1361: x_return_status := FND_API.G_RET_STS_ERROR;
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 '

Line 1364: x_return_status := fnd_api.g_ret_sts_error;

1360: -- Bug 5903208
1361: x_return_status := FND_API.G_RET_STS_ERROR;
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

Line 1375: x_return_status := fnd_api.g_ret_sts_unexp_error;

1371: || ' Error is '
1372: || SQLERRM);
1373: END IF;
1374:
1375: x_return_status := fnd_api.g_ret_sts_unexp_error;
1376: fnd_msg_pub.add_exc_msg ('GME_RESOURCE_ENGINE_PVT'
1377: ,'resource_dtl_process');
1378: END resource_dtl_process;
1379:

Line 1409: x_return_status := fnd_api.g_ret_sts_success;

1405: || l_api_name);
1406: END IF;
1407:
1408: /* Initialize return status to success */
1409: x_return_status := fnd_api.g_ret_sts_success;
1410:
1411: IF ( p_batch_step_rec.step_status = 1
1412: AND p_step_resources_rec.plan_start_date IS NULL) THEN
1413: gme_common_pvt.log_message ('GME_START_DATE_REQD');

Line 1414: RAISE fnd_api.g_exc_error;

1410:
1411: IF ( p_batch_step_rec.step_status = 1
1412: AND p_step_resources_rec.plan_start_date IS NULL) THEN
1413: gme_common_pvt.log_message ('GME_START_DATE_REQD');
1414: RAISE fnd_api.g_exc_error;
1415: END IF;
1416:
1417: IF p_batch_step_rec.step_status = 1
1418: AND p_step_resources_rec.plan_rsrc_usage IS NULL THEN

Line 1420: RAISE fnd_api.g_exc_error;

1416:
1417: IF p_batch_step_rec.step_status = 1
1418: AND p_step_resources_rec.plan_rsrc_usage IS NULL THEN
1419: gme_common_pvt.log_message ('GME_PLAN_RSRC_REQD');
1420: RAISE fnd_api.g_exc_error;
1421: END IF;
1422:
1423: IF ( p_batch_step_rec.step_status = 1
1424: AND p_step_resources_rec.plan_rsrc_qty IS NULL) THEN

Line 1426: RAISE fnd_api.g_exc_error;

1422:
1423: IF ( p_batch_step_rec.step_status = 1
1424: AND p_step_resources_rec.plan_rsrc_qty IS NULL) THEN
1425: gme_common_pvt.log_message ('GME_RSRC_QTY_REQD');
1426: RAISE fnd_api.g_exc_error;
1427: END IF;
1428:
1429: IF ( p_batch_step_rec.step_status = 1
1430: AND p_step_resources_rec.plan_rsrc_count IS NULL) THEN

Line 1432: RAISE fnd_api.g_exc_error;

1428:
1429: IF ( p_batch_step_rec.step_status = 1
1430: AND p_step_resources_rec.plan_rsrc_count IS NULL) THEN
1431: gme_common_pvt.log_message ('GME_RSRC_COUNT_REQD');
1432: RAISE fnd_api.g_exc_error;
1433: END IF;
1434:
1435: IF ( p_batch_step_rec.step_status > 2
1436: AND p_step_resources_rec.actual_rsrc_qty IS NULL) THEN

Line 1438: RAISE fnd_api.g_exc_error;

1434:
1435: IF ( p_batch_step_rec.step_status > 2
1436: AND p_step_resources_rec.actual_rsrc_qty IS NULL) THEN
1437: gme_common_pvt.log_message ('GME_RSRC_QTY_REQD');
1438: RAISE fnd_api.g_exc_error;
1439: END IF;
1440:
1441: IF ( p_batch_step_rec.step_status > 2
1442: AND p_step_resources_rec.actual_rsrc_count IS NULL) THEN

Line 1444: RAISE fnd_api.g_exc_error;

1440:
1441: IF ( p_batch_step_rec.step_status > 2
1442: AND p_step_resources_rec.actual_rsrc_count IS NULL) THEN
1443: gme_common_pvt.log_message ('GME_RSRC_COUNT_REQD');
1444: RAISE fnd_api.g_exc_error;
1445: END IF;
1446:
1447: /* Let us check for the validitiy of the plan and actual dates */
1448: IF p_step_resources_rec.plan_start_date IS NOT NULL

Line 1453: RAISE fnd_api.g_exc_error;

1449: AND p_step_resources_rec.plan_cmplt_date IS NOT NULL THEN
1450: IF p_step_resources_rec.plan_start_date >
1451: p_step_resources_rec.plan_cmplt_date THEN
1452: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1453: RAISE fnd_api.g_exc_error;
1454: END IF;
1455: END IF;
1456:
1457: IF p_step_resources_rec.actual_start_date IS NOT NULL

Line 1462: RAISE fnd_api.g_exc_error;

1458: AND p_step_resources_rec.actual_cmplt_date IS NOT NULL THEN
1459: IF p_step_resources_rec.actual_start_date >
1460: p_step_resources_rec.actual_cmplt_date THEN
1461: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1462: RAISE fnd_api.g_exc_error;
1463: END IF;
1464: END IF;
1465:
1466: IF p_step_resources_rec.plan_start_date IS NOT NULL

Line 1477: RAISE fnd_api.g_exc_error;

1473: ,'START_DATE'
1474: ,fnd_date.date_to_displaydt (p_step_activity_rec.plan_start_date)
1475: ,'END_DATE'
1476: ,fnd_date.date_to_displaydt (p_step_activity_rec.plan_cmplt_date) );
1477: RAISE fnd_api.g_exc_error;
1478: END IF;
1479:
1480: IF p_step_resources_rec.plan_cmplt_date IS NOT NULL
1481: AND p_step_resources_rec.plan_cmplt_date >

Line 1489: RAISE fnd_api.g_exc_error;

1485: ,'START_DATE'
1486: ,fnd_date.date_to_displaydt (p_step_activity_rec.plan_start_date)
1487: ,'END_DATE'
1488: ,fnd_date.date_to_displaydt (p_step_activity_rec.plan_cmplt_date) );
1489: RAISE fnd_api.g_exc_error;
1490: END IF;
1491:
1492: IF p_step_resources_rec.actual_start_date IS NOT NULL
1493: AND ( p_step_resources_rec.actual_start_date <

Line 1505: RAISE fnd_api.g_exc_error;

1501: ,'END_DATE'
1502: ,fnd_date.date_to_displaydt
1503: (NVL (p_step_activity_rec.actual_cmplt_date
1504: ,p_step_activity_rec.actual_start_date) ) );
1505: RAISE fnd_api.g_exc_error;
1506: END IF;
1507:
1508: IF p_step_resources_rec.actual_cmplt_date IS NOT NULL
1509: AND p_step_resources_rec.actual_cmplt_date >

Line 1517: RAISE fnd_api.g_exc_error;

1513: ,'START_DATE'
1514: ,fnd_date.date_to_displaydt (p_step_activity_rec.actual_start_date)
1515: ,'END_DATE'
1516: ,fnd_date.date_to_displaydt (p_step_activity_rec.actual_cmplt_date) );
1517: RAISE fnd_api.g_exc_error;
1518: END IF;
1519:
1520: /* Only one primary resource is allowed per activity let us check for it now */
1521: /* Remove this call as per Resource TD page 57 */

Line 1533: WHEN fnd_api.g_exc_error THEN

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;
1535: WHEN OTHERS THEN
1536: IF g_debug <= gme_debug.g_log_unexpected THEN
1537: gme_debug.put_line ( 'When others exception in '

Line 1534: x_return_status := fnd_api.g_ret_sts_error;

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;
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

Line 1545: x_return_status := fnd_api.g_ret_sts_unexp_error;

1541: || ' Error is '
1542: || SQLERRM);
1543: END IF;
1544:
1545: x_return_status := fnd_api.g_ret_sts_unexp_error;
1546: fnd_msg_pub.add_exc_msg ('GME_RESOURCE_ENGINE_PVT'
1547: ,'VALIDATE_RESOURCE');
1548: END validate_resource;
1549:

Line 1610: x_return_status := fnd_api.g_ret_sts_success;

1606: || l_api_name);
1607: END IF;
1608:
1609: /* Initialize return status to success */
1610: x_return_status := fnd_api.g_ret_sts_success;
1611:
1612: OPEN cur_get_prim_rsrc (p_step_resources_rec.batchstep_activity_id
1613: ,p_step_resources_rec.batchstep_resource_id);
1614:

Line 1658: RAISE fnd_api.g_exc_error;

1654: --Rishi 3446787/3020345
1655: fnd_message.set_token ('ACTIVITY', l_activity);
1656: fnd_message.set_token ('STEPNO', l_batchstep_no);
1657: fnd_msg_pub.ADD;
1658: RAISE fnd_api.g_exc_error;
1659: ELSIF (l_count = 0) AND NVL (p_step_resources_rec.prim_rsrc_ind, 0) = 0 THEN
1660: fnd_message.set_name ('GME', 'GME_MIN_ONE_PRIM_RSRC');
1661: fnd_message.set_token ('ACTIVITY', l_activity);
1662: fnd_message.set_token ('STEPNO', l_batchstep_no);

Line 1665: RAISE fnd_api.g_exc_error;

1661: fnd_message.set_token ('ACTIVITY', l_activity);
1662: fnd_message.set_token ('STEPNO', l_batchstep_no);
1663: --Rishi 3446787/3020345 end
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);

Line 1672: WHEN fnd_api.g_exc_error THEN

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;
1674: WHEN OTHERS THEN
1675: IF g_debug <= gme_debug.g_log_unexpected THEN
1676: gme_debug.put_line ( 'When others exception in '

Line 1673: x_return_status := fnd_api.g_ret_sts_error;

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;
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

Line 1684: x_return_status := fnd_api.g_ret_sts_unexp_error;

1680: || ' Error is '
1681: || SQLERRM);
1682: END IF;
1683:
1684: x_return_status := fnd_api.g_ret_sts_unexp_error;
1685: fnd_msg_pub.add_exc_msg ('GME_RESOURCE_ENGINE_PVT'
1686: ,'CHECK_PRIMARY_RESOURCE');
1687: END check_primary_resource;
1688:

Line 1732: x_return_status := fnd_api.g_ret_sts_success;

1728:
1729: l_count NUMBER (5);
1730: BEGIN
1731: /* Initialize return status to success */
1732: x_return_status := fnd_api.g_ret_sts_success;
1733:
1734: FOR batchsteps IN cur_get_batch_steps LOOP
1735: FOR activities IN
1736: cur_get_batchstep_activities (p_batch_id

Line 1759: RAISE fnd_api.g_exc_error;

1755: fnd_message.set_name ('GME', 'GME_ONE_PRIM_RSRC');
1756: fnd_message.set_token ('ACTIVITY', activities.activity);
1757: fnd_message.set_token ('STEPNO', batchsteps.batchstep_no);
1758: fnd_msg_pub.ADD;
1759: RAISE fnd_api.g_exc_error;
1760: ELSIF (l_count = 0) THEN
1761: fnd_message.set_name ('GME', 'GME_MIN_ONE_PRIM_RSRC');
1762: fnd_message.set_token ('ACTIVITY', activities.activity);
1763: fnd_message.set_token ('STEPNO', batchsteps.batchstep_no);

Line 1765: RAISE fnd_api.g_exc_error;

1761: fnd_message.set_name ('GME', 'GME_MIN_ONE_PRIM_RSRC');
1762: fnd_message.set_token ('ACTIVITY', activities.activity);
1763: fnd_message.set_token ('STEPNO', batchsteps.batchstep_no);
1764: fnd_msg_pub.ADD;
1765: RAISE fnd_api.g_exc_error;
1766: END IF;
1767: END LOOP;
1768: END LOOP;
1769: EXCEPTION

Line 1770: WHEN fnd_api.g_exc_error THEN

1766: END IF;
1767: END LOOP;
1768: END LOOP;
1769: EXCEPTION
1770: WHEN fnd_api.g_exc_error THEN
1771: x_return_status := fnd_api.g_ret_sts_error;
1772: WHEN OTHERS THEN
1773: x_return_status := fnd_api.g_ret_sts_unexp_error;
1774: fnd_msg_pub.add_exc_msg ('GME_RESOURCE_ENGINE_PVT'

Line 1771: x_return_status := fnd_api.g_ret_sts_error;

1767: END LOOP;
1768: END LOOP;
1769: EXCEPTION
1770: WHEN fnd_api.g_exc_error THEN
1771: x_return_status := fnd_api.g_ret_sts_error;
1772: WHEN OTHERS THEN
1773: x_return_status := fnd_api.g_ret_sts_unexp_error;
1774: fnd_msg_pub.add_exc_msg ('GME_RESOURCE_ENGINE_PVT'
1775: ,'CHECK_PRIMARY_RESOURCE');

Line 1773: x_return_status := fnd_api.g_ret_sts_unexp_error;

1769: EXCEPTION
1770: WHEN fnd_api.g_exc_error THEN
1771: x_return_status := fnd_api.g_ret_sts_error;
1772: WHEN OTHERS THEN
1773: x_return_status := fnd_api.g_ret_sts_unexp_error;
1774: fnd_msg_pub.add_exc_msg ('GME_RESOURCE_ENGINE_PVT'
1775: ,'CHECK_PRIMARY_RESOURCE');
1776: END check_primary_resource;
1777:

Line 1825: x_return_status := fnd_api.g_ret_sts_success;

1821: || l_api_name);
1822: END IF;
1823:
1824: /* Initialize return status to success */
1825: x_return_status := fnd_api.g_ret_sts_success;
1826: x_step_resources_rec.batchstep_resource_id :=
1827: p_step_resources_rec.batchstep_resource_id;
1828:
1829: IF NOT gme_batch_step_resources_dbl.fetch_row

Line 1832: RAISE fnd_api.g_exc_error;

1828:
1829: IF NOT gme_batch_step_resources_dbl.fetch_row
1830: (p_batch_step_resources => x_step_resources_rec
1831: ,x_batch_step_resources => x_step_resources_rec) THEN
1832: RAISE fnd_api.g_exc_error;
1833: END IF;
1834:
1835: OPEN cur_get_stat;
1836:

Line 1866: WHEN fnd_api.g_exc_error THEN

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;
1868: WHEN OTHERS THEN
1869: IF g_debug <= gme_debug.g_log_unexpected THEN
1870: gme_debug.put_line ( 'When others exception in '

Line 1867: x_return_status := fnd_api.g_ret_sts_error;

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;
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

Line 1878: x_return_status := fnd_api.g_ret_sts_unexp_error;

1874: || ' Error is '
1875: || SQLERRM);
1876: END IF;
1877:
1878: x_return_status := fnd_api.g_ret_sts_unexp_error;
1879: fnd_msg_pub.add_exc_msg ('GME_RESOURCE_ENGINE_PVT'
1880: ,'GET_RESOURCE_USAGE');
1881: END get_resource_usage;
1882:

Line 2072: x_return_status := fnd_api.g_ret_sts_success;

2068: || l_api_name);
2069: END IF;
2070:
2071: /* Initially let us assign the return status to success */
2072: x_return_status := fnd_api.g_ret_sts_success;
2073:
2074: l_batch_step_rsrc_rec_in.batchstep_resource_id := p_batchstep_rsrc_id;
2075: IF NOT gme_common_pvt.get_batchstep_rsrc (
2076: p_batchstep_rsrc_rec => l_batch_step_rsrc_rec_in

Line 2118: RAISE fnd_api.g_exc_error;

2114: OR p_resource IS NULL) THEN
2115: gme_common_pvt.log_message ('INPUT_PARMS_MISS'
2116: ,'PROC'
2117: , l_api_name || '.' || g_pkg_name);
2118: RAISE fnd_api.g_exc_error;
2119: ELSE
2120: -- Validate input param one by one to see if it identifies a resource correctly
2121: OPEN cur_get_batch_id (p_org_id, p_batch_no);
2122:

Line 2193: RAISE fnd_api.g_exc_error;

2189: OR ( (p_end_date IS NULL) AND (p_usage <> 0) ) ) THEN
2190: gme_common_pvt.log_message ('INPUT_PARMS_MISS'
2191: ,'PROC'
2192: , l_api_name || '.' || g_pkg_name);
2193: RAISE fnd_api.g_exc_error;
2194: END IF;
2195:
2196: l_batch_header.batch_id := l_batch_step_rsrc_rec.batch_id;
2197:

Line 2266: RAISE FND_API.g_exc_error;

2262: IF cur_validate_reason_id%NOTFOUND THEN
2263: CLOSE cur_validate_reason_id;
2264: gme_common_pvt.log_message(p_product_code => 'INV'
2265: ,p_message_code => 'INV_LOTC_REASONID_INVALID');
2266: RAISE FND_API.g_exc_error;
2267: END IF;
2268: CLOSE cur_validate_reason_id;
2269: ELSIF p_reason_name IS NOT NULL THEN
2270: OPEN cur_get_reason_id(p_reason_name);

Line 2276: RAISE FND_API.g_exc_error;

2272: INTO x_reason_id;
2273: IF cur_get_reason_id%NOTFOUND THEN
2274: CLOSE cur_get_reason_id;
2275: gme_common_pvt.log_message('GME_INVALID_REASON_NAME');
2276: RAISE FND_API.g_exc_error;
2277: ELSE
2278: FETCH cur_get_reason_id
2279: INTO x_reason_id;
2280: IF cur_get_reason_id%NOTFOUND THEN

Line 2285: RAISE FND_API.g_exc_error;

2281: CLOSE cur_get_reason_id;
2282: ELSE
2283: CLOSE cur_get_reason_id;
2284: gme_common_pvt.log_message('GME_REASON_NAME_NOT_UNIQUE');
2285: RAISE FND_API.g_exc_error;
2286: END IF;
2287: END IF;
2288: END IF; /* IF p_reason_name IS NOT NULL */
2289:

Line 2391: RAISE FND_API.g_exc_error;

2387: IF NOT gme_api_grp.close_period_check_flexible
2388: (p_tran_rec => p_tran_rec,
2389: x_tran_rec => l_tran_rec_out)
2390: THEN
2391: RAISE FND_API.g_exc_error;
2392: END IF;
2393: x_trans_date := l_tran_rec_out.trans_date;
2394: --Rishi Varma 02-09-2004 B3856541 end
2395: */

Line 2401: RAISE fnd_api.g_exc_error;

2397: (p_org_id => l_batch_step_rsrc_rec.organization_id
2398: ,p_trans_date => p_trans_date
2399: ,x_trans_date => x_trans_date
2400: ,x_period_id => l_period_id) THEN
2401: RAISE fnd_api.g_exc_error;
2402: END IF;
2403:
2404: /* end */
2405:

Line 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

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;
2442: WHEN invalid_instance_id OR invalid_instance_no THEN
2443: x_return_status := fnd_api.g_ret_sts_error;
2444: WHEN neg_usage_not_allowed OR batch_hdr_fetch_err OR rsrcid_not_found THEN

Line 2441: x_return_status := fnd_api.g_ret_sts_error;

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;
2442: WHEN invalid_instance_id OR invalid_instance_no THEN
2443: x_return_status := fnd_api.g_ret_sts_error;
2444: WHEN neg_usage_not_allowed OR batch_hdr_fetch_err OR rsrcid_not_found THEN
2445: x_return_status := fnd_api.g_ret_sts_error;

Line 2443: x_return_status := fnd_api.g_ret_sts_error;

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;
2442: WHEN invalid_instance_id OR invalid_instance_no THEN
2443: x_return_status := fnd_api.g_ret_sts_error;
2444: WHEN neg_usage_not_allowed OR batch_hdr_fetch_err OR rsrcid_not_found THEN
2445: x_return_status := fnd_api.g_ret_sts_error;
2446: WHEN batch_not_found OR batchstep_not_found OR invalid_step_status THEN
2447: x_return_status := fnd_api.g_ret_sts_error;

Line 2445: x_return_status := fnd_api.g_ret_sts_error;

2441: x_return_status := fnd_api.g_ret_sts_error;
2442: WHEN invalid_instance_id OR invalid_instance_no THEN
2443: x_return_status := fnd_api.g_ret_sts_error;
2444: WHEN neg_usage_not_allowed OR batch_hdr_fetch_err OR rsrcid_not_found THEN
2445: x_return_status := fnd_api.g_ret_sts_error;
2446: WHEN batch_not_found OR batchstep_not_found OR invalid_step_status THEN
2447: x_return_status := fnd_api.g_ret_sts_error;
2448: WHEN rtxn_for_fpo_not_allowed THEN
2449: x_return_status := fnd_api.g_ret_sts_error;

Line 2447: x_return_status := fnd_api.g_ret_sts_error;

2443: x_return_status := fnd_api.g_ret_sts_error;
2444: WHEN neg_usage_not_allowed OR batch_hdr_fetch_err OR rsrcid_not_found THEN
2445: x_return_status := fnd_api.g_ret_sts_error;
2446: WHEN batch_not_found OR batchstep_not_found OR invalid_step_status THEN
2447: x_return_status := fnd_api.g_ret_sts_error;
2448: WHEN rtxn_for_fpo_not_allowed THEN
2449: x_return_status := fnd_api.g_ret_sts_error;
2450: WHEN stepactivity_not_found OR resource_not_found OR rtxn_for_updinv_not_allowed THEN
2451: x_return_status := fnd_api.g_ret_sts_error;

Line 2449: x_return_status := fnd_api.g_ret_sts_error;

2445: x_return_status := fnd_api.g_ret_sts_error;
2446: WHEN batch_not_found OR batchstep_not_found OR invalid_step_status THEN
2447: x_return_status := fnd_api.g_ret_sts_error;
2448: WHEN rtxn_for_fpo_not_allowed THEN
2449: x_return_status := fnd_api.g_ret_sts_error;
2450: WHEN stepactivity_not_found OR resource_not_found OR rtxn_for_updinv_not_allowed THEN
2451: x_return_status := fnd_api.g_ret_sts_error;
2452: WHEN invalid_reason_code THEN
2453: fnd_message.set_name ('GMA', 'SY_REASONCODE');

Line 2451: x_return_status := fnd_api.g_ret_sts_error;

2447: x_return_status := fnd_api.g_ret_sts_error;
2448: WHEN rtxn_for_fpo_not_allowed THEN
2449: x_return_status := fnd_api.g_ret_sts_error;
2450: WHEN stepactivity_not_found OR resource_not_found OR rtxn_for_updinv_not_allowed THEN
2451: x_return_status := fnd_api.g_ret_sts_error;
2452: WHEN invalid_reason_code THEN
2453: fnd_message.set_name ('GMA', 'SY_REASONCODE');
2454: fnd_msg_pub.ADD;
2455: x_return_status := fnd_api.g_ret_sts_error;

Line 2455: x_return_status := fnd_api.g_ret_sts_error;

2451: x_return_status := fnd_api.g_ret_sts_error;
2452: WHEN invalid_reason_code 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

Line 2466: x_return_status := fnd_api.g_ret_sts_unexp_error;

2462: || ' Error is '
2463: || SQLERRM);
2464: END IF;
2465:
2466: x_return_status := fnd_api.g_ret_sts_unexp_error;
2467: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2468: END validate_rsrc_txn_param;
2469:
2470: /*===========================================================================================

Line 2544: x_return_status := fnd_api.g_ret_sts_success;

2540: || l_api_name);
2541: END IF;
2542:
2543: /* Initially let us assign the return status to success */
2544: x_return_status := fnd_api.g_ret_sts_success;
2545:
2546: /*siva commented following IF condition to allow insertion of flexfileds
2547: without validation when p_validate_flexfields is FALSE */
2548: --IF gme_common_pvt.g_flex_validate_prof = 1 THEN

Line 2555: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2551: (p_resource_txn_rec => p_rsrc_txn_rec
2552: ,x_resource_txn_rec => x_rsrc_txn_rec
2553: ,x_return_status => l_return_status);
2554:
2555: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2556: RAISE validation_failure;
2557: END IF;
2558: --END IF;
2559:

Line 2597: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2593: || '.'
2594: || l_api_name);
2595: END IF;
2596:
2597: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2598: RAISE validation_failure;
2599: END IF;
2600:
2601: OPEN cur_fetch_resource_dtl (l_line_id);

Line 2628: RAISE fnd_api.g_exc_error;

2624: ,x_resource_tbl => l_resource_tbl
2625: ,x_return_status => l_return_status);
2626:
2627: IF l_return_status <> x_return_status THEN
2628: RAISE fnd_api.g_exc_error;
2629: END IF;
2630:
2631: -- delete all rec in l_resource_tbl
2632: FOR i IN 1 .. l_resource_tbl.COUNT LOOP

Line 2746: x_return_status := fnd_api.g_ret_sts_error;

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;
2747: WHEN update_rsrc_txn_err OR rsrc_txn_insert_err 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;

Line 2748: x_return_status := fnd_api.g_ret_sts_error;

2744: EXCEPTION
2745: WHEN validation_failure OR error_load_trans THEN
2746: x_return_status := fnd_api.g_ret_sts_error;
2747: WHEN update_rsrc_txn_err OR rsrc_txn_insert_err 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

Line 2750: x_return_status := fnd_api.g_ret_sts_error;

2746: x_return_status := fnd_api.g_ret_sts_error;
2747: WHEN update_rsrc_txn_err OR rsrc_txn_insert_err 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

Line 2761: x_return_status := fnd_api.g_ret_sts_unexp_error;

2757: || ' Error is '
2758: || SQLERRM);
2759: END IF;
2760:
2761: x_return_status := fnd_api.g_ret_sts_unexp_error;
2762: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2763: END update_actual_resource_usage;
2764:
2765: /*===========================================================================================

Line 2843: x_return_status := fnd_api.g_ret_sts_success;

2839: || l_api_name);
2840: END IF;
2841:
2842: /* Initially let us assign the return status to success */
2843: x_return_status := fnd_api.g_ret_sts_success;
2844:
2845: /*siva commented following IF condition to allow insertion of flexfileds
2846: without validation when p_validate_flexfields is FALSE */
2847: --IF gme_common_pvt.g_flex_validate_prof = 1 THEN

Line 2854: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2850: (p_resource_txn_rec => p_rsrc_txn_rec
2851: ,x_resource_txn_rec => x_rsrc_txn_rec
2852: ,x_return_status => x_return_status);
2853:
2854: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2855: RAISE validation_failure;
2856: END IF;
2857: --END IF;
2858:

Line 2898: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2894: || '.'
2895: || l_api_name);
2896: END IF;
2897:
2898: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2899: RAISE validation_failure;
2900: END IF;
2901:
2902: OPEN cur_fetch_resource_dtl (l_line_id);

Line 2998: x_return_status := fnd_api.g_ret_sts_error;

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;
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

Line 3000: x_return_status := fnd_api.g_ret_sts_error;

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;
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

Line 3011: x_return_status := fnd_api.g_ret_sts_unexp_error;

3007: || ' Error is '
3008: || SQLERRM);
3009: END IF;
3010:
3011: x_return_status := fnd_api.g_ret_sts_unexp_error;
3012: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3013: END insert_incr_actual_rsrc_txn;
3014:
3015: /*==== =======================================================================================

Line 3098: x_return_status := fnd_api.g_ret_sts_success;

3094: || l_api_name);
3095: END IF;
3096:
3097: /* Initially let us assign the return status to success */
3098: x_return_status := fnd_api.g_ret_sts_success;
3099:
3100: /*siva commented following IF condition to allow insertion of flexfileds
3101: without validation when p_validate_flexfields is FALSE */
3102: --IF gme_common_pvt.g_flex_validate_prof = 1 THEN

Line 3109: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3105: (p_resource_txn_rec => p_rsrc_txn_rec
3106: ,x_resource_txn_rec => x_rsrc_txn_rec
3107: ,x_return_status => l_return_status);
3108:
3109: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3110: RAISE validation_failure;
3111: END IF;
3112: --END IF;
3113: l_rsrc_txn_rec := x_rsrc_txn_rec;

Line 3154: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3150: || '.'
3151: || l_api_name);
3152: END IF;
3153:
3154: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3155: RAISE validation_failure;
3156: END IF;
3157:
3158: /* V. Ajay Kumar Bug 3041705. Multiplied the difference of

Line 3295: x_return_status := fnd_api.g_ret_sts_error;

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;
3296: WHEN rsrc_fetch_err OR rsrc_update_err OR reduce_pend_usage_err 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;

Line 3297: x_return_status := fnd_api.g_ret_sts_error;

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;
3296: WHEN rsrc_fetch_err OR rsrc_update_err OR reduce_pend_usage_err 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

Line 3299: x_return_status := fnd_api.g_ret_sts_error;

3295: x_return_status := fnd_api.g_ret_sts_error;
3296: WHEN rsrc_fetch_err OR rsrc_update_err OR reduce_pend_usage_err 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

Line 3310: x_return_status := fnd_api.g_ret_sts_unexp_error;

3306: || ' Error is '
3307: || SQLERRM);
3308: END IF;
3309:
3310: x_return_status := fnd_api.g_ret_sts_unexp_error;
3311: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3312: END insert_timed_actual_rsrc_txn;
3313:
3314: /*==== =======================================================================================

Line 3374: x_return_status := fnd_api.g_ret_sts_success;

3370: || l_api_name);
3371: END IF;
3372:
3373: /* Initially let us assign the return status to success */
3374: x_return_status := fnd_api.g_ret_sts_success;
3375:
3376: /*siva commented following IF condition to allow insertion of flexfileds
3377: without validation when p_validate_flexfields is FALSE */
3378: -- IF gme_common_pvt.g_flex_validate_prof = 1 THEN

Line 3385: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3381: (p_resource_txn_rec => p_rsrc_txn_rec
3382: ,x_resource_txn_rec => x_rsrc_txn_rec
3383: ,x_return_status => x_return_status);
3384:
3385: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3386: RAISE validation_failure;
3387: END IF;
3388: --END IF;
3389: /* siva added the following line */

Line 3394: l_return_status := fnd_api.g_ret_sts_success;

3390: l_rsrc_txn_rec := x_rsrc_txn_rec;
3391:
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

Line 3433: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3429: || '.'
3430: || l_api_name);
3431: END IF;
3432:
3433: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3434: RAISE validation_failure;
3435: END IF;
3436:
3437: OPEN cur_fetch_resource_dtl (l_line_id);

Line 3499: x_return_status := fnd_api.g_ret_sts_error;

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;
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

Line 3510: x_return_status := fnd_api.g_ret_sts_unexp_error;

3506: || ' Error is '
3507: || SQLERRM);
3508: END IF;
3509:
3510: x_return_status := fnd_api.g_ret_sts_unexp_error;
3511: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3512: END start_cmplt_actual_rsrc_txn;
3513:
3514: /*==== =======================================================================================

Line 3601: x_return_status := fnd_api.g_ret_sts_success;

3597: || l_api_name);
3598: END IF;
3599:
3600: /* Initially let us assign the return status to success */
3601: x_return_status := fnd_api.g_ret_sts_success;
3602:
3603: -- validate poc_trans_id right here as validate_rsrc_txn_param doesnt validate it
3604:
3605: OPEN cur_validate_poc_trans_id (p_rsrc_txn_rec.poc_trans_id);

Line 3628: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3624: (p_resource_txn_rec => p_rsrc_txn_rec
3625: ,x_resource_txn_rec => x_rsrc_txn_rec
3626: ,x_return_status => x_return_status);
3627:
3628: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3629: RAISE validation_failure;
3630: END IF;
3631: --END IF;
3632:

Line 3759: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3755: || '.'
3756: || l_api_name);
3757: END IF;
3758:
3759: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3760: RAISE validation_failure;
3761: END IF;
3762:
3763: -- construct record for updation

Line 3892: x_return_status := fnd_api.g_ret_sts_error;

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;
3893: --Begin Bug#3479669
3894: --Added rsrc_txn_ins_err exception
3895: WHEN error_load_trans OR invalid_poc_trans_id OR rsrc_txn_upd_err OR rsrc_txn_ins_err THEN
3896: --End Bug#3479669

Line 3897: x_return_status := fnd_api.g_ret_sts_error;

3893: --Begin Bug#3479669
3894: --Added rsrc_txn_ins_err exception
3895: WHEN error_load_trans OR invalid_poc_trans_id OR rsrc_txn_upd_err OR rsrc_txn_ins_err THEN
3896: --End Bug#3479669
3897: x_return_status := fnd_api.g_ret_sts_error;
3898: WHEN validation_failure THEN
3899: x_return_status := fnd_api.g_ret_sts_error;
3900: WHEN uom_conversion_err OR invalid_txn_for_end THEN
3901: x_return_status := fnd_api.g_ret_sts_error;

Line 3899: x_return_status := fnd_api.g_ret_sts_error;

3895: WHEN error_load_trans OR invalid_poc_trans_id OR rsrc_txn_upd_err OR rsrc_txn_ins_err THEN
3896: --End Bug#3479669
3897: x_return_status := fnd_api.g_ret_sts_error;
3898: WHEN validation_failure THEN
3899: x_return_status := fnd_api.g_ret_sts_error;
3900: WHEN uom_conversion_err OR invalid_txn_for_end 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;

Line 3901: x_return_status := fnd_api.g_ret_sts_error;

3897: x_return_status := fnd_api.g_ret_sts_error;
3898: WHEN validation_failure THEN
3899: x_return_status := fnd_api.g_ret_sts_error;
3900: WHEN uom_conversion_err OR invalid_txn_for_end 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

Line 3903: x_return_status := fnd_api.g_ret_sts_error;

3899: x_return_status := fnd_api.g_ret_sts_error;
3900: WHEN uom_conversion_err OR invalid_txn_for_end 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

Line 3914: x_return_status := fnd_api.g_ret_sts_unexp_error;

3910: || ' Error is '
3911: || SQLERRM);
3912: END IF;
3913:
3914: x_return_status := fnd_api.g_ret_sts_unexp_error;
3915: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3916: END end_cmplt_actual_rsrc_txn;
3917: END gme_resource_engine_pvt;