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.RCV_UPDATE_RTI_LC dependencies on ASN_DEBUG

Line 26: asn_debug.put_line('Entering UPDATE_RTI_WITH_LC.update_rti' || to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));

22:
23: --
24: x_lcm_int := lcm_int_table();
25:
26: asn_debug.put_line('Entering UPDATE_RTI_WITH_LC.update_rti' || to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));
27: asn_debug.put_line('no of records to be updated : ' || p_int_rec.COUNT);
28: --
29:
30: g_fail_if_one_line_fails := nvl(fnd_profile.VALUE('RCV_FAIL_IF_LINE_FAILS'),'N');

Line 27: asn_debug.put_line('no of records to be updated : ' || p_int_rec.COUNT);

23: --
24: x_lcm_int := lcm_int_table();
25:
26: asn_debug.put_line('Entering UPDATE_RTI_WITH_LC.update_rti' || to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));
27: asn_debug.put_line('no of records to be updated : ' || p_int_rec.COUNT);
28: --
29:
30: g_fail_if_one_line_fails := nvl(fnd_profile.VALUE('RCV_FAIL_IF_LINE_FAILS'),'N');
31:

Line 32: asn_debug.put_line('profile RCV_FAIL_IF_LINE_FAILS: ' || g_fail_if_one_line_fails);

28: --
29:
30: g_fail_if_one_line_fails := nvl(fnd_profile.VALUE('RCV_FAIL_IF_LINE_FAILS'),'N');
31:
32: asn_debug.put_line('profile RCV_FAIL_IF_LINE_FAILS: ' || g_fail_if_one_line_fails);
33:
34: SELECT rcv_interface_groups_s.NEXTVAL
35: INTO l_group_id
36: FROM DUAL;

Line 38: asn_debug.put_line('group_id to be updated with: ' || l_group_id);

34: SELECT rcv_interface_groups_s.NEXTVAL
35: INTO l_group_id
36: FROM DUAL;
37:
38: asn_debug.put_line('group_id to be updated with: ' || l_group_id);
39:
40: for i in 1..p_int_rec.COUNT loop
41:
42: if (p_int_rec(i).unit_landed_cost is not null

Line 56: asn_debug.put_line('updated interface id: ' || p_int_rec(i).interface_id);

52: AND unit_landed_cost is NULL;
53:
54: l_row_count := l_row_count + SQL%ROWCOUNT;
55:
56: asn_debug.put_line('updated interface id: ' || p_int_rec(i).interface_id);
57: asn_debug.put_line('Updated : '||SQL%ROWCOUNT||' rows in RTI');
58:
59: if (SQL%ROWCOUNT > 0) then
60: k := k+1;

Line 57: asn_debug.put_line('Updated : '||SQL%ROWCOUNT||' rows in RTI');

53:
54: l_row_count := l_row_count + SQL%ROWCOUNT;
55:
56: asn_debug.put_line('updated interface id: ' || p_int_rec(i).interface_id);
57: asn_debug.put_line('Updated : '||SQL%ROWCOUNT||' rows in RTI');
58:
59: if (SQL%ROWCOUNT > 0) then
60: k := k+1;
61: x_lcm_int.extend;

Line 66: asn_debug.put_line('did not update interface id: ' || p_int_rec(i).interface_id);

62: x_lcm_int(k) := p_int_rec(i).interface_id;
63: end if;
64:
65: else
66: asn_debug.put_line('did not update interface id: ' || p_int_rec(i).interface_id);
67: asn_debug.put_line('unit_landed_cost: ' || p_int_rec(i).unit_landed_cost);
68: asn_debug.put_line('lcm_shipment_line_id: ' || p_int_rec(i).lcm_shipment_line_id);
69: asn_debug.put_line('interface_id: ' || p_int_rec(i).interface_id);
70:

Line 67: asn_debug.put_line('unit_landed_cost: ' || p_int_rec(i).unit_landed_cost);

63: end if;
64:
65: else
66: asn_debug.put_line('did not update interface id: ' || p_int_rec(i).interface_id);
67: asn_debug.put_line('unit_landed_cost: ' || p_int_rec(i).unit_landed_cost);
68: asn_debug.put_line('lcm_shipment_line_id: ' || p_int_rec(i).lcm_shipment_line_id);
69: asn_debug.put_line('interface_id: ' || p_int_rec(i).interface_id);
70:
71: end if;

Line 68: asn_debug.put_line('lcm_shipment_line_id: ' || p_int_rec(i).lcm_shipment_line_id);

64:
65: else
66: asn_debug.put_line('did not update interface id: ' || p_int_rec(i).interface_id);
67: asn_debug.put_line('unit_landed_cost: ' || p_int_rec(i).unit_landed_cost);
68: asn_debug.put_line('lcm_shipment_line_id: ' || p_int_rec(i).lcm_shipment_line_id);
69: asn_debug.put_line('interface_id: ' || p_int_rec(i).interface_id);
70:
71: end if;
72:

Line 69: asn_debug.put_line('interface_id: ' || p_int_rec(i).interface_id);

65: else
66: asn_debug.put_line('did not update interface id: ' || p_int_rec(i).interface_id);
67: asn_debug.put_line('unit_landed_cost: ' || p_int_rec(i).unit_landed_cost);
68: asn_debug.put_line('lcm_shipment_line_id: ' || p_int_rec(i).lcm_shipment_line_id);
69: asn_debug.put_line('interface_id: ' || p_int_rec(i).interface_id);
70:
71: end if;
72:
73: end loop;

Line 75: asn_debug.put_line('Updated : '||l_row_count||' rows in RTI');

71: end if;
72:
73: end loop;
74:
75: asn_debug.put_line('Updated : '||l_row_count||' rows in RTI');
76:
77: l_lpn_group_rti_count := 0;
78: for i in 1..p_int_rec.COUNT loop
79:

Line 94: asn_debug.put_line('lpn_group_id: '||l_lpn_group_id);

90: -- /* If a non-lcm line and lcm line are tied to the same lpn_group_id, we
91: -- need to set the non-lcm line to 'LC_PENDING' as these should be processed together.
92: -- */
93:
94: asn_debug.put_line('lpn_group_id: '||l_lpn_group_id);
95:
96: IF (l_lpn_group_id IS NOT NULL) THEN
97:
98: select count(1)

Line 105: asn_debug.put_line('LPN Group check : l_lpn_group_rti_count = ' ||l_lpn_group_rti_count);

101: where lpn_group_id = l_lpn_group_id
102: and (lcm_shipment_line_id is NULL OR unit_landed_cost is NULL)
103: and processing_status_code in ('LC_PENDING','LC_INTERFACED');
104:
105: asn_debug.put_line('LPN Group check : l_lpn_group_rti_count = ' ||l_lpn_group_rti_count);
106:
107: if (l_lpn_group_rti_count = 0) then
108:
109: UPDATE rcv_transactions_interface

Line 137: asn_debug.put_line('no of rtis updated: '||sql%rowcount||' for the lpn group id: '||l_lpn_group_id);

133:
134: )
135: );
136:
137: asn_debug.put_line('no of rtis updated: '||sql%rowcount||' for the lpn group id: '||l_lpn_group_id);
138: callRTP := TRUE;
139:
140: end if;
141: else

Line 156: asn_debug.put_line('asn_type = ' ||l_asn_type);

152: l_header_interface_id := -9999;
153: l_rhi_group_id := -9999;
154: end;
155:
156: asn_debug.put_line('asn_type = ' ||l_asn_type);
157: asn_debug.put_line('header_interface_id = ' ||l_header_interface_id);
158: asn_debug.put_line('rhi_group_id = ' ||l_rhi_group_id);
159:
160: IF (l_asn_type = 'ASN'

Line 157: asn_debug.put_line('header_interface_id = ' ||l_header_interface_id);

153: l_rhi_group_id := -9999;
154: end;
155:
156: asn_debug.put_line('asn_type = ' ||l_asn_type);
157: asn_debug.put_line('header_interface_id = ' ||l_header_interface_id);
158: asn_debug.put_line('rhi_group_id = ' ||l_rhi_group_id);
159:
160: IF (l_asn_type = 'ASN'
161: AND g_fail_if_one_line_fails = 'Y') THEN

Line 158: asn_debug.put_line('rhi_group_id = ' ||l_rhi_group_id);

154: end;
155:
156: asn_debug.put_line('asn_type = ' ||l_asn_type);
157: asn_debug.put_line('header_interface_id = ' ||l_header_interface_id);
158: asn_debug.put_line('rhi_group_id = ' ||l_rhi_group_id);
159:
160: IF (l_asn_type = 'ASN'
161: AND g_fail_if_one_line_fails = 'Y') THEN
162: select count(1)

Line 170: asn_debug.put_line('ASN check : l_lpn_group_rti_count = ' ||l_lpn_group_rti_count);

166: and group_id = l_rhi_group_id
167: and (lcm_shipment_line_id is NULL OR unit_landed_cost is NULL)
168: and processing_status_code in ('LC_PENDING','LC_INTERFACED');
169:
170: asn_debug.put_line('ASN check : l_lpn_group_rti_count = ' ||l_lpn_group_rti_count);
171:
172:
173: if (l_lpn_group_rti_count = 0) then
174:

Line 204: asn_debug.put_line('rtis updated: '||sql%rowcount||' for the header interface id: '||l_header_interface_id);

200:
201: )
202: );
203:
204: asn_debug.put_line('rtis updated: '||sql%rowcount||' for the header interface id: '||l_header_interface_id);
205: callRTP := TRUE;
206:
207: end if;
208: ELSE

Line 231: asn_debug.put_line('rti updated for the interface id: '||p_int_rec(i).interface_id);

227: and lcm_shipment_line_id is not NULL
228: and unit_landed_cost is not NULL
229: );
230:
231: asn_debug.put_line('rti updated for the interface id: '||p_int_rec(i).interface_id);
232: callRTP := TRUE;
233: END IF;
234:
235: end if;

Line 242: asn_debug.put_line('calling RTP for group id: '||l_group_id);

238:
239: if (callRTP) then
240:
241: COMMIT;
242: asn_debug.put_line('calling RTP for group id: '||l_group_id);
243: l_req_id := fnd_request.submit_request('PO', 'RVCTP',null,null,false,'BATCH',l_group_id,NULL,NULL,
244: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
245: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
246: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 256: asn_debug.put_line('request id: '||l_req_id, 'insertlcm', '9');

252: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
253: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
254: NULL, NULL, NULL, NULL, NULL, NULL);
255:
256: asn_debug.put_line('request id: '||l_req_id, 'insertlcm', '9');
257:
258: if (l_req_id <= 0 or l_req_id is null) then
259: raise fnd_api.g_exc_unexpected_error;
260: end if;

Line 269: asn_debug.put_line('encountered an error in update_rti: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000));

265:
266: EXCEPTION
267: WHEN OTHERS THEN
268:
269: asn_debug.put_line('encountered an error in update_rti: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000));
270: asn_debug.put_line('Updated : '||l_row_count||' rows in RTI');
271:
272: COMMIT;
273:

Line 270: asn_debug.put_line('Updated : '||l_row_count||' rows in RTI');

266: EXCEPTION
267: WHEN OTHERS THEN
268:
269: asn_debug.put_line('encountered an error in update_rti: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000));
270: asn_debug.put_line('Updated : '||l_row_count||' rows in RTI');
271:
272: COMMIT;
273:
274: END update_rti;