DBA Data[Home] [Help]

APPS.JTF_RS_WF_INTEGRATION_PUB dependencies on FND_MSG_PUB

Line 274: fnd_msg_pub.Initialize;

270:
271: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
272: if p_init_msg_list is not NULL and fnd_api.to_boolean(p_init_msg_list)
273: then
274: fnd_msg_pub.Initialize;
275: end if;
276:
277: /* If the resource is not attached to an fnd user */
278: -- if (p_user_id is NULL) then

Line 729: fnd_msg_pub.Initialize;

725:
726: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
727: if p_init_msg_list is not NULL and fnd_api.to_boolean(p_init_msg_list)
728: then
729: fnd_msg_pub.Initialize;
730: end if;
731:
732: OPEN res_cur;
733: FETCH res_cur INTO res_rec;

Line 1083: fnd_msg_pub.Initialize;

1079:
1080: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1081: if p_init_msg_list is not NULL and fnd_api.to_boolean(p_init_msg_list)
1082: then
1083: fnd_msg_pub.Initialize;
1084: end if;
1085:
1086: for i in res_user_role_cur LOOP
1087: Wf_local_synch.propagate_user_role(

Line 1150: fnd_msg_pub.initialize;

1146: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1147: RAISE fnd_api.g_exc_unexpected_error;
1148: END IF;
1149: IF p_init_msg_list is not NULL and fnd_api.to_boolean(p_init_msg_list) THEN
1150: fnd_msg_pub.initialize;
1151: END IF;
1152:
1153: -- if (l_start_date_active <= l_sysdate AND
1154: -- (l_end_date_active is null OR

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

1197: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
1198:
1199: ROLLBACK TO wf_int_create_resource_group;
1200: x_return_status := fnd_api.g_ret_sts_unexp_error;
1201: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1202: END;
1203:
1204:
1205: PROCEDURE update_resource_group

Line 1279: fnd_msg_pub.initialize;

1275: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1276: RAISE fnd_api.g_exc_unexpected_error;
1277: END IF;
1278: IF p_init_msg_list is not NULL and fnd_api.to_boolean(p_init_msg_list) THEN
1279: fnd_msg_pub.initialize;
1280: END IF;
1281:
1282: /* Role record exists then update if group name, email, start date
1283: or end date is changed */

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

1439: END IF;
1440:
1441: ROLLBACK TO wf_int_update_resource_group;
1442: x_return_status := fnd_api.g_ret_sts_unexp_error;
1443: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1444: END;
1445:
1446:
1447: PROCEDURE create_resource_group_members

Line 1505: fnd_msg_pub.initialize;

1501: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1502: RAISE fnd_api.g_exc_unexpected_error;
1503: END IF;
1504: IF p_init_msg_list is not NULL and fnd_api.to_boolean(p_init_msg_list) THEN
1505: fnd_msg_pub.initialize;
1506: END IF;
1507:
1508: OPEN c_grp_active(p_group_id);
1509: FETCH c_grp_active INTO l_grp_active;

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

1581: END IF;
1582:
1583: ROLLBACK TO wf_int_cr_res_grp_mbr;
1584: x_return_status := fnd_api.g_ret_sts_unexp_error;
1585: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1586: END;
1587:
1588: PROCEDURE delete_resource_group_members
1589: (P_API_VERSION IN NUMBER,

Line 1613: fnd_msg_pub.initialize;

1609: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1610: RAISE fnd_api.g_exc_unexpected_error;
1611: END IF;
1612: IF p_init_msg_list is not NULL and fnd_api.to_boolean(p_init_msg_list) THEN
1613: fnd_msg_pub.initialize;
1614: END IF;
1615:
1616: jtf_rs_wf_integration_pub.get_wf_role(P_RESOURCE_ID => P_RESOURCE_ID,
1617: X_ROLE_NAME => l_user_name,

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

1646: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
1647:
1648: ROLLBACK TO wf_int_del_res_grp_mbr;
1649: x_return_status := fnd_api.g_ret_sts_unexp_error;
1650: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1651: END;
1652:
1653: PROCEDURE create_resource_team
1654: (P_API_VERSION IN NUMBER,

Line 1684: fnd_msg_pub.initialize;

1680: g_pkg_name) THEN
1681: RAISE fnd_api.g_exc_unexpected_error;
1682: END IF;
1683: IF p_init_msg_list is not NULL and fnd_api.to_boolean(p_init_msg_list) THEN
1684: fnd_msg_pub.initialize;
1685: END IF;
1686:
1687: -- if (l_start_date_active <= l_sysdate AND
1688: -- (l_end_date_active is null OR

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

1729: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
1730:
1731: ROLLBACK TO wf_int_create_resource_team;
1732: x_return_status := fnd_api.g_ret_sts_unexp_error;
1733: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1734: END;
1735:
1736: PROCEDURE update_resource_team
1737: (P_API_VERSION IN NUMBER,

Line 1809: fnd_msg_pub.initialize;

1805: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1806: RAISE fnd_api.g_exc_unexpected_error;
1807: END IF;
1808: IF p_init_msg_list is not NULL and fnd_api.to_boolean(p_init_msg_list) THEN
1809: fnd_msg_pub.initialize;
1810: END IF;
1811:
1812: /* Role record exists then update if team name, email, start date
1813: or end date is changed */

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

1962: END IF;
1963:
1964: ROLLBACK TO wf_int_update_resource_team;
1965: x_return_status := fnd_api.g_ret_sts_unexp_error;
1966: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1967: END;
1968:
1969: PROCEDURE create_resource_team_members
1970: (P_API_VERSION IN NUMBER,

Line 2037: fnd_msg_pub.initialize;

2033: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2034: RAISE fnd_api.g_exc_unexpected_error;
2035: END IF;
2036: IF p_init_msg_list is not NULL and fnd_api.to_boolean(p_init_msg_list) THEN
2037: fnd_msg_pub.initialize;
2038: END IF;
2039:
2040: OPEN c_team_active(p_team_id);
2041: FETCH c_team_active INTO l_team_active;

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

2165: END IF;
2166:
2167: ROLLBACK TO wf_int_cr_res_team_mbr;
2168: x_return_status := fnd_api.g_ret_sts_unexp_error;
2169: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2170: END;
2171:
2172:
2173: PROCEDURE delete_resource_team_members

Line 2200: fnd_msg_pub.initialize;

2196: g_pkg_name) THEN
2197: RAISE fnd_api.g_exc_unexpected_error;
2198: END IF;
2199: IF p_init_msg_list is not NULL and fnd_api.to_boolean(p_init_msg_list) THEN
2200: fnd_msg_pub.initialize;
2201: END IF;
2202:
2203: IF (P_RESOURCE_ID is not null) THEN
2204: jtf_rs_wf_integration_pub.get_wf_role(P_RESOURCE_ID => P_RESOURCE_ID,

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

2245: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
2246:
2247: ROLLBACK TO wf_int_del_res_team_mbr;
2248: x_return_status := fnd_api.g_ret_sts_unexp_error;
2249: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2250: END;
2251:
2252: END jtf_rs_wf_integration_pub;