[Home] [Help]
1095: '. Raising exception.');
1096: END IF;
1097:
1098: CLOSE get_po_header_id;
1099: 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.
1100: FND_MSG_PUB.ADD;
1101: RAISE FND_API.G_EXC_ERROR;
1102: ELSE
1103: -- Check whether the Requisition is approved or not.
1111: END IF;
1112:
1113: CLOSE chk_po_req_approved;
1114: CLOSE get_po_header_id;
1115: FND_MESSAGE.set_name('AHL', 'AHL_OSP_REQ_NOT_APRVD'); -- Receipt cannot be done as the requisition is not approved.
1116: FND_MSG_PUB.ADD;
1117: RAISE FND_API.G_EXC_ERROR;
1118: END IF;
1119: CLOSE chk_po_req_approved;
1129: END IF;
1130:
1131: CLOSE get_po_header_details1;
1132: CLOSE get_po_header_id;
1133: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PO_NOT_APRVD'); -- Receipt cannot be done as the purchase order is not approved.
1134: FND_MSG_PUB.ADD;
1135: RAISE FND_API.G_EXC_ERROR;
1136: END IF;
1137: CLOSE get_po_header_details1;
1143: 'OSP order: '||l_osp_order_number||' is not in status PO_CREATED or REQ_CREATED. Raising exception.');
1144: END IF;
1145:
1146: CLOSE get_po_header_id;
1147: FND_MESSAGE.set_name('AHL', 'AHL_OSP_ORDER_INVALID'); -- The status of the OSP order (ORDER_NUM) is not valid for receiving.
1148: FND_MESSAGE.set_token('ORDER_NUM', l_osp_order_number);
1149: FND_MSG_PUB.ADD;
1150: RAISE FND_API.G_EXC_ERROR;
1151: END IF; -- if get_po_header_id%FOUND
1144: END IF;
1145:
1146: CLOSE get_po_header_id;
1147: FND_MESSAGE.set_name('AHL', 'AHL_OSP_ORDER_INVALID'); -- The status of the OSP order (ORDER_NUM) is not valid for receiving.
1148: FND_MESSAGE.set_token('ORDER_NUM', l_osp_order_number);
1149: FND_MSG_PUB.ADD;
1150: RAISE FND_API.G_EXC_ERROR;
1151: END IF; -- if get_po_header_id%FOUND
1152: CLOSE get_po_header_id;
1193: END IF;
1194:
1195: CLOSE get_po_line;
1196: CLOSE get_po_line_quantity1;
1197: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PO_NULL_OR_INVLD'); -- Either the purchase order is not created or it is not approved.
1198: FND_MSG_PUB.ADD;
1199: RAISE FND_API.G_EXC_ERROR;
1200: END IF; -- if get_po_line%FOUND
1201: CLOSE get_po_line;
1225: END IF;
1226:
1227: CLOSE chk_pending_transaction;
1228: CLOSE get_po_line_quantity1;
1229: FND_MESSAGE.set_name('AHL', 'AHL_OSP_PO_PENDING_TRNSCTN'); -- Some of the purchase order lines for this return line have pending transactions.
1230: FND_MSG_PUB.ADD;
1231: RAISE FND_API.G_EXC_ERROR;
1232: END IF;
1233: CLOSE chk_pending_transaction;
1347: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
1348: 'No PO lines could be found to do a receipt against. Raising exception.');
1349: END IF;
1350:
1351: FND_MESSAGE.set_name('AHL', 'AHL_OSP_ALL_PO_LINES_RCVD'); -- All the purchase order lines for this return line have been received.
1352: FND_MSG_PUB.ADD;
1353: RAISE FND_API.G_EXC_ERROR;
1354: END IF;
1355:
1680: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1681: FND_LOG.string(FND_LOG.level_statement, l_debug_key, 'Pending transactions exist for oe line id: '||p_rma_receipt_rec.RETURN_LINE_ID);
1682: END IF;
1683: CLOSE chk_pending_transaction;
1684: FND_MESSAGE.set_name('AHL', 'AHL_OSP_OE_TRANS_PENDING'); -- The return line has pending transactions.
1685: FND_MSG_PUB.ADD;
1686: RAISE FND_API.G_EXC_ERROR;
1687: END IF;
1688: CLOSE chk_pending_transaction;
1804: x_return_line_id := l_new_oe_line_id;
1805:
1806: ELSE
1807: --Part number change cannot be performed for the return line.
1808: FND_MESSAGE.Set_Name('AHL','AHL_OSP_CHG_OSPL_INV');
1809: FND_MSG_PUB.ADD;
1810: RAISE FND_API.G_EXC_ERROR;
1811: END IF;
1812:
2620: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
2621: 'Mandatory fields have not been entered.');
2622: END IF;
2623:
2624: FND_MESSAGE.set_name('AHL', 'AHL_COM_REQD_PARAM_MISSING'); -- Required parameter is missing.
2625: FND_MSG_PUB.ADD;
2626:
2627: -- Set the l_valid_flag as FALSE.
2628: l_valid_flag := FALSE;
2648: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
2649: 'Part number change and exchange cannot be done together.');
2650: END IF;
2651:
2652: FND_MESSAGE.set_name('AHL', 'AHL_OSP_NO_PN_CHG_EXCHG_TGTHR'); -- Part number change and Exchange cannot be done together.
2653: FND_MSG_PUB.ADD;
2654:
2655: -- Set the l_valid_flag as FALSE.
2656: l_valid_flag := FALSE;
2665: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
2666: 'Return line: '||p_rma_receipt_rec.return_line_id||' is invalid.');
2667: END IF;
2668:
2669: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RMA_LINE_INVALID'); -- Return line is invalid.
2670: FND_MSG_PUB.ADD;
2671:
2672: -- Set the l_valid_flag as FALSE.
2673: l_valid_flag := FALSE;
2683: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
2684: 'Shipment order: '||l_oe_header_id||' is not booked.');
2685: END IF;
2686:
2687: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RMA_SHPMNT_NOT_BKD'); -- Shipment is not booked.
2688: FND_MSG_PUB.ADD;
2689:
2690: -- Set the l_valid_flag as FALSE.
2691: l_valid_flag := FALSE;
2703: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
2704: 'Ship line id for the return line: '||p_rma_receipt_rec.return_line_id||' is NULL.');
2705: END IF;
2706:
2707: FND_MESSAGE.set_name('AHL', 'AHL_OSP_SHIP_LINE_NULL'); -- Shipment line does not exist for this return line.
2708: FND_MSG_PUB.ADD;
2709:
2710: -- Set the l_valid_flag as FALSE.
2711: l_valid_flag := FALSE;
2727: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
2728: 'Shipment for the return line: '||p_rma_receipt_rec.return_line_id||' has not been done yet.');
2729: END IF;
2730:
2731: FND_MESSAGE.set_name('AHL', 'AHL_OSP_SHIPMENT_NOT_DONE'); -- Shipping has not been done for the ship line corresponding to this return line.
2732: FND_MSG_PUB.ADD;
2733:
2734: -- Set the l_valid_flag as FALSE.
2735: l_valid_flag := FALSE;
2750: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
2751: 'Shipped qty is not less than the ordered qty for the return line: '||p_rma_receipt_rec.return_line_id);
2752: END IF;
2753:
2754: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RECEIPT_CMPLT'); -- Receipt is complete for this return line.
2755: FND_MSG_PUB.ADD;
2756:
2757: -- Set the l_valid_flag as FALSE.
2758: l_valid_flag := FALSE;
2764: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
2765: 'Receipt date: '||p_rma_receipt_rec.receipt_date||' is in future.');
2766: END IF;
2767:
2768: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RECEIPT_DATE_INVALID'); -- Receipt cannot be done for a future date.
2769: FND_MSG_PUB.ADD;
2770:
2771: -- Set the l_valid_flag as FALSE.
2772: l_valid_flag := FALSE;
2781: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
2782: 'Receipt org is different from the one set in the return line.');
2783: END IF;
2784:
2785: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RECEIPT_ORG_INVALID'); -- Receiving organization is different from the one set for the return line.
2786: FND_MSG_PUB.ADD;
2787:
2788: -- Set the l_valid_flag as FALSE.
2789: l_valid_flag := FALSE;
2902: IF(p_exchange_instance_id is not null) THEN
2903: OPEN val_exg_instance_id_csr(p_exchange_instance_id);
2904: FETCH val_exg_instance_id_csr INTO l_exist;
2905: IF (val_exg_instance_id_csr %NOTFOUND) THEN
2906: FND_MESSAGE.Set_Name('AHL','AHL_OSP_SHIP_COMPONENT');
2907: FND_MSG_PUB.ADD;
2908: CLOSE val_exg_instance_id_csr;
2909: RAISE Fnd_Api.g_exc_error;
2910: END IF;
2963: P_ATTRIBUTE15 => l_osp_line_rec.ATTRIBUTE15 );
2964: END LOOP;
2965:
2966: IF l_row_check = 'N' THEN
2967: Fnd_Message.set_name('AHL', 'AHL_OSP_INVALID_LINE_ITEM');
2968: Fnd_Msg_Pub.ADD;
2969: RAISE Fnd_Api.g_exc_error;
2970: END IF;
2971:
3105: P_ATTRIBUTE15 => l_osp_line_rec.ATTRIBUTE15 );
3106: END LOOP;
3107:
3108: IF l_row_check = 'N' THEN
3109: Fnd_Message.set_name('AHL', 'AHL_OSP_INVALID_LINE_ITEM');
3110: Fnd_Msg_Pub.ADD;
3111: RAISE Fnd_Api.g_exc_error;
3112: END IF;
3113:
3203: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
3204: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
3205: 'Mandatory fields have not been entered.');
3206: END IF;
3207: FND_MESSAGE.set_name('AHL', 'AHL_COM_REQD_PARAM_MISSING'); -- Required parameter is missing.
3208: FND_MSG_PUB.ADD;
3209: x_return_status := FND_API.G_RET_STS_ERROR;
3210: RETURN;
3211: END IF;
3228: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
3229: 'The receiving locator '||l_receiving_locator_name||' already exists in another Sub Inventory '
3230: ||l_sub_inv_code);
3231: END IF;
3232: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RMA_INV_LOC'); -- The receiving locator is invalid.
3233: FND_MSG_PUB.ADD;
3234: x_return_status := FND_API.G_RET_STS_ERROR;
3235: CLOSE is_valid_locator;
3236: RETURN;
3298: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
3299: 'The receiving locator '||p_rma_receipt_rec.receiving_locator_name||' does not exist in Sub Inventory '
3300: ||p_rma_receipt_rec.receiving_subinventory);
3301: END IF;
3302: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RMA_INV_LOC'); -- The receiving locator is invalid.
3303: FND_MSG_PUB.ADD;
3304: x_return_status := FND_API.G_RET_STS_ERROR;
3305: CLOSE is_dyn_locator_sub_inv;
3306: CLOSE is_valid_locator;