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.HZ_GNR_MAP10000 dependencies on FND_API

Line 114: x_status := FND_API.g_ret_sts_success;

110: END IF;
111:
112: --hk_debugl('Validate for Map Start');
113: -- defaulting the sucess status
114: x_status := FND_API.g_ret_sts_success;
115:
116: L_MAP_DTLS_TBL := X_MAP_DTLS_TBL;
117: --hk_debugl('The Map table passed in with loc comp values');
118: --hk_debugt(L_MAP_DTLS_TBL);

Line 123: x_status := FND_API.g_ret_sts_success;

119:
120: IF L_MAP_DTLS_TBL.COUNT = 1 THEN
121: -- This means country is the only required mapped column for validation.
122: -- and country is already populated in the L_MAP_DTLS_TBL in the initialization section of this package.
123: x_status := FND_API.g_ret_sts_success;
124: RETURN;
125: END IF;
126:
127: IF HZ_GNR_UTIL_PKG.getLocCompCount(L_MAP_DTLS_TBL) = 0 THEN

Line 155: x_status := FND_API.G_RET_STS_ERROR;

151: p_module => l_module
152: );
153: END IF;
154:
155: x_status := FND_API.G_RET_STS_ERROR;
156: X_MAP_DTLS_TBL := L_MAP_DTLS_TBL;
157: RETURN;
158: ELSE
159:

Line 170: x_status := FND_API.G_RET_STS_SUCCESS;

166: p_module => l_module
167: );
168: END IF;
169:
170: x_status := FND_API.G_RET_STS_SUCCESS;
171: X_MAP_DTLS_TBL := L_MAP_DTLS_TBL;
172: RETURN;
173: END IF;
174: END IF;

Line 262: x_status := FND_API.G_RET_STS_ERROR;

258: x_cause := 'NO_MATCH';
259: HZ_GNR_UTIL_PKG.fix_no_match(L_MAP_DTLS_TBL,x_status);
260: --hk_debugl('Map_loc table after Fix');
261: --hk_debugt(L_MAP_DTLS_TBL);
262: x_status := FND_API.G_RET_STS_ERROR;
263: ELSE
264: --Fetching once more to see where there are multiple records
265:
266: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 329: x_status := FND_API.G_RET_STS_ERROR;

325: );
326: END IF;
327:
328: x_cause := 'MULTIPLE_MATCH';
329: x_status := FND_API.G_RET_STS_ERROR;
330: RETURN;
331: END IF;
332:
333: ELSE -- Not able to found a unique record with identifier type as NAME

Line 346: x_status := FND_API.G_RET_STS_ERROR;

342: p_module => l_module
343: );
344: END IF;
345:
346: x_status := FND_API.G_RET_STS_ERROR;
347: RETURN;
348: END IF;
349: CLOSE c_getGeo1;
350:

Line 382: x_status := FND_API.G_RET_STS_ERROR;

378: END IF;
379:
380: x_cause := 'MULTIPLE_PARENT';
381: X_MAP_DTLS_TBL := L_MAP_DTLS_TBL;
382: x_status := FND_API.G_RET_STS_ERROR;
383:
384: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
385: hz_utility_v2pub.debug
386: (p_message => ' x_cause : '||x_cause,

Line 440: x_status := FND_API.G_RET_STS_ERROR;

436: p_module => l_module
437: );
438: END IF;
439:
440: x_status := FND_API.G_RET_STS_ERROR;
441: X_MAP_DTLS_TBL := L_MAP_DTLS_TBL;
442: RETURN;
443: END IF;
444:

Line 522: x_status := FND_API.g_ret_sts_success;

518:
519: BEGIN
520:
521: -- defaulting the sucess status
522: x_status := FND_API.g_ret_sts_success;
523: --hk_debugl('Processing Location record with location_id :- '||nvl(to_char(p_location_id),'NULL_LOCATION_ID'));
524: l_loc_components_rec.COUNTRY := P_COUNTRY;
525: l_loc_components_rec.STATE := P_STATE;
526: l_loc_components_rec.PROVINCE := P_PROVINCE;

Line 574: x_status := FND_API.g_ret_sts_success;

570: p_module => l_module
571: );
572: END IF;
573:
574: x_status := FND_API.g_ret_sts_success;
575: X_ADDR_VAL_STATUS := x_status;
576: RETURN;
577: END IF;
578: END IF;

Line 630: IF (x_status = FND_API.g_ret_sts_error) THEN

626: END IF;
627:
628: -- This usage level check is required upfront because usage level validation will ignore
629: -- some of the passed in parameters for the complete mapping and may result in wrong status
630: IF (x_status = FND_API.g_ret_sts_error) THEN
631:
632: -- hk_debugl('Trying to check if usage level validation is success even with map validation as error..');
633: -- hk_debugl('TABLE that is returned by Validate For Map');
634: -- hk_debugt(LL_MAP_DTLS_TBL);

Line 638: IF HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL) = FND_API.G_RET_STS_SUCCESS THEN

634: -- hk_debugt(LL_MAP_DTLS_TBL);
635: -- hk_debugl('Usage Map Table With loc comp values');
636: -- hk_debugt(L_MDU_TBL);
637:
638: IF HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL) = FND_API.G_RET_STS_SUCCESS THEN
639: -- hk_debugl('COMPLETE mapping is error but is sufficient for passed usage. So setting X_STATUS to success');
640: x_status := FND_API.g_ret_sts_success;
641:
642: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 640: x_status := FND_API.g_ret_sts_success;

636: -- hk_debugt(L_MDU_TBL);
637:
638: IF HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL) = FND_API.G_RET_STS_SUCCESS THEN
639: -- hk_debugl('COMPLETE mapping is error but is sufficient for passed usage. So setting X_STATUS to success');
640: x_status := FND_API.g_ret_sts_success;
641:
642: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
643: hz_utility_v2pub.debug
644: (p_message => 'COMPLETE mapping is error but is sufficient for passed usage. So setting X_STATUS to success',

Line 656: IF x_status = FND_API.g_ret_sts_success THEN

652: END IF;
653: END IF;
654: -------End of status check for usage level ----------+
655:
656: IF x_status = FND_API.g_ret_sts_success THEN
657: --hk_debugt(LL_MAP_DTLS_TBL); ----- Code to display the output.
658: -- Set the address validation status to success since x_statusis success
659: X_ADDR_VAL_STATUS := x_status;
660: IF P_LOCATION_ID IS NOT NULL THEN

Line 700: IF HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL) = FND_API.G_RET_STS_ERROR THEN

696: );
697: END IF;
698:
699: -- This means no usage level validation is required
700: IF HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL) = FND_API.G_RET_STS_ERROR THEN
701:
702: HZ_GNR_UTIL_PKG.fill_values(LL_MAP_DTLS_TBL);
703: -- This below call is to derive the address validation status and set the message
704: X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(LL_MAP_DTLS_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,'E',x_status);

Line 740: x_status := FND_API.g_ret_sts_success;

736:
737: HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,
738: L_USAGE_CODE,'S',L_LOC_COMPONENTS_REC,p_lock_flag,LL_MAP_DTLS_TBL,l_status);
739: --hk_debugl('Status after create_gnr : '||l_status);
740: x_status := FND_API.g_ret_sts_success;
741: END IF;
742:
743: X_CALL_MAP := 'N';
744: RETURN;

Line 781: x_status := FND_API.g_ret_sts_success;

777: HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,
778: L_USAGE_CODE,'S',L_LOC_COMPONENTS_REC,p_lock_flag,L_MDU_TBL,l_status);
779: END IF;
780:
781: x_status := FND_API.g_ret_sts_success;
782: RETURN;
783: END IF;
784: --hk_debugl('L_MDU_TBL has count count more than 1');
785:

Line 847: x_status := FND_API.G_RET_STS_ERROR;

843: );
844: END IF;
845:
846: HZ_GNR_UTIL_PKG.fix_no_match(LL_MAP_DTLS_TBL,x_status);
847: x_status := FND_API.G_RET_STS_ERROR;
848: ELSE
849: --Fetching once more to see where there are multiple records
850:
851: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 915: x_status := FND_API.G_RET_STS_ERROR;

911: END IF;
912:
913: LL_MAP_DTLS_TBL := L_MAP_DTLS_TBL;
914: HZ_GNR_UTIL_PKG.fix_no_match(LL_MAP_DTLS_TBL,x_status);
915: x_status := FND_API.G_RET_STS_ERROR;
916: END IF;
917:
918: ELSE -- Not able to found a unique record with identifier type as NAME
919:

Line 931: x_status := FND_API.G_RET_STS_ERROR;

927: );
928: END IF;
929:
930: LL_MAP_DTLS_TBL := L_MAP_DTLS_TBL;
931: x_status := FND_API.G_RET_STS_ERROR;
932: END IF;
933: CLOSE c_getGeo1;
934:
935: ELSE -- a unique record or a record with multiple parent flag = Y is found

Line 949: IF l_multiple_parent_flag = 'Y' AND x_status <> FND_API.G_RET_STS_ERROR THEN

945: END IF;
946:
947: END IF;
948:
949: IF l_multiple_parent_flag = 'Y' AND x_status <> FND_API.G_RET_STS_ERROR THEN
950: IF HZ_GNR_UTIL_PKG.fix_multiparent(l_geography_id,LL_MAP_DTLS_TBL) = TRUE THEN
951: NULL;
952: ELSE -- Multiple parent case not able to find a unique record
953:

Line 964: x_status := FND_API.G_RET_STS_ERROR;

960: p_module => l_module
961: );
962: END IF;
963:
964: x_status := FND_API.G_RET_STS_ERROR;
965: END IF;
966:
967: ELSE -- a unique record is found
968:

Line 1026: IF x_status = FND_API.g_ret_sts_success THEN

1022: HZ_GNR_UTIL_PKG.fill_values(LL_MAP_DTLS_TBL);
1023: --hk_debugl('LL_MAP_DTLS_TBL after fill_values');
1024: --hk_debugt(LL_MAP_DTLS_TBL);
1025:
1026: IF x_status = FND_API.g_ret_sts_success THEN
1027: -- We need to call the getAddrValStatus only once. All other cases we are looking into x_call_map
1028: -- In some case the below code will execute with the x_call_map as N
1029: IF l_get_addr_val = 'Y' THEN
1030: -- This below call is to derive the address validation status and set the message

Line 1152: x_status := FND_API.g_ret_sts_success;

1148:
1149: BEGIN
1150:
1151: -- defaulting the sucess status
1152: x_status := FND_API.g_ret_sts_success;
1153: --hk_debugl('Processing Location record with location_id :- '||nvl(to_char(p_location_id),'NULL_LOCATION_ID'));
1154: l_loc_components_rec.COUNTRY := P_COUNTRY;
1155: l_loc_components_rec.STATE := P_STATE;
1156: l_loc_components_rec.PROVINCE := P_PROVINCE;

Line 1204: x_status := FND_API.g_ret_sts_success;

1200: p_module => l_module
1201: );
1202: END IF;
1203:
1204: x_status := FND_API.g_ret_sts_success;
1205: X_ADDR_VAL_STATUS := x_status;
1206: RETURN;
1207: END IF;
1208: END IF;

Line 1260: IF (x_status = FND_API.g_ret_sts_error) THEN

1256: END IF;
1257:
1258: -- This usage level check is required upfront because usage level validation will ignore
1259: -- some of the passed in parameters for the complete mapping and may result in wrong status
1260: IF (x_status = FND_API.g_ret_sts_error) THEN
1261:
1262: -- hk_debugl('Trying to check if usage level validation is success even with map validation as error..');
1263: -- hk_debugl('TABLE that is returned by Validate For Map');
1264: -- hk_debugt(LL_MAP_DTLS_TBL);

Line 1268: IF HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL) = FND_API.G_RET_STS_SUCCESS THEN

1264: -- hk_debugt(LL_MAP_DTLS_TBL);
1265: -- hk_debugl('Usage Map Table With loc comp values');
1266: -- hk_debugt(L_MDU_TBL);
1267:
1268: IF HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL) = FND_API.G_RET_STS_SUCCESS THEN
1269: -- hk_debugl('COMPLETE mapping is error but is sufficient for passed usage. So setting X_STATUS to success');
1270: x_status := FND_API.g_ret_sts_success;
1271:
1272: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1270: x_status := FND_API.g_ret_sts_success;

1266: -- hk_debugt(L_MDU_TBL);
1267:
1268: IF HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL) = FND_API.G_RET_STS_SUCCESS THEN
1269: -- hk_debugl('COMPLETE mapping is error but is sufficient for passed usage. So setting X_STATUS to success');
1270: x_status := FND_API.g_ret_sts_success;
1271:
1272: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1273: hz_utility_v2pub.debug
1274: (p_message => 'COMPLETE mapping is error but is sufficient for passed usage. So setting X_STATUS to success',

Line 1286: IF x_status = FND_API.g_ret_sts_success THEN

1282: END IF;
1283: END IF;
1284: -------End of status check for usage level ----------+
1285:
1286: IF x_status = FND_API.g_ret_sts_success THEN
1287: --hk_debugt(LL_MAP_DTLS_TBL); ----- Code to display the output.
1288: -- Set the address validation status to success since x_statusis success
1289: X_ADDR_VAL_STATUS := x_status;
1290: IF P_LOCATION_ID IS NOT NULL THEN

Line 1330: IF HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL) = FND_API.G_RET_STS_ERROR THEN

1326: );
1327: END IF;
1328:
1329: -- This means no usage level validation is required
1330: IF HZ_GNR_UTIL_PKG.get_usage_val_status(LL_MAP_DTLS_TBL,L_MDU_TBL) = FND_API.G_RET_STS_ERROR THEN
1331:
1332: HZ_GNR_UTIL_PKG.fill_values(LL_MAP_DTLS_TBL);
1333: -- This below call is to derive the address validation status and set the message
1334: X_ADDR_VAL_STATUS := HZ_GNR_UTIL_PKG.getAddrValStatus(LL_MAP_DTLS_TBL,L_MDU_TBL,P_CALLED_FROM,P_ADDR_VAL_LEVEL,x_addr_warn_msg,'E',x_status);

Line 1370: x_status := FND_API.g_ret_sts_success;

1366:
1367: HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,
1368: L_USAGE_CODE,'S',L_LOC_COMPONENTS_REC,p_lock_flag,LL_MAP_DTLS_TBL,l_status);
1369: --hk_debugl('Status after create_gnr : '||l_status);
1370: x_status := FND_API.g_ret_sts_success;
1371: END IF;
1372:
1373: X_CALL_MAP := 'N';
1374: RETURN;

Line 1411: x_status := FND_API.g_ret_sts_success;

1407: HZ_GNR_UTIL_PKG.create_gnr(P_LOCATION_ID,G_MAP_REC.LOC_TBL_NAME,
1408: L_USAGE_CODE,'S',L_LOC_COMPONENTS_REC,p_lock_flag,L_MDU_TBL,l_status);
1409: END IF;
1410:
1411: x_status := FND_API.g_ret_sts_success;
1412: RETURN;
1413: END IF;
1414: --hk_debugl('L_MDU_TBL has count count more than 1');
1415:

Line 1477: x_status := FND_API.G_RET_STS_ERROR;

1473: );
1474: END IF;
1475:
1476: HZ_GNR_UTIL_PKG.fix_no_match(LL_MAP_DTLS_TBL,x_status);
1477: x_status := FND_API.G_RET_STS_ERROR;
1478: ELSE
1479: --Fetching once more to see where there are multiple records
1480:
1481: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 1545: x_status := FND_API.G_RET_STS_ERROR;

1541: END IF;
1542:
1543: LL_MAP_DTLS_TBL := L_MAP_DTLS_TBL;
1544: HZ_GNR_UTIL_PKG.fix_no_match(LL_MAP_DTLS_TBL,x_status);
1545: x_status := FND_API.G_RET_STS_ERROR;
1546: END IF;
1547:
1548: ELSE -- Not able to found a unique record with identifier type as NAME
1549:

Line 1561: x_status := FND_API.G_RET_STS_ERROR;

1557: );
1558: END IF;
1559:
1560: LL_MAP_DTLS_TBL := L_MAP_DTLS_TBL;
1561: x_status := FND_API.G_RET_STS_ERROR;
1562: END IF;
1563: CLOSE c_getGeo1;
1564:
1565: ELSE -- a unique record or a record with multiple parent flag = Y is found

Line 1579: IF l_multiple_parent_flag = 'Y' AND x_status <> FND_API.G_RET_STS_ERROR THEN

1575: END IF;
1576:
1577: END IF;
1578:
1579: IF l_multiple_parent_flag = 'Y' AND x_status <> FND_API.G_RET_STS_ERROR THEN
1580: IF HZ_GNR_UTIL_PKG.fix_multiparent(l_geography_id,LL_MAP_DTLS_TBL) = TRUE THEN
1581: NULL;
1582: ELSE -- Multiple parent case not able to find a unique record
1583:

Line 1594: x_status := FND_API.G_RET_STS_ERROR;

1590: p_module => l_module
1591: );
1592: END IF;
1593:
1594: x_status := FND_API.G_RET_STS_ERROR;
1595: END IF;
1596:
1597: ELSE -- a unique record is found
1598:

Line 1656: IF x_status = FND_API.g_ret_sts_success THEN

1652: HZ_GNR_UTIL_PKG.fill_values(LL_MAP_DTLS_TBL);
1653: --hk_debugl('LL_MAP_DTLS_TBL after fill_values');
1654: --hk_debugt(LL_MAP_DTLS_TBL);
1655:
1656: IF x_status = FND_API.g_ret_sts_success THEN
1657: -- We need to call the getAddrValStatus only once. All other cases we are looking into x_call_map
1658: -- In some case the below code will execute with the x_call_map as N
1659: IF l_get_addr_val = 'Y' THEN
1660: -- This below call is to derive the address validation status and set the message