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_SLA_CLAIM_EXTRACT_PUB dependencies on FND_API

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

31: -- NOTES
32: ---------------------------------------------------------------------
33: PROCEDURE Create_SLA_Extract(
34: p_api_version_number IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,

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

32: ---------------------------------------------------------------------
33: PROCEDURE Create_SLA_Extract(
34: p_api_version_number IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,

Line 37: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

33: PROCEDURE Create_SLA_Extract(
34: p_api_version_number IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_commit IN VARCHAR2 := FND_API.G_FALSE,
37: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: p_claim_id IN ozf_claims.claim_id%TYPE,

Line 64: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

60: BEGIN
61: -- Standard Start of API savepoint
62: SAVEPOINT CREATE_SLA_Extract_PUB;
63: -- Standard call to check for call compatibility.
64: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
65: p_api_version_number,
66: l_api_name,
67: G_PKG_NAME)
68: THEN

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: p_api_version_number,
66: l_api_name,
67: G_PKG_NAME)
68: THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71: -- Initialize message list if p_init_msg_list is set to TRUE.
72: IF FND_API.to_Boolean( p_init_msg_list )
73: THEN

Line 72: IF FND_API.to_Boolean( p_init_msg_list )

68: THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71: -- Initialize message list if p_init_msg_list is set to TRUE.
72: IF FND_API.to_Boolean( p_init_msg_list )
73: THEN
74: FND_MSG_PUB.initialize;
75: END IF;
76: -- Debug Message

Line 81: x_return_status := FND_API.G_RET_STS_SUCCESS;

77: IF g_debug THEN
78: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' pub start');
79: END IF;
80: -- Initialize API return status to SUCCESS
81: x_return_status := FND_API.G_RET_STS_SUCCESS;
82: --
83: -- API body
84: --
85: IF p_claim_line_tbl.count > 0 THEN

Line 102: RAISE FND_API.G_EXC_ERROR;

98: DPP_UTILITY_PVT.debug_message('This is not a valid claim ');
99: FND_MESSAGE.set_name('DPP', 'DPP_INVALID_CLAIM');
100: FND_MESSAGE.set_token('CLAIM_ID', p_claim_id);
101: FND_MSG_PUB.add;
102: RAISE FND_API.G_EXC_ERROR;
103: END;
104:
105: BEGIN
106: INSERT INTO DPP_XLA_HEADERS

Line 135: RAISE FND_API.G_EXC_ERROR;

131: FND_MESSAGE.set_name('DPP', 'DPP_DUPLICATE_HDR_EXTRACT');
132: FND_MESSAGE.set_token('TXN_HDR_ID', l_transaction_header_id);
133: FND_MESSAGE.set_token('BASE_TXN_HDR_ID', p_claim_id);
134: FND_MSG_PUB.add;
135: RAISE FND_API.G_EXC_ERROR;
136: END;
137:
138: l_sla_line_tbl_type.delete;
139: FOR i IN p_claim_line_tbl.FIRST..p_claim_line_tbl.LAST LOOP

Line 175: RAISE FND_API.G_EXC_ERROR;

171: FND_MESSAGE.set_name('DPP', 'DPP_INVALID_CLAIM_LINE');
172: FND_MESSAGE.set_token('CLAIM_ID',p_claim_line_tbl(i).claim_id);
173: FND_MESSAGE.set_token('ITEM_ID',p_claim_line_tbl(i).item_id);
174: FND_MSG_PUB.add;
175: RAISE FND_API.G_EXC_ERROR;
176: END;
177:
178:
179: l_sla_line_tbl_type(i).transaction_header_id:=l_transaction_header_id;

Line 221: RAISE FND_API.G_EXC_ERROR;

217: FND_MESSAGE.set_token('TXN_HDR_ID', l_transaction_header_id);
218: FND_MESSAGE.set_token('BASE_TXN_HDR_ID', p_claim_id);
219: FND_MESSAGE.set_token('BASE_TXN_LINE_ID', l_sla_line_tbl_type(i).base_transaction_line_id);
220: FND_MSG_PUB.add;
221: RAISE FND_API.G_EXC_ERROR;
222: END;
223: END LOOP;
224: END IF;
225: END IF;

Line 227: IF FND_API.to_Boolean( p_commit )

223: END LOOP;
224: END IF;
225: END IF;
226:
227: IF FND_API.to_Boolean( p_commit )
228: THEN
229: COMMIT WORK;
230: END IF;
231: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 231: x_return_status := FND_API.G_RET_STS_SUCCESS;

227: IF FND_API.to_Boolean( p_commit )
228: THEN
229: COMMIT WORK;
230: END IF;
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232: EXCEPTION
233: WHEN OZF_Utility_PVT.resource_locked THEN
234: ROLLBACK TO CREATE_SLA_Extract_PUB;
235: x_return_status := FND_API.G_RET_STS_ERROR;

Line 235: x_return_status := FND_API.G_RET_STS_ERROR;

231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232: EXCEPTION
233: WHEN OZF_Utility_PVT.resource_locked THEN
234: ROLLBACK TO CREATE_SLA_Extract_PUB;
235: x_return_status := FND_API.G_RET_STS_ERROR;
236: FND_MSG_PUB.Count_And_Get (
237: p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count,
239: p_data => x_msg_data

Line 237: p_encoded => FND_API.G_FALSE,

233: WHEN OZF_Utility_PVT.resource_locked THEN
234: ROLLBACK TO CREATE_SLA_Extract_PUB;
235: x_return_status := FND_API.G_RET_STS_ERROR;
236: FND_MSG_PUB.Count_And_Get (
237: p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count,
239: p_data => x_msg_data
240: );
241: WHEN FND_API.G_EXC_ERROR THEN

Line 241: WHEN FND_API.G_EXC_ERROR THEN

237: p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count,
239: p_data => x_msg_data
240: );
241: WHEN FND_API.G_EXC_ERROR THEN
242: ROLLBACK TO CREATE_SLA_Extract_PUB;
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: -- Standard call to get message count and if count=1, get the message
245: FND_MSG_PUB.Count_And_Get (

Line 243: x_return_status := FND_API.G_RET_STS_ERROR;

239: p_data => x_msg_data
240: );
241: WHEN FND_API.G_EXC_ERROR THEN
242: ROLLBACK TO CREATE_SLA_Extract_PUB;
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: -- Standard call to get message count and if count=1, get the message
245: FND_MSG_PUB.Count_And_Get (
246: p_encoded => FND_API.G_FALSE,
247: p_count => x_msg_count,

Line 246: p_encoded => FND_API.G_FALSE,

242: ROLLBACK TO CREATE_SLA_Extract_PUB;
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: -- Standard call to get message count and if count=1, get the message
245: FND_MSG_PUB.Count_And_Get (
246: p_encoded => FND_API.G_FALSE,
247: p_count => x_msg_count,
248: p_data => x_msg_data
249: );
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

246: p_encoded => FND_API.G_FALSE,
247: p_count => x_msg_count,
248: p_data => x_msg_data
249: );
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: ROLLBACK TO CREATE_SLA_Extract_PUB;
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253: -- Standard call to get message count and if count=1, get the message
254: FND_MSG_PUB.Count_And_Get (

Line 252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

248: p_data => x_msg_data
249: );
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: ROLLBACK TO CREATE_SLA_Extract_PUB;
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253: -- Standard call to get message count and if count=1, get the message
254: FND_MSG_PUB.Count_And_Get (
255: p_encoded => FND_API.G_FALSE,
256: p_count => x_msg_count,

Line 255: p_encoded => FND_API.G_FALSE,

251: ROLLBACK TO CREATE_SLA_Extract_PUB;
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253: -- Standard call to get message count and if count=1, get the message
254: FND_MSG_PUB.Count_And_Get (
255: p_encoded => FND_API.G_FALSE,
256: p_count => x_msg_count,
257: p_data => x_msg_data
258: );
259: WHEN OTHERS THEN

Line 261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

257: p_data => x_msg_data
258: );
259: WHEN OTHERS THEN
260: ROLLBACK TO CREATE_SLA_Extract_PUB;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
263: THEN
264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
265: END IF;

Line 268: p_encoded => FND_API.G_FALSE,

264: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
265: END IF;
266: -- Standard call to get message count and if count=1, get the message
267: FND_MSG_PUB.Count_And_Get (
268: p_encoded => FND_API.G_FALSE,
269: p_count => x_msg_count,
270: p_data => x_msg_data
271: );
272: End Create_SLA_extract;