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

Line 7904: l_billed_at_source_msg := l_billed_at_source_msg || fnd_message.get_string('OKS','OKS_HEADER_CASCADE_DATES_WARN') || ';' ;

7900: appends a text in the remarks as " Billing program would not process this fully billed contract"
7901: */
7902: LOG_MESSAGES('Checking billed_at_source for eligible contracts ...'|| l_eligible_contracts_tbl(i).billed_at_source);
7903: if (l_eligible_contracts_tbl(i).billed_at_source is not null and l_eligible_contracts_tbl(i).billed_at_source ='Y') then
7904: l_billed_at_source_msg := l_billed_at_source_msg || fnd_message.get_string('OKS','OKS_HEADER_CASCADE_DATES_WARN') || ';' ;
7905: else
7906: l_billed_at_source_msg := '';
7907: end if;
7908:

Line 7934: -- l_message := FND_MESSAGE.get_string('OKS','OKS_MSCHG_UND_REN');

7930: -- x_return_status => l_return_status ) ;
7931: -- LOG_MESSAGES('Can_Update_Contract :'||l_return_status);
7932: -- IF l_can_update_yn = 'N' then
7933: -- l_status := 'ERROR';
7934: -- l_message := FND_MESSAGE.get_string('OKS','OKS_MSCHG_UND_REN');
7935: -- l_message := 'Can not update. The contract is under electronic renewal process.';
7936: -- RAISE G_EXCEPTION_HALT_VALIDATION;
7937: -- END IF;
7938:

Line 7959: l_message := FND_MESSAGE.get_string('OKS','OKS_MSCHG_WARR_CON') ;

7955: LOG_MESSAGES('Check warranty flag '||l_warranty_flag);
7956: If l_warranty_flag = 'Y' then
7957: If l_criteria_rec.attribute not in ('CONTRACT_START_DATE','CONTRACT_END_DATE') then
7958:
7959: l_message := FND_MESSAGE.get_string('OKS','OKS_MSCHG_WARR_CON') ;
7960: -- l_message := 'Warranty Contract. You can only update Start Date and End Date' ;
7961: RAISE l_notelligible_exception ;
7962: Else
7963: If l_criteria_rec.attribute = 'CONTRACT_START_DATE' then

Line 7970: l_message := FND_MESSAGE.get_string('OKS','OKS_MSCHG_WRONG_DT') ;

7966:
7967: -- Check Start Date > End Date
7968: If trunc(l_eligible_contracts_tbl(i).end_date) <
7969: trunc(to_date(l_new_value,'YYYY/MM/DD HH24:MI:SS')) then
7970: l_message := FND_MESSAGE.get_string('OKS','OKS_MSCHG_WRONG_DT') ;
7971: -- l_message := 'Contract End Date less than new Start Date' ;
7972: RAISE l_notelligible_exception ;
7973: End If;
7974:

Line 8231: l_message := FND_MESSAGE.get_string('OKS','OKS_MSCHG_WRONG_DT') ;

8227:
8228: -- Check Start Date > End Date
8229: If trunc(l_eligible_contracts_tbl(i).Start_date) >
8230: trunc(to_date(l_new_value,'YYYY/MM/DD HH24:MI:SS')) then
8231: l_message := FND_MESSAGE.get_string('OKS','OKS_MSCHG_WRONG_DT') ;
8232: -- l_message := 'Contract Start Date greater than new End Date' ;
8233: RAISE l_notelligible_exception ;
8234: End If;
8235:

Line 10306: l_message := FND_MESSAGE.get_string('OKS','OKS_INVALID_PRICE_LIST') ;

10302:
10303: If nvl(l_pricelist_valid,'N') <> 'Y' then
10304: LOG_MESSAGES('After pricelist validity check; Price List is invalid ');
10305: l_status := 'ERROR';
10306: l_message := FND_MESSAGE.get_string('OKS','OKS_INVALID_PRICE_LIST') ;
10307: RAISE G_EXCEPTION_HALT_VALIDATION;
10308: End If;
10309:
10310: OKC_CONTRACT_PUB.lock_contract_header(

Line 11230: l_message := FND_MESSAGE.get_string('OKS','OKS_MSCHG_BILL_CON') ;

11226: l_chrv_tbl_in(1).object_version_number := l_eligible_contracts_tbl(i).object_version_number;
11227:
11228: IF OKS_EXTWAR_UTIL_PVT.Check_Already_Billed(l_chrv_tbl_in(1).id,NULL,1,NULL) then --to_date(l_new_value,'YYYY/MM/DD HH24:MI:SS')) then
11229:
11230: l_message := FND_MESSAGE.get_string('OKS','OKS_MSCHG_BILL_CON') ;
11231: -- l_message := 'It is already billed. Can not update. ' ;
11232: RAISE l_notelligible_exception ;
11233:
11234: Else

Line 11590: l_message := FND_MESSAGE.get_string('OKS','OKS_MSCHG_BILL_CON') ;

11586:
11587: IF OKS_EXTWAR_UTIL_PVT.Check_Already_Billed(l_chrv_tbl_in(1).id,NULL,1,to_date(l_new_value,'YYYY/MM/DD HH24:MI:SS')) then
11588:
11589: -- l_message := 'It is already billed. Can not update. ' ;
11590: l_message := FND_MESSAGE.get_string('OKS','OKS_MSCHG_BILL_CON') ;
11591: RAISE l_notelligible_exception ;
11592:
11593: ELSE
11594:

Line 12082: l_outfiles_succ(l_outfile_success_id).String3 := pad( FND_MESSAGE.get_string('OKS','OKS_SUCCESS'),22)

12078: rpad(substr(nvl(l_eligible_contracts_tbl(i).contract_number_modifier,' '),1,16),18,' ') ;
12079: l_outfiles_succ(l_outfile_success_id).String2 :=
12080: rpad(substr(nvl(l_eligible_contracts_tbl(i).short_description,' '),1,32),32,' ')||' '||
12081: rpad(substr(nvl(l_old_value,' '),1,25),25,' ') ;
12082: l_outfiles_succ(l_outfile_success_id).String3 := pad( FND_MESSAGE.get_string('OKS','OKS_SUCCESS'),22)
12083: ||' '||l_message || l_billed_at_source_msg ;
12084:
12085: l_amt_message := NULL;
12086: l_success_cnt := l_success_cnt + 1;

Line 12090: l_status := FND_MESSAGE.get_string('OKS','OKS_MSCHG_ERROR');

12086: l_success_cnt := l_success_cnt + 1;
12087: EXCEPTION
12088: WHEN G_EXCEPTION_HALT_VALIDATION THEN
12089: l_error_cnt := l_error_cnt + 1;
12090: l_status := FND_MESSAGE.get_string('OKS','OKS_MSCHG_ERROR');
12091: -- l_status := 'ERROR';
12092: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MASSCHANGE');
12093: LOG_MESSAGES('G_EXCEPTION_HALT_VALIDATION in inner LOOP');
12094: --Update operation lines with ERROR (revisit)

Line 12133: l_status := FND_MESSAGE.get_string('OKS','OKS_MSCHG_NOT_ELIG') ;

12129: x_msg_count => l_msg_count,
12130: x_msg_data => l_msg_data,
12131: p_olev_rec => l_olev_rec_in,
12132: x_olev_rec => l_olev_rec_out);
12133: l_status := FND_MESSAGE.get_string('OKS','OKS_MSCHG_NOT_ELIG') ;
12134: -- l_status := 'NOT ELIGIBLE';
12135: l_message := nvl(l_message,
12136: FND_MESSAGE.get_string('OKS','OKS_MSCHG_MSG_GEN') );
12137: -- l_message := nvl(l_message,'This Contract does not qualify for mass update');

Line 12136: FND_MESSAGE.get_string('OKS','OKS_MSCHG_MSG_GEN') );

12132: x_olev_rec => l_olev_rec_out);
12133: l_status := FND_MESSAGE.get_string('OKS','OKS_MSCHG_NOT_ELIG') ;
12134: -- l_status := 'NOT ELIGIBLE';
12135: l_message := nvl(l_message,
12136: FND_MESSAGE.get_string('OKS','OKS_MSCHG_MSG_GEN') );
12137: -- l_message := nvl(l_message,'This Contract does not qualify for mass update');
12138: -- insert into inelligible tbl
12139:
12140: l_outfile_inel_id := l_outfile_inel_id + 1 ;

Line 12156: l_status := FND_MESSAGE.get_string('OKS','OKS_MSCHG_ERROR');

12152:
12153: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT('BEFORE_MASSCHANGE');
12154: LOG_MESSAGES('For oie_id:'||p_oie_id||', Others EXCEPTION:'||SQLERRM);
12155: l_error_cnt := l_error_cnt + 1;
12156: l_status := FND_MESSAGE.get_string('OKS','OKS_MSCHG_ERROR');
12157: -- l_status := 'ERROR';
12158: l_message := SQLERRM;
12159:
12160: l_olev_rec_in.id := l_eligible_contracts_tbl(i).ole_id;

Line 12300: fnd_file.put_line(FND_FILE.OUTPUT, pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_MSCHG')||

12296: l_empty_string1 :=' ';
12297: l_dash_string1 :='------------------------------';
12298:
12299: fnd_file.new_line(FND_FILE.OUTPUT, 1);
12300: fnd_file.put_line(FND_FILE.OUTPUT, pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_MSCHG')||
12301: ' '||FND_MESSAGE.get_string('OKS',l_process_type_msg_seed)||' '||
12302: FND_MESSAGE.get_string('OKS','OKS_MSCHG_RPT'),45,'L') );
12303: fnd_file.put_line(FND_FILE.OUTPUT, pad(pad('****',
12304: length(FND_MESSAGE.get_string('OKS','OKS_MSCHG_MSCHG')||

Line 12301: ' '||FND_MESSAGE.get_string('OKS',l_process_type_msg_seed)||' '||

12297: l_dash_string1 :='------------------------------';
12298:
12299: fnd_file.new_line(FND_FILE.OUTPUT, 1);
12300: fnd_file.put_line(FND_FILE.OUTPUT, pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_MSCHG')||
12301: ' '||FND_MESSAGE.get_string('OKS',l_process_type_msg_seed)||' '||
12302: FND_MESSAGE.get_string('OKS','OKS_MSCHG_RPT'),45,'L') );
12303: fnd_file.put_line(FND_FILE.OUTPUT, pad(pad('****',
12304: length(FND_MESSAGE.get_string('OKS','OKS_MSCHG_MSCHG')||
12305: FND_MESSAGE.get_string('OKS',l_process_type_msg_seed)||

Line 12302: FND_MESSAGE.get_string('OKS','OKS_MSCHG_RPT'),45,'L') );

12298:
12299: fnd_file.new_line(FND_FILE.OUTPUT, 1);
12300: fnd_file.put_line(FND_FILE.OUTPUT, pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_MSCHG')||
12301: ' '||FND_MESSAGE.get_string('OKS',l_process_type_msg_seed)||' '||
12302: FND_MESSAGE.get_string('OKS','OKS_MSCHG_RPT'),45,'L') );
12303: fnd_file.put_line(FND_FILE.OUTPUT, pad(pad('****',
12304: length(FND_MESSAGE.get_string('OKS','OKS_MSCHG_MSCHG')||
12305: FND_MESSAGE.get_string('OKS',l_process_type_msg_seed)||
12306: FND_MESSAGE.get_string('OKS','OKS_MSCHG_RPT')

Line 12304: length(FND_MESSAGE.get_string('OKS','OKS_MSCHG_MSCHG')||

12300: fnd_file.put_line(FND_FILE.OUTPUT, pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_MSCHG')||
12301: ' '||FND_MESSAGE.get_string('OKS',l_process_type_msg_seed)||' '||
12302: FND_MESSAGE.get_string('OKS','OKS_MSCHG_RPT'),45,'L') );
12303: fnd_file.put_line(FND_FILE.OUTPUT, pad(pad('****',
12304: length(FND_MESSAGE.get_string('OKS','OKS_MSCHG_MSCHG')||
12305: FND_MESSAGE.get_string('OKS',l_process_type_msg_seed)||
12306: FND_MESSAGE.get_string('OKS','OKS_MSCHG_RPT')
12307: )+2,'R','*'),45,'L') );
12308: fnd_file.new_line(FND_FILE.OUTPUT, 2);

Line 12305: FND_MESSAGE.get_string('OKS',l_process_type_msg_seed)||

12301: ' '||FND_MESSAGE.get_string('OKS',l_process_type_msg_seed)||' '||
12302: FND_MESSAGE.get_string('OKS','OKS_MSCHG_RPT'),45,'L') );
12303: fnd_file.put_line(FND_FILE.OUTPUT, pad(pad('****',
12304: length(FND_MESSAGE.get_string('OKS','OKS_MSCHG_MSCHG')||
12305: FND_MESSAGE.get_string('OKS',l_process_type_msg_seed)||
12306: FND_MESSAGE.get_string('OKS','OKS_MSCHG_RPT')
12307: )+2,'R','*'),45,'L') );
12308: fnd_file.new_line(FND_FILE.OUTPUT, 2);
12309: fnd_file.put_line(FND_FILE.OUTPUT, pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_NAME'),35)

Line 12306: FND_MESSAGE.get_string('OKS','OKS_MSCHG_RPT')

12302: FND_MESSAGE.get_string('OKS','OKS_MSCHG_RPT'),45,'L') );
12303: fnd_file.put_line(FND_FILE.OUTPUT, pad(pad('****',
12304: length(FND_MESSAGE.get_string('OKS','OKS_MSCHG_MSCHG')||
12305: FND_MESSAGE.get_string('OKS',l_process_type_msg_seed)||
12306: FND_MESSAGE.get_string('OKS','OKS_MSCHG_RPT')
12307: )+2,'R','*'),45,'L') );
12308: fnd_file.new_line(FND_FILE.OUTPUT, 2);
12309: fnd_file.put_line(FND_FILE.OUTPUT, pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_NAME'),35)
12310: ||': '||l_masschange_name);

Line 12309: fnd_file.put_line(FND_FILE.OUTPUT, pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_NAME'),35)

12305: FND_MESSAGE.get_string('OKS',l_process_type_msg_seed)||
12306: FND_MESSAGE.get_string('OKS','OKS_MSCHG_RPT')
12307: )+2,'R','*'),45,'L') );
12308: fnd_file.new_line(FND_FILE.OUTPUT, 2);
12309: fnd_file.put_line(FND_FILE.OUTPUT, pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_NAME'),35)
12310: ||': '||l_masschange_name);
12311: fnd_file.new_line(FND_FILE.OUTPUT, 1);
12312: fnd_file.put_line(FND_FILE.OUTPUT, pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_SCOPE'),35) );
12313: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1

Line 12312: fnd_file.put_line(FND_FILE.OUTPUT, pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_SCOPE'),35) );

12308: fnd_file.new_line(FND_FILE.OUTPUT, 2);
12309: fnd_file.put_line(FND_FILE.OUTPUT, pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_NAME'),35)
12310: ||': '||l_masschange_name);
12311: fnd_file.new_line(FND_FILE.OUTPUT, 1);
12312: fnd_file.put_line(FND_FILE.OUTPUT, pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_SCOPE'),35) );
12313: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1
12314: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_UPD_LVL'),35)
12315: ||': '||l_update_level);
12316: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1

Line 12314: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_UPD_LVL'),35)

12310: ||': '||l_masschange_name);
12311: fnd_file.new_line(FND_FILE.OUTPUT, 1);
12312: fnd_file.put_line(FND_FILE.OUTPUT, pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_SCOPE'),35) );
12313: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1
12314: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_UPD_LVL'),35)
12315: ||': '||l_update_level);
12316: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1
12317: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_UPD_LVL_VAL'),35)
12318: ||': '|| l_update_level_value);

Line 12317: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_UPD_LVL_VAL'),35)

12313: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1
12314: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_UPD_LVL'),35)
12315: ||': '||l_update_level);
12316: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1
12317: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_UPD_LVL_VAL'),35)
12318: ||': '|| l_update_level_value);
12319: fnd_file.new_line(FND_FILE.OUTPUT, 1);
12320: fnd_file.put_line(FND_FILE.OUTPUT, pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CRIT'),40) );
12321: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1

Line 12320: fnd_file.put_line(FND_FILE.OUTPUT, pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CRIT'),40) );

12316: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1
12317: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_UPD_LVL_VAL'),35)
12318: ||': '|| l_update_level_value);
12319: fnd_file.new_line(FND_FILE.OUTPUT, 1);
12320: fnd_file.put_line(FND_FILE.OUTPUT, pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CRIT'),40) );
12321: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1
12322: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_ATTR'),35)
12323: ||': '||l_attribute);
12324: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1

Line 12322: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_ATTR'),35)

12318: ||': '|| l_update_level_value);
12319: fnd_file.new_line(FND_FILE.OUTPUT, 1);
12320: fnd_file.put_line(FND_FILE.OUTPUT, pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CRIT'),40) );
12321: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1
12322: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_ATTR'),35)
12323: ||': '||l_attribute);
12324: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1
12325: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),35)
12326: ||': '||l_old_value);

Line 12325: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),35)

12321: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1
12322: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_ATTR'),35)
12323: ||': '||l_attribute);
12324: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1
12325: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),35)
12326: ||': '||l_old_value);
12327: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1
12328: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_NEW_VAL'),35)
12329: ||': '||l_new_value);

Line 12328: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_NEW_VAL'),35)

12324: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1
12325: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),35)
12326: ||': '||l_old_value);
12327: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1
12328: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_NEW_VAL'),35)
12329: ||': '||l_new_value);
12330:
12331: -- fnd_file.put_line(FND_FILE.OUTPUT, l_star_string1||l_star_string1||l_star_string1||
12332: -- l_star_string1||l_star_string1 );

Line 12343: fnd_file.put_line(FND_FILE.OUTPUT,FND_MESSAGE.get_string('OKS','OKS_MSCHG_SUMM') ) ;

12339: l_fail_count := l_outfiles_fail.count ;
12340: l_inel_count := l_outfiles_inel.count ;
12341: l_total_rec_count := nvl(l_succ_count,0) + nvl(l_fail_count,0) + nvl(l_inel_count,0) ;
12342:
12343: fnd_file.put_line(FND_FILE.OUTPUT,FND_MESSAGE.get_string('OKS','OKS_MSCHG_SUMM') ) ;
12344: fnd_file.put_line(FND_FILE.OUTPUT,'****************') ;
12345: fnd_file.new_line(FND_FILE.OUTPUT,1) ;
12346: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_SUCC_CON'),50)
12347: ||': '||l_outfiles_succ.count) ;

Line 12346: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_SUCC_CON'),50)

12342:
12343: fnd_file.put_line(FND_FILE.OUTPUT,FND_MESSAGE.get_string('OKS','OKS_MSCHG_SUMM') ) ;
12344: fnd_file.put_line(FND_FILE.OUTPUT,'****************') ;
12345: fnd_file.new_line(FND_FILE.OUTPUT,1) ;
12346: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_SUCC_CON'),50)
12347: ||': '||l_outfiles_succ.count) ;
12348: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_FAIL_CON'),50)
12349: ||': '||l_outfiles_fail.count) ;
12350: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_INELG_CON'),50)

Line 12348: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_FAIL_CON'),50)

12344: fnd_file.put_line(FND_FILE.OUTPUT,'****************') ;
12345: fnd_file.new_line(FND_FILE.OUTPUT,1) ;
12346: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_SUCC_CON'),50)
12347: ||': '||l_outfiles_succ.count) ;
12348: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_FAIL_CON'),50)
12349: ||': '||l_outfiles_fail.count) ;
12350: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_INELG_CON'),50)
12351: ||': '||l_outfiles_inel.count) ;
12352: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_TOT_PROC'),50)

Line 12350: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_INELG_CON'),50)

12346: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_SUCC_CON'),50)
12347: ||': '||l_outfiles_succ.count) ;
12348: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_FAIL_CON'),50)
12349: ||': '||l_outfiles_fail.count) ;
12350: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_INELG_CON'),50)
12351: ||': '||l_outfiles_inel.count) ;
12352: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_TOT_PROC'),50)
12353: ||': '||l_total_rec_count ) ;
12354: fnd_file.new_line(FND_FILE.OUTPUT,1) ;

Line 12352: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_TOT_PROC'),50)

12348: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_FAIL_CON'),50)
12349: ||': '||l_outfiles_fail.count) ;
12350: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_INELG_CON'),50)
12351: ||': '||l_outfiles_inel.count) ;
12352: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_TOT_PROC'),50)
12353: ||': '||l_total_rec_count ) ;
12354: fnd_file.new_line(FND_FILE.OUTPUT,1) ;
12355: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.get_string('OKS','OKS_MSCHG_DET')) ;
12356: fnd_file.put_line(FND_FILE.OUTPUT,'****************') ;

Line 12355: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.get_string('OKS','OKS_MSCHG_DET')) ;

12351: ||': '||l_outfiles_inel.count) ;
12352: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_TOT_PROC'),50)
12353: ||': '||l_total_rec_count ) ;
12354: fnd_file.new_line(FND_FILE.OUTPUT,1) ;
12355: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.get_string('OKS','OKS_MSCHG_DET')) ;
12356: fnd_file.put_line(FND_FILE.OUTPUT,'****************') ;
12357: fnd_file.new_line(FND_FILE.OUTPUT,1) ;
12358: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.get_string('OKS','OKS_MSCHG_LIST_SUCC') ) ;
12359: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||

Line 12358: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.get_string('OKS','OKS_MSCHG_LIST_SUCC') ) ;

12354: fnd_file.new_line(FND_FILE.OUTPUT,1) ;
12355: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.get_string('OKS','OKS_MSCHG_DET')) ;
12356: fnd_file.put_line(FND_FILE.OUTPUT,'****************') ;
12357: fnd_file.new_line(FND_FILE.OUTPUT,1) ;
12358: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.get_string('OKS','OKS_MSCHG_LIST_SUCC') ) ;
12359: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||
12360: l_dash_string1||l_dash_string1||l_dash_string1);
12361: fnd_file.put_line(FND_FILE.OUTPUT,
12362: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||

Line 12362: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||

12358: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.get_string('OKS','OKS_MSCHG_LIST_SUCC') ) ;
12359: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||
12360: l_dash_string1||l_dash_string1||l_dash_string1);
12361: fnd_file.put_line(FND_FILE.OUTPUT,
12362: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||
12363: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||
12364: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||
12365: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||
12366: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||

Line 12363: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||

12359: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||
12360: l_dash_string1||l_dash_string1||l_dash_string1);
12361: fnd_file.put_line(FND_FILE.OUTPUT,
12362: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||
12363: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||
12364: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||
12365: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||
12366: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||
12367: FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_REM') );

Line 12364: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||

12360: l_dash_string1||l_dash_string1||l_dash_string1);
12361: fnd_file.put_line(FND_FILE.OUTPUT,
12362: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||
12363: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||
12364: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||
12365: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||
12366: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||
12367: FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_REM') );
12368: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||

Line 12365: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||

12361: fnd_file.put_line(FND_FILE.OUTPUT,
12362: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||
12363: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||
12364: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||
12365: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||
12366: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||
12367: FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_REM') );
12368: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||
12369: l_dash_string1||l_dash_string1||l_dash_string1);

Line 12366: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||

12362: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||
12363: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||
12364: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||
12365: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||
12366: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||
12367: FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_REM') );
12368: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||
12369: l_dash_string1||l_dash_string1||l_dash_string1);
12370:

Line 12367: FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_REM') );

12363: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||
12364: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||
12365: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||
12366: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||
12367: FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_REM') );
12368: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||
12369: l_dash_string1||l_dash_string1||l_dash_string1);
12370:
12371: IF NVL(l_outfiles_succ.count,0) > 0 then

Line 12381: fnd_file.put_line(FND_FILE.OUTPUT,FND_MESSAGE.get_string('OKS','OKS_MSCHG_LIST_FAIL') ) ;

12377: END IF ;
12378:
12379: fnd_file.new_line(FND_FILE.OUTPUT,1) ;
12380: fnd_file.new_line(FND_FILE.OUTPUT,1) ;
12381: fnd_file.put_line(FND_FILE.OUTPUT,FND_MESSAGE.get_string('OKS','OKS_MSCHG_LIST_FAIL') ) ;
12382: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||
12383: l_dash_string1||l_dash_string1||l_dash_string1);
12384:
12385: fnd_file.put_line(FND_FILE.OUTPUT,

Line 12386: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||

12382: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||
12383: l_dash_string1||l_dash_string1||l_dash_string1);
12384:
12385: fnd_file.put_line(FND_FILE.OUTPUT,
12386: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||
12387: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||
12388: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||
12389: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||
12390: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||

Line 12387: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||

12383: l_dash_string1||l_dash_string1||l_dash_string1);
12384:
12385: fnd_file.put_line(FND_FILE.OUTPUT,
12386: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||
12387: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||
12388: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||
12389: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||
12390: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||
12391: FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_REM') );

Line 12388: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||

12384:
12385: fnd_file.put_line(FND_FILE.OUTPUT,
12386: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||
12387: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||
12388: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||
12389: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||
12390: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||
12391: FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_REM') );
12392:

Line 12389: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||

12385: fnd_file.put_line(FND_FILE.OUTPUT,
12386: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||
12387: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||
12388: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||
12389: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||
12390: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||
12391: FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_REM') );
12392:
12393: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||

Line 12390: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||

12386: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||
12387: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||
12388: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||
12389: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||
12390: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||
12391: FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_REM') );
12392:
12393: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||
12394: l_dash_string1||l_dash_string1||l_dash_string1);

Line 12391: FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_REM') );

12387: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||
12388: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||
12389: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||
12390: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||
12391: FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_REM') );
12392:
12393: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||
12394: l_dash_string1||l_dash_string1||l_dash_string1);
12395: For j in 1..l_outfiles_fail.count LOOP

Line 12403: fnd_file.put_line(FND_FILE.OUTPUT,FND_MESSAGE.get_string('OKS','OKS_MSCHG_LIST_INELG') ) ;

12399: END LOOP ;
12400:
12401: fnd_file.new_line(FND_FILE.OUTPUT,1) ;
12402: fnd_file.new_line(FND_FILE.OUTPUT,1) ;
12403: fnd_file.put_line(FND_FILE.OUTPUT,FND_MESSAGE.get_string('OKS','OKS_MSCHG_LIST_INELG') ) ;
12404: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||
12405: l_dash_string1||l_dash_string1||l_dash_string1);
12406:
12407: fnd_file.put_line(FND_FILE.OUTPUT,

Line 12408: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||

12404: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||
12405: l_dash_string1||l_dash_string1||l_dash_string1);
12406:
12407: fnd_file.put_line(FND_FILE.OUTPUT,
12408: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||
12409: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||
12410: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||
12411: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||
12412: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||

Line 12409: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||

12405: l_dash_string1||l_dash_string1||l_dash_string1);
12406:
12407: fnd_file.put_line(FND_FILE.OUTPUT,
12408: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||
12409: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||
12410: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||
12411: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||
12412: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||
12413: FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_REM') );

Line 12410: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||

12406:
12407: fnd_file.put_line(FND_FILE.OUTPUT,
12408: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||
12409: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||
12410: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||
12411: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||
12412: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||
12413: FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_REM') );
12414:

Line 12411: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||

12407: fnd_file.put_line(FND_FILE.OUTPUT,
12408: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||
12409: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||
12410: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||
12411: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||
12412: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||
12413: FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_REM') );
12414:
12415: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||

Line 12412: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||

12408: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||
12409: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||
12410: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||
12411: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||
12412: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||
12413: FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_REM') );
12414:
12415: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||
12416: l_dash_string1||l_dash_string1||l_dash_string1);

Line 12413: FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_REM') );

12409: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||
12410: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_CON_DECS'),34) ||
12411: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),25) ||
12412: pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_STAT'),24) ||
12413: FND_MESSAGE.get_string('OKS','OKS_MSCHG_PROC_REM') );
12414:
12415: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||
12416: l_dash_string1||l_dash_string1||l_dash_string1);
12417: For k in 1..l_outfiles_inel.count LOOP

Line 12426: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_RPT_END')

12422: fnd_file.new_line(FND_FILE.OUTPUT,1) ;
12423: fnd_file.new_line(FND_FILE.OUTPUT,1) ;
12424: fnd_file.new_line(FND_FILE.OUTPUT,1) ;
12425: fnd_file.put_line(FND_FILE.OUTPUT, pad('********* '
12426: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_RPT_END')
12427: ||' *********',45,'L') );
12428:
12429: EXCEPTION
12430: WHEN OTHERS THEN