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_CONSIGN_NOTIF_UTL dependencies on FND_API

Line 28: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

24: --===================
25: -- CONSTANTS
26: --===================
27: G_MODULE_PREFIX CONSTANT VARCHAR2(50) := 'inv.plsql.' || G_PKG_NAME || '.';
28: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
29: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
30: G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.login_id;
31:
32: --=============================================

Line 92: x_return_status := FND_API.G_RET_STS_SUCCESS;

88: , 'Entry');
89: END IF;
90: END IF;
91:
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: -- send notification to the user
95: SELECT mtl_consigned_diag_notif_s.NEXTVAL INTO l_item_key_s FROM DUAL;
96: l_item_key := l_item_key_prefix || to_char(l_item_key_s);

Line 170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

166: END IF;
167:
168: EXCEPTION
169: WHEN OTHERS THEN
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
171:
172: IF g_fnd_debug = 'Y' THEN
173: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
174: THEN

Line 193: -- p_init_msg_list REQUIRED FND_API.G_TRUE to reset the message list

189: -- Inventory Diagnostics errors to resolve.
190: --
191: -- PARAMETERS:
192: -- p_api_version REQUIRED API version
193: -- p_init_msg_list REQUIRED FND_API.G_TRUE to reset the message list
194: -- FND_API.G_FALSE to not reset it.
195: -- If pass NULL, it means FND_API.G_FALSE.
196: -- p_commit REQUIRED FND_API.G_TRUE to have API commit the change
197: -- FND_API.G_FALSE to not commit the change.

Line 194: -- FND_API.G_FALSE to not reset it.

190: --
191: -- PARAMETERS:
192: -- p_api_version REQUIRED API version
193: -- p_init_msg_list REQUIRED FND_API.G_TRUE to reset the message list
194: -- FND_API.G_FALSE to not reset it.
195: -- If pass NULL, it means FND_API.G_FALSE.
196: -- p_commit REQUIRED FND_API.G_TRUE to have API commit the change
197: -- FND_API.G_FALSE to not commit the change.
198: -- If pass NULL, it means FND_API.G_FALSE.

Line 195: -- If pass NULL, it means FND_API.G_FALSE.

191: -- PARAMETERS:
192: -- p_api_version REQUIRED API version
193: -- p_init_msg_list REQUIRED FND_API.G_TRUE to reset the message list
194: -- FND_API.G_FALSE to not reset it.
195: -- If pass NULL, it means FND_API.G_FALSE.
196: -- p_commit REQUIRED FND_API.G_TRUE to have API commit the change
197: -- FND_API.G_FALSE to not commit the change.
198: -- If pass NULL, it means FND_API.G_FALSE.
199: -- x_return_status REQUIRED Value can be

Line 196: -- p_commit REQUIRED FND_API.G_TRUE to have API commit the change

192: -- p_api_version REQUIRED API version
193: -- p_init_msg_list REQUIRED FND_API.G_TRUE to reset the message list
194: -- FND_API.G_FALSE to not reset it.
195: -- If pass NULL, it means FND_API.G_FALSE.
196: -- p_commit REQUIRED FND_API.G_TRUE to have API commit the change
197: -- FND_API.G_FALSE to not commit the change.
198: -- If pass NULL, it means FND_API.G_FALSE.
199: -- x_return_status REQUIRED Value can be
200: -- FND_API.G_RET_STS_SUCCESS

Line 197: -- FND_API.G_FALSE to not commit the change.

193: -- p_init_msg_list REQUIRED FND_API.G_TRUE to reset the message list
194: -- FND_API.G_FALSE to not reset it.
195: -- If pass NULL, it means FND_API.G_FALSE.
196: -- p_commit REQUIRED FND_API.G_TRUE to have API commit the change
197: -- FND_API.G_FALSE to not commit the change.
198: -- If pass NULL, it means FND_API.G_FALSE.
199: -- x_return_status REQUIRED Value can be
200: -- FND_API.G_RET_STS_SUCCESS
201: -- FND_API.G_RET_STS_ERROR

Line 198: -- If pass NULL, it means FND_API.G_FALSE.

194: -- FND_API.G_FALSE to not reset it.
195: -- If pass NULL, it means FND_API.G_FALSE.
196: -- p_commit REQUIRED FND_API.G_TRUE to have API commit the change
197: -- FND_API.G_FALSE to not commit the change.
198: -- If pass NULL, it means FND_API.G_FALSE.
199: -- x_return_status REQUIRED Value can be
200: -- FND_API.G_RET_STS_SUCCESS
201: -- FND_API.G_RET_STS_ERROR
202: -- FND_API.G_RET_STS_UNEXP_ERROR

Line 200: -- FND_API.G_RET_STS_SUCCESS

196: -- p_commit REQUIRED FND_API.G_TRUE to have API commit the change
197: -- FND_API.G_FALSE to not commit the change.
198: -- If pass NULL, it means FND_API.G_FALSE.
199: -- x_return_status REQUIRED Value can be
200: -- FND_API.G_RET_STS_SUCCESS
201: -- FND_API.G_RET_STS_ERROR
202: -- FND_API.G_RET_STS_UNEXP_ERROR
203: -- x_msg_count REQUIRED Number of messages on the message list
204: -- x_msg_data REQUIRED Return message data if message count is 1

Line 201: -- FND_API.G_RET_STS_ERROR

197: -- FND_API.G_FALSE to not commit the change.
198: -- If pass NULL, it means FND_API.G_FALSE.
199: -- x_return_status REQUIRED Value can be
200: -- FND_API.G_RET_STS_SUCCESS
201: -- FND_API.G_RET_STS_ERROR
202: -- FND_API.G_RET_STS_UNEXP_ERROR
203: -- x_msg_count REQUIRED Number of messages on the message list
204: -- x_msg_data REQUIRED Return message data if message count is 1
205: -- p_notification_resend_days

Line 202: -- FND_API.G_RET_STS_UNEXP_ERROR

198: -- If pass NULL, it means FND_API.G_FALSE.
199: -- x_return_status REQUIRED Value can be
200: -- FND_API.G_RET_STS_SUCCESS
201: -- FND_API.G_RET_STS_ERROR
202: -- FND_API.G_RET_STS_UNEXP_ERROR
203: -- x_msg_count REQUIRED Number of messages on the message list
204: -- x_msg_data REQUIRED Return message data if message count is 1
205: -- p_notification_resend_days
206: -- REQUIRED Number of days elapsed before resending

Line 267: IF FND_API.To_Boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN

263: , 'Entry');
264: END IF;
265: END IF;
266:
267: IF FND_API.To_Boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
268: FND_MSG_PUB.initialize;
269: END IF;
270:
271: IF NOT FND_API.Compatible_API_Call( l_api_version

Line 271: IF NOT FND_API.Compatible_API_Call( l_api_version

267: IF FND_API.To_Boolean(NVL(p_init_msg_list, FND_API.G_FALSE)) THEN
268: FND_MSG_PUB.initialize;
269: END IF;
270:
271: IF NOT FND_API.Compatible_API_Call( l_api_version
272: , p_api_version
273: , l_api_name
274: , G_PKG_NAME
275: )

Line 277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

273: , l_api_name
274: , G_PKG_NAME
275: )
276: THEN
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: END IF;
279:
280: x_return_status := FND_API.G_RET_STS_SUCCESS;
281:

Line 280: x_return_status := FND_API.G_RET_STS_SUCCESS;

276: THEN
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: END IF;
279:
280: x_return_status := FND_API.G_RET_STS_SUCCESS;
281:
282: SELECT DISTINCT agent_id BULK COLLECT INTO agent_id_tbl
283: FROM mtl_consigned_diag_errors
284: WHERE agent_id IS NOT NULL

Line 348: IF p_commit = FND_API.G_TRUE THEN

344: last_update_login = G_LOGIN_ID
345: WHERE notif_status_tbl(j) = G_RET_STS_SUCCESS
346: AND agent_id = agent_id_tbl(j);
347:
348: IF p_commit = FND_API.G_TRUE THEN
349: COMMIT;
350: END IF;
351:
352: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

366: ROLLBACK TO Send_Notification_PUB;
367: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
368: , p_data => x_msg_data);
369:
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371:
372: IF (g_fnd_debug = 'Y') THEN
373: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
374: THEN