DBA Data[Home] [Help]

APPS.ARH_CSU_PKG dependencies on FND_MESSAGE

Line 354: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_DUN_SITE');

350: --
351: --
352: if (dummy >= 1 ) then
353: if (p_site_use_code = 'DUN' ) then
354: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_DUN_SITE');
355: elsif ( p_site_use_code = 'LEGAL' ) then
356: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_LEGAL_SITE');
357: elsif ( p_site_use_code = 'STMTS' ) then
358: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_STMTS_SITE');

Line 356: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_LEGAL_SITE');

352: if (dummy >= 1 ) then
353: if (p_site_use_code = 'DUN' ) then
354: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_DUN_SITE');
355: elsif ( p_site_use_code = 'LEGAL' ) then
356: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_LEGAL_SITE');
357: elsif ( p_site_use_code = 'STMTS' ) then
358: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_STMTS_SITE');
359: end if;
360: --

Line 358: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_STMTS_SITE');

354: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_DUN_SITE');
355: elsif ( p_site_use_code = 'LEGAL' ) then
356: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_LEGAL_SITE');
357: elsif ( p_site_use_code = 'STMTS' ) then
358: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_STMTS_SITE');
359: end if;
360: --
361: app_exception.raise_exception;
362: end if;

Line 377: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_BS_PER_ADDR');

373: and status = 'A'
374: and ( ( p_site_use_id is null ) or site_use_id <> p_site_use_id);
375: --
376: if (dummy >= 1) then
377: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_BS_PER_ADDR');
378: app_exception.raise_exception;
379: end if;
380: --
381: --

Line 442: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_DUN_SITE');

438: --
439: --
440: if (dummy >= 1 ) then
441: if (p_site_use_code = 'DUN' ) then
442: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_DUN_SITE');
443: x_msg_data := 'AR_CUST_ONE_ACTIVE_DUN_SITE';
444: elsif ( p_site_use_code = 'LEGAL' ) then
445: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_LEGAL_SITE');
446: x_msg_data := 'AR_CUST_ONE_ACTIVE_LEGAL_SITE';

Line 445: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_LEGAL_SITE');

441: if (p_site_use_code = 'DUN' ) then
442: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_DUN_SITE');
443: x_msg_data := 'AR_CUST_ONE_ACTIVE_DUN_SITE';
444: elsif ( p_site_use_code = 'LEGAL' ) then
445: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_LEGAL_SITE');
446: x_msg_data := 'AR_CUST_ONE_ACTIVE_LEGAL_SITE';
447: elsif ( p_site_use_code = 'STMTS' ) then
448: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_STMTS_SITE');
449: x_msg_data := 'AR_CUST_ONE_ACTIVE_STMTS_SITE';

Line 448: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_STMTS_SITE');

444: elsif ( p_site_use_code = 'LEGAL' ) then
445: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_LEGAL_SITE');
446: x_msg_data := 'AR_CUST_ONE_ACTIVE_LEGAL_SITE';
447: elsif ( p_site_use_code = 'STMTS' ) then
448: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_STMTS_SITE');
449: x_msg_data := 'AR_CUST_ONE_ACTIVE_STMTS_SITE';
450: end if;
451: --
452: --app_exception.raise_exception;

Line 472: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_BS_PER_ADDR');

468: and status = 'A'
469: and ( ( p_site_use_id is null ) or site_use_id <> p_site_use_id);
470: --
471: if (dummy >= 1) then
472: fnd_message.set_name('AR','AR_CUST_ONE_ACTIVE_BS_PER_ADDR');
473: --app_exception.raise_exception;
474: FND_MSG_PUB.ADD;
475: x_return_status := FND_API.G_RET_STS_ERROR;
476: x_msg_count := 1;

Line 545: fnd_message.set_name('AR','AR_CUST_DUP_CODE_LOCATION');

541: and su.STATUS = 'A'
542: and rownum = 1;
543: --
544: IF ( dummy >= 1 ) THEN
545: fnd_message.set_name('AR','AR_CUST_DUP_CODE_LOCATION');
546: app_exception.raise_exception;
547: END IF;
548:
549: EXCEPTION

Line 618: fnd_message.set_name('AR','AR_CUST_DUP_CODE_LOCATION');

614: and su.STATUS = 'A'
615: and rownum = 1;
616: --
617: IF ( dummy >= 1 ) THEN
618: fnd_message.set_name('AR','AR_CUST_DUP_CODE_LOCATION');
619: --app_exception.raise_exception;
620: FND_MSG_PUB.ADD;
621: x_return_status := FND_API.G_RET_STS_ERROR;
622: x_msg_count := 1;

Line 690: fnd_message.set_name('AR','AR_CUST_ONE_PRIMARY_SU');

686: from ar_lookups
687: where lookup_type = 'SITE_USE_CODE'
688: and lookup_code = p_site_use_code;
689: --
690: fnd_message.set_name('AR','AR_CUST_ONE_PRIMARY_SU');
691: fnd_message.set_token('SITE_CODE',l_site_use_meaning);
692: app_exception.raise_exception;
693: end if;
694: --

Line 691: fnd_message.set_token('SITE_CODE',l_site_use_meaning);

687: where lookup_type = 'SITE_USE_CODE'
688: and lookup_code = p_site_use_code;
689: --
690: fnd_message.set_name('AR','AR_CUST_ONE_PRIMARY_SU');
691: fnd_message.set_token('SITE_CODE',l_site_use_meaning);
692: app_exception.raise_exception;
693: end if;
694: --
695: end check_primary;

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

1185: l_site_use_rowid ,
1186: l_site_object_version_number,
1187: l_site_use_last_update_date ;
1188: IF cu_version%NOTFOUND THEN
1189: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
1190: FND_MESSAGE.SET_TOKEN('RECORD','hz_cust_site_uses');
1191: FND_MESSAGE.SET_TOKEN('ID',x_site_use_id);
1192: FND_MSG_PUB.ADD;
1193: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1190: FND_MESSAGE.SET_TOKEN('RECORD','hz_cust_site_uses');

1186: l_site_object_version_number,
1187: l_site_use_last_update_date ;
1188: IF cu_version%NOTFOUND THEN
1189: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
1190: FND_MESSAGE.SET_TOKEN('RECORD','hz_cust_site_uses');
1191: FND_MESSAGE.SET_TOKEN('ID',x_site_use_id);
1192: FND_MSG_PUB.ADD;
1193: x_return_status := FND_API.G_RET_STS_ERROR;
1194: END IF;

Line 1191: FND_MESSAGE.SET_TOKEN('ID',x_site_use_id);

1187: l_site_use_last_update_date ;
1188: IF cu_version%NOTFOUND THEN
1189: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
1190: FND_MESSAGE.SET_TOKEN('RECORD','hz_cust_site_uses');
1191: FND_MESSAGE.SET_TOKEN('ID',x_site_use_id);
1192: FND_MSG_PUB.ADD;
1193: x_return_status := FND_API.G_RET_STS_ERROR;
1194: END IF;
1195: CLOSE cu_version;

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

1196:
1197: IF TO_CHAR(X_Last_Update_Date,'DD-MON-YYYY HH:MI:SS') <>
1198: TO_CHAR(l_site_use_last_update_date,'DD-MON-YYYY HH:MI:SS')
1199: THEN
1200: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1201: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_cust_site_uses');
1202: FND_MSG_PUB.ADD;
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: END IF;

Line 1201: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_cust_site_uses');

1197: IF TO_CHAR(X_Last_Update_Date,'DD-MON-YYYY HH:MI:SS') <>
1198: TO_CHAR(l_site_use_last_update_date,'DD-MON-YYYY HH:MI:SS')
1199: THEN
1200: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1201: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_cust_site_uses');
1202: FND_MSG_PUB.ADD;
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: END IF;
1205: ELSE