171: */
172: --INSERT INTO msista_Tmp values (20, 'entering for(p_action_input_data) loop');
173: --commit;
174: --** These default values have been added as part of bug #4706930 - MS **---
175: l_p_task_name := FND_API.G_MISS_CHAR;
176: l_p_type := FND_API.G_MISS_CHAR;
177: l_p_priority := FND_API.G_MISS_CHAR;
178: l_p_status := FND_API.G_MISS_CHAR;
179:
172: --INSERT INTO msista_Tmp values (20, 'entering for(p_action_input_data) loop');
173: --commit;
174: --** These default values have been added as part of bug #4706930 - MS **---
175: l_p_task_name := FND_API.G_MISS_CHAR;
176: l_p_type := FND_API.G_MISS_CHAR;
177: l_p_priority := FND_API.G_MISS_CHAR;
178: l_p_status := FND_API.G_MISS_CHAR;
179:
180: l_p_planned_start := FND_API.G_MISS_DATE;
173: --commit;
174: --** These default values have been added as part of bug #4706930 - MS **---
175: l_p_task_name := FND_API.G_MISS_CHAR;
176: l_p_type := FND_API.G_MISS_CHAR;
177: l_p_priority := FND_API.G_MISS_CHAR;
178: l_p_status := FND_API.G_MISS_CHAR;
179:
180: l_p_planned_start := FND_API.G_MISS_DATE;
181: l_p_planned_end := FND_API.G_MISS_DATE;
174: --** These default values have been added as part of bug #4706930 - MS **---
175: l_p_task_name := FND_API.G_MISS_CHAR;
176: l_p_type := FND_API.G_MISS_CHAR;
177: l_p_priority := FND_API.G_MISS_CHAR;
178: l_p_status := FND_API.G_MISS_CHAR;
179:
180: l_p_planned_start := FND_API.G_MISS_DATE;
181: l_p_planned_end := FND_API.G_MISS_DATE;
182: l_p_actual_start := FND_API.G_MISS_DATE;
176: l_p_type := FND_API.G_MISS_CHAR;
177: l_p_priority := FND_API.G_MISS_CHAR;
178: l_p_status := FND_API.G_MISS_CHAR;
179:
180: l_p_planned_start := FND_API.G_MISS_DATE;
181: l_p_planned_end := FND_API.G_MISS_DATE;
182: l_p_actual_start := FND_API.G_MISS_DATE;
183: l_p_actual_end := FND_API.G_MISS_DATE;
184: l_p_sched_start := FND_API.G_MISS_DATE;
177: l_p_priority := FND_API.G_MISS_CHAR;
178: l_p_status := FND_API.G_MISS_CHAR;
179:
180: l_p_planned_start := FND_API.G_MISS_DATE;
181: l_p_planned_end := FND_API.G_MISS_DATE;
182: l_p_actual_start := FND_API.G_MISS_DATE;
183: l_p_actual_end := FND_API.G_MISS_DATE;
184: l_p_sched_start := FND_API.G_MISS_DATE;
185: l_p_sched_end := FND_API.G_MISS_DATE;
178: l_p_status := FND_API.G_MISS_CHAR;
179:
180: l_p_planned_start := FND_API.G_MISS_DATE;
181: l_p_planned_end := FND_API.G_MISS_DATE;
182: l_p_actual_start := FND_API.G_MISS_DATE;
183: l_p_actual_end := FND_API.G_MISS_DATE;
184: l_p_sched_start := FND_API.G_MISS_DATE;
185: l_p_sched_end := FND_API.G_MISS_DATE;
186: l_p_description := FND_API.G_MISS_CHAR;
179:
180: l_p_planned_start := FND_API.G_MISS_DATE;
181: l_p_planned_end := FND_API.G_MISS_DATE;
182: l_p_actual_start := FND_API.G_MISS_DATE;
183: l_p_actual_end := FND_API.G_MISS_DATE;
184: l_p_sched_start := FND_API.G_MISS_DATE;
185: l_p_sched_end := FND_API.G_MISS_DATE;
186: l_p_description := FND_API.G_MISS_CHAR;
187: l_p_note := FND_API.G_MISS_CHAR;
180: l_p_planned_start := FND_API.G_MISS_DATE;
181: l_p_planned_end := FND_API.G_MISS_DATE;
182: l_p_actual_start := FND_API.G_MISS_DATE;
183: l_p_actual_end := FND_API.G_MISS_DATE;
184: l_p_sched_start := FND_API.G_MISS_DATE;
185: l_p_sched_end := FND_API.G_MISS_DATE;
186: l_p_description := FND_API.G_MISS_CHAR;
187: l_p_note := FND_API.G_MISS_CHAR;
188:
181: l_p_planned_end := FND_API.G_MISS_DATE;
182: l_p_actual_start := FND_API.G_MISS_DATE;
183: l_p_actual_end := FND_API.G_MISS_DATE;
184: l_p_sched_start := FND_API.G_MISS_DATE;
185: l_p_sched_end := FND_API.G_MISS_DATE;
186: l_p_description := FND_API.G_MISS_CHAR;
187: l_p_note := FND_API.G_MISS_CHAR;
188:
189: for i in 1..p_action_input_data.COUNT LOOP
182: l_p_actual_start := FND_API.G_MISS_DATE;
183: l_p_actual_end := FND_API.G_MISS_DATE;
184: l_p_sched_start := FND_API.G_MISS_DATE;
185: l_p_sched_end := FND_API.G_MISS_DATE;
186: l_p_description := FND_API.G_MISS_CHAR;
187: l_p_note := FND_API.G_MISS_CHAR;
188:
189: for i in 1..p_action_input_data.COUNT LOOP
190:
183: l_p_actual_end := FND_API.G_MISS_DATE;
184: l_p_sched_start := FND_API.G_MISS_DATE;
185: l_p_sched_end := FND_API.G_MISS_DATE;
186: l_p_description := FND_API.G_MISS_CHAR;
187: l_p_note := FND_API.G_MISS_CHAR;
188:
189: for i in 1..p_action_input_data.COUNT LOOP
190:
191: l_dataSetType := p_action_input_data(i).dataSetType;
304: IF (l_p_task_name is NULL) THEN
305: --INSERT INTO msista_Tmp values (42, 'l_task_name is null');
306: --commit;
307:
308: l_task_name := FND_API.G_MISS_CHAR;
309: ELSE
310: --INSERT INTO msista_Tmp values (42, 'l_task_name <> null');
311: --commit;
312:
315: IF ( l_p_type is NULL ) THEN
316: --INSERT INTO msista_Tmp values (42, 'l_type is null');
317: --commit;
318:
319: l_type := FND_API.G_MISS_CHAR; --G_MISS_NUM;
320: ELSE
321: --INSERT INTO msista_Tmp values (42, 'l_type <> null');
322: --commit;
323:
325: END IF;
326: IF (l_p_description is NULL ) THEN
327: --INSERT INTO msista_Tmp values (42, 'l_description is null');
328: --commit;
329: l_description := FND_API.G_MISS_CHAR;
330: ELSE
331: --INSERT INTO msista_Tmp values (42, 'l_description <> null');
332: --commit;
333:
336: IF (l_p_status is NULL ) THEN
337: --INSERT INTO msista_Tmp values (42, 'l_status is null');
338: --commit;
339:
340: l_status := FND_API.G_MISS_CHAR; --g_miss_num;
341: ELSE
342: --INSERT INTO msista_Tmp values (42, 'l_status <> null');
343: --commit;
344:
348: (l_count = 1 AND l_p_priority is NULL )) THEN
349: --INSERT INTO msista_Tmp values (42, 'l_priority is null');
350: --commit;
351:
352: l_priority := FND_API.G_MISS_CHAR; --g_miss_num;
353: ELSE
354: --INSERT INTO msista_Tmp values (42, 'l_count is '||l_count||',l_priority <> null and it is '||l_p_priority);
355: --commit;
356:
359: IF (l_p_owner is NULL) THEN
360: --INSERT INTO msista_Tmp values (42, 'l_owner is null');
361: --commit;
362:
363: l_owner_id := FND_API.G_MISS_NUM;
364: l_owner_type_code := FND_API.G_MISS_CHAR;
365: ELSE
366: --INSERT INTO msista_Tmp values (42, 'l_owner <> null, parsing l_owner='||l_owner);
367: --commit;
360: --INSERT INTO msista_Tmp values (42, 'l_owner is null');
361: --commit;
362:
363: l_owner_id := FND_API.G_MISS_NUM;
364: l_owner_type_code := FND_API.G_MISS_CHAR;
365: ELSE
366: --INSERT INTO msista_Tmp values (42, 'l_owner <> null, parsing l_owner='||l_owner);
367: --commit;
368:
379: IF (l_p_assignee is NULL) THEN
380: --INSERT INTO msista_Tmp values (42, 'l_assignee is null');
381: --commit;
382:
383: l_assignee_id := FND_API.G_MISS_NUM;
384: l_assignee_type_code := FND_API.G_MISS_CHAR;
385: ELSE
386: --INSERT INTO msista_Tmp values (42, 'l_assignee <> null, parsing');
387: --commit;
380: --INSERT INTO msista_Tmp values (42, 'l_assignee is null');
381: --commit;
382:
383: l_assignee_id := FND_API.G_MISS_NUM;
384: l_assignee_type_code := FND_API.G_MISS_CHAR;
385: ELSE
386: --INSERT INTO msista_Tmp values (42, 'l_assignee <> null, parsing');
387: --commit;
388:
399: IF (l_count > 1 AND l_p_planned_start is NULL) THEN
400: --INSERT INTO msista_Tmp values (42, 'l_planned_start is null');
401: --commit;
402:
403: l_planned_start := FND_API.G_MISS_DATE;
404: ELSE
405: --INSERT INTO msista_Tmp values (42, 'l_planned_start <> null');
406: --commit;
407:
410: IF (l_count > 1 AND l_p_planned_end is NULL) THEN
411: --INSERT INTO msista_Tmp values (42, 'l_planned_end is null');
412: --commit;
413:
414: l_planned_end := FND_API.G_MISS_DATE;
415: ELSE
416: --INSERT INTO msista_Tmp values (42, 'l_planned_end <> null');
417: --commit;
418:
421: IF (l_count > 1 AND l_p_actual_start is NULL) THEN
422: --INSERT INTO msista_Tmp values (42, 'l_actual_start is null');
423: --commit;
424:
425: l_actual_start := FND_API.G_MISS_DATE;
426: ELSE
427: --INSERT INTO msista_Tmp values (42, 'l_actual_start <> null');
428: --commit;
429:
432: IF (l_count > 1 AND l_p_actual_end is NULL) THEN
433: --INSERT INTO msista_Tmp values (42, 'l_actual_end is null');
434: --commit;
435:
436: l_actual_end := FND_API.G_MISS_DATE;
437: ELSE
438: --INSERT INTO msista_Tmp values (42, 'l_actual_end <> null');
439: --commit;
440:
443: IF (l_count > 1 AND l_p_sched_start is NULL) THEN
444: --INSERT INTO msista_Tmp values (42, 'l_sched_start is null');
445: --commit;
446:
447: l_sched_start := FND_API.G_MISS_DATE;
448: ELSE
449: --INSERT INTO msista_Tmp values (42, 'l_sched_start <> null');
450: --commit;
451:
455:
456: --INSERT INTO msista_Tmp values (42, 'l_sched_end is null');
457: --commit;
458:
459: l_sched_end := FND_API.G_MISS_DATE;
460: ELSE
461: --INSERT INTO msista_Tmp values (42, 'l_sched_end <> null');
462: --commit;
463:
677: l_note_ctxt_tbl(l_note_ctxt_idx).NOTE_CONTEXT_TYPE_ID := l_task_rec_tbl(i).id;
678: l_note_ctxt_idx := l_note_ctxt_idx+1;
679:
680: jtf_notes_pub.create_note(
681: -- p_parent_note_id => fnd_api.g_miss_num,
682: -- p_jtf_note_id => fnd_api.g_miss_num,
683: p_api_version => l_api_version,
684: p_init_msg_list => G_FALSE,
685: p_commit => G_FALSE,
678: l_note_ctxt_idx := l_note_ctxt_idx+1;
679:
680: jtf_notes_pub.create_note(
681: -- p_parent_note_id => fnd_api.g_miss_num,
682: -- p_jtf_note_id => fnd_api.g_miss_num,
683: p_api_version => l_api_version,
684: p_init_msg_list => G_FALSE,
685: p_commit => G_FALSE,
686: p_validation_level => l_valid_level_full,
747: if (l_note_context_type_id is not null) then
748: jtf_notes_pub.Create_note_context
749: ( p_validation_level => l_valid_level_full,
750: p_jtf_note_id => l_note_id,
751: p_last_update_date => FND_API.G_MISS_DATE,
752: p_last_updated_by => G_USER_ID,
753: p_creation_date => FND_API.G_MISS_DATE,
754: p_note_context_type_id => l_note_context_type_id,
755: p_note_context_type => l_obj_type_code,
749: ( p_validation_level => l_valid_level_full,
750: p_jtf_note_id => l_note_id,
751: p_last_update_date => FND_API.G_MISS_DATE,
752: p_last_updated_by => G_USER_ID,
753: p_creation_date => FND_API.G_MISS_DATE,
754: p_note_context_type_id => l_note_context_type_id,
755: p_note_context_type => l_obj_type_code,
756: x_return_status => l_return_status,
757: x_note_context_id => l_context_id
795: if (l_note_context_type_id is not null) then
796: jtf_notes_pub.Create_note_context
797: ( p_validation_level => l_valid_level_full,
798: p_jtf_note_id => l_note_id,
799: p_last_update_date => FND_API.G_MISS_DATE,
800: p_last_updated_by => G_USER_ID,
801: p_creation_date => FND_API.G_MISS_DATE,
802: p_note_context_type_id => l_note_context_type_id,
803: p_note_context_type => 'PARTY',
797: ( p_validation_level => l_valid_level_full,
798: p_jtf_note_id => l_note_id,
799: p_last_update_date => FND_API.G_MISS_DATE,
800: p_last_updated_by => G_USER_ID,
801: p_creation_date => FND_API.G_MISS_DATE,
802: p_note_context_type_id => l_note_context_type_id,
803: p_note_context_type => 'PARTY',
804: x_return_status => l_return_status,
805: x_note_context_id => l_context_id
844: if (l_note_context_type_id is not null) then
845: jtf_notes_pub.Create_note_context
846: ( p_validation_level => l_valid_level_full,
847: p_jtf_note_id => l_note_id,
848: p_last_update_date => FND_API.G_MISS_DATE,
849: p_last_updated_by => G_USER_ID,
850: p_creation_date => FND_API.G_MISS_DATE,
851: p_note_context_type_id => l_note_context_type_id,
852: p_note_context_type => 'PARTY',
846: ( p_validation_level => l_valid_level_full,
847: p_jtf_note_id => l_note_id,
848: p_last_update_date => FND_API.G_MISS_DATE,
849: p_last_updated_by => G_USER_ID,
850: p_creation_date => FND_API.G_MISS_DATE,
851: p_note_context_type_id => l_note_context_type_id,
852: p_note_context_type => 'PARTY',
853: x_return_status => l_return_status,
854: x_note_context_id => l_context_id
895: if (l_note_context_type_id is not null) then
896: jtf_notes_pub.Create_note_context
897: ( p_validation_level => l_valid_level_full,
898: p_jtf_note_id => l_note_id,
899: p_last_update_date => FND_API.G_MISS_DATE,
900: p_last_updated_by => G_USER_ID,
901: p_creation_date => FND_API.G_MISS_DATE,
902: p_note_context_type_id => l_note_context_type_id,
903: p_note_context_type => 'PARTY',
897: ( p_validation_level => l_valid_level_full,
898: p_jtf_note_id => l_note_id,
899: p_last_update_date => FND_API.G_MISS_DATE,
900: p_last_updated_by => G_USER_ID,
901: p_creation_date => FND_API.G_MISS_DATE,
902: p_note_context_type_id => l_note_context_type_id,
903: p_note_context_type => 'PARTY',
904: x_return_status => l_return_status,
905: x_note_context_id => l_context_id
949: if (l_note_context_type_id is not null) then
950: jtf_notes_pub.Create_note_context
951: ( p_validation_level => l_valid_level_full,
952: p_jtf_note_id => l_note_id,
953: p_last_update_date => FND_API.G_MISS_DATE,
954: p_last_updated_by => G_USER_ID,
955: p_creation_date => FND_API.G_MISS_DATE,
956: p_note_context_type_id => l_note_context_type_id,
957: p_note_context_type => 'PARTY',
951: ( p_validation_level => l_valid_level_full,
952: p_jtf_note_id => l_note_id,
953: p_last_update_date => FND_API.G_MISS_DATE,
954: p_last_updated_by => G_USER_ID,
955: p_creation_date => FND_API.G_MISS_DATE,
956: p_note_context_type_id => l_note_context_type_id,
957: p_note_context_type => 'PARTY',
958: x_return_status => l_return_status,
959: x_note_context_id => l_context_id
1013: if (l_note_context_type_id is not null) then
1014: jtf_notes_pub.Create_note_context
1015: ( p_validation_level => l_valid_level_full,
1016: p_jtf_note_id => l_note_id,
1017: p_last_update_date => FND_API.G_MISS_DATE,
1018: p_last_updated_by => G_USER_ID,
1019: p_creation_date => FND_API.G_MISS_DATE,
1020: p_note_context_type_id => l_note_context_type_id,
1021: p_note_context_type => 'PARTY',
1015: ( p_validation_level => l_valid_level_full,
1016: p_jtf_note_id => l_note_id,
1017: p_last_update_date => FND_API.G_MISS_DATE,
1018: p_last_updated_by => G_USER_ID,
1019: p_creation_date => FND_API.G_MISS_DATE,
1020: p_note_context_type_id => l_note_context_type_id,
1021: p_note_context_type => 'PARTY',
1022: x_return_status => l_return_status,
1023: x_note_context_id => l_context_id
1077: if (l_note_context_type_id is not null) then
1078: jtf_notes_pub.Create_note_context
1079: ( p_validation_level => l_valid_level_full,
1080: p_jtf_note_id => l_note_id,
1081: p_last_update_date => FND_API.G_MISS_DATE,
1082: p_last_updated_by => G_USER_ID,
1083: p_creation_date => FND_API.G_MISS_DATE,
1084: p_note_context_type_id => l_note_context_type_id,
1085: p_note_context_type => 'PARTY',
1079: ( p_validation_level => l_valid_level_full,
1080: p_jtf_note_id => l_note_id,
1081: p_last_update_date => FND_API.G_MISS_DATE,
1082: p_last_updated_by => G_USER_ID,
1083: p_creation_date => FND_API.G_MISS_DATE,
1084: p_note_context_type_id => l_note_context_type_id,
1085: p_note_context_type => 'PARTY',
1086: x_return_status => l_return_status,
1087: x_note_context_id => l_context_id
1128: x_return_status := G_UNEXP_ERROR;
1129:
1130: fnd_message.set_name ('IEU', 'IEU_STATUS_TYPE_FAIL');
1131: fnd_msg_pub.add;
1132: x_return_status := fnd_api.g_ret_sts_unexp_error;
1133: fnd_msg_pub.count_and_get (
1134: p_count => x_msg_count,
1135: p_data => x_msg_data
1136: );
1139: x_return_status := G_UNEXP_ERROR;
1140:
1141: fnd_message.set_name ('IEU', 'IEU_TASK_NAME_FAIL');
1142: fnd_msg_pub.add;
1143: x_return_status := fnd_api.g_ret_sts_unexp_error;
1144: fnd_msg_pub.count_and_get (
1145: p_count => x_msg_count,
1146: p_data => x_msg_data
1147: );
1151: --fnd_message.set_name ('IEU', 'IEU_STATUS_TYPE_FAIL');
1152: if (l_msg_count is null) or (l_msg_count < 1) then
1153: fnd_message.set_name ('IEU', 'IEU_UPDATE_TASK_FAIL');
1154: fnd_msg_pub.add;
1155: x_return_status := fnd_api.g_ret_sts_unexp_error;
1156: fnd_msg_pub.count_and_get (
1157: p_count => x_msg_count,
1158: p_data => x_msg_data
1159: );