DBA Data[Home] [Help]

APPS.HZ_LOCATION_SERVICES_PUB dependencies on FND_MSG_PUB

Line 236: FND_MSG_PUB.initialize;

232: BEGIN
233:
234: savepoint address_validation_pub;
235:
236: FND_MSG_PUB.initialize;
237:
238: req_data := fnd_conc_global.request_data;
239:
240: --

Line 313: FND_MSG_PUB.ADD;

309: log('Invalid adapter id: '||l_adapter_id);
310: log('p_adapter_content_source: '||p_adapter_content_source);
311: log('p_country_code: '||p_country);
312: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_ADAPTER');
313: FND_MSG_PUB.ADD;
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316: END IF;
317:

Line 541: FND_MSG_PUB.initialize;

537: BEGIN
538:
539: savepoint address_validation_w_pub;
540:
541: FND_MSG_PUB.initialize;
542:
543: log('Starting Location Service Worker');
544: log('Start Time ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
545: log('NEWLINE');

Line 1017: fnd_msg_pub.add;

1013: WHEN OTHERS THEN
1014: log('Cannot update party due to record change.');
1015: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
1016: fnd_message.set_token('TABLE', 'HZ_PARTIES');
1017: fnd_msg_pub.add;
1018: CLOSE ident_address;
1019: RAISE fnd_api.g_exc_error;
1020: END;
1021:

Line 1214: FND_MSG_PUB.ADD;

1210: WHERE org_id = l_org_id;
1211: EXCEPTION
1212: WHEN NO_DATA_FOUND THEN
1213: FND_MESSAGE.SET_NAME( 'AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');
1214: FND_MSG_PUB.ADD;
1215: --x_return_status := FND_API.G_RET_STS_ERROR;
1216: END;
1217:
1218: log('Country: '||l_location_rec.country);

Line 1382: --FND_MSG_PUB.initialize;

1378:
1379: BEGIN
1380:
1381: savepoint submit_addrval_doc_pub;
1382: --FND_MSG_PUB.initialize;
1383:
1384: --Initialize API return status to success.
1385: x_return_status := FND_API.G_RET_STS_SUCCESS;
1386:

Line 1395: FND_MSG_PUB.ADD;

1391: log('Invalid adapter id: '||l_adapter_id);
1392: log('p_adapter_id: '||p_adapter_id);
1393: log('p_country_code: '||p_country_code);
1394: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_ADAPTER');
1395: FND_MSG_PUB.ADD;
1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;
1398:
1399: l_write_log := nvl(fnd_profile.value('HZ_WRITE_ADAPTER_LOG'), 'N');

Line 1648: FND_MSG_PUB.Count_And_Get(

1644: log('Error: Aborting Location Service');
1645: --FND_FILE.close;
1646: ROLLBACK TO submit_addrval_doc_pub;
1647: x_return_status := FND_API.G_RET_STS_ERROR;
1648: FND_MSG_PUB.Count_And_Get(
1649: p_encoded => FND_API.G_FALSE,
1650: p_count => x_msg_count,
1651: p_data => x_msg_data);
1652:

Line 1658: FND_MSG_PUB.Count_And_Get(

1654: log('Error: Aborting Location Service');
1655: --FND_FILE.close;
1656: ROLLBACK TO submit_addrval_doc_pub;
1657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1658: FND_MSG_PUB.Count_And_Get(
1659: p_encoded => FND_API.G_FALSE,
1660: p_count => x_msg_count,
1661: p_data => x_msg_data);
1662:

Line 1669: FND_MSG_PUB.Count_And_Get(

1665: log('SQL Error: '||SQLERRM);
1666: --FND_FILE.close;
1667: ROLLBACK TO submit_addrval_doc_pub;
1668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1669: FND_MSG_PUB.Count_And_Get(
1670: p_encoded => FND_API.G_FALSE,
1671: p_count => x_msg_count,
1672: p_data => x_msg_data);
1673:

Line 1930: FND_MSG_PUB.Reset;

1926: FUNCTION logerror(SQLERRM VARCHAR2 DEFAULT NULL)
1927: RETURN VARCHAR2 IS
1928: l_msg_data VARCHAR2(2000);
1929: BEGIN
1930: FND_MSG_PUB.Reset;
1931:
1932: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1933: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1934: END LOOP;

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

1928: l_msg_data VARCHAR2(2000);
1929: BEGIN
1930: FND_MSG_PUB.Reset;
1931:
1932: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1933: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1934: END LOOP;
1935: IF (SQLERRM IS NOT NULL) THEN
1936: l_msg_data := l_msg_data || SQLERRM;

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

1929: BEGIN
1930: FND_MSG_PUB.Reset;
1931:
1932: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1933: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE );
1934: END LOOP;
1935: IF (SQLERRM IS NOT NULL) THEN
1936: l_msg_data := l_msg_data || SQLERRM;
1937: END IF;

Line 2000: FND_MSG_PUB.ADD;

1996:
1997: IF(p_location_rec.address1 IS NULL OR p_location_rec.address1 = FND_API.G_MISS_CHAR) THEN
1998: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1999: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ADDRESS1');
2000: FND_MSG_PUB.ADD;
2001: log('Address1 is mandatory');
2002: RAISE FND_API.G_EXC_ERROR;
2003: END IF;
2004:

Line 2008: FND_MSG_PUB.ADD;

2004:
2005: IF(p_location_rec.country IS NULL OR p_location_rec.country = FND_API.G_MISS_CHAR) THEN
2006: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2007: FND_MESSAGE.SET_TOKEN('COLUMN' ,'COUNTRY');
2008: FND_MSG_PUB.ADD;
2009: log('Country is mandatory');
2010: RAISE FND_API.G_EXC_ERROR;
2011: END IF;
2012: EXCEPTION

Line 2023: FND_MSG_PUB.ADD;

2019: WHEN OTHERS THEN
2020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2021: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2022: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2023: FND_MSG_PUB.ADD;
2024: END validate_mandatory_column;
2025:
2026: -----------------------------------------------------------------------
2027: -- Called from address_validation