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 26: l_return_status VARCHAR2(3) := FND_API.G_RET_STS_SUCCESS;

22:
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;

Line 121: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 125: p_init_msg_list => fnd_api.g_false,

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

Line 126: p_commit => fnd_api.g_false,

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

Line 127: p_Validation_Level => fnd_api.g_valid_level_full,

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

Line 134: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 135: RAISE FND_API.G_EXC_ERROR;

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

Line 161: l_return_status := FND_API.G_RET_STS_SUCCESS;

157: END IF;
158:
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

Line 167: p_init_msg_list => fnd_api.g_false,

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,
170: x_msg_count => x_msg_count ,
171: x_msg_data => x_msg_data ,

Line 168: p_validation_level => fnd_api.g_valid_level_full,

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,
170: x_msg_count => x_msg_count ,
171: x_msg_data => x_msg_data ,
172: p_child_erecords => l_child_erecords ,

Line 203: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 204: RAISE FND_API.G_EXC_ERROR;

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

Line 213: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 218: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 227: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 244: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 248: p_init_msg_list => FND_API.G_TRUE ,

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

Line 258: p_autonomous_commit => FND_API.G_FALSE );

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

Line 276: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 277: RAISE FND_API.G_EXC_ERROR;

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

Line 282: WHEN FND_API.G_EXC_ERROR THEN

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

Line 283: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 446: l_return_status := FND_API.G_RET_STS_SUCCESS;

442: --
443: -- get sr ea data
444: --dbms_output.put_line('Going to call get sr ext data
');
445:
446: l_return_status := FND_API.G_RET_STS_SUCCESS;
447:
448: CS_SR_EXTATTRIBUTES_PVT.Get_SR_Ext_Attrs
449: ( p_api_version => 1.0
450: , p_init_msg_list => FND_API.G_FALSE

Line 450: , p_init_msg_list => FND_API.G_FALSE

446: l_return_status := FND_API.G_RET_STS_SUCCESS;
447:
448: CS_SR_EXTATTRIBUTES_PVT.Get_SR_Ext_Attrs
449: ( p_api_version => 1.0
450: , p_init_msg_list => FND_API.G_FALSE
451: , p_commit => FND_API.G_FALSE
452: , p_incident_id => p_incident_id
453: , p_object_name => 'CS_SERVICE_REQUEST'
454: , x_ext_attr_grp_tbl => l_extensibility_table

Line 451: , p_commit => FND_API.G_FALSE

447:
448: CS_SR_EXTATTRIBUTES_PVT.Get_SR_Ext_Attrs
449: ( p_api_version => 1.0
450: , p_init_msg_list => FND_API.G_FALSE
451: , p_commit => FND_API.G_FALSE
452: , p_incident_id => p_incident_id
453: , p_object_name => 'CS_SERVICE_REQUEST'
454: , x_ext_attr_grp_tbl => l_extensibility_table
455: , x_ext_attr_tbl => l_ext_attr_table

Line 467: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

463: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_ERES_INT_PKG.START_APPROVAL_PROCESS', dbg_msg);
464: END IF;
465: END IF;
466: --dbms_output.put_line('after call get sr ext data:' || l_return_status || '
');
467: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
468: RETURN NULL;
469: END IF;
470:
471: --dbms_output.put_line('return status is '||l_return_status);

Line 2148: l_return_status := FND_API.G_RET_STS_SUCCESS;

2144: END IF;
2145:
2146: -- Get the target Service request status
2147:
2148: l_return_status := FND_API.G_RET_STS_SUCCESS;
2149:
2150: Get_Target_SR_Status
2151: ( P_Incident_Id => P_Incident_id,
2152: P_Intermediate_Status_Id => P_Intermediate_Status_Id,

Line 2196: l_return_status := FND_API.G_RET_STS_SUCCESS;

2192: END IF;
2193:
2194: -- Get the document ID (Erecord Id) using the event key and event name
2195:
2196: l_return_status := FND_API.G_RET_STS_SUCCESS;
2197:
2198: EDR_Standard_PUB.Get_ERecord_ID
2199: (p_api_version => 1.0,
2200: p_init_msg_list => fnd_api.g_false,

Line 2200: p_init_msg_list => fnd_api.g_false,

2196: l_return_status := FND_API.G_RET_STS_SUCCESS;
2197:
2198: EDR_Standard_PUB.Get_ERecord_ID
2199: (p_api_version => 1.0,
2200: p_init_msg_list => fnd_api.g_false,
2201: p_event_name => 'oracle.apps.cs.sr.ServiceRequestApproval',
2202: p_event_key => P_Incident_id,
2203: x_return_status => l_return_status,
2204: x_msg_count => l_msg_count ,

Line 2228: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2224: END IF;
2225: END IF;
2226: END IF;
2227:
2228: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2229: l_spl_excp := 'Y';
2230: END IF ;
2231:
2232: IF l_eRecord_Id IS NOT NULL THEN

Line 2246: l_return_status := FND_API.G_RET_STS_SUCCESS;

2242: END IF;
2243: END IF;
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,

Line 2250: P_init_msg_list => FND_API.G_TRUE,

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,
2253: X_msg_count => l_msg_count,
2254: X_msg_data => l_msg_data,

Line 2279: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2275: END IF;
2276: END IF;
2277: END IF;
2278:
2279: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2280: l_spl_excp := 'Y';
2281: END IF;
2282:
2283: IF l_signatures_tbl.COUNT > 0 THEN

Line 2325: l_return_status := FND_API.G_RET_STS_SUCCESS;

2321: END IF;
2322: END IF;
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 ,

Line 2329: P_init_msg_list => FND_API.G_TRUE ,

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,
2332: X_msg_count => l_msg_count,
2333: X_msg_data => l_msg_data,

Line 2357: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2353: END IF;
2354: END IF;
2355: END IF;
2356:
2357: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2358: null;
2359: END IF ;
2360:
2361: FOR j IN 1..l_Signatureparams.COUNT

Line 2435: l_return_status := FND_API.G_RET_STS_SUCCESS ;

2431: END IF;
2432: END IF;
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,

Line 2471: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2467: END IF;
2468: END IF;
2469: END IF;
2470:
2471: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2472:
2473: IF l_note_type IS NOT NULL THEN
2474:
2475: -- Log JTF_NOTES_PUB API is being called to create notes for signer's comments.

Line 2489: l_return_status := FND_API.G_RET_STS_SUCCESS ;

2485:
2486: FOR k IN 1..l_notes_table.COUNT
2487: LOOP
2488: l_note_id := NULL;
2489: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2490:
2491: JTF_Notes_PUB.Create_Note
2492: ( p_api_version => 1.0
2493: , p_init_msg_list => fnd_api.g_false

Line 2493: , p_init_msg_list => fnd_api.g_false

2489: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2490:
2491: JTF_Notes_PUB.Create_Note
2492: ( p_api_version => 1.0
2493: , p_init_msg_list => fnd_api.g_false
2494: , p_commit => fnd_api.g_false
2495: , p_validation_level => fnd_api.g_valid_level_full
2496: , p_source_object_id => p_incident_id
2497: , p_source_object_code => 'SR'

Line 2494: , p_commit => fnd_api.g_false

2490:
2491: JTF_Notes_PUB.Create_Note
2492: ( p_api_version => 1.0
2493: , p_init_msg_list => fnd_api.g_false
2494: , p_commit => fnd_api.g_false
2495: , p_validation_level => fnd_api.g_valid_level_full
2496: , p_source_object_id => p_incident_id
2497: , p_source_object_code => 'SR'
2498: , p_notes => l_notes_table(k).note

Line 2495: , p_validation_level => fnd_api.g_valid_level_full

2491: JTF_Notes_PUB.Create_Note
2492: ( p_api_version => 1.0
2493: , p_init_msg_list => fnd_api.g_false
2494: , p_commit => fnd_api.g_false
2495: , p_validation_level => fnd_api.g_valid_level_full
2496: , p_source_object_id => p_incident_id
2497: , p_source_object_code => 'SR'
2498: , p_notes => l_notes_table(k).note
2499: , p_notes_detail => l_notes_table(k).note_detail

Line 2530: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2526: END IF;
2527:
2528: -- if JTF API errors out then do not raise any errors
2529:
2530: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2531:
2532: --Get all the error messages and add error messages to the note
2533:
2534: IF (FND_MSG_PUB.Count_Msg > 1) THEN

Line 2603: l_return_status := FND_API.G_RET_STS_SUCCESS ;

2599: END IF;
2600: END IF;
2601:
2602: -- Send an EDR acknowledgement.
2603: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2604:
2605: EDR_TRANS_ACKN_PUB.SEND_ACKN
2606: ( p_api_version => 1.0,
2607: p_init_msg_list => FND_API.G_TRUE ,

Line 2607: p_init_msg_list => FND_API.G_TRUE ,

2603: l_return_status := FND_API.G_RET_STS_SUCCESS ;
2604:
2605: EDR_TRANS_ACKN_PUB.SEND_ACKN
2606: ( p_api_version => 1.0,
2607: p_init_msg_list => FND_API.G_TRUE ,
2608: x_return_status => l_return_status,
2609: x_msg_count => l_msg_count,
2610: x_msg_data => l_msg_data,
2611: p_event_name => 'oracle.apps.cs.sr.ServiceRequesstApproval',

Line 2617: p_autonomous_commit => FND_API.G_FALSE );

2613: p_ERECord_id => l_ERECORD_ID,
2614: p_trans_status => 'SUCCESS',
2615: p_ackn_by => 'Service Request Approval Process',
2616: p_ackn_note => 'Service Request Approval Completed',
2617: p_autonomous_commit => FND_API.G_FALSE );
2618:
2619:
2620: -- Log EDR_TRANS_ACKN_PUB.SEND_ACKN return status
2621:

Line 2732: l_return_status := FND_API.G_RET_STS_SUCCESS;

2728: END IF;
2729:
2730: -- Get the initial status of the service request.
2731:
2732: l_return_status := FND_API.G_RET_STS_SUCCESS;
2733:
2734: Get_Target_SR_Status
2735: ( P_Incident_Id => P_Incident_id,
2736: P_Intermediate_Status_Id => P_Intermediate_Status_Id,

Line 2777: l_return_status := FND_API.G_RET_STS_SUCCESS ;

2773:
2774: -- call update service request api to update the service request to the initial status.
2775:
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,

Line 2812: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2808: END IF;
2809: END IF;
2810: END IF;
2811:
2812: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2813:
2814: IF l_note_type IS NOT NULL THEN
2815:
2816: -- Log JTF_NOTES_PUB API is being called to create notes for signer's comments.

Line 2830: l_return_status := FND_API.G_RET_STS_SUCCESS;

2826:
2827: FOR k IN 1..l_notes_table.COUNT
2828: LOOP
2829: l_note_id := NULL;
2830: l_return_status := FND_API.G_RET_STS_SUCCESS;
2831:
2832: JTF_Notes_PUB.Create_Note
2833: ( p_api_version => 1.0
2834: , p_init_msg_list => fnd_api.g_false

Line 2834: , p_init_msg_list => fnd_api.g_false

2830: l_return_status := FND_API.G_RET_STS_SUCCESS;
2831:
2832: JTF_Notes_PUB.Create_Note
2833: ( p_api_version => 1.0
2834: , p_init_msg_list => fnd_api.g_false
2835: , p_commit => fnd_api.g_false
2836: , p_validation_level => fnd_api.g_valid_level_full
2837: , p_source_object_id => p_incident_id
2838: , p_source_object_code => 'SR'

Line 2835: , p_commit => fnd_api.g_false

2831:
2832: JTF_Notes_PUB.Create_Note
2833: ( p_api_version => 1.0
2834: , p_init_msg_list => fnd_api.g_false
2835: , p_commit => fnd_api.g_false
2836: , p_validation_level => fnd_api.g_valid_level_full
2837: , p_source_object_id => p_incident_id
2838: , p_source_object_code => 'SR'
2839: , p_notes => l_notes_table(k).note

Line 2836: , p_validation_level => fnd_api.g_valid_level_full

2832: JTF_Notes_PUB.Create_Note
2833: ( p_api_version => 1.0
2834: , p_init_msg_list => fnd_api.g_false
2835: , p_commit => fnd_api.g_false
2836: , p_validation_level => fnd_api.g_valid_level_full
2837: , p_source_object_id => p_incident_id
2838: , p_source_object_code => 'SR'
2839: , p_notes => l_notes_table(k).note
2840: , p_notes_detail => l_notes_table(k).note_detail

Line 2871: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2867: END IF;
2868:
2869: -- if JTF API errors out then do not raise any errors
2870:
2871: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2872:
2873: --Get all the error messages and add error messages to the note
2874:
2875: IF (FND_MSG_PUB.Count_Msg > 1) THEN

Line 2946: l_return_status := FND_API.G_RET_STS_SUCCESS;

2942: END IF;
2943:
2944: -- Send an EDR acknowledgement.
2945:
2946: l_return_status := FND_API.G_RET_STS_SUCCESS;
2947:
2948: EDR_TRANS_ACKN_PUB.SEND_ACKN
2949: ( p_api_version => 1.0,
2950: p_init_msg_list => FND_API.G_TRUE ,

Line 2950: p_init_msg_list => FND_API.G_TRUE ,

2946: l_return_status := FND_API.G_RET_STS_SUCCESS;
2947:
2948: EDR_TRANS_ACKN_PUB.SEND_ACKN
2949: ( p_api_version => 1.0,
2950: p_init_msg_list => FND_API.G_TRUE ,
2951: x_return_status => l_return_status,
2952: x_msg_count => l_msg_count,
2953: x_msg_data => l_msg_data,
2954: p_event_name => 'oracle.apps.cs.sr.ServiceRequesstApproval',

Line 2960: p_autonomous_commit => FND_API.G_FALSE );

2956: p_ERECord_id => l_ERECORD_ID,
2957: p_trans_status => 'SUCCESS',
2958: p_ackn_by => 'Service Request Approval Process',
2959: p_ackn_note => 'Service Request Approval Completed',
2960: p_autonomous_commit => FND_API.G_FALSE );
2961:
2962: -- Log EDR_TRANS_ACKN_PUB.SEND_ACKN return status
2963:
2964: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN

Line 3062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3058: END IF ;
3059:
3060: EXCEPTION
3061: WHEN OTHERS THEN
3062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3063: FND_MESSAGE.SET_NAME('CS','CS_ERES_INVLD_INTMED_STS');
3064: FND_MSG_PUB.ADD;
3065: RAISE;
3066: END Get_Target_SR_Status ;