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.

[Home] [Help]

APPS.GME_BATCHSTEP_ACT_PVT dependencies on FND_API

Line 67: x_return_status := fnd_api.g_ret_sts_success;

63: );
64: END IF;
65:
66: /* Set the return status to success initially */
67: x_return_status := fnd_api.g_ret_sts_success;
68:
69: IF p_org_code IS NULL
70: THEN
71: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

Line 75: RAISE fnd_api.g_exc_error;

71: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
72: 'FIELD_NAME',
73: 'ORGANIZATION'
74: );
75: RAISE fnd_api.g_exc_error;
76: ELSIF p_batch_no IS NULL
77: THEN
78: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
79: 'FIELD_NAME',

Line 82: RAISE fnd_api.g_exc_error;

78: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
79: 'FIELD_NAME',
80: 'BATCH NUMBER'
81: );
82: RAISE fnd_api.g_exc_error;
83: ELSIF p_batchstep_no IS NULL
84: THEN
85: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
86: 'FIELD_NAME',

Line 89: RAISE fnd_api.g_exc_error;

85: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
86: 'FIELD_NAME',
87: 'BATCH STEP NUMBER'
88: );
89: RAISE fnd_api.g_exc_error;
90: END IF;
91:
92: -- Validate input param one by one to see if it identifies an activity correctly
93: OPEN cur_get_batch_dtl (gme_common_pvt.g_organization_id, p_batch_no);

Line 100: RAISE fnd_api.g_exc_error;

96: IF cur_get_batch_dtl%NOTFOUND
97: THEN
98: CLOSE cur_get_batch_dtl;
99: gme_common_pvt.log_message ('GME_BATCH_NOT_FOUND');
100: RAISE fnd_api.g_exc_error;
101: END IF;
102:
103: CLOSE cur_get_batch_dtl;
104: -- use batch_id to fetch batchstep_id

Line 112: RAISE fnd_api.g_exc_error;

108: IF cur_get_batchstep_dtl%NOTFOUND
109: THEN
110: CLOSE cur_get_batchstep_dtl;
111: gme_common_pvt.log_message ('PC_INV_BATCHSTEP_NO');
112: RAISE fnd_api.g_exc_error;
113: END IF;
114:
115: CLOSE cur_get_batchstep_dtl;
116:

Line 132: RAISE fnd_api.g_exc_error;

128: p_activity,
129: 'STEP_NO',
130: p_batchstep_no
131: );
132: RAISE fnd_api.g_exc_error;
133: END IF;
134:
135: CLOSE cur_get_activity_id;
136: END IF;

Line 151: WHEN fnd_api.g_exc_error

147: || x_return_status
148: );
149: END IF;
150: EXCEPTION
151: WHEN fnd_api.g_exc_error
152: THEN
153: x_return_status := fnd_api.g_ret_sts_error;
154: WHEN fnd_api.g_exc_unexpected_error
155: THEN

Line 153: x_return_status := fnd_api.g_ret_sts_error;

149: END IF;
150: EXCEPTION
151: WHEN fnd_api.g_exc_error
152: THEN
153: x_return_status := fnd_api.g_ret_sts_error;
154: WHEN fnd_api.g_exc_unexpected_error
155: THEN
156: x_return_status := fnd_api.g_ret_sts_unexp_error;
157:

Line 154: WHEN fnd_api.g_exc_unexpected_error

150: EXCEPTION
151: WHEN fnd_api.g_exc_error
152: THEN
153: x_return_status := fnd_api.g_ret_sts_error;
154: WHEN fnd_api.g_exc_unexpected_error
155: THEN
156: x_return_status := fnd_api.g_ret_sts_unexp_error;
157:
158: IF (NVL (g_debug, 0) > 0)

Line 156: x_return_status := fnd_api.g_ret_sts_unexp_error;

152: THEN
153: x_return_status := fnd_api.g_ret_sts_error;
154: WHEN fnd_api.g_exc_unexpected_error
155: THEN
156: x_return_status := fnd_api.g_ret_sts_unexp_error;
157:
158: IF (NVL (g_debug, 0) > 0)
159: THEN
160: gme_debug.put_line ( g_pkg_name

Line 171: x_return_status := fnd_api.g_ret_sts_unexp_error;

167: END IF;
168: WHEN OTHERS
169: THEN
170: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
171: x_return_status := fnd_api.g_ret_sts_unexp_error;
172:
173: IF (NVL (g_debug, 0) > 0)
174: THEN
175: gme_debug.put_line ( g_pkg_name

Line 198: DEFAULT fnd_api.g_false,

194: PROCEDURE validate_activity_param (
195: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,
196: p_step_id IN NUMBER,
197: p_validate_flexfield IN VARCHAR2
198: DEFAULT fnd_api.g_false,
199: p_action IN VARCHAR2,
200: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
201: x_step_status OUT NOCOPY NUMBER,
202: x_return_status OUT NOCOPY VARCHAR2

Line 247: x_return_status := fnd_api.g_ret_sts_success;

243: );
244: END IF;
245:
246: /* Set the return status to success initially */
247: x_return_status := fnd_api.g_ret_sts_success;
248:
249: --{
250: IF (p_action = 'INSERT')
251: THEN

Line 260: RAISE fnd_api.g_exc_error;

256: IF l_batch_type = 10
257: THEN
258: CLOSE cur_check_fpo;
259: gme_common_pvt.log_message ('GME_FPO_ACTV_NO_INS');
260: RAISE fnd_api.g_exc_error;
261: END IF;
262:
263: CLOSE cur_check_fpo;
264: -- check activity

Line 272: RAISE fnd_api.g_exc_error;

268: IF cur_check_activity%NOTFOUND
269: THEN
270: CLOSE cur_check_activity;
271: gme_common_pvt.log_message ('GME_BAD_ACTIVITY');
272: RAISE fnd_api.g_exc_error;
273: END IF;
274:
275: CLOSE cur_check_activity;
276: -- Fetch step info

Line 287: RAISE fnd_api.g_exc_error;

283: gme_common_pvt.log_message ('GME_BATCH_STEP_NOT_FOUND',
284: 'STEP_ID',
285: p_step_id
286: );
287: RAISE fnd_api.g_exc_error;
288: END IF;
289:
290: CLOSE cur_get_step_dtl;
291:

Line 295: RAISE fnd_api.g_exc_error;

291:
292: IF l_step_dtl.step_status IN (4, 5)
293: THEN -- Closed or cancelled step
294: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');
295: RAISE fnd_api.g_exc_error;
296: END IF;
297:
298: -- check ASQC property - can't insert into WIP step for ASQC batch
299: OPEN cur_get_batch_asqc (l_step_dtl.batch_id);

Line 306: RAISE fnd_api.g_exc_error;

302:
303: IF l_batch_asqc = 1 AND l_step_dtl.step_status = 2
304: THEN
305: gme_common_pvt.log_message ('GME_INVALID_ASQC_ACTION_ACTV');
306: RAISE fnd_api.g_exc_error;
307: END IF;
308:
309: -- check plan activity factor
310: IF l_step_dtl.step_status = 1

Line 317: RAISE fnd_api.g_exc_error;

313: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
314: 'FIELD_NAME',
315: 'PLAN_ACTIVITY_FACTOR'
316: );
317: RAISE fnd_api.g_exc_error;
318: END IF;
319:
320: -- check actual activity factor
321: IF l_step_dtl.step_status IN (2, 3)

Line 328: RAISE fnd_api.g_exc_error;

324: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
325: 'FIELD_NAME',
326: 'ACTUAL_ACTIVITY_FACTOR'
327: );
328: RAISE fnd_api.g_exc_error;
329: END IF;
330:
331: l_batchstep_activity_rec := p_batchstep_activity_rec;
332: l_batchstep_activity_rec.material_ind := NULL;

Line 356: RAISE fnd_api.g_exc_error;

352: gme_common_pvt.log_message ('GME_ACTV_PLAN_DATE',
353: 'ACTIVITY',
354: p_batchstep_activity_rec.activity
355: );
356: RAISE fnd_api.g_exc_error;
357: END IF;
358:
359: IF p_batchstep_activity_rec.plan_start_date IS NOT NULL
360: AND p_batchstep_activity_rec.plan_cmplt_date IS NOT NULL

Line 366: RAISE fnd_api.g_exc_error;

362: p_batchstep_activity_rec.plan_cmplt_date
363: )
364: THEN
365: gme_common_pvt.log_message ('PM_BADSTARTDATE');
366: RAISE fnd_api.g_exc_error;
367: END IF;
368:
369: IF p_batchstep_activity_rec.plan_cmplt_date IS NOT NULL
370: AND (p_batchstep_activity_rec.plan_cmplt_date >

Line 378: RAISE fnd_api.g_exc_error;

374: gme_common_pvt.log_message ('GME_ACTV_PLAN_DATE',
375: 'ACTIVITY',
376: p_batchstep_activity_rec.activity
377: );
378: RAISE fnd_api.g_exc_error;
379: END IF;
380:
381: -- Default the plan dates if they were not passed in
382: IF p_batchstep_activity_rec.plan_start_date IS NULL

Line 409: RAISE fnd_api.g_exc_error;

405: THEN
406: gme_common_pvt.log_message (p_message_code => 'SY_NOFUTUREDATE',
407: p_product_code => 'GMA'
408: );
409: RAISE fnd_api.g_exc_error;
410: END IF;
411:
412: -- Check that the activity actual dates fall within the step dates.
413: IF p_batchstep_activity_rec.actual_start_date IS NOT NULL

Line 424: RAISE fnd_api.g_exc_error;

420: gme_common_pvt.log_message ('GME_ACTV_ACTUAL_DATE',
421: 'ACTIVITY',
422: p_batchstep_activity_rec.activity
423: );
424: RAISE fnd_api.g_exc_error;
425: END IF;
426:
427: -- default actual start date if not supplied
428: IF p_batchstep_activity_rec.actual_start_date IS NULL

Line 446: RAISE fnd_api.g_exc_error;

442: gme_common_pvt.g_timestamp
443: THEN
444: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
445: fnd_msg_pub.ADD;
446: RAISE fnd_api.g_exc_error;
447: END IF;
448:
449: IF p_batchstep_activity_rec.actual_start_date IS NOT NULL
450: AND p_batchstep_activity_rec.actual_cmplt_date IS NOT NULL

Line 456: RAISE fnd_api.g_exc_error;

452: p_batchstep_activity_rec.actual_cmplt_date
453: )
454: THEN
455: gme_common_pvt.log_message ('PM_BADSTARTDATE');
456: RAISE fnd_api.g_exc_error;
457: END IF;
458:
459: IF p_batchstep_activity_rec.actual_cmplt_date IS NOT NULL
460: AND p_batchstep_activity_rec.actual_cmplt_date >

Line 467: RAISE fnd_api.g_exc_error;

463: gme_common_pvt.log_message ('GME_ACTV_ACTUAL_DATE',
464: 'ACTIVITY',
465: p_batchstep_activity_rec.activity
466: );
467: RAISE fnd_api.g_exc_error;
468: END IF;
469:
470: IF p_batchstep_activity_rec.actual_cmplt_date IS NULL
471: THEN

Line 494: RAISE fnd_api.g_exc_error;

490:
491: IF l_activity_factor = 0
492: THEN
493: gme_common_pvt.log_message ('GME_ZERO_ACT_FACT');
494: RAISE fnd_api.g_exc_error;
495: END IF;
496:
497: --{
498: IF ( (fnd_api.to_boolean (p_validate_flexfield))

Line 498: IF ( (fnd_api.to_boolean (p_validate_flexfield))

494: RAISE fnd_api.g_exc_error;
495: END IF;
496:
497: --{
498: IF ( (fnd_api.to_boolean (p_validate_flexfield))
499: AND ( p_batchstep_activity_rec.attribute_category IS NOT NULL
500: OR p_batchstep_activity_rec.attribute1 IS NOT NULL
501: OR p_batchstep_activity_rec.attribute2 IS NOT NULL
502: OR p_batchstep_activity_rec.attribute3 IS NOT NULL

Line 538: IF (x_return_status = fnd_api.g_ret_sts_error)

534: x_step_activities => x_batchstep_activity_rec,
535: x_return_status => x_return_status
536: );
537:
538: IF (x_return_status = fnd_api.g_ret_sts_error)
539: THEN
540: RAISE fnd_api.g_exc_error;
541: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
542: THEN

Line 540: RAISE fnd_api.g_exc_error;

536: );
537:
538: IF (x_return_status = fnd_api.g_ret_sts_error)
539: THEN
540: RAISE fnd_api.g_exc_error;
541: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
542: THEN
543: RAISE fnd_api.g_exc_unexpected_error;
544: END IF;

Line 541: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

537:
538: IF (x_return_status = fnd_api.g_ret_sts_error)
539: THEN
540: RAISE fnd_api.g_exc_error;
541: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
542: THEN
543: RAISE fnd_api.g_exc_unexpected_error;
544: END IF;
545:

Line 543: RAISE fnd_api.g_exc_unexpected_error;

539: THEN
540: RAISE fnd_api.g_exc_error;
541: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
542: THEN
543: RAISE fnd_api.g_exc_unexpected_error;
544: END IF;
545:
546: l_batchstep_activity_rec.attribute_category :=
547: x_batchstep_activity_rec.attribute_category;

Line 626: WHEN fnd_api.g_exc_error

622: || x_return_status
623: );
624: END IF;
625: EXCEPTION
626: WHEN fnd_api.g_exc_error
627: THEN
628: x_return_status := fnd_api.g_ret_sts_error;
629: WHEN fnd_api.g_exc_unexpected_error
630: THEN

Line 628: x_return_status := fnd_api.g_ret_sts_error;

624: END IF;
625: EXCEPTION
626: WHEN fnd_api.g_exc_error
627: THEN
628: x_return_status := fnd_api.g_ret_sts_error;
629: WHEN fnd_api.g_exc_unexpected_error
630: THEN
631: x_return_status := fnd_api.g_ret_sts_unexp_error;
632:

Line 629: WHEN fnd_api.g_exc_unexpected_error

625: EXCEPTION
626: WHEN fnd_api.g_exc_error
627: THEN
628: x_return_status := fnd_api.g_ret_sts_error;
629: WHEN fnd_api.g_exc_unexpected_error
630: THEN
631: x_return_status := fnd_api.g_ret_sts_unexp_error;
632:
633: IF (NVL (g_debug, 0) > 0)

Line 631: x_return_status := fnd_api.g_ret_sts_unexp_error;

627: THEN
628: x_return_status := fnd_api.g_ret_sts_error;
629: WHEN fnd_api.g_exc_unexpected_error
630: THEN
631: x_return_status := fnd_api.g_ret_sts_unexp_error;
632:
633: IF (NVL (g_debug, 0) > 0)
634: THEN
635: gme_debug.put_line ( g_pkg_name

Line 646: x_return_status := fnd_api.g_ret_sts_unexp_error;

642: END IF;
643: WHEN OTHERS
644: THEN
645: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
646: x_return_status := fnd_api.g_ret_sts_unexp_error;
647:
648: IF (NVL (g_debug, 0) > 0)
649: THEN
650: gme_debug.put_line ( g_pkg_name

Line 679: DEFAULT fnd_api.g_false,

675: p_org_code IN VARCHAR2 := NULL,
676: p_batch_no IN VARCHAR2 := NULL,
677: p_batchstep_no IN NUMBER := NULL,
678: p_ignore_qty_below_cap IN VARCHAR2
679: DEFAULT fnd_api.g_false,
680: p_validate_flexfield IN VARCHAR2
681: DEFAULT fnd_api.g_false,
682: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
683: x_return_status OUT NOCOPY VARCHAR2

Line 681: DEFAULT fnd_api.g_false,

677: p_batchstep_no IN NUMBER := NULL,
678: p_ignore_qty_below_cap IN VARCHAR2
679: DEFAULT fnd_api.g_false,
680: p_validate_flexfield IN VARCHAR2
681: DEFAULT fnd_api.g_false,
682: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
683: x_return_status OUT NOCOPY VARCHAR2
684: )
685: IS

Line 718: x_return_status := fnd_api.g_ret_sts_success;

714: );
715: END IF;
716:
717: /* Set the return status to success initially */
718: x_return_status := fnd_api.g_ret_sts_success;
719:
720: IF p_batchstep_activity_rec.activity IS NULL
721: THEN
722: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

Line 726: RAISE fnd_api.g_exc_error;

722: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
723: 'FIELD_NAME',
724: 'ACTIVITY'
725: );
726: RAISE fnd_api.g_exc_error;
727: END IF;
728:
729: IF p_batchstep_activity_rec.batchstep_id IS NOT NULL
730: THEN

Line 743: RAISE fnd_api.g_exc_error;

739: gme_common_pvt.log_message ('GME_BATCH_STEP_NOT_FOUND',
740: 'STEP_ID',
741: l_batchstep_id
742: );
743: RAISE fnd_api.g_exc_error;
744: END IF;
745:
746: CLOSE cur_validate_step;
747: ELSE

Line 772: IF (x_return_status = fnd_api.g_ret_sts_error)

768: || x_return_status
769: );
770: END IF;
771:
772: IF (x_return_status = fnd_api.g_ret_sts_error)
773: THEN
774: RAISE fnd_api.g_exc_error;
775: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
776: THEN

Line 774: RAISE fnd_api.g_exc_error;

770: END IF;
771:
772: IF (x_return_status = fnd_api.g_ret_sts_error)
773: THEN
774: RAISE fnd_api.g_exc_error;
775: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
776: THEN
777: RAISE fnd_api.g_exc_unexpected_error;
778: END IF;

Line 775: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

771:
772: IF (x_return_status = fnd_api.g_ret_sts_error)
773: THEN
774: RAISE fnd_api.g_exc_error;
775: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
776: THEN
777: RAISE fnd_api.g_exc_unexpected_error;
778: END IF;
779: END IF;

Line 777: RAISE fnd_api.g_exc_unexpected_error;

773: THEN
774: RAISE fnd_api.g_exc_error;
775: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
776: THEN
777: RAISE fnd_api.g_exc_unexpected_error;
778: END IF;
779: END IF;
780:
781: validate_activity_param (p_batchstep_activity_rec => p_batchstep_activity_rec,

Line 801: IF (x_return_status = fnd_api.g_ret_sts_error)

797: || x_return_status
798: );
799: END IF;
800:
801: IF (x_return_status = fnd_api.g_ret_sts_error)
802: THEN
803: RAISE fnd_api.g_exc_error;
804: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
805: THEN

Line 803: RAISE fnd_api.g_exc_error;

799: END IF;
800:
801: IF (x_return_status = fnd_api.g_ret_sts_error)
802: THEN
803: RAISE fnd_api.g_exc_error;
804: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
805: THEN
806: RAISE fnd_api.g_exc_unexpected_error;
807: END IF;

Line 804: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

800:
801: IF (x_return_status = fnd_api.g_ret_sts_error)
802: THEN
803: RAISE fnd_api.g_exc_error;
804: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
805: THEN
806: RAISE fnd_api.g_exc_unexpected_error;
807: END IF;
808:

Line 806: RAISE fnd_api.g_exc_unexpected_error;

802: THEN
803: RAISE fnd_api.g_exc_error;
804: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
805: THEN
806: RAISE fnd_api.g_exc_unexpected_error;
807: END IF;
808:
809: l_batchstep_activity_rec.batch_id := l_batch_id;
810: l_batchstep_activity_rec.batchstep_id := l_batchstep_id;

Line 825: RAISE fnd_api.g_exc_error;

821: p_token1_value => p_batchstep_activity_rec.activity,
822: p_token2_name => 'STEPNO',
823: p_token2_value => p_batchstep_no
824: );
825: RAISE fnd_api.g_exc_error;
826: END IF;
827:
828: l_prim_rsrc_count := 0;
829:

Line 847: IF (x_return_status = fnd_api.g_ret_sts_error)

843: x_step_status => l_step_status,
844: x_return_status => x_return_status
845: );
846:
847: IF (x_return_status = fnd_api.g_ret_sts_error)
848: THEN
849: RAISE fnd_api.g_exc_error;
850: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
851: THEN

Line 849: RAISE fnd_api.g_exc_error;

845: );
846:
847: IF (x_return_status = fnd_api.g_ret_sts_error)
848: THEN
849: RAISE fnd_api.g_exc_error;
850: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
851: THEN
852: RAISE fnd_api.g_exc_unexpected_error;
853: END IF;

Line 850: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

846:
847: IF (x_return_status = fnd_api.g_ret_sts_error)
848: THEN
849: RAISE fnd_api.g_exc_error;
850: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
851: THEN
852: RAISE fnd_api.g_exc_unexpected_error;
853: END IF;
854:

Line 852: RAISE fnd_api.g_exc_unexpected_error;

848: THEN
849: RAISE fnd_api.g_exc_error;
850: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
851: THEN
852: RAISE fnd_api.g_exc_unexpected_error;
853: END IF;
854:
855: gme_batchstep_rsrc_pvt.validate_rsrc_param (p_batchstep_resource_rec => p_batchstep_resource_tbl (i
856: ),

Line 866: IF (x_return_status = fnd_api.g_ret_sts_error)

862: x_step_status => l_step_status,
863: x_return_status => x_return_status
864: );
865:
866: IF (x_return_status = fnd_api.g_ret_sts_error)
867: THEN
868: RAISE fnd_api.g_exc_error;
869: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
870: THEN

Line 868: RAISE fnd_api.g_exc_error;

864: );
865:
866: IF (x_return_status = fnd_api.g_ret_sts_error)
867: THEN
868: RAISE fnd_api.g_exc_error;
869: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
870: THEN
871: RAISE fnd_api.g_exc_unexpected_error;
872: END IF;

Line 869: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

865:
866: IF (x_return_status = fnd_api.g_ret_sts_error)
867: THEN
868: RAISE fnd_api.g_exc_error;
869: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
870: THEN
871: RAISE fnd_api.g_exc_unexpected_error;
872: END IF;
873:

Line 871: RAISE fnd_api.g_exc_unexpected_error;

867: THEN
868: RAISE fnd_api.g_exc_error;
869: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
870: THEN
871: RAISE fnd_api.g_exc_unexpected_error;
872: END IF;
873:
874: IF NVL (p_batchstep_resource_tbl (i).prim_rsrc_ind, 0) = 1
875: THEN

Line 888: RAISE fnd_api.g_exc_error;

884: l_batchstep_activity_rec.activity,
885: 'STEPNO',
886: p_batchstep_no
887: );
888: RAISE fnd_api.g_exc_error;
889: END IF;
890:
891: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)
892: THEN

Line 909: RAISE fnd_api.g_exc_error;

905: l_batchstep_activity_out_rec
906: )
907: )
908: THEN
909: RAISE fnd_api.g_exc_error;
910: END IF;
911:
912: IF (NVL (g_debug, -1) = gme_debug.g_log_statement)
913: THEN

Line 940: IF (x_return_status = fnd_api.g_ret_sts_error)

936: x_batchstep_resource_rec => l_batchstep_resource_out_rec,
937: x_return_status => x_return_status
938: );
939:
940: IF (x_return_status = fnd_api.g_ret_sts_error)
941: THEN
942: RAISE fnd_api.g_exc_error;
943: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
944: THEN

Line 942: RAISE fnd_api.g_exc_error;

938: );
939:
940: IF (x_return_status = fnd_api.g_ret_sts_error)
941: THEN
942: RAISE fnd_api.g_exc_error;
943: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
944: THEN
945: RAISE fnd_api.g_exc_unexpected_error;
946: END IF;

Line 943: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

939:
940: IF (x_return_status = fnd_api.g_ret_sts_error)
941: THEN
942: RAISE fnd_api.g_exc_error;
943: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
944: THEN
945: RAISE fnd_api.g_exc_unexpected_error;
946: END IF;
947: END LOOP;

Line 945: RAISE fnd_api.g_exc_unexpected_error;

941: THEN
942: RAISE fnd_api.g_exc_error;
943: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
944: THEN
945: RAISE fnd_api.g_exc_unexpected_error;
946: END IF;
947: END LOOP;
948:
949: x_batchstep_activity_rec := l_batchstep_activity_out_rec;

Line 964: WHEN fnd_api.g_exc_error

960: || x_return_status
961: );
962: END IF;
963: EXCEPTION
964: WHEN fnd_api.g_exc_error
965: THEN
966: x_batchstep_activity_rec := NULL;
967: x_return_status := fnd_api.g_ret_sts_error;
968: WHEN fnd_api.g_exc_unexpected_error

Line 967: x_return_status := fnd_api.g_ret_sts_error;

963: EXCEPTION
964: WHEN fnd_api.g_exc_error
965: THEN
966: x_batchstep_activity_rec := NULL;
967: x_return_status := fnd_api.g_ret_sts_error;
968: WHEN fnd_api.g_exc_unexpected_error
969: THEN
970: x_batchstep_activity_rec := NULL;
971: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 968: WHEN fnd_api.g_exc_unexpected_error

964: WHEN fnd_api.g_exc_error
965: THEN
966: x_batchstep_activity_rec := NULL;
967: x_return_status := fnd_api.g_ret_sts_error;
968: WHEN fnd_api.g_exc_unexpected_error
969: THEN
970: x_batchstep_activity_rec := NULL;
971: x_return_status := fnd_api.g_ret_sts_unexp_error;
972:

Line 971: x_return_status := fnd_api.g_ret_sts_unexp_error;

967: x_return_status := fnd_api.g_ret_sts_error;
968: WHEN fnd_api.g_exc_unexpected_error
969: THEN
970: x_batchstep_activity_rec := NULL;
971: x_return_status := fnd_api.g_ret_sts_unexp_error;
972:
973: IF (NVL (g_debug, 0) > 0)
974: THEN
975: gme_debug.put_line ( g_pkg_name

Line 987: x_return_status := fnd_api.g_ret_sts_unexp_error;

983: WHEN OTHERS
984: THEN
985: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
986: x_batchstep_activity_rec := NULL;
987: x_return_status := fnd_api.g_ret_sts_unexp_error;
988:
989: IF (NVL (g_debug, 0) > 0)
990: THEN
991: gme_debug.put_line ( g_pkg_name

Line 1020: DEFAULT fnd_api.g_false,

1016: p_org_code IN VARCHAR2 := NULL,
1017: p_batch_no IN VARCHAR2 := NULL,
1018: p_batchstep_no IN NUMBER := NULL,
1019: p_validate_flexfield IN VARCHAR2
1020: DEFAULT fnd_api.g_false,
1021: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
1022: x_return_status OUT NOCOPY VARCHAR2
1023: )
1024: IS

Line 1105: x_return_status := fnd_api.g_ret_sts_success;

1101: );
1102: END IF;
1103:
1104: /* Set the return status to success initially */
1105: x_return_status := fnd_api.g_ret_sts_success;
1106:
1107: IF ( p_batchstep_activity_rec.activity IS NULL
1108: AND p_batchstep_activity_rec.batchstep_activity_id IS NULL
1109: )

Line 1115: RAISE fnd_api.g_exc_error;

1111: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1112: 'FIELD_NAME',
1113: 'ACTIVITY'
1114: );
1115: RAISE fnd_api.g_exc_error;
1116: END IF;
1117:
1118: IF p_batchstep_activity_rec.batchstep_activity_id IS NOT NULL
1119: THEN

Line 1130: RAISE fnd_api.g_exc_error;

1126: IF cur_get_dtl%NOTFOUND
1127: THEN
1128: CLOSE cur_get_dtl;
1129: gme_common_pvt.log_message ('GME_ACTID_NOT_FOUND');
1130: RAISE fnd_api.g_exc_error;
1131: END IF;
1132:
1133: CLOSE cur_get_dtl;
1134: ELSE

Line 1160: IF (x_return_status = fnd_api.g_ret_sts_error)

1156: || x_return_status
1157: );
1158: END IF;
1159:
1160: IF (x_return_status = fnd_api.g_ret_sts_error)
1161: THEN
1162: RAISE fnd_api.g_exc_error;
1163: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1164: THEN

Line 1162: RAISE fnd_api.g_exc_error;

1158: END IF;
1159:
1160: IF (x_return_status = fnd_api.g_ret_sts_error)
1161: THEN
1162: RAISE fnd_api.g_exc_error;
1163: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1164: THEN
1165: RAISE fnd_api.g_exc_unexpected_error;
1166: END IF;

Line 1163: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

1159:
1160: IF (x_return_status = fnd_api.g_ret_sts_error)
1161: THEN
1162: RAISE fnd_api.g_exc_error;
1163: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1164: THEN
1165: RAISE fnd_api.g_exc_unexpected_error;
1166: END IF;
1167: END IF;

Line 1165: RAISE fnd_api.g_exc_unexpected_error;

1161: THEN
1162: RAISE fnd_api.g_exc_error;
1163: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1164: THEN
1165: RAISE fnd_api.g_exc_unexpected_error;
1166: END IF;
1167: END IF;
1168:
1169: -- Check if this is an FPO

Line 1177: RAISE fnd_api.g_exc_error;

1173: IF l_batch_type = 10
1174: THEN
1175: CLOSE cur_check_fpo;
1176: gme_common_pvt.log_message ('GME_FPO_ACTV_NO_EDIT');
1177: RAISE fnd_api.g_exc_error;
1178: END IF;
1179:
1180: CLOSE cur_check_fpo;
1181: OPEN cur_lock_actv (l_activity_id);

Line 1195: RAISE fnd_api.g_exc_error;

1191: l_batchstep_activity_rec
1192: )
1193: )
1194: THEN
1195: RAISE fnd_api.g_exc_error;
1196: END IF;
1197:
1198: l_seq_dep_ind := l_batchstep_activity_rec.sequence_dependent_ind;
1199:

Line 1203: RAISE fnd_api.g_exc_error;

1199:
1200: IF l_step_status IN (4, 5)
1201: THEN
1202: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');
1203: RAISE fnd_api.g_exc_error;
1204: END IF;
1205:
1206: IF p_batchstep_activity_rec.offset_interval = fnd_api.g_miss_num
1207: THEN

Line 1206: IF p_batchstep_activity_rec.offset_interval = fnd_api.g_miss_num

1202: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');
1203: RAISE fnd_api.g_exc_error;
1204: END IF;
1205:
1206: IF p_batchstep_activity_rec.offset_interval = fnd_api.g_miss_num
1207: THEN
1208: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1209: 'FIELD_NAME',
1210: 'offset_interval'

Line 1212: RAISE fnd_api.g_exc_error;

1208: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1209: 'FIELD_NAME',
1210: 'offset_interval'
1211: );
1212: RAISE fnd_api.g_exc_error;
1213: ELSIF ( p_batchstep_activity_rec.offset_interval IS NOT NULL
1214: AND (l_batchstep_activity_rec.offset_interval <>
1215: p_batchstep_activity_rec.offset_interval
1216: )

Line 1230: IF p_batchstep_activity_rec.plan_start_date = fnd_api.g_miss_date

1226: CLOSE cur_get_step_dtl;
1227:
1228: IF l_step_status IN (1, 2)
1229: THEN
1230: IF p_batchstep_activity_rec.plan_start_date = fnd_api.g_miss_date
1231: THEN
1232: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1233: 'FIELD_NAME',
1234: 'plan_start_date'

Line 1236: RAISE fnd_api.g_exc_error;

1232: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1233: 'FIELD_NAME',
1234: 'plan_start_date'
1235: );
1236: RAISE fnd_api.g_exc_error;
1237: ELSIF p_batchstep_activity_rec.plan_start_date IS NOT NULL
1238: AND (p_batchstep_activity_rec.plan_start_date <>
1239: l_batchstep_activity_rec.plan_start_date
1240: )

Line 1252: RAISE fnd_api.g_exc_error;

1248: gme_common_pvt.log_message ('GME_ACTV_PLAN_DATE',
1249: 'ACTIVITY',
1250: l_activity
1251: );
1252: RAISE fnd_api.g_exc_error;
1253: END IF;
1254:
1255: l_field_updated := TRUE;
1256: l_upd_plan_date := TRUE;

Line 1261: IF p_batchstep_activity_rec.plan_cmplt_date = fnd_api.g_miss_date

1257: l_batchstep_activity_rec.plan_start_date :=
1258: p_batchstep_activity_rec.plan_start_date;
1259: END IF;
1260:
1261: IF p_batchstep_activity_rec.plan_cmplt_date = fnd_api.g_miss_date
1262: THEN
1263: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1264: 'FIELD_NAME',
1265: 'plan_cmplt_date'

Line 1267: RAISE fnd_api.g_exc_error;

1263: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1264: 'FIELD_NAME',
1265: 'plan_cmplt_date'
1266: );
1267: RAISE fnd_api.g_exc_error;
1268: ELSIF p_batchstep_activity_rec.plan_cmplt_date IS NOT NULL
1269: AND (p_batchstep_activity_rec.plan_cmplt_date <>
1270: l_batchstep_activity_rec.plan_cmplt_date
1271: )

Line 1281: RAISE fnd_api.g_exc_error;

1277: gme_common_pvt.log_message ('GME_ACTV_PLAN_DATE',
1278: 'ACTIVITY',
1279: l_activity
1280: );
1281: RAISE fnd_api.g_exc_error;
1282: END IF;
1283:
1284: l_field_updated := TRUE;
1285: l_upd_plan_date := TRUE;

Line 1296: RAISE fnd_api.g_exc_error;

1292: l_batchstep_activity_rec.plan_cmplt_date
1293: )
1294: THEN
1295: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1296: RAISE fnd_api.g_exc_error;
1297: END IF;
1298: END IF;
1299:
1300: IF l_step_dtl.step_status IN (2, 3)

Line 1302: IF p_batchstep_activity_rec.actual_start_date = fnd_api.g_miss_date

1298: END IF;
1299:
1300: IF l_step_dtl.step_status IN (2, 3)
1301: THEN
1302: IF p_batchstep_activity_rec.actual_start_date = fnd_api.g_miss_date
1303: THEN
1304: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1305: 'FIELD_NAME',
1306: 'actual_start_date'

Line 1308: RAISE fnd_api.g_exc_error;

1304: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1305: 'FIELD_NAME',
1306: 'actual_start_date'
1307: );
1308: RAISE fnd_api.g_exc_error;
1309: ELSIF p_batchstep_activity_rec.actual_start_date IS NOT NULL
1310: AND (p_batchstep_activity_rec.actual_start_date <>
1311: l_batchstep_activity_rec.actual_start_date
1312: )

Line 1320: RAISE fnd_api.g_exc_error;

1316: gme_common_pvt.g_timestamp
1317: THEN
1318: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
1319: fnd_msg_pub.ADD;
1320: RAISE fnd_api.g_exc_error;
1321: END IF;
1322:
1323: -- Check that the activity actual dates fall within the step dates.
1324: IF ( p_batchstep_activity_rec.actual_start_date <

Line 1334: RAISE fnd_api.g_exc_error;

1330: gme_common_pvt.log_message ('GME_ACTV_ACTUAL_DATE',
1331: 'ACTIVITY',
1332: l_activity
1333: );
1334: RAISE fnd_api.g_exc_error;
1335: END IF;
1336:
1337: l_field_updated := TRUE;
1338: l_upd_act_date := TRUE;

Line 1346: IF p_batchstep_activity_rec.actual_cmplt_date = fnd_api.g_miss_date

1342: END IF;
1343:
1344: IF l_step_dtl.step_status = 3
1345: THEN
1346: IF p_batchstep_activity_rec.actual_cmplt_date = fnd_api.g_miss_date
1347: THEN
1348: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1349: 'FIELD_NAME',
1350: 'actual_cmplt_date'

Line 1352: RAISE fnd_api.g_exc_error;

1348: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1349: 'FIELD_NAME',
1350: 'actual_cmplt_date'
1351: );
1352: RAISE fnd_api.g_exc_error;
1353: ELSIF p_batchstep_activity_rec.actual_cmplt_date IS NOT NULL
1354: AND (p_batchstep_activity_rec.actual_cmplt_date <>
1355: l_batchstep_activity_rec.actual_cmplt_date
1356: )

Line 1364: RAISE fnd_api.g_exc_error;

1360: gme_common_pvt.g_timestamp
1361: THEN
1362: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
1363: fnd_msg_pub.ADD;
1364: RAISE fnd_api.g_exc_error;
1365: END IF;
1366:
1367: IF p_batchstep_activity_rec.actual_cmplt_date IS NOT NULL
1368: AND p_batchstep_activity_rec.actual_cmplt_date >

Line 1375: RAISE fnd_api.g_exc_error;

1371: gme_common_pvt.log_message ('GME_ACTV_ACTUAL_DATE',
1372: 'ACTIVITY',
1373: l_activity
1374: );
1375: RAISE fnd_api.g_exc_error;
1376: END IF;
1377:
1378: l_field_updated := TRUE;
1379: l_upd_act_date := TRUE;

Line 1391: RAISE fnd_api.g_exc_error;

1387: l_batchstep_activity_rec.actual_cmplt_date
1388: )
1389: THEN
1390: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1391: RAISE fnd_api.g_exc_error;
1392: END IF;
1393:
1394: -- check that activities dates are within resource dates
1395: IF l_upd_plan_date OR l_upd_act_date

Line 1432: RAISE fnd_api.g_exc_error;

1428: gme_common_pvt.log_message ('GME_RSRC_DATES_NOT_ALLOWED',
1429: 'RESOURCE',
1430: 'l_resource'
1431: );
1432: RAISE fnd_api.g_exc_error;
1433: END IF;
1434: END IF;
1435:
1436: --fix to g_miss_num and comparison to not NULL for l_batchstep_activity_rec

Line 1438: fnd_api.g_miss_num

1434: END IF;
1435:
1436: --fix to g_miss_num and comparison to not NULL for l_batchstep_activity_rec
1437: IF p_batchstep_activity_rec.plan_activity_factor =
1438: fnd_api.g_miss_num
1439: AND l_batchstep_activity_rec.plan_activity_factor IS NOT NULL
1440: THEN
1441: gme_common_pvt.log_message ('GME_PLAN_ACTV_FACT_NOTNULL');
1442: RAISE fnd_api.g_exc_error;

Line 1442: RAISE fnd_api.g_exc_error;

1438: fnd_api.g_miss_num
1439: AND l_batchstep_activity_rec.plan_activity_factor IS NOT NULL
1440: THEN
1441: gme_common_pvt.log_message ('GME_PLAN_ACTV_FACT_NOTNULL');
1442: RAISE fnd_api.g_exc_error;
1443: END IF;
1444:
1445: IF ( p_batchstep_activity_rec.plan_activity_factor IS NOT NULL
1446: AND l_batchstep_activity_rec.plan_activity_factor IS NULL

Line 1463: fnd_api.g_miss_num

1459: END IF;
1460:
1461: --fix to g_miss_num and comparison to not NULL for l_batchstep_activity_rec
1462: IF p_batchstep_activity_rec.actual_activity_factor =
1463: fnd_api.g_miss_num
1464: AND l_batchstep_activity_rec.actual_activity_factor IS NOT NULL
1465: THEN
1466: gme_common_pvt.log_message ('GME_ACTUAL_ACTV_FACT_NOTNULL');
1467: RAISE fnd_api.g_exc_error;

Line 1467: RAISE fnd_api.g_exc_error;

1463: fnd_api.g_miss_num
1464: AND l_batchstep_activity_rec.actual_activity_factor IS NOT NULL
1465: THEN
1466: gme_common_pvt.log_message ('GME_ACTUAL_ACTV_FACT_NOTNULL');
1467: RAISE fnd_api.g_exc_error;
1468: END IF;
1469:
1470: IF ( p_batchstep_activity_rec.actual_activity_factor IS NOT NULL
1471: AND l_batchstep_activity_rec.actual_activity_factor IS NULL

Line 1486: IF (fnd_api.to_boolean (p_validate_flexfield))

1482: p_batchstep_activity_rec.actual_activity_factor;
1483: END IF;
1484: END IF;
1485:
1486: IF (fnd_api.to_boolean (p_validate_flexfield))
1487: THEN
1488: IF NVL (p_batchstep_activity_rec.attribute_category, ' ') <>
1489: NVL (l_batchstep_activity_rec.attribute_category, ' ')
1490: OR NVL (p_batchstep_activity_rec.attribute1, ' ') <>

Line 1569: IF (x_return_status = fnd_api.g_ret_sts_error)

1565: || x_return_status
1566: );
1567: END IF;
1568:
1569: IF (x_return_status = fnd_api.g_ret_sts_error)
1570: THEN
1571: RAISE fnd_api.g_exc_error;
1572: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1573: THEN

Line 1571: RAISE fnd_api.g_exc_error;

1567: END IF;
1568:
1569: IF (x_return_status = fnd_api.g_ret_sts_error)
1570: THEN
1571: RAISE fnd_api.g_exc_error;
1572: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1573: THEN
1574: RAISE fnd_api.g_exc_unexpected_error;
1575: END IF;

Line 1572: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

1568:
1569: IF (x_return_status = fnd_api.g_ret_sts_error)
1570: THEN
1571: RAISE fnd_api.g_exc_error;
1572: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1573: THEN
1574: RAISE fnd_api.g_exc_unexpected_error;
1575: END IF;
1576:

Line 1574: RAISE fnd_api.g_exc_unexpected_error;

1570: THEN
1571: RAISE fnd_api.g_exc_error;
1572: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1573: THEN
1574: RAISE fnd_api.g_exc_unexpected_error;
1575: END IF;
1576:
1577: -- copy all the validated flex fields
1578: l_batchstep_activity_rec.attribute_category :=

Line 1646: RAISE fnd_api.g_exc_error;

1642:
1643: IF NOT (l_field_updated)
1644: THEN
1645: gme_common_pvt.log_message ('GME_NO_CHANGE_TO_UPD');
1646: RAISE fnd_api.g_exc_error;
1647: END IF;
1648:
1649: IF (NVL (g_debug, -1) = gme_debug.g_log_statement)
1650: THEN

Line 1679: IF (x_return_status = fnd_api.g_ret_sts_error)

1675: || x_return_status
1676: );
1677: END IF;
1678:
1679: IF (x_return_status = fnd_api.g_ret_sts_error)
1680: THEN
1681: RAISE fnd_api.g_exc_error;
1682: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1683: THEN

Line 1681: RAISE fnd_api.g_exc_error;

1677: END IF;
1678:
1679: IF (x_return_status = fnd_api.g_ret_sts_error)
1680: THEN
1681: RAISE fnd_api.g_exc_error;
1682: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1683: THEN
1684: RAISE fnd_api.g_exc_unexpected_error;
1685: END IF;

Line 1682: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

1678:
1679: IF (x_return_status = fnd_api.g_ret_sts_error)
1680: THEN
1681: RAISE fnd_api.g_exc_error;
1682: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1683: THEN
1684: RAISE fnd_api.g_exc_unexpected_error;
1685: END IF;
1686: END IF;

Line 1684: RAISE fnd_api.g_exc_unexpected_error;

1680: THEN
1681: RAISE fnd_api.g_exc_error;
1682: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1683: THEN
1684: RAISE fnd_api.g_exc_unexpected_error;
1685: END IF;
1686: END IF;
1687:
1688: gme_update_step_qty_pvt.update_resources (p_batch_hdr_rec => l_batch_hdr,

Line 1705: IF (x_return_status = fnd_api.g_ret_sts_error)

1701: || x_return_status
1702: );
1703: END IF;
1704:
1705: IF (x_return_status = fnd_api.g_ret_sts_error)
1706: THEN
1707: RAISE fnd_api.g_exc_error;
1708: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1709: THEN

Line 1707: RAISE fnd_api.g_exc_error;

1703: END IF;
1704:
1705: IF (x_return_status = fnd_api.g_ret_sts_error)
1706: THEN
1707: RAISE fnd_api.g_exc_error;
1708: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1709: THEN
1710: RAISE fnd_api.g_exc_unexpected_error;
1711: END IF;

Line 1708: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

1704:
1705: IF (x_return_status = fnd_api.g_ret_sts_error)
1706: THEN
1707: RAISE fnd_api.g_exc_error;
1708: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1709: THEN
1710: RAISE fnd_api.g_exc_unexpected_error;
1711: END IF;
1712: END IF;

Line 1710: RAISE fnd_api.g_exc_unexpected_error;

1706: THEN
1707: RAISE fnd_api.g_exc_error;
1708: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1709: THEN
1710: RAISE fnd_api.g_exc_unexpected_error;
1711: END IF;
1712: END IF;
1713:
1714: IF NOT (gme_batch_step_activities_dbl.update_row (l_batchstep_activity_rec

Line 1718: RAISE fnd_api.g_exc_error;

1714: IF NOT (gme_batch_step_activities_dbl.update_row (l_batchstep_activity_rec
1715: )
1716: )
1717: THEN
1718: RAISE fnd_api.g_exc_error;
1719: END IF;
1720:
1721: IF l_seq_dep_ind <> l_batchstep_activity_rec.sequence_dependent_ind
1722: THEN

Line 1733: RAISE fnd_api.g_exc_error;

1729: l_batchstep_activity_rec
1730: )
1731: )
1732: THEN
1733: RAISE fnd_api.g_exc_error;
1734: END IF;
1735:
1736: x_batchstep_activity_rec := l_batchstep_activity_rec;
1737:

Line 1761: x_return_status := fnd_api.g_ret_sts_error;

1757: 'Activity',
1758: 'KEY',
1759: l_activity
1760: );
1761: x_return_status := fnd_api.g_ret_sts_error;
1762: WHEN fnd_api.g_exc_error
1763: THEN
1764: x_return_status := fnd_api.g_ret_sts_error;
1765: WHEN fnd_api.g_exc_unexpected_error

Line 1762: WHEN fnd_api.g_exc_error

1758: 'KEY',
1759: l_activity
1760: );
1761: x_return_status := fnd_api.g_ret_sts_error;
1762: WHEN fnd_api.g_exc_error
1763: THEN
1764: x_return_status := fnd_api.g_ret_sts_error;
1765: WHEN fnd_api.g_exc_unexpected_error
1766: THEN

Line 1764: x_return_status := fnd_api.g_ret_sts_error;

1760: );
1761: x_return_status := fnd_api.g_ret_sts_error;
1762: WHEN fnd_api.g_exc_error
1763: THEN
1764: x_return_status := fnd_api.g_ret_sts_error;
1765: WHEN fnd_api.g_exc_unexpected_error
1766: THEN
1767: x_return_status := fnd_api.g_ret_sts_unexp_error;
1768:

Line 1765: WHEN fnd_api.g_exc_unexpected_error

1761: x_return_status := fnd_api.g_ret_sts_error;
1762: WHEN fnd_api.g_exc_error
1763: THEN
1764: x_return_status := fnd_api.g_ret_sts_error;
1765: WHEN fnd_api.g_exc_unexpected_error
1766: THEN
1767: x_return_status := fnd_api.g_ret_sts_unexp_error;
1768:
1769: IF (NVL (g_debug, 0) > 0)

Line 1767: x_return_status := fnd_api.g_ret_sts_unexp_error;

1763: THEN
1764: x_return_status := fnd_api.g_ret_sts_error;
1765: WHEN fnd_api.g_exc_unexpected_error
1766: THEN
1767: x_return_status := fnd_api.g_ret_sts_unexp_error;
1768:
1769: IF (NVL (g_debug, 0) > 0)
1770: THEN
1771: gme_debug.put_line ( g_pkg_name

Line 1782: x_return_status := fnd_api.g_ret_sts_unexp_error;

1778: END IF;
1779: WHEN OTHERS
1780: THEN
1781: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1782: x_return_status := fnd_api.g_ret_sts_unexp_error;
1783:
1784: IF (NVL (g_debug, 0) > 0)
1785: THEN
1786: gme_debug.put_line ( g_pkg_name

Line 1878: x_return_status := fnd_api.g_ret_sts_success;

1874: );
1875: END IF;
1876:
1877: /* Set the return status to success initially */
1878: x_return_status := fnd_api.g_ret_sts_success;
1879:
1880: IF (p_batchstep_activity_id IS NULL AND p_activity IS NULL)
1881: THEN
1882: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

Line 1886: RAISE fnd_api.g_exc_error;

1882: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1883: 'FIELD_NAME',
1884: 'ACTIVITY'
1885: );
1886: RAISE fnd_api.g_exc_error;
1887: ELSE
1888: IF p_batchstep_activity_id IS NULL
1889: THEN
1890: validate_param (p_org_code => p_org_code,

Line 1913: IF (x_return_status = fnd_api.g_ret_sts_error)

1909: || x_return_status
1910: );
1911: END IF;
1912:
1913: IF (x_return_status = fnd_api.g_ret_sts_error)
1914: THEN
1915: RAISE fnd_api.g_exc_error;
1916: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1917: THEN

Line 1915: RAISE fnd_api.g_exc_error;

1911: END IF;
1912:
1913: IF (x_return_status = fnd_api.g_ret_sts_error)
1914: THEN
1915: RAISE fnd_api.g_exc_error;
1916: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1917: THEN
1918: RAISE fnd_api.g_exc_unexpected_error;
1919: END IF;

Line 1916: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

1912:
1913: IF (x_return_status = fnd_api.g_ret_sts_error)
1914: THEN
1915: RAISE fnd_api.g_exc_error;
1916: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1917: THEN
1918: RAISE fnd_api.g_exc_unexpected_error;
1919: END IF;
1920:

Line 1918: RAISE fnd_api.g_exc_unexpected_error;

1914: THEN
1915: RAISE fnd_api.g_exc_error;
1916: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1917: THEN
1918: RAISE fnd_api.g_exc_unexpected_error;
1919: END IF;
1920:
1921: l_activity := p_activity;
1922: ELSE

Line 1936: RAISE fnd_api.g_exc_error;

1932: IF cur_get_step_dtl%NOTFOUND
1933: THEN
1934: CLOSE cur_get_step_dtl;
1935: gme_common_pvt.log_message ('GME_ACTID_NOT_FOUND');
1936: RAISE fnd_api.g_exc_error;
1937: END IF;
1938:
1939: CLOSE cur_get_step_dtl;
1940: END IF;

Line 1951: RAISE fnd_api.g_exc_error;

1947: IF l_batch_type = 10
1948: THEN
1949: CLOSE cur_check_fpo;
1950: gme_common_pvt.log_message ('GME_FPO_ACTV_NO_DEL');
1951: RAISE fnd_api.g_exc_error;
1952: END IF;
1953:
1954: CLOSE cur_check_fpo;
1955: OPEN cur_lock_actv (l_activity_id);

Line 1967: RAISE fnd_api.g_exc_error;

1963:
1964: IF l_batch_status <> 1
1965: THEN
1966: gme_common_pvt.log_message ('PM_WRONG_STATUS');
1967: RAISE fnd_api.g_exc_error;
1968: END IF;
1969:
1970: OPEN cur_get_activity_count (l_batchstep_id);
1971: FETCH cur_get_activity_count INTO l_cnt;

Line 1976: RAISE fnd_api.g_exc_error;

1972:
1973: IF l_cnt = 1
1974: THEN
1975: gme_common_pvt.log_message ('GME_ACTIVITY_NOT_ATTACH');
1976: RAISE fnd_api.g_exc_error;
1977: END IF;
1978:
1979: l_batchstep_activity_rec.batch_id := l_batch_id;
1980: l_batchstep_activity_rec.batchstep_id := l_batchstep_id;

Line 2005: IF (x_return_status = fnd_api.g_ret_sts_error)

2001: || x_return_status
2002: );
2003: END IF;
2004:
2005: IF (x_return_status = fnd_api.g_ret_sts_error)
2006: THEN
2007: RAISE fnd_api.g_exc_error;
2008: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2009: THEN

Line 2007: RAISE fnd_api.g_exc_error;

2003: END IF;
2004:
2005: IF (x_return_status = fnd_api.g_ret_sts_error)
2006: THEN
2007: RAISE fnd_api.g_exc_error;
2008: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2009: THEN
2010: RAISE fnd_api.g_exc_unexpected_error;
2011: END IF;

Line 2008: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

2004:
2005: IF (x_return_status = fnd_api.g_ret_sts_error)
2006: THEN
2007: RAISE fnd_api.g_exc_error;
2008: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2009: THEN
2010: RAISE fnd_api.g_exc_unexpected_error;
2011: END IF;
2012: END IF;

Line 2010: RAISE fnd_api.g_exc_unexpected_error;

2006: THEN
2007: RAISE fnd_api.g_exc_error;
2008: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2009: THEN
2010: RAISE fnd_api.g_exc_unexpected_error;
2011: END IF;
2012: END IF;
2013:
2014: gme_delete_batch_step_pvt.delete_activity (p_batch_step_activities_rec => l_batchstep_activity_rec,

Line 2025: IF (x_return_status = fnd_api.g_ret_sts_error)

2021: || x_return_status
2022: );
2023: END IF;
2024:
2025: IF (x_return_status = fnd_api.g_ret_sts_error)
2026: THEN
2027: RAISE fnd_api.g_exc_error;
2028: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2029: THEN

Line 2027: RAISE fnd_api.g_exc_error;

2023: END IF;
2024:
2025: IF (x_return_status = fnd_api.g_ret_sts_error)
2026: THEN
2027: RAISE fnd_api.g_exc_error;
2028: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2029: THEN
2030: RAISE fnd_api.g_exc_unexpected_error;
2031: END IF;

Line 2028: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

2024:
2025: IF (x_return_status = fnd_api.g_ret_sts_error)
2026: THEN
2027: RAISE fnd_api.g_exc_error;
2028: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2029: THEN
2030: RAISE fnd_api.g_exc_unexpected_error;
2031: END IF;
2032:

Line 2030: RAISE fnd_api.g_exc_unexpected_error;

2026: THEN
2027: RAISE fnd_api.g_exc_error;
2028: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2029: THEN
2030: RAISE fnd_api.g_exc_unexpected_error;
2031: END IF;
2032:
2033: IF (NVL (g_debug, 0) IN
2034: (gme_debug.g_log_statement, gme_debug.g_log_procedure)

Line 2056: x_return_status := fnd_api.g_ret_sts_error;

2052: 'Activity',
2053: 'KEY',
2054: l_activity
2055: );
2056: x_return_status := fnd_api.g_ret_sts_error;
2057: WHEN fnd_api.g_exc_error
2058: THEN
2059: x_return_status := fnd_api.g_ret_sts_error;
2060: WHEN fnd_api.g_exc_unexpected_error

Line 2057: WHEN fnd_api.g_exc_error

2053: 'KEY',
2054: l_activity
2055: );
2056: x_return_status := fnd_api.g_ret_sts_error;
2057: WHEN fnd_api.g_exc_error
2058: THEN
2059: x_return_status := fnd_api.g_ret_sts_error;
2060: WHEN fnd_api.g_exc_unexpected_error
2061: THEN

Line 2059: x_return_status := fnd_api.g_ret_sts_error;

2055: );
2056: x_return_status := fnd_api.g_ret_sts_error;
2057: WHEN fnd_api.g_exc_error
2058: THEN
2059: x_return_status := fnd_api.g_ret_sts_error;
2060: WHEN fnd_api.g_exc_unexpected_error
2061: THEN
2062: x_return_status := fnd_api.g_ret_sts_unexp_error;
2063:

Line 2060: WHEN fnd_api.g_exc_unexpected_error

2056: x_return_status := fnd_api.g_ret_sts_error;
2057: WHEN fnd_api.g_exc_error
2058: THEN
2059: x_return_status := fnd_api.g_ret_sts_error;
2060: WHEN fnd_api.g_exc_unexpected_error
2061: THEN
2062: x_return_status := fnd_api.g_ret_sts_unexp_error;
2063:
2064: IF (NVL (g_debug, 0) > 0)

Line 2062: x_return_status := fnd_api.g_ret_sts_unexp_error;

2058: THEN
2059: x_return_status := fnd_api.g_ret_sts_error;
2060: WHEN fnd_api.g_exc_unexpected_error
2061: THEN
2062: x_return_status := fnd_api.g_ret_sts_unexp_error;
2063:
2064: IF (NVL (g_debug, 0) > 0)
2065: THEN
2066: gme_debug.put_line ( g_pkg_name

Line 2077: x_return_status := fnd_api.g_ret_sts_unexp_error;

2073: END IF;
2074: WHEN OTHERS
2075: THEN
2076: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2077: x_return_status := fnd_api.g_ret_sts_unexp_error;
2078:
2079: IF (NVL (g_debug, 0) > 0)
2080: THEN
2081: gme_debug.put_line ( g_pkg_name