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

Line 17: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)

13: IS
14: l_debug_line NUMBER;
15: BEGIN
16: SAVEPOINT flm_delete_tasks;
17: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)
18: THEN
19: FND_MSG_PUB.initialize;
20: END IF;
21:

Line 22: x_return_status := FND_API.G_RET_STS_SUCCESS;

18: THEN
19: FND_MSG_PUB.initialize;
20: END IF;
21:
22: x_return_status := FND_API.G_RET_STS_SUCCESS;
23:
24: l_debug_line := 10;
25: DELETE FROM FLM_SEQ_TASK_EXCEPTIONS
26: WHERE SEQ_TASK_ID = p_seq_task_id;

Line 52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

48: l_debug_line := 70;
49:
50: EXCEPTION
51: WHEN OTHERS THEN
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
53: ROLLBACK TO flm_delete_tasks;
54:
55: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
56: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_ui' ,'delete_tasks('||l_debug_line||')');

Line 76: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)

72: PRAGMA AUTONOMOUS_TRANSACTION;
73: l_debug_line NUMBER;
74: BEGIN
75: SAVEPOINT flm_delete_tasks_commit;
76: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)
77: THEN
78: FND_MSG_PUB.initialize;
79: END IF;
80:

Line 81: x_return_status := FND_API.G_RET_STS_SUCCESS;

77: THEN
78: FND_MSG_PUB.initialize;
79: END IF;
80:
81: x_return_status := FND_API.G_RET_STS_SUCCESS;
82:
83: l_debug_line := 10;
84: delete_tasks(p_seq_task_id,'F', x_return_status, x_msg_count, x_msg_data);
85: l_debug_line := 20;

Line 91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

87: commit;
88:
89: EXCEPTION
90: WHEN OTHERS THEN
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92: ROLLBACK TO flm_delete_tasks_commit;
93:
94: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
95: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_ui' ,'delete_tasks_commit('||l_debug_line||')');

Line 191: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)

187: END get_excluded_hours;
188:
189: BEGIN
190: SAVEPOINT flm_line_available_capacity;
191: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)
192: THEN
193: FND_MSG_PUB.initialize;
194: END IF;
195:

Line 197: x_return_status := FND_API.G_RET_STS_SUCCESS;

193: FND_MSG_PUB.initialize;
194: END IF;
195:
196: l_debug_line := 10;
197: x_return_status := FND_API.G_RET_STS_SUCCESS;
198:
199: --fix bug#3170105
200: flm_timezone.init_timezone(p_organization_id);
201:

Line 319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

315: l_debug_line := 80;
316:
317: EXCEPTION
318: WHEN OTHERS THEN
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
320: x_capacity := -1;
321: ROLLBACK TO flm_line_available_capacity;
322:
323: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 371: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)

367: FROM FLM_SEQ_TASK_LINES
368: WHERE SEQ_TASK_ID = p_seq_task_id;
369: BEGIN
370: SAVEPOINT flm_insert_demands;
371: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)
372: THEN
373: FND_MSG_PUB.initialize;
374: END IF;
375:

Line 377: x_return_status := FND_API.G_RET_STS_SUCCESS;

373: FND_MSG_PUB.initialize;
374: END IF;
375:
376: l_debug_line := 10;
377: x_return_status := FND_API.G_RET_STS_SUCCESS;
378:
379: --Added Planning Recomendation flag for bug fix:7305721
380: SELECT NVL(DEMAND_CRITERIA_GROUP_ID,-1),NVL(ALTERNATE_ROUTING_FLAG,'N'),SEQ_TASK_TYPE, ORGANIZATION_ID,
381: TO_CHAR(DEMAND_START_DATE,'DD-MON-RR HH24:MI:SS'), TO_CHAR(DEMAND_END_DATE,'DD-MON-RR HH24:MI:SS'),

Line 390: x_return_status := FND_API.G_RET_STS_SUCCESS;

386: WHERE SEQ_TASK_ID = p_seq_task_id;
387:
388: l_debug_line := 20;
389: IF l_seq_task_type = FLM_CONSTANTS.SEQ_TASK_RESEQ THEN
390: x_return_status := FND_API.G_RET_STS_SUCCESS;
391: return;
392: END IF;
393:
394: l_debug_line := 30;

Line 431: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

427:
428: l_debug_line := 40;
429: flm_filter_criteria_process.get_filter_clause(l_criteria_group_id,'MUOV',NULL,l_filter,
430: l_return_status,l_msg_count,l_msg_data);
431: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
432: x_return_status := l_return_status;
433: x_msg_count := l_msg_count;
434: x_msg_data := l_msg_data;
435: return;

Line 465: x_return_status := FND_API.G_RET_STS_ERROR;

461: dbms_sql.close_cursor(l_cursor);
462:
463: IF (p_max_rows IS NOT NULL AND p_max_rows <> -1 AND l_count_rows > p_max_rows) THEN
464: ROLLBACK TO flm_insert_demands;
465: x_return_status := FND_API.G_RET_STS_ERROR;
466:
467: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
468: FND_MESSAGE.SET_NAME('FLM','FLM_SEQ_DEMAND_EXCEEDED');
469: FND_MSG_PUB.Add;

Line 512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

508:
509: EXCEPTION
510: WHEN OTHERS THEN
511: ROLLBACK TO flm_insert_demands;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
513:
514: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
515: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_ui' ,'insert_demands('||l_debug_line||')');
516: END IF;

Line 535: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)

531: IS
532: l_debug_line NUMBER;
533: BEGIN
534: SAVEPOINT flm_get_demand_qty;
535: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)
536: THEN
537: FND_MSG_PUB.initialize;
538: END IF;
539:

Line 547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

543: l_debug_line := 20;
544: EXCEPTION
545: WHEN OTHERS THEN
546: ROLLBACK TO flm_get_demand_qty;
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548:
549: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
550: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_ui' ,'get_demand_qty('||l_debug_line||')');
551: END IF;

Line 570: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)

566: IS
567: l_debug_line NUMBER;
568: BEGIN
569: SAVEPOINT flm_delete_demands;
570: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)
571: THEN
572: FND_MSG_PUB.initialize;
573: END IF;
574:

Line 576: x_return_status := FND_API.G_RET_STS_SUCCESS;

572: FND_MSG_PUB.initialize;
573: END IF;
574:
575: l_debug_line := 10;
576: x_return_status := FND_API.G_RET_STS_SUCCESS;
577:
578: DELETE FROM FLM_SEQ_TASK_DEMANDS WHERE SEQ_TASK_ID = p_seq_task_id;
579: l_debug_line := 20;
580:

Line 584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

580:
581: EXCEPTION
582: WHEN OTHERS THEN
583: ROLLBACK TO flm_delete_demands;
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585:
586: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
587: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_ui' ,'delete_demands('||l_debug_line||')');
588: END IF;

Line 607: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)

603: l_debug_line NUMBER;
604: l_criteria_group_id NUMBER;
605: BEGIN
606: SAVEPOINT flm_delete_criteria;
607: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)
608: THEN
609: FND_MSG_PUB.initialize;
610: END IF;
611:

Line 613: x_return_status := FND_API.G_RET_STS_SUCCESS;

609: FND_MSG_PUB.initialize;
610: END IF;
611:
612: l_debug_line := 10;
613: x_return_status := FND_API.G_RET_STS_SUCCESS;
614:
615: l_debug_line := 20;
616: SELECT NVL(DEMAND_CRITERIA_GROUP_ID,-1)
617: INTO l_criteria_group_id

Line 629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

625:
626: EXCEPTION
627: WHEN OTHERS THEN
628: ROLLBACK TO flm_delete_criteria;
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630:
631: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
632: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_ui' ,'delete_criteria('||l_debug_line||')');
633: END IF;

Line 654: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)

650: IS
651: l_debug_line NUMBER;
652: BEGIN
653: SAVEPOINT flm_insert_line_constraints;
654: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)
655: THEN
656: FND_MSG_PUB.initialize;
657: END IF;
658:

Line 660: x_return_status := FND_API.G_RET_STS_SUCCESS;

656: FND_MSG_PUB.initialize;
657: END IF;
658:
659: l_debug_line := 10;
660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661:
662: INSERT INTO FLM_SEQ_TASK_LINES (
663: SEQ_TASK_ID,
664: LINE_ID,

Line 783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

779:
780: EXCEPTION
781: WHEN OTHERS THEN
782: ROLLBACK TO flm_insert_line_constraints;
783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
784:
785: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
786: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_ui' ,'insert_line_constraints('||l_debug_line||')');
787: END IF;

Line 805: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)

801: IS
802: l_debug_line NUMBER;
803: BEGIN
804: SAVEPOINT flm_delete_line_constraints;
805: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)
806: THEN
807: FND_MSG_PUB.initialize;
808: END IF;
809:

Line 811: x_return_status := FND_API.G_RET_STS_SUCCESS;

807: FND_MSG_PUB.initialize;
808: END IF;
809:
810: l_debug_line := 10;
811: x_return_status := FND_API.G_RET_STS_SUCCESS;
812:
813: DELETE FROM FLM_SEQ_TASK_LINES WHERE SEQ_TASK_ID = p_seq_task_id;
814: l_debug_line := 20;
815:

Line 823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

819: EXCEPTION
820:
821: WHEN OTHERS THEN
822: ROLLBACK TO flm_delete_line_constraints;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
824:
825: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
826: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_ui' ,'delete_line_constraints('||l_debug_line||')');
827: END IF;

Line 847: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)

843: IS
844: l_debug_line NUMBER;
845: BEGIN
846: SAVEPOINT flm_get_min_wip_entity_id;
847: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)
848: THEN
849: FND_MSG_PUB.initialize;
850: END IF;
851:

Line 853: x_return_status := FND_API.G_RET_STS_SUCCESS;

849: FND_MSG_PUB.initialize;
850: END IF;
851:
852: l_debug_line := 10;
853: x_return_status := FND_API.G_RET_STS_SUCCESS;
854:
855: SELECT min(wip_entity_id)
856: INTO x_wip_entity_id
857: FROM WIP_FLOW_SCHEDULES

Line 865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

861: l_debug_line := 20;
862: EXCEPTION
863: WHEN OTHERS THEN
864: ROLLBACK TO flm_get_min_wip_entity_id;
865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866:
867: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
868: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_ui' ,'get_min_wip_entity_id('||l_debug_line||')');
869: END IF;

Line 896: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)

892: l_msg_data VARCHAR2(1000);
893: BEGIN
894:
895: SAVEPOINT flm_data_cleanup;
896: IF p_init_msg_list IS NOT NULL AND FND_API.TO_BOOLEAN(p_init_msg_list)
897: THEN
898: FND_MSG_PUB.initialize;
899: END IF;
900:

Line 902: x_return_status := FND_API.G_RET_STS_SUCCESS;

898: FND_MSG_PUB.initialize;
899: END IF;
900:
901: l_debug_line := 10;
902: x_return_status := FND_API.G_RET_STS_SUCCESS;
903:
904: FOR l_task_rec IN l_task_cursor LOOP
905: delete_tasks(l_task_rec.seq_task_id, 'F', l_return_status, l_msg_count, l_msg_data);
906: END LOOP;

Line 912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

908:
909: EXCEPTION
910: WHEN OTHERS THEN
911: ROLLBACK TO flm_data_cleanup;
912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
913:
914: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
915: FND_MSG_PUB.Add_Exc_Msg ('flm_seq_ui' ,'data_cleanup('||l_debug_line||')');
916: END IF;