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

Line 60: FND_MSG_PUB.initialize;

56: --
57: SAVEPOINT Update_Row ;
58: --
59: if FND_API.to_Boolean (p_init_msg_list) then
60: FND_MSG_PUB.initialize;
61: end if;
62:
63: -- Initialize API return status to success
64:

Line 83: FND_MSG_PUB.Add ;

79: P_LAST_UPDATE_LOGIN := -1;
80: end if;
81: else
82: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
83: FND_MSG_PUB.Add ;
84: raise FND_API.G_EXC_ERROR ;
85: end if;
86: --
87:

Line 129: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

125: end if;
126:
127: -- Standard call to get message count and if count is 1, get message info.
128:
129: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
130: p_data => p_msg_data);
131: --
132: EXCEPTION
133:

Line 138: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

134: when FND_API.G_EXC_ERROR then
135: --
136: rollback to Update_Row ;
137: p_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
139: p_data => p_msg_data);
140: --
141: when FND_API.G_EXC_UNEXPECTED_ERROR then
142: --

Line 145: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

141: when FND_API.G_EXC_UNEXPECTED_ERROR then
142: --
143: rollback to Update_Row ;
144: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
146: p_data => p_msg_data);
147: --
148: when OTHERS then
149: --

Line 152: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

148: when OTHERS then
149: --
150: rollback to Update_Row ;
151: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
153: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
154: l_api_name);
155: end if;
156: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 153: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

149: --
150: rollback to Update_Row ;
151: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
153: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
154: l_api_name);
155: end if;
156: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
157: p_data => p_msg_data);

Line 156: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

152: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
153: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
154: l_api_name);
155: end if;
156: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
157: p_data => p_msg_data);
158: --
159:
160: END UPDATE_ROW;

Line 213: FND_MSG_PUB.initialize;

209: --
210: SAVEPOINT INSERT_ROW ;
211: --
212: if FND_API.to_Boolean (p_init_msg_list) then
213: FND_MSG_PUB.initialize;
214: end if;
215: --
216: p_return_status := FND_API.G_RET_STS_SUCCESS ;
217: --

Line 233: FND_MSG_PUB.Add ;

229: P_LAST_UPDATE_LOGIN := -1;
230: end if;
231: else
232: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
233: FND_MSG_PUB.Add ;
234: raise FND_API.G_EXC_ERROR;
235: end if;
236: --
237:

Line 316: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

312: if FND_API.to_Boolean (p_commit) then
313: commit work;
314: end if;
315: -- Standard call to get message count and if count is 1, get message info.
316: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
317: p_data => p_msg_data);
318: --
319: EXCEPTION
320: --

Line 325: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

321: when FND_API.G_EXC_ERROR then
322: --
323: rollback to INSERT_ROW ;
324: p_return_status := FND_API.G_RET_STS_ERROR;
325: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
326: p_data => p_msg_data);
327: --
328: when FND_API.G_EXC_UNEXPECTED_ERROR then
329: --

Line 332: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

328: when FND_API.G_EXC_UNEXPECTED_ERROR then
329: --
330: rollback to INSERT_ROW ;
331: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
333: p_data => p_msg_data);
334: --
335: when OTHERS then
336: --

Line 339: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

335: when OTHERS then
336: --
337: rollback to INSERT_ROW ;
338: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
340: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
341: l_api_name);
342: END if;
343: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 340: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

336: --
337: rollback to INSERT_ROW ;
338: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
340: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
341: l_api_name);
342: END if;
343: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
344: p_data => p_msg_data);

Line 343: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

339: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
340: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
341: l_api_name);
342: END if;
343: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
344: p_data => p_msg_data);
345: --
346: END INSERT_ROW;
347: --

Line 417: FND_MSG_PUB.initialize;

413: --
414: SAVEPOINT Lock_Row ;
415: --
416: if FND_API.to_Boolean (p_init_msg_list) then
417: FND_MSG_PUB.initialize;
418: end if;
419: --
420: p_return_status := FND_API.G_RET_STS_SUCCESS ;
421: p_row_locked := FND_API.G_TRUE ;

Line 427: fnd_msg_pub.add ;

423: open c1;
424: fetch c1 into tlinfo;
425: if (c1%notfound) then
426: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
427: fnd_msg_pub.add ;
428: close c1;
429: raise fnd_api.g_exc_error ;
430: end if;
431: close c1;

Line 492: fnd_msg_pub.add ;

488: ) then
489: null;
490: else
491: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
492: fnd_msg_pub.add ;
493: raise fnd_api.g_exc_error ;
494: end if;
495:
496: EXCEPTION

Line 502: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

498: --
499: rollback to LOCK_ROW ;
500: p_row_locked := FND_API.G_FALSE ;
501: p_return_status := FND_API.G_RET_STS_ERROR;
502: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
503: p_data => p_msg_data);
504: --
505: when FND_API.G_EXC_ERROR then
506: --

Line 509: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

505: when FND_API.G_EXC_ERROR then
506: --
507: rollback to LOCK_ROW ;
508: p_return_status := FND_API.G_RET_STS_ERROR;
509: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
510: p_data => p_msg_data);
511: --
512: when FND_API.G_EXC_UNEXPECTED_ERROR then
513: --

Line 516: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

512: when FND_API.G_EXC_UNEXPECTED_ERROR then
513: --
514: rollback to LOCK_ROW ;
515: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
516: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
517: p_data => p_msg_data);
518: --
519: when OTHERS then
520: --

Line 523: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

519: when OTHERS then
520: --
521: rollback to LOCK_ROW ;
522: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
523: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
524: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
525: l_api_name);
526: END if;
527: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 524: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

520: --
521: rollback to LOCK_ROW ;
522: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
523: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
524: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
525: l_api_name);
526: END if;
527: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
528: p_data => p_msg_data);

Line 527: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

523: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
524: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
525: l_api_name);
526: END if;
527: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
528: p_data => p_msg_data);
529: --
530: END LOCK_ROW;
531:

Line 557: FND_MSG_PUB.initialize;

553: --
554: -- Initialize message list if p_init_msg_list is set to TRUE.
555: --
556: if FND_API.to_Boolean (p_init_msg_list) then
557: FND_MSG_PUB.initialize;
558: end if;
559: --
560: p_return_status := FND_API.G_RET_STS_SUCCESS ;
561:

Line 577: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

573: end if;
574:
575: -- Standard call to get message count and if count is 1, get message info.
576:
577: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
578: p_data => p_msg_data);
579: --
580: EXCEPTION
581: when FND_API.G_EXC_ERROR then

Line 585: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

581: when FND_API.G_EXC_ERROR then
582: --
583: rollback to DELETE_ROW;
584: p_return_status := FND_API.G_RET_STS_ERROR;
585: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
586: p_data => p_msg_data);
587: --
588: when FND_API.G_EXC_UNEXPECTED_ERROR then
589: --

Line 592: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

588: when FND_API.G_EXC_UNEXPECTED_ERROR then
589: --
590: rollback to DELETE_ROW;
591: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
593: p_data => p_msg_data);
594: --
595: when OTHERS then
596: --

Line 599: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

595: when OTHERS then
596: --
597: rollback to DELETE_ROW ;
598: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
599: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
600: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
601: l_api_name);
602: end if;
603: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 600: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

596: --
597: rollback to DELETE_ROW ;
598: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
599: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
600: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
601: l_api_name);
602: end if;
603: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
604: p_data => p_msg_data);

Line 603: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

599: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
600: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
601: l_api_name);
602: end if;
603: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
604: p_data => p_msg_data);
605: --
606: END DELETE_ROW;
607: