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_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_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 404: p_return_status := FND_API.G_RET_STS_SUCCESS;

400: --
401: -- Initialize Return Status and Error Buffer
402: --
403: p_default_code:= Null;
404: p_return_status := FND_API.G_RET_STS_SUCCESS;
405: l_classif_code :=null;
406:
407: OPEN c_delimiter;
408: FETCH c_delimiter INTO g_delimiter;

Line 412: p_return_status:=FND_API.G_RET_STS_ERROR;

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

Line 423: -- RAISE FND_API.G_EXC_ERROR;

419: l_log_msg);
420: END IF;
421:
422: RETURN;
423: -- RAISE FND_API.G_EXC_ERROR;
424: ELSE
425:
426: IF NOT is_territory_code_valid(p_country_code) then
427: p_return_status := FND_API.G_RET_STS_ERROR;

Line 427: p_return_status := FND_API.G_RET_STS_ERROR;

423: -- RAISE FND_API.G_EXC_ERROR;
424: ELSE
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

Line 481: p_return_status := FND_API.G_RET_STS_ERROR;

477: l_log_msg);
478: END IF;
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:

Line 494: -- RAISE FND_API.G_EXC_ERROR;

490: G_MODULE_NAME || l_procedure_name,
491: l_log_msg);
492: END IF;
493: return;
494: -- RAISE FND_API.G_EXC_ERROR;
495: END IF;
496:
497: CLOSE c_model_intended_use;
498: END IF; -- model intended use found in cache

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

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

Line 575: -- RAISE FND_API.G_EXC_ERROR;

571: G_MODULE_NAME || l_procedure_name,
572: l_log_msg);
573: END IF;
574: RETURN;
575: -- RAISE FND_API.G_EXC_ERROR;
576: END IF;
577:
578: CLOSE c_item_category;
579:

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

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

Line 608: -- RAISE FND_API.G_EXC_ERROR;

604: l_log_msg);
605: END IF;
606:
607: RETURN;
608: -- RAISE FND_API.G_EXC_ERROR;
609: END IF;
610:
611: p_default_code := l_category_code;
612:

Line 864: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 878: WHEN FND_API.G_EXC_ERROR THEN

874: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
875: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
876: END IF;
877:
878: WHEN FND_API.G_EXC_ERROR THEN
879: p_return_status := FND_API.G_RET_STS_ERROR;
880: IF c_country_default%isopen THEN CLOSE c_country_default; END IF;
881: IF c_model_Intended_use%isopen THEN CLOSE c_model_Intended_use; END IF;
882: IF c_item_category%isopen THEN CLOSE c_item_category; END IF;

Line 879: p_return_status := FND_API.G_RET_STS_ERROR;

875: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
876: END IF;
877:
878: WHEN FND_API.G_EXC_ERROR THEN
879: p_return_status := FND_API.G_RET_STS_ERROR;
880: IF c_country_default%isopen THEN CLOSE c_country_default; END IF;
881: IF c_model_Intended_use%isopen THEN CLOSE c_model_Intended_use; END IF;
882: IF c_item_category%isopen THEN CLOSE c_item_category; END IF;
883: IF c_category_code%isopen THEN CLOSE c_category_code; END IF;

Line 892: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 996: p_return_status := FND_API.G_RET_STS_SUCCESS;

992: --
993: -- Initialize Return Status and Error Buffer
994: --
995: p_default_code:= Null;
996: p_return_status := FND_API.G_RET_STS_SUCCESS;
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';

Line 999: p_return_status:=FND_API.G_RET_STS_ERROR;

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

Line 1010: --RAISE FND_API.G_EXC_ERROR;

1006: G_MODULE_NAME || l_procedure_name,
1007: l_log_msg);
1008: END IF;
1009: RETURN;
1010: --RAISE FND_API.G_EXC_ERROR;
1011: ELSE
1012:
1013: IF NOT is_territory_code_valid(p_country_code) then
1014: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1014: p_return_status := FND_API.G_RET_STS_ERROR;

1010: --RAISE FND_API.G_EXC_ERROR;
1011: ELSE
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

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

1034: l_log_msg);
1035: END IF;
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:

Line 1051: -- RAISE FND_API.G_EXC_ERROR;

1047: G_MODULE_NAME || l_procedure_name,
1048: l_log_msg);
1049: END IF;
1050: return;
1051: -- RAISE FND_API.G_EXC_ERROR;
1052:
1053: ELSE
1054: -- data found. Store in cache.
1055:

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

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

Line 1105: --RAISE FND_API.G_EXC_ERROR;

1101: l_log_msg);
1102: END IF;
1103:
1104: RETURN;
1105: --RAISE FND_API.G_EXC_ERROR;
1106: END IF;
1107:
1108: IF c_item_category%notfound THEN
1109: CLOSE c_item_category;

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

1121:
1122: IF c_default_category%notfound THEN
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:

Line 1137: --RAISE FND_API.G_EXC_ERROR;

1133: G_MODULE_NAME || l_procedure_name,
1134: l_log_msg);
1135: END IF;
1136: return;
1137: --RAISE FND_API.G_EXC_ERROR;
1138: END IF;
1139: CLOSE c_default_category ;
1140: END IF;
1141:

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

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

Line 1173: -- RAISE FND_API.G_EXC_ERROR;

1169: l_log_msg);
1170: END IF;
1171:
1172: RETURN;
1173: -- RAISE FND_API.G_EXC_ERROR;
1174: END IF;
1175:
1176: p_default_code := l_category_code;
1177: CLOSE c_category_code;

Line 1199: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1213: WHEN FND_API.G_EXC_ERROR THEN

1209: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1210: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1211: END IF;
1212:
1213: WHEN FND_API.G_EXC_ERROR THEN
1214: p_return_status := FND_API.G_RET_STS_ERROR;
1215: IF c_country_default%ISOPEN THEN CLOSE c_country_default; END IF;
1216: IF c_item_category%ISOPEN THEN CLOSE c_item_category; END IF;
1217: IF c_default_category%ISOPEN THEN CLOSE c_default_category; END IF;

Line 1214: p_return_status := FND_API.G_RET_STS_ERROR;

1210: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name,SQLCODE || ': ' || SQLERRM);
1211: END IF;
1212:
1213: WHEN FND_API.G_EXC_ERROR THEN
1214: p_return_status := FND_API.G_RET_STS_ERROR;
1215: IF c_country_default%ISOPEN THEN CLOSE c_country_default; END IF;
1216: IF c_item_category%ISOPEN THEN CLOSE c_item_category; END IF;
1217: IF c_default_category%ISOPEN THEN CLOSE c_default_category; END IF;
1218: IF c_category_code%ISOPEN THEN CLOSE c_category_code; END IF;

Line 1227: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1401: x_return_status := FND_API.G_RET_STS_SUCCESS;

1397: -- Logging Infra: Statement level
1398:
1399: -- Initialize Return Status and Error Buffer
1400: --
1401: x_return_status := FND_API.G_RET_STS_SUCCESS;
1402:
1403: -- Set initial value for effective date in case it comes null
1404: IF p_effective_date is null Then
1405: l_Effective_Date:= sysdate;

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

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

Line 1424: RAISE FND_API.G_EXC_ERROR;

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

Line 1448: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1461: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1506: x_return_status := FND_API.G_RET_STS_ERROR;

1502: and tr.party_tax_profile_id = ptp.party_tax_profile_id
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

Line 1511: 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;
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;

Line 1515: x_return_status := FND_API.G_RET_STS_ERROR;

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');
1517: --
1518: END get_le_from_tax_registration;
1519:

Line 1533: x_return_status := FND_API.G_RET_STS_SUCCESS;

1529:
1530: BEGIN
1531:
1532: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1533: x_return_status := FND_API.G_RET_STS_SUCCESS;
1534: x_found_in_cache := FALSE;
1535:
1536: IF (g_level_statement >= g_current_runtime_level ) THEN
1537: FND_LOG.STRING(g_level_statement, 'ZX.PLSQL.ZX_TCM_EXT_SERVICES_PUB.get_fc_country_def_cache_info.BEGIN',