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_RELEASE_BATCH_STEP_PVT dependencies on GME_COMMON_PVT

Line 30: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab

26: PROCEDURE release_step (
27: p_batch_step_rec IN gme_batch_steps%ROWTYPE
28: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
29: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
30: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
31: ,x_return_status OUT NOCOPY VARCHAR2)
32: IS
33: l_api_name CONSTANT VARCHAR2 (30) := 'RELEASE_STEP';
34: /* Exception definitions */

Line 73: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN

69: ,x_exception_material_tbl => x_exception_material_tbl
70: ,x_return_status => l_return_status);
71:
72: IF l_return_status NOT IN
73: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN
74: x_return_status := l_return_status;
75: RAISE error_release_step_rec;
76: END IF;
77:

Line 78: IF l_return_status = gme_common_pvt.g_exceptions_err THEN

74: x_return_status := l_return_status;
75: RAISE error_release_step_rec;
76: END IF;
77:
78: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
79: x_return_status := gme_common_pvt.g_exceptions_err;
80: END IF;
81:
82: /*Bug#5109119 moved the release batch call (which is there before call to release_step_recursive)

Line 79: x_return_status := gme_common_pvt.g_exceptions_err;

75: RAISE error_release_step_rec;
76: END IF;
77:
78: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
79: x_return_status := gme_common_pvt.g_exceptions_err;
80: END IF;
81:
82: /*Bug#5109119 moved the release batch call (which is there before call to release_step_recursive)
83: moved here because first step actual start date will be available if and only if the above procedure returns

Line 87: IF (p_batch_header_rec.batch_status = gme_common_pvt.g_batch_pending) THEN

83: moved here because first step actual start date will be available if and only if the above procedure returns
84: */
85: /* If the batch status is Pending, then release the batch... */
86: /* check that this is valid already done in Pub */
87: IF (p_batch_header_rec.batch_status = gme_common_pvt.g_batch_pending) THEN
88: /* Bug#5109119 intialize Batch actual start date with the passed one or with the calculated
89: first step actual start date no need to check for close period here as it's one of the step actual start
90: dates and already validated in process_Dependent_steps procedure*/
91: l_in_batch_header_rec := p_batch_header_rec;

Line 102: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN

98: ,x_return_status => l_return_status
99: ,x_exception_material_tbl => x_exception_material_tbl);
100:
101: IF l_return_status NOT IN
102: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN
103: x_return_status := l_return_status;
104: RAISE error_release_batch;
105: END IF;
106:

Line 107: IF l_return_status = gme_common_pvt.g_exceptions_err THEN

103: x_return_status := l_return_status;
104: RAISE error_release_batch;
105: END IF;
106:
107: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
108: x_return_status := gme_common_pvt.g_exceptions_err;
109: END IF;
110: END IF;
111:

Line 108: x_return_status := gme_common_pvt.g_exceptions_err;

104: RAISE error_release_batch;
105: END IF;
106:
107: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
108: x_return_status := gme_common_pvt.g_exceptions_err;
109: END IF;
110: END IF;
111:
112:

Line 156: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab

152: PROCEDURE release_step_recursive (
153: p_batch_step_rec IN gme_batch_steps%ROWTYPE
154: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
155: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
156: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
157: ,x_return_status OUT NOCOPY VARCHAR2)
158: IS
159: l_api_name CONSTANT VARCHAR2 (30) := 'release_step_recursive';
160: step_rel_cmpl_closed EXCEPTION;

Line 194: (gme_common_pvt.g_step_wip

190: x_return_status := fnd_api.g_ret_sts_success;
191:
192: /* Exit the recursive loop if the step is already released, completed or closed */
193: IF p_batch_step_rec.step_status IN
194: (gme_common_pvt.g_step_wip
195: ,gme_common_pvt.g_step_completed
196: ,gme_common_pvt.g_step_closed) THEN
197: RAISE step_rel_cmpl_closed;
198: END IF;

Line 195: ,gme_common_pvt.g_step_completed

191:
192: /* Exit the recursive loop if the step is already released, completed or closed */
193: IF p_batch_step_rec.step_status IN
194: (gme_common_pvt.g_step_wip
195: ,gme_common_pvt.g_step_completed
196: ,gme_common_pvt.g_step_closed) THEN
197: RAISE step_rel_cmpl_closed;
198: END IF;
199:

Line 196: ,gme_common_pvt.g_step_closed) THEN

192: /* Exit the recursive loop if the step is already released, completed or closed */
193: IF p_batch_step_rec.step_status IN
194: (gme_common_pvt.g_step_wip
195: ,gme_common_pvt.g_step_completed
196: ,gme_common_pvt.g_step_closed) THEN
197: RAISE step_rel_cmpl_closed;
198: END IF;
199:
200: gme_validate_flex_fld_pvt.validate_flex_batch_step

Line 216: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN

212: ,x_exception_material_tbl => x_exception_material_tbl
213: ,x_return_status => l_return_status);
214:
215: IF l_return_status NOT IN
216: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN
217: x_return_status := l_return_status;
218: RAISE error_process_dep_steps;
219: END IF;
220:

Line 221: IF l_return_status = gme_common_pvt.g_exceptions_err THEN

217: x_return_status := l_return_status;
218: RAISE error_process_dep_steps;
219: END IF;
220:
221: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
222: x_return_status := gme_common_pvt.g_exceptions_err;
223: END IF;
224:
225: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 222: x_return_status := gme_common_pvt.g_exceptions_err;

218: RAISE error_process_dep_steps;
219: END IF;
220:
221: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
222: x_return_status := gme_common_pvt.g_exceptions_err;
223: END IF;
224:
225: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
226: gme_debug.put_line

Line 248: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN

244: ,x_exception_material_tbl => x_exception_material_tbl
245: ,x_return_status => l_return_status);
246:
247: IF l_return_status NOT IN
248: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN
249: x_return_status := l_return_status;
250: RAISE rel_step_ing_error;
251: END IF;
252:

Line 253: IF l_return_status = gme_common_pvt.g_exceptions_err THEN

249: x_return_status := l_return_status;
250: RAISE rel_step_ing_error;
251: END IF;
252:
253: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
254: x_return_status := gme_common_pvt.g_exceptions_err;
255: END IF;
256:
257: /* Invoke the update step qty API to update the step quantities and the */

Line 254: x_return_status := gme_common_pvt.g_exceptions_err;

250: RAISE rel_step_ing_error;
251: END IF;
252:
253: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
254: x_return_status := gme_common_pvt.g_exceptions_err;
255: END IF;
256:
257: /* Invoke the update step qty API to update the step quantities and the */
258: /* quantities of the succeeding steps */

Line 274: (p_event_name => gme_common_pvt.G_BSTEP_REL_WF

270:
271: /* Needs to be done for each step released */
272: IF (x_batch_step_rec.quality_status = 2) THEN
273: wf_event.RAISE
274: (p_event_name => gme_common_pvt.G_BSTEP_REL_WF
275: ,p_event_key => TO_CHAR
276: (x_batch_step_rec.batchstep_id) );
277: END IF;
278:

Line 308: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab

304:
305: PROCEDURE process_dependent_steps (
306: p_batch_step_rec IN gme_batch_steps%ROWTYPE
307: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
308: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
309: ,x_return_status OUT NOCOPY VARCHAR2)
310: IS
311: l_api_name CONSTANT VARCHAR2 (30) := 'process_dependent_steps';
312:

Line 352: IF NOT gme_common_pvt.check_close_period(p_org_id => p_batch_header_rec.organization_id

348: x_return_status := fnd_api.g_ret_sts_success;
349:
350: /* Bug#5109119 Begin check the close period for current step. this check will be done for current step and dependent steps
351: also as process_dependent_steps will be called for each step*/
352: IF NOT gme_common_pvt.check_close_period(p_org_id => p_batch_header_rec.organization_id
353: ,p_trans_date => p_batch_step_rec.actual_start_date) THEN
354: RAISE error_close_period;
355: END IF;
356:

Line 397: gme_common_pvt.g_auto_step_release THEN

393: END IF;
394:
395: /* If the dependent step is set to automatic release */
396: IF l_dep_step_rec.steprelease_type =
397: gme_common_pvt.g_auto_step_release THEN
398: l_batch_step_rec.batchstep_id := l_dep_step_rec.dep_step_id;
399:
400: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec
401: ,l_batch_step_rec) ) THEN

Line 409: gme_common_pvt.g_dep_type_finish_start)

405: /* If the dependency is Finish To Start and their is a positive delay */
406: /* then complete the dependent step otherwise call the release API if the step */
407: /* status is pending. */
408: IF (l_dep_step_rec.dep_type =
409: gme_common_pvt.g_dep_type_finish_start)
410: AND (l_dep_step_rec.standard_delay >= 0) THEN
411: l_complete_dep_step := TRUE;
412: ELSE
413: l_complete_dep_step := FALSE;

Line 414: END IF; /* IF (l_dep_step_rec.dep_type = gme_common_pvt.g_dep_type_finish_start) AND */

410: AND (l_dep_step_rec.standard_delay >= 0) THEN
411: l_complete_dep_step := TRUE;
412: ELSE
413: l_complete_dep_step := FALSE;
414: END IF; /* IF (l_dep_step_rec.dep_type = gme_common_pvt.g_dep_type_finish_start) AND */
415:
416: /* If the step status is pending */
417: IF (l_dep_step_rec.step_status = gme_common_pvt.g_step_pending) THEN
418: /*Bug#5183521 when step dependency is start to start, the dependent should start before the current step

Line 417: IF (l_dep_step_rec.step_status = gme_common_pvt.g_step_pending) THEN

413: l_complete_dep_step := FALSE;
414: END IF; /* IF (l_dep_step_rec.dep_type = gme_common_pvt.g_dep_type_finish_start) AND */
415:
416: /* If the step status is pending */
417: IF (l_dep_step_rec.step_status = gme_common_pvt.g_step_pending) THEN
418: /*Bug#5183521 when step dependency is start to start, the dependent should start before the current step
419: considering the standard delay defined in dependencies.commented the ELSE and added OR condition */
420: IF (l_dep_step_rec.dep_type = gme_common_pvt.g_dep_type_finish_start AND
421: l_dep_step_rec.standard_delay < 0) OR

Line 420: IF (l_dep_step_rec.dep_type = gme_common_pvt.g_dep_type_finish_start AND

416: /* If the step status is pending */
417: IF (l_dep_step_rec.step_status = gme_common_pvt.g_step_pending) THEN
418: /*Bug#5183521 when step dependency is start to start, the dependent should start before the current step
419: considering the standard delay defined in dependencies.commented the ELSE and added OR condition */
420: IF (l_dep_step_rec.dep_type = gme_common_pvt.g_dep_type_finish_start AND
421: l_dep_step_rec.standard_delay < 0) OR
422: (l_dep_step_rec.dep_type = gme_common_pvt.g_dep_type_start_start) THEN
423: l_batch_step_rec.actual_start_date :=
424: p_batch_step_rec.actual_start_date

Line 422: (l_dep_step_rec.dep_type = gme_common_pvt.g_dep_type_start_start) THEN

418: /*Bug#5183521 when step dependency is start to start, the dependent should start before the current step
419: considering the standard delay defined in dependencies.commented the ELSE and added OR condition */
420: IF (l_dep_step_rec.dep_type = gme_common_pvt.g_dep_type_finish_start AND
421: l_dep_step_rec.standard_delay < 0) OR
422: (l_dep_step_rec.dep_type = gme_common_pvt.g_dep_type_start_start) THEN
423: l_batch_step_rec.actual_start_date :=
424: p_batch_step_rec.actual_start_date
425: - (l_dep_step_rec.standard_delay / 24);
426: /*ELSIF (l_dep_step_rec.dep_type =

Line 427: gme_common_pvt.g_dep_type_start_start) THEN

423: l_batch_step_rec.actual_start_date :=
424: p_batch_step_rec.actual_start_date
425: - (l_dep_step_rec.standard_delay / 24);
426: /*ELSIF (l_dep_step_rec.dep_type =
427: gme_common_pvt.g_dep_type_start_start) THEN
428: l_batch_step_rec.actual_start_date :=
429: p_batch_step_rec.actual_start_date
430: + (l_dep_step_rec.standard_delay / 24); */
431: END IF;

Line 432: /* dep_type = gme_common_pvt.g_dep_type_finish_start */

428: l_batch_step_rec.actual_start_date :=
429: p_batch_step_rec.actual_start_date
430: + (l_dep_step_rec.standard_delay / 24); */
431: END IF;
432: /* dep_type = gme_common_pvt.g_dep_type_finish_start */
433:
434: l_in_batch_step_rec := l_batch_step_rec;
435: /* Bug#5109119 when l_complete_dep_step is TRUE call complete_step directly, no need to call release_step */
436: IF NOT l_complete_dep_step THEN

Line 446: ,gme_common_pvt.g_exceptions_err) THEN

442: ,x_return_status => l_return_status);
443:
444: IF l_return_status NOT IN
445: (fnd_api.g_ret_sts_success
446: ,gme_common_pvt.g_exceptions_err) THEN
447: x_return_status := l_return_status;
448: RAISE dep_step_rel_error;
449: END IF;
450:

Line 451: IF l_return_status = gme_common_pvt.g_exceptions_err THEN

447: x_return_status := l_return_status;
448: RAISE dep_step_rel_error;
449: END IF;
450:
451: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
452: x_return_status := gme_common_pvt.g_exceptions_err;
453: END IF;
454: END IF; /* IF NOT l_complete_dep_step THEN */
455: END IF; /* IF (l_dep_step_rec.step_status = gme_common_pvt.g_step_pending) */

Line 452: x_return_status := gme_common_pvt.g_exceptions_err;

448: RAISE dep_step_rel_error;
449: END IF;
450:
451: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
452: x_return_status := gme_common_pvt.g_exceptions_err;
453: END IF;
454: END IF; /* IF NOT l_complete_dep_step THEN */
455: END IF; /* IF (l_dep_step_rec.step_status = gme_common_pvt.g_step_pending) */
456:

Line 455: END IF; /* IF (l_dep_step_rec.step_status = gme_common_pvt.g_step_pending) */

451: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
452: x_return_status := gme_common_pvt.g_exceptions_err;
453: END IF;
454: END IF; /* IF NOT l_complete_dep_step THEN */
455: END IF; /* IF (l_dep_step_rec.step_status = gme_common_pvt.g_step_pending) */
456:
457: IF l_complete_dep_step THEN
458: l_batch_step_rec.actual_cmplt_date :=
459: p_batch_step_rec.actual_start_date

Line 482: ,gme_common_pvt.g_exceptions_err) THEN

478: ,x_exception_material_tbl => x_exception_material_tbl);
479:
480: IF l_return_status NOT IN
481: (fnd_api.g_ret_sts_success
482: ,gme_common_pvt.g_exceptions_err) THEN
483: x_return_status := l_return_status;
484: RAISE dep_step_cmpl_error;
485: END IF;
486:

Line 487: IF l_return_status = gme_common_pvt.g_exceptions_err THEN

483: x_return_status := l_return_status;
484: RAISE dep_step_cmpl_error;
485: END IF;
486:
487: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
488: x_return_status := gme_common_pvt.g_exceptions_err;
489: END IF;
490: END IF; -- IF l_complete_dep_step THEN
491: END IF; -- IF l_dep_step_rec.steprelease_type = gme_common_pvt.g_auto_step_release

Line 488: x_return_status := gme_common_pvt.g_exceptions_err;

484: RAISE dep_step_cmpl_error;
485: END IF;
486:
487: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
488: x_return_status := gme_common_pvt.g_exceptions_err;
489: END IF;
490: END IF; -- IF l_complete_dep_step THEN
491: END IF; -- IF l_dep_step_rec.steprelease_type = gme_common_pvt.g_auto_step_release
492: END LOOP; /* FOR l_dep_step_rec IN Cur_get_dep_steps */

Line 491: END IF; -- IF l_dep_step_rec.steprelease_type = gme_common_pvt.g_auto_step_release

487: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
488: x_return_status := gme_common_pvt.g_exceptions_err;
489: END IF;
490: END IF; -- IF l_complete_dep_step THEN
491: END IF; -- IF l_dep_step_rec.steprelease_type = gme_common_pvt.g_auto_step_release
492: END LOOP; /* FOR l_dep_step_rec IN Cur_get_dep_steps */
493:
494:
495: /* Bug#5109119 l_first_step_start_date will preserve the min(step dates) between the recursive calls.

Line 518: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'

514: fnd_msg_pub.ADD;
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: --Bug#5109119 End
517: WHEN batch_step_fetch_error THEN
518: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
519: ,SQLERRM);
520: x_return_status := fnd_api.g_ret_sts_unexp_error;
521: WHEN dep_step_rel_error OR dep_step_cmpl_error THEN
522: NULL;

Line 557: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab

553: =============================================================================================*/
554: PROCEDURE release_step_line (
555: p_batch_step_rec IN gme_batch_steps%ROWTYPE
556: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
557: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
558: ,x_return_status OUT NOCOPY VARCHAR2)
559: IS
560: l_api_name CONSTANT VARCHAR2 (30) := 'release_step_line';
561: l_return_status VARCHAR2 (1);

Line 582: x_batch_step_rec.step_status := gme_common_pvt.g_step_wip;

578: -- Each time this is called, p_batch_step_rec has already been retrieved from DB... has all
579: -- latest data and in addition has the actual start date calculated and set
580: x_batch_step_rec := p_batch_step_rec;
581: /* Update the Batch Step Status to WIP */
582: x_batch_step_rec.step_status := gme_common_pvt.g_step_wip;
583:
584: -- Update the batch step
585: IF NOT (gme_batch_steps_dbl.update_row (x_batch_step_rec) ) THEN
586: RAISE batch_step_upd_err;

Line 590: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;

586: RAISE batch_step_upd_err;
587: END IF;
588:
589: -- Update WHO columns for output structure
590: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;
591: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;
592: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;
593:
594: -- Update activity start date

Line 591: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;

587: END IF;
588:
589: -- Update WHO columns for output structure
590: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;
591: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;
592: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;
593:
594: -- Update activity start date
595: -- Does not factor in offset

Line 592: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;

588:
589: -- Update WHO columns for output structure
590: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;
591: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;
592: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;
593:
594: -- Update activity start date
595: -- Does not factor in offset
596: UPDATE gme_batch_step_activities

Line 598: ,last_updated_by = gme_common_pvt.g_user_ident

594: -- Update activity start date
595: -- Does not factor in offset
596: UPDATE gme_batch_step_activities
597: SET actual_start_date = x_batch_step_rec.actual_start_date
598: ,last_updated_by = gme_common_pvt.g_user_ident
599: ,last_update_date = gme_common_pvt.g_timestamp
600: ,last_update_login = gme_common_pvt.g_login_id
601: WHERE batchstep_id = x_batch_step_rec.batchstep_id;
602:

Line 599: ,last_update_date = gme_common_pvt.g_timestamp

595: -- Does not factor in offset
596: UPDATE gme_batch_step_activities
597: SET actual_start_date = x_batch_step_rec.actual_start_date
598: ,last_updated_by = gme_common_pvt.g_user_ident
599: ,last_update_date = gme_common_pvt.g_timestamp
600: ,last_update_login = gme_common_pvt.g_login_id
601: WHERE batchstep_id = x_batch_step_rec.batchstep_id;
602:
603: -- Update resource start date

Line 600: ,last_update_login = gme_common_pvt.g_login_id

596: UPDATE gme_batch_step_activities
597: SET actual_start_date = x_batch_step_rec.actual_start_date
598: ,last_updated_by = gme_common_pvt.g_user_ident
599: ,last_update_date = gme_common_pvt.g_timestamp
600: ,last_update_login = gme_common_pvt.g_login_id
601: WHERE batchstep_id = x_batch_step_rec.batchstep_id;
602:
603: -- Update resource start date
604: -- Does not factor in offset

Line 607: ,last_updated_by = gme_common_pvt.g_user_ident

603: -- Update resource start date
604: -- Does not factor in offset
605: UPDATE gme_batch_step_resources
606: SET actual_start_date = x_batch_step_rec.actual_start_date
607: ,last_updated_by = gme_common_pvt.g_user_ident
608: ,last_update_date = gme_common_pvt.g_timestamp
609: ,last_update_login = gme_common_pvt.g_login_id
610: WHERE batchstep_id = x_batch_step_rec.batchstep_id;
611:

Line 608: ,last_update_date = gme_common_pvt.g_timestamp

604: -- Does not factor in offset
605: UPDATE gme_batch_step_resources
606: SET actual_start_date = x_batch_step_rec.actual_start_date
607: ,last_updated_by = gme_common_pvt.g_user_ident
608: ,last_update_date = gme_common_pvt.g_timestamp
609: ,last_update_login = gme_common_pvt.g_login_id
610: WHERE batchstep_id = x_batch_step_rec.batchstep_id;
611:
612: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

Line 609: ,last_update_login = gme_common_pvt.g_login_id

605: UPDATE gme_batch_step_resources
606: SET actual_start_date = x_batch_step_rec.actual_start_date
607: ,last_updated_by = gme_common_pvt.g_user_ident
608: ,last_update_date = gme_common_pvt.g_timestamp
609: ,last_update_login = gme_common_pvt.g_login_id
610: WHERE batchstep_id = x_batch_step_rec.batchstep_id;
611:
612: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
613: gme_debug.g_log_procedure THEN

Line 618: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'

614: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
615: END IF;
616: EXCEPTION
617: WHEN batch_step_upd_err THEN
618: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
619: ,SQLERRM);
620: x_return_status := fnd_api.g_ret_sts_unexp_error;
621: WHEN OTHERS THEN
622: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 639: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab

635:
636: PROCEDURE release_step_ingredients (
637: p_batch_step_rec IN gme_batch_steps%ROWTYPE
638: ,p_update_inv_ind IN VARCHAR2
639: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
640: ,x_return_status OUT NOCOPY VARCHAR2)
641: IS
642: CURSOR cur_step_ingredients (v_batchstep_id NUMBER)
643: IS

Line 648: AND matl.line_type = gme_common_pvt.g_line_type_ing

644: SELECT matl.*
645: FROM gme_material_details matl, gme_batch_step_items item
646: WHERE item.batchstep_id = v_batchstep_id
647: AND item.material_detail_id = matl.material_detail_id
648: AND matl.line_type = gme_common_pvt.g_line_type_ing
649: AND matl.release_type = gme_common_pvt.g_mtl_autobystep_release;
650:
651: l_api_name CONSTANT VARCHAR2 (30) := 'release_step_ingredients';
652: l_return_status VARCHAR2 (1);

Line 649: AND matl.release_type = gme_common_pvt.g_mtl_autobystep_release;

645: FROM gme_material_details matl, gme_batch_step_items item
646: WHERE item.batchstep_id = v_batchstep_id
647: AND item.material_detail_id = matl.material_detail_id
648: AND matl.line_type = gme_common_pvt.g_line_type_ing
649: AND matl.release_type = gme_common_pvt.g_mtl_autobystep_release;
650:
651: l_api_name CONSTANT VARCHAR2 (30) := 'release_step_ingredients';
652: l_return_status VARCHAR2 (1);
653: l_matl_dtl_rec gme_material_details%ROWTYPE;

Line 654: l_matl_dtl_tab gme_common_pvt.material_details_tab;

650:
651: l_api_name CONSTANT VARCHAR2 (30) := 'release_step_ingredients';
652: l_return_status VARCHAR2 (1);
653: l_matl_dtl_rec gme_material_details%ROWTYPE;
654: l_matl_dtl_tab gme_common_pvt.material_details_tab;
655: l_consume BOOLEAN;
656: error_process_ing EXCEPTION;
657: BEGIN
658: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

Line 693: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN

689: ,x_exception_material_tbl => x_exception_material_tbl
690: ,x_return_status => l_return_status);
691:
692: IF l_return_status NOT IN
693: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN
694: x_return_status := l_return_status;
695: RAISE error_process_ing;
696: END IF;
697:

Line 698: IF l_return_status = gme_common_pvt.g_exceptions_err THEN

694: x_return_status := l_return_status;
695: RAISE error_process_ing;
696: END IF;
697:
698: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
699: x_return_status := gme_common_pvt.g_exceptions_err;
700: END IF;
701: END LOOP;
702:

Line 699: x_return_status := gme_common_pvt.g_exceptions_err;

695: RAISE error_process_ing;
696: END IF;
697:
698: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
699: x_return_status := gme_common_pvt.g_exceptions_err;
700: END IF;
701: END LOOP;
702:
703: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

Line 774: ELSIF p_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip THEN

770: x_batch_step_rec.actual_start_date := SYSDATE;
771: ELSE -- user passed in an actual start date; ensure it's not in the future
772: IF (p_batch_step_rec.actual_start_date > SYSDATE) THEN
773: RAISE error_future_date;
774: ELSIF p_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip THEN
775: IF p_batch_step_rec.actual_start_date < p_batch_header_rec.actual_start_date THEN
776: RAISE error_actual_start_date;
777: END IF;
778: END IF;

Line 808: IF NOT gme_common_pvt.check_validity_rule_dates (

804: RAISE error_vr_dates;
805: END IF;*/
806: --sunitha ch. Bug 5336007 aded call to check_validity_rule_dates and passed p_validate_plan_dates_ind=1
807: --to validate planned start date against validate rule dates
808: IF NOT gme_common_pvt.check_validity_rule_dates (
809: p_validity_rule_id => p_batch_header_rec.recipe_validity_rule_id
810: ,p_start_date => p_batch_header_rec.actual_start_date
811: ,p_cmplt_date => p_batch_header_rec.actual_cmplt_date
812: ,p_batch_header_rec => p_batch_header_rec

Line 819: IF NOT gme_common_pvt.check_close_period(p_org_id => p_batch_header_rec.organization_id

815: RAISE error_vr_dates;
816: END IF;
817: -- End Bug 5336007
818: END IF; -- IF p_batch_header_rec.recipe_validity_rule_id IS NOT NULL
819: IF NOT gme_common_pvt.check_close_period(p_org_id => p_batch_header_rec.organization_id
820: ,p_trans_date => x_batch_step_rec.actual_start_date) THEN
821: RAISE error_close_period;
822: END IF;
823:

Line 869: gme_common_pvt.log_message ('GME_STEP_START_BATCH_START_ERR');

865: x_return_status := FND_API.G_RET_STS_ERROR;
866: WHEN error_validation THEN
867: NULL;
868: WHEN error_actual_start_date THEN
869: gme_common_pvt.log_message ('GME_STEP_START_BATCH_START_ERR');
870: x_return_status := FND_API.G_RET_STS_ERROR;
871: WHEN error_vr_dates THEN
872: x_return_status := FND_API.G_RET_STS_ERROR;
873: WHEN OTHERS THEN