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

Line 75: FND_MSG_PUB.initialize;

71:
72: begin
73: -- Initialize message list if p_init_msg_list is set to TRUE.
74: IF FND_API.to_Boolean( p_init_msg_list ) THEN
75: FND_MSG_PUB.initialize;
76: END IF;
77:
78: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
79:

Line 87: FND_MSG_PUB.Add;

83:
84: IF (P_One_Question.mQuestionName is NULL OR P_One_Question.mQuestionName= FND_API.G_MISS_CHAR) THEN
85: X_Return_Status := FND_API.G_RET_STS_ERROR;
86: FND_MESSAGE.SET_NAME('CS','CS_TP_Question_NAME_INVALID');
87: FND_MSG_PUB.Add;
88: RAISE FND_API.G_EXC_ERROR;
89: END IF;
90:
91: IF (P_One_Question.mAnswerType is NULL OR P_One_Question.mAnswerType= FND_API.G_MISS_CHAR OR length(P_One_Question.mAnswerType)<=0)THEN

Line 94: FND_MSG_PUB.Add;

90:
91: IF (P_One_Question.mAnswerType is NULL OR P_One_Question.mAnswerType= FND_API.G_MISS_CHAR OR length(P_One_Question.mAnswerType)<=0)THEN
92: X_Return_Status := FND_API.G_RET_STS_ERROR;
93: FND_MESSAGE.SET_NAME('CS','CS_TP_Question_Answer_INVALID');
94: FND_MSG_PUB.Add;
95: RAISE FND_API.G_EXC_ERROR;
96: END IF;
97:
98: l_current_date := sysdate;

Line 179: FND_MSG_PUB.Count_And_Get

175: IF FND_API.To_Boolean( p_commit ) THEN
176: COMMIT WORK;
177: END IF;
178: -- Standard call to get message count and if count is 1, get message info.
179: FND_MSG_PUB.Count_And_Get
180: (p_count => x_msg_count ,
181: p_data => x_msg_data
182: );
183:

Line 186: FND_MSG_PUB.Count_And_Get

182: );
183:
184: EXCEPTION
185: WHEN FND_API.G_EXC_ERROR THEN
186: FND_MSG_PUB.Count_And_Get
187: (p_count => x_msg_count ,
188: p_data => x_msg_data
189: );
190:

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

190:
191:
192: WHEN OTHERS THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
195: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
196: END IF;
197: FND_MSG_PUB.Count_And_Get
198: (p_count => x_msg_count ,

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

191:
192: WHEN OTHERS THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
195: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
196: END IF;
197: FND_MSG_PUB.Count_And_Get
198: (p_count => x_msg_count ,
199: p_data => x_msg_data

Line 197: FND_MSG_PUB.Count_And_Get

193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
195: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
196: END IF;
197: FND_MSG_PUB.Count_And_Get
198: (p_count => x_msg_count ,
199: p_data => x_msg_data
200: );
201: raise;

Line 228: FND_MSG_PUB.initialize;

224:
225: begin
226: -- Initialize message list if p_init_msg_list is set to TRUE.
227: IF FND_API.to_Boolean( p_init_msg_list ) THEN
228: FND_MSG_PUB.initialize;
229: END IF;
230:
231: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
232:

Line 240: FND_MSG_PUB.Add;

236:
237: IF (P_One_Question.mQuestionName is NULL OR P_One_Question.mQuestionName= FND_API.G_MISS_CHAR) THEN
238: X_Return_Status := FND_API.G_RET_STS_ERROR;
239: FND_MESSAGE.SET_NAME('CS','CS_TP_Question_NAME_INVALID');
240: FND_MSG_PUB.Add;
241: RAISE FND_API.G_EXC_ERROR;
242: END IF;
243:
244: IF (P_One_Question.mAnswerType is NULL OR P_One_Question.mAnswerType= FND_API.G_MISS_CHAR OR length(P_One_Question.mAnswerType)<=0)THEN

Line 247: FND_MSG_PUB.Add;

243:
244: IF (P_One_Question.mAnswerType is NULL OR P_One_Question.mAnswerType= FND_API.G_MISS_CHAR OR length(P_One_Question.mAnswerType)<=0)THEN
245: X_Return_Status := FND_API.G_RET_STS_ERROR;
246: FND_MESSAGE.SET_NAME('CS','CS_TP_Question_Answer_INVALID');
247: FND_MSG_PUB.Add;
248: RAISE FND_API.G_EXC_ERROR;
249: END IF;
250:
251: --check to see if the question is modified after the client's query

Line 264: FND_MSG_PUB.Add;

260: -- is the last updated date from db later than the date from client
261: if (l_last_updated_date > TO_DATE (P_One_Question.mLast_Updated_Date, l_default_last_up_date_format )) then
262: X_Return_Status := FND_API.G_RET_STS_ERROR;
263: FND_MESSAGE.SET_NAME('CS','CS_TP_QUESTION_UPDATED');
264: FND_MSG_PUB.Add;
265: RAISE FND_API.G_EXC_ERROR;
266: end if;
267:
268: -- Update the question table , note lookup_id is not modified.

Line 298: FND_MSG_PUB.Count_And_Get

294: IF FND_API.To_Boolean( p_commit ) THEN
295: COMMIT WORK;
296: END IF;
297: -- Standard call to get message count and if count is 1, get message info.
298: FND_MSG_PUB.Count_And_Get
299: (p_count => x_msg_count ,
300: p_data => x_msg_data
301: );
302:

Line 305: FND_MSG_PUB.Count_And_Get

301: );
302:
303: EXCEPTION
304: WHEN FND_API.G_EXC_ERROR THEN
305: FND_MSG_PUB.Count_And_Get
306: (p_count => x_msg_count ,
307: p_data => x_msg_data
308: );
309:

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

309:
310:
311: WHEN OTHERS THEN
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
313: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
314: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
315: END IF;
316: FND_MSG_PUB.Count_And_Get
317: (p_count => x_msg_count ,

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

310:
311: WHEN OTHERS THEN
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
313: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
314: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
315: END IF;
316: FND_MSG_PUB.Count_And_Get
317: (p_count => x_msg_count ,
318: p_data => x_msg_data

Line 316: FND_MSG_PUB.Count_And_Get

312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
313: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
314: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
315: END IF;
316: FND_MSG_PUB.Count_And_Get
317: (p_count => x_msg_count ,
318: p_data => x_msg_data
319: );
320: raise;

Line 360: FND_MSG_PUB.initialize;

356:
357: begin
358: -- Initialize message list if p_init_msg_list is set to TRUE.
359: IF FND_API.to_Boolean( p_init_msg_list ) THEN
360: FND_MSG_PUB.initialize;
361: END IF;
362:
363: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
364:

Line 425: FND_MSG_PUB.Count_And_Get

421: IF FND_API.To_Boolean( p_commit ) THEN
422: COMMIT WORK;
423: END IF;
424: -- Standard call to get message count and if count is 1, get message info.
425: FND_MSG_PUB.Count_And_Get
426: (p_count => x_msg_count ,
427: p_data => x_msg_data
428: );
429:

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

429:
430: EXCEPTION
431: WHEN OTHERS THEN
432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
434: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
435: END IF;
436: FND_MSG_PUB.Count_And_Get
437: (p_count => x_msg_count ,

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

430: EXCEPTION
431: WHEN OTHERS THEN
432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
434: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
435: END IF;
436: FND_MSG_PUB.Count_And_Get
437: (p_count => x_msg_count ,
438: p_data => x_msg_data

Line 436: FND_MSG_PUB.Count_And_Get

432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
434: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
435: END IF;
436: FND_MSG_PUB.Count_And_Get
437: (p_count => x_msg_count ,
438: p_data => x_msg_data
439: );
440: raise;

Line 469: FND_MSG_PUB.initialize;

465: l_last_update_date DATE;
466: begin
467: -- Initialize message list if p_init_msg_list is set to TRUE.
468: IF FND_API.to_Boolean( p_init_msg_list ) THEN
469: FND_MSG_PUB.initialize;
470: END IF;
471:
472: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
473:

Line 491: FND_MSG_PUB.Add;

487: close last_updateC;
488: if (to_date( P_Questions(i).mLast_Updated_date, l_default_last_up_date_format) < l_last_update_date) then
489: X_Return_Status := FND_API.G_RET_STS_ERROR;
490: FND_MESSAGE.SET_NAME('CS','CS_TP_QUESTION_UPDATED');
491: FND_MSG_PUB.Add;
492: RAISE FND_API.G_EXC_ERROR;
493: end if;
494:
495: CS_TP_TEMPLATE_QUESTIONS_PKG.UPDATE_ROW (

Line 513: FND_MSG_PUB.Count_And_Get

509: IF FND_API.To_Boolean( p_commit ) THEN
510: COMMIT WORK;
511: END IF;
512: -- Standard call to get message count and if count is 1, get message info.
513: FND_MSG_PUB.Count_And_Get
514: (p_count => x_msg_count ,
515: p_data => x_msg_data
516: );
517:

Line 520: FND_MSG_PUB.Count_And_Get

516: );
517:
518: EXCEPTION
519: WHEN FND_API.G_EXC_ERROR THEN
520: FND_MSG_PUB.Count_And_Get
521: (p_count => x_msg_count ,
522: p_data => x_msg_data
523: );
524:

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

524:
525:
526: WHEN OTHERS THEN
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
528: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
529: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
530: END IF;
531: FND_MSG_PUB.Count_And_Get
532: (p_count => x_msg_count ,

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

525:
526: WHEN OTHERS THEN
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
528: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
529: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
530: END IF;
531: FND_MSG_PUB.Count_And_Get
532: (p_count => x_msg_count ,
533: p_data => x_msg_data

Line 531: FND_MSG_PUB.Count_And_Get

527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
528: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
529: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
530: END IF;
531: FND_MSG_PUB.Count_And_Get
532: (p_count => x_msg_count ,
533: p_data => x_msg_data
534: );
535: raise;

Line 576: FND_MSG_PUB.initialize;

572: L_SHOW_ON_CREATION_FLAG VARCHAR2(1);
573: begin
574: -- Initialize message list if p_init_msg_list is set to TRUE.
575: IF FND_API.to_Boolean( p_init_msg_list ) THEN
576: FND_MSG_PUB.initialize;
577: END IF;
578:
579: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
580:

Line 687: FND_MSG_PUB.Count_And_Get

683: IF FND_API.To_Boolean( p_commit) THEN
684: COMMIT WORK;
685: END IF;
686: -- Standard call to get message count and if count is 1, get message info.
687: FND_MSG_PUB.Count_And_Get
688: (p_count => x_msg_count,
689: p_data => x_msg_data
690: );
691:

Line 694: FND_MSG_PUB.Count_And_Get

690: );
691:
692: EXCEPTION
693: WHEN FND_API.G_EXC_ERROR THEN
694: FND_MSG_PUB.Count_And_Get
695: (p_count => x_msg_count ,
696: p_data => x_msg_data
697: );
698:

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

697: );
698:
699: WHEN OTHERS THEN
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
701: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
702: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
703: END IF;
704: FND_MSG_PUB.Count_And_Get
705: (p_count => x_msg_count ,

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

698:
699: WHEN OTHERS THEN
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
701: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
702: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
703: END IF;
704: FND_MSG_PUB.Count_And_Get
705: (p_count => x_msg_count ,
706: p_data => x_msg_data

Line 704: FND_MSG_PUB.Count_And_Get

700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
701: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
702: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
703: END IF;
704: FND_MSG_PUB.Count_And_Get
705: (p_count => x_msg_count ,
706: p_data => x_msg_data
707: );
708: raise;

Line 734: FND_MSG_PUB.initialize;

730:
731: begin
732: -- Initialize message list if p_init_msg_list is set to TRUE.
733: IF FND_API.to_Boolean( p_init_msg_list ) THEN
734: FND_MSG_PUB.initialize;
735: END IF;
736:
737: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
738:

Line 763: FND_MSG_PUB.Count_And_Get

759: IF FND_API.To_Boolean( p_commit) THEN
760: COMMIT WORK;
761: END IF;
762: -- Standard call to get message count and if count is 1, get message info.
763: FND_MSG_PUB.Count_And_Get
764: (p_count => x_msg_count ,
765: p_data => x_msg_data
766: );
767:

Line 770: FND_MSG_PUB.Count_And_Get

766: );
767:
768: EXCEPTION
769: WHEN FND_API.G_EXC_ERROR THEN
770: FND_MSG_PUB.Count_And_Get
771: (p_count => x_msg_count ,
772: p_data => x_msg_data
773: );
774:

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

773: );
774:
775: WHEN OTHERS THEN
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
777: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
778: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
779: END IF;
780: FND_MSG_PUB.Count_And_Get
781: (p_count => x_msg_count ,

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

774:
775: WHEN OTHERS THEN
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
777: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
778: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
779: END IF;
780: FND_MSG_PUB.Count_And_Get
781: (p_count => x_msg_count ,
782: p_data => x_msg_data

Line 780: FND_MSG_PUB.Count_And_Get

776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
777: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
778: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
779: END IF;
780: FND_MSG_PUB.Count_And_Get
781: (p_count => x_msg_count ,
782: p_data => x_msg_data
783: );
784: raise;