[Home] [Help]
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
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
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
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
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
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
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
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
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
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
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
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
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
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:
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:
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:
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:
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
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
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
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
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
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
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
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
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
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
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
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:
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;
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
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
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
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
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)
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:
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:
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:
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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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:
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
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
1762: Check_User_Termination;
1763:
1764: ---
1765:
1766: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1767: THEN
1768: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1769: THEN
1770: fnd_log.string
1816: Check_User_Termination;
1817:
1818: ---
1819:
1820: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1821: THEN
1822: IF l_incident_id_status_tbl.COUNT > 0
1823:
1824: -- If there are any SRs with purge_status E indicating
1881: Check_User_Termination;
1882:
1883: ---
1884:
1885: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1886: THEN
1887: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1888: THEN
1889: fnd_log.string
1938: Check_User_Termination;
1939:
1940: ---
1941:
1942: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1943: AND p_audit_required = 'Y'
1944:
1945: -- If audit information is required as per profile option
1946: -- CS_SR_PURGE_AUDIT_REQUIRED, then proceed further
1965:
1966: Create_Purgeaudit_Records
1967: (
1968: p_api_version_number => 1.0
1969: , p_init_msg_list => FND_API.G_FALSE
1970: , p_commit => FND_API.G_FALSE
1971: , p_purge_set_id => l_purge_set_id
1972: , p_incident_id_tbl => l_incident_id_tbl
1973: , p_incident_number_tbl => l_incident_number_tbl
1966: Create_Purgeaudit_Records
1967: (
1968: p_api_version_number => 1.0
1969: , p_init_msg_list => FND_API.G_FALSE
1970: , p_commit => FND_API.G_FALSE
1971: , p_purge_set_id => l_purge_set_id
1972: , p_incident_id_tbl => l_incident_id_tbl
1973: , p_incident_number_tbl => l_incident_number_tbl
1974: , p_incident_type_id_tbl => l_incident_type_id_tbl
2017: END IF ;
2018:
2019: EXCEPTION
2020:
2021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2023:
2024: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2025: THEN
2018:
2019: EXCEPTION
2020:
2021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2023:
2024: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2025: THEN
2026: fnd_log.string
2026: fnd_log.string
2027: (
2028: fnd_log.level_unexpected
2029: , L_LOG_MODULE || 'unexpected_error'
2030: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2031: );
2032:
2033: x_msg_count := FND_MSG_PUB.Count_Msg;
2034:
2055: END IF ;
2056: END IF ;
2057:
2058: WHEN OTHERS THEN
2059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2060: FND_MESSAGE.Set_Name('CS', 'CS_SR_DEL_FAIL');
2061: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2062: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2063: FND_MSG_PUB.ADD;
2119: */
2120: PROCEDURE Delete_Contacts
2121: (
2122: p_api_version_number IN NUMBER := 1.0
2123: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2124: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2125: , p_object_type IN VARCHAR2
2126: , p_processing_set_id IN NUMBER
2127: , x_return_status OUT NOCOPY VARCHAR2
2120: PROCEDURE Delete_Contacts
2121: (
2122: p_api_version_number IN NUMBER := 1.0
2123: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2124: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2125: , p_object_type IN VARCHAR2
2126: , p_processing_set_id IN NUMBER
2127: , x_return_status OUT NOCOPY VARCHAR2
2128: , x_msg_count OUT NOCOPY NUMBER
2137:
2138: l_row_count NUMBER := 0;
2139:
2140: BEGIN
2141: x_return_status := FND_API.G_RET_STS_SUCCESS;
2142:
2143: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2144: THEN
2145: fnd_log.string
2179: , 'p_processing_set_id:' || p_processing_set_id
2180: );
2181: END IF ;
2182:
2183: IF NOT FND_API.Compatible_API_Call
2184: (
2185: L_API_VERSION
2186: , p_api_version_number
2187: , L_API_NAME
2192: (
2193: p_count => x_msg_count
2194: , p_data => x_msg_data
2195: );
2196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2197: END IF ;
2198:
2199: IF
2200: FND_API.to_Boolean(p_init_msg_list)
2196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2197: END IF ;
2198:
2199: IF
2200: FND_API.to_Boolean(p_init_msg_list)
2201: THEN
2202: FND_MSG_PUB.initialize;
2203: END IF ;
2204:
2432: END IF ;
2433:
2434: EXCEPTION
2435:
2436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2438:
2439: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2440: THEN
2433:
2434: EXCEPTION
2435:
2436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2438:
2439: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2440: THEN
2441: fnd_log.string
2441: fnd_log.string
2442: (
2443: fnd_log.level_unexpected
2444: , L_LOG_MODULE || 'unexpected_error'
2445: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2446: );
2447: END IF ;
2448:
2449: WHEN OTHERS THEN
2446: );
2447: END IF ;
2448:
2449: WHEN OTHERS THEN
2450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2451: FND_MESSAGE.Set_Name('CS', 'CS_SR_CONT_DEL_FAIL');
2452: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2453: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2454: FND_MSG_PUB.ADD;
2507: */
2508: PROCEDURE Delete_Audit_Records
2509: (
2510: p_api_version_number IN NUMBER := 1.0
2511: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2512: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2513: , p_object_type IN VARCHAR2
2514: , p_processing_set_id IN NUMBER
2515: , x_return_status OUT NOCOPY VARCHAR2
2508: PROCEDURE Delete_Audit_Records
2509: (
2510: p_api_version_number IN NUMBER := 1.0
2511: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2512: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2513: , p_object_type IN VARCHAR2
2514: , p_processing_set_id IN NUMBER
2515: , x_return_status OUT NOCOPY VARCHAR2
2516: , x_msg_count OUT NOCOPY NUMBER
2525:
2526: l_row_count NUMBER;
2527:
2528: BEGIN
2529: x_return_status := FND_API.G_RET_STS_SUCCESS;
2530:
2531: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2532: THEN
2533: fnd_log.string
2567: , 'p_processing_set_id:' || p_processing_set_id
2568: );
2569: END IF ;
2570:
2571: IF NOT FND_API.Compatible_API_Call
2572: (
2573: L_API_VERSION
2574: , p_api_version_number
2575: , L_API_NAME
2580: (
2581: p_count => x_msg_count
2582: , p_data => x_msg_data
2583: );
2584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2585: END IF ;
2586:
2587: IF
2588: FND_API.to_Boolean(p_init_msg_list)
2584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2585: END IF ;
2586:
2587: IF
2588: FND_API.to_Boolean(p_init_msg_list)
2589: THEN
2590: FND_MSG_PUB.initialize;
2591: END IF ;
2592:
2689: END IF ;
2690:
2691: EXCEPTION
2692:
2693: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2695:
2696: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2697: THEN
2690:
2691: EXCEPTION
2692:
2693: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2695:
2696: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2697: THEN
2698: fnd_log.string
2698: fnd_log.string
2699: (
2700: fnd_log.level_unexpected
2701: , L_LOG_MODULE || 'unexpected_error'
2702: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2703: );
2704: END IF ;
2705:
2706: WHEN OTHERS THEN
2703: );
2704: END IF ;
2705:
2706: WHEN OTHERS THEN
2707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2708: FND_MESSAGE.Set_Name('CS', 'CS_SR_AUDIT_DEL_FAIL');
2709: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2710: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2711: FND_MSG_PUB.ADD;
2765: */
2766: PROCEDURE Delete_Sr_Attributes
2767: (
2768: p_api_version_number IN NUMBER
2769: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2770: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2771: , p_object_type IN VARCHAR2
2772: , p_processing_set_id IN NUMBER
2773: , x_return_status OUT NOCOPY VARCHAR2
2766: PROCEDURE Delete_Sr_Attributes
2767: (
2768: p_api_version_number IN NUMBER
2769: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2770: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2771: , p_object_type IN VARCHAR2
2772: , p_processing_set_id IN NUMBER
2773: , x_return_status OUT NOCOPY VARCHAR2
2774: , x_msg_count OUT NOCOPY NUMBER
2783:
2784: l_row_count NUMBER;
2785:
2786: BEGIN
2787: x_return_status := FND_API.G_RET_STS_SUCCESS;
2788:
2789: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2790: THEN
2791: fnd_log.string
2825: , 'p_processing_set_id:' || p_processing_set_id
2826: );
2827: END IF ;
2828:
2829: IF NOT FND_API.Compatible_API_Call
2830: (
2831: L_API_VERSION
2832: , p_api_version_number
2833: , L_API_NAME
2838: (
2839: p_count => x_msg_count
2840: , p_data => x_msg_data
2841: );
2842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2843: END IF ;
2844:
2845: IF
2846: FND_API.to_Boolean(p_init_msg_list)
2842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2843: END IF ;
2844:
2845: IF
2846: FND_API.to_Boolean(p_init_msg_list)
2847: THEN
2848: FND_MSG_PUB.initialize;
2849: END IF ;
2850:
3076: END IF ;
3077:
3078: EXCEPTION
3079:
3080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3082:
3083: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3084: THEN
3077:
3078: EXCEPTION
3079:
3080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3082:
3083: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3084: THEN
3085: fnd_log.string
3085: fnd_log.string
3086: (
3087: fnd_log.level_unexpected
3088: , L_LOG_MODULE || 'unexpected_error'
3089: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
3090: );
3091: END IF ;
3092:
3093: WHEN OTHERS THEN
3090: );
3091: END IF ;
3092:
3093: WHEN OTHERS THEN
3094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3095: FND_MESSAGE.Set_Name('CS', 'CS_SR_ATTR_VAL_DEL_FAIL');
3096: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
3097: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
3098: FND_MSG_PUB.ADD;
3215: */
3216: PROCEDURE Create_Purgeaudit_Records
3217: (
3218: p_api_version_number IN NUMBER := 1.0
3219: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3220: , p_commit IN VARCHAR2 := FND_API.G_FALSE
3221: , p_purge_set_id IN NUMBER
3222: , p_incident_id_tbl IN t_number_tbl
3223: , p_incident_number_tbl IN t_long_string_tbl
3216: PROCEDURE Create_Purgeaudit_Records
3217: (
3218: p_api_version_number IN NUMBER := 1.0
3219: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3220: , p_commit IN VARCHAR2 := FND_API.G_FALSE
3221: , p_purge_set_id IN NUMBER
3222: , p_incident_id_tbl IN t_number_tbl
3223: , p_incident_number_tbl IN t_long_string_tbl
3224: , p_incident_type_id_tbl IN t_number_tbl
3248:
3249: l_row_count NUMBER;
3250:
3251: BEGIN
3252: x_return_status := FND_API.G_RET_STS_SUCCESS;
3253:
3254: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3255: THEN
3256: fnd_log.string
3287:
3288: l_user_id := fnd_global.user_id;
3289: l_login_id := fnd_global.login_id;
3290:
3291: IF NOT FND_API.Compatible_API_Call
3292: (
3293: L_API_VERSION
3294: , p_api_version_number
3295: , L_API_NAME
3300: (
3301: p_count => x_msg_count
3302: , p_data => x_msg_data
3303: );
3304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3305: END IF ;
3306:
3307: IF FND_API.to_Boolean(p_init_msg_list)
3308: THEN
3303: );
3304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3305: END IF ;
3306:
3307: IF FND_API.to_Boolean(p_init_msg_list)
3308: THEN
3309: FND_MSG_PUB.initialize;
3310: END IF ;
3311:
3476: END IF ;
3477:
3478: EXCEPTION
3479:
3480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3482:
3483: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3484: THEN
3477:
3478: EXCEPTION
3479:
3480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3482:
3483: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3484: THEN
3485: fnd_log.string
3485: fnd_log.string
3486: (
3487: fnd_log.level_unexpected
3488: , L_LOG_MODULE || 'unexpected_error'
3489: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
3490: );
3491: END IF ;
3492:
3493: WHEN OTHERS THEN
3490: );
3491: END IF ;
3492:
3493: WHEN OTHERS THEN
3494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3495: FND_MESSAGE.Set_Name('CS', 'CS_SR_PRG_CRT_FAIL');
3496: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
3497: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
3498: FND_MSG_PUB.ADD;
3606: (
3607: request_data => 'T'
3608: );
3609:
3610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3611: END IF;
3612: ELSE
3613: -- if fnd_concurrent.get_request_status failed...
3614: