[Home] [Help]
1041: if c1%notfound then
1042: --
1043: close c1;
1044: --
1045: -- raise error as FK does not relate to PK in fnd_user table
1046: -- table.
1047: --
1048: hr_utility.set_message(8302,'PQH_INVALID_ROLE');
1049: hr_utility.raise_error;
1092: l_dummy varchar2(1);
1093: --
1094: cursor c1 is
1095: select null
1096: from fnd_user a
1097: where a.user_id = p_forwarded_to_user_id;
1098: --
1099: Begin
1100: --
1109: <> nvl(pqh_rht_shd.g_old_rec.forwarded_to_user_id,hr_api.g_number)
1110: or not l_api_updating) and
1111: p_forwarded_to_user_id is not null then
1112: --
1113: -- check if forwarded_to_user_id value exists in fnd_user table
1114: --
1115: open c1;
1116: --
1117: fetch c1 into l_dummy;
1118: if c1%notfound then
1119: --
1120: close c1;
1121: --
1122: -- raise error as FK does not relate to PK in fnd_user table
1123: -- table.
1124: --
1125: hr_utility.set_message(8302,'PQH_INVALID_USER');
1126: hr_utility.raise_error;
1170: l_dummy varchar2(1);
1171: --
1172: cursor c1 is
1173: select null
1174: from fnd_user a
1175: where a.user_id = p_forwarded_by_user_id;
1176: --
1177: Begin
1178: --
1187: <> nvl(pqh_rht_shd.g_old_rec.forwarded_by_user_id,hr_api.g_number)
1188: or not l_api_updating) and
1189: p_forwarded_by_user_id is not null then
1190: --
1191: -- check if forwarded_by_user_id value exists in fnd_user table
1192: --
1193: open c1;
1194: --
1195: fetch c1 into l_dummy;
1196: if c1%notfound then
1197: --
1198: close c1;
1199: --
1200: -- raise error as FK does not relate to PK in fnd_user table
1201: -- table.
1202: --
1203: hr_utility.set_message(8302,'PQH_INVALID_USER');
1204: hr_utility.raise_error;