2195: THEN
2196:
2197: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2198: THEN
2199: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
2200: FND_MESSAGE.SET_TOKEN('RNAME',l_resource_name);
2201:
2202: FND_MSG_PUB.add;
2203: END IF;
2196:
2197: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2198: THEN
2199: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
2200: FND_MESSAGE.SET_TOKEN('RNAME',l_resource_name);
2201:
2202: FND_MSG_PUB.add;
2203: END IF;
2204:
2442: p_return_status := FND_API.G_RET_STS_ERROR;
2443:
2444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2445: THEN
2446: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
2447: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
2448: FND_MESSAGE.SET_TOKEN('TASK', '');
2449: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
2450: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
2443:
2444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2445: THEN
2446: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
2447: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
2448: FND_MESSAGE.SET_TOKEN('TASK', '');
2449: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
2450: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
2451: FND_MESSAGE.SET_TOKEN('START_DATE', '');
2444: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2445: THEN
2446: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
2447: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
2448: FND_MESSAGE.SET_TOKEN('TASK', '');
2449: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
2450: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
2451: FND_MESSAGE.SET_TOKEN('START_DATE', '');
2452: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
2445: THEN
2446: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
2447: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
2448: FND_MESSAGE.SET_TOKEN('TASK', '');
2449: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
2450: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
2451: FND_MESSAGE.SET_TOKEN('START_DATE', '');
2452: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
2453: FND_MSG_PUB.ADD;
2446: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
2447: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
2448: FND_MESSAGE.SET_TOKEN('TASK', '');
2449: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
2450: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
2451: FND_MESSAGE.SET_TOKEN('START_DATE', '');
2452: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
2453: FND_MSG_PUB.ADD;
2454: END IF;
2447: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
2448: FND_MESSAGE.SET_TOKEN('TASK', '');
2449: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
2450: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
2451: FND_MESSAGE.SET_TOKEN('START_DATE', '');
2452: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
2453: FND_MSG_PUB.ADD;
2454: END IF;
2455:
2448: FND_MESSAGE.SET_TOKEN('TASK', '');
2449: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
2450: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
2451: FND_MESSAGE.SET_TOKEN('START_DATE', '');
2452: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
2453: FND_MSG_PUB.ADD;
2454: END IF;
2455:
2456: FND_MSG_PUB.Count_And_Get
4507: IF (l_err_code > 0)
4508: THEN
4509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4510: THEN
4511: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4512: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.BUDGET_WF_IS_USED');
4513: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4514: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4515: FND_MSG_PUB.add;
4508: THEN
4509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4510: THEN
4511: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4512: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.BUDGET_WF_IS_USED');
4513: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4514: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4515: FND_MSG_PUB.add;
4516: END IF;
4509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4510: THEN
4511: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4512: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.BUDGET_WF_IS_USED');
4513: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4514: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4515: FND_MSG_PUB.add;
4516: END IF;
4517:
4510: THEN
4511: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4512: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.BUDGET_WF_IS_USED');
4513: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4514: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4515: FND_MSG_PUB.add;
4516: END IF;
4517:
4518: -- RAISE FND_API.G_EXC_ERROR;
4573: IF (l_err_code > 0)
4574: THEN
4575: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4576: THEN
4577: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4578: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.START_BUDGET_WF');
4579: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4580: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4581: FND_MSG_PUB.add;
4574: THEN
4575: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4576: THEN
4577: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4578: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.START_BUDGET_WF');
4579: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4580: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4581: FND_MSG_PUB.add;
4582: END IF;
4575: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4576: THEN
4577: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4578: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.START_BUDGET_WF');
4579: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4580: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4581: FND_MSG_PUB.add;
4582: END IF;
4583:
4576: THEN
4577: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4578: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.START_BUDGET_WF');
4579: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4580: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4581: FND_MSG_PUB.add;
4582: END IF;
4583:
4584: RAISE FND_API.G_EXC_ERROR;
4944: p_return_status := FND_API.G_RET_STS_ERROR ;
4945:
4946: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4947: THEN
4948: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
4949: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
4950: FND_MESSAGE.SET_TOKEN('TASK', '');
4951: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
4952: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
4945:
4946: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4947: THEN
4948: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
4949: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
4950: FND_MESSAGE.SET_TOKEN('TASK', '');
4951: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
4952: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
4953: FND_MESSAGE.SET_TOKEN('START_DATE', '');
4946: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4947: THEN
4948: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
4949: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
4950: FND_MESSAGE.SET_TOKEN('TASK', '');
4951: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
4952: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
4953: FND_MESSAGE.SET_TOKEN('START_DATE', '');
4954: FND_MESSAGE.SET_TOKEN('ENTITY', 'BUDGET_VERSIONS');
4947: THEN
4948: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
4949: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
4950: FND_MESSAGE.SET_TOKEN('TASK', '');
4951: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
4952: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
4953: FND_MESSAGE.SET_TOKEN('START_DATE', '');
4954: FND_MESSAGE.SET_TOKEN('ENTITY', 'BUDGET_VERSIONS');
4955: FND_MSG_PUB.Add;
4948: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
4949: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
4950: FND_MESSAGE.SET_TOKEN('TASK', '');
4951: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
4952: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
4953: FND_MESSAGE.SET_TOKEN('START_DATE', '');
4954: FND_MESSAGE.SET_TOKEN('ENTITY', 'BUDGET_VERSIONS');
4955: FND_MSG_PUB.Add;
4956: END IF;
4949: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
4950: FND_MESSAGE.SET_TOKEN('TASK', '');
4951: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
4952: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
4953: FND_MESSAGE.SET_TOKEN('START_DATE', '');
4954: FND_MESSAGE.SET_TOKEN('ENTITY', 'BUDGET_VERSIONS');
4955: FND_MSG_PUB.Add;
4956: END IF;
4957:
4950: FND_MESSAGE.SET_TOKEN('TASK', '');
4951: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
4952: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
4953: FND_MESSAGE.SET_TOKEN('START_DATE', '');
4954: FND_MESSAGE.SET_TOKEN('ENTITY', 'BUDGET_VERSIONS');
4955: FND_MSG_PUB.Add;
4956: END IF;
4957:
4958: FND_MSG_PUB.Count_And_Get
5307: END IF;
5308:
5309: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5310: THEN
5311: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
5312: FND_MESSAGE.SET_TOKEN('Rname',l_resource_name);
5313:
5314: FND_MSG_PUB.add;
5315: END IF;
5308:
5309: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5310: THEN
5311: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
5312: FND_MESSAGE.SET_TOKEN('Rname',l_resource_name);
5313:
5314: FND_MSG_PUB.add;
5315: END IF;
5316:
5911: p_return_status := FND_API.G_RET_STS_ERROR;
5912:
5913: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5914: THEN
5915: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
5916: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
5917: FND_MESSAGE.set_token('TASK', l_amg_task_number);
5918: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
5919: FND_MESSAGE.set_token('SOURCE_NAME', '');
5912:
5913: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5914: THEN
5915: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
5916: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
5917: FND_MESSAGE.set_token('TASK', l_amg_task_number);
5918: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
5919: FND_MESSAGE.set_token('SOURCE_NAME', '');
5920: FND_MESSAGE.set_token('START_DATE', '');
5913: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5914: THEN
5915: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
5916: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
5917: FND_MESSAGE.set_token('TASK', l_amg_task_number);
5918: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
5919: FND_MESSAGE.set_token('SOURCE_NAME', '');
5920: FND_MESSAGE.set_token('START_DATE', '');
5921: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
5914: THEN
5915: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
5916: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
5917: FND_MESSAGE.set_token('TASK', l_amg_task_number);
5918: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
5919: FND_MESSAGE.set_token('SOURCE_NAME', '');
5920: FND_MESSAGE.set_token('START_DATE', '');
5921: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
5922: FND_MSG_PUB.add;
5915: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
5916: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
5917: FND_MESSAGE.set_token('TASK', l_amg_task_number);
5918: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
5919: FND_MESSAGE.set_token('SOURCE_NAME', '');
5920: FND_MESSAGE.set_token('START_DATE', '');
5921: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
5922: FND_MSG_PUB.add;
5923: END IF;
5916: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
5917: FND_MESSAGE.set_token('TASK', l_amg_task_number);
5918: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
5919: FND_MESSAGE.set_token('SOURCE_NAME', '');
5920: FND_MESSAGE.set_token('START_DATE', '');
5921: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
5922: FND_MSG_PUB.add;
5923: END IF;
5924:
5917: FND_MESSAGE.set_token('TASK', l_amg_task_number);
5918: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
5919: FND_MESSAGE.set_token('SOURCE_NAME', '');
5920: FND_MESSAGE.set_token('START_DATE', '');
5921: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
5922: FND_MSG_PUB.add;
5923: END IF;
5924:
5925: FND_MSG_PUB.count_and_get
6909: p_return_status := FND_API.G_RET_STS_ERROR;
6910:
6911: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6912: THEN
6913: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
6914: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
6915: FND_MESSAGE.SET_TOKEN('TASK', '');
6916: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
6917: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
6910:
6911: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6912: THEN
6913: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
6914: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
6915: FND_MESSAGE.SET_TOKEN('TASK', '');
6916: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
6917: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
6918: FND_MESSAGE.SET_TOKEN('START_DATE', '');
6911: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6912: THEN
6913: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
6914: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
6915: FND_MESSAGE.SET_TOKEN('TASK', '');
6916: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
6917: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
6918: FND_MESSAGE.SET_TOKEN('START_DATE', '');
6919: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
6912: THEN
6913: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
6914: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
6915: FND_MESSAGE.SET_TOKEN('TASK', '');
6916: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
6917: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
6918: FND_MESSAGE.SET_TOKEN('START_DATE', '');
6919: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
6920: FND_MSG_PUB.ADD;
6913: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
6914: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
6915: FND_MESSAGE.SET_TOKEN('TASK', '');
6916: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
6917: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
6918: FND_MESSAGE.SET_TOKEN('START_DATE', '');
6919: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
6920: FND_MSG_PUB.ADD;
6921: END IF;
6914: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
6915: FND_MESSAGE.SET_TOKEN('TASK', '');
6916: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
6917: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
6918: FND_MESSAGE.SET_TOKEN('START_DATE', '');
6919: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
6920: FND_MSG_PUB.ADD;
6921: END IF;
6922:
6915: FND_MESSAGE.SET_TOKEN('TASK', '');
6916: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
6917: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
6918: FND_MESSAGE.SET_TOKEN('START_DATE', '');
6919: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
6920: FND_MSG_PUB.ADD;
6921: END IF;
6922:
6923: FND_MSG_PUB.Count_And_Get
7823: p_return_status := FND_API.G_RET_STS_ERROR;
7824:
7825: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7826: THEN
7827: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
7828: FND_MESSAGE.set_token('PROJECT', l_amg_segment1);
7829: FND_MESSAGE.set_token('TASK', '');
7830: FND_MESSAGE.set_token('BUDGET_TYPE', p_budget_type_code);
7831: FND_MESSAGE.set_token('SOURCE_NAME', '');
7824:
7825: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7826: THEN
7827: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
7828: FND_MESSAGE.set_token('PROJECT', l_amg_segment1);
7829: FND_MESSAGE.set_token('TASK', '');
7830: FND_MESSAGE.set_token('BUDGET_TYPE', p_budget_type_code);
7831: FND_MESSAGE.set_token('SOURCE_NAME', '');
7832: FND_MESSAGE.set_token('START_DATE', '');
7825: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7826: THEN
7827: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
7828: FND_MESSAGE.set_token('PROJECT', l_amg_segment1);
7829: FND_MESSAGE.set_token('TASK', '');
7830: FND_MESSAGE.set_token('BUDGET_TYPE', p_budget_type_code);
7831: FND_MESSAGE.set_token('SOURCE_NAME', '');
7832: FND_MESSAGE.set_token('START_DATE', '');
7833: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_CODE');
7826: THEN
7827: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
7828: FND_MESSAGE.set_token('PROJECT', l_amg_segment1);
7829: FND_MESSAGE.set_token('TASK', '');
7830: FND_MESSAGE.set_token('BUDGET_TYPE', p_budget_type_code);
7831: FND_MESSAGE.set_token('SOURCE_NAME', '');
7832: FND_MESSAGE.set_token('START_DATE', '');
7833: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_CODE');
7834: FND_MSG_PUB.add;
7827: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
7828: FND_MESSAGE.set_token('PROJECT', l_amg_segment1);
7829: FND_MESSAGE.set_token('TASK', '');
7830: FND_MESSAGE.set_token('BUDGET_TYPE', p_budget_type_code);
7831: FND_MESSAGE.set_token('SOURCE_NAME', '');
7832: FND_MESSAGE.set_token('START_DATE', '');
7833: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_CODE');
7834: FND_MSG_PUB.add;
7835: END IF;
7828: FND_MESSAGE.set_token('PROJECT', l_amg_segment1);
7829: FND_MESSAGE.set_token('TASK', '');
7830: FND_MESSAGE.set_token('BUDGET_TYPE', p_budget_type_code);
7831: FND_MESSAGE.set_token('SOURCE_NAME', '');
7832: FND_MESSAGE.set_token('START_DATE', '');
7833: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_CODE');
7834: FND_MSG_PUB.add;
7835: END IF;
7836:
7829: FND_MESSAGE.set_token('TASK', '');
7830: FND_MESSAGE.set_token('BUDGET_TYPE', p_budget_type_code);
7831: FND_MESSAGE.set_token('SOURCE_NAME', '');
7832: FND_MESSAGE.set_token('START_DATE', '');
7833: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_CODE');
7834: FND_MSG_PUB.add;
7835: END IF;
7836:
7837: FND_MSG_PUB.count_and_get
8894: p_return_status := FND_API.G_RET_STS_ERROR;
8895:
8896: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8897: THEN
8898: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
8899: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
8900: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
8901: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
8902: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
8895:
8896: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8897: THEN
8898: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
8899: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
8900: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
8901: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
8902: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
8903: FND_MESSAGE.SET_TOKEN('START_DATE',fnd_date.date_to_chardate(p_start_date));
8896: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
8897: THEN
8898: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
8899: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
8900: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
8901: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
8902: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
8903: FND_MESSAGE.SET_TOKEN('START_DATE',fnd_date.date_to_chardate(p_start_date));
8904: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_LINE_CODE');
8897: THEN
8898: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
8899: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
8900: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
8901: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
8902: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
8903: FND_MESSAGE.SET_TOKEN('START_DATE',fnd_date.date_to_chardate(p_start_date));
8904: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_LINE_CODE');
8905: FND_MSG_PUB.ADD;
8898: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
8899: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
8900: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
8901: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
8902: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
8903: FND_MESSAGE.SET_TOKEN('START_DATE',fnd_date.date_to_chardate(p_start_date));
8904: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_LINE_CODE');
8905: FND_MSG_PUB.ADD;
8906: END IF;
8899: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
8900: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
8901: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
8902: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
8903: FND_MESSAGE.SET_TOKEN('START_DATE',fnd_date.date_to_chardate(p_start_date));
8904: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_LINE_CODE');
8905: FND_MSG_PUB.ADD;
8906: END IF;
8907:
8900: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
8901: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
8902: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
8903: FND_MESSAGE.SET_TOKEN('START_DATE',fnd_date.date_to_chardate(p_start_date));
8904: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_LINE_CODE');
8905: FND_MSG_PUB.ADD;
8906: END IF;
8907:
8908: FND_MSG_PUB.Count_And_Get
12450: -- dbms_output.put_line ('after calling pa_budget_lines_v_pkg.check_overlapping_dates ' || l_err_code );
12451:
12452: IF l_err_code > 0 THEN
12453: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12454: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
12455: FND_MESSAGE.SET_TOKEN('Rname',l_resource_name);
12456:
12457: FND_MSG_PUB.add;
12458: END IF;
12451:
12452: IF l_err_code > 0 THEN
12453: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12454: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
12455: FND_MESSAGE.SET_TOKEN('Rname',l_resource_name);
12456:
12457: FND_MSG_PUB.add;
12458: END IF;
12459: RAISE FND_API.G_EXC_ERROR;
12586: p_return_status := FND_API.G_RET_STS_ERROR;
12587:
12588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
12589: THEN
12590: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
12591: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
12592: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
12593: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
12594: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
12587:
12588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
12589: THEN
12590: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
12591: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
12592: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
12593: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
12594: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
12595: -- FND_MESSAGE.SET_TOKEN('START_DATE', to_char(l_budget_start_date));
12588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
12589: THEN
12590: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
12591: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
12592: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
12593: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
12594: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
12595: -- FND_MESSAGE.SET_TOKEN('START_DATE', to_char(l_budget_start_date));
12596: FND_MESSAGE.SET_TOKEN('START_DATE',
12589: THEN
12590: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
12591: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
12592: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
12593: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
12594: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
12595: -- FND_MESSAGE.SET_TOKEN('START_DATE', to_char(l_budget_start_date));
12596: FND_MESSAGE.SET_TOKEN('START_DATE',
12597: fnd_date.date_to_chardate(l_budget_start_date));
12590: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
12591: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
12592: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
12593: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
12594: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
12595: -- FND_MESSAGE.SET_TOKEN('START_DATE', to_char(l_budget_start_date));
12596: FND_MESSAGE.SET_TOKEN('START_DATE',
12597: fnd_date.date_to_chardate(l_budget_start_date));
12598: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
12591: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
12592: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
12593: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
12594: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
12595: -- FND_MESSAGE.SET_TOKEN('START_DATE', to_char(l_budget_start_date));
12596: FND_MESSAGE.SET_TOKEN('START_DATE',
12597: fnd_date.date_to_chardate(l_budget_start_date));
12598: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
12599: FND_MSG_PUB.ADD;
12592: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
12593: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
12594: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
12595: -- FND_MESSAGE.SET_TOKEN('START_DATE', to_char(l_budget_start_date));
12596: FND_MESSAGE.SET_TOKEN('START_DATE',
12597: fnd_date.date_to_chardate(l_budget_start_date));
12598: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
12599: FND_MSG_PUB.ADD;
12600: END IF;
12594: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
12595: -- FND_MESSAGE.SET_TOKEN('START_DATE', to_char(l_budget_start_date));
12596: FND_MESSAGE.SET_TOKEN('START_DATE',
12597: fnd_date.date_to_chardate(l_budget_start_date));
12598: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
12599: FND_MSG_PUB.ADD;
12600: END IF;
12601:
12602: FND_MSG_PUB.Count_And_Get
13989: p_return_status := FND_API.G_RET_STS_ERROR;
13990:
13991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
13992: THEN
13993: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
13994: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
13995: FND_MESSAGE.set_token('TASK', l_amg_task_number);
13996: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
13997: FND_MESSAGE.set_token('SOURCE_NAME', '');
13990:
13991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
13992: THEN
13993: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
13994: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
13995: FND_MESSAGE.set_token('TASK', l_amg_task_number);
13996: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
13997: FND_MESSAGE.set_token('SOURCE_NAME', '');
13998: FND_MESSAGE.set_token('START_DATE', '');
13991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
13992: THEN
13993: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
13994: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
13995: FND_MESSAGE.set_token('TASK', l_amg_task_number);
13996: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
13997: FND_MESSAGE.set_token('SOURCE_NAME', '');
13998: FND_MESSAGE.set_token('START_DATE', '');
13999: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
13992: THEN
13993: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
13994: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
13995: FND_MESSAGE.set_token('TASK', l_amg_task_number);
13996: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
13997: FND_MESSAGE.set_token('SOURCE_NAME', '');
13998: FND_MESSAGE.set_token('START_DATE', '');
13999: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
14000: FND_MSG_PUB.add;
13993: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
13994: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
13995: FND_MESSAGE.set_token('TASK', l_amg_task_number);
13996: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
13997: FND_MESSAGE.set_token('SOURCE_NAME', '');
13998: FND_MESSAGE.set_token('START_DATE', '');
13999: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
14000: FND_MSG_PUB.add;
14001: END IF;
13994: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
13995: FND_MESSAGE.set_token('TASK', l_amg_task_number);
13996: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
13997: FND_MESSAGE.set_token('SOURCE_NAME', '');
13998: FND_MESSAGE.set_token('START_DATE', '');
13999: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
14000: FND_MSG_PUB.add;
14001: END IF;
14002:
13995: FND_MESSAGE.set_token('TASK', l_amg_task_number);
13996: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
13997: FND_MESSAGE.set_token('SOURCE_NAME', '');
13998: FND_MESSAGE.set_token('START_DATE', '');
13999: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
14000: FND_MSG_PUB.add;
14001: END IF;
14002:
14003: FND_MSG_PUB.count_and_get