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.WSH_ITM_USERS_PKG dependencies on FND_MSG_PUB

Line 83: FND_MSG_PUB.ADD;

79: l_api_name ,
80: G_PKG_NAME )
81: THEN
82: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
83: FND_MSG_PUB.ADD;
84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86: -- Initialize message list if p_init_msg_list is set to TRUE.
87: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 88: FND_MSG_PUB.initialize;

84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86: -- Initialize message list if p_init_msg_list is set to TRUE.
87: IF FND_API.to_Boolean( p_init_msg_list ) THEN
88: FND_MSG_PUB.initialize;
89: END IF;
90: -- Initialize API return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92: --dbms_output.put_line('begin api-2');

Line 130: FND_MSG_PUB.ADD;

126: ,FND_GLOBAL.login_id
127: ) ;
128: IF SQL%NOTFOUND THEN
129: FND_MESSAGE.SET_NAME('WSH', 'WSH_INSERT_FAILED');
130: FND_MSG_PUB.ADD;
131: x_return_status := FND_API.G_RET_STS_ERROR;
132: RAISE FND_API.G_EXC_ERROR ;
133: END IF;
134: --dbms_output.put_line('Seq Id got it '||l_ITM_USER_SEQUENCE_ID||'success');

Line 144: FND_MSG_PUB.Count_And_Get

140: COMMIT WORK;
141: END IF;
142: -- Standard call to get message count and if count is 1,
143: -- get message info.
144: FND_MSG_PUB.Count_And_Get
145: ( p_count => x_msg_count,
146: p_data => x_msg_data
147: );
148:

Line 153: FND_MSG_PUB.Count_And_Get

149: EXCEPTION
150: WHEN FND_API.G_EXC_ERROR THEN
151: ROLLBACK TO WSH_ITM_USERS_PKG;
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MSG_PUB.Count_And_Get
154: ( p_count => x_msg_count,
155: p_data => x_msg_data
156: );
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 160: FND_MSG_PUB.Count_And_Get

156: );
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: ROLLBACK TO WSH_ITM_USERS_PKG;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: FND_MSG_PUB.Count_And_Get
161: ( p_count => x_msg_count,
162: p_data => x_msg_data
163: );
164: WHEN OTHERS THEN

Line 167: IF FND_MSG_PUB.Check_Msg_Level

163: );
164: WHEN OTHERS THEN
165: ROLLBACK TO WSH_ITM_USERS_PKG;
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: IF FND_MSG_PUB.Check_Msg_Level
168: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
169: THEN
170: FND_MSG_PUB.Add_Exc_Msg
171: ( G_PKG_NAME ,

Line 168: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

164: WHEN OTHERS THEN
165: ROLLBACK TO WSH_ITM_USERS_PKG;
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: IF FND_MSG_PUB.Check_Msg_Level
168: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
169: THEN
170: FND_MSG_PUB.Add_Exc_Msg
171: ( G_PKG_NAME ,
172: l_api_name

Line 170: FND_MSG_PUB.Add_Exc_Msg

166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: IF FND_MSG_PUB.Check_Msg_Level
168: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
169: THEN
170: FND_MSG_PUB.Add_Exc_Msg
171: ( G_PKG_NAME ,
172: l_api_name
173: );
174: END IF;

Line 175: FND_MSG_PUB.Count_And_Get

171: ( G_PKG_NAME ,
172: l_api_name
173: );
174: END IF;
175: FND_MSG_PUB.Count_And_Get
176: ( p_count => x_msg_count,
177: p_data => x_msg_data
178: );
179: End Insert_Row;

Line 260: FND_MSG_PUB.ADD;

256: l_api_name ,
257: G_PKG_NAME )
258: THEN
259: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
260: FND_MSG_PUB.ADD;
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;
263:
264: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 266: FND_MSG_PUB.initialize;

262: END IF;
263:
264: -- Initialize message list if p_init_msg_list is set to TRUE.
265: IF FND_API.to_Boolean( p_init_msg_list ) THEN
266: FND_MSG_PUB.initialize;
267: END IF;
268:
269: -- Initialize API return status to success
270: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 293: FND_MSG_PUB.ADD;

289:
290:
291: IF SQL%NOTFOUND THEN
292: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_FAILED');
293: FND_MSG_PUB.ADD;
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: RAISE FND_API.G_EXC_ERROR ;
296: END IF;
297:

Line 310: FND_MSG_PUB.Count_And_Get

306:
307: -- Standard call to get message count and if count is 1,
308: -- get message info.
309:
310: FND_MSG_PUB.Count_And_Get
311: ( p_count => x_msg_count,
312: p_data => x_msg_data
313: );
314:

Line 319: FND_MSG_PUB.Count_And_Get

315: EXCEPTION
316: WHEN FND_API.G_EXC_ERROR THEN
317: ROLLBACK TO WSH_ITM_USERS_PKG;
318: x_return_status := FND_API.G_RET_STS_ERROR;
319: FND_MSG_PUB.Count_And_Get
320: ( p_count => x_msg_count,
321: p_data => x_msg_data
322: );
323:

Line 327: FND_MSG_PUB.Count_And_Get

323:
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
325: ROLLBACK TO WSH_ITM_USERS_PKG;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: FND_MSG_PUB.Count_And_Get
328: ( p_count => x_msg_count,
329: p_data => x_msg_data
330: );
331:

Line 335: IF FND_MSG_PUB.Check_Msg_Level

331:
332: WHEN OTHERS THEN
333: ROLLBACK TO WSH_ITM_USERS_PKG;
334: x_return_status := 'W';
335: IF FND_MSG_PUB.Check_Msg_Level
336: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
337: THEN
338: FND_MSG_PUB.Add_Exc_Msg
339: ( G_PKG_NAME ,

Line 336: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

332: WHEN OTHERS THEN
333: ROLLBACK TO WSH_ITM_USERS_PKG;
334: x_return_status := 'W';
335: IF FND_MSG_PUB.Check_Msg_Level
336: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
337: THEN
338: FND_MSG_PUB.Add_Exc_Msg
339: ( G_PKG_NAME ,
340: l_api_name

Line 338: FND_MSG_PUB.Add_Exc_Msg

334: x_return_status := 'W';
335: IF FND_MSG_PUB.Check_Msg_Level
336: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
337: THEN
338: FND_MSG_PUB.Add_Exc_Msg
339: ( G_PKG_NAME ,
340: l_api_name
341: );
342: END IF;

Line 344: FND_MSG_PUB.Count_And_Get

340: l_api_name
341: );
342: END IF;
343:
344: FND_MSG_PUB.Count_And_Get
345: ( p_count => x_msg_count,
346: p_data => x_msg_data
347: );
348:

Line 414: FND_MSG_PUB.ADD;

410: l_api_name ,
411: G_PKG_NAME )
412: THEN
413: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
414: FND_MSG_PUB.ADD;
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417: -- Initialize message list if p_init_msg_list is set to TRUE.
418: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 419: FND_MSG_PUB.initialize;

415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: END IF;
417: -- Initialize message list if p_init_msg_list is set to TRUE.
418: IF FND_API.to_Boolean( p_init_msg_list ) THEN
419: FND_MSG_PUB.initialize;
420: END IF;
421: -- Initialize API return status to success
422: x_return_status := FND_API.G_RET_STS_SUCCESS;
423:

Line 431: FND_MSG_PUB.ADD;

427: DELETE from wsh_itm_user_setups
428: WHERE itm_user_sequence_id = p_itm_user_sequence_id ;
429: IF SQL%NOTFOUND THEN
430: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');
431: FND_MSG_PUB.ADD;
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: RAISE FND_API.G_EXC_ERROR ;
434: END IF;
435: --dbms_output.put_line('begin-5');

Line 445: FND_MSG_PUB.Count_And_Get

441: COMMIT WORK;
442: END IF;
443: -- Standard call to get message count and if count is 1,
444: -- get message info.
445: FND_MSG_PUB.Count_And_Get
446: ( p_count => x_msg_count,
447: p_data => x_msg_data
448: );
449:

Line 455: FND_MSG_PUB.Count_And_Get

451: WHEN FND_API.G_EXC_ERROR THEN
452: --dbms_output.put_line(sqlerrm);
453: ROLLBACK TO WSH_ITM_USERS_PKG;
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: FND_MSG_PUB.Count_And_Get
456: ( p_count => x_msg_count,
457: p_data => x_msg_data
458: );
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 463: FND_MSG_PUB.Count_And_Get

459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: --dbms_output.put_line(sqlerrm);
461: ROLLBACK TO WSH_ITM_USERS_PKG;
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: FND_MSG_PUB.Count_And_Get
464: ( p_count => x_msg_count,
465: p_data => x_msg_data
466: );
467: WHEN OTHERS THEN

Line 471: IF FND_MSG_PUB.Check_Msg_Level

467: WHEN OTHERS THEN
468: --dbms_output.put_line(sqlerrm);
469: ROLLBACK TO WSH_ITM_USERS_PKG;
470: x_return_status := 'W';
471: IF FND_MSG_PUB.Check_Msg_Level
472: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
473: THEN
474: FND_MSG_PUB.Add_Exc_Msg
475: ( G_PKG_NAME ,

Line 472: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

468: --dbms_output.put_line(sqlerrm);
469: ROLLBACK TO WSH_ITM_USERS_PKG;
470: x_return_status := 'W';
471: IF FND_MSG_PUB.Check_Msg_Level
472: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
473: THEN
474: FND_MSG_PUB.Add_Exc_Msg
475: ( G_PKG_NAME ,
476: l_api_name

Line 474: FND_MSG_PUB.Add_Exc_Msg

470: x_return_status := 'W';
471: IF FND_MSG_PUB.Check_Msg_Level
472: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
473: THEN
474: FND_MSG_PUB.Add_Exc_Msg
475: ( G_PKG_NAME ,
476: l_api_name
477: );
478: END IF;

Line 479: FND_MSG_PUB.Count_And_Get

475: ( G_PKG_NAME ,
476: l_api_name
477: );
478: END IF;
479: FND_MSG_PUB.Count_And_Get
480: ( p_count => x_msg_count,
481: p_data => x_msg_data
482: );
483:

Line 573: FND_MSG_PUB.ADD;

569: l_api_name ,
570: G_PKG_NAME )
571: THEN
572: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
573: FND_MSG_PUB.ADD;
574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
575: END IF;
576:
577: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 579: FND_MSG_PUB.initialize;

575: END IF;
576:
577: -- Initialize message list if p_init_msg_list is set to TRUE.
578: IF FND_API.to_Boolean( p_init_msg_list ) THEN
579: FND_MSG_PUB.initialize;
580: END IF;
581:
582: -- Initialize API return status to success
583: x_return_status := FND_API.G_RET_STS_SUCCESS;