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.12020000.2 2012/12/07 00:10:16 sareepar 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.12020000.2 2012/12/07 00:10:16 sareepar 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 157: p_x_appr_deptshift_rec IN OUT NOCOPY AHL_APPR_DEPT_SHIFTS_PUB.APPR_DEPTSHIFT_REC

153: (
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_x_appr_deptshift_rec IN OUT NOCOPY AHL_APPR_DEPT_SHIFTS_PUB.APPR_DEPTSHIFT_REC
158: )
159: as
160: CURSOR get_org_id(C_NAME VARCHAR2)
161: IS

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 411: p_appr_deptshift_rec IN AHL_APPR_DEPT_SHIFTS_PUB.appr_deptshift_rec

407: (
408: x_return_status OUT NOCOPY VARCHAR2,
409: x_msg_count OUT NOCOPY NUMBER,
410: x_msg_data OUT NOCOPY VARCHAR2,
411: p_appr_deptshift_rec IN AHL_APPR_DEPT_SHIFTS_PUB.appr_deptshift_rec
412: )
413: as
414: l_counter NUMBER:=0;
415: l_prim_key NUMBER:=0;

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 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 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 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 1171: END AHL_APPR_DEPT_SHIFTS_PUB;

1167: p_count => x_msg_count,
1168: p_data => X_msg_data);
1169: END;
1170:
1171: END AHL_APPR_DEPT_SHIFTS_PUB;