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.CS_ERES_INT_PKG dependencies on EDR_EVIDENCESTORE_PUB

Line 2055: l_doc_param_table EDR_EvidenceStore_PUB.Params_tbl_type;

2051: -- Variables to pass to the EDR APIs
2052:
2053: l_eRecord_Id NUMBER;
2054: l_document_rec EDR_PSIG_DOCUMENTS%ROWTYPE;
2055: l_doc_param_table EDR_EvidenceStore_PUB.Params_tbl_type;
2056: l_Signatures_tbl EDR_EvidenceStore_PUB.Signature_tbl_type;
2057: l_SignatureDetails EDR_PSIG_DETAILS%ROWTYPE;
2058: l_Signatureparams EDR_EvidenceStore_PUB.params_tbl_type;
2059:

Line 2056: l_Signatures_tbl EDR_EvidenceStore_PUB.Signature_tbl_type;

2052:
2053: l_eRecord_Id NUMBER;
2054: l_document_rec EDR_PSIG_DOCUMENTS%ROWTYPE;
2055: l_doc_param_table EDR_EvidenceStore_PUB.Params_tbl_type;
2056: l_Signatures_tbl EDR_EvidenceStore_PUB.Signature_tbl_type;
2057: l_SignatureDetails EDR_PSIG_DETAILS%ROWTYPE;
2058: l_Signatureparams EDR_EvidenceStore_PUB.params_tbl_type;
2059:
2060: -- Variables to be passed to the Update SR API

Line 2058: l_Signatureparams EDR_EvidenceStore_PUB.params_tbl_type;

2054: l_document_rec EDR_PSIG_DOCUMENTS%ROWTYPE;
2055: l_doc_param_table EDR_EvidenceStore_PUB.Params_tbl_type;
2056: l_Signatures_tbl EDR_EvidenceStore_PUB.Signature_tbl_type;
2057: l_SignatureDetails EDR_PSIG_DETAILS%ROWTYPE;
2058: l_Signatureparams EDR_EvidenceStore_PUB.params_tbl_type;
2059:
2060: -- Variables to be passed to the Update SR API
2061: l_note_status VARCHAR2(240);
2062: l_note_type VARCHAR2(240);

Line 2234: -- Log EDR_EvidenceStore_PUB.Get_DocumentDetails is being called

2230: END IF ;
2231:
2232: IF l_eRecord_Id IS NOT NULL THEN
2233:
2234: -- Log EDR_EvidenceStore_PUB.Get_DocumentDetails is being called
2235:
2236: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2237: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2238: dbg_msg := ('Calling EDR_EvidenceStore_PUB.Get_DocumentDetails');

Line 2238: dbg_msg := ('Calling EDR_EvidenceStore_PUB.Get_DocumentDetails');

2234: -- Log EDR_EvidenceStore_PUB.Get_DocumentDetails is being called
2235:
2236: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2237: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2238: dbg_msg := ('Calling EDR_EvidenceStore_PUB.Get_DocumentDetails');
2239: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2240: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2241: END IF;
2242: END IF;

Line 2248: EDR_EvidenceStore_PUB.Get_DocumentDetails

2244: -- Get Document Details using the eRecord/Document Id.
2245:
2246: l_return_status := FND_API.G_RET_STS_SUCCESS;
2247:
2248: EDR_EvidenceStore_PUB.Get_DocumentDetails
2249: ( P_api_version => 1.0,
2250: P_init_msg_list => FND_API.G_TRUE,
2251: p_document_id => l_eRecord_id,
2252: X_return_status => l_return_status,

Line 2264: dbg_msg := ('After Calling EDR_EvidenceStore_PUB.Get_DocumentDetails');

2260: -- Log EDR_Standard_PUB.Get_ERecord_ID return status
2261:
2262: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2263: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2264: dbg_msg := ('After Calling EDR_EvidenceStore_PUB.Get_DocumentDetails');
2265: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2266: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2267: END IF;
2268: dbg_msg := ('EDR_EvidenceStore_PUB.Get_DocumentDetails Return Status : '||l_return_status);

Line 2268: dbg_msg := ('EDR_EvidenceStore_PUB.Get_DocumentDetails Return Status : '||l_return_status);

2264: dbg_msg := ('After Calling EDR_EvidenceStore_PUB.Get_DocumentDetails');
2265: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2266: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2267: END IF;
2268: dbg_msg := ('EDR_EvidenceStore_PUB.Get_DocumentDetails Return Status : '||l_return_status);
2269: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2270: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2271: END IF;
2272: dbg_msg := ('EDR_EvidenceStore_PUB.Get_DocumentDetails Sig Table Count : '||l_signatures_tbl.COUNT);

Line 2272: dbg_msg := ('EDR_EvidenceStore_PUB.Get_DocumentDetails Sig Table Count : '||l_signatures_tbl.COUNT);

2268: dbg_msg := ('EDR_EvidenceStore_PUB.Get_DocumentDetails Return Status : '||l_return_status);
2269: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2270: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2271: END IF;
2272: dbg_msg := ('EDR_EvidenceStore_PUB.Get_DocumentDetails Sig Table Count : '||l_signatures_tbl.COUNT);
2273: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2274: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2275: END IF;
2276: END IF;

Line 2314: -- Log EDR_EvidenceStore_PUB.GET_SignatureDetails is being called

2310: ' ('||l_signatures_tbl(i).user_name||')';
2311: l_action := l_action||' '||l_signatures_tbl(i).user_response;
2312:
2313:
2314: -- Log EDR_EvidenceStore_PUB.GET_SignatureDetails is being called
2315:
2316: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2317: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2318: dbg_msg := ('Calling EDR_EvidenceStore_PUB.GET_SignatureDetails');

Line 2318: dbg_msg := ('Calling EDR_EvidenceStore_PUB.GET_SignatureDetails');

2314: -- Log EDR_EvidenceStore_PUB.GET_SignatureDetails is being called
2315:
2316: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2317: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2318: dbg_msg := ('Calling EDR_EvidenceStore_PUB.GET_SignatureDetails');
2319: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2320: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2321: END IF;
2322: END IF;

Line 2327: EDR_EvidenceStore_PUB.GET_SignatureDetails

2323: END IF;
2324:
2325: l_return_status := FND_API.G_RET_STS_SUCCESS;
2326:
2327: EDR_EvidenceStore_PUB.GET_SignatureDetails
2328: ( P_api_version => 1.0,
2329: P_init_msg_list => FND_API.G_TRUE ,
2330: P_signature_id => l_signatures_tbl(i).signature_id,
2331: X_return_status => l_return_status,

Line 2338: -- Log EDR_EvidenceStore_PUB.GET_SignatureDetails return status

2334: X_SIGNATUREDETAILS => l_signatureDetails,
2335: X_SIGNATUREPARAMS => l_Signatureparams ) ;
2336:
2337:
2338: -- Log EDR_EvidenceStore_PUB.GET_SignatureDetails return status
2339:
2340: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2341: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2342: dbg_msg := ('After Calling EDR_EvidenceStore_PUB.GET_SignatureDetails');

Line 2342: dbg_msg := ('After Calling EDR_EvidenceStore_PUB.GET_SignatureDetails');

2338: -- Log EDR_EvidenceStore_PUB.GET_SignatureDetails return status
2339:
2340: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2341: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2342: dbg_msg := ('After Calling EDR_EvidenceStore_PUB.GET_SignatureDetails');
2343: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2344: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2345: END IF;
2346: dbg_msg := ('EDR_EvidenceStore_PUB.GET_SignatureDetails Return Status : '||l_return_status);

Line 2346: dbg_msg := ('EDR_EvidenceStore_PUB.GET_SignatureDetails Return Status : '||l_return_status);

2342: dbg_msg := ('After Calling EDR_EvidenceStore_PUB.GET_SignatureDetails');
2343: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2344: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2345: END IF;
2346: dbg_msg := ('EDR_EvidenceStore_PUB.GET_SignatureDetails Return Status : '||l_return_status);
2347: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2348: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2349: END IF;
2350: dbg_msg := ('EDR_EvidenceStore_PUB.GET_SignatureDetails Sig Param Table Count : '||l_Signatureparams.COUNT);

Line 2350: dbg_msg := ('EDR_EvidenceStore_PUB.GET_SignatureDetails Sig Param Table Count : '||l_Signatureparams.COUNT);

2346: dbg_msg := ('EDR_EvidenceStore_PUB.GET_SignatureDetails Return Status : '||l_return_status);
2347: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2348: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2349: END IF;
2350: dbg_msg := ('EDR_EvidenceStore_PUB.GET_SignatureDetails Sig Param Table Count : '||l_Signatureparams.COUNT);
2351: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2352: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2353: END IF;
2354: END IF;