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.54 2011/09/13 09:12:12 rvkondur noship $ */
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.54 2011/09/13 09:12:12 rvkondur noship $ */
3:
4: -- Package name : DPP_BUSINESSEVENTS_PVT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

19: );
20:
21: FUNCTION IS_NOTIF_EXECUTED(P_TXN_HDR_ID IN NUMBER, P_PROC_CODE IN VARCHAR2) RETURN BOOLEAN;
22:
23: G_PKG_NAME CONSTANT VARCHAR2(30) := 'DPP_BUSINESSEVENTS_PVT';
24: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
25: G_FILE_NAME CONSTANT VARCHAR2(12) := 'dppvbevb.pls';
26:
27:

Line 67: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_BUSINESSEVENTS_PVT.SEND_CANCEL_NOTIFICATIONS';

63: IS
64: L_API_VERSION CONSTANT NUMBER := 1.0;
65: L_API_NAME CONSTANT VARCHAR2(30) := 'SEND_CANCEL_NOTIFICATIONS';
66: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| L_API_NAME;
67: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_BUSINESSEVENTS_PVT.SEND_CANCEL_NOTIFICATIONS';
68:
69: BEGIN
70:
71: SAVEPOINT SEND_CANCEL_NOTIF;

Line 224: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_BUSINESSEVENTS_PVT.RAISE_BUSINESS_EVT_FOR_PROCESS';

220:
221: L_API_VERSION CONSTANT NUMBER := 1.0;
222: L_API_NAME CONSTANT VARCHAR2(35) := 'RAISE_BUSINESS_EVENT_FOR_PROCESS';
223: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| L_API_NAME;
224: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_BUSINESSEVENTS_PVT.RAISE_BUSINESS_EVT_FOR_PROCESS';
225:
226: L_TXN_HDR_NUM VARCHAR2(255);
227:
228: L_TXN_HDR_REC DPP_TXN_HDR_REC_TYPE;

Line 353: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_BUSINESSEVENTS_PVT.RAISE_EFFECTIVE_DATE_EVENT';

349:
350: L_API_NAME CONSTANT VARCHAR2(30) := 'RAISE_EFFECTIVE_DATE_EVENT';
351: L_API_VERSION CONSTANT NUMBER := 1.0;
352: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
353: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_BUSINESSEVENTS_PVT.RAISE_EFFECTIVE_DATE_EVENT';
354:
355: L_EVENT_NAME VARCHAR2(60) := 'oracle.apps.dpp.notifyeffective';
356: L_ITEM_KEY VARCHAR2(30);
357: L_PARAMETER_LIST WF_PARAMETER_LIST_T;

Line 482: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_BUSINESSEVENTS_PVT.SEND_EFFECTIVE_DATE_NOTIF';

478: )
479: IS
480:
481: L_PROGRAM_ID NUMBER := 0;
482: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_BUSINESSEVENTS_PVT.SEND_EFFECTIVE_DATE_NOTIF';
483:
484: CURSOR GET_USER_LIST (P_PROGRAM_ID VARCHAR2) IS
485: SELECT DISTINCT H.CREATED_BY, U.USER_NAME
486: FROM DPP_TRANSACTION_HEADERS_ALL H, FND_USER U

Line 584: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_BUSINESSEVENTS_PVT.RAISE_BUSINESS_EVENT';

580: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
581: l_return_status VARCHAR2(30);
582: l_msg_count NUMBER;
583: l_msg_data VARCHAR2(4000);
584: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_BUSINESSEVENTS_PVT.RAISE_BUSINESS_EVENT';
585:
586: l_input_xml CLOB;
587: l_queryCtx dbms_xmlquery.ctxType;
588: l_table_count NUMBER;

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

635:
636: EXCEPTION
637: WHEN NO_DATA_FOUND THEN
638: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
639: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
640: fnd_message.set_token('ERRNO', sqlcode);
641: fnd_message.set_token('REASON', 'EXECUTION DETAIL ID NOT FOUND');
642: FND_MSG_PUB.add;
643: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

645: END IF;
646: RAISE FND_API.g_exc_error;
647: WHEN OTHERS THEN
648: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
649: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
650: fnd_message.set_token('ERRNO', sqlcode);
651: fnd_message.set_token('REASON', sqlerrm);
652: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
653: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID');

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

670:
671: EXCEPTION
672: WHEN NO_DATA_FOUND THEN
673: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
674: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
675: fnd_message.set_token('ERRNO', sqlcode);
676: fnd_message.set_token('REASON', 'INVALID USER');
677: FND_MSG_PUB.add;
678: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

680: END IF;
681: RAISE FND_API.g_exc_error;
682: WHEN OTHERS THEN
683: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
684: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
685: fnd_message.set_token('ERRNO', sqlcode);
686: fnd_message.set_token('REASON', sqlerrm);
687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
688: END;

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

726: );
727: EXCEPTION
728: WHEN OTHERS THEN
729: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
730: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
731: fnd_message.set_token('ERRNO', sqlcode);
732: fnd_message.set_token('REASON', sqlerrm);
733: FND_MSG_PUB.add;
734: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

738: END;
739: END LOOP;
740: ELSE
741: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
742: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
743: fnd_message.set_token('ERRNO', sqlcode);
744: fnd_message.set_token('REASON', 'Transaction Line Id is required for the API');
745: FND_MSG_PUB.add;
746: RAISE FND_API.G_EXC_ERROR;

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

756: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
757: EXCEPTION
758: WHEN OTHERS THEN
759: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
760: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
761: fnd_message.set_token('ERRNO', sqlcode);
762: fnd_message.set_token('REASON', sqlerrm);
763: FND_MSG_PUB.add;
764: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

776: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
777: EXCEPTION
778: WHEN OTHERS THEN
779: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
780: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
781: fnd_message.set_token('ERRNO', sqlcode);
782: fnd_message.set_token('REASON', sqlerrm);
783: FND_MSG_PUB.add;
784: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

914: AND to_number(supp_dist_claim_id) = p_txn_hdr_rec.claim_id;
915: EXCEPTION
916: WHEN NO_DATA_FOUND THEN
917: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
918: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
919: fnd_message.set_token('ERRNO', sqlcode);
920: fnd_message.set_token('REASON', 'INVALID CLAIM HEADER AMOUNT');
921: FND_MSG_PUB.add;
922: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

924: END IF;
925: RAISE FND_API.G_EXC_ERROR;
926: WHEN OTHERS THEN
927: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
928: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
929: fnd_message.set_token('ERRNO', sqlcode);
930: fnd_message.set_token('REASON', sqlerrm);
931: FND_MSG_PUB.add;
932: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

1097: WHEN NO_DATA_FOUND THEN
1098: l_cost_adj_acct := null;
1099: WHEN OTHERS THEN
1100: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1101: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1102: fnd_message.set_token('ERRNO', sqlcode);
1103: fnd_message.set_token('REASON', sqlerrm);
1104: FND_MSG_PUB.add;
1105: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

1119: AND dtha.transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
1120: EXCEPTION
1121: WHEN NO_DATA_FOUND THEN
1122: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1123: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1124: fnd_message.set_token('ERRNO', sqlcode);
1125: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT NOT FOUND');
1126: FND_MSG_PUB.add;
1127: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

1129: END IF;
1130: RAISE FND_API.G_EXC_ERROR;
1131: WHEN OTHERS THEN
1132: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1133: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1134: fnd_message.set_token('ERRNO', sqlcode);
1135: fnd_message.set_token('REASON', sqlerrm);
1136: FND_MSG_PUB.add;
1137: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

1199: END IF;
1200: END IF;
1201: ELSE
1202: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1203: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1204: fnd_message.set_token('ERRNO', sqlcode);
1205: fnd_message.set_token('REASON', 'COST ADJUSTMENT ACCOUNT IS NULL');
1206: FND_MSG_PUB.add;
1207: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

1330: AND dtha.transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
1331: EXCEPTION
1332: WHEN NO_DATA_FOUND THEN
1333: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1334: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1335: fnd_message.set_token('ERRNO', sqlcode);
1336: fnd_message.set_token('REASON', 'SUPPLIER TRADE PROFILE IS NOT FOUND'); --To be modified
1337: FND_MSG_PUB.add;
1338: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

1340: END IF;
1341: RAISE FND_API.g_exc_error;
1342: WHEN OTHERS THEN
1343: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1344: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1345: fnd_message.set_token('ERRNO', sqlcode);
1346: fnd_message.set_token('REASON', sqlerrm);
1347: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1348: FND_MESSAGE.set_name('DPP', 'DPP_BUSEVT_INVALID_EXE_DET_ID'); --To be modified

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

1738:
1739: WHEN OTHERS THEN
1740: ROLLBACK TO Raise_Business_Event;
1741: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1742: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1743: fnd_message.set_token('ERRNO', sqlcode);
1744: fnd_message.set_token('REASON', sqlerrm);
1745: x_return_status := FND_API.g_ret_sts_unexp_error ;
1746: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1796: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_BUSINESSEVENTS_PVT.RAISE_WORKFLOW_EVENT';

1792: l_target_system VARCHAR2(4) := 'EBIZ';
1793: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1794: l_exe_status VARCHAR2(15) := 'SUBMITTED';
1795: l_event_test VARCHAR2(10);
1796: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_BUSINESSEVENTS_PVT.RAISE_WORKFLOW_EVENT';
1797:
1798: BEGIN
1799:
1800: x_return_status := FND_API.g_ret_sts_success;

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

1842:
1843: EXCEPTION
1844: WHEN OTHERS THEN
1845: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1846: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1847: fnd_message.set_token('ERRNO', sqlcode);
1848: fnd_message.set_token('REASON', sqlerrm);
1849: FND_MSG_PUB.add;
1850: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

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

1913:
1914: WHEN OTHERS THEN
1915: ROLLBACK TO Raise_Workflow_Event;
1916: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1917: fnd_message.set_token('ROUTINE', 'DPP_BUSINESSEVENTS_PVT');
1918: fnd_message.set_token('ERRNO', sqlcode);
1919: fnd_message.set_token('REASON', sqlerrm);
1920: FND_MSG_PUB.add;
1921: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 1938: END DPP_BUSINESSEVENTS_PVT;

1934: END IF;
1935:
1936: END Raise_Workflow_Event;
1937:
1938: END DPP_BUSINESSEVENTS_PVT;
1939: