[Home] [Help]
865: '. Raising exception.');
866: END IF;
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.
881: END IF;
882:
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;
899: END IF;
900:
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;
913: 'OSP order: '||l_osp_order_number||' is not in status PO_CREATED or REQ_CREATED. Raising exception.');
914: END IF;
915:
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
914: END IF;
915:
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;
963: END IF;
964:
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;
995: END IF;
996:
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;
1117: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
1118: 'No PO lines could be found to do a receipt against. Raising exception.');
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:
1443: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1444: FND_LOG.string(FND_LOG.level_statement, l_debug_key, 'Pending transactions exist for oe line id: '||p_rma_receipt_rec.RETURN_LINE_ID);
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;
1549: x_return_line_id := l_new_oe_line_id;
1550:
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:
2341: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
2342: 'Mandatory fields have not been entered.');
2343: END IF;
2344:
2345: FND_MESSAGE.set_name('AHL', 'AHL_COM_REQD_PARAM_MISSING'); -- Required parameter is missing.
2346: FND_MSG_PUB.ADD;
2347:
2348: -- Set the l_valid_flag as FALSE.
2349: l_valid_flag := FALSE;
2369: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
2370: 'Part number change and exchange cannot be done together.');
2371: END IF;
2372:
2373: FND_MESSAGE.set_name('AHL', 'AHL_OSP_NO_PN_CHG_EXCHG_TGTHR'); -- Part number change and Exchange cannot be done together.
2374: FND_MSG_PUB.ADD;
2375:
2376: -- Set the l_valid_flag as FALSE.
2377: l_valid_flag := FALSE;
2386: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
2387: 'Return line: '||p_rma_receipt_rec.return_line_id||' is invalid.');
2388: END IF;
2389:
2390: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RMA_LINE_INVALID'); -- Return line is invalid.
2391: FND_MSG_PUB.ADD;
2392:
2393: -- Set the l_valid_flag as FALSE.
2394: l_valid_flag := FALSE;
2404: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
2405: 'Shipment order: '||l_oe_header_id||' is not booked.');
2406: END IF;
2407:
2408: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RMA_SHPMNT_NOT_BKD'); -- Shipment is not booked.
2409: FND_MSG_PUB.ADD;
2410:
2411: -- Set the l_valid_flag as FALSE.
2412: l_valid_flag := FALSE;
2424: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
2425: 'Ship line id for the return line: '||p_rma_receipt_rec.return_line_id||' is NULL.');
2426: END IF;
2427:
2428: FND_MESSAGE.set_name('AHL', 'AHL_OSP_SHIP_LINE_NULL'); -- Shipment line does not exist for this return line.
2429: FND_MSG_PUB.ADD;
2430:
2431: -- Set the l_valid_flag as FALSE.
2432: l_valid_flag := FALSE;
2448: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
2449: 'Shipment for the return line: '||p_rma_receipt_rec.return_line_id||' has not been done yet.');
2450: END IF;
2451:
2452: FND_MESSAGE.set_name('AHL', 'AHL_OSP_SHIPMENT_NOT_DONE'); -- Shipping has not been done for the ship line corresponding to this return line.
2453: FND_MSG_PUB.ADD;
2454:
2455: -- Set the l_valid_flag as FALSE.
2456: l_valid_flag := FALSE;
2471: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
2472: 'Shipped qty is not less than the ordered qty for the return line: '||p_rma_receipt_rec.return_line_id);
2473: END IF;
2474:
2475: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RECEIPT_CMPLT'); -- Receipt is complete for this return line.
2476: FND_MSG_PUB.ADD;
2477:
2478: -- Set the l_valid_flag as FALSE.
2479: l_valid_flag := FALSE;
2485: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
2486: 'Receipt date: '||p_rma_receipt_rec.receipt_date||' is in future.');
2487: END IF;
2488:
2489: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RECEIPT_DATE_INVALID'); -- Receipt cannot be done for a future date.
2490: FND_MSG_PUB.ADD;
2491:
2492: -- Set the l_valid_flag as FALSE.
2493: l_valid_flag := FALSE;
2502: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
2503: 'Receipt org is different from the one set in the return line.');
2504: END IF;
2505:
2506: FND_MESSAGE.set_name('AHL', 'AHL_OSP_RECEIPT_ORG_INVALID'); -- Receiving organization is different from the one set for the return line.
2507: FND_MSG_PUB.ADD;
2508:
2509: -- Set the l_valid_flag as FALSE.
2510: l_valid_flag := FALSE;
2623: IF(p_exchange_instance_id is not null) THEN
2624: OPEN val_exg_instance_id_csr(p_exchange_instance_id);
2625: FETCH val_exg_instance_id_csr INTO l_exist;
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;
2684: P_ATTRIBUTE15 => l_osp_line_rec.ATTRIBUTE15 );
2685: END LOOP;
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:
2826: P_ATTRIBUTE15 => l_osp_line_rec.ATTRIBUTE15 );
2827: END LOOP;
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: