DBA Data[Home] [Help]

APPS.CSD_ESTIMATES_FROM_BOM_PVT dependencies on FND_API

Line 557: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 563: x_return_status := FND_API.G_RET_STS_SUCCESS;

559: END IF;
560:
561: -- set the return status as success status.
562:
563: x_return_status := FND_API.G_RET_STS_SUCCESS;
564:
565:
566: -- get the billing type id based on the repair_type and billing type
567:

Line 578: RAISE FND_API.G_EXC_ERROR;

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

Line 824: p_init_msg_list => FND_API.G_TRUE,

820: -- call estimate lines API.
821: csd_repair_estimate_pvt.create_repair_estimate_lines(
822: p_api_version => 1.0,
823: p_commit => 'T',
824: p_init_msg_list => FND_API.G_TRUE,
825: p_validation_level => 0,
826: x_estimate_line_rec => l_estimate_lines_rec,
827: x_estimate_line_id => l_estimate_line_id,
828: x_return_status => x_return_status,

Line 838: --RAISE FND_API.G_EXC_ERROR;

834: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
835: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,lc_mod_name||'Error',
836: 'An error occured during execution of create_repair_estimate API'||x_msg_data);
837: END IF;
838: --RAISE FND_API.G_EXC_ERROR;
839: RETURN;
840: END IF;
841:
842: END LOOP;

Line 847: WHEN FND_API.G_EXC_ERROR THEN

843: x_return_status := 'S';
844: commit;
845:
846: EXCEPTION
847: WHEN FND_API.G_EXC_ERROR THEN
848: x_return_status := FND_API.G_RET_STS_ERROR;
849: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,
850: p_count => x_msg_count,
851: p_data => x_msg_data);

Line 848: x_return_status := FND_API.G_RET_STS_ERROR;

844: commit;
845:
846: EXCEPTION
847: WHEN FND_API.G_EXC_ERROR THEN
848: x_return_status := FND_API.G_RET_STS_ERROR;
849: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,
850: p_count => x_msg_count,
851: p_data => x_msg_data);
852:

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

845:
846: EXCEPTION
847: WHEN FND_API.G_EXC_ERROR THEN
848: x_return_status := FND_API.G_RET_STS_ERROR;
849: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,
850: p_count => x_msg_count,
851: p_data => x_msg_data);
852:
853: ROLLBACK;

Line 855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

851: p_data => x_msg_data);
852:
853: ROLLBACK;
854: WHEN OTHERS THEN
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
856: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,
857: p_count => x_msg_count,
858: p_data => x_msg_data);
859: ROLLBACK;

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

852:
853: ROLLBACK;
854: WHEN OTHERS THEN
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
856: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,
857: p_count => x_msg_count,
858: p_data => x_msg_data);
859: ROLLBACK;
860:

Line 949: RAISE FND_API.G_EXC_ERROR;

945: );
946:
947: if x_return_status <> 'S' THEN
948: l_item_cost := null;
949: RAISE FND_API.G_EXC_ERROR;
950: END IF;
951: RETURN l_item_cost;
952:
953: EXCEPTION

Line 954: WHEN FND_API.G_EXC_ERROR THEN

950: END IF;
951: RETURN l_item_cost;
952:
953: EXCEPTION
954: WHEN FND_API.G_EXC_ERROR THEN
955: RETURN l_item_cost;
956: RAISE FND_API.G_EXC_ERROR;
957: END get_item_cost;
958:

Line 956: RAISE FND_API.G_EXC_ERROR;

952:
953: EXCEPTION
954: WHEN FND_API.G_EXC_ERROR THEN
955: RETURN l_item_cost;
956: RAISE FND_API.G_EXC_ERROR;
957: END get_item_cost;
958:
959: FUNCTION get_selling_price(p_item_id IN number,
960: p_uom IN varchar2,

Line 1099: RAISE FND_API.G_EXC_ERROR;

1095: x_msg_count => x_msg_count,
1096: x_msg_data => x_msg_data);
1097: IF x_return_Status <> 'S' THEN
1098: l_selling_price := NULL;
1099: RAISE FND_API.G_EXC_ERROR;
1100: END IF;
1101:
1102: RETURN l_selling_price;
1103: END IF;

Line 1106: WHEN FND_API.G_EXC_ERROR THEN

1102: RETURN l_selling_price;
1103: END IF;
1104:
1105: EXCEPTION
1106: WHEN FND_API.G_EXC_ERROR THEN
1107: RETURN l_selling_price;
1108: RAISE FND_API.G_EXC_ERROR;
1109: when OTHERS then
1110: return l_selling_price;

Line 1108: RAISE FND_API.G_EXC_ERROR;

1104:
1105: EXCEPTION
1106: WHEN FND_API.G_EXC_ERROR THEN
1107: RETURN l_selling_price;
1108: RAISE FND_API.G_EXC_ERROR;
1109: when OTHERS then
1110: return l_selling_price;
1111: RAISE;
1112: END get_selling_price;

Line 1151: RAISE FND_API.G_EXC_ERROR;

1147: );
1148:
1149: IF x_return_status <> 'S' THEN
1150: l_discount_price := null;
1151: RAISE FND_API.G_EXC_ERROR;
1152: END if;
1153: RETURN l_discount_price;
1154:
1155: EXCEPTION

Line 1156: WHEN FND_API.G_EXC_ERROR THEN

1152: END if;
1153: RETURN l_discount_price;
1154:
1155: EXCEPTION
1156: WHEN FND_API.G_EXC_ERROR THEN
1157: RETURN l_discount_price;
1158: RAISE FND_API.G_EXC_ERROR;
1159: END get_discount_price;
1160:

Line 1158: RAISE FND_API.G_EXC_ERROR;

1154:
1155: EXCEPTION
1156: WHEN FND_API.G_EXC_ERROR THEN
1157: RETURN l_discount_price;
1158: RAISE FND_API.G_EXC_ERROR;
1159: END get_discount_price;
1160:
1161:
1162: END csd_estimates_from_bom_pvt;