DBA Data[Home] [Help]

APPS.OKC_TERMS_COPY_GRP dependencies on FND_MSG_PUB

Line 143: FND_MSG_PUB.initialize;

139: END IF;
140:
141: -- Initialize message list if p_init_msg_list is set to TRUE.
142: IF FND_API.to_Boolean( p_init_msg_list ) THEN
143: FND_MSG_PUB.initialize;
144: END IF;
145:
146: -- Initialize API return status to success
147: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

373: COMMIT WORK;
374: END IF;
375:
376: -- Standard call to get message count and if count is 1, get message info.
377: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
378:
379: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
380: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving copy_doc');
381: END IF;

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

389: END IF;
390:
391: ROLLBACK TO g_copy_doc_grp;
392: x_return_status := G_RET_STS_ERROR ;
393: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
394:
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
397: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

398: END IF;
399:
400: ROLLBACK TO g_copy_doc_grp;
401: x_return_status := G_RET_STS_UNEXP_ERROR ;
402: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
403:
404: WHEN OTHERS THEN
405: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
406: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving copy_doc because of EXCEPTION: '||sqlerrm);

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

407: END IF;
408:
409: ROLLBACK TO g_copy_doc_grp;
410: x_return_status := G_RET_STS_UNEXP_ERROR ;
411: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
412: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
413: END IF;
414: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
415: END copy_doc;

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

408:
409: ROLLBACK TO g_copy_doc_grp;
410: x_return_status := G_RET_STS_UNEXP_ERROR ;
411: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
412: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
413: END IF;
414: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
415: END copy_doc;
416:

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

410: x_return_status := G_RET_STS_UNEXP_ERROR ;
411: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
412: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
413: END IF;
414: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
415: END copy_doc;
416:
417: /*
418: --To be used when copying a terms template to make a new template or to make a

Line 514: FND_MSG_PUB.initialize;

510: END IF;
511:
512: -- Initialize message list if p_init_msg_list is set to TRUE.
513: IF FND_API.to_Boolean( p_init_msg_list ) THEN
514: FND_MSG_PUB.initialize;
515: END IF;
516:
517: -- Initialize API return status to success
518: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

708: COMMIT WORK;
709: END IF;
710:
711: -- Standard call to get message count and if count is 1, get message info.
712: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
713:
714: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
715: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving copy_terms_template');
716: END IF;

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

732: END IF;
733:
734: ROLLBACK TO g_copy_terms_template_grp;
735: x_return_status := G_RET_STS_ERROR ;
736: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
737:
738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
739: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
740: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_terms_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

749: END IF;
750:
751: ROLLBACK TO g_copy_terms_template_grp;
752: x_return_status := G_RET_STS_UNEXP_ERROR ;
753: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
754:
755: WHEN OTHERS THEN
756: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
757: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving copy_terms_template because of EXCEPTION: '||sqlerrm);

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

766: END IF;
767:
768: ROLLBACK TO g_copy_terms_template_grp;
769: x_return_status := G_RET_STS_UNEXP_ERROR ;
770: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
771: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
772: END IF;
773: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
774: END copy_terms_template;

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

767:
768: ROLLBACK TO g_copy_terms_template_grp;
769: x_return_status := G_RET_STS_UNEXP_ERROR ;
770: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
771: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
772: END IF;
773: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
774: END copy_terms_template;
775:

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

769: x_return_status := G_RET_STS_UNEXP_ERROR ;
770: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
771: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
772: END IF;
773: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
774: END copy_terms_template;
775:
776: /*
777: --To be used when instantiating a term on a document.

Line 864: FND_MSG_PUB.initialize;

860: END IF;
861:
862: -- Initialize message list if p_init_msg_list is set to TRUE.
863: IF FND_API.to_Boolean( p_init_msg_list ) THEN
864: FND_MSG_PUB.initialize;
865: END IF;
866:
867: IF FND_API.To_Boolean( p_validate_commit ) AND
868: NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (

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

1028: COMMIT WORK;
1029: END IF;
1030:
1031: -- Standard call to get message count and if count is 1, get message info.
1032: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1033:
1034: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1035: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving copy_terms');
1036: END IF;

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

1046: END IF;
1047:
1048: ROLLBACK TO g_copy_terms_grp;
1049: x_return_status := G_RET_STS_ERROR ;
1050: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1051:
1052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1053: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1054: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

1056:
1057:
1058: ROLLBACK TO g_copy_terms_grp;
1059: x_return_status := G_RET_STS_UNEXP_ERROR ;
1060: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1061:
1062: WHEN OTHERS THEN
1063: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1064: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving copy_terms because of EXCEPTION: '||sqlerrm);

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

1065: END IF;
1066:
1067: ROLLBACK TO g_copy_terms_grp;
1068: x_return_status := G_RET_STS_UNEXP_ERROR ;
1069: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1070: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1071: END IF;
1072: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1073:

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

1066:
1067: ROLLBACK TO g_copy_terms_grp;
1068: x_return_status := G_RET_STS_UNEXP_ERROR ;
1069: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1070: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1071: END IF;
1072: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1073:
1074:

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

1068: x_return_status := G_RET_STS_UNEXP_ERROR ;
1069: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1070: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1071: END IF;
1072: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1073:
1074:
1075: END copy_terms;
1076:

Line 1124: FND_MSG_PUB.initialize;

1120: END IF;
1121:
1122: -- Initialize message list if p_init_msg_list is set to TRUE.
1123: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1124: FND_MSG_PUB.initialize;
1125: END IF;
1126:
1127: -- Initialize API return status to success
1128: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1250: COMMIT WORK;
1251: END IF;
1252:
1253: -- Standard call to get message count and if count is 1, get message info.
1254: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1255:
1256: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1257: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving create_template_revision');
1258: END IF;

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

1270: END IF;
1271:
1272: ROLLBACK TO g_create_template_revision_grp;
1273: x_return_status := G_RET_STS_ERROR ;
1274: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1275:
1276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1277: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1278: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving create_template_revision: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

1283: END IF;
1284:
1285: ROLLBACK TO g_create_template_revision_grp;
1286: x_return_status := G_RET_STS_UNEXP_ERROR ;
1287: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1288:
1289: WHEN OTHERS THEN
1290: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1291: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving create_template_revision because of EXCEPTION: '||sqlerrm);

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

1297: END IF;
1298:
1299: ROLLBACK TO g_create_template_revision_grp;
1300: x_return_status := G_RET_STS_UNEXP_ERROR ;
1301: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1302: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1303: END IF;
1304: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1305: END create_template_revision;

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

1298:
1299: ROLLBACK TO g_create_template_revision_grp;
1300: x_return_status := G_RET_STS_UNEXP_ERROR ;
1301: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1302: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1303: END IF;
1304: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1305: END create_template_revision;
1306:

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

1300: x_return_status := G_RET_STS_UNEXP_ERROR ;
1301: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1302: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1303: END IF;
1304: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1305: END create_template_revision;
1306:
1307: /*
1308: -- To be used while copying a document from archive to make a new document.

Line 1357: FND_MSG_PUB.initialize;

1353: END IF;
1354:
1355: -- Initialize message list if p_init_msg_list is set to TRUE.
1356: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1357: FND_MSG_PUB.initialize;
1358: END IF;
1359:
1360: -- Initialize API return status to success
1361: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1393: COMMIT WORK;
1394: END IF;
1395:
1396: -- Standard call to get message count and if count is 1, get message info.
1397: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1398:
1399: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1400: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving copy_archived_doc');
1401: END IF;

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

1409: END IF;
1410:
1411: ROLLBACK TO g_copy_archived_doc_grp;
1412: x_return_status := G_RET_STS_ERROR ;
1413: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1414:
1415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1416: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1417: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_archived_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

1418: END IF;
1419:
1420: ROLLBACK TO g_copy_archived_doc_grp;
1421: x_return_status := G_RET_STS_UNEXP_ERROR ;
1422: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1423:
1424: WHEN OTHERS THEN
1425: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1426: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving copy_archived_doc because of EXCEPTION: '||sqlerrm);

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

1427: END IF;
1428:
1429: ROLLBACK TO g_copy_archived_doc_grp;
1430: x_return_status := G_RET_STS_UNEXP_ERROR ;
1431: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1432: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1433: END IF;
1434: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1435: END copy_archived_doc;

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

1428:
1429: ROLLBACK TO g_copy_archived_doc_grp;
1430: x_return_status := G_RET_STS_UNEXP_ERROR ;
1431: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1432: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1433: END IF;
1434: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1435: END copy_archived_doc;
1436:

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

1430: x_return_status := G_RET_STS_UNEXP_ERROR ;
1431: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1432: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1433: END IF;
1434: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1435: END copy_archived_doc;
1436:
1437: /*************************************************************
1438: 07-APR-2004 pnayani: bug#3524864 added copy_response_doc API |

Line 1512: FND_MSG_PUB.initialize;

1508: END IF;
1509:
1510: -- Initialize message list if p_init_msg_list is set to TRUE.
1511: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1512: FND_MSG_PUB.initialize;
1513: END IF;
1514:
1515: -- Initialize API return status to success
1516: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1621: COMMIT WORK;
1622: END IF;
1623:
1624: -- Standard call to get message count and if count is 1, get message info.
1625: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1626:
1627: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1628: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving copy_response_doc');
1629: END IF;

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

1637: END IF;
1638:
1639: ROLLBACK TO g_copy_doc_grp;
1640: x_return_status := G_RET_STS_ERROR ;
1641: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1642:
1643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1644: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1645: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_response_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

1646: END IF;
1647:
1648: ROLLBACK TO g_copy_doc_grp;
1649: x_return_status := G_RET_STS_UNEXP_ERROR ;
1650: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1651:
1652: WHEN OTHERS THEN
1653: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1654: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving copy_response_doc because of EXCEPTION: '||sqlerrm);

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

1655: END IF;
1656:
1657: ROLLBACK TO g_copy_doc_grp;
1658: x_return_status := G_RET_STS_UNEXP_ERROR ;
1659: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1660: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1661: END IF;
1662: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1663: END copy_response_doc;

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

1656:
1657: ROLLBACK TO g_copy_doc_grp;
1658: x_return_status := G_RET_STS_UNEXP_ERROR ;
1659: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1660: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1661: END IF;
1662: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1663: END copy_response_doc;
1664:

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

1658: x_return_status := G_RET_STS_UNEXP_ERROR ;
1659: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1660: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1661: END IF;
1662: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1663: END copy_response_doc;
1664:
1665:
1666: