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 1027: fnd_message.set_name('HXC', 'HXC_HTC_INVALID_SQL');

1023: null;
1024:
1025: WHEN OTHERS THEN
1026:
1027: fnd_message.set_name('HXC', 'HXC_HTC_INVALID_SQL');
1028: fnd_message.set_token('ERROR', SQLERRM );
1029: fnd_message.raise_error;
1030:
1031: END;

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

1024:
1025: WHEN OTHERS THEN
1026:
1027: fnd_message.set_name('HXC', 'HXC_HTC_INVALID_SQL');
1028: fnd_message.set_token('ERROR', SQLERRM );
1029: fnd_message.raise_error;
1030:
1031: END;
1032:

Line 1029: fnd_message.raise_error;

1025: WHEN OTHERS THEN
1026:
1027: fnd_message.set_name('HXC', 'HXC_HTC_INVALID_SQL');
1028: fnd_message.set_token('ERROR', SQLERRM );
1029: fnd_message.raise_error;
1030:
1031: END;
1032:
1033: END validate_time_category_sql;

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

1196: IF ( g_debug ) THEN
1197: hr_utility.trace('GAZ - INVALID COMBO');
1198: END IF;
1199:
1200: fnd_message.set_name('HXC', 'HXC_TC_INV_EQUAL_IS_NULL_COMBO');
1201: fnd_message.raise_error;
1202:
1203: ELSIF ( ( l_value_string = '' ) AND ( p_comps_r.equal_to = 'Y' ) )
1204: THEN

Line 1201: fnd_message.raise_error;

1197: hr_utility.trace('GAZ - INVALID COMBO');
1198: END IF;
1199:
1200: fnd_message.set_name('HXC', 'HXC_TC_INV_EQUAL_IS_NULL_COMBO');
1201: fnd_message.raise_error;
1202:
1203: ELSIF ( ( l_value_string = '' ) AND ( p_comps_r.equal_to = 'Y' ) )
1204: THEN
1205: IF ( p_an_sql )

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

1317: IF ( g_debug ) THEN
1318: hr_utility.trace('GAZ - INVALID COMBO');
1319: END IF;
1320:
1321: fnd_message.set_name('HXC', 'HXC_TC_INV_EQUAL_IS_NULL_COMBO');
1322: fnd_message.raise_error;
1323:
1324: ELSIF ( ( l_value_string = '' ) AND ( p_comps_r.equal_to = 'Y' ) )
1325: THEN

Line 1322: fnd_message.raise_error;

1318: hr_utility.trace('GAZ - INVALID COMBO');
1319: END IF;
1320:
1321: fnd_message.set_name('HXC', 'HXC_TC_INV_EQUAL_IS_NULL_COMBO');
1322: fnd_message.raise_error;
1323:
1324: ELSIF ( ( l_value_string = '' ) AND ( p_comps_r.equal_to = 'Y' ) )
1325: THEN
1326:

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

1722: IF ( l_first_context <> l_alternate_name_comps_r.context )
1723: THEN
1724: CLOSE csr_get_alternate_name_comps;
1725:
1726: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1727: fnd_message.set_token('PROCEDURE', l_proc);
1728: fnd_message.set_token('STEP','Alternate name component contexts different');
1729: fnd_message.raise_error;
1730: END IF;

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

1723: THEN
1724: CLOSE csr_get_alternate_name_comps;
1725:
1726: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1727: fnd_message.set_token('PROCEDURE', l_proc);
1728: fnd_message.set_token('STEP','Alternate name component contexts different');
1729: fnd_message.raise_error;
1730: END IF;
1731:

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

1724: CLOSE csr_get_alternate_name_comps;
1725:
1726: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1727: fnd_message.set_token('PROCEDURE', l_proc);
1728: fnd_message.set_token('STEP','Alternate name component contexts different');
1729: fnd_message.raise_error;
1730: END IF;
1731:
1732: END LOOP;

Line 1729: fnd_message.raise_error;

1725:
1726: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1727: fnd_message.set_token('PROCEDURE', l_proc);
1728: fnd_message.set_token('STEP','Alternate name component contexts different');
1729: fnd_message.raise_error;
1730: END IF;
1731:
1732: END LOOP;
1733:

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

2217: THEN
2218:
2219: IF ( NOT l_day_index_tab.EXISTS(p_blocks(l_ind).parent_building_block_id))
2220: THEN
2221: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2222: fnd_message.set_token('PROCEDURE', l_proc);
2223: fnd_message.set_token('STEP','DAY index does not exist ');
2224: fnd_message.raise_error;
2225: END IF;

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

2218:
2219: IF ( NOT l_day_index_tab.EXISTS(p_blocks(l_ind).parent_building_block_id))
2220: THEN
2221: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2222: fnd_message.set_token('PROCEDURE', l_proc);
2223: fnd_message.set_token('STEP','DAY index does not exist ');
2224: fnd_message.raise_error;
2225: END IF;
2226:

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

2219: IF ( NOT l_day_index_tab.EXISTS(p_blocks(l_ind).parent_building_block_id))
2220: THEN
2221: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2222: fnd_message.set_token('PROCEDURE', l_proc);
2223: fnd_message.set_token('STEP','DAY index does not exist ');
2224: fnd_message.raise_error;
2225: END IF;
2226:
2227: l_start_time :=

Line 2224: fnd_message.raise_error;

2220: THEN
2221: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2222: fnd_message.set_token('PROCEDURE', l_proc);
2223: fnd_message.set_token('STEP','DAY index does not exist ');
2224: fnd_message.raise_error;
2225: END IF;
2226:
2227: l_start_time :=
2228: FND_DATE.CANONICAL_TO_DATE(p_blocks(l_day_index_tab(p_blocks(l_ind).parent_building_block_id)).start_time);

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

2831: l_first_time_round := TRUE;
2832:
2833: IF ( p_rec.type <> 'MC_VS' )
2834: THEN
2835: fnd_message.set_name ('HXC','HXC_GAZ_NOT_A_VS_ROW');
2836: fnd_message.raise_error;
2837: END IF;
2838:
2839: -- first check the SQL associated with the value set has

Line 2836: fnd_message.raise_error;

2832:
2833: IF ( p_rec.type <> 'MC_VS' )
2834: THEN
2835: fnd_message.set_name ('HXC','HXC_GAZ_NOT_A_VS_ROW');
2836: fnd_message.raise_error;
2837: END IF;
2838:
2839: -- first check the SQL associated with the value set has
2840: -- no $FLEX$ OR $PROFILE$

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

2844: , l_sql_ok);
2845:
2846: IF ( NOT l_sql_ok )
2847: THEN
2848: fnd_message.set_name('HXC', 'HXC_TCC_CANNOT_USE_MPC');
2849: fnd_message.raise_error;
2850: END IF;
2851:
2852: -- get the time category operator

Line 2849: fnd_message.raise_error;

2845:
2846: IF ( NOT l_sql_ok )
2847: THEN
2848: fnd_message.set_name('HXC', 'HXC_TCC_CANNOT_USE_MPC');
2849: fnd_message.raise_error;
2850: END IF;
2851:
2852: -- get the time category operator
2853:

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

3682: ELSIF ( p_scope = 'DAY' )
3683: THEN
3684: -- not supported
3685:
3686: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3687: fnd_message.set_token('PROCEDURE', l_proc);
3688: fnd_message.set_token('STEP','DAY not supported!');
3689: fnd_message.raise_error;
3690:

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

3683: THEN
3684: -- not supported
3685:
3686: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3687: fnd_message.set_token('PROCEDURE', l_proc);
3688: fnd_message.set_token('STEP','DAY not supported!');
3689: fnd_message.raise_error;
3690:
3691: ELSIF ( p_scope = 'DETAIL' )

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

3684: -- not supported
3685:
3686: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3687: fnd_message.set_token('PROCEDURE', l_proc);
3688: fnd_message.set_token('STEP','DAY not supported!');
3689: fnd_message.raise_error;
3690:
3691: ELSIF ( p_scope = 'DETAIL' )
3692: THEN

Line 3689: fnd_message.raise_error;

3685:
3686: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
3687: fnd_message.set_token('PROCEDURE', l_proc);
3688: fnd_message.set_token('STEP','DAY not supported!');
3689: fnd_message.raise_error;
3690:
3691: ELSIF ( p_scope = 'DETAIL' )
3692: THEN
3693:

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

4117: THEN
4118: IF hxc_time_category_utils_pkg.g_time_category_id is not null then
4119: IF g_empty_time_category_tab.exists(hxc_time_category_utils_pkg.g_time_category_id) then
4120: IF NOT g_empty_time_category_tab(hxc_time_category_utils_pkg.g_time_category_id).p_status THEN
4121: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4122: fnd_message.set_token('PROCEDURE', l_proc);
4123: fnd_message.set_token('STEP','g tc id not tc tab id');
4124: fnd_message.raise_error;
4125: END IF;

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

4118: IF hxc_time_category_utils_pkg.g_time_category_id is not null then
4119: IF g_empty_time_category_tab.exists(hxc_time_category_utils_pkg.g_time_category_id) then
4120: IF NOT g_empty_time_category_tab(hxc_time_category_utils_pkg.g_time_category_id).p_status THEN
4121: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4122: fnd_message.set_token('PROCEDURE', l_proc);
4123: fnd_message.set_token('STEP','g tc id not tc tab id');
4124: fnd_message.raise_error;
4125: END IF;
4126: END IF;

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

4119: IF g_empty_time_category_tab.exists(hxc_time_category_utils_pkg.g_time_category_id) then
4120: IF NOT g_empty_time_category_tab(hxc_time_category_utils_pkg.g_time_category_id).p_status THEN
4121: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4122: fnd_message.set_token('PROCEDURE', l_proc);
4123: fnd_message.set_token('STEP','g tc id not tc tab id');
4124: fnd_message.raise_error;
4125: END IF;
4126: END IF;
4127: END IF;

Line 4124: fnd_message.raise_error;

4120: IF NOT g_empty_time_category_tab(hxc_time_category_utils_pkg.g_time_category_id).p_status THEN
4121: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4122: fnd_message.set_token('PROCEDURE', l_proc);
4123: fnd_message.set_token('STEP','g tc id not tc tab id');
4124: fnd_message.raise_error;
4125: END IF;
4126: END IF;
4127: END IF;
4128: END IF;

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

4177: , p_vs_sql => l_sql );
4178:
4179: ELSE
4180:
4181: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4182: fnd_message.set_token('PROCEDURE', l_proc);
4183: fnd_message.set_token('STEP','Invalid TYPE');
4184: fnd_message.raise_error;
4185:

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

4178:
4179: ELSE
4180:
4181: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4182: fnd_message.set_token('PROCEDURE', l_proc);
4183: fnd_message.set_token('STEP','Invalid TYPE');
4184: fnd_message.raise_error;
4185:
4186: END IF;

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

4179: ELSE
4180:
4181: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4182: fnd_message.set_token('PROCEDURE', l_proc);
4183: fnd_message.set_token('STEP','Invalid TYPE');
4184: fnd_message.raise_error;
4185:
4186: END IF;
4187:

Line 4184: fnd_message.raise_error;

4180:
4181: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4182: fnd_message.set_token('PROCEDURE', l_proc);
4183: fnd_message.set_token('STEP','Invalid TYPE');
4184: fnd_message.raise_error;
4185:
4186: END IF;
4187:
4188: validate_time_category_sql ( l_sql );

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

4481: else
4482:
4483: -- should only be table or independent value sets
4484:
4485: fnd_message.set_name(809,'HXC_GAZ_VALUE_SET_CHANGED');
4486:
4487: end if; -- validation type
4488:
4489: IF ( g_debug ) THEN

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

5338: l_proc VARCHAR2(72) := g_package||'process_tc_timecard';
5339:
5340: BEGIN
5341:
5342: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5343: fnd_message.set_token('PROCEDURE', l_proc);
5344: fnd_message.set_token('STEP','Procedure redundant use evaluate_time_category');
5345: fnd_message.raise_error;
5346:

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

5339:
5340: BEGIN
5341:
5342: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5343: fnd_message.set_token('PROCEDURE', l_proc);
5344: fnd_message.set_token('STEP','Procedure redundant use evaluate_time_category');
5345: fnd_message.raise_error;
5346:
5347: END process_tc_timecard;

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

5340: BEGIN
5341:
5342: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5343: fnd_message.set_token('PROCEDURE', l_proc);
5344: fnd_message.set_token('STEP','Procedure redundant use evaluate_time_category');
5345: fnd_message.raise_error;
5346:
5347: END process_tc_timecard;
5348:

Line 5345: fnd_message.raise_error;

5341:
5342: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5343: fnd_message.set_token('PROCEDURE', l_proc);
5344: fnd_message.set_token('STEP','Procedure redundant use evaluate_time_category');
5345: fnd_message.raise_error;
5346:
5347: END process_tc_timecard;
5348:
5349:

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

5356: l_proc varchar2(72) := g_package||'time_category_string';
5357:
5358: BEGIN
5359:
5360: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5361: fnd_message.set_token('PROCEDURE', l_proc);
5362: fnd_message.set_token('STEP','Procedure redundant use evaluate_time_category');
5363: fnd_message.raise_error;
5364:

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

5357:
5358: BEGIN
5359:
5360: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5361: fnd_message.set_token('PROCEDURE', l_proc);
5362: fnd_message.set_token('STEP','Procedure redundant use evaluate_time_category');
5363: fnd_message.raise_error;
5364:
5365: END time_category_string;

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

5358: BEGIN
5359:
5360: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5361: fnd_message.set_token('PROCEDURE', l_proc);
5362: fnd_message.set_token('STEP','Procedure redundant use evaluate_time_category');
5363: fnd_message.raise_error;
5364:
5365: END time_category_string;
5366:

Line 5363: fnd_message.raise_error;

5359:
5360: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
5361: fnd_message.set_token('PROCEDURE', l_proc);
5362: fnd_message.set_token('STEP','Procedure redundant use evaluate_time_category');
5363: fnd_message.raise_error;
5364:
5365: END time_category_string;
5366:
5367:

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

5435:
5436: IF ( l_time_category_name IS NOT NULL )
5437: THEN
5438:
5439: fnd_message.set_name('HXC', 'HXC_HTC_ALIAS_REF_INT_CHECK');
5440: fnd_message.set_token('TC_NAME', l_time_category_name );
5441: fnd_message.raise_error;
5442:
5443: END IF;

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

5436: IF ( l_time_category_name IS NOT NULL )
5437: THEN
5438:
5439: fnd_message.set_name('HXC', 'HXC_HTC_ALIAS_REF_INT_CHECK');
5440: fnd_message.set_token('TC_NAME', l_time_category_name );
5441: fnd_message.raise_error;
5442:
5443: END IF;
5444:

Line 5441: fnd_message.raise_error;

5437: THEN
5438:
5439: fnd_message.set_name('HXC', 'HXC_HTC_ALIAS_REF_INT_CHECK');
5440: fnd_message.set_token('TC_NAME', l_time_category_name );
5441: fnd_message.raise_error;
5442:
5443: END IF;
5444:
5445:

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

5489:
5490: IF ( l_time_category_name IS NOT NULL )
5491: THEN
5492:
5493: fnd_message.set_name('HXC', 'HXC_HTC_ALIAS_REF_INT_CHECK');
5494: fnd_message.set_token('TC_NAME', l_time_category_name );
5495: fnd_message.raise_error;
5496:
5497: END IF;

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

5490: IF ( l_time_category_name IS NOT NULL )
5491: THEN
5492:
5493: fnd_message.set_name('HXC', 'HXC_HTC_ALIAS_REF_INT_CHECK');
5494: fnd_message.set_token('TC_NAME', l_time_category_name );
5495: fnd_message.raise_error;
5496:
5497: END IF;
5498:

Line 5495: fnd_message.raise_error;

5491: THEN
5492:
5493: fnd_message.set_name('HXC', 'HXC_HTC_ALIAS_REF_INT_CHECK');
5494: fnd_message.set_token('TC_NAME', l_time_category_name );
5495: fnd_message.raise_error;
5496:
5497: END IF;
5498:
5499: