DBA Data[Home] [Help]

APPS.HZP_CPROF_PKG dependencies on FND_MSG_PUB

Line 432: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

428: );
429:
430: IF x_msg_count > 1 THEN
431: FOR i IN 1..x_msg_count LOOP
432: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
433: tmp_var1 := tmp_var1 || ' '|| tmp_var;
434: END LOOP;
435: x_msg_data := tmp_var1;
436: END IF;

Line 562: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

558:
559: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
560: IF x_msg_count > 1 THEN
561: FOR i IN 1..x_msg_count LOOP
562: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
563: tmp_var1 := tmp_var1 || ' '|| tmp_var;
564: END LOOP;
565: x_msg_data := tmp_var1;
566: END IF;

Line 702: FND_MSG_PUB.ADD;

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,
706: p_count => x_msg_count,

Line 704: FND_MSG_PUB.Count_And_Get(

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,
706: p_count => x_msg_count,
707: p_data => x_msg_data );
708:

Line 711: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

707: p_data => x_msg_data );
708:
709: IF x_msg_count > 1 THEN
710: FOR i IN 1..x_msg_count LOOP
711: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
712: tmp_var1 := tmp_var1 || ' '|| tmp_var;
713: END LOOP;
714: x_msg_data := SUBSTRB(tmp_var1,1,2000);
715: END IF;

Line 842: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

838: x_msg_data => x_msg_data );
839:
840: IF x_msg_count > 1 THEN
841: FOR i IN 1..x_msg_count LOOP
842: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
843: tmp_var1 := tmp_var1 || ' '|| tmp_var;
844: END LOOP;
845: x_msg_data := tmp_var1;
846: END IF;

Line 1393: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1389: END LOOP;
1390:
1391: IF x_msg_count > 1 THEN
1392: FOR i IN 1..x_msg_count LOOP
1393: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1394: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1395: END LOOP;
1396: x_msg_data := tmp_var1;
1397: END IF;

Line 1924: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1920:
1921:
1922: IF x_msg_count > 1 THEN
1923: FOR i IN 1..x_msg_count LOOP
1924: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1925: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1926: END LOOP;
1927: x_msg_data := tmp_var1;
1928: END IF;

Line 2116: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2112:
2113: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2114: IF x_msg_count > 1 THEN
2115: FOR i IN 1..x_msg_count LOOP
2116: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2117: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2118: END LOOP;
2119: x_msg_data := tmp_var1;
2120: END IF;

Line 2130: FND_MSG_PUB.ADD;

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,
2134: p_data => x_msg_data );

Line 2131: FND_MSG_PUB.Count_And_Get(

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,
2134: p_data => x_msg_data );
2135: arp_standard.debug('EXCEPTION: hzp_cprof_pkg.delete_profile_amout'||x_msg_data);

Line 2336: FND_MSG_PUB.ADD;

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:
2340: CLOSE cu_version_prof_amt;

Line 2365: fnd_msg_pub.count_and_get(

2361: arp_standard.debug('update_profile_amount (-)');
2362: EXCEPTION
2363: WHEN l_exception THEN
2364: x_return_status := FND_API.G_RET_STS_ERROR;
2365: fnd_msg_pub.count_and_get(
2366: p_encoded => fnd_api.g_false,
2367: p_count => x_msg_count,
2368: p_data => x_msg_data);
2369: IF x_msg_count > 1 THEN

Line 2371: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2367: p_count => x_msg_count,
2368: p_data => x_msg_data);
2369: IF x_msg_count > 1 THEN
2370: FOR i IN 1..x_msg_count LOOP
2371: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2372: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2373: END LOOP;
2374: x_msg_data := tmp_var1;
2375: END IF;

Line 2381: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

2377:
2378: WHEN tca_Exception THEN
2379: IF x_msg_count > 1 THEN
2380: FOR i IN 1..x_msg_count LOOP
2381: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2382: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2383: END LOOP;
2384: x_msg_data := tmp_var1;
2385: END IF;

Line 2392: FND_MSG_PUB.ADD;

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,
2396: p_data => x_msg_data );

Line 2393: FND_MSG_PUB.Count_And_Get(

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,
2396: p_data => x_msg_data );
2397: arp_standard.debug('EXCEPTION OTHERS: hzp_cprof_pkg.update_profile_amout'||x_msg_data);

Line 2438: FND_MSG_PUB.ADD;

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,
2442: p_data => x_msg_data );

Line 2439: FND_MSG_PUB.Count_And_Get(

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,
2442: p_data => x_msg_data );
2443: arp_standard.debug('EXCEPTION NO_DATA_FOUND: hzp_cprof_pkg.delete_profile_amout');

Line 2449: FND_MSG_PUB.ADD;

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,
2453: p_data => x_msg_data );

Line 2450: FND_MSG_PUB.Count_And_Get(

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,
2453: p_data => x_msg_data );
2454: arp_standard.debug('EXCEPTION OTHERS: hzp_cprof_pkg.delete_profile_amout'||x_msg_data);