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 515: FND_MSG_PUB.initialize;

511: END IF;
512:
513: -- Initialize message list if p_init_msg_list is set to TRUE.
514: IF FND_API.to_Boolean( p_init_msg_list ) THEN
515: FND_MSG_PUB.initialize;
516: END IF;
517:
518: IF FND_API.To_Boolean( p_validate_commit ) THEN
519:

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

620: IF FND_API.To_Boolean( p_commit ) THEN
621: COMMIT WORK;
622: END IF;
623: -- Standard call to get message count and if count is 1, get message info.
624: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
625:
626: /*IF (l_debug = 'Y') THEN
627: okc_debug.log('1800: Leaving update_section', 2);
628: END IF;*/

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

648: END IF;
649:
650: ROLLBACK TO g_update_section_GRP;
651: x_return_status := G_RET_STS_ERROR ;
652: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
653:
654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
655: /*IF (l_debug = 'Y') THEN
656: okc_debug.log('2000: Leaving update_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

666: END IF;
667:
668: ROLLBACK TO g_update_section_GRP;
669: x_return_status := G_RET_STS_UNEXP_ERROR ;
670: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
671:
672: WHEN OTHERS THEN
673: /*IF (l_debug = 'Y') THEN
674: okc_debug.log('2100: Leaving update_section because of EXCEPTION: '||sqlerrm, 2);

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

691:
692: ROLLBACK TO g_update_section_GRP;
693:
694: x_return_status := G_RET_STS_UNEXP_ERROR ;
695: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
696: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
697: END IF;
698: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
699:

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

692: ROLLBACK TO g_update_section_GRP;
693:
694: x_return_status := G_RET_STS_UNEXP_ERROR ;
695: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
696: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
697: END IF;
698: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
699:
700: END update_section;

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

694: x_return_status := G_RET_STS_UNEXP_ERROR ;
695: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
696: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
697: END IF;
698: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
699:
700: END update_section;
701:
702: -------------------------------------------------------

Line 849: FND_MSG_PUB.initialize;

845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
846: END IF;
847: -- Initialize message list if p_init_msg_list is set to TRUE.
848: IF FND_API.to_Boolean( p_init_msg_list ) THEN
849: FND_MSG_PUB.initialize;
850: END IF;
851:
852: IF FND_API.To_Boolean( p_validate_commit ) AND
853: NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (

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

1088: IF FND_API.To_Boolean( p_commit ) THEN
1089: COMMIT WORK;
1090: END IF;
1091: -- Standard call to get message count and if count is 1, get message info.
1092: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1093:
1094: /*IF (l_debug = 'Y') THEN
1095: okc_debug.log('1100: Leaving add_section', 2);
1096: END IF;*/

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

1128: END IF;
1129:
1130: ROLLBACK TO g_add_section_GRP;
1131: x_return_status := G_RET_STS_ERROR ;
1132: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1133:
1134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1135: /*IF (l_debug = 'Y') THEN
1136: okc_debug.log('1300: Leaving add_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

1158: CLOSE l_get_child_art_crs;
1159: END IF;
1160: ROLLBACK TO g_add_section_GRP;
1161: x_return_status := G_RET_STS_UNEXP_ERROR ;
1162: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1163:
1164: WHEN OTHERS THEN
1165: /*IF (l_debug = 'Y') THEN
1166: okc_debug.log('1400: Leaving add_section because of EXCEPTION: '||sqlerrm, 2);

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

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: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1201: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1202: END IF;
1203: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1204:

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

1197: END IF;
1198: ROLLBACK TO g_add_section_GRP;
1199: x_return_status := G_RET_STS_UNEXP_ERROR ;
1200: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1201: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1202: END IF;
1203: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1204:
1205: END add_section;

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

1199: x_return_status := G_RET_STS_UNEXP_ERROR ;
1200: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1201: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1202: END IF;
1203: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1204:
1205: END add_section;
1206:
1207: ---------------------------------------------------------------------------

Line 1240: FND_MSG_PUB.initialize;

1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1237: END IF;
1238: -- Initialize message list if p_init_msg_list is set to TRUE.
1239: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1240: FND_MSG_PUB.initialize;
1241: END IF;
1242: -- Initialize API return status to success
1243: x_return_status := FND_API.G_RET_STS_SUCCESS;
1244:

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

1258: END IF;
1259: --------------------------------------------
1260:
1261: -- Standard call to get message count and if count is 1, get message info.
1262: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1263:
1264: /*IF (l_debug = 'Y') THEN
1265: okc_debug.log('1200: Leaving lock_row', 2);
1266: END IF;*/

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

1281: G_PKG_NAME, '1300: Leaving lock_Row: OKC_API.G_EXCEPTION_ERROR Exception' );
1282: END IF;
1283: ROLLBACK TO g_lock_row_GRP;
1284: x_return_status := G_RET_STS_ERROR ;
1285: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1286:
1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1288: /*IF (l_debug = 'Y') THEN
1289: okc_debug.log('1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

1294: G_PKG_NAME, '1400: Leaving lock_Row: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception' );
1295: END IF;
1296: ROLLBACK TO g_lock_row_GRP;
1297: x_return_status := G_RET_STS_UNEXP_ERROR ;
1298: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1299:
1300: WHEN OTHERS THEN
1301: /*IF (l_debug = 'Y') THEN
1302: okc_debug.log('1500: Leaving lock_Row because of EXCEPTION: '||sqlerrm, 2);

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

1314: p_token2_value => sqlerrm);
1315:
1316: ROLLBACK TO g_lock_row_GRP;
1317: x_return_status := G_RET_STS_UNEXP_ERROR ;
1318: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1319: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1320: END IF;
1321: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1322:

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

1315:
1316: ROLLBACK TO g_lock_row_GRP;
1317: x_return_status := G_RET_STS_UNEXP_ERROR ;
1318: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1319: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1320: END IF;
1321: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1322:
1323: END lock_row;

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

1317: x_return_status := G_RET_STS_UNEXP_ERROR ;
1318: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1319: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1320: END IF;
1321: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1322:
1323: END lock_row;
1324:
1325: ---------------------------------------------------------------------------

Line 1394: FND_MSG_PUB.initialize;

1390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1391: END IF;
1392: -- Initialize message list if p_init_msg_list is set to TRUE.
1393: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1394: FND_MSG_PUB.initialize;
1395: END IF;
1396:
1397: IF FND_API.To_Boolean( p_validate_commit ) THEN
1398:

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

1583: IF FND_API.To_Boolean( p_commit ) THEN
1584: COMMIT WORK;
1585: END IF;
1586: -- Standard call to get message count and if count is 1, get message info.
1587: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1588:
1589: /*IF (l_debug = 'Y') THEN
1590: okc_debug.log('2300: Leaving delete_section', 2);
1591: END IF;*/

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

1619: END IF;
1620:
1621: ROLLBACK TO g_delete_section_GRP;
1622: x_return_status := G_RET_STS_ERROR ;
1623: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1624:
1625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1626: /*IF (l_debug = 'Y') THEN
1627: okc_debug.log('2500: Leaving delete_section: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

1645: END IF;
1646:
1647: ROLLBACK TO g_delete_section_GRP;
1648: x_return_status := G_RET_STS_UNEXP_ERROR ;
1649: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1650:
1651: WHEN OTHERS THEN
1652: /*IF (l_debug = 'Y') THEN
1653: okc_debug.log('2600: Leaving delete_section because of EXCEPTION: '||sqlerrm, 2);

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

1678: END IF;
1679:
1680: ROLLBACK TO g_delete_section_GRP;
1681: x_return_status := G_RET_STS_UNEXP_ERROR ;
1682: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1683: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1684: END IF;
1685: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1686:

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

1679:
1680: ROLLBACK TO g_delete_section_GRP;
1681: x_return_status := G_RET_STS_UNEXP_ERROR ;
1682: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1683: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1684: END IF;
1685: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1686:
1687: END delete_section;

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

1681: x_return_status := G_RET_STS_UNEXP_ERROR ;
1682: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1683: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1684: END IF;
1685: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1686:
1687: END delete_section;
1688:
1689: END OKC_TERMS_SECTIONS_GRP;