DBA Data[Home] [Help]

APPS.PSB_POSITIONS_PVT dependencies on FND_MESSAGE

Line 312: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

308: if P_LAST_UPDATE_LOGIN is NULL then
309: P_LAST_UPDATE_LOGIN := -1;
310: end if;
311: else
312: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
313: FND_MSG_PUB.Add ;
314: raise FND_API.G_EXC_ERROR;
315: end if;
316: --

Line 597: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

593: --
594: open c1;
595: fetch c1 into tlinfo;
596: if (c1%notfound) then
597: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
598: fnd_msg_pub.add ;
599: close c1;
600: raise fnd_api.g_exc_error ;
601: end if;

Line 705: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

701:
702: ) then
703: null;
704: else
705: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
706: fnd_msg_pub.add ;
707: raise fnd_api.g_exc_error ;
708: end if;
709:

Line 841: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');

837: if P_LAST_UPDATE_LOGIN is NULL then
838: P_LAST_UPDATE_LOGIN := -1;
839: end if;
840: else
841: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
842: FND_MSG_PUB.Add ;
843: raise FND_API.G_EXC_ERROR ;
844: end if;
845:

Line 1203: fnd_message.set_name('PSB', 'PSB_POSITION_IN_WORKSHEET');

1199: FROM psb_ws_position_lines
1200: WHERE position_id = p_position_id;
1201:
1202: IF (l_count <> 0) THEN
1203: fnd_message.set_name('PSB', 'PSB_POSITION_IN_WORKSHEET');
1204: fnd_msg_pub.add ;
1205: raise fnd_api.g_exc_error ;
1206: END IF;
1207: --

Line 4117: FND_MESSAGE.SET_NAME('PSB', 'PSB_REVISION_NOT_FOUND') ;

4113: -- revision do not need date values so they may be null.. use position
4114: -- revision now has same structure as worksheet
4115:
4116: if (rev_csr%NOTFOUND) THEN
4117: FND_MESSAGE.SET_NAME('PSB', 'PSB_REVISION_NOT_FOUND') ;
4118: FND_MSG_PUB.Add ;
4119: raise FND_API.G_EXC_ERROR ;
4120: end if;
4121: CLOSE rev_csr ;

Line 4133: FND_MESSAGE.SET_NAME('PSB', 'PSB_WORKSHEET_NOT_FOUND') ;

4129: l_local_copy_flag ,
4130: l_global_worksheet_id ,
4131: l_budget_calendar_id ;
4132: if (worksheet_csr%NOTFOUND) THEN
4133: FND_MESSAGE.SET_NAME('PSB', 'PSB_WORKSHEET_NOT_FOUND') ;
4134: FND_MSG_PUB.Add ;
4135: raise FND_API.G_EXC_ERROR ;
4136: end if;
4137: CLOSE worksheet_csr ;

Line 4158: FND_MESSAGE.SET_NAME('PSB', 'PSB_CALENDAR_NOT_FOUND') ;

4154: OPEN calendar_csr ;
4155: FETCH calendar_csr INTO l_cal_start_date,
4156: l_cal_end_date ;
4157: if (calendar_csr%NOTFOUND) THEN
4158: FND_MESSAGE.SET_NAME('PSB', 'PSB_CALENDAR_NOT_FOUND') ;
4159: FND_MSG_PUB.Add ;
4160: raise FND_API.G_EXC_ERROR ;
4161: end if;
4162: --

Line 4183: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_NOT_FOUND') ;

4179: OPEN position_csr ;
4180: FETCH position_csr INTO l_pos_effective_start_date,
4181: l_pos_effective_end_date ;
4182: if (position_csr%NOTFOUND) then
4183: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_NOT_FOUND') ;
4184: FND_MSG_PUB.Add ;
4185: raise FND_API.G_EXC_ERROR ;
4186: end if;
4187: CLOSE position_csr ;

Line 4382: FND_MESSAGE.SET_NAME('PSB', 'PSB_MULTIPLE_SALARY_IN_PERIOD');

4378: if FND_API.to_Boolean(l_salary_overlaps) then
4379: begin
4380:
4381: if p_rowid is not null then
4382: FND_MESSAGE.SET_NAME('PSB', 'PSB_MULTIPLE_SALARY_IN_PERIOD');
4383: FND_MSG_PUB.Add;
4384: end if;
4385:
4386: raise FND_API.G_EXC_ERROR;

Line 4584: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');

4580:
4581: IF NVL(l_error_flag,FND_API.G_RET_STS_SUCCESS) =
4582: FND_API.G_RET_STS_SUCCESS THEN
4583:
4584: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
4585: FND_MSG_PUB.ADD;
4586: FND_MESSAGE.SET_NAME('PSB', 'PSB_NO_WS_VALID_ERR');
4587: FND_MSG_PUB.ADD;
4588: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');

Line 4586: FND_MESSAGE.SET_NAME('PSB', 'PSB_NO_WS_VALID_ERR');

4582: FND_API.G_RET_STS_SUCCESS THEN
4583:
4584: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
4585: FND_MSG_PUB.ADD;
4586: FND_MESSAGE.SET_NAME('PSB', 'PSB_NO_WS_VALID_ERR');
4587: FND_MSG_PUB.ADD;
4588: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
4589: FND_MSG_PUB.ADD;
4590: END IF;

Line 4588: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');

4584: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
4585: FND_MSG_PUB.ADD;
4586: FND_MESSAGE.SET_NAME('PSB', 'PSB_NO_WS_VALID_ERR');
4587: FND_MSG_PUB.ADD;
4588: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
4589: FND_MSG_PUB.ADD;
4590: END IF;
4591:
4592: END IF;

Line 5118: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_CCID_FAILURE');

5114: p_employee_number,p_error_flag);
5115:
5116: END IF;
5117:
5118: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_CCID_FAILURE');
5119: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_concat_segments);
5120: FND_MSG_PUB.ADD;
5121: /* Bug 3692601 End */
5122: END;

Line 5119: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_concat_segments);

5115:
5116: END IF;
5117:
5118: FND_MESSAGE.SET_NAME('PSB', 'PSB_GL_CCID_FAILURE');
5119: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_concat_segments);
5120: FND_MSG_PUB.ADD;
5121: /* Bug 3692601 End */
5122: END;
5123: /* Bug 3692601 Start */

Line 5141: FND_MESSAGE.Set_Name('PSB', 'PSB_SUMMARY_DETAIL_BUDGETING');

5137: LOOP
5138: IF cc_rec.detail_budgeting_allowed_flag = 'N'
5139: OR cc_rec.summary_flag = 'Y' THEN
5140: SET_POS_HEADING(l_position_flag, p_name,p_employee_number, p_error_flag);
5141: FND_MESSAGE.Set_Name('PSB', 'PSB_SUMMARY_DETAIL_BUDGETING');
5142: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_concat_segments);
5143: FND_MSG_PUB.ADD;
5144: END IF;
5145: END LOOP;

Line 5142: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_concat_segments);

5138: IF cc_rec.detail_budgeting_allowed_flag = 'N'
5139: OR cc_rec.summary_flag = 'Y' THEN
5140: SET_POS_HEADING(l_position_flag, p_name,p_employee_number, p_error_flag);
5141: FND_MESSAGE.Set_Name('PSB', 'PSB_SUMMARY_DETAIL_BUDGETING');
5142: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_concat_segments);
5143: FND_MSG_PUB.ADD;
5144: END IF;
5145: END LOOP;
5146: END IF;

Line 5166: FND_MESSAGE.Set_Name('PSB', 'PSB_SUMMARY_DETAIL_BUDGETING');

5162: key_flex_code => 'GL#',
5163: structure_number => p_chart_of_accounts_id,
5164: combination_id => c_dist_rec.code_combination_id);
5165: SET_POS_HEADING(l_position_flag, p_name,p_employee_number, p_error_flag);
5166: FND_MESSAGE.Set_Name('PSB', 'PSB_SUMMARY_DETAIL_BUDGETING');
5167: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_concat_segments);
5168: FND_MSG_PUB.ADD;
5169: END IF;
5170: END LOOP;

Line 5167: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_concat_segments);

5163: structure_number => p_chart_of_accounts_id,
5164: combination_id => c_dist_rec.code_combination_id);
5165: SET_POS_HEADING(l_position_flag, p_name,p_employee_number, p_error_flag);
5166: FND_MESSAGE.Set_Name('PSB', 'PSB_SUMMARY_DETAIL_BUDGETING');
5167: FND_MESSAGE.SET_TOKEN('ACCOUNT', l_concat_segments);
5168: FND_MSG_PUB.ADD;
5169: END IF;
5170: END LOOP;
5171: END IF;

Line 5193: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_NO_JOB_ATTRIBUTE');

5189:
5190: IF NOT FND_API.to_Boolean(l_job_exists) THEN
5191: SET_POS_HEADING(l_position_flag,
5192: p_name,p_employee_number,p_error_flag );
5193: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_NO_JOB_ATTRIBUTE');
5194: FND_MSG_PUB.Add;
5195: END IF;
5196:
5197: --++ paybasis

Line 5210: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_INVALID_PAY_BASIS');

5206:
5207: IF FND_API.to_Boolean(l_pay_basis_invalid) THEN
5208: /* SET_POS_HEADING(l_position_flag ,
5209: p_name,p_employee_number,p_error_flag );
5210: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_INVALID_PAY_BASIS');
5211: FND_MSG_PUB.Add; */
5212: SET_POS_HEADING(l_position_flag,
5213: p_name,p_employee_number,p_error_flag );
5214: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_SALARY_BASIS');

Line 5214: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_SALARY_BASIS');

5210: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_INVALID_PAY_BASIS');
5211: FND_MSG_PUB.Add; */
5212: SET_POS_HEADING(l_position_flag,
5213: p_name,p_employee_number,p_error_flag );
5214: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_SALARY_BASIS');
5215: FND_MESSAGE.SET_TOKEN('POSITION', p_name);
5216: FND_MESSAGE.SET_TOKEN('START_DATE', l_calc_start_date);
5217: FND_MESSAGE.SET_TOKEN('END_DATE', l_calc_end_date);
5218: FND_MSG_PUB.ADD;

Line 5215: FND_MESSAGE.SET_TOKEN('POSITION', p_name);

5211: FND_MSG_PUB.Add; */
5212: SET_POS_HEADING(l_position_flag,
5213: p_name,p_employee_number,p_error_flag );
5214: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_SALARY_BASIS');
5215: FND_MESSAGE.SET_TOKEN('POSITION', p_name);
5216: FND_MESSAGE.SET_TOKEN('START_DATE', l_calc_start_date);
5217: FND_MESSAGE.SET_TOKEN('END_DATE', l_calc_end_date);
5218: FND_MSG_PUB.ADD;
5219: END IF;

Line 5216: FND_MESSAGE.SET_TOKEN('START_DATE', l_calc_start_date);

5212: SET_POS_HEADING(l_position_flag,
5213: p_name,p_employee_number,p_error_flag );
5214: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_SALARY_BASIS');
5215: FND_MESSAGE.SET_TOKEN('POSITION', p_name);
5216: FND_MESSAGE.SET_TOKEN('START_DATE', l_calc_start_date);
5217: FND_MESSAGE.SET_TOKEN('END_DATE', l_calc_end_date);
5218: FND_MSG_PUB.ADD;
5219: END IF;
5220:

Line 5217: FND_MESSAGE.SET_TOKEN('END_DATE', l_calc_end_date);

5213: p_name,p_employee_number,p_error_flag );
5214: FND_MESSAGE.SET_NAME('PSB', 'PSB_INVALID_SALARY_BASIS');
5215: FND_MESSAGE.SET_TOKEN('POSITION', p_name);
5216: FND_MESSAGE.SET_TOKEN('START_DATE', l_calc_start_date);
5217: FND_MESSAGE.SET_TOKEN('END_DATE', l_calc_end_date);
5218: FND_MSG_PUB.ADD;
5219: END IF;
5220:
5221: /* Bug 3247574 End */

Line 5294: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_NO_DEFAULT_WEEK_HOURS');

5290:
5291: if NOT FND_API.to_Boolean(l_weekly_hours_exists) THEN
5292: SET_POS_HEADING(l_position_flag ,
5293: p_name,p_employee_number,p_error_flag );
5294: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_NO_DEFAULT_WEEK_HOURS');
5295: FND_MSG_PUB.Add;
5296: end if;
5297:
5298: end if;

Line 5331: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_MISSING_SALARY');

5327: IF NOT FND_API.to_Boolean(l_salary_exists) THEN
5328:
5329: SET_POS_HEADING(l_position_flag ,
5330: p_name,p_employee_number,p_error_flag );
5331: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_MISSING_SALARY');
5332: FND_MSG_PUB.Add;
5333: END IF;
5334:
5335: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5438: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_INCOMPLETE_DISTR');

5434: LOOP
5435:
5436: SET_POS_HEADING(p_position_flag ,
5437: p_name,p_employee_number,p_error_flag );
5438: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_INCOMPLETE_DISTR');
5439: FND_MSG_PUB.Add;
5440:
5441: END LOOP;
5442:

Line 5496: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_CCID_NOTIN_BG');

5492: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
5493:
5494: SET_POS_HEADING(p_position_flag ,
5495: p_name,p_employee_number,p_error_flag );
5496: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_CCID_NOTIN_BG');
5497: FND_MESSAGE.SET_TOKEN('CCID', l_concat_segments);
5498: FND_MSG_PUB.Add;
5499:
5500: ELSE

Line 5497: FND_MESSAGE.SET_TOKEN('CCID', l_concat_segments);

5493:
5494: SET_POS_HEADING(p_position_flag ,
5495: p_name,p_employee_number,p_error_flag );
5496: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_CCID_NOTIN_BG');
5497: FND_MESSAGE.SET_TOKEN('CCID', l_concat_segments);
5498: FND_MSG_PUB.Add;
5499:
5500: ELSE
5501: -- validate in in account range

Line 5521: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_INVALID_CCID_IN_BG');

5517:
5518: IF l_check_allowed_ret_status <> FND_API.G_TRUE THEN
5519: SET_POS_HEADING(p_position_flag ,
5520: p_name,p_employee_number,p_error_flag );
5521: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_INVALID_CCID_IN_BG');
5522: FND_MESSAGE.SET_TOKEN('CCID', l_concat_segments);
5523: FND_MSG_PUB.Add;
5524:
5525: END IF;

Line 5522: FND_MESSAGE.SET_TOKEN('CCID', l_concat_segments);

5518: IF l_check_allowed_ret_status <> FND_API.G_TRUE THEN
5519: SET_POS_HEADING(p_position_flag ,
5520: p_name,p_employee_number,p_error_flag );
5521: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_INVALID_CCID_IN_BG');
5522: FND_MESSAGE.SET_TOKEN('CCID', l_concat_segments);
5523: FND_MSG_PUB.Add;
5524:
5525: END IF;
5526:

Line 5536: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_MISSING_DISTRIBUTIONS');

5532:
5533: IF NOT FND_API.to_Boolean(l_salary_distr_exists) THEN
5534: SET_POS_HEADING(p_position_flag ,
5535: p_name,p_employee_number,p_error_flag );
5536: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_MISSING_DISTRIBUTIONS');
5537: FND_MSG_PUB.Add;
5538: END IF;
5539:
5540: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5614: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');

5610: BEGIN
5611: IF p_position_flag IS NULL THEN
5612: -- header
5613: p_position_flag := 'Y';
5614: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
5615: FND_MSG_PUB.Add;
5616: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_POSITION');
5617: FND_MESSAGE.SET_TOKEN('NAME', p_position_name);
5618: FND_MESSAGE.SET_TOKEN('EMP', p_employee_number);

Line 5616: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_POSITION');

5612: -- header
5613: p_position_flag := 'Y';
5614: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
5615: FND_MSG_PUB.Add;
5616: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_POSITION');
5617: FND_MESSAGE.SET_TOKEN('NAME', p_position_name);
5618: FND_MESSAGE.SET_TOKEN('EMP', p_employee_number);
5619: FND_MSG_PUB.Add;
5620: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');

Line 5617: FND_MESSAGE.SET_TOKEN('NAME', p_position_name);

5613: p_position_flag := 'Y';
5614: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
5615: FND_MSG_PUB.Add;
5616: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_POSITION');
5617: FND_MESSAGE.SET_TOKEN('NAME', p_position_name);
5618: FND_MESSAGE.SET_TOKEN('EMP', p_employee_number);
5619: FND_MSG_PUB.Add;
5620: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
5621: FND_MSG_PUB.Add;

Line 5618: FND_MESSAGE.SET_TOKEN('EMP', p_employee_number);

5614: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
5615: FND_MSG_PUB.Add;
5616: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_POSITION');
5617: FND_MESSAGE.SET_TOKEN('NAME', p_position_name);
5618: FND_MESSAGE.SET_TOKEN('EMP', p_employee_number);
5619: FND_MSG_PUB.Add;
5620: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
5621: FND_MSG_PUB.Add;
5622:

Line 5620: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');

5616: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_POSITION');
5617: FND_MESSAGE.SET_TOKEN('NAME', p_position_name);
5618: FND_MESSAGE.SET_TOKEN('EMP', p_employee_number);
5619: FND_MSG_PUB.Add;
5620: FND_MESSAGE.SET_NAME('PSB', 'PSB_VAL_LINE');
5621: FND_MSG_PUB.Add;
5622:
5623: END IF;
5624: p_error_flag := FND_API.G_RET_STS_ERROR ;