DBA Data[Home] [Help]

APPS.INV_ITEM_SUB_DEFAULT_PKG dependencies on FND_MESSAGE

Line 53: FND_MESSAGE.SET_NAME('WMS','WMS_NULL_INPUT_PARAMETER');

49: THEN
50: IF (l_debug = 1) THEN
51: INV_TRX_UTIL_PUB.TRACE('One or more input parameter/s is/are null :','INSERT_UPDATE_ITEM_SUB_DEFAULTS',9);
52: END IF;
53: FND_MESSAGE.SET_NAME('WMS','WMS_NULL_INPUT_PARAMETER');
54: l_msg_count := l_msg_count + 1;
55: /* One of more input parameters provided are null */
56: RAISE fnd_api.g_exc_error;
57: END IF;

Line 64: FND_MESSAGE.SET_NAME('WMS','WMS_INVALID_DEFAULT_TYPE');

60: IF p_default_type NOT IN (1,2,3) THEN
61: IF (l_debug = 1) THEN
62: INV_TRX_UTIL_PUB.TRACE('p_default_type is not in 1, 2,3 ','INSERT_UPDATE_ITEM_SUB_DEFAULTS',9);
63: END IF;
64: FND_MESSAGE.SET_NAME('WMS','WMS_INVALID_DEFAULT_TYPE');
65: l_msg_count := l_msg_count + 1;
66: /*Invalid value for the Default_Type.The value should be either 1 or 2 or 3*/
67: RAISE fnd_api.g_exc_error;
68: END IF;

Line 74: FND_MESSAGE.SET_NAME('WMS','WMS_INVALID_PROCESS_CODE');

70: IF p_process_code NOT IN ('INSERT','UPDATE','SYNC') THEN
71: IF (l_debug = 1) THEN
72: INV_TRX_UTIL_PUB.TRACE('Invalid value for p_process_code','INSERT_UPDATE_ITEM_SUB_DEFAULTS',9);
73: END IF;
74: FND_MESSAGE.SET_NAME('WMS','WMS_INVALID_PROCESS_CODE');
75: l_msg_count := l_msg_count + 1;
76: RAISE fnd_api.g_exc_error;
77: /*Invalid value for the PROCESS CODE.The value should be either insert update or sync*/
78: END IF;

Line 89: FND_MESSAGE.SET_NAME('WMS','WMS_INVALID_SUBINVENTORY_CODE');

85: AND nvl(disable_date,sysdate+1) > sysdate
86: AND organization_id = p_organization_id;
87: EXCEPTION
88: WHEN no_data_found THEN
89: FND_MESSAGE.SET_NAME('WMS','WMS_INVALID_SUBINVENTORY_CODE');
90: l_msg_count := l_msg_count + 1;
91: RAISE fnd_api.g_exc_error;
92: END;
93: END IF;

Line 238: x_msg_data := FND_MESSAGE.GET;

234: IF (l_debug = 1) THEN
235: INV_TRX_UTIL_PUB.TRACE('In fnd_api.g_exc_error :'||SQLERRM,'INSERT_UPDATE_ITEM_SUB_DEFAULTS',9);
236: END IF;
237: ROLLBACK TO ins_upd_item_sub_dft;
238: x_msg_data := FND_MESSAGE.GET;
239: x_msg_count := l_msg_count;
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: x_return_status := fnd_api.g_ret_sts_unexp_error ;
242: IF (l_debug = 1) THEN

Line 246: x_msg_data := FND_MESSAGE.GET;

242: IF (l_debug = 1) THEN
243: INV_TRX_UTIL_PUB.TRACE('In FND_API.G_EXC_UNEXPECTED_ERROR :'||SQLERRM,'INSERT_UPDATE_ITEM_SUB_DEFAULTS',9);
244: END IF;
245: ROLLBACK TO ins_upd_item_sub_dft;
246: x_msg_data := FND_MESSAGE.GET;
247: x_msg_count := l_msg_count;
248: WHEN OTHERS THEN
249: x_return_status := fnd_api.g_ret_sts_unexp_error ;
250: IF (l_debug = 1) THEN

Line 254: x_msg_data := FND_MESSAGE.GET;

250: IF (l_debug = 1) THEN
251: INV_TRX_UTIL_PUB.TRACE('In when others :'||SQLERRM,'INSERT_UPDATE_ITEM_SUB_DEFAULTS',9);
252: END IF;
253: ROLLBACK TO ins_upd_item_sub_dft;
254: x_msg_data := FND_MESSAGE.GET;
255: x_msg_count := l_msg_count;
256: END INSERT_UPD_ITEM_SUB_DEFAULTS;
257: END INV_ITEM_SUB_DEFAULT_PKG;