DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_CUHK dependencies on FND_MSG_PUB

Line 24: FND_MSG_PUB.count_and_get(

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);
28:

Line 32: FND_MSG_PUB.count_and_get(

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);
36:

Line 40: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
44: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 41: FND_MSG_PUB.add_exc_msg(

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,
44: p_error_text => SUBSTRB(SQLERRM,1,240));
45: END IF;

Line 46: FND_MSG_PUB.count_and_get(

42: p_pkg_name => G_PKG_NAME,
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:

Line 77: FND_MSG_PUB.count_and_get(

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);
81:

Line 85: FND_MSG_PUB.count_and_get(

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);
89:

Line 93: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
97: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 94: FND_MSG_PUB.add_exc_msg(

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,
97: p_error_text => SUBSTRB(SQLERRM,1,240));
98: END IF;

Line 99: FND_MSG_PUB.count_and_get(

95: p_pkg_name => G_PKG_NAME,
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:

Line 127: FND_MSG_PUB.count_and_get(

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);
131:

Line 135: FND_MSG_PUB.count_and_get(

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);
139:

Line 143: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
147: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 144: FND_MSG_PUB.add_exc_msg(

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,
147: p_error_text => SUBSTRB(SQLERRM,1,240));
148: END IF;

Line 149: FND_MSG_PUB.count_and_get(

145: p_pkg_name => G_PKG_NAME,
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:

Line 177: FND_MSG_PUB.count_and_get(

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);
181:

Line 185: FND_MSG_PUB.count_and_get(

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);
189:

Line 193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
197: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 194: FND_MSG_PUB.add_exc_msg(

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,
197: p_error_text => SUBSTRB(SQLERRM,1,240));
198: END IF;

Line 199: FND_MSG_PUB.count_and_get(

195: p_pkg_name => G_PKG_NAME,
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: