APPS.EAM_SAFETY_ASSET_NUMBER_PUB dependencies on FND_API

Line 30: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

26: /*Procedure to create or update asset/instance safety lookups-positional asset/lockout device*/
27: PROCEDURE CREATEUPDATE_ASSET_SAFETY_INFO
28: (
29: p_api_version IN NUMBER
30: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
31: ,p_eAM_asset_safety_tbl IN EAM_SAFETY_ASSET_NUMBER_PUB.eam_asset_safety_info_tbl_type
32: ,x_return_status OUT NOCOPY VARCHAR2
33: ,x_msg_count OUT NOCOPY NUMBER
34: ,x_msg_data OUT NOCOPY VARCHAR2

Line 57: IF NOT FND_API.Compatible_API_Call (l_api_version,

53:
54: SAVEPOINT CREATEUPDATE_ASSET_SAFETY_INFO;
55:
56: -- Standard call to check for call compatibility.
57: IF NOT FND_API.Compatible_API_Call (l_api_version,
58: p_api_version,
59: l_api_name ,
60: G_PKG_NAME ) THEN
61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

57: IF NOT FND_API.Compatible_API_Call (l_api_version,
58: p_api_version,
59: l_api_name ,
60: G_PKG_NAME ) THEN
61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
62: END IF;
63:
64: -- Initialize API return status to success
65: x_return_status := fnd_api.g_ret_sts_success;

Line 65: x_return_status := fnd_api.g_ret_sts_success;

61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
62: END IF;
63:
64: -- Initialize API return status to success
65: x_return_status := fnd_api.g_ret_sts_success;
66:
67: FND_MSG_PUB.initialize;
68:
69:

Line 78: OR p_eAM_asset_safety_tbl(i).instance_id = FND_API.G_MISS_NUM THEN

74:
75: BEGIN
76:
77: IF p_eAM_asset_safety_tbl(i).instance_id IS NULL
78: OR p_eAM_asset_safety_tbl(i).instance_id = FND_API.G_MISS_NUM THEN
79: /*FND_MESSAGE.SET_NAME('CSI','CSI_ASSET_NOT_NULL');
80: FND_MSG_PUB.ADD; */
81: x_return_status := FND_API.G_RET_STS_ERROR;
82: l_error_count:=l_error_count+1;

Line 81: x_return_status := FND_API.G_RET_STS_ERROR;

77: IF p_eAM_asset_safety_tbl(i).instance_id IS NULL
78: OR p_eAM_asset_safety_tbl(i).instance_id = FND_API.G_MISS_NUM THEN
79: /*FND_MESSAGE.SET_NAME('CSI','CSI_ASSET_NOT_NULL');
80: FND_MSG_PUB.ADD; */
81: x_return_status := FND_API.G_RET_STS_ERROR;
82: l_error_count:=l_error_count+1;
83: RAISE FND_API.G_EXC_ERROR;
84: END IF;
85:

Line 83: RAISE FND_API.G_EXC_ERROR;

79: /*FND_MESSAGE.SET_NAME('CSI','CSI_ASSET_NOT_NULL');
80: FND_MSG_PUB.ADD; */
81: x_return_status := FND_API.G_RET_STS_ERROR;
82: l_error_count:=l_error_count+1;
83: RAISE FND_API.G_EXC_ERROR;
84: END IF;
85:
86: /*validate Asset */
87: EAM_SAFETY_ASSET_UTL_PKG.VALIDATE_INSTANCE_NUMBER

Line 98: RAISE FND_API.G_EXC_ERROR;

94: );
95:
96: IF(l_return_status<>'S') THEN
97: l_error_count:=l_error_count+1;
98: RAISE FND_API.G_EXC_ERROR;
99: END IF;
100:
101: /*This procedure is called to validate the safety type and lookup values*/
102: EAM_SAFETY_ASSET_UTL_PKG.VALIDATE_SAFETY_INFO

Line 111: RAISE FND_API.G_EXC_ERROR;

107: );
108:
109: IF(l_return_status<>'S') THEN
110: l_error_count:=l_error_count+1;
111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
113:
114: IF l_create_update = 'U' THEN
115:

Line 121: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

117: ( p_eAM_asset_safety_rec => p_eAM_asset_safety_tbl(i)
118: ,x_return_status => l_return_status
119: );
120:
121: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
122: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
123: l_error_count:=l_error_count+1;
124: -- Continue processing other records
125: RAISE FND_API.G_EXC_ERROR;

Line 122: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);

118: ,x_return_status => l_return_status
119: );
120:
121: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
122: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
123: l_error_count:=l_error_count+1;
124: -- Continue processing other records
125: RAISE FND_API.G_EXC_ERROR;
126: END IF;

Line 125: RAISE FND_API.G_EXC_ERROR;

121: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
122: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
123: l_error_count:=l_error_count+1;
124: -- Continue processing other records
125: RAISE FND_API.G_EXC_ERROR;
126: END IF;
127: END IF;
128: /*l_create_update = 'C' indicates that asset number safety lookup values are being entered for the first time for asset/instance */
129: IF l_create_update = 'C' THEN

Line 136: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

132: ( p_eAM_asset_safety_rec => p_eAM_asset_safety_tbl(i)
133: ,x_return_status => l_return_status
134: );
135:
136: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
137: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
138: l_error_count:=l_error_count+1;
139: RAISE FND_API.G_EXC_ERROR;
140: END IF;

Line 137: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);

133: ,x_return_status => l_return_status
134: );
135:
136: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
137: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
138: l_error_count:=l_error_count+1;
139: RAISE FND_API.G_EXC_ERROR;
140: END IF;
141: END IF;

Line 139: RAISE FND_API.G_EXC_ERROR;

135:
136: IF NOT(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
137: l_msg_data:=fnd_msg_pub.get(fnd_msg_pub.G_LAST, FND_API.G_FALSE);
138: l_error_count:=l_error_count+1;
139: RAISE FND_API.G_EXC_ERROR;
140: END IF;
141: END IF;
142:
143: EXCEPTION

Line 144: WHEN FND_API.G_EXC_ERROR THEN

140: END IF;
141: END IF;
142:
143: EXCEPTION
144: WHEN FND_API.G_EXC_ERROR THEN
145: NULL;
146: END;
147: END LOOP;
148: END IF;

Line 152: RAISE FND_API.G_EXC_ERROR;

148: END IF;
149:
150:
151: IF l_error_count > 0 THEN
152: RAISE FND_API.G_EXC_ERROR;
153: END IF;
154:
155: COMMIT WORK;
156:

Line 160: WHEN FND_API.G_EXC_ERROR THEN

156:
157:
158: EXCEPTION
159:
160: WHEN FND_API.G_EXC_ERROR THEN
161: x_return_status := FND_API.G_RET_STS_ERROR ;
162: ROLLBACK TO CREATEUPDATE_ASSET_SAFETY_INFO;
163: FND_MSG_PUB.Count_And_Get
164: ( p_encoded => FND_API.G_FALSE,

Line 161: x_return_status := FND_API.G_RET_STS_ERROR ;

157:
158: EXCEPTION
159:
160: WHEN FND_API.G_EXC_ERROR THEN
161: x_return_status := FND_API.G_RET_STS_ERROR ;
162: ROLLBACK TO CREATEUPDATE_ASSET_SAFETY_INFO;
163: FND_MSG_PUB.Count_And_Get
164: ( p_encoded => FND_API.G_FALSE,
165: p_count => x_msg_count,

Line 164: ( p_encoded => FND_API.G_FALSE,

160: WHEN FND_API.G_EXC_ERROR THEN
161: x_return_status := FND_API.G_RET_STS_ERROR ;
162: ROLLBACK TO CREATEUPDATE_ASSET_SAFETY_INFO;
163: FND_MSG_PUB.Count_And_Get
164: ( p_encoded => FND_API.G_FALSE,
165: p_count => x_msg_count,
166: p_data => x_msg_data
167: );
168:

Line 169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

165: p_count => x_msg_count,
166: p_data => x_msg_data
167: );
168:
169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171: ROLLBACK TO CREATEUPDATE_ASSET_SAFETY_INFO;
172: FND_MSG_PUB.Count_And_Get
173: ( p_encoded => FND_API.G_FALSE,

Line 170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

166: p_data => x_msg_data
167: );
168:
169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171: ROLLBACK TO CREATEUPDATE_ASSET_SAFETY_INFO;
172: FND_MSG_PUB.Count_And_Get
173: ( p_encoded => FND_API.G_FALSE,
174: p_count => x_msg_count,

Line 173: ( p_encoded => FND_API.G_FALSE,

169: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171: ROLLBACK TO CREATEUPDATE_ASSET_SAFETY_INFO;
172: FND_MSG_PUB.Count_And_Get
173: ( p_encoded => FND_API.G_FALSE,
174: p_count => x_msg_count,
175: p_data => x_msg_data
176: );
177:

Line 179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

175: p_data => x_msg_data
176: );
177:
178: WHEN OTHERS THEN
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: ROLLBACK TO CREATEUPDATE_ASSET_SAFETY_INFO;
181: IF FND_MSG_PUB.Check_Msg_Level
182: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
183: THEN

Line 190: ( p_encoded => FND_API.G_FALSE,

186: l_api_name
187: );
188: END IF;
189: FND_MSG_PUB.Count_And_Get
190: ( p_encoded => FND_API.G_FALSE,
191: p_count => x_msg_count,
192: p_data => x_msg_data
193: );
194: