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.HZP_CPROF_PKG dependencies on FND_API

Line 14: res_date := FND_API.G_MISS_DATE;

10: res_date date;
11: BEGIN
12: IF p_switch = 'NULL_GMISS' THEN
13: IF p_date IS NULL THEN
14: res_date := FND_API.G_MISS_DATE;
15: ELSE
16: res_date := p_date;
17: END IF;
18: ELSIF p_switch = 'GMISS_NULL' THEN

Line 19: IF p_date = FND_API.G_MISS_DATE THEN

15: ELSE
16: res_date := p_date;
17: END IF;
18: ELSIF p_switch = 'GMISS_NULL' THEN
19: IF p_date = FND_API.G_MISS_DATE THEN
20: res_date := NULL;
21: ELSE
22: res_date := p_date;
23: END IF;

Line 39: return FND_API.G_MISS_CHAR;

35: res_char varchar2(2000);
36: BEGIN
37: IF p_switch = 'NULL_GMISS' THEN
38: IF p_char IS NULL THEN
39: return FND_API.G_MISS_CHAR;
40: ELSE
41: return p_char;
42: END IF;
43: ELSIF p_switch = 'GMISS_NULL' THEN

Line 44: IF p_char = FND_API.G_MISS_CHAR THEN

40: ELSE
41: return p_char;
42: END IF;
43: ELSIF p_switch = 'GMISS_NULL' THEN
44: IF p_char = FND_API.G_MISS_CHAR THEN
45: return NULL;
46: ELSE
47: return p_char;
48: END IF;

Line 62: return FND_API.G_MISS_NUM;

58: IS
59: BEGIN
60: IF p_switch = 'NULL_GMISS' THEN
61: IF p_num IS NULL THEN
62: return FND_API.G_MISS_NUM;
63: ELSE
64: return p_num;
65: END IF;
66: ELSIF p_switch = 'GMISS_NULL' THEN

Line 67: IF p_num = FND_API.G_MISS_NUM THEN

63: ELSE
64: return p_num;
65: END IF;
66: ELSIF p_switch = 'GMISS_NULL' THEN
67: IF p_num = FND_API.G_MISS_NUM THEN
68: return NULL;
69: ELSE
70: return p_num;
71: END IF;

Line 412: p_create_profile => fnd_api.g_true,

408: /* Commented for Bug No : 2134837
409: HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use (
410: p_cust_site_use_rec => suse_rec,
411: p_customer_profile_rec => prof_rec,
412: p_create_profile => fnd_api.g_true,
413: p_create_profile_amt => fnd_api.g_false,
414: x_site_use_id => i_site_use_id,
415: x_return_status => x_return_status,
416: x_msg_count => x_msg_count,

Line 413: p_create_profile_amt => fnd_api.g_false,

409: HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use (
410: p_cust_site_use_rec => suse_rec,
411: p_customer_profile_rec => prof_rec,
412: p_create_profile => fnd_api.g_true,
413: p_create_profile_amt => fnd_api.g_false,
414: x_site_use_id => i_site_use_id,
415: x_return_status => x_return_status,
416: x_msg_count => x_msg_count,
417: x_msg_data => x_msg_data

Line 423: p_create_profile_amt => fnd_api.g_false,

419: */
420: prof_rec.created_by_module := 'TCA_FORM_WRAPPER';
421: HZ_CUSTOMER_PROFILE_V2PUB.create_customer_profile (
422: p_customer_profile_rec => prof_rec,
423: p_create_profile_amt => fnd_api.g_false,
424: x_cust_account_profile_id => l_cust_account_profile_id,
425: x_return_status => x_return_status,
426: x_msg_count => x_msg_count,
427: x_msg_data => x_msg_data

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 438: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

434: END LOOP;
435: x_msg_data := tmp_var1;
436: END IF;
437:
438: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
439: return;
440: END IF;
441:
442: END Insert_Row;

Line 559: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

555: x_return_status => x_return_status,
556: x_msg_count => x_msg_count,
557: x_msg_data => x_msg_data );
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;

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 705: p_encoded => FND_API.G_FALSE,

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:
709: IF x_msg_count > 1 THEN

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 848: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

844: END LOOP;
845: x_msg_data := tmp_var1;
846: END IF;
847:
848: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
849: RAISE Exc_g;
850: END IF;
851:
852: EXCEPTION

Line 1363: p_check_foreign_key => FND_API.G_FALSE,

1359: EXIT WHEN c_prof_class_amts%NOTFOUND;
1360:
1361: prof_amt_rec.created_by_module := 'TCA_FORM_WRAPPER';
1362: HZ_CUSTOMER_PROFILE_V2PUB.create_cust_profile_amt (
1363: p_check_foreign_key => FND_API.G_FALSE,
1364: p_cust_profile_amt_rec => prof_amt_rec,
1365: x_cust_acct_profile_amt_id => x_cust_acct_profile_amt_id,
1366: x_return_status => x_return_status,
1367: x_msg_count => x_msg_count,

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 1890: p_check_foreign_key => FND_API.G_FALSE,

1886: EXIT WHEN c_prof_class_amts%NOTFOUND;
1887:
1888: prof_amt_rec.created_by_module := 'TCA_FORM_WRAPPER';
1889: HZ_CUSTOMER_PROFILE_V2PUB.create_cust_profile_amt (
1890: p_check_foreign_key => FND_API.G_FALSE,
1891: p_cust_profile_amt_rec => prof_amt_rec,
1892: x_cust_acct_profile_amt_id => x_cust_acct_profile_amt_id,
1893: x_return_status => x_return_status,
1894: x_msg_count => x_msg_count,

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 2032: x_return_status := FND_API.G_RET_STS_SUCCESS;

2028: i NUMBER;
2029: tmp_var1 VARCHAR2(2000);
2030: BEGIN
2031: arp_standard.debug('create_profile_amount (+)');
2032: x_return_status := FND_API.G_RET_STS_SUCCESS;
2033:
2034: l_rec.cust_acct_profile_amt_id := x_cust_acct_profile_amt_id;
2035: l_rec.cust_account_profile_id := p_cust_account_profile_id;
2036: l_rec.currency_code := p_currency_code;

Line 2113: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2109: x_return_status => x_return_status,
2110: x_msg_count => x_msg_count,
2111: x_msg_data => x_msg_data);
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;

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 2127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2123:
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(

Line 2132: p_encoded => FND_API.G_FALSE,

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);
2136: END;

Line 2250: x_return_status := FND_API.G_RET_STS_SUCCESS;

2246: arp_standard.debug('update_profile_amount (+)');
2247: arp_standard.debug('Object_version_number:'||p_object_version);
2248: arp_standard.debug('last_update_date:'||X_Last_Update_Date );
2249:
2250: x_return_status := FND_API.G_RET_STS_SUCCESS;
2251:
2252: l_rec.cust_acct_profile_amt_id := INIT_SWITCH(p_cust_acct_profile_amt_id);
2253: l_rec.cust_account_profile_id := INIT_SWITCH(p_cust_account_profile_id);
2254: l_rec.currency_code := INIT_SWITCH(p_currency_code);

Line 2346: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2342: END IF;
2343:
2344: arp_standard.debug('x_return_status :'||x_return_status);
2345:
2346: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2347:
2348: HZ_CUSTOMER_PROFILE_V2PUB.update_cust_profile_amt
2349: ( p_cust_profile_amt_rec => l_rec,
2350: p_object_version_number => l_object_version,

Line 2357: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2353: x_msg_data => x_msg_data);
2354:
2355: END IF;
2356:
2357: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2358: RAISE tca_exception;
2359: END IF;
2360:
2361: arp_standard.debug('update_profile_amount (-)');

Line 2364: x_return_status := FND_API.G_RET_STS_ERROR;

2360:
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);

Line 2366: p_encoded => fnd_api.g_false,

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
2370: FOR i IN 1..x_msg_count LOOP

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 2389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2385: END IF;
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(

Line 2394: p_encoded => FND_API.G_FALSE,

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);
2398: END;

Line 2422: x_return_status := FND_API.G_RET_STS_SUCCESS;

2418: IS
2419: BEGIN
2420: arp_standard.debug('delete_profile_amount(+)');
2421:
2422: x_return_status := FND_API.G_RET_STS_SUCCESS;
2423:
2424: DELETE FROM hz_cust_profile_amts
2425: WHERE cust_acct_profile_amt_id = p_cust_acct_profile_amt_id;
2426:

Line 2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2431: arp_standard.debug('delete_profile_amount(-)');
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(

Line 2440: p_encoded => FND_API.G_FALSE,

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');
2444:

Line 2446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2451: p_encoded => FND_API.G_FALSE,

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);
2455: END;