DBA Data[Home] [Help]

APPS.ZX_TCM_CONTROL_PKG dependencies on FND_MESSAGE

Line 333: fnd_message.set_name('ZX','ZX_INV_NOT_ENABLED');

329:
330: IF zx_global_Structures_pkg.g_inventory_installed_flag = 'N' THEN
331: --p_return_status:=FND_API.G_RET_STS_ERROR;
332: --p_error_buffer:='Inventory is not enabled';
333: fnd_message.set_name('ZX','ZX_INV_NOT_ENABLED');
334: p_fsc_rec.fsc_code:= null;
335:
336: -- Logging Infra: YK: 3/5: Statement level: "E" means "E"rror
337: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

403: IF c_inventory_set%NOTFOUND THEN
404: p_return_status:= FND_API.G_RET_STS_SUCCESS;
405: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
406: --p_error_buffer:='Fiscal Type Code does not exits';
407: --fnd_message.set_name('ZX','ZX_FC_TYPE_NOT_EXIST');
408: CLOSE c_inventory_set;
409: --return;
410: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
411: l_log_msg :='Fiscal Type Code does not exits';

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

472: END IF;
473:
474: IF c_category%NOTFOUND THEN
475: --p_error_buffer:= 'Fiscal Classification Code does not have an equivalent Item Category Code';
476: fnd_message.set_name('ZX','ZX_ITEM_CAT_NOT_EXIST');
477: p_return_status:= FND_API.G_RET_STS_SUCCESS;
478: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
479: CLOSE c_category;
480: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 502: fnd_message.set_name('ZX','ZX_FC_NOT_ALLOC_ENTITY_ID');

498: OPEN c_item_category_child;
499: FETCH c_item_category_child INTO l_allocated_flag;
500:
501: IF c_item_category_child%NOTFOUND THEN
502: fnd_message.set_name('ZX','ZX_FC_NOT_ALLOC_ENTITY_ID');
503: p_return_status:= FND_API.G_RET_STS_SUCCESS;
504: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
505: CLOSE c_item_category_child;
506: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 592: fnd_message.set_name('ZX','ZX_REGIME_NOT_VALID');

588:
589: if c_parent_regime_assoc%notfound then
590: p_return_status:=FND_API.G_RET_STS_SUCCESS;
591: --p_error_buffer:='Regime for the given Fiscal Type is not valid ';
592: fnd_message.set_name('ZX','ZX_REGIME_NOT_VALID');
593: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
594: close c_parent_regime_assoc;
595: --return;
596: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

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

621: if c_tca_class_category%notfound then
622: p_return_status:=FND_API.G_RET_STS_SUCCESS;
623: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
624: --p_error_buffer:='Fiscal Type Code does not exits';
625: --fnd_message.set_name('ZX','ZX_FC_TYPE_NOT_EXIST');
626: close c_tca_class_category;
627: --return;
628: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
629: l_log_msg :='Fiscal Type Code does not exits';

Line 644: --fnd_message.set_name('ZX','ZX_FC_INV_CAT_NOT_EXIST');

640: if l_tca_class_category_code is null then
641: p_return_status:=FND_API.G_RET_STS_SUCCESS;
642: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
643: --p_error_buffer:='Foreign Key broken:Fiscal Type Code does not have Class Category associated';
644: --fnd_message.set_name('ZX','ZX_FC_INV_CAT_NOT_EXIST');
645: -- Logging Infra: YK: 3/5: Error l_tca_class_category_code is null
646: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
647: l_log_msg := 'E: CUR: c_tca_class_category: l_tca_class_category_code is null: ' ||
648: 'classification_type_code='|| p_fsc_rec.classification_type;

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

681:
682: if c_party_tax_profile_id%notfound then
683: --p_return_status:=FND_API.G_RET_STS_ERROR;
684: --p_error_buffer:='Party Tax Profile ID not found';
685: fnd_message.set_name('ZX','ZX_PTP_ID_NOT_EXIST');
686: p_fsc_rec.fsc_code:= null;
687: close c_party_tax_profile_id;
688: --return;
689: RAISE FND_API.G_EXC_ERROR;

Line 711: fnd_message.set_name('ZX','ZX_FC_CODE_PARAM_NOT_EXIST');

707: if c_class_code%notfound then
708: p_fsc_rec.fsc_code := FND_API.G_MISS_CHAR;
709: p_return_status:=FND_API.G_RET_STS_SUCCESS;
710: --p_error_buffer:='Parameter value does not have a corresponding Fiscal Code';
711: fnd_message.set_name('ZX','ZX_FC_CODE_PARAM_NOT_EXIST');
712: close c_class_code;
713: return;
714: --RAISE FND_API.G_EXC_ERROR;
715: else

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

1029: END IF;
1030:
1031: if c_classification_type_code%notfound then
1032: --p_error_buffer:='Fiscal Type Code does not exists';
1033: --fnd_message.set_name('ZX','ZX_FC_TYPE_NOT_EXIST');
1034: close c_classification_type_code;
1035:
1036: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1037: l_log_msg := 'Fiscal Type Code does not exists';

Line 1078: --fnd_message.set_name('ZX','ZX_REGIME_NOT_VALID');

1074:
1075:
1076: if c_parent_regime_assoc%notfound then
1077: --p_error_buffer:='Regime for the given Fiscal Type is not valid ';
1078: --fnd_message.set_name('ZX','ZX_REGIME_NOT_VALID');
1079: close c_parent_regime_assoc;
1080: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1081: l_log_msg := 'Regime for the given Fiscal Type is not valid ';
1082: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 1128: -- fnd_message.set_name('ZX','ZX_FC_NOT_ALLOC_ENTITY_ID');

1124: if c_parent_trxbizcat_fiscalclass%notfound then
1125: p_fsc_rec.fsc_code:= FND_API.G_MISS_CHAR;
1126: p_fsc_rec.effective_from := null;
1127: p_fsc_rec.effective_to := null;
1128: -- fnd_message.set_name('ZX','ZX_FC_NOT_ALLOC_ENTITY_ID');
1129: -- RAISE FND_API.G_EXC_ERROR;
1130: else
1131: p_fsc_rec.effective_from :=l_effective_from;
1132: p_fsc_rec.effective_to :=l_effective_to;

Line 1145: --fnd_message.set_name('ZX','ZX_FC_CATEG_NOT_SUPPORTED');

1141: end if;
1142:
1143: else
1144: --p_error_buffer:='Classification Category not supported by this procedure';
1145: --fnd_message.set_name('ZX','ZX_FC_CATEG_NOT_SUPPORTED');
1146:
1147: -- Logging Infra: YK: 3/5:
1148: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1149: l_log_msg := 'E: unspported category: p_fsc_rec.classification_category=' || p_fsc_rec.classification_category;

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

1168:
1169: EXCEPTION
1170: WHEN INVALID_CURSOR THEN
1171: p_return_status := FND_API.G_RET_STS_ERROR;
1172: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1173: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1174:
1175: if c_regime_assoc%isopen then close c_regime_assoc; end if;
1176: if c_parent_regime_assoc%isopen then close c_parent_regime_assoc; end if;

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

1169: EXCEPTION
1170: WHEN INVALID_CURSOR THEN
1171: p_return_status := FND_API.G_RET_STS_ERROR;
1172: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1173: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1174:
1175: if c_regime_assoc%isopen then close c_regime_assoc; end if;
1176: if c_parent_regime_assoc%isopen then close c_parent_regime_assoc; end if;
1177: if c_inventory_set%isopen then close c_inventory_set; end if;

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

1232: if c_trxbizcat_fiscalclass%isopen then close c_trxbizcat_fiscalclass; end if;
1233:
1234: WHEN OTHERS THEN
1235: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1236: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1237: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1238:
1239: if c_regime_assoc%isopen then close c_regime_assoc; end if;
1240: if c_parent_regime_assoc%isopen then close c_parent_regime_assoc; end if;

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

1233:
1234: WHEN OTHERS THEN
1235: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1236: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1237: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1238:
1239: if c_regime_assoc%isopen then close c_regime_assoc; end if;
1240: if c_parent_regime_assoc%isopen then close c_parent_regime_assoc; end if;
1241: if c_inventory_set%isopen then close c_inventory_set; end if;

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

1333:
1334: if c_delimiter%notfound then
1335: --p_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1336: --p_error_buffer:='Classification Type does not exist';
1337: --fnd_message.set_name('ZX','ZX_FC_TYPE_NOT_EXIST');
1338: close c_delimiter;
1339:
1340: -- Logging Infra: YK: 3/5: c_delimiter notfound
1341: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1454: --fnd_message.set_name('ZX','ZX_FC_CATEG_NOT_SUPPORTED');

1450:
1451: else
1452: --p_return_status:=FND_API.G_RET_STS_ERROR;
1453: --p_error_buffer:='Classification Category not supported by this procedure';
1454: --fnd_message.set_name('ZX','ZX_FC_CATEG_NOT_SUPPORTED');
1455:
1456: -- Logging Infra: YK: 3/5:
1457: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1458: l_log_msg := 'E: unspported category: p_fsc_cat_rec.classification_category= '

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

1475: END IF;
1476: EXCEPTION
1477: WHEN INVALID_CURSOR THEN
1478: p_return_status := FND_API.G_RET_STS_ERROR;
1479: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1480: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1481:
1482: if c_classification_code%isopen then close c_classification_code; end if;
1483: if c_delimiter%isopen then close c_delimiter; end if;

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

1476: EXCEPTION
1477: WHEN INVALID_CURSOR THEN
1478: p_return_status := FND_API.G_RET_STS_ERROR;
1479: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1480: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1481:
1482: if c_classification_code%isopen then close c_classification_code; end if;
1483: if c_delimiter%isopen then close c_delimiter; end if;
1484:

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

1514: if c_delimiter%isopen then close c_delimiter; end if;
1515:
1516: WHEN OTHERS THEN
1517: p_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:
1521: if c_classification_code%isopen then close c_classification_code; end if;
1522: if c_delimiter%isopen then close c_delimiter; end if;

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

1515:
1516: WHEN OTHERS THEN
1517: p_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:
1521: if c_classification_code%isopen then close c_classification_code; end if;
1522: if c_delimiter%isopen then close c_delimiter; end if;
1523:

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

1940: WHEN NO_DATA_FOUND THEN
1941: NULL;
1942: WHEN OTHERS THEN
1943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1944: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1945: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1946:
1947: -- Logging Infra: Statement level
1948: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1941: NULL;
1942: WHEN OTHERS THEN
1943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1944: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1945: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1946:
1947: -- Logging Infra: Statement level
1948: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1949: l_log_msg := 'Error Message: '||SQLERRM;

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

2109: WHEN NO_DATA_FOUND THEN
2110: NULL;
2111: WHEN OTHERS THEN
2112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2113: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2114: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2115:
2116: -- Logging Infra: Statement level
2117: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2110: NULL;
2111: WHEN OTHERS THEN
2112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2113: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2114: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2115:
2116: -- Logging Infra: Statement level
2117: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2118: l_log_msg := 'Error Message: '||SQLERRM;

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

2252: WHEN NO_DATA_FOUND THEN
2253: NULL;
2254: WHEN OTHERS THEN
2255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2256: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2257: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2258:
2259: -- Logging Infra: Statement level
2260: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2253: NULL;
2254: WHEN OTHERS THEN
2255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2256: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2257: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2258:
2259: -- Logging Infra: Statement level
2260: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2261: l_log_msg := 'Error Message: '||SQLERRM;

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

2365: WHEN NO_DATA_FOUND THEN
2366: NULL;
2367: WHEN OTHERS THEN
2368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2369: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2370: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2371:
2372: -- Logging Infra: Statement level
2373: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2366: NULL;
2367: WHEN OTHERS THEN
2368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2369: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2370: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2371:
2372: -- Logging Infra: Statement level
2373: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2374: l_log_msg := 'Error Message: '||SQLERRM;

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

2477: WHEN NO_DATA_FOUND THEN
2478: NULL;
2479: WHEN OTHERS THEN
2480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2481: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2482: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2483:
2484: -- Logging Infra: Statement level
2485: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2478: NULL;
2479: WHEN OTHERS THEN
2480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2481: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2482: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2483:
2484: -- Logging Infra: Statement level
2485: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2486: l_log_msg := 'Error Message: '||SQLERRM;

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

2714: WHEN NO_DATA_FOUND THEN
2715: NULL;
2716: WHEN OTHERS THEN
2717: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2718: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2719: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2720:
2721: -- Logging Infra: Statement level
2722: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2715: NULL;
2716: WHEN OTHERS THEN
2717: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2718: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2719: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2720:
2721: -- Logging Infra: Statement level
2722: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2723: l_log_msg := 'Error Message: '||SQLERRM;

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

2832:
2833:
2834: EXCEPTION WHEN OTHERS THEN
2835: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2836: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2837: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2838:
2839: -- Logging Infra: Statement level
2840: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2833:
2834: EXCEPTION WHEN OTHERS THEN
2835: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2836: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2837: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2838:
2839: -- Logging Infra: Statement level
2840: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2841: l_log_msg := 'Error Message: '||SQLERRM;