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.OKC_OC_INT_SALESCDT_PVT dependencies on OKC_UTIL

Line 93: IF okc_util.l_trace_flag OR okc_util.l_log_flag THEN

89: PROCEDURE print_error(pos IN NUMBER) IS
90: x_msg_count NUMBER;
91: x_msg_data VARCHAR2(1000);
92: BEGIN
93: IF okc_util.l_trace_flag OR okc_util.l_log_flag THEN
94: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
95: p_data => x_msg_data
96: );
97: IF (l_debug = 'Y') THEN

Line 98: okc_util.print_trace(pos, '==EXCEPTION=================');

94: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
95: p_data => x_msg_data
96: );
97: IF (l_debug = 'Y') THEN
98: okc_util.print_trace(pos, '==EXCEPTION=================');
99: END IF;
100: x_msg_data := fnd_msg_pub.get( p_msg_index => x_msg_count,
101: p_encoded => 'F'
102: );

Line 104: okc_util.print_trace(pos, 'Message : '||x_msg_data);

100: x_msg_data := fnd_msg_pub.get( p_msg_index => x_msg_count,
101: p_encoded => 'F'
102: );
103: IF (l_debug = 'Y') THEN
104: okc_util.print_trace(pos, 'Message : '||x_msg_data);
105: okc_util.print_trace(pos, '============================');
106: END IF;
107: END IF;
108: END print_error;

Line 105: okc_util.print_trace(pos, '============================');

101: p_encoded => 'F'
102: );
103: IF (l_debug = 'Y') THEN
104: okc_util.print_trace(pos, 'Message : '||x_msg_data);
105: okc_util.print_trace(pos, '============================');
106: END IF;
107: END IF;
108: END print_error;
109:

Line 123: okc_util.print_trace(1, '>START - OKC_OC_INT_SALESCDT_PVT.CLEANUP - Initialize global PL/SQL Tables');

119: -----------------------------------------------------------------------------
120: PROCEDURE cleanup(x_return_status OUT NOCOPY varchar2 ) IS
121: BEGIN
122: IF (l_debug = 'Y') THEN
123: okc_util.print_trace(1, '>START - OKC_OC_INT_SALESCDT_PVT.CLEANUP - Initialize global PL/SQL Tables');
124: okc_util.print_trace(1, ' ');
125: END IF;
126:
127: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 124: okc_util.print_trace(1, ' ');

120: PROCEDURE cleanup(x_return_status OUT NOCOPY varchar2 ) IS
121: BEGIN
122: IF (l_debug = 'Y') THEN
123: okc_util.print_trace(1, '>START - OKC_OC_INT_SALESCDT_PVT.CLEANUP - Initialize global PL/SQL Tables');
124: okc_util.print_trace(1, ' ');
125: END IF;
126:
127: x_return_status := OKC_API.G_RET_STS_SUCCESS;
128:

Line 130: okc_util.print_trace(2, 'Cleaning up plsql tables');

126:
127: x_return_status := OKC_API.G_RET_STS_SUCCESS;
128:
129: IF (l_debug = 'Y') THEN
130: okc_util.print_trace(2, 'Cleaning up plsql tables');
131: END IF;
132:
133: --sales credits
134: g_sales_credit_tab.DELETE;

Line 138: okc_util.print_trace(2, 'Done Cleaning up');

134: g_sales_credit_tab.DELETE;
135: lx_sales_credit_tab.DELETE;
136:
137: IF (l_debug = 'Y') THEN
138: okc_util.print_trace(2, 'Done Cleaning up');
139: okc_util.print_trace(1, ' 140: END IF;
141: EXCEPTION
142: WHEN OTHERS THEN

Line 139: okc_util.print_trace(1, '

135: lx_sales_credit_tab.DELETE;
136:
137: IF (l_debug = 'Y') THEN
138: okc_util.print_trace(2, 'Done Cleaning up');
139: okc_util.print_trace(1, ' 140: END IF;
141: EXCEPTION
142: WHEN OTHERS THEN
143: OKC_API.set_message(G_APP_NAME,

Line 186: OKC_UTIL.print_trace(1, ' ');

182: x_return_status := l_return_status;
183:
184:
185: IF (l_debug = 'Y') THEN
186: OKC_UTIL.print_trace(1, ' ');
187: OKC_UTIL.print_trace(1, '================================================');
188: OKC_UTIL.print_trace(1, 'INITIALIZE GLOBAL PLSQL TABLES ');
189: OKC_UTIL.print_trace(1, '================================================');
190: OKC_UTIL.print_trace(1, ' ');

Line 187: OKC_UTIL.print_trace(1, '================================================');

183:
184:
185: IF (l_debug = 'Y') THEN
186: OKC_UTIL.print_trace(1, ' ');
187: OKC_UTIL.print_trace(1, '================================================');
188: OKC_UTIL.print_trace(1, 'INITIALIZE GLOBAL PLSQL TABLES ');
189: OKC_UTIL.print_trace(1, '================================================');
190: OKC_UTIL.print_trace(1, ' ');
191: OKC_UTIL.print_trace(1, ' ');

Line 188: OKC_UTIL.print_trace(1, 'INITIALIZE GLOBAL PLSQL TABLES ');

184:
185: IF (l_debug = 'Y') THEN
186: OKC_UTIL.print_trace(1, ' ');
187: OKC_UTIL.print_trace(1, '================================================');
188: OKC_UTIL.print_trace(1, 'INITIALIZE GLOBAL PLSQL TABLES ');
189: OKC_UTIL.print_trace(1, '================================================');
190: OKC_UTIL.print_trace(1, ' ');
191: OKC_UTIL.print_trace(1, ' ');
192: END IF;

Line 189: OKC_UTIL.print_trace(1, '================================================');

185: IF (l_debug = 'Y') THEN
186: OKC_UTIL.print_trace(1, ' ');
187: OKC_UTIL.print_trace(1, '================================================');
188: OKC_UTIL.print_trace(1, 'INITIALIZE GLOBAL PLSQL TABLES ');
189: OKC_UTIL.print_trace(1, '================================================');
190: OKC_UTIL.print_trace(1, ' ');
191: OKC_UTIL.print_trace(1, ' ');
192: END IF;
193:

Line 190: OKC_UTIL.print_trace(1, ' ');

186: OKC_UTIL.print_trace(1, ' ');
187: OKC_UTIL.print_trace(1, '================================================');
188: OKC_UTIL.print_trace(1, 'INITIALIZE GLOBAL PLSQL TABLES ');
189: OKC_UTIL.print_trace(1, '================================================');
190: OKC_UTIL.print_trace(1, ' ');
191: OKC_UTIL.print_trace(1, ' ');
192: END IF;
193:
194: cleanup(x_return_status => l_return_status);

Line 191: OKC_UTIL.print_trace(1, ' ');

187: OKC_UTIL.print_trace(1, '================================================');
188: OKC_UTIL.print_trace(1, 'INITIALIZE GLOBAL PLSQL TABLES ');
189: OKC_UTIL.print_trace(1, '================================================');
190: OKC_UTIL.print_trace(1, ' ');
191: OKC_UTIL.print_trace(1, ' ');
192: END IF;
193:
194: cleanup(x_return_status => l_return_status);
195: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

Line 203: OKC_UTIL.print_trace(1, ' ');

199: END IF;
200:
201:
202: IF (l_debug = 'Y') THEN
203: OKC_UTIL.print_trace(1, ' ');
204: OKC_UTIL.print_trace(1, 'Create Contract Sales Credit');
205: OKC_UTIL.print_trace(1, '-----------------------------------------------');
206: OKC_UTIL.print_trace(1, '>START - ******* OKC_OC_INT_SALESCDT_PVT.create_k_sales_credit -');
207: END IF;

Line 204: OKC_UTIL.print_trace(1, 'Create Contract Sales Credit');

200:
201:
202: IF (l_debug = 'Y') THEN
203: OKC_UTIL.print_trace(1, ' ');
204: OKC_UTIL.print_trace(1, 'Create Contract Sales Credit');
205: OKC_UTIL.print_trace(1, '-----------------------------------------------');
206: OKC_UTIL.print_trace(1, '>START - ******* OKC_OC_INT_SALESCDT_PVT.create_k_sales_credit -');
207: END IF;
208:

Line 205: OKC_UTIL.print_trace(1, '-----------------------------------------------');

201:
202: IF (l_debug = 'Y') THEN
203: OKC_UTIL.print_trace(1, ' ');
204: OKC_UTIL.print_trace(1, 'Create Contract Sales Credit');
205: OKC_UTIL.print_trace(1, '-----------------------------------------------');
206: OKC_UTIL.print_trace(1, '>START - ******* OKC_OC_INT_SALESCDT_PVT.create_k_sales_credit -');
207: END IF;
208:
209:

Line 206: OKC_UTIL.print_trace(1, '>START - ******* OKC_OC_INT_SALESCDT_PVT.create_k_sales_credit -');

202: IF (l_debug = 'Y') THEN
203: OKC_UTIL.print_trace(1, ' ');
204: OKC_UTIL.print_trace(1, 'Create Contract Sales Credit');
205: OKC_UTIL.print_trace(1, '-----------------------------------------------');
206: OKC_UTIL.print_trace(1, '>START - ******* OKC_OC_INT_SALESCDT_PVT.create_k_sales_credit -');
207: END IF;
208:
209:
210: --<>

Line 215: OKC_UTIL.print_trace(2, 'Calling get_sales_credit at HEADER level-');

211:
212: --get sales credit information from ASO or ONT at the HEADER level
213: --and store it in global PL/SQL table g_sales_credit_tab
214: IF (l_debug = 'Y') THEN
215: OKC_UTIL.print_trace(2, 'Calling get_sales_credit at HEADER level-');
216: OKC_UTIL.print_trace(2, 'Contract Id- '|| p_chr_id);
217: OKC_UTIL.print_trace(2, 'Quote Id - '|| p_qhr_id);
218: OKC_UTIL.print_trace(2, 'Order Id - '|| p_ohr_id);
219: END IF;

Line 216: OKC_UTIL.print_trace(2, 'Contract Id- '|| p_chr_id);

212: --get sales credit information from ASO or ONT at the HEADER level
213: --and store it in global PL/SQL table g_sales_credit_tab
214: IF (l_debug = 'Y') THEN
215: OKC_UTIL.print_trace(2, 'Calling get_sales_credit at HEADER level-');
216: OKC_UTIL.print_trace(2, 'Contract Id- '|| p_chr_id);
217: OKC_UTIL.print_trace(2, 'Quote Id - '|| p_qhr_id);
218: OKC_UTIL.print_trace(2, 'Order Id - '|| p_ohr_id);
219: END IF;
220: get_sales_credit (

Line 217: OKC_UTIL.print_trace(2, 'Quote Id - '|| p_qhr_id);

213: --and store it in global PL/SQL table g_sales_credit_tab
214: IF (l_debug = 'Y') THEN
215: OKC_UTIL.print_trace(2, 'Calling get_sales_credit at HEADER level-');
216: OKC_UTIL.print_trace(2, 'Contract Id- '|| p_chr_id);
217: OKC_UTIL.print_trace(2, 'Quote Id - '|| p_qhr_id);
218: OKC_UTIL.print_trace(2, 'Order Id - '|| p_ohr_id);
219: END IF;
220: get_sales_credit (
221: p_chr_id => p_chr_id,

Line 218: OKC_UTIL.print_trace(2, 'Order Id - '|| p_ohr_id);

214: IF (l_debug = 'Y') THEN
215: OKC_UTIL.print_trace(2, 'Calling get_sales_credit at HEADER level-');
216: OKC_UTIL.print_trace(2, 'Contract Id- '|| p_chr_id);
217: OKC_UTIL.print_trace(2, 'Quote Id - '|| p_qhr_id);
218: OKC_UTIL.print_trace(2, 'Order Id - '|| p_ohr_id);
219: END IF;
220: get_sales_credit (
221: p_chr_id => p_chr_id,
222: p_q_flag => p_q_flag,

Line 228: OKC_UTIL.print_trace(2, 'Header level call to get_sales_credit finished successfully');

224: p_o_flag => p_o_flag,
225: p_ohr_id => p_ohr_id
226: );
227: IF (l_debug = 'Y') THEN
228: OKC_UTIL.print_trace(2, 'Header level call to get_sales_credit finished successfully');
229: OKC_UTIL.print_trace(2, 'Output in global PL/SQL table g_sales_credit_tab');
230: END IF;
231:
232:

Line 229: OKC_UTIL.print_trace(2, 'Output in global PL/SQL table g_sales_credit_tab');

225: p_ohr_id => p_ohr_id
226: );
227: IF (l_debug = 'Y') THEN
228: OKC_UTIL.print_trace(2, 'Header level call to get_sales_credit finished successfully');
229: OKC_UTIL.print_trace(2, 'Output in global PL/SQL table g_sales_credit_tab');
230: END IF;
231:
232:
233: --get sales credit information from ASO or ONT at the LINE level

Line 237: OKC_UTIL.print_trace(2, 'Calling get_sales_credit at LINE level-');

233: --get sales credit information from ASO or ONT at the LINE level
234: --and append it to global PL/SQL table g_sales_credit_tab which will then
235: --contain BOTH header AND line level information
236: IF (l_debug = 'Y') THEN
237: OKC_UTIL.print_trace(2, 'Calling get_sales_credit at LINE level-');
238: OKC_UTIL.print_trace(2, 'Contract Id- '|| p_chr_id);
239: OKC_UTIL.print_trace(2, 'Quote Id - '|| p_qhr_id);
240: OKC_UTIL.print_trace(2, 'Order Id - '|| p_ohr_id);
241: OKC_UTIL.print_trace(2, 'PL/SQL table p_line_inf_tab- related quote or order lines and contract lines');

Line 238: OKC_UTIL.print_trace(2, 'Contract Id- '|| p_chr_id);

234: --and append it to global PL/SQL table g_sales_credit_tab which will then
235: --contain BOTH header AND line level information
236: IF (l_debug = 'Y') THEN
237: OKC_UTIL.print_trace(2, 'Calling get_sales_credit at LINE level-');
238: OKC_UTIL.print_trace(2, 'Contract Id- '|| p_chr_id);
239: OKC_UTIL.print_trace(2, 'Quote Id - '|| p_qhr_id);
240: OKC_UTIL.print_trace(2, 'Order Id - '|| p_ohr_id);
241: OKC_UTIL.print_trace(2, 'PL/SQL table p_line_inf_tab- related quote or order lines and contract lines');
242: END IF;

Line 239: OKC_UTIL.print_trace(2, 'Quote Id - '|| p_qhr_id);

235: --contain BOTH header AND line level information
236: IF (l_debug = 'Y') THEN
237: OKC_UTIL.print_trace(2, 'Calling get_sales_credit at LINE level-');
238: OKC_UTIL.print_trace(2, 'Contract Id- '|| p_chr_id);
239: OKC_UTIL.print_trace(2, 'Quote Id - '|| p_qhr_id);
240: OKC_UTIL.print_trace(2, 'Order Id - '|| p_ohr_id);
241: OKC_UTIL.print_trace(2, 'PL/SQL table p_line_inf_tab- related quote or order lines and contract lines');
242: END IF;
243: get_sales_credit (

Line 240: OKC_UTIL.print_trace(2, 'Order Id - '|| p_ohr_id);

236: IF (l_debug = 'Y') THEN
237: OKC_UTIL.print_trace(2, 'Calling get_sales_credit at LINE level-');
238: OKC_UTIL.print_trace(2, 'Contract Id- '|| p_chr_id);
239: OKC_UTIL.print_trace(2, 'Quote Id - '|| p_qhr_id);
240: OKC_UTIL.print_trace(2, 'Order Id - '|| p_ohr_id);
241: OKC_UTIL.print_trace(2, 'PL/SQL table p_line_inf_tab- related quote or order lines and contract lines');
242: END IF;
243: get_sales_credit (
244: p_chr_id => p_chr_id,

Line 241: OKC_UTIL.print_trace(2, 'PL/SQL table p_line_inf_tab- related quote or order lines and contract lines');

237: OKC_UTIL.print_trace(2, 'Calling get_sales_credit at LINE level-');
238: OKC_UTIL.print_trace(2, 'Contract Id- '|| p_chr_id);
239: OKC_UTIL.print_trace(2, 'Quote Id - '|| p_qhr_id);
240: OKC_UTIL.print_trace(2, 'Order Id - '|| p_ohr_id);
241: OKC_UTIL.print_trace(2, 'PL/SQL table p_line_inf_tab- related quote or order lines and contract lines');
242: END IF;
243: get_sales_credit (
244: p_chr_id => p_chr_id,
245: p_q_flag => p_q_flag,

Line 252: OKC_UTIL.print_trace(2, 'Line level call to get_sales_credit finished successfully');

248: p_ohr_id => p_ohr_id,
249: p_line_inf_tab => p_line_inf_tab
250: );
251: IF (l_debug = 'Y') THEN
252: OKC_UTIL.print_trace(2, 'Line level call to get_sales_credit finished successfully');
253: OKC_UTIL.print_trace(2, 'Output in global PL/SQL table g_sale_credits_tab');
254: END IF;
255:
256: --now put this sales credits information in OKC

Line 253: OKC_UTIL.print_trace(2, 'Output in global PL/SQL table g_sale_credits_tab');

249: p_line_inf_tab => p_line_inf_tab
250: );
251: IF (l_debug = 'Y') THEN
252: OKC_UTIL.print_trace(2, 'Line level call to get_sales_credit finished successfully');
253: OKC_UTIL.print_trace(2, 'Output in global PL/SQL table g_sale_credits_tab');
254: END IF;
255:
256: --now put this sales credits information in OKC
257: IF (l_debug = 'Y') THEN

Line 258: OKC_UTIL.print_trace(2, ' >Calling OKC_SALES_CREDIT_PVT.create_sales_credit');

254: END IF;
255:
256: --now put this sales credits information in OKC
257: IF (l_debug = 'Y') THEN
258: OKC_UTIL.print_trace(2, ' >Calling OKC_SALES_CREDIT_PVT.create_sales_credit');
259: OKC_UTIL.print_trace(2, 'input p_scrv_tbl => g_sales_credit_tab');
260: END IF;
261: IF g_sales_credit_tab.FIRST IS NOT NULL THEN
262:

Line 259: OKC_UTIL.print_trace(2, 'input p_scrv_tbl => g_sales_credit_tab');

255:
256: --now put this sales credits information in OKC
257: IF (l_debug = 'Y') THEN
258: OKC_UTIL.print_trace(2, ' >Calling OKC_SALES_CREDIT_PVT.create_sales_credit');
259: OKC_UTIL.print_trace(2, 'input p_scrv_tbl => g_sales_credit_tab');
260: END IF;
261: IF g_sales_credit_tab.FIRST IS NOT NULL THEN
262:
263: OKC_SALES_CREDIT_PVT.create_sales_credit(

Line 325: OKC_UTIL.print_trace(2, ' >Call to OKC_SALES_CREDIT_PVT.create_sales_credit finished successfully');

321: END IF;
322: END IF;
323:
324: IF (l_debug = 'Y') THEN
325: OKC_UTIL.print_trace(2, ' >Call to OKC_SALES_CREDIT_PVT.create_sales_credit finished successfully');
326: END IF;
327: --<>
328: -----------------------------------------------
329:

Line 332: OKC_UTIL.print_trace(1, '>END - ******* OKC_OC_INT_SALESCDT_PVT.create_k_sales_credit -');

328: -----------------------------------------------
329:
330:
331: IF (l_debug = 'Y') THEN
332: OKC_UTIL.print_trace(1, '>END - ******* OKC_OC_INT_SALESCDT_PVT.create_k_sales_credit -');
333: END IF;
334:
335:
336: EXCEPTION

Line 387: OKC_UTIL.print_trace(3, 'START --> get_sales_credit- ');

383: i BINARY_INTEGER := 0;
384:
385: BEGIN
386: IF (l_debug = 'Y') THEN
387: OKC_UTIL.print_trace(3, 'START --> get_sales_credit- ');
388: OKC_UTIL.print_trace(3, 'Contract Id - '|| p_chr_id);
389: OKC_UTIL.print_trace(3, 'Quote Id - '|| p_qhr_id);
390: OKC_UTIL.print_trace(3, 'Order Id - '|| p_ohr_id);
391: END IF;

Line 388: OKC_UTIL.print_trace(3, 'Contract Id - '|| p_chr_id);

384:
385: BEGIN
386: IF (l_debug = 'Y') THEN
387: OKC_UTIL.print_trace(3, 'START --> get_sales_credit- ');
388: OKC_UTIL.print_trace(3, 'Contract Id - '|| p_chr_id);
389: OKC_UTIL.print_trace(3, 'Quote Id - '|| p_qhr_id);
390: OKC_UTIL.print_trace(3, 'Order Id - '|| p_ohr_id);
391: END IF;
392:

Line 389: OKC_UTIL.print_trace(3, 'Quote Id - '|| p_qhr_id);

385: BEGIN
386: IF (l_debug = 'Y') THEN
387: OKC_UTIL.print_trace(3, 'START --> get_sales_credit- ');
388: OKC_UTIL.print_trace(3, 'Contract Id - '|| p_chr_id);
389: OKC_UTIL.print_trace(3, 'Quote Id - '|| p_qhr_id);
390: OKC_UTIL.print_trace(3, 'Order Id - '|| p_ohr_id);
391: END IF;
392:
393: --get all the sales credit for the quote header (or order header)

Line 390: OKC_UTIL.print_trace(3, 'Order Id - '|| p_ohr_id);

386: IF (l_debug = 'Y') THEN
387: OKC_UTIL.print_trace(3, 'START --> get_sales_credit- ');
388: OKC_UTIL.print_trace(3, 'Contract Id - '|| p_chr_id);
389: OKC_UTIL.print_trace(3, 'Quote Id - '|| p_qhr_id);
390: OKC_UTIL.print_trace(3, 'Order Id - '|| p_ohr_id);
391: END IF;
392:
393: --get all the sales credit for the quote header (or order header)
394: --for processing at the header level

Line 400: OKC_UTIL.print_trace(3, 'Calling get_sales_credit_tab with p_chr_id and p_qhr_id/p_ohr_id for processing at header level');

396: IF p_q_flag = OKC_API.G_TRUE AND p_qhr_id IS NOT NULL AND p_qhr_id <> OKC_API.G_MISS_NUM AND
397: p_line_inf_tab.FIRST IS NULL
398: THEN
399: IF (l_debug = 'Y') THEN
400: OKC_UTIL.print_trace(3, 'Calling get_sales_credit_tab with p_chr_id and p_qhr_id/p_ohr_id for processing at header level');
401: END IF;
402: -- get_sales_credit_tab stores it's output in g_sales_credit_tab
403: get_sales_credit_tab(p_chr_id => p_chr_id,
404: p_q_flag => p_q_flag,

Line 408: OKC_UTIL.print_trace(3, 'Call to get_sales_credit_tab finished successfully');

404: p_q_flag => p_q_flag,
405: p_qhr_id => p_qhr_id
406: );
407: IF (l_debug = 'Y') THEN
408: OKC_UTIL.print_trace(3, 'Call to get_sales_credit_tab finished successfully');
409: END IF;
410:
411: ELSIF p_o_flag = OKC_API.G_TRUE AND p_ohr_id IS NOT NULL AND p_ohr_id <> OKC_API.G_MISS_NUM AND
412: p_line_inf_tab.FIRST IS NULL

Line 415: OKC_UTIL.print_trace(3, 'Calling get_sales_credit_tab with p_chr_id and p_qhr_id/p_ohr_id for processing at header level');

411: ELSIF p_o_flag = OKC_API.G_TRUE AND p_ohr_id IS NOT NULL AND p_ohr_id <> OKC_API.G_MISS_NUM AND
412: p_line_inf_tab.FIRST IS NULL
413: THEN
414: IF (l_debug = 'Y') THEN
415: OKC_UTIL.print_trace(3, 'Calling get_sales_credit_tab with p_chr_id and p_qhr_id/p_ohr_id for processing at header level');
416: END IF;
417: -- get_sales_credit_tab stores it's output in g_sales_credit_tab
418: get_sales_credit_tab(p_chr_id => p_chr_id,
419: p_o_flag => p_o_flag,

Line 423: OKC_UTIL.print_trace(3, 'Call to get_sales_credit_tab finished successfully');

419: p_o_flag => p_o_flag,
420: p_ohr_id => p_ohr_id
421: );
422: IF (l_debug = 'Y') THEN
423: OKC_UTIL.print_trace(3, 'Call to get_sales_credit_tab finished successfully');
424: END IF;
425: END IF;
426:
427:

Line 435: OKC_UTIL.print_trace(3, 'Calling get_sales_credit_tab with p_chr_id and p_qhr_id/p_ohr_id and p_line_inf_tab for processing at line level');

431: --keeping intact the header level information that g_sales_credit_tab may
432: --already contain.
433: IF p_line_inf_tab.FIRST IS NOT NULL THEN
434: IF (l_debug = 'Y') THEN
435: OKC_UTIL.print_trace(3, 'Calling get_sales_credit_tab with p_chr_id and p_qhr_id/p_ohr_id and p_line_inf_tab for processing at line level');
436: END IF;
437:
438: i := p_line_inf_tab.FIRST;
439: WHILE i IS NOT NULL LOOP

Line 467: OKC_UTIL.print_trace(3, 'Call to get_sales_credit_tab finished successfully');

463: END LOOP;
464: END IF;
465:
466: IF (l_debug = 'Y') THEN
467: OKC_UTIL.print_trace(3, 'Call to get_sales_credit_tab finished successfully');
468: OKC_UTIL.print_trace(3, 'END --> get_sales_credit ');
469: END IF;
470: EXCEPTION
471: WHEN OTHERS THEN

Line 468: OKC_UTIL.print_trace(3, 'END --> get_sales_credit ');

464: END IF;
465:
466: IF (l_debug = 'Y') THEN
467: OKC_UTIL.print_trace(3, 'Call to get_sales_credit_tab finished successfully');
468: OKC_UTIL.print_trace(3, 'END --> get_sales_credit ');
469: END IF;
470: EXCEPTION
471: WHEN OTHERS THEN
472: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 566: OKC_UTIL.print_trace(4, 'START --> get_sales_credit_tab- ');

562:
563: BEGIN
564:
565: IF (l_debug = 'Y') THEN
566: OKC_UTIL.print_trace(4, 'START --> get_sales_credit_tab- ');
567: OKC_UTIL.print_trace(4, 'Contract Id - '|| p_chr_id);
568: OKC_UTIL.print_trace(4, 'Contract Line Id - '|| p_cle_id);
569: OKC_UTIL.print_trace(4, 'Quote Id - '|| p_qhr_id);
570: OKC_UTIL.print_trace(4, 'Quote Line Id - '|| p_qle_id);

Line 567: OKC_UTIL.print_trace(4, 'Contract Id - '|| p_chr_id);

563: BEGIN
564:
565: IF (l_debug = 'Y') THEN
566: OKC_UTIL.print_trace(4, 'START --> get_sales_credit_tab- ');
567: OKC_UTIL.print_trace(4, 'Contract Id - '|| p_chr_id);
568: OKC_UTIL.print_trace(4, 'Contract Line Id - '|| p_cle_id);
569: OKC_UTIL.print_trace(4, 'Quote Id - '|| p_qhr_id);
570: OKC_UTIL.print_trace(4, 'Quote Line Id - '|| p_qle_id);
571: OKC_UTIL.print_trace(4, 'Order Id - '|| p_ohr_id);

Line 568: OKC_UTIL.print_trace(4, 'Contract Line Id - '|| p_cle_id);

564:
565: IF (l_debug = 'Y') THEN
566: OKC_UTIL.print_trace(4, 'START --> get_sales_credit_tab- ');
567: OKC_UTIL.print_trace(4, 'Contract Id - '|| p_chr_id);
568: OKC_UTIL.print_trace(4, 'Contract Line Id - '|| p_cle_id);
569: OKC_UTIL.print_trace(4, 'Quote Id - '|| p_qhr_id);
570: OKC_UTIL.print_trace(4, 'Quote Line Id - '|| p_qle_id);
571: OKC_UTIL.print_trace(4, 'Order Id - '|| p_ohr_id);
572: OKC_UTIL.print_trace(4, 'Order Line Id - '|| p_ole_id);

Line 569: OKC_UTIL.print_trace(4, 'Quote Id - '|| p_qhr_id);

565: IF (l_debug = 'Y') THEN
566: OKC_UTIL.print_trace(4, 'START --> get_sales_credit_tab- ');
567: OKC_UTIL.print_trace(4, 'Contract Id - '|| p_chr_id);
568: OKC_UTIL.print_trace(4, 'Contract Line Id - '|| p_cle_id);
569: OKC_UTIL.print_trace(4, 'Quote Id - '|| p_qhr_id);
570: OKC_UTIL.print_trace(4, 'Quote Line Id - '|| p_qle_id);
571: OKC_UTIL.print_trace(4, 'Order Id - '|| p_ohr_id);
572: OKC_UTIL.print_trace(4, 'Order Line Id - '|| p_ole_id);
573: END IF;

Line 570: OKC_UTIL.print_trace(4, 'Quote Line Id - '|| p_qle_id);

566: OKC_UTIL.print_trace(4, 'START --> get_sales_credit_tab- ');
567: OKC_UTIL.print_trace(4, 'Contract Id - '|| p_chr_id);
568: OKC_UTIL.print_trace(4, 'Contract Line Id - '|| p_cle_id);
569: OKC_UTIL.print_trace(4, 'Quote Id - '|| p_qhr_id);
570: OKC_UTIL.print_trace(4, 'Quote Line Id - '|| p_qle_id);
571: OKC_UTIL.print_trace(4, 'Order Id - '|| p_ohr_id);
572: OKC_UTIL.print_trace(4, 'Order Line Id - '|| p_ole_id);
573: END IF;
574:

Line 571: OKC_UTIL.print_trace(4, 'Order Id - '|| p_ohr_id);

567: OKC_UTIL.print_trace(4, 'Contract Id - '|| p_chr_id);
568: OKC_UTIL.print_trace(4, 'Contract Line Id - '|| p_cle_id);
569: OKC_UTIL.print_trace(4, 'Quote Id - '|| p_qhr_id);
570: OKC_UTIL.print_trace(4, 'Quote Line Id - '|| p_qle_id);
571: OKC_UTIL.print_trace(4, 'Order Id - '|| p_ohr_id);
572: OKC_UTIL.print_trace(4, 'Order Line Id - '|| p_ole_id);
573: END IF;
574:
575:

Line 572: OKC_UTIL.print_trace(4, 'Order Line Id - '|| p_ole_id);

568: OKC_UTIL.print_trace(4, 'Contract Line Id - '|| p_cle_id);
569: OKC_UTIL.print_trace(4, 'Quote Id - '|| p_qhr_id);
570: OKC_UTIL.print_trace(4, 'Quote Line Id - '|| p_qle_id);
571: OKC_UTIL.print_trace(4, 'Order Id - '|| p_ohr_id);
572: OKC_UTIL.print_trace(4, 'Order Line Id - '|| p_ole_id);
573: END IF;
574:
575:
576: IF (p_q_flag = OKC_API.G_TRUE AND

Line 580: OKC_UTIL.print_trace(4, 'Processing sales credit information for Quote Id - '|| p_qhr_id);

576: IF (p_q_flag = OKC_API.G_TRUE AND
577: p_qhr_id IS NOT NULL AND
578: p_qhr_id <> OKC_API.G_MISS_NUM) THEN
579: IF (l_debug = 'Y') THEN
580: OKC_UTIL.print_trace(4, 'Processing sales credit information for Quote Id - '|| p_qhr_id);
581: END IF;
582: ELSIF (p_o_flag = OKC_API.G_TRUE AND
583: p_ohr_id IS NOT NULL AND
584: p_ohr_id <> OKC_API.G_MISS_NUM) THEN

Line 586: OKC_UTIL.print_trace(4, 'Processing sales credit information for Order Id - '|| p_ohr_id);

582: ELSIF (p_o_flag = OKC_API.G_TRUE AND
583: p_ohr_id IS NOT NULL AND
584: p_ohr_id <> OKC_API.G_MISS_NUM) THEN
585: IF (l_debug = 'Y') THEN
586: OKC_UTIL.print_trace(4, 'Processing sales credit information for Order Id - '|| p_ohr_id);
587: END IF;
588: END IF;
589:
590:

Line 621: OKC_UTIL.print_trace(4, 'percent: '|| l_source_sales_credit_rec.percent);

617: END IF;
618:
619: g_sales_credit_tab(i).percent := l_source_sales_credit_rec.percent;
620: IF (l_debug = 'Y') THEN
621: OKC_UTIL.print_trace(4, 'percent: '|| l_source_sales_credit_rec.percent);
622: END IF;
623:
624: /*********** contact creation no longer needed ***********
625: --each SALESREP_ID from the quote (or order) is created as a contact

Line 652: okc_util.print_trace(4, 'OUTPUT RECORD - OKO_OM_INT_OTK_PVT.create_contact_for_contract :');

648: --IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
649: -- x_return_status := l_return_status;
650: --END IF;
651: IF (l_debug = 'Y') THEN
652: okc_util.print_trace(4, 'OUTPUT RECORD - OKO_OM_INT_OTK_PVT.create_contact_for_contract :');
653: okc_util.print_trace(4, '===============================================');
654: END IF;
655: --okc_util.print_trace(4, 'Status = '||x_return_status);
656: IF (l_debug = 'Y') THEN

Line 653: okc_util.print_trace(4, '===============================================');

649: -- x_return_status := l_return_status;
650: --END IF;
651: IF (l_debug = 'Y') THEN
652: okc_util.print_trace(4, 'OUTPUT RECORD - OKO_OM_INT_OTK_PVT.create_contact_for_contract :');
653: okc_util.print_trace(4, '===============================================');
654: END IF;
655: --okc_util.print_trace(4, 'Status = '||x_return_status);
656: IF (l_debug = 'Y') THEN
657: okc_util.print_trace(4, 'Status = '||l_return_status);

Line 655: --okc_util.print_trace(4, 'Status = '||x_return_status);

651: IF (l_debug = 'Y') THEN
652: okc_util.print_trace(4, 'OUTPUT RECORD - OKO_OM_INT_OTK_PVT.create_contact_for_contract :');
653: okc_util.print_trace(4, '===============================================');
654: END IF;
655: --okc_util.print_trace(4, 'Status = '||x_return_status);
656: IF (l_debug = 'Y') THEN
657: okc_util.print_trace(4, 'Status = '||l_return_status);
658: END IF;
659: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 657: okc_util.print_trace(4, 'Status = '||l_return_status);

653: okc_util.print_trace(4, '===============================================');
654: END IF;
655: --okc_util.print_trace(4, 'Status = '||x_return_status);
656: IF (l_debug = 'Y') THEN
657: okc_util.print_trace(4, 'Status = '||l_return_status);
658: END IF;
659: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
660: IF (l_debug = 'Y') THEN
661: OKC_UTIL.print_trace(4,SQLERRM);

Line 661: OKC_UTIL.print_trace(4,SQLERRM);

657: okc_util.print_trace(4, 'Status = '||l_return_status);
658: END IF;
659: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
660: IF (l_debug = 'Y') THEN
661: OKC_UTIL.print_trace(4,SQLERRM);
662: END IF;
663: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
664: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
665: IF (l_debug = 'Y') THEN

Line 666: OKC_UTIL.print_trace(4,SQLERRM);

662: END IF;
663: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
664: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
665: IF (l_debug = 'Y') THEN
666: OKC_UTIL.print_trace(4,SQLERRM);
667: END IF;
668: RAISE OKC_API.G_EXCEPTION_ERROR;
669: END IF;
670:

Line 685: OKC_UTIL.print_trace(4, 'salesrep_id1: '|| l_source_sales_credit_rec.salesrep_id);

681: ---obsolete column g_sales_credit_tab(i).ctc_id := l_source_sales_credit_rec.salesrep_id;
682: g_sales_credit_tab(i).salesrep_id1 := l_source_sales_credit_rec.salesrep_id;
683: g_sales_credit_tab(i).salesrep_id2 := '#';
684: IF (l_debug = 'Y') THEN
685: OKC_UTIL.print_trace(4, 'salesrep_id1: '|| l_source_sales_credit_rec.salesrep_id);
686: OKC_UTIL.print_trace(4, 'salesrep_id2: #');
687: END IF;
688:
689:

Line 686: OKC_UTIL.print_trace(4, 'salesrep_id2: #');

682: g_sales_credit_tab(i).salesrep_id1 := l_source_sales_credit_rec.salesrep_id;
683: g_sales_credit_tab(i).salesrep_id2 := '#';
684: IF (l_debug = 'Y') THEN
685: OKC_UTIL.print_trace(4, 'salesrep_id1: '|| l_source_sales_credit_rec.salesrep_id);
686: OKC_UTIL.print_trace(4, 'salesrep_id2: #');
687: END IF;
688:
689:
690: ----g_sales_credit_tab(i). := l_source_sales_credit_rec.resource_group_id;

Line 698: OKC_UTIL.print_trace(4, 'sales_credit_type_id1: '|| l_source_sales_credit_rec.sales_credit_type_id);

694: g_sales_credit_tab(i).sales_credit_type_id2 := '#';
695: -----g_sales_credit. := l_source_sales_credit_rec.attribute_category_code
696: --new column needed in OKC
697: IF (l_debug = 'Y') THEN
698: OKC_UTIL.print_trace(4, 'sales_credit_type_id1: '|| l_source_sales_credit_rec.sales_credit_type_id);
699: OKC_UTIL.print_trace(4, 'sales_credit_type_id2: #');
700: END IF;
701:
702: g_sales_credit_tab(i).object_version_number := l_source_sales_credit_rec.object_version_number;

Line 699: OKC_UTIL.print_trace(4, 'sales_credit_type_id2: #');

695: -----g_sales_credit. := l_source_sales_credit_rec.attribute_category_code
696: --new column needed in OKC
697: IF (l_debug = 'Y') THEN
698: OKC_UTIL.print_trace(4, 'sales_credit_type_id1: '|| l_source_sales_credit_rec.sales_credit_type_id);
699: OKC_UTIL.print_trace(4, 'sales_credit_type_id2: #');
700: END IF;
701:
702: g_sales_credit_tab(i).object_version_number := l_source_sales_credit_rec.object_version_number;
703: IF (l_debug = 'Y') THEN

Line 704: OKC_UTIL.print_trace(4, 'object_version_number: '|| l_source_sales_credit_rec.object_version_number);

700: END IF;
701:
702: g_sales_credit_tab(i).object_version_number := l_source_sales_credit_rec.object_version_number;
703: IF (l_debug = 'Y') THEN
704: OKC_UTIL.print_trace(4, 'object_version_number: '|| l_source_sales_credit_rec.object_version_number);
705: END IF;
706:
707: END LOOP;
708: --IF c_source_sales_credit_rec%ROWCOUNT > 0 THEN

Line 716: -- OKC_UTIL.print_trace(4, 'END --> get_sales_credit_tab: returned error- ');

712:
713:
714:
715: --IF l_no_data_found THEN
716: -- OKC_UTIL.print_trace(4, 'END --> get_sales_credit_tab: returned error- ');
717: -- RAISE OKC_API.G_EXCEPTION_ERROR;
718: --ELSE
719: IF (l_debug = 'Y') THEN
720: OKC_UTIL.print_trace(4, 'Output: PL/SQL global table- g_sale_credits_tab');

Line 720: OKC_UTIL.print_trace(4, 'Output: PL/SQL global table- g_sale_credits_tab');

716: -- OKC_UTIL.print_trace(4, 'END --> get_sales_credit_tab: returned error- ');
717: -- RAISE OKC_API.G_EXCEPTION_ERROR;
718: --ELSE
719: IF (l_debug = 'Y') THEN
720: OKC_UTIL.print_trace(4, 'Output: PL/SQL global table- g_sale_credits_tab');
721: OKC_UTIL.print_trace(4, 'END --> get_sales_credit_tab- ');
722: END IF;
723: --END IF;
724:

Line 721: OKC_UTIL.print_trace(4, 'END --> get_sales_credit_tab- ');

717: -- RAISE OKC_API.G_EXCEPTION_ERROR;
718: --ELSE
719: IF (l_debug = 'Y') THEN
720: OKC_UTIL.print_trace(4, 'Output: PL/SQL global table- g_sale_credits_tab');
721: OKC_UTIL.print_trace(4, 'END --> get_sales_credit_tab- ');
722: END IF;
723: --END IF;
724:
725: EXCEPTION

Line 728: OKC_UTIL.print_trace(4,SQLERRM);

724:
725: EXCEPTION
726: WHEN OTHERS THEN
727: IF (l_debug = 'Y') THEN
728: OKC_UTIL.print_trace(4,SQLERRM);
729: END IF;
730: IF c_source_sales_credit_rec%ISOPEN THEN
731: CLOSE c_source_sales_credit_rec;
732: END IF;

Line 887: okc_util.print_trace(1,'---------------------------------');

883:
884: BEGIN
885:
886: IF (l_debug = 'Y') THEN
887: okc_util.print_trace(1,'---------------------------------');
888: okc_util.print_trace(1,'>> start : Get sales credit ');
889: okc_util.print_trace(1,'---------------------------------');
890: END IF;
891:

Line 888: okc_util.print_trace(1,'>> start : Get sales credit ');

884: BEGIN
885:
886: IF (l_debug = 'Y') THEN
887: okc_util.print_trace(1,'---------------------------------');
888: okc_util.print_trace(1,'>> start : Get sales credit ');
889: okc_util.print_trace(1,'---------------------------------');
890: END IF;
891:
892: --

Line 889: okc_util.print_trace(1,'---------------------------------');

885:
886: IF (l_debug = 'Y') THEN
887: okc_util.print_trace(1,'---------------------------------');
888: okc_util.print_trace(1,'>> start : Get sales credit ');
889: okc_util.print_trace(1,'---------------------------------');
890: END IF;
891:
892: --
893: -- housekeeping

Line 926: okc_util.print_trace(1,'step 1-1 operation code = '||sales_credit_rec.operation_code);

922:
923: IF sales_credit_rec.operation_code = g_aso_op_code_create THEN
924:
925: IF (l_debug = 'Y') THEN
926: okc_util.print_trace(1,'step 1-1 operation code = '||sales_credit_rec.operation_code);
927: END IF;
928:
929: -- Populate l_sales_credit_rec with infomation from sales_credit_rec;
930:

Line 957: okc_util.print_trace(1,'step 1-2 operation code = '||sales_credit_rec.operation_code);

953:
954:
955: IF sales_credit_rec.operation_code = g_aso_op_code_update THEN
956: IF (l_debug = 'Y') THEN
957: okc_util.print_trace(1,'step 1-2 operation code = '||sales_credit_rec.operation_code);
958: END IF;
959: IF NVL(l_prec_sls_crdt_id,0) <> sales_credit_rec.id THEN
960:
961: --

Line 970: okc_util.print_trace(1,'step 1-3 related sales credit adjustment is already planned to be updated');

966: FOR i IN l_sales_credit_tab.first..l_sales_credit_tab.last LOOP
967: IF l_sales_credit_tab(i).sales_credit_id = sales_credit_rec.sales_credit_id THEN
968:
969: IF (l_debug = 'Y') THEN
970: okc_util.print_trace(1,'step 1-3 related sales credit adjustment is already planned to be updated');
971: END IF;
972:
973: l_sales_credit_insert := OKC_API.G_FALSE;
974: exit;

Line 993: okc_util.print_trace(1,'step 1-4 checking ctrct sls crdt with multiple qte sls crdt');

989: FOR i IN l_sales_credit_tab.first..l_sales_credit_tab.last LOOP
990: IF l_sales_credit_tab(i).sales_credit_id = sales_credit_rec.sales_credit_id THEN
991: l_sales_credit_insert := OKC_API.G_FALSE;
992: IF (l_debug = 'Y') THEN
993: okc_util.print_trace(1,'step 1-4 checking ctrct sls crdt with multiple qte sls crdt');
994: END IF;
995: exit;
996: END IF;
997: END LOOP;

Line 1060: okc_util.print_trace(1,'INDEX VALUE x = '||x);

1056:
1057: l_sales_credit_tab(x) := l_sales_credit_rec;
1058:
1059: IF (l_debug = 'Y') THEN
1060: okc_util.print_trace(1,'INDEX VALUE x = '||x);
1061: okc_util.print_trace(1,'=========================================================');
1062: okc_util.print_trace(1,' ');
1063: END IF;
1064:

Line 1061: okc_util.print_trace(1,'=========================================================');

1057: l_sales_credit_tab(x) := l_sales_credit_rec;
1058:
1059: IF (l_debug = 'Y') THEN
1060: okc_util.print_trace(1,'INDEX VALUE x = '||x);
1061: okc_util.print_trace(1,'=========================================================');
1062: okc_util.print_trace(1,' ');
1063: END IF;
1064:
1065: IF (l_debug = 'Y') THEN

Line 1062: okc_util.print_trace(1,' ');

1058:
1059: IF (l_debug = 'Y') THEN
1060: okc_util.print_trace(1,'INDEX VALUE x = '||x);
1061: okc_util.print_trace(1,'=========================================================');
1062: okc_util.print_trace(1,' ');
1063: END IF;
1064:
1065: IF (l_debug = 'Y') THEN
1066: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(x).operation_code);

Line 1066: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(x).operation_code);

1062: okc_util.print_trace(1,' ');
1063: END IF;
1064:
1065: IF (l_debug = 'Y') THEN
1066: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(x).operation_code);
1067: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(x).quote_header_id);
1068: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(x).quote_line_id);
1069: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(x).sales_credit_id);
1070: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(x).percent);

Line 1067: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(x).quote_header_id);

1063: END IF;
1064:
1065: IF (l_debug = 'Y') THEN
1066: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(x).operation_code);
1067: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(x).quote_header_id);
1068: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(x).quote_line_id);
1069: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(x).sales_credit_id);
1070: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(x).percent);
1071: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(x).resource_id);

Line 1068: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(x).quote_line_id);

1064:
1065: IF (l_debug = 'Y') THEN
1066: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(x).operation_code);
1067: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(x).quote_header_id);
1068: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(x).quote_line_id);
1069: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(x).sales_credit_id);
1070: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(x).percent);
1071: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(x).resource_id);
1072: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(x).sales_credit_type_id);

Line 1069: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(x).sales_credit_id);

1065: IF (l_debug = 'Y') THEN
1066: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(x).operation_code);
1067: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(x).quote_header_id);
1068: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(x).quote_line_id);
1069: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(x).sales_credit_id);
1070: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(x).percent);
1071: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(x).resource_id);
1072: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(x).sales_credit_type_id);
1073: END IF;

Line 1070: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(x).percent);

1066: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(x).operation_code);
1067: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(x).quote_header_id);
1068: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(x).quote_line_id);
1069: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(x).sales_credit_id);
1070: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(x).percent);
1071: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(x).resource_id);
1072: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(x).sales_credit_type_id);
1073: END IF;
1074: -- okc_util.print_trace(1,'obj ver # = '||l_sales_credit_tab(x).object_version_number);

Line 1071: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(x).resource_id);

1067: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(x).quote_header_id);
1068: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(x).quote_line_id);
1069: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(x).sales_credit_id);
1070: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(x).percent);
1071: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(x).resource_id);
1072: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(x).sales_credit_type_id);
1073: END IF;
1074: -- okc_util.print_trace(1,'obj ver # = '||l_sales_credit_tab(x).object_version_number);
1075: IF (l_debug = 'Y') THEN

Line 1072: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(x).sales_credit_type_id);

1068: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(x).quote_line_id);
1069: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(x).sales_credit_id);
1070: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(x).percent);
1071: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(x).resource_id);
1072: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(x).sales_credit_type_id);
1073: END IF;
1074: -- okc_util.print_trace(1,'obj ver # = '||l_sales_credit_tab(x).object_version_number);
1075: IF (l_debug = 'Y') THEN
1076: okc_util.print_trace(1,'last updt date = '||l_sales_credit_tab(x).last_update_date);

Line 1074: -- okc_util.print_trace(1,'obj ver # = '||l_sales_credit_tab(x).object_version_number);

1070: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(x).percent);
1071: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(x).resource_id);
1072: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(x).sales_credit_type_id);
1073: END IF;
1074: -- okc_util.print_trace(1,'obj ver # = '||l_sales_credit_tab(x).object_version_number);
1075: IF (l_debug = 'Y') THEN
1076: okc_util.print_trace(1,'last updt date = '||l_sales_credit_tab(x).last_update_date);
1077: END IF;
1078:

Line 1076: okc_util.print_trace(1,'last updt date = '||l_sales_credit_tab(x).last_update_date);

1072: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(x).sales_credit_type_id);
1073: END IF;
1074: -- okc_util.print_trace(1,'obj ver # = '||l_sales_credit_tab(x).object_version_number);
1075: IF (l_debug = 'Y') THEN
1076: okc_util.print_trace(1,'last updt date = '||l_sales_credit_tab(x).last_update_date);
1077: END IF;
1078:
1079:
1080: IF (l_debug = 'Y') THEN

Line 1081: okc_util.print_trace(1,' ');

1077: END IF;
1078:
1079:
1080: IF (l_debug = 'Y') THEN
1081: okc_util.print_trace(1,' ');
1082: END IF;
1083:
1084: x := x + 1;
1085: --

Line 1167: okc_util.print_trace(1,' ');

1163: END LOOP;
1164:
1165:
1166: IF (l_debug = 'Y') THEN
1167: okc_util.print_trace(1,' ');
1168: okc_util.print_trace(1,'-----------------------------------------');
1169: okc_util.print_trace(1,' values contained in the l_sales_credit_tab ');
1170: okc_util.print_trace(1,'-----------------------------------------');
1171: okc_util.print_trace(1,' ');

Line 1168: okc_util.print_trace(1,'-----------------------------------------');

1164:
1165:
1166: IF (l_debug = 'Y') THEN
1167: okc_util.print_trace(1,' ');
1168: okc_util.print_trace(1,'-----------------------------------------');
1169: okc_util.print_trace(1,' values contained in the l_sales_credit_tab ');
1170: okc_util.print_trace(1,'-----------------------------------------');
1171: okc_util.print_trace(1,' ');
1172: END IF;

Line 1169: okc_util.print_trace(1,' values contained in the l_sales_credit_tab ');

1165:
1166: IF (l_debug = 'Y') THEN
1167: okc_util.print_trace(1,' ');
1168: okc_util.print_trace(1,'-----------------------------------------');
1169: okc_util.print_trace(1,' values contained in the l_sales_credit_tab ');
1170: okc_util.print_trace(1,'-----------------------------------------');
1171: okc_util.print_trace(1,' ');
1172: END IF;
1173:

Line 1170: okc_util.print_trace(1,'-----------------------------------------');

1166: IF (l_debug = 'Y') THEN
1167: okc_util.print_trace(1,' ');
1168: okc_util.print_trace(1,'-----------------------------------------');
1169: okc_util.print_trace(1,' values contained in the l_sales_credit_tab ');
1170: okc_util.print_trace(1,'-----------------------------------------');
1171: okc_util.print_trace(1,' ');
1172: END IF;
1173:
1174: IF l_sales_credit_tab.first IS NOT NULL THEN

Line 1171: okc_util.print_trace(1,' ');

1167: okc_util.print_trace(1,' ');
1168: okc_util.print_trace(1,'-----------------------------------------');
1169: okc_util.print_trace(1,' values contained in the l_sales_credit_tab ');
1170: okc_util.print_trace(1,'-----------------------------------------');
1171: okc_util.print_trace(1,' ');
1172: END IF;
1173:
1174: IF l_sales_credit_tab.first IS NOT NULL THEN
1175: FOR i IN l_sales_credit_tab.first..l_sales_credit_tab.last LOOP

Line 1179: okc_util.print_trace(1,' ');

1175: FOR i IN l_sales_credit_tab.first..l_sales_credit_tab.last LOOP
1176: IF l_sales_credit_tab.EXISTS(i) THEN
1177:
1178: IF (l_debug = 'Y') THEN
1179: okc_util.print_trace(1,' ');
1180: END IF;
1181:
1182: IF (l_debug = 'Y') THEN
1183: okc_util.print_trace(1,'index value = '||i);

Line 1183: okc_util.print_trace(1,'index value = '||i);

1179: okc_util.print_trace(1,' ');
1180: END IF;
1181:
1182: IF (l_debug = 'Y') THEN
1183: okc_util.print_trace(1,'index value = '||i);
1184: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(i).operation_code);
1185: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(i).quote_header_id);
1186: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(i).quote_line_id);
1187: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(i).sales_credit_id);

Line 1184: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(i).operation_code);

1180: END IF;
1181:
1182: IF (l_debug = 'Y') THEN
1183: okc_util.print_trace(1,'index value = '||i);
1184: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(i).operation_code);
1185: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(i).quote_header_id);
1186: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(i).quote_line_id);
1187: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(i).sales_credit_id);
1188: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(i).percent);

Line 1185: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(i).quote_header_id);

1181:
1182: IF (l_debug = 'Y') THEN
1183: okc_util.print_trace(1,'index value = '||i);
1184: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(i).operation_code);
1185: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(i).quote_header_id);
1186: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(i).quote_line_id);
1187: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(i).sales_credit_id);
1188: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(i).percent);
1189: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(i).resource_id);

Line 1186: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(i).quote_line_id);

1182: IF (l_debug = 'Y') THEN
1183: okc_util.print_trace(1,'index value = '||i);
1184: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(i).operation_code);
1185: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(i).quote_header_id);
1186: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(i).quote_line_id);
1187: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(i).sales_credit_id);
1188: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(i).percent);
1189: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(i).resource_id);
1190: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(i).sales_credit_type_id);

Line 1187: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(i).sales_credit_id);

1183: okc_util.print_trace(1,'index value = '||i);
1184: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(i).operation_code);
1185: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(i).quote_header_id);
1186: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(i).quote_line_id);
1187: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(i).sales_credit_id);
1188: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(i).percent);
1189: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(i).resource_id);
1190: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(i).sales_credit_type_id);
1191: END IF;

Line 1188: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(i).percent);

1184: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(i).operation_code);
1185: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(i).quote_header_id);
1186: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(i).quote_line_id);
1187: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(i).sales_credit_id);
1188: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(i).percent);
1189: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(i).resource_id);
1190: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(i).sales_credit_type_id);
1191: END IF;
1192: -- okc_util.print_trace(1,'obj ver # = '||l_sales_credit_tab(i).object_version_number);

Line 1189: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(i).resource_id);

1185: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(i).quote_header_id);
1186: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(i).quote_line_id);
1187: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(i).sales_credit_id);
1188: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(i).percent);
1189: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(i).resource_id);
1190: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(i).sales_credit_type_id);
1191: END IF;
1192: -- okc_util.print_trace(1,'obj ver # = '||l_sales_credit_tab(i).object_version_number);
1193: IF (l_debug = 'Y') THEN

Line 1190: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(i).sales_credit_type_id);

1186: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(i).quote_line_id);
1187: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(i).sales_credit_id);
1188: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(i).percent);
1189: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(i).resource_id);
1190: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(i).sales_credit_type_id);
1191: END IF;
1192: -- okc_util.print_trace(1,'obj ver # = '||l_sales_credit_tab(i).object_version_number);
1193: IF (l_debug = 'Y') THEN
1194: okc_util.print_trace(1,'last updt date = '||l_sales_credit_tab(i).last_update_date);

Line 1192: -- okc_util.print_trace(1,'obj ver # = '||l_sales_credit_tab(i).object_version_number);

1188: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(i).percent);
1189: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(i).resource_id);
1190: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(i).sales_credit_type_id);
1191: END IF;
1192: -- okc_util.print_trace(1,'obj ver # = '||l_sales_credit_tab(i).object_version_number);
1193: IF (l_debug = 'Y') THEN
1194: okc_util.print_trace(1,'last updt date = '||l_sales_credit_tab(i).last_update_date);
1195: END IF;
1196:

Line 1194: okc_util.print_trace(1,'last updt date = '||l_sales_credit_tab(i).last_update_date);

1190: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(i).sales_credit_type_id);
1191: END IF;
1192: -- okc_util.print_trace(1,'obj ver # = '||l_sales_credit_tab(i).object_version_number);
1193: IF (l_debug = 'Y') THEN
1194: okc_util.print_trace(1,'last updt date = '||l_sales_credit_tab(i).last_update_date);
1195: END IF;
1196:
1197: IF (l_debug = 'Y') THEN
1198: okc_util.print_trace(1,' ');

Line 1198: okc_util.print_trace(1,' ');

1194: okc_util.print_trace(1,'last updt date = '||l_sales_credit_tab(i).last_update_date);
1195: END IF;
1196:
1197: IF (l_debug = 'Y') THEN
1198: okc_util.print_trace(1,' ');
1199: END IF;
1200: END IF;
1201: END LOOP;
1202: END IF;

Line 1220: okc_util.print_trace(1,' ');

1216: END IF;
1217:
1218:
1219: IF (l_debug = 'Y') THEN
1220: okc_util.print_trace(1,' ');
1221: okc_util.print_trace(1,'====================================================');
1222: okc_util.print_trace(1,' FINAL VALUES CONTAINED IN THE X_SALES_CREDIT_TAB ');
1223: okc_util.print_trace(1,'====================================================');
1224: okc_util.print_trace(1,' ');

Line 1221: okc_util.print_trace(1,'====================================================');

1217:
1218:
1219: IF (l_debug = 'Y') THEN
1220: okc_util.print_trace(1,' ');
1221: okc_util.print_trace(1,'====================================================');
1222: okc_util.print_trace(1,' FINAL VALUES CONTAINED IN THE X_SALES_CREDIT_TAB ');
1223: okc_util.print_trace(1,'====================================================');
1224: okc_util.print_trace(1,' ');
1225: END IF;

Line 1222: okc_util.print_trace(1,' FINAL VALUES CONTAINED IN THE X_SALES_CREDIT_TAB ');

1218:
1219: IF (l_debug = 'Y') THEN
1220: okc_util.print_trace(1,' ');
1221: okc_util.print_trace(1,'====================================================');
1222: okc_util.print_trace(1,' FINAL VALUES CONTAINED IN THE X_SALES_CREDIT_TAB ');
1223: okc_util.print_trace(1,'====================================================');
1224: okc_util.print_trace(1,' ');
1225: END IF;
1226:

Line 1223: okc_util.print_trace(1,'====================================================');

1219: IF (l_debug = 'Y') THEN
1220: okc_util.print_trace(1,' ');
1221: okc_util.print_trace(1,'====================================================');
1222: okc_util.print_trace(1,' FINAL VALUES CONTAINED IN THE X_SALES_CREDIT_TAB ');
1223: okc_util.print_trace(1,'====================================================');
1224: okc_util.print_trace(1,' ');
1225: END IF;
1226:
1227: IF x_sales_credit_tab.first IS NOT NULL THEN

Line 1224: okc_util.print_trace(1,' ');

1220: okc_util.print_trace(1,' ');
1221: okc_util.print_trace(1,'====================================================');
1222: okc_util.print_trace(1,' FINAL VALUES CONTAINED IN THE X_SALES_CREDIT_TAB ');
1223: okc_util.print_trace(1,'====================================================');
1224: okc_util.print_trace(1,' ');
1225: END IF;
1226:
1227: IF x_sales_credit_tab.first IS NOT NULL THEN
1228: FOR i IN x_sales_credit_tab.first..x_sales_credit_tab.last LOOP

Line 1232: okc_util.print_trace(1,' ');

1228: FOR i IN x_sales_credit_tab.first..x_sales_credit_tab.last LOOP
1229: IF x_sales_credit_tab.EXISTS(i) THEN
1230:
1231: IF (l_debug = 'Y') THEN
1232: okc_util.print_trace(1,' ');
1233: okc_util.print_trace(1,'index value = '||i);
1234: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(i).operation_code);
1235: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(i).quote_header_id);
1236: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(i).quote_line_id);

Line 1233: okc_util.print_trace(1,'index value = '||i);

1229: IF x_sales_credit_tab.EXISTS(i) THEN
1230:
1231: IF (l_debug = 'Y') THEN
1232: okc_util.print_trace(1,' ');
1233: okc_util.print_trace(1,'index value = '||i);
1234: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(i).operation_code);
1235: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(i).quote_header_id);
1236: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(i).quote_line_id);
1237: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(i).sales_credit_id);

Line 1234: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(i).operation_code);

1230:
1231: IF (l_debug = 'Y') THEN
1232: okc_util.print_trace(1,' ');
1233: okc_util.print_trace(1,'index value = '||i);
1234: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(i).operation_code);
1235: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(i).quote_header_id);
1236: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(i).quote_line_id);
1237: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(i).sales_credit_id);
1238: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(i).percent);

Line 1235: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(i).quote_header_id);

1231: IF (l_debug = 'Y') THEN
1232: okc_util.print_trace(1,' ');
1233: okc_util.print_trace(1,'index value = '||i);
1234: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(i).operation_code);
1235: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(i).quote_header_id);
1236: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(i).quote_line_id);
1237: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(i).sales_credit_id);
1238: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(i).percent);
1239: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(i).resource_id);

Line 1236: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(i).quote_line_id);

1232: okc_util.print_trace(1,' ');
1233: okc_util.print_trace(1,'index value = '||i);
1234: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(i).operation_code);
1235: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(i).quote_header_id);
1236: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(i).quote_line_id);
1237: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(i).sales_credit_id);
1238: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(i).percent);
1239: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(i).resource_id);
1240: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(i).sales_credit_type_id);

Line 1237: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(i).sales_credit_id);

1233: okc_util.print_trace(1,'index value = '||i);
1234: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(i).operation_code);
1235: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(i).quote_header_id);
1236: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(i).quote_line_id);
1237: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(i).sales_credit_id);
1238: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(i).percent);
1239: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(i).resource_id);
1240: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(i).sales_credit_type_id);
1241: END IF;

Line 1238: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(i).percent);

1234: okc_util.print_trace(1,'operation code = '||l_sales_credit_tab(i).operation_code);
1235: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(i).quote_header_id);
1236: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(i).quote_line_id);
1237: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(i).sales_credit_id);
1238: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(i).percent);
1239: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(i).resource_id);
1240: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(i).sales_credit_type_id);
1241: END IF;
1242: -- okc_util.print_trace(1,'obj ver # = '||l_sales_credit_tab(i).object_version_number);

Line 1239: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(i).resource_id);

1235: okc_util.print_trace(1,'qte hdr id = '||l_sales_credit_tab(i).quote_header_id);
1236: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(i).quote_line_id);
1237: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(i).sales_credit_id);
1238: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(i).percent);
1239: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(i).resource_id);
1240: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(i).sales_credit_type_id);
1241: END IF;
1242: -- okc_util.print_trace(1,'obj ver # = '||l_sales_credit_tab(i).object_version_number);
1243: IF (l_debug = 'Y') THEN

Line 1240: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(i).sales_credit_type_id);

1236: okc_util.print_trace(1,'qte line id = '||l_sales_credit_tab(i).quote_line_id);
1237: okc_util.print_trace(1,'sales credit id = '||l_sales_credit_tab(i).sales_credit_id);
1238: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(i).percent);
1239: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(i).resource_id);
1240: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(i).sales_credit_type_id);
1241: END IF;
1242: -- okc_util.print_trace(1,'obj ver # = '||l_sales_credit_tab(i).object_version_number);
1243: IF (l_debug = 'Y') THEN
1244: okc_util.print_trace(1,'last updt date = '||l_sales_credit_tab(i).last_update_date);

Line 1242: -- okc_util.print_trace(1,'obj ver # = '||l_sales_credit_tab(i).object_version_number);

1238: okc_util.print_trace(1,'percent = '||l_sales_credit_tab(i).percent);
1239: okc_util.print_trace(1,'resource(ctc)id = '||l_sales_credit_tab(i).resource_id);
1240: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(i).sales_credit_type_id);
1241: END IF;
1242: -- okc_util.print_trace(1,'obj ver # = '||l_sales_credit_tab(i).object_version_number);
1243: IF (l_debug = 'Y') THEN
1244: okc_util.print_trace(1,'last updt date = '||l_sales_credit_tab(i).last_update_date);
1245: okc_util.print_trace(1,' ');
1246: END IF;

Line 1244: okc_util.print_trace(1,'last updt date = '||l_sales_credit_tab(i).last_update_date);

1240: okc_util.print_trace(1,'sls crdt typ id = '||l_sales_credit_tab(i).sales_credit_type_id);
1241: END IF;
1242: -- okc_util.print_trace(1,'obj ver # = '||l_sales_credit_tab(i).object_version_number);
1243: IF (l_debug = 'Y') THEN
1244: okc_util.print_trace(1,'last updt date = '||l_sales_credit_tab(i).last_update_date);
1245: okc_util.print_trace(1,' ');
1246: END IF;
1247:
1248: END IF;

Line 1245: okc_util.print_trace(1,' ');

1241: END IF;
1242: -- okc_util.print_trace(1,'obj ver # = '||l_sales_credit_tab(i).object_version_number);
1243: IF (l_debug = 'Y') THEN
1244: okc_util.print_trace(1,'last updt date = '||l_sales_credit_tab(i).last_update_date);
1245: okc_util.print_trace(1,' ');
1246: END IF;
1247:
1248: END IF;
1249: END LOOP;

Line 1256: okc_util.print_trace(1,' ');

1252: -- x_k_sales_credit_tab := l_k_sales_credit_tab;
1253: -- x_sales_credit_tab := l_sales_credit_tab;
1254:
1255: IF (l_debug = 'Y') THEN
1256: okc_util.print_trace(1,' ');
1257: okc_util.print_trace(1,'====================================================');
1258: okc_util.print_trace(1,' FINAL VALUES CONTAINED IN THE X_K_SALES_CREDIT_TAB ');
1259: okc_util.print_trace(1,'====================================================');
1260: okc_util.print_trace(1,' ');

Line 1257: okc_util.print_trace(1,'====================================================');

1253: -- x_sales_credit_tab := l_sales_credit_tab;
1254:
1255: IF (l_debug = 'Y') THEN
1256: okc_util.print_trace(1,' ');
1257: okc_util.print_trace(1,'====================================================');
1258: okc_util.print_trace(1,' FINAL VALUES CONTAINED IN THE X_K_SALES_CREDIT_TAB ');
1259: okc_util.print_trace(1,'====================================================');
1260: okc_util.print_trace(1,' ');
1261: END IF;

Line 1258: okc_util.print_trace(1,' FINAL VALUES CONTAINED IN THE X_K_SALES_CREDIT_TAB ');

1254:
1255: IF (l_debug = 'Y') THEN
1256: okc_util.print_trace(1,' ');
1257: okc_util.print_trace(1,'====================================================');
1258: okc_util.print_trace(1,' FINAL VALUES CONTAINED IN THE X_K_SALES_CREDIT_TAB ');
1259: okc_util.print_trace(1,'====================================================');
1260: okc_util.print_trace(1,' ');
1261: END IF;
1262:

Line 1259: okc_util.print_trace(1,'====================================================');

1255: IF (l_debug = 'Y') THEN
1256: okc_util.print_trace(1,' ');
1257: okc_util.print_trace(1,'====================================================');
1258: okc_util.print_trace(1,' FINAL VALUES CONTAINED IN THE X_K_SALES_CREDIT_TAB ');
1259: okc_util.print_trace(1,'====================================================');
1260: okc_util.print_trace(1,' ');
1261: END IF;
1262:
1263: IF x_k_sales_credit_tab.first IS NOT NULL THEN

Line 1260: okc_util.print_trace(1,' ');

1256: okc_util.print_trace(1,' ');
1257: okc_util.print_trace(1,'====================================================');
1258: okc_util.print_trace(1,' FINAL VALUES CONTAINED IN THE X_K_SALES_CREDIT_TAB ');
1259: okc_util.print_trace(1,'====================================================');
1260: okc_util.print_trace(1,' ');
1261: END IF;
1262:
1263: IF x_k_sales_credit_tab.first IS NOT NULL THEN
1264: FOR i IN x_k_sales_credit_tab.first..x_k_sales_credit_tab.last LOOP

Line 1268: okc_util.print_trace(1,'INDEX VALUE = '||i);

1264: FOR i IN x_k_sales_credit_tab.first..x_k_sales_credit_tab.last LOOP
1265: IF x_k_sales_credit_tab.EXISTS(i) THEN
1266:
1267: IF (l_debug = 'Y') THEN
1268: okc_util.print_trace(1,'INDEX VALUE = '||i);
1269: okc_util.print_trace(1,'okc_k_sales_credits - id = '||x_k_sales_credit_tab(i).id);
1270: okc_util.print_trace(1,'Level = '||x_k_sales_credit_tab(i).level);
1271: END IF;
1272:

Line 1269: okc_util.print_trace(1,'okc_k_sales_credits - id = '||x_k_sales_credit_tab(i).id);

1265: IF x_k_sales_credit_tab.EXISTS(i) THEN
1266:
1267: IF (l_debug = 'Y') THEN
1268: okc_util.print_trace(1,'INDEX VALUE = '||i);
1269: okc_util.print_trace(1,'okc_k_sales_credits - id = '||x_k_sales_credit_tab(i).id);
1270: okc_util.print_trace(1,'Level = '||x_k_sales_credit_tab(i).level);
1271: END IF;
1272:
1273: END IF;

Line 1270: okc_util.print_trace(1,'Level = '||x_k_sales_credit_tab(i).level);

1266:
1267: IF (l_debug = 'Y') THEN
1268: okc_util.print_trace(1,'INDEX VALUE = '||i);
1269: okc_util.print_trace(1,'okc_k_sales_credits - id = '||x_k_sales_credit_tab(i).id);
1270: okc_util.print_trace(1,'Level = '||x_k_sales_credit_tab(i).level);
1271: END IF;
1272:
1273: END IF;
1274:

Line 1279: okc_util.print_trace(1,'------------------------------');

1275: END LOOP;
1276: END IF;
1277:
1278: IF (l_debug = 'Y') THEN
1279: okc_util.print_trace(1,'------------------------------');
1280: okc_util.print_trace(1,'>>END : Get sales credits ');
1281: okc_util.print_trace(1,'------------------------------');
1282: END IF;
1283:

Line 1280: okc_util.print_trace(1,'>>END : Get sales credits ');

1276: END IF;
1277:
1278: IF (l_debug = 'Y') THEN
1279: okc_util.print_trace(1,'------------------------------');
1280: okc_util.print_trace(1,'>>END : Get sales credits ');
1281: okc_util.print_trace(1,'------------------------------');
1282: END IF;
1283:
1284: EXCEPTION

Line 1281: okc_util.print_trace(1,'------------------------------');

1277:
1278: IF (l_debug = 'Y') THEN
1279: okc_util.print_trace(1,'------------------------------');
1280: okc_util.print_trace(1,'>>END : Get sales credits ');
1281: okc_util.print_trace(1,'------------------------------');
1282: END IF;
1283:
1284: EXCEPTION
1285: WHEN OTHERS THEN

Line 1287: okc_util.print_trace(1,'inside get sales credit : others exception');

1283:
1284: EXCEPTION
1285: WHEN OTHERS THEN
1286: IF (l_debug = 'Y') THEN
1287: okc_util.print_trace(1,'inside get sales credit : others exception');
1288: END IF;
1289:
1290: IF c_k_sales_credit%ISOPEN THEN
1291: CLOSE c_k_sales_credit;

Line 1360: okc_util.print_trace(1,'=============================================');

1356: --
1357: -- Get the sales credit information into the x_hd_sales_credit_tab variable
1358: --
1359: IF (l_debug = 'Y') THEN
1360: okc_util.print_trace(1,'=============================================');
1361: okc_util.print_trace(1,'START : GET SALES CREDITS AT HEADER LEVEL ');
1362: okc_util.print_trace(1,'=============================================');
1363: END IF;
1364:

Line 1361: okc_util.print_trace(1,'START : GET SALES CREDITS AT HEADER LEVEL ');

1357: -- Get the sales credit information into the x_hd_sales_credit_tab variable
1358: --
1359: IF (l_debug = 'Y') THEN
1360: okc_util.print_trace(1,'=============================================');
1361: okc_util.print_trace(1,'START : GET SALES CREDITS AT HEADER LEVEL ');
1362: okc_util.print_trace(1,'=============================================');
1363: END IF;
1364:
1365: get_sales_credit(p_chr_id => p_chr_id,

Line 1362: okc_util.print_trace(1,'=============================================');

1358: --
1359: IF (l_debug = 'Y') THEN
1360: okc_util.print_trace(1,'=============================================');
1361: okc_util.print_trace(1,'START : GET SALES CREDITS AT HEADER LEVEL ');
1362: okc_util.print_trace(1,'=============================================');
1363: END IF;
1364:
1365: get_sales_credit(p_chr_id => p_chr_id,
1366: p_cle_id => NULL,

Line 1385: okc_util.print_trace(1,'===========================================');

1381: x_k_sales_credit_tab => l_k_sales_credit_tab,
1382: x_sales_credit_tab => x_hd_sales_credit_tab );
1383:
1384: IF (l_debug = 'Y') THEN
1385: okc_util.print_trace(1,'===========================================');
1386: okc_util.print_trace(1,' END : GET SALES CREDITS AT HEADER LEVEL ');
1387: okc_util.print_trace(1,'===========================================');
1388: END IF;
1389:

Line 1386: okc_util.print_trace(1,' END : GET SALES CREDITS AT HEADER LEVEL ');

1382: x_sales_credit_tab => x_hd_sales_credit_tab );
1383:
1384: IF (l_debug = 'Y') THEN
1385: okc_util.print_trace(1,'===========================================');
1386: okc_util.print_trace(1,' END : GET SALES CREDITS AT HEADER LEVEL ');
1387: okc_util.print_trace(1,'===========================================');
1388: END IF;
1389:
1390:

Line 1387: okc_util.print_trace(1,'===========================================');

1383:
1384: IF (l_debug = 'Y') THEN
1385: okc_util.print_trace(1,'===========================================');
1386: okc_util.print_trace(1,' END : GET SALES CREDITS AT HEADER LEVEL ');
1387: okc_util.print_trace(1,'===========================================');
1388: END IF;
1389:
1390:
1391: --------------------------------------------------------------

Line 1400: okc_util.print_trace(1,'===========================================');

1396: -- Select sales credit information into the x_ln_sales_credit_tab variable
1397: --
1398:
1399: IF (l_debug = 'Y') THEN
1400: okc_util.print_trace(1,'===========================================');
1401: okc_util.print_trace(1,'START : GET SALES CREDITS AT LINE LEVEL ');
1402: okc_util.print_trace(1,'===========================================');
1403: END IF;
1404:

Line 1401: okc_util.print_trace(1,'START : GET SALES CREDITS AT LINE LEVEL ');

1397: --
1398:
1399: IF (l_debug = 'Y') THEN
1400: okc_util.print_trace(1,'===========================================');
1401: okc_util.print_trace(1,'START : GET SALES CREDITS AT LINE LEVEL ');
1402: okc_util.print_trace(1,'===========================================');
1403: END IF;
1404:
1405: IF l_line_tab.FIRST IS NOT NULL THEN

Line 1402: okc_util.print_trace(1,'===========================================');

1398:
1399: IF (l_debug = 'Y') THEN
1400: okc_util.print_trace(1,'===========================================');
1401: okc_util.print_trace(1,'START : GET SALES CREDITS AT LINE LEVEL ');
1402: okc_util.print_trace(1,'===========================================');
1403: END IF;
1404:
1405: IF l_line_tab.FIRST IS NOT NULL THEN
1406:

Line 1427: -- okc_util.print_trace(1,'operation code '||l_line_tab(i).operation_code);

1423:
1424:
1425: IF l_line_tab(i).operation_code= g_aso_op_code_create THEN
1426:
1427: -- okc_util.print_trace(1,'operation code '||l_line_tab(i).operation_code);
1428:
1429: get_sales_credit(p_chr_id => p_chr_id,
1430: p_cle_id => l_cle_id,
1431: --

Line 1450: -- okc_util.print_trace(1,'operation code '||l_line_tab(i).operation_code);

1446: x_sales_credit_tab => x_ln_temp_sls_crdt_tab);
1447:
1448: ELSIF l_line_tab(i).operation_code= g_aso_op_code_update THEN
1449:
1450: -- okc_util.print_trace(1,'operation code '||l_line_tab(i).operation_code);
1451:
1452: get_sales_credit(p_chr_id => p_chr_id,
1453: p_cle_id => l_cle_id,
1454: --

Line 1477: -- okc_util.print_trace(1,'operation code '||l_line_tab(i).operation_code);

1473: x_sales_credit_tab => x_ln_temp_sls_crdt_tab);
1474:
1475: ELSIF l_line_tab(i).operation_code= g_aso_op_code_delete THEN
1476:
1477: -- okc_util.print_trace(1,'operation code '||l_line_tab(i).operation_code);
1478:
1479: get_sales_credit(p_chr_id => NULL,
1480: p_cle_id => NULL,
1481: --

Line 1513: okc_util.print_trace(1,'===========================================');

1509: END LOOP;
1510: END IF;
1511:
1512: IF (l_debug = 'Y') THEN
1513: okc_util.print_trace(1,'===========================================');
1514: okc_util.print_trace(1,' END : GET SALES CREDITS AT LINE LEVEL ');
1515: okc_util.print_trace(1,'===========================================');
1516: END IF;
1517:

Line 1514: okc_util.print_trace(1,' END : GET SALES CREDITS AT LINE LEVEL ');

1510: END IF;
1511:
1512: IF (l_debug = 'Y') THEN
1513: okc_util.print_trace(1,'===========================================');
1514: okc_util.print_trace(1,' END : GET SALES CREDITS AT LINE LEVEL ');
1515: okc_util.print_trace(1,'===========================================');
1516: END IF;
1517:
1518: EXCEPTION

Line 1515: okc_util.print_trace(1,'===========================================');

1511:
1512: IF (l_debug = 'Y') THEN
1513: okc_util.print_trace(1,'===========================================');
1514: okc_util.print_trace(1,' END : GET SALES CREDITS AT LINE LEVEL ');
1515: okc_util.print_trace(1,'===========================================');
1516: END IF;
1517:
1518: EXCEPTION
1519: