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

Line 86: FND_MSG_PUB.initialize;

82: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
83: END IF;
84: -- Initialize message list if p_init_msg_list is set to TRUE.
85: IF FND_API.to_Boolean( p_init_msg_list ) THEN
86: FND_MSG_PUB.initialize;
87: END IF;
88: -- Initialize API return status to success
89: x_return_status := FND_API.G_RET_STS_SUCCESS;
90:

Line 128: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

124: END IF;
125: --------------------------------------------
126:
127: -- Standard call to get message count and if count is 1, get message info.
128: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
129:
130: IF (l_debug = 'Y') THEN
131: okc_debug.log('200: Leaving Validate_Allowed_Tmpl_Usages', 2);
132: END IF;

Line 141: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

137: okc_debug.log('300: Leaving Validate_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
138: END IF;
139: ROLLBACK TO g_Validate_Allowed_Usages_GRP;
140: x_return_status := G_RET_STS_ERROR ;
141: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
142:
143: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
144: IF (l_debug = 'Y') THEN
145: okc_debug.log('400: Leaving Validate_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 149: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

145: okc_debug.log('400: Leaving Validate_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
146: END IF;
147: ROLLBACK TO g_Validate_Allowed_Usages_GRP;
148: x_return_status := G_RET_STS_UNEXP_ERROR ;
149: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
150:
151: WHEN OTHERS THEN
152: IF (l_debug = 'Y') THEN
153: okc_debug.log('500: Leaving Validate_Allowed_Tmpl_Usages because of EXCEPTION: '||sqlerrm, 2);

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

154: END IF;
155:
156: ROLLBACK TO g_Validate_Allowed_Usages_GRP;
157: x_return_status := G_RET_STS_UNEXP_ERROR ;
158: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
159: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
160: END IF;
161: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
162:

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

155:
156: ROLLBACK TO g_Validate_Allowed_Usages_GRP;
157: x_return_status := G_RET_STS_UNEXP_ERROR ;
158: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
159: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
160: END IF;
161: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
162:
163: END Validate_Allowed_Tmpl_Usages;

Line 161: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

157: x_return_status := G_RET_STS_UNEXP_ERROR ;
158: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
159: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
160: END IF;
161: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
162:
163: END Validate_Allowed_Tmpl_Usages;
164:
165: -------------------------------------

Line 226: FND_MSG_PUB.initialize;

222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;
224: -- Initialize message list if p_init_msg_list is set to TRUE.
225: IF FND_API.to_Boolean( p_init_msg_list ) THEN
226: FND_MSG_PUB.initialize;
227: END IF;
228: -- Initialize API return status to success
229: x_return_status := FND_API.G_RET_STS_SUCCESS;
230:

Line 272: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

268: IF FND_API.To_Boolean( p_commit ) THEN
269: COMMIT WORK;
270: END IF;
271: -- Standard call to get message count and if count is 1, get message info.
272: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
273:
274: IF (l_debug = 'Y') THEN
275: okc_debug.log('700: Leaving Create_Allowed_Tmpl_Usages', 2);
276: END IF;

Line 285: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

281: okc_debug.log('800: Leaving Create_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
282: END IF;
283: ROLLBACK TO g_Create_Allowed_Usages_GRP;
284: x_return_status := G_RET_STS_ERROR ;
285: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
286:
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288: IF (l_debug = 'Y') THEN
289: okc_debug.log('900: Leaving Create_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 293: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

289: okc_debug.log('900: Leaving Create_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
290: END IF;
291: ROLLBACK TO g_Create_Allowed_Usages_GRP;
292: x_return_status := G_RET_STS_UNEXP_ERROR ;
293: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
294:
295: WHEN OTHERS THEN
296: IF (l_debug = 'Y') THEN
297: okc_debug.log('1000: Leaving Create_Allowed_Tmpl_Usages because of EXCEPTION: '||sqlerrm, 2);

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

298: END IF;
299:
300: ROLLBACK TO g_Create_Allowed_Usages_GRP;
301: x_return_status := G_RET_STS_UNEXP_ERROR ;
302: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
303: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
304: END IF;
305: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
306:

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

299:
300: ROLLBACK TO g_Create_Allowed_Usages_GRP;
301: x_return_status := G_RET_STS_UNEXP_ERROR ;
302: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
303: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
304: END IF;
305: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
306:
307: END Create_Allowed_Tmpl_Usages;

Line 305: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

301: x_return_status := G_RET_STS_UNEXP_ERROR ;
302: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
303: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
304: END IF;
305: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
306:
307: END Create_Allowed_Tmpl_Usages;
308: ---------------------------------------------------------------------------
309: -- PROCEDURE Lock_Allowed_Tmpl_Usages

Line 338: FND_MSG_PUB.initialize;

334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: END IF;
336: -- Initialize message list if p_init_msg_list is set to TRUE.
337: IF FND_API.to_Boolean( p_init_msg_list ) THEN
338: FND_MSG_PUB.initialize;
339: END IF;
340: -- Initialize API return status to success
341: x_return_status := FND_API.G_RET_STS_SUCCESS;
342:

Line 360: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

356: END IF;
357: --------------------------------------------
358:
359: -- Standard call to get message count and if count is 1, get message info.
360: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
361:
362: IF (l_debug = 'Y') THEN
363: okc_debug.log('1200: Leaving Lock_Allowed_Tmpl_Usages', 2);
364: END IF;

Line 373: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

369: okc_debug.log('1300: Leaving Lock_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
370: END IF;
371: ROLLBACK TO g_Lock_Allowed_Usages_GRP;
372: x_return_status := G_RET_STS_ERROR ;
373: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
374:
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376: IF (l_debug = 'Y') THEN
377: okc_debug.log('1400: Leaving Lock_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 381: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

377: okc_debug.log('1400: Leaving Lock_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
378: END IF;
379: ROLLBACK TO g_Lock_Allowed_Usages_GRP;
380: x_return_status := G_RET_STS_UNEXP_ERROR ;
381: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
382:
383: WHEN OTHERS THEN
384: IF (l_debug = 'Y') THEN
385: okc_debug.log('1500: Leaving Lock_Allowed_Tmpl_Usages because of EXCEPTION: '||sqlerrm, 2);

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

386: END IF;
387:
388: ROLLBACK TO g_Lock_Allowed_Usages_GRP;
389: x_return_status := G_RET_STS_UNEXP_ERROR ;
390: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
392: END IF;
393: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
394:

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

387:
388: ROLLBACK TO g_Lock_Allowed_Usages_GRP;
389: x_return_status := G_RET_STS_UNEXP_ERROR ;
390: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
392: END IF;
393: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
394:
395: END Lock_Allowed_Tmpl_Usages;

Line 393: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

389: x_return_status := G_RET_STS_UNEXP_ERROR ;
390: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
392: END IF;
393: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
394:
395: END Lock_Allowed_Tmpl_Usages;
396: ---------------------------------------------------------------------------
397: -- PROCEDURE Update_Allowed_Tmpl_Usages

Line 453: FND_MSG_PUB.initialize;

449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451: -- Initialize message list if p_init_msg_list is set to TRUE.
452: IF FND_API.to_Boolean( p_init_msg_list ) THEN
453: FND_MSG_PUB.initialize;
454: END IF;
455: -- Initialize API return status to success
456: x_return_status := FND_API.G_RET_STS_SUCCESS;
457:

Line 499: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

495: IF FND_API.To_Boolean( p_commit ) THEN
496: COMMIT WORK;
497: END IF;
498: -- Standard call to get message count and if count is 1, get message info.
499: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
500:
501: IF (l_debug = 'Y') THEN
502: okc_debug.log('1800: Leaving Update_Allowed_Tmpl_Usages', 2);
503: END IF;

Line 512: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

508: okc_debug.log('1900: Leaving Update_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
509: END IF;
510: ROLLBACK TO g_Update_Allowed_Usages_GRP;
511: x_return_status := G_RET_STS_ERROR ;
512: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
513:
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: IF (l_debug = 'Y') THEN
516: okc_debug.log('2000: Leaving Update_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 520: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

516: okc_debug.log('2000: Leaving Update_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
517: END IF;
518: ROLLBACK TO g_Update_Allowed_Usages_GRP;
519: x_return_status := G_RET_STS_UNEXP_ERROR ;
520: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
521:
522: WHEN OTHERS THEN
523: IF (l_debug = 'Y') THEN
524: okc_debug.log('2100: Leaving Update_Allowed_Tmpl_Usages because of EXCEPTION: '||sqlerrm, 2);

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

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

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

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

Line 532: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

Line 567: FND_MSG_PUB.initialize;

563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
564: END IF;
565: -- Initialize message list if p_init_msg_list is set to TRUE.
566: IF FND_API.to_Boolean( p_init_msg_list ) THEN
567: FND_MSG_PUB.initialize;
568: END IF;
569: -- Initialize API return status to success
570: x_return_status := FND_API.G_RET_STS_SUCCESS;
571:

Line 593: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

589: IF FND_API.To_Boolean( p_commit ) THEN
590: COMMIT WORK;
591: END IF;
592: -- Standard call to get message count and if count is 1, get message info.
593: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
594:
595: IF (l_debug = 'Y') THEN
596: okc_debug.log('2300: Leaving Delete_Allowed_Tmpl_Usages', 2);
597: END IF;

Line 606: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

602: okc_debug.log('2400: Leaving Delete_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_ERROR Exception', 2);
603: END IF;
604: ROLLBACK TO g_Delete_Allowed_Usages_GRP;
605: x_return_status := G_RET_STS_ERROR ;
606: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
607:
608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
609: IF (l_debug = 'Y') THEN
610: okc_debug.log('2500: Leaving Delete_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 614: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

610: okc_debug.log('2500: Leaving Delete_Allowed_Tmpl_Usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
611: END IF;
612: ROLLBACK TO g_Delete_Allowed_Usages_GRP;
613: x_return_status := G_RET_STS_UNEXP_ERROR ;
614: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
615:
616: WHEN OTHERS THEN
617: IF (l_debug = 'Y') THEN
618: okc_debug.log('2600: Leaving Delete_Allowed_Tmpl_Usages because of EXCEPTION: '||sqlerrm, 2);

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

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

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

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

Line 626: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

622: x_return_status := G_RET_STS_UNEXP_ERROR ;
623: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
624: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
625: END IF;
626: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
627:
628: END Delete_Allowed_Tmpl_Usages;
629:
630: END OKC_ALLOWED_TMPL_USAGES_GRP;