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_APPR_DEPT_SHIFTS_PUB dependencies on FND_MSG_PUB

Line 224: FND_MSG_PUB.ADD;

220: x_return_status:=FND_API.G_RET_STS_SUCCESS;
221: IF p_x_appr_deptshift_rec.ORGANIZATION_NAME IS NULL OR p_x_appr_deptshift_rec.ORGANIZATION_NAME=FND_API.G_MISS_CHAR
222: THEN
223: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_ORG_NAME_NULL');
224: FND_MSG_PUB.ADD;
225: l_check_flag:='N';
226: ELSE
227: l_check_flag:='Y';
228: OPEN get_org_id(p_x_appr_deptshift_rec.ORGANIZATION_NAME);

Line 233: FND_MSG_PUB.ADD;

229: FETCH get_org_id INTO p_x_appr_deptshift_rec.ORGANIZATION_ID;
230: IF get_org_id%NOTFOUND
231: THEN
232: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_ORG_NAME_INVALID');
233: FND_MSG_PUB.ADD;
234: l_check_flag:='N';
235: END IF;
236: CLOSE get_org_id;
237: END IF;

Line 243: FND_MSG_PUB.ADD;

239: l_check_flag:='N';
240: IF p_x_appr_deptshift_rec.DEPT_DESCRIPTION IS NULL OR p_x_appr_deptshift_rec.DEPT_DESCRIPTION=FND_API.G_MISS_CHAR
241: THEN
242: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_DEPT_NAME_NULL');
243: FND_MSG_PUB.ADD;
244: l_check_flag:='N';
245: ELSE
246: l_check_flag:='Y';
247: END IF;

Line 256: FND_MSG_PUB.ADD;

252: FETCH get_org_dept_id INTO p_x_appr_deptshift_rec.DEPARTMENT_ID;
253: IF get_org_dept_id%NOTFOUND
254: THEN
255: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_DEPT_NAME_INVALID');
256: FND_MSG_PUB.ADD;
257: l_check_flag:='N';
258: END IF;
259: CLOSE get_org_dept_id;
260: END IF;

Line 267: FND_MSG_PUB.ADD;

263: l_check_flag:='N';
264: IF p_x_appr_deptshift_rec.CALENDAR_DESCRIPTION IS NULL OR p_x_appr_deptshift_rec.CALENDAR_DESCRIPTION=FND_API.G_MISS_CHAR
265: THEN
266: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_CALENDER_NAME_NULL');
267: FND_MSG_PUB.ADD;
268: l_check_flag:='N';
269: ELSE
270: l_check_flag:='Y';
271: END IF;

Line 281: FND_MSG_PUB.ADD;

277: FETCH get_bom_calendar INTO p_x_appr_deptshift_rec.CALENDAR_CODE;
278: IF get_bom_calendar%NOTFOUND
279: THEN
280: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_CALENDER_INVALID');
281: FND_MSG_PUB.ADD;
282: l_check_flag:='N';
283: ELSE
284: l_check_flag:='Y';
285: END IF;

Line 294: FND_MSG_PUB.ADD;

290: l_check_flag:='N';
291: IF p_x_appr_deptshift_rec.SHIFT_NUM IS NULL OR p_x_appr_deptshift_rec.SHIFT_NUM=FND_API.G_MISS_NUM
292: THEN
293: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_SHIFT_NUMBER_NULL');
294: FND_MSG_PUB.ADD;
295: l_check_flag:='N';
296: ELSE
297: l_check_flag:='Y';
298: END IF;

Line 307: FND_MSG_PUB.ADD;

303: FETCH get_bom_shift_num INTO p_x_appr_deptshift_rec.SHIFT_NUM;
304: IF get_bom_shift_num%NOTFOUND
305: THEN
306: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_SHIFT_NUMBER_INVALID');
307: FND_MSG_PUB.ADD;
308: l_check_flag:='N';
309: ELSE
310: l_check_flag:='Y';
311: END IF;

Line 320: FND_MSG_PUB.ADD;

316: l_check_flag:='N';
317: IF p_x_appr_deptshift_rec.SEQ_NAME IS NULL OR p_x_appr_deptshift_rec.SEQ_NAME=FND_API.G_MISS_CHAR
318: THEN
319: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_WORK_DAYS_NULL');
320: FND_MSG_PUB.ADD;
321: l_check_flag:='N';
322: ELSE
323: l_check_flag:='Y';
324: END IF;

Line 332: FND_MSG_PUB.ADD;

328: FETCH get_bom_workdays INTO p_x_appr_deptshift_rec.SEQ_NUM;
329: IF get_bom_workdays%NOTFOUND
330: THEN
331: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_SEQ_DESCRIP_INVALID');
332: FND_MSG_PUB.ADD;
333: -- Added by rbhavsar on Nov 27, 2007 for ER 5854712
334: l_check_flag:='N';
335: END IF;
336: CLOSE get_bom_workdays;

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

378:
379: EXCEPTION
380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
381: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
383: p_count => x_msg_count,
384: p_data => x_msg_data);
385:
386: WHEN FND_API.G_EXC_ERROR THEN

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

384: p_data => x_msg_data);
385:
386: WHEN FND_API.G_EXC_ERROR THEN
387: X_return_status := FND_API.G_RET_STS_ERROR;
388: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
389: p_count => x_msg_count,
390: p_data => X_msg_data);
391: WHEN OTHERS THEN
392: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 393: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

389: p_count => x_msg_count,
390: p_data => X_msg_data);
391: WHEN OTHERS THEN
392: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
394: THEN
395: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
396: p_procedure_name => 'TRANSLATE_VALUE_ID',
397: p_error_text => SUBSTR(SQLERRM,1,240));

Line 395: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',

391: WHEN OTHERS THEN
392: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
394: THEN
395: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
396: p_procedure_name => 'TRANSLATE_VALUE_ID',
397: p_error_text => SUBSTR(SQLERRM,1,240));
398: END IF;
399: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

395: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
396: p_procedure_name => 'TRANSLATE_VALUE_ID',
397: p_error_text => SUBSTR(SQLERRM,1,240));
398: END IF;
399: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
400: p_count => x_msg_count,
401: p_data => x_msg_data);
402: END;
403:

Line 461: FND_MSG_PUB.ADD;

457: THEN
458: IF p_appr_deptshift_rec.OBJECT_VERSION_NUMBER IS NULL OR p_appr_deptshift_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_NUM
459: THEN
460: FND_MESSAGE.SET_NAME('AHL','AHL_COM_OBJECT_VERS_NUM_NULL');
461: FND_MSG_PUB.ADD;
462: END IF;
463:
464: IF p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID IS NULL OR p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID=FND_API.G_MISS_NUM
465: THEN

Line 467: FND_MSG_PUB.ADD;

463:
464: IF p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID IS NULL OR p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID=FND_API.G_MISS_NUM
465: THEN
466: FND_MESSAGE.SET_NAME('AHL','AHL_DEPARTMENT_SHIFTS_ID_NULL');
467: FND_MSG_PUB.ADD;
468: ELSE
469: SELECT AHL_DEPARTMENT_SHIFTS_ID INTO l_prim_key
470: FROM AHL_DEPARTMENT_SHIFTS
471: WHERE AHL_DEPARTMENT_SHIFTS_ID=p_appr_deptshift_rec.AHL_DEPARTMENT_SHIFTS_ID;

Line 482: FND_MSG_PUB.ADD;

478:
479: IF l_counter>0
480: THEN
481: FND_MESSAGE.SET_NAME('AHL','AHL_APPR_DEPT_EXISTS');
482: FND_MSG_PUB.ADD;
483: END IF;
484: END IF;
485:
486: -- Added by rbhavsar on Nov 27, 2007 for ER 5854712

Line 502: FND_MSG_PUB.ADD;

498: IF (validate_subinventory%NOTFOUND) THEN
499: CLOSE validate_subinventory;
500: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_SUBINVENTORY');
501: FND_MESSAGE.Set_Token('INV', p_appr_deptshift_rec.SUBINVENTORY);
502: FND_MSG_PUB.ADD;
503: RAISE FND_API.G_EXC_ERROR;
504: ELSE
505: IF l_status_id in (NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1), NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1)) THEN
506: CLOSE validate_subinventory;

Line 509: FND_MSG_PUB.ADD;

505: IF l_status_id in (NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1), NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1)) THEN
506: CLOSE validate_subinventory;
507: FND_MESSAGE.SET_NAME('AHL', 'AHL_SUBINVENTORY_NOT_SVC');
508: FND_MESSAGE.Set_Token('INV', p_appr_deptshift_rec.SUBINVENTORY);
509: FND_MSG_PUB.ADD;
510: RAISE FND_API.G_EXC_ERROR;
511: END IF;
512: END IF;
513: CLOSE validate_subinventory;

Line 519: FND_MSG_PUB.ADD;

515:
516: IF (p_appr_deptshift_rec.SUBINVENTORY IS NULL AND
517: (p_appr_deptshift_rec.INV_LOCATOR_ID IS NOT NULL OR p_appr_deptshift_rec.LOCATOR_SEGMENTS IS NOT NULL)) THEN
518: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_PC_SUBINV_MANDATORY');
519: FND_MSG_PUB.ADD;
520: RAISE FND_API.G_EXC_ERROR;
521: END IF;
522:
523: IF (p_appr_deptshift_rec.INV_LOCATOR_ID IS NOT NULL) THEN

Line 532: FND_MSG_PUB.ADD;

528: IF (validate_inv_loc_id%NOTFOUND) THEN
529: CLOSE validate_inv_loc_id;
530: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_LOCATOR');
531: FND_MESSAGE.Set_Token('LOC', p_appr_deptshift_rec.INV_LOCATOR_ID);
532: FND_MSG_PUB.ADD;
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;
535: CLOSE validate_inv_loc_id;
536: END IF;

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

543:
544: EXCEPTION
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
548: p_count => x_msg_count,
549: p_data => x_msg_data);
550:
551: WHEN FND_API.G_EXC_ERROR THEN

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

549: p_data => x_msg_data);
550:
551: WHEN FND_API.G_EXC_ERROR THEN
552: X_return_status := FND_API.G_RET_STS_ERROR;
553: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
554: p_count => x_msg_count,
555: p_data => X_msg_data);
556:
557: WHEN OTHERS THEN

Line 559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

555: p_data => X_msg_data);
556:
557: WHEN OTHERS THEN
558: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
560: THEN
561: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
562: p_procedure_name => 'VALIDATE_APPR_DEPT_SHIFT',
563: p_error_text => SUBSTR(SQLERRM,1,240));

Line 561: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',

557: WHEN OTHERS THEN
558: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
560: THEN
561: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
562: p_procedure_name => 'VALIDATE_APPR_DEPT_SHIFT',
563: p_error_text => SUBSTR(SQLERRM,1,240));
564: END IF;
565: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

561: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
562: p_procedure_name => 'VALIDATE_APPR_DEPT_SHIFT',
563: p_error_text => SUBSTR(SQLERRM,1,240));
564: END IF;
565: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
566: p_count => x_msg_count,
567: p_data => X_msg_data);
568:
569: END;

Line 615: FND_MSG_PUB.initialize;

611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: END IF;
613:
614: IF FND_API.to_boolean(l_init_msg_list) THEN
615: FND_MSG_PUB.initialize;
616: END IF;
617:
618: x_return_status:=FND_API.G_RET_STS_SUCCESS;
619:

Line 645: l_msg_count := FND_MSG_PUB.count_msg;

641: );
642: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
643: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from TRANSLATE_VALUE_ID. x_return_status = ' || x_return_status);
644: END IF;
645: l_msg_count := FND_MSG_PUB.count_msg;
646: IF l_msg_count > 0
647: THEN
648: x_msg_count := l_msg_count;
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 676: l_msg_count := FND_MSG_PUB.count_msg;

672: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
673: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from VALIDATE_APPR_DEPT_SHIFT. x_return_status = ' || x_return_status);
674: END IF;
675:
676: l_msg_count := FND_MSG_PUB.count_msg;
677:
678: IF l_msg_count > 0
679: THEN
680: x_msg_count := l_msg_count;

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

797: EXCEPTION
798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
799: ROLLBACK TO CREATE_APPR_DEPT_SHIFTS;
800: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
801: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
802: p_count => x_msg_count,
803: p_data => x_msg_data);
804: WHEN FND_API.G_EXC_ERROR THEN
805: ROLLBACK TO CREATE_APPR_DEPT_SHIFTS;

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

803: p_data => x_msg_data);
804: WHEN FND_API.G_EXC_ERROR THEN
805: ROLLBACK TO CREATE_APPR_DEPT_SHIFTS;
806: X_return_status := FND_API.G_RET_STS_ERROR;
807: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
808: p_count => x_msg_count,
809: p_data => X_msg_data);
810: WHEN OTHERS THEN
811: ROLLBACK TO CREATE_APPR_DEPT_SHIFTS;

Line 813: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

809: p_data => X_msg_data);
810: WHEN OTHERS THEN
811: ROLLBACK TO CREATE_APPR_DEPT_SHIFTS;
812: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
813: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
814: THEN
815: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
816: p_procedure_name => 'CREATE_APPR_DEPT_SHIFTS',
817: p_error_text => SUBSTR(SQLERRM,1,240));

Line 815: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',

811: ROLLBACK TO CREATE_APPR_DEPT_SHIFTS;
812: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
813: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
814: THEN
815: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
816: p_procedure_name => 'CREATE_APPR_DEPT_SHIFTS',
817: p_error_text => SUBSTR(SQLERRM,1,240));
818:
819: END IF;

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

816: p_procedure_name => 'CREATE_APPR_DEPT_SHIFTS',
817: p_error_text => SUBSTR(SQLERRM,1,240));
818:
819: END IF;
820: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
821: p_count => x_msg_count,
822: p_data => X_msg_data);
823: END;
824:

Line 873: FND_MSG_PUB.initialize;

869: END IF;
870:
871:
872: IF FND_API.to_boolean(l_init_msg_list) THEN
873: FND_MSG_PUB.initialize;
874: END IF;
875:
876:
877: x_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 902: l_msg_count := FND_MSG_PUB.count_msg;

898: x_msg_data =>l_msg_data,
899: p_appr_deptshift_rec =>l_appr_deptshift_rec);
900: END IF;
901:
902: l_msg_count := FND_MSG_PUB.count_msg;
903:
904: IF l_msg_count > 0
905: THEN
906: x_msg_count := l_msg_count;

Line 921: FND_MSG_PUB.ADD;

917: AND OBJECT_VERSION_NUMBER=l_appr_deptshift_rec.OBJECT_VERSION_NUMBER;
918: IF (sql%ROWCOUNT=0)
919: THEN
920: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
921: FND_MSG_PUB.ADD;
922: END IF;
923: END IF;
924:
925: IF FND_API.TO_BOOLEAN(p_commit) THEN

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

932: EXCEPTION
933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
934: ROLLBACK TO DELETE_DEPT_SHIFTS;
935: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
936: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
937: p_count => x_msg_count,
938: p_data => x_msg_data);
939: WHEN FND_API.G_EXC_ERROR THEN
940: ROLLBACK TO DELETE_DEPT_SHIFTS;

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

938: p_data => x_msg_data);
939: WHEN FND_API.G_EXC_ERROR THEN
940: ROLLBACK TO DELETE_DEPT_SHIFTS;
941: X_return_status := FND_API.G_RET_STS_ERROR;
942: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
943: p_count => x_msg_count,
944: p_data => X_msg_data);
945:
946: WHEN OTHERS THEN

Line 949: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

945:
946: WHEN OTHERS THEN
947: ROLLBACK TO DELETE_DEPT_SHIFTS;
948: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
949: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
950: THEN
951: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
952: p_procedure_name => 'CREATE_APPR_DEPT_SHIFTS',
953: p_error_text => SUBSTR(SQLERRM,1,240));

Line 951: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',

947: ROLLBACK TO DELETE_DEPT_SHIFTS;
948: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
949: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
950: THEN
951: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
952: p_procedure_name => 'CREATE_APPR_DEPT_SHIFTS',
953: p_error_text => SUBSTR(SQLERRM,1,240));
954:
955: END IF;

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

952: p_procedure_name => 'CREATE_APPR_DEPT_SHIFTS',
953: p_error_text => SUBSTR(SQLERRM,1,240));
954:
955: END IF;
956: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
957: p_count => x_msg_count,
958: p_data => X_msg_data);
959: END;
960:

Line 1006: FND_MSG_PUB.initialize;

1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1003: END IF;
1004:
1005: IF FND_API.to_boolean(l_init_msg_list) THEN
1006: FND_MSG_PUB.initialize;
1007: END IF;
1008:
1009: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1010:

Line 1036: l_msg_count := FND_MSG_PUB.count_msg;

1032: );
1033: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1034: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from TRANSLATE_VALUE_ID. x_return_status = ' || x_return_status);
1035: END IF;
1036: l_msg_count := FND_MSG_PUB.count_msg;
1037: IF l_msg_count > 0
1038: THEN
1039: x_msg_count := l_msg_count;
1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1067: l_msg_count := FND_MSG_PUB.count_msg;

1063: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1064: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Returned from VALIDATE_APPR_DEPT_SHIFT. x_return_status = ' || x_return_status);
1065: END IF;
1066:
1067: l_msg_count := FND_MSG_PUB.count_msg;
1068:
1069: IF l_msg_count > 0
1070: THEN
1071: x_msg_count := l_msg_count;

Line 1133: FND_MSG_PUB.add;

1129: -- If the record does not exist, then, abort API.
1130: IF ( SQL%ROWCOUNT = 0 ) THEN
1131: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
1132: --FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_appr_deptshift_rec ) );
1133: FND_MSG_PUB.add;
1134: END IF;
1135:
1136: IF FND_API.TO_BOOLEAN(p_commit) THEN
1137: COMMIT;

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

1143: EXCEPTION
1144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1145: ROLLBACK TO EDIT_APPR_DEPT_SHIFTS;
1146: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1147: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1148: p_count => x_msg_count,
1149: p_data => x_msg_data);
1150: WHEN FND_API.G_EXC_ERROR THEN
1151: ROLLBACK TO EDIT_APPR_DEPT_SHIFTS;

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

1149: p_data => x_msg_data);
1150: WHEN FND_API.G_EXC_ERROR THEN
1151: ROLLBACK TO EDIT_APPR_DEPT_SHIFTS;
1152: X_return_status := FND_API.G_RET_STS_ERROR;
1153: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1154: p_count => x_msg_count,
1155: p_data => X_msg_data);
1156: WHEN OTHERS THEN
1157: ROLLBACK TO EDIT_APPR_DEPT_SHIFTS;

Line 1159: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1155: p_data => X_msg_data);
1156: WHEN OTHERS THEN
1157: ROLLBACK TO EDIT_APPR_DEPT_SHIFTS;
1158: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1159: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1160: THEN
1161: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
1162: p_procedure_name => 'CREATE_APPR_DEPT_SHIFTS',
1163: p_error_text => SUBSTR(SQLERRM,1,240));

Line 1161: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',

1157: ROLLBACK TO EDIT_APPR_DEPT_SHIFTS;
1158: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1159: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1160: THEN
1161: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
1162: p_procedure_name => 'CREATE_APPR_DEPT_SHIFTS',
1163: p_error_text => SUBSTR(SQLERRM,1,240));
1164:
1165: END IF;

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

1162: p_procedure_name => 'CREATE_APPR_DEPT_SHIFTS',
1163: p_error_text => SUBSTR(SQLERRM,1,240));
1164:
1165: END IF;
1166: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1167: p_count => x_msg_count,
1168: p_data => X_msg_data);
1169: END;
1170: