DBA Data[Home] [Help]

APPS.JTF_RS_RES_SSWA_PUB dependencies on FND_MESSAGE

Line 540: fnd_message.set_name('JTF','JTF_RS_HR_API_ERROR');

536: WHEN hr_api_error
537: THEN
538: ROLLBACK TO cr_emp_save;
539: x_return_status := fnd_api.g_ret_sts_error;
540: fnd_message.set_name('JTF','JTF_RS_HR_API_ERROR');
541: fnd_message.set_token('P_SQLERRM',substr(SQLERRM,11));
542: FND_MSG_PUB.add;
543: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
544: when fnd_api.g_exc_unexpected_error

Line 541: fnd_message.set_token('P_SQLERRM',substr(SQLERRM,11));

537: THEN
538: ROLLBACK TO cr_emp_save;
539: x_return_status := fnd_api.g_ret_sts_error;
540: fnd_message.set_name('JTF','JTF_RS_HR_API_ERROR');
541: fnd_message.set_token('P_SQLERRM',substr(SQLERRM,11));
542: FND_MSG_PUB.add;
543: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
544: when fnd_api.g_exc_unexpected_error
545: then

Line 552: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

548: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
549: when others
550: then
551: rollback to cr_emp_save;
552: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
553: fnd_message.set_token('P_SQLCODE',SQLCODE);
554: fnd_message.set_token('P_SQLERRM',SQLERRM);
555: fnd_message.set_token('P_API_NAME',l_api_name);
556: FND_MSG_PUB.add;

Line 553: fnd_message.set_token('P_SQLCODE',SQLCODE);

549: when others
550: then
551: rollback to cr_emp_save;
552: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
553: fnd_message.set_token('P_SQLCODE',SQLCODE);
554: fnd_message.set_token('P_SQLERRM',SQLERRM);
555: fnd_message.set_token('P_API_NAME',l_api_name);
556: FND_MSG_PUB.add;
557: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 554: fnd_message.set_token('P_SQLERRM',SQLERRM);

550: then
551: rollback to cr_emp_save;
552: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
553: fnd_message.set_token('P_SQLCODE',SQLCODE);
554: fnd_message.set_token('P_SQLERRM',SQLERRM);
555: fnd_message.set_token('P_API_NAME',l_api_name);
556: FND_MSG_PUB.add;
557: x_return_status := fnd_api.g_ret_sts_unexp_error;
558: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 555: fnd_message.set_token('P_API_NAME',l_api_name);

551: rollback to cr_emp_save;
552: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
553: fnd_message.set_token('P_SQLCODE',SQLCODE);
554: fnd_message.set_token('P_SQLERRM',SQLERRM);
555: fnd_message.set_token('P_API_NAME',l_api_name);
556: FND_MSG_PUB.add;
557: x_return_status := fnd_api.g_ret_sts_unexp_error;
558: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
559:

Line 1956: fnd_message.set_name ('JTF', 'JTF_RS_UPDATED');

1952: -- notification/apporval and atleast one field has
1953: -- full update
1954: if(l_u=1 and l_uwa=0 and l_uwn=0)
1955: then
1956: fnd_message.set_name ('JTF', 'JTF_RS_UPDATED');
1957: FND_MSG_PUB.add;
1958: else
1959: if(p_approved = 'A')
1960: then

Line 1961: fnd_message.set_name ('JTF', 'JTF_RS_WF_APPROVAL');

1957: FND_MSG_PUB.add;
1958: else
1959: if(p_approved = 'A')
1960: then
1961: fnd_message.set_name ('JTF', 'JTF_RS_WF_APPROVAL');
1962: fnd_message.set_token('P_MGR',l_mgr_name);
1963: FND_MSG_PUB.add;
1964: elsif(p_approved= 'T')
1965: then

Line 1962: fnd_message.set_token('P_MGR',l_mgr_name);

1958: else
1959: if(p_approved = 'A')
1960: then
1961: fnd_message.set_name ('JTF', 'JTF_RS_WF_APPROVAL');
1962: fnd_message.set_token('P_MGR',l_mgr_name);
1963: FND_MSG_PUB.add;
1964: elsif(p_approved= 'T')
1965: then
1966: fnd_message.set_name ('JTF', 'JTF_RS_WF_NOTIF');

Line 1966: fnd_message.set_name ('JTF', 'JTF_RS_WF_NOTIF');

1962: fnd_message.set_token('P_MGR',l_mgr_name);
1963: FND_MSG_PUB.add;
1964: elsif(p_approved= 'T')
1965: then
1966: fnd_message.set_name ('JTF', 'JTF_RS_WF_NOTIF');
1967: fnd_message.set_token('P_MGR',l_mgr_name);
1968: FND_MSG_PUB.add;
1969: fnd_message.set_name ('JTF', 'JTF_RS_UPDATED');
1970: FND_MSG_PUB.add;

Line 1967: fnd_message.set_token('P_MGR',l_mgr_name);

1963: FND_MSG_PUB.add;
1964: elsif(p_approved= 'T')
1965: then
1966: fnd_message.set_name ('JTF', 'JTF_RS_WF_NOTIF');
1967: fnd_message.set_token('P_MGR',l_mgr_name);
1968: FND_MSG_PUB.add;
1969: fnd_message.set_name ('JTF', 'JTF_RS_UPDATED');
1970: FND_MSG_PUB.add;
1971: elsif((p_approved='TE') OR (p_approved = 'AE') OR

Line 1969: fnd_message.set_name ('JTF', 'JTF_RS_UPDATED');

1965: then
1966: fnd_message.set_name ('JTF', 'JTF_RS_WF_NOTIF');
1967: fnd_message.set_token('P_MGR',l_mgr_name);
1968: FND_MSG_PUB.add;
1969: fnd_message.set_name ('JTF', 'JTF_RS_UPDATED');
1970: FND_MSG_PUB.add;
1971: elsif((p_approved='TE') OR (p_approved = 'AE') OR
1972: (l_u=1 AND l_uwa=1 AND l_uwn=0))
1973: then

Line 1974: fnd_message.set_name ('JTF', 'JTF_RS_UPDATED');

1970: FND_MSG_PUB.add;
1971: elsif((p_approved='TE') OR (p_approved = 'AE') OR
1972: (l_u=1 AND l_uwa=1 AND l_uwn=0))
1973: then
1974: fnd_message.set_name ('JTF', 'JTF_RS_UPDATED');
1975: FND_MSG_PUB.add;
1976: end if;
1977: end if;
1978:

Line 1981: fnd_message.set_name ('JTF', 'JTF_RS_NO_CHANGES');

1977: end if;
1978:
1979: if((l_u = 0) AND (l_uwn = 0) AND (l_uwa = 0) AND (p_approved = 'N'))
1980: then
1981: fnd_message.set_name ('JTF', 'JTF_RS_NO_CHANGES');
1982: FND_MSG_PUB.add;
1983: elsif((l_uwa= 1) AND (old_rec.source_mgr_id is not null))
1984: then
1985: open mgr_user(old_rec.source_mgr_id);

Line 1989: fnd_message.set_name ('JTF', 'JTF_RS_WF_APPROVAL');

1985: open mgr_user(old_rec.source_mgr_id);
1986: fetch mgr_user into l_mgr_user_id ;
1987: if(mgr_user%found)
1988: then
1989: fnd_message.set_name ('JTF', 'JTF_RS_WF_APPROVAL');
1990: fnd_message.set_token('P_MGR',l_mgr_name);
1991: FND_MSG_PUB.add;
1992: end if;
1993: close mgr_user;

Line 1990: fnd_message.set_token('P_MGR',l_mgr_name);

1986: fetch mgr_user into l_mgr_user_id ;
1987: if(mgr_user%found)
1988: then
1989: fnd_message.set_name ('JTF', 'JTF_RS_WF_APPROVAL');
1990: fnd_message.set_token('P_MGR',l_mgr_name);
1991: FND_MSG_PUB.add;
1992: end if;
1993: close mgr_user;
1994: end if;

Line 2006: fnd_message.set_name('JTF','JTF_RS_HR_API_ERROR');

2002: WHEN hr_api_error
2003: THEN
2004: ROLLBACK TO sp_save;
2005: x_return_status := fnd_api.g_ret_sts_error;
2006: fnd_message.set_name('JTF','JTF_RS_HR_API_ERROR');
2007: fnd_message.set_token('P_SQLERRM',substr(SQLERRM,11));
2008: FND_MSG_PUB.add;
2009: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2010: WHEN fnd_api.g_exc_unexpected_error

Line 2007: fnd_message.set_token('P_SQLERRM',substr(SQLERRM,11));

2003: THEN
2004: ROLLBACK TO sp_save;
2005: x_return_status := fnd_api.g_ret_sts_error;
2006: fnd_message.set_name('JTF','JTF_RS_HR_API_ERROR');
2007: fnd_message.set_token('P_SQLERRM',substr(SQLERRM,11));
2008: FND_MSG_PUB.add;
2009: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2010: WHEN fnd_api.g_exc_unexpected_error
2011: THEN

Line 2024: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

2020:
2021: WHEN OTHERS
2022: THEN
2023: ROLLBACK TO sp_save;
2024: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2025: fnd_message.set_token('P_SQLCODE',SQLCODE);
2026: fnd_message.set_token('P_SQLERRM',SQLERRM);
2027: fnd_message.set_token('P_API_NAME',l_api_name);
2028: FND_MSG_PUB.add;

Line 2025: fnd_message.set_token('P_SQLCODE',SQLCODE);

2021: WHEN OTHERS
2022: THEN
2023: ROLLBACK TO sp_save;
2024: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2025: fnd_message.set_token('P_SQLCODE',SQLCODE);
2026: fnd_message.set_token('P_SQLERRM',SQLERRM);
2027: fnd_message.set_token('P_API_NAME',l_api_name);
2028: FND_MSG_PUB.add;
2029: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2026: fnd_message.set_token('P_SQLERRM',SQLERRM);

2022: THEN
2023: ROLLBACK TO sp_save;
2024: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2025: fnd_message.set_token('P_SQLCODE',SQLCODE);
2026: fnd_message.set_token('P_SQLERRM',SQLERRM);
2027: fnd_message.set_token('P_API_NAME',l_api_name);
2028: FND_MSG_PUB.add;
2029: x_return_status := fnd_api.g_ret_sts_unexp_error;
2030: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 2027: fnd_message.set_token('P_API_NAME',l_api_name);

2023: ROLLBACK TO sp_save;
2024: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2025: fnd_message.set_token('P_SQLCODE',SQLCODE);
2026: fnd_message.set_token('P_SQLERRM',SQLERRM);
2027: fnd_message.set_token('P_API_NAME',l_api_name);
2028: FND_MSG_PUB.add;
2029: x_return_status := fnd_api.g_ret_sts_unexp_error;
2030: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2031: END update_resource;