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 356: IF NOT gme_common_pvt.check_close_period(p_org_id => p_batch_header_rec.organization_id

352:
353: -- Bug 8595231 - We do not need to validate the start date if the step is already released.
354: -- As this procedure gets called by complete_step_recursive also.
355: IF p_batch_step_rec.step_status = 1 THEN
356: IF NOT gme_common_pvt.check_close_period(p_org_id => p_batch_header_rec.organization_id
357: ,p_trans_date => p_batch_step_rec.actual_start_date) THEN
358: RAISE error_close_period;
359: END IF;
360: END IF;

Line 402: gme_common_pvt.g_auto_step_release THEN

398: END IF;
399:
400: /* If the dependent step is set to automatic release */
401: IF l_dep_step_rec.steprelease_type =
402: gme_common_pvt.g_auto_step_release THEN
403: l_batch_step_rec.batchstep_id := l_dep_step_rec.dep_step_id;
404:
405: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec
406: ,l_batch_step_rec) ) THEN

Line 414: gme_common_pvt.g_dep_type_finish_start)

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

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

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

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

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

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

421: /* If the step status is pending */
422: IF (l_dep_step_rec.step_status = gme_common_pvt.g_step_pending) THEN
423: /*Bug#5183521 when step dependency is start to start, the dependent should start before the current step
424: considering the standard delay defined in dependencies.commented the ELSE and added OR condition */
425: IF (l_dep_step_rec.dep_type = gme_common_pvt.g_dep_type_finish_start AND
426: l_dep_step_rec.standard_delay < 0) OR
427: (l_dep_step_rec.dep_type = 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

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

423: /*Bug#5183521 when step dependency is start to start, the dependent should start before the current step
424: considering the standard delay defined in dependencies.commented the ELSE and added OR condition */
425: IF (l_dep_step_rec.dep_type = gme_common_pvt.g_dep_type_finish_start AND
426: l_dep_step_rec.standard_delay < 0) OR
427: (l_dep_step_rec.dep_type = 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: /*ELSIF (l_dep_step_rec.dep_type =

Line 432: 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: /*ELSIF (l_dep_step_rec.dep_type =
432: gme_common_pvt.g_dep_type_start_start) THEN
433: l_batch_step_rec.actual_start_date :=
434: p_batch_step_rec.actual_start_date
435: + (l_dep_step_rec.standard_delay / 24); */
436: END IF;

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

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

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

446: ,x_exception_material_tbl => x_exception_material_tbl
447: ,x_return_status => l_return_status);
448:
449: IF l_return_status NOT IN
450: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN
451: x_return_status := l_return_status;
452: RAISE dep_step_rel_error;
453: END IF;
454:

Line 455: IF l_return_status = gme_common_pvt.g_exceptions_err THEN

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

Line 456: x_return_status := gme_common_pvt.g_exceptions_err;

452: RAISE dep_step_rel_error;
453: END IF;
454:
455: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
456: x_return_status := gme_common_pvt.g_exceptions_err;
457: END IF;
458: END IF; /* IF NOT l_complete_dep_step THEN */
459: END IF; /* IF (l_dep_step_rec.step_status = gme_common_pvt.g_step_pending) */
460:

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

455: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
456: x_return_status := gme_common_pvt.g_exceptions_err;
457: END IF;
458: END IF; /* IF NOT l_complete_dep_step THEN */
459: END IF; /* IF (l_dep_step_rec.step_status = gme_common_pvt.g_step_pending) */
460:
461: IF l_complete_dep_step THEN
462: l_batch_step_rec.actual_cmplt_date :=
463: p_batch_step_rec.actual_start_date

Line 486: ,gme_common_pvt.g_exceptions_err) THEN

482: ,x_exception_material_tbl => x_exception_material_tbl);
483:
484: IF l_return_status NOT IN
485: (fnd_api.g_ret_sts_success
486: ,gme_common_pvt.g_exceptions_err) THEN
487: x_return_status := l_return_status;
488: RAISE dep_step_cmpl_error;
489: END IF;
490:

Line 491: IF l_return_status = gme_common_pvt.g_exceptions_err THEN

487: x_return_status := l_return_status;
488: RAISE dep_step_cmpl_error;
489: END IF;
490:
491: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
492: x_return_status := gme_common_pvt.g_exceptions_err;
493: END IF;
494: END IF; -- IF l_complete_dep_step THEN
495: END IF; -- IF l_dep_step_rec.steprelease_type = gme_common_pvt.g_auto_step_release

Line 492: x_return_status := gme_common_pvt.g_exceptions_err;

488: RAISE dep_step_cmpl_error;
489: END IF;
490:
491: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
492: x_return_status := gme_common_pvt.g_exceptions_err;
493: END IF;
494: END IF; -- IF l_complete_dep_step THEN
495: END IF; -- IF l_dep_step_rec.steprelease_type = gme_common_pvt.g_auto_step_release
496: END LOOP; /* FOR l_dep_step_rec IN Cur_get_dep_steps */

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

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

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

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

Line 562: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab

558: =============================================================================================*/
559: PROCEDURE release_step_line (
560: p_batch_step_rec IN gme_batch_steps%ROWTYPE
561: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
562: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
563: ,x_return_status OUT NOCOPY VARCHAR2)
564: IS
565: l_api_name CONSTANT VARCHAR2 (30) := 'release_step_line';
566: l_return_status VARCHAR2 (1);

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

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

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

591: RAISE batch_step_upd_err;
592: END IF;
593:
594: -- Update WHO columns for output structure
595: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;
596: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;
597: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;
598:
599: -- Bug 13706812 - Use batch id in whse clause to help performance.

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

592: END IF;
593:
594: -- Update WHO columns for output structure
595: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;
596: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;
597: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;
598:
599: -- Bug 13706812 - Use batch id in whse clause to help performance.
600: -- Update activity start date

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

593:
594: -- Update WHO columns for output structure
595: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;
596: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;
597: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;
598:
599: -- Bug 13706812 - Use batch id in whse clause to help performance.
600: -- Update activity start date
601: -- Does not factor in offset

Line 604: ,last_updated_by = gme_common_pvt.g_user_ident

600: -- Update activity start date
601: -- Does not factor in offset
602: UPDATE gme_batch_step_activities
603: SET actual_start_date = x_batch_step_rec.actual_start_date
604: ,last_updated_by = gme_common_pvt.g_user_ident
605: ,last_update_date = gme_common_pvt.g_timestamp
606: ,last_update_login = gme_common_pvt.g_login_id
607: WHERE batchstep_id = x_batch_step_rec.batchstep_id
608: AND batch_id = x_batch_step_rec.batch_id;

Line 605: ,last_update_date = gme_common_pvt.g_timestamp

601: -- Does not factor in offset
602: UPDATE gme_batch_step_activities
603: SET actual_start_date = x_batch_step_rec.actual_start_date
604: ,last_updated_by = gme_common_pvt.g_user_ident
605: ,last_update_date = gme_common_pvt.g_timestamp
606: ,last_update_login = gme_common_pvt.g_login_id
607: WHERE batchstep_id = x_batch_step_rec.batchstep_id
608: AND batch_id = x_batch_step_rec.batch_id;
609:

Line 606: ,last_update_login = gme_common_pvt.g_login_id

602: UPDATE gme_batch_step_activities
603: SET actual_start_date = x_batch_step_rec.actual_start_date
604: ,last_updated_by = gme_common_pvt.g_user_ident
605: ,last_update_date = gme_common_pvt.g_timestamp
606: ,last_update_login = gme_common_pvt.g_login_id
607: WHERE batchstep_id = x_batch_step_rec.batchstep_id
608: AND batch_id = x_batch_step_rec.batch_id;
609:
610: -- Update resource start date

Line 614: ,last_updated_by = gme_common_pvt.g_user_ident

610: -- Update resource start date
611: -- Does not factor in offset
612: UPDATE gme_batch_step_resources
613: SET actual_start_date = x_batch_step_rec.actual_start_date
614: ,last_updated_by = gme_common_pvt.g_user_ident
615: ,last_update_date = gme_common_pvt.g_timestamp
616: ,last_update_login = gme_common_pvt.g_login_id
617: WHERE batchstep_id = x_batch_step_rec.batchstep_id;
618:

Line 615: ,last_update_date = gme_common_pvt.g_timestamp

611: -- Does not factor in offset
612: UPDATE gme_batch_step_resources
613: SET actual_start_date = x_batch_step_rec.actual_start_date
614: ,last_updated_by = gme_common_pvt.g_user_ident
615: ,last_update_date = gme_common_pvt.g_timestamp
616: ,last_update_login = gme_common_pvt.g_login_id
617: WHERE batchstep_id = x_batch_step_rec.batchstep_id;
618:
619: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

Line 616: ,last_update_login = gme_common_pvt.g_login_id

612: UPDATE gme_batch_step_resources
613: SET actual_start_date = x_batch_step_rec.actual_start_date
614: ,last_updated_by = gme_common_pvt.g_user_ident
615: ,last_update_date = gme_common_pvt.g_timestamp
616: ,last_update_login = gme_common_pvt.g_login_id
617: WHERE batchstep_id = x_batch_step_rec.batchstep_id;
618:
619: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
620: gme_debug.g_log_procedure THEN

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

621: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
622: END IF;
623: EXCEPTION
624: WHEN batch_step_upd_err THEN
625: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
626: ,SQLERRM);
627: x_return_status := fnd_api.g_ret_sts_unexp_error;
628: WHEN OTHERS THEN
629: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 646: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab

642:
643: PROCEDURE release_step_ingredients (
644: p_batch_step_rec IN gme_batch_steps%ROWTYPE
645: ,p_update_inv_ind IN VARCHAR2
646: ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
647: ,x_return_status OUT NOCOPY VARCHAR2)
648: IS
649: CURSOR cur_step_ingredients (v_batchstep_id NUMBER)
650: IS

Line 655: AND matl.line_type = gme_common_pvt.g_line_type_ing

651: SELECT matl.*
652: FROM gme_material_details matl, gme_batch_step_items item
653: WHERE item.batchstep_id = v_batchstep_id
654: AND item.material_detail_id = matl.material_detail_id
655: AND matl.line_type = gme_common_pvt.g_line_type_ing
656: AND matl.release_type = gme_common_pvt.g_mtl_autobystep_release;
657:
658: l_api_name CONSTANT VARCHAR2 (30) := 'release_step_ingredients';
659: l_return_status VARCHAR2 (1);

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

652: FROM gme_material_details matl, gme_batch_step_items item
653: WHERE item.batchstep_id = v_batchstep_id
654: AND item.material_detail_id = matl.material_detail_id
655: AND matl.line_type = gme_common_pvt.g_line_type_ing
656: AND matl.release_type = gme_common_pvt.g_mtl_autobystep_release;
657:
658: l_api_name CONSTANT VARCHAR2 (30) := 'release_step_ingredients';
659: l_return_status VARCHAR2 (1);
660: l_matl_dtl_rec gme_material_details%ROWTYPE;

Line 661: l_matl_dtl_tab gme_common_pvt.material_details_tab;

657:
658: l_api_name CONSTANT VARCHAR2 (30) := 'release_step_ingredients';
659: l_return_status VARCHAR2 (1);
660: l_matl_dtl_rec gme_material_details%ROWTYPE;
661: l_matl_dtl_tab gme_common_pvt.material_details_tab;
662: l_consume BOOLEAN;
663:
664: l_reserved_qty NUMBER; -- Bug 13795581
665:

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

711: ,x_exception_material_tbl => x_exception_material_tbl
712: ,x_return_status => l_return_status);
713:
714: IF l_return_status NOT IN
715: (fnd_api.g_ret_sts_success, gme_common_pvt.g_exceptions_err) THEN
716: x_return_status := l_return_status;
717: RAISE error_process_ing;
718: END IF;
719:

Line 720: IF l_return_status = gme_common_pvt.g_exceptions_err THEN

716: x_return_status := l_return_status;
717: RAISE error_process_ing;
718: END IF;
719:
720: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
721: x_return_status := gme_common_pvt.g_exceptions_err;
722: END IF;
723: END IF;
724: END LOOP;

Line 721: x_return_status := gme_common_pvt.g_exceptions_err;

717: RAISE error_process_ing;
718: END IF;
719:
720: IF l_return_status = gme_common_pvt.g_exceptions_err THEN
721: x_return_status := gme_common_pvt.g_exceptions_err;
722: END IF;
723: END IF;
724: END LOOP;
725:

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

793: x_batch_step_rec.actual_start_date := SYSDATE;
794: ELSE -- user passed in an actual start date; ensure it's not in the future
795: IF (p_batch_step_rec.actual_start_date > SYSDATE) THEN
796: RAISE error_future_date;
797: ELSIF p_batch_header_rec.batch_status = gme_common_pvt.g_batch_wip THEN
798: IF p_batch_step_rec.actual_start_date < p_batch_header_rec.actual_start_date THEN
799: RAISE error_actual_start_date;
800: END IF;
801: END IF;

Line 834: IF NOT gme_common_pvt.check_validity_rule_dates (

830: RAISE error_vr_dates;
831: END IF;*/
832: -- sunitha ch. Bug 5336007 aded call to check_validity_rule_dates and passed p_validate_plan_dates_ind=1
833: -- to validate planned start date against validate rule dates
834: IF NOT gme_common_pvt.check_validity_rule_dates (
835: p_validity_rule_id => p_batch_header_rec.recipe_validity_rule_id
836: ,p_start_date => p_batch_header_rec.actual_start_date
837: ,p_cmplt_date => p_batch_header_rec.actual_cmplt_date
838: ,p_batch_header_rec => p_batch_header_rec

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

844: END IF; -- p_batch_header_rec.batch_status = 1
845: END IF; -- IF p_batch_header_rec.recipe_validity_rule_id IS NOT NULL
846:
847:
848: IF NOT gme_common_pvt.check_close_period(p_org_id => p_batch_header_rec.organization_id
849: ,p_trans_date => x_batch_step_rec.actual_start_date) THEN
850: RAISE error_close_period;
851: END IF;
852:

Line 893: gme_common_pvt.log_message ('GME_VALIDITY_OBSO_OR_ONHOLD');

889: WHEN error_close_period THEN
890: x_return_status := FND_API.G_RET_STS_ERROR;
891: -- 7564922 - Add missing exception clause for validity status check.
892: WHEN error_validity_status THEN
893: gme_common_pvt.log_message ('GME_VALIDITY_OBSO_OR_ONHOLD');
894: x_return_status := FND_API.G_RET_STS_ERROR;
895: WHEN error_future_date THEN
896: fnd_message.set_name ('GMA', 'SY_NOFUTUREDATE');
897: fnd_msg_pub.ADD;

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

898: x_return_status := FND_API.G_RET_STS_ERROR;
899: WHEN error_validation THEN
900: NULL;
901: WHEN error_actual_start_date THEN
902: gme_common_pvt.log_message ('GME_STEP_START_BATCH_START_ERR');
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: WHEN error_vr_dates THEN
905: x_return_status := FND_API.G_RET_STS_ERROR;
906: WHEN OTHERS THEN