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

Line 325: -- p_commit_flag FND_API.G_TRUE - commit changes; FND_API.G_FALSE - do not commit

321: -- Parameters:
322: -- p_group_ids list of group_ids to process their
323: -- WSH_TRIPS_INTERFACE records and
324: -- their associated tables' records.
325: -- p_commit_flag FND_API.G_TRUE - commit changes; FND_API.G_FALSE - do not commit
326: -- x_return_status return status
327: -- success means all groups have been released.
328: -- warning means at least one group is released and at least one
329: -- group failed.

Line 601: IF p_commit_flag = FND_API.G_TRUE THEN

597: WSH_DEBUG_SV.log(l_module_name,'finished group_id', p_group_ids(l_index));
598: END IF;
599:
600: l_savepoint_set := FALSE;
601: IF p_commit_flag = FND_API.G_TRUE THEN
602: COMMIT;
603: END IF;
604:
605: -- before we go on to the next group, clear the errors.

Line 657: -- p_commit_flag FND_API.G_TRUE - commit changes; FND_API.G_FALSE - do not commit

653: -- p_group_ids list of group_ids to purge their
654: -- WSH_TRIPS_INTERFACE records and
655: -- their associated tables' records.
656: -- WSH_INTERFACE_ERRORS will be purged.
657: -- p_commit_flag FND_API.G_TRUE - commit changes; FND_API.G_FALSE - do not commit
658: -- x_return_status return status
659: --
660: -- Description:
661: -- Delete the records from WSH and FTE interface tables.

Line 804: IF p_commit_flag = FND_API.G_TRUE THEN

800: where wie.interface_error_group_id = p_group_ids(i)
801: and wie.interface_action_code = G_TP_RELEASE_CODE;
802:
803:
804: IF p_commit_flag = FND_API.G_TRUE THEN
805: commit;
806: END IF;
807:
808:

Line 3467: (NVL(itrip.wsh_carrier_id, FND_API.G_MISS_NUM)

3463: x_plan_trips(l_new_index).wsh_planned_flag := NULL;
3464: ELSIF itrip.wsh_planned_flag = 'N'
3465: AND (itrip.wsh_lane_id IS NOT NULL)
3466: AND (
3467: (NVL(itrip.wsh_carrier_id, FND_API.G_MISS_NUM)
3468: <> NVL(itrip.carrier_id, FND_API.G_MISS_NUM))
3469: OR
3470: (NVL(itrip.wsh_mode_of_transport, FND_API.G_MISS_CHAR)
3471: <> NVL(itrip.mode_of_transport, FND_API.G_MISS_CHAR))

Line 3468: <> NVL(itrip.carrier_id, FND_API.G_MISS_NUM))

3464: ELSIF itrip.wsh_planned_flag = 'N'
3465: AND (itrip.wsh_lane_id IS NOT NULL)
3466: AND (
3467: (NVL(itrip.wsh_carrier_id, FND_API.G_MISS_NUM)
3468: <> NVL(itrip.carrier_id, FND_API.G_MISS_NUM))
3469: OR
3470: (NVL(itrip.wsh_mode_of_transport, FND_API.G_MISS_CHAR)
3471: <> NVL(itrip.mode_of_transport, FND_API.G_MISS_CHAR))
3472: OR

Line 3470: (NVL(itrip.wsh_mode_of_transport, FND_API.G_MISS_CHAR)

3466: AND (
3467: (NVL(itrip.wsh_carrier_id, FND_API.G_MISS_NUM)
3468: <> NVL(itrip.carrier_id, FND_API.G_MISS_NUM))
3469: OR
3470: (NVL(itrip.wsh_mode_of_transport, FND_API.G_MISS_CHAR)
3471: <> NVL(itrip.mode_of_transport, FND_API.G_MISS_CHAR))
3472: OR
3473: (NVL(itrip.wsh_service_level, FND_API.G_MISS_CHAR)
3474: <> NVL(itrip.service_level, FND_API.G_MISS_CHAR))

Line 3471: <> NVL(itrip.mode_of_transport, FND_API.G_MISS_CHAR))

3467: (NVL(itrip.wsh_carrier_id, FND_API.G_MISS_NUM)
3468: <> NVL(itrip.carrier_id, FND_API.G_MISS_NUM))
3469: OR
3470: (NVL(itrip.wsh_mode_of_transport, FND_API.G_MISS_CHAR)
3471: <> NVL(itrip.mode_of_transport, FND_API.G_MISS_CHAR))
3472: OR
3473: (NVL(itrip.wsh_service_level, FND_API.G_MISS_CHAR)
3474: <> NVL(itrip.service_level, FND_API.G_MISS_CHAR))
3475: OR

Line 3473: (NVL(itrip.wsh_service_level, FND_API.G_MISS_CHAR)

3469: OR
3470: (NVL(itrip.wsh_mode_of_transport, FND_API.G_MISS_CHAR)
3471: <> NVL(itrip.mode_of_transport, FND_API.G_MISS_CHAR))
3472: OR
3473: (NVL(itrip.wsh_service_level, FND_API.G_MISS_CHAR)
3474: <> NVL(itrip.service_level, FND_API.G_MISS_CHAR))
3475: OR
3476: (itrip.wsh_lane_id <> NVL(itrip.lane_id, FND_API.G_MISS_NUM))
3477: ) THEN

Line 3474: <> NVL(itrip.service_level, FND_API.G_MISS_CHAR))

3470: (NVL(itrip.wsh_mode_of_transport, FND_API.G_MISS_CHAR)
3471: <> NVL(itrip.mode_of_transport, FND_API.G_MISS_CHAR))
3472: OR
3473: (NVL(itrip.wsh_service_level, FND_API.G_MISS_CHAR)
3474: <> NVL(itrip.service_level, FND_API.G_MISS_CHAR))
3475: OR
3476: (itrip.wsh_lane_id <> NVL(itrip.lane_id, FND_API.G_MISS_NUM))
3477: ) THEN
3478: -- bug 3295628: FTE does not allow existing trip's ship method components

Line 3476: (itrip.wsh_lane_id <> NVL(itrip.lane_id, FND_API.G_MISS_NUM))

3472: OR
3473: (NVL(itrip.wsh_service_level, FND_API.G_MISS_CHAR)
3474: <> NVL(itrip.service_level, FND_API.G_MISS_CHAR))
3475: OR
3476: (itrip.wsh_lane_id <> NVL(itrip.lane_id, FND_API.G_MISS_NUM))
3477: ) THEN
3478: -- bug 3295628: FTE does not allow existing trip's ship method components
3479: -- to be changed if the trip has a lane.
3480: -- In this case, we should create a new trip

Line 3495: (NVL(itrip.wsh_carrier_id, FND_API.G_MISS_NUM)

3491: -- Bug 3507047: Allow the lane_id to be updated on a firmed trip
3492: -- without failing the plan.
3493: IF itrip.wsh_planned_flag IN ('Y', 'F')
3494: AND (
3495: (NVL(itrip.wsh_carrier_id, FND_API.G_MISS_NUM)
3496: <> NVL(itrip.carrier_id, FND_API.G_MISS_NUM))
3497: OR
3498: (NVL(itrip.wsh_mode_of_transport, FND_API.G_MISS_CHAR)
3499: <> NVL(itrip.mode_of_transport, FND_API.G_MISS_CHAR))

Line 3496: <> NVL(itrip.carrier_id, FND_API.G_MISS_NUM))

3492: -- without failing the plan.
3493: IF itrip.wsh_planned_flag IN ('Y', 'F')
3494: AND (
3495: (NVL(itrip.wsh_carrier_id, FND_API.G_MISS_NUM)
3496: <> NVL(itrip.carrier_id, FND_API.G_MISS_NUM))
3497: OR
3498: (NVL(itrip.wsh_mode_of_transport, FND_API.G_MISS_CHAR)
3499: <> NVL(itrip.mode_of_transport, FND_API.G_MISS_CHAR))
3500: OR

Line 3498: (NVL(itrip.wsh_mode_of_transport, FND_API.G_MISS_CHAR)

3494: AND (
3495: (NVL(itrip.wsh_carrier_id, FND_API.G_MISS_NUM)
3496: <> NVL(itrip.carrier_id, FND_API.G_MISS_NUM))
3497: OR
3498: (NVL(itrip.wsh_mode_of_transport, FND_API.G_MISS_CHAR)
3499: <> NVL(itrip.mode_of_transport, FND_API.G_MISS_CHAR))
3500: OR
3501: (NVL(itrip.wsh_service_level, FND_API.G_MISS_CHAR)
3502: <> NVL(itrip.service_level, FND_API.G_MISS_CHAR))

Line 3499: <> NVL(itrip.mode_of_transport, FND_API.G_MISS_CHAR))

3495: (NVL(itrip.wsh_carrier_id, FND_API.G_MISS_NUM)
3496: <> NVL(itrip.carrier_id, FND_API.G_MISS_NUM))
3497: OR
3498: (NVL(itrip.wsh_mode_of_transport, FND_API.G_MISS_CHAR)
3499: <> NVL(itrip.mode_of_transport, FND_API.G_MISS_CHAR))
3500: OR
3501: (NVL(itrip.wsh_service_level, FND_API.G_MISS_CHAR)
3502: <> NVL(itrip.service_level, FND_API.G_MISS_CHAR))
3503: OR

Line 3501: (NVL(itrip.wsh_service_level, FND_API.G_MISS_CHAR)

3497: OR
3498: (NVL(itrip.wsh_mode_of_transport, FND_API.G_MISS_CHAR)
3499: <> NVL(itrip.mode_of_transport, FND_API.G_MISS_CHAR))
3500: OR
3501: (NVL(itrip.wsh_service_level, FND_API.G_MISS_CHAR)
3502: <> NVL(itrip.service_level, FND_API.G_MISS_CHAR))
3503: OR
3504: (NVL(itrip.wsh_vehicle_org_id, FND_API.G_MISS_NUM)
3505: <> NVL(itrip.vehicle_organization_id, FND_API.G_MISS_NUM))

Line 3502: <> NVL(itrip.service_level, FND_API.G_MISS_CHAR))

3498: (NVL(itrip.wsh_mode_of_transport, FND_API.G_MISS_CHAR)
3499: <> NVL(itrip.mode_of_transport, FND_API.G_MISS_CHAR))
3500: OR
3501: (NVL(itrip.wsh_service_level, FND_API.G_MISS_CHAR)
3502: <> NVL(itrip.service_level, FND_API.G_MISS_CHAR))
3503: OR
3504: (NVL(itrip.wsh_vehicle_org_id, FND_API.G_MISS_NUM)
3505: <> NVL(itrip.vehicle_organization_id, FND_API.G_MISS_NUM))
3506: OR

Line 3504: (NVL(itrip.wsh_vehicle_org_id, FND_API.G_MISS_NUM)

3500: OR
3501: (NVL(itrip.wsh_service_level, FND_API.G_MISS_CHAR)
3502: <> NVL(itrip.service_level, FND_API.G_MISS_CHAR))
3503: OR
3504: (NVL(itrip.wsh_vehicle_org_id, FND_API.G_MISS_NUM)
3505: <> NVL(itrip.vehicle_organization_id, FND_API.G_MISS_NUM))
3506: OR
3507: (NVL(itrip.wsh_vehicle_item_id, FND_API.G_MISS_NUM)
3508: <> NVL(itrip.vehicle_item_id, FND_API.G_MISS_NUM))

Line 3505: <> NVL(itrip.vehicle_organization_id, FND_API.G_MISS_NUM))

3501: (NVL(itrip.wsh_service_level, FND_API.G_MISS_CHAR)
3502: <> NVL(itrip.service_level, FND_API.G_MISS_CHAR))
3503: OR
3504: (NVL(itrip.wsh_vehicle_org_id, FND_API.G_MISS_NUM)
3505: <> NVL(itrip.vehicle_organization_id, FND_API.G_MISS_NUM))
3506: OR
3507: (NVL(itrip.wsh_vehicle_item_id, FND_API.G_MISS_NUM)
3508: <> NVL(itrip.vehicle_item_id, FND_API.G_MISS_NUM))
3509: ) THEN

Line 3507: (NVL(itrip.wsh_vehicle_item_id, FND_API.G_MISS_NUM)

3503: OR
3504: (NVL(itrip.wsh_vehicle_org_id, FND_API.G_MISS_NUM)
3505: <> NVL(itrip.vehicle_organization_id, FND_API.G_MISS_NUM))
3506: OR
3507: (NVL(itrip.wsh_vehicle_item_id, FND_API.G_MISS_NUM)
3508: <> NVL(itrip.vehicle_item_id, FND_API.G_MISS_NUM))
3509: ) THEN
3510: stamp_interface_error(
3511: p_group_id => x_context.group_id,

Line 3508: <> NVL(itrip.vehicle_item_id, FND_API.G_MISS_NUM))

3504: (NVL(itrip.wsh_vehicle_org_id, FND_API.G_MISS_NUM)
3505: <> NVL(itrip.vehicle_organization_id, FND_API.G_MISS_NUM))
3506: OR
3507: (NVL(itrip.wsh_vehicle_item_id, FND_API.G_MISS_NUM)
3508: <> NVL(itrip.vehicle_item_id, FND_API.G_MISS_NUM))
3509: ) THEN
3510: stamp_interface_error(
3511: p_group_id => x_context.group_id,
3512: p_entity_table_name => 'WSH_TRIPS_INTERFACE',

Line 4015: (NVL(l_snapshot_lane_ids(l_used_index), FND_API.G_MISS_NUM)

4011: (l_snapshot_trip_plan_flags(l_used_index) = 'N')
4012: AND ( (l_snapshot_lane_ids(l_used_index) IS NULL)
4013: OR (
4014: -- if trip has lane, lane and ship method must match.
4015: (NVL(l_snapshot_lane_ids(l_used_index), FND_API.G_MISS_NUM)
4016: = NVL(x_plan_trips(l_trip_index).lane_id,
4017: FND_API.G_MISS_NUM))
4018: AND (NVL(l_snapshot_carrier_ids(l_used_index),
4019: FND_API.G_MISS_NUM)

Line 4017: FND_API.G_MISS_NUM))

4013: OR (
4014: -- if trip has lane, lane and ship method must match.
4015: (NVL(l_snapshot_lane_ids(l_used_index), FND_API.G_MISS_NUM)
4016: = NVL(x_plan_trips(l_trip_index).lane_id,
4017: FND_API.G_MISS_NUM))
4018: AND (NVL(l_snapshot_carrier_ids(l_used_index),
4019: FND_API.G_MISS_NUM)
4020: = NVL(x_plan_trips(l_trip_index).carrier_id,
4021: FND_API.G_MISS_NUM))

Line 4019: FND_API.G_MISS_NUM)

4015: (NVL(l_snapshot_lane_ids(l_used_index), FND_API.G_MISS_NUM)
4016: = NVL(x_plan_trips(l_trip_index).lane_id,
4017: FND_API.G_MISS_NUM))
4018: AND (NVL(l_snapshot_carrier_ids(l_used_index),
4019: FND_API.G_MISS_NUM)
4020: = NVL(x_plan_trips(l_trip_index).carrier_id,
4021: FND_API.G_MISS_NUM))
4022: AND (NVL(l_snapshot_modes(l_used_index),
4023: FND_API.G_MISS_CHAR)

Line 4021: FND_API.G_MISS_NUM))

4017: FND_API.G_MISS_NUM))
4018: AND (NVL(l_snapshot_carrier_ids(l_used_index),
4019: FND_API.G_MISS_NUM)
4020: = NVL(x_plan_trips(l_trip_index).carrier_id,
4021: FND_API.G_MISS_NUM))
4022: AND (NVL(l_snapshot_modes(l_used_index),
4023: FND_API.G_MISS_CHAR)
4024: = NVL(x_plan_trips(l_trip_index).mode_of_transport,
4025: FND_API.G_MISS_CHAR))

Line 4023: FND_API.G_MISS_CHAR)

4019: FND_API.G_MISS_NUM)
4020: = NVL(x_plan_trips(l_trip_index).carrier_id,
4021: FND_API.G_MISS_NUM))
4022: AND (NVL(l_snapshot_modes(l_used_index),
4023: FND_API.G_MISS_CHAR)
4024: = NVL(x_plan_trips(l_trip_index).mode_of_transport,
4025: FND_API.G_MISS_CHAR))
4026: AND (NVL(l_snapshot_service_levels(l_used_index),
4027: FND_API.G_MISS_CHAR)

Line 4025: FND_API.G_MISS_CHAR))

4021: FND_API.G_MISS_NUM))
4022: AND (NVL(l_snapshot_modes(l_used_index),
4023: FND_API.G_MISS_CHAR)
4024: = NVL(x_plan_trips(l_trip_index).mode_of_transport,
4025: FND_API.G_MISS_CHAR))
4026: AND (NVL(l_snapshot_service_levels(l_used_index),
4027: FND_API.G_MISS_CHAR)
4028: = NVL(x_plan_trips(l_trip_index).service_level,
4029: FND_API.G_MISS_CHAR))

Line 4027: FND_API.G_MISS_CHAR)

4023: FND_API.G_MISS_CHAR)
4024: = NVL(x_plan_trips(l_trip_index).mode_of_transport,
4025: FND_API.G_MISS_CHAR))
4026: AND (NVL(l_snapshot_service_levels(l_used_index),
4027: FND_API.G_MISS_CHAR)
4028: = NVL(x_plan_trips(l_trip_index).service_level,
4029: FND_API.G_MISS_CHAR))
4030: )
4031: )

Line 4029: FND_API.G_MISS_CHAR))

4025: FND_API.G_MISS_CHAR))
4026: AND (NVL(l_snapshot_service_levels(l_used_index),
4027: FND_API.G_MISS_CHAR)
4028: = NVL(x_plan_trips(l_trip_index).service_level,
4029: FND_API.G_MISS_CHAR))
4030: )
4031: )
4032: )
4033: OR (

Line 4036: FND_API.G_MISS_NUM)

4032: )
4033: OR (
4034: -- if trip is firmed, trip attributes must match the plan's attributes
4035: (NVL(l_snapshot_carrier_ids(l_used_index),
4036: FND_API.G_MISS_NUM)
4037: = NVL(x_plan_trips(l_trip_index).carrier_id,
4038: FND_API.G_MISS_NUM))
4039: AND (NVL(l_snapshot_modes(l_used_index),
4040: FND_API.G_MISS_CHAR)

Line 4038: FND_API.G_MISS_NUM))

4034: -- if trip is firmed, trip attributes must match the plan's attributes
4035: (NVL(l_snapshot_carrier_ids(l_used_index),
4036: FND_API.G_MISS_NUM)
4037: = NVL(x_plan_trips(l_trip_index).carrier_id,
4038: FND_API.G_MISS_NUM))
4039: AND (NVL(l_snapshot_modes(l_used_index),
4040: FND_API.G_MISS_CHAR)
4041: = NVL(x_plan_trips(l_trip_index).mode_of_transport,
4042: FND_API.G_MISS_CHAR))

Line 4040: FND_API.G_MISS_CHAR)

4036: FND_API.G_MISS_NUM)
4037: = NVL(x_plan_trips(l_trip_index).carrier_id,
4038: FND_API.G_MISS_NUM))
4039: AND (NVL(l_snapshot_modes(l_used_index),
4040: FND_API.G_MISS_CHAR)
4041: = NVL(x_plan_trips(l_trip_index).mode_of_transport,
4042: FND_API.G_MISS_CHAR))
4043: AND (NVL(l_snapshot_service_levels(l_used_index),
4044: FND_API.G_MISS_CHAR)

Line 4042: FND_API.G_MISS_CHAR))

4038: FND_API.G_MISS_NUM))
4039: AND (NVL(l_snapshot_modes(l_used_index),
4040: FND_API.G_MISS_CHAR)
4041: = NVL(x_plan_trips(l_trip_index).mode_of_transport,
4042: FND_API.G_MISS_CHAR))
4043: AND (NVL(l_snapshot_service_levels(l_used_index),
4044: FND_API.G_MISS_CHAR)
4045: = NVL(x_plan_trips(l_trip_index).service_level,
4046: FND_API.G_MISS_CHAR))

Line 4044: FND_API.G_MISS_CHAR)

4040: FND_API.G_MISS_CHAR)
4041: = NVL(x_plan_trips(l_trip_index).mode_of_transport,
4042: FND_API.G_MISS_CHAR))
4043: AND (NVL(l_snapshot_service_levels(l_used_index),
4044: FND_API.G_MISS_CHAR)
4045: = NVL(x_plan_trips(l_trip_index).service_level,
4046: FND_API.G_MISS_CHAR))
4047: AND (NVL(l_snapshot_veh_org_ids(l_used_index),
4048: FND_API.G_MISS_NUM)

Line 4046: FND_API.G_MISS_CHAR))

4042: FND_API.G_MISS_CHAR))
4043: AND (NVL(l_snapshot_service_levels(l_used_index),
4044: FND_API.G_MISS_CHAR)
4045: = NVL(x_plan_trips(l_trip_index).service_level,
4046: FND_API.G_MISS_CHAR))
4047: AND (NVL(l_snapshot_veh_org_ids(l_used_index),
4048: FND_API.G_MISS_NUM)
4049: = NVL(x_plan_trips(l_trip_index).vehicle_organization_id,
4050: FND_API.G_MISS_NUM))

Line 4048: FND_API.G_MISS_NUM)

4044: FND_API.G_MISS_CHAR)
4045: = NVL(x_plan_trips(l_trip_index).service_level,
4046: FND_API.G_MISS_CHAR))
4047: AND (NVL(l_snapshot_veh_org_ids(l_used_index),
4048: FND_API.G_MISS_NUM)
4049: = NVL(x_plan_trips(l_trip_index).vehicle_organization_id,
4050: FND_API.G_MISS_NUM))
4051: AND (NVL(l_snapshot_veh_item_ids(l_used_index),
4052: FND_API.G_MISS_NUM)

Line 4050: FND_API.G_MISS_NUM))

4046: FND_API.G_MISS_CHAR))
4047: AND (NVL(l_snapshot_veh_org_ids(l_used_index),
4048: FND_API.G_MISS_NUM)
4049: = NVL(x_plan_trips(l_trip_index).vehicle_organization_id,
4050: FND_API.G_MISS_NUM))
4051: AND (NVL(l_snapshot_veh_item_ids(l_used_index),
4052: FND_API.G_MISS_NUM)
4053: = NVL(x_plan_trips(l_trip_index).vehicle_item_id,
4054: FND_API.G_MISS_NUM))

Line 4052: FND_API.G_MISS_NUM)

4048: FND_API.G_MISS_NUM)
4049: = NVL(x_plan_trips(l_trip_index).vehicle_organization_id,
4050: FND_API.G_MISS_NUM))
4051: AND (NVL(l_snapshot_veh_item_ids(l_used_index),
4052: FND_API.G_MISS_NUM)
4053: = NVL(x_plan_trips(l_trip_index).vehicle_item_id,
4054: FND_API.G_MISS_NUM))
4055: AND (NVL(l_snapshot_lane_ids(l_used_index),
4056: FND_API.G_MISS_NUM)

Line 4054: FND_API.G_MISS_NUM))

4050: FND_API.G_MISS_NUM))
4051: AND (NVL(l_snapshot_veh_item_ids(l_used_index),
4052: FND_API.G_MISS_NUM)
4053: = NVL(x_plan_trips(l_trip_index).vehicle_item_id,
4054: FND_API.G_MISS_NUM))
4055: AND (NVL(l_snapshot_lane_ids(l_used_index),
4056: FND_API.G_MISS_NUM)
4057: = NVL(x_plan_trips(l_trip_index).lane_id,
4058: FND_API.G_MISS_NUM))

Line 4056: FND_API.G_MISS_NUM)

4052: FND_API.G_MISS_NUM)
4053: = NVL(x_plan_trips(l_trip_index).vehicle_item_id,
4054: FND_API.G_MISS_NUM))
4055: AND (NVL(l_snapshot_lane_ids(l_used_index),
4056: FND_API.G_MISS_NUM)
4057: = NVL(x_plan_trips(l_trip_index).lane_id,
4058: FND_API.G_MISS_NUM))
4059: )
4060: )

Line 4058: FND_API.G_MISS_NUM))

4054: FND_API.G_MISS_NUM))
4055: AND (NVL(l_snapshot_lane_ids(l_used_index),
4056: FND_API.G_MISS_NUM)
4057: = NVL(x_plan_trips(l_trip_index).lane_id,
4058: FND_API.G_MISS_NUM))
4059: )
4060: )
4061: THEN
4062: -- stop information match and we can map these plan records to existing trip/stops

Line 4894: p_init_msg_list => FND_API.G_TRUE,

4890: l_dd_action_prms.action_code := 'UNASSIGN';
4891:
4892: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(
4893: p_api_version_number => 1.0,
4894: p_init_msg_list => FND_API.G_TRUE,
4895: p_commit => FND_API.G_FALSE,
4896: x_return_status => l_return_status,
4897: x_msg_count => l_msg_count,
4898: x_msg_data => l_msg_data,

Line 4895: p_commit => FND_API.G_FALSE,

4891:
4892: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(
4893: p_api_version_number => 1.0,
4894: p_init_msg_list => FND_API.G_TRUE,
4895: p_commit => FND_API.G_FALSE,
4896: x_return_status => l_return_status,
4897: x_msg_count => l_msg_count,
4898: x_msg_data => l_msg_data,
4899: p_rec_attr_tab => l_dd_attrs,

Line 4979: p_init_msg_list => FND_API.G_TRUE,

4975:
4976:
4977: WSH_DELIVERIES_GRP.delivery_action(
4978: p_api_version_number => 1.0,
4979: p_init_msg_list => FND_API.G_TRUE,
4980: p_commit => FND_API.G_FALSE,
4981: p_action_prms => l_del_action_prms,
4982: p_rec_attr_tab => l_del_attrs,
4983: x_delivery_out_rec => l_del_action_rec,

Line 4980: p_commit => FND_API.G_FALSE,

4976:
4977: WSH_DELIVERIES_GRP.delivery_action(
4978: p_api_version_number => 1.0,
4979: p_init_msg_list => FND_API.G_TRUE,
4980: p_commit => FND_API.G_FALSE,
4981: p_action_prms => l_del_action_prms,
4982: p_rec_attr_tab => l_del_attrs,
4983: x_delivery_out_rec => l_del_action_rec,
4984: x_defaults_rec => l_del_defaults,

Line 5052: p_init_msg_list => FND_API.G_FALSE, -- bug 3593690: retain messages from copy_delivery_record

5048:
5049:
5050: wsh_deliveries_grp.create_update_delivery (
5051: p_api_version_number => 1.0,
5052: p_init_msg_list => FND_API.G_FALSE, -- bug 3593690: retain messages from copy_delivery_record
5053: p_commit => FND_API.G_FALSE,
5054: p_in_rec => l_del_in_rec,
5055: p_rec_attr_tab => l_del_attrs,
5056: x_del_out_rec_tab => l_del_out_tab,

Line 5053: p_commit => FND_API.G_FALSE,

5049:
5050: wsh_deliveries_grp.create_update_delivery (
5051: p_api_version_number => 1.0,
5052: p_init_msg_list => FND_API.G_FALSE, -- bug 3593690: retain messages from copy_delivery_record
5053: p_commit => FND_API.G_FALSE,
5054: p_in_rec => l_del_in_rec,
5055: p_rec_attr_tab => l_del_attrs,
5056: x_del_out_rec_tab => l_del_out_tab,
5057: x_return_status => l_return_status,

Line 5121: p_init_msg_list => FND_API.G_TRUE,

5117: l_stop_action_prms.action_code := 'DELETE';
5118:
5119: WSH_TRIP_STOPS_GRP.stop_action(
5120: p_api_version_number => 1.0,
5121: p_init_msg_list => FND_API.G_TRUE,
5122: p_commit => FND_API.G_FALSE,
5123: p_action_prms => l_stop_action_prms,
5124: p_rec_attr_tab => l_stop_attrs,
5125: x_stop_out_rec => l_stop_action_rec,

Line 5122: p_commit => FND_API.G_FALSE,

5118:
5119: WSH_TRIP_STOPS_GRP.stop_action(
5120: p_api_version_number => 1.0,
5121: p_init_msg_list => FND_API.G_TRUE,
5122: p_commit => FND_API.G_FALSE,
5123: p_action_prms => l_stop_action_prms,
5124: p_rec_attr_tab => l_stop_attrs,
5125: x_stop_out_rec => l_stop_action_rec,
5126: x_def_rec => l_stop_defaults,

Line 5177: p_init_msg_list => FND_API.G_FALSE,

5173: END IF;
5174:
5175: wsh_trip_stops_grp.Create_Update_Stop(
5176: p_api_version_number => 1.0,
5177: p_init_msg_list => FND_API.G_FALSE,
5178: p_commit => FND_API.G_FALSE,
5179: p_in_rec => l_stop_in_rec,
5180: p_rec_attr_tab => l_stop_attrs,
5181: x_stop_out_tab => l_stop_out_tab,

Line 5178: p_commit => FND_API.G_FALSE,

5174:
5175: wsh_trip_stops_grp.Create_Update_Stop(
5176: p_api_version_number => 1.0,
5177: p_init_msg_list => FND_API.G_FALSE,
5178: p_commit => FND_API.G_FALSE,
5179: p_in_rec => l_stop_in_rec,
5180: p_rec_attr_tab => l_stop_attrs,
5181: x_stop_out_tab => l_stop_out_tab,
5182: x_return_status => l_return_status,

Line 5261: p_init_msg_list => FND_API.G_TRUE,

5257:
5258:
5259: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(
5260: p_api_version_number => 1.0,
5261: p_init_msg_list => FND_API.G_TRUE,
5262: p_commit => FND_API.G_FALSE,
5263: x_return_status => l_return_status,
5264: x_msg_count => l_msg_count,
5265: x_msg_data => l_msg_data,

Line 5262: p_commit => FND_API.G_FALSE,

5258:
5259: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(
5260: p_api_version_number => 1.0,
5261: p_init_msg_list => FND_API.G_TRUE,
5262: p_commit => FND_API.G_FALSE,
5263: x_return_status => l_return_status,
5264: x_msg_count => l_msg_count,
5265: x_msg_data => l_msg_data,
5266: p_rec_attr_tab => l_dd_attrs,

Line 5386: p_init_msg_list => FND_API.G_TRUE,

5382: l_dd_action_prms.split_quantity := NULL;
5383:
5384: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(
5385: p_api_version_number => 1.0,
5386: p_init_msg_list => FND_API.G_TRUE,
5387: p_commit => FND_API.G_FALSE,
5388: x_return_status => l_return_status,
5389: x_msg_count => l_msg_count,
5390: x_msg_data => l_msg_data,

Line 5387: p_commit => FND_API.G_FALSE,

5383:
5384: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(
5385: p_api_version_number => 1.0,
5386: p_init_msg_list => FND_API.G_TRUE,
5387: p_commit => FND_API.G_FALSE,
5388: x_return_status => l_return_status,
5389: x_msg_count => l_msg_count,
5390: x_msg_data => l_msg_data,
5391: p_rec_attr_tab => l_dd_attrs,

Line 5430: p_init_msg_list => FND_API.G_TRUE,

5426: l_dd_action_prms.delivery_id := NULL;
5427:
5428: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(
5429: p_api_version_number => 1.0,
5430: p_init_msg_list => FND_API.G_TRUE,
5431: p_commit => FND_API.G_FALSE,
5432: x_return_status => l_return_status,
5433: x_msg_count => l_msg_count,
5434: x_msg_data => l_msg_data,

Line 5431: p_commit => FND_API.G_FALSE,

5427:
5428: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(
5429: p_api_version_number => 1.0,
5430: p_init_msg_list => FND_API.G_TRUE,
5431: p_commit => FND_API.G_FALSE,
5432: x_return_status => l_return_status,
5433: x_msg_count => l_msg_count,
5434: x_msg_data => l_msg_data,
5435: p_rec_attr_tab => l_sd_dd_attrs,

Line 5577: p_init_msg_list => FND_API.G_TRUE,

5573: l_dd_action_prms.delivery_id := NULL;
5574:
5575: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(
5576: p_api_version_number => 1.0,
5577: p_init_msg_list => FND_API.G_TRUE,
5578: p_commit => FND_API.G_FALSE,
5579: x_return_status => l_return_status,
5580: x_msg_count => l_msg_count,
5581: x_msg_data => l_msg_data,

Line 5578: p_commit => FND_API.G_FALSE,

5574:
5575: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(
5576: p_api_version_number => 1.0,
5577: p_init_msg_list => FND_API.G_TRUE,
5578: p_commit => FND_API.G_FALSE,
5579: x_return_status => l_return_status,
5580: x_msg_count => l_msg_count,
5581: x_msg_data => l_msg_data,
5582: p_rec_attr_tab => l_unassign_details,

Line 5704: p_init_msg_list => FND_API.G_TRUE,

5700: END LOOP;
5701:
5702: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(
5703: p_api_version_number => 1.0,
5704: p_init_msg_list => FND_API.G_TRUE,
5705: p_commit => FND_API.G_FALSE,
5706: x_return_status => l_return_status,
5707: x_msg_count => l_msg_count,
5708: x_msg_data => l_msg_data,

Line 5705: p_commit => FND_API.G_FALSE,

5701:
5702: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(
5703: p_api_version_number => 1.0,
5704: p_init_msg_list => FND_API.G_TRUE,
5705: p_commit => FND_API.G_FALSE,
5706: x_return_status => l_return_status,
5707: x_msg_count => l_msg_count,
5708: x_msg_data => l_msg_data,
5709: p_rec_attr_tab => l_dd_attrs,

Line 5896: p_init_msg_list => FND_API.G_TRUE,

5892: END LOOP;
5893:
5894: WSH_DELIVERIES_GRP.delivery_action(
5895: p_api_version_number => 1.0,
5896: p_init_msg_list => FND_API.G_TRUE,
5897: p_commit => FND_API.G_FALSE,
5898: p_action_prms => l_del_action_prms,
5899: p_rec_attr_tab => l_del_attrs,
5900: x_delivery_out_rec => l_del_action_rec,

Line 5897: p_commit => FND_API.G_FALSE,

5893:
5894: WSH_DELIVERIES_GRP.delivery_action(
5895: p_api_version_number => 1.0,
5896: p_init_msg_list => FND_API.G_TRUE,
5897: p_commit => FND_API.G_FALSE,
5898: p_action_prms => l_del_action_prms,
5899: p_rec_attr_tab => l_del_attrs,
5900: x_delivery_out_rec => l_del_action_rec,
5901: x_defaults_rec => l_del_defaults,

Line 6005: p_init_msg_list => FND_API.G_TRUE,

6001: l_del_action_prms.dropoff_stop_id := NULL;
6002:
6003: WSH_DELIVERIES_GRP.delivery_action(
6004: p_api_version_number => 1.0,
6005: p_init_msg_list => FND_API.G_TRUE,
6006: p_commit => FND_API.G_FALSE,
6007: p_action_prms => l_del_action_prms,
6008: p_rec_attr_tab => l_cf_dels,
6009: x_delivery_out_rec => l_del_action_rec,

Line 6006: p_commit => FND_API.G_FALSE,

6002:
6003: WSH_DELIVERIES_GRP.delivery_action(
6004: p_api_version_number => 1.0,
6005: p_init_msg_list => FND_API.G_TRUE,
6006: p_commit => FND_API.G_FALSE,
6007: p_action_prms => l_del_action_prms,
6008: p_rec_attr_tab => l_cf_dels,
6009: x_delivery_out_rec => l_del_action_rec,
6010: x_defaults_rec => l_del_defaults,

Line 6055: p_init_msg_list => FND_API.G_TRUE,

6051: l_del_action_prms.dropoff_stop_id := NULL;
6052:
6053: WSH_DELIVERIES_GRP.delivery_action(
6054: p_api_version_number => 1.0,
6055: p_init_msg_list => FND_API.G_TRUE,
6056: p_commit => FND_API.G_FALSE,
6057: p_action_prms => l_del_action_prms,
6058: p_rec_attr_tab => l_rcf_dels,
6059: x_delivery_out_rec => l_del_action_rec,

Line 6056: p_commit => FND_API.G_FALSE,

6052:
6053: WSH_DELIVERIES_GRP.delivery_action(
6054: p_api_version_number => 1.0,
6055: p_init_msg_list => FND_API.G_TRUE,
6056: p_commit => FND_API.G_FALSE,
6057: p_action_prms => l_del_action_prms,
6058: p_rec_attr_tab => l_rcf_dels,
6059: x_delivery_out_rec => l_del_action_rec,
6060: x_defaults_rec => l_del_defaults,

Line 6138: p_init_msg_list => FND_API.G_TRUE,

6134: l_trip_action_prms.action_code := 'PLAN';
6135:
6136: wsh_trips_grp.trip_action(
6137: p_api_version_number => 1.0,
6138: p_init_msg_list => FND_API.G_TRUE,
6139: p_commit => FND_API.G_FALSE,
6140: p_action_prms => l_trip_action_prms,
6141: p_rec_attr_tab => l_rf_trips,
6142: x_trip_out_rec => l_trip_out_rec,

Line 6139: p_commit => FND_API.G_FALSE,

6135:
6136: wsh_trips_grp.trip_action(
6137: p_api_version_number => 1.0,
6138: p_init_msg_list => FND_API.G_TRUE,
6139: p_commit => FND_API.G_FALSE,
6140: p_action_prms => l_trip_action_prms,
6141: p_rec_attr_tab => l_rf_trips,
6142: x_trip_out_rec => l_trip_out_rec,
6143: x_def_rec => l_trip_defaults,

Line 6184: p_init_msg_list => FND_API.G_TRUE,

6180: l_trip_action_prms.action_code := 'FIRM';
6181:
6182: wsh_trips_grp.trip_action(
6183: p_api_version_number => 1.0,
6184: p_init_msg_list => FND_API.G_TRUE,
6185: p_commit => FND_API.G_FALSE,
6186: p_action_prms => l_trip_action_prms,
6187: p_rec_attr_tab => l_rcf_trips,
6188: x_trip_out_rec => l_trip_out_rec,

Line 6185: p_commit => FND_API.G_FALSE,

6181:
6182: wsh_trips_grp.trip_action(
6183: p_api_version_number => 1.0,
6184: p_init_msg_list => FND_API.G_TRUE,
6185: p_commit => FND_API.G_FALSE,
6186: p_action_prms => l_trip_action_prms,
6187: p_rec_attr_tab => l_rcf_trips,
6188: x_trip_out_rec => l_trip_out_rec,
6189: x_def_rec => l_trip_defaults,

Line 6278: p_init_msg_list => FND_API.G_TRUE,

6274: END LOOP;
6275:
6276: WSH_FTE_INTEGRATION.Rate_Trip (
6277: p_api_version => 1.0,
6278: p_init_msg_list => FND_API.G_TRUE,
6279: p_action_params => l_rating_action_params,
6280: p_commit => FND_API.G_FALSE,
6281: x_return_status => l_return_status,
6282: x_msg_count => l_msg_count,

Line 6280: p_commit => FND_API.G_FALSE,

6276: WSH_FTE_INTEGRATION.Rate_Trip (
6277: p_api_version => 1.0,
6278: p_init_msg_list => FND_API.G_TRUE,
6279: p_action_params => l_rating_action_params,
6280: p_commit => FND_API.G_FALSE,
6281: x_return_status => l_return_status,
6282: x_msg_count => l_msg_count,
6283: x_msg_data => l_msg_data);
6284:

Line 6314: -- p_init_msg_list => FND_API.G_TRUE,

6310: --END IF;
6311: --
6312: --WSH_FTE_INTEGRATION.CREATE_RANK_LIST_BULK(
6313: -- p_api_version_number => 1,
6314: -- p_init_msg_list => FND_API.G_TRUE,
6315: -- x_return_status => l_return_status,
6316: -- x_msg_count => l_msg_count,
6317: -- x_msg_data => l_msg_data,
6318: -- p_source => WSH_FTE_INTEGRATION.C_RANKLIST_SOURCE_TP,

Line 6390: p_init_msg_list => FND_API.G_TRUE, --??? or FALSE

6386: END IF;
6387:
6388: WSH_FTE_INTEGRATION.Trip_Action (
6389: p_api_version => 1.0,
6390: p_init_msg_list => FND_API.G_TRUE, --??? or FALSE
6391: p_trip_id_tab => l_trip_id_tab,
6392: p_action_params => l_trip_action_params,
6393: p_commit => FND_API.G_FALSE,
6394: x_action_out_rec => l_trip_action_out_rec,

Line 6393: p_commit => FND_API.G_FALSE,

6389: p_api_version => 1.0,
6390: p_init_msg_list => FND_API.G_TRUE, --??? or FALSE
6391: p_trip_id_tab => l_trip_id_tab,
6392: p_action_params => l_trip_action_params,
6393: p_commit => FND_API.G_FALSE,
6394: x_action_out_rec => l_trip_action_out_rec,
6395: x_return_status => l_return_status,
6396: x_msg_count => l_msg_count,
6397: x_msg_data => l_msg_data);

Line 6463: WHEN fnd_api.g_exc_error THEN

6459: WSH_DEBUG_SV.pop(l_module_name);
6460: END IF;
6461:
6462: EXCEPTION
6463: WHEN fnd_api.g_exc_error THEN
6464: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6465: fnd_msg_pub.count_and_get(
6466: p_count => l_msg_count,
6467: p_data => l_msg_data,

Line 6468: p_encoded => fnd_api.g_false);

6464: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6465: fnd_msg_pub.count_and_get(
6466: p_count => l_msg_count,
6467: p_data => l_msg_data,
6468: p_encoded => fnd_api.g_false);
6469: --
6470: stamp_interface_error(
6471: p_group_id => x_context.group_id,
6472: p_entity_table_name => l_interface_entity,

Line 6479: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);

6475: x_errors_tab => x_errors_tab,
6476: x_return_status => l_return_status);
6477: --
6478: IF l_debug_on THEN
6479: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
6480: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
6481: END IF;
6482: --
6483:

Line 6480: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');

6476: x_return_status => l_return_status);
6477: --
6478: IF l_debug_on THEN
6479: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
6480: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
6481: END IF;
6482: --
6483:
6484:

Line 6486: WHEN fnd_api.g_exc_unexpected_error THEN

6482: --
6483:
6484:
6485:
6486: WHEN fnd_api.g_exc_unexpected_error THEN
6487: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6488: fnd_msg_pub.count_and_get(
6489: p_count => l_msg_count,
6490: p_data => l_msg_data,

Line 6491: p_encoded => fnd_api.g_false);

6487: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6488: fnd_msg_pub.count_and_get(
6489: p_count => l_msg_count,
6490: p_data => l_msg_data,
6491: p_encoded => fnd_api.g_false);
6492: --
6493: stamp_interface_error(
6494: p_group_id => x_context.group_id,
6495: p_entity_table_name => l_interface_entity,

Line 6502: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);

6498: x_errors_tab => x_errors_tab,
6499: x_return_status => l_return_status);
6500: --
6501: IF l_debug_on THEN
6502: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
6503: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6504: END IF;
6505:
6506:

Line 6503: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

6499: x_return_status => l_return_status);
6500: --
6501: IF l_debug_on THEN
6502: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
6503: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6504: END IF;
6505:
6506:
6507: WHEN OTHERS THEN

Line 6936: p_init_msg_list => FND_API.G_TRUE,

6932: l_del_action_prms.trip_id := leg.trip_id;
6933:
6934: WSH_DELIVERIES_GRP.delivery_action(
6935: p_api_version_number => 1.0,
6936: p_init_msg_list => FND_API.G_TRUE,
6937: p_commit => FND_API.G_FALSE,
6938: p_action_prms => l_del_action_prms,
6939: p_rec_attr_tab => l_del_attrs,
6940: x_delivery_out_rec => l_del_action_rec,

Line 6937: p_commit => FND_API.G_FALSE,

6933:
6934: WSH_DELIVERIES_GRP.delivery_action(
6935: p_api_version_number => 1.0,
6936: p_init_msg_list => FND_API.G_TRUE,
6937: p_commit => FND_API.G_FALSE,
6938: p_action_prms => l_del_action_prms,
6939: p_rec_attr_tab => l_del_attrs,
6940: x_delivery_out_rec => l_del_action_rec,
6941: x_defaults_rec => l_del_defaults,

Line 7252: p_init_msg_list => FND_API.G_TRUE,

7248: l_stop_action_prms.action_code := 'DELETE';
7249:
7250: WSH_TRIP_STOPS_GRP.stop_action(
7251: p_api_version_number => 1.0,
7252: p_init_msg_list => FND_API.G_TRUE,
7253: p_commit => FND_API.G_FALSE,
7254: p_action_prms => l_stop_action_prms,
7255: p_rec_attr_tab => l_stop_attrs,
7256: x_stop_out_rec => l_stop_action_rec,

Line 7253: p_commit => FND_API.G_FALSE,

7249:
7250: WSH_TRIP_STOPS_GRP.stop_action(
7251: p_api_version_number => 1.0,
7252: p_init_msg_list => FND_API.G_TRUE,
7253: p_commit => FND_API.G_FALSE,
7254: p_action_prms => l_stop_action_prms,
7255: p_rec_attr_tab => l_stop_attrs,
7256: x_stop_out_rec => l_stop_action_rec,
7257: x_def_rec => l_stop_defaults,

Line 7307: p_init_msg_list => FND_API.G_TRUE,

7303: l_trip_action_prms.action_code := 'DELETE';
7304:
7305: wsh_trips_grp.trip_action(
7306: p_api_version_number => 1.0,
7307: p_init_msg_list => FND_API.G_TRUE,
7308: p_commit => FND_API.G_FALSE,
7309: p_action_prms => l_trip_action_prms,
7310: p_rec_attr_tab => l_trip_attrs,
7311: x_trip_out_rec => l_trip_out_rec,

Line 7308: p_commit => FND_API.G_FALSE,

7304:
7305: wsh_trips_grp.trip_action(
7306: p_api_version_number => 1.0,
7307: p_init_msg_list => FND_API.G_TRUE,
7308: p_commit => FND_API.G_FALSE,
7309: p_action_prms => l_trip_action_prms,
7310: p_rec_attr_tab => l_trip_attrs,
7311: x_trip_out_rec => l_trip_out_rec,
7312: x_def_rec => l_trip_defaults,

Line 10248: p_init_msg_list => FND_API.G_FALSE,

10244: -- phase 2: call this API only if lane_id needs to be populated.
10245:
10246: wsh_trips_grp.Create_Update_Trip(
10247: p_api_version_number => 1.0,
10248: p_init_msg_list => FND_API.G_FALSE,
10249: p_commit => FND_API.G_FALSE,
10250: p_trip_info_tab => l_trip_attrs,
10251: p_In_rec => l_trip_in_rec,
10252: x_Out_Tab => l_trip_out_tab,

Line 10249: p_commit => FND_API.G_FALSE,

10245:
10246: wsh_trips_grp.Create_Update_Trip(
10247: p_api_version_number => 1.0,
10248: p_init_msg_list => FND_API.G_FALSE,
10249: p_commit => FND_API.G_FALSE,
10250: p_trip_info_tab => l_trip_attrs,
10251: p_In_rec => l_trip_in_rec,
10252: x_Out_Tab => l_trip_out_tab,
10253: x_return_status => l_return_status,

Line 10281: WHEN fnd_api.g_exc_error THEN

10277: END IF;
10278:
10279:
10280: EXCEPTION
10281: WHEN fnd_api.g_exc_error THEN
10282: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10283: fnd_msg_pub.count_and_get(
10284: p_count => l_msg_count,
10285: p_data => l_msg_data,

Line 10286: p_encoded => fnd_api.g_false);

10282: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
10283: fnd_msg_pub.count_and_get(
10284: p_count => l_msg_count,
10285: p_data => l_msg_data,
10286: p_encoded => fnd_api.g_false);
10287: --
10288: stamp_interface_error(
10289: p_group_id => x_context.group_id,
10290: p_entity_table_name => l_interface_entity,

Line 10297: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);

10293: x_errors_tab => x_errors_tab,
10294: x_return_status => l_return_status);
10295: --
10296: IF l_debug_on THEN
10297: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
10298: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
10299: END IF;
10300:
10301: WHEN fnd_api.g_exc_unexpected_error THEN

Line 10298: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');

10294: x_return_status => l_return_status);
10295: --
10296: IF l_debug_on THEN
10297: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
10298: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
10299: END IF;
10300:
10301: WHEN fnd_api.g_exc_unexpected_error THEN
10302: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 10301: WHEN fnd_api.g_exc_unexpected_error THEN

10297: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
10298: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
10299: END IF;
10300:
10301: WHEN fnd_api.g_exc_unexpected_error THEN
10302: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
10303: fnd_msg_pub.count_and_get(
10304: p_count => l_msg_count,
10305: p_data => l_msg_data,

Line 10306: p_encoded => fnd_api.g_false);

10302: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
10303: fnd_msg_pub.count_and_get(
10304: p_count => l_msg_count,
10305: p_data => l_msg_data,
10306: p_encoded => fnd_api.g_false);
10307: --
10308: stamp_interface_error(
10309: p_group_id => x_context.group_id,
10310: p_entity_table_name => l_interface_entity,

Line 10317: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);

10313: x_errors_tab => x_errors_tab,
10314: x_return_status => l_return_status);
10315: --
10316: IF l_debug_on THEN
10317: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
10318: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10319: END IF;
10320:
10321: WHEN OTHERS THEN

Line 10318: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

10314: x_return_status => l_return_status);
10315: --
10316: IF l_debug_on THEN
10317: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
10318: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
10319: END IF;
10320:
10321: WHEN OTHERS THEN
10322: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 10453: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE,

10449: IF l_debug_on THEN
10450: WSH_DEBUG_SV.log(l_module_name,'COUNT--',c);
10451: END IF;
10452: FOR i in 1..c LOOP
10453: FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE,
10454: p_msg_index => i,
10455: p_data => l_buffer,
10456: p_msg_index_out => l_index_out);
10457: