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 AHL_DEBUG_PUB

Line 174: AHL_DEBUG_PUB.enable_debug;

170: l_check_flag VARCHAR2(1):='N';
171: l_counter NUMBER:=0;
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

Line 177: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside translate1 -- l_check_flag' || l_check_flag);

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);
181: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_ORG_NAME_NULL');

Line 180: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside organization-- l_check_flag' || l_check_flag);

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;
183: l_check_flag:='N';
184: ELSE

Line 186: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside org cursor -- l_check_flag' || l_check_flag);

182: FND_MSG_PUB.ADD;
183: l_check_flag:='N';
184: ELSE
185: l_check_flag:='Y';
186: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside org cursor -- l_check_flag' || l_check_flag);
187: OPEN get_org_id(p_x_vwp_deptshift_rec.ORGANIZATION_NAME);
188: FETCH get_org_id INTO p_x_vwp_deptshift_rec.ORGANIZATION_ID;
189: IF get_org_id%NOTFOUND
190: THEN

Line 198: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside translate3 -- l_check_flag' || l_check_flag);

194: END IF;
195: CLOSE get_org_id;
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);

Line 202: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside department-- l_check_flag' || l_check_flag);

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;
205: l_check_flag:='N';
206: ELSE

Line 223: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside translate2 -- l_check_flag' || l_check_flag);

219: END IF;
220: CLOSE get_org_dept_id;
221: END IF;
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

Line 228: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside calender-- 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;
231: l_check_flag:='N';
232: ELSE

Line 252: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside translate2 -- l_check_flag' || l_check_flag);

248: END IF;
249: CLOSE get_bom_calendar;
250: END IF;
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

Line 257: --AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside shift number-- 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;
260: l_check_flag:='N';
261: ELSE

Line 281: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside translate2 -- l_check_flag' || l_check_flag);

277: CLOSE get_bom_shift_num;
278: END IF;
279:
280: IF G_DEBUG='Y' THEN
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

Line 288: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside sequence number-- l_check_flag' || l_check_flag);

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;
290: --
291: FND_MESSAGE.SET_NAME('AHL','AHL_VWP_WORK_DAYS_NULL');
292: FND_MSG_PUB.ADD;

Line 298: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside translate2 -- l_check_flag' || l_check_flag);

294: ELSE
295: l_check_flag:='Y';
296: END IF;
297: IF G_DEBUG='Y' THEN
298: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside translate2 -- l_check_flag' || l_check_flag);
299: END IF;
300: IF l_check_flag='Y'
301: THEN
302: IF G_DEBUG='Y' THEN

Line 303: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside sequence number ***** -- l_check_flag' || l_check_flag);

299: END IF;
300: IF l_check_flag='Y'
301: THEN
302: IF G_DEBUG='Y' THEN
303: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- inside sequence number ***** -- l_check_flag' || l_check_flag);
304: END IF;
305: OPEN get_bom_workdays(p_x_vwp_deptshift_rec.CALENDAR_CODE,p_x_vwp_deptshift_rec.SHIFT_NUM,p_x_vwp_deptshift_rec.SEQ_NAME);
306: FETCH get_bom_workdays INTO p_x_vwp_deptshift_rec.SEQ_NUM;
307: IF get_bom_workdays%NOTFOUND

Line 315: AHL_DEBUG_PUB.disable_debug;

311: END IF;
312: CLOSE get_bom_workdays;
313: END IF;
314: IF G_DEBUG='Y' THEN
315: AHL_DEBUG_PUB.disable_debug;
316: END IF;
317:
318: EXCEPTION
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 459: AHL_DEBUG_PUB.enable_debug;

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;
461:
462: IF p_module_type = 'JSP'
463: THEN

Line 472: AHL_DEBUG_PUB.debug( 'AHL_VWP_DEPT_SHIFTS_PUB.','+CREATE_VWP_DEPT_SHIFTS+');

468:
469: -- Debug info.
470:
471: IF G_DEBUG='Y' THEN
472: AHL_DEBUG_PUB.debug( 'AHL_VWP_DEPT_SHIFTS_PUB.','+CREATE_VWP_DEPT_SHIFTS+');
473: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- before translate shift_num ' || l_vwp_deptshift_rec.SHIFT_NUM);
474: END IF;
475:
476: TRANSLATE_VALUE_ID

Line 473: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- before translate shift_num ' || l_vwp_deptshift_rec.SHIFT_NUM);

469: -- Debug info.
470:
471: IF G_DEBUG='Y' THEN
472: AHL_DEBUG_PUB.debug( 'AHL_VWP_DEPT_SHIFTS_PUB.','+CREATE_VWP_DEPT_SHIFTS+');
473: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- before translate shift_num ' || l_vwp_deptshift_rec.SHIFT_NUM);
474: END IF;
475:
476: TRANSLATE_VALUE_ID
477: (

Line 484: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- after transalate shift_num' || l_vwp_deptshift_rec.SHIFT_NUM);

480: x_msg_data =>l_msg_data,
481: p_x_vwp_deptshift_rec =>l_vwp_deptshift_rec
482: );
483: IF G_DEBUG='Y' THEN
484: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- after transalate shift_num' || l_vwp_deptshift_rec.SHIFT_NUM);
485: END IF;
486: l_msg_count := FND_MSG_PUB.count_msg;
487: IF l_msg_count > 0
488: THEN

Line 514: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- after validation shift_num' || l_vwp_deptshift_rec.SHIFT_NUM);

510: x_msg_data =>l_msg_data,
511: p_vwp_deptshift_rec =>l_vwp_deptshift_rec);
512: END IF;
513: IF G_DEBUG='Y' THEN
514: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- after validation shift_num' || l_vwp_deptshift_rec.SHIFT_NUM);
515: END IF;
516:
517: l_msg_count := FND_MSG_PUB.count_msg;
518:

Line 528: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- before insert shift_num' || l_vwp_deptshift_rec.SHIFT_NUM);

524: END IF;
525:
526: -- insert process goes here
527: IF G_DEBUG='Y' THEN
528: AHL_DEBUG_PUB.debug('AHL_VWP_DEPT_SHIFTS_PUB -- before insert shift_num' || l_vwp_deptshift_rec.SHIFT_NUM);
529: END IF;
530: IF l_vwp_deptshift_rec.DML_OPERATION='C'
531: THEN
532: Select AHL_DEPARTMENT_SHIFTS_S.nextval into

Line 609: AHL_DEBUG_PUB.disable_debug;

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;
610: END IF;
611:
612: EXCEPTION
613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 690: AHL_DEBUG_PUB.enable_debug;

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;
692:
693: IF p_module_type = 'JSP'
694: THEN

Line 704: AHL_DEBUG_PUB.debug( 'AHL_VWP_DEPT_SHITS_PUB.','+delete_VWP_DEPT_SHIFTS+');

700:
701: -- Debug info.
702:
703: IF G_DEBUG='Y' THEN
704: AHL_DEBUG_PUB.debug( 'AHL_VWP_DEPT_SHITS_PUB.','+delete_VWP_DEPT_SHIFTS+');
705: END IF;
706:
707:
708:

Line 746: AHL_DEBUG_PUB.disable_debug;

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;
747: END IF;
748:
749: EXCEPTION
750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN