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 466: IF ((p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE))THEN

462: FROM csi_item_instances
463: WHERE instance_id = p_instance_id
464: and ((active_end_date is null) OR (trunc(active_end_date,'MI') >= trunc(SYSDATE,'MI'))); --Changed to trunc for bug 9750206
465: BEGIN
466: IF ((p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE))THEN
467: IF trunc(p_start_date,'MI') > trunc(p_end_date,'MI') THEN --Changed to trunc for bug 9750206
468: l_return_value := FALSE;
469: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_START_DATE');
470: FND_MESSAGE.SET_TOKEN('ACTIVE_START_DATE',p_start_date);

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

581: WHERE instance_id = p_instance_id
582: and ((active_end_date is null) OR (trunc(active_end_date,'MI') >= trunc(sysdate,'MI'))); --Changed to trunc for bug 9750206
583: BEGIN
584:
585: IF ((p_instance_party_id is null) or (p_instance_party_id = fnd_api.g_miss_num)) then
586:
587: IF ((p_end_date is NOT NULL) and (p_end_date <> fnd_api.g_miss_date)) THEN
588: IF trunc(p_end_date,'MI') < trunc(sysdate,'MI') THEN --Changed to trunc for bug 9750206
589: l_return_value := FALSE;

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

583: BEGIN
584:
585: IF ((p_instance_party_id is null) or (p_instance_party_id = fnd_api.g_miss_num)) then
586:
587: IF ((p_end_date is NOT NULL) and (p_end_date <> fnd_api.g_miss_date)) THEN
588: IF trunc(p_end_date,'MI') < trunc(sysdate,'MI') THEN --Changed to trunc for bug 9750206
589: l_return_value := FALSE;
590: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_PTY_END_DATE');
591: FND_MESSAGE.SET_TOKEN('ACTIVE_END_DATE',p_end_date);

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

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

Line 753: p_instance_party_id = FND_API.G_MISS_NUM THEN

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

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

1165: FROM csi_i_parties
1166: WHERE instance_party_id = p_instance_party_id
1167: and ((active_end_date is null) OR (active_end_date >= sysdate));
1168: BEGIN
1169: IF (p_end_date is NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE) THEN
1170:
1171: -- Modified date comparision for bug 7333900, ignore difference in seconds
1172: IF (trunc(p_start_date,'MI') > trunc(p_end_date,'MI')) THEN --Changed to trunc for bug 9750206
1173: l_return_value := FALSE;

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

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

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

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

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

1323: RETURN l_return_value;
1324: END IF;
1325: END IF;
1326:
1327: IF ((p_end_date is not null) and (p_end_date <> fnd_api.g_miss_date)) then
1328:
1329: OPEN c1;
1330: FETCH c1 INTO l_instance_end_date;
1331:

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

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

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

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

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

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

Line 2248: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

Line 2253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2249: p_api_version ,
2250: l_api_name ,
2251: g_pkg_name )
2252: THEN
2253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2254: END IF;
2255:
2256: -- Initialize message list if p_init_msg_list is set to TRUE.
2257: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2257: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 2263: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

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

2306: ,x_return_status => x_return_status
2307: ,x_msg_count => x_msg_count
2308: ,x_msg_data => x_msg_data );
2309:
2310: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2311: l_msg_index := 1;
2312: l_msg_count := x_msg_count;
2313: WHILE l_msg_count > 0 LOOP
2314: x_msg_data := FND_MSG_PUB.GET(

Line 2316: FND_API.G_FALSE);

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

Line 2322: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 2339: RAISE FND_API.G_EXC_ERROR;

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

Line 2346: IF FND_API.To_Boolean( p_commit ) THEN

2342:
2343: -- End of API body
2344:
2345: -- Standard check of p_commit.
2346: IF FND_API.To_Boolean( p_commit ) THEN
2347: COMMIT WORK;
2348: END IF;
2349:
2350:

Line 2357: WHEN FND_API.G_EXC_ERROR THEN

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

Line 2359: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 2363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2361: ( p_count => x_msg_count,
2362: p_data => x_msg_data );
2363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2364: -- ROLLBACK TO Transfer_Party_Rules;
2365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2366: FND_MSG_PUB.Count_And_Get
2367: ( p_count => x_msg_count,
2368: p_data => x_msg_data );
2369: WHEN OTHERS THEN

Line 2371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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

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

2457: AND contact_ip_id = p_contact_ip_id
2458: AND ((active_end_date is null) OR (active_end_date > p_start_date))
2459: -- AND active_start_date < p_end_date; --sk added
2460: AND ((active_end_date is null) OR (active_end_date >= sysdate)); -- Added for Bug 14772562
2461: -- AND NVL(active_end_date, SYSDATE) >= DECODE(active_end_date, NULL, SYSDATE, NVL(p_start_date, FND_API.G_MISS_DATE));
2462: BEGIN
2463: OPEN C1;
2464: FETCH C1 INTO l_dummy;
2465: IF C1%FOUND THEN

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

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

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

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