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_BILLING_UTIL_PVT dependencies on FND_FILE

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

1054: END IF;
1055:
1056: -- Printing In Process Billing Transactions report header. The formatting of the message titles is
1057: -- also taken care here.
1058: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||
1059: RPAD(' ', 53 , ' ' ));
1060: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1061: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1062: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKL_IN_PRCS_BILL_TRANS_REP') ||

Line 1060: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));

1056: -- Printing In Process Billing Transactions report header. The formatting of the message titles is
1057: -- also taken care here.
1058: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||
1059: RPAD(' ', 53 , ' ' ));
1060: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1061: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1062: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKL_IN_PRCS_BILL_TRANS_REP') ||
1063: RPAD(' ', 53 , ' ' ));
1064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || '-------------------------------' || RPAD(' ', 51, ' ' ));

Line 1061: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));

1057: -- also taken care here.
1058: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||
1059: RPAD(' ', 53 , ' ' ));
1060: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1061: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1062: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKL_IN_PRCS_BILL_TRANS_REP') ||
1063: RPAD(' ', 53 , ' ' ));
1064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || '-------------------------------' || RPAD(' ', 51, ' ' ));
1065: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));

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

1058: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKLHOMENAVTITLE') ||
1059: RPAD(' ', 53 , ' ' ));
1060: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1061: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1062: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKL_IN_PRCS_BILL_TRANS_REP') ||
1063: RPAD(' ', 53 , ' ' ));
1064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || '-------------------------------' || RPAD(' ', 51, ' ' ));
1065: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));

Line 1064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || '-------------------------------' || RPAD(' ', 51, ' ' ));

1060: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1061: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1062: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKL_IN_PRCS_BILL_TRANS_REP') ||
1063: RPAD(' ', 53 , ' ' ));
1064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || '-------------------------------' || RPAD(' ', 51, ' ' ));
1065: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1067: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));*/
1068:

Line 1065: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));

1061: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1062: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKL_IN_PRCS_BILL_TRANS_REP') ||
1063: RPAD(' ', 53 , ' ' ));
1064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || '-------------------------------' || RPAD(' ', 51, ' ' ));
1065: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1067: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));*/
1068:
1069: -- Printing the titles for 'Contract Number' and 'Next Step'

Line 1066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));

1062: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', 52 , ' ' ) || fnd_message.get_string('OKL','OKL_IN_PRCS_BILL_TRANS_REP') ||
1063: RPAD(' ', 53 , ' ' ));
1064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || '-------------------------------' || RPAD(' ', 51, ' ' ));
1065: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1067: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));*/
1068:
1069: -- Printing the titles for 'Contract Number' and 'Next Step'
1070: /* FND_FILE.PUT(FND_FILE.OUTPUT, RPAD('Contract Number Next Step',150,' '));

Line 1067: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));*/

1063: RPAD(' ', 53 , ' ' ));
1064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || '-------------------------------' || RPAD(' ', 51, ' ' ));
1065: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1067: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));*/
1068:
1069: -- Printing the titles for 'Contract Number' and 'Next Step'
1070: /* FND_FILE.PUT(FND_FILE.OUTPUT, RPAD('Contract Number Next Step',150,' '));
1071: FND_FILE.PUT(FND_FILE.OUTPUT, RPAD('------------------ --------------',150,' ')); */

Line 1070: /* FND_FILE.PUT(FND_FILE.OUTPUT, RPAD('Contract Number Next Step',150,' '));

1066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1067: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));*/
1068:
1069: -- Printing the titles for 'Contract Number' and 'Next Step'
1070: /* FND_FILE.PUT(FND_FILE.OUTPUT, RPAD('Contract Number Next Step',150,' '));
1071: FND_FILE.PUT(FND_FILE.OUTPUT, RPAD('------------------ --------------',150,' ')); */
1072:
1073: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Contract Number Next Step');
1074: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------------ --------------'); */

Line 1071: FND_FILE.PUT(FND_FILE.OUTPUT, RPAD('------------------ --------------',150,' ')); */

1067: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));*/
1068:
1069: -- Printing the titles for 'Contract Number' and 'Next Step'
1070: /* FND_FILE.PUT(FND_FILE.OUTPUT, RPAD('Contract Number Next Step',150,' '));
1071: FND_FILE.PUT(FND_FILE.OUTPUT, RPAD('------------------ --------------',150,' ')); */
1072:
1073: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Contract Number Next Step');
1074: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------------ --------------'); */
1075:

Line 1073: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Contract Number Next Step');

1069: -- Printing the titles for 'Contract Number' and 'Next Step'
1070: /* FND_FILE.PUT(FND_FILE.OUTPUT, RPAD('Contract Number Next Step',150,' '));
1071: FND_FILE.PUT(FND_FILE.OUTPUT, RPAD('------------------ --------------',150,' ')); */
1072:
1073: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Contract Number Next Step');
1074: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------------ --------------'); */
1075:
1076: -- Initialize the contract variable to Null.
1077: -- Open the cursor Int_Ext_Check_Csr, Loop through it and display the contract number

Line 1074: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------------ --------------'); */

1070: /* FND_FILE.PUT(FND_FILE.OUTPUT, RPAD('Contract Number Next Step',150,' '));
1071: FND_FILE.PUT(FND_FILE.OUTPUT, RPAD('------------------ --------------',150,' ')); */
1072:
1073: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Contract Number Next Step');
1074: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------------ --------------'); */
1075:
1076: -- Initialize the contract variable to Null.
1077: -- Open the cursor Int_Ext_Check_Csr, Loop through it and display the contract number
1078: -- and the Next step value should be 'Run Prepare Receivables Bills concurrent program'.

Line 1090: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(SUBSTR(l_contract,1,28),30,' ')||

1086: THEN
1087: LOOP
1088: x_any_data_exists := true; -- VPANWAR changed for pre upgrade test
1089: x_retcode := 1;
1090: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(SUBSTR(l_contract,1,28),30,' ')||
1091: RPAD(' Run Prepare Receivables Bills concurrent program',120,' '));
1092: FETCH int_ext_check_csr INTO l_contract;
1093: EXIT WHEN int_ext_check_csr%NOTFOUND;*/
1094: x_errbuf := 'Prepare Receivables Bills concurrent program';

Line 1098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || 'No Records Found' || RPAD(' ', 51, ' ' ));*/

1094: x_errbuf := 'Prepare Receivables Bills concurrent program';
1095: EXIT;
1096: END LOOP;
1097: /* ELSE
1098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || 'No Records Found' || RPAD(' ', 51, ' ' ));*/
1099: END IF;
1100: CLOSE int_ext_check_csr;
1101:
1102: -- Insert blank lines

Line 1103: /*FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));

1099: END IF;
1100: CLOSE int_ext_check_csr;
1101:
1102: -- Insert blank lines
1103: /*FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
1104: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
1105: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));*/
1106:
1107: -- Initialize the contract variable to Null.

Line 1104: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));

1100: CLOSE int_ext_check_csr;
1101:
1102: -- Insert blank lines
1103: /*FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
1104: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
1105: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));*/
1106:
1107: -- Initialize the contract variable to Null.
1108: -- Open the cursor ext_cnsld_check_csr, Loop through it and display the contract number

Line 1105: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));*/

1101:
1102: -- Insert blank lines
1103: /*FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
1104: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
1105: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));*/
1106:
1107: -- Initialize the contract variable to Null.
1108: -- Open the cursor ext_cnsld_check_csr, Loop through it and display the contract number
1109: -- and the Next step value should be 'Run Receivables Bills Consolidation concurrent program'.

Line 1121: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(SUBSTR(l_contract,1,28),30,' ')||

1117: THEN
1118: LOOP
1119: x_any_data_exists := true; -- VPANWAR changed for pre upgrade test
1120: x_retcode := 1;
1121: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(SUBSTR(l_contract,1,28),30,' ')||
1122: RPAD(' Run Receivables Bills Consolidation concurrent program',120,' '));
1123: FETCH ext_cnsld_check_csr INTO l_contract;
1124: EXIT WHEN ext_cnsld_check_csr%NOTFOUND;*/
1125: x_errbuf := 'Receivables Bills Consolidation concurrent program';

Line 1129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || 'No Records Found' || RPAD(' ', 51, ' ' ));*/

1125: x_errbuf := 'Receivables Bills Consolidation concurrent program';
1126: EXIT;
1127: END LOOP;
1128: /*ELSE
1129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || 'No Records Found' || RPAD(' ', 51, ' ' ));*/
1130: END IF;
1131: CLOSE ext_cnsld_check_csr;
1132:
1133: -- Insert blank lines

Line 1134: /*FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));

1130: END IF;
1131: CLOSE ext_cnsld_check_csr;
1132:
1133: -- Insert blank lines
1134: /*FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
1135: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
1136: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));*/
1137:
1138: -- Initialize the contract variable to Null.

Line 1135: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));

1131: CLOSE ext_cnsld_check_csr;
1132:
1133: -- Insert blank lines
1134: /*FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
1135: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
1136: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));*/
1137:
1138: -- Initialize the contract variable to Null.
1139: -- Open the cursor cnsld_ar_check_csr, Loop through it and display the contract number

Line 1136: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));*/

1132:
1133: -- Insert blank lines
1134: /*FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
1135: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
1136: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));*/
1137:
1138: -- Initialize the contract variable to Null.
1139: -- Open the cursor cnsld_ar_check_csr, Loop through it and display the contract number
1140: -- and the Next step value should be 'Run Prepare Receivables Bills concurrent program'.

Line 1152: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(SUBSTR(l_contract,1,28),30,' ')||

1148: THEN
1149: LOOP
1150: x_any_data_exists := true; -- VPANWAR changed for pre upgrade test
1151: x_retcode := 1;
1152: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(SUBSTR(l_contract,1,28),30,' ')||
1153: RPAD(' Run Receivables Invoice Transfer to AR concurrent program',120,' '));
1154: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',30,' ')||
1155: RPAD(' Run AutoInvoice Master Program',120,' '));
1156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',30,' ')||

Line 1154: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',30,' ')||

1150: x_any_data_exists := true; -- VPANWAR changed for pre upgrade test
1151: x_retcode := 1;
1152: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(SUBSTR(l_contract,1,28),30,' ')||
1153: RPAD(' Run Receivables Invoice Transfer to AR concurrent program',120,' '));
1154: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',30,' ')||
1155: RPAD(' Run AutoInvoice Master Program',120,' '));
1156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',30,' ')||
1157: RPAD(' Run Fetch AR Invoice Numbers',120,' '));
1158: FETCH cnsld_ar_check_csr INTO l_contract;

Line 1156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',30,' ')||

1152: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(SUBSTR(l_contract,1,28),30,' ')||
1153: RPAD(' Run Receivables Invoice Transfer to AR concurrent program',120,' '));
1154: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',30,' ')||
1155: RPAD(' Run AutoInvoice Master Program',120,' '));
1156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',30,' ')||
1157: RPAD(' Run Fetch AR Invoice Numbers',120,' '));
1158: FETCH cnsld_ar_check_csr INTO l_contract;
1159: EXIT WHEN cnsld_ar_check_csr%NOTFOUND;*/
1160: x_errbuf := 'AutoInvoice Master Program and Fetch AR Invoice Numbers';

Line 1164: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || 'No Records Found' || RPAD(' ', 51, ' ' ));*/

1160: x_errbuf := 'AutoInvoice Master Program and Fetch AR Invoice Numbers';
1161: EXIT;
1162: END LOOP;
1163: /*ELSE
1164: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || 'No Records Found' || RPAD(' ', 51, ' ' ));*/
1165: END IF;
1166: CLOSE cnsld_ar_check_csr;
1167:
1168: -- Insert blank lines

Line 1169: /*FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));

1165: END IF;
1166: CLOSE cnsld_ar_check_csr;
1167:
1168: -- Insert blank lines
1169: /*FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
1170: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
1171: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));*/
1172:
1173: -- Initialize the contract variable to Null.

Line 1170: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));

1166: CLOSE cnsld_ar_check_csr;
1167:
1168: -- Insert blank lines
1169: /*FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
1170: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
1171: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));*/
1172:
1173: -- Initialize the contract variable to Null.
1174: -- Open the cursor cnsld_pstv_check_csr, Loop through it and display the contract number

Line 1171: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));*/

1167:
1168: -- Insert blank lines
1169: /*FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
1170: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));
1171: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, rPAD(' ', 150, ' '));*/
1172:
1173: -- Initialize the contract variable to Null.
1174: -- Open the cursor cnsld_pstv_check_csr, Loop through it and display the contract number
1175: -- and the Next step value should be 'Run Prepare Receivables Bills concurrent program'.

Line 1187: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(SUBSTR(l_contract,1,28),30,' ')||

1183: THEN
1184: LOOP
1185: x_any_data_exists := true; -- VPANWAR changed for pre upgrade test
1186: x_retcode := 1;
1187: /*FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(SUBSTR(l_contract,1,28),30,' ')||
1188: RPAD(' Run Fetch AR Invoice Numbers',120,' '));
1189: FETCH cnsld_pstv_check_csr INTO l_contract;
1190: EXIT WHEN cnsld_pstv_check_csr%NOTFOUND;*/
1191: x_errbuf := 'Fetch AR Invoice Numbers';

Line 1195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || 'No Records Found' || RPAD(' ', 51, ' ' ));*/

1191: x_errbuf := 'Fetch AR Invoice Numbers';
1192: EXIT;
1193: END LOOP;
1194: /*ELSE
1195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ',50, ' ' ) || 'No Records Found' || RPAD(' ', 51, ' ' ));*/
1196: END IF;
1197: CLOSE cnsld_pstv_check_csr;
1198:
1199: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);

Line 1226: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLERRM);

1222: x_errbuf := SQLERRM;
1223: x_retcode := 2;
1224: x_any_data_exists := true; -- VPANWAR changed for pre upgrade test
1225:
1226: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLERRM);
1227:
1228: IF (SQLCODE <> -20001) THEN
1229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);
1230: RAISE;

Line 1229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);

1225:
1226: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLERRM);
1227:
1228: IF (SQLCODE <> -20001) THEN
1229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);
1230: RAISE;
1231: ELSE
1232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);
1233: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);

1228: IF (SQLCODE <> -20001) THEN
1229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);
1230: RAISE;
1231: ELSE
1232: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error: '||SQLCODE||SQLERRM);
1233: APP_EXCEPTION.RAISE_EXCEPTION;
1234: END IF;
1235: END check_preupgrade_data;
1236: