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 432: FND_MSG_PUB.initialize;

428: END IF;
429:
430: -- Initialize message list if p_init_msg_list is set to TRUE.
431: IF FND_API.to_Boolean( p_init_msg_list ) THEN
432: FND_MSG_PUB.initialize;
433: END IF;
434:
435: -- Initialize API return status to success
436: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
655: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
656: -- get the validation results as a simple string
657: -- and add to fnd message stack
658: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, 'change_clause_status', get_error_string(l_art_validation_results));
659: RAISE FND_API.G_EXC_ERROR;
660: END IF;
661:
662: UPDATE okc_terms_templates_all

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

816: wf_engine.StartProcess( itemtype => l_itemtype,
817: itemkey => l_itemkey );
818:
819: -- Standard call to get message count and if count is 1, get message info.
820: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
821:
822: /*IF (l_debug = 'Y') THEN
823: okc_debug.log('1000: Leaving start_approval', 2);
824: END IF;*/

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

842: END IF;
843:
844: ROLLBACK TO g_start_approval_pvt;
845: x_return_status := G_RET_STS_ERROR ;
846: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
847:
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: /*IF (l_debug = 'Y') THEN
850: okc_debug.log('900: Leaving start_approval: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

856: END IF;
857:
858: ROLLBACK TO g_start_approval_pvt;
859: x_return_status := G_RET_STS_UNEXP_ERROR ;
860: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
861:
862: WHEN OTHERS THEN
863: /*IF (l_debug = 'Y') THEN
864: okc_debug.log('1000: Leaving start_approval because of EXCEPTION: '||sqlerrm, 2);

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

870: END IF;
871:
872: ROLLBACK TO g_start_approval_pvt;
873: x_return_status := G_RET_STS_UNEXP_ERROR ;
874: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
875: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
876: END IF;
877: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
878: END start_approval;

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

871:
872: ROLLBACK TO g_start_approval_pvt;
873: x_return_status := G_RET_STS_UNEXP_ERROR ;
874: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
875: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
876: END IF;
877: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
878: END start_approval;
879:

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

873: x_return_status := G_RET_STS_UNEXP_ERROR ;
874: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
875: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
876: END IF;
877: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
878: END start_approval;
879:
880: ---------------------------------------------------------------------------
881: -- Procedure approve_template

Line 1517: FND_MSG_PUB.initialize;

1513: END IF;
1514:
1515: -- Initialize message list if p_init_msg_list is set to TRUE.
1516: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1517: FND_MSG_PUB.initialize;
1518: END IF;
1519:
1520: -- Initialize API return status to success
1521: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1529: FND_MSG_PUB.add;

1525: x_return_status := FND_API.G_RET_STS_ERROR;
1526: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
1527: FND_MESSAGE.set_token('ARG_NAME', 'p_status');
1528: FND_MESSAGE.set_token('ARG_VALUE', p_status);
1529: FND_MSG_PUB.add;
1530: RAISE FND_API.G_EXC_ERROR;
1531: END IF;
1532:
1533: OPEN l_tmpl_csr(p_template_id);

Line 1541: FND_MSG_PUB.add;

1537: CLOSE l_tmpl_csr;
1538: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
1539: FND_MESSAGE.set_token('ARG_NAME', 'p_template_id');
1540: FND_MESSAGE.set_token('ARG_VALUE', p_template_id);
1541: FND_MSG_PUB.add;
1542: RAISE FND_API.G_EXC_ERROR;
1543: END IF;
1544:
1545: OPEN l_tmpl_clauses_csr(p_template_id, p_wf_seq_id);

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

1607: END IF;
1608:
1609:
1610: -- Standard call to get message count and if count is 1, get message info.
1611: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1612:
1613: IF(FND_API.to_boolean(p_commit)) THEN
1614: COMMIT;
1615: END IF;

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

1644: END IF;
1645:
1646: ROLLBACK TO change_clause_status_pvt;
1647: x_return_status := G_RET_STS_ERROR ;
1648: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1649:
1650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1651: /*IF (l_debug = 'Y') THEN
1652: okc_debug.log('900: Leaving change_clause_status: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

1665: END IF;
1666:
1667: ROLLBACK TO change_clause_status_pvt;
1668: x_return_status := G_RET_STS_UNEXP_ERROR ;
1669: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1670:
1671: WHEN OTHERS THEN
1672: /*IF (l_debug = 'Y') THEN
1673: okc_debug.log('1000: Leaving change_clause_status because of EXCEPTION: '||sqlerrm, 2);

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

1686: END IF;
1687:
1688: ROLLBACK TO change_clause_status_pvt;
1689: x_return_status := G_RET_STS_UNEXP_ERROR ;
1690: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1691: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1692: END IF;
1693: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1694: END change_clause_status;

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

1687:
1688: ROLLBACK TO change_clause_status_pvt;
1689: x_return_status := G_RET_STS_UNEXP_ERROR ;
1690: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1691: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1692: END IF;
1693: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1694: END change_clause_status;
1695:

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

1689: x_return_status := G_RET_STS_UNEXP_ERROR ;
1690: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1691: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1692: END IF;
1693: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1694: END change_clause_status;
1695:
1696: ---------------------------------------------------------------------------
1697: -- Function get_error_string

Line 2089: FND_MSG_PUB.initialize;

2085: END IF;
2086:
2087: -- Initialize message list if p_init_msg_list is set to TRUE.
2088: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2089: FND_MSG_PUB.initialize;
2090: END IF;
2091:
2092: -- Initialize API return status to success
2093: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2098: select template_id from okc_terms_templates_all
2099: where template_id = p_template_id and status_code in ('DRAFT', 'REJECTED', 'REVISION'));
2100:
2101: -- Standard call to get message count and if count is 1, get message info.
2102: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2103:
2104: IF(FND_API.to_boolean(p_commit)) THEN
2105: COMMIT;
2106: END IF;

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

2128: END IF;
2129:
2130: ROLLBACK TO change_clause_status_pvt;
2131: x_return_status := G_RET_STS_ERROR ;
2132: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2133:
2134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2135: /*IF (l_debug = 'Y') THEN
2136: okc_debug.log('900: Leaving select_draft_clauses: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

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

2142: END IF;
2143:
2144: ROLLBACK TO change_clause_status_pvt;
2145: x_return_status := G_RET_STS_UNEXP_ERROR ;
2146: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2147:
2148: WHEN OTHERS THEN
2149: /*IF (l_debug = 'Y') THEN
2150: okc_debug.log('1000: Leaving select_draft_clauses because of EXCEPTION: '||sqlerrm, 2);

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

2156: END IF;
2157:
2158: ROLLBACK TO change_clause_status_pvt;
2159: x_return_status := G_RET_STS_UNEXP_ERROR ;
2160: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2161: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2162: END IF;
2163: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2164: END select_draft_clauses;

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

2157:
2158: ROLLBACK TO change_clause_status_pvt;
2159: x_return_status := G_RET_STS_UNEXP_ERROR ;
2160: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2161: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2162: END IF;
2163: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2164: END select_draft_clauses;
2165:

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

2159: x_return_status := G_RET_STS_UNEXP_ERROR ;
2160: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
2161: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
2162: END IF;
2163: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2164: END select_draft_clauses;
2165:
2166: end OKC_TERMS_TMPL_APPROVAL_PVT;