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

Line 29: x_return_status := fnd_api.g_ret_sts_success;

25: x_rec_count := 0;
26: x_msg_data := '';
27: Fnd_Msg_Pub.initialize;
28:
29: x_return_status := fnd_api.g_ret_sts_success;
30:
31: IF p_status_change = 'CANCELLED' THEN
32: BEGIN
33: SELECT DISTINCT 'Y' INTO l_flag

Line 208: RAISE FND_API.G_EXC_ERROR;

204: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
205: fnd_message.set_name('DPP', 'DPP_TXN_NOT_CANCELLED');
206: fnd_msg_pub.add;
207: END IF;
208: RAISE FND_API.G_EXC_ERROR;
209: END IF;
210:
211: ELSIF p_status_change = 'CLOSED' THEN
212: BEGIN

Line 377: RAISE FND_API.G_EXC_ERROR;

373: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
374: fnd_message.set_name('DPP', 'DPP_TXN_NOT_CLOSED');
375: fnd_msg_pub.add;
376: END IF;
377: RAISE FND_API.G_EXC_ERROR;
378: END IF;
379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381: x_return_status := FND_API.G_RET_STS_ERROR;

Line 380: WHEN FND_API.G_EXC_ERROR THEN

376: END IF;
377: RAISE FND_API.G_EXC_ERROR;
378: END IF;
379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381: x_return_status := FND_API.G_RET_STS_ERROR;
382:
383: WHEN OTHERS THEN
384: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 381: x_return_status := FND_API.G_RET_STS_ERROR;

377: RAISE FND_API.G_EXC_ERROR;
378: END IF;
379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381: x_return_status := FND_API.G_RET_STS_ERROR;
382:
383: WHEN OTHERS THEN
384: x_return_status := fnd_api.g_ret_sts_unexp_error;
385:

Line 384: x_return_status := fnd_api.g_ret_sts_unexp_error;

380: WHEN FND_API.G_EXC_ERROR THEN
381: x_return_status := FND_API.G_RET_STS_ERROR;
382:
383: WHEN OTHERS THEN
384: x_return_status := fnd_api.g_ret_sts_unexp_error;
385:
386: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
387: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
388: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.check_txnclose');

Line 434: x_return_status := fnd_api.g_ret_sts_success;

430:
431: CLOSE get_vendor_csr;
432: x_rec_count := l_vendor_tbl.COUNT;
433: x_vendor_tbl := l_vendor_tbl;
434: x_return_status := fnd_api.g_ret_sts_success;
435:
436: IF DPP_DEBUG_HIGH_ON THEN
437: DPP_UTILITY_PVT.debug_message ('search_vendors(): x_return_status: ' || x_return_status);
438: END IF;

Line 442: x_return_status := fnd_api.g_ret_sts_unexp_error;

438: END IF;
439:
440: EXCEPTION
441: WHEN OTHERS THEN
442: x_return_status := fnd_api.g_ret_sts_unexp_error;
443:
444: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
445: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
446: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendors');

Line 504: RAISE FND_API.G_EXC_ERROR;

500: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
501: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_VENDORID');
502: fnd_msg_pub.add;
503: END IF;
504: RAISE FND_API.G_EXC_ERROR;
505:
506: ELSIF l_search_criteria_tbl(3).search_text IS NULL THEN
507: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
508: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_ORGID');

Line 511: RAISE FND_API.G_EXC_ERROR;

507: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
508: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_ORGID');
509: fnd_msg_pub.add;
510: END IF;
511: RAISE FND_API.G_EXC_ERROR;
512: END IF;
513:
514: OPEN get_vendor_sites_csr(NVL(l_search_criteria_tbl(1).search_criteria,'VENDOR_ID'), l_search_criteria_tbl(1).search_text,
515: NVL(l_search_criteria_tbl(2).search_criteria,'VENDOR_SITE_CODE'), NVL(l_search_criteria_tbl(2).search_text,'%'),

Line 526: x_return_status := fnd_api.g_ret_sts_success;

522: CLOSE get_vendor_sites_csr;
523:
524: x_rec_count := l_vendor_site_tbl.COUNT;
525: x_vendor_site_tbl := l_vendor_site_tbl;
526: x_return_status := fnd_api.g_ret_sts_success;
527: IF DPP_DEBUG_HIGH_ON THEN
528: DPP_UTILITY_PVT.debug_message ('search_vendor_sites(): x_return_status: ' || x_return_status);
529: END IF;
530:

Line 533: WHEN FND_API.G_EXC_ERROR THEN

529: END IF;
530:
531: EXCEPTION
532:
533: WHEN FND_API.G_EXC_ERROR THEN
534: x_return_status := FND_API.G_RET_STS_ERROR;
535:
536: WHEN OTHERS THEN
537: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 534: x_return_status := FND_API.G_RET_STS_ERROR;

530:
531: EXCEPTION
532:
533: WHEN FND_API.G_EXC_ERROR THEN
534: x_return_status := FND_API.G_RET_STS_ERROR;
535:
536: WHEN OTHERS THEN
537: x_return_status := fnd_api.g_ret_sts_unexp_error;
538:

Line 537: x_return_status := fnd_api.g_ret_sts_unexp_error;

533: WHEN FND_API.G_EXC_ERROR THEN
534: x_return_status := FND_API.G_RET_STS_ERROR;
535:
536: WHEN OTHERS THEN
537: x_return_status := fnd_api.g_ret_sts_unexp_error;
538:
539: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
540: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
541: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendor_sites');

Line 596: RAISE fnd_api.g_exc_error;

592: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_VENDORSITEID');
593: fnd_msg_pub.add;
594: END IF;
595:
596: RAISE fnd_api.g_exc_error;
597: END IF;
598:
599: OPEN get_vendor_contacts_csr(NVL(l_search_criteria_tbl(1).search_criteria,'VENDOR_SITE_ID'), l_search_criteria_tbl(1).search_text,
600: NVL(l_search_criteria_tbl(2).search_criteria,'FIRST_NAME'), NVL(l_search_criteria_tbl(2).search_text,'%'));

Line 609: x_return_status := fnd_api.g_ret_sts_success;

605: CLOSE get_vendor_contacts_csr;
606:
607: x_rec_count := l_vendor_contact_tbl.COUNT;
608: x_vendor_contact_tbl := l_vendor_contact_tbl;
609: x_return_status := fnd_api.g_ret_sts_success;
610: IF DPP_DEBUG_HIGH_ON THEN
611: DPP_UTILITY_PVT.debug_message ('search_vendor_contacts(): x_return_status: ' || x_return_status);
612: END IF;
613:

Line 615: WHEN FND_API.G_EXC_ERROR THEN

611: DPP_UTILITY_PVT.debug_message ('search_vendor_contacts(): x_return_status: ' || x_return_status);
612: END IF;
613:
614: EXCEPTION
615: WHEN FND_API.G_EXC_ERROR THEN
616: x_return_status := FND_API.G_RET_STS_ERROR;
617:
618: WHEN OTHERS THEN
619: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 616: x_return_status := FND_API.G_RET_STS_ERROR;

612: END IF;
613:
614: EXCEPTION
615: WHEN FND_API.G_EXC_ERROR THEN
616: x_return_status := FND_API.G_RET_STS_ERROR;
617:
618: WHEN OTHERS THEN
619: x_return_status := fnd_api.g_ret_sts_unexp_error;
620:

Line 619: x_return_status := fnd_api.g_ret_sts_unexp_error;

615: WHEN FND_API.G_EXC_ERROR THEN
616: x_return_status := FND_API.G_RET_STS_ERROR;
617:
618: WHEN OTHERS THEN
619: x_return_status := fnd_api.g_ret_sts_unexp_error;
620:
621: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
622: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
623: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_vendor_contacts');

Line 733: RAISE fnd_api.g_exc_error;

729: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_ORGID');
730: fnd_msg_pub.add;
731: END IF;
732:
733: RAISE fnd_api.g_exc_error;
734: ELSIF l_search_criteria_tbl(3).search_text IS NULL THEN
735: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
736: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_VENDORID');
737: fnd_msg_pub.add;

Line 739: RAISE fnd_api.g_exc_error;

735: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
736: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_VENDORID');
737: fnd_msg_pub.add;
738: END IF;
739: RAISE fnd_api.g_exc_error;
740: ELSIF l_search_criteria_tbl(4).search_text IS NULL THEN
741: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
742: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_VENDORSITEID');
743: fnd_msg_pub.add;

Line 745: RAISE fnd_api.g_exc_error;

741: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
742: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_VENDORSITEID');
743: fnd_msg_pub.add;
744: END IF;
745: RAISE fnd_api.g_exc_error;
746: END IF;
747:
748: BEGIN
749: SELECT supp_trade_profile_id

Line 825: x_return_status := fnd_api.g_ret_sts_success;

821: END IF;
822:
823: x_rec_count := l_itemnum_tbl.COUNT;
824: x_item_tbl := l_itemnum_tbl;
825: x_return_status := fnd_api.g_ret_sts_success;
826: IF DPP_DEBUG_HIGH_ON THEN
827: DPP_UTILITY_PVT.debug_message ('search_items(): x_return_status: ' || x_return_status);
828: END IF;
829:

Line 832: WHEN FND_API.G_EXC_ERROR THEN

828: END IF;
829:
830: EXCEPTION
831:
832: WHEN FND_API.G_EXC_ERROR THEN
833: x_return_status := FND_API.G_RET_STS_ERROR;
834:
835: WHEN OTHERS THEN
836: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 833: x_return_status := FND_API.G_RET_STS_ERROR;

829:
830: EXCEPTION
831:
832: WHEN FND_API.G_EXC_ERROR THEN
833: x_return_status := FND_API.G_RET_STS_ERROR;
834:
835: WHEN OTHERS THEN
836: x_return_status := fnd_api.g_ret_sts_unexp_error;
837:

Line 836: x_return_status := fnd_api.g_ret_sts_unexp_error;

832: WHEN FND_API.G_EXC_ERROR THEN
833: x_return_status := FND_API.G_RET_STS_ERROR;
834:
835: WHEN OTHERS THEN
836: x_return_status := fnd_api.g_ret_sts_unexp_error;
837:
838: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
839: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
840: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_items');

Line 899: RAISE fnd_api.g_exc_error;

895: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_TRANSACTIONID');
896: fnd_msg_pub.add;
897: END IF;
898:
899: RAISE fnd_api.g_exc_error;
900: ELSIF l_search_criteria_tbl(3).search_text IS NULL THEN
901: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
902: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_CUST_ACCT_ID');
903: fnd_msg_pub.add;

Line 905: RAISE fnd_api.g_exc_error;

901: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
902: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_CUST_ACCT_ID');
903: fnd_msg_pub.add;
904: END IF;
905: RAISE fnd_api.g_exc_error;
906: END IF;
907:
908: OPEN get_customer_item_csr(NVL(l_search_criteria_tbl(1).search_criteria,'TRANSACTION_HEADER_ID'),
909: l_search_criteria_tbl(1).search_text,

Line 923: x_return_status := fnd_api.g_ret_sts_success;

919: CLOSE get_customer_item_csr;
920:
921: x_rec_count := l_customer_item_tbl.COUNT;
922: x_customer_item_tbl := l_customer_item_tbl;
923: x_return_status := fnd_api.g_ret_sts_success;
924: IF DPP_DEBUG_HIGH_ON THEN
925: DPP_UTILITY_PVT.debug_message ('search_customer_items(): x_return_status: ' || x_return_status);
926: END IF;
927:

Line 929: WHEN FND_API.G_EXC_ERROR THEN

925: DPP_UTILITY_PVT.debug_message ('search_customer_items(): x_return_status: ' || x_return_status);
926: END IF;
927:
928: EXCEPTION
929: WHEN FND_API.G_EXC_ERROR THEN
930: x_return_status := FND_API.G_RET_STS_ERROR;
931:
932: WHEN OTHERS THEN
933: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 930: x_return_status := FND_API.G_RET_STS_ERROR;

926: END IF;
927:
928: EXCEPTION
929: WHEN FND_API.G_EXC_ERROR THEN
930: x_return_status := FND_API.G_RET_STS_ERROR;
931:
932: WHEN OTHERS THEN
933: x_return_status := fnd_api.g_ret_sts_unexp_error;
934:

Line 933: x_return_status := fnd_api.g_ret_sts_unexp_error;

929: WHEN FND_API.G_EXC_ERROR THEN
930: x_return_status := FND_API.G_RET_STS_ERROR;
931:
932: WHEN OTHERS THEN
933: x_return_status := fnd_api.g_ret_sts_unexp_error;
934:
935: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
936: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
937: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customer_items');

Line 975: x_return_status := fnd_api.g_ret_sts_success;

971: l_warehouse_tbl warehouse_tbl_type;
972:
973: BEGIN
974: x_rec_count := 0;
975: x_return_status := fnd_api.g_ret_sts_success;
976: IF l_search_criteria_tbl(2).search_text IS NULL THEN
977: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
978: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_ORGID');
979: fnd_msg_pub.add;

Line 982: RAISE FND_API.G_EXC_ERROR;

978: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_ORGID');
979: fnd_msg_pub.add;
980: END IF;
981:
982: RAISE FND_API.G_EXC_ERROR;
983: END IF;
984: OPEN get_warehouse_csr(NVL(l_search_criteria_tbl(1).search_criteria,'WAREHOUSE_CODE'),
985: NVL(l_search_criteria_tbl(1).search_text,'%'),
986: NVL(l_search_criteria_tbl(2).search_criteria,'ORG_ID'),

Line 1003: WHEN FND_API.G_EXC_ERROR THEN

999: DPP_UTILITY_PVT.debug_message ('search_warehouses(): x_return_status: ' || x_return_status);
1000: END IF;
1001:
1002: EXCEPTION
1003: WHEN FND_API.G_EXC_ERROR THEN
1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005:
1006: WHEN OTHERS THEN
1007: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1004: x_return_status := FND_API.G_RET_STS_ERROR;

1000: END IF;
1001:
1002: EXCEPTION
1003: WHEN FND_API.G_EXC_ERROR THEN
1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005:
1006: WHEN OTHERS THEN
1007: x_return_status := fnd_api.g_ret_sts_unexp_error;
1008:

Line 1007: x_return_status := fnd_api.g_ret_sts_unexp_error;

1003: WHEN FND_API.G_EXC_ERROR THEN
1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005:
1006: WHEN OTHERS THEN
1007: x_return_status := fnd_api.g_ret_sts_unexp_error;
1008:
1009: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1010: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1011: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_warehouses');

Line 1161: x_return_status := FND_API.G_RET_STS_ERROR;

1157: AND rownum = 1;
1158: EXCEPTION
1159: WHEN OTHERS THEN
1160: DPP_UTILITY_PVT.debug_message ('Error in fetching primary UOM: ' || SQLERRM);
1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: END;
1163:
1164: l_covered_inv_tbl(i).uom_code := l_primary_uom_code; -- Default to Primary UOM
1165: END IF;

Line 1171: x_return_status := fnd_api.g_ret_sts_success;

1167: END LOOP;
1168:
1169: p_covered_inv_tbl := l_covered_inv_tbl;
1170:
1171: x_return_status := fnd_api.g_ret_sts_success;
1172:
1173: IF DPP_DEBUG_HIGH_ON THEN
1174: DPP_UTILITY_PVT.debug_message ('get_coveredinventory(): x_return_status: ' || x_return_status);
1175: END IF;

Line 1180: x_return_status := fnd_api.g_ret_sts_unexp_error;

1176:
1177: EXCEPTION
1178:
1179: WHEN OTHERS THEN
1180: x_return_status := fnd_api.g_ret_sts_unexp_error;
1181:
1182: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1183: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1184: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_CoveredInventory');

Line 1289: x_return_status := fnd_api.g_ret_sts_success;

1285:
1286: BEGIN
1287:
1288: x_rec_count := 0;
1289: x_return_status := fnd_api.g_ret_sts_success;
1290: IF l_hdr_rec.org_id IS NULL THEN
1291: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1292: FND_MESSAGE.set_token('ID', 'Org ID');
1293: FND_MSG_PUB.add;

Line 1294: RAISE FND_API.G_EXC_ERROR;

1290: IF l_hdr_rec.org_id IS NULL THEN
1291: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1292: FND_MESSAGE.set_token('ID', 'Org ID');
1293: FND_MSG_PUB.add;
1294: RAISE FND_API.G_EXC_ERROR;
1295: ELSIF l_hdr_rec.effective_start_date IS NULL THEN
1296: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1297: FND_MESSAGE.set_token('ID', 'Effective Start Date');
1298: FND_MSG_PUB.add;

Line 1299: RAISE FND_API.G_EXC_ERROR;

1295: ELSIF l_hdr_rec.effective_start_date IS NULL THEN
1296: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1297: FND_MESSAGE.set_token('ID', 'Effective Start Date');
1298: FND_MSG_PUB.add;
1299: RAISE FND_API.G_EXC_ERROR;
1300: ELSIF l_hdr_rec.effective_end_date IS NULL THEN
1301: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1302: FND_MESSAGE.set_token('ID', 'Effective End Date');
1303: FND_MSG_PUB.add;

Line 1304: RAISE FND_API.G_EXC_ERROR;

1300: ELSIF l_hdr_rec.effective_end_date IS NULL THEN
1301: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1302: FND_MESSAGE.set_token('ID', 'Effective End Date');
1303: FND_MSG_PUB.add;
1304: RAISE FND_API.G_EXC_ERROR;
1305: END IF;
1306:
1307: FOR i in l_inventorydetails_tbl.FIRST..l_inventorydetails_tbl.LAST
1308: LOOP

Line 1314: x_return_status := FND_API.G_RET_STS_ERROR;

1310: IF l_inventorydetails_tbl(i).Inventory_Item_ID IS NULL THEN
1311: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1312: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
1313: FND_MSG_PUB.add;
1314: x_return_status := FND_API.G_RET_STS_ERROR;
1315: ELSE
1316: FOR get_covered_inventory_rec IN get_covered_inventory_csr(l_hdr_rec.org_id, l_hdr_rec.effective_start_date, l_hdr_rec.effective_end_date, l_inventorydetails_tbl(i).Inventory_Item_ID)
1317: LOOP
1318: l_inventorydetails_tbl(i).covered_quantity := NVL(get_covered_inventory_rec.covered_qty,0);

Line 1472: x_return_status := FND_API.G_RET_STS_ERROR;

1468: AND rownum = 1;
1469: EXCEPTION
1470: WHEN OTHERS THEN
1471: DPP_UTILITY_PVT.debug_message ('Error in fetching primary UOM: ' || SQLERRM);
1472: x_return_status := FND_API.G_RET_STS_ERROR;
1473: END;
1474:
1475: l_inventorydetails_tbl(i).uom_code := l_primary_uom_code; -- Default to Primary UOM
1476: END IF;

Line 1489: WHEN FND_API.G_EXC_ERROR THEN

1485: DPP_UTILITY_PVT.debug_message ('get_inventorydetails(): x_return_status: ' || x_return_status);
1486: END IF;
1487:
1488: EXCEPTION
1489: WHEN FND_API.G_EXC_ERROR THEN
1490: x_return_status := FND_API.G_RET_STS_ERROR;
1491:
1492: WHEN OTHERS THEN
1493: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1490: x_return_status := FND_API.G_RET_STS_ERROR;

1486: END IF;
1487:
1488: EXCEPTION
1489: WHEN FND_API.G_EXC_ERROR THEN
1490: x_return_status := FND_API.G_RET_STS_ERROR;
1491:
1492: WHEN OTHERS THEN
1493: x_return_status := fnd_api.g_ret_sts_unexp_error;
1494:

Line 1493: x_return_status := fnd_api.g_ret_sts_unexp_error;

1489: WHEN FND_API.G_EXC_ERROR THEN
1490: x_return_status := FND_API.G_RET_STS_ERROR;
1491:
1492: WHEN OTHERS THEN
1493: x_return_status := fnd_api.g_ret_sts_unexp_error;
1494:
1495: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1496: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1497: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_InventoryDetails');

Line 1537: x_return_status := fnd_api.g_ret_sts_success;

1533: osta.primary_uom_code;
1534: BEGIN
1535:
1536: x_rec_count := 0;
1537: x_return_status := fnd_api.g_ret_sts_success;
1538: IF l_hdr_rec.effective_start_date IS NULL THEN
1539: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1540: FND_MESSAGE.set_token('ID', 'Effective Start Date');
1541: FND_MSG_PUB.add;

Line 1542: RAISE FND_API.G_EXC_ERROR;

1538: IF l_hdr_rec.effective_start_date IS NULL THEN
1539: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1540: FND_MESSAGE.set_token('ID', 'Effective Start Date');
1541: FND_MSG_PUB.add;
1542: RAISE FND_API.G_EXC_ERROR;
1543: ELSIF l_hdr_rec.effective_end_date IS NULL THEN
1544: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1545: FND_MESSAGE.set_token('ID', 'Effective End Date');
1546: FND_MSG_PUB.add;

Line 1547: RAISE FND_API.G_EXC_ERROR;

1543: ELSIF l_hdr_rec.effective_end_date IS NULL THEN
1544: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1545: FND_MESSAGE.set_token('ID', 'Effective End Date');
1546: FND_MSG_PUB.add;
1547: RAISE FND_API.G_EXC_ERROR;
1548: END IF;
1549:
1550: FOR i in l_cust_inv_tbl.FIRST..l_cust_inv_tbl.LAST
1551: LOOP

Line 1557: x_return_status := FND_API.G_RET_STS_ERROR;

1553: IF l_cust_inv_tbl(i).Inventory_Item_ID IS NULL THEN
1554: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1555: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
1556: FND_MSG_PUB.add;
1557: x_return_status := FND_API.G_RET_STS_ERROR;
1558: ELSIF l_cust_inv_tbl(i).Customer_ID IS NULL THEN
1559: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1560: FND_MESSAGE.set_token('ID', 'Customer ID');
1561: FND_MSG_PUB.add;

Line 1562: x_return_status := FND_API.G_RET_STS_ERROR;

1558: ELSIF l_cust_inv_tbl(i).Customer_ID IS NULL THEN
1559: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1560: FND_MESSAGE.set_token('ID', 'Customer ID');
1561: FND_MSG_PUB.add;
1562: x_return_status := FND_API.G_RET_STS_ERROR;
1563: ELSE
1564: FOR get_customer_inventory_rec IN get_customer_inventory_csr(l_hdr_rec.effective_start_date,
1565: l_hdr_rec.effective_end_date,
1566: l_cust_inv_tbl(i).customer_ID,

Line 1582: WHEN FND_API.G_EXC_ERROR THEN

1578: IF DPP_DEBUG_HIGH_ON THEN
1579: DPP_UTILITY_PVT.debug_message ('get_customerInventory(): x_return_status: ' || x_return_status);
1580: END IF;
1581: EXCEPTION
1582: WHEN FND_API.G_EXC_ERROR THEN
1583: x_return_status := FND_API.G_RET_STS_ERROR;
1584:
1585: WHEN OTHERS THEN
1586: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1583: x_return_status := FND_API.G_RET_STS_ERROR;

1579: DPP_UTILITY_PVT.debug_message ('get_customerInventory(): x_return_status: ' || x_return_status);
1580: END IF;
1581: EXCEPTION
1582: WHEN FND_API.G_EXC_ERROR THEN
1583: x_return_status := FND_API.G_RET_STS_ERROR;
1584:
1585: WHEN OTHERS THEN
1586: x_return_status := fnd_api.g_ret_sts_unexp_error;
1587: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1586: x_return_status := fnd_api.g_ret_sts_unexp_error;

1582: WHEN FND_API.G_EXC_ERROR THEN
1583: x_return_status := FND_API.G_RET_STS_ERROR;
1584:
1585: WHEN OTHERS THEN
1586: x_return_status := fnd_api.g_ret_sts_unexp_error;
1587: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1588: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1589: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_CustomerInventory');
1590: fnd_message.set_token('ERRNO', sqlcode);

Line 1640: x_return_status := fnd_api.g_ret_sts_success;

1636: ORDER BY hz.account_name,hz.account_number;
1637:
1638: BEGIN
1639: x_rec_count := 0;
1640: x_return_status := fnd_api.g_ret_sts_success;
1641: IF l_search_criteria_tbl(2).search_text IS NULL THEN
1642: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1643: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_TRANSACTIONID');
1644: fnd_msg_pub.add;

Line 1646: RAISE FND_API.G_EXC_ERROR;

1642: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
1643: fnd_message.set_name('DPP', 'DPP_UI_LOV_NO_TRANSACTIONID');
1644: fnd_msg_pub.add;
1645: END IF;
1646: RAISE FND_API.G_EXC_ERROR;
1647: END IF;
1648:
1649: OPEN get_customer_csr(l_search_criteria_tbl(1).search_criteria,
1650: NVL(l_search_criteria_tbl(1).search_text,'%'),

Line 1667: WHEN FND_API.G_EXC_ERROR THEN

1663: DPP_UTILITY_PVT.debug_message ('search_customers(): x_return_status: ' || x_return_status);
1664: END IF;
1665:
1666: EXCEPTION
1667: WHEN FND_API.G_EXC_ERROR THEN
1668: x_return_status := FND_API.G_RET_STS_ERROR;
1669:
1670: WHEN OTHERS THEN
1671: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1668: x_return_status := FND_API.G_RET_STS_ERROR;

1664: END IF;
1665:
1666: EXCEPTION
1667: WHEN FND_API.G_EXC_ERROR THEN
1668: x_return_status := FND_API.G_RET_STS_ERROR;
1669:
1670: WHEN OTHERS THEN
1671: x_return_status := fnd_api.g_ret_sts_unexp_error;
1672:

Line 1671: x_return_status := fnd_api.g_ret_sts_unexp_error;

1667: WHEN FND_API.G_EXC_ERROR THEN
1668: x_return_status := FND_API.G_RET_STS_ERROR;
1669:
1670: WHEN OTHERS THEN
1671: x_return_status := fnd_api.g_ret_sts_unexp_error;
1672:
1673: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1674: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1675: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.search_customers');

Line 1744: x_return_status := fnd_api.g_ret_sts_success;

1740:
1741: BEGIN
1742:
1743: x_rec_count := 0;
1744: x_return_status := fnd_api.g_ret_sts_success;
1745: IF l_hdr_rec.org_id IS NULL THEN
1746: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1747: FND_MESSAGE.set_token('ID', 'Org ID');
1748: FND_MSG_PUB.add;

Line 1749: RAISE FND_API.G_EXC_ERROR;

1745: IF l_hdr_rec.org_id IS NULL THEN
1746: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1747: FND_MESSAGE.set_token('ID', 'Org ID');
1748: FND_MSG_PUB.add;
1749: RAISE FND_API.G_EXC_ERROR;
1750: END IF;
1751:
1752: FOR i in l_cust_price_tbl.FIRST..l_cust_price_tbl.LAST
1753: LOOP

Line 1759: x_return_status := FND_API.G_RET_STS_ERROR;

1755: IF l_cust_price_tbl(i).Inventory_Item_ID IS NULL THEN
1756: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1757: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
1758: FND_MSG_PUB.add;
1759: x_return_status := FND_API.G_RET_STS_ERROR;
1760: ELSIF l_cust_price_tbl(i).Customer_ID IS NULL THEN
1761: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1762: FND_MESSAGE.set_token('ID', 'Customer ID');
1763: FND_MSG_PUB.add;

Line 1764: x_return_status := FND_API.G_RET_STS_ERROR;

1760: ELSIF l_cust_price_tbl(i).Customer_ID IS NULL THEN
1761: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1762: FND_MESSAGE.set_token('ID', 'Customer ID');
1763: FND_MSG_PUB.add;
1764: x_return_status := FND_API.G_RET_STS_ERROR;
1765: ELSIF l_cust_price_tbl(i).UOM_Code IS NULL THEN
1766: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1767: FND_MESSAGE.set_token('ID', 'UOM Code');
1768: FND_MSG_PUB.add;

Line 1769: x_return_status := FND_API.G_RET_STS_ERROR;

1765: ELSIF l_cust_price_tbl(i).UOM_Code IS NULL THEN
1766: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1767: FND_MESSAGE.set_token('ID', 'UOM Code');
1768: FND_MSG_PUB.add;
1769: x_return_status := FND_API.G_RET_STS_ERROR;
1770: ELSIF l_cust_price_tbl(i).price_change IS NULL THEN
1771: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1772: FND_MESSAGE.set_token('ID', 'Price Change');
1773: FND_MSG_PUB.add;

Line 1774: x_return_status := FND_API.G_RET_STS_ERROR;

1770: ELSIF l_cust_price_tbl(i).price_change IS NULL THEN
1771: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1772: FND_MESSAGE.set_token('ID', 'Price Change');
1773: FND_MSG_PUB.add;
1774: x_return_status := FND_API.G_RET_STS_ERROR;
1775: ELSE
1776: FOR get_last_price_rec IN get_last_price_csr(l_hdr_rec.org_id,
1777: l_cust_price_tbl(i).Inventory_Item_ID,
1778: l_cust_price_tbl(i).Customer_ID,

Line 1793: ,p_conv_type => FND_API.G_MISS_CHAR

1789: --Call the convert currency API to get the converted value of Price change
1790: l_to_amount := 0;
1791: DPP_UTILITY_PVT.convert_currency( p_from_currency => l_hdr_rec.currency_code
1792: ,p_to_currency => l_cust_price_tbl(i).invoice_currency_code
1793: ,p_conv_type => FND_API.G_MISS_CHAR
1794: ,p_conv_rate => FND_API.G_MISS_NUM
1795: ,p_conv_date => l_trunc_sysdate
1796: ,p_from_amount => l_cust_price_tbl(i).price_change
1797: ,x_return_status => l_return_status

Line 1794: ,p_conv_rate => FND_API.G_MISS_NUM

1790: l_to_amount := 0;
1791: DPP_UTILITY_PVT.convert_currency( p_from_currency => l_hdr_rec.currency_code
1792: ,p_to_currency => l_cust_price_tbl(i).invoice_currency_code
1793: ,p_conv_type => FND_API.G_MISS_CHAR
1794: ,p_conv_rate => FND_API.G_MISS_NUM
1795: ,p_conv_date => l_trunc_sysdate
1796: ,p_from_amount => l_cust_price_tbl(i).price_change
1797: ,x_return_status => l_return_status
1798: ,x_to_amount => l_to_amount

Line 1826: WHEN FND_API.G_EXC_ERROR THEN

1822: DPP_UTILITY_PVT.debug_message ('get_lastprice(): x_return_status: ' || x_return_status);
1823: END IF;
1824:
1825: EXCEPTION
1826: WHEN FND_API.G_EXC_ERROR THEN
1827: x_return_status := FND_API.G_RET_STS_ERROR;
1828:
1829: WHEN OTHERS THEN
1830: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1827: x_return_status := FND_API.G_RET_STS_ERROR;

1823: END IF;
1824:
1825: EXCEPTION
1826: WHEN FND_API.G_EXC_ERROR THEN
1827: x_return_status := FND_API.G_RET_STS_ERROR;
1828:
1829: WHEN OTHERS THEN
1830: x_return_status := fnd_api.g_ret_sts_unexp_error;
1831:

Line 1830: x_return_status := fnd_api.g_ret_sts_unexp_error;

1826: WHEN FND_API.G_EXC_ERROR THEN
1827: x_return_status := FND_API.G_RET_STS_ERROR;
1828:
1829: WHEN OTHERS THEN
1830: x_return_status := fnd_api.g_ret_sts_unexp_error;
1831:
1832: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1833: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1834: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_LastPrice');

Line 1874: x_return_status := fnd_api.g_ret_sts_success;

1870:
1871: BEGIN
1872:
1873: x_rec_count := 0;
1874: x_return_status := fnd_api.g_ret_sts_success;
1875:
1876: IF l_header_rec.org_id IS NULL THEN
1877: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1878: FND_MESSAGE.set_token('ID', 'Org ID');

Line 1880: RAISE FND_API.G_EXC_ERROR;

1876: IF l_header_rec.org_id IS NULL THEN
1877: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1878: FND_MESSAGE.set_token('ID', 'Org ID');
1879: FND_MSG_PUB.add;
1880: RAISE FND_API.G_EXC_ERROR;
1881: ELSIF l_header_rec.currency_code IS NULL THEN
1882: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1883: FND_MESSAGE.set_token('ID', 'Currency Code');
1884: FND_MSG_PUB.add;

Line 1885: RAISE FND_API.G_EXC_ERROR;

1881: ELSIF l_header_rec.currency_code IS NULL THEN
1882: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1883: FND_MESSAGE.set_token('ID', 'Currency Code');
1884: FND_MSG_PUB.add;
1885: RAISE FND_API.G_EXC_ERROR;
1886: END IF;
1887: po_moac_utils_pvt.set_org_context(l_header_rec.org_id);
1888:
1889: SELECT inventory_organization_id

Line 1909: x_return_status := FND_API.G_RET_STS_ERROR;

1905: IF l_listprice_tbl(i).Inventory_Item_ID IS NULL THEN
1906: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1907: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
1908: FND_MSG_PUB.add;
1909: x_return_status := FND_API.G_RET_STS_ERROR;
1910: ELSE
1911: FOR get_list_price_rec IN get_list_price_csr(l_header_rec.org_id, l_listprice_tbl(i).Inventory_Item_ID)
1912: LOOP
1913: IF l_functional_currency = l_header_rec.currency_code THEN

Line 1920: ,p_conv_type => FND_API.G_MISS_CHAR

1916: l_to_amount := 0;
1917: DPP_UTILITY_PVT.convert_currency(
1918: p_from_currency => l_functional_currency
1919: ,p_to_currency => l_header_rec.currency_code
1920: ,p_conv_type => FND_API.G_MISS_CHAR
1921: ,p_conv_rate => FND_API.G_MISS_NUM
1922: ,p_conv_date => l_trunc_sysdate
1923: ,p_from_amount => get_list_price_rec.list_price
1924: ,x_return_status => l_return_status

Line 1921: ,p_conv_rate => FND_API.G_MISS_NUM

1917: DPP_UTILITY_PVT.convert_currency(
1918: p_from_currency => l_functional_currency
1919: ,p_to_currency => l_header_rec.currency_code
1920: ,p_conv_type => FND_API.G_MISS_CHAR
1921: ,p_conv_rate => FND_API.G_MISS_NUM
1922: ,p_conv_date => l_trunc_sysdate
1923: ,p_from_amount => get_list_price_rec.list_price
1924: ,x_return_status => l_return_status
1925: ,x_to_amount => l_to_amount

Line 1941: WHEN FND_API.G_EXC_ERROR THEN

1937: DPP_UTILITY_PVT.debug_message ('get_listprice(): x_return_status: ' || x_return_status);
1938: END IF;
1939:
1940: EXCEPTION
1941: WHEN FND_API.G_EXC_ERROR THEN
1942: x_return_status := FND_API.G_RET_STS_ERROR;
1943:
1944: WHEN OTHERS THEN
1945: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1942: x_return_status := FND_API.G_RET_STS_ERROR;

1938: END IF;
1939:
1940: EXCEPTION
1941: WHEN FND_API.G_EXC_ERROR THEN
1942: x_return_status := FND_API.G_RET_STS_ERROR;
1943:
1944: WHEN OTHERS THEN
1945: x_return_status := fnd_api.g_ret_sts_unexp_error;
1946:

Line 1945: x_return_status := fnd_api.g_ret_sts_unexp_error;

1941: WHEN FND_API.G_EXC_ERROR THEN
1942: x_return_status := FND_API.G_RET_STS_ERROR;
1943:
1944: WHEN OTHERS THEN
1945: x_return_status := fnd_api.g_ret_sts_unexp_error;
1946:
1947: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1948: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1949: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_ListPrice');

Line 1977: x_return_status := fnd_api.g_ret_sts_success;

1973:
1974: l_vendor_rec vendor_rec_type := p_vendor_rec;
1975: BEGIN
1976: x_rec_count := 0;
1977: x_return_status := fnd_api.g_ret_sts_success;
1978:
1979: IF l_vendor_rec.vendor_ID IS NULL THEN
1980: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1981: FND_MESSAGE.set_token('ID', 'Vendor ID');

Line 1983: RAISE FND_API.G_EXC_ERROR;

1979: IF l_vendor_rec.vendor_ID IS NULL THEN
1980: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
1981: FND_MESSAGE.set_token('ID', 'Vendor ID');
1982: FND_MSG_PUB.add;
1983: RAISE FND_API.G_EXC_ERROR;
1984: END IF;
1985: FOR get_vendor_rec IN get_vendor_csr(l_vendor_rec.vendor_ID)
1986: LOOP
1987: l_vendor_rec.vendor_number := get_vendor_rec.vendor_num;

Line 1995: WHEN FND_API.G_EXC_ERROR THEN

1991:
1992: p_vendor_rec := l_vendor_rec;
1993:
1994: EXCEPTION
1995: WHEN FND_API.G_EXC_ERROR THEN
1996: x_return_status := FND_API.G_RET_STS_ERROR;
1997:
1998: WHEN OTHERS THEN
1999: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1996: x_return_status := FND_API.G_RET_STS_ERROR;

1992: p_vendor_rec := l_vendor_rec;
1993:
1994: EXCEPTION
1995: WHEN FND_API.G_EXC_ERROR THEN
1996: x_return_status := FND_API.G_RET_STS_ERROR;
1997:
1998: WHEN OTHERS THEN
1999: x_return_status := fnd_api.g_ret_sts_unexp_error;
2000:

Line 1999: x_return_status := fnd_api.g_ret_sts_unexp_error;

1995: WHEN FND_API.G_EXC_ERROR THEN
1996: x_return_status := FND_API.G_RET_STS_ERROR;
1997:
1998: WHEN OTHERS THEN
1999: x_return_status := fnd_api.g_ret_sts_unexp_error;
2000:
2001: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2002: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2003: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor');

Line 2037: x_return_status := fnd_api.g_ret_sts_success;

2033:
2034: l_vendor_site_rec vendor_site_rec_type := p_vendor_site_rec;
2035: BEGIN
2036: x_rec_count := 0;
2037: x_return_status := fnd_api.g_ret_sts_success;
2038:
2039: IF l_vendor_site_rec.vendor_ID IS NULL THEN
2040: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2041: FND_MESSAGE.set_token('ID', 'Vendor ID');

Line 2043: RAISE FND_API.G_EXC_ERROR;

2039: IF l_vendor_site_rec.vendor_ID IS NULL THEN
2040: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2041: FND_MESSAGE.set_token('ID', 'Vendor ID');
2042: FND_MSG_PUB.add;
2043: RAISE FND_API.G_EXC_ERROR;
2044: ELSIF l_vendor_site_rec.vendor_site_ID IS NULL THEN
2045: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2046: FND_MESSAGE.set_token('ID', 'Vendor Site ID');
2047: FND_MSG_PUB.add;

Line 2048: RAISE FND_API.G_EXC_ERROR;

2044: ELSIF l_vendor_site_rec.vendor_site_ID IS NULL THEN
2045: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2046: FND_MESSAGE.set_token('ID', 'Vendor Site ID');
2047: FND_MSG_PUB.add;
2048: RAISE FND_API.G_EXC_ERROR;
2049: END IF;
2050:
2051: FOR get_vendor_site_rec IN get_vendor_site_csr(l_vendor_site_rec.vendor_ID,l_vendor_site_rec.vendor_site_ID)
2052: LOOP

Line 2067: WHEN FND_API.G_EXC_ERROR THEN

2063:
2064: p_vendor_site_rec := l_vendor_site_rec;
2065:
2066: EXCEPTION
2067: WHEN FND_API.G_EXC_ERROR THEN
2068: x_return_status := FND_API.G_RET_STS_ERROR;
2069:
2070: WHEN OTHERS THEN
2071: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2068: x_return_status := FND_API.G_RET_STS_ERROR;

2064: p_vendor_site_rec := l_vendor_site_rec;
2065:
2066: EXCEPTION
2067: WHEN FND_API.G_EXC_ERROR THEN
2068: x_return_status := FND_API.G_RET_STS_ERROR;
2069:
2070: WHEN OTHERS THEN
2071: x_return_status := fnd_api.g_ret_sts_unexp_error;
2072:

Line 2071: x_return_status := fnd_api.g_ret_sts_unexp_error;

2067: WHEN FND_API.G_EXC_ERROR THEN
2068: x_return_status := FND_API.G_RET_STS_ERROR;
2069:
2070: WHEN OTHERS THEN
2071: x_return_status := fnd_api.g_ret_sts_unexp_error;
2072:
2073: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2074: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2075: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor_Site');

Line 2108: x_return_status := fnd_api.g_ret_sts_success;

2104: l_vendor_contact_rec vendor_contact_rec_type := p_vendor_contact_rec;
2105:
2106: BEGIN
2107: x_rec_count := 0;
2108: x_return_status := fnd_api.g_ret_sts_success;
2109:
2110: IF l_vendor_contact_rec.vendor_site_ID IS NULL THEN
2111: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2112: FND_MESSAGE.set_token('ID', 'Vendor Site ID');

Line 2114: RAISE FND_API.G_EXC_ERROR;

2110: IF l_vendor_contact_rec.vendor_site_ID IS NULL THEN
2111: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2112: FND_MESSAGE.set_token('ID', 'Vendor Site ID');
2113: FND_MSG_PUB.add;
2114: RAISE FND_API.G_EXC_ERROR;
2115: ELSIF l_vendor_contact_rec.vendor_contact_ID IS NULL THEN
2116: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2117: FND_MESSAGE.set_token('ID', 'Vendor Contact ID');
2118: FND_MSG_PUB.add;

Line 2119: RAISE FND_API.G_EXC_ERROR;

2115: ELSIF l_vendor_contact_rec.vendor_contact_ID IS NULL THEN
2116: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2117: FND_MESSAGE.set_token('ID', 'Vendor Contact ID');
2118: FND_MSG_PUB.add;
2119: RAISE FND_API.G_EXC_ERROR;
2120: END IF;
2121:
2122: FOR get_vendor_contact_rec IN get_vendor_contact_csr(l_vendor_contact_rec.vendor_site_ID,l_vendor_contact_rec.vendor_contact_ID)
2123: LOOP

Line 2137: WHEN FND_API.G_EXC_ERROR THEN

2133:
2134: p_vendor_contact_rec := l_vendor_contact_rec;
2135:
2136: EXCEPTION
2137: WHEN FND_API.G_EXC_ERROR THEN
2138: x_return_status := FND_API.G_RET_STS_ERROR;
2139:
2140: WHEN OTHERS THEN
2141: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2138: x_return_status := FND_API.G_RET_STS_ERROR;

2134: p_vendor_contact_rec := l_vendor_contact_rec;
2135:
2136: EXCEPTION
2137: WHEN FND_API.G_EXC_ERROR THEN
2138: x_return_status := FND_API.G_RET_STS_ERROR;
2139:
2140: WHEN OTHERS THEN
2141: x_return_status := fnd_api.g_ret_sts_unexp_error;
2142:

Line 2141: x_return_status := fnd_api.g_ret_sts_unexp_error;

2137: WHEN FND_API.G_EXC_ERROR THEN
2138: x_return_status := FND_API.G_RET_STS_ERROR;
2139:
2140: WHEN OTHERS THEN
2141: x_return_status := fnd_api.g_ret_sts_unexp_error;
2142:
2143: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2144: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2145: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Vendor_Contact');

Line 2170: x_return_status := fnd_api.g_ret_sts_success;

2166: l_warehouse_tbl warehouse_tbl_type := p_warehouse_tbl;
2167:
2168: BEGIN
2169: x_rec_count := 0;
2170: x_return_status := fnd_api.g_ret_sts_success;
2171:
2172:
2173:
2174: IF l_warehouse_tbl.COUNT > 0 THEN

Line 2182: x_return_status := FND_API.G_RET_STS_ERROR;

2178: IF l_warehouse_tbl(i).warehouse_id IS NULL THEN
2179: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2180: FND_MESSAGE.set_token('ID', 'Warehouse ID');
2181: FND_MSG_PUB.add;
2182: x_return_status := FND_API.G_RET_STS_ERROR;
2183: ELSE
2184: FOR get_warehouse_rec IN get_warehouse_csr(l_warehouse_tbl(i).warehouse_id)
2185: LOOP
2186: l_warehouse_tbl(i).warehouse_name := get_warehouse_rec.warehouse;

Line 2200: WHEN FND_API.G_EXC_ERROR THEN

2196: DPP_UTILITY_PVT.debug_message ('get_warehouse(): x_return_status: ' || x_return_status);
2197: END IF;
2198:
2199: EXCEPTION
2200: WHEN FND_API.G_EXC_ERROR THEN
2201: x_return_status := FND_API.G_RET_STS_ERROR;
2202: WHEN OTHERS THEN
2203: x_return_status := fnd_api.g_ret_sts_unexp_error;
2204:

Line 2201: x_return_status := FND_API.G_RET_STS_ERROR;

2197: END IF;
2198:
2199: EXCEPTION
2200: WHEN FND_API.G_EXC_ERROR THEN
2201: x_return_status := FND_API.G_RET_STS_ERROR;
2202: WHEN OTHERS THEN
2203: x_return_status := fnd_api.g_ret_sts_unexp_error;
2204:
2205: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 2203: x_return_status := fnd_api.g_ret_sts_unexp_error;

2199: EXCEPTION
2200: WHEN FND_API.G_EXC_ERROR THEN
2201: x_return_status := FND_API.G_RET_STS_ERROR;
2202: WHEN OTHERS THEN
2203: x_return_status := fnd_api.g_ret_sts_unexp_error;
2204:
2205: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2206: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2207: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Warehouse');

Line 2232: x_return_status := fnd_api.g_ret_sts_success;

2228: l_customer_tbl customer_tbl_type := p_customer_tbl;
2229:
2230: BEGIN
2231: x_rec_count := 0;
2232: x_return_status := fnd_api.g_ret_sts_success;
2233:
2234: FOR i in l_customer_tbl.FIRST..l_customer_tbl.LAST
2235: LOOP
2236:

Line 2241: x_return_status := FND_API.G_RET_STS_ERROR;

2237: IF l_customer_tbl(i).customer_id IS NULL THEN
2238: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2239: FND_MESSAGE.set_token('ID', 'Customer ID');
2240: FND_MSG_PUB.add;
2241: x_return_status := FND_API.G_RET_STS_ERROR;
2242: ELSE
2243:
2244: FOR get_customer_rec IN get_customer_csr(l_customer_tbl(i).customer_id)
2245: LOOP

Line 2263: x_return_status := fnd_api.g_ret_sts_unexp_error;

2259: END IF;
2260:
2261: EXCEPTION
2262: WHEN OTHERS THEN
2263: x_return_status := fnd_api.g_ret_sts_unexp_error;
2264: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2265: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2266: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Customer');
2267: fnd_message.set_token('ERRNO', sqlcode);

Line 2305: RAISE fnd_api.g_exc_error;

2301: fnd_message.set_name('DPP', 'DPP_ORG_ID_NOTFOUND');
2302: fnd_msg_pub.add;
2303: END IF;
2304:
2305: RAISE fnd_api.g_exc_error;
2306: END IF;
2307:
2308: IF (DPP_DEBUG_HIGH_ON) THEN
2309: dpp_utility_pvt.debug_message('debug: start ' || l_org_id);

Line 2313: x_return_status := fnd_api.g_ret_sts_success;

2309: dpp_utility_pvt.debug_message('debug: start ' || l_org_id);
2310: END IF;
2311:
2312: x_rec_count := 0;
2313: x_return_status := fnd_api.g_ret_sts_success;
2314:
2315: FOR i in l_item_tbl.FIRST..l_item_tbl.LAST
2316: LOOP
2317:

Line 2322: x_return_status := FND_API.G_RET_STS_ERROR;

2318: IF l_item_tbl(i).inventory_item_id IS NULL THEN
2319: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2320: FND_MESSAGE.set_token('ID', 'Inventory Item ID');
2321: FND_MSG_PUB.add;
2322: x_return_status := FND_API.G_RET_STS_ERROR;
2323:
2324: ELSE
2325:
2326: FOR Get_Product_rec IN Get_Product_csr(l_item_tbl(i).inventory_item_id, l_org_id)

Line 2342: x_return_status := fnd_api.g_ret_sts_unexp_error;

2338: DPP_UTILITY_PVT.debug_message ('get_product(): x_return_status: ' || x_return_status);
2339: END IF;
2340: EXCEPTION
2341: WHEN OTHERS THEN
2342: x_return_status := fnd_api.g_ret_sts_unexp_error;
2343:
2344: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2345: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2346: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.Get_Product');

Line 2384: FND_MESSAGE.set_token('TEXT', REPLACE (p_message_text, FND_API.G_MISS_CHAR, 'G_MISS_CHAR'));

2380: INSERT INTO DPP_LOG_MESSAGES(LOG_ID,LOG_MESSAGE) VALUES(DPP_DEBUG_LOG_ID_SEQ.nextval, p_message_text);
2381: COMMIT;
2382:
2383: FND_MESSAGE.set_name('DPP', 'DPP_API_DEBUG_MESSAGE');
2384: FND_MESSAGE.set_token('TEXT', REPLACE (p_message_text, FND_API.G_MISS_CHAR, 'G_MISS_CHAR'));
2385: FND_MSG_PUB.add;
2386:
2387: END debug_message;
2388:

Line 2421: x_return_status := fnd_api.g_ret_sts_success;

2417:
2418: l_user_id NUMBER := p_user_id;
2419:
2420: BEGIN
2421: x_return_status := fnd_api.g_ret_sts_success;
2422:
2423: IF l_user_id IS NULL THEN
2424: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2425: FND_MESSAGE.set_token('ID', 'User ID');

Line 2427: RAISE FND_API.G_EXC_ERROR;

2423: IF l_user_id IS NULL THEN
2424: FND_MESSAGE.set_name('DPP', 'DPP_API_INPUT_ID_MISSING');
2425: FND_MESSAGE.set_token('ID', 'User ID');
2426: FND_MSG_PUB.add;
2427: RAISE FND_API.G_EXC_ERROR;
2428: ELSE
2429:
2430: FOR Get_Mail_ID_rec IN Get_Mail_ID_csr(l_user_id)
2431: LOOP

Line 2438: x_return_status := FND_API.G_RET_STS_ERROR;

2434:
2435: END IF;
2436:
2437: IF x_email_address IS NULL THEN
2438: x_return_status := FND_API.G_RET_STS_ERROR;
2439: END IF;
2440:
2441: EXCEPTION
2442: WHEN FND_API.G_EXC_ERROR THEN

Line 2442: WHEN FND_API.G_EXC_ERROR THEN

2438: x_return_status := FND_API.G_RET_STS_ERROR;
2439: END IF;
2440:
2441: EXCEPTION
2442: WHEN FND_API.G_EXC_ERROR THEN
2443: x_return_status := FND_API.G_RET_STS_ERROR;
2444: WHEN OTHERS THEN
2445: x_return_status := fnd_api.g_ret_sts_unexp_error;
2446:

Line 2443: x_return_status := FND_API.G_RET_STS_ERROR;

2439: END IF;
2440:
2441: EXCEPTION
2442: WHEN FND_API.G_EXC_ERROR THEN
2443: x_return_status := FND_API.G_RET_STS_ERROR;
2444: WHEN OTHERS THEN
2445: x_return_status := fnd_api.g_ret_sts_unexp_error;
2446:
2447: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 2445: x_return_status := fnd_api.g_ret_sts_unexp_error;

2441: EXCEPTION
2442: WHEN FND_API.G_EXC_ERROR THEN
2443: x_return_status := FND_API.G_RET_STS_ERROR;
2444: WHEN OTHERS THEN
2445: x_return_status := fnd_api.g_ret_sts_unexp_error;
2446:
2447: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2448: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
2449: fnd_message.set_token('ROUTINE', 'DPP_UTILITY_PVT.get_EmailAddress');

Line 2459: ,p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

2455:
2456: PROCEDURE convert_currency(
2457: p_from_currency IN VARCHAR2
2458: ,p_to_currency IN VARCHAR2
2459: ,p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
2460: ,p_conv_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM
2461: ,p_conv_date IN DATE DEFAULT SYSDATE
2462: ,p_from_amount IN NUMBER
2463: ,x_return_status OUT NOCOPY VARCHAR2

Line 2460: ,p_conv_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM

2456: PROCEDURE convert_currency(
2457: p_from_currency IN VARCHAR2
2458: ,p_to_currency IN VARCHAR2
2459: ,p_conv_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
2460: ,p_conv_rate IN NUMBER DEFAULT FND_API.G_MISS_NUM
2461: ,p_conv_date IN DATE DEFAULT SYSDATE
2462: ,p_from_amount IN NUMBER
2463: ,x_return_status OUT NOCOPY VARCHAR2
2464: ,x_to_amount OUT NOCOPY NUMBER

Line 2480: x_return_status := fnd_api.g_ret_sts_success;

2476: l_conversion_type VARCHAR2(30); -- Curr conversion type; see API doc for details.
2477:
2478: BEGIN
2479: -- Initialize return status.
2480: x_return_status := fnd_api.g_ret_sts_success;
2481: -- condition added to pass conversion types
2482: IF p_conv_type = FND_API.G_MISS_CHAR THEN
2483: -- Get the currency conversion type from profile option
2484: l_conversion_type := fnd_profile.VALUE(l_conversion_type_profile);

Line 2482: IF p_conv_type = FND_API.G_MISS_CHAR THEN

2478: BEGIN
2479: -- Initialize return status.
2480: x_return_status := fnd_api.g_ret_sts_success;
2481: -- condition added to pass conversion types
2482: IF p_conv_type = FND_API.G_MISS_CHAR THEN
2483: -- Get the currency conversion type from profile option
2484: l_conversion_type := fnd_profile.VALUE(l_conversion_type_profile);
2485: -- Conversion type cannot be null in profile
2486: IF l_conversion_type IS NULL THEN

Line 2491: x_return_status := fnd_api.g_ret_sts_error;

2487: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2488: fnd_message.set_name('DPP', 'DPP_NO_EXCHANGE_TYPE');
2489: fnd_msg_pub.add;
2490: END IF;
2491: x_return_status := fnd_api.g_ret_sts_error;
2492: RETURN;
2493: END IF;
2494: ELSE
2495: l_conversion_type := p_conv_type;

Line 2522: x_return_status := fnd_api.g_ret_sts_error;

2518: fnd_message.set_token('CURRENCY_TO', p_to_currency);
2519: fnd_msg_pub.add;
2520: END IF;
2521:
2522: x_return_status := fnd_api.g_ret_sts_error;
2523: WHEN gl_currency_api.invalid_currency THEN
2524: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2525: fnd_message.set_name('DPP', 'DPP_INVALID_CURR');
2526: fnd_message.set_token('CURRENCY_FROM', p_from_currency);

Line 2531: x_return_status := fnd_api.g_ret_sts_error;

2527: fnd_message.set_token('CURRENCY_TO', p_to_currency);
2528: fnd_msg_pub.add;
2529: END IF;
2530:
2531: x_return_status := fnd_api.g_ret_sts_error;
2532: WHEN OTHERS THEN
2533: x_return_status := fnd_api.g_ret_sts_unexp_error;
2534: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
2535: FND_MESSAGE.SET_TOKEN('ROUTINE', 'DPP_UTILITY_PVT.convert_currency');

Line 2533: x_return_status := fnd_api.g_ret_sts_unexp_error;

2529: END IF;
2530:
2531: x_return_status := fnd_api.g_ret_sts_error;
2532: WHEN OTHERS THEN
2533: x_return_status := fnd_api.g_ret_sts_unexp_error;
2534: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
2535: FND_MESSAGE.SET_TOKEN('ROUTINE', 'DPP_UTILITY_PVT.convert_currency');
2536: FND_MESSAGE.SET_TOKEN('ERRNO', sqlcode);
2537: FND_MESSAGE.SET_TOKEN('REASON', sqlerrm);

Line 2579: x_return_status := fnd_api.g_ret_sts_success;

2575: AND hr.organization_id = p_org_id;
2576:
2577: BEGIN
2578: -- Initialize return status.
2579: x_return_status := fnd_api.g_ret_sts_success;
2580:
2581: -- Get the currency conversion type from profile option
2582: IF x_exchange_rate_type IS NULL THEN
2583: l_conversion_type := fnd_profile.VALUE(l_conversion_type_profile);

Line 2594: x_return_status := fnd_api.g_ret_sts_error;

2590: fnd_message.set_name('DPP', 'DPP_NO_EXCHANGE_TYPE');
2591: fnd_msg_pub.add;
2592: END IF;
2593:
2594: x_return_status := fnd_api.g_ret_sts_error;
2595: RETURN;
2596: ELSE
2597: IF ozf_utility_pvt.check_fk_exists('GL_DAILY_CONVERSION_TYPES',
2598: 'CONVERSION_TYPE'

Line 2599: ,l_conversion_type) = fnd_api.g_false

2595: RETURN;
2596: ELSE
2597: IF ozf_utility_pvt.check_fk_exists('GL_DAILY_CONVERSION_TYPES',
2598: 'CONVERSION_TYPE'
2599: ,l_conversion_type) = fnd_api.g_false
2600: THEN
2601: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2602: fnd_message.set_name('DPP', 'DPP_WRONG_CONVERSION_TYPE');
2603: fnd_msg_pub.add;

Line 2605: x_return_status := fnd_api.g_ret_sts_error;

2601: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2602: fnd_message.set_name('DPP', 'DPP_WRONG_CONVERSION_TYPE');
2603: fnd_msg_pub.add;
2604: END IF;
2605: x_return_status := fnd_api.g_ret_sts_error;
2606: RETURN;
2607: END IF;
2608: END IF;
2609:

Line 2624: RAISE fnd_api.g_exc_error;

2620: fnd_message.set_name('DPP', 'DPP_ORG_ID_NOTFOUND');
2621: fnd_msg_pub.add;
2622: END IF;
2623:
2624: RAISE fnd_api.g_exc_error;
2625: END IF;
2626:
2627: END IF;
2628:

Line 2643: RAISE fnd_api.g_exc_error;

2639: fnd_message.set_name('DPP', 'DPP_GL_SOB_NOTFOUND');
2640: fnd_msg_pub.add;
2641: END IF;
2642:
2643: RAISE fnd_api.g_exc_error;
2644: END IF;
2645:
2646: CLOSE c_get_gl_info;
2647: -- Call the proper GL API to convert the amount.

Line 2665: WHEN fnd_api.g_exc_error THEN

2661: x_exchange_rate_type := l_conversion_type;
2662: --
2663:
2664: EXCEPTION
2665: WHEN fnd_api.g_exc_error THEN
2666: x_return_status := fnd_api.g_ret_sts_error;
2667: WHEN gl_currency_api.no_rate THEN
2668: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2669: fnd_message.set_name('DPP', 'DPP_NO_RATE');

Line 2666: x_return_status := fnd_api.g_ret_sts_error;

2662: --
2663:
2664: EXCEPTION
2665: WHEN fnd_api.g_exc_error THEN
2666: x_return_status := fnd_api.g_ret_sts_error;
2667: WHEN gl_currency_api.no_rate THEN
2668: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2669: fnd_message.set_name('DPP', 'DPP_NO_RATE');
2670: fnd_msg_pub.add;

Line 2673: x_return_status := fnd_api.g_ret_sts_error;

2669: fnd_message.set_name('DPP', 'DPP_NO_RATE');
2670: fnd_msg_pub.add;
2671: END IF;
2672:
2673: x_return_status := fnd_api.g_ret_sts_error;
2674: WHEN gl_currency_api.invalid_currency THEN
2675: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error) THEN
2676: fnd_message.set_name('DPP', 'DPP_INVALID_CURR');
2677: fnd_msg_pub.add;

Line 2680: x_return_status := fnd_api.g_ret_sts_error;

2676: fnd_message.set_name('DPP', 'DPP_INVALID_CURR');
2677: fnd_msg_pub.add;
2678: END IF;
2679:
2680: x_return_status := fnd_api.g_ret_sts_error;
2681: WHEN OTHERS THEN
2682: x_return_status := fnd_api.g_ret_sts_unexp_error;
2683:
2684: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 2682: x_return_status := fnd_api.g_ret_sts_unexp_error;

2678: END IF;
2679:
2680: x_return_status := fnd_api.g_ret_sts_error;
2681: WHEN OTHERS THEN
2682: x_return_status := fnd_api.g_ret_sts_unexp_error;
2683:
2684: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2685: FND_MESSAGE.SET_NAME('FND', 'SQL_PLSQL_ERROR');
2686: FND_MESSAGE.SET_TOKEN('ROUTINE', 'DPP_UTILITY_PVT.Convert_functional_curr');