DBA Data[Home] [Help]

APPS.AR_LATE_CHARGE_PKG dependencies on FND_MESSAGE

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

1000: WHEN OTHERS THEN
1001:
1002: outandlog( message => 'EXCEPTION OTHERS in call_invoice_api:'||SQLERRM);
1003: x_return_status := fnd_api.g_ret_sts_unexp_error;
1004: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1005: fnd_message.set_token('ERROR',SQLERRM);
1006: fnd_msg_pub.add;
1007:
1008: fnd_msg_pub.count_and_get(

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

1001:
1002: outandlog( message => 'EXCEPTION OTHERS in call_invoice_api:'||SQLERRM);
1003: x_return_status := fnd_api.g_ret_sts_unexp_error;
1004: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1005: fnd_message.set_token('ERROR',SQLERRM);
1006: fnd_msg_pub.add;
1007:
1008: fnd_msg_pub.count_and_get(
1009: p_encoded => fnd_api.g_false,

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

1357: FETCH c_gl_date INTO s_gl_date,
1358: s_cal_int_date;
1359: IF c_gl_date%NOTFOUND OR s_gl_date IS NULL THEN
1360: arp_standard.debug(' Late Charge Batch GL date and calculate interest date is required');
1361: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1362: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );
1363: FND_MSG_PUB.ADD;
1364: x_return_status := FND_API.G_RET_STS_ERROR;
1365: END IF;

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

1358: s_cal_int_date;
1359: IF c_gl_date%NOTFOUND OR s_gl_date IS NULL THEN
1360: arp_standard.debug(' Late Charge Batch GL date and calculate interest date is required');
1361: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1362: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );
1363: FND_MSG_PUB.ADD;
1364: x_return_status := FND_API.G_RET_STS_ERROR;
1365: END IF;
1366: IF c_gl_date%NOTFOUND OR s_cal_int_date IS NULL THEN

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

1364: x_return_status := FND_API.G_RET_STS_ERROR;
1365: END IF;
1366: IF c_gl_date%NOTFOUND OR s_cal_int_date IS NULL THEN
1367: arp_standard.debug(' Late Charge Batch calculate interest date is required');
1368: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1369: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'calculate_interest_to_date' );
1370: FND_MSG_PUB.ADD;
1371: x_return_status := FND_API.G_RET_STS_ERROR;
1372: END IF;

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

1365: END IF;
1366: IF c_gl_date%NOTFOUND OR s_cal_int_date IS NULL THEN
1367: arp_standard.debug(' Late Charge Batch calculate interest date is required');
1368: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1369: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'calculate_interest_to_date' );
1370: FND_MSG_PUB.ADD;
1371: x_return_status := FND_API.G_RET_STS_ERROR;
1372: END IF;
1373: CLOSE c_gl_date;

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

1522:
1523: outandlog( message => x_msg_data);
1524:
1525: WHEN OTHERS THEN
1526: FND_MESSAGE.Set_Name('AR','HZ_API_OTHERS_EXCEP');
1527: FND_MESSAGE.Set_Token('ERROR',SQLERRM);
1528: fnd_msg_pub.add;
1529: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1530: p_count => x_msg_count,

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

1523: outandlog( message => x_msg_data);
1524:
1525: WHEN OTHERS THEN
1526: FND_MESSAGE.Set_Name('AR','HZ_API_OTHERS_EXCEP');
1527: FND_MESSAGE.Set_Token('ERROR',SQLERRM);
1528: fnd_msg_pub.add;
1529: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1530: p_count => x_msg_count,
1531: p_data => x_msg_data );

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

1720: FETCH c_gl_date INTO s_gl_date,
1721: s_cal_int_date;
1722: IF c_gl_date%NOTFOUND OR s_gl_date IS NULL THEN
1723: arp_standard.debug(' Late Charge Batch GL date and calculate interest date is required');
1724: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1725: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );
1726: FND_MSG_PUB.ADD;
1727: x_return_status := FND_API.G_RET_STS_ERROR;
1728: END IF;

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

1721: s_cal_int_date;
1722: IF c_gl_date%NOTFOUND OR s_gl_date IS NULL THEN
1723: arp_standard.debug(' Late Charge Batch GL date and calculate interest date is required');
1724: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1725: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );
1726: FND_MSG_PUB.ADD;
1727: x_return_status := FND_API.G_RET_STS_ERROR;
1728: END IF;
1729: IF c_gl_date%NOTFOUND OR s_cal_int_date IS NULL THEN

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

1727: x_return_status := FND_API.G_RET_STS_ERROR;
1728: END IF;
1729: IF c_gl_date%NOTFOUND OR s_cal_int_date IS NULL THEN
1730: arp_standard.debug(' Late Charge Batch calculate interest date is required');
1731: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1732: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'calculate_interest_to_date' );
1733: FND_MSG_PUB.ADD;
1734: x_return_status := FND_API.G_RET_STS_ERROR;
1735: END IF;

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

1728: END IF;
1729: IF c_gl_date%NOTFOUND OR s_cal_int_date IS NULL THEN
1730: arp_standard.debug(' Late Charge Batch calculate interest date is required');
1731: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1732: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'calculate_interest_to_date' );
1733: FND_MSG_PUB.ADD;
1734: x_return_status := FND_API.G_RET_STS_ERROR;
1735: END IF;
1736: CLOSE c_gl_date;

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

1949:
1950: WHEN OTHERS THEN
1951: IF cadj%ISOPEN THEN CLOSE cadj; END IF;
1952: x_return_status := fnd_api.g_ret_sts_unexp_error;
1953: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1954: fnd_message.set_token('ERROR',SQLERRM);
1955: fnd_msg_pub.add;
1956:
1957: fnd_msg_pub.count_and_get(

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

1950: WHEN OTHERS THEN
1951: IF cadj%ISOPEN THEN CLOSE cadj; END IF;
1952: x_return_status := fnd_api.g_ret_sts_unexp_error;
1953: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1954: fnd_message.set_token('ERROR',SQLERRM);
1955: fnd_msg_pub.add;
1956:
1957: fnd_msg_pub.count_and_get(
1958: p_encoded => fnd_api.g_false,

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

2242: p_encoded => fnd_api.g_false,
2243: p_count => x_msg_count,
2244: p_data => x_msg_data);
2245: retcode := 1;
2246: outandlog('Error: ' || FND_MESSAGE.GET);
2247: log('Batch en error ' || x_msg_data);
2248: errbuf := errbuf || logerror || x_msg_data;
2249: outandlog('Aborting concurrent program execution');
2250: FND_FILE.close;

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

2249: outandlog('Aborting concurrent program execution');
2250: FND_FILE.close;
2251:
2252: WHEN OTHERS THEN
2253: outandlog('Error: ' || FND_MESSAGE.GET);
2254: log('SQL Error ' || SQLERRM);
2255: retcode := 2;
2256: errbuf := errbuf || logerror || SQLERRM;
2257: outandlog('Aborting concurrent program execution');

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

2482:
2483: x_return_status := fnd_api.g_ret_sts_success;
2484:
2485: IF p_batch_source_id IS NULL THEN
2486: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2487: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
2488: FND_MSG_PUB.ADD;
2489: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2490: ELSE

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

2483: x_return_status := fnd_api.g_ret_sts_success;
2484:
2485: IF p_batch_source_id IS NULL THEN
2486: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2487: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
2488: FND_MSG_PUB.ADD;
2489: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2490: ELSE
2491: OPEN c_batch_source;

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

2490: ELSE
2491: OPEN c_batch_source;
2492: FETCH c_batch_source INTO l_test;
2493: IF c_batch_source%NOTFOUND THEN
2494: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
2495: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_source_id' );
2496: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
2497: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_batch_sources');
2498: FND_MSG_PUB.ADD;

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

2491: OPEN c_batch_source;
2492: FETCH c_batch_source INTO l_test;
2493: IF c_batch_source%NOTFOUND THEN
2494: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
2495: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_source_id' );
2496: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
2497: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_batch_sources');
2498: FND_MSG_PUB.ADD;
2499: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;

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

2492: FETCH c_batch_source INTO l_test;
2493: IF c_batch_source%NOTFOUND THEN
2494: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
2495: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_source_id' );
2496: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
2497: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_batch_sources');
2498: FND_MSG_PUB.ADD;
2499: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2500: END IF;

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

2493: IF c_batch_source%NOTFOUND THEN
2494: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
2495: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_source_id' );
2496: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
2497: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_batch_sources');
2498: FND_MSG_PUB.ADD;
2499: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2500: END IF;
2501: CLOSE c_batch_source;

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

2507: l_CALCULATE_INTEREST_TO_DATE,
2508: l_BATCH_STATUS,
2509: l_GL_DATE;
2510: IF c%NOTFOUND THEN
2511: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
2512: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
2513: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_id' );
2514: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches');
2515: FND_MSG_PUB.ADD;

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

2508: l_BATCH_STATUS,
2509: l_GL_DATE;
2510: IF c%NOTFOUND THEN
2511: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
2512: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
2513: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_id' );
2514: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches');
2515: FND_MSG_PUB.ADD;
2516: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;

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

2509: l_GL_DATE;
2510: IF c%NOTFOUND THEN
2511: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
2512: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
2513: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_id' );
2514: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches');
2515: FND_MSG_PUB.ADD;
2516: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2517: outandlog('Interest Batch not found with the interest_batch_id :'||p_batch_id);

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

2510: IF c%NOTFOUND THEN
2511: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
2512: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
2513: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_id' );
2514: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches');
2515: FND_MSG_PUB.ADD;
2516: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2517: outandlog('Interest Batch not found with the interest_batch_id :'||p_batch_id);
2518: ELSE

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

2516: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2517: outandlog('Interest Batch not found with the interest_batch_id :'||p_batch_id);
2518: ELSE
2519: IF l_BATCH_STATUS <> 'F' OR l_BATCH_STATUS IS NULL THEN
2520: fnd_message.set_name('AR', 'AR_ONLY_VALUE_ALLOWED');
2521: fnd_message.set_token('COLUMN', 'BATCH_STATUS');
2522: fnd_message.set_token('VALUES', 'F');
2523: fnd_msg_pub.add;
2524: retcode := 2;

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

2517: outandlog('Interest Batch not found with the interest_batch_id :'||p_batch_id);
2518: ELSE
2519: IF l_BATCH_STATUS <> 'F' OR l_BATCH_STATUS IS NULL THEN
2520: fnd_message.set_name('AR', 'AR_ONLY_VALUE_ALLOWED');
2521: fnd_message.set_token('COLUMN', 'BATCH_STATUS');
2522: fnd_message.set_token('VALUES', 'F');
2523: fnd_msg_pub.add;
2524: retcode := 2;
2525: x_return_status := fnd_api.g_ret_sts_error;

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

2518: ELSE
2519: IF l_BATCH_STATUS <> 'F' OR l_BATCH_STATUS IS NULL THEN
2520: fnd_message.set_name('AR', 'AR_ONLY_VALUE_ALLOWED');
2521: fnd_message.set_token('COLUMN', 'BATCH_STATUS');
2522: fnd_message.set_token('VALUES', 'F');
2523: fnd_msg_pub.add;
2524: retcode := 2;
2525: x_return_status := fnd_api.g_ret_sts_error;
2526: outandlog('Interest Batch batch_status should be Final to import interest_batch_id :'||p_batch_id);

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

2525: x_return_status := fnd_api.g_ret_sts_error;
2526: outandlog('Interest Batch batch_status should be Final to import interest_batch_id :'||p_batch_id);
2527: END IF;
2528: IF l_CALCULATE_INTEREST_TO_DATE IS NULL THEN
2529: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2530: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'CALCULATE_INTEREST_TO_DATE' );
2531: FND_MSG_PUB.ADD;
2532: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2533: outandlog('Interest Batch calculation interest to date is mandatory interest_batch_id :'||p_batch_id);

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

2526: outandlog('Interest Batch batch_status should be Final to import interest_batch_id :'||p_batch_id);
2527: END IF;
2528: IF l_CALCULATE_INTEREST_TO_DATE IS NULL THEN
2529: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2530: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'CALCULATE_INTEREST_TO_DATE' );
2531: FND_MSG_PUB.ADD;
2532: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2533: outandlog('Interest Batch calculation interest to date is mandatory interest_batch_id :'||p_batch_id);
2534: END IF;

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

2532: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2533: outandlog('Interest Batch calculation interest to date is mandatory interest_batch_id :'||p_batch_id);
2534: END IF;
2535: IF l_GL_DATE IS NULL THEN
2536: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2537: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );
2538: FND_MSG_PUB.ADD;
2539: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2540: outandlog('Interest Batch GL date is mandatory interest_batch_id :'||p_batch_id);

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

2533: outandlog('Interest Batch calculation interest to date is mandatory interest_batch_id :'||p_batch_id);
2534: END IF;
2535: IF l_GL_DATE IS NULL THEN
2536: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2537: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );
2538: FND_MSG_PUB.ADD;
2539: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2540: outandlog('Interest Batch GL date is mandatory interest_batch_id :'||p_batch_id);
2541: END IF;

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

2539: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2540: outandlog('Interest Batch GL date is mandatory interest_batch_id :'||p_batch_id);
2541: END IF;
2542: IF l_transferred_status = 'S' THEN
2543: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2544: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status );
2545: fnd_msg_pub.add;
2546: retcode := 1;
2547: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;

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

2540: outandlog('Interest Batch GL date is mandatory interest_batch_id :'||p_batch_id);
2541: END IF;
2542: IF l_transferred_status = 'S' THEN
2543: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2544: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status );
2545: fnd_msg_pub.add;
2546: retcode := 1;
2547: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2548: outandlog('Interest Batch already successfully transferred interest_batch_id :'||p_batch_id);

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

2546: retcode := 1;
2547: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2548: outandlog('Interest Batch already successfully transferred interest_batch_id :'||p_batch_id);
2549: ELSIF l_transferred_status = 'E' THEN
2550: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2551: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status );
2552: fnd_msg_pub.add;
2553: retcode := 1;
2554: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

2547: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
2548: outandlog('Interest Batch already successfully transferred interest_batch_id :'||p_batch_id);
2549: ELSIF l_transferred_status = 'E' THEN
2550: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2551: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status );
2552: fnd_msg_pub.add;
2553: retcode := 1;
2554: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2555: outandlog('Interest Batch is in Error, please fix it before submitting interest_batch_id :'||p_batch_id);

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

2553: retcode := 1;
2554: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2555: outandlog('Interest Batch is in Error, please fix it before submitting interest_batch_id :'||p_batch_id);
2556: ELSIF l_transferred_status = 'P' THEN
2557: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2558: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status );
2559: fnd_msg_pub.add;
2560: retcode := 1;
2561: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

2554: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2555: outandlog('Interest Batch is in Error, please fix it before submitting interest_batch_id :'||p_batch_id);
2556: ELSIF l_transferred_status = 'P' THEN
2557: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2558: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status );
2559: fnd_msg_pub.add;
2560: retcode := 1;
2561: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2562: outandlog('Interest Batch is in process, can not resubmit interest_batch_id :'||p_batch_id);

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

2562: outandlog('Interest Batch is in process, can not resubmit interest_batch_id :'||p_batch_id);
2563: ELSIF l_transferred_status = 'N' THEN
2564: outandlog('Processing the batch interest_batch_id :'||p_batch_id);
2565: ELSIF l_transferred_status IS NOT NULL THEN
2566: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2567: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status);
2568: fnd_msg_pub.add;
2569: fnd_message.set_name('AR', 'AR_ONLY_VALUES_ALLOWED');
2570: fnd_message.set_token('COLUMN', 'TRANSFERRED_STATUS');

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

2563: ELSIF l_transferred_status = 'N' THEN
2564: outandlog('Processing the batch interest_batch_id :'||p_batch_id);
2565: ELSIF l_transferred_status IS NOT NULL THEN
2566: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2567: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status);
2568: fnd_msg_pub.add;
2569: fnd_message.set_name('AR', 'AR_ONLY_VALUES_ALLOWED');
2570: fnd_message.set_token('COLUMN', 'TRANSFERRED_STATUS');
2571: fnd_message.set_token('VALUES', 'P,E,N,S');

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

2565: ELSIF l_transferred_status IS NOT NULL THEN
2566: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2567: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status);
2568: fnd_msg_pub.add;
2569: fnd_message.set_name('AR', 'AR_ONLY_VALUES_ALLOWED');
2570: fnd_message.set_token('COLUMN', 'TRANSFERRED_STATUS');
2571: fnd_message.set_token('VALUES', 'P,E,N,S');
2572: fnd_msg_pub.add;
2573: retcode := 2;

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

2566: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
2567: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status);
2568: fnd_msg_pub.add;
2569: fnd_message.set_name('AR', 'AR_ONLY_VALUES_ALLOWED');
2570: fnd_message.set_token('COLUMN', 'TRANSFERRED_STATUS');
2571: fnd_message.set_token('VALUES', 'P,E,N,S');
2572: fnd_msg_pub.add;
2573: retcode := 2;
2574: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

2567: FND_MESSAGE.SET_TOKEN( 'STATUS', l_transferred_status);
2568: fnd_msg_pub.add;
2569: fnd_message.set_name('AR', 'AR_ONLY_VALUES_ALLOWED');
2570: fnd_message.set_token('COLUMN', 'TRANSFERRED_STATUS');
2571: fnd_message.set_token('VALUES', 'P,E,N,S');
2572: fnd_msg_pub.add;
2573: retcode := 2;
2574: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
2575: outandlog('Interest Batch transferred flag should be in (NULL,S,E) no other value permitted interest_batch_id :'||p_batch_id);

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

2672: p_encoded => fnd_api.g_false,
2673: p_count => x_msg_count,
2674: p_data => x_msg_data);
2675:
2676: outandlog('Error: ' || FND_MESSAGE.GET);
2677: log('Batch en error ' || x_msg_data);
2678: errbuf := errbuf || logerror || x_msg_data;
2679: outandlog('Aborting concurrent program execution');
2680: FND_FILE.close;

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

2678: errbuf := errbuf || logerror || x_msg_data;
2679: outandlog('Aborting concurrent program execution');
2680: FND_FILE.close;
2681: WHEN fnd_Api.g_exc_error THEN
2682: outandlog('Error: ' || FND_MESSAGE.GET);
2683: log('Batch en error ' || x_msg_data);
2684: errbuf := errbuf || logerror || x_msg_data;
2685: outandlog('Aborting concurrent program execution');
2686: FND_FILE.close;

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

2685: outandlog('Aborting concurrent program execution');
2686: FND_FILE.close;
2687:
2688: WHEN OTHERS THEN
2689: outandlog('Error: ' || FND_MESSAGE.GET);
2690: log('SQL Error ' || SQLERRM);
2691: retcode := 2;
2692: errbuf := errbuf || logerror || SQLERRM;
2693: outandlog('Aborting concurrent program execution');

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

2878: p_encoded => fnd_api.g_false,
2879: p_count => x_msg_count,
2880: p_data => x_msg_data);
2881: retcode := 1;
2882: outandlog('Error: ' || FND_MESSAGE.GET);
2883: log('Batch en error ' || x_msg_data);
2884: errbuf := errbuf || logerror || x_msg_data;
2885: outandlog('Aborting concurrent program execution');
2886: FND_FILE.close;

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

2885: outandlog('Aborting concurrent program execution');
2886: FND_FILE.close;
2887:
2888: WHEN OTHERS THEN
2889: outandlog('Error: ' || FND_MESSAGE.GET);
2890: log('SQL Error ' || SQLERRM);
2891: retcode := 2;
2892: errbuf := errbuf || logerror || SQLERRM;
2893: outandlog('Aborting concurrent program execution');

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

3088: log(' p_max_workers '||p_max_workers);
3089: x_return_status := fnd_api.g_ret_sts_success;
3090: IF p_interest_batch_id IS NULL THEN
3091: log('p_interest_batch_id required ');
3092: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3093: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'interest_batch_id' );
3094: FND_MSG_PUB.ADD;
3095: x_return_status := fnd_Api.G_RET_STS_ERROR;
3096: END IF;

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

3089: x_return_status := fnd_api.g_ret_sts_success;
3090: IF p_interest_batch_id IS NULL THEN
3091: log('p_interest_batch_id required ');
3092: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3093: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'interest_batch_id' );
3094: FND_MSG_PUB.ADD;
3095: x_return_status := fnd_Api.G_RET_STS_ERROR;
3096: END IF;
3097:

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

3096: END IF;
3097:
3098: IF NOT(p_max_workers > 0) THEN
3099: log('p_max_worker should be greater than 0');
3100: FND_MESSAGE.SET_NAME( 'AR', 'AR_NB_WORKER_GREATER_ZERO' );
3101: FND_MSG_PUB.ADD;
3102: x_return_status := fnd_Api.G_RET_STS_ERROR;
3103: END IF;
3104:

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

3122: worker_cpt := x_worker_list.COUNT;
3123:
3124: log('worker_cpt :'|| worker_cpt);
3125: IF NOT (worker_cpt > 0) THEN
3126: FND_MESSAGE.SET_NAME( 'AR', 'AR_NO_HEADER_TO_PROCESS' );
3127: FND_MSG_PUB.ADD;
3128: x_return_status := fnd_Api.G_RET_STS_ERROR;
3129: END IF;
3130: END IF;

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

3130: END IF;
3131: log('prepare_header_for_worker -');
3132: EXCEPTION
3133: WHEN OTHERS THEN
3134: outandlog('Error: ' || FND_MESSAGE.GET);
3135: log('SQL Error in prepare_header_for_worker' || SQLERRM);
3136: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3137: END;
3138:

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

3218:
3219: x_return_status := fnd_api.g_ret_sts_success;
3220:
3221: IF p_batch_source_id IS NULL THEN
3222: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3223: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
3224: FND_MSG_PUB.ADD;
3225: retcode := 2;
3226: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;

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

3219: x_return_status := fnd_api.g_ret_sts_success;
3220:
3221: IF p_batch_source_id IS NULL THEN
3222: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3223: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
3224: FND_MSG_PUB.ADD;
3225: retcode := 2;
3226: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3227: ELSE

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

3227: ELSE
3228: OPEN c_batch_source;
3229: FETCH c_batch_source INTO l_test;
3230: IF c_batch_source%NOTFOUND THEN
3231: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3232: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_source_id' );
3233: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
3234: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_batch_sources');
3235: FND_MSG_PUB.ADD;

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

3228: OPEN c_batch_source;
3229: FETCH c_batch_source INTO l_test;
3230: IF c_batch_source%NOTFOUND THEN
3231: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3232: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_source_id' );
3233: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
3234: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_batch_sources');
3235: FND_MSG_PUB.ADD;
3236: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;

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

3229: FETCH c_batch_source INTO l_test;
3230: IF c_batch_source%NOTFOUND THEN
3231: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3232: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_source_id' );
3233: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
3234: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_batch_sources');
3235: FND_MSG_PUB.ADD;
3236: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3237: END IF;

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

3230: IF c_batch_source%NOTFOUND THEN
3231: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3232: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_source_id' );
3233: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'batch_source_id' );
3234: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ra_batch_sources');
3235: FND_MSG_PUB.ADD;
3236: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3237: END IF;
3238: CLOSE c_batch_source;

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

3244: l_CALCULATE_INTEREST_TO_DATE,
3245: l_BATCH_STATUS,
3246: l_GL_DATE;
3247: IF c%NOTFOUND THEN
3248: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3249: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
3250: FND_MESSAGE.SET_TOKEN( 'COLUMN',p_batch_id );
3251: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches' );
3252: FND_MSG_PUB.ADD;

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

3245: l_BATCH_STATUS,
3246: l_GL_DATE;
3247: IF c%NOTFOUND THEN
3248: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3249: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
3250: FND_MESSAGE.SET_TOKEN( 'COLUMN',p_batch_id );
3251: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches' );
3252: FND_MSG_PUB.ADD;
3253: x_return_status := FND_API.G_RET_STS_ERROR;

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

3246: l_GL_DATE;
3247: IF c%NOTFOUND THEN
3248: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3249: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
3250: FND_MESSAGE.SET_TOKEN( 'COLUMN',p_batch_id );
3251: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches' );
3252: FND_MSG_PUB.ADD;
3253: x_return_status := FND_API.G_RET_STS_ERROR;
3254: retcode := 2;

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

3247: IF c%NOTFOUND THEN
3248: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
3249: FND_MESSAGE.SET_TOKEN( 'FK', 'batch_id' );
3250: FND_MESSAGE.SET_TOKEN( 'COLUMN',p_batch_id );
3251: FND_MESSAGE.SET_TOKEN( 'TABLE', 'ar_interest_batches' );
3252: FND_MSG_PUB.ADD;
3253: x_return_status := FND_API.G_RET_STS_ERROR;
3254: retcode := 2;
3255: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;

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

3255: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3256: outandlog('Interest Batch not found with the interest_batch_id :'||p_batch_id);
3257: ELSE
3258: IF l_BATCH_STATUS <> 'F' OR l_BATCH_STATUS IS NULL THEN
3259: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3260: fnd_message.set_token('STATE', l_BATCH_STATUS);
3261: fnd_msg_pub.add;
3262: retcode := 2;
3263: x_return_status := fnd_api.g_ret_sts_error;

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

3256: outandlog('Interest Batch not found with the interest_batch_id :'||p_batch_id);
3257: ELSE
3258: IF l_BATCH_STATUS <> 'F' OR l_BATCH_STATUS IS NULL THEN
3259: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3260: fnd_message.set_token('STATE', l_BATCH_STATUS);
3261: fnd_msg_pub.add;
3262: retcode := 2;
3263: x_return_status := fnd_api.g_ret_sts_error;
3264: outandlog('Interest Batch batch_status should be Final to import interest_batch_id :'||p_batch_id);

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

3263: x_return_status := fnd_api.g_ret_sts_error;
3264: outandlog('Interest Batch batch_status should be Final to import interest_batch_id :'||p_batch_id);
3265: END IF;
3266: IF l_CALCULATE_INTEREST_TO_DATE IS NULL THEN
3267: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3268: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'CALCULATE_INTEREST_TO_DATE' );
3269: FND_MSG_PUB.ADD;
3270: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3271: outandlog('Interest Batch calculation interest to date is mandatory interest_batch_id :'||p_batch_id);

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

3264: outandlog('Interest Batch batch_status should be Final to import interest_batch_id :'||p_batch_id);
3265: END IF;
3266: IF l_CALCULATE_INTEREST_TO_DATE IS NULL THEN
3267: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3268: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'CALCULATE_INTEREST_TO_DATE' );
3269: FND_MSG_PUB.ADD;
3270: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3271: outandlog('Interest Batch calculation interest to date is mandatory interest_batch_id :'||p_batch_id);
3272: END IF;

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

3270: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3271: outandlog('Interest Batch calculation interest to date is mandatory interest_batch_id :'||p_batch_id);
3272: END IF;
3273: IF l_GL_DATE IS NULL THEN
3274: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3275: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );
3276: FND_MSG_PUB.ADD;
3277: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3278: outandlog('Interest Batch GL date is mandatory interest_batch_id :'||p_batch_id);

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

3271: outandlog('Interest Batch calculation interest to date is mandatory interest_batch_id :'||p_batch_id);
3272: END IF;
3273: IF l_GL_DATE IS NULL THEN
3274: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3275: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'GL_DATE' );
3276: FND_MSG_PUB.ADD;
3277: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3278: outandlog('Interest Batch GL date is mandatory interest_batch_id :'||p_batch_id);
3279: END IF;

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

3277: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3278: outandlog('Interest Batch GL date is mandatory interest_batch_id :'||p_batch_id);
3279: END IF;
3280: IF l_transferred_status = 'S' THEN
3281: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3282: fnd_message.set_token('STATE', l_BATCH_STATUS);
3283: fnd_msg_pub.add;
3284: retcode := 1;
3285: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;

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

3278: outandlog('Interest Batch GL date is mandatory interest_batch_id :'||p_batch_id);
3279: END IF;
3280: IF l_transferred_status = 'S' THEN
3281: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3282: fnd_message.set_token('STATE', l_BATCH_STATUS);
3283: fnd_msg_pub.add;
3284: retcode := 1;
3285: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3286: outandlog('Interest Batch already successfully transferred interest_batch_id :'||p_batch_id);

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

3284: retcode := 1;
3285: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3286: outandlog('Interest Batch already successfully transferred interest_batch_id :'||p_batch_id);
3287: ELSIF l_transferred_status = 'E' THEN
3288: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3289: fnd_message.set_token('STATE', l_BATCH_STATUS);
3290: fnd_msg_pub.add;
3291: retcode := 1;
3292: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

3285: x_return_status := fnd_Api.G_RET_STS_UNEXP_ERROR;
3286: outandlog('Interest Batch already successfully transferred interest_batch_id :'||p_batch_id);
3287: ELSIF l_transferred_status = 'E' THEN
3288: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3289: fnd_message.set_token('STATE', l_BATCH_STATUS);
3290: fnd_msg_pub.add;
3291: retcode := 1;
3292: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
3293: outandlog('Interest Batch is in Error, please fix it before submitting interest_batch_id :'||p_batch_id);

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

3291: retcode := 1;
3292: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
3293: outandlog('Interest Batch is in Error, please fix it before submitting interest_batch_id :'||p_batch_id);
3294: ELSIF l_transferred_status = 'P' THEN
3295: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3296: fnd_message.set_token('STATE', l_BATCH_STATUS);
3297: fnd_msg_pub.add;
3298: retcode := 1;
3299: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

3292: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
3293: outandlog('Interest Batch is in Error, please fix it before submitting interest_batch_id :'||p_batch_id);
3294: ELSIF l_transferred_status = 'P' THEN
3295: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3296: fnd_message.set_token('STATE', l_BATCH_STATUS);
3297: fnd_msg_pub.add;
3298: retcode := 1;
3299: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
3300: outandlog('Interest Batch is in process, can not resubmit interest_batch_id :'||p_batch_id);

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

3300: outandlog('Interest Batch is in process, can not resubmit interest_batch_id :'||p_batch_id);
3301: ELSIF l_transferred_status = 'N' THEN
3302: outandlog('Processing the batch interest_batch_id :'||p_batch_id);
3303: ELSIF l_transferred_status IS NOT NULL THEN
3304: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3305: fnd_message.set_token('STATE', l_BATCH_STATUS);
3306: fnd_msg_pub.add;
3307: retcode := 2;
3308: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

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

3301: ELSIF l_transferred_status = 'N' THEN
3302: outandlog('Processing the batch interest_batch_id :'||p_batch_id);
3303: ELSIF l_transferred_status IS NOT NULL THEN
3304: fnd_message.set_name('AR', 'AR_INT_BATCH_STATUS');
3305: fnd_message.set_token('STATE', l_BATCH_STATUS);
3306: fnd_msg_pub.add;
3307: retcode := 2;
3308: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
3309: outandlog('Interest Batch transferred flag should be in (NULL,S,E) no other value permitted interest_batch_id :'||p_batch_id);

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

3443: p_encoded => fnd_api.g_false,
3444: p_count => x_msg_count,
3445: p_data => x_msg_data);
3446:
3447: outandlog('Error: ' || FND_MESSAGE.GET);
3448: log('Batch en error ' || x_msg_data);
3449: errbuf := errbuf || logerror || x_msg_data;
3450: outandlog('Aborting concurrent program execution');
3451: END IF;

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

3457: p_encoded => fnd_api.g_false,
3458: p_count => x_msg_count,
3459: p_data => x_msg_data);
3460:
3461: outandlog('Error: ' || FND_MESSAGE.GET);
3462: log('Batch en error ' || x_msg_data);
3463: errbuf := errbuf || logerror || x_msg_data;
3464: outandlog('Aborting concurrent program execution');
3465: FND_FILE.close;

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

3463: errbuf := errbuf || logerror || x_msg_data;
3464: outandlog('Aborting concurrent program execution');
3465: FND_FILE.close;
3466: WHEN fnd_Api.g_exc_error THEN
3467: outandlog('Error: ' || FND_MESSAGE.GET);
3468: log('Batch en error ' || x_msg_data);
3469: errbuf := errbuf || logerror || x_msg_data;
3470: outandlog('Aborting concurrent program execution');
3471: FND_FILE.close;

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

3470: outandlog('Aborting concurrent program execution');
3471: FND_FILE.close;
3472:
3473: WHEN OTHERS THEN
3474: outandlog('Error: ' || FND_MESSAGE.GET);
3475: log('SQL Error ' || SQLERRM);
3476: retcode := 2;
3477: errbuf := errbuf || logerror || SQLERRM;
3478: outandlog('Aborting concurrent program execution');