APPS.IEM_DP_NOTIFICATION_WF_PUB dependencies on FND_API

Line 79: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

75: --Standard Savepoint
76: SAVEPOINT IEM_LAUNCH_WF_DPNTF_PUB;
77:
78: -- Standard call to check for call compatibility.
79: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
80: p_api_version_number,
81: l_api_name,
82: G_PKG_NAME)
83: THEN

Line 84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

80: p_api_version_number,
81: l_api_name,
82: G_PKG_NAME)
83: THEN
84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86:
87: --Initialize the message list if p_init_msg_list is set to TRUE
88: If FND_API.to_Boolean(p_init_msg_list) THEN

Line 88: If FND_API.to_Boolean(p_init_msg_list) THEN

84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
85: END IF;
86:
87: --Initialize the message list if p_init_msg_list is set to TRUE
88: If FND_API.to_Boolean(p_init_msg_list) THEN
89: FND_MSG_PUB.initialize;
90: END IF;
91:
92: --Initialize API status return

Line 93: x_return_status := FND_API.G_RET_STS_SUCCESS;

89: FND_MSG_PUB.initialize;
90: END IF;
91:
92: --Initialize API status return
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: --temp solution, modify when get real sequence
96: SELECT IEM_DP_PROCESS_STATUS_S1.nextval
97: INTO l_seq_id

Line 107: IF FND_API.To_Boolean(p_commit) THEN

103: ItemType =>'IEMDPNTF' ,
104: ItemKey =>l_seq_id);
105:
106: -- Standard Check Of p_commit.
107: IF FND_API.To_Boolean(p_commit) THEN
108: COMMIT WORK;
109: END IF;
110:
111: -- Standard callto get message count and if count is 1, get message info.

Line 118: WHEN FND_API.G_EXC_ERROR THEN

114: p_data => x_msg_data
115: );
116: EXCEPTION
117:
118: WHEN FND_API.G_EXC_ERROR THEN
119:
120: ROLLBACK TO IEM_LAUNCH_WF_DPNTF_PUB;
121: x_return_status := FND_API.G_RET_STS_ERROR ;
122: FND_MSG_PUB.Count_And_Get

Line 121: x_return_status := FND_API.G_RET_STS_ERROR ;

117:
118: WHEN FND_API.G_EXC_ERROR THEN
119:
120: ROLLBACK TO IEM_LAUNCH_WF_DPNTF_PUB;
121: x_return_status := FND_API.G_RET_STS_ERROR ;
122: FND_MSG_PUB.Count_And_Get
123: ( p_count => x_msg_count,
124: p_data => x_msg_data
125: );

Line 126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

122: FND_MSG_PUB.Count_And_Get
123: ( p_count => x_msg_count,
124: p_data => x_msg_data
125: );
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
127:
128: ROLLBACK TO IEM_LAUNCH_WF_DPNTF_PUB;
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
130: FND_MSG_PUB.Count_And_Get

Line 129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

125: );
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
127:
128: ROLLBACK TO IEM_LAUNCH_WF_DPNTF_PUB;
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
130: FND_MSG_PUB.Count_And_Get
131: ( p_count => x_msg_count,
132: p_data => x_msg_data
133: );

Line 137: x_return_status := FND_API.G_RET_STS_ERROR;

133: );
134: WHEN OTHERS THEN
135:
136: ROLLBACK TO IEM_LAUNCH_WF_DPNTF_PUB;
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: IF FND_MSG_PUB.Check_Msg_Level
139: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
140: THEN
141: FND_MSG_PUB.Add_Exc_Msg