DBA Data[Home] [Help]

APPS.IEU_WPACTIONS_PVT dependencies on FND_API

Line 175: l_p_task_name := FND_API.G_MISS_CHAR;

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:

Line 176: l_p_type := FND_API.G_MISS_CHAR;

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;

Line 177: l_p_priority := FND_API.G_MISS_CHAR;

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;

Line 178: l_p_status := FND_API.G_MISS_CHAR;

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;

Line 180: l_p_planned_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;

Line 181: l_p_planned_end := 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;

Line 182: l_p_actual_start := 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;

Line 183: l_p_actual_end := FND_API.G_MISS_DATE;

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;

Line 184: l_p_sched_start := FND_API.G_MISS_DATE;

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:

Line 185: l_p_sched_end := 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:
189: for i in 1..p_action_input_data.COUNT LOOP

Line 186: l_p_description := FND_API.G_MISS_CHAR;

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:

Line 187: l_p_note := FND_API.G_MISS_CHAR;

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;

Line 308: l_task_name := FND_API.G_MISS_CHAR;

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:

Line 319: l_type := FND_API.G_MISS_CHAR; --G_MISS_NUM;

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:

Line 329: l_description := FND_API.G_MISS_CHAR;

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:

Line 340: l_status := FND_API.G_MISS_CHAR; --g_miss_num;

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:

Line 352: l_priority := FND_API.G_MISS_CHAR; --g_miss_num;

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:

Line 363: l_owner_id := FND_API.G_MISS_NUM;

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;

Line 364: l_owner_type_code := FND_API.G_MISS_CHAR;

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:

Line 383: l_assignee_id := FND_API.G_MISS_NUM;

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;

Line 384: l_assignee_type_code := FND_API.G_MISS_CHAR;

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:

Line 403: l_planned_start := FND_API.G_MISS_DATE;

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:

Line 414: l_planned_end := FND_API.G_MISS_DATE;

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:

Line 425: l_actual_start := FND_API.G_MISS_DATE;

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:

Line 436: l_actual_end := FND_API.G_MISS_DATE;

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:

Line 447: l_sched_start := FND_API.G_MISS_DATE;

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:

Line 459: l_sched_end := FND_API.G_MISS_DATE;

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:

Line 662: -- p_parent_note_id => fnd_api.g_miss_num,

658: l_note_ctxt_tbl(l_note_ctxt_idx).NOTE_CONTEXT_TYPE_ID := l_task_rec_tbl(i).id;
659: l_note_ctxt_idx := l_note_ctxt_idx+1;
660:
661: jtf_notes_pub.create_note(
662: -- p_parent_note_id => fnd_api.g_miss_num,
663: -- p_jtf_note_id => fnd_api.g_miss_num,
664: p_api_version => l_api_version,
665: p_init_msg_list => G_FALSE,
666: p_commit => G_FALSE,

Line 663: -- p_jtf_note_id => fnd_api.g_miss_num,

659: l_note_ctxt_idx := l_note_ctxt_idx+1;
660:
661: jtf_notes_pub.create_note(
662: -- p_parent_note_id => fnd_api.g_miss_num,
663: -- p_jtf_note_id => fnd_api.g_miss_num,
664: p_api_version => l_api_version,
665: p_init_msg_list => G_FALSE,
666: p_commit => G_FALSE,
667: p_validation_level => l_valid_level_full,

Line 732: p_last_update_date => FND_API.G_MISS_DATE,

728: if (l_note_context_type_id is not null) then
729: jtf_notes_pub.Create_note_context
730: ( p_validation_level => l_valid_level_full,
731: p_jtf_note_id => l_note_id,
732: p_last_update_date => FND_API.G_MISS_DATE,
733: p_last_updated_by => G_USER_ID,
734: p_creation_date => FND_API.G_MISS_DATE,
735: p_note_context_type_id => l_note_context_type_id,
736: p_note_context_type => l_obj_type_code,

Line 734: p_creation_date => FND_API.G_MISS_DATE,

730: ( p_validation_level => l_valid_level_full,
731: p_jtf_note_id => l_note_id,
732: p_last_update_date => FND_API.G_MISS_DATE,
733: p_last_updated_by => G_USER_ID,
734: p_creation_date => FND_API.G_MISS_DATE,
735: p_note_context_type_id => l_note_context_type_id,
736: p_note_context_type => l_obj_type_code,
737: x_return_status => l_return_status,
738: x_note_context_id => l_context_id

Line 780: p_last_update_date => FND_API.G_MISS_DATE,

776: if (l_note_context_type_id is not null) then
777: jtf_notes_pub.Create_note_context
778: ( p_validation_level => l_valid_level_full,
779: p_jtf_note_id => l_note_id,
780: p_last_update_date => FND_API.G_MISS_DATE,
781: p_last_updated_by => G_USER_ID,
782: p_creation_date => FND_API.G_MISS_DATE,
783: p_note_context_type_id => l_note_context_type_id,
784: p_note_context_type => 'PARTY',

Line 782: p_creation_date => FND_API.G_MISS_DATE,

778: ( p_validation_level => l_valid_level_full,
779: p_jtf_note_id => l_note_id,
780: p_last_update_date => FND_API.G_MISS_DATE,
781: p_last_updated_by => G_USER_ID,
782: p_creation_date => FND_API.G_MISS_DATE,
783: p_note_context_type_id => l_note_context_type_id,
784: p_note_context_type => 'PARTY',
785: x_return_status => l_return_status,
786: x_note_context_id => l_context_id

Line 829: p_last_update_date => FND_API.G_MISS_DATE,

825: if (l_note_context_type_id is not null) then
826: jtf_notes_pub.Create_note_context
827: ( p_validation_level => l_valid_level_full,
828: p_jtf_note_id => l_note_id,
829: p_last_update_date => FND_API.G_MISS_DATE,
830: p_last_updated_by => G_USER_ID,
831: p_creation_date => FND_API.G_MISS_DATE,
832: p_note_context_type_id => l_note_context_type_id,
833: p_note_context_type => 'PARTY',

Line 831: p_creation_date => FND_API.G_MISS_DATE,

827: ( p_validation_level => l_valid_level_full,
828: p_jtf_note_id => l_note_id,
829: p_last_update_date => FND_API.G_MISS_DATE,
830: p_last_updated_by => G_USER_ID,
831: p_creation_date => FND_API.G_MISS_DATE,
832: p_note_context_type_id => l_note_context_type_id,
833: p_note_context_type => 'PARTY',
834: x_return_status => l_return_status,
835: x_note_context_id => l_context_id

Line 880: p_last_update_date => FND_API.G_MISS_DATE,

876: if (l_note_context_type_id is not null) then
877: jtf_notes_pub.Create_note_context
878: ( p_validation_level => l_valid_level_full,
879: p_jtf_note_id => l_note_id,
880: p_last_update_date => FND_API.G_MISS_DATE,
881: p_last_updated_by => G_USER_ID,
882: p_creation_date => FND_API.G_MISS_DATE,
883: p_note_context_type_id => l_note_context_type_id,
884: p_note_context_type => 'PARTY',

Line 882: p_creation_date => FND_API.G_MISS_DATE,

878: ( p_validation_level => l_valid_level_full,
879: p_jtf_note_id => l_note_id,
880: p_last_update_date => FND_API.G_MISS_DATE,
881: p_last_updated_by => G_USER_ID,
882: p_creation_date => FND_API.G_MISS_DATE,
883: p_note_context_type_id => l_note_context_type_id,
884: p_note_context_type => 'PARTY',
885: x_return_status => l_return_status,
886: x_note_context_id => l_context_id

Line 934: p_last_update_date => FND_API.G_MISS_DATE,

930: if (l_note_context_type_id is not null) then
931: jtf_notes_pub.Create_note_context
932: ( p_validation_level => l_valid_level_full,
933: p_jtf_note_id => l_note_id,
934: p_last_update_date => FND_API.G_MISS_DATE,
935: p_last_updated_by => G_USER_ID,
936: p_creation_date => FND_API.G_MISS_DATE,
937: p_note_context_type_id => l_note_context_type_id,
938: p_note_context_type => 'PARTY',

Line 936: p_creation_date => FND_API.G_MISS_DATE,

932: ( p_validation_level => l_valid_level_full,
933: p_jtf_note_id => l_note_id,
934: p_last_update_date => FND_API.G_MISS_DATE,
935: p_last_updated_by => G_USER_ID,
936: p_creation_date => FND_API.G_MISS_DATE,
937: p_note_context_type_id => l_note_context_type_id,
938: p_note_context_type => 'PARTY',
939: x_return_status => l_return_status,
940: x_note_context_id => l_context_id

Line 998: p_last_update_date => FND_API.G_MISS_DATE,

994: if (l_note_context_type_id is not null) then
995: jtf_notes_pub.Create_note_context
996: ( p_validation_level => l_valid_level_full,
997: p_jtf_note_id => l_note_id,
998: p_last_update_date => FND_API.G_MISS_DATE,
999: p_last_updated_by => G_USER_ID,
1000: p_creation_date => FND_API.G_MISS_DATE,
1001: p_note_context_type_id => l_note_context_type_id,
1002: p_note_context_type => 'PARTY',

Line 1000: p_creation_date => FND_API.G_MISS_DATE,

996: ( p_validation_level => l_valid_level_full,
997: p_jtf_note_id => l_note_id,
998: p_last_update_date => FND_API.G_MISS_DATE,
999: p_last_updated_by => G_USER_ID,
1000: p_creation_date => FND_API.G_MISS_DATE,
1001: p_note_context_type_id => l_note_context_type_id,
1002: p_note_context_type => 'PARTY',
1003: x_return_status => l_return_status,
1004: x_note_context_id => l_context_id

Line 1062: p_last_update_date => FND_API.G_MISS_DATE,

1058: if (l_note_context_type_id is not null) then
1059: jtf_notes_pub.Create_note_context
1060: ( p_validation_level => l_valid_level_full,
1061: p_jtf_note_id => l_note_id,
1062: p_last_update_date => FND_API.G_MISS_DATE,
1063: p_last_updated_by => G_USER_ID,
1064: p_creation_date => FND_API.G_MISS_DATE,
1065: p_note_context_type_id => l_note_context_type_id,
1066: p_note_context_type => 'PARTY',

Line 1064: p_creation_date => FND_API.G_MISS_DATE,

1060: ( p_validation_level => l_valid_level_full,
1061: p_jtf_note_id => l_note_id,
1062: p_last_update_date => FND_API.G_MISS_DATE,
1063: p_last_updated_by => G_USER_ID,
1064: p_creation_date => FND_API.G_MISS_DATE,
1065: p_note_context_type_id => l_note_context_type_id,
1066: p_note_context_type => 'PARTY',
1067: x_return_status => l_return_status,
1068: x_note_context_id => l_context_id

Line 1113: x_return_status := fnd_api.g_ret_sts_unexp_error;

1109: x_return_status := G_UNEXP_ERROR;
1110:
1111: fnd_message.set_name ('IEU', 'IEU_STATUS_TYPE_FAIL');
1112: fnd_msg_pub.add;
1113: x_return_status := fnd_api.g_ret_sts_unexp_error;
1114: fnd_msg_pub.count_and_get (
1115: p_count => x_msg_count,
1116: p_data => x_msg_data
1117: );

Line 1124: x_return_status := fnd_api.g_ret_sts_unexp_error;

1120: x_return_status := G_UNEXP_ERROR;
1121:
1122: fnd_message.set_name ('IEU', 'IEU_TASK_NAME_FAIL');
1123: fnd_msg_pub.add;
1124: x_return_status := fnd_api.g_ret_sts_unexp_error;
1125: fnd_msg_pub.count_and_get (
1126: p_count => x_msg_count,
1127: p_data => x_msg_data
1128: );

Line 1136: x_return_status := fnd_api.g_ret_sts_unexp_error;

1132: --fnd_message.set_name ('IEU', 'IEU_STATUS_TYPE_FAIL');
1133: if (l_msg_count is null) or (l_msg_count < 1) then
1134: fnd_message.set_name ('IEU', 'IEU_UPDATE_TASK_FAIL');
1135: fnd_msg_pub.add;
1136: x_return_status := fnd_api.g_ret_sts_unexp_error;
1137: fnd_msg_pub.count_and_get (
1138: p_count => x_msg_count,
1139: p_data => x_msg_data
1140: );