DBA Data[Home] [Help]

APPS.AHL_MC_PATH_POSITION_PUB dependencies on FND_MESSAGE

Line 78: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PATH_POS_TBL_NULL');

74:
75: -- check for path position table
76: IF (p_path_position_tbl.COUNT < 1) THEN
77: -- input is NULL
78: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_PATH_POS_TBL_NULL');
79: FND_MSG_PUB.ADD;
80: RAISE FND_API.G_EXC_ERROR;
81: END IF;
82:

Line 231: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_ID_NULL');

227: IF (l_path_position_tbl(i).mc_id IS NULL) THEN
228: -- check for mc_name
229: IF (l_path_position_tbl(i).mc_name IS NULL) THEN
230: -- input is NULL
231: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_ID_NULL');
232: FND_MSG_PUB.ADD;
233: l_validation_failed_flag := 'Y';
234: ELSE
235: OPEN chk_mc_name_csr(l_path_position_tbl(i).mc_name);

Line 240: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_ID_NAME_INV');

236: FETCH chk_mc_name_csr INTO l_mc_id;
237:
238: IF (chk_mc_name_csr%NOTFOUND) THEN
239: -- input is invalid
240: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_ID_NAME_INV');
241: FND_MESSAGE.Set_Token('MC_NAME', l_path_position_tbl(i).mc_name);
242: FND_MSG_PUB.ADD;
243: l_validation_failed_flag := 'Y';
244: END IF;

Line 241: FND_MESSAGE.Set_Token('MC_NAME', l_path_position_tbl(i).mc_name);

237:
238: IF (chk_mc_name_csr%NOTFOUND) THEN
239: -- input is invalid
240: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_ID_NAME_INV');
241: FND_MESSAGE.Set_Token('MC_NAME', l_path_position_tbl(i).mc_name);
242: FND_MSG_PUB.ADD;
243: l_validation_failed_flag := 'Y';
244: END IF;
245:

Line 257: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_ID_INV');

253: FETCH chk_mc_id_csr INTO l_dummy;
254:
255: IF (chk_mc_id_csr%NOTFOUND) THEN
256: -- input is invalid
257: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_ID_INV');
258: FND_MESSAGE.Set_Token('MC_ID', l_path_position_tbl(i).mc_id);
259: FND_MSG_PUB.ADD;
260: l_validation_failed_flag := 'Y';
261: END IF;

Line 258: FND_MESSAGE.Set_Token('MC_ID', l_path_position_tbl(i).mc_id);

254:
255: IF (chk_mc_id_csr%NOTFOUND) THEN
256: -- input is invalid
257: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_ID_INV');
258: FND_MESSAGE.Set_Token('MC_ID', l_path_position_tbl(i).mc_id);
259: FND_MSG_PUB.ADD;
260: l_validation_failed_flag := 'Y';
261: END IF;
262:

Line 277: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_REV_INV');

273: FETCH chk_mc_revision_csr INTO l_ver_no;
274:
275: IF (chk_mc_revision_csr%NOTFOUND) THEN
276: -- input is invalid
277: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_REV_INV');
278: FND_MESSAGE.Set_Token('MC_ID', l_path_position_tbl(i).mc_id);
279: FND_MESSAGE.Set_Token('MC_REV', l_path_position_tbl(i).mc_revision);
280: FND_MSG_PUB.ADD;
281: l_validation_failed_flag := 'Y';

Line 278: FND_MESSAGE.Set_Token('MC_ID', l_path_position_tbl(i).mc_id);

274:
275: IF (chk_mc_revision_csr%NOTFOUND) THEN
276: -- input is invalid
277: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_REV_INV');
278: FND_MESSAGE.Set_Token('MC_ID', l_path_position_tbl(i).mc_id);
279: FND_MESSAGE.Set_Token('MC_REV', l_path_position_tbl(i).mc_revision);
280: FND_MSG_PUB.ADD;
281: l_validation_failed_flag := 'Y';
282: END IF;

Line 279: FND_MESSAGE.Set_Token('MC_REV', l_path_position_tbl(i).mc_revision);

275: IF (chk_mc_revision_csr%NOTFOUND) THEN
276: -- input is invalid
277: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_REV_INV');
278: FND_MESSAGE.Set_Token('MC_ID', l_path_position_tbl(i).mc_id);
279: FND_MESSAGE.Set_Token('MC_REV', l_path_position_tbl(i).mc_revision);
280: FND_MSG_PUB.ADD;
281: l_validation_failed_flag := 'Y';
282: END IF;
283:

Line 295: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_VER_NO_INV');

291: FETCH chk_mc_ver_no_csr INTO l_dummy;
292:
293: IF (chk_mc_ver_no_csr%NOTFOUND) THEN
294: -- input is invalid
295: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_VER_NO_INV');
296: FND_MESSAGE.Set_Token('MC_ID', l_path_position_tbl(i).mc_id);
297: FND_MESSAGE.Set_Token('MC_VER_NO', l_path_position_tbl(i).version_number);
298: FND_MSG_PUB.ADD;
299: l_validation_failed_flag := 'Y';

Line 296: FND_MESSAGE.Set_Token('MC_ID', l_path_position_tbl(i).mc_id);

292:
293: IF (chk_mc_ver_no_csr%NOTFOUND) THEN
294: -- input is invalid
295: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_VER_NO_INV');
296: FND_MESSAGE.Set_Token('MC_ID', l_path_position_tbl(i).mc_id);
297: FND_MESSAGE.Set_Token('MC_VER_NO', l_path_position_tbl(i).version_number);
298: FND_MSG_PUB.ADD;
299: l_validation_failed_flag := 'Y';
300: END IF;

Line 297: FND_MESSAGE.Set_Token('MC_VER_NO', l_path_position_tbl(i).version_number);

293: IF (chk_mc_ver_no_csr%NOTFOUND) THEN
294: -- input is invalid
295: FND_MESSAGE.Set_Name('AHL', 'AHL_MC_RULE_MC_VER_NO_INV');
296: FND_MESSAGE.Set_Token('MC_ID', l_path_position_tbl(i).mc_id);
297: FND_MESSAGE.Set_Token('MC_VER_NO', l_path_position_tbl(i).version_number);
298: FND_MSG_PUB.ADD;
299: l_validation_failed_flag := 'Y';
300: END IF;
301: