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_FILE

Line 7855: -- fnd_file.put_line(FND_FILE.OUTPUT, ' MASS CHANGE '||p_process_type||' REPORT');

7851:
7852: -- The following code for report is moved towards the end of the procedure.
7853: -- Reason: Report printing code was scattered. Mar 2004
7854:
7855: -- fnd_file.put_line(FND_FILE.OUTPUT, ' MASS CHANGE '||p_process_type||' REPORT');
7856: -- fnd_file.put_line(FND_FILE.OUTPUT, ' **************************');
7857: -- fnd_file.new_line(FND_FILE.OUTPUT, 2);
7858: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Name : '||l_masschange_name);
7859: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);

Line 7856: -- fnd_file.put_line(FND_FILE.OUTPUT, ' **************************');

7852: -- The following code for report is moved towards the end of the procedure.
7853: -- Reason: Report printing code was scattered. Mar 2004
7854:
7855: -- fnd_file.put_line(FND_FILE.OUTPUT, ' MASS CHANGE '||p_process_type||' REPORT');
7856: -- fnd_file.put_line(FND_FILE.OUTPUT, ' **************************');
7857: -- fnd_file.new_line(FND_FILE.OUTPUT, 2);
7858: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Name : '||l_masschange_name);
7859: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7860: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Scope ');

Line 7857: -- fnd_file.new_line(FND_FILE.OUTPUT, 2);

7853: -- Reason: Report printing code was scattered. Mar 2004
7854:
7855: -- fnd_file.put_line(FND_FILE.OUTPUT, ' MASS CHANGE '||p_process_type||' REPORT');
7856: -- fnd_file.put_line(FND_FILE.OUTPUT, ' **************************');
7857: -- fnd_file.new_line(FND_FILE.OUTPUT, 2);
7858: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Name : '||l_masschange_name);
7859: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7860: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Scope ');
7861: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level : '||l_update_level);

Line 7858: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Name : '||l_masschange_name);

7854:
7855: -- fnd_file.put_line(FND_FILE.OUTPUT, ' MASS CHANGE '||p_process_type||' REPORT');
7856: -- fnd_file.put_line(FND_FILE.OUTPUT, ' **************************');
7857: -- fnd_file.new_line(FND_FILE.OUTPUT, 2);
7858: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Name : '||l_masschange_name);
7859: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7860: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Scope ');
7861: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level : '||l_update_level);
7862: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level value : '||l_update_level_value);

Line 7859: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);

7855: -- fnd_file.put_line(FND_FILE.OUTPUT, ' MASS CHANGE '||p_process_type||' REPORT');
7856: -- fnd_file.put_line(FND_FILE.OUTPUT, ' **************************');
7857: -- fnd_file.new_line(FND_FILE.OUTPUT, 2);
7858: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Name : '||l_masschange_name);
7859: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7860: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Scope ');
7861: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level : '||l_update_level);
7862: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level value : '||l_update_level_value);
7863: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);

Line 7860: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Scope ');

7856: -- fnd_file.put_line(FND_FILE.OUTPUT, ' **************************');
7857: -- fnd_file.new_line(FND_FILE.OUTPUT, 2);
7858: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Name : '||l_masschange_name);
7859: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7860: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Scope ');
7861: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level : '||l_update_level);
7862: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level value : '||l_update_level_value);
7863: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7864: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Criteria ');

Line 7861: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level : '||l_update_level);

7857: -- fnd_file.new_line(FND_FILE.OUTPUT, 2);
7858: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Name : '||l_masschange_name);
7859: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7860: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Scope ');
7861: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level : '||l_update_level);
7862: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level value : '||l_update_level_value);
7863: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7864: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Criteria ');
7865: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Attribute : '||l_attribute);

Line 7862: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level value : '||l_update_level_value);

7858: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Name : '||l_masschange_name);
7859: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7860: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Scope ');
7861: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level : '||l_update_level);
7862: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level value : '||l_update_level_value);
7863: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7864: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Criteria ');
7865: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Attribute : '||l_attribute);
7866: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Old value : '||l_old_value);

Line 7863: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);

7859: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7860: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Scope ');
7861: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level : '||l_update_level);
7862: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level value : '||l_update_level_value);
7863: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7864: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Criteria ');
7865: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Attribute : '||l_attribute);
7866: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Old value : '||l_old_value);
7867: -- fnd_file.put_line(FND_FILE.OUTPUT, ' New value : '||l_new_value);

Line 7864: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Criteria ');

7860: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Scope ');
7861: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level : '||l_update_level);
7862: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level value : '||l_update_level_value);
7863: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7864: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Criteria ');
7865: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Attribute : '||l_attribute);
7866: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Old value : '||l_old_value);
7867: -- fnd_file.put_line(FND_FILE.OUTPUT, ' New value : '||l_new_value);
7868: -- fnd_file.put_line(FND_FILE.OUTPUT, '*********************************************************************************************************************');

Line 7865: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Attribute : '||l_attribute);

7861: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level : '||l_update_level);
7862: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level value : '||l_update_level_value);
7863: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7864: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Criteria ');
7865: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Attribute : '||l_attribute);
7866: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Old value : '||l_old_value);
7867: -- fnd_file.put_line(FND_FILE.OUTPUT, ' New value : '||l_new_value);
7868: -- fnd_file.put_line(FND_FILE.OUTPUT, '*********************************************************************************************************************');
7869: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);

Line 7866: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Old value : '||l_old_value);

7862: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Update Level value : '||l_update_level_value);
7863: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7864: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Criteria ');
7865: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Attribute : '||l_attribute);
7866: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Old value : '||l_old_value);
7867: -- fnd_file.put_line(FND_FILE.OUTPUT, ' New value : '||l_new_value);
7868: -- fnd_file.put_line(FND_FILE.OUTPUT, '*********************************************************************************************************************');
7869: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7870: -- fnd_file.put_line(FND_FILE.OUTPUT, 'List of Contracts for Mass Change:');

Line 7867: -- fnd_file.put_line(FND_FILE.OUTPUT, ' New value : '||l_new_value);

7863: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7864: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Criteria ');
7865: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Attribute : '||l_attribute);
7866: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Old value : '||l_old_value);
7867: -- fnd_file.put_line(FND_FILE.OUTPUT, ' New value : '||l_new_value);
7868: -- fnd_file.put_line(FND_FILE.OUTPUT, '*********************************************************************************************************************');
7869: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7870: -- fnd_file.put_line(FND_FILE.OUTPUT, 'List of Contracts for Mass Change:');
7871: -- fnd_file.put_line(FND_FILE.OUTPUT, '----------------------------------------------------------------------------------------------------------------------');

Line 7868: -- fnd_file.put_line(FND_FILE.OUTPUT, '*********************************************************************************************************************');

7864: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Mass change Criteria ');
7865: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Attribute : '||l_attribute);
7866: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Old value : '||l_old_value);
7867: -- fnd_file.put_line(FND_FILE.OUTPUT, ' New value : '||l_new_value);
7868: -- fnd_file.put_line(FND_FILE.OUTPUT, '*********************************************************************************************************************');
7869: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7870: -- fnd_file.put_line(FND_FILE.OUTPUT, 'List of Contracts for Mass Change:');
7871: -- fnd_file.put_line(FND_FILE.OUTPUT, '----------------------------------------------------------------------------------------------------------------------');
7872: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Contract Number Modifier Description Old Value Process Status Remark');

Line 7869: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);

7865: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Attribute : '||l_attribute);
7866: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Old value : '||l_old_value);
7867: -- fnd_file.put_line(FND_FILE.OUTPUT, ' New value : '||l_new_value);
7868: -- fnd_file.put_line(FND_FILE.OUTPUT, '*********************************************************************************************************************');
7869: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7870: -- fnd_file.put_line(FND_FILE.OUTPUT, 'List of Contracts for Mass Change:');
7871: -- fnd_file.put_line(FND_FILE.OUTPUT, '----------------------------------------------------------------------------------------------------------------------');
7872: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Contract Number Modifier Description Old Value Process Status Remark');
7873: -- fnd_file.put_line(FND_FILE.OUTPUT, '----------------------------------------------------------------------------------------------------------------------');

Line 7870: -- fnd_file.put_line(FND_FILE.OUTPUT, 'List of Contracts for Mass Change:');

7866: -- fnd_file.put_line(FND_FILE.OUTPUT, ' Old value : '||l_old_value);
7867: -- fnd_file.put_line(FND_FILE.OUTPUT, ' New value : '||l_new_value);
7868: -- fnd_file.put_line(FND_FILE.OUTPUT, '*********************************************************************************************************************');
7869: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7870: -- fnd_file.put_line(FND_FILE.OUTPUT, 'List of Contracts for Mass Change:');
7871: -- fnd_file.put_line(FND_FILE.OUTPUT, '----------------------------------------------------------------------------------------------------------------------');
7872: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Contract Number Modifier Description Old Value Process Status Remark');
7873: -- fnd_file.put_line(FND_FILE.OUTPUT, '----------------------------------------------------------------------------------------------------------------------');
7874:

Line 7871: -- fnd_file.put_line(FND_FILE.OUTPUT, '----------------------------------------------------------------------------------------------------------------------');

7867: -- fnd_file.put_line(FND_FILE.OUTPUT, ' New value : '||l_new_value);
7868: -- fnd_file.put_line(FND_FILE.OUTPUT, '*********************************************************************************************************************');
7869: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7870: -- fnd_file.put_line(FND_FILE.OUTPUT, 'List of Contracts for Mass Change:');
7871: -- fnd_file.put_line(FND_FILE.OUTPUT, '----------------------------------------------------------------------------------------------------------------------');
7872: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Contract Number Modifier Description Old Value Process Status Remark');
7873: -- fnd_file.put_line(FND_FILE.OUTPUT, '----------------------------------------------------------------------------------------------------------------------');
7874:
7875: LOG_MESSAGES('Fetching list of eligible contracts ...');

Line 7872: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Contract Number Modifier Description Old Value Process Status Remark');

7868: -- fnd_file.put_line(FND_FILE.OUTPUT, '*********************************************************************************************************************');
7869: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7870: -- fnd_file.put_line(FND_FILE.OUTPUT, 'List of Contracts for Mass Change:');
7871: -- fnd_file.put_line(FND_FILE.OUTPUT, '----------------------------------------------------------------------------------------------------------------------');
7872: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Contract Number Modifier Description Old Value Process Status Remark');
7873: -- fnd_file.put_line(FND_FILE.OUTPUT, '----------------------------------------------------------------------------------------------------------------------');
7874:
7875: LOG_MESSAGES('Fetching list of eligible contracts ...');
7876:

Line 7873: -- fnd_file.put_line(FND_FILE.OUTPUT, '----------------------------------------------------------------------------------------------------------------------');

7869: -- fnd_file.new_line(FND_FILE.OUTPUT, 1);
7870: -- fnd_file.put_line(FND_FILE.OUTPUT, 'List of Contracts for Mass Change:');
7871: -- fnd_file.put_line(FND_FILE.OUTPUT, '----------------------------------------------------------------------------------------------------------------------');
7872: -- fnd_file.put_line(FND_FILE.OUTPUT, 'Contract Number Modifier Description Old Value Process Status Remark');
7873: -- fnd_file.put_line(FND_FILE.OUTPUT, '----------------------------------------------------------------------------------------------------------------------');
7874:
7875: LOG_MESSAGES('Fetching list of eligible contracts ...');
7876:
7877: OKS_MASSCHANGE_PVT.get_eligible_contracts

Line 7892: fnd_file.new_line(FND_FILE.OUTPUT, 1);

7888: LOG_MESSAGES('Updating all selected (A,E) operation lines STATUS to NULL ...'||l_eligible_contracts_tbl.COUNT);
7889:
7890: UPDATE_LINE_STATUS(p_oie_id => l_criteria_rec.oie_id);
7891:
7892: fnd_file.new_line(FND_FILE.OUTPUT, 1);
7893:
7894: FOR i IN 1 .. l_eligible_contracts_tbl.COUNT
7895: LOOP
7896: BEGIN

Line 12195: --fnd_file.put_line(FND_FILE.OUTPUT,'No Contracts Eligible for Processing ');

12191: l_oiev_rec_in.status_code := 'PROCESSED';
12192: ELSIF l_eligible_contracts_tbl.COUNT = 0 then
12193: l_oiev_rec_in.status_code := 'PROCESSED';
12194: LOG_MESSAGES('No Contracts Elligible for Processing ');
12195: --fnd_file.put_line(FND_FILE.OUTPUT,'No Contracts Eligible for Processing ');
12196: ELSIF l_error_cnt > 0 and l_success_cnt=0 then
12197: l_oiev_rec_in.status_code := 'ERROR';
12198: END IF;
12199: ELSIF p_process_type = 'PREVIEW' then

Line 12207: --fnd_file.put_line(FND_FILE.OUTPUT,'No Contracts Eligible for Processing ');

12203: l_oiev_rec_in.status_code := 'PREVIEWED';
12204: -- END IF;
12205: IF l_eligible_contracts_tbl.COUNT = 0 then
12206: LOG_MESSAGES('No Contracts Elligible for Processing ');
12207: --fnd_file.put_line(FND_FILE.OUTPUT,'No Contracts Eligible for Processing ');
12208: END IF;
12209: END IF;
12210:
12211: -- Printing Inelligible Contracts

Line 12299: fnd_file.new_line(FND_FILE.OUTPUT, 1);

12295:
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('****',

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 12303: fnd_file.put_line(FND_FILE.OUTPUT, pad(pad('****',

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')
12307: )+2,'R','*'),45,'L') );

Line 12308: fnd_file.new_line(FND_FILE.OUTPUT, 2);

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);
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) );

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 12311: fnd_file.new_line(FND_FILE.OUTPUT, 1);

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
12314: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_UPD_LVL'),35)
12315: ||': '||l_update_level);

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 12313: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1

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
12317: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_UPD_LVL_VAL'),35)

Line 12316: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1

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);
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) );

Line 12319: fnd_file.new_line(FND_FILE.OUTPUT, 1);

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
12322: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_ATTR'),35)
12323: ||': '||l_attribute);

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 12321: 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
12325: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_OLD_VAL'),35)

Line 12324: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1

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);
12327: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1
12328: ||FND_MESSAGE.get_string('OKS','OKS_MSCHG_NEW_VAL'),35)

Line 12327: fnd_file.put_line(FND_FILE.OUTPUT, pad(l_empty_string1

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);
12330:
12331: -- fnd_file.put_line(FND_FILE.OUTPUT, l_star_string1||l_star_string1||l_star_string1||

Line 12331: -- fnd_file.put_line(FND_FILE.OUTPUT, l_star_string1||l_star_string1||l_star_string1||

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 );
12333:
12334: fnd_file.new_line(FND_FILE.OUTPUT, 1);
12335: fnd_file.new_line(FND_FILE.OUTPUT, 1);

Line 12334: fnd_file.new_line(FND_FILE.OUTPUT, 1);

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 );
12333:
12334: fnd_file.new_line(FND_FILE.OUTPUT, 1);
12335: fnd_file.new_line(FND_FILE.OUTPUT, 1);
12336:
12337:
12338: l_succ_count := l_outfiles_succ.count ;

Line 12335: fnd_file.new_line(FND_FILE.OUTPUT, 1);

12331: -- fnd_file.put_line(FND_FILE.OUTPUT, l_star_string1||l_star_string1||l_star_string1||
12332: -- l_star_string1||l_star_string1 );
12333:
12334: fnd_file.new_line(FND_FILE.OUTPUT, 1);
12335: fnd_file.new_line(FND_FILE.OUTPUT, 1);
12336:
12337:
12338: l_succ_count := l_outfiles_succ.count ;
12339: l_fail_count := l_outfiles_fail.count ;

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 12344: fnd_file.put_line(FND_FILE.OUTPUT,'****************') ;

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) ;
12348: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_FAIL_CON'),50)

Line 12345: fnd_file.new_line(FND_FILE.OUTPUT,1) ;

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) ;
12348: fnd_file.put_line(FND_FILE.OUTPUT,pad(FND_MESSAGE.get_string('OKS','OKS_MSCHG_FAIL_CON'),50)
12349: ||': '||l_outfiles_fail.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 12354: fnd_file.new_line(FND_FILE.OUTPUT,1) ;

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,'****************') ;
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') ) ;

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 12356: fnd_file.put_line(FND_FILE.OUTPUT,'****************') ;

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||
12360: l_dash_string1||l_dash_string1||l_dash_string1);

Line 12357: fnd_file.new_line(FND_FILE.OUTPUT,1) ;

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||
12360: l_dash_string1||l_dash_string1||l_dash_string1);
12361: fnd_file.put_line(FND_FILE.OUTPUT,

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 12359: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||

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) ||
12363: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_MODIFIER'),18) ||

Line 12361: 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) ||
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) ||

Line 12368: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||

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
12372: For i in 1..l_outfiles_succ.count LOOP

Line 12373: fnd_file.put_line(FND_FILE.OUTPUT,l_outfiles_succ(i).String1||

12369: l_dash_string1||l_dash_string1||l_dash_string1);
12370:
12371: IF NVL(l_outfiles_succ.count,0) > 0 then
12372: For i in 1..l_outfiles_succ.count LOOP
12373: fnd_file.put_line(FND_FILE.OUTPUT,l_outfiles_succ(i).String1||
12374: l_outfiles_succ(i).String2||
12375: l_outfiles_succ(i).String3) ;
12376: END LOOP ;
12377: END IF ;

Line 12379: fnd_file.new_line(FND_FILE.OUTPUT,1) ;

12375: l_outfiles_succ(i).String3) ;
12376: END LOOP ;
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);

Line 12380: fnd_file.new_line(FND_FILE.OUTPUT,1) ;

12376: END LOOP ;
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:

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 12382: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||

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,
12386: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||

Line 12385: fnd_file.put_line(FND_FILE.OUTPUT,

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,
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) ||

Line 12393: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||

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
12396: fnd_file.put_line(FND_FILE.OUTPUT,l_outfiles_fail(j).String1||
12397: l_outfiles_fail(j).String2||

Line 12396: fnd_file.put_line(FND_FILE.OUTPUT,l_outfiles_fail(j).String1||

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
12396: fnd_file.put_line(FND_FILE.OUTPUT,l_outfiles_fail(j).String1||
12397: l_outfiles_fail(j).String2||
12398: l_outfiles_fail(j).String3) ;
12399: END LOOP ;
12400:

Line 12401: fnd_file.new_line(FND_FILE.OUTPUT,1) ;

12397: l_outfiles_fail(j).String2||
12398: l_outfiles_fail(j).String3) ;
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);

Line 12402: fnd_file.new_line(FND_FILE.OUTPUT,1) ;

12398: l_outfiles_fail(j).String3) ;
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:

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 12404: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||

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,
12408: pad(FND_MESSAGE.get_string('OKS','OKS_VAL_CONTRACT_NO'),30) ||

Line 12407: fnd_file.put_line(FND_FILE.OUTPUT,

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,
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) ||

Line 12415: fnd_file.put_line(FND_FILE.OUTPUT, l_dash_string1||l_dash_string1||

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
12418: fnd_file.put_line(FND_FILE.OUTPUT,l_outfiles_inel(k).String1||
12419: l_outfiles_inel(k).String2||

Line 12418: fnd_file.put_line(FND_FILE.OUTPUT,l_outfiles_inel(k).String1||

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
12418: fnd_file.put_line(FND_FILE.OUTPUT,l_outfiles_inel(k).String1||
12419: l_outfiles_inel(k).String2||
12420: l_outfiles_inel(k).String3) ;
12421: END LOOP ;
12422: fnd_file.new_line(FND_FILE.OUTPUT,1) ;

Line 12422: fnd_file.new_line(FND_FILE.OUTPUT,1) ;

12418: fnd_file.put_line(FND_FILE.OUTPUT,l_outfiles_inel(k).String1||
12419: l_outfiles_inel(k).String2||
12420: l_outfiles_inel(k).String3) ;
12421: END LOOP ;
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')

Line 12423: fnd_file.new_line(FND_FILE.OUTPUT,1) ;

12419: l_outfiles_inel(k).String2||
12420: l_outfiles_inel(k).String3) ;
12421: END LOOP ;
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') );

Line 12424: fnd_file.new_line(FND_FILE.OUTPUT,1) ;

12420: l_outfiles_inel(k).String3) ;
12421: END LOOP ;
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:

Line 12425: fnd_file.put_line(FND_FILE.OUTPUT, pad('********* '

12421: END LOOP ;
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

Line 12522: fnd_file.put_line(FND_FILE.LOG, p_mesg);

12518: IF nvl(l_conc_program,'N') = 'N' THEN
12519: --dbms_output.put_line(p_mesg);
12520: NULL;
12521: ELSE
12522: fnd_file.put_line(FND_FILE.LOG, p_mesg);
12523: END IF;
12524: END LOG_MESSAGES;
12525:
12526: PROCEDURE CREATE_OPERATION_INSTANCES (p_oie_rec IN opr_instance_rec_type,