DBA Data[Home] [Help]

APPS.HZ_LOCATION_SERVICES_PUB dependencies on FND_MESSAGE

Line 312: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_ADAPTER');

308: IF(l_adapter_id IS NULL) THEN
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;

Line 466: l_err_msg := FND_MESSAGE.get;

462: log('NEWLINE');
463: log('Submit Address Validation Worker '||j);
464:
465: IF(l_request_id IS NULL or l_request_id = 0) THEN
466: l_err_msg := FND_MESSAGE.get;
467: errbuf := l_err_msg;
468: retcode := 2;
469: RETURN;
470: END IF;

Line 1015: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');

1011:
1012: EXCEPTION
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;

Line 1016: fnd_message.set_token('TABLE', 'HZ_PARTIES');

1012: EXCEPTION
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;

Line 1213: FND_MESSAGE.SET_NAME( 'AR','AR_NO_ROW_IN_SYSTEM_PARAMETERS');

1209: FROM ar_system_parameters_all
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:

Line 1394: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_INVALID_ADAPTER');

1390: IF(l_adapter_id IS NULL) THEN
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:

Line 1572: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_TIMEOUT');

1568: log('Location Service Transfer Finished');
1569: WHEN UTL_HTTP.TRANSFER_TIMEOUT THEN
1570: log('Location Service Timeout Occur');
1571: -- need message for invalid adapter
1572: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_TIMEOUT');
1573: RAISE FND_API.G_EXC_ERROR;
1574: WHEN OTHERS THEN
1575: log('Location Service Others Error Occur');
1576: -- need message for invalid adapter

Line 1593: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');

1589: And it is NEVER raised after calling with enable=>true */
1590: WHEN UTL_HTTP.REQUEST_FAILED THEN
1591: log('REQUEST_FAILED: ' || UTL_HTTP.GET_DETAILED_SQLERRM);
1592: --FND_FILE.close;
1593: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');
1594: RAISE FND_API.G_EXC_ERROR;
1595:
1596: -- raised by URL http://xxx.oracle.com/
1597: WHEN UTL_HTTP.HTTP_SERVER_ERROR THEN

Line 1600: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');

1596: -- raised by URL http://xxx.oracle.com/
1597: WHEN UTL_HTTP.HTTP_SERVER_ERROR THEN
1598: log('HTTP_SERVER_ERROR: ' || UTL_HTTP.GET_DETAILED_SQLERRM);
1599: --FND_FILE.close;
1600: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');
1601: RAISE FND_API.G_EXC_ERROR;
1602:
1603: -- raised by URL http://otn.oracle.com/xxx
1604: WHEN UTL_HTTP.HTTP_CLIENT_ERROR THEN

Line 1607: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');

1603: -- raised by URL http://otn.oracle.com/xxx
1604: WHEN UTL_HTTP.HTTP_CLIENT_ERROR THEN
1605: log('HTTP_CLIENT_ERROR: ' || UTL_HTTP.GET_DETAILED_SQLERRM);
1606: --FND_FILE.close;
1607: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');
1608: RAISE FND_API.G_EXC_ERROR;
1609:
1610: WHEN UTL_HTTP.TRANSFER_TIMEOUT THEN
1611: log('HTTP TRANSFER TIMEOUT: '|| UTL_HTTP.GET_DETAILED_SQLERRM);

Line 1613: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');

1609:
1610: WHEN UTL_HTTP.TRANSFER_TIMEOUT THEN
1611: log('HTTP TRANSFER TIMEOUT: '|| UTL_HTTP.GET_DETAILED_SQLERRM);
1612: --FND_FILE.close;
1613: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');
1614: RAISE FND_API.G_EXC_ERROR;
1615:
1616: WHEN OTHERS THEN
1617: log('HTTP OTHER EXCEPTION: '|| UTL_HTTP.GET_DETAILED_SQLERRM);

Line 1620: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');

1616: WHEN OTHERS THEN
1617: log('HTTP OTHER EXCEPTION: '|| UTL_HTTP.GET_DETAILED_SQLERRM);
1618: log('Check SQL EXCEPTION: '|| SQLERRM);
1619: --FND_FILE.close;
1620: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_ERROR');
1621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1622: END;
1623:
1624: -- ************************************************************************************ --

Line 1998: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

1994: x_return_status IN OUT NOCOPY VARCHAR2) IS
1995: BEGIN
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;

Line 1999: FND_MESSAGE.SET_TOKEN('COLUMN' ,'ADDRESS1');

1995: BEGIN
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;

Line 2006: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

2002: RAISE FND_API.G_EXC_ERROR;
2003: END IF;
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;

Line 2007: FND_MESSAGE.SET_TOKEN('COLUMN' ,'COUNTRY');

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

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

2017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2018:
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:

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

2018:
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: -----------------------------------------------------------------------