DBA Data[Home] [Help]

APPS.PN_TENANCIES_PKG dependencies on FND_MESSAGE

Line 912: fnd_message.set_name ('PN', 'PN_DUPLEASE_PRIMARY_TENANCY');

908: );
909:
910: EXCEPTION
911: WHEN NO_DATA_FOUND THEN
912: fnd_message.set_name ('PN', 'PN_DUPLEASE_PRIMARY_TENANCY');
913: x_return_status := 'E';
914: END;
915:
916: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CHECK_UNIQUE_PRIMARY_LOCATION (-)');

Line 1013: fnd_message.set_name ('PN', 'PN_PARENT_LOC_IN_LEASE');

1009: AND ((x_tenancy_id IS NULL) OR (pnt.tenancy_id <> x_tenancy_id)
1010: )
1011: AND ROWNUM < 2;
1012:
1013: fnd_message.set_name ('PN', 'PN_PARENT_LOC_IN_LEASE');
1014: x_return_status := 'E';
1015:
1016: EXCEPTION
1017: WHEN NO_DATA_FOUND THEN -- IF no data was found THEN we don't worry

Line 1061: fnd_message.set_name ('PN', 'PN_LEASE_TENANCY_OVERLAP');

1057: );
1058:
1059:
1060: IF nvl(pn_mo_cache_utils.get_profile_value('PN_MULTIPLE_LEASE_FOR_LOCATION',l_org_id),'N') <> 'Y' THEN
1061: fnd_message.set_name ('PN', 'PN_LEASE_TENANCY_OVERLAP');
1062: fnd_message.set_token ('LOCATION_CODE', l_locationCode);
1063: fnd_message.set_token ('LEASE_NUMBER', l_leaseNumber);
1064: x_return_status := 'E';
1065: ELSE

Line 1062: fnd_message.set_token ('LOCATION_CODE', l_locationCode);

1058:
1059:
1060: IF nvl(pn_mo_cache_utils.get_profile_value('PN_MULTIPLE_LEASE_FOR_LOCATION',l_org_id),'N') <> 'Y' THEN
1061: fnd_message.set_name ('PN', 'PN_LEASE_TENANCY_OVERLAP');
1062: fnd_message.set_token ('LOCATION_CODE', l_locationCode);
1063: fnd_message.set_token ('LEASE_NUMBER', l_leaseNumber);
1064: x_return_status := 'E';
1065: ELSE
1066: x_return_status := 'W';

Line 1063: fnd_message.set_token ('LEASE_NUMBER', l_leaseNumber);

1059:
1060: IF nvl(pn_mo_cache_utils.get_profile_value('PN_MULTIPLE_LEASE_FOR_LOCATION',l_org_id),'N') <> 'Y' THEN
1061: fnd_message.set_name ('PN', 'PN_LEASE_TENANCY_OVERLAP');
1062: fnd_message.set_token ('LOCATION_CODE', l_locationCode);
1063: fnd_message.set_token ('LEASE_NUMBER', l_leaseNumber);
1064: x_return_status := 'E';
1065: ELSE
1066: x_return_status := 'W';
1067: END IF;

Line 1109: fnd_message.set_name ('PN', 'PN_LEASE_TENANCY_SUBLEASE_DT');

1105: AND ROWNUM < 2
1106: );
1107:
1108:
1109: fnd_message.set_name ('PN', 'PN_LEASE_TENANCY_SUBLEASE_DT');
1110: fnd_message.set_token ('LOCATION_CODE', l_locationCode);
1111: fnd_message.set_token ('LEASE_NUMBER', l_leaseNumber);
1112: x_return_status := 'E';
1113:

Line 1110: fnd_message.set_token ('LOCATION_CODE', l_locationCode);

1106: );
1107:
1108:
1109: fnd_message.set_name ('PN', 'PN_LEASE_TENANCY_SUBLEASE_DT');
1110: fnd_message.set_token ('LOCATION_CODE', l_locationCode);
1111: fnd_message.set_token ('LEASE_NUMBER', l_leaseNumber);
1112: x_return_status := 'E';
1113:
1114: EXCEPTION

Line 1111: fnd_message.set_token ('LEASE_NUMBER', l_leaseNumber);

1107:
1108:
1109: fnd_message.set_name ('PN', 'PN_LEASE_TENANCY_SUBLEASE_DT');
1110: fnd_message.set_token ('LOCATION_CODE', l_locationCode);
1111: fnd_message.set_token ('LEASE_NUMBER', l_leaseNumber);
1112: x_return_status := 'E';
1113:
1114: EXCEPTION
1115: WHEN NO_DATA_FOUND THEN

Line 1154: fnd_message.set_name('PN', 'PN_LEASE_TENANCY_MASTER_NEXIST');

1150: -- IF data was found THEN we don't worry
1151:
1152: EXCEPTION
1153: WHEN NO_DATA_FOUND THEN
1154: fnd_message.set_name('PN', 'PN_LEASE_TENANCY_MASTER_NEXIST');
1155: fnd_message.set_token('LOCATION_CODE', l_locationCode);
1156: x_return_status := 'E';
1157: END;
1158:

Line 1155: fnd_message.set_token('LOCATION_CODE', l_locationCode);

1151:
1152: EXCEPTION
1153: WHEN NO_DATA_FOUND THEN
1154: fnd_message.set_name('PN', 'PN_LEASE_TENANCY_MASTER_NEXIST');
1155: fnd_message.set_token('LOCATION_CODE', l_locationCode);
1156: x_return_status := 'E';
1157: END;
1158:
1159: -- only IF the location EXISTS IN the master and dates are

Line 1197: fnd_message.set_name ('PN', 'PN_LEASE_TENANCY_OVERLAP');

1193: );
1194:
1195:
1196: IF nvl(pn_mo_cache_utils.get_profile_value('PN_MULTIPLE_LEASE_FOR_LOCATION',l_org_id),'N') <> 'Y' THEN
1197: fnd_message.set_name ('PN', 'PN_LEASE_TENANCY_OVERLAP');
1198: fnd_message.set_token ('LOCATION_CODE', l_locationCode);
1199: fnd_message.set_token ('LEASE_NUMBER', l_leaseNumber);
1200: x_return_status := 'E';
1201: ELSE

Line 1198: fnd_message.set_token ('LOCATION_CODE', l_locationCode);

1194:
1195:
1196: IF nvl(pn_mo_cache_utils.get_profile_value('PN_MULTIPLE_LEASE_FOR_LOCATION',l_org_id),'N') <> 'Y' THEN
1197: fnd_message.set_name ('PN', 'PN_LEASE_TENANCY_OVERLAP');
1198: fnd_message.set_token ('LOCATION_CODE', l_locationCode);
1199: fnd_message.set_token ('LEASE_NUMBER', l_leaseNumber);
1200: x_return_status := 'E';
1201: ELSE
1202: x_return_status := 'W';

Line 1199: fnd_message.set_token ('LEASE_NUMBER', l_leaseNumber);

1195:
1196: IF nvl(pn_mo_cache_utils.get_profile_value('PN_MULTIPLE_LEASE_FOR_LOCATION',l_org_id),'N') <> 'Y' THEN
1197: fnd_message.set_name ('PN', 'PN_LEASE_TENANCY_OVERLAP');
1198: fnd_message.set_token ('LOCATION_CODE', l_locationCode);
1199: fnd_message.set_token ('LEASE_NUMBER', l_leaseNumber);
1200: x_return_status := 'E';
1201: ELSE
1202: x_return_status := 'W';
1203: END IF;

Line 1236: fnd_message.set_name('PN', 'PN_LEASE_TENANCY_EST_DT_NULL');

1232: BEGIN
1233: pnp_debug_pkg.debug('PN_TENANCIES_PKG.CHECK_TENANCY_DATES (+)');
1234:
1235: IF (X_ESTIMATED_OCCUPANCY_DATE IS NULL) THEN
1236: fnd_message.set_name('PN', 'PN_LEASE_TENANCY_EST_DT_NULL');
1237: x_return_status := 'E';
1238:
1239: ELSIF (X_EXPIRATION_DATE IS NULL) THEN
1240: fnd_message.set_name ('PN', 'PN_LEASE_TENANCY_EXP_DT_NULL');

Line 1240: fnd_message.set_name ('PN', 'PN_LEASE_TENANCY_EXP_DT_NULL');

1236: fnd_message.set_name('PN', 'PN_LEASE_TENANCY_EST_DT_NULL');
1237: x_return_status := 'E';
1238:
1239: ELSIF (X_EXPIRATION_DATE IS NULL) THEN
1240: fnd_message.set_name ('PN', 'PN_LEASE_TENANCY_EXP_DT_NULL');
1241: x_return_status := 'E';
1242:
1243: ELSIF (TRUNC(NVL(x_occupancy_date, x_expiration_date)) > TRUNC(x_expiration_date)) THEN
1244:

Line 1245: fnd_message.set_name ('PN', 'PN_LEASE_TENANCY_EXP_GT_OCP_DT');

1241: x_return_status := 'E';
1242:
1243: ELSIF (TRUNC(NVL(x_occupancy_date, x_expiration_date)) > TRUNC(x_expiration_date)) THEN
1244:
1245: fnd_message.set_name ('PN', 'PN_LEASE_TENANCY_EXP_GT_OCP_DT');
1246: x_return_status := 'E';
1247: END IF;
1248:
1249: