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

Line 173: FND_MSG_PUB.initialize;

169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170: END IF;
171: -- Initialize message list if p_init_msg_list is set to TRUE.
172: IF FND_API.to_Boolean( p_init_msg_list ) THEN
173: FND_MSG_PUB.initialize;
174: END IF;
175: -- Initialize API return status to success
176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177:

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

342: IF FND_API.To_Boolean( p_commit ) THEN
343: COMMIT WORK;
344: END IF;
345: -- Standard call to get message count and if count is 1, get message info.
346: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
347:
348: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
349: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'700: Leaving Insert_Contract_Doc');
350: END IF;

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

358: CLOSE l_attachment_id_csr;
359: END IF;
360: ROLLBACK TO g_Insert_Contract_Doc_GRP;
361: x_return_status := G_RET_STS_ERROR ;
362: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
363:
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
365: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
366: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'900: Leaving Insert_Contract_Doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

369: CLOSE l_attachment_id_csr;
370: END IF;
371: ROLLBACK TO g_Insert_Contract_Doc_GRP;
372: x_return_status := G_RET_STS_UNEXP_ERROR ;
373: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
374:
375: WHEN OTHERS THEN
376: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
377: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1000: Leaving Insert_Contract_Doc because of EXCEPTION: '||sqlerrm);

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

380: CLOSE l_attachment_id_csr;
381: END IF;
382: ROLLBACK TO g_Insert_Contract_Doc_GRP;
383: x_return_status := G_RET_STS_UNEXP_ERROR ;
384: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
385: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
386: END IF;
387: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
388:

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

381: END IF;
382: ROLLBACK TO g_Insert_Contract_Doc_GRP;
383: x_return_status := G_RET_STS_UNEXP_ERROR ;
384: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
385: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
386: END IF;
387: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
388:
389: END Insert_Contract_Doc;

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

383: x_return_status := G_RET_STS_UNEXP_ERROR ;
384: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
385: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
386: END IF;
387: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
388:
389: END Insert_Contract_Doc;
390:
391:

Line 499: FND_MSG_PUB.initialize;

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

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

565: IF FND_API.To_Boolean( p_commit ) THEN
566: COMMIT WORK;
567: END IF;
568: -- Standard call to get message count and if count is 1, get message info.
569: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
570:
571: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
572: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1800: Leaving Update_Contract_Doc');
573: END IF;

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

581: CLOSE contract_doc_csr ;
582: END IF;
583: ROLLBACK TO g_Update_Contract_Doc_GRP;
584: x_return_status := G_RET_STS_ERROR ;
585: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
586:
587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
588: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
589: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2000: Leaving Update_Contract_Doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

592: CLOSE contract_doc_csr ;
593: END IF;
594: ROLLBACK TO g_Update_Contract_Doc_GRP;
595: x_return_status := G_RET_STS_UNEXP_ERROR ;
596: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
597:
598: WHEN OTHERS THEN
599: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
600: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2100: Leaving Update_Contract_Doc because of EXCEPTION: '||sqlerrm);

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

603: CLOSE contract_doc_csr ;
604: END IF;
605: ROLLBACK TO g_Update_Contract_Doc_GRP;
606: x_return_status := G_RET_STS_UNEXP_ERROR ;
607: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
608: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
609: END IF;
610: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
611:

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

604: END IF;
605: ROLLBACK TO g_Update_Contract_Doc_GRP;
606: x_return_status := G_RET_STS_UNEXP_ERROR ;
607: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
608: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
609: END IF;
610: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
611:
612: END Update_Contract_Doc;

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

606: x_return_status := G_RET_STS_UNEXP_ERROR ;
607: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
608: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
609: END IF;
610: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
611:
612: END Update_Contract_Doc;
613:
614:

Line 732: FND_MSG_PUB.initialize;

728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
729: END IF;
730: -- Initialize message list if p_init_msg_list is set to TRUE.
731: IF FND_API.to_Boolean( p_init_msg_list ) THEN
732: FND_MSG_PUB.initialize;
733: END IF;
734: -- Initialize API return status to success
735: x_return_status := FND_API.G_RET_STS_SUCCESS;
736:

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

983: IF FND_API.To_Boolean( p_commit ) THEN
984: COMMIT WORK;
985: END IF;
986: -- Standard call to get message count and if count is 1, get message info.
987: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
988:
989: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
990: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving Delete_Contract_Doc');
991: END IF;

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

1003: CLOSE fnd_doc_csr ;
1004: END IF;
1005: ROLLBACK TO g_Delete_Contract_Doc_GRP;
1006: x_return_status := G_RET_STS_ERROR ;
1007: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1008:
1009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1010: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1011: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2500: Leaving Delete_Contract_Doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

1017: CLOSE fnd_doc_csr ;
1018: END IF;
1019: ROLLBACK TO g_Delete_Contract_Doc_GRP;
1020: x_return_status := G_RET_STS_UNEXP_ERROR ;
1021: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1022:
1023: WHEN OTHERS THEN
1024: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1025: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2600: Leaving Delete_Contract_Doc because of EXCEPTION: '||sqlerrm);

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

1031: CLOSE fnd_doc_csr ;
1032: END IF;
1033: ROLLBACK TO g_Delete_Contract_Doc_GRP;
1034: x_return_status := G_RET_STS_UNEXP_ERROR ;
1035: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1036: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1037: END IF;
1038: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1039:

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

1032: END IF;
1033: ROLLBACK TO g_Delete_Contract_Doc_GRP;
1034: x_return_status := G_RET_STS_UNEXP_ERROR ;
1035: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1036: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1037: END IF;
1038: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1039:
1040: END Delete_Contract_Doc;

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

1034: x_return_status := G_RET_STS_UNEXP_ERROR ;
1035: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1036: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1037: END IF;
1038: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1039:
1040: END Delete_Contract_Doc;
1041:
1042:

Line 1128: FND_MSG_PUB.initialize;

1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1125: END IF;
1126: -- Initialize message list if p_init_msg_list is set to TRUE.
1127: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1128: FND_MSG_PUB.initialize;
1129: END IF;
1130:
1131: -- Initialize API return status to success
1132: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1373: IF FND_API.To_Boolean( p_commit ) THEN
1374: COMMIT WORK;
1375: END IF;
1376: -- Standard call to get message count and if count is 1, get message info.
1377: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1378:
1379: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1380: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2800: Leaving Version_Attachments');
1381: END IF;

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

1389: CLOSE datatype_csr ;
1390: END IF;
1391: ROLLBACK TO Version_Attachments_GRP;
1392: x_return_status := G_RET_STS_ERROR ;
1393: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1394:
1395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1396: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1397: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3000: Leaving Version_Attachments: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

1400: CLOSE datatype_csr ;
1401: END IF;
1402: ROLLBACK TO Version_Attachments_GRP;
1403: x_return_status := G_RET_STS_UNEXP_ERROR ;
1404: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1405:
1406: WHEN OTHERS THEN
1407: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1408: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3100: Leaving Version_Attachments because of EXCEPTION: '||sqlerrm);

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

1411: CLOSE datatype_csr ;
1412: END IF;
1413: ROLLBACK TO Version_Attachments_GRP;
1414: x_return_status := G_RET_STS_UNEXP_ERROR ;
1415: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1416: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1417: END IF;
1418: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1419: END Version_Attachments;

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

1412: END IF;
1413: ROLLBACK TO Version_Attachments_GRP;
1414: x_return_status := G_RET_STS_UNEXP_ERROR ;
1415: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1416: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1417: END IF;
1418: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1419: END Version_Attachments;
1420:

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

1414: x_return_status := G_RET_STS_UNEXP_ERROR ;
1415: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1416: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1417: END IF;
1418: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1419: END Version_Attachments;
1420:
1421:
1422:

Line 1483: FND_MSG_PUB.initialize;

1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1480: END IF;
1481: -- Initialize message list if p_init_msg_list is set to TRUE.
1482: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1483: FND_MSG_PUB.initialize;
1484: END IF;
1485:
1486: -- Initialize API return status to success
1487: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1521: IF FND_API.To_Boolean( p_commit ) THEN
1522: COMMIT WORK;
1523: END IF;
1524: -- Standard call to get message count and if count is 1, get message info.
1525: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1526:
1527: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1528: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3300: Leaving Delete_Ver_Attachments');
1529: END IF;

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

1534: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3400: Leaving Delete_Ver_Attachments: OKC_API.G_EXCEPTION_ERROR Exception');
1535: END IF;
1536: ROLLBACK TO Delete_Ver_Attachments_GRP;
1537: x_return_status := G_RET_STS_ERROR ;
1538: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1539:
1540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1541: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1542: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3500: Leaving Delete_Ver_Attachments: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

1542: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3500: Leaving Delete_Ver_Attachments: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1543: END IF;
1544: ROLLBACK TO Delete_Ver_Attachments_GRP;
1545: x_return_status := G_RET_STS_UNEXP_ERROR ;
1546: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1547:
1548: WHEN OTHERS THEN
1549: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1550: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3600: Leaving Delete_Ver_Attachments because of EXCEPTION: '||sqlerrm);

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

1551: END IF;
1552:
1553: ROLLBACK TO Delete_Ver_Attachments_GRP;
1554: x_return_status := G_RET_STS_UNEXP_ERROR ;
1555: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1556: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1557: END IF;
1558: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1559:

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

1552:
1553: ROLLBACK TO Delete_Ver_Attachments_GRP;
1554: x_return_status := G_RET_STS_UNEXP_ERROR ;
1555: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1556: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1557: END IF;
1558: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1559:
1560: END Delete_Ver_Attachments;

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

1554: x_return_status := G_RET_STS_UNEXP_ERROR ;
1555: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1556: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1557: END IF;
1558: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1559:
1560: END Delete_Ver_Attachments;
1561:
1562:

Line 1617: FND_MSG_PUB.initialize;

1613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1614: END IF;
1615: -- Initialize message list if p_init_msg_list is set to TRUE.
1616: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1617: FND_MSG_PUB.initialize;
1618: END IF;
1619:
1620: -- Initialize API return status to success
1621: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1673: IF FND_API.To_Boolean( p_commit ) THEN
1674: COMMIT WORK;
1675: END IF;
1676: -- Standard call to get message count and if count is 1, get message info.
1677: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1678:
1679: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1680: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3900: Leaving Delete_Doc_Attachments');
1681: END IF;

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

1686: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4000: Leaving Delete_Doc_Attachments: OKC_API.G_EXCEPTION_ERROR Exception');
1687: END IF;
1688: ROLLBACK TO Delete_Doc_Attachments_GRP;
1689: x_return_status := G_RET_STS_ERROR ;
1690: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1691:
1692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1693: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1694: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4100: Leaving Delete_Doc_Attachments: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

1694: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4100: Leaving Delete_Doc_Attachments: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1695: END IF;
1696: ROLLBACK TO Delete_Doc_Attachments_GRP;
1697: x_return_status := G_RET_STS_UNEXP_ERROR ;
1698: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1699:
1700: WHEN OTHERS THEN
1701: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1702: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4200: Leaving Delete_Doc_Attachments because of EXCEPTION: '||sqlerrm);

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

1703: END IF;
1704:
1705: ROLLBACK TO Delete_Doc_Attachments_GRP;
1706: x_return_status := G_RET_STS_UNEXP_ERROR ;
1707: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1708: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1709: END IF;
1710: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1711: END Delete_Doc_Attachments;

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

1704:
1705: ROLLBACK TO Delete_Doc_Attachments_GRP;
1706: x_return_status := G_RET_STS_UNEXP_ERROR ;
1707: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1708: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1709: END IF;
1710: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1711: END Delete_Doc_Attachments;
1712:

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

1706: x_return_status := G_RET_STS_UNEXP_ERROR ;
1707: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1708: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1709: END IF;
1710: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1711: END Delete_Doc_Attachments;
1712:
1713:
1714:

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

2055: END IF;
2056: END LOOP;
2057:
2058: -- Standard call to get message count and if count is 1, get message info.
2059: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2060:
2061: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2062: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4900: Leaving Copy_Attachment_Docs');
2063: END IF;

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

2073: CLOSE doc_version_view_name_csr;
2074: END IF;
2075:
2076: x_return_status := G_RET_STS_ERROR ;
2077: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2078:
2079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2080: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2081: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4841: Leaving Copy_Attachment_Docs: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

2086: CLOSE doc_version_view_name_csr;
2087: END IF;
2088:
2089: x_return_status := G_RET_STS_UNEXP_ERROR ;
2090: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2091:
2092: WHEN OTHERS THEN
2093: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2094: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'482: Leaving Copy_Attachment_Docs because of EXCEPTION: '||sqlerrm);

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

2099: CLOSE doc_version_view_name_csr;
2100: END IF;
2101:
2102: x_return_status := G_RET_STS_UNEXP_ERROR ;
2103: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2104: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2105: END IF;
2106: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2107:

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

2100: END IF;
2101:
2102: x_return_status := G_RET_STS_UNEXP_ERROR ;
2103: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2104: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2105: END IF;
2106: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2107:
2108:

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

2102: x_return_status := G_RET_STS_UNEXP_ERROR ;
2103: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2104: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2105: END IF;
2106: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2107:
2108:
2109: END Copy_Attachment_Docs;
2110:

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

2286: END LOOP;
2287:
2288:
2289: -- Standard call to get message count and if count is 1, get message info.
2290: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2291: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2292: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5100: Leaving Copy_Attachment_Refs');
2293: END IF;
2294:

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

2300: IF (category_csr%ISOPEN) THEN
2301: CLOSE category_csr ;
2302: END IF;
2303: x_return_status := G_RET_STS_ERROR ;
2304: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2305:
2306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2307: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2308: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5082: Leaving Copy_Attachment_Refs: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

2310: IF (category_csr%ISOPEN) THEN
2311: CLOSE category_csr ;
2312: END IF;
2313: x_return_status := G_RET_STS_UNEXP_ERROR ;
2314: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2315:
2316: WHEN OTHERS THEN
2317: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2318: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5083: Leaving Copy_Attachment_Refs because of EXCEPTION: '||sqlerrm);

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

2320: IF (category_csr%ISOPEN) THEN
2321: CLOSE category_csr ;
2322: END IF;
2323: x_return_status := G_RET_STS_UNEXP_ERROR ;
2324: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2326: END IF;
2327: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2328:

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

2321: CLOSE category_csr ;
2322: END IF;
2323: x_return_status := G_RET_STS_UNEXP_ERROR ;
2324: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2326: END IF;
2327: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2328:
2329: END Copy_Attachment_Refs;

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

2323: x_return_status := G_RET_STS_UNEXP_ERROR ;
2324: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2326: END IF;
2327: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2328:
2329: END Copy_Attachment_Refs;
2330:
2331:

Line 2412: FND_MSG_PUB.initialize;

2408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2409: END IF;
2410: -- Initialize message list if p_init_msg_list is set to TRUE.
2411: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2412: FND_MSG_PUB.initialize;
2413: END IF;
2414:
2415: -- Initialize API return status to success
2416: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2466: IF FND_API.To_Boolean( p_commit ) THEN
2467: COMMIT WORK;
2468: END IF;
2469: -- Standard call to get message count and if count is 1, get message info.
2470: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2471: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2472: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4400: Leaving Copy_Attachments');
2473: END IF;
2474:

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

2478: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4500: Leaving Copy_Attachments: OKC_API.G_EXCEPTION_ERROR Exception');
2479: END IF;
2480: ROLLBACK TO Copy_Attachments_GRP;
2481: x_return_status := G_RET_STS_ERROR ;
2482: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2483:
2484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2485: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2486: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4600: Leaving Copy_Attachments: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

2486: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4600: Leaving Copy_Attachments: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2487: END IF;
2488: ROLLBACK TO Copy_Attachments_GRP;
2489: x_return_status := G_RET_STS_UNEXP_ERROR ;
2490: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2491:
2492: WHEN OTHERS THEN
2493: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2494: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4700: Leaving Copy_Attachments because of EXCEPTION: '||sqlerrm);

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

2494: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4700: Leaving Copy_Attachments because of EXCEPTION: '||sqlerrm);
2495: END IF;
2496: ROLLBACK TO Copy_Attachments_GRP;
2497: x_return_status := G_RET_STS_UNEXP_ERROR ;
2498: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2499: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2500: END IF;
2501: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2502: END Copy_Attachments;

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

2495: END IF;
2496: ROLLBACK TO Copy_Attachments_GRP;
2497: x_return_status := G_RET_STS_UNEXP_ERROR ;
2498: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2499: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2500: END IF;
2501: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2502: END Copy_Attachments;
2503:

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

2497: x_return_status := G_RET_STS_UNEXP_ERROR ;
2498: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2499: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2500: END IF;
2501: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2502: END Copy_Attachments;
2503:
2504:
2505: PROCEDURE qa_doc(

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

2581:
2582: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2583: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving QA_Doc');
2584: END IF;
2585: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2586:
2587: EXCEPTION
2588: WHEN FND_API.G_EXC_ERROR THEN
2589: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2593: CLOSE l_get_qa_detail_csr ;
2594: END IF;
2595: ROLLBACK TO g_QA_Doc;
2596: x_return_status := G_RET_STS_ERROR ;
2597: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2598:
2599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2600: ROLLBACK TO g_QA_Doc;
2601: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2605: CLOSE l_get_qa_detail_csr ;
2606: END IF;
2607: ROLLBACK TO g_QA_Doc;
2608: x_return_status := G_RET_STS_UNEXP_ERROR ;
2609: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2610:
2611: WHEN OTHERS THEN
2612: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2613: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2600: Leaving QA_Doc because of EXCEPTION: '||sqlerrm);

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

2616: CLOSE l_get_qa_detail_csr ;
2617: END IF;
2618: ROLLBACK TO g_QA_Doc;
2619: x_return_status := G_RET_STS_UNEXP_ERROR ;
2620: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2621: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2622: END IF;
2623: END QA_Doc;
2624:

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

2617: END IF;
2618: ROLLBACK TO g_QA_Doc;
2619: x_return_status := G_RET_STS_UNEXP_ERROR ;
2620: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2621: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2622: END IF;
2623: END QA_Doc;
2624:
2625: -- Returns 'Y' - Attached document is oracle generated and mergeable.