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_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 106: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

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

Line 107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 110: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 137: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

Line 149: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

Line 167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 236: l_init_msg_list := FND_API.G_FALSE;

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