29: -- Parameters :
30:
31: -- IN : p_api_version IN NUMBER Required
32: -- p_init_msg_list IN VARCHAR2 Optional
33: -- DEFAULT = FND_API.G_FALSE
34: -- p_commit IN VARCHAR2 optional
35: -- DEFAULT = FND_API.G_FALSE
36:
37: -- OUT : x_return_status OUT VARCHAR2(1)
31: -- IN : p_api_version IN NUMBER Required
32: -- p_init_msg_list IN VARCHAR2 Optional
33: -- DEFAULT = FND_API.G_FALSE
34: -- p_commit IN VARCHAR2 optional
35: -- DEFAULT = FND_API.G_FALSE
36:
37: -- OUT : x_return_status OUT VARCHAR2(1)
38: -- x_msg_count OUT NUMBER
39: -- x_msg_data OUT VARCHAR2(2000)
51:
52:
53: FUNCTION OK_TO_LAUNCH_WORKFLOW
54: ( p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
58: x_msg_data OUT NOCOPY VARCHAR2
59: ) RETURN BOOLEAN IS
67:
68:
69: /* Standard call to check for call compatibility */
70:
71: IF NOT fnd_api.compatible_api_call (l_api_version,
72: p_api_version,
73: l_api_name,
74: g_pkg_name) THEN
75: RAISE fnd_api.g_exc_unexpected_error;
71: IF NOT fnd_api.compatible_api_call (l_api_version,
72: p_api_version,
73: l_api_name,
74: g_pkg_name) THEN
75: RAISE fnd_api.g_exc_unexpected_error;
76: END IF;
77:
78:
79: /* Initialize message list if p_init_msg_list is set to TRUE */
77:
78:
79: /* Initialize message list if p_init_msg_list is set to TRUE */
80:
81: IF fnd_api.to_boolean (p_init_msg_list) THEN
82: fnd_msg_pub.initialize;
83: END IF;
84:
85:
94: p_data => x_msg_data
95: );
96:
97:
98: x_return_status := fnd_api.g_ret_sts_success;
99:
100:
101: RETURN (TRUE);
102:
101: RETURN (TRUE);
102:
103:
104: EXCEPTION
105: WHEN FND_API.G_EXC_ERROR THEN
106: ROLLBACK TO jtf_assign_wf;
107: x_return_status := FND_API.G_RET_STS_ERROR ;
108: FND_MSG_PUB.Count_And_Get
109: (
103:
104: EXCEPTION
105: WHEN FND_API.G_EXC_ERROR THEN
106: ROLLBACK TO jtf_assign_wf;
107: x_return_status := FND_API.G_RET_STS_ERROR ;
108: FND_MSG_PUB.Count_And_Get
109: (
110: p_count => x_msg_count,
111: p_data => x_msg_data
111: p_data => x_msg_data
112: );
113: RETURN (FALSE);
114:
115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: ROLLBACK TO jtf_assign_wf;
117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
118: FND_MSG_PUB.Count_And_Get
119: (
113: RETURN (FALSE);
114:
115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
116: ROLLBACK TO jtf_assign_wf;
117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
118: FND_MSG_PUB.Count_And_Get
119: (
120: p_count => x_msg_count,
121: p_data => x_msg_data
123: RETURN (FALSE);
124:
125: WHEN OTHERS THEN
126: ROLLBACK TO jtf_assign_wf;
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
128: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )THEN
129: FND_MSG_PUB.Add_Exc_Msg
130: (
131: G_PKG_NAME,