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_EXECUTIONPROCESS_PVT dependencies on DPP_EXECUTION_PROCESSES

Line 88: FROM OZF_PROCESS_SETUP_ALL OPSA, DPP_EXECUTION_PROCESSES DEP

84: L_SETUP_FLAG BOOLEAN := FALSE;
85:
86: CURSOR get_auto_flag_csr(p_supp_trd_prf_id NUMBER, p_process_code VARCHAR2, p_txn_hdr_id VARCHAR2) IS
87: SELECT NVL(AUTOMATIC_FLAG,'N') AUTOMATIC_FLAG
88: FROM OZF_PROCESS_SETUP_ALL OPSA, DPP_EXECUTION_PROCESSES DEP
89: WHERE NVL(SUPP_TRADE_PROFILE_ID,0) = NVL(P_SUPP_TRD_PRF_ID,0)
90: AND OPSA.PROCESS_CODE = P_PROCESS_CODE
91: AND OPSA.PROCESS_CODE = DEP.PROCESS_CODE
92: AND OPSA.ORG_ID = P_IN_ORG_ID

Line 363: FROM OZF_PROCESS_SETUP_ALL OPSA, DPP_EXECUTION_PROCESSES DEP

359: AND ROWNUM=1;
360:
361: CURSOR get_auto_flag_csr(p_supp_trd_prf_id NUMBER, p_process_code VARCHAR2, p_txn_hdr_id VARCHAR2) IS
362: SELECT NVL(AUTOMATIC_FLAG,'N') AUTOMATIC_FLAG
363: FROM OZF_PROCESS_SETUP_ALL OPSA, DPP_EXECUTION_PROCESSES DEP
364: WHERE NVL(SUPP_TRADE_PROFILE_ID,0) = NVL(P_SUPP_TRD_PRF_ID,0)
365: AND OPSA.PROCESS_CODE = P_PROCESS_CODE
366: AND OPSA.PROCESS_CODE = DEP.PROCESS_CODE
367: AND OPSA.ORG_ID = P_IN_ORG_ID

Line 1025: --Insert records into DPP_EXECUTION_PROCESSES based on the Execution Process setup either at STP or System Parameters

1021:
1022: L_SUPP_TRADE_PROFILE_ID := GET_PROCESS_SETUP_ID(P_VENDOR_ID, P_VENDOR_SITE_ID, P_ORG_ID);
1023:
1024: --Process Setup exist
1025: --Insert records into DPP_EXECUTION_PROCESSES based on the Execution Process setup either at STP or System Parameters
1026: InsertExecProcesses(
1027: p_txn_hdr_id => p_txn_hdr_id,
1028: p_org_id => p_org_id,
1029: p_supp_trd_prfl_id => l_supp_trade_profile_id,

Line 1108: FROM DPP_EXECUTION_PROCESSES

1104: --Cursor to get the count of execution processes for the transaction
1105: CURSOR get_exec_processes_cnt(p_txn_hdr_id NUMBER)
1106: IS
1107: SELECT COUNT(1)
1108: FROM DPP_EXECUTION_PROCESSES
1109: WHERE transaction_header_id = p_txn_hdr_id;
1110:
1111: --Cursor to retrieve the process codes from look up
1112: CURSOR get_process_codes_csr (p_supp_trd_prf_id NUMBER)

Line 1117: WHERE dppl.lookup_type = 'DPP_EXECUTION_PROCESSES'

1113: IS
1114: SELECT dppl.lookup_code
1115: FROM dpp_lookups dppl,
1116: OZF_PROCESS_SETUP_ALL opsa
1117: WHERE dppl.lookup_type = 'DPP_EXECUTION_PROCESSES'
1118: AND dppl.tag is not null
1119: AND nvl(opsa.supp_trade_profile_id,0) = nvl(p_supp_trd_prf_id,0)
1120: AND opsa.enabled_flag = 'Y'
1121: AND opsa.org_id = p_org_id

Line 1130: BEGIN --Check if the transaction exists in DPP_EXECUTION_PROCESSES table

1126:
1127: -- Initialize API return status to SUCCESS
1128: x_return_status := FND_API.G_RET_STS_SUCCESS;
1129:
1130: BEGIN --Check if the transaction exists in DPP_EXECUTION_PROCESSES table
1131: OPEN get_exec_processes_cnt(p_txn_hdr_id);
1132: FETCH get_exec_processes_cnt INTO l_exe_process_cnt;
1133: CLOSE get_exec_processes_cnt;
1134: EXCEPTION

Line 1136: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while checking if the transaction exists in DPP_EXECUTION_PROCESSES table: '||SQLERRM);

1132: FETCH get_exec_processes_cnt INTO l_exe_process_cnt;
1133: CLOSE get_exec_processes_cnt;
1134: EXCEPTION
1135: WHEN OTHERS THEN
1136: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while checking if the transaction exists in DPP_EXECUTION_PROCESSES table: '||SQLERRM);
1137: FND_FILE.NEW_LINE(FND_FILE.LOG);
1138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1139: END;
1140:

Line 1143: DELETE FROM DPP_EXECUTION_PROCESSES

1139: END;
1140:
1141: IF l_exe_process_cnt > 0 THEN
1142: BEGIN
1143: DELETE FROM DPP_EXECUTION_PROCESSES
1144: WHERE transaction_header_id = p_txn_hdr_id;
1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while deleting the records from DPP_EXECUTION_PROCESSES table: ' || SQLERRM);

Line 1147: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while deleting the records from DPP_EXECUTION_PROCESSES table: ' || SQLERRM);

1143: DELETE FROM DPP_EXECUTION_PROCESSES
1144: WHERE transaction_header_id = p_txn_hdr_id;
1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while deleting the records from DPP_EXECUTION_PROCESSES table: ' || SQLERRM);
1148: FND_FILE.NEW_LINE(FND_FILE.LOG);
1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1150: END;
1151: END IF;

Line 1156: --Insert the Process codes into the DPP_EXECUTION_PROCESSES table

1152:
1153: FOR get_process_codes_rec IN get_process_codes_csr(p_supp_trd_prfl_id)
1154: LOOP
1155: BEGIN
1156: --Insert the Process codes into the DPP_EXECUTION_PROCESSES table
1157: INSERT INTO DPP_EXECUTION_PROCESSES (process_code,
1158: transaction_header_id,
1159: created_by,
1160: creation_date,

Line 1157: INSERT INTO DPP_EXECUTION_PROCESSES (process_code,

1153: FOR get_process_codes_rec IN get_process_codes_csr(p_supp_trd_prfl_id)
1154: LOOP
1155: BEGIN
1156: --Insert the Process codes into the DPP_EXECUTION_PROCESSES table
1157: INSERT INTO DPP_EXECUTION_PROCESSES (process_code,
1158: transaction_header_id,
1159: created_by,
1160: creation_date,
1161: last_updated_by,

Line 1175: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while inserting into DPP_EXECUTION_PROCESSES: ' || SQLERRM);

1171: l_login_id
1172: );
1173: EXCEPTION
1174: WHEN OTHERS THEN
1175: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception while inserting into DPP_EXECUTION_PROCESSES: ' || SQLERRM);
1176: FND_FILE.NEW_LINE(FND_FILE.LOG);
1177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1178: END;
1179: END LOOP;