245: l_agg_rec.minid,
246: l_agg_rec.maxid,nvl(l_batch_size,10000));
247:
248: IF (l_ret = 0) then
249: errbuf := fnd_message.get;
250: retcode := 2;
251: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Sub-request failed to submit: ' || errbuf);
252: return;
253: ELSE
277: l_agg_rec.minid,
278: l_agg_rec.maxid,nvl(l_batch_size,10000));
279:
280: IF (l_ret = 0) then
281: errbuf := fnd_message.get;
282: retcode := 2;
283: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Sub-request Line History failed to submit: ' || errbuf);
284: return;
285: ELSE
318: range_rec.wb_high,
319: nvl(l_batch_size,10000));
320:
321: IF (l_ret = 0) then
322: errbuf := fnd_message.get;
323: retcode := 2;
324: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Sub-request failed to submit: ' || errbuf);
325: return;
326: ELSE
359: range_rec.wb_high,
360: nvl(l_batch_size,10000));
361:
362: IF (l_ret = 0) then
363: errbuf := fnd_message.get;
364: retcode := 2;
365: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Sub-request failed to submit: ' || errbuf);
366: return;
367: ELSE
2131: FND_FILE.put_line(FND_FILE.OUTPUT,' Credit Card Migration Error Report ');
2132: FND_FILE.put_line(FND_FILE.OUTPUT,' ********************************** ');
2133: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2134: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Headers');
2135: fnd_file.put_line(FND_FILE.OUTPUT,FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_HDR'));
2136: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string
2137: || SUBSTR(l_dash_string,1,6));
2138:
2139: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2138:
2139: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2140: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Number Billto Status Start Date End Date Date Terminated Credit Card Number Expiration Date');
2141: FND_FILE.put_line(FND_FILE.OUTPUT,
2142: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2143: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2144: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2145: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2146: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2139: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2140: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Number Billto Status Start Date End Date Date Terminated Credit Card Number Expiration Date');
2141: FND_FILE.put_line(FND_FILE.OUTPUT,
2142: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2143: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2144: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2145: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2146: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2147: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2140: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Number Billto Status Start Date End Date Date Terminated Credit Card Number Expiration Date');
2141: FND_FILE.put_line(FND_FILE.OUTPUT,
2142: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2143: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2144: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2145: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2146: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2147: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2148: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2141: FND_FILE.put_line(FND_FILE.OUTPUT,
2142: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2143: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2144: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2145: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2146: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2147: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2148: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2149: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2142: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2143: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2144: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2145: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2146: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2147: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2148: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2149: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2150: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string||l_dash_string||l_dash_string
2143: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2144: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2145: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2146: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2147: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2148: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2149: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2150: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string||l_dash_string||l_dash_string
2151: ||l_dash_string||l_dash_string||l_dash_string
2144: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2145: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2146: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2147: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2148: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2149: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2150: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string||l_dash_string||l_dash_string
2151: ||l_dash_string||l_dash_string||l_dash_string
2152: ||l_dash_string||l_dash_string||l_dash_string
2145: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2146: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2147: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2148: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2149: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2150: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string||l_dash_string||l_dash_string
2151: ||l_dash_string||l_dash_string||l_dash_string
2152: ||l_dash_string||l_dash_string||l_dash_string
2153: ||l_dash_string||l_dash_string||l_dash_string
2223: END LOOP;
2224: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2225: END LOOP;
2226: ELSE
2227: fnd_file.put_line(FND_FILE.OUTPUT,FND_MESSAGE.get_string('OKS','OKS_RR_MIG_SUCCESS'));
2228: END IF;
2229:
2230: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2231: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Headers History');
2228: END IF;
2229:
2230: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2231: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Headers History');
2232: FND_FILE.put_line(FND_FILE.OUTPUT,FND_MESSAGE.get_string('OKS','OKS_RR_HDR_HIST'));
2233: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string||l_dash_string
2234: ||SUBSTR(l_dash_string,1,4));
2235: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2236: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Number Major Version Billto Status Start Date End Date Date Terminated Credit Card Number Expiration Date');
2234: ||SUBSTR(l_dash_string,1,4));
2235: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2236: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Number Major Version Billto Status Start Date End Date Date Terminated Credit Card Number Expiration Date');
2237: FND_FILE.put_line(FND_FILE.OUTPUT,
2238: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2239: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_MAJOR_VER'),17)
2240: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2241: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2242: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2235: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2236: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Number Major Version Billto Status Start Date End Date Date Terminated Credit Card Number Expiration Date');
2237: FND_FILE.put_line(FND_FILE.OUTPUT,
2238: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2239: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_MAJOR_VER'),17)
2240: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2241: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2242: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2243: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2236: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Number Major Version Billto Status Start Date End Date Date Terminated Credit Card Number Expiration Date');
2237: FND_FILE.put_line(FND_FILE.OUTPUT,
2238: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2239: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_MAJOR_VER'),17)
2240: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2241: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2242: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2243: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2244: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2237: FND_FILE.put_line(FND_FILE.OUTPUT,
2238: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2239: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_MAJOR_VER'),17)
2240: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2241: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2242: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2243: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2244: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2245: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2238: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2239: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_MAJOR_VER'),17)
2240: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2241: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2242: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2243: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2244: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2245: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2246: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2239: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_MAJOR_VER'),17)
2240: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2241: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2242: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2243: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2244: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2245: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2246: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2247: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string||l_dash_string||l_dash_string
2240: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2241: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2242: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2243: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2244: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2245: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2246: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2247: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string||l_dash_string||l_dash_string
2248: ||l_dash_string||l_dash_string||l_dash_string
2241: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2242: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2243: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2244: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2245: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2246: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2247: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string||l_dash_string||l_dash_string
2248: ||l_dash_string||l_dash_string||l_dash_string
2249: ||l_dash_string||l_dash_string||l_dash_string
2242: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2243: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2244: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2245: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2246: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2247: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string||l_dash_string||l_dash_string
2248: ||l_dash_string||l_dash_string||l_dash_string
2249: ||l_dash_string||l_dash_string||l_dash_string
2250: ||l_dash_string||l_dash_string||l_dash_string
2323: END LOOP;
2324: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2325: END LOOP;
2326: ELSE
2327: fnd_file.put_line(FND_FILE.OUTPUT,FND_MESSAGE.get_string('OKS','OKS_RR_MIG_SUCCESS'));
2328: END IF;
2329:
2330: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Lines');
2331: FND_FILE.put_line(FND_FILE.OUTPUT,FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_LINES'));
2327: fnd_file.put_line(FND_FILE.OUTPUT,FND_MESSAGE.get_string('OKS','OKS_RR_MIG_SUCCESS'));
2328: END IF;
2329:
2330: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Lines');
2331: FND_FILE.put_line(FND_FILE.OUTPUT,FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_LINES'));
2332: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string|| SUBSTR(l_dash_string,1,4));
2333: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2334: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Number Line Number Billto Service Name Status Start Date End Date Date Terminated Credit Card Number Expiration Date ');
2335: FND_FILE.put_line(FND_FILE.OUTPUT,
2332: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string|| SUBSTR(l_dash_string,1,4));
2333: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2334: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Number Line Number Billto Service Name Status Start Date End Date Date Terminated Credit Card Number Expiration Date ');
2335: FND_FILE.put_line(FND_FILE.OUTPUT,
2336: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2337: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_LINE_NUMBER'),14)
2338: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2339: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_SRV_NAME'),25)
2340: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2333: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2334: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Number Line Number Billto Service Name Status Start Date End Date Date Terminated Credit Card Number Expiration Date ');
2335: FND_FILE.put_line(FND_FILE.OUTPUT,
2336: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2337: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_LINE_NUMBER'),14)
2338: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2339: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_SRV_NAME'),25)
2340: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2341: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2334: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Number Line Number Billto Service Name Status Start Date End Date Date Terminated Credit Card Number Expiration Date ');
2335: FND_FILE.put_line(FND_FILE.OUTPUT,
2336: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2337: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_LINE_NUMBER'),14)
2338: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2339: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_SRV_NAME'),25)
2340: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2341: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2342: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2335: FND_FILE.put_line(FND_FILE.OUTPUT,
2336: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2337: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_LINE_NUMBER'),14)
2338: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2339: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_SRV_NAME'),25)
2340: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2341: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2342: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2343: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2336: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2337: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_LINE_NUMBER'),14)
2338: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2339: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_SRV_NAME'),25)
2340: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2341: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2342: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2343: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2344: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2337: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_LINE_NUMBER'),14)
2338: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2339: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_SRV_NAME'),25)
2340: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2341: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2342: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2343: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2344: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2345: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2338: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2339: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_SRV_NAME'),25)
2340: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2341: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2342: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2343: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2344: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2345: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2346: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string||l_dash_string||l_dash_string
2339: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_SRV_NAME'),25)
2340: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2341: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2342: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2343: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2344: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2345: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2346: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string||l_dash_string||l_dash_string
2347: ||l_dash_string||l_dash_string||l_dash_string
2340: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2341: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2342: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2343: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2344: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2345: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2346: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string||l_dash_string||l_dash_string
2347: ||l_dash_string||l_dash_string||l_dash_string
2348: ||l_dash_string||l_dash_string||l_dash_string
2341: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2342: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2343: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2344: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2345: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2346: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string||l_dash_string||l_dash_string
2347: ||l_dash_string||l_dash_string||l_dash_string
2348: ||l_dash_string||l_dash_string||l_dash_string
2349: ||l_dash_string||l_dash_string||l_dash_string
2468: END LOOP;
2469: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2470: END LOOP;
2471: ELSE
2472: fnd_file.put_line(FND_FILE.OUTPUT,FND_MESSAGE.get_string('OKS','OKS_RR_MIG_SUCCESS'));
2473: END IF;
2474:
2475: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2476: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Lines History');
2473: END IF;
2474:
2475: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2476: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Lines History');
2477: FND_FILE.put_line(FND_FILE.OUTPUT,FND_MESSAGE.get_string('OKS','OKS_RR_LINE_HIST'));
2478: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string||l_dash_string
2479: ||SUBSTR(l_dash_string,1,2));
2480: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2481: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Number Major Version Line Number Billto Service Name Status Start Date End Date Date Terminated Credit Card Number Expiration Date');
2479: ||SUBSTR(l_dash_string,1,2));
2480: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2481: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Number Major Version Line Number Billto Service Name Status Start Date End Date Date Terminated Credit Card Number Expiration Date');
2482: FND_FILE.put_line(FND_FILE.OUTPUT,
2483: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2484: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_MAJOR_VER'),16)
2485: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_LINE_NUMBER'),14)
2486: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2487: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_SRV_NAME'),25)
2480: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2481: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Number Major Version Line Number Billto Service Name Status Start Date End Date Date Terminated Credit Card Number Expiration Date');
2482: FND_FILE.put_line(FND_FILE.OUTPUT,
2483: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2484: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_MAJOR_VER'),16)
2485: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_LINE_NUMBER'),14)
2486: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2487: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_SRV_NAME'),25)
2488: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2481: -- FND_FILE.put_line(FND_FILE.OUTPUT,'Contract Number Major Version Line Number Billto Service Name Status Start Date End Date Date Terminated Credit Card Number Expiration Date');
2482: FND_FILE.put_line(FND_FILE.OUTPUT,
2483: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2484: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_MAJOR_VER'),16)
2485: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_LINE_NUMBER'),14)
2486: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2487: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_SRV_NAME'),25)
2488: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2489: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2482: FND_FILE.put_line(FND_FILE.OUTPUT,
2483: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2484: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_MAJOR_VER'),16)
2485: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_LINE_NUMBER'),14)
2486: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2487: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_SRV_NAME'),25)
2488: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2489: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2490: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2483: RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CONTRACT_NUM'),25)
2484: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_MAJOR_VER'),16)
2485: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_LINE_NUMBER'),14)
2486: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2487: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_SRV_NAME'),25)
2488: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2489: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2490: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2491: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2484: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_MAJOR_VER'),16)
2485: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_LINE_NUMBER'),14)
2486: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2487: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_SRV_NAME'),25)
2488: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2489: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2490: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2491: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2492: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2485: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_LINE_NUMBER'),14)
2486: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2487: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_SRV_NAME'),25)
2488: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2489: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2490: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2491: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2492: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2493: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2486: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_BILL_TO'),25)
2487: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_SRV_NAME'),25)
2488: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2489: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2490: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2491: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2492: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2493: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2494: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string||l_dash_string||l_dash_string
2487: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_SRV_NAME'),25)
2488: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2489: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2490: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2491: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2492: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2493: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2494: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string||l_dash_string||l_dash_string
2495: ||l_dash_string||l_dash_string||l_dash_string
2488: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_STATUS'),10)
2489: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2490: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2491: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2492: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2493: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2494: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string||l_dash_string||l_dash_string
2495: ||l_dash_string||l_dash_string||l_dash_string
2496: ||l_dash_string||l_dash_string||l_dash_string
2489: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_START_DATE'),14)
2490: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_END_DATE'),13)
2491: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_DATE_TERM'),18)
2492: ||RPAD(FND_MESSAGE.get_string('OKS','OKS_RR_CCR_NUM'),20)
2493: ||FND_MESSAGE.get_string('OKS','OKS_RR_EXP_DATE'));
2494: FND_FILE.put_line(FND_FILE.OUTPUT,l_dash_string||l_dash_string||l_dash_string
2495: ||l_dash_string||l_dash_string||l_dash_string
2496: ||l_dash_string||l_dash_string||l_dash_string
2497: ||l_dash_string||l_dash_string||l_dash_string
2620: END LOOP;
2621: FND_FILE.put_line(FND_FILE.OUTPUT,' ');
2622: END LOOP;
2623: ELSE
2624: fnd_file.put_line(FND_FILE.OUTPUT,FND_MESSAGE.get_string('OKS','OKS_RR_MIG_SUCCESS'));
2625: END IF;
2626: END;
2627:
2628:
2757: l_agg_rec.minid,
2758: l_agg_rec.maxid,nvl(l_batch_size,10000));
2759:
2760: IF (l_ret = 0) then
2761: errbuf := fnd_message.get;
2762: retcode := 2;
2763: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Sub-request failed to submit: ' || errbuf);
2764: return;
2765: ELSE
2789: l_agg_rec.minid,
2790: l_agg_rec.maxid,nvl(l_batch_size,10000));
2791:
2792: IF (l_ret = 0) then
2793: errbuf := fnd_message.get;
2794: retcode := 2;
2795: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Sub-request Line History failed to submit: ' || errbuf);
2796: return;
2797: ELSE
2814: range_rec.wb_high,
2815: nvl(l_batch_size,10000));
2816:
2817: IF (l_ret = 0) then
2818: errbuf := fnd_message.get;
2819: retcode := 2;
2820: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Sub-request failed to submit: ' || errbuf);
2821: return;
2822: ELSE
2841: range_rec.wb_high,
2842: nvl(l_batch_size,10000));
2843:
2844: IF (l_ret = 0) then
2845: errbuf := fnd_message.get;
2846: retcode := 2;
2847: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Sub-request failed to submit: ' || errbuf);
2848: return;
2849: ELSE