APPS.DPP_SLA_CLAIM_EXTRACT_PUB dependencies on FND_MSG_PUB

Line 18: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

14: -- ===============================================================
15: G_PKG_NAME CONSTANT VARCHAR2(30):= 'DPP_SLA_CLAIM_EXTRACT_PUB';
16: G_FILE_NAME CONSTANT VARCHAR2(14) := 'dppsce.pls';
17:
18: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
19:
20: ---------------------------------------------------------------------
21: -- PROCEDURE
22: -- create_sla_extract

Line 74: FND_MSG_PUB.initialize;

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
77: IF g_debug THEN
78: OZF_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' pub start');

Line 101: FND_MSG_PUB.add;

97: WHEN NO_DATA_FOUND THEN
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

Line 134: FND_MSG_PUB.add;

130: WHEN DUP_VAL_ON_INDEX THEN
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;

Line 174: FND_MSG_PUB.add;

170: DPP_UTILITY_PVT.debug_message('This claim line does not exist in Price Protection ');
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:

Line 220: FND_MSG_PUB.add;

216: FND_MESSAGE.set_name('DPP', 'DPP_DUPLICATE_LINE_EXTRACT');
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;

Line 236: FND_MSG_PUB.Count_And_Get (

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
240: );

Line 245: FND_MSG_PUB.Count_And_Get (

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,
248: p_data => x_msg_data
249: );

Line 254: FND_MSG_PUB.Count_And_Get (

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,
257: p_data => x_msg_data
258: );

Line 262: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;
266: -- Standard call to get message count and if count=1, get the message

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

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;
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,

Line 267: FND_MSG_PUB.Count_And_Get (

263: THEN
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: );