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_LINE_ACK_UTIL dependencies on OE_ACKNOWLEDGMENT_PUB

Line 25: Elsif nvl(p_booked_flag, 'N') = 'N' AND p_transaction_type = OE_Acknowledgment_Pub.G_TRANSACTION_POI Then

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

Line 128: If p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_POA then

124: -- {Start of 3A4 change for the reject = 'N'
125: -- If l_line_rec.order_source_id = 20 Then Bug 9685021
126: If l_order_source_id = 20 Then
127: If l_line_rec.First_Ack_Code IS NULL Then
128: If p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_POA then
129: l_line_rec.FIRST_ACK_CODE :=
130: Get_Ack_Code(p_order_source_id => l_line_rec.order_source_id,
131: p_reject_order => p_reject_order);
132: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CPO then

Line 132: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CPO then

128: If p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_POA then
129: l_line_rec.FIRST_ACK_CODE :=
130: Get_Ack_Code(p_order_source_id => l_line_rec.order_source_id,
131: p_reject_order => p_reject_order);
132: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CPO then
133: l_line_rec.FIRST_ACK_CODE :=
134: Get_Ack_Code(p_order_source_id => l_line_rec.order_source_id,
135: p_reject_order => p_reject_order);
136: -- 3A6 related

Line 137: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO then

133: l_line_rec.FIRST_ACK_CODE :=
134: Get_Ack_Code(p_order_source_id => l_line_rec.order_source_id,
135: p_reject_order => p_reject_order);
136: -- 3A6 related
137: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO then
138: If l_line_rec.last_ack_code IS NULL Then
139: l_line_rec.FIRST_ACK_CODE := 'OPEN';
140: Else
141: l_line_rec.FIRST_ACK_CODE := l_line_rec.last_ack_code;

Line 143: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO then

139: l_line_rec.FIRST_ACK_CODE := 'OPEN';
140: Else
141: l_line_rec.FIRST_ACK_CODE := l_line_rec.last_ack_code;
142: End if;
143: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO then
144: If l_line_rec.last_ack_code IS NULL Then
145: l_line_rec.FIRST_ACK_CODE := 'OPEN';
146: Else
147: l_line_rec.FIRST_ACK_CODE := l_line_rec.last_ack_code;

Line 150: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_POI then

146: Else
147: l_line_rec.FIRST_ACK_CODE := l_line_rec.last_ack_code;
148: End if;
149: -- 3A4 related
150: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_POI then
151: l_line_rec.FIRST_ACK_CODE :=
152: Get_Ack_Code(p_order_source_id => l_line_rec.order_source_id,
153: p_reject_order => p_reject_order,
154: p_booked_flag => l_line_rec.booked_flag,

Line 155: p_transaction_type => oe_acknowledgment_pub.G_TRANSACTION_POI);

151: l_line_rec.FIRST_ACK_CODE :=
152: Get_Ack_Code(p_order_source_id => l_line_rec.order_source_id,
153: p_reject_order => p_reject_order,
154: p_booked_flag => l_line_rec.booked_flag,
155: p_transaction_type => oe_acknowledgment_pub.G_TRANSACTION_POI);
156: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CHO then
157: l_line_rec.FIRST_ACK_CODE :=
158: Get_Ack_Code(p_order_source_id => l_line_rec.order_source_id,
159: p_reject_order => p_reject_order);

Line 156: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CHO then

152: Get_Ack_Code(p_order_source_id => l_line_rec.order_source_id,
153: p_reject_order => p_reject_order,
154: p_booked_flag => l_line_rec.booked_flag,
155: p_transaction_type => oe_acknowledgment_pub.G_TRANSACTION_POI);
156: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CHO then
157: l_line_rec.FIRST_ACK_CODE :=
158: Get_Ack_Code(p_order_source_id => l_line_rec.order_source_id,
159: p_reject_order => p_reject_order);
160:

Line 399: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO

395: END IF;
396:
397: BEGIN
398:
399: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
400: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
401: then
402:
403: SELECT count(*) INTO l_count

Line 400: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO

396:
397: BEGIN
398:
399: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
400: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
401: then
402:
403: SELECT count(*) INTO l_count
404: FROM OE_LINE_ACKS

Line 2836: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO

2832: p_line_id is not null) Then
2833:
2834: --request id is only used in where clause for 3a6
2835:
2836: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
2837: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
2838: then
2839: DELETE FROM OE_LINE_ACKS
2840: WHERE HEADER_ID = p_header_id

Line 2837: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO

2833:
2834: --request id is only used in where clause for 3a6
2835:
2836: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
2837: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
2838: then
2839: DELETE FROM OE_LINE_ACKS
2840: WHERE HEADER_ID = p_header_id
2841: AND LINE_ID = p_line_id

Line 2873: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO

2869: end If;
2870: Elsif (p_orig_sys_document_ref is not null) Then
2871: oe_debug_pub.add('before deleting line acknowledgment by orig_sys_document_Ref, line_ref and shipment_ref ',3);
2872:
2873: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
2874: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
2875: then
2876:
2877: DELETE FROM OE_LINE_ACKS

Line 2874: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO

2870: Elsif (p_orig_sys_document_ref is not null) Then
2871: oe_debug_pub.add('before deleting line acknowledgment by orig_sys_document_Ref, line_ref and shipment_ref ',3);
2872:
2873: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
2874: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
2875: then
2876:
2877: DELETE FROM OE_LINE_ACKS
2878: WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref