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.INV_ITEM_SUB_DEFAULT_PKG dependencies on FND_API

Line 37: x_return_status := fnd_api.g_ret_sts_success;

33: INV_TRX_UTIL_PUB.TRACE('p_process_code :'||p_process_code,'INSERT_UPDATE_ITEM_SUB_DEFAULTS',9);
34: INV_TRX_UTIL_PUB.TRACE('p_commit :'||p_commit,'INSERT_UPDATE_ITEM_SUB_DEFAULTS',9);
35: END IF;
36: SAVEPOINT ins_upd_item_sub_dft;
37: x_return_status := fnd_api.g_ret_sts_success;
38:
39: /*Check if all the input parameters are passed */
40: IF (p_organization_id IS NULL OR
41: p_inventory_item_id IS NULL OR

Line 56: RAISE fnd_api.g_exc_error;

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;
58:
59: /*Check if the default is in 1,2,3. If not one among them, throw an exception */
60: IF p_default_type NOT IN (1,2,3) THEN

Line 67: RAISE fnd_api.g_exc_error;

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;
69:
70: IF p_process_code NOT IN ('INSERT','UPDATE','SYNC') THEN
71: IF (l_debug = 1) THEN

Line 76: RAISE fnd_api.g_exc_error;

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;
79:
80: IF p_subinventory_code IS NOT NULL THEN

Line 91: RAISE fnd_api.g_exc_error;

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;
94:
95: IF UPPER(p_process_code) = 'INSERT' THEN

Line 222: IF p_commit =fnd_api.g_true THEN

218: END IF;
219: END;
220: END IF;
221:
222: IF p_commit =fnd_api.g_true THEN
223: IF (l_debug = 1) THEN
224: INV_TRX_UTIL_PUB.TRACE('p_commit is true. Hence commiting the transaction ','INSERT_UPDATE_ITEM_SUB_DEFAULTS',9);
225: END IF;
226: COMMIT;

Line 232: WHEN fnd_api.g_exc_error THEN

228: IF (l_debug = 1) THEN
229: INV_TRX_UTIL_PUB.TRACE('Program completed successfully','INSERT_UPDATE_ITEM_SUB_DEFAULTS',9);
230: END IF;
231: EXCEPTION
232: WHEN fnd_api.g_exc_error THEN
233: x_return_status := fnd_api.g_ret_sts_error;
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;

Line 233: x_return_status := fnd_api.g_ret_sts_error;

229: INV_TRX_UTIL_PUB.TRACE('Program completed successfully','INSERT_UPDATE_ITEM_SUB_DEFAULTS',9);
230: END IF;
231: EXCEPTION
232: WHEN fnd_api.g_exc_error THEN
233: x_return_status := fnd_api.g_ret_sts_error;
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;

Line 235: INV_TRX_UTIL_PUB.TRACE('In fnd_api.g_exc_error :'||SQLERRM,'INSERT_UPDATE_ITEM_SUB_DEFAULTS',9);

231: EXCEPTION
232: WHEN fnd_api.g_exc_error THEN
233: x_return_status := fnd_api.g_ret_sts_error;
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;

Line 240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
243: INV_TRX_UTIL_PUB.TRACE('In FND_API.G_EXC_UNEXPECTED_ERROR :'||SQLERRM,'INSERT_UPDATE_ITEM_SUB_DEFAULTS',9);
244: END IF;

Line 241: x_return_status := fnd_api.g_ret_sts_unexp_error ;

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

Line 243: INV_TRX_UTIL_PUB.TRACE('In FND_API.G_EXC_UNEXPECTED_ERROR :'||SQLERRM,'INSERT_UPDATE_ITEM_SUB_DEFAULTS',9);

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

Line 249: x_return_status := fnd_api.g_ret_sts_unexp_error ;

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