APPS.CSTPSCCR dependencies on STANDARD

Line 650: CM_FROZEN_STANDARD NUMBER := 1;

646: l_org_id NUMBER;
647: CM_THIS_LEVEL NUMBER := 1;
648: CM_PREVIOUS_LEVEL NUMBER := 2;
649: CM_REPORT_ONLY NUMBER := 3;
650: CM_FROZEN_STANDARD NUMBER := 1;
651: l_oerr_code NUMBER;
652: l_buy_cost NUMBER;
653: l_vendor_id NUMBER;
654: l_src_org_id NUMBER;

Line 661: standard_error EXCEPTION;

657: l_wsm_enabled VARCHAR2(1);
658: l_ret_code NUMBER;
659: l_phantom_mat NUMBER;
660: sql_stmt_num NUMBER := 0;
661: standard_error EXCEPTION;
662: snapshot_error EXCEPTION;
663: l_login_id NUMBER := -1;
664: l_rollup_date CONSTANT DATE := TO_DATE(rollup_date,'YYYY/MM/DD HH24:MI:SS');
665:

Line 859: RAISE STANDARD_ERROR;

855: return_code,
856: err_buf);
857:
858: IF (return_code <> 0) THEN
859: RAISE STANDARD_ERROR;
860: END IF;
861:
862:
863: sql_stmt_num := 30;

Line 875: RAISE STANDARD_ERROR;

871: return_code,
872: err_buf);
873:
874: IF (return_code <> 0) THEN
875: RAISE STANDARD_ERROR;
876: END IF;
877:
878:
879:

Line 892: RAISE STANDARD_ERROR;

888: return_code,
889: err_buf);
890:
891: IF (return_code <> 0) THEN
892: RAISE STANDARD_ERROR;
893: END IF;
894:
895:
896: END LOOP;

Line 2140: RAISE STANDARD_ERROR;

2136: IF (l_oerr_code <> 0) THEN
2137: /* Propagation for Bug 2347889.
2138: Need to return error_code */
2139: return_code := l_oerr_code;
2140: RAISE STANDARD_ERROR;
2141: END IF;
2142:
2143: END LOOP;
2144:

Line 2174: RAISE STANDARD_ERROR;

2170: END IF;
2171:
2172: IF (l_oerr_code <> 0) THEN
2173: return_code := l_oerr_code;
2174: RAISE STANDARD_ERROR;
2175: END IF;
2176:
2177:
2178: sql_stmt_num := 130;

Line 2412: when STANDARD_ERROR then

2408: err_buf := 'CSTPSCCR.cstsccru ' || 'Success';
2409: return(return_code);
2410:
2411: EXCEPTION
2412: when STANDARD_ERROR then
2413: return(return_code);
2414: when SNAPSHOT_ERROR then
2415: return(return_code);
2416: when OTHERS then

Line 2439: STANDARD_ERROR EXCEPTION;

2435: l_stmt_num NUMBER;
2436: l_src_org_id NUMBER;
2437: l_markup_code NUMBER;
2438: l_markup NUMBER;
2439: STANDARD_ERROR EXCEPTION;
2440:
2441: CURSOR markup_org_cur(
2442: l_rollup_id IN NUMBER,
2443: l_inventory_item_id IN NUMBER,

Line 2491: RAISE STANDARD_ERROR;

2487: x_err_buf
2488: );
2489:
2490: IF (x_err_code <> 0) THEN
2491: RAISE STANDARD_ERROR;
2492: NULL;
2493: END IF;
2494:
2495: UPDATE CST_SC_SOURCING_RULES CSSR

Line 2563: STANDARD_ERROR EXCEPTION;

2559: l_src_org_id NUMBER;
2560: x_ship_charge_code NUMBER;
2561: x_ship_charge NUMBER;
2562: l_ship_method VARCHAR2(30);
2563: STANDARD_ERROR EXCEPTION;
2564:
2565: CURSOR shipping_cost_cur(
2566: l_rollup_id IN NUMBER,
2567: l_inventory_item_id IN NUMBER,

Line 2617: RAISE STANDARD_ERROR;

2613: x_err_buf
2614: );
2615:
2616: IF (x_err_code <> 0) THEN
2617: RAISE STANDARD_ERROR;
2618: NULL;
2619: END IF;
2620: l_stmt_num := 30;
2621:

Line 2669: STANDARD_ERROR EXCEPTION;

2665: l_curr_rowid ROWID;
2666: l_site_id NUMBER;
2667: l_ship_method NUMBER;
2668: default_cost_type_id NUMBER;
2669: STANDARD_ERROR EXCEPTION;
2670:
2671: CURSOR vendors_cur( l_rollup_id IN NUMBER,
2672: l_inventory_item_id IN NUMBER,
2673: l_dest_organization_id IN NUMBER,

Line 2717: RAISE STANDARD_ERROR;

2713: );
2714:
2715: IF (x_err_code <> 0) THEN
2716: NULL;
2717: RAISE STANDARD_ERROR;
2718: END IF;
2719:
2720: UPDATE CST_SC_SOURCING_RULES CSSR
2721: SET CSSR.ITEM_COST = l_buy_cost,