DBA Data[Home] [Help]

APPS.DPP_SLA_CLAIM_EXTRACT_PUB dependencies on FND_MESSAGE

Line 99: FND_MESSAGE.set_name('DPP', 'DPP_INVALID_CLAIM');

95: EXCEPTION
96:
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;

Line 100: FND_MESSAGE.set_token('CLAIM_ID', p_claim_id);

96:
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:

Line 131: FND_MESSAGE.set_name('DPP', 'DPP_DUPLICATE_HDR_EXTRACT');

127: p_userid
128: );
129: EXCEPTION
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;

Line 132: FND_MESSAGE.set_token('TXN_HDR_ID', l_transaction_header_id);

128: );
129: EXCEPTION
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;

Line 133: FND_MESSAGE.set_token('BASE_TXN_HDR_ID', p_claim_id);

129: EXCEPTION
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:

Line 171: FND_MESSAGE.set_name('DPP', 'DPP_INVALID_CLAIM_LINE');

167: EXCEPTION
168:
169: WHEN NO_DATA_FOUND THEN
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;

Line 172: FND_MESSAGE.set_token('CLAIM_ID',p_claim_line_tbl(i).claim_id);

168:
169: WHEN NO_DATA_FOUND THEN
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;

Line 173: FND_MESSAGE.set_token('ITEM_ID',p_claim_line_tbl(i).item_id);

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

Line 216: FND_MESSAGE.set_name('DPP', 'DPP_DUPLICATE_LINE_EXTRACT');

212: );
213:
214: EXCEPTION
215: WHEN DUP_VAL_ON_INDEX THEN
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;

Line 217: FND_MESSAGE.set_token('TXN_HDR_ID', l_transaction_header_id);

213:
214: EXCEPTION
215: WHEN DUP_VAL_ON_INDEX THEN
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;

Line 218: FND_MESSAGE.set_token('BASE_TXN_HDR_ID', p_claim_id);

214: EXCEPTION
215: WHEN DUP_VAL_ON_INDEX THEN
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;

Line 219: FND_MESSAGE.set_token('BASE_TXN_LINE_ID', l_sla_line_tbl_type(i).base_transaction_line_id);

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