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_VWP_DEPT_SHIFTS_PUB dependencies on FND_API

Line 13: IF p_x_vwp_deptshift_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_NUM

9: p_x_vwp_deptshift_rec IN OUT NOCOPY AHL_VWP_DEPT_SHIFTS_PUB.vwp_deptshift_rec
10: )
11: AS
12: BEGIN
13: IF p_x_vwp_deptshift_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_NUM
14: THEN
15: p_x_vwp_deptshift_rec.OBJECT_VERSION_NUMBER:=NULL;
16: END IF;
17:

Line 18: IF p_x_vwp_deptshift_rec.DEPARTMENT_ID= FND_API.G_MISS_NUM

14: THEN
15: p_x_vwp_deptshift_rec.OBJECT_VERSION_NUMBER:=NULL;
16: END IF;
17:
18: IF p_x_vwp_deptshift_rec.DEPARTMENT_ID= FND_API.G_MISS_NUM
19: THEN
20: p_x_vwp_deptshift_rec.DEPARTMENT_ID:=NULL;
21: END IF;
22:

Line 23: IF p_x_vwp_deptshift_rec.SHIFT_NUM= FND_API.G_MISS_NUM

19: THEN
20: p_x_vwp_deptshift_rec.DEPARTMENT_ID:=NULL;
21: END IF;
22:
23: IF p_x_vwp_deptshift_rec.SHIFT_NUM= FND_API.G_MISS_NUM
24: THEN
25: p_x_vwp_deptshift_rec.SHIFT_NUM:=NULL;
26: END IF;
27:

Line 28: IF p_x_vwp_deptshift_rec.SEQ_NUM= FND_API.G_MISS_NUM

24: THEN
25: p_x_vwp_deptshift_rec.SHIFT_NUM:=NULL;
26: END IF;
27:
28: IF p_x_vwp_deptshift_rec.SEQ_NUM= FND_API.G_MISS_NUM
29: THEN
30: p_x_vwp_deptshift_rec.SEQ_NUM:=NULL;
31: END IF;
32:

Line 33: IF p_x_vwp_deptshift_rec.CALENDAR_CODE= FND_API.G_MISS_CHAR

29: THEN
30: p_x_vwp_deptshift_rec.SEQ_NUM:=NULL;
31: END IF;
32:
33: IF p_x_vwp_deptshift_rec.CALENDAR_CODE= FND_API.G_MISS_CHAR
34: THEN
35: p_x_vwp_deptshift_rec.CALENDAR_CODE:=NULL;
36: END IF;
37:

Line 38: IF p_x_vwp_deptshift_Rec.ATTRIBUTE_CATEGORY IS NULL OR p_x_vwp_deptshift_Rec.ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR

34: THEN
35: p_x_vwp_deptshift_rec.CALENDAR_CODE:=NULL;
36: END IF;
37:
38: IF p_x_vwp_deptshift_Rec.ATTRIBUTE_CATEGORY IS NULL OR p_x_vwp_deptshift_Rec.ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR
39: THEN
40: p_x_vwp_deptshift_Rec.ATTRIBUTE_CATEGORY:=NULL;
41: END IF;
42:

Line 43: IF p_x_vwp_deptshift_Rec.ATTRIBUTE1=FND_API.G_MISS_CHAR

39: THEN
40: p_x_vwp_deptshift_Rec.ATTRIBUTE_CATEGORY:=NULL;
41: END IF;
42:
43: IF p_x_vwp_deptshift_Rec.ATTRIBUTE1=FND_API.G_MISS_CHAR
44: THEN
45: p_x_vwp_deptshift_Rec.ATTRIBUTE1:=NULL;
46: END IF;
47:

Line 48: IF p_x_vwp_deptshift_Rec.ATTRIBUTE2=FND_API.G_MISS_CHAR

44: THEN
45: p_x_vwp_deptshift_Rec.ATTRIBUTE1:=NULL;
46: END IF;
47:
48: IF p_x_vwp_deptshift_Rec.ATTRIBUTE2=FND_API.G_MISS_CHAR
49: THEN
50: p_x_vwp_deptshift_Rec.ATTRIBUTE2:=NULL;
51: END IF;
52:

Line 53: IF p_x_vwp_deptshift_Rec.ATTRIBUTE3=FND_API.G_MISS_CHAR

49: THEN
50: p_x_vwp_deptshift_Rec.ATTRIBUTE2:=NULL;
51: END IF;
52:
53: IF p_x_vwp_deptshift_Rec.ATTRIBUTE3=FND_API.G_MISS_CHAR
54: THEN
55: p_x_vwp_deptshift_Rec.ATTRIBUTE3:=NULL;
56: END IF;
57:

Line 58: IF p_x_vwp_deptshift_Rec.ATTRIBUTE4 IS NULL OR p_x_vwp_deptshift_Rec.ATTRIBUTE4=FND_API.G_MISS_CHAR

54: THEN
55: p_x_vwp_deptshift_Rec.ATTRIBUTE3:=NULL;
56: END IF;
57:
58: IF p_x_vwp_deptshift_Rec.ATTRIBUTE4 IS NULL OR p_x_vwp_deptshift_Rec.ATTRIBUTE4=FND_API.G_MISS_CHAR
59: THEN
60: p_x_vwp_deptshift_Rec.ATTRIBUTE4:=NULL;
61: END IF;
62:

Line 63: IF p_x_vwp_deptshift_Rec.ATTRIBUTE5=FND_API.G_MISS_CHAR

59: THEN
60: p_x_vwp_deptshift_Rec.ATTRIBUTE4:=NULL;
61: END IF;
62:
63: IF p_x_vwp_deptshift_Rec.ATTRIBUTE5=FND_API.G_MISS_CHAR
64: THEN
65: p_x_vwp_deptshift_Rec.ATTRIBUTE5:=NULL;
66: END IF;
67:

Line 68: IF p_x_vwp_deptshift_Rec.ATTRIBUTE6=FND_API.G_MISS_CHAR

64: THEN
65: p_x_vwp_deptshift_Rec.ATTRIBUTE5:=NULL;
66: END IF;
67:
68: IF p_x_vwp_deptshift_Rec.ATTRIBUTE6=FND_API.G_MISS_CHAR
69: THEN
70: p_x_vwp_deptshift_Rec.ATTRIBUTE6:=NULL;
71: END IF;
72:

Line 73: IF p_x_vwp_deptshift_Rec.ATTRIBUTE7=FND_API.G_MISS_CHAR

69: THEN
70: p_x_vwp_deptshift_Rec.ATTRIBUTE6:=NULL;
71: END IF;
72:
73: IF p_x_vwp_deptshift_Rec.ATTRIBUTE7=FND_API.G_MISS_CHAR
74: THEN
75: p_x_vwp_deptshift_Rec.ATTRIBUTE7:=NULL;
76: END IF;
77:

Line 78: IF p_x_vwp_deptshift_Rec.ATTRIBUTE8=FND_API.G_MISS_CHAR

74: THEN
75: p_x_vwp_deptshift_Rec.ATTRIBUTE7:=NULL;
76: END IF;
77:
78: IF p_x_vwp_deptshift_Rec.ATTRIBUTE8=FND_API.G_MISS_CHAR
79: THEN
80: p_x_vwp_deptshift_Rec.ATTRIBUTE8:=NULL;
81: END IF;
82:

Line 83: IF p_x_vwp_deptshift_Rec.ATTRIBUTE9=FND_API.G_MISS_CHAR

79: THEN
80: p_x_vwp_deptshift_Rec.ATTRIBUTE8:=NULL;
81: END IF;
82:
83: IF p_x_vwp_deptshift_Rec.ATTRIBUTE9=FND_API.G_MISS_CHAR
84: THEN
85: p_x_vwp_deptshift_Rec.ATTRIBUTE9:=NULL;
86: END IF;
87:

Line 88: IF p_x_vwp_deptshift_Rec.ATTRIBUTE10=FND_API.G_MISS_CHAR

84: THEN
85: p_x_vwp_deptshift_Rec.ATTRIBUTE9:=NULL;
86: END IF;
87:
88: IF p_x_vwp_deptshift_Rec.ATTRIBUTE10=FND_API.G_MISS_CHAR
89: THEN
90: p_x_vwp_deptshift_Rec.ATTRIBUTE10:=NULL;
91: END IF;
92:

Line 93: IF p_x_vwp_deptshift_Rec.ATTRIBUTE11=FND_API.G_MISS_CHAR

89: THEN
90: p_x_vwp_deptshift_Rec.ATTRIBUTE10:=NULL;
91: END IF;
92:
93: IF p_x_vwp_deptshift_Rec.ATTRIBUTE11=FND_API.G_MISS_CHAR
94: THEN
95: p_x_vwp_deptshift_Rec.ATTRIBUTE11:=NULL;
96: END IF;
97:

Line 98: IF p_x_vwp_deptshift_Rec.ATTRIBUTE12 IS NULL OR p_x_vwp_deptshift_Rec.ATTRIBUTE12=FND_API.G_MISS_CHAR

94: THEN
95: p_x_vwp_deptshift_Rec.ATTRIBUTE11:=NULL;
96: END IF;
97:
98: IF p_x_vwp_deptshift_Rec.ATTRIBUTE12 IS NULL OR p_x_vwp_deptshift_Rec.ATTRIBUTE12=FND_API.G_MISS_CHAR
99: THEN
100: p_x_vwp_deptshift_Rec.ATTRIBUTE12:=NULL;
101: END IF;
102:

Line 103: IF p_x_vwp_deptshift_Rec.ATTRIBUTE13=FND_API.G_MISS_CHAR

99: THEN
100: p_x_vwp_deptshift_Rec.ATTRIBUTE12:=NULL;
101: END IF;
102:
103: IF p_x_vwp_deptshift_Rec.ATTRIBUTE13=FND_API.G_MISS_CHAR
104: THEN
105: p_x_vwp_deptshift_Rec.ATTRIBUTE13:=NULL;
106: END IF;
107:

Line 108: IF p_x_vwp_deptshift_Rec.ATTRIBUTE14=FND_API.G_MISS_CHAR

104: THEN
105: p_x_vwp_deptshift_Rec.ATTRIBUTE13:=NULL;
106: END IF;
107:
108: IF p_x_vwp_deptshift_Rec.ATTRIBUTE14=FND_API.G_MISS_CHAR
109: THEN
110: p_x_vwp_deptshift_Rec.ATTRIBUTE14:=NULL;
111: END IF;
112:

Line 113: IF p_x_vwp_deptshift_Rec.ATTRIBUTE15=FND_API.G_MISS_CHAR

109: THEN
110: p_x_vwp_deptshift_Rec.ATTRIBUTE14:=NULL;
111: END IF;
112:
113: IF p_x_vwp_deptshift_Rec.ATTRIBUTE15=FND_API.G_MISS_CHAR
114: THEN
115: p_x_vwp_deptshift_Rec.ATTRIBUTE15:=NULL;
116: END IF;
117: END;

Line 176: x_return_status:=FND_API.G_RET_STS_SUCCESS;

172: BEGIN
173: IF G_DEBUG='Y' THEN
174: AHL_DEBUG_PUB.enable_debug;
175: END IF;
176: x_return_status:=FND_API.G_RET_STS_SUCCESS;
177: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside translate1 -- l_check_flag' || l_check_flag);
178: IF p_x_vwp_deptshift_rec.ORGANIZATION_NAME IS NULL OR p_x_vwp_deptshift_rec.ORGANIZATION_NAME=FND_API.G_MISS_CHAR
179: THEN
180: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside organization-- l_check_flag' || l_check_flag);

Line 178: IF p_x_vwp_deptshift_rec.ORGANIZATION_NAME IS NULL OR p_x_vwp_deptshift_rec.ORGANIZATION_NAME=FND_API.G_MISS_CHAR

174: AHL_DEBUG_PUB.enable_debug;
175: END IF;
176: x_return_status:=FND_API.G_RET_STS_SUCCESS;
177: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside translate1 -- l_check_flag' || l_check_flag);
178: IF p_x_vwp_deptshift_rec.ORGANIZATION_NAME IS NULL OR p_x_vwp_deptshift_rec.ORGANIZATION_NAME=FND_API.G_MISS_CHAR
179: THEN
180: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside organization-- l_check_flag' || l_check_flag);
181: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_ORG_NAME_NULL');
182: FND_MSG_PUB.ADD;

Line 200: IF p_x_vwp_deptshift_rec.DEPT_DESCRIPTION IS NULL OR p_x_vwp_deptshift_rec.DEPT_DESCRIPTION=FND_API.G_MISS_CHAR

196: END IF;
197:
198: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside translate3 -- l_check_flag' || l_check_flag);
199: l_check_flag:='N';
200: IF p_x_vwp_deptshift_rec.DEPT_DESCRIPTION IS NULL OR p_x_vwp_deptshift_rec.DEPT_DESCRIPTION=FND_API.G_MISS_CHAR
201: THEN
202: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside department-- l_check_flag' || l_check_flag);
203: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_DEPT_NAME_NULL');
204: FND_MSG_PUB.ADD;

Line 226: IF p_x_vwp_deptshift_rec.CALENDAR_DESCRIPTION IS NULL OR p_x_vwp_deptshift_rec.CALENDAR_DESCRIPTION=FND_API.G_MISS_CHAR

222:
223: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside translate2 -- l_check_flag' || l_check_flag);
224:
225: l_check_flag:='N';
226: IF p_x_vwp_deptshift_rec.CALENDAR_DESCRIPTION IS NULL OR p_x_vwp_deptshift_rec.CALENDAR_DESCRIPTION=FND_API.G_MISS_CHAR
227: THEN
228: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside calender-- l_check_flag' || l_check_flag);
229: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_CALENDER_NAME_NULL');
230: FND_MSG_PUB.ADD;

Line 255: IF p_x_vwp_deptshift_rec.SHIFT_NUM IS NULL OR p_x_vwp_deptshift_rec.SHIFT_NUM=FND_API.G_MISS_NUM

251:
252: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside translate2 -- l_check_flag' || l_check_flag);
253:
254: l_check_flag:='N';
255: IF p_x_vwp_deptshift_rec.SHIFT_NUM IS NULL OR p_x_vwp_deptshift_rec.SHIFT_NUM=FND_API.G_MISS_NUM
256: THEN
257: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside shift number-- l_check_flag' || l_check_flag);
258: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_SHIFT_NUMBER_NULL');
259: FND_MSG_PUB.ADD;

Line 285: IF p_x_vwp_deptshift_rec.SEQ_NAME IS NULL OR p_x_vwp_deptshift_rec.SEQ_NAME=FND_API.G_MISS_CHAR

281: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside translate2 -- l_check_flag' || l_check_flag);
282: END IF;
283:
284: l_check_flag:='N';
285: IF p_x_vwp_deptshift_rec.SEQ_NAME IS NULL OR p_x_vwp_deptshift_rec.SEQ_NAME=FND_API.G_MISS_CHAR
286: THEN
287: IF G_DEBUG='Y' THEN
288: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside sequence number-- l_check_flag' || l_check_flag);
289: END IF;

Line 319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

315: AHL_DEBUG_PUB.disable_debug;
316: END IF;
317:
318: EXCEPTION
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
322: p_count => x_msg_count,
323: p_data => x_msg_data);

Line 320: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

316: END IF;
317:
318: EXCEPTION
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
322: p_count => x_msg_count,
323: p_data => x_msg_data);
324:

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

317:
318: EXCEPTION
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
322: p_count => x_msg_count,
323: p_data => x_msg_data);
324:
325: WHEN FND_API.G_EXC_ERROR THEN

Line 325: WHEN FND_API.G_EXC_ERROR THEN

321: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
322: p_count => x_msg_count,
323: p_data => x_msg_data);
324:
325: WHEN FND_API.G_EXC_ERROR THEN
326: X_return_status := FND_API.G_RET_STS_ERROR;
327: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count,
329: p_data => X_msg_data);

Line 326: X_return_status := FND_API.G_RET_STS_ERROR;

322: p_count => x_msg_count,
323: p_data => x_msg_data);
324:
325: WHEN FND_API.G_EXC_ERROR THEN
326: X_return_status := FND_API.G_RET_STS_ERROR;
327: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count,
329: p_data => X_msg_data);
330: WHEN OTHERS THEN

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

323: p_data => x_msg_data);
324:
325: WHEN FND_API.G_EXC_ERROR THEN
326: X_return_status := FND_API.G_RET_STS_ERROR;
327: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count,
329: p_data => X_msg_data);
330: WHEN OTHERS THEN
331: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 331: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

327: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
328: p_count => x_msg_count,
329: p_data => X_msg_data);
330: WHEN OTHERS THEN
331: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
333: THEN
334: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',
335: p_procedure_name => 'TRANSLATE_VALUE_ID',

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

334: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',
335: p_procedure_name => 'TRANSLATE_VALUE_ID',
336: p_error_text => SUBSTR(SQLERRM,1,240));
337: END IF;
338: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
339: p_count => x_msg_count,
340: p_data => x_msg_data);
341: END;
342:

Line 356: x_return_status:=FND_API.G_RET_STS_SUCCESS;

352: as
353: l_counter NUMBER:=0;
354: l_prim_key NUMBER:=0;
355: BEGIN
356: x_return_status:=FND_API.G_RET_STS_SUCCESS;
357:
358: IF p_vwp_deptshift_rec.DML_OPERATION='D'
359: THEN
360: IF p_vwp_deptshift_rec.OBJECT_VERSION_NUMBER IS NULL OR p_vwp_deptshift_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_NUM

Line 360: IF p_vwp_deptshift_rec.OBJECT_VERSION_NUMBER IS NULL OR p_vwp_deptshift_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_NUM

356: x_return_status:=FND_API.G_RET_STS_SUCCESS;
357:
358: IF p_vwp_deptshift_rec.DML_OPERATION='D'
359: THEN
360: IF p_vwp_deptshift_rec.OBJECT_VERSION_NUMBER IS NULL OR p_vwp_deptshift_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_NUM
361: THEN
362: FND_MESSAGE.SET_NAME('AHL','AHL_COM_OBJECT_VERS_NUM_NULL');
363: FND_MSG_PUB.ADD;
364: END IF;

Line 366: IF p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID IS NULL OR p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID=FND_API.G_MISS_NUM

362: FND_MESSAGE.SET_NAME('AHL','AHL_COM_OBJECT_VERS_NUM_NULL');
363: FND_MSG_PUB.ADD;
364: END IF;
365:
366: IF p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID IS NULL OR p_vwp_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID=FND_API.G_MISS_NUM
367: THEN
368: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');
369: FND_MSG_PUB.ADD;
370: ELSE

Line 388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

384: END IF;
385: END IF;
386:
387: EXCEPTION
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
389: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
391: p_count => x_msg_count,
392: p_data => x_msg_data);

Line 389: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

385: END IF;
386:
387: EXCEPTION
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
389: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
391: p_count => x_msg_count,
392: p_data => x_msg_data);
393:

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

386:
387: EXCEPTION
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
389: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
391: p_count => x_msg_count,
392: p_data => x_msg_data);
393:
394: WHEN FND_API.G_EXC_ERROR THEN

Line 394: WHEN FND_API.G_EXC_ERROR THEN

390: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
391: p_count => x_msg_count,
392: p_data => x_msg_data);
393:
394: WHEN FND_API.G_EXC_ERROR THEN
395: X_return_status := FND_API.G_RET_STS_ERROR;
396: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
397: p_count => x_msg_count,
398: p_data => X_msg_data);

Line 395: X_return_status := FND_API.G_RET_STS_ERROR;

391: p_count => x_msg_count,
392: p_data => x_msg_data);
393:
394: WHEN FND_API.G_EXC_ERROR THEN
395: X_return_status := FND_API.G_RET_STS_ERROR;
396: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
397: p_count => x_msg_count,
398: p_data => X_msg_data);
399:

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

392: p_data => x_msg_data);
393:
394: WHEN FND_API.G_EXC_ERROR THEN
395: X_return_status := FND_API.G_RET_STS_ERROR;
396: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
397: p_count => x_msg_count,
398: p_data => X_msg_data);
399:
400: WHEN OTHERS THEN

Line 401: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

397: p_count => x_msg_count,
398: p_data => X_msg_data);
399:
400: WHEN OTHERS THEN
401: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
402: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
403: THEN
404: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',
405: p_procedure_name => 'VALIDATE_VWP_DEPT_SHIFT',

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

404: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',
405: p_procedure_name => 'VALIDATE_VWP_DEPT_SHIFT',
406: p_error_text => SUBSTR(SQLERRM,1,240));
407: END IF;
408: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
409: p_count => x_msg_count,
410: p_data => X_msg_data);
411:
412: END;

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

416: p_api_version IN NUMBER:= 1.0,
417: p_init_msg_list IN VARCHAR2,
418: p_commit IN VARCHAR2,
419: p_validation_level IN NUMBER,
420: p_default IN VARCHAR2 := FND_API.G_FALSE,
421: p_module_type IN VARCHAR2,
422: x_return_status OUT NOCOPY VARCHAR2,
423: x_msg_count OUT NOCOPY NUMBER,
424: x_msg_data OUT NOCOPY VARCHAR2,

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

431: l_api_version CONSTANT NUMBER := 1.0;
432: l_msg_count NUMBER:=0;
433: l_msg_data VARCHAR2(2000);
434: l_return_status VARCHAR2(1);
435: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
436: l_department_shifts_id number:=0;
437: l_object_version_number NUMBER;
438: l_check_flag VARCHAR2(1):='Y';
439: BEGIN

Line 445: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

441: SAVEPOINT CREATE_VWP_DEPT_SHIFTS;
442:
443: -- Initialize message list if p_init_msg_list is set to TRUE.
444:
445: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
446: p_api_version,
447: l_api_name,G_PKG_NAME)
448: THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

445: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
446: p_api_version,
447: l_api_name,G_PKG_NAME)
448: THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451:
452: IF FND_API.to_boolean(l_init_msg_list) THEN
453: FND_MSG_PUB.initialize;

Line 452: IF FND_API.to_boolean(l_init_msg_list) THEN

448: THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451:
452: IF FND_API.to_boolean(l_init_msg_list) THEN
453: FND_MSG_PUB.initialize;
454: END IF;
455:
456: x_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 456: x_return_status:=FND_API.G_RET_STS_SUCCESS;

452: IF FND_API.to_boolean(l_init_msg_list) THEN
453: FND_MSG_PUB.initialize;
454: END IF;
455:
456: x_return_status:=FND_API.G_RET_STS_SUCCESS;
457:
458: IF G_DEBUG='Y' THEN
459: AHL_DEBUG_PUB.enable_debug;
460: END IF;

Line 490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

486: l_msg_count := FND_MSG_PUB.count_msg;
487: IF l_msg_count > 0
488: THEN
489: x_msg_count := l_msg_count;
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:
494:

Line 491: RAISE FND_API.G_EXC_ERROR;

487: IF l_msg_count > 0
488: THEN
489: x_msg_count := l_msg_count;
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:
494:
495: IF FND_API.to_boolean(p_default)

Line 495: IF FND_API.to_boolean(p_default)

491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:
494:
495: IF FND_API.to_boolean(p_default)
496: THEN
497: DEFAULT_MISSING_ATTRIBS
498: (
499: p_x_vwp_deptshift_rec =>l_vwp_deptshift_rec

Line 503: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )

499: p_x_vwp_deptshift_rec =>l_vwp_deptshift_rec
500: );
501: END IF;
502:
503: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )
504: THEN
505:
506: VALIDATE_VWP_DEPT_SHIFT
507: (

Line 522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

518:
519: IF l_msg_count > 0
520: THEN
521: x_msg_count := l_msg_count;
522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
523: RAISE FND_API.G_EXC_ERROR;
524: END IF;
525:
526: -- insert process goes here

Line 523: RAISE FND_API.G_EXC_ERROR;

519: IF l_msg_count > 0
520: THEN
521: x_msg_count := l_msg_count;
522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
523: RAISE FND_API.G_EXC_ERROR;
524: END IF;
525:
526: -- insert process goes here
527: IF G_DEBUG='Y' THEN

Line 605: IF FND_API.TO_BOOLEAN(p_commit) THEN

601: l_vwp_deptshift_rec.ATTRIBUTE14,
602: l_vwp_deptshift_rec.ATTRIBUTE15);
603: END IF;
604:
605: IF FND_API.TO_BOOLEAN(p_commit) THEN
606: COMMIT;
607: END IF;
608: IF G_DEBUG='Y' THEN
609: AHL_DEBUG_PUB.disable_debug;

Line 613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

609: AHL_DEBUG_PUB.disable_debug;
610: END IF;
611:
612: EXCEPTION
613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
614: ROLLBACK TO CREATE_VWP_DEPT_SHIFTS;
615: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
616: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
617: p_count => x_msg_count,

Line 615: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

611:
612: EXCEPTION
613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
614: ROLLBACK TO CREATE_VWP_DEPT_SHIFTS;
615: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
616: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
617: p_count => x_msg_count,
618: p_data => x_msg_data);
619: WHEN FND_API.G_EXC_ERROR THEN

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

612: EXCEPTION
613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
614: ROLLBACK TO CREATE_VWP_DEPT_SHIFTS;
615: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
616: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
617: p_count => x_msg_count,
618: p_data => x_msg_data);
619: WHEN FND_API.G_EXC_ERROR THEN
620: ROLLBACK TO CREATE_VWP_DEPT_SHIFTS;

Line 619: WHEN FND_API.G_EXC_ERROR THEN

615: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
616: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
617: p_count => x_msg_count,
618: p_data => x_msg_data);
619: WHEN FND_API.G_EXC_ERROR THEN
620: ROLLBACK TO CREATE_VWP_DEPT_SHIFTS;
621: X_return_status := FND_API.G_RET_STS_ERROR;
622: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
623: p_count => x_msg_count,

Line 621: X_return_status := FND_API.G_RET_STS_ERROR;

617: p_count => x_msg_count,
618: p_data => x_msg_data);
619: WHEN FND_API.G_EXC_ERROR THEN
620: ROLLBACK TO CREATE_VWP_DEPT_SHIFTS;
621: X_return_status := FND_API.G_RET_STS_ERROR;
622: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
623: p_count => x_msg_count,
624: p_data => X_msg_data);
625: WHEN OTHERS THEN

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

618: p_data => x_msg_data);
619: WHEN FND_API.G_EXC_ERROR THEN
620: ROLLBACK TO CREATE_VWP_DEPT_SHIFTS;
621: X_return_status := FND_API.G_RET_STS_ERROR;
622: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
623: p_count => x_msg_count,
624: p_data => X_msg_data);
625: WHEN OTHERS THEN
626: ROLLBACK TO CREATE_VWP_DEPT_SHIFTS;

Line 627: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

623: p_count => x_msg_count,
624: p_data => X_msg_data);
625: WHEN OTHERS THEN
626: ROLLBACK TO CREATE_VWP_DEPT_SHIFTS;
627: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
629: THEN
630: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',
631: p_procedure_name => 'CREATE_VWP_DEPT_SHIFTS',

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

631: p_procedure_name => 'CREATE_VWP_DEPT_SHIFTS',
632: p_error_text => SUBSTR(SQLERRM,1,240));
633:
634: END IF;
635: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
636: p_count => x_msg_count,
637: p_data => X_msg_data);
638: END;
639:

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

642: p_api_version IN NUMBER:= 1.0,
643: p_init_msg_list IN VARCHAR2,
644: p_commit IN VARCHAR2,
645: p_validation_level IN NUMBER,
646: p_default IN VARCHAR2 := FND_API.G_FALSE,
647: p_module_type IN VARCHAR2,
648: x_return_status OUT NOCOPY VARCHAR2,
649: x_msg_count OUT NOCOPY NUMBER,
650: x_msg_data OUT NOCOPY VARCHAR2,

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

658: l_num_rec NUMBER;
659: l_msg_count NUMBER;
660: l_msg_data VARCHAR2(2000);
661: l_return_status VARCHAR2(1);
662: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
663: l_department_shifts_id number:=0;
664: l_lookup_var varchar2(1);
665: l_object_version_number NUMBER;
666: l_check_flag VARCHAR2(1):='Y';

Line 674: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

670: SAVEPOINT DELETE_DEPT_SHIFTS;
671:
672: -- Initialize message list if p_init_msg_list is set to TRUE.
673:
674: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
675: p_api_version,
676: l_api_name,G_PKG_NAME)
677: THEN
678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

674: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
675: p_api_version,
676: l_api_name,G_PKG_NAME)
677: THEN
678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
679: END IF;
680:
681:
682: IF FND_API.to_boolean(l_init_msg_list) THEN

Line 682: IF FND_API.to_boolean(l_init_msg_list) THEN

678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
679: END IF;
680:
681:
682: IF FND_API.to_boolean(l_init_msg_list) THEN
683: FND_MSG_PUB.initialize;
684: END IF;
685:
686:

Line 687: x_return_status:=FND_API.G_RET_STS_SUCCESS;

683: FND_MSG_PUB.initialize;
684: END IF;
685:
686:
687: x_return_status:=FND_API.G_RET_STS_SUCCESS;
688:
689: IF G_DEBUG='Y' THEN
690: AHL_DEBUG_PUB.enable_debug;
691: END IF;

Line 709: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )

705: END IF;
706:
707:
708:
709: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )
710: THEN
711: VALIDATE_VWP_DEPT_SHIFT
712: (
713: x_return_status =>x_return_Status,

Line 724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

720:
721: IF l_msg_count > 0
722: THEN
723: x_msg_count := l_msg_count;
724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
725: RAISE FND_API.G_EXC_ERROR;
726: END IF;
727:
728: -- DELETE GOES HERE

Line 725: RAISE FND_API.G_EXC_ERROR;

721: IF l_msg_count > 0
722: THEN
723: x_msg_count := l_msg_count;
724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
725: RAISE FND_API.G_EXC_ERROR;
726: END IF;
727:
728: -- DELETE GOES HERE
729:

Line 742: IF FND_API.TO_BOOLEAN(p_commit) THEN

738: FND_MSG_PUB.ADD;
739: END IF;
740: END IF;
741:
742: IF FND_API.TO_BOOLEAN(p_commit) THEN
743: COMMIT;
744: END IF;
745: IF G_DEBUG='Y' THEN
746: AHL_DEBUG_PUB.disable_debug;

Line 750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

746: AHL_DEBUG_PUB.disable_debug;
747: END IF;
748:
749: EXCEPTION
750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
751: ROLLBACK TO DELETE_DEPT_SHIFTS;
752: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
753: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
754: p_count => x_msg_count,

Line 752: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

748:
749: EXCEPTION
750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
751: ROLLBACK TO DELETE_DEPT_SHIFTS;
752: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
753: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
754: p_count => x_msg_count,
755: p_data => x_msg_data);
756: WHEN FND_API.G_EXC_ERROR THEN

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

749: EXCEPTION
750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
751: ROLLBACK TO DELETE_DEPT_SHIFTS;
752: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
753: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
754: p_count => x_msg_count,
755: p_data => x_msg_data);
756: WHEN FND_API.G_EXC_ERROR THEN
757: ROLLBACK TO DELETE_DEPT_SHIFTS;

Line 756: WHEN FND_API.G_EXC_ERROR THEN

752: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
753: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
754: p_count => x_msg_count,
755: p_data => x_msg_data);
756: WHEN FND_API.G_EXC_ERROR THEN
757: ROLLBACK TO DELETE_DEPT_SHIFTS;
758: X_return_status := FND_API.G_RET_STS_ERROR;
759: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
760: p_count => x_msg_count,

Line 758: X_return_status := FND_API.G_RET_STS_ERROR;

754: p_count => x_msg_count,
755: p_data => x_msg_data);
756: WHEN FND_API.G_EXC_ERROR THEN
757: ROLLBACK TO DELETE_DEPT_SHIFTS;
758: X_return_status := FND_API.G_RET_STS_ERROR;
759: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
760: p_count => x_msg_count,
761: p_data => X_msg_data);
762:

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

755: p_data => x_msg_data);
756: WHEN FND_API.G_EXC_ERROR THEN
757: ROLLBACK TO DELETE_DEPT_SHIFTS;
758: X_return_status := FND_API.G_RET_STS_ERROR;
759: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
760: p_count => x_msg_count,
761: p_data => X_msg_data);
762:
763: WHEN OTHERS THEN

Line 765: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

761: p_data => X_msg_data);
762:
763: WHEN OTHERS THEN
764: ROLLBACK TO DELETE_DEPT_SHIFTS;
765: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
766: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
767: THEN
768: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_VWP_DEPT_SHIFTS_PUB',
769: p_procedure_name => 'CREATE_VWP_DEPT_SHIFTS',

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

769: p_procedure_name => 'CREATE_VWP_DEPT_SHIFTS',
770: p_error_text => SUBSTR(SQLERRM,1,240));
771:
772: END IF;
773: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
774: p_count => x_msg_count,
775: p_data => X_msg_data);
776: END;
777: