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 2139: RAISE STANDARD_ERROR;

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

Line 2173: RAISE STANDARD_ERROR;

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

Line 2411: when STANDARD_ERROR then

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

Line 2438: STANDARD_ERROR EXCEPTION;

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

Line 2490: RAISE STANDARD_ERROR;

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

Line 2562: STANDARD_ERROR EXCEPTION;

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

Line 2616: RAISE STANDARD_ERROR;

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

Line 2668: STANDARD_ERROR EXCEPTION;

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

Line 2716: RAISE STANDARD_ERROR;

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