DBA Data[Home] [Help]

APPS.FTE_TP_GRP dependencies on WSH_TP_RELEASE_INT

Line 647: x_context IN OUT NOCOPY WSH_TP_RELEASE_INT.context_rec_type,

643: -- x_obsoleted_trip_moves will have the obsoleted move segments.
644: --
645:
646: PROCEDURE map_moves(
647: x_context IN OUT NOCOPY WSH_TP_RELEASE_INT.context_rec_type,
648: x_plan_trips IN OUT NOCOPY WSH_TP_RELEASE_INT.plan_trip_tab_type,
649: x_plan_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_trip_move_tab_type,
650: x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,
651: x_obsoleted_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.obsoleted_trip_move_tab_type,

Line 648: x_plan_trips IN OUT NOCOPY WSH_TP_RELEASE_INT.plan_trip_tab_type,

644: --
645:
646: PROCEDURE map_moves(
647: x_context IN OUT NOCOPY WSH_TP_RELEASE_INT.context_rec_type,
648: x_plan_trips IN OUT NOCOPY WSH_TP_RELEASE_INT.plan_trip_tab_type,
649: x_plan_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_trip_move_tab_type,
650: x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,
651: x_obsoleted_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.obsoleted_trip_move_tab_type,
652: x_errors_tab IN OUT NOCOPY WSH_TP_RELEASE_INT.interface_errors_tab_type,

Line 652: x_errors_tab IN OUT NOCOPY WSH_TP_RELEASE_INT.interface_errors_tab_type,

648: x_plan_trips IN OUT NOCOPY WSH_TP_RELEASE_INT.plan_trip_tab_type,
649: x_plan_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_trip_move_tab_type,
650: x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,
651: x_obsoleted_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.obsoleted_trip_move_tab_type,
652: x_errors_tab IN OUT NOCOPY WSH_TP_RELEASE_INT.interface_errors_tab_type,
653: x_return_status OUT NOCOPY VARCHAR2
654: )
655: IS
656: --

Line 788: WSH_TP_RELEASE_INT.stamp_interface_error(

784: x_plan_moves(l_new_index).move_id := NULL;
785: ELSIF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
786: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
787: -- move or one of its trip_moves cannot be locked or some other error happened.
788: WSH_TP_RELEASE_INT.stamp_interface_error(
789: p_group_id => x_context.group_id,
790: p_entity_table_name => 'FTE_MOVES_INTERFACE',
791: p_entity_interface_id => imove.move_interface_id,
792: p_message_name => 'WSH_TP_F_NO_LOCK_MOVE',

Line 845: WSH_TP_RELEASE_INT.stamp_interface_error(

841: l_trip_index := x_plan_trips.NEXT(l_trip_index);
842: END LOOP;
843:
844: IF l_trip_index IS NULL THEN
845: WSH_TP_RELEASE_INT.stamp_interface_error(
846: p_group_id => x_context.group_id,
847: p_entity_table_name => 'FTE_TRIP_MOVES_INTERFACE',
848: p_entity_interface_id => itripmove.trip_move_interface_id,
849: p_message_name => 'WSH_TP_F_TRIP_NOT_MAPPED',

Line 944: WSH_TP_RELEASE_INT.stamp_interface_error(

940:
941: -- is this move currently firmed (so it should have all trip_moves mapped)?
942: IF x_plan_moves(l_new_index).fte_planned_flag <> 'N' THEN
943: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
944: WSH_TP_RELEASE_INT.stamp_interface_error(
945: p_group_id => x_context.group_id,
946: p_entity_table_name => 'FTE_MOVES_INTERFACE',
947: p_entity_interface_id => x_plan_moves(l_new_index).move_interface_id,
948: p_message_name => 'WSH_TP_F_FIRM_MOVE_DIFF',

Line 998: WSH_TP_RELEASE_INT.stamp_interface_error(

994:
995: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
996: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
997: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
998: WSH_TP_RELEASE_INT.stamp_interface_error(
999: p_group_id => x_context.group_id,
1000: p_entity_table_name => 'WSH_TRIPS_INTERFACE',
1001: p_entity_interface_id => x_plan_trips(l_trip_index).trip_interface_id,
1002: p_message_name => 'WSH_TP_F_MOVE_LOOKUP',

Line 1062: WSH_TP_RELEASE_INT.stamp_interface_error(

1058: IF (l_locked = 'Y')
1059: OR (l_return_status IN
1060: (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1061: -- move or one of its trip_moves cannot be locked or some other error happened.
1062: WSH_TP_RELEASE_INT.stamp_interface_error(
1063: p_group_id => x_context.group_id,
1064: p_entity_table_name => 'WSH_TRIPS_INTERFACE',
1065: p_entity_interface_id => x_plan_trips(l_trip_index).trip_interface_id,
1066: p_message_name => 'WSH_TP_F_NO_LOCK_OBS_MOVE',

Line 1081: WSH_TP_RELEASE_INT.stamp_interface_error(

1077:
1078: -- we should not obsolete a firmed move.
1079: IF NVL(l_move_rec.planned_flag, 'N') <> 'N' THEN
1080: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1081: WSH_TP_RELEASE_INT.stamp_interface_error(
1082: p_group_id => x_context.group_id,
1083: p_entity_table_name => 'WSH_TRIPS_INTERFACE',
1084: p_entity_interface_id => x_plan_trips(l_trip_index).trip_interface_id,
1085: p_message_name => 'WSH_TP_F_FIRM_MOVE_NO_MATCH',

Line 1178: x_context IN OUT NOCOPY WSH_TP_RELEASE_INT.context_rec_type,

1174: -- Create or update continous moves and their segments, delete obsoleted segments.
1175: --
1176:
1177: PROCEDURE reconciliate_moves(
1178: x_context IN OUT NOCOPY WSH_TP_RELEASE_INT.context_rec_type,
1179: x_plan_trips IN OUT NOCOPY WSH_TP_RELEASE_INT.plan_trip_tab_type,
1180: x_plan_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_trip_move_tab_type,
1181: x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,
1182: x_obsoleted_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.obsoleted_trip_move_tab_type,

Line 1179: x_plan_trips IN OUT NOCOPY WSH_TP_RELEASE_INT.plan_trip_tab_type,

1175: --
1176:
1177: PROCEDURE reconciliate_moves(
1178: x_context IN OUT NOCOPY WSH_TP_RELEASE_INT.context_rec_type,
1179: x_plan_trips IN OUT NOCOPY WSH_TP_RELEASE_INT.plan_trip_tab_type,
1180: x_plan_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_trip_move_tab_type,
1181: x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,
1182: x_obsoleted_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.obsoleted_trip_move_tab_type,
1183: x_errors_tab IN OUT NOCOPY WSH_TP_RELEASE_INT.interface_errors_tab_type,

Line 1183: x_errors_tab IN OUT NOCOPY WSH_TP_RELEASE_INT.interface_errors_tab_type,

1179: x_plan_trips IN OUT NOCOPY WSH_TP_RELEASE_INT.plan_trip_tab_type,
1180: x_plan_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_trip_move_tab_type,
1181: x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,
1182: x_obsoleted_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.obsoleted_trip_move_tab_type,
1183: x_errors_tab IN OUT NOCOPY WSH_TP_RELEASE_INT.interface_errors_tab_type,
1184: x_return_status OUT NOCOPY VARCHAR2
1185: )
1186: IS
1187: --

Line 1241: WSH_TP_RELEASE_INT.stamp_interface_error(

1237: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1238: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1239:
1240: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1241: WSH_TP_RELEASE_INT.stamp_interface_error(
1242: p_group_id => x_context.group_id,
1243: p_entity_table_name => 'NONE',
1244: p_entity_interface_id => -1,
1245: p_message_name => 'WSH_TP_F_DELETE_OBS_MOVE',

Line 1266: WSH_TP_RELEASE_INT.stamp_interface_error(

1262: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
1263: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1264:
1265: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1266: WSH_TP_RELEASE_INT.stamp_interface_error(
1267: p_group_id => x_context.group_id,
1268: p_entity_table_name => 'NONE',
1269: p_entity_interface_id => -1,
1270: p_message_name => 'WSH_TP_F_DELETE_OBS_MOVE',

Line 1310: WSH_TP_RELEASE_INT.stamp_interface_error(

1306: x_move_id => l_id,
1307: x_return_status => l_return_status);
1308: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1309: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1310: WSH_TP_RELEASE_INT.stamp_interface_error(
1311: p_group_id => x_context.group_id,
1312: p_entity_table_name => 'FTE_MOVES_INTERFACE',
1313: p_entity_interface_id => x_plan_moves(l_m_index).move_interface_id,
1314: p_message_name => 'WSH_TP_F_CREATE_MOVE',

Line 1329: WSH_TP_RELEASE_INT.stamp_interface_error(

1325: p_move_info => l_move_rec,
1326: x_return_status => l_return_status);
1327: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1328: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1329: WSH_TP_RELEASE_INT.stamp_interface_error(
1330: p_group_id => x_context.group_id,
1331: p_entity_table_name => 'FTE_MOVES_INTERFACE',
1332: p_entity_interface_id => x_plan_moves(l_m_index).move_interface_id,
1333: p_message_name => 'WSH_TP_F_UPDATE_MOVE',

Line 1360: WSH_TP_RELEASE_INT.stamp_interface_error(

1356: x_trip_move_id => l_id,
1357: x_return_status => l_return_status);
1358: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1359: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1360: WSH_TP_RELEASE_INT.stamp_interface_error(
1361: p_group_id => x_context.group_id,
1362: p_entity_table_name => 'FTE_TRIP_MOVES_INTERFACE',
1363: p_entity_interface_id => x_plan_trip_moves(l_tm_index).trip_move_interface_id,
1364: p_message_name => 'WSH_TP_F_CREATE_TRIP_MOVE',

Line 1379: WSH_TP_RELEASE_INT.stamp_interface_error(

1375: p_trip_moves_info => l_trip_move_rec,
1376: x_return_status => l_return_status);
1377: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1378: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1379: WSH_TP_RELEASE_INT.stamp_interface_error(
1380: p_group_id => x_context.group_id,
1381: p_entity_table_name => 'FTE_TRIP_MOVES_INTERFACE',
1382: p_entity_interface_id => x_plan_trip_moves(l_tm_index).trip_move_interface_id,
1383: p_message_name => 'WSH_TP_F_UPDATE_TRIP_MOVE',

Line 1446: x_context IN OUT NOCOPY WSH_TP_RELEASE_INT.context_rec_type,

1442: -- Upgrade continuous moves' PLANNED_FLAG based on the plan
1443: --
1444:
1445: PROCEDURE tp_firm_moves(
1446: x_context IN OUT NOCOPY WSH_TP_RELEASE_INT.context_rec_type,
1447: x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,
1448: x_errors_tab IN OUT NOCOPY WSH_TP_RELEASE_INT.interface_errors_tab_type,
1449: x_return_status OUT NOCOPY VARCHAR2
1450: )

Line 1448: x_errors_tab IN OUT NOCOPY WSH_TP_RELEASE_INT.interface_errors_tab_type,

1444:
1445: PROCEDURE tp_firm_moves(
1446: x_context IN OUT NOCOPY WSH_TP_RELEASE_INT.context_rec_type,
1447: x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,
1448: x_errors_tab IN OUT NOCOPY WSH_TP_RELEASE_INT.interface_errors_tab_type,
1449: x_return_status OUT NOCOPY VARCHAR2
1450: )
1451: IS
1452: --

Line 1501: WSH_TP_RELEASE_INT.stamp_interface_error(

1497: p_move_info => l_move_rec,
1498: x_return_status => l_return_status);
1499: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1501: WSH_TP_RELEASE_INT.stamp_interface_error(
1502: p_group_id => x_context.group_id,
1503: p_entity_table_name => 'FTE_MOVES_INTERFACE',
1504: p_entity_interface_id => x_plan_moves(l_m_index).move_interface_id,
1505: p_message_name => 'WSH_TP_F_FIRM_MOVE',