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 681: -- p_parent_note_id => fnd_api.g_miss_num,

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,

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

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,

Line 751: p_last_update_date => FND_API.G_MISS_DATE,

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,

Line 753: p_creation_date => FND_API.G_MISS_DATE,

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

Line 799: p_last_update_date => FND_API.G_MISS_DATE,

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',

Line 801: p_creation_date => FND_API.G_MISS_DATE,

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

Line 848: p_last_update_date => FND_API.G_MISS_DATE,

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',

Line 850: p_creation_date => FND_API.G_MISS_DATE,

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

Line 899: p_last_update_date => FND_API.G_MISS_DATE,

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',

Line 901: p_creation_date => FND_API.G_MISS_DATE,

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

Line 953: p_last_update_date => FND_API.G_MISS_DATE,

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',

Line 955: p_creation_date => FND_API.G_MISS_DATE,

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

Line 1017: p_last_update_date => FND_API.G_MISS_DATE,

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',

Line 1019: p_creation_date => FND_API.G_MISS_DATE,

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

Line 1081: p_last_update_date => FND_API.G_MISS_DATE,

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',

Line 1083: p_creation_date => FND_API.G_MISS_DATE,

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

Line 1132: x_return_status := fnd_api.g_ret_sts_unexp_error;

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: );

Line 1143: x_return_status := fnd_api.g_ret_sts_unexp_error;

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: );

Line 1155: x_return_status := fnd_api.g_ret_sts_unexp_error;

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: );