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

Line 84: FND_MSG_PUB.ADD;

80: l_api_name ,
81: G_PKG_NAME )
82: THEN
83: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
84: FND_MSG_PUB.ADD;
85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87: -- Initialize message list if p_init_msg_list is set to TRUE.
88: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 89: FND_MSG_PUB.initialize;

85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87: -- Initialize message list if p_init_msg_list is set to TRUE.
88: IF FND_API.to_Boolean( p_init_msg_list ) THEN
89: FND_MSG_PUB.initialize;
90: END IF;
91: -- Initialize API return status to success
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93: --dbms_output.put_line('begin api-2');

Line 124: FND_MSG_PUB.ADD;

120: );
121:
122: IF SQL%NOTFOUND THEN
123: FND_MESSAGE.SET_NAME('WSH', 'WSH_INSERT_FAILED');
124: FND_MSG_PUB.ADD;
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: RAISE FND_API.G_EXC_ERROR ;
127: END IF;
128: --dbms_output.put_line('Seq Id got it '||l_parameter_ID||'success');

Line 138: FND_MSG_PUB.Count_And_Get

134: COMMIT WORK;
135: END IF;
136: -- Standard call to get message count and if count is 1,
137: -- get message info.
138: FND_MSG_PUB.Count_And_Get
139: ( p_count => x_msg_count,
140: p_data => x_msg_data
141: );
142:

Line 176: FND_MSG_PUB.ADD;

172: and T.LANGUAGE = L.LANGUAGE_CODE);
173:
174: IF SQL%NOTFOUND THEN
175: FND_MESSAGE.SET_NAME('WSH', 'WSH_INSERT_FAILED');
176: FND_MSG_PUB.ADD;
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: RAISE FND_API.G_EXC_ERROR ;
179: END IF;
180: --dbms_output.put_line('Seq Id got it '||l_parameter_ID||'success');

Line 190: FND_MSG_PUB.Count_And_Get

186: COMMIT WORK;
187: END IF;
188: -- Standard call to get message count and if count is 1,
189: -- get message info.
190: FND_MSG_PUB.Count_And_Get
191: ( p_count => x_msg_count,
192: p_data => x_msg_data
193: );
194:

Line 199: FND_MSG_PUB.Count_And_Get

195: EXCEPTION
196: WHEN FND_API.G_EXC_ERROR THEN
197: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;
198: x_return_status := FND_API.G_RET_STS_ERROR;
199: FND_MSG_PUB.Count_And_Get
200: ( p_count => x_msg_count,
201: p_data => x_msg_data
202: );
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 206: FND_MSG_PUB.Count_And_Get

202: );
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
204: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
206: FND_MSG_PUB.Count_And_Get
207: ( p_count => x_msg_count,
208: p_data => x_msg_data
209: );
210: WHEN OTHERS THEN

Line 213: IF FND_MSG_PUB.Check_Msg_Level

209: );
210: WHEN OTHERS THEN
211: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: IF FND_MSG_PUB.Check_Msg_Level
214: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
215: THEN
216: FND_MSG_PUB.Add_Exc_Msg
217: ( G_PKG_NAME ,

Line 214: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

210: WHEN OTHERS THEN
211: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: IF FND_MSG_PUB.Check_Msg_Level
214: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
215: THEN
216: FND_MSG_PUB.Add_Exc_Msg
217: ( G_PKG_NAME ,
218: l_api_name

Line 216: FND_MSG_PUB.Add_Exc_Msg

212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: IF FND_MSG_PUB.Check_Msg_Level
214: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
215: THEN
216: FND_MSG_PUB.Add_Exc_Msg
217: ( G_PKG_NAME ,
218: l_api_name
219: );
220: END IF;

Line 221: FND_MSG_PUB.Count_And_Get

217: ( G_PKG_NAME ,
218: l_api_name
219: );
220: END IF;
221: FND_MSG_PUB.Count_And_Get
222: ( p_count => x_msg_count,
223: p_data => x_msg_data
224: );
225:

Line 323: FND_MSG_PUB.ADD;

319: l_api_name ,
320: G_PKG_NAME )
321: THEN
322: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
323: FND_MSG_PUB.ADD;
324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
325: END IF;
326: -- Initialize message list if p_init_msg_list is set to TRUE.
327: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 328: FND_MSG_PUB.initialize;

324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
325: END IF;
326: -- Initialize message list if p_init_msg_list is set to TRUE.
327: IF FND_API.to_Boolean( p_init_msg_list ) THEN
328: FND_MSG_PUB.initialize;
329: END IF;
330: -- Initialize API return status to success
331: x_return_status := FND_API.G_RET_STS_SUCCESS;
332:

Line 462: FND_MSG_PUB.ADD;

458: l_api_name ,
459: G_PKG_NAME )
460: THEN
461: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
462: FND_MSG_PUB.ADD;
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465: -- Initialize message list if p_init_msg_list is set to TRUE.
466: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 467: FND_MSG_PUB.initialize;

463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END IF;
465: -- Initialize message list if p_init_msg_list is set to TRUE.
466: IF FND_API.to_Boolean( p_init_msg_list ) THEN
467: FND_MSG_PUB.initialize;
468: END IF;
469: -- Initialize API return status to success
470: x_return_status := FND_API.G_RET_STS_SUCCESS;
471:

Line 487: FND_MSG_PUB.ADD;

483: where PARAMETER_ID = P_PARAMETER_ID;
484:
485: IF SQL%NOTFOUND THEN
486: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_FAILED');
487: FND_MSG_PUB.ADD;
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: RAISE FND_API.G_EXC_ERROR ;
490: END IF;
491: --dbms_output.put_line('begin-5');

Line 501: FND_MSG_PUB.Count_And_Get

497: COMMIT WORK;
498: END IF;
499: -- Standard call to get message count and if count is 1,
500: -- get message info.
501: FND_MSG_PUB.Count_And_Get
502: ( p_count => x_msg_count,
503: p_data => x_msg_data
504: );
505:

Line 515: FND_MSG_PUB.ADD;

511: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
512:
513: IF SQL%NOTFOUND THEN
514: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_FAILED');
515: FND_MSG_PUB.ADD;
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: RAISE FND_API.G_EXC_ERROR ;
518: END IF;
519: --dbms_output.put_line('begin-5');

Line 529: FND_MSG_PUB.Count_And_Get

525: COMMIT WORK;
526: END IF;
527: -- Standard call to get message count and if count is 1,
528: -- get message info.
529: FND_MSG_PUB.Count_And_Get
530: ( p_count => x_msg_count,
531: p_data => x_msg_data
532: );
533:

Line 539: FND_MSG_PUB.Count_And_Get

535: WHEN FND_API.G_EXC_ERROR THEN
536: --dbms_output.put_line(sqlerrm);
537: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: FND_MSG_PUB.Count_And_Get
540: ( p_count => x_msg_count,
541: p_data => x_msg_data
542: );
543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 547: FND_MSG_PUB.Count_And_Get

543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
544: --dbms_output.put_line(sqlerrm);
545: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547: FND_MSG_PUB.Count_And_Get
548: ( p_count => x_msg_count,
549: p_data => x_msg_data
550: );
551: WHEN OTHERS THEN

Line 555: IF FND_MSG_PUB.Check_Msg_Level

551: WHEN OTHERS THEN
552: --dbms_output.put_line(sqlerrm);
553: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;
554: x_return_status := 'W';
555: IF FND_MSG_PUB.Check_Msg_Level
556: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
557: THEN
558: FND_MSG_PUB.Add_Exc_Msg
559: ( G_PKG_NAME ,

Line 556: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

552: --dbms_output.put_line(sqlerrm);
553: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;
554: x_return_status := 'W';
555: IF FND_MSG_PUB.Check_Msg_Level
556: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
557: THEN
558: FND_MSG_PUB.Add_Exc_Msg
559: ( G_PKG_NAME ,
560: l_api_name

Line 558: FND_MSG_PUB.Add_Exc_Msg

554: x_return_status := 'W';
555: IF FND_MSG_PUB.Check_Msg_Level
556: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
557: THEN
558: FND_MSG_PUB.Add_Exc_Msg
559: ( G_PKG_NAME ,
560: l_api_name
561: );
562: END IF;

Line 563: FND_MSG_PUB.Count_And_Get

559: ( G_PKG_NAME ,
560: l_api_name
561: );
562: END IF;
563: FND_MSG_PUB.Count_And_Get
564: ( p_count => x_msg_count,
565: p_data => x_msg_data
566: );
567:

Line 636: FND_MSG_PUB.ADD;

632: l_api_name ,
633: G_PKG_NAME )
634: THEN
635: FND_MESSAGE.SET_NAME('WSH', 'WSH_INCOMPATIBLE_API_CALL');
636: FND_MSG_PUB.ADD;
637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
638: END IF;
639: -- Initialize message list if p_init_msg_list is set to TRUE.
640: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 641: FND_MSG_PUB.initialize;

637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
638: END IF;
639: -- Initialize message list if p_init_msg_list is set to TRUE.
640: IF FND_API.to_Boolean( p_init_msg_list ) THEN
641: FND_MSG_PUB.initialize;
642: END IF;
643: -- Initialize API return status to success
644: x_return_status := FND_API.G_RET_STS_SUCCESS;
645:

Line 655: FND_MSG_PUB.ADD;

651: where PARAMETER_ID = P_PARAMETER_ID;
652:
653: IF SQL%NOTFOUND THEN
654: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');
655: FND_MSG_PUB.ADD;
656: x_return_status := FND_API.G_RET_STS_ERROR;
657: RAISE FND_API.G_EXC_ERROR ;
658: END IF;
659: --dbms_output.put_line('begin-5');

Line 669: FND_MSG_PUB.Count_And_Get

665: COMMIT WORK;
666: END IF;
667: -- Standard call to get message count and if count is 1,
668: -- get message info.
669: FND_MSG_PUB.Count_And_Get
670: ( p_count => x_msg_count,
671: p_data => x_msg_data
672: );
673:

Line 679: FND_MSG_PUB.ADD;

675: where PARAMETER_ID = p_PARAMETER_ID;
676:
677: IF SQL%NOTFOUND THEN
678: FND_MESSAGE.SET_NAME('WSH', 'WSH_DELETE_FAILED');
679: FND_MSG_PUB.ADD;
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: RAISE FND_API.G_EXC_ERROR ;
682: END IF;
683: --dbms_output.put_line('begin-5');

Line 693: FND_MSG_PUB.Count_And_Get

689: COMMIT WORK;
690: END IF;
691: -- Standard call to get message count and if count is 1,
692: -- 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 703: FND_MSG_PUB.Count_And_Get

699: WHEN FND_API.G_EXC_ERROR THEN
700: --dbms_output.put_line(sqlerrm);
701: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;
702: x_return_status := FND_API.G_RET_STS_ERROR;
703: FND_MSG_PUB.Count_And_Get
704: ( p_count => x_msg_count,
705: p_data => x_msg_data
706: );
707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 711: FND_MSG_PUB.Count_And_Get

707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
708: --dbms_output.put_line(sqlerrm);
709: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: FND_MSG_PUB.Count_And_Get
712: ( p_count => x_msg_count,
713: p_data => x_msg_data
714: );
715: WHEN OTHERS THEN

Line 719: IF FND_MSG_PUB.Check_Msg_Level

715: WHEN OTHERS THEN
716: --dbms_output.put_line(sqlerrm);
717: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;
718: x_return_status := 'W';
719: IF FND_MSG_PUB.Check_Msg_Level
720: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
721: THEN
722: FND_MSG_PUB.Add_Exc_Msg
723: ( G_PKG_NAME ,

Line 720: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

716: --dbms_output.put_line(sqlerrm);
717: ROLLBACK TO WSH_CC_PARAMETER_SETUPS_PKG;
718: x_return_status := 'W';
719: IF FND_MSG_PUB.Check_Msg_Level
720: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
721: THEN
722: FND_MSG_PUB.Add_Exc_Msg
723: ( G_PKG_NAME ,
724: l_api_name

Line 722: FND_MSG_PUB.Add_Exc_Msg

718: x_return_status := 'W';
719: IF FND_MSG_PUB.Check_Msg_Level
720: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
721: THEN
722: FND_MSG_PUB.Add_Exc_Msg
723: ( G_PKG_NAME ,
724: l_api_name
725: );
726: END IF;

Line 727: FND_MSG_PUB.Count_And_Get

723: ( G_PKG_NAME ,
724: l_api_name
725: );
726: END IF;
727: FND_MSG_PUB.Count_And_Get
728: ( p_count => x_msg_count,
729: p_data => x_msg_data
730: );
731: