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.PAY_US_CITY_PKG dependencies on HR_UTILITY

Line 85: hr_utility.set_message(801, p_error_mesg);

81: p_procedure varchar2,
82: p_step number) IS
83: BEGIN
84:
85: hr_utility.set_message(801, p_error_mesg);
86: hr_utility.set_message_token('PROCEDURE', 'pyusukno.'||p_procedure);
87: hr_utility.set_message_token('STEP', p_step);
88: hr_utility.raise_error;
89:

Line 86: hr_utility.set_message_token('PROCEDURE', 'pyusukno.'||p_procedure);

82: p_step number) IS
83: BEGIN
84:
85: hr_utility.set_message(801, p_error_mesg);
86: hr_utility.set_message_token('PROCEDURE', 'pyusukno.'||p_procedure);
87: hr_utility.set_message_token('STEP', p_step);
88: hr_utility.raise_error;
89:
90: END local_error;

Line 87: hr_utility.set_message_token('STEP', p_step);

83: BEGIN
84:
85: hr_utility.set_message(801, p_error_mesg);
86: hr_utility.set_message_token('PROCEDURE', 'pyusukno.'||p_procedure);
87: hr_utility.set_message_token('STEP', p_step);
88: hr_utility.raise_error;
89:
90: END local_error;
91:

Line 88: hr_utility.raise_error;

84:
85: hr_utility.set_message(801, p_error_mesg);
86: hr_utility.set_message_token('PROCEDURE', 'pyusukno.'||p_procedure);
87: hr_utility.set_message_token('STEP', p_step);
88: hr_utility.raise_error;
89:
90: END local_error;
91:
92: --------------------------------------------------------------------------

Line 152: hr_utility.trace ('Error: Failed to find state codes.');

148: from pay_us_states
149: where state_name = l_state_Name;
150:
151: EXCEPTION WHEN no_data_found THEN
152: hr_utility.trace ('Error: Failed to find state codes.');
153: local_error ('HR_7952_ADDR_NO_STATE_CODE', 'create_new_geocode', 1);
154:
155: END ;
156:

Line 165: hr_utility.trace ('Error: Failed to find county codes.');

161: where state_code = l_st_code
162: and initcap(county_name) = l_county_Name;
163:
164: EXCEPTION WHEN no_data_found THEN
165: hr_utility.trace ('Error: Failed to find county codes.');
166: local_error ('HR_7953_ADDR_NO_COUNTY_FOUND', 'create_new_geocode', 2);
167:
168: END;
169:

Line 250: hr_utility.trace ('Error: Given city is already created.');

246: l_county_code,
247: p_city_code);
248: ELSE /* lv_new_geo = 'N' */
249: /* Display a more meaningful error here */
250: hr_utility.trace ('Error: Given city is already created.');
251: local_error ('PAY_DUPL_CITY_NAME', 'create_new_geocode', 3);
252: END IF;
253:
254: ELSE

Line 293: hr_utility.trace ('Error: Given city is already created.');

289: p_disable);
290:
291:
292: ELSE
293: hr_utility.trace ('Error: Given city is already created.');
294: local_error ('PAY_DUPL_CITY_NAME', 'create_new_geocode', 4);
295: END IF; /* SQL NOT FOUND */
296: END IF; /* not found */
297: END create_new_geocode ;

Line 350: hr_utility.trace ('County Name: '||p_co_name);

346: BEGIN
347:
348: /* force case of all passed-in parameters to match that stored in DB. */
349:
350: hr_utility.trace ('County Name: '||p_co_name);
351: hr_utility.trace ('State Name: '||p_st_name);
352:
353: l_stateName := initcap(p_st_name);
354: l_countyName := initcap(p_co_name);

Line 351: hr_utility.trace ('State Name: '||p_st_name);

347:
348: /* force case of all passed-in parameters to match that stored in DB. */
349:
350: hr_utility.trace ('County Name: '||p_co_name);
351: hr_utility.trace ('State Name: '||p_st_name);
352:
353: l_stateName := initcap(p_st_name);
354: l_countyName := initcap(p_co_name);
355: l_cityName := initcap(p_ci_name);

Line 357: hr_utility.trace ('County name after initcap :'||l_countyName);

353: l_stateName := initcap(p_st_name);
354: l_countyName := initcap(p_co_name);
355: l_cityName := initcap(p_ci_name);
356:
357: hr_utility.trace ('County name after initcap :'||l_countyName);
358: hr_utility.trace ('State name after initcap :'||l_stateName);
359: /* get state, county and city codes. */
360:
361: BEGIN

Line 358: hr_utility.trace ('State name after initcap :'||l_stateName);

354: l_countyName := initcap(p_co_name);
355: l_cityName := initcap(p_ci_name);
356:
357: hr_utility.trace ('County name after initcap :'||l_countyName);
358: hr_utility.trace ('State name after initcap :'||l_stateName);
359: /* get state, county and city codes. */
360:
361: BEGIN
362: select state_code, state_abbrev

Line 368: hr_utility.trace ('Error: Failed to find state codes.');

364: from pay_us_states
365: where state_name = l_stateName;
366:
367: EXCEPTION WHEN no_data_found THEN
368: hr_utility.trace ('Error: Failed to find state codes.');
369: local_error ('HR_7952_ADDR_NO_STATE_CODE', 'create_unkn_city', 1);
370: END;
371:
372: hr_utility.trace ('selected state code: ' || l_st_code);

Line 372: hr_utility.trace ('selected state code: ' || l_st_code);

368: hr_utility.trace ('Error: Failed to find state codes.');
369: local_error ('HR_7952_ADDR_NO_STATE_CODE', 'create_unkn_city', 1);
370: END;
371:
372: hr_utility.trace ('selected state code: ' || l_st_code);
373: hr_utility.trace ('l_countyName: ' || l_countyName);
374:
375: BEGIN
376: select county_code

Line 373: hr_utility.trace ('l_countyName: ' || l_countyName);

369: local_error ('HR_7952_ADDR_NO_STATE_CODE', 'create_unkn_city', 1);
370: END;
371:
372: hr_utility.trace ('selected state code: ' || l_st_code);
373: hr_utility.trace ('l_countyName: ' || l_countyName);
374:
375: BEGIN
376: select county_code
377: into l_co_code

Line 383: hr_utility.trace ('Error: Failed to find county codes.');

379: where state_code = l_st_code
380: and initcap(county_name) = l_countyName;
381:
382: EXCEPTION WHEN no_data_found THEN
383: hr_utility.trace ('Error: Failed to find county codes.');
384: local_error ('HR_7953_ADDR_NO_COUNTY_FOUND', 'create_unkn_city', 2);
385: END;
386:
387: hr_utility.trace ('selected county code: ' || l_co_code);

Line 387: hr_utility.trace ('selected county code: ' || l_co_code);

383: hr_utility.trace ('Error: Failed to find county codes.');
384: local_error ('HR_7953_ADDR_NO_COUNTY_FOUND', 'create_unkn_city', 2);
385: END;
386:
387: hr_utility.trace ('selected county code: ' || l_co_code);
388:
389: /* see if this city is unknown. */
390:
391: if hr_us_ff_udfs.addr_val(l_st_abbrev, l_countyName, l_cityName,

Line 418: hr_utility.trace ('Number of unknown cities '||l_n_ci_code);

414: from pay_us_city_geocodes
415: where state_code = l_st_code and county_code = l_co_code
416: and city_code like 'U%';
417:
418: hr_utility.trace ('Number of unknown cities '||l_n_ci_code);
419:
420: if l_n_ci_code <= 0 then
421: l_ci_code := 'U000';
422: hr_utility.trace ('Initial city code is:'||l_ci_code);

Line 422: hr_utility.trace ('Initial city code is:'||l_ci_code);

418: hr_utility.trace ('Number of unknown cities '||l_n_ci_code);
419:
420: if l_n_ci_code <= 0 then
421: l_ci_code := 'U000';
422: hr_utility.trace ('Initial city code is:'||l_ci_code);
423: else
424: /*
425: use explicit cursor to step through each of the unknown
426: city codes to find the latest city code.

Line 435: hr_utility.trace ('Max city code is:'||

431: l_max_ci_code then
432:
433: l_max_ci_code :=
434: fnd_number.canonical_to_number(substr(l_city_rec.city_code,2,3));
435: hr_utility.trace ('Max city code is:'||
436: l_city_rec.city_code);
437:
438: end if;
439: end loop;

Line 449: hr_utility.trace ('Final city code is:'||l_ci_code);

445: else
446: l_ci_code := 'U'||to_char(l_max_ci_code + 1);
447: end if;
448:
449: hr_utility.trace ('Final city code is:'||l_ci_code);
450: end if;
451: p_ci_code := l_ci_code;
452:
453: insert into pay_us_city_geocodes

Line 457: hr_utility.trace ('Inserted a geocode.');

453: insert into pay_us_city_geocodes
454: (state_code, county_code, city_code)
455: values
456: (l_st_code, l_co_code, l_ci_code);
457: hr_utility.trace ('Inserted a geocode.');
458:
459: insert into pay_us_zip_codes
460: (zip_start, zip_end, state_code, county_code, city_code)
461: values

Line 463: hr_utility.trace ('Inserted a zip code.');

459: insert into pay_us_zip_codes
460: (zip_start, zip_end, state_code, county_code, city_code)
461: values
462: (p_zi_start, p_zi_end, l_st_code, l_co_code, l_ci_code);
463: hr_utility.trace ('Inserted a zip code.');
464:
465: insert into pay_us_city_names
466: (city_name, state_code, county_code, city_code, primary_flag, disable)
467: values

Line 469: hr_utility.trace ('Inserted an unknown city.');

465: insert into pay_us_city_names
466: (city_name, state_code, county_code, city_code, primary_flag, disable)
467: values
468: (l_cityName, l_st_code, l_co_code, l_ci_code, 'N', p_disable);
469: hr_utility.trace ('Inserted an unknown city.');
470:
471: elsif (l_n_ci_name = 1) then
472: hr_utility.trace ('Error: Given city is already created.');
473: local_error ('HR_7954_ADDR_NOT_UNKNOWN_CITY',

Line 472: hr_utility.trace ('Error: Given city is already created.');

468: (l_cityName, l_st_code, l_co_code, l_ci_code, 'N', p_disable);
469: hr_utility.trace ('Inserted an unknown city.');
470:
471: elsif (l_n_ci_name = 1) then
472: hr_utility.trace ('Error: Given city is already created.');
473: local_error ('HR_7954_ADDR_NOT_UNKNOWN_CITY',
474: 'create_unkn_city', 3);
475: else
476: /* a new zip range for an existing city has been entered */

Line 505: hr_utility.trace ('Inserted a new zip code for an existing city.');

501: INSERT INTO pay_us_zip_codes
502: (ZIP_START, ZIP_END, STATE_CODE, COUNTY_CODE, CITY_CODE)
503: VALUES
504: (l_zip_start,l_zip_end,l_st_code,l_co_code,l_ci_code);
505: hr_utility.trace ('Inserted a new zip code for an existing city.');
506:
507: p_ci_code := l_ci_code;
508: p_zi_end := l_zip_end;
509: p_zi_start := l_zip_start;

Line 523: hr_utility.trace ('Error: Given city is already created.');

519: AND state_code = l_st_code;
520:
521: end if;
522: else
523: hr_utility.trace ('Error: Given city is already created.');
524: local_error ('HR_7954_ADDR_NOT_UNKNOWN_CITY', 'create_unkn_city', 4);
525: end if;
526:
527: END create_unkn_city;

Line 579: /* hr_utility.trace_on('Y','CACITY');*/

575:
576: --
577: BEGIN
578: --
579: /* hr_utility.trace_on('Y','CACITY');*/
580: l_zip_start := p_zip_start;
581: l_zip_end := p_zip_end;
582:
583: create_unkn_city (p_city_code,

Line 595: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

591: OPEN C;
592: FETCH C INTO p_zprowid;
593: IF (C%NOTFOUND) THEN
594: CLOSE C;
595: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
596: hr_utility.set_message_token('PROCEDURE',
597: 'pay_us_city_pkg.Insert_Row');
598: hr_utility.set_message_token('STEP','1');
599: hr_utility.raise_error;

Line 596: hr_utility.set_message_token('PROCEDURE',

592: FETCH C INTO p_zprowid;
593: IF (C%NOTFOUND) THEN
594: CLOSE C;
595: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
596: hr_utility.set_message_token('PROCEDURE',
597: 'pay_us_city_pkg.Insert_Row');
598: hr_utility.set_message_token('STEP','1');
599: hr_utility.raise_error;
600: END if;

Line 598: hr_utility.set_message_token('STEP','1');

594: CLOSE C;
595: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
596: hr_utility.set_message_token('PROCEDURE',
597: 'pay_us_city_pkg.Insert_Row');
598: hr_utility.set_message_token('STEP','1');
599: hr_utility.raise_error;
600: END if;
601:
602: --

Line 599: hr_utility.raise_error;

595: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
596: hr_utility.set_message_token('PROCEDURE',
597: 'pay_us_city_pkg.Insert_Row');
598: hr_utility.set_message_token('STEP','1');
599: hr_utility.raise_error;
600: END if;
601:
602: --
603: OPEN C2;

Line 607: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

603: OPEN C2;
604: FETCH C2 INTO p_cirowid;
605: IF (C2%NOTFOUND) THEN
606: CLOSE C2;
607: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
608: hr_utility.set_message_token('PROCEDURE',
609: 'pay_us_city_pkg.Insert_Row');
610: hr_utility.set_message_token('STEP','2');
611: hr_utility.raise_error;

Line 608: hr_utility.set_message_token('PROCEDURE',

604: FETCH C2 INTO p_cirowid;
605: IF (C2%NOTFOUND) THEN
606: CLOSE C2;
607: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
608: hr_utility.set_message_token('PROCEDURE',
609: 'pay_us_city_pkg.Insert_Row');
610: hr_utility.set_message_token('STEP','2');
611: hr_utility.raise_error;
612: END if;

Line 610: hr_utility.set_message_token('STEP','2');

606: CLOSE C2;
607: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
608: hr_utility.set_message_token('PROCEDURE',
609: 'pay_us_city_pkg.Insert_Row');
610: hr_utility.set_message_token('STEP','2');
611: hr_utility.raise_error;
612: END if;
613:
614: --

Line 611: hr_utility.raise_error;

607: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
608: hr_utility.set_message_token('PROCEDURE',
609: 'pay_us_city_pkg.Insert_Row');
610: hr_utility.set_message_token('STEP','2');
611: hr_utility.raise_error;
612: END if;
613:
614: --
615: OPEN C3;

Line 619: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

615: OPEN C3;
616: FETCH C3 INTO p_gerowid;
617: IF (C3%NOTFOUND) THEN
618: CLOSE C3;
619: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
620: hr_utility.set_message_token('PROCEDURE',
621: 'pay_us_city_pkg.Insert_Row');
622: hr_utility.set_message_token('STEP','3');
623: hr_utility.raise_error;

Line 620: hr_utility.set_message_token('PROCEDURE',

616: FETCH C3 INTO p_gerowid;
617: IF (C3%NOTFOUND) THEN
618: CLOSE C3;
619: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
620: hr_utility.set_message_token('PROCEDURE',
621: 'pay_us_city_pkg.Insert_Row');
622: hr_utility.set_message_token('STEP','3');
623: hr_utility.raise_error;
624: END if;

Line 622: hr_utility.set_message_token('STEP','3');

618: CLOSE C3;
619: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
620: hr_utility.set_message_token('PROCEDURE',
621: 'pay_us_city_pkg.Insert_Row');
622: hr_utility.set_message_token('STEP','3');
623: hr_utility.raise_error;
624: END if;
625:
626: /* hr_utility.trace_off; */

Line 623: hr_utility.raise_error;

619: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
620: hr_utility.set_message_token('PROCEDURE',
621: 'pay_us_city_pkg.Insert_Row');
622: hr_utility.set_message_token('STEP','3');
623: hr_utility.raise_error;
624: END if;
625:
626: /* hr_utility.trace_off; */
627: END Insert_Row;

Line 626: /* hr_utility.trace_off; */

622: hr_utility.set_message_token('STEP','3');
623: hr_utility.raise_error;
624: END if;
625:
626: /* hr_utility.trace_off; */
627: END Insert_Row;
628:
629: -----------------------------------------------------------------------------
630: -- Name --

Line 672: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

668: OPEN C;
669: FETCH C INTO l_recinfo;
670: if (C%NOTFOUND) then
671: CLOSE C;
672: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
673: hr_utility.set_message_token('PROCEDURE',
674: 'pay_us_city_pkg.lock_row');
675: hr_utility.set_message_token('STEP','1');
676: hr_utility.raise_error;

Line 673: hr_utility.set_message_token('PROCEDURE',

669: FETCH C INTO l_recinfo;
670: if (C%NOTFOUND) then
671: CLOSE C;
672: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
673: hr_utility.set_message_token('PROCEDURE',
674: 'pay_us_city_pkg.lock_row');
675: hr_utility.set_message_token('STEP','1');
676: hr_utility.raise_error;
677: end if;

Line 675: hr_utility.set_message_token('STEP','1');

671: CLOSE C;
672: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
673: hr_utility.set_message_token('PROCEDURE',
674: 'pay_us_city_pkg.lock_row');
675: hr_utility.set_message_token('STEP','1');
676: hr_utility.raise_error;
677: end if;
678: --
679: OPEN C2;

Line 676: hr_utility.raise_error;

672: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
673: hr_utility.set_message_token('PROCEDURE',
674: 'pay_us_city_pkg.lock_row');
675: hr_utility.set_message_token('STEP','1');
676: hr_utility.raise_error;
677: end if;
678: --
679: OPEN C2;
680: FETCH C2 INTO l_recinfo2;

Line 683: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

679: OPEN C2;
680: FETCH C2 INTO l_recinfo2;
681: if (C2%NOTFOUND) then
682: CLOSE C2;
683: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
684: hr_utility.set_message_token('PROCEDURE',
685: 'pay_us_city_pkg.lock_row');
686: hr_utility.set_message_token('STEP','2');
687: hr_utility.raise_error;

Line 684: hr_utility.set_message_token('PROCEDURE',

680: FETCH C2 INTO l_recinfo2;
681: if (C2%NOTFOUND) then
682: CLOSE C2;
683: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
684: hr_utility.set_message_token('PROCEDURE',
685: 'pay_us_city_pkg.lock_row');
686: hr_utility.set_message_token('STEP','2');
687: hr_utility.raise_error;
688: end if;

Line 686: hr_utility.set_message_token('STEP','2');

682: CLOSE C2;
683: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
684: hr_utility.set_message_token('PROCEDURE',
685: 'pay_us_city_pkg.lock_row');
686: hr_utility.set_message_token('STEP','2');
687: hr_utility.raise_error;
688: end if;
689: --
690: OPEN C3;

Line 687: hr_utility.raise_error;

683: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
684: hr_utility.set_message_token('PROCEDURE',
685: 'pay_us_city_pkg.lock_row');
686: hr_utility.set_message_token('STEP','2');
687: hr_utility.raise_error;
688: end if;
689: --
690: OPEN C3;
691: FETCH C3 INTO l_recinfo3;

Line 694: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

690: OPEN C3;
691: FETCH C3 INTO l_recinfo3;
692: if (C3%NOTFOUND) then
693: CLOSE C3;
694: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
695: hr_utility.set_message_token('PROCEDURE',
696: 'pay_us_city_pkg.lock_row');
697: hr_utility.set_message_token('STEP','3');
698: hr_utility.raise_error;

Line 695: hr_utility.set_message_token('PROCEDURE',

691: FETCH C3 INTO l_recinfo3;
692: if (C3%NOTFOUND) then
693: CLOSE C3;
694: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
695: hr_utility.set_message_token('PROCEDURE',
696: 'pay_us_city_pkg.lock_row');
697: hr_utility.set_message_token('STEP','3');
698: hr_utility.raise_error;
699: end if;

Line 697: hr_utility.set_message_token('STEP','3');

693: CLOSE C3;
694: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
695: hr_utility.set_message_token('PROCEDURE',
696: 'pay_us_city_pkg.lock_row');
697: hr_utility.set_message_token('STEP','3');
698: hr_utility.raise_error;
699: end if;
700:
701: --

Line 698: hr_utility.raise_error;

694: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
695: hr_utility.set_message_token('PROCEDURE',
696: 'pay_us_city_pkg.lock_row');
697: hr_utility.set_message_token('STEP','3');
698: hr_utility.raise_error;
699: end if;
700:
701: --
702: -- Remove trailing spaces.

Line 763: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

759: zip_end = p_zip_end
760: WHERE rowid = p_zprowid;
761: --
762: if (SQL%NOTFOUND) then
763: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
764: hr_utility.set_message_token('PROCEDURE',
765: 'pay_us_new_cities_pkg.update_row');
766: hr_utility.set_message_token('STEP','1');
767: hr_utility.raise_error;

Line 764: hr_utility.set_message_token('PROCEDURE',

760: WHERE rowid = p_zprowid;
761: --
762: if (SQL%NOTFOUND) then
763: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
764: hr_utility.set_message_token('PROCEDURE',
765: 'pay_us_new_cities_pkg.update_row');
766: hr_utility.set_message_token('STEP','1');
767: hr_utility.raise_error;
768: end if;

Line 766: hr_utility.set_message_token('STEP','1');

762: if (SQL%NOTFOUND) then
763: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
764: hr_utility.set_message_token('PROCEDURE',
765: 'pay_us_new_cities_pkg.update_row');
766: hr_utility.set_message_token('STEP','1');
767: hr_utility.raise_error;
768: end if;
769: --
770: UPDATE pay_us_city_names

Line 767: hr_utility.raise_error;

763: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
764: hr_utility.set_message_token('PROCEDURE',
765: 'pay_us_new_cities_pkg.update_row');
766: hr_utility.set_message_token('STEP','1');
767: hr_utility.raise_error;
768: end if;
769: --
770: UPDATE pay_us_city_names
771: SET disable = p_disable

Line 778: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

774: AND city_code = p_city_code
775: AND city_name = p_city_name;
776: --
777: if (SQL%NOTFOUND) then
778: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
779: hr_utility.set_message_token('PROCEDURE',
780: 'pay_us_new_cities_pkg.update_row');
781: hr_utility.set_message_token('STEP','1');
782: hr_utility.raise_error;

Line 779: hr_utility.set_message_token('PROCEDURE',

775: AND city_name = p_city_name;
776: --
777: if (SQL%NOTFOUND) then
778: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
779: hr_utility.set_message_token('PROCEDURE',
780: 'pay_us_new_cities_pkg.update_row');
781: hr_utility.set_message_token('STEP','1');
782: hr_utility.raise_error;
783: end if;

Line 781: hr_utility.set_message_token('STEP','1');

777: if (SQL%NOTFOUND) then
778: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
779: hr_utility.set_message_token('PROCEDURE',
780: 'pay_us_new_cities_pkg.update_row');
781: hr_utility.set_message_token('STEP','1');
782: hr_utility.raise_error;
783: end if;
784: --
785: END Update_Row;

Line 782: hr_utility.raise_error;

778: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
779: hr_utility.set_message_token('PROCEDURE',
780: 'pay_us_new_cities_pkg.update_row');
781: hr_utility.set_message_token('STEP','1');
782: hr_utility.raise_error;
783: end if;
784: --
785: END Update_Row;
786: --

Line 839: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

835:
836: END IF;
837: --
838: if (SQL%NOTFOUND) then
839: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
840: hr_utility.set_message_token('PROCEDURE',
841: 'pay_us_city_pkg.delete_row');
842: hr_utility.set_message_token('STEP','3');
843: hr_utility.raise_error;

Line 840: hr_utility.set_message_token('PROCEDURE',

836: END IF;
837: --
838: if (SQL%NOTFOUND) then
839: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
840: hr_utility.set_message_token('PROCEDURE',
841: 'pay_us_city_pkg.delete_row');
842: hr_utility.set_message_token('STEP','3');
843: hr_utility.raise_error;
844: end if;

Line 842: hr_utility.set_message_token('STEP','3');

838: if (SQL%NOTFOUND) then
839: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
840: hr_utility.set_message_token('PROCEDURE',
841: 'pay_us_city_pkg.delete_row');
842: hr_utility.set_message_token('STEP','3');
843: hr_utility.raise_error;
844: end if;
845: END Delete_Row;
846: --

Line 843: hr_utility.raise_error;

839: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
840: hr_utility.set_message_token('PROCEDURE',
841: 'pay_us_city_pkg.delete_row');
842: hr_utility.set_message_token('STEP','3');
843: hr_utility.raise_error;
844: end if;
845: END Delete_Row;
846: --
847: -- The Next procedure is used for checking and validating data

Line 913: hr_utility.set_message (801,'HR_6153_all_PROCEDURE_FAIL');

909: FETCH C1 INTO l_recinfo1;
910: IF (C1%FOUND) THEN
911: /* rosie monge 18-mar-03 2844658 */
912: /*
913: hr_utility.set_message (801,'HR_6153_all_PROCEDURE_FAIL');
914: hr_utility.set_message_token ('PROCEDURE',
915: 'pay_us_chk_addr_pkg.chk_city_in_addr');
916: hr_utility.set_message_token ('STEP', '1');
917: */

Line 914: hr_utility.set_message_token ('PROCEDURE',

910: IF (C1%FOUND) THEN
911: /* rosie monge 18-mar-03 2844658 */
912: /*
913: hr_utility.set_message (801,'HR_6153_all_PROCEDURE_FAIL');
914: hr_utility.set_message_token ('PROCEDURE',
915: 'pay_us_chk_addr_pkg.chk_city_in_addr');
916: hr_utility.set_message_token ('STEP', '1');
917: */
918: hr_utility.set_message(801,'PAY_74153_CITY_CANNOT_DISABLE');

Line 916: hr_utility.set_message_token ('STEP', '1');

912: /*
913: hr_utility.set_message (801,'HR_6153_all_PROCEDURE_FAIL');
914: hr_utility.set_message_token ('PROCEDURE',
915: 'pay_us_chk_addr_pkg.chk_city_in_addr');
916: hr_utility.set_message_token ('STEP', '1');
917: */
918: hr_utility.set_message(801,'PAY_74153_CITY_CANNOT_DISABLE');
919: hr_utility.raise_error;
920: END IF;

Line 918: hr_utility.set_message(801,'PAY_74153_CITY_CANNOT_DISABLE');

914: hr_utility.set_message_token ('PROCEDURE',
915: 'pay_us_chk_addr_pkg.chk_city_in_addr');
916: hr_utility.set_message_token ('STEP', '1');
917: */
918: hr_utility.set_message(801,'PAY_74153_CITY_CANNOT_DISABLE');
919: hr_utility.raise_error;
920: END IF;
921: CLOSE C1;
922:

Line 919: hr_utility.raise_error;

915: 'pay_us_chk_addr_pkg.chk_city_in_addr');
916: hr_utility.set_message_token ('STEP', '1');
917: */
918: hr_utility.set_message(801,'PAY_74153_CITY_CANNOT_DISABLE');
919: hr_utility.raise_error;
920: END IF;
921: CLOSE C1;
922:
923: ELSE

Line 929: hr_utility.set_message (801,'HR_6153_all_PROCEDURE_FAIL');

925: FETCH C2 INTO l_recinfo2;
926: IF (C2%FOUND) THEN
927: /* rmonge fix for bug 2844658 */
928: /*
929: hr_utility.set_message (801,'HR_6153_all_PROCEDURE_FAIL');
930: hr_utility.set_message_token ('PROCEDURE',
931: 'pay_us_chk_addr_pkg.chk_city_in_addr');
932: hr_utility.set_message_token ('STEP', '1');
933: */

Line 930: hr_utility.set_message_token ('PROCEDURE',

926: IF (C2%FOUND) THEN
927: /* rmonge fix for bug 2844658 */
928: /*
929: hr_utility.set_message (801,'HR_6153_all_PROCEDURE_FAIL');
930: hr_utility.set_message_token ('PROCEDURE',
931: 'pay_us_chk_addr_pkg.chk_city_in_addr');
932: hr_utility.set_message_token ('STEP', '1');
933: */
934: hr_utility.set_message(801,'PAY_74153_CITY_CANNOT_DISABLE');

Line 932: hr_utility.set_message_token ('STEP', '1');

928: /*
929: hr_utility.set_message (801,'HR_6153_all_PROCEDURE_FAIL');
930: hr_utility.set_message_token ('PROCEDURE',
931: 'pay_us_chk_addr_pkg.chk_city_in_addr');
932: hr_utility.set_message_token ('STEP', '1');
933: */
934: hr_utility.set_message(801,'PAY_74153_CITY_CANNOT_DISABLE');
935: hr_utility.raise_error;
936: END IF;

Line 934: hr_utility.set_message(801,'PAY_74153_CITY_CANNOT_DISABLE');

930: hr_utility.set_message_token ('PROCEDURE',
931: 'pay_us_chk_addr_pkg.chk_city_in_addr');
932: hr_utility.set_message_token ('STEP', '1');
933: */
934: hr_utility.set_message(801,'PAY_74153_CITY_CANNOT_DISABLE');
935: hr_utility.raise_error;
936: END IF;
937: CLOSE C2;
938:

Line 935: hr_utility.raise_error;

931: 'pay_us_chk_addr_pkg.chk_city_in_addr');
932: hr_utility.set_message_token ('STEP', '1');
933: */
934: hr_utility.set_message(801,'PAY_74153_CITY_CANNOT_DISABLE');
935: hr_utility.raise_error;
936: END IF;
937: CLOSE C2;
938:
939: END IF;