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

Line 92: FND_MSG_PUB.initialize;

88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90: -- Initialize message list if p_init_msg_list is set to TRUE.
91: IF FND_API.to_Boolean( p_init_msg_list ) THEN
92: FND_MSG_PUB.initialize;
93: END IF;
94: -- Initialize API return status to success
95: x_return_status := FND_API.G_RET_STS_SUCCESS;
96:

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

143: END IF;
144: --------------------------------------------
145:
146: -- Standard call to get message count and if count is 1, get message info.
147: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
148:
149: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
150: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Leaving validate_row');
151: END IF;

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

156: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception');
157: END IF;
158: ROLLBACK TO g_validate_row_GRP;
159: x_return_status := G_RET_STS_ERROR ;
160: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
161:
162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
163: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
164: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

164: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
165: END IF;
166: ROLLBACK TO g_validate_row_GRP;
167: x_return_status := G_RET_STS_UNEXP_ERROR ;
168: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
169:
170: WHEN OTHERS THEN
171: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
172: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm);

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

173: END IF;
174:
175: ROLLBACK TO g_validate_row_GRP;
176: x_return_status := 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( p_count => x_msg_count, p_data => x_msg_data );
181:

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

174:
175: ROLLBACK TO g_validate_row_GRP;
176: x_return_status := 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( p_count => x_msg_count, p_data => x_msg_data );
181:
182: END validate_row;

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

176: x_return_status := 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( p_count => x_msg_count, p_data => x_msg_data );
181:
182: END validate_row;
183:
184: -------------------------------------

Line 250: FND_MSG_PUB.initialize;

246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: END IF;
248: -- Initialize message list if p_init_msg_list is set to TRUE.
249: IF FND_API.to_Boolean( p_init_msg_list ) THEN
250: FND_MSG_PUB.initialize;
251: END IF;
252: -- Initialize API return status to success
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254: --added for 10+ word integration and deviations report

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

308: IF FND_API.To_Boolean( p_commit ) THEN
309: COMMIT WORK;
310: END IF;
311: -- Standard call to get message count and if count is 1, get message info.
312: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
313:
314: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
315: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: Leaving create_template_usages');
316: END IF;

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

321: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving create_template_usages: OKC_API.G_EXCEPTION_ERROR Exception');
322: END IF;
323: ROLLBACK TO g_insert_row_GRP;
324: x_return_status := G_RET_STS_ERROR ;
325: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
326:
327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
328: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
329: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving insert_row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

329: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving insert_row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
330: END IF;
331: ROLLBACK TO g_insert_row_GRP;
332: x_return_status := G_RET_STS_UNEXP_ERROR ;
333: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
334:
335: WHEN OTHERS THEN
336: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
337: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving insert_row because of EXCEPTION: '||sqlerrm);

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

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

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

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

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

341: x_return_status := G_RET_STS_UNEXP_ERROR ;
342: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
343: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
344: END IF;
345: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
346:
347: END create_template_usages;
348: ---------------------------------------------------------------------------
349: -- PROCEDURE lock_row

Line 379: FND_MSG_PUB.initialize;

375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
376: END IF;
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: -- Initialize API return status to success
382: x_return_status := FND_API.G_RET_STS_SUCCESS;
383:

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

398: END IF;
399: --------------------------------------------
400:
401: -- Standard call to get message count and if count is 1, get message info.
402: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
403:
404: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
405: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1200: Leaving lock_row');
406: END IF;

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

411: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception');
412: END IF;
413: ROLLBACK TO g_lock_row_GRP;
414: x_return_status := G_RET_STS_ERROR ;
415: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
416:
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
419: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

419: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
420: END IF;
421: ROLLBACK TO g_lock_row_GRP;
422: x_return_status := G_RET_STS_UNEXP_ERROR ;
423: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
424:
425: WHEN OTHERS THEN
426: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
427: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1500: Leaving lock_Row because of EXCEPTION: '||sqlerrm);

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

428: END IF;
429:
430: ROLLBACK TO g_lock_row_GRP;
431: x_return_status := G_RET_STS_UNEXP_ERROR ;
432: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
433: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
434: END IF;
435: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
436:

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

429:
430: ROLLBACK TO g_lock_row_GRP;
431: x_return_status := G_RET_STS_UNEXP_ERROR ;
432: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
433: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
434: END IF;
435: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
436:
437: END lock_row;

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

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

Line 498: FND_MSG_PUB.initialize;

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

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

542: IF FND_API.To_Boolean( p_commit ) THEN
543: COMMIT WORK;
544: END IF;
545: -- Standard call to get message count and if count is 1, get message info.
546: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
547:
548: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
549: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Leaving update_template_usages');
550: END IF;

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

555: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1900: Leaving update_template_usages: OKC_API.G_EXCEPTION_ERROR Exception');
556: END IF;
557: ROLLBACK TO g_update_row_GRP;
558: x_return_status := G_RET_STS_ERROR ;
559: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
560:
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
563: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving update_template_usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

563: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving update_template_usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
564: END IF;
565: ROLLBACK TO g_update_row_GRP;
566: x_return_status := G_RET_STS_UNEXP_ERROR ;
567: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
568:
569: WHEN OTHERS THEN
570: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
571: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2100: Leaving update_template_usages because of EXCEPTION: '||sqlerrm);

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

572: END IF;
573:
574: ROLLBACK TO g_update_row_GRP;
575: x_return_status := G_RET_STS_UNEXP_ERROR ;
576: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
577: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
578: END IF;
579: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
580:

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

573:
574: ROLLBACK TO g_update_row_GRP;
575: x_return_status := G_RET_STS_UNEXP_ERROR ;
576: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
577: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
578: END IF;
579: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
580:
581: END update_template_usages;

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

575: x_return_status := G_RET_STS_UNEXP_ERROR ;
576: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
577: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
578: END IF;
579: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
580:
581: END update_template_usages;
582:
583: ---------------------------------------------------------------------------

Line 615: FND_MSG_PUB.initialize;

611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: END IF;
613: -- Initialize message list if p_init_msg_list is set to TRUE.
614: IF FND_API.to_Boolean( p_init_msg_list ) THEN
615: FND_MSG_PUB.initialize;
616: END IF;
617: -- Initialize API return status to success
618: x_return_status := FND_API.G_RET_STS_SUCCESS;
619:

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

638: IF FND_API.To_Boolean( p_commit ) THEN
639: COMMIT WORK;
640: END IF;
641: -- Standard call to get message count and if count is 1, get message info.
642: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
643:
644: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
645: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving delete_template_usages');
646: END IF;

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

651: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving delete_template_usages: OKC_API.G_EXCEPTION_ERROR Exception');
652: END IF;
653: ROLLBACK TO g_delete_row_GRP;
654: x_return_status := G_RET_STS_ERROR ;
655: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
656:
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
659: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving delete_template_usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

659: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving delete_template_usages: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
660: END IF;
661: ROLLBACK TO g_delete_row_GRP;
662: x_return_status := G_RET_STS_UNEXP_ERROR ;
663: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
664:
665: WHEN OTHERS THEN
666: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
667: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2600: Leaving delete_template_usages because of EXCEPTION: '||sqlerrm);

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

668: END IF;
669:
670: ROLLBACK TO g_delete_row_GRP;
671: x_return_status := G_RET_STS_UNEXP_ERROR ;
672: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
673: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
674: END IF;
675: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
676:

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

669:
670: ROLLBACK TO g_delete_row_GRP;
671: x_return_status := G_RET_STS_UNEXP_ERROR ;
672: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
673: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
674: END IF;
675: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
676:
677: END delete_template_usages;

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

671: x_return_status := G_RET_STS_UNEXP_ERROR ;
672: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
673: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
674: END IF;
675: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
676:
677: END delete_template_usages;
678:
679: PROCEDURE Set_Contract_Source(

Line 733: FND_MSG_PUB.initialize;

729: END IF;
730:
731: -- Initialize message list if p_init_msg_list is set to TRUE.
732: IF FND_API.to_Boolean( p_init_msg_list ) THEN
733: FND_MSG_PUB.initialize;
734: END IF;
735:
736: -- Check if anything changed. If no change, then nothing to update, return.
737: OPEN l_template_usages_csr;

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

826: IF FND_API.To_Boolean( p_commit ) THEN
827: COMMIT WORK;
828: END IF;
829: -- Standard call to get message count and if count is 1, get message info.
830: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
831:
832: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
833: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving Set_Contract_Source');
834: END IF;

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

839: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving Set_Contract_Source: OKC_API.G_EXCEPTION_ERROR Exception');
840: END IF;
841: ROLLBACK TO g_set_contract_source_GRP;
842: x_return_status := G_RET_STS_ERROR ;
843: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
844:
845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
846: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
847: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving Set_Contract_Source: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

847: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving Set_Contract_Source: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
848: END IF;
849: ROLLBACK TO g_set_contract_source_GRP;
850: x_return_status := G_RET_STS_UNEXP_ERROR ;
851: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
852:
853: WHEN OTHERS THEN
854: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
855: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2600: Leaving Set_Contract_Source because of EXCEPTION: '||sqlerrm);

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

856: END IF;
857:
858: ROLLBACK TO g_set_contract_source_GRP;
859: x_return_status := G_RET_STS_UNEXP_ERROR ;
860: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
861: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
862: END IF;
863: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
864:

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

857:
858: ROLLBACK TO g_set_contract_source_GRP;
859: x_return_status := G_RET_STS_UNEXP_ERROR ;
860: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
861: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
862: END IF;
863: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
864:
865: END Set_Contract_Source;

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

859: x_return_status := G_RET_STS_UNEXP_ERROR ;
860: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
861: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
862: END IF;
863: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
864:
865: END Set_Contract_Source;
866:
867: PROCEDURE Set_Contract_Source_details(

Line 927: FND_MSG_PUB.initialize;

923: END IF;
924:
925: -- Initialize message list if p_init_msg_list is set to TRUE.
926: IF FND_API.to_Boolean( p_init_msg_list ) THEN
927: FND_MSG_PUB.initialize;
928: END IF;
929:
930: -- Check if anything changed. If no change, then nothing to update, return.
931: OPEN l_template_usages_csr;

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

1031: IF FND_API.To_Boolean( p_commit ) THEN
1032: COMMIT WORK;
1033: END IF;
1034: -- Standard call to get message count and if count is 1, get message info.
1035: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1036:
1037: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1038: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving Set_Contract_Source_details');
1039: END IF;

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

1044: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving Set_Contract_Source_details: OKC_API.G_EXCEPTION_ERROR Exception');
1045: END IF;
1046: ROLLBACK TO g_set_contract_src_dtls_GRP;
1047: x_return_status := G_RET_STS_ERROR ;
1048: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1049:
1050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1051: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1052: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving Set_Contract_Source_details: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

1052: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving Set_Contract_Source_details: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1053: END IF;
1054: ROLLBACK TO g_set_contract_src_dtls_GRP;
1055: x_return_status := G_RET_STS_UNEXP_ERROR ;
1056: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1057:
1058: WHEN OTHERS THEN
1059: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1060: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2600: Leaving Set_Contract_Source_details because of EXCEPTION: '||sqlerrm);

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

1061: END IF;
1062:
1063: ROLLBACK TO g_set_contract_src_dtls_GRP;
1064: x_return_status := G_RET_STS_UNEXP_ERROR ;
1065: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1066: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1067: END IF;
1068: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1069:

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

1062:
1063: ROLLBACK TO g_set_contract_src_dtls_GRP;
1064: x_return_status := G_RET_STS_UNEXP_ERROR ;
1065: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1066: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1067: END IF;
1068: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1069:
1070: END Set_Contract_Source_details;

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

1064: x_return_status := G_RET_STS_UNEXP_ERROR ;
1065: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1066: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1067: END IF;
1068: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1069:
1070: END Set_Contract_Source_details;
1071:
1072: END OKC_TEMPLATE_USAGES_GRP;