DBA Data[Home] [Help]

APPS.HXC_TIME_CATEGORY_UTILS_PKG dependencies on FND_MESSAGE

Line 537: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

533:
534: l_tc_ind := l_tc_ind + 1;
535:
536: ELSE
537: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
538: fnd_message.set_token('PROCEDURE', l_proc);
539: fnd_message.set_token('STEP','Invalid TYPE');
540: fnd_message.raise_error;
541: END IF;

Line 538: fnd_message.set_token('PROCEDURE', l_proc);

534: l_tc_ind := l_tc_ind + 1;
535:
536: ELSE
537: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
538: fnd_message.set_token('PROCEDURE', l_proc);
539: fnd_message.set_token('STEP','Invalid TYPE');
540: fnd_message.raise_error;
541: END IF;
542:

Line 539: fnd_message.set_token('STEP','Invalid TYPE');

535:
536: ELSE
537: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
538: fnd_message.set_token('PROCEDURE', l_proc);
539: fnd_message.set_token('STEP','Invalid TYPE');
540: fnd_message.raise_error;
541: END IF;
542:
543: END LOOP;

Line 540: fnd_message.raise_error;

536: ELSE
537: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
538: fnd_message.set_token('PROCEDURE', l_proc);
539: fnd_message.set_token('STEP','Invalid TYPE');
540: fnd_message.raise_error;
541: END IF;
542:
543: END LOOP;
544:

Line 1006: fnd_message.set_name('HXC', 'HXC_HTC_INVALID_SQL');

1002: null;
1003:
1004: WHEN OTHERS THEN
1005:
1006: fnd_message.set_name('HXC', 'HXC_HTC_INVALID_SQL');
1007: fnd_message.set_token('ERROR', SQLERRM );
1008: fnd_message.raise_error;
1009:
1010: END;

Line 1007: fnd_message.set_token('ERROR', SQLERRM );

1003:
1004: WHEN OTHERS THEN
1005:
1006: fnd_message.set_name('HXC', 'HXC_HTC_INVALID_SQL');
1007: fnd_message.set_token('ERROR', SQLERRM );
1008: fnd_message.raise_error;
1009:
1010: END;
1011:

Line 1008: fnd_message.raise_error;

1004: WHEN OTHERS THEN
1005:
1006: fnd_message.set_name('HXC', 'HXC_HTC_INVALID_SQL');
1007: fnd_message.set_token('ERROR', SQLERRM );
1008: fnd_message.raise_error;
1009:
1010: END;
1011:
1012: END validate_time_category_sql;

Line 1179: fnd_message.set_name('HXC', 'HXC_TC_INV_EQUAL_IS_NULL_COMBO');

1175: IF ( g_debug ) THEN
1176: hr_utility.trace('GAZ - INVALID COMBO');
1177: END IF;
1178:
1179: fnd_message.set_name('HXC', 'HXC_TC_INV_EQUAL_IS_NULL_COMBO');
1180: fnd_message.raise_error;
1181:
1182: ELSIF ( ( l_value_string = '' ) AND ( p_comps_r.equal_to = 'Y' ) )
1183: THEN

Line 1180: fnd_message.raise_error;

1176: hr_utility.trace('GAZ - INVALID COMBO');
1177: END IF;
1178:
1179: fnd_message.set_name('HXC', 'HXC_TC_INV_EQUAL_IS_NULL_COMBO');
1180: fnd_message.raise_error;
1181:
1182: ELSIF ( ( l_value_string = '' ) AND ( p_comps_r.equal_to = 'Y' ) )
1183: THEN
1184: IF ( p_an_sql )

Line 1300: fnd_message.set_name('HXC', 'HXC_TC_INV_EQUAL_IS_NULL_COMBO');

1296: IF ( g_debug ) THEN
1297: hr_utility.trace('GAZ - INVALID COMBO');
1298: END IF;
1299:
1300: fnd_message.set_name('HXC', 'HXC_TC_INV_EQUAL_IS_NULL_COMBO');
1301: fnd_message.raise_error;
1302:
1303: ELSIF ( ( l_value_string = '' ) AND ( p_comps_r.equal_to = 'Y' ) )
1304: THEN

Line 1301: fnd_message.raise_error;

1297: hr_utility.trace('GAZ - INVALID COMBO');
1298: END IF;
1299:
1300: fnd_message.set_name('HXC', 'HXC_TC_INV_EQUAL_IS_NULL_COMBO');
1301: fnd_message.raise_error;
1302:
1303: ELSIF ( ( l_value_string = '' ) AND ( p_comps_r.equal_to = 'Y' ) )
1304: THEN
1305:

Line 1705: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

1701: IF ( l_first_context <> l_alternate_name_comps_r.context )
1702: THEN
1703: CLOSE csr_get_alternate_name_comps;
1704:
1705: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1706: fnd_message.set_token('PROCEDURE', l_proc);
1707: fnd_message.set_token('STEP','Alternate name component contexts different');
1708: fnd_message.raise_error;
1709: END IF;

Line 1706: fnd_message.set_token('PROCEDURE', l_proc);

1702: THEN
1703: CLOSE csr_get_alternate_name_comps;
1704:
1705: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1706: fnd_message.set_token('PROCEDURE', l_proc);
1707: fnd_message.set_token('STEP','Alternate name component contexts different');
1708: fnd_message.raise_error;
1709: END IF;
1710:

Line 1707: fnd_message.set_token('STEP','Alternate name component contexts different');

1703: CLOSE csr_get_alternate_name_comps;
1704:
1705: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1706: fnd_message.set_token('PROCEDURE', l_proc);
1707: fnd_message.set_token('STEP','Alternate name component contexts different');
1708: fnd_message.raise_error;
1709: END IF;
1710:
1711: END LOOP;

Line 1708: fnd_message.raise_error;

1704:
1705: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1706: fnd_message.set_token('PROCEDURE', l_proc);
1707: fnd_message.set_token('STEP','Alternate name component contexts different');
1708: fnd_message.raise_error;
1709: END IF;
1710:
1711: END LOOP;
1712:

Line 2200: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

2196: THEN
2197:
2198: IF ( NOT l_day_index_tab.EXISTS(p_blocks(l_ind).parent_building_block_id))
2199: THEN
2200: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2201: fnd_message.set_token('PROCEDURE', l_proc);
2202: fnd_message.set_token('STEP','DAY index does not exist ');
2203: fnd_message.raise_error;
2204: END IF;

Line 2201: fnd_message.set_token('PROCEDURE', l_proc);

2197:
2198: IF ( NOT l_day_index_tab.EXISTS(p_blocks(l_ind).parent_building_block_id))
2199: THEN
2200: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2201: fnd_message.set_token('PROCEDURE', l_proc);
2202: fnd_message.set_token('STEP','DAY index does not exist ');
2203: fnd_message.raise_error;
2204: END IF;
2205:

Line 2202: fnd_message.set_token('STEP','DAY index does not exist ');

2198: IF ( NOT l_day_index_tab.EXISTS(p_blocks(l_ind).parent_building_block_id))
2199: THEN
2200: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2201: fnd_message.set_token('PROCEDURE', l_proc);
2202: fnd_message.set_token('STEP','DAY index does not exist ');
2203: fnd_message.raise_error;
2204: END IF;
2205:
2206: l_start_time :=

Line 2203: fnd_message.raise_error;

2199: THEN
2200: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2201: fnd_message.set_token('PROCEDURE', l_proc);
2202: fnd_message.set_token('STEP','DAY index does not exist ');
2203: fnd_message.raise_error;
2204: END IF;
2205:
2206: l_start_time :=
2207: FND_DATE.CANONICAL_TO_DATE(p_blocks(l_day_index_tab(p_blocks(l_ind).parent_building_block_id)).start_time);

Line 2810: fnd_message.set_name ('HXC','HXC_GAZ_NOT_A_VS_ROW');

2806: l_first_time_round := TRUE;
2807:
2808: IF ( p_rec.type <> 'MC_VS' )
2809: THEN
2810: fnd_message.set_name ('HXC','HXC_GAZ_NOT_A_VS_ROW');
2811: fnd_message.raise_error;
2812: END IF;
2813:
2814: -- first check the SQL associated with the value set has

Line 2811: fnd_message.raise_error;

2807:
2808: IF ( p_rec.type <> 'MC_VS' )
2809: THEN
2810: fnd_message.set_name ('HXC','HXC_GAZ_NOT_A_VS_ROW');
2811: fnd_message.raise_error;
2812: END IF;
2813:
2814: -- first check the SQL associated with the value set has
2815: -- no $FLEX$ OR $PROFILE$

Line 2823: fnd_message.set_name('HXC', 'HXC_TCC_CANNOT_USE_MPC');

2819: , l_sql_ok);
2820:
2821: IF ( NOT l_sql_ok )
2822: THEN
2823: fnd_message.set_name('HXC', 'HXC_TCC_CANNOT_USE_MPC');
2824: fnd_message.raise_error;
2825: END IF;
2826:
2827: -- get the time category operator

Line 2824: fnd_message.raise_error;

2820:
2821: IF ( NOT l_sql_ok )
2822: THEN
2823: fnd_message.set_name('HXC', 'HXC_TCC_CANNOT_USE_MPC');
2824: fnd_message.raise_error;
2825: END IF;
2826:
2827: -- get the time category operator
2828:

Line 3569: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

3565: ELSIF ( p_scope = 'DAY' )
3566: THEN
3567: -- not supported
3568:
3569: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3570: fnd_message.set_token('PROCEDURE', l_proc);
3571: fnd_message.set_token('STEP','DAY not supported!');
3572: fnd_message.raise_error;
3573:

Line 3570: fnd_message.set_token('PROCEDURE', l_proc);

3566: THEN
3567: -- not supported
3568:
3569: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3570: fnd_message.set_token('PROCEDURE', l_proc);
3571: fnd_message.set_token('STEP','DAY not supported!');
3572: fnd_message.raise_error;
3573:
3574: ELSIF ( p_scope = 'DETAIL' )

Line 3571: fnd_message.set_token('STEP','DAY not supported!');

3567: -- not supported
3568:
3569: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3570: fnd_message.set_token('PROCEDURE', l_proc);
3571: fnd_message.set_token('STEP','DAY not supported!');
3572: fnd_message.raise_error;
3573:
3574: ELSIF ( p_scope = 'DETAIL' )
3575: THEN

Line 3572: fnd_message.raise_error;

3568:
3569: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3570: fnd_message.set_token('PROCEDURE', l_proc);
3571: fnd_message.set_token('STEP','DAY not supported!');
3572: fnd_message.raise_error;
3573:
3574: ELSIF ( p_scope = 'DETAIL' )
3575: THEN
3576:

Line 4004: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

4000: THEN
4001: IF hxc_time_category_utils_pkg.g_time_category_id is not null then
4002: IF g_empty_time_category_tab.exists(hxc_time_category_utils_pkg.g_time_category_id) then
4003: IF NOT g_empty_time_category_tab(hxc_time_category_utils_pkg.g_time_category_id).p_status THEN
4004: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4005: fnd_message.set_token('PROCEDURE', l_proc);
4006: fnd_message.set_token('STEP','g tc id not tc tab id');
4007: fnd_message.raise_error;
4008: END IF;

Line 4005: fnd_message.set_token('PROCEDURE', l_proc);

4001: IF hxc_time_category_utils_pkg.g_time_category_id is not null then
4002: IF g_empty_time_category_tab.exists(hxc_time_category_utils_pkg.g_time_category_id) then
4003: IF NOT g_empty_time_category_tab(hxc_time_category_utils_pkg.g_time_category_id).p_status THEN
4004: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4005: fnd_message.set_token('PROCEDURE', l_proc);
4006: fnd_message.set_token('STEP','g tc id not tc tab id');
4007: fnd_message.raise_error;
4008: END IF;
4009: END IF;

Line 4006: fnd_message.set_token('STEP','g tc id not tc tab id');

4002: IF g_empty_time_category_tab.exists(hxc_time_category_utils_pkg.g_time_category_id) then
4003: IF NOT g_empty_time_category_tab(hxc_time_category_utils_pkg.g_time_category_id).p_status THEN
4004: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4005: fnd_message.set_token('PROCEDURE', l_proc);
4006: fnd_message.set_token('STEP','g tc id not tc tab id');
4007: fnd_message.raise_error;
4008: END IF;
4009: END IF;
4010: END IF;

Line 4007: fnd_message.raise_error;

4003: IF NOT g_empty_time_category_tab(hxc_time_category_utils_pkg.g_time_category_id).p_status THEN
4004: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4005: fnd_message.set_token('PROCEDURE', l_proc);
4006: fnd_message.set_token('STEP','g tc id not tc tab id');
4007: fnd_message.raise_error;
4008: END IF;
4009: END IF;
4010: END IF;
4011: END IF;

Line 4064: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

4060: , p_vs_sql => l_sql );
4061:
4062: ELSE
4063:
4064: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4065: fnd_message.set_token('PROCEDURE', l_proc);
4066: fnd_message.set_token('STEP','Invalid TYPE');
4067: fnd_message.raise_error;
4068:

Line 4065: fnd_message.set_token('PROCEDURE', l_proc);

4061:
4062: ELSE
4063:
4064: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4065: fnd_message.set_token('PROCEDURE', l_proc);
4066: fnd_message.set_token('STEP','Invalid TYPE');
4067: fnd_message.raise_error;
4068:
4069: END IF;

Line 4066: fnd_message.set_token('STEP','Invalid TYPE');

4062: ELSE
4063:
4064: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4065: fnd_message.set_token('PROCEDURE', l_proc);
4066: fnd_message.set_token('STEP','Invalid TYPE');
4067: fnd_message.raise_error;
4068:
4069: END IF;
4070:

Line 4067: fnd_message.raise_error;

4063:
4064: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4065: fnd_message.set_token('PROCEDURE', l_proc);
4066: fnd_message.set_token('STEP','Invalid TYPE');
4067: fnd_message.raise_error;
4068:
4069: END IF;
4070:
4071: validate_time_category_sql ( l_sql );

Line 4368: fnd_message.set_name(809,'HXC_GAZ_VALUE_SET_CHANGED');

4364: else
4365:
4366: -- should only be table or independent value sets
4367:
4368: fnd_message.set_name(809,'HXC_GAZ_VALUE_SET_CHANGED');
4369:
4370: end if; -- validation type
4371:
4372: IF ( g_debug ) THEN

Line 5225: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

5221: l_proc VARCHAR2(72) := g_package||'process_tc_timecard';
5222:
5223: BEGIN
5224:
5225: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5226: fnd_message.set_token('PROCEDURE', l_proc);
5227: fnd_message.set_token('STEP','Procedure redundant use evaluate_time_category');
5228: fnd_message.raise_error;
5229:

Line 5226: fnd_message.set_token('PROCEDURE', l_proc);

5222:
5223: BEGIN
5224:
5225: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5226: fnd_message.set_token('PROCEDURE', l_proc);
5227: fnd_message.set_token('STEP','Procedure redundant use evaluate_time_category');
5228: fnd_message.raise_error;
5229:
5230: END process_tc_timecard;

Line 5227: fnd_message.set_token('STEP','Procedure redundant use evaluate_time_category');

5223: BEGIN
5224:
5225: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5226: fnd_message.set_token('PROCEDURE', l_proc);
5227: fnd_message.set_token('STEP','Procedure redundant use evaluate_time_category');
5228: fnd_message.raise_error;
5229:
5230: END process_tc_timecard;
5231:

Line 5228: fnd_message.raise_error;

5224:
5225: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5226: fnd_message.set_token('PROCEDURE', l_proc);
5227: fnd_message.set_token('STEP','Procedure redundant use evaluate_time_category');
5228: fnd_message.raise_error;
5229:
5230: END process_tc_timecard;
5231:
5232:

Line 5243: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

5239: l_proc varchar2(72) := g_package||'time_category_string';
5240:
5241: BEGIN
5242:
5243: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5244: fnd_message.set_token('PROCEDURE', l_proc);
5245: fnd_message.set_token('STEP','Procedure redundant use evaluate_time_category');
5246: fnd_message.raise_error;
5247:

Line 5244: fnd_message.set_token('PROCEDURE', l_proc);

5240:
5241: BEGIN
5242:
5243: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5244: fnd_message.set_token('PROCEDURE', l_proc);
5245: fnd_message.set_token('STEP','Procedure redundant use evaluate_time_category');
5246: fnd_message.raise_error;
5247:
5248: END time_category_string;

Line 5245: fnd_message.set_token('STEP','Procedure redundant use evaluate_time_category');

5241: BEGIN
5242:
5243: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5244: fnd_message.set_token('PROCEDURE', l_proc);
5245: fnd_message.set_token('STEP','Procedure redundant use evaluate_time_category');
5246: fnd_message.raise_error;
5247:
5248: END time_category_string;
5249:

Line 5246: fnd_message.raise_error;

5242:
5243: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5244: fnd_message.set_token('PROCEDURE', l_proc);
5245: fnd_message.set_token('STEP','Procedure redundant use evaluate_time_category');
5246: fnd_message.raise_error;
5247:
5248: END time_category_string;
5249:
5250:

Line 5322: fnd_message.set_name('HXC', 'HXC_HTC_ALIAS_REF_INT_CHECK');

5318:
5319: IF ( l_time_category_name IS NOT NULL )
5320: THEN
5321:
5322: fnd_message.set_name('HXC', 'HXC_HTC_ALIAS_REF_INT_CHECK');
5323: fnd_message.set_token('TC_NAME', l_time_category_name );
5324: fnd_message.raise_error;
5325:
5326: END IF;

Line 5323: fnd_message.set_token('TC_NAME', l_time_category_name );

5319: IF ( l_time_category_name IS NOT NULL )
5320: THEN
5321:
5322: fnd_message.set_name('HXC', 'HXC_HTC_ALIAS_REF_INT_CHECK');
5323: fnd_message.set_token('TC_NAME', l_time_category_name );
5324: fnd_message.raise_error;
5325:
5326: END IF;
5327:

Line 5324: fnd_message.raise_error;

5320: THEN
5321:
5322: fnd_message.set_name('HXC', 'HXC_HTC_ALIAS_REF_INT_CHECK');
5323: fnd_message.set_token('TC_NAME', l_time_category_name );
5324: fnd_message.raise_error;
5325:
5326: END IF;
5327:
5328:

Line 5376: fnd_message.set_name('HXC', 'HXC_HTC_ALIAS_REF_INT_CHECK');

5372:
5373: IF ( l_time_category_name IS NOT NULL )
5374: THEN
5375:
5376: fnd_message.set_name('HXC', 'HXC_HTC_ALIAS_REF_INT_CHECK');
5377: fnd_message.set_token('TC_NAME', l_time_category_name );
5378: fnd_message.raise_error;
5379:
5380: END IF;

Line 5377: fnd_message.set_token('TC_NAME', l_time_category_name );

5373: IF ( l_time_category_name IS NOT NULL )
5374: THEN
5375:
5376: fnd_message.set_name('HXC', 'HXC_HTC_ALIAS_REF_INT_CHECK');
5377: fnd_message.set_token('TC_NAME', l_time_category_name );
5378: fnd_message.raise_error;
5379:
5380: END IF;
5381:

Line 5378: fnd_message.raise_error;

5374: THEN
5375:
5376: fnd_message.set_name('HXC', 'HXC_HTC_ALIAS_REF_INT_CHECK');
5377: fnd_message.set_token('TC_NAME', l_time_category_name );
5378: fnd_message.raise_error;
5379:
5380: END IF;
5381:
5382: