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 161: FND_MSG_PUB.Reset;

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

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

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

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

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

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

990: WHEN FND_API.G_EXC_ERROR THEN
991: --
992: -- Error from invoice api directly out
993: --
994: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
995: p_count => x_msg_count,
996: p_data => x_msg_data );
997:
998: outandlog( message => x_msg_data);

Line 1006: fnd_msg_pub.add;

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

Line 1008: fnd_msg_pub.count_and_get(

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

Line 1363: FND_MSG_PUB.ADD;

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

Line 1370: FND_MSG_PUB.ADD;

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

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

1515: outandlog( message => 'create_charge_inv_dm -');
1516:
1517: EXCEPTION
1518: WHEN FND_API.G_EXC_ERROR THEN
1519: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1520: p_count => x_msg_count,
1521: p_data => x_msg_data );
1522:
1523: outandlog( message => x_msg_data);

Line 1528: fnd_msg_pub.add;

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

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

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

Line 1726: FND_MSG_PUB.ADD;

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

Line 1733: FND_MSG_PUB.ADD;

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

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

1817:
1818: IF l_msg_count > 1 THEN
1819: ll_msg_data := NULL;
1820: FOR cnt IN 1..l_msg_count LOOP
1821: ll_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,
1822: FND_API.G_FALSE);
1823: log(' error text : '|| ll_msg_data);
1824: l_msg_data := SUBSTRB(l_msg_data||ll_msg_data,1,2000);
1825: END LOOP;

Line 1944: fnd_msg_pub.count_and_get(

1940: WHEN no_adj_to_process THEN
1941: NULL;
1942: WHEN FND_API.G_EXC_ERROR THEN
1943: IF cadj%ISOPEN THEN CLOSE cadj; END IF;
1944: fnd_msg_pub.count_and_get(
1945: p_encoded => fnd_api.g_false,
1946: p_count => x_msg_count,
1947: p_data => x_msg_data);
1948: outandlog( message => ' EXCEPTION FND_API.G_EXC_ERROR create_charge_adj :'||x_msg_data);

Line 1955: fnd_msg_pub.add;

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

Line 1957: fnd_msg_pub.count_and_get(

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

Line 2241: fnd_msg_pub.count_and_get(

2237:
2238: FND_FILE.close;
2239: EXCEPTION
2240: WHEN fnd_Api.g_exc_error THEN
2241: fnd_msg_pub.count_and_get(
2242: p_encoded => fnd_api.g_false,
2243: p_count => x_msg_count,
2244: p_data => x_msg_data);
2245: retcode := 1;

Line 2488: FND_MSG_PUB.ADD;

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

Line 2498: FND_MSG_PUB.ADD;

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

Line 2515: FND_MSG_PUB.ADD;

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

Line 2523: fnd_msg_pub.add;

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

Line 2531: FND_MSG_PUB.ADD;

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

Line 2538: FND_MSG_PUB.ADD;

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

Line 2545: fnd_msg_pub.add;

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

Line 2552: fnd_msg_pub.add;

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

Line 2559: fnd_msg_pub.add;

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

Line 2568: fnd_msg_pub.add;

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

Line 2572: fnd_msg_pub.add;

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

Line 2671: fnd_msg_pub.count_and_get(

2667: outandlog( message =>' End at ' || to_char(SYSDATE, 'HH24:MI:SS') );
2668: outandlog( message =>'End create_late_charge for the batch:'||p_batch_id||' Please check log files' );
2669: EXCEPTION
2670: WHEN fnd_Api.g_exc_unexpected_error THEN
2671: fnd_msg_pub.count_and_get(
2672: p_encoded => fnd_api.g_false,
2673: p_count => x_msg_count,
2674: p_data => x_msg_data);
2675:

Line 2877: fnd_msg_pub.count_and_get(

2873:
2874: FND_FILE.close;
2875: EXCEPTION
2876: WHEN fnd_Api.g_exc_error THEN
2877: fnd_msg_pub.count_and_get(
2878: p_encoded => fnd_api.g_false,
2879: p_count => x_msg_count,
2880: p_data => x_msg_data);
2881: retcode := 1;

Line 3020: fnd_msg_pub.initialize;

3016: g_interest_batch_id := l_interest_batch_id;
3017: g_org_id := l_org_id;
3018: g_BATCH_SOURCE_ID := l_batch_source_id;
3019:
3020: fnd_msg_pub.initialize;
3021:
3022: log('Calling create_late_charge_per_worker +');
3023:
3024: create_late_charge_per_worker

Line 3037: fnd_msg_pub.count_and_get(

3033:
3034: log('Calling create_late_charge_per_worker -');
3035: --{Message Stack
3036: IF retcode <> '0' THEN
3037: fnd_msg_pub.count_and_get(
3038: p_encoded => fnd_api.g_false,
3039: p_count => x_msg_count,
3040: p_data => x_msg_data);
3041: IF x_msg_count > 1 THEN

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

3042: i := 0;
3043: LOOP
3044: IF i < x_msg_count THEN
3045: i := i + 1 ;
3046: x_msg_data :=FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
3047: log(x_msg_data);
3048: ELSE
3049: EXIT;
3050: END IF;

Line 3094: FND_MSG_PUB.ADD;

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

Line 3101: FND_MSG_PUB.ADD;

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

Line 3127: FND_MSG_PUB.ADD;

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

Line 3224: FND_MSG_PUB.ADD;

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

Line 3235: FND_MSG_PUB.ADD;

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

Line 3252: FND_MSG_PUB.ADD;

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

Line 3261: fnd_msg_pub.add;

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

Line 3269: FND_MSG_PUB.ADD;

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

Line 3276: FND_MSG_PUB.ADD;

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

Line 3283: fnd_msg_pub.add;

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

Line 3290: fnd_msg_pub.add;

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

Line 3297: fnd_msg_pub.add;

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

Line 3306: fnd_msg_pub.add;

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

Line 3442: fnd_msg_pub.count_and_get(

3438: x_msg_data => x_msg_data);
3439:
3440: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3441: retcode := 2;
3442: fnd_msg_pub.count_and_get(
3443: p_encoded => fnd_api.g_false,
3444: p_count => x_msg_count,
3445: p_data => x_msg_data);
3446:

Line 3456: fnd_msg_pub.count_and_get(

3452:
3453: FND_FILE.close;
3454:
3455: WHEN fnd_Api.g_exc_unexpected_error THEN
3456: fnd_msg_pub.count_and_get(
3457: p_encoded => fnd_api.g_false,
3458: p_count => x_msg_count,
3459: p_data => x_msg_data);
3460: