APPS.PV_USER_REGISTRATION_PKG dependencies on FND_API

Line 31: x_return_status := FND_API.G_RET_STS_SUCCESS;

27: l_wf_item_key number;
28:
29: begin
30:
31: x_return_status := FND_API.G_RET_STS_SUCCESS;
32:
33: select pv_lead_workflows_s.nextval into l_wf_item_key
34: from sys.dual;
35:

Line 70: WHEN FND_API.G_EXC_ERROR THEN

66: x_item_type := l_wf_item_type;
67: x_item_key := l_wf_item_key;
68:
69: EXCEPTION
70: WHEN FND_API.G_EXC_ERROR THEN
71: x_return_status := FND_API.G_RET_STS_ERROR;
72:
73: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE
74: ,p_count => x_msg_count

Line 71: x_return_status := FND_API.G_RET_STS_ERROR;

67: x_item_key := l_wf_item_key;
68:
69: EXCEPTION
70: WHEN FND_API.G_EXC_ERROR THEN
71: x_return_status := FND_API.G_RET_STS_ERROR;
72:
73: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE
74: ,p_count => x_msg_count
75: ,p_data => x_msg_data);

Line 73: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE

69: EXCEPTION
70: WHEN FND_API.G_EXC_ERROR THEN
71: x_return_status := FND_API.G_RET_STS_ERROR;
72:
73: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE
74: ,p_count => x_msg_count
75: ,p_data => x_msg_data);
76:
77: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 77: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

73: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE
74: ,p_count => x_msg_count
75: ,p_data => x_msg_data);
76:
77: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
79:
80: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE
81: ,p_count => x_msg_count

Line 78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

74: ,p_count => x_msg_count
75: ,p_data => x_msg_data);
76:
77: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
79:
80: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE
81: ,p_count => x_msg_count
82: ,p_data => x_msg_data);

Line 80: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE

76:
77: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
79:
80: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE
81: ,p_count => x_msg_count
82: ,p_data => x_msg_data);
83:
84: WHEN OTHERS THEN

Line 85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

81: ,p_count => x_msg_count
82: ,p_data => x_msg_data);
83:
84: WHEN OTHERS THEN
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86: fnd_msg_pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
87:
88: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE
89: ,p_count => x_msg_count

Line 88: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE

84: WHEN OTHERS THEN
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86: fnd_msg_pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
87:
88: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE
89: ,p_count => x_msg_count
90: ,p_data => x_msg_data);
91:
92: end notify_user_by_email;