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 113: If p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_POA then

109: OE_Line_Util.Convert_Miss_To_Null (l_line_rec);
110: -- {Start of 3A4 change for the reject = 'N'
111: If l_line_rec.order_source_id = 20 Then
112: If l_line_rec.First_Ack_Code IS NULL Then
113: If p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_POA then
114: l_line_rec.FIRST_ACK_CODE :=
115: Get_Ack_Code(p_order_source_id => l_line_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_line_rec.FIRST_ACK_CODE :=
115: Get_Ack_Code(p_order_source_id => l_line_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_line_rec.FIRST_ACK_CODE :=
119: Get_Ack_Code(p_order_source_id => l_line_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_line_rec.FIRST_ACK_CODE :=
119: Get_Ack_Code(p_order_source_id => l_line_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_line_rec.last_ack_code IS NULL Then
124: l_line_rec.FIRST_ACK_CODE := 'OPEN';
125: Else
126: l_line_rec.FIRST_ACK_CODE := l_line_rec.last_ack_code;

Line 128: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO then

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

Line 135: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_POI then

131: Else
132: l_line_rec.FIRST_ACK_CODE := l_line_rec.last_ack_code;
133: End if;
134: -- 3A4 related
135: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_POI then
136: l_line_rec.FIRST_ACK_CODE :=
137: Get_Ack_Code(p_order_source_id => l_line_rec.order_source_id,
138: p_reject_order => p_reject_order,
139: p_booked_flag => l_line_rec.booked_flag,

Line 140: p_transaction_type => oe_acknowledgment_pub.G_TRANSACTION_POI);

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

Line 141: Elsif p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CHO then

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

Line 384: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO

380: END IF;
381:
382: BEGIN
383:
384: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
385: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
386: then
387:
388: SELECT count(*) INTO l_count

Line 385: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO

381:
382: BEGIN
383:
384: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
385: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
386: then
387:
388: SELECT count(*) INTO l_count
389: FROM OE_LINE_ACKS

Line 2758: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO

2754: p_line_id is not null) Then
2755:
2756: --request id is only used in where clause for 3a6
2757:
2758: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
2759: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
2760: then
2761: DELETE FROM OE_LINE_ACKS
2762: WHERE HEADER_ID = p_header_id

Line 2759: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO

2755:
2756: --request id is only used in where clause for 3a6
2757:
2758: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
2759: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
2760: then
2761: DELETE FROM OE_LINE_ACKS
2762: WHERE HEADER_ID = p_header_id
2763: AND LINE_ID = p_line_id

Line 2795: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO

2791: end If;
2792: Elsif (p_orig_sys_document_ref is not null) Then
2793: oe_debug_pub.add('before deleting line acknowledgment by orig_sys_document_Ref, line_ref and shipment_ref ',3);
2794:
2795: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
2796: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
2797: then
2798:
2799: DELETE FROM OE_LINE_ACKS

Line 2796: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO

2792: Elsif (p_orig_sys_document_ref is not null) Then
2793: oe_debug_pub.add('before deleting line acknowledgment by orig_sys_document_Ref, line_ref and shipment_ref ',3);
2794:
2795: if p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_SSO
2796: Or p_ack_type = oe_acknowledgment_pub.G_TRANSACTION_CSO
2797: then
2798:
2799: DELETE FROM OE_LINE_ACKS
2800: WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref