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

Line 167: FND_MSG_PUB.initialize;

163: END IF;
164:
165: -- Initialize message list if p_init_msg_list is set to TRUE.
166: IF FND_API.to_Boolean( p_init_msg_list ) THEN
167: FND_MSG_PUB.initialize;
168: END IF;
169:
170: -- Initialize API return status to success
171: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

490: COMMIT WORK;
491: END IF;
492:
493: -- Standard call to get message count and if count is 1, get message info.
494: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
495:
496: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
497: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving copy_doc');
498: END IF;

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

506: END IF;
507:
508: ROLLBACK TO g_copy_doc_grp;
509: x_return_status := G_RET_STS_ERROR ;
510: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
511:
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
514: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

515: END IF;
516:
517: ROLLBACK TO g_copy_doc_grp;
518: x_return_status := G_RET_STS_UNEXP_ERROR ;
519: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
520:
521: WHEN OTHERS THEN
522: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
523: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving copy_doc because of EXCEPTION: '||sqlerrm);

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

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

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

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

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

527: x_return_status := G_RET_STS_UNEXP_ERROR ;
528: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
529: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
530: END IF;
531: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
532: END copy_doc;
533:
534: /*
535: --To be used when copying a terms template to make a new template or to make a

Line 632: FND_MSG_PUB.initialize;

628: END IF;
629:
630: -- Initialize message list if p_init_msg_list is set to TRUE.
631: IF FND_API.to_Boolean( p_init_msg_list ) THEN
632: FND_MSG_PUB.initialize;
633: END IF;
634:
635: -- Initialize API return status to success
636: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

826: COMMIT WORK;
827: END IF;
828:
829: -- Standard call to get message count and if count is 1, get message info.
830: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', 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,'1000: Leaving copy_terms_template');
834: END IF;

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

850: END IF;
851:
852: ROLLBACK TO g_copy_terms_template_grp;
853: x_return_status := G_RET_STS_ERROR ;
854: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
855:
856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
857: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
858: 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 871: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

867: END IF;
868:
869: ROLLBACK TO g_copy_terms_template_grp;
870: x_return_status := G_RET_STS_UNEXP_ERROR ;
871: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
872:
873: WHEN OTHERS THEN
874: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
875: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving copy_terms_template because of EXCEPTION: '||sqlerrm);

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

884: END IF;
885:
886: ROLLBACK TO g_copy_terms_template_grp;
887: x_return_status := G_RET_STS_UNEXP_ERROR ;
888: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
889: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
890: END IF;
891: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
892: END copy_terms_template;

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

885:
886: ROLLBACK TO g_copy_terms_template_grp;
887: x_return_status := G_RET_STS_UNEXP_ERROR ;
888: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
889: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
890: END IF;
891: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
892: END copy_terms_template;
893:

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

887: x_return_status := G_RET_STS_UNEXP_ERROR ;
888: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
889: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
890: END IF;
891: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
892: END copy_terms_template;
893:
894: /*
895: --To be used when instantiating a term on a document.

Line 984: FND_MSG_PUB.initialize;

980: END IF;
981:
982: -- Initialize message list if p_init_msg_list is set to TRUE.
983: IF FND_API.to_Boolean( p_init_msg_list ) THEN
984: FND_MSG_PUB.initialize;
985: END IF;
986:
987: IF FND_API.To_Boolean( p_validate_commit ) AND
988: NOT FND_API.To_Boolean(OKC_TERMS_UTIL_GRP.ok_to_commit (

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

1163: COMMIT WORK;
1164: END IF;
1165:
1166: -- Standard call to get message count and if count is 1, get message info.
1167: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1168:
1169: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1170: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving copy_terms');
1171: END IF;

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

1181: END IF;
1182:
1183: ROLLBACK TO g_copy_terms_grp;
1184: x_return_status := G_RET_STS_ERROR ;
1185: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1186:
1187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1188: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1189: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

1191:
1192:
1193: ROLLBACK TO g_copy_terms_grp;
1194: x_return_status := G_RET_STS_UNEXP_ERROR ;
1195: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1196:
1197: WHEN OTHERS THEN
1198: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1199: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving copy_terms because of EXCEPTION: '||sqlerrm);

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

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

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

1201:
1202: ROLLBACK TO g_copy_terms_grp;
1203: x_return_status := G_RET_STS_UNEXP_ERROR ;
1204: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1205: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1206: END IF;
1207: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1208:
1209:

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

1203: x_return_status := G_RET_STS_UNEXP_ERROR ;
1204: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1205: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1206: END IF;
1207: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1208:
1209:
1210: END copy_terms;
1211:

Line 1259: FND_MSG_PUB.initialize;

1255: END IF;
1256:
1257: -- Initialize message list if p_init_msg_list is set to TRUE.
1258: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1259: FND_MSG_PUB.initialize;
1260: END IF;
1261:
1262: -- Initialize API return status to success
1263: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1386: COMMIT WORK;
1387: END IF;
1388:
1389: -- Standard call to get message count and if count is 1, get message info.
1390: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1391:
1392: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1393: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving create_template_revision');
1394: END IF;

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

1406: END IF;
1407:
1408: ROLLBACK TO g_create_template_revision_grp;
1409: x_return_status := G_RET_STS_ERROR ;
1410: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1411:
1412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1413: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1414: 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 1423: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

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

1433: END IF;
1434:
1435: ROLLBACK TO g_create_template_revision_grp;
1436: x_return_status := G_RET_STS_UNEXP_ERROR ;
1437: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1438: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1439: END IF;
1440: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1441: END create_template_revision;

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

1434:
1435: ROLLBACK TO g_create_template_revision_grp;
1436: x_return_status := G_RET_STS_UNEXP_ERROR ;
1437: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1438: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1439: END IF;
1440: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1441: END create_template_revision;
1442:

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

1436: x_return_status := G_RET_STS_UNEXP_ERROR ;
1437: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1438: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1439: END IF;
1440: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1441: END create_template_revision;
1442:
1443: /*
1444: -- To be used while copying a document from archive to make a new document.

Line 1493: FND_MSG_PUB.initialize;

1489: END IF;
1490:
1491: -- Initialize message list if p_init_msg_list is set to TRUE.
1492: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1493: FND_MSG_PUB.initialize;
1494: END IF;
1495:
1496: -- Initialize API return status to success
1497: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1529: COMMIT WORK;
1530: END IF;
1531:
1532: -- Standard call to get message count and if count is 1, get message info.
1533: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1534:
1535: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1536: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving copy_archived_doc');
1537: END IF;

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

1545: END IF;
1546:
1547: ROLLBACK TO g_copy_archived_doc_grp;
1548: x_return_status := G_RET_STS_ERROR ;
1549: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1550:
1551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1552: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1553: 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 1558: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1554: END IF;
1555:
1556: ROLLBACK TO g_copy_archived_doc_grp;
1557: x_return_status := G_RET_STS_UNEXP_ERROR ;
1558: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1559:
1560: WHEN OTHERS THEN
1561: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1562: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving copy_archived_doc because of EXCEPTION: '||sqlerrm);

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

1563: END IF;
1564:
1565: ROLLBACK TO g_copy_archived_doc_grp;
1566: x_return_status := G_RET_STS_UNEXP_ERROR ;
1567: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1568: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1569: END IF;
1570: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1571: END copy_archived_doc;

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

1564:
1565: ROLLBACK TO g_copy_archived_doc_grp;
1566: x_return_status := G_RET_STS_UNEXP_ERROR ;
1567: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1568: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1569: END IF;
1570: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1571: END copy_archived_doc;
1572:

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

1566: x_return_status := G_RET_STS_UNEXP_ERROR ;
1567: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1568: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1569: END IF;
1570: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1571: END copy_archived_doc;
1572:
1573: /*************************************************************
1574: 07-APR-2004 pnayani: bug#3524864 added copy_response_doc API |

Line 1648: FND_MSG_PUB.initialize;

1644: END IF;
1645:
1646: -- Initialize message list if p_init_msg_list is set to TRUE.
1647: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1648: FND_MSG_PUB.initialize;
1649: END IF;
1650:
1651: -- Initialize API return status to success
1652: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1757: COMMIT WORK;
1758: END IF;
1759:
1760: -- Standard call to get message count and if count is 1, get message info.
1761: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1762:
1763: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1764: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving copy_response_doc');
1765: END IF;

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

1773: END IF;
1774:
1775: ROLLBACK TO g_copy_doc_grp;
1776: x_return_status := G_RET_STS_ERROR ;
1777: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1778:
1779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1780: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1781: 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 1786: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

1782: END IF;
1783:
1784: ROLLBACK TO g_copy_doc_grp;
1785: x_return_status := G_RET_STS_UNEXP_ERROR ;
1786: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1787:
1788: WHEN OTHERS THEN
1789: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1790: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving copy_response_doc because of EXCEPTION: '||sqlerrm);

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

1791: END IF;
1792:
1793: ROLLBACK TO g_copy_doc_grp;
1794: x_return_status := G_RET_STS_UNEXP_ERROR ;
1795: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1796: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1797: END IF;
1798: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1799: END copy_response_doc;

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

1792:
1793: ROLLBACK TO g_copy_doc_grp;
1794: x_return_status := G_RET_STS_UNEXP_ERROR ;
1795: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1796: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1797: END IF;
1798: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1799: END copy_response_doc;
1800:

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

1794: x_return_status := G_RET_STS_UNEXP_ERROR ;
1795: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1796: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1797: END IF;
1798: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1799: END copy_response_doc;
1800:
1801:
1802: PROCEDURE process_mod_terms (

Line 1881: FND_MSG_PUB.initialize;

1877: END IF;
1878:
1879: -- Initialize message list if p_init_msg_list is set to TRUE.
1880: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1881: FND_MSG_PUB.initialize;
1882: END IF;
1883:
1884: -- Initialize API return status to success
1885: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1948: COMMIT WORK;
1949: END IF;
1950:
1951: -- Standard call to get message count and if count is 1, get message info.
1952: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1953:
1954: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1955: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'900: Leaving process_mod_terms');
1956: END IF;

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

2060: COMMIT WORK;
2061: END IF;
2062:
2063: -- Standard call to get message count and if count is 1, get message info.
2064: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2065:
2066: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2067: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'1000: Leaving process_mod_terms');
2068: END IF;

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

2076: END IF;
2077:
2078: ROLLBACK TO g_process_mod_terms_GRP;
2079: x_return_status := G_RET_STS_ERROR ;
2080: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2081:
2082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2083: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2084: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving process_mod_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

2085: END IF;
2086:
2087: ROLLBACK TO g_process_mod_terms_GRP;
2088: x_return_status := G_RET_STS_UNEXP_ERROR ;
2089: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2090:
2091: WHEN OTHERS THEN
2092: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2093: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'1000: Leaving process_mod_terms because of EXCEPTION: '||sqlerrm);

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

2094: END IF;
2095:
2096: ROLLBACK TO g_process_mod_terms_GRP;
2097: x_return_status := G_RET_STS_UNEXP_ERROR ;
2098: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2099: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2100: END IF;
2101: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2102:

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

2095:
2096: ROLLBACK TO g_process_mod_terms_GRP;
2097: x_return_status := G_RET_STS_UNEXP_ERROR ;
2098: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2099: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2100: END IF;
2101: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2102:
2103: END process_mod_terms;

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

2097: x_return_status := G_RET_STS_UNEXP_ERROR ;
2098: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2099: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2100: END IF;
2101: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2102:
2103: END process_mod_terms;
2104:
2105: