APPS.PAY_ORG_PAYMENT_METHODS_PKG dependencies on PAY_ORG_PAYMENT_METHODS_PKG

Line 1: PACKAGE BODY pay_org_payment_methods_pkg AS

1: PACKAGE BODY pay_org_payment_methods_pkg AS
2: /* $Header: pyopm01t.pkb 120.6 2006/08/31 12:42:53 pgongada noship $ */
3: g_dummy number(1);
4: g_business_group_id number(15);
5: g_validation_start_date date;

Line 337: l_package_name VARCHAR2(80) := 'PAY_ORG_PAYMENT_METHODS_PKG.VALIDATE_TRANSLATION';

333: ptm.effective_end_date) or
334: (g_validation_start_date IS NULL or g_validation_end_date IS NULL) or
335: ((g_validation_start_date < ptm.effective_start_date) and
336: (g_validation_end_date > ptm.effective_end_date)));
337: l_package_name VARCHAR2(80) := 'PAY_ORG_PAYMENT_METHODS_PKG.VALIDATE_TRANSLATION';
338:
339: BEGIN
340: hr_utility.set_location (l_package_name,10);
341: OPEN c_translation(language, org_payment_method_name,org_payment_method_id);

Line 395: hr_utility.set_message_token ('PROCEDURE','PAY_ORG_PAYMENT_METHODS_PKG.DELETE_TL_ROW');

391: and o.rowid <> chartorowid(P_ROW_ID));
392: --
393: if sql%notfound then -- trap system errors during deletion
394: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
395: hr_utility.set_message_token ('PROCEDURE','PAY_ORG_PAYMENT_METHODS_PKG.DELETE_TL_ROW');
396: end if;
397: --
398: -- ********************************************************************************
399: --

Line 502: hr_utility.set_message_token('PROCEDURE','pay_org_payment_methods_pkg.lock_row');

498: --
499: if (OPM_CUR%NOTFOUND) then
500: close OPM_CUR;
501: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
502: hr_utility.set_message_token('PROCEDURE','pay_org_payment_methods_pkg.lock_row');
503: hr_utility.set_message_token('STEP','1');
504: hr_utility.raise_error;
505: end if;
506: close OPM_CUR;

Line 516: hr_utility.set_message_token('PROCEDURE','pay_org_payment_methods_pkg.lock_row');

512:
513: if (PGA_CUR%NOTFOUND) then
514: close PGA_CUR;
515: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
516: hr_utility.set_message_token('PROCEDURE','pay_org_payment_methods_pkg.lock_row');
517: hr_utility.set_message_token('STEP','2');
518: hr_utility.raise_error;
519: end if;
520:

Line 922: hr_utility.set_message_token ('PROCEDURE','PAY_ORG_PAYMENT_METHODS_PKG.UPDATE_TL_ROW');

918: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
919: --
920: if (sql%notfound) then -- trap system errors during update
921: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
922: hr_utility.set_message_token ('PROCEDURE','PAY_ORG_PAYMENT_METHODS_PKG.UPDATE_TL_ROW');
923: end if;
924: --
925: -- ***************************************************************************************
926:

Line 984: hr_utility.set_message_token ('PROCEDURE','PAY_ORG_PAYMENT_METHODS_PKG.UPDAT

980: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
981: --
982: if (sql%notfound) then -- trap system errors during update
983: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
984: hr_utility.set_message_token ('PROCEDURE','PAY_ORG_PAYMENT_METHODS_PKG.UPDAT
985: E_TL_ROW');
986: end if;
987: --
988:

Line 1115: hr_utility.set_message_token('PROCEDURE','PAY_ORG_PAYMENT_METHODS_PKG.UNIQUE_CHK');

1111: and BUSINESS_GROUP_ID is NULL;
1112: --
1113: IF (result>1) THEN
1114: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1115: hr_utility.set_message_token('PROCEDURE','PAY_ORG_PAYMENT_METHODS_PKG.UNIQUE_CHK');
1116: hr_utility.set_message_token('STEP','1');
1117: hr_utility.raise_error;
1118: END IF;
1119: EXCEPTION

Line 1122: hr_utility.set_message_token('PROCEDURE','PAY_ORG_PAYMENT_METHODS_PKG.UNIQUE_CHK');

1118: END IF;
1119: EXCEPTION
1120: when NO_DATA_FOUND then
1121: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1122: hr_utility.set_message_token('PROCEDURE','PAY_ORG_PAYMENT_METHODS_PKG.UNIQUE_CHK');
1123: hr_utility.set_message_token('STEP','1');
1124: hr_utility.raise_error;
1125: end unique_chk;
1126: --------------------------------------------------------------------------------

Line 1159: hr_utility.set_message_token('PROCEDURE','PAY_ORG_PAYMENT_METHODS_PKG.PAYEE_TYPE');

1155: RETURN l_payee_name;
1156: exception
1157: WHEN no_data_found THEN
1158: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1159: hr_utility.set_message_token('PROCEDURE','PAY_ORG_PAYMENT_METHODS_PKG.PAYEE_TYPE');
1160: hr_utility.set_message_token('STEP','2');
1161: hr_utility.raise_error;
1162: end payee_type;
1163: --------------------------------------------------------------------------------

Line 1193: -- hr_utility.set_message_token ('PROCEDURE','PAY_ORG_PAYMENT_METHODS_PKG.TRANSLATE_ROW');

1189: and BUSINESS_GROUP_ID is NULL);
1190: --
1191: if (sql%notfound) then -- trap system errors during update
1192: -- hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1193: -- hr_utility.set_message_token ('PROCEDURE','PAY_ORG_PAYMENT_METHODS_PKG.TRANSLATE_ROW');
1194: -- hr_utility.set_message_token('STEP','1');
1195: -- hr_utility.raise_error;
1196: null;
1197: end if;

Line 1218: END pay_org_payment_methods_pkg;

1214: end if;
1215: --
1216: end lock_aba_row;
1217: --------------------------------------------------------------------------------
1218: END pay_org_payment_methods_pkg;