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_EXECUTION_DETAILS

Line 33: --Get the number of times the notification process was run without an error for this transaction, from the dpp execution details table.

29: RETURN BOOLEAN IS
30: L_EXECUTED BOOLEAN DEFAULT FALSE;
31: L_EXEC_COUNT NUMBER;
32: BEGIN
33: --Get the number of times the notification process was run without an error for this transaction, from the dpp execution details table.
34: SELECT COUNT(1)
35: INTO L_EXEC_COUNT
36: FROM DPP_EXECUTION_DETAILS
37: WHERE TRANSACTION_HEADER_ID=P_TXN_HDR_ID

Line 36: FROM DPP_EXECUTION_DETAILS

32: BEGIN
33: --Get the number of times the notification process was run without an error for this transaction, from the dpp execution details table.
34: SELECT COUNT(1)
35: INTO L_EXEC_COUNT
36: FROM DPP_EXECUTION_DETAILS
37: WHERE TRANSACTION_HEADER_ID=P_TXN_HDR_ID
38: AND PROCESS_CODE=P_PROC_CODE
39: AND EXECUTION_STATUS <> 'ERROR';
40:

Line 1806: --Check if the event subscription can be raised or not before inserting into the DPP_EXECUTION_DETAILS table

1802: SAVEPOINT Raise_Workflow_Event;
1803:
1804: --Get a unique value for the l_new_item_key key
1805: l_new_item_key := TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
1806: --Check if the event subscription can be raised or not before inserting into the DPP_EXECUTION_DETAILS table
1807: l_event_test := wf_event.test(l_event_name);
1808: IF l_event_test = 'NONE' THEN
1809: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'No enabled local subscriptions reference the event, or the event does not exist.');
1810: RAISE FND_API.g_exc_error;

Line 1816: --Insert a line in to the DPP_EXECUTION_DETAILS table corresponding to the process which has been started

1812: DPP_UTILITY_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Number of rows Processed : '||p_row_count);
1813:
1814: --Check if the xml has any rows processed and raise the event
1815: IF p_row_count > 0 THEN
1816: --Insert a line in to the DPP_EXECUTION_DETAILS table corresponding to the process which has been started
1817: BEGIN
1818: INSERT INTO DPP_EXECUTION_DETAILS (EXECUTION_DETAIL_ID,
1819: object_version_number,
1820: TRANSACTION_HEADER_ID,

Line 1818: INSERT INTO DPP_EXECUTION_DETAILS (EXECUTION_DETAIL_ID,

1814: --Check if the xml has any rows processed and raise the event
1815: IF p_row_count > 0 THEN
1816: --Insert a line in to the DPP_EXECUTION_DETAILS table corresponding to the process which has been started
1817: BEGIN
1818: INSERT INTO DPP_EXECUTION_DETAILS (EXECUTION_DETAIL_ID,
1819: object_version_number,
1820: TRANSACTION_HEADER_ID,
1821: PROCESS_CODE,
1822: INPUT_XML,