DBA Data[Home] [Help]

APPS.CSD_INTERNAL_ORDERS_PVT dependencies on FND_MSG_PUB

Line 109: FND_MSG_PUB.ADD;

105:
106: IF l_shipment_header_id.COUNT = 0
107: THEN
108: FND_MESSAGE.SET_NAME('CSD','CSD_INT_SHIPMENT_MIS');
109: FND_MSG_PUB.ADD;
110: RAISE fnd_api.g_exc_error;
111: END IF;
112:
113: -- the subinventory is not passed in and in the organization item setup,

Line 438: Fnd_Msg_Pub.initialize;

434: END IF;
435:
436: IF Fnd_Api.to_Boolean(p_init_msg_list)
437: THEN
438: Fnd_Msg_Pub.initialize;
439: END IF;
440:
441: x_return_status := G_RET_STS_SUCCESS;
442:

Line 537: Fnd_Msg_Pub.initialize;

533: END IF;
534:
535: IF Fnd_Api.to_Boolean(p_init_msg_list)
536: THEN
537: Fnd_Msg_Pub.initialize;
538: END IF;
539:
540: x_return_status := G_RET_STS_SUCCESS;
541: -- if the source and destination subinventories are passed in then we will use them

Line 604: FND_MSG_PUB.ADD;

600: AND msi.organization_id = p_destination_orgs(i);
601: EXCEPTION
602: WHEN no_data_found THEN
603: FND_MESSAGE.SET_NAME('CSD','CSD_MIS_ITEM_ORG_ASG');
604: FND_MSG_PUB.ADD;
605: RAISE fnd_api.g_exc_error;
606: END;
607: -- step 4. get the material account id.
608: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN

Line 753: fnd_msg_pub.add;

749: WHERE interface_source_line_id = p_product_txn_ids(1);
750: EXCEPTION
751: WHEN no_data_found THEN
752: fnd_message.set_name('CSD','CSD_INT_REQ_FAIL');
753: fnd_msg_pub.add;
754: RAISE fnd_api.g_exc_error;
755: END;
756:
757: EXCEPTION

Line 971: fnd_msg_pub.add;

967: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
968: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'ISO creation failed.');
969: END IF;
970: fnd_message.set_name('CSD','CSD_CREATE_ISO_FAIL');
971: fnd_msg_pub.add;
972: fnd_msg_pub.count_and_get(p_count => x_msg_count,
973: p_data => x_msg_data);
974: retcode := 2;
975: WHEN fnd_api.g_exc_error THEN

Line 972: fnd_msg_pub.count_and_get(p_count => x_msg_count,

968: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'ISO creation failed.');
969: END IF;
970: fnd_message.set_name('CSD','CSD_CREATE_ISO_FAIL');
971: fnd_msg_pub.add;
972: fnd_msg_pub.count_and_get(p_count => x_msg_count,
973: p_data => x_msg_data);
974: retcode := 2;
975: WHEN fnd_api.g_exc_error THEN
976: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN

Line 980: fnd_msg_pub.count_and_get(p_count => x_msg_count,

976: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
977: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'In g_exc_error');
978: END IF;
979: retcode := 2;
980: fnd_msg_pub.count_and_get(p_count => x_msg_count,
981: p_data => x_msg_data);
982: WHEN fnd_api.g_exc_unexpected_error THEN
983: null;
984: -- when others is specifically skipped here. Some thing totally unexpected has happened. Let the

Line 1042: fnd_msg_pub.initialize;

1038: END IF;
1039:
1040: IF fnd_api.to_boolean(p_init_msg_list)
1041: THEN
1042: fnd_msg_pub.initialize;
1043: END IF;
1044:
1045: G_DELIVERY_DETAIL_ID := NULL;
1046: -- if the shipped quantity is > 0 and < orig_quantity, then the OM order line was split.

Line 1074: fnd_msg_pub.add;

1070: IF l_order_rec.picking_rule_id IS NULL
1071: THEN
1072: fnd_message.set_name('CSD', 'CSD_INV_PICKING_RULE_ID');
1073: fnd_message.set_token('PICKING_RULE_ID',l_order_rec.picking_rule_id );
1074: fnd_msg_pub.add;
1075: RAISE fnd_api.g_exc_error;
1076: END IF;
1077:
1078: l_order_rec.order_header_id := p_order_header_id;

Line 1150: fnd_msg_pub.add;

1146: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1147: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'The delivery has been backordered.');
1148: END IF;
1149: fnd_message.set_name('CSD','CSD_NOT_PICK_RELEASED');
1150: fnd_msg_pub.add;
1151: RAISE fnd_api.g_exc_error;
1152:
1153: ELSIF l_dummy = 'S'
1154: THEN

Line 1159: fnd_msg_pub.add;

1155: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1156: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'The line needs to be transacted using transact move order.');
1157: END IF;
1158: fnd_message.set_name('CSD','CSD_TRANSACT_MOVE_ORDER');
1159: fnd_msg_pub.add;
1160: RAISE fnd_api.g_exc_error;
1161:
1162: ELSE
1163:

Line 1262: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1258: EXCEPTION
1259: WHEN fnd_api.g_exc_error
1260: THEN
1261: x_return_status := G_RET_STS_ERROR;
1262: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1263: p_data => x_msg_data);
1264:
1265: END pick_release_internal_order;
1266:

Line 1361: fnd_msg_pub.initialize;

1357: END IF;
1358:
1359: IF fnd_api.to_boolean(p_init_msg_list)
1360: THEN
1361: fnd_msg_pub.initialize;
1362: END IF;
1363:
1364: -- if the item is reservable, the item would have been reserved as part of the pick release activity.
1365: -- if the item is not reservable, then we would need to pass in the serial number, revision and lot number

Line 1389: FND_MSG_PUB.ADD;

1385: THEN
1386: IF p_fm_serial_num_tbl.COUNT = 0
1387: THEN
1388: FND_MESSAGE.SET_NAME('CSD','CSD_API_SERIAL_NUM_REQD');
1389: FND_MSG_PUB.ADD;
1390: RAISE FND_API.G_EXC_ERROR;
1391: END IF;
1392: END IF;
1393:

Line 1401: FND_MSG_PUB.ADD;

1397: IF p_lot_num IS NULL
1398: THEN
1399: FND_MESSAGE.SET_NAME('CSD','CSD_LOT_NUMBER_REQD');
1400: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
1401: FND_MSG_PUB.ADD;
1402: RAISE FND_API.G_EXC_ERROR;
1403: END IF;
1404: END IF;
1405:

Line 1413: FND_MSG_PUB.ADD;

1409: IF p_rev IS NULL
1410: THEN
1411: FND_MESSAGE.SET_NAME('CSD','CSD_ITEM_REVISION_REQD');
1412: FND_MESSAGE.SET_TOKEN('ITEM',l_item_name);
1413: FND_MSG_PUB.ADD;
1414: RAISE FND_API.G_EXC_ERROR;
1415: END IF;
1416: END IF;
1417: END IF; -- reservable check over.

Line 1523: Fnd_Msg_Pub.ADD;

1519: END IF;
1520: --dbms_output.put_line('Update shipping attributes failed '||x_msg_data);
1521: fnd_message.set_name('CSD','CSD_UPDATE_SHIPPING_FAILED');
1522: fnd_message.set_token('err_msg', x_msg_data);
1523: Fnd_Msg_Pub.ADD;
1524: RAISE fnd_api.g_exc_error;
1525: END IF;
1526: -- Return status check.
1527:

Line 1626: FND_MSG_PUB.ADD;

1622: END;
1623: IF l_shipped_flag = 'N' then
1624: FND_MESSAGE.SET_NAME('CSD','CSD_SHIP_CONFIRM_FAILED');
1625: FND_MESSAGE.SET_TOKEN('ERR_MSG',x_msg_data);
1626: FND_MSG_PUB.ADD;
1627: RAISE FND_API.G_EXC_ERROR;
1628: END IF;
1629: END IF;
1630:

Line 1670: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1666: x_msg_data := x_msg_summary || x_msg_details;
1667: ELSE
1668: x_msg_data := x_msg_summary;
1669: END IF;*/
1670: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1671: p_data => x_msg_data);
1672: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1673: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'Error in ship confirm action '||x_msg_data);
1674: END IF;

Line 1679: FND_MSG_PUB.ADD;

1675:
1676: x_return_status := fnd_api.g_ret_sts_error;
1677: WHEN no_data_found THEN
1678: FND_MESSAGE.SET_NAME('CSD','CSD_MISSING_DELIVERY');
1679: FND_MSG_PUB.ADD;
1680: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1681: p_data => x_msg_data);
1682: x_return_status := fnd_api.g_ret_sts_error;
1683: END ship_confirm_internal_order;

Line 1680: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1676: x_return_status := fnd_api.g_ret_sts_error;
1677: WHEN no_data_found THEN
1678: FND_MESSAGE.SET_NAME('CSD','CSD_MISSING_DELIVERY');
1679: FND_MSG_PUB.ADD;
1680: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1681: p_data => x_msg_data);
1682: x_return_status := fnd_api.g_ret_sts_error;
1683: END ship_confirm_internal_order;
1684:

Line 1796: fnd_msg_pub.initialize;

1792: END IF;
1793:
1794: IF fnd_api.to_boolean(p_init_msg_list)
1795: THEN
1796: fnd_msg_pub.initialize;
1797: END IF;
1798:
1799: x_return_status := G_RET_STS_SUCCESS;
1800: -- find if there is atleast quantity of 1 shipped for this internal order.

Line 1815: FND_MSG_PUB.ADD;

1811:
1812: IF l_dummy = 0
1813: THEN
1814: FND_MESSAGE.SET_NAME('CSD','CSD_INT_ORD_NOT_SHIPPED');
1815: FND_MSG_PUB.ADD;
1816: RAISE l_validation;
1817: END IF;
1818:
1819: -- validate if the internal requisition is already received based on shipping networks setup.

Line 1879: FND_MSG_PUB.ADD;

1875:
1876: IF l_received_quantity = l_dummy
1877: THEN
1878: FND_MESSAGE.SET_NAME('CSD','CSD_INT_ORD_RECEIVED');
1879: FND_MSG_PUB.ADD;
1880: x_msg_data := fnd_message.get;
1881: RETURN;
1882: END IF;
1883: END IF;

Line 1965: fnd_msg_pub.count_and_get(p_count => x_msg_count,

1961: WHEN l_validation THEN
1962: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
1963: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'Validation error:'||x_msg_data);
1964: END IF;
1965: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1966: p_data => x_msg_data);
1967: x_return_status := G_RET_STS_ERROR;
1968:
1969: END RECEIVE_INTERNAL_ORDER;

Line 2059: fnd_msg_pub.initialize;

2055: END IF;
2056:
2057: IF fnd_api.to_boolean(p_init_msg_list)
2058: THEN
2059: fnd_msg_pub.initialize;
2060: END IF;
2061:
2062: x_return_status := G_RET_STS_SUCCESS;
2063:

Line 2594: fnd_msg_pub.add;

2590: fnd_log.string(G_LEVEL_PROCEDURE, lc_api_name,'In release_batch exception');
2591: END IF;
2592: fnd_message.set_name('CSD', 'CSD_PICK_RELEASE_FAIL');
2593: fnd_message.set_token('BATCH_NAME', l_batch_name);
2594: fnd_msg_pub.add;
2595: x_return_status := G_RET_STS_ERROR;
2596: ROLLBACK TO RELEASE_SALESORDER;
2597: WHEN NO_DATA_FOUND THEN
2598: fnd_message.set_name('CSD', 'CSD_INV_ORDER_HEADER_ID');

Line 2600: fnd_msg_pub.add;

2596: ROLLBACK TO RELEASE_SALESORDER;
2597: WHEN NO_DATA_FOUND THEN
2598: fnd_message.set_name('CSD', 'CSD_INV_ORDER_HEADER_ID');
2599: fnd_message.set_token('ORDER_HEADER_ID',p_order_header_id);
2600: fnd_msg_pub.add;
2601: x_return_status := G_RET_STS_ERROR;
2602: ROLLBACK TO RELEASE_SALESORDER;
2603: WHEN ALLOCATION_ERROR THEN
2604: x_return_status := G_RET_STS_ERROR;