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 712: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

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

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

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

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

879: outandlog( message =>'Worker has completed successfully');
880:
881: EXCEPTION
882: WHEN maintenance_record THEN
883: outandlog('Error: ' || FND_MESSAGE.GET);
884: retcode := 1;
885: errbuf := errbuf || logerror;
886: outandlog('Aborting concurrent program execution');
887: -- FND_FILE.close;

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

887: -- FND_FILE.close;
888:
889: WHEN FND_API.G_EXC_ERROR THEN
890: ROLLBACK TO upgrade_by_request;
891: outandlog('Error: ' || FND_MESSAGE.GET);
892: retcode := 1;
893: errbuf := errbuf || logerror;
894: outandlog('Aborting concurrent program execution');
895: -- FND_FILE.close;

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

897:
898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
899: --JL raises FND api error
900: ROLLBACK TO upgrade_by_request;
901: outandlog('Error: ' || FND_MESSAGE.GET);
902: retcode := 1;
903: errbuf := errbuf || logerror;
904: outandlog('Aborting concurrent program execution');
905: -- FND_FILE.close;

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

906:
907: WHEN OTHERS THEN
908: --AR and MRC and PSA raises when others
909: ROLLBACK TO upgrade_by_request;
910: outandlog('Error: ' || FND_MESSAGE.GET);
911: log('SQL Error ' || SQLERRM);
912: retcode := 1;
913: errbuf := errbuf || logerror || SQLERRM;
914: outandlog('Aborting concurrent program execution');

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

1192: FETCH c_req INTO l_status, l_request_id;
1193: IF c_req%NOTFOUND THEN
1194: x_return_status := 'S';
1195: ELSE
1196: fnd_message.set_name('AR','AR_XLA_EXIST_REQ_ERROR');
1197: fnd_message.set_token('REQUEST_ID',l_request_id);
1198: x_return_msg := fnd_message.get;
1199: outandlog(x_return_msg);
1200: x_return_status := 'E';

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

1193: IF c_req%NOTFOUND THEN
1194: x_return_status := 'S';
1195: ELSE
1196: fnd_message.set_name('AR','AR_XLA_EXIST_REQ_ERROR');
1197: fnd_message.set_token('REQUEST_ID',l_request_id);
1198: x_return_msg := fnd_message.get;
1199: outandlog(x_return_msg);
1200: x_return_status := 'E';
1201: END IF;

Line 1198: x_return_msg := fnd_message.get;

1194: x_return_status := 'S';
1195: ELSE
1196: fnd_message.set_name('AR','AR_XLA_EXIST_REQ_ERROR');
1197: fnd_message.set_token('REQUEST_ID',l_request_id);
1198: x_return_msg := fnd_message.get;
1199: outandlog(x_return_msg);
1200: x_return_status := 'E';
1201: END IF;
1202: CLOSE c_req;

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

2013: retcode := -2;
2014: OPEN c_ledger(l_xla_upg_rec.ledger_id);
2015: FETCH c_ledger INTO l_ledger_name;
2016: CLOSE c_ledger;
2017: fnd_message.set_name('AR','AR_UNSUCCESSFUL_RUN_EXISTS');
2018: fnd_message.set_token('PERIOD' ,l_xla_upg_rec.period_name);
2019: fnd_message.set_token('LEDGER' ,l_ledger_name);
2020: fnd_message.set_token('WORKERS',l_xla_upg_rec.workers_num);
2021: fnd_message.set_token('SIZE' ,l_xla_upg_rec.batch_size);

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

2014: OPEN c_ledger(l_xla_upg_rec.ledger_id);
2015: FETCH c_ledger INTO l_ledger_name;
2016: CLOSE c_ledger;
2017: fnd_message.set_name('AR','AR_UNSUCCESSFUL_RUN_EXISTS');
2018: fnd_message.set_token('PERIOD' ,l_xla_upg_rec.period_name);
2019: fnd_message.set_token('LEDGER' ,l_ledger_name);
2020: fnd_message.set_token('WORKERS',l_xla_upg_rec.workers_num);
2021: fnd_message.set_token('SIZE' ,l_xla_upg_rec.batch_size);
2022: errbuf := fnd_message.get;

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

2015: FETCH c_ledger INTO l_ledger_name;
2016: CLOSE c_ledger;
2017: fnd_message.set_name('AR','AR_UNSUCCESSFUL_RUN_EXISTS');
2018: fnd_message.set_token('PERIOD' ,l_xla_upg_rec.period_name);
2019: fnd_message.set_token('LEDGER' ,l_ledger_name);
2020: fnd_message.set_token('WORKERS',l_xla_upg_rec.workers_num);
2021: fnd_message.set_token('SIZE' ,l_xla_upg_rec.batch_size);
2022: errbuf := fnd_message.get;
2023: outandlog(errbuf);

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

2016: CLOSE c_ledger;
2017: fnd_message.set_name('AR','AR_UNSUCCESSFUL_RUN_EXISTS');
2018: fnd_message.set_token('PERIOD' ,l_xla_upg_rec.period_name);
2019: fnd_message.set_token('LEDGER' ,l_ledger_name);
2020: fnd_message.set_token('WORKERS',l_xla_upg_rec.workers_num);
2021: fnd_message.set_token('SIZE' ,l_xla_upg_rec.batch_size);
2022: errbuf := fnd_message.get;
2023: outandlog(errbuf);
2024:

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

2017: fnd_message.set_name('AR','AR_UNSUCCESSFUL_RUN_EXISTS');
2018: fnd_message.set_token('PERIOD' ,l_xla_upg_rec.period_name);
2019: fnd_message.set_token('LEDGER' ,l_ledger_name);
2020: fnd_message.set_token('WORKERS',l_xla_upg_rec.workers_num);
2021: fnd_message.set_token('SIZE' ,l_xla_upg_rec.batch_size);
2022: errbuf := fnd_message.get;
2023: outandlog(errbuf);
2024:
2025: WHEN no_date_in_xla_tab THEN

Line 2022: errbuf := fnd_message.get;

2018: fnd_message.set_token('PERIOD' ,l_xla_upg_rec.period_name);
2019: fnd_message.set_token('LEDGER' ,l_ledger_name);
2020: fnd_message.set_token('WORKERS',l_xla_upg_rec.workers_num);
2021: fnd_message.set_token('SIZE' ,l_xla_upg_rec.batch_size);
2022: errbuf := fnd_message.get;
2023: outandlog(errbuf);
2024:
2025: WHEN no_date_in_xla_tab THEN
2026: retcode := -2;

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

2023: outandlog(errbuf);
2024:
2025: WHEN no_date_in_xla_tab THEN
2026: retcode := -2;
2027: fnd_message.set_name('AR','AR_XLA_UPGRADE_DATE_MISSING');
2028: errbuf := fnd_message.get;
2029: outandlog(errbuf);
2030:
2031: WHEN previous_run_dates_mismatch THEN

Line 2028: errbuf := fnd_message.get;

2024:
2025: WHEN no_date_in_xla_tab THEN
2026: retcode := -2;
2027: fnd_message.set_name('AR','AR_XLA_UPGRADE_DATE_MISSING');
2028: errbuf := fnd_message.get;
2029: outandlog(errbuf);
2030:
2031: WHEN previous_run_dates_mismatch THEN
2032: retcode := -2;

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

2029: outandlog(errbuf);
2030:
2031: WHEN previous_run_dates_mismatch THEN
2032: retcode := -2;
2033: fnd_message.set_name('AR','AR_XLA_UPGRADE_DATE_OVERLAP');
2034: fnd_message.set_token('START_DATE' ,l_start_date);
2035: fnd_message.set_token('END_DATE' ,l_end_date);
2036: fnd_message.set_token('EXIST_START_DATE',l_xla_upg_rec.start_date);
2037: fnd_message.set_token('EXIST_END_DATE' ,l_xla_upg_rec.end_date);

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

2030:
2031: WHEN previous_run_dates_mismatch THEN
2032: retcode := -2;
2033: fnd_message.set_name('AR','AR_XLA_UPGRADE_DATE_OVERLAP');
2034: fnd_message.set_token('START_DATE' ,l_start_date);
2035: fnd_message.set_token('END_DATE' ,l_end_date);
2036: fnd_message.set_token('EXIST_START_DATE',l_xla_upg_rec.start_date);
2037: fnd_message.set_token('EXIST_END_DATE' ,l_xla_upg_rec.end_date);
2038: errbuf := fnd_message.get;

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

2031: WHEN previous_run_dates_mismatch THEN
2032: retcode := -2;
2033: fnd_message.set_name('AR','AR_XLA_UPGRADE_DATE_OVERLAP');
2034: fnd_message.set_token('START_DATE' ,l_start_date);
2035: fnd_message.set_token('END_DATE' ,l_end_date);
2036: fnd_message.set_token('EXIST_START_DATE',l_xla_upg_rec.start_date);
2037: fnd_message.set_token('EXIST_END_DATE' ,l_xla_upg_rec.end_date);
2038: errbuf := fnd_message.get;
2039: outandlog(errbuf);

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

2032: retcode := -2;
2033: fnd_message.set_name('AR','AR_XLA_UPGRADE_DATE_OVERLAP');
2034: fnd_message.set_token('START_DATE' ,l_start_date);
2035: fnd_message.set_token('END_DATE' ,l_end_date);
2036: fnd_message.set_token('EXIST_START_DATE',l_xla_upg_rec.start_date);
2037: fnd_message.set_token('EXIST_END_DATE' ,l_xla_upg_rec.end_date);
2038: errbuf := fnd_message.get;
2039: outandlog(errbuf);
2040:

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

2033: fnd_message.set_name('AR','AR_XLA_UPGRADE_DATE_OVERLAP');
2034: fnd_message.set_token('START_DATE' ,l_start_date);
2035: fnd_message.set_token('END_DATE' ,l_end_date);
2036: fnd_message.set_token('EXIST_START_DATE',l_xla_upg_rec.start_date);
2037: fnd_message.set_token('EXIST_END_DATE' ,l_xla_upg_rec.end_date);
2038: errbuf := fnd_message.get;
2039: outandlog(errbuf);
2040:
2041: END;

Line 2038: errbuf := fnd_message.get;

2034: fnd_message.set_token('START_DATE' ,l_start_date);
2035: fnd_message.set_token('END_DATE' ,l_end_date);
2036: fnd_message.set_token('EXIST_START_DATE',l_xla_upg_rec.start_date);
2037: fnd_message.set_token('EXIST_END_DATE' ,l_xla_upg_rec.end_date);
2038: errbuf := fnd_message.get;
2039: outandlog(errbuf);
2040:
2041: END;
2042: