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_OPM_SHD dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 32: If (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK1') Then

28: l_proc varchar2(72) := g_package||'constraint_error';
29: --
30: Begin
31: --
32: If (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK1') Then
33: -- RAISE ERROR MESSAGE
34: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
35: fnd_message.set_token('COLUMN_NAME', 'BUSINESS_GROUP_ID');
36: fnd_message.raise_error;

Line 37: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK2') Then

33: -- RAISE ERROR MESSAGE
34: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
35: fnd_message.set_token('COLUMN_NAME', 'BUSINESS_GROUP_ID');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK2') Then
38: -- RAISE ERROR MESSAGE
39: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
40: fnd_message.set_token('COLUMN_NAME', 'EXTERNAL_ACCOUNT_ID');
41: fnd_message.raise_error;

Line 42: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK3') Then

38: -- RAISE ERROR MESSAGE
39: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
40: fnd_message.set_token('COLUMN_NAME', 'EXTERNAL_ACCOUNT_ID');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK3') Then
43: -- RAISE ERROR MESSAGE
44: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
45: fnd_message.set_token('COLUMN_NAME', 'PAYMENT_TYPE_ID');
46: fnd_message.raise_error;

Line 47: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK4') Then

43: -- RAISE ERROR MESSAGE
44: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
45: fnd_message.set_token('COLUMN_NAME', 'PAYMENT_TYPE_ID');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_FK4') Then
48: -- RAISE ERROR MESSAGE
49: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
50: fnd_message.set_token('COLUMN_NAME', 'DEFINED_BALANCE_ID');
51: fnd_message.raise_error;

Line 52: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_PK') Then

48: -- RAISE ERROR MESSAGE
49: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
50: fnd_message.set_token('COLUMN_NAME', 'DEFINED_BALANCE_ID');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ORG_PAYMENT_METHODS_F_PK') Then
53: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
54: fnd_message.set_token('PROCEDURE', l_proc);
55: fnd_message.set_token('STEP','25');
56: fnd_message.raise_error;

Line 138: from pay_org_payment_methods_f

134: ,cost_payment
135: ,cost_cleared_payment
136: ,cost_cleared_void_payment
137: ,exclude_manual_payment
138: from pay_org_payment_methods_f
139: where org_payment_method_id = p_org_payment_method_id
140: and p_effective_date
141: between effective_start_date and effective_end_date;
142: --

Line 213: ,p_base_table_name => 'pay_org_payment_methods_f'

209: -- Call the corresponding datetrack api
210: --
211: dt_api.find_dt_upd_modes
212: (p_effective_date => p_effective_date
213: ,p_base_table_name => 'pay_org_payment_methods_f'
214: ,p_base_key_column => 'org_payment_method_id'
215: ,p_base_key_value => p_base_key_value
216: ,p_correction => p_correction
217: ,p_update => p_update

Line 247: ,p_base_table_name => 'pay_org_payment_methods_f'

243: -- Call the corresponding datetrack api
244: --
245: dt_api.find_dt_del_modes
246: (p_effective_date => p_effective_date
247: ,p_base_table_name => 'pay_org_payment_methods_f'
248: ,p_base_key_column => 'org_payment_method_id'
249: ,p_base_key_value => p_base_key_value
250: ,p_zap => p_zap
251: ,p_delete => p_delete

Line 282: (p_base_table_name => 'pay_org_payment_methods_f'

278: -- version number.
279: --
280: l_object_version_number :=
281: dt_api.get_object_version_number
282: (p_base_table_name => 'pay_org_payment_methods_f'
283: ,p_base_key_column => 'org_payment_method_id'
284: ,p_base_key_value => p_base_key_value
285: );
286: --

Line 293: update pay_org_payment_methods_f t

289: --
290: -- Update the specified datetrack row setting the effective
291: -- end date to the specified new effective end date.
292: --
293: update pay_org_payment_methods_f t
294: set t.effective_end_date = p_new_effective_end_date
295: , t.object_version_number = l_object_version_number
296: where t.org_payment_method_id = p_base_key_value
297: and p_effective_date

Line 392: from pay_org_payment_methods_f

388: ,cost_payment
389: ,cost_cleared_payment
390: ,cost_cleared_void_payment
391: ,exclude_manual_payment
392: from pay_org_payment_methods_f
393: where org_payment_method_id = p_org_payment_method_id
394: and p_effective_date
395: between effective_start_date and effective_end_date
396: for update nowait;

Line 481: ,p_base_table_name => 'pay_org_payment_methods_f'

477: --
478: dt_api.validate_dt_mode
479: (p_effective_date => p_effective_date
480: ,p_datetrack_mode => p_datetrack_mode
481: ,p_base_table_name => 'pay_org_payment_methods_f'
482: ,p_base_key_column => 'org_payment_method_id'
483: ,p_base_key_value => p_org_payment_method_id
484: ,p_child_table_name1 => 'pay_org_pay_method_usages_f'
485: ,p_child_key_column1 => 'org_pay_method_usage_id'

Line 524: fnd_message.set_token('TABLE_NAME', 'pay_org_payment_methods_f');

520: -- The object is locked therefore we need to supply a meaningful
521: -- error message.
522: --
523: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
524: fnd_message.set_token('TABLE_NAME', 'pay_org_payment_methods_f');
525: fnd_message.raise_error;
526: End lck;
527: --
528: -- ----------------------------------------------------------------------------