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

Line 37: FND_MSG_PUB.initialize;

33: l_max_sequence NUMBER;
34: begin
35: -- Initialize message list if p_init_msg_list is set to TRUE.
36: IF FND_API.to_Boolean( p_init_msg_list ) THEN
37: FND_MSG_PUB.initialize;
38: END IF;
39:
40: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
41:

Line 48: FND_MSG_PUB.Add;

44: -- Perform validation
45: IF (P_One_Choice.mChoiceName is NULL OR P_One_Choice.mChoiceName= FND_API.G_MISS_CHAR) THEN
46: X_Return_Status := FND_API.G_RET_STS_ERROR;
47: FND_MESSAGE.SET_NAME('CS','CS_TP_Choice_NAME_INVALID');
48: FND_MSG_PUB.Add;
49: RAISE FND_API.G_EXC_ERROR;
50: END IF;
51:
52: IF (P_One_Choice.mScore is NULL OR P_One_Choice.mScore = FND_API.G_MISS_NUM) then

Line 55: FND_MSG_PUB.Add;

51:
52: IF (P_One_Choice.mScore is NULL OR P_One_Choice.mScore = FND_API.G_MISS_NUM) then
53: X_Return_Status := FND_API.G_RET_STS_ERROR;
54: FND_MESSAGE.SET_NAME('CS','CS_TP_Choice_Score_INVALID');
55: FND_MSG_PUB.Add;
56: RAISE FND_API.G_EXC_ERROR;
57: END IF;
58:
59: open LookupC;

Line 65: FND_MSG_PUB.Add;

61: close LookupC;
62: if (l_lookup_count <1 or l_lookup_count>1) then
63: X_Return_Status := FND_API.G_RET_STS_ERROR;
64: FND_MESSAGE.SET_NAME('CS','CS_TP_LookUPID_INVALID');
65: FND_MSG_PUB.Add;
66: raise FND_API.G_EXC_UNEXPECTED_ERROR;
67: end if;
68:
69: open C;

Line 110: FND_MSG_PUB.Count_And_Get

106: IF FND_API.To_Boolean( p_commit ) THEN
107: COMMIT WORK;
108: END IF;
109: -- Standard call to get message count and if count is 1, get message info.
110: FND_MSG_PUB.Count_And_Get
111: (p_count => x_msg_count ,
112: p_data => x_msg_data
113: );
114:

Line 117: FND_MSG_PUB.Count_And_Get

113: );
114:
115: EXCEPTION
116: WHEN FND_API.G_EXC_ERROR THEN
117: FND_MSG_PUB.Count_And_Get
118: (p_count => x_msg_count ,
119: p_data => x_msg_data
120: );
121:

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

121:
122:
123: WHEN OTHERS THEN
124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
125: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
126: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
127: END IF;
128: FND_MSG_PUB.Count_And_Get
129: (p_count => x_msg_count ,

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

122:
123: WHEN OTHERS THEN
124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
125: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
126: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
127: END IF;
128: FND_MSG_PUB.Count_And_Get
129: (p_count => x_msg_count ,
130: p_data => x_msg_data

Line 128: FND_MSG_PUB.Count_And_Get

124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
125: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
126: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
127: END IF;
128: FND_MSG_PUB.Count_And_Get
129: (p_count => x_msg_count ,
130: p_data => x_msg_data
131: );
132: raise;

Line 151: FND_MSG_PUB.initialize;

147:
148: begin
149: -- Initialize message list if p_init_msg_list is set to TRUE.
150: IF FND_API.to_Boolean( p_init_msg_list ) THEN
151: FND_MSG_PUB.initialize;
152: END IF;
153:
154: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
155:

Line 169: FND_MSG_PUB.Count_And_Get

165: IF FND_API.To_Boolean( p_commit ) THEN
166: COMMIT WORK;
167: END IF;
168: -- Standard call to get message count and if count is 1, get message info.
169: FND_MSG_PUB.Count_And_Get
170: (p_count => x_msg_count ,
171: p_data => x_msg_data
172: );
173:

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

173:
174: EXCEPTION
175: WHEN OTHERS THEN
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
177: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
178: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
179: END IF;
180: FND_MSG_PUB.Count_And_Get
181: (p_count => x_msg_count ,

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

174: EXCEPTION
175: WHEN OTHERS THEN
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
177: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
178: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
179: END IF;
180: FND_MSG_PUB.Count_And_Get
181: (p_count => x_msg_count ,
182: p_data => x_msg_data

Line 180: FND_MSG_PUB.Count_And_Get

176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
177: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
178: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
179: END IF;
180: FND_MSG_PUB.Count_And_Get
181: (p_count => x_msg_count ,
182: p_data => x_msg_data
183: );
184: raise;

Line 214: FND_MSG_PUB.initialize;

210: l_last_update_date DATE;
211: begin
212: -- Initialize message list if p_init_msg_list is set to TRUE.
213: IF FND_API.to_Boolean( p_init_msg_list ) THEN
214: FND_MSG_PUB.initialize;
215: END IF;
216:
217: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
218:

Line 235: FND_MSG_PUB.Add;

231: close last_updateC;
232: if (to_date( P_Choices(i).mLast_Updated_date, l_default_last_up_date_format) < l_last_update_date) then
233: X_Return_Status := FND_API.G_RET_STS_ERROR;
234: FND_MESSAGE.SET_NAME('CS','CS_TP_CHOICE_UPDATED');
235: FND_MSG_PUB.Add;
236: RAISE FND_API.G_EXC_ERROR;
237: end if;
238: CS_TP_CHOICES_PKG.UPDATE_ROW (
239: X_CHOICE_ID => P_Choices (i).mChoiceID,

Line 259: FND_MSG_PUB.Count_And_Get

255: IF FND_API.To_Boolean( p_commit ) THEN
256: COMMIT WORK;
257: END IF;
258: -- Standard call to get message count and if count is 1, get message info.
259: FND_MSG_PUB.Count_And_Get
260: (p_count => x_msg_count ,
261: p_data => x_msg_data
262: );
263:

Line 266: FND_MSG_PUB.Count_And_Get

262: );
263:
264: EXCEPTION
265: WHEN FND_API.G_EXC_ERROR THEN
266: FND_MSG_PUB.Count_And_Get
267: (p_count => x_msg_count ,
268: p_data => x_msg_data
269: );
270:

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

270:
271:
272: WHEN OTHERS THEN
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
274: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
275: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
276: END IF;
277: FND_MSG_PUB.Count_And_Get
278: (p_count => x_msg_count ,

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

271:
272: WHEN OTHERS THEN
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
274: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
275: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
276: END IF;
277: FND_MSG_PUB.Count_And_Get
278: (p_count => x_msg_count ,
279: p_data => x_msg_data

Line 277: FND_MSG_PUB.Count_And_Get

273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
274: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
275: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
276: END IF;
277: FND_MSG_PUB.Count_And_Get
278: (p_count => x_msg_count ,
279: p_data => x_msg_data
280: );
281: raise;

Line 316: FND_MSG_PUB.initialize;

312: j NUMBER;
313: begin
314: -- Initialize message list if p_init_msg_list is set to TRUE.
315: IF FND_API.to_Boolean( p_init_msg_list ) THEN
316: FND_MSG_PUB.initialize;
317: END IF;
318:
319: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
320:

Line 382: FND_MSG_PUB.Count_And_Get

378: IF FND_API.To_Boolean( p_commit) THEN
379: COMMIT WORK;
380: END IF;
381: -- Standard call to get message count and if count is 1, get message info.
382: FND_MSG_PUB.Count_And_Get
383: (p_count => x_msg_count,
384: p_data => x_msg_data
385: );
386:

Line 389: FND_MSG_PUB.Count_And_Get

385: );
386:
387: EXCEPTION
388: WHEN FND_API.G_EXC_ERROR THEN
389: FND_MSG_PUB.Count_And_Get
390: (p_count => x_msg_count ,
391: p_data => x_msg_data
392: );
393:

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

392: );
393:
394: WHEN OTHERS THEN
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
396: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
397: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
398: END IF;
399: FND_MSG_PUB.Count_And_Get
400: (p_count => x_msg_count ,

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

393:
394: WHEN OTHERS THEN
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
396: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
397: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
398: END IF;
399: FND_MSG_PUB.Count_And_Get
400: (p_count => x_msg_count ,
401: p_data => x_msg_data

Line 399: FND_MSG_PUB.Count_And_Get

395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
396: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
397: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
398: END IF;
399: FND_MSG_PUB.Count_And_Get
400: (p_count => x_msg_count ,
401: p_data => x_msg_data
402: );
403: raise;

Line 434: FND_MSG_PUB.initialize;

430: l_login NUMBER :=FND_API.G_MISS_NUM;
431: begin
432: -- Initialize message list if p_init_msg_list is set to TRUE.
433: IF FND_API.to_Boolean( p_init_msg_list ) THEN
434: FND_MSG_PUB.initialize;
435: END IF;
436:
437: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
438:

Line 457: FND_MSG_PUB.Add;

453: if (to_date( P_Choices(i).mLast_Updated_date, l_default_last_up_date_format)
454: < l_last_update_date) then
455: X_Return_Status := FND_API.G_RET_STS_ERROR;
456: FND_MESSAGE.SET_NAME('CS','CS_TP_CHOICE_UPDATED');
457: FND_MSG_PUB.Add;
458: RAISE FND_API.G_EXC_ERROR;
459: end if;
460: */
461:

Line 486: FND_MSG_PUB.Count_And_Get

482: IF FND_API.To_Boolean( p_commit ) THEN
483: COMMIT WORK;
484: END IF;
485: -- Standard call to get message count and if count is 1, get message info.
486: FND_MSG_PUB.Count_And_Get
487: (p_count => x_msg_count ,
488: p_data => x_msg_data
489: );
490:

Line 493: FND_MSG_PUB.Count_And_Get

489: );
490:
491: EXCEPTION
492: WHEN FND_API.G_EXC_ERROR THEN
493: FND_MSG_PUB.Count_And_Get
494: (p_count => x_msg_count ,
495: p_data => x_msg_data
496: );
497:

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

497:
498:
499: WHEN OTHERS THEN
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
501: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
502: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
503: END IF;
504: FND_MSG_PUB.Count_And_Get
505: (p_count => x_msg_count ,

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

498:
499: WHEN OTHERS THEN
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
501: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
502: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
503: END IF;
504: FND_MSG_PUB.Count_And_Get
505: (p_count => x_msg_count ,
506: p_data => x_msg_data

Line 504: FND_MSG_PUB.Count_And_Get

500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
501: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
502: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
503: END IF;
504: FND_MSG_PUB.Count_And_Get
505: (p_count => x_msg_count ,
506: p_data => x_msg_data
507: );
508: --raise;

Line 544: FND_MSG_PUB.initialize;

540: l_freetext_count NUMBER;
541: begin
542: -- Initialize message list if p_init_msg_list is set to TRUE.
543: IF FND_API.to_Boolean( p_init_msg_list ) THEN
544: FND_MSG_PUB.initialize;
545: END IF;
546:
547: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
548:

Line 555: FND_MSG_PUB.Add;

551: -- Perform validation
552: IF (p_One_Freetext.mFreetextSize is NULL OR p_One_Freetext.mFreetextSize= FND_API.G_MISS_NUM) THEN
553: X_Return_Status := FND_API.G_RET_STS_ERROR;
554: FND_MESSAGE.SET_NAME('CS','CS_TP_FreetextSize_INVALID');
555: FND_MSG_PUB.Add;
556: RAISE FND_API.G_EXC_ERROR;
557: END IF;
558: open LookupC;
559: fetch LookupC into l_lookup_count;

Line 605: FND_MSG_PUB.Count_And_Get

601: IF FND_API.To_Boolean( p_commit ) THEN
602: COMMIT WORK;
603: END IF;
604: -- Standard call to get message count and if count is 1, get message info.
605: FND_MSG_PUB.Count_And_Get
606: (p_count => x_msg_count ,
607: p_data => x_msg_data
608: );
609:

Line 612: FND_MSG_PUB.Count_And_Get

608: );
609:
610: EXCEPTION
611: WHEN FND_API.G_EXC_ERROR THEN
612: FND_MSG_PUB.Count_And_Get
613: (p_count => x_msg_count ,
614: p_data => x_msg_data
615: );
616:

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

616:
617: /*
618: WHEN OTHERS THEN
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
620: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
621: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
622: END IF;
623: FND_MSG_PUB.Count_And_Get
624: (p_count => x_msg_count ,

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

617: /*
618: WHEN OTHERS THEN
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
620: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
621: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
622: END IF;
623: FND_MSG_PUB.Count_And_Get
624: (p_count => x_msg_count ,
625: p_data => x_msg_data

Line 623: FND_MSG_PUB.Count_And_Get

619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
620: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
621: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
622: END IF;
623: FND_MSG_PUB.Count_And_Get
624: (p_count => x_msg_count ,
625: p_data => x_msg_data
626: );
627: raise;

Line 661: FND_MSG_PUB.initialize;

657:
658: begin
659: -- Initialize message list if p_init_msg_list is set to TRUE.
660: IF FND_API.to_Boolean( p_init_msg_list ) THEN
661: FND_MSG_PUB.initialize;
662: END IF;
663:
664: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
665:

Line 693: FND_MSG_PUB.Count_And_Get

689: IF FND_API.To_Boolean( p_commit ) THEN
690: COMMIT WORK;
691: END IF;
692: -- Standard call to get message count and if count is 1, get message info.
693: FND_MSG_PUB.Count_And_Get
694: (p_count => x_msg_count ,
695: p_data => x_msg_data
696: );
697:

Line 700: FND_MSG_PUB.Count_And_Get

696: );
697:
698: EXCEPTION
699: WHEN FND_API.G_EXC_ERROR THEN
700: FND_MSG_PUB.Count_And_Get
701: (p_count => x_msg_count ,
702: p_data => x_msg_data
703: );
704:

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

704:
705: /*
706: WHEN OTHERS THEN
707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
708: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
709: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
710: END IF;
711: FND_MSG_PUB.Count_And_Get
712: (p_count => x_msg_count ,

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

705: /*
706: WHEN OTHERS THEN
707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
708: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
709: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
710: END IF;
711: FND_MSG_PUB.Count_And_Get
712: (p_count => x_msg_count ,
713: p_data => x_msg_data

Line 711: FND_MSG_PUB.Count_And_Get

707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
708: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
709: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
710: END IF;
711: FND_MSG_PUB.Count_And_Get
712: (p_count => x_msg_count ,
713: p_data => x_msg_data
714: );
715: raise;