APPS.CSTPSCCM dependencies on CSTPSCCM

Line 1: PACKAGE BODY CSTPSCCM AS

1: PACKAGE BODY CSTPSCCM AS
2: /* $Header: CSTSCCMB.pls 120.2 2007/12/19 08:07:23 smsasidh ship $ */
3:
4: FUNCTION merge_costs (
5: p_rollup_id IN NUMBER,

Line 167: x_err_buf := 'CSTPSCCM.remove_rollup_history' ||': Not Merged asbased_on_rollup_flag set to No ';

163: done in cursor defintion */
164: /* IF (based_on_rollup_costs_cur%FOUND) THEN */
165: IF (based_on_rollup_costs_cur%NOTFOUND) THEN
166: CLOSE based_on_rollup_costs_cur;
167: x_err_buf := 'CSTPSCCM.remove_rollup_history' ||': Not Merged asbased_on_rollup_flag set to No ';
168:
169: RETURN x_return_code;
170: END IF;
171: CLOSE based_on_rollup_costs_cur;

Line 824: x_err_buf := 'CSTPSCCM.merge_costs' ||': Returned Success';

820:
821: END LOOP;
822:
823: x_return_code := 0;
824: x_err_buf := 'CSTPSCCM.merge_costs' ||': Returned Success';
825: return x_return_code;
826:
827: EXCEPTION
828: WHEN OTHERS THEN

Line 830: x_err_buf := 'CSTPSCCM.merge_costs' ||'stmt_num='||l_stmt_num||' : '||substrb(sqlerrm,1,1000);

826:
827: EXCEPTION
828: WHEN OTHERS THEN
829: x_return_code := SQLCODE;
830: x_err_buf := 'CSTPSCCM.merge_costs' ||'stmt_num='||l_stmt_num||' : '||substrb(sqlerrm,1,1000);
831: --dbms_output.put_line(x_err_buf);
832: --dbms_output.put_line(to_char(x_return_code));
833:
834: return x_return_code;

Line 960: x_err_buf := 'CSTPSCCM.remove_rollup_history' ||': Returned Success';

956: AND CSL1.INVENTORY_ITEM_ID = CSLLC.INVENTORY_ITEM_ID
957: AND CSL1.ORGANIZATION_ID = CSLLC.ORGANIZATION_ID);
958:
959: x_return_code := 0;
960: x_err_buf := 'CSTPSCCM.remove_rollup_history' ||': Returned Success';
961: return x_return_code;
962:
963: EXCEPTION
964: WHEN OTHERS THEN

Line 966: x_err_buf := 'CSTPSCCM.remove_rollup_history' ||'stmt_num='||l_stmt_num||' : '||substrb(sqlerrm,1,240);

962:
963: EXCEPTION
964: WHEN OTHERS THEN
965: x_return_code := SQLCODE;
966: x_err_buf := 'CSTPSCCM.remove_rollup_history' ||'stmt_num='||l_stmt_num||' : '||substrb(sqlerrm,1,240);
967:
968: return x_return_code;
969:
970:

Line 985: retcode := CSTPSCCM.remove_rollup_history

981: ) IS
982:
983:
984: BEGIN
985: retcode := CSTPSCCM.remove_rollup_history
986: (
987: p_rollup_id => to_number(p_rollup_id),
988: p_sc_cost_type_id => to_number(p_sc_cost_type_id),
989: p_rollup_option => to_number(p_rollup_option),

Line 994: END CSTPSCCM;

990: x_err_buf => x_err_buf
991: );
992: END proc_remove_rollup_history;
993:
994: END CSTPSCCM;