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 2140: l_doc_param_table EDR_EvidenceStore_PUB.Params_tbl_type;

2136: -- Variables to pass to the EDR APIs
2137:
2138: l_eRecord_Id NUMBER;
2139: l_document_rec EDR_PSIG_DOCUMENTS%ROWTYPE;
2140: l_doc_param_table EDR_EvidenceStore_PUB.Params_tbl_type;
2141: l_Signatures_tbl EDR_EvidenceStore_PUB.Signature_tbl_type;
2142: l_SignatureDetails EDR_PSIG_DETAILS%ROWTYPE;
2143: l_Signatureparams EDR_EvidenceStore_PUB.params_tbl_type;
2144:

Line 2141: l_Signatures_tbl EDR_EvidenceStore_PUB.Signature_tbl_type;

2137:
2138: l_eRecord_Id NUMBER;
2139: l_document_rec EDR_PSIG_DOCUMENTS%ROWTYPE;
2140: l_doc_param_table EDR_EvidenceStore_PUB.Params_tbl_type;
2141: l_Signatures_tbl EDR_EvidenceStore_PUB.Signature_tbl_type;
2142: l_SignatureDetails EDR_PSIG_DETAILS%ROWTYPE;
2143: l_Signatureparams EDR_EvidenceStore_PUB.params_tbl_type;
2144:
2145: -- Variables to be passed to the Update SR API

Line 2143: l_Signatureparams EDR_EvidenceStore_PUB.params_tbl_type;

2139: l_document_rec EDR_PSIG_DOCUMENTS%ROWTYPE;
2140: l_doc_param_table EDR_EvidenceStore_PUB.Params_tbl_type;
2141: l_Signatures_tbl EDR_EvidenceStore_PUB.Signature_tbl_type;
2142: l_SignatureDetails EDR_PSIG_DETAILS%ROWTYPE;
2143: l_Signatureparams EDR_EvidenceStore_PUB.params_tbl_type;
2144:
2145: -- Variables to be passed to the Update SR API
2146: l_note_status VARCHAR2(240);
2147: l_note_type VARCHAR2(240);

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

2319: END IF ;
2320:
2321: IF l_eRecord_Id IS NOT NULL THEN
2322:
2323: -- Log EDR_EvidenceStore_PUB.Get_DocumentDetails is being called
2324:
2325: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2326: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2327: dbg_msg := ('Calling EDR_EvidenceStore_PUB.Get_DocumentDetails');

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

2323: -- Log EDR_EvidenceStore_PUB.Get_DocumentDetails is being called
2324:
2325: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2326: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2327: dbg_msg := ('Calling EDR_EvidenceStore_PUB.Get_DocumentDetails');
2328: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2329: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2330: END IF;
2331: END IF;

Line 2337: EDR_EvidenceStore_PUB.Get_DocumentDetails

2333: -- Get Document Details using the eRecord/Document Id.
2334:
2335: l_return_status := FND_API.G_RET_STS_SUCCESS;
2336:
2337: EDR_EvidenceStore_PUB.Get_DocumentDetails
2338: ( P_api_version => 1.0,
2339: P_init_msg_list => FND_API.G_TRUE,
2340: p_document_id => l_eRecord_id,
2341: X_return_status => l_return_status,

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

2349: -- Log EDR_Standard_PUB.Get_ERecord_ID return status
2350:
2351: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2352: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2353: dbg_msg := ('After Calling EDR_EvidenceStore_PUB.Get_DocumentDetails');
2354: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2355: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2356: END IF;
2357: dbg_msg := ('EDR_EvidenceStore_PUB.Get_DocumentDetails Return Status : '||l_return_status);

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

2353: dbg_msg := ('After Calling EDR_EvidenceStore_PUB.Get_DocumentDetails');
2354: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2355: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2356: END IF;
2357: dbg_msg := ('EDR_EvidenceStore_PUB.Get_DocumentDetails Return Status : '||l_return_status);
2358: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2359: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2360: END IF;
2361: dbg_msg := ('EDR_EvidenceStore_PUB.Get_DocumentDetails Sig Table Count : '||l_signatures_tbl.COUNT);

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

2357: dbg_msg := ('EDR_EvidenceStore_PUB.Get_DocumentDetails Return Status : '||l_return_status);
2358: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2359: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2360: END IF;
2361: dbg_msg := ('EDR_EvidenceStore_PUB.Get_DocumentDetails Sig Table Count : '||l_signatures_tbl.COUNT);
2362: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2363: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2364: END IF;
2365: END IF;

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

2400: l_action := l_action_code||' '||l_signatures_tbl(i).user_response; --Bug 9879799 , changed l_action to l_action_Code
2401:
2402:
2403:
2404: -- Log EDR_EvidenceStore_PUB.GET_SignatureDetails is being called
2405:
2406: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2407: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2408: dbg_msg := ('Calling EDR_EvidenceStore_PUB.GET_SignatureDetails');

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

2404: -- Log EDR_EvidenceStore_PUB.GET_SignatureDetails is being called
2405:
2406: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2407: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2408: dbg_msg := ('Calling EDR_EvidenceStore_PUB.GET_SignatureDetails');
2409: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2410: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2411: END IF;
2412: END IF;

Line 2417: EDR_EvidenceStore_PUB.GET_SignatureDetails

2413: END IF;
2414:
2415: l_return_status := FND_API.G_RET_STS_SUCCESS;
2416:
2417: EDR_EvidenceStore_PUB.GET_SignatureDetails
2418: ( P_api_version => 1.0,
2419: P_init_msg_list => FND_API.G_TRUE ,
2420: P_signature_id => l_signatures_tbl(i).signature_id,
2421: X_return_status => l_return_status,

Line 2428: -- Log EDR_EvidenceStore_PUB.GET_SignatureDetails return status

2424: X_SIGNATUREDETAILS => l_signatureDetails,
2425: X_SIGNATUREPARAMS => l_Signatureparams ) ;
2426:
2427:
2428: -- Log EDR_EvidenceStore_PUB.GET_SignatureDetails return status
2429:
2430: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2431: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2432: dbg_msg := ('After Calling EDR_EvidenceStore_PUB.GET_SignatureDetails');

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

2428: -- Log EDR_EvidenceStore_PUB.GET_SignatureDetails return status
2429:
2430: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2431: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2432: dbg_msg := ('After Calling EDR_EvidenceStore_PUB.GET_SignatureDetails');
2433: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2434: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2435: END IF;
2436: dbg_msg := ('EDR_EvidenceStore_PUB.GET_SignatureDetails Return Status : '||l_return_status);

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

2432: dbg_msg := ('After Calling EDR_EvidenceStore_PUB.GET_SignatureDetails');
2433: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2434: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2435: END IF;
2436: dbg_msg := ('EDR_EvidenceStore_PUB.GET_SignatureDetails Return Status : '||l_return_status);
2437: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2438: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2439: END IF;
2440: dbg_msg := ('EDR_EvidenceStore_PUB.GET_SignatureDetails Sig Param Table Count : '||l_Signatureparams.COUNT);

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

2436: dbg_msg := ('EDR_EvidenceStore_PUB.GET_SignatureDetails Return Status : '||l_return_status);
2437: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2438: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2439: END IF;
2440: dbg_msg := ('EDR_EvidenceStore_PUB.GET_SignatureDetails Sig Param Table Count : '||l_Signatureparams.COUNT);
2441: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2442: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2443: END IF;
2444: END IF;