DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on EDR_ERES_EVENT_PUB

Line 27: l_child_erecords EDR_ERES_EVENT_PUB.ERECORD_ID_TBL_TYPE;

23: -- Local variables
24: l_det_erec_req VARCHAR2(3);
25: l_xml_doc CLOB;
26: l_return_status VARCHAR2(3) := FND_API.G_RET_STS_SUCCESS;
27: l_child_erecords EDR_ERES_EVENT_PUB.ERECORD_ID_TBL_TYPE;
28: l_event EDR_ERES_EVENT_PUB.ERES_EVENT_REC_TYPE;
29: l_qa_erecord_tbl QA_RESULT_GRP.QA_ERECORD_TBL_TYPE;
30: l_send_ackn BOOLEAN := FALSE;
31: l_txn_status VARCHAR2(30);

Line 28: l_event EDR_ERES_EVENT_PUB.ERES_EVENT_REC_TYPE;

24: l_det_erec_req VARCHAR2(3);
25: l_xml_doc CLOB;
26: l_return_status VARCHAR2(3) := FND_API.G_RET_STS_SUCCESS;
27: l_child_erecords EDR_ERES_EVENT_PUB.ERECORD_ID_TBL_TYPE;
28: l_event EDR_ERES_EVENT_PUB.ERES_EVENT_REC_TYPE;
29: l_qa_erecord_tbl QA_RESULT_GRP.QA_ERECORD_TBL_TYPE;
30: l_send_ackn BOOLEAN := FALSE;
31: l_txn_status VARCHAR2(30);
32: l_str VARCHAR2(240);

Line 152: dbg_msg := ('Calling EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT API ');

148: dbg_msg := ('P_Incident_id :'||P_Incident_id);
149:
150: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
151: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.START_APPROVAL_PROCESS')) THEN
152: dbg_msg := ('Calling EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT API ');
153: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.START_APPROVAL_PROCESS', dbg_msg);
155: END IF;
156: END IF;

Line 163: --dbms_output.put_line('Start Approval Process - Calling EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT');

159: -- Call the ERES API to raise ERES event.
160:
161: l_return_status := FND_API.G_RET_STS_SUCCESS;
162:
163: --dbms_output.put_line('Start Approval Process - Calling EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT');
164:
165: EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT
166: ( p_api_version => 1.0 ,
167: p_init_msg_list => fnd_api.g_false,

Line 165: EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT

161: l_return_status := FND_API.G_RET_STS_SUCCESS;
162:
163: --dbms_output.put_line('Start Approval Process - Calling EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT');
164:
165: EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT
166: ( p_api_version => 1.0 ,
167: p_init_msg_list => fnd_api.g_false,
168: p_validation_level => fnd_api.g_valid_level_full,
169: x_return_status => l_return_status,

Line 181: dbg_msg := ('After Calling EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT API ');

177: --dbms_output.put_line('Event Status : '||l_event.event_status);
178:
179: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
180: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.START_APPROVAL_PROCESS')) THEN
181: dbg_msg := ('After Calling EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT API ');
182: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
183: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.START_APPROVAL_PROCESS', dbg_msg);
184: END IF;
185:

Line 186: dbg_msg := ('EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT API Return Status : '||l_return_status);

182: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
183: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.START_APPROVAL_PROCESS', dbg_msg);
184: END IF;
185:
186: dbg_msg := ('EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT API Return Status : '||l_return_status);
187: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
188: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.START_APPROVAL_PROCESS', dbg_msg);
189: END IF;
190:

Line 191: dbg_msg := ('EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT API Event Status : '||l_event.event_status);

187: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
188: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.START_APPROVAL_PROCESS', dbg_msg);
189: END IF;
190:
191: dbg_msg := ('EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT API Event Status : '||l_event.event_status);
192: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
193: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.START_APPROVAL_PROCESS', dbg_msg);
194: END IF;
195:

Line 196: dbg_msg := ('EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT API ERecord ID : '||l_event.ERECORD_ID);

192: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
193: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.START_APPROVAL_PROCESS', dbg_msg);
194: END IF;
195:
196: dbg_msg := ('EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT API ERecord ID : '||l_event.ERECORD_ID);
197: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
198: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.START_APPROVAL_PROCESS', dbg_msg);
199: END IF;
200: END IF;