APPS.ASG_CUSTOM_PVT dependencies on FND_MESSAGE

Line 120: fnd_message.set_name('ASG','TABLE_NOT EXISTS');

116: if l_table_exists = 0
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

Line 129: fnd_message.set_name('ASG','NO BASE TABLE NAME');

125: */
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:

Line 147: fnd_message.set_name('ASG','PUB ITEM NOT CUSTOMABLE');

143: if (l_custom_flag <> 'Y')
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:

Line 158: fnd_message.set_name('ASG','NULL PK COLUMNS');

154: -- ****************
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:

Line 180: fnd_message.set_name('ASG','PK number _NOT matched');

176: LAST_COL_NUM := l_pk_num + l_col_num;
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:

Line 199: fnd_message.set_name('ASG','RECORDS EXISTING IN ACC TABLE');

195: if (l_parent_table <> p_base_table_name AND l_acc_count <> 0)
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;

Line 351: fnd_message.set_name('ASG','SQL COMMAND FAIL!');

347:
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;