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_API

Line 164: p_return_status := FND_API.G_RET_STS_ERROR;

160: --------------------------------------------------------------------------------------
161:
162: -- Checking parameters are not null
163: IF (p_party_type_code is null) THEN
164: p_return_status := FND_API.G_RET_STS_ERROR;
165: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
166: RETURN;
167: END IF; -- Null parameters
168:

Line 194: p_return_status := FND_API.G_RET_STS_SUCCESS;

190: END IF;
191: -- Logging Infra: Statement level
192: ----------------------------------------------------------------------------------
193:
194: p_return_status := FND_API.G_RET_STS_SUCCESS;
195: RETURN;
196: ELSE
197: /*Reinitialize p_ptp_id */
198: p_ptp_id := NULL;

Line 222: p_return_status := FND_API.G_RET_STS_SUCCESS;

218: END IF;
219: -- Logging Infra: Statement level
220: ---------------------------------------------------------------------------------
221:
222: p_return_status := FND_API.G_RET_STS_SUCCESS;
223: RETURN;
224: ELSE
225: /*Reinitialize p_ptp_id */
226: p_ptp_id := NULL;

Line 250: p_return_status := FND_API.G_RET_STS_SUCCESS;

246: END IF;
247: -- Logging Infra: Statement level
248: ---------------------------------------------------------------------------------
249:
250: p_return_status := FND_API.G_RET_STS_SUCCESS;
251: RETURN;
252: ELSE
253: /*Reinitialize p_ptp_id */
254: p_ptp_id := NULL;

Line 278: p_return_status := FND_API.G_RET_STS_SUCCESS;

274: END IF;
275: -- Logging Infra: Statement level
276: ---------------------------------------------------------------------------------
277:
278: p_return_status := FND_API.G_RET_STS_SUCCESS;
279: RETURN;
280: ELSE
281: /*Reinitialize p_ptp_id */
282: p_ptp_id := NULL;

Line 295: p_return_status := FND_API.G_RET_STS_SUCCESS;

291: l_log_msg := 'There is not an establishment associated. Returning without error.';
292: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
293: END IF;
294: ---------------------------------------------------------------------------------
295: p_return_status := FND_API.G_RET_STS_SUCCESS;
296: END IF; -- If5
297: -- END P_Party_Type_Code = 'LEGAL_ESTABLISHMENT'
298:
299: -- Checking First Party

Line 310: p_return_status := FND_API.G_RET_STS_SUCCESS;

306: AND ptp.party_id = xle.party_id
307: AND ptp.Party_Type_Code = p_party_type_code;
308:
309: -- Set Status Parameter to Success
310: p_return_status := FND_API.G_RET_STS_SUCCESS;
311:
312: ---------------------------------------------------------------------------------
313: -- Logging Infra: Statement level
314: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 347: p_return_status := FND_API.G_RET_STS_SUCCESS;

343: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name, l_log_msg);
344: END IF;
345: ---------------------------------------------------------------------------------
346: p_ptp_id := NULL;
347: p_return_status := FND_API.G_RET_STS_SUCCESS;
348: ELSE
349: ---------------------------------------------------------------------------------
350: -- Logging Infra: Statement level
351: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 360: p_return_status := FND_API.G_RET_STS_ERROR;

356: END IF;
357: ---------------------------------------------------------------------------------
358: -- Bug 4512462
359: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
360: p_return_status := FND_API.G_RET_STS_ERROR;
361: END IF;
362: --close c_get_ptp_id;
363: ELSE
364:

Line 375: p_return_status := FND_API.G_RET_STS_SUCCESS;

371: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
372: END IF;
373: -- Logging Infra: Statement level
374: ---------------------------------------------------------------------------------
375: p_return_status := FND_API.G_RET_STS_SUCCESS;
376: --close c_get_ptp_id;
377: END IF;
378: END IF; -- End IF for Party Types
379: ---------------------------------------------------------------------------------

Line 397: p_return_status := FND_API.G_RET_STS_ERROR;

393: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_procedure_name, l_log_msg);
394: END IF;
395: -- Bug 4512462
396: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
397: p_return_status := FND_API.G_RET_STS_ERROR;
398: WHEN INVALID_CURSOR THEN
399: p_return_status := FND_API.G_RET_STS_ERROR;
400: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
401: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);

Line 399: p_return_status := FND_API.G_RET_STS_ERROR;

395: -- Bug 4512462
396: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
397: p_return_status := FND_API.G_RET_STS_ERROR;
398: WHEN INVALID_CURSOR THEN
399: p_return_status := FND_API.G_RET_STS_ERROR;
400: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
401: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
402: WHEN OTHERS THEN
403: p_return_status := FND_API.G_RET_STS_ERROR;

Line 403: p_return_status := FND_API.G_RET_STS_ERROR;

399: p_return_status := FND_API.G_RET_STS_ERROR;
400: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
401: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
402: WHEN OTHERS THEN
403: p_return_status := FND_API.G_RET_STS_ERROR;
404: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
405: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
406:
407: -- Logging Infra: Statement level

Line 477: p_return_status := FND_API.G_RET_STS_ERROR;

473: l_ptp_id_tbl(l_ptp_id_indx).ptp_id := p_ptp_id;
474: END IF;
475:
476: IF P_PTP_ID is null Then
477: p_return_status := FND_API.G_RET_STS_ERROR;
478: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
479: ELSE
480: p_return_status := FND_API.G_RET_STS_SUCCESS;
481: END IF;

Line 480: p_return_status := FND_API.G_RET_STS_SUCCESS;

476: IF P_PTP_ID is null Then
477: p_return_status := FND_API.G_RET_STS_ERROR;
478: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
479: ELSE
480: p_return_status := FND_API.G_RET_STS_SUCCESS;
481: END IF;
482:
483: ---------------------------------------------------------------------------------
484: -- Logging Infra: Statement level

Line 495: p_return_status := FND_API.G_RET_STS_ERROR;

491: -- Logging Infra: Statement level
492: ---------------------------------------------------------------------------------
493: EXCEPTION
494: WHEN INVALID_CURSOR THEN
495: p_return_status := FND_API.G_RET_STS_ERROR;
496: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
497: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
498: WHEN OTHERS THEN
499: p_return_status := FND_API.G_RET_STS_ERROR;

Line 499: p_return_status := FND_API.G_RET_STS_ERROR;

495: p_return_status := FND_API.G_RET_STS_ERROR;
496: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
497: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
498: WHEN OTHERS THEN
499: p_return_status := FND_API.G_RET_STS_ERROR;
500: FND_MESSAGE.Set_Name ('ZX','ZX_GENERIC_MESSAGE');
501: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
502:
503: -- Logging Infra: Statement level

Line 563: p_return_status := FND_API.G_RET_STS_ERROR;

559: -- Always LE_ID parameter can not be NULL
560: --
561: IF p_le_id IS NULL THEN
562: p_ptp_id := NULL;
563: p_return_status := FND_API.G_RET_STS_ERROR;
564: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
565: --
566: -- Case: Get parameter LE_ID (Return PTP ID of LE)
567: --

Line 575: p_return_status := FND_API.G_RET_STS_ERROR;

571: Fetch c_ptp_of_le into p_ptp_id;
572:
573: IF c_ptp_of_le%NOTFOUND THEN
574: p_ptp_id := NULL;
575: p_return_status := FND_API.G_RET_STS_ERROR;
576: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
577: close c_ptp_of_le;
578: ELSE
579: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 579: p_return_status := FND_API.G_RET_STS_SUCCESS;

575: p_return_status := FND_API.G_RET_STS_ERROR;
576: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
577: close c_ptp_of_le;
578: ELSE
579: p_return_status := FND_API.G_RET_STS_SUCCESS;
580: END IF;
581:
582: --
583: -- Case: Both parameter P_LE_ID and P_ORG_ID are not NULL

Line 622: p_return_status := FND_API.G_RET_STS_SUCCESS;

618:
619: IF l_chk_le_flg = 'N' OR l_chk_le_flg IS NULL THEN
620:
621: IF p_ptp_id IS NOT NULL THEN
622: p_return_status := FND_API.G_RET_STS_SUCCESS;
623: --close c_get_ptp;
624: ELSE
625: p_ptp_id := NULL;
626: p_return_status := FND_API.G_RET_STS_ERROR;

Line 626: p_return_status := FND_API.G_RET_STS_ERROR;

622: p_return_status := FND_API.G_RET_STS_SUCCESS;
623: --close c_get_ptp;
624: ELSE
625: p_ptp_id := NULL;
626: p_return_status := FND_API.G_RET_STS_ERROR;
627: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
628: --close c_get_ptp;
629: END IF;
630:

Line 641: p_return_status := FND_API.G_RET_STS_ERROR;

637: Fetch c_ptp_of_le into p_ptp_id;
638:
639: IF c_ptp_of_le%NOTFOUND THEN
640: p_ptp_id := NULL;
641: p_return_status := FND_API.G_RET_STS_ERROR;
642: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
643: close c_ptp_of_le;
644: ELSE
645: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 645: p_return_status := FND_API.G_RET_STS_SUCCESS;

641: p_return_status := FND_API.G_RET_STS_ERROR;
642: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
643: close c_ptp_of_le;
644: ELSE
645: p_return_status := FND_API.G_RET_STS_SUCCESS;
646: close c_ptp_of_le;
647: END IF;
648:
649: ---------------------------------------------------------------------------------

Line 660: p_return_status := FND_API.G_RET_STS_ERROR;

656: -- Logging Infra: Statement level
657: ---------------------------------------------------------------------------------
658:
659: ELSE
660: p_return_status := FND_API.G_RET_STS_ERROR;
661: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
662: END IF;
663:
664: ELSE

Line 670: p_return_status := FND_API.G_RET_STS_ERROR;

666: Fetch c_ptp_of_le into p_ptp_id;
667:
668: IF c_ptp_of_le%NOTFOUND THEN
669: p_ptp_id := NULL;
670: p_return_status := FND_API.G_RET_STS_ERROR;
671: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
672: close c_ptp_of_le;
673: ELSE
674: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 674: p_return_status := FND_API.G_RET_STS_SUCCESS;

670: p_return_status := FND_API.G_RET_STS_ERROR;
671: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
672: close c_ptp_of_le;
673: ELSE
674: p_return_status := FND_API.G_RET_STS_SUCCESS;
675: close c_ptp_of_le;
676: END IF;
677:
678: ---------------------------------------------------------------------------------

Line 690: p_return_status := FND_API.G_RET_STS_ERROR;

686:
687: END IF;
688: ELSE
689: p_ptp_id := NULL;
690: p_return_status := FND_API.G_RET_STS_ERROR;
691: FND_MESSAGE.SET_NAME('ZX', 'ZX_PARTY_NOT_EXISTS');
692: END IF;
693: ---------------------------------------------------------------------------------
694: -- Logging Infra: Procedure level

Line 703: p_return_status := FND_API.G_RET_STS_ERROR;

699: ---------------------------------------------------------------------------------
700:
701: EXCEPTION
702: WHEN INVALID_CURSOR THEN
703: p_return_status := FND_API.G_RET_STS_ERROR;
704: FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');
705: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);
706: WHEN OTHERS THEN
707: p_return_status := FND_API.G_RET_STS_ERROR;

Line 707: p_return_status := FND_API.G_RET_STS_ERROR;

703: p_return_status := FND_API.G_RET_STS_ERROR;
704: FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');
705: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);
706: WHEN OTHERS THEN
707: p_return_status := FND_API.G_RET_STS_ERROR;
708: FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');
709: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);
710:
711: -- Logging Infra: Statement level

Line 774: p_return_status := FND_API.G_RET_STS_ERROR;

770: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
771: END IF;
772: -- Logging Infra: Statement level
773: --------------------------------------------------------------------------------
774: p_return_status := FND_API.G_RET_STS_ERROR;
775: FND_MESSAGE.SET_NAME('ZX', 'ZX_LOCATION_NOT_EXIST');
776: close c_get_location_id;
777: ELSIF p_location_id IS NULL THEN
778: --------------------------------------------------------------------------------

Line 786: p_return_status := FND_API.G_RET_STS_ERROR;

782: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
783: END IF;
784: -- Logging Infra: Statement level
785: --------------------------------------------------------------------------------
786: p_return_status := FND_API.G_RET_STS_ERROR;
787: FND_MESSAGE.SET_NAME('ZX', 'ZX_LOCATION_NOT_EXIST');
788: close c_get_location_id;
789: ELSE
790: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 790: p_return_status := FND_API.G_RET_STS_SUCCESS;

786: p_return_status := FND_API.G_RET_STS_ERROR;
787: FND_MESSAGE.SET_NAME('ZX', 'ZX_LOCATION_NOT_EXIST');
788: close c_get_location_id;
789: ELSE
790: p_return_status := FND_API.G_RET_STS_SUCCESS;
791: close c_get_location_id;
792:
793: --------------------------------------------------------------------------------
794: -- Logging Infra: Statement level

Line 813: p_return_status := FND_API.G_RET_STS_ERROR;

809: --------------------------------------------------------------------------------
810:
811: EXCEPTION
812: WHEN INVALID_CURSOR THEN
813: p_return_status := FND_API.G_RET_STS_ERROR;
814: FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');
815: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);
816: WHEN OTHERS THEN
817: p_return_status := FND_API.G_RET_STS_ERROR;

Line 817: p_return_status := FND_API.G_RET_STS_ERROR;

813: p_return_status := FND_API.G_RET_STS_ERROR;
814: FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');
815: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);
816: WHEN OTHERS THEN
817: p_return_status := FND_API.G_RET_STS_ERROR;
818: FND_MESSAGE.SET_NAME ('ZX','ZX_GENERIC_MESSAGE');
819: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', SQLERRM);
820:
821: -----------------------------------------------------------------------------

Line 886: IF NOT FND_API.Compatible_API_Call(

882: /*--------------------------------------------------+
883: | Standard call to check for call compatibility |
884: +--------------------------------------------------*/
885:
886: IF NOT FND_API.Compatible_API_Call(
887: l_api_version,
888: p_api_version,
889: l_api_name,
890: G_PKG_NAME

Line 892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

888: p_api_version,
889: l_api_name,
890: G_PKG_NAME
891: ) THEN
892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893: END IF;
894:
895: /*-----------------------------------------+
896: | Initialize return status to SUCCESS |

Line 899: x_return_status := FND_API.G_RET_STS_SUCCESS;

895: /*-----------------------------------------+
896: | Initialize return status to SUCCESS |
897: +-----------------------------------------*/
898:
899: x_return_status := FND_API.G_RET_STS_SUCCESS;
900:
901:
902: Open c_get_reg_id;
903: Fetch c_get_reg_id into l_tax_registration_id;

Line 906: x_return_status := FND_API.G_RET_STS_ERROR;

902: Open c_get_reg_id;
903: Fetch c_get_reg_id into l_tax_registration_id;
904:
905: IF c_get_reg_id%NOTFOUND THEN
906: x_return_status := FND_API.G_RET_STS_ERROR;
907: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
908: close c_get_reg_id;
909:
910: -- Logging Infra: Statement level

Line 918: x_return_status := FND_API.G_RET_STS_SUCCESS;

914: END IF;
915: -- Logging Infra: Statement level
916:
917: ELSE
918: x_return_status := FND_API.G_RET_STS_SUCCESS;
919: close c_get_reg_id;
920: END IF;
921:
922: -- Logging Infra: Procedure level

Line 929: WHEN FND_API.G_EXC_ERROR THEN

925: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name||'.begin', l_log_msg);
926: END IF;
927:
928: EXCEPTION
929: WHEN FND_API.G_EXC_ERROR THEN
930: ROLLBACK TO Check_Tax_Registrations_PVT;
931: x_return_status := FND_API.G_RET_STS_ERROR ;
932:
933: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 931: x_return_status := FND_API.G_RET_STS_ERROR ;

927:
928: EXCEPTION
929: WHEN FND_API.G_EXC_ERROR THEN
930: ROLLBACK TO Check_Tax_Registrations_PVT;
931: x_return_status := FND_API.G_RET_STS_ERROR ;
932:
933: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
934: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
935: END IF;

Line 937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

933: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
934: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
935: END IF;
936:
937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
938: ROLLBACK TO Check_Tax_Registrations_PVT;
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
940:
941: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

935: END IF;
936:
937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
938: ROLLBACK TO Check_Tax_Registrations_PVT;
939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
940:
941: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
942: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,'');
943: END IF;

Line 946: x_return_status := FND_API.G_RET_STS_ERROR;

942: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,'');
943: END IF;
944:
945: WHEN INVALID_CURSOR THEN
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
948:
949: WHEN OTHERS THEN
950: x_return_status := FND_API.G_RET_STS_ERROR;

Line 950: x_return_status := FND_API.G_RET_STS_ERROR;

946: x_return_status := FND_API.G_RET_STS_ERROR;
947: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
948:
949: WHEN OTHERS THEN
950: x_return_status := FND_API.G_RET_STS_ERROR;
951: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
952:
953: -- Logging Infra: Statement level
954: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1085: IF NOT FND_API.Compatible_API_Call(

1081: /*--------------------------------------------------+
1082: | Standard call to check for call compatibility |
1083: +--------------------------------------------------*/
1084:
1085: IF NOT FND_API.Compatible_API_Call(
1086: l_api_version,
1087: p_api_version,
1088: l_api_name,
1089: G_PKG_NAME

Line 1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1087: p_api_version,
1088: l_api_name,
1089: G_PKG_NAME
1090: ) THEN
1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092: END IF;
1093:
1094:
1095: /*-----------------------------------------+

Line 1099: x_return_status := FND_API.G_RET_STS_SUCCESS;

1095: /*-----------------------------------------+
1096: | Initialize return status to SUCCESS |
1097: +-----------------------------------------*/
1098:
1099: x_return_status := FND_API.G_RET_STS_SUCCESS;
1100:
1101:
1102: OPEN c_find_reg_num;
1103: LOOP

Line 1162: x_return_status := FND_API.G_RET_STS_ERROR;

1158:
1159: EXIT WHEN c_find_reg_num%NOTFOUND;
1160:
1161: IF c_find_reg_num%ROWCOUNT = 0 Then
1162: x_return_status := FND_API.G_RET_STS_ERROR;
1163: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
1164:
1165: EXIT;
1166: CLOSE c_find_reg_num;

Line 1169: x_return_status := FND_API.G_RET_STS_SUCCESS;

1165: EXIT;
1166: CLOSE c_find_reg_num;
1167:
1168: ELSE
1169: x_return_status := FND_API.G_RET_STS_SUCCESS;
1170:
1171: IF p_le_new_reg_id IS NULL and p_le_old_end_date IS NULL THEN
1172: update ZX_REGISTRATIONS set
1173: effective_to = SYSDATE

Line 1431: WHEN FND_API.G_EXC_ERROR THEN

1427: END IF;
1428:
1429: EXCEPTION
1430:
1431: WHEN FND_API.G_EXC_ERROR THEN
1432: ROLLBACK TO Sync_Tax_Registrations_PVT;
1433: x_return_status := FND_API.G_RET_STS_ERROR ;
1434:
1435: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1433: x_return_status := FND_API.G_RET_STS_ERROR ;

1429: EXCEPTION
1430:
1431: WHEN FND_API.G_EXC_ERROR THEN
1432: ROLLBACK TO Sync_Tax_Registrations_PVT;
1433: x_return_status := FND_API.G_RET_STS_ERROR ;
1434:
1435: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
1436: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
1437: END IF;

Line 1439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1435: IF ( G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
1436: FND_LOG.STRING(G_LEVEL_ERROR,G_MODULE_NAME||l_api_name,'');
1437: END IF;
1438:
1439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1440: ROLLBACK TO Sync_Tax_Registrations_PVT;
1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1442:
1443: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1437: END IF;
1438:
1439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1440: ROLLBACK TO Sync_Tax_Registrations_PVT;
1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1442:
1443: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1444: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,'');
1445: END IF;

Line 1448: x_return_status := FND_API.G_RET_STS_ERROR;

1444: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,'');
1445: END IF;
1446:
1447: WHEN INVALID_CURSOR THEN
1448: x_return_status := FND_API.G_RET_STS_ERROR;
1449: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
1450:
1451: WHEN OTHERS THEN
1452: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1452: x_return_status := FND_API.G_RET_STS_ERROR;

1448: x_return_status := FND_API.G_RET_STS_ERROR;
1449: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
1450:
1451: WHEN OTHERS THEN
1452: x_return_status := FND_API.G_RET_STS_ERROR;
1453: FND_MESSAGE.SET_NAME('ZX','ZX_GENERIC_MESSAGE');
1454:
1455: END SYNC_TAX_REGISTRATIONS;
1456:

Line 1498: x_return_status := FND_API.G_RET_STS_SUCCESS;

1494: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1495:
1496: BEGIN
1497:
1498: x_return_status := FND_API.G_RET_STS_SUCCESS;
1499: l_tbl_index := dbms_utility.get_hash_value(p_party_type_code||'$'||to_char(p_party_id), 1, 8192);
1500:
1501: IF (ZX_GLOBAL_STRUCTURES_PKG.g_party_tax_prof_id_info_tbl.exists(l_tbl_index)
1502: AND ZX_GLOBAL_STRUCTURES_PKG.g_party_tax_prof_id_info_tbl(l_tbl_index).party_type_code = p_party_type_code

Line 1608: x_return_status := FND_API.G_RET_STS_SUCCESS;

1604: l_tbl_index binary_integer;
1605:
1606: BEGIN
1607:
1608: x_return_status := FND_API.G_RET_STS_SUCCESS;
1609:
1610: IF ZX_GLOBAL_STRUCTURES_PKG.G_PARTY_TAX_PROF_INFO_TBL.exists(p_party_tax_profile_id)
1611: THEN
1612: