DBA Data[Home] [Help]

APPS.GMI_MO_PURGE dependencies on GMI_RESERVATION_UTIL

Line 71: GMI_Reservation_Util.PrintLn('Purging default transactions');

67: --
68: -- If purge transactions are selected
69: --
70: IF p_purge_option in (0,2) THEN
71: GMI_Reservation_Util.PrintLn('Purging default transactions');
72: FOR Order_rec IN Closed_order_lines
73: LOOP
74: FOR c1rec in Default_transactions (Order_rec.line_id)
75: LOOP

Line 92: GMI_Reservation_Util.PrintLn(' '||loopnum||' Default transactions Successfully purged');

88: END IF;
89: END LOOP; -- Default_transactions
90: COMMIT;
91: END LOOP; -- Closed_order_lines
92: GMI_Reservation_Util.PrintLn(' '||loopnum||' Default transactions Successfully purged');
93: END IF;
94:
95: IF p_purge_option in (1,2) THEN
96: --

Line 118: GMI_Reservation_Util.PrintLn('Backup MO Tables successfully Created');

114: WHEN table_already_exists THEN
115: NULL;
116: END;
117:
118: GMI_Reservation_Util.PrintLn('Backup MO Tables successfully Created');
119: END IF;
120:
121: --
122: -- If purge Move order is selected

Line 126: GMI_Reservation_Util.PrintLn('Purging Move Order Header/Lines');

122: -- If purge Move order is selected
123: --
124: IF p_purge_option in (1,2) THEN
125: loopnum := 0; -- Intialize loopnum
126: GMI_Reservation_Util.PrintLn('Purging Move Order Header/Lines');
127: FOR Order_rec IN Closed_order_lines
128: LOOP
129: BEGIN
130: --

Line 204: GMI_Reservation_Util.PrintLn('About '||loopnum||' Move Order Header/Lines purged successfully');

200: NULL;
201: END;
202: END LOOP;
203: COMMIT;
204: GMI_Reservation_Util.PrintLn('About '||loopnum||' Move Order Header/Lines purged successfully');
205: END IF;
206: EXCEPTION
207: when others then
208: GMI_Reservation_Util.PrintLn('Exception has occurred'||SQLERRM|| ' : ' || SQLCODE );

Line 208: GMI_Reservation_Util.PrintLn('Exception has occurred'||SQLERRM|| ' : ' || SQLCODE );

204: GMI_Reservation_Util.PrintLn('About '||loopnum||' Move Order Header/Lines purged successfully');
205: END IF;
206: EXCEPTION
207: when others then
208: GMI_Reservation_Util.PrintLn('Exception has occurred'||SQLERRM|| ' : ' || SQLCODE );
209: ROLLBACK;
210:
211: END Lines;
212: