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

Line 81: FND_MSG_PUB.initialize;

77: END IF;
78:
79: -- Initialize message list if p_init_msg_list is set to TRUE.
80: IF FND_API.to_Boolean(p_init_msg_list) THEN
81: FND_MSG_PUB.initialize;
82: END IF;
83:
84: -- Initialize API return status to success
85: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 132: FND_MSG_PUB.Add;

128: );
129:
130: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
131: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_CREATE_MSITE_RESP_FL');
132: FND_MSG_PUB.Add;
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
135: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_CREATE_MSITE_RESP_FL');
136: FND_MSG_PUB.Add;

Line 136: FND_MSG_PUB.Add;

132: FND_MSG_PUB.Add;
133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
134: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
135: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_CREATE_MSITE_RESP_FL');
136: FND_MSG_PUB.Add;
137: RAISE FND_API.G_EXC_ERROR;
138: END IF;
139:
140: END IF;

Line 153: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

149: COMMIT WORK;
150: END IF;
151:
152: -- Standard call to get message count and if count is 1, get message info.
153: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
154: p_data => x_msg_data,
155: p_encoded => 'F');
156:
157: EXCEPTION

Line 162: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

158:
159: WHEN FND_API.G_EXC_ERROR THEN
160: ROLLBACK TO Associate_Resps_To_Msite_Pvt;
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
163: p_data => x_msg_data,
164: p_encoded => 'F');
165:
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 169: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

165:
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: ROLLBACK TO Associate_Resps_To_Msite_Pvt;
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
170: p_data => x_msg_data,
171: p_encoded => 'F');
172:
173: WHEN OTHERS THEN

Line 179: FND_MSG_PUB.Add;

175: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
176: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
177: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
178: FND_MESSAGE.Set_Token('REASON', SQLERRM);
179: FND_MSG_PUB.Add;
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181:
182: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
183: THEN

Line 182: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

178: FND_MESSAGE.Set_Token('REASON', SQLERRM);
179: FND_MSG_PUB.Add;
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181:
182: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
183: THEN
184: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
185: END IF;
186:

Line 184: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181:
182: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
183: THEN
184: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
185: END IF;
186:
187: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
188: p_data => x_msg_data,

Line 187: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

183: THEN
184: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
185: END IF;
186:
187: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
188: p_data => x_msg_data,
189: p_encoded => 'F');
190:
191: END Associate_Resps_To_MSite;

Line 233: FND_MSG_PUB.initialize;

229: END IF;
230:
231: -- Initialize message list if p_init_msg_list is set to TRUE.
232: IF FND_API.to_Boolean(p_init_msg_list) THEN
233: FND_MSG_PUB.initialize;
234: END IF;
235:
236: -- Initialize API return status to success
237: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 264: FND_MSG_PUB.Add;

260: );
261:
262: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
263: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_DELETE_MSITE_RESP_FL');
264: FND_MSG_PUB.Add;
265: RAISE FND_API.G_EXC_ERROR;
266: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
267: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_DELETE_MSITE_RESP_FL');
268: FND_MSG_PUB.Add;

Line 268: FND_MSG_PUB.Add;

264: FND_MSG_PUB.Add;
265: RAISE FND_API.G_EXC_ERROR;
266: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
267: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_DELETE_MSITE_RESP_FL');
268: FND_MSG_PUB.Add;
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: END IF;
271:
272: ELSE

Line 296: FND_MSG_PUB.Add;

292: );
293:
294: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
295: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_UPDATE_MSITE_RESP_FL');
296: FND_MSG_PUB.Add;
297: RAISE FND_API.G_EXC_ERROR;
298: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
299: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_UPDATE_MSITE_RESP_FL');
300: FND_MSG_PUB.Add;

Line 300: FND_MSG_PUB.Add;

296: FND_MSG_PUB.Add;
297: RAISE FND_API.G_EXC_ERROR;
298: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
299: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_UPDATE_MSITE_RESP_FL');
300: FND_MSG_PUB.Add;
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: END IF;
303:
304: END IF;

Line 317: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

313: COMMIT WORK;
314: END IF;
315:
316: -- Standard call to get message count and if count is 1, get message info.
317: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
318: p_data => x_msg_data,
319: p_encoded => 'F');
320:
321: EXCEPTION

Line 326: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

322:
323: WHEN FND_API.G_EXC_ERROR THEN
324: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
325: x_return_status := FND_API.G_RET_STS_ERROR;
326: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
327: p_data => x_msg_data,
328: p_encoded => 'F');
329:
330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 333: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

329:
330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
331: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
333: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
334: p_data => x_msg_data,
335: p_encoded => 'F');
336:
337: WHEN OTHERS THEN

Line 341: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

337: WHEN OTHERS THEN
338: ROLLBACK TO Update_Delete_Msite_Resps_Pvt;
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
340:
341: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
342: THEN
343: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
344: END IF;
345:

Line 343: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
340:
341: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
342: THEN
343: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
344: END IF;
345:
346: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
347: p_data => x_msg_data,

Line 346: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

342: THEN
343: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
344: END IF;
345:
346: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
347: p_data => x_msg_data,
348: p_encoded => 'F');
349:
350: END Update_Delete_Msite_Resps;

Line 379: FND_MSG_PUB.initialize;

375: BEGIN
376:
377: -- Initialize message list if p_init_msg_list is set to TRUE.
378: IF FND_API.to_Boolean(p_init_msg_list) THEN
379: FND_MSG_PUB.initialize;
380: END IF;
381:
382: -- Initialize API return status to success
383: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 427: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

423: EXCEPTION
424:
425: WHEN FND_API.G_EXC_ERROR THEN
426: x_return_status := FND_API.G_RET_STS_ERROR;
427: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
428: p_data => x_msg_data,
429: p_encoded => 'F');
430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 433: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

429: p_encoded => 'F');
430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
433: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
434: p_data => x_msg_data,
435: p_encoded => 'F');
436:
437: WHEN OTHERS THEN

Line 440: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

436:
437: WHEN OTHERS THEN
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439:
440: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
441: THEN
442: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
443: END IF;
444:

Line 442: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
439:
440: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
441: THEN
442: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
443: END IF;
444:
445: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
446: p_data => x_msg_data,

Line 445: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

441: THEN
442: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
443: END IF;
444:
445: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
446: p_data => x_msg_data,
447: p_encoded => 'F');
448:
449: END Load_MsiteResps_For_Msite;

Line 500: FND_MSG_PUB.initialize;

496: END IF;
497:
498: -- Initialize message list if p_init_msg_list is set to TRUE.
499: IF FND_API.to_Boolean(p_init_msg_list) THEN
500: FND_MSG_PUB.initialize;
501: END IF;
502:
503: -- Initialize API return status to success
504: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 550: FND_MSG_PUB.Add;

546: --
547: IF (p_query_criteria IS NULL) THEN
548:
549: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_QUERY_CRIT_NULL');
550: FND_MSG_PUB.Add;
551: RAISE FND_API.G_EXC_ERROR;
552:
553: ELSIF (p_query_criteria = 'NAME') THEN
554:

Line 572: FND_MSG_PUB.Add;

568: ELSE
569: -- none of the query criteria specified
570: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_INVLD_QUERY_CRIT');
571: FND_MESSAGE.Set_Token('QUERY_CRITERIA', p_query_criteria);
572: FND_MSG_PUB.Add;
573: RAISE FND_API.G_EXC_ERROR;
574: END IF;
575:
576: --

Line 590: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

586: COMMIT WORK;
587: END IF;
588:
589: -- Standard call to get message count and if count is 1, get message info.
590: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
591: p_data => x_msg_data,
592: p_encoded => 'F');
593:
594: EXCEPTION

Line 598: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

594: EXCEPTION
595:
596: WHEN FND_API.G_EXC_ERROR THEN
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
599: p_data => x_msg_data,
600: p_encoded => 'F');
601:
602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 604: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

600: p_encoded => 'F');
601:
602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
604: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
605: p_data => x_msg_data,
606: p_encoded => 'F');
607:
608: WHEN OTHERS THEN

Line 613: FND_MSG_PUB.Add;

609: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
610: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
611: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
612: FND_MESSAGE.Set_Token('REASON', SQLERRM);
613: FND_MSG_PUB.Add;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615:
616: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
617: THEN

Line 616: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

612: FND_MESSAGE.Set_Token('REASON', SQLERRM);
613: FND_MSG_PUB.Add;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615:
616: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
617: THEN
618: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
619: END IF;
620:

Line 618: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615:
616: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
617: THEN
618: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
619: END IF;
620:
621: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
622: p_data => x_msg_data,

Line 621: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

617: THEN
618: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
619: END IF;
620:
621: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
622: p_data => x_msg_data,
623: p_encoded => 'F');
624:
625: END Get_Resp_Appl_Id_List;

Line 665: FND_MSG_PUB.initialize;

661: END IF;
662:
663: -- Initialize message list if p_init_msg_list is set to TRUE.
664: IF FND_API.to_Boolean(p_init_msg_list) THEN
665: FND_MSG_PUB.initialize;
666: END IF;
667:
668: -- Initialize API return status to success
669: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 676: FND_MSG_PUB.Add;

672: -- If there are no responsibilities in the input, then return error
673: --
674: IF (p_responsibility_ids.COUNT <= 0) THEN
675: FND_MESSAGE.Set_Name('JTF', 'JTF_MSITE_NO_RESPS_SPECIFIED');
676: FND_MSG_PUB.Add;
677: RAISE FND_API.G_EXC_ERROR;
678: END IF;
679:
680: --

Line 724: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

720: COMMIT WORK;
721: END IF;
722:
723: -- Standard call to get message count and if count is 1, get message info.
724: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
725: p_data => x_msg_data,
726: p_encoded => 'F');
727:
728: EXCEPTION

Line 732: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

728: EXCEPTION
729:
730: WHEN FND_API.G_EXC_ERROR THEN
731: x_return_status := FND_API.G_RET_STS_ERROR;
732: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
733: p_data => x_msg_data,
734: p_encoded => 'F');
735:
736: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 738: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

734: p_encoded => 'F');
735:
736: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
738: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
739: p_data => x_msg_data,
740: p_encoded => 'F');
741:
742: WHEN OTHERS THEN

Line 747: FND_MSG_PUB.Add;

743: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
744: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
745: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
746: FND_MESSAGE.Set_Token('REASON', SQLERRM);
747: FND_MSG_PUB.Add;
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749:
750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
751: THEN

Line 750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

746: FND_MESSAGE.Set_Token('REASON', SQLERRM);
747: FND_MSG_PUB.Add;
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749:
750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
751: THEN
752: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
753: END IF;
754:

Line 752: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749:
750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
751: THEN
752: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
753: END IF;
754:
755: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
756: p_data => x_msg_data,

Line 755: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,

751: THEN
752: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
753: END IF;
754:
755: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
756: p_data => x_msg_data,
757: p_encoded => 'F');
758:
759: END Get_Resp_Appl_Info_For_Lookup;