APPS.AHL_VWP_TASKS_LINKS_PVT dependencies on FND_API

Line 16: IF p_x_task_link_tbl(i).TASK_LINK_ID= FND_API.G_MISS_NUM

12:
13: FOR i IN p_x_task_link_TBL.FIRST.. p_x_task_link_TBL.LAST
14: LOOP
15:
16: IF p_x_task_link_tbl(i).TASK_LINK_ID= FND_API.G_MISS_NUM
17: THEN
18: p_x_task_link_tbl(i).TASK_LINK_ID:=NULL;
19: END IF;
20: IF p_x_task_link_tbl(i).OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM

Line 20: IF p_x_task_link_tbl(i).OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM

16: IF p_x_task_link_tbl(i).TASK_LINK_ID= FND_API.G_MISS_NUM
17: THEN
18: p_x_task_link_tbl(i).TASK_LINK_ID:=NULL;
19: END IF;
20: IF p_x_task_link_tbl(i).OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM
21: THEN
22: p_x_task_link_tbl(i).OBJECT_VERSION_NUMBER:=NULL;
23: END IF;
24: IF p_x_task_link_tbl(i).LAST_UPDATE_DATE=FND_API.G_MISS_DATE

Line 24: IF p_x_task_link_tbl(i).LAST_UPDATE_DATE=FND_API.G_MISS_DATE

20: IF p_x_task_link_tbl(i).OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM
21: THEN
22: p_x_task_link_tbl(i).OBJECT_VERSION_NUMBER:=NULL;
23: END IF;
24: IF p_x_task_link_tbl(i).LAST_UPDATE_DATE=FND_API.G_MISS_DATE
25: THEN
26: p_x_task_link_tbl(i).LAST_UPDATE_DATE:=NULL;
27: END IF;
28: IF p_x_task_link_tbl(i).LAST_UPDATED_BY= FND_API.G_MISS_NUM

Line 28: IF p_x_task_link_tbl(i).LAST_UPDATED_BY= FND_API.G_MISS_NUM

24: IF p_x_task_link_tbl(i).LAST_UPDATE_DATE=FND_API.G_MISS_DATE
25: THEN
26: p_x_task_link_tbl(i).LAST_UPDATE_DATE:=NULL;
27: END IF;
28: IF p_x_task_link_tbl(i).LAST_UPDATED_BY= FND_API.G_MISS_NUM
29: THEN
30: p_x_task_link_tbl(i).LAST_UPDATED_BY:=NULL;
31: END IF;
32: IF p_x_task_link_tbl(i).CREATION_DATE=FND_API.G_MISS_DATE

Line 32: IF p_x_task_link_tbl(i).CREATION_DATE=FND_API.G_MISS_DATE

28: IF p_x_task_link_tbl(i).LAST_UPDATED_BY= FND_API.G_MISS_NUM
29: THEN
30: p_x_task_link_tbl(i).LAST_UPDATED_BY:=NULL;
31: END IF;
32: IF p_x_task_link_tbl(i).CREATION_DATE=FND_API.G_MISS_DATE
33: THEN
34: p_x_task_link_tbl(i).CREATION_DATE:=NULL;
35: END IF;
36: IF p_x_task_link_tbl(i).CREATED_BY= FND_API.G_MISS_NUM

Line 36: IF p_x_task_link_tbl(i).CREATED_BY= FND_API.G_MISS_NUM

32: IF p_x_task_link_tbl(i).CREATION_DATE=FND_API.G_MISS_DATE
33: THEN
34: p_x_task_link_tbl(i).CREATION_DATE:=NULL;
35: END IF;
36: IF p_x_task_link_tbl(i).CREATED_BY= FND_API.G_MISS_NUM
37: THEN
38: p_x_task_link_tbl(i).CREATED_BY:=NULL;
39: END IF;
40: IF p_x_task_link_tbl(i).LAST_UPDATE_LOGIN= FND_API.G_MISS_NUM

Line 40: IF p_x_task_link_tbl(i).LAST_UPDATE_LOGIN= FND_API.G_MISS_NUM

36: IF p_x_task_link_tbl(i).CREATED_BY= FND_API.G_MISS_NUM
37: THEN
38: p_x_task_link_tbl(i).CREATED_BY:=NULL;
39: END IF;
40: IF p_x_task_link_tbl(i).LAST_UPDATE_LOGIN= FND_API.G_MISS_NUM
41: THEN
42: p_x_task_link_tbl(i).LAST_UPDATE_LOGIN:=NULL;
43: END IF;
44: IF p_x_task_link_tbl(i).VISIT_TASK_ID= FND_API.G_MISS_NUM

Line 44: IF p_x_task_link_tbl(i).VISIT_TASK_ID= FND_API.G_MISS_NUM

40: IF p_x_task_link_tbl(i).LAST_UPDATE_LOGIN= FND_API.G_MISS_NUM
41: THEN
42: p_x_task_link_tbl(i).LAST_UPDATE_LOGIN:=NULL;
43: END IF;
44: IF p_x_task_link_tbl(i).VISIT_TASK_ID= FND_API.G_MISS_NUM
45: THEN
46: p_x_task_link_tbl(i).VISIT_TASK_ID:=NULL;
47: END IF;
48: IF p_x_task_link_tbl(i).PARENT_TASK_ID= FND_API.G_MISS_NUM

Line 48: IF p_x_task_link_tbl(i).PARENT_TASK_ID= FND_API.G_MISS_NUM

44: IF p_x_task_link_tbl(i).VISIT_TASK_ID= FND_API.G_MISS_NUM
45: THEN
46: p_x_task_link_tbl(i).VISIT_TASK_ID:=NULL;
47: END IF;
48: IF p_x_task_link_tbl(i).PARENT_TASK_ID= FND_API.G_MISS_NUM
49: THEN
50: p_x_task_link_tbl(i).PARENT_TASK_ID:=NULL;
51: END IF;
52:

Line 53: IF p_x_task_link_TBL(i).ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR

49: THEN
50: p_x_task_link_tbl(i).PARENT_TASK_ID:=NULL;
51: END IF;
52:
53: IF p_x_task_link_TBL(i).ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR
54: THEN
55: p_x_task_link_TBL(i).ATTRIBUTE_CATEGORY:=NULL;
56: END IF;
57:

Line 58: IF p_x_task_link_TBL(i).ATTRIBUTE1=FND_API.G_MISS_CHAR

54: THEN
55: p_x_task_link_TBL(i).ATTRIBUTE_CATEGORY:=NULL;
56: END IF;
57:
58: IF p_x_task_link_TBL(i).ATTRIBUTE1=FND_API.G_MISS_CHAR
59: THEN
60: p_x_task_link_TBL(i).ATTRIBUTE1:=NULL;
61: END IF;
62:

Line 63: IF p_x_task_link_TBL(i).ATTRIBUTE2=FND_API.G_MISS_CHAR

59: THEN
60: p_x_task_link_TBL(i).ATTRIBUTE1:=NULL;
61: END IF;
62:
63: IF p_x_task_link_TBL(i).ATTRIBUTE2=FND_API.G_MISS_CHAR
64: THEN
65: p_x_task_link_TBL(i).ATTRIBUTE2:=NULL;
66: END IF;
67:

Line 68: IF p_x_task_link_TBL(i).ATTRIBUTE3=FND_API.G_MISS_CHAR

64: THEN
65: p_x_task_link_TBL(i).ATTRIBUTE2:=NULL;
66: END IF;
67:
68: IF p_x_task_link_TBL(i).ATTRIBUTE3=FND_API.G_MISS_CHAR
69: THEN
70: p_x_task_link_TBL(i).ATTRIBUTE3:=NULL;
71: END IF;
72:

Line 73: IF p_x_task_link_TBL(i).ATTRIBUTE4 IS NULL OR p_x_task_link_TBL(i).ATTRIBUTE4=FND_API.G_MISS_CHAR

69: THEN
70: p_x_task_link_TBL(i).ATTRIBUTE3:=NULL;
71: END IF;
72:
73: IF p_x_task_link_TBL(i).ATTRIBUTE4 IS NULL OR p_x_task_link_TBL(i).ATTRIBUTE4=FND_API.G_MISS_CHAR
74: THEN
75: p_x_task_link_TBL(i).ATTRIBUTE4:=NULL;
76: END IF;
77:

Line 78: IF p_x_task_link_TBL(i).ATTRIBUTE5=FND_API.G_MISS_CHAR

74: THEN
75: p_x_task_link_TBL(i).ATTRIBUTE4:=NULL;
76: END IF;
77:
78: IF p_x_task_link_TBL(i).ATTRIBUTE5=FND_API.G_MISS_CHAR
79: THEN
80: p_x_task_link_TBL(i).ATTRIBUTE5:=NULL;
81: END IF;
82:

Line 83: IF p_x_task_link_TBL(i).ATTRIBUTE6=FND_API.G_MISS_CHAR

79: THEN
80: p_x_task_link_TBL(i).ATTRIBUTE5:=NULL;
81: END IF;
82:
83: IF p_x_task_link_TBL(i).ATTRIBUTE6=FND_API.G_MISS_CHAR
84: THEN
85: p_x_task_link_TBL(i).ATTRIBUTE6:=NULL;
86: END IF;
87:

Line 88: IF p_x_task_link_TBL(i).ATTRIBUTE7=FND_API.G_MISS_CHAR

84: THEN
85: p_x_task_link_TBL(i).ATTRIBUTE6:=NULL;
86: END IF;
87:
88: IF p_x_task_link_TBL(i).ATTRIBUTE7=FND_API.G_MISS_CHAR
89: THEN
90: p_x_task_link_TBL(i).ATTRIBUTE7:=NULL;
91: END IF;
92:

Line 93: IF p_x_task_link_TBL(i).ATTRIBUTE8=FND_API.G_MISS_CHAR

89: THEN
90: p_x_task_link_TBL(i).ATTRIBUTE7:=NULL;
91: END IF;
92:
93: IF p_x_task_link_TBL(i).ATTRIBUTE8=FND_API.G_MISS_CHAR
94: THEN
95: p_x_task_link_TBL(i).ATTRIBUTE8:=NULL;
96: END IF;
97:

Line 98: IF p_x_task_link_TBL(i).ATTRIBUTE9=FND_API.G_MISS_CHAR

94: THEN
95: p_x_task_link_TBL(i).ATTRIBUTE8:=NULL;
96: END IF;
97:
98: IF p_x_task_link_TBL(i).ATTRIBUTE9=FND_API.G_MISS_CHAR
99: THEN
100: p_x_task_link_TBL(i).ATTRIBUTE9:=NULL;
101: END IF;
102:

Line 103: IF p_x_task_link_TBL(i).ATTRIBUTE10=FND_API.G_MISS_CHAR

99: THEN
100: p_x_task_link_TBL(i).ATTRIBUTE9:=NULL;
101: END IF;
102:
103: IF p_x_task_link_TBL(i).ATTRIBUTE10=FND_API.G_MISS_CHAR
104: THEN
105: p_x_task_link_TBL(i).ATTRIBUTE10:=NULL;
106: END IF;
107:

Line 108: IF p_x_task_link_TBL(i).ATTRIBUTE11=FND_API.G_MISS_CHAR

104: THEN
105: p_x_task_link_TBL(i).ATTRIBUTE10:=NULL;
106: END IF;
107:
108: IF p_x_task_link_TBL(i).ATTRIBUTE11=FND_API.G_MISS_CHAR
109: THEN
110: p_x_task_link_TBL(i).ATTRIBUTE11:=NULL;
111: END IF;
112:

Line 113: IF p_x_task_link_TBL(i).ATTRIBUTE12=FND_API.G_MISS_CHAR

109: THEN
110: p_x_task_link_TBL(i).ATTRIBUTE11:=NULL;
111: END IF;
112:
113: IF p_x_task_link_TBL(i).ATTRIBUTE12=FND_API.G_MISS_CHAR
114: THEN
115: p_x_task_link_TBL(i).ATTRIBUTE12:=NULL;
116: END IF;
117:

Line 118: IF p_x_task_link_TBL(i).ATTRIBUTE13=FND_API.G_MISS_CHAR

114: THEN
115: p_x_task_link_TBL(i).ATTRIBUTE12:=NULL;
116: END IF;
117:
118: IF p_x_task_link_TBL(i).ATTRIBUTE13=FND_API.G_MISS_CHAR
119: THEN
120: p_x_task_link_TBL(i).ATTRIBUTE13:=NULL;
121: END IF;
122:

Line 123: IF p_x_task_link_TBL(i).ATTRIBUTE14=FND_API.G_MISS_CHAR

119: THEN
120: p_x_task_link_TBL(i).ATTRIBUTE13:=NULL;
121: END IF;
122:
123: IF p_x_task_link_TBL(i).ATTRIBUTE14=FND_API.G_MISS_CHAR
124: THEN
125: p_x_task_link_TBL(i).ATTRIBUTE14:=NULL;
126: END IF;
127:

Line 128: IF p_x_task_link_TBL(i).ATTRIBUTE15=FND_API.G_MISS_CHAR

124: THEN
125: p_x_task_link_TBL(i).ATTRIBUTE14:=NULL;
126: END IF;
127:
128: IF p_x_task_link_TBL(i).ATTRIBUTE15=FND_API.G_MISS_CHAR
129: THEN
130: p_x_task_link_TBL(i).ATTRIBUTE15:=NULL;
131: END IF;
132: END LOOP;

Line 259: x_return_status:=FND_API.G_RET_STS_SUCCESS;

255: l_parent_task_id number;
256:
257: BEGIN
258:
259: x_return_status:=FND_API.G_RET_STS_SUCCESS;
260:
261:
262: -- Changes done for Post 11.5.10 by senthil.
263: /*IF p_task_link_rec.HIERARCHY_INDICATOR='AFTER' --Commented by tchimira as per vwp ER-12424063 on 14-FEB-2011

Line 285: RAISE FND_API.G_EXC_ERROR;

281: CLOSE c_task_type_code;
282: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_SUMMARY');
283: FND_MESSAGE.SET_TOKEN('TASK_NUM',l_parent_task_number);
284: FND_MSG_PUB.ADD;
285: RAISE FND_API.G_EXC_ERROR;
286: END IF;
287: CLOSE c_task_type_code;
288:
289: OPEN c_task_status(l_parent_task_id);

Line 301: RAISE FND_API.G_EXC_ERROR;

297: CLOSE c_task_status;
298: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_PARENT_REL');
299: FND_MESSAGE.SET_TOKEN('TASK_NUM',l_parent_task_number);
300: FND_MSG_PUB.ADD;
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;
303: CLOSE c_task_status;
304:
305:

Line 318: RAISE FND_API.G_EXC_ERROR;

314: CLOSE c_task_status;
315: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_CHILD_REL');
316: FND_MESSAGE.SET_TOKEN('TASK_NUM',l_child_task_number);
317: FND_MSG_PUB.ADD;
318: RAISE FND_API.G_EXC_ERROR;
319: END IF;
320: CLOSE c_task_status;
321:
322: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 370: RAISE FND_API.G_EXC_ERROR;

366: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CHILD_STG_GT');
367: FND_MESSAGE.SET_TOKEN('CHILD_TASK_NUM',l_child_task_number);
368: FND_MESSAGE.SET_TOKEN('PARENT_TASK_NUM',l_parent_task_number);
369: FND_MSG_PUB.ADD;
370: RAISE FND_API.G_EXC_ERROR;
371: END IF; -- if c_validate_rules not found
372: CLOSE c_validate_rules;
373: END IF; -- if either parent or child stage id is null
374: END LOOP; -- loop through child tasks

Line 381: IF (p_task_link_rec.task_link_id IS NULL OR p_task_link_rec.task_link_id=FND_API.G_MISS_NUM) AND p_task_link_rec.dml_operation<>'C'

377:
378: IF p_task_link_rec.dml_operation<>'D'
379: THEN
380:
381: IF (p_task_link_rec.task_link_id IS NULL OR p_task_link_rec.task_link_id=FND_API.G_MISS_NUM) AND p_task_link_rec.dml_operation<>'C'
382: THEN
383: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_VISIT_LINK_ID_NULL');
384: FND_MSG_PUB.ADD;
385: RAISE FND_API.G_EXC_ERROR;

Line 385: RAISE FND_API.G_EXC_ERROR;

381: IF (p_task_link_rec.task_link_id IS NULL OR p_task_link_rec.task_link_id=FND_API.G_MISS_NUM) AND p_task_link_rec.dml_operation<>'C'
382: THEN
383: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_VISIT_LINK_ID_NULL');
384: FND_MSG_PUB.ADD;
385: RAISE FND_API.G_EXC_ERROR;
386: END IF;
387:
388: IF (p_task_link_rec.OBJECT_VERSION_NUMBER IS NULL OR p_task_link_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_NUM) and p_task_link_rec.dml_operation<>'C'
389: THEN

Line 388: IF (p_task_link_rec.OBJECT_VERSION_NUMBER IS NULL OR p_task_link_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_NUM) and p_task_link_rec.dml_operation<>'C'

384: FND_MSG_PUB.ADD;
385: RAISE FND_API.G_EXC_ERROR;
386: END IF;
387:
388: IF (p_task_link_rec.OBJECT_VERSION_NUMBER IS NULL OR p_task_link_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_NUM) and p_task_link_rec.dml_operation<>'C'
389: THEN
390: FND_MESSAGE.SET_NAME('AHL','AHL_COM_OBJECT_VERS_NUM_NULL');
391: FND_MSG_PUB.ADD;
392: RAISE FND_API.G_EXC_ERROR;

Line 392: RAISE FND_API.G_EXC_ERROR;

388: IF (p_task_link_rec.OBJECT_VERSION_NUMBER IS NULL OR p_task_link_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_NUM) and p_task_link_rec.dml_operation<>'C'
389: THEN
390: FND_MESSAGE.SET_NAME('AHL','AHL_COM_OBJECT_VERS_NUM_NULL');
391: FND_MSG_PUB.ADD;
392: RAISE FND_API.G_EXC_ERROR;
393: END IF;
394:
395:
396: -- Check for uniq ness of the Route Sequences

Line 398: IF (p_task_link_rec.visit_Task_id IS NOT NULL AND p_task_link_rec.visit_Task_id<>FND_API.G_MISS_NUM

394:
395:
396: -- Check for uniq ness of the Route Sequences
397:
398: IF (p_task_link_rec.visit_Task_id IS NOT NULL AND p_task_link_rec.visit_Task_id<>FND_API.G_MISS_NUM
399: AND p_task_link_rec.PARENT_TASK_ID IS NOT NULL AND p_task_link_rec.PARENT_TASK_ID<>FND_API.G_MISS_NUM)
400: THEN
401: IF G_DEBUG='Y' THEN
402: AHL_DEBUG_PUB.debug(L_FULL_NAME|| 'Enter Validate 02','+VWP_HIERARCHY+');

Line 399: AND p_task_link_rec.PARENT_TASK_ID IS NOT NULL AND p_task_link_rec.PARENT_TASK_ID<>FND_API.G_MISS_NUM)

395:
396: -- Check for uniq ness of the Route Sequences
397:
398: IF (p_task_link_rec.visit_Task_id IS NOT NULL AND p_task_link_rec.visit_Task_id<>FND_API.G_MISS_NUM
399: AND p_task_link_rec.PARENT_TASK_ID IS NOT NULL AND p_task_link_rec.PARENT_TASK_ID<>FND_API.G_MISS_NUM)
400: THEN
401: IF G_DEBUG='Y' THEN
402: AHL_DEBUG_PUB.debug(L_FULL_NAME|| 'Enter Validate 02','+VWP_HIERARCHY+');
403: END IF;

Line 429: RAISE FND_API.G_EXC_ERROR;

425: THEN
426: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_LINK_DUP');
427: FND_MESSAGE.SET_TOKEN('RECORD',p_task_link_rec.visit_Task_number,false);
428: FND_MSG_PUB.ADD;
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
431: CLOSE check_UNIQ;
432:
433: END IF;

Line 436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

432:
433: END IF;
434: END IF;
435: EXCEPTION
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
439: p_count => x_msg_count,
440: p_data => x_msg_data);

Line 437: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

433: END IF;
434: END IF;
435: EXCEPTION
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
439: p_count => x_msg_count,
440: p_data => x_msg_data);
441:

Line 438: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

434: END IF;
435: EXCEPTION
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
438: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
439: p_count => x_msg_count,
440: p_data => x_msg_data);
441:
442: WHEN FND_API.G_EXC_ERROR THEN

Line 442: WHEN FND_API.G_EXC_ERROR THEN

438: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
439: p_count => x_msg_count,
440: p_data => x_msg_data);
441:
442: WHEN FND_API.G_EXC_ERROR THEN
443: X_return_status := FND_API.G_RET_STS_ERROR;
444: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
445: p_count => x_msg_count,
446: p_data => X_msg_data);

Line 443: X_return_status := FND_API.G_RET_STS_ERROR;

439: p_count => x_msg_count,
440: p_data => x_msg_data);
441:
442: WHEN FND_API.G_EXC_ERROR THEN
443: X_return_status := FND_API.G_RET_STS_ERROR;
444: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
445: p_count => x_msg_count,
446: p_data => X_msg_data);
447: WHEN OTHERS THEN

Line 444: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

440: p_data => x_msg_data);
441:
442: WHEN FND_API.G_EXC_ERROR THEN
443: X_return_status := FND_API.G_RET_STS_ERROR;
444: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
445: p_count => x_msg_count,
446: p_data => X_msg_data);
447: WHEN OTHERS THEN
448: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 448: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

444: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
445: p_count => x_msg_count,
446: p_data => X_msg_data);
447: WHEN OTHERS THEN
448: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
450: THEN
451: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
452: p_procedure_name => L_API_NAME,

Line 455: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

451: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
452: p_procedure_name => L_API_NAME,
453: p_error_text => SUBSTR(SQLERRM,1,240));
454: END IF;
455: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
456: p_count => x_msg_count,
457: p_data => X_msg_data);
458: END;
459:

Line 484: x_return_status:=FND_API.G_RET_STS_SUCCESS;

480:
481: l_task_det get_task_info%rowtype;
482: BEGIN
483:
484: x_return_status:=FND_API.G_RET_STS_SUCCESS;
485:
486: IF p_x_task_link_rec.visit_task_number is null OR p_x_task_link_rec.visit_task_number=FND_API.G_MISS_CHAR
487: THEN
488: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_NUMBER_NULL');

Line 486: IF p_x_task_link_rec.visit_task_number is null OR p_x_task_link_rec.visit_task_number=FND_API.G_MISS_CHAR

482: BEGIN
483:
484: x_return_status:=FND_API.G_RET_STS_SUCCESS;
485:
486: IF p_x_task_link_rec.visit_task_number is null OR p_x_task_link_rec.visit_task_number=FND_API.G_MISS_CHAR
487: THEN
488: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_NUMBER_NULL');
489: FND_MSG_PUB.ADD;
490: RAISE FND_API.G_EXC_ERROR;

Line 490: RAISE FND_API.G_EXC_ERROR;

486: IF p_x_task_link_rec.visit_task_number is null OR p_x_task_link_rec.visit_task_number=FND_API.G_MISS_CHAR
487: THEN
488: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_TASK_NUMBER_NULL');
489: FND_MSG_PUB.ADD;
490: RAISE FND_API.G_EXC_ERROR;
491:
492: ELSE
493: OPEN get_task_info(p_x_task_link_rec.VISIT_TASK_ID,p_x_task_link_rec.visit_task_number);
494: FETCH get_task_info INTO l_task_det;

Line 501: RAISE FND_API.G_EXC_ERROR;

497: THEN
498: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CONTEXT_TSK_INV');
499: FND_MESSAGE.SET_TOKEN('RECORD',p_x_task_link_rec.visit_Task_number,false);
500: FND_MSG_PUB.ADD;
501: RAISE FND_API.G_EXC_ERROR;
502: ELSE
503: p_x_task_link_rec.parent_task_id:=l_task_det.visit_task_id;
504: -- Commented by amagrawa based on review comments.
505: -- p_x_task_link_rec.visit_task_number:=l_task_det.visit_task_number;

Line 512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

508: CLOSE get_task_info;
509: END IF;
510:
511: EXCEPTION
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,
516: p_data => x_msg_data);

Line 513: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

509: END IF;
510:
511: EXCEPTION
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,
516: p_data => x_msg_data);
517:

Line 514: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

510:
511: EXCEPTION
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,
516: p_data => x_msg_data);
517:
518: WHEN FND_API.G_EXC_ERROR THEN

Line 518: WHEN FND_API.G_EXC_ERROR THEN

514: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,
516: p_data => x_msg_data);
517:
518: WHEN FND_API.G_EXC_ERROR THEN
519: X_return_status := FND_API.G_RET_STS_ERROR;
520: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
521: p_count => x_msg_count,
522: p_data => X_msg_data);

Line 519: X_return_status := FND_API.G_RET_STS_ERROR;

515: p_count => x_msg_count,
516: p_data => x_msg_data);
517:
518: WHEN FND_API.G_EXC_ERROR THEN
519: X_return_status := FND_API.G_RET_STS_ERROR;
520: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
521: p_count => x_msg_count,
522: p_data => X_msg_data);
523: WHEN OTHERS THEN

Line 520: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

516: p_data => x_msg_data);
517:
518: WHEN FND_API.G_EXC_ERROR THEN
519: X_return_status := FND_API.G_RET_STS_ERROR;
520: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
521: p_count => x_msg_count,
522: p_data => X_msg_data);
523: WHEN OTHERS THEN
524: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 524: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

520: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
521: p_count => x_msg_count,
522: p_data => X_msg_data);
523: WHEN OTHERS THEN
524: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
526: THEN
527: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
528: p_procedure_name => 'TRANS_VALUE_ID',

Line 531: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

527: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
528: p_procedure_name => 'TRANS_VALUE_ID',
529: p_error_text => SUBSTR(SQLERRM,1,240));
530: END IF;
531: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
532: p_count => x_msg_count,
533: p_data => X_msg_data);
534: END;
535:

Line 550: x_return_status:=FND_API.G_RET_STS_SUCCESS;

546: l_cyclic_loop EXCEPTION;
547: PRAGMA EXCEPTION_INIT(l_cyclic_loop,-1436);
548: l_counter NUMBER;
549: BEGIN
550: x_return_status:=FND_API.G_RET_STS_SUCCESS;
551:
552: SELECT COUNT(*) INTO l_counter
553: FROM AHL_TASK_LINKS A
554: START WITH VISIT_TASK_ID=P_VISIT_TASK_ID

Line 567: x_return_status := FND_API.G_RET_STS_ERROR;

563: ELSE
564: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_WBS_INVALID'); --WBS rule and Route Dependency are in violation
565: FND_MSG_PUB.ADD;
566: END IF;
567: x_return_status := FND_API.G_RET_STS_ERROR;
568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
569: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
571: p_count => x_msg_count,

Line 568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

564: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_WBS_INVALID'); --WBS rule and Route Dependency are in violation
565: FND_MSG_PUB.ADD;
566: END IF;
567: x_return_status := FND_API.G_RET_STS_ERROR;
568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
569: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
571: p_count => x_msg_count,
572: p_data => x_msg_data);

Line 569: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

565: FND_MSG_PUB.ADD;
566: END IF;
567: x_return_status := FND_API.G_RET_STS_ERROR;
568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
569: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
571: p_count => x_msg_count,
572: p_data => x_msg_data);
573:

Line 570: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

566: END IF;
567: x_return_status := FND_API.G_RET_STS_ERROR;
568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
569: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
571: p_count => x_msg_count,
572: p_data => x_msg_data);
573:
574: WHEN FND_API.G_EXC_ERROR THEN

Line 574: WHEN FND_API.G_EXC_ERROR THEN

570: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
571: p_count => x_msg_count,
572: p_data => x_msg_data);
573:
574: WHEN FND_API.G_EXC_ERROR THEN
575: X_return_status := FND_API.G_RET_STS_ERROR;
576: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
577: p_count => x_msg_count,
578: p_data => X_msg_data);

Line 575: X_return_status := FND_API.G_RET_STS_ERROR;

571: p_count => x_msg_count,
572: p_data => x_msg_data);
573:
574: WHEN FND_API.G_EXC_ERROR THEN
575: X_return_status := FND_API.G_RET_STS_ERROR;
576: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
577: p_count => x_msg_count,
578: p_data => X_msg_data);
579: WHEN OTHERS THEN

Line 576: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

572: p_data => x_msg_data);
573:
574: WHEN FND_API.G_EXC_ERROR THEN
575: X_return_status := FND_API.G_RET_STS_ERROR;
576: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
577: p_count => x_msg_count,
578: p_data => X_msg_data);
579: WHEN OTHERS THEN
580: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 580: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

576: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
577: p_count => x_msg_count,
578: p_data => X_msg_data);
579: WHEN OTHERS THEN
580: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
582: THEN
583: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
584: p_procedure_name => 'NON_CYCLIC_ENF',

Line 587: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

583: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
584: p_procedure_name => 'NON_CYCLIC_ENF',
585: p_error_text => SUBSTR(SQLERRM,1,240));
586: END IF;
587: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
588: p_count => x_msg_count,
589: p_data => X_msg_data);
590: END;
591:

Line 653: RAISE FND_API.G_EXC_ERROR;

649:
650: l_msg_count := FND_MSG_PUB.count_msg;
651: IF l_msg_count > 0
652: THEN
653: RAISE FND_API.G_EXC_ERROR;
654: END IF;
655:
656:
657:

Line 734: IF l_return_Status = FND_API.G_RET_STS_ERROR THEN

730: );
731:
732: -- Added by amagrawa based on review comments.
733: IF l_return_Status <>'S' THEN
734: IF l_return_Status = FND_API.G_RET_STS_ERROR THEN
735: RAISE FND_API.G_EXC_ERROR;
736: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN
737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
738: END IF;

Line 735: RAISE FND_API.G_EXC_ERROR;

731:
732: -- Added by amagrawa based on review comments.
733: IF l_return_Status <>'S' THEN
734: IF l_return_Status = FND_API.G_RET_STS_ERROR THEN
735: RAISE FND_API.G_EXC_ERROR;
736: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN
737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
738: END IF;
739:

Line 736: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN

732: -- Added by amagrawa based on review comments.
733: IF l_return_Status <>'S' THEN
734: IF l_return_Status = FND_API.G_RET_STS_ERROR THEN
735: RAISE FND_API.G_EXC_ERROR;
736: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN
737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
738: END IF;
739:
740: END IF;

Line 737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

733: IF l_return_Status <>'S' THEN
734: IF l_return_Status = FND_API.G_RET_STS_ERROR THEN
735: RAISE FND_API.G_EXC_ERROR;
736: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN
737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
738: END IF;
739:
740: END IF;
741:

Line 754: IF l_return_Status = FND_API.G_RET_STS_ERROR THEN

750: p_task_link_rec =>P_task_link_rec
751: );
752:
753: IF l_return_Status <>'S' THEN
754: IF l_return_Status = FND_API.G_RET_STS_ERROR THEN
755: RAISE FND_API.G_EXC_ERROR;
756: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: END IF;

Line 755: RAISE FND_API.G_EXC_ERROR;

751: );
752:
753: IF l_return_Status <>'S' THEN
754: IF l_return_Status = FND_API.G_RET_STS_ERROR THEN
755: RAISE FND_API.G_EXC_ERROR;
756: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: END IF;
759: END IF;

Line 756: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN

752:
753: IF l_return_Status <>'S' THEN
754: IF l_return_Status = FND_API.G_RET_STS_ERROR THEN
755: RAISE FND_API.G_EXC_ERROR;
756: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: END IF;
759: END IF;
760: -- VWP ER-12424063:: tchimira:: call validate vwp links after insering the task rule::end

Line 757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

753: IF l_return_Status <>'S' THEN
754: IF l_return_Status = FND_API.G_RET_STS_ERROR THEN
755: RAISE FND_API.G_EXC_ERROR;
756: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: END IF;
759: END IF;
760: -- VWP ER-12424063:: tchimira:: call validate vwp links after insering the task rule::end
761:

Line 765: p_init_msg_list => Fnd_Api.G_FALSE,

761:
762: -- Added cxcheng POST11510--------------
763: --Now adjust the times derivation for the child task
764: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,
765: p_init_msg_list => Fnd_Api.G_FALSE,
766: p_commit => Fnd_Api.G_FALSE,
767: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
768: x_return_status => l_return_status,
769: x_msg_count => l_msg_count,

Line 766: p_commit => Fnd_Api.G_FALSE,

762: -- Added cxcheng POST11510--------------
763: --Now adjust the times derivation for the child task
764: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,
765: p_init_msg_list => Fnd_Api.G_FALSE,
766: p_commit => Fnd_Api.G_FALSE,
767: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
768: x_return_status => l_return_status,
769: x_msg_count => l_msg_count,
770: x_msg_data => l_msg_data,

Line 767: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

763: --Now adjust the times derivation for the child task
764: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,
765: p_init_msg_list => Fnd_Api.G_FALSE,
766: p_commit => Fnd_Api.G_FALSE,
767: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
768: x_return_status => l_return_status,
769: x_msg_count => l_msg_count,
770: x_msg_data => l_msg_data,
771: p_task_id => P_task_link_rec.visit_task_id);

Line 777: IF l_return_Status = FND_API.G_RET_STS_ERROR

773:
774: -- Added by amagrawa based on review comments.
775: IF l_return_Status <>'S'
776: THEN
777: IF l_return_Status = FND_API.G_RET_STS_ERROR
778: THEN
779: RAISE FND_API.G_EXC_ERROR;
780: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR
781: THEN

Line 779: RAISE FND_API.G_EXC_ERROR;

775: IF l_return_Status <>'S'
776: THEN
777: IF l_return_Status = FND_API.G_RET_STS_ERROR
778: THEN
779: RAISE FND_API.G_EXC_ERROR;
780: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR
781: THEN
782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
783: END IF;

Line 780: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR

776: THEN
777: IF l_return_Status = FND_API.G_RET_STS_ERROR
778: THEN
779: RAISE FND_API.G_EXC_ERROR;
780: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR
781: THEN
782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
783: END IF;
784:

Line 782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

778: THEN
779: RAISE FND_API.G_EXC_ERROR;
780: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR
781: THEN
782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
783: END IF;
784:
785: END IF;
786:

Line 790: RAISE FND_API.G_EXC_ERROR;

786:
787: l_msg_count := FND_MSG_PUB.count_msg;
788: IF l_msg_count > 0
789: THEN
790: RAISE FND_API.G_EXC_ERROR;
791: END IF;
792:
793: END Create_Task_Links;
794:

Line 825: RAISE FND_API.G_EXC_ERROR;

821: IF SQL%ROWCOUNT=0
822: THEN
823: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
824: FND_MSG_PUB.ADD;
825: RAISE FND_API.G_EXC_ERROR;
826: END IF;
827:
828:
829: -- Added cxcheng POST11510--------------

Line 832: p_init_msg_list => Fnd_Api.G_FALSE,

828:
829: -- Added cxcheng POST11510--------------
830: --Now adjust the times derivation for the child task. Parent doesn't matter
831: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,
832: p_init_msg_list => Fnd_Api.G_FALSE,
833: p_commit => Fnd_Api.G_FALSE,
834: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
835: x_return_status => l_return_status,
836: x_msg_count => l_msg_count,

Line 833: p_commit => Fnd_Api.G_FALSE,

829: -- Added cxcheng POST11510--------------
830: --Now adjust the times derivation for the child task. Parent doesn't matter
831: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,
832: p_init_msg_list => Fnd_Api.G_FALSE,
833: p_commit => Fnd_Api.G_FALSE,
834: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
835: x_return_status => l_return_status,
836: x_msg_count => l_msg_count,
837: x_msg_data => l_msg_data,

Line 834: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

830: --Now adjust the times derivation for the child task. Parent doesn't matter
831: AHL_VWP_TIMES_PVT.Adjust_Task_Times(p_api_version => 1.0,
832: p_init_msg_list => Fnd_Api.G_FALSE,
833: p_commit => Fnd_Api.G_FALSE,
834: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
835: x_return_status => l_return_status,
836: x_msg_count => l_msg_count,
837: x_msg_data => l_msg_data,
838: p_task_id => l_child_task_id);

Line 843: IF l_return_Status = FND_API.G_RET_STS_ERROR

839:
840: -- Added by amagrawa based on review comments.
841: IF l_return_Status <>'S'
842: THEN
843: IF l_return_Status = FND_API.G_RET_STS_ERROR
844: THEN
845: RAISE FND_API.G_EXC_ERROR;
846: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR
847: THEN

Line 845: RAISE FND_API.G_EXC_ERROR;

841: IF l_return_Status <>'S'
842: THEN
843: IF l_return_Status = FND_API.G_RET_STS_ERROR
844: THEN
845: RAISE FND_API.G_EXC_ERROR;
846: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR
847: THEN
848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
849: END IF;

Line 846: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR

842: THEN
843: IF l_return_Status = FND_API.G_RET_STS_ERROR
844: THEN
845: RAISE FND_API.G_EXC_ERROR;
846: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR
847: THEN
848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
849: END IF;
850:

Line 848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

844: THEN
845: RAISE FND_API.G_EXC_ERROR;
846: ELSIF l_return_Status = FND_API.G_RET_STS_UNEXP_ERROR
847: THEN
848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
849: END IF;
850:
851: END IF;
852:

Line 856: RAISE FND_API.G_EXC_ERROR;

852:
853: l_msg_count := FND_MSG_PUB.count_msg;
854: IF l_msg_count > 0
855: THEN
856: RAISE FND_API.G_EXC_ERROR;
857: END IF;
858:
859: END DELETE_TASK_LINKS;
860:

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

860:
861: PROCEDURE PROCESS_TASK_LINKS
862: (
863: p_api_version IN NUMBER := 1.0,
864: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
865: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
866: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
867: p_default IN VARCHAR2 := FND_API.G_FALSE,
868: p_module_type IN VARCHAR2 := NULL,

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

861: PROCEDURE PROCESS_TASK_LINKS
862: (
863: p_api_version IN NUMBER := 1.0,
864: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
865: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
866: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
867: p_default IN VARCHAR2 := FND_API.G_FALSE,
868: p_module_type IN VARCHAR2 := NULL,
869: x_return_status OUT NOCOPY VARCHAR2,

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

862: (
863: p_api_version IN NUMBER := 1.0,
864: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
865: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
866: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
867: p_default IN VARCHAR2 := FND_API.G_FALSE,
868: p_module_type IN VARCHAR2 := NULL,
869: x_return_status OUT NOCOPY VARCHAR2,
870: x_msg_count OUT NOCOPY NUMBER,

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

863: p_api_version IN NUMBER := 1.0,
864: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
865: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
866: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
867: p_default IN VARCHAR2 := FND_API.G_FALSE,
868: p_module_type IN VARCHAR2 := NULL,
869: x_return_status OUT NOCOPY VARCHAR2,
870: x_msg_count OUT NOCOPY NUMBER,
871: x_msg_data OUT NOCOPY VARCHAR2,

Line 906: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;

902: l_api_version CONSTANT NUMBER := 1.0;
903: l_msg_count NUMBER;
904: l_msg_data VARCHAR2(2000);
905: l_return_status VARCHAR2(1);
906: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
907: l_commit VARCHAR2(1):= FND_API.G_FALSE;
908: l_TASK_LINK_tbl TASK_LINK_TBL:=p_x_task_link_tbl;
909: L_TASK_LINK_REC TASK_LINK_REC;
910: l_status_code VARCHAR2(30);

Line 907: l_commit VARCHAR2(1):= FND_API.G_FALSE;

903: l_msg_count NUMBER;
904: l_msg_data VARCHAR2(2000);
905: l_return_status VARCHAR2(1);
906: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
907: l_commit VARCHAR2(1):= FND_API.G_FALSE;
908: l_TASK_LINK_tbl TASK_LINK_TBL:=p_x_task_link_tbl;
909: L_TASK_LINK_REC TASK_LINK_REC;
910: l_status_code VARCHAR2(30);
911: l_task_id NUMBER;

Line 924: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

920: SAVEPOINT PROCESS_TASK_LINKS;
921:
922: -- Standard call to check for call compatibility.
923:
924: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
925: p_api_version,
926: l_api_name,G_PKG_NAME) THEN
927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
928: END IF;

Line 927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

923:
924: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
925: p_api_version,
926: l_api_name,G_PKG_NAME) THEN
927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
928: END IF;
929:
930: -- Initialize message list if p_init_msg_list is set to TRUE.
931: IF FND_API.to_boolean(l_init_msg_list) THEN

Line 931: IF FND_API.to_boolean(l_init_msg_list) THEN

927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
928: END IF;
929:
930: -- Initialize message list if p_init_msg_list is set to TRUE.
931: IF FND_API.to_boolean(l_init_msg_list) THEN
932: FND_MSG_PUB.initialize;
933: END IF;
934:
935:

Line 953: x_return_status := FND_API.G_RET_STS_SUCCESS;

949:
950:
951: -- Initialize API return status to success
952:
953: x_return_status := FND_API.G_RET_STS_SUCCESS;
954:
955:
956: --Start of API Body
957:

Line 986: IF x_return_Status = FND_API.G_RET_STS_ERROR

982:
983: -- Added by amagrawa based on review comments.
984: IF x_return_Status <>'S'
985: THEN
986: IF x_return_Status = FND_API.G_RET_STS_ERROR
987: THEN
988: RAISE FND_API.G_EXC_ERROR;
989: ELSIF x_return_Status = FND_API.G_RET_STS_UNEXP_ERROR
990: THEN

Line 988: RAISE FND_API.G_EXC_ERROR;

984: IF x_return_Status <>'S'
985: THEN
986: IF x_return_Status = FND_API.G_RET_STS_ERROR
987: THEN
988: RAISE FND_API.G_EXC_ERROR;
989: ELSIF x_return_Status = FND_API.G_RET_STS_UNEXP_ERROR
990: THEN
991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
992: END IF;

Line 989: ELSIF x_return_Status = FND_API.G_RET_STS_UNEXP_ERROR

985: THEN
986: IF x_return_Status = FND_API.G_RET_STS_ERROR
987: THEN
988: RAISE FND_API.G_EXC_ERROR;
989: ELSIF x_return_Status = FND_API.G_RET_STS_UNEXP_ERROR
990: THEN
991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
992: END IF;
993: END IF;

Line 991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

987: THEN
988: RAISE FND_API.G_EXC_ERROR;
989: ELSIF x_return_Status = FND_API.G_RET_STS_UNEXP_ERROR
990: THEN
991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
992: END IF;
993: END IF;
994:
995: l_TASK_LINK_tbl(i).parent_task_id:=l_TASK_LINK_rec.parent_task_id;

Line 1008: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1004: -- Commented by amagrawa based on review comments.
1005: /* l_msg_count := FND_MSG_PUB.count_msg;
1006: IF l_msg_count > 0 THEN
1007: X_msg_count := l_msg_count;
1008: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1009: RAISE FND_API.G_EXC_ERROR;
1010: END IF;
1011: */
1012: IF G_DEBUG='Y' THEN

Line 1009: RAISE FND_API.G_EXC_ERROR;

1005: /* l_msg_count := FND_MSG_PUB.count_msg;
1006: IF l_msg_count > 0 THEN
1007: X_msg_count := l_msg_count;
1008: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1009: RAISE FND_API.G_EXC_ERROR;
1010: END IF;
1011: */
1012: IF G_DEBUG='Y' THEN
1013: AHL_DEBUG_PUB.debug( L_FULL_NAME||' After Translate','+VWP_HIERARCHY+');

Line 1055: x_return_status := FND_API.G_RET_STS_ERROR;

1051:
1052: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_INV_TASK_STATUS');
1053: FND_MESSAGE.SET_TOKEN('RECORD',l_TASK_LINK_tbl(i).visit_task_number ,false);
1054: FND_MSG_PUB.ADD;
1055: x_return_status := FND_API.G_RET_STS_ERROR;
1056:
1057: ELSE
1058: l_TASK_LINK_rec.object_version_number :=l_TASK_LINK_tbl(i).object_version_number;
1059: l_TASK_LINK_rec.visit_task_id :=l_TASK_LINK_tbl(i).visit_task_id;

Line 1067: -- IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )

1063: l_TASK_LINK_rec.visit_task_id :=l_TASK_LINK_tbl(i).visit_task_id;
1064: l_TASK_LINK_rec.dml_operation :=l_TASK_LINK_tbl(i).DML_OPERATION;
1065:
1066:
1067: -- IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )
1068: -- THEN
1069: /* IF l_TASK_LINK_TBL(i).DML_OPERATION<>'D'
1070: THEN
1071:

Line 1125: p_init_msg_list => Fnd_Api.G_FALSE,

1121: IF l_visit_end_date IS NOT NULL THEN
1122:
1123: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials
1124: (p_api_version => p_api_version,
1125: p_init_msg_list => Fnd_Api.G_FALSE,
1126: p_commit => Fnd_Api.G_FALSE,
1127: p_visit_id => l_visit_csr_rec.visit_id,
1128: p_visit_task_id => NULL,
1129: p_org_id => NULL,

Line 1126: p_commit => Fnd_Api.G_FALSE,

1122:
1123: AHL_LTP_REQST_MATRL_PVT.Process_Planned_Materials
1124: (p_api_version => p_api_version,
1125: p_init_msg_list => Fnd_Api.G_FALSE,
1126: p_commit => Fnd_Api.G_FALSE,
1127: p_visit_id => l_visit_csr_rec.visit_id,
1128: p_visit_task_id => NULL,
1129: p_org_id => NULL,
1130: p_start_date => NULL,

Line 1139: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

1135: x_msg_data => l_msg_data);
1136:
1137:
1138:
1139: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
1140: X_msg_count := l_msg_count;
1141: X_return_status := Fnd_Api.G_RET_STS_ERROR;
1142: RAISE Fnd_Api.G_EXC_ERROR;
1143: END IF;

Line 1141: X_return_status := Fnd_Api.G_RET_STS_ERROR;

1137:
1138:
1139: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
1140: X_msg_count := l_msg_count;
1141: X_return_status := Fnd_Api.G_RET_STS_ERROR;
1142: RAISE Fnd_Api.G_EXC_ERROR;
1143: END IF;
1144:
1145: END IF;

Line 1142: RAISE Fnd_Api.G_EXC_ERROR;

1138:
1139: IF l_msg_count > 0 OR NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
1140: X_msg_count := l_msg_count;
1141: X_return_status := Fnd_Api.G_RET_STS_ERROR;
1142: RAISE Fnd_Api.G_EXC_ERROR;
1143: END IF;
1144:
1145: END IF;
1146:

Line 1156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1152: p_visit_id =>l_visit_csr_rec.visit_id,
1153: p_flag =>'Y',
1154: x_return_status =>x_return_status);
1155: END IF;
1156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1157: CLOSE C_VISIT;
1158: RAISE FND_API.G_EXC_ERROR;
1159: END IF;
1160: END IF;

Line 1158: RAISE FND_API.G_EXC_ERROR;

1154: x_return_status =>x_return_status);
1155: END IF;
1156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1157: CLOSE C_VISIT;
1158: RAISE FND_API.G_EXC_ERROR;
1159: END IF;
1160: END IF;
1161: CLOSE C_VISIT;
1162:

Line 1167: X_return_status := FND_API.G_RET_STS_ERROR;

1163: END IF;
1164: l_msg_count := FND_MSG_PUB.count_msg;
1165: IF l_msg_count > 0 THEN
1166: X_msg_count := l_msg_count;
1167: X_return_status := FND_API.G_RET_STS_ERROR;
1168: RAISE FND_API.G_EXC_ERROR;
1169: END IF;
1170:
1171:

Line 1168: RAISE FND_API.G_EXC_ERROR;

1164: l_msg_count := FND_MSG_PUB.count_msg;
1165: IF l_msg_count > 0 THEN
1166: X_msg_count := l_msg_count;
1167: X_return_status := FND_API.G_RET_STS_ERROR;
1168: RAISE FND_API.G_EXC_ERROR;
1169: END IF;
1170:
1171:
1172: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 1172: IF FND_API.TO_BOOLEAN(p_commit) THEN

1168: RAISE FND_API.G_EXC_ERROR;
1169: END IF;
1170:
1171:
1172: IF FND_API.TO_BOOLEAN(p_commit) THEN
1173: COMMIT;
1174: END IF;
1175: -- Debug info
1176:

Line 1188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1184: AHL_DEBUG_PUB.disable_debug;
1185: END IF;
1186:
1187: EXCEPTION
1188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1189: ROLLBACK TO PROCESS_TASK_LINKS;
1190: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1191: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1192: p_count => x_msg_count,

Line 1190: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1186:
1187: EXCEPTION
1188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1189: ROLLBACK TO PROCESS_TASK_LINKS;
1190: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1191: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1192: p_count => x_msg_count,
1193: p_data => x_msg_data);
1194:

Line 1191: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1187: EXCEPTION
1188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1189: ROLLBACK TO PROCESS_TASK_LINKS;
1190: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1191: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1192: p_count => x_msg_count,
1193: p_data => x_msg_data);
1194:
1195: WHEN FND_API.G_EXC_ERROR THEN

Line 1195: WHEN FND_API.G_EXC_ERROR THEN

1191: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1192: p_count => x_msg_count,
1193: p_data => x_msg_data);
1194:
1195: WHEN FND_API.G_EXC_ERROR THEN
1196: ROLLBACK TO PROCESS_TASK_LINKS;
1197: X_return_status := FND_API.G_RET_STS_ERROR;
1198: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1199: p_count => x_msg_count,

Line 1197: X_return_status := FND_API.G_RET_STS_ERROR;

1193: p_data => x_msg_data);
1194:
1195: WHEN FND_API.G_EXC_ERROR THEN
1196: ROLLBACK TO PROCESS_TASK_LINKS;
1197: X_return_status := FND_API.G_RET_STS_ERROR;
1198: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1199: p_count => x_msg_count,
1200: p_data => X_msg_data);
1201: WHEN OTHERS THEN

Line 1198: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1194:
1195: WHEN FND_API.G_EXC_ERROR THEN
1196: ROLLBACK TO PROCESS_TASK_LINKS;
1197: X_return_status := FND_API.G_RET_STS_ERROR;
1198: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1199: p_count => x_msg_count,
1200: p_data => X_msg_data);
1201: WHEN OTHERS THEN
1202: ROLLBACK TO PROCESS_TASK_LINKS;

Line 1203: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1199: p_count => x_msg_count,
1200: p_data => X_msg_data);
1201: WHEN OTHERS THEN
1202: ROLLBACK TO PROCESS_TASK_LINKS;
1203: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1204: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1205: THEN
1206: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_TASKS_LINKS_PVT',
1207: p_procedure_name => 'PROCESS_TASK_LINKS',

Line 1210: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1206: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_TASKS_LINKS_PVT',
1207: p_procedure_name => 'PROCESS_TASK_LINKS',
1208: p_error_text => SUBSTR(SQLERRM,1,240));
1209: END IF;
1210: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1211: p_count => x_msg_count,
1212: p_data => X_msg_data);
1213: END;
1214: