DBA Data[Home] [Help]

APPS.OE_OE_FORM_LINE_ADJ dependencies on OE_OE_FORM_LINE_ADJ

Line 1: PACKAGE BODY OE_OE_Form_Line_Adj AS

1: PACKAGE BODY OE_OE_Form_Line_Adj AS
2: /* $Header: OEXFLADB.pls 120.2 2006/07/25 11:47:16 ppnair noship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Line_Adj';

2: /* $Header: OEXFLADB.pls 120.2 2006/07/25 11:47:16 ppnair noship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Line_Adj';
7:
8: -- Global variables holding cached record.
9:
10: g_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type

Line 248: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.DEFAULT_ATTRIBUTES' , 1 ) ;

244: --
245: BEGIN
246:
247: IF l_debug_level > 0 THEN
248: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.DEFAULT_ATTRIBUTES' , 1 ) ;
249: END IF;
250:
251: -- Set the UI flag
252: OE_GLOBALS.G_UI_FLAG := TRUE;

Line 503: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.DEFAULT_ATTRIBUTES' , 1 ) ;

499: , p_data => x_msg_data
500: );
501:
502: IF l_debug_level > 0 THEN
503: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.DEFAULT_ATTRIBUTES' , 1 ) ;
504: END IF;
505:
506: EXCEPTION
507:

Line 807: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.CHANGE_ATTRIBUTES' , 1 ) ;

803: --
804: BEGIN
805:
806: IF l_debug_level > 0 THEN
807: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.CHANGE_ATTRIBUTES' , 1 ) ;
808: END IF;
809:
810: --initialize record.
811: l_line_rec.line_id := NULL;

Line 897: oe_debug_pub.add( ' IN OE_OE_FORM_LINE_ADJ:'||SQLERRM ) ;

893: AND nvl(lin.line_id,l_x_Line_Adj_rec.line_id) = l_x_Line_Adj_rec.line_id
894: AND rownum = 1;
895: EXCEPTION WHEN OTHERS THEN
896: IF l_debug_level > 0 THEN
897: oe_debug_pub.add( ' IN OE_OE_FORM_LINE_ADJ:'||SQLERRM ) ;
898: END IF;
899: END;
900: END IF;
901: ELSIF p_attr_id = OE_Line_Adj_Util.G_MODIFIER_MECHANISM_TYPE_CODE then

Line 1875: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.CHANGE_ATTRIBUTES' , 1 ) ;

1871: , p_data => x_msg_data
1872: );
1873:
1874: IF l_debug_level > 0 THEN
1875: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.CHANGE_ATTRIBUTES' , 1 ) ;
1876: END IF;
1877:
1878: EXCEPTION
1879:

Line 2012: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.VALIDATE_AND_WRITE' , 1 ) ;

2008: --
2009: BEGIN
2010:
2011: IF l_debug_level > 0 THEN
2012: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.VALIDATE_AND_WRITE' , 1 ) ;
2013: END IF;
2014:
2015: -- Set the UI flag
2016: OE_GLOBALS.G_UI_FLAG := TRUE;

Line 2217: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.VALIDATE_AND_WRITE' , 1 ) ;

2213: , p_data => x_msg_data
2214: );
2215:
2216: IF l_debug_level > 0 THEN
2217: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.VALIDATE_AND_WRITE' , 1 ) ;
2218: END IF;
2219:
2220: EXCEPTION
2221:

Line 2335: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.DELETE_ROW' , 1 ) ;

2331: --
2332: BEGIN
2333:
2334: IF l_debug_level > 0 THEN
2335: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.DELETE_ROW' , 1 ) ;
2336: END IF;
2337:
2338: -- Set the UI flag
2339: OE_GLOBALS.G_UI_FLAG := TRUE;

Line 2486: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.DELETE_ROW' , 1 ) ;

2482: , p_data => x_msg_data
2483: );
2484:
2485: IF l_debug_level > 0 THEN
2486: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.DELETE_ROW' , 1 ) ;
2487: END IF;
2488:
2489: EXCEPTION
2490:

Line 2590: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.PROCESS_DELAYED_REQUESTS' , 1 ) ;

2586: --
2587: BEGIN
2588:
2589: IF l_debug_level > 0 THEN
2590: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.PROCESS_DELAYED_REQUESTS' , 1 ) ;
2591: END IF;
2592:
2593: /*
2594: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 2751: oe_debug_pub.add('Exiting OE_OE_FORM_LINE_ADJ.PROCESS_DELAYED_REQUESTS', 1);

2747: ( p_count => x_msg_count
2748: , p_data => x_msg_data
2749: );
2750:
2751: oe_debug_pub.add('Exiting OE_OE_FORM_LINE_ADJ.PROCESS_DELAYED_REQUESTS', 1);
2752:
2753: ****************************************************************/
2754:
2755: EXCEPTION

Line 2861: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.REPLACE_ATTRIBUTES' , 1 ) ;

2857: --
2858: BEGIN
2859:
2860: IF l_debug_level > 0 THEN
2861: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.REPLACE_ATTRIBUTES' , 1 ) ;
2862: END IF;
2863:
2864: -- Set the UI flag
2865: OE_GLOBALS.G_UI_FLAG := TRUE;

Line 3023: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.REPLACE_ATTRIBUTES' , 1 ) ;

3019: , p_data => x_msg_data
3020: );
3021:
3022: IF l_debug_level > 0 THEN
3023: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.REPLACE_ATTRIBUTES' , 1 ) ;
3024: END IF;
3025:
3026: EXCEPTION
3027:

Line 3111: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.LOCK_ROW' , 1 ) ;

3107: --
3108: BEGIN
3109:
3110: IF l_debug_level > 0 THEN
3111: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.LOCK_ROW' , 1 ) ;
3112: END IF;
3113:
3114: -- Load Line_Adj record
3115:

Line 3149: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.LOCK_ROW' , 1 ) ;

3145: , p_data => x_msg_data
3146: );
3147:
3148: IF l_debug_level > 0 THEN
3149: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.LOCK_ROW' , 1 ) ;
3150: END IF;
3151:
3152: EXCEPTION
3153:

Line 3192: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.WRITE_LINE_ADJ' , 1 ) ;

3188: --
3189: BEGIN
3190:
3191: IF l_debug_level > 0 THEN
3192: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.WRITE_LINE_ADJ' , 1 ) ;
3193: END IF;
3194:
3195: g_Line_Adj_rec := p_Line_Adj_rec;
3196:

Line 3204: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.WRITE_LINE_ADJ' , 1 ) ;

3200:
3201: END IF;
3202:
3203: IF l_debug_level > 0 THEN
3204: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.WRITE_LINE_ADJ' , 1 ) ;
3205: END IF;
3206:
3207: END Write_Line_Adj;
3208:

Line 3222: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.GET_LINE_ADJ' , 1 ) ;

3218: --
3219: BEGIN
3220:
3221: IF l_debug_level > 0 THEN
3222: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.GET_LINE_ADJ' , 1 ) ;
3223: END IF;
3224:
3225: IF p_price_adjustment_id <> g_Line_Adj_rec.price_adjustment_id
3226: THEN

Line 3244: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.GET_LINE_ADJ' , 1 ) ;

3240:
3241: END IF;
3242:
3243: IF l_debug_level > 0 THEN
3244: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.GET_LINE_ADJ' , 1 ) ;
3245: END IF;
3246:
3247: IF p_db_record THEN
3248:

Line 3270: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.CLEAR_LINE_ADJ' , 1 ) ;

3266: --
3267: BEGIN
3268:
3269: IF l_debug_level > 0 THEN
3270: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.CLEAR_LINE_ADJ' , 1 ) ;
3271: END IF;
3272:
3273: g_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
3274: g_db_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;

Line 3277: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.CLEAR_LINE_ADJ' , 1 ) ;

3273: g_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
3274: g_db_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
3275:
3276: IF l_debug_level > 0 THEN
3277: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.CLEAR_LINE_ADJ' , 1 ) ;
3278: END IF;
3279:
3280: END Clear_Line_Adj;
3281:

Line 3373: oe_debug_pub.add( ' IN OE_OE_FORM_LINE_ADJ.INSER_ROW:'||SQLERRM ) ;

3369: EXCEPTION WHEN OTHERS THEN
3370: -- lagrawal bug 3673050
3371: OE_GLOBALS.G_UI_FLAG := FALSE;
3372: IF l_debug_level > 0 THEN
3373: oe_debug_pub.add( ' IN OE_OE_FORM_LINE_ADJ.INSER_ROW:'||SQLERRM ) ;
3374: END IF;
3375: END;
3376: END IF;
3377:

Line 3414: , 'Oe_Oe_Form_Line_Adj.Insert_Row:'||SQLERRM

3410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3411:
3412: OE_MSG_PUB.Add_Exc_Msg
3413: ( G_PKG_NAME
3414: , 'Oe_Oe_Form_Line_Adj.Insert_Row:'||SQLERRM
3415: );
3416: IF l_debug_level > 0 THEN
3417: oe_debug_pub.add( 'OE_OE_FORM_LINE_ADJ.INSERT_ROW:'||SQLERRM ) ;
3418: END IF;

Line 3417: oe_debug_pub.add( 'OE_OE_FORM_LINE_ADJ.INSERT_ROW:'||SQLERRM ) ;

3413: ( G_PKG_NAME
3414: , 'Oe_Oe_Form_Line_Adj.Insert_Row:'||SQLERRM
3415: );
3416: IF l_debug_level > 0 THEN
3417: oe_debug_pub.add( 'OE_OE_FORM_LINE_ADJ.INSERT_ROW:'||SQLERRM ) ;
3418: END IF;
3419: -- Get message count and data
3420:
3421: OE_MSG_PUB.Count_And_Get

Line 3500: oe_debug_pub.add( ' EXECPTION IN OE_OE_FORM_LINE_ADJ:'||SQLERRM ) ;

3496: END IF;
3497: End If;
3498: Exception When Others Then
3499: IF l_debug_level > 0 THEN
3500: oe_debug_pub.add( ' EXECPTION IN OE_OE_FORM_LINE_ADJ:'||SQLERRM ) ;
3501: END IF;
3502: End;
3503:
3504: --This Procedure will either change,create or delete adjustments

Line 3645: oe_debug_pub.add( 'IN OE_OE_FORM_LINE_ADJ.PROCESS_ADJ:'||SQLERRM||':'||STMT ) ;

3641: End Loop;
3642:
3643: Exception When Others Then
3644: IF l_debug_level > 0 THEN
3645: oe_debug_pub.add( 'IN OE_OE_FORM_LINE_ADJ.PROCESS_ADJ:'||SQLERRM||':'||STMT ) ;
3646: END IF;
3647: End;
3648:
3649:

Line 3650: END OE_OE_Form_Line_Adj;

3646: END IF;
3647: End;
3648:
3649:
3650: END OE_OE_Form_Line_Adj;