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_BUSINESSEVENTS_PVT dependencies on FND_MESSAGE

Line 122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

118: FROM dual;
119:
120: EXCEPTION
121: WHEN NO_DATA_FOUND THEN
122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
123: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
124: fnd_message.set_token('ERRNO', sqlcode);
125: fnd_message.set_token('REASON', 'EXECUTION DETAIL ID NOT FOUND');
126: FND_MSG_PUB.add;

Line 123: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

119:
120: EXCEPTION
121: WHEN NO_DATA_FOUND THEN
122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
123: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
124: fnd_message.set_token('ERRNO', sqlcode);
125: fnd_message.set_token('REASON', 'EXECUTION DETAIL ID NOT FOUND');
126: FND_MSG_PUB.add;
127: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 124: fnd_message.set_token('ERRNO', sqlcode);

120: EXCEPTION
121: WHEN NO_DATA_FOUND THEN
122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
123: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
124: fnd_message.set_token('ERRNO', sqlcode);
125: fnd_message.set_token('REASON', 'EXECUTION DETAIL ID NOT FOUND');
126: FND_MSG_PUB.add;
127: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
128: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 125: fnd_message.set_token('REASON', 'EXECUTION DETAIL ID NOT FOUND');

121: WHEN NO_DATA_FOUND THEN
122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
123: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
124: fnd_message.set_token('ERRNO', sqlcode);
125: fnd_message.set_token('REASON', 'EXECUTION DETAIL ID NOT FOUND');
126: FND_MSG_PUB.add;
127: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
128: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
129: END IF;

Line 132: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

128: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
129: END IF;
130: RAISE FND_API.g_exc_error;
131: WHEN OTHERS THEN
132: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
133: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
134: fnd_message.set_token('ERRNO', sqlcode);
135: fnd_message.set_token('REASON', sqlerrm);
136: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 133: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

129: END IF;
130: RAISE FND_API.g_exc_error;
131: WHEN OTHERS THEN
132: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
133: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
134: fnd_message.set_token('ERRNO', sqlcode);
135: fnd_message.set_token('REASON', sqlerrm);
136: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
137: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID');

Line 134: fnd_message.set_token('ERRNO', sqlcode);

130: RAISE FND_API.g_exc_error;
131: WHEN OTHERS THEN
132: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
133: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
134: fnd_message.set_token('ERRNO', sqlcode);
135: fnd_message.set_token('REASON', sqlerrm);
136: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
137: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID');
138: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ');

Line 135: fnd_message.set_token('REASON', sqlerrm);

131: WHEN OTHERS THEN
132: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
133: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
134: fnd_message.set_token('ERRNO', sqlcode);
135: fnd_message.set_token('REASON', sqlerrm);
136: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
137: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID');
138: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ');
139: FND_MSG_PUB.add;

Line 137: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID');

133: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
134: fnd_message.set_token('ERRNO', sqlcode);
135: fnd_message.set_token('REASON', sqlerrm);
136: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
137: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID');
138: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ');
139: FND_MSG_PUB.add;
140: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
141: END IF;

Line 138: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ');

134: fnd_message.set_token('ERRNO', sqlcode);
135: fnd_message.set_token('REASON', sqlerrm);
136: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
137: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID');
138: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ');
139: FND_MSG_PUB.add;
140: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
141: END IF;
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 158: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

154: WHERE user_id = l_user_id ;
155:
156: EXCEPTION
157: WHEN NO_DATA_FOUND THEN
158: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
159: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
160: fnd_message.set_token('ERRNO', sqlcode);
161: fnd_message.set_token('REASON', 'INVALID USER');
162: FND_MSG_PUB.add;

Line 159: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

155:
156: EXCEPTION
157: WHEN NO_DATA_FOUND THEN
158: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
159: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
160: fnd_message.set_token('ERRNO', sqlcode);
161: fnd_message.set_token('REASON', 'INVALID USER');
162: FND_MSG_PUB.add;
163: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 160: fnd_message.set_token('ERRNO', sqlcode);

156: EXCEPTION
157: WHEN NO_DATA_FOUND THEN
158: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
159: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
160: fnd_message.set_token('ERRNO', sqlcode);
161: fnd_message.set_token('REASON', 'INVALID USER');
162: FND_MSG_PUB.add;
163: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
164: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 161: fnd_message.set_token('REASON', 'INVALID USER');

157: WHEN NO_DATA_FOUND THEN
158: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
159: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
160: fnd_message.set_token('ERRNO', sqlcode);
161: fnd_message.set_token('REASON', 'INVALID USER');
162: FND_MSG_PUB.add;
163: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
164: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
165: END IF;

Line 168: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

164: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
165: END IF;
166: RAISE FND_API.g_exc_error;
167: WHEN OTHERS THEN
168: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
169: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
170: fnd_message.set_token('ERRNO', sqlcode);
171: fnd_message.set_token('REASON', sqlerrm);
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 169: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

165: END IF;
166: RAISE FND_API.g_exc_error;
167: WHEN OTHERS THEN
168: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
169: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
170: fnd_message.set_token('ERRNO', sqlcode);
171: fnd_message.set_token('REASON', sqlerrm);
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END;

Line 170: fnd_message.set_token('ERRNO', sqlcode);

166: RAISE FND_API.g_exc_error;
167: WHEN OTHERS THEN
168: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
169: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
170: fnd_message.set_token('ERRNO', sqlcode);
171: fnd_message.set_token('REASON', sqlerrm);
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END;
174:

Line 171: fnd_message.set_token('REASON', sqlerrm);

167: WHEN OTHERS THEN
168: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
169: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
170: fnd_message.set_token('ERRNO', sqlcode);
171: fnd_message.set_token('REASON', sqlerrm);
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END;
174:
175: l_user_name := ''''||l_user_name||'''';

Line 183: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_CLAIM_TYPE');

179: OR p_txn_hdr_rec.process_code = 'CUSTCL' THEN
180:
181: IF p_txn_hdr_rec.claim_type_flag IS NULL THEN
182: --No claim type flag has been sent
183: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_CLAIM_TYPE');
184: FND_MSG_PUB.add;
185: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
186: RAISE FND_API.g_exc_error;
187: ELSE

Line 211: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

207: p_txn_line_id(i)
208: );
209: EXCEPTION
210: WHEN OTHERS THEN
211: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
212: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
213: fnd_message.set_token('ERRNO', sqlcode);
214: fnd_message.set_token('REASON', sqlerrm);
215: FND_MSG_PUB.add;

Line 212: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

208: );
209: EXCEPTION
210: WHEN OTHERS THEN
211: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
212: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
213: fnd_message.set_token('ERRNO', sqlcode);
214: fnd_message.set_token('REASON', sqlerrm);
215: FND_MSG_PUB.add;
216: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 213: fnd_message.set_token('ERRNO', sqlcode);

209: EXCEPTION
210: WHEN OTHERS THEN
211: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
212: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
213: fnd_message.set_token('ERRNO', sqlcode);
214: fnd_message.set_token('REASON', sqlerrm);
215: FND_MSG_PUB.add;
216: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
217: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 214: fnd_message.set_token('REASON', sqlerrm);

210: WHEN OTHERS THEN
211: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
212: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
213: fnd_message.set_token('ERRNO', sqlcode);
214: fnd_message.set_token('REASON', sqlerrm);
215: FND_MSG_PUB.add;
216: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
217: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
218: END IF;

Line 223: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
220: END;
221: END LOOP;
222: ELSE
223: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
224: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
225: fnd_message.set_token('ERRNO', sqlcode);
226: fnd_message.set_token('REASON', 'Transaction Line Id is required for the API');
227: FND_MSG_PUB.add;

Line 224: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

220: END;
221: END LOOP;
222: ELSE
223: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
224: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
225: fnd_message.set_token('ERRNO', sqlcode);
226: fnd_message.set_token('REASON', 'Transaction Line Id is required for the API');
227: FND_MSG_PUB.add;
228: RAISE FND_API.G_EXC_ERROR;

Line 225: fnd_message.set_token('ERRNO', sqlcode);

221: END LOOP;
222: ELSE
223: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
224: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
225: fnd_message.set_token('ERRNO', sqlcode);
226: fnd_message.set_token('REASON', 'Transaction Line Id is required for the API');
227: FND_MSG_PUB.add;
228: RAISE FND_API.G_EXC_ERROR;
229: END IF; --l_table_count

Line 226: fnd_message.set_token('REASON', 'Transaction Line Id is required for the API');

222: ELSE
223: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
224: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
225: fnd_message.set_token('ERRNO', sqlcode);
226: fnd_message.set_token('REASON', 'Transaction Line Id is required for the API');
227: FND_MSG_PUB.add;
228: RAISE FND_API.G_EXC_ERROR;
229: END IF; --l_table_count
230: ELSE

Line 241: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

237: FROM dpp_transaction_lines_all
238: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
239: EXCEPTION
240: WHEN OTHERS THEN
241: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
242: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
243: fnd_message.set_token('ERRNO', sqlcode);
244: fnd_message.set_token('REASON', sqlerrm);
245: FND_MSG_PUB.add;

Line 242: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

238: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
239: EXCEPTION
240: WHEN OTHERS THEN
241: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
242: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
243: fnd_message.set_token('ERRNO', sqlcode);
244: fnd_message.set_token('REASON', sqlerrm);
245: FND_MSG_PUB.add;
246: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 243: fnd_message.set_token('ERRNO', sqlcode);

239: EXCEPTION
240: WHEN OTHERS THEN
241: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
242: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
243: fnd_message.set_token('ERRNO', sqlcode);
244: fnd_message.set_token('REASON', sqlerrm);
245: FND_MSG_PUB.add;
246: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
247: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 244: fnd_message.set_token('REASON', sqlerrm);

240: WHEN OTHERS THEN
241: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
242: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
243: fnd_message.set_token('ERRNO', sqlcode);
244: fnd_message.set_token('REASON', sqlerrm);
245: FND_MSG_PUB.add;
246: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
247: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
248: END IF;

Line 261: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

257: FROM dpp_customer_claims_all
258: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
259: EXCEPTION
260: WHEN OTHERS THEN
261: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
262: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
263: fnd_message.set_token('ERRNO', sqlcode);
264: fnd_message.set_token('REASON', sqlerrm);
265: FND_MSG_PUB.add;

Line 262: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

258: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
259: EXCEPTION
260: WHEN OTHERS THEN
261: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
262: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
263: fnd_message.set_token('ERRNO', sqlcode);
264: fnd_message.set_token('REASON', sqlerrm);
265: FND_MSG_PUB.add;
266: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 263: fnd_message.set_token('ERRNO', sqlcode);

259: EXCEPTION
260: WHEN OTHERS THEN
261: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
262: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
263: fnd_message.set_token('ERRNO', sqlcode);
264: fnd_message.set_token('REASON', sqlerrm);
265: FND_MSG_PUB.add;
266: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
267: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 264: fnd_message.set_token('REASON', sqlerrm);

260: WHEN OTHERS THEN
261: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
262: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
263: fnd_message.set_token('ERRNO', sqlcode);
264: fnd_message.set_token('REASON', sqlerrm);
265: FND_MSG_PUB.add;
266: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
267: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
268: END IF;

Line 393: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

389: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID
390: AND to_number(supp_dist_claim_id) = p_txn_hdr_rec.claim_id;
391: EXCEPTION
392: WHEN NO_DATA_FOUND THEN
393: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
394: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
395: fnd_message.set_token('ERRNO', sqlcode);
396: fnd_message.set_token('REASON', 'INVALID CLAIM HEADER AMOUNT');
397: FND_MSG_PUB.add;

Line 394: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

390: AND to_number(supp_dist_claim_id) = p_txn_hdr_rec.claim_id;
391: EXCEPTION
392: WHEN NO_DATA_FOUND THEN
393: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
394: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
395: fnd_message.set_token('ERRNO', sqlcode);
396: fnd_message.set_token('REASON', 'INVALID CLAIM HEADER AMOUNT');
397: FND_MSG_PUB.add;
398: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 395: fnd_message.set_token('ERRNO', sqlcode);

391: EXCEPTION
392: WHEN NO_DATA_FOUND THEN
393: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
394: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
395: fnd_message.set_token('ERRNO', sqlcode);
396: fnd_message.set_token('REASON', 'INVALID CLAIM HEADER AMOUNT');
397: FND_MSG_PUB.add;
398: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
399: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 396: fnd_message.set_token('REASON', 'INVALID CLAIM HEADER AMOUNT');

392: WHEN NO_DATA_FOUND THEN
393: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
394: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
395: fnd_message.set_token('ERRNO', sqlcode);
396: fnd_message.set_token('REASON', 'INVALID CLAIM HEADER AMOUNT');
397: FND_MSG_PUB.add;
398: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
399: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
400: END IF;

Line 403: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

399: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
400: END IF;
401: RAISE FND_API.G_EXC_ERROR;
402: WHEN OTHERS THEN
403: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
404: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
405: fnd_message.set_token('ERRNO', sqlcode);
406: fnd_message.set_token('REASON', sqlerrm);
407: FND_MSG_PUB.add;

Line 404: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

400: END IF;
401: RAISE FND_API.G_EXC_ERROR;
402: WHEN OTHERS THEN
403: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
404: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
405: fnd_message.set_token('ERRNO', sqlcode);
406: fnd_message.set_token('REASON', sqlerrm);
407: FND_MSG_PUB.add;
408: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 405: fnd_message.set_token('ERRNO', sqlcode);

401: RAISE FND_API.G_EXC_ERROR;
402: WHEN OTHERS THEN
403: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
404: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
405: fnd_message.set_token('ERRNO', sqlcode);
406: fnd_message.set_token('REASON', sqlerrm);
407: FND_MSG_PUB.add;
408: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
409: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_CLAIM_AMT');

Line 406: fnd_message.set_token('REASON', sqlerrm);

402: WHEN OTHERS THEN
403: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
404: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
405: fnd_message.set_token('ERRNO', sqlcode);
406: fnd_message.set_token('REASON', sqlerrm);
407: FND_MSG_PUB.add;
408: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
409: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_CLAIM_AMT');
410: FND_MSG_PUB.add;

Line 409: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_CLAIM_AMT');

405: fnd_message.set_token('ERRNO', sqlcode);
406: fnd_message.set_token('REASON', sqlerrm);
407: FND_MSG_PUB.add;
408: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
409: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_CLAIM_AMT');
410: FND_MSG_PUB.add;
411: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
412: END IF;
413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 574: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

570: EXCEPTION
571: WHEN NO_DATA_FOUND THEN
572: l_cost_adj_acct := null;
573: WHEN OTHERS THEN
574: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
575: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
576: fnd_message.set_token('ERRNO', sqlcode);
577: fnd_message.set_token('REASON', sqlerrm);
578: FND_MSG_PUB.add;

Line 575: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

571: WHEN NO_DATA_FOUND THEN
572: l_cost_adj_acct := null;
573: WHEN OTHERS THEN
574: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
575: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
576: fnd_message.set_token('ERRNO', sqlcode);
577: fnd_message.set_token('REASON', sqlerrm);
578: FND_MSG_PUB.add;
579: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 576: fnd_message.set_token('ERRNO', sqlcode);

572: l_cost_adj_acct := null;
573: WHEN OTHERS THEN
574: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
575: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
576: fnd_message.set_token('ERRNO', sqlcode);
577: fnd_message.set_token('REASON', sqlerrm);
578: FND_MSG_PUB.add;
579: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
580: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_COSTADJACC');

Line 577: fnd_message.set_token('REASON', sqlerrm);

573: WHEN OTHERS THEN
574: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
575: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
576: fnd_message.set_token('ERRNO', sqlcode);
577: fnd_message.set_token('REASON', sqlerrm);
578: FND_MSG_PUB.add;
579: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
580: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_COSTADJACC');
581: FND_MSG_PUB.add;

Line 580: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_COSTADJACC');

576: fnd_message.set_token('ERRNO', sqlcode);
577: fnd_message.set_token('REASON', sqlerrm);
578: FND_MSG_PUB.add;
579: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
580: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_COSTADJACC');
581: FND_MSG_PUB.add;
582: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
583: END IF;
584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 596: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

592: WHERE osp.org_id = to_number(dtha.org_id)
593: AND dtha.transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
594: EXCEPTION
595: WHEN NO_DATA_FOUND THEN
596: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
597: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
598: fnd_message.set_token('ERRNO', sqlcode);
599: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT NOT FOUND');
600: FND_MSG_PUB.add;

Line 597: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

593: AND dtha.transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
594: EXCEPTION
595: WHEN NO_DATA_FOUND THEN
596: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
597: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
598: fnd_message.set_token('ERRNO', sqlcode);
599: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT NOT FOUND');
600: FND_MSG_PUB.add;
601: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 598: fnd_message.set_token('ERRNO', sqlcode);

594: EXCEPTION
595: WHEN NO_DATA_FOUND THEN
596: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
597: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
598: fnd_message.set_token('ERRNO', sqlcode);
599: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT NOT FOUND');
600: FND_MSG_PUB.add;
601: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
602: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 599: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT NOT FOUND');

595: WHEN NO_DATA_FOUND THEN
596: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
597: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
598: fnd_message.set_token('ERRNO', sqlcode);
599: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT NOT FOUND');
600: FND_MSG_PUB.add;
601: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
602: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
603: END IF;

Line 606: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

602: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
603: END IF;
604: RAISE FND_API.G_EXC_ERROR;
605: WHEN OTHERS THEN
606: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
607: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
608: fnd_message.set_token('ERRNO', sqlcode);
609: fnd_message.set_token('REASON', sqlerrm);
610: FND_MSG_PUB.add;

Line 607: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

603: END IF;
604: RAISE FND_API.G_EXC_ERROR;
605: WHEN OTHERS THEN
606: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
607: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
608: fnd_message.set_token('ERRNO', sqlcode);
609: fnd_message.set_token('REASON', sqlerrm);
610: FND_MSG_PUB.add;
611: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 608: fnd_message.set_token('ERRNO', sqlcode);

604: RAISE FND_API.G_EXC_ERROR;
605: WHEN OTHERS THEN
606: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
607: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
608: fnd_message.set_token('ERRNO', sqlcode);
609: fnd_message.set_token('REASON', sqlerrm);
610: FND_MSG_PUB.add;
611: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
612: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_COSTADJACC');

Line 609: fnd_message.set_token('REASON', sqlerrm);

605: WHEN OTHERS THEN
606: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
607: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
608: fnd_message.set_token('ERRNO', sqlcode);
609: fnd_message.set_token('REASON', sqlerrm);
610: FND_MSG_PUB.add;
611: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
612: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_COSTADJACC');
613: FND_MSG_PUB.add;

Line 612: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_COSTADJACC');

608: fnd_message.set_token('ERRNO', sqlcode);
609: fnd_message.set_token('REASON', sqlerrm);
610: FND_MSG_PUB.add;
611: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
612: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_COSTADJACC');
613: FND_MSG_PUB.add;
614: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
615: END IF;
616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 677: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
674: END IF;
675: END IF;
676: ELSE
677: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
678: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
679: fnd_message.set_token('ERRNO', sqlcode);
680: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT IS NULL');
681: FND_MSG_PUB.add;

Line 678: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

674: END IF;
675: END IF;
676: ELSE
677: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
678: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
679: fnd_message.set_token('ERRNO', sqlcode);
680: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT IS NULL');
681: FND_MSG_PUB.add;
682: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 679: fnd_message.set_token('ERRNO', sqlcode);

675: END IF;
676: ELSE
677: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
678: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
679: fnd_message.set_token('ERRNO', sqlcode);
680: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT IS NULL');
681: FND_MSG_PUB.add;
682: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
683: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 680: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT IS NULL');

676: ELSE
677: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
678: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
679: fnd_message.set_token('ERRNO', sqlcode);
680: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT IS NULL');
681: FND_MSG_PUB.add;
682: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
683: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
684: END IF;

Line 807: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

803: AND ostp.org_id = to_number(dtha.org_id)
804: AND dtha.transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
805: EXCEPTION
806: WHEN NO_DATA_FOUND THEN
807: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
808: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
809: fnd_message.set_token('ERRNO', sqlcode);
810: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
811: FND_MSG_PUB.add;

Line 808: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

804: AND dtha.transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
805: EXCEPTION
806: WHEN NO_DATA_FOUND THEN
807: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
808: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
809: fnd_message.set_token('ERRNO', sqlcode);
810: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
811: FND_MSG_PUB.add;
812: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 809: fnd_message.set_token('ERRNO', sqlcode);

805: EXCEPTION
806: WHEN NO_DATA_FOUND THEN
807: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
808: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
809: fnd_message.set_token('ERRNO', sqlcode);
810: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
811: FND_MSG_PUB.add;
812: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
813: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 810: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified

806: WHEN NO_DATA_FOUND THEN
807: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
808: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
809: fnd_message.set_token('ERRNO', sqlcode);
810: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
811: FND_MSG_PUB.add;
812: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
813: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
814: END IF;

Line 817: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

813: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
814: END IF;
815: RAISE FND_API.g_exc_error;
816: WHEN OTHERS THEN
817: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
818: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
819: fnd_message.set_token('ERRNO', sqlcode);
820: fnd_message.set_token('REASON', sqlerrm);
821: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 818: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

814: END IF;
815: RAISE FND_API.g_exc_error;
816: WHEN OTHERS THEN
817: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
818: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
819: fnd_message.set_token('ERRNO', sqlcode);
820: fnd_message.set_token('REASON', sqlerrm);
821: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
822: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified

Line 819: fnd_message.set_token('ERRNO', sqlcode);

815: RAISE FND_API.g_exc_error;
816: WHEN OTHERS THEN
817: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
818: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
819: fnd_message.set_token('ERRNO', sqlcode);
820: fnd_message.set_token('REASON', sqlerrm);
821: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
822: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
823: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified

Line 820: fnd_message.set_token('REASON', sqlerrm);

816: WHEN OTHERS THEN
817: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
818: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
819: fnd_message.set_token('ERRNO', sqlcode);
820: fnd_message.set_token('REASON', sqlerrm);
821: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
822: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
823: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified
824: FND_MSG_PUB.add;

Line 822: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified

818: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
819: fnd_message.set_token('ERRNO', sqlcode);
820: fnd_message.set_token('REASON', sqlerrm);
821: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
822: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
823: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified
824: FND_MSG_PUB.add;
825: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
826: END IF;

Line 823: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified

819: fnd_message.set_token('ERRNO', sqlcode);
820: fnd_message.set_token('REASON', sqlerrm);
821: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
822: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified
823: fnd_message.set_token('SEQ_NAME', 'DPP_EXECUTION_DETAIL_ID_SEQ'); --To be modified
824: FND_MSG_PUB.add;
825: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
826: END IF;
827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1140: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_PRO_CODE');

1136: --Check if the query returns any rows
1137: l_row_count := dbms_xmlquery.getNumRowsProcessed(l_queryCtx);
1138: dbms_xmlquery.closeContext(l_queryCtx);
1139: ELSE
1140: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_PRO_CODE');
1141: fnd_message.set_token('PROCESS_CODE', p_txn_hdr_rec.process_code);
1142: FND_MSG_PUB.add;
1143: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1144: RAISE FND_API.g_exc_error;

Line 1141: fnd_message.set_token('PROCESS_CODE', p_txn_hdr_rec.process_code);

1137: l_row_count := dbms_xmlquery.getNumRowsProcessed(l_queryCtx);
1138: dbms_xmlquery.closeContext(l_queryCtx);
1139: ELSE
1140: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_PRO_CODE');
1141: fnd_message.set_token('PROCESS_CODE', p_txn_hdr_rec.process_code);
1142: FND_MSG_PUB.add;
1143: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1144: RAISE FND_API.g_exc_error;
1145: END IF;

Line 1215: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1211: END IF;
1212:
1213: WHEN OTHERS THEN
1214: ROLLBACK TO Raise_Business_Event;
1215: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1216: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1217: fnd_message.set_token('ERRNO', sqlcode);
1218: fnd_message.set_token('REASON', sqlerrm);
1219: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1216: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

1212:
1213: WHEN OTHERS THEN
1214: ROLLBACK TO Raise_Business_Event;
1215: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1216: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1217: fnd_message.set_token('ERRNO', sqlcode);
1218: fnd_message.set_token('REASON', sqlerrm);
1219: x_return_status := FND_API.g_ret_sts_unexp_error ;
1220: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1217: fnd_message.set_token('ERRNO', sqlcode);

1213: WHEN OTHERS THEN
1214: ROLLBACK TO Raise_Business_Event;
1215: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1216: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1217: fnd_message.set_token('ERRNO', sqlcode);
1218: fnd_message.set_token('REASON', sqlerrm);
1219: x_return_status := FND_API.g_ret_sts_unexp_error ;
1220: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1221: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 1218: fnd_message.set_token('REASON', sqlerrm);

1214: ROLLBACK TO Raise_Business_Event;
1215: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1216: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1217: fnd_message.set_token('ERRNO', sqlcode);
1218: fnd_message.set_token('REASON', sqlerrm);
1219: x_return_status := FND_API.g_ret_sts_unexp_error ;
1220: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1221: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1222: END IF;

Line 1319: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1315: l_user_id);
1316:
1317: EXCEPTION
1318: WHEN OTHERS THEN
1319: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1320: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1321: fnd_message.set_token('ERRNO', sqlcode);
1322: fnd_message.set_token('REASON', sqlerrm);
1323: FND_MSG_PUB.add;

Line 1320: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

1316:
1317: EXCEPTION
1318: WHEN OTHERS THEN
1319: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1320: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1321: fnd_message.set_token('ERRNO', sqlcode);
1322: fnd_message.set_token('REASON', sqlerrm);
1323: FND_MSG_PUB.add;
1324: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1321: fnd_message.set_token('ERRNO', sqlcode);

1317: EXCEPTION
1318: WHEN OTHERS THEN
1319: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1320: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1321: fnd_message.set_token('ERRNO', sqlcode);
1322: fnd_message.set_token('REASON', sqlerrm);
1323: FND_MSG_PUB.add;
1324: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1325: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

Line 1322: fnd_message.set_token('REASON', sqlerrm);

1318: WHEN OTHERS THEN
1319: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1320: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1321: fnd_message.set_token('ERRNO', sqlcode);
1322: fnd_message.set_token('REASON', sqlerrm);
1323: FND_MSG_PUB.add;
1324: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1325: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1326: END IF;

Line 1355: FND_MESSAGE.set_name('DPP', 'DPP_CC_NO_ELIGIBLE_LINES_MSG');

1351: ELSE
1352: IF g_debug THEN
1353: DPP_UTILITY_PVT.debug_message('Work Flow Event is not Raised');
1354: END IF;
1355: FND_MESSAGE.set_name('DPP', 'DPP_CC_NO_ELIGIBLE_LINES_MSG');
1356: FND_MSG_PUB.add;
1357: RAISE FND_API.g_exc_error;
1358: END IF; --p_row_count > 0
1359: END IF;

Line 1392: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1388: END IF;
1389:
1390: WHEN OTHERS THEN
1391: ROLLBACK TO Raise_Workflow_Event;
1392: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1393: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1394: fnd_message.set_token('ERRNO', sqlcode);
1395: fnd_message.set_token('REASON', sqlerrm);
1396: FND_MSG_PUB.add;

Line 1393: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');

1389:
1390: WHEN OTHERS THEN
1391: ROLLBACK TO Raise_Workflow_Event;
1392: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1393: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1394: fnd_message.set_token('ERRNO', sqlcode);
1395: fnd_message.set_token('REASON', sqlerrm);
1396: FND_MSG_PUB.add;
1397: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1394: fnd_message.set_token('ERRNO', sqlcode);

1390: WHEN OTHERS THEN
1391: ROLLBACK TO Raise_Workflow_Event;
1392: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1393: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1394: fnd_message.set_token('ERRNO', sqlcode);
1395: fnd_message.set_token('REASON', sqlerrm);
1396: FND_MSG_PUB.add;
1397: x_return_status := FND_API.g_ret_sts_unexp_error ;
1398: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1395: fnd_message.set_token('REASON', sqlerrm);

1391: ROLLBACK TO Raise_Workflow_Event;
1392: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1393: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1394: fnd_message.set_token('ERRNO', sqlcode);
1395: fnd_message.set_token('REASON', sqlerrm);
1396: FND_MSG_PUB.add;
1397: x_return_status := FND_API.g_ret_sts_unexp_error ;
1398: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1399: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);