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.

[Home] [Help]

APPS.OKC_REP_EXP_NTF_PVT dependencies on FND_API

Line 35: -- Default = FND_API.G_FALSE

31: --Pre-reqs : None.
32: --Parameters :
33: --IN : p_api_version IN NUMBER Required
34: -- : p_init_msg_list IN VARCHAR2 Optional
35: -- Default = FND_API.G_FALSE
36: --OUT : x_return_status OUT VARCHAR2(1)
37: -- : x_msg_count OUT NUMBER
38: -- : x_msg_data OUT VARCHAR2(2000)
39: --Note :

Line 108: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

104: l_api_name := 'contract_expiration_notifier';
105: l_api_version := 1.0;
106:
107: -- Standard call to check for call compatibility.
108: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: END IF;
111: -- Initialize message list if p_init_msg_list is set to TRUE.
112: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

105: l_api_version := 1.0;
106:
107: -- Standard call to check for call compatibility.
108: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: END IF;
111: -- Initialize message list if p_init_msg_list is set to TRUE.
112: IF FND_API.to_Boolean( p_init_msg_list ) THEN
113: FND_MSG_PUB.initialize;

Line 112: IF FND_API.to_Boolean( p_init_msg_list ) THEN

108: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
110: END IF;
111: -- Initialize message list if p_init_msg_list is set to TRUE.
112: IF FND_API.to_Boolean( p_init_msg_list ) THEN
113: FND_MSG_PUB.initialize;
114: END IF;
115:
116: FOR expiring_contracts_rec IN EXPIRING_CONTRACTS LOOP

Line 139: WHEN FND_API.G_EXC_ERROR THEN

135: 'Leaving OKC_REP_EXP_NTF_PVT.contract_expiration_notifier');
136: END IF;
137:
138: EXCEPTION
139: WHEN FND_API.G_EXC_ERROR THEN
140: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
141: fnd_log.string(
142: FND_LOG.LEVEL_EXCEPTION,
143: G_MODULE || l_api_name,

Line 144: 'Leaving contract_expiration_notifier:FND_API.G_EXC_ERROR Exception');

140: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
141: fnd_log.string(
142: FND_LOG.LEVEL_EXCEPTION,
143: G_MODULE || l_api_name,
144: 'Leaving contract_expiration_notifier:FND_API.G_EXC_ERROR Exception');
145: END IF;
146: --close cursors
147: IF (EXPIRING_CONTRACTS%ISOPEN) THEN
148: CLOSE EXPIRING_CONTRACTS ;

Line 151: x_return_status := FND_API.G_RET_STS_ERROR;

147: IF (EXPIRING_CONTRACTS%ISOPEN) THEN
148: CLOSE EXPIRING_CONTRACTS ;
149: END IF;
150:
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: FND_MSG_PUB.Count_And_Get(
153: p_count => x_msg_count,
154: p_data => x_msg_data
155: );

Line 157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

153: p_count => x_msg_count,
154: p_data => x_msg_data
155: );
156:
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
159: fnd_log.string(
160: FND_LOG.LEVEL_EXCEPTION,
161: G_MODULE || l_api_name,

Line 162: 'Leaving contract_expiration_notifier:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

158: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
159: fnd_log.string(
160: FND_LOG.LEVEL_EXCEPTION,
161: G_MODULE || l_api_name,
162: 'Leaving contract_expiration_notifier:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
163: END IF;
164: --close cursors
165: IF (EXPIRING_CONTRACTS%ISOPEN) THEN
166: CLOSE EXPIRING_CONTRACTS ;

Line 169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

165: IF (EXPIRING_CONTRACTS%ISOPEN) THEN
166: CLOSE EXPIRING_CONTRACTS ;
167: END IF;
168:
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: FND_MSG_PUB.Count_And_Get(
171: p_count => x_msg_count,
172: p_data => x_msg_data
173: );

Line 195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

191: IF (EXPIRING_CONTRACTS%ISOPEN) THEN
192: CLOSE EXPIRING_CONTRACTS ;
193: END IF;
194:
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196: FND_MSG_PUB.Count_And_Get(
197: p_count => x_msg_count,
198: p_data => x_msg_data
199: );

Line 238: l_init_msg_list := FND_API.G_FALSE;

234: END IF;
235:
236: l_api_name := 'contract_expiration_manager';
237: l_api_version := 1.0;
238: l_init_msg_list := FND_API.G_FALSE;
239:
240: contract_expiration_notifier(
241: p_api_version => l_api_version,
242: p_init_msg_list => l_init_msg_list,