16: IS
17: I NUMBER:=0;
18: BEGIN
19:
20: FND_API.g_entity_tbl.DELETE;
21:
22: -- START GEN entities
23: I := I + 1;
24: FND_API.g_entity_tbl(I).name := 'ALL';
20: FND_API.g_entity_tbl.DELETE;
21:
22: -- START GEN entities
23: I := I + 1;
24: FND_API.g_entity_tbl(I).name := 'ALL';
25: I := I + 1;
26: FND_API.g_entity_tbl(I).name := 'WIP_ENTITIES';
27: I := I + 1;
28: FND_API.g_entity_tbl(I).name := 'FLOWSCHEDULE';
22: -- START GEN entities
23: I := I + 1;
24: FND_API.g_entity_tbl(I).name := 'ALL';
25: I := I + 1;
26: FND_API.g_entity_tbl(I).name := 'WIP_ENTITIES';
27: I := I + 1;
28: FND_API.g_entity_tbl(I).name := 'FLOWSCHEDULE';
29: I := I + 1;
30: FND_API.g_entity_tbl(I).name := 'DISCRETEJOB';
24: FND_API.g_entity_tbl(I).name := 'ALL';
25: I := I + 1;
26: FND_API.g_entity_tbl(I).name := 'WIP_ENTITIES';
27: I := I + 1;
28: FND_API.g_entity_tbl(I).name := 'FLOWSCHEDULE';
29: I := I + 1;
30: FND_API.g_entity_tbl(I).name := 'DISCRETEJOB';
31: I := I + 1;
32: FND_API.g_entity_tbl(I).name := 'REPSCHEDULE';
26: FND_API.g_entity_tbl(I).name := 'WIP_ENTITIES';
27: I := I + 1;
28: FND_API.g_entity_tbl(I).name := 'FLOWSCHEDULE';
29: I := I + 1;
30: FND_API.g_entity_tbl(I).name := 'DISCRETEJOB';
31: I := I + 1;
32: FND_API.g_entity_tbl(I).name := 'REPSCHEDULE';
33: I := I + 1;
34: FND_API.g_entity_tbl(I).name := 'WIPTRANSACTION';
28: FND_API.g_entity_tbl(I).name := 'FLOWSCHEDULE';
29: I := I + 1;
30: FND_API.g_entity_tbl(I).name := 'DISCRETEJOB';
31: I := I + 1;
32: FND_API.g_entity_tbl(I).name := 'REPSCHEDULE';
33: I := I + 1;
34: FND_API.g_entity_tbl(I).name := 'WIPTRANSACTION';
35: I := I + 1;
36: FND_API.g_entity_tbl(I).name := 'COMPONENTISSUE';
30: FND_API.g_entity_tbl(I).name := 'DISCRETEJOB';
31: I := I + 1;
32: FND_API.g_entity_tbl(I).name := 'REPSCHEDULE';
33: I := I + 1;
34: FND_API.g_entity_tbl(I).name := 'WIPTRANSACTION';
35: I := I + 1;
36: FND_API.g_entity_tbl(I).name := 'COMPONENTISSUE';
37: I := I + 1;
38: FND_API.g_entity_tbl(I).name := 'OSP';
32: FND_API.g_entity_tbl(I).name := 'REPSCHEDULE';
33: I := I + 1;
34: FND_API.g_entity_tbl(I).name := 'WIPTRANSACTION';
35: I := I + 1;
36: FND_API.g_entity_tbl(I).name := 'COMPONENTISSUE';
37: I := I + 1;
38: FND_API.g_entity_tbl(I).name := 'OSP';
39: I := I + 1;
40: FND_API.g_entity_tbl(I).name := 'SHOPFLOORMOVE';
34: FND_API.g_entity_tbl(I).name := 'WIPTRANSACTION';
35: I := I + 1;
36: FND_API.g_entity_tbl(I).name := 'COMPONENTISSUE';
37: I := I + 1;
38: FND_API.g_entity_tbl(I).name := 'OSP';
39: I := I + 1;
40: FND_API.g_entity_tbl(I).name := 'SHOPFLOORMOVE';
41: I := I + 1;
42: FND_API.g_entity_tbl(I).name := 'RESOURCE';
36: FND_API.g_entity_tbl(I).name := 'COMPONENTISSUE';
37: I := I + 1;
38: FND_API.g_entity_tbl(I).name := 'OSP';
39: I := I + 1;
40: FND_API.g_entity_tbl(I).name := 'SHOPFLOORMOVE';
41: I := I + 1;
42: FND_API.g_entity_tbl(I).name := 'RESOURCE';
43: -- END GEN entities
44:
38: FND_API.g_entity_tbl(I).name := 'OSP';
39: I := I + 1;
40: FND_API.g_entity_tbl(I).name := 'SHOPFLOORMOVE';
41: I := I + 1;
42: FND_API.g_entity_tbl(I).name := 'RESOURCE';
43: -- END GEN entities
44:
45: END Get_Entities_Tbl;
46:
114: , 'Invalid action'
115: );
116: END IF;
117:
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119:
120: END IF;
121:
122: RETURN l_control_rec;
174:
175:
176: PROCEDURE Add_Error_Message(p_product VARCHAR2 := 'WIP',
177: p_message_name VARCHAR2,
178: p_token1_name VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_token1_value VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_token2_name VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_token2_value VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_token3_name VARCHAR2 := FND_API.G_MISS_CHAR,
175:
176: PROCEDURE Add_Error_Message(p_product VARCHAR2 := 'WIP',
177: p_message_name VARCHAR2,
178: p_token1_name VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_token1_value VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_token2_name VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_token2_value VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_token3_name VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_token3_value VARCHAR2 := FND_API.G_MISS_CHAR,
176: PROCEDURE Add_Error_Message(p_product VARCHAR2 := 'WIP',
177: p_message_name VARCHAR2,
178: p_token1_name VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_token1_value VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_token2_name VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_token2_value VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_token3_name VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_token3_value VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_token4_name VARCHAR2 := FND_API.G_MISS_CHAR,
177: p_message_name VARCHAR2,
178: p_token1_name VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_token1_value VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_token2_name VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_token2_value VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_token3_name VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_token3_value VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_token4_name VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_token4_value VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_token1_name VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_token1_value VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_token2_name VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_token2_value VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_token3_name VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_token3_value VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_token4_name VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_token4_value VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_token5_name VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_token1_value VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_token2_name VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_token2_value VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_token3_name VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_token3_value VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_token4_name VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_token4_value VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_token5_name VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_token5_value VARCHAR2 := FND_API.G_MISS_CHAR)
180: p_token2_name VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_token2_value VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_token3_name VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_token3_value VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_token4_name VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_token4_value VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_token5_name VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_token5_value VARCHAR2 := FND_API.G_MISS_CHAR)
188:
181: p_token2_value VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_token3_name VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_token3_value VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_token4_name VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_token4_value VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_token5_name VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_token5_value VARCHAR2 := FND_API.G_MISS_CHAR)
188:
189: IS
182: p_token3_name VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_token3_value VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_token4_name VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_token4_value VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_token5_name VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_token5_value VARCHAR2 := FND_API.G_MISS_CHAR)
188:
189: IS
190: BEGIN
183: p_token3_value VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_token4_name VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_token4_value VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_token5_name VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_token5_value VARCHAR2 := FND_API.G_MISS_CHAR)
188:
189: IS
190: BEGIN
191:
192: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
193:
194: FND_MESSAGE.SET_NAME(p_product,p_message_name);
195:
196: IF p_token1_name <> FND_API.G_MISS_CHAR
197: AND p_token1_value <> FND_API.G_MISS_CHAR THEN
198: FND_MESSAGE.SET_TOKEN(p_token1_name,p_token1_value);
199: END IF;
200: IF p_token2_name <> FND_API.G_MISS_CHAR
193:
194: FND_MESSAGE.SET_NAME(p_product,p_message_name);
195:
196: IF p_token1_name <> FND_API.G_MISS_CHAR
197: AND p_token1_value <> FND_API.G_MISS_CHAR THEN
198: FND_MESSAGE.SET_TOKEN(p_token1_name,p_token1_value);
199: END IF;
200: IF p_token2_name <> FND_API.G_MISS_CHAR
201: AND p_token2_value <> FND_API.G_MISS_CHAR THEN
196: IF p_token1_name <> FND_API.G_MISS_CHAR
197: AND p_token1_value <> FND_API.G_MISS_CHAR THEN
198: FND_MESSAGE.SET_TOKEN(p_token1_name,p_token1_value);
199: END IF;
200: IF p_token2_name <> FND_API.G_MISS_CHAR
201: AND p_token2_value <> FND_API.G_MISS_CHAR THEN
202: FND_MESSAGE.SET_TOKEN(p_token2_name,p_token2_value);
203: END IF;
204: IF p_token3_name <> FND_API.G_MISS_CHAR
197: AND p_token1_value <> FND_API.G_MISS_CHAR THEN
198: FND_MESSAGE.SET_TOKEN(p_token1_name,p_token1_value);
199: END IF;
200: IF p_token2_name <> FND_API.G_MISS_CHAR
201: AND p_token2_value <> FND_API.G_MISS_CHAR THEN
202: FND_MESSAGE.SET_TOKEN(p_token2_name,p_token2_value);
203: END IF;
204: IF p_token3_name <> FND_API.G_MISS_CHAR
205: AND p_token3_value <> FND_API.G_MISS_CHAR THEN
200: IF p_token2_name <> FND_API.G_MISS_CHAR
201: AND p_token2_value <> FND_API.G_MISS_CHAR THEN
202: FND_MESSAGE.SET_TOKEN(p_token2_name,p_token2_value);
203: END IF;
204: IF p_token3_name <> FND_API.G_MISS_CHAR
205: AND p_token3_value <> FND_API.G_MISS_CHAR THEN
206: FND_MESSAGE.SET_TOKEN(p_token3_name,p_token3_value);
207: END IF;
208: IF p_token4_name <> FND_API.G_MISS_CHAR
201: AND p_token2_value <> FND_API.G_MISS_CHAR THEN
202: FND_MESSAGE.SET_TOKEN(p_token2_name,p_token2_value);
203: END IF;
204: IF p_token3_name <> FND_API.G_MISS_CHAR
205: AND p_token3_value <> FND_API.G_MISS_CHAR THEN
206: FND_MESSAGE.SET_TOKEN(p_token3_name,p_token3_value);
207: END IF;
208: IF p_token4_name <> FND_API.G_MISS_CHAR
209: AND p_token4_value <> FND_API.G_MISS_CHAR THEN
204: IF p_token3_name <> FND_API.G_MISS_CHAR
205: AND p_token3_value <> FND_API.G_MISS_CHAR THEN
206: FND_MESSAGE.SET_TOKEN(p_token3_name,p_token3_value);
207: END IF;
208: IF p_token4_name <> FND_API.G_MISS_CHAR
209: AND p_token4_value <> FND_API.G_MISS_CHAR THEN
210: FND_MESSAGE.SET_TOKEN(p_token4_name,p_token4_value);
211: END IF;
212: IF p_token5_name <> FND_API.G_MISS_CHAR
205: AND p_token3_value <> FND_API.G_MISS_CHAR THEN
206: FND_MESSAGE.SET_TOKEN(p_token3_name,p_token3_value);
207: END IF;
208: IF p_token4_name <> FND_API.G_MISS_CHAR
209: AND p_token4_value <> FND_API.G_MISS_CHAR THEN
210: FND_MESSAGE.SET_TOKEN(p_token4_name,p_token4_value);
211: END IF;
212: IF p_token5_name <> FND_API.G_MISS_CHAR
213: AND p_token5_value <> FND_API.G_MISS_CHAR THEN
208: IF p_token4_name <> FND_API.G_MISS_CHAR
209: AND p_token4_value <> FND_API.G_MISS_CHAR THEN
210: FND_MESSAGE.SET_TOKEN(p_token4_name,p_token4_value);
211: END IF;
212: IF p_token5_name <> FND_API.G_MISS_CHAR
213: AND p_token5_value <> FND_API.G_MISS_CHAR THEN
214: FND_MESSAGE.SET_TOKEN(p_token5_name,p_token5_value);
215: END IF;
216:
209: AND p_token4_value <> FND_API.G_MISS_CHAR THEN
210: FND_MESSAGE.SET_TOKEN(p_token4_name,p_token4_value);
211: END IF;
212: IF p_token5_name <> FND_API.G_MISS_CHAR
213: AND p_token5_value <> FND_API.G_MISS_CHAR THEN
214: FND_MESSAGE.SET_TOKEN(p_token5_name,p_token5_value);
215: END IF;
216:
217: FND_MSG_PUB.Add;
231: BEGIN
232: fnd_msg_pub.reset;
233: for i in 1..p_msg_count loop
234:
235: fnd_msg_pub.get (p_encoded => FND_API.G_FALSE,
236: p_data => msg_data,
237: p_msg_index_out => cnt);
238:
239: -- dbms_output.put_line('error # ' || cnt || ': ' || msg_data);
298: x_locator_control => x_locator_control,
299: x_level => x_level);
300:
301: EXCEPTION
302: WHEN FND_API.G_EXC_ERROR THEN
303:
304: x_return_status := FND_API.G_RET_STS_ERROR;
305:
306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
300:
301: EXCEPTION
302: WHEN FND_API.G_EXC_ERROR THEN
303:
304: x_return_status := FND_API.G_RET_STS_ERROR;
305:
306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
307:
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
302: WHEN FND_API.G_EXC_ERROR THEN
303:
304: x_return_status := FND_API.G_RET_STS_ERROR;
305:
306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
307:
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309:
310: WHEN OTHERS THEN
304: x_return_status := FND_API.G_RET_STS_ERROR;
305:
306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
307:
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309:
310: WHEN OTHERS THEN
311:
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309:
310: WHEN OTHERS THEN
311:
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
313: Add_Error_Message(p_message_name => 'UNEXPECTED_ERROR',
314: p_token1_name => 'TEXT',
315: p_token1_value => Sqlerrm);
316: