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

Line 340: hr_utility.set_location (l_package_name,10);

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);
342: hr_utility.set_location (l_package_name,50);
343: FETCH c_translation INTO g_dummy;
344:

Line 342: hr_utility.set_location (l_package_name,50);

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);
342: hr_utility.set_location (l_package_name,50);
343: FETCH c_translation INTO g_dummy;
344:
345: IF c_translation%NOTFOUND THEN
346: hr_utility.set_location (l_package_name,60);

Line 346: hr_utility.set_location (l_package_name,60);

342: hr_utility.set_location (l_package_name,50);
343: FETCH c_translation INTO g_dummy;
344:
345: IF c_translation%NOTFOUND THEN
346: hr_utility.set_location (l_package_name,60);
347: CLOSE c_translation;
348: ELSE
349: hr_utility.set_location (l_package_name,70);
350: CLOSE c_translation;

Line 349: hr_utility.set_location (l_package_name,70);

345: IF c_translation%NOTFOUND THEN
346: hr_utility.set_location (l_package_name,60);
347: CLOSE c_translation;
348: ELSE
349: hr_utility.set_location (l_package_name,70);
350: CLOSE c_translation;
351: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
352: fnd_message.raise_error;
353: END IF;

Line 354: hr_utility.set_location ('Leaving:'||l_package_name,80);

350: CLOSE c_translation;
351: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
352: fnd_message.raise_error;
353: END IF;
354: hr_utility.set_location ('Leaving:'||l_package_name,80);
355: END validate_translation;
356: -----------------------------------------------------------------------------
357: --
358: -- Standard delete procedure

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

390: where o.ORG_PAYMENT_METHOD_ID = P_ORG_PAYMENT_METHOD_ID
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: -- ********************************************************************************

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 501: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

497: fetch OPM_CUR into OPM_REC;
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;

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 503: hr_utility.set_message_token('STEP','1');

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;
507: --

Line 504: hr_utility.raise_error;

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;
507: --
508: --

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

511: fetch PGA_CUR into PGA_REC;
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;

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 517: hr_utility.set_message_token('STEP','2');

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:
521: close PGA_CUR;

Line 518: hr_utility.raise_error;

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:
521: close PGA_CUR;
522:

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

917: where ORG_PAYMENT_METHOD_ID = P_ORG_PAYMENT_METHOD_ID
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: -- ***************************************************************************************

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 983: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');

979: where ORG_PAYMENT_METHOD_ID = P_ORG_PAYMENT_METHOD_ID
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: --

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 1069: hr_utility.set_message(801, 'HR_6235_PAYM_EXISTING_PPMS');

1065: from pay_personal_payment_methods_f
1066: where org_payment_method_id = p_opm_id
1067: and effective_end_date > fnd_date.canonical_to_date(p_end_date);
1068: if (SQL%FOUND) then
1069: hr_utility.set_message(801, 'HR_6235_PAYM_EXISTING_PPMS');
1070: hr_utility.raise_error;
1071: end if;
1072: -- now check if there are any opmu's using this opm with an end date
1073: --greater than the new end_date

Line 1070: hr_utility.raise_error;

1066: where org_payment_method_id = p_opm_id
1067: and effective_end_date > fnd_date.canonical_to_date(p_end_date);
1068: if (SQL%FOUND) then
1069: hr_utility.set_message(801, 'HR_6235_PAYM_EXISTING_PPMS');
1070: hr_utility.raise_error;
1071: end if;
1072: -- now check if there are any opmu's using this opm with an end date
1073: --greater than the new end_date
1074: select null

Line 1080: hr_utility.set_message(801, 'HR_6236_PAYM_USED_AS_DEFAULT');

1076: from pay_org_pay_method_usages_f
1077: where org_payment_method_id = p_opm_id
1078: and effective_end_date > fnd_date.canonical_to_date(p_end_date);
1079: if (SQL%FOUND) then
1080: hr_utility.set_message(801, 'HR_6236_PAYM_USED_AS_DEFAULT');
1081: hr_utility.raise_error;
1082: end if;
1083: exception
1084: when no_data_found then

Line 1081: hr_utility.raise_error;

1077: where org_payment_method_id = p_opm_id
1078: and effective_end_date > fnd_date.canonical_to_date(p_end_date);
1079: if (SQL%FOUND) then
1080: hr_utility.set_message(801, 'HR_6236_PAYM_USED_AS_DEFAULT');
1081: hr_utility.raise_error;
1082: end if;
1083: exception
1084: when no_data_found then
1085: null;

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

1110: and O_EFFECTIVE_END_DATE is not NULL
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;

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 1116: hr_utility.set_message_token('STEP','1');

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
1120: when NO_DATA_FOUND then

Line 1117: hr_utility.raise_error;

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
1120: when NO_DATA_FOUND then
1121: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

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

1117: hr_utility.raise_error;
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;

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 1123: hr_utility.set_message_token('STEP','1');

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: --------------------------------------------------------------------------------
1127: function payee_type(p_payee_type varchar2,

Line 1124: hr_utility.raise_error;

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: --------------------------------------------------------------------------------
1127: function payee_type(p_payee_type varchar2,
1128: p_payee_id number,

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

1154: END IF;
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;

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 1160: hr_utility.set_message_token('STEP','2');

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: --------------------------------------------------------------------------------
1164: procedure TRANSLATE_ROW (

Line 1161: hr_utility.raise_error;

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: --------------------------------------------------------------------------------
1164: procedure TRANSLATE_ROW (
1165: X_O_ORG_PAYMENT_METHOD_NAME in varchar2,

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

1188: and X_O_EFFECTIVE_END_DATE is not NULL
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;

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 1194: -- hr_utility.set_message_token('STEP','1');

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;
1198: end TRANSLATE_ROW;

Line 1195: -- hr_utility.raise_error;

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;
1198: end TRANSLATE_ROW;
1199: --------------------------------------------------------------------------------