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_MSG_PUB

Line 164: FND_MSG_PUB.Reset;

160: FUNCTION logerror(SQLERRM VARCHAR2 DEFAULT NULL)
161: RETURN VARCHAR2 IS
162: l_msg_data VARCHAR2(2000);
163: BEGIN
164: FND_MSG_PUB.Reset;
165:
166: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
167: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
168: END LOOP;

Line 166: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

162: l_msg_data VARCHAR2(2000);
163: BEGIN
164: FND_MSG_PUB.Reset;
165:
166: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
167: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
168: END LOOP;
169: IF (SQLERRM IS NOT NULL) THEN
170: l_msg_data := l_msg_data || SQLERRM;

Line 167: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

163: BEGIN
164: FND_MSG_PUB.Reset;
165:
166: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
167: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
168: END LOOP;
169: IF (SQLERRM IS NOT NULL) THEN
170: l_msg_data := l_msg_data || SQLERRM;
171: END IF;

Line 1020: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

1016: -- Error from invoice api directly out
1017: --
1018: ar_late_charge_pkg.g_invoice_api_called_from_lc := 'N';
1019:
1020: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1021: p_count => x_msg_count,
1022: p_data => x_msg_data );
1023:
1024: outandlog( message => x_msg_data);

Line 1034: fnd_msg_pub.add;

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,
1038: p_count => x_msg_count,

Line 1036: fnd_msg_pub.count_and_get(

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,
1038: p_count => x_msg_count,
1039: p_data => x_msg_data);
1040: outandlog( message => ' EXCEPTION OTHERS call_invoice_api :'||SQLERRM);

Line 1398: FND_MSG_PUB.ADD;

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
1402: arp_standard.debug(' Late Charge Batch calculate interest date is required');

Line 1405: FND_MSG_PUB.ADD;

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;
1409: ELSE

Line 1554: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

1550: outandlog( message => 'create_charge_inv_dm -');
1551:
1552: EXCEPTION
1553: WHEN FND_API.G_EXC_ERROR THEN
1554: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1555: p_count => x_msg_count,
1556: p_data => x_msg_data );
1557:
1558: outandlog( message => x_msg_data);

Line 1563: fnd_msg_pub.add;

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 );
1567: outandlog( message => x_msg_data);

Line 1564: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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 );
1567: outandlog( message => x_msg_data);
1568: END;

Line 1766: FND_MSG_PUB.ADD;

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
1770: arp_standard.debug(' Late Charge Batch calculate interest date is required');

Line 1773: FND_MSG_PUB.ADD;

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;
1777: ELSE

Line 1861: ll_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,

1857:
1858: IF l_msg_count > 1 THEN
1859: ll_msg_data := NULL;
1860: FOR cnt IN 1..l_msg_count LOOP
1861: ll_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,
1862: FND_API.G_FALSE);
1863: log(' error text : '|| ll_msg_data);
1864: l_msg_data := SUBSTRB(l_msg_data||ll_msg_data,1,2000);
1865: END LOOP;

Line 1984: fnd_msg_pub.count_and_get(

1980: WHEN no_adj_to_process THEN
1981: NULL;
1982: WHEN FND_API.G_EXC_ERROR THEN
1983: IF cadj%ISOPEN THEN CLOSE cadj; END IF;
1984: fnd_msg_pub.count_and_get(
1985: p_encoded => fnd_api.g_false,
1986: p_count => x_msg_count,
1987: p_data => x_msg_data);
1988: outandlog( message => ' EXCEPTION FND_API.G_EXC_ERROR create_charge_adj :'||x_msg_data);

Line 1995: fnd_msg_pub.add;

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,
1999: p_count => x_msg_count,

Line 1997: fnd_msg_pub.count_and_get(

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,
1999: p_count => x_msg_count,
2000: p_data => x_msg_data);
2001: outandlog( message => ' EXCEPTION OTHERS create_charge_adj :'||SQLERRM);

Line 2281: fnd_msg_pub.count_and_get(

2277:
2278: FND_FILE.close;
2279: EXCEPTION
2280: WHEN fnd_Api.g_exc_error THEN
2281: fnd_msg_pub.count_and_get(
2282: p_encoded => fnd_api.g_false,
2283: p_count => x_msg_count,
2284: p_data => x_msg_data);
2285: retcode := 1;

Line 2528: FND_MSG_PUB.ADD;

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;
2532: FETCH c_batch_source INTO l_test;

Line 2538: FND_MSG_PUB.ADD;

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;
2542: END IF;

Line 2555: FND_MSG_PUB.ADD;

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
2559: IF l_BATCH_STATUS <> 'F' OR l_BATCH_STATUS IS NULL THEN

Line 2563: fnd_msg_pub.add;

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);
2567: END IF;

Line 2571: FND_MSG_PUB.ADD;

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;
2575: IF l_GL_DATE IS NULL THEN

Line 2578: FND_MSG_PUB.ADD;

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;
2582: IF l_transferred_status = 'S' THEN

Line 2585: fnd_msg_pub.add;

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);
2589: ELSIF l_transferred_status = 'E' THEN

Line 2592: fnd_msg_pub.add;

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);
2596: ELSIF l_transferred_status = 'P' THEN

Line 2599: fnd_msg_pub.add;

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);
2603: ELSIF l_transferred_status = 'N' THEN

Line 2608: fnd_msg_pub.add;

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');
2612: fnd_msg_pub.add;

Line 2612: fnd_msg_pub.add;

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);
2616: END IF;

Line 2711: fnd_msg_pub.count_and_get(

2707: outandlog( message =>' End at ' || to_char(SYSDATE, 'HH24:MI:SS') );
2708: outandlog( message =>'End create_late_charge for the batch:'||p_batch_id||' Please check log files' );
2709: EXCEPTION
2710: WHEN fnd_Api.g_exc_unexpected_error THEN
2711: fnd_msg_pub.count_and_get(
2712: p_encoded => fnd_api.g_false,
2713: p_count => x_msg_count,
2714: p_data => x_msg_data);
2715:

Line 2917: fnd_msg_pub.count_and_get(

2913:
2914: FND_FILE.close;
2915: EXCEPTION
2916: WHEN fnd_Api.g_exc_error THEN
2917: fnd_msg_pub.count_and_get(
2918: p_encoded => fnd_api.g_false,
2919: p_count => x_msg_count,
2920: p_data => x_msg_data);
2921: retcode := 1;

Line 3060: fnd_msg_pub.initialize;

3056: g_interest_batch_id := l_interest_batch_id;
3057: g_org_id := l_org_id;
3058: g_BATCH_SOURCE_ID := l_batch_source_id;
3059:
3060: fnd_msg_pub.initialize;
3061:
3062: log('Calling create_late_charge_per_worker +');
3063:
3064: create_late_charge_per_worker

Line 3077: fnd_msg_pub.count_and_get(

3073:
3074: log('Calling create_late_charge_per_worker -');
3075: --{Message Stack
3076: IF retcode <> '0' THEN
3077: fnd_msg_pub.count_and_get(
3078: p_encoded => fnd_api.g_false,
3079: p_count => x_msg_count,
3080: p_data => x_msg_data);
3081: IF x_msg_count > 1 THEN

Line 3086: x_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);

3082: i := 0;
3083: LOOP
3084: IF i < x_msg_count THEN
3085: i := i + 1 ;
3086: x_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
3087: log(x_msg_data);
3088: ELSE
3089: EXIT;
3090: END IF;

Line 3134: FND_MSG_PUB.ADD;

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:
3138: IF NOT(p_max_workers > 0) THEN

Line 3141: FND_MSG_PUB.ADD;

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:
3145: IF x_return_status = fnd_api.g_ret_sts_success THEN

Line 3167: FND_MSG_PUB.ADD;

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;
3171: log('prepare_header_for_worker -');

Line 3264: FND_MSG_PUB.ADD;

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
3268: OPEN c_batch_source;

Line 3275: FND_MSG_PUB.ADD;

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;
3279: END IF;

Line 3292: FND_MSG_PUB.ADD;

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;
3296: outandlog('Interest Batch not found with the interest_batch_id :'||p_batch_id);

Line 3301: fnd_msg_pub.add;

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);
3305: END IF;

Line 3309: FND_MSG_PUB.ADD;

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;
3313: IF l_GL_DATE IS NULL THEN

Line 3316: FND_MSG_PUB.ADD;

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;
3320: IF l_transferred_status = 'S' THEN

Line 3323: fnd_msg_pub.add;

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);
3327: ELSIF l_transferred_status = 'E' THEN

Line 3330: fnd_msg_pub.add;

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);
3334: ELSIF l_transferred_status = 'P' THEN

Line 3337: fnd_msg_pub.add;

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);
3341: ELSIF l_transferred_status = 'N' THEN

Line 3346: fnd_msg_pub.add;

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);
3350: END IF;

Line 3482: fnd_msg_pub.count_and_get(

3478: x_msg_data => x_msg_data);
3479:
3480: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3481: retcode := 2;
3482: fnd_msg_pub.count_and_get(
3483: p_encoded => fnd_api.g_false,
3484: p_count => x_msg_count,
3485: p_data => x_msg_data);
3486:

Line 3496: fnd_msg_pub.count_and_get(

3492:
3493: FND_FILE.close;
3494:
3495: WHEN fnd_Api.g_exc_unexpected_error THEN
3496: fnd_msg_pub.count_and_get(
3497: p_encoded => fnd_api.g_false,
3498: p_count => x_msg_count,
3499: p_data => x_msg_data);
3500: