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_API

Line 89: p_return_status := FND_API.G_RET_STS_SUCCESS;

85: --
86: -- Initialize Return Status and Error Buffer
87: --
88:
89: p_return_status := FND_API.G_RET_STS_SUCCESS;
90:
91: -- Logging Infra: YK: 3/10: Break point
92: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
93: l_log_msg := 'B: input params: p_tax_regime_code=' || p_tax_regime_code ||

Line 103: p_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

99: l_log_msg);
100: END IF;
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

Line 114: --RAISE FND_API.G_EXC_ERROR;

110: G_MODULE_NAME || l_procedure_name,
111: l_log_msg);
112: END IF;
113: RETURN;
114: --RAISE FND_API.G_EXC_ERROR;
115: ELSE
116: OPEN c_default_status;
117: FETCH c_default_status INTO p_tax_status_code;
118:

Line 140: p_return_status := FND_API.G_RET_STS_SUCCESS;

136: G_MODULE_NAME || l_procedure_name,
137: l_log_msg);
138: END IF;
139:
140: p_return_status := FND_API.G_RET_STS_SUCCESS;
141: --p_error_buffer := 'Default Tax Status found';
142:
143: IF c_default_rate%FOUND THEN
144: --p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 144: --p_return_status := FND_API.G_RET_STS_SUCCESS;

140: p_return_status := FND_API.G_RET_STS_SUCCESS;
141: --p_error_buffer := 'Default Tax Status found';
142:
143: IF c_default_rate%FOUND THEN
144: --p_return_status := FND_API.G_RET_STS_SUCCESS;
145: --p_error_buffer := 'Default Tax Status and Rate found';
146:
147: -- Logging Infra: YK: 3/10: Break point
148: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 167: --p_return_status := FND_API.G_RET_STS_SUCCESS;

163:
164: CLOSE c_default_rate;
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

Line 178: --RAISE FND_API.G_EXC_ERROR;

174: FND_LOG.STRING(G_LEVEL_STATEMENT,
175: G_MODULE_NAME || l_procedure_name,
176: l_log_msg);
177: END IF;
178: --RAISE FND_API.G_EXC_ERROR;
179: END IF;
180:
181: CLOSE c_default_status;
182:

Line 202: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 213: WHEN FND_API.G_EXC_ERROR THEN

209: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
210: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
211: END IF;
212:
213: WHEN FND_API.G_EXC_ERROR THEN
214: p_return_status := FND_API.G_RET_STS_ERROR;
215: IF c_default_rate%ISOPEN THEN CLOSE c_default_rate; end if;
216: IF c_default_status%ISOPEN THEN CLOSE c_default_status; end if;
217: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 214: p_return_status := FND_API.G_RET_STS_ERROR;

210: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
211: END IF;
212:
213: WHEN FND_API.G_EXC_ERROR THEN
214: p_return_status := FND_API.G_RET_STS_ERROR;
215: IF c_default_rate%ISOPEN THEN CLOSE c_default_rate; end if;
216: IF c_default_status%ISOPEN THEN CLOSE c_default_status; end if;
217: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
218: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);

Line 223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 405: p_return_status := FND_API.G_RET_STS_SUCCESS;

401: --
402: -- Initialize Return Status and Error Buffer
403: --
404: p_default_code:= Null;
405: p_return_status := FND_API.G_RET_STS_SUCCESS;
406: l_classif_code :=null;
407: /* Bug 7483584 ,7519329*/
408: l_country_code := p_country_code;
409:

Line 415: p_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

411: FETCH c_delimiter INTO g_delimiter;
412: CLOSE c_delimiter;
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';

Line 426: -- RAISE FND_API.G_EXC_ERROR;

422: l_log_msg);
423: END IF;
424:
425: RETURN;
426: -- RAISE FND_API.G_EXC_ERROR;
427: ELSE
428:
429: IF NOT is_territory_code_valid(p_country_code) then
430: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 430: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

426: -- RAISE FND_API.G_EXC_ERROR;
427: ELSE
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

Line 497: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

493: l_log_msg);
494: END IF;
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:

Line 510: -- RAISE FND_API.G_EXC_ERROR;

506: G_MODULE_NAME || l_procedure_name,
507: l_log_msg);
508: END IF;
509: RETURN;
510: -- RAISE FND_API.G_EXC_ERROR;
511: END IF;
512:
513: CLOSE c_model_intended_use;
514: END IF; -- model intended use found in cache

Line 582: -- p_return_status := FND_API.G_RET_STS_ERROR;

578: END IF;
579:
580: IF c_item_category%rowcount>1 THEN
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;

Line 598: -- RAISE FND_API.G_EXC_ERROR;

594: G_MODULE_NAME || l_procedure_name,
595: l_log_msg);
596: END IF;
597: RETURN;
598: -- RAISE FND_API.G_EXC_ERROR;
599: END IF;
600:
601: CLOSE c_item_category;
602:

Line 616: --p_return_status := FND_API.G_RET_STS_ERROR;

612: END IF;
613:
614: IF c_category_code%NOTFOUND THEN
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;

Line 632: -- RAISE FND_API.G_EXC_ERROR;

628: l_log_msg);
629: END IF;
630:
631: RETURN;
632: -- RAISE FND_API.G_EXC_ERROR;
633: END IF;
634:
635: p_default_code := l_category_code;
636:

Line 902: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 916: WHEN FND_API.G_EXC_ERROR THEN

912: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
913: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
914: END IF;
915:
916: WHEN FND_API.G_EXC_ERROR THEN
917: p_return_status := FND_API.G_RET_STS_ERROR;
918: IF c_country_default%isopen THEN CLOSE c_country_default; END IF;
919: IF c_model_Intended_use%isopen THEN CLOSE c_model_Intended_use; END IF;
920: IF c_item_category%isopen THEN CLOSE c_item_category; END IF;

Line 917: p_return_status := FND_API.G_RET_STS_ERROR;

913: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
914: END IF;
915:
916: WHEN FND_API.G_EXC_ERROR THEN
917: p_return_status := FND_API.G_RET_STS_ERROR;
918: IF c_country_default%isopen THEN CLOSE c_country_default; END IF;
919: IF c_model_Intended_use%isopen THEN CLOSE c_model_Intended_use; END IF;
920: IF c_item_category%isopen THEN CLOSE c_item_category; END IF;
921: IF c_category_code%isopen THEN CLOSE c_category_code; END IF;

Line 930: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1034: p_return_status := FND_API.G_RET_STS_SUCCESS;

1030: --
1031: -- Initialize Return Status and Error Buffer
1032: --
1033: p_default_code:= Null;
1034: p_return_status := FND_API.G_RET_STS_SUCCESS;
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';

Line 1037: p_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

1033: p_default_code:= Null;
1034: p_return_status := FND_API.G_RET_STS_SUCCESS;
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

Line 1048: --RAISE FND_API.G_EXC_ERROR;

1044: G_MODULE_NAME || l_procedure_name,
1045: l_log_msg);
1046: END IF;
1047: RETURN;
1048: --RAISE FND_API.G_EXC_ERROR;
1049: ELSE
1050:
1051: IF NOT is_territory_code_valid(p_country_code) then
1052: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1052: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1048: --RAISE FND_API.G_EXC_ERROR;
1049: ELSE
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

Line 1076: -- p_return_status := FND_API.G_RET_STS_ERROR;

1072: l_log_msg);
1073: END IF;
1074:
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;

Line 1090: -- RAISE FND_API.G_EXC_ERROR;

1086: G_MODULE_NAME || l_procedure_name,
1087: l_log_msg);
1088: END IF;
1089: return;
1090: -- RAISE FND_API.G_EXC_ERROR;
1091:
1092: ELSE
1093: -- data found. Store in cache.
1094:

Line 1128: -- p_return_status := FND_API.G_RET_STS_ERROR;

1124: END IF;
1125:
1126: IF c_item_category%rowcount>1 THEN
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;

Line 1145: --RAISE FND_API.G_EXC_ERROR;

1141: l_log_msg);
1142: END IF;
1143:
1144: RETURN;
1145: --RAISE FND_API.G_EXC_ERROR;
1146: END IF;
1147:
1148: IF c_item_category%notfound THEN
1149: -- CLOSE c_item_category; --bug#9855187 --

Line 1166: -- p_return_status := FND_API.G_RET_STS_ERROR;

1162: IF c_default_category%notfound THEN
1163: CLOSE c_default_category ;
1164: CLOSE c_item_category;
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:

Line 1179: --RAISE FND_API.G_EXC_ERROR;

1175: G_MODULE_NAME || l_procedure_name,
1176: l_log_msg);
1177: END IF;
1178: return;
1179: --RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181: CLOSE c_default_category ;
1182: END IF;
1183:

Line 1199: --p_return_status := FND_API.G_RET_STS_ERROR;

1195: END IF;
1196:
1197: IF c_category_code%NOTFOUND THEN
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:

Line 1216: -- RAISE FND_API.G_EXC_ERROR;

1212: l_log_msg);
1213: END IF;
1214:
1215: RETURN;
1216: -- RAISE FND_API.G_EXC_ERROR;
1217: END IF;
1218:
1219: p_default_code := l_category_code;
1220: CLOSE c_category_code;

Line 1242: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1256: WHEN FND_API.G_EXC_ERROR THEN

1252: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1253: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1254: END IF;
1255:
1256: WHEN FND_API.G_EXC_ERROR THEN
1257: p_return_status := FND_API.G_RET_STS_ERROR;
1258: IF c_country_default%ISOPEN THEN CLOSE c_country_default; END IF;
1259: IF c_item_category%ISOPEN THEN CLOSE c_item_category; END IF;
1260: IF c_default_category%ISOPEN THEN CLOSE c_default_category; END IF;

Line 1257: p_return_status := FND_API.G_RET_STS_ERROR;

1253: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1254: END IF;
1255:
1256: WHEN FND_API.G_EXC_ERROR THEN
1257: p_return_status := FND_API.G_RET_STS_ERROR;
1258: IF c_country_default%ISOPEN THEN CLOSE c_country_default; END IF;
1259: IF c_item_category%ISOPEN THEN CLOSE c_item_category; END IF;
1260: IF c_default_category%ISOPEN THEN CLOSE c_default_category; END IF;
1261: IF c_category_code%ISOPEN THEN CLOSE c_category_code; END IF;

Line 1270: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1444: x_return_status := FND_API.G_RET_STS_SUCCESS;

1440: -- Logging Infra: Statement level
1441:
1442: -- Initialize Return Status and Error Buffer
1443: --
1444: x_return_status := FND_API.G_RET_STS_SUCCESS;
1445:
1446: -- Set initial value for effective date in case it comes null
1447: IF p_effective_date is null Then
1448: l_Effective_Date:= sysdate;

Line 1464: --x_return_status := FND_API.G_RET_STS_ERROR;

1460: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1461: END IF;
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:

Line 1467: RAISE FND_API.G_EXC_ERROR;

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
1471: For Regis IN Default_Reg Loop

Line 1491: x_return_status := FND_API.G_RET_STS_ERROR;

1487: EXCEPTION
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

Line 1504: x_return_status := FND_API.G_RET_STS_ERROR;

1500: -- Logging Infra: Statement level
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

Line 1508: WHEN FND_API.G_EXC_ERROR 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
1511: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1512: l_log_msg := 'NO DATA FOUND EXCEP - Error Message: '||SQLERRM;

Line 1509: 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
1511: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1512: l_log_msg := 'NO DATA FOUND EXCEP - Error Message: '||SQLERRM;
1513: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

Line 1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1513: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
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

Line 1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1546: and tr.party_tax_profile_id = ptp.party_tax_profile_id
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',

Line 1560: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1564: x_return_status := FND_API.G_RET_STS_ERROR;

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');
1566: --
1567: END get_le_from_tax_registration;
1568:

Line 1582: x_return_status := FND_API.G_RET_STS_SUCCESS;

1578:
1579: BEGIN
1580:
1581: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1582: x_return_status := FND_API.G_RET_STS_SUCCESS;
1583: x_found_in_cache := FALSE;
1584:
1585: IF (g_level_statement >= g_current_runtime_level ) THEN
1586: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info.BEGIN',