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

Line 38: res_date := FND_API.G_MISS_DATE;

34: res_date date;
35: BEGIN
36: IF p_switch = 'NULL_GMISS' THEN
37: IF p_date IS NULL THEN
38: res_date := FND_API.G_MISS_DATE;
39: ELSE
40: res_date := p_date;
41: END IF;
42: ELSIF p_switch = 'GMISS_NULL' THEN

Line 43: IF p_date = FND_API.G_MISS_DATE THEN

39: ELSE
40: res_date := p_date;
41: END IF;
42: ELSIF p_switch = 'GMISS_NULL' THEN
43: IF p_date = FND_API.G_MISS_DATE THEN
44: res_date := NULL;
45: ELSE
46: res_date := p_date;
47: END IF;

Line 63: return FND_API.G_MISS_CHAR;

59: res_char varchar2(2000);
60: BEGIN
61: IF p_switch = 'NULL_GMISS' THEN
62: IF p_char IS NULL THEN
63: return FND_API.G_MISS_CHAR;
64: ELSE
65: return p_char;
66: END IF;
67: ELSIF p_switch = 'GMISS_NULL' THEN

Line 68: IF p_char = FND_API.G_MISS_CHAR THEN

64: ELSE
65: return p_char;
66: END IF;
67: ELSIF p_switch = 'GMISS_NULL' THEN
68: IF p_char = FND_API.G_MISS_CHAR THEN
69: return NULL;
70: ELSE
71: return p_char;
72: END IF;

Line 86: return FND_API.G_MISS_NUM;

82: IS
83: BEGIN
84: IF p_switch = 'NULL_GMISS' THEN
85: IF p_num IS NULL THEN
86: return FND_API.G_MISS_NUM;
87: ELSE
88: return p_num;
89: END IF;
90: ELSIF p_switch = 'GMISS_NULL' THEN

Line 91: IF p_num = FND_API.G_MISS_NUM THEN

87: ELSE
88: return p_num;
89: END IF;
90: ELSIF p_switch = 'GMISS_NULL' THEN
91: IF p_num = FND_API.G_MISS_NUM THEN
92: return NULL;
93: ELSE
94: return p_num;
95: END IF;

Line 454: x_return_status := FND_API.G_RET_STS_ERROR;

450: end if;
451: --
452: --app_exception.raise_exception;
453: FND_MSG_PUB.ADD;
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: x_msg_count := 1;
456: return;
457: end if;
458: --

Line 475: x_return_status := FND_API.G_RET_STS_ERROR;

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;
477: x_msg_data := 'AR_CUST_ONE_ACTIVE_BS_PER_ADDR';
478: return;
479:

Line 621: x_return_status := FND_API.G_RET_STS_ERROR;

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;
623: x_msg_data := 'AR_CUST_DUP_CODE_LOCATION';
624: return;
625: END IF;

Line 820: IF X_SITE_USE_CODE <> FND_API.G_MISS_CHAR AND X_SITE_USE_CODE IS NOT NULL THEN

816:
817: BEGIN
818:
819:
820: IF X_SITE_USE_CODE <> FND_API.G_MISS_CHAR AND X_SITE_USE_CODE IS NOT NULL THEN
821:
822:
823: x_return_status := FND_API.G_RET_STS_SUCCESS;
824:

Line 823: x_return_status := FND_API.G_RET_STS_SUCCESS;

819:
820: IF X_SITE_USE_CODE <> FND_API.G_MISS_CHAR AND X_SITE_USE_CODE IS NOT NULL THEN
821:
822:
823: x_return_status := FND_API.G_RET_STS_SUCCESS;
824:
825:
826: select hz_cust_site_uses_s.nextval into x_site_use_id from dual;
827: --

Line 849: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

845: x_return_status => x_return_status,
846: x_msg_count => x_msg_count,
847: x_msg_data => x_msg_data
848: );
849: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
850: return;
851: end if;
852: end if;
853: --

Line 864: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

860: x_return_status => x_return_status,
861: x_msg_count => x_msg_count,
862: x_msg_data => x_msg_data
863: );
864: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
865: return;
866: end if;
867: --
868: --

Line 894: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

890: x_return_status => x_return_status,
891: x_msg_count => x_msg_count,
892: x_msg_data => x_msg_data
893: );
894: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
895: return;
896: END IF;
897: end if;
898:

Line 1001: p_create_profile => fnd_api.g_false,

997:
998: HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use (
999: p_cust_site_use_rec => suse_rec,
1000: p_customer_profile_rec => profile_rec,
1001: p_create_profile => fnd_api.g_false,
1002: p_create_profile_amt => fnd_api.g_false,
1003: x_site_use_id => x_site_use_id,
1004: x_return_status => x_return_status,
1005: x_msg_count => x_msg_count,

Line 1002: p_create_profile_amt => fnd_api.g_false,

998: HZ_CUST_ACCOUNT_SITE_V2PUB.create_cust_site_use (
999: p_cust_site_use_rec => suse_rec,
1000: p_customer_profile_rec => profile_rec,
1001: p_create_profile => fnd_api.g_false,
1002: p_create_profile_amt => fnd_api.g_false,
1003: x_site_use_id => x_site_use_id,
1004: x_return_status => x_return_status,
1005: x_msg_count => x_msg_count,
1006: x_msg_data => x_msg_data );

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

1006: x_msg_data => x_msg_data );
1007:
1008: IF x_msg_count > 1 THEN
1009: FOR i IN 1..x_msg_count LOOP
1010: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1011: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1012: END LOOP;
1013: x_msg_data := tmp_var1;
1014: END IF;

Line 1016: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1012: END LOOP;
1013: x_msg_data := tmp_var1;
1014: END IF;
1015:
1016: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1017: return;
1018: END IF;
1019:
1020: --

Line 1178: x_return_status := FND_API.G_RET_STS_SUCCESS;

1174: l_site_use_last_update_date DATE;
1175: --
1176: BEGIN
1177:
1178: x_return_status := FND_API.G_RET_STS_SUCCESS;
1179: --
1180: -- For Backward compatibility when Object Version Number is not entered
1181: --
1182: IF x_object_version = -1 THEN

Line 1193: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1196:
1197: IF TO_CHAR(X_Last_Update_Date,'DD-MON-YYYY HH:MI:SS') <>

Line 1203: x_return_status := FND_API.G_RET_STS_ERROR;

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
1206: l_site_object_version_number := x_object_version;
1207: END IF;

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

1209: --
1210: --
1211: IF x_msg_count > 1 THEN
1212: FOR i IN 1..x_msg_count LOOP
1213: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1214: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1215: END LOOP;
1216: x_msg_data := tmp_var1;
1217: END IF;

Line 1219: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1215: END LOOP;
1216: x_msg_data := tmp_var1;
1217: END IF;
1218:
1219: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1220: return;
1221: END IF;
1222: --
1223: --

Line 1335: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1331: x_return_status => x_return_status,
1332: x_msg_count => x_msg_count,
1333: x_msg_data => x_msg_data
1334: );
1335: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1336: return;
1337: end if;
1338: end if;
1339: --

Line 1349: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1345: x_return_status => x_return_status,
1346: x_msg_count => x_msg_count,
1347: x_msg_data => x_msg_data
1348: );
1349: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1350: return;
1351: end if;
1352: --
1353: --

Line 1378: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1374: x_return_status => x_return_status,
1375: x_msg_count => x_msg_count,
1376: x_msg_data => x_msg_data
1377: );
1378: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1379: return;
1380: END IF;
1381: --
1382: end if;

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

1393: );
1394:
1395: IF x_msg_count > 1 THEN
1396: FOR i IN 1..x_msg_count LOOP
1397: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1398: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1399: END LOOP;
1400: x_msg_data := tmp_var1;
1401: END IF;

Line 1403: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1399: END LOOP;
1400: x_msg_data := tmp_var1;
1401: END IF;
1402:
1403: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1404: return;
1405: END IF;
1406: --
1407: -- Backward compatibility