APPS.RCV_CALL_LCM_WS dependencies on ASN_DEBUG

Line 57: asn_debug.put_line('Entering RCV_CALL_LCM_WS.insertLCM' || to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));

53: l_msg_data VARCHAR2(2000);
54:
55: BEGIN
56:
57: asn_debug.put_line('Entering RCV_CALL_LCM_WS.insertLCM' || to_char(sysdate,'DD-MON-YYYY HH:MI:SS'));
58:
59: -- Bug 9411154
60: l_ret := fnd_concurrent.set_completion_status('NORMAL', 'Success');
61:

Line 69: asn_debug.put_line('No of rows from RSH to be inserted: ' || p_rti_rec.COUNT);

65:
66: open c_rsh_rti;
67: fetch c_rsh_rti BULK COLLECT INTO p_rti_rec;
68:
69: asn_debug.put_line('No of rows from RSH to be inserted: ' || p_rti_rec.COUNT);
70:
71:
72: IF p_rti_rec.first IS NOT NULL THEN
73:

Line 74: asn_debug.put_line('calling LCM API for RSH');

70:
71:
72: IF p_rti_rec.first IS NOT NULL THEN
73:
74: asn_debug.put_line('calling LCM API for RSH');
75:
76: INL_INTEGRATION_GRP.Import_FromRCV(p_rti_rec,
77: l_return_status,
78: l_msg_count,

Line 81: asn_debug.put_line('after calling LCM API for RSH: ' || p_rti_rec.COUNT);

77: l_return_status,
78: l_msg_count,
79: l_msg_data );
80:
81: asn_debug.put_line('after calling LCM API for RSH: ' || p_rti_rec.COUNT);
82:
83: -- Setting error bufer and return code
84: IF l_msg_count = 1 THEN
85: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);

Line 111: asn_debug.put_line('before closing the RSH cursor');

107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108: END IF;
109: END IF;
110:
111: asn_debug.put_line('before closing the RSH cursor');
112:
113: IF c_rsh_rti%ISOPEN THEN
114: CLOSE c_rsh_rti;
115: END IF;

Line 121: asn_debug.put_line('fetching the RHI cursor');

117: p_rti_rec.delete;
118:
119: open c_rhi_rti;
120:
121: asn_debug.put_line('fetching the RHI cursor');
122:
123: fetch c_rhi_rti BULK COLLECT INTO p_rti_rec;
124:
125:

Line 126: asn_debug.put_line('No of rows from RHI to be inserted: ' || p_rti_rec.COUNT);

122:
123: fetch c_rhi_rti BULK COLLECT INTO p_rti_rec;
124:
125:
126: asn_debug.put_line('No of rows from RHI to be inserted: ' || p_rti_rec.COUNT);
127:
128: IF p_rti_rec.first IS NOT NULL THEN
129:
130: asn_debug.put_line('calling LCM API for RHI' || p_rti_rec.COUNT);

Line 130: asn_debug.put_line('calling LCM API for RHI' || p_rti_rec.COUNT);

126: asn_debug.put_line('No of rows from RHI to be inserted: ' || p_rti_rec.COUNT);
127:
128: IF p_rti_rec.first IS NOT NULL THEN
129:
130: asn_debug.put_line('calling LCM API for RHI' || p_rti_rec.COUNT);
131:
132: INL_INTEGRATION_GRP.Import_FromRCV(p_rti_rec,
133: l_return_status,
134: l_msg_count,

Line 137: asn_debug.put_line(' after calling LCM API for RHI' || p_rti_rec.COUNT);

133: l_return_status,
134: l_msg_count,
135: l_msg_data);
136:
137: asn_debug.put_line(' after calling LCM API for RHI' || p_rti_rec.COUNT);
138:
139: -- Setting error bufer and return code
140: IF l_msg_count = 1 THEN
141: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msg_data);

Line 167: asn_debug.put_line('before closing the RHI cursor');

163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165: END IF;
166:
167: asn_debug.put_line('before closing the RHI cursor');
168: IF c_rhi_rti%ISOPEN THEN
169: CLOSE c_rhi_rti;
170: END IF;
171:

Line 180: asn_debug.put_line('the error is: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000));

176: END IF;
177: IF c_rhi_rti%ISOPEN THEN
178: CLOSE c_rhi_rti;
179: END IF;
180: asn_debug.put_line('the error is: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000));
181: x_retcode := 1;
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
183: IF c_rsh_rti%ISOPEN THEN
184: CLOSE c_rsh_rti;

Line 189: asn_debug.put_line('the error is: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000));

185: END IF;
186: IF c_rhi_rti%ISOPEN THEN
187: CLOSE c_rhi_rti;
188: END IF;
189: asn_debug.put_line('the error is: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000));
190: x_retcode := 2;
191: WHEN OTHERS THEN
192: IF c_rsh_rti%ISOPEN THEN
193: CLOSE c_rsh_rti;

Line 198: asn_debug.put_line('the error is: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000));

194: END IF;
195: IF c_rhi_rti%ISOPEN THEN
196: CLOSE c_rhi_rti;
197: END IF;
198: asn_debug.put_line('the error is: ' || sqlcode ||' '||substr(SQLERRM, 1, 1000));
199: l_ret := fnd_concurrent.set_completion_status('ERROR', 'Error');
200: x_retcode := 2;
201: x_errbuf := 'Error';
202: END insertLCM;