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 8996: RAISE FND_API.G_EXC_ERROR;

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

Line 9014: RAISE FND_API.G_EXC_ERROR;

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

Line 9523: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

Line 9565: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,

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

Line 9584: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 9692: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 9702: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 9711: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 9720: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 9728: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 9734: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,

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

Line 10478: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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

Line 10479: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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

Line 10557: IF NOT FND_API.Compatible_API_Call

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

Line 10565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 10570: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 10806: p_init_msg_list => FND_API.G_FALSE,

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

Line 10808: p_commit => FND_API.G_FALSE,

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

Line 10835: p_encoded => FND_API.G_FALSE

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

Line 10860: p_encoded => FND_API.G_FALSE

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

Line 10949: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 10959: p_encoded => FND_API.G_FALSE

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

Line 10977: -- p_encoded => FND_API.G_FALSE

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

Line 10991: p_encoded => FND_API.G_FALSE

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

Line 11004: p_encoded => FND_API.G_FALSE

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

Line 11017: p_encoded => FND_API.G_FALSE

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

Line 11029: p_encoded => FND_API.G_FALSE

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

Line 11040: p_encoded => FND_API.G_FALSE

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

Line 11045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 11052: p_encoded => FND_API.G_FALSE

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

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

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

Line 11065: p_encoded => FND_API.G_FALSE

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

Line 11510: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,

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

Line 11911: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,

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

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

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

Line 12318: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,

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

Line 12652: RAISE FND_API.G_EXC_ERROR;

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

Line 12669: RAISE FND_API.G_EXC_ERROR;

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

Line 12895: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

Line 12930: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,

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

Line 13064: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_true,

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