DBA Data[Home] [Help]

APPS.PSB_HR_POPULATE_DATA_PVT dependencies on FND_MSG_PUB

Line 90: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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: --

Line 91: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME ,

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 ,

Line 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: ) ;

Line 1708: FND_MSG_PUB.Add;

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:

Line 1973: FND_MSG_PUB.Add;

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;

Line 2332: FND_MSG_PUB.Add;

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:

Line 2598: FND_MSG_PUB.Add;

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;

Line 2973: FND_MSG_PUB.Add;

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:

Line 3236: FND_MSG_PUB.ADD;

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;

Line 3605: FND_MSG_PUB.Add;

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:

Line 3871: FND_MSG_PUB.Add;

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;

Line 4332: FND_MSG_PUB.Add;

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');

Line 4339: FND_MSG_PUB.Add;

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');

Line 4346: FND_MSG_PUB.Add;

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:

Line 4966: FND_MSG_PUB.ADD;

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');

Line 4972: FND_MSG_PUB.ADD;

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:

Line 5446: FND_MSG_PUB.Add;

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:

Line 5812: FND_MSG_PUB.initialize;

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

Line 6339: FND_MSG_PUB.Add;

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:

Line 6860: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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 );

Line 6865: FND_MSG_PUB.Add;

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;

Line 6870: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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 );

Line 6875: FND_MSG_PUB.Add;

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;

Line 6881: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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 );

Line 6887: FND_MSG_PUB.Add;

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

Line 6889: IF FND_MSG_PUB.Check_Msg_Level

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 ) ;

Line 6890: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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;

Line 6892: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME ,

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;

Line 7146: FND_MSG_PUB.initialize;

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:

Line 7806: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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 );

Line 7811: FND_MSG_PUB.Add;

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;

Line 7816: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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 );

Line 7821: FND_MSG_PUB.Add;

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;

Line 7826: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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 );

Line 7832: FND_MSG_PUB.Add;

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

Line 7834: IF FND_MSG_PUB.Check_Msg_Level

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,

Line 7835: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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);

Line 7837: FND_MSG_PUB.Add_Exc_Msg

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:

Line 7956: FND_MSG_PUB.initialize;

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;

Line 8387: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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 );

Line 8395: FND_MSG_PUB.Add;

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;

Line 8400: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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 );

Line 8408: FND_MSG_PUB.Add;

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;

Line 8413: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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 );

Line 8422: FND_MSG_PUB.Add;

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

Line 8424: IF FND_MSG_PUB.Check_Msg_Level

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,

Line 8425: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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);

Line 8427: FND_MSG_PUB.Add_Exc_Msg

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:

Line 8538: FND_MSG_PUB.initialize;

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:

Line 8819: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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);

Line 8824: FND_MSG_PUB.Add;

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;

Line 8829: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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);

Line 8834: FND_MSG_PUB.Add;

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;

Line 8839: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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);

Line 8845: FND_MSG_PUB.Add;

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

Line 8847: IF FND_MSG_PUB.Check_Msg_Level

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,

Line 8848: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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);

Line 8850: FND_MSG_PUB.Add_Exc_Msg

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:

Line 8897: FND_MSG_PUB.initialize;

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:

Line 8959: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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;

Line 8965: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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;

Line 8971: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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)

Line 8974: IF FND_MSG_PUB.Check_Msg_Level

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,

Line 8975: (p_message_level => FND_MSG_PUB.G_MSG_LVL_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,
8979: p_procedure_name => l_api_name);

Line 8977: FND_MSG_PUB.Add_Exc_Msg

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:

Line 9088: FND_MSG_PUB.initialize;

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:

Line 9494: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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 );

Line 9499: FND_MSG_PUB.Add;

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;

Line 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;

Line 9508: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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 );

Line 9513: FND_MSG_PUB.Add;

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;

Line 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;

Line 9522: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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 );

Line 9527: FND_MSG_PUB.Add;

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;

Line 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

Line 9533: IF FND_MSG_PUB.Check_Msg_Level

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,

Line 9534: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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);

Line 9536: FND_MSG_PUB.Add_Exc_Msg

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:

Line 9600: FND_MSG_PUB.initialize;

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

Line 9671: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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;

Line 9677: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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;

Line 9683: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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)

Line 9686: IF FND_MSG_PUB.Check_Msg_Level

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,

Line 9687: (p_message_level => FND_MSG_PUB.G_MSG_LVL_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,
9691: p_procedure_name => l_api_name);

Line 9689: FND_MSG_PUB.Add_Exc_Msg

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: