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.FII_RECONVERSION_PKG dependencies on FII_UTIL

Line 79: FII_UTIL.initialize(p_log_filename || '.log',

75:
76: --
77: -- 1.1 Initialize the logging
78: --
79: FII_UTIL.initialize(p_log_filename || '.log',
80: p_output_filename || '.out',
81: NULL, 'FII_RECONVERSION_PKG');
82: -- LOG: Function enter
83: FII_RECONVERSION_PKG.func_enter(l_procedure_name);

Line 87: FII_UTIL.put_line(' ');

83: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
84:
85: -- LOG: List all passed parameters
86: l_process_step := 'LOG_LIST_PARAMS';
87: FII_UTIL.put_line(' ');
88: FII_UTIL.put_line(FND_MESSAGE.get_string('FND', 'CONC-PARAMETERS') || ':');
89: FII_UTIL.put_line(FII_MESSAGE.get_message(
90: 'FII_RECONV_TRX_TYPE_PARAM_P', NULL
91: , 'P_VALUE', p_transaction_type));

Line 88: FII_UTIL.put_line(FND_MESSAGE.get_string('FND', 'CONC-PARAMETERS') || ':');

84:
85: -- LOG: List all passed parameters
86: l_process_step := 'LOG_LIST_PARAMS';
87: FII_UTIL.put_line(' ');
88: FII_UTIL.put_line(FND_MESSAGE.get_string('FND', 'CONC-PARAMETERS') || ':');
89: FII_UTIL.put_line(FII_MESSAGE.get_message(
90: 'FII_RECONV_TRX_TYPE_PARAM_P', NULL
91: , 'P_VALUE', p_transaction_type));
92: FII_UTIL.put_line(FII_MESSAGE.get_message(

Line 89: FII_UTIL.put_line(FII_MESSAGE.get_message(

85: -- LOG: List all passed parameters
86: l_process_step := 'LOG_LIST_PARAMS';
87: FII_UTIL.put_line(' ');
88: FII_UTIL.put_line(FND_MESSAGE.get_string('FND', 'CONC-PARAMETERS') || ':');
89: FII_UTIL.put_line(FII_MESSAGE.get_message(
90: 'FII_RECONV_TRX_TYPE_PARAM_P', NULL
91: , 'P_VALUE', p_transaction_type));
92: FII_UTIL.put_line(FII_MESSAGE.get_message(
93: 'FII_RECONV_CURR_TYPE_PARAM_P', NULL

Line 92: FII_UTIL.put_line(FII_MESSAGE.get_message(

88: FII_UTIL.put_line(FND_MESSAGE.get_string('FND', 'CONC-PARAMETERS') || ':');
89: FII_UTIL.put_line(FII_MESSAGE.get_message(
90: 'FII_RECONV_TRX_TYPE_PARAM_P', NULL
91: , 'P_VALUE', p_transaction_type));
92: FII_UTIL.put_line(FII_MESSAGE.get_message(
93: 'FII_RECONV_CURR_TYPE_PARAM_P', NULL
94: , 'P_VALUE', p_currency_type));
95: FII_UTIL.put_line(FII_MESSAGE.get_message(
96: 'FII_RECONV_PRI_RTYPE_PARAM_P', NULL

Line 95: FII_UTIL.put_line(FII_MESSAGE.get_message(

91: , 'P_VALUE', p_transaction_type));
92: FII_UTIL.put_line(FII_MESSAGE.get_message(
93: 'FII_RECONV_CURR_TYPE_PARAM_P', NULL
94: , 'P_VALUE', p_currency_type));
95: FII_UTIL.put_line(FII_MESSAGE.get_message(
96: 'FII_RECONV_PRI_RTYPE_PARAM_P', NULL
97: , 'P_VALUE', p_primary_rate_type));
98: FII_UTIL.put_line(FII_MESSAGE.get_message(
99: 'FII_RECONV_SEC_RTYPE_PARAM_P', NULL

Line 98: FII_UTIL.put_line(FII_MESSAGE.get_message(

94: , 'P_VALUE', p_currency_type));
95: FII_UTIL.put_line(FII_MESSAGE.get_message(
96: 'FII_RECONV_PRI_RTYPE_PARAM_P', NULL
97: , 'P_VALUE', p_primary_rate_type));
98: FII_UTIL.put_line(FII_MESSAGE.get_message(
99: 'FII_RECONV_SEC_RTYPE_PARAM_P', NULL
100: , 'P_VALUE', p_secondary_rate_type));
101: FII_UTIL.put_line(FII_MESSAGE.get_message(
102: 'FII_RECONV_FROM_DATE_PARAM_P', NULL

Line 101: FII_UTIL.put_line(FII_MESSAGE.get_message(

97: , 'P_VALUE', p_primary_rate_type));
98: FII_UTIL.put_line(FII_MESSAGE.get_message(
99: 'FII_RECONV_SEC_RTYPE_PARAM_P', NULL
100: , 'P_VALUE', p_secondary_rate_type));
101: FII_UTIL.put_line(FII_MESSAGE.get_message(
102: 'FII_RECONV_FROM_DATE_PARAM_P', NULL
103: , 'P_VALUE', p_from_date));
104: FII_UTIL.put_line(FII_MESSAGE.get_message(
105: 'FII_RECONV_TO_DATE_PARAM_P', NULL

Line 104: FII_UTIL.put_line(FII_MESSAGE.get_message(

100: , 'P_VALUE', p_secondary_rate_type));
101: FII_UTIL.put_line(FII_MESSAGE.get_message(
102: 'FII_RECONV_FROM_DATE_PARAM_P', NULL
103: , 'P_VALUE', p_from_date));
104: FII_UTIL.put_line(FII_MESSAGE.get_message(
105: 'FII_RECONV_TO_DATE_PARAM_P', NULL
106: , 'P_VALUE', p_to_date));
107:
108: -- LOG: FII_RECONV_INIT_STEP || time stamp

Line 109: FII_UTIL.put_line(' ');

105: 'FII_RECONV_TO_DATE_PARAM_P', NULL
106: , 'P_VALUE', p_to_date));
107:
108: -- LOG: FII_RECONV_INIT_STEP || time stamp
109: FII_UTIL.put_line(' ');
110: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));
111: -- LOG: State debug mode is on if it does
112: FII_UTIL.debug_line('This process is running in debug mode');
113:

Line 110: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));

106: , 'P_VALUE', p_to_date));
107:
108: -- LOG: FII_RECONV_INIT_STEP || time stamp
109: FII_UTIL.put_line(' ');
110: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));
111: -- LOG: State debug mode is on if it does
112: FII_UTIL.debug_line('This process is running in debug mode');
113:
114: --

Line 112: FII_UTIL.debug_line('This process is running in debug mode');

108: -- LOG: FII_RECONV_INIT_STEP || time stamp
109: FII_UTIL.put_line(' ');
110: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));
111: -- LOG: State debug mode is on if it does
112: FII_UTIL.debug_line('This process is running in debug mode');
113:
114: --
115: -- 1.2 Initialize the variables and validate the parameters
116: --

Line 121: FII_UTIL.debug_line('Variables:');

117:
118: -- Set l_conc_req_id
119: l_process_step := 'GET_CONC_REQ_ID';
120: l_conc_req_id := FND_GLOBAL.conc_request_id;
121: FII_UTIL.debug_line('Variables:');
122: FII_UTIL.debug_line(' l_conc_req_id = ' || l_conc_req_id);
123: l_user_id := FND_GLOBAL.user_id;
124: FII_UTIL.debug_line(' l_user_id = ' || l_user_id);
125:

Line 122: FII_UTIL.debug_line(' l_conc_req_id = ' || l_conc_req_id);

118: -- Set l_conc_req_id
119: l_process_step := 'GET_CONC_REQ_ID';
120: l_conc_req_id := FND_GLOBAL.conc_request_id;
121: FII_UTIL.debug_line('Variables:');
122: FII_UTIL.debug_line(' l_conc_req_id = ' || l_conc_req_id);
123: l_user_id := FND_GLOBAL.user_id;
124: FII_UTIL.debug_line(' l_user_id = ' || l_user_id);
125:
126: -- Set l_reconv_gl_flag based on p_transaction_type

Line 124: FII_UTIL.debug_line(' l_user_id = ' || l_user_id);

120: l_conc_req_id := FND_GLOBAL.conc_request_id;
121: FII_UTIL.debug_line('Variables:');
122: FII_UTIL.debug_line(' l_conc_req_id = ' || l_conc_req_id);
123: l_user_id := FND_GLOBAL.user_id;
124: FII_UTIL.debug_line(' l_user_id = ' || l_user_id);
125:
126: -- Set l_reconv_gl_flag based on p_transaction_type
127: l_process_step := 'CHECK_RECONV_GL';
128: IF (p_transaction_type = 'GL' OR p_transaction_type = 'ALL')

Line 151: FII_UTIL.debug_line(' l_gl_name = ' || l_gl_name);

147: EXCEPTION
148: WHEN OTHERS THEN
149: l_gl_name := 'Oracle General Ledger';
150: END;
151: FII_UTIL.debug_line(' l_gl_name = ' || l_gl_name);
152:
153: -- Set l_reconv_gl_flag
154: IF (l_installed_flag = 'Y')
155: THEN

Line 173: FII_UTIL.debug_line(' l_reconv_gl_flag = ' || l_reconv_gl_flag);

169: END IF; -- IF (p_transaction_type = 'GL')
170:
171: END IF; -- IF (l_installed_flag = 'Y')
172: END IF; -- IF (p_transaction_type = 'GL' OR p_transaction_type = 'ALL')
173: FII_UTIL.debug_line(' l_reconv_gl_flag = ' || l_reconv_gl_flag);
174:
175: -- Set l_reconv_ap_flag based on p_transaction_type
176: l_process_step := 'CHECK_RECONV_AP';
177: IF (p_transaction_type = 'AP' OR p_transaction_type = 'ALL')

Line 198: FII_UTIL.debug_line(' l_ap_name = ' || l_ap_name);

194: EXCEPTION
195: WHEN OTHERS THEN
196: l_ap_name := 'Oracle Payables';
197: END;
198: FII_UTIL.debug_line(' l_ap_name = ' || l_ap_name);
199:
200: -- Set l_reconv_ap_flag
201: IF (l_installed_flag = 'Y')
202: THEN

Line 220: FII_UTIL.debug_line(' l_reconv_ap_flag = ' || l_reconv_ap_flag);

216: END IF; -- IF (p_transaction_type = 'AP')
217:
218: END IF; -- IF (l_installed_flag = 'Y')
219: END IF; -- IF (p_transaction_type = 'AP' OR p_transaction_type = 'ALL')
220: FII_UTIL.debug_line(' l_reconv_ap_flag = ' || l_reconv_ap_flag);
221:
222: -- Set l_reconv_ar_flag based on p_transaction_type
223: l_process_step := 'CHECK_RECONV_AR';
224: IF (p_transaction_type = 'AR' OR p_transaction_type = 'ALL')

Line 245: FII_UTIL.debug_line(' l_ar_name = ' || l_ar_name);

241: EXCEPTION
242: WHEN OTHERS THEN
243: l_ar_name := 'Oracle Receivables';
244: END;
245: FII_UTIL.debug_line(' l_ar_name = ' || l_ar_name);
246:
247: -- Set l_reconv_ar_flag
248: IF (l_installed_flag = 'Y')
249: THEN

Line 267: FII_UTIL.debug_line(' l_reconv_ar_flag = ' || l_reconv_ar_flag);

263: END IF; -- IF (p_transaction_type = 'AR')
264:
265: END IF; -- IF (l_installed_flag = 'Y')
266: END IF; -- IF (p_transaction_type = 'AR' OR p_transaction_type = 'ALL')
267: FII_UTIL.debug_line(' l_reconv_ar_flag = ' || l_reconv_ar_flag);
268:
269: l_process_step := 'GET_PRI_SEC_TEXT';
270: -- Set l_primaryText
271: l_primaryText := FII_MESSAGE.get_message('FII_RECONV_PRIMARY', NULL);

Line 272: FII_UTIL.debug_line(' l_primaryText = ' || l_primaryText);

268:
269: l_process_step := 'GET_PRI_SEC_TEXT';
270: -- Set l_primaryText
271: l_primaryText := FII_MESSAGE.get_message('FII_RECONV_PRIMARY', NULL);
272: FII_UTIL.debug_line(' l_primaryText = ' || l_primaryText);
273: -- Set l_secondaryText
274: l_secondaryText := FII_MESSAGE.get_message('FII_RECONV_SECONDARY', NULL);
275: FII_UTIL.debug_line(' l_secondaryText = ' || l_secondaryText);
276:

Line 275: FII_UTIL.debug_line(' l_secondaryText = ' || l_secondaryText);

271: l_primaryText := FII_MESSAGE.get_message('FII_RECONV_PRIMARY', NULL);
272: FII_UTIL.debug_line(' l_primaryText = ' || l_primaryText);
273: -- Set l_secondaryText
274: l_secondaryText := FII_MESSAGE.get_message('FII_RECONV_SECONDARY', NULL);
275: FII_UTIL.debug_line(' l_secondaryText = ' || l_secondaryText);
276:
277: -- Validate Primary global currency setup
278: l_process_step := 'VALIDATE_PRI_SETUP';
279: IF (p_currency_type = 'PRIMARY' OR p_currency_type = 'ALL')

Line 294: FII_UTIL.debug_line(' l_primary_currency = ' || l_primary_currency);

290:
291: ELSE
292: -- Set l_primary_currency and l_primary_mau
293: l_primary_currency := BIS_COMMON_PARAMETERS.get_currency_code;
294: FII_UTIL.debug_line(' l_primary_currency = ' || l_primary_currency);
295: l_primary_mau := FII_CURRENCY.get_mau_primary;
296: FII_UTIL.debug_line(' l_primary_mau = ' || l_primary_mau);
297:
298: -- Validate primary currency and its MAU

Line 296: FII_UTIL.debug_line(' l_primary_mau = ' || l_primary_mau);

292: -- Set l_primary_currency and l_primary_mau
293: l_primary_currency := BIS_COMMON_PARAMETERS.get_currency_code;
294: FII_UTIL.debug_line(' l_primary_currency = ' || l_primary_currency);
295: l_primary_mau := FII_CURRENCY.get_mau_primary;
296: FII_UTIL.debug_line(' l_primary_mau = ' || l_primary_mau);
297:
298: -- Validate primary currency and its MAU
299: IF (l_primary_currency IS NULL AND p_currency_type = 'PRIMARY')
300: THEN

Line 336: FII_UTIL.debug_line(' l_secondary_currency = ' || l_secondary_currency);

332: RAISE INVALID_SETUP;
333:
334: ELSE
335: l_secondary_currency := BIS_COMMON_PARAMETERS.get_secondary_currency_code;
336: FII_UTIL.debug_line(' l_secondary_currency = ' || l_secondary_currency);
337: l_secondary_mau := FII_CURRENCY.get_mau_secondary;
338: FII_UTIL.debug_line(' l_secondary_mau = ' || l_secondary_mau);
339:
340: IF (l_secondary_currency IS NULL AND p_currency_type = 'SECONDARY')

Line 338: FII_UTIL.debug_line(' l_secondary_mau = ' || l_secondary_mau);

334: ELSE
335: l_secondary_currency := BIS_COMMON_PARAMETERS.get_secondary_currency_code;
336: FII_UTIL.debug_line(' l_secondary_currency = ' || l_secondary_currency);
337: l_secondary_mau := FII_CURRENCY.get_mau_secondary;
338: FII_UTIL.debug_line(' l_secondary_mau = ' || l_secondary_mau);
339:
340: IF (l_secondary_currency IS NULL AND p_currency_type = 'SECONDARY')
341: THEN
342: -- Secondary is selected only but fails to find its currency code

Line 364: FII_UTIL.debug_line(' l_from_date = ' || l_from_date);

360:
361: -- Convert date strings to date format
362: l_process_step := 'CONVERT_STR_TO_DATE';
363: l_from_date := TO_DATE(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
364: FII_UTIL.debug_line(' l_from_date = ' || l_from_date);
365: l_to_date := TO_DATE(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
366: FII_UTIL.debug_line(' l_to_date = ' || l_to_date);
367:
368: -- Validate the date range

Line 366: FII_UTIL.debug_line(' l_to_date = ' || l_to_date);

362: l_process_step := 'CONVERT_STR_TO_DATE';
363: l_from_date := TO_DATE(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
364: FII_UTIL.debug_line(' l_from_date = ' || l_from_date);
365: l_to_date := TO_DATE(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
366: FII_UTIL.debug_line(' l_to_date = ' || l_to_date);
367:
368: -- Validate the date range
369: l_process_step := 'CHECK_FROM_BEFORE_TO';
370: IF (l_from_date > l_to_date)

Line 392: FII_UTIL.debug_line(' l_from_date_id = ' || l_from_date_id);

388: l_err_msg := FII_MESSAGE.get_message( 'FII_RECONV_INVALID_DATE', NULL
389: , 'P_DATE', l_from_date);
390: RAISE INVALID_SETUP;
391: END;
392: FII_UTIL.debug_line(' l_from_date_id = ' || l_from_date_id);
393:
394: -- Validate the passed To Date which is defined in the global calendar
395: l_process_step := 'VALIDATE_TO_DATE';
396: BEGIN

Line 408: FII_UTIL.debug_line(' l_to_date_id = ' || l_to_date_id);

404: l_err_msg := FII_MESSAGE.get_message( 'FII_RECONV_INVALID_DATE', NULL
405: , 'P_DATE', l_to_date);
406: RAISE INVALID_SETUP;
407: END;
408: FII_UTIL.debug_line(' l_to_date_id = ' || l_to_date_id);
409: END IF; -- IF (l_from_date > l_to_date)
410:
411: -- ===========================
412: -- 2. Cache reconversion rates

Line 429: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(

425: -- All required rates are cached successfully, so launch 1 sub-request to
426: -- reconvert global amounts for each product
427:
428: -- LOG: FII_RECONV_LAUNCH_STEP || time stamp
429: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
430: 'FII_RECONV_LAUNCH_STEP', NULL));
431:
432: -- ====================================================
433: -- 3. Launch request to reconvert global amounts for GL

Line 469: FII_UTIL.put_line(FII_MESSAGE.get_message(

465: IF (l_req_list(l_launched_ct).request_id = 0)
466: THEN
467: -- Fail to submit the child request
468: l_completion_status := 'E';
469: FII_UTIL.put_line(FII_MESSAGE.get_message(
470: 'FII_RECONV_LAUNCH_ERROR', NULL
471: , 'PROD_NAME', l_gl_name));
472: FII_UTIL.put_line(' ');
473: ELSE

Line 472: FII_UTIL.put_line(' ');

468: l_completion_status := 'E';
469: FII_UTIL.put_line(FII_MESSAGE.get_message(
470: 'FII_RECONV_LAUNCH_ERROR', NULL
471: , 'PROD_NAME', l_gl_name));
472: FII_UTIL.put_line(' ');
473: ELSE
474: -- Succeed to submit the child request
475: -- Commit it in order to launch the child request
476: COMMIT;

Line 477: FII_UTIL.put_line(FII_MESSAGE.get_message(

473: ELSE
474: -- Succeed to submit the child request
475: -- Commit it in order to launch the child request
476: COMMIT;
477: FII_UTIL.put_line(FII_MESSAGE.get_message(
478: 'FII_RECONV_LAUNCH_SUCCESS', NULL
479: , 'REQ_ID', l_req_list(l_launched_ct).request_id
480: , 'PROD_NAME', l_gl_name));
481: l_running_ct := l_running_ct + 1;

Line 522: FII_UTIL.put_line(FII_MESSAGE.get_message(

518: IF (l_req_list(l_launched_ct).request_id = 0)
519: THEN
520: -- Fail to submit the child request
521: l_completion_status := 'E';
522: FII_UTIL.put_line(FII_MESSAGE.get_message(
523: 'FII_RECONV_LAUNCH_ERROR', NULL
524: , 'PROD_NAME', l_ap_name));
525: ELSE
526: -- Succeed to submit the child request

Line 529: FII_UTIL.put_line(FII_MESSAGE.get_message(

525: ELSE
526: -- Succeed to submit the child request
527: -- Commit it in order to launch the child request
528: COMMIT;
529: FII_UTIL.put_line(FII_MESSAGE.get_message(
530: 'FII_RECONV_LAUNCH_SUCCESS', NULL
531: , 'REQ_ID', l_req_list(l_launched_ct).request_id
532: , 'PROD_NAME', l_ap_name));
533: l_running_ct := l_running_ct + 1;

Line 574: FII_UTIL.put_line(FII_MESSAGE.get_message(

570: IF (l_req_list(l_launched_ct).request_id = 0)
571: THEN
572: -- Fail to submit the child request
573: l_completion_status := 'E';
574: FII_UTIL.put_line(FII_MESSAGE.get_message(
575: 'FII_RECONV_LAUNCH_ERROR', NULL
576: , 'PROD_NAME', l_ar_name));
577: ELSE
578: -- Succeed to submit the child request

Line 581: FII_UTIL.put_line(FII_MESSAGE.get_message(

577: ELSE
578: -- Succeed to submit the child request
579: -- Commit it in order to launch the child request
580: COMMIT;
581: FII_UTIL.put_line(FII_MESSAGE.get_message(
582: 'FII_RECONV_LAUNCH_SUCCESS', NULL
583: , 'REQ_ID', l_req_list(l_launched_ct).request_id
584: , 'PROD_NAME', l_ar_name));
585: l_running_ct := l_running_ct + 1;

Line 598: FII_UTIL.put_line(' ');

594: -- At least one request is submitted successfully, so wait for it to
595: -- complete before proceeding to print the execution report
596: l_process_step := 'WAIT_FOR_REQUESTS';
597: -- LOG: FII_RECONV_LAUNCH_STEP || time stamp
598: FII_UTIL.put_line(' ');
599: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
600: 'FII_RECONV_WAIT_STEP', NULL));
601:
602: WHILE (l_running_ct > 0 )

Line 599: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(

595: -- complete before proceeding to print the execution report
596: l_process_step := 'WAIT_FOR_REQUESTS';
597: -- LOG: FII_RECONV_LAUNCH_STEP || time stamp
598: FII_UTIL.put_line(' ');
599: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
600: 'FII_RECONV_WAIT_STEP', NULL));
601:
602: WHILE (l_running_ct > 0 )
603: LOOP

Line 624: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(

620: IF (l_req_list(i).dev_phase = 'COMPLETE')
621: THEN
622: -- The launched request has completed
623: l_running_ct := l_running_ct - 1;
624: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
625: 'FII_RECONV_CHILD_COMPLETE', NULL
626: , 'REQ_ID', l_req_list(i).request_id
627: , 'STATUS', l_req_list(i).status));
628:

Line 633: FII_UTIL.put_line(FII_MESSAGE.get_message(

629: -- Check if it errors out
630: IF (l_req_list(i).dev_status = 'ERROR')
631: THEN
632: -- The child process errors out, so print error message
633: FII_UTIL.put_line(FII_MESSAGE.get_message(
634: 'FII_RECONV_CHILD_ERROR', NULL
635: , 'REQ_ID', l_req_list(i).request_id));
636: FII_UTIL.put_line(' ' || l_req_list(i).completion_msg);
637:

Line 636: FII_UTIL.put_line(' ' || l_req_list(i).completion_msg);

632: -- The child process errors out, so print error message
633: FII_UTIL.put_line(FII_MESSAGE.get_message(
634: 'FII_RECONV_CHILD_ERROR', NULL
635: , 'REQ_ID', l_req_list(i).request_id));
636: FII_UTIL.put_line(' ' || l_req_list(i).completion_msg);
637:
638: -- If any child request errors out, this process will error out
639: l_completion_status := 'E';
640: END IF; -- IF (l_req_list(i).dev_status = 'ERROR')

Line 659: FII_UTIL.put_line(FII_MESSAGE.get_message(

655:
656: ELSE
657: -- There are no transactions selected for reconversion. We will still
658: -- exit the program successfully
659: FII_UTIL.put_line(FII_MESSAGE.get_message(
660: 'FII_RECONV_NO_TRANSACTIONS', NULL));
661:
662: END IF; -- IF (l_caching_status = 'C')
663:

Line 669: FII_UTIL.put_line(' ');

665: -- 7. Print execution report
666: -- =========================
667: l_process_step := 'PRINT_EXECUTION_REPORT';
668: -- LOG: FII_RECONV_PRINT_RPT_STEP || time stamp
669: FII_UTIL.put_line(' ');
670: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
671: 'FII_RECONV_PRINT_RPT_STEP', NULL));
672: FII_RECONVERSION_PKG.print_report( l_conc_req_id
673: , p_transaction_type

Line 670: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(

666: -- =========================
667: l_process_step := 'PRINT_EXECUTION_REPORT';
668: -- LOG: FII_RECONV_PRINT_RPT_STEP || time stamp
669: FII_UTIL.put_line(' ');
670: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
671: 'FII_RECONV_PRINT_RPT_STEP', NULL));
672: FII_RECONVERSION_PKG.print_report( l_conc_req_id
673: , p_transaction_type
674: , p_currency_type

Line 689: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(

685: -- 8. Cleanup the cached rates
686: -- ===========================
687: l_process_step := 'CLEANUP_CACHED_RATES';
688: -- LOG: FII_RECONV_EXIT_PROCESS_STEP || time stamp
689: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
690: 'FII_RECONV_CLEANUP_STEP', NULL));
691: -- Delete cached rates from FII_RECONV_RATES for this request and commit
692: DELETE FROM FII_RECONV_RATES
693: WHERE request_id = l_conc_req_id;

Line 701: FII_UTIL.put_line(' ');

697: -- 9. Exit the process
698: -- ===================
699: l_process_step := 'EXIT_PROCESS';
700: -- LOG: FII_RECONV_EXIT_PROCESS_STEP || time stamp
701: FII_UTIL.put_line(' ');
702: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
703: 'FII_RECONV_EXIT_PROCESS_STEP', NULL));
704:
705: IF (l_completion_status = 'E')

Line 702: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(

698: -- ===================
699: l_process_step := 'EXIT_PROCESS';
700: -- LOG: FII_RECONV_EXIT_PROCESS_STEP || time stamp
701: FII_UTIL.put_line(' ');
702: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
703: 'FII_RECONV_EXIT_PROCESS_STEP', NULL));
704:
705: IF (l_completion_status = 'E')
706: THEN

Line 710: FII_UTIL.debug_line('This process errors out because of sub-request(s)');

706: THEN
707: -- Process errors out
708: IF (l_caching_status = 'C')
709: THEN
710: FII_UTIL.debug_line('This process errors out because of sub-request(s)');
711: errbuf := FII_MESSAGE.get_message('FII_RECONV_PROCESS_FAIL', NULL);
712: l_process_step := 'LAUNCH_REQUESTS';
713: ELSE
714: FII_UTIL.debug_line('This process errors out because of missing rate(s)');

Line 714: FII_UTIL.debug_line('This process errors out because of missing rate(s)');

710: FII_UTIL.debug_line('This process errors out because of sub-request(s)');
711: errbuf := FII_MESSAGE.get_message('FII_RECONV_PROCESS_FAIL', NULL);
712: l_process_step := 'LAUNCH_REQUESTS';
713: ELSE
714: FII_UTIL.debug_line('This process errors out because of missing rate(s)');
715: errbuf := l_err_msg;
716: l_process_step := 'CACHE_RATES';
717: END IF;
718: -- Print error messages to log

Line 727: FII_UTIL.debug_line('This process completes successfully');

723: RAISE_APPLICATION_ERROR(-20010, errbuf);
724:
725: ELSE
726: -- Process coompletes successfully
727: FII_UTIL.debug_line('This process completes successfully');
728: -- Commit changes to the database
729: FND_CONCURRENT.af_commit;
730: -- Set the concurrent program completion status
731: l_return_val := FND_CONCURRENT.set_completion_status('COMPLETE', NULL);

Line 739: FII_UTIL.debug_line('This process errors out because of invalid setup');

735: EXCEPTION
736: WHEN INVALID_SETUP THEN
737: -- Process fails because of invalid setup
738: -- Note: We don't need to rollback since there are no updates/insert
739: FII_UTIL.debug_line('This process errors out because of invalid setup');
740: -- Print error messages to log
741: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, l_err_msg);
742: -- Set the concurrent program completion status to ERROR
743: l_return_val := FND_CONCURRENT.set_completion_status('ERROR', NULL);

Line 751: FII_UTIL.debug_line('This process errors out because of other functions');

747:
748: WHEN RECONV_ERROR THEN
749: -- Process fails because of exceptions raised from other functions
750: -- and we need to rollback
751: FII_UTIL.debug_line('This process errors out because of other functions');
752: -- Rollback
753: FND_CONCURRENT.af_rollback;
754: -- Print error messages to log file
755: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step);

Line 765: FII_UTIL.debug_line('This process errors out because of other exceptions');

761: RAISE_APPLICATION_ERROR(-20030, errbuf);
762:
763: WHEN OTHERS THEN
764: -- Process fails because of other exceptions and we need to rollback
765: FII_UTIL.debug_line('This process errors out because of other exceptions');
766: -- Rollback
767: FND_CONCURRENT.af_rollback;
768: -- Print error messages to log file
769: errbuf := sqlerrm;

Line 824: FII_UTIL.put_line(' ');

820: --
821: l_process_step := 'CACHE_RATES_FOR_GL';
822:
823: -- LOG: FII_RECONV_CACHE_RATE_STEP || time stamp for GL
824: FII_UTIL.put_line(' ');
825: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
826: 'FII_RECONV_CACHE_RATE_STEP', NULL
827: , 'PROD_NAME', p_gl_name));
828:

Line 825: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(

821: l_process_step := 'CACHE_RATES_FOR_GL';
822:
823: -- LOG: FII_RECONV_CACHE_RATE_STEP || time stamp for GL
824: FII_UTIL.put_line(' ');
825: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
826: 'FII_RECONV_CACHE_RATE_STEP', NULL
827: , 'PROD_NAME', p_gl_name));
828:
829: -- Insert rates to FII_RECONV_RATES based on the transactions of

Line 860: FII_UTIL.put_timestamp(FND_MESSAGE.get);

856: l_cached_rate_flag := TRUE;
857: END IF;
858: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
859: FND_MESSAGE.set_token('ROWS', l_cached_rate_count);
860: FII_UTIL.put_timestamp(FND_MESSAGE.get);
861: END IF; -- IF (p_cache_for_gl_flag = 'Y')
862:
863: IF (p_cache_for_ap_flag = 'Y')
864: THEN

Line 871: FII_UTIL.put_line(' ');

867: --
868: l_process_step := 'CACHE_RATES_FOR_AP';
869:
870: -- LOG: FII_RECONV_CACHE_RATE_STEP || time stamp for AP
871: FII_UTIL.put_line(' ');
872: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
873: 'FII_RECONV_CACHE_RATE_STEP', NULL
874: , 'PROD_NAME', p_ap_name));
875:

Line 872: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(

868: l_process_step := 'CACHE_RATES_FOR_AP';
869:
870: -- LOG: FII_RECONV_CACHE_RATE_STEP || time stamp for AP
871: FII_UTIL.put_line(' ');
872: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
873: 'FII_RECONV_CACHE_RATE_STEP', NULL
874: , 'PROD_NAME', p_ap_name));
875:
876: -- Insert rates to FII_RECONV_RATES based on the transactions of

Line 909: FII_UTIL.put_timestamp(FND_MESSAGE.get);

905: l_cached_rate_flag := TRUE;
906: END IF;
907: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
908: FND_MESSAGE.set_token('ROWS', l_cached_rate_count);
909: FII_UTIL.put_timestamp(FND_MESSAGE.get);
910: END IF; -- IF (p_cache_for_ap_flag = 'Y')
911:
912: IF (p_cache_for_ar_flag = 'Y')
913: THEN

Line 920: FII_UTIL.put_line(' ');

916: --
917: l_process_step := 'CACHE_RATES_FOR_AR';
918:
919: -- LOG: FII_RECONV_CACHE_RATE_STEP || time stamp for AR
920: FII_UTIL.put_line(' ');
921: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
922: 'FII_RECONV_CACHE_RATE_STEP', NULL
923: , 'PROD_NAME', p_ar_name));
924:

Line 921: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(

917: l_process_step := 'CACHE_RATES_FOR_AR';
918:
919: -- LOG: FII_RECONV_CACHE_RATE_STEP || time stamp for AR
920: FII_UTIL.put_line(' ');
921: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
922: 'FII_RECONV_CACHE_RATE_STEP', NULL
923: , 'PROD_NAME', p_ar_name));
924:
925: -- Insert rates to FII_RECONV_RATES based on the transactions of

Line 958: FII_UTIL.put_timestamp(FND_MESSAGE.get);

954: l_cached_rate_flag := TRUE;
955: END IF;
956: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
957: FND_MESSAGE.set_token('ROWS', l_cached_rate_count);
958: FII_UTIL.put_timestamp(FND_MESSAGE.get);
959: END IF; -- IF (p_cache_for_ar_flag = 'Y')
960:
961: --
962: -- 2.4 Determine the caching rate status

Line 974: FII_UTIL.debug_line(' ');

970: SELECT count(*) INTO l_missing_rate_count
971: FROM FII_RECONV_RATES
972: WHERE request_id = p_request_id
973: AND (NVL(primary_rate, 1) <= 0 OR NVL(secondary_rate, 1) <= 0);
974: FII_UTIL.debug_line(' ');
975: FII_UTIL.debug_line(TO_CHAR(l_missing_rate_count)
976: || ' days have missing rates');
977:
978: IF (l_missing_rate_count > 0)

Line 975: FII_UTIL.debug_line(TO_CHAR(l_missing_rate_count)

971: FROM FII_RECONV_RATES
972: WHERE request_id = p_request_id
973: AND (NVL(primary_rate, 1) <= 0 OR NVL(secondary_rate, 1) <= 0);
974: FII_UTIL.debug_line(' ');
975: FII_UTIL.debug_line(TO_CHAR(l_missing_rate_count)
976: || ' days have missing rates');
977:
978: IF (l_missing_rate_count > 0)
979: THEN

Line 1041: FII_UTIL.initialize(p_log_filename || '_GL.log',

1037: BEGIN
1038: --
1039: -- 3.1 Initialize the logging for this child request
1040: --
1041: FII_UTIL.initialize(p_log_filename || '_GL.log',
1042: p_output_filename || '_GL.out',
1043: NULL, 'FII_RECONVERSION_PKG');
1044: -- LOG: Function enter
1045: FII_RECONVERSION_PKG.func_enter(l_procedure_name);

Line 1047: FII_UTIL.put_line(' ');

1043: NULL, 'FII_RECONVERSION_PKG');
1044: -- LOG: Function enter
1045: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
1046: -- LOG: FII_RECONV_INIT_STEP || time stamp
1047: FII_UTIL.put_line(' ');
1048: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));
1049: -- LOG: State debug mode is on if it does
1050: FII_UTIL.debug_line('This process is running in debug mode');
1051:

Line 1048: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));

1044: -- LOG: Function enter
1045: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
1046: -- LOG: FII_RECONV_INIT_STEP || time stamp
1047: FII_UTIL.put_line(' ');
1048: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));
1049: -- LOG: State debug mode is on if it does
1050: FII_UTIL.debug_line('This process is running in debug mode');
1051:
1052: -- Determine if we should use ID columns or not

Line 1050: FII_UTIL.debug_line('This process is running in debug mode');

1046: -- LOG: FII_RECONV_INIT_STEP || time stamp
1047: FII_UTIL.put_line(' ');
1048: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));
1049: -- LOG: State debug mode is on if it does
1050: FII_UTIL.debug_line('This process is running in debug mode');
1051:
1052: -- Determine if we should use ID columns or not
1053: l_process_step := 'CHECK_USE_ID_COLS';
1054: BEGIN

Line 1085: FII_UTIL.debug_line('ID columns exists');

1081:
1082: -- It can select the ID columns from FII_GL_JE_SUMMARY_B and
1083: -- FII_RECONV_GL_ROLLUP_GT, so set l_use_id_columns to TRUE
1084: l_use_id_columns := TRUE;
1085: FII_UTIL.debug_line('ID columns exists');
1086: EXCEPTION
1087: WHEN OTHERS THEN
1088: l_use_id_columns := FALSE;
1089: FII_UTIL.debug_line('ID columns do not exist');

Line 1089: FII_UTIL.debug_line('ID columns do not exist');

1085: FII_UTIL.debug_line('ID columns exists');
1086: EXCEPTION
1087: WHEN OTHERS THEN
1088: l_use_id_columns := FALSE;
1089: FII_UTIL.debug_line('ID columns do not exist');
1090: END;
1091:
1092: -- LOG: FII_RECONV_RECONVERT_AMT_STEP || time stamp for GL
1093: FII_UTIL.put_line(' ');

Line 1093: FII_UTIL.put_line(' ');

1089: FII_UTIL.debug_line('ID columns do not exist');
1090: END;
1091:
1092: -- LOG: FII_RECONV_RECONVERT_AMT_STEP || time stamp for GL
1093: FII_UTIL.put_line(' ');
1094: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
1095: 'FII_RECONV_RECONVERT_AMT_STEP', NULL
1096: , 'PROD_NAME', p_product_name));
1097:

Line 1094: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(

1090: END;
1091:
1092: -- LOG: FII_RECONV_RECONVERT_AMT_STEP || time stamp for GL
1093: FII_UTIL.put_line(' ');
1094: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
1095: 'FII_RECONV_RECONVERT_AMT_STEP', NULL
1096: , 'PROD_NAME', p_product_name));
1097:
1098: --

Line 1312: FII_UTIL.put_timestamp(FND_MESSAGE.get);

1308: l_process_step := 'RUN_DAILY_SQL';
1309: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1310: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1311: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1312: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1313:
1314: -- Close cursor
1315: l_process_step := 'CLOSE_DAILY_SQL';
1316: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

Line 1448: FII_UTIL.put_timestamp(FND_MESSAGE.get);

1444: l_process_step := 'RUN_WEEKLY_SQL';
1445: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1446: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1447: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1448: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1449:
1450: -- Close cursor
1451: l_process_step := 'CLOSE_WEEKLY_SQL';
1452: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

Line 1590: FII_UTIL.put_timestamp(FND_MESSAGE.get);

1586: l_process_step := 'RUN_OTHER_SQL';
1587: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1588: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1589: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1590: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1591:
1592: -- Close cursor
1593: l_process_step := 'CLOSE_OTHER_SQL';
1594: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

Line 1781: FII_UTIL.put_timestamp(FND_MESSAGE.get);

1777: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1778: COMMIT;
1779: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1780: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1781: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1782:
1783: -- Close cursor
1784: l_process_step := 'CLOSE_UPDATE_SQL';
1785: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

Line 1789: FII_UTIL.put_line(' ');

1785: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
1786:
1787: END IF; -- IF (l_processed_rows > 0)
1788: -- LOG: Print out the number of updated rows for GL
1789: FII_UTIL.put_line(' ');
1790: l_message := FII_MESSAGE.get_message('FII_RECONV_UPDATED_ROWS', NULL,
1791: 'NUM_ROWS', l_processed_rows,
1792: 'PROD_NAME', p_product_name);
1793: FII_UTIL.put_line(l_message);

Line 1793: FII_UTIL.put_line(l_message);

1789: FII_UTIL.put_line(' ');
1790: l_message := FII_MESSAGE.get_message('FII_RECONV_UPDATED_ROWS', NULL,
1791: 'NUM_ROWS', l_processed_rows,
1792: 'PROD_NAME', p_product_name);
1793: FII_UTIL.put_line(l_message);
1794:
1795: --
1796: -- 3.6 This process completes successfully
1797: --

Line 1800: FII_UTIL.put_line(' ');

1796: -- 3.6 This process completes successfully
1797: --
1798: l_process_step := 'EXIT_PROCESS';
1799: -- LOG: FII_RECONV_EXIT_PROCESS_STEP || time stamp
1800: FII_UTIL.put_line(' ');
1801: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
1802: 'FII_RECONV_EXIT_PROCESS_STEP', NULL));
1803: FII_UTIL.debug_line('Process complete successfully');
1804:

Line 1801: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(

1797: --
1798: l_process_step := 'EXIT_PROCESS';
1799: -- LOG: FII_RECONV_EXIT_PROCESS_STEP || time stamp
1800: FII_UTIL.put_line(' ');
1801: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
1802: 'FII_RECONV_EXIT_PROCESS_STEP', NULL));
1803: FII_UTIL.debug_line('Process complete successfully');
1804:
1805: -- Commit changes to the database and print log messages

Line 1803: FII_UTIL.debug_line('Process complete successfully');

1799: -- LOG: FII_RECONV_EXIT_PROCESS_STEP || time stamp
1800: FII_UTIL.put_line(' ');
1801: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
1802: 'FII_RECONV_EXIT_PROCESS_STEP', NULL));
1803: FII_UTIL.debug_line('Process complete successfully');
1804:
1805: -- Commit changes to the database and print log messages
1806: FND_CONCURRENT.af_commit;
1807: -- Set the concurrent program completion status to COMPLETE

Line 1816: FII_UTIL.debug_line('Proces errors out because of other functions'' error');

1812: EXCEPTION
1813: WHEN RECONV_ERROR THEN
1814: -- Process fails because of exceptions raised from other functions
1815: -- and we need to rollback
1816: FII_UTIL.debug_line('Proces errors out because of other functions'' error');
1817: -- Rollback
1818: FND_CONCURRENT.af_rollback;
1819: -- Print error messages to log file
1820: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step);

Line 1830: FII_UTIL.debug_line('Proces errors out because of other exception');

1826: RAISE_APPLICATION_ERROR(-20050, errbuf);
1827:
1828: WHEN OTHERS THEN
1829: -- Process fails because of other exceptions and we need to rollback
1830: FII_UTIL.debug_line('Proces errors out because of other exception');
1831: -- Rollback
1832: FND_CONCURRENT.af_rollback;
1833: -- Print error messages to log file
1834: errbuf := sqlerrm;

Line 1874: FII_UTIL.initialize(p_log_filename || '_AP.log',

1870: BEGIN
1871: --
1872: -- 4.1 Initialize the logging for this child request
1873: --
1874: FII_UTIL.initialize(p_log_filename || '_AP.log',
1875: p_output_filename || '_AP.out',
1876: NULL, 'FII_RECONVERSION_PKG');
1877: FII_UTIL.put_line(' ');
1878: -- LOG: Function enter

Line 1877: FII_UTIL.put_line(' ');

1873: --
1874: FII_UTIL.initialize(p_log_filename || '_AP.log',
1875: p_output_filename || '_AP.out',
1876: NULL, 'FII_RECONVERSION_PKG');
1877: FII_UTIL.put_line(' ');
1878: -- LOG: Function enter
1879: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
1880: -- LOG: FII_RECONV_INIT_STEP || time stamp
1881: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));

Line 1881: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));

1877: FII_UTIL.put_line(' ');
1878: -- LOG: Function enter
1879: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
1880: -- LOG: FII_RECONV_INIT_STEP || time stamp
1881: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));
1882: -- LOG: State debug mode is on if it does
1883: FII_UTIL.debug_line('This process is running in debug mode');
1884:
1885: -- LOG: FII_RECONV_RECONVERT_AMT_STEP || time stamp for AP

Line 1883: FII_UTIL.debug_line('This process is running in debug mode');

1879: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
1880: -- LOG: FII_RECONV_INIT_STEP || time stamp
1881: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));
1882: -- LOG: State debug mode is on if it does
1883: FII_UTIL.debug_line('This process is running in debug mode');
1884:
1885: -- LOG: FII_RECONV_RECONVERT_AMT_STEP || time stamp for AP
1886: FII_UTIL.put_line(' ');
1887: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(

Line 1886: FII_UTIL.put_line(' ');

1882: -- LOG: State debug mode is on if it does
1883: FII_UTIL.debug_line('This process is running in debug mode');
1884:
1885: -- LOG: FII_RECONV_RECONVERT_AMT_STEP || time stamp for AP
1886: FII_UTIL.put_line(' ');
1887: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
1888: 'FII_RECONV_RECONVERT_AMT_STEP', NULL
1889: , 'PROD_NAME', p_product_name));
1890:

Line 1887: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(

1883: FII_UTIL.debug_line('This process is running in debug mode');
1884:
1885: -- LOG: FII_RECONV_RECONVERT_AMT_STEP || time stamp for AP
1886: FII_UTIL.put_line(' ');
1887: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
1888: 'FII_RECONV_RECONVERT_AMT_STEP', NULL
1889: , 'PROD_NAME', p_product_name));
1890:
1891: --

Line 1937: FII_UTIL.put_line(l_message);

1933: -- LOG: Print out the number of updated rows for AP
1934: l_message := FII_MESSAGE.get_message('FII_RECONV_UPDATED_ROWS', NULL,
1935: 'NUM_ROWS', NVL(l_processed_rows, 0),
1936: 'PROD_NAME', p_product_name);
1937: FII_UTIL.put_line(l_message);
1938:
1939: --
1940: -- 4.3 This process completes successfully
1941: --

Line 1944: FII_UTIL.put_line(' ');

1940: -- 4.3 This process completes successfully
1941: --
1942: l_process_step := 'EXIT_PROCESS';
1943: -- LOG: FII_RECONV_EXIT_PROCESS_STEP || time stamp
1944: FII_UTIL.put_line(' ');
1945: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
1946: 'FII_RECONV_EXIT_PROCESS_STEP', NULL));
1947: FII_UTIL.debug_line('Process complete successfully');
1948:

Line 1945: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(

1941: --
1942: l_process_step := 'EXIT_PROCESS';
1943: -- LOG: FII_RECONV_EXIT_PROCESS_STEP || time stamp
1944: FII_UTIL.put_line(' ');
1945: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
1946: 'FII_RECONV_EXIT_PROCESS_STEP', NULL));
1947: FII_UTIL.debug_line('Process complete successfully');
1948:
1949: -- Commit changes to the database and print log messages

Line 1947: FII_UTIL.debug_line('Process complete successfully');

1943: -- LOG: FII_RECONV_EXIT_PROCESS_STEP || time stamp
1944: FII_UTIL.put_line(' ');
1945: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
1946: 'FII_RECONV_EXIT_PROCESS_STEP', NULL));
1947: FII_UTIL.debug_line('Process complete successfully');
1948:
1949: -- Commit changes to the database and print log messages
1950: FND_CONCURRENT.af_commit;
1951: -- Set the concurrent program completion status to COMPLETE

Line 1959: FII_UTIL.debug_line('Proces errors out because of other exception');

1955:
1956: EXCEPTION
1957: WHEN OTHERS THEN
1958: -- Process fails because of other exceptions and we need to rollback
1959: FII_UTIL.debug_line('Proces errors out because of other exception');
1960: -- Rollback
1961: FND_CONCURRENT.af_rollback;
1962: -- Print error messages to log file
1963: errbuf := sqlerrm;

Line 2003: FII_UTIL.initialize(p_log_filename || '_AR.log',

1999: BEGIN
2000: --
2001: -- 5.1 Initialize the logging for this child request
2002: --
2003: FII_UTIL.initialize(p_log_filename || '_AR.log',
2004: p_output_filename || '_AR.out',
2005: NULL, 'FII_RECONVERSION_PKG');
2006: FII_UTIL.put_line(' ');
2007: -- LOG: Function enter

Line 2006: FII_UTIL.put_line(' ');

2002: --
2003: FII_UTIL.initialize(p_log_filename || '_AR.log',
2004: p_output_filename || '_AR.out',
2005: NULL, 'FII_RECONVERSION_PKG');
2006: FII_UTIL.put_line(' ');
2007: -- LOG: Function enter
2008: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
2009: -- LOG: FII_RECONV_INIT_STEP || time stamp
2010: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));

Line 2010: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));

2006: FII_UTIL.put_line(' ');
2007: -- LOG: Function enter
2008: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
2009: -- LOG: FII_RECONV_INIT_STEP || time stamp
2010: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));
2011: -- LOG: State debug mode is on if it does
2012: FII_UTIL.debug_line('This process is running in debug mode');
2013: -- LOG: FII_RECONV_RECONVERT_AMT_STEP || time stamp for AR
2014: FII_UTIL.put_line(' ');

Line 2012: FII_UTIL.debug_line('This process is running in debug mode');

2008: FII_RECONVERSION_PKG.func_enter(l_procedure_name);
2009: -- LOG: FII_RECONV_INIT_STEP || time stamp
2010: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));
2011: -- LOG: State debug mode is on if it does
2012: FII_UTIL.debug_line('This process is running in debug mode');
2013: -- LOG: FII_RECONV_RECONVERT_AMT_STEP || time stamp for AR
2014: FII_UTIL.put_line(' ');
2015: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
2016: 'FII_RECONV_RECONVERT_AMT_STEP', NULL

Line 2014: FII_UTIL.put_line(' ');

2010: FII_UTIL.put_timestamp(FII_MESSAGE.get_message('FII_RECONV_INIT_STEP', NULL));
2011: -- LOG: State debug mode is on if it does
2012: FII_UTIL.debug_line('This process is running in debug mode');
2013: -- LOG: FII_RECONV_RECONVERT_AMT_STEP || time stamp for AR
2014: FII_UTIL.put_line(' ');
2015: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
2016: 'FII_RECONV_RECONVERT_AMT_STEP', NULL
2017: , 'PROD_NAME', p_product_name));
2018:

Line 2015: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(

2011: -- LOG: State debug mode is on if it does
2012: FII_UTIL.debug_line('This process is running in debug mode');
2013: -- LOG: FII_RECONV_RECONVERT_AMT_STEP || time stamp for AR
2014: FII_UTIL.put_line(' ');
2015: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
2016: 'FII_RECONV_RECONVERT_AMT_STEP', NULL
2017: , 'PROD_NAME', p_product_name));
2018:
2019: --

Line 2063: FII_UTIL.put_line(l_message);

2059: -- LOG: Print out the number of updated rows for AR
2060: l_message := FII_MESSAGE.get_message('FII_RECONV_UPDATED_ROWS', NULL,
2061: 'NUM_ROWS', NVL(l_processed_rows, 0),
2062: 'PROD_NAME', p_product_name);
2063: FII_UTIL.put_line(l_message);
2064:
2065: --
2066: -- 4.3 This process completes successfully
2067: --

Line 2070: FII_UTIL.put_line(' ');

2066: -- 4.3 This process completes successfully
2067: --
2068: l_process_step := 'EXIT_PROCESS';
2069: -- LOG: FII_RECONV_EXIT_PROCESS_STEP || time stamp
2070: FII_UTIL.put_line(' ');
2071: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
2072: 'FII_RECONV_EXIT_PROCESS_STEP', NULL));
2073: FII_UTIL.debug_line('Process complete successfully');
2074:

Line 2071: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(

2067: --
2068: l_process_step := 'EXIT_PROCESS';
2069: -- LOG: FII_RECONV_EXIT_PROCESS_STEP || time stamp
2070: FII_UTIL.put_line(' ');
2071: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
2072: 'FII_RECONV_EXIT_PROCESS_STEP', NULL));
2073: FII_UTIL.debug_line('Process complete successfully');
2074:
2075: -- Commit changes to the database and print log messages

Line 2073: FII_UTIL.debug_line('Process complete successfully');

2069: -- LOG: FII_RECONV_EXIT_PROCESS_STEP || time stamp
2070: FII_UTIL.put_line(' ');
2071: FII_UTIL.put_timestamp(FII_MESSAGE.get_message(
2072: 'FII_RECONV_EXIT_PROCESS_STEP', NULL));
2073: FII_UTIL.debug_line('Process complete successfully');
2074:
2075: -- Commit changes to the database and print log messages
2076: FND_CONCURRENT.af_commit;
2077: -- Set the concurrent program completion status to COMPLETE

Line 2085: FII_UTIL.debug_line('Proces errors out because of other exception');

2081:
2082: EXCEPTION
2083: WHEN OTHERS THEN
2084: -- Process fails because of other exceptions and we need to rollback
2085: FII_UTIL.debug_line('Proces errors out because of other exception');
2086: -- Rollback
2087: FND_CONCURRENT.af_rollback;
2088: -- Print error messages to log file
2089: errbuf := sqlerrm;

Line 2476: FII_UTIL.debug_line(' ');

2472:
2473: l_process_step VARCHAR2(50) := 'PRINT_BUILT_SQL';
2474: l_procedure_name VARCHAR2(30) := 'print_sql';
2475: BEGIN
2476: FII_UTIL.debug_line(' ');
2477: FII_UTIL.debug_line(p_sql_desc);
2478: FOR i IN 1..p_num_of_lines
2479: LOOP
2480: FII_UTIL.debug_line(p_sql_stmt(i));

Line 2477: FII_UTIL.debug_line(p_sql_desc);

2473: l_process_step VARCHAR2(50) := 'PRINT_BUILT_SQL';
2474: l_procedure_name VARCHAR2(30) := 'print_sql';
2475: BEGIN
2476: FII_UTIL.debug_line(' ');
2477: FII_UTIL.debug_line(p_sql_desc);
2478: FOR i IN 1..p_num_of_lines
2479: LOOP
2480: FII_UTIL.debug_line(p_sql_stmt(i));
2481: END LOOP;

Line 2480: FII_UTIL.debug_line(p_sql_stmt(i));

2476: FII_UTIL.debug_line(' ');
2477: FII_UTIL.debug_line(p_sql_desc);
2478: FOR i IN 1..p_num_of_lines
2479: LOOP
2480: FII_UTIL.debug_line(p_sql_stmt(i));
2481: END LOOP;
2482: FII_UTIL.debug_line(' ');
2483: EXCEPTION
2484: WHEN OTHERS THEN

Line 2482: FII_UTIL.debug_line(' ');

2478: FOR i IN 1..p_num_of_lines
2479: LOOP
2480: FII_UTIL.debug_line(p_sql_stmt(i));
2481: END LOOP;
2482: FII_UTIL.debug_line(' ');
2483: EXCEPTION
2484: WHEN OTHERS THEN
2485: -- Print error code and messages to log file and raise error
2486: FII_RECONVERSION_PKG.func_fail(l_procedure_name, l_process_step, sqlerrm);

Line 2500: FII_UTIL.put_line(' ');

2496: -- It will print some customerized output to log and then call
2497: -- FII_MESSAGE.func_enter() to print standard output for entering function
2498: PROCEDURE func_enter(p_func_name IN VARCHAR2) IS
2499: BEGIN
2500: FII_UTIL.put_line(' ');
2501: FII_MESSAGE.func_ent(p_func_name);
2502: END func_enter;
2503:
2504:

Line 2515: FII_UTIL.put_line(' ');

2511: -- successfully
2512: PROCEDURE func_succ(p_func_name IN VARCHAR2) IS
2513: BEGIN
2514: FII_MESSAGE.func_succ(p_func_name);
2515: FII_UTIL.put_line(' ');
2516: END func_succ;
2517:
2518:
2519: -- PROCEDURE

Line 2531: FII_UTIL.debug_line(' ');

2527: , p_debug_step IN VARCHAR2
2528: , p_err_msg IN VARCHAR2) IS
2529: BEGIN
2530: -- Print the debug step when it's in debug mode
2531: FII_UTIL.debug_line(' ');
2532: FII_UTIL.debug_line('Raise error while ' || p_debug_step);
2533:
2534: -- Print the error message
2535: FII_UTIL.put_line(' ');

Line 2532: FII_UTIL.debug_line('Raise error while ' || p_debug_step);

2528: , p_err_msg IN VARCHAR2) IS
2529: BEGIN
2530: -- Print the debug step when it's in debug mode
2531: FII_UTIL.debug_line(' ');
2532: FII_UTIL.debug_line('Raise error while ' || p_debug_step);
2533:
2534: -- Print the error message
2535: FII_UTIL.put_line(' ');
2536: FII_UTIL.put_line(FII_MESSAGE.get_message(

Line 2535: FII_UTIL.put_line(' ');

2531: FII_UTIL.debug_line(' ');
2532: FII_UTIL.debug_line('Raise error while ' || p_debug_step);
2533:
2534: -- Print the error message
2535: FII_UTIL.put_line(' ');
2536: FII_UTIL.put_line(FII_MESSAGE.get_message(
2537: 'FII_ERR_ENC_ROUT', NULL
2538: , 'ROUTINE_NAME', p_func_name || '()'));
2539: IF (p_err_msg IS NOT NULL)

Line 2536: FII_UTIL.put_line(FII_MESSAGE.get_message(

2532: FII_UTIL.debug_line('Raise error while ' || p_debug_step);
2533:
2534: -- Print the error message
2535: FII_UTIL.put_line(' ');
2536: FII_UTIL.put_line(FII_MESSAGE.get_message(
2537: 'FII_ERR_ENC_ROUT', NULL
2538: , 'ROUTINE_NAME', p_func_name || '()'));
2539: IF (p_err_msg IS NOT NULL)
2540: THEN

Line 2541: FII_UTIL.put_line(p_err_msg);

2537: 'FII_ERR_ENC_ROUT', NULL
2538: , 'ROUTINE_NAME', p_func_name || '()'));
2539: IF (p_err_msg IS NOT NULL)
2540: THEN
2541: FII_UTIL.put_line(p_err_msg);
2542: END IF;
2543: FII_UTIL.put_line(' ');
2544:
2545: -- Print the standard output

Line 2543: FII_UTIL.put_line(' ');

2539: IF (p_err_msg IS NOT NULL)
2540: THEN
2541: FII_UTIL.put_line(p_err_msg);
2542: END IF;
2543: FII_UTIL.put_line(' ');
2544:
2545: -- Print the standard output
2546: FII_MESSAGE.func_fail(p_func_name);
2547: FII_UTIL.put_line(' ');

Line 2547: FII_UTIL.put_line(' ');

2543: FII_UTIL.put_line(' ');
2544:
2545: -- Print the standard output
2546: FII_MESSAGE.func_fail(p_func_name);
2547: FII_UTIL.put_line(' ');
2548: END func_fail;
2549:
2550: END FII_RECONVERSION_PKG;