eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_UPG_SO dependencies on OE_UPG_SO

Line 1: PACKAGE BODY OE_Upg_SO as

1: PACKAGE BODY OE_Upg_SO as
2: /* $Header: OEXIUSOB.pls 120.1 2011/12/21 08:09:16 rmoharan noship $ */
3:
4:
5: Procedure Upgrade_Price_adjustments

Line 379: OE_Upg_SO.Upgrade_Insert_Lines_History;

375: G_canc_rec := NULL;
376: G_canc_rec := mcan;
377: -- dbms_output.put_line('Ins cancellations');
378: G_ORD_CANC_FLAG := 'Y';
379: OE_Upg_SO.Upgrade_Insert_Lines_History;
380: G_ORD_CANC_FLAG := 'N';
381: end loop; /* end loop for Cancellations */
382: G_ERROR_LOCATION := 6;
383: End Upgrade_Cancellations;

Line 857: oe_upg_so.upgrade_insert_errors

853: + G_EARLIEST_SCHEDULE_LIMIT;
854: exception
855: when others then
856: g_line_rec.latest_acceptable_date :=NULL;
857: oe_upg_so.upgrade_insert_errors
858: (
859: L_header_id => g_header_id,
860: L_comments => 'FYI Only: Line ID: '||to_char(g_old_line_id)
861: ||' had corrupted data in Date_requested_current field. Latest_acceptable_date is updated to NULL for all its new lines'

Line 2119: OE_UPG_SO.Upgrade_Insert_Upgrade_Log;

2115:
2116: G_Log_Rec.New_Line_Number := g_last_line_number;
2117: G_Log_Rec.mtl_sales_order_id := g_mtl_sales_order_id;
2118:
2119: OE_UPG_SO.Upgrade_Insert_Upgrade_Log;
2120:
2121: g_log_rec.comments := NULL;
2122:
2123: begin

Line 2142: oe_upg_so.upgrade_insert_errors

2138: where oe_order_line_id = g_old_line_id;
2139: END IF;
2140: exception
2141: when others then
2142: oe_upg_so.upgrade_insert_errors
2143: (
2144: L_header_id => g_header_id,
2145: L_comments => 'Updating RCV shipment failed for line :'
2146: ||to_char(g_old_line_id)||' with oracle error ORA-'

Line 2151: OE_Upg_SO.Upgrade_Sales_Credits

2147: ||to_char(sqlcode));
2148: end;
2149:
2150: /* ========== Line Level Sales Credits =========== */
2151: OE_Upg_SO.Upgrade_Sales_Credits
2152: ( L_level_flag => 'L');
2153:
2154: /* ========== Line Level Price Adjustments =========== */
2155: OE_Upg_SO.Upgrade_Price_Adjustments

Line 2155: OE_Upg_SO.Upgrade_Price_Adjustments

2151: OE_Upg_SO.Upgrade_Sales_Credits
2152: ( L_level_flag => 'L');
2153:
2154: /* ========== Line Level Price Adjustments =========== */
2155: OE_Upg_SO.Upgrade_Price_Adjustments
2156: ( L_level_flag => 'L');
2157:
2158: if OE_Upg_SO.G_HDR_CANC_FLAG = 'Y' then
2159: G_ERROR_LOCATION := 710;

Line 2158: if OE_Upg_SO.G_HDR_CANC_FLAG = 'Y' then

2154: /* ========== Line Level Price Adjustments =========== */
2155: OE_Upg_SO.Upgrade_Price_Adjustments
2156: ( L_level_flag => 'L');
2157:
2158: if OE_Upg_SO.G_HDR_CANC_FLAG = 'Y' then
2159: G_ERROR_LOCATION := 710;
2160: g_canc_rec := g_hdr_canc_rec;
2161: G_ORD_CANC_FLAG := 'N';
2162: OE_Upg_SO.Upgrade_Insert_Lines_History;

Line 2162: OE_Upg_SO.Upgrade_Insert_Lines_History;

2158: if OE_Upg_SO.G_HDR_CANC_FLAG = 'Y' then
2159: G_ERROR_LOCATION := 710;
2160: g_canc_rec := g_hdr_canc_rec;
2161: G_ORD_CANC_FLAG := 'N';
2162: OE_Upg_SO.Upgrade_Insert_Lines_History;
2163: end if;
2164:
2165: if v_bal_return_quantity <= 0 or v_line_exit_flag = 1 then
2166: exit;

Line 2172: /* if nvl(mol.cancelled_quantity,0) > 0 and OE_Upg_SO.G_HDR_CANC_FLAG <> 'Y' then */

2168:
2169: end loop; /* extra loop for returns */
2170:
2171: /* ========== Line Level Cancellations =========== */
2172: /* if nvl(mol.cancelled_quantity,0) > 0 and OE_Upg_SO.G_HDR_CANC_FLAG <> 'Y' then */
2173:
2174: if g_line_id_Change_flag = 'Y' then
2175: if nvl(mol.cancelled_quantity,0) > 0 then
2176: OE_Upg_SO.Upgrade_Cancellations ;

Line 2176: OE_Upg_SO.Upgrade_Cancellations ;

2172: /* if nvl(mol.cancelled_quantity,0) > 0 and OE_Upg_SO.G_HDR_CANC_FLAG <> 'Y' then */
2173:
2174: if g_line_id_Change_flag = 'Y' then
2175: if nvl(mol.cancelled_quantity,0) > 0 then
2176: OE_Upg_SO.Upgrade_Cancellations ;
2177: end if;
2178: end if;
2179:
2180: end loop; /* end loop for Order lines*/

Line 2331: oe_upg_so.upgrade_insert_errors

2327: and nvl(line_type,'O') = L_line_type */
2328:
2329: exception
2330: when no_data_found then
2331: oe_upg_so.upgrade_insert_errors
2332: (
2333: L_header_id => 0,
2334: L_comments => 'FYI Only: Parallel process of Sales Order Upgrade not used for the slab:'||to_char(L_slab)
2335: );

Line 2344: OE_Upg_SO.g_earliest_schedule_limit :=

2340: end;
2341:
2342: commit_counter := 0;
2343:
2344: OE_Upg_SO.g_earliest_schedule_limit :=
2345: to_number(FND_PROFILE.VALUE('OE_SCHEDULE_DATE_WINDOW'));
2346:
2347: OE_Upg_SO.g_latest_schedule_limit := OE_Upg_SO.g_earliest_schedule_limit;
2348:

Line 2347: OE_Upg_SO.g_latest_schedule_limit := OE_Upg_SO.g_earliest_schedule_limit;

2343:
2344: OE_Upg_SO.g_earliest_schedule_limit :=
2345: to_number(FND_PROFILE.VALUE('OE_SCHEDULE_DATE_WINDOW'));
2346:
2347: OE_Upg_SO.g_latest_schedule_limit := OE_Upg_SO.g_earliest_schedule_limit;
2348:
2349: v_source_code_profile_value := fnd_profile.value('SO_SOURCE_CODE');
2350: v_auto_source_code := NULL;
2351:

Line 2672: OE_Upg_SO.G_Earliest_Schedule_Limit, /* EARLIEST_SCHEDULE_LIMIT */

2668: moh.global_attribute18, /* GLOBAL_ATTRIBUTE18 */
2669: moh.global_attribute19, /* GLOBAL_ATTRIBUTE19 */
2670: moh.global_attribute20, /* GLOBAL_ATTRIBUTE20 */
2671: 'SHIP', /* ORDER_DATE_TYPE_CODE */
2672: OE_Upg_SO.G_Earliest_Schedule_Limit, /* EARLIEST_SCHEDULE_LIMIT */
2673: OE_Upg_SO.G_Latest_Schedule_Limit, /* LATEST_SCHEDULE_LIMIT */
2674: moh.payment_type_code, /* PAYMENT_TYPE_CODE */
2675: moh.payment_amount, /* PAYMENT_AMOUNT */
2676: moh.check_number, /* CHECK_NUMBER */

Line 2673: OE_Upg_SO.G_Latest_Schedule_Limit, /* LATEST_SCHEDULE_LIMIT */

2669: moh.global_attribute19, /* GLOBAL_ATTRIBUTE19 */
2670: moh.global_attribute20, /* GLOBAL_ATTRIBUTE20 */
2671: 'SHIP', /* ORDER_DATE_TYPE_CODE */
2672: OE_Upg_SO.G_Earliest_Schedule_Limit, /* EARLIEST_SCHEDULE_LIMIT */
2673: OE_Upg_SO.G_Latest_Schedule_Limit, /* LATEST_SCHEDULE_LIMIT */
2674: moh.payment_type_code, /* PAYMENT_TYPE_CODE */
2675: moh.payment_amount, /* PAYMENT_AMOUNT */
2676: moh.check_number, /* CHECK_NUMBER */
2677: moh.credit_card_code, /* CREDIT_CARD_CODE */

Line 2771: OE_Upg_SO.Upgrade_Create_Order_Lines;

2767:
2768: /* ============ Order Lines Creation ===========*/
2769:
2770: G_LINE_ID := NULL;
2771: OE_Upg_SO.Upgrade_Create_Order_Lines;
2772:
2773: /* ============ Header Level Sales Credits ===========*/
2774: OE_Upg_SO.Upgrade_Sales_Credits
2775: ( L_level_flag => 'H');

Line 2774: OE_Upg_SO.Upgrade_Sales_Credits

2770: G_LINE_ID := NULL;
2771: OE_Upg_SO.Upgrade_Create_Order_Lines;
2772:
2773: /* ============ Header Level Sales Credits ===========*/
2774: OE_Upg_SO.Upgrade_Sales_Credits
2775: ( L_level_flag => 'H');
2776:
2777: /* ============ Header Level Price Adjustments ===========*/
2778: OE_Upg_SO.Upgrade_Price_Adjustments ( L_level_flag => 'H');

Line 2778: OE_Upg_SO.Upgrade_Price_Adjustments ( L_level_flag => 'H');

2774: OE_Upg_SO.Upgrade_Sales_Credits
2775: ( L_level_flag => 'H');
2776:
2777: /* ============ Header Level Price Adjustments ===========*/
2778: OE_Upg_SO.Upgrade_Price_Adjustments ( L_level_flag => 'H');
2779:
2780: /* ============ Upgrade Log Handling ===========*/
2781:
2782: g_log_rec := NULL;

Line 2786: OE_UPG_SO.Upgrade_Insert_Upgrade_Log;

2782: g_log_rec := NULL;
2783: g_log_rec.header_id := g_header_id;
2784: g_log_rec.mtl_sales_order_id := g_mtl_sales_order_id;
2785:
2786: OE_UPG_SO.Upgrade_Insert_Upgrade_Log;
2787:
2788: Update SO_HEADERS_ALL
2789: set upgrade_flag = 'Y'
2790: where header_id = G_HEADER_ID;

Line 2798: oe_upg_so.upgrade_insert_errors

2794: if G_ERROR_ALERT = 'Y' then
2795: G_ERROR_LOCATION := 11;
2796: ROLLBACK TO HEADER_SAVE_POINT;
2797: v_error_code := sqlcode;
2798: oe_upg_so.upgrade_insert_errors
2799: (
2800: L_header_id => g_header_id,
2801: L_comments => 'Exception tapped: Alert level = '
2802: ||to_char(G_ERROR_LOCATION)||' Code -'

Line 2817: oe_upg_so.upgrade_insert_errors

2813: when others then
2814: /* G_ERROR_LOCATION := 12; */
2815: ROLLBACK TO HEADER_SAVE_POINT;
2816: v_error_code := sqlcode;
2817: oe_upg_so.upgrade_insert_errors
2818: (
2819: L_header_id => G_HEADER_ID,
2820: L_comments => 'Exception tapped: Exception level ='
2821: ||to_char(G_ERROR_LOCATION)||'code -'

Line 3589: OE_UPG_SO.Upgrade_Insert_Distbn_Record

3585: end;
3586:
3587: if v_total_headers < 5000 or l_total_slabs = 1 then
3588:
3589: OE_UPG_SO.Upgrade_Insert_Distbn_Record
3590: (
3591: L_slab => 1,
3592: L_start_header_id => v_min_header,
3593: L_end_Header_id => v_max_header,

Line 3621: OE_UPG_SO.Upgrade_Insert_Distbn_Record

3617:
3618: if v_counter = v_gap and v_slab_count < v_total_slabs then
3619: v_max_header := MRdis.header_id;
3620:
3621: OE_UPG_SO.Upgrade_Insert_Distbn_Record
3622: (
3623: L_slab => v_slab_count,
3624: L_start_header_id => v_min_header,
3625: L_end_Header_id => v_max_header,

Line 3636: OE_UPG_SO.Upgrade_Insert_Distbn_Record

3632:
3633: end loop;
3634: v_max_header := v_dis_header_id;
3635:
3636: OE_UPG_SO.Upgrade_Insert_Distbn_Record
3637: (
3638: L_slab => v_slab_count,
3639: L_start_header_id => v_min_header,
3640: L_end_Header_id => v_max_header ,

Line 3977: oe_upg_so.upgrade_insert_errors

3973:
3974: exception
3975: when others then
3976: rollback;
3977: oe_upg_so.upgrade_insert_errors
3978: (
3979: L_header_id => 0,
3980: L_comments => 'Line set updation failed on ora error: '||to_char(sqlcode)
3981: );

Line 4015: oe_upg_so.Upgrade_Insert_Errors(

4011: set service_reference_line_id = v_new_line_id
4012: where line_Id = c2.line_id;
4013: exception
4014: when no_data_found then
4015: oe_upg_so.Upgrade_Insert_Errors(
4016: c2.header_id,
4017: 'FYI Only: Service Ref.Line id not updated in OM for Line '
4018: ||to_char(c2.line_id)||
4019: 'as it is not found in Order Entry table');

Line 6059: OE_UPG_SO.Upgrade_Insert_Upgrade_Log;

6055: g_log_rec.return_qty_available := null;
6056: G_Log_Rec.New_Line_Number := null;
6057: G_Log_Rec.mtl_sales_order_id := null; /* to check with Rupal if this is okay */
6058: g_log_rec.comments := 'Created through sub-program for Upgrade';
6059: OE_UPG_SO.Upgrade_Insert_Upgrade_Log;
6060:
6061: g_line_id := p_line_rec.line_id;
6062: g_header_id := p_line_rec.header_id;
6063:

Line 6066: OE_Upg_SO.Upgrade_Price_Adjustments

6062: g_header_id := p_line_rec.header_id;
6063:
6064: /* ========== Price Adjustments =========== */
6065: IF p_apply_price_adj = 'Y' THEN
6066: OE_Upg_SO.Upgrade_Price_Adjustments
6067: ( L_level_flag => 'L');
6068: END IF;
6069:
6070: /* ========== Sales Credits =========== */

Line 6071: OE_Upg_SO.Upgrade_Sales_Credits

6067: ( L_level_flag => 'L');
6068: END IF;
6069:
6070: /* ========== Sales Credits =========== */
6071: OE_Upg_SO.Upgrade_Sales_Credits
6072: ( L_level_flag => 'L');
6073:
6074: IF l_debug_level > 0 THEN
6075: oe_debug_pub.add( 'EXITING INSERT_ROW' , 1 ) ;

Line 6279: oe_upg_so.upgrade_insert_errors

6275: exception
6276: when others then
6277: ROLLBACK TO R_SAVE_POINT;
6278: v_error_code := sqlcode;
6279: oe_upg_so.upgrade_insert_errors
6280: ( L_header_id => l_header_id,
6281: L_comments => 'Exception in Process_Upgraded_Returns: '
6282: ||'Error code -'
6283: ||to_char(v_error_code)

Line 6401: oe_upg_so.upgrade_insert_errors

6397: exception
6398: when others then
6399: ROLLBACK TO SAVE_POINT1;
6400: v_error_code := sqlcode;
6401: oe_upg_so.upgrade_insert_errors
6402: ( L_header_id => l_header_id,
6403: L_comments => 'Exception in Fix_Returns_Splits: '
6404: ||'Error code -'
6405: ||to_char(v_error_code)

Line 6425: End OE_Upg_SO;

6421: Commit;
6422:
6423: END Fix_Returns_Splits;
6424:
6425: End OE_Upg_SO;