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.HZ_PARTY_MERGE dependencies on FND_MSG_PUB

Line 500: FND_MSG_PUB.initialize;

496:
497: ---Bug 2440553 Savepoint for the start of batch_merge
498: --SAVEPOINT batch_merge; commented out and moved to after commit for bug 3267877.
499:
500: FND_MSG_PUB.initialize;
501: init_globals;
502:
503: --Initialize API return status to success.
504: l_glob_return_status := FND_API.G_RET_STS_SUCCESS;

Line 519: FND_MSG_PUB.ADD;

515: l_batch_id := TO_NUMBER(p_batch_id);
516: ELSE
517: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_NOTFOUND');
518: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
519: FND_MSG_PUB.ADD;
520: RAISE FND_API.G_EXC_ERROR;
521: END IF;
522:
523: -- Open the batch cursor and fetch batch details

Line 530: FND_MSG_PUB.ADD;

526: l_batch_delete, l_batch_commit;
527: IF (c_batch%NOTFOUND) THEN
528: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_NOTFOUND');
529: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
530: FND_MSG_PUB.ADD;
531: RAISE FND_API.G_EXC_ERROR;
532: END IF;
533:
534: -- If batch already complete error out

Line 538: FND_MSG_PUB.ADD;

534: -- If batch already complete error out
535: IF (l_batch_status = 'COMPLETE') THEN
536: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_COMPLETE');
537: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
538: FND_MSG_PUB.ADD;
539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541: CLOSE c_batch;
542:

Line 554: FND_MSG_PUB.ADD;

550: IF (l_ret_merge_ok = 'N') THEN
551: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_INTERNAL_PARTY_IND');
552: FND_MESSAGE.SET_TOKEN('PARTY_INT', l_int_party);
553: FND_MESSAGE.SET_TOKEN('PARTY_EXT', l_ext_party);
554: FND_MSG_PUB.ADD;
555: RAISE FND_API.G_EXC_ERROR;
556: END IF;
557:
558: HZ_MERGE_DUP_PVT.validate_overlapping_merge_req(

Line 709: FND_MSG_PUB.initialize;

705:
706: ----- Loop through each pre merge party and perform the merge
707: OPEN c_batch_details(l_batch_id, l_pre_merge_to_party_id);
708: LOOP
709: FND_MSG_PUB.initialize;
710:
711: -- Initialize return status and error buffer
712: l_return_status := FND_API.G_RET_STS_SUCCESS;
713: l_error_msg := '';

Line 735: FND_MSG_PUB.ADD;

731: FETCH c_dict_id INTO l_dict_id;
732: IF c_dict_id%NOTFOUND THEN
733: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
734: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTIES');
735: FND_MSG_PUB.ADD;
736: RAISE FND_API.G_EXC_ERROR;
737: END IF;
738: CLOSE c_dict_id;
739:

Line 776: FND_MSG_PUB.ADD;

772: FETCH c_dict_id INTO l_dict_id;
773: IF c_dict_id%NOTFOUND THEN
774: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
775: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTY_SITES');
776: FND_MSG_PUB.ADD;
777: RAISE FND_API.G_EXC_ERROR;
778: END IF;
779: CLOSE c_dict_id;
780:

Line 823: FND_MSG_PUB.ADD;

819: FETCH c_dict_id INTO l_dict_id;
820: IF c_dict_id%NOTFOUND THEN
821: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
822: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_CONTACT_POINTS');
823: FND_MSG_PUB.ADD;
824: RAISE FND_API.G_EXC_ERROR;
825: END IF;
826: CLOSE c_dict_id;
827:

Line 876: FND_MSG_PUB.ADD;

872: FETCH c_dict_id INTO l_dict_id;
873: IF c_dict_id%NOTFOUND THEN
874: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
875: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTY_RELATIONSHIPS');
876: FND_MSG_PUB.ADD;
877: RAISE FND_API.G_EXC_ERROR;
878: END IF;
879: CLOSE c_dict_id;
880:

Line 944: FND_MSG_PUB.ADD;

940: end if; --l_return_status
941:
942: ELSE --type of merge
943: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_MERGE_TYPE');
944: FND_MSG_PUB.ADD;
945: RAISE FND_API.G_EXC_ERROR;
946: END IF; --type of merge
947:
948: -- If the party was successfully merged, update merge status to 'DONE'

Line 1092: IF FND_MSG_PUB.Count_Msg <=0 THEN

1088: ROLLBACK TO batch_merge;
1089: outandlog('Batch merge procedure '||l_proc_name||' is not successful');
1090: l_error_msg := logerror;
1091: --bug 4916777
1092: IF FND_MSG_PUB.Count_Msg <=0 THEN
1093: l_error_msg := 'Error executing batch merge procedure ' || l_proc_name || ' for entity ' || l_sub_entity_name;
1094: END IF;
1095: I_Counter:=0;
1096: store_merge_log(l_batch_pid, -1,

Line 1356: FND_MSG_PUB.ADD;

1352: FETCH c_dict_id INTO l_dict_id, l_desc;
1353: IF c_dict_id%NOTFOUND THEN
1354: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1355: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_PARTY_SITES');
1356: FND_MSG_PUB.ADD;
1357: RAISE FND_API.G_EXC_ERROR;
1358: END IF;
1359: CLOSE c_dict_id;
1360:

Line 1483: FND_MSG_PUB.ADD;

1479: -- If not found error out
1480: IF (c_dict_details%NOTFOUND or l_proc_name = null) THEN
1481: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1482: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
1483: FND_MSG_PUB.ADD;
1484: RAISE FND_API.G_EXC_ERROR;
1485: END IF;
1486: CLOSE c_dict_details;
1487:

Line 1594: IF FND_MSG_PUB.Count_Msg <=0 THEN

1590: log('Error: Merge failed in procedure '||l_proc_name||' for entity '||p_entity_name,TRUE); --4634891
1591: x_error_msg := logerror;
1592:
1593: --bug 4916777
1594: IF FND_MSG_PUB.Count_Msg <=0 THEN
1595: x_error_msg := 'Error executing procedure ' || l_proc_name || ' for entity ' || p_entity_name;
1596: log(x_error_msg);
1597: END IF;
1598: --bug 4916777

Line 1683: FND_MSG_PUB.ADD;

1679: IF (l_sub_entity_name is null or l_sub_fk_column_name is null or
1680: l_sub_fk_column_name is null) THEN
1681: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1682: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_sub_entity_name);
1683: FND_MSG_PUB.ADD;
1684:
1685: x_error_msg:=logerror;
1686: store_merge_log(p_batch_party_id, -1,
1687: -1,p_from_id, p_to_id,null,null,

Line 1766: FND_MSG_PUB.ADD;

1762: l_subrec_str:=NULL;
1763: ELSE
1764: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1765: FND_MESSAGE.SET_TOKEN('ERROR' ,'do_merge ' || SQLERRM);
1766: FND_MSG_PUB.ADD;
1767:
1768: x_error_msg:=logerror;
1769: store_merge_log(p_batch_party_id, -1,
1770: -1,p_from_id, p_to_id,null,null,

Line 1791: FND_MSG_PUB.ADD;

1787: -- If not found error out
1788: IF (c_dict_details%NOTFOUND or l_proc_name = null) THEN
1789: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1790: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_sub_entity_name);
1791: FND_MSG_PUB.ADD;
1792: RAISE FND_API.G_EXC_ERROR;
1793: END IF;
1794: CLOSE c_dict_details;
1795: log(p_log_padding || ' '|| l_desc);

Line 1859: IF FND_MSG_PUB.Count_Msg <=0 THEN

1855: log(' **** Error **** ', TRUE);
1856: log('Error: Merge failed in procedure '||l_proc_name_b||' for entity '||l_sub_entity_name,TRUE); --4634891
1857: x_error_msg := logerror;
1858: --bug 4916777
1859: IF FND_MSG_PUB.Count_Msg <=0 THEN
1860: x_error_msg := 'Error executing procedure ' || l_proc_name || ' for entity ' || p_entity_name;
1861: log(x_error_msg);
1862: END IF ;
1863: --bug 4916777

Line 1910: FND_MSG_PUB.ADD;

1906: -- If not found error out
1907: IF (c_dict_details%NOTFOUND or l_proc_name = null) THEN
1908: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
1909: FND_MESSAGE.SET_TOKEN('ENTITY' ,l_sub_entity_name);
1910: FND_MSG_PUB.ADD;
1911: RAISE FND_API.G_EXC_ERROR;
1912: END IF;
1913: CLOSE c_dict_details;
1914: END IF;

Line 1945: IF FND_MSG_PUB.Count_Msg <=0 THEN

1941: log(' **** Error **** ', TRUE);
1942: log('Error: Merge failed in procedure '||l_proc_name_b||' for entity '||l_sub_entity_name,TRUE); --4634891
1943: x_error_msg := logerror;
1944: --bug 4916777
1945: IF FND_MSG_PUB.Count_Msg <=0 THEN
1946: x_error_msg := 'Error executing procedure ' || l_proc_name || ' for entity ' || p_entity_name;
1947: log(x_error_msg);
1948: END IF ;
1949: --bug 4916777

Line 2024: FND_MSG_PUB.ADD;

2020: EXCEPTION
2021: WHEN OTHERS THEN
2022: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2023: FND_MESSAGE.SET_TOKEN('ERROR' ,'do_merge ' || SQLERRM);
2024: FND_MSG_PUB.ADD;
2025:
2026: x_error_msg:=logerror;
2027: store_merge_log(p_batch_party_id, -1,
2028: -1,p_from_id, p_to_id,null,null,

Line 2063: FND_MSG_PUB.ADD;

2059: EXCEPTION
2060: WHEN OTHERS THEN
2061: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_BATCH_LOCK_ERROR');
2062: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2063: FND_MSG_PUB.ADD;
2064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2065: END lock_batch;
2066:
2067: /*---------------------------------------------------------------------------------------

Line 2191: FND_MSG_PUB.ADD;

2187: WHEN OTHERS THEN
2188: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_LOCK_ERROR');
2189: FND_MESSAGE.SET_TOKEN('ENTITY', p_entity_name);
2190: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM || ' : ' || lockstr || ' subent ' || l_sub_ent_name);
2191: FND_MSG_PUB.ADD;
2192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2193: END lock_records;
2194:
2195: /*------------------------------------------------------------------------------

Line 2253: FND_MSG_PUB.ADD;

2249: EXCEPTION
2250: WHEN OTHERS THEN
2251: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_DELETE_ERROR');
2252: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2253: FND_MSG_PUB.ADD;
2254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2255: END delete_merged_records;
2256:
2257: /*-------------------------------------------------------------------

Line 2300: FND_MSG_PUB.ADD;

2296: WHEN OTHERS THEN
2297: FND_MESSAGE.SET_NAME('AR', 'HZ_REC_DESC_ERROR');
2298: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
2299: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2300: FND_MSG_PUB.ADD;
2301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2302: RETURN NULL;
2303: END get_record_desc;
2304:

Line 2337: FND_MSG_PUB.ADD;

2333: WHEN OTHERS THEN
2334: FND_MESSAGE.SET_NAME('AR', 'HZ_REC_DESC_ERROR');
2335: FND_MESSAGE.SET_TOKEN('ENTITY' ,p_entity_name);
2336: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2337: FND_MSG_PUB.ADD;
2338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2339: RETURN NULL;
2340: END get_record_desc_r;
2341:

Line 2425: FND_MSG_PUB.ADD;

2421: log('Data exists in table for the merge-to party. Aborting merge');
2422: log('');
2423: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2424: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2425: FND_MSG_PUB.ADD;
2426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2427: END exec_merge;
2428:
2429: /*-----------------------------------------------------------------

Line 2511: FND_MSG_PUB.ADD;

2507: log('Data exists in table for the merge-to party. Aborting merge');
2508: log('');
2509: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2510: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2511: FND_MSG_PUB.ADD;
2512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2513: END exec_merge_r;
2514:
2515: --bug 4634891 created overloaded procedure exec_merge

Line 2568: FND_MSG_PUB.ADD;

2564: log('Data exists in table for the merge-to party. Aborting merge');
2565: log('');
2566: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2567: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2568: FND_MSG_PUB.ADD;
2569: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2570: END exec_merge;
2571:
2572: /*------------------------------------------------------------------------

Line 2670: FND_MSG_PUB.ADD;

2666: EXCEPTION
2667: WHEN OTHERS THEN
2668: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2669: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2670: FND_MSG_PUB.ADD;
2671: RAISE FND_API.G_EXC_ERROR;
2672: END store_merge_history;
2673:
2674: /*---------------------------------------------------------------------------

Line 2775: FND_MSG_PUB.ADD;

2771: -- ROLLBACK to batch_merge;
2772: ROLLBACK; -- bug 3947633
2773: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
2774: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2775: FND_MSG_PUB.ADD;
2776: RAISE FND_API.G_EXC_ERROR;
2777: END store_merge_log;
2778:
2779: /*---------------------------------------------------------------------------

Line 2926: FND_MSG_PUB.ADD;

2922: l_batch_status, l_batch_delete,l_batch_commit;
2923: IF (pre_batch%NOTFOUND) THEN
2924: FND_MESSAGE.SET_NAME('AR', 'HZ_BATCH_NOTFOUND');
2925: FND_MESSAGE.SET_TOKEN('BATCHID', p_batch_id);
2926: FND_MSG_PUB.ADD;
2927: RAISE FND_API.G_EXC_ERROR;
2928: END IF;
2929: CLOSE pre_batch;
2930:

Line 3115: FND_MSG_PUB.Reset;

3111: RETURN VARCHAR2 IS
3112:
3113: l_msg_data VARCHAR2(2000);
3114: BEGIN
3115: FND_MSG_PUB.Reset;
3116:
3117: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3118: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
3119: END LOOP;

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

3113: l_msg_data VARCHAR2(2000);
3114: BEGIN
3115: FND_MSG_PUB.Reset;
3116:
3117: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3118: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
3119: END LOOP;
3120: IF (SQLERRM IS NOT NULL) THEN
3121: l_msg_data := l_msg_data || SQLERRM;

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

3114: BEGIN
3115: FND_MSG_PUB.Reset;
3116:
3117: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3118: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
3119: END LOOP;
3120: IF (SQLERRM IS NOT NULL) THEN
3121: l_msg_data := l_msg_data || SQLERRM;
3122: END IF;

Line 3175: FND_MSG_PUB.initialize;

3171: END IF;
3172:
3173: --Initialize message list if p_init_msg_list is set to TRUE.
3174: IF FND_API.to_Boolean(p_init_msg_list) THEN
3175: FND_MSG_PUB.initialize;
3176: END IF;
3177:
3178: --Initialize API return status to success.
3179: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3205: FND_MSG_PUB.ADD;

3201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3202:
3203: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3205: FND_MSG_PUB.ADD;
3206:
3207: FND_MSG_PUB.Count_And_Get(
3208: p_encoded => FND_API.G_FALSE,
3209: p_count => x_msg_count,

Line 3207: FND_MSG_PUB.Count_And_Get(

3203: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3204: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3205: FND_MSG_PUB.ADD;
3206:
3207: FND_MSG_PUB.Count_And_Get(
3208: p_encoded => FND_API.G_FALSE,
3209: p_count => x_msg_count,
3210: p_data => x_msg_data);
3211: END get_merge_to_record_id;

Line 3248: FND_MSG_PUB.ADD;

3244: EXCEPTION
3245: WHEN OTHERS THEN
3246: /* FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3247: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3248: FND_MSG_PUB.ADD;
3249: RAISE FND_API.G_EXC_ERROR;*/
3250: RETURN NULL;
3251: END;
3252:

Line 3290: FND_MSG_PUB.ADD;

3286: EXCEPTION
3287: WHEN OTHERS THEN
3288: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3289: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3290: FND_MSG_PUB.ADD;
3291: RAISE FND_API.G_EXC_ERROR;
3292: END get_col_type;
3293:
3294:

Line 3340: FND_MSG_PUB.initialize;

3336: END IF;
3337:
3338: --Initialize message list if p_init_msg_list is set to TRUE.
3339: IF FND_API.to_Boolean(p_init_msg_list) THEN
3340: FND_MSG_PUB.initialize;
3341: END IF;
3342:
3343: --Initialize API return status to success.
3344: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3364: FND_MSG_PUB.ADD;

3360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3361:
3362: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3363: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3364: FND_MSG_PUB.ADD;
3365:
3366: FND_MSG_PUB.Count_And_Get(
3367: p_count => x_msg_count,
3368: p_data => x_msg_data);

Line 3366: FND_MSG_PUB.Count_And_Get(

3362: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
3363: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3364: FND_MSG_PUB.ADD;
3365:
3366: FND_MSG_PUB.Count_And_Get(
3367: p_count => x_msg_count,
3368: p_data => x_msg_data);
3369: END check_party_in_merge_batch;
3370:

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

3515: l_msg_data);
3516:
3517: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3518: IF l_msg_data IS NULL THEN
3519: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3520: l_msg_data := l_msg_data ||
3521: FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
3522: END LOOP;
3523: END IF;

Line 3521: FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

3517: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3518: IF l_msg_data IS NULL THEN
3519: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3520: l_msg_data := l_msg_data ||
3521: FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
3522: END LOOP;
3523: END IF;
3524: RETURN;
3525: END IF;

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

3543: l_msg_data);
3544:
3545: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3546: IF l_msg_data IS NULL THEN
3547: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3548: l_msg_data := l_msg_data ||
3549: FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
3550: END LOOP;
3551: END IF;

Line 3549: FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );

3545: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3546: IF l_msg_data IS NULL THEN
3547: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3548: l_msg_data := l_msg_data ||
3549: FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
3550: END LOOP;
3551: END IF;
3552: FND_FILE.put_line (FND_FILE.log,'Warning .. Error updating Org Profile of x_to_id ' || l_msg_data);
3553: -- Bug Fix : 3116262.

Line 4591: FND_MSG_PUB.ADD;

4587: WHEN OTHERS THEN
4588: log('Error in setup DNB data: '||SQLERRM);
4589: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
4590: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4591: FND_MSG_PUB.ADD;
4592: APP_EXCEPTION.RAISE_EXCEPTION;
4593: END;
4594:
4595: PROCEDURE insert_party_site_details (

Line 4807: FND_MSG_PUB.ADD;

4803: WHEN OTHERS THEN
4804: log('Error in check internal/external party type: '||SQLERRM);
4805: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4806: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4807: FND_MSG_PUB.ADD;
4808: APP_EXCEPTION.RAISE_EXCEPTION;
4809: END check_int_ext_party_type;
4810:
4811: