APPS.PAY_PAYMENT_TYPES_PKG dependencies on PAY_PAYMENT_TYPES_PKG

Line 1: PACKAGE BODY PAY_PAYMENT_TYPES_PKG as

1: PACKAGE BODY PAY_PAYMENT_TYPES_PKG as
2: /* $Header: pypyt01t.pkb 120.0.12010000.3 2009/07/12 10:21:45 namgoyal ship $ */
3: g_dummy number(1);
4:
5: PROCEDURE Is_Unique(X_Rowid VARCHAR2,X_Payment_Type_Name VARCHAR2,X_Territory_Code VARCHAR2) IS

Line 182: l_package_name VARCHAR2(80) := 'PAY_PAYMENT_TYPES_PKG.VALIDATE_TRANSLATION';

178: AND ptt.payment_type_id = pty.payment_type_id
179: AND ptt.language = p_language
180: AND pty.payment_type_id <> p_payment_type_id;
181:
182: l_package_name VARCHAR2(80) := 'PAY_PAYMENT_TYPES_PKG.VALIDATE_TRANSLATION';
183:
184: BEGIN
185:
186: hr_utility.set_location (l_package_name,10);

Line 300: -- hr_utility.set_message_token ('PROCEDURE','PAY_PAYMENT_TYPES_PKG.LOCK_TL_ROW');

296: -- end loop;
297: ----
298: --if (l_mls_count=0) then -- Trap system errors
299: -- hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
300: -- hr_utility.set_message_token ('PROCEDURE','PAY_PAYMENT_TYPES_PKG.LOCK_TL_ROW');
301: --end if;
302: --
303: -- ***************************************************************************
304: --

Line 420: hr_utility.set_message_token ('PROCEDURE','PAY_PAYMENT_TYPES_PKG.UPDATE_TL_ROW');

416: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
417: --
418: if (sql%notfound) then -- trap system errors during update
419: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
420: hr_utility.set_message_token ('PROCEDURE','PAY_PAYMENT_TYPES_PKG.UPDATE_TL_ROW');
421: end if;
422: --
423: -- ***************************************************************************************
424: --

Line 448: hr_utility.set_message_token ('PROCEDURE','PAY_PAYMENT_TYPES_PKG.DELETE_TL_ROW');

444: where PAYMENT_TYPE_ID = X_PAYMENT_TYPE_ID;
445: --
446: if sql%notfound then -- trap system errors during deletion
447: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
448: hr_utility.set_message_token ('PROCEDURE','PAY_PAYMENT_TYPES_PKG.DELETE_TL_ROW');
449: end if;
450: --
451: -- ********************************************************************************
452: --

Line 533: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_TYPES_PKG.UNIQUE_CHK');

529: AND UPPER(territory_code) = UPPER(x_territory_code);
530: --
531: IF (result>1) THEN
532: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
533: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_TYPES_PKG.UNIQUE_CHK');
534: hr_utility.set_message_token('STEP','1');
535: hr_utility.raise_error;
536: END IF;
537: EXCEPTION

Line 540: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_TYPES_PKG.UNIQUE_CHK');

536: END IF;
537: EXCEPTION
538: when NO_DATA_FOUND then
539: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
540: hr_utility.set_message_token('PROCEDURE','PAY_PAYMENT_TYPES_PKG.UNIQUE_CHK');
541: hr_utility.set_message_token('STEP','1');
542: hr_utility.raise_error;
543: end unique_chk;
544: --

Line 570: -- hr_utility.set_message_token ('PROCEDURE','PAY_PAYMENT_TYPES_PKG.TRANSLATE_ROW');

566: AND nvl(upper(x_b_payment_type_name),'~null~') = nvl(upper(ppt.payment_type_name),'~null~'));
567: --
568: if (sql%notfound) then -- trap system errors during update
569: -- hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
570: -- hr_utility.set_message_token ('PROCEDURE','PAY_PAYMENT_TYPES_PKG.TRANSLATE_ROW');
571: -- hr_utility.set_message_token('STEP','1');
572: -- hr_utility.raise_error;
573: null;
574: end if;

Line 718: END PAY_PAYMENT_TYPES_PKG;

714: AND nvl(upper(x_b_payment_type_name),'~null~') = nvl(upper(ppt.payment_type_name),'~null~'));
715: end if;
716: end LOAD_ROW;
717: ------------------------------------------------------------------------------
718: END PAY_PAYMENT_TYPES_PKG;