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_CA_CITY_PKG dependencies on HR_UTILITY

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

31: p_procedure varchar2,
32: p_step number) IS
33: BEGIN
34:
35: hr_utility.set_message(801, p_error_mesg);
36: hr_utility.set_message_token('PROCEDURE', 'pyusukno.'||p_procedure);
37: hr_utility.set_message_token('STEP', p_step);
38: hr_utility.raise_error;
39:

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

32: p_step number) IS
33: BEGIN
34:
35: hr_utility.set_message(801, p_error_mesg);
36: hr_utility.set_message_token('PROCEDURE', 'pyusukno.'||p_procedure);
37: hr_utility.set_message_token('STEP', p_step);
38: hr_utility.raise_error;
39:
40: END local_error;

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

33: BEGIN
34:
35: hr_utility.set_message(801, p_error_mesg);
36: hr_utility.set_message_token('PROCEDURE', 'pyusukno.'||p_procedure);
37: hr_utility.set_message_token('STEP', p_step);
38: hr_utility.raise_error;
39:
40: END local_error;
41:

Line 38: hr_utility.raise_error;

34:
35: hr_utility.set_message(801, p_error_mesg);
36: hr_utility.set_message_token('PROCEDURE', 'pyusukno.'||p_procedure);
37: hr_utility.set_message_token('STEP', p_step);
38: hr_utility.raise_error;
39:
40: END local_error;
41:
42: --------------------------------------------------------------------------

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

98: from pay_us_states
99: where state_name = l_state_Name;
100:
101: EXCEPTION WHEN no_data_found THEN
102: hr_utility.trace ('Error: Failed to find state codes.');
103: local_error ('HR_7952_ADDR_NO_STATE_CODE', 'create_new_geocode', 1);
104:
105: END ;
106:

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

111: where state_code = l_st_code
112: and initcap(county_name) = l_county_Name;
113:
114: EXCEPTION WHEN no_data_found THEN
115: hr_utility.trace ('Error: Failed to find county codes.');
116: local_error ('HR_7953_ADDR_NO_COUNTY_FOUND', 'create_new_geocode', 2);
117:
118: END;
119:

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

196: l_county_code,
197: p_city_code);
198: ELSE /* lv_new_geo = 'N' */
199: /* Display a more meaningful error here */
200: hr_utility.trace ('Error: Given city is already created.');
201: local_error ('PAY_DUPL_CITY_NAME', 'create_new_geocode', 3);
202: END IF;
203:
204: ELSE

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

239: p_disable);
240:
241:
242: ELSE
243: hr_utility.trace ('Error: Given city is already created.');
244: local_error ('PAY_DUPL_CITY_NAME', 'create_new_geocode', 4);
245: END IF; /* SQL NOT FOUND */
246: END IF; /* not found */
247: END create_new_geocode ;

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

296: BEGIN
297:
298: /* force case of all passed-in parameters to match that stored in DB. */
299:
300: hr_utility.trace ('County Name: '||p_co_name);
301: hr_utility.trace ('State Name: '||p_st_name);
302:
303: l_stateName := initcap(p_st_name);
304: l_countyName := initcap(p_co_name);

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

297:
298: /* force case of all passed-in parameters to match that stored in DB. */
299:
300: hr_utility.trace ('County Name: '||p_co_name);
301: hr_utility.trace ('State Name: '||p_st_name);
302:
303: l_stateName := initcap(p_st_name);
304: l_countyName := initcap(p_co_name);
305: l_cityName := p_ci_name;

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

303: l_stateName := initcap(p_st_name);
304: l_countyName := initcap(p_co_name);
305: l_cityName := p_ci_name;
306:
307: hr_utility.trace ('County name after initcap :'||l_countyName);
308: hr_utility.trace ('State name after initcap :'||l_stateName);
309: /* get state, county and city codes. */
310:
311: BEGIN

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

304: l_countyName := initcap(p_co_name);
305: l_cityName := p_ci_name;
306:
307: hr_utility.trace ('County name after initcap :'||l_countyName);
308: hr_utility.trace ('State name after initcap :'||l_stateName);
309: /* get state, county and city codes. */
310:
311: BEGIN
312: select state_code, state_abbrev

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

314: from pay_us_states
315: where state_name = l_stateName;
316:
317: EXCEPTION WHEN no_data_found THEN
318: hr_utility.trace ('Error: Failed to find state codes.');
319: local_error ('HR_7952_ADDR_NO_STATE_CODE', 'create_unkn_city', 1);
320: END;
321:
322: hr_utility.trace ('selected state code: ' || l_st_code);

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

318: hr_utility.trace ('Error: Failed to find state codes.');
319: local_error ('HR_7952_ADDR_NO_STATE_CODE', 'create_unkn_city', 1);
320: END;
321:
322: hr_utility.trace ('selected state code: ' || l_st_code);
323: hr_utility.trace ('l_countyName: ' || l_countyName);
324:
325: BEGIN
326: select county_code

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

319: local_error ('HR_7952_ADDR_NO_STATE_CODE', 'create_unkn_city', 1);
320: END;
321:
322: hr_utility.trace ('selected state code: ' || l_st_code);
323: hr_utility.trace ('l_countyName: ' || l_countyName);
324:
325: BEGIN
326: select county_code
327: into l_co_code

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

329: where state_code = l_st_code
330: and initcap(county_name) = l_countyName;
331:
332: EXCEPTION WHEN no_data_found THEN
333: hr_utility.trace ('Error: Failed to find county codes.');
334: local_error ('HR_7953_ADDR_NO_COUNTY_FOUND', 'create_unkn_city', 2);
335: END;
336:
337: hr_utility.trace ('selected county code: ' || l_co_code);

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

333: hr_utility.trace ('Error: Failed to find county codes.');
334: local_error ('HR_7953_ADDR_NO_COUNTY_FOUND', 'create_unkn_city', 2);
335: END;
336:
337: hr_utility.trace ('selected county code: ' || l_co_code);
338:
339: /* see if this city is unknown. */
340:
341: if hr_us_ff_udfs.addr_val(l_st_abbrev, l_countyName, l_cityName,

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

364: from pay_us_city_geocodes
365: where state_code = l_st_code and county_code = l_co_code
366: and city_code like 'U%';
367:
368: hr_utility.trace ('Number of unknown cities '||l_n_ci_code);
369:
370: if l_n_ci_code <= 0 then
371: l_ci_code := 'U000';
372: hr_utility.trace ('Initial city code is:'||l_ci_code);

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

368: hr_utility.trace ('Number of unknown cities '||l_n_ci_code);
369:
370: if l_n_ci_code <= 0 then
371: l_ci_code := 'U000';
372: hr_utility.trace ('Initial city code is:'||l_ci_code);
373: else
374: /*
375: use explicit cursor to step through each of the unknown
376: city codes to find the latest city code.

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

381: l_max_ci_code then
382:
383: l_max_ci_code :=
384: fnd_number.canonical_to_number(substr(l_city_rec.city_code,2,3));
385: hr_utility.trace ('Max city code is:'||
386: l_city_rec.city_code);
387:
388: end if;
389: end loop;

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

395: else
396: l_ci_code := 'U'||to_char(l_max_ci_code + 1);
397: end if;
398:
399: hr_utility.trace ('Final city code is:'||l_ci_code);
400: end if;
401: p_ci_code := l_ci_code;
402:
403: insert into pay_us_city_geocodes

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

403: insert into pay_us_city_geocodes
404: (state_code, county_code, city_code)
405: values
406: (l_st_code, l_co_code, l_ci_code);
407: hr_utility.trace ('Inserted a geocode.');
408:
409: insert into pay_us_zip_codes
410: (zip_start, zip_end, state_code, county_code, city_code)
411: values

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

409: insert into pay_us_zip_codes
410: (zip_start, zip_end, state_code, county_code, city_code)
411: values
412: (p_zi_start, p_zi_end, l_st_code, l_co_code, l_ci_code);
413: hr_utility.trace ('Inserted a zip code.');
414:
415: insert into pay_us_city_names
416: (city_name, state_code, county_code, city_code, primary_flag, disable)
417: values

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

415: insert into pay_us_city_names
416: (city_name, state_code, county_code, city_code, primary_flag, disable)
417: values
418: (l_cityName, l_st_code, l_co_code, l_ci_code, 'N', p_disable);
419: hr_utility.trace ('Inserted an unknown city.');
420:
421: elsif (l_n_ci_name = 1) then
422: hr_utility.trace ('Error: Given city is already created.');
423: local_error ('HR_7954_ADDR_NOT_UNKNOWN_CITY',

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

418: (l_cityName, l_st_code, l_co_code, l_ci_code, 'N', p_disable);
419: hr_utility.trace ('Inserted an unknown city.');
420:
421: elsif (l_n_ci_name = 1) then
422: hr_utility.trace ('Error: Given city is already created.');
423: local_error ('HR_7954_ADDR_NOT_UNKNOWN_CITY',
424: 'create_unkn_city', 3);
425: else
426: /* a new zip range for an existing city has been entered */

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

451: INSERT INTO pay_us_zip_codes
452: (ZIP_START, ZIP_END, STATE_CODE, COUNTY_CODE, CITY_CODE)
453: VALUES
454: (l_zip_start,l_zip_end,l_st_code,l_co_code,l_ci_code);
455: hr_utility.trace ('Inserted a new zip code for an existing city.');
456:
457: p_ci_code := l_ci_code;
458: p_zi_end := l_zip_end;
459: p_zi_start := l_zip_start;

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

469: AND state_code = l_st_code;
470:
471: end if;
472: else
473: hr_utility.trace ('Error: Given city is already created.');
474: local_error ('HR_7954_ADDR_NOT_UNKNOWN_CITY', 'create_unkn_city', 4);
475: end if;
476:
477: END create_unkn_city;

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

525:
526: --
527: BEGIN
528: --
529: /* hr_utility.trace_on('Y','CACITY');*/
530: l_zip_start := p_zip_start;
531: l_zip_end := p_zip_end;
532:
533: create_unkn_city (p_city_code,

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

541: OPEN C;
542: FETCH C INTO p_zprowid;
543: IF (C%NOTFOUND) THEN
544: CLOSE C;
545: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
546: hr_utility.set_message_token('PROCEDURE',
547: 'PAY_CA_CITY_PKG.Insert_Row');
548: hr_utility.set_message_token('STEP','1');
549: hr_utility.raise_error;

Line 546: hr_utility.set_message_token('PROCEDURE',

542: FETCH C INTO p_zprowid;
543: IF (C%NOTFOUND) THEN
544: CLOSE C;
545: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
546: hr_utility.set_message_token('PROCEDURE',
547: 'PAY_CA_CITY_PKG.Insert_Row');
548: hr_utility.set_message_token('STEP','1');
549: hr_utility.raise_error;
550: END if;

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

544: CLOSE C;
545: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
546: hr_utility.set_message_token('PROCEDURE',
547: 'PAY_CA_CITY_PKG.Insert_Row');
548: hr_utility.set_message_token('STEP','1');
549: hr_utility.raise_error;
550: END if;
551:
552: --

Line 549: hr_utility.raise_error;

545: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
546: hr_utility.set_message_token('PROCEDURE',
547: 'PAY_CA_CITY_PKG.Insert_Row');
548: hr_utility.set_message_token('STEP','1');
549: hr_utility.raise_error;
550: END if;
551:
552: --
553: OPEN C2;

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

553: OPEN C2;
554: FETCH C2 INTO p_cirowid;
555: IF (C2%NOTFOUND) THEN
556: CLOSE C2;
557: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
558: hr_utility.set_message_token('PROCEDURE',
559: 'PAY_CA_CITY_PKG.Insert_Row');
560: hr_utility.set_message_token('STEP','2');
561: hr_utility.raise_error;

Line 558: hr_utility.set_message_token('PROCEDURE',

554: FETCH C2 INTO p_cirowid;
555: IF (C2%NOTFOUND) THEN
556: CLOSE C2;
557: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
558: hr_utility.set_message_token('PROCEDURE',
559: 'PAY_CA_CITY_PKG.Insert_Row');
560: hr_utility.set_message_token('STEP','2');
561: hr_utility.raise_error;
562: END if;

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

556: CLOSE C2;
557: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
558: hr_utility.set_message_token('PROCEDURE',
559: 'PAY_CA_CITY_PKG.Insert_Row');
560: hr_utility.set_message_token('STEP','2');
561: hr_utility.raise_error;
562: END if;
563:
564: --

Line 561: hr_utility.raise_error;

557: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
558: hr_utility.set_message_token('PROCEDURE',
559: 'PAY_CA_CITY_PKG.Insert_Row');
560: hr_utility.set_message_token('STEP','2');
561: hr_utility.raise_error;
562: END if;
563:
564: --
565: OPEN C3;

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

565: OPEN C3;
566: FETCH C3 INTO p_gerowid;
567: IF (C3%NOTFOUND) THEN
568: CLOSE C3;
569: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
570: hr_utility.set_message_token('PROCEDURE',
571: 'PAY_CA_CITY_PKG.Insert_Row');
572: hr_utility.set_message_token('STEP','3');
573: hr_utility.raise_error;

Line 570: hr_utility.set_message_token('PROCEDURE',

566: FETCH C3 INTO p_gerowid;
567: IF (C3%NOTFOUND) THEN
568: CLOSE C3;
569: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
570: hr_utility.set_message_token('PROCEDURE',
571: 'PAY_CA_CITY_PKG.Insert_Row');
572: hr_utility.set_message_token('STEP','3');
573: hr_utility.raise_error;
574: END if;

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

568: CLOSE C3;
569: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
570: hr_utility.set_message_token('PROCEDURE',
571: 'PAY_CA_CITY_PKG.Insert_Row');
572: hr_utility.set_message_token('STEP','3');
573: hr_utility.raise_error;
574: END if;
575:
576: /* hr_utility.trace_off; */

Line 573: hr_utility.raise_error;

569: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
570: hr_utility.set_message_token('PROCEDURE',
571: 'PAY_CA_CITY_PKG.Insert_Row');
572: hr_utility.set_message_token('STEP','3');
573: hr_utility.raise_error;
574: END if;
575:
576: /* hr_utility.trace_off; */
577: END Insert_Row;

Line 576: /* hr_utility.trace_off; */

572: hr_utility.set_message_token('STEP','3');
573: hr_utility.raise_error;
574: END if;
575:
576: /* hr_utility.trace_off; */
577: END Insert_Row;
578:
579: -----------------------------------------------------------------------------
580: -- Name --

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

618: OPEN C;
619: FETCH C INTO l_recinfo;
620: if (C%NOTFOUND) then
621: CLOSE C;
622: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
623: hr_utility.set_message_token('PROCEDURE',
624: 'PAY_CA_CITY_PKG.lock_row');
625: hr_utility.set_message_token('STEP','1');
626: hr_utility.raise_error;

Line 623: hr_utility.set_message_token('PROCEDURE',

619: FETCH C INTO l_recinfo;
620: if (C%NOTFOUND) then
621: CLOSE C;
622: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
623: hr_utility.set_message_token('PROCEDURE',
624: 'PAY_CA_CITY_PKG.lock_row');
625: hr_utility.set_message_token('STEP','1');
626: hr_utility.raise_error;
627: end if;

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

621: CLOSE C;
622: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
623: hr_utility.set_message_token('PROCEDURE',
624: 'PAY_CA_CITY_PKG.lock_row');
625: hr_utility.set_message_token('STEP','1');
626: hr_utility.raise_error;
627: end if;
628: --
629: OPEN C2;

Line 626: hr_utility.raise_error;

622: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
623: hr_utility.set_message_token('PROCEDURE',
624: 'PAY_CA_CITY_PKG.lock_row');
625: hr_utility.set_message_token('STEP','1');
626: hr_utility.raise_error;
627: end if;
628: --
629: OPEN C2;
630: FETCH C2 INTO l_recinfo2;

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

629: OPEN C2;
630: FETCH C2 INTO l_recinfo2;
631: if (C2%NOTFOUND) then
632: CLOSE C2;
633: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
634: hr_utility.set_message_token('PROCEDURE',
635: 'PAY_CA_CITY_PKG.lock_row');
636: hr_utility.set_message_token('STEP','2');
637: hr_utility.raise_error;

Line 634: hr_utility.set_message_token('PROCEDURE',

630: FETCH C2 INTO l_recinfo2;
631: if (C2%NOTFOUND) then
632: CLOSE C2;
633: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
634: hr_utility.set_message_token('PROCEDURE',
635: 'PAY_CA_CITY_PKG.lock_row');
636: hr_utility.set_message_token('STEP','2');
637: hr_utility.raise_error;
638: end if;

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

632: CLOSE C2;
633: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
634: hr_utility.set_message_token('PROCEDURE',
635: 'PAY_CA_CITY_PKG.lock_row');
636: hr_utility.set_message_token('STEP','2');
637: hr_utility.raise_error;
638: end if;
639: --
640: OPEN C3;

Line 637: hr_utility.raise_error;

633: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
634: hr_utility.set_message_token('PROCEDURE',
635: 'PAY_CA_CITY_PKG.lock_row');
636: hr_utility.set_message_token('STEP','2');
637: hr_utility.raise_error;
638: end if;
639: --
640: OPEN C3;
641: FETCH C3 INTO l_recinfo3;

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

640: OPEN C3;
641: FETCH C3 INTO l_recinfo3;
642: if (C3%NOTFOUND) then
643: CLOSE C3;
644: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
645: hr_utility.set_message_token('PROCEDURE',
646: 'PAY_CA_CITY_PKG.lock_row');
647: hr_utility.set_message_token('STEP','3');
648: hr_utility.raise_error;

Line 645: hr_utility.set_message_token('PROCEDURE',

641: FETCH C3 INTO l_recinfo3;
642: if (C3%NOTFOUND) then
643: CLOSE C3;
644: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
645: hr_utility.set_message_token('PROCEDURE',
646: 'PAY_CA_CITY_PKG.lock_row');
647: hr_utility.set_message_token('STEP','3');
648: hr_utility.raise_error;
649: end if;

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

643: CLOSE C3;
644: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
645: hr_utility.set_message_token('PROCEDURE',
646: 'PAY_CA_CITY_PKG.lock_row');
647: hr_utility.set_message_token('STEP','3');
648: hr_utility.raise_error;
649: end if;
650:
651: --

Line 648: hr_utility.raise_error;

644: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
645: hr_utility.set_message_token('PROCEDURE',
646: 'PAY_CA_CITY_PKG.lock_row');
647: hr_utility.set_message_token('STEP','3');
648: hr_utility.raise_error;
649: end if;
650:
651: --
652: -- Remove trailing spaces.

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

709: zip_end = p_zip_end
710: WHERE rowid = p_zprowid;
711: --
712: if (SQL%NOTFOUND) then
713: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
714: hr_utility.set_message_token('PROCEDURE',
715: 'pay_us_new_cities_pkg.update_row');
716: hr_utility.set_message_token('STEP','1');
717: hr_utility.raise_error;

Line 714: hr_utility.set_message_token('PROCEDURE',

710: WHERE rowid = p_zprowid;
711: --
712: if (SQL%NOTFOUND) then
713: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
714: hr_utility.set_message_token('PROCEDURE',
715: 'pay_us_new_cities_pkg.update_row');
716: hr_utility.set_message_token('STEP','1');
717: hr_utility.raise_error;
718: end if;

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

712: if (SQL%NOTFOUND) then
713: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
714: hr_utility.set_message_token('PROCEDURE',
715: 'pay_us_new_cities_pkg.update_row');
716: hr_utility.set_message_token('STEP','1');
717: hr_utility.raise_error;
718: end if;
719: --
720: UPDATE pay_us_city_names

Line 717: hr_utility.raise_error;

713: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
714: hr_utility.set_message_token('PROCEDURE',
715: 'pay_us_new_cities_pkg.update_row');
716: hr_utility.set_message_token('STEP','1');
717: hr_utility.raise_error;
718: end if;
719: --
720: UPDATE pay_us_city_names
721: SET disable = p_disable

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

724: AND city_code = p_city_code
725: AND city_name = p_city_name;
726: --
727: if (SQL%NOTFOUND) then
728: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
729: hr_utility.set_message_token('PROCEDURE',
730: 'pay_us_new_cities_pkg.update_row');
731: hr_utility.set_message_token('STEP','1');
732: hr_utility.raise_error;

Line 729: hr_utility.set_message_token('PROCEDURE',

725: AND city_name = p_city_name;
726: --
727: if (SQL%NOTFOUND) then
728: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
729: hr_utility.set_message_token('PROCEDURE',
730: 'pay_us_new_cities_pkg.update_row');
731: hr_utility.set_message_token('STEP','1');
732: hr_utility.raise_error;
733: end if;

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

727: if (SQL%NOTFOUND) then
728: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
729: hr_utility.set_message_token('PROCEDURE',
730: 'pay_us_new_cities_pkg.update_row');
731: hr_utility.set_message_token('STEP','1');
732: hr_utility.raise_error;
733: end if;
734: --
735: END Update_Row;

Line 732: hr_utility.raise_error;

728: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
729: hr_utility.set_message_token('PROCEDURE',
730: 'pay_us_new_cities_pkg.update_row');
731: hr_utility.set_message_token('STEP','1');
732: hr_utility.raise_error;
733: end if;
734: --
735: END Update_Row;
736: --

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

785:
786: END IF;
787: --
788: if (SQL%NOTFOUND) then
789: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
790: hr_utility.set_message_token('PROCEDURE',
791: 'PAY_CA_CITY_PKG.delete_row');
792: hr_utility.set_message_token('STEP','3');
793: hr_utility.raise_error;

Line 790: hr_utility.set_message_token('PROCEDURE',

786: END IF;
787: --
788: if (SQL%NOTFOUND) then
789: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
790: hr_utility.set_message_token('PROCEDURE',
791: 'PAY_CA_CITY_PKG.delete_row');
792: hr_utility.set_message_token('STEP','3');
793: hr_utility.raise_error;
794: end if;

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

788: if (SQL%NOTFOUND) then
789: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
790: hr_utility.set_message_token('PROCEDURE',
791: 'PAY_CA_CITY_PKG.delete_row');
792: hr_utility.set_message_token('STEP','3');
793: hr_utility.raise_error;
794: end if;
795: END Delete_Row;
796: --

Line 793: hr_utility.raise_error;

789: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
790: hr_utility.set_message_token('PROCEDURE',
791: 'PAY_CA_CITY_PKG.delete_row');
792: hr_utility.set_message_token('STEP','3');
793: hr_utility.raise_error;
794: end if;
795: END Delete_Row;
796: --
797: -- The Next procedure is used for checking and validating data

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

859: FETCH C1 INTO l_recinfo1;
860: IF (C1%FOUND) THEN
861: /* rosie monge 18-mar-03 2844658 */
862: /*
863: hr_utility.set_message (801,'HR_6153_all_PROCEDURE_FAIL');
864: hr_utility.set_message_token ('PROCEDURE',
865: 'pay_us_chk_addr_pkg.chk_city_in_addr');
866: hr_utility.set_message_token ('STEP', '1');
867: */

Line 864: hr_utility.set_message_token ('PROCEDURE',

860: IF (C1%FOUND) THEN
861: /* rosie monge 18-mar-03 2844658 */
862: /*
863: hr_utility.set_message (801,'HR_6153_all_PROCEDURE_FAIL');
864: hr_utility.set_message_token ('PROCEDURE',
865: 'pay_us_chk_addr_pkg.chk_city_in_addr');
866: hr_utility.set_message_token ('STEP', '1');
867: */
868: hr_utility.set_message(801,'PAY_74153_CITY_CANNOT_DISABLE');

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

862: /*
863: hr_utility.set_message (801,'HR_6153_all_PROCEDURE_FAIL');
864: hr_utility.set_message_token ('PROCEDURE',
865: 'pay_us_chk_addr_pkg.chk_city_in_addr');
866: hr_utility.set_message_token ('STEP', '1');
867: */
868: hr_utility.set_message(801,'PAY_74153_CITY_CANNOT_DISABLE');
869: hr_utility.raise_error;
870: END IF;

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

864: hr_utility.set_message_token ('PROCEDURE',
865: 'pay_us_chk_addr_pkg.chk_city_in_addr');
866: hr_utility.set_message_token ('STEP', '1');
867: */
868: hr_utility.set_message(801,'PAY_74153_CITY_CANNOT_DISABLE');
869: hr_utility.raise_error;
870: END IF;
871: CLOSE C1;
872:

Line 869: hr_utility.raise_error;

865: 'pay_us_chk_addr_pkg.chk_city_in_addr');
866: hr_utility.set_message_token ('STEP', '1');
867: */
868: hr_utility.set_message(801,'PAY_74153_CITY_CANNOT_DISABLE');
869: hr_utility.raise_error;
870: END IF;
871: CLOSE C1;
872:
873: ELSE

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

875: FETCH C2 INTO l_recinfo2;
876: IF (C2%FOUND) THEN
877: /* rmonge fix for bug 2844658 */
878: /*
879: hr_utility.set_message (801,'HR_6153_all_PROCEDURE_FAIL');
880: hr_utility.set_message_token ('PROCEDURE',
881: 'pay_us_chk_addr_pkg.chk_city_in_addr');
882: hr_utility.set_message_token ('STEP', '1');
883: */

Line 880: hr_utility.set_message_token ('PROCEDURE',

876: IF (C2%FOUND) THEN
877: /* rmonge fix for bug 2844658 */
878: /*
879: hr_utility.set_message (801,'HR_6153_all_PROCEDURE_FAIL');
880: hr_utility.set_message_token ('PROCEDURE',
881: 'pay_us_chk_addr_pkg.chk_city_in_addr');
882: hr_utility.set_message_token ('STEP', '1');
883: */
884: hr_utility.set_message(801,'PAY_74153_CITY_CANNOT_DISABLE');

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

878: /*
879: hr_utility.set_message (801,'HR_6153_all_PROCEDURE_FAIL');
880: hr_utility.set_message_token ('PROCEDURE',
881: 'pay_us_chk_addr_pkg.chk_city_in_addr');
882: hr_utility.set_message_token ('STEP', '1');
883: */
884: hr_utility.set_message(801,'PAY_74153_CITY_CANNOT_DISABLE');
885: hr_utility.raise_error;
886: END IF;

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

880: hr_utility.set_message_token ('PROCEDURE',
881: 'pay_us_chk_addr_pkg.chk_city_in_addr');
882: hr_utility.set_message_token ('STEP', '1');
883: */
884: hr_utility.set_message(801,'PAY_74153_CITY_CANNOT_DISABLE');
885: hr_utility.raise_error;
886: END IF;
887: CLOSE C2;
888:

Line 885: hr_utility.raise_error;

881: 'pay_us_chk_addr_pkg.chk_city_in_addr');
882: hr_utility.set_message_token ('STEP', '1');
883: */
884: hr_utility.set_message(801,'PAY_74153_CITY_CANNOT_DISABLE');
885: hr_utility.raise_error;
886: END IF;
887: CLOSE C2;
888:
889: END IF;