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_PPMV4_UTILS_SS dependencies on PAY_PSS_TX_STEPS_PKG

Line 169: pay_pss_tx_steps_pkg.insert_row

165: l_proc varchar2(2000) := g_package || 'ppm2tt';
166: begin
167: seterrorstage(l_proc, 'ENTER', 0);
168: if p_ppm.transaction_step_id is null then
169: pay_pss_tx_steps_pkg.insert_row
170: (p_transaction_id => p_ppm.transaction_id
171: ,p_transaction_step_id => p_ppm.transaction_step_id
172: ,p_source_table => p_ppm.source_table
173: ,p_state => p_ppm.state

Line 241: pay_pss_tx_steps_pkg.update_row

237: ,p_o_attribute19 => p_ppm.o_attribute19
238: ,p_o_attribute20 => p_ppm.o_attribute20
239: );
240: else
241: pay_pss_tx_steps_pkg.update_row
242: (p_transaction_step_id => p_ppm.transaction_step_id
243: ,p_source_table => p_ppm.source_table
244: ,p_state => p_ppm.state
245: ,p_personal_payment_method_id => p_ppm.personal_payment_method_id

Line 1140: if p_state = pay_pss_tx_steps_pkg.C_STATE_NEW then

1136: --
1137: -- Set up default values by operation and type.
1138: --
1139: seterrorstage(l_proc, 'ENTER', 0);
1140: if p_state = pay_pss_tx_steps_pkg.C_STATE_NEW then
1141: seterrorstage(l_proc, 'C_STATE_NEW', 10);
1142: l_default_number := null;
1143: l_default_varchar2 := null;
1144: l_datetrack_mode := hr_api.g_insert;

Line 1145: elsif p_state = pay_pss_tx_steps_pkg.C_STATE_UPDATED then

1141: seterrorstage(l_proc, 'C_STATE_NEW', 10);
1142: l_default_number := null;
1143: l_default_varchar2 := null;
1144: l_datetrack_mode := hr_api.g_insert;
1145: elsif p_state = pay_pss_tx_steps_pkg.C_STATE_UPDATED then
1146: seterrorstage(l_proc, 'C_STATE_UPDATED', 20);
1147: l_default_number := hr_api.g_number;
1148: l_default_varchar2 := hr_api.g_varchar2;
1149: l_datetrack_mode := p_update_datetrack_mode;

Line 1169: if p_amount_type = pay_pss_tx_steps_pkg.C_PERCENTAGE or

1165: end if;
1166: --
1167: -- Set up Percent/Amount validation.
1168: --
1169: if p_amount_type = pay_pss_tx_steps_pkg.C_PERCENTAGE or
1170: p_amount_type = pay_pss_tx_steps_pkg.C_PERCENTAGE_ONLY then
1171: seterrorstage(l_proc, 'C_PERCENTAGE', 40);
1172: l_amount := null;
1173: l_percentage := p_amount;

Line 1170: p_amount_type = pay_pss_tx_steps_pkg.C_PERCENTAGE_ONLY then

1166: --
1167: -- Set up Percent/Amount validation.
1168: --
1169: if p_amount_type = pay_pss_tx_steps_pkg.C_PERCENTAGE or
1170: p_amount_type = pay_pss_tx_steps_pkg.C_PERCENTAGE_ONLY then
1171: seterrorstage(l_proc, 'C_PERCENTAGE', 40);
1172: l_amount := null;
1173: l_percentage := p_amount;
1174: elsif p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY or

Line 1174: elsif p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY or

1170: p_amount_type = pay_pss_tx_steps_pkg.C_PERCENTAGE_ONLY then
1171: seterrorstage(l_proc, 'C_PERCENTAGE', 40);
1172: l_amount := null;
1173: l_percentage := p_amount;
1174: elsif p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY or
1175: p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY_ONLY then
1176: seterrorstage(l_proc, 'C_MONETARY', 50);
1177: l_amount := p_amount;
1178: l_percentage := null;

Line 1175: p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY_ONLY then

1171: seterrorstage(l_proc, 'C_PERCENTAGE', 40);
1172: l_amount := null;
1173: l_percentage := p_amount;
1174: elsif p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY or
1175: p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY_ONLY then
1176: seterrorstage(l_proc, 'C_MONETARY', 50);
1177: l_amount := p_amount;
1178: l_percentage := null;
1179: elsif p_amount_type = pay_pss_tx_steps_pkg.C_REMAINING_PAY then

Line 1179: elsif p_amount_type = pay_pss_tx_steps_pkg.C_REMAINING_PAY then

1175: p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY_ONLY then
1176: seterrorstage(l_proc, 'C_MONETARY', 50);
1177: l_amount := p_amount;
1178: l_percentage := null;
1179: elsif p_amount_type = pay_pss_tx_steps_pkg.C_REMAINING_PAY then
1180: --
1181: -- Handled as 100%.
1182: --
1183: seterrorstage(l_proc, 'C_REMAINING_PAY', 60);

Line 1206: if p_state = pay_pss_tx_steps_pkg.C_STATE_NEW then

1202: end if;
1203: --
1204: -- Set up the business_group_id for the INSERT and UPDATE operations.
1205: --
1206: if p_state = pay_pss_tx_steps_pkg.C_STATE_NEW then
1207: --
1208: -- Check for (fatal) business_group_id error. If this error
1209: -- occurs then the module is broken.
1210: --

Line 1230: elsif p_state = pay_pss_tx_steps_pkg.C_STATE_UPDATED then

1226: close csr_asg_busgrp;
1227: end if;
1228: raise;
1229: end;
1230: elsif p_state = pay_pss_tx_steps_pkg.C_STATE_UPDATED then
1231: --
1232: -- Check for (fatal) business_group_id error. If this error
1233: -- occurs then the module is broken.
1234: --

Line 1335: if p_state = pay_pss_tx_steps_pkg.C_STATE_NEW then

1331: );
1332: --
1333: -- Do initial checks specific to each operation.
1334: --
1335: if p_state = pay_pss_tx_steps_pkg.C_STATE_NEW then
1336: --
1337: -- Do the record locking. If this code fails then it is fatal
1338: -- error within the module.
1339: --

Line 1382: elsif p_state = pay_pss_tx_steps_pkg.C_STATE_UPDATED then

1378: exception
1379: when others then
1380: raise;
1381: end;
1382: elsif p_state = pay_pss_tx_steps_pkg.C_STATE_UPDATED then
1383: --
1384: -- Do the record locking. If this code fails then it is fatal
1385: -- error within the module.
1386: --

Line 1426: if p_payment_type = pay_pss_tx_steps_pkg.C_DEPOSIT then

1422: --
1423: seterrorstage(l_proc, 'VALIDATE_BANK_SEGMENTS', 150);
1424: begin
1425: --
1426: if p_payment_type = pay_pss_tx_steps_pkg.C_DEPOSIT then
1427: --
1428: -- The OA key flex code inserts into the combination table: therefore,
1429: -- p_external_account_id refers to an existing row in
1430: -- PAY_EXTERNAL_ACCOUNTS.

Line 1642: if p_amount_type = pay_pss_tx_steps_pkg.C_PERCENTAGE or

1638: --
1639: -- Choose more specific messages based on whether or not
1640: -- the configuration is for percent only or amount only.
1641: --
1642: if p_amount_type = pay_pss_tx_steps_pkg.C_PERCENTAGE or
1643: p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY then
1644: fnd_msg_pub.add;
1645: else
1646: fnd_message.set_name('PER', 'HR_WEB_REQUIRED_FIELD');

Line 1643: p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY then

1639: -- Choose more specific messages based on whether or not
1640: -- the configuration is for percent only or amount only.
1641: --
1642: if p_amount_type = pay_pss_tx_steps_pkg.C_PERCENTAGE or
1643: p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY then
1644: fnd_msg_pub.add;
1645: else
1646: fnd_message.set_name('PER', 'HR_WEB_REQUIRED_FIELD');
1647: fnd_msg_pub.add;

Line 1824: if p_amount_type = pay_pss_tx_steps_pkg.C_PERCENTAGE or

1820: l_personal_payment_method_id := p_personal_payment_method_id;
1821: --
1822: -- Set Percentage/Amount.
1823: --
1824: if p_amount_type = pay_pss_tx_steps_pkg.C_PERCENTAGE or
1825: p_amount_type = pay_pss_tx_steps_pkg.C_PERCENTAGE_ONLY then
1826: l_percentage := p_amount;
1827: l_amount := null;
1828: elsif p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY or

Line 1825: p_amount_type = pay_pss_tx_steps_pkg.C_PERCENTAGE_ONLY then

1821: --
1822: -- Set Percentage/Amount.
1823: --
1824: if p_amount_type = pay_pss_tx_steps_pkg.C_PERCENTAGE or
1825: p_amount_type = pay_pss_tx_steps_pkg.C_PERCENTAGE_ONLY then
1826: l_percentage := p_amount;
1827: l_amount := null;
1828: elsif p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY or
1829: p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY_ONLY then

Line 1828: elsif p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY or

1824: if p_amount_type = pay_pss_tx_steps_pkg.C_PERCENTAGE or
1825: p_amount_type = pay_pss_tx_steps_pkg.C_PERCENTAGE_ONLY then
1826: l_percentage := p_amount;
1827: l_amount := null;
1828: elsif p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY or
1829: p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY_ONLY then
1830: l_percentage := null;
1831: l_amount := p_amount;
1832:

Line 1829: p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY_ONLY then

1825: p_amount_type = pay_pss_tx_steps_pkg.C_PERCENTAGE_ONLY then
1826: l_percentage := p_amount;
1827: l_amount := null;
1828: elsif p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY or
1829: p_amount_type = pay_pss_tx_steps_pkg.C_MONETARY_ONLY then
1830: l_percentage := null;
1831: l_amount := p_amount;
1832:
1833: --

Line 1844: if p_state = pay_pss_tx_steps_pkg.C_STATE_NEW then

1840: end if;
1841: --
1842: -- Check the PPM state to determine which API call to make.
1843: --
1844: if p_state = pay_pss_tx_steps_pkg.C_STATE_NEW then
1845: hr_personal_pay_method_api.create_personal_pay_method
1846: (p_validate => p_validate
1847: ,p_effective_date => p_effective_date
1848: ,p_assignment_id => p_assignment_id

Line 1913: elsif p_state = pay_pss_tx_steps_pkg.C_STATE_UPDATED then

1909: ,p_effective_start_date => l_effective_start_date
1910: ,p_effective_end_date => l_effective_end_date
1911: ,p_comment_id => l_comment_id
1912: );
1913: elsif p_state = pay_pss_tx_steps_pkg.C_STATE_UPDATED then
1914: hr_personal_pay_method_api.update_personal_pay_method
1915: (p_validate => p_validate
1916: ,p_effective_date => p_effective_date
1917: ,p_datetrack_update_mode => p_update_datetrack_mode

Line 1980: elsif p_state = pay_pss_tx_steps_pkg.C_STATE_DELETED then

1976: ,p_effective_start_date => l_effective_start_date
1977: ,p_effective_end_date => l_effective_end_date
1978: ,p_comment_id => l_comment_id
1979: );
1980: elsif p_state = pay_pss_tx_steps_pkg.C_STATE_DELETED then
1981: l_object_version_number := p_delete_ovn;
1982: if p_delete_datetrack_mode = hr_api.g_zap then
1983: l_effective_date := p_effective_date;
1984: else

Line 1996: elsif p_state = pay_pss_tx_steps_pkg.C_STATE_EXISTING and

1992: ,p_object_version_number => l_object_version_number
1993: ,p_effective_start_date => l_effective_start_date
1994: ,p_effective_end_date => l_effective_end_date
1995: );
1996: elsif p_state = pay_pss_tx_steps_pkg.C_STATE_EXISTING and
1997: p_real_priority <> p_o_real_priority then
1998: hr_personal_pay_method_api.update_personal_pay_method
1999: (p_validate => p_validate
2000: ,p_personal_payment_method_id => p_personal_payment_method_id