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_ACKNOWLEDGMENT_PUB

Line 28: Elsif nvl(p_booked_flag, 'N') = 'N' AND p_transaction_type = OE_Acknowledgment_Pub.G_TRANSACTION_POI 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
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');

Line 113: If p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_POA then

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
114: l_header_rec.FIRST_ACK_CODE :=
115: Get_Ack_Code(p_order_source_id => l_header_rec.order_source_id,
116: p_reject_order => p_reject_order);
117: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CPO then

Line 117: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CPO then

113: If p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_POA then
114: l_header_rec.FIRST_ACK_CODE :=
115: Get_Ack_Code(p_order_source_id => l_header_rec.order_source_id,
116: p_reject_order => p_reject_order);
117: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CPO then
118: l_header_rec.FIRST_ACK_CODE :=
119: Get_Ack_Code(p_order_source_id => l_header_rec.order_source_id,
120: p_reject_order => p_reject_order);
121: -- 3A6 related

Line 122: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO then

118: l_header_rec.FIRST_ACK_CODE :=
119: Get_Ack_Code(p_order_source_id => l_header_rec.order_source_id,
120: p_reject_order => p_reject_order);
121: -- 3A6 related
122: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO then
123: If l_header_rec.last_ack_code IS NULL Then
124: l_header_rec.FIRST_ACK_CODE := 'OPEN';
125: Else
126: l_header_rec.FIRST_ACK_CODE := l_header_rec.last_ack_code;

Line 128: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO then

124: l_header_rec.FIRST_ACK_CODE := 'OPEN';
125: Else
126: l_header_rec.FIRST_ACK_CODE := l_header_rec.last_ack_code;
127: End if;
128: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO then
129: If l_header_rec.last_ack_code IS NULL Then
130: l_header_rec.FIRST_ACK_CODE := 'OPEN';
131: Else
132: l_header_rec.FIRST_ACK_CODE := l_header_rec.last_ack_code;

Line 134: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_POI then

130: l_header_rec.FIRST_ACK_CODE := 'OPEN';
131: Else
132: l_header_rec.FIRST_ACK_CODE := l_header_rec.last_ack_code;
133: End if;
134: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_POI then
135: l_header_rec.FIRST_ACK_CODE :=
136: Get_Ack_Code(p_order_source_id => l_header_rec.order_source_id,
137: p_reject_order => p_reject_order,
138: p_booked_flag => l_header_rec.booked_flag,

Line 139: p_transaction_type => oe_acknowledgment_pub.G_TRANSACTION_POI

135: l_header_rec.FIRST_ACK_CODE :=
136: Get_Ack_Code(p_order_source_id => l_header_rec.order_source_id,
137: p_reject_order => p_reject_order,
138: p_booked_flag => l_header_rec.booked_flag,
139: p_transaction_type => oe_acknowledgment_pub.G_TRANSACTION_POI
140: );
141: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CHO then
142: l_header_rec.FIRST_ACK_CODE :=
143: Get_Ack_Code(p_order_source_id => l_header_rec.order_source_id,

Line 141: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CHO then

137: p_reject_order => p_reject_order,
138: p_booked_flag => l_header_rec.booked_flag,
139: p_transaction_type => oe_acknowledgment_pub.G_TRANSACTION_POI
140: );
141: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CHO then
142: l_header_rec.FIRST_ACK_CODE :=
143: Get_Ack_Code(p_order_source_id => l_header_rec.order_source_id,
144: p_reject_order => p_reject_order);
145: Elsif l_header_rec.ORDER_SOURCE_ID <> 20 Then -- so that we still handle 855

Line 174: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO

170:
171: BEGIN
172:
173:
174: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
175: OR p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
176: then
177:
178: SELECT count(*) INTO l_count

Line 175: OR p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO

171: BEGIN
172:
173:
174: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
175: OR p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
176: then
177:
178: SELECT count(*) INTO l_count
179: FROM OE_HEADER_ACKS

Line 1263: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO

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
1266:
1267: DELETE FROM OE_HEADER_ACKS

Line 1264: OR p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO

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
1266:
1267: DELETE FROM OE_HEADER_ACKS
1268: WHERE HEADER_ID = p_header_id

Line 1297: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO

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
1300: DELETE FROM OE_HEADER_ACKS
1301: WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref

Line 1298: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO

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
1300: DELETE FROM OE_HEADER_ACKS
1301: WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
1302: AND ACKNOWLEDGMENT_TYPE = p_ack_type -- POI, CPO, etc