APPS.AHL_APPR_DEPT_SHIFTS_PUB dependencies on AHL_APPR_DEPT_SHIFTS_PUB

Line 1: PACKAGE BODY AHL_APPR_DEPT_SHIFTS_PUB AS

1: PACKAGE BODY AHL_APPR_DEPT_SHIFTS_PUB AS
2: /* $Header: AHLPDSHB.pls 120.1 2007/12/05 20:40:00 rbhavsar ship $ */
3: --
4: G_PKG_NAME VARCHAR2(30):='AHL_APPR_DEPT_SHIFTS_PUB';
5:

Line 4: G_PKG_NAME VARCHAR2(30):='AHL_APPR_DEPT_SHIFTS_PUB';

1: PACKAGE BODY AHL_APPR_DEPT_SHIFTS_PUB AS
2: /* $Header: AHLPDSHB.pls 120.1 2007/12/05 20:40:00 rbhavsar ship $ */
3: --
4: G_PKG_NAME VARCHAR2(30):='AHL_APPR_DEPT_SHIFTS_PUB';
5:
6: -- Added by rbhavsar on Nov 27, 2007 for ER 5854712
7: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_APPR_DEPT_SHIFTS_PUB';
8: --

Line 7: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_APPR_DEPT_SHIFTS_PUB';

3: --
4: G_PKG_NAME VARCHAR2(30):='AHL_APPR_DEPT_SHIFTS_PUB';
5:
6: -- Added by rbhavsar on Nov 27, 2007 for ER 5854712
7: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_APPR_DEPT_SHIFTS_PUB';
8: --
9: PROCEDURE DEFAULT_MISSING_ATTRIBS
10: (
11: p_x_appr_deptshift_rec IN OUT NOCOPY AHL_APPR_DEPT_SHIFTS_PUB.appr_deptshift_rec

Line 11: p_x_appr_deptshift_rec IN OUT NOCOPY AHL_APPR_DEPT_SHIFTS_PUB.appr_deptshift_rec

7: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_APPR_DEPT_SHIFTS_PUB';
8: --
9: PROCEDURE DEFAULT_MISSING_ATTRIBS
10: (
11: p_x_appr_deptshift_rec IN OUT NOCOPY AHL_APPR_DEPT_SHIFTS_PUB.appr_deptshift_rec
12: )
13: AS
14: BEGIN
15: IF p_x_appr_deptshift_rec.OBJECT_VERSION_NUMBER=FND_API.G_MISS_NUM

Line 144: p_x_appr_deptshift_rec IN OUT NOCOPY AHL_APPR_DEPT_SHIFTS_PUB.APPR_DEPTSHIFT_REC

140: (
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_x_appr_deptshift_rec IN OUT NOCOPY AHL_APPR_DEPT_SHIFTS_PUB.APPR_DEPTSHIFT_REC
145: )
146: as
147: CURSOR get_org_id(C_NAME VARCHAR2)
148: IS

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

378: WHEN OTHERS THEN
379: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
381: THEN
382: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
383: p_procedure_name => 'TRANSLATE_VALUE_ID',
384: p_error_text => SUBSTR(SQLERRM,1,240));
385: END IF;
386: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 398: p_appr_deptshift_rec IN AHL_APPR_DEPT_SHIFTS_PUB.appr_deptshift_rec

394: (
395: x_return_status OUT NOCOPY VARCHAR2,
396: x_msg_count OUT NOCOPY NUMBER,
397: x_msg_data OUT NOCOPY VARCHAR2,
398: p_appr_deptshift_rec IN AHL_APPR_DEPT_SHIFTS_PUB.appr_deptshift_rec
399: )
400: as
401: l_counter NUMBER:=0;
402: l_prim_key NUMBER:=0;

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

531: WHEN OTHERS THEN
532: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
534: THEN
535: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
536: p_procedure_name => 'VALIDATE_APPR_DEPT_SHIFT',
537: p_error_text => SUBSTR(SQLERRM,1,240));
538: END IF;
539: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

765: ROLLBACK TO CREATE_APPR_DEPT_SHIFTS;
766: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
768: THEN
769: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
770: p_procedure_name => 'CREATE_APPR_DEPT_SHIFTS',
771: p_error_text => SUBSTR(SQLERRM,1,240));
772:
773: END IF;

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

901: ROLLBACK TO DELETE_DEPT_SHIFTS;
902: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
903: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
904: THEN
905: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_DEPT_SHIFTS_PUB',
906: p_procedure_name => 'CREATE_APPR_DEPT_SHIFTS',
907: p_error_text => SUBSTR(SQLERRM,1,240));
908:
909: END IF;

Line 915: END AHL_APPR_DEPT_SHIFTS_PUB;

911: p_count => x_msg_count,
912: p_data => X_msg_data);
913: END;
914:
915: END AHL_APPR_DEPT_SHIFTS_PUB;