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 231: FND_MSG_PUB.Initialize;

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

Line 259: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 339: x_msg_count := FND_MSG_PUB.count_msg;

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

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

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

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

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

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

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

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

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

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

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

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

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