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 DPP_BUSINESSEVENTS_PVT

Line 1: PACKAGE BODY DPP_BUSINESSEVENTS_PVT AS

1: PACKAGE BODY DPP_BUSINESSEVENTS_PVT AS
2: /* $Header: dppvbevb.pls 120.39.12010000.2 2008/11/11 11:27:39 rvkondur ship $ */
3:
4: -- Package name : DPP_BUSINESSEVENTS_PVT
5: -- Purpose :

Line 4: -- Package name : DPP_BUSINESSEVENTS_PVT

1: PACKAGE BODY DPP_BUSINESSEVENTS_PVT AS
2: /* $Header: dppvbevb.pls 120.39.12010000.2 2008/11/11 11:27:39 rvkondur ship $ */
3:
4: -- Package name : DPP_BUSINESSEVENTS_PVT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_BUSINESSEVENTS_PVT';

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_BUSINESSEVENTS_PVT';
11: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'dppvbevb.pls';
13: ---------------------------------------------------------------------
14: -- PROCEDURE

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 1413: END DPP_BUSINESSEVENTS_PVT;

1409: END LOOP;
1410: END IF;
1411:
1412: END Raise_Workflow_Event;
1413: END DPP_BUSINESSEVENTS_PVT;