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_PRD_WORKORDER_CUHK dependencies on FND_API

Line 18: x_return_status:=FND_API.G_RET_STS_SUCCESS;

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
21: WHEN FND_API.G_EXC_ERROR THEN
22: ROLLBACK TO ahl_prd_workorder_cuhk;

Line 21: WHEN FND_API.G_EXC_ERROR THEN

17: --dbms_output.put_line('Inside CREATE_JOB_PRE Hook -->' );
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,

Line 23: x_return_status := FND_API.G_RET_STS_ERROR;

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,
27: p_data => x_msg_data);

Line 25: p_encoded => FND_API.G_FALSE,

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,
27: p_data => x_msg_data);
28:
29: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 29: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

25: p_encoded => FND_API.G_FALSE,
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,

Line 31: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
35: p_data => x_msg_data);

Line 33: p_encoded => FND_API.G_FALSE,

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,
35: p_data => x_msg_data);
36:
37: WHEN OTHERS THEN

Line 39: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
43: p_procedure_name => l_api_name,

Line 47: p_encoded => FND_API.G_FALSE,

43: p_procedure_name => l_api_name,
44: p_error_text => SUBSTRB(SQLERRM,1,240));
45: END IF;
46: FND_MSG_PUB.count_and_get(
47: p_encoded => FND_API.G_FALSE,
48: p_count => x_msg_count,
49: p_data => x_msg_data);
50:
51: End CREATE_JOB_PRE;

Line 69: x_return_status:=FND_API.G_RET_STS_SUCCESS;

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:
73: EXCEPTION

Line 74: WHEN FND_API.G_EXC_ERROR THEN

70: --dbms_output.put_line('Inside CREATE_JOB_POST Hook -->' );
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,

Line 76: x_return_status := FND_API.G_RET_STS_ERROR;

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,
80: p_data => x_msg_data);

Line 78: p_encoded => FND_API.G_FALSE,

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,
80: p_data => x_msg_data);
81:
82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 82: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

78: p_encoded => FND_API.G_FALSE,
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,

Line 84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
88: p_data => x_msg_data);

Line 86: p_encoded => FND_API.G_FALSE,

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,
88: p_data => x_msg_data);
89:
90: WHEN OTHERS THEN

Line 92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
96: p_procedure_name => l_api_name,

Line 100: p_encoded => FND_API.G_FALSE,

96: p_procedure_name => l_api_name,
97: p_error_text => SUBSTRB(SQLERRM,1,240));
98: END IF;
99: FND_MSG_PUB.count_and_get(
100: p_encoded => FND_API.G_FALSE,
101: p_count => x_msg_count,
102: p_data => x_msg_data);
103:
104: End CREATE_JOB_POST;

Line 120: x_return_status:=FND_API.G_RET_STS_SUCCESS;

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
124: WHEN FND_API.G_EXC_ERROR THEN

Line 124: WHEN FND_API.G_EXC_ERROR THEN

120: x_return_status:=FND_API.G_RET_STS_SUCCESS;
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,

Line 126: x_return_status := FND_API.G_RET_STS_ERROR;

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,
130: p_data => x_msg_data);

Line 128: p_encoded => FND_API.G_FALSE,

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,
130: p_data => x_msg_data);
131:
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

128: p_encoded => FND_API.G_FALSE,
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,

Line 134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
138: p_data => x_msg_data);

Line 136: p_encoded => FND_API.G_FALSE,

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,
138: p_data => x_msg_data);
139:
140: WHEN OTHERS THEN

Line 142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
146: p_procedure_name => l_api_name,

Line 150: p_encoded => FND_API.G_FALSE,

146: p_procedure_name => l_api_name,
147: p_error_text => SUBSTRB(SQLERRM,1,240));
148: END IF;
149: FND_MSG_PUB.count_and_get(
150: p_encoded => FND_API.G_FALSE,
151: p_count => x_msg_count,
152: p_data => x_msg_data);
153:
154: End UPDATE_JOB_PRE ;

Line 170: x_return_status:=FND_API.G_RET_STS_SUCCESS;

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
174: WHEN FND_API.G_EXC_ERROR THEN

Line 174: WHEN FND_API.G_EXC_ERROR THEN

170: x_return_status:=FND_API.G_RET_STS_SUCCESS;
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,

Line 176: x_return_status := FND_API.G_RET_STS_ERROR;

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,
180: p_data => x_msg_data);

Line 178: p_encoded => FND_API.G_FALSE,

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,
180: p_data => x_msg_data);
181:
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

178: p_encoded => FND_API.G_FALSE,
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,

Line 184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
188: p_data => x_msg_data);

Line 186: p_encoded => FND_API.G_FALSE,

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,
188: p_data => x_msg_data);
189:
190: WHEN OTHERS THEN

Line 192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,
196: p_procedure_name => l_api_name,

Line 200: p_encoded => FND_API.G_FALSE,

196: p_procedure_name => l_api_name,
197: p_error_text => SUBSTRB(SQLERRM,1,240));
198: END IF;
199: FND_MSG_PUB.count_and_get(
200: p_encoded => FND_API.G_FALSE,
201: p_count => x_msg_count,
202: p_data => x_msg_data);
203:
204: End UPDATE_JOB_POST;