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_SR_DELETE_UTIL dependencies on FND_API

Line 17: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

13:
14: PROCEDURE Delete_Contacts
15: (
16: p_api_version_number IN NUMBER := 1.0
17: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
18: , p_commit IN VARCHAR2 := FND_API.G_FALSE
19: , p_object_type IN VARCHAR2
20: , p_processing_set_id IN NUMBER
21: , x_return_status OUT NOCOPY VARCHAR2

Line 18: , p_commit IN VARCHAR2 := FND_API.G_FALSE

14: PROCEDURE Delete_Contacts
15: (
16: p_api_version_number IN NUMBER := 1.0
17: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
18: , p_commit IN VARCHAR2 := FND_API.G_FALSE
19: , p_object_type IN VARCHAR2
20: , p_processing_set_id IN NUMBER
21: , x_return_status OUT NOCOPY VARCHAR2
22: , x_msg_count OUT NOCOPY NUMBER

Line 29: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

25:
26: PROCEDURE Delete_Audit_Records
27: (
28: p_api_version_number IN NUMBER := 1.0
29: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
30: , p_commit IN VARCHAR2 := FND_API.G_FALSE
31: , p_object_type IN VARCHAR2
32: , p_processing_set_id IN NUMBER
33: , x_return_status OUT NOCOPY VARCHAR2

Line 30: , p_commit IN VARCHAR2 := FND_API.G_FALSE

26: PROCEDURE Delete_Audit_Records
27: (
28: p_api_version_number IN NUMBER := 1.0
29: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
30: , p_commit IN VARCHAR2 := FND_API.G_FALSE
31: , p_object_type IN VARCHAR2
32: , p_processing_set_id IN NUMBER
33: , x_return_status OUT NOCOPY VARCHAR2
34: , x_msg_count OUT NOCOPY NUMBER

Line 41: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

37:
38: PROCEDURE Delete_Sr_Attributes
39: (
40: p_api_version_number IN NUMBER := 1.0
41: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
42: , p_commit IN VARCHAR2 := FND_API.G_FALSE
43: , p_object_type IN VARCHAR2
44: , p_processing_set_id IN NUMBER
45: , x_return_status OUT NOCOPY VARCHAR2

Line 42: , p_commit IN VARCHAR2 := FND_API.G_FALSE

38: PROCEDURE Delete_Sr_Attributes
39: (
40: p_api_version_number IN NUMBER := 1.0
41: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
42: , p_commit IN VARCHAR2 := FND_API.G_FALSE
43: , p_object_type IN VARCHAR2
44: , p_processing_set_id IN NUMBER
45: , x_return_status OUT NOCOPY VARCHAR2
46: , x_msg_count OUT NOCOPY NUMBER

Line 53: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

49:
50: PROCEDURE Create_Purgeaudit_Records
51: (
52: p_api_version_number IN NUMBER := 1.0
53: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
54: , p_commit IN VARCHAR2 := FND_API.G_FALSE
55: , p_purge_set_id IN NUMBER
56: , p_incident_id_tbl IN t_number_tbl
57: , p_incident_number_tbl IN t_long_string_tbl

Line 54: , p_commit IN VARCHAR2 := FND_API.G_FALSE

50: PROCEDURE Create_Purgeaudit_Records
51: (
52: p_api_version_number IN NUMBER := 1.0
53: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
54: , p_commit IN VARCHAR2 := FND_API.G_FALSE
55: , p_purge_set_id IN NUMBER
56: , p_incident_id_tbl IN t_number_tbl
57: , p_incident_number_tbl IN t_long_string_tbl
58: , p_incident_type_id_tbl IN t_number_tbl

Line 125: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

121: */
122: PROCEDURE Delete_Sr_Validations
123: (
124: p_api_version_number IN NUMBER := 1.0
125: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
126: , p_commit IN VARCHAR2 := FND_API.G_FALSE
127: , p_object_type IN VARCHAR2
128: , p_processing_set_id IN NUMBER
129: , p_purge_source_with_open_task IN VARCHAR2

Line 126: , p_commit IN VARCHAR2 := FND_API.G_FALSE

122: PROCEDURE Delete_Sr_Validations
123: (
124: p_api_version_number IN NUMBER := 1.0
125: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
126: , p_commit IN VARCHAR2 := FND_API.G_FALSE
127: , p_object_type IN VARCHAR2
128: , p_processing_set_id IN NUMBER
129: , p_purge_source_with_open_task IN VARCHAR2
130: , x_return_status OUT NOCOPY VARCHAR2

Line 145: x_return_status := FND_API.G_RET_STS_SUCCESS;

141:
142: x_msg_index_out NUMBER;
143:
144: BEGIN
145: x_return_status := FND_API.G_RET_STS_SUCCESS;
146:
147: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
148: THEN
149: fnd_log.string

Line 193: IF NOT FND_API.Compatible_API_Call

189: , 'p_processing_set_id:' || p_processing_set_id
190: );
191: END IF ;
192:
193: IF NOT FND_API.Compatible_API_Call
194: (
195: L_API_VERSION
196: , p_api_version_number
197: , L_API_NAME

Line 206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

202: (
203: p_count => x_msg_count
204: , p_data => x_msg_data
205: );
206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
207: END IF ;
208:
209: IF FND_API.to_Boolean(p_init_msg_list)
210: THEN

Line 209: IF FND_API.to_Boolean(p_init_msg_list)

205: );
206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
207: END IF ;
208:
209: IF FND_API.to_Boolean(p_init_msg_list)
210: THEN
211: FND_MSG_PUB.initialize;
212: END IF ;
213:

Line 236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

232: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');
233: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);
234: FND_MSG_PUB.ADD;
235:
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
238:
239: ---
240:

Line 259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

255: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
256: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
257: FND_MSG_PUB.ADD;
258:
259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
260: END IF;
261:
262: ---
263:

Line 291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

287: )
288: );
289: FND_MSG_PUB.ADD;
290:
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: END IF;
293:
294: ------------------------------------------------------------------------------
295: -- Actual Logic starts below:

Line 302: IF x_return_status = FND_API.G_RET_STS_SUCCESS

298: Check_User_Termination;
299:
300: ---
301:
302: IF x_return_status = FND_API.G_RET_STS_SUCCESS
303: THEN
304: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
305: THEN
306: fnd_log.string

Line 322: , p_init_msg_list => FND_API.G_FALSE

318:
319: CSF_MAINTAIN_GRP.Validate_FieldServiceObjects
320: (
321: p_api_version => '1.0'
322: , p_init_msg_list => FND_API.G_FALSE
323: , p_commit => FND_API.G_FALSE
324: , p_processing_set_id => p_processing_set_id
325: , p_object_type => p_object_type
326: , x_return_status => x_return_status

Line 323: , p_commit => FND_API.G_FALSE

319: CSF_MAINTAIN_GRP.Validate_FieldServiceObjects
320: (
321: p_api_version => '1.0'
322: , p_init_msg_list => FND_API.G_FALSE
323: , p_commit => FND_API.G_FALSE
324: , p_processing_set_id => p_processing_set_id
325: , p_object_type => p_object_type
326: , x_return_status => x_return_status
327: , x_msg_count => x_msg_count

Line 349: IF x_return_status = FND_API.G_RET_STS_SUCCESS

345: Check_User_Termination;
346:
347: ---
348:
349: IF x_return_status = FND_API.G_RET_STS_SUCCESS
350: THEN
351: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
352: THEN
353: fnd_log.string

Line 369: , p_init_msg_list => FND_API.G_FALSE

365:
366: CS_CHARGE_DETAILS_PVT.Purge_Chg_Validations
367: (
368: p_api_version_number => '1.0'
369: , p_init_msg_list => FND_API.G_FALSE
370: , p_commit => FND_API.G_FALSE
371: , p_processing_set_id => p_processing_set_id
372: , p_object_type => p_object_type
373: , x_return_status => x_return_status

Line 370: , p_commit => FND_API.G_FALSE

366: CS_CHARGE_DETAILS_PVT.Purge_Chg_Validations
367: (
368: p_api_version_number => '1.0'
369: , p_init_msg_list => FND_API.G_FALSE
370: , p_commit => FND_API.G_FALSE
371: , p_processing_set_id => p_processing_set_id
372: , p_object_type => p_object_type
373: , x_return_status => x_return_status
374: , x_msg_count => x_msg_count

Line 395: IF x_return_status = FND_API.G_RET_STS_SUCCESS

391: Check_User_Termination;
392:
393: ---
394:
395: IF x_return_status = FND_API.G_RET_STS_SUCCESS
396: THEN
397: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
398: THEN
399: fnd_log.string

Line 414: , p_init_msg_list => FND_API.G_FALSE

410:
411: CAC_TASK_PURGE_PUB.Validate_Tasks
412: (
413: p_api_version => '1.0'
414: , p_init_msg_list => FND_API.G_FALSE
415: , p_commit => FND_API.G_FALSE
416: , p_processing_set_id => p_processing_set_id
417: , p_object_type => p_object_type
418: , p_purge_source_with_open_task => p_purge_source_with_open_task

Line 415: , p_commit => FND_API.G_FALSE

411: CAC_TASK_PURGE_PUB.Validate_Tasks
412: (
413: p_api_version => '1.0'
414: , p_init_msg_list => FND_API.G_FALSE
415: , p_commit => FND_API.G_FALSE
416: , p_processing_set_id => p_processing_set_id
417: , p_object_type => p_object_type
418: , p_purge_source_with_open_task => p_purge_source_with_open_task
419: , x_return_status => x_return_status

Line 454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

450: END IF ;
451:
452: EXCEPTION
453:
454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456:
457: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
458: THEN

Line 455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

451:
452: EXCEPTION
453:
454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456:
457: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
458: THEN
459: fnd_log.string

Line 463: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL

459: fnd_log.string
460: (
461: fnd_log.level_unexpected
462: , L_LOG_MODULE || 'unexpected_error'
463: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
464: );
465:
466: x_msg_count := FND_MSG_PUB.Count_Msg;
467:

Line 492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

488: END IF ;
489: END IF ;
490:
491: WHEN OTHERS THEN
492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
493: FND_MESSAGE.Set_Name('CS', 'CS_SR_DEL_VAL_FAIL');
494: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
495: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
496: FND_MSG_PUB.ADD;

Line 576: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

572: */
573: PROCEDURE Delete_ServiceRequest
574: (
575: p_api_version_number IN NUMBER := 1.0
576: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
577: , p_commit IN VARCHAR2 := FND_API.G_FALSE
578: , p_purge_set_id IN NUMBER
579: , p_processing_set_id IN NUMBER
580: , p_object_type IN VARCHAR2

Line 577: , p_commit IN VARCHAR2 := FND_API.G_FALSE

573: PROCEDURE Delete_ServiceRequest
574: (
575: p_api_version_number IN NUMBER := 1.0
576: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
577: , p_commit IN VARCHAR2 := FND_API.G_FALSE
578: , p_purge_set_id IN NUMBER
579: , p_processing_set_id IN NUMBER
580: , p_object_type IN VARCHAR2
581: , p_audit_required IN VARCHAR2

Line 615: x_return_status := FND_API.G_RET_STS_SUCCESS;

611: l_source_lang_tbl t_string_tbl;
612: l_summary_tbl t_long_string_tbl;
613:
614: BEGIN
615: x_return_status := FND_API.G_RET_STS_SUCCESS;
616:
617: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
618: THEN
619: fnd_log.string

Line 669: IF NOT FND_API.Compatible_API_Call

665: , 'p_audit_required:' || p_audit_required
666: );
667: END IF ;
668:
669: IF NOT FND_API.Compatible_API_Call
670: (
671: L_API_VERSION
672: , p_api_version_number
673: , L_API_NAME

Line 682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

678: (
679: p_count => x_msg_count
680: , p_data => x_msg_data
681: );
682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
683: END IF ;
684:
685: IF
686: FND_API.to_Boolean(p_init_msg_list)

Line 686: FND_API.to_Boolean(p_init_msg_list)

682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
683: END IF ;
684:
685: IF
686: FND_API.to_Boolean(p_init_msg_list)
687: THEN
688: FND_MSG_PUB.initialize;
689: END IF ;
690:

Line 714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

710: FND_MESSAGE.Set_Token('PARAM', 'p_audit_required');
711: FND_MESSAGE.Set_Token('CURRVAL', p_audit_required);
712: FND_MSG_PUB.ADD;
713:
714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
715: END IF;
716:
717: ---
718:

Line 737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

733: FND_MESSAGE.Set_Token('PARAM', 'p_object_type');
734: FND_MESSAGE.Set_Token('CURRVAL', p_object_type);
735: FND_MSG_PUB.ADD;
736:
737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
738: END IF;
739:
740: ---
741:

Line 760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

756: FND_MESSAGE.Set_Token('PARAM', 'p_processing_set_id');
757: FND_MESSAGE.Set_Token('CURRVAL', NVL(to_char(p_processing_set_id),'NULL'));
758: FND_MSG_PUB.ADD;
759:
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
761: END IF;
762:
763: ------------------------------------------------------------------------------
764: -- Actual Logic starts below:

Line 800: IF x_return_status = FND_API.G_RET_STS_SUCCESS

796: Check_User_Termination;
797:
798: ---
799:
800: IF x_return_status = FND_API.G_RET_STS_SUCCESS
801: THEN
802: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
803: THEN
804: fnd_log.string

Line 819: , p_init_msg_list => FND_API.G_FALSE

815:
816: CSF_MAINTAIN_GRP.Purge_FieldServiceObjects
817: (
818: p_api_version => '1.0'
819: , p_init_msg_list => FND_API.G_FALSE
820: , p_commit => FND_API.G_FALSE
821: , p_processing_set_id => p_processing_set_id
822: , p_object_type => p_object_type
823: , x_return_status => x_return_status

Line 820: , p_commit => FND_API.G_FALSE

816: CSF_MAINTAIN_GRP.Purge_FieldServiceObjects
817: (
818: p_api_version => '1.0'
819: , p_init_msg_list => FND_API.G_FALSE
820: , p_commit => FND_API.G_FALSE
821: , p_processing_set_id => p_processing_set_id
822: , p_object_type => p_object_type
823: , x_return_status => x_return_status
824: , x_msg_count => x_msg_count

Line 846: IF x_return_status = FND_API.G_RET_STS_SUCCESS

842: Check_User_Termination;
843:
844: ---
845:
846: IF x_return_status = FND_API.G_RET_STS_SUCCESS
847: THEN
848: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
849: THEN
850: fnd_log.string

Line 865: , p_init_msg_list => FND_API.G_FALSE

861:
862: CS_CHARGE_DETAILS_PVT.Purge_Charges
863: (
864: p_api_version_number => '1.0'
865: , p_init_msg_list => FND_API.G_FALSE
866: , p_commit => FND_API.G_FALSE
867: , p_processing_set_id => p_processing_set_id
868: , p_object_type => p_object_type
869: , x_return_status => x_return_status

Line 866: , p_commit => FND_API.G_FALSE

862: CS_CHARGE_DETAILS_PVT.Purge_Charges
863: (
864: p_api_version_number => '1.0'
865: , p_init_msg_list => FND_API.G_FALSE
866: , p_commit => FND_API.G_FALSE
867: , p_processing_set_id => p_processing_set_id
868: , p_object_type => p_object_type
869: , x_return_status => x_return_status
870: , x_msg_count => x_msg_count

Line 895: IF x_return_status = FND_API.G_RET_STS_SUCCESS

891:
892:
893: --Added for 12.1 Service Costing
894:
895: IF x_return_status = FND_API.G_RET_STS_SUCCESS
896: THEN
897: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
898: THEN
899: fnd_log.string

Line 917: , p_init_msg_list => FND_API.G_FALSE

913:
914: CS_COST_DETAILS_PVT.Purge_Cost
915: (
916: p_api_version_number => '1.0'
917: , p_init_msg_list => FND_API.G_FALSE
918: , p_commit => FND_API.G_FALSE
919: , p_processing_set_id => p_processing_set_id
920: , p_object_type => p_object_type
921: , x_return_status => x_return_status

Line 918: , p_commit => FND_API.G_FALSE

914: CS_COST_DETAILS_PVT.Purge_Cost
915: (
916: p_api_version_number => '1.0'
917: , p_init_msg_list => FND_API.G_FALSE
918: , p_commit => FND_API.G_FALSE
919: , p_processing_set_id => p_processing_set_id
920: , p_object_type => p_object_type
921: , x_return_status => x_return_status
922: , x_msg_count => x_msg_count

Line 951: IF x_return_status = FND_API.G_RET_STS_SUCCESS

947:
948: ---
949:
950:
951: IF x_return_status = FND_API.G_RET_STS_SUCCESS
952: THEN
953: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
954: THEN
955: fnd_log.string

Line 969: , p_init_msg_list => FND_API.G_FALSE

965:
966: CS_MESSAGES_PKG.Delete_Message
967: (
968: p_api_version_number => '1.0'
969: , p_init_msg_list => FND_API.G_FALSE
970: , p_commit => FND_API.G_FALSE
971: , p_processing_set_id => p_processing_set_id
972: , p_object_type => p_object_type
973: , x_return_status => x_return_status

Line 970: , p_commit => FND_API.G_FALSE

966: CS_MESSAGES_PKG.Delete_Message
967: (
968: p_api_version_number => '1.0'
969: , p_init_msg_list => FND_API.G_FALSE
970: , p_commit => FND_API.G_FALSE
971: , p_processing_set_id => p_processing_set_id
972: , p_object_type => p_object_type
973: , x_return_status => x_return_status
974: , x_msg_count => x_msg_count

Line 996: IF x_return_status = FND_API.G_RET_STS_SUCCESS

992: Check_User_Termination;
993:
994: ---
995:
996: IF x_return_status = FND_API.G_RET_STS_SUCCESS
997: THEN
998: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
999: THEN
1000: fnd_log.string

Line 1017: , p_init_msg_list => FND_API.G_FALSE

1013:
1014: CS_SR_DELETE_UTIL.Delete_Contacts
1015: (
1016: p_api_version_number => '1.0'
1017: , p_init_msg_list => FND_API.G_FALSE
1018: , p_commit => FND_API.G_FALSE
1019: , p_processing_set_id => p_processing_set_id
1020: , p_object_type => p_object_type
1021: , x_return_status => x_return_status

Line 1018: , p_commit => FND_API.G_FALSE

1014: CS_SR_DELETE_UTIL.Delete_Contacts
1015: (
1016: p_api_version_number => '1.0'
1017: , p_init_msg_list => FND_API.G_FALSE
1018: , p_commit => FND_API.G_FALSE
1019: , p_processing_set_id => p_processing_set_id
1020: , p_object_type => p_object_type
1021: , x_return_status => x_return_status
1022: , x_msg_count => x_msg_count

Line 1044: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1040: Check_User_Termination;
1041:
1042: ---
1043:
1044: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1045: THEN
1046: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1047: THEN
1048: fnd_log.string

Line 1064: , p_init_msg_list => FND_API.G_FALSE

1060:
1061: CS_SR_DELETE_UTIL.Delete_Sr_Attributes
1062: (
1063: p_api_version_number => '1.0'
1064: , p_init_msg_list => FND_API.G_FALSE
1065: , p_commit => FND_API.G_FALSE
1066: , p_processing_set_id => p_processing_set_id
1067: , p_object_type => p_object_type
1068: , x_return_status => x_return_status

Line 1065: , p_commit => FND_API.G_FALSE

1061: CS_SR_DELETE_UTIL.Delete_Sr_Attributes
1062: (
1063: p_api_version_number => '1.0'
1064: , p_init_msg_list => FND_API.G_FALSE
1065: , p_commit => FND_API.G_FALSE
1066: , p_processing_set_id => p_processing_set_id
1067: , p_object_type => p_object_type
1068: , x_return_status => x_return_status
1069: , x_msg_count => x_msg_count

Line 1091: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1087: Check_User_Termination;
1088:
1089: ---
1090:
1091: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1092: THEN
1093: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1094: THEN
1095: fnd_log.string

Line 1110: , p_init_msg_list => FND_API.G_FALSE

1106:
1107: CS_SR_DELETE_UTIL.Delete_Audit_Records
1108: (
1109: p_api_version_number => '1.0'
1110: , p_init_msg_list => FND_API.G_FALSE
1111: , p_commit => FND_API.G_FALSE
1112: , p_processing_set_id => p_processing_set_id
1113: , p_object_type => p_object_type
1114: , x_return_status => x_return_status

Line 1111: , p_commit => FND_API.G_FALSE

1107: CS_SR_DELETE_UTIL.Delete_Audit_Records
1108: (
1109: p_api_version_number => '1.0'
1110: , p_init_msg_list => FND_API.G_FALSE
1111: , p_commit => FND_API.G_FALSE
1112: , p_processing_set_id => p_processing_set_id
1113: , p_object_type => p_object_type
1114: , x_return_status => x_return_status
1115: , x_msg_count => x_msg_count

Line 1137: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1133: Check_User_Termination;
1134:
1135: ---
1136:
1137: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1138: THEN
1139: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1140: THEN
1141: fnd_log.string

Line 1156: , p_init_msg_list => FND_API.G_FALSE

1152:
1153: CS_INCIDENTLINKS_PVT.Delete_IncidentLink
1154: (
1155: p_api_version_number => '1.0'
1156: , p_init_msg_list => FND_API.G_FALSE
1157: , p_commit => FND_API.G_FALSE
1158: , p_processing_set_id => p_processing_set_id
1159: , p_object_type => p_object_type
1160: , x_return_status => x_return_status

Line 1157: , p_commit => FND_API.G_FALSE

1153: CS_INCIDENTLINKS_PVT.Delete_IncidentLink
1154: (
1155: p_api_version_number => '1.0'
1156: , p_init_msg_list => FND_API.G_FALSE
1157: , p_commit => FND_API.G_FALSE
1158: , p_processing_set_id => p_processing_set_id
1159: , p_object_type => p_object_type
1160: , x_return_status => x_return_status
1161: , x_msg_count => x_msg_count

Line 1183: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1179: Check_User_Termination;
1180:
1181: ---
1182:
1183: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1184: THEN
1185: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1186: THEN
1187: fnd_log.string

Line 1202: , p_init_msg_list => FND_API.G_FALSE

1198:
1199: CS_KNOWLEDGE_GRP.Purge_Knowledge_Links
1200: (
1201: p_api_version => '1.0'
1202: , p_init_msg_list => FND_API.G_FALSE
1203: , p_commit => FND_API.G_FALSE
1204: , p_processing_set_id => p_processing_set_id
1205: , p_object_type => p_object_type
1206: , x_return_status => x_return_status

Line 1203: , p_commit => FND_API.G_FALSE

1199: CS_KNOWLEDGE_GRP.Purge_Knowledge_Links
1200: (
1201: p_api_version => '1.0'
1202: , p_init_msg_list => FND_API.G_FALSE
1203: , p_commit => FND_API.G_FALSE
1204: , p_processing_set_id => p_processing_set_id
1205: , p_object_type => p_object_type
1206: , x_return_status => x_return_status
1207: , x_msg_count => x_msg_count

Line 1229: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1225: Check_User_Termination;
1226:
1227: ---
1228:
1229: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1230: THEN
1231: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1232: THEN
1233: fnd_log.string

Line 1247: , p_init_msg_list => FND_API.G_FALSE

1243:
1244: CAC_NOTE_PURGE_PUB.Purge_Notes
1245: (
1246: p_api_version => '1.0'
1247: , p_init_msg_list => FND_API.G_FALSE
1248: , p_commit => FND_API.G_FALSE
1249: , p_processing_set_id => p_processing_set_id
1250: , p_object_type => p_object_type
1251: , x_return_status => x_return_status

Line 1248: , p_commit => FND_API.G_FALSE

1244: CAC_NOTE_PURGE_PUB.Purge_Notes
1245: (
1246: p_api_version => '1.0'
1247: , p_init_msg_list => FND_API.G_FALSE
1248: , p_commit => FND_API.G_FALSE
1249: , p_processing_set_id => p_processing_set_id
1250: , p_object_type => p_object_type
1251: , x_return_status => x_return_status
1252: , x_msg_count => x_msg_count

Line 1273: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1269: Check_User_Termination;
1270:
1271: ---
1272:
1273: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1274: THEN
1275: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1276: THEN
1277: fnd_log.string

Line 1291: , p_init_msg_list => FND_API.G_FALSE

1287:
1288: CAC_TASK_PURGE_PUB.Purge_Tasks
1289: (
1290: p_api_version => '1.0'
1291: , p_init_msg_list => FND_API.G_FALSE
1292: , p_commit => FND_API.G_FALSE
1293: , p_processing_set_id => p_processing_set_id
1294: , p_object_type => p_object_type
1295: , x_return_status => x_return_status

Line 1292: , p_commit => FND_API.G_FALSE

1288: CAC_TASK_PURGE_PUB.Purge_Tasks
1289: (
1290: p_api_version => '1.0'
1291: , p_init_msg_list => FND_API.G_FALSE
1292: , p_commit => FND_API.G_FALSE
1293: , p_processing_set_id => p_processing_set_id
1294: , p_object_type => p_object_type
1295: , x_return_status => x_return_status
1296: , x_msg_count => x_msg_count

Line 1317: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1313: Check_User_Termination;
1314:
1315: ---
1316:
1317: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1318: THEN
1319: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1320: THEN
1321: fnd_log.string

Line 1335: , p_init_msg_list => FND_API.G_FALSE

1331:
1332: IEU_WR_PUB.Purge_Wr_Item
1333: (
1334: p_api_version_number => '1.0'
1335: , p_init_msg_list => FND_API.G_FALSE
1336: , p_commit => FND_API.G_FALSE
1337: , p_processing_set_id => p_processing_set_id
1338: , p_object_type => p_object_type
1339: , x_return_status => x_return_status

Line 1336: , p_commit => FND_API.G_FALSE

1332: IEU_WR_PUB.Purge_Wr_Item
1333: (
1334: p_api_version_number => '1.0'
1335: , p_init_msg_list => FND_API.G_FALSE
1336: , p_commit => FND_API.G_FALSE
1337: , p_processing_set_id => p_processing_set_id
1338: , p_object_type => p_object_type
1339: , x_return_status => x_return_status
1340: , x_msg_count => x_msg_count

Line 1362: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1358: Check_User_Termination;
1359:
1360: ---
1361:
1362: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1363: THEN
1364: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1365: THEN
1366: fnd_log.string

Line 1381: , p_init_msg_list => FND_API.G_FALSE

1377:
1378: JTF_IH_PURGE.P_Delete_Interactions
1379: (
1380: p_api_version => '1.0'
1381: , p_init_msg_list => FND_API.G_FALSE
1382: , p_commit => FND_API.G_FALSE
1383: , p_processing_set_id => p_processing_set_id
1384: , p_object_type => p_object_type
1385: , x_return_status => x_return_status

Line 1382: , p_commit => FND_API.G_FALSE

1378: JTF_IH_PURGE.P_Delete_Interactions
1379: (
1380: p_api_version => '1.0'
1381: , p_init_msg_list => FND_API.G_FALSE
1382: , p_commit => FND_API.G_FALSE
1383: , p_processing_set_id => p_processing_set_id
1384: , p_object_type => p_object_type
1385: , x_return_status => x_return_status
1386: , x_msg_count => x_msg_count

Line 1408: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1404: Check_User_Termination;
1405:
1406: ---
1407:
1408: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1409: THEN
1410: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1411: THEN
1412: fnd_log.string

Line 1456: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1452: Check_User_Termination;
1453:
1454: ---
1455:
1456: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1457: THEN
1458: IF l_incident_id_tbl.COUNT > 0
1459: THEN
1460: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

Line 1522: AND x_return_status = FND_API.G_RET_STS_SUCCESS

1518:
1519: ---
1520:
1521: IF p_audit_required = 'Y'
1522: AND x_return_status = FND_API.G_RET_STS_SUCCESS
1523:
1524: -- If audit information is required as per profile option
1525: -- CS_SR_PURGE_AUDIT_REQUIRED, then proceed further
1526:

Line 1657: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1653: Check_User_Termination;
1654:
1655: ---
1656:
1657: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1658: THEN
1659: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1660: THEN
1661: fnd_log.string

Line 1712: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1708: Check_User_Termination;
1709:
1710: ---
1711:
1712: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1713: THEN
1714: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1715: THEN
1716: fnd_log.string

Line 1765: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1761: Check_User_Termination;
1762:
1763: ---
1764:
1765: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1766: THEN
1767: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1768: THEN
1769: fnd_log.string

Line 1818: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1814: Check_User_Termination;
1815:
1816: ---
1817:
1818: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1819: THEN
1820: IF l_incident_id_status_tbl.COUNT > 0
1821:
1822: -- If there are any SRs with purge_status E indicating

Line 1883: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1879: Check_User_Termination;
1880:
1881: ---
1882:
1883: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1884: THEN
1885: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1886: THEN
1887: fnd_log.string

Line 1940: IF x_return_status = FND_API.G_RET_STS_SUCCESS

1936: Check_User_Termination;
1937:
1938: ---
1939:
1940: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1941: AND p_audit_required = 'Y'
1942:
1943: -- If audit information is required as per profile option
1944: -- CS_SR_PURGE_AUDIT_REQUIRED, then proceed further

Line 1967: , p_init_msg_list => FND_API.G_FALSE

1963:
1964: Create_Purgeaudit_Records
1965: (
1966: p_api_version_number => '1.0'
1967: , p_init_msg_list => FND_API.G_FALSE
1968: , p_commit => FND_API.G_FALSE
1969: , p_purge_set_id => l_purge_set_id
1970: , p_incident_id_tbl => l_incident_id_tbl
1971: , p_incident_number_tbl => l_incident_number_tbl

Line 1968: , p_commit => FND_API.G_FALSE

1964: Create_Purgeaudit_Records
1965: (
1966: p_api_version_number => '1.0'
1967: , p_init_msg_list => FND_API.G_FALSE
1968: , p_commit => FND_API.G_FALSE
1969: , p_purge_set_id => l_purge_set_id
1970: , p_incident_id_tbl => l_incident_id_tbl
1971: , p_incident_number_tbl => l_incident_number_tbl
1972: , p_incident_type_id_tbl => l_incident_type_id_tbl

Line 2019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2015: END IF ;
2016:
2017: EXCEPTION
2018:
2019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2021:
2022: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2023: THEN

Line 2020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2016:
2017: EXCEPTION
2018:
2019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2021:
2022: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2023: THEN
2024: fnd_log.string

Line 2028: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL

2024: fnd_log.string
2025: (
2026: fnd_log.level_unexpected
2027: , L_LOG_MODULE || 'unexpected_error'
2028: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2029: );
2030:
2031: x_msg_count := FND_MSG_PUB.Count_Msg;
2032:

Line 2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2053: END IF ;
2054: END IF ;
2055:
2056: WHEN OTHERS THEN
2057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2058: FND_MESSAGE.Set_Name('CS', 'CS_SR_DEL_FAIL');
2059: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2060: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2061: FND_MSG_PUB.ADD;

Line 2121: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2117: */
2118: PROCEDURE Delete_Contacts
2119: (
2120: p_api_version_number IN NUMBER := 1.0
2121: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2122: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2123: , p_object_type IN VARCHAR2
2124: , p_processing_set_id IN NUMBER
2125: , x_return_status OUT NOCOPY VARCHAR2

Line 2122: , p_commit IN VARCHAR2 := FND_API.G_FALSE

2118: PROCEDURE Delete_Contacts
2119: (
2120: p_api_version_number IN NUMBER := 1.0
2121: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2122: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2123: , p_object_type IN VARCHAR2
2124: , p_processing_set_id IN NUMBER
2125: , x_return_status OUT NOCOPY VARCHAR2
2126: , x_msg_count OUT NOCOPY NUMBER

Line 2139: x_return_status := FND_API.G_RET_STS_SUCCESS;

2135:
2136: l_row_count NUMBER := 0;
2137:
2138: BEGIN
2139: x_return_status := FND_API.G_RET_STS_SUCCESS;
2140:
2141: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2142: THEN
2143: fnd_log.string

Line 2181: IF NOT FND_API.Compatible_API_Call

2177: , 'p_processing_set_id:' || p_processing_set_id
2178: );
2179: END IF ;
2180:
2181: IF NOT FND_API.Compatible_API_Call
2182: (
2183: L_API_VERSION
2184: , p_api_version_number
2185: , L_API_NAME

Line 2194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2190: (
2191: p_count => x_msg_count
2192: , p_data => x_msg_data
2193: );
2194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2195: END IF ;
2196:
2197: IF
2198: FND_API.to_Boolean(p_init_msg_list)

Line 2198: FND_API.to_Boolean(p_init_msg_list)

2194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2195: END IF ;
2196:
2197: IF
2198: FND_API.to_Boolean(p_init_msg_list)
2199: THEN
2200: FND_MSG_PUB.initialize;
2201: END IF ;
2202:

Line 2433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2429: END IF ;
2430:
2431: EXCEPTION
2432:
2433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2435:
2436: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2437: THEN

Line 2434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2430:
2431: EXCEPTION
2432:
2433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2435:
2436: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2437: THEN
2438: fnd_log.string

Line 2442: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL

2438: fnd_log.string
2439: (
2440: fnd_log.level_unexpected
2441: , L_LOG_MODULE || 'unexpected_error'
2442: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2443: );
2444: END IF ;
2445:
2446: WHEN OTHERS THEN

Line 2447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2443: );
2444: END IF ;
2445:
2446: WHEN OTHERS THEN
2447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2448: FND_MESSAGE.Set_Name('CS', 'CS_SR_CONT_DEL_FAIL');
2449: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2450: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2451: FND_MSG_PUB.ADD;

Line 2508: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2504: */
2505: PROCEDURE Delete_Audit_Records
2506: (
2507: p_api_version_number IN NUMBER := 1.0
2508: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2509: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2510: , p_object_type IN VARCHAR2
2511: , p_processing_set_id IN NUMBER
2512: , x_return_status OUT NOCOPY VARCHAR2

Line 2509: , p_commit IN VARCHAR2 := FND_API.G_FALSE

2505: PROCEDURE Delete_Audit_Records
2506: (
2507: p_api_version_number IN NUMBER := 1.0
2508: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2509: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2510: , p_object_type IN VARCHAR2
2511: , p_processing_set_id IN NUMBER
2512: , x_return_status OUT NOCOPY VARCHAR2
2513: , x_msg_count OUT NOCOPY NUMBER

Line 2526: x_return_status := FND_API.G_RET_STS_SUCCESS;

2522:
2523: l_row_count NUMBER;
2524:
2525: BEGIN
2526: x_return_status := FND_API.G_RET_STS_SUCCESS;
2527:
2528: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2529: THEN
2530: fnd_log.string

Line 2568: IF NOT FND_API.Compatible_API_Call

2564: , 'p_processing_set_id:' || p_processing_set_id
2565: );
2566: END IF ;
2567:
2568: IF NOT FND_API.Compatible_API_Call
2569: (
2570: L_API_VERSION
2571: , p_api_version_number
2572: , L_API_NAME

Line 2581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2577: (
2578: p_count => x_msg_count
2579: , p_data => x_msg_data
2580: );
2581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2582: END IF ;
2583:
2584: IF
2585: FND_API.to_Boolean(p_init_msg_list)

Line 2585: FND_API.to_Boolean(p_init_msg_list)

2581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2582: END IF ;
2583:
2584: IF
2585: FND_API.to_Boolean(p_init_msg_list)
2586: THEN
2587: FND_MSG_PUB.initialize;
2588: END IF ;
2589:

Line 2689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2685: END IF ;
2686:
2687: EXCEPTION
2688:
2689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2691:
2692: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2693: THEN

Line 2690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2686:
2687: EXCEPTION
2688:
2689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2691:
2692: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2693: THEN
2694: fnd_log.string

Line 2698: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL

2694: fnd_log.string
2695: (
2696: fnd_log.level_unexpected
2697: , L_LOG_MODULE || 'unexpected_error'
2698: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2699: );
2700: END IF ;
2701:
2702: WHEN OTHERS THEN

Line 2703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2699: );
2700: END IF ;
2701:
2702: WHEN OTHERS THEN
2703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2704: FND_MESSAGE.Set_Name('CS', 'CS_SR_AUDIT_DEL_FAIL');
2705: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2706: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2707: FND_MSG_PUB.ADD;

Line 2765: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2761: */
2762: PROCEDURE Delete_Sr_Attributes
2763: (
2764: p_api_version_number IN NUMBER
2765: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2766: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2767: , p_object_type IN VARCHAR2
2768: , p_processing_set_id IN NUMBER
2769: , x_return_status OUT NOCOPY VARCHAR2

Line 2766: , p_commit IN VARCHAR2 := FND_API.G_FALSE

2762: PROCEDURE Delete_Sr_Attributes
2763: (
2764: p_api_version_number IN NUMBER
2765: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2766: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2767: , p_object_type IN VARCHAR2
2768: , p_processing_set_id IN NUMBER
2769: , x_return_status OUT NOCOPY VARCHAR2
2770: , x_msg_count OUT NOCOPY NUMBER

Line 2783: x_return_status := FND_API.G_RET_STS_SUCCESS;

2779:
2780: l_row_count NUMBER;
2781:
2782: BEGIN
2783: x_return_status := FND_API.G_RET_STS_SUCCESS;
2784:
2785: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2786: THEN
2787: fnd_log.string

Line 2825: IF NOT FND_API.Compatible_API_Call

2821: , 'p_processing_set_id:' || p_processing_set_id
2822: );
2823: END IF ;
2824:
2825: IF NOT FND_API.Compatible_API_Call
2826: (
2827: L_API_VERSION
2828: , p_api_version_number
2829: , L_API_NAME

Line 2838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2834: (
2835: p_count => x_msg_count
2836: , p_data => x_msg_data
2837: );
2838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2839: END IF ;
2840:
2841: IF
2842: FND_API.to_Boolean(p_init_msg_list)

Line 2842: FND_API.to_Boolean(p_init_msg_list)

2838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2839: END IF ;
2840:
2841: IF
2842: FND_API.to_Boolean(p_init_msg_list)
2843: THEN
2844: FND_MSG_PUB.initialize;
2845: END IF ;
2846:

Line 3076: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3072: END IF ;
3073:
3074: EXCEPTION
3075:
3076: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3078:
3079: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3080: THEN

Line 3077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3073:
3074: EXCEPTION
3075:
3076: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3078:
3079: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3080: THEN
3081: fnd_log.string

Line 3085: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL

3081: fnd_log.string
3082: (
3083: fnd_log.level_unexpected
3084: , L_LOG_MODULE || 'unexpected_error'
3085: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
3086: );
3087: END IF ;
3088:
3089: WHEN OTHERS THEN

Line 3090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3086: );
3087: END IF ;
3088:
3089: WHEN OTHERS THEN
3090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3091: FND_MESSAGE.Set_Name('CS', 'CS_SR_ATTR_VAL_DEL_FAIL');
3092: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
3093: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
3094: FND_MSG_PUB.ADD;

Line 3215: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

3211: */
3212: PROCEDURE Create_Purgeaudit_Records
3213: (
3214: p_api_version_number IN NUMBER := 1.0
3215: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3216: , p_commit IN VARCHAR2 := FND_API.G_FALSE
3217: , p_purge_set_id IN NUMBER
3218: , p_incident_id_tbl IN t_number_tbl
3219: , p_incident_number_tbl IN t_long_string_tbl

Line 3216: , p_commit IN VARCHAR2 := FND_API.G_FALSE

3212: PROCEDURE Create_Purgeaudit_Records
3213: (
3214: p_api_version_number IN NUMBER := 1.0
3215: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3216: , p_commit IN VARCHAR2 := FND_API.G_FALSE
3217: , p_purge_set_id IN NUMBER
3218: , p_incident_id_tbl IN t_number_tbl
3219: , p_incident_number_tbl IN t_long_string_tbl
3220: , p_incident_type_id_tbl IN t_number_tbl

Line 3248: x_return_status := FND_API.G_RET_STS_SUCCESS;

3244:
3245: l_row_count NUMBER;
3246:
3247: BEGIN
3248: x_return_status := FND_API.G_RET_STS_SUCCESS;
3249:
3250: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3251: THEN
3252: fnd_log.string

Line 3287: IF NOT FND_API.Compatible_API_Call

3283:
3284: l_user_id := fnd_global.user_id;
3285: l_login_id := fnd_global.login_id;
3286:
3287: IF NOT FND_API.Compatible_API_Call
3288: (
3289: L_API_VERSION
3290: , p_api_version_number
3291: , L_API_NAME

Line 3300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3296: (
3297: p_count => x_msg_count
3298: , p_data => x_msg_data
3299: );
3300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3301: END IF ;
3302:
3303: IF FND_API.to_Boolean(p_init_msg_list)
3304: THEN

Line 3303: IF FND_API.to_Boolean(p_init_msg_list)

3299: );
3300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3301: END IF ;
3302:
3303: IF FND_API.to_Boolean(p_init_msg_list)
3304: THEN
3305: FND_MSG_PUB.initialize;
3306: END IF ;
3307:

Line 3476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3472: END IF ;
3473:
3474: EXCEPTION
3475:
3476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3478:
3479: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3480: THEN

Line 3477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3473:
3474: EXCEPTION
3475:
3476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3478:
3479: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3480: THEN
3481: fnd_log.string

Line 3485: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL

3481: fnd_log.string
3482: (
3483: fnd_log.level_unexpected
3484: , L_LOG_MODULE || 'unexpected_error'
3485: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
3486: );
3487: END IF ;
3488:
3489: WHEN OTHERS THEN

Line 3490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3486: );
3487: END IF ;
3488:
3489: WHEN OTHERS THEN
3490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3491: FND_MESSAGE.Set_Name('CS', 'CS_SR_PRG_CRT_FAIL');
3492: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
3493: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
3494: FND_MSG_PUB.ADD;

Line 3606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3602: (
3603: request_data => 'T'
3604: );
3605:
3606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3607: END IF;
3608: ELSE
3609: -- if fnd_concurrent.get_request_status failed...
3610: