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 76: FND_MSG_PUB.initialize;

72: END IF;
73: -- Initialize message list if p_init_msg_list is set to TRUE.
74: IF FND_API.to_Boolean( p_init_msg_list )
75: THEN
76: FND_MSG_PUB.initialize;
77: END IF;
78: -- Debug Message
79:
80: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Public API: ' || l_api_name || ' pub start');

Line 103: FND_MSG_PUB.add;

99: WHEN NO_DATA_FOUND THEN
100: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'This is not a valid claim ');
101: FND_MESSAGE.set_name('DPP', 'DPP_INVALID_CLAIM');
102: FND_MESSAGE.set_token('CLAIM_ID', p_claim_id);
103: FND_MSG_PUB.add;
104: RAISE FND_API.G_EXC_ERROR;
105: END;
106:
107: BEGIN

Line 136: FND_MSG_PUB.add;

132: WHEN DUP_VAL_ON_INDEX THEN
133: FND_MESSAGE.set_name('DPP', 'DPP_DUPLICATE_HDR_EXTRACT');
134: FND_MESSAGE.set_token('TXN_HDR_ID', l_transaction_header_id);
135: FND_MESSAGE.set_token('BASE_TXN_HDR_ID', p_claim_id);
136: FND_MSG_PUB.add;
137: RAISE FND_API.G_EXC_ERROR;
138: END;
139:
140: l_sla_line_tbl_type.delete;

Line 176: FND_MSG_PUB.add;

172: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'This claim line does not exist in Price Protection ');
173: FND_MESSAGE.set_name('DPP', 'DPP_INVALID_CLAIM_LINE');
174: FND_MESSAGE.set_token('CLAIM_ID',p_claim_line_tbl(i).claim_id);
175: FND_MESSAGE.set_token('ITEM_ID',p_claim_line_tbl(i).item_id);
176: FND_MSG_PUB.add;
177: RAISE FND_API.G_EXC_ERROR;
178: END;
179:
180:

Line 222: FND_MSG_PUB.add;

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

Line 238: FND_MSG_PUB.Count_And_Get (

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

Line 247: FND_MSG_PUB.Count_And_Get (

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

Line 256: FND_MSG_PUB.Count_And_Get (

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

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

260: );
261: WHEN OTHERS THEN
262: ROLLBACK TO CREATE_SLA_Extract_PUB;
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
265: THEN
266: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
267: END IF;
268: -- Standard call to get message count and if count=1, get the message

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

262: ROLLBACK TO CREATE_SLA_Extract_PUB;
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
265: THEN
266: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
267: END IF;
268: -- Standard call to get message count and if count=1, get the message
269: FND_MSG_PUB.Count_And_Get (
270: p_encoded => FND_API.G_FALSE,

Line 269: FND_MSG_PUB.Count_And_Get (

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