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.OKL_PROCESS_TAX dependencies on OKL_API

Line 77: WHEN OKL_API.G_EXCEPTION_ERROR THEN

73: ELSE
74: RETURN FALSE;
75: END IF;
76: EXCEPTION
77: WHEN OKL_API.G_EXCEPTION_ERROR THEN
78: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
79: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Tax_Exempt',
80: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
81: END IF;

Line 80: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

76: EXCEPTION
77: WHEN OKL_API.G_EXCEPTION_ERROR THEN
78: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
79: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Tax_Exempt',
80: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
81: END IF;
82: IF c_exempt_status%ISOPEN THEN
83: CLOSE c_exempt_status;
84: END IF;

Line 126: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

122: | 20-JAN-2005 RKUTTIYA Added FND debug messages
123: *=======================================================================*/
124: /*
125: PROCEDURE Get_Asset_Details(p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_flag IN VARCHAR2,

Line 229: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

225: -- Local Variable Declarations
226: /*---------------------------------------------*/
227:
228: /*
229: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
230: l_asset_id NUMBER;
231: l_asset_number VARCHAR2(150);
232: l_inst_loc_id NUMBER;
233: l_inst_loc_type_code VARCHAR2(30);

Line 270: OKL_API.set_message( p_app_name => 'OKL',

266: print_to_log('l_inst_loc_type_code :'||l_inst_loc_type_code);
267:
268: IF l_inst_loc_id IS NULL THEN
269: -- Install Location id is required
270: OKL_API.set_message( p_app_name => 'OKL',
271: p_msg_name => G_REQUIRED_VALUE,
272: p_token1 => G_COL_NAME_TOKEN,
273: p_token1_value => 'LOCATION_ID');
274: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 274: RAISE OKL_API.G_EXCEPTION_ERROR;

270: OKL_API.set_message( p_app_name => 'OKL',
271: p_msg_name => G_REQUIRED_VALUE,
272: p_token1 => G_COL_NAME_TOKEN,
273: p_token1_value => 'LOCATION_ID');
274: RAISE OKL_API.G_EXCEPTION_ERROR;
275: END IF;
276:
277: --Check the source of the install location id
278: IF l_inst_loc_type_code = 'HZ_PARTY_SITES' THEN

Line 297: OKL_API.set_message( p_app_name => 'OKL',

293: print_to_log('px_ship_to_siteuseid :'||px_ship_to_siteuseid);
294:
295: IF px_ship_to_siteuseid IS NULL THEN
296: -- Install Location id is required
297: OKL_API.set_message( p_app_name => 'OKL',
298: p_msg_name => G_REQUIRED_VALUE,
299: p_token1 => G_COL_NAME_TOKEN,
300: p_token1_value => 'SHIP_TO');
301: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 301: RAISE OKL_API.G_EXCEPTION_ERROR;

297: OKL_API.set_message( p_app_name => 'OKL',
298: p_msg_name => G_REQUIRED_VALUE,
299: p_token1 => G_COL_NAME_TOKEN,
300: p_token1_value => 'SHIP_TO');
301: RAISE OKL_API.G_EXCEPTION_ERROR;
302: END IF;
303: --get the ship to location id
304: OPEN c_get_shiptolocid(l_loc_id);
305: FETCH c_get_shiptolocid INTO px_ship_to_locid,px_postal_code;

Line 317: WHEN OKL_API.G_EXCEPTION_ERROR THEN

313: px_postal_code := NULL;
314: END IF;
315: x_return_status := l_return_status;
316: EXCEPTION
317: WHEN OKL_API.G_EXCEPTION_ERROR THEN
318: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
319: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Get_Asset_Details',
320: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
321: END IF;

Line 320: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');

316: EXCEPTION
317: WHEN OKL_API.G_EXCEPTION_ERROR THEN
318: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
319: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Get_Asset_Details',
320: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
321: END IF;
322: IF c_asset_number%ISOPEN THEN
323: CLOSE c_asset_number;
324: END IF;

Line 537: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

533: OKC_LINE_STYLES_B B
534: WHERE A.LSE_ID = B.ID
535: AND A.ID = p_kle_id;
536: */
537: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
538: l_api_name CONSTANT VARCHAR2(30) := 'Create_Tax_Schedule';
539: l_api_version CONSTANT NUMBER := 1;
540: /*-----------------------------------------------------------------------+
541: | Local Variable Declarations and initializations |

Line 598: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

594: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_date_from :'||p_tax_in_rec.date_from);
595: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_date_to :'||p_tax_in_rec.date_to);
596: END IF;
597:
598: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
599: G_PKG_NAME,
600: p_init_msg_list,
601: l_api_version,
602: p_api_version,

Line 643: OKL_API.set_message(p_app_name => g_app_name,

639: OPEN c_lty_code(contract_streams_rec.line_id);
640: FETCH c_lty_code INTO l_lty_code;
641: IF c_lty_code%NOTFOUND THEN
642: -- The case of a bad data need to be handled (Bad line id in the streams record)
643: OKL_API.set_message(p_app_name => g_app_name,
644: p_msg_name => 'OKL_INVALID_DATA');
645: RAISE OKL_API.G_EXCEPTION_ERROR;
646: END IF;
647: CLOSE c_lty_code;

Line 645: RAISE OKL_API.G_EXCEPTION_ERROR;

641: IF c_lty_code%NOTFOUND THEN
642: -- The case of a bad data need to be handled (Bad line id in the streams record)
643: OKL_API.set_message(p_app_name => g_app_name,
644: p_msg_name => 'OKL_INVALID_DATA');
645: RAISE OKL_API.G_EXCEPTION_ERROR;
646: END IF;
647: CLOSE c_lty_code;
648: END IF;
649: print_to_log('lty_code :'||l_lty_code);

Line 686: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

682: px_ship_to_siteuseid => lx_ship_to_siteuseid,
683: px_ship_to_locid => lx_ship_to_locid,
684: px_postal_code => lx_postal_code);
685: print_to_log('return status from Get_Asset_Details :'|| l_return_status);
686: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
687: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
688: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
689: RAISE OKL_API.G_EXCEPTION_ERROR;
690: END IF;

Line 687: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

683: px_ship_to_locid => lx_ship_to_locid,
684: px_postal_code => lx_postal_code);
685: print_to_log('return status from Get_Asset_Details :'|| l_return_status);
686: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
687: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
688: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
689: RAISE OKL_API.G_EXCEPTION_ERROR;
690: END IF;
691:

Line 688: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

684: px_postal_code => lx_postal_code);
685: print_to_log('return status from Get_Asset_Details :'|| l_return_status);
686: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
687: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
688: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
689: RAISE OKL_API.G_EXCEPTION_ERROR;
690: END IF;
691:
692:

Line 689: RAISE OKL_API.G_EXCEPTION_ERROR;

685: print_to_log('return status from Get_Asset_Details :'|| l_return_status);
686: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
687: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
688: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
689: RAISE OKL_API.G_EXCEPTION_ERROR;
690: END IF;
691:
692:
693: END IF; -- Tax Exempt

Line 708: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN

704: x_bill_to_address_rec => l_bill_to_rec,
705: x_return_status => l_return_status);
706: print_to_log('return status from get_bill_to_address :'|| l_return_status);
707:
708: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
709: l_cust_site_use_id := l_bill_to_rec.id1;
710: l_cust_account_id := l_bill_to_rec.cust_account_id;
711: l_bill_to_postal_code := l_bill_to_rec.postal_code;
712: OPEN c_get_billto_location(l_cust_site_use_id,l_cust_account_id);

Line 720: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS)

716: print_to_log('customer bill to site_use_id :'|| l_cust_site_use_id);
717: print_to_log('customer bill to location_id :'|| l_bill_to_locid);
718: print_to_log('customer bill to postal_code :'|| l_bill_to_postal_code);
719:
720: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS)
721: OR (l_cust_site_use_id IS NULL)
722: OR (l_cust_account_id IS NULL) THEN
723: -- l_overall_status := OKL_API.G_RET_STS_ERROR;
724: OKL_API.SET_MESSAGE (p_app_name => OKL_API.G_APP_NAME,

Line 723: -- l_overall_status := OKL_API.G_RET_STS_ERROR;

719:
720: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS)
721: OR (l_cust_site_use_id IS NULL)
722: OR (l_cust_account_id IS NULL) THEN
723: -- l_overall_status := OKL_API.G_RET_STS_ERROR;
724: OKL_API.SET_MESSAGE (p_app_name => OKL_API.G_APP_NAME,
725: p_msg_name => 'OKL_AM_TAX_NO_BILL_TO',
726: p_token1 => 'OBJECT',
727: p_token1_value => l_object_name);

Line 724: OKL_API.SET_MESSAGE (p_app_name => OKL_API.G_APP_NAME,

720: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS)
721: OR (l_cust_site_use_id IS NULL)
722: OR (l_cust_account_id IS NULL) THEN
723: -- l_overall_status := OKL_API.G_RET_STS_ERROR;
724: OKL_API.SET_MESSAGE (p_app_name => OKL_API.G_APP_NAME,
725: p_msg_name => 'OKL_AM_TAX_NO_BILL_TO',
726: p_token1 => 'OBJECT',
727: p_token1_value => l_object_name);
728: END IF;

Line 766: OKL_API.set_message(p_app_name => g_app_name,

762:
763: --Tax API logs the messages in a debug file in case of exceptions raised. hence coding in this manner.
764: WHEN OTHERS THEN
765: -- exceptions raised by Tax engine
766: OKL_API.set_message(p_app_name => g_app_name,
767: p_msg_name => 'OKL_CS_TAX_FAILED');
768:
769: RAISE OKL_API.G_EXCEPTION_ERROR;
770: END;--call to tax api.

Line 769: RAISE OKL_API.G_EXCEPTION_ERROR;

765: -- exceptions raised by Tax engine
766: OKL_API.set_message(p_app_name => g_app_name,
767: p_msg_name => 'OKL_CS_TAX_FAILED');
768:
769: RAISE OKL_API.G_EXCEPTION_ERROR;
770: END;--call to tax api.
771:
772:
773: -- get the out put tax record structure;

Line 822: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

818: x_msg_data => x_msg_data,
819: p_okl_tax_lines_v_rec => l_okl_tax_rec,
820: x_okl_tax_lines_v_rec => lx_tax_rec);
821:
822: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
823: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
824: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
825: RAISE OKL_API.G_EXCEPTION_ERROR;
826: END IF;

Line 823: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

819: p_okl_tax_lines_v_rec => l_okl_tax_rec,
820: x_okl_tax_lines_v_rec => lx_tax_rec);
821:
822: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
823: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
824: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
825: RAISE OKL_API.G_EXCEPTION_ERROR;
826: END IF;
827:

Line 824: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

820: x_okl_tax_lines_v_rec => lx_tax_rec);
821:
822: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
823: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
824: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
825: RAISE OKL_API.G_EXCEPTION_ERROR;
826: END IF;
827:
828: END LOOP; -- end processing output tax table

Line 825: RAISE OKL_API.G_EXCEPTION_ERROR;

821:
822: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
823: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
824: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
825: RAISE OKL_API.G_EXCEPTION_ERROR;
826: END IF;
827:
828: END LOOP; -- end processing output tax table
829:

Line 850: OKL_API.set_message(p_app_name => g_app_name,

846: OPEN c_lty_code(c_invoice_rec.line_id);
847: FETCH c_lty_code INTO l_lty_code;
848: IF c_lty_code%NOTFOUND THEN
849: -- The case of a bad data need to be handled (Bad line id in the streams record)
850: OKL_API.set_message(p_app_name => g_app_name,
851: p_msg_name => 'OKL_INVALID_DATA');
852: RAISE OKL_API.G_EXCEPTION_ERROR;
853: END IF;
854: CLOSE c_lty_code;

Line 852: RAISE OKL_API.G_EXCEPTION_ERROR;

848: IF c_lty_code%NOTFOUND THEN
849: -- The case of a bad data need to be handled (Bad line id in the streams record)
850: OKL_API.set_message(p_app_name => g_app_name,
851: p_msg_name => 'OKL_INVALID_DATA');
852: RAISE OKL_API.G_EXCEPTION_ERROR;
853: END IF;
854: CLOSE c_lty_code;
855: print_to_log('lty_code'||l_lty_code);
856: END IF;

Line 884: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

880: px_ship_to_siteuseid => lx_ship_to_siteuseid,
881: px_ship_to_locid => lx_ship_to_locid,
882: px_postal_code => lx_postal_code);
883:
884: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
885: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
886: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
887: RAISE OKL_API.G_EXCEPTION_ERROR;
888: END IF;

Line 885: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

881: px_ship_to_locid => lx_ship_to_locid,
882: px_postal_code => lx_postal_code);
883:
884: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
885: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
886: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
887: RAISE OKL_API.G_EXCEPTION_ERROR;
888: END IF;
889:

Line 886: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

882: px_postal_code => lx_postal_code);
883:
884: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
885: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
886: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
887: RAISE OKL_API.G_EXCEPTION_ERROR;
888: END IF;
889:
890: ELSIF (l_lty_code = 'SOLD_SERVICE') OR -- Line with no assets

Line 887: RAISE OKL_API.G_EXCEPTION_ERROR;

883:
884: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
885: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
886: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
887: RAISE OKL_API.G_EXCEPTION_ERROR;
888: END IF;
889:
890: ELSIF (l_lty_code = 'SOLD_SERVICE') OR -- Line with no assets
891: (l_lty_code = 'FEE') OR -- Line with no assets

Line 935: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

931: x_msg_data => x_msg_data,
932: p_okl_tax_lines_v_rec => l_okl_tax_rec,
933: x_okl_tax_lines_v_rec => lx_tax_rec);
934:
935: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
936: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
937: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
938: RAISE OKL_API.G_EXCEPTION_ERROR;
939: END IF;

Line 936: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

932: p_okl_tax_lines_v_rec => l_okl_tax_rec,
933: x_okl_tax_lines_v_rec => lx_tax_rec);
934:
935: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
936: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
937: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
938: RAISE OKL_API.G_EXCEPTION_ERROR;
939: END IF;
940:

Line 937: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

933: x_okl_tax_lines_v_rec => lx_tax_rec);
934:
935: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
936: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
937: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
938: RAISE OKL_API.G_EXCEPTION_ERROR;
939: END IF;
940:
941: END LOOP; --End Processing AR Tax records.

Line 938: RAISE OKL_API.G_EXCEPTION_ERROR;

934:
935: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
936: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
937: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
938: RAISE OKL_API.G_EXCEPTION_ERROR;
939: END IF;
940:
941: END LOOP; --End Processing AR Tax records.
942:

Line 947: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);

943: print_to_log('return status from simple entity'||l_return_status);
944: */
945:
946: x_return_status := l_return_status;
947: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
948: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
949: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule ','End(-)');
950: END IF;
951: EXCEPTION

Line 952: WHEN OKL_API.G_EXCEPTION_ERROR THEN

948: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
949: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule ','End(-)');
950: END IF;
951: EXCEPTION
952: WHEN OKL_API.G_EXCEPTION_ERROR THEN
953: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
954: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
955: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
956: END IF;

Line 955: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');

951: EXCEPTION
952: WHEN OKL_API.G_EXCEPTION_ERROR THEN
953: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
954: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
955: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
956: END IF;
957: /* IF c_get_custacctid%ISOPEN THEN
958: CLOSE c_get_custacctid;
959: END IF;

Line 973: x_return_status := OKL_API.G_RET_STS_ERROR;

969: IF c_invoiced_streams%ISOPEN THEN
970: CLOSE c_invoiced_streams;
971: END IF;
972: */
973: x_return_status := OKL_API.G_RET_STS_ERROR;
974:
975: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
976: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
977: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',

Line 975: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

971: END IF;
972: */
973: x_return_status := OKL_API.G_RET_STS_ERROR;
974:
975: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
976: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
977: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
978: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
979: END IF;

Line 978: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

974:
975: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
976: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
977: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
978: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
979: END IF;
980: /*IF c_get_custacctid%ISOPEN THEN
981: CLOSE c_get_custacctid;
982: END IF;

Line 996: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

992: IF c_invoiced_streams%ISOPEN THEN
993: CLOSE c_invoiced_streams;
994: END IF;
995: */
996: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
997:
998: WHEN OTHERS THEN
999: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1000: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',

Line 1019: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1015: IF c_invoiced_streams%ISOPEN THEN
1016: CLOSE c_invoiced_streams;
1017: END IF;
1018: */
1019: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1020: -- unexpecetd error
1021: OKL_API.set_message(p_app_name => g_app_name,
1022: p_msg_name => g_unexpected_error,
1023: p_token1 => g_sqlcode_token,

Line 1021: OKL_API.set_message(p_app_name => g_app_name,

1017: END IF;
1018: */
1019: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1020: -- unexpecetd error
1021: OKL_API.set_message(p_app_name => g_app_name,
1022: p_msg_name => g_unexpected_error,
1023: p_token1 => g_sqlcode_token,
1024: p_token1_value => sqlcode,
1025: p_token2 => g_sqlerrm_token,

Line 1074: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1070: x_msg_count OUT NOCOPY NUMBER,
1071: x_msg_data OUT NOCOPY VARCHAR2,
1072: p_tax_in_tbl IN okl_tax_tbl_type)
1073: IS
1074: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1075: l_api_name CONSTANT VARCHAR2(30) := 'Create_Tax_Schedule';
1076: l_api_version CONSTANT NUMBER := 1;
1077: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1078: i NUMBER;

Line 1077: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1073: IS
1074: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1075: l_api_name CONSTANT VARCHAR2(30) := 'Create_Tax_Schedule';
1076: l_api_version CONSTANT NUMBER := 1;
1077: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1078: i NUMBER;
1079: BEGIN
1080: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1081: G_PKG_NAME,

Line 1080: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1076: l_api_version CONSTANT NUMBER := 1;
1077: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1078: i NUMBER;
1079: BEGIN
1080: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1081: G_PKG_NAME,
1082: p_init_msg_list,
1083: l_api_version,
1084: p_api_version,

Line 1088: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

1084: p_api_version,
1085: '_PVT',
1086: x_return_status);
1087: -- check if activity started successfully
1088: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1089: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1090: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1091: raise OKL_API.G_EXCEPTION_ERROR;
1092: End If;

Line 1089: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1085: '_PVT',
1086: x_return_status);
1087: -- check if activity started successfully
1088: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1089: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1090: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1091: raise OKL_API.G_EXCEPTION_ERROR;
1092: End If;
1093: -- Make sure PL/SQL table has records in it before passing

Line 1090: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

1086: x_return_status);
1087: -- check if activity started successfully
1088: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1089: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1090: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1091: raise OKL_API.G_EXCEPTION_ERROR;
1092: End If;
1093: -- Make sure PL/SQL table has records in it before passing
1094: /* IF (p_tax_in_tbl.COUNT > 0) THEN

Line 1091: raise OKL_API.G_EXCEPTION_ERROR;

1087: -- check if activity started successfully
1088: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
1089: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1090: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
1091: raise OKL_API.G_EXCEPTION_ERROR;
1092: End If;
1093: -- Make sure PL/SQL table has records in it before passing
1094: /* IF (p_tax_in_tbl.COUNT > 0) THEN
1095: i := p_tax_in_tbl.FIRST;

Line 1114: p_init_msg_list => OKL_API.G_FALSE,

1110: END IF;
1111: LOOP
1112: Create_Tax_Schedule (
1113: p_api_version => l_api_version,
1114: p_init_msg_list => OKL_API.G_FALSE,
1115: x_return_status => x_return_status,
1116: x_msg_count => x_msg_count,
1117: x_msg_data => x_msg_data,
1118: p_tax_in_rec => p_tax_in_tbl(i));

Line 1120: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then

1116: x_msg_count => x_msg_count,
1117: x_msg_data => x_msg_data,
1118: p_tax_in_rec => p_tax_in_tbl(i));
1119: -- store the highest degree of error
1120: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then
1121: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then
1122: l_overall_status := x_return_status;
1123: End If;
1124: End If;

Line 1121: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then

1117: x_msg_data => x_msg_data,
1118: p_tax_in_rec => p_tax_in_tbl(i));
1119: -- store the highest degree of error
1120: If x_return_status <> OKL_API.G_RET_STS_SUCCESS Then
1121: If l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR Then
1122: l_overall_status := x_return_status;
1123: End If;
1124: End If;
1125: EXIT WHEN (i = p_tax_in_tbl.LAST);

Line 1131: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

1127: END LOOP;
1128: -- return overall status
1129: x_return_status := l_overall_status;
1130: END IF;
1131: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1132: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1133: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1134: raise OKL_API.G_EXCEPTION_ERROR;
1135: End If;

Line 1132: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1128: -- return overall status
1129: x_return_status := l_overall_status;
1130: END IF;
1131: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1132: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1133: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1134: raise OKL_API.G_EXCEPTION_ERROR;
1135: End If;
1136: */

Line 1133: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

1129: x_return_status := l_overall_status;
1130: END IF;
1131: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1132: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1133: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1134: raise OKL_API.G_EXCEPTION_ERROR;
1135: End If;
1136: */
1137: x_return_status := l_return_status;

Line 1134: raise OKL_API.G_EXCEPTION_ERROR;

1130: END IF;
1131: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1132: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1133: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1134: raise OKL_API.G_EXCEPTION_ERROR;
1135: End If;
1136: */
1137: x_return_status := l_return_status;
1138:

Line 1139: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);

1135: End If;
1136: */
1137: x_return_status := l_return_status;
1138:
1139: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
1140: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1141: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule ','End(-)');
1142: END IF;
1143: EXCEPTION

Line 1144: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1140: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1141: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule ','End(-)');
1142: END IF;
1143: EXCEPTION
1144: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1145: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1146: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
1147: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
1148: END IF;

Line 1147: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');

1143: EXCEPTION
1144: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1145: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1146: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
1147: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
1148: END IF;
1149: x_return_status := OKL_API.G_RET_STS_ERROR;
1150: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1151: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1149: x_return_status := OKL_API.G_RET_STS_ERROR;

1145: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1146: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
1147: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
1148: END IF;
1149: x_return_status := OKL_API.G_RET_STS_ERROR;
1150: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1151: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1152: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
1153: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

Line 1150: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1146: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
1147: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
1148: END IF;
1149: x_return_status := OKL_API.G_RET_STS_ERROR;
1150: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1151: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1152: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
1153: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1154: END IF;

Line 1153: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');

1149: x_return_status := OKL_API.G_RET_STS_ERROR;
1150: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1151: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1152: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
1153: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1154: END IF;
1155: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1156: WHEN OTHERS THEN
1157: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1155: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1151: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1152: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
1153: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1154: END IF;
1155: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1156: WHEN OTHERS THEN
1157: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1158: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
1159: 'EXCEPTION :'||sqlerrm);

Line 1161: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1157: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1158: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
1159: 'EXCEPTION :'||sqlerrm);
1160: END IF;
1161: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1162: -- unexpected error
1163: OKL_API.set_message(p_app_name => g_app_name,
1164: p_msg_name => g_unexpected_error,
1165: p_token1 => g_sqlcode_token,

Line 1163: OKL_API.set_message(p_app_name => g_app_name,

1159: 'EXCEPTION :'||sqlerrm);
1160: END IF;
1161: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1162: -- unexpected error
1163: OKL_API.set_message(p_app_name => g_app_name,
1164: p_msg_name => g_unexpected_error,
1165: p_token1 => g_sqlcode_token,
1166: p_token1_value => sqlcode,
1167: p_token2 => g_sqlerrm_token,