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.9.12000000.2 2007/04/03 10:46:30 smmathew 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 421: OE_Line_Ack_Util.Delete_Row (p_line_id => l_line_rec.line_id,

417: = nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR);
418: end if;
419: IF l_count > 0 THEN
420: oe_debug_pub.add('l_count > 0, Calling Delete_Row');
421: OE_Line_Ack_Util.Delete_Row (p_line_id => l_line_rec.line_id,
422: p_ack_type => p_ack_type,
423: p_sold_to_org_id => l_line_rec.sold_to_org_id,
424: p_sold_to_org => l_line_val_rec.sold_to_org,
425: p_change_sequence => l_line_rec.change_sequence,

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

427: p_header_id => l_line_rec.header_id);
428:
429: ELSE
430: oe_debug_pub.add('l_count <= 0 for line_id, attempting delete by doc ref, line ref and ship ref');
431: OE_Line_Ack_Util.Delete_Row (p_line_id => NULL,
432: p_ack_type => p_ack_type,
433: p_orig_sys_document_ref => l_line_rec.orig_sys_document_ref,
434: p_orig_sys_line_ref => l_line_rec.orig_sys_line_ref,
435: p_orig_sys_shipment_ref => l_line_rec.orig_sys_shipment_ref,

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

1290: EXCEPTION
1291:
1292: WHEN OTHERS THEN
1293:
1294: oe_debug_pub.Add('Encountered Others Error Exception in OE_Line_Ack_Util.Insert_Row: '||sqlerrm);
1295:
1296: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1297: THEN
1298: FND_MSG_PUB.Add_Exc_Msg

Line 1299: ( G_PKG_NAME, 'OE_Line_Ack_Util.Insert_Row'

1295:
1296: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1297: THEN
1298: FND_MSG_PUB.Add_Exc_Msg
1299: ( G_PKG_NAME, 'OE_Line_Ack_Util.Insert_Row'
1300: );
1301: END IF;
1302:
1303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2721:
2722: When Others Then
2723: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then
2724: FND_MSG_PUB.Add_Exc_Msg
2725: (G_PKG_NAME, 'OE_Line_Ack_Util.Insert_Row');
2726: End If;
2727:
2728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2729:

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

2838: EXCEPTION
2839:
2840: WHEN OTHERS THEN
2841:
2842: oe_debug_pub.Add('Encountered Others Error Exception in OE_Line_Ack_Util.Delete_Row: '||sqlerrm);
2843:
2844: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2845: THEN
2846: FND_MSG_PUB.Add_Exc_Msg

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

2843:
2844: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2845: THEN
2846: FND_MSG_PUB.Add_Exc_Msg
2847: (G_PKG_NAME, 'OE_Line_Ack_Util.Delete_Row');
2848: END IF;
2849:
2850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2851:

Line 2858: END OE_Line_Ack_Util;

2854:
2855:
2856:
2857:
2858: END OE_Line_Ack_Util;