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 1081: FND_MSG_PUB.Initialize;

1077: END IF;
1078:
1079: -- Initialize message list if p_init_msg_list is set to TRUE.
1080: IF FND_API.To_Boolean(p_init_msg_list) THEN
1081: FND_MSG_PUB.Initialize;
1082: END IF;
1083:
1084: -- Get the PO header id for the OSP order corresponding to the given return line id.
1085: OPEN get_po_header_id(p_return_line_id);

Line 1100: FND_MSG_PUB.ADD;

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

Line 1116: FND_MSG_PUB.ADD;

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

Line 1134: FND_MSG_PUB.ADD;

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

Line 1149: FND_MSG_PUB.ADD;

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

Line 1198: FND_MSG_PUB.ADD;

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

Line 1230: FND_MSG_PUB.ADD;

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

Line 1352: FND_MSG_PUB.ADD;

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

Line 1390: FND_MSG_PUB.Count_And_Get

1386: -- Set the OUT parameter x_request_id with l_req_id.
1387: x_request_id := l_req_id;
1388:
1389: -- Standard call to get message count and initialise the OUT parameters.
1390: FND_MSG_PUB.Count_And_Get
1391: ( p_count => x_msg_count,
1392: p_data => x_msg_data,
1393: p_encoded => FND_API.G_FALSE
1394: );

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

1404: EXCEPTION
1405: WHEN FND_API.G_EXC_ERROR THEN
1406: ROLLBACK TO Receive_Against_PO_Pvt;
1407: x_return_status := FND_API.G_RET_STS_ERROR;
1408: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1409: p_data => x_msg_data,
1410: p_encoded => FND_API.G_FALSE);
1411:
1412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1411:
1412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1413: ROLLBACK TO Receive_Against_PO_Pvt;
1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1415: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1416: p_data => x_msg_data,
1417: p_encoded => FND_API.G_FALSE);
1418:
1419: WHEN OTHERS THEN

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

1418:
1419: WHEN OTHERS THEN
1420: ROLLBACK TO Receive_Against_PO_Pvt;
1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => G_PKG_NAME,
1423: p_procedure_name => l_api_name,
1424: p_error_text => SQLERRM);
1425:
1426: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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

1422: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => G_PKG_NAME,
1423: p_procedure_name => l_api_name,
1424: p_error_text => SQLERRM);
1425:
1426: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1427: p_data => x_msg_data,
1428: p_encoded => FND_API.G_FALSE);
1429: END Receive_Against_PO;
1430:

Line 1650: FND_MSG_PUB.Initialize;

1646: END IF;
1647:
1648: -- Initialize message list if p_init_msg_list is set to TRUE.
1649: IF FND_API.To_Boolean(p_init_msg_list) THEN
1650: FND_MSG_PUB.Initialize;
1651: END IF;
1652:
1653: x_return_line_id := null;
1654:

Line 1685: FND_MSG_PUB.ADD;

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

Line 1809: FND_MSG_PUB.ADD;

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

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

2047: OE_MSG_PUB.Get(p_msg_index => i,
2048: p_encoded => FND_API.G_FALSE,
2049: p_data => l_msg_data,
2050: p_msg_index_out => l_msg_index_out);
2051: fnd_msg_pub.add_exc_msg(p_pkg_name => 'OE_ORDER_PUB',
2052: p_procedure_name => 'processOrder',
2053: p_error_text => substr(l_msg_data,1,240));
2054: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2055: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'OE:Err Msg '||i||'.' || l_msg_data);

Line 2492: FND_MSG_PUB.Count_And_Get

2488: -- Set the OUT parameter x_request_id with l_req_id.
2489: x_request_id := l_request_id;
2490:
2491: -- Standard call to get message count and initialise the OUT parameters.
2492: FND_MSG_PUB.Count_And_Get
2493: ( p_count => x_msg_count,
2494: p_data => x_msg_data,
2495: p_encoded => FND_API.G_FALSE
2496: );

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

2508: EXCEPTION
2509: WHEN FND_API.G_EXC_ERROR THEN
2510: ROLLBACK TO Receive_Against_RMA_Pvt;
2511: x_return_status := FND_API.G_RET_STS_ERROR;
2512: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2513: p_data => x_msg_data,
2514: p_encoded => FND_API.G_FALSE);
2515:
2516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2515:
2516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2517: ROLLBACK TO Receive_Against_RMA_Pvt;
2518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2519: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2520: p_data => x_msg_data,
2521: p_encoded => FND_API.G_FALSE);
2522:
2523: WHEN OTHERS THEN

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

2522:
2523: WHEN OTHERS THEN
2524: ROLLBACK TO Receive_Against_RMA_Pvt;
2525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2526: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => G_PKG_NAME,
2527: p_procedure_name => l_api_name,
2528: p_error_text => SQLERRM);
2529:
2530: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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

2526: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => G_PKG_NAME,
2527: p_procedure_name => l_api_name,
2528: p_error_text => SQLERRM);
2529:
2530: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
2531: p_data => x_msg_data,
2532: p_encoded => FND_API.G_FALSE);
2533: END Receive_Against_RMA;
2534:

Line 2625: FND_MSG_PUB.ADD;

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

Line 2653: FND_MSG_PUB.ADD;

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

Line 2670: FND_MSG_PUB.ADD;

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

Line 2688: FND_MSG_PUB.ADD;

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

Line 2708: FND_MSG_PUB.ADD;

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

Line 2732: FND_MSG_PUB.ADD;

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

Line 2755: FND_MSG_PUB.ADD;

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

Line 2769: FND_MSG_PUB.ADD;

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

Line 2786: FND_MSG_PUB.ADD;

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

Line 2907: FND_MSG_PUB.ADD;

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

Line 2968: Fnd_Msg_Pub.ADD;

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

Line 3110: Fnd_Msg_Pub.ADD;

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

Line 3208: FND_MSG_PUB.ADD;

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

Line 3233: FND_MSG_PUB.ADD;

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

Line 3303: FND_MSG_PUB.ADD;

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;
3307: RETURN;