DBA Data[Home] [Help]

APPS.PO_SHIPMENTS_SV9 dependencies on DBMS_OUTPUT

Line 16: dbms_output.put_line('before call');

12: X_shipment_num NUMBER;
13:
14: BEGIN
15:
16: dbms_output.put_line('before call');
17:
18: po_shipments_sv1.get_shipment_num(X_po_release_id,
19: X_po_line_id,
20: X_shipment_num);

Line 22: dbms_output.put_line('after call');

18: po_shipments_sv1.get_shipment_num(X_po_release_id,
19: X_po_line_id,
20: X_shipment_num);
21:
22: dbms_output.put_line('after call');
23: dbms_output.put_line(X_shipment_num);
24:
25: END test_get_shipment_num;
26:

Line 23: dbms_output.put_line(X_shipment_num);

19: X_po_line_id,
20: X_shipment_num);
21:
22: dbms_output.put_line('after call');
23: dbms_output.put_line(X_shipment_num);
24:
25: END test_get_shipment_num;
26:
27: /*===========================================================================

Line 66: dbms_output.put_line('before call');

62: X_inspection_required_flag VARCHAR2(1) := '';
63:
64: BEGIN
65:
66: dbms_output.put_line('before call');
67:
68: po_shipments_sv1.get_planned_ship_info(
69: X_source_shipment_id,
70: X_set_of_books_id ,

Line 96: dbms_output.put_line('after call');

92: X_accrue_on_receipt_flag,
93: X_receipt_required_flag,
94: X_inspection_required_flag);
95:
96: dbms_output.put_line('after call');
97: dbms_output.put_line('Location Code = '||X_ship_to_location_code);
98: dbms_output.put_line('Location Id = '||X_ship_to_location_id);
99: dbms_output.put_line('Org Code = '||X_ship_to_org_code);
100: dbms_output.put_line('Org Id = '||X_ship_to_organization_id);

Line 97: dbms_output.put_line('Location Code = '||X_ship_to_location_code);

93: X_receipt_required_flag,
94: X_inspection_required_flag);
95:
96: dbms_output.put_line('after call');
97: dbms_output.put_line('Location Code = '||X_ship_to_location_code);
98: dbms_output.put_line('Location Id = '||X_ship_to_location_id);
99: dbms_output.put_line('Org Code = '||X_ship_to_org_code);
100: dbms_output.put_line('Org Id = '||X_ship_to_organization_id);
101: dbms_output.put_line('Quantity = '||X_quantity);

Line 98: dbms_output.put_line('Location Id = '||X_ship_to_location_id);

94: X_inspection_required_flag);
95:
96: dbms_output.put_line('after call');
97: dbms_output.put_line('Location Code = '||X_ship_to_location_code);
98: dbms_output.put_line('Location Id = '||X_ship_to_location_id);
99: dbms_output.put_line('Org Code = '||X_ship_to_org_code);
100: dbms_output.put_line('Org Id = '||X_ship_to_organization_id);
101: dbms_output.put_line('Quantity = '||X_quantity);
102:

Line 99: dbms_output.put_line('Org Code = '||X_ship_to_org_code);

95:
96: dbms_output.put_line('after call');
97: dbms_output.put_line('Location Code = '||X_ship_to_location_code);
98: dbms_output.put_line('Location Id = '||X_ship_to_location_id);
99: dbms_output.put_line('Org Code = '||X_ship_to_org_code);
100: dbms_output.put_line('Org Id = '||X_ship_to_organization_id);
101: dbms_output.put_line('Quantity = '||X_quantity);
102:
103: END test_get_planned_ship_info;

Line 100: dbms_output.put_line('Org Id = '||X_ship_to_organization_id);

96: dbms_output.put_line('after call');
97: dbms_output.put_line('Location Code = '||X_ship_to_location_code);
98: dbms_output.put_line('Location Id = '||X_ship_to_location_id);
99: dbms_output.put_line('Org Code = '||X_ship_to_org_code);
100: dbms_output.put_line('Org Id = '||X_ship_to_organization_id);
101: dbms_output.put_line('Quantity = '||X_quantity);
102:
103: END test_get_planned_ship_info;
104:

Line 101: dbms_output.put_line('Quantity = '||X_quantity);

97: dbms_output.put_line('Location Code = '||X_ship_to_location_code);
98: dbms_output.put_line('Location Id = '||X_ship_to_location_id);
99: dbms_output.put_line('Org Code = '||X_ship_to_org_code);
100: dbms_output.put_line('Org Id = '||X_ship_to_organization_id);
101: dbms_output.put_line('Quantity = '||X_quantity);
102:
103: END test_get_planned_ship_info;
104:
105:

Line 119: dbms_output.put_line('before call');

115: X_quantity_released NUMBER := '';
116:
117: BEGIN
118:
119: dbms_output.put_line('before call');
120:
121: X_quantity_released := po_shipments_sv1.get_sched_released_qty(X_source_id,
122: X_entity_level, X_shipment_type);
123:

Line 124: dbms_output.put_line('Return Value is = '||X_quantity_released);

120:
121: X_quantity_released := po_shipments_sv1.get_sched_released_qty(X_source_id,
122: X_entity_level, X_shipment_type);
123:
124: dbms_output.put_line('Return Value is = '||X_quantity_released);
125:
126: END test_get_sched_released_qty;
127:
128:

Line 141: dbms_output.put_line('before call');

137: X_number_shipments NUMBER := '';
138:
139: BEGIN
140:
141: dbms_output.put_line('before call');
142:
143: X_number_shipments := po_shipments_sv2.get_number_shipments(X_po_line_id,
144: X_shipment_type);
145:

Line 146: dbms_output.put_line('Return Value is = '||X_number_shipments);

142:
143: X_number_shipments := po_shipments_sv2.get_number_shipments(X_po_line_id,
144: X_shipment_type);
145:
146: dbms_output.put_line('Return Value is = '||X_number_shipments);
147:
148: END test_get_number_shipments;
149:
150: /*===========================================================================

Line 160: dbms_output.put_line('before call');

156: X_shipment_type IN VARCHAR2) IS
157:
158: BEGIN
159:
160: dbms_output.put_line('before call');
161:
162: IF po_shipments_sv2.val_release_shipments(X_po_line_id, X_shipment_type) THEN
163: dbms_output.put_line('Return TRUE');
164: ELSE

Line 163: dbms_output.put_line('Return TRUE');

159:
160: dbms_output.put_line('before call');
161:
162: IF po_shipments_sv2.val_release_shipments(X_po_line_id, X_shipment_type) THEN
163: dbms_output.put_line('Return TRUE');
164: ELSE
165: dbms_output.put_line('Return FALSE');
166:
167: END IF;

Line 165: dbms_output.put_line('Return FALSE');

161:
162: IF po_shipments_sv2.val_release_shipments(X_po_line_id, X_shipment_type) THEN
163: dbms_output.put_line('Return TRUE');
164: ELSE
165: dbms_output.put_line('Return FALSE');
166:
167: END IF;
168: END test_val_release_shipments;
169:

Line 182: dbms_output.put_line('before call');

178: X_line_location_id NUMBER := '';
179:
180: BEGIN
181:
182: dbms_output.put_line('before call');
183:
184: X_line_location_id := po_shipments_sv3.get_line_location_id(X_po_line_id,
185: X_shipment_type);
186:

Line 187: dbms_output.put_line('Return Value is = '||X_line_location_id);

183:
184: X_line_location_id := po_shipments_sv3.get_line_location_id(X_po_line_id,
185: X_shipment_type);
186:
187: dbms_output.put_line('Return Value is = '||X_line_location_id);
188:
189: END test_get_line_location_id;
190:
191:

Line 209: dbms_output.put_line('before call');

205: X_cancelled_flag VARCHAR2(1) := '';
206:
207: BEGIN
208:
209: dbms_output.put_line('before call');
210:
211: po_shipments_sv2.get_shipment_status(X_po_line_id,
212: X_shipment_type,
213: X_line_location_id,

Line 219: dbms_output.put_line('Approved Value is = '||X_approved_flag);

215: X_encumbered_flag,
216: X_closed_code,
217: X_cancelled_flag);
218:
219: dbms_output.put_line('Approved Value is = '||X_approved_flag);
220: dbms_output.put_line('Encumbered Value is = '||X_encumbered_flag);
221: dbms_output.put_line('Closed Code is = '||X_closed_code);
222: dbms_output.put_line('Cancelled_flag is = '||X_cancelled_flag);
223:

Line 220: dbms_output.put_line('Encumbered Value is = '||X_encumbered_flag);

216: X_closed_code,
217: X_cancelled_flag);
218:
219: dbms_output.put_line('Approved Value is = '||X_approved_flag);
220: dbms_output.put_line('Encumbered Value is = '||X_encumbered_flag);
221: dbms_output.put_line('Closed Code is = '||X_closed_code);
222: dbms_output.put_line('Cancelled_flag is = '||X_cancelled_flag);
223:
224: END test_get_shipment_status;

Line 221: dbms_output.put_line('Closed Code is = '||X_closed_code);

217: X_cancelled_flag);
218:
219: dbms_output.put_line('Approved Value is = '||X_approved_flag);
220: dbms_output.put_line('Encumbered Value is = '||X_encumbered_flag);
221: dbms_output.put_line('Closed Code is = '||X_closed_code);
222: dbms_output.put_line('Cancelled_flag is = '||X_cancelled_flag);
223:
224: END test_get_shipment_status;
225:

Line 222: dbms_output.put_line('Cancelled_flag is = '||X_cancelled_flag);

218:
219: dbms_output.put_line('Approved Value is = '||X_approved_flag);
220: dbms_output.put_line('Encumbered Value is = '||X_encumbered_flag);
221: dbms_output.put_line('Closed Code is = '||X_closed_code);
222: dbms_output.put_line('Cancelled_flag is = '||X_cancelled_flag);
223:
224: END test_get_shipment_status;
225:
226: /*===========================================================================

Line 239: dbms_output.put_line('before call');

235: X_Ship_Val_For_Update BOOLEAN;
236:
237: BEGIN
238:
239: dbms_output.put_line('before call');
240:
241: IF po_shipments_sv2.val_ship_qty(X_po_line_id,
242: X_shipment_type,
243: X_line_quantity) THEN

Line 244: dbms_output.put_line('TRUE');

240:
241: IF po_shipments_sv2.val_ship_qty(X_po_line_id,
242: X_shipment_type,
243: X_line_quantity) THEN
244: dbms_output.put_line('TRUE');
245: ELSE
246: dbms_output.put_line('FALSE');
247: END IF;
248:

Line 246: dbms_output.put_line('FALSE');

242: X_shipment_type,
243: X_line_quantity) THEN
244: dbms_output.put_line('TRUE');
245: ELSE
246: dbms_output.put_line('FALSE');
247: END IF;
248:
249: END test_val_ship_qty;
250:

Line 265: dbms_output.put_line('before call');

261: X_Ship_Val_For_Update BOOLEAN;
262:
263: BEGIN
264:
265: dbms_output.put_line('before call');
266:
267: IF po_shipments_sv2.val_ship_price(X_po_line_id,
268: X_shipment_type,
269: X_unit_price) THEN

Line 270: dbms_output.put_line('TRUE');

266:
267: IF po_shipments_sv2.val_ship_price(X_po_line_id,
268: X_shipment_type,
269: X_unit_price) THEN
270: dbms_output.put_line('TRUE');
271: ELSE
272: dbms_output.put_line('FALSE');
273: END IF;
274:

Line 272: dbms_output.put_line('FALSE');

268: X_shipment_type,
269: X_unit_price) THEN
270: dbms_output.put_line('TRUE');
271: ELSE
272: dbms_output.put_line('FALSE');
273: END IF;
274:
275: END test_val_ship_price;
276:

Line 303: dbms_output.put_line('before call');

299: X_need_to_approve number;
300:
301: BEGIN
302:
303: dbms_output.put_line('before call');
304:
305: X_need_to_approve := po_shipments_sv10.val_approval_status(
306: X_shipment_id ,
307: X_shipment_type ,

Line 326: dbms_output.put_line('TRUE');

322: NULL); --
323:
324: IF ((X_need_to_approve = 1) or
325: (X_need_to_approve = 2) ) THEN
326: dbms_output.put_line('TRUE');
327: ELSE
328: dbms_output.put_line('FALSE');
329: END IF;
330:

Line 328: dbms_output.put_line('FALSE');

324: IF ((X_need_to_approve = 1) or
325: (X_need_to_approve = 2) ) THEN
326: dbms_output.put_line('TRUE');
327: ELSE
328: dbms_output.put_line('FALSE');
329: END IF;
330:
331: END test_val_approval_status;
332:

Line 379: dbms_output.put_line('before call');

375: X_total_line_quantity NUMBER;
376:
377: BEGIN
378:
379: dbms_output.put_line('before call');
380:
381: po_shipments_sv5.val_source_line_num
382: (X_entity_level ,
383: X_po_line_id ,

Line 401: dbms_output.put_line('X_val_sched_released_qty = '||X_val_sched_released_qty);

397: X_receipt_required_flag ,
398: X_stock_enabled_flag ,
399: X_total_line_quantity );
400:
401: dbms_output.put_line('X_val_sched_released_qty = '||X_val_sched_released_qty);
402: dbms_output.put_line('X_item_id = '||X_item_id);
403: dbms_output.put_line('X_category_id = '||X_category_id);
404:
405:

Line 402: dbms_output.put_line('X_item_id = '||X_item_id);

398: X_stock_enabled_flag ,
399: X_total_line_quantity );
400:
401: dbms_output.put_line('X_val_sched_released_qty = '||X_val_sched_released_qty);
402: dbms_output.put_line('X_item_id = '||X_item_id);
403: dbms_output.put_line('X_category_id = '||X_category_id);
404:
405:
406: END test_source_line_server_cover;

Line 403: dbms_output.put_line('X_category_id = '||X_category_id);

399: X_total_line_quantity );
400:
401: dbms_output.put_line('X_val_sched_released_qty = '||X_val_sched_released_qty);
402: dbms_output.put_line('X_item_id = '||X_item_id);
403: dbms_output.put_line('X_category_id = '||X_category_id);
404:
405:
406: END test_source_line_server_cover;
407:

Line 420: dbms_output.put_line('Before_call');

416: X_po_header_id IN NUMBER) IS
417:
418: BEGIN
419:
420: dbms_output.put_line('Before_call');
421:
422: /* IF po_rfqqt_s.val_start_dates(X_start_date, X_po_header_id) THEN
423: dbms_output.put_line('Return TRUE');
424: ELSE

Line 423: dbms_output.put_line('Return TRUE');

419:
420: dbms_output.put_line('Before_call');
421:
422: /* IF po_rfqqt_s.val_start_dates(X_start_date, X_po_header_id) THEN
423: dbms_output.put_line('Return TRUE');
424: ELSE
425: dbms_output.put_line('Return FALSE');
426: END IF;*/
427:

Line 425: dbms_output.put_line('Return FALSE');

421:
422: /* IF po_rfqqt_s.val_start_dates(X_start_date, X_po_header_id) THEN
423: dbms_output.put_line('Return TRUE');
424: ELSE
425: dbms_output.put_line('Return FALSE');
426: END IF;*/
427:
428: /* There is no server pkg by the name po_rfqqt_s. */
429: null;

Line 447: dbms_output.put_line('Before_call');

443: X_po_header_id IN NUMBER) IS
444:
445: BEGIN
446:
447: dbms_output.put_line('Before_call');
448:
449: /* IF po_rfqqt_s.val_end_dates(X_end_date, X_po_header_id) THEN
450: dbms_output.put_line('Return TRUE');
451: ELSE

Line 450: dbms_output.put_line('Return TRUE');

446:
447: dbms_output.put_line('Before_call');
448:
449: /* IF po_rfqqt_s.val_end_dates(X_end_date, X_po_header_id) THEN
450: dbms_output.put_line('Return TRUE');
451: ELSE
452: dbms_output.put_line('Return FALSE');
453: END IF;*/
454:

Line 452: dbms_output.put_line('Return FALSE');

448:
449: /* IF po_rfqqt_s.val_end_dates(X_end_date, X_po_header_id) THEN
450: dbms_output.put_line('Return TRUE');
451: ELSE
452: dbms_output.put_line('Return FALSE');
453: END IF;*/
454:
455: /* There is no server pkg by the name po_rfqqt_s. */
456: null;