86: l_msg_count NUMBER ;
87: l_msg_data VARCHAR2(1000) ;
88: BEGIN
89: --
90: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
91: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,
92: p_api_name ) ;
93: END IF;
94: --
87: l_msg_data VARCHAR2(1000) ;
88: BEGIN
89: --
90: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
91: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,
92: p_api_name ) ;
93: END IF;
94: --
95: FND_MSG_PUB.Get( p_msg_index => 1 ,
91: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,
92: p_api_name ) ;
93: END IF;
94: --
95: FND_MSG_PUB.Get( p_msg_index => 1 ,
96: p_encoded => FND_API.G_FALSE ,
97: p_data => l_msg_data ,
98: p_msg_index_out => l_msg_count
99: ) ;
1704: l_msg := FND_MESSAGE.Get;
1705: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');
1706: FND_MESSAGE.SET_TOKEN('POSITION_NAME',p_name );
1707: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);
1708: FND_MSG_PUB.Add;
1709: hr_utility.set_location('error in get segments',9867);
1710: RAISE FND_API.G_EXC_ERROR;
1711: end if;
1712:
1969: combination_id => l_ccid
1970: )
1971: then
1972: l_msg := FND_MESSAGE.get;
1973: FND_MSG_PUB.Add;
1974: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_CCID_FAILURE');
1975: FND_MESSAGE.SET_TOKEN('ERRMESG',l_msg);
1976: hr_utility.set_location('error in get combination id',9867);
1977: RAISE FND_API.G_EXC_ERROR;
2328: l_msg := FND_MESSAGE.Get;
2329: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');
2330: FND_MESSAGE.SET_TOKEN('POSITION_NAME',p_name );
2331: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);
2332: FND_MSG_PUB.Add;
2333: hr_utility.set_location('error in get segments',9850);
2334: RAISE FND_API.G_EXC_ERROR;
2335: end if;
2336:
2594: segments => isegs,
2595: combination_id => l_ccid)
2596: then
2597: l_msg := FND_MESSAGE.get;
2598: FND_MSG_PUB.Add;
2599: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_CCID_FAILURE');
2600: FND_MESSAGE.SET_TOKEN('ERRMESG',l_msg);
2601: hr_utility.set_location('error in get combination id',9867);
2602: RAISE FND_API.G_EXC_ERROR;
2969: l_msg := FND_MESSAGE.Get;
2970: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');
2971: FND_MESSAGE.SET_TOKEN('POSITION_NAME',p_name );
2972: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);
2973: FND_MSG_PUB.Add;
2974: hr_utility.set_location('error in get segments',9850);
2975: RAISE FND_API.G_EXC_ERROR;
2976: end if;
2977:
3232: segments => isegs,
3233: combination_id => l_ccid)
3234: then
3235: l_msg := FND_MESSAGE.get;
3236: FND_MSG_PUB.ADD;
3237: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_CCID_FAILURE');
3238: FND_MESSAGE.SET_TOKEN('ERRMESG',l_msg);
3239: hr_utility.set_location('error in get combination id',9867);
3240: RAISE FND_API.G_EXC_ERROR;
3601: l_msg := FND_MESSAGE.Get;
3602: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');
3603: FND_MESSAGE.SET_TOKEN('POSITION_NAME',p_name );
3604: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);
3605: FND_MSG_PUB.Add;
3606: hr_utility.set_location('error in get segments',9850);
3607: RAISE FND_API.G_EXC_ERROR;
3608: end if;
3609:
3867: segments => isegs,
3868: combination_id => l_ccid)
3869: then
3870: l_msg := FND_MESSAGE.get;
3871: FND_MSG_PUB.Add;
3872: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_CCID_FAILURE');
3873: FND_MESSAGE.SET_TOKEN('ERRMESG',l_msg);
3874: hr_utility.set_location('error in get combination id',9867);
3875: RAISE FND_API.G_EXC_ERROR;
4328: p_return_status := FND_API.G_RET_STS_ERROR;
4329: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
4330: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
4331: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
4332: FND_MSG_PUB.Add;
4333:
4334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4335: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4336: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
4335: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4336: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
4337: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
4338: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
4339: FND_MSG_PUB.Add;
4340:
4341: WHEN OTHERS THEN
4342: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4343: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
4342: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4343: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
4344: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
4345: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
4346: FND_MSG_PUB.Add;
4347:
4348: END Create_Salary_Distributions;
4349: /*---------------------------------------------------------------------------*/
4350:
4962: FND_MESSAGE.SET_TOKEN('AWARD_ID', l_award_id );
4963: FND_MESSAGE.SET_TOKEN('EXPENDITURE_TYPE', l_expenditure_type );
4964: FND_MESSAGE.SET_TOKEN('EXPENDITURE_ORGANIZATION_ID',
4965: l_expenditure_org_id );
4966: FND_MSG_PUB.ADD;
4967:
4968: -- Added an extra message as one message was getting truncated in
4969: -- the request out file.
4970: FND_MESSAGE.SET_NAME('PSB', 'PSB_POETA_AG_ERROR_MESSAGE');
4968: -- Added an extra message as one message was getting truncated in
4969: -- the request out file.
4970: FND_MESSAGE.SET_NAME('PSB', 'PSB_POETA_AG_ERROR_MESSAGE');
4971: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', l_message_text);
4972: FND_MSG_PUB.ADD;
4973:
4974: END IF;
4975: -- End checking if CCID got generated.
4976:
5442: FND_FILE.put_line(FND_FILE.LOG,l_msg);
5443: FND_MESSAGE.SET_NAME('PSB','PSB_POSITION_COST_CCID_FAILURE');
5444: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
5445: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);
5446: FND_MSG_PUB.Add;
5447: RETURN;
5448: --
5449: END IF;
5450:
5808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5809: END IF;
5810: --
5811: IF FND_API.to_Boolean (p_init_msg_lISt) THEN
5812: FND_MSG_PUB.initialize;
5813: END IF;
5814: p_return_status := FND_API.G_RET_STS_SUCCESS;
5815:
5816: -- for bug 4213882
6335: VALUES (
6336: -4712, -4712, 'XXX', null, l_msg, SYSDATE, -1);
6337: /* end bug no 4170600 */
6338:
6339: FND_MSG_PUB.Add;
6340: --RAISE FND_API.G_EXC_ERROR;
6341:
6342: ELSE
6343:
6856: WHEN FND_API.G_EXC_ERROR THEN
6857: --
6858: ROLLBACK to Populate_Position;
6859: p_return_status := FND_API.G_RET_STS_ERROR;
6860: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6861: p_data => p_msg_data);
6862: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
6863: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
6864: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
6861: p_data => p_msg_data);
6862: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
6863: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
6864: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
6865: FND_MSG_PUB.Add;
6866: --
6867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6868: ROLLBACK to Populate_Position;
6869: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6866: --
6867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6868: ROLLBACK to Populate_Position;
6869: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6870: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6871: p_data => p_msg_data);
6872: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
6873: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
6874: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
6871: p_data => p_msg_data);
6872: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
6873: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
6874: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
6875: FND_MSG_PUB.Add;
6876: --
6877: WHEN OTHERS THEN
6878: --
6879: ROLLBACK to Populate_Position;
6877: WHEN OTHERS THEN
6878: --
6879: ROLLBACK to Populate_Position;
6880: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6881: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
6882: p_data => p_msg_data);
6883:
6884: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
6885: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
6883:
6884: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
6885: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
6886: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
6887: FND_MSG_PUB.Add;
6888:
6889: IF FND_MSG_PUB.Check_Msg_Level
6890: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6891: THEN
6885: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
6886: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
6887: FND_MSG_PUB.Add;
6888:
6889: IF FND_MSG_PUB.Check_Msg_Level
6890: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6891: THEN
6892: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
6893: l_api_name ) ;
6886: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
6887: FND_MSG_PUB.Add;
6888:
6889: IF FND_MSG_PUB.Check_Msg_Level
6890: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6891: THEN
6892: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
6893: l_api_name ) ;
6894: END IF;
6888:
6889: IF FND_MSG_PUB.Check_Msg_Level
6890: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6891: THEN
6892: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,
6893: l_api_name ) ;
6894: END IF;
6895: --
6896: END Populate_Position_Information;
7142:
7143: -- Initialize message lISt IF p_init_msg_lISt IS set to TRUE.
7144:
7145: IF FND_API.to_Boolean (p_init_msg_lISt) THEN
7146: FND_MSG_PUB.initialize;
7147: END IF;
7148:
7149: -- Initialize API return status to success
7150:
7802:
7803: WHEN FND_API.G_EXC_ERROR THEN
7804: ROLLBACK to Populate_Employee;
7805: p_return_status := FND_API.G_RET_STS_ERROR;
7806: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7807: p_data => p_msg_data);
7808: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
7809: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
7810: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
7807: p_data => p_msg_data);
7808: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
7809: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
7810: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
7811: FND_MSG_PUB.Add;
7812:
7813: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7814: ROLLBACK to Populate_Employee;
7815: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7812:
7813: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7814: ROLLBACK to Populate_Employee;
7815: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7816: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7817: p_data => p_msg_data);
7818: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
7819: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
7820: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
7817: p_data => p_msg_data);
7818: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
7819: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
7820: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
7821: FND_MSG_PUB.Add;
7822:
7823: WHEN OTHERS THEN
7824: ROLLBACK to Populate_Employee;
7825: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7822:
7823: WHEN OTHERS THEN
7824: ROLLBACK to Populate_Employee;
7825: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7826: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
7827: p_data => p_msg_data);
7828:
7829: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
7830: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
7828:
7829: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
7830: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
7831: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
7832: FND_MSG_PUB.Add;
7833:
7834: IF FND_MSG_PUB.Check_Msg_Level
7835: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7836: THEN
7830: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
7831: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
7832: FND_MSG_PUB.Add;
7833:
7834: IF FND_MSG_PUB.Check_Msg_Level
7835: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7836: THEN
7837: FND_MSG_PUB.Add_Exc_Msg
7838: (p_pkg_name => G_PKG_NAME,
7831: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
7832: FND_MSG_PUB.Add;
7833:
7834: IF FND_MSG_PUB.Check_Msg_Level
7835: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7836: THEN
7837: FND_MSG_PUB.Add_Exc_Msg
7838: (p_pkg_name => G_PKG_NAME,
7839: p_procedure_name => l_api_name);
7833:
7834: IF FND_MSG_PUB.Check_Msg_Level
7835: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7836: THEN
7837: FND_MSG_PUB.Add_Exc_Msg
7838: (p_pkg_name => G_PKG_NAME,
7839: p_procedure_name => l_api_name);
7840: END IF;
7841:
7952:
7953: -- Initialize message lISt IF p_init_msg_lISt IS set to TRUE.
7954:
7955: IF FND_API.to_Boolean (p_init_msg_lISt) THEN
7956: FND_MSG_PUB.initialize;
7957: END IF;
7958:
7959: -- Initialize API return status to success
7960: p_return_status := FND_API.G_RET_STS_SUCCESS;
8383:
8384: WHEN FND_API.G_EXC_ERROR THEN
8385: ROLLBACK to Populate_Element;
8386: p_return_status := FND_API.G_RET_STS_ERROR;
8387: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8388: p_data => p_msg_data);
8389: FND_MESSAGE.SET_NAME('PSB', 'PSB_SALARY_DETAILS');
8390: FND_MESSAGE.SET_TOKEN('SALARY_TYPE',lm_salary_type );
8391: FND_MESSAGE.SET_TOKEN('RATE_OR_PAYSCALE_NAME',lm_rate_or_payscale_name );
8391: FND_MESSAGE.SET_TOKEN('RATE_OR_PAYSCALE_NAME',lm_rate_or_payscale_name );
8392: FND_MESSAGE.SET_TOKEN('GRADE_NAME',lm_grade_name );
8393: FND_MESSAGE.SET_TOKEN('GRADE_STEP',lm_grade_step );
8394: FND_MESSAGE.SET_TOKEN('GRADE_SEQUENCE',lm_sequence_number);
8395: FND_MSG_PUB.Add;
8396:
8397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8398: ROLLBACK to Populate_Element;
8399: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8396:
8397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8398: ROLLBACK to Populate_Element;
8399: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8400: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8401: p_data => p_msg_data);
8402: FND_MESSAGE.SET_NAME('PSB', 'PSB_SALARY_DETAILS');
8403: FND_MESSAGE.SET_TOKEN('SALARY_TYPE',lm_salary_type );
8404: FND_MESSAGE.SET_TOKEN('RATE_OR_PAYSCALE_NAME',lm_rate_or_payscale_name );
8404: FND_MESSAGE.SET_TOKEN('RATE_OR_PAYSCALE_NAME',lm_rate_or_payscale_name );
8405: FND_MESSAGE.SET_TOKEN('GRADE_NAME',lm_grade_name );
8406: FND_MESSAGE.SET_TOKEN('GRADE_STEP',lm_grade_step );
8407: FND_MESSAGE.SET_TOKEN('GRADE_SEQUENCE',lm_sequence_number);
8408: FND_MSG_PUB.Add;
8409:
8410: WHEN OTHERS THEN
8411: ROLLBACK to Populate_Element;
8412: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8409:
8410: WHEN OTHERS THEN
8411: ROLLBACK to Populate_Element;
8412: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8413: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8414: p_data => p_msg_data);
8415:
8416: FND_MESSAGE.SET_NAME('PSB', 'PSB_SALARY_DETAILS');
8417: FND_MESSAGE.SET_TOKEN('SALARY_TYPE',lm_salary_type );
8418: FND_MESSAGE.SET_TOKEN('RATE_OR_PAYSCALE_NAME',lm_rate_or_payscale_name );
8419: FND_MESSAGE.SET_TOKEN('GRADE_NAME',lm_grade_name );
8420: FND_MESSAGE.SET_TOKEN('GRADE_STEP',lm_grade_step );
8421: FND_MESSAGE.SET_TOKEN('GRADE_SEQUENCE',lm_sequence_number);
8422: FND_MSG_PUB.Add;
8423:
8424: IF FND_MSG_PUB.Check_Msg_Level
8425: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8426: THEN
8420: FND_MESSAGE.SET_TOKEN('GRADE_STEP',lm_grade_step );
8421: FND_MESSAGE.SET_TOKEN('GRADE_SEQUENCE',lm_sequence_number);
8422: FND_MSG_PUB.Add;
8423:
8424: IF FND_MSG_PUB.Check_Msg_Level
8425: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8426: THEN
8427: FND_MSG_PUB.Add_Exc_Msg
8428: (p_pkg_name => G_PKG_NAME,
8421: FND_MESSAGE.SET_TOKEN('GRADE_SEQUENCE',lm_sequence_number);
8422: FND_MSG_PUB.Add;
8423:
8424: IF FND_MSG_PUB.Check_Msg_Level
8425: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8426: THEN
8427: FND_MSG_PUB.Add_Exc_Msg
8428: (p_pkg_name => G_PKG_NAME,
8429: p_procedure_name => l_api_name);
8423:
8424: IF FND_MSG_PUB.Check_Msg_Level
8425: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8426: THEN
8427: FND_MSG_PUB.Add_Exc_Msg
8428: (p_pkg_name => G_PKG_NAME,
8429: p_procedure_name => l_api_name);
8430: END IF;
8431:
8534:
8535: -- Initialize message lISt IF p_init_msg_lISt IS set to TRUE.
8536:
8537: IF FND_API.to_Boolean (p_init_msg_lISt) THEN
8538: FND_MSG_PUB.initialize;
8539: END IF;
8540:
8541: -- Initialize API return status to success
8542:
8815:
8816: WHEN FND_API.G_EXC_ERROR THEN
8817: ROLLBACK to Populate_Attributes;
8818: p_return_status := FND_API.G_RET_STS_ERROR;
8819: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8820: p_data => p_msg_data);
8821: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');
8822: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',l_attribute_name);
8823: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',l_attribute_value);
8820: p_data => p_msg_data);
8821: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');
8822: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',l_attribute_name);
8823: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',l_attribute_value);
8824: FND_MSG_PUB.Add;
8825:
8826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8827: ROLLBACK to Populate_Attributes;
8828: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8825:
8826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8827: ROLLBACK to Populate_Attributes;
8828: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8829: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8830: p_data => p_msg_data);
8831: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');
8832: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',l_attribute_name);
8833: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',l_attribute_value);
8830: p_data => p_msg_data);
8831: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');
8832: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',l_attribute_name);
8833: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',l_attribute_value);
8834: FND_MSG_PUB.Add;
8835:
8836: WHEN OTHERS THEN
8837: ROLLBACK to Populate_Attributes;
8838: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8835:
8836: WHEN OTHERS THEN
8837: ROLLBACK to Populate_Attributes;
8838: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8839: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8840: p_data => p_msg_data);
8841:
8842: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');
8843: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',l_attribute_name);
8841:
8842: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');
8843: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',l_attribute_name);
8844: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',l_attribute_value);
8845: FND_MSG_PUB.Add;
8846:
8847: IF FND_MSG_PUB.Check_Msg_Level
8848: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8849: THEN
8843: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',l_attribute_name);
8844: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',l_attribute_value);
8845: FND_MSG_PUB.Add;
8846:
8847: IF FND_MSG_PUB.Check_Msg_Level
8848: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8849: THEN
8850: FND_MSG_PUB.Add_Exc_Msg
8851: (p_pkg_name => G_PKG_NAME,
8844: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',l_attribute_value);
8845: FND_MSG_PUB.Add;
8846:
8847: IF FND_MSG_PUB.Check_Msg_Level
8848: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8849: THEN
8850: FND_MSG_PUB.Add_Exc_Msg
8851: (p_pkg_name => G_PKG_NAME,
8852: p_procedure_name => l_api_name);
8846:
8847: IF FND_MSG_PUB.Check_Msg_Level
8848: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8849: THEN
8850: FND_MSG_PUB.Add_Exc_Msg
8851: (p_pkg_name => G_PKG_NAME,
8852: p_procedure_name => l_api_name);
8853: END IF;
8854:
8893:
8894: -- Initialize message lISt IF p_init_msg_lISt IS set to TRUE.
8895:
8896: IF FND_API.to_Boolean (p_init_msg_lISt) THEN
8897: FND_MSG_PUB.initialize;
8898: END IF;
8899:
8900: -- Initialize API return status to success
8901:
8955:
8956: WHEN FND_API.G_EXC_ERROR THEN
8957: ROLLBACK to Populate_Costing;
8958: p_return_status := FND_API.G_RET_STS_ERROR;
8959: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8960: p_data => p_msg_data);
8961:
8962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8963: ROLLBACK to Populate_Costing;
8961:
8962: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8963: ROLLBACK to Populate_Costing;
8964: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8965: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8966: p_data => p_msg_data);
8967:
8968: WHEN OTHERS THEN
8969: ROLLBACK to Populate_Costing;
8967:
8968: WHEN OTHERS THEN
8969: ROLLBACK to Populate_Costing;
8970: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8971: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8972: p_data => p_msg_data);
8973:
8974: IF FND_MSG_PUB.Check_Msg_Level
8975: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8970: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8971: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8972: p_data => p_msg_data);
8973:
8974: IF FND_MSG_PUB.Check_Msg_Level
8975: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8976: THEN
8977: FND_MSG_PUB.Add_Exc_Msg
8978: (p_pkg_name => G_PKG_NAME,
8971: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
8972: p_data => p_msg_data);
8973:
8974: IF FND_MSG_PUB.Check_Msg_Level
8975: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8976: THEN
8977: FND_MSG_PUB.Add_Exc_Msg
8978: (p_pkg_name => G_PKG_NAME,
8979: p_procedure_name => l_api_name);
8973:
8974: IF FND_MSG_PUB.Check_Msg_Level
8975: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8976: THEN
8977: FND_MSG_PUB.Add_Exc_Msg
8978: (p_pkg_name => G_PKG_NAME,
8979: p_procedure_name => l_api_name);
8980: END IF;
8981:
9084:
9085: -- Initialize message lISt IF p_init_msg_lISt IS set to TRUE.
9086:
9087: IF FND_API.to_Boolean (p_init_msg_lISt) THEN
9088: FND_MSG_PUB.initialize;
9089: END IF;
9090:
9091: -- Initialize API return status to success
9092:
9490:
9491: WHEN FND_API.G_EXC_ERROR THEN
9492: ROLLBACK to Populate_Position_Assignments;
9493: p_return_status := FND_API.G_RET_STS_ERROR;
9494: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9495: p_data => p_msg_data);
9496: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
9497: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
9498: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
9495: p_data => p_msg_data);
9496: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
9497: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
9498: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
9499: FND_MSG_PUB.Add;
9500: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');
9501: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',lp_attribute_name);
9502: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',lp_attribute_value);
9503: FND_MSG_PUB.Add;
9499: FND_MSG_PUB.Add;
9500: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');
9501: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',lp_attribute_name);
9502: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',lp_attribute_value);
9503: FND_MSG_PUB.Add;
9504:
9505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9506: ROLLBACK to Populate_Position_Assignments;
9507: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9504:
9505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9506: ROLLBACK to Populate_Position_Assignments;
9507: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9508: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9509: p_data => p_msg_data);
9510: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
9511: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
9512: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
9509: p_data => p_msg_data);
9510: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
9511: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
9512: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
9513: FND_MSG_PUB.Add;
9514: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');
9515: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',lp_attribute_name);
9516: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',lp_attribute_value);
9517: FND_MSG_PUB.Add;
9513: FND_MSG_PUB.Add;
9514: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');
9515: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',lp_attribute_name);
9516: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',lp_attribute_value);
9517: FND_MSG_PUB.Add;
9518:
9519: WHEN OTHERS THEN
9520: ROLLBACK to Populate_Position_Assignments;
9521: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9518:
9519: WHEN OTHERS THEN
9520: ROLLBACK to Populate_Position_Assignments;
9521: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9522: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9523: p_data => p_msg_data);
9524: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
9525: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
9526: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
9523: p_data => p_msg_data);
9524: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');
9525: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
9526: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
9527: FND_MSG_PUB.Add;
9528: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');
9529: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',lp_attribute_name);
9530: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',lp_attribute_value);
9531: FND_MSG_PUB.Add;
9527: FND_MSG_PUB.Add;
9528: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');
9529: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',lp_attribute_name);
9530: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',lp_attribute_value);
9531: FND_MSG_PUB.Add;
9532:
9533: IF FND_MSG_PUB.Check_Msg_Level
9534: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9535: THEN
9529: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',lp_attribute_name);
9530: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',lp_attribute_value);
9531: FND_MSG_PUB.Add;
9532:
9533: IF FND_MSG_PUB.Check_Msg_Level
9534: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9535: THEN
9536: FND_MSG_PUB.Add_Exc_Msg
9537: (p_pkg_name => G_PKG_NAME,
9530: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',lp_attribute_value);
9531: FND_MSG_PUB.Add;
9532:
9533: IF FND_MSG_PUB.Check_Msg_Level
9534: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9535: THEN
9536: FND_MSG_PUB.Add_Exc_Msg
9537: (p_pkg_name => G_PKG_NAME,
9538: p_procedure_name => l_api_name);
9532:
9533: IF FND_MSG_PUB.Check_Msg_Level
9534: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9535: THEN
9536: FND_MSG_PUB.Add_Exc_Msg
9537: (p_pkg_name => G_PKG_NAME,
9538: p_procedure_name => l_api_name);
9539: END IF;
9540:
9596:
9597: -- Initialize message lISt IF p_init_msg_lISt IS set to TRUE.
9598:
9599: IF FND_API.to_Boolean (p_init_msg_lISt) THEN
9600: FND_MSG_PUB.initialize;
9601: END IF;
9602:
9603: p_return_status := FND_API.G_RET_STS_SUCCESS;
9604: -- API body
9667:
9668: WHEN FND_API.G_EXC_ERROR THEN
9669: ROLLBACK to Apply_Defaults;
9670: p_return_status := FND_API.G_RET_STS_ERROR;
9671: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9672: p_data => p_msg_data);
9673:
9674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9675: ROLLBACK to Apply_Defaults;
9673:
9674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9675: ROLLBACK to Apply_Defaults;
9676: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9677: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9678: p_data => p_msg_data);
9679:
9680: WHEN OTHERS THEN
9681: ROLLBACK to Apply_Defaults;
9679:
9680: WHEN OTHERS THEN
9681: ROLLBACK to Apply_Defaults;
9682: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9683: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9684: p_data => p_msg_data);
9685:
9686: IF FND_MSG_PUB.Check_Msg_Level
9687: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9682: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9683: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9684: p_data => p_msg_data);
9685:
9686: IF FND_MSG_PUB.Check_Msg_Level
9687: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9688: THEN
9689: FND_MSG_PUB.Add_Exc_Msg
9690: (p_pkg_name => G_PKG_NAME,
9683: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
9684: p_data => p_msg_data);
9685:
9686: IF FND_MSG_PUB.Check_Msg_Level
9687: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9688: THEN
9689: FND_MSG_PUB.Add_Exc_Msg
9690: (p_pkg_name => G_PKG_NAME,
9691: p_procedure_name => l_api_name);
9685:
9686: IF FND_MSG_PUB.Check_Msg_Level
9687: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9688: THEN
9689: FND_MSG_PUB.Add_Exc_Msg
9690: (p_pkg_name => G_PKG_NAME,
9691: p_procedure_name => l_api_name);
9692: END IF;
9693: