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 CS_SERVICEREQUEST_PVT

Line 2063: l_notes_table CS_ServiceRequest_PVT.Notes_Table;

2059:
2060: -- Variables to be passed to the Update SR API
2061: l_note_status VARCHAR2(240);
2062: l_note_type VARCHAR2(240);
2063: l_notes_table CS_ServiceRequest_PVT.Notes_Table;
2064: l_notes_table_dummy CS_ServiceRequest_PVT.Notes_Table;
2065: l_ServiceRequest_Rec CS_ServiceRequest_PVT.Service_Request_Rec_Type;
2066: l_sr_version NUMBER;
2067: l_note_text VARCHAR2(4000);

Line 2064: l_notes_table_dummy CS_ServiceRequest_PVT.Notes_Table;

2060: -- Variables to be passed to the Update SR API
2061: l_note_status VARCHAR2(240);
2062: l_note_type VARCHAR2(240);
2063: l_notes_table CS_ServiceRequest_PVT.Notes_Table;
2064: l_notes_table_dummy CS_ServiceRequest_PVT.Notes_Table;
2065: l_ServiceRequest_Rec CS_ServiceRequest_PVT.Service_Request_Rec_Type;
2066: l_sr_version NUMBER;
2067: l_note_text VARCHAR2(4000);
2068: l_contacts_table CS_ServiceRequest_PVT.Contacts_Table;

Line 2065: l_ServiceRequest_Rec CS_ServiceRequest_PVT.Service_Request_Rec_Type;

2061: l_note_status VARCHAR2(240);
2062: l_note_type VARCHAR2(240);
2063: l_notes_table CS_ServiceRequest_PVT.Notes_Table;
2064: l_notes_table_dummy CS_ServiceRequest_PVT.Notes_Table;
2065: l_ServiceRequest_Rec CS_ServiceRequest_PVT.Service_Request_Rec_Type;
2066: l_sr_version NUMBER;
2067: l_note_text VARCHAR2(4000);
2068: l_contacts_table CS_ServiceRequest_PVT.Contacts_Table;
2069: l_sr_update_out_rec CS_ServiceRequest_PVT.sr_update_out_rec_type;

Line 2068: l_contacts_table CS_ServiceRequest_PVT.Contacts_Table;

2064: l_notes_table_dummy CS_ServiceRequest_PVT.Notes_Table;
2065: l_ServiceRequest_Rec CS_ServiceRequest_PVT.Service_Request_Rec_Type;
2066: l_sr_version NUMBER;
2067: l_note_text VARCHAR2(4000);
2068: l_contacts_table CS_ServiceRequest_PVT.Contacts_Table;
2069: l_sr_update_out_rec CS_ServiceRequest_PVT.sr_update_out_rec_type;
2070:
2071: -- Local Variables
2072: l_sig_status VARCHAR2(40);

Line 2069: l_sr_update_out_rec CS_ServiceRequest_PVT.sr_update_out_rec_type;

2065: l_ServiceRequest_Rec CS_ServiceRequest_PVT.Service_Request_Rec_Type;
2066: l_sr_version NUMBER;
2067: l_note_text VARCHAR2(4000);
2068: l_contacts_table CS_ServiceRequest_PVT.Contacts_Table;
2069: l_sr_update_out_rec CS_ServiceRequest_PVT.sr_update_out_rec_type;
2070:
2071: -- Local Variables
2072: l_sig_status VARCHAR2(40);
2073: l_target_status_id NUMBER;

Line 2411: CS_ServiceRequest_PVT.Initialize_Rec(l_servicerequest_Rec);

2407:
2408: -- Call Update Service Request API to update the SR Status and Create Notes
2409:
2410: -- Initialize the service request record.
2411: CS_ServiceRequest_PVT.Initialize_Rec(l_servicerequest_Rec);
2412:
2413: IF l_sr_status_id = p_intermediate_status_id THEN
2414: l_servicerequest_Rec.status_id := l_target_status_id;
2415: END IF ;

Line 2424: -- Log CS_ServiceRequest_PVT.Update_ServiceRequest is being called

2420: -- If UpdateService Request API call fails then add additional note and
2421: -- update the service request status to the initial status
2422:
2423:
2424: -- Log CS_ServiceRequest_PVT.Update_ServiceRequest is being called
2425:
2426: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2427: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2428: dbg_msg := ('Calling CS_ServiceRequest_PVT.Update_ServiceRequest (1)');

Line 2428: dbg_msg := ('Calling CS_ServiceRequest_PVT.Update_ServiceRequest (1)');

2424: -- Log CS_ServiceRequest_PVT.Update_ServiceRequest is being called
2425:
2426: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2427: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2428: dbg_msg := ('Calling CS_ServiceRequest_PVT.Update_ServiceRequest (1)');
2429: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2430: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2431: END IF;
2432: END IF;

Line 2437: CS_ServiceRequest_PVT.Update_ServiceRequest

2433: END IF;
2434:
2435: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2436:
2437: CS_ServiceRequest_PVT.Update_ServiceRequest
2438: ( p_api_version => 4.0,
2439: x_return_status => l_return_status,
2440: x_msg_count => l_msg_count,
2441: x_msg_data => l_msg_data,

Line 2456: -- Log CS_ServiceRequest_PVT.Update_ServiceRequest return status

2452: x_sr_update_out_rec => l_sr_update_out_rec );
2453:
2454:
2455:
2456: -- Log CS_ServiceRequest_PVT.Update_ServiceRequest return status
2457:
2458: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2459: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2460: dbg_msg := ('After Calling CS_ServiceRequest_PVT.Update_ServiceRequest');

Line 2460: dbg_msg := ('After Calling CS_ServiceRequest_PVT.Update_ServiceRequest');

2456: -- Log CS_ServiceRequest_PVT.Update_ServiceRequest return status
2457:
2458: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2459: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2460: dbg_msg := ('After Calling CS_ServiceRequest_PVT.Update_ServiceRequest');
2461: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2462: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2463: END IF;
2464: dbg_msg := ('CS_ServiceRequest_PVT.Update_ServiceRequest Return Status : '||l_return_status);

Line 2464: dbg_msg := ('CS_ServiceRequest_PVT.Update_ServiceRequest Return Status : '||l_return_status);

2460: dbg_msg := ('After Calling CS_ServiceRequest_PVT.Update_ServiceRequest');
2461: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2462: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2463: END IF;
2464: dbg_msg := ('CS_ServiceRequest_PVT.Update_ServiceRequest Return Status : '||l_return_status);
2465: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2466: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2467: END IF;
2468: END IF;

Line 2763: -- Log CS_ServiceRequest_PVT.Update_ServiceRequest is being called

2759: END IF;
2760: END IF;
2761: END IF;
2762:
2763: -- Log CS_ServiceRequest_PVT.Update_ServiceRequest is being called
2764:
2765: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2766: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2767: dbg_msg := ('Calling CS_ServiceRequest_PVT.Update_ServiceRequest (2)');

Line 2767: dbg_msg := ('Calling CS_ServiceRequest_PVT.Update_ServiceRequest (2)');

2763: -- Log CS_ServiceRequest_PVT.Update_ServiceRequest is being called
2764:
2765: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2766: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2767: dbg_msg := ('Calling CS_ServiceRequest_PVT.Update_ServiceRequest (2)');
2768: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2769: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2770: END IF;
2771: END IF;

Line 2780: CS_ServiceRequest_PVT.Update_ServiceRequest

2776: l_servicerequest_Rec.status_id := l_target_status_id;
2777: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2778:
2779:
2780: CS_ServiceRequest_PVT.Update_ServiceRequest
2781: ( p_api_version => 4.0,
2782: x_return_status => l_return_status,
2783: x_msg_count => l_msg_count,
2784: x_msg_data => l_msg_data,

Line 2797: -- Log CS_ServiceRequest_PVT.Update_ServiceRequest return status

2793: p_validate_sr_closure => NVL(l_validate_sr_close,'N'),
2794: p_auto_close_child_entities => NVL(l_validate_sr_close,'N'),
2795: x_sr_update_out_rec => l_sr_update_out_rec );
2796:
2797: -- Log CS_ServiceRequest_PVT.Update_ServiceRequest return status
2798:
2799: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2800: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2801: dbg_msg := ('After Calling CS_ServiceRequest_PVT.Update_ServiceRequest (2)');

Line 2801: dbg_msg := ('After Calling CS_ServiceRequest_PVT.Update_ServiceRequest (2)');

2797: -- Log CS_ServiceRequest_PVT.Update_ServiceRequest return status
2798:
2799: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
2800: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process')) THEN
2801: dbg_msg := ('After Calling CS_ServiceRequest_PVT.Update_ServiceRequest (2)');
2802: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2803: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2804: END IF;
2805: dbg_msg := ('CS_ServiceRequest_PVT.Update_ServiceRequest Return Status : '||l_return_status);

Line 2805: dbg_msg := ('CS_ServiceRequest_PVT.Update_ServiceRequest Return Status : '||l_return_status);

2801: dbg_msg := ('After Calling CS_ServiceRequest_PVT.Update_ServiceRequest (2)');
2802: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2803: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2804: END IF;
2805: dbg_msg := ('CS_ServiceRequest_PVT.Update_ServiceRequest Return Status : '||l_return_status);
2806: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2807: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.Post_Approval_Process', dbg_msg);
2808: END IF;
2809: END IF;