DBA Data[Home] [Help]

APPS.AR_UPGHARNESS_PKG dependencies on FND_MESSAGE

Line 346: log(fnd_message.get);

342: argument5 => p_batch_size,
343: argument6 => l_order_num);
344: IF l_req_id = 0 THEN
345: log('Error submitting request');
346: log(fnd_message.get);
347: l_prv_script_name := l_script_name;
348: l_prv_table_name := l_table_name;
349: UPDATE ar_submission_ctrl_gt
350: SET request_id = -9,

Line 715: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

711: x_return_msg => x_return_msg,
712: x_request_control_id => x_request_control_id);
713:
714: IF x_return_status <> 'S' THEN
715: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
716: FND_MESSAGE.SET_TOKEN( 'TEXT', x_return_msg );
717: FND_MSG_PUB.ADD;
718: RAISE maintenance_record;
719: END IF;

Line 716: FND_MESSAGE.SET_TOKEN( 'TEXT', x_return_msg );

712: x_request_control_id => x_request_control_id);
713:
714: IF x_return_status <> 'S' THEN
715: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
716: FND_MESSAGE.SET_TOKEN( 'TEXT', x_return_msg );
717: FND_MSG_PUB.ADD;
718: RAISE maintenance_record;
719: END IF;
720:

Line 925: outandlog('Error: ' || FND_MESSAGE.GET);

921: outandlog( message =>'Worker has completed successfully');
922:
923: EXCEPTION
924: WHEN maintenance_record THEN
925: outandlog('Error: ' || FND_MESSAGE.GET);
926: retcode := 1;
927: errbuf := errbuf || logerror;
928: outandlog('Aborting concurrent program execution');
929: -- FND_FILE.close;

Line 933: outandlog('Error: ' || FND_MESSAGE.GET);

929: -- FND_FILE.close;
930:
931: WHEN FND_API.G_EXC_ERROR THEN
932: ROLLBACK TO upgrade_by_request;
933: outandlog('Error: ' || FND_MESSAGE.GET);
934: retcode := 1;
935: errbuf := errbuf || logerror;
936: outandlog('Aborting concurrent program execution');
937: -- FND_FILE.close;

Line 943: outandlog('Error: ' || FND_MESSAGE.GET);

939:
940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
941: --JL raises FND api error
942: ROLLBACK TO upgrade_by_request;
943: outandlog('Error: ' || FND_MESSAGE.GET);
944: retcode := 1;
945: errbuf := errbuf || logerror;
946: outandlog('Aborting concurrent program execution');
947: -- FND_FILE.close;

Line 951: outandlog('Error: ' || FND_MESSAGE.GET);

947: -- FND_FILE.close;
948:
949: WHEN OTHERS THEN
950: --AR and MRC and PSA raises when others
951: outandlog('Error: ' || FND_MESSAGE.GET);
952: log('SQL Error ' || SQLERRM);
953: retcode := 1;
954: errbuf := errbuf || logerror || SQLERRM;
955: outandlog('Aborting concurrent program execution');

Line 1256: fnd_message.set_name('AR','AR_XLA_EXIST_REQ_ERROR');

1252: FETCH c_req INTO l_status, l_request_id;
1253: IF c_req%NOTFOUND THEN
1254: x_return_status := 'S';
1255: ELSE
1256: fnd_message.set_name('AR','AR_XLA_EXIST_REQ_ERROR');
1257: fnd_message.set_token('REQUEST_ID',l_request_id);
1258: x_return_msg := fnd_message.get;
1259: outandlog(x_return_msg);
1260: x_return_status := 'E';

Line 1257: fnd_message.set_token('REQUEST_ID',l_request_id);

1253: IF c_req%NOTFOUND THEN
1254: x_return_status := 'S';
1255: ELSE
1256: fnd_message.set_name('AR','AR_XLA_EXIST_REQ_ERROR');
1257: fnd_message.set_token('REQUEST_ID',l_request_id);
1258: x_return_msg := fnd_message.get;
1259: outandlog(x_return_msg);
1260: x_return_status := 'E';
1261: END IF;

Line 1258: x_return_msg := fnd_message.get;

1254: x_return_status := 'S';
1255: ELSE
1256: fnd_message.set_name('AR','AR_XLA_EXIST_REQ_ERROR');
1257: fnd_message.set_token('REQUEST_ID',l_request_id);
1258: x_return_msg := fnd_message.get;
1259: outandlog(x_return_msg);
1260: x_return_status := 'E';
1261: END IF;
1262: CLOSE c_req;

Line 2133: fnd_message.set_name('AR','AR_UNSUCCESSFUL_RUN_EXISTS');

2129: retcode := -2;
2130: OPEN c_ledger(l_xla_upg_rec.ledger_id);
2131: FETCH c_ledger INTO l_ledger_name;
2132: CLOSE c_ledger;
2133: fnd_message.set_name('AR','AR_UNSUCCESSFUL_RUN_EXISTS');
2134: fnd_message.set_token('PERIOD' ,l_xla_upg_rec.period_name);
2135: fnd_message.set_token('LEDGER' ,l_ledger_name);
2136: fnd_message.set_token('WORKERS',l_xla_upg_rec.workers_num);
2137: fnd_message.set_token('SIZE' ,l_xla_upg_rec.batch_size);

Line 2134: fnd_message.set_token('PERIOD' ,l_xla_upg_rec.period_name);

2130: OPEN c_ledger(l_xla_upg_rec.ledger_id);
2131: FETCH c_ledger INTO l_ledger_name;
2132: CLOSE c_ledger;
2133: fnd_message.set_name('AR','AR_UNSUCCESSFUL_RUN_EXISTS');
2134: fnd_message.set_token('PERIOD' ,l_xla_upg_rec.period_name);
2135: fnd_message.set_token('LEDGER' ,l_ledger_name);
2136: fnd_message.set_token('WORKERS',l_xla_upg_rec.workers_num);
2137: fnd_message.set_token('SIZE' ,l_xla_upg_rec.batch_size);
2138: errbuf := fnd_message.get;

Line 2135: fnd_message.set_token('LEDGER' ,l_ledger_name);

2131: FETCH c_ledger INTO l_ledger_name;
2132: CLOSE c_ledger;
2133: fnd_message.set_name('AR','AR_UNSUCCESSFUL_RUN_EXISTS');
2134: fnd_message.set_token('PERIOD' ,l_xla_upg_rec.period_name);
2135: fnd_message.set_token('LEDGER' ,l_ledger_name);
2136: fnd_message.set_token('WORKERS',l_xla_upg_rec.workers_num);
2137: fnd_message.set_token('SIZE' ,l_xla_upg_rec.batch_size);
2138: errbuf := fnd_message.get;
2139: outandlog(errbuf);

Line 2136: fnd_message.set_token('WORKERS',l_xla_upg_rec.workers_num);

2132: CLOSE c_ledger;
2133: fnd_message.set_name('AR','AR_UNSUCCESSFUL_RUN_EXISTS');
2134: fnd_message.set_token('PERIOD' ,l_xla_upg_rec.period_name);
2135: fnd_message.set_token('LEDGER' ,l_ledger_name);
2136: fnd_message.set_token('WORKERS',l_xla_upg_rec.workers_num);
2137: fnd_message.set_token('SIZE' ,l_xla_upg_rec.batch_size);
2138: errbuf := fnd_message.get;
2139: outandlog(errbuf);
2140:

Line 2137: fnd_message.set_token('SIZE' ,l_xla_upg_rec.batch_size);

2133: fnd_message.set_name('AR','AR_UNSUCCESSFUL_RUN_EXISTS');
2134: fnd_message.set_token('PERIOD' ,l_xla_upg_rec.period_name);
2135: fnd_message.set_token('LEDGER' ,l_ledger_name);
2136: fnd_message.set_token('WORKERS',l_xla_upg_rec.workers_num);
2137: fnd_message.set_token('SIZE' ,l_xla_upg_rec.batch_size);
2138: errbuf := fnd_message.get;
2139: outandlog(errbuf);
2140:
2141: WHEN no_date_in_xla_tab THEN

Line 2138: errbuf := fnd_message.get;

2134: fnd_message.set_token('PERIOD' ,l_xla_upg_rec.period_name);
2135: fnd_message.set_token('LEDGER' ,l_ledger_name);
2136: fnd_message.set_token('WORKERS',l_xla_upg_rec.workers_num);
2137: fnd_message.set_token('SIZE' ,l_xla_upg_rec.batch_size);
2138: errbuf := fnd_message.get;
2139: outandlog(errbuf);
2140:
2141: WHEN no_date_in_xla_tab THEN
2142: retcode := -2;

Line 2143: fnd_message.set_name('AR','AR_XLA_UPGRADE_DATE_MISSING');

2139: outandlog(errbuf);
2140:
2141: WHEN no_date_in_xla_tab THEN
2142: retcode := -2;
2143: fnd_message.set_name('AR','AR_XLA_UPGRADE_DATE_MISSING');
2144: errbuf := fnd_message.get;
2145: outandlog(errbuf);
2146:
2147: WHEN previous_run_dates_mismatch THEN

Line 2144: errbuf := fnd_message.get;

2140:
2141: WHEN no_date_in_xla_tab THEN
2142: retcode := -2;
2143: fnd_message.set_name('AR','AR_XLA_UPGRADE_DATE_MISSING');
2144: errbuf := fnd_message.get;
2145: outandlog(errbuf);
2146:
2147: WHEN previous_run_dates_mismatch THEN
2148: retcode := -2;

Line 2149: fnd_message.set_name('AR','AR_XLA_UPGRADE_DATE_OVERLAP');

2145: outandlog(errbuf);
2146:
2147: WHEN previous_run_dates_mismatch THEN
2148: retcode := -2;
2149: fnd_message.set_name('AR','AR_XLA_UPGRADE_DATE_OVERLAP');
2150: fnd_message.set_token('START_DATE' ,l_start_date);
2151: fnd_message.set_token('END_DATE' ,l_end_date);
2152: fnd_message.set_token('EXIST_START_DATE',l_xla_upg_rec.start_date);
2153: fnd_message.set_token('EXIST_END_DATE' ,l_xla_upg_rec.end_date);

Line 2150: fnd_message.set_token('START_DATE' ,l_start_date);

2146:
2147: WHEN previous_run_dates_mismatch THEN
2148: retcode := -2;
2149: fnd_message.set_name('AR','AR_XLA_UPGRADE_DATE_OVERLAP');
2150: fnd_message.set_token('START_DATE' ,l_start_date);
2151: fnd_message.set_token('END_DATE' ,l_end_date);
2152: fnd_message.set_token('EXIST_START_DATE',l_xla_upg_rec.start_date);
2153: fnd_message.set_token('EXIST_END_DATE' ,l_xla_upg_rec.end_date);
2154: errbuf := fnd_message.get;

Line 2151: fnd_message.set_token('END_DATE' ,l_end_date);

2147: WHEN previous_run_dates_mismatch THEN
2148: retcode := -2;
2149: fnd_message.set_name('AR','AR_XLA_UPGRADE_DATE_OVERLAP');
2150: fnd_message.set_token('START_DATE' ,l_start_date);
2151: fnd_message.set_token('END_DATE' ,l_end_date);
2152: fnd_message.set_token('EXIST_START_DATE',l_xla_upg_rec.start_date);
2153: fnd_message.set_token('EXIST_END_DATE' ,l_xla_upg_rec.end_date);
2154: errbuf := fnd_message.get;
2155: outandlog(errbuf);

Line 2152: fnd_message.set_token('EXIST_START_DATE',l_xla_upg_rec.start_date);

2148: retcode := -2;
2149: fnd_message.set_name('AR','AR_XLA_UPGRADE_DATE_OVERLAP');
2150: fnd_message.set_token('START_DATE' ,l_start_date);
2151: fnd_message.set_token('END_DATE' ,l_end_date);
2152: fnd_message.set_token('EXIST_START_DATE',l_xla_upg_rec.start_date);
2153: fnd_message.set_token('EXIST_END_DATE' ,l_xla_upg_rec.end_date);
2154: errbuf := fnd_message.get;
2155: outandlog(errbuf);
2156:

Line 2153: fnd_message.set_token('EXIST_END_DATE' ,l_xla_upg_rec.end_date);

2149: fnd_message.set_name('AR','AR_XLA_UPGRADE_DATE_OVERLAP');
2150: fnd_message.set_token('START_DATE' ,l_start_date);
2151: fnd_message.set_token('END_DATE' ,l_end_date);
2152: fnd_message.set_token('EXIST_START_DATE',l_xla_upg_rec.start_date);
2153: fnd_message.set_token('EXIST_END_DATE' ,l_xla_upg_rec.end_date);
2154: errbuf := fnd_message.get;
2155: outandlog(errbuf);
2156:
2157: END;

Line 2154: errbuf := fnd_message.get;

2150: fnd_message.set_token('START_DATE' ,l_start_date);
2151: fnd_message.set_token('END_DATE' ,l_end_date);
2152: fnd_message.set_token('EXIST_START_DATE',l_xla_upg_rec.start_date);
2153: fnd_message.set_token('EXIST_END_DATE' ,l_xla_upg_rec.end_date);
2154: errbuf := fnd_message.get;
2155: outandlog(errbuf);
2156:
2157: END;
2158: