APPS.JAI_CMN_RG_OTHERS_PKG dependencies on JAI_CMN_RG_OTHERS_PKG

Line 1: PACKAGE BODY jai_cmn_rg_others_pkg AS

1: PACKAGE BODY jai_cmn_rg_others_pkg AS
2: /* $Header: jai_cmn_rg_oth.plb 120.2 2007/05/04 13:43:25 csahoo ship $ */
3: /***************************************************************************************************
4: CREATED BY : ssumaith
5: CREATED DATE : 11-JAN-2005

Line 67: p_process_msg := 'jai_cmn_rg_others_pkg - Source type cannot be Null';

63: END IF;
64:
65: IF p_source_type IS NULL THEN
66: p_process_flag := jai_constants.expected_error;
67: p_process_msg := 'jai_cmn_rg_others_pkg - Source type cannot be Null';
68: return;
69: END IF;
70:
71: IF p_source_name IS NULL THEN

Line 73: p_process_msg := 'jai_cmn_rg_others_pkg -Source Name cannot be Null';

69: END IF;
70:
71: IF p_source_name IS NULL THEN
72: p_process_flag := jai_constants.expected_error;
73: p_process_msg := 'jai_cmn_rg_others_pkg -Source Name cannot be Null';
74: return;
75: end if;
76:
77: IF p_tax_type IS NULL THEN

Line 79: p_process_msg := 'jai_cmn_rg_others_pkg - Tax type cannot be Null';

75: end if;
76:
77: IF p_tax_type IS NULL THEN
78: p_process_flag := jai_constants.expected_error;
79: p_process_msg := 'jai_cmn_rg_others_pkg - Tax type cannot be Null';
80: return;
81: END IF;
82:
83: OPEN c_rg_other_id;

Line 122: p_process_msg := 'Error Occured in jai_cmn_rg_others_pkg.insert_row - ' || substr(sqlerrm,1,900);

118:
119: EXCEPTION
120: WHEN OTHERS THEN
121: p_process_flag := jai_constants.unexpected_error;
122: p_process_msg := 'Error Occured in jai_cmn_rg_others_pkg.insert_row - ' || substr(sqlerrm,1,900);
123: END insert_row;
124:
125:
126: procedure check_balances(p_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE ,

Line 281: END jai_cmn_rg_others_pkg;

277: END check_sh_balances;
278: --end 5989740
279:
280:
281: END jai_cmn_rg_others_pkg;