DBA Data[Home] [Help]

APPS.IBE_ORDER_SAVE_PVT dependencies on OE_GLOBALS

Line 374: x_line_rec.operation := OE_Globals.G_OPR_UPDATE;

370: x_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
371: x_line_rec.item_type_code := p_order_line_rec.item_type_code;
372: x_line_rec.ordered_quantity := p_order_line_rec.ordered_quantity + l_line_rec.ordered_quantity;
373: x_line_rec.line_id := l_line_rec.line_id;
374: x_line_rec.operation := OE_Globals.G_OPR_UPDATE;
375: else
376: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
377: Ibe_Util.Debug('MergeLines else part: No previous record');
378: end if;

Line 380: x_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;

376: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
377: Ibe_Util.Debug('MergeLines else part: No previous record');
378: end if;
379: x_line_rec := p_order_line_rec;
380: x_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
381: end if;
382: close c_get_lineInfo;
383:
384: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 486: l_order_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;

482: For i in 1..l_order_line_tbl.COUNT
483: LOOP
484:
485: IF (p_save_type = SAVE_NORMAL) THEN
486: l_order_line_tbl(i).operation := OE_GLOBALS.G_OPR_UPDATE;
487:
488: ELSIF (p_save_type = SAVE_ADDITEMS AND p_order_header_rec.ORDER_CATEGORY_CODE = 'RETURN') THEN
489:
490: -- salesrep_id

Line 499: IF (p_order_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN

495: l_salesrep_id := l_salesrep_inforec.salesrep_id;
496: end loop;
497: -- end if;
498:
499: IF (p_order_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE) THEN
500: MergeLines(p_header_id => p_order_header_rec.HEADER_ID,
501: p_order_line_rec => l_order_line_tbl(i),
502: x_line_rec => lx_line_rec);
503:

Line 514: IF (l_order_line_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE) THEN

510: /* The following IF LOOP would be executed when there is already an active pending Return And
511: the user is trying to add an item to it. So it will be 'UPDATE' at header level and
512: 'CREATE' at line level */
513:
514: IF (l_order_line_tbl(i).operation = OE_GLOBALS.G_OPR_CREATE) THEN
515: l_order_line_tbl(i).line_category_code := 'RETURN';
516: l_order_line_tbl(i).return_context := 'ORDER';
517: l_order_line_tbl(i).salesrep_id := l_salesrep_id;
518: l_order_line_tbl(i).source_document_type_id := 13; --iStore Account

Line 557: l_order_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;

553:
554: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
555: ibe_util.Debug('Inside Line Values Defaulting flow');
556: END IF;
557: l_order_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
558: l_order_line_tbl(i).line_category_code := 'RETURN';
559: l_order_line_tbl(i).return_context := 'ORDER';
560: l_order_line_tbl(i).salesrep_id := l_salesrep_id;
561: l_order_line_tbl(i).source_document_type_id := 13; --iStore Account

Line 595: l_order_line_tbl(i).operation := OE_GLOBALS.G_OPR_DELETE;

591:
592: END IF; -- headerrec.operation.operation ='update'
593:
594: ELSIF (p_save_type = SAVE_REMOVEITEMS) THEN
595: l_order_line_tbl(i).operation := OE_GLOBALS.G_OPR_DELETE;
596: END IF;
597:
598: End Loop;
599:

Line 736: x_order_header_rec.operation := OE_Globals.G_OPR_UPDATE;

732: FND_Message.Set_Name('IBE', 'IBE_ERR_OT_REFRESH_RETURN');
733: FND_Msg_Pub.Add;
734: RAISE FND_API.G_EXC_ERROR;
735: ELSE
736: x_order_header_rec.operation := OE_Globals.G_OPR_UPDATE;
737: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
738: Ibe_util.Debug('Return not booked loop: ' ||x_order_header_rec.operation);
739: END IF;
740: END IF;

Line 758: x_order_header_rec.operation := OE_Globals.G_OPR_CREATE;

754:
755: IF (p_save_type = SAVE_ADDITEMS) THEN
756:
757: x_order_header_rec.header_id := l_order_header_id;
758: x_order_header_rec.operation := OE_Globals.G_OPR_CREATE;
759:
760: /** -- As the flow is for CREATE do set the necessary attributes -- **/
761:
762: IF (x_order_header_rec.order_type_id is null OR

Line 852: x_order_header_rec.operation := OE_Globals.G_OPR_UPDATE;

848: x_order_header_rec.order_type_id = FND_API.G_MISS_NUM)
849: then
850: x_order_header_rec.order_type_id := l_ordertype_id;
851: end if;
852: x_order_header_rec.operation := OE_Globals.G_OPR_UPDATE;
853:
854: END IF; -- if order_header_id
855:
856: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 908: x_order_header_rec.operation := OE_Globals.G_OPR_DELETE;

904:
905: IF (x_order_header_rec.FLOW_STATUS_CODE in ('ENTERED','WORKING') AND
906: x_order_header_rec.ORDER_CATEGORY_CODE = 'RETURN') THEN
907:
908: x_order_header_rec.operation := OE_Globals.G_OPR_DELETE;
909: x_order_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
910:
911: ELSE
912: x_order_header_rec.operation := OE_Globals.G_OPR_UPDATE;

Line 912: x_order_header_rec.operation := OE_Globals.G_OPR_UPDATE;

908: x_order_header_rec.operation := OE_Globals.G_OPR_DELETE;
909: x_order_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
910:
911: ELSE
912: x_order_header_rec.operation := OE_Globals.G_OPR_UPDATE;
913: x_order_header_rec.cancelled_flag := 'Y';
914: -- x_order_header_rec.change_reasons := p_order_header_rec.change_reasons;
915: -- x_order_header_rec.change_comments := p_order_header_rec.change_comments;
916:

Line 1387: l_order_line_tbl(l_linetbl_count).operation := OE_Globals.G_OPR_UPDATE;

1383: end if;
1384: l_linetbl_count := l_linetbl_count +1;
1385: l_order_line_tbl(l_linetbl_count) := OE_Order_PUB.G_MISS_LINE_REC;
1386: l_order_line_tbl(l_linetbl_count).line_id := l_lineid;
1387: l_order_line_tbl(l_linetbl_count).operation := OE_Globals.G_OPR_UPDATE;
1388: l_order_line_tbl(l_linetbl_count).invoice_to_org_id := l_invoiceto_org_id;
1389: l_order_line_tbl(l_linetbl_count).ship_to_org_id := l_shipto_org_id;
1390: end loop;
1391: close lineid_tmp;

Line 1494: l_order_line_tbl(l_linetbl_count).OPERATION := OE_Globals.G_OPR_DELETE;

1490: loop
1491: l_linetbl_count := l_linetbl_count+1;
1492: l_order_line_tbl(l_linetbl_count) := OE_Order_PUB.G_MISS_LINE_REC;
1493: l_order_line_tbl(l_linetbl_count).LINE_ID := l_childlineid_rec.LINE_ID;
1494: l_order_line_tbl(l_linetbl_count).OPERATION := OE_Globals.G_OPR_DELETE;
1495: end loop;
1496: end if;
1497: end loop;
1498:

Line 1524: l_order_line_tbl(l_linetbl_count).OPERATION := OE_Globals.G_OPR_UPDATE;

1520: loop
1521: l_linetbl_count := l_linetbl_count+1;
1522: l_order_line_tbl(l_linetbl_count) := OE_Order_PUB.G_MISS_LINE_REC;
1523: l_order_line_tbl(l_linetbl_count).LINE_ID := l_childlineid_rec.LINE_ID;
1524: l_order_line_tbl(l_linetbl_count).OPERATION := OE_Globals.G_OPR_UPDATE;
1525:
1526: if(l_order_line_tbl(i).ORDERED_QUANTITY is not null
1527: AND l_order_line_tbl(i).ORDERED_QUANTITY <> FND_API.G_MISS_NUM)
1528: then

Line 1577: l_order_line_tbl(l_linetbl_count).OPERATION := OE_Globals.G_OPR_UPDATE;

1573: loop
1574: l_linetbl_count := l_linetbl_count+1;
1575: l_order_line_tbl(l_linetbl_count) := OE_Order_PUB.G_MISS_LINE_REC;
1576: l_order_line_tbl(l_linetbl_count).LINE_ID := l_childlineid_rec.LINE_ID;
1577: l_order_line_tbl(l_linetbl_count).OPERATION := OE_Globals.G_OPR_UPDATE;
1578:
1579: if(l_order_line_tbl(k).ship_to_contact_id is not null AND
1580: l_order_line_tbl(k).ship_to_contact_id <> FND_API.G_MISS_NUM) then
1581: l_order_line_tbl(l_linetbl_count).ship_to_contact_id

Line 2875: IF ((l_order_header_rec.operation = OE_Globals.G_OPR_CREATE) OR

2871: ,p_order_header_rec => l_order_header_rec
2872: ,p_save_type => p_save_type
2873: ,x_order_line_tbl => l_order_line_tbl
2874: );
2875: IF ((l_order_header_rec.operation = OE_Globals.G_OPR_CREATE) OR
2876: (p_billto_partysite_id is not null AND p_billto_partysite_id <> FND_API.G_MISS_NUM) OR
2877: (p_shipto_partysite_id is not null AND p_shipto_partysite_id <> FND_API.G_MISS_NUM))
2878: THEN
2879: DefaultHdrLineAddress(p_order_line_tbl => l_order_line_tbl

Line 2936: (l_order_header_rec.operation = OE_Globals.G_OPR_UPDATE) AND

2932: close cr_persontype;
2933:
2934:
2935: IF ((l_user_type = 'PERSON') AND
2936: (l_order_header_rec.operation = OE_Globals.G_OPR_UPDATE) AND
2937: (p_submit_control_rec.cancel_flag <> 'Y'))
2938: THEN
2939: IF (IBE_UTIL.G_DEBUGON = l_true) then
2940: Ibe_Util.DEBUG('calling SetLine ids API');

Line 2990: IF(l_order_header_rec.operation = OE_Globals.G_OPR_DELETE) THEN

2986: ibe_util.debug('after cancelorder header_id:' ||l_order_header_rec.header_id);
2987: ibe_util.debug('after cancelorder operation:' ||l_order_header_rec.operation);
2988: end if;
2989:
2990: IF(l_order_header_rec.operation = OE_Globals.G_OPR_DELETE) THEN
2991: l_cancel_flow := FND_API.G_TRUE;
2992: END IF;
2993:
2994: end if;

Line 3003: IF (l_order_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND

2999: -- This to propagate parent level changes to all children if a
3000: -- MDL item is updated/ removed.
3001: -- This is used currently by the Return-Flow-Orders alone.
3002:
3003: IF (l_order_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
3004: (p_submit_control_rec.submit_flag is null
3005: OR p_submit_control_rec.submit_flag = FND_API.G_MISS_CHAR))
3006: THEN
3007: IF l_order_header_rec.order_category_code = 'RETURN' then

Line 3038: if(l_order_line_tbl(lineIdx).operation=OE_GLOBALS.G_OPR_DELETE) THEN

3034: end if;
3035:
3036: for lineIdx in 1..l_order_line_tbl.count
3037: loop
3038: if(l_order_line_tbl(lineIdx).operation=OE_GLOBALS.G_OPR_DELETE) THEN
3039: p_dl_line_ids := p_dl_line_ids || ','||l_order_line_tbl(lineIdx).LINE_ID;
3040: end if;
3041: end loop;
3042:

Line 3069: IF(l_order_header_rec.operation = OE_Globals.G_OPR_DELETE) THEN

3065: ibe_util.debug('after Remove-Cancelorder header_id:' ||l_order_header_rec.header_id);
3066: ibe_util.debug('after Remove-cancelorder operation:' ||l_order_header_rec.operation);
3067: end if;
3068:
3069: IF(l_order_header_rec.operation = OE_Globals.G_OPR_DELETE) THEN
3070: l_cancel_flow := FND_API.G_TRUE;
3071: l_order_line_tbl := OE_ORDER_PUB.G_MISS_LINE_TBL;
3072: END IF;
3073: END IF; --No Of Existing Lines

Line 3144: (l_order_header_rec.operation = OE_Globals.G_OPR_UPDATE) AND

3140: -- For B2B flow, submit_order() could be called directly.
3141: -- Checking whether it is a B2C flow.
3142:
3143: IF ((l_user_type = 'PERSON') AND
3144: (l_order_header_rec.operation = OE_Globals.G_OPR_UPDATE) AND
3145: (p_submit_control_rec.cancel_flag <> 'Y')) THEN
3146:
3147: l_ProcessOrder_Flow := FND_API.G_TRUE;
3148: ELSIF ((l_user_type = 'PARTY_RELATIONSHIP') AND -- b2b user

Line 3149: (l_order_header_rec.operation = OE_Globals.G_OPR_UPDATE) AND

3145: (p_submit_control_rec.cancel_flag <> 'Y')) THEN
3146:
3147: l_ProcessOrder_Flow := FND_API.G_TRUE;
3148: ELSIF ((l_user_type = 'PARTY_RELATIONSHIP') AND -- b2b user
3149: (l_order_header_rec.operation = OE_Globals.G_OPR_UPDATE) AND
3150: (p_submit_control_rec.cancel_flag <> 'Y')) THEN
3151:
3152: /* bug 8303137, scnagara, Added this condition for a b2b user so that when quantity
3153: is updated in Review and Submit return page, and Submit Return is clicked, quantity needs

Line 3164: l_request_tbl(1).entity_code := OE_GLOBALS.G_ENTITY_HEADER;

3160: l_ProcessOrder_Flow := FND_API.G_FALSE;
3161: End If; --user_type ='Person'
3162:
3163: Else
3164: l_request_tbl(1).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
3165: l_request_tbl(1).request_type := OE_GLOBALS.G_BOOK_ORDER;
3166: End If;
3167:
3168: END IF; -- booking submitflag='Y'

Line 3165: l_request_tbl(1).request_type := OE_GLOBALS.G_BOOK_ORDER;

3161: End If; --user_type ='Person'
3162:
3163: Else
3164: l_request_tbl(1).entity_code := OE_GLOBALS.G_ENTITY_HEADER;
3165: l_request_tbl(1).request_type := OE_GLOBALS.G_BOOK_ORDER;
3166: End If;
3167:
3168: END IF; -- booking submitflag='Y'
3169:

Line 3498: l_control_rec OE_GLOBALS.Control_Rec_Type;

3494: l_order_header_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
3495: l_retplcy_orderhdr_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
3496: l_request_tbl OE_Order_PUB.Request_Tbl_Type := OE_Order_PUB.G_MISS_REQUEST_TBL;
3497: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
3498: l_control_rec OE_GLOBALS.Control_Rec_Type;
3499: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
3500: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
3501: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
3502: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;

Line 3587: l_order_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;

3583: END IF;
3584:
3585: -- SET HEADER RECORD
3586: l_order_header_rec := p_order_header_rec;
3587: l_order_header_rec.operation := OE_GLOBALS.G_OPR_CREATE;
3588: -- l_order_header_rec.flow_status_code := 'ENTERED';
3589: --l_order_header_rec.ORDER_CATEGORY_CODE := 'RETURN';
3590: l_order_type_id := FND_PROFILE.VALUE('IBE_RETURN_TRANSACTION_TYPE');
3591:

Line 3657: l_order_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;

3653: l_order_line_tbl(i).line_category_code := 'RETURN';
3654: l_order_line_tbl(i).return_context := 'ORDER';
3655: end if;
3656:
3657: l_order_line_tbl(i).operation := OE_GLOBALS.G_OPR_CREATE;
3658:
3659:
3660: -- ShipTo / InvoiceTo OrgIds.
3661: -- line level will always be defaulted from original order lines.

Line 3743: l_retplcy_orderhdr_rec.operation := OE_Globals.G_OPR_UPDATE;

3739: END IF;
3740:
3741: --SET HEADER RECORD
3742: l_retplcy_orderhdr_rec.header_id := lx_order_header_rec.header_id;
3743: l_retplcy_orderhdr_rec.operation := OE_Globals.G_OPR_UPDATE;
3744:
3745: -- SET CONTROL RECORD
3746: l_control_rec.controlled_operation := TRUE;
3747: l_control_rec.process_partial := TRUE;

Line 3781: , p_api_service_level => OE_GLOBALS.G_CHECK_SECURITY_ONLY

3777: , p_commit => FND_API.G_FALSE
3778: , x_return_status => x_return_status
3779: , x_msg_count => x_msg_count
3780: , x_msg_data => x_msg_data
3781: , p_api_service_level => OE_GLOBALS.G_CHECK_SECURITY_ONLY
3782: , p_control_rec => l_control_rec
3783: , p_header_rec => l_retplcy_orderhdr_rec
3784: , p_line_tbl => l_order_line_tbl
3785: , p_Action_Request_tbl => l_request_tbl

Line 3953: l_control_rec OE_GLOBALS.Control_Rec_Type;

3949:
3950: l_order_header_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
3951: l_order_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
3952: l_request_tbl OE_Order_PUB.Request_Tbl_Type := OE_Order_PUB.G_MISS_REQUEST_TBL;
3953: l_control_rec OE_GLOBALS.Control_Rec_Type;
3954: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
3955: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
3956: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
3957: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;

Line 4130: l_order_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

4126:
4127: end if;
4128:
4129: l_order_header_rec.header_id := p_order_header_id;
4130: l_order_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
4131: l_order_line_tbl(1) := OE_Order_PUB.G_MISS_LINE_REC;
4132: l_order_line_tbl(1).header_id := p_order_header_id;
4133: l_order_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
4134: l_order_line_tbl(1).line_id := p_order_line_id;

Line 4133: l_order_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

4129: l_order_header_rec.header_id := p_order_header_id;
4130: l_order_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
4131: l_order_line_tbl(1) := OE_Order_PUB.G_MISS_LINE_REC;
4132: l_order_line_tbl(1).header_id := p_order_header_id;
4133: l_order_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
4134: l_order_line_tbl(1).line_id := p_order_line_id;
4135:
4136: if(l_siteuse_billto = 'BILL_TO') then
4137: l_order_line_tbl(1).invoice_to_org_id := l_billto_acct_siteuse_id;