DBA Data[Home] [Help]

APPS.CSD_ESTIMATES_FROM_BOM_PVT dependencies on FND_API

Line 559: IF FND_API.to_boolean(p_init_msg_list) THEN

555: END IF;
556:
557: -- if message init is passed as yes initialize message stack.
558:
559: IF FND_API.to_boolean(p_init_msg_list) THEN
560: fnd_msg_pub.initialize;
561: END IF;
562:
563: -- set the return status as success status.

Line 565: x_return_status := FND_API.G_RET_STS_SUCCESS;

561: END IF;
562:
563: -- set the return status as success status.
564:
565: x_return_status := FND_API.G_RET_STS_SUCCESS;
566:
567: g_repair_line_id := p_repair_line_id; -- --bug#10187275,subhat
568: -- get the billing type id based on the repair_type and billing type
569:

Line 580: RAISE FND_API.G_EXC_ERROR;

576: EXCEPTION
577: WHEN NO_DATA_FOUND THEN
578: fnd_message.set_name('CSD','CSD_API_INV_TXN_BILLING_TYPE');
579: fnd_msg_pub.add;
580: RAISE FND_API.G_EXC_ERROR;
581: END;
582:
583: -- the required parameter validation is done in the java layer.
584: l_count := p_itemQty.COUNT;

Line 835: p_init_msg_list => FND_API.G_TRUE,

831: -- call estimate lines API.
832: csd_repair_estimate_pvt.create_repair_estimate_lines(
833: p_api_version => 1.0,
834: p_commit => 'T',
835: p_init_msg_list => FND_API.G_TRUE,
836: p_validation_level => 0,
837: x_estimate_line_rec => l_estimate_lines_rec,
838: x_estimate_line_id => l_estimate_line_id,
839: x_return_status => x_return_status,

Line 849: --RAISE FND_API.G_EXC_ERROR;

845: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
846: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'Error',
847: 'An error occured during execution of create_repair_estimate API'||x_msg_data);
848: END IF;
849: --RAISE FND_API.G_EXC_ERROR;
850: RETURN;
851: END IF;
852:
853: END LOOP;

Line 858: WHEN FND_API.G_EXC_ERROR THEN

854: x_return_status := 'S';
855: commit;
856:
857: EXCEPTION
858: WHEN FND_API.G_EXC_ERROR THEN
859: x_return_status := FND_API.G_RET_STS_ERROR;
860: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,
861: p_count => x_msg_count,
862: p_data => x_msg_data);

Line 859: x_return_status := FND_API.G_RET_STS_ERROR;

855: commit;
856:
857: EXCEPTION
858: WHEN FND_API.G_EXC_ERROR THEN
859: x_return_status := FND_API.G_RET_STS_ERROR;
860: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,
861: p_count => x_msg_count,
862: p_data => x_msg_data);
863:

Line 860: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,

856:
857: EXCEPTION
858: WHEN FND_API.G_EXC_ERROR THEN
859: x_return_status := FND_API.G_RET_STS_ERROR;
860: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,
861: p_count => x_msg_count,
862: p_data => x_msg_data);
863:
864: ROLLBACK;

Line 866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

862: p_data => x_msg_data);
863:
864: ROLLBACK;
865: WHEN OTHERS THEN
866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
867: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,
868: p_count => x_msg_count,
869: p_data => x_msg_data);
870: ROLLBACK;

Line 867: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,

863:
864: ROLLBACK;
865: WHEN OTHERS THEN
866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
867: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,
868: p_count => x_msg_count,
869: p_data => x_msg_data);
870: ROLLBACK;
871:

Line 960: RAISE FND_API.G_EXC_ERROR;

956: );
957:
958: if x_return_status <> 'S' THEN
959: l_item_cost := null;
960: RAISE FND_API.G_EXC_ERROR;
961: END IF;
962: RETURN l_item_cost;
963:
964: EXCEPTION

Line 965: WHEN FND_API.G_EXC_ERROR THEN

961: END IF;
962: RETURN l_item_cost;
963:
964: EXCEPTION
965: WHEN FND_API.G_EXC_ERROR THEN
966: RETURN l_item_cost;
967: RAISE FND_API.G_EXC_ERROR;
968: END get_item_cost;
969:

Line 967: RAISE FND_API.G_EXC_ERROR;

963:
964: EXCEPTION
965: WHEN FND_API.G_EXC_ERROR THEN
966: RETURN l_item_cost;
967: RAISE FND_API.G_EXC_ERROR;
968: END get_item_cost;
969:
970: FUNCTION get_selling_price(p_item_id IN number,
971: p_uom IN varchar2,

Line 1112: RAISE FND_API.G_EXC_ERROR;

1108: x_msg_count => x_msg_count,
1109: x_msg_data => x_msg_data);
1110: IF x_return_Status <> 'S' THEN
1111: l_selling_price := NULL;
1112: RAISE FND_API.G_EXC_ERROR;
1113: END IF;
1114:
1115: RETURN l_selling_price;
1116: END IF;

Line 1119: WHEN FND_API.G_EXC_ERROR THEN

1115: RETURN l_selling_price;
1116: END IF;
1117:
1118: EXCEPTION
1119: WHEN FND_API.G_EXC_ERROR THEN
1120: RETURN l_selling_price;
1121: RAISE FND_API.G_EXC_ERROR;
1122: when OTHERS then
1123: return l_selling_price;

Line 1121: RAISE FND_API.G_EXC_ERROR;

1117:
1118: EXCEPTION
1119: WHEN FND_API.G_EXC_ERROR THEN
1120: RETURN l_selling_price;
1121: RAISE FND_API.G_EXC_ERROR;
1122: when OTHERS then
1123: return l_selling_price;
1124: RAISE;
1125: END get_selling_price;

Line 1164: RAISE FND_API.G_EXC_ERROR;

1160: );
1161:
1162: IF x_return_status <> 'S' THEN
1163: l_discount_price := null;
1164: RAISE FND_API.G_EXC_ERROR;
1165: END if;
1166: RETURN l_discount_price;
1167:
1168: EXCEPTION

Line 1169: WHEN FND_API.G_EXC_ERROR THEN

1165: END if;
1166: RETURN l_discount_price;
1167:
1168: EXCEPTION
1169: WHEN FND_API.G_EXC_ERROR THEN
1170: RETURN l_discount_price;
1171: RAISE FND_API.G_EXC_ERROR;
1172: END get_discount_price;
1173:

Line 1171: RAISE FND_API.G_EXC_ERROR;

1167:
1168: EXCEPTION
1169: WHEN FND_API.G_EXC_ERROR THEN
1170: RETURN l_discount_price;
1171: RAISE FND_API.G_EXC_ERROR;
1172: END get_discount_price;
1173:
1174:
1175: END csd_estimates_from_bom_pvt;