eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_HR_POPULATE_DATA_PVT dependencies on FND_MESSAGE

Line 101: FND_MESSAGE.SET_NAME ('PSB', 'PSB_DEBUG_MESSAGE') ;

97: p_data => l_msg_data ,
98: p_msg_index_out => l_msg_count
99: ) ;
100: --
101: FND_MESSAGE.SET_NAME ('PSB', 'PSB_DEBUG_MESSAGE') ;
102: FND_MESSAGE.SET_TOKEN('MESSAGE', l_msg_data ) ;
103: FND_MESSAGE.RAISE_ERROR;
104: --
105: END Process_Exception ;

Line 102: FND_MESSAGE.SET_TOKEN('MESSAGE', l_msg_data ) ;

98: p_msg_index_out => l_msg_count
99: ) ;
100: --
101: FND_MESSAGE.SET_NAME ('PSB', 'PSB_DEBUG_MESSAGE') ;
102: FND_MESSAGE.SET_TOKEN('MESSAGE', l_msg_data ) ;
103: FND_MESSAGE.RAISE_ERROR;
104: --
105: END Process_Exception ;
106: /*---------------------------------------------------------------------------*/

Line 103: FND_MESSAGE.RAISE_ERROR;

99: ) ;
100: --
101: FND_MESSAGE.SET_NAME ('PSB', 'PSB_DEBUG_MESSAGE') ;
102: FND_MESSAGE.SET_TOKEN('MESSAGE', l_msg_data ) ;
103: FND_MESSAGE.RAISE_ERROR;
104: --
105: END Process_Exception ;
106: /*---------------------------------------------------------------------------*/
107:

Line 1267: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');

1263: exception
1264: when OTHERS then -- Bug #4658351: Changed VALUE_ERROR to OTHERS
1265:
1266: -- Changed the exception part for Bug#4658351
1267: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');
1268: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
1269: l_message_text := fnd_message.get;
1270: RAISE_APPLICATION_ERROR(-20001,l_message_text);
1271:

Line 1268: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);

1264: when OTHERS then -- Bug #4658351: Changed VALUE_ERROR to OTHERS
1265:
1266: -- Changed the exception part for Bug#4658351
1267: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');
1268: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
1269: l_message_text := fnd_message.get;
1270: RAISE_APPLICATION_ERROR(-20001,l_message_text);
1271:
1272: end;

Line 1269: l_message_text := fnd_message.get;

1265:
1266: -- Changed the exception part for Bug#4658351
1267: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_DATE_ERR');
1268: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
1269: l_message_text := fnd_message.get;
1270: RAISE_APPLICATION_ERROR(-20001,l_message_text);
1271:
1272: end;
1273: elsif (C_Attribute_Rec.data_type = 'N') then

Line 1281: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_NUMBER_ERR');

1277: exception
1278: when INVALID_NUMBER then
1279:
1280: -- Changed the exception part for Bug#4658351
1281: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_NUMBER_ERR');
1282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
1283: l_message_text := fnd_message.get;
1284: RAISE_APPLICATION_ERROR(-20000,l_message_text);
1285:

Line 1282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);

1278: when INVALID_NUMBER then
1279:
1280: -- Changed the exception part for Bug#4658351
1281: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_NUMBER_ERR');
1282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
1283: l_message_text := fnd_message.get;
1284: RAISE_APPLICATION_ERROR(-20000,l_message_text);
1285:
1286: end;

Line 1283: l_message_text := fnd_message.get;

1279:
1280: -- Changed the exception part for Bug#4658351
1281: FND_MESSAGE.SET_NAME('PSB', 'PSB_ATTRIBUTE_VALUE_NUMBER_ERR');
1282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME', l_attribute_name);
1283: l_message_text := fnd_message.get;
1284: RAISE_APPLICATION_ERROR(-20000,l_message_text);
1285:
1286: end;
1287:

Line 1704: l_msg := FND_MESSAGE.Get;

1700:
1701: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num,
1702: p_position_definition_id, nsegs, segs);
1703: if (tf = FALSE) then
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;

Line 1705: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');

1701: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num,
1702: p_position_definition_id, nsegs, segs);
1703: if (tf = FALSE) then
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);

Line 1706: FND_MESSAGE.SET_TOKEN('POSITION_NAME',p_name );

1702: p_position_definition_id, nsegs, segs);
1703: if (tf = FALSE) then
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;

Line 1707: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);

1703: if (tf = FALSE) then
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;

Line 1972: l_msg := FND_MESSAGE.get;

1968: segments => isegs,
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);

Line 1974: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_CCID_FAILURE');

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;
1978: end if;

Line 1975: FND_MESSAGE.SET_TOKEN('ERRMESG',l_msg);

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;
1978: end if;
1979:

Line 2049: FND_MESSAGE.SET_NAME('PSB', 'PSB_PQH_INSERT_FAILURE');

2045: p_name => l_concat_pos_name,
2046: p_mode => 'R'
2047: );
2048: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2049: FND_MESSAGE.SET_NAME('PSB', 'PSB_PQH_INSERT_FAILURE');
2050: RAISE FND_API.G_EXC_ERROR;
2051: END IF;
2052:
2053: -- Addto position sets for WS recalc

Line 2085: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_SALARY_FAILURE');

2081: p_entry_grade_id => p_entry_grade_id,
2082: p_pay_basis_id => p_pay_basis_id
2083: );
2084: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2085: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_SALARY_FAILURE');
2086: RAISE FND_API.G_EXC_ERROR;
2087: END IF;
2088:
2089: Populate_Attribute_Assignments

Line 2106: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_ATTRIBUTE_FAIL');

2102: p_data_extract_id => l_data_extract_id,
2103: p_business_group_id => p_business_group_id
2104: ) ;
2105: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2106: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_ATTRIBUTE_FAIL');
2107: RAISE FND_API.G_EXC_ERROR;
2108: END IF;
2109:
2110: -- Update WS/BR; do only in add since org is cannot be diff than input

Line 2117: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_WS_FAILURE' );

2113: p_org_id => p_organization_id
2114: ) ;
2115: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2116: hr_utility.set_location(' fail to update ws value ',888);
2117: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_WS_FAILURE' );
2118: RAISE FND_API.G_EXC_ERROR;
2119: END IF;
2120:
2121: hr_utility.set_location('>> END insert position trans',777);

Line 2328: l_msg := FND_MESSAGE.Get;

2324:
2325: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num, p_position_definition_id, nsegs, segs);
2326:
2327: if (tf = FALSE) then
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;

Line 2329: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');

2325: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num, p_position_definition_id, nsegs, segs);
2326:
2327: if (tf = FALSE) then
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);

Line 2330: FND_MESSAGE.SET_TOKEN('POSITION_NAME',p_name );

2326:
2327: if (tf = FALSE) then
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;

Line 2331: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);

2327: if (tf = FALSE) then
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;

Line 2597: l_msg := FND_MESSAGE.get;

2593: n_segments => l_pos_index,
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);

Line 2599: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_CCID_FAILURE');

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;
2603: end if;

Line 2600: FND_MESSAGE.SET_TOKEN('ERRMESG',l_msg);

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;
2603: end if;
2604:

Line 2670: FND_MESSAGE.SET_NAME('PSB', 'PSB_PQH_UPDATE_FAILURE' );

2666: --++ update name and hr_position_id; when applied hr_position_id is set
2667: --++ to hr's position id
2668:
2669: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2670: FND_MESSAGE.SET_NAME('PSB', 'PSB_PQH_UPDATE_FAILURE' );
2671:
2672: RAISE FND_API.G_EXC_ERROR;
2673: END IF;
2674:

Line 2695: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_SALARY_FAILURE' );

2691: p_entry_grade_id => p_entry_grade_id,
2692: p_pay_basis_id => p_pay_basis_id_o);
2693:
2694: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2695: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_SALARY_FAILURE' );
2696:
2697: RAISE FND_API.G_EXC_ERROR;
2698: end if;
2699:

Line 2717: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_ATTRIBUTE_FAIL' );

2713: p_data_extract_id => c_pos_trx_rec.data_extract_id,
2714: p_business_group_id => p_business_group_id);
2715:
2716: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2717: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_ATTRIBUTE_FAIL' );
2718: RAISE FND_API.G_EXC_ERROR;
2719: end if;
2720:
2721: end if; --end of p_transaction_status <> applied

Line 2969: l_msg := FND_MESSAGE.Get;

2965: End Loop;
2966:
2967: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num, p_position_definition_id, nsegs, segs);
2968: if (tf = FALSE) then
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;

Line 2970: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');

2966:
2967: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num, p_position_definition_id, nsegs, segs);
2968: if (tf = FALSE) then
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);

Line 2971: FND_MESSAGE.SET_TOKEN('POSITION_NAME',p_name );

2967: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num, p_position_definition_id, nsegs, segs);
2968: if (tf = FALSE) then
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;

Line 2972: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);

2968: if (tf = FALSE) then
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;

Line 3235: l_msg := FND_MESSAGE.get;

3231: n_segments => l_pos_index,
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);

Line 3237: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_CCID_FAILURE');

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;
3241: end if;

Line 3238: FND_MESSAGE.SET_TOKEN('ERRMESG',l_msg);

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;
3241: end if;
3242:

Line 3334: FND_MESSAGE.SET_NAME('PSB', 'PSB_POS_INSERT_FAILURE' );

3330: );
3331:
3332: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3333: hr_utility.set_location('error in insert position',9877);
3334: FND_MESSAGE.SET_NAME('PSB', 'PSB_POS_INSERT_FAILURE' );
3335:
3336: RAISE FND_API.G_EXC_ERROR;
3337: END IF;
3338:

Line 3371: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_SALARY_FAILURE' );

3367: p_entry_grade_id => p_entry_grade_id,
3368: p_pay_basis_id => p_pay_basis_id);
3369:
3370: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3371: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_SALARY_FAILURE' );
3372:
3373: RAISE FND_API.G_EXC_ERROR;
3374: END IF;
3375:

Line 3394: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_ATTRIBUTE_FAIL' );

3390: p_business_group_id => p_business_group_id
3391: ) ;
3392: --
3393: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3394: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_ATTRIBUTE_FAIL' );
3395: RAISE FND_API.G_EXC_ERROR;
3396: END IF;
3397:
3398: hr_utility.set_location(' org id is ' || get_global('G_PSB_ORG_ID') ,888);

Line 3408: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_WS_FAILURE' );

3404: p_org_id => p_organization_id);
3405:
3406: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3407: hr_utility.set_location(' fail to update ws value ',888);
3408: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_WS_FAILURE' );
3409: RAISE FND_API.G_EXC_ERROR;
3410:
3411: RAISE FND_API.G_EXC_ERROR;
3412: END IF;

Line 3601: l_msg := FND_MESSAGE.Get;

3597: End Loop;
3598:
3599: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num, p_position_definition_id, nsegs, segs);
3600: if (tf = FALSE) then
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;

Line 3602: FND_MESSAGE.SET_NAME('PSB','PSB_POS_DEFN_VALUE_ERROR');

3598:
3599: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num, p_position_definition_id, nsegs, segs);
3600: if (tf = FALSE) then
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);

Line 3603: FND_MESSAGE.SET_TOKEN('POSITION_NAME',p_name );

3599: tf := FND_FLEX_EXT.GET_SEGMENTS('PER', 'POS', l_pos_id_flex_num, p_position_definition_id, nsegs, segs);
3600: if (tf = FALSE) then
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;

Line 3604: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);

3600: if (tf = FALSE) then
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;

Line 3870: l_msg := FND_MESSAGE.get;

3866: n_segments => l_pos_index,
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);

Line 3872: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_CCID_FAILURE');

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;
3876: end if;

Line 3873: FND_MESSAGE.SET_TOKEN('ERRMESG',l_msg);

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;
3876: end if;
3877:

Line 3966: FND_MESSAGE.SET_NAME('PSB', 'PSB_POS_UPDATE_FAILURE' );

3962: hr_utility.set_location(' after update position', 1887);
3963:
3964: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3965: hr_utility.set_location(' posb fail after update position', 1887);
3966: FND_MESSAGE.SET_NAME('PSB', 'PSB_POS_UPDATE_FAILURE' );
3967:
3968: RAISE FND_API.G_EXC_ERROR;
3969: END IF;
3970:

Line 3988: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_SALARY_FAILURE' );

3984: p_entry_grade_id => p_entry_grade_id,
3985: p_pay_basis_id => p_pay_basis_id);
3986:
3987: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3988: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_SALARY_FAILURE' );
3989:
3990: RAISE FND_API.G_EXC_ERROR;
3991: END IF;
3992:

Line 4011: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_ATTRIBUTE_FAIL' );

4007: p_business_group_id => p_business_group_id_o);
4008:
4009: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4010: RAISE FND_API.G_EXC_ERROR;
4011: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_ATTRIBUTE_FAIL' );
4012:
4013: END IF;
4014:
4015: End Loop;

Line 4023: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_WS_FAILURE' );

4019: p_org_id => p_organization_id_o);
4020:
4021: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4022: hr_utility.set_location(' fail to update ws value ',888);
4023: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCREMENTAL_WS_FAILURE' );
4024: RAISE FND_API.G_EXC_ERROR;
4025:
4026: RAISE FND_API.G_EXC_ERROR;
4027: END IF;

Line 4128: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCR_INSERT_POS_WS_FAIL');

4124:
4125: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
4126: hr_utility.set_location(' fail to insert row ',888);
4127: --hr_utility.trace_off;
4128: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCR_INSERT_POS_WS_FAIL');
4129: raise FND_API.G_EXC_ERROR;
4130: END IF;
4131: --++ end ws
4132: ELSE

Line 4154: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCR_INSERT_POS_REV_FAIL');

4150: p_freeze_flag => 'N',
4151: p_view_line_flag => 'Y');
4152:
4153: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
4154: FND_MESSAGE.SET_NAME('PSB', 'PSB_INCR_INSERT_POS_REV_FAIL');
4155: raise FND_API.G_EXC_ERROR;
4156: else
4157: -- update the position table for system data extract with budget group ID
4158: -- start bug 3253644

Line 4329: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');

4325: EXCEPTION
4326:
4327: WHEN FND_API.G_EXC_ERROR THEN
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:

Line 4330: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );

4326:
4327: WHEN FND_API.G_EXC_ERROR THEN
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

Line 4331: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );

4327: WHEN FND_API.G_EXC_ERROR THEN
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;

Line 4336: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');

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

Line 4337: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );

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

Line 4338: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );

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

Line 4343: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');

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

Line 4344: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );

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

Line 4345: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );

4341: WHEN OTHERS THEN
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: /*---------------------------------------------------------------------------*/

Line 4950: fnd_message.parse_encoded( l_error_message ,

4946: --
4947: -- Decode l_error_message as l_error_message is always supposed to be
4948: -- in encoded format only as per Workflow Account Generator standards.
4949: --
4950: fnd_message.parse_encoded( l_error_message ,
4951: l_appl_short_name ,
4952: l_message_name
4953: ) ;
4954: l_message_text := fnd_message.get_string( l_appl_short_name,

Line 4954: l_message_text := fnd_message.get_string( l_appl_short_name,

4950: fnd_message.parse_encoded( l_error_message ,
4951: l_appl_short_name ,
4952: l_message_name
4953: ) ;
4954: l_message_text := fnd_message.get_string( l_appl_short_name,
4955: l_message_name);
4956: -- End encoding the messages retrieved as l_error_message.
4957:
4958: FND_MESSAGE.SET_NAME('PSB', 'PSB_POETA_TO_CCID_FAILURE');

Line 4958: FND_MESSAGE.SET_NAME('PSB', 'PSB_POETA_TO_CCID_FAILURE');

4954: l_message_text := fnd_message.get_string( l_appl_short_name,
4955: l_message_name);
4956: -- End encoding the messages retrieved as l_error_message.
4957:
4958: FND_MESSAGE.SET_NAME('PSB', 'PSB_POETA_TO_CCID_FAILURE');
4959: FND_MESSAGE.SET_TOKEN('POSITION_NAME', l_position_name );
4960: FND_MESSAGE.SET_TOKEN('PROJECT_ID', l_project_id );
4961: FND_MESSAGE.SET_TOKEN('TASK_ID', l_task_id );
4962: FND_MESSAGE.SET_TOKEN('AWARD_ID', l_award_id );

Line 4959: FND_MESSAGE.SET_TOKEN('POSITION_NAME', l_position_name );

4955: l_message_name);
4956: -- End encoding the messages retrieved as l_error_message.
4957:
4958: FND_MESSAGE.SET_NAME('PSB', 'PSB_POETA_TO_CCID_FAILURE');
4959: FND_MESSAGE.SET_TOKEN('POSITION_NAME', l_position_name );
4960: FND_MESSAGE.SET_TOKEN('PROJECT_ID', l_project_id );
4961: FND_MESSAGE.SET_TOKEN('TASK_ID', l_task_id );
4962: FND_MESSAGE.SET_TOKEN('AWARD_ID', l_award_id );
4963: FND_MESSAGE.SET_TOKEN('EXPENDITURE_TYPE', l_expenditure_type );

Line 4960: FND_MESSAGE.SET_TOKEN('PROJECT_ID', l_project_id );

4956: -- End encoding the messages retrieved as l_error_message.
4957:
4958: FND_MESSAGE.SET_NAME('PSB', 'PSB_POETA_TO_CCID_FAILURE');
4959: FND_MESSAGE.SET_TOKEN('POSITION_NAME', l_position_name );
4960: FND_MESSAGE.SET_TOKEN('PROJECT_ID', l_project_id );
4961: FND_MESSAGE.SET_TOKEN('TASK_ID', l_task_id );
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',

Line 4961: FND_MESSAGE.SET_TOKEN('TASK_ID', l_task_id );

4957:
4958: FND_MESSAGE.SET_NAME('PSB', 'PSB_POETA_TO_CCID_FAILURE');
4959: FND_MESSAGE.SET_TOKEN('POSITION_NAME', l_position_name );
4960: FND_MESSAGE.SET_TOKEN('PROJECT_ID', l_project_id );
4961: FND_MESSAGE.SET_TOKEN('TASK_ID', l_task_id );
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 );

Line 4962: FND_MESSAGE.SET_TOKEN('AWARD_ID', l_award_id );

4958: FND_MESSAGE.SET_NAME('PSB', 'PSB_POETA_TO_CCID_FAILURE');
4959: FND_MESSAGE.SET_TOKEN('POSITION_NAME', l_position_name );
4960: FND_MESSAGE.SET_TOKEN('PROJECT_ID', l_project_id );
4961: FND_MESSAGE.SET_TOKEN('TASK_ID', l_task_id );
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;

Line 4963: FND_MESSAGE.SET_TOKEN('EXPENDITURE_TYPE', l_expenditure_type );

4959: FND_MESSAGE.SET_TOKEN('POSITION_NAME', l_position_name );
4960: FND_MESSAGE.SET_TOKEN('PROJECT_ID', l_project_id );
4961: FND_MESSAGE.SET_TOKEN('TASK_ID', l_task_id );
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:

Line 4964: FND_MESSAGE.SET_TOKEN('EXPENDITURE_ORGANIZATION_ID',

4960: FND_MESSAGE.SET_TOKEN('PROJECT_ID', l_project_id );
4961: FND_MESSAGE.SET_TOKEN('TASK_ID', l_task_id );
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

Line 4970: FND_MESSAGE.SET_NAME('PSB', 'PSB_POETA_AG_ERROR_MESSAGE');

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');
4971: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', l_message_text);
4972: FND_MSG_PUB.ADD;
4973:
4974: END IF;

Line 4971: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE', l_message_text);

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

Line 5441: l_msg := FND_MESSAGE.Get;

5437: THEN
5438: --
5439: FND_FILE.put_line(FND_FILE.LOG,
5440: 'Cannot create CCID FOR position '|| p_position_id);
5441: l_msg := FND_MESSAGE.Get;
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);

Line 5443: FND_MESSAGE.SET_NAME('PSB','PSB_POSITION_COST_CCID_FAILURE');

5439: FND_FILE.put_line(FND_FILE.LOG,
5440: 'Cannot create CCID FOR position '|| p_position_id);
5441: l_msg := FND_MESSAGE.Get;
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;

Line 5444: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );

5440: 'Cannot create CCID FOR position '|| p_position_id);
5441: l_msg := FND_MESSAGE.Get;
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: --

Line 5445: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);

5441: l_msg := FND_MESSAGE.Get;
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;

Line 6317: l_msg := FND_MESSAGE.Get;

6313: l_last_success_flag := 'N';
6314: END IF;
6315: /* For Bug No: 3066598 End */
6316:
6317: l_msg := FND_MESSAGE.Get;
6318: FND_FILE.put_line(FND_FILE.LOG, 'Cannot import HRMS Position: '||
6319: l_position_i_cache(i).hr_position_id) ;
6320: FND_FILE.put_line(FND_FILE.LOG,l_msg);
6321: FND_MESSAGE.SET_NAME('PSB','PSB_POSITION_CCID_FAILURE');

Line 6321: FND_MESSAGE.SET_NAME('PSB','PSB_POSITION_CCID_FAILURE');

6317: l_msg := FND_MESSAGE.Get;
6318: FND_FILE.put_line(FND_FILE.LOG, 'Cannot import HRMS Position: '||
6319: l_position_i_cache(i).hr_position_id) ;
6320: FND_FILE.put_line(FND_FILE.LOG,l_msg);
6321: FND_MESSAGE.SET_NAME('PSB','PSB_POSITION_CCID_FAILURE');
6322: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
6323: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);
6324:
6325: /* start bug no 4170600 */

Line 6322: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );

6318: FND_FILE.put_line(FND_FILE.LOG, 'Cannot import HRMS Position: '||
6319: l_position_i_cache(i).hr_position_id) ;
6320: FND_FILE.put_line(FND_FILE.LOG,l_msg);
6321: FND_MESSAGE.SET_NAME('PSB','PSB_POSITION_CCID_FAILURE');
6322: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
6323: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);
6324:
6325: /* start bug no 4170600 */
6326: l_msg := FND_MESSAGE.GET;

Line 6323: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);

6319: l_position_i_cache(i).hr_position_id) ;
6320: FND_FILE.put_line(FND_FILE.LOG,l_msg);
6321: FND_MESSAGE.SET_NAME('PSB','PSB_POSITION_CCID_FAILURE');
6322: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
6323: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);
6324:
6325: /* start bug no 4170600 */
6326: l_msg := FND_MESSAGE.GET;
6327: INSERT INTO PSB_ERROR_MESSAGES (

Line 6326: l_msg := FND_MESSAGE.GET;

6322: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );
6323: FND_MESSAGE.SET_TOKEN('ERR_MESG',l_msg);
6324:
6325: /* start bug no 4170600 */
6326: l_msg := FND_MESSAGE.GET;
6327: INSERT INTO PSB_ERROR_MESSAGES (
6328: CONCURRENT_REQUEST_ID,
6329: PROCESS_ID,
6330: SOURCE_PROCESS,

Line 6862: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');

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 );
6865: FND_MSG_PUB.Add;
6866: --

Line 6863: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );

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 );
6865: FND_MSG_PUB.Add;
6866: --
6867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6864: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );

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 );
6865: FND_MSG_PUB.Add;
6866: --
6867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6868: ROLLBACK to Populate_Position;

Line 6872: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');

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 );
6875: FND_MSG_PUB.Add;
6876: --

Line 6873: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );

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 );
6875: FND_MSG_PUB.Add;
6876: --
6877: WHEN OTHERS THEN

Line 6874: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );

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 );
6875: FND_MSG_PUB.Add;
6876: --
6877: WHEN OTHERS THEN
6878: --

Line 6884: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');

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 );
6886: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
6887: FND_MSG_PUB.Add;
6888:

Line 6885: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );

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 );
6886: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
6887: FND_MSG_PUB.Add;
6888:
6889: IF FND_MSG_PUB.Check_Msg_Level

Line 6886: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );

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

Line 7310: fnd_message.set_name('PSB','PSB_NON_GRADE_SALARY');

7306:
7307: l_non_grade_salary := 'Y';
7308: ln_pay_element_id := 0;
7309: l_non_grade_salary_name := '';
7310: fnd_message.set_name('PSB','PSB_NON_GRADE_SALARY');
7311: l_non_grade_salary_name := FND_MESSAGE.GET;
7312: prev_rate_or_payscale_name := l_non_grade_salary_name;
7313:
7314: FOR C_non_grade_salary_rec in C_non_grade_salary

Line 7311: l_non_grade_salary_name := FND_MESSAGE.GET;

7307: l_non_grade_salary := 'Y';
7308: ln_pay_element_id := 0;
7309: l_non_grade_salary_name := '';
7310: fnd_message.set_name('PSB','PSB_NON_GRADE_SALARY');
7311: l_non_grade_salary_name := FND_MESSAGE.GET;
7312: prev_rate_or_payscale_name := l_non_grade_salary_name;
7313:
7314: FOR C_non_grade_salary_rec in C_non_grade_salary
7315: LOOP

Line 7808: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');

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 );
7811: FND_MSG_PUB.Add;
7812:

Line 7809: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );

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 );
7811: FND_MSG_PUB.Add;
7812:
7813: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 7810: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );

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 );
7811: FND_MSG_PUB.Add;
7812:
7813: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7814: ROLLBACK to Populate_Employee;

Line 7818: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');

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 );
7821: FND_MSG_PUB.Add;
7822:

Line 7819: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );

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 );
7821: FND_MSG_PUB.Add;
7822:
7823: WHEN OTHERS THEN

Line 7820: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );

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 );
7821: FND_MSG_PUB.Add;
7822:
7823: WHEN OTHERS THEN
7824: ROLLBACK to Populate_Employee;

Line 7829: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');

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 );
7831: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
7832: FND_MSG_PUB.Add;
7833:

Line 7830: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );

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 );
7831: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );
7832: FND_MSG_PUB.Add;
7833:
7834: IF FND_MSG_PUB.Check_Msg_Level

Line 7831: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );

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

Line 8389: FND_MESSAGE.SET_NAME('PSB', 'PSB_SALARY_DETAILS');

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 );
8392: FND_MESSAGE.SET_TOKEN('GRADE_NAME',lm_grade_name );
8393: FND_MESSAGE.SET_TOKEN('GRADE_STEP',lm_grade_step );

Line 8390: FND_MESSAGE.SET_TOKEN('SALARY_TYPE',lm_salary_type );

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

Line 8391: FND_MESSAGE.SET_TOKEN('RATE_OR_PAYSCALE_NAME',lm_rate_or_payscale_name );

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

Line 8392: FND_MESSAGE.SET_TOKEN('GRADE_NAME',lm_grade_name );

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

Line 8393: FND_MESSAGE.SET_TOKEN('GRADE_STEP',lm_grade_step );

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

Line 8394: FND_MESSAGE.SET_TOKEN('GRADE_SEQUENCE',lm_sequence_number);

8390: FND_MESSAGE.SET_TOKEN('SALARY_TYPE',lm_salary_type );
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;

Line 8402: FND_MESSAGE.SET_NAME('PSB', 'PSB_SALARY_DETAILS');

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 );
8405: FND_MESSAGE.SET_TOKEN('GRADE_NAME',lm_grade_name );
8406: FND_MESSAGE.SET_TOKEN('GRADE_STEP',lm_grade_step );

Line 8403: FND_MESSAGE.SET_TOKEN('SALARY_TYPE',lm_salary_type );

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

Line 8404: FND_MESSAGE.SET_TOKEN('RATE_OR_PAYSCALE_NAME',lm_rate_or_payscale_name );

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

Line 8405: FND_MESSAGE.SET_TOKEN('GRADE_NAME',lm_grade_name );

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

Line 8406: FND_MESSAGE.SET_TOKEN('GRADE_STEP',lm_grade_step );

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

Line 8407: FND_MESSAGE.SET_TOKEN('GRADE_SEQUENCE',lm_sequence_number);

8403: FND_MESSAGE.SET_TOKEN('SALARY_TYPE',lm_salary_type );
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;

Line 8416: FND_MESSAGE.SET_NAME('PSB', 'PSB_SALARY_DETAILS');

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

Line 8417: FND_MESSAGE.SET_TOKEN('SALARY_TYPE',lm_salary_type );

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

Line 8418: FND_MESSAGE.SET_TOKEN('RATE_OR_PAYSCALE_NAME',lm_rate_or_payscale_name );

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;

Line 8419: FND_MESSAGE.SET_TOKEN('GRADE_NAME',lm_grade_name );

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:

Line 8420: FND_MESSAGE.SET_TOKEN('GRADE_STEP',lm_grade_step );

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

Line 8421: FND_MESSAGE.SET_TOKEN('GRADE_SEQUENCE',lm_sequence_number);

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)

Line 8821: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');

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);
8824: FND_MSG_PUB.Add;
8825:

Line 8822: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',l_attribute_name);

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);
8824: FND_MSG_PUB.Add;
8825:
8826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8823: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',l_attribute_value);

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);
8824: FND_MSG_PUB.Add;
8825:
8826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8827: ROLLBACK to Populate_Attributes;

Line 8831: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');

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);
8834: FND_MSG_PUB.Add;
8835:

Line 8832: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',l_attribute_name);

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);
8834: FND_MSG_PUB.Add;
8835:
8836: WHEN OTHERS THEN

Line 8833: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',l_attribute_value);

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);
8834: FND_MSG_PUB.Add;
8835:
8836: WHEN OTHERS THEN
8837: ROLLBACK to Populate_Attributes;

Line 8842: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');

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);
8844: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',l_attribute_value);
8845: FND_MSG_PUB.Add;
8846:

Line 8843: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',l_attribute_name);

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);
8844: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',l_attribute_value);
8845: FND_MSG_PUB.Add;
8846:
8847: IF FND_MSG_PUB.Check_Msg_Level

Line 8844: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',l_attribute_value);

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

Line 9496: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');

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 );
9499: FND_MSG_PUB.Add;
9500: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');

Line 9497: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );

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 );
9499: FND_MSG_PUB.Add;
9500: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');
9501: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',lp_attribute_name);

Line 9498: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );

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

Line 9500: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');

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

Line 9501: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',lp_attribute_name);

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;
9504:
9505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 9502: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',lp_attribute_value);

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;
9504:
9505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9506: ROLLBACK to Populate_Position_Assignments;

Line 9510: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');

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 );
9513: FND_MSG_PUB.Add;
9514: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');

Line 9511: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );

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 );
9513: FND_MSG_PUB.Add;
9514: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');
9515: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',lp_attribute_name);

Line 9512: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );

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

Line 9514: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');

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

Line 9515: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',lp_attribute_name);

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;
9518:
9519: WHEN OTHERS THEN

Line 9516: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',lp_attribute_value);

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;
9518:
9519: WHEN OTHERS THEN
9520: ROLLBACK to Populate_Position_Assignments;

Line 9524: FND_MESSAGE.SET_NAME('PSB', 'PSB_POSITION_DETAILS');

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 );
9527: FND_MSG_PUB.Add;
9528: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');

Line 9525: FND_MESSAGE.SET_TOKEN('POSITION_NAME',l_position_name );

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 );
9527: FND_MSG_PUB.Add;
9528: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');
9529: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',lp_attribute_name);

Line 9526: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME',l_employee_name );

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

Line 9528: FND_MESSAGE.SET_NAME('PSB','PSB_ATTRIBUTE_NAME');

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

Line 9529: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_NAME',lp_attribute_name);

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;
9532:
9533: IF FND_MSG_PUB.Check_Msg_Level

Line 9530: FND_MESSAGE.SET_TOKEN('ATTRIBUTE_VALUE',lp_attribute_value);

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;
9532:
9533: IF FND_MSG_PUB.Check_Msg_Level
9534: (p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)