APPS.HZ_MAP_PARTY_PUB dependencies on HZ_PARTY_INTERFACE_ERRORS

Line 165: | information is stored in hz_party_interface_errors

161: | set_hz_dnb_invalid_data
162: |
163: | DESCRIPTION
164: | o If value for any field passed by DNB is not valid, then this
165: | information is stored in hz_party_interface_errors
166: |
167: | SCOPE - PRIVATE
168: |
169: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 209: INSERT INTO hz_party_interface_errors (

205: FND_MESSAGE.SET_TOKEN('TCA_VALUE',p_tca_value);
206: END IF;
207: l_message_text := FND_MESSAGE.GET;
208:
209: INSERT INTO hz_party_interface_errors (
210: interface_error_id,
211: party_interface_id,
212: message_text,
213: created_by,

Line 219: hz_party_interface_errors_s.nextval,

215: last_updated_by,
216: last_update_date,
217: last_update_login)
218: VALUES (
219: hz_party_interface_errors_s.nextval,
220: G_PARTY_INTERFACE_ID,
221: l_message_text,
222: hz_utility_v2pub.created_by,
223: hz_utility_v2pub.creation_date,

Line 246: | o Inserts a record in hz_party_interface_errors for each field

242: | ~ Other lookup code columns will be set to NULL.
243: | o Status in hz_party_interface will be W1, W2 instead of P1,
244: | P2 respectively if this procedure modifies any errorneous
245: | DNB data.
246: | o Inserts a record in hz_party_interface_errors for each field
247: | rectified.
248: |
249: | SCOPE - PRIVATE
250: |

Line 6661: -- SELECT hz_party_interface_errors_s.nextval INTO l_interface_error_id from dual;

6657:
6658: FND_MSG_PUB.RESET;
6659:
6660: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
6661: -- SELECT hz_party_interface_errors_s.nextval INTO l_interface_error_id from dual;
6662:
6663: l_message_text := FND_MSG_PUB.Get(
6664: p_encoded => FND_API.G_FALSE );
6665:

Line 6666: INSERT INTO hz_party_interface_errors (

6662:
6663: l_message_text := FND_MSG_PUB.Get(
6664: p_encoded => FND_API.G_FALSE );
6665:
6666: INSERT INTO hz_party_interface_errors (
6667: interface_error_id,
6668: party_interface_id,
6669: message_text,
6670: created_by,

Line 6676: hz_party_interface_errors_s.nextval ,

6672: last_updated_by,
6673: last_update_date,
6674: last_update_login)
6675: VALUES (
6676: hz_party_interface_errors_s.nextval ,
6677: p_party_interface_id,
6678: l_message_text,
6679: hz_utility_v2pub.created_by,
6680: hz_utility_v2pub.creation_date,

Line 6687: COMMIT; /* commit update to hz_party_interface and inserts into hz_party_interface_errors */

6683: hz_utility_v2pub.last_update_login);
6684:
6685: END LOOP;
6686:
6687: COMMIT; /* commit update to hz_party_interface and inserts into hz_party_interface_errors */
6688:
6689: arp_util.debug('HZ_MAP_PARTY_PUB.STORE_ERROR (-) ');
6690:
6691: END store_error;