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_PC_HEADER_PUB dependencies on FND_MSG_PUB

Line 39: FND_MSG_PUB.ADD;

35: BEGIN
36: IF TRIM(p_lookup_meaning) IS NULL AND TRIM(p_lookup_code) IS NULL
37: THEN
38: FND_MESSAGE.Set_Name('AHL',p_error_reqd);
39: FND_MSG_PUB.ADD;
40: ELSE
41: OPEN check_fnd_lookup(p_lookup_type ,p_lookup_meaning, p_lookup_code);
42: FETCH check_fnd_lookup into p_lookup_code,p_lookup_meaning;
43: IF check_fnd_lookup%NOTFOUND

Line 46: FND_MSG_PUB.ADD;

42: FETCH check_fnd_lookup into p_lookup_code,p_lookup_meaning;
43: IF check_fnd_lookup%NOTFOUND
44: THEN
45: FND_MESSAGE.Set_Name('AHL',p_error_exists);
46: FND_MSG_PUB.ADD;
47: CLOSE check_fnd_lookup;
48: END IF;
49: END IF;
50:

Line 69: FND_MSG_PUB.ADD;

65: -- PC name is mandatory
66: IF TRIM(p_x_pc_header_rec.NAME) IS NULL
67: THEN
68: FND_MESSAGE.Set_Name('AHL','AHL_PC_NAME_REQD');
69: FND_MSG_PUB.ADD;
70: END IF;
71:
72: VALIDATE_FND_LOOKUPS
73: (

Line 107: FND_MSG_PUB.ADD;

103: THEN
104: IF TRIM(p_x_pc_header_rec.PC_HEADER_ID) IS NULL
105: THEN
106: FND_MESSAGE.Set_Name('AHL','AHL_PC_HEADER_ID_REQCD');
107: FND_MSG_PUB.ADD;
108: END IF;
109: END IF;
110:
111: END VALIDATE_HEADER;

Line 151: FND_MSG_PUB.ADD;

147: -- Item Type Desc is not passed from frontend, then ERROR
148: IF (p_x_pc_header_rec.PRODUCT_TYPE_DESC) IS NULL
149: THEN
150: FND_MESSAGE.SET_NAME('AHL','AHL_PC_PRODUCT_TYPE_REQD');
151: FND_MSG_PUB.ADD;
152: RAISE FND_API.G_EXC_ERROR;
153: ELSE
154: OPEN get_item_type_code (p_x_pc_header_rec.PRODUCT_TYPE_DESC);
155: FETCH get_item_type_code INTO l_item_type_code, l_item_type_desc;

Line 160: FND_MSG_PUB.ADD;

156: -- No such Item Type found for passed Item Type Desc, then ERROR
157: IF (get_item_type_code%NOTFOUND)
158: THEN
159: FND_MESSAGE.SET_NAME('AHL','AHL_PC_PRODUCT_TYPE_NOT_FOUND');
160: FND_MSG_PUB.ADD;
161: CLOSE get_item_type_code;
162: RAISE FND_API.G_EXC_ERROR;
163: ELSE
164: FETCH get_item_type_code INTO l_dummy_code, l_dummy_desc;

Line 174: FND_MSG_PUB.ADD;

170: FETCH check_item_type_desc_and_code INTO l_dummy_code, l_dummy_desc;
171: IF (check_item_type_desc_and_code%NOTFOUND)
172: THEN
173: FND_MESSAGE.SET_NAME('AHL','AHL_PC_DUP_PROD_CODE_FOR_DESC');
174: FND_MSG_PUB.ADD;
175: CLOSE check_item_type_desc_and_code;
176: CLOSE get_item_type_code;
177: RAISE FND_API.G_EXC_ERROR;
178: ELSE

Line 182: FND_MSG_PUB.ADD;

178: ELSE
179: IF ( p_x_pc_header_rec.PRODUCT_TYPE_CODE) IS NULL
180: THEN
181: FND_MESSAGE.SET_NAME('AHL','AHL_PC_DUP_PROD_CODE_FOR_DESC');
182: FND_MSG_PUB.ADD;
183: CLOSE check_item_type_desc_and_code;
184: CLOSE get_item_type_code;
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;

Line 232: FND_MSG_PUB.Initialize;

228:
229: -- Initialize message list if p_init_msg_list is set to TRUE
230: IF FND_API.To_Boolean(p_init_msg_list)
231: THEN
232: FND_MSG_PUB.Initialize;
233: END IF;
234:
235: x_return_status := FND_API.G_RET_STS_SUCCESS;
236:

Line 260: x_msg_count := FND_MSG_PUB.count_msg;

256:
257: VALIDATE_HEADER (p_x_pc_header_rec);
258:
259: -- Check Error Message stack.
260: x_msg_count := FND_MSG_PUB.count_msg;
261: IF x_msg_count > 0
262: THEN
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;

Line 341: x_msg_count := FND_MSG_PUB.count_msg;

337: );
338: END IF;
339:
340: -- Check Error Message stack.
341: x_msg_count := FND_MSG_PUB.count_msg;
342: IF x_msg_count > 0
343: THEN
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;

Line 354: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

350: COMMIT WORK;
351: END IF;
352:
353: -- Standard call to get message count and if count is 1, get message info
354: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
355: p_data => x_msg_data,
356: p_encoded => fnd_api.g_false );
357:
358: EXCEPTION

Line 362: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

358: EXCEPTION
359: WHEN FND_API.G_EXC_ERROR THEN
360: x_return_status := FND_API.G_RET_STS_ERROR;
361: Rollback to PROCESS_PC_HEADER_PUB;
362: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
363: p_data => x_msg_data,
364: p_encoded => fnd_api.g_false );
365:
366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 369: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

365:
366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
368: Rollback to PROCESS_PC_HEADER_PUB;
369: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
370: p_data => x_msg_data,
371: p_encoded => fnd_api.g_false );
372:
373: WHEN OTHERS THEN

Line 376: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

372:
373: WHEN OTHERS THEN
374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
375: Rollback to PROCESS_PC_HEADER_PUB;
376: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
377: THEN
378: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
379: p_procedure_name => 'PROCESS_PC_HEADER',
380: p_error_text => SUBSTR(SQLERRM,1,240) );

Line 378: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
375: Rollback to PROCESS_PC_HEADER_PUB;
376: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
377: THEN
378: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
379: p_procedure_name => 'PROCESS_PC_HEADER',
380: p_error_text => SUBSTR(SQLERRM,1,240) );
381: END IF;
382: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 382: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

378: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
379: p_procedure_name => 'PROCESS_PC_HEADER',
380: p_error_text => SUBSTR(SQLERRM,1,240) );
381: END IF;
382: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
383: p_data => x_msg_data,
384: p_encoded => fnd_api.g_false );
385:
386: END PROCESS_PC_HEADER ;