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.JAI_AP_UTILS_PKG dependencies on JAI_AP_UTILS_PKG

Line 1: PACKAGE BODY jai_ap_utils_pkg AS

1: PACKAGE BODY jai_ap_utils_pkg AS
2: /* $Header: jai_ap_utils.plb 120.35.12020000.3 2013/03/25 01:55:39 cholei ship $ */
3:
4:
5:

Line 74: GV_MODULE_PREFIX CONSTANT VARCHAR2(30) := 'jai_ap_utils_pkg'; -- -- Added by Jia Li for tax inclusive computation on 2007/12/26

70:
71: 14 15-MAR-2013 zhiwei.xin Forward porting for DTC ER bug#13359892
72: ---------------------------------------------------------------------------------------------------------
73: */
74: GV_MODULE_PREFIX CONSTANT VARCHAR2(30) := 'jai_ap_utils_pkg'; -- -- Added by Jia Li for tax inclusive computation on 2007/12/26
75:
76: PROCEDURE create_pla_invoice(P_PLA_ID IN NUMBER,
77: P_SET_OF_BOOK_ID IN NUMBER, P_ORG_ID IN NUMBER) AS
78:

Line 903: lv_object_name VARCHAR2(61); -- := 'jai_ap_utils_pkg.insert_ap_inv_interface'; /* Added by Ramananda for bug#4407165 */

899: --Added by Qiong for AP Open Interface of ZX intergration --ported by Chong from 12.1.3 20130325
900: p_Calc_Tax_During_Import_Flag IN VARCHAR2 DEFAULT NULL
901: ) IS
902:
903: lv_object_name VARCHAR2(61); -- := 'jai_ap_utils_pkg.insert_ap_inv_interface'; /* Added by Ramananda for bug#4407165 */
904:
905:
906: /* start additions by ssumaith - bug# 4448789 */
907: ln_legal_entity_id NUMBER;

Line 958: lv_object_name := 'jai_ap_utils_pkg.insert_ap_inv_interface'; /* Added by Ramananda for bug#4407165 */

954: -- # --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
955: -- # --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
956: -- # ****************************************************************************************************************************************************************************************
957:
958: lv_object_name := 'jai_ap_utils_pkg.insert_ap_inv_interface'; /* Added by Ramananda for bug#4407165 */
959:
960: /*Start additions by mmurtuza for bug 13423031*/
961: open cur_get_base_legal_entity_id;
962: fetch cur_get_base_legal_entity_id into ln_legal_entity_id;

Line 1262: lv_object_name := 'jai_ap_utils_pkg.insert_ap_inv_lines_interface'; /* Added by Ramananda for bug#4407165 */

1258: IS
1259: lv_object_name VARCHAR2(61);
1260: BEGIN
1261:
1262: lv_object_name := 'jai_ap_utils_pkg.insert_ap_inv_lines_interface'; /* Added by Ramananda for bug#4407165 */
1263:
1264: INSERT INTO ap_invoice_lines_interface(
1265: INVOICE_ID,
1266: INVOICE_LINE_ID,

Line 1578: FILENAME: jai_ap_utils_pkg.get_apportion_factor.sql

1574:
1575: begin
1576:
1577: /* -----------------------------------------------------------------------------
1578: FILENAME: jai_ap_utils_pkg.get_apportion_factor.sql
1579: CHANGE HISTORY:
1580:
1581: S.No Date Author and Details
1582: 1 14/06/2004 Created by Aparajita for bug#3633078. Version#115.0

Line 1922: Fnd_File.put_line(Fnd_File.LOG, 'Exception encountered in procedure jai_ap_utils_pkg.submit_pla_boe_for_approval');

1918: Fnd_File.put_line(Fnd_File.LOG, 'PLA/BOE invoice num :' || p_boe_id || ', approval request submitted ');
1919:
1920: exception
1921: when others then
1922: Fnd_File.put_line(Fnd_File.LOG, 'Exception encountered in procedure jai_ap_utils_pkg.submit_pla_boe_for_approval');
1923: Fnd_File.put_line(Fnd_File.LOG, SQLERRM);
1924: retcode := 2;
1925: errbuf := SQLERRM;
1926: RETURN;

Line 3434: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_STATEMENT, 'JAI.PLSQL.JAI_AP_UTILS_PKG.get_section_code', 'get effective section code:' || lv_section_code);

3430: );
3431: FETCH cur_get_section_code INTO lv_section_code;
3432: CLOSE cur_get_section_code;
3433:
3434: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_STATEMENT, 'JAI.PLSQL.JAI_AP_UTILS_PKG.get_section_code', 'get effective section code:' || lv_section_code);
3435: RETURN lv_section_code;
3436: END get_section_code;
3437:
3438: FUNCTION GET_NATURAL_ACCOUNT_VALUE (PN_DISTRIBUTION_CCID NUMBER, PV_SEGMENT_NAME VARCHAR2) RETURN VARCHAR2

Line 4139: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_taxes_all',

4135: ,p_jai_cmn_taxes_all_rec.auto_create_category
4136: ,p_jai_cmn_taxes_all_rec.reverse_charge_flag
4137: );
4138:
4139: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_taxes_all',
4140: 'Created a new tax code ' || p_jai_cmn_taxes_all_rec.tax_id || '-' || p_jai_cmn_taxes_all_rec.tax_name);
4141:
4142: END insert_jai_cmn_taxes_all;
4143:

Line 4210: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_tax_ctg_lines',

4206: ,p_jai_cmn_tax_ctg_lines_rec.last_update_login
4207: ,p_jai_cmn_tax_ctg_lines_rec.object_version_number
4208: );
4209:
4210: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_PROCEDURE, 'JAI.PLSQL.JAI_AP_UTILS_PKG.insert_jai_cmn_tax_ctg_lines',
4211: 'Created a tax category line ' || p_jai_cmn_tax_ctg_lines_rec.line_no || '-' || p_jai_cmn_tax_ctg_lines_rec.tax_id);
4212:
4213: END insert_jai_cmn_tax_ctg_lines;
4214: ------------------------------------------------------------------------------------------------

Line 4530: END jai_ap_utils_pkg ;

4526:
4527: -- Code Ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 end.
4528:
4529:
4530: END jai_ap_utils_pkg ;