1: PACKAGE BODY PON_PRICE_ELEMENTS_PKG as
2: /* $Header: PONPETPB.pls 120.2 2006/04/13 13:09:47 sapandey noship $ */
3:
4: -------------------------------------------------------------------------------
5: -------------------------- PACKAGE BODY --------------------------------------
60: p_result := 2;
61: p_err_msg := SQLERRM;
62: p_err_code := SQLCODE;
63:
64: RAISE_APPLICATION_ERROR(-20000, 'Exception at PON_PRICE_ELEMENTS_PKG.insert_price_element('|| x_err_loc || '): ' || p_err_code || ' : ' || p_err_msg);
65:
66:
67: END;
68:
131: WHEN OTHERS THEN
132: p_result := 2;
133: p_err_msg := SQLERRM;
134: p_err_code := SQLCODE;
135: RAISE_APPLICATION_ERROR(-20000, 'Exception at PON_PRICE_ELEMENTS_PKG.update_price_element('|| x_err_loc || '): ' || p_err_code || ' : ' || p_err_msg);
136:
137:
138: END;
139:
187: AND pe2.language = lang.language_code);
188:
189: END ADD_LANGUAGE;
190:
191: END PON_PRICE_ELEMENTS_PKG;