DBA Data[Home] [Help]

APPS.INV_LABEL_PVT8 dependencies on FND_MESSAGE

Line 1873: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');

1869: IF ( l_return_status <> fnd_api.g_ret_sts_success ) THEN
1870: IF (l_debug = 1) THEN
1871: trace('failed to genrate LPN');
1872: END IF;
1873: fnd_message.set_name('WMS', 'WMS_PRINT_LABEL_FAIL');
1874: fnd_msg_pub.ADD;
1875: END IF;
1876:
1877: l_wdd_tb(l_qty_index).outer_lpn_id := l_to_lpn_id;

Line 3764: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');

3760:
3761: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
3762: x_return_status := FND_API.G_RET_STS_SUCCESS;
3763: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3764: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3765: fnd_msg_pub.ADD;
3766: -- Fix for bug: 4179593 Start
3767: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3768: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

Line 3785: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');

3781: trace('Custom Labels Trace [INVLAP8B.pls]: WARNING: No row returned by the Custom SQL query');
3782: END IF;
3783: x_return_status := FND_API.G_RET_STS_SUCCESS;
3784: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3785: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3786: fnd_msg_pub.ADD;
3787: -- Fix for bug: 4179593 Start
3788: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3789: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

Line 3800: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');

3796: trace('Custom Labels Trace [INVLAP8B.pls]: ERROR: Multiple values returned by the Custom SQL query');
3797: END IF;
3798: x_return_status := FND_API.G_RET_STS_SUCCESS;
3799: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3800: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3801: fnd_msg_pub.ADD;
3802: -- Fix for bug: 4179593 Start
3803: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3804: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

Line 3822: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');

3818: trace('Custom Labels Trace [INVLAP8B.pls]: At Breadcrumb 5');
3819: trace('Custom Labels Trace [INVLAP8B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
3820: END IF;
3821: x_return_status := FND_API.G_RET_STS_ERROR;
3822: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3823: fnd_msg_pub.ADD;
3824: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3826: END;