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

Line 245: RAISE FND_API.G_EXC_ERROR;

241: END LOOP;
242: CLOSE c_patterns;
243:
244: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247:
248: fte_freight_pricing_util.unset_method(l_log_level,'load_rules');
249: EXCEPTION

Line 250: WHEN FND_API.G_EXC_ERROR THEN

246: END IF;
247:
248: fte_freight_pricing_util.unset_method(l_log_level,'load_rules');
249: EXCEPTION
250: WHEN FND_API.G_EXC_ERROR THEN
251: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
252: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
253: fte_freight_pricing_util.unset_method(l_log_level,'load_rules');
254: WHEN others THEN

Line 252: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');

248: fte_freight_pricing_util.unset_method(l_log_level,'load_rules');
249: EXCEPTION
250: WHEN FND_API.G_EXC_ERROR THEN
251: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
252: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
253: fte_freight_pricing_util.unset_method(l_log_level,'load_rules');
254: WHEN others THEN
255: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
256: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');

Line 4665: raise FND_API.G_EXC_ERROR;

4661: CLOSE get_uom_for_each;
4662:
4663: IF l_uom_ea is null THEN
4664: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'uom for each is null');
4665: raise FND_API.G_EXC_ERROR;
4666: END IF;
4667:
4668: -- Modified for 12i for Multi currency support.
4669: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'p_currency_code '|| p_currency_code);

Line 4683: raise FND_API.G_EXC_ERROR;

4679:
4680: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS and
4681: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4682: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'get currency code failed');
4683: raise FND_API.G_EXC_ERROR;
4684: END IF;
4685:
4686: -- group top level rows by container type into pricing engine rows
4687: l_engine_row_count := 0;

Line 4694: raise FND_API.G_EXC_ERROR;

4690: IF (i is not null) THEN
4691: LOOP
4692: IF ((p_top_level_rows(i).container_flag IS NULL) OR (p_top_level_rows(i).container_flag = 'N')) THEN
4693: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'top level loose item cannot be rated in rate basis CONTAINER_ALL');
4694: raise FND_API.G_EXC_ERROR;
4695: END IF;
4696: IF p_top_level_rows(i).container_type_code is null THEN
4697: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'top level container type code is null, cannot be rated in rate basis CONTAINER_ALL');
4698: raise FND_API.G_EXC_ERROR;

Line 4698: raise FND_API.G_EXC_ERROR;

4694: raise FND_API.G_EXC_ERROR;
4695: END IF;
4696: IF p_top_level_rows(i).container_type_code is null THEN
4697: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'top level container type code is null, cannot be rated in rate basis CONTAINER_ALL');
4698: raise FND_API.G_EXC_ERROR;
4699: END IF;
4700:
4701: IF l_engine_row_count = 0 THEN
4702: l_engine_row_count := 1;

Line 4747: raise FND_API.G_EXC_ERROR;

4743: x_return_status => l_return_status);
4744:
4745: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4746: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4747: raise FND_API.G_EXC_ERROR;
4748: END IF;
4749:
4750: -- set up data structure to call QP
4751: -- call QP

Line 4804: raise FND_API.G_EXC_ERROR;

4800:
4801: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');
4802: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4803: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4804: raise FND_API.G_EXC_ERROR;
4805: END IF;
4806:
4807: --l_set_num := 1;
4808: i := l_pricing_engine_rows.FIRST;

Line 4818: raise FND_API.G_EXC_ERROR;

4814:
4815: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);
4816: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4817: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4818: raise FND_API.G_EXC_ERROR;
4819: END IF;
4820:
4821: fte_qp_engine.prepare_qp_line_qualifiers(
4822: p_event_num => l_event_num,

Line 4830: raise FND_API.G_EXC_ERROR;

4826:
4827: fte_freight_pricing_util.set_location(p_loc=>'after create qp line qualifiers. i='||i);
4828: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4829: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4830: raise FND_API.G_EXC_ERROR;
4831: END IF;
4832:
4833: fte_qp_engine.prepare_qp_line_attributes (
4834: p_event_num => l_event_num,

Line 4842: raise FND_API.G_EXC_ERROR;

4838:
4839: fte_freight_pricing_util.set_location(p_loc=>'after create qp line attributes. i='||i);
4840: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4841: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4842: raise FND_API.G_EXC_ERROR;
4843: END IF;
4844:
4845: EXIT WHEN i >= l_pricing_engine_rows.LAST;
4846: i := l_pricing_engine_rows.NEXT(i);

Line 4858: raise FND_API.G_EXC_ERROR;

4854:
4855: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 1');
4856: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4857: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4858: raise FND_API.G_EXC_ERROR;
4859: END IF;
4860:
4861: --check for errors in the output
4862: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);

Line 4866: raise FND_API.G_EXC_ERROR;

4862: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
4863: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
4864: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4865: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4866: raise FND_API.G_EXC_ERROR;
4867: END IF;
4868:
4869: fte_qp_engine.print_qp_output();
4870:

Line 4881: raise FND_API.G_EXC_ERROR;

4877:
4878: fte_freight_pricing_util.set_location(p_loc=>'after apply_min_charge ');
4879: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4880: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4881: raise FND_API.G_EXC_ERROR;
4882: END IF;
4883: END IF;
4884:
4885: -- create request lines for the next event and call qp engine

Line 4893: raise FND_API.G_EXC_ERROR;

4889:
4890: fte_freight_pricing_util.set_location(p_loc=>'after prepare_next_event_request');
4891: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4892: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4893: raise FND_API.G_EXC_ERROR;
4894: END IF;
4895:
4896: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => l_qp_output_line_rows,
4897: x_qp_output_detail_rows => l_qp_output_detail_rows,

Line 4903: raise FND_API.G_EXC_ERROR;

4899:
4900: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 2');
4901: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4902: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4903: raise FND_API.G_EXC_ERROR;
4904: END IF;
4905:
4906: --check for errors in the output
4907: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);

Line 4911: raise FND_API.G_EXC_ERROR;

4907: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
4908: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
4909: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4910: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4911: raise FND_API.G_EXC_ERROR;
4912: END IF;
4913:
4914: fte_qp_engine.print_qp_output();
4915:

Line 4962: raise FND_API.G_EXC_ERROR;

4958: x_freight_cost_type_id => l_fc_charge_rec.freight_cost_type_id,
4959: x_return_status => l_return_status);
4960: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4961: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4962: raise FND_API.G_EXC_ERROR;
4963: END IF;
4964: ELSE -- l_qp_output_detail_rows(j).list_line_type_code = 'DIS'
4965: l_line_discount_amount := l_line_discount_amount + l_fc_charge_rec.total_amount;
4966:

Line 4976: raise FND_API.G_EXC_ERROR;

4972: x_freight_cost_type_id => l_fc_charge_rec.freight_cost_type_id,
4973: x_return_status => l_return_status);
4974: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4975: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4976: raise FND_API.G_EXC_ERROR;
4977: END IF;
4978: END IF;
4979:
4980: --distribute SUR/DIS into top level containers

Line 5058: raise FND_API.G_EXC_ERROR;

5054: x_freight_cost_type_id => l_fc_rec.freight_cost_type_id,
5055: x_return_status => l_return_status);
5056: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5057: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5058: raise FND_API.G_EXC_ERROR;
5059: END IF;
5060:
5061: l_summary_amount := l_summary_amount + l_fc_rec.total_amount;
5062:

Line 5152: raise FND_API.G_EXC_ERROR;

5148: x_freight_cost_type_id => l_freight_cost_type_id,
5149: x_return_status => l_return_status);
5150: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5151: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5152: raise FND_API.G_EXC_ERROR;
5153: END IF;
5154:
5155: IF p_save_flag = 'M' THEN
5156:

Line 5210: WHEN FND_API.G_EXC_ERROR THEN

5206: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
5207:
5208: EXCEPTION
5209:
5210: WHEN FND_API.G_EXC_ERROR THEN
5211: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5212: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
5213: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
5214: WHEN others THEN

Line 5212: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');

5208: EXCEPTION
5209:
5210: WHEN FND_API.G_EXC_ERROR THEN
5211: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5212: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
5213: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
5214: WHEN others THEN
5215: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5216: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');

Line 5253: raise FND_API.G_EXC_ERROR;

5249: IF (((p_top_level_rows(i).container_flag = 'Y') OR (p_top_level_rows(i).container_flag = 'C')) and (p_top_level_rows(i).wdd_tare_weight > 0)) THEN
5250:
5251: IF p_top_level_rows(i).wdd_weight_uom_code is null THEN
5252: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'top level container tare weight > 0 and weight uom is null');
5253: raise FND_API.G_EXC_ERROR;
5254: END IF;
5255:
5256: IF x_weight_uom is NULL THEN
5257: x_weight_uom := p_top_level_rows(i).wdd_weight_uom_code;

Line 5270: raise FND_API.G_EXC_ERROR;

5266: p_top_level_rows(i).wdd_tare_weight,
5267: NULL,0);
5268: IF l_tmp <= 0 THEN
5269: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'WSH_WV_UTILS.convert_uom return 0');
5270: raise FND_API.G_EXC_ERROR;
5271: ELSE
5272: x_total_container_weight := x_total_container_weight + l_tmp;
5273: END IF;
5274: END IF;

Line 5286: WHEN FND_API.G_EXC_ERROR THEN

5282:
5283: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
5284:
5285: EXCEPTION
5286: WHEN FND_API.G_EXC_ERROR THEN
5287: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5288: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
5289: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
5290: WHEN others THEN

Line 5288: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');

5284:
5285: EXCEPTION
5286: WHEN FND_API.G_EXC_ERROR THEN
5287: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5288: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
5289: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
5290: WHEN others THEN
5291: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5292: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');

Line 5352: raise FND_API.G_EXC_ERROR;

5348: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_total_container_weight='||l_total_container_weight);
5349: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_container_weight_uom='||l_container_weight_uom);
5350:
5351: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
5352: raise FND_API.G_EXC_ERROR;
5353: END IF;
5354:
5355: IF l_total_container_weight <= 0 THEN
5356: raise g_finished_success;

Line 5386: raise FND_API.G_EXC_ERROR;

5382:
5383: IF l_segment2 is null or l_segment2 < 0 THEN
5384: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'cannot get valid numeric segment2 from category id '
5385: ||x_pricing_engine_rows(i).category_id);
5386: raise FND_API.G_EXC_ERROR;
5387: END IF;
5388:
5389: IF l_lowest_fc_segment2 = -1 THEN
5390: l_lowest_fc_segment2 := l_segment2;

Line 5475: WHEN FND_API.G_EXC_ERROR THEN

5471:
5472: EXCEPTION
5473: WHEN g_finished_success THEN
5474: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
5475: WHEN FND_API.G_EXC_ERROR THEN
5476: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5477: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
5478: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
5479: WHEN others THEN

Line 5477: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');

5473: WHEN g_finished_success THEN
5474: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
5475: WHEN FND_API.G_EXC_ERROR THEN
5476: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5477: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
5478: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
5479: WHEN others THEN
5480: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5481: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');

Line 5580: raise FND_API.G_EXC_ERROR;

5576: x_return_status => l_return_status );
5577: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS and
5578: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5579: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'get currency code failed');
5580: raise FND_API.G_EXC_ERROR;
5581: END IF;
5582: END IF;
5583:
5584: --4294663

Line 5646: raise FND_API.G_EXC_ERROR;

5642: 'top level detail id: '||p_top_level_rows(i).content_id
5643: ||' wdd_gross_weight: '||p_top_level_rows(i).wdd_gross_weight
5644: ||' '||p_top_level_rows(i).wdd_weight_uom_code);
5645: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'top level detail gross weight invalid');
5646: raise FND_API.G_EXC_ERROR;
5647: END IF;
5648:
5649: FTE_FREIGHT_PRICING.g_rolledup_lines(i).delivery_detail_id := p_top_level_rows(i).content_id;
5650: FTE_FREIGHT_PRICING.g_rolledup_lines(i).line_quantity := p_top_level_rows(i).wdd_gross_weight;

Line 5668: raise FND_API.G_EXC_ERROR;

5664: FTE_FREIGHT_PRICING.g_rolledup_lines(i).line_quantity,
5665: NULL,0);
5666: IF l_tmp <= 0 THEN
5667: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'WSH_WV_UTILS.convert_uom return 0');
5668: raise FND_API.G_EXC_ERROR;
5669: ELSE
5670: FTE_FREIGHT_PRICING.g_rolledup_lines(i).line_quantity := l_tmp;
5671: FTE_FREIGHT_PRICING.g_rolledup_lines(i).line_uom := l_pricing_engine_rows(1).line_uom;
5672: l_pricing_engine_rows(1).line_quantity :=

Line 5738: raise FND_API.G_EXC_ERROR;

5734:
5735: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');
5736: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5737: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5738: raise FND_API.G_EXC_ERROR;
5739: END IF;
5740:
5741: --l_set_num := 1;
5742: i := l_pricing_engine_rows.FIRST;

Line 5752: raise FND_API.G_EXC_ERROR;

5748:
5749: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);
5750: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5751: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5752: raise FND_API.G_EXC_ERROR;
5753: END IF;
5754:
5755: fte_qp_engine.prepare_qp_line_qualifiers(
5756: p_event_num => l_event_num,

Line 5764: raise FND_API.G_EXC_ERROR;

5760:
5761: fte_freight_pricing_util.set_location(p_loc=>'after create qp line qualifiers. i='||i);
5762: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5763: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5764: raise FND_API.G_EXC_ERROR;
5765: END IF;
5766:
5767: fte_qp_engine.prepare_qp_line_attributes (
5768: p_event_num => l_event_num,

Line 5776: raise FND_API.G_EXC_ERROR;

5772:
5773: fte_freight_pricing_util.set_location(p_loc=>'after create qp line attributes. i='||i);
5774: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5775: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5776: raise FND_API.G_EXC_ERROR;
5777: END IF;
5778:
5779: EXIT WHEN i >= l_pricing_engine_rows.LAST;
5780: i := l_pricing_engine_rows.NEXT(i);

Line 5792: raise FND_API.G_EXC_ERROR;

5788:
5789: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 1');
5790: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5791: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5792: raise FND_API.G_EXC_ERROR;
5793: END IF;
5794:
5795: --check for errors in the output
5796: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);

Line 5800: raise FND_API.G_EXC_ERROR;

5796: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
5797: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
5798: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5799: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5800: raise FND_API.G_EXC_ERROR;
5801: END IF;
5802:
5803: fte_qp_engine.print_qp_output();
5804:

Line 5815: raise FND_API.G_EXC_ERROR;

5811:
5812: fte_freight_pricing_util.set_location(p_loc=>'after apply_min_charge ');
5813: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5814: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5815: raise FND_API.G_EXC_ERROR;
5816: END IF;
5817: END IF;
5818:
5819: -- create request lines for the next event and call qp engine

Line 5827: raise FND_API.G_EXC_ERROR;

5823:
5824: fte_freight_pricing_util.set_location(p_loc=>'after prepare_next_event_request');
5825: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5826: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5827: raise FND_API.G_EXC_ERROR;
5828: END IF;
5829:
5830: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => l_qp_output_line_rows,
5831: x_qp_output_detail_rows => l_qp_output_detail_rows,

Line 5837: raise FND_API.G_EXC_ERROR;

5833:
5834: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 2');
5835: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5836: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5837: raise FND_API.G_EXC_ERROR;
5838: END IF;
5839:
5840: --check for errors in the output
5841: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);

Line 5845: raise FND_API.G_EXC_ERROR;

5841: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
5842: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
5843: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5844: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5845: raise FND_API.G_EXC_ERROR;
5846: END IF;
5847:
5848: fte_qp_engine.print_qp_output();
5849:

Line 5894: raise FND_API.G_EXC_ERROR;

5890: x_freight_cost_type_id => l_fc_charge_rec.freight_cost_type_id,
5891: x_return_status => l_return_status);
5892: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5893: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5894: raise FND_API.G_EXC_ERROR;
5895: END IF;
5896: ELSE -- l_qp_output_detail_rows(j).list_line_type_code = 'DIS'
5897: l_line_discount_amount := l_line_discount_amount + l_fc_charge_rec.total_amount;
5898:

Line 5908: raise FND_API.G_EXC_ERROR;

5904: x_freight_cost_type_id => l_fc_charge_rec.freight_cost_type_id,
5905: x_return_status => l_return_status);
5906: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5907: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5908: raise FND_API.G_EXC_ERROR;
5909: END IF;
5910: END IF;
5911:
5912: --distribute SUR/DIS into top level details

Line 5985: raise FND_API.G_EXC_ERROR;

5981: x_freight_cost_type_id => l_fc_rec.freight_cost_type_id,
5982: x_return_status => l_return_status);
5983: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5984: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5985: raise FND_API.G_EXC_ERROR;
5986: END IF;
5987:
5988: l_summary_amount := l_summary_amount + l_fc_rec.total_amount;
5989:

Line 6077: raise FND_API.G_EXC_ERROR;

6073: x_freight_cost_type_id => l_freight_cost_type_id,
6074: x_return_status => l_return_status);
6075: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
6076: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
6077: raise FND_API.G_EXC_ERROR;
6078: END IF;
6079:
6080:
6081: l_leg_id_array(l_delivery_id):=l_leg_id;

Line 6153: WHEN FND_API.G_EXC_ERROR THEN

6149:
6150: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
6151:
6152: EXCEPTION
6153: WHEN FND_API.G_EXC_ERROR THEN
6154: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6155: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
6156: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
6157: WHEN others THEN

Line 6155: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');

6151:
6152: EXCEPTION
6153: WHEN FND_API.G_EXC_ERROR THEN
6154: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6155: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
6156: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
6157: WHEN others THEN
6158: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6159: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');