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.

[Home] [Help]

APPS.FTE_FREIGHT_PRICING dependencies on FND_API

Line 2067: RAISE FND_API.G_EXC_ERROR;

2063: p_exc => ' ',
2064: p_msg_name => 'FTE_PRC_EMPTY_DEL',
2065: p_msg_type => 'E',
2066: p_delivery_id => p_delivery_id);
2067: RAISE FND_API.G_EXC_ERROR;
2068: END IF;
2069:
2070: -- validate freight term
2071: l_count := 0;

Line 2110: WHEN FND_API.G_EXC_ERROR THEN

2106: EXCEPTION
2107: WHEN g_finished_warning THEN
2108: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2109: --
2110: WHEN FND_API.G_EXC_ERROR THEN
2111: x_return_code := G_RC_ERROR;
2112: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
2113: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2114: --

Line 2112: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');

2108: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2109: --
2110: WHEN FND_API.G_EXC_ERROR THEN
2111: x_return_code := G_RC_ERROR;
2112: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
2113: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2114: --
2115: WHEN OTHERS THEN
2116: WSH_UTIL_CORE.DEFAULT_HANDLER(G_PKG_NAME||'.'||l_api_name);

Line 2152: RAISE FND_API.G_EXC_ERROR;

2148: p_exc => ' ',
2149: p_msg_name => 'FTE_PRC_TRP_NO_DLV',
2150: p_msg_type => 'E',
2151: p_trip_id => p_trip_id);
2152: RAISE FND_API.G_EXC_ERROR;
2153: END IF;
2154:
2155: -- check for empty delivery
2156: l_count := 0;

Line 2170: RAISE FND_API.G_EXC_ERROR;

2166: p_exc => ' ',
2167: p_msg_name => 'FTE_PRC_TRP_NO_DEL_CONTENT',
2168: p_msg_type => 'E',
2169: p_trip_id => p_trip_id);
2170: RAISE FND_API.G_EXC_ERROR;
2171: END IF;
2172:
2173: -- validate freight term
2174: l_count := 0;

Line 2213: WHEN FND_API.G_EXC_ERROR THEN

2209: EXCEPTION
2210: WHEN g_finished_warning THEN
2211: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2212: --
2213: WHEN FND_API.G_EXC_ERROR THEN
2214: x_return_code := G_RC_ERROR;
2215: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
2216: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2217: --

Line 2215: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');

2211: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2212: --
2213: WHEN FND_API.G_EXC_ERROR THEN
2214: x_return_code := G_RC_ERROR;
2215: FTE_FREIGHT_PRICING_UTIL.set_exception(l_api_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
2216: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
2217: --
2218: WHEN OTHERS THEN
2219: WSH_UTIL_CORE.DEFAULT_HANDLER(G_PKG_NAME||'.'||l_api_name);

Line 5007: raise FND_API.G_EXC_ERROR;

5003:
5004: IF l_uom_ea is null THEN
5005: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After get_uom_for_each ');
5006: fte_freight_pricing_util.set_exception(l_api_name,l_log_level,'g_get_uom_for_each_failed');
5007: raise FND_API.G_EXC_ERROR;
5008: END IF;
5009:
5010: i := g_shipment_line_rows.FIRST;
5011: LOOP

Line 5151: WHEN FND_API.G_EXC_ERROR THEN

5147: x_return_status := l_return_status;
5148: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'rollup_container_hierarchy');
5149:
5150: EXCEPTION
5151: WHEN FND_API.G_EXC_ERROR THEN
5152: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5153: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'rollup_container_hierarchy');
5154: WHEN FTE_FREIGHT_PRICING_UTIL.g_rollup_container_failed THEN
5155: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 5215: raise FND_API.G_EXC_ERROR;

5211:
5212: IF l_uom_ea is null THEN
5213: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After get_uom_for_each ');
5214: fte_freight_pricing_util.set_exception(l_api_name,l_log_level,'g_get_uom_for_each_failed');
5215: raise FND_API.G_EXC_ERROR;
5216: END IF;
5217:
5218: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'p_classification_code='||p_classification_code);
5219: IF p_classification_code IS NOT NULL THEN

Line 5342: WHEN FND_API.G_EXC_ERROR THEN

5338: x_return_status := l_return_status;
5339: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'rollup_loose_item');
5340:
5341: EXCEPTION
5342: WHEN FND_API.G_EXC_ERROR THEN
5343: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5344: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'rollup_loose_item');
5345: WHEN FTE_FREIGHT_PRICING_UTIL.g_rollup_container_failed THEN
5346: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 7114: RAISE FND_API.G_EXC_ERROR;

7110: x_return_status => l_return_status );
7111:
7112: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7113: and l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
7114: RAISE FND_API.G_EXC_ERROR;
7115: END IF;
7116:
7117: END IF; --l_lane_function = 'LTL' and p_classification_code = 'FC'
7118:

Line 7122: WHEN FND_API.G_EXC_ERROR THEN

7118:
7119: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'process_shipment_pattern');
7120:
7121: EXCEPTION
7122: WHEN FND_API.G_EXC_ERROR THEN
7123: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7124: FTE_FREIGHT_PRICING_UTIL.set_exception('process_shipment_pattern',FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
7125: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'process_shipment_pattern');
7126: WHEN FTE_FREIGHT_PRICING_UTIL.g_initialize_failed THEN

Line 7124: FTE_FREIGHT_PRICING_UTIL.set_exception('process_shipment_pattern',FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');

7120:
7121: EXCEPTION
7122: WHEN FND_API.G_EXC_ERROR THEN
7123: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7124: FTE_FREIGHT_PRICING_UTIL.set_exception('process_shipment_pattern',FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
7125: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'process_shipment_pattern');
7126: WHEN FTE_FREIGHT_PRICING_UTIL.g_initialize_failed THEN
7127: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7128: FTE_FREIGHT_PRICING_UTIL.set_exception('process_shipment_pattern',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_initialize_failed');

Line 7558: RAISE FND_API.G_EXC_ERROR;

7554: x_return_status => l_return_status ) ;
7555:
7556: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7557: and l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
7558: RAISE FND_API.G_EXC_ERROR;
7559: END IF;
7560:
7561: ELSE -- l_lane_info.basis <> 'CONTAINER_ALL'
7562:

Line 7629: RAISE FND_API.G_EXC_ERROR;

7625: x_return_status => l_return_status ) ;
7626:
7627: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7628: and l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
7629: RAISE FND_API.G_EXC_ERROR;
7630: END IF;
7631:
7632: ELSE
7633:

Line 8125: WHEN FND_API.G_EXC_ERROR THEN

8121:
8122: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_pricing');
8123:
8124: EXCEPTION
8125: WHEN FND_API.G_EXC_ERROR THEN
8126: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8127: FTE_FREIGHT_PRICING_UTIL.set_exception('process_shipment_pattern',FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
8128: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_pricing');
8129:

Line 8127: FTE_FREIGHT_PRICING_UTIL.set_exception('process_shipment_pattern',FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');

8123:
8124: EXCEPTION
8125: WHEN FND_API.G_EXC_ERROR THEN
8126: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8127: FTE_FREIGHT_PRICING_UTIL.set_exception('process_shipment_pattern',FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
8128: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_pricing');
8129:
8130:
8131:

Line 8997: RAISE FND_API.G_EXC_ERROR;

8993: p_trip_id => p_segment_id,
8994: x_return_code => l_return_code);
8995:
8996: IF l_return_code = G_RC_ERROR THEN
8997: RAISE FND_API.G_EXC_ERROR;
8998: ELSIF (l_return_code = G_RC_REPRICE_NOT_REQUIRED
8999: OR l_return_code = G_RC_NOT_RATE_FREIGHT_TERM
9000: OR l_return_code = G_RC_NOT_RATE_MANIFESTING) THEN
9001: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 9015: RAISE FND_API.G_EXC_ERROR;

9011: p_delivery_id => l_delivery_id,
9012: x_return_code => l_return_code);
9013:
9014: IF l_return_code = G_RC_ERROR THEN
9015: RAISE FND_API.G_EXC_ERROR;
9016: ELSIF (l_return_code = G_RC_REPRICE_NOT_REQUIRED
9017: OR l_return_code = G_RC_NOT_RATE_FREIGHT_TERM
9018: OR l_return_code = G_RC_NOT_RATE_MANIFESTING) THEN
9019: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 9524: WHEN FND_API.G_EXC_ERROR THEN

9520: EXCEPTION
9521: WHEN g_finished_warning THEN
9522: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
9523: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_consolidate');
9524: WHEN FND_API.G_EXC_ERROR THEN
9525: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9526: FTE_FREIGHT_PRICING_UTIL.set_exception('shipment_price_consolidate',FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
9527: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_consolidate');
9528: WHEN FTE_FREIGHT_PRICING_UTIL.g_noleg_segment THEN

Line 9526: FTE_FREIGHT_PRICING_UTIL.set_exception('shipment_price_consolidate',FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');

9522: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
9523: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_consolidate');
9524: WHEN FND_API.G_EXC_ERROR THEN
9525: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9526: FTE_FREIGHT_PRICING_UTIL.set_exception('shipment_price_consolidate',FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
9527: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_consolidate');
9528: WHEN FTE_FREIGHT_PRICING_UTIL.g_noleg_segment THEN
9529: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9530: FTE_FREIGHT_PRICING_UTIL.set_exception('shipment_price_consolidate',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_noleg_segment');

Line 9566: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,

9562:
9563: END shipment_price_consolidate;
9564:
9565: PROCEDURE shipment_price_consolidate (
9566: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,
9567: p_in_attributes IN FtePricingInRecType,
9568: x_return_status OUT NOCOPY VARCHAR2,
9569: x_msg_count OUT NOCOPY NUMBER,
9570: x_msg_data OUT NOCOPY VARCHAR2 )

Line 9585: IF FND_API.to_Boolean( p_init_msg_list ) THEN

9581:
9582: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
9583:
9584: -- Initialize message list if p_init_msg_list is set to TRUE.
9585: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9586:
9587: FTE_FREIGHT_PRICING_UTIL.initialize_logging( p_init_msg_list => p_init_msg_list,
9588: x_return_status => l_return_status );
9589:

Line 9693: IF FND_API.to_Boolean( p_init_msg_list ) THEN

9689: p_count => x_msg_count,
9690: p_data => x_msg_data );
9691:
9692: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_consolidate_standard');
9693: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9694: FTE_FREIGHT_PRICING_UTIL.close_logs;
9695: END IF;
9696:
9697: EXCEPTION

Line 9703: IF FND_API.to_Boolean( p_init_msg_list ) THEN

9699: WHEN FTE_FREIGHT_PRICING_UTIL.g_get_trip_mode_fail THEN
9700: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9701: FTE_FREIGHT_PRICING_UTIL.set_exit_exception('shipment_price_consolidate_standard','g_get_trip_mode_fail');
9702: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_consolidate_standard');
9703: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9704: FTE_FREIGHT_PRICING_UTIL.close_logs;
9705: END IF;
9706:
9707:

Line 9712: IF FND_API.to_Boolean( p_init_msg_list ) THEN

9708: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_rate_trip_fail THEN
9709: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9710: FTE_FREIGHT_PRICING_UTIL.set_exit_exception('shipment_price_consolidate_standard','g_tl_rate_trip_fail');
9711: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_consolidate_standard');
9712: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9713: FTE_FREIGHT_PRICING_UTIL.close_logs;
9714: END IF;
9715:
9716:

Line 9721: IF FND_API.to_Boolean( p_init_msg_list ) THEN

9717: WHEN FTE_FREIGHT_PRICING_UTIL.g_price_consolidate_failed THEN
9718: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
9719: FTE_FREIGHT_PRICING_UTIL.set_exit_exception('shipment_price_consolidate_standard','g_price_consolidate_failed');
9720: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_consolidate_standard');
9721: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9722: FTE_FREIGHT_PRICING_UTIL.close_logs;
9723: END IF;
9724: WHEN others THEN
9725: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 9729: IF FND_API.to_Boolean( p_init_msg_list ) THEN

9725: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
9726: FTE_FREIGHT_PRICING_UTIL.set_exit_exception('shipment_price_consolidate_standard','g_others');
9727: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
9728: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_consolidate_standard');
9729: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9730: FTE_FREIGHT_PRICING_UTIL.close_logs;
9731: END IF;
9732: END shipment_price_consolidate;
9733:

Line 9735: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,

9731: END IF;
9732: END shipment_price_consolidate;
9733:
9734: PROCEDURE shipment_price_compare (
9735: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,
9736: p_delivery_id IN NUMBER,
9737: -- JDBC Thin driver can not support PL/SQL tables having one column (OCI driver supports) types
9738: -- thats why we are goint with this clumsy way of comma separated list
9739: p_lane_rows IN VARCHAR2 DEFAULT NULL,

Line 10479: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

10475: -- So in case of rerating Trip level rating will be called always instead of individual delivery leg
10476:
10477: PROCEDURE rerate_shipment_online(
10478: p_api_version IN NUMBER DEFAULT 1.0,
10479: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10480: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10481: p_deliveries_list IN FTE_ID_TAB_TYPE,
10482: p_delivery_name_list IN FTE_NAME_TAB_TYPE,
10483: p_deliveries_list_type IN VARCHAR2 , -- This will have 'DEL' for Delivery IDs or 'DLEG' for Delivery Leg Ids.

Line 10480: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

10476:
10477: PROCEDURE rerate_shipment_online(
10478: p_api_version IN NUMBER DEFAULT 1.0,
10479: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10480: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
10481: p_deliveries_list IN FTE_ID_TAB_TYPE,
10482: p_delivery_name_list IN FTE_NAME_TAB_TYPE,
10483: p_deliveries_list_type IN VARCHAR2 , -- This will have 'DEL' for Delivery IDs or 'DLEG' for Delivery Leg Ids.
10484: x_success_list OUT NOCOPY FTE_ID_TAB_TYPE,

Line 10558: IF NOT FND_API.Compatible_API_Call

10554: BEGIN
10555: SAVEPOINT rerate_shipment_online;
10556: --
10557: -- Standard call to check for call compatibility.
10558: IF NOT FND_API.Compatible_API_Call
10559: (
10560: l_api_version,
10561: p_api_version,
10562: l_api_name,

Line 10566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

10562: l_api_name,
10563: G_PKG_NAME
10564: )
10565: THEN
10566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10567: END IF;
10568:
10569:
10570: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 10571: IF FND_API.to_Boolean( p_init_msg_list )

10567: END IF;
10568:
10569:
10570: -- Initialize message list if p_init_msg_list is set to TRUE.
10571: IF FND_API.to_Boolean( p_init_msg_list )
10572: THEN
10573: FND_MSG_PUB.initialize;
10574: END IF;
10575:

Line 10807: p_init_msg_list => FND_API.G_FALSE,

10803:
10804: FTE_TRIP_RATING_GRP.Rate_Trip
10805: (
10806: p_api_version => 1.0,
10807: p_init_msg_list => FND_API.G_FALSE,
10808: p_action_params => l_action_params,
10809: p_commit => FND_API.G_FALSE,
10810: p_init_prc_log => 'N',
10811: x_return_status => l_return_status,

Line 10809: p_commit => FND_API.G_FALSE,

10805: (
10806: p_api_version => 1.0,
10807: p_init_msg_list => FND_API.G_FALSE,
10808: p_action_params => l_action_params,
10809: p_commit => FND_API.G_FALSE,
10810: p_init_prc_log => 'N',
10811: x_return_status => l_return_status,
10812: x_msg_count => l_msg_count,
10813: x_msg_data => l_msg_data

Line 10836: p_encoded => FND_API.G_FALSE

10832: FND_MSG_PUB.Count_And_Get
10833: (
10834: p_count => l_msg_count,
10835: p_data => l_message,
10836: p_encoded => FND_API.G_FALSE
10837: );
10838: FTE_FREIGHT_PRICING_UTIL.print_msg(p_msg => 'Warning : '||l_message);
10839: FOR j1 IN l_all_trips.FIRST..l_all_trips.LAST LOOP
10840: IF l_all_trips(j1).trip_id = l_trip_ids(l_index).trip_id THEN

Line 10861: p_encoded => FND_API.G_FALSE

10857: FND_MSG_PUB.Count_And_Get
10858: (
10859: p_count => l_msg_count,
10860: p_data => l_message,
10861: p_encoded => FND_API.G_FALSE
10862: );
10863: FTE_FREIGHT_PRICING_UTIL.print_msg(p_msg => 'Error : '||l_message);
10864: FOR j1 IN l_all_trips.FIRST..l_all_trips.LAST LOOP
10865: IF l_all_trips(j1).trip_id = l_trip_ids(l_index).trip_id THEN

Line 10950: IF FND_API.To_Boolean( p_commit ) THEN

10946: RAISE l_dleg_validation_failed;
10947: END IF;
10948:
10949:
10950: IF FND_API.To_Boolean( p_commit ) THEN
10951:
10952: COMMIT WORK;
10953:
10954: END IF;

Line 10960: p_encoded => FND_API.G_FALSE

10956: FND_MSG_PUB.Count_And_Get
10957: (
10958: p_count => x_msg_count,
10959: p_data => x_msg_data,
10960: p_encoded => FND_API.G_FALSE
10961: );
10962:
10963:
10964:

Line 10978: -- p_encoded => FND_API.G_FALSE

10974: --FND_MSG_PUB.Count_And_Get
10975: -- (
10976: -- p_count => x_msg_count,
10977: -- p_data => x_msg_data,
10978: -- p_encoded => FND_API.G_FALSE
10979: -- );
10980: -- FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'msg count is ='||x_msg_count);
10981: -- FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'msg data is ='||x_msg_data);
10982: FTE_FREIGHT_PRICING_UTIL.set_exit_exception(l_api_name,'l_delivery_validation_failed');

Line 10992: p_encoded => FND_API.G_FALSE

10988: FND_MSG_PUB.Count_And_Get
10989: (
10990: p_count => x_msg_count,
10991: p_data => x_msg_data,
10992: p_encoded => FND_API.G_FALSE
10993: );
10994: FTE_FREIGHT_PRICING_UTIL.set_exit_exception(l_api_name,'l_dleg_list_empty');
10995: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
10996: FTE_FREIGHT_PRICING_UTIL.close_logs;

Line 11005: p_encoded => FND_API.G_FALSE

11001: FND_MSG_PUB.Count_And_Get
11002: (
11003: p_count => x_msg_count,
11004: p_data => x_msg_data,
11005: p_encoded => FND_API.G_FALSE
11006: );
11007: FTE_FREIGHT_PRICING_UTIL.set_exit_exception(l_api_name,'l_delv_list_empty');
11008: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
11009: FTE_FREIGHT_PRICING_UTIL.close_logs;

Line 11018: p_encoded => FND_API.G_FALSE

11014: FND_MSG_PUB.Count_And_Get
11015: (
11016: p_count => x_msg_count,
11017: p_data => x_msg_data,
11018: p_encoded => FND_API.G_FALSE
11019: );
11020: FTE_FREIGHT_PRICING_UTIL.set_exit_exception(l_api_name,'l_del_name_mismatch');
11021: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
11022: FTE_FREIGHT_PRICING_UTIL.close_logs;

Line 11030: p_encoded => FND_API.G_FALSE

11026: FND_MSG_PUB.Count_And_Get
11027: (
11028: p_count => x_msg_count,
11029: p_data => x_msg_data,
11030: p_encoded => FND_API.G_FALSE
11031: );
11032: FTE_FREIGHT_PRICING_UTIL.set_exception('shipment_reprice2',FTE_FREIGHT_PRICING_UTIL.G_ERR,'l_dleg_validation_failed');
11033: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_reprice2');
11034: FTE_FREIGHT_PRICING_UTIL.close_logs;

Line 11041: p_encoded => FND_API.G_FALSE

11037: FND_MSG_PUB.Count_And_Get
11038: (
11039: p_count => x_msg_count,
11040: p_data => x_msg_data,
11041: p_encoded => FND_API.G_FALSE
11042: );
11043: FTE_FREIGHT_PRICING_UTIL.set_exception('shipment_reprice2',FTE_FREIGHT_PRICING_UTIL.G_ERR,'l_delivery_leg_rating_failed');
11044: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_reprice2');
11045: FTE_FREIGHT_PRICING_UTIL.close_logs;

Line 11046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

11042: );
11043: FTE_FREIGHT_PRICING_UTIL.set_exception('shipment_reprice2',FTE_FREIGHT_PRICING_UTIL.G_ERR,'l_delivery_leg_rating_failed');
11044: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_reprice2');
11045: FTE_FREIGHT_PRICING_UTIL.close_logs;
11046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11047: ROLLBACK TO rerate_shipment_online;
11048: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11049: FND_MSG_PUB.Count_And_Get
11050: (

Line 11053: p_encoded => FND_API.G_FALSE

11049: FND_MSG_PUB.Count_And_Get
11050: (
11051: p_count => x_msg_count,
11052: p_data => x_msg_data,
11053: p_encoded => FND_API.G_FALSE
11054: );
11055:
11056: FTE_FREIGHT_PRICING_UTIL.set_exit_exception(l_api_name,'FND_API.G_EXC_UNEXPECTED_ERROR');
11057: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);

Line 11056: FTE_FREIGHT_PRICING_UTIL.set_exit_exception(l_api_name,'FND_API.G_EXC_UNEXPECTED_ERROR');

11052: p_data => x_msg_data,
11053: p_encoded => FND_API.G_FALSE
11054: );
11055:
11056: FTE_FREIGHT_PRICING_UTIL.set_exit_exception(l_api_name,'FND_API.G_EXC_UNEXPECTED_ERROR');
11057: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);
11058: FTE_FREIGHT_PRICING_UTIL.close_logs;
11059: WHEN others THEN
11060: ROLLBACK TO rerate_shipment_online;

Line 11066: p_encoded => FND_API.G_FALSE

11062: FND_MSG_PUB.Count_And_Get
11063: (
11064: p_count => x_msg_count,
11065: p_data => x_msg_data,
11066: p_encoded => FND_API.G_FALSE
11067: );
11068: FTE_FREIGHT_PRICING_UTIL.set_exit_exception(l_api_name,'g_others');
11069: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
11070: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_api_name);

Line 11511: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,

11507: END;
11508:
11509: -- todo take care of applied_to_charge_id
11510: PROCEDURE Move_fc_temp_to_main (
11511: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,
11512: p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
11513: p_request_id IN NUMBER, -- Comparison Request ID to move to main
11514: p_delivery_leg_id IN NUMBER,
11515: p_lane_id IN NUMBER DEFAULT NULL,

Line 11912: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,

11908: END Move_fc_temp_to_main;
11909:
11910:
11911: PROCEDURE Move_fc_temp_to_main (
11912: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,
11913: p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
11914: p_request_id IN NUMBER, -- Comparison Request ID to move to main
11915: p_trip_id IN NUMBER,
11916: p_lane_id IN NUMBER DEFAULT NULL,

Line 11966: l_init_msg_list VARCHAR2(30) :=FND_API.G_FALSE;

11962: l_update_rowid VARCHAR2(30);
11963: l_dleg_ids DBMS_UTILITY.NUMBER_ARRAY;
11964: l_delivery_id NUMBER;
11965: l_dleg_id NUMBER;
11966: l_init_msg_list VARCHAR2(30) :=FND_API.G_FALSE;
11967: l_freight_cost_id NUMBER;
11968: l_return_status VARCHAR2(1);
11969:
11970: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;

Line 12319: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,

12315: END Move_fc_temp_to_main;
12316:
12317:
12318: PROCEDURE delete_fc_temp (
12319: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,
12320: p_request_id IN NUMBER, -- Comparison Request ID to move to main
12321: x_return_status OUT NOCOPY VARCHAR2)
12322: IS
12323:

Line 12653: RAISE FND_API.G_EXC_ERROR;

12649: p_trip_id => p_trip_id,
12650: x_return_code => l_return_code);
12651:
12652: IF l_return_code = G_RC_ERROR THEN
12653: RAISE FND_API.G_EXC_ERROR;
12654: ELSIF (l_return_code = G_RC_REPRICE_NOT_REQUIRED
12655: OR l_return_code = G_RC_NOT_RATE_FREIGHT_TERM
12656: OR l_return_code = G_RC_NOT_RATE_MANIFESTING) THEN
12657: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 12670: RAISE FND_API.G_EXC_ERROR;

12666: p_delivery_id => p_delivery_id,
12667: x_return_code => l_return_code);
12668:
12669: IF l_return_code = G_RC_ERROR THEN
12670: RAISE FND_API.G_EXC_ERROR;
12671: ELSIF (l_return_code = G_RC_REPRICE_NOT_REQUIRED
12672: OR l_return_code = G_RC_NOT_RATE_FREIGHT_TERM
12673: OR l_return_code = G_RC_NOT_RATE_MANIFESTING) THEN
12674: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 12896: WHEN FND_API.G_EXC_ERROR THEN

12892: EXCEPTION
12893: WHEN g_finished_warning THEN
12894: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
12895: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_compare_pvt');
12896: WHEN FND_API.G_EXC_ERROR THEN
12897: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
12898: FTE_FREIGHT_PRICING_UTIL.set_exception('shipment_price_compare_pvt',FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
12899: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_compare_pvt');
12900: WHEN FTE_FREIGHT_PRICING_UTIL.g_delivery_not_found THEN

Line 12898: FTE_FREIGHT_PRICING_UTIL.set_exception('shipment_price_compare_pvt',FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');

12894: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
12895: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_compare_pvt');
12896: WHEN FND_API.G_EXC_ERROR THEN
12897: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
12898: FTE_FREIGHT_PRICING_UTIL.set_exception('shipment_price_compare_pvt',FTE_FREIGHT_PRICING_UTIL.G_ERR,'FND_API.G_EXC_ERROR');
12899: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'shipment_price_compare_pvt');
12900: WHEN FTE_FREIGHT_PRICING_UTIL.g_delivery_not_found THEN
12901: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
12902: FTE_FREIGHT_PRICING_UTIL.set_exception('shipment_price_compare_pvt',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_delivery_not_found');

Line 12931: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,

12927: END shipment_price_compare_pvt;
12928:
12929:
12930: PROCEDURE FPA_total_commodity_weight(
12931: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,
12932: p_delivery_id IN NUMBER,
12933: x_total_comm_wt OUT NOCOPY NUMBER,
12934: x_wt_uom OUT NOCOPY VARCHAR2,
12935: x_return_status OUT NOCOPY VARCHAR2,

Line 13065: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,

13061: -- It returns PL/SQL tables (dense) of summary price in the same sequence as the input
13062: -- Calls shipment hierarchy flattening API
13063:
13064: PROCEDURE shipment_price_compare (
13065: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,
13066: p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
13067: p_delivery_id IN NUMBER,
13068: p_trip_id IN NUMBER,
13069: p_lane_sched_id_tab IN FTE_ID_TAB_TYPE, -- lane_ids or schedule_ids