eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_FUZZY_PUB dependencies on FND_API

Line 420: IF upper(p_key_search_flag) = FND_API.G_FALSE

416: WHERE customer_key = X_party_Key;
417:
418: BEGIN
419: -- if the request is not to use the keys then use match by party name
420: IF upper(p_key_search_flag) = FND_API.G_FALSE
421: THEN
422: OPEN C_Duplicate_Names(p_party_name);
423: FETCH C_Duplicate_Names INTO p_party_id;
424: IF (C_Duplicate_Names%NOTFOUND)

Line 426: p_is_duplicate := FND_API.G_FALSE;

422: OPEN C_Duplicate_Names(p_party_name);
423: FETCH C_Duplicate_Names INTO p_party_id;
424: IF (C_Duplicate_Names%NOTFOUND)
425: THEN
426: p_is_duplicate := FND_API.G_FALSE;
427: ELSE
428: p_is_duplicate := FND_API.G_TRUE;
429: END IF;
430: CLOSE C_Duplicate_Names;

Line 428: p_is_duplicate := FND_API.G_TRUE;

424: IF (C_Duplicate_Names%NOTFOUND)
425: THEN
426: p_is_duplicate := FND_API.G_FALSE;
427: ELSE
428: p_is_duplicate := FND_API.G_TRUE;
429: END IF;
430: CLOSE C_Duplicate_Names;
431:
432: ELSIF upper(p_key_search_flag) = FND_API.G_TRUE -- if the request is to use the keys then use match by key

Line 432: ELSIF upper(p_key_search_flag) = FND_API.G_TRUE -- if the request is to use the keys then use match by key

428: p_is_duplicate := FND_API.G_TRUE;
429: END IF;
430: CLOSE C_Duplicate_Names;
431:
432: ELSIF upper(p_key_search_flag) = FND_API.G_TRUE -- if the request is to use the keys then use match by key
433: THEN
434: OPEN C_Duplicate_Keys( p_party_key);
435: FETCH C_Duplicate_Keys INTO p_party_id;
436: IF (C_Duplicate_Keys%NOTFOUND)

Line 438: p_is_duplicate := FND_API.G_FALSE;

434: OPEN C_Duplicate_Keys( p_party_key);
435: FETCH C_Duplicate_Keys INTO p_party_id;
436: IF (C_Duplicate_Keys%NOTFOUND)
437: THEN
438: p_is_duplicate := FND_API.G_FALSE;
439: ELSE
440: p_is_duplicate := FND_API.G_TRUE;
441: END IF;
442: CLOSE C_Duplicate_Keys;

Line 440: p_is_duplicate := FND_API.G_TRUE;

436: IF (C_Duplicate_Keys%NOTFOUND)
437: THEN
438: p_is_duplicate := FND_API.G_FALSE;
439: ELSE
440: p_is_duplicate := FND_API.G_TRUE;
441: END IF;
442: CLOSE C_Duplicate_Keys;
443:
444: END IF;

Line 448: p_is_duplicate := FND_API.G_FALSE;

444: END IF;
445:
446: EXCEPTION
447: WHEN OTHERS THEN
448: p_is_duplicate := FND_API.G_FALSE;
449:
450: END Find_Duplicate_Party;
451:
452:

Line 491: p_key_search_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE,

487:
488: PROCEDURE Find_Duplicate_Address (
489: p_address_rec IN HZ_LOCATION_V2PUB.LOCATION_REC_TYPE,
490: p_address_key IN VARCHAR2,
491: p_key_search_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE,
492: p_location_id OUT NOCOPY NUMBER,
493: p_is_duplicate OUT NOCOPY VARCHAR2)
494: IS
495: CURSOR C_Duplicate_Keys (X_Address_Key VARCHAR2) IS

Line 522: IF upper(p_key_search_flag) = FND_API.G_FALSE

518: '#-_.,/\', ' ') ,' ' ) );
519:
520: BEGIN
521: -- if the request is not to use the keys then use match by address fields
522: IF upper(p_key_search_flag) = FND_API.G_FALSE
523: THEN
524: OPEN C_Duplicate_Address (rtrim(p_address_rec.Address1,FND_API.G_MISS_CHAR),
525: rtrim(p_address_rec.Address2,FND_API.G_MISS_CHAR),
526: rtrim(p_address_rec.Address3,FND_API.G_MISS_CHAR),

Line 524: OPEN C_Duplicate_Address (rtrim(p_address_rec.Address1,FND_API.G_MISS_CHAR),

520: BEGIN
521: -- if the request is not to use the keys then use match by address fields
522: IF upper(p_key_search_flag) = FND_API.G_FALSE
523: THEN
524: OPEN C_Duplicate_Address (rtrim(p_address_rec.Address1,FND_API.G_MISS_CHAR),
525: rtrim(p_address_rec.Address2,FND_API.G_MISS_CHAR),
526: rtrim(p_address_rec.Address3,FND_API.G_MISS_CHAR),
527: rtrim(p_address_rec.Address4,FND_API.G_MISS_CHAR),
528: rtrim(p_address_rec.Postal_Code,FND_API.G_MISS_CHAR),

Line 525: rtrim(p_address_rec.Address2,FND_API.G_MISS_CHAR),

521: -- if the request is not to use the keys then use match by address fields
522: IF upper(p_key_search_flag) = FND_API.G_FALSE
523: THEN
524: OPEN C_Duplicate_Address (rtrim(p_address_rec.Address1,FND_API.G_MISS_CHAR),
525: rtrim(p_address_rec.Address2,FND_API.G_MISS_CHAR),
526: rtrim(p_address_rec.Address3,FND_API.G_MISS_CHAR),
527: rtrim(p_address_rec.Address4,FND_API.G_MISS_CHAR),
528: rtrim(p_address_rec.Postal_Code,FND_API.G_MISS_CHAR),
529: rtrim(p_address_rec.State,FND_API.G_MISS_CHAR),

Line 526: rtrim(p_address_rec.Address3,FND_API.G_MISS_CHAR),

522: IF upper(p_key_search_flag) = FND_API.G_FALSE
523: THEN
524: OPEN C_Duplicate_Address (rtrim(p_address_rec.Address1,FND_API.G_MISS_CHAR),
525: rtrim(p_address_rec.Address2,FND_API.G_MISS_CHAR),
526: rtrim(p_address_rec.Address3,FND_API.G_MISS_CHAR),
527: rtrim(p_address_rec.Address4,FND_API.G_MISS_CHAR),
528: rtrim(p_address_rec.Postal_Code,FND_API.G_MISS_CHAR),
529: rtrim(p_address_rec.State,FND_API.G_MISS_CHAR),
530: rtrim(p_address_rec.City,FND_API.G_MISS_CHAR),

Line 527: rtrim(p_address_rec.Address4,FND_API.G_MISS_CHAR),

523: THEN
524: OPEN C_Duplicate_Address (rtrim(p_address_rec.Address1,FND_API.G_MISS_CHAR),
525: rtrim(p_address_rec.Address2,FND_API.G_MISS_CHAR),
526: rtrim(p_address_rec.Address3,FND_API.G_MISS_CHAR),
527: rtrim(p_address_rec.Address4,FND_API.G_MISS_CHAR),
528: rtrim(p_address_rec.Postal_Code,FND_API.G_MISS_CHAR),
529: rtrim(p_address_rec.State,FND_API.G_MISS_CHAR),
530: rtrim(p_address_rec.City,FND_API.G_MISS_CHAR),
531: rtrim(p_address_rec.Country,FND_API.G_MISS_CHAR));

Line 528: rtrim(p_address_rec.Postal_Code,FND_API.G_MISS_CHAR),

524: OPEN C_Duplicate_Address (rtrim(p_address_rec.Address1,FND_API.G_MISS_CHAR),
525: rtrim(p_address_rec.Address2,FND_API.G_MISS_CHAR),
526: rtrim(p_address_rec.Address3,FND_API.G_MISS_CHAR),
527: rtrim(p_address_rec.Address4,FND_API.G_MISS_CHAR),
528: rtrim(p_address_rec.Postal_Code,FND_API.G_MISS_CHAR),
529: rtrim(p_address_rec.State,FND_API.G_MISS_CHAR),
530: rtrim(p_address_rec.City,FND_API.G_MISS_CHAR),
531: rtrim(p_address_rec.Country,FND_API.G_MISS_CHAR));
532: FETCH C_Duplicate_Address into p_location_id;

Line 529: rtrim(p_address_rec.State,FND_API.G_MISS_CHAR),

525: rtrim(p_address_rec.Address2,FND_API.G_MISS_CHAR),
526: rtrim(p_address_rec.Address3,FND_API.G_MISS_CHAR),
527: rtrim(p_address_rec.Address4,FND_API.G_MISS_CHAR),
528: rtrim(p_address_rec.Postal_Code,FND_API.G_MISS_CHAR),
529: rtrim(p_address_rec.State,FND_API.G_MISS_CHAR),
530: rtrim(p_address_rec.City,FND_API.G_MISS_CHAR),
531: rtrim(p_address_rec.Country,FND_API.G_MISS_CHAR));
532: FETCH C_Duplicate_Address into p_location_id;
533: IF (C_Duplicate_Address%NOTFOUND)

Line 530: rtrim(p_address_rec.City,FND_API.G_MISS_CHAR),

526: rtrim(p_address_rec.Address3,FND_API.G_MISS_CHAR),
527: rtrim(p_address_rec.Address4,FND_API.G_MISS_CHAR),
528: rtrim(p_address_rec.Postal_Code,FND_API.G_MISS_CHAR),
529: rtrim(p_address_rec.State,FND_API.G_MISS_CHAR),
530: rtrim(p_address_rec.City,FND_API.G_MISS_CHAR),
531: rtrim(p_address_rec.Country,FND_API.G_MISS_CHAR));
532: FETCH C_Duplicate_Address into p_location_id;
533: IF (C_Duplicate_Address%NOTFOUND)
534: THEN

Line 531: rtrim(p_address_rec.Country,FND_API.G_MISS_CHAR));

527: rtrim(p_address_rec.Address4,FND_API.G_MISS_CHAR),
528: rtrim(p_address_rec.Postal_Code,FND_API.G_MISS_CHAR),
529: rtrim(p_address_rec.State,FND_API.G_MISS_CHAR),
530: rtrim(p_address_rec.City,FND_API.G_MISS_CHAR),
531: rtrim(p_address_rec.Country,FND_API.G_MISS_CHAR));
532: FETCH C_Duplicate_Address into p_location_id;
533: IF (C_Duplicate_Address%NOTFOUND)
534: THEN
535: p_is_duplicate := FND_API.G_FALSE;

Line 535: p_is_duplicate := FND_API.G_FALSE;

531: rtrim(p_address_rec.Country,FND_API.G_MISS_CHAR));
532: FETCH C_Duplicate_Address into p_location_id;
533: IF (C_Duplicate_Address%NOTFOUND)
534: THEN
535: p_is_duplicate := FND_API.G_FALSE;
536: ELSE
537: p_is_duplicate := FND_API.G_TRUE;
538: END IF;
539: CLOSE C_Duplicate_Address;

Line 537: p_is_duplicate := FND_API.G_TRUE;

533: IF (C_Duplicate_Address%NOTFOUND)
534: THEN
535: p_is_duplicate := FND_API.G_FALSE;
536: ELSE
537: p_is_duplicate := FND_API.G_TRUE;
538: END IF;
539: CLOSE C_Duplicate_Address;
540: ELSIF p_key_search_flag = FND_API.G_TRUE -- if the request is to use the keys then use match by address key
541: THEN

Line 540: ELSIF p_key_search_flag = FND_API.G_TRUE -- if the request is to use the keys then use match by address key

536: ELSE
537: p_is_duplicate := FND_API.G_TRUE;
538: END IF;
539: CLOSE C_Duplicate_Address;
540: ELSIF p_key_search_flag = FND_API.G_TRUE -- if the request is to use the keys then use match by address key
541: THEN
542: OPEN C_Duplicate_Keys (p_address_key);
543: FETCH C_Duplicate_Keys into p_location_id;
544: IF (C_Duplicate_Keys%NOTFOUND)

Line 546: p_is_duplicate := FND_API.G_FALSE;

542: OPEN C_Duplicate_Keys (p_address_key);
543: FETCH C_Duplicate_Keys into p_location_id;
544: IF (C_Duplicate_Keys%NOTFOUND)
545: THEN
546: p_is_duplicate := FND_API.G_FALSE;
547: ELSE
548: p_is_duplicate := FND_API.G_TRUE;
549: END IF;
550: CLOSE C_Duplicate_Keys;

Line 548: p_is_duplicate := FND_API.G_TRUE;

544: IF (C_Duplicate_Keys%NOTFOUND)
545: THEN
546: p_is_duplicate := FND_API.G_FALSE;
547: ELSE
548: p_is_duplicate := FND_API.G_TRUE;
549: END IF;
550: CLOSE C_Duplicate_Keys;
551: END IF;
552:

Line 555: p_is_duplicate := FND_API.G_FALSE;

551: END IF;
552:
553: EXCEPTION
554: WHEN OTHERS THEN
555: p_is_duplicate := FND_API.G_FALSE;
556:
557: END Find_Duplicate_Address;
558:
559:

Line 805: -- if FND_API.G_MISS_CHAR is passed for address word, then treat it as NULL

801: ELSE
802: l_address_word := l_address4;
803: END IF;
804:
805: -- if FND_API.G_MISS_CHAR is passed for address word, then treat it as NULL
806: if l_address_word = FND_API.G_MISS_CHAR then
807: l_address_word := NULL;
808: end if;
809:

Line 806: if l_address_word = FND_API.G_MISS_CHAR then

802: l_address_word := l_address4;
803: END IF;
804:
805: -- if FND_API.G_MISS_CHAR is passed for address word, then treat it as NULL
806: if l_address_word = FND_API.G_MISS_CHAR then
807: l_address_word := NULL;
808: end if;
809:
810: -- Generate the address line portion of the key

Line 824: -- if FND_API.G_MISS_CHAR has been passed for postal code, that should be treated as NULL

820: --
821: l_word_length := to_number(NVL(FND_PROFILE.Value('HZ_POSTAL_CODE_KEY_LENGTH'), lengthb(l_postal_code) ));
822: l_postal_word := substrb(l_postal_code, 1, l_word_length);
823:
824: -- if FND_API.G_MISS_CHAR has been passed for postal code, that should be treated as NULL
825: if l_postal_word = FND_API.G_MISS_CHAR then
826: l_postal_word := NULL;
827: end if;
828:

Line 825: if l_postal_word = FND_API.G_MISS_CHAR then

821: l_word_length := to_number(NVL(FND_PROFILE.Value('HZ_POSTAL_CODE_KEY_LENGTH'), lengthb(l_postal_code) ));
822: l_postal_word := substrb(l_postal_code, 1, l_word_length);
823:
824: -- if FND_API.G_MISS_CHAR has been passed for postal code, that should be treated as NULL
825: if l_postal_word = FND_API.G_MISS_CHAR then
826: l_postal_word := NULL;
827: end if;
828:
829: -- Generate the postal code portion of key

Line 849: -- if FND_API.G_MISS_CHAR has been passed for first name or last name,

845:
846: -- for key type 'PERSON'
847: ELSIF l_key_type = 'PERSON'
848: THEN
849: -- if FND_API.G_MISS_CHAR has been passed for first name or last name,
850: -- then those should be treated as NULL
851: if l_first_name = FND_API.G_MISS_CHAR then
852: l_first_name := NULL;
853: end if;

Line 851: if l_first_name = FND_API.G_MISS_CHAR then

847: ELSIF l_key_type = 'PERSON'
848: THEN
849: -- if FND_API.G_MISS_CHAR has been passed for first name or last name,
850: -- then those should be treated as NULL
851: if l_first_name = FND_API.G_MISS_CHAR then
852: l_first_name := NULL;
853: end if;
854:
855: if l_last_name = FND_API.G_MISS_CHAR then

Line 855: if l_last_name = FND_API.G_MISS_CHAR then

851: if l_first_name = FND_API.G_MISS_CHAR then
852: l_first_name := NULL;
853: end if;
854:
855: if l_last_name = FND_API.G_MISS_CHAR then
856: l_last_name := NULL;
857: end if;
858:
859: -- Generate the person key.

Line 1191: | duplicate record, it sets p_duplicate to fnd_api.g_true. Also a |

1187: | |
1188: | DESCRIPTION |
1189: | Public procedure for checking if the passed party information |
1190: | is a duplicate of an existing party. If program finds that it is a |
1191: | duplicate record, it sets p_duplicate to fnd_api.g_true. Also a |
1192: | message is set and one matching party_id is returned. |
1193: | |
1194: | SCOPE - Public |
1195: | |

Line 1223: p_key_search_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE,

1219: p_party_type IN VARCHAR2,
1220: p_person_first_name IN VARCHAR2 DEFAULT NULL,
1221: p_person_last_name IN VARCHAR2 DEFAULT NULL,
1222: p_party_name IN VARCHAR2 DEFAULT NULL,
1223: p_key_search_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE,
1224: p_duplicate OUT NOCOPY VARCHAR2,
1225: p_msg_count OUT NOCOPY NUMBER,
1226: p_msg_data OUT NOCOPY VARCHAR2,
1227: p_party_id OUT NOCOPY NUMBER

Line 1238: p_duplicate := fnd_api.g_false;

1234: l_object_name hz_parties.party_name%TYPE;
1235: l_is_duplicate varchar2(10);
1236:
1237: begin
1238: p_duplicate := fnd_api.g_false;
1239:
1240: IF p_party_type = 'PERSON'
1241: THEN
1242: -- generate the party key for person (necessary for duplicate checking)

Line 1277: if fnd_api.to_boolean (l_is_duplicate)

1273: END IF;
1274:
1275: p_duplicate := l_is_duplicate;
1276:
1277: if fnd_api.to_boolean (l_is_duplicate)
1278: then
1279: p_party_id := l_party_id;
1280: p_duplicate := fnd_api.g_true;
1281:

Line 1280: p_duplicate := fnd_api.g_true;

1276:
1277: if fnd_api.to_boolean (l_is_duplicate)
1278: then
1279: p_party_id := l_party_id;
1280: p_duplicate := fnd_api.g_true;
1281:
1282: fnd_message.set_name ('AR', 'HZ_MATCHING_PARTY_EXISTS');
1283: fnd_msg_pub.add;
1284: end if;

Line 1296: | found, p_duplicate is set to fnd_api.g_true and a message is also set |

1292: | |
1293: | DESCRIPTION |
1294: | Public procedure for checking if the passed location information |
1295: | is a duplicate of an existing location.If a duplicate location is |
1296: | found, p_duplicate is set to fnd_api.g_true and a message is also set |
1297: | stating that. p_key_search_flag determines whether to do a key match |
1298: | or exact match. |
1299: | |
1300: | SCOPE - Public |

Line 1338: p_key_search_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE,

1334: p_postal_code IN VARCHAR2 DEFAULT NULL,
1335: p_state IN VARCHAR2 DEFAULT NULL,
1336: p_city IN VARCHAR2 DEFAULT NULL,
1337: p_country IN VARCHAR2 DEFAULT NULL,
1338: p_key_search_flag IN VARCHAR2 DEFAULT FND_API.G_TRUE,
1339: p_duplicate OUT NOCOPY VARCHAR2,
1340: p_msg_count OUT NOCOPY NUMBER,
1341: p_msg_data OUT NOCOPY VARCHAR2,
1342: p_location_id OUT NOCOPY NUMBER) IS

Line 1350: p_duplicate := fnd_api.g_false;

1346: l_location_id NUMBER;
1347: l_is_duplicate VARCHAR2(10);
1348:
1349: begin
1350: p_duplicate := fnd_api.g_false;
1351:
1352: -- generate the address key (necessary for duplicate checking)
1353: l_address_key := Generate_Key('ADDRESS',
1354: p_address1,

Line 1378: if fnd_api.to_boolean (l_is_duplicate)

1374: p_is_duplicate => l_is_duplicate);
1375:
1376: p_duplicate := l_is_duplicate;
1377:
1378: if fnd_api.to_boolean (l_is_duplicate)
1379: then
1380: p_location_id := l_location_id;
1381: p_duplicate := fnd_api.g_true;
1382:

Line 1381: p_duplicate := fnd_api.g_true;

1377:
1378: if fnd_api.to_boolean (l_is_duplicate)
1379: then
1380: p_location_id := l_location_id;
1381: p_duplicate := fnd_api.g_true;
1382:
1383: fnd_message.set_name ('AR', 'MATCHING_LOCATION_EXISTS');
1384: fnd_msg_pub.add;
1385: end if;