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_EURO_CONV_PUB dependencies on OKC_DEBUG

Line 31: okc_debug.Set_Indentation('OKC_EURO_CONV_PUB');

27: l_return_status varchar2(1) :='S';
28: BEGIN
29:
30: IF (l_debug = 'Y') THEN
31: okc_debug.Set_Indentation('OKC_EURO_CONV_PUB');
32: okc_debug.log('200: Entered set header rec', 2);
33: END IF;
34:
35: x_chrv_rec.id := p_chr_rec.id;

Line 32: okc_debug.log('200: Entered set header rec', 2);

28: BEGIN
29:
30: IF (l_debug = 'Y') THEN
31: okc_debug.Set_Indentation('OKC_EURO_CONV_PUB');
32: okc_debug.log('200: Entered set header rec', 2);
33: END IF;
34:
35: x_chrv_rec.id := p_chr_rec.id;
36: x_chrv_rec.contract_number := p_chr_rec.contract_number;

Line 148: okc_debug.log('okc_currency_api.get_rate is ' || l_return_status);

144:
145: x_return_status := l_return_status;
146:
147: IF (l_debug = 'Y') THEN
148: okc_debug.log('okc_currency_api.get_rate is ' || l_return_status);
149: END IF;
150: IF l_return_status <> 'S' THEN
151: RETURN x_chrv_tbl;
152: END IF;

Line 167: okc_debug.log('400: Exiting set_header_rec:others Exception', 2);

163: EXCEPTION
164: WHEN others THEN
165:
166: IF (l_debug = 'Y') THEN
167: okc_debug.log('400: Exiting set_header_rec:others Exception', 2);
168: okc_debug.Reset_Indentation;
169: END IF;
170: x_return_status:='U';
171:

Line 168: okc_debug.Reset_Indentation;

164: WHEN others THEN
165:
166: IF (l_debug = 'Y') THEN
167: okc_debug.log('400: Exiting set_header_rec:others Exception', 2);
168: okc_debug.Reset_Indentation;
169: END IF;
170: x_return_status:='U';
171:
172: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');

Line 197: okc_debug.Set_Indentation('OKC_EURO_CONV_PUB');

193: x_chrv_tbl OKC_CONTRACT_PUB.chrv_tbl_type;
194:
195: BEGIN
196: IF (l_debug = 'Y') THEN
197: okc_debug.Set_Indentation('OKC_EURO_CONV_PUB');
198: okc_debug.log('600: Entered Add_conversion_data', 2);
199: END IF;
200:
201:

Line 198: okc_debug.log('600: Entered Add_conversion_data', 2);

194:
195: BEGIN
196: IF (l_debug = 'Y') THEN
197: okc_debug.Set_Indentation('OKC_EURO_CONV_PUB');
198: okc_debug.log('600: Entered Add_conversion_data', 2);
199: END IF;
200:
201:
202: If

Line 208: okc_debug.log('625: No conversion data found',2);

204: p_contracts_rec.conversion_rate is null AND
205: p_contracts_rec.conversion_rate_date is null) THEN
206: p_update_all := 'Y' ;
207: IF (l_debug = 'Y') THEN
208: okc_debug.log('625: No conversion data found',2);
209: END IF;
210:
211: Elsif
212: (p_contracts_rec.conversion_type is null OR

Line 217: okc_debug.log('650: Conversion data found, VALUES:'||

213: p_contracts_rec.conversion_rate is null OR
214: p_contracts_rec.conversion_rate_date is null) THEN
215: p_update_all := 'N' ;
216: IF (l_debug = 'Y') THEN
217: okc_debug.log('650: Conversion data found, VALUES:'||
218: p_contracts_rec.conversion_rate || '/' ||
219: p_contracts_rec.conversion_rate_date || '/' ||
220: p_contracts_rec.conversion_type,2);
221: END IF;

Line 239: okc_debug.log('640: Calling update_contract_header');

235:
236: If y_return_status = 'S' Then
237:
238: IF (l_debug = 'Y') THEN
239: okc_debug.log('640: Calling update_contract_header');
240: END IF;
241:
242: OKC_CONTRACT_PUB.update_contract_header(
243: p_api_version => g_api_version,

Line 253: okc_debug.log('635: update_header returns ' || l_return_status);

249: x_chrv_tbl => x_chrv_tbl);
250:
251: x_return_status := l_return_status;
252: IF (l_debug = 'Y') THEN
253: okc_debug.log('635: update_header returns ' || l_return_status);
254: END IF;
255:
256: Else
257: If l_debug = 'Y' Then

Line 258: okc_debug.log('636:set header returns error');

254: END IF;
255:
256: Else
257: If l_debug = 'Y' Then
258: okc_debug.log('636:set header returns error');
259: End If;
260: End If;
261: Else
262: IF p_update_all = 'Y' THEN

Line 270: okc_debug.log('700: Exiting Add_Conversion_data', 2);

266: END IF;
267: End If;
268:
269: IF (l_debug = 'Y') THEN
270: okc_debug.log('700: Exiting Add_Conversion_data', 2);
271: okc_debug.Reset_Indentation;
272: END IF;
273:
274:

Line 271: okc_debug.Reset_Indentation;

267: End If;
268:
269: IF (l_debug = 'Y') THEN
270: okc_debug.log('700: Exiting Add_Conversion_data', 2);
271: okc_debug.Reset_Indentation;
272: END IF;
273:
274:
275: EXCEPTION

Line 280: okc_debug.log('800: Exiting Add_Conversion_data:others Exception', 2);

276:
277: WHEN others THEN
278:
279: IF (l_debug = 'Y') THEN
280: okc_debug.log('800: Exiting Add_Conversion_data:others Exception', 2);
281: okc_debug.Reset_Indentation;
282: END IF;
283:
284: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');

Line 281: okc_debug.Reset_Indentation;

277: WHEN others THEN
278:
279: IF (l_debug = 'Y') THEN
280: okc_debug.log('800: Exiting Add_Conversion_data:others Exception', 2);
281: okc_debug.Reset_Indentation;
282: END IF;
283:
284: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
285: fnd_message.set_token('ROUTINE',l_proc);

Line 343: okc_debug.Set_Indentation('OKC_EURO_CONV_PUB');

339: fnd_file.put_line(FND_FILE.LOG,'Trace Mode is Enabled');
340: END IF;
341:
342: IF (l_debug = 'Y') THEN
343: okc_debug.Set_Indentation('OKC_EURO_CONV_PUB');
344: okc_debug.log('900: Entered CONVERT_CONTRACTS', 2);
345: END IF;
346:
347: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');

Line 344: okc_debug.log('900: Entered CONVERT_CONTRACTS', 2);

340: END IF;
341:
342: IF (l_debug = 'Y') THEN
343: okc_debug.Set_Indentation('OKC_EURO_CONV_PUB');
344: okc_debug.log('900: Entered CONVERT_CONTRACTS', 2);
345: END IF;
346:
347: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
348: fnd_file.put_line(FND_FILE.LOG,' Starting Concurrent Program ... ');

Line 377: okc_debug.Log('20: p_org_id : '||p_org_id,2);

373: fnd_file.put_line(FND_FILE.OUTPUT,' Organization Id :'||p_org_id);
374: fnd_file.put_line(FND_FILE.OUTPUT,' ************************************************ ');
375:
376: IF (l_debug = 'Y') THEN
377: okc_debug.Log('20: p_org_id : '||p_org_id,2);
378: okc_debug.Log('20: p_conversion_date : '||p_conversion_date,2);
379: okc_debug.Log('20: p_conversion_type : '||p_conversion_type,2);
380: END IF;
381:

Line 378: okc_debug.Log('20: p_conversion_date : '||p_conversion_date,2);

374: fnd_file.put_line(FND_FILE.OUTPUT,' ************************************************ ');
375:
376: IF (l_debug = 'Y') THEN
377: okc_debug.Log('20: p_org_id : '||p_org_id,2);
378: okc_debug.Log('20: p_conversion_date : '||p_conversion_date,2);
379: okc_debug.Log('20: p_conversion_type : '||p_conversion_type,2);
380: END IF;
381:
382: IF (l_debug = 'Y') THEN

Line 379: okc_debug.Log('20: p_conversion_type : '||p_conversion_type,2);

375:
376: IF (l_debug = 'Y') THEN
377: okc_debug.Log('20: p_org_id : '||p_org_id,2);
378: okc_debug.Log('20: p_conversion_date : '||p_conversion_date,2);
379: okc_debug.Log('20: p_conversion_type : '||p_conversion_type,2);
380: END IF;
381:
382: IF (l_debug = 'Y') THEN
383: okc_debug.Log('25: User ID : '||fnd_global.user_id,2);

Line 383: okc_debug.Log('25: User ID : '||fnd_global.user_id,2);

379: okc_debug.Log('20: p_conversion_type : '||p_conversion_type,2);
380: END IF;
381:
382: IF (l_debug = 'Y') THEN
383: okc_debug.Log('25: User ID : '||fnd_global.user_id,2);
384: okc_debug.Log('25: Conc Req ID : '||fnd_global.conc_request_id,2);
385: END IF;
386:
387: g_conversion_type := p_conversion_type;

Line 384: okc_debug.Log('25: Conc Req ID : '||fnd_global.conc_request_id,2);

380: END IF;
381:
382: IF (l_debug = 'Y') THEN
383: okc_debug.Log('25: User ID : '||fnd_global.user_id,2);
384: okc_debug.Log('25: Conc Req ID : '||fnd_global.conc_request_id,2);
385: END IF;
386:
387: g_conversion_type := p_conversion_type;
388: g_conversion_rate_date := fnd_date.canonical_to_date(p_conversion_date);

Line 435: okc_debug.log('1000: Processing '||

431: -- increment counter
432: k_counter := k_counter + 1;
433: k1_counter:= k1_counter +1;
434: IF (l_debug = 'Y') THEN
435: okc_debug.log('1000: Processing '||
436: (contracts_rec.contract_number || '(' ||
437: contracts_rec.contract_number_modifier || ')' ||
438: ' Currency: ' || contracts_rec.currency_code ||
439: ' Status: ' || contracts_rec.sts_code), 2);

Line 455: okc_debug.log('1200: Record Updated ', 2);

451: If p_update_mode_YN = 'Y' Then
452: If l_return_status='S' Then
453: k_success_counter := k_success_counter+1;
454: IF (l_debug = 'Y') THEN
455: okc_debug.log('1200: Record Updated ', 2);
456: END IF;
457: Elsif l_return_status = 'N' Then
458: k_success_counter := k_success_counter+1;
459: IF (l_debug = 'Y') THEN

Line 460: okc_debug.log('1100: Upgrade not required ', 2);

456: END IF;
457: Elsif l_return_status = 'N' Then
458: k_success_counter := k_success_counter+1;
459: IF (l_debug = 'Y') THEN
460: okc_debug.log('1100: Upgrade not required ', 2);
461: END IF;
462: Else
463: fnd_message.set_name('OKC','OKC_K_CONV_ERROR');
464: fnd_message.set_token('CONTRACT_NUMBER',contracts_rec.contract_number);

Line 467: okc_debug.log('1100: Record not Updated ', 2);

463: fnd_message.set_name('OKC','OKC_K_CONV_ERROR');
464: fnd_message.set_token('CONTRACT_NUMBER',contracts_rec.contract_number);
465: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
466: IF (l_debug = 'Y') THEN
467: okc_debug.log('1100: Record not Updated ', 2);
468: END IF;
469: k_failure_counter := k_failure_counter+1;
470: end If;
471: --dbms_output.put_line(contracts_rec.contract_number);

Line 510: okc_debug.log('1115: After LOOP' || 'Contracts proccessed' ,2);

506: fnd_file.put_line(FND_FILE.OUTPUT,'Total Contracts processed : '||k1_counter);
507: fnd_file.put_line(FND_FILE.LOG,'Total Contracts processed : '||k1_counter);
508:
509: IF (l_debug = 'Y') THEN
510: okc_debug.log('1115: After LOOP' || 'Contracts proccessed' ,2);
511: END IF;
512:
513: If p_update_mode_yn = 'Y' then
514: fnd_file.put_line(FND_FILE.OUTPUT,'Number of Contracts - Success: '||k_success_counter);

Line 520: okc_debug.log('1100: ' || k1_counter || 'Contracts Processed' ,2);

516: commit;
517: End If;
518:
519: IF (l_debug = 'Y') THEN
520: okc_debug.log('1100: ' || k1_counter || 'Contracts Processed' ,2);
521: END IF;
522:
523: fnd_file.put_line(FND_FILE.LOG,' ---------------------------------------------------------- ');
524: fnd_file.put_line(FND_FILE.LOG,'Completed Concurrent Program. ');

Line 532: okc_debug.log('1100: Exiting CONVERT_CONTRACTS', 2);

528: okc_util.stop_trace;
529: END IF;
530:
531: IF (l_debug = 'Y') THEN
532: okc_debug.log('1100: Exiting CONVERT_CONTRACTS', 2);
533: okc_debug.Reset_Indentation;
534: END IF;
535:
536:

Line 533: okc_debug.Reset_Indentation;

529: END IF;
530:
531: IF (l_debug = 'Y') THEN
532: okc_debug.log('1100: Exiting CONVERT_CONTRACTS', 2);
533: okc_debug.Reset_Indentation;
534: END IF;
535:
536:
537: EXCEPTION

Line 542: okc_debug.log('1200: Exiting CONVERT_CONTRACTS:NO_CONVERSION_RQD Exception', 2);

538:
539: WHEN NO_CONVERSION_RQD then
540:
541: IF (l_debug = 'Y') THEN
542: okc_debug.log('1200: Exiting CONVERT_CONTRACTS:NO_CONVERSION_RQD Exception', 2);
543: okc_debug.Reset_Indentation;
544: END IF;
545:
546: fnd_message.set_name('OKC','OKC_CONV_NOT_REQD');

Line 543: okc_debug.Reset_Indentation;

539: WHEN NO_CONVERSION_RQD then
540:
541: IF (l_debug = 'Y') THEN
542: okc_debug.log('1200: Exiting CONVERT_CONTRACTS:NO_CONVERSION_RQD Exception', 2);
543: okc_debug.Reset_Indentation;
544: END IF;
545:
546: fnd_message.set_name('OKC','OKC_CONV_NOT_REQD');
547: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);

Line 552: okc_debug.log('1200: Exiting CONVERT_CONTRACTS:others Exception', 2);

548:
549: WHEN others THEN
550:
551: IF (l_debug = 'Y') THEN
552: okc_debug.log('1200: Exiting CONVERT_CONTRACTS:others Exception', 2);
553: okc_debug.Reset_Indentation;
554: END IF;
555:
556: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');

Line 553: okc_debug.Reset_Indentation;

549: WHEN others THEN
550:
551: IF (l_debug = 'Y') THEN
552: okc_debug.log('1200: Exiting CONVERT_CONTRACTS:others Exception', 2);
553: okc_debug.Reset_Indentation;
554: END IF;
555:
556: fnd_message.set_name('OKC','OKC_CATASTROPHIC_ERROR');
557: fnd_message.set_token('ROUTINE',l_proc);