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_CONTROL_PKG dependencies on FND_MESSAGE

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

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

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

375:
376: if c_parent_regime_assoc%notfound then
377: --p_return_status:=FND_API.G_RET_STS_ERROR;
378: --p_error_buffer:='Regime for the given Fiscal Type is not valid ';
379: fnd_message.set_name('ZX','ZX_REGIME_NOT_VALID');
380: p_fsc_rec.fsc_code:= null;
381: close c_parent_regime_assoc;
382: --return;
383: RAISE FND_API.G_EXC_ERROR;

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

402: if c_inventory_set%notfound then
403: --p_return_status:=FND_API.G_RET_STS_ERROR;
404: p_fsc_rec.fsc_code:= null;
405: --p_error_buffer:='Fiscal Type Code does not exits';
406: fnd_message.set_name('ZX','ZX_FC_TYPE_NOT_EXIST');
407: close c_inventory_set;
408: --return;
409: RAISE FND_API.G_EXC_ERROR;
410: else

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

414: if l_category_set_id = null then
415: --p_return_status:=FND_API.G_RET_STS_ERROR;
416: p_fsc_rec.fsc_code:= null;
417: --p_error_buffer:='Foreign Key broken:Fiscal Type Code does not have Inventory Category Set associated';
418: fnd_message.set_name('ZX','ZX_FC_INV_CAT_NOT_EXIST');
419:
420: -- Logging Infra: YK: 3/5: Error l_category_set_id is null
421: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
422: l_log_msg := 'E: l_category_set_id is null: classification_type_code='|| p_fsc_rec.classification_type;

Line 438: fnd_message.set_name('ZX','ZX_FC_INV_STRUCT_NOT_EXIST');

434: if c_inventory_structure%notfound then
435: --p_return_status:=FND_API.G_RET_STS_ERROR;
436: p_fsc_rec.fsc_code:= null;
437: --p_error_buffer:='Foreign Key broken: Inventory Structure ID not found';
438: fnd_message.set_name('ZX','ZX_FC_INV_STRUCT_NOT_EXIST');
439: close c_inventory_structure;
440:
441: -- Logging Infra: YK: 3/5: c_inventory_structure notfound
442: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

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

467: END IF;
468:
469: if c_category%notfound then
470: --p_error_buffer:= 'Fiscal Classification Code does not have an equivalent Item Category Code';
471: fnd_message.set_name('ZX','ZX_ITEM_CAT_NOT_EXIST');
472: p_fsc_rec.fsc_code:= null;
473: --p_return_status:=FND_API.G_RET_STS_SUCCESS;
474: close c_category;
475: --return;

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

498:
499:
500: if c_item_category_child%notfound then
501:
502: fnd_message.set_name('ZX','ZX_FC_NOT_ALLOC_ENTITY_ID');
503: p_fsc_rec.fsc_code:= null;
504: close c_item_category_child;
505:
506: -- Logging Infra: YK: 3/5: c_item_category notfound

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

590:
591: if c_parent_regime_assoc%notfound then
592: --p_return_status:=FND_API.G_RET_STS_ERROR;
593: --p_error_buffer:='Regime for the given Fiscal Type is not valid ';
594: fnd_message.set_name('ZX','ZX_REGIME_NOT_VALID');
595: p_fsc_rec.fsc_code:= null;
596: close c_parent_regime_assoc;
597: --return;
598: RAISE FND_API.G_EXC_ERROR;

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

615:
616: if c_tca_class_category%notfound then
617: --p_return_status:=FND_API.G_RET_STS_ERROR;
618: --p_error_buffer:='Fiscal Type Code does not exits';
619: fnd_message.set_name('ZX','ZX_FC_TYPE_NOT_EXIST');
620: p_fsc_rec.fsc_code:= null;
621: close c_tca_class_category;
622: --return;
623: RAISE FND_API.G_EXC_ERROR;

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

627:
628: if l_tca_class_category_code = null then
629: --p_return_status:=FND_API.G_RET_STS_ERROR;
630: --p_error_buffer:='Foreign Key broken:Fiscal Type Code does not have Class Category associated';
631: fnd_message.set_name('ZX','ZX_FC_INV_CAT_NOT_EXIST');
632: p_fsc_rec.fsc_code:= null;
633:
634: -- Logging Infra: YK: 3/5: Error l_tca_class_category_code is null
635: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

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

670:
671: if c_party_tax_profile_id%notfound then
672: --p_return_status:=FND_API.G_RET_STS_ERROR;
673: --p_error_buffer:='Party Tax Profile ID not found';
674: fnd_message.set_name('ZX','ZX_PTP_ID_NOT_EXIST');
675: p_fsc_rec.fsc_code:= null;
676: close c_party_tax_profile_id;
677: --return;
678: RAISE FND_API.G_EXC_ERROR;

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

696: if c_class_code%notfound then
697: p_fsc_rec.fsc_code:= null;
698: --p_return_status:=FND_API.G_RET_STS_SUCCESS;
699: --p_error_buffer:='Parameter value does not have a corresponding Fiscal Code';
700: fnd_message.set_name('ZX','ZX_FC_CODE_PARAM_NOT_EXIST');
701: close c_class_code;
702: --return;
703: RAISE FND_API.G_EXC_ERROR;
704: else

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

787: p_fsc_rec.effective_from :=l_effective_from;
788: p_fsc_rec.effective_to :=l_effective_to;
789: --p_return_status:=FND_API.G_RET_STS_SUCCESS;
790: --p_error_buffer:='Fiscal Code is not allocated to the Entity ID';
791: --fnd_message.set_name('ZX','ZX_FC_NOT_ALLOC_ENTITY_ID');
792: close c_party_category;
793:
794: --return;
795: --RAISE FND_API.G_EXC_ERROR;

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

987: p_fsc_rec.effective_from := null;
988: p_fsc_rec.effective_to := null;
989: --p_return_status:=FND_API.G_RET_STS_SUCCESS;
990: --p_error_buffer:='Fiscal Code is not allocated to the Entity ID';
991: --fnd_message.set_name('ZX','ZX_FC_NOT_ALLOC_ENTITY_ID');
992: close c_party_category;
993:
994: --return;
995: --RAISE FND_API.G_EXC_ERROR;

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

1027: if c_classification_type_code%notfound then
1028: p_fsc_rec.fsc_code:= null;
1029: --p_return_status:=FND_API.G_RET_STS_ERROR;
1030: --p_error_buffer:='Fiscal Type Code does not exists';
1031: fnd_message.set_name('ZX','ZX_FC_TYPE_NOT_EXIST');
1032: close c_classification_type_code;
1033: --return;
1034: RAISE FND_API.G_EXC_ERROR;
1035: else

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

1065: if c_parent_regime_assoc%notfound then
1066: p_fsc_rec.fsc_code:= null;
1067: --p_return_status:=FND_API.G_RET_STS_ERROR;
1068: --p_error_buffer:='Regime for the given Fiscal Type is not valid ';
1069: fnd_message.set_name('ZX','ZX_REGIME_NOT_VALID');
1070: close c_parent_regime_assoc;
1071: --return;
1072: RAISE FND_API.G_EXC_ERROR;
1073: end if;

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

1107: if c_parent_trxbizcat_fiscalclass%notfound then
1108: p_fsc_rec.fsc_code:= null;
1109: p_fsc_rec.effective_from := null;
1110: p_fsc_rec.effective_to := null;
1111: fnd_message.set_name('ZX','ZX_FC_NOT_ALLOC_ENTITY_ID');
1112: close c_parent_trxbizcat_fiscalclass;
1113: RAISE FND_API.G_EXC_ERROR;
1114: else
1115: p_fsc_rec.effective_from :=l_effective_from;

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

1126: end if;
1127:
1128: else
1129: --p_error_buffer:='Classification Category not supported by this procedure';
1130: fnd_message.set_name('ZX','ZX_FC_CATEG_NOT_SUPPORTED');
1131:
1132: -- Logging Infra: YK: 3/5:
1133: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1134: l_log_msg := 'E: unspported category: p_fsc_rec.classification_category=' || p_fsc_rec.classification_category;

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

1153:
1154: EXCEPTION
1155: WHEN INVALID_CURSOR THEN
1156: p_return_status := FND_API.G_RET_STS_ERROR;
1157: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1158: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1159:
1160: if c_regime_assoc%isopen then close c_regime_assoc; end if;
1161: if c_parent_regime_assoc%isopen then close c_parent_regime_assoc; end if;

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

1154: EXCEPTION
1155: WHEN INVALID_CURSOR THEN
1156: p_return_status := FND_API.G_RET_STS_ERROR;
1157: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1158: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1159:
1160: if c_regime_assoc%isopen then close c_regime_assoc; end if;
1161: if c_parent_regime_assoc%isopen then close c_parent_regime_assoc; end if;
1162: if c_inventory_set%isopen then close c_inventory_set; end if;

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

1201:
1202:
1203: WHEN OTHERS THEN
1204: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1205: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1206: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1207:
1208: if c_regime_assoc%isopen then close c_regime_assoc; end if;
1209: if c_parent_regime_assoc%isopen then close c_parent_regime_assoc; end if;

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

1202:
1203: WHEN OTHERS THEN
1204: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1205: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1206: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1207:
1208: if c_regime_assoc%isopen then close c_regime_assoc; end if;
1209: if c_parent_regime_assoc%isopen then close c_parent_regime_assoc; end if;
1210: if c_inventory_set%isopen then close c_inventory_set; end if;

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

1302:
1303: if c_delimiter%notfound then
1304: p_return_status:=FND_API.G_RET_STS_ERROR;
1305: --p_error_buffer:='Classification Type does not exist';
1306: fnd_message.set_name('ZX','ZX_FC_TYPE_NOT_EXIST');
1307: close c_delimiter;
1308:
1309: -- Logging Infra: YK: 3/5: c_delimiter notfound
1310: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

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

1419:
1420: else
1421: --p_return_status:=FND_API.G_RET_STS_ERROR;
1422: --p_error_buffer:='Classification Category not supported by this procedure';
1423: fnd_message.set_name('ZX','ZX_FC_CATEG_NOT_SUPPORTED');
1424: p_return_status:=FND_API.G_RET_STS_ERROR;
1425:
1426: -- Logging Infra: YK: 3/5:
1427: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

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

1445: END IF;
1446: EXCEPTION
1447: WHEN INVALID_CURSOR THEN
1448: p_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: if c_classification_code%isopen then close c_classification_code; end if;
1453: if c_delimiter%isopen then close c_delimiter; end if;

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

1446: EXCEPTION
1447: WHEN INVALID_CURSOR THEN
1448: p_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: if c_classification_code%isopen then close c_classification_code; end if;
1453: if c_delimiter%isopen then close c_delimiter; end if;
1454:

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

1475: END IF;
1476:
1477: WHEN OTHERS THEN
1478: p_return_status := FND_API.G_RET_STS_UNEXP_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:
1477: WHEN OTHERS THEN
1478: p_return_status := FND_API.G_RET_STS_UNEXP_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 1904: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');

1900: WHEN NO_DATA_FOUND THEN
1901: NULL;
1902: WHEN OTHERS THEN
1903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1904: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1905: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1906:
1907: -- Logging Infra: Statement level
1908: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1901: NULL;
1902: WHEN OTHERS THEN
1903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1904: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
1905: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
1906:
1907: -- Logging Infra: Statement level
1908: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1909: l_log_msg := 'Error Message: '||SQLERRM;

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

2053: WHEN NO_DATA_FOUND THEN
2054: NULL;
2055: WHEN OTHERS THEN
2056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2057: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2058: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2059:
2060: -- Logging Infra: Statement level
2061: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2054: NULL;
2055: WHEN OTHERS THEN
2056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2057: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2058: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2059:
2060: -- Logging Infra: Statement level
2061: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2062: l_log_msg := 'Error Message: '||SQLERRM;

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

2189: WHEN NO_DATA_FOUND THEN
2190: NULL;
2191: WHEN OTHERS THEN
2192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2193: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2194: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2195:
2196: -- Logging Infra: Statement level
2197: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2190: NULL;
2191: WHEN OTHERS THEN
2192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2193: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2194: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2195:
2196: -- Logging Infra: Statement level
2197: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2198: l_log_msg := 'Error Message: '||SQLERRM;

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

2302: WHEN NO_DATA_FOUND THEN
2303: NULL;
2304: WHEN OTHERS THEN
2305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2306: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2307: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2308:
2309: -- Logging Infra: Statement level
2310: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2303: NULL;
2304: WHEN OTHERS THEN
2305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2306: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2307: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2308:
2309: -- Logging Infra: Statement level
2310: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2311: l_log_msg := 'Error Message: '||SQLERRM;

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

2410: WHEN NO_DATA_FOUND THEN
2411: NULL;
2412: WHEN OTHERS THEN
2413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2414: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2415: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2416:
2417: -- Logging Infra: Statement level
2418: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2411: NULL;
2412: WHEN OTHERS THEN
2413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2414: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2415: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2416:
2417: -- Logging Infra: Statement level
2418: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2419: l_log_msg := 'Error Message: '||SQLERRM;

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

2647: WHEN NO_DATA_FOUND THEN
2648: NULL;
2649: WHEN OTHERS THEN
2650: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2651: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2652: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2653:
2654: -- Logging Infra: Statement level
2655: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2648: NULL;
2649: WHEN OTHERS THEN
2650: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2651: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2652: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2653:
2654: -- Logging Infra: Statement level
2655: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2656: l_log_msg := 'Error Message: '||SQLERRM;

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

2765:
2766:
2767: EXCEPTION WHEN OTHERS THEN
2768: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2769: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2770: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2771:
2772: -- Logging Infra: Statement level
2773: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2766:
2767: EXCEPTION WHEN OTHERS THEN
2768: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2769: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
2770: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
2771:
2772: -- Logging Infra: Statement level
2773: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2774: l_log_msg := 'Error Message: '||SQLERRM;