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

Line 17: IF (NVL(p_number,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN

13: p_param_name IN VARCHAR2,
14: p_api_name IN VARCHAR2
15: ) IS
16: BEGIN
17: IF (NVL(p_number,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) THEN
18: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
19: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
20: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
21: FND_MSG_PUB.Add;

Line 22: RAISE FND_API.G_EXC_ERROR;

18: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
19: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
20: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
21: FND_MSG_PUB.Add;
22: RAISE FND_API.G_EXC_ERROR;
23: END IF;
24: END Check_Reqd_Param_num;
25:
26: /*-----------------------------------------------------------*/

Line 38: IF (NVL(p_variable,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN

34: p_param_name IN VARCHAR2,
35: p_api_name IN VARCHAR2
36: ) IS
37: BEGIN
38: IF (NVL(p_variable,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR) THEN
39: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
40: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
41: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
42: FND_MSG_PUB.Add;

Line 43: RAISE FND_API.G_EXC_ERROR;

39: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
40: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
41: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
42: FND_MSG_PUB.Add;
43: RAISE FND_API.G_EXC_ERROR;
44: END IF;
45: END Check_Reqd_Param_char;
46:
47: /*-----------------------------------------------------------*/

Line 59: IF (NVL(p_date,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN

55: p_param_name IN VARCHAR2,
56: p_api_name IN VARCHAR2
57: ) IS
58: BEGIN
59: IF (NVL(p_date,FND_API.G_MISS_DATE) = FND_API.G_MISS_DATE) THEN
60: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
61: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
62: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
63: FND_MSG_PUB.Add;

Line 64: RAISE FND_API.G_EXC_ERROR;

60: FND_MESSAGE.SET_NAME('CSI','CSI_API_REQD_PARAM_MISSING');
61: FND_MESSAGE.SET_TOKEN('API_NAME',p_api_name);
62: FND_MESSAGE.SET_TOKEN('MISSING_PARAM',p_param_name);
63: FND_MSG_PUB.Add;
64: RAISE FND_API.G_EXC_ERROR;
65: END IF;
66: END Check_Reqd_Param_date;
67:
68: /*-----------------------------------------------------------*/

Line 97: and NVL(contact_ip_id,fnd_api.g_miss_num) = nvl(p_contact_ip_id,fnd_api.g_miss_num)

93: and party_source_table = p_party_source_table
94: and party_id = p_party_id
95: and relationship_type_code = p_relationship_type
96: and contact_flag = p_contact_flag
97: and NVL(contact_ip_id,fnd_api.g_miss_num) = nvl(p_contact_ip_id,fnd_api.g_miss_num)
98: and ((active_end_date is null) OR (active_end_date >= sysdate));
99:
100: IF ( p_stack_err_msg = TRUE ) THEN
101: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PARTY_REL_COMB');

Line 464: IF ((p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE))THEN

460: FROM csi_item_instances
461: WHERE instance_id = p_instance_id
462: and ((active_end_date is null) OR (active_end_date >= sysdate));
463: BEGIN
464: IF ((p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE))THEN
465: IF p_start_date > p_end_date THEN
466: l_return_value := FALSE;
467: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_START_DATE');
468: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);

Line 583: IF ((p_instance_party_id is null) or (p_instance_party_id = fnd_api.g_miss_num)) then

579: WHERE instance_id = p_instance_id
580: and ((active_end_date is null) OR (active_end_date >= sysdate));
581: BEGIN
582:
583: IF ((p_instance_party_id is null) or (p_instance_party_id = fnd_api.g_miss_num)) then
584:
585: IF ((p_end_date is NOT NULL) and (p_end_date <> fnd_api.g_miss_date)) THEN
586: IF p_end_date < sysdate THEN
587: l_return_value := FALSE;

Line 585: IF ((p_end_date is NOT NULL) and (p_end_date <> fnd_api.g_miss_date)) THEN

581: BEGIN
582:
583: IF ((p_instance_party_id is null) or (p_instance_party_id = fnd_api.g_miss_num)) then
584:
585: IF ((p_end_date is NOT NULL) and (p_end_date <> fnd_api.g_miss_date)) THEN
586: IF p_end_date < sysdate THEN
587: l_return_value := FALSE;
588: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');
589: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);

Line 610: IF ((p_end_date is NOT NULL) and (p_end_date <> fnd_api.g_miss_date)) THEN

606: RETURN l_return_value;
607: END IF;
608: END IF;
609:
610: IF ((p_end_date is NOT NULL) and (p_end_date <> fnd_api.g_miss_date)) THEN
611: OPEN c1;
612: FETCH c1 INTO l_instance_end_date ,l_instance_start_date;
613:
614: IF l_instance_end_date is NOT NULL THEN

Line 751: p_instance_party_id = FND_API.G_MISS_NUM THEN

747: AND relationship_type_code = 'OWNER'
748: and ((active_end_date is null) OR (active_end_date >= sysdate));
749: BEGIN
750: IF p_instance_party_id IS NULL OR
751: p_instance_party_id = FND_API.G_MISS_NUM THEN
752: l_inst_party_id := -99999;
753: ELSE
754: l_inst_party_id := p_instance_party_id;
755: END IF;

Line 1167: IF (p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE) THEN

1163: FROM csi_i_parties
1164: WHERE instance_party_id = p_instance_party_id
1165: and ((active_end_date is null) OR (active_end_date >= sysdate));
1166: BEGIN
1167: IF (p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE) THEN
1168:
1169: IF p_start_date > p_end_date THEN
1170: l_return_value := FALSE;
1171: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ACCT_START_DATE');

Line 1286: IF ((p_ip_account_id IS NULL) OR (p_ip_account_id = FND_API.G_MISS_NUM))

1282: FROM csi_i_parties
1283: WHERE instance_party_id = p_inst_party_id
1284: and ((active_end_date is null) OR (active_end_date >= sysdate));
1285: BEGIN
1286: IF ((p_ip_account_id IS NULL) OR (p_ip_account_id = FND_API.G_MISS_NUM))
1287: THEN
1288: IF ((p_end_date is NOT NULL) and (p_end_date <> fnd_api.g_miss_date))
1289: THEN
1290: IF p_end_date < sysdate

Line 1288: IF ((p_end_date is NOT NULL) and (p_end_date <> fnd_api.g_miss_date))

1284: and ((active_end_date is null) OR (active_end_date >= sysdate));
1285: BEGIN
1286: IF ((p_ip_account_id IS NULL) OR (p_ip_account_id = FND_API.G_MISS_NUM))
1287: THEN
1288: IF ((p_end_date is NOT NULL) and (p_end_date <> fnd_api.g_miss_date))
1289: THEN
1290: IF p_end_date < sysdate
1291: THEN
1292: l_return_value := FALSE;

Line 1323: IF ((p_end_date is not null) and (p_end_date <> fnd_api.g_miss_date)) then

1319: RETURN l_return_value;
1320: END IF;
1321: END IF;
1322:
1323: IF ((p_end_date is not null) and (p_end_date <> fnd_api.g_miss_date)) then
1324:
1325: OPEN c1;
1326: FETCH c1 INTO l_instance_end_date;
1327:

Line 2210: ,p_commit IN VARCHAR2 := fnd_api.g_false

2206: /*-----------------------------------------------------------*/
2207:
2208: PROCEDURE Transfer_Party_Rules
2209: ( p_api_version IN NUMBER
2210: ,p_commit IN VARCHAR2 := fnd_api.g_false
2211: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2212: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
2213: ,p_party_rec IN csi_datastructures_pub.party_rec
2214: ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE

Line 2211: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

2207:
2208: PROCEDURE Transfer_Party_Rules
2209: ( p_api_version IN NUMBER
2210: ,p_commit IN VARCHAR2 := fnd_api.g_false
2211: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2212: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
2213: ,p_party_rec IN csi_datastructures_pub.party_rec
2214: ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE
2215: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 2212: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

2208: PROCEDURE Transfer_Party_Rules
2209: ( p_api_version IN NUMBER
2210: ,p_commit IN VARCHAR2 := fnd_api.g_false
2211: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2212: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
2213: ,p_party_rec IN csi_datastructures_pub.party_rec
2214: ,p_stack_err_msg IN BOOLEAN DEFAULT TRUE
2215: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
2216: ,x_return_status OUT NOCOPY VARCHAR2

Line 2244: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2240: -- Standard Start of API savepoint
2241: -- SAVEPOINT Transfer_Party_Rules;
2242:
2243: -- Standard call to check for call compatibility.
2244: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2245: p_api_version ,
2246: l_api_name ,
2247: g_pkg_name )
2248: THEN

Line 2249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2245: p_api_version ,
2246: l_api_name ,
2247: g_pkg_name )
2248: THEN
2249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2250: END IF;
2251:
2252: -- Initialize message list if p_init_msg_list is set to TRUE.
2253: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2253: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2250: END IF;
2251:
2252: -- Initialize message list if p_init_msg_list is set to TRUE.
2253: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2254: FND_MSG_PUB.initialize;
2255: END IF;
2256:
2257: -- Initialize API return status to success

Line 2259: x_return_status := FND_API.G_RET_STS_SUCCESS;

2255: END IF;
2256:
2257: -- Initialize API return status to success
2258: -- Verify if the Party rel combination exists
2259: x_return_status := FND_API.G_RET_STS_SUCCESS;
2260:
2261: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
2262: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2263:

Line 2288: l_party_account_rec.expire_flag := fnd_api.g_true; -- Added by sguthiva for bug 2307804

2284: FOR C1 IN GET_IP_ACCOUNT(p_party_rec.instance_party_id)
2285: LOOP
2286: IF GET_IP_ACCOUNT%FOUND THEN
2287: l_party_account_rec.ip_account_id := C1.ip_account_id;
2288: l_party_account_rec.expire_flag := fnd_api.g_true; -- Added by sguthiva for bug 2307804
2289: l_party_account_rec.object_version_number := C1.object_version_number;
2290: -- Added by sguthiva for bug 2307804
2291: IF C1.relationship_type_code <> 'OWNER'
2292: THEN

Line 2306: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2302: ,x_return_status => x_return_status
2303: ,x_msg_count => x_msg_count
2304: ,x_msg_data => x_msg_data );
2305:
2306: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2307: l_msg_index := 1;
2308: l_msg_count := x_msg_count;
2309: WHILE l_msg_count > 0 LOOP
2310: x_msg_data := FND_MSG_PUB.GET(

Line 2312: FND_API.G_FALSE);

2308: l_msg_count := x_msg_count;
2309: WHILE l_msg_count > 0 LOOP
2310: x_msg_data := FND_MSG_PUB.GET(
2311: l_msg_index,
2312: FND_API.G_FALSE);
2313: csi_gen_utility_pvt.put_line( 'message data = Error from csi_party_relationships_pvt.expire_inst_party_account');
2314: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
2315: l_msg_index := l_msg_index + 1;
2316: l_msg_count := l_msg_count - 1;

Line 2318: RAISE FND_API.G_EXC_ERROR;

2314: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
2315: l_msg_index := l_msg_index + 1;
2316: l_msg_count := l_msg_count - 1;
2317: END LOOP;
2318: RAISE FND_API.G_EXC_ERROR;
2319: END IF;
2320: END IF; -- Added by sguthiva for bug 2307804
2321: END IF;
2322: END LOOP;

Line 2329: AND p_party_rec.contact_ip_id <> fnd_api.g_miss_num

2325:
2326: -- Check if the party in question has a contact
2327: /* The following code has been added for bug 2127250 */
2328: IF p_party_rec.contact_ip_id IS NOT NULL
2329: AND p_party_rec.contact_ip_id <> fnd_api.g_miss_num
2330: THEN
2331: /* End of addition for bug 2127250 */
2332: IF (CSI_Instance_parties_vld_pvt.Is_Party_Contact_Exists
2333: (p_party_rec.contact_ip_id,

Line 2335: RAISE FND_API.G_EXC_ERROR;

2331: /* End of addition for bug 2127250 */
2332: IF (CSI_Instance_parties_vld_pvt.Is_Party_Contact_Exists
2333: (p_party_rec.contact_ip_id,
2334: TRUE)) THEN
2335: RAISE FND_API.G_EXC_ERROR;
2336: END IF;
2337: END IF;
2338:
2339: -- End of API body

Line 2342: IF FND_API.To_Boolean( p_commit ) THEN

2338:
2339: -- End of API body
2340:
2341: -- Standard check of p_commit.
2342: IF FND_API.To_Boolean( p_commit ) THEN
2343: COMMIT WORK;
2344: END IF;
2345:
2346:

Line 2353: WHEN FND_API.G_EXC_ERROR THEN

2349: (p_count => x_msg_count ,
2350: p_data => x_msg_data );
2351:
2352: EXCEPTION
2353: WHEN FND_API.G_EXC_ERROR THEN
2354: -- ROLLBACK TO Transfer_Party_Rules;
2355: x_return_status := FND_API.G_RET_STS_ERROR ;
2356: FND_MSG_PUB.Count_And_Get
2357: ( p_count => x_msg_count,

Line 2355: x_return_status := FND_API.G_RET_STS_ERROR ;

2351:
2352: EXCEPTION
2353: WHEN FND_API.G_EXC_ERROR THEN
2354: -- ROLLBACK TO Transfer_Party_Rules;
2355: x_return_status := FND_API.G_RET_STS_ERROR ;
2356: FND_MSG_PUB.Count_And_Get
2357: ( p_count => x_msg_count,
2358: p_data => x_msg_data );
2359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2355: x_return_status := FND_API.G_RET_STS_ERROR ;
2356: FND_MSG_PUB.Count_And_Get
2357: ( p_count => x_msg_count,
2358: p_data => x_msg_data );
2359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2360: -- ROLLBACK TO Transfer_Party_Rules;
2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2362: FND_MSG_PUB.Count_And_Get
2363: ( p_count => x_msg_count,

Line 2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2357: ( p_count => x_msg_count,
2358: p_data => x_msg_data );
2359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2360: -- ROLLBACK TO Transfer_Party_Rules;
2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2362: FND_MSG_PUB.Count_And_Get
2363: ( p_count => x_msg_count,
2364: p_data => x_msg_data );
2365: WHEN OTHERS THEN

Line 2367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2363: ( p_count => x_msg_count,
2364: p_data => x_msg_data );
2365: WHEN OTHERS THEN
2366: -- ROLLBACK TO Transfer_Party_Rules;
2367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2368: IF FND_MSG_PUB.Check_Msg_Level
2369: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2370: THEN
2371: FND_MSG_PUB.Add_Exc_Msg

Line 2405: AND NVL(active_end_date, SYSDATE) >= DECODE(active_end_date, NULL, SYSDATE, NVL(p_start_date, FND_API.G_MISS_DATE));

2401: -- AND relationship_type_code = p_relationship_type
2402: AND preferred_flag = 'Y'
2403: AND contact_flag = 'Y'
2404: AND ((active_end_date is null) OR (active_end_date >= sysdate))
2405: AND NVL(active_end_date, SYSDATE) >= DECODE(active_end_date, NULL, SYSDATE, NVL(p_start_date, FND_API.G_MISS_DATE));
2406: BEGIN
2407: OPEN C1;
2408: FETCH C1 INTO l_dummy;
2409: IF C1%FOUND THEN

Line 2457: -- AND NVL(active_end_date, SYSDATE) >= DECODE(active_end_date, NULL, SYSDATE, NVL(p_start_date, FND_API.G_MISS_DATE));

2453: AND contact_ip_id = p_contact_ip_id
2454: AND ((active_end_date is null) OR (active_end_date > p_start_date));
2455: -- AND active_start_date < p_end_date; --sk added
2456: -- AND ((active_end_date is null) OR (active_end_date >= sysdate))
2457: -- AND NVL(active_end_date, SYSDATE) >= DECODE(active_end_date, NULL, SYSDATE, NVL(p_start_date, FND_API.G_MISS_DATE));
2458: BEGIN
2459: OPEN C1;
2460: FETCH C1 INTO l_dummy;
2461: IF C1%FOUND THEN

Line 2503: AND NVL(active_end_date, SYSDATE) >= DECODE(active_end_date, NULL, SYSDATE, NVL(p_start_date, FND_API.G_MISS_DATE));

2499: -- AND relationship_type_code = p_relationship_type
2500: AND preferred_flag = 'Y'
2501: AND contact_flag <> 'Y'
2502: AND ((active_end_date is null) OR (active_end_date >= sysdate))
2503: AND NVL(active_end_date, SYSDATE) >= DECODE(active_end_date, NULL, SYSDATE, NVL(p_start_date, FND_API.G_MISS_DATE));
2504:
2505:
2506: BEGIN
2507: OPEN C1;

Line 2555: -- AND NVL(active_end_date, SYSDATE) >= DECODE(active_end_date, NULL, SYSDATE, NVL(p_start_date, FND_API.G_MISS_DATE));

2551: AND contact_flag <> 'Y'
2552: AND ((active_end_date IS NULL) OR (active_end_date > p_start_date));
2553: -- AND active_start_date < p_end_date ; sk commented this for bug 2077093.
2554: -- AND ((active_end_date is null) OR (active_end_date >= sysdate)) --sk commented
2555: -- AND NVL(active_end_date, SYSDATE) >= DECODE(active_end_date, NULL, SYSDATE, NVL(p_start_date, FND_API.G_MISS_DATE));
2556: BEGIN
2557: OPEN C1;
2558: FETCH C1 INTO l_dummy;
2559: IF C1%FOUND THEN