DBA Data[Home] [Help]

APPS.GME_API_MAIN dependencies on GME_COMMON_PVT

Line 56: := gme_common_pvt.g_max_errors

52: V - Inventory shortage exists
53: ================================================================================*/
54: PROCEDURE create_batch (
55: p_validation_level IN NUMBER
56: := gme_common_pvt.g_max_errors
57: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
58: ,x_message_count OUT NOCOPY NUMBER
59: ,x_message_list OUT NOCOPY VARCHAR2
60: ,x_return_status OUT NOCOPY VARCHAR2

Line 75: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);

71: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_true
72: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true
73: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
74: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
75: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
76:
77: /*================================================================================
78: Procedure
79: create_phantom

Line 103: := gme_common_pvt.g_max_errors

99: U - Unexpected Error
100: ================================================================================*/
101: PROCEDURE create_phantom (
102: p_validation_level IN NUMBER
103: := gme_common_pvt.g_max_errors
104: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
105: ,x_message_count OUT NOCOPY NUMBER
106: ,x_message_list OUT NOCOPY VARCHAR2
107: ,x_return_status OUT NOCOPY VARCHAR2

Line 116: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);

112: ,p_validity_rule_id IN NUMBER
113: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true
114: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
115: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
116: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
117:
118: /*================================================================================
119: Procedure
120: scale_batch

Line 157: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab

153: ,p_qty_type IN NUMBER
154: ,p_recalc_dates IN VARCHAR2 -- Navin
155: ,p_use_workday_cal IN VARCHAR2
156: ,p_contiguity_override IN VARCHAR2
157: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
158: --Navin
159: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
160: ,x_message_count OUT NOCOPY NUMBER
161: ,x_message_list OUT NOCOPY VARCHAR2

Line 216: := gme_common_pvt.g_max_errors

212: ================================================================================*/
213:
214: PROCEDURE insert_material_line (
215: p_validation_level IN NUMBER
216: := gme_common_pvt.g_max_errors
217: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
218: ,x_message_count OUT NOCOPY NUMBER
219: ,x_message_list OUT NOCOPY VARCHAR2
220: ,x_return_status OUT NOCOPY VARCHAR2

Line 231: := gme_common_pvt.g_max_errors

227:
228: -- following called from form... streamlined: step record not required
229: PROCEDURE insert_material_line (
230: p_validation_level IN NUMBER
231: := gme_common_pvt.g_max_errors
232: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
233: ,x_message_count OUT NOCOPY NUMBER
234: ,x_message_list OUT NOCOPY VARCHAR2
235: ,x_return_status OUT NOCOPY VARCHAR2

Line 273: := gme_common_pvt.g_max_errors

269: ================================================================================*/
270:
271: PROCEDURE update_material_line (
272: p_validation_level IN NUMBER
273: := gme_common_pvt.g_max_errors
274: ,p_init_msg_list IN VARCHAR2
275: := fnd_api.g_false
276: ,x_message_count OUT NOCOPY NUMBER
277: ,x_message_list OUT NOCOPY VARCHAR2

Line 292: := gme_common_pvt.g_max_errors

288:
289: -- following called from form... streamlined: step record and stored matl dtl record not required
290: PROCEDURE update_material_line (
291: p_validation_level IN NUMBER
292: := gme_common_pvt.g_max_errors
293: ,p_init_msg_list IN VARCHAR2
294: := fnd_api.g_false
295: ,x_message_count OUT NOCOPY NUMBER
296: ,x_message_list OUT NOCOPY VARCHAR2

Line 329: := gme_common_pvt.g_max_errors

325:
326:
327: PROCEDURE delete_material_line (
328: p_validation_level IN NUMBER
329: := gme_common_pvt.g_max_errors
330: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
331: ,x_message_count OUT NOCOPY NUMBER
332: ,x_message_list OUT NOCOPY VARCHAR2
333: ,x_return_status OUT NOCOPY VARCHAR2

Line 342: := gme_common_pvt.g_max_errors

338:
339: -- following called from form... streamlined: step record not required
340: PROCEDURE delete_material_line (
341: p_validation_level IN NUMBER
342: := gme_common_pvt.g_max_errors
343: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
344: ,x_message_count OUT NOCOPY NUMBER
345: ,x_message_list OUT NOCOPY VARCHAR2
346: ,x_return_status OUT NOCOPY VARCHAR2

Line 499: := gme_common_pvt.g_max_errors

495: X - Exception
496: ================================================================================*/
497: PROCEDURE release_batch (
498: p_validation_level IN NUMBER
499: := gme_common_pvt.g_max_errors
500: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
501: ,x_message_count OUT NOCOPY NUMBER
502: ,x_message_list OUT NOCOPY VARCHAR2
503: ,x_return_status OUT NOCOPY VARCHAR2

Line 506: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab

502: ,x_message_list OUT NOCOPY VARCHAR2
503: ,x_return_status OUT NOCOPY VARCHAR2
504: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
505: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
506: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
507: ,p_ignore_exception IN VARCHAR2 := NULL); --Bug#5186328
508:
509: /*================================================================================
510: Procedure

Line 531: := gme_common_pvt.g_max_errors

527: X - Exception
528: ================================================================================*/
529: PROCEDURE release_step (
530: p_validation_level IN NUMBER
531: := gme_common_pvt.g_max_errors
532: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
533: ,x_message_count OUT NOCOPY NUMBER
534: ,x_message_list OUT NOCOPY VARCHAR2
535: ,x_return_status OUT NOCOPY VARCHAR2

Line 539: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab

535: ,x_return_status OUT NOCOPY VARCHAR2
536: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
537: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
538: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
539: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
540: ,p_ignore_exception IN VARCHAR2 := NULL); --Bug#5186328
541:
542: /*================================================================================
543: Procedure

Line 561: := gme_common_pvt.g_max_errors

557: U - Unexpected Error
558: ================================================================================*/
559: PROCEDURE complete_batch (
560: p_validation_level IN NUMBER
561: := gme_common_pvt.g_max_errors
562: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
563: ,x_message_count OUT NOCOPY NUMBER
564: ,x_message_list OUT NOCOPY VARCHAR2
565: ,x_return_status OUT NOCOPY VARCHAR2

Line 568: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab

564: ,x_message_list OUT NOCOPY VARCHAR2
565: ,x_return_status OUT NOCOPY VARCHAR2
566: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
567: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
568: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
569: ,p_ignore_exception IN VARCHAR2 := NULL); --Bug#5186328
570:
571: /*================================================================================
572: Procedure

Line 593: := gme_common_pvt.g_max_errors

589:
590: ================================================================================*/
591: PROCEDURE complete_step (
592: p_validation_level IN NUMBER
593: := gme_common_pvt.g_max_errors
594: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
595: ,x_message_count OUT NOCOPY NUMBER
596: ,x_message_list OUT NOCOPY VARCHAR2
597: ,x_return_status OUT NOCOPY VARCHAR2

Line 601: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab

597: ,x_return_status OUT NOCOPY VARCHAR2
598: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
599: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
600: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
601: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
602: ,p_ignore_exception IN VARCHAR2 := NULL); --Bug#5186328
603:
604: /*================================================================================
605: Procedure

Line 621: := gme_common_pvt.g_max_errors

617: U - Unexpected Error
618: ================================================================================*/
619: PROCEDURE delete_step (
620: p_validation_level IN NUMBER
621: := gme_common_pvt.g_max_errors
622: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
623: ,x_message_count OUT NOCOPY NUMBER
624: ,x_message_list OUT NOCOPY VARCHAR2
625: ,x_return_status OUT NOCOPY VARCHAR2

Line 645: := gme_common_pvt.g_max_errors

641: U - Unexpected Error
642: ================================================================================*/
643: PROCEDURE insert_step (
644: p_validation_level IN NUMBER
645: := gme_common_pvt.g_max_errors
646: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
647: ,x_message_count OUT NOCOPY NUMBER
648: ,x_message_list OUT NOCOPY VARCHAR2
649: ,x_return_status OUT NOCOPY VARCHAR2

Line 669: p_validation_level IN NUMBER := gme_common_pvt.g_max_errors

665: E - Error
666: U - Unexpected Error
667: ================================================================================*/
668: PROCEDURE revert_batch (
669: p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
670: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
671: ,x_message_count OUT NOCOPY NUMBER
672: ,x_message_list OUT NOCOPY VARCHAR2
673: ,x_return_status OUT NOCOPY VARCHAR2

Line 698: p_validation_level IN NUMBER := gme_common_pvt.g_max_errors

694: U - Unexpected Error
695: ================================================================================*/
696:
697: PROCEDURE revert_step (
698: p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
699: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
700: ,x_message_count OUT NOCOPY NUMBER
701: ,x_message_list OUT NOCOPY VARCHAR2
702: ,x_return_status OUT NOCOPY VARCHAR2

Line 758: := gme_common_pvt.g_max_errors /* Punit Kumar */

754: U - Unexpected Error
755: ================================================================================*/
756: PROCEDURE close_step (
757: p_validation_level IN NUMBER
758: := gme_common_pvt.g_max_errors /* Punit Kumar */
759: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
760: ,x_message_count OUT NOCOPY NUMBER
761: ,x_message_list OUT NOCOPY VARCHAR2
762: ,x_return_status OUT NOCOPY VARCHAR2

Line 789: := gme_common_pvt.g_max_errors /* Punit Kumar */

785: U - Unexpected Error
786: ================================================================================*/
787: PROCEDURE reopen_batch (
788: p_validation_level IN NUMBER
789: := gme_common_pvt.g_max_errors /* Punit Kumar */
790: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
791: ,x_message_count OUT NOCOPY NUMBER
792: ,x_message_list OUT NOCOPY VARCHAR2
793: ,x_return_status OUT NOCOPY VARCHAR2

Line 817: := gme_common_pvt.g_max_errors /* Punit Kumar */

813: U - Unexpected Error
814: ================================================================================*/
815: PROCEDURE reopen_step (
816: p_validation_level IN NUMBER
817: := gme_common_pvt.g_max_errors /* Punit Kumar */
818: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
819: ,x_message_count OUT NOCOPY NUMBER
820: ,x_message_list OUT NOCOPY VARCHAR2
821: ,x_return_status OUT NOCOPY VARCHAR2

Line 852: := gme_common_pvt.g_max_errors

848: HISTORY
849: ================================================================================*/
850: PROCEDURE incremental_backflush (
851: p_validation_level IN NUMBER
852: := gme_common_pvt.g_max_errors
853: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
854: ,x_message_count OUT NOCOPY NUMBER
855: ,x_message_list OUT NOCOPY VARCHAR2
856: ,x_return_status OUT NOCOPY VARCHAR2

Line 862: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);

858: ,p_material_detail_rec IN gme_material_details%ROWTYPE
859: ,p_qty IN NUMBER
860: ,p_qty_type IN NUMBER
861: ,p_trans_date IN DATE
862: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
863:
864:
865: /*================================================================================
866: Procedure

Line 887: := gme_common_pvt.g_max_errors

883: C - No continous periods found
884: ================================================================================*/
885: PROCEDURE reroute_batch (
886: p_validation_level IN NUMBER
887: := gme_common_pvt.g_max_errors
888: ,p_init_msg_list IN VARCHAR2
889: DEFAULT fnd_api.g_false
890: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
891: ,p_validity_rule_id IN NUMBER

Line 920: := gme_common_pvt.g_max_errors

916: U - Unexpected Error
917: ================================================================================*/
918: PROCEDURE cancel_batch (
919: p_validation_level IN NUMBER
920: := gme_common_pvt.g_max_errors
921: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
922: ,x_message_count OUT NOCOPY NUMBER
923: ,x_message_list OUT NOCOPY VARCHAR2
924: ,x_return_status OUT NOCOPY VARCHAR2

Line 949: := gme_common_pvt.g_max_errors

945: U - Unexpected Error
946: ================================================================================*/
947: PROCEDURE terminate_batch (
948: p_validation_level IN NUMBER
949: := gme_common_pvt.g_max_errors
950: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
951: ,x_message_count OUT NOCOPY NUMBER
952: ,x_message_list OUT NOCOPY VARCHAR2
953: ,x_return_status OUT NOCOPY VARCHAR2

Line 976: := gme_common_pvt.g_max_errors

972: U - Unexpected Error
973: ================================================================================*/
974: PROCEDURE unrelease_batch (
975: p_validation_level IN NUMBER
976: := gme_common_pvt.g_max_errors
977: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
978: ,x_message_count OUT NOCOPY NUMBER
979: ,x_message_list OUT NOCOPY VARCHAR2
980: ,x_return_status OUT NOCOPY VARCHAR2

Line 1006: := gme_common_pvt.g_max_errors

1002: U - Unexpected Error
1003: ================================================================================*/
1004: PROCEDURE unrelease_step (
1005: p_validation_level IN NUMBER
1006: := gme_common_pvt.g_max_errors
1007: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1008: ,x_message_count OUT NOCOPY NUMBER
1009: ,x_message_list OUT NOCOPY VARCHAR2
1010: ,x_return_status OUT NOCOPY VARCHAR2

Line 1085: := gme_common_pvt.g_max_errors

1081: ================================================================================*/
1082:
1083: PROCEDURE create_pending_product_lot (
1084: p_validation_level IN NUMBER
1085: := gme_common_pvt.g_max_errors
1086: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1087: ,x_message_count OUT NOCOPY NUMBER
1088: ,x_message_list OUT NOCOPY VARCHAR2
1089: ,x_return_status OUT NOCOPY VARCHAR2

Line 1116: := gme_common_pvt.g_max_errors

1112: ================================================================================*/
1113:
1114: PROCEDURE update_pending_product_lot (
1115: p_validation_level IN NUMBER
1116: := gme_common_pvt.g_max_errors
1117: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1118: ,x_message_count OUT NOCOPY NUMBER
1119: ,x_message_list OUT NOCOPY VARCHAR2
1120: ,x_return_status OUT NOCOPY VARCHAR2

Line 1146: := gme_common_pvt.g_max_errors

1142: ================================================================================*/
1143:
1144: PROCEDURE delete_pending_product_lot (
1145: p_validation_level IN NUMBER
1146: := gme_common_pvt.g_max_errors
1147: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1148: ,x_message_count OUT NOCOPY NUMBER
1149: ,x_message_list OUT NOCOPY VARCHAR2
1150: ,x_return_status OUT NOCOPY VARCHAR2