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_MSG_PUB

Line 851: FND_MSG_PUB.Initialize;

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.
855: OPEN get_po_header_id(p_return_line_id);

Line 870: FND_MSG_PUB.ADD;

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.
874: -- If not approved, raise an exception.

Line 886: FND_MSG_PUB.ADD;

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;
890: END IF; -- if l_po_req_header_id IS NULL

Line 904: FND_MSG_PUB.ADD;

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;
908: END IF; -- if l_po_header_id IS NULL

Line 919: FND_MSG_PUB.ADD;

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;
923:

Line 968: FND_MSG_PUB.ADD;

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;
972: END IF;

Line 1000: FND_MSG_PUB.ADD;

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;
1004:

Line 1122: FND_MSG_PUB.ADD;

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:
1126: -- After the interface tables been populated above, submit request for calling the Concurrent Program 'RVCTP'.

Line 1160: FND_MSG_PUB.Count_And_Get

1156: -- Set the OUT parameter x_request_id with l_req_id.
1157: x_request_id := l_req_id;
1158:
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: );

Line 1178: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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:
1182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1185: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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:
1189: WHEN OTHERS THEN

Line 1192: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => G_PKG_NAME,

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:
1196: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1196: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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:
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:

Line 1415: FND_MSG_PUB.Initialize;

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;
1419:

Line 1448: FND_MSG_PUB.ADD;

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;
1452:

Line 1554: FND_MSG_PUB.ADD;

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:
1558: ELSIF (l_exchange_flag) THEN

Line 1774: fnd_msg_pub.add_exc_msg(p_pkg_name => 'OE_ORDER_PUB',

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',
1776: p_error_text => substr(l_msg_data,1,240));
1777: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1778: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'OE:Err Msg '||i||'.' || l_msg_data);

Line 2213: FND_MSG_PUB.Count_And_Get

2209: -- Set the OUT parameter x_request_id with l_req_id.
2210: x_request_id := l_request_id;
2211:
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: );

Line 2233: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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:
2237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2240: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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:
2244: WHEN OTHERS THEN

Line 2247: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => G_PKG_NAME,

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:
2251: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 2251: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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:
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:

Line 2346: FND_MSG_PUB.ADD;

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;
2350: END IF;

Line 2374: FND_MSG_PUB.ADD;

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;
2378: END IF;

Line 2391: FND_MSG_PUB.ADD;

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;
2395: END IF;

Line 2409: FND_MSG_PUB.ADD;

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;
2413: END IF;

Line 2429: FND_MSG_PUB.ADD;

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;
2433: ELSE

Line 2453: FND_MSG_PUB.ADD;

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;
2457: END IF;

Line 2476: FND_MSG_PUB.ADD;

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;
2480: END IF;

Line 2490: FND_MSG_PUB.ADD;

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;
2494: END IF;

Line 2507: FND_MSG_PUB.ADD;

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;
2511: END IF;

Line 2628: FND_MSG_PUB.ADD;

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;
2632: CLOSE val_exg_instance_id_csr;

Line 2689: Fnd_Msg_Pub.ADD;

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:
2693: END Update_OSP_Line_Exch_Instance;

Line 2831: Fnd_Msg_Pub.ADD;

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:
2835: END Update_OSP_Order_Lines;