APPS.OE_HEADER_ACK_UTIL dependencies on OE_HEADER_ACK_UTIL

Line 1: PACKAGE BODY OE_Header_Ack_Util AS

1: PACKAGE BODY OE_Header_Ack_Util AS
2: /* $Header: OEXUHAKB.pls 120.4 2005/12/15 03:06:43 akyadav noship $ */
3:
4:
5: -- Global constant holding the package name

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

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

Line 207: OE_Header_Ack_Util.Delete_Row (p_header_id => l_header_rec.header_id,

203: = nvl(l_header_rec.change_sequence, FND_API.G_MISS_CHAR);
204:
205: end if;
206: IF l_count > 0 THEN
207: OE_Header_Ack_Util.Delete_Row (p_header_id => l_header_rec.header_id,
208: p_ack_type => p_ack_type,
209: p_sold_to_org_id => l_header_rec.sold_to_org_id,
210: p_sold_to_org => l_header_val_rec.sold_to_org,
211: p_change_sequence => l_header_rec.change_sequence,

Line 217: OE_Header_Ack_Util.Delete_Row (p_header_id => NULL,

213: oe_debug_pub.add('Count is > 0, Calling Delete Row',3);
214: oe_debug_pub.add('Count is ' || l_count);
215: ELSE
216: oe_debug_pub.add('Count <= 0 for header_id, attempting delete by doc ref');
217: OE_Header_Ack_Util.Delete_Row (p_header_id => NULL,
218: p_ack_type => p_ack_type,
219:
220: p_orig_sys_document_ref => l_header_rec.orig_sys_document_ref,
221: p_sold_to_org_id => l_header_rec.sold_to_org_id,

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

821:
822: EXCEPTION
823:
824: WHEN OTHERS THEN
825: oe_debug_pub.Add('Encountered Others Error Exception in OE_Header_Ack_Util.Insert_Row: '||sqlerrm);
826:
827: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
828: THEN
829: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'OE_Header_Ack_Util.Insert_Row');

Line 829: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'OE_Header_Ack_Util.Insert_Row');

825: oe_debug_pub.Add('Encountered Others Error Exception in OE_Header_Ack_Util.Insert_Row: '||sqlerrm);
826:
827: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
828: THEN
829: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'OE_Header_Ack_Util.Insert_Row');
830: END IF;
831:
832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
833: END Insert_Row;

Line 1240: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'OE_Header_Ack_Util.Insert_Row');

1236: Exception
1237:
1238: When Others Then
1239: If FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then
1240: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'OE_Header_Ack_Util.Insert_Row');
1241: End If;
1242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1243:
1244: End Insert_Row;

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

1331: EXCEPTION
1332:
1333: WHEN OTHERS THEN
1334:
1335: oe_debug_pub.Add('Encountered Others Error Exception in OE_Header_Ack_Util.Delete_Row: '||sqlerrm);
1336:
1337: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1338: THEN
1339: FND_MSG_PUB.Add_Exc_Msg

Line 1340: (G_PKG_NAME, 'OE_Header_Ack_Util.Delete_Row');

1336:
1337: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1338: THEN
1339: FND_MSG_PUB.Add_Exc_Msg
1340: (G_PKG_NAME, 'OE_Header_Ack_Util.Delete_Row');
1341: END IF;
1342:
1343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1344:

Line 1347: END OE_Header_Ack_Util;

1343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1344:
1345: END Delete_Row;
1346:
1347: END OE_Header_Ack_Util;