DBA Data[Home] [Help]

APPS.JTF_RS_RES_SSWA_PUB dependencies on FND_MSG_PUB

Line 217: fnd_msg_pub.Initialize;

213:
214: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
215: if fnd_api.tO_BOOLEAN(p_init_msg_list)
216: then
217: fnd_msg_pub.Initialize;
218: end if;
219:
220: l_employee_number := p_employee_number;
221:

Line 542: FND_MSG_PUB.add;

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
546: rollback to cr_emp_save;

Line 543: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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
546: rollback to cr_emp_save;
547: x_return_status := fnd_api.g_ret_sts_error;

Line 548: 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
546: rollback to cr_emp_save;
547: x_return_status := fnd_api.g_ret_sts_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');

Line 556: FND_MSG_PUB.add;

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:
560: END create_emp_resource;

Line 558: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
560: END create_emp_resource;
561:
562: PROCEDURE update_resource

Line 909: FND_MSG_PUB.Initialize;

905: x_return_status := fnd_api.g_ret_sts_success;
906: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
907: IF FND_API.To_boolean(P_INIT_MSG_LIST)
908: THEN
909: FND_MSG_PUB.Initialize;
910: END IF;
911: SAVEPOINT sp_save;
912: IF(P_APPROVED='NR')
913: THEN

Line 1957: FND_MSG_PUB.add;

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
1961: fnd_message.set_name ('JTF', 'JTF_RS_WF_APPROVAL');

Line 1963: FND_MSG_PUB.add;

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');
1967: fnd_message.set_token('P_MGR',l_mgr_name);

Line 1968: 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
1972: (l_u=1 AND l_uwa=1 AND l_uwn=0))

Line 1970: FND_MSG_PUB.add;

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
1974: fnd_message.set_name ('JTF', 'JTF_RS_UPDATED');

Line 1975: 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:
1979: if((l_u = 0) AND (l_uwn = 0) AND (l_uwa = 0) AND (p_approved = 'N'))

Line 1982: FND_MSG_PUB.add;

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);
1986: fetch mgr_user into l_mgr_user_id ;

Line 1991: FND_MSG_PUB.add;

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

Line 1996: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1992: end if;
1993: close mgr_user;
1994: end if;
1995:
1996: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1997: else
1998: ROLLBACK TO sp_save;
1999: end if;
2000:

Line 2008: FND_MSG_PUB.add;

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
2012: ROLLBACK TO sp_save;

Line 2009: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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
2012: ROLLBACK TO sp_save;
2013: x_return_status := fnd_api.g_ret_sts_error;

Line 2014: 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
2012: ROLLBACK TO sp_save;
2013: x_return_status := fnd_api.g_ret_sts_error;
2014: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2015: WHEN fnd_api.g_exc_error
2016: THEN
2017: ROLLBACK TO sp_save;
2018: x_return_status := fnd_api.g_ret_sts_error;

Line 2019: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2015: WHEN fnd_api.g_exc_error
2016: THEN
2017: ROLLBACK TO sp_save;
2018: x_return_status := fnd_api.g_ret_sts_error;
2019: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2020:
2021: WHEN OTHERS
2022: THEN
2023: ROLLBACK TO sp_save;

Line 2028: FND_MSG_PUB.add;

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

Line 2030: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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;
2032:
2033:
2034: