DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_CUHK dependencies on AHL_PRD_WORKORDER_CUHK

Line 1: Package body AHL_PRD_WORKORDER_CUHK AS

1: Package body AHL_PRD_WORKORDER_CUHK AS
2: /*$Header: AHLCPRJB.pls 120.0.12010000.1 2009/01/12 23:33:43 sikumar noship $*/
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_PRD_WORKORDER_CUHK';
5:

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

1: Package body AHL_PRD_WORKORDER_CUHK AS
2: /*$Header: AHLCPRJB.pls 120.0.12010000.1 2009/01/12 23:33:43 sikumar noship $*/
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_PRD_WORKORDER_CUHK';
5:
6: PROCEDURE CREATE_JOB_PRE
7: (
8: p_prd_workorder_rec IN AHL_PRD_WORKORDER_PVT.prd_workorder_rec,

Line 16: SAVEPOINT ahl_prd_workorder_cuhk;

12: IS
13: l_api_name VARCHAR2(30) := 'create_job_pre';
14:
15: BEGIN
16: SAVEPOINT ahl_prd_workorder_cuhk;
17: --dbms_output.put_line('Inside CREATE_JOB_PRE Hook -->' );
18: x_return_status:=FND_API.G_RET_STS_SUCCESS;
19:
20: EXCEPTION

Line 22: ROLLBACK TO ahl_prd_workorder_cuhk;

18: x_return_status:=FND_API.G_RET_STS_SUCCESS;
19:
20: EXCEPTION
21: WHEN FND_API.G_EXC_ERROR THEN
22: ROLLBACK TO ahl_prd_workorder_cuhk;
23: x_return_status := FND_API.G_RET_STS_ERROR;
24: FND_MSG_PUB.count_and_get(
25: p_encoded => FND_API.G_FALSE,
26: p_count => x_msg_count,

Line 30: ROLLBACK TO ahl_prd_workorder_cuhk;

26: p_count => x_msg_count,
27: p_data => x_msg_data);
28:
29: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
30: ROLLBACK TO ahl_prd_workorder_cuhk;
31: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
32: FND_MSG_PUB.count_and_get(
33: p_encoded => FND_API.G_FALSE,
34: p_count => x_msg_count,

Line 38: ROLLBACK TO ahl_prd_workorder_cuhk;

34: p_count => x_msg_count,
35: p_data => x_msg_data);
36:
37: WHEN OTHERS THEN
38: ROLLBACK TO ahl_prd_workorder_cuhk;
39: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
40: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
41: FND_MSG_PUB.add_exc_msg(
42: p_pkg_name => G_PKG_NAME,

Line 68: SAVEPOINT ahl_prd_workorder_cuhk;

64: IS
65: l_api_name VARCHAR2(30) := 'create_job_post';
66:
67: Begin
68: SAVEPOINT ahl_prd_workorder_cuhk;
69: x_return_status:=FND_API.G_RET_STS_SUCCESS;
70: --dbms_output.put_line('Inside CREATE_JOB_POST Hook -->' );
71:
72:

Line 75: ROLLBACK TO ahl_prd_workorder_cuhk;

71:
72:
73: EXCEPTION
74: WHEN FND_API.G_EXC_ERROR THEN
75: ROLLBACK TO ahl_prd_workorder_cuhk;
76: x_return_status := FND_API.G_RET_STS_ERROR;
77: FND_MSG_PUB.count_and_get(
78: p_encoded => FND_API.G_FALSE,
79: p_count => x_msg_count,

Line 83: ROLLBACK TO ahl_prd_workorder_cuhk;

79: p_count => x_msg_count,
80: p_data => x_msg_data);
81:
82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
83: ROLLBACK TO ahl_prd_workorder_cuhk;
84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
85: FND_MSG_PUB.count_and_get(
86: p_encoded => FND_API.G_FALSE,
87: p_count => x_msg_count,

Line 91: ROLLBACK TO ahl_prd_workorder_cuhk;

87: p_count => x_msg_count,
88: p_data => x_msg_data);
89:
90: WHEN OTHERS THEN
91: ROLLBACK TO ahl_prd_workorder_cuhk;
92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
93: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
94: FND_MSG_PUB.add_exc_msg(
95: p_pkg_name => G_PKG_NAME,

Line 119: SAVEPOINT ahl_prd_workorder_cuhk;

115: IS
116: l_api_name VARCHAR2(30) := 'update_job_pre';
117:
118: Begin
119: SAVEPOINT ahl_prd_workorder_cuhk;
120: x_return_status:=FND_API.G_RET_STS_SUCCESS;
121: --dbms_output.put_line('Inside UPDATE_JOB_PRE Hook -->' );
122:
123: EXCEPTION

Line 125: ROLLBACK TO ahl_prd_workorder_cuhk;

121: --dbms_output.put_line('Inside UPDATE_JOB_PRE Hook -->' );
122:
123: EXCEPTION
124: WHEN FND_API.G_EXC_ERROR THEN
125: ROLLBACK TO ahl_prd_workorder_cuhk;
126: x_return_status := FND_API.G_RET_STS_ERROR;
127: FND_MSG_PUB.count_and_get(
128: p_encoded => FND_API.G_FALSE,
129: p_count => x_msg_count,

Line 133: ROLLBACK TO ahl_prd_workorder_cuhk;

129: p_count => x_msg_count,
130: p_data => x_msg_data);
131:
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
133: ROLLBACK TO ahl_prd_workorder_cuhk;
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.count_and_get(
136: p_encoded => FND_API.G_FALSE,
137: p_count => x_msg_count,

Line 141: ROLLBACK TO ahl_prd_workorder_cuhk;

137: p_count => x_msg_count,
138: p_data => x_msg_data);
139:
140: WHEN OTHERS THEN
141: ROLLBACK TO ahl_prd_workorder_cuhk;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
144: FND_MSG_PUB.add_exc_msg(
145: p_pkg_name => G_PKG_NAME,

Line 169: SAVEPOINT ahl_prd_workorder_cuhk;

165: IS
166: l_api_name VARCHAR2(30) := 'update_job_post';
167:
168: BEGIN
169: SAVEPOINT ahl_prd_workorder_cuhk;
170: x_return_status:=FND_API.G_RET_STS_SUCCESS;
171: --dbms_output.put_line('Inside UPDATE_JOB_POST Hook -->' );
172:
173: EXCEPTION

Line 175: ROLLBACK TO ahl_prd_workorder_cuhk;

171: --dbms_output.put_line('Inside UPDATE_JOB_POST Hook -->' );
172:
173: EXCEPTION
174: WHEN FND_API.G_EXC_ERROR THEN
175: ROLLBACK TO ahl_prd_workorder_cuhk;
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: FND_MSG_PUB.count_and_get(
178: p_encoded => FND_API.G_FALSE,
179: p_count => x_msg_count,

Line 183: ROLLBACK TO ahl_prd_workorder_cuhk;

179: p_count => x_msg_count,
180: p_data => x_msg_data);
181:
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
183: ROLLBACK TO ahl_prd_workorder_cuhk;
184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
185: FND_MSG_PUB.count_and_get(
186: p_encoded => FND_API.G_FALSE,
187: p_count => x_msg_count,

Line 191: ROLLBACK TO ahl_prd_workorder_cuhk;

187: p_count => x_msg_count,
188: p_data => x_msg_data);
189:
190: WHEN OTHERS THEN
191: ROLLBACK TO ahl_prd_workorder_cuhk;
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
194: FND_MSG_PUB.add_exc_msg(
195: p_pkg_name => G_PKG_NAME,

Line 206: End AHL_PRD_WORKORDER_CUHK;

202: p_data => x_msg_data);
203:
204: End UPDATE_JOB_POST;
205:
206: End AHL_PRD_WORKORDER_CUHK;