3723: IF l_project_id IS NULL
3724: THEN
3725: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3726: THEN
3727: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- bug 2257612
3728: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Project Reference');
3729: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_project_reference);
3730: FND_MSG_PUB.add;
3731: END IF;
3724: THEN
3725: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3726: THEN
3727: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- bug 2257612
3728: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Project Reference');
3729: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_project_reference);
3730: FND_MSG_PUB.add;
3731: END IF;
3732:
3725: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3726: THEN
3727: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- bug 2257612
3728: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Project Reference');
3729: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_project_reference);
3730: FND_MSG_PUB.add;
3731: END IF;
3732:
3733: RAISE FND_API.G_EXC_ERROR;
3945: IF l_task_id IS NULL
3946: THEN
3947: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3948: THEN
3949: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
3950: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Reference');
3951: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_task_reference);
3952: FND_MSG_PUB.add;
3953:
3946: THEN
3947: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3948: THEN
3949: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
3950: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Reference');
3951: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_task_reference);
3952: FND_MSG_PUB.add;
3953:
3954: RAISE FND_API.G_EXC_ERROR;
3947: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3948: THEN
3949: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
3950: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Reference');
3951: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_task_reference);
3952: FND_MSG_PUB.add;
3953:
3954: RAISE FND_API.G_EXC_ERROR;
3955:
4244: IF cur_pa_proj_elems%NOTFOUND
4245: THEN
4246: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4247: THEN
4248: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
4249: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Reference');
4250: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_task_reference);
4251: FND_MSG_PUB.add;
4252: CLOSE cur_pa_proj_elems;
4245: THEN
4246: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4247: THEN
4248: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
4249: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Reference');
4250: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_task_reference);
4251: FND_MSG_PUB.add;
4252: CLOSE cur_pa_proj_elems;
4253: RAISE FND_API.G_EXC_ERROR;
4246: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4247: THEN
4248: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
4249: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Reference');
4250: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_task_reference);
4251: FND_MSG_PUB.add;
4252: CLOSE cur_pa_proj_elems;
4253: RAISE FND_API.G_EXC_ERROR;
4254: END IF;
4258: --End Add by rtarway,for BUG 3919800
4259:
4260: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4261: THEN
4262: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
4263: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Reference');
4264: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_task_reference);
4265: FND_MSG_PUB.add;
4266:
4259:
4260: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4261: THEN
4262: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
4263: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Reference');
4264: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_task_reference);
4265: FND_MSG_PUB.add;
4266:
4267: RAISE FND_API.G_EXC_ERROR;
4260: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4261: THEN
4262: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
4263: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Reference');
4264: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_task_reference);
4265: FND_MSG_PUB.add;
4266:
4267: RAISE FND_API.G_EXC_ERROR;
4268:
4336: THEN
4337: p_return_status := FND_API.G_RET_STS_ERROR;
4338: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4339: THEN
4340: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
4341: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Reference');
4342: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_task_reference);
4343: FND_MSG_PUB.add;
4344: RAISE FND_API.G_EXC_ERROR;
4337: p_return_status := FND_API.G_RET_STS_ERROR;
4338: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4339: THEN
4340: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
4341: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Reference');
4342: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_task_reference);
4343: FND_MSG_PUB.add;
4344: RAISE FND_API.G_EXC_ERROR;
4345: END IF;
4338: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4339: THEN
4340: FND_MESSAGE.SET_NAME('PA','PA_API_CONV_ERROR_AMG'); -- Bug 2257612
4341: FND_MESSAGE.SET_TOKEN('ATTR_NAME','Pm Task Reference');
4342: FND_MESSAGE.SET_TOKEN('ATTR_VALUE',p_pm_task_reference);
4343: FND_MSG_PUB.add;
4344: RAISE FND_API.G_EXC_ERROR;
4345: END IF;
4346: END IF;
4424: THEN
4425: RETURN FALSE;
4426: END IF;
4427:
4428: FND_MESSAGE.SET_NAME ('PA',p_message);
4429: RETURN TRUE;
4430:
4431: EXCEPTION
4432: WHEN VALUE_ERROR
7798: lv_count number;
7799: BEGIN
7800: select count(1) into lv_count from PA_WORK_TYPES_B where WORK_TYPE_ID = p_work_type_id;
7801: if lv_count < 1 then
7802: FND_MESSAGE.SET_NAME('PA','PA_INVALID_WORK_TYPE_TASK');
7803: FND_MESSAGE.SET_TOKEN('TASK_NAME',l_amg_task_number);
7804: FND_MSG_PUB.add;
7805: RAISE FND_API.G_EXC_ERROR;
7806: END IF;
7799: BEGIN
7800: select count(1) into lv_count from PA_WORK_TYPES_B where WORK_TYPE_ID = p_work_type_id;
7801: if lv_count < 1 then
7802: FND_MESSAGE.SET_NAME('PA','PA_INVALID_WORK_TYPE_TASK');
7803: FND_MESSAGE.SET_TOKEN('TASK_NAME',l_amg_task_number);
7804: FND_MSG_PUB.add;
7805: RAISE FND_API.G_EXC_ERROR;
7806: END IF;
7807: END;
9512:
9513:
9514: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
9515: THEN
9516: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_T_AMG');
9517: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
9518: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
9519: FND_MESSAGE.SET_TOKEN('ENTITY', G_TASK_CODE);
9520: FND_MSG_PUB.ADD;
9513:
9514: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
9515: THEN
9516: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_T_AMG');
9517: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
9518: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
9519: FND_MESSAGE.SET_TOKEN('ENTITY', G_TASK_CODE);
9520: FND_MSG_PUB.ADD;
9521: END IF;
9514: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
9515: THEN
9516: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_T_AMG');
9517: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
9518: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
9519: FND_MESSAGE.SET_TOKEN('ENTITY', G_TASK_CODE);
9520: FND_MSG_PUB.ADD;
9521: END IF;
9522:
9515: THEN
9516: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_T_AMG');
9517: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
9518: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
9519: FND_MESSAGE.SET_TOKEN('ENTITY', G_TASK_CODE);
9520: FND_MSG_PUB.ADD;
9521: END IF;
9522:
9523: FND_MSG_PUB.Count_And_Get
10162: p_task_id := NULL ;
10163:
10164: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
10165: THEN
10166: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_T_AMG');
10167: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
10168: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
10169: FND_MESSAGE.SET_TOKEN('ENTITY', G_TASK_CODE);
10170: FND_MSG_PUB.ADD;
10163:
10164: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
10165: THEN
10166: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_T_AMG');
10167: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
10168: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
10169: FND_MESSAGE.SET_TOKEN('ENTITY', G_TASK_CODE);
10170: FND_MSG_PUB.ADD;
10171: END IF;
10164: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
10165: THEN
10166: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_T_AMG');
10167: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
10168: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
10169: FND_MESSAGE.SET_TOKEN('ENTITY', G_TASK_CODE);
10170: FND_MSG_PUB.ADD;
10171: END IF;
10172:
10165: THEN
10166: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_T_AMG');
10167: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
10168: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
10169: FND_MESSAGE.SET_TOKEN('ENTITY', G_TASK_CODE);
10170: FND_MSG_PUB.ADD;
10171: END IF;
10172:
10173: FND_MSG_PUB.Count_And_Get
10636: p_return_status := FND_API.G_RET_STS_ERROR;
10637:
10638: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
10639: THEN
10640: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_P_AMG');
10641: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
10642: FND_MESSAGE.SET_TOKEN('ENTITY', G_PROJECT_CODE);
10643: FND_MSG_PUB.ADD;
10644: END IF;
10637:
10638: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
10639: THEN
10640: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_P_AMG');
10641: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
10642: FND_MESSAGE.SET_TOKEN('ENTITY', G_PROJECT_CODE);
10643: FND_MSG_PUB.ADD;
10644: END IF;
10645: FND_MSG_PUB.Count_And_Get
10638: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
10639: THEN
10640: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_P_AMG');
10641: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
10642: FND_MESSAGE.SET_TOKEN('ENTITY', G_PROJECT_CODE);
10643: FND_MSG_PUB.ADD;
10644: END IF;
10645: FND_MSG_PUB.Count_And_Get
10646: ( p_count => p_msg_count ,