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

Line 80: /* Proceedure loops through the FND_MSG_PUB stack and sets the

76:
77: ---------------------------------------------------------------------------
78: -- Procedure set_wf_error_context
79: ---------------------------------------------------------------------------
80: /* Proceedure loops through the FND_MSG_PUB stack and sets the
81: workflow error context to give as much information as possible to wf engine
82: in case an api fails
83: */
84: PROCEDURE set_wf_error_context(

Line 112: l_arg_tbl(k) := substrb(FND_MSG_PUB.get(p_msg_index => k,p_encoded => 'F'), 1, 2000);

108: ' funcmode='||p_funcmode,1,2000);
109:
110: FOR k in 1..p_msg_count LOOP
111: EXIT WHEN k >= 4;
112: l_arg_tbl(k) := substrb(FND_MSG_PUB.get(p_msg_index => k,p_encoded => 'F'), 1, 2000);
113: END LOOP;
114:
115: WF_CORE.CONTEXT(p_pkg_name, p_api_name,
116: l_arg_tbl(0), l_arg_tbl(1), l_arg_tbl(2),l_arg_tbl(3),l_arg_tbl(4));

Line 447: FND_MSG_PUB.initialize;

443: END IF;
444:
445: -- Initialize message list if p_init_msg_list is set to TRUE.
446: IF FND_API.to_Boolean( p_init_msg_list ) THEN
447: FND_MSG_PUB.initialize;
448: END IF;
449:
450: -- Initialize API return status to success
451: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 673: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, 'change_clause_status', get_error_string(l_art_validation_results));

669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
670: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
671: -- get the validation results as a simple string
672: -- and add to fnd message stack
673: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, 'change_clause_status', get_error_string(l_art_validation_results));
674: RAISE FND_API.G_EXC_ERROR;
675: END IF;
676:
677: UPDATE okc_terms_templates_all

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

831: wf_engine.StartProcess( itemtype => l_itemtype,
832: itemkey => l_itemkey );
833:
834: -- Standard call to get message count and if count is 1, get message info.
835: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
836:
837: /*IF (l_debug = 'Y') THEN
838: okc_debug.log('1000: Leaving start_approval', 2);
839: END IF;*/

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

857: END IF;
858:
859: ROLLBACK TO g_start_approval_pvt;
860: x_return_status := G_RET_STS_ERROR ;
861: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
862:
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: /*IF (l_debug = 'Y') THEN
865: okc_debug.log('900: Leaving start_approval: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

871: END IF;
872:
873: ROLLBACK TO g_start_approval_pvt;
874: x_return_status := G_RET_STS_UNEXP_ERROR ;
875: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
876:
877: WHEN OTHERS THEN
878: /*IF (l_debug = 'Y') THEN
879: okc_debug.log('1000: Leaving start_approval because of EXCEPTION: '||sqlerrm, 2);

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

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

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

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

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

888: x_return_status := G_RET_STS_UNEXP_ERROR ;
889: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
890: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
891: END IF;
892: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
893: END start_approval;
894:
895: ---------------------------------------------------------------------------
896: -- Procedure approve_template

Line 1566: FND_MSG_PUB.initialize;

1562: END IF;
1563:
1564: -- Initialize message list if p_init_msg_list is set to TRUE.
1565: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1566: FND_MSG_PUB.initialize;
1567: END IF;
1568:
1569: -- Initialize API return status to success
1570: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1578: FND_MSG_PUB.add;

1574: x_return_status := FND_API.G_RET_STS_ERROR;
1575: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
1576: FND_MESSAGE.set_token('ARG_NAME', 'p_status');
1577: FND_MESSAGE.set_token('ARG_VALUE', p_status);
1578: FND_MSG_PUB.add;
1579: RAISE FND_API.G_EXC_ERROR;
1580: END IF;
1581:
1582: OPEN l_tmpl_csr(p_template_id);

Line 1590: FND_MSG_PUB.add;

1586: CLOSE l_tmpl_csr;
1587: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
1588: FND_MESSAGE.set_token('ARG_NAME', 'p_template_id');
1589: FND_MESSAGE.set_token('ARG_VALUE', p_template_id);
1590: FND_MSG_PUB.add;
1591: RAISE FND_API.G_EXC_ERROR;
1592: END IF;
1593:
1594: OPEN l_tmpl_clauses_csr(p_template_id, p_wf_seq_id);

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

1656: END IF;
1657:
1658:
1659: -- Standard call to get message count and if count is 1, get message info.
1660: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1661:
1662: IF(FND_API.to_boolean(p_commit)) THEN
1663: COMMIT;
1664: END IF;

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

1693: END IF;
1694:
1695: ROLLBACK TO change_clause_status_pvt;
1696: x_return_status := G_RET_STS_ERROR ;
1697: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1698:
1699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1700: /*IF (l_debug = 'Y') THEN
1701: okc_debug.log('900: Leaving change_clause_status: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

1714: END IF;
1715:
1716: ROLLBACK TO change_clause_status_pvt;
1717: x_return_status := G_RET_STS_UNEXP_ERROR ;
1718: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1719:
1720: WHEN OTHERS THEN
1721: /*IF (l_debug = 'Y') THEN
1722: okc_debug.log('1000: Leaving change_clause_status because of EXCEPTION: '||sqlerrm, 2);

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

1735: END IF;
1736:
1737: ROLLBACK TO change_clause_status_pvt;
1738: x_return_status := G_RET_STS_UNEXP_ERROR ;
1739: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1740: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1741: END IF;
1742: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1743: END change_clause_status;

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

1736:
1737: ROLLBACK TO change_clause_status_pvt;
1738: x_return_status := G_RET_STS_UNEXP_ERROR ;
1739: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1740: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1741: END IF;
1742: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1743: END change_clause_status;
1744:

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

1738: x_return_status := G_RET_STS_UNEXP_ERROR ;
1739: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1740: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1741: END IF;
1742: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1743: END change_clause_status;
1744:
1745: ---------------------------------------------------------------------------
1746: -- Function get_error_string

Line 2159: FND_MSG_PUB.initialize;

2155: END IF;
2156:
2157: -- Initialize message list if p_init_msg_list is set to TRUE.
2158: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2159: FND_MSG_PUB.initialize;
2160: END IF;
2161:
2162: -- Initialize API return status to success
2163: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2168: select template_id from okc_terms_templates_all
2169: where template_id = p_template_id and status_code in ('DRAFT', 'REJECTED', 'REVISION'));
2170:
2171: -- Standard call to get message count and if count is 1, get message info.
2172: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2173:
2174: IF(FND_API.to_boolean(p_commit)) THEN
2175: COMMIT;
2176: END IF;

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

2198: END IF;
2199:
2200: ROLLBACK TO change_clause_status_pvt;
2201: x_return_status := G_RET_STS_ERROR ;
2202: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2203:
2204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2205: /*IF (l_debug = 'Y') THEN
2206: okc_debug.log('900: Leaving select_draft_clauses: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

2212: END IF;
2213:
2214: ROLLBACK TO change_clause_status_pvt;
2215: x_return_status := G_RET_STS_UNEXP_ERROR ;
2216: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2217:
2218: WHEN OTHERS THEN
2219: /*IF (l_debug = 'Y') THEN
2220: okc_debug.log('1000: Leaving select_draft_clauses because of EXCEPTION: '||sqlerrm, 2);

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

2226: END IF;
2227:
2228: ROLLBACK TO change_clause_status_pvt;
2229: x_return_status := G_RET_STS_UNEXP_ERROR ;
2230: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2231: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2232: END IF;
2233: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2234: END select_draft_clauses;

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

2227:
2228: ROLLBACK TO change_clause_status_pvt;
2229: x_return_status := G_RET_STS_UNEXP_ERROR ;
2230: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2231: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2232: END IF;
2233: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2234: END select_draft_clauses;
2235:

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

2229: x_return_status := G_RET_STS_UNEXP_ERROR ;
2230: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2231: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2232: END IF;
2233: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2234: END select_draft_clauses;
2235:
2236: end OKC_TERMS_TMPL_APPROVAL_PVT;