13: --
14: hr_utility.set_location('Entering:'|| l_proc, 10);
15:
16: if p_argument is null then
17: fnd_message.set_name( 'PAY', 'PAY_75178_NO_DATA' );
18: fnd_message.set_token('VALUE1' , l_proc);
19: fnd_message.set_token('VALUE2' , p_column) ;
20: fnd_message.raise_error;
21: end if;
14: hr_utility.set_location('Entering:'|| l_proc, 10);
15:
16: if p_argument is null then
17: fnd_message.set_name( 'PAY', 'PAY_75178_NO_DATA' );
18: fnd_message.set_token('VALUE1' , l_proc);
19: fnd_message.set_token('VALUE2' , p_column) ;
20: fnd_message.raise_error;
21: end if;
22:
15:
16: if p_argument is null then
17: fnd_message.set_name( 'PAY', 'PAY_75178_NO_DATA' );
18: fnd_message.set_token('VALUE1' , l_proc);
19: fnd_message.set_token('VALUE2' , p_column) ;
20: fnd_message.raise_error;
21: end if;
22:
23: hr_utility.set_location(' Leaving:'|| l_proc, 20);
16: if p_argument is null then
17: fnd_message.set_name( 'PAY', 'PAY_75178_NO_DATA' );
18: fnd_message.set_token('VALUE1' , l_proc);
19: fnd_message.set_token('VALUE2' , p_column) ;
20: fnd_message.raise_error;
21: end if;
22:
23: hr_utility.set_location(' Leaving:'|| l_proc, 20);
24: --
62: fetch csr_exists into l_upgrade_definition_id;
63:
64: IF csr_exists%NOTFOUND THEN
65: CLOSE csr_exists;
66: fnd_message.set_name('PAY', 'PAY_34863_SHORT_NAME_NOT_EXIST');
67: fnd_message.raise_error;
68: END IF;
69: CLOSE csr_exists;
70:
63:
64: IF csr_exists%NOTFOUND THEN
65: CLOSE csr_exists;
66: fnd_message.set_name('PAY', 'PAY_34863_SHORT_NAME_NOT_EXIST');
67: fnd_message.raise_error;
68: END IF;
69: CLOSE csr_exists;
70:
71: insert into PAY_UPGRADE_PARAMETERS (
191: fetch csr_existing_upd_def into l_upgrade_def_id;
192:
193: IF csr_existing_upd_def%NOTFOUND THEN
194: CLOSE csr_existing_upd_def;
195: fnd_message.set_name('PAY', 'PAY_34863_SHORT_NAME_NOT_EXIST');
196: fnd_message.raise_error;
197: END IF;
198: CLOSE csr_existing_upd_def;
199:
192:
193: IF csr_existing_upd_def%NOTFOUND THEN
194: CLOSE csr_existing_upd_def;
195: fnd_message.set_name('PAY', 'PAY_34863_SHORT_NAME_NOT_EXIST');
196: fnd_message.raise_error;
197: END IF;
198: CLOSE csr_existing_upd_def;
199:
200: open csr_existing_upd_param(l_upgrade_def_id);