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.ZX_TCM_EXT_SERVICES_PUB dependencies on FND_MESSAGE

Line 105: fnd_message.set_name('ZX','ZX_PARAM_NOT_SET');

101:
102: IF p_tax_regime_code is NULL OR p_tax is NULL THEN
103: --p_return_status:=FND_API.G_RET_STS_ERROR;
104: --p_error_buffer:='One or more of the parameters are not entered';
105: fnd_message.set_name('ZX','ZX_PARAM_NOT_SET');
106: -- Logging Infra: YK: 3/10:
107: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
108: l_log_msg := 'E: wrong input params: p_tax_regime_code is null or p_tax is null';
109: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 169: --fnd_message.set_name('ZX','ZX_DEFAULT_VALUE_NOT_EXIST');

165:
166: ELSIF c_default_status%notfound THEN
167: --p_return_status := FND_API.G_RET_STS_SUCCESS;
168: --p_error_buffer := 'No Default values exist for the given Tax Regime Code and Tax';
169: --fnd_message.set_name('ZX','ZX_DEFAULT_VALUE_NOT_EXIST');
170:
171: -- Logging Infra: YK: 3/10: Break point
172: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
173: l_log_msg := 'B: CUR: c_default_status: notfound';

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

199:
200: EXCEPTION
201: WHEN INVALID_CURSOR THEN
202: p_return_status := FND_API.G_RET_STS_ERROR;
203: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
204: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
205: IF c_default_rate%ISOPEN THEN CLOSE c_default_rate; end if;
206: IF c_default_status%ISOPEN THEN CLOSE c_default_status; end if;
207:

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

200: EXCEPTION
201: WHEN INVALID_CURSOR THEN
202: p_return_status := FND_API.G_RET_STS_ERROR;
203: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
204: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
205: IF c_default_rate%ISOPEN THEN CLOSE c_default_rate; end if;
206: IF c_default_status%ISOPEN THEN CLOSE c_default_status; end if;
207:
208: -- Logging Infra: YK: 3/10:

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

220:
221:
222: WHEN OTHERS THEN
223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
225: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
226:
227: IF c_default_rate%ISOPEN THEN CLOSE c_default_rate; end if;
228: IF c_default_status%ISOPEN THEN CLOSE c_default_status; end if;

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

221:
222: WHEN OTHERS THEN
223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
225: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
226:
227: IF c_default_rate%ISOPEN THEN CLOSE c_default_rate; end if;
228: IF c_default_status%ISOPEN THEN CLOSE c_default_status; end if;
229:

Line 414: fnd_message.set_name('ZX','ZX_PARAM_NOT_SET');

410:
411: IF p_country_code is NULL THEN
412: p_return_status:=FND_API.G_RET_STS_ERROR;
413: --p_error_buffer:='One or more of the parameters are not entered';
414: fnd_message.set_name('ZX','ZX_PARAM_NOT_SET');
415: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
416: l_log_msg := 'E: p_country_code is null';
417: FND_LOG.STRING(G_LEVEL_STATEMENT,
418: G_MODULE_NAME || l_procedure_name,

Line 429: fnd_message.set_name('ZX','ZX_COUNTRY_CODE_INVALID');

425:
426: IF NOT is_territory_code_valid(p_country_code) then
427: p_return_status := FND_API.G_RET_STS_ERROR;
428: --p_error_buffer := 'Invalid Country Code: '||p_country_code;
429: fnd_message.set_name('ZX','ZX_COUNTRY_CODE_INVALID');
430: -- Logging Infra: YK: 3/10: Break point
431: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
432: l_log_msg := 'Invalid Country Code: '||p_country_code;
433: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 483: fnd_message.set_name('ZX','ZX_FC_TYPE_NOT_EXIST');

479:
480: IF c_model_intended_use%NOTFOUND then
481: p_return_status := FND_API.G_RET_STS_ERROR;
482: --p_error_buffer := 'Seeded Fiscal Classification Type is missing';
483: fnd_message.set_name('ZX','ZX_FC_TYPE_NOT_EXIST');
484: CLOSE c_model_intended_use;
485:
486: -- Logging Infra: YK: 3/10: Break point
487: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 562: fnd_message.set_name('ZX','ZX_MANY_CATEG_ASSIGNED');

558: IF c_item_category%rowcount>1 THEN
559: p_default_code := NULL;
560: -- p_return_status := FND_API.G_RET_STS_ERROR;
561: -- p_error_buffer := 'Many categories assigned';
562: fnd_message.set_name('ZX','ZX_MANY_CATEG_ASSIGNED');
563: CLOSE c_item_category;
564:
565: -- Logging Infra: YK: 3/10: Break point:
566: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 595: fnd_message.set_name('ZX','ZX_ITEM_CAT_NOT_EXIST');

591: IF c_category_code%NOTFOUND THEN
592: p_default_code := NULL;
593: --p_return_status := FND_API.G_RET_STS_ERROR;
594: --p_error_buffer := 'Category Code does not exists';
595: fnd_message.set_name('ZX','ZX_ITEM_CAT_NOT_EXIST');
596: CLOSE c_category_code;
597:
598: -- Logging Infra: YK: 3/10: Break point:
599: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

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

861:
862: EXCEPTION
863: WHEN INVALID_CURSOR THEN
864: p_return_status := FND_API.G_RET_STS_ERROR;
865: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
866: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
867:
868: IF c_country_default%isopen THEN CLOSE c_country_default; END IF;
869: IF c_model_Intended_use%isopen THEN CLOSE c_model_Intended_use; END IF;

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

862: EXCEPTION
863: WHEN INVALID_CURSOR THEN
864: p_return_status := FND_API.G_RET_STS_ERROR;
865: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
866: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
867:
868: IF c_country_default%isopen THEN CLOSE c_country_default; END IF;
869: IF c_model_Intended_use%isopen THEN CLOSE c_model_Intended_use; END IF;
870: IF c_item_category%isopen THEN CLOSE c_item_category; END IF;

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

889:
890:
891: WHEN OTHERS THEN
892: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
893: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
894: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
895:
896: IF c_country_default%isopen THEN CLOSE c_country_default; END IF;
897: IF c_model_Intended_use%isopen THEN CLOSE c_model_Intended_use; END IF;

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

890:
891: WHEN OTHERS THEN
892: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
893: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
894: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
895:
896: IF c_country_default%isopen THEN CLOSE c_country_default; END IF;
897: IF c_model_Intended_use%isopen THEN CLOSE c_model_Intended_use; END IF;
898: IF c_item_category%isopen THEN CLOSE c_item_category; END IF;

Line 1001: fnd_message.set_name('ZX','ZX_PARAM_NOT_SET');

997:
998: IF p_country_code is NULL THEN
999: p_return_status:=FND_API.G_RET_STS_ERROR;
1000: --p_error_buffer:='One or more of the parameters are not entered';
1001: fnd_message.set_name('ZX','ZX_PARAM_NOT_SET');
1002:
1003: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1004: l_log_msg := 'E: p_country_code is null';
1005: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 1016: fnd_message.set_name('ZX','ZX_COUNTRY_CODE_INVALID');

1012:
1013: IF NOT is_territory_code_valid(p_country_code) then
1014: p_return_status := FND_API.G_RET_STS_ERROR;
1015: --p_error_buffer := 'Invalid Country Code: '||p_country_code;
1016: fnd_message.set_name('ZX','ZX_COUNTRY_CODE_INVALID');
1017: -- Logging Infra: YK: 3/10: Break point
1018: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1019: l_log_msg := 'Invalid Country Code: '||p_country_code;
1020: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 1040: fnd_message.set_name('ZX','ZX_COUNTRY_DEFFAULTS_NOT_EXIST');

1036:
1037: IF c_country_default%NOTFOUND then
1038: -- p_return_status := FND_API.G_RET_STS_ERROR;
1039: --p_error_buffer := 'No defaults have been defined for the country';
1040: fnd_message.set_name('ZX','ZX_COUNTRY_DEFFAULTS_NOT_EXIST');
1041: CLOSE c_country_default;
1042:
1043: -- Logging Infra: YK: 3/12: Break point
1044: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1091: fnd_message.set_name('ZX','ZX_MANY_CATEG_ASSIGNED');

1087: IF c_item_category%rowcount>1 THEN
1088: p_default_code := NULL;
1089: -- p_return_status := FND_API.G_RET_STS_ERROR;
1090: --p_error_buffer := 'Many categories assigned under same Category Set';
1091: fnd_message.set_name('ZX','ZX_MANY_CATEG_ASSIGNED');
1092: CLOSE c_item_category;
1093:
1094: -- Logging Infra: YK: 3/12: Break point:
1095: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1127: fnd_message.set_name('ZX','ZX_NO_DEFAULT_DERIVED');

1123: CLOSE c_default_category ;
1124: p_default_code := NULL;
1125: -- p_return_status := FND_API.G_RET_STS_ERROR;
1126: --p_error_buffer := 'No default value could be derived';
1127: fnd_message.set_name('ZX','ZX_NO_DEFAULT_DERIVED');
1128:
1129: -- Logging Infra: YK: 3/12: Break point:
1130: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1131: l_log_msg := 'E: CUR: c_default_category: notfound: category_set_id=' || l_category_set;

Line 1159: fnd_message.set_name('ZX','ZX_FC_CATEG_NOT_EXIST');

1155: IF c_category_code%NOTFOUND THEN
1156: p_default_code := NULL;
1157: --p_return_status := FND_API.G_RET_STS_ERROR;
1158: --p_error_buffer := 'Classification Category Code does not exists';
1159: fnd_message.set_name('ZX','ZX_FC_CATEG_NOT_EXIST');
1160:
1161: CLOSE c_category_code;
1162:
1163: -- Logging Infra: YK: 3/12: Break point:

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

1196:
1197: EXCEPTION
1198: WHEN INVALID_CURSOR THEN
1199: p_return_status := FND_API.G_RET_STS_ERROR;
1200: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1201: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1202:
1203: IF c_country_default%ISOPEN THEN CLOSE c_country_default; END IF;
1204: IF c_item_category%ISOPEN THEN CLOSE c_item_category; END IF;

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

1197: EXCEPTION
1198: WHEN INVALID_CURSOR THEN
1199: p_return_status := FND_API.G_RET_STS_ERROR;
1200: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1201: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1202:
1203: IF c_country_default%ISOPEN THEN CLOSE c_country_default; END IF;
1204: IF c_item_category%ISOPEN THEN CLOSE c_item_category; END IF;
1205: IF c_default_category%ISOPEN THEN CLOSE c_default_category; END IF;

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

1224:
1225:
1226: WHEN OTHERS THEN
1227: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1228: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1229: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1230:
1231: IF c_country_default%ISOPEN THEN CLOSE c_country_default; END IF;
1232: IF c_item_category%ISOPEN THEN CLOSE c_item_category; END IF;

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

1225:
1226: WHEN OTHERS THEN
1227: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1228: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1229: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1230:
1231: IF c_country_default%ISOPEN THEN CLOSE c_country_default; END IF;
1232: IF c_item_category%ISOPEN THEN CLOSE c_item_category; END IF;
1233: IF c_default_category%ISOPEN THEN CLOSE c_default_category; END IF;

Line 1423: fnd_message.set_name('ZX','ZX_PTP_ID_NOT_EXIST');

1419: -- Logging Infra: Statement level
1420:
1421: --x_return_status := FND_API.G_RET_STS_ERROR;
1422: --return (NULL);
1423: fnd_message.set_name('ZX','ZX_PTP_ID_NOT_EXIST');
1424: RAISE FND_API.G_EXC_ERROR;
1425:
1426: ELSE
1427: -- Try Default Registration First

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

1445: WHEN NO_DATA_FOUND THEN
1446: /*
1447: --Return(Null);
1448: x_return_status := FND_API.G_RET_STS_ERROR;
1449: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1450: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1451:
1452: -- Logging Infra: Statement level
1453: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1446: /*
1447: --Return(Null);
1448: x_return_status := FND_API.G_RET_STS_ERROR;
1449: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1450: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1451:
1452: -- Logging Infra: Statement level
1453: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1454: l_log_msg := 'NO DATA FOUND EXCEP - Error Message: '||SQLERRM;

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

1458: */
1459: NULL;
1460: WHEN INVALID_CURSOR THEN
1461: x_return_status := FND_API.G_RET_STS_ERROR;
1462: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1463: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1464:
1465: WHEN FND_API.G_EXC_ERROR THEN
1466: x_return_status := FND_API.G_RET_STS_ERROR;

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

1459: NULL;
1460: WHEN INVALID_CURSOR THEN
1461: x_return_status := FND_API.G_RET_STS_ERROR;
1462: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1463: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1464:
1465: WHEN FND_API.G_EXC_ERROR THEN
1466: x_return_status := FND_API.G_RET_STS_ERROR;
1467: -- Logging Infra: Statement level

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

1471: END IF;
1472:
1473: WHEN OTHERS THEN
1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1475: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1476: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1477: -- Logging Infra: Statement level
1478: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1479: l_log_msg := 'Error Message: '||SQLERRM;

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

1472:
1473: WHEN OTHERS THEN
1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1475: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1476: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1477: -- Logging Infra: Statement level
1478: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1479: l_log_msg := 'Error Message: '||SQLERRM;
1480: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

Line 1507: FND_MESSAGE.Set_Name ('ZX','ZX_REG_NUM_MANDATORY');

1503: and ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
1504: and ptp.party_id = xle.party_id;
1505: ELSE
1506: x_return_status := FND_API.G_RET_STS_ERROR;
1507: FND_MESSAGE.Set_Name ('ZX','ZX_REG_NUM_MANDATORY');
1508: END IF;
1509: return l_legal_entity_id;
1510: EXCEPTION WHEN NO_DATA_FOUND THEN
1511: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1512: FND_MESSAGE.Set_Name ('ZX','ZX_REG_LE_NOT_FOUND');

1508: END IF;
1509: return l_legal_entity_id;
1510: EXCEPTION WHEN NO_DATA_FOUND THEN
1511: x_return_status := FND_API.G_RET_STS_ERROR;
1512: FND_MESSAGE.Set_Name ('ZX','ZX_REG_LE_NOT_FOUND');
1513: --
1514: WHEN TOO_MANY_ROWS THEN
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516: FND_MESSAGE.Set_Name ('ZX','ZX_REG_MANY_LEGAL_ENTITY');

Line 1516: FND_MESSAGE.Set_Name ('ZX','ZX_REG_MANY_LEGAL_ENTITY');

1512: FND_MESSAGE.Set_Name ('ZX','ZX_REG_LE_NOT_FOUND');
1513: --
1514: WHEN TOO_MANY_ROWS THEN
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516: FND_MESSAGE.Set_Name ('ZX','ZX_REG_MANY_LEGAL_ENTITY');
1517: --
1518: END get_le_from_tax_registration;
1519:
1520: PROCEDURE get_fc_country_def_cache_info (