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_DEFAULT_ASSIGNMENTS_PVT dependencies on FND_MSG_PUB

Line 65: FND_MSG_PUB.initialize;

61:
62: -- Initialize message list if p_init_msg_list is set to TRUE.
63:
64: if FND_API.to_Boolean (p_init_msg_list) then
65: FND_MSG_PUB.initialize;
66: end if;
67:
68: -- Initialize API return status to success
69:

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

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

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

138: rollback to INSERT_ROW_PVT;
139:
140: p_return_status := FND_API.G_RET_STS_ERROR;
141:
142: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
143: p_data => p_msg_data);
144:
145:
146: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

148: rollback to INSERT_ROW_PVT;
149:
150: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
151:
152: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
153: p_data => p_msg_data);
154:
155:
156: when OTHERS then

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

158: rollback to INSERT_ROW_PVT;
159:
160: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161:
162: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
163:
164: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
165: l_api_name);
166: end if;

Line 164: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

160: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161:
162: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
163:
164: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
165: l_api_name);
166: end if;
167:
168: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

164: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
165: l_api_name);
166: end if;
167:
168: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
169: p_data => p_msg_data);
170:
171: END INSERT_ROW;
172:

Line 222: FND_MSG_PUB.initialize;

218:
219: -- Initialize message list if p_init_msg_list is set to TRUE.
220:
221: if FND_API.to_Boolean (p_init_msg_list) then
222: FND_MSG_PUB.initialize;
223: end if;
224:
225: -- Initialize API return status to success
226:

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

258: end if;
259:
260: -- Standard call to get message count and if count is 1, get message info.
261:
262: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
263: p_data => p_msg_data);
264:
265: EXCEPTION
266:

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

269: rollback to UPDATE_ROW_PVT;
270:
271: p_return_status := FND_API.G_RET_STS_ERROR;
272:
273: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
274: p_data => p_msg_data);
275:
276:
277: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

279: rollback to UPDATE_ROW_PVT;
280:
281: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282:
283: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
284: p_data => p_msg_data);
285:
286:
287: when OTHERS then

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

289: rollback to UPDATE_ROW_PVT;
290:
291: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292:
293: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
294:
295: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
296: l_api_name);
297: end if;

Line 295: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

291: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292:
293: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
294:
295: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
296: l_api_name);
297: end if;
298:
299: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

295: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
296: l_api_name);
297: end if;
298:
299: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
300: p_data => p_msg_data);
301:
302: END UPDATE_ROW;
303:

Line 339: FND_MSG_PUB.initialize;

335:
336: -- Initialize message list if p_init_msg_list is set to TRUE.
337:
338: if FND_API.to_Boolean (p_init_msg_list) then
339: FND_MSG_PUB.initialize;
340: end if;
341:
342:
343: --Delete the record in the table

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

350: end if;
351:
352: -- Standard call to get message count and if count is 1, get message info.
353:
354: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
355: p_data => p_msg_data);
356:
357: -- Standard check of p_commit.
358:

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

368: rollback to DELETE_ROW_PVT;
369:
370: p_return_status := FND_API.G_RET_STS_ERROR;
371:
372: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
373: p_data => p_msg_data);
374:
375:
376: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

378: rollback to DELETE_ROW_PVT;
379:
380: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
381:
382: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
383: p_data => p_msg_data);
384:
385:
386: when OTHERS then

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

388: rollback to DELETE_ROW_PVT;
389:
390: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391:
392: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
393:
394: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
395: l_api_name);
396: end if;

Line 394: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

390: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391:
392: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
393:
394: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
395: l_api_name);
396: end if;
397:
398: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

394: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
395: l_api_name);
396: end if;
397:
398: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
399: p_data => p_msg_data);
400: END DELETE_ROW;
401:
402: PROCEDURE LOCK_ROW(

Line 452: FND_MSG_PUB.initialize ;

448: END IF;
449: --
450:
451: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
452: FND_MSG_PUB.initialize ;
453: END IF;
454: --
455: p_return_status := FND_API.G_RET_STS_SUCCESS ;
456: p_row_locked := FND_API.G_TRUE ;

Line 464: FND_MSG_PUB.Add;

460: FETCH C INTO Recinfo;
461: IF (C%NOTFOUND) then
462: CLOSE C;
463: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
464: FND_MSG_PUB.Add;
465: RAISE FND_API.G_EXC_ERROR ;
466: END IF;
467:
468: IF

Line 508: FND_MSG_PUB.Add;

504: THEN
505: Null;
506: ELSE
507: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
508: FND_MSG_PUB.Add;
509: RAISE FND_API.G_EXC_ERROR ;
510: END IF;
511:
512: --

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

513: IF FND_API.To_Boolean ( p_commit ) THEN
514: COMMIT WORK;
515: END iF;
516: --
517: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
518: p_data => p_msg_data );
519: --
520: EXCEPTION
521: --

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

523: --
524: ROLLBACK TO Lock_Row_Pvt ;
525: p_row_locked := FND_API.G_FALSE;
526: p_return_status := FND_API.G_RET_STS_ERROR;
527: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
528: p_data => p_msg_data );
529: --
530: WHEN FND_API.G_EXC_ERROR THEN
531: --

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

530: WHEN FND_API.G_EXC_ERROR THEN
531: --
532: ROLLBACK TO Lock_Row_Pvt ;
533: p_return_status := FND_API.G_RET_STS_ERROR;
534: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
535: p_data => p_msg_data );
536: --
537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
538: --

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

537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
538: --
539: ROLLBACK TO Lock_Row_Pvt ;
540: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
541: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
542: p_data => p_msg_data );
543: --
544: WHEN OTHERS THEN
545: --

Line 549: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

545: --
546: ROLLBACK TO Lock_Row_Pvt ;
547: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548: --
549: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
550: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
551: l_api_name);
552: END if;
553: --

Line 550: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

546: ROLLBACK TO Lock_Row_Pvt ;
547: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548: --
549: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
550: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
551: l_api_name);
552: END if;
553: --
554: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

550: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
551: l_api_name);
552: END if;
553: --
554: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
555: p_data => p_msg_data );
556: END LOCK_ROW;
557:
558: PROCEDURE Check_Unique

Line 609: FND_MSG_PUB.initialize ;

605: END IF;
606: --
607:
608: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
609: FND_MSG_PUB.initialize ;
610: END IF;
611: --
612: p_return_status := FND_API.G_RET_STS_SUCCESS ;
613: --

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

628: IF FND_API.To_Boolean ( p_commit ) THEN
629: COMMIT WORK;
630: END iF;
631: --
632: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
633: p_data => p_msg_data );
634: --
635: EXCEPTION
636: --

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

637: WHEN FND_API.G_EXC_ERROR THEN
638: --
639: ROLLBACK TO Check_Unique_Pvt ;
640: p_return_status := FND_API.G_RET_STS_ERROR;
641: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
642: p_data => p_msg_data );
643: --
644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
645: --

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

644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
645: --
646: ROLLBACK TO Check_Unique_Pvt ;
647: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
648: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
649: p_data => p_msg_data );
650: --
651: WHEN OTHERS THEN
652: --

Line 656: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

652: --
653: ROLLBACK TO Check_Unique_Pvt ;
654: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
655: --
656: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
657: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
658: l_api_name);
659: END if;
660: --

Line 657: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

653: ROLLBACK TO Check_Unique_Pvt ;
654: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
655: --
656: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
657: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
658: l_api_name);
659: END if;
660: --
661: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

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

657: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
658: l_api_name);
659: END if;
660: --
661: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
662: p_data => p_msg_data );
663: --
664: END Check_Unique;
665: