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.DPP_LOG_PVT dependencies on FND_API

Line 28: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

24: ----------------------------------------------------------------------
25:
26: PROCEDURE Insert_HeaderLog(
27: p_api_version IN NUMBER
28: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
29: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
30: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
31: ,x_return_status OUT NOCOPY VARCHAR2
32: ,x_msg_count OUT NOCOPY NUMBER

Line 29: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

25:
26: PROCEDURE Insert_HeaderLog(
27: p_api_version IN NUMBER
28: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
29: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
30: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
31: ,x_return_status OUT NOCOPY VARCHAR2
32: ,x_msg_count OUT NOCOPY NUMBER
33: ,x_msg_data OUT NOCOPY VARCHAR2

Line 30: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

26: PROCEDURE Insert_HeaderLog(
27: p_api_version IN NUMBER
28: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
29: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
30: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
31: ,x_return_status OUT NOCOPY VARCHAR2
32: ,x_msg_count OUT NOCOPY NUMBER
33: ,x_msg_data OUT NOCOPY VARCHAR2
34: ,p_txn_hdr_rec IN dpp_cst_hdr_rec_type

Line 50: IF NOT FND_API.Compatible_API_Call ( l_api_version,

46:
47: -- Standard begin of API savepoint
48: SAVEPOINT Insert_HeaderLog_PVT;
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call ( l_api_version,
51: p_api_version,
52: l_api_name,
53: G_PKG_NAME)
54: THEN

Line 55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

51: p_api_version,
52: l_api_name,
53: G_PKG_NAME)
54: THEN
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;
57: -- Initialize message list if p_init_msg_list is set to TRUE.
58: IF FND_API.to_Boolean( p_init_msg_list )
59: THEN

Line 58: IF FND_API.to_Boolean( p_init_msg_list )

54: THEN
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;
57: -- Initialize message list if p_init_msg_list is set to TRUE.
58: IF FND_API.to_Boolean( p_init_msg_list )
59: THEN
60: FND_MSG_PUB.initialize;
61: END IF;
62:

Line 68: x_return_status := FND_API.G_RET_STS_SUCCESS;

64: IF g_debug THEN
65: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
66: END IF;
67: -- Initialize API return status to sucess
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: --
71: -- API body
72: --

Line 122: IF FND_API.to_Boolean( p_commit )

118:
119: END IF;
120:
121: -- Standard check for p_commit
122: IF FND_API.to_Boolean( p_commit )
123: THEN
124: COMMIT WORK;
125: END IF;
126: -- Debug Message

Line 138: WHEN FND_API.G_EXC_ERROR THEN

134: );
135:
136: --Exception Handling
137: EXCEPTION
138: WHEN FND_API.G_EXC_ERROR THEN
139: ROLLBACK TO INSERT_HEADERLOG_PVT;
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: -- Standard call to get message count and if count=1, get the message
142: FND_MSG_PUB.Count_And_Get (

Line 140: x_return_status := FND_API.G_RET_STS_ERROR;

136: --Exception Handling
137: EXCEPTION
138: WHEN FND_API.G_EXC_ERROR THEN
139: ROLLBACK TO INSERT_HEADERLOG_PVT;
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: -- Standard call to get message count and if count=1, get the message
142: FND_MSG_PUB.Count_And_Get (
143: p_encoded => FND_API.G_FALSE,
144: p_count => x_msg_count,

Line 143: p_encoded => FND_API.G_FALSE,

139: ROLLBACK TO INSERT_HEADERLOG_PVT;
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: -- Standard call to get message count and if count=1, get the message
142: FND_MSG_PUB.Count_And_Get (
143: p_encoded => FND_API.G_FALSE,
144: p_count => x_msg_count,
145: p_data => x_msg_data
146: );
147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

143: p_encoded => FND_API.G_FALSE,
144: p_count => x_msg_count,
145: p_data => x_msg_data
146: );
147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
148: ROLLBACK TO INSERT_HEADERLOG_PVT;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: -- Standard call to get message count and if count=1, get the message
151: FND_MSG_PUB.Count_And_Get (

Line 149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

145: p_data => x_msg_data
146: );
147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
148: ROLLBACK TO INSERT_HEADERLOG_PVT;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: -- Standard call to get message count and if count=1, get the message
151: FND_MSG_PUB.Count_And_Get (
152: p_encoded => FND_API.G_FALSE,
153: p_count => x_msg_count,

Line 152: p_encoded => FND_API.G_FALSE,

148: ROLLBACK TO INSERT_HEADERLOG_PVT;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: -- Standard call to get message count and if count=1, get the message
151: FND_MSG_PUB.Count_And_Get (
152: p_encoded => FND_API.G_FALSE,
153: p_count => x_msg_count,
154: p_data => x_msg_data
155: );
156: WHEN OTHERS THEN

Line 158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

154: p_data => x_msg_data
155: );
156: WHEN OTHERS THEN
157: ROLLBACK TO INSERT_HEADERLOG_PVT;
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
160: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_HeaderLog');
161: fnd_message.set_token('ERRNO', sqlcode);
162: fnd_message.set_token('REASON', sqlerrm);

Line 166: p_encoded => FND_API.G_FALSE,

162: fnd_message.set_token('REASON', sqlerrm);
163: FND_MSG_PUB.ADD;
164: -- Standard call to get message count and if count=1, get the message
165: FND_MSG_PUB.Count_And_Get (
166: p_encoded => FND_API.G_FALSE,
167: p_count => x_msg_count,
168: p_data => x_msg_data
169: );
170:

Line 175: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

171: END Insert_HeaderLog;
172:
173: PROCEDURE Insert_LinesLog(
174: p_api_version IN NUMBER
175: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
176: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
177: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
178: ,x_return_status OUT NOCOPY VARCHAR2
179: ,x_msg_count OUT NOCOPY NUMBER

Line 176: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

172:
173: PROCEDURE Insert_LinesLog(
174: p_api_version IN NUMBER
175: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
176: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
177: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
178: ,x_return_status OUT NOCOPY VARCHAR2
179: ,x_msg_count OUT NOCOPY NUMBER
180: ,x_msg_data OUT NOCOPY VARCHAR2

Line 177: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

173: PROCEDURE Insert_LinesLog(
174: p_api_version IN NUMBER
175: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
176: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
177: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
178: ,x_return_status OUT NOCOPY VARCHAR2
179: ,x_msg_count OUT NOCOPY NUMBER
180: ,x_msg_data OUT NOCOPY VARCHAR2
181: ,p_txn_lines_tbl IN dpp_txn_line_tbl_type

Line 196: IF NOT FND_API.Compatible_API_Call ( l_api_version,

192:
193: -- Standard begin of API savepoint
194: SAVEPOINT Insert_LinesLog_PVT;
195: -- Standard call to check for call compatibility.
196: IF NOT FND_API.Compatible_API_Call ( l_api_version,
197: p_api_version,
198: l_api_name,
199: G_PKG_NAME)
200: THEN

Line 201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

197: p_api_version,
198: l_api_name,
199: G_PKG_NAME)
200: THEN
201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
202: END IF;
203: -- Initialize message list if p_init_msg_list is set to TRUE.
204: IF FND_API.to_Boolean( p_init_msg_list )
205: THEN

Line 204: IF FND_API.to_Boolean( p_init_msg_list )

200: THEN
201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
202: END IF;
203: -- Initialize message list if p_init_msg_list is set to TRUE.
204: IF FND_API.to_Boolean( p_init_msg_list )
205: THEN
206: FND_MSG_PUB.initialize;
207: END IF;
208:

Line 214: x_return_status := FND_API.G_RET_STS_SUCCESS;

210: IF g_debug THEN
211: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
212: END IF;
213: -- Initialize API return status to sucess
214: x_return_status := FND_API.G_RET_STS_SUCCESS;
215:
216: --
217: -- API body
218: --

Line 284: IF FND_API.to_Boolean( p_commit )

280:
281: END IF;
282:
283: -- Standard check for p_commit
284: IF FND_API.to_Boolean( p_commit )
285: THEN
286: COMMIT WORK;
287: END IF;
288: -- Debug Message

Line 303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

299: EXCEPTION
300:
301: WHEN OTHERS THEN
302: ROLLBACK TO INSERT_LINESLOG_PVT;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
305: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_LinesLog');
306: fnd_message.set_token('ERRNO', sqlcode);
307: fnd_message.set_token('REASON', sqlerrm);

Line 311: p_encoded => FND_API.G_FALSE,

307: fnd_message.set_token('REASON', sqlerrm);
308: FND_MSG_PUB.ADD;
309: -- Standard call to get message count and if count=1, get the message
310: FND_MSG_PUB.Count_And_Get (
311: p_encoded => FND_API.G_FALSE,
312: p_count => x_msg_count,
313: p_data => x_msg_data
314: );
315: END Insert_LinesLog;

Line 319: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

315: END Insert_LinesLog;
316:
317: PROCEDURE Insert_ClaimsLog(
318: p_api_version IN NUMBER
319: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
320: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
321: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
322: ,x_return_status OUT NOCOPY VARCHAR2
323: ,x_msg_count OUT NOCOPY NUMBER

Line 320: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

316:
317: PROCEDURE Insert_ClaimsLog(
318: p_api_version IN NUMBER
319: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
320: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
321: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
322: ,x_return_status OUT NOCOPY VARCHAR2
323: ,x_msg_count OUT NOCOPY NUMBER
324: ,x_msg_data OUT NOCOPY VARCHAR2

Line 321: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

317: PROCEDURE Insert_ClaimsLog(
318: p_api_version IN NUMBER
319: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
320: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
321: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
322: ,x_return_status OUT NOCOPY VARCHAR2
323: ,x_msg_count OUT NOCOPY NUMBER
324: ,x_msg_data OUT NOCOPY VARCHAR2
325: ,p_claim_lines_tbl IN dpp_claim_line_tbl_type

Line 340: IF NOT FND_API.Compatible_API_Call ( l_api_version,

336:
337: -- Standard begin of API savepoint
338: SAVEPOINT Insert_ClaimsLog_PVT;
339: -- Standard call to check for call compatibility.
340: IF NOT FND_API.Compatible_API_Call ( l_api_version,
341: p_api_version,
342: l_api_name,
343: G_PKG_NAME)
344: THEN

Line 345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

341: p_api_version,
342: l_api_name,
343: G_PKG_NAME)
344: THEN
345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
346: END IF;
347: -- Initialize message list if p_init_msg_list is set to TRUE.
348: IF FND_API.to_Boolean( p_init_msg_list )
349: THEN

Line 348: IF FND_API.to_Boolean( p_init_msg_list )

344: THEN
345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
346: END IF;
347: -- Initialize message list if p_init_msg_list is set to TRUE.
348: IF FND_API.to_Boolean( p_init_msg_list )
349: THEN
350: FND_MSG_PUB.initialize;
351: END IF;
352:

Line 358: x_return_status := FND_API.G_RET_STS_SUCCESS;

354: IF g_debug THEN
355: DPP_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
356: END IF;
357: -- Initialize API return status to sucess
358: x_return_status := FND_API.G_RET_STS_SUCCESS;
359:
360: --
361: -- API body
362: --

Line 422: IF FND_API.to_Boolean( p_commit )

418:
419: END IF;
420:
421: -- Standard check for p_commit
422: IF FND_API.to_Boolean( p_commit )
423: THEN
424: COMMIT WORK;
425: END IF;
426: -- Debug Message

Line 441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

437: EXCEPTION
438:
439: WHEN OTHERS THEN
440: ROLLBACK TO INSERT_CLAIMSLOG_PVT;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
443: fnd_message.set_token('ROUTINE', 'DPP_LOG_PVT.Insert_ClaimsLog');
444: fnd_message.set_token('ERRNO', sqlcode);
445: fnd_message.set_token('REASON', sqlerrm);

Line 449: p_encoded => FND_API.G_FALSE,

445: fnd_message.set_token('REASON', sqlerrm);
446: FND_MSG_PUB.ADD;
447: -- Standard call to get message count and if count=1, get the message
448: FND_MSG_PUB.Count_And_Get (
449: p_encoded => FND_API.G_FALSE,
450: p_count => x_msg_count,
451: p_data => x_msg_data
452: );
453: END Insert_ClaimsLog;