DBA Data[Home] [Help]

APPS.PAY_PPMV4_SS dependencies on FND_MESSAGE

Line 140: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');

136: ,p_success => l_success
137: );
138: if not l_success then
139: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'EXIT:FAIL:1', 25);
140: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
141: fnd_message.set_token('WHERE', l_proc);
142: fnd_message.set_token('ADDITIONAL_INFO', '');
143: fnd_msg_pub.add;
144: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

Line 141: fnd_message.set_token('WHERE', l_proc);

137: );
138: if not l_success then
139: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'EXIT:FAIL:1', 25);
140: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
141: fnd_message.set_token('WHERE', l_proc);
142: fnd_message.set_token('ADDITIONAL_INFO', '');
143: fnd_msg_pub.add;
144: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
145: fnd_msg_pub.count_and_get

Line 142: fnd_message.set_token('ADDITIONAL_INFO', '');

138: if not l_success then
139: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'EXIT:FAIL:1', 25);
140: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
141: fnd_message.set_token('WHERE', l_proc);
142: fnd_message.set_token('ADDITIONAL_INFO', '');
143: fnd_msg_pub.add;
144: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
145: fnd_msg_pub.count_and_get
146: (p_count => p_msg_count

Line 179: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');

175: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'EXIT:SUCCESS', 40);
176: exception
177: when others then
178: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'EXIT:FAIL:2', 50);
179: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
180: fnd_message.set_token('WHERE', l_proc);
181: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
182: fnd_msg_pub.add;
183: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

Line 180: fnd_message.set_token('WHERE', l_proc);

176: exception
177: when others then
178: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'EXIT:FAIL:2', 50);
179: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
180: fnd_message.set_token('WHERE', l_proc);
181: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
182: fnd_msg_pub.add;
183: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
184: fnd_msg_pub.count_and_get

Line 181: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);

177: when others then
178: pay_ppmv4_utils_ss.seterrorstage(l_proc, 'EXIT:FAIL:2', 50);
179: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
180: fnd_message.set_token('WHERE', l_proc);
181: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
182: fnd_msg_pub.add;
183: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
184: fnd_msg_pub.count_and_get
185: (p_count => p_msg_count

Line 704: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');

700: -- are handled "for free" using checkErrors.
701: --
702: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
703: fnd_msg_pub.initialize;
704: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
705: fnd_message.set_token('WHERE', l_proc);
706: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
707: fnd_msg_pub.add;
708: fnd_msg_pub.count_and_get

Line 705: fnd_message.set_token('WHERE', l_proc);

701: --
702: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
703: fnd_msg_pub.initialize;
704: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
705: fnd_message.set_token('WHERE', l_proc);
706: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
707: fnd_msg_pub.add;
708: fnd_msg_pub.count_and_get
709: (p_count => p_msg_count

Line 706: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);

702: p_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
703: fnd_msg_pub.initialize;
704: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
705: fnd_message.set_token('WHERE', l_proc);
706: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
707: fnd_msg_pub.add;
708: fnd_msg_pub.count_and_get
709: (p_count => p_msg_count
710: ,p_data => p_msg_data

Line 893: fnd_message.set_name('PER', 'PAY_34069_NO_PAY_METHOD');

889: begin
890: execute immediate l_sql_stat into l_opmid;
891: exception
892: when others then
893: fnd_message.set_name('PER', 'PAY_34069_NO_PAY_METHOD');
894: fnd_msg_pub.add;
895: fnd_message.raise_error;
896: end;
897: --

Line 895: fnd_message.raise_error;

891: exception
892: when others then
893: fnd_message.set_name('PER', 'PAY_34069_NO_PAY_METHOD');
894: fnd_msg_pub.add;
895: fnd_message.raise_error;
896: end;
897: --
898: open csr_opms(p_assignment_id,p_effective_date,l_category,l_opmid);
899: fetch csr_opms into l_opmid;

Line 902: fnd_message.set_name('PER', 'PAY_34069_NO_PAY_METHOD');

898: open csr_opms(p_assignment_id,p_effective_date,l_category,l_opmid);
899: fetch csr_opms into l_opmid;
900: if csr_opms%notfound then
901: close csr_opms;
902: fnd_message.set_name('PER', 'PAY_34069_NO_PAY_METHOD');
903: fnd_msg_pub.add;
904: fnd_message.raise_error;
905: end if;
906: close csr_opms;

Line 904: fnd_message.raise_error;

900: if csr_opms%notfound then
901: close csr_opms;
902: fnd_message.set_name('PER', 'PAY_34069_NO_PAY_METHOD');
903: fnd_msg_pub.add;
904: fnd_message.raise_error;
905: end if;
906: close csr_opms;
907: --
908: l_found := TRUE;

Line 958: fnd_message.set_name('PER', 'PAY_52626_NO_PAYMENT_TYPES');

954: --
955: -- Output error message.
956: --
957: if not l_cash_found and not l_check_found and not l_deposit_found then
958: fnd_message.set_name('PER', 'PAY_52626_NO_PAYMENT_TYPES');
959: fnd_msg_pub.add;
960: fnd_message.raise_error;
961: end if;
962: --

Line 960: fnd_message.raise_error;

956: --
957: if not l_cash_found and not l_check_found and not l_deposit_found then
958: fnd_message.set_name('PER', 'PAY_52626_NO_PAYMENT_TYPES');
959: fnd_msg_pub.add;
960: fnd_message.raise_error;
961: end if;
962: --
963:
964: end getcustomopms;

Line 1171: fnd_message.set_name('PAY', 'PAY_50405_PSS_CFG_PROC_ERROR');

1167: --
1168: if csr_opms%isopen then
1169: close csr_opms;
1170: end if;
1171: fnd_message.set_name('PAY', 'PAY_50405_PSS_CFG_PROC_ERROR');
1172: fnd_message.set_token('STAGE', 'GET_OPMS');
1173: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
1174: fnd_msg_pub.add;
1175: fnd_message.raise_error;

Line 1172: fnd_message.set_token('STAGE', 'GET_OPMS');

1168: if csr_opms%isopen then
1169: close csr_opms;
1170: end if;
1171: fnd_message.set_name('PAY', 'PAY_50405_PSS_CFG_PROC_ERROR');
1172: fnd_message.set_token('STAGE', 'GET_OPMS');
1173: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
1174: fnd_msg_pub.add;
1175: fnd_message.raise_error;
1176: end;

Line 1173: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);

1169: close csr_opms;
1170: end if;
1171: fnd_message.set_name('PAY', 'PAY_50405_PSS_CFG_PROC_ERROR');
1172: fnd_message.set_token('STAGE', 'GET_OPMS');
1173: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
1174: fnd_msg_pub.add;
1175: fnd_message.raise_error;
1176: end;
1177: --

Line 1175: fnd_message.raise_error;

1171: fnd_message.set_name('PAY', 'PAY_50405_PSS_CFG_PROC_ERROR');
1172: fnd_message.set_token('STAGE', 'GET_OPMS');
1173: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
1174: fnd_msg_pub.add;
1175: fnd_message.raise_error;
1176: end;
1177: --
1178: -- Output error message.
1179: --

Line 1181: fnd_message.set_name('PER', 'PAY_52626_NO_PAYMENT_TYPES');

1177: --
1178: -- Output error message.
1179: --
1180: if not l_cash_found and not l_check_found and not l_deposit_found then
1181: fnd_message.set_name('PER', 'PAY_52626_NO_PAYMENT_TYPES');
1182: fnd_msg_pub.add;
1183: fnd_message.raise_error;
1184: end if;
1185: end getopms;

Line 1183: fnd_message.raise_error;

1179: --
1180: if not l_cash_found and not l_check_found and not l_deposit_found then
1181: fnd_message.set_name('PER', 'PAY_52626_NO_PAYMENT_TYPES');
1182: fnd_msg_pub.add;
1183: fnd_message.raise_error;
1184: end if;
1185: end getopms;
1186:
1187: -------------------------------< getpayrollinfo >--------------------------

Line 1437: fnd_message.set_name('PAY', 'PAY_50405_PSS_CFG_PROC_ERROR');

1433: -- Convenience procedure for raising error in the initial code.
1434: --
1435: procedure initialerror(p_stage in varchar2, p_additional_info in varchar2) is
1436: begin
1437: fnd_message.set_name('PAY', 'PAY_50405_PSS_CFG_PROC_ERROR');
1438: fnd_message.set_token('STAGE', p_stage);
1439: fnd_message.set_token('ADDITIONAL_INFO', p_additional_info);
1440: fnd_msg_pub.add;
1441: fnd_message.raise_error;

Line 1438: fnd_message.set_token('STAGE', p_stage);

1434: --
1435: procedure initialerror(p_stage in varchar2, p_additional_info in varchar2) is
1436: begin
1437: fnd_message.set_name('PAY', 'PAY_50405_PSS_CFG_PROC_ERROR');
1438: fnd_message.set_token('STAGE', p_stage);
1439: fnd_message.set_token('ADDITIONAL_INFO', p_additional_info);
1440: fnd_msg_pub.add;
1441: fnd_message.raise_error;
1442: end initialerror;

Line 1439: fnd_message.set_token('ADDITIONAL_INFO', p_additional_info);

1435: procedure initialerror(p_stage in varchar2, p_additional_info in varchar2) is
1436: begin
1437: fnd_message.set_name('PAY', 'PAY_50405_PSS_CFG_PROC_ERROR');
1438: fnd_message.set_token('STAGE', p_stage);
1439: fnd_message.set_token('ADDITIONAL_INFO', p_additional_info);
1440: fnd_msg_pub.add;
1441: fnd_message.raise_error;
1442: end initialerror;
1443: begin

Line 1441: fnd_message.raise_error;

1437: fnd_message.set_name('PAY', 'PAY_50405_PSS_CFG_PROC_ERROR');
1438: fnd_message.set_token('STAGE', p_stage);
1439: fnd_message.set_token('ADDITIONAL_INFO', p_additional_info);
1440: fnd_msg_pub.add;
1441: fnd_message.raise_error;
1442: end initialerror;
1443: begin
1444: --
1445: -- Initialise the AOL message tables.

Line 1933: fnd_message.set_name('PER', 'PAY_52626_NO_PAYMENT_TYPES');

1929: end if;
1930: end if;
1931: --
1932: if l_payment_types is null then
1933: fnd_message.set_name('PER', 'PAY_52626_NO_PAYMENT_TYPES');
1934: fnd_msg_pub.add;
1935: fnd_message.raise_error;
1936: end if;
1937: p_payment_types := l_payment_types;

Line 1935: fnd_message.raise_error;

1931: --
1932: if l_payment_types is null then
1933: fnd_message.set_name('PER', 'PAY_52626_NO_PAYMENT_TYPES');
1934: fnd_msg_pub.add;
1935: fnd_message.raise_error;
1936: end if;
1937: p_payment_types := l_payment_types;
1938: p_deposit_opmid := to_char(l_deposit_opmid);
1939: p_cash_opmid := to_char(l_cash_opmid);

Line 2039: fnd_message.set_name('PER', 'PAY_52622_FUTURE_PAYMENTS');

2035: );
2036: fetch csr_future_ppms into l_option_value;
2037: if csr_future_ppms%found then
2038: close csr_future_ppms;
2039: fnd_message.set_name('PER', 'PAY_52622_FUTURE_PAYMENTS');
2040: fnd_msg_pub.add;
2041: fnd_message.raise_error;
2042: end if;
2043: close csr_future_ppms;

Line 2041: fnd_message.raise_error;

2037: if csr_future_ppms%found then
2038: close csr_future_ppms;
2039: fnd_message.set_name('PER', 'PAY_52622_FUTURE_PAYMENTS');
2040: fnd_msg_pub.add;
2041: fnd_message.raise_error;
2042: end if;
2043: close csr_future_ppms;
2044: --
2045: -- Check for consistency between the permitted amount types and the

Line 2056: fnd_message.set_name('PER', 'PAY_52625_PPM_USES_AMOUNT');

2052: );
2053: fetch csr_monetary into l_option_value;
2054: if csr_monetary%found then
2055: close csr_monetary;
2056: fnd_message.set_name('PER', 'PAY_52625_PPM_USES_AMOUNT');
2057: fnd_msg_pub.add;
2058: fnd_message.raise_error;
2059: end if;
2060: close csr_monetary;

Line 2058: fnd_message.raise_error;

2054: if csr_monetary%found then
2055: close csr_monetary;
2056: fnd_message.set_name('PER', 'PAY_52625_PPM_USES_AMOUNT');
2057: fnd_msg_pub.add;
2058: fnd_message.raise_error;
2059: end if;
2060: close csr_monetary;
2061: elsif l_monetary_only then
2062: open csr_percentage

Line 2069: fnd_message.set_name('PER', 'PAY_52624_PPM_USES_PERCENTAGE');

2065: );
2066: fetch csr_percentage into l_option_value;
2067: if csr_percentage%found then
2068: close csr_percentage;
2069: fnd_message.set_name('PER', 'PAY_52624_PPM_USES_PERCENTAGE');
2070: fnd_msg_pub.add;
2071: fnd_message.raise_error;
2072: end if;
2073: close csr_percentage;

Line 2071: fnd_message.raise_error;

2067: if csr_percentage%found then
2068: close csr_percentage;
2069: fnd_message.set_name('PER', 'PAY_52624_PPM_USES_PERCENTAGE');
2070: fnd_msg_pub.add;
2071: fnd_message.raise_error;
2072: end if;
2073: close csr_percentage;
2074: end if;
2075: --

Line 2085: fnd_message.set_name('PER', 'PAY_52631_PPMSS_OPTION_ERROR');

2081: ,p_data => p_msg_data
2082: );
2083: return;
2084: <>
2085: fnd_message.set_name('PER', 'PAY_52631_PPMSS_OPTION_ERROR');
2086: fnd_message.set_token('OPTION', l_option);
2087: fnd_msg_pub.add;
2088: fnd_message.raise_error;
2089: exception

Line 2086: fnd_message.set_token('OPTION', l_option);

2082: );
2083: return;
2084: <>
2085: fnd_message.set_name('PER', 'PAY_52631_PPMSS_OPTION_ERROR');
2086: fnd_message.set_token('OPTION', l_option);
2087: fnd_msg_pub.add;
2088: fnd_message.raise_error;
2089: exception
2090: --

Line 2088: fnd_message.raise_error;

2084: <>
2085: fnd_message.set_name('PER', 'PAY_52631_PPMSS_OPTION_ERROR');
2086: fnd_message.set_token('OPTION', l_option);
2087: fnd_msg_pub.add;
2088: fnd_message.raise_error;
2089: exception
2090: --
2091: -- Set up the error status.
2092: --

Line 2103: fnd_message.set_name('PAY', 'PAY_50405_PSS_CFG_PROC_ERROR');

2099: (p_count => l_msg_count
2100: ,p_data => p_msg_data
2101: );
2102: if l_msg_count = 0 then
2103: fnd_message.set_name('PAY', 'PAY_50405_PSS_CFG_PROC_ERROR');
2104: fnd_message.set_token('STAGE', 'UNEXPECTED_ERROR');
2105: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
2106: fnd_msg_pub.add;
2107: fnd_msg_pub.count_and_get

Line 2104: fnd_message.set_token('STAGE', 'UNEXPECTED_ERROR');

2100: ,p_data => p_msg_data
2101: );
2102: if l_msg_count = 0 then
2103: fnd_message.set_name('PAY', 'PAY_50405_PSS_CFG_PROC_ERROR');
2104: fnd_message.set_token('STAGE', 'UNEXPECTED_ERROR');
2105: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
2106: fnd_msg_pub.add;
2107: fnd_msg_pub.count_and_get
2108: (p_count => l_msg_count

Line 2105: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);

2101: );
2102: if l_msg_count = 0 then
2103: fnd_message.set_name('PAY', 'PAY_50405_PSS_CFG_PROC_ERROR');
2104: fnd_message.set_token('STAGE', 'UNEXPECTED_ERROR');
2105: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
2106: fnd_msg_pub.add;
2107: fnd_msg_pub.count_and_get
2108: (p_count => l_msg_count
2109: ,p_data => p_msg_data

Line 3057: fnd_message.set_name('PAY', 'PAY_51519_PSS_CANNOT_DELETE');

3053: -- Handle valid DELETE failures:
3054: -- a) Prepayments exist.
3055: -- b) 3rd Party Payroll interface does not allow zap deletes.
3056: --
3057: fnd_message.set_name('PAY', 'PAY_51519_PSS_CANNOT_DELETE');
3058: fnd_msg_pub.add;
3059: p_return_status := fnd_api.G_RET_STS_ERROR;
3060: fnd_msg_pub.count_and_get
3061: (p_count => p_msg_count

Line 3134: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');

3130: --
3131: -- Set up messages to Oracle Applications API standards as these
3132: -- are handled "for free" using checkErrors().
3133: --
3134: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
3135: fnd_message.set_token('WHERE', l_proc);
3136: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
3137: fnd_msg_pub.add;
3138: p_return_status := fnd_api.G_RET_STS_ERROR;

Line 3135: fnd_message.set_token('WHERE', l_proc);

3131: -- Set up messages to Oracle Applications API standards as these
3132: -- are handled "for free" using checkErrors().
3133: --
3134: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
3135: fnd_message.set_token('WHERE', l_proc);
3136: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
3137: fnd_msg_pub.add;
3138: p_return_status := fnd_api.G_RET_STS_ERROR;
3139: fnd_msg_pub.count_and_get

Line 3136: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);

3132: -- are handled "for free" using checkErrors().
3133: --
3134: fnd_message.set_name('PAY', 'PAY_51518_PSS_ASSERT_ERROR');
3135: fnd_message.set_token('WHERE', l_proc);
3136: fnd_message.set_token('ADDITIONAL_INFO', sqlerrm);
3137: fnd_msg_pub.add;
3138: p_return_status := fnd_api.G_RET_STS_ERROR;
3139: fnd_msg_pub.count_and_get
3140: (p_count => p_msg_count