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_UNEXP_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 417: --fnd_message.set_name('ZX','ZX_PARAM_NOT_SET');

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

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

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

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

495:
496: IF c_model_intended_use%NOTFOUND then
497: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
498: --p_error_buffer := 'Seeded Fiscal Classification Type is missing';
499: --fnd_message.set_name('ZX','ZX_FC_TYPE_NOT_EXIST');
500: CLOSE c_model_intended_use;
501:
502: -- Logging Infra: YK: 3/10: Break point
503: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

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

581: p_default_code := NULL;
582: -- p_return_status := FND_API.G_RET_STS_ERROR;
583: -- p_error_buffer := 'Many categories assigned';
584: --Commented the code to set the message for Bug#9485527
585: --fnd_message.set_name('ZX','ZX_MANY_CATEG_ASSIGNED');
586: CLOSE c_item_category;
587:
588: -- Logging Infra: YK: 3/10: Break point:
589: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

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

615: p_default_code := NULL;
616: --p_return_status := FND_API.G_RET_STS_ERROR;
617: --p_error_buffer := 'Category Code does not exists';
618: --Commented the code to set the message for Bug#9485527
619: --fnd_message.set_name('ZX','ZX_ITEM_CAT_NOT_EXIST');
620: CLOSE c_category_code;
621:
622: -- Logging Infra: YK: 3/10: Break point:
623: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

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

899:
900: EXCEPTION
901: WHEN INVALID_CURSOR THEN
902: p_return_status := FND_API.G_RET_STS_ERROR;
903: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
904: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
905:
906: IF c_country_default%isopen THEN CLOSE c_country_default; END IF;
907: IF c_model_Intended_use%isopen THEN CLOSE c_model_Intended_use; END IF;

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

900: EXCEPTION
901: WHEN INVALID_CURSOR THEN
902: p_return_status := FND_API.G_RET_STS_ERROR;
903: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
904: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
905:
906: IF c_country_default%isopen THEN CLOSE c_country_default; END IF;
907: IF c_model_Intended_use%isopen THEN CLOSE c_model_Intended_use; END IF;
908: IF c_item_category%isopen THEN CLOSE c_item_category; END IF;

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

927:
928:
929: WHEN OTHERS THEN
930: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
931: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
932: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
933:
934: IF c_country_default%isopen THEN CLOSE c_country_default; END IF;
935: IF c_model_Intended_use%isopen THEN CLOSE c_model_Intended_use; END IF;

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

928:
929: WHEN OTHERS THEN
930: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
931: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
932: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
933:
934: IF c_country_default%isopen THEN CLOSE c_country_default; END IF;
935: IF c_model_Intended_use%isopen THEN CLOSE c_model_Intended_use; END IF;
936: IF c_item_category%isopen THEN CLOSE c_item_category; END IF;

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

1035:
1036: IF p_country_code is NULL THEN
1037: p_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1038: --p_error_buffer:='One or more of the parameters are not entered';
1039: --fnd_message.set_name('ZX','ZX_PARAM_NOT_SET');
1040:
1041: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1042: l_log_msg := 'E: p_country_code is null';
1043: FND_LOG.STRING(G_LEVEL_STATEMENT,

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

1050:
1051: IF NOT is_territory_code_valid(p_country_code) then
1052: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: --p_error_buffer := 'Invalid Country Code: '||p_country_code;
1054: --fnd_message.set_name('ZX','ZX_COUNTRY_CODE_INVALID');
1055: -- Logging Infra: YK: 3/10: Break point
1056: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1057: l_log_msg := 'Invalid Country Code: '||p_country_code;
1058: FND_LOG.STRING(G_LEVEL_STATEMENT,

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

1075: IF c_country_default%NOTFOUND then
1076: -- p_return_status := FND_API.G_RET_STS_ERROR;
1077: --p_error_buffer := 'No defaults have been defined for the country';
1078: --Commented the code to set the message for Bug#9485527
1079: --fnd_message.set_name('ZX','ZX_COUNTRY_DEFFAULTS_NOT_EXIST');
1080: CLOSE c_country_default;
1081:
1082: -- Logging Infra: YK: 3/12: Break point
1083: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

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

1127: p_default_code := NULL;
1128: -- p_return_status := FND_API.G_RET_STS_ERROR;
1129: --p_error_buffer := 'Many categories assigned under same Category Set';
1130: --Commented the code to set the message for Bug#9485527
1131: --fnd_message.set_name('ZX','ZX_MANY_CATEG_ASSIGNED');
1132: CLOSE c_item_category;
1133:
1134: -- Logging Infra: YK: 3/12: Break point:
1135: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

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

1165: p_default_code := NULL;
1166: -- p_return_status := FND_API.G_RET_STS_ERROR;
1167: --p_error_buffer := 'No default value could be derived';
1168: --Commented the code to set the message for Bug#9485527
1169: --fnd_message.set_name('ZX','ZX_NO_DEFAULT_DERIVED');
1170:
1171: -- Logging Infra: YK: 3/12: Break point:
1172: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1173: l_log_msg := 'E: CUR: c_default_category: notfound: category_set_id=' || l_category_set;

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

1198: p_default_code := NULL;
1199: --p_return_status := FND_API.G_RET_STS_ERROR;
1200: --p_error_buffer := 'Classification Category Code does not exists';
1201: --Commented the code to set the message for Bug#9485527
1202: --fnd_message.set_name('ZX','ZX_FC_CATEG_NOT_EXIST');
1203:
1204: CLOSE c_category_code;
1205:
1206: -- Logging Infra: YK: 3/12: Break point:

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

1239:
1240: EXCEPTION
1241: WHEN INVALID_CURSOR THEN
1242: p_return_status := FND_API.G_RET_STS_ERROR;
1243: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1244: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1245:
1246: IF c_country_default%ISOPEN THEN CLOSE c_country_default; END IF;
1247: IF c_item_category%ISOPEN THEN CLOSE c_item_category; END IF;

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

1240: EXCEPTION
1241: WHEN INVALID_CURSOR THEN
1242: p_return_status := FND_API.G_RET_STS_ERROR;
1243: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1244: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1245:
1246: IF c_country_default%ISOPEN THEN CLOSE c_country_default; END IF;
1247: IF c_item_category%ISOPEN THEN CLOSE c_item_category; END IF;
1248: IF c_default_category%ISOPEN THEN CLOSE c_default_category; END IF;

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

1267:
1268:
1269: WHEN OTHERS THEN
1270: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1271: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1272: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1273:
1274: IF c_country_default%ISOPEN THEN CLOSE c_country_default; END IF;
1275: IF c_item_category%ISOPEN THEN CLOSE c_item_category; END IF;

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

1268:
1269: WHEN OTHERS THEN
1270: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1271: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1272: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1273:
1274: IF c_country_default%ISOPEN THEN CLOSE c_country_default; END IF;
1275: IF c_item_category%ISOPEN THEN CLOSE c_item_category; END IF;
1276: IF c_default_category%ISOPEN THEN CLOSE c_default_category; END IF;

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

1462: -- Logging Infra: Statement level
1463:
1464: --x_return_status := FND_API.G_RET_STS_ERROR;
1465: --return (NULL);
1466: fnd_message.set_name('ZX','ZX_PTP_ID_NOT_EXIST');
1467: RAISE FND_API.G_EXC_ERROR;
1468:
1469: ELSE
1470: -- Try Default Registration First

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

1488: WHEN NO_DATA_FOUND THEN
1489: /*
1490: --Return(Null);
1491: x_return_status := FND_API.G_RET_STS_ERROR;
1492: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1493: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1494:
1495: -- Logging Infra: Statement level
1496: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1489: /*
1490: --Return(Null);
1491: x_return_status := FND_API.G_RET_STS_ERROR;
1492: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1493: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1494:
1495: -- Logging Infra: Statement level
1496: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1497: l_log_msg := 'NO DATA FOUND EXCEP - Error Message: '||SQLERRM;

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

1501: */
1502: NULL;
1503: WHEN INVALID_CURSOR THEN
1504: x_return_status := FND_API.G_RET_STS_ERROR;
1505: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1506: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1507:
1508: WHEN FND_API.G_EXC_ERROR THEN
1509: x_return_status := FND_API.G_RET_STS_ERROR;

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

1502: NULL;
1503: WHEN INVALID_CURSOR THEN
1504: x_return_status := FND_API.G_RET_STS_ERROR;
1505: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1506: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1507:
1508: WHEN FND_API.G_EXC_ERROR THEN
1509: x_return_status := FND_API.G_RET_STS_ERROR;
1510: -- Logging Infra: Statement level

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

1514: END IF;
1515:
1516: WHEN OTHERS THEN
1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1518: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1519: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1520: -- Logging Infra: Statement level
1521: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1522: l_log_msg := 'Error Message: '||SQLERRM;

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

1515:
1516: WHEN OTHERS THEN
1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1518: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1519: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1520: -- Logging Infra: Statement level
1521: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1522: l_log_msg := 'Error Message: '||SQLERRM;
1523: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

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

1547: and ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
1548: and ptp.party_id = xle.party_id;
1549: ELSE
1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1551: --FND_MESSAGE.Set_Name ('ZX','ZX_REG_NUM_MANDATORY');
1552: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1553: FND_LOG.STRING(G_LEVEL_STATEMENT,
1554: G_MODULE_NAME || 'get_le_from_tax_registration',
1555: 'Registration Number is mandatory but it is null.');

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

1557: END IF;
1558: return l_legal_entity_id;
1559: EXCEPTION WHEN NO_DATA_FOUND THEN
1560: x_return_status := FND_API.G_RET_STS_ERROR;
1561: FND_MESSAGE.Set_Name ('ZX','ZX_REG_LE_NOT_FOUND');
1562: --
1563: WHEN TOO_MANY_ROWS THEN
1564: x_return_status := FND_API.G_RET_STS_ERROR;
1565: FND_MESSAGE.Set_Name ('ZX','ZX_REG_MANY_LEGAL_ENTITY');

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

1561: FND_MESSAGE.Set_Name ('ZX','ZX_REG_LE_NOT_FOUND');
1562: --
1563: WHEN TOO_MANY_ROWS THEN
1564: x_return_status := FND_API.G_RET_STS_ERROR;
1565: FND_MESSAGE.Set_Name ('ZX','ZX_REG_MANY_LEGAL_ENTITY');
1566: --
1567: END get_le_from_tax_registration;
1568:
1569: PROCEDURE get_fc_country_def_cache_info (