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_NEW dependencies on OE_UPG_SO_NEW

Line 1: PACKAGE BODY OE_UPG_SO_NEW as

1: PACKAGE BODY OE_UPG_SO_NEW as
2: /* $Header: OEXNUSOB.pls 120.4 2007/11/20 13:18:26 amallik ship $ */
3:
4:
5: G_EXC_INVALID_ORDER_CATEGORY Exception;

Line 566: OE_UPG_SO_NEW.Upgrade_Insert_Lines_History;

562: g_canc_rec.can_attribute15 := mcan.attribute15;
563: -- G_canc_rec := mcan;
564: -- dbms_output.put_line('Ins cancellations');
565: G_ORD_CANC_FLAG := 'Y';
566: OE_UPG_SO_NEW.Upgrade_Insert_Lines_History;
567: G_ORD_CANC_FLAG := 'N';
568: end loop; /* end loop for Cancellations */
569: G_ERROR_LOCATION := 6;
570: End Upgrade_Cancellations;

Line 861: l_qp_upg_line_rec OE_UPG_SO_NEW.LINE_REC_TYPE;

857: v_actual_ordered_quantity number;
858: r_pto_m_c_k boolean := FALSE;
859: r_upgraded_flag varchar2(1):= null;
860: --to pass this record structure to QP
861: l_qp_upg_line_rec OE_UPG_SO_NEW.LINE_REC_TYPE;
862: --
863: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
864: --
865: begin

Line 2737: OE_UPG_SO_NEW.Upgrade_Insert_Upgrade_Log;

2733:
2734: G_Log_Rec.New_Line_Number := g_line_rec.line_number;
2735: G_Log_Rec.mtl_sales_order_id := g_mtl_sales_order_id;
2736:
2737: OE_UPG_SO_NEW.Upgrade_Insert_Upgrade_Log;
2738:
2739: g_log_rec.comments := NULL;
2740:
2741: begin

Line 2760: OE_UPG_SO_NEW.upgrade_insert_errors

2756: where oe_order_line_id = g_old_line_id;
2757: END IF;
2758: exception
2759: when others then
2760: OE_UPG_SO_NEW.upgrade_insert_errors
2761: (
2762: L_header_id => g_header_id,
2763: L_comments => 'Updating RCV shipment failed for line :'
2764: ||to_char(g_old_line_id)||' with oracle error ORA-'

Line 2781: OE_UPG_SO_NEW.Upgrade_Price_Adjustments

2777:
2778: IF ( (g_line_rec.item_type_code <> 'INCLUDED' )
2779: AND (g_line_rec.item_type_code <> 'CONFIG') ) THEN
2780:
2781: OE_UPG_SO_NEW.Upgrade_Price_Adjustments
2782: ( L_level_flag => 'L');
2783:
2784: END IF;
2785:

Line 2789: OE_UPG_SO_NEW.Upgrade_Sales_Credits

2785:
2786: END IF;
2787:
2788: /* ========== Line Level Sales Credits =========== */
2789: OE_UPG_SO_NEW.Upgrade_Sales_Credits
2790: ( L_level_flag => 'L');
2791:
2792: if OE_UPG_SO_NEW.G_HDR_CANC_FLAG = 'Y' then
2793: G_ERROR_LOCATION := 710;

Line 2792: if OE_UPG_SO_NEW.G_HDR_CANC_FLAG = 'Y' then

2788: /* ========== Line Level Sales Credits =========== */
2789: OE_UPG_SO_NEW.Upgrade_Sales_Credits
2790: ( L_level_flag => 'L');
2791:
2792: if OE_UPG_SO_NEW.G_HDR_CANC_FLAG = 'Y' then
2793: G_ERROR_LOCATION := 710;
2794: g_canc_rec := g_hdr_canc_rec;
2795: G_ORD_CANC_FLAG := 'N';
2796: OE_UPG_SO_NEW.Upgrade_Insert_Lines_History;

Line 2796: OE_UPG_SO_NEW.Upgrade_Insert_Lines_History;

2792: if OE_UPG_SO_NEW.G_HDR_CANC_FLAG = 'Y' then
2793: G_ERROR_LOCATION := 710;
2794: g_canc_rec := g_hdr_canc_rec;
2795: G_ORD_CANC_FLAG := 'N';
2796: OE_UPG_SO_NEW.Upgrade_Insert_Lines_History;
2797: end if;
2798:
2799: if v_bal_return_quantity <= 0 or v_line_exit_flag = 1 then
2800: exit;

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

2802:
2803: end loop; /* extra loop for returns */
2804:
2805: /* ========== Line Level Cancellations =========== */
2806: /* if nvl(mol.cancelled_quantity,0) > 0 and OE_UPG_SO_NEW.G_HDR_CANC_FLAG <> 'Y' then */
2807:
2808: if g_line_id_Change_flag = 'Y' then
2809: if nvl(mol.cancelled_quantity,0) > 0 then
2810: OE_UPG_SO_NEW.Upgrade_Cancellations ;

Line 2810: OE_UPG_SO_NEW.Upgrade_Cancellations ;

2806: /* if nvl(mol.cancelled_quantity,0) > 0 and OE_UPG_SO_NEW.G_HDR_CANC_FLAG <> 'Y' then */
2807:
2808: if g_line_id_Change_flag = 'Y' then
2809: if nvl(mol.cancelled_quantity,0) > 0 then
2810: OE_UPG_SO_NEW.Upgrade_Cancellations ;
2811: end if;
2812: end if;
2813:
2814: end loop; /* end loop for Order lines*/

Line 2968: OE_UPG_SO_NEW.upgrade_insert_errors

2964: /* where nvl(alloted_flag,'N') = 'N' */
2965:
2966: exception
2967: when no_data_found then
2968: OE_UPG_SO_NEW.upgrade_insert_errors
2969: (
2970: L_header_id => 0,
2971: L_comments => 'FYI Only: Parallel process of Sales Order Upgrade not used for the slab:'||to_char(L_slab)
2972: );

Line 2981: OE_UPG_SO_NEW.g_earliest_schedule_limit :=

2977: end;
2978:
2979: commit_counter := 0;
2980:
2981: OE_UPG_SO_NEW.g_earliest_schedule_limit :=
2982: to_number(FND_PROFILE.VALUE('OE_SCHEDULE_DATE_WINDOW'));
2983:
2984: OE_UPG_SO_NEW.g_latest_schedule_limit := OE_UPG_SO_NEW.g_earliest_schedule_limit;
2985:

Line 2984: OE_UPG_SO_NEW.g_latest_schedule_limit := OE_UPG_SO_NEW.g_earliest_schedule_limit;

2980:
2981: OE_UPG_SO_NEW.g_earliest_schedule_limit :=
2982: to_number(FND_PROFILE.VALUE('OE_SCHEDULE_DATE_WINDOW'));
2983:
2984: OE_UPG_SO_NEW.g_latest_schedule_limit := OE_UPG_SO_NEW.g_earliest_schedule_limit;
2985:
2986: v_source_code_profile_value := fnd_profile.value('SO_SOURCE_CODE');
2987:
2988: --5302907: Ref. to old sys. param table commented

Line 3401: OE_UPG_SO_NEW.G_Earliest_Schedule_Limit, /* EARLIEST_SCHEDULE_LIMIT */

3397: moh.global_attribute18, /* GLOBAL_ATTRIBUTE18 */
3398: moh.global_attribute19, /* GLOBAL_ATTRIBUTE19 */
3399: moh.global_attribute20, /* GLOBAL_ATTRIBUTE20 */
3400: 'SHIP', /* ORDER_DATE_TYPE_CODE */
3401: OE_UPG_SO_NEW.G_Earliest_Schedule_Limit, /* EARLIEST_SCHEDULE_LIMIT */
3402: OE_UPG_SO_NEW.G_Latest_Schedule_Limit, /* LATEST_SCHEDULE_LIMIT */
3403: moh.payment_type_code, /* PAYMENT_TYPE_CODE */
3404: moh.payment_amount, /* PAYMENT_AMOUNT */
3405: moh.check_number, /* CHECK_NUMBER */

Line 3402: OE_UPG_SO_NEW.G_Latest_Schedule_Limit, /* LATEST_SCHEDULE_LIMIT */

3398: moh.global_attribute19, /* GLOBAL_ATTRIBUTE19 */
3399: moh.global_attribute20, /* GLOBAL_ATTRIBUTE20 */
3400: 'SHIP', /* ORDER_DATE_TYPE_CODE */
3401: OE_UPG_SO_NEW.G_Earliest_Schedule_Limit, /* EARLIEST_SCHEDULE_LIMIT */
3402: OE_UPG_SO_NEW.G_Latest_Schedule_Limit, /* LATEST_SCHEDULE_LIMIT */
3403: moh.payment_type_code, /* PAYMENT_TYPE_CODE */
3404: moh.payment_amount, /* PAYMENT_AMOUNT */
3405: moh.check_number, /* CHECK_NUMBER */
3406: moh.credit_card_code, /* CREDIT_CARD_CODE */

Line 3537: OE_UPG_SO_NEW.Upgrade_Create_Order_Lines;

3533:
3534: /* ============ Order Lines Creation ===========*/
3535:
3536: G_LINE_ID := NULL;
3537: OE_UPG_SO_NEW.Upgrade_Create_Order_Lines;
3538:
3539: /* ============ Line Sets Creation (ontupg46.sql )=======*/
3540: -- bug fix 1759900
3541: IF G_OPEN_ATO_MODEL = 1 THEN

Line 3542: OE_UPG_SO_NEW.Insert_Multiple_Models;

3538:
3539: /* ============ Line Sets Creation (ontupg46.sql )=======*/
3540: -- bug fix 1759900
3541: IF G_OPEN_ATO_MODEL = 1 THEN
3542: OE_UPG_SO_NEW.Insert_Multiple_Models;
3543: END IF;
3544:
3545: /* ============ Line Sets Creation (ontupg16.sql )=======*/
3546:

Line 3549: OE_UPG_SO_NEW.Upgrade_Create_Line_Sets;

3545: /* ============ Line Sets Creation (ontupg16.sql )=======*/
3546:
3547: -- Changed to conditional execution on 10/23/01 by stsukuma
3548: IF G_OPEN_FLAG = 'Y' THEN
3549: OE_UPG_SO_NEW.Upgrade_Create_Line_Sets;
3550: END IF;
3551:
3552: /* ============ Updates After Creation =======*/
3553:

Line 3554: OE_UPG_SO_NEW.Update_After_Insert;

3550: END IF;
3551:
3552: /* ============ Updates After Creation =======*/
3553:
3554: OE_UPG_SO_NEW.Update_After_Insert;
3555:
3556: /* ============ Update Remnant Flag(ontupg53) =======*/
3557:
3558: IF G_OPEN_FLAG = 'Y' THEN

Line 3560: OE_UPG_SO_NEW.Update_remnant_flag;

3556: /* ============ Update Remnant Flag(ontupg53) =======*/
3557:
3558: IF G_OPEN_FLAG = 'Y' THEN
3559:
3560: OE_UPG_SO_NEW.Update_remnant_flag;
3561: END IF;
3562:
3563: /* ============ Updates for Returns =======*/
3564:

Line 3571: OE_UPG_SO_NEW.Upgrade_Sales_Credits

3567: Return_Fulfillment_Sets(G_HEADER_ID);
3568: END IF;
3569:
3570: /* ============ Header Level Sales Credits ===========*/
3571: OE_UPG_SO_NEW.Upgrade_Sales_Credits
3572: ( L_level_flag => 'H');
3573:
3574: /* ============ Header Level Price Adjustments ===========*/
3575: OE_UPG_SO_NEW.Upgrade_Price_Adjustments ( L_level_flag => 'H');

Line 3575: OE_UPG_SO_NEW.Upgrade_Price_Adjustments ( L_level_flag => 'H');

3571: OE_UPG_SO_NEW.Upgrade_Sales_Credits
3572: ( L_level_flag => 'H');
3573:
3574: /* ============ Header Level Price Adjustments ===========*/
3575: OE_UPG_SO_NEW.Upgrade_Price_Adjustments ( L_level_flag => 'H');
3576:
3577: /* ============ Upgrade Log Handling ===========*/
3578:
3579: g_log_rec := NULL;

Line 3583: OE_UPG_SO_NEW.Upgrade_Insert_Upgrade_Log;

3579: g_log_rec := NULL;
3580: g_log_rec.header_id := g_header_id;
3581: g_log_rec.mtl_sales_order_id := g_mtl_sales_order_id;
3582:
3583: OE_UPG_SO_NEW.Upgrade_Insert_Upgrade_Log;
3584:
3585: Update SO_HEADERS_ALL
3586: set upgrade_flag = 'Y'
3587: where header_id = G_HEADER_ID;

Line 3595: OE_UPG_SO_NEW.upgrade_insert_errors

3591: if G_ERROR_ALERT = 'Y' then
3592: G_ERROR_LOCATION := 11;
3593: ROLLBACK TO HEADER_SAVE_POINT;
3594: v_error_code := sqlcode;
3595: OE_UPG_SO_NEW.upgrade_insert_errors
3596: (
3597: L_header_id => g_header_id,
3598: L_comments => 'Exception tapped: Alert level = '
3599: ||to_char(G_ERROR_LOCATION)||' Code -'

Line 3612: OE_UPG_SO_NEW.upgrade_insert_errors

3608: end if;
3609: exception
3610: when G_EXC_INVALID_COPY_SOURCE THEN
3611: ROLLBACK TO HEADER_SAVE_POINT;
3612: OE_UPG_SO_NEW.upgrade_insert_errors
3613: ( L_header_id => G_HEADER_ID,
3614: L_comments => G_ERROR_MESSAGE
3615: );
3616: Mark_Order_As_Non_Updatable(G_HEADER_ID);

Line 3622: OE_UPG_SO_NEW.upgrade_insert_errors

3618: commit_counter := 0;
3619: G_ERROR_ALERT := 'N';
3620: when G_EXC_INVALID_INTERNAL_SOURCE THEN
3621: ROLLBACK TO HEADER_SAVE_POINT;
3622: OE_UPG_SO_NEW.upgrade_insert_errors
3623: ( L_header_id => G_HEADER_ID,
3624: L_comments => G_ERROR_MESSAGE
3625: );
3626: Mark_Order_As_Non_Updatable(G_HEADER_ID);

Line 3632: OE_UPG_SO_NEW.upgrade_insert_errors

3628: commit_counter := 0;
3629: G_ERROR_ALERT := 'N';
3630: when G_EXC_INVALID_SOURCE_CODE THEN
3631: ROLLBACK TO HEADER_SAVE_POINT;
3632: OE_UPG_SO_NEW.upgrade_insert_errors
3633: ( L_header_id => G_HEADER_ID,
3634: L_comments => G_ERROR_MESSAGE
3635: );
3636: Mark_Order_As_Non_Updatable(G_HEADER_ID);

Line 3642: OE_UPG_SO_NEW.upgrade_insert_errors

3638: commit_counter := 0;
3639: G_ERROR_ALERT := 'N';
3640: when G_EXC_INVALID_ORDER_CATEGORY THEN
3641: ROLLBACK TO HEADER_SAVE_POINT;
3642: OE_UPG_SO_NEW.upgrade_insert_errors
3643: ( L_header_id => G_HEADER_ID,
3644: L_comments => G_ERROR_MESSAGE
3645: );
3646: Mark_Order_As_Non_Updatable(G_HEADER_ID);

Line 3652: OE_UPG_SO_NEW.upgrade_insert_errors

3648: commit_counter := 0;
3649: G_ERROR_ALERT := 'N';
3650: when G_EXC_INVALID_RMA_REFERENCE THEN
3651: ROLLBACK TO HEADER_SAVE_POINT;
3652: OE_UPG_SO_NEW.upgrade_insert_errors
3653: ( L_header_id => G_HEADER_ID,
3654: L_comments => G_ERROR_MESSAGE
3655: );
3656: Mark_Order_As_Non_Updatable(G_HEADER_ID);

Line 3662: OE_UPG_SO_NEW.upgrade_insert_errors

3658: commit_counter := 0;
3659: G_ERROR_ALERT := 'N';
3660: when G_EXC_INVALID_ORIGSYS_LINEREF THEN
3661: ROLLBACK TO HEADER_SAVE_POINT;
3662: OE_UPG_SO_NEW.upgrade_insert_errors
3663: ( L_header_id => G_HEADER_ID,
3664: L_comments => G_ERROR_MESSAGE
3665: );
3666: Mark_Order_As_Non_Updatable(G_HEADER_ID);

Line 3672: OE_UPG_SO_NEW.upgrade_insert_errors

3668: commit_counter := 0;
3669: G_ERROR_ALERT := 'N';
3670: when G_EXC_INVALID_SRC_DOC_LINE THEN
3671: ROLLBACK TO HEADER_SAVE_POINT;
3672: OE_UPG_SO_NEW.upgrade_insert_errors
3673: ( L_header_id => G_HEADER_ID,
3674: L_comments => G_ERROR_MESSAGE
3675: );
3676: Mark_Order_As_Non_Updatable(G_HEADER_ID);

Line 3684: OE_UPG_SO_NEW.upgrade_insert_errors

3680: when others then
3681: /* G_ERROR_LOCATION := 12; */
3682: ROLLBACK TO HEADER_SAVE_POINT;
3683: v_error_code := sqlcode;
3684: OE_UPG_SO_NEW.upgrade_insert_errors
3685: (
3686: L_header_id => G_HEADER_ID,
3687: L_comments => 'Exception tapped: Exception level ='
3688: ||to_char(G_ERROR_LOCATION)||'code -'

Line 4448: OE_UPG_SO_NEW.Upgrade_Insert_Distbn_Record

4444: end;
4445:
4446: if v_total_headers < 500 or l_total_slabs = 1 then
4447:
4448: OE_UPG_SO_NEW.Upgrade_Insert_Distbn_Record
4449: (
4450: L_slab => 1,
4451: L_start_header_id => v_min_header,
4452: L_end_Header_id => v_max_header,

Line 4480: OE_UPG_SO_NEW.Upgrade_Insert_Distbn_Record

4476:
4477: if v_counter = v_gap and v_slab_count < v_total_slabs then
4478: v_max_header := MRdis.header_id;
4479:
4480: OE_UPG_SO_NEW.Upgrade_Insert_Distbn_Record
4481: (
4482: L_slab => v_slab_count,
4483: L_start_header_id => v_min_header,
4484: L_end_Header_id => v_max_header,

Line 4495: OE_UPG_SO_NEW.Upgrade_Insert_Distbn_Record

4491:
4492: end loop;
4493: v_max_header := v_dis_header_id;
4494:
4495: OE_UPG_SO_NEW.Upgrade_Insert_Distbn_Record
4496: (
4497: L_slab => v_slab_count,
4498: L_start_header_id => v_min_header,
4499: L_end_Header_id => v_max_header ,

Line 4566: oe_upg_so_new.upgrade_insert_distbn_record

4562: NULL;
4563:
4564: ELSIF l_row_count < 500 OR l_total_slabs = 1 THEN
4565:
4566: oe_upg_so_new.upgrade_insert_distbn_record
4567: (
4568: l_slab => 1,
4569: l_start_header_id => l_min_id,
4570: l_end_header_id => l_max_id,

Line 4585: oe_upg_so_new.upgrade_insert_distbn_record

4581:
4582: IF (l_record_counter = l_records_per_slab
4583: AND l_current_slab < l_total_slabs) THEN
4584:
4585: oe_upg_so_new.upgrade_insert_distbn_record
4586: (
4587: l_slab => l_current_slab,
4588: l_start_header_id => l_starting_id,
4589: l_end_header_id => l_line_service_detail_id,

Line 4616: oe_upg_so_new.upgrade_insert_distbn_record

4612: END LOOP;
4613:
4614: IF l_record_counter <> 0 THEN
4615:
4616: oe_upg_so_new.upgrade_insert_distbn_record
4617: (
4618: l_slab => l_current_slab,
4619: l_start_header_id => l_starting_id,
4620: l_end_header_id => l_max_id,

Line 4690: OE_UPG_SO_NEW.Upgrade_Insert_Distbn_Record

4686: end;
4687:
4688: if v_total_sources < 500 or l_total_slabs = 1 then
4689:
4690: OE_UPG_SO_NEW.Upgrade_Insert_Distbn_Record
4691: (
4692: L_slab => 1,
4693: L_start_header_id => v_min_source,
4694: L_end_Header_id => v_max_source,

Line 4722: OE_UPG_SO_NEW.Upgrade_Insert_Distbn_Record

4718:
4719: if v_counter = v_gap and v_slab_count < v_total_slabs then
4720: v_max_source := MRdis.hold_source_id;
4721:
4722: OE_UPG_SO_NEW.Upgrade_Insert_Distbn_Record
4723: (
4724: L_slab => v_slab_count,
4725: L_start_header_id => v_min_source,
4726: L_end_Header_id => v_max_source,

Line 4737: OE_UPG_SO_NEW.Upgrade_Insert_Distbn_Record

4733:
4734: end loop;
4735: v_max_source := v_dis_hold_source_id;
4736:
4737: OE_UPG_SO_NEW.Upgrade_Insert_Distbn_Record
4738: (
4739: L_slab => v_slab_count,
4740: L_start_header_id => v_min_source,
4741: L_end_Header_id => v_max_source ,

Line 4806: OE_UPG_SO_NEW.Upgrade_Insert_Distbn_Record

4802: END;
4803:
4804: IF v_total_headers < 500 or l_total_slabs = 1 then
4805:
4806: OE_UPG_SO_NEW.Upgrade_Insert_Distbn_Record
4807: (
4808: L_slab => 1,
4809: L_start_header_id => v_min_header,
4810: L_end_Header_id => v_max_header,

Line 4837: OE_UPG_SO_NEW.Upgrade_Insert_Distbn_Record

4833:
4834: IF v_counter = v_gap and v_slab_count < v_total_slabs then
4835: v_max_header := C1.freight_charge_id;
4836:
4837: OE_UPG_SO_NEW.Upgrade_Insert_Distbn_Record
4838: (
4839: L_slab => v_slab_count,
4840: L_start_header_id => v_min_header,
4841: L_end_Header_id => v_max_header,

Line 4852: OE_UPG_SO_NEW.Upgrade_Insert_Distbn_Record

4848:
4849: END LOOP;
4850: v_max_header := v_dis_header_id;
4851:
4852: OE_UPG_SO_NEW.Upgrade_Insert_Distbn_Record
4853: (
4854: L_slab => v_slab_count,
4855: L_start_header_id => v_min_header,
4856: L_end_Header_id => v_max_header ,

Line 5232: OE_UPG_SO_NEW.upgrade_insert_errors

5228: CLOSE model_lines;
5229:
5230: exception
5231: when others then
5232: OE_UPG_SO_NEW.upgrade_insert_errors
5233: ( L_header_id => g_header_id,
5234: L_comments => 'Update_Remnant_Flag failed on ora error: '||to_char(sqlcode)
5235: );
5236: raise;

Line 5477: OE_UPG_SO_NEW.Upgrade_Insert_Errors(

5473: CLOSE service_product_lines;
5474:
5475: EXCEPTION
5476: WHEN NO_DATA_FOUND THEN
5477: OE_UPG_SO_NEW.Upgrade_Insert_Errors(
5478: G_HEADER_ID,
5479: 'FYI Only: Service Ref.Line id not updated in OM for Line '
5480: ||to_char(l_new_line_id2));
5481:

Line 5789: OE_UPG_SO_NEW.Upgrade_Insert_Errors(

5785: EXCEPTION
5786:
5787: WHEN NO_DATA_FOUND THEN
5788:
5789: OE_UPG_SO_NEW.Upgrade_Insert_Errors(
5790: G_HEADER_ID,
5791: 'FYI Only: Service Ref information not updated since parent line does not exist'
5792: ||to_char(l_update_index));
5793:

Line 5838: OE_UPG_SO_NEW.upgrade_insert_errors

5834: NULL;
5835:
5836: exception
5837: when others then
5838: OE_UPG_SO_NEW.upgrade_insert_errors
5839: ( L_header_id => g_header_id,
5840: L_comments => 'Update_After_Insert failed on ora error: '||to_char(sqlcode)
5841: );
5842: raise;

Line 6120: OE_UPG_SO_NEW.upgrade_insert_errors

6116: */
6117: end loop;
6118: exception
6119: when others then
6120: OE_UPG_SO_NEW.upgrade_insert_errors
6121: ( L_header_id => g_header_id,
6122: L_comments => 'Line set updation failed on ora error: '||to_char(sqlcode)
6123: );
6124: raise;

Line 6498: OE_UPG_SO_NEW.upgrade_insert_errors

6494: END LOOP;
6495: exception
6496: when others then
6497: v_error_code := sqlcode;
6498: OE_UPG_SO_NEW.upgrade_insert_errors
6499: ( L_header_id => g_header_id,
6500: L_comments => 'Exception insert_multiple_models: '
6501: ||'Error code -'
6502: ||to_char(v_error_code)

Line 8333: OE_UPG_SO_NEW.Upgrade_Insert_Upgrade_Log;

8329: g_log_rec.return_qty_available := null;
8330: G_Log_Rec.New_Line_Number := null;
8331: G_Log_Rec.mtl_sales_order_id := null; /* to check with Rupal if this is okay */
8332: g_log_rec.comments := 'Created through sub-program for Upgrade';
8333: OE_UPG_SO_NEW.Upgrade_Insert_Upgrade_Log;
8334:
8335: g_line_id := p_line_rec.line_id;
8336: g_header_id := p_line_rec.header_id;
8337:

Line 8353: OE_UPG_SO_NEW.Upgrade_Price_Adjustments

8349: /* ========== Price Adjustments =========== */
8350: IF ( (p_line_rec.item_type_code <> 'INCLUDED' )
8351: AND (p_line_rec.item_type_code <> 'CONFIG') ) THEN
8352:
8353: OE_UPG_SO_NEW.Upgrade_Price_Adjustments
8354: ( L_level_flag => 'L');
8355:
8356: END IF;
8357:

Line 8362: OE_UPG_SO_NEW.Upgrade_Sales_Credits

8358: END IF;
8359:
8360:
8361: /* ========== Sales Credits =========== */
8362: OE_UPG_SO_NEW.Upgrade_Sales_Credits
8363: ( L_level_flag => 'L');
8364:
8365: IF l_debug_level > 0 THEN
8366: oe_debug_pub.add( 'EXITING INSERT_ROW' , 1 ) ;

Line 8565: OE_UPG_SO_NEW.upgrade_insert_errors

8561: Insert_Return_Included_Items(l_line_id,'Process_Returns');
8562: Exception
8563: when others then
8564: v_error_code := sqlcode;
8565: OE_UPG_SO_NEW.upgrade_insert_errors
8566: ( L_header_id => l_header_id,
8567: L_comments => 'Exception in Process_Upgraded_Returns: '
8568: ||'Error code -'
8569: ||to_char(v_error_code)

Line 8820: OE_UPG_SO_NEW.upgrade_insert_errors

8816:
8817: exception
8818: when others then
8819: v_error_code := sqlcode;
8820: OE_UPG_SO_NEW.upgrade_insert_errors
8821: ( L_header_id => l_header_id,
8822: L_comments => 'Exception return_fulfillment_sets: '
8823: ||'Error code -'
8824: ||to_char(v_error_code)

Line 8953: End OE_UPG_SO_NEW;

8949:
8950: Exception When others then null;
8951: End;
8952:
8953: End OE_UPG_SO_NEW;