2221: THEN
2222:
2223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2224: THEN
2225: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
2226: FND_MESSAGE.SET_TOKEN('RNAME',l_resource_name);
2227:
2228: FND_MSG_PUB.add;
2229: END IF;
2222:
2223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2224: THEN
2225: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
2226: FND_MESSAGE.SET_TOKEN('RNAME',l_resource_name);
2227:
2228: FND_MSG_PUB.add;
2229: END IF;
2230:
2468: p_return_status := FND_API.G_RET_STS_ERROR;
2469:
2470: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2471: THEN
2472: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
2473: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
2474: FND_MESSAGE.SET_TOKEN('TASK', '');
2475: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
2476: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
2469:
2470: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2471: THEN
2472: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
2473: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
2474: FND_MESSAGE.SET_TOKEN('TASK', '');
2475: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
2476: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
2477: FND_MESSAGE.SET_TOKEN('START_DATE', '');
2470: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2471: THEN
2472: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
2473: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
2474: FND_MESSAGE.SET_TOKEN('TASK', '');
2475: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
2476: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
2477: FND_MESSAGE.SET_TOKEN('START_DATE', '');
2478: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
2471: THEN
2472: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
2473: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
2474: FND_MESSAGE.SET_TOKEN('TASK', '');
2475: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
2476: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
2477: FND_MESSAGE.SET_TOKEN('START_DATE', '');
2478: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
2479: FND_MSG_PUB.ADD;
2472: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
2473: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
2474: FND_MESSAGE.SET_TOKEN('TASK', '');
2475: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
2476: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
2477: FND_MESSAGE.SET_TOKEN('START_DATE', '');
2478: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
2479: FND_MSG_PUB.ADD;
2480: END IF;
2473: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
2474: FND_MESSAGE.SET_TOKEN('TASK', '');
2475: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
2476: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
2477: FND_MESSAGE.SET_TOKEN('START_DATE', '');
2478: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
2479: FND_MSG_PUB.ADD;
2480: END IF;
2481:
2474: FND_MESSAGE.SET_TOKEN('TASK', '');
2475: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
2476: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
2477: FND_MESSAGE.SET_TOKEN('START_DATE', '');
2478: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
2479: FND_MSG_PUB.ADD;
2480: END IF;
2481:
2482: FND_MSG_PUB.Count_And_Get
4613: IF (l_err_code > 0)
4614: THEN
4615: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4616: THEN
4617: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4618: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.BUDGET_WF_IS_USED');
4619: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4620: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4621: FND_MSG_PUB.add;
4614: THEN
4615: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4616: THEN
4617: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4618: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.BUDGET_WF_IS_USED');
4619: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4620: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4621: FND_MSG_PUB.add;
4622: END IF;
4615: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4616: THEN
4617: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4618: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.BUDGET_WF_IS_USED');
4619: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4620: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4621: FND_MSG_PUB.add;
4622: END IF;
4623:
4616: THEN
4617: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4618: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.BUDGET_WF_IS_USED');
4619: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4620: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4621: FND_MSG_PUB.add;
4622: END IF;
4623:
4624: -- RAISE FND_API.G_EXC_ERROR;
4679: IF (l_err_code > 0)
4680: THEN
4681: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4682: THEN
4683: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4684: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.START_BUDGET_WF');
4685: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4686: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4687: FND_MSG_PUB.add;
4680: THEN
4681: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4682: THEN
4683: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4684: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.START_BUDGET_WF');
4685: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4686: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4687: FND_MSG_PUB.add;
4688: END IF;
4681: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4682: THEN
4683: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4684: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.START_BUDGET_WF');
4685: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4686: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4687: FND_MSG_PUB.add;
4688: END IF;
4689:
4682: THEN
4683: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
4684: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.START_BUDGET_WF');
4685: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
4686: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
4687: FND_MSG_PUB.add;
4688: END IF;
4689:
4690: RAISE FND_API.G_EXC_ERROR;
5050: p_return_status := FND_API.G_RET_STS_ERROR ;
5051:
5052: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5053: THEN
5054: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
5055: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
5056: FND_MESSAGE.SET_TOKEN('TASK', '');
5057: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
5058: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
5051:
5052: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5053: THEN
5054: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
5055: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
5056: FND_MESSAGE.SET_TOKEN('TASK', '');
5057: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
5058: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
5059: FND_MESSAGE.SET_TOKEN('START_DATE', '');
5052: IF FND_MSG_PUB.Check_Msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5053: THEN
5054: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
5055: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
5056: FND_MESSAGE.SET_TOKEN('TASK', '');
5057: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
5058: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
5059: FND_MESSAGE.SET_TOKEN('START_DATE', '');
5060: FND_MESSAGE.SET_TOKEN('ENTITY', 'BUDGET_VERSIONS');
5053: THEN
5054: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
5055: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
5056: FND_MESSAGE.SET_TOKEN('TASK', '');
5057: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
5058: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
5059: FND_MESSAGE.SET_TOKEN('START_DATE', '');
5060: FND_MESSAGE.SET_TOKEN('ENTITY', 'BUDGET_VERSIONS');
5061: FND_MSG_PUB.Add;
5054: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
5055: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
5056: FND_MESSAGE.SET_TOKEN('TASK', '');
5057: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
5058: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
5059: FND_MESSAGE.SET_TOKEN('START_DATE', '');
5060: FND_MESSAGE.SET_TOKEN('ENTITY', 'BUDGET_VERSIONS');
5061: FND_MSG_PUB.Add;
5062: END IF;
5055: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
5056: FND_MESSAGE.SET_TOKEN('TASK', '');
5057: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
5058: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
5059: FND_MESSAGE.SET_TOKEN('START_DATE', '');
5060: FND_MESSAGE.SET_TOKEN('ENTITY', 'BUDGET_VERSIONS');
5061: FND_MSG_PUB.Add;
5062: END IF;
5063:
5056: FND_MESSAGE.SET_TOKEN('TASK', '');
5057: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
5058: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
5059: FND_MESSAGE.SET_TOKEN('START_DATE', '');
5060: FND_MESSAGE.SET_TOKEN('ENTITY', 'BUDGET_VERSIONS');
5061: FND_MSG_PUB.Add;
5062: END IF;
5063:
5064: FND_MSG_PUB.Count_And_Get
5444: END IF;
5445:
5446: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5447: THEN
5448: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
5449: FND_MESSAGE.SET_TOKEN('Rname',l_resource_name);
5450:
5451: FND_MSG_PUB.add;
5452: END IF;
5445:
5446: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
5447: THEN
5448: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
5449: FND_MESSAGE.SET_TOKEN('Rname',l_resource_name);
5450:
5451: FND_MSG_PUB.add;
5452: END IF;
5453:
6063: p_return_status := FND_API.G_RET_STS_ERROR;
6064:
6065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6066: THEN
6067: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
6068: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
6069: FND_MESSAGE.set_token('TASK', l_amg_task_number);
6070: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
6071: FND_MESSAGE.set_token('SOURCE_NAME', '');
6064:
6065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6066: THEN
6067: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
6068: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
6069: FND_MESSAGE.set_token('TASK', l_amg_task_number);
6070: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
6071: FND_MESSAGE.set_token('SOURCE_NAME', '');
6072: FND_MESSAGE.set_token('START_DATE', '');
6065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
6066: THEN
6067: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
6068: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
6069: FND_MESSAGE.set_token('TASK', l_amg_task_number);
6070: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
6071: FND_MESSAGE.set_token('SOURCE_NAME', '');
6072: FND_MESSAGE.set_token('START_DATE', '');
6073: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
6066: THEN
6067: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
6068: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
6069: FND_MESSAGE.set_token('TASK', l_amg_task_number);
6070: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
6071: FND_MESSAGE.set_token('SOURCE_NAME', '');
6072: FND_MESSAGE.set_token('START_DATE', '');
6073: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
6074: FND_MSG_PUB.add;
6067: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
6068: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
6069: FND_MESSAGE.set_token('TASK', l_amg_task_number);
6070: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
6071: FND_MESSAGE.set_token('SOURCE_NAME', '');
6072: FND_MESSAGE.set_token('START_DATE', '');
6073: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
6074: FND_MSG_PUB.add;
6075: END IF;
6068: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
6069: FND_MESSAGE.set_token('TASK', l_amg_task_number);
6070: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
6071: FND_MESSAGE.set_token('SOURCE_NAME', '');
6072: FND_MESSAGE.set_token('START_DATE', '');
6073: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
6074: FND_MSG_PUB.add;
6075: END IF;
6076:
6069: FND_MESSAGE.set_token('TASK', l_amg_task_number);
6070: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
6071: FND_MESSAGE.set_token('SOURCE_NAME', '');
6072: FND_MESSAGE.set_token('START_DATE', '');
6073: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
6074: FND_MSG_PUB.add;
6075: END IF;
6076:
6077: FND_MSG_PUB.count_and_get
7061: p_return_status := FND_API.G_RET_STS_ERROR;
7062:
7063: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7064: THEN
7065: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
7066: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
7067: FND_MESSAGE.SET_TOKEN('TASK', '');
7068: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
7069: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
7062:
7063: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7064: THEN
7065: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
7066: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
7067: FND_MESSAGE.SET_TOKEN('TASK', '');
7068: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
7069: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
7070: FND_MESSAGE.SET_TOKEN('START_DATE', '');
7063: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7064: THEN
7065: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
7066: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
7067: FND_MESSAGE.SET_TOKEN('TASK', '');
7068: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
7069: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
7070: FND_MESSAGE.SET_TOKEN('START_DATE', '');
7071: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
7064: THEN
7065: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
7066: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
7067: FND_MESSAGE.SET_TOKEN('TASK', '');
7068: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
7069: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
7070: FND_MESSAGE.SET_TOKEN('START_DATE', '');
7071: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
7072: FND_MSG_PUB.ADD;
7065: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
7066: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
7067: FND_MESSAGE.SET_TOKEN('TASK', '');
7068: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
7069: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
7070: FND_MESSAGE.SET_TOKEN('START_DATE', '');
7071: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
7072: FND_MSG_PUB.ADD;
7073: END IF;
7066: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
7067: FND_MESSAGE.SET_TOKEN('TASK', '');
7068: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
7069: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
7070: FND_MESSAGE.SET_TOKEN('START_DATE', '');
7071: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
7072: FND_MSG_PUB.ADD;
7073: END IF;
7074:
7067: FND_MESSAGE.SET_TOKEN('TASK', '');
7068: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', p_budget_type_code);
7069: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
7070: FND_MESSAGE.SET_TOKEN('START_DATE', '');
7071: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
7072: FND_MSG_PUB.ADD;
7073: END IF;
7074:
7075: FND_MSG_PUB.Count_And_Get
7977: p_return_status := FND_API.G_RET_STS_ERROR;
7978:
7979: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7980: THEN
7981: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
7982: FND_MESSAGE.set_token('PROJECT', l_amg_segment1);
7983: FND_MESSAGE.set_token('TASK', '');
7984: FND_MESSAGE.set_token('BUDGET_TYPE', p_budget_type_code);
7985: FND_MESSAGE.set_token('SOURCE_NAME', '');
7978:
7979: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7980: THEN
7981: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
7982: FND_MESSAGE.set_token('PROJECT', l_amg_segment1);
7983: FND_MESSAGE.set_token('TASK', '');
7984: FND_MESSAGE.set_token('BUDGET_TYPE', p_budget_type_code);
7985: FND_MESSAGE.set_token('SOURCE_NAME', '');
7986: FND_MESSAGE.set_token('START_DATE', '');
7979: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
7980: THEN
7981: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
7982: FND_MESSAGE.set_token('PROJECT', l_amg_segment1);
7983: FND_MESSAGE.set_token('TASK', '');
7984: FND_MESSAGE.set_token('BUDGET_TYPE', p_budget_type_code);
7985: FND_MESSAGE.set_token('SOURCE_NAME', '');
7986: FND_MESSAGE.set_token('START_DATE', '');
7987: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_CODE');
7980: THEN
7981: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
7982: FND_MESSAGE.set_token('PROJECT', l_amg_segment1);
7983: FND_MESSAGE.set_token('TASK', '');
7984: FND_MESSAGE.set_token('BUDGET_TYPE', p_budget_type_code);
7985: FND_MESSAGE.set_token('SOURCE_NAME', '');
7986: FND_MESSAGE.set_token('START_DATE', '');
7987: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_CODE');
7988: FND_MSG_PUB.add;
7981: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
7982: FND_MESSAGE.set_token('PROJECT', l_amg_segment1);
7983: FND_MESSAGE.set_token('TASK', '');
7984: FND_MESSAGE.set_token('BUDGET_TYPE', p_budget_type_code);
7985: FND_MESSAGE.set_token('SOURCE_NAME', '');
7986: FND_MESSAGE.set_token('START_DATE', '');
7987: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_CODE');
7988: FND_MSG_PUB.add;
7989: END IF;
7982: FND_MESSAGE.set_token('PROJECT', l_amg_segment1);
7983: FND_MESSAGE.set_token('TASK', '');
7984: FND_MESSAGE.set_token('BUDGET_TYPE', p_budget_type_code);
7985: FND_MESSAGE.set_token('SOURCE_NAME', '');
7986: FND_MESSAGE.set_token('START_DATE', '');
7987: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_CODE');
7988: FND_MSG_PUB.add;
7989: END IF;
7990:
7983: FND_MESSAGE.set_token('TASK', '');
7984: FND_MESSAGE.set_token('BUDGET_TYPE', p_budget_type_code);
7985: FND_MESSAGE.set_token('SOURCE_NAME', '');
7986: FND_MESSAGE.set_token('START_DATE', '');
7987: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_CODE');
7988: FND_MSG_PUB.add;
7989: END IF;
7990:
7991: FND_MSG_PUB.count_and_get
9073: p_return_status := FND_API.G_RET_STS_ERROR;
9074:
9075: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
9076: THEN
9077: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
9078: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
9079: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
9080: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
9081: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
9074:
9075: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
9076: THEN
9077: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
9078: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
9079: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
9080: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
9081: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
9082: FND_MESSAGE.SET_TOKEN('START_DATE',fnd_date.date_to_chardate(dateval => p_start_date, calendar_aware => 1)); -- rmunjulu pass additional parameter to make it calendar aware
9075: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
9076: THEN
9077: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
9078: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
9079: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
9080: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
9081: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
9082: FND_MESSAGE.SET_TOKEN('START_DATE',fnd_date.date_to_chardate(dateval => p_start_date, calendar_aware => 1)); -- rmunjulu pass additional parameter to make it calendar aware
9083: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_LINE_CODE');
9076: THEN
9077: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
9078: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
9079: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
9080: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
9081: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
9082: FND_MESSAGE.SET_TOKEN('START_DATE',fnd_date.date_to_chardate(dateval => p_start_date, calendar_aware => 1)); -- rmunjulu pass additional parameter to make it calendar aware
9083: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_LINE_CODE');
9084: FND_MSG_PUB.ADD;
9077: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
9078: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
9079: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
9080: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
9081: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
9082: FND_MESSAGE.SET_TOKEN('START_DATE',fnd_date.date_to_chardate(dateval => p_start_date, calendar_aware => 1)); -- rmunjulu pass additional parameter to make it calendar aware
9083: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_LINE_CODE');
9084: FND_MSG_PUB.ADD;
9085: END IF;
9078: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_project_number);
9079: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
9080: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
9081: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
9082: FND_MESSAGE.SET_TOKEN('START_DATE',fnd_date.date_to_chardate(dateval => p_start_date, calendar_aware => 1)); -- rmunjulu pass additional parameter to make it calendar aware
9083: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_LINE_CODE');
9084: FND_MSG_PUB.ADD;
9085: END IF;
9086:
9079: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
9080: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
9081: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
9082: FND_MESSAGE.SET_TOKEN('START_DATE',fnd_date.date_to_chardate(dateval => p_start_date, calendar_aware => 1)); -- rmunjulu pass additional parameter to make it calendar aware
9083: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_LINE_CODE');
9084: FND_MSG_PUB.ADD;
9085: END IF;
9086:
9087: FND_MSG_PUB.Count_And_Get
12667: -- dbms_output.put_line ('after calling pa_budget_lines_v_pkg.check_overlapping_dates ' || l_err_code );
12668:
12669: IF l_err_code > 0 THEN
12670: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12671: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
12672: FND_MESSAGE.SET_TOKEN('Rname',l_resource_name);
12673:
12674: FND_MSG_PUB.add;
12675: END IF;
12668:
12669: IF l_err_code > 0 THEN
12670: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
12671: FND_MESSAGE.SET_NAME('PA','PA_CHECK_DATES_FAILED');
12672: FND_MESSAGE.SET_TOKEN('Rname',l_resource_name);
12673:
12674: FND_MSG_PUB.add;
12675: END IF;
12676: RAISE FND_API.G_EXC_ERROR;
12803: p_return_status := FND_API.G_RET_STS_ERROR;
12804:
12805: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
12806: THEN
12807: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
12808: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
12809: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
12810: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
12811: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
12804:
12805: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
12806: THEN
12807: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
12808: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
12809: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
12810: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
12811: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
12812: -- FND_MESSAGE.SET_TOKEN('START_DATE', to_char(l_budget_start_date));
12805: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
12806: THEN
12807: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
12808: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
12809: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
12810: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
12811: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
12812: -- FND_MESSAGE.SET_TOKEN('START_DATE', to_char(l_budget_start_date));
12813: FND_MESSAGE.SET_TOKEN('START_DATE',
12806: THEN
12807: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
12808: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
12809: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
12810: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
12811: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
12812: -- FND_MESSAGE.SET_TOKEN('START_DATE', to_char(l_budget_start_date));
12813: FND_MESSAGE.SET_TOKEN('START_DATE',
12814: fnd_date.date_to_chardate(dateval => l_budget_start_date, calendar_aware => 1)); -- rmunjulu pass additional parameter to make it calendar_aware
12807: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
12808: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
12809: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
12810: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
12811: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
12812: -- FND_MESSAGE.SET_TOKEN('START_DATE', to_char(l_budget_start_date));
12813: FND_MESSAGE.SET_TOKEN('START_DATE',
12814: fnd_date.date_to_chardate(dateval => l_budget_start_date, calendar_aware => 1)); -- rmunjulu pass additional parameter to make it calendar_aware
12815: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
12808: FND_MESSAGE.SET_TOKEN('PROJECT', l_amg_segment1);
12809: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
12810: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
12811: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
12812: -- FND_MESSAGE.SET_TOKEN('START_DATE', to_char(l_budget_start_date));
12813: FND_MESSAGE.SET_TOKEN('START_DATE',
12814: fnd_date.date_to_chardate(dateval => l_budget_start_date, calendar_aware => 1)); -- rmunjulu pass additional parameter to make it calendar_aware
12815: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
12816: FND_MSG_PUB.ADD;
12809: FND_MESSAGE.SET_TOKEN('TASK', l_amg_task_number);
12810: FND_MESSAGE.SET_TOKEN('BUDGET_TYPE', l_budget_type_code);
12811: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
12812: -- FND_MESSAGE.SET_TOKEN('START_DATE', to_char(l_budget_start_date));
12813: FND_MESSAGE.SET_TOKEN('START_DATE',
12814: fnd_date.date_to_chardate(dateval => l_budget_start_date, calendar_aware => 1)); -- rmunjulu pass additional parameter to make it calendar_aware
12815: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
12816: FND_MSG_PUB.ADD;
12817: END IF;
12811: FND_MESSAGE.SET_TOKEN('SOURCE_NAME', '');
12812: -- FND_MESSAGE.SET_TOKEN('START_DATE', to_char(l_budget_start_date));
12813: FND_MESSAGE.SET_TOKEN('START_DATE',
12814: fnd_date.date_to_chardate(dateval => l_budget_start_date, calendar_aware => 1)); -- rmunjulu pass additional parameter to make it calendar_aware
12815: FND_MESSAGE.SET_TOKEN('ENTITY', 'G_BUDGET_CODE');
12816: FND_MSG_PUB.ADD;
12817: END IF;
12818:
12819: FND_MSG_PUB.Count_And_Get
14235: p_return_status := FND_API.G_RET_STS_ERROR;
14236:
14237: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14238: THEN
14239: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
14240: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
14241: FND_MESSAGE.set_token('TASK', l_amg_task_number);
14242: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
14243: FND_MESSAGE.set_token('SOURCE_NAME', '');
14236:
14237: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14238: THEN
14239: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
14240: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
14241: FND_MESSAGE.set_token('TASK', l_amg_task_number);
14242: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
14243: FND_MESSAGE.set_token('SOURCE_NAME', '');
14244: FND_MESSAGE.set_token('START_DATE', '');
14237: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
14238: THEN
14239: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
14240: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
14241: FND_MESSAGE.set_token('TASK', l_amg_task_number);
14242: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
14243: FND_MESSAGE.set_token('SOURCE_NAME', '');
14244: FND_MESSAGE.set_token('START_DATE', '');
14245: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
14238: THEN
14239: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
14240: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
14241: FND_MESSAGE.set_token('TASK', l_amg_task_number);
14242: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
14243: FND_MESSAGE.set_token('SOURCE_NAME', '');
14244: FND_MESSAGE.set_token('START_DATE', '');
14245: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
14246: FND_MSG_PUB.add;
14239: FND_MESSAGE.set_name('PA','PA_ROW_ALREADY_LOCKED_B_AMG');
14240: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
14241: FND_MESSAGE.set_token('TASK', l_amg_task_number);
14242: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
14243: FND_MESSAGE.set_token('SOURCE_NAME', '');
14244: FND_MESSAGE.set_token('START_DATE', '');
14245: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
14246: FND_MSG_PUB.add;
14247: END IF;
14240: FND_MESSAGE.set_token('PROJECT', l_amg_project_number);
14241: FND_MESSAGE.set_token('TASK', l_amg_task_number);
14242: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
14243: FND_MESSAGE.set_token('SOURCE_NAME', '');
14244: FND_MESSAGE.set_token('START_DATE', '');
14245: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
14246: FND_MSG_PUB.add;
14247: END IF;
14248:
14241: FND_MESSAGE.set_token('TASK', l_amg_task_number);
14242: FND_MESSAGE.set_token('BUDGET_TYPE', l_budget_type_code);
14243: FND_MESSAGE.set_token('SOURCE_NAME', '');
14244: FND_MESSAGE.set_token('START_DATE', '');
14245: FND_MESSAGE.set_token('ENTITY', 'G_BUDGET_LINE_CODE');
14246: FND_MSG_PUB.add;
14247: END IF;
14248:
14249: FND_MSG_PUB.count_and_get
19598: pa_debug.write_file('Failed because the value of p_distrib_amts is not valid',5);
19599: END IF;
19600: l_err_value := l_distribute_amounts;
19601: l_err_field := 'p_distribute_amounts';
19602: FND_MESSAGE.SET_NAME('PA','PA_PMC_INVALID_LOV_VAL');
19603: FND_MESSAGE.SET_TOKEN('VALUE',l_err_value);
19604: FND_MESSAGE.SET_TOKEN('FIELD',l_err_field);
19605: FND_MSG_PUB.add;
19606: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
19599: END IF;
19600: l_err_value := l_distribute_amounts;
19601: l_err_field := 'p_distribute_amounts';
19602: FND_MESSAGE.SET_NAME('PA','PA_PMC_INVALID_LOV_VAL');
19603: FND_MESSAGE.SET_TOKEN('VALUE',l_err_value);
19604: FND_MESSAGE.SET_TOKEN('FIELD',l_err_field);
19605: FND_MSG_PUB.add;
19606: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
19607: END IF;
19600: l_err_value := l_distribute_amounts;
19601: l_err_field := 'p_distribute_amounts';
19602: FND_MESSAGE.SET_NAME('PA','PA_PMC_INVALID_LOV_VAL');
19603: FND_MESSAGE.SET_TOKEN('VALUE',l_err_value);
19604: FND_MESSAGE.SET_TOKEN('FIELD',l_err_field);
19605: FND_MSG_PUB.add;
19606: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
19607: END IF;
19608: -- Bug 9610380 : End