DBA Data[Home] [Help]

APPS.HZP_CPROF_PKG dependencies on FND_MESSAGE

Line 108: fnd_message.set_name('AR','AR_CUST_ONE_PROFILE_ALLOWED');

104: and su.site_use_code in ('BILL_TO','DUN','STMTS') ;
105: --
106: END IF;
107: IF ( l_profile_count >= 1 ) THEN
108: fnd_message.set_name('AR','AR_CUST_ONE_PROFILE_ALLOWED');
109: app_exception.raise_exception;
110: END IF;
111: --
112: --

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

695: FROM HZ_CUSTOMER_PROFILES
696: WHERE ROWID = X_rowid;
697:
698: IF (SQL%NOTFOUND) THEN
699: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
700: FND_MESSAGE.SET_TOKEN('RECORD','HZ_CUSTOMER_PROFILES');
701: FND_MESSAGE.SET_TOKEN('ID',X_Customer_Profile_Id);
702: FND_MSG_PUB.ADD;
703:

Line 700: FND_MESSAGE.SET_TOKEN('RECORD','HZ_CUSTOMER_PROFILES');

696: WHERE ROWID = X_rowid;
697:
698: IF (SQL%NOTFOUND) THEN
699: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
700: FND_MESSAGE.SET_TOKEN('RECORD','HZ_CUSTOMER_PROFILES');
701: FND_MESSAGE.SET_TOKEN('ID',X_Customer_Profile_Id);
702: FND_MSG_PUB.ADD;
703:
704: FND_MSG_PUB.Count_And_Get(

Line 701: FND_MESSAGE.SET_TOKEN('ID',X_Customer_Profile_Id);

697:
698: IF (SQL%NOTFOUND) THEN
699: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
700: FND_MESSAGE.SET_TOKEN('RECORD','HZ_CUSTOMER_PROFILES');
701: FND_MESSAGE.SET_TOKEN('ID',X_Customer_Profile_Id);
702: FND_MSG_PUB.ADD;
703:
704: FND_MSG_PUB.Count_And_Get(
705: p_encoded => FND_API.G_FALSE,

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

2124: arp_standard.debug('create_profile_amount(-)');
2125: EXCEPTION
2126: WHEN OTHERS THEN
2127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2128: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2129: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2130: FND_MSG_PUB.ADD;
2131: FND_MSG_PUB.Count_And_Get(
2132: p_encoded => FND_API.G_FALSE,

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

2125: EXCEPTION
2126: WHEN OTHERS THEN
2127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2128: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2129: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2130: FND_MSG_PUB.ADD;
2131: FND_MSG_PUB.Count_And_Get(
2132: p_encoded => FND_API.G_FALSE,
2133: p_count => x_msg_count,

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

2329: l_last_update_date;
2330: arp_standard.debug('Last_update_date:'||to_char(l_last_update_date));
2331:
2332: IF cu_version_prof_amt%NOTFOUND THEN
2333: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
2334: FND_MESSAGE.SET_TOKEN('RECORD','HZ_CUST_PROFILE_AMTS');
2335: FND_MESSAGE.SET_TOKEN('ID',p_cust_acct_profile_amt_id);
2336: FND_MSG_PUB.ADD;
2337: RAISE l_exception;

Line 2334: FND_MESSAGE.SET_TOKEN('RECORD','HZ_CUST_PROFILE_AMTS');

2330: arp_standard.debug('Last_update_date:'||to_char(l_last_update_date));
2331:
2332: IF cu_version_prof_amt%NOTFOUND THEN
2333: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
2334: FND_MESSAGE.SET_TOKEN('RECORD','HZ_CUST_PROFILE_AMTS');
2335: FND_MESSAGE.SET_TOKEN('ID',p_cust_acct_profile_amt_id);
2336: FND_MSG_PUB.ADD;
2337: RAISE l_exception;
2338: END IF;

Line 2335: FND_MESSAGE.SET_TOKEN('ID',p_cust_acct_profile_amt_id);

2331:
2332: IF cu_version_prof_amt%NOTFOUND THEN
2333: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
2334: FND_MESSAGE.SET_TOKEN('RECORD','HZ_CUST_PROFILE_AMTS');
2335: FND_MESSAGE.SET_TOKEN('ID',p_cust_acct_profile_amt_id);
2336: FND_MSG_PUB.ADD;
2337: RAISE l_exception;
2338: END IF;
2339:

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

2386: arp_standard.debug('Exception hzp_cprof_pkg.update_profile_amount:'||x_msg_data);
2387:
2388: WHEN OTHERS THEN
2389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2390: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2391: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2392: FND_MSG_PUB.ADD;
2393: FND_MSG_PUB.Count_And_Get(
2394: p_encoded => FND_API.G_FALSE,

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

2387:
2388: WHEN OTHERS THEN
2389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2390: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2391: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2392: FND_MSG_PUB.ADD;
2393: FND_MSG_PUB.Count_And_Get(
2394: p_encoded => FND_API.G_FALSE,
2395: p_count => x_msg_count,

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

2432:
2433: EXCEPTION
2434: WHEN NO_DATA_FOUND THEN
2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2436: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2437: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2438: FND_MSG_PUB.ADD;
2439: FND_MSG_PUB.Count_And_Get(
2440: p_encoded => FND_API.G_FALSE,

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

2433: EXCEPTION
2434: WHEN NO_DATA_FOUND THEN
2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2436: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2437: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2438: FND_MSG_PUB.ADD;
2439: FND_MSG_PUB.Count_And_Get(
2440: p_encoded => FND_API.G_FALSE,
2441: p_count => x_msg_count,

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

2443: arp_standard.debug('EXCEPTION NO_DATA_FOUND: hzp_cprof_pkg.delete_profile_amout');
2444:
2445: WHEN OTHERS THEN
2446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2447: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2448: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2449: FND_MSG_PUB.ADD;
2450: FND_MSG_PUB.Count_And_Get(
2451: p_encoded => FND_API.G_FALSE,

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

2444:
2445: WHEN OTHERS THEN
2446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2447: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2448: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2449: FND_MSG_PUB.ADD;
2450: FND_MSG_PUB.Count_And_Get(
2451: p_encoded => FND_API.G_FALSE,
2452: p_count => x_msg_count,