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

Line 178: --FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');

174: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
175: l_log_msg := 'party type is null for party_id ' || to_char(p_party_id);
176: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name, l_log_msg);
177: END IF;
178: --FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
179: RETURN;
180: END IF; -- Null parameters
181:
182: -- Initialize P_Ptp_ID

Line 372: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');

368: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name, l_log_msg);
369: END IF;
370: ---------------------------------------------------------------------------------
371: -- Bug 4512462
372: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
373: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', p_party_type_code);
374: p_return_status := FND_API.G_RET_STS_ERROR;
375: END IF;
376: --close c_get_ptp_id;

Line 373: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', p_party_type_code);

369: END IF;
370: ---------------------------------------------------------------------------------
371: -- Bug 4512462
372: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
373: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', p_party_type_code);
374: p_return_status := FND_API.G_RET_STS_ERROR;
375: END IF;
376: --close c_get_ptp_id;
377: ELSE

Line 411: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');

407: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name, l_log_msg);
408: END IF;
409:
410: -- Bug 4512462
411: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
412: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', p_party_type_code);
413:
414: -- bug 8568734
415: IF P_Party_Type_Code = 'FIRST_PARTY' THEN

Line 412: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', p_party_type_code);

408: END IF;
409:
410: -- Bug 4512462
411: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
412: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', p_party_type_code);
413:
414: -- bug 8568734
415: IF P_Party_Type_Code = 'FIRST_PARTY' THEN
416: OPEN get_le_name_csr;

Line 420: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);

416: OPEN get_le_name_csr;
417: FETCH get_le_name_csr INTO l_party_name;
418: CLOSE get_le_name_csr;
419: END IF;
420: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);
421: p_return_status := FND_API.G_RET_STS_ERROR;
422: WHEN INVALID_CURSOR THEN
423: --bug 8568734
424: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

421: p_return_status := FND_API.G_RET_STS_ERROR;
422: WHEN INVALID_CURSOR THEN
423: --bug 8568734
424: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
425: --FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
426: --FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
427: -- Logging Infra: Statement level
428: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
429: l_log_msg := 'Error Message: '||SQLERRM;

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

422: WHEN INVALID_CURSOR THEN
423: --bug 8568734
424: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
425: --FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
426: --FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
427: -- Logging Infra: Statement level
428: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
429: l_log_msg := 'Error Message: '||SQLERRM;
430: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

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

431: END IF;
432: WHEN OTHERS THEN
433: -- bug 8568734
434: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: --FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
436: --FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
437:
438: -- Logging Infra: Statement level
439: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

432: WHEN OTHERS THEN
433: -- bug 8568734
434: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: --FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
436: --FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
437:
438: -- Logging Infra: Statement level
439: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
440: l_log_msg := 'Error Message: '||SQLERRM;

Line 516: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');

512: END IF;
513:
514: IF P_PTP_ID is null Then
515: p_return_status := FND_API.G_RET_STS_ERROR;
516: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
517: -- bug 8568734
518: OPEN get_le_name_csr;
519: FETCH get_le_name_csr INTO l_party_name;
520: CLOSE get_le_name_csr;

Line 521: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', 'LEGAL_ESTABLISHMENT');

517: -- bug 8568734
518: OPEN get_le_name_csr;
519: FETCH get_le_name_csr INTO l_party_name;
520: CLOSE get_le_name_csr;
521: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', 'LEGAL_ESTABLISHMENT');
522: FND_MESSAGE.SET_TOKEN('PARTY_NAME', 'l_party_name');
523:
524: ELSE
525: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 522: FND_MESSAGE.SET_TOKEN('PARTY_NAME', 'l_party_name');

518: OPEN get_le_name_csr;
519: FETCH get_le_name_csr INTO l_party_name;
520: CLOSE get_le_name_csr;
521: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', 'LEGAL_ESTABLISHMENT');
522: FND_MESSAGE.SET_TOKEN('PARTY_NAME', 'l_party_name');
523:
524: ELSE
525: p_return_status := FND_API.G_RET_STS_SUCCESS;
526: END IF;

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

537: ---------------------------------------------------------------------------------
538: EXCEPTION
539: WHEN INVALID_CURSOR THEN
540: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
541: --FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
542: --FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
543: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
544: l_log_msg := 'Error Message: '||SQLERRM;
545: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

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

538: EXCEPTION
539: WHEN INVALID_CURSOR THEN
540: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
541: --FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
542: --FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
543: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
544: l_log_msg := 'Error Message: '||SQLERRM;
545: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
546: END IF;

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

546: END IF;
547:
548: WHEN OTHERS THEN
549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: --FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
551: --FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
552:
553: -- Logging Infra: Statement level
554: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

547:
548: WHEN OTHERS THEN
549: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: --FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
551: --FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
552:
553: -- Logging Infra: Statement level
554: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
555: l_log_msg := 'Error Message: '||SQLERRM;

Line 632: -- FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');

628: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
629: l_log_msg := 'Legal Entity Id is NULL';
630: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
631: END IF;
632: -- FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
633:
634: --
635: -- Case: Get parameter LE_ID (Return PTP ID of LE)
636: --

Line 645: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');

641:
642: IF c_ptp_of_le%NOTFOUND THEN
643: p_ptp_id := NULL;
644: p_return_status := FND_API.G_RET_STS_ERROR;
645: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
646:
647: OPEN get_le_name_csr;
648: FETCH get_le_name_csr INTO l_party_name;
649: CLOSE get_le_name_csr;

Line 651: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', 'LEGAL_ENTITY');

647: OPEN get_le_name_csr;
648: FETCH get_le_name_csr INTO l_party_name;
649: CLOSE get_le_name_csr;
650:
651: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', 'LEGAL_ENTITY');
652: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);
653: close c_ptp_of_le;
654: ELSE
655: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 652: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);

648: FETCH get_le_name_csr INTO l_party_name;
649: CLOSE get_le_name_csr;
650:
651: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', 'LEGAL_ENTITY');
652: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);
653: close c_ptp_of_le;
654: ELSE
655: p_return_status := FND_API.G_RET_STS_SUCCESS;
656: END IF;

Line 703: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');

699: --close c_get_ptp;
700: ELSE
701: p_ptp_id := NULL;
702: p_return_status := FND_API.G_RET_STS_ERROR;
703: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
704: -- bug 8568734
705: OPEN get_ou_name_csr;
706: FETCH get_ou_name_csr INTO l_party_name;
707: CLOSE get_ou_name_csr;

Line 708: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');

704: -- bug 8568734
705: OPEN get_ou_name_csr;
706: FETCH get_ou_name_csr INTO l_party_name;
707: CLOSE get_ou_name_csr;
708: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
709: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', 'OU');
710: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);
711: --close c_get_ptp;
712: END IF;

Line 709: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', 'OU');

705: OPEN get_ou_name_csr;
706: FETCH get_ou_name_csr INTO l_party_name;
707: CLOSE get_ou_name_csr;
708: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
709: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', 'OU');
710: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);
711: --close c_get_ptp;
712: END IF;
713:

Line 710: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);

706: FETCH get_ou_name_csr INTO l_party_name;
707: CLOSE get_ou_name_csr;
708: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
709: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', 'OU');
710: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);
711: --close c_get_ptp;
712: END IF;
713:
714: --

Line 725: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');

721:
722: IF c_ptp_of_le%NOTFOUND THEN
723: p_ptp_id := NULL;
724: p_return_status := FND_API.G_RET_STS_ERROR;
725: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
726: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', 'LEGAL_ENTITY');
727:
728: OPEN get_le_name_csr;
729: FETCH get_le_name_csr INTO l_party_name;

Line 726: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', 'LEGAL_ENTITY');

722: IF c_ptp_of_le%NOTFOUND THEN
723: p_ptp_id := NULL;
724: p_return_status := FND_API.G_RET_STS_ERROR;
725: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
726: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', 'LEGAL_ENTITY');
727:
728: OPEN get_le_name_csr;
729: FETCH get_le_name_csr INTO l_party_name;
730: CLOSE get_le_name_csr;

Line 732: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);

728: OPEN get_le_name_csr;
729: FETCH get_le_name_csr INTO l_party_name;
730: CLOSE get_le_name_csr;
731:
732: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);
733: close c_ptp_of_le;
734: ELSE
735: p_return_status := FND_API.G_RET_STS_SUCCESS;
736: close c_ptp_of_le;

Line 751: -- FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');

747: ---------------------------------------------------------------------------------
748:
749: ELSE
750: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: -- FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
752: ---------------------------------------------------------------------------------
753: -- Logging Infra: Statement level
754: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
755: l_log_msg := 'Invalid l_chk_le_flg';

Line 769: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');

765:
766: IF c_ptp_of_le%NOTFOUND THEN
767: p_ptp_id := NULL;
768: p_return_status := FND_API.G_RET_STS_ERROR;
769: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
770: -- bug 8568734
771: OPEN get_le_name_csr;
772: FETCH get_le_name_csr INTO l_party_name;
773: CLOSE get_le_name_csr;

Line 774: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', 'LEGAL_ENTITY');

770: -- bug 8568734
771: OPEN get_le_name_csr;
772: FETCH get_le_name_csr INTO l_party_name;
773: CLOSE get_le_name_csr;
774: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', 'LEGAL_ENTITY');
775: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);
776: close c_ptp_of_le;
777: ELSE
778: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 775: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);

771: OPEN get_le_name_csr;
772: FETCH get_le_name_csr INTO l_party_name;
773: CLOSE get_le_name_csr;
774: FND_MESSAGE.SET_TOKEN('PARTY_TYPE', 'LEGAL_ENTITY');
775: FND_MESSAGE.SET_TOKEN('PARTY_NAME', l_party_name);
776: close c_ptp_of_le;
777: ELSE
778: p_return_status := FND_API.G_RET_STS_SUCCESS;
779: close c_ptp_of_le;

Line 803: --FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');

799: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
800: END IF;
801: -- Logging Infra: Statement level
802: ---------------------------------------------------------------------------------
803: --FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
804:
805: END IF;
806: ---------------------------------------------------------------------------------
807: -- Logging Infra: Procedure level

Line 817: --FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');

813:
814: EXCEPTION
815: WHEN INVALID_CURSOR THEN
816: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
817: --FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');
818: --FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);
819: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
820: l_log_msg := 'Error Message: '||SQLERRM;
821: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

Line 818: --FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);

814: EXCEPTION
815: WHEN INVALID_CURSOR THEN
816: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
817: --FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');
818: --FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);
819: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
820: l_log_msg := 'Error Message: '||SQLERRM;
821: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
822: END IF;

Line 825: --FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');

821: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
822: END IF;
823: WHEN OTHERS THEN
824: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
825: --FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');
826: --FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);
827:
828: -- Logging Infra: Statement level
829: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 826: --FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);

822: END IF;
823: WHEN OTHERS THEN
824: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
825: --FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');
826: --FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);
827:
828: -- Logging Infra: Statement level
829: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
830: l_log_msg := 'Error Message: '||SQLERRM;

Line 894: --FND_MESSAGE.SET_NAME('ZX', 'ZX_LOCATION_NOT_EXIST');

890: END IF;
891: -- Logging Infra: Statement level
892: --------------------------------------------------------------------------------
893: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
894: --FND_MESSAGE.SET_NAME('ZX', 'ZX_LOCATION_NOT_EXIST');
895: close c_get_location_id;
896: ELSIF p_location_id IS NULL THEN
897: --------------------------------------------------------------------------------
898: -- Logging Infra: Statement level

Line 906: FND_MESSAGE.SET_NAME('ZX', 'ZX_LOCATION_NOT_EXIST');

902: END IF;
903: -- Logging Infra: Statement level
904: --------------------------------------------------------------------------------
905: p_return_status := FND_API.G_RET_STS_ERROR;
906: FND_MESSAGE.SET_NAME('ZX', 'ZX_LOCATION_NOT_EXIST');
907: FND_MESSAGE.SET_TOKEN('BU', l_party_name);
908: close c_get_location_id;
909: ELSE
910: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 907: FND_MESSAGE.SET_TOKEN('BU', l_party_name);

903: -- Logging Infra: Statement level
904: --------------------------------------------------------------------------------
905: p_return_status := FND_API.G_RET_STS_ERROR;
906: FND_MESSAGE.SET_NAME('ZX', 'ZX_LOCATION_NOT_EXIST');
907: FND_MESSAGE.SET_TOKEN('BU', l_party_name);
908: close c_get_location_id;
909: ELSE
910: p_return_status := FND_API.G_RET_STS_SUCCESS;
911: close c_get_location_id;

Line 934: --FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');

930:
931: EXCEPTION
932: WHEN INVALID_CURSOR THEN
933: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: --FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');
935: --FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);
936: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
937: l_log_msg := 'Error Message: '||SQLERRM;
938: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

Line 935: --FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);

931: EXCEPTION
932: WHEN INVALID_CURSOR THEN
933: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: --FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');
935: --FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);
936: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
937: l_log_msg := 'Error Message: '||SQLERRM;
938: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
939: END IF;

Line 943: --FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');

939: END IF;
940:
941: WHEN OTHERS THEN
942: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
943: --FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');
944: --FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);
945:
946: -----------------------------------------------------------------------------
947: -- Logging Infra: Statement level

Line 944: --FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);

940:
941: WHEN OTHERS THEN
942: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
943: --FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');
944: --FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);
945:
946: -----------------------------------------------------------------------------
947: -- Logging Infra: Statement level
948: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1032: -- FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');

1028: Fetch c_get_reg_id into l_tax_registration_id;
1029:
1030: IF c_get_reg_id%NOTFOUND THEN
1031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1032: -- FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
1033: close c_get_reg_id;
1034:
1035: -- Logging Infra: Statement level
1036: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1072: --FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');

1068: END IF;
1069:
1070: WHEN INVALID_CURSOR THEN
1071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1072: --FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
1073: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1074: l_log_msg := 'Error Message: '||SQLERRM;
1075: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1076: END IF;

Line 1080: --FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');

1076: END IF;
1077:
1078: WHEN OTHERS THEN
1079: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1080: --FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
1081:
1082: -- Logging Infra: Statement level
1083: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1084: l_log_msg := 'Error Message: '||SQLERRM;

Line 1292: -- FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');

1288: EXIT WHEN c_find_reg_num%NOTFOUND;
1289:
1290: IF c_find_reg_num%ROWCOUNT = 0 Then
1291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1292: -- FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
1293: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1294: l_log_msg := 'c_find_reg_num%ROWCOUNT = 0';
1295: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
1296: END IF;

Line 1581: --FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');

1577: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,'');
1578: END IF;
1579:
1580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1581: --FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
1582: -- Logging Infra: Statement level
1583: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1584: l_log_msg := 'Error Message: '||SQLERRM;
1585: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_api_name, l_log_msg);

Line 1589: --FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');

1585: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_api_name, l_log_msg);
1586: END IF;
1587: WHEN OTHERS THEN
1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1589: --FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
1590: -- Logging Infra: Statement level
1591: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1592: l_log_msg := 'Error Message: '||SQLERRM;
1593: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_api_name, l_log_msg);