APPS.AHL_OSP_ORDERS_CUHK dependencies on FND_MSG_PUB

Line 34: FND_MSG_PUB.add;

30: FETCH get_item_flag INTO l_first_item_flag;
31: IF get_item_flag%NOTFOUND THEN
32: FND_MESSAGE.set_name('AHL', 'AHL_OSP_ORD_INV_ITEM');
33: FND_MESSAGE.set_token('ITEM_ID', p_osp_order_lines_tbl(1).inventory_item_id);
34: FND_MSG_PUB.add;
35: CLOSE get_item_flag;
36: RAISE FND_API.G_EXC_ERROR;
37: ELSE
38: CLOSE get_item_flag;

Line 46: FND_MSG_PUB.ADD;

42: FETCH get_item_flag INTO l_temp_item_flag;
43: IF get_item_flag%NOTFOUND THEN
44: FND_MESSAGE.set_name('AHL', 'AHL_OSP_ORD_INV_ITEM');
45: FND_MESSAGE.set_token('ITEM_ID', p_osp_order_lines_tbl(i).inventory_item_id);
46: FND_MSG_PUB.ADD;
47: CLOSE get_item_flag;
48: RAISE FND_API.G_EXC_ERROR;
49: ELSE
50: CLOSE get_item_flag;

Line 58: FND_MSG_PUB.add;

54: (l_temp_item_flag <> l_first_item_flag)) THEN
55: -- Throw an error about the mixed nature of items
56: FND_MESSAGE.set_name('AHL', 'AHL_OSP_CANNOT_MIX_ITEMS');
57: FND_MESSAGE.set_token('ITEM_ID', p_osp_order_lines_tbl(i).inventory_item_id);
58: FND_MSG_PUB.add;
59: RAISE FND_API.G_EXC_ERROR;
60: END IF;
61: END LOOP;
62: END IF;

Line 65: l_msg_count := FND_MSG_PUB.count_msg;

61: END LOOP;
62: END IF;
63: */
64: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
65: l_msg_count := FND_MSG_PUB.count_msg;
66: IF l_msg_count > 0 THEN
67: x_msg_count := l_msg_count;
68: RAISE FND_API.G_EXC_ERROR;
69: END IF;

Line 72: FND_MSG_PUB.count_and_get(

68: RAISE FND_API.G_EXC_ERROR;
69: END IF;
70:
71: -- Count and Get messages (optional)
72: FND_MSG_PUB.count_and_get(
73: p_encoded => FND_API.G_FALSE,
74: p_count => x_msg_count,
75: p_data => x_msg_data);
76:

Line 80: FND_MSG_PUB.count_and_get(

76:
77: EXCEPTION
78: WHEN FND_API.G_EXC_ERROR THEN
79: x_return_status := FND_API.G_RET_STS_ERROR;
80: FND_MSG_PUB.count_and_get(
81: p_encoded => FND_API.G_FALSE,
82: p_count => x_msg_count,
83: p_data => x_msg_data);
84:

Line 87: FND_MSG_PUB.count_and_get(

83: p_data => x_msg_data);
84:
85: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
86: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
87: FND_MSG_PUB.count_and_get(
88: p_encoded => FND_API.G_FALSE,
89: p_count => x_msg_count,
90: p_data => x_msg_data);
91:

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

90: p_data => x_msg_data);
91:
92: WHEN OTHERS THEN
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
95: THEN
96: FND_MSG_PUB.add_exc_msg(
97: p_pkg_name => G_PKG_NAME,
98: p_procedure_name => l_api_name,

Line 96: FND_MSG_PUB.add_exc_msg(

92: WHEN OTHERS THEN
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
95: THEN
96: FND_MSG_PUB.add_exc_msg(
97: p_pkg_name => G_PKG_NAME,
98: p_procedure_name => l_api_name,
99: p_error_text => SUBSTRB(SQLERRM,1,240));
100: END IF;

Line 101: FND_MSG_PUB.count_and_get(

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

Line 124: l_msg_count := FND_MSG_PUB.count_msg;

120:
121: --Users can add their own customization code here
122:
123: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
124: l_msg_count := FND_MSG_PUB.count_msg;
125: IF l_msg_count > 0 THEN
126: x_msg_count := l_msg_count;
127: RAISE FND_API.G_EXC_ERROR;
128: END IF;

Line 131: FND_MSG_PUB.count_and_get(

127: RAISE FND_API.G_EXC_ERROR;
128: END IF;
129:
130: -- Count and Get messages (optional)
131: FND_MSG_PUB.count_and_get(
132: p_encoded => FND_API.G_FALSE,
133: p_count => x_msg_count,
134: p_data => x_msg_data);
135:

Line 139: FND_MSG_PUB.count_and_get(

135:
136: EXCEPTION
137: WHEN FND_API.G_EXC_ERROR THEN
138: x_return_status := FND_API.G_RET_STS_ERROR;
139: FND_MSG_PUB.count_and_get(
140: p_encoded => FND_API.G_FALSE,
141: p_count => x_msg_count,
142: p_data => x_msg_data);
143:

Line 146: FND_MSG_PUB.count_and_get(

142: p_data => x_msg_data);
143:
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: FND_MSG_PUB.count_and_get(
147: p_encoded => FND_API.G_FALSE,
148: p_count => x_msg_count,
149: p_data => x_msg_data);
150:

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

149: p_data => x_msg_data);
150:
151: WHEN OTHERS THEN
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
154: FND_MSG_PUB.add_exc_msg(
155: p_pkg_name => G_PKG_NAME,
156: p_procedure_name => l_api_name,
157: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 154: FND_MSG_PUB.add_exc_msg(

150:
151: WHEN OTHERS THEN
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
154: FND_MSG_PUB.add_exc_msg(
155: p_pkg_name => G_PKG_NAME,
156: p_procedure_name => l_api_name,
157: p_error_text => SUBSTRB(SQLERRM,1,240));
158: END IF;

Line 159: FND_MSG_PUB.count_and_get(

155: p_pkg_name => G_PKG_NAME,
156: p_procedure_name => l_api_name,
157: p_error_text => SUBSTRB(SQLERRM,1,240));
158: END IF;
159: FND_MSG_PUB.count_and_get(
160: p_encoded => FND_API.G_FALSE,
161: p_count => x_msg_count,
162: p_data => x_msg_data);
163: END process_osp_order_post;