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_HEADER_ACK_UTIL dependencies on OE_DEBUG_PUB

Line 20: oe_debug_pub.add('Entering function GET_ACK_CODE');

16: IS
17: l_ack_code Varchar2(30);
18: l_hold_id NUMBER;
19: BEGIN
20: oe_debug_pub.add('Entering function GET_ACK_CODE');
21: oe_debug_pub.add('p_reject_order = '||p_reject_order);
22: oe_debug_pub.add('p_order_source_id = '||p_order_source_id);
23: If p_reject_order = 'N' Then
24: If p_order_source_id = 20 Then

Line 21: oe_debug_pub.add('p_reject_order = '||p_reject_order);

17: l_ack_code Varchar2(30);
18: l_hold_id NUMBER;
19: BEGIN
20: oe_debug_pub.add('Entering function GET_ACK_CODE');
21: oe_debug_pub.add('p_reject_order = '||p_reject_order);
22: oe_debug_pub.add('p_order_source_id = '||p_order_source_id);
23: If p_reject_order = 'N' Then
24: If p_order_source_id = 20 Then
25: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN

Line 22: oe_debug_pub.add('p_order_source_id = '||p_order_source_id);

18: l_hold_id NUMBER;
19: BEGIN
20: oe_debug_pub.add('Entering function GET_ACK_CODE');
21: oe_debug_pub.add('p_reject_order = '||p_reject_order);
22: oe_debug_pub.add('p_order_source_id = '||p_order_source_id);
23: If p_reject_order = 'N' Then
24: If p_order_source_id = 20 Then
25: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
26: If nvl(FND_PROFILE.VALUE('ONT_XML_ACCEPT_STATE'), 'ENTERED') = 'ENTERED' Then

Line 29: oe_debug_pub.add('return Pending');

25: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' THEN
26: If nvl(FND_PROFILE.VALUE('ONT_XML_ACCEPT_STATE'), 'ENTERED') = 'ENTERED' Then
27: Return '0';
28: Elsif nvl(p_booked_flag, 'N') = 'N' AND p_transaction_type = OE_Acknowledgment_Pub.G_TRANSACTION_POI Then
29: oe_debug_pub.add('return Pending');
30: Return '3'; -- pending
31: Else
32: oe_debug_pub.add('return Accepted - code is 0, post-110510');
33: Return '0';

Line 32: oe_debug_pub.add('return Accepted - code is 0, post-110510');

28: Elsif nvl(p_booked_flag, 'N') = 'N' AND p_transaction_type = OE_Acknowledgment_Pub.G_TRANSACTION_POI Then
29: oe_debug_pub.add('return Pending');
30: Return '3'; -- pending
31: Else
32: oe_debug_pub.add('return Accepted - code is 0, post-110510');
33: Return '0';
34: End If;
35: Else
36: oe_debug_pub.add('return Accepted - code is 0, pre-110510');

Line 36: oe_debug_pub.add('return Accepted - code is 0, pre-110510');

32: oe_debug_pub.add('return Accepted - code is 0, post-110510');
33: Return '0';
34: End If;
35: Else
36: oe_debug_pub.add('return Accepted - code is 0, pre-110510');
37: Return '0';
38: End If;
39: Else
40: BEGIN

Line 46: oe_debug_pub.add('Hold Applied on this order is :'|| l_hold_id, 3);

42: INTO l_hold_id
43: FROM OE_ORDER_HOLDS
44: WHERE header_id = p_header_id
45: AND hold_release_id IS NULL ;
46: oe_debug_pub.add('Hold Applied on this order is :'|| l_hold_id, 3);
47:
48: Return 'AH' ;
49:
50: EXCEPTION

Line 53: oe_debug_pub.add('No Holds found ', 3);

49:
50: EXCEPTION
51: WHEN NO_DATA_FOUND
52: THEN
53: oe_debug_pub.add('No Holds found ', 3);
54: oe_debug_pub.add( 'Header id'||p_header_id);
55: Return 'AT' ;
56:
57: WHEN TOO_MANY_ROWS

Line 54: oe_debug_pub.add( 'Header id'||p_header_id);

50: EXCEPTION
51: WHEN NO_DATA_FOUND
52: THEN
53: oe_debug_pub.add('No Holds found ', 3);
54: oe_debug_pub.add( 'Header id'||p_header_id);
55: Return 'AT' ;
56:
57: WHEN TOO_MANY_ROWS
58: THEN

Line 59: oe_debug_pub.add('Many Holds Applied on this order ', 3);

55: Return 'AT' ;
56:
57: WHEN TOO_MANY_ROWS
58: THEN
59: oe_debug_pub.add('Many Holds Applied on this order ', 3);
60: Return 'AH' ;
61: END ;
62: End If;
63: Elsif p_reject_order = 'Y' Then

Line 65: oe_debug_pub.add('return Rejected - code is 2');

61: END ;
62: End If;
63: Elsif p_reject_order = 'Y' Then
64: If p_order_source_id = 20 Then
65: oe_debug_pub.add('return Rejected - code is 2');
66: Return '2';
67: Else
68: oe_debug_pub.add('return RJ');
69: Return 'RJ';

Line 68: oe_debug_pub.add('return RJ');

64: If p_order_source_id = 20 Then
65: oe_debug_pub.add('return Rejected - code is 2');
66: Return '2';
67: Else
68: oe_debug_pub.add('return RJ');
69: Return 'RJ';
70: End If;
71: Else
72: oe_debug_pub.add('return Null in else');

Line 72: oe_debug_pub.add('return Null in else');

68: oe_debug_pub.add('return RJ');
69: Return 'RJ';
70: End If;
71: Else
72: oe_debug_pub.add('return Null in else');
73: Return Null;
74: End If;
75: END GET_ACK_CODE;
76: -- End GET_ACK_CODE }

Line 95: oe_debug_pub.add('before copying header acknowledgment reject N',3);

91: l_count NUMBER;
92:
93: BEGIN
94: IF p_reject_order = 'N' THEN
95: oe_debug_pub.add('before copying header acknowledgment reject N',3);
96: l_header_rec := p_header_rec;
97: l_header_val_rec := p_header_val_rec;
98: ELSE
99: oe_debug_pub.add('before copying header acknowledgment reject else',3);

Line 99: oe_debug_pub.add('before copying header acknowledgment reject else',3);

95: oe_debug_pub.add('before copying header acknowledgment reject N',3);
96: l_header_rec := p_header_rec;
97: l_header_val_rec := p_header_val_rec;
98: ELSE
99: oe_debug_pub.add('before copying header acknowledgment reject else',3);
100: l_header_rec := p_old_header_rec;
101: l_header_val_rec := p_old_header_val_rec;
102: END IF;
103:

Line 106: oe_debug_pub.add('First Ack Code is :'||l_header_rec.FIRST_ACK_CODE);

102: END IF;
103:
104: OE_Header_Util.Convert_Miss_To_Null (l_header_rec);
105:
106: oe_debug_pub.add('First Ack Code is :'||l_header_rec.FIRST_ACK_CODE);
107: oe_debug_pub.add('First Ack Code is :'||p_header_rec.FIRST_ACK_CODE);
108: oe_debug_pub.add('Order Source Id :'|| l_header_rec.order_source_id);
109: oe_debug_pub.add('p_ack_type :'|| p_ack_type);
110: IF nvl(l_header_rec.FIRST_ACK_CODE, ' ') = ' ' THEN -- It is 855

Line 107: oe_debug_pub.add('First Ack Code is :'||p_header_rec.FIRST_ACK_CODE);

103:
104: OE_Header_Util.Convert_Miss_To_Null (l_header_rec);
105:
106: oe_debug_pub.add('First Ack Code is :'||l_header_rec.FIRST_ACK_CODE);
107: oe_debug_pub.add('First Ack Code is :'||p_header_rec.FIRST_ACK_CODE);
108: oe_debug_pub.add('Order Source Id :'|| l_header_rec.order_source_id);
109: oe_debug_pub.add('p_ack_type :'|| p_ack_type);
110: IF nvl(l_header_rec.FIRST_ACK_CODE, ' ') = ' ' THEN -- It is 855
111: -- Commented as part of 3A4 Change

Line 108: oe_debug_pub.add('Order Source Id :'|| l_header_rec.order_source_id);

104: OE_Header_Util.Convert_Miss_To_Null (l_header_rec);
105:
106: oe_debug_pub.add('First Ack Code is :'||l_header_rec.FIRST_ACK_CODE);
107: oe_debug_pub.add('First Ack Code is :'||p_header_rec.FIRST_ACK_CODE);
108: oe_debug_pub.add('Order Source Id :'|| l_header_rec.order_source_id);
109: oe_debug_pub.add('p_ack_type :'|| p_ack_type);
110: IF nvl(l_header_rec.FIRST_ACK_CODE, ' ') = ' ' THEN -- It is 855
111: -- Commented as part of 3A4 Change
112: -- l_header_rec.FIRST_ACK_CODE := 'AT'; -- RJ for rejected

Line 109: oe_debug_pub.add('p_ack_type :'|| p_ack_type);

105:
106: oe_debug_pub.add('First Ack Code is :'||l_header_rec.FIRST_ACK_CODE);
107: oe_debug_pub.add('First Ack Code is :'||p_header_rec.FIRST_ACK_CODE);
108: oe_debug_pub.add('Order Source Id :'|| l_header_rec.order_source_id);
109: oe_debug_pub.add('p_ack_type :'|| p_ack_type);
110: IF nvl(l_header_rec.FIRST_ACK_CODE, ' ') = ' ' THEN -- It is 855
111: -- Commented as part of 3A4 Change
112: -- l_header_rec.FIRST_ACK_CODE := 'AT'; -- RJ for rejected
113: If p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_POA then

Line 155: oe_debug_pub.add('trans is 865 :putting first_ack_date');

151: l_header_rec.FIRST_ACK_DATE := '';
152: l_header_rec.LAST_ACK_CODE := '';
153: l_header_rec.LAST_ACK_DATE := '';
154: ELSE
155: oe_debug_pub.add('trans is 865 :putting first_ack_date');
156: oe_debug_pub.add('First Ack Date :'|| to_char(p_old_header_rec.FIRST_ACK_DATE));
157: l_header_rec.FIRST_ACK_DATE := p_header_rec.FIRST_ACK_DATE;
158: -- Commented as part of 3A4 Change
159: -- l_header_rec.LAST_ACK_CODE := 'AT'; -- RJ for rejected

Line 156: oe_debug_pub.add('First Ack Date :'|| to_char(p_old_header_rec.FIRST_ACK_DATE));

152: l_header_rec.LAST_ACK_CODE := '';
153: l_header_rec.LAST_ACK_DATE := '';
154: ELSE
155: oe_debug_pub.add('trans is 865 :putting first_ack_date');
156: oe_debug_pub.add('First Ack Date :'|| to_char(p_old_header_rec.FIRST_ACK_DATE));
157: l_header_rec.FIRST_ACK_DATE := p_header_rec.FIRST_ACK_DATE;
158: -- Commented as part of 3A4 Change
159: -- l_header_rec.LAST_ACK_CODE := 'AT'; -- RJ for rejected
160: l_header_rec.LAST_ACK_CODE :=

Line 213: oe_debug_pub.add('Count is > 0, Calling Delete Row',3);

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,
212: p_request_id => l_header_rec.request_id);
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,

Line 214: oe_debug_pub.add('Count is ' || l_count);

210: p_sold_to_org => l_header_val_rec.sold_to_org,
211: p_change_sequence => l_header_rec.change_sequence,
212: p_request_id => l_header_rec.request_id);
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,

Line 216: oe_debug_pub.add('Count <= 0 for header_id, attempting delete by doc ref');

212: p_request_id => l_header_rec.request_id);
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,

Line 230: oe_debug_pub.add('Others exception is select from o_header_acks',3);

226: END IF;
227:
228:
229: EXCEPTION WHEN OTHERS THEN
230: oe_debug_pub.add('Others exception is select from o_header_acks',3);
231: END;
232:
233:
234: oe_debug_pub.add('Source = '||l_header_rec.order_source_id);

Line 234: oe_debug_pub.add('Source = '||l_header_rec.order_source_id);

230: oe_debug_pub.add('Others exception is select from o_header_acks',3);
231: END;
232:
233:
234: oe_debug_pub.add('Source = '||l_header_rec.order_source_id);
235: oe_debug_pub.add('Ref = '||l_header_rec.orig_sys_document_ref);
236: oe_debug_pub.add('Headerid = '||l_header_rec.header_id);
237: oe_debug_pub.add('First Ack Code = '|| l_header_rec.first_ack_code,1);
238: IF ( l_header_rec.order_source_id <> FND_API.G_MISS_NUM

Line 235: oe_debug_pub.add('Ref = '||l_header_rec.orig_sys_document_ref);

231: END;
232:
233:
234: oe_debug_pub.add('Source = '||l_header_rec.order_source_id);
235: oe_debug_pub.add('Ref = '||l_header_rec.orig_sys_document_ref);
236: oe_debug_pub.add('Headerid = '||l_header_rec.header_id);
237: oe_debug_pub.add('First Ack Code = '|| l_header_rec.first_ack_code,1);
238: IF ( l_header_rec.order_source_id <> FND_API.G_MISS_NUM
239: AND nvl(l_header_rec.order_source_id,0) <> 0

Line 236: oe_debug_pub.add('Headerid = '||l_header_rec.header_id);

232:
233:
234: oe_debug_pub.add('Source = '||l_header_rec.order_source_id);
235: oe_debug_pub.add('Ref = '||l_header_rec.orig_sys_document_ref);
236: oe_debug_pub.add('Headerid = '||l_header_rec.header_id);
237: oe_debug_pub.add('First Ack Code = '|| l_header_rec.first_ack_code,1);
238: IF ( l_header_rec.order_source_id <> FND_API.G_MISS_NUM
239: AND nvl(l_header_rec.order_source_id,0) <> 0
240: AND l_header_rec.orig_sys_document_ref <> FND_API.G_MISS_CHAR

Line 237: oe_debug_pub.add('First Ack Code = '|| l_header_rec.first_ack_code,1);

233:
234: oe_debug_pub.add('Source = '||l_header_rec.order_source_id);
235: oe_debug_pub.add('Ref = '||l_header_rec.orig_sys_document_ref);
236: oe_debug_pub.add('Headerid = '||l_header_rec.header_id);
237: oe_debug_pub.add('First Ack Code = '|| l_header_rec.first_ack_code,1);
238: IF ( l_header_rec.order_source_id <> FND_API.G_MISS_NUM
239: AND nvl(l_header_rec.order_source_id,0) <> 0
240: AND l_header_rec.orig_sys_document_ref <> FND_API.G_MISS_CHAR
241: AND nvl(l_header_rec.orig_sys_document_ref,' ') <> ' ')

Line 246: oe_debug_pub.add('inserting header ack record for'||

242:
243: OR (l_header_rec.header_id <> FND_API.G_MISS_NUM
244: AND nvl(l_header_rec.header_id,0) <> 0)
245: THEN
246: oe_debug_pub.add('inserting header ack record for'||
247: ' source id: ' ||to_char(l_header_rec.order_source_id)||
248: ', ref: ' ||l_header_rec.orig_sys_document_ref||
249: ', header id: '||to_char(l_header_rec.header_id));
250:

Line 817: oe_debug_pub.add('Incomplete data for inserting header ack rec');

813: ,l_header_val_rec.end_customer_site_country
814: ,l_header_val_rec.invoice_to_customer_name -- for bug 4489065
815: );
816: ELSE
817: oe_debug_pub.add('Incomplete data for inserting header ack rec');
818: END IF;
819:
820: oe_debug_pub.add('after inserting header acknowledgment record');
821:

Line 820: oe_debug_pub.add('after inserting header acknowledgment record');

816: ELSE
817: oe_debug_pub.add('Incomplete data for inserting header ack rec');
818: END IF;
819:
820: oe_debug_pub.add('after inserting header acknowledgment record');
821:
822: EXCEPTION
823:
824: WHEN OTHERS THEN

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 845: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

841: Is
842:
843: l_header_rec OE_Order_Pub.Header_Rec_Type := p_header_rec;
844: l_count Number;
845: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
846: l_ack_type Varchar2(3);
847:
848: Begin
849:

Line 852: oe_debug_pub.add('trans is 855');

848: Begin
849:
850: If nvl(l_header_rec.FIRST_ACK_CODE, ' ') = ' ' Then
851: -- Trans is 855
852: oe_debug_pub.add('trans is 855');
853: l_header_rec.First_Ack_Code :=
854: Get_Ack_Code(p_order_source_id => l_header_rec.order_source_id,
855: p_reject_order => 'N',
856: p_header_id => l_header_rec.header_id);

Line 865: oe_debug_pub.add('trans is 865');

861: --l_ack_type := '855'; for bug4730258
862: x_ack_type := '855';
863: Else
864: -- Trans is 865
865: oe_debug_pub.add('trans is 865');
866: l_header_rec.Last_Ack_Code :=
867: Get_Ack_Code(p_order_source_id => l_header_rec.order_source_id,
868: p_reject_order => 'N',
869: p_header_id => l_header_rec.header_id);

Line 889: oe_debug_pub.add('unacknowledged ack present, call delete');

885: And nvl(acknowledgment_type,'ALL') = nvl(l_ack_type,'ALL')
886: And acknowledgment_flag Is Null;
887:
888: If l_count > 0 Then
889: oe_debug_pub.add('unacknowledged ack present, call delete');
890: --Commented code to delete records from oe_line_acks for bug 4730258
891: Delete From Oe_Header_Acks
892: Where header_id = l_header_rec.header_id
893: And nvl(change_sequence,'ALL') = nvl(l_header_rec.change_sequence,'ALL')

Line 1232: Oe_Debug_Pub.Add('No data for Ack');

1228: );
1229:
1230: Else
1231: If l_debug_level > 0 Then
1232: Oe_Debug_Pub.Add('No data for Ack');
1233: End If;
1234: End If;
1235:
1236: Exception

Line 1261: oe_debug_pub.add('before deleting header acknowledgment ',3);

1257: IS
1258: BEGIN
1259:
1260: If p_header_id Is Not NULL Then
1261: oe_debug_pub.add('before deleting header acknowledgment ',3);
1262:
1263: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
1264: OR p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
1265: then

Line 1295: oe_debug_pub.add('before deleting header acknowledgment by orig_sys_document_Ref ',3);

1291: = nvl(p_change_sequence, FND_API.G_MISS_CHAR);
1292: end if;
1293:
1294: Elsif p_orig_sys_document_ref Is Not NULL Then
1295: oe_debug_pub.add('before deleting header acknowledgment by orig_sys_document_Ref ',3);
1296:
1297: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
1298: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
1299: then

Line 1327: oe_debug_pub.add('not deleting any rows from oe_header_acks ',3);

1323:
1324: end if;
1325:
1326: Else
1327: oe_debug_pub.add('not deleting any rows from oe_header_acks ',3);
1328:
1329: End If;
1330:
1331: EXCEPTION

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