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 FND_API

Line 27: l_return_status VARCHAR2(3) := FND_API.G_RET_STS_SUCCESS;

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

Line 122: l_return_status := FND_API.G_RET_STS_SUCCESS;

118: -- Call the QA API to get eRecord for the QA records.
119:
120: IF p_qa_collection_id IS NOT NULL THEN
121:
122: l_return_status := FND_API.G_RET_STS_SUCCESS;
123:
124: QA_RESULT_GRP.Get_QA_Results_Erecords
125: ( p_api_version => 1.0,
126: p_init_msg_list => fnd_api.g_false,

Line 126: p_init_msg_list => fnd_api.g_false,

122: l_return_status := FND_API.G_RET_STS_SUCCESS;
123:
124: QA_RESULT_GRP.Get_QA_Results_Erecords
125: ( p_api_version => 1.0,
126: p_init_msg_list => fnd_api.g_false,
127: p_commit => fnd_api.g_false,
128: p_Validation_Level => fnd_api.g_valid_level_full,
129: p_Collection_Id => p_qa_collection_id,
130: X_qa_erecord_tbl => l_qa_erecord_tbl,

Line 127: p_commit => fnd_api.g_false,

123:
124: QA_RESULT_GRP.Get_QA_Results_Erecords
125: ( p_api_version => 1.0,
126: p_init_msg_list => fnd_api.g_false,
127: p_commit => fnd_api.g_false,
128: p_Validation_Level => fnd_api.g_valid_level_full,
129: p_Collection_Id => p_qa_collection_id,
130: X_qa_erecord_tbl => l_qa_erecord_tbl,
131: x_return_status => l_return_status,

Line 128: p_Validation_Level => fnd_api.g_valid_level_full,

124: QA_RESULT_GRP.Get_QA_Results_Erecords
125: ( p_api_version => 1.0,
126: p_init_msg_list => fnd_api.g_false,
127: p_commit => fnd_api.g_false,
128: p_Validation_Level => fnd_api.g_valid_level_full,
129: p_Collection_Id => p_qa_collection_id,
130: X_qa_erecord_tbl => l_qa_erecord_tbl,
131: x_return_status => l_return_status,
132: x_msg_count => x_msg_count,

Line 135: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

131: x_return_status => l_return_status,
132: x_msg_count => x_msg_count,
133: x_msg_data => x_msg_data );
134:
135: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
136: RAISE FND_API.G_EXC_ERROR;
137: ELSE
138: IF l_qa_erecord_tbl.COUNT > 0 THEN
139: FOR i IN 1..l_qa_erecord_tbl.COUNT

Line 136: RAISE FND_API.G_EXC_ERROR;

132: x_msg_count => x_msg_count,
133: x_msg_data => x_msg_data );
134:
135: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
136: RAISE FND_API.G_EXC_ERROR;
137: ELSE
138: IF l_qa_erecord_tbl.COUNT > 0 THEN
139: FOR i IN 1..l_qa_erecord_tbl.COUNT
140: LOOP

Line 162: l_return_status := FND_API.G_RET_STS_SUCCESS;

158: END IF;
159:
160: -- Call the ERES API to raise ERES event.
161:
162: l_return_status := FND_API.G_RET_STS_SUCCESS;
163:
164: --dbms_output.put_line('Start Approval Process - Calling EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT');
165:
166: EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT

Line 168: p_init_msg_list => fnd_api.g_false,

164: --dbms_output.put_line('Start Approval Process - Calling EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT');
165:
166: EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT
167: ( p_api_version => 1.0 ,
168: p_init_msg_list => fnd_api.g_false,
169: p_validation_level => fnd_api.g_valid_level_full,
170: x_return_status => l_return_status,
171: x_msg_count => x_msg_count ,
172: x_msg_data => x_msg_data ,

Line 169: p_validation_level => fnd_api.g_valid_level_full,

165:
166: EDR_ERES_EVENT_PUB.RAISE_ERES_EVENT
167: ( p_api_version => 1.0 ,
168: p_init_msg_list => fnd_api.g_false,
169: p_validation_level => fnd_api.g_valid_level_full,
170: x_return_status => l_return_status,
171: x_msg_count => x_msg_count ,
172: x_msg_data => x_msg_data ,
173: p_child_erecords => l_child_erecords ,

Line 204: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

200: END IF;
201: END IF;
202: END IF;
203:
204: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
205: RAISE FND_API.G_EXC_ERROR;
206: END IF;
207:
208: -- send an acknowledge to ERES about the business transaction being completed successfully

Line 205: RAISE FND_API.G_EXC_ERROR;

201: END IF;
202: END IF;
203:
204: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
205: RAISE FND_API.G_EXC_ERROR;
206: END IF;
207:
208: -- send an acknowledge to ERES about the business transaction being completed successfully
209: -- This acknowledgement will not be sent from this API if the ERES API response is 'PENDING'.

Line 214: x_return_status := FND_API.G_RET_STS_SUCCESS;

210:
211: IF (l_event.event_status = 'PENDING') THEN
212: l_send_ackn := FALSE;
213: l_txn_status := 'SUCCESS';
214: x_return_status := FND_API.G_RET_STS_SUCCESS;
215: x_approval_status := 'PENDING';
216: ELSIF (l_event.event_status ='ERROR') AND (l_event.ERECORD_ID IS NOT NULL) THEN
217: l_send_ackn := TRUE;
218: l_txn_status := 'ERROR';

Line 219: x_return_status := FND_API.G_RET_STS_ERROR;

215: x_approval_status := 'PENDING';
216: ELSIF (l_event.event_status ='ERROR') AND (l_event.ERECORD_ID IS NOT NULL) THEN
217: l_send_ackn := TRUE;
218: l_txn_status := 'ERROR';
219: x_return_status := FND_API.G_RET_STS_ERROR;
220: x_approval_status := 'ERROR';
221: ELSIF (l_event.event_status = 'NOACTION') THEN
222:
223: IF l_event.ERECORD_ID IS NOT NULL THEN

Line 228: x_return_status := FND_API.G_RET_STS_SUCCESS;

224: l_send_ackn := TRUE;
225: l_txn_status := 'SUCCESS';
226: END IF ;
227:
228: x_return_status := FND_API.G_RET_STS_SUCCESS;
229: x_approval_status := 'NO_ACTION';
230: END IF ;
231:
232: IF l_send_ackn = TRUE THEN

Line 245: l_return_status := FND_API.G_RET_STS_SUCCESS;

241: END IF;
242: END IF;
243: END IF;
244:
245: l_return_status := FND_API.G_RET_STS_SUCCESS;
246:
247: EDR_TRANS_ACKN_PUB.SEND_ACKN
248: ( p_api_version => 1.0,
249: p_init_msg_list => FND_API.G_TRUE ,

Line 249: p_init_msg_list => FND_API.G_TRUE ,

245: l_return_status := FND_API.G_RET_STS_SUCCESS;
246:
247: EDR_TRANS_ACKN_PUB.SEND_ACKN
248: ( p_api_version => 1.0,
249: p_init_msg_list => FND_API.G_TRUE ,
250: x_return_status => l_return_status,
251: x_msg_count => x_msg_count,
252: x_msg_data => x_msg_data,
253: p_event_name => l_event.event_name,

Line 259: p_autonomous_commit => FND_API.G_FALSE );

255: p_ERECord_id => l_event.ERECORD_ID,
256: p_trans_status => l_txn_status,
257: p_ackn_by => 'Service Request Approval Process',
258: p_ackn_note => 'Service Request Approval Initiation process completed',
259: p_autonomous_commit => FND_API.G_FALSE );
260:
261: -- Log output of EDR_TRANS_ACKN_PUB.SEND_ACKN call
262:
263: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

Line 277: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

273: END IF;
274: END IF;
275: END IF;
276:
277: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
278: RAISE FND_API.G_EXC_ERROR;
279: END IF ;
280: END IF ; -- l_send_ackn
281:

Line 278: RAISE FND_API.G_EXC_ERROR;

274: END IF;
275: END IF;
276:
277: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
278: RAISE FND_API.G_EXC_ERROR;
279: END IF ;
280: END IF ; -- l_send_ackn
281:
282: EXCEPTION

Line 283: WHEN FND_API.G_EXC_ERROR THEN

279: END IF ;
280: END IF ; -- l_send_ackn
281:
282: EXCEPTION
283: WHEN FND_API.G_EXC_ERROR THEN
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: FND_MSG_PUB.Count_And_Get
286: ( p_count => x_msg_count,
287: p_data => x_msg_data

Line 284: x_return_status := FND_API.G_RET_STS_ERROR;

280: END IF ; -- l_send_ackn
281:
282: EXCEPTION
283: WHEN FND_API.G_EXC_ERROR THEN
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: FND_MSG_PUB.Count_And_Get
286: ( p_count => x_msg_count,
287: p_data => x_msg_data
288: );

Line 290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

286: ( p_count => x_msg_count,
287: p_data => x_msg_data
288: );
289:
290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: FND_MSG_PUB.Count_And_Get
293: ( p_count => x_msg_count,
294: p_data => x_msg_data

Line 291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

287: p_data => x_msg_data
288: );
289:
290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: FND_MSG_PUB.Count_And_Get
293: ( p_count => x_msg_count,
294: p_data => x_msg_data
295: );

Line 297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

293: ( p_count => x_msg_count,
294: p_data => x_msg_data
295: );
296: WHEN OTHERS THEN
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: FND_MSG_PUB.Count_And_Get
299: ( p_count => x_msg_count,
300: p_data => x_msg_data
301: );

Line 460: l_return_status := FND_API.G_RET_STS_SUCCESS;

456: --
457: -- get sr ea data
458: --dbms_output.put_line('Going to call get sr ext data
');
459:
460: l_return_status := FND_API.G_RET_STS_SUCCESS;
461:
462: CS_SR_EXTATTRIBUTES_PVT.Get_SR_Ext_Attrs
463: ( p_api_version => 1.0
464: , p_init_msg_list => FND_API.G_FALSE

Line 464: , p_init_msg_list => FND_API.G_FALSE

460: l_return_status := FND_API.G_RET_STS_SUCCESS;
461:
462: CS_SR_EXTATTRIBUTES_PVT.Get_SR_Ext_Attrs
463: ( p_api_version => 1.0
464: , p_init_msg_list => FND_API.G_FALSE
465: , p_commit => FND_API.G_FALSE
466: , p_incident_id => p_incident_id
467: , p_object_name => 'CS_SERVICE_REQUEST'
468: , x_ext_attr_grp_tbl => l_extensibility_table

Line 465: , p_commit => FND_API.G_FALSE

461:
462: CS_SR_EXTATTRIBUTES_PVT.Get_SR_Ext_Attrs
463: ( p_api_version => 1.0
464: , p_init_msg_list => FND_API.G_FALSE
465: , p_commit => FND_API.G_FALSE
466: , p_incident_id => p_incident_id
467: , p_object_name => 'CS_SERVICE_REQUEST'
468: , x_ext_attr_grp_tbl => l_extensibility_table
469: , x_ext_attr_tbl => l_ext_attr_table

Line 481: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

477: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.START_APPROVAL_PROCESS', dbg_msg);
478: END IF;
479: END IF;
480: --dbms_output.put_line('after call get sr ext data:' || l_return_status || '
');
481: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
482: RETURN NULL;
483: END IF;
484:
485: --dbms_output.put_line('return status is '||l_return_status);

Line 2237: l_return_status := FND_API.G_RET_STS_SUCCESS;

2233: END IF;
2234:
2235: -- Get the target Service request status
2236:
2237: l_return_status := FND_API.G_RET_STS_SUCCESS;
2238:
2239: Get_Target_SR_Status
2240: ( P_Incident_Id => P_Incident_id,
2241: P_Intermediate_Status_Id => P_Intermediate_Status_Id,

Line 2285: l_return_status := FND_API.G_RET_STS_SUCCESS;

2281: END IF;
2282:
2283: -- Get the document ID (Erecord Id) using the event key and event name
2284:
2285: l_return_status := FND_API.G_RET_STS_SUCCESS;
2286:
2287: EDR_Standard_PUB.Get_ERecord_ID
2288: (p_api_version => 1.0,
2289: p_init_msg_list => fnd_api.g_false,

Line 2289: p_init_msg_list => fnd_api.g_false,

2285: l_return_status := FND_API.G_RET_STS_SUCCESS;
2286:
2287: EDR_Standard_PUB.Get_ERecord_ID
2288: (p_api_version => 1.0,
2289: p_init_msg_list => fnd_api.g_false,
2290: p_event_name => 'oracle.apps.cs.sr.ServiceRequestApproval',
2291: p_event_key => P_Incident_id,
2292: x_return_status => l_return_status,
2293: x_msg_count => l_msg_count ,

Line 2317: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2313: END IF;
2314: END IF;
2315: END IF;
2316:
2317: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2318: l_spl_excp := 'Y';
2319: END IF ;
2320:
2321: IF l_eRecord_Id IS NOT NULL THEN

Line 2335: l_return_status := FND_API.G_RET_STS_SUCCESS;

2331: END IF;
2332: END IF;
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,

Line 2339: P_init_msg_list => FND_API.G_TRUE,

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,
2342: X_msg_count => l_msg_count,
2343: X_msg_data => l_msg_data,

Line 2368: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2364: END IF;
2365: END IF;
2366: END IF;
2367:
2368: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2369: l_spl_excp := 'Y';
2370: END IF;
2371:
2372: IF l_signatures_tbl.COUNT > 0 THEN

Line 2415: l_return_status := FND_API.G_RET_STS_SUCCESS;

2411: END IF;
2412: END IF;
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 ,

Line 2419: P_init_msg_list => FND_API.G_TRUE ,

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,
2422: X_msg_count => l_msg_count,
2423: X_msg_data => l_msg_data,

Line 2447: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2443: END IF;
2444: END IF;
2445: END IF;
2446:
2447: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2448: null;
2449: END IF ;
2450:
2451: FOR j IN 1..l_Signatureparams.COUNT

Line 2529: l_return_status := FND_API.G_RET_STS_SUCCESS ;

2525: END IF;
2526: END IF;
2527: END IF;
2528:
2529: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2530:
2531: CS_ServiceRequest_PVT.Update_ServiceRequest
2532: ( p_api_version => 4.0,
2533: x_return_status => l_return_status,

Line 2565: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2561: END IF;
2562: END IF;
2563: END IF;
2564:
2565: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2566:
2567: IF l_note_type IS NOT NULL THEN
2568:
2569: -- Log JTF_NOTES_PUB API is being called to create notes for signer's comments.

Line 2583: l_return_status := FND_API.G_RET_STS_SUCCESS ;

2579:
2580: FOR k IN 1..l_notes_table.COUNT
2581: LOOP
2582: l_note_id := NULL;
2583: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2584:
2585: JTF_Notes_PUB.Create_Note
2586: ( p_api_version => 1.0
2587: , p_init_msg_list => fnd_api.g_false

Line 2587: , p_init_msg_list => fnd_api.g_false

2583: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2584:
2585: JTF_Notes_PUB.Create_Note
2586: ( p_api_version => 1.0
2587: , p_init_msg_list => fnd_api.g_false
2588: , p_commit => fnd_api.g_false
2589: , p_validation_level => fnd_api.g_valid_level_full
2590: , p_source_object_id => p_incident_id
2591: , p_source_object_code => 'SR'

Line 2588: , p_commit => fnd_api.g_false

2584:
2585: JTF_Notes_PUB.Create_Note
2586: ( p_api_version => 1.0
2587: , p_init_msg_list => fnd_api.g_false
2588: , p_commit => fnd_api.g_false
2589: , p_validation_level => fnd_api.g_valid_level_full
2590: , p_source_object_id => p_incident_id
2591: , p_source_object_code => 'SR'
2592: , p_notes => l_notes_table(k).note

Line 2589: , p_validation_level => fnd_api.g_valid_level_full

2585: JTF_Notes_PUB.Create_Note
2586: ( p_api_version => 1.0
2587: , p_init_msg_list => fnd_api.g_false
2588: , p_commit => fnd_api.g_false
2589: , p_validation_level => fnd_api.g_valid_level_full
2590: , p_source_object_id => p_incident_id
2591: , p_source_object_code => 'SR'
2592: , p_notes => l_notes_table(k).note
2593: , p_notes_detail => l_notes_table(k).note_detail

Line 2624: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2620: END IF;
2621:
2622: -- if JTF API errors out then do not raise any errors
2623:
2624: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2625:
2626: --Get all the error messages and add error messages to the note
2627:
2628: IF (FND_MSG_PUB.Count_Msg > 1) THEN

Line 2697: l_return_status := FND_API.G_RET_STS_SUCCESS ;

2693: END IF;
2694: END IF;
2695:
2696: -- Send an EDR acknowledgement.
2697: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2698:
2699: EDR_TRANS_ACKN_PUB.SEND_ACKN
2700: ( p_api_version => 1.0,
2701: p_init_msg_list => FND_API.G_TRUE ,

Line 2701: p_init_msg_list => FND_API.G_TRUE ,

2697: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2698:
2699: EDR_TRANS_ACKN_PUB.SEND_ACKN
2700: ( p_api_version => 1.0,
2701: p_init_msg_list => FND_API.G_TRUE ,
2702: x_return_status => l_return_status,
2703: x_msg_count => l_msg_count,
2704: x_msg_data => l_msg_data,
2705: p_event_name => 'oracle.apps.cs.sr.ServiceRequesstApproval',

Line 2711: p_autonomous_commit => FND_API.G_FALSE );

2707: p_ERECord_id => l_ERECORD_ID,
2708: p_trans_status => 'SUCCESS',
2709: p_ackn_by => 'Service Request Approval Process',
2710: p_ackn_note => 'Service Request Approval Completed',
2711: p_autonomous_commit => FND_API.G_FALSE );
2712:
2713:
2714: -- Log EDR_TRANS_ACKN_PUB.SEND_ACKN return status
2715:

Line 2826: l_return_status := FND_API.G_RET_STS_SUCCESS;

2822: END IF;
2823:
2824: -- Get the initial status of the service request.
2825:
2826: l_return_status := FND_API.G_RET_STS_SUCCESS;
2827:
2828: Get_Target_SR_Status
2829: ( P_Incident_Id => P_Incident_id,
2830: P_Intermediate_Status_Id => P_Intermediate_Status_Id,

Line 2871: l_return_status := FND_API.G_RET_STS_SUCCESS ;

2867:
2868: -- call update service request api to update the service request to the initial status.
2869:
2870: l_servicerequest_Rec.status_id := l_target_status_id;
2871: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2872:
2873:
2874: CS_ServiceRequest_PVT.Update_ServiceRequest
2875: ( p_api_version => 4.0,

Line 2906: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2902: END IF;
2903: END IF;
2904: END IF;
2905:
2906: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2907:
2908: IF l_note_type IS NOT NULL THEN
2909:
2910: -- Log JTF_NOTES_PUB API is being called to create notes for signer's comments.

Line 2924: l_return_status := FND_API.G_RET_STS_SUCCESS;

2920:
2921: FOR k IN 1..l_notes_table.COUNT
2922: LOOP
2923: l_note_id := NULL;
2924: l_return_status := FND_API.G_RET_STS_SUCCESS;
2925:
2926: JTF_Notes_PUB.Create_Note
2927: ( p_api_version => 1.0
2928: , p_init_msg_list => fnd_api.g_false

Line 2928: , p_init_msg_list => fnd_api.g_false

2924: l_return_status := FND_API.G_RET_STS_SUCCESS;
2925:
2926: JTF_Notes_PUB.Create_Note
2927: ( p_api_version => 1.0
2928: , p_init_msg_list => fnd_api.g_false
2929: , p_commit => fnd_api.g_false
2930: , p_validation_level => fnd_api.g_valid_level_full
2931: , p_source_object_id => p_incident_id
2932: , p_source_object_code => 'SR'

Line 2929: , p_commit => fnd_api.g_false

2925:
2926: JTF_Notes_PUB.Create_Note
2927: ( p_api_version => 1.0
2928: , p_init_msg_list => fnd_api.g_false
2929: , p_commit => fnd_api.g_false
2930: , p_validation_level => fnd_api.g_valid_level_full
2931: , p_source_object_id => p_incident_id
2932: , p_source_object_code => 'SR'
2933: , p_notes => l_notes_table(k).note

Line 2930: , p_validation_level => fnd_api.g_valid_level_full

2926: JTF_Notes_PUB.Create_Note
2927: ( p_api_version => 1.0
2928: , p_init_msg_list => fnd_api.g_false
2929: , p_commit => fnd_api.g_false
2930: , p_validation_level => fnd_api.g_valid_level_full
2931: , p_source_object_id => p_incident_id
2932: , p_source_object_code => 'SR'
2933: , p_notes => l_notes_table(k).note
2934: , p_notes_detail => l_notes_table(k).note_detail

Line 2965: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2961: END IF;
2962:
2963: -- if JTF API errors out then do not raise any errors
2964:
2965: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2966:
2967: --Get all the error messages and add error messages to the note
2968:
2969: IF (FND_MSG_PUB.Count_Msg > 1) THEN

Line 3040: l_return_status := FND_API.G_RET_STS_SUCCESS;

3036: END IF;
3037:
3038: -- Send an EDR acknowledgement.
3039:
3040: l_return_status := FND_API.G_RET_STS_SUCCESS;
3041:
3042: EDR_TRANS_ACKN_PUB.SEND_ACKN
3043: ( p_api_version => 1.0,
3044: p_init_msg_list => FND_API.G_TRUE ,

Line 3044: p_init_msg_list => FND_API.G_TRUE ,

3040: l_return_status := FND_API.G_RET_STS_SUCCESS;
3041:
3042: EDR_TRANS_ACKN_PUB.SEND_ACKN
3043: ( p_api_version => 1.0,
3044: p_init_msg_list => FND_API.G_TRUE ,
3045: x_return_status => l_return_status,
3046: x_msg_count => l_msg_count,
3047: x_msg_data => l_msg_data,
3048: p_event_name => 'oracle.apps.cs.sr.ServiceRequesstApproval',

Line 3054: p_autonomous_commit => FND_API.G_FALSE );

3050: p_ERECord_id => l_ERECORD_ID,
3051: p_trans_status => 'SUCCESS',
3052: p_ackn_by => 'Service Request Approval Process',
3053: p_ackn_note => 'Service Request Approval Completed',
3054: p_autonomous_commit => FND_API.G_FALSE );
3055:
3056: -- Log EDR_TRANS_ACKN_PUB.SEND_ACKN return status
3057:
3058: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

Line 3156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3152: END IF ;
3153:
3154: EXCEPTION
3155: WHEN OTHERS THEN
3156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3157: FND_MESSAGE.SET_NAME('CS','CS_ERES_INVLD_INTMED_STS');
3158: FND_MSG_PUB.ADD;
3159: RAISE;
3160: END Get_Target_SR_Status ;