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.AHL_OSP_RCV_PVT dependencies on FND_API

Line 63: -- It returns FND_API.G_TRUE if a receipt can be done. Otherwise, it returns FND_API.G_FALSE.

59: -- Start of Comments --
60: -- Function name : Can_Receive_Against_OSP
61: -- Type : Public
62: -- Functionality : Function to determine if an OSP Order is 'ready for receipt'.
63: -- It returns FND_API.G_TRUE if a receipt can be done. Otherwise, it returns FND_API.G_FALSE.
64: -- Pre-reqs :
65: --
66: -- Parameters:
67: --

Line 116: -- Check for the given OSP order id. If NULL, return FND_API.G_FALSE.

112: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
113: FND_LOG.string(FND_LOG.level_procedure, l_debug_key||'.begin', 'API called with p_osp_order_id: '||p_osp_order_id);
114: END IF;
115:
116: -- Check for the given OSP order id. If NULL, return FND_API.G_FALSE.
117: IF (p_osp_order_id IS NULL) THEN
118: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
119: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
120: 'OSP order id is NULL. Returning False.');

Line 123: RETURN FND_API.G_FALSE;

119: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
120: 'OSP order id is NULL. Returning False.');
121: END IF;
122:
123: RETURN FND_API.G_FALSE;
124: END IF;
125:
126: -- Get the shipment header id, i.e. oe_header_id, for the given OSP order id.
127: OPEN get_oe_header_id(p_osp_order_id);

Line 131: -- Check for the oe_header_id. If NULL, it means no shipment has been created. Return FND_API.G_FALSE.

127: OPEN get_oe_header_id(p_osp_order_id);
128: FETCH get_oe_header_id INTO l_oe_header_id;
129: CLOSE get_oe_header_id;
130:
131: -- Check for the oe_header_id. If NULL, it means no shipment has been created. Return FND_API.G_FALSE.
132: IF (l_oe_header_id IS NULL) THEN
133: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
134: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
135: 'oe_header_id is NULL for the OSP order: '||p_osp_order_id||'. Returning False.');

Line 138: RETURN FND_API.G_FALSE;

134: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
135: 'oe_header_id is NULL for the OSP order: '||p_osp_order_id||'. Returning False.');
136: END IF;
137:
138: RETURN FND_API.G_FALSE;
139: END IF;
140:
141: -- Check whether the shipment, i.e. oe_header_id is booked or not.
142: OPEN chk_shipment_booked(l_oe_header_id);

Line 145: -- The shipment is not booked. Return FND_API.G_FALSE.

141: -- Check whether the shipment, i.e. oe_header_id is booked or not.
142: OPEN chk_shipment_booked(l_oe_header_id);
143: FETCH chk_shipment_booked INTO l_dummy;
144: IF (chk_shipment_booked%NOTFOUND) THEN
145: -- The shipment is not booked. Return FND_API.G_FALSE.
146: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
147: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
148: 'Shipment '||l_oe_header_id||' is not booked. Returning False.');
149: END IF;

Line 152: RETURN FND_API.G_FALSE;

148: 'Shipment '||l_oe_header_id||' is not booked. Returning False.');
149: END IF;
150:
151: CLOSE chk_shipment_booked;
152: RETURN FND_API.G_FALSE;
153: END IF;
154: CLOSE chk_shipment_booked;
155:
156: -- For a booked shipment, get all the RMA type lines.

Line 163: IF (Can_Receive_Against_RMA(l_oe_line_id) = FND_API.G_TRUE) THEN

159: FETCH get_rma_lines INTO l_oe_line_id;
160: EXIT WHEN get_rma_lines%NOTFOUND;
161:
162: -- Check whether the receipt can be done against the RMA line id or not.
163: IF (Can_Receive_Against_RMA(l_oe_line_id) = FND_API.G_TRUE) THEN
164: -- Receipt against RMA can be done for this line. Return FND_API.G_TRUE.
165: CLOSE get_rma_lines;
166: RETURN FND_API.G_TRUE;
167: ELSIF (Can_Receive_Against_PO(l_oe_line_id) = FND_API.G_TRUE) THEN

Line 164: -- Receipt against RMA can be done for this line. Return FND_API.G_TRUE.

160: EXIT WHEN get_rma_lines%NOTFOUND;
161:
162: -- Check whether the receipt can be done against the RMA line id or not.
163: IF (Can_Receive_Against_RMA(l_oe_line_id) = FND_API.G_TRUE) THEN
164: -- Receipt against RMA can be done for this line. Return FND_API.G_TRUE.
165: CLOSE get_rma_lines;
166: RETURN FND_API.G_TRUE;
167: ELSIF (Can_Receive_Against_PO(l_oe_line_id) = FND_API.G_TRUE) THEN
168: -- Receipt against PO can be done for this line. Return FND_API.G_TRUE.

Line 166: RETURN FND_API.G_TRUE;

162: -- Check whether the receipt can be done against the RMA line id or not.
163: IF (Can_Receive_Against_RMA(l_oe_line_id) = FND_API.G_TRUE) THEN
164: -- Receipt against RMA can be done for this line. Return FND_API.G_TRUE.
165: CLOSE get_rma_lines;
166: RETURN FND_API.G_TRUE;
167: ELSIF (Can_Receive_Against_PO(l_oe_line_id) = FND_API.G_TRUE) THEN
168: -- Receipt against PO can be done for this line. Return FND_API.G_TRUE.
169: CLOSE get_rma_lines;
170: RETURN FND_API.G_TRUE;

Line 167: ELSIF (Can_Receive_Against_PO(l_oe_line_id) = FND_API.G_TRUE) THEN

163: IF (Can_Receive_Against_RMA(l_oe_line_id) = FND_API.G_TRUE) THEN
164: -- Receipt against RMA can be done for this line. Return FND_API.G_TRUE.
165: CLOSE get_rma_lines;
166: RETURN FND_API.G_TRUE;
167: ELSIF (Can_Receive_Against_PO(l_oe_line_id) = FND_API.G_TRUE) THEN
168: -- Receipt against PO can be done for this line. Return FND_API.G_TRUE.
169: CLOSE get_rma_lines;
170: RETURN FND_API.G_TRUE;
171: END IF;

Line 168: -- Receipt against PO can be done for this line. Return FND_API.G_TRUE.

164: -- Receipt against RMA can be done for this line. Return FND_API.G_TRUE.
165: CLOSE get_rma_lines;
166: RETURN FND_API.G_TRUE;
167: ELSIF (Can_Receive_Against_PO(l_oe_line_id) = FND_API.G_TRUE) THEN
168: -- Receipt against PO can be done for this line. Return FND_API.G_TRUE.
169: CLOSE get_rma_lines;
170: RETURN FND_API.G_TRUE;
171: END IF;
172: END LOOP;

Line 170: RETURN FND_API.G_TRUE;

166: RETURN FND_API.G_TRUE;
167: ELSIF (Can_Receive_Against_PO(l_oe_line_id) = FND_API.G_TRUE) THEN
168: -- Receipt against PO can be done for this line. Return FND_API.G_TRUE.
169: CLOSE get_rma_lines;
170: RETURN FND_API.G_TRUE;
171: END IF;
172: END LOOP;
173: CLOSE get_rma_lines;
174:

Line 175: -- If none of the shipment/PO lines can be received, return FND_API.G_FALSE.

171: END IF;
172: END LOOP;
173: CLOSE get_rma_lines;
174:
175: -- If none of the shipment/PO lines can be received, return FND_API.G_FALSE.
176: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
177: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
178: 'None of the shipment/PO lines can be received. Returnig False.');
179: END IF;

Line 181: RETURN FND_API.G_FALSE;

177: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
178: 'None of the shipment/PO lines can be received. Returnig False.');
179: END IF;
180:
181: RETURN FND_API.G_FALSE;
182: END Can_Receive_Against_OSP;
183:
184:
185: -- Start of Comments --

Line 189: -- It returns FND_API.G_TRUE if a receipt can be done. Otherwise, it returns FND_API.G_FALSE.

185: -- Start of Comments --
186: -- Function name : Can_Receive_Against_PO
187: -- Type : Public
188: -- Functionality : Function to determine if a receipt against PO can be done given an RMA line.
189: -- It returns FND_API.G_TRUE if a receipt can be done. Otherwise, it returns FND_API.G_FALSE.
190: -- Pre-reqs :
191: --
192: -- Parameters:
193: --

Line 340: -- The given return line is invalid. Return FND_API.G_FALSE.

336: -- Check whether the given return line is valid or not.
337: OPEN chk_return_line(p_return_line_id);
338: FETCH chk_return_line INTO l_dummy;
339: IF (chk_return_line%NOTFOUND) THEN
340: -- The given return line is invalid. Return FND_API.G_FALSE.
341: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
342: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
343: 'Return line: '||p_return_line_id||' is invalid. Returnig False.');
344: END IF;

Line 347: RETURN FND_API.G_FALSE;

343: 'Return line: '||p_return_line_id||' is invalid. Returnig False.');
344: END IF;
345:
346: CLOSE chk_return_line;
347: RETURN FND_API.G_FALSE;
348: END IF;
349: CLOSE chk_return_line;
350:
351: -- SATHAPLI::Bug 6877509 - changes start, 02-Apr-08

Line 366: -- ordered quantity, then it means there is still quantity left to be returned. Return FND_API.G_FALSE.

362: -- SATHAPLI::Bug 6877509 - changes end, 02-Apr-08
363:
364: -- PO receipt should be enabled only after RMA receipt is complete. For this, check for the ordered and
365: -- shipped quantities of the given return line. If the shipped quantity is less than the
366: -- ordered quantity, then it means there is still quantity left to be returned. Return FND_API.G_FALSE.
367: IF (l_oe_shipped_qty IS NULL OR l_oe_shipped_qty < l_oe_ordered_qty) THEN
368: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
369: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
370: 'Shipped quantity is NULL, or less than the ordered quantity for the return line: '||p_return_line_id||

Line 374: RETURN FND_API.G_FALSE;

370: 'Shipped quantity is NULL, or less than the ordered quantity for the return line: '||p_return_line_id||
371: '. As receipt against RMA is not complete yet, returning False.');
372: END IF;
373:
374: RETURN FND_API.G_FALSE;
375: END IF;
376:
377: -- Get the PO header id for the OSP order corresponding to the given return line id.
378: OPEN get_po_header_id(p_return_line_id);

Line 384: -- Even the requisition header id is NULL. Return FND_API.G_FALSE.

380: IF (get_po_header_id%FOUND) THEN
381: IF (l_po_header_id IS NULL) THEN
382: -- As the PO header id is NULL, check for the requisition header id.
383: IF (l_po_req_header_id IS NULL) THEN
384: -- Even the requisition header id is NULL. Return FND_API.G_FALSE.
385: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
386: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
387: 'Both PO and requisition headers are NULL for the OSP order: '||l_osp_order_id||
388: '. Returning False.');

Line 392: RETURN FND_API.G_FALSE;

388: '. Returning False.');
389: END IF;
390:
391: CLOSE get_po_header_id;
392: RETURN FND_API.G_FALSE;
393: ELSE
394: -- Check whether the Requisition is approved or not.
395: -- If not approved, return FND_API.G_FALSE.
396: OPEN chk_po_req_approved(l_po_req_header_id);

Line 395: -- If not approved, return FND_API.G_FALSE.

391: CLOSE get_po_header_id;
392: RETURN FND_API.G_FALSE;
393: ELSE
394: -- Check whether the Requisition is approved or not.
395: -- If not approved, return FND_API.G_FALSE.
396: OPEN chk_po_req_approved(l_po_req_header_id);
397: FETCH chk_po_req_approved INTO l_dummy;
398: IF (chk_po_req_approved%NOTFOUND) THEN
399: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 406: RETURN FND_API.G_FALSE;

402: END IF;
403:
404: CLOSE chk_po_req_approved;
405: CLOSE get_po_header_id;
406: RETURN FND_API.G_FALSE;
407: END IF;
408: CLOSE chk_po_req_approved;
409: END IF; -- if l_po_req_header_id IS NULL
410: ELSE

Line 412: -- If not approved, return FND_API.G_FALSE.

408: CLOSE chk_po_req_approved;
409: END IF; -- if l_po_req_header_id IS NULL
410: ELSE
411: -- Check whether the Purchase order is approved or not.
412: -- If not approved, return FND_API.G_FALSE.
413: OPEN chk_po_header_approved(l_po_header_id);
414: FETCH chk_po_header_approved INTO l_dummy;
415: IF (chk_po_header_approved%NOTFOUND) THEN
416: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 423: RETURN FND_API.G_FALSE;

419: END IF;
420:
421: CLOSE chk_po_header_approved;
422: CLOSE get_po_header_id;
423: RETURN FND_API.G_FALSE;
424: END IF;
425: CLOSE chk_po_header_approved;
426: END IF; -- if l_po_header_id IS NULL
427: ELSE

Line 428: -- This means that the OSP order is not in the PO_CREATED or REQ_CREATED status. Return FND_API.G_FALSE.

424: END IF;
425: CLOSE chk_po_header_approved;
426: END IF; -- if l_po_header_id IS NULL
427: ELSE
428: -- This means that the OSP order is not in the PO_CREATED or REQ_CREATED status. Return FND_API.G_FALSE.
429: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
430: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
431: 'OSP order: '||l_osp_order_id||' is not in status PO_CREATED or REQ_CREATED. Returnig False.');
432: END IF;

Line 435: RETURN FND_API.G_FALSE;

431: 'OSP order: '||l_osp_order_id||' is not in status PO_CREATED or REQ_CREATED. Returnig False.');
432: END IF;
433:
434: CLOSE get_po_header_id;
435: RETURN FND_API.G_FALSE;
436: END IF; -- if get_po_header_id%FOUND
437: CLOSE get_po_header_id;
438:
439: -- After the OSP order and Purchase order or Requisition checks above, check for the PO line quantity for each OSP order line.

Line 477: RETURN FND_API.G_FALSE;

473: END IF;
474:
475: CLOSE get_po_line;
476: CLOSE get_po_line_quantity1;
477: RETURN FND_API.G_FALSE;
478: END IF; -- if get_po_line%FOUND
479: CLOSE get_po_line;
480: END IF;
481:

Line 482: -- For any of the PO lines, if the total received quantity is not less than the line quantity, return FND_API.G_FALSE.

478: END IF; -- if get_po_line%FOUND
479: CLOSE get_po_line;
480: END IF;
481:
482: -- For any of the PO lines, if the total received quantity is not less than the line quantity, return FND_API.G_FALSE.
483: -- No need to check this for merged Requisition lines, this check would already have happened for the first Requisition line.
484: IF NOT l_merged_req_line AND NOT (l_po_line_tot_qty < l_po_line_qty) THEN
485: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
486: FND_LOG.string(FND_LOG.level_statement, l_debug_key,

Line 492: RETURN FND_API.G_FALSE;

488: ' Returning False.');
489: END IF;
490:
491: CLOSE get_po_line_quantity1;
492: RETURN FND_API.G_FALSE;
493: END IF;
494: END LOOP;
495: CLOSE get_po_line_quantity1;
496:

Line 497: -- If all the checks have been validated, return FND_API.G_TRUE.

493: END IF;
494: END LOOP;
495: CLOSE get_po_line_quantity1;
496:
497: -- If all the checks have been validated, return FND_API.G_TRUE.
498: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
499: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
500: 'All checks validated. Returnig True.');
501: END IF;

Line 503: RETURN FND_API.G_TRUE;

499: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
500: 'All checks validated. Returnig True.');
501: END IF;
502:
503: RETURN FND_API.G_TRUE;
504: END Can_Receive_Against_PO;
505:
506:
507: -- Start of Comments --

Line 511: -- It returns FND_API.G_TRUE if a receipt can be done. Otherwise, it returns FND_API.G_FALSE.

507: -- Start of Comments --
508: -- Function name : Can_Receive_Against_RMA
509: -- Type : Public
510: -- Functionality : Function to determine if a receipt can be done against a given RMA line.
511: -- It returns FND_API.G_TRUE if a receipt can be done. Otherwise, it returns FND_API.G_FALSE.
512: -- Pre-reqs :
513: --
514: -- Parameters:
515: --

Line 577: -- The given return line is invalid. Return FND_API.G_FALSE.

573: -- Check whether the given return line is valid or not.
574: OPEN chk_return_line(p_return_line_id);
575: FETCH chk_return_line INTO l_dummy;
576: IF (chk_return_line%NOTFOUND) THEN
577: -- The given return line is invalid. Return FND_API.G_FALSE.
578: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
579: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
580: 'Return line: '||p_return_line_id||' is invalid. Returnig False.');
581: END IF;

Line 584: RETURN FND_API.G_FALSE;

580: 'Return line: '||p_return_line_id||' is invalid. Returnig False.');
581: END IF;
582:
583: CLOSE chk_return_line;
584: RETURN FND_API.G_FALSE;
585: END IF;
586: CLOSE chk_return_line;
587:
588: -- Check whether the shipment is booked or not.

Line 592: -- The shipment is not booked. Return FND_API.G_FALSE.

588: -- Check whether the shipment is booked or not.
589: OPEN chk_shipment_booked(p_return_line_id);
590: FETCH chk_shipment_booked INTO l_oe_header_id;
591: IF (chk_shipment_booked%NOTFOUND) THEN
592: -- The shipment is not booked. Return FND_API.G_FALSE.
593: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
594: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
595: 'Shipment order: '||l_oe_header_id||' is not booked. Returnig False.');
596: END IF;

Line 599: RETURN FND_API.G_FALSE;

595: 'Shipment order: '||l_oe_header_id||' is not booked. Returnig False.');
596: END IF;
597:
598: CLOSE chk_shipment_booked;
599: RETURN FND_API.G_FALSE;
600: END IF;
601: CLOSE chk_shipment_booked;
602:
603:

Line 608: -- If the ship line id is NULL, return FND_API.G_FALSE.

604: -- Get the ship line id of the OSP order lines, that correspond to the given return line.
605: OPEN get_osp_ship_line_id(p_return_line_id);
606: FETCH get_osp_ship_line_id INTO l_oe_ship_line_id;
607: IF (get_osp_ship_line_id%FOUND) THEN
608: -- If the ship line id is NULL, return FND_API.G_FALSE.
609: IF (l_oe_ship_line_id IS NULL) THEN
610: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
611: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
612: 'Ship line id for the return line: '||p_return_line_id||' is NULL. Returning False.');

Line 616: RETURN FND_API.G_FALSE;

612: 'Ship line id for the return line: '||p_return_line_id||' is NULL. Returning False.');
613: END IF;
614:
615: CLOSE get_osp_ship_line_id;
616: RETURN FND_API.G_FALSE;
617: ELSE
618: -- Get the ordered and shipped quantities of the ship line.
619: OPEN get_oe_quantities(l_oe_ship_line_id);
620: FETCH get_oe_quantities INTO l_ship_line_qty_rec;

Line 629: -- If the shipped quantity is NULL or zero, it means shipment hasn't been done yet. Return FND_API.G_FALSE.

625: FND_LOG.string(FND_LOG.level_statement, l_debug_key, 'l_ship_line_qty_rec.shipped_quantity: '||l_ship_line_qty_rec .shipped_quantity);
626: END IF;
627:
628: -- Shipment should have been done for any receipt to take place. For this, check the shipped quantity.
629: -- If the shipped quantity is NULL or zero, it means shipment hasn't been done yet. Return FND_API.G_FALSE.
630: IF (l_ship_line_qty_rec.shipped_quantity IS NULL OR l_ship_line_qty_rec.shipped_quantity = 0) THEN
631: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
632: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
633: 'Shipment for the return line: '||p_return_line_id||' has not been done yet. Returning False.');

Line 637: RETURN FND_API.G_FALSE;

633: 'Shipment for the return line: '||p_return_line_id||' has not been done yet. Returning False.');
634: END IF;
635:
636: CLOSE get_osp_ship_line_id;
637: RETURN FND_API.G_FALSE;
638: END IF;
639: END IF;
640: END IF;
641: CLOSE get_osp_ship_line_id;

Line 649: -- ordered quantity, then it means there is no quantity left to be returned. Return FND_API.G_FALSE.

645: FETCH get_oe_quantities INTO l_return_line_qty_rec;
646: CLOSE get_oe_quantities;
647:
648: -- Check for the ordered and shipped quantities of the given return line. If the shipped quantity is not less than the
649: -- ordered quantity, then it means there is no quantity left to be returned. Return FND_API.G_FALSE.
650: IF NOT (nvl(l_return_line_qty_rec.shipped_quantity,0) < l_return_line_qty_rec.ordered_quantity) THEN
651: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
652: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
653: 'Shipped quantity is not less than the ordered quantity for the return line: '||p_return_line_id||'.'||

Line 657: RETURN FND_API.G_FALSE;

653: 'Shipped quantity is not less than the ordered quantity for the return line: '||p_return_line_id||'.'||
654: ' Returning False.');
655: END IF;
656:
657: RETURN FND_API.G_FALSE;
658: END IF;
659:
660: -- If all the checks have been validated, return FND_API.G_TRUE.
661: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 660: -- If all the checks have been validated, return FND_API.G_TRUE.

656:
657: RETURN FND_API.G_FALSE;
658: END IF;
659:
660: -- If all the checks have been validated, return FND_API.G_TRUE.
661: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
662: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
663: 'All checks validated. Returnig True.');
664: END IF;

Line 666: RETURN FND_API.G_TRUE;

662: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
663: 'All checks validated. Returnig True.');
664: END IF;
665:
666: RETURN FND_API.G_TRUE;
667: END Can_Receive_Against_RMA;
668:
669:
670: -- Start of Comments --

Line 680: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

676: -- Parameters:
677: --
678: -- Standard IN Parameters:
679: -- p_api_version IN NUMBER Required
680: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
681: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
682: -- p_validation_level IN NUMBER Required
683: -- p_module_type IN VARCHAR2 Default NULL
684: --

Line 681: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

677: --
678: -- Standard IN Parameters:
679: -- p_api_version IN NUMBER Required
680: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
681: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
682: -- p_validation_level IN NUMBER Required
683: -- p_module_type IN VARCHAR2 Default NULL
684: --
685: -- Standard OUT Parameters:

Line 702: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

698: -- End of Comments --
699:
700: PROCEDURE Receive_Against_PO (
701: p_api_version IN NUMBER,
702: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
703: p_commit IN VARCHAR2 := FND_API.G_FALSE,
704: p_validation_level IN NUMBER,
705: p_module_type IN VARCHAR2 := NULL,
706: x_return_status OUT NOCOPY VARCHAR2,

Line 703: p_commit IN VARCHAR2 := FND_API.G_FALSE,

699:
700: PROCEDURE Receive_Against_PO (
701: p_api_version IN NUMBER,
702: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
703: p_commit IN VARCHAR2 := FND_API.G_FALSE,
704: p_validation_level IN NUMBER,
705: p_module_type IN VARCHAR2 := NULL,
706: x_return_status OUT NOCOPY VARCHAR2,
707: x_msg_count OUT NOCOPY NUMBER,

Line 841: x_return_status := FND_API.G_RET_STS_SUCCESS;

837: -- Standard start of API savepoint.
838: SAVEPOINT Receive_Against_PO_Pvt;
839:
840: -- Initialize Procedure return status to success.
841: x_return_status := FND_API.G_RET_STS_SUCCESS;
842:
843: -- Standard call to check for call compatibility.
844: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
845: l_api_name, G_PKG_NAME) THEN

Line 844: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

840: -- Initialize Procedure return status to success.
841: x_return_status := FND_API.G_RET_STS_SUCCESS;
842:
843: -- Standard call to check for call compatibility.
844: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
845: l_api_name, G_PKG_NAME) THEN
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: END IF;
848:

Line 846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

842:
843: -- Standard call to check for call compatibility.
844: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
845: l_api_name, G_PKG_NAME) THEN
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: END IF;
848:
849: -- Initialize message list if p_init_msg_list is set to TRUE.
850: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 850: IF FND_API.To_Boolean(p_init_msg_list) THEN

846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: END IF;
848:
849: -- Initialize message list if p_init_msg_list is set to TRUE.
850: IF FND_API.To_Boolean(p_init_msg_list) THEN
851: FND_MSG_PUB.Initialize;
852: END IF;
853:
854: -- Get the PO header id for the OSP order corresponding to the given return line id.

Line 871: RAISE FND_API.G_EXC_ERROR;

867:
868: CLOSE get_po_header_id;
869: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PO_REQ_NULL'); -- Receipt cannot be done as neither the purchase order nor the requisition exist for this OSP order.
870: FND_MSG_PUB.ADD;
871: RAISE FND_API.G_EXC_ERROR;
872: ELSE
873: -- Check whether the Requisition is approved or not.
874: -- If not approved, raise an exception.
875: OPEN chk_po_req_approved(l_po_req_header_id);

Line 887: RAISE FND_API.G_EXC_ERROR;

883: CLOSE chk_po_req_approved;
884: CLOSE get_po_header_id;
885: FND_MESSAGE.set_name('AHL', 'AHL_OSP_REQ_NOT_APRVD'); -- Receipt cannot be done as the requisition is not approved.
886: FND_MSG_PUB.ADD;
887: RAISE FND_API.G_EXC_ERROR;
888: END IF;
889: CLOSE chk_po_req_approved;
890: END IF; -- if l_po_req_header_id IS NULL
891: ELSE

Line 905: RAISE FND_API.G_EXC_ERROR;

901: CLOSE get_po_header_details1;
902: CLOSE get_po_header_id;
903: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PO_NOT_APRVD'); -- Receipt cannot be done as the purchase order is not approved.
904: FND_MSG_PUB.ADD;
905: RAISE FND_API.G_EXC_ERROR;
906: END IF;
907: CLOSE get_po_header_details1;
908: END IF; -- if l_po_header_id IS NULL
909: ELSE

Line 920: RAISE FND_API.G_EXC_ERROR;

916: CLOSE get_po_header_id;
917: FND_MESSAGE.set_name('AHL', 'AHL_OSP_ORDER_INVALID'); -- The status of the OSP order (ORDER_NUM) is not valid for receiving.
918: FND_MESSAGE.set_token('ORDER_NUM', l_osp_order_number);
919: FND_MSG_PUB.ADD;
920: RAISE FND_API.G_EXC_ERROR;
921: END IF; -- if get_po_header_id%FOUND
922: CLOSE get_po_header_id;
923:
924: -- Get the PO line quantity and the total received quantity.

Line 969: RAISE FND_API.G_EXC_ERROR;

965: CLOSE get_po_line;
966: CLOSE get_po_line_quantity1;
967: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PO_NULL_OR_INVLD'); -- Either the purchase order is not created or it is not approved.
968: FND_MSG_PUB.ADD;
969: RAISE FND_API.G_EXC_ERROR;
970: END IF; -- if get_po_line%FOUND
971: CLOSE get_po_line;
972: END IF;
973:

Line 1001: RAISE FND_API.G_EXC_ERROR;

997: CLOSE chk_pending_transaction;
998: CLOSE get_po_line_quantity1;
999: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PO_PENDING_TRNSCTN'); -- Some of the purchase order lines for this return line have pending transactions.
1000: FND_MSG_PUB.ADD;
1001: RAISE FND_API.G_EXC_ERROR;
1002: END IF;
1003: CLOSE chk_pending_transaction;
1004:
1005: -- Insert a record in RCV_HEADERS_INTERFACE table as a header of these PO lines.

Line 1123: RAISE FND_API.G_EXC_ERROR;

1119: END IF;
1120:
1121: FND_MESSAGE.set_name('AHL', 'AHL_OSP_ALL_PO_LINES_RCVD'); -- All the purchase order lines for this return line have been received.
1122: FND_MSG_PUB.ADD;
1123: RAISE FND_API.G_EXC_ERROR;
1124: END IF;
1125:
1126: -- After the interface tables been populated above, submit request for calling the Concurrent Program 'RVCTP'.
1127: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 1163: p_encoded => FND_API.G_FALSE

1159: -- Standard call to get message count and initialise the OUT parameters.
1160: FND_MSG_PUB.Count_And_Get
1161: ( p_count => x_msg_count,
1162: p_data => x_msg_data,
1163: p_encoded => FND_API.G_FALSE
1164: );
1165:
1166: -- Commit work if p_commit is TRUE.
1167: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 1167: IF FND_API.TO_BOOLEAN(p_commit) THEN

1163: p_encoded => FND_API.G_FALSE
1164: );
1165:
1166: -- Commit work if p_commit is TRUE.
1167: IF FND_API.TO_BOOLEAN(p_commit) THEN
1168: COMMIT WORK;
1169: END IF;
1170:
1171: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 1175: WHEN FND_API.G_EXC_ERROR THEN

1171: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1172: FND_LOG.string(FND_LOG.level_procedure, l_debug_key||'.end', 'End of the API. x_request_id: '||x_request_id);
1173: END IF;
1174: EXCEPTION
1175: WHEN FND_API.G_EXC_ERROR THEN
1176: ROLLBACK TO Receive_Against_PO_Pvt;
1177: x_return_status := FND_API.G_RET_STS_ERROR;
1178: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1179: p_data => x_msg_data,

Line 1177: x_return_status := FND_API.G_RET_STS_ERROR;

1173: END IF;
1174: EXCEPTION
1175: WHEN FND_API.G_EXC_ERROR THEN
1176: ROLLBACK TO Receive_Against_PO_Pvt;
1177: x_return_status := FND_API.G_RET_STS_ERROR;
1178: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1179: p_data => x_msg_data,
1180: p_encoded => FND_API.G_FALSE);
1181:

Line 1180: p_encoded => FND_API.G_FALSE);

1176: ROLLBACK TO Receive_Against_PO_Pvt;
1177: x_return_status := FND_API.G_RET_STS_ERROR;
1178: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1179: p_data => x_msg_data,
1180: p_encoded => FND_API.G_FALSE);
1181:
1182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1183: ROLLBACK TO Receive_Against_PO_Pvt;
1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1178: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1179: p_data => x_msg_data,
1180: p_encoded => FND_API.G_FALSE);
1181:
1182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1183: ROLLBACK TO Receive_Against_PO_Pvt;
1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1185: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1186: p_data => x_msg_data,

Line 1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1180: p_encoded => FND_API.G_FALSE);
1181:
1182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1183: ROLLBACK TO Receive_Against_PO_Pvt;
1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1185: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1186: p_data => x_msg_data,
1187: p_encoded => FND_API.G_FALSE);
1188:

Line 1187: p_encoded => FND_API.G_FALSE);

1183: ROLLBACK TO Receive_Against_PO_Pvt;
1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1185: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1186: p_data => x_msg_data,
1187: p_encoded => FND_API.G_FALSE);
1188:
1189: WHEN OTHERS THEN
1190: ROLLBACK TO Receive_Against_PO_Pvt;
1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1187: p_encoded => FND_API.G_FALSE);
1188:
1189: WHEN OTHERS THEN
1190: ROLLBACK TO Receive_Against_PO_Pvt;
1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1192: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => G_PKG_NAME,
1193: p_procedure_name => l_api_name,
1194: p_error_text => SQLERRM);
1195:

Line 1198: p_encoded => FND_API.G_FALSE);

1194: p_error_text => SQLERRM);
1195:
1196: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1197: p_data => x_msg_data,
1198: p_encoded => FND_API.G_FALSE);
1199: END Receive_Against_PO;
1200:
1201:
1202: -- Start of Comments --

Line 1213: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

1209: -- Parameters:
1210: --
1211: -- Standard IN Parameters:
1212: -- p_api_version IN NUMBER Required
1213: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1214: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1215: -- p_validation_level IN NUMBER Required
1216: -- p_module_type IN VARCHAR2 Default NULL
1217: --

Line 1214: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

1210: --
1211: -- Standard IN Parameters:
1212: -- p_api_version IN NUMBER Required
1213: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1214: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
1215: -- p_validation_level IN NUMBER Required
1216: -- p_module_type IN VARCHAR2 Default NULL
1217: --
1218: -- Standard OUT Parameters:

Line 1236: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1232: -- End of Comments --
1233:
1234: PROCEDURE Receive_Against_RMA (
1235: p_api_version IN NUMBER,
1236: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1237: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1238: p_validation_level IN NUMBER,
1239: p_module_type IN VARCHAR2 := NULL,
1240: x_return_status OUT NOCOPY VARCHAR2,

Line 1237: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1233:
1234: PROCEDURE Receive_Against_RMA (
1235: p_api_version IN NUMBER,
1236: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1237: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1238: p_validation_level IN NUMBER,
1239: p_module_type IN VARCHAR2 := NULL,
1240: x_return_status OUT NOCOPY VARCHAR2,
1241: x_msg_count OUT NOCOPY NUMBER,

Line 1405: x_return_status := FND_API.G_RET_STS_SUCCESS;

1401: -- Standard start of API savepoint.
1402: SAVEPOINT Receive_Against_RMA_Pvt;
1403:
1404: -- Initialize Procedure return status to success.
1405: x_return_status := FND_API.G_RET_STS_SUCCESS;
1406:
1407: -- Standard call to check for call compatibility.
1408: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1409: l_api_name, G_PKG_NAME) THEN

Line 1408: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,

1404: -- Initialize Procedure return status to success.
1405: x_return_status := FND_API.G_RET_STS_SUCCESS;
1406:
1407: -- Standard call to check for call compatibility.
1408: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1409: l_api_name, G_PKG_NAME) THEN
1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1411: END IF;
1412:

Line 1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1406:
1407: -- Standard call to check for call compatibility.
1408: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
1409: l_api_name, G_PKG_NAME) THEN
1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1411: END IF;
1412:
1413: -- Initialize message list if p_init_msg_list is set to TRUE.
1414: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1414: IF FND_API.To_Boolean(p_init_msg_list) THEN

1410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1411: END IF;
1412:
1413: -- Initialize message list if p_init_msg_list is set to TRUE.
1414: IF FND_API.To_Boolean(p_init_msg_list) THEN
1415: FND_MSG_PUB.Initialize;
1416: END IF;
1417:
1418: x_return_line_id := null;

Line 1449: RAISE FND_API.G_EXC_ERROR;

1445: END IF;
1446: CLOSE chk_pending_transaction;
1447: FND_MESSAGE.set_name('AHL', 'AHL_OSP_OE_TRANS_PENDING'); -- The return line has pending transactions.
1448: FND_MSG_PUB.ADD;
1449: RAISE FND_API.G_EXC_ERROR;
1450: END IF;
1451: CLOSE chk_pending_transaction;
1452:
1453: /* Validate the input parameters. This api will throw any validation errors */

Line 1522: p_init_msg_list => FND_API.G_FALSE,

1518:
1519: AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change
1520: (
1521: p_api_version => 1.0,
1522: p_init_msg_list => FND_API.G_FALSE,
1523: p_commit => FND_API.G_FALSE,
1524: p_serialnum_change_rec => l_serialnum_change_rec,
1525: x_return_status => l_return_status,
1526: x_msg_count => l_msg_count,

Line 1523: p_commit => FND_API.G_FALSE,

1519: AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change
1520: (
1521: p_api_version => 1.0,
1522: p_init_msg_list => FND_API.G_FALSE,
1523: p_commit => FND_API.G_FALSE,
1524: p_serialnum_change_rec => l_serialnum_change_rec,
1525: x_return_status => l_return_status,
1526: x_msg_count => l_msg_count,
1527: x_msg_data => l_msg_data

Line 1535: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'After calling AHL_OSP_SHIPMENT_PUB.Process_Osp_SerialNum_Change');
1532: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'l_return_status: '||l_return_status);
1533: END IF;
1534:
1535: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1536: RAISE FND_API.G_EXC_ERROR;
1537: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1539: END IF;

Line 1536: RAISE FND_API.G_EXC_ERROR;

1532: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'l_return_status: '||l_return_status);
1533: END IF;
1534:
1535: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1536: RAISE FND_API.G_EXC_ERROR;
1537: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1539: END IF;
1540: --Retrieve the new return line id

Line 1537: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1533: END IF;
1534:
1535: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1536: RAISE FND_API.G_EXC_ERROR;
1537: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1539: END IF;
1540: --Retrieve the new return line id
1541: OPEN get_oe_line_id(l_osp_line_id);

Line 1538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1534:
1535: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1536: RAISE FND_API.G_EXC_ERROR;
1537: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1539: END IF;
1540: --Retrieve the new return line id
1541: OPEN get_oe_line_id(l_osp_line_id);
1542: FETCH get_oe_line_id INTO l_new_oe_line_id;

Line 1555: RAISE FND_API.G_EXC_ERROR;

1551: ELSE
1552: --Part number change cannot be performed for the return line.
1553: FND_MESSAGE.Set_Name('AHL','AHL_OSP_CHG_OSPL_INV');
1554: FND_MSG_PUB.ADD;
1555: RAISE FND_API.G_EXC_ERROR;
1556: END IF;
1557:
1558: ELSIF (l_exchange_flag) THEN
1559: --Exchange is being performed for the return line

Line 1581: p_init_msg_list => FND_API.G_FALSE,

1577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Before calling AHL_OSP_ORDERS_PVT.process_osp_order for order conversion');
1578: END IF;
1579: AHL_OSP_ORDERS_PVT.process_osp_order(
1580: p_api_version => 1.0,
1581: p_init_msg_list => FND_API.G_FALSE,
1582: p_commit => FND_API.G_FALSE,
1583: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1584: p_module_type => NULL,
1585: p_x_osp_order_rec => l_osp_order_rec,

Line 1582: p_commit => FND_API.G_FALSE,

1578: END IF;
1579: AHL_OSP_ORDERS_PVT.process_osp_order(
1580: p_api_version => 1.0,
1581: p_init_msg_list => FND_API.G_FALSE,
1582: p_commit => FND_API.G_FALSE,
1583: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1584: p_module_type => NULL,
1585: p_x_osp_order_rec => l_osp_order_rec,
1586: p_x_osp_order_lines_tbl => l_osp_order_lines_tbl,

Line 1583: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1579: AHL_OSP_ORDERS_PVT.process_osp_order(
1580: p_api_version => 1.0,
1581: p_init_msg_list => FND_API.G_FALSE,
1582: p_commit => FND_API.G_FALSE,
1583: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1584: p_module_type => NULL,
1585: p_x_osp_order_rec => l_osp_order_rec,
1586: p_x_osp_order_lines_tbl => l_osp_order_lines_tbl,
1587: x_return_status => l_return_status,

Line 1596: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1592: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'After calling AHL_OSP_ORDERS_PVT.process_osp_order for order conversion');
1593: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'l_return_status: '||l_return_status);
1594: END IF;
1595:
1596: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1597: RAISE FND_API.G_EXC_ERROR;
1598: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1600: END IF;

Line 1597: RAISE FND_API.G_EXC_ERROR;

1593: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'l_return_status: '||l_return_status);
1594: END IF;
1595:
1596: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1597: RAISE FND_API.G_EXC_ERROR;
1598: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1600: END IF;
1601: l_rma_line_canceled := true;

Line 1598: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1594: END IF;
1595:
1596: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1597: RAISE FND_API.G_EXC_ERROR;
1598: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1600: END IF;
1601: l_rma_line_canceled := true;
1602: --Need to change the order type, if the conversion is indeed successful. Depending on the order type, the serial number/lot

Line 1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1595:
1596: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1597: RAISE FND_API.G_EXC_ERROR;
1598: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1600: END IF;
1601: l_rma_line_canceled := true;
1602: --Need to change the order type, if the conversion is indeed successful. Depending on the order type, the serial number/lot
1603: --number are dervived for receipt.

Line 1644: p_init_msg_list => FND_API.G_FALSE, --p_init_msg_list,

1640: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'l_osp_order_line_rec.exchange_instance_id:'||l_osp_order_line_rec.exchange_instance_id);
1641: END IF;
1642: IF(nvl(l_derived_instance_id,-1) <> nvl(l_osp_order_line_rec.exchange_instance_id,-1)) THEN
1643: AHL_OSP_SHIPMENT_PUB.Delete_IB_Transaction(
1644: p_init_msg_list => FND_API.G_FALSE, --p_init_msg_list,
1645: p_commit => FND_API.G_FALSE,
1646: p_validation_level => p_validation_level,
1647: x_return_status => x_return_status,
1648: x_msg_count => x_msg_count,

Line 1645: p_commit => FND_API.G_FALSE,

1641: END IF;
1642: IF(nvl(l_derived_instance_id,-1) <> nvl(l_osp_order_line_rec.exchange_instance_id,-1)) THEN
1643: AHL_OSP_SHIPMENT_PUB.Delete_IB_Transaction(
1644: p_init_msg_list => FND_API.G_FALSE, --p_init_msg_list,
1645: p_commit => FND_API.G_FALSE,
1646: p_validation_level => p_validation_level,
1647: x_return_status => x_return_status,
1648: x_msg_count => x_msg_count,
1649: x_msg_data => x_msg_data,

Line 1667: p_init_msg_list => FND_API.G_FALSE, -- Don't initialize the Message List

1663:
1664: l_del_oe_lines_tbl(1) := p_rma_receipt_rec.return_line_id;
1665: AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order (
1666: p_api_version => 1.0,
1667: p_init_msg_list => FND_API.G_FALSE, -- Don't initialize the Message List
1668: p_commit => FND_API.G_FALSE, -- Don't commit independently
1669: p_oe_header_id => null, -- Not deleting the shipment header: Only the lines
1670: p_oe_lines_tbl => l_del_oe_lines_tbl, -- Lines to be deleted/Cancelled
1671: p_cancel_flag => FND_API.G_FALSE, -- Do Deletes if possible, Cancels if not

Line 1668: p_commit => FND_API.G_FALSE, -- Don't commit independently

1664: l_del_oe_lines_tbl(1) := p_rma_receipt_rec.return_line_id;
1665: AHL_OSP_SHIPMENT_PUB.Delete_Cancel_Order (
1666: p_api_version => 1.0,
1667: p_init_msg_list => FND_API.G_FALSE, -- Don't initialize the Message List
1668: p_commit => FND_API.G_FALSE, -- Don't commit independently
1669: p_oe_header_id => null, -- Not deleting the shipment header: Only the lines
1670: p_oe_lines_tbl => l_del_oe_lines_tbl, -- Lines to be deleted/Cancelled
1671: p_cancel_flag => FND_API.G_FALSE, -- Do Deletes if possible, Cancels if not
1672: x_return_status => l_return_status ,

Line 1671: p_cancel_flag => FND_API.G_FALSE, -- Do Deletes if possible, Cancels if not

1667: p_init_msg_list => FND_API.G_FALSE, -- Don't initialize the Message List
1668: p_commit => FND_API.G_FALSE, -- Don't commit independently
1669: p_oe_header_id => null, -- Not deleting the shipment header: Only the lines
1670: p_oe_lines_tbl => l_del_oe_lines_tbl, -- Lines to be deleted/Cancelled
1671: p_cancel_flag => FND_API.G_FALSE, -- Do Deletes if possible, Cancels if not
1672: x_return_status => l_return_status ,
1673: x_msg_count => l_msg_count ,
1674: x_msg_data => l_msg_data
1675: );

Line 1679: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1675: );
1676: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1677: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from Delete_Cancel_Order, l_return_status = ' || l_return_status);
1678: END IF;
1679: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1680: RAISE FND_API.G_EXC_ERROR;
1681: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1683: END IF;

Line 1680: RAISE FND_API.G_EXC_ERROR;

1676: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1677: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from Delete_Cancel_Order, l_return_status = ' || l_return_status);
1678: END IF;
1679: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1680: RAISE FND_API.G_EXC_ERROR;
1681: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1683: END IF;
1684: l_rma_line_canceled := true;

Line 1681: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1677: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from Delete_Cancel_Order, l_return_status = ' || l_return_status);
1678: END IF;
1679: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1680: RAISE FND_API.G_EXC_ERROR;
1681: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1683: END IF;
1684: l_rma_line_canceled := true;
1685: END IF;--IF(l_oe_order_line_rec.inventory_item_id = p_rma_receipt_rec.EXCHANGE_ITEM_ID) THEN

Line 1682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1678: END IF;
1679: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1680: RAISE FND_API.G_EXC_ERROR;
1681: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1683: END IF;
1684: l_rma_line_canceled := true;
1685: END IF;--IF(l_oe_order_line_rec.inventory_item_id = p_rma_receipt_rec.EXCHANGE_ITEM_ID) THEN
1686: END IF;--IF(l_osp_order_type = AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE) THEN

Line 1709: l_oe_line_tbl(1).line_id := FND_API.G_MISS_NUM;

1705:
1706: /* Create a new RMA Line, corresponding to the receipt */
1707: l_oe_line_tbl(1) := l_oe_line_rec;
1708: l_oe_line_tbl(1).inventory_item_id := p_rma_receipt_rec.EXCHANGE_ITEM_ID;
1709: l_oe_line_tbl(1).line_id := FND_API.G_MISS_NUM;
1710: l_oe_line_tbl(1).line_number := FND_API.G_MISS_NUM;
1711: l_oe_line_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
1712:
1713: IF(p_rma_receipt_rec.EXCHANGE_SERIAL_NUMBER is not NULL OR p_rma_receipt_rec.EXCHANGE_LOT_NUMBER is not NULL) THEN

Line 1710: l_oe_line_tbl(1).line_number := FND_API.G_MISS_NUM;

1706: /* Create a new RMA Line, corresponding to the receipt */
1707: l_oe_line_tbl(1) := l_oe_line_rec;
1708: l_oe_line_tbl(1).inventory_item_id := p_rma_receipt_rec.EXCHANGE_ITEM_ID;
1709: l_oe_line_tbl(1).line_id := FND_API.G_MISS_NUM;
1710: l_oe_line_tbl(1).line_number := FND_API.G_MISS_NUM;
1711: l_oe_line_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
1712:
1713: IF(p_rma_receipt_rec.EXCHANGE_SERIAL_NUMBER is not NULL OR p_rma_receipt_rec.EXCHANGE_LOT_NUMBER is not NULL) THEN
1714: --populate the lot_serial_rec

Line 1715: l_oe_lot_serial_tbl(1).lot_serial_id := FND_API.G_MISS_NUM;

1711: l_oe_line_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
1712:
1713: IF(p_rma_receipt_rec.EXCHANGE_SERIAL_NUMBER is not NULL OR p_rma_receipt_rec.EXCHANGE_LOT_NUMBER is not NULL) THEN
1714: --populate the lot_serial_rec
1715: l_oe_lot_serial_tbl(1).lot_serial_id := FND_API.G_MISS_NUM;
1716: l_oe_lot_serial_tbl(1).lot_number := p_rma_receipt_rec.exchange_lot_number;
1717: l_oe_lot_serial_tbl(1).from_serial_number := p_rma_receipt_rec.exchange_serial_number;
1718: l_oe_lot_serial_tbl(1).quantity := l_oe_line_rec.ordered_quantity;
1719: l_oe_lot_serial_tbl(1).line_index := 1;

Line 1729: p_init_msg_list => FND_API.G_TRUE,

1725: END IF;
1726:
1727: OE_ORDER_GRP.PROCESS_ORDER(
1728: p_api_version_number => 1.0,
1729: p_init_msg_list => FND_API.G_TRUE,
1730: x_return_status => x_return_status,
1731: x_msg_count => x_msg_count,
1732: x_msg_data => x_msg_data,
1733: p_header_rec => x_header_rec,

Line 1768: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1764: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed OE_ORDER_GRP.PROCESS_ORDER, x_return_status = ' || x_return_status);
1765: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'x_return_line_id = ' || x_return_line_id);
1766: END IF;
1767:
1768: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1769: FOR i IN 1..x_msg_count LOOP
1770: OE_MSG_PUB.Get(p_msg_index => i,
1771: p_encoded => FND_API.G_FALSE,
1772: p_data => l_msg_data,

Line 1771: p_encoded => FND_API.G_FALSE,

1767:
1768: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1769: FOR i IN 1..x_msg_count LOOP
1770: OE_MSG_PUB.Get(p_msg_index => i,
1771: p_encoded => FND_API.G_FALSE,
1772: p_data => l_msg_data,
1773: p_msg_index_out => l_msg_index_out);
1774: fnd_msg_pub.add_exc_msg(p_pkg_name => 'OE_ORDER_PUB',
1775: p_procedure_name => 'processOrder',

Line 1784: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1780:
1781: END LOOP;
1782: END IF;
1783:
1784: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1785: RAISE FND_API.G_EXC_ERROR;
1786: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1788: END IF;

Line 1785: RAISE FND_API.G_EXC_ERROR;

1781: END LOOP;
1782: END IF;
1783:
1784: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1785: RAISE FND_API.G_EXC_ERROR;
1786: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1788: END IF;
1789:

Line 1786: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1782: END IF;
1783:
1784: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1785: RAISE FND_API.G_EXC_ERROR;
1786: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1788: END IF;
1789:
1790: /* Update the osp_line with the new RMA line id*/

Line 1787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1783:
1784: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1785: RAISE FND_API.G_EXC_ERROR;
1786: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1788: END IF;
1789:
1790: /* Update the osp_line with the new RMA line id*/
1791: OPEN get_same_phyitem_order_lines(l_osp_line_id);

Line 1801: p_oe_ship_line_id => FND_API.G_MISS_NUM ,

1797: END IF;
1798: Update_OSP_Order_Lines(
1799: p_osp_order_id => l_osp_order_id,
1800: p_osp_line_id => l_same_ser_ospline_id,
1801: p_oe_ship_line_id => FND_API.G_MISS_NUM ,
1802: p_oe_return_line_id => x_return_line_id);
1803: END LOOP;
1804: CLOSE get_same_phyitem_order_lines;
1805: END IF;--IF(l_rma_line_canceled) THEN

Line 1829: p_init_msg_list => FND_API.G_FALSE, --p_init_msg_list,

1825: END IF;
1826:
1827: /* Create the new IB transaction */
1828: AHL_OSP_SHIPMENT_PUB.Create_IB_Transaction(
1829: p_init_msg_list => FND_API.G_FALSE, --p_init_msg_list,
1830: p_commit => FND_API.G_FALSE,
1831: p_validation_level => p_validation_level,
1832: x_return_status => l_return_status,
1833: x_msg_count => l_msg_count,

Line 1830: p_commit => FND_API.G_FALSE,

1826:
1827: /* Create the new IB transaction */
1828: AHL_OSP_SHIPMENT_PUB.Create_IB_Transaction(
1829: p_init_msg_list => FND_API.G_FALSE, --p_init_msg_list,
1830: p_commit => FND_API.G_FALSE,
1831: p_validation_level => p_validation_level,
1832: x_return_status => l_return_status,
1833: x_msg_count => l_msg_count,
1834: x_msg_data => l_msg_data,

Line 1844: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1840: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1841: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Return status from Create_IB_Transaction: ' || l_return_status);
1842: END IF;
1843:
1844: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1845: RAISE FND_API.G_EXC_ERROR;
1846: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1848: END IF;

Line 1845: RAISE FND_API.G_EXC_ERROR;

1841: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Return status from Create_IB_Transaction: ' || l_return_status);
1842: END IF;
1843:
1844: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1845: RAISE FND_API.G_EXC_ERROR;
1846: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1848: END IF;
1849:

Line 1846: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1842: END IF;
1843:
1844: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1845: RAISE FND_API.G_EXC_ERROR;
1846: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1848: END IF;
1849:
1850: END IF;--IF(l_is_ib_trackable = 'Y' AND (l_rma_line_canceled OR l_ib_trans_deleted)) THEN

Line 1847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1843:
1844: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1845: RAISE FND_API.G_EXC_ERROR;
1846: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1847: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1848: END IF;
1849:
1850: END IF;--IF(l_is_ib_trackable = 'Y' AND (l_rma_line_canceled OR l_ib_trans_deleted)) THEN
1851:

Line 2216: p_encoded => FND_API.G_FALSE

2212: -- Standard call to get message count and initialise the OUT parameters.
2213: FND_MSG_PUB.Count_And_Get
2214: ( p_count => x_msg_count,
2215: p_data => x_msg_data,
2216: p_encoded => FND_API.G_FALSE
2217: );
2218:
2219: -- Commit work if p_commit is TRUE.
2220: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 2220: IF FND_API.TO_BOOLEAN(p_commit) THEN

2216: p_encoded => FND_API.G_FALSE
2217: );
2218:
2219: -- Commit work if p_commit is TRUE.
2220: IF FND_API.TO_BOOLEAN(p_commit) THEN
2221: COMMIT WORK;
2222: END IF;
2223:
2224: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 2230: WHEN FND_API.G_EXC_ERROR THEN

2226: ' x_request_id: '||x_request_id||
2227: ', x_return_line_id: '||x_return_line_id);
2228: END IF;
2229: EXCEPTION
2230: WHEN FND_API.G_EXC_ERROR THEN
2231: ROLLBACK TO Receive_Against_RMA_Pvt;
2232: x_return_status := FND_API.G_RET_STS_ERROR;
2233: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2234: p_data => x_msg_data,

Line 2232: x_return_status := FND_API.G_RET_STS_ERROR;

2228: END IF;
2229: EXCEPTION
2230: WHEN FND_API.G_EXC_ERROR THEN
2231: ROLLBACK TO Receive_Against_RMA_Pvt;
2232: x_return_status := FND_API.G_RET_STS_ERROR;
2233: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2234: p_data => x_msg_data,
2235: p_encoded => FND_API.G_FALSE);
2236:

Line 2235: p_encoded => FND_API.G_FALSE);

2231: ROLLBACK TO Receive_Against_RMA_Pvt;
2232: x_return_status := FND_API.G_RET_STS_ERROR;
2233: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2234: p_data => x_msg_data,
2235: p_encoded => FND_API.G_FALSE);
2236:
2237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2238: ROLLBACK TO Receive_Against_RMA_Pvt;
2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2233: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2234: p_data => x_msg_data,
2235: p_encoded => FND_API.G_FALSE);
2236:
2237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2238: ROLLBACK TO Receive_Against_RMA_Pvt;
2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2240: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2241: p_data => x_msg_data,

Line 2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2235: p_encoded => FND_API.G_FALSE);
2236:
2237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2238: ROLLBACK TO Receive_Against_RMA_Pvt;
2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2240: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2241: p_data => x_msg_data,
2242: p_encoded => FND_API.G_FALSE);
2243:

Line 2242: p_encoded => FND_API.G_FALSE);

2238: ROLLBACK TO Receive_Against_RMA_Pvt;
2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2240: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2241: p_data => x_msg_data,
2242: p_encoded => FND_API.G_FALSE);
2243:
2244: WHEN OTHERS THEN
2245: ROLLBACK TO Receive_Against_RMA_Pvt;
2246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2242: p_encoded => FND_API.G_FALSE);
2243:
2244: WHEN OTHERS THEN
2245: ROLLBACK TO Receive_Against_RMA_Pvt;
2246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2247: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => G_PKG_NAME,
2248: p_procedure_name => l_api_name,
2249: p_error_text => SQLERRM);
2250:

Line 2253: p_encoded => FND_API.G_FALSE);

2249: p_error_text => SQLERRM);
2250:
2251: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2252: p_data => x_msg_data,
2253: p_encoded => FND_API.G_FALSE);
2254: END Receive_Against_RMA;
2255:
2256:
2257: -- Start of Comments --

Line 2531: RAISE FND_API.G_EXC_ERROR;

2527: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
2528: 'As l_valid_flag is FALSE, raising an exception.');
2529: END IF;
2530:
2531: RAISE FND_API.G_EXC_ERROR;
2532: END IF;
2533: END Validate_Receiving_Params;
2534:
2535:

Line 2630: RAISE Fnd_Api.g_exc_error;

2626: IF (val_exg_instance_id_csr %NOTFOUND) THEN
2627: FND_MESSAGE.Set_Name('AHL','AHL_OSP_SHIP_COMPONENT');
2628: FND_MSG_PUB.ADD;
2629: CLOSE val_exg_instance_id_csr;
2630: RAISE Fnd_Api.g_exc_error;
2631: END IF;
2632: CLOSE val_exg_instance_id_csr;
2633: END IF;
2634:

Line 2690: RAISE Fnd_Api.g_exc_error;

2686:
2687: IF l_row_check = 'N' THEN
2688: Fnd_Message.set_name('AHL', 'AHL_OSP_INVALID_LINE_ITEM');
2689: Fnd_Msg_Pub.ADD;
2690: RAISE Fnd_Api.g_exc_error;
2691: END IF;
2692:
2693: END Update_OSP_Line_Exch_Instance;
2694:

Line 2768: AND p_oe_ship_line_id <> FND_API.G_MISS_NUM) THEN

2764: FOR l_osp_line_rec IN ahl_osp_lines_csr(p_osp_order_id, p_osp_line_id)
2765: LOOP
2766: l_row_check := 'Y';
2767: IF ( p_oe_ship_line_id IS NOT NULL
2768: AND p_oe_ship_line_id <> FND_API.G_MISS_NUM) THEN
2769: l_oe_ship_line_id := p_oe_ship_line_id;
2770: ELSE
2771: l_oe_ship_line_id := l_osp_line_rec.oe_ship_line_id;
2772: END IF;

Line 2775: AND p_oe_return_line_id <> FND_API.G_MISS_NUM) THEN

2771: l_oe_ship_line_id := l_osp_line_rec.oe_ship_line_id;
2772: END IF;
2773:
2774: IF (p_oe_return_line_id IS NOT NULL
2775: AND p_oe_return_line_id <> FND_API.G_MISS_NUM) THEN
2776: l_oe_return_line_id := p_oe_return_line_id;
2777: ELSE
2778: l_oe_return_line_id := l_osp_line_rec.oe_return_line_id;
2779: END IF;

Line 2832: RAISE Fnd_Api.g_exc_error;

2828:
2829: IF l_row_check = 'N' THEN
2830: Fnd_Message.set_name('AHL', 'AHL_OSP_INVALID_LINE_ITEM');
2831: Fnd_Msg_Pub.ADD;
2832: RAISE Fnd_Api.g_exc_error;
2833: END IF;
2834:
2835: END Update_OSP_Order_Lines;
2836: