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.CAC_TASK_PURGE_PVT dependencies on FND_API

Line 56: p_delete_closed_task_only IN VARCHAR2 DEFAULT fnd_api.g_false ,

52: p_actual_end_date_from IN VARCHAR2 ,
53: p_actual_end_date_to IN VARCHAR2 ,
54: p_task_type_id IN NUMBER DEFAULT NULL ,
55: p_task_status_id IN NUMBER DEFAULT NULL ,
56: p_delete_closed_task_only IN VARCHAR2 DEFAULT fnd_api.g_false ,
57: p_delete_deleted_task_only IN VARCHAR2 DEFAULT fnd_api.g_false,
58: p_no_of_worker IN NUMBER DEFAULT 4 )
59: IS
60: l_api_version CONSTANT NUMBER := 1.0;

Line 57: p_delete_deleted_task_only IN VARCHAR2 DEFAULT fnd_api.g_false,

53: p_actual_end_date_to IN VARCHAR2 ,
54: p_task_type_id IN NUMBER DEFAULT NULL ,
55: p_task_status_id IN NUMBER DEFAULT NULL ,
56: p_delete_closed_task_only IN VARCHAR2 DEFAULT fnd_api.g_false ,
57: p_delete_deleted_task_only IN VARCHAR2 DEFAULT fnd_api.g_false,
58: p_no_of_worker IN NUMBER DEFAULT 4 )
59: IS
60: l_api_version CONSTANT NUMBER := 1.0;
61: l_api_name CONSTANT VARCHAR2(30) := 'PURGE_STANDALONE_TASKS';

Line 131: IF NOT fnd_api.compatible_api_call (

127: BEGIN
128:
129: SAVEPOINT purge_standalone_tasks;
130:
131: IF NOT fnd_api.compatible_api_call (
132: l_api_version,
133: l_api_version,
134: l_api_name,
135: g_pkg_name

Line 138: RAISE fnd_api.g_exc_unexpected_error;

134: l_api_name,
135: g_pkg_name
136: )
137: THEN
138: RAISE fnd_api.g_exc_unexpected_error;
139: END IF;
140:
141: fnd_msg_pub.initialize;
142:

Line 207: RAISE fnd_api.g_exc_unexpected_error;

203: THEN
204: FND_MESSAGE.Set_Name ('JTF', 'CAC_NO_TO_DATE_PROVIDED');
205: FND_MSG_PUB.Add;
206: --fnd_file.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
207: RAISE fnd_api.g_exc_unexpected_error;
208: End if;
209:
210:
211: ----------------------------

Line 564: argument2 => fnd_api.g_false , -- p_init_msg_list

560: description => TO_CHAR(j) , -- Displayed in the Name column of Requests Screen
561: start_time => NULL ,
562: sub_request => TRUE ,
563: argument1 => 1 , -- p_api_version_number
564: argument2 => fnd_api.g_false , -- p_init_msg_list
565: argument3 => fnd_api.g_false , -- p_commit
566: argument4 => j , -- p_worker_id
567: argument5 => l_request_id -- p_concurrent_request_id
568: );

Line 565: argument3 => fnd_api.g_false , -- p_commit

561: start_time => NULL ,
562: sub_request => TRUE ,
563: argument1 => 1 , -- p_api_version_number
564: argument2 => fnd_api.g_false , -- p_init_msg_list
565: argument3 => fnd_api.g_false , -- p_commit
566: argument4 => j , -- p_worker_id
567: argument5 => l_request_id -- p_concurrent_request_id
568: );
569:

Line 578: RAISE fnd_api.g_exc_unexpected_error;

574: IF l_worker_conc_req_arr(j) = 0
575: THEN
576: FND_MESSAGE.Set_Name('JTF', 'CAC_TASK_PURGE_SUBMIT_REQUEST');
577: FND_MSG_PUB.Add;
578: RAISE fnd_api.g_exc_unexpected_error;
579: END IF;
580: END LOOP;
581:
582:

Line 714: RAISE fnd_api.g_exc_unexpected_error;

710:
711: FND_MESSAGE.Set_Name('JTF', 'CAC_TASK_NO_CP_STATUS');
712: FND_MSG_PUB.Add;
713:
714: RAISE fnd_api.g_exc_unexpected_error;
715: END IF;
716: END LOOP;
717:
718: -- Set the completion status of the main concurrent request

Line 725: RAISE fnd_api.g_exc_unexpected_error;

721: IF l_main_conc_req_dev_status = 'WARNING'
722: THEN
723: FND_MESSAGE.Set_Name('JTF', 'CAC_TASK_WORKER_RET_STAT_WARN');
724: FND_MSG_PUB.Add;
725: RAISE fnd_api.g_exc_unexpected_error;
726: ELSIF l_main_conc_req_dev_status = 'ERROR'
727: THEN
728: FND_MESSAGE.Set_Name('JTF', 'CAC_TASK_WORKER_RET_STAT_ERR');
729: FND_MSG_PUB.Add;

Line 730: RAISE fnd_api.g_exc_unexpected_error;

726: ELSIF l_main_conc_req_dev_status = 'ERROR'
727: THEN
728: FND_MESSAGE.Set_Name('JTF', 'CAC_TASK_WORKER_RET_STAT_ERR');
729: FND_MSG_PUB.Add;
730: RAISE fnd_api.g_exc_unexpected_error;
731: END IF;
732:
733: -- In case of 'NORMAL', setting OUT variable to successful,
734: -- committing the work and also truncating JTF_TASK_PURGE table

Line 770: WHEN fnd_api.g_exc_unexpected_error

766:
767: END IF; -- End of l_request_data Is NULL
768:
769: EXCEPTION
770: WHEN fnd_api.g_exc_unexpected_error
771: THEN
772: ROLLBACK TO purge_standalone_tasks;
773: FND_MSG_PUB.Count_And_Get (
774: p_count => l_msg_count,

Line 797: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'fnd_api.g_exc_unexpected_error');

793: -- Exception level Logging
794: ----------------------------
795: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
796: THEN
797: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'fnd_api.g_exc_unexpected_error');
798: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_msg_count = '||l_msg_count);
799: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Error message = '||REPLACE(l_msg_data,CHR(0),' '));
800: END IF;
801:

Line 843: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,

839: END PURGE_STANDALONE_TASKS;
840:
841: Procedure DELETE_TASK_ATTACHMENTS (
842: p_api_version IN NUMBER ,
843: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
844: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
845: p_processing_set_id IN NUMBER ,
846: x_return_status OUT NOCOPY VARCHAR2 ,
847: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 844: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,

840:
841: Procedure DELETE_TASK_ATTACHMENTS (
842: p_api_version IN NUMBER ,
843: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
844: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
845: p_processing_set_id IN NUMBER ,
846: x_return_status OUT NOCOPY VARCHAR2 ,
847: x_msg_data OUT NOCOPY VARCHAR2 ,
848: x_msg_count OUT NOCOPY NUMBER )

Line 871: x_return_status := fnd_api.g_ret_sts_success;

867: BEGIN
868:
869: SAVEPOINT delete_task_attachments;
870:
871: x_return_status := fnd_api.g_ret_sts_success;
872:
873: IF NOT fnd_api.compatible_api_call (
874: l_api_version,
875: p_api_version,

Line 873: IF NOT fnd_api.compatible_api_call (

869: SAVEPOINT delete_task_attachments;
870:
871: x_return_status := fnd_api.g_ret_sts_success;
872:
873: IF NOT fnd_api.compatible_api_call (
874: l_api_version,
875: p_api_version,
876: l_api_name,
877: g_pkg_name

Line 880: RAISE fnd_api.g_exc_unexpected_error;

876: l_api_name,
877: g_pkg_name
878: )
879: THEN
880: RAISE fnd_api.g_exc_unexpected_error;
881: END IF;
882:
883: IF fnd_api.to_boolean (p_init_msg_list)
884: THEN

Line 883: IF fnd_api.to_boolean (p_init_msg_list)

879: THEN
880: RAISE fnd_api.g_exc_unexpected_error;
881: END IF;
882:
883: IF fnd_api.to_boolean (p_init_msg_list)
884: THEN
885: fnd_msg_pub.initialize;
886: END IF;
887:

Line 941: IF fnd_api.to_boolean(p_commit)

937: END LOOP;
938:
939: END IF;
940:
941: IF fnd_api.to_boolean(p_commit)
942: THEN
943: COMMIT WORK;
944: END IF;
945:

Line 947: WHEN fnd_api.g_exc_unexpected_error

943: COMMIT WORK;
944: END IF;
945:
946: EXCEPTION
947: WHEN fnd_api.g_exc_unexpected_error
948: THEN
949: ROLLBACK TO delete_task_attachments;
950: x_return_status := fnd_api.g_ret_sts_unexp_error;
951: FND_MSG_PUB.Count_And_Get (

Line 950: x_return_status := fnd_api.g_ret_sts_unexp_error;

946: EXCEPTION
947: WHEN fnd_api.g_exc_unexpected_error
948: THEN
949: ROLLBACK TO delete_task_attachments;
950: x_return_status := fnd_api.g_ret_sts_unexp_error;
951: FND_MSG_PUB.Count_And_Get (
952: p_count => x_msg_count,
953: p_data => x_msg_data
954: );

Line 969: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'fnd_api.g_exc_unexpected_error');

965: -- Exception level Logging
966: ----------------------------
967: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
968: THEN
969: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'fnd_api.g_exc_unexpected_error');
970: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'x_msg_count = '||x_msg_count);
971: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
972: END IF;
973:

Line 980: x_return_status := fnd_api.g_ret_sts_unexp_error;

976: ROLLBACK TO delete_task_attachments;
977: FND_MESSAGE.Set_Name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');
978: FND_MESSAGE.Set_Token ('P_TEXT', G_PKG_NAME||'.'||l_api_name ||' : '||SQLCODE||' : '|| SQLERRM);
979: FND_MSG_PUB.Add;
980: x_return_status := fnd_api.g_ret_sts_unexp_error;
981: FND_MSG_PUB.Count_And_Get (
982: p_count => x_msg_count,
983: p_data => x_msg_data
984: );

Line 1009: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

1005: END DELETE_TASK_ATTACHMENTS;
1006:
1007: Procedure VALIDATE_STANDALONE_TASK(
1008: p_api_version IN NUMBER,
1009: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1010: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1011: p_processing_set_id IN NUMBER,
1012: x_return_status OUT NOCOPY VARCHAR2,
1013: x_msg_data OUT NOCOPY VARCHAR2,

Line 1010: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

1006:
1007: Procedure VALIDATE_STANDALONE_TASK(
1008: p_api_version IN NUMBER,
1009: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1010: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1011: p_processing_set_id IN NUMBER,
1012: x_return_status OUT NOCOPY VARCHAR2,
1013: x_msg_data OUT NOCOPY VARCHAR2,
1014: x_msg_count OUT NOCOPY NUMBER)

Line 1022: x_return_status := fnd_api.g_ret_sts_success;

1018:
1019: BEGIN
1020: SAVEPOINT validate_standalone_task;
1021:
1022: x_return_status := fnd_api.g_ret_sts_success;
1023:
1024: IF NOT fnd_api.compatible_api_call (
1025: l_api_version,
1026: p_api_version,

Line 1024: IF NOT fnd_api.compatible_api_call (

1020: SAVEPOINT validate_standalone_task;
1021:
1022: x_return_status := fnd_api.g_ret_sts_success;
1023:
1024: IF NOT fnd_api.compatible_api_call (
1025: l_api_version,
1026: p_api_version,
1027: l_api_name,
1028: g_pkg_name

Line 1031: RAISE fnd_api.g_exc_unexpected_error;

1027: l_api_name,
1028: g_pkg_name
1029: )
1030: THEN
1031: RAISE fnd_api.g_exc_unexpected_error;
1032: END IF;
1033:
1034: IF fnd_api.to_boolean (p_init_msg_list)
1035: THEN

Line 1034: IF fnd_api.to_boolean (p_init_msg_list)

1030: THEN
1031: RAISE fnd_api.g_exc_unexpected_error;
1032: END IF;
1033:
1034: IF fnd_api.to_boolean (p_init_msg_list)
1035: THEN
1036: fnd_msg_pub.initialize;
1037: END IF;
1038:

Line 1059: P_INIT_MSG_LIST => FND_API.G_FALSE ,

1055: END IF;
1056:
1057: CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS(
1058: P_API_VERSION => 1.0,
1059: P_INIT_MSG_LIST => FND_API.G_FALSE ,
1060: P_COMMIT => FND_API.G_FALSE ,
1061: P_PROCESSING_SET_ID => p_processing_set_id ,
1062: P_OBJECT_TYPE => 'TASK' ,
1063: X_RETURN_STATUS => x_return_status ,

Line 1060: P_COMMIT => FND_API.G_FALSE ,

1056:
1057: CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS(
1058: P_API_VERSION => 1.0,
1059: P_INIT_MSG_LIST => FND_API.G_FALSE ,
1060: P_COMMIT => FND_API.G_FALSE ,
1061: P_PROCESSING_SET_ID => p_processing_set_id ,
1062: P_OBJECT_TYPE => 'TASK' ,
1063: X_RETURN_STATUS => x_return_status ,
1064: X_MSG_COUNT => x_msg_count ,

Line 1067: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

1063: X_RETURN_STATUS => x_return_status ,
1064: X_MSG_COUNT => x_msg_count ,
1065: X_MSG_DATA => x_msg_data);
1066:
1067: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1068: THEN
1069: x_return_status := fnd_api.g_ret_sts_unexp_error;
1070:
1071: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 1069: x_return_status := fnd_api.g_ret_sts_unexp_error;

1065: X_MSG_DATA => x_msg_data);
1066:
1067: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
1068: THEN
1069: x_return_status := fnd_api.g_ret_sts_unexp_error;
1070:
1071: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1072: THEN
1073: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'VALIDATE_STANDALONE_TASK', 'return status error after calling CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS');

Line 1076: RAISE fnd_api.g_exc_unexpected_error;

1072: THEN
1073: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'VALIDATE_STANDALONE_TASK', 'return status error after calling CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS');
1074: END IF;
1075:
1076: RAISE fnd_api.g_exc_unexpected_error;
1077:
1078: END IF;
1079:
1080:

Line 1081: IF fnd_api.to_boolean (p_commit)

1077:
1078: END IF;
1079:
1080:
1081: IF fnd_api.to_boolean (p_commit)
1082: THEN
1083: COMMIT WORK;
1084: END IF;
1085:

Line 1100: WHEN fnd_api.g_exc_unexpected_error

1096: p_data => x_msg_data
1097: );
1098:
1099: EXCEPTION
1100: WHEN fnd_api.g_exc_unexpected_error
1101: THEN
1102: ROLLBACK TO validate_standalone_task;
1103: x_return_status := fnd_api.g_ret_sts_unexp_error;
1104: FND_MSG_PUB.Count_And_Get (

Line 1103: x_return_status := fnd_api.g_ret_sts_unexp_error;

1099: EXCEPTION
1100: WHEN fnd_api.g_exc_unexpected_error
1101: THEN
1102: ROLLBACK TO validate_standalone_task;
1103: x_return_status := fnd_api.g_ret_sts_unexp_error;
1104: FND_MSG_PUB.Count_And_Get (
1105: p_count => x_msg_count,
1106: p_data => x_msg_data
1107: );

Line 1120: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'fnd_api.g_exc_unexpected_error');

1116: -- Exception level Logging
1117: ----------------------------
1118: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1119: THEN
1120: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'fnd_api.g_exc_unexpected_error');
1121: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'x_msg_count = '||x_msg_count);
1122: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
1123: END IF;
1124:

Line 1131: x_return_status := fnd_api.g_ret_sts_unexp_error;

1127: ROLLBACK TO validate_standalone_task;
1128: FND_MESSAGE.Set_Name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');
1129: FND_MESSAGE.Set_Token ('P_TEXT', G_PKG_NAME||'.'||l_api_name ||' : '||SQLCODE||' : '|| SQLERRM);
1130: FND_MSG_PUB.Add;
1131: x_return_status := fnd_api.g_ret_sts_unexp_error;
1132: FND_MSG_PUB.Count_And_Get (
1133: p_count => x_msg_count,
1134: p_data => x_msg_data
1135: );

Line 1159: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,

1155: Procedure POPULATE_PURGE_TMP (
1156: errbuf OUT NOCOPY VARCHAR2,
1157: retcode OUT NOCOPY VARCHAR2,
1158: p_api_version IN NUMBER ,
1159: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
1160: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
1161: p_worker_id IN NUMBER ,
1162: p_concurrent_request_id IN NUMBER)
1163: IS

Line 1160: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,

1156: errbuf OUT NOCOPY VARCHAR2,
1157: retcode OUT NOCOPY VARCHAR2,
1158: p_api_version IN NUMBER ,
1159: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
1160: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
1161: p_worker_id IN NUMBER ,
1162: p_concurrent_request_id IN NUMBER)
1163: IS
1164: l_api_version CONSTANT NUMBER := 1.0;

Line 1207: IF NOT fnd_api.compatible_api_call (

1203: BEGIN
1204:
1205: SAVEPOINT populate_purge_tmp;
1206:
1207: IF NOT fnd_api.compatible_api_call (
1208: l_api_version,
1209: p_api_version,
1210: l_api_name,
1211: g_pkg_name

Line 1214: RAISE fnd_api.g_exc_unexpected_error;

1210: l_api_name,
1211: g_pkg_name
1212: )
1213: THEN
1214: RAISE fnd_api.g_exc_unexpected_error;
1215: END IF;
1216:
1217: IF fnd_api.to_boolean (p_init_msg_list)
1218: THEN

Line 1217: IF fnd_api.to_boolean (p_init_msg_list)

1213: THEN
1214: RAISE fnd_api.g_exc_unexpected_error;
1215: END IF;
1216:
1217: IF fnd_api.to_boolean (p_init_msg_list)
1218: THEN
1219: fnd_msg_pub.initialize;
1220: END IF;
1221:

Line 1296: p_init_msg_list => fnd_api.g_false ,

1292: -- Calling VALIDATE_STANDALONE_TASK to validate standalone tasks
1293:
1294: VALIDATE_STANDALONE_TASK (
1295: p_api_version => 1.0 ,
1296: p_init_msg_list => fnd_api.g_false ,
1297: p_commit => fnd_api.g_false ,
1298: p_processing_set_id => l_processing_set_id ,
1299: x_return_status => l_return_status ,
1300: x_msg_count => l_msg_count ,

Line 1297: p_commit => fnd_api.g_false ,

1293:
1294: VALIDATE_STANDALONE_TASK (
1295: p_api_version => 1.0 ,
1296: p_init_msg_list => fnd_api.g_false ,
1297: p_commit => fnd_api.g_false ,
1298: p_processing_set_id => l_processing_set_id ,
1299: x_return_status => l_return_status ,
1300: x_msg_count => l_msg_count ,
1301: x_msg_data => l_msg_data

Line 1304: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

1300: x_msg_count => l_msg_count ,
1301: x_msg_data => l_msg_data
1302: );
1303:
1304: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1305: THEN
1306: l_return_status := fnd_api.g_ret_sts_unexp_error;
1307: RAISE fnd_api.g_exc_unexpected_error;
1308: END IF;

Line 1306: l_return_status := fnd_api.g_ret_sts_unexp_error;

1302: );
1303:
1304: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1305: THEN
1306: l_return_status := fnd_api.g_ret_sts_unexp_error;
1307: RAISE fnd_api.g_exc_unexpected_error;
1308: END IF;
1309:
1310: ----------------------------

Line 1307: RAISE fnd_api.g_exc_unexpected_error;

1303:
1304: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1305: THEN
1306: l_return_status := fnd_api.g_ret_sts_unexp_error;
1307: RAISE fnd_api.g_exc_unexpected_error;
1308: END IF;
1309:
1310: ----------------------------
1311: -- Statement level Logging

Line 1323: p_init_msg_list => fnd_api.g_false ,

1319: -- Calling DELETE_TASK_ATTACHMENTS to delete attachments
1320:
1321: DELETE_TASK_ATTACHMENTS (
1322: p_api_version => 1.0 ,
1323: p_init_msg_list => fnd_api.g_false ,
1324: p_commit => fnd_api.g_false ,
1325: p_processing_set_id => l_processing_set_id ,
1326: x_return_status => l_return_status ,
1327: x_msg_data => l_msg_data ,

Line 1324: p_commit => fnd_api.g_false ,

1320:
1321: DELETE_TASK_ATTACHMENTS (
1322: p_api_version => 1.0 ,
1323: p_init_msg_list => fnd_api.g_false ,
1324: p_commit => fnd_api.g_false ,
1325: p_processing_set_id => l_processing_set_id ,
1326: x_return_status => l_return_status ,
1327: x_msg_data => l_msg_data ,
1328: x_msg_count => l_msg_count

Line 1331: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

1327: x_msg_data => l_msg_data ,
1328: x_msg_count => l_msg_count
1329: );
1330:
1331: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1332: THEN
1333: l_return_status := fnd_api.g_ret_sts_unexp_error;
1334: RAISE fnd_api.g_exc_unexpected_error;
1335: END IF;

Line 1333: l_return_status := fnd_api.g_ret_sts_unexp_error;

1329: );
1330:
1331: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1332: THEN
1333: l_return_status := fnd_api.g_ret_sts_unexp_error;
1334: RAISE fnd_api.g_exc_unexpected_error;
1335: END IF;
1336:
1337:

Line 1334: RAISE fnd_api.g_exc_unexpected_error;

1330:
1331: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1332: THEN
1333: l_return_status := fnd_api.g_ret_sts_unexp_error;
1334: RAISE fnd_api.g_exc_unexpected_error;
1335: END IF;
1336:
1337:
1338: ----------------------------

Line 1352: p_init_msg_list => fnd_api.g_false,

1348: -- Calling CAC_NOTE_PURGE_PUB.PURGE_NOTES to delete notes
1349:
1350: CAC_NOTE_PURGE_PUB.PURGE_NOTES (
1351: p_api_version => 1.0 ,
1352: p_init_msg_list => fnd_api.g_false,
1353: p_commit => fnd_api.g_false,
1354: x_return_status => l_return_status ,
1355: x_msg_data => l_msg_data ,
1356: x_msg_count => l_msg_count ,

Line 1353: p_commit => fnd_api.g_false,

1349:
1350: CAC_NOTE_PURGE_PUB.PURGE_NOTES (
1351: p_api_version => 1.0 ,
1352: p_init_msg_list => fnd_api.g_false,
1353: p_commit => fnd_api.g_false,
1354: x_return_status => l_return_status ,
1355: x_msg_data => l_msg_data ,
1356: x_msg_count => l_msg_count ,
1357: p_processing_set_id => l_processing_set_id ,

Line 1361: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

1357: p_processing_set_id => l_processing_set_id ,
1358: p_object_type => 'TASK'
1359: ) ;
1360:
1361: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1362: THEN
1363: l_return_status := fnd_api.g_ret_sts_unexp_error;
1364: RAISE fnd_api.g_exc_unexpected_error;
1365: END IF;

Line 1363: l_return_status := fnd_api.g_ret_sts_unexp_error;

1359: ) ;
1360:
1361: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1362: THEN
1363: l_return_status := fnd_api.g_ret_sts_unexp_error;
1364: RAISE fnd_api.g_exc_unexpected_error;
1365: END IF;
1366:
1367:

Line 1364: RAISE fnd_api.g_exc_unexpected_error;

1360:
1361: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1362: THEN
1363: l_return_status := fnd_api.g_ret_sts_unexp_error;
1364: RAISE fnd_api.g_exc_unexpected_error;
1365: END IF;
1366:
1367:
1368: ----------------------------

Line 1380: p_init_msg_list => fnd_api.g_false,

1376: -- Calling CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS to delete data from Field Service
1377:
1378: CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS(
1379: p_api_version => 1.0,
1380: p_init_msg_list => fnd_api.g_false,
1381: p_commit => fnd_api.g_false,
1382: p_processing_set_id => l_processing_set_id ,
1383: p_object_type => 'TASK' ,
1384: x_return_status => l_return_status,

Line 1381: p_commit => fnd_api.g_false,

1377:
1378: CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS(
1379: p_api_version => 1.0,
1380: p_init_msg_list => fnd_api.g_false,
1381: p_commit => fnd_api.g_false,
1382: p_processing_set_id => l_processing_set_id ,
1383: p_object_type => 'TASK' ,
1384: x_return_status => l_return_status,
1385: x_msg_count => l_msg_count,

Line 1389: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

1385: x_msg_count => l_msg_count,
1386: x_msg_data => l_msg_data
1387: );
1388:
1389: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1390: THEN
1391: l_return_status := fnd_api.g_ret_sts_unexp_error;
1392: RAISE fnd_api.g_exc_unexpected_error;
1393: END IF;

Line 1391: l_return_status := fnd_api.g_ret_sts_unexp_error;

1387: );
1388:
1389: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1390: THEN
1391: l_return_status := fnd_api.g_ret_sts_unexp_error;
1392: RAISE fnd_api.g_exc_unexpected_error;
1393: END IF;
1394:
1395:

Line 1392: RAISE fnd_api.g_exc_unexpected_error;

1388:
1389: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1390: THEN
1391: l_return_status := fnd_api.g_ret_sts_unexp_error;
1392: RAISE fnd_api.g_exc_unexpected_error;
1393: END IF;
1394:
1395:
1396: ----------------------------

Line 1409: p_init_msg_list => fnd_api.g_false,

1405: -- Calling IEU_WR_PUB.Purge_Wr_Item to delete data from UWQ
1406:
1407: IEU_WR_PUB.Purge_Wr_Item(
1408: p_api_version_number => 1.0,
1409: p_init_msg_list => fnd_api.g_false,
1410: p_commit => fnd_api.g_false,
1411: p_processing_set_id => l_processing_set_id ,
1412: p_object_type => 'TASK' ,
1413: x_return_status => l_return_status,

Line 1410: p_commit => fnd_api.g_false,

1406:
1407: IEU_WR_PUB.Purge_Wr_Item(
1408: p_api_version_number => 1.0,
1409: p_init_msg_list => fnd_api.g_false,
1410: p_commit => fnd_api.g_false,
1411: p_processing_set_id => l_processing_set_id ,
1412: p_object_type => 'TASK' ,
1413: x_return_status => l_return_status,
1414: x_msg_count => l_msg_count,

Line 1418: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

1414: x_msg_count => l_msg_count,
1415: x_msg_data => l_msg_data
1416: );
1417:
1418: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1419: THEN
1420: l_return_status := fnd_api.g_ret_sts_unexp_error;
1421: RAISE fnd_api.g_exc_unexpected_error;
1422: END IF;

Line 1420: l_return_status := fnd_api.g_ret_sts_unexp_error;

1416: );
1417:
1418: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1419: THEN
1420: l_return_status := fnd_api.g_ret_sts_unexp_error;
1421: RAISE fnd_api.g_exc_unexpected_error;
1422: END IF;
1423:
1424:

Line 1421: RAISE fnd_api.g_exc_unexpected_error;

1417:
1418: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1419: THEN
1420: l_return_status := fnd_api.g_ret_sts_unexp_error;
1421: RAISE fnd_api.g_exc_unexpected_error;
1422: END IF;
1423:
1424:
1425: ----------------------------

Line 1438: p_init_msg_list => fnd_api.g_false,

1434: -- Calling JTF_IH_PURGE.P_Delete_Interactions to delete data from Interaction History
1435:
1436: JTF_IH_PURGE.P_Delete_Interactions(
1437: p_api_version => 1.0,
1438: p_init_msg_list => fnd_api.g_false,
1439: p_commit => fnd_api.g_false,
1440: p_processing_set_id => l_processing_set_id ,
1441: p_object_type => 'TASK' ,
1442: x_return_status => l_return_status,

Line 1439: p_commit => fnd_api.g_false,

1435:
1436: JTF_IH_PURGE.P_Delete_Interactions(
1437: p_api_version => 1.0,
1438: p_init_msg_list => fnd_api.g_false,
1439: p_commit => fnd_api.g_false,
1440: p_processing_set_id => l_processing_set_id ,
1441: p_object_type => 'TASK' ,
1442: x_return_status => l_return_status,
1443: x_msg_count => l_msg_count,

Line 1448: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

1444: x_msg_data => l_msg_data
1445: );
1446:
1447:
1448: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1449: THEN
1450: l_return_status := fnd_api.g_ret_sts_unexp_error;
1451: RAISE fnd_api.g_exc_unexpected_error;
1452: END IF;

Line 1450: l_return_status := fnd_api.g_ret_sts_unexp_error;

1446:
1447:
1448: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1449: THEN
1450: l_return_status := fnd_api.g_ret_sts_unexp_error;
1451: RAISE fnd_api.g_exc_unexpected_error;
1452: END IF;
1453:
1454:

Line 1451: RAISE fnd_api.g_exc_unexpected_error;

1447:
1448: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1449: THEN
1450: l_return_status := fnd_api.g_ret_sts_unexp_error;
1451: RAISE fnd_api.g_exc_unexpected_error;
1452: END IF;
1453:
1454:
1455: ----------------------------

Line 1469: p_init_msg_list => fnd_api.g_false ,

1465: -- Calling CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES to delte task entities
1466:
1467: CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES(
1468: p_api_version => 1.0 ,
1469: p_init_msg_list => fnd_api.g_false ,
1470: p_commit => fnd_api.g_false ,
1471: p_processing_set_id => l_processing_set_id ,
1472: x_return_status => l_return_status ,
1473: x_msg_data => l_msg_data ,

Line 1470: p_commit => fnd_api.g_false ,

1466:
1467: CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES(
1468: p_api_version => 1.0 ,
1469: p_init_msg_list => fnd_api.g_false ,
1470: p_commit => fnd_api.g_false ,
1471: p_processing_set_id => l_processing_set_id ,
1472: x_return_status => l_return_status ,
1473: x_msg_data => l_msg_data ,
1474: x_msg_count => l_msg_count ,

Line 1478: IF NOT (l_return_status = fnd_api.g_ret_sts_success)

1474: x_msg_count => l_msg_count ,
1475: p_object_type => 'TASK'
1476: );
1477:
1478: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1479: THEN
1480: l_return_status := fnd_api.g_ret_sts_unexp_error;
1481: RAISE fnd_api.g_exc_unexpected_error;
1482: END IF;

Line 1480: l_return_status := fnd_api.g_ret_sts_unexp_error;

1476: );
1477:
1478: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1479: THEN
1480: l_return_status := fnd_api.g_ret_sts_unexp_error;
1481: RAISE fnd_api.g_exc_unexpected_error;
1482: END IF;
1483:
1484:

Line 1481: RAISE fnd_api.g_exc_unexpected_error;

1477:
1478: IF NOT (l_return_status = fnd_api.g_ret_sts_success)
1479: THEN
1480: l_return_status := fnd_api.g_ret_sts_unexp_error;
1481: RAISE fnd_api.g_exc_unexpected_error;
1482: END IF;
1483:
1484:
1485: ----------------------------

Line 1543: IF fnd_api.to_boolean(p_commit)

1539:
1540: errbuf := l_msg_data;
1541: retcode := l_cp_succ;
1542:
1543: IF fnd_api.to_boolean(p_commit)
1544: THEN
1545: COMMIT WORK;
1546: END IF;
1547:

Line 1558: WHEN fnd_api.g_exc_unexpected_error

1554: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'retcode = '||retcode);
1555: END IF;
1556:
1557: EXCEPTION
1558: WHEN fnd_api.g_exc_unexpected_error
1559: THEN
1560: ROLLBACK TO populate_purge_tmp;
1561: FND_MSG_PUB.Count_And_Get (
1562: p_count => l_msg_count,

Line 1586: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'fnd_api.g_exc_unexpected_error');

1582: -- Exception level Logging
1583: ----------------------------
1584: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1585: THEN
1586: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'fnd_api.g_exc_unexpected_error');
1587: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'l_msg_count = '||l_msg_count);
1588: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Error message = '||REPLACE(l_msg_data,CHR(0),' '));
1589: END IF;
1590:

Line 1631: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,

1627: END POPULATE_PURGE_TMP;
1628:
1629: Procedure PURGE_TASK_ENTITIES (
1630: p_api_version IN NUMBER ,
1631: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
1632: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
1633: p_processing_set_id IN NUMBER ,
1634: x_return_status OUT NOCOPY VARCHAR2 ,
1635: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 1632: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,

1628:
1629: Procedure PURGE_TASK_ENTITIES (
1630: p_api_version IN NUMBER ,
1631: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,
1632: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,
1633: p_processing_set_id IN NUMBER ,
1634: x_return_status OUT NOCOPY VARCHAR2 ,
1635: x_msg_data OUT NOCOPY VARCHAR2 ,
1636: x_msg_count OUT NOCOPY NUMBER ,

Line 1661: x_return_status := fnd_api.g_ret_sts_success;

1657: BEGIN
1658:
1659: SAVEPOINT purge_task_entities;
1660:
1661: x_return_status := fnd_api.g_ret_sts_success;
1662:
1663: IF NOT fnd_api.compatible_api_call (
1664: l_api_version,
1665: p_api_version,

Line 1663: IF NOT fnd_api.compatible_api_call (

1659: SAVEPOINT purge_task_entities;
1660:
1661: x_return_status := fnd_api.g_ret_sts_success;
1662:
1663: IF NOT fnd_api.compatible_api_call (
1664: l_api_version,
1665: p_api_version,
1666: l_api_name,
1667: g_pkg_name

Line 1670: RAISE fnd_api.g_exc_unexpected_error;

1666: l_api_name,
1667: g_pkg_name
1668: )
1669: THEN
1670: RAISE fnd_api.g_exc_unexpected_error;
1671: END IF;
1672:
1673: IF fnd_api.to_boolean (p_init_msg_list)
1674: THEN

Line 1673: IF fnd_api.to_boolean (p_init_msg_list)

1669: THEN
1670: RAISE fnd_api.g_exc_unexpected_error;
1671: END IF;
1672:
1673: IF fnd_api.to_boolean (p_init_msg_list)
1674: THEN
1675: fnd_msg_pub.initialize;
1676: END IF;
1677:

Line 1949: IF fnd_api.to_boolean(p_commit)

1945: END IF;
1946:
1947: END IF;
1948:
1949: IF fnd_api.to_boolean(p_commit)
1950: THEN
1951: COMMIT WORK;
1952: END IF;
1953:

Line 1963: WHEN fnd_api.g_exc_unexpected_error

1959: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'End of PURGE_TASK_ENTITIES');
1960: END IF;
1961:
1962: EXCEPTION
1963: WHEN fnd_api.g_exc_unexpected_error
1964: THEN
1965: ROLLBACK TO purge_task_entities;
1966: x_return_status := fnd_api.g_ret_sts_unexp_error;
1967: FND_MSG_PUB.Count_And_Get (

Line 1966: x_return_status := fnd_api.g_ret_sts_unexp_error;

1962: EXCEPTION
1963: WHEN fnd_api.g_exc_unexpected_error
1964: THEN
1965: ROLLBACK TO purge_task_entities;
1966: x_return_status := fnd_api.g_ret_sts_unexp_error;
1967: FND_MSG_PUB.Count_And_Get (
1968: p_count => x_msg_count,
1969: p_data => x_msg_data
1970: );

Line 1985: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'fnd_api.g_exc_unexpected_error');

1981: -- Exception level Logging
1982: ----------------------------
1983: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1984: THEN
1985: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'fnd_api.g_exc_unexpected_error');
1986: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'x_msg_count = '||x_msg_count);
1987: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
1988: END IF;
1989:

Line 1996: x_return_status := fnd_api.g_ret_sts_unexp_error;

1992: ROLLBACK TO purge_task_entities;
1993: FND_MESSAGE.Set_Name ('JTF', 'CAC_TASK_UNKNOWN_ERROR');
1994: FND_MESSAGE.Set_Token ('P_TEXT', G_PKG_NAME||'.'||l_api_name ||' : '||SQLCODE||' : '|| SQLERRM);
1995: FND_MSG_PUB.Add;
1996: x_return_status := fnd_api.g_ret_sts_unexp_error;
1997: FND_MSG_PUB.Count_And_Get (
1998: p_count => x_msg_count,
1999: p_data => x_msg_data
2000: );