DBA Data[Home] [Help]

APPS.ARH_PHON_PKG dependencies on FND_MESSAGE

Line 137: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');

133: CLOSE cu_contact_point_version;
134: END IF;
135:
136: IF x_rowid IS NULL THEN
137: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
138: FND_MESSAGE.SET_TOKEN('RECORD',p_table_name);
139: FND_MESSAGE.SET_TOKEN('ID',p_col_id);
140: FND_MSG_PUB.ADD;
141: x_return_status := FND_API.G_RET_STS_ERROR;

Line 138: FND_MESSAGE.SET_TOKEN('RECORD',p_table_name);

134: END IF;
135:
136: IF x_rowid IS NULL THEN
137: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
138: FND_MESSAGE.SET_TOKEN('RECORD',p_table_name);
139: FND_MESSAGE.SET_TOKEN('ID',p_col_id);
140: FND_MSG_PUB.ADD;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: ELSE

Line 139: FND_MESSAGE.SET_TOKEN('ID',p_col_id);

135:
136: IF x_rowid IS NULL THEN
137: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
138: FND_MESSAGE.SET_TOKEN('RECORD',p_table_name);
139: FND_MESSAGE.SET_TOKEN('ID',p_col_id);
140: FND_MSG_PUB.ADD;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: ELSE
143: IF TO_CHAR(x_last_update_date,'DD-MON-YYYY HH:MI:SS') <>

Line 146: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

142: ELSE
143: IF TO_CHAR(x_last_update_date,'DD-MON-YYYY HH:MI:SS') <>
144: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
145: THEN
146: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
147: FND_MESSAGE.SET_TOKEN('TABLE', p_table_name);
148: FND_MSG_PUB.ADD;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: END IF;

Line 147: FND_MESSAGE.SET_TOKEN('TABLE', p_table_name);

143: IF TO_CHAR(x_last_update_date,'DD-MON-YYYY HH:MI:SS') <>
144: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
145: THEN
146: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
147: FND_MESSAGE.SET_TOKEN('TABLE', p_table_name);
148: FND_MSG_PUB.ADD;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: END IF;
151: END IF;

Line 229: fnd_message.set_name('AR','AR_CUST_ONE_PRIMARY_PHONE');

225: and ( (p_phone_id is null)
226: or cont_point.contact_point_id <> p_phone_id );
227: --
228: if ( primary_count >= 1 ) then
229: fnd_message.set_name('AR','AR_CUST_ONE_PRIMARY_PHONE');
230: app_exception.raise_exception;
231: end if;
232: --
233: elsif (p_type = 'ADDR' ) then

Line 250: fnd_message.set_name('AR','AR_CUST_ADDR_ONE_PRIMARY_PHONE');

246: and ( (p_phone_id is null)
247: or cont_point.contact_point_id <> p_phone_id );
248: --
249: if ( primary_count >= 1 ) then
250: fnd_message.set_name('AR','AR_CUST_ADDR_ONE_PRIMARY_PHONE');
251: app_exception.raise_exception;
252: end if;
253: elsif (p_type = 'CONT' ) then
254: --

Line 269: fnd_message.set_name('AR','AR_CUST_CONT_ONE_PRIMARY_PHONE');

265: and ( (p_phone_id is null)
266: or cont_point.contact_point_id <> p_phone_id );
267: --
268: if ( primary_count >= 1 ) then
269: fnd_message.set_name('AR','AR_CUST_CONT_ONE_PRIMARY_PHONE');
270: app_exception.raise_exception;
271: end if;
272: else
273: app_exception.invalid_argument('arp_phones_pkg.check_primary','p_type',p_type);