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_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 683: DEFAULT fnd_api.g_false,

679: p_org_code IN VARCHAR2 := NULL,
680: p_batch_no IN VARCHAR2 := NULL,
681: p_batchstep_no IN NUMBER := NULL,
682: p_ignore_qty_below_cap IN VARCHAR2
683: DEFAULT fnd_api.g_false,
684: p_validate_flexfield IN VARCHAR2
685: DEFAULT fnd_api.g_false,
686: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
687: x_return_status OUT NOCOPY VARCHAR2

Line 685: DEFAULT fnd_api.g_false,

681: p_batchstep_no IN NUMBER := NULL,
682: p_ignore_qty_below_cap IN VARCHAR2
683: DEFAULT fnd_api.g_false,
684: p_validate_flexfield IN VARCHAR2
685: DEFAULT fnd_api.g_false,
686: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
687: x_return_status OUT NOCOPY VARCHAR2
688: )
689: IS

Line 722: x_return_status := fnd_api.g_ret_sts_success;

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

Line 730: RAISE fnd_api.g_exc_error;

726: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
727: 'FIELD_NAME',
728: 'ACTIVITY'
729: );
730: RAISE fnd_api.g_exc_error;
731: END IF;
732:
733: IF p_batchstep_activity_rec.batchstep_id IS NOT NULL
734: THEN

Line 747: RAISE fnd_api.g_exc_error;

743: gme_common_pvt.log_message ('GME_BATCH_STEP_NOT_FOUND',
744: 'STEP_ID',
745: l_batchstep_id
746: );
747: RAISE fnd_api.g_exc_error;
748: END IF;
749:
750: CLOSE cur_validate_step;
751: ELSE

Line 776: IF (x_return_status = fnd_api.g_ret_sts_error)

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

Line 778: RAISE fnd_api.g_exc_error;

774: END IF;
775:
776: IF (x_return_status = fnd_api.g_ret_sts_error)
777: THEN
778: RAISE fnd_api.g_exc_error;
779: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
780: THEN
781: RAISE fnd_api.g_exc_unexpected_error;
782: END IF;

Line 779: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

775:
776: IF (x_return_status = fnd_api.g_ret_sts_error)
777: THEN
778: RAISE fnd_api.g_exc_error;
779: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
780: THEN
781: RAISE fnd_api.g_exc_unexpected_error;
782: END IF;
783: END IF;

Line 781: RAISE fnd_api.g_exc_unexpected_error;

777: THEN
778: RAISE fnd_api.g_exc_error;
779: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
780: THEN
781: RAISE fnd_api.g_exc_unexpected_error;
782: END IF;
783: END IF;
784:
785: validate_activity_param (p_batchstep_activity_rec => p_batchstep_activity_rec,

Line 805: IF (x_return_status = fnd_api.g_ret_sts_error)

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

Line 807: RAISE fnd_api.g_exc_error;

803: END IF;
804:
805: IF (x_return_status = fnd_api.g_ret_sts_error)
806: THEN
807: RAISE fnd_api.g_exc_error;
808: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
809: THEN
810: RAISE fnd_api.g_exc_unexpected_error;
811: END IF;

Line 808: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

804:
805: IF (x_return_status = fnd_api.g_ret_sts_error)
806: THEN
807: RAISE fnd_api.g_exc_error;
808: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
809: THEN
810: RAISE fnd_api.g_exc_unexpected_error;
811: END IF;
812:

Line 810: RAISE fnd_api.g_exc_unexpected_error;

806: THEN
807: RAISE fnd_api.g_exc_error;
808: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
809: THEN
810: RAISE fnd_api.g_exc_unexpected_error;
811: END IF;
812:
813: l_batchstep_activity_rec.batch_id := l_batch_id;
814: l_batchstep_activity_rec.batchstep_id := l_batchstep_id;

Line 829: RAISE fnd_api.g_exc_error;

825: p_token1_value => p_batchstep_activity_rec.activity,
826: p_token2_name => 'STEPNO',
827: p_token2_value => p_batchstep_no
828: );
829: RAISE fnd_api.g_exc_error;
830: END IF;
831:
832: l_prim_rsrc_count := 0;
833:

Line 854: IF (x_return_status = fnd_api.g_ret_sts_error)

850: x_step_status => l_step_status,
851: x_return_status => x_return_status
852: );
853:
854: IF (x_return_status = fnd_api.g_ret_sts_error)
855: THEN
856: RAISE fnd_api.g_exc_error;
857: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
858: THEN

Line 856: RAISE fnd_api.g_exc_error;

852: );
853:
854: IF (x_return_status = fnd_api.g_ret_sts_error)
855: THEN
856: RAISE fnd_api.g_exc_error;
857: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
858: THEN
859: RAISE fnd_api.g_exc_unexpected_error;
860: END IF;

Line 857: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

853:
854: IF (x_return_status = fnd_api.g_ret_sts_error)
855: THEN
856: RAISE fnd_api.g_exc_error;
857: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
858: THEN
859: RAISE fnd_api.g_exc_unexpected_error;
860: END IF;
861:

Line 859: RAISE fnd_api.g_exc_unexpected_error;

855: THEN
856: RAISE fnd_api.g_exc_error;
857: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
858: THEN
859: RAISE fnd_api.g_exc_unexpected_error;
860: END IF;
861:
862: gme_batchstep_rsrc_pvt.validate_rsrc_param (p_batchstep_resource_rec => p_batchstep_resource_tbl (i
863: ),

Line 873: IF (x_return_status = fnd_api.g_ret_sts_error)

869: x_step_status => l_step_status,
870: x_return_status => x_return_status
871: );
872:
873: IF (x_return_status = fnd_api.g_ret_sts_error)
874: THEN
875: RAISE fnd_api.g_exc_error;
876: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
877: THEN

Line 875: RAISE fnd_api.g_exc_error;

871: );
872:
873: IF (x_return_status = fnd_api.g_ret_sts_error)
874: THEN
875: RAISE fnd_api.g_exc_error;
876: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
877: THEN
878: RAISE fnd_api.g_exc_unexpected_error;
879: END IF;

Line 876: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

872:
873: IF (x_return_status = fnd_api.g_ret_sts_error)
874: THEN
875: RAISE fnd_api.g_exc_error;
876: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
877: THEN
878: RAISE fnd_api.g_exc_unexpected_error;
879: END IF;
880: */

Line 878: RAISE fnd_api.g_exc_unexpected_error;

874: THEN
875: RAISE fnd_api.g_exc_error;
876: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
877: THEN
878: RAISE fnd_api.g_exc_unexpected_error;
879: END IF;
880: */
881: IF NVL (p_batchstep_resource_tbl (i).prim_rsrc_ind, 0) = 1
882: THEN

Line 895: RAISE fnd_api.g_exc_error;

891: l_batchstep_activity_rec.activity,
892: 'STEPNO',
893: p_batchstep_no
894: );
895: RAISE fnd_api.g_exc_error;
896: END IF;
897:
898: IF (NVL (g_debug, 0) = gme_debug.g_log_statement)
899: THEN

Line 916: RAISE fnd_api.g_exc_error;

912: l_batchstep_activity_out_rec
913: )
914: )
915: THEN
916: RAISE fnd_api.g_exc_error;
917: END IF;
918:
919: IF (NVL (g_debug, -1) = gme_debug.g_log_statement)
920: THEN

Line 947: IF (x_return_status = fnd_api.g_ret_sts_error)

943: x_batchstep_resource_rec => l_batchstep_resource_out_rec,
944: x_return_status => x_return_status
945: );
946:
947: IF (x_return_status = fnd_api.g_ret_sts_error)
948: THEN
949: RAISE fnd_api.g_exc_error;
950: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
951: THEN

Line 949: RAISE fnd_api.g_exc_error;

945: );
946:
947: IF (x_return_status = fnd_api.g_ret_sts_error)
948: THEN
949: RAISE fnd_api.g_exc_error;
950: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
951: THEN
952: RAISE fnd_api.g_exc_unexpected_error;
953: END IF;

Line 950: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

946:
947: IF (x_return_status = fnd_api.g_ret_sts_error)
948: THEN
949: RAISE fnd_api.g_exc_error;
950: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
951: THEN
952: RAISE fnd_api.g_exc_unexpected_error;
953: END IF;
954: END LOOP;

Line 952: RAISE fnd_api.g_exc_unexpected_error;

948: THEN
949: RAISE fnd_api.g_exc_error;
950: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
951: THEN
952: RAISE fnd_api.g_exc_unexpected_error;
953: END IF;
954: END LOOP;
955:
956: x_batchstep_activity_rec := l_batchstep_activity_out_rec;

Line 971: WHEN fnd_api.g_exc_error

967: || x_return_status
968: );
969: END IF;
970: EXCEPTION
971: WHEN fnd_api.g_exc_error
972: THEN
973: x_batchstep_activity_rec := NULL;
974: x_return_status := fnd_api.g_ret_sts_error;
975: WHEN fnd_api.g_exc_unexpected_error

Line 974: x_return_status := fnd_api.g_ret_sts_error;

970: EXCEPTION
971: WHEN fnd_api.g_exc_error
972: THEN
973: x_batchstep_activity_rec := NULL;
974: x_return_status := fnd_api.g_ret_sts_error;
975: WHEN fnd_api.g_exc_unexpected_error
976: THEN
977: x_batchstep_activity_rec := NULL;
978: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 975: WHEN fnd_api.g_exc_unexpected_error

971: WHEN fnd_api.g_exc_error
972: THEN
973: x_batchstep_activity_rec := NULL;
974: x_return_status := fnd_api.g_ret_sts_error;
975: WHEN fnd_api.g_exc_unexpected_error
976: THEN
977: x_batchstep_activity_rec := NULL;
978: x_return_status := fnd_api.g_ret_sts_unexp_error;
979:

Line 978: x_return_status := fnd_api.g_ret_sts_unexp_error;

974: x_return_status := fnd_api.g_ret_sts_error;
975: WHEN fnd_api.g_exc_unexpected_error
976: THEN
977: x_batchstep_activity_rec := NULL;
978: x_return_status := fnd_api.g_ret_sts_unexp_error;
979:
980: IF (NVL (g_debug, 0) > 0)
981: THEN
982: gme_debug.put_line ( g_pkg_name

Line 994: x_return_status := fnd_api.g_ret_sts_unexp_error;

990: WHEN OTHERS
991: THEN
992: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
993: x_batchstep_activity_rec := NULL;
994: x_return_status := fnd_api.g_ret_sts_unexp_error;
995:
996: IF (NVL (g_debug, 0) > 0)
997: THEN
998: gme_debug.put_line ( g_pkg_name

Line 1027: DEFAULT fnd_api.g_false,

1023: p_org_code IN VARCHAR2 := NULL,
1024: p_batch_no IN VARCHAR2 := NULL,
1025: p_batchstep_no IN NUMBER := NULL,
1026: p_validate_flexfield IN VARCHAR2
1027: DEFAULT fnd_api.g_false,
1028: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
1029: x_return_status OUT NOCOPY VARCHAR2
1030: )
1031: IS

Line 1112: x_return_status := fnd_api.g_ret_sts_success;

1108: );
1109: END IF;
1110:
1111: /* Set the return status to success initially */
1112: x_return_status := fnd_api.g_ret_sts_success;
1113:
1114: IF ( p_batchstep_activity_rec.activity IS NULL
1115: AND p_batchstep_activity_rec.batchstep_activity_id IS NULL
1116: )

Line 1122: RAISE fnd_api.g_exc_error;

1118: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1119: 'FIELD_NAME',
1120: 'ACTIVITY'
1121: );
1122: RAISE fnd_api.g_exc_error;
1123: END IF;
1124:
1125: IF p_batchstep_activity_rec.batchstep_activity_id IS NOT NULL
1126: THEN

Line 1137: RAISE fnd_api.g_exc_error;

1133: IF cur_get_dtl%NOTFOUND
1134: THEN
1135: CLOSE cur_get_dtl;
1136: gme_common_pvt.log_message ('GME_ACTID_NOT_FOUND');
1137: RAISE fnd_api.g_exc_error;
1138: END IF;
1139:
1140: CLOSE cur_get_dtl;
1141: ELSE

Line 1167: IF (x_return_status = fnd_api.g_ret_sts_error)

1163: || x_return_status
1164: );
1165: END IF;
1166:
1167: IF (x_return_status = fnd_api.g_ret_sts_error)
1168: THEN
1169: RAISE fnd_api.g_exc_error;
1170: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1171: THEN

Line 1169: RAISE fnd_api.g_exc_error;

1165: END IF;
1166:
1167: IF (x_return_status = fnd_api.g_ret_sts_error)
1168: THEN
1169: RAISE fnd_api.g_exc_error;
1170: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1171: THEN
1172: RAISE fnd_api.g_exc_unexpected_error;
1173: END IF;

Line 1170: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

1166:
1167: IF (x_return_status = fnd_api.g_ret_sts_error)
1168: THEN
1169: RAISE fnd_api.g_exc_error;
1170: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1171: THEN
1172: RAISE fnd_api.g_exc_unexpected_error;
1173: END IF;
1174: END IF;

Line 1172: RAISE fnd_api.g_exc_unexpected_error;

1168: THEN
1169: RAISE fnd_api.g_exc_error;
1170: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1171: THEN
1172: RAISE fnd_api.g_exc_unexpected_error;
1173: END IF;
1174: END IF;
1175:
1176: -- Check if this is an FPO

Line 1184: RAISE fnd_api.g_exc_error;

1180: IF l_batch_type = 10
1181: THEN
1182: CLOSE cur_check_fpo;
1183: gme_common_pvt.log_message ('GME_FPO_ACTV_NO_EDIT');
1184: RAISE fnd_api.g_exc_error;
1185: END IF;
1186:
1187: CLOSE cur_check_fpo;
1188: OPEN cur_lock_actv (l_activity_id);

Line 1202: RAISE fnd_api.g_exc_error;

1198: l_batchstep_activity_rec
1199: )
1200: )
1201: THEN
1202: RAISE fnd_api.g_exc_error;
1203: END IF;
1204:
1205: l_seq_dep_ind := l_batchstep_activity_rec.sequence_dependent_ind;
1206:

Line 1210: RAISE fnd_api.g_exc_error;

1206:
1207: IF l_step_status IN (4, 5)
1208: THEN
1209: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');
1210: RAISE fnd_api.g_exc_error;
1211: END IF;
1212:
1213: IF p_batchstep_activity_rec.offset_interval = fnd_api.g_miss_num
1214: THEN

Line 1213: IF p_batchstep_activity_rec.offset_interval = fnd_api.g_miss_num

1209: gme_common_pvt.log_message ('PC_STEP_STATUS_ERR');
1210: RAISE fnd_api.g_exc_error;
1211: END IF;
1212:
1213: IF p_batchstep_activity_rec.offset_interval = fnd_api.g_miss_num
1214: THEN
1215: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1216: 'FIELD_NAME',
1217: 'offset_interval'

Line 1219: RAISE fnd_api.g_exc_error;

1215: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1216: 'FIELD_NAME',
1217: 'offset_interval'
1218: );
1219: RAISE fnd_api.g_exc_error;
1220: ELSIF ( p_batchstep_activity_rec.offset_interval IS NOT NULL
1221: AND (l_batchstep_activity_rec.offset_interval <>
1222: p_batchstep_activity_rec.offset_interval
1223: )

Line 1237: IF p_batchstep_activity_rec.plan_start_date = fnd_api.g_miss_date

1233: CLOSE cur_get_step_dtl;
1234:
1235: IF l_step_status IN (1, 2)
1236: THEN
1237: IF p_batchstep_activity_rec.plan_start_date = fnd_api.g_miss_date
1238: THEN
1239: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1240: 'FIELD_NAME',
1241: 'plan_start_date'

Line 1243: RAISE fnd_api.g_exc_error;

1239: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1240: 'FIELD_NAME',
1241: 'plan_start_date'
1242: );
1243: RAISE fnd_api.g_exc_error;
1244: ELSIF p_batchstep_activity_rec.plan_start_date IS NOT NULL
1245: AND (p_batchstep_activity_rec.plan_start_date <>
1246: l_batchstep_activity_rec.plan_start_date
1247: )

Line 1259: RAISE fnd_api.g_exc_error;

1255: gme_common_pvt.log_message ('GME_ACTV_PLAN_DATE',
1256: 'ACTIVITY',
1257: l_activity
1258: );
1259: RAISE fnd_api.g_exc_error;
1260: END IF;
1261:
1262: l_field_updated := TRUE;
1263: l_upd_plan_date := TRUE;

Line 1268: IF p_batchstep_activity_rec.plan_cmplt_date = fnd_api.g_miss_date

1264: l_batchstep_activity_rec.plan_start_date :=
1265: p_batchstep_activity_rec.plan_start_date;
1266: END IF;
1267:
1268: IF p_batchstep_activity_rec.plan_cmplt_date = fnd_api.g_miss_date
1269: THEN
1270: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1271: 'FIELD_NAME',
1272: 'plan_cmplt_date'

Line 1274: RAISE fnd_api.g_exc_error;

1270: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1271: 'FIELD_NAME',
1272: 'plan_cmplt_date'
1273: );
1274: RAISE fnd_api.g_exc_error;
1275: ELSIF p_batchstep_activity_rec.plan_cmplt_date IS NOT NULL
1276: AND (p_batchstep_activity_rec.plan_cmplt_date <>
1277: l_batchstep_activity_rec.plan_cmplt_date
1278: )

Line 1288: RAISE fnd_api.g_exc_error;

1284: gme_common_pvt.log_message ('GME_ACTV_PLAN_DATE',
1285: 'ACTIVITY',
1286: l_activity
1287: );
1288: RAISE fnd_api.g_exc_error;
1289: END IF;
1290:
1291: l_field_updated := TRUE;
1292: l_upd_plan_date := TRUE;

Line 1303: RAISE fnd_api.g_exc_error;

1299: l_batchstep_activity_rec.plan_cmplt_date
1300: )
1301: THEN
1302: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1303: RAISE fnd_api.g_exc_error;
1304: END IF;
1305: END IF;
1306:
1307: IF l_step_dtl.step_status IN (2, 3)

Line 1309: IF p_batchstep_activity_rec.actual_start_date = fnd_api.g_miss_date

1305: END IF;
1306:
1307: IF l_step_dtl.step_status IN (2, 3)
1308: THEN
1309: IF p_batchstep_activity_rec.actual_start_date = fnd_api.g_miss_date
1310: THEN
1311: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1312: 'FIELD_NAME',
1313: 'actual_start_date'

Line 1315: RAISE fnd_api.g_exc_error;

1311: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1312: 'FIELD_NAME',
1313: 'actual_start_date'
1314: );
1315: RAISE fnd_api.g_exc_error;
1316: ELSIF p_batchstep_activity_rec.actual_start_date IS NOT NULL
1317: AND (p_batchstep_activity_rec.actual_start_date <>
1318: l_batchstep_activity_rec.actual_start_date
1319: )

Line 1327: RAISE fnd_api.g_exc_error;

1323: gme_common_pvt.g_timestamp
1324: THEN
1325: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
1326: fnd_msg_pub.ADD;
1327: RAISE fnd_api.g_exc_error;
1328: END IF;
1329:
1330: -- Check that the activity actual dates fall within the step dates.
1331: IF ( p_batchstep_activity_rec.actual_start_date <

Line 1341: RAISE fnd_api.g_exc_error;

1337: gme_common_pvt.log_message ('GME_ACTV_ACTUAL_DATE',
1338: 'ACTIVITY',
1339: l_activity
1340: );
1341: RAISE fnd_api.g_exc_error;
1342: END IF;
1343:
1344: l_field_updated := TRUE;
1345: l_upd_act_date := TRUE;

Line 1353: IF p_batchstep_activity_rec.actual_cmplt_date = fnd_api.g_miss_date

1349: END IF;
1350:
1351: IF l_step_dtl.step_status = 3
1352: THEN
1353: IF p_batchstep_activity_rec.actual_cmplt_date = fnd_api.g_miss_date
1354: THEN
1355: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1356: 'FIELD_NAME',
1357: 'actual_cmplt_date'

Line 1359: RAISE fnd_api.g_exc_error;

1355: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1356: 'FIELD_NAME',
1357: 'actual_cmplt_date'
1358: );
1359: RAISE fnd_api.g_exc_error;
1360: ELSIF p_batchstep_activity_rec.actual_cmplt_date IS NOT NULL
1361: AND (p_batchstep_activity_rec.actual_cmplt_date <>
1362: l_batchstep_activity_rec.actual_cmplt_date
1363: )

Line 1371: RAISE fnd_api.g_exc_error;

1367: gme_common_pvt.g_timestamp
1368: THEN
1369: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
1370: fnd_msg_pub.ADD;
1371: RAISE fnd_api.g_exc_error;
1372: END IF;
1373:
1374: IF p_batchstep_activity_rec.actual_cmplt_date IS NOT NULL
1375: AND p_batchstep_activity_rec.actual_cmplt_date >

Line 1382: RAISE fnd_api.g_exc_error;

1378: gme_common_pvt.log_message ('GME_ACTV_ACTUAL_DATE',
1379: 'ACTIVITY',
1380: l_activity
1381: );
1382: RAISE fnd_api.g_exc_error;
1383: END IF;
1384:
1385: l_field_updated := TRUE;
1386: l_upd_act_date := TRUE;

Line 1398: RAISE fnd_api.g_exc_error;

1394: l_batchstep_activity_rec.actual_cmplt_date
1395: )
1396: THEN
1397: gme_common_pvt.log_message ('PM_BADSTARTDATE');
1398: RAISE fnd_api.g_exc_error;
1399: END IF;
1400:
1401: -- check that activities dates are within resource dates
1402: IF l_upd_plan_date OR l_upd_act_date

Line 1439: RAISE fnd_api.g_exc_error;

1435: gme_common_pvt.log_message ('GME_RSRC_DATES_NOT_ALLOWED',
1436: 'RESOURCE',
1437: 'l_resource'
1438: );
1439: RAISE fnd_api.g_exc_error;
1440: END IF;
1441: END IF;
1442:
1443: --fix to g_miss_num and comparison to not NULL for l_batchstep_activity_rec

Line 1445: fnd_api.g_miss_num

1441: END IF;
1442:
1443: --fix to g_miss_num and comparison to not NULL for l_batchstep_activity_rec
1444: IF p_batchstep_activity_rec.plan_activity_factor =
1445: fnd_api.g_miss_num
1446: AND l_batchstep_activity_rec.plan_activity_factor IS NOT NULL
1447: THEN
1448: gme_common_pvt.log_message ('GME_PLAN_ACTV_FACT_NOTNULL');
1449: RAISE fnd_api.g_exc_error;

Line 1449: RAISE fnd_api.g_exc_error;

1445: fnd_api.g_miss_num
1446: AND l_batchstep_activity_rec.plan_activity_factor IS NOT NULL
1447: THEN
1448: gme_common_pvt.log_message ('GME_PLAN_ACTV_FACT_NOTNULL');
1449: RAISE fnd_api.g_exc_error;
1450: END IF;
1451:
1452: IF ( p_batchstep_activity_rec.plan_activity_factor IS NOT NULL
1453: AND l_batchstep_activity_rec.plan_activity_factor IS NULL

Line 1470: fnd_api.g_miss_num

1466: END IF;
1467:
1468: --fix to g_miss_num and comparison to not NULL for l_batchstep_activity_rec
1469: IF p_batchstep_activity_rec.actual_activity_factor =
1470: fnd_api.g_miss_num
1471: AND l_batchstep_activity_rec.actual_activity_factor IS NOT NULL
1472: THEN
1473: gme_common_pvt.log_message ('GME_ACTUAL_ACTV_FACT_NOTNULL');
1474: RAISE fnd_api.g_exc_error;

Line 1474: RAISE fnd_api.g_exc_error;

1470: fnd_api.g_miss_num
1471: AND l_batchstep_activity_rec.actual_activity_factor IS NOT NULL
1472: THEN
1473: gme_common_pvt.log_message ('GME_ACTUAL_ACTV_FACT_NOTNULL');
1474: RAISE fnd_api.g_exc_error;
1475: END IF;
1476:
1477: IF ( p_batchstep_activity_rec.actual_activity_factor IS NOT NULL
1478: AND l_batchstep_activity_rec.actual_activity_factor IS NULL

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

1489: p_batchstep_activity_rec.actual_activity_factor;
1490: END IF;
1491: END IF;
1492:
1493: IF (fnd_api.to_boolean (p_validate_flexfield))
1494: THEN
1495: IF NVL (p_batchstep_activity_rec.attribute_category, ' ') <>
1496: NVL (l_batchstep_activity_rec.attribute_category, ' ')
1497: OR NVL (p_batchstep_activity_rec.attribute1, ' ') <>

Line 1576: IF (x_return_status = fnd_api.g_ret_sts_error)

1572: || x_return_status
1573: );
1574: END IF;
1575:
1576: IF (x_return_status = fnd_api.g_ret_sts_error)
1577: THEN
1578: RAISE fnd_api.g_exc_error;
1579: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1580: THEN

Line 1578: RAISE fnd_api.g_exc_error;

1574: END IF;
1575:
1576: IF (x_return_status = fnd_api.g_ret_sts_error)
1577: THEN
1578: RAISE fnd_api.g_exc_error;
1579: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1580: THEN
1581: RAISE fnd_api.g_exc_unexpected_error;
1582: END IF;

Line 1579: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

1575:
1576: IF (x_return_status = fnd_api.g_ret_sts_error)
1577: THEN
1578: RAISE fnd_api.g_exc_error;
1579: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1580: THEN
1581: RAISE fnd_api.g_exc_unexpected_error;
1582: END IF;
1583:

Line 1581: RAISE fnd_api.g_exc_unexpected_error;

1577: THEN
1578: RAISE fnd_api.g_exc_error;
1579: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1580: THEN
1581: RAISE fnd_api.g_exc_unexpected_error;
1582: END IF;
1583:
1584: -- copy all the validated flex fields
1585: l_batchstep_activity_rec.attribute_category :=

Line 1653: RAISE fnd_api.g_exc_error;

1649:
1650: IF NOT (l_field_updated)
1651: THEN
1652: gme_common_pvt.log_message ('GME_NO_CHANGE_TO_UPD');
1653: RAISE fnd_api.g_exc_error;
1654: END IF;
1655:
1656: IF (NVL (g_debug, -1) = gme_debug.g_log_statement)
1657: THEN

Line 1686: IF (x_return_status = fnd_api.g_ret_sts_error)

1682: || x_return_status
1683: );
1684: END IF;
1685:
1686: IF (x_return_status = fnd_api.g_ret_sts_error)
1687: THEN
1688: RAISE fnd_api.g_exc_error;
1689: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1690: THEN

Line 1688: RAISE fnd_api.g_exc_error;

1684: END IF;
1685:
1686: IF (x_return_status = fnd_api.g_ret_sts_error)
1687: THEN
1688: RAISE fnd_api.g_exc_error;
1689: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1690: THEN
1691: RAISE fnd_api.g_exc_unexpected_error;
1692: END IF;

Line 1689: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

1685:
1686: IF (x_return_status = fnd_api.g_ret_sts_error)
1687: THEN
1688: RAISE fnd_api.g_exc_error;
1689: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1690: THEN
1691: RAISE fnd_api.g_exc_unexpected_error;
1692: END IF;
1693: END IF;

Line 1691: RAISE fnd_api.g_exc_unexpected_error;

1687: THEN
1688: RAISE fnd_api.g_exc_error;
1689: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1690: THEN
1691: RAISE fnd_api.g_exc_unexpected_error;
1692: END IF;
1693: END IF;
1694:
1695: gme_update_step_qty_pvt.update_resources (p_batch_hdr_rec => l_batch_hdr,

Line 1712: IF (x_return_status = fnd_api.g_ret_sts_error)

1708: || x_return_status
1709: );
1710: END IF;
1711:
1712: IF (x_return_status = fnd_api.g_ret_sts_error)
1713: THEN
1714: RAISE fnd_api.g_exc_error;
1715: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1716: THEN

Line 1714: RAISE fnd_api.g_exc_error;

1710: END IF;
1711:
1712: IF (x_return_status = fnd_api.g_ret_sts_error)
1713: THEN
1714: RAISE fnd_api.g_exc_error;
1715: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1716: THEN
1717: RAISE fnd_api.g_exc_unexpected_error;
1718: END IF;

Line 1715: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

1711:
1712: IF (x_return_status = fnd_api.g_ret_sts_error)
1713: THEN
1714: RAISE fnd_api.g_exc_error;
1715: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1716: THEN
1717: RAISE fnd_api.g_exc_unexpected_error;
1718: END IF;
1719: END IF;

Line 1717: RAISE fnd_api.g_exc_unexpected_error;

1713: THEN
1714: RAISE fnd_api.g_exc_error;
1715: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1716: THEN
1717: RAISE fnd_api.g_exc_unexpected_error;
1718: END IF;
1719: END IF;
1720:
1721: IF NOT (gme_batch_step_activities_dbl.update_row (l_batchstep_activity_rec

Line 1725: RAISE fnd_api.g_exc_error;

1721: IF NOT (gme_batch_step_activities_dbl.update_row (l_batchstep_activity_rec
1722: )
1723: )
1724: THEN
1725: RAISE fnd_api.g_exc_error;
1726: END IF;
1727:
1728: IF l_seq_dep_ind <> l_batchstep_activity_rec.sequence_dependent_ind
1729: THEN

Line 1740: RAISE fnd_api.g_exc_error;

1736: l_batchstep_activity_rec
1737: )
1738: )
1739: THEN
1740: RAISE fnd_api.g_exc_error;
1741: END IF;
1742:
1743: x_batchstep_activity_rec := l_batchstep_activity_rec;
1744:

Line 1768: x_return_status := fnd_api.g_ret_sts_error;

1764: 'Activity',
1765: 'KEY',
1766: l_activity
1767: );
1768: x_return_status := fnd_api.g_ret_sts_error;
1769: WHEN fnd_api.g_exc_error
1770: THEN
1771: x_return_status := fnd_api.g_ret_sts_error;
1772: WHEN fnd_api.g_exc_unexpected_error

Line 1769: WHEN fnd_api.g_exc_error

1765: 'KEY',
1766: l_activity
1767: );
1768: x_return_status := fnd_api.g_ret_sts_error;
1769: WHEN fnd_api.g_exc_error
1770: THEN
1771: x_return_status := fnd_api.g_ret_sts_error;
1772: WHEN fnd_api.g_exc_unexpected_error
1773: THEN

Line 1771: x_return_status := fnd_api.g_ret_sts_error;

1767: );
1768: x_return_status := fnd_api.g_ret_sts_error;
1769: WHEN fnd_api.g_exc_error
1770: THEN
1771: x_return_status := fnd_api.g_ret_sts_error;
1772: WHEN fnd_api.g_exc_unexpected_error
1773: THEN
1774: x_return_status := fnd_api.g_ret_sts_unexp_error;
1775:

Line 1772: WHEN fnd_api.g_exc_unexpected_error

1768: x_return_status := fnd_api.g_ret_sts_error;
1769: WHEN fnd_api.g_exc_error
1770: THEN
1771: x_return_status := fnd_api.g_ret_sts_error;
1772: WHEN fnd_api.g_exc_unexpected_error
1773: THEN
1774: x_return_status := fnd_api.g_ret_sts_unexp_error;
1775:
1776: IF (NVL (g_debug, 0) > 0)

Line 1774: x_return_status := fnd_api.g_ret_sts_unexp_error;

1770: THEN
1771: x_return_status := fnd_api.g_ret_sts_error;
1772: WHEN fnd_api.g_exc_unexpected_error
1773: THEN
1774: x_return_status := fnd_api.g_ret_sts_unexp_error;
1775:
1776: IF (NVL (g_debug, 0) > 0)
1777: THEN
1778: gme_debug.put_line ( g_pkg_name

Line 1789: x_return_status := fnd_api.g_ret_sts_unexp_error;

1785: END IF;
1786: WHEN OTHERS
1787: THEN
1788: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1789: x_return_status := fnd_api.g_ret_sts_unexp_error;
1790:
1791: IF (NVL (g_debug, 0) > 0)
1792: THEN
1793: gme_debug.put_line ( g_pkg_name

Line 1885: x_return_status := fnd_api.g_ret_sts_success;

1881: );
1882: END IF;
1883:
1884: /* Set the return status to success initially */
1885: x_return_status := fnd_api.g_ret_sts_success;
1886:
1887: IF (p_batchstep_activity_id IS NULL AND p_activity IS NULL)
1888: THEN
1889: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',

Line 1893: RAISE fnd_api.g_exc_error;

1889: gme_common_pvt.log_message ('GME_FIELD_VALUE_REQUIRED',
1890: 'FIELD_NAME',
1891: 'ACTIVITY'
1892: );
1893: RAISE fnd_api.g_exc_error;
1894: ELSE
1895: IF p_batchstep_activity_id IS NULL
1896: THEN
1897: validate_param (p_org_code => p_org_code,

Line 1920: IF (x_return_status = fnd_api.g_ret_sts_error)

1916: || x_return_status
1917: );
1918: END IF;
1919:
1920: IF (x_return_status = fnd_api.g_ret_sts_error)
1921: THEN
1922: RAISE fnd_api.g_exc_error;
1923: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1924: THEN

Line 1922: RAISE fnd_api.g_exc_error;

1918: END IF;
1919:
1920: IF (x_return_status = fnd_api.g_ret_sts_error)
1921: THEN
1922: RAISE fnd_api.g_exc_error;
1923: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1924: THEN
1925: RAISE fnd_api.g_exc_unexpected_error;
1926: END IF;

Line 1923: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

1919:
1920: IF (x_return_status = fnd_api.g_ret_sts_error)
1921: THEN
1922: RAISE fnd_api.g_exc_error;
1923: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1924: THEN
1925: RAISE fnd_api.g_exc_unexpected_error;
1926: END IF;
1927:

Line 1925: RAISE fnd_api.g_exc_unexpected_error;

1921: THEN
1922: RAISE fnd_api.g_exc_error;
1923: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1924: THEN
1925: RAISE fnd_api.g_exc_unexpected_error;
1926: END IF;
1927:
1928: l_activity := p_activity;
1929: ELSE

Line 1943: RAISE fnd_api.g_exc_error;

1939: IF cur_get_step_dtl%NOTFOUND
1940: THEN
1941: CLOSE cur_get_step_dtl;
1942: gme_common_pvt.log_message ('GME_ACTID_NOT_FOUND');
1943: RAISE fnd_api.g_exc_error;
1944: END IF;
1945:
1946: CLOSE cur_get_step_dtl;
1947: END IF;

Line 1958: RAISE fnd_api.g_exc_error;

1954: IF l_batch_type = 10
1955: THEN
1956: CLOSE cur_check_fpo;
1957: gme_common_pvt.log_message ('GME_FPO_ACTV_NO_DEL');
1958: RAISE fnd_api.g_exc_error;
1959: END IF;
1960:
1961: CLOSE cur_check_fpo;
1962: OPEN cur_lock_actv (l_activity_id);

Line 1974: RAISE fnd_api.g_exc_error;

1970:
1971: IF l_batch_status <> 1
1972: THEN
1973: gme_common_pvt.log_message ('PM_WRONG_STATUS');
1974: RAISE fnd_api.g_exc_error;
1975: END IF;
1976:
1977: OPEN cur_get_activity_count (l_batchstep_id);
1978: FETCH cur_get_activity_count INTO l_cnt;

Line 1983: RAISE fnd_api.g_exc_error;

1979:
1980: IF l_cnt = 1
1981: THEN
1982: gme_common_pvt.log_message ('GME_ACTIVITY_NOT_ATTACH');
1983: RAISE fnd_api.g_exc_error;
1984: END IF;
1985:
1986: l_batchstep_activity_rec.batch_id := l_batch_id;
1987: l_batchstep_activity_rec.batchstep_id := l_batchstep_id;

Line 2012: IF (x_return_status = fnd_api.g_ret_sts_error)

2008: || x_return_status
2009: );
2010: END IF;
2011:
2012: IF (x_return_status = fnd_api.g_ret_sts_error)
2013: THEN
2014: RAISE fnd_api.g_exc_error;
2015: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2016: THEN

Line 2014: RAISE fnd_api.g_exc_error;

2010: END IF;
2011:
2012: IF (x_return_status = fnd_api.g_ret_sts_error)
2013: THEN
2014: RAISE fnd_api.g_exc_error;
2015: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2016: THEN
2017: RAISE fnd_api.g_exc_unexpected_error;
2018: END IF;

Line 2015: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

2011:
2012: IF (x_return_status = fnd_api.g_ret_sts_error)
2013: THEN
2014: RAISE fnd_api.g_exc_error;
2015: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2016: THEN
2017: RAISE fnd_api.g_exc_unexpected_error;
2018: END IF;
2019: END IF;

Line 2017: RAISE fnd_api.g_exc_unexpected_error;

2013: THEN
2014: RAISE fnd_api.g_exc_error;
2015: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2016: THEN
2017: RAISE fnd_api.g_exc_unexpected_error;
2018: END IF;
2019: END IF;
2020:
2021: gme_delete_batch_step_pvt.delete_activity (p_batch_step_activities_rec => l_batchstep_activity_rec,

Line 2032: IF (x_return_status = fnd_api.g_ret_sts_error)

2028: || x_return_status
2029: );
2030: END IF;
2031:
2032: IF (x_return_status = fnd_api.g_ret_sts_error)
2033: THEN
2034: RAISE fnd_api.g_exc_error;
2035: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2036: THEN

Line 2034: RAISE fnd_api.g_exc_error;

2030: END IF;
2031:
2032: IF (x_return_status = fnd_api.g_ret_sts_error)
2033: THEN
2034: RAISE fnd_api.g_exc_error;
2035: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2036: THEN
2037: RAISE fnd_api.g_exc_unexpected_error;
2038: END IF;

Line 2035: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)

2031:
2032: IF (x_return_status = fnd_api.g_ret_sts_error)
2033: THEN
2034: RAISE fnd_api.g_exc_error;
2035: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2036: THEN
2037: RAISE fnd_api.g_exc_unexpected_error;
2038: END IF;
2039:

Line 2037: RAISE fnd_api.g_exc_unexpected_error;

2033: THEN
2034: RAISE fnd_api.g_exc_error;
2035: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error)
2036: THEN
2037: RAISE fnd_api.g_exc_unexpected_error;
2038: END IF;
2039:
2040: IF (NVL (g_debug, 0) IN
2041: (gme_debug.g_log_statement, gme_debug.g_log_procedure)

Line 2063: x_return_status := fnd_api.g_ret_sts_error;

2059: 'Activity',
2060: 'KEY',
2061: l_activity
2062: );
2063: x_return_status := fnd_api.g_ret_sts_error;
2064: WHEN fnd_api.g_exc_error
2065: THEN
2066: x_return_status := fnd_api.g_ret_sts_error;
2067: WHEN fnd_api.g_exc_unexpected_error

Line 2064: WHEN fnd_api.g_exc_error

2060: 'KEY',
2061: l_activity
2062: );
2063: x_return_status := fnd_api.g_ret_sts_error;
2064: WHEN fnd_api.g_exc_error
2065: THEN
2066: x_return_status := fnd_api.g_ret_sts_error;
2067: WHEN fnd_api.g_exc_unexpected_error
2068: THEN

Line 2066: x_return_status := fnd_api.g_ret_sts_error;

2062: );
2063: x_return_status := fnd_api.g_ret_sts_error;
2064: WHEN fnd_api.g_exc_error
2065: THEN
2066: x_return_status := fnd_api.g_ret_sts_error;
2067: WHEN fnd_api.g_exc_unexpected_error
2068: THEN
2069: x_return_status := fnd_api.g_ret_sts_unexp_error;
2070:

Line 2067: WHEN fnd_api.g_exc_unexpected_error

2063: x_return_status := fnd_api.g_ret_sts_error;
2064: WHEN fnd_api.g_exc_error
2065: THEN
2066: x_return_status := fnd_api.g_ret_sts_error;
2067: WHEN fnd_api.g_exc_unexpected_error
2068: THEN
2069: x_return_status := fnd_api.g_ret_sts_unexp_error;
2070:
2071: IF (NVL (g_debug, 0) > 0)

Line 2069: x_return_status := fnd_api.g_ret_sts_unexp_error;

2065: THEN
2066: x_return_status := fnd_api.g_ret_sts_error;
2067: WHEN fnd_api.g_exc_unexpected_error
2068: THEN
2069: x_return_status := fnd_api.g_ret_sts_unexp_error;
2070:
2071: IF (NVL (g_debug, 0) > 0)
2072: THEN
2073: gme_debug.put_line ( g_pkg_name

Line 2084: x_return_status := fnd_api.g_ret_sts_unexp_error;

2080: END IF;
2081: WHEN OTHERS
2082: THEN
2083: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2084: x_return_status := fnd_api.g_ret_sts_unexp_error;
2085:
2086: IF (NVL (g_debug, 0) > 0)
2087: THEN
2088: gme_debug.put_line ( g_pkg_name