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

Line 13: res_date := FND_API.G_MISS_DATE;

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

Line 18: IF p_date = FND_API.G_MISS_DATE THEN

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

Line 38: return FND_API.G_MISS_CHAR;

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

Line 43: IF p_char = FND_API.G_MISS_CHAR THEN

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

Line 61: return FND_API.G_MISS_NUM;

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

Line 66: IF p_num = FND_API.G_MISS_NUM THEN

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

Line 143: x_return_status := FND_API.G_RET_STS_ERROR;

139: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
140: FND_MESSAGE.SET_TOKEN('RECORD',p_table_name);
141: FND_MESSAGE.SET_TOKEN('ID',p_col_id);
142: FND_MSG_PUB.ADD;
143: x_return_status := FND_API.G_RET_STS_ERROR;
144: ELSE
145: IF TO_CHAR(x_last_update_date,'DD-MON-YYYY HH:MI:SS') <>
146: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
147: THEN

Line 151: x_return_status := FND_API.G_RET_STS_ERROR;

147: THEN
148: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
149: FND_MESSAGE.SET_TOKEN('TABLE', p_table_name);
150: FND_MSG_PUB.ADD;
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: END IF;
153: END IF;
154: END;
155:

Line 192: x_return_status := FND_API.G_RET_STS_ERROR;

188: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
189: FND_MESSAGE.SET_TOKEN('RECORD','HZ_PARTIES');
190: FND_MESSAGE.SET_TOKEN('ID',p_party_id);
191: FND_MSG_PUB.ADD;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: END IF;
194: CLOSE cu_party_update;
195: EXCEPTION
196: WHEN OTHERS THEN

Line 203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

199: END IF;
200: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
201: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
202: FND_MSG_PUB.ADD;
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: END;
205:
206: PROCEDURE SetFlagRelationship
207: (p_rel_code IN VARCHAR2,

Line 361: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

357: x_return_status => x_return_status,
358: x_msg_count => x_msg_count,
359: x_msg_data => x_msg_data );
360:
361: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
362: update_flag(
363: p_party_id => c_party_id,
364: p_flag_name => p_rel_code,
365: p_flag_value => C_flag,

Line 418: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

414: x_msg_count => x_msg_count,
415: x_msg_data => x_msg_data );
416:
417: -- Need to be commented on once HZ_RELATIONSHIP_V2PUB.update_relationship is fixed.
418: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
419: update_flag(
420: p_party_id => c_party_id,
421: p_flag_name => p_rel_code,
422: p_flag_value => C_flag,

Line 748: o_duns_number_c IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR )

744: o_organization_profile_id IN OUT NOCOPY NUMBER,
745: x_msg_count OUT NOCOPY NUMBER,
746: x_msg_data OUT NOCOPY varchar2,
747: x_return_status OUT NOCOPY VARCHAR2,
748: o_duns_number_c IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR )
749:
750: IS
751:
752: -- acct_rec hz_customer_accounts_pub.account_rec_type;

Line 793: x_return_status := FND_API.G_RET_STS_SUCCESS;

789: X_PARTY_REL_LAST_UPDATE_DATE date;
790:
791: BEGIN
792:
793: x_return_status := FND_API.G_RET_STS_SUCCESS;
794:
795: /*Bug 3013045*/
796: IF c_party_id is not null
797: THEN

Line 1054: p_create_profile_amt => FND_API.G_FALSE,

1050: HZ_CUST_ACCOUNT_V2PUB.create_cust_account (
1051: p_cust_account_rec => acct_rec,
1052: p_organization_rec => org_rec,
1053: p_customer_profile_rec => prof_rec,
1054: p_create_profile_amt => FND_API.G_FALSE,
1055: x_cust_account_id => x_customer_id,
1056: x_account_number => x_cust_account_number,
1057: x_party_id => x_party_id,
1058: x_party_number => x_party_number,

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

1063:
1064:
1065: IF x_msg_count > 1 THEN
1066: FOR i IN 1..x_msg_count LOOP
1067: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1068: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1069: END LOOP;
1070: x_msg_data := tmp_var1;
1071: END IF;

Line 1073: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1069: END LOOP;
1070: x_msg_data := tmp_var1;
1071: END IF;
1072:
1073: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1074: return;
1075: END IF;
1076:
1077: c_cust_account_id := x_customer_id;

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

1096: x_msg_data => x_msg_data
1097: );
1098: IF x_msg_count > 1 THEN
1099: FOR i IN 1..x_msg_count LOOP
1100: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1101: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1102: END LOOP;
1103: x_msg_data := tmp_var1;
1104: END IF;

Line 1106: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1102: END LOOP;
1103: x_msg_data := tmp_var1;
1104: END IF;
1105:
1106: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1107: return;
1108: END IF;
1109:
1110: org_rec_update.party_rec.category_code := INIT_SWITCH(C_Category_Code);

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

1136: );
1137:
1138: IF x_msg_count > 1 THEN
1139: FOR i IN 1..x_msg_count LOOP
1140: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1141: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1142: END LOOP;
1143: x_msg_data := tmp_var1;
1144: END IF;

Line 1146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1142: END LOOP;
1143: x_msg_data := tmp_var1;
1144: END IF;
1145:
1146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1147: return;
1148: END IF;
1149:
1150: END IF;

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

1176:
1177:
1178: IF x_msg_count > 1 THEN
1179: FOR i IN 1..x_msg_count LOOP
1180: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1181: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1182: END LOOP;
1183: x_msg_data := tmp_var1;
1184: END IF;

Line 1469: x_return_status := FND_API.G_RET_STS_SUCCESS;

1465: l_dummy_id NUMBER;
1466:
1467: BEGIN
1468:
1469: x_return_status := FND_API.G_RET_STS_SUCCESS;
1470:
1471: /*Bug 3013045*/
1472:
1473: IF c_party_id is not null

Line 1718: p_create_profile_amt => FND_API.G_FALSE,

1714: HZ_CUST_ACCOUNT_V2PUB.create_cust_account (
1715: p_cust_account_rec => acct_rec,
1716: p_person_rec => person_rec,
1717: p_customer_profile_rec => prof_rec,
1718: p_create_profile_amt => FND_API.G_FALSE,
1719: x_cust_account_id => x_customer_id,
1720: x_account_number => x_cust_account_number,
1721: x_party_id => x_party_id,
1722: x_party_number => x_party_number,

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

1726: x_msg_data => x_msg_data );
1727:
1728: IF x_msg_count > 1 THEN
1729: FOR i IN 1..x_msg_count LOOP
1730: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1731: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1732: END LOOP;
1733: x_msg_data := tmp_var1;
1734: END IF;

Line 1736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1732: END LOOP;
1733: x_msg_data := tmp_var1;
1734: END IF;
1735:
1736: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1737: return;
1738: END IF;
1739:
1740: c_cust_account_id := x_customer_id;

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

1759: x_msg_data => x_msg_data
1760: );
1761: IF x_msg_count > 1 THEN
1762: FOR i IN 1..x_msg_count LOOP
1763: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1764: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1765: END LOOP;
1766: x_msg_data := tmp_var1;
1767: END IF;

Line 1769: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1765: END LOOP;
1766: x_msg_data := tmp_var1;
1767: END IF;
1768:
1769: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1770: return;
1771: END IF;
1772: person_rec_update.party_rec.party_id := INIT_SWITCH(C_Party_Id);
1773: person_rec_update.party_rec.category_code := INIT_SWITCH(C_Category_Code);

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

1790: x_msg_data => x_msg_data
1791: );
1792: IF x_msg_count > 1 THEN
1793: FOR i IN 1..x_msg_count LOOP
1794: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1795: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1796: END LOOP;
1797: x_msg_data := tmp_var1;
1798: END IF;

Line 1800: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1796: END LOOP;
1797: x_msg_data := tmp_var1;
1798: END IF;
1799:
1800: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1801: return;
1802: END IF;
1803: END IF;
1804:

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

1824: x_end_date => SYSDATE);
1825:
1826: IF x_msg_count > 1 THEN
1827: FOR i IN 1..x_msg_count LOOP
1828: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1829: tmp_var1 := tmp_var1 || ' '|| tmp_var;
1830: END LOOP;
1831: x_msg_data := tmp_var1;
1832: END IF;

Line 2051: c_duns_number_c IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

2047: o_person_profile_id in out NOCOPY number,
2048: x_msg_count OUT NOCOPY NUMBER,
2049: x_msg_data OUT NOCOPY varchar2,
2050: x_return_status OUT NOCOPY VARCHAR2,
2051: c_duns_number_c IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
2052: x_cust_acct_object_version IN NUMBER DEFAULT -1,
2053: x_cust_prof_object_version IN NUMBER DEFAULT -1,
2054: x_party_object_version IN NUMBER DEFAULT -1)
2055: IS

Line 2150: x_return_status := FND_API.G_RET_STS_SUCCESS;

2146: l_party_id NUMBER;
2147:
2148: BEGIN
2149:
2150: x_return_status := FND_API.G_RET_STS_SUCCESS;
2151:
2152: ---------------------------
2153: --{ Update Customer Account
2154: ---------------------------

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

2169: x_msg_data => x_msg_data
2170: );
2171: IF x_msg_count > 1 THEN
2172: FOR i IN 1..x_msg_count LOOP
2173: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2174: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2175: END LOOP;
2176: x_msg_data := tmp_var1;
2177: END IF;

Line 2179: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2175: END LOOP;
2176: x_msg_data := tmp_var1;
2177: END IF;
2178:
2179: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2180: return;
2181: END IF;
2182:
2183: END IF;

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

2275: );
2276:
2277: IF x_msg_count > 1 THEN
2278: FOR i IN 1..x_msg_count LOOP
2279: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2280: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2281: END LOOP;
2282: x_msg_data := tmp_var1;
2283: END IF;

Line 2285: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2281: END LOOP;
2282: x_msg_data := tmp_var1;
2283: END IF;
2284:
2285: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2286: return;
2287: END IF;
2288:
2289: SELECT last_update_date,

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

2314: x_msg_data => x_msg_data );
2315:
2316: IF x_msg_count > 1 THEN
2317: FOR i IN 1..x_msg_count LOOP
2318: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2319: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2320: END LOOP;
2321: x_msg_data := tmp_var1;
2322: END IF;

Line 2324: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2320: END LOOP;
2321: x_msg_data := tmp_var1;
2322: END IF;
2323:
2324: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2325: return;
2326: END IF;
2327:
2328: END IF;

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

2434: );
2435:
2436: IF x_msg_count > 1 THEN
2437: FOR i IN 1..x_msg_count LOOP
2438: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2439: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2440: END LOOP;
2441: x_msg_data := tmp_var1;
2442: END IF;

Line 2444: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2440: END LOOP;
2441: x_msg_data := tmp_var1;
2442: END IF;
2443:
2444: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2445: return;
2446: END IF;
2447:
2448: SELECT last_update_date INTO p_last_update_date

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

2468: x_msg_data => x_msg_data
2469: );
2470: IF x_msg_count > 1 THEN
2471: FOR i IN 1..x_msg_count LOOP
2472: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2473: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2474: END LOOP;
2475: x_msg_data := tmp_var1;
2476: END IF;

Line 2478: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2474: END LOOP;
2475: x_msg_data := tmp_var1;
2476: END IF;
2477:
2478: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2479: return;
2480: END IF;
2481:
2482: END IF;

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

2516: );
2517:
2518: IF x_msg_count > 1 THEN
2519: FOR i IN 1..x_msg_count LOOP
2520: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2521: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2522: END LOOP;
2523: x_msg_data := tmp_var1;
2524: END IF;

Line 2526: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2522: END LOOP;
2523: x_msg_data := tmp_var1;
2524: END IF;
2525:
2526: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2527: return;
2528: END IF;
2529:
2530:

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

2566: );
2567:
2568: IF x_msg_count > 1 THEN
2569: FOR i IN 1..x_msg_count LOOP
2570: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2571: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2572: END LOOP;
2573: x_msg_data := tmp_var1;
2574: END IF;

Line 2576: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2572: END LOOP;
2573: x_msg_data := tmp_var1;
2574: END IF;
2575:
2576: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2577: return;
2578: END IF;
2579:
2580:

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

2610: x_end_date => x_end_date );
2611:
2612: IF x_msg_count > 1 THEN
2613: FOR i IN 1..x_msg_count LOOP
2614: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
2615: tmp_var1 := tmp_var1 || ' '|| tmp_var;
2616: END LOOP;
2617: x_msg_data := tmp_var1;
2618: END IF;

Line 2620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2616: END LOOP;
2617: x_msg_data := tmp_var1;
2618: END IF;
2619:
2620: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2621: return;
2622: END IF;
2623:
2624: END IF;

Line 2842: c_duns_number_c IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

2838: o_person_profile_id in out NOCOPY number,
2839: x_msg_count OUT NOCOPY NUMBER,
2840: x_msg_data OUT NOCOPY varchar2,
2841: x_return_status OUT NOCOPY VARCHAR2,
2842: c_duns_number_c IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
2843: x_cust_acct_object_version IN NUMBER DEFAULT -1,
2844: x_cust_prof_object_version IN NUMBER DEFAULT -1,
2845: x_party_object_version IN NUMBER DEFAULT -1)
2846: IS