DBA Data[Home] [Help]

APPS.CHV_CONFIRM_SCHEDULES dependencies on DBMS_OUTPUT

Line 63: dbms_output.put_line(x_message) ;

59: x_message := FND_MESSAGE.GET_STRING('CHV', 'CHV_NOT_CONFIRMED');
60:
61: x_progress := '030';
62:
63: dbms_output.put_line(x_message) ;
64: /* Now since we have the online report as messages we do not need this
65:
66: INSERT INTO po_interface_errors(interface_type,
67: interface_transaction_id,

Line 90: --dbms_output.put_line('confirm schedule item : Exiting') ;

86:
87: */
88: END IF;
89:
90: --dbms_output.put_line('confirm schedule item : Exiting') ;
91:
92: --Return the boolean value to the calling procedure.
93:
94: RETURN(x_item_confirm) ;

Line 164: --dbms_output.put_line('Confirm Header: Entering') ;

160: AND csi.organization_id = coo.organization_id ;
161:
162: BEGIN
163:
164: --dbms_output.put_line('Confirm Header: Entering') ;
165:
166: x_progress := '010';
167:
168: OPEN c_all_schedule_items;

Line 180: --dbms_output.put_line('Confirm Header: Looping') ;

176: SAVEPOINT confirm_schedule_savepoint;
177:
178: LOOP
179:
180: --dbms_output.put_line('Confirm Header: Looping') ;
181:
182: x_progress := '030';
183:
184: FETCH c_all_schedule_items

Line 202: --dbms_output.put_line('Confirm Header: item_status'||x_item_confirm_status) ;

198: x_progress := '040';
199:
200: IF nvl(x_item_confirm_status,'IN_PROCESS') = 'IN_PROCESS' then
201:
202: --dbms_output.put_line('Confirm Header: item_status'||x_item_confirm_status) ;
203:
204: x_item_confirm := confirm_schedule_item(p_schedule_id,
205: x_schedule_item_id,
206: x_vendor_id,

Line 242: --dbms_output.put_line('Confirm Header: select cum period id') ;

238: -- Cums are enabled for this Organization. Select cum details
239: -- in order to update high authorizations for the supplier/site
240: -- item/org.
241:
242: --dbms_output.put_line('Confirm Header: select cum period id') ;
243:
244: -- Select the open cum period for the organization. The period
245: -- should cover the schedule horizon start date.
246:

Line 257: --dbms_output.put_line('Confirm Header cum period id:'||to_char(x_cum_period_id)) ;

253: BETWEEN ccp.cum_period_start_date
254: AND ccp.cum_period_end_date
255: AND ccp.organization_id = x_item_org_id;
256:
257: --dbms_output.put_line('Confirm Header cum period id:'||to_char(x_cum_period_id)) ;
258:
259: -- For the item select asl info with reference to authorizations
260: -- for the supplier/site/item/org.
261: