21:
22: if csr_unique_name%found then
23:
24: close csr_unique_name;
25: fnd_message.set_name( 'PAY', 'PAY_33187_SHORT_NAME_EXISTS' );
26: fnd_message.raise_error;
27:
28: end if;
29: close csr_unique_name;
22: if csr_unique_name%found then
23:
24: close csr_unique_name;
25: fnd_message.set_name( 'PAY', 'PAY_33187_SHORT_NAME_EXISTS' );
26: fnd_message.raise_error;
27:
28: end if;
29: close csr_unique_name;
30:
50: ,p_lookup_type => p_lookup_type
51: ,p_lookup_code => p_lookup_code
52: )
53: then
54: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
55: fnd_message.set_token('LOOKUP_TYPE', p_lookup_type);
56: fnd_message.set_token('COLUMN', p_column);
57: fnd_message.raise_error;
58: end if;
51: ,p_lookup_code => p_lookup_code
52: )
53: then
54: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
55: fnd_message.set_token('LOOKUP_TYPE', p_lookup_type);
56: fnd_message.set_token('COLUMN', p_column);
57: fnd_message.raise_error;
58: end if;
59:
52: )
53: then
54: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
55: fnd_message.set_token('LOOKUP_TYPE', p_lookup_type);
56: fnd_message.set_token('COLUMN', p_column);
57: fnd_message.raise_error;
58: end if;
59:
60: hr_utility.set_location('Leaving:'|| l_proc, 20);
53: then
54: fnd_message.set_name('PAY', 'HR_52966_INVALID_LOOKUP');
55: fnd_message.set_token('LOOKUP_TYPE', p_lookup_type);
56: fnd_message.set_token('COLUMN', p_column);
57: fnd_message.raise_error;
58: end if;
59:
60: hr_utility.set_location('Leaving:'|| l_proc, 20);
61: --
70: --
71: hr_utility.set_location('Entering:'|| l_proc, 10);
72:
73: if p_argument is null then
74: fnd_message.set_name( 'PAY', 'PAY_75178_NO_DATA' );
75: fnd_message.set_token('VALUE1' , l_proc);
76: fnd_message.set_token('VALUE2' , p_column) ;
77: fnd_message.raise_error;
78: end if;
71: hr_utility.set_location('Entering:'|| l_proc, 10);
72:
73: if p_argument is null then
74: fnd_message.set_name( 'PAY', 'PAY_75178_NO_DATA' );
75: fnd_message.set_token('VALUE1' , l_proc);
76: fnd_message.set_token('VALUE2' , p_column) ;
77: fnd_message.raise_error;
78: end if;
79:
72:
73: if p_argument is null then
74: fnd_message.set_name( 'PAY', 'PAY_75178_NO_DATA' );
75: fnd_message.set_token('VALUE1' , l_proc);
76: fnd_message.set_token('VALUE2' , p_column) ;
77: fnd_message.raise_error;
78: end if;
79:
80: hr_utility.set_location(' Leaving:'|| l_proc, 20);
73: if p_argument is null then
74: fnd_message.set_name( 'PAY', 'PAY_75178_NO_DATA' );
75: fnd_message.set_token('VALUE1' , l_proc);
76: fnd_message.set_token('VALUE2' , p_column) ;
77: fnd_message.raise_error;
78: end if;
79:
80: hr_utility.set_location(' Leaving:'|| l_proc, 20);
81: --
100: fetch csr_legislation_code into l_exists ;
101:
102: if csr_legislation_code%notfound then
103: close csr_legislation_code;
104: fnd_message.set_name('PAY', 'PAY_33177_LEG_CODE_INVALID');
105: fnd_message.raise_error;
106: end if;
107: close csr_legislation_code;
108:
101:
102: if csr_legislation_code%notfound then
103: close csr_legislation_code;
104: fnd_message.set_name('PAY', 'PAY_33177_LEG_CODE_INVALID');
105: fnd_message.raise_error;
106: end if;
107: close csr_legislation_code;
108:
109: hr_utility.set_location(' Leaving:'|| l_proc, 20);
129: fetch csr_delete into l_exists ;
130:
131: if csr_delete%found then
132: close csr_delete;
133: fnd_message.set_name('PAY', 'PAY_33188_DELETION_NOT_ALLOWED');
134: fnd_message.raise_error;
135: end if;
136: close csr_delete;
137:
130:
131: if csr_delete%found then
132: close csr_delete;
133: fnd_message.set_name('PAY', 'PAY_33188_DELETION_NOT_ALLOWED');
134: fnd_message.raise_error;
135: end if;
136: close csr_delete;
137:
138: hr_utility.set_location(' Leaving:'|| l_proc, 20);
232:
233: -- Upgrade Level cannot be Global when legsislation code is not null.
234:
235: if p_legislation_code is not null and p_upgrade_level = 'G' then
236: fnd_message.set_name('PAY', 'PAY_33189_GLOBAL_LEG_UPGDEF');
237: fnd_message.raise_error;
238: end if;
239:
240: -- Legislatively Enabled must be 'N' when legislation code is not null.
233: -- Upgrade Level cannot be Global when legsislation code is not null.
234:
235: if p_legislation_code is not null and p_upgrade_level = 'G' then
236: fnd_message.set_name('PAY', 'PAY_33189_GLOBAL_LEG_UPGDEF');
237: fnd_message.raise_error;
238: end if;
239:
240: -- Legislatively Enabled must be 'N' when legislation code is not null.
241:
239:
240: -- Legislatively Enabled must be 'N' when legislation code is not null.
241:
242: if p_legislation_code is not null and p_legislatively_enabled <> 'N' then
243: fnd_message.set_name('PAY', 'PAY_33190_ENABLE_LEG_UPGDEF');
244: fnd_message.raise_error;
245: end if;
246:
247: open csr_nextseq;
240: -- Legislatively Enabled must be 'N' when legislation code is not null.
241:
242: if p_legislation_code is not null and p_legislatively_enabled <> 'N' then
243: fnd_message.set_name('PAY', 'PAY_33190_ENABLE_LEG_UPGDEF');
244: fnd_message.raise_error;
245: end if;
246:
247: open csr_nextseq;
248: fetch csr_nextseq into l_upgrade_definition_id;
482: open csr_lck;
483: fetch csr_lck into recinfo;
484: if (csr_lck%notfound) then
485: close csr_lck;
486: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
487: app_exception.raise_exception;
488: end if;
489: close csr_lck;
490:
505:
506: ) then
507: null;
508: else
509: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
510: app_exception.raise_exception;
511: end if;
512:
513: for tlinfo in csr_lck_tl loop
516: and (tlinfo.name = p_name)
517: ) then
518: null;
519: else
520: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
521: app_exception.raise_exception;
522: end if;
523: end if;
524: end loop;
699: FETCH C_APPL INTO l_appl_id;
700:
701: IF C_APPL%NOTFOUND THEN
702: CLOSE C_APPL;
703: fnd_message.set_name('FND', 'AFDICT- ARG APPL');
704: fnd_message.set_token('APPL', P_OWNER_APPL_SHORT_NAME);
705: fnd_message.raise_error;
706: END IF;
707: CLOSE C_APPL;
700:
701: IF C_APPL%NOTFOUND THEN
702: CLOSE C_APPL;
703: fnd_message.set_name('FND', 'AFDICT- ARG APPL');
704: fnd_message.set_token('APPL', P_OWNER_APPL_SHORT_NAME);
705: fnd_message.raise_error;
706: END IF;
707: CLOSE C_APPL;
708: END IF;
701: IF C_APPL%NOTFOUND THEN
702: CLOSE C_APPL;
703: fnd_message.set_name('FND', 'AFDICT- ARG APPL');
704: fnd_message.set_token('APPL', P_OWNER_APPL_SHORT_NAME);
705: fnd_message.raise_error;
706: END IF;
707: CLOSE C_APPL;
708: END IF;
709: