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

Line 102: FND_MSG_PUB.initialize;

98: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: END IF;
100: -- Initialize message list if p_init_msg_list is set to TRUE.
101: IF FND_API.to_Boolean( p_init_msg_list ) THEN
102: FND_MSG_PUB.initialize;
103: END IF;
104: -- Initialize API return status to success
105: x_return_status := FND_API.G_RET_STS_SUCCESS;
106:

Line 155: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

151: END IF;
152: --------------------------------------------
153:
154: -- Standard call to get message count and if count is 1, get message info.
155: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
156:
157: /*IF (l_debug = 'Y') THEN
158: okc_debug.log('200: Leaving validate_row', 2);
159: END IF;*/

Line 178: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

174: G_PKG_NAME, '300: Leaving Validate_Row: OKC_API.G_EXCEPTION_ERROR Exception' );
175: END IF;
176: ROLLBACK TO g_validate_row_GRP;
177: x_return_status := G_RET_STS_ERROR ;
178: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
179:
180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
181: /*IF (l_debug = 'Y') THEN
182: okc_debug.log('400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 191: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

187: G_PKG_NAME, '400: Leaving Validate_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
188: END IF;
189: ROLLBACK TO g_validate_row_GRP;
190: x_return_status := G_RET_STS_UNEXP_ERROR ;
191: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
192:
193: WHEN OTHERS THEN
194: /*IF (l_debug = 'Y') THEN
195: okc_debug.log('500: Leaving Validate_Row because of EXCEPTION: '||sqlerrm, 2);

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

207: p_token2_value => sqlerrm);
208:
209: ROLLBACK TO g_validate_row_GRP;
210: x_return_status := G_RET_STS_UNEXP_ERROR ;
211: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
212: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
213: END IF;
214: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
215:

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

208:
209: ROLLBACK TO g_validate_row_GRP;
210: x_return_status := G_RET_STS_UNEXP_ERROR ;
211: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
212: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
213: END IF;
214: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
215:
216: END validate_row;

Line 214: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

210: x_return_status := G_RET_STS_UNEXP_ERROR ;
211: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
212: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
213: END IF;
214: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
215:
216: END validate_row;
217:
218: -------------------------------------

Line 290: FND_MSG_PUB.initialize;

286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288: -- Initialize message list if p_init_msg_list is set to TRUE.
289: IF FND_API.to_Boolean( p_init_msg_list ) THEN
290: FND_MSG_PUB.initialize;
291: END IF;
292:
293: -- Initialize API return status to success
294: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

356: IF FND_API.To_Boolean( p_commit ) THEN
357: COMMIT WORK;
358: END IF;
359: -- Standard call to get message count and if count is 1, get message info.
360: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
361:
362: /*IF (l_debug = 'Y') THEN
363: okc_debug.log('700: Leaving create_section', 2);
364: END IF;*/

Line 383: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

379: G_PKG_NAME, '800: Leaving create_section: OKC_API.G_EXCEPTION_ERROR Exception');
380: END IF;
381: ROLLBACK TO g_create_section_GRP;
382: x_return_status := G_RET_STS_ERROR ;
383: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
384:
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
386: /*IF (l_debug = 'Y') THEN
387: okc_debug.log('900: Leaving create_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 396: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

392: G_PKG_NAME, '900: Leaving create_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
393: END IF;
394: ROLLBACK TO g_create_section_GRP;
395: x_return_status := G_RET_STS_UNEXP_ERROR ;
396: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
397:
398: WHEN OTHERS THEN
399: /*IF (l_debug = 'Y') THEN
400: okc_debug.log('1000: Leaving create_section because of EXCEPTION: '||sqlerrm, 2);

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

412: p_token2_value => sqlerrm);
413:
414: ROLLBACK TO g_create_section_GRP;
415: x_return_status := G_RET_STS_UNEXP_ERROR ;
416: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
417: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
418: END IF;
419: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
420:

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

413:
414: ROLLBACK TO g_create_section_GRP;
415: x_return_status := G_RET_STS_UNEXP_ERROR ;
416: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
417: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
418: END IF;
419: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
420:
421: END create_section;

Line 419: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

415: x_return_status := G_RET_STS_UNEXP_ERROR ;
416: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
417: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
418: END IF;
419: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
420:
421: END create_section;
422:
423: --------------------------------------------------------------------------

Line 516: FND_MSG_PUB.initialize;

512: END IF;
513:
514: -- Initialize message list if p_init_msg_list is set to TRUE.
515: IF FND_API.to_Boolean( p_init_msg_list ) THEN
516: FND_MSG_PUB.initialize;
517: END IF;
518:
519: IF p_document_id IS NULL OR p_document_type IS NULL OR p_orig_system_reference_id1 IS NULL THEN
520: OPEN l_document_id_csr;

Line 662: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

658: IF FND_API.To_Boolean( p_commit ) THEN
659: COMMIT WORK;
660: END IF;
661: -- Standard call to get message count and if count is 1, get message info.
662: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
663:
664: /*IF (l_debug = 'Y') THEN
665: okc_debug.log('1800: Leaving update_section', 2);
666: END IF;*/

Line 690: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

686: END IF;
687:
688: ROLLBACK TO g_update_section_GRP;
689: x_return_status := G_RET_STS_ERROR ;
690: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
691:
692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
693: /*IF (l_debug = 'Y') THEN
694: okc_debug.log('2000: Leaving update_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 708: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

704: END IF;
705:
706: ROLLBACK TO g_update_section_GRP;
707: x_return_status := G_RET_STS_UNEXP_ERROR ;
708: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
709:
710: WHEN OTHERS THEN
711: /*IF (l_debug = 'Y') THEN
712: okc_debug.log('2100: Leaving update_section because of EXCEPTION: '||sqlerrm, 2);

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

729:
730: ROLLBACK TO g_update_section_GRP;
731:
732: x_return_status := G_RET_STS_UNEXP_ERROR ;
733: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
734: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
735: END IF;
736: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
737:

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

730: ROLLBACK TO g_update_section_GRP;
731:
732: x_return_status := G_RET_STS_UNEXP_ERROR ;
733: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
734: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
735: END IF;
736: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
737:
738: END update_section;

Line 736: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

732: x_return_status := G_RET_STS_UNEXP_ERROR ;
733: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
734: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
735: END IF;
736: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
737:
738: END update_section;
739:
740: -------------------------------------------------------

Line 887: FND_MSG_PUB.initialize;

883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
884: END IF;
885: -- Initialize message list if p_init_msg_list is set to TRUE.
886: IF FND_API.to_Boolean( p_init_msg_list ) THEN
887: FND_MSG_PUB.initialize;
888: END IF;
889:
890: IF FND_API.To_Boolean( p_validate_commit ) AND
891: NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (

Line 1130: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1126: IF FND_API.To_Boolean( p_commit ) THEN
1127: COMMIT WORK;
1128: END IF;
1129: -- Standard call to get message count and if count is 1, get message info.
1130: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1131:
1132: /*IF (l_debug = 'Y') THEN
1133: okc_debug.log('1100: Leaving add_section', 2);
1134: END IF;*/

Line 1170: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1166: END IF;
1167:
1168: ROLLBACK TO g_add_section_GRP;
1169: x_return_status := G_RET_STS_ERROR ;
1170: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1171:
1172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1173: /*IF (l_debug = 'Y') THEN
1174: okc_debug.log('1300: Leaving add_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 1200: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1196: CLOSE l_get_child_art_crs;
1197: END IF;
1198: ROLLBACK TO g_add_section_GRP;
1199: x_return_status := G_RET_STS_UNEXP_ERROR ;
1200: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1201:
1202: WHEN OTHERS THEN
1203: /*IF (l_debug = 'Y') THEN
1204: okc_debug.log('1400: Leaving add_section because of EXCEPTION: '||sqlerrm, 2);

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

1234: CLOSE l_get_child_art_crs;
1235: END IF;
1236: ROLLBACK TO g_add_section_GRP;
1237: x_return_status := G_RET_STS_UNEXP_ERROR ;
1238: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1239: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1240: END IF;
1241: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1242:

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

1235: END IF;
1236: ROLLBACK TO g_add_section_GRP;
1237: x_return_status := G_RET_STS_UNEXP_ERROR ;
1238: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1239: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1240: END IF;
1241: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1242:
1243: END add_section;

Line 1241: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1237: x_return_status := G_RET_STS_UNEXP_ERROR ;
1238: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1239: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1240: END IF;
1241: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1242:
1243: END add_section;
1244:
1245: ---------------------------------------------------------------------------

Line 1278: FND_MSG_PUB.initialize;

1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1275: END IF;
1276: -- Initialize message list if p_init_msg_list is set to TRUE.
1277: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1278: FND_MSG_PUB.initialize;
1279: END IF;
1280: -- Initialize API return status to success
1281: x_return_status := FND_API.G_RET_STS_SUCCESS;
1282:

Line 1300: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1296: END IF;
1297: --------------------------------------------
1298:
1299: -- Standard call to get message count and if count is 1, get message info.
1300: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1301:
1302: /*IF (l_debug = 'Y') THEN
1303: okc_debug.log('1200: Leaving lock_row', 2);
1304: END IF;*/

Line 1323: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1319: G_PKG_NAME, '1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception' );
1320: END IF;
1321: ROLLBACK TO g_lock_row_GRP;
1322: x_return_status := G_RET_STS_ERROR ;
1323: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1324:
1325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1326: /*IF (l_debug = 'Y') THEN
1327: okc_debug.log('1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 1336: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1332: G_PKG_NAME, '1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
1333: END IF;
1334: ROLLBACK TO g_lock_row_GRP;
1335: x_return_status := G_RET_STS_UNEXP_ERROR ;
1336: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1337:
1338: WHEN OTHERS THEN
1339: /*IF (l_debug = 'Y') THEN
1340: okc_debug.log('1500: Leaving lock_Row because of EXCEPTION: '||sqlerrm, 2);

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

1352: p_token2_value => sqlerrm);
1353:
1354: ROLLBACK TO g_lock_row_GRP;
1355: x_return_status := G_RET_STS_UNEXP_ERROR ;
1356: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1357: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1358: END IF;
1359: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1360:

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

1353:
1354: ROLLBACK TO g_lock_row_GRP;
1355: x_return_status := G_RET_STS_UNEXP_ERROR ;
1356: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1357: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1358: END IF;
1359: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1360:
1361: END lock_row;

Line 1359: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1355: x_return_status := G_RET_STS_UNEXP_ERROR ;
1356: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1357: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1358: END IF;
1359: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1360:
1361: END lock_row;
1362:
1363: ---------------------------------------------------------------------------

Line 1435: FND_MSG_PUB.initialize;

1431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1432: END IF;
1433: -- Initialize message list if p_init_msg_list is set to TRUE.
1434: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1435: FND_MSG_PUB.initialize;
1436: END IF;
1437:
1438: OPEN l_document_id_csr;
1439: FETCH l_document_id_csr into l_document_id,l_document_type,l_orig_system_reference_id1;

Line 1667: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1663: IF FND_API.To_Boolean( p_commit ) THEN
1664: COMMIT WORK;
1665: END IF;
1666: -- Standard call to get message count and if count is 1, get message info.
1667: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1668:
1669: /*IF (l_debug = 'Y') THEN
1670: okc_debug.log('2300: Leaving delete_section', 2);
1671: END IF;*/

Line 1703: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1699: END IF;
1700:
1701: ROLLBACK TO g_delete_section_GRP;
1702: x_return_status := G_RET_STS_ERROR ;
1703: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1704:
1705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1706: /*IF (l_debug = 'Y') THEN
1707: okc_debug.log('2500: Leaving delete_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line 1729: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1725: END IF;
1726:
1727: ROLLBACK TO g_delete_section_GRP;
1728: x_return_status := G_RET_STS_UNEXP_ERROR ;
1729: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1730:
1731: WHEN OTHERS THEN
1732: /*IF (l_debug = 'Y') THEN
1733: okc_debug.log('2600: Leaving delete_section because of EXCEPTION: '||sqlerrm, 2);

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

1758: END IF;
1759:
1760: ROLLBACK TO g_delete_section_GRP;
1761: x_return_status := G_RET_STS_UNEXP_ERROR ;
1762: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1763: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1764: END IF;
1765: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1766:

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

1759:
1760: ROLLBACK TO g_delete_section_GRP;
1761: x_return_status := G_RET_STS_UNEXP_ERROR ;
1762: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1763: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1764: END IF;
1765: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1766:
1767: END delete_section;

Line 1765: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1761: x_return_status := G_RET_STS_UNEXP_ERROR ;
1762: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1763: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1764: END IF;
1765: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1766:
1767: END delete_section;
1768:
1769: END OKC_TERMS_SECTIONS_GRP;