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

Line 608: x_return_status := fnd_api.g_ret_sts_success;

604: where release_id = p_release_id
605: and trip_id = l_trip_id_tab(i);
606: end if;
607:
608: x_return_status := fnd_api.g_ret_sts_success;
609: print_info(g_log_flow_of_control,'remove_unqualified_trips : Program ended');
610: exception
611: when others then
612: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 612: x_return_status := fnd_api.g_ret_sts_unexp_error;

608: x_return_status := fnd_api.g_ret_sts_success;
609: print_info(g_log_flow_of_control,'remove_unqualified_trips : Program ended');
610: exception
611: when others then
612: x_return_status := fnd_api.g_ret_sts_unexp_error;
613: print_info(g_log_flow_of_control,'remove_unqualified_trips : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
614: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
615: end remove_unqualified_trips;
616:

Line 769: x_return_status := fnd_api.g_ret_sts_success;

765:
766: end if;
767: close cur_cm;
768:
769: x_return_status := fnd_api.g_ret_sts_success;
770: print_info(g_log_flow_of_control,'populate_related_trip_thru_cm for CM = '||p_cm_id_of_trip||' Program ended');
771: exception
772: when others then
773: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 773: x_return_status := fnd_api.g_ret_sts_unexp_error;

769: x_return_status := fnd_api.g_ret_sts_success;
770: print_info(g_log_flow_of_control,'populate_related_trip_thru_cm for CM = '||p_cm_id_of_trip||' Program ended');
771: exception
772: when others then
773: x_return_status := fnd_api.g_ret_sts_unexp_error;
774: print_info(g_log_flow_of_control,'populate_related_trip_thru_cm : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
775: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
776: end populate_related_trip_thru_cm;
777:

Line 878: x_return_status := fnd_api.g_ret_sts_success;

874: and mdl_rel.trip_id <> mdl.trip_id
875: and mdl.plan_id = p_plan_id
876: and mdl.trip_id = p_trip_id);
877:
878: x_return_status := fnd_api.g_ret_sts_success;
879: print_info(g_log_flow_of_control,'populate_related_trip_thru_del for trip = '||p_trip_id||' : Program ended');
880: exception
881: when others then
882: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 882: x_return_status := fnd_api.g_ret_sts_unexp_error;

878: x_return_status := fnd_api.g_ret_sts_success;
879: print_info(g_log_flow_of_control,'populate_related_trip_thru_del for trip = '||p_trip_id||' : Program ended');
880: exception
881: when others then
882: x_return_status := fnd_api.g_ret_sts_unexp_error;
883: print_info(g_log_flow_of_control,'populate_related_trip_thru_del : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
884: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
885: end populate_related_trip_thru_del;
886:

Line 943: if l_return_status <> fnd_api.g_ret_sts_success then

939: and trip_id = l_trip_id;
940:
941: if l_cm_id_of_trip is not null then -- means this trips is part of a continuous move
942: populate_related_trip_thru_cm(l_return_status, p_plan_id, p_release_id, l_cm_id_of_trip, l_planned_flag, l_group_id);
943: if l_return_status <> fnd_api.g_ret_sts_success then
944: raise l_error_from_called_procedure;
945: end if;
946: end if;
947:

Line 949: if l_return_status <> fnd_api.g_ret_sts_success then

945: end if;
946: end if;
947:
948: populate_related_trip_thru_del(l_return_status, p_plan_id, p_release_id, l_trip_id, l_planned_flag, l_group_id);
949: if l_return_status <> fnd_api.g_ret_sts_success then
950: raise l_error_from_called_procedure;
951: end if;
952: end loop;
953:

Line 954: x_return_status := fnd_api.g_ret_sts_success;

950: raise l_error_from_called_procedure;
951: end if;
952: end loop;
953:
954: x_return_status := fnd_api.g_ret_sts_success;
955: print_info(g_log_flow_of_control,'populate_related_trips : Program ended');
956: exception
957: when l_error_from_called_procedure then
958: x_return_status := fnd_api.g_ret_sts_error;

Line 958: x_return_status := fnd_api.g_ret_sts_error;

954: x_return_status := fnd_api.g_ret_sts_success;
955: print_info(g_log_flow_of_control,'populate_related_trips : Program ended');
956: exception
957: when l_error_from_called_procedure then
958: x_return_status := fnd_api.g_ret_sts_error;
959: when others then
960: x_return_status := fnd_api.g_ret_sts_unexp_error;
961: print_info(g_log_flow_of_control,'populate_related_trips : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
962: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);

Line 960: x_return_status := fnd_api.g_ret_sts_unexp_error;

956: exception
957: when l_error_from_called_procedure then
958: x_return_status := fnd_api.g_ret_sts_error;
959: when others then
960: x_return_status := fnd_api.g_ret_sts_unexp_error;
961: print_info(g_log_flow_of_control,'populate_related_trips : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
962: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
963: end populate_related_trips;
964:

Line 1005: x_return_status := fnd_api.g_ret_sts_success;

1001: end loop;
1002: print_info(g_log_must_message,'');
1003: end if;
1004:
1005: x_return_status := fnd_api.g_ret_sts_success;
1006: print_info(g_log_flow_of_control,'remove_grp_of_passed_dep_dt : Program ended');
1007: exception
1008: when others then
1009: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1009: x_return_status := fnd_api.g_ret_sts_unexp_error;

1005: x_return_status := fnd_api.g_ret_sts_success;
1006: print_info(g_log_flow_of_control,'remove_grp_of_passed_dep_dt : Program ended');
1007: exception
1008: when others then
1009: x_return_status := fnd_api.g_ret_sts_unexp_error;
1010: print_info(g_log_flow_of_control,'remove_grp_of_passed_dep_dt : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
1011: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
1012: end remove_grp_of_passed_dep_dt;
1013:

Line 1100: x_return_status := fnd_api.g_ret_sts_success;

1096: and group_id = l_group_id_tobedeleted_tab(i);
1097: end if;
1098: end if;
1099:
1100: x_return_status := fnd_api.g_ret_sts_success;
1101: print_info(g_log_flow_of_control,'remove_grp_of_exceptions : Program ended');
1102: exception
1103: when others then
1104: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1104: x_return_status := fnd_api.g_ret_sts_unexp_error;

1100: x_return_status := fnd_api.g_ret_sts_success;
1101: print_info(g_log_flow_of_control,'remove_grp_of_exceptions : Program ended');
1102: exception
1103: when others then
1104: x_return_status := fnd_api.g_ret_sts_unexp_error;
1105: print_info(g_log_flow_of_control,'remove_grp_of_exceptions : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
1106: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
1107: end remove_grp_of_exceptions;
1108:

Line 1164: x_return_status := fnd_api.g_ret_sts_success;

1160: end if;
1161: end if;
1162: end if;
1163:
1164: x_return_status := fnd_api.g_ret_sts_success;
1165: print_info(g_log_flow_of_control,'remove_grp_of_unwanted_trip : Program ended');
1166: exception
1167: when others then
1168: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1168: x_return_status := fnd_api.g_ret_sts_unexp_error;

1164: x_return_status := fnd_api.g_ret_sts_success;
1165: print_info(g_log_flow_of_control,'remove_grp_of_unwanted_trip : Program ended');
1166: exception
1167: when others then
1168: x_return_status := fnd_api.g_ret_sts_unexp_error;
1169: print_info(g_log_flow_of_control,'remove_grp_of_unwanted_trip : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
1170: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
1171: end remove_grp_of_unwanted_trip;
1172: */

Line 1219: x_return_status := fnd_api.g_ret_sts_success;

1215:
1216: end if;
1217: end loop;
1218:
1219: x_return_status := fnd_api.g_ret_sts_success;
1220: print_info(g_log_flow_of_control,'reset_grp_ids_in_sequence_of_1 : Program ended');
1221: exception
1222: when others then
1223: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1223: x_return_status := fnd_api.g_ret_sts_unexp_error;

1219: x_return_status := fnd_api.g_ret_sts_success;
1220: print_info(g_log_flow_of_control,'reset_grp_ids_in_sequence_of_1 : Program ended');
1221: exception
1222: when others then
1223: x_return_status := fnd_api.g_ret_sts_unexp_error;
1224: print_info(g_log_flow_of_control,'reset_grp_ids_in_sequence_of_1 : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
1225: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
1226: end reset_grp_ids_in_sequence_of_1;
1227:

Line 1343: x_return_status := fnd_api.g_ret_sts_success;

1339: AND mrt1.release_id = p_release_id
1340: AND mrt1.trip_id IS NOT NULL
1341: AND mrt1.planned_flag = 1);
1342:
1343: x_return_status := fnd_api.g_ret_sts_success;
1344: print_info(g_log_flow_of_control,'populate_deliveries : Program ended');
1345: exception
1346: when others then
1347: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1347: x_return_status := fnd_api.g_ret_sts_unexp_error;

1343: x_return_status := fnd_api.g_ret_sts_success;
1344: print_info(g_log_flow_of_control,'populate_deliveries : Program ended');
1345: exception
1346: when others then
1347: x_return_status := fnd_api.g_ret_sts_unexp_error;
1348: print_info(g_log_flow_of_control,'populate_deliveries : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
1349: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
1350: end populate_deliveries;
1351:

Line 1362: and (wdd_iface.source_header_id is null or wdd_iface.source_line_id = FND_API.G_MISS_NUM or wdd_iface.source_line_set_id is null)

1358: , wsh_del_details_interface wdd_iface
1359: where wdd.source_code = wdd_iface.source_code
1360: and wdd.source_header_number = wdd_iface.source_header_number
1361: and substr(wdd.source_line_number,1,instr(wdd.source_line_number||'.','.',1,1)-1) = substr(wdd_iface.source_line_number,1,instr(wdd_iface.source_line_number||'.','.',1,1)-1)
1362: and (wdd_iface.source_header_id is null or wdd_iface.source_line_id = FND_API.G_MISS_NUM or wdd_iface.source_line_set_id is null)
1363: and wdd_iface.delivery_detail_interface_id = mrt.delivery_detail_id_iface
1364: and mrt.release_id = l_release_id
1365: group by wdd_iface.delivery_detail_interface_id;
1366:

Line 2110: , nvl(wdd.source_line_id,FND_API.G_MISS_NUM)

2106: , mrt.ship_set_id
2107: , mrt.arrival_set_id
2108: , mrt.organization_id
2109: , mrt.org_id
2110: , nvl(wdd.source_line_id,FND_API.G_MISS_NUM)
2111: , decode(mrt.container_flag,1,'Y','N')
2112: , mrt.source_line_number
2113: , mrt.split_from_delivery_detail_id
2114: , mrt.earliest_pickup_date

Line 2146: x_return_status := fnd_api.g_ret_sts_success;

2142:
2143: update_ids_in_wdd_iface_tab (p_release_id);
2144: update_loc_id_in_iface_tab (p_release_id);
2145:
2146: x_return_status := fnd_api.g_ret_sts_success;
2147: print_info(g_log_flow_of_control,'populate_interface_tables : Program ended');
2148: exception
2149: when others then
2150: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2150: x_return_status := fnd_api.g_ret_sts_unexp_error;

2146: x_return_status := fnd_api.g_ret_sts_success;
2147: print_info(g_log_flow_of_control,'populate_interface_tables : Program ended');
2148: exception
2149: when others then
2150: x_return_status := fnd_api.g_ret_sts_unexp_error;
2151: print_info(g_log_flow_of_control,'populate_interface_tables : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
2152: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
2153: end populate_interface_tables;
2154:

Line 2210: x_return_status := fnd_api.g_ret_sts_success;

2206: g_cnt_cm_failed := g_cnt_cm_failed + nvl(l_continuous_move_id_tab.last,0);
2207: end if;
2208: end if;
2209:
2210: x_return_status := fnd_api.g_ret_sts_success;
2211: print_info(g_log_flow_of_control,'update_mst_cm_trips for group '||p_group_id||' : Program ended');
2212: exception
2213: when others then
2214: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2214: x_return_status := fnd_api.g_ret_sts_unexp_error;

2210: x_return_status := fnd_api.g_ret_sts_success;
2211: print_info(g_log_flow_of_control,'update_mst_cm_trips for group '||p_group_id||' : Program ended');
2212: exception
2213: when others then
2214: x_return_status := fnd_api.g_ret_sts_unexp_error;
2215: print_info(g_log_flow_of_control,'update_mst_cm_trips : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
2216: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
2217: end update_mst_cm_trips;
2218:

Line 2333: x_return_status := fnd_api.g_ret_sts_success;

2329: g_cnt_deadhead_failed := g_cnt_deadhead_failed + get_statistics(p_release_id, p_plan_id, p_group_id, 'DEADHEAD');
2330: end if;
2331: end if;
2332:
2333: x_return_status := fnd_api.g_ret_sts_success;
2334: print_info(g_log_flow_of_control,'update_mst_trips for group '||p_group_id||' : Program ended');
2335: exception
2336: when others then
2337: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2337: x_return_status := fnd_api.g_ret_sts_unexp_error;

2333: x_return_status := fnd_api.g_ret_sts_success;
2334: print_info(g_log_flow_of_control,'update_mst_trips for group '||p_group_id||' : Program ended');
2335: exception
2336: when others then
2337: x_return_status := fnd_api.g_ret_sts_unexp_error;
2338: print_info(g_log_flow_of_control,'update_mst_trips : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
2339: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
2340: end update_mst_trips;
2341:

Line 2380: x_return_status := fnd_api.g_ret_sts_success;

2376: and delivery_id = l_delivery_id_tab(i);
2377: end if;
2378: end if;
2379:
2380: x_return_status := fnd_api.g_ret_sts_success;
2381: print_info(g_log_flow_of_control,'update_mst_deliveries for group '||p_group_id||' : Program ended');
2382: exception
2383: when others then
2384: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2384: x_return_status := fnd_api.g_ret_sts_unexp_error;

2380: x_return_status := fnd_api.g_ret_sts_success;
2381: print_info(g_log_flow_of_control,'update_mst_deliveries for group '||p_group_id||' : Program ended');
2382: exception
2383: when others then
2384: x_return_status := fnd_api.g_ret_sts_unexp_error;
2385: print_info(g_log_flow_of_control,'update_mst_deliveries : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
2386: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
2387: end update_mst_deliveries;
2388:

Line 2427: x_return_status := fnd_api.g_ret_sts_success;

2423: and trip_id = l_trip_id_tab(i);
2424: end if;
2425: end if;
2426:
2427: x_return_status := fnd_api.g_ret_sts_success;
2428: print_info(g_log_flow_of_control,'update_sr_ids_in_mt for group '||p_group_id||' : Program ended');
2429: exception
2430: when others then
2431: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2431: x_return_status := fnd_api.g_ret_sts_unexp_error;

2427: x_return_status := fnd_api.g_ret_sts_success;
2428: print_info(g_log_flow_of_control,'update_sr_ids_in_mt for group '||p_group_id||' : Program ended');
2429: exception
2430: when others then
2431: x_return_status := fnd_api.g_ret_sts_unexp_error;
2432: print_info(g_log_flow_of_control,'update_sr_ids_in_mt : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
2433: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
2434: end update_sr_ids_in_mt;
2435:

Line 2474: x_return_status := fnd_api.g_ret_sts_success;

2470: and delivery_id = l_delivery_id_tab(i);
2471: end if;
2472: end if;
2473:
2474: x_return_status := fnd_api.g_ret_sts_success;
2475: print_info(g_log_flow_of_control,'update_sr_ids_in_md for group '||p_group_id||' : Program ended');
2476: exception
2477: when others then
2478: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2478: x_return_status := fnd_api.g_ret_sts_unexp_error;

2474: x_return_status := fnd_api.g_ret_sts_success;
2475: print_info(g_log_flow_of_control,'update_sr_ids_in_md for group '||p_group_id||' : Program ended');
2476: exception
2477: when others then
2478: x_return_status := fnd_api.g_ret_sts_unexp_error;
2479: print_info(g_log_flow_of_control,'update_sr_ids_in_md : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
2480: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
2481: end update_sr_ids_in_md;
2482:

Line 2521: x_return_status := fnd_api.g_ret_sts_success;

2517: and delivery_detail_id = l_delivery_detail_id_tab(i);
2518: end if;
2519: end if;
2520:
2521: x_return_status := fnd_api.g_ret_sts_success;
2522: print_info(g_log_flow_of_control,'update_sr_ids_in_mdd for group '||p_group_id||' : Program ended');
2523: exception
2524: when others then
2525: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2525: x_return_status := fnd_api.g_ret_sts_unexp_error;

2521: x_return_status := fnd_api.g_ret_sts_success;
2522: print_info(g_log_flow_of_control,'update_sr_ids_in_mdd for group '||p_group_id||' : Program ended');
2523: exception
2524: when others then
2525: x_return_status := fnd_api.g_ret_sts_unexp_error;
2526: print_info(g_log_flow_of_control,'update_sr_ids_in_mdd : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
2527: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
2528: end update_sr_ids_in_mdd;
2529:

Line 2586: if l_return_status <> fnd_api.g_ret_sts_success then

2582: end if;
2583: close cur_check_error;
2584:
2585: update_mst_cm_trips (l_return_status, p_group_tab(i), p_plan_id, p_release_id, p_release_mode, l_date, l_error_found);
2586: if l_return_status <> fnd_api.g_ret_sts_success then
2587: raise l_error_from_called_procedure;
2588: else
2589: update_mst_trips (l_return_status, p_group_tab(i), p_plan_id, p_release_id, p_release_mode, l_date, l_error_found);
2590: if l_return_status <> fnd_api.g_ret_sts_success then

Line 2590: if l_return_status <> fnd_api.g_ret_sts_success then

2586: if l_return_status <> fnd_api.g_ret_sts_success then
2587: raise l_error_from_called_procedure;
2588: else
2589: update_mst_trips (l_return_status, p_group_tab(i), p_plan_id, p_release_id, p_release_mode, l_date, l_error_found);
2590: if l_return_status <> fnd_api.g_ret_sts_success then
2591: raise l_error_from_called_procedure;
2592: else
2593: if l_error_found = 0 then -- if successful only proceed
2594: update_mst_deliveries (l_return_status, p_group_tab(i), p_plan_id, p_release_id, l_error_found);

Line 2595: if l_return_status <> fnd_api.g_ret_sts_success then

2591: raise l_error_from_called_procedure;
2592: else
2593: if l_error_found = 0 then -- if successful only proceed
2594: update_mst_deliveries (l_return_status, p_group_tab(i), p_plan_id, p_release_id, l_error_found);
2595: if l_return_status <> fnd_api.g_ret_sts_success then
2596: raise l_error_from_called_procedure;
2597: else
2598: update_sr_ids_in_mt (l_return_status, p_group_tab(i), p_plan_id, p_release_id, l_error_found);
2599: if l_return_status <> fnd_api.g_ret_sts_success then

Line 2599: if l_return_status <> fnd_api.g_ret_sts_success then

2595: if l_return_status <> fnd_api.g_ret_sts_success then
2596: raise l_error_from_called_procedure;
2597: else
2598: update_sr_ids_in_mt (l_return_status, p_group_tab(i), p_plan_id, p_release_id, l_error_found);
2599: if l_return_status <> fnd_api.g_ret_sts_success then
2600: raise l_error_from_called_procedure;
2601: else
2602: update_sr_ids_in_md (l_return_status, p_group_tab(i), p_plan_id, p_release_id, l_error_found);
2603: if l_return_status <> fnd_api.g_ret_sts_success then

Line 2603: if l_return_status <> fnd_api.g_ret_sts_success then

2599: if l_return_status <> fnd_api.g_ret_sts_success then
2600: raise l_error_from_called_procedure;
2601: else
2602: update_sr_ids_in_md (l_return_status, p_group_tab(i), p_plan_id, p_release_id, l_error_found);
2603: if l_return_status <> fnd_api.g_ret_sts_success then
2604: raise l_error_from_called_procedure;
2605: else
2606: update_sr_ids_in_mdd (l_return_status, p_group_tab(i), p_plan_id, p_release_id, l_error_found);
2607: if l_return_status <> fnd_api.g_ret_sts_success then

Line 2607: if l_return_status <> fnd_api.g_ret_sts_success then

2603: if l_return_status <> fnd_api.g_ret_sts_success then
2604: raise l_error_from_called_procedure;
2605: else
2606: update_sr_ids_in_mdd (l_return_status, p_group_tab(i), p_plan_id, p_release_id, l_error_found);
2607: if l_return_status <> fnd_api.g_ret_sts_success then
2608: raise l_error_from_called_procedure;
2609: end if;
2610: end if;
2611: end if;

Line 2644: x_return_status := fnd_api.g_ret_sts_success;

2640: end if;
2641: end loop;
2642: end if;
2643:
2644: x_return_status := fnd_api.g_ret_sts_success;
2645: print_info(g_log_flow_of_control,'update_tp_tables : Program ended');
2646: exception
2647: when l_error_from_called_procedure then
2648: x_return_status := fnd_api.g_ret_sts_error;

Line 2648: x_return_status := fnd_api.g_ret_sts_error;

2644: x_return_status := fnd_api.g_ret_sts_success;
2645: print_info(g_log_flow_of_control,'update_tp_tables : Program ended');
2646: exception
2647: when l_error_from_called_procedure then
2648: x_return_status := fnd_api.g_ret_sts_error;
2649: when others then
2650: x_return_status := fnd_api.g_ret_sts_unexp_error;
2651: print_info(g_log_flow_of_control,'update_tp_tables : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
2652: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);

Line 2650: x_return_status := fnd_api.g_ret_sts_unexp_error;

2646: exception
2647: when l_error_from_called_procedure then
2648: x_return_status := fnd_api.g_ret_sts_error;
2649: when others then
2650: x_return_status := fnd_api.g_ret_sts_unexp_error;
2651: print_info(g_log_flow_of_control,'update_tp_tables : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
2652: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
2653: end update_tp_tables;
2654:

Line 2840: x_return_status := fnd_api.g_ret_sts_success;

2836: from mst_release_temp
2837: where release_id = p_release_id
2838: );
2839:
2840: x_return_status := fnd_api.g_ret_sts_success;
2841: print_info(g_log_flow_of_control,'pull_into_global_temp_table : Program ended');
2842: exception
2843: when others then
2844: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2844: x_return_status := fnd_api.g_ret_sts_unexp_error;

2840: x_return_status := fnd_api.g_ret_sts_success;
2841: print_info(g_log_flow_of_control,'pull_into_global_temp_table : Program ended');
2842: exception
2843: when others then
2844: x_return_status := fnd_api.g_ret_sts_unexp_error;
2845: print_info(g_log_flow_of_control,'pull_into_global_temp_table : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
2846: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
2847: end pull_into_global_temp_table;
2848:

Line 2970: x_return_status := fnd_api.g_ret_sts_success;

2966: where mrt_gt.release_id = p_release_id
2967: and mrt_gt.plan_id = p_plan_id
2968: and mrt_gt.planned_flag in (-1111,-2222,-3333,-4444,-5555);
2969:
2970: x_return_status := fnd_api.g_ret_sts_success;
2971: print_info(g_log_flow_of_control,'compute_statistics : Program ended');
2972: exception
2973: when others then
2974: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2974: x_return_status := fnd_api.g_ret_sts_unexp_error;

2970: x_return_status := fnd_api.g_ret_sts_success;
2971: print_info(g_log_flow_of_control,'compute_statistics : Program ended');
2972: exception
2973: when others then
2974: x_return_status := fnd_api.g_ret_sts_unexp_error;
2975: print_info(g_log_flow_of_control,'compute_statistics : Unexpected error ' || to_char(sqlcode) || ':' || SQLERRM);
2976: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
2977: end compute_statistics;
2978:

Line 3017: if l_return_status = fnd_api.g_ret_sts_success then

3013: into l_release_start_date
3014: from dual;
3015:
3016: remove_unqualified_trips(l_return_status, p_plan_id, p_release_id);
3017: if l_return_status = fnd_api.g_ret_sts_success then
3018: populate_related_trips(l_return_status, p_plan_id, p_release_id);
3019: if l_return_status = fnd_api.g_ret_sts_success then
3020: remove_grp_of_passed_dep_dt (l_return_status, p_release_id,l_release_start_date);
3021: if l_return_status = fnd_api.g_ret_sts_success then

Line 3019: if l_return_status = fnd_api.g_ret_sts_success then

3015:
3016: remove_unqualified_trips(l_return_status, p_plan_id, p_release_id);
3017: if l_return_status = fnd_api.g_ret_sts_success then
3018: populate_related_trips(l_return_status, p_plan_id, p_release_id);
3019: if l_return_status = fnd_api.g_ret_sts_success then
3020: remove_grp_of_passed_dep_dt (l_return_status, p_release_id,l_release_start_date);
3021: if l_return_status = fnd_api.g_ret_sts_success then
3022: remove_grp_of_exceptions(l_return_status, p_plan_id, p_release_id, p_release_mode);
3023: if l_return_status = fnd_api.g_ret_sts_success then

Line 3021: if l_return_status = fnd_api.g_ret_sts_success then

3017: if l_return_status = fnd_api.g_ret_sts_success then
3018: populate_related_trips(l_return_status, p_plan_id, p_release_id);
3019: if l_return_status = fnd_api.g_ret_sts_success then
3020: remove_grp_of_passed_dep_dt (l_return_status, p_release_id,l_release_start_date);
3021: if l_return_status = fnd_api.g_ret_sts_success then
3022: remove_grp_of_exceptions(l_return_status, p_plan_id, p_release_id, p_release_mode);
3023: if l_return_status = fnd_api.g_ret_sts_success then
3024: --remove_grp_of_unwanted_trip(l_return_status, p_plan_id, p_release_id, p_release_mode);
3025: compute_statistics (l_return_status, p_plan_id, p_release_id);

Line 3023: if l_return_status = fnd_api.g_ret_sts_success then

3019: if l_return_status = fnd_api.g_ret_sts_success then
3020: remove_grp_of_passed_dep_dt (l_return_status, p_release_id,l_release_start_date);
3021: if l_return_status = fnd_api.g_ret_sts_success then
3022: remove_grp_of_exceptions(l_return_status, p_plan_id, p_release_id, p_release_mode);
3023: if l_return_status = fnd_api.g_ret_sts_success then
3024: --remove_grp_of_unwanted_trip(l_return_status, p_plan_id, p_release_id, p_release_mode);
3025: compute_statistics (l_return_status, p_plan_id, p_release_id);
3026: if l_return_status = fnd_api.g_ret_sts_success then
3027: reset_grp_ids_in_sequence_of_1(l_return_status, l_group_tab, p_plan_id, p_release_id);

Line 3026: if l_return_status = fnd_api.g_ret_sts_success then

3022: remove_grp_of_exceptions(l_return_status, p_plan_id, p_release_id, p_release_mode);
3023: if l_return_status = fnd_api.g_ret_sts_success then
3024: --remove_grp_of_unwanted_trip(l_return_status, p_plan_id, p_release_id, p_release_mode);
3025: compute_statistics (l_return_status, p_plan_id, p_release_id);
3026: if l_return_status = fnd_api.g_ret_sts_success then
3027: reset_grp_ids_in_sequence_of_1(l_return_status, l_group_tab, p_plan_id, p_release_id);
3028: if l_return_status = fnd_api.g_ret_sts_success then
3029: populate_deliveries(l_return_status, p_release_id);
3030: if l_return_status = fnd_api.g_ret_sts_success then

Line 3028: if l_return_status = fnd_api.g_ret_sts_success then

3024: --remove_grp_of_unwanted_trip(l_return_status, p_plan_id, p_release_id, p_release_mode);
3025: compute_statistics (l_return_status, p_plan_id, p_release_id);
3026: if l_return_status = fnd_api.g_ret_sts_success then
3027: reset_grp_ids_in_sequence_of_1(l_return_status, l_group_tab, p_plan_id, p_release_id);
3028: if l_return_status = fnd_api.g_ret_sts_success then
3029: populate_deliveries(l_return_status, p_release_id);
3030: if l_return_status = fnd_api.g_ret_sts_success then
3031: populate_interface_tables(l_return_status, p_release_id);
3032: if l_return_status = fnd_api.g_ret_sts_success then

Line 3030: if l_return_status = fnd_api.g_ret_sts_success then

3026: if l_return_status = fnd_api.g_ret_sts_success then
3027: reset_grp_ids_in_sequence_of_1(l_return_status, l_group_tab, p_plan_id, p_release_id);
3028: if l_return_status = fnd_api.g_ret_sts_success then
3029: populate_deliveries(l_return_status, p_release_id);
3030: if l_return_status = fnd_api.g_ret_sts_success then
3031: populate_interface_tables(l_return_status, p_release_id);
3032: if l_return_status = fnd_api.g_ret_sts_success then
3033: if g_apply_to_te = 1 then
3034: print_info(g_log_flow_of_control,'g_apply_to_te : ' ||g_apply_to_te);

Line 3032: if l_return_status = fnd_api.g_ret_sts_success then

3028: if l_return_status = fnd_api.g_ret_sts_success then
3029: populate_deliveries(l_return_status, p_release_id);
3030: if l_return_status = fnd_api.g_ret_sts_success then
3031: populate_interface_tables(l_return_status, p_release_id);
3032: if l_return_status = fnd_api.g_ret_sts_success then
3033: if g_apply_to_te = 1 then
3034: print_info(g_log_flow_of_control,'g_apply_to_te : ' ||g_apply_to_te);
3035: l_input_rec.ACTION_CODE := wsh_tp_release_grp.G_ACTION_RELEASE;
3036: l_input_rec.COMMIT_FLAG := fnd_api.G_FALSE;

Line 3036: l_input_rec.COMMIT_FLAG := fnd_api.G_FALSE;

3032: if l_return_status = fnd_api.g_ret_sts_success then
3033: if g_apply_to_te = 1 then
3034: print_info(g_log_flow_of_control,'g_apply_to_te : ' ||g_apply_to_te);
3035: l_input_rec.ACTION_CODE := wsh_tp_release_grp.G_ACTION_RELEASE;
3036: l_input_rec.COMMIT_FLAG := fnd_api.G_FALSE;
3037:
3038: wsh_tp_release_grp.action( l_group_tab -- list of group ids created in release process above
3039: , l_input_rec
3040: , l_output_rec

Line 3042: -- l_return_status -> fnd_api.g_ret_sts_success ---> all group released to TE

3038: wsh_tp_release_grp.action( l_group_tab -- list of group ids created in release process above
3039: , l_input_rec
3040: , l_output_rec
3041: , l_return_status);
3042: -- l_return_status -> fnd_api.g_ret_sts_success ---> all group released to TE
3043: -- l_return_status -> WSH_UTIL_CORE.G_RET_STS_WARNING ---> at least one group failed and at least one successful
3044: -- l_return_status -> fnd_api.g_ret_sts_error ---> all groups failed
3045: -- l_return_status -> fnd_api.g_ret_sts_unexp_error ---> unexpected error occured in TE
3046: end if;

Line 3044: -- l_return_status -> fnd_api.g_ret_sts_error ---> all groups failed

3040: , l_output_rec
3041: , l_return_status);
3042: -- l_return_status -> fnd_api.g_ret_sts_success ---> all group released to TE
3043: -- l_return_status -> WSH_UTIL_CORE.G_RET_STS_WARNING ---> at least one group failed and at least one successful
3044: -- l_return_status -> fnd_api.g_ret_sts_error ---> all groups failed
3045: -- l_return_status -> fnd_api.g_ret_sts_unexp_error ---> unexpected error occured in TE
3046: end if;
3047: if l_return_status = fnd_api.g_ret_sts_unexp_error then
3048: rollback;

Line 3045: -- l_return_status -> fnd_api.g_ret_sts_unexp_error ---> unexpected error occured in TE

3041: , l_return_status);
3042: -- l_return_status -> fnd_api.g_ret_sts_success ---> all group released to TE
3043: -- l_return_status -> WSH_UTIL_CORE.G_RET_STS_WARNING ---> at least one group failed and at least one successful
3044: -- l_return_status -> fnd_api.g_ret_sts_error ---> all groups failed
3045: -- l_return_status -> fnd_api.g_ret_sts_unexp_error ---> unexpected error occured in TE
3046: end if;
3047: if l_return_status = fnd_api.g_ret_sts_unexp_error then
3048: rollback;
3049: else

Line 3047: if l_return_status = fnd_api.g_ret_sts_unexp_error then

3043: -- l_return_status -> WSH_UTIL_CORE.G_RET_STS_WARNING ---> at least one group failed and at least one successful
3044: -- l_return_status -> fnd_api.g_ret_sts_error ---> all groups failed
3045: -- l_return_status -> fnd_api.g_ret_sts_unexp_error ---> unexpected error occured in TE
3046: end if;
3047: if l_return_status = fnd_api.g_ret_sts_unexp_error then
3048: rollback;
3049: else
3050: if g_update_tp_tables = 1 then
3051: print_info(g_log_flow_of_control,'g_update_tp_tables : ' ||g_update_tp_tables);

Line 3053: if l_return_status <> fnd_api.g_ret_sts_success then

3049: else
3050: if g_update_tp_tables = 1 then
3051: print_info(g_log_flow_of_control,'g_update_tp_tables : ' ||g_update_tp_tables);
3052: update_tp_tables (l_return_status, l_group_tab, p_plan_id, p_release_id, p_release_mode, l_release_start_date);
3053: if l_return_status <> fnd_api.g_ret_sts_success then
3054: rollback;
3055: end if;
3056: end if;
3057: print_info(g_log_flow_of_control,'g_purge_interface_table : ' ||g_purge_interface_table);

Line 3060: l_input_rec.COMMIT_FLAG := fnd_api.G_FALSE;

3056: end if;
3057: print_info(g_log_flow_of_control,'g_purge_interface_table : ' ||g_purge_interface_table);
3058: if g_purge_interface_table = 1 then
3059: l_input_rec.ACTION_CODE := wsh_tp_release_grp.G_ACTION_PURGE;
3060: l_input_rec.COMMIT_FLAG := fnd_api.G_FALSE;
3061:
3062: wsh_tp_release_grp.action( l_group_tab -- list of group ids created in release process above
3063: , l_input_rec
3064: , l_output_rec

Line 3287: if l_return_status = fnd_api.g_ret_sts_success then

3283: set_release_debug_flags;
3284: print_info(g_log_flow_of_control,'release_load : Release Id = ' ||p_release_id|| ' Program started');
3285: g_release_data := 'TRIP';
3286: pull_into_global_temp_table (l_return_status, p_release_id);
3287: if l_return_status = fnd_api.g_ret_sts_success then
3288: do_release (p_plan_id, p_release_id, p_release_mode);
3289: end if;
3290:
3291: print_info(g_log_flow_of_control,'release_load : Release Id = ' ||p_release_id|| ' Program ended');

Line 3454: x_return_status := fnd_api.g_ret_sts_error;

3450: l_where_clause := substr(l_where_clause,1,length(l_where_clause)-3);
3451: if l_where_clause is null or l_where_clause = ' ( 1 = 1 ) ' then
3452: --print_info(g_log_must_message,'Rule set / rule / rule condition not defined to auto-release this plan. No trip eligible for release.');
3453: print_info(g_log_must_message,get_seeded_message('MST_REL_BK_MESSAGE_39'));
3454: x_return_status := fnd_api.g_ret_sts_error;
3455: log_statistics;
3456: --set_concurrent_status('WARNING', 'Zero Groups attempted to release.');
3457: set_concurrent_status('WARNING', get_seeded_message('MST_REL_BK_MESSAGE_39'));
3458: else

Line 3525: x_return_status := fnd_api.g_ret_sts_success;

3521: and mt.plan_id = mp.plan_id
3522: and mt.vehicle_type_id = fvt.vehicle_type_id (+) and ( '||l_where_clause||' ))';
3523:
3524: g_where_clause := l_where_clause; -- to use in procedure remove_grp_of_unwanted_trip to eliminate groups of disqualified trips
3525: x_return_status := fnd_api.g_ret_sts_success;
3526: end if;
3527: print_info(g_log_flow_of_control,'insert_plan_trips_ruleset : Program ended');
3528: exception
3529: when others then

Line 3530: x_return_status := fnd_api.g_ret_sts_unexp_error;

3526: end if;
3527: print_info(g_log_flow_of_control,'insert_plan_trips_ruleset : Program ended');
3528: exception
3529: when others then
3530: x_return_status := fnd_api.g_ret_sts_unexp_error;
3531: print_info(g_log_flow_of_control,'insert_plan_trips_ruleset : ' || to_char(sqlcode) || ':' || SQLERRM);
3532: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
3533: end insert_plan_trips_ruleset;
3534:

Line 3600: x_return_status := fnd_api.g_ret_sts_success;

3596: and mt.plan_id = mp.plan_id
3597: and mt.vehicle_type_id = fvt.vehicle_type_id (+)
3598: );
3599:
3600: x_return_status := fnd_api.g_ret_sts_success;
3601: print_info(g_log_flow_of_control,'insert_plan_trips : Program ended');
3602: exception
3603: when others then
3604: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3604: x_return_status := fnd_api.g_ret_sts_unexp_error;

3600: x_return_status := fnd_api.g_ret_sts_success;
3601: print_info(g_log_flow_of_control,'insert_plan_trips : Program ended');
3602: exception
3603: when others then
3604: x_return_status := fnd_api.g_ret_sts_unexp_error;
3605: print_info(g_log_flow_of_control,'insert_plan_trips : ' || to_char(sqlcode) || ':' || SQLERRM);
3606: set_concurrent_status('ERROR',get_seeded_message('MST_REL_BK_MESSAGE_47') || to_char(sqlcode) || ':' || SQLERRM);
3607: end insert_plan_trips;
3608:

Line 3821: if l_return_status = fnd_api.g_ret_sts_success then

3817: print_info(g_log_must_message,'Simulated Auto-Release with Ruleset: Manual-release with ruleset mode will be run. This is not for customer.');
3818: g_release_data := 'TRIP';
3819: g_auto_release := 3;
3820: insert_plan_trips_ruleset(l_return_status, p_plan_id, p_release_id);
3821: if l_return_status = fnd_api.g_ret_sts_success then
3822: do_release (p_plan_id, p_release_id, 1);
3823: end if;
3824: elsif g_house_keeping = 3 then -- Manual-release as auto-release will be run. This is not for customer.
3825: print_info(g_log_must_message,'Simulated Auto-Release of Entire Plan: Manual-release as auto-release will be run. This is not for customer.');

Line 3828: if l_return_status = fnd_api.g_ret_sts_success then

3824: elsif g_house_keeping = 3 then -- Manual-release as auto-release will be run. This is not for customer.
3825: print_info(g_log_must_message,'Simulated Auto-Release of Entire Plan: Manual-release as auto-release will be run. This is not for customer.');
3826: g_release_data := 'PLAN';
3827: insert_plan_trips (l_return_status, p_plan_id, p_release_id);
3828: if l_return_status = fnd_api.g_ret_sts_success then
3829: do_release (p_plan_id, p_release_id, 1);
3830: end if;
3831: else
3832: print_info(g_log_flow_of_control,'release_plan : Release Id = ' ||p_release_id|| ' Program started');

Line 3837: if l_return_status = fnd_api.g_ret_sts_success then

3833:
3834: if nvl(p_release_mode,2) = 2 then -- called from ui (manual release entire plan)
3835: g_release_data := 'PLAN';
3836: insert_plan_trips (l_return_status, p_plan_id, p_release_id);
3837: if l_return_status = fnd_api.g_ret_sts_success then
3838: do_release (p_plan_id, p_release_id, p_release_mode);
3839: end if;
3840: elsif p_release_mode = 3 then -- called from ui (manual release entire plan with ruleset)
3841: g_release_data := 'TRIP'; -- added this portion of elsif due to bug 3570370

Line 3844: if l_return_status = fnd_api.g_ret_sts_success then

3840: elsif p_release_mode = 3 then -- called from ui (manual release entire plan with ruleset)
3841: g_release_data := 'TRIP'; -- added this portion of elsif due to bug 3570370
3842: g_auto_release := 3;
3843: insert_plan_trips_ruleset(l_return_status, p_plan_id, p_release_id);
3844: if l_return_status = fnd_api.g_ret_sts_success then
3845: do_release (p_plan_id, p_release_id, 1); -- making release mode (third parameter) to 1 to simulate auto-release
3846: end if;
3847: elsif p_release_mode = 1 then -- called from engine for auto release
3848:

Line 3858: if l_return_status = fnd_api.g_ret_sts_success then

3854: null;
3855: elsif l_auto_release = 2 then -- release entire plan as per planned-flag in tables
3856: g_release_data := 'PLAN';
3857: insert_plan_trips (l_return_status, p_plan_id, p_release_id);
3858: if l_return_status = fnd_api.g_ret_sts_success then
3859: do_release (p_plan_id, p_release_id, p_release_mode);
3860: end if;
3861: elsif l_auto_release = 3 then -- release plan as per the rule set defined in plan option
3862: g_auto_release := 3;

Line 3865: if l_return_status = fnd_api.g_ret_sts_success then

3861: elsif l_auto_release = 3 then -- release plan as per the rule set defined in plan option
3862: g_auto_release := 3;
3863: g_release_data := 'TRIP';
3864: insert_plan_trips_ruleset(l_return_status, p_plan_id, p_release_id);
3865: if l_return_status = fnd_api.g_ret_sts_success then
3866: do_release (p_plan_id, p_release_id, p_release_mode);
3867: end if;
3868: end if;
3869: end if;