97: EXCEPTION
98:
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;
98:
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:
129: p_userid
130: );
131: EXCEPTION
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;
130: );
131: EXCEPTION
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;
131: EXCEPTION
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:
169: EXCEPTION
170:
171: WHEN NO_DATA_FOUND THEN
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;
170:
171: WHEN NO_DATA_FOUND THEN
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;
171: WHEN NO_DATA_FOUND THEN
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:
214: );
215:
216: EXCEPTION
217: WHEN DUP_VAL_ON_INDEX THEN
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;
215:
216: EXCEPTION
217: WHEN DUP_VAL_ON_INDEX THEN
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;
216: EXCEPTION
217: WHEN DUP_VAL_ON_INDEX THEN
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;
217: WHEN DUP_VAL_ON_INDEX THEN
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;