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 1379: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

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

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

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

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

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

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

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

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

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

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

Line 1485: FND_MSG_PUB.initialize;

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

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

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

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

1536: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3400: Leaving Delete_Ver_Attachments: OKC_API.G_EXCEPTION_ERROR Exception');
1537: END IF;
1538: ROLLBACK TO Delete_Ver_Attachments_GRP;
1539: x_return_status := G_RET_STS_ERROR ;
1540: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1541:
1542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1543: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1544: 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 1548: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

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

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

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

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

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

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

Line 1619: FND_MSG_PUB.initialize;

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

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

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

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

1688: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4000: Leaving Delete_Doc_Attachments: OKC_API.G_EXCEPTION_ERROR Exception');
1689: END IF;
1690: ROLLBACK TO Delete_Doc_Attachments_GRP;
1691: x_return_status := G_RET_STS_ERROR ;
1692: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1693:
1694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1695: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1696: 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 1700: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

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

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

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

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

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

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

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

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

2066: END IF;
2067: END LOOP;
2068:
2069: -- Standard call to get message count and if count is 1, get message info.
2070: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2071:
2072: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2073: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4900: Leaving Copy_Attachment_Docs');
2074: END IF;

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

2084: CLOSE doc_version_view_name_csr;
2085: END IF;
2086:
2087: x_return_status := G_RET_STS_ERROR ;
2088: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2089:
2090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2091: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2092: 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 2101: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

2097: CLOSE doc_version_view_name_csr;
2098: END IF;
2099:
2100: x_return_status := G_RET_STS_UNEXP_ERROR ;
2101: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2102:
2103: WHEN OTHERS THEN
2104: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2105: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'482: Leaving Copy_Attachment_Docs because of EXCEPTION: '||sqlerrm);

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

2110: CLOSE doc_version_view_name_csr;
2111: END IF;
2112:
2113: x_return_status := G_RET_STS_UNEXP_ERROR ;
2114: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2115: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2116: END IF;
2117: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2118:

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

2111: END IF;
2112:
2113: x_return_status := G_RET_STS_UNEXP_ERROR ;
2114: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2115: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2116: END IF;
2117: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2118:
2119:

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

2113: x_return_status := G_RET_STS_UNEXP_ERROR ;
2114: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2115: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2116: END IF;
2117: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2118:
2119:
2120: END Copy_Attachment_Docs;
2121:

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

2297: END LOOP;
2298:
2299:
2300: -- Standard call to get message count and if count is 1, get message info.
2301: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2302: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2303: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5100: Leaving Copy_Attachment_Refs');
2304: END IF;
2305:

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

2311: IF (category_csr%ISOPEN) THEN
2312: CLOSE category_csr ;
2313: END IF;
2314: x_return_status := G_RET_STS_ERROR ;
2315: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2316:
2317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2318: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2319: 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 2325: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );

2321: IF (category_csr%ISOPEN) THEN
2322: CLOSE category_csr ;
2323: END IF;
2324: x_return_status := G_RET_STS_UNEXP_ERROR ;
2325: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2326:
2327: WHEN OTHERS THEN
2328: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2329: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5083: Leaving Copy_Attachment_Refs because of EXCEPTION: '||sqlerrm);

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

2331: IF (category_csr%ISOPEN) THEN
2332: CLOSE category_csr ;
2333: END IF;
2334: x_return_status := G_RET_STS_UNEXP_ERROR ;
2335: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2336: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2337: END IF;
2338: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2339:

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

2332: CLOSE category_csr ;
2333: END IF;
2334: x_return_status := G_RET_STS_UNEXP_ERROR ;
2335: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2336: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2337: END IF;
2338: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2339:
2340: END Copy_Attachment_Refs;

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

2334: x_return_status := G_RET_STS_UNEXP_ERROR ;
2335: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2336: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2337: END IF;
2338: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2339:
2340: END Copy_Attachment_Refs;
2341:
2342:

Line 2423: FND_MSG_PUB.initialize;

2419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2420: END IF;
2421: -- Initialize message list if p_init_msg_list is set to TRUE.
2422: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2423: FND_MSG_PUB.initialize;
2424: END IF;
2425:
2426: -- Initialize API return status to success
2427: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2477: IF FND_API.To_Boolean( p_commit ) THEN
2478: COMMIT WORK;
2479: END IF;
2480: -- Standard call to get message count and if count is 1, get message info.
2481: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2482: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2483: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4400: Leaving Copy_Attachments');
2484: END IF;
2485:

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

2489: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4500: Leaving Copy_Attachments: OKC_API.G_EXCEPTION_ERROR Exception');
2490: END IF;
2491: ROLLBACK TO Copy_Attachments_GRP;
2492: x_return_status := G_RET_STS_ERROR ;
2493: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2494:
2495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2496: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2497: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4600: Leaving Copy_Attachments: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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

2497: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4600: Leaving Copy_Attachments: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2498: END IF;
2499: ROLLBACK TO Copy_Attachments_GRP;
2500: x_return_status := G_RET_STS_UNEXP_ERROR ;
2501: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2502:
2503: WHEN OTHERS THEN
2504: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2505: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4700: Leaving Copy_Attachments because of EXCEPTION: '||sqlerrm);

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

2505: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4700: Leaving Copy_Attachments because of EXCEPTION: '||sqlerrm);
2506: END IF;
2507: ROLLBACK TO Copy_Attachments_GRP;
2508: x_return_status := G_RET_STS_UNEXP_ERROR ;
2509: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2510: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2511: END IF;
2512: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2513: END Copy_Attachments;

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

2506: END IF;
2507: ROLLBACK TO Copy_Attachments_GRP;
2508: x_return_status := G_RET_STS_UNEXP_ERROR ;
2509: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2510: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2511: END IF;
2512: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2513: END Copy_Attachments;
2514:

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

2508: x_return_status := G_RET_STS_UNEXP_ERROR ;
2509: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2510: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2511: END IF;
2512: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2513: END Copy_Attachments;
2514:
2515:
2516: PROCEDURE qa_doc(

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

2592:
2593: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2594: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2300: Leaving QA_Doc');
2595: END IF;
2596: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2597:
2598: EXCEPTION
2599: WHEN FND_API.G_EXC_ERROR THEN
2600: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2604: CLOSE l_get_qa_detail_csr ;
2605: END IF;
2606: ROLLBACK TO g_QA_Doc;
2607: x_return_status := G_RET_STS_ERROR ;
2608: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2609:
2610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2611: ROLLBACK TO g_QA_Doc;
2612: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

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: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2621:
2622: WHEN OTHERS THEN
2623: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2624: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2600: Leaving QA_Doc because of EXCEPTION: '||sqlerrm);

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

2627: CLOSE l_get_qa_detail_csr ;
2628: END IF;
2629: ROLLBACK TO g_QA_Doc;
2630: x_return_status := G_RET_STS_UNEXP_ERROR ;
2631: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2632: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2633: END IF;
2634: END QA_Doc;
2635:

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

2628: END IF;
2629: ROLLBACK TO g_QA_Doc;
2630: x_return_status := G_RET_STS_UNEXP_ERROR ;
2631: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2632: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2633: END IF;
2634: END QA_Doc;
2635:
2636: -- Returns 'Y' - Attached document is oracle generated and mergeable.