APPS.OE_LINE_ACK_UTIL dependencies on OE_LINE_ACK_UTIL

Line 1: PACKAGE BODY OE_Line_Ack_Util AS

1: PACKAGE BODY OE_Line_Ack_Util AS
2: /* $Header: OEXULAKB.pls 120.12.12020000.2 2013/01/21 05:26:31 kadiraju ship $ */
3:
4:
5: -- Global constant holding the package name

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_LINE_ACK_UTIL';

3:
4:
5: -- Global constant holding the package name
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_LINE_ACK_UTIL';
8:
9: -- {aksingh 3a4 Start
10: -- { Start GET_ACK_CODE
11: FUNCTION GET_ACK_CODE (p_order_source_id NUMBER := 6,

Line 436: OE_Line_Ack_Util.Delete_Row (p_line_id => l_line_rec.line_id,

432: = nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR);
433: end if;
434: IF l_count > 0 THEN
435: oe_debug_pub.add('l_count > 0, Calling Delete_Row');
436: OE_Line_Ack_Util.Delete_Row (p_line_id => l_line_rec.line_id,
437: p_ack_type => p_ack_type,
438: p_sold_to_org_id => l_line_rec.sold_to_org_id,
439: p_sold_to_org => l_line_val_rec.sold_to_org,
440: p_change_sequence => l_line_rec.change_sequence,

Line 446: OE_Line_Ack_Util.Delete_Row (p_line_id => NULL,

442: p_header_id => l_line_rec.header_id);
443:
444: ELSE
445: oe_debug_pub.add('l_count <= 0 for line_id, attempting delete by doc ref, line ref and ship ref');
446: OE_Line_Ack_Util.Delete_Row (p_line_id => NULL,
447: p_ack_type => p_ack_type,
448: p_orig_sys_document_ref => l_line_rec.orig_sys_document_ref,
449: p_orig_sys_line_ref => l_line_rec.orig_sys_line_ref,
450: p_orig_sys_shipment_ref => l_line_rec.orig_sys_shipment_ref,

Line 1338: oe_debug_pub.Add('Encountered Others Error Exception in OE_Line_Ack_Util.Insert_Row: '||sqlerrm);

1334: EXCEPTION
1335:
1336: WHEN OTHERS THEN
1337:
1338: oe_debug_pub.Add('Encountered Others Error Exception in OE_Line_Ack_Util.Insert_Row: '||sqlerrm);
1339:
1340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1341: THEN
1342: FND_MSG_PUB.Add_Exc_Msg

Line 1343: ( G_PKG_NAME, 'OE_Line_Ack_Util.Insert_Row'

1339:
1340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1341: THEN
1342: FND_MSG_PUB.Add_Exc_Msg
1343: ( G_PKG_NAME, 'OE_Line_Ack_Util.Insert_Row'
1344: );
1345: END IF;
1346:
1347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2803: (G_PKG_NAME, 'OE_Line_Ack_Util.Insert_Row');

2799:
2800: When Others Then
2801: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then
2802: FND_MSG_PUB.Add_Exc_Msg
2803: (G_PKG_NAME, 'OE_Line_Ack_Util.Insert_Row');
2804: End If;
2805:
2806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2807:

Line 2920: oe_debug_pub.Add('Encountered Others Error Exception in OE_Line_Ack_Util.Delete_Row: '||sqlerrm);

2916: EXCEPTION
2917:
2918: WHEN OTHERS THEN
2919:
2920: oe_debug_pub.Add('Encountered Others Error Exception in OE_Line_Ack_Util.Delete_Row: '||sqlerrm);
2921:
2922: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2923: THEN
2924: FND_MSG_PUB.Add_Exc_Msg

Line 2925: (G_PKG_NAME, 'OE_Line_Ack_Util.Delete_Row');

2921:
2922: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2923: THEN
2924: FND_MSG_PUB.Add_Exc_Msg
2925: (G_PKG_NAME, 'OE_Line_Ack_Util.Delete_Row');
2926: END IF;
2927:
2928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2929:

Line 2936: END OE_Line_Ack_Util;

2932:
2933:
2934:
2935:
2936: END OE_Line_Ack_Util;