DBA Data[Home] [Help]

APPS.HZ_ACCT_CREATE_PKG dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

184: SET COMPETITOR_FLAG = p_flag_value
185: WHERE party_id = p_party_id;
186: END IF;
187: ELSE
188: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
189: FND_MESSAGE.SET_TOKEN('RECORD','HZ_PARTIES');
190: FND_MESSAGE.SET_TOKEN('ID',p_party_id);
191: FND_MSG_PUB.ADD;
192: x_return_status := FND_API.G_RET_STS_ERROR;

Line 189: FND_MESSAGE.SET_TOKEN('RECORD','HZ_PARTIES');

185: WHERE party_id = p_party_id;
186: END IF;
187: ELSE
188: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
189: FND_MESSAGE.SET_TOKEN('RECORD','HZ_PARTIES');
190: FND_MESSAGE.SET_TOKEN('ID',p_party_id);
191: FND_MSG_PUB.ADD;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: END IF;

Line 190: FND_MESSAGE.SET_TOKEN('ID',p_party_id);

186: END IF;
187: ELSE
188: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
189: FND_MESSAGE.SET_TOKEN('RECORD','HZ_PARTIES');
190: FND_MESSAGE.SET_TOKEN('ID',p_party_id);
191: FND_MSG_PUB.ADD;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: END IF;
194: CLOSE cu_party_update;

Line 200: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

196: WHEN OTHERS THEN
197: IF cu_party_update%ISOPEN THEN
198: CLOSE cu_party_update;
199: END IF;
200: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
201: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
202: FND_MSG_PUB.ADD;
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: END;

Line 201: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

197: IF cu_party_update%ISOPEN THEN
198: CLOSE cu_party_update;
199: END IF;
200: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
201: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
202: FND_MSG_PUB.ADD;
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: END;
205:

Line 3108: fnd_message.set_name ('AR','AR_PARTY_NUMBER_EXISTS');

3104: );
3105:
3106: exception
3107: when NO_DATA_FOUND then
3108: fnd_message.set_name ('AR','AR_PARTY_NUMBER_EXISTS');
3109: app_exception.raise_exception;
3110: end check_unique_party_number;
3111: --
3112: --