eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_RM_RT_OPER_PANEL_PVT dependencies on FND_API

Line 27: p_rt_oper_panel_rec.panel_type <> FND_API.G_MISS_CHAR ) THEN

23:
24: BEGIN
25:
26: IF ( p_rt_oper_panel_rec.panel_type IS NOT NULL AND
27: p_rt_oper_panel_rec.panel_type <> FND_API.G_MISS_CHAR ) THEN
28: l_record_identifier := l_record_identifier || p_rt_oper_panel_rec.panel_type;
29: END IF;
30:
31: l_record_identifier := l_record_identifier;

Line 51: x_return_status := FND_API.G_RET_STS_SUCCESS;

47: l_return_status VARCHAR2(1);
48: l_msg_data VARCHAR2(2000);
49:
50: BEGIN
51: x_return_status := FND_API.G_RET_STS_SUCCESS;
52:
53: -- Check if a valid value is passed in p_association_type_code
54: IF ( p_association_type_code = FND_API.G_MISS_CHAR OR
55: p_association_type_code IS NULL ) THEN

Line 54: IF ( p_association_type_code = FND_API.G_MISS_CHAR OR

50: BEGIN
51: x_return_status := FND_API.G_RET_STS_SUCCESS;
52:
53: -- Check if a valid value is passed in p_association_type_code
54: IF ( p_association_type_code = FND_API.G_MISS_CHAR OR
55: p_association_type_code IS NULL ) THEN
56: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASSOC_TYPE_NULL' );
57: FND_MSG_PUB.add;
58: x_return_status := FND_API.G_RET_STS_ERROR;

Line 58: x_return_status := FND_API.G_RET_STS_ERROR;

54: IF ( p_association_type_code = FND_API.G_MISS_CHAR OR
55: p_association_type_code IS NULL ) THEN
56: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASSOC_TYPE_NULL' );
57: FND_MSG_PUB.add;
58: x_return_status := FND_API.G_RET_STS_ERROR;
59: RETURN;
60: ELSIF ( p_association_type_code <> 'OPERATION' AND
61: p_association_type_code <> 'ROUTE' ) THEN
62: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASSOC_TYPE_INVALID' );

Line 65: x_return_status := FND_API.G_RET_STS_ERROR;

61: p_association_type_code <> 'ROUTE' ) THEN
62: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASSOC_TYPE_INVALID' );
63: FND_MESSAGE.set_token( 'FIELD', p_association_type_code );
64: FND_MSG_PUB.add;
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: RETURN;
67: END IF;
68:
69: -- Check if a valid value is passed in p_object_id

Line 77: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

73: p_operation_id => p_object_id,
74: x_return_status => l_return_status,
75: x_msg_data => l_msg_data
76: );
77: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
78: FND_MESSAGE.set_name( 'AHL', l_msg_data );
79: FND_MSG_PUB.add;
80: x_return_status := FND_API.G_RET_STS_ERROR;
81: RETURN;

Line 80: x_return_status := FND_API.G_RET_STS_ERROR;

76: );
77: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
78: FND_MESSAGE.set_name( 'AHL', l_msg_data );
79: FND_MSG_PUB.add;
80: x_return_status := FND_API.G_RET_STS_ERROR;
81: RETURN;
82: END IF;
83: ELSIF (p_association_type_code = 'ROUTE') THEN
84: AHL_RM_ROUTE_UTIL.validate_route_status

Line 90: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

86: p_route_id => p_object_id,
87: x_return_status => l_return_status,
88: x_msg_data => l_msg_data
89: );
90: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
91: FND_MESSAGE.set_name( 'AHL', l_msg_data );
92: FND_MSG_PUB.add;
93: x_return_status := FND_API.G_RET_STS_ERROR;
94: RETURN;

Line 93: x_return_status := FND_API.G_RET_STS_ERROR;

89: );
90: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
91: FND_MESSAGE.set_name( 'AHL', l_msg_data );
92: FND_MSG_PUB.add;
93: x_return_status := FND_API.G_RET_STS_ERROR;
94: RETURN;
95: END IF;
96: END IF;
97:

Line 103: x_return_status := FND_API.G_RET_STS_ERROR;

99: IF ( p_rt_oper_panel_tbl.count < 1 ) THEN
100: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
101: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME1 );
102: FND_MSG_PUB.add;
103: x_return_status := FND_API.G_RET_STS_ERROR;
104: RETURN;
105: END IF;
106:
107: -- Validate DML Operation

Line 120: x_return_status := FND_API.G_RET_STS_ERROR;

116: THEN
117: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML_REC' );
118: FND_MESSAGE.set_token( 'FIELD', p_rt_oper_panel_tbl(i).dml_operation );
119: FND_MSG_PUB.add;
120: x_return_status := FND_API.G_RET_STS_ERROR;
121: RETURN;
122: END IF;
123: END LOOP;
124:

Line 137: ELSIF ( p_x_rt_oper_panel_rec.panel_type = FND_API.G_MISS_CHAR ) THEN

133:
134: BEGIN
135: IF ( p_x_rt_oper_panel_rec.panel_type IS NULL ) THEN
136: p_x_rt_oper_panel_rec.panel_type_id := NULL;
137: ELSIF ( p_x_rt_oper_panel_rec.panel_type = FND_API.G_MISS_CHAR ) THEN
138: p_x_rt_oper_panel_rec.panel_type_id := FND_API.G_MISS_CHAR;
139: END IF;
140:
141: END clear_lov_attribute_ids;

Line 138: p_x_rt_oper_panel_rec.panel_type_id := FND_API.G_MISS_CHAR;

134: BEGIN
135: IF ( p_x_rt_oper_panel_rec.panel_type IS NULL ) THEN
136: p_x_rt_oper_panel_rec.panel_type_id := NULL;
137: ELSIF ( p_x_rt_oper_panel_rec.panel_type = FND_API.G_MISS_CHAR ) THEN
138: p_x_rt_oper_panel_rec.panel_type_id := FND_API.G_MISS_CHAR;
139: END IF;
140:
141: END clear_lov_attribute_ids;
142:

Line 155: x_return_status := FND_API.G_RET_STS_SUCCESS;

151: l_return_status VARCHAR2(1);
152: l_msg_data VARCHAR2(2000);
153:
154: BEGIN
155: x_return_status := FND_API.G_RET_STS_SUCCESS;
156:
157: -- Convert / Validate panel_type_id
158: IF ( ( p_x_rt_oper_panel_rec.panel_type_id IS NOT NULL AND
159: p_x_rt_oper_panel_rec.panel_type_id <> FND_API.G_MISS_CHAR ) OR

Line 159: p_x_rt_oper_panel_rec.panel_type_id <> FND_API.G_MISS_CHAR ) OR

155: x_return_status := FND_API.G_RET_STS_SUCCESS;
156:
157: -- Convert / Validate panel_type_id
158: IF ( ( p_x_rt_oper_panel_rec.panel_type_id IS NOT NULL AND
159: p_x_rt_oper_panel_rec.panel_type_id <> FND_API.G_MISS_CHAR ) OR
160: ( p_x_rt_oper_panel_rec.panel_type IS NOT NULL AND
161: p_x_rt_oper_panel_rec.panel_type <> FND_API.G_MISS_CHAR ) ) THEN
162:
163: AHL_RM_ROUTE_UTIL.validate_lookup

Line 161: p_x_rt_oper_panel_rec.panel_type <> FND_API.G_MISS_CHAR ) ) THEN

157: -- Convert / Validate panel_type_id
158: IF ( ( p_x_rt_oper_panel_rec.panel_type_id IS NOT NULL AND
159: p_x_rt_oper_panel_rec.panel_type_id <> FND_API.G_MISS_CHAR ) OR
160: ( p_x_rt_oper_panel_rec.panel_type IS NOT NULL AND
161: p_x_rt_oper_panel_rec.panel_type <> FND_API.G_MISS_CHAR ) ) THEN
162:
163: AHL_RM_ROUTE_UTIL.validate_lookup
164: (
165: x_return_status => l_return_status,

Line 172: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

168: p_lookup_meaning => p_x_rt_oper_panel_rec.panel_type,
169: p_x_lookup_code => p_x_rt_oper_panel_rec.panel_type_id
170: );
171:
172: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
173: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
174: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PANEL_TYPE' );
175: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
176: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PANEL_TYPES' );

Line 182: p_x_rt_oper_panel_rec.panel_type = FND_API.G_MISS_CHAR ) THEN

178: FND_MESSAGE.set_name( 'AHL', l_msg_data );
179: END IF;
180:
181: IF ( p_x_rt_oper_panel_rec.panel_type IS NULL OR
182: p_x_rt_oper_panel_rec.panel_type = FND_API.G_MISS_CHAR ) THEN
183: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_panel_rec.panel_type_id ) );
184: ELSE
185: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_panel_rec.panel_type );
186: END IF;

Line 205: IF ( p_x_rt_oper_panel_rec.panel_type_id = FND_API.G_MISS_CHAR ) THEN

201:
202: BEGIN
203:
204: -- Convert G_MISS values to NULL
205: IF ( p_x_rt_oper_panel_rec.panel_type_id = FND_API.G_MISS_CHAR ) THEN
206: p_x_rt_oper_panel_rec.panel_type_id := null;
207: END IF;
208:
209: IF ( p_x_rt_oper_panel_rec.panel_type = FND_API.G_MISS_CHAR ) THEN

Line 209: IF ( p_x_rt_oper_panel_rec.panel_type = FND_API.G_MISS_CHAR ) THEN

205: IF ( p_x_rt_oper_panel_rec.panel_type_id = FND_API.G_MISS_CHAR ) THEN
206: p_x_rt_oper_panel_rec.panel_type_id := null;
207: END IF;
208:
209: IF ( p_x_rt_oper_panel_rec.panel_type = FND_API.G_MISS_CHAR ) THEN
210: p_x_rt_oper_panel_rec.panel_type := null;
211: END IF;
212:
213: IF ( p_x_rt_oper_panel_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

Line 213: IF ( p_x_rt_oper_panel_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

209: IF ( p_x_rt_oper_panel_rec.panel_type = FND_API.G_MISS_CHAR ) THEN
210: p_x_rt_oper_panel_rec.panel_type := null;
211: END IF;
212:
213: IF ( p_x_rt_oper_panel_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
214: p_x_rt_oper_panel_rec.attribute_category := null;
215: END IF;
216:
217: IF ( p_x_rt_oper_panel_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

Line 217: IF ( p_x_rt_oper_panel_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

213: IF ( p_x_rt_oper_panel_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
214: p_x_rt_oper_panel_rec.attribute_category := null;
215: END IF;
216:
217: IF ( p_x_rt_oper_panel_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
218: p_x_rt_oper_panel_rec.attribute1 := null;
219: END IF;
220:
221: IF ( p_x_rt_oper_panel_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

Line 221: IF ( p_x_rt_oper_panel_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

217: IF ( p_x_rt_oper_panel_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
218: p_x_rt_oper_panel_rec.attribute1 := null;
219: END IF;
220:
221: IF ( p_x_rt_oper_panel_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
222: p_x_rt_oper_panel_rec.attribute2 := null;
223: END IF;
224:
225: IF ( p_x_rt_oper_panel_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

Line 225: IF ( p_x_rt_oper_panel_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

221: IF ( p_x_rt_oper_panel_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
222: p_x_rt_oper_panel_rec.attribute2 := null;
223: END IF;
224:
225: IF ( p_x_rt_oper_panel_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
226: p_x_rt_oper_panel_rec.attribute3 := null;
227: END IF;
228:
229: IF ( p_x_rt_oper_panel_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

Line 229: IF ( p_x_rt_oper_panel_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

225: IF ( p_x_rt_oper_panel_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
226: p_x_rt_oper_panel_rec.attribute3 := null;
227: END IF;
228:
229: IF ( p_x_rt_oper_panel_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
230: p_x_rt_oper_panel_rec.attribute4 := null;
231: END IF;
232:
233: IF ( p_x_rt_oper_panel_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

Line 233: IF ( p_x_rt_oper_panel_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

229: IF ( p_x_rt_oper_panel_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
230: p_x_rt_oper_panel_rec.attribute4 := null;
231: END IF;
232:
233: IF ( p_x_rt_oper_panel_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
234: p_x_rt_oper_panel_rec.attribute5 := null;
235: END IF;
236:
237: IF ( p_x_rt_oper_panel_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

Line 237: IF ( p_x_rt_oper_panel_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

233: IF ( p_x_rt_oper_panel_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
234: p_x_rt_oper_panel_rec.attribute5 := null;
235: END IF;
236:
237: IF ( p_x_rt_oper_panel_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
238: p_x_rt_oper_panel_rec.attribute6 := null;
239: END IF;
240:
241: IF ( p_x_rt_oper_panel_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

Line 241: IF ( p_x_rt_oper_panel_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

237: IF ( p_x_rt_oper_panel_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
238: p_x_rt_oper_panel_rec.attribute6 := null;
239: END IF;
240:
241: IF ( p_x_rt_oper_panel_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
242: p_x_rt_oper_panel_rec.attribute7 := null;
243: END IF;
244:
245: IF ( p_x_rt_oper_panel_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

Line 245: IF ( p_x_rt_oper_panel_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

241: IF ( p_x_rt_oper_panel_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
242: p_x_rt_oper_panel_rec.attribute7 := null;
243: END IF;
244:
245: IF ( p_x_rt_oper_panel_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
246: p_x_rt_oper_panel_rec.attribute8 := null;
247: END IF;
248:
249: IF ( p_x_rt_oper_panel_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

Line 249: IF ( p_x_rt_oper_panel_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

245: IF ( p_x_rt_oper_panel_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
246: p_x_rt_oper_panel_rec.attribute8 := null;
247: END IF;
248:
249: IF ( p_x_rt_oper_panel_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
250: p_x_rt_oper_panel_rec.attribute9 := null;
251: END IF;
252:
253: IF ( p_x_rt_oper_panel_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

Line 253: IF ( p_x_rt_oper_panel_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

249: IF ( p_x_rt_oper_panel_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
250: p_x_rt_oper_panel_rec.attribute9 := null;
251: END IF;
252:
253: IF ( p_x_rt_oper_panel_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
254: p_x_rt_oper_panel_rec.attribute10 := null;
255: END IF;
256:
257: IF ( p_x_rt_oper_panel_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

Line 257: IF ( p_x_rt_oper_panel_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

253: IF ( p_x_rt_oper_panel_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
254: p_x_rt_oper_panel_rec.attribute10 := null;
255: END IF;
256:
257: IF ( p_x_rt_oper_panel_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
258: p_x_rt_oper_panel_rec.attribute11 := null;
259: END IF;
260:
261: IF ( p_x_rt_oper_panel_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

Line 261: IF ( p_x_rt_oper_panel_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

257: IF ( p_x_rt_oper_panel_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
258: p_x_rt_oper_panel_rec.attribute11 := null;
259: END IF;
260:
261: IF ( p_x_rt_oper_panel_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
262: p_x_rt_oper_panel_rec.attribute12 := null;
263: END IF;
264:
265: IF ( p_x_rt_oper_panel_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

Line 265: IF ( p_x_rt_oper_panel_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

261: IF ( p_x_rt_oper_panel_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
262: p_x_rt_oper_panel_rec.attribute12 := null;
263: END IF;
264:
265: IF ( p_x_rt_oper_panel_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
266: p_x_rt_oper_panel_rec.attribute13 := null;
267: END IF;
268:
269: IF ( p_x_rt_oper_panel_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

Line 269: IF ( p_x_rt_oper_panel_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

265: IF ( p_x_rt_oper_panel_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
266: p_x_rt_oper_panel_rec.attribute13 := null;
267: END IF;
268:
269: IF ( p_x_rt_oper_panel_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
270: p_x_rt_oper_panel_rec.attribute14 := null;
271: END IF;
272:
273: IF ( p_x_rt_oper_panel_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

Line 273: IF ( p_x_rt_oper_panel_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

269: IF ( p_x_rt_oper_panel_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
270: p_x_rt_oper_panel_rec.attribute14 := null;
271: END IF;
272:
273: IF ( p_x_rt_oper_panel_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
274: p_x_rt_oper_panel_rec.attribute15 := null;
275: END IF;
276:
277: END default_missing_attributes;

Line 339: RAISE FND_API.G_EXC_ERROR;

335: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PANEL_REC' );
336: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_panel_rec ) );
337: FND_MSG_PUB.add;
338: CLOSE get_old_rec;
339: RAISE FND_API.G_EXC_ERROR;
340: END IF;
341:
342: CLOSE get_old_rec;
343:

Line 345: IF ( p_x_rt_oper_panel_rec.panel_type_id = FND_API.G_MISS_CHAR ) THEN

341:
342: CLOSE get_old_rec;
343:
344: -- Convert G_MISS values to NULL and NULL values to Old values
345: IF ( p_x_rt_oper_panel_rec.panel_type_id = FND_API.G_MISS_CHAR ) THEN
346: p_x_rt_oper_panel_rec.panel_type_id := null;
347: ELSIF ( p_x_rt_oper_panel_rec.panel_type_id IS NULL ) THEN
348: p_x_rt_oper_panel_rec.panel_type_id := l_old_rt_oper_panel_rec.panel_type_id;
349: END IF;

Line 351: IF ( p_x_rt_oper_panel_rec.panel_type = FND_API.G_MISS_CHAR ) THEN

347: ELSIF ( p_x_rt_oper_panel_rec.panel_type_id IS NULL ) THEN
348: p_x_rt_oper_panel_rec.panel_type_id := l_old_rt_oper_panel_rec.panel_type_id;
349: END IF;
350:
351: IF ( p_x_rt_oper_panel_rec.panel_type = FND_API.G_MISS_CHAR ) THEN
352: p_x_rt_oper_panel_rec.panel_type := null;
353: ELSIF ( p_x_rt_oper_panel_rec.panel_type IS NULL ) THEN
354: p_x_rt_oper_panel_rec.panel_type := l_old_rt_oper_panel_rec.panel_type;
355: END IF;

Line 357: IF ( p_x_rt_oper_panel_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

353: ELSIF ( p_x_rt_oper_panel_rec.panel_type IS NULL ) THEN
354: p_x_rt_oper_panel_rec.panel_type := l_old_rt_oper_panel_rec.panel_type;
355: END IF;
356:
357: IF ( p_x_rt_oper_panel_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
358: p_x_rt_oper_panel_rec.attribute_category := null;
359: ELSIF ( p_x_rt_oper_panel_rec.attribute_category IS NULL ) THEN
360: p_x_rt_oper_panel_rec.attribute_category := l_old_rt_oper_panel_rec.attribute_category;
361: END IF;

Line 363: IF ( p_x_rt_oper_panel_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

359: ELSIF ( p_x_rt_oper_panel_rec.attribute_category IS NULL ) THEN
360: p_x_rt_oper_panel_rec.attribute_category := l_old_rt_oper_panel_rec.attribute_category;
361: END IF;
362:
363: IF ( p_x_rt_oper_panel_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
364: p_x_rt_oper_panel_rec.attribute1 := null;
365: ELSIF ( p_x_rt_oper_panel_rec.attribute1 IS NULL ) THEN
366: p_x_rt_oper_panel_rec.attribute1 := l_old_rt_oper_panel_rec.attribute1;
367: END IF;

Line 369: IF ( p_x_rt_oper_panel_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

365: ELSIF ( p_x_rt_oper_panel_rec.attribute1 IS NULL ) THEN
366: p_x_rt_oper_panel_rec.attribute1 := l_old_rt_oper_panel_rec.attribute1;
367: END IF;
368:
369: IF ( p_x_rt_oper_panel_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
370: p_x_rt_oper_panel_rec.attribute2 := null;
371: ELSIF ( p_x_rt_oper_panel_rec.attribute2 IS NULL ) THEN
372: p_x_rt_oper_panel_rec.attribute2 := l_old_rt_oper_panel_rec.attribute2;
373: END IF;

Line 375: IF ( p_x_rt_oper_panel_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

371: ELSIF ( p_x_rt_oper_panel_rec.attribute2 IS NULL ) THEN
372: p_x_rt_oper_panel_rec.attribute2 := l_old_rt_oper_panel_rec.attribute2;
373: END IF;
374:
375: IF ( p_x_rt_oper_panel_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
376: p_x_rt_oper_panel_rec.attribute3 := null;
377: ELSIF ( p_x_rt_oper_panel_rec.attribute3 IS NULL ) THEN
378: p_x_rt_oper_panel_rec.attribute3 := l_old_rt_oper_panel_rec.attribute3;
379: END IF;

Line 381: IF ( p_x_rt_oper_panel_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

377: ELSIF ( p_x_rt_oper_panel_rec.attribute3 IS NULL ) THEN
378: p_x_rt_oper_panel_rec.attribute3 := l_old_rt_oper_panel_rec.attribute3;
379: END IF;
380:
381: IF ( p_x_rt_oper_panel_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
382: p_x_rt_oper_panel_rec.attribute4 := null;
383: ELSIF ( p_x_rt_oper_panel_rec.attribute4 IS NULL ) THEN
384: p_x_rt_oper_panel_rec.attribute4 := l_old_rt_oper_panel_rec.attribute4;
385: END IF;

Line 387: IF ( p_x_rt_oper_panel_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

383: ELSIF ( p_x_rt_oper_panel_rec.attribute4 IS NULL ) THEN
384: p_x_rt_oper_panel_rec.attribute4 := l_old_rt_oper_panel_rec.attribute4;
385: END IF;
386:
387: IF ( p_x_rt_oper_panel_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
388: p_x_rt_oper_panel_rec.attribute5 := null;
389: ELSIF ( p_x_rt_oper_panel_rec.attribute5 IS NULL ) THEN
390: p_x_rt_oper_panel_rec.attribute5 := l_old_rt_oper_panel_rec.attribute5;
391: END IF;

Line 393: IF ( p_x_rt_oper_panel_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

389: ELSIF ( p_x_rt_oper_panel_rec.attribute5 IS NULL ) THEN
390: p_x_rt_oper_panel_rec.attribute5 := l_old_rt_oper_panel_rec.attribute5;
391: END IF;
392:
393: IF ( p_x_rt_oper_panel_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
394: p_x_rt_oper_panel_rec.attribute6 := null;
395: ELSIF ( p_x_rt_oper_panel_rec.attribute6 IS NULL ) THEN
396: p_x_rt_oper_panel_rec.attribute6 := l_old_rt_oper_panel_rec.attribute6;
397: END IF;

Line 399: IF ( p_x_rt_oper_panel_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

395: ELSIF ( p_x_rt_oper_panel_rec.attribute6 IS NULL ) THEN
396: p_x_rt_oper_panel_rec.attribute6 := l_old_rt_oper_panel_rec.attribute6;
397: END IF;
398:
399: IF ( p_x_rt_oper_panel_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
400: p_x_rt_oper_panel_rec.attribute7 := null;
401: ELSIF ( p_x_rt_oper_panel_rec.attribute7 IS NULL ) THEN
402: p_x_rt_oper_panel_rec.attribute7 := l_old_rt_oper_panel_rec.attribute7;
403: END IF;

Line 405: IF ( p_x_rt_oper_panel_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

401: ELSIF ( p_x_rt_oper_panel_rec.attribute7 IS NULL ) THEN
402: p_x_rt_oper_panel_rec.attribute7 := l_old_rt_oper_panel_rec.attribute7;
403: END IF;
404:
405: IF ( p_x_rt_oper_panel_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
406: p_x_rt_oper_panel_rec.attribute8 := null;
407: ELSIF ( p_x_rt_oper_panel_rec.attribute8 IS NULL ) THEN
408: p_x_rt_oper_panel_rec.attribute8 := l_old_rt_oper_panel_rec.attribute8;
409: END IF;

Line 411: IF ( p_x_rt_oper_panel_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

407: ELSIF ( p_x_rt_oper_panel_rec.attribute8 IS NULL ) THEN
408: p_x_rt_oper_panel_rec.attribute8 := l_old_rt_oper_panel_rec.attribute8;
409: END IF;
410:
411: IF ( p_x_rt_oper_panel_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
412: p_x_rt_oper_panel_rec.attribute9 := null;
413: ELSIF ( p_x_rt_oper_panel_rec.attribute9 IS NULL ) THEN
414: p_x_rt_oper_panel_rec.attribute9 := l_old_rt_oper_panel_rec.attribute9;
415: END IF;

Line 417: IF ( p_x_rt_oper_panel_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

413: ELSIF ( p_x_rt_oper_panel_rec.attribute9 IS NULL ) THEN
414: p_x_rt_oper_panel_rec.attribute9 := l_old_rt_oper_panel_rec.attribute9;
415: END IF;
416:
417: IF ( p_x_rt_oper_panel_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
418: p_x_rt_oper_panel_rec.attribute10 := null;
419: ELSIF ( p_x_rt_oper_panel_rec.attribute10 IS NULL ) THEN
420: p_x_rt_oper_panel_rec.attribute10 := l_old_rt_oper_panel_rec.attribute10;
421: END IF;

Line 423: IF ( p_x_rt_oper_panel_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

419: ELSIF ( p_x_rt_oper_panel_rec.attribute10 IS NULL ) THEN
420: p_x_rt_oper_panel_rec.attribute10 := l_old_rt_oper_panel_rec.attribute10;
421: END IF;
422:
423: IF ( p_x_rt_oper_panel_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
424: p_x_rt_oper_panel_rec.attribute11 := null;
425: ELSIF ( p_x_rt_oper_panel_rec.attribute11 IS NULL ) THEN
426: p_x_rt_oper_panel_rec.attribute11 := l_old_rt_oper_panel_rec.attribute11;
427: END IF;

Line 429: IF ( p_x_rt_oper_panel_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

425: ELSIF ( p_x_rt_oper_panel_rec.attribute11 IS NULL ) THEN
426: p_x_rt_oper_panel_rec.attribute11 := l_old_rt_oper_panel_rec.attribute11;
427: END IF;
428:
429: IF ( p_x_rt_oper_panel_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
430: p_x_rt_oper_panel_rec.attribute12 := null;
431: ELSIF ( p_x_rt_oper_panel_rec.attribute12 IS NULL ) THEN
432: p_x_rt_oper_panel_rec.attribute12 := l_old_rt_oper_panel_rec.attribute12;
433: END IF;

Line 435: IF ( p_x_rt_oper_panel_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

431: ELSIF ( p_x_rt_oper_panel_rec.attribute12 IS NULL ) THEN
432: p_x_rt_oper_panel_rec.attribute12 := l_old_rt_oper_panel_rec.attribute12;
433: END IF;
434:
435: IF ( p_x_rt_oper_panel_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
436: p_x_rt_oper_panel_rec.attribute13 := null;
437: ELSIF ( p_x_rt_oper_panel_rec.attribute13 IS NULL ) THEN
438: p_x_rt_oper_panel_rec.attribute13 := l_old_rt_oper_panel_rec.attribute13;
439: END IF;

Line 441: IF ( p_x_rt_oper_panel_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

437: ELSIF ( p_x_rt_oper_panel_rec.attribute13 IS NULL ) THEN
438: p_x_rt_oper_panel_rec.attribute13 := l_old_rt_oper_panel_rec.attribute13;
439: END IF;
440:
441: IF ( p_x_rt_oper_panel_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
442: p_x_rt_oper_panel_rec.attribute14 := null;
443: ELSIF ( p_x_rt_oper_panel_rec.attribute14 IS NULL ) THEN
444: p_x_rt_oper_panel_rec.attribute14 := l_old_rt_oper_panel_rec.attribute14;
445: END IF;

Line 447: IF ( p_x_rt_oper_panel_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

443: ELSIF ( p_x_rt_oper_panel_rec.attribute14 IS NULL ) THEN
444: p_x_rt_oper_panel_rec.attribute14 := l_old_rt_oper_panel_rec.attribute14;
445: END IF;
446:
447: IF ( p_x_rt_oper_panel_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
448: p_x_rt_oper_panel_rec.attribute15 := null;
449: ELSIF ( p_x_rt_oper_panel_rec.attribute15 IS NULL ) THEN
450: p_x_rt_oper_panel_rec.attribute15 := l_old_rt_oper_panel_rec.attribute15;
451: END IF;

Line 472: x_return_status := FND_API.G_RET_STS_SUCCESS;

468: l_max_rt_time_span NUMBER;
469: l_dummy VARCHAR2(1);
470:
471: BEGIN
472: x_return_status := FND_API.G_RET_STS_SUCCESS;
473:
474: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
475: l_msg_count := FND_MSG_PUB.count_msg;
476: IF l_msg_count > 0 THEN

Line 477: RAISE FND_API.G_EXC_ERROR;

473:
474: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
475: l_msg_count := FND_MSG_PUB.count_msg;
476: IF l_msg_count > 0 THEN
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479:
480: IF ( p_rt_oper_panel_rec.dml_operation = 'C' ) THEN
481: RETURN;

Line 486: p_rt_oper_panel_rec.object_version_number = FND_API.G_MISS_NUM ) THEN

482: END IF;
483:
484: -- Check if the mandatory Object Version Number column contains a null value.
485: IF ( p_rt_oper_panel_rec.object_version_number IS NULL OR
486: p_rt_oper_panel_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
487: FND_MESSAGE.set_name( 'AHL','AHL_RM_PANEL_VERSION_NULL' );
488: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_panel_rec ) );
489: FND_MSG_PUB.add;
490: END IF;

Line 494: p_rt_oper_panel_rec.rt_oper_panel_id = FND_API.G_MISS_NUM ) THEN

490: END IF;
491:
492: -- Check if the mandatory rt_oper_panel ID column contains a null value.
493: IF ( p_rt_oper_panel_rec.rt_oper_panel_id IS NULL OR
494: p_rt_oper_panel_rec.rt_oper_panel_id = FND_API.G_MISS_NUM ) THEN
495: FND_MESSAGE.set_name( 'AHL','AHL_RM_RT_OPER_PANEL_ID_NULL' );
496: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_rt_oper_panel_rec ) );
497: FND_MSG_PUB.add;
498: END IF;

Line 503: RAISE FND_API.G_EXC_ERROR;

499:
500: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
501: l_msg_count := FND_MSG_PUB.count_msg;
502: IF l_msg_count > 0 THEN
503: RAISE FND_API.G_EXC_ERROR;
504: END IF;
505:
506:
507: END validate_attributes;

Line 533: x_return_status := FND_API.G_RET_STS_SUCCESS;

529: l_rt_oper_panel_rec rt_oper_panel_rec_type;
530:
531: BEGIN
532:
533: x_return_status := FND_API.G_RET_STS_SUCCESS;
534: -- Check whether any duplicate rt_oper_panel records for the given object_ID
535: OPEN get_dup_rec( p_object_id, p_association_type_code );
536:
537: LOOP

Line 550: x_return_status := FND_API.G_RET_STS_ERROR;

546: CLOSE get_dup_rec;
547: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_RT_OPER_PANEL_DUP' );
548: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_rt_oper_panel_rec ) );
549: FND_MSG_PUB.add;
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: RETURN;
552: END IF;
553:
554: CLOSE get_dup_rec;

Line 561: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

557:
558: PROCEDURE process_rt_oper_panel
559: (
560: p_api_version IN NUMBER := 1.0,
561: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
562: p_commit IN VARCHAR2 := FND_API.G_FALSE,
563: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
564: p_default IN VARCHAR2 := FND_API.G_FALSE,
565: p_module_type IN VARCHAR2 := NULL,

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

558: PROCEDURE process_rt_oper_panel
559: (
560: p_api_version IN NUMBER := 1.0,
561: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
562: p_commit IN VARCHAR2 := FND_API.G_FALSE,
563: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
564: p_default IN VARCHAR2 := FND_API.G_FALSE,
565: p_module_type IN VARCHAR2 := NULL,
566: x_return_status OUT NOCOPY VARCHAR2,

Line 563: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

559: (
560: p_api_version IN NUMBER := 1.0,
561: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
562: p_commit IN VARCHAR2 := FND_API.G_FALSE,
563: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
564: p_default IN VARCHAR2 := FND_API.G_FALSE,
565: p_module_type IN VARCHAR2 := NULL,
566: x_return_status OUT NOCOPY VARCHAR2,
567: x_msg_count OUT NOCOPY NUMBER,

Line 564: p_default IN VARCHAR2 := FND_API.G_FALSE,

560: p_api_version IN NUMBER := 1.0,
561: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
562: p_commit IN VARCHAR2 := FND_API.G_FALSE,
563: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
564: p_default IN VARCHAR2 := FND_API.G_FALSE,
565: p_module_type IN VARCHAR2 := NULL,
566: x_return_status OUT NOCOPY VARCHAR2,
567: x_msg_count OUT NOCOPY NUMBER,
568: x_msg_data OUT NOCOPY VARCHAR2,

Line 598: x_return_status := FND_API.G_RET_STS_SUCCESS;

594: l_x_operation_rec AHL_RM_OPERATION_PVT.operation_rec_type ;
595: l_x_route_rec AHL_RM_ROUTE_PVT.route_rec_type ;
596: BEGIN
597: -- Initialize API return status to success
598: x_return_status := FND_API.G_RET_STS_SUCCESS;
599:
600: -- Standard Start of API savepoint
601: SAVEPOINT process_rt_oper_panel_pvt;
602:

Line 604: IF NOT FND_API.compatible_api_call

600: -- Standard Start of API savepoint
601: SAVEPOINT process_rt_oper_panel_pvt;
602:
603: -- Standard call to check for call compatibility.
604: IF NOT FND_API.compatible_api_call
605: (
606: l_api_version,
607: p_api_version,
608: G_API_NAME1,

Line 612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

608: G_API_NAME1,
609: G_PKG_NAME
610: )
611: THEN
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: END IF;
614:
615: -- Initialize message list if p_init_msg_list is set to TRUE.
616: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 616: IF FND_API.to_boolean( p_init_msg_list ) THEN

612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: END IF;
614:
615: -- Initialize message list if p_init_msg_list is set to TRUE.
616: IF FND_API.to_boolean( p_init_msg_list ) THEN
617: FND_MSG_PUB.initialize;
618: END IF;
619:
620: IF G_DEBUG = 'Y' THEN

Line 639: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

635: x_msg_data => x_msg_data
636: );
637:
638: -- If any severe error occurs, then, abort API.
639: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
640: RAISE FND_API.G_EXC_ERROR;
641: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
643: END IF;

Line 640: RAISE FND_API.G_EXC_ERROR;

636: );
637:
638: -- If any severe error occurs, then, abort API.
639: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
640: RAISE FND_API.G_EXC_ERROR;
641: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
643: END IF;
644: END IF ;

Line 641: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

637:
638: -- If any severe error occurs, then, abort API.
639: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
640: RAISE FND_API.G_EXC_ERROR;
641: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
643: END IF;
644: END IF ;
645:

Line 642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

638: -- If any severe error occurs, then, abort API.
639: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
640: RAISE FND_API.G_EXC_ERROR;
641: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
643: END IF;
644: END IF ;
645:
646:

Line 657: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

653: l_return_status
654: );
655:
656: -- If any severe error occurs, then, abort API.
657: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
658: RAISE FND_API.G_EXC_ERROR;
659: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
661: END IF;

Line 658: RAISE FND_API.G_EXC_ERROR;

654: );
655:
656: -- If any severe error occurs, then, abort API.
657: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
658: RAISE FND_API.G_EXC_ERROR;
659: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
661: END IF;
662:

Line 659: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

655:
656: -- If any severe error occurs, then, abort API.
657: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
658: RAISE FND_API.G_EXC_ERROR;
659: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
661: END IF;
662:
663: -- If the module type is JSP, then default values for ID columns of LOV attributes

Line 660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

656: -- If any severe error occurs, then, abort API.
657: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
658: RAISE FND_API.G_EXC_ERROR;
659: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
661: END IF;
662:
663: -- If the module type is JSP, then default values for ID columns of LOV attributes
664: IF ( p_module_type = 'JSP' ) THEN

Line 677: --IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN

673: END IF;
674:
675: -- Convert Values into Ids.
676: -- Balaji removed p_validation_level check in 11510+ as a part of public api cleanup.
677: --IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
678: FOR i IN 1..p_x_rt_oper_panel_tbl.count LOOP
679: IF ( p_x_rt_oper_panel_tbl(i).dml_operation <> 'D' ) THEN
680: convert_values_to_ids
681: (

Line 687: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

683: l_return_status -- OUT
684: );
685:
686: -- If any severe error occurs, then, abort API.
687: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
688: RAISE FND_API.G_EXC_ERROR;
689: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
691: END IF;

Line 688: RAISE FND_API.G_EXC_ERROR;

684: );
685:
686: -- If any severe error occurs, then, abort API.
687: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
688: RAISE FND_API.G_EXC_ERROR;
689: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
691: END IF;
692: END IF;

Line 689: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

685:
686: -- If any severe error occurs, then, abort API.
687: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
688: RAISE FND_API.G_EXC_ERROR;
689: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
691: END IF;
692: END IF;
693: END LOOP;

Line 690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

686: -- If any severe error occurs, then, abort API.
687: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
688: RAISE FND_API.G_EXC_ERROR;
689: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
691: END IF;
692: END IF;
693: END LOOP;
694: --END IF;

Line 702: IF FND_API.to_boolean( p_default ) THEN

698: END IF;
699:
700: -- Default rt_oper_panel attributes.
701: /* Removed as a part of public API cleanup in 11510+.
702: IF FND_API.to_boolean( p_default ) THEN
703: FOR i IN 1..p_x_rt_oper_panel_tbl.count LOOP
704: IF ( p_x_rt_oper_panel_tbl(i).dml_operation <> 'D' ) THEN
705: default_attributes
706: (

Line 720: --IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN

716: END IF;
717:
718: -- Validate all attributes (Item level validation)
719: -- Balaji removed p_validation_level check in 11510+ as a part of public api cleanup.
720: --IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
721: FOR i IN 1..p_x_rt_oper_panel_tbl.count LOOP
722: validate_attributes
723: (
724: p_object_id, -- IN

Line 731: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

727: l_return_status -- OUT
728: );
729:
730: -- If any severe error occurs, then, abort API.
731: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
732: RAISE FND_API.G_EXC_ERROR;
733: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
735: END IF;

Line 732: RAISE FND_API.G_EXC_ERROR;

728: );
729:
730: -- If any severe error occurs, then, abort API.
731: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
732: RAISE FND_API.G_EXC_ERROR;
733: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
735: END IF;
736: END LOOP;

Line 733: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

729:
730: -- If any severe error occurs, then, abort API.
731: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
732: RAISE FND_API.G_EXC_ERROR;
733: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
735: END IF;
736: END LOOP;
737: --END IF;

Line 734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

730: -- If any severe error occurs, then, abort API.
731: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
732: RAISE FND_API.G_EXC_ERROR;
733: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
735: END IF;
736: END LOOP;
737: --END IF;
738:

Line 779: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

775: l_msg_data,
776: l_return_status
777: );
778:
779: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
780: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
781: FND_MSG_PUB.ADD;
782: x_return_status := l_return_status;
783: RETURN;

Line 810: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

806: l_msg_data,
807: l_return_status
808: );
809:
810: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
811: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
812: FND_MSG_PUB.ADD;
813: x_return_status := l_return_status;
814: RETURN;

Line 835: RAISE FND_API.G_EXC_ERROR;

831: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
832: l_msg_count := FND_MSG_PUB.count_msg;
833: IF l_msg_count > 0 THEN
834: x_msg_count := l_msg_count;
835: RAISE FND_API.G_EXC_ERROR;
836: END IF;
837:
838: -- Perform the DML statement directly.
839: FOR i IN 1..p_x_rt_oper_panel_tbl.count LOOP

Line 1004: RAISE FND_API.G_EXC_ERROR;

1000: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1001: l_msg_count := FND_MSG_PUB.count_msg;
1002: IF l_msg_count > 0 THEN
1003: x_msg_count := l_msg_count;
1004: RAISE FND_API.G_EXC_ERROR;
1005: END IF;
1006:
1007: -- Perform cross records validations and duplicate records check
1008: validate_records

Line 1016: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1012: l_return_status -- OUT
1013: );
1014:
1015: -- If any severe error occurs, then, abort API.
1016: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;

Line 1017: RAISE FND_API.G_EXC_ERROR;

1013: );
1014:
1015: -- If any severe error occurs, then, abort API.
1016: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;
1021:

Line 1018: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1014:
1015: -- If any severe error occurs, then, abort API.
1016: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;
1021:
1022: IF G_DEBUG = 'Y' THEN

Line 1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1015: -- If any severe error occurs, then, abort API.
1016: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1017: RAISE FND_API.G_EXC_ERROR;
1018: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: END IF;
1021:
1022: IF G_DEBUG = 'Y' THEN
1023: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_records' );

Line 1027: IF FND_API.to_boolean( p_commit ) THEN

1023: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_records' );
1024: END IF;
1025:
1026: -- Perform the Commit (if requested)
1027: IF FND_API.to_boolean( p_commit ) THEN
1028: COMMIT WORK;
1029: END IF;
1030:
1031: -- Count and Get messages (optional)

Line 1034: p_encoded => FND_API.G_FALSE,

1030:
1031: -- Count and Get messages (optional)
1032: FND_MSG_PUB.count_and_get
1033: (
1034: p_encoded => FND_API.G_FALSE,
1035: p_count => x_msg_count,
1036: p_data => x_msg_data
1037: );
1038:

Line 1044: WHEN FND_API.G_EXC_ERROR THEN

1040: IF G_DEBUG = 'Y' THEN
1041: AHL_DEBUG_PUB.disable_debug;
1042: END IF;
1043: EXCEPTION
1044: WHEN FND_API.G_EXC_ERROR THEN
1045: ROLLBACK TO process_rt_oper_panel_PVT;
1046: x_return_status := FND_API.G_RET_STS_ERROR ;
1047: FND_MSG_PUB.count_and_get
1048: (

Line 1046: x_return_status := FND_API.G_RET_STS_ERROR ;

1042: END IF;
1043: EXCEPTION
1044: WHEN FND_API.G_EXC_ERROR THEN
1045: ROLLBACK TO process_rt_oper_panel_PVT;
1046: x_return_status := FND_API.G_RET_STS_ERROR ;
1047: FND_MSG_PUB.count_and_get
1048: (
1049: p_encoded => FND_API.G_FALSE,
1050: p_count => x_msg_count,

Line 1049: p_encoded => FND_API.G_FALSE,

1045: ROLLBACK TO process_rt_oper_panel_PVT;
1046: x_return_status := FND_API.G_RET_STS_ERROR ;
1047: FND_MSG_PUB.count_and_get
1048: (
1049: p_encoded => FND_API.G_FALSE,
1050: p_count => x_msg_count,
1051: p_data => x_msg_data
1052: );
1053:

Line 1059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1055: IF G_DEBUG = 'Y' THEN
1056: AHL_DEBUG_PUB.disable_debug;
1057: END IF;
1058:
1059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1060: ROLLBACK TO process_rt_oper_panel_PVT;
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1062: FND_MSG_PUB.count_and_get
1063: (

Line 1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1057: END IF;
1058:
1059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1060: ROLLBACK TO process_rt_oper_panel_PVT;
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1062: FND_MSG_PUB.count_and_get
1063: (
1064: p_encoded => FND_API.G_FALSE,
1065: p_count => x_msg_count,

Line 1064: p_encoded => FND_API.G_FALSE,

1060: ROLLBACK TO process_rt_oper_panel_PVT;
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1062: FND_MSG_PUB.count_and_get
1063: (
1064: p_encoded => FND_API.G_FALSE,
1065: p_count => x_msg_count,
1066: p_data => x_msg_data
1067: );
1068:

Line 1076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1072: END IF;
1073:
1074: WHEN OTHERS THEN
1075: ROLLBACK TO process_rt_oper_panel_PVT;
1076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1077: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1078: THEN
1079: FND_MSG_PUB.add_exc_msg
1080: (

Line 1088: p_encoded => FND_API.G_FALSE,

1084: );
1085: END IF;
1086: FND_MSG_PUB.count_and_get
1087: (
1088: p_encoded => FND_API.G_FALSE,
1089: p_count => x_msg_count,
1090: p_data => x_msg_data
1091: );
1092: