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

Line 334: p_init_msg_list => FND_API.G_TRUE,

330: if jtf_tasks_pub.p_task_user_hooks.entity = 'TASK' then
331:
332: IEU_WR_PUB.CREATE_WR_ITEM(
333: p_api_version => 1.0,
334: p_init_msg_list => FND_API.G_TRUE,
335: p_commit => FND_API.G_FALSE,
336: p_workitem_obj_code => 'TASK',
337: p_workitem_pk_id => jtf_tasks_pub.p_task_user_hooks.task_id,
338: p_work_item_number => to_number(jtf_tasks_pub.p_task_user_hooks.task_number),

Line 335: p_commit => FND_API.G_FALSE,

331:
332: IEU_WR_PUB.CREATE_WR_ITEM(
333: p_api_version => 1.0,
334: p_init_msg_list => FND_API.G_TRUE,
335: p_commit => FND_API.G_FALSE,
336: p_workitem_obj_code => 'TASK',
337: p_workitem_pk_id => jtf_tasks_pub.p_task_user_hooks.task_id,
338: p_work_item_number => to_number(jtf_tasks_pub.p_task_user_hooks.task_number),
339: p_title => jtf_tasks_pub.p_task_user_hooks.task_name,

Line 363: x_return_status := fnd_api.g_ret_sts_success;

359:
360: x_return_status := l_return_status;
361:
362: else
363: x_return_status := fnd_api.g_ret_sts_success;
364:
365: end if;
366:
367: EXCEPTION

Line 369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

365: end if;
366:
367: EXCEPTION
368: WHEN OTHERS THEN
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
370:
371: END;
372:
373: else -- task is not in Open status, so return success

Line 374: x_return_status := FND_API.G_RET_STS_SUCCESS;

370:
371: END;
372:
373: else -- task is not in Open status, so return success
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375: end if;
376:
377: end if; /* Tasks Rules Func */
378:

Line 380: x_return_status := FND_API.G_RET_STS_SUCCESS;

376:
377: end if; /* Tasks Rules Func */
378:
379: elsif l_activation_status = 'N' then
380: x_return_status := FND_API.G_RET_STS_SUCCESS;
381: end if;
382: end create_task_uwqm_pre;
383:
384:

Line 793: x_return_status := fnd_api.g_ret_sts_success;

789: if (jtf_tasks_pub.p_task_user_hooks.entity = 'TASK')
790: then
791: -- Start IF-3
792: if ((l_task_status = 'CLOSE') and (l_count = 0)) THEN
793: x_return_status := fnd_api.g_ret_sts_success;
794: else
795: if trunc(nvl(l_due_date, FND_API.G_MISS_DATE)) <> trunc(nvl(l_wr_due_date, FND_API.G_MISS_DATE))
796: then
797: l_workitem_comment_code2 := l_workitem_comment_code2;

Line 795: if trunc(nvl(l_due_date, FND_API.G_MISS_DATE)) <> trunc(nvl(l_wr_due_date, FND_API.G_MISS_DATE))

791: -- Start IF-3
792: if ((l_task_status = 'CLOSE') and (l_count = 0)) THEN
793: x_return_status := fnd_api.g_ret_sts_success;
794: else
795: if trunc(nvl(l_due_date, FND_API.G_MISS_DATE)) <> trunc(nvl(l_wr_due_date, FND_API.G_MISS_DATE))
796: then
797: l_workitem_comment_code2 := l_workitem_comment_code2;
798: else
799: l_workitem_comment_code2 := null;

Line 884: p_init_msg_list => FND_API.G_TRUE,

880: -- Start IF-4
881: if ((l_task_status <> 'CLOSE') and (l_count = 0)) then
882: IEU_WR_PUB.CREATE_WR_ITEM(
883: p_api_version => 1.0,
884: p_init_msg_list => FND_API.G_TRUE,
885: p_commit => FND_API.G_FALSE,
886: p_workitem_obj_code => 'TASK',
887: p_workitem_pk_id => jtf_tasks_pub.p_task_user_hooks.task_id,
888: p_work_item_number => to_number(jtf_tasks_pub.p_task_user_hooks.task_number),

Line 885: p_commit => FND_API.G_FALSE,

881: if ((l_task_status <> 'CLOSE') and (l_count = 0)) then
882: IEU_WR_PUB.CREATE_WR_ITEM(
883: p_api_version => 1.0,
884: p_init_msg_list => FND_API.G_TRUE,
885: p_commit => FND_API.G_FALSE,
886: p_workitem_obj_code => 'TASK',
887: p_workitem_pk_id => jtf_tasks_pub.p_task_user_hooks.task_id,
888: p_work_item_number => to_number(jtf_tasks_pub.p_task_user_hooks.task_number),
889: p_title => jtf_tasks_pub.p_task_user_hooks.task_name,

Line 914: p_init_msg_list => FND_API.G_TRUE,

910: x_return_status := l_return_status;
911: else
912: IEU_WR_PUB.UPDATE_WR_ITEM(
913: p_api_version => 1.0,
914: p_init_msg_list => FND_API.G_TRUE,
915: p_commit => FND_API.G_FALSE,
916: p_workitem_obj_code => 'TASK',
917: p_workitem_pk_id => jtf_tasks_pub.p_task_user_hooks.task_id,
918: p_title => jtf_tasks_pub.p_task_user_hooks.task_name,

Line 915: p_commit => FND_API.G_FALSE,

911: else
912: IEU_WR_PUB.UPDATE_WR_ITEM(
913: p_api_version => 1.0,
914: p_init_msg_list => FND_API.G_TRUE,
915: p_commit => FND_API.G_FALSE,
916: p_workitem_obj_code => 'TASK',
917: p_workitem_pk_id => jtf_tasks_pub.p_task_user_hooks.task_id,
918: p_title => jtf_tasks_pub.p_task_user_hooks.task_name,
919: p_party_id => jtf_tasks_pub.p_task_user_hooks.customer_id,

Line 941: if (x_return_status <> fnd_api.g_ret_sts_success) then

937: x_return_status := l_return_status;
938: end if;
939: -- End IF-4
940:
941: if (x_return_status <> fnd_api.g_ret_sts_success) then
942: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
943: raise FND_API.G_EXC_UNEXPECTED_ERROR;
944: end if;
945: End if;

Line 942: -- x_return_status := fnd_api.g_ret_sts_unexp_error;

938: end if;
939: -- End IF-4
940:
941: if (x_return_status <> fnd_api.g_ret_sts_success) then
942: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
943: raise FND_API.G_EXC_UNEXPECTED_ERROR;
944: end if;
945: End if;
946: -- End IF-3

Line 943: raise FND_API.G_EXC_UNEXPECTED_ERROR;

939: -- End IF-4
940:
941: if (x_return_status <> fnd_api.g_ret_sts_success) then
942: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
943: raise FND_API.G_EXC_UNEXPECTED_ERROR;
944: end if;
945: End if;
946: -- End IF-3
947: else

Line 948: x_return_status := fnd_api.g_ret_sts_success;

944: end if;
945: End if;
946: -- End IF-3
947: else
948: x_return_status := fnd_api.g_ret_sts_success;
949: end if;
950: -- End IF-2 (Task Check)
951: else -- ie if flag=n
952: x_return_status := fnd_api.g_ret_sts_success;

Line 952: x_return_status := fnd_api.g_ret_sts_success;

948: x_return_status := fnd_api.g_ret_sts_success;
949: end if;
950: -- End IF-2 (Task Check)
951: else -- ie if flag=n
952: x_return_status := fnd_api.g_ret_sts_success;
953: end if;
954: -- End IF-1
955:
956: EXCEPTION

Line 957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

953: end if;
954: -- End IF-1
955:
956: EXCEPTION
957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
959:
960: WHEN OTHERS THEN
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

954: -- End IF-1
955:
956: EXCEPTION
957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
959:
960: WHEN OTHERS THEN
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
962: END;

Line 961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
959:
960: WHEN OTHERS THEN
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
962: END;
963:
964: end if; /* Tasks Rules Func */
965:

Line 967: x_return_status := FND_API.G_RET_STS_SUCCESS;

963:
964: end if; /* Tasks Rules Func */
965:
966: elsif l_activation_status = 'N' then
967: x_return_status := FND_API.G_RET_STS_SUCCESS;
968: end if;
969: end update_task_uwqm_pre;
970:
971:

Line 1135: FND_API.G_MISS_CHAR,

1131: 'DELETE_TASK',
1132: jtf_tasks_pub.p_task_user_hooks.task_id,
1133: null,
1134: null,
1135: FND_API.G_MISS_CHAR,
1136: FND_API.G_MISS_NUM,
1137: FND_API.G_MISS_NUM,
1138: FND_API.G_MISS_NUM,
1139: FND_API.G_MISS_NUM,

Line 1136: FND_API.G_MISS_NUM,

1132: jtf_tasks_pub.p_task_user_hooks.task_id,
1133: null,
1134: null,
1135: FND_API.G_MISS_CHAR,
1136: FND_API.G_MISS_NUM,
1137: FND_API.G_MISS_NUM,
1138: FND_API.G_MISS_NUM,
1139: FND_API.G_MISS_NUM,
1140: FND_API.G_MISS_CHAR,

Line 1137: FND_API.G_MISS_NUM,

1133: null,
1134: null,
1135: FND_API.G_MISS_CHAR,
1136: FND_API.G_MISS_NUM,
1137: FND_API.G_MISS_NUM,
1138: FND_API.G_MISS_NUM,
1139: FND_API.G_MISS_NUM,
1140: FND_API.G_MISS_CHAR,
1141: FND_API.G_MISS_NUM,

Line 1138: FND_API.G_MISS_NUM,

1134: null,
1135: FND_API.G_MISS_CHAR,
1136: FND_API.G_MISS_NUM,
1137: FND_API.G_MISS_NUM,
1138: FND_API.G_MISS_NUM,
1139: FND_API.G_MISS_NUM,
1140: FND_API.G_MISS_CHAR,
1141: FND_API.G_MISS_NUM,
1142: l_task_source_obj_type_code,

Line 1139: FND_API.G_MISS_NUM,

1135: FND_API.G_MISS_CHAR,
1136: FND_API.G_MISS_NUM,
1137: FND_API.G_MISS_NUM,
1138: FND_API.G_MISS_NUM,
1139: FND_API.G_MISS_NUM,
1140: FND_API.G_MISS_CHAR,
1141: FND_API.G_MISS_NUM,
1142: l_task_source_obj_type_code,
1143: FND_API.G_MISS_NUM,

Line 1140: FND_API.G_MISS_CHAR,

1136: FND_API.G_MISS_NUM,
1137: FND_API.G_MISS_NUM,
1138: FND_API.G_MISS_NUM,
1139: FND_API.G_MISS_NUM,
1140: FND_API.G_MISS_CHAR,
1141: FND_API.G_MISS_NUM,
1142: l_task_source_obj_type_code,
1143: FND_API.G_MISS_NUM,
1144: NULL,

Line 1141: FND_API.G_MISS_NUM,

1137: FND_API.G_MISS_NUM,
1138: FND_API.G_MISS_NUM,
1139: FND_API.G_MISS_NUM,
1140: FND_API.G_MISS_CHAR,
1141: FND_API.G_MISS_NUM,
1142: l_task_source_obj_type_code,
1143: FND_API.G_MISS_NUM,
1144: NULL,
1145: FND_API.G_MISS_DATE,

Line 1143: FND_API.G_MISS_NUM,

1139: FND_API.G_MISS_NUM,
1140: FND_API.G_MISS_CHAR,
1141: FND_API.G_MISS_NUM,
1142: l_task_source_obj_type_code,
1143: FND_API.G_MISS_NUM,
1144: NULL,
1145: FND_API.G_MISS_DATE,
1146: FND_API.G_MISS_DATE,
1147: FND_API.G_MISS_DATE,

Line 1145: FND_API.G_MISS_DATE,

1141: FND_API.G_MISS_NUM,
1142: l_task_source_obj_type_code,
1143: FND_API.G_MISS_NUM,
1144: NULL,
1145: FND_API.G_MISS_DATE,
1146: FND_API.G_MISS_DATE,
1147: FND_API.G_MISS_DATE,
1148: FND_API.G_MISS_DATE,
1149: FND_API.G_MISS_DATE,

Line 1146: FND_API.G_MISS_DATE,

1142: l_task_source_obj_type_code,
1143: FND_API.G_MISS_NUM,
1144: NULL,
1145: FND_API.G_MISS_DATE,
1146: FND_API.G_MISS_DATE,
1147: FND_API.G_MISS_DATE,
1148: FND_API.G_MISS_DATE,
1149: FND_API.G_MISS_DATE,
1150: FND_API.G_MISS_DATE,

Line 1147: FND_API.G_MISS_DATE,

1143: FND_API.G_MISS_NUM,
1144: NULL,
1145: FND_API.G_MISS_DATE,
1146: FND_API.G_MISS_DATE,
1147: FND_API.G_MISS_DATE,
1148: FND_API.G_MISS_DATE,
1149: FND_API.G_MISS_DATE,
1150: FND_API.G_MISS_DATE,
1151: null,

Line 1148: FND_API.G_MISS_DATE,

1144: NULL,
1145: FND_API.G_MISS_DATE,
1146: FND_API.G_MISS_DATE,
1147: FND_API.G_MISS_DATE,
1148: FND_API.G_MISS_DATE,
1149: FND_API.G_MISS_DATE,
1150: FND_API.G_MISS_DATE,
1151: null,
1152: null,

Line 1149: FND_API.G_MISS_DATE,

1145: FND_API.G_MISS_DATE,
1146: FND_API.G_MISS_DATE,
1147: FND_API.G_MISS_DATE,
1148: FND_API.G_MISS_DATE,
1149: FND_API.G_MISS_DATE,
1150: FND_API.G_MISS_DATE,
1151: null,
1152: null,
1153: null);

Line 1150: FND_API.G_MISS_DATE,

1146: FND_API.G_MISS_DATE,
1147: FND_API.G_MISS_DATE,
1148: FND_API.G_MISS_DATE,
1149: FND_API.G_MISS_DATE,
1150: FND_API.G_MISS_DATE,
1151: null,
1152: null,
1153: null);
1154:

Line 1179: FND_API.G_MISS_CHAR,

1175: END;
1176:
1177: l_def_data_list(l_def_data_list.last) := SYSTEM.DEF_WR_DATA_OBJ(
1178: 'DELETE',
1179: FND_API.G_MISS_CHAR,
1180: FND_API.G_MISS_DATE,
1181: 'TASKS',
1182: l_orig_grp_owner
1183: );

Line 1180: FND_API.G_MISS_DATE,

1176:
1177: l_def_data_list(l_def_data_list.last) := SYSTEM.DEF_WR_DATA_OBJ(
1178: 'DELETE',
1179: FND_API.G_MISS_CHAR,
1180: FND_API.G_MISS_DATE,
1181: 'TASKS',
1182: l_orig_grp_owner
1183: );
1184:

Line 1243: p_init_msg_list => FND_API.G_TRUE,

1239:
1240: if l_entity = 'TASK' then
1241: IEU_WR_PUB.UPDATE_WR_ITEM(
1242: p_api_version => 1.0,
1243: p_init_msg_list => FND_API.G_TRUE,
1244: p_commit => FND_API.G_FALSE,
1245: p_workitem_obj_code => 'TASK',
1246: p_workitem_pk_id => jtf_tasks_pub.p_task_user_hooks.task_id,
1247: p_title => FND_API.G_MISS_CHAR,

Line 1244: p_commit => FND_API.G_FALSE,

1240: if l_entity = 'TASK' then
1241: IEU_WR_PUB.UPDATE_WR_ITEM(
1242: p_api_version => 1.0,
1243: p_init_msg_list => FND_API.G_TRUE,
1244: p_commit => FND_API.G_FALSE,
1245: p_workitem_obj_code => 'TASK',
1246: p_workitem_pk_id => jtf_tasks_pub.p_task_user_hooks.task_id,
1247: p_title => FND_API.G_MISS_CHAR,
1248: p_party_id => FND_API.G_MISS_NUM,

Line 1247: p_title => FND_API.G_MISS_CHAR,

1243: p_init_msg_list => FND_API.G_TRUE,
1244: p_commit => FND_API.G_FALSE,
1245: p_workitem_obj_code => 'TASK',
1246: p_workitem_pk_id => jtf_tasks_pub.p_task_user_hooks.task_id,
1247: p_title => FND_API.G_MISS_CHAR,
1248: p_party_id => FND_API.G_MISS_NUM,
1249: p_priority_code => FND_API.G_MISS_CHAR,
1250: p_due_date => FND_API.G_MISS_DATE,
1251: p_owner_id => FND_API.G_MISS_NUM,

Line 1248: p_party_id => FND_API.G_MISS_NUM,

1244: p_commit => FND_API.G_FALSE,
1245: p_workitem_obj_code => 'TASK',
1246: p_workitem_pk_id => jtf_tasks_pub.p_task_user_hooks.task_id,
1247: p_title => FND_API.G_MISS_CHAR,
1248: p_party_id => FND_API.G_MISS_NUM,
1249: p_priority_code => FND_API.G_MISS_CHAR,
1250: p_due_date => FND_API.G_MISS_DATE,
1251: p_owner_id => FND_API.G_MISS_NUM,
1252: p_owner_type => FND_API.G_MISS_CHAR,

Line 1249: p_priority_code => FND_API.G_MISS_CHAR,

1245: p_workitem_obj_code => 'TASK',
1246: p_workitem_pk_id => jtf_tasks_pub.p_task_user_hooks.task_id,
1247: p_title => FND_API.G_MISS_CHAR,
1248: p_party_id => FND_API.G_MISS_NUM,
1249: p_priority_code => FND_API.G_MISS_CHAR,
1250: p_due_date => FND_API.G_MISS_DATE,
1251: p_owner_id => FND_API.G_MISS_NUM,
1252: p_owner_type => FND_API.G_MISS_CHAR,
1253: p_assignee_id => FND_API.G_MISS_NUM,

Line 1250: p_due_date => FND_API.G_MISS_DATE,

1246: p_workitem_pk_id => jtf_tasks_pub.p_task_user_hooks.task_id,
1247: p_title => FND_API.G_MISS_CHAR,
1248: p_party_id => FND_API.G_MISS_NUM,
1249: p_priority_code => FND_API.G_MISS_CHAR,
1250: p_due_date => FND_API.G_MISS_DATE,
1251: p_owner_id => FND_API.G_MISS_NUM,
1252: p_owner_type => FND_API.G_MISS_CHAR,
1253: p_assignee_id => FND_API.G_MISS_NUM,
1254: p_assignee_type => FND_API.G_MISS_CHAR,

Line 1251: p_owner_id => FND_API.G_MISS_NUM,

1247: p_title => FND_API.G_MISS_CHAR,
1248: p_party_id => FND_API.G_MISS_NUM,
1249: p_priority_code => FND_API.G_MISS_CHAR,
1250: p_due_date => FND_API.G_MISS_DATE,
1251: p_owner_id => FND_API.G_MISS_NUM,
1252: p_owner_type => FND_API.G_MISS_CHAR,
1253: p_assignee_id => FND_API.G_MISS_NUM,
1254: p_assignee_type => FND_API.G_MISS_CHAR,
1255: p_source_object_id => FND_API.G_MISS_NUM,

Line 1252: p_owner_type => FND_API.G_MISS_CHAR,

1248: p_party_id => FND_API.G_MISS_NUM,
1249: p_priority_code => FND_API.G_MISS_CHAR,
1250: p_due_date => FND_API.G_MISS_DATE,
1251: p_owner_id => FND_API.G_MISS_NUM,
1252: p_owner_type => FND_API.G_MISS_CHAR,
1253: p_assignee_id => FND_API.G_MISS_NUM,
1254: p_assignee_type => FND_API.G_MISS_CHAR,
1255: p_source_object_id => FND_API.G_MISS_NUM,
1256: p_source_object_type_code => FND_API.G_MISS_CHAR,

Line 1253: p_assignee_id => FND_API.G_MISS_NUM,

1249: p_priority_code => FND_API.G_MISS_CHAR,
1250: p_due_date => FND_API.G_MISS_DATE,
1251: p_owner_id => FND_API.G_MISS_NUM,
1252: p_owner_type => FND_API.G_MISS_CHAR,
1253: p_assignee_id => FND_API.G_MISS_NUM,
1254: p_assignee_type => FND_API.G_MISS_CHAR,
1255: p_source_object_id => FND_API.G_MISS_NUM,
1256: p_source_object_type_code => FND_API.G_MISS_CHAR,
1257: p_application_id => 690,

Line 1254: p_assignee_type => FND_API.G_MISS_CHAR,

1250: p_due_date => FND_API.G_MISS_DATE,
1251: p_owner_id => FND_API.G_MISS_NUM,
1252: p_owner_type => FND_API.G_MISS_CHAR,
1253: p_assignee_id => FND_API.G_MISS_NUM,
1254: p_assignee_type => FND_API.G_MISS_CHAR,
1255: p_source_object_id => FND_API.G_MISS_NUM,
1256: p_source_object_type_code => FND_API.G_MISS_CHAR,
1257: p_application_id => 690,
1258: p_work_item_status => 'DELETE',

Line 1255: p_source_object_id => FND_API.G_MISS_NUM,

1251: p_owner_id => FND_API.G_MISS_NUM,
1252: p_owner_type => FND_API.G_MISS_CHAR,
1253: p_assignee_id => FND_API.G_MISS_NUM,
1254: p_assignee_type => FND_API.G_MISS_CHAR,
1255: p_source_object_id => FND_API.G_MISS_NUM,
1256: p_source_object_type_code => FND_API.G_MISS_CHAR,
1257: p_application_id => 690,
1258: p_work_item_status => 'DELETE',
1259: p_user_id => FND_GLOBAL.USER_ID,

Line 1256: p_source_object_type_code => FND_API.G_MISS_CHAR,

1252: p_owner_type => FND_API.G_MISS_CHAR,
1253: p_assignee_id => FND_API.G_MISS_NUM,
1254: p_assignee_type => FND_API.G_MISS_CHAR,
1255: p_source_object_id => FND_API.G_MISS_NUM,
1256: p_source_object_type_code => FND_API.G_MISS_CHAR,
1257: p_application_id => 690,
1258: p_work_item_status => 'DELETE',
1259: p_user_id => FND_GLOBAL.USER_ID,
1260: p_login_id => FND_GLOBAL.LOGIN_ID,

Line 1268: x_return_status := fnd_api.g_ret_sts_success;

1264: x_return_status => L_RETURN_STATUS);
1265:
1266: x_return_status := l_return_status;
1267: else
1268: x_return_status := fnd_api.g_ret_sts_success;
1269: end if;
1270: else /* Work Item does not exist in Work Repository */
1271:
1272: --insert into p_temp values('ret success');

Line 1273: x_return_status := fnd_api.g_ret_sts_success;

1269: end if;
1270: else /* Work Item does not exist in Work Repository */
1271:
1272: --insert into p_temp values('ret success');
1273: x_return_status := fnd_api.g_ret_sts_success;
1274: end if;
1275:
1276: if (x_return_status = fnd_api.g_ret_sts_success)
1277: then

Line 1276: if (x_return_status = fnd_api.g_ret_sts_success)

1272: --insert into p_temp values('ret success');
1273: x_return_status := fnd_api.g_ret_sts_success;
1274: end if;
1275:
1276: if (x_return_status = fnd_api.g_ret_sts_success)
1277: then
1278: l_del_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;
1279: --insert into p_temp values ('del tsk id: '||l_del_task_id);
1280: end if;

Line 1284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1280: end if;
1281:
1282: EXCEPTION WHEN OTHERS THEN
1283: --insert into p_temp values('excep');
1284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1285:
1286: END;
1287:
1288: end if; /* Tasks Rules Func */

Line 1290: x_return_status := FND_API.G_RET_STS_SUCCESS;

1286: END;
1287:
1288: end if; /* Tasks Rules Func */
1289: elsif l_activation_status = 'N' then
1290: x_return_status := FND_API.G_RET_STS_SUCCESS;
1291: end if;
1292: end delete_task_uwqm_pre;
1293:
1294: PROCEDURE create_task_assign_uwqm_pre ( x_return_status OUT NOCOPY VARCHAR2 ) As

Line 1540: FND_API.G_MISS_CHAR,

1536: l_tasks_data_list(l_tasks_data_list.last) := SYSTEM.WR_TASKS_DATA_OBJ (
1537: 'CREATE_TASK_ASG',
1538: jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
1539: null,
1540: FND_API.G_MISS_CHAR,
1541: FND_API.G_MISS_CHAR,
1542: FND_API.G_MISS_NUM,
1543: FND_API.G_MISS_NUM,
1544: FND_API.G_MISS_NUM,

Line 1541: FND_API.G_MISS_CHAR,

1537: 'CREATE_TASK_ASG',
1538: jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
1539: null,
1540: FND_API.G_MISS_CHAR,
1541: FND_API.G_MISS_CHAR,
1542: FND_API.G_MISS_NUM,
1543: FND_API.G_MISS_NUM,
1544: FND_API.G_MISS_NUM,
1545: FND_API.G_MISS_NUM,

Line 1542: FND_API.G_MISS_NUM,

1538: jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
1539: null,
1540: FND_API.G_MISS_CHAR,
1541: FND_API.G_MISS_CHAR,
1542: FND_API.G_MISS_NUM,
1543: FND_API.G_MISS_NUM,
1544: FND_API.G_MISS_NUM,
1545: FND_API.G_MISS_NUM,
1546: FND_API.G_MISS_CHAR,

Line 1543: FND_API.G_MISS_NUM,

1539: null,
1540: FND_API.G_MISS_CHAR,
1541: FND_API.G_MISS_CHAR,
1542: FND_API.G_MISS_NUM,
1543: FND_API.G_MISS_NUM,
1544: FND_API.G_MISS_NUM,
1545: FND_API.G_MISS_NUM,
1546: FND_API.G_MISS_CHAR,
1547: FND_API.G_MISS_NUM,

Line 1544: FND_API.G_MISS_NUM,

1540: FND_API.G_MISS_CHAR,
1541: FND_API.G_MISS_CHAR,
1542: FND_API.G_MISS_NUM,
1543: FND_API.G_MISS_NUM,
1544: FND_API.G_MISS_NUM,
1545: FND_API.G_MISS_NUM,
1546: FND_API.G_MISS_CHAR,
1547: FND_API.G_MISS_NUM,
1548: l_task_source_obj_type_code,

Line 1545: FND_API.G_MISS_NUM,

1541: FND_API.G_MISS_CHAR,
1542: FND_API.G_MISS_NUM,
1543: FND_API.G_MISS_NUM,
1544: FND_API.G_MISS_NUM,
1545: FND_API.G_MISS_NUM,
1546: FND_API.G_MISS_CHAR,
1547: FND_API.G_MISS_NUM,
1548: l_task_source_obj_type_code,
1549: FND_API.G_MISS_NUM,

Line 1546: FND_API.G_MISS_CHAR,

1542: FND_API.G_MISS_NUM,
1543: FND_API.G_MISS_NUM,
1544: FND_API.G_MISS_NUM,
1545: FND_API.G_MISS_NUM,
1546: FND_API.G_MISS_CHAR,
1547: FND_API.G_MISS_NUM,
1548: l_task_source_obj_type_code,
1549: FND_API.G_MISS_NUM,
1550: NULL,

Line 1547: FND_API.G_MISS_NUM,

1543: FND_API.G_MISS_NUM,
1544: FND_API.G_MISS_NUM,
1545: FND_API.G_MISS_NUM,
1546: FND_API.G_MISS_CHAR,
1547: FND_API.G_MISS_NUM,
1548: l_task_source_obj_type_code,
1549: FND_API.G_MISS_NUM,
1550: NULL,
1551: FND_API.G_MISS_DATE,

Line 1549: FND_API.G_MISS_NUM,

1545: FND_API.G_MISS_NUM,
1546: FND_API.G_MISS_CHAR,
1547: FND_API.G_MISS_NUM,
1548: l_task_source_obj_type_code,
1549: FND_API.G_MISS_NUM,
1550: NULL,
1551: FND_API.G_MISS_DATE,
1552: FND_API.G_MISS_DATE,
1553: FND_API.G_MISS_DATE,

Line 1551: FND_API.G_MISS_DATE,

1547: FND_API.G_MISS_NUM,
1548: l_task_source_obj_type_code,
1549: FND_API.G_MISS_NUM,
1550: NULL,
1551: FND_API.G_MISS_DATE,
1552: FND_API.G_MISS_DATE,
1553: FND_API.G_MISS_DATE,
1554: FND_API.G_MISS_DATE,
1555: FND_API.G_MISS_DATE,

Line 1552: FND_API.G_MISS_DATE,

1548: l_task_source_obj_type_code,
1549: FND_API.G_MISS_NUM,
1550: NULL,
1551: FND_API.G_MISS_DATE,
1552: FND_API.G_MISS_DATE,
1553: FND_API.G_MISS_DATE,
1554: FND_API.G_MISS_DATE,
1555: FND_API.G_MISS_DATE,
1556: FND_API.G_MISS_DATE,

Line 1553: FND_API.G_MISS_DATE,

1549: FND_API.G_MISS_NUM,
1550: NULL,
1551: FND_API.G_MISS_DATE,
1552: FND_API.G_MISS_DATE,
1553: FND_API.G_MISS_DATE,
1554: FND_API.G_MISS_DATE,
1555: FND_API.G_MISS_DATE,
1556: FND_API.G_MISS_DATE,
1557: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code,

Line 1554: FND_API.G_MISS_DATE,

1550: NULL,
1551: FND_API.G_MISS_DATE,
1552: FND_API.G_MISS_DATE,
1553: FND_API.G_MISS_DATE,
1554: FND_API.G_MISS_DATE,
1555: FND_API.G_MISS_DATE,
1556: FND_API.G_MISS_DATE,
1557: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code,
1558: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id,

Line 1555: FND_API.G_MISS_DATE,

1551: FND_API.G_MISS_DATE,
1552: FND_API.G_MISS_DATE,
1553: FND_API.G_MISS_DATE,
1554: FND_API.G_MISS_DATE,
1555: FND_API.G_MISS_DATE,
1556: FND_API.G_MISS_DATE,
1557: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code,
1558: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id,
1559: jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id);

Line 1556: FND_API.G_MISS_DATE,

1552: FND_API.G_MISS_DATE,
1553: FND_API.G_MISS_DATE,
1554: FND_API.G_MISS_DATE,
1555: FND_API.G_MISS_DATE,
1556: FND_API.G_MISS_DATE,
1557: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code,
1558: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id,
1559: jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id);
1560:

Line 1585: FND_API.G_MISS_CHAR,

1581: l_orig_grp_owner := null;
1582: END;
1583:
1584: l_def_data_list(l_def_data_list.last) := SYSTEM.DEF_WR_DATA_OBJ(
1585: FND_API.G_MISS_CHAR,
1586: FND_API.G_MISS_CHAR,
1587: l_ins_due_date,
1588: 'TASKS',
1589: l_orig_grp_owner

Line 1586: FND_API.G_MISS_CHAR,

1582: END;
1583:
1584: l_def_data_list(l_def_data_list.last) := SYSTEM.DEF_WR_DATA_OBJ(
1585: FND_API.G_MISS_CHAR,
1586: FND_API.G_MISS_CHAR,
1587: l_ins_due_date,
1588: 'TASKS',
1589: l_orig_grp_owner
1590: );

Line 1651: x_return_status := fnd_api.g_ret_sts_success;

1647: if ( ( (l_task_status = 'CLOSE') or (l_del_flag = 'Y') )
1648: and (l_wi_exists = 'N'))
1649: then
1650: -- insert into p_temp(msg) values ('close/del and rec does not exists.. ret success');
1651: x_return_status := fnd_api.g_ret_sts_success;
1652: else
1653: -- insert into p_temp(msg) values (' else condn');
1654: if (l_wi_exists = 'N')
1655: then

Line 1680: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1676: exception
1677: when others then
1678: null;
1679: -- insert into p_temp(msg) values('raising err ');
1680: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1681: --raise;
1682: end;
1683:
1684:

Line 1727: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1723: -- and workitem_obj_code = 'TASK';
1724: and workitem_obj_code = l_workitem_obj_code;
1725: EXCEPTION WHEN others THEN
1726: null;
1727: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1728: -- l_msg_data := 'Work item does not exist in the WR ';
1729: --raise;
1730:
1731: end ;

Line 1953: p_init_msg_list => FND_API.G_TRUE,

1949: -- insert into p_temp(msg) values (' calling insert ');
1950:
1951: IEU_WR_PUB.CREATE_WR_ITEM(
1952: p_api_version => 1.0,
1953: p_init_msg_list => FND_API.G_TRUE,
1954: p_commit => FND_API.G_true,
1955: p_workitem_obj_code => 'TASK',
1956: p_workitem_pk_id => l_ins_task_id,
1957: p_work_item_number => l_ins_task_number,

Line 1954: p_commit => FND_API.G_true,

1950:
1951: IEU_WR_PUB.CREATE_WR_ITEM(
1952: p_api_version => 1.0,
1953: p_init_msg_list => FND_API.G_TRUE,
1954: p_commit => FND_API.G_true,
1955: p_workitem_obj_code => 'TASK',
1956: p_workitem_pk_id => l_ins_task_id,
1957: p_work_item_number => l_ins_task_number,
1958: p_title => l_ins_task_name,

Line 1983: p_init_msg_list => FND_API.G_TRUE,

1979:
1980: --insert into p_temp(msg) values (' calling update ');
1981: IEU_WR_PUB.UPDATE_WR_ITEM(
1982: p_api_version => 1.0,
1983: p_init_msg_list => FND_API.G_TRUE,
1984: p_commit => FND_API.G_FALSE,
1985: p_workitem_obj_code => 'TASK',
1986: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
1987: p_title => FND_API.G_MISS_CHAR,

Line 1984: p_commit => FND_API.G_FALSE,

1980: --insert into p_temp(msg) values (' calling update ');
1981: IEU_WR_PUB.UPDATE_WR_ITEM(
1982: p_api_version => 1.0,
1983: p_init_msg_list => FND_API.G_TRUE,
1984: p_commit => FND_API.G_FALSE,
1985: p_workitem_obj_code => 'TASK',
1986: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
1987: p_title => FND_API.G_MISS_CHAR,
1988: p_party_id => FND_API.G_MISS_NUM,

Line 1987: p_title => FND_API.G_MISS_CHAR,

1983: p_init_msg_list => FND_API.G_TRUE,
1984: p_commit => FND_API.G_FALSE,
1985: p_workitem_obj_code => 'TASK',
1986: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
1987: p_title => FND_API.G_MISS_CHAR,
1988: p_party_id => FND_API.G_MISS_NUM,
1989: p_priority_code => FND_API.G_MISS_CHAR,
1990: p_due_date => l_ins_due_date,
1991: p_owner_id => FND_API.G_MISS_NUM,

Line 1988: p_party_id => FND_API.G_MISS_NUM,

1984: p_commit => FND_API.G_FALSE,
1985: p_workitem_obj_code => 'TASK',
1986: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
1987: p_title => FND_API.G_MISS_CHAR,
1988: p_party_id => FND_API.G_MISS_NUM,
1989: p_priority_code => FND_API.G_MISS_CHAR,
1990: p_due_date => l_ins_due_date,
1991: p_owner_id => FND_API.G_MISS_NUM,
1992: p_owner_type => FND_API.G_MISS_CHAR,

Line 1989: p_priority_code => FND_API.G_MISS_CHAR,

1985: p_workitem_obj_code => 'TASK',
1986: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
1987: p_title => FND_API.G_MISS_CHAR,
1988: p_party_id => FND_API.G_MISS_NUM,
1989: p_priority_code => FND_API.G_MISS_CHAR,
1990: p_due_date => l_ins_due_date,
1991: p_owner_id => FND_API.G_MISS_NUM,
1992: p_owner_type => FND_API.G_MISS_CHAR,
1993: p_assignee_id => l_assignee_id,

Line 1991: p_owner_id => FND_API.G_MISS_NUM,

1987: p_title => FND_API.G_MISS_CHAR,
1988: p_party_id => FND_API.G_MISS_NUM,
1989: p_priority_code => FND_API.G_MISS_CHAR,
1990: p_due_date => l_ins_due_date,
1991: p_owner_id => FND_API.G_MISS_NUM,
1992: p_owner_type => FND_API.G_MISS_CHAR,
1993: p_assignee_id => l_assignee_id,
1994: p_assignee_type => l_assignee_type,
1995: p_source_object_id => FND_API.G_MISS_NUM,

Line 1992: p_owner_type => FND_API.G_MISS_CHAR,

1988: p_party_id => FND_API.G_MISS_NUM,
1989: p_priority_code => FND_API.G_MISS_CHAR,
1990: p_due_date => l_ins_due_date,
1991: p_owner_id => FND_API.G_MISS_NUM,
1992: p_owner_type => FND_API.G_MISS_CHAR,
1993: p_assignee_id => l_assignee_id,
1994: p_assignee_type => l_assignee_type,
1995: p_source_object_id => FND_API.G_MISS_NUM,
1996: p_source_object_type_code => FND_API.G_MISS_CHAR,

Line 1995: p_source_object_id => FND_API.G_MISS_NUM,

1991: p_owner_id => FND_API.G_MISS_NUM,
1992: p_owner_type => FND_API.G_MISS_CHAR,
1993: p_assignee_id => l_assignee_id,
1994: p_assignee_type => l_assignee_type,
1995: p_source_object_id => FND_API.G_MISS_NUM,
1996: p_source_object_type_code => FND_API.G_MISS_CHAR,
1997: p_application_id => 690,
1998: p_user_id => FND_GLOBAL.USER_ID,
1999: p_login_id => FND_GLOBAL.LOGIN_ID,

Line 1996: p_source_object_type_code => FND_API.G_MISS_CHAR,

1992: p_owner_type => FND_API.G_MISS_CHAR,
1993: p_assignee_id => l_assignee_id,
1994: p_assignee_type => l_assignee_type,
1995: p_source_object_id => FND_API.G_MISS_NUM,
1996: p_source_object_type_code => FND_API.G_MISS_CHAR,
1997: p_application_id => 690,
1998: p_user_id => FND_GLOBAL.USER_ID,
1999: p_login_id => FND_GLOBAL.LOGIN_ID,
2000: p_work_item_status => FND_API.G_MISS_CHAR,

Line 2000: p_work_item_status => FND_API.G_MISS_CHAR,

1996: p_source_object_type_code => FND_API.G_MISS_CHAR,
1997: p_application_id => 690,
1998: p_user_id => FND_GLOBAL.USER_ID,
1999: p_login_id => FND_GLOBAL.LOGIN_ID,
2000: p_work_item_status => FND_API.G_MISS_CHAR,
2001: p_audit_trail_rec => l_audit_trail_rec,
2002: x_msg_count => L_MSG_COUNT,
2003: x_msg_data => L_MSG_DATA,
2004: x_return_status => L_RETURN_STATUS);

Line 2021: p_init_msg_list => FND_API.G_TRUE,

2017:
2018: --insert into p_temp(msg) values (' calling update ');
2019: IEU_WR_PUB.UPDATE_WR_ITEM(
2020: p_api_version => 1.0,
2021: p_init_msg_list => FND_API.G_TRUE,
2022: p_commit => FND_API.G_FALSE,
2023: p_workitem_obj_code => 'TASK',
2024: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2025: p_title => FND_API.G_MISS_CHAR,

Line 2022: p_commit => FND_API.G_FALSE,

2018: --insert into p_temp(msg) values (' calling update ');
2019: IEU_WR_PUB.UPDATE_WR_ITEM(
2020: p_api_version => 1.0,
2021: p_init_msg_list => FND_API.G_TRUE,
2022: p_commit => FND_API.G_FALSE,
2023: p_workitem_obj_code => 'TASK',
2024: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2025: p_title => FND_API.G_MISS_CHAR,
2026: p_party_id => FND_API.G_MISS_NUM,

Line 2025: p_title => FND_API.G_MISS_CHAR,

2021: p_init_msg_list => FND_API.G_TRUE,
2022: p_commit => FND_API.G_FALSE,
2023: p_workitem_obj_code => 'TASK',
2024: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2025: p_title => FND_API.G_MISS_CHAR,
2026: p_party_id => FND_API.G_MISS_NUM,
2027: p_priority_code => FND_API.G_MISS_CHAR,
2028: p_due_date => l_ins_due_date,
2029: p_owner_id => FND_API.G_MISS_NUM,

Line 2026: p_party_id => FND_API.G_MISS_NUM,

2022: p_commit => FND_API.G_FALSE,
2023: p_workitem_obj_code => 'TASK',
2024: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2025: p_title => FND_API.G_MISS_CHAR,
2026: p_party_id => FND_API.G_MISS_NUM,
2027: p_priority_code => FND_API.G_MISS_CHAR,
2028: p_due_date => l_ins_due_date,
2029: p_owner_id => FND_API.G_MISS_NUM,
2030: p_owner_type => FND_API.G_MISS_CHAR,

Line 2027: p_priority_code => FND_API.G_MISS_CHAR,

2023: p_workitem_obj_code => 'TASK',
2024: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2025: p_title => FND_API.G_MISS_CHAR,
2026: p_party_id => FND_API.G_MISS_NUM,
2027: p_priority_code => FND_API.G_MISS_CHAR,
2028: p_due_date => l_ins_due_date,
2029: p_owner_id => FND_API.G_MISS_NUM,
2030: p_owner_type => FND_API.G_MISS_CHAR,
2031: p_assignee_id => l_assignee_id,

Line 2029: p_owner_id => FND_API.G_MISS_NUM,

2025: p_title => FND_API.G_MISS_CHAR,
2026: p_party_id => FND_API.G_MISS_NUM,
2027: p_priority_code => FND_API.G_MISS_CHAR,
2028: p_due_date => l_ins_due_date,
2029: p_owner_id => FND_API.G_MISS_NUM,
2030: p_owner_type => FND_API.G_MISS_CHAR,
2031: p_assignee_id => l_assignee_id,
2032: p_assignee_type => l_assignee_type,
2033: p_source_object_id => FND_API.G_MISS_NUM,

Line 2030: p_owner_type => FND_API.G_MISS_CHAR,

2026: p_party_id => FND_API.G_MISS_NUM,
2027: p_priority_code => FND_API.G_MISS_CHAR,
2028: p_due_date => l_ins_due_date,
2029: p_owner_id => FND_API.G_MISS_NUM,
2030: p_owner_type => FND_API.G_MISS_CHAR,
2031: p_assignee_id => l_assignee_id,
2032: p_assignee_type => l_assignee_type,
2033: p_source_object_id => FND_API.G_MISS_NUM,
2034: p_source_object_type_code => FND_API.G_MISS_CHAR,

Line 2033: p_source_object_id => FND_API.G_MISS_NUM,

2029: p_owner_id => FND_API.G_MISS_NUM,
2030: p_owner_type => FND_API.G_MISS_CHAR,
2031: p_assignee_id => l_assignee_id,
2032: p_assignee_type => l_assignee_type,
2033: p_source_object_id => FND_API.G_MISS_NUM,
2034: p_source_object_type_code => FND_API.G_MISS_CHAR,
2035: p_application_id => 690,
2036: p_user_id => FND_GLOBAL.USER_ID,
2037: p_login_id => FND_GLOBAL.LOGIN_ID,

Line 2034: p_source_object_type_code => FND_API.G_MISS_CHAR,

2030: p_owner_type => FND_API.G_MISS_CHAR,
2031: p_assignee_id => l_assignee_id,
2032: p_assignee_type => l_assignee_type,
2033: p_source_object_id => FND_API.G_MISS_NUM,
2034: p_source_object_type_code => FND_API.G_MISS_CHAR,
2035: p_application_id => 690,
2036: p_user_id => FND_GLOBAL.USER_ID,
2037: p_login_id => FND_GLOBAL.LOGIN_ID,
2038: p_work_item_status => FND_API.G_MISS_CHAR,

Line 2038: p_work_item_status => FND_API.G_MISS_CHAR,

2034: p_source_object_type_code => FND_API.G_MISS_CHAR,
2035: p_application_id => 690,
2036: p_user_id => FND_GLOBAL.USER_ID,
2037: p_login_id => FND_GLOBAL.LOGIN_ID,
2038: p_work_item_status => FND_API.G_MISS_CHAR,
2039: p_audit_trail_rec => l_audit_trail_rec,
2040: x_msg_count => L_MSG_COUNT,
2041: x_msg_data => L_MSG_DATA,
2042: x_return_status => L_RETURN_STATUS);

Line 2051: x_return_status := fnd_api.g_ret_sts_success;

2047: elsif (l_entity <> 'TASK')
2048: --or (nvl(l_group_id, 'N') = 'N')
2049: then
2050: -- insert into p_temp(msg) values (' wr proc was not called..returning success ');
2051: x_return_status := fnd_api.g_ret_sts_success;
2052: end if;
2053: ELSE -- Niraj, 4220060
2054: x_return_status := fnd_api.g_ret_sts_success; -- Niraj, 4220060
2055: END IF; -- Niraj, 4220060

Line 2054: x_return_status := fnd_api.g_ret_sts_success; -- Niraj, 4220060

2050: -- insert into p_temp(msg) values (' wr proc was not called..returning success ');
2051: x_return_status := fnd_api.g_ret_sts_success;
2052: end if;
2053: ELSE -- Niraj, 4220060
2054: x_return_status := fnd_api.g_ret_sts_success; -- Niraj, 4220060
2055: END IF; -- Niraj, 4220060
2056: -- End 'l_update_wr_item_call' check
2057:
2058: end if; /* Work Item exists in UWQ Work Repository */

Line 2061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2057:
2058: end if; /* Work Item exists in UWQ Work Repository */
2059:
2060: EXCEPTION WHEN OTHERS THEN
2061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2062:
2063: END;
2064:
2065: end if; /* Tasks Rules Func */

Line 2067: x_return_status := FND_API.G_RET_STS_SUCCESS;

2063: END;
2064:
2065: end if; /* Tasks Rules Func */
2066: elsif l_activation_status = 'N' then
2067: x_return_status := FND_API.G_RET_STS_SUCCESS;
2068: end if;
2069: end create_task_assign_uwqm_pre;
2070:
2071:

Line 2325: FND_API.G_MISS_CHAR,

2321: l_tasks_data_list(l_tasks_data_list.last) := SYSTEM.WR_TASKS_DATA_OBJ (
2322: 'UPDATE_TASK_ASG',
2323: jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2324: null,
2325: FND_API.G_MISS_CHAR,
2326: FND_API.G_MISS_CHAR,
2327: FND_API.G_MISS_NUM,
2328: FND_API.G_MISS_NUM,
2329: FND_API.G_MISS_NUM,

Line 2326: FND_API.G_MISS_CHAR,

2322: 'UPDATE_TASK_ASG',
2323: jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2324: null,
2325: FND_API.G_MISS_CHAR,
2326: FND_API.G_MISS_CHAR,
2327: FND_API.G_MISS_NUM,
2328: FND_API.G_MISS_NUM,
2329: FND_API.G_MISS_NUM,
2330: FND_API.G_MISS_NUM,

Line 2327: FND_API.G_MISS_NUM,

2323: jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2324: null,
2325: FND_API.G_MISS_CHAR,
2326: FND_API.G_MISS_CHAR,
2327: FND_API.G_MISS_NUM,
2328: FND_API.G_MISS_NUM,
2329: FND_API.G_MISS_NUM,
2330: FND_API.G_MISS_NUM,
2331: FND_API.G_MISS_CHAR,

Line 2328: FND_API.G_MISS_NUM,

2324: null,
2325: FND_API.G_MISS_CHAR,
2326: FND_API.G_MISS_CHAR,
2327: FND_API.G_MISS_NUM,
2328: FND_API.G_MISS_NUM,
2329: FND_API.G_MISS_NUM,
2330: FND_API.G_MISS_NUM,
2331: FND_API.G_MISS_CHAR,
2332: FND_API.G_MISS_NUM,

Line 2329: FND_API.G_MISS_NUM,

2325: FND_API.G_MISS_CHAR,
2326: FND_API.G_MISS_CHAR,
2327: FND_API.G_MISS_NUM,
2328: FND_API.G_MISS_NUM,
2329: FND_API.G_MISS_NUM,
2330: FND_API.G_MISS_NUM,
2331: FND_API.G_MISS_CHAR,
2332: FND_API.G_MISS_NUM,
2333: l_task_source_obj_type_code,

Line 2330: FND_API.G_MISS_NUM,

2326: FND_API.G_MISS_CHAR,
2327: FND_API.G_MISS_NUM,
2328: FND_API.G_MISS_NUM,
2329: FND_API.G_MISS_NUM,
2330: FND_API.G_MISS_NUM,
2331: FND_API.G_MISS_CHAR,
2332: FND_API.G_MISS_NUM,
2333: l_task_source_obj_type_code,
2334: FND_API.G_MISS_NUM,

Line 2331: FND_API.G_MISS_CHAR,

2327: FND_API.G_MISS_NUM,
2328: FND_API.G_MISS_NUM,
2329: FND_API.G_MISS_NUM,
2330: FND_API.G_MISS_NUM,
2331: FND_API.G_MISS_CHAR,
2332: FND_API.G_MISS_NUM,
2333: l_task_source_obj_type_code,
2334: FND_API.G_MISS_NUM,
2335: NULL,

Line 2332: FND_API.G_MISS_NUM,

2328: FND_API.G_MISS_NUM,
2329: FND_API.G_MISS_NUM,
2330: FND_API.G_MISS_NUM,
2331: FND_API.G_MISS_CHAR,
2332: FND_API.G_MISS_NUM,
2333: l_task_source_obj_type_code,
2334: FND_API.G_MISS_NUM,
2335: NULL,
2336: FND_API.G_MISS_DATE,

Line 2334: FND_API.G_MISS_NUM,

2330: FND_API.G_MISS_NUM,
2331: FND_API.G_MISS_CHAR,
2332: FND_API.G_MISS_NUM,
2333: l_task_source_obj_type_code,
2334: FND_API.G_MISS_NUM,
2335: NULL,
2336: FND_API.G_MISS_DATE,
2337: FND_API.G_MISS_DATE,
2338: FND_API.G_MISS_DATE,

Line 2336: FND_API.G_MISS_DATE,

2332: FND_API.G_MISS_NUM,
2333: l_task_source_obj_type_code,
2334: FND_API.G_MISS_NUM,
2335: NULL,
2336: FND_API.G_MISS_DATE,
2337: FND_API.G_MISS_DATE,
2338: FND_API.G_MISS_DATE,
2339: FND_API.G_MISS_DATE,
2340: FND_API.G_MISS_DATE,

Line 2337: FND_API.G_MISS_DATE,

2333: l_task_source_obj_type_code,
2334: FND_API.G_MISS_NUM,
2335: NULL,
2336: FND_API.G_MISS_DATE,
2337: FND_API.G_MISS_DATE,
2338: FND_API.G_MISS_DATE,
2339: FND_API.G_MISS_DATE,
2340: FND_API.G_MISS_DATE,
2341: FND_API.G_MISS_DATE,

Line 2338: FND_API.G_MISS_DATE,

2334: FND_API.G_MISS_NUM,
2335: NULL,
2336: FND_API.G_MISS_DATE,
2337: FND_API.G_MISS_DATE,
2338: FND_API.G_MISS_DATE,
2339: FND_API.G_MISS_DATE,
2340: FND_API.G_MISS_DATE,
2341: FND_API.G_MISS_DATE,
2342: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code,

Line 2339: FND_API.G_MISS_DATE,

2335: NULL,
2336: FND_API.G_MISS_DATE,
2337: FND_API.G_MISS_DATE,
2338: FND_API.G_MISS_DATE,
2339: FND_API.G_MISS_DATE,
2340: FND_API.G_MISS_DATE,
2341: FND_API.G_MISS_DATE,
2342: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code,
2343: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id,

Line 2340: FND_API.G_MISS_DATE,

2336: FND_API.G_MISS_DATE,
2337: FND_API.G_MISS_DATE,
2338: FND_API.G_MISS_DATE,
2339: FND_API.G_MISS_DATE,
2340: FND_API.G_MISS_DATE,
2341: FND_API.G_MISS_DATE,
2342: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code,
2343: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id,
2344: jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id);

Line 2341: FND_API.G_MISS_DATE,

2337: FND_API.G_MISS_DATE,
2338: FND_API.G_MISS_DATE,
2339: FND_API.G_MISS_DATE,
2340: FND_API.G_MISS_DATE,
2341: FND_API.G_MISS_DATE,
2342: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code,
2343: jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id,
2344: jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id);
2345:

Line 2370: FND_API.G_MISS_CHAR,

2366: l_orig_grp_owner := null;
2367: END;
2368:
2369: l_def_data_list(l_def_data_list.last) := SYSTEM.DEF_WR_DATA_OBJ(
2370: FND_API.G_MISS_CHAR,
2371: FND_API.G_MISS_CHAR,
2372: l_ins_due_date,
2373: 'TASKS',
2374: l_orig_grp_owner

Line 2371: FND_API.G_MISS_CHAR,

2367: END;
2368:
2369: l_def_data_list(l_def_data_list.last) := SYSTEM.DEF_WR_DATA_OBJ(
2370: FND_API.G_MISS_CHAR,
2371: FND_API.G_MISS_CHAR,
2372: l_ins_due_date,
2373: 'TASKS',
2374: l_orig_grp_owner
2375: );

Line 2441: x_return_status := fnd_api.g_ret_sts_success;

2437: if ( ( (l_task_status = 'CLOSE') or (l_del_flag = 'Y') )
2438: and (l_wi_exists = 'N'))
2439: then
2440: -- insert into p_temp(msg) values ('close/del and rec does not exists.. ret success');
2441: x_return_status := fnd_api.g_ret_sts_success;
2442: else
2443: -- If the work item status is not closed or deleted and if the work item does not exist in Work Repository
2444: -- then create the work item
2445: if (l_wi_exists = 'N')

Line 2472: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2468: exception
2469: when others then
2470: null;
2471: -- insert into p_temp values('raising err ');
2472: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2473: --raise;
2474: end;
2475:
2476: l_owner_id := l_ins_owner_id;

Line 2698: p_init_msg_list => FND_API.G_TRUE,

2694: -- insert into p_temp values (' calling insert ');
2695:
2696: IEU_WR_PUB.CREATE_WR_ITEM(
2697: p_api_version => 1.0,
2698: p_init_msg_list => FND_API.G_TRUE,
2699: p_commit => FND_API.G_true,
2700: p_workitem_obj_code => 'TASK',
2701: p_workitem_pk_id => l_ins_task_id,
2702: p_work_item_number => l_ins_task_number,

Line 2699: p_commit => FND_API.G_true,

2695:
2696: IEU_WR_PUB.CREATE_WR_ITEM(
2697: p_api_version => 1.0,
2698: p_init_msg_list => FND_API.G_TRUE,
2699: p_commit => FND_API.G_true,
2700: p_workitem_obj_code => 'TASK',
2701: p_workitem_pk_id => l_ins_task_id,
2702: p_work_item_number => l_ins_task_number,
2703: p_title => l_ins_task_name,

Line 2728: p_init_msg_list => FND_API.G_TRUE,

2724:
2725: -- insert into p_temp values(' calling update wr item' );
2726: IEU_WR_PUB.UPDATE_WR_ITEM(
2727: p_api_version => 1.0,
2728: p_init_msg_list => FND_API.G_TRUE,
2729: p_commit => FND_API.G_FALSE,
2730: p_workitem_obj_code => 'TASK',
2731: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2732: p_title => FND_API.G_MISS_CHAR,

Line 2729: p_commit => FND_API.G_FALSE,

2725: -- insert into p_temp values(' calling update wr item' );
2726: IEU_WR_PUB.UPDATE_WR_ITEM(
2727: p_api_version => 1.0,
2728: p_init_msg_list => FND_API.G_TRUE,
2729: p_commit => FND_API.G_FALSE,
2730: p_workitem_obj_code => 'TASK',
2731: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2732: p_title => FND_API.G_MISS_CHAR,
2733: p_party_id => FND_API.G_MISS_NUM,

Line 2732: p_title => FND_API.G_MISS_CHAR,

2728: p_init_msg_list => FND_API.G_TRUE,
2729: p_commit => FND_API.G_FALSE,
2730: p_workitem_obj_code => 'TASK',
2731: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2732: p_title => FND_API.G_MISS_CHAR,
2733: p_party_id => FND_API.G_MISS_NUM,
2734: p_priority_code => FND_API.G_MISS_CHAR,
2735: p_due_date => l_ins_due_date,
2736: p_owner_id => FND_API.G_MISS_NUM,

Line 2733: p_party_id => FND_API.G_MISS_NUM,

2729: p_commit => FND_API.G_FALSE,
2730: p_workitem_obj_code => 'TASK',
2731: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2732: p_title => FND_API.G_MISS_CHAR,
2733: p_party_id => FND_API.G_MISS_NUM,
2734: p_priority_code => FND_API.G_MISS_CHAR,
2735: p_due_date => l_ins_due_date,
2736: p_owner_id => FND_API.G_MISS_NUM,
2737: p_owner_type => FND_API.G_MISS_CHAR,

Line 2734: p_priority_code => FND_API.G_MISS_CHAR,

2730: p_workitem_obj_code => 'TASK',
2731: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2732: p_title => FND_API.G_MISS_CHAR,
2733: p_party_id => FND_API.G_MISS_NUM,
2734: p_priority_code => FND_API.G_MISS_CHAR,
2735: p_due_date => l_ins_due_date,
2736: p_owner_id => FND_API.G_MISS_NUM,
2737: p_owner_type => FND_API.G_MISS_CHAR,
2738: p_assignee_id => l_assignee_id,

Line 2736: p_owner_id => FND_API.G_MISS_NUM,

2732: p_title => FND_API.G_MISS_CHAR,
2733: p_party_id => FND_API.G_MISS_NUM,
2734: p_priority_code => FND_API.G_MISS_CHAR,
2735: p_due_date => l_ins_due_date,
2736: p_owner_id => FND_API.G_MISS_NUM,
2737: p_owner_type => FND_API.G_MISS_CHAR,
2738: p_assignee_id => l_assignee_id,
2739: p_assignee_type => l_assignee_type,
2740: p_source_object_id => FND_API.G_MISS_NUM,

Line 2737: p_owner_type => FND_API.G_MISS_CHAR,

2733: p_party_id => FND_API.G_MISS_NUM,
2734: p_priority_code => FND_API.G_MISS_CHAR,
2735: p_due_date => l_ins_due_date,
2736: p_owner_id => FND_API.G_MISS_NUM,
2737: p_owner_type => FND_API.G_MISS_CHAR,
2738: p_assignee_id => l_assignee_id,
2739: p_assignee_type => l_assignee_type,
2740: p_source_object_id => FND_API.G_MISS_NUM,
2741: p_source_object_type_code => FND_API.G_MISS_CHAR,

Line 2740: p_source_object_id => FND_API.G_MISS_NUM,

2736: p_owner_id => FND_API.G_MISS_NUM,
2737: p_owner_type => FND_API.G_MISS_CHAR,
2738: p_assignee_id => l_assignee_id,
2739: p_assignee_type => l_assignee_type,
2740: p_source_object_id => FND_API.G_MISS_NUM,
2741: p_source_object_type_code => FND_API.G_MISS_CHAR,
2742: p_application_id => 690,
2743: p_user_id => FND_GLOBAL.USER_ID,
2744: p_login_id => FND_GLOBAL.LOGIN_ID,

Line 2741: p_source_object_type_code => FND_API.G_MISS_CHAR,

2737: p_owner_type => FND_API.G_MISS_CHAR,
2738: p_assignee_id => l_assignee_id,
2739: p_assignee_type => l_assignee_type,
2740: p_source_object_id => FND_API.G_MISS_NUM,
2741: p_source_object_type_code => FND_API.G_MISS_CHAR,
2742: p_application_id => 690,
2743: p_user_id => FND_GLOBAL.USER_ID,
2744: p_login_id => FND_GLOBAL.LOGIN_ID,
2745: p_work_item_status => FND_API.G_MISS_CHAR,

Line 2745: p_work_item_status => FND_API.G_MISS_CHAR,

2741: p_source_object_type_code => FND_API.G_MISS_CHAR,
2742: p_application_id => 690,
2743: p_user_id => FND_GLOBAL.USER_ID,
2744: p_login_id => FND_GLOBAL.LOGIN_ID,
2745: p_work_item_status => FND_API.G_MISS_CHAR,
2746: p_audit_trail_rec => l_audit_trail_rec,
2747: x_msg_count => L_MSG_COUNT,
2748: x_msg_data => L_MSG_DATA,
2749: x_return_status => L_RETURN_STATUS);

Line 2766: p_init_msg_list => FND_API.G_TRUE,

2762:
2763: -- insert into p_temp(msg) values(' calling update wr item' );
2764: IEU_WR_PUB.UPDATE_WR_ITEM(
2765: p_api_version => 1.0,
2766: p_init_msg_list => FND_API.G_TRUE,
2767: p_commit => FND_API.G_FALSE,
2768: p_workitem_obj_code => 'TASK',
2769: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2770: p_title => FND_API.G_MISS_CHAR,

Line 2767: p_commit => FND_API.G_FALSE,

2763: -- insert into p_temp(msg) values(' calling update wr item' );
2764: IEU_WR_PUB.UPDATE_WR_ITEM(
2765: p_api_version => 1.0,
2766: p_init_msg_list => FND_API.G_TRUE,
2767: p_commit => FND_API.G_FALSE,
2768: p_workitem_obj_code => 'TASK',
2769: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2770: p_title => FND_API.G_MISS_CHAR,
2771: p_party_id => FND_API.G_MISS_NUM,

Line 2770: p_title => FND_API.G_MISS_CHAR,

2766: p_init_msg_list => FND_API.G_TRUE,
2767: p_commit => FND_API.G_FALSE,
2768: p_workitem_obj_code => 'TASK',
2769: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2770: p_title => FND_API.G_MISS_CHAR,
2771: p_party_id => FND_API.G_MISS_NUM,
2772: p_priority_code => FND_API.G_MISS_CHAR,
2773: p_due_date => l_ins_due_date,
2774: p_owner_id => FND_API.G_MISS_NUM,

Line 2771: p_party_id => FND_API.G_MISS_NUM,

2767: p_commit => FND_API.G_FALSE,
2768: p_workitem_obj_code => 'TASK',
2769: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2770: p_title => FND_API.G_MISS_CHAR,
2771: p_party_id => FND_API.G_MISS_NUM,
2772: p_priority_code => FND_API.G_MISS_CHAR,
2773: p_due_date => l_ins_due_date,
2774: p_owner_id => FND_API.G_MISS_NUM,
2775: p_owner_type => FND_API.G_MISS_CHAR,

Line 2772: p_priority_code => FND_API.G_MISS_CHAR,

2768: p_workitem_obj_code => 'TASK',
2769: p_workitem_pk_id => jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id,
2770: p_title => FND_API.G_MISS_CHAR,
2771: p_party_id => FND_API.G_MISS_NUM,
2772: p_priority_code => FND_API.G_MISS_CHAR,
2773: p_due_date => l_ins_due_date,
2774: p_owner_id => FND_API.G_MISS_NUM,
2775: p_owner_type => FND_API.G_MISS_CHAR,
2776: p_assignee_id => l_assignee_id,

Line 2774: p_owner_id => FND_API.G_MISS_NUM,

2770: p_title => FND_API.G_MISS_CHAR,
2771: p_party_id => FND_API.G_MISS_NUM,
2772: p_priority_code => FND_API.G_MISS_CHAR,
2773: p_due_date => l_ins_due_date,
2774: p_owner_id => FND_API.G_MISS_NUM,
2775: p_owner_type => FND_API.G_MISS_CHAR,
2776: p_assignee_id => l_assignee_id,
2777: p_assignee_type => l_assignee_type,
2778: p_source_object_id => FND_API.G_MISS_NUM,

Line 2775: p_owner_type => FND_API.G_MISS_CHAR,

2771: p_party_id => FND_API.G_MISS_NUM,
2772: p_priority_code => FND_API.G_MISS_CHAR,
2773: p_due_date => l_ins_due_date,
2774: p_owner_id => FND_API.G_MISS_NUM,
2775: p_owner_type => FND_API.G_MISS_CHAR,
2776: p_assignee_id => l_assignee_id,
2777: p_assignee_type => l_assignee_type,
2778: p_source_object_id => FND_API.G_MISS_NUM,
2779: p_source_object_type_code => FND_API.G_MISS_CHAR,

Line 2778: p_source_object_id => FND_API.G_MISS_NUM,

2774: p_owner_id => FND_API.G_MISS_NUM,
2775: p_owner_type => FND_API.G_MISS_CHAR,
2776: p_assignee_id => l_assignee_id,
2777: p_assignee_type => l_assignee_type,
2778: p_source_object_id => FND_API.G_MISS_NUM,
2779: p_source_object_type_code => FND_API.G_MISS_CHAR,
2780: p_application_id => 690,
2781: p_user_id => FND_GLOBAL.USER_ID,
2782: p_login_id => FND_GLOBAL.LOGIN_ID,

Line 2779: p_source_object_type_code => FND_API.G_MISS_CHAR,

2775: p_owner_type => FND_API.G_MISS_CHAR,
2776: p_assignee_id => l_assignee_id,
2777: p_assignee_type => l_assignee_type,
2778: p_source_object_id => FND_API.G_MISS_NUM,
2779: p_source_object_type_code => FND_API.G_MISS_CHAR,
2780: p_application_id => 690,
2781: p_user_id => FND_GLOBAL.USER_ID,
2782: p_login_id => FND_GLOBAL.LOGIN_ID,
2783: p_work_item_status => FND_API.G_MISS_CHAR,

Line 2783: p_work_item_status => FND_API.G_MISS_CHAR,

2779: p_source_object_type_code => FND_API.G_MISS_CHAR,
2780: p_application_id => 690,
2781: p_user_id => FND_GLOBAL.USER_ID,
2782: p_login_id => FND_GLOBAL.LOGIN_ID,
2783: p_work_item_status => FND_API.G_MISS_CHAR,
2784: p_audit_trail_rec => l_audit_trail_rec,
2785: x_msg_count => L_MSG_COUNT,
2786: x_msg_data => L_MSG_DATA,
2787: x_return_status => L_RETURN_STATUS);

Line 2793: x_return_status := fnd_api.g_ret_sts_success;

2789: x_return_status := l_return_status;
2790:
2791: else
2792:
2793: x_return_status := fnd_api.g_ret_sts_success;
2794:
2795: end if;
2796:
2797: elsif (l_entity <> 'TASK')

Line 2799: x_return_status := fnd_api.g_ret_sts_success;

2795: end if;
2796:
2797: elsif (l_entity <> 'TASK')
2798: then
2799: x_return_status := fnd_api.g_ret_sts_success;
2800: end if;
2801: ELSE -- Niraj, 4220060
2802: x_return_status := fnd_api.g_ret_sts_success; -- Niraj, 4220060
2803: END IF; -- Niraj, 4220060

Line 2802: x_return_status := fnd_api.g_ret_sts_success; -- Niraj, 4220060

2798: then
2799: x_return_status := fnd_api.g_ret_sts_success;
2800: end if;
2801: ELSE -- Niraj, 4220060
2802: x_return_status := fnd_api.g_ret_sts_success; -- Niraj, 4220060
2803: END IF; -- Niraj, 4220060
2804: -- End 'l_update_wr_item_call' check
2805:
2806: end if; /* Task Work Item exists in UWQ Metaphor */

Line 2809: -- x_return_status := fnd_api.g_ret_sts_success;

2805:
2806: end if; /* Task Work Item exists in UWQ Metaphor */
2807:
2808: -- else /* assignee_role <> assingee */
2809: -- x_return_status := fnd_api.g_ret_sts_success;
2810: -- end if;
2811:
2812: EXCEPTION WHEN OTHERS THEN
2813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2809: -- x_return_status := fnd_api.g_ret_sts_success;
2810: -- end if;
2811:
2812: EXCEPTION WHEN OTHERS THEN
2813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2814:
2815: END;
2816:
2817: end if; /* Tasks Rules Func */

Line 2819: x_return_status := fnd_api.g_ret_sts_success;

2815: END;
2816:
2817: end if; /* Tasks Rules Func */
2818: elsif l_activation_status = 'N' then
2819: x_return_status := fnd_api.g_ret_sts_success;
2820: end if;
2821:
2822: end update_task_assign_uwqm_pre;
2823:

Line 3057: FND_API.G_MISS_CHAR,

3053: l_tasks_data_list(l_tasks_data_list.last) := SYSTEM.WR_TASKS_DATA_OBJ (
3054: 'DELETE_TASK_ASG',
3055: l_task_id,
3056: null,
3057: FND_API.G_MISS_CHAR,
3058: FND_API.G_MISS_CHAR,
3059: FND_API.G_MISS_NUM,
3060: FND_API.G_MISS_NUM,
3061: FND_API.G_MISS_NUM,

Line 3058: FND_API.G_MISS_CHAR,

3054: 'DELETE_TASK_ASG',
3055: l_task_id,
3056: null,
3057: FND_API.G_MISS_CHAR,
3058: FND_API.G_MISS_CHAR,
3059: FND_API.G_MISS_NUM,
3060: FND_API.G_MISS_NUM,
3061: FND_API.G_MISS_NUM,
3062: FND_API.G_MISS_NUM,

Line 3059: FND_API.G_MISS_NUM,

3055: l_task_id,
3056: null,
3057: FND_API.G_MISS_CHAR,
3058: FND_API.G_MISS_CHAR,
3059: FND_API.G_MISS_NUM,
3060: FND_API.G_MISS_NUM,
3061: FND_API.G_MISS_NUM,
3062: FND_API.G_MISS_NUM,
3063: FND_API.G_MISS_CHAR,

Line 3060: FND_API.G_MISS_NUM,

3056: null,
3057: FND_API.G_MISS_CHAR,
3058: FND_API.G_MISS_CHAR,
3059: FND_API.G_MISS_NUM,
3060: FND_API.G_MISS_NUM,
3061: FND_API.G_MISS_NUM,
3062: FND_API.G_MISS_NUM,
3063: FND_API.G_MISS_CHAR,
3064: FND_API.G_MISS_NUM,

Line 3061: FND_API.G_MISS_NUM,

3057: FND_API.G_MISS_CHAR,
3058: FND_API.G_MISS_CHAR,
3059: FND_API.G_MISS_NUM,
3060: FND_API.G_MISS_NUM,
3061: FND_API.G_MISS_NUM,
3062: FND_API.G_MISS_NUM,
3063: FND_API.G_MISS_CHAR,
3064: FND_API.G_MISS_NUM,
3065: l_task_source_obj_type_code,

Line 3062: FND_API.G_MISS_NUM,

3058: FND_API.G_MISS_CHAR,
3059: FND_API.G_MISS_NUM,
3060: FND_API.G_MISS_NUM,
3061: FND_API.G_MISS_NUM,
3062: FND_API.G_MISS_NUM,
3063: FND_API.G_MISS_CHAR,
3064: FND_API.G_MISS_NUM,
3065: l_task_source_obj_type_code,
3066: FND_API.G_MISS_NUM,

Line 3063: FND_API.G_MISS_CHAR,

3059: FND_API.G_MISS_NUM,
3060: FND_API.G_MISS_NUM,
3061: FND_API.G_MISS_NUM,
3062: FND_API.G_MISS_NUM,
3063: FND_API.G_MISS_CHAR,
3064: FND_API.G_MISS_NUM,
3065: l_task_source_obj_type_code,
3066: FND_API.G_MISS_NUM,
3067: NULL,

Line 3064: FND_API.G_MISS_NUM,

3060: FND_API.G_MISS_NUM,
3061: FND_API.G_MISS_NUM,
3062: FND_API.G_MISS_NUM,
3063: FND_API.G_MISS_CHAR,
3064: FND_API.G_MISS_NUM,
3065: l_task_source_obj_type_code,
3066: FND_API.G_MISS_NUM,
3067: NULL,
3068: FND_API.G_MISS_DATE,

Line 3066: FND_API.G_MISS_NUM,

3062: FND_API.G_MISS_NUM,
3063: FND_API.G_MISS_CHAR,
3064: FND_API.G_MISS_NUM,
3065: l_task_source_obj_type_code,
3066: FND_API.G_MISS_NUM,
3067: NULL,
3068: FND_API.G_MISS_DATE,
3069: FND_API.G_MISS_DATE,
3070: FND_API.G_MISS_DATE,

Line 3068: FND_API.G_MISS_DATE,

3064: FND_API.G_MISS_NUM,
3065: l_task_source_obj_type_code,
3066: FND_API.G_MISS_NUM,
3067: NULL,
3068: FND_API.G_MISS_DATE,
3069: FND_API.G_MISS_DATE,
3070: FND_API.G_MISS_DATE,
3071: FND_API.G_MISS_DATE,
3072: FND_API.G_MISS_DATE,

Line 3069: FND_API.G_MISS_DATE,

3065: l_task_source_obj_type_code,
3066: FND_API.G_MISS_NUM,
3067: NULL,
3068: FND_API.G_MISS_DATE,
3069: FND_API.G_MISS_DATE,
3070: FND_API.G_MISS_DATE,
3071: FND_API.G_MISS_DATE,
3072: FND_API.G_MISS_DATE,
3073: FND_API.G_MISS_DATE,

Line 3070: FND_API.G_MISS_DATE,

3066: FND_API.G_MISS_NUM,
3067: NULL,
3068: FND_API.G_MISS_DATE,
3069: FND_API.G_MISS_DATE,
3070: FND_API.G_MISS_DATE,
3071: FND_API.G_MISS_DATE,
3072: FND_API.G_MISS_DATE,
3073: FND_API.G_MISS_DATE,
3074: null,

Line 3071: FND_API.G_MISS_DATE,

3067: NULL,
3068: FND_API.G_MISS_DATE,
3069: FND_API.G_MISS_DATE,
3070: FND_API.G_MISS_DATE,
3071: FND_API.G_MISS_DATE,
3072: FND_API.G_MISS_DATE,
3073: FND_API.G_MISS_DATE,
3074: null,
3075: null,

Line 3072: FND_API.G_MISS_DATE,

3068: FND_API.G_MISS_DATE,
3069: FND_API.G_MISS_DATE,
3070: FND_API.G_MISS_DATE,
3071: FND_API.G_MISS_DATE,
3072: FND_API.G_MISS_DATE,
3073: FND_API.G_MISS_DATE,
3074: null,
3075: null,
3076: null);

Line 3073: FND_API.G_MISS_DATE,

3069: FND_API.G_MISS_DATE,
3070: FND_API.G_MISS_DATE,
3071: FND_API.G_MISS_DATE,
3072: FND_API.G_MISS_DATE,
3073: FND_API.G_MISS_DATE,
3074: null,
3075: null,
3076: null);
3077:

Line 3102: FND_API.G_MISS_CHAR,

3098: l_orig_grp_owner := null;
3099: END;
3100:
3101: l_def_data_list(l_def_data_list.last) := SYSTEM.DEF_WR_DATA_OBJ(
3102: FND_API.G_MISS_CHAR,
3103: FND_API.G_MISS_CHAR,
3104: l_ins_due_date,
3105: 'TASKS',
3106: l_orig_grp_owner

Line 3103: FND_API.G_MISS_CHAR,

3099: END;
3100:
3101: l_def_data_list(l_def_data_list.last) := SYSTEM.DEF_WR_DATA_OBJ(
3102: FND_API.G_MISS_CHAR,
3103: FND_API.G_MISS_CHAR,
3104: l_ins_due_date,
3105: 'TASKS',
3106: l_orig_grp_owner
3107: );

Line 3171: x_return_status := fnd_api.g_ret_sts_success;

3167:
3168: if ( (l_task_status = 'CLOSE') or (l_del_flag = 'Y') )
3169: then
3170: --insert into p_temp(msg) values ('close/del and rec does not exists.. ret success');
3171: x_return_status := fnd_api.g_ret_sts_success;
3172:
3173: elsif (nvl(l_del_task_id, '-9') = l_task_id)
3174: then
3175: -- This work item is being deleted

Line 3192: x_return_status := fnd_api.g_ret_sts_success;

3188: if (l_task_asg_count = 1)
3189: then
3190: l_del_task_id := null;
3191: end if;
3192: x_return_status := fnd_api.g_ret_sts_success;
3193:
3194: else
3195: -- Create Work repository Item
3196:

Line 3223: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3219: exception
3220: when others then
3221: null;
3222: -- insert into p_temp values('raising err ');
3223: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3224: --raise;
3225: end;
3226:
3227: l_owner_id := l_ins_owner_id;

Line 3320: p_init_msg_list => FND_API.G_TRUE,

3316: then
3317: --insert into p_temp values ('create wr item');
3318: IEU_WR_PUB.CREATE_WR_ITEM(
3319: p_api_version => 1.0,
3320: p_init_msg_list => FND_API.G_TRUE,
3321: p_commit => FND_API.G_true,
3322: p_workitem_obj_code => 'TASK',
3323: p_workitem_pk_id => l_ins_task_id,
3324: p_work_item_number => l_ins_task_number,

Line 3321: p_commit => FND_API.G_true,

3317: --insert into p_temp values ('create wr item');
3318: IEU_WR_PUB.CREATE_WR_ITEM(
3319: p_api_version => 1.0,
3320: p_init_msg_list => FND_API.G_TRUE,
3321: p_commit => FND_API.G_true,
3322: p_workitem_obj_code => 'TASK',
3323: p_workitem_pk_id => l_ins_task_id,
3324: p_work_item_number => l_ins_task_number,
3325: p_title => l_ins_task_name,

Line 3471: p_init_msg_list => FND_API.G_TRUE,

3467:
3468: if (l_entity = 'TASK') and (nvl(l_other_asg_deleted_flag, 'N') = 'N')then
3469: IEU_WR_PUB.UPDATE_WR_ITEM(
3470: p_api_version => 1.0,
3471: p_init_msg_list => FND_API.G_TRUE,
3472: p_commit => FND_API.G_FALSE,
3473: p_workitem_obj_code => 'TASK',
3474: p_workitem_pk_id => l_task_id,
3475: p_title => FND_API.G_MISS_CHAR,

Line 3472: p_commit => FND_API.G_FALSE,

3468: if (l_entity = 'TASK') and (nvl(l_other_asg_deleted_flag, 'N') = 'N')then
3469: IEU_WR_PUB.UPDATE_WR_ITEM(
3470: p_api_version => 1.0,
3471: p_init_msg_list => FND_API.G_TRUE,
3472: p_commit => FND_API.G_FALSE,
3473: p_workitem_obj_code => 'TASK',
3474: p_workitem_pk_id => l_task_id,
3475: p_title => FND_API.G_MISS_CHAR,
3476: p_party_id => FND_API.G_MISS_NUM,

Line 3475: p_title => FND_API.G_MISS_CHAR,

3471: p_init_msg_list => FND_API.G_TRUE,
3472: p_commit => FND_API.G_FALSE,
3473: p_workitem_obj_code => 'TASK',
3474: p_workitem_pk_id => l_task_id,
3475: p_title => FND_API.G_MISS_CHAR,
3476: p_party_id => FND_API.G_MISS_NUM,
3477: p_priority_code => FND_API.G_MISS_CHAR,
3478: p_due_date => l_ins_due_date,
3479: p_owner_id => FND_API.G_MISS_NUM,

Line 3476: p_party_id => FND_API.G_MISS_NUM,

3472: p_commit => FND_API.G_FALSE,
3473: p_workitem_obj_code => 'TASK',
3474: p_workitem_pk_id => l_task_id,
3475: p_title => FND_API.G_MISS_CHAR,
3476: p_party_id => FND_API.G_MISS_NUM,
3477: p_priority_code => FND_API.G_MISS_CHAR,
3478: p_due_date => l_ins_due_date,
3479: p_owner_id => FND_API.G_MISS_NUM,
3480: p_owner_type => FND_API.G_MISS_CHAR,

Line 3477: p_priority_code => FND_API.G_MISS_CHAR,

3473: p_workitem_obj_code => 'TASK',
3474: p_workitem_pk_id => l_task_id,
3475: p_title => FND_API.G_MISS_CHAR,
3476: p_party_id => FND_API.G_MISS_NUM,
3477: p_priority_code => FND_API.G_MISS_CHAR,
3478: p_due_date => l_ins_due_date,
3479: p_owner_id => FND_API.G_MISS_NUM,
3480: p_owner_type => FND_API.G_MISS_CHAR,
3481: p_assignee_id => l_assignee_id,

Line 3479: p_owner_id => FND_API.G_MISS_NUM,

3475: p_title => FND_API.G_MISS_CHAR,
3476: p_party_id => FND_API.G_MISS_NUM,
3477: p_priority_code => FND_API.G_MISS_CHAR,
3478: p_due_date => l_ins_due_date,
3479: p_owner_id => FND_API.G_MISS_NUM,
3480: p_owner_type => FND_API.G_MISS_CHAR,
3481: p_assignee_id => l_assignee_id,
3482: p_assignee_type => l_assignee_type,
3483: p_source_object_id => FND_API.G_MISS_NUM,

Line 3480: p_owner_type => FND_API.G_MISS_CHAR,

3476: p_party_id => FND_API.G_MISS_NUM,
3477: p_priority_code => FND_API.G_MISS_CHAR,
3478: p_due_date => l_ins_due_date,
3479: p_owner_id => FND_API.G_MISS_NUM,
3480: p_owner_type => FND_API.G_MISS_CHAR,
3481: p_assignee_id => l_assignee_id,
3482: p_assignee_type => l_assignee_type,
3483: p_source_object_id => FND_API.G_MISS_NUM,
3484: p_source_object_type_code => FND_API.G_MISS_CHAR,

Line 3483: p_source_object_id => FND_API.G_MISS_NUM,

3479: p_owner_id => FND_API.G_MISS_NUM,
3480: p_owner_type => FND_API.G_MISS_CHAR,
3481: p_assignee_id => l_assignee_id,
3482: p_assignee_type => l_assignee_type,
3483: p_source_object_id => FND_API.G_MISS_NUM,
3484: p_source_object_type_code => FND_API.G_MISS_CHAR,
3485: p_application_id => 690,
3486: p_user_id => FND_GLOBAL.USER_ID,
3487: p_login_id => FND_GLOBAL.LOGIN_ID,

Line 3484: p_source_object_type_code => FND_API.G_MISS_CHAR,

3480: p_owner_type => FND_API.G_MISS_CHAR,
3481: p_assignee_id => l_assignee_id,
3482: p_assignee_type => l_assignee_type,
3483: p_source_object_id => FND_API.G_MISS_NUM,
3484: p_source_object_type_code => FND_API.G_MISS_CHAR,
3485: p_application_id => 690,
3486: p_user_id => FND_GLOBAL.USER_ID,
3487: p_login_id => FND_GLOBAL.LOGIN_ID,
3488: p_work_item_status => FND_API.G_MISS_CHAR,

Line 3488: p_work_item_status => FND_API.G_MISS_CHAR,

3484: p_source_object_type_code => FND_API.G_MISS_CHAR,
3485: p_application_id => 690,
3486: p_user_id => FND_GLOBAL.USER_ID,
3487: p_login_id => FND_GLOBAL.LOGIN_ID,
3488: p_work_item_status => FND_API.G_MISS_CHAR,
3489: p_audit_trail_rec => l_audit_trail_rec,
3490: x_msg_data => L_MSG_DATA,
3491: x_msg_count => l_msg_count,
3492: x_return_status => L_RETURN_STATUS);

Line 3497: x_return_status := fnd_api.g_ret_sts_success;

3493:
3494: x_return_status := l_return_status;
3495: elsif (l_entity <> 'TASK') or
3496: (nvl(l_other_asg_deleted_flag, 'N') = 'Y') then
3497: x_return_status := fnd_api.g_ret_sts_success;
3498: end if;
3499:
3500: end if; /* l_wi_exists */
3501:

Line 3504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3500: end if; /* l_wi_exists */
3501:
3502:
3503: EXCEPTION WHEN OTHERS THEN
3504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3505:
3506: END;
3507:
3508: end if; /* Task Rules Func */

Line 3510: x_return_status := fnd_api.g_ret_sts_success;

3506: END;
3507:
3508: end if; /* Task Rules Func */
3509: elsif l_activation_status = 'N' then
3510: x_return_status := fnd_api.g_ret_sts_success;
3511: end if;
3512: end delete_task_assign_uwqm_pre;
3513:
3514: END IEU_TASKS_USERHOOKS;