1158: begin
1159:
1160: l_profile_check := FND_PROFILE.VALUE('PJI_SUM_CLEANALL');
1161:
1162: FND_MESSAGE.SET_NAME('PJI', 'PJI_SUM_CLEANALL_FAILED');
1163:
1164: if (upper(nvl(l_profile_check, 'N')) <> 'Y') then
1165: pji_utils.write2out(FND_MESSAGE.GET);
1166: commit;
1161:
1162: FND_MESSAGE.SET_NAME('PJI', 'PJI_SUM_CLEANALL_FAILED');
1163:
1164: if (upper(nvl(l_profile_check, 'N')) <> 'Y') then
1165: pji_utils.write2out(FND_MESSAGE.GET);
1166: commit;
1167: retcode := 1;
1168: return;
1169: end if;
1168: return;
1169: end if;
1170:
1171: if (upper(nvl(p_check, 'N')) <> 'Y') then
1172: pji_utils.write2out(FND_MESSAGE.GET);
1173: commit;
1174: retcode := 1;
1175: return;
1176: end if;