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_RETROBILL_PVT dependencies on OE_RETROBILL_PVT

Line 1: PACKAGE BODY OE_RETROBILL_PVT AS

1: PACKAGE BODY OE_RETROBILL_PVT AS
2: /* $Header: OEXVRTOB.pls 120.32 2011/11/17 06:48:45 nilegupt ship $ */
3:
4:
5: /*

Line 242: G_PKG_NAME VARCHAR2(30):='OE_RETROBILL_PVT';

238:
239:
240: G_CURRENT_RETROBILL_REQUEST_ID NUMBER;
241: G_LINES_NOT_RETRO_DISPLAYED VARCHAR2(1);
242: G_PKG_NAME VARCHAR2(30):='OE_RETROBILL_PVT';
243: --bug3738043
244: G_RETRO_PRICING_PHASE_COUNT NUMBER := 0;
245:
246: -- 3661895

Line 307: oe_debug_pub.add('Entering oe_retrobill_pvt.get_last_retro...input header_id:'||p_header_id);

303:
304: Begin
305:
306: If l_debug_level > 0 Then
307: oe_debug_pub.add('Entering oe_retrobill_pvt.get_last_retro...input header_id:'||p_header_id);
308: End If;
309:
310: --!!!Need to check system param, if no retrobill should return the same header_id immediately
311: --to save processing time!!!

Line 324: oe_debug_pub.add('Exiting oe_retrobill_pvt.get_last_retro...output header_id:'||x_header_id);

320: x_header_id:=l_retro_header_id;
321: END IF;
322:
323: If l_debug_level > 0 Then
324: oe_debug_pub.add('Exiting oe_retrobill_pvt.get_last_retro...output header_id:'||x_header_id);
325: End If;
326:
327: Exception
328: When Others then

Line 354: oe_debug_pub.add('Entering oe_retrobill_pvt.get_last_retro...input Line_id:'||p_line_id);

350: l_query_header_id Number;
351: Begin
352:
353: If l_debug_level > 0 Then
354: oe_debug_pub.add('Entering oe_retrobill_pvt.get_last_retro...input Line_id:'||p_line_id);
355: End If;
356:
357: --!!!Need to check system param, if no retrobill should return the same header_id immediately
358: --to save processing time!!!

Line 372: oe_debug_pub.add('Exiting oe_retrobill_pvt.get_last_retro...output line_id:'||x_line_id);

368: x_line_id:=l_retro_line_id;
369: END IF;
370:
371: If l_debug_level > 0 Then
372: oe_debug_pub.add('Exiting oe_retrobill_pvt.get_last_retro...output line_id:'||x_line_id);
373: End If;
374:
375: Exception
376: When Others then

Line 1379: oe_debug_pub.add('Execption occured in Oe_Retrobill_Pvt.Insert_Id:'||SQLERRM);

1375: END IF;
1376:
1377: Exception
1378: When Others Then
1379: oe_debug_pub.add('Execption occured in Oe_Retrobill_Pvt.Insert_Id:'||SQLERRM);
1380: Raise;
1381: End;
1382:
1383: /**************************************************************

Line 1395: oe_debug_pub.add('Enter procedure Oe_Retrobill_Pvt.Prepare_Line_Pricing_Attribs:');

1391: l_row_count NUMBER := 0;
1392: Begin
1393:
1394: -- query the attributes table OE_ORDER_PRICE_ATTRIBS and assign it to the record structure
1395: oe_debug_pub.add('Enter procedure Oe_Retrobill_Pvt.Prepare_Line_Pricing_Attribs:');
1396:
1397: SELECT
1398: pricing_context,
1399: pricing_attribute1,

Line 1648: oe_debug_pub.add('Exiting procedure Oe_Retrobill_Pvt.Prepare_Line_Pricing_Attribs:');

1644: l_row_count := SQL%ROWCOUNT;
1645: x_row_count := l_row_count;
1646:
1647: oe_debug_pub.add('Number of records: ' || l_row_count);
1648: oe_debug_pub.add('Exiting procedure Oe_Retrobill_Pvt.Prepare_Line_Pricing_Attribs:');
1649:
1650: Exception
1651:
1652: WHEN NO_DATA_FOUND THEN

Line 1657: oe_debug_pub.add('Execption occured in Oe_Retrobill_Pvt.Prepare_Line_Pricing_Attribs:'||SQLERRM);

1653: oe_debug_pub.add('Line pricing attributes not populated for the original Order');
1654: x_row_count := 0;
1655:
1656: When Others Then
1657: oe_debug_pub.add('Execption occured in Oe_Retrobill_Pvt.Prepare_Line_Pricing_Attribs:'||SQLERRM);
1658: Raise;
1659: End;
1660:
1661:

Line 3456: Oe_retrobill_Pvt.Delete_Order(lx_header_id, l_header_deleted);

3452: p_Line_price_Att_tbl => l_Line_price_Att_tbl, -- 8736629
3453: x_created_header_id=>lx_header_id,
3454: x_return_status =>lx_return_status);
3455: IF(lx_return_status=FND_API.G_RET_STS_SUCCESS and lx_header_id is not NULL) THEN
3456: Oe_retrobill_Pvt.Delete_Order(lx_header_id, l_header_deleted);
3457: --bug 12922209
3458: IF l_header_deleted THEN
3459: oe_debug_pub.ADD('Retro Order Header created has been deleted');
3460: --assiging 1 to ret_code to return warning

Line 3576: oe_retrobill_pvt.delete_order(lx_header_id, l_header_deleted); --bug5003256

3572: p_Line_price_Att_tbl => l_Line_price_Att_tbl, -- 8736629
3573: x_created_header_id=>lx_header_id,
3574: x_return_status=>lx_return_status);
3575: IF(lx_return_status=FND_API.G_RET_STS_SUCCESS and lx_header_id is not NULL) THEN
3576: oe_retrobill_pvt.delete_order(lx_header_id, l_header_deleted); --bug5003256
3577: --bug 12922209 start
3578: IF l_header_deleted THEN
3579: oe_debug_pub.ADD('Retro Order Header created has been deleted');
3580: x_ret_code :=1;

Line 3708: x_retrun_status_text:='OE_RETROBILL_PVT.Process_Retrobill_Request'||SQLERRM;

3704: When Others Then
3705: oe_debug_pub.add('Exception occured in process_retrobill_requests:'||SQLERRM);
3706: oe_debug_pub.add('Statement number:'||stmt);
3707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3708: x_retrun_status_text:='OE_RETROBILL_PVT.Process_Retrobill_Request'||SQLERRM;
3709: oe_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data);
3710: x_created_retrobill_request_id:=NULL;
3711: --bug5003256
3712: x_error_count := -1;

Line 3768: l_retrobill_tbl OE_RETROBILL_PVT.RETROBILL_TBL_TYPE;

3764:
3765: i NUMBER :=1;
3766: j NUMBER;
3767: l_retrobill_request_rec OE_RETROBILL_REQUESTS%ROWTYPE;
3768: l_retrobill_tbl OE_RETROBILL_PVT.RETROBILL_TBL_TYPE;
3769:
3770: l_return_status varchar2(2000);
3771: l_msg_count NUMBER;
3772: l_msg_data varchar2(2000);

Line 3784: Oe_Debug_Pub.add('skubendr:Entering procedure Oe_Retrobill_Pvt.Oe_Build_Retrobill_Table');

3780: l_ret_code NUMBER; --bug12922209
3781: BEGIN
3782: open c_lines;
3783: If l_debug_level > 0 Then
3784: Oe_Debug_Pub.add('skubendr:Entering procedure Oe_Retrobill_Pvt.Oe_Build_Retrobill_Table');
3785: End If;
3786:
3787: -- Initialize Message Stack
3788: -- We initialize the message stack here and for the subsequent process order calls pass the init_msg_list as FALSE

Line 3862: Oe_Debug_Pub.add('skubendr:Before calling Oe_Retrobill_Pvt.Process_Retrobill_Request');

3858: l_retrobill_request_rec.sold_to_org_id := p_sold_to_org_id;
3859: l_retrobill_request_rec.inventory_item_id := p_inventory_item_id;
3860:
3861: If l_debug_level > 0 Then
3862: Oe_Debug_Pub.add('skubendr:Before calling Oe_Retrobill_Pvt.Process_Retrobill_Request');
3863: End If;
3864:
3865: IF(l_retrobill_tbl.count <> 0) THEN
3866: Oe_Retrobill_Pvt.Process_Retrobill_Request

Line 3866: Oe_Retrobill_Pvt.Process_Retrobill_Request

3862: Oe_Debug_Pub.add('skubendr:Before calling Oe_Retrobill_Pvt.Process_Retrobill_Request');
3863: End If;
3864:
3865: IF(l_retrobill_tbl.count <> 0) THEN
3866: Oe_Retrobill_Pvt.Process_Retrobill_Request
3867: (p_retrobill_request_rec => l_retrobill_request_rec
3868: ,p_retrobill_tbl => l_retrobill_tbl
3869: ,x_created_retrobill_request_id => l_retrobill_request_id
3870: ,x_msg_count => l_msg_count

Line 3881: Oe_Debug_Pub.add('skubendr:After calling Oe_Retrobill_Pvt.Process_Retrobill_Request :'||l_return_status);

3877:
3878: x_ret_code := l_ret_code; --bug 12922209
3879:
3880: IF l_debug_level > 0 Then
3881: Oe_Debug_Pub.add('skubendr:After calling Oe_Retrobill_Pvt.Process_Retrobill_Request :'||l_return_status);
3882: END IF;
3883:
3884: -- delete the data from temp table after retrobilling process
3885: IF(p_request_session_id is not NULL) THEN

Line 3896: Oe_Debug_Pub.add('skubendr:Exiting procedure Oe_Retrobill_Pvt.Oe_Build_Retrobill_Table:'||l_return_status);

3892: x_return_status := l_return_status;
3893: x_return_status_text := l_return_status_text;
3894:
3895: IF l_debug_level > 0 Then
3896: Oe_Debug_Pub.add('skubendr:Exiting procedure Oe_Retrobill_Pvt.Oe_Build_Retrobill_Table:'||l_return_status);
3897: END IF;
3898: EXCEPTION
3899: WHEN NO_DATA_FOUND THEN
3900: RAISE NO_DATA_FOUND;

Line 4570: oe_debug_pub.add('Entering Oe_Retrobill_Pvt.Oe_Retrobill_Purge',1);

4566:
4567: FND_PROFILE.Get('CONC_REQUEST_ID', l_concurrent_id);
4568:
4569: IF l_debug_level > 0 THEN
4570: oe_debug_pub.add('Entering Oe_Retrobill_Pvt.Oe_Retrobill_Purge',1);
4571: oe_debug_pub.add( 'CONCURRENT REQUEST ID: '|| TO_CHAR ( L_CONCURRENT_ID ) ) ;
4572: END IF;
4573:
4574: --rt moac start

Line 4683: oe_debug_pub.add('Exiting Oe_Retrobill_pvt.Oe_retrobill_Purge');

4679: END IF;
4680:
4681: fnd_file.put_line(FND_FILE.OUTPUT,'Number of Requests Purged:' ||l_requests_processed);
4682: fnd_file.put_line(FND_FILE.OUTPUT,'Number of Orders Purged:' ||l_headers_processed);
4683: oe_debug_pub.add('Exiting Oe_Retrobill_pvt.Oe_retrobill_Purge');
4684: commit;
4685:
4686: EXCEPTION
4687: WHEN OTHERS THEN

Line 4848: End OE_RETROBILL_PVT;

4844: END IF;
4845:
4846: END Get_Line_Adjustments;
4847:
4848: End OE_RETROBILL_PVT;