DBA Data[Home] [Help]

APPS.ZX_TCM_GEO_JUR_PKG dependencies on FND_MESSAGE

Line 123: FND_MESSAGE.SET_NAME('ZX', 'ZX_TCM_NO_PARTY_TYPE_INFO');

119:
120: EXCEPTION WHEN OTHERS THEN
121: -- Party type information could not be retrived.
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: FND_MESSAGE.SET_NAME('ZX', 'ZX_TCM_NO_PARTY_TYPE_INFO');
124:
125: -- Logging Infra: Statement level
126: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
127: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'E: EXC: OTHERS: '||SQLCODE||': '||SQLERRM);

Line 262: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_LOC_REC');

258: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
259: END IF;
260:
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_LOC_REC');
263: FND_MESSAGE.SET_TOKEN('LOC_ID', p_location_id);
264: FND_MESSAGE.SET_TOKEN('TABLE_NAME', p_location_table_name);
265: RAISE FND_API.G_EXC_ERROR;
266: END;

Line 263: FND_MESSAGE.SET_TOKEN('LOC_ID', p_location_id);

259: END IF;
260:
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_LOC_REC');
263: FND_MESSAGE.SET_TOKEN('LOC_ID', p_location_id);
264: FND_MESSAGE.SET_TOKEN('TABLE_NAME', p_location_table_name);
265: RAISE FND_API.G_EXC_ERROR;
266: END;
267: END;

Line 264: FND_MESSAGE.SET_TOKEN('TABLE_NAME', p_location_table_name);

260:
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_LOC_REC');
263: FND_MESSAGE.SET_TOKEN('LOC_ID', p_location_id);
264: FND_MESSAGE.SET_TOKEN('TABLE_NAME', p_location_table_name);
265: RAISE FND_API.G_EXC_ERROR;
266: END;
267: END;
268:

Line 309: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_LOC_REC');

305: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
306: END IF;
307:
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_LOC_REC');
310: FND_MESSAGE.SET_TOKEN('LOC_ID', p_location_id);
311: FND_MESSAGE.SET_TOKEN('TABLE_NAME', p_location_table_name);
312: RAISE FND_API.G_EXC_ERROR;
313: END;

Line 310: FND_MESSAGE.SET_TOKEN('LOC_ID', p_location_id);

306: END IF;
307:
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_LOC_REC');
310: FND_MESSAGE.SET_TOKEN('LOC_ID', p_location_id);
311: FND_MESSAGE.SET_TOKEN('TABLE_NAME', p_location_table_name);
312: RAISE FND_API.G_EXC_ERROR;
313: END;
314: END;

Line 311: FND_MESSAGE.SET_TOKEN('TABLE_NAME', p_location_table_name);

307:
308: x_return_status := FND_API.G_RET_STS_ERROR;
309: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_LOC_REC');
310: FND_MESSAGE.SET_TOKEN('LOC_ID', p_location_id);
311: FND_MESSAGE.SET_TOKEN('TABLE_NAME', p_location_table_name);
312: RAISE FND_API.G_EXC_ERROR;
313: END;
314: END;
315: END IF;

Line 739: FND_MESSAGE.SET_NAME('ZX', 'ZX_GEO_NO_GEO_NAME_REF');

735: END IF;
736:
737: IF l_count_geo = 0 THEN
738: x_return_status := FND_API.G_RET_STS_ERROR;
739: FND_MESSAGE.SET_NAME('ZX', 'ZX_GEO_NO_GEO_NAME_REF');
740: RAISE FND_API.G_EXC_ERROR;
741: END IF;
742: END IF;
743:

Line 797: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');

793: END IF;
794:
795: WHEN OTHERS THEN
796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
797: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
798: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
799:
800: IF C_GEOGRAPHY_TYPES%ISOPEN THEN
801: close C_GEOGRAPHY_TYPES;

Line 798: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);

794:
795: WHEN OTHERS THEN
796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
797: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
798: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
799:
800: IF C_GEOGRAPHY_TYPES%ISOPEN THEN
801: close C_GEOGRAPHY_TYPES;
802: END IF;

Line 1227: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');

1223:
1224:
1225: WHEN OTHERS THEN
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1227: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1228: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1229:
1230: -- Logging Infra: Statement level
1231: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1228: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);

1224:
1225: WHEN OTHERS THEN
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1227: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1228: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1229:
1230: -- Logging Infra: Statement level
1231: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1232: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'E: EXC: OTHERS: '||SQLCODE||': '||SQLERRM);

Line 1296: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_TYPE_INVALID');

1292: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1293: END IF;
1294:
1295: --x_return_status := FND_API.G_RET_STS_ERROR;
1296: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_TYPE_INVALID');
1297: RAISE FND_API.G_EXC_ERROR;
1298: END IF;
1299: -- ---------------------
1300: */

Line 1398: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_COUNTRY');

1394: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1395: END IF;
1396:
1397: x_return_status := FND_API.G_RET_STS_ERROR;
1398: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_COUNTRY');
1399: FND_MESSAGE.SET_TOKEN('LOC_ID', p_location_id);
1400: FND_MESSAGE.SET_TOKEN('TABLE_NAME', x_location_table_name);
1401: RAISE FND_API.G_EXC_ERROR;
1402: END;

Line 1399: FND_MESSAGE.SET_TOKEN('LOC_ID', p_location_id);

1395: END IF;
1396:
1397: x_return_status := FND_API.G_RET_STS_ERROR;
1398: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_COUNTRY');
1399: FND_MESSAGE.SET_TOKEN('LOC_ID', p_location_id);
1400: FND_MESSAGE.SET_TOKEN('TABLE_NAME', x_location_table_name);
1401: RAISE FND_API.G_EXC_ERROR;
1402: END;
1403: ELSE

Line 1400: FND_MESSAGE.SET_TOKEN('TABLE_NAME', x_location_table_name);

1396:
1397: x_return_status := FND_API.G_RET_STS_ERROR;
1398: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_COUNTRY');
1399: FND_MESSAGE.SET_TOKEN('LOC_ID', p_location_id);
1400: FND_MESSAGE.SET_TOKEN('TABLE_NAME', x_location_table_name);
1401: RAISE FND_API.G_EXC_ERROR;
1402: END;
1403: ELSE
1404:

Line 1438: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');

1434: END IF;
1435:
1436: WHEN OTHERS THEN
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1439: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1440:
1441: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1442: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,

Line 1439: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);

1435:
1436: WHEN OTHERS THEN
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1438: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1439: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1440:
1441: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1442: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,
1443: 'E: EXC: OTHERS: '|| SQLCODE||': '||SQLERRM);