DBA Data[Home] [Help]

APPS.ASG_CUSTOM_PVT dependencies on FND_MSG_PUB

Line 88: fND_MSG_PUB.initialize;

84:
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: if FND_API.to_Boolean( p_init_msg_list)
87: then
88: fND_MSG_PUB.initialize;
89: end if;
90: -- Initialize API return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:

Line 121: fnd_msg_pub.Add;

117: then
118: -- this table does not exist
119: log(p_base_table_name || ' does not exists!');
120: fnd_message.set_name('ASG','TABLE_NOT EXISTS');
121: fnd_msg_pub.Add;
122: raise FND_API.G_EXC_ERROR;
123: end if;
124: else
125: */

Line 130: fnd_msg_pub.Add;

126: if (p_base_table_name is NULL)
127: then
128: log('p_base_table_name Should not be NULL!');
129: fnd_message.set_name('ASG','NO BASE TABLE NAME');
130: fnd_msg_pub.Add;
131: raise FND_API.G_EXC_ERROR;
132: end if;
133:
134:

Line 148: fnd_msg_pub.Add;

144: then
145: -- the custom flag is not Y
146: log(p_pub_item_name || ' is not for the customization!');
147: fnd_message.set_name('ASG','PUB ITEM NOT CUSTOMABLE');
148: fnd_msg_pub.Add;
149: raise FND_API.G_EXC_ERROR;
150: end if;
151:
152: -- *****************

Line 159: fnd_msg_pub.Add;

155: if p_primary_key_columns is NULL
156: then
157: log( 'p_primary_key_columns Should not be NULL!');
158: fnd_message.set_name('ASG','NULL PK COLUMNS');
159: fnd_msg_pub.Add;
160: raise FND_API.G_EXC_ERROR;
161: end if;
162:
163: -- ******************

Line 181: fnd_msg_pub.Add;

177: if (l_pk_num <> find_num_pkcols(p_primary_key_columns))
178: then
179: log (' The Primary Keys number does not match with the pub item');
180: fnd_message.set_name('ASG','PK number _NOT matched');
181: fnd_msg_pub.Add;
182: raise FND_API.G_EXC_ERROR;
183: end if;
184:
185:

Line 200: fnd_msg_pub.Add;

196: then
197: log (' The pub item base table cannot be changed while there is
198: record existing in the acc table!');
199: fnd_message.set_name('ASG','RECORDS EXISTING IN ACC TABLE');
200: fnd_msg_pub.Add;
201: raise FND_API.G_EXC_ERROR;
202: END IF;
203: END IF;
204:

Line 307: FND_MSG_PUB.Count_And_Get

303: EXCEPTION
304: WHEN FND_API.G_EXC_ERROR THEN
305: Rollback to customize_pub_item_PVT;
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: FND_MSG_PUB.Count_And_Get
308: (
309: p_count => x_msg_count,
310: p_data => x_error_message
311: );

Line 315: FND_MSG_PUB.Count_And_Get

311: );
312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
313: Rollback to customize_pub_item_PVT;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: FND_MSG_PUB.Count_And_Get
316: (
317: p_count => x_msg_count,
318: p_data => x_error_message
319: );

Line 323: if FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

319: );
320: WHEN OTHERS THEN
321: Rollback to customize_pub_item_PVT;
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
323: if FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: then
325: FND_MSG_PUB.Add_Exc_Msg
326: (
327: G_PKG_NAME,

Line 325: FND_MSG_PUB.Add_Exc_Msg

321: Rollback to customize_pub_item_PVT;
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
323: if FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
324: then
325: FND_MSG_PUB.Add_Exc_Msg
326: (
327: G_PKG_NAME,
328: l_api_name,
329: sqlerrm

Line 332: FND_MSG_PUB.Count_And_Get

328: l_api_name,
329: sqlerrm
330: );
331: end if;
332: FND_MSG_PUB.Count_And_Get
333: (
334: p_count => x_msg_count,
335: p_data => x_error_message
336: );

Line 352: fnd_msg_pub.Add;

348: RETURN FND_API.G_RET_STS_SUCCESS;
349: EXCEPTION
350: when OTHERS then
351: fnd_message.set_name('ASG','SQL COMMAND FAIL!');
352: fnd_msg_pub.Add;
353: log ( substr(sqlerrm, 1, 200));
354: Raise;
355: RETURN FND_API.G_RET_STS_ERROR;
356: end;

Line 556: FND_MSG_PUB.initialize;

552:
553: -- Initialize message list if p_init_msg_list is set to TRUE.
554: if FND_API.to_Boolean( p_init_msg_list)
555: then
556: FND_MSG_PUB.initialize;
557: end if;
558:
559: -- Initialize API return status to success
560: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 625: FND_MSG_PUB.initialize;

621:
622: -- Initialize message list if p_init_msg_list is set to TRUE.
623: if FND_API.to_Boolean( p_init_msg_list)
624: then
625: FND_MSG_PUB.initialize;
626: end if;
627: -- Initialize API return status to success
628: x_return_status := FND_API.G_RET_STS_SUCCESS;
629:

Line 695: FND_MSG_PUB.initialize;

691:
692: -- Initialize message list if p_init_msg_list is set to TRUE.
693: if FND_API.to_Boolean( p_init_msg_list)
694: then
695: FND_MSG_PUB.initialize;
696: end if;
697:
698: -- Initialize API return status to success
699: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 767: FND_MSG_PUB.initialize;

763:
764: -- Initialize message list if p_init_msg_list is set to TRUE.
765: if FND_API.to_Boolean( p_init_msg_list)
766: then
767: FND_MSG_PUB.initialize;
768: end if;
769:
770: -- Initialize API return status to success
771: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 837: FND_MSG_PUB.initialize;

833:
834: -- Initialize message list if p_init_msg_list is set to TRUE.
835: if FND_API.to_Boolean( p_init_msg_list)
836: then
837: FND_MSG_PUB.initialize;
838: end if;
839:
840: -- Initialize API return status to success
841: x_return_status := FND_API.G_RET_STS_SUCCESS;