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.OKL_SUBSIDY_POOL_RPT_PVT dependencies on FND_MESSAGE

Line 370: fnd_message.set_name(G_APP_NAME,

366: each_row.effective_from_date,
367: l_conv_rate
368: );
369: IF (l_amount < 0) THEN
370: fnd_message.set_name(G_APP_NAME,
371: 'OKL_POOL_CURR_CONV');
372: fnd_message.set_token('FROM_CURR',
373: p_from_currency_code);
374: fnd_message.set_token('TO_CURR',

Line 372: fnd_message.set_token('FROM_CURR',

368: );
369: IF (l_amount < 0) THEN
370: fnd_message.set_name(G_APP_NAME,
371: 'OKL_POOL_CURR_CONV');
372: fnd_message.set_token('FROM_CURR',
373: p_from_currency_code);
374: fnd_message.set_token('TO_CURR',
375: p_to_currency_code);
376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

Line 374: fnd_message.set_token('TO_CURR',

370: fnd_message.set_name(G_APP_NAME,
371: 'OKL_POOL_CURR_CONV');
372: fnd_message.set_token('FROM_CURR',
373: p_from_currency_code);
374: fnd_message.set_token('TO_CURR',
375: p_to_currency_code);
376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
377: END IF;
378:

Line 376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

372: fnd_message.set_token('FROM_CURR',
373: p_from_currency_code);
374: fnd_message.set_token('TO_CURR',
375: p_to_currency_code);
376: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
377: END IF;
378:
379: IF (each_row.budget_type_code = 'ADDITION' AND each_row.decision_status_code = 'ACTIVE') THEN
380: l_total_budget := l_total_budget + l_amount;

Line 553: fnd_message.set_name(G_APP_NAME,

549: each_row.trx_date,
550: l_conv_rate
551: );
552: IF (l_amount < 0) THEN
553: fnd_message.set_name(G_APP_NAME,
554: 'OKL_POOL_CURR_CONV');
555: fnd_message.set_token('FROM_CURR',
556: p_from_currency_code);
557: fnd_message.set_token('TO_CURR',

Line 555: fnd_message.set_token('FROM_CURR',

551: );
552: IF (l_amount < 0) THEN
553: fnd_message.set_name(G_APP_NAME,
554: 'OKL_POOL_CURR_CONV');
555: fnd_message.set_token('FROM_CURR',
556: p_from_currency_code);
557: fnd_message.set_token('TO_CURR',
558: p_to_currency_code);
559: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

Line 557: fnd_message.set_token('TO_CURR',

553: fnd_message.set_name(G_APP_NAME,
554: 'OKL_POOL_CURR_CONV');
555: fnd_message.set_token('FROM_CURR',
556: p_from_currency_code);
557: fnd_message.set_token('TO_CURR',
558: p_to_currency_code);
559: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
560: END IF;
561: IF (each_row.trx_type_code = 'ADDITION') THEN

Line 559: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

555: fnd_message.set_token('FROM_CURR',
556: p_from_currency_code);
557: fnd_message.set_token('TO_CURR',
558: p_to_currency_code);
559: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
560: END IF;
561: IF (each_row.trx_type_code = 'ADDITION') THEN
562: l_trx_amount := l_trx_amount - l_amount;
563: ELSIF(each_row.trx_type_code = 'REDUCTION') THEN

Line 771: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_PARENT_POOL') || ' : '

767:
768: -- Parent pool header with the parent pool name.
769: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
770: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
771: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_PARENT_POOL') || ' : '
772: || fnd_message.get_string('OKL',p_pool_rec.subsidy_pool_name));
773: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 30 , '-' ));
774: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
775: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

Line 772: || fnd_message.get_string('OKL',p_pool_rec.subsidy_pool_name));

768: -- Parent pool header with the parent pool name.
769: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
770: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
771: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_PARENT_POOL') || ' : '
772: || fnd_message.get_string('OKL',p_pool_rec.subsidy_pool_name));
773: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 30 , '-' ));
774: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
775: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
776: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||

Line 776: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||

772: || fnd_message.get_string('OKL',p_pool_rec.subsidy_pool_name));
773: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 30 , '-' ));
774: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
775: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
776: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
777: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
778: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
779: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||
780: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||

Line 777: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||

773: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 30 , '-' ));
774: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
775: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
776: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
777: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
778: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
779: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||
780: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
781: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_Balance_len,'TITLE'));

Line 778: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||

774: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
775: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
776: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
777: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
778: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
779: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||
780: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
781: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_Balance_len,'TITLE'));
782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));

Line 779: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||

775: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
776: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
777: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
778: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
779: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||
780: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
781: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_Balance_len,'TITLE'));
782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));
783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 780: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||

776: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
777: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
778: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
779: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||
780: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
781: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_Balance_len,'TITLE'));
782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));
783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
784: -- Convert the reporting pool limit amount from pool currency to the parent pool(user entered) currency.

Line 781: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_Balance_len,'TITLE'));

777: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
778: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
779: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||
780: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
781: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_Balance_len,'TITLE'));
782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));
783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
784: -- Convert the reporting pool limit amount from pool currency to the parent pool(user entered) currency.
785: l_reporting_limit := currency_conversion(p_pool_rec.reporting_pool_limit,

Line 793: fnd_message.set_name( G_APP_NAME,

789: p_pool_rec.effective_from_date,
790: l_conv_rate
791: );
792: IF (l_reporting_limit < 0) THEN
793: fnd_message.set_name( G_APP_NAME,
794: 'OKL_POOL_CURR_CONV');
795: fnd_message.set_token('FROM_CURR',
796: p_pool_rec.currency_code);
797: fnd_message.set_token('TO_CURR',

Line 795: fnd_message.set_token('FROM_CURR',

791: );
792: IF (l_reporting_limit < 0) THEN
793: fnd_message.set_name( G_APP_NAME,
794: 'OKL_POOL_CURR_CONV');
795: fnd_message.set_token('FROM_CURR',
796: p_pool_rec.currency_code);
797: fnd_message.set_token('TO_CURR',
798: p_to_currency_code);
799: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

Line 797: fnd_message.set_token('TO_CURR',

793: fnd_message.set_name( G_APP_NAME,
794: 'OKL_POOL_CURR_CONV');
795: fnd_message.set_token('FROM_CURR',
796: p_pool_rec.currency_code);
797: fnd_message.set_token('TO_CURR',
798: p_to_currency_code);
799: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
800: END IF;
801: -- If subsidy pool is of type reporting then, calculate the total budgets and remaining balance for that pool,

Line 799: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

795: fnd_message.set_token('FROM_CURR',
796: p_pool_rec.currency_code);
797: fnd_message.set_token('TO_CURR',
798: p_to_currency_code);
799: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
800: END IF;
801: -- If subsidy pool is of type reporting then, calculate the total budgets and remaining balance for that pool,
802: -- from all its children which are of type budget.
803: IF(p_pool_rec.pool_type_code = 'REPORTING') THEN

Line 1091: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CHILDREN_POOL'));

1087: END IF;
1088:
1089: -- Print child header.
1090: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1091: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CHILDREN_POOL'));
1092: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 30 , '-' ));
1093: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
1094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1095: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||

Line 1095: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||

1091: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_CHILDREN_POOL'));
1092: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 30 , '-' ));
1093: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
1094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1095: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
1096: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
1097: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
1098: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||
1099: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||

Line 1096: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||

1092: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 30 , '-' ));
1093: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
1094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1095: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
1096: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
1097: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
1098: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||
1099: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
1100: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_Balance_len,'TITLE'));

Line 1097: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||

1093: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
1094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1095: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
1096: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
1097: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
1098: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||
1099: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
1100: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_Balance_len,'TITLE'));
1101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));

Line 1098: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||

1094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1095: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
1096: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
1097: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
1098: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||
1099: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
1100: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_Balance_len,'TITLE'));
1101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));
1102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 1099: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||

1095: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
1096: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
1097: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
1098: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||
1099: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
1100: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_Balance_len,'TITLE'));
1101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));
1102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1103:

Line 1100: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_Balance_len,'TITLE'));

1096: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
1097: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
1098: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||
1099: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
1100: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_Balance_len,'TITLE'));
1101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));
1102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1103:
1104: -- For all the records in a table, print the records.

Line 1186: fnd_message.set_name( G_APP_NAME,

1182: p_pool_tbl(i).effective_from_date,
1183: l_conv_rate
1184: );
1185: IF (l_reporting_limit < 0) THEN
1186: fnd_message.set_name( G_APP_NAME,
1187: 'OKL_POOL_CURR_CONV');
1188: fnd_message.set_token('FROM_CURR',
1189: p_pool_tbl(i).currency_code);
1190: fnd_message.set_token('TO_CURR',

Line 1188: fnd_message.set_token('FROM_CURR',

1184: );
1185: IF (l_reporting_limit < 0) THEN
1186: fnd_message.set_name( G_APP_NAME,
1187: 'OKL_POOL_CURR_CONV');
1188: fnd_message.set_token('FROM_CURR',
1189: p_pool_tbl(i).currency_code);
1190: fnd_message.set_token('TO_CURR',
1191: p_to_currency_code);
1192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

Line 1190: fnd_message.set_token('TO_CURR',

1186: fnd_message.set_name( G_APP_NAME,
1187: 'OKL_POOL_CURR_CONV');
1188: fnd_message.set_token('FROM_CURR',
1189: p_pool_tbl(i).currency_code);
1190: fnd_message.set_token('TO_CURR',
1191: p_to_currency_code);
1192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1193: END IF;
1194:

Line 1192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

1188: fnd_message.set_token('FROM_CURR',
1189: p_pool_tbl(i).currency_code);
1190: fnd_message.set_token('TO_CURR',
1191: p_to_currency_code);
1192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1193: END IF;
1194:
1195: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1196: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

Line 1349: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||

1345:
1346: l_from_date:= FND_DATE.CANONICAL_TO_DATE(p_date);
1347:
1348: -- Printing Subsidy pools report header.
1349: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||
1350: RPAD(' ', 53 , ' ' ));
1351: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_REPORT') ||

Line 1353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_REPORT') ||

1349: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||
1350: RPAD(' ', 53 , ' ' ));
1351: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1352: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1353: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_REPORT') ||
1354: RPAD(' ', 53 , ' ' ));
1355: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || '-------------------------------' || RPAD(' ', 51, ' ' ));
1356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));

Line 1610: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||

1606: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1607: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
1609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1610: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
1611: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
1612: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
1613: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
1614: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len,'TITLE')||' '||

Line 1611: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||

1607: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
1609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1610: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
1611: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
1612: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
1613: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
1614: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len,'TITLE')||' '||
1615: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_Balance_len,'TITLE'));

Line 1612: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||

1608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
1609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1610: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
1611: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
1612: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
1613: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
1614: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len,'TITLE')||' '||
1615: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_Balance_len,'TITLE'));
1616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));

Line 1613: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||

1609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1610: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
1611: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
1612: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
1613: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
1614: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len,'TITLE')||' '||
1615: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_Balance_len,'TITLE'));
1616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));
1617: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 1614: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len,'TITLE')||' '||

1610: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
1611: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
1612: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
1613: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
1614: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len,'TITLE')||' '||
1615: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_Balance_len,'TITLE'));
1616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));
1617: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1618: -- Calculate the total budgets for subsidy pool till the date specified.

Line 1615: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_Balance_len,'TITLE'));

1611: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
1612: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
1613: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
1614: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len,'TITLE')||' '||
1615: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_Balance_len,'TITLE'));
1616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));
1617: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1618: -- Calculate the total budgets for subsidy pool till the date specified.
1619: l_budget := total_budgets( p_pool_rec.id,

Line 1677: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||

1673: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1675: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
1676: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1677: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
1678: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
1679: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
1680: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||
1681: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len,'TITLE'));

Line 1678: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||

1674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1675: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
1676: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1677: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
1678: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
1679: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
1680: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||
1681: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len,'TITLE'));
1682: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));

Line 1679: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||

1675: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
1676: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1677: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
1678: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
1679: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
1680: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||
1681: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len,'TITLE'));
1682: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));
1683: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

Line 1680: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||

1676: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1677: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
1678: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
1679: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
1680: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||
1681: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len,'TITLE'));
1682: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));
1683: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1684:

Line 1681: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len,'TITLE'));

1677: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
1678: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_TYPE_TXT'),l_Pool_Type_len,'TITLE')||' '||
1679: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
1680: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_LIMIT'),l_Pool_Limit_len,'TITLE')||' '||
1681: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len,'TITLE'));
1682: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));
1683: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1684:
1685: -- For each of the children found for "Reporting" pool type

Line 1933: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_TRANSACTION'));

1929: RAISE OKL_API.G_EXCEPTION_ERROR;
1930: END IF;
1931: -- Print the transaction header.
1932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1933: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_TRANSACTION'));
1934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 30 , '-' ));
1935: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length , '-' ));
1936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1937: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SOURCE'),l_trx_reason_len,'TITLE')||' '||

Line 1937: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SOURCE'),l_trx_reason_len,'TITLE')||' '||

1933: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_TRANSACTION'));
1934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 30 , '-' ));
1935: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length , '-' ));
1936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1937: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SOURCE'),l_trx_reason_len,'TITLE')||' '||
1938: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_NUMBER'),l_source_len,'TITLE')||' '||
1939: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_ASSET_NUMBER'),l_asset_len,'TITLE')||' '||
1940: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_VENDOR'),l_vendor_len,'TITLE')||' '||
1941: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY'),l_subsidy_len,'TITLE')||' '||

Line 1938: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_NUMBER'),l_source_len,'TITLE')||' '||

1934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 30 , '-' ));
1935: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length , '-' ));
1936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1937: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SOURCE'),l_trx_reason_len,'TITLE')||' '||
1938: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_NUMBER'),l_source_len,'TITLE')||' '||
1939: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_ASSET_NUMBER'),l_asset_len,'TITLE')||' '||
1940: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_VENDOR'),l_vendor_len,'TITLE')||' '||
1941: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY'),l_subsidy_len,'TITLE')||' '||
1942: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_EXPT_DATE'),l_src_trx_date_len,'TITLE')||' '||

Line 1939: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_ASSET_NUMBER'),l_asset_len,'TITLE')||' '||

1935: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length , '-' ));
1936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1937: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SOURCE'),l_trx_reason_len,'TITLE')||' '||
1938: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_NUMBER'),l_source_len,'TITLE')||' '||
1939: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_ASSET_NUMBER'),l_asset_len,'TITLE')||' '||
1940: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_VENDOR'),l_vendor_len,'TITLE')||' '||
1941: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY'),l_subsidy_len,'TITLE')||' '||
1942: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_EXPT_DATE'),l_src_trx_date_len,'TITLE')||' '||
1943: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len + l_curr_len,'TITLE')||' '||

Line 1940: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_VENDOR'),l_vendor_len,'TITLE')||' '||

1936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1937: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SOURCE'),l_trx_reason_len,'TITLE')||' '||
1938: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_NUMBER'),l_source_len,'TITLE')||' '||
1939: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_ASSET_NUMBER'),l_asset_len,'TITLE')||' '||
1940: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_VENDOR'),l_vendor_len,'TITLE')||' '||
1941: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY'),l_subsidy_len,'TITLE')||' '||
1942: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_EXPT_DATE'),l_src_trx_date_len,'TITLE')||' '||
1943: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len + l_curr_len,'TITLE')||' '||
1944: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_CURR_CONV_FACT'),l_conv_rate_len,'TITLE')||' '||

Line 1941: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY'),l_subsidy_len,'TITLE')||' '||

1937: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SOURCE'),l_trx_reason_len,'TITLE')||' '||
1938: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_NUMBER'),l_source_len,'TITLE')||' '||
1939: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_ASSET_NUMBER'),l_asset_len,'TITLE')||' '||
1940: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_VENDOR'),l_vendor_len,'TITLE')||' '||
1941: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY'),l_subsidy_len,'TITLE')||' '||
1942: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_EXPT_DATE'),l_src_trx_date_len,'TITLE')||' '||
1943: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len + l_curr_len,'TITLE')||' '||
1944: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_CURR_CONV_FACT'),l_conv_rate_len,'TITLE')||' '||
1945: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_RPT_AMOUNT'),l_pool_amt_len + l_curr_len,'TITLE')||' '||

Line 1942: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_EXPT_DATE'),l_src_trx_date_len,'TITLE')||' '||

1938: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_NUMBER'),l_source_len,'TITLE')||' '||
1939: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_ASSET_NUMBER'),l_asset_len,'TITLE')||' '||
1940: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_VENDOR'),l_vendor_len,'TITLE')||' '||
1941: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY'),l_subsidy_len,'TITLE')||' '||
1942: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_EXPT_DATE'),l_src_trx_date_len,'TITLE')||' '||
1943: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len + l_curr_len,'TITLE')||' '||
1944: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_CURR_CONV_FACT'),l_conv_rate_len,'TITLE')||' '||
1945: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_RPT_AMOUNT'),l_pool_amt_len + l_curr_len,'TITLE')||' '||
1946: -- abindal start bug# 4873705 --

Line 1943: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len + l_curr_len,'TITLE')||' '||

1939: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_ASSET_NUMBER'),l_asset_len,'TITLE')||' '||
1940: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_VENDOR'),l_vendor_len,'TITLE')||' '||
1941: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY'),l_subsidy_len,'TITLE')||' '||
1942: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_EXPT_DATE'),l_src_trx_date_len,'TITLE')||' '||
1943: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len + l_curr_len,'TITLE')||' '||
1944: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_CURR_CONV_FACT'),l_conv_rate_len,'TITLE')||' '||
1945: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_RPT_AMOUNT'),l_pool_amt_len + l_curr_len,'TITLE')||' '||
1946: -- abindal start bug# 4873705 --
1947: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_OPERATING_UNIT'),l_oper_unit_len,'TITLE'));

Line 1944: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_CURR_CONV_FACT'),l_conv_rate_len,'TITLE')||' '||

1940: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_VENDOR'),l_vendor_len,'TITLE')||' '||
1941: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY'),l_subsidy_len,'TITLE')||' '||
1942: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_EXPT_DATE'),l_src_trx_date_len,'TITLE')||' '||
1943: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len + l_curr_len,'TITLE')||' '||
1944: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_CURR_CONV_FACT'),l_conv_rate_len,'TITLE')||' '||
1945: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_RPT_AMOUNT'),l_pool_amt_len + l_curr_len,'TITLE')||' '||
1946: -- abindal start bug# 4873705 --
1947: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_OPERATING_UNIT'),l_oper_unit_len,'TITLE'));
1948: -- abindal end bug# 4873705 --

Line 1945: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_RPT_AMOUNT'),l_pool_amt_len + l_curr_len,'TITLE')||' '||

1941: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY'),l_subsidy_len,'TITLE')||' '||
1942: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_EXPT_DATE'),l_src_trx_date_len,'TITLE')||' '||
1943: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len + l_curr_len,'TITLE')||' '||
1944: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_CURR_CONV_FACT'),l_conv_rate_len,'TITLE')||' '||
1945: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_RPT_AMOUNT'),l_pool_amt_len + l_curr_len,'TITLE')||' '||
1946: -- abindal start bug# 4873705 --
1947: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_OPERATING_UNIT'),l_oper_unit_len,'TITLE'));
1948: -- abindal end bug# 4873705 --
1949: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length , '=' ));

Line 1947: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_OPERATING_UNIT'),l_oper_unit_len,'TITLE'));

1943: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TRX_AMOUNT'),l_trx_amt_len + l_curr_len,'TITLE')||' '||
1944: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_CURR_CONV_FACT'),l_conv_rate_len,'TITLE')||' '||
1945: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_RPT_AMOUNT'),l_pool_amt_len + l_curr_len,'TITLE')||' '||
1946: -- abindal start bug# 4873705 --
1947: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_OPERATING_UNIT'),l_oper_unit_len,'TITLE'));
1948: -- abindal end bug# 4873705 --
1949: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length , '=' ));
1950: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1951:

Line 1993: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TOTAL_AMOUNT'),l_total_amt_len,'TITLE')||' : '||

1989: -- is displayed.
1990: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length , '-' ));
1991: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
1992: RPAD(' ', l_tot_bdgt_len , ' ' )||
1993: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TOTAL_AMOUNT'),l_total_amt_len,'TITLE')||' : '||
1994: LPAD(okl_accounting_util.format_amount(l_pool_amount,p_pool_currency),l_pool_amt_len,' ')||' '||
1995: GET_PROPER_LENGTH(p_pool_currency,l_curr_len,'DATA'));
1996: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length , '-' ));
1997:

Line 2013: fnd_message.set_name( G_APP_NAME,

2009: );
2010: -- if negative value is returned display the error that the conversion between
2011: -- the two currencies is not found.
2012: IF (l_amount < 0) THEN
2013: fnd_message.set_name( G_APP_NAME,
2014: 'OKL_POOL_CURR_CONV');
2015: fnd_message.set_token('FROM_CURR',
2016: each_row.subsidy_pool_currency_code);
2017: fnd_message.set_token('TO_CURR',

Line 2015: fnd_message.set_token('FROM_CURR',

2011: -- the two currencies is not found.
2012: IF (l_amount < 0) THEN
2013: fnd_message.set_name( G_APP_NAME,
2014: 'OKL_POOL_CURR_CONV');
2015: fnd_message.set_token('FROM_CURR',
2016: each_row.subsidy_pool_currency_code);
2017: fnd_message.set_token('TO_CURR',
2018: p_pool_currency);
2019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

Line 2017: fnd_message.set_token('TO_CURR',

2013: fnd_message.set_name( G_APP_NAME,
2014: 'OKL_POOL_CURR_CONV');
2015: fnd_message.set_token('FROM_CURR',
2016: each_row.subsidy_pool_currency_code);
2017: fnd_message.set_token('TO_CURR',
2018: p_pool_currency);
2019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
2020: END IF;
2021: -- If transaction line type is "Reduction" display the transaction amount as

Line 2019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

2015: fnd_message.set_token('FROM_CURR',
2016: each_row.subsidy_pool_currency_code);
2017: fnd_message.set_token('TO_CURR',
2018: p_pool_currency);
2019: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
2020: END IF;
2021: -- If transaction line type is "Reduction" display the transaction amount as
2022: -- .
2023: IF(each_row.trx_type_code = 'ADDITION') THEN

Line 2059: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TOTAL_AMOUNT'),l_total_amt_len,'TITLE')||' : '||

2055: -- Print the total subsidy amount at the end of all the transactions record.
2056: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length , '-' ));
2057: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
2058: RPAD(' ', l_tot_bdgt_len , ' ' )||
2059: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_TOTAL_AMOUNT'),l_total_amt_len,'TITLE')||' : '||
2060: LPAD(okl_accounting_util.format_amount(l_pool_amount,p_pool_currency),l_pool_amt_len,' ')||' '||
2061: GET_PROPER_LENGTH(p_pool_currency,l_curr_len,'DATA'));
2062: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length , '-' ));
2063: END IF;

Line 2186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||

2182: l_from_date:= FND_DATE.CANONICAL_TO_DATE(p_from_date);
2183: l_to_date:= FND_DATE.CANONICAL_TO_DATE(p_to_date);
2184:
2185: -- Printing Subsidy pools report header.
2186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||
2187: RPAD(' ', 53 , ' ' ));
2188: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
2189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
2190: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_REPORT') ||

Line 2190: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_REPORT') ||

2186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||
2187: RPAD(' ', 53 , ' ' ));
2188: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
2189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
2190: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_REPORT') ||
2191: RPAD(' ', 53 , ' ' ));
2192: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || '-------------------------------' || RPAD(' ', 51, ' ' ));
2193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
2194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));

Line 2201: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME') || ' : '

2197: -- Get the record for user entered pool name.
2198: l_pool_rec := get_parent_record(p_pool_id);
2199: -- Prints the user entered parameters.
2200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 100 , '-' ));
2201: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME') || ' : '
2202: || l_pool_rec.subsidy_pool_name);
2203: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_FROM_DATE') || ' : ' || l_from_date);
2204: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_TO_DATE') || ' : ' || l_to_date);
2205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 100 , '-' ));

Line 2203: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_FROM_DATE') || ' : ' || l_from_date);

2199: -- Prints the user entered parameters.
2200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 100 , '-' ));
2201: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME') || ' : '
2202: || l_pool_rec.subsidy_pool_name);
2203: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_FROM_DATE') || ' : ' || l_from_date);
2204: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_TO_DATE') || ' : ' || l_to_date);
2205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 100 , '-' ));
2206:
2207: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN

Line 2204: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_TO_DATE') || ' : ' || l_to_date);

2200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 100 , '-' ));
2201: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME') || ' : '
2202: || l_pool_rec.subsidy_pool_name);
2203: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_FROM_DATE') || ' : ' || l_from_date);
2204: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_TO_DATE') || ' : ' || l_to_date);
2205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', 100 , '-' ));
2206:
2207: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
2208: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

Line 2470: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||

2466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
2467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
2468: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
2469: FND_FILE.PUT(FND_FILE.OUTPUT,
2470: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
2471: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
2472: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
2473: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_len,'TITLE')||' '||
2474: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_PERCENT_BUDGET'),l_percent_len,'TITLE')||' '||

Line 2471: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||

2467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
2468: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
2469: FND_FILE.PUT(FND_FILE.OUTPUT,
2470: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
2471: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
2472: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
2473: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_len,'TITLE')||' '||
2474: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_PERCENT_BUDGET'),l_percent_len,'TITLE')||' '||
2475: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_END_TERM'),l_effective_to_len,'TITLE'));

Line 2472: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||

2468: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
2469: FND_FILE.PUT(FND_FILE.OUTPUT,
2470: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
2471: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
2472: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
2473: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_len,'TITLE')||' '||
2474: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_PERCENT_BUDGET'),l_percent_len,'TITLE')||' '||
2475: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_END_TERM'),l_effective_to_len,'TITLE'));
2476: IF(p_days is not null) THEN

Line 2473: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_len,'TITLE')||' '||

2469: FND_FILE.PUT(FND_FILE.OUTPUT,
2470: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
2471: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
2472: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
2473: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_len,'TITLE')||' '||
2474: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_PERCENT_BUDGET'),l_percent_len,'TITLE')||' '||
2475: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_END_TERM'),l_effective_to_len,'TITLE'));
2476: IF(p_days is not null) THEN
2477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

Line 2474: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_PERCENT_BUDGET'),l_percent_len,'TITLE')||' '||

2470: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_NAME'),l_Pool_Name_len,'TITLE')||' '||
2471: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
2472: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
2473: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_len,'TITLE')||' '||
2474: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_PERCENT_BUDGET'),l_percent_len,'TITLE')||' '||
2475: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_END_TERM'),l_effective_to_len,'TITLE'));
2476: IF(p_days is not null) THEN
2477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
2478: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_REMAINING_DAYS'),l_remaining_days_len,'TITLE'));

Line 2475: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_END_TERM'),l_effective_to_len,'TITLE'));

2471: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_AGN_RPT_CURRENCY'),l_Currency_Code_len,'TITLE')||' '||
2472: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BUDGET'),l_Budget_len,'TITLE')||' '||
2473: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_POOL_BALANCE'),l_Remaining_len,'TITLE')||' '||
2474: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_PERCENT_BUDGET'),l_percent_len,'TITLE')||' '||
2475: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_END_TERM'),l_effective_to_len,'TITLE'));
2476: IF(p_days is not null) THEN
2477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
2478: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_REMAINING_DAYS'),l_remaining_days_len,'TITLE'));
2479: END IF;

Line 2478: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_REMAINING_DAYS'),l_remaining_days_len,'TITLE'));

2474: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_PERCENT_BUDGET'),l_percent_len,'TITLE')||' '||
2475: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_END_TERM'),l_effective_to_len,'TITLE'));
2476: IF(p_days is not null) THEN
2477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
2478: GET_PROPER_LENGTH(fnd_message.get_string('OKL','OKL_REMAINING_DAYS'),l_remaining_days_len,'TITLE'));
2479: END IF;
2480: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=', l_total_length+8 , '=' ));
2481: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2482:

Line 2734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||

2730:
2731: l_date:= FND_DATE.CANONICAL_TO_DATE(p_end_date);
2732:
2733: -- Printing Subsidy pools report header.
2734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||
2735: RPAD(' ', 53 , ' ' ));
2736: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
2737: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
2738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_REPORT') ||

Line 2738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_REPORT') ||

2734: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||
2735: RPAD(' ', 53 , ' ' ));
2736: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
2737: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
2738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKL_SUBSIDY_POOL_REPORT') ||
2739: RPAD(' ', 53 , ' ' ));
2740: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || '-------------------------------' || RPAD(' ', 51, ' ' ));
2741: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
2742: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));

Line 2749: fnd_message.set_name( G_APP_NAME,

2745: -- If p_remaining is entered and p_currency is not entered or vice versa
2746: -- then throw an error, if any one of these parameter is entered then other
2747: -- one is mandatory parameter.
2748: IF ( p_remaining is not null AND p_currency is null) THEN
2749: fnd_message.set_name( G_APP_NAME,
2750: 'OKL_SUBPOOL_CURR_REQ');
2751: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
2752: ELSIF ( p_remaining is null AND p_currency is not null) THEN
2753: fnd_message.set_name( G_APP_NAME,

Line 2751: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

2747: -- one is mandatory parameter.
2748: IF ( p_remaining is not null AND p_currency is null) THEN
2749: fnd_message.set_name( G_APP_NAME,
2750: 'OKL_SUBPOOL_CURR_REQ');
2751: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
2752: ELSIF ( p_remaining is null AND p_currency is not null) THEN
2753: fnd_message.set_name( G_APP_NAME,
2754: 'OKL_SUBPOOL_REM_BDGT');
2755: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

Line 2753: fnd_message.set_name( G_APP_NAME,

2749: fnd_message.set_name( G_APP_NAME,
2750: 'OKL_SUBPOOL_CURR_REQ');
2751: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
2752: ELSIF ( p_remaining is null AND p_currency is not null) THEN
2753: fnd_message.set_name( G_APP_NAME,
2754: 'OKL_SUBPOOL_REM_BDGT');
2755: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
2756: ELSIF (p_percent is not null AND p_percent > 100)THEN
2757: fnd_message.set_name( G_APP_NAME,

Line 2755: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

2751: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
2752: ELSIF ( p_remaining is null AND p_currency is not null) THEN
2753: fnd_message.set_name( G_APP_NAME,
2754: 'OKL_SUBPOOL_REM_BDGT');
2755: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
2756: ELSIF (p_percent is not null AND p_percent > 100)THEN
2757: fnd_message.set_name( G_APP_NAME,
2758: 'OKL_LLA_PERCENT');
2759: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

Line 2757: fnd_message.set_name( G_APP_NAME,

2753: fnd_message.set_name( G_APP_NAME,
2754: 'OKL_SUBPOOL_REM_BDGT');
2755: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
2756: ELSIF (p_percent is not null AND p_percent > 100)THEN
2757: fnd_message.set_name( G_APP_NAME,
2758: 'OKL_LLA_PERCENT');
2759: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
2760: -- if more than one parameters is entered, considering p_remaining and p_currency
2761: -- as a single parameter, or no parameter is entered then throw an error.

Line 2759: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

2755: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
2756: ELSIF (p_percent is not null AND p_percent > 100)THEN
2757: fnd_message.set_name( G_APP_NAME,
2758: 'OKL_LLA_PERCENT');
2759: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
2760: -- if more than one parameters is entered, considering p_remaining and p_currency
2761: -- as a single parameter, or no parameter is entered then throw an error.
2762: -- At least one of the parameter is mandatory.
2763: ELSIF( (p_percent is not null AND p_remaining is not null) OR

Line 2770: fnd_message.set_name( G_APP_NAME,

2766: ( p_percent is not null AND p_days is not null) OR
2767: ( p_remaining is not null AND p_days is not null) OR
2768: ( l_date is not null AND p_days is not null) OR
2769: (p_percent is null AND p_remaining is null AND l_date is null AND p_days is null AND p_currency is null)) THEN
2770: fnd_message.set_name( G_APP_NAME,
2771: 'OKL_SUBPOOL_ATLIMIT_PARAMS');
2772: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
2773: -- if user has entered one of the parameters then print the report.
2774: ELSE

Line 2772: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

2768: ( l_date is not null AND p_days is not null) OR
2769: (p_percent is null AND p_remaining is null AND l_date is null AND p_days is null AND p_currency is null)) THEN
2770: fnd_message.set_name( G_APP_NAME,
2771: 'OKL_SUBPOOL_ATLIMIT_PARAMS');
2772: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
2773: -- if user has entered one of the parameters then print the report.
2774: ELSE
2775: print_atlimit_detail (p_percent,
2776: p_remaining,

Line 2947: fnd_message.set_name( G_APP_NAME,

2943: p_pool_rec.effective_from_date,
2944: l_conv_rate
2945: );
2946: IF (l_reporting_limit < 0) THEN
2947: fnd_message.set_name( G_APP_NAME,
2948: 'OKL_POOL_CURR_CONV');
2949: fnd_message.set_token('FROM_CURR',
2950: p_pool_rec.currency_code);
2951: fnd_message.set_token('TO_CURR',

Line 2949: fnd_message.set_token('FROM_CURR',

2945: );
2946: IF (l_reporting_limit < 0) THEN
2947: fnd_message.set_name( G_APP_NAME,
2948: 'OKL_POOL_CURR_CONV');
2949: fnd_message.set_token('FROM_CURR',
2950: p_pool_rec.currency_code);
2951: fnd_message.set_token('TO_CURR',
2952: p_to_currency_code);
2953: x_pool_dtl_rec.error_message := fnd_message.get;

Line 2951: fnd_message.set_token('TO_CURR',

2947: fnd_message.set_name( G_APP_NAME,
2948: 'OKL_POOL_CURR_CONV');
2949: fnd_message.set_token('FROM_CURR',
2950: p_pool_rec.currency_code);
2951: fnd_message.set_token('TO_CURR',
2952: p_to_currency_code);
2953: x_pool_dtl_rec.error_message := fnd_message.get;
2954: END IF;
2955: -- If subsidy pool is of type reporting then, calculate the total budgets and remaining balance for that pool,

Line 2953: x_pool_dtl_rec.error_message := fnd_message.get;

2949: fnd_message.set_token('FROM_CURR',
2950: p_pool_rec.currency_code);
2951: fnd_message.set_token('TO_CURR',
2952: p_to_currency_code);
2953: x_pool_dtl_rec.error_message := fnd_message.get;
2954: END IF;
2955: -- If subsidy pool is of type reporting then, calculate the total budgets and remaining balance for that pool,
2956: -- from all its children which are of type budget.
2957: IF(p_pool_rec.pool_type_code = 'REPORTING') THEN

Line 3471: fnd_message.set_name( G_APP_NAME,

3467: -- If p_remaining is entered and p_currency is not entered or vice versa
3468: -- then throw an error, if any one of these parameter is entered then other
3469: -- one is mandatory parameter.
3470: IF ( P_REMAINING is not null AND P_CURRENCY is null) THEN
3471: fnd_message.set_name( G_APP_NAME,
3472: 'OKL_SUBPOOL_CURR_REQ');
3473: INSERT INTO
3474: OKL_G_REPORTS_GT(VALUE1_TEXT,
3475: VALUE2_TEXT)

Line 3478: fnd_message.get

3474: OKL_G_REPORTS_GT(VALUE1_TEXT,
3475: VALUE2_TEXT)
3476: VALUES
3477: ('ERROR',
3478: fnd_message.get
3479: );
3480:
3481: ELSIF ( P_REMAINING is null AND P_CURRENCY is not null) THEN
3482: fnd_message.set_name( G_APP_NAME,

Line 3482: fnd_message.set_name( G_APP_NAME,

3478: fnd_message.get
3479: );
3480:
3481: ELSIF ( P_REMAINING is null AND P_CURRENCY is not null) THEN
3482: fnd_message.set_name( G_APP_NAME,
3483: 'OKL_SUBPOOL_REM_BDGT');
3484: INSERT INTO
3485: OKL_G_REPORTS_GT(VALUE1_TEXT,
3486: VALUE2_TEXT)

Line 3489: fnd_message.get

3485: OKL_G_REPORTS_GT(VALUE1_TEXT,
3486: VALUE2_TEXT)
3487: VALUES
3488: ('ERROR',
3489: fnd_message.get
3490: );
3491:
3492: ELSIF (P_PERCENT is not null AND P_PERCENT > 100)THEN
3493: fnd_message.set_name( G_APP_NAME,

Line 3493: fnd_message.set_name( G_APP_NAME,

3489: fnd_message.get
3490: );
3491:
3492: ELSIF (P_PERCENT is not null AND P_PERCENT > 100)THEN
3493: fnd_message.set_name( G_APP_NAME,
3494: 'OKL_LLA_PERCENT');
3495: INSERT INTO
3496: OKL_G_REPORTS_GT(VALUE1_TEXT,
3497: VALUE2_TEXT)

Line 3500: fnd_message.get

3496: OKL_G_REPORTS_GT(VALUE1_TEXT,
3497: VALUE2_TEXT)
3498: VALUES
3499: ('ERROR',
3500: fnd_message.get
3501: );
3502:
3503: -- if more than one parameters is entered, considering p_remaining and p_currency
3504: -- as a single parameter, or no parameter is entered then throw an error.

Line 3513: fnd_message.set_name( G_APP_NAME,

3509: ( P_PERCENT is not null AND P_DAYS is not null) OR
3510: ( P_REMAINING is not null AND P_DAYS is not null) OR
3511: ( l_date is not null AND P_DAYS is not null) OR
3512: (P_PERCENT is null AND P_REMAINING is null AND l_date is null AND P_DAYS is null AND P_CURRENCY is null)) THEN
3513: fnd_message.set_name( G_APP_NAME,
3514: 'OKL_SUBPOOL_ATLIMIT_PARAMS');
3515: INSERT INTO
3516: OKL_G_REPORTS_GT(VALUE1_TEXT,
3517: VALUE2_TEXT)

Line 3520: fnd_message.get

3516: OKL_G_REPORTS_GT(VALUE1_TEXT,
3517: VALUE2_TEXT)
3518: VALUES
3519: ('ERROR',
3520: fnd_message.get
3521: );
3522: ELSE
3523:
3524: -- If p_percent parameter value is entered by user and other parameters value is null.

Line 4153: fnd_message.set_name( G_APP_NAME,

4149: );
4150: -- if negative value is returned display the error that the conversion between
4151: -- the two currencies is not found.
4152: IF (l_amount < 0) THEN
4153: fnd_message.set_name( G_APP_NAME,
4154: 'OKL_POOL_CURR_CONV');
4155: fnd_message.set_token('FROM_CURR',
4156: each_row.subsidy_pool_currency_code);
4157: fnd_message.set_token('TO_CURR',

Line 4155: fnd_message.set_token('FROM_CURR',

4151: -- the two currencies is not found.
4152: IF (l_amount < 0) THEN
4153: fnd_message.set_name( G_APP_NAME,
4154: 'OKL_POOL_CURR_CONV');
4155: fnd_message.set_token('FROM_CURR',
4156: each_row.subsidy_pool_currency_code);
4157: fnd_message.set_token('TO_CURR',
4158: p_pool_currency);
4159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

Line 4157: fnd_message.set_token('TO_CURR',

4153: fnd_message.set_name( G_APP_NAME,
4154: 'OKL_POOL_CURR_CONV');
4155: fnd_message.set_token('FROM_CURR',
4156: each_row.subsidy_pool_currency_code);
4157: fnd_message.set_token('TO_CURR',
4158: p_pool_currency);
4159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
4160: END IF;
4161: -- If transaction line type is "Reduction" display the transaction amount as

Line 4159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);

4155: fnd_message.set_token('FROM_CURR',
4156: each_row.subsidy_pool_currency_code);
4157: fnd_message.set_token('TO_CURR',
4158: p_pool_currency);
4159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
4160: END IF;
4161: -- If transaction line type is "Reduction" display the transaction amount as
4162: -- .
4163: IF(each_row.trx_type_code = 'ADDITION') THEN