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_MAP_PARTY_PUB dependencies on FND_MESSAGE

Line 197: FND_MESSAGE.SET_NAME('AR','HZ_DNB_INVALID_DATA');

193: p_tca_value IN VARCHAR2
194: )IS
195: l_message_text VARCHAR2(2000) := NULL;
196: BEGIN
197: FND_MESSAGE.SET_NAME('AR','HZ_DNB_INVALID_DATA');
198: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_column_name);
199: FND_MESSAGE.SET_TOKEN('DNB_VALUE',p_dnb_value);
200: --bug 3107162: when a field is rectified to NULL error message should
201: --be that the field is set to 'NULL' instead of blank

Line 198: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_column_name);

194: )IS
195: l_message_text VARCHAR2(2000) := NULL;
196: BEGIN
197: FND_MESSAGE.SET_NAME('AR','HZ_DNB_INVALID_DATA');
198: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_column_name);
199: FND_MESSAGE.SET_TOKEN('DNB_VALUE',p_dnb_value);
200: --bug 3107162: when a field is rectified to NULL error message should
201: --be that the field is set to 'NULL' instead of blank
202: IF p_tca_value IS NULL THEN

Line 199: FND_MESSAGE.SET_TOKEN('DNB_VALUE',p_dnb_value);

195: l_message_text VARCHAR2(2000) := NULL;
196: BEGIN
197: FND_MESSAGE.SET_NAME('AR','HZ_DNB_INVALID_DATA');
198: FND_MESSAGE.SET_TOKEN('FIELD_NAME',p_column_name);
199: FND_MESSAGE.SET_TOKEN('DNB_VALUE',p_dnb_value);
200: --bug 3107162: when a field is rectified to NULL error message should
201: --be that the field is set to 'NULL' instead of blank
202: IF p_tca_value IS NULL THEN
203: FND_MESSAGE.SET_TOKEN('TCA_VALUE','NULL');

Line 203: FND_MESSAGE.SET_TOKEN('TCA_VALUE','NULL');

199: FND_MESSAGE.SET_TOKEN('DNB_VALUE',p_dnb_value);
200: --bug 3107162: when a field is rectified to NULL error message should
201: --be that the field is set to 'NULL' instead of blank
202: IF p_tca_value IS NULL THEN
203: FND_MESSAGE.SET_TOKEN('TCA_VALUE','NULL');
204: ELSE
205: FND_MESSAGE.SET_TOKEN('TCA_VALUE',p_tca_value);
206: END IF;
207: l_message_text := FND_MESSAGE.GET;

Line 205: FND_MESSAGE.SET_TOKEN('TCA_VALUE',p_tca_value);

201: --be that the field is set to 'NULL' instead of blank
202: IF p_tca_value IS NULL THEN
203: FND_MESSAGE.SET_TOKEN('TCA_VALUE','NULL');
204: ELSE
205: FND_MESSAGE.SET_TOKEN('TCA_VALUE',p_tca_value);
206: END IF;
207: l_message_text := FND_MESSAGE.GET;
208:
209: INSERT INTO hz_party_interface_errors (

Line 207: l_message_text := FND_MESSAGE.GET;

203: FND_MESSAGE.SET_TOKEN('TCA_VALUE','NULL');
204: ELSE
205: FND_MESSAGE.SET_TOKEN('TCA_VALUE',p_tca_value);
206: END IF;
207: l_message_text := FND_MESSAGE.GET;
208:
209: INSERT INTO hz_party_interface_errors (
210: interface_error_id,
211: party_interface_id,

Line 1783: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1780:
1781: arp_util.debug('HZ_MAP_PARTY_PUB.MAP: OTHERS EXCEPTION');
1782:
1783: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1784: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1785: FND_MSG_PUB.ADD;
1786:
1787: do_update_request_log(

Line 1784: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1780:
1781: arp_util.debug('HZ_MAP_PARTY_PUB.MAP: OTHERS EXCEPTION');
1782:
1783: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1784: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1785: FND_MSG_PUB.ADD;
1786:
1787: do_update_request_log(
1788: l_interface_rec.request_log_id,

Line 1820: FND_MESSAGE.SET_NAME('AR','HZ_DNB_INVALID_NULL');

1816:
1817: -- Bug 3107162
1818:
1819: IF l_any_rectification_in_batch THEN
1820: FND_MESSAGE.SET_NAME('AR','HZ_DNB_INVALID_NULL');
1821: FND_MSG_PUB.ADD;
1822: END IF;
1823:
1824: --Standard call to get message count and if count is 1, get message info.

Line 6035: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

6031: WHEN OTHERS THEN
6032: ROLLBACK TO store_related_duns_pub;
6033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6034:
6035: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
6036: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6037: FND_MSG_PUB.ADD;
6038:
6039: do_update_request_log(

Line 6036: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

6032: ROLLBACK TO store_related_duns_pub;
6033: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6034:
6035: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
6036: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6037: FND_MSG_PUB.ADD;
6038:
6039: do_update_request_log(
6040: l_interface_rec.request_log_id,

Line 6771: errbuf := FND_MESSAGE.GET || ' ' || SQLERRM;

6767: );
6768:
6769: --handle return values
6770: IF ( l_x_return_status <> 'S' ) THEN
6771: errbuf := FND_MESSAGE.GET || ' ' || SQLERRM;
6772: retcode := 2;
6773: END IF;
6774: --reset the message table index used in reading messages to point to the top of the message table.
6775: FND_MSG_PUB.RESET;

Line 6895: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

6891: WHEN OTHERS THEN
6892:
6893: ROLLBACK TO create_lookup;
6894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6895: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
6896: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6897: FND_MSG_PUB.ADD;
6898: FND_MSG_PUB.Count_And_Get(
6899: p_encoded => FND_API.G_FALSE,

Line 6896: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

6892:
6893: ROLLBACK TO create_lookup;
6894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6895: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
6896: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
6897: FND_MSG_PUB.ADD;
6898: FND_MSG_PUB.Count_And_Get(
6899: p_encoded => FND_API.G_FALSE,
6900: p_count => x_msg_count,

Line 7243: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

7239:
7240: EXCEPTION
7241: WHEN OTHERS THEN
7242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7243: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
7244: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
7245: FND_MSG_PUB.ADD;
7246: END create_dynamic_lookups;
7247:

Line 7244: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

7240: EXCEPTION
7241: WHEN OTHERS THEN
7242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7243: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
7244: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
7245: FND_MSG_PUB.ADD;
7246: END create_dynamic_lookups;
7247:
7248: END HZ_MAP_PARTY_PUB;