APPS.AHL_PRD_PRINT_CUHK dependencies on FND_API

Line 51: x_return_status:=FND_API.G_RET_STS_SUCCESS;

47:
48: BEGIN
49: SAVEPOINT Generate_JCG_XML_PRE_CUHK;
50:
51: x_return_status:=FND_API.G_RET_STS_SUCCESS;
52:
53: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
54: fnd_log.string
55: (

Line 87: WHEN FND_API.G_EXC_ERROR THEN

83:
84: END IF;
85:
86: EXCEPTION
87: WHEN FND_API.G_EXC_ERROR THEN
88: ROLLBACK TO Generate_JCG_XML_PRE_CUHK;
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: FND_MSG_PUB.count_and_get(
91: p_encoded => FND_API.G_FALSE,

Line 89: x_return_status := FND_API.G_RET_STS_ERROR;

85:
86: EXCEPTION
87: WHEN FND_API.G_EXC_ERROR THEN
88: ROLLBACK TO Generate_JCG_XML_PRE_CUHK;
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: FND_MSG_PUB.count_and_get(
91: p_encoded => FND_API.G_FALSE,
92: p_count => x_msg_count,
93: p_data => x_msg_data);

Line 91: p_encoded => FND_API.G_FALSE,

87: WHEN FND_API.G_EXC_ERROR THEN
88: ROLLBACK TO Generate_JCG_XML_PRE_CUHK;
89: x_return_status := FND_API.G_RET_STS_ERROR;
90: FND_MSG_PUB.count_and_get(
91: p_encoded => FND_API.G_FALSE,
92: p_count => x_msg_count,
93: p_data => x_msg_data);
94:
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

91: p_encoded => FND_API.G_FALSE,
92: p_count => x_msg_count,
93: p_data => x_msg_data);
94:
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96: ROLLBACK TO Generate_JCG_XML_PRE_CUHK;
97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
98: FND_MSG_PUB.count_and_get(
99: p_encoded => FND_API.G_FALSE,

Line 97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

93: p_data => x_msg_data);
94:
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96: ROLLBACK TO Generate_JCG_XML_PRE_CUHK;
97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
98: FND_MSG_PUB.count_and_get(
99: p_encoded => FND_API.G_FALSE,
100: p_count => x_msg_count,
101: p_data => x_msg_data);

Line 99: p_encoded => FND_API.G_FALSE,

95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96: ROLLBACK TO Generate_JCG_XML_PRE_CUHK;
97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
98: FND_MSG_PUB.count_and_get(
99: p_encoded => FND_API.G_FALSE,
100: p_count => x_msg_count,
101: p_data => x_msg_data);
102:
103: WHEN OTHERS THEN

Line 105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

101: p_data => x_msg_data);
102:
103: WHEN OTHERS THEN
104: ROLLBACK TO Generate_JCG_XML_PRE_CUHK;
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
107: FND_MSG_PUB.add_exc_msg(
108: p_pkg_name => G_PKG_NAME,
109: p_procedure_name => l_api_name,

Line 113: p_encoded => FND_API.G_FALSE,

109: p_procedure_name => l_api_name,
110: p_error_text => SUBSTRB(SQLERRM,1,240));
111: END IF;
112: FND_MSG_PUB.count_and_get(
113: p_encoded => FND_API.G_FALSE,
114: p_count => x_msg_count,
115: p_data => x_msg_data);
116:
117: END Generate_JCG_XML_PRE;

Line 217: x_return_status:=FND_API.G_RET_STS_SUCCESS;

213: 'Input p_jcg_wrkpkg_location:' || p_jcg_wrkpkg_location);
214:
215: END IF;
216:
217: x_return_status:=FND_API.G_RET_STS_SUCCESS;
218:
219: /* For more information on out of the box transformation provided, customer can
220: * review following procedures and function -
221:

Line 251: WHEN FND_API.G_EXC_ERROR THEN

247: );
248: END IF;
249:
250: EXCEPTION
251: WHEN FND_API.G_EXC_ERROR THEN
252: ROLLBACK TO Generate_JCG_XML_POST_CUHK;
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: FND_MSG_PUB.count_and_get(
255: p_encoded => FND_API.G_FALSE,

Line 253: x_return_status := FND_API.G_RET_STS_ERROR;

249:
250: EXCEPTION
251: WHEN FND_API.G_EXC_ERROR THEN
252: ROLLBACK TO Generate_JCG_XML_POST_CUHK;
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: FND_MSG_PUB.count_and_get(
255: p_encoded => FND_API.G_FALSE,
256: p_count => x_msg_count,
257: p_data => x_msg_data);

Line 255: p_encoded => FND_API.G_FALSE,

251: WHEN FND_API.G_EXC_ERROR THEN
252: ROLLBACK TO Generate_JCG_XML_POST_CUHK;
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: FND_MSG_PUB.count_and_get(
255: p_encoded => FND_API.G_FALSE,
256: p_count => x_msg_count,
257: p_data => x_msg_data);
258:
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

255: p_encoded => FND_API.G_FALSE,
256: p_count => x_msg_count,
257: p_data => x_msg_data);
258:
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: ROLLBACK TO Generate_JCG_XML_POST_CUHK;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: FND_MSG_PUB.count_and_get(
263: p_encoded => FND_API.G_FALSE,

Line 261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

257: p_data => x_msg_data);
258:
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: ROLLBACK TO Generate_JCG_XML_POST_CUHK;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: FND_MSG_PUB.count_and_get(
263: p_encoded => FND_API.G_FALSE,
264: p_count => x_msg_count,
265: p_data => x_msg_data);

Line 263: p_encoded => FND_API.G_FALSE,

259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
260: ROLLBACK TO Generate_JCG_XML_POST_CUHK;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: FND_MSG_PUB.count_and_get(
263: p_encoded => FND_API.G_FALSE,
264: p_count => x_msg_count,
265: p_data => x_msg_data);
266:
267: WHEN OTHERS THEN

Line 269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

265: p_data => x_msg_data);
266:
267: WHEN OTHERS THEN
268: ROLLBACK TO Generate_JCG_XML_POST_CUHK;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
271: FND_MSG_PUB.add_exc_msg(
272: p_pkg_name => G_PKG_NAME,
273: p_procedure_name => l_api_name,

Line 277: p_encoded => FND_API.G_FALSE,

273: p_procedure_name => l_api_name,
274: p_error_text => SUBSTRB(SQLERRM,1,240));
275: END IF;
276: FND_MSG_PUB.count_and_get(
277: p_encoded => FND_API.G_FALSE,
278: p_count => x_msg_count,
279: p_data => x_msg_data);
280:
281: END Generate_JCG_XML_POST;