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.AR_LATE_CHARGE_PKG dependencies on FND_MESSAGE

Line 491: fnd_message.set_name('AR', 'AR_LATE_CHRGE_INTRST_INV_IMPRT'); /Bug 11737619/

487: iv_dist_cpt := iv_trx_dist_tbl.COUNT;
488: iv_salescredits_cpt := iv_trx_salescredits_tbl.COUNT;
489: iv_line_num := 0;
490:
491: fnd_message.set_name('AR', 'AR_LATE_CHRGE_INTRST_INV_IMPRT'); /*Bug 11737619*/
492: l_comments := fnd_message.get; /*Bug 11737619*/
493:
494: FOR i IN iv_interest_line_id.FIRST .. iv_interest_line_id.LAST LOOP
495:

Line 492: l_comments := fnd_message.get; /Bug 11737619/

488: iv_salescredits_cpt := iv_trx_salescredits_tbl.COUNT;
489: iv_line_num := 0;
490:
491: fnd_message.set_name('AR', 'AR_LATE_CHRGE_INTRST_INV_IMPRT'); /*Bug 11737619*/
492: l_comments := fnd_message.get; /*Bug 11737619*/
493:
494: FOR i IN iv_interest_line_id.FIRST .. iv_interest_line_id.LAST LOOP
495:
496:

Line 1032: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

1028: ar_late_charge_pkg.g_invoice_api_called_from_lc := 'N';
1029:
1030: outandlog( message => 'EXCEPTION OTHERS in call_invoice_api:'||SQLERRM);
1031: x_return_status := fnd_api.g_ret_sts_unexp_error;
1032: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1033: fnd_message.set_token('ERROR',SQLERRM);
1034: fnd_msg_pub.add;
1035:
1036: fnd_msg_pub.count_and_get(

Line 1033: fnd_message.set_token('ERROR',SQLERRM);

1029:
1030: outandlog( message => 'EXCEPTION OTHERS in call_invoice_api:'||SQLERRM);
1031: x_return_status := fnd_api.g_ret_sts_unexp_error;
1032: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1033: fnd_message.set_token('ERROR',SQLERRM);
1034: fnd_msg_pub.add;
1035:
1036: fnd_msg_pub.count_and_get(
1037: p_encoded => fnd_api.g_false,

Line 1396: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

1392: FETCH c_gl_date INTO s_gl_date,
1393: s_cal_int_date;
1394: IF c_gl_date%NOTFOUND OR s_gl_date IS NULL THEN
1395: arp_standard.debug(' Late Charge Batch GL date and calculate interest date is required');
1396: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1397: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );
1398: FND_MSG_PUB.ADD;
1399: x_return_status := FND_API.G_RET_STS_ERROR;
1400: END IF;

Line 1397: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );

1393: s_cal_int_date;
1394: IF c_gl_date%NOTFOUND OR s_gl_date IS NULL THEN
1395: arp_standard.debug(' Late Charge Batch GL date and calculate interest date is required');
1396: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1397: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );
1398: FND_MSG_PUB.ADD;
1399: x_return_status := FND_API.G_RET_STS_ERROR;
1400: END IF;
1401: IF c_gl_date%NOTFOUND OR s_cal_int_date IS NULL THEN

Line 1403: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

1399: x_return_status := FND_API.G_RET_STS_ERROR;
1400: END IF;
1401: IF c_gl_date%NOTFOUND OR s_cal_int_date IS NULL THEN
1402: arp_standard.debug(' Late Charge Batch calculate interest date is required');
1403: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1404: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'calculate_interest_to_date' );
1405: FND_MSG_PUB.ADD;
1406: x_return_status := FND_API.G_RET_STS_ERROR;
1407: END IF;

Line 1404: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'calculate_interest_to_date' );

1400: END IF;
1401: IF c_gl_date%NOTFOUND OR s_cal_int_date IS NULL THEN
1402: arp_standard.debug(' Late Charge Batch calculate interest date is required');
1403: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1404: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'calculate_interest_to_date' );
1405: FND_MSG_PUB.ADD;
1406: x_return_status := FND_API.G_RET_STS_ERROR;
1407: END IF;
1408: CLOSE c_gl_date;

Line 1561: FND_MESSAGE.Set_Name('AR','HZ_API_OTHERS_EXCEP');

1557:
1558: outandlog( message => x_msg_data);
1559:
1560: WHEN OTHERS THEN
1561: FND_MESSAGE.Set_Name('AR','HZ_API_OTHERS_EXCEP');
1562: FND_MESSAGE.Set_Token('ERROR',SQLERRM);
1563: fnd_msg_pub.add;
1564: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1565: p_count => x_msg_count,

Line 1562: FND_MESSAGE.Set_Token('ERROR',SQLERRM);

1558: outandlog( message => x_msg_data);
1559:
1560: WHEN OTHERS THEN
1561: FND_MESSAGE.Set_Name('AR','HZ_API_OTHERS_EXCEP');
1562: FND_MESSAGE.Set_Token('ERROR',SQLERRM);
1563: fnd_msg_pub.add;
1564: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1565: p_count => x_msg_count,
1566: p_data => x_msg_data );

Line 1764: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

1760: FETCH c_gl_date INTO s_gl_date,
1761: s_cal_int_date;
1762: IF c_gl_date%NOTFOUND OR s_gl_date IS NULL THEN
1763: arp_standard.debug(' Late Charge Batch GL date and calculate interest date is required');
1764: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1765: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );
1766: FND_MSG_PUB.ADD;
1767: x_return_status := FND_API.G_RET_STS_ERROR;
1768: END IF;

Line 1765: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );

1761: s_cal_int_date;
1762: IF c_gl_date%NOTFOUND OR s_gl_date IS NULL THEN
1763: arp_standard.debug(' Late Charge Batch GL date and calculate interest date is required');
1764: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1765: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );
1766: FND_MSG_PUB.ADD;
1767: x_return_status := FND_API.G_RET_STS_ERROR;
1768: END IF;
1769: IF c_gl_date%NOTFOUND OR s_cal_int_date IS NULL THEN

Line 1771: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

1767: x_return_status := FND_API.G_RET_STS_ERROR;
1768: END IF;
1769: IF c_gl_date%NOTFOUND OR s_cal_int_date IS NULL THEN
1770: arp_standard.debug(' Late Charge Batch calculate interest date is required');
1771: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1772: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'calculate_interest_to_date' );
1773: FND_MSG_PUB.ADD;
1774: x_return_status := FND_API.G_RET_STS_ERROR;
1775: END IF;

Line 1772: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'calculate_interest_to_date' );

1768: END IF;
1769: IF c_gl_date%NOTFOUND OR s_cal_int_date IS NULL THEN
1770: arp_standard.debug(' Late Charge Batch calculate interest date is required');
1771: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1772: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'calculate_interest_to_date' );
1773: FND_MSG_PUB.ADD;
1774: x_return_status := FND_API.G_RET_STS_ERROR;
1775: END IF;
1776: CLOSE c_gl_date;

Line 1993: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

1989:
1990: WHEN OTHERS THEN
1991: IF cadj%ISOPEN THEN CLOSE cadj; END IF;
1992: x_return_status := fnd_api.g_ret_sts_unexp_error;
1993: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1994: fnd_message.set_token('ERROR',SQLERRM);
1995: fnd_msg_pub.add;
1996:
1997: fnd_msg_pub.count_and_get(

Line 1994: fnd_message.set_token('ERROR',SQLERRM);

1990: WHEN OTHERS THEN
1991: IF cadj%ISOPEN THEN CLOSE cadj; END IF;
1992: x_return_status := fnd_api.g_ret_sts_unexp_error;
1993: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1994: fnd_message.set_token('ERROR',SQLERRM);
1995: fnd_msg_pub.add;
1996:
1997: fnd_msg_pub.count_and_get(
1998: p_encoded => fnd_api.g_false,

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

2282: p_encoded => fnd_api.g_false,
2283: p_count => x_msg_count,
2284: p_data => x_msg_data);
2285: retcode := 1;
2286: outandlog('Error: ' || FND_MESSAGE.GET);
2287: log('Batch en error ' || x_msg_data);
2288: errbuf := errbuf || logerror || x_msg_data;
2289: outandlog('Aborting concurrent program execution');
2290: FND_FILE.close;

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

2289: outandlog('Aborting concurrent program execution');
2290: FND_FILE.close;
2291:
2292: WHEN OTHERS THEN
2293: outandlog('Error: ' || FND_MESSAGE.GET);
2294: log('SQL Error ' || SQLERRM);
2295: retcode := 2;
2296: errbuf := errbuf || logerror || SQLERRM;
2297: outandlog('Aborting concurrent program execution');

Line 2526: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

2522:
2523: x_return_status := fnd_api.g_ret_sts_success;
2524:
2525: IF p_batch_source_id IS NULL THEN
2526: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2527: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
2528: FND_MSG_PUB.ADD;
2529: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2530: ELSE

Line 2527: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );

2523: x_return_status := fnd_api.g_ret_sts_success;
2524:
2525: IF p_batch_source_id IS NULL THEN
2526: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2527: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
2528: FND_MSG_PUB.ADD;
2529: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2530: ELSE
2531: OPEN c_batch_source;

Line 2534: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );

2530: ELSE
2531: OPEN c_batch_source;
2532: FETCH c_batch_source INTO l_test;
2533: IF c_batch_source%NOTFOUND THEN
2534: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
2535: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_source_id' );
2536: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
2537: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_batch_sources');
2538: FND_MSG_PUB.ADD;

Line 2535: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_source_id' );

2531: OPEN c_batch_source;
2532: FETCH c_batch_source INTO l_test;
2533: IF c_batch_source%NOTFOUND THEN
2534: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
2535: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_source_id' );
2536: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
2537: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_batch_sources');
2538: FND_MSG_PUB.ADD;
2539: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 2536: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );

2532: FETCH c_batch_source INTO l_test;
2533: IF c_batch_source%NOTFOUND THEN
2534: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
2535: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_source_id' );
2536: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
2537: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_batch_sources');
2538: FND_MSG_PUB.ADD;
2539: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2540: END IF;

Line 2537: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_batch_sources');

2533: IF c_batch_source%NOTFOUND THEN
2534: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
2535: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_source_id' );
2536: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
2537: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_batch_sources');
2538: FND_MSG_PUB.ADD;
2539: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2540: END IF;
2541: CLOSE c_batch_source;

Line 2551: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );

2547: l_CALCULATE_INTEREST_TO_DATE,
2548: l_BATCH_STATUS,
2549: l_GL_DATE;
2550: IF c%NOTFOUND THEN
2551: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
2552: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
2553: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_id' );
2554: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches');
2555: FND_MSG_PUB.ADD;

Line 2552: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );

2548: l_BATCH_STATUS,
2549: l_GL_DATE;
2550: IF c%NOTFOUND THEN
2551: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
2552: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
2553: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_id' );
2554: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches');
2555: FND_MSG_PUB.ADD;
2556: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 2553: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_id' );

2549: l_GL_DATE;
2550: IF c%NOTFOUND THEN
2551: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
2552: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
2553: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_id' );
2554: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches');
2555: FND_MSG_PUB.ADD;
2556: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2557: outandlog('Interest Batch not found with the interest_batch_id :'||p_batch_id);

Line 2554: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches');

2550: IF c%NOTFOUND THEN
2551: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
2552: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
2553: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_id' );
2554: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches');
2555: FND_MSG_PUB.ADD;
2556: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2557: outandlog('Interest Batch not found with the interest_batch_id :'||p_batch_id);
2558: ELSE

Line 2560: fnd_message.set_name('AR', 'AR_ONLY_VALUE_ALLOWED');

2556: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2557: outandlog('Interest Batch not found with the interest_batch_id :'||p_batch_id);
2558: ELSE
2559: IF l_BATCH_STATUS <> 'F' OR l_BATCH_STATUS IS NULL THEN
2560: fnd_message.set_name('AR', 'AR_ONLY_VALUE_ALLOWED');
2561: fnd_message.set_token('COLUMN', 'BATCH_STATUS');
2562: fnd_message.set_token('VALUES', 'F');
2563: fnd_msg_pub.add;
2564: retcode := 2;

Line 2561: fnd_message.set_token('COLUMN', 'BATCH_STATUS');

2557: outandlog('Interest Batch not found with the interest_batch_id :'||p_batch_id);
2558: ELSE
2559: IF l_BATCH_STATUS <> 'F' OR l_BATCH_STATUS IS NULL THEN
2560: fnd_message.set_name('AR', 'AR_ONLY_VALUE_ALLOWED');
2561: fnd_message.set_token('COLUMN', 'BATCH_STATUS');
2562: fnd_message.set_token('VALUES', 'F');
2563: fnd_msg_pub.add;
2564: retcode := 2;
2565: x_return_status := fnd_api.g_ret_sts_error;

Line 2562: fnd_message.set_token('VALUES', 'F');

2558: ELSE
2559: IF l_BATCH_STATUS <> 'F' OR l_BATCH_STATUS IS NULL THEN
2560: fnd_message.set_name('AR', 'AR_ONLY_VALUE_ALLOWED');
2561: fnd_message.set_token('COLUMN', 'BATCH_STATUS');
2562: fnd_message.set_token('VALUES', 'F');
2563: fnd_msg_pub.add;
2564: retcode := 2;
2565: x_return_status := fnd_api.g_ret_sts_error;
2566: outandlog('Interest Batch batch_status should be Final to import interest_batch_id :'||p_batch_id);

Line 2569: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

2565: x_return_status := fnd_api.g_ret_sts_error;
2566: outandlog('Interest Batch batch_status should be Final to import interest_batch_id :'||p_batch_id);
2567: END IF;
2568: IF l_CALCULATE_INTEREST_TO_DATE IS NULL THEN
2569: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2570: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'CALCULATE_INTEREST_TO_DATE' );
2571: FND_MSG_PUB.ADD;
2572: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2573: outandlog('Interest Batch calculation interest to date is mandatory interest_batch_id :'||p_batch_id);

Line 2570: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'CALCULATE_INTEREST_TO_DATE' );

2566: outandlog('Interest Batch batch_status should be Final to import interest_batch_id :'||p_batch_id);
2567: END IF;
2568: IF l_CALCULATE_INTEREST_TO_DATE IS NULL THEN
2569: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2570: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'CALCULATE_INTEREST_TO_DATE' );
2571: FND_MSG_PUB.ADD;
2572: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2573: outandlog('Interest Batch calculation interest to date is mandatory interest_batch_id :'||p_batch_id);
2574: END IF;

Line 2576: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

2572: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2573: outandlog('Interest Batch calculation interest to date is mandatory interest_batch_id :'||p_batch_id);
2574: END IF;
2575: IF l_GL_DATE IS NULL THEN
2576: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2577: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );
2578: FND_MSG_PUB.ADD;
2579: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2580: outandlog('Interest Batch GL date is mandatory interest_batch_id :'||p_batch_id);

Line 2577: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );

2573: outandlog('Interest Batch calculation interest to date is mandatory interest_batch_id :'||p_batch_id);
2574: END IF;
2575: IF l_GL_DATE IS NULL THEN
2576: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2577: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );
2578: FND_MSG_PUB.ADD;
2579: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2580: outandlog('Interest Batch GL date is mandatory interest_batch_id :'||p_batch_id);
2581: END IF;

Line 2583: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');

2579: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2580: outandlog('Interest Batch GL date is mandatory interest_batch_id :'||p_batch_id);
2581: END IF;
2582: IF l_transferred_status = 'S' THEN
2583: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2584: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status );
2585: fnd_msg_pub.add;
2586: retcode := 1;
2587: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 2584: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status );

2580: outandlog('Interest Batch GL date is mandatory interest_batch_id :'||p_batch_id);
2581: END IF;
2582: IF l_transferred_status = 'S' THEN
2583: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2584: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status );
2585: fnd_msg_pub.add;
2586: retcode := 1;
2587: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2588: outandlog('Interest Batch already successfully transferred interest_batch_id :'||p_batch_id);

Line 2590: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');

2586: retcode := 1;
2587: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2588: outandlog('Interest Batch already successfully transferred interest_batch_id :'||p_batch_id);
2589: ELSIF l_transferred_status = 'E' THEN
2590: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2591: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status );
2592: fnd_msg_pub.add;
2593: retcode := 1;
2594: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

Line 2591: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status );

2587: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2588: outandlog('Interest Batch already successfully transferred interest_batch_id :'||p_batch_id);
2589: ELSIF l_transferred_status = 'E' THEN
2590: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2591: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status );
2592: fnd_msg_pub.add;
2593: retcode := 1;
2594: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2595: outandlog('Interest Batch is in Error, please fix it before submitting interest_batch_id :'||p_batch_id);

Line 2597: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');

2593: retcode := 1;
2594: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2595: outandlog('Interest Batch is in Error, please fix it before submitting interest_batch_id :'||p_batch_id);
2596: ELSIF l_transferred_status = 'P' THEN
2597: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2598: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status );
2599: fnd_msg_pub.add;
2600: retcode := 1;
2601: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

Line 2598: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status );

2594: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2595: outandlog('Interest Batch is in Error, please fix it before submitting interest_batch_id :'||p_batch_id);
2596: ELSIF l_transferred_status = 'P' THEN
2597: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2598: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status );
2599: fnd_msg_pub.add;
2600: retcode := 1;
2601: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2602: outandlog('Interest Batch is in process, can not resubmit interest_batch_id :'||p_batch_id);

Line 2606: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');

2602: outandlog('Interest Batch is in process, can not resubmit interest_batch_id :'||p_batch_id);
2603: ELSIF l_transferred_status = 'N' THEN
2604: outandlog('Processing the batch interest_batch_id :'||p_batch_id);
2605: ELSIF l_transferred_status IS NOT NULL THEN
2606: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2607: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status);
2608: fnd_msg_pub.add;
2609: fnd_message.set_name('AR', 'AR_ONLY_VALUES_ALLOWED');
2610: fnd_message.set_token('COLUMN', 'TRANSFERRED_STATUS');

Line 2607: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status);

2603: ELSIF l_transferred_status = 'N' THEN
2604: outandlog('Processing the batch interest_batch_id :'||p_batch_id);
2605: ELSIF l_transferred_status IS NOT NULL THEN
2606: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2607: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status);
2608: fnd_msg_pub.add;
2609: fnd_message.set_name('AR', 'AR_ONLY_VALUES_ALLOWED');
2610: fnd_message.set_token('COLUMN', 'TRANSFERRED_STATUS');
2611: fnd_message.set_token('VALUES', 'P,E,N,S');

Line 2609: fnd_message.set_name('AR', 'AR_ONLY_VALUES_ALLOWED');

2605: ELSIF l_transferred_status IS NOT NULL THEN
2606: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2607: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status);
2608: fnd_msg_pub.add;
2609: fnd_message.set_name('AR', 'AR_ONLY_VALUES_ALLOWED');
2610: fnd_message.set_token('COLUMN', 'TRANSFERRED_STATUS');
2611: fnd_message.set_token('VALUES', 'P,E,N,S');
2612: fnd_msg_pub.add;
2613: retcode := 2;

Line 2610: fnd_message.set_token('COLUMN', 'TRANSFERRED_STATUS');

2606: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2607: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status);
2608: fnd_msg_pub.add;
2609: fnd_message.set_name('AR', 'AR_ONLY_VALUES_ALLOWED');
2610: fnd_message.set_token('COLUMN', 'TRANSFERRED_STATUS');
2611: fnd_message.set_token('VALUES', 'P,E,N,S');
2612: fnd_msg_pub.add;
2613: retcode := 2;
2614: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

Line 2611: fnd_message.set_token('VALUES', 'P,E,N,S');

2607: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status);
2608: fnd_msg_pub.add;
2609: fnd_message.set_name('AR', 'AR_ONLY_VALUES_ALLOWED');
2610: fnd_message.set_token('COLUMN', 'TRANSFERRED_STATUS');
2611: fnd_message.set_token('VALUES', 'P,E,N,S');
2612: fnd_msg_pub.add;
2613: retcode := 2;
2614: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2615: outandlog('Interest Batch transferred flag should be in (NULL,S,E) no other value permitted interest_batch_id :'||p_batch_id);

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

2712: p_encoded => fnd_api.g_false,
2713: p_count => x_msg_count,
2714: p_data => x_msg_data);
2715:
2716: outandlog('Error: ' || FND_MESSAGE.GET);
2717: log('Batch en error ' || x_msg_data);
2718: errbuf := errbuf || logerror || x_msg_data;
2719: outandlog('Aborting concurrent program execution');
2720: FND_FILE.close;

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

2718: errbuf := errbuf || logerror || x_msg_data;
2719: outandlog('Aborting concurrent program execution');
2720: FND_FILE.close;
2721: WHEN fnd_Api.g_exc_error THEN
2722: outandlog('Error: ' || FND_MESSAGE.GET);
2723: log('Batch en error ' || x_msg_data);
2724: errbuf := errbuf || logerror || x_msg_data;
2725: outandlog('Aborting concurrent program execution');
2726: FND_FILE.close;

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

2725: outandlog('Aborting concurrent program execution');
2726: FND_FILE.close;
2727:
2728: WHEN OTHERS THEN
2729: outandlog('Error: ' || FND_MESSAGE.GET);
2730: log('SQL Error ' || SQLERRM);
2731: retcode := 2;
2732: errbuf := errbuf || logerror || SQLERRM;
2733: outandlog('Aborting concurrent program execution');

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

2918: p_encoded => fnd_api.g_false,
2919: p_count => x_msg_count,
2920: p_data => x_msg_data);
2921: retcode := 1;
2922: outandlog('Error: ' || FND_MESSAGE.GET);
2923: log('Batch en error ' || x_msg_data);
2924: errbuf := errbuf || logerror || x_msg_data;
2925: outandlog('Aborting concurrent program execution');
2926: FND_FILE.close;

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

2925: outandlog('Aborting concurrent program execution');
2926: FND_FILE.close;
2927:
2928: WHEN OTHERS THEN
2929: outandlog('Error: ' || FND_MESSAGE.GET);
2930: log('SQL Error ' || SQLERRM);
2931: retcode := 2;
2932: errbuf := errbuf || logerror || SQLERRM;
2933: outandlog('Aborting concurrent program execution');

Line 3132: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

3128: log(' p_max_workers '||p_max_workers);
3129: x_return_status := fnd_api.g_ret_sts_success;
3130: IF p_interest_batch_id IS NULL THEN
3131: log('p_interest_batch_id required ');
3132: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3133: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'interest_batch_id' );
3134: FND_MSG_PUB.ADD;
3135: x_return_status := fnd_Api.G_RET_STS_ERROR;
3136: END IF;

Line 3133: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'interest_batch_id' );

3129: x_return_status := fnd_api.g_ret_sts_success;
3130: IF p_interest_batch_id IS NULL THEN
3131: log('p_interest_batch_id required ');
3132: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3133: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'interest_batch_id' );
3134: FND_MSG_PUB.ADD;
3135: x_return_status := fnd_Api.G_RET_STS_ERROR;
3136: END IF;
3137:

Line 3140: FND_MESSAGE.SET_NAME( 'AR', 'AR_NB_WORKER_GREATER_ZERO' );

3136: END IF;
3137:
3138: IF NOT(p_max_workers > 0) THEN
3139: log('p_max_worker should be greater than 0');
3140: FND_MESSAGE.SET_NAME( 'AR', 'AR_NB_WORKER_GREATER_ZERO' );
3141: FND_MSG_PUB.ADD;
3142: x_return_status := fnd_Api.G_RET_STS_ERROR;
3143: END IF;
3144:

Line 3166: FND_MESSAGE.SET_NAME( 'AR', 'AR_NO_HEADER_TO_PROCESS' );

3162: worker_cpt := x_worker_list.COUNT;
3163:
3164: log('worker_cpt :'|| worker_cpt);
3165: IF NOT (worker_cpt > 0) THEN
3166: FND_MESSAGE.SET_NAME( 'AR', 'AR_NO_HEADER_TO_PROCESS' );
3167: FND_MSG_PUB.ADD;
3168: x_return_status := fnd_Api.G_RET_STS_ERROR;
3169: END IF;
3170: END IF;

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

3170: END IF;
3171: log('prepare_header_for_worker -');
3172: EXCEPTION
3173: WHEN OTHERS THEN
3174: outandlog('Error: ' || FND_MESSAGE.GET);
3175: log('SQL Error in prepare_header_for_worker' || SQLERRM);
3176: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3177: END;
3178:

Line 3262: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

3258:
3259: x_return_status := fnd_api.g_ret_sts_success;
3260:
3261: IF p_batch_source_id IS NULL THEN
3262: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3263: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
3264: FND_MSG_PUB.ADD;
3265: retcode := 2;
3266: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 3263: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );

3259: x_return_status := fnd_api.g_ret_sts_success;
3260:
3261: IF p_batch_source_id IS NULL THEN
3262: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3263: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
3264: FND_MSG_PUB.ADD;
3265: retcode := 2;
3266: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3267: ELSE

Line 3271: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );

3267: ELSE
3268: OPEN c_batch_source;
3269: FETCH c_batch_source INTO l_test;
3270: IF c_batch_source%NOTFOUND THEN
3271: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3272: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_source_id' );
3273: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
3274: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_batch_sources');
3275: FND_MSG_PUB.ADD;

Line 3272: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_source_id' );

3268: OPEN c_batch_source;
3269: FETCH c_batch_source INTO l_test;
3270: IF c_batch_source%NOTFOUND THEN
3271: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3272: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_source_id' );
3273: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
3274: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_batch_sources');
3275: FND_MSG_PUB.ADD;
3276: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 3273: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );

3269: FETCH c_batch_source INTO l_test;
3270: IF c_batch_source%NOTFOUND THEN
3271: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3272: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_source_id' );
3273: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
3274: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_batch_sources');
3275: FND_MSG_PUB.ADD;
3276: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3277: END IF;

Line 3274: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_batch_sources');

3270: IF c_batch_source%NOTFOUND THEN
3271: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3272: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_source_id' );
3273: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
3274: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_batch_sources');
3275: FND_MSG_PUB.ADD;
3276: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3277: END IF;
3278: CLOSE c_batch_source;

Line 3288: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );

3284: l_CALCULATE_INTEREST_TO_DATE,
3285: l_BATCH_STATUS,
3286: l_GL_DATE;
3287: IF c%NOTFOUND THEN
3288: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3289: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
3290: FND_MESSAGE.SET_TOKEN( 'COLUMN',p_batch_id );
3291: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches' );
3292: FND_MSG_PUB.ADD;

Line 3289: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );

3285: l_BATCH_STATUS,
3286: l_GL_DATE;
3287: IF c%NOTFOUND THEN
3288: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3289: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
3290: FND_MESSAGE.SET_TOKEN( 'COLUMN',p_batch_id );
3291: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches' );
3292: FND_MSG_PUB.ADD;
3293: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3290: FND_MESSAGE.SET_TOKEN( 'COLUMN',p_batch_id );

3286: l_GL_DATE;
3287: IF c%NOTFOUND THEN
3288: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3289: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
3290: FND_MESSAGE.SET_TOKEN( 'COLUMN',p_batch_id );
3291: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches' );
3292: FND_MSG_PUB.ADD;
3293: x_return_status := FND_API.G_RET_STS_ERROR;
3294: retcode := 2;

Line 3291: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches' );

3287: IF c%NOTFOUND THEN
3288: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3289: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
3290: FND_MESSAGE.SET_TOKEN( 'COLUMN',p_batch_id );
3291: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches' );
3292: FND_MSG_PUB.ADD;
3293: x_return_status := FND_API.G_RET_STS_ERROR;
3294: retcode := 2;
3295: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 3299: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');

3295: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3296: outandlog('Interest Batch not found with the interest_batch_id :'||p_batch_id);
3297: ELSE
3298: IF l_BATCH_STATUS <> 'F' OR l_BATCH_STATUS IS NULL THEN
3299: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3300: fnd_message.set_token('STATE', l_BATCH_STATUS);
3301: fnd_msg_pub.add;
3302: retcode := 2;
3303: x_return_status := fnd_api.g_ret_sts_error;

Line 3300: fnd_message.set_token('STATE', l_BATCH_STATUS);

3296: outandlog('Interest Batch not found with the interest_batch_id :'||p_batch_id);
3297: ELSE
3298: IF l_BATCH_STATUS <> 'F' OR l_BATCH_STATUS IS NULL THEN
3299: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3300: fnd_message.set_token('STATE', l_BATCH_STATUS);
3301: fnd_msg_pub.add;
3302: retcode := 2;
3303: x_return_status := fnd_api.g_ret_sts_error;
3304: outandlog('Interest Batch batch_status should be Final to import interest_batch_id :'||p_batch_id);

Line 3307: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

3303: x_return_status := fnd_api.g_ret_sts_error;
3304: outandlog('Interest Batch batch_status should be Final to import interest_batch_id :'||p_batch_id);
3305: END IF;
3306: IF l_CALCULATE_INTEREST_TO_DATE IS NULL THEN
3307: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3308: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'CALCULATE_INTEREST_TO_DATE' );
3309: FND_MSG_PUB.ADD;
3310: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3311: outandlog('Interest Batch calculation interest to date is mandatory interest_batch_id :'||p_batch_id);

Line 3308: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'CALCULATE_INTEREST_TO_DATE' );

3304: outandlog('Interest Batch batch_status should be Final to import interest_batch_id :'||p_batch_id);
3305: END IF;
3306: IF l_CALCULATE_INTEREST_TO_DATE IS NULL THEN
3307: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3308: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'CALCULATE_INTEREST_TO_DATE' );
3309: FND_MSG_PUB.ADD;
3310: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3311: outandlog('Interest Batch calculation interest to date is mandatory interest_batch_id :'||p_batch_id);
3312: END IF;

Line 3314: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

3310: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3311: outandlog('Interest Batch calculation interest to date is mandatory interest_batch_id :'||p_batch_id);
3312: END IF;
3313: IF l_GL_DATE IS NULL THEN
3314: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3315: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );
3316: FND_MSG_PUB.ADD;
3317: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3318: outandlog('Interest Batch GL date is mandatory interest_batch_id :'||p_batch_id);

Line 3315: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );

3311: outandlog('Interest Batch calculation interest to date is mandatory interest_batch_id :'||p_batch_id);
3312: END IF;
3313: IF l_GL_DATE IS NULL THEN
3314: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3315: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );
3316: FND_MSG_PUB.ADD;
3317: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3318: outandlog('Interest Batch GL date is mandatory interest_batch_id :'||p_batch_id);
3319: END IF;

Line 3321: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');

3317: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3318: outandlog('Interest Batch GL date is mandatory interest_batch_id :'||p_batch_id);
3319: END IF;
3320: IF l_transferred_status = 'S' THEN
3321: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3322: fnd_message.set_token('STATE', l_BATCH_STATUS);
3323: fnd_msg_pub.add;
3324: retcode := 1;
3325: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 3322: fnd_message.set_token('STATE', l_BATCH_STATUS);

3318: outandlog('Interest Batch GL date is mandatory interest_batch_id :'||p_batch_id);
3319: END IF;
3320: IF l_transferred_status = 'S' THEN
3321: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3322: fnd_message.set_token('STATE', l_BATCH_STATUS);
3323: fnd_msg_pub.add;
3324: retcode := 1;
3325: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3326: outandlog('Interest Batch already successfully transferred interest_batch_id :'||p_batch_id);

Line 3328: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');

3324: retcode := 1;
3325: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3326: outandlog('Interest Batch already successfully transferred interest_batch_id :'||p_batch_id);
3327: ELSIF l_transferred_status = 'E' THEN
3328: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3329: fnd_message.set_token('STATE', l_BATCH_STATUS);
3330: fnd_msg_pub.add;
3331: retcode := 1;
3332: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

Line 3329: fnd_message.set_token('STATE', l_BATCH_STATUS);

3325: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3326: outandlog('Interest Batch already successfully transferred interest_batch_id :'||p_batch_id);
3327: ELSIF l_transferred_status = 'E' THEN
3328: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3329: fnd_message.set_token('STATE', l_BATCH_STATUS);
3330: fnd_msg_pub.add;
3331: retcode := 1;
3332: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
3333: outandlog('Interest Batch is in Error, please fix it before submitting interest_batch_id :'||p_batch_id);

Line 3335: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');

3331: retcode := 1;
3332: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
3333: outandlog('Interest Batch is in Error, please fix it before submitting interest_batch_id :'||p_batch_id);
3334: ELSIF l_transferred_status = 'P' THEN
3335: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3336: fnd_message.set_token('STATE', l_BATCH_STATUS);
3337: fnd_msg_pub.add;
3338: retcode := 1;
3339: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

Line 3336: fnd_message.set_token('STATE', l_BATCH_STATUS);

3332: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
3333: outandlog('Interest Batch is in Error, please fix it before submitting interest_batch_id :'||p_batch_id);
3334: ELSIF l_transferred_status = 'P' THEN
3335: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3336: fnd_message.set_token('STATE', l_BATCH_STATUS);
3337: fnd_msg_pub.add;
3338: retcode := 1;
3339: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
3340: outandlog('Interest Batch is in process, can not resubmit interest_batch_id :'||p_batch_id);

Line 3344: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');

3340: outandlog('Interest Batch is in process, can not resubmit interest_batch_id :'||p_batch_id);
3341: ELSIF l_transferred_status = 'N' THEN
3342: outandlog('Processing the batch interest_batch_id :'||p_batch_id);
3343: ELSIF l_transferred_status IS NOT NULL THEN
3344: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3345: fnd_message.set_token('STATE', l_BATCH_STATUS);
3346: fnd_msg_pub.add;
3347: retcode := 2;
3348: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

Line 3345: fnd_message.set_token('STATE', l_BATCH_STATUS);

3341: ELSIF l_transferred_status = 'N' THEN
3342: outandlog('Processing the batch interest_batch_id :'||p_batch_id);
3343: ELSIF l_transferred_status IS NOT NULL THEN
3344: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3345: fnd_message.set_token('STATE', l_BATCH_STATUS);
3346: fnd_msg_pub.add;
3347: retcode := 2;
3348: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
3349: outandlog('Interest Batch transferred flag should be in (NULL,S,E) no other value permitted interest_batch_id :'||p_batch_id);

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

3483: p_encoded => fnd_api.g_false,
3484: p_count => x_msg_count,
3485: p_data => x_msg_data);
3486:
3487: outandlog('Error: ' || FND_MESSAGE.GET);
3488: log('Batch en error ' || x_msg_data);
3489: errbuf := errbuf || logerror || x_msg_data;
3490: outandlog('Aborting concurrent program execution');
3491: END IF;

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

3497: p_encoded => fnd_api.g_false,
3498: p_count => x_msg_count,
3499: p_data => x_msg_data);
3500:
3501: outandlog('Error: ' || FND_MESSAGE.GET);
3502: log('Batch en error ' || x_msg_data);
3503: errbuf := errbuf || logerror || x_msg_data;
3504: outandlog('Aborting concurrent program execution');
3505: FND_FILE.close;

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

3503: errbuf := errbuf || logerror || x_msg_data;
3504: outandlog('Aborting concurrent program execution');
3505: FND_FILE.close;
3506: WHEN fnd_Api.g_exc_error THEN
3507: outandlog('Error: ' || FND_MESSAGE.GET);
3508: log('Batch en error ' || x_msg_data);
3509: errbuf := errbuf || logerror || x_msg_data;
3510: outandlog('Aborting concurrent program execution');
3511: FND_FILE.close;

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

3510: outandlog('Aborting concurrent program execution');
3511: FND_FILE.close;
3512:
3513: WHEN OTHERS THEN
3514: outandlog('Error: ' || FND_MESSAGE.GET);
3515: log('SQL Error ' || SQLERRM);
3516: retcode := 2;
3517: errbuf := errbuf || logerror || SQLERRM;
3518: outandlog('Aborting concurrent program execution');