DBA Data[Home] [Help]

APPS.WIP_GLOBALS dependencies on FND_API

Line 20: FND_API.g_entity_tbl.DELETE;

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';

Line 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';

Line 26: FND_API.g_entity_tbl(I).name := 'WIP_ENTITIES';

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';

Line 28: FND_API.g_entity_tbl(I).name := 'FLOWSCHEDULE';

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';

Line 30: FND_API.g_entity_tbl(I).name := 'DISCRETEJOB';

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';

Line 32: FND_API.g_entity_tbl(I).name := 'REPSCHEDULE';

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';

Line 34: FND_API.g_entity_tbl(I).name := 'WIPTRANSACTION';

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';

Line 36: FND_API.g_entity_tbl(I).name := 'COMPONENTISSUE';

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';

Line 38: FND_API.g_entity_tbl(I).name := 'OSP';

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';

Line 40: FND_API.g_entity_tbl(I).name := 'SHOPFLOORMOVE';

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:

Line 42: FND_API.g_entity_tbl(I).name := 'RESOURCE';

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:

Line 118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;

Line 178: p_token1_name VARCHAR2 := FND_API.G_MISS_CHAR,

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,

Line 179: p_token1_value 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,

Line 180: p_token2_name 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,

Line 181: p_token2_value 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,

Line 182: p_token3_name 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,

Line 183: p_token3_value 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)

Line 184: p_token4_name 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:

Line 185: p_token4_value 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:
189: IS

Line 186: p_token5_name 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
190: BEGIN

Line 187: p_token5_value 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
191:

Line 196: IF p_token1_name <> FND_API.G_MISS_CHAR

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

Line 197: AND p_token1_value <> FND_API.G_MISS_CHAR 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
201: AND p_token2_value <> FND_API.G_MISS_CHAR THEN

Line 200: IF p_token2_name <> FND_API.G_MISS_CHAR

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

Line 201: AND p_token2_value <> FND_API.G_MISS_CHAR THEN

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

Line 204: IF p_token3_name <> FND_API.G_MISS_CHAR

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

Line 205: AND p_token3_value <> FND_API.G_MISS_CHAR THEN

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

Line 208: IF p_token4_name <> FND_API.G_MISS_CHAR

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

Line 209: AND p_token4_value <> FND_API.G_MISS_CHAR THEN

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

Line 212: IF p_token5_name <> FND_API.G_MISS_CHAR

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:

Line 213: AND p_token5_value <> FND_API.G_MISS_CHAR THEN

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;

Line 235: fnd_msg_pub.get (p_encoded => FND_API.G_FALSE,

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);

Line 302: WHEN FND_API.G_EXC_ERROR THEN

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

Line 304: x_return_status := FND_API.G_RET_STS_ERROR;

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;

Line 306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;

Line 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: