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_PARTY_RELATIONSHIPS_PUB dependencies on FND_API

Line 59: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

55:
56: csi_utility_grp.check_ib_active;
57:
58: -- Standard call to check for call compatibility.
59: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
60: p_api_version ,
61: l_api_name ,
62: g_pkg_name )
63: THEN

Line 64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

60: p_api_version ,
61: l_api_name ,
62: g_pkg_name )
63: THEN
64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
65: END IF;
66:
67: -- Initialize message list if p_init_msg_list is set to TRUE.
68: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 68: IF FND_API.to_Boolean( p_init_msg_list ) THEN

64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
65: END IF;
66:
67: -- Initialize message list if p_init_msg_list is set to TRUE.
68: IF FND_API.to_Boolean( p_init_msg_list ) THEN
69: FND_MSG_PUB.initialize;
70: END IF;
71:
72: -- Initialize API return status to success

Line 73: x_return_status := FND_API.G_RET_STS_SUCCESS;

69: FND_MSG_PUB.initialize;
70: END IF;
71:
72: -- Initialize API return status to success
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74:
75: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
76: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
77:

Line 104: IF (p_party_query_rec.instance_party_id = FND_API.G_MISS_NUM)

100:
101: -- Start API body
102: -- check if atleast one query parameters are passed else
103: -- raise an error
104: IF (p_party_query_rec.instance_party_id = FND_API.G_MISS_NUM)
105: AND (p_party_query_rec.instance_id = FND_API.G_MISS_NUM)
106: AND (p_party_query_rec.party_id = FND_API.G_MISS_NUM)
107: AND (p_party_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
108:

Line 105: AND (p_party_query_rec.instance_id = FND_API.G_MISS_NUM)

101: -- Start API body
102: -- check if atleast one query parameters are passed else
103: -- raise an error
104: IF (p_party_query_rec.instance_party_id = FND_API.G_MISS_NUM)
105: AND (p_party_query_rec.instance_id = FND_API.G_MISS_NUM)
106: AND (p_party_query_rec.party_id = FND_API.G_MISS_NUM)
107: AND (p_party_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
108:
109: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');

Line 106: AND (p_party_query_rec.party_id = FND_API.G_MISS_NUM)

102: -- check if atleast one query parameters are passed else
103: -- raise an error
104: IF (p_party_query_rec.instance_party_id = FND_API.G_MISS_NUM)
105: AND (p_party_query_rec.instance_id = FND_API.G_MISS_NUM)
106: AND (p_party_query_rec.party_id = FND_API.G_MISS_NUM)
107: AND (p_party_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
108:
109: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
110: FND_MSG_PUB.Add;

Line 107: AND (p_party_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN

103: -- raise an error
104: IF (p_party_query_rec.instance_party_id = FND_API.G_MISS_NUM)
105: AND (p_party_query_rec.instance_id = FND_API.G_MISS_NUM)
106: AND (p_party_query_rec.party_id = FND_API.G_MISS_NUM)
107: AND (p_party_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
108:
109: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
110: FND_MSG_PUB.Add;
111: RAISE FND_API.G_EXC_ERROR;

Line 111: RAISE FND_API.G_EXC_ERROR;

107: AND (p_party_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
108:
109: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
110: FND_MSG_PUB.Add;
111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
113:
114: -- Generate the where clause dynamically
115: csi_party_relationships_pvt.Gen_Pty_Where_Clause

Line 148: IF ((p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE)) THEN

144:
145: -- Close the cursor
146: DBMS_SQL.CLOSE_CURSOR(l_get_party_cursor_id);
147:
148: IF ((p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE)) THEN
149:
150: IF p_time_stamp <= sysdate THEN
151: -- contruct from the history if the p_time_stamp
152: -- is < than sysdate

Line 157: RAISE FND_API.G_EXC_ERROR;

153: csi_party_relationships_pvt.Construct_pty_from_hist(x_party_header_tbl, p_time_stamp);
154: ELSE
155: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
156: FND_MSG_PUB.ADD;
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159: END IF;
160: --start of the new code for resolve_id_columns 08/24/01
161:

Line 162: IF p_resolve_id_columns = fnd_api.g_true THEN

158: END IF;
159: END IF;
160: --start of the new code for resolve_id_columns 08/24/01
161:
162: IF p_resolve_id_columns = fnd_api.g_true THEN
163:
164: IF x_party_header_tbl.count > 0 THEN
165:
166: FOR i IN x_party_header_tbl.FIRST.. x_party_header_tbl.LAST

Line 236: x_party_header_tbl(i).party_name = fnd_api.g_miss_char

232: AND cl.lookup_code=l_party_source_tbl
233: AND cii.instance_id=x_party_header_tbl(i).instance_id;
234:
235: IF x_party_header_tbl(i).party_name IS NULL OR
236: x_party_header_tbl(i).party_name = fnd_api.g_miss_char
237: THEN
238: x_party_header_tbl(i).party_name :=l_pty_name;
239: END IF;
240:

Line 309: IF FND_API.To_Boolean( p_commit ) THEN

305: -- End of API body
306:
307: -- Standard check of p_commit.
308: /*
309: IF FND_API.To_Boolean( p_commit ) THEN
310: COMMIT WORK;
311: END IF;
312: */
313:

Line 327: WHEN FND_API.G_EXC_ERROR THEN

323: FND_MSG_PUB.Count_And_Get
324: (p_count => x_msg_count ,
325: p_data => x_msg_data );
326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
328: -- ROLLBACK TO get_inst_party_rel_pub;
329: x_return_status := FND_API.G_RET_STS_ERROR ;
330: FND_MSG_PUB.Count_And_Get
331: ( p_count => x_msg_count,

Line 329: x_return_status := FND_API.G_RET_STS_ERROR ;

325: p_data => x_msg_data );
326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
328: -- ROLLBACK TO get_inst_party_rel_pub;
329: x_return_status := FND_API.G_RET_STS_ERROR ;
330: FND_MSG_PUB.Count_And_Get
331: ( p_count => x_msg_count,
332: p_data => x_msg_data );
333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

329: x_return_status := FND_API.G_RET_STS_ERROR ;
330: FND_MSG_PUB.Count_And_Get
331: ( p_count => x_msg_count,
332: p_data => x_msg_data );
333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
334: -- ROLLBACK TO get_inst_party_rel_pub;
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
336: FND_MSG_PUB.Count_And_Get
337: ( p_count => x_msg_count,

Line 335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

331: ( p_count => x_msg_count,
332: p_data => x_msg_data );
333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
334: -- ROLLBACK TO get_inst_party_rel_pub;
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
336: FND_MSG_PUB.Count_And_Get
337: ( p_count => x_msg_count,
338: p_data => x_msg_data );
339: WHEN OTHERS THEN

Line 344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

340: IF DBMS_SQL.IS_OPEN(l_get_party_cursor_id) THEN
341: DBMS_SQL.CLOSE_CURSOR(l_get_party_cursor_id);
342: END IF;
343: -- ROLLBACK TO get_inst_party_rel_pub;
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
345: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
346: FND_MSG_PUB.Add_Exc_Msg
347: ( g_pkg_name ,
348: l_api_name );

Line 404: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

400:
401: csi_utility_grp.check_ib_active;
402:
403: -- Standard call to check for call compatibility.
404: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
405: p_api_version ,
406: l_api_name ,
407: g_pkg_name )
408: THEN

Line 409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

405: p_api_version ,
406: l_api_name ,
407: g_pkg_name )
408: THEN
409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410: END IF;
411:
412: -- Initialize message list if p_init_msg_list is set to TRUE.
413: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 413: IF FND_API.to_Boolean( p_init_msg_list ) THEN

409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410: END IF;
411:
412: -- Initialize message list if p_init_msg_list is set to TRUE.
413: IF FND_API.to_Boolean( p_init_msg_list ) THEN
414: FND_MSG_PUB.initialize;
415: END IF;
416:
417: -- Initialize API return status to success

Line 418: x_return_status := FND_API.G_RET_STS_SUCCESS;

414: FND_MSG_PUB.initialize;
415: END IF;
416:
417: -- Initialize API return status to success
418: x_return_status := FND_API.G_RET_STS_SUCCESS;
419:
420: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
421: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
422:

Line 460: RAISE FND_API.G_EXC_ERROR;

456: --
457: IF l_internal_party_id IS NULL THEN
458: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
459: FND_MSG_PUB.ADD;
460: RAISE FND_API.G_EXC_ERROR;
461: END IF;
462: -- Check if the table is not empty and then loop
463: IF p_party_tbl.count > 0 THEN
464: FOR l_party_row IN p_party_tbl.FIRST..p_party_tbl.LAST LOOP

Line 479: OR (p_party_account_tbl(l_acct_row).parent_tbl_index = FND_API.G_MISS_NUM)

475: IF p_party_account_tbl.EXISTS(l_acct_row) -- Added for bug 3776650
476: THEN
477: -- Check if the party and its accounts are mapped
478: IF ((p_party_account_tbl(l_acct_row).parent_tbl_index IS NULL)
479: OR (p_party_account_tbl(l_acct_row).parent_tbl_index = FND_API.G_MISS_NUM)
480: OR (NOT(p_party_tbl.EXISTS(p_party_account_tbl(l_acct_row).parent_tbl_index)))
481: ) THEN
482: FND_MESSAGE.SET_NAME('CSI','CSI_API_PARTY_ACCT_NOT_MAPPED');
483: FND_MSG_PUB.Add;

Line 484: RAISE FND_API.G_EXC_ERROR;

480: OR (NOT(p_party_tbl.EXISTS(p_party_account_tbl(l_acct_row).parent_tbl_index)))
481: ) THEN
482: FND_MESSAGE.SET_NAME('CSI','CSI_API_PARTY_ACCT_NOT_MAPPED');
483: FND_MSG_PUB.Add;
484: RAISE FND_API.G_EXC_ERROR;
485: END IF;
486:
487: IF ((p_party_account_tbl(l_acct_row).parent_tbl_index = l_party_row)
488: AND (p_party_account_tbl(l_acct_row).relationship_type_code = 'OWNER')) THEN

Line 500: RAISE FND_API.G_EXC_ERROR;

496: IF NOT l_party_has_correct_acct THEN
497: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OWNER_ACCT');
498: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_tbl(l_party_row).party_id);
499: FND_MSG_PUB.ADD;
500: RAISE FND_API.G_EXC_ERROR;
501: END IF;
502:
503: END IF;
504:

Line 508: p_party_tbl(l_party_row).contact_ip_id=fnd_api.g_miss_num )

504:
505: -- Adding att enhancements by sguthiva
506: IF p_party_tbl(l_party_row).contact_flag='Y'
507: AND (p_party_tbl(l_party_row).contact_ip_id IS NULL OR
508: p_party_tbl(l_party_row).contact_ip_id=fnd_api.g_miss_num )
509: AND (p_party_tbl(l_party_row).contact_parent_tbl_index IS NOT NULL AND
510: p_party_tbl(l_party_row).contact_parent_tbl_index <> fnd_api.g_miss_num )
511: THEN
512: FOR cont_row IN p_party_tbl.FIRST .. p_party_tbl.LAST

Line 510: p_party_tbl(l_party_row).contact_parent_tbl_index <> fnd_api.g_miss_num )

506: IF p_party_tbl(l_party_row).contact_flag='Y'
507: AND (p_party_tbl(l_party_row).contact_ip_id IS NULL OR
508: p_party_tbl(l_party_row).contact_ip_id=fnd_api.g_miss_num )
509: AND (p_party_tbl(l_party_row).contact_parent_tbl_index IS NOT NULL AND
510: p_party_tbl(l_party_row).contact_parent_tbl_index <> fnd_api.g_miss_num )
511: THEN
512: FOR cont_row IN p_party_tbl.FIRST .. p_party_tbl.LAST
513: LOOP
514: IF cont_row=p_party_tbl(l_party_row).contact_parent_tbl_index

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

537: ,p_party_rel_type_tbl => l_party_rel_type_tbl
538: ,p_party_count_rec => l_party_count_rec
539: ) ;
540:
541: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
542: l_msg_index := 1;
543: l_msg_count := x_msg_count;
544: WHILE l_msg_count > 0 LOOP
545: x_msg_data := FND_MSG_PUB.GET

Line 547: FND_API.G_FALSE );

543: l_msg_count := x_msg_count;
544: WHILE l_msg_count > 0 LOOP
545: x_msg_data := FND_MSG_PUB.GET
546: ( l_msg_index,
547: FND_API.G_FALSE );
548: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
549: l_msg_index := l_msg_index + 1;
550: l_msg_count := l_msg_count - 1;
551: END LOOP;

Line 552: RAISE FND_API.G_EXC_ERROR;

548: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
549: l_msg_index := l_msg_index + 1;
550: l_msg_count := l_msg_count - 1;
551: END LOOP;
552: RAISE FND_API.G_EXC_ERROR;
553: END IF;
554: END IF;
555: END LOOP; -- End of party loop
556: END IF; -- End of party count if

Line 563: OR (p_party_account_tbl(l_acct_row).parent_tbl_index = FND_API.G_MISS_NUM)

559: IF (p_party_account_tbl.COUNT > 0) THEN
560: FOR l_acct_row IN p_party_account_tbl.FIRST..p_party_account_tbl.LAST LOOP
561: IF p_party_account_tbl.EXISTS(l_acct_row) THEN
562: IF ((p_party_account_tbl(l_acct_row).parent_tbl_index IS NULL)
563: OR (p_party_account_tbl(l_acct_row).parent_tbl_index = FND_API.G_MISS_NUM)
564: OR (NOT(p_party_tbl.EXISTS(p_party_account_tbl(l_acct_row).parent_tbl_index)))
565: ) THEN
566: FND_MESSAGE.SET_NAME('CSI','CSI_API_PARTY_ACCT_NOT_MAPPED');
567: FND_MSG_PUB.Add;

Line 568: RAISE FND_API.G_EXC_ERROR;

564: OR (NOT(p_party_tbl.EXISTS(p_party_account_tbl(l_acct_row).parent_tbl_index)))
565: ) THEN
566: FND_MESSAGE.SET_NAME('CSI','CSI_API_PARTY_ACCT_NOT_MAPPED');
567: FND_MSG_PUB.Add;
568: RAISE FND_API.G_EXC_ERROR;
569: END IF;
570:
571: p_party_account_tbl(l_acct_row).instance_party_id :=
572: p_party_tbl(p_party_account_tbl(l_acct_row).parent_tbl_index).instance_party_id;

Line 575: OR p_party_account_tbl(l_acct_row).active_start_date = fnd_api.g_miss_date

571: p_party_account_tbl(l_acct_row).instance_party_id :=
572: p_party_tbl(p_party_account_tbl(l_acct_row).parent_tbl_index).instance_party_id;
573: -- Strat Addition for bug 1893100
574: IF p_party_account_tbl(l_acct_row).active_start_date IS NULL
575: OR p_party_account_tbl(l_acct_row).active_start_date = fnd_api.g_miss_date
576: AND (p_party_account_tbl(l_acct_row).ip_account_id IS NULL
577: OR p_party_account_tbl(l_acct_row).ip_account_id = fnd_api.g_miss_num)
578: THEN
579: p_party_account_tbl(l_acct_row).active_start_date :=

Line 577: OR p_party_account_tbl(l_acct_row).ip_account_id = fnd_api.g_miss_num)

573: -- Strat Addition for bug 1893100
574: IF p_party_account_tbl(l_acct_row).active_start_date IS NULL
575: OR p_party_account_tbl(l_acct_row).active_start_date = fnd_api.g_miss_date
576: AND (p_party_account_tbl(l_acct_row).ip_account_id IS NULL
577: OR p_party_account_tbl(l_acct_row).ip_account_id = fnd_api.g_miss_num)
578: THEN
579: p_party_account_tbl(l_acct_row).active_start_date :=
580: p_party_tbl(p_party_account_tbl(l_acct_row).parent_tbl_index).active_start_date;
581: END IF;

Line 599: AND p_party_account_tbl(l_acct_row).ip_account_id <> fnd_api.g_miss_num

595: -- End addition.
596:
597: -- Call Private package to validate and create party accounts
598: IF p_party_account_tbl(l_acct_row).ip_account_id IS NOT NULL
599: AND p_party_account_tbl(l_acct_row).ip_account_id <> fnd_api.g_miss_num
600: AND l_account_found IS NOT NULL
601: THEN
602: csi_party_relationships_pvt.update_inst_party_account
603: ( p_api_version => p_api_version

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

629: );
630:
631: END IF;
632:
633: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
634: l_msg_index := 1;
635: l_msg_count := x_msg_count;
636: WHILE l_msg_count > 0 LOOP
637: x_msg_data := FND_MSG_PUB.GET(

Line 639: FND_API.G_FALSE );

635: l_msg_count := x_msg_count;
636: WHILE l_msg_count > 0 LOOP
637: x_msg_data := FND_MSG_PUB.GET(
638: l_msg_index,
639: FND_API.G_FALSE );
640: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
641: l_msg_index := l_msg_index + 1;
642: l_msg_count := l_msg_count - 1;
643: END LOOP;

Line 644: RAISE FND_API.G_EXC_ERROR;

640: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
641: l_msg_index := l_msg_index + 1;
642: l_msg_count := l_msg_count - 1;
643: END LOOP;
644: RAISE FND_API.G_EXC_ERROR;
645: END IF;
646: END IF;
647: END LOOP;
648: END IF;

Line 655: IF FND_API.To_Boolean( p_commit ) THEN

651: --
652: -- End of API body
653: -- Standard check of p_commit.
654:
655: IF FND_API.To_Boolean( p_commit ) THEN
656: COMMIT WORK;
657: END IF;
658:
659: /***** srramakr commented for bug # 3304439

Line 672: WHEN FND_API.G_EXC_ERROR THEN

668: FND_MSG_PUB.Count_And_Get
669: (p_count => x_msg_count ,
670: p_data => x_msg_data );
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
673: x_return_status := FND_API.G_RET_STS_ERROR ;
674: ROLLBACK TO create_inst_party_rel_pub;
675: FND_MSG_PUB.Count_And_Get
676: ( p_count => x_msg_count,

Line 673: x_return_status := FND_API.G_RET_STS_ERROR ;

669: (p_count => x_msg_count ,
670: p_data => x_msg_data );
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
673: x_return_status := FND_API.G_RET_STS_ERROR ;
674: ROLLBACK TO create_inst_party_rel_pub;
675: FND_MSG_PUB.Count_And_Get
676: ( p_count => x_msg_count,
677: p_data => x_msg_data );

Line 679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

675: FND_MSG_PUB.Count_And_Get
676: ( p_count => x_msg_count,
677: p_data => x_msg_data );
678:
679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
681: ROLLBACK TO create_inst_party_rel_pub;
682: FND_MSG_PUB.Count_And_Get
683: ( p_count => x_msg_count,

Line 680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

676: ( p_count => x_msg_count,
677: p_data => x_msg_data );
678:
679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
681: ROLLBACK TO create_inst_party_rel_pub;
682: FND_MSG_PUB.Count_And_Get
683: ( p_count => x_msg_count,
684: p_data => x_msg_data );

Line 687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

683: ( p_count => x_msg_count,
684: p_data => x_msg_data );
685:
686: WHEN OTHERS THEN
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
688: ROLLBACK TO create_inst_party_rel_pub;
689: IF FND_MSG_PUB.Check_Msg_Level
690: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
691: THEN

Line 838: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

834:
835: csi_utility_grp.check_ib_active;
836:
837: -- Standard call to check for call compatibility.
838: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
839: p_api_version ,
840: l_api_name ,
841: g_pkg_name )
842: THEN

Line 843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

839: p_api_version ,
840: l_api_name ,
841: g_pkg_name )
842: THEN
843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
844: END IF;
845:
846: -- Initialize message list if p_init_msg_list is set to TRUE.
847: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 847: IF FND_API.to_Boolean( p_init_msg_list ) THEN

843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
844: END IF;
845:
846: -- Initialize message list if p_init_msg_list is set to TRUE.
847: IF FND_API.to_Boolean( p_init_msg_list ) THEN
848: FND_MSG_PUB.initialize;
849: END IF;
850:
851:

Line 853: x_return_status := FND_API.G_RET_STS_SUCCESS;

849: END IF;
850:
851:
852: -- Initialize API return status to success
853: x_return_status := FND_API.G_RET_STS_SUCCESS;
854:
855: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
856: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
857:

Line 888: l_grp_call_contracts := FND_API.G_FALSE;

884: -- Start API body
885: --
886: -- Assign the value for l_grp_call_contracts
887: -- Since all the records will have the same value for grp_call_contracts, we just take the first one.
888: l_grp_call_contracts := FND_API.G_FALSE;
889: IF p_party_account_tbl.count > 0 THEN
890: FOR tab_row in p_party_account_tbl.FIRST .. p_party_account_tbl.LAST
891: LOOP
892: IF p_party_account_tbl.EXISTS(tab_row) THEN

Line 952: RAISE FND_API.G_EXC_ERROR;

948: --
949: IF l_internal_party_id IS NULL THEN
950: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
951: FND_MSG_PUB.ADD;
952: RAISE FND_API.G_EXC_ERROR;
953: END IF;
954: -- Check if the table is not empty
955: IF p_party_tbl.count > 0 THEN
956: FOR l_party_row IN p_party_tbl.FIRST..p_party_tbl.LAST LOOP

Line 963: RAISE FND_API.G_EXC_ERROR;

959: -- Get Current Party record
960: IF NOT(CSI_Instance_parties_vld_pvt.Get_Party_Record
961: ( p_party_tbl(l_party_row).instance_party_id,
962: l_curr_party_rec)) THEN
963: RAISE FND_API.G_EXC_ERROR;
964: END IF;
965:
966: -- Check if this is Transfer of ownership (i.e. owner to a new owner)
967: -- If so, then a new owner account is needed for the new party

Line 968: IF ((p_party_tbl(l_party_row).PARTY_ID <> FND_API.G_MISS_NUM)

964: END IF;
965:
966: -- Check if this is Transfer of ownership (i.e. owner to a new owner)
967: -- If so, then a new owner account is needed for the new party
968: IF ((p_party_tbl(l_party_row).PARTY_ID <> FND_API.G_MISS_NUM)
969: AND (p_party_tbl(l_party_row).PARTY_ID IS NOT NULL)
970: AND (p_party_tbl(l_party_row).party_id <> l_internal_party_id)
971: AND (p_party_tbl(l_party_row).PARTY_ID <> l_curr_party_rec.PARTY_ID)
972: AND (p_party_tbl(l_party_row).PARTY_SOURCE_TABLE = 'HZ_PARTIES')

Line 986: OR (p_party_account_tbl(l_acct_row).parent_tbl_index = FND_API.G_MISS_NUM)

982: IF p_party_account_tbl.EXISTS(l_acct_row) -- Added for bug 3776650
983: THEN
984: -- Check if the party and its accounts are mapped
985: IF ((p_party_account_tbl(l_acct_row).parent_tbl_index IS NULL)
986: OR (p_party_account_tbl(l_acct_row).parent_tbl_index = FND_API.G_MISS_NUM)
987: OR (NOT(p_party_tbl.EXISTS(p_party_account_tbl(l_acct_row).parent_tbl_index)))
988: ) THEN
989: FND_MESSAGE.SET_NAME('CSI','CSI_API_PARTY_ACCT_NOT_MAPPED');
990: FND_MSG_PUB.Add;

Line 991: RAISE FND_API.G_EXC_ERROR;

987: OR (NOT(p_party_tbl.EXISTS(p_party_account_tbl(l_acct_row).parent_tbl_index)))
988: ) THEN
989: FND_MESSAGE.SET_NAME('CSI','CSI_API_PARTY_ACCT_NOT_MAPPED');
990: FND_MSG_PUB.Add;
991: RAISE FND_API.G_EXC_ERROR;
992: END IF;
993:
994: IF ((p_party_account_tbl(l_acct_row).parent_tbl_index = l_party_row)
995: AND (p_party_account_tbl(l_acct_row).relationship_type_code = 'OWNER')) THEN

Line 999: p_party_account_tbl(l_acct_row).bill_to_address = FND_API.G_MISS_NUM THEN

995: AND (p_party_account_tbl(l_acct_row).relationship_type_code = 'OWNER')) THEN
996: l_party_has_correct_acct := TRUE;
997: -- Check whether bill_to and ship_to are passed. If not make them null
998: IF p_party_account_tbl(l_acct_row).bill_to_address IS NULL OR
999: p_party_account_tbl(l_acct_row).bill_to_address = FND_API.G_MISS_NUM THEN
1000: p_party_account_tbl(l_acct_row).bill_to_address := NULL;
1001: END IF;
1002: --
1003: IF p_party_account_tbl(l_acct_row).ship_to_address IS NULL OR

Line 1004: p_party_account_tbl(l_acct_row).ship_to_address = FND_API.G_MISS_NUM THEN

1000: p_party_account_tbl(l_acct_row).bill_to_address := NULL;
1001: END IF;
1002: --
1003: IF p_party_account_tbl(l_acct_row).ship_to_address IS NULL OR
1004: p_party_account_tbl(l_acct_row).ship_to_address = FND_API.G_MISS_NUM THEN
1005: p_party_account_tbl(l_acct_row).ship_to_address := NULL;
1006: END IF;
1007: --
1008: END IF;

Line 1018: RAISE FND_API.G_EXC_ERROR;

1014: IF NOT l_party_has_correct_acct THEN
1015: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OWNER_ACCT');
1016: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_tbl(l_party_row).party_id);
1017: FND_MSG_PUB.ADD;
1018: RAISE FND_API.G_EXC_ERROR;
1019: END IF;
1020:
1021: END IF;
1022:

Line 1076: AND p_party_account_tbl(l_row).ip_account_id <> fnd_api.g_miss_num

1072: IF p_party_account_tbl.EXISTS(l_row) THEN
1073: l_obj_ver_number := NULL;
1074: BEGIN
1075: IF p_party_account_tbl(l_row).ip_account_id IS NOT NULL
1076: AND p_party_account_tbl(l_row).ip_account_id <> fnd_api.g_miss_num
1077: THEN
1078: SELECT acct.object_version_number
1079: INTO l_obj_ver_number
1080: FROM csi_ip_accounts acct

Line 1087: IF (p_party_account_tbl(l_row).ip_account_id IS NOT NULL AND p_party_account_tbl(l_row).ip_account_id <> fnd_api.g_miss_num)

1083: EXCEPTION
1084: WHEN OTHERS THEN
1085: l_obj_ver_number := NULL;
1086: END;
1087: IF (p_party_account_tbl(l_row).ip_account_id IS NOT NULL AND p_party_account_tbl(l_row).ip_account_id <> fnd_api.g_miss_num)
1088: AND p_party_account_tbl(l_row).relationship_type_code = 'OWNER'
1089: AND p_party_account_tbl(l_row).instance_party_id = l_party_rec.instance_party_id
1090: AND p_party_account_tbl(l_row).object_version_number = l_obj_ver_number
1091: THEN

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

1107: ,x_return_status => x_return_status
1108: ,x_msg_count => x_msg_count
1109: ,x_msg_data => x_msg_data ) ;
1110:
1111: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1112: l_msg_index := 1;
1113: l_msg_count := x_msg_count;
1114: WHILE l_msg_count > 0 LOOP
1115: x_msg_data := FND_MSG_PUB.GET(

Line 1117: FND_API.G_FALSE );

1113: l_msg_count := x_msg_count;
1114: WHILE l_msg_count > 0 LOOP
1115: x_msg_data := FND_MSG_PUB.GET(
1116: l_msg_index,
1117: FND_API.G_FALSE );
1118: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1119: l_msg_index := l_msg_index + 1;
1120: l_msg_count := l_msg_count - 1;
1121: END LOOP;

Line 1122: RAISE FND_API.G_EXC_ERROR;

1118: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1119: l_msg_index := l_msg_index + 1;
1120: l_msg_count := l_msg_count - 1;
1121: END LOOP;
1122: RAISE FND_API.G_EXC_ERROR;
1123: ELSE
1124: -- Grab the new party rec
1125: l_party_tbl(l_party_row) := l_party_rec;
1126: END IF;

Line 1141: (p_party_account_tbl(l_acct_row).ip_account_id = FND_API.G_MISS_NUM) ) THEN

1137:
1138:
1139: IF ( (p_party_account_tbl(l_acct_row).ip_account_id IS NULL)
1140: OR
1141: (p_party_account_tbl(l_acct_row).ip_account_id = FND_API.G_MISS_NUM) ) THEN
1142: -- Call Private package to validate and create party accounts
1143: csi_party_relationships_pvt.create_inst_party_account
1144: ( p_api_version => p_api_version
1145: ,p_commit => p_commit

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

1220: ,x_msg_count => x_msg_count
1221: ,x_msg_data => x_msg_data);
1222: END IF;
1223:
1224: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1225: l_msg_index := 1;
1226: l_msg_count := x_msg_count;
1227: WHILE l_msg_count > 0 LOOP
1228: x_msg_data := FND_MSG_PUB.GET(

Line 1230: FND_API.G_FALSE );

1226: l_msg_count := x_msg_count;
1227: WHILE l_msg_count > 0 LOOP
1228: x_msg_data := FND_MSG_PUB.GET(
1229: l_msg_index,
1230: FND_API.G_FALSE );
1231: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1232: l_msg_index := l_msg_index + 1;
1233: l_msg_count := l_msg_count - 1;
1234: END LOOP;

Line 1235: RAISE FND_API.G_EXC_ERROR;

1231: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1232: l_msg_index := l_msg_index + 1;
1233: l_msg_count := l_msg_count - 1;
1234: END LOOP;
1235: RAISE FND_API.G_EXC_ERROR;
1236: END IF;
1237: END IF;
1238: END LOOP;
1239: -- Added by sguthiva for bug 2307804

Line 1262: p_party_tbl(p_row).instance_id <> fnd_api.g_miss_num)

1258: IF l_old_party_tbl(l_row).instance_party_id = p_party_tbl(p_row).instance_party_id
1259: AND l_old_party_tbl(l_row).party_id <> l_internal_party_id
1260: AND p_party_tbl(p_row).party_id = l_internal_party_id
1261: AND ( p_party_tbl(p_row).instance_id IS NOT NULL AND
1262: p_party_tbl(p_row).instance_id <> fnd_api.g_miss_num)
1263: AND p_party_tbl(p_row).relationship_type_code='OWNER'
1264: THEN
1265: FOR l_exp_pty IN exp_pty_csr(p_party_tbl(p_row).instance_id)
1266: LOOP

Line 1275: p_txn_rec.src_txn_creation_date = FND_API.G_MISS_DATE THEN

1271: l_exp_party_rec.object_version_number := l_exp_pty.object_version_number;
1272: -- Bug 3804960
1273: -- srramakr Need to use the same the date used by the item instance
1274: IF p_txn_rec.src_txn_creation_date IS NULL OR
1275: p_txn_rec.src_txn_creation_date = FND_API.G_MISS_DATE THEN
1276: l_exp_party_rec.active_end_date := sysdate;
1277: ELSE
1278: l_exp_party_rec.active_end_date := p_txn_rec.src_txn_creation_date;
1279: END IF;

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

1288: ,x_return_status => x_return_status
1289: ,x_msg_count => x_msg_count
1290: ,x_msg_data => x_msg_data ) ;
1291:
1292: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1293: l_msg_index := 1;
1294: l_msg_count := x_msg_count;
1295: WHILE l_msg_count > 0
1296: LOOP

Line 1299: FND_API.G_FALSE );

1295: WHILE l_msg_count > 0
1296: LOOP
1297: x_msg_data := FND_MSG_PUB.GET(
1298: l_msg_index,
1299: FND_API.G_FALSE );
1300: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1301: l_msg_index := l_msg_index + 1;
1302: l_msg_count := l_msg_count - 1;
1303: END LOOP;

Line 1304: RAISE FND_API.G_EXC_ERROR;

1300: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1301: l_msg_index := l_msg_index + 1;
1302: l_msg_count := l_msg_count - 1;
1303: END LOOP;
1304: RAISE FND_API.G_EXC_ERROR;
1305: END IF;
1306: --fix for bug 5511689:To expire non-owner accounts while expiring non-owner parties.
1307: FOR exp_acct_rec IN exp_acct_csr(l_exp_pty.instance_party_id) LOOP
1308: l_exp_acct_rec:=l_temp_acct_rec;

Line 1313: l_exp_acct_rec.expire_flag :=fnd_api.g_true;

1309: l_exp_acct_rec.ip_account_id := exp_acct_rec.ip_account_id;
1310: l_exp_acct_rec.relationship_type_code := exp_acct_rec.relationship_type_code;
1311: l_exp_acct_rec.object_version_number := exp_acct_rec.object_version_number ;
1312: l_exp_acct_rec.active_end_date :=SYSDATE;
1313: l_exp_acct_rec.expire_flag :=fnd_api.g_true;
1314: csi_gen_utility_pvt.put_line('Expiring account record '||l_exp_acct_rec.ip_account_id||' of account type '||l_exp_acct_rec.relationship_type_code);
1315: IF l_exp_acct_rec.ip_account_id IS NOT NULL
1316: AND l_exp_acct_rec.ip_account_id <> fnd_api.g_miss_num
1317: THEN

Line 1316: AND l_exp_acct_rec.ip_account_id <> fnd_api.g_miss_num

1312: l_exp_acct_rec.active_end_date :=SYSDATE;
1313: l_exp_acct_rec.expire_flag :=fnd_api.g_true;
1314: csi_gen_utility_pvt.put_line('Expiring account record '||l_exp_acct_rec.ip_account_id||' of account type '||l_exp_acct_rec.relationship_type_code);
1315: IF l_exp_acct_rec.ip_account_id IS NOT NULL
1316: AND l_exp_acct_rec.ip_account_id <> fnd_api.g_miss_num
1317: THEN
1318: l_exp_acct_rec.grp_call_contracts := l_grp_call_contracts;
1319: csi_party_relationships_pvt.update_inst_party_account
1320: ( p_api_version => p_api_version

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

1327: ,x_return_status => x_return_status
1328: ,x_msg_count => x_msg_count
1329: ,x_msg_data => x_msg_data);
1330:
1331: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1332: l_msg_index := 1;
1333: l_msg_count := x_msg_count;
1334: WHILE l_msg_count > 0 LOOP
1335: x_msg_data := FND_MSG_PUB.GET(

Line 1337: FND_API.G_FALSE );

1333: l_msg_count := x_msg_count;
1334: WHILE l_msg_count > 0 LOOP
1335: x_msg_data := FND_MSG_PUB.GET(
1336: l_msg_index,
1337: FND_API.G_FALSE );
1338: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1339: l_msg_index := l_msg_index + 1;
1340: l_msg_count := l_msg_count - 1;
1341: END LOOP;

Line 1342: RAISE FND_API.G_EXC_ERROR;

1338: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1339: l_msg_index := l_msg_index + 1;
1340: l_msg_count := l_msg_count - 1;
1341: END LOOP;
1342: RAISE FND_API.G_EXC_ERROR;
1343: END IF;
1344: END IF;
1345: END LOOP;
1346: --end of fix 5511689

Line 1364: l_exp_acct_rec.expire_flag :=fnd_api.g_true;

1360: WHERE instance_party_id=p_party_tbl(p_row).instance_party_id
1361: AND relationship_type_code ='OWNER'
1362: AND nvl(active_end_date, sysdate+1) >= sysdate;
1363: l_exp_acct_rec.active_end_date :=SYSDATE;
1364: l_exp_acct_rec.expire_flag :=fnd_api.g_true;
1365: EXCEPTION
1366: WHEN OTHERS THEN
1367: NULL;
1368: END;

Line 1371: AND l_exp_acct_rec.ip_account_id <> fnd_api.g_miss_num

1367: NULL;
1368: END;
1369:
1370: IF l_exp_acct_rec.ip_account_id IS NOT NULL
1371: AND l_exp_acct_rec.ip_account_id <> fnd_api.g_miss_num
1372: THEN
1373: l_exp_acct_rec.grp_call_contracts := l_grp_call_contracts;
1374: csi_party_relationships_pvt.update_inst_party_account
1375: ( p_api_version => p_api_version

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

1382: ,x_return_status => x_return_status
1383: ,x_msg_count => x_msg_count
1384: ,x_msg_data => x_msg_data);
1385:
1386: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1387: l_msg_index := 1;
1388: l_msg_count := x_msg_count;
1389: WHILE l_msg_count > 0 LOOP
1390: x_msg_data := FND_MSG_PUB.GET(

Line 1392: FND_API.G_FALSE );

1388: l_msg_count := x_msg_count;
1389: WHILE l_msg_count > 0 LOOP
1390: x_msg_data := FND_MSG_PUB.GET(
1391: l_msg_index,
1392: FND_API.G_FALSE );
1393: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1394: l_msg_index := l_msg_index + 1;
1395: l_msg_count := l_msg_count - 1;
1396: END LOOP;

Line 1397: RAISE FND_API.G_EXC_ERROR;

1393: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1394: l_msg_index := l_msg_index + 1;
1395: l_msg_count := l_msg_count - 1;
1396: END LOOP;
1397: RAISE FND_API.G_EXC_ERROR;
1398: END IF;
1399: END IF;
1400: END IF;
1401: END LOOP;

Line 1421: l_old_party_tbl(l_old_party_row).party_id <> fnd_api.g_miss_num

1417: LOOP
1418: IF l_old_party_tbl.EXISTS(l_old_party_row) THEN
1419: IF l_old_party_tbl(l_old_party_row).relationship_type_code = 'OWNER' AND
1420: l_old_party_tbl(l_old_party_row).party_id IS NOT NULL AND
1421: l_old_party_tbl(l_old_party_row).party_id <> fnd_api.g_miss_num
1422: THEN
1423: -- Get Current Party record
1424: IF NOT(CSI_Instance_parties_vld_pvt.Get_Party_Record
1425: ( l_old_party_tbl(l_old_party_row).instance_party_id,

Line 1427: RAISE FND_API.G_EXC_ERROR;

1423: -- Get Current Party record
1424: IF NOT(CSI_Instance_parties_vld_pvt.Get_Party_Record
1425: ( l_old_party_tbl(l_old_party_row).instance_party_id,
1426: l_new_curr_party_rec)) THEN
1427: RAISE FND_API.G_EXC_ERROR;
1428: END IF;
1429:
1430: -- Start of code addition for fixing bug 6368172, section 3 of 5
1431: -- grab the owner account of the parent

Line 1502: AND l_old_parent_owner_pty_acct_id <> fnd_api.g_miss_num

1498: IF l_old_party_tbl(l_old_party_row).party_id <> l_new_curr_party_rec.party_id
1499: -- Start of code addition for fixing bug 6368172, section 4 of 5
1500: OR (l_old_party_tbl(l_old_party_row).party_id = l_new_curr_party_rec.party_id
1501: AND l_old_parent_owner_pty_acct_id IS NOT NULL
1502: AND l_old_parent_owner_pty_acct_id <> fnd_api.g_miss_num
1503: AND l_old_parent_owner_pty_acct_id <> l_new_ip_acct_rec.party_account_id)
1504: -- End of code addition for fixing bug 6368172, section 4 of 5
1505: OR nvl(l_old_party_tbl(l_old_party_row).cascade_ownership_flag,'N')='Y' -- Added for cascade 2972082
1506: THEN

Line 1515: l_old_party_tbl(l_old_party_row).instance_id = fnd_api.g_miss_num

1511: -- Here I'm grabbing the children
1512:
1513: -- Added for cascade bug 2972082
1514: IF l_old_party_tbl(l_old_party_row).instance_id IS NULL OR
1515: l_old_party_tbl(l_old_party_row).instance_id = fnd_api.g_miss_num
1516: THEN
1517: BEGIN
1518: SELECT instance_id
1519: INTO l_old_party_tbl(l_old_party_row).instance_id

Line 1533: p_rel_query_rec.object_id <> FND_API.G_MISS_NUM THEN

1529: p_rel_query_rec.object_id := l_old_party_tbl(l_old_party_row).instance_id;
1530: p_rel_query_rec.relationship_type_code := 'COMPONENT-OF';
1531: --
1532: IF p_rel_query_rec.object_id IS NOT NULL AND
1533: p_rel_query_rec.object_id <> FND_API.G_MISS_NUM THEN
1534: csi_ii_relationships_pvt.Get_Children
1535: ( p_relationship_query_rec => p_rel_query_rec,
1536: p_rel_tbl => l_rel_tbl,
1537: p_depth => NULL,

Line 1538: p_active_relationship_only => FND_API.G_TRUE,

1534: csi_ii_relationships_pvt.Get_Children
1535: ( p_relationship_query_rec => p_rel_query_rec,
1536: p_rel_tbl => l_rel_tbl,
1537: p_depth => NULL,
1538: p_active_relationship_only => FND_API.G_TRUE,
1539: p_time_stamp => FND_API.G_MISS_DATE,
1540: p_get_dfs => FND_API.G_FALSE,
1541: p_ii_relationship_level_tbl => l_ii_relationship_level_tbl,
1542: x_return_status => x_return_status,

Line 1539: p_time_stamp => FND_API.G_MISS_DATE,

1535: ( p_relationship_query_rec => p_rel_query_rec,
1536: p_rel_tbl => l_rel_tbl,
1537: p_depth => NULL,
1538: p_active_relationship_only => FND_API.G_TRUE,
1539: p_time_stamp => FND_API.G_MISS_DATE,
1540: p_get_dfs => FND_API.G_FALSE,
1541: p_ii_relationship_level_tbl => l_ii_relationship_level_tbl,
1542: x_return_status => x_return_status,
1543: x_msg_count => x_msg_count,

Line 1540: p_get_dfs => FND_API.G_FALSE,

1536: p_rel_tbl => l_rel_tbl,
1537: p_depth => NULL,
1538: p_active_relationship_only => FND_API.G_TRUE,
1539: p_time_stamp => FND_API.G_MISS_DATE,
1540: p_get_dfs => FND_API.G_FALSE,
1541: p_ii_relationship_level_tbl => l_ii_relationship_level_tbl,
1542: x_return_status => x_return_status,
1543: x_msg_count => x_msg_count,
1544: x_msg_data => x_msg_data

Line 1547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1543: x_msg_count => x_msg_count,
1544: x_msg_data => x_msg_data
1545: );
1546: --
1547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1548: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
1549: FND_MSG_PUB.Add;
1550: RAISE FND_API.G_EXC_ERROR;
1551: END IF;

Line 1550: RAISE FND_API.G_EXC_ERROR;

1546: --
1547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1548: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
1549: FND_MSG_PUB.Add;
1550: RAISE FND_API.G_EXC_ERROR;
1551: END IF;
1552: END IF;
1553: --
1554: IF l_rel_tbl.count > 0 THEN

Line 1564: l_cld_party_rec.active_start_date := fnd_api.g_miss_date;

1560: -- Now grab the child instances instance_party_id
1561: BEGIN
1562: l_cld_party_rec := l_new_curr_party_rec;
1563: l_cld_party_id := null;
1564: l_cld_party_rec.active_start_date := fnd_api.g_miss_date;
1565: l_cld_party_rec.active_end_date := fnd_api.g_miss_date;
1566: SELECT instance_party_id,
1567: instance_id,
1568: party_id,

Line 1565: l_cld_party_rec.active_end_date := fnd_api.g_miss_date;

1561: BEGIN
1562: l_cld_party_rec := l_new_curr_party_rec;
1563: l_cld_party_id := null;
1564: l_cld_party_rec.active_start_date := fnd_api.g_miss_date;
1565: l_cld_party_rec.active_end_date := fnd_api.g_miss_date;
1566: SELECT instance_party_id,
1567: instance_id,
1568: party_id,
1569: object_version_number

Line 1600: -- cascade_ownership_flag=fnd_api.g_true.

1596:
1597: -- The following is modified for cascade bug 2972082
1598: -- to make sure parties were updated only for new party
1599: -- which is different from the original party if
1600: -- cascade_ownership_flag=fnd_api.g_true.
1601: /*
1602: IF l_cld_party_rec.instance_party_id IS NOT NULL AND
1603: l_cld_party_rec.instance_party_id <> fnd_api.g_miss_num AND
1604: ((l_cld_party_id = l_old_party_tbl(l_old_party_row).party_id AND

Line 1603: l_cld_party_rec.instance_party_id <> fnd_api.g_miss_num AND

1599: -- which is different from the original party if
1600: -- cascade_ownership_flag=fnd_api.g_true.
1601: /*
1602: IF l_cld_party_rec.instance_party_id IS NOT NULL AND
1603: l_cld_party_rec.instance_party_id <> fnd_api.g_miss_num AND
1604: ((l_cld_party_id = l_old_party_tbl(l_old_party_row).party_id AND
1605: l_cld_party_id <> l_cld_party_rec.party_id)
1606: OR
1607: (l_cld_party_id <> l_old_party_tbl(l_old_party_row).party_id AND

Line 1628: l_cld_party_rec.instance_party_id <> fnd_api.g_miss_num AND

1624: l_old_child_owner_pty_acct_id := NULL;
1625: END;
1626: END IF;
1627: IF l_cld_party_rec.instance_party_id IS NOT NULL AND
1628: l_cld_party_rec.instance_party_id <> fnd_api.g_miss_num AND
1629: ((l_cld_party_id = l_old_party_tbl(l_old_party_row).party_id AND
1630: l_cld_party_id <> l_cld_party_rec.party_id)
1631: OR
1632: (l_cld_party_id = l_old_party_tbl(l_old_party_row).party_id AND

Line 1635: l_old_parent_owner_pty_acct_id <> fnd_api.g_miss_num AND

1631: OR
1632: (l_cld_party_id = l_old_party_tbl(l_old_party_row).party_id AND
1633: l_cld_party_id = l_cld_party_rec.party_id AND
1634: l_old_parent_owner_pty_acct_id IS NOT NULL AND
1635: l_old_parent_owner_pty_acct_id <> fnd_api.g_miss_num AND
1636: l_old_child_owner_pty_acct_id IS NOT NULL AND
1637: l_old_child_owner_pty_acct_id <> fnd_api.g_miss_num AND
1638: l_old_child_owner_pty_acct_id = l_old_parent_owner_pty_acct_id AND
1639: l_old_child_owner_pty_acct_id <> l_new_ip_acct_rec.party_account_id)

Line 1637: l_old_child_owner_pty_acct_id <> fnd_api.g_miss_num AND

1633: l_cld_party_id = l_cld_party_rec.party_id AND
1634: l_old_parent_owner_pty_acct_id IS NOT NULL AND
1635: l_old_parent_owner_pty_acct_id <> fnd_api.g_miss_num AND
1636: l_old_child_owner_pty_acct_id IS NOT NULL AND
1637: l_old_child_owner_pty_acct_id <> fnd_api.g_miss_num AND
1638: l_old_child_owner_pty_acct_id = l_old_parent_owner_pty_acct_id AND
1639: l_old_child_owner_pty_acct_id <> l_new_ip_acct_rec.party_account_id)
1640: OR
1641: (l_cld_party_id <> l_old_party_tbl(l_old_party_row).party_id AND

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

1655: ,x_return_status => x_return_status
1656: ,x_msg_count => x_msg_count
1657: ,x_msg_data => x_msg_data ) ;
1658:
1659: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1660: l_msg_index := 1;
1661: l_msg_count := x_msg_count;
1662: WHILE l_msg_count > 0 LOOP
1663: x_msg_data := FND_MSG_PUB.GET(

Line 1665: FND_API.G_FALSE );

1661: l_msg_count := x_msg_count;
1662: WHILE l_msg_count > 0 LOOP
1663: x_msg_data := FND_MSG_PUB.GET(
1664: l_msg_index,
1665: FND_API.G_FALSE );
1666: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1667: l_msg_index := l_msg_index + 1;
1668: l_msg_count := l_msg_count - 1;
1669: END LOOP;

Line 1670: RAISE FND_API.G_EXC_ERROR;

1666: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1667: l_msg_index := l_msg_index + 1;
1668: l_msg_count := l_msg_count - 1;
1669: END LOOP;
1670: RAISE FND_API.G_EXC_ERROR;
1671: END IF;
1672:
1673: --added may15
1674: -- Added by sguthiva for bug 2307804

Line 1694: p_txn_rec.src_txn_creation_date = FND_API.G_MISS_DATE THEN

1690: l_exp_party_rec.object_version_number := l_exp_pty.object_version_number;
1691: -- Bug 3804960
1692: -- srramakr Need to use the same the date used by the item instance
1693: IF p_txn_rec.src_txn_creation_date IS NULL OR
1694: p_txn_rec.src_txn_creation_date = FND_API.G_MISS_DATE THEN
1695: l_exp_party_rec.active_end_date := sysdate;
1696: ELSE
1697: l_exp_party_rec.active_end_date := p_txn_rec.src_txn_creation_date;
1698: END IF;

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

1707: ,x_return_status => x_return_status
1708: ,x_msg_count => x_msg_count
1709: ,x_msg_data => x_msg_data ) ;
1710:
1711: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1712: l_msg_index := 1;
1713: l_msg_count := x_msg_count;
1714: WHILE l_msg_count > 0
1715: LOOP

Line 1718: FND_API.G_FALSE );

1714: WHILE l_msg_count > 0
1715: LOOP
1716: x_msg_data := FND_MSG_PUB.GET(
1717: l_msg_index,
1718: FND_API.G_FALSE );
1719: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1720: l_msg_index := l_msg_index + 1;
1721: l_msg_count := l_msg_count - 1;
1722: END LOOP;

Line 1723: RAISE FND_API.G_EXC_ERROR;

1719: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1720: l_msg_index := l_msg_index + 1;
1721: l_msg_count := l_msg_count - 1;
1722: END LOOP;
1723: RAISE FND_API.G_EXC_ERROR;
1724: END IF;
1725: END LOOP;
1726: END IF;
1727: --End addition for bug 3294748

Line 1742: p_txn_rec.src_txn_creation_date = FND_API.G_MISS_DATE THEN

1738: AND relationship_type_code ='OWNER';
1739: -- Bug 3804960
1740: -- srramakr Need to use the same the date used by the item instance
1741: IF p_txn_rec.src_txn_creation_date IS NULL OR
1742: p_txn_rec.src_txn_creation_date = FND_API.G_MISS_DATE THEN
1743: l_exp_acct_rec.active_end_date := sysdate;
1744: ELSE
1745: l_exp_acct_rec.active_end_date := p_txn_rec.src_txn_creation_date;
1746: END IF;

Line 1748: l_exp_acct_rec.expire_flag :=fnd_api.g_true;

1744: ELSE
1745: l_exp_acct_rec.active_end_date := p_txn_rec.src_txn_creation_date;
1746: END IF;
1747: -- End of 3804960
1748: l_exp_acct_rec.expire_flag :=fnd_api.g_true;
1749: EXCEPTION
1750: WHEN OTHERS THEN
1751: NULL;
1752: END;

Line 1755: AND l_exp_acct_rec.ip_account_id <> fnd_api.g_miss_num

1751: NULL;
1752: END;
1753:
1754: IF l_exp_acct_rec.ip_account_id IS NOT NULL
1755: AND l_exp_acct_rec.ip_account_id <> fnd_api.g_miss_num
1756: THEN
1757: l_exp_acct_rec.grp_call_contracts := l_grp_call_contracts;
1758: csi_party_relationships_pvt.update_inst_party_account
1759: ( p_api_version => p_api_version

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

1766: ,x_return_status => x_return_status
1767: ,x_msg_count => x_msg_count
1768: ,x_msg_data => x_msg_data);
1769:
1770: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1771: l_msg_index := 1;
1772: l_msg_count := x_msg_count;
1773: WHILE l_msg_count > 0 LOOP
1774: x_msg_data := FND_MSG_PUB.GET(

Line 1776: FND_API.G_FALSE );

1772: l_msg_count := x_msg_count;
1773: WHILE l_msg_count > 0 LOOP
1774: x_msg_data := FND_MSG_PUB.GET(
1775: l_msg_index,
1776: FND_API.G_FALSE );
1777: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1778: l_msg_index := l_msg_index + 1;
1779: l_msg_count := l_msg_count - 1;
1780: END LOOP;

Line 1781: RAISE FND_API.G_EXC_ERROR;

1777: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1778: l_msg_index := l_msg_index + 1;
1779: l_msg_count := l_msg_count - 1;
1780: END LOOP;
1781: RAISE FND_API.G_EXC_ERROR;
1782: END IF;
1783: END IF;
1784: END IF;
1785: -- End addition by sguthiva for bug 2307804

Line 1789: l_ip_acct_rec.instance_party_id <> fnd_api.g_miss_num

1785: -- End addition by sguthiva for bug 2307804
1786: IF l_cld_party_rec.party_id <> l_internal_party_id
1787: THEN
1788: IF l_ip_acct_rec.instance_party_id IS NOT NULL AND
1789: l_ip_acct_rec.instance_party_id <> fnd_api.g_miss_num
1790: THEN
1791: l_ip_acct_rec:=l_new_ip_acct_rec; -- added for 2608706
1792: l_ip_acct_rec.instance_party_id := l_cld_party_rec.instance_party_id;
1793: l_ip_acct_rec.ip_account_id := fnd_api.g_miss_num;

Line 1793: l_ip_acct_rec.ip_account_id := fnd_api.g_miss_num;

1789: l_ip_acct_rec.instance_party_id <> fnd_api.g_miss_num
1790: THEN
1791: l_ip_acct_rec:=l_new_ip_acct_rec; -- added for 2608706
1792: l_ip_acct_rec.instance_party_id := l_cld_party_rec.instance_party_id;
1793: l_ip_acct_rec.ip_account_id := fnd_api.g_miss_num;
1794: -- srramakr Bug 3621181 need to cascade Bill_to and Ship_to address to the children
1795: -- l_ip_acct_rec.bill_to_address := fnd_api.g_miss_num;
1796: -- l_ip_acct_rec.ship_to_address := fnd_api.g_miss_num;
1797: l_ip_acct_rec.active_start_date := fnd_api.g_miss_date; -- added for 2608706

Line 1795: -- l_ip_acct_rec.bill_to_address := fnd_api.g_miss_num;

1791: l_ip_acct_rec:=l_new_ip_acct_rec; -- added for 2608706
1792: l_ip_acct_rec.instance_party_id := l_cld_party_rec.instance_party_id;
1793: l_ip_acct_rec.ip_account_id := fnd_api.g_miss_num;
1794: -- srramakr Bug 3621181 need to cascade Bill_to and Ship_to address to the children
1795: -- l_ip_acct_rec.bill_to_address := fnd_api.g_miss_num;
1796: -- l_ip_acct_rec.ship_to_address := fnd_api.g_miss_num;
1797: l_ip_acct_rec.active_start_date := fnd_api.g_miss_date; -- added for 2608706
1798: l_ip_acct_rec.active_end_date := fnd_api.g_miss_date; -- added for 2608706
1799: l_ip_acct_rec.grp_call_contracts := l_grp_call_contracts;

Line 1796: -- l_ip_acct_rec.ship_to_address := fnd_api.g_miss_num;

1792: l_ip_acct_rec.instance_party_id := l_cld_party_rec.instance_party_id;
1793: l_ip_acct_rec.ip_account_id := fnd_api.g_miss_num;
1794: -- srramakr Bug 3621181 need to cascade Bill_to and Ship_to address to the children
1795: -- l_ip_acct_rec.bill_to_address := fnd_api.g_miss_num;
1796: -- l_ip_acct_rec.ship_to_address := fnd_api.g_miss_num;
1797: l_ip_acct_rec.active_start_date := fnd_api.g_miss_date; -- added for 2608706
1798: l_ip_acct_rec.active_end_date := fnd_api.g_miss_date; -- added for 2608706
1799: l_ip_acct_rec.grp_call_contracts := l_grp_call_contracts;
1800: -- Added the following code for bug 2972082

Line 1797: l_ip_acct_rec.active_start_date := fnd_api.g_miss_date; -- added for 2608706

1793: l_ip_acct_rec.ip_account_id := fnd_api.g_miss_num;
1794: -- srramakr Bug 3621181 need to cascade Bill_to and Ship_to address to the children
1795: -- l_ip_acct_rec.bill_to_address := fnd_api.g_miss_num;
1796: -- l_ip_acct_rec.ship_to_address := fnd_api.g_miss_num;
1797: l_ip_acct_rec.active_start_date := fnd_api.g_miss_date; -- added for 2608706
1798: l_ip_acct_rec.active_end_date := fnd_api.g_miss_date; -- added for 2608706
1799: l_ip_acct_rec.grp_call_contracts := l_grp_call_contracts;
1800: -- Added the following code for bug 2972082
1801: IF nvl(l_old_party_tbl(l_old_party_row).cascade_ownership_flag,'N')='Y'

Line 1798: l_ip_acct_rec.active_end_date := fnd_api.g_miss_date; -- added for 2608706

1794: -- srramakr Bug 3621181 need to cascade Bill_to and Ship_to address to the children
1795: -- l_ip_acct_rec.bill_to_address := fnd_api.g_miss_num;
1796: -- l_ip_acct_rec.ship_to_address := fnd_api.g_miss_num;
1797: l_ip_acct_rec.active_start_date := fnd_api.g_miss_date; -- added for 2608706
1798: l_ip_acct_rec.active_end_date := fnd_api.g_miss_date; -- added for 2608706
1799: l_ip_acct_rec.grp_call_contracts := l_grp_call_contracts;
1800: -- Added the following code for bug 2972082
1801: IF nvl(l_old_party_tbl(l_old_party_row).cascade_ownership_flag,'N')='Y'
1802: AND l_cld_party_id <> l_cld_party_rec.party_id

Line 1811: l_ip_acct_rec.system_id := fnd_api.g_miss_num;

1807: -- End of addition for bug 2972082
1808: -- Need to pass the system_id for components also if the Xfer of ownership is
1809: -- initiated from xfer of system. This will be true if both parent and child instances
1810: -- belong to the same system.
1811: l_ip_acct_rec.system_id := fnd_api.g_miss_num;
1812: --
1813: IF p_party_account_tbl.EXISTS(1) AND
1814: p_party_account_tbl(1).system_id IS NOT NULL AND
1815: p_party_account_tbl(1).system_id <> FND_API.G_MISS_NUM AND

Line 1815: p_party_account_tbl(1).system_id <> FND_API.G_MISS_NUM AND

1811: l_ip_acct_rec.system_id := fnd_api.g_miss_num;
1812: --
1813: IF p_party_account_tbl.EXISTS(1) AND
1814: p_party_account_tbl(1).system_id IS NOT NULL AND
1815: p_party_account_tbl(1).system_id <> FND_API.G_MISS_NUM AND
1816: NVL(p_party_account_tbl(1).relationship_type_code,FND_API.G_MISS_CHAR) = 'OWNER' THEN
1817: Begin
1818: select system_id
1819: into l_ip_acct_rec.system_id

Line 1816: NVL(p_party_account_tbl(1).relationship_type_code,FND_API.G_MISS_CHAR) = 'OWNER' THEN

1812: --
1813: IF p_party_account_tbl.EXISTS(1) AND
1814: p_party_account_tbl(1).system_id IS NOT NULL AND
1815: p_party_account_tbl(1).system_id <> FND_API.G_MISS_NUM AND
1816: NVL(p_party_account_tbl(1).relationship_type_code,FND_API.G_MISS_CHAR) = 'OWNER' THEN
1817: Begin
1818: select system_id
1819: into l_ip_acct_rec.system_id
1820: from csi_item_instances

Line 1822: and nvl(system_id,fnd_api.g_miss_num) = p_party_account_tbl(1).system_id;

1818: select system_id
1819: into l_ip_acct_rec.system_id
1820: from csi_item_instances
1821: where instance_id = l_rel_tbl(j).subject_id
1822: and nvl(system_id,fnd_api.g_miss_num) = p_party_account_tbl(1).system_id;
1823: Exception
1824: when no_data_found then
1825: l_ip_acct_rec.system_id := fnd_api.g_miss_num;
1826: End;

Line 1825: l_ip_acct_rec.system_id := fnd_api.g_miss_num;

1821: where instance_id = l_rel_tbl(j).subject_id
1822: and nvl(system_id,fnd_api.g_miss_num) = p_party_account_tbl(1).system_id;
1823: Exception
1824: when no_data_found then
1825: l_ip_acct_rec.system_id := fnd_api.g_miss_num;
1826: End;
1827: END IF;
1828: csi_party_relationships_pvt.create_inst_party_account
1829: ( p_api_version => p_api_version

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

1841: ,p_account_count_rec => l_account_count_rec
1842: ,p_oks_txn_inst_tbl => p_oks_txn_inst_tbl
1843: );
1844:
1845: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1846: l_msg_index := 1;
1847: l_msg_count := x_msg_count;
1848: WHILE l_msg_count > 0 LOOP
1849: x_msg_data := FND_MSG_PUB.GET(

Line 1851: FND_API.G_FALSE );

1847: l_msg_count := x_msg_count;
1848: WHILE l_msg_count > 0 LOOP
1849: x_msg_data := FND_MSG_PUB.GET(
1850: l_msg_index,
1851: FND_API.G_FALSE );
1852: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1853: l_msg_index := l_msg_index + 1;
1854: l_msg_count := l_msg_count - 1;
1855: END LOOP;

Line 1856: RAISE FND_API.G_EXC_ERROR;

1852: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1853: l_msg_index := l_msg_index + 1;
1854: l_msg_count := l_msg_count - 1;
1855: END LOOP;
1856: RAISE FND_API.G_EXC_ERROR;
1857: END IF;
1858: END IF;
1859: END IF;
1860: -- End commentation by sguthiva for bug 2307804

Line 1878: IF FND_API.To_Boolean( p_commit ) THEN

1874: -- End of API body
1875:
1876:
1877: -- Standard check of p_commit.
1878: IF FND_API.To_Boolean( p_commit ) THEN
1879: COMMIT WORK;
1880: END IF;
1881:
1882: /***** srramakr commented for bug # 3304439

Line 1895: WHEN FND_API.G_EXC_ERROR THEN

1891: FND_MSG_PUB.Count_And_Get
1892: (p_count => x_msg_count ,
1893: p_data => x_msg_data );
1894: EXCEPTION
1895: WHEN FND_API.G_EXC_ERROR THEN
1896: ROLLBACK TO update_inst_party_rel_pub;
1897: x_return_status := FND_API.G_RET_STS_ERROR ;
1898: FND_MSG_PUB.Count_And_Get
1899: ( p_count => x_msg_count,

Line 1897: x_return_status := FND_API.G_RET_STS_ERROR ;

1893: p_data => x_msg_data );
1894: EXCEPTION
1895: WHEN FND_API.G_EXC_ERROR THEN
1896: ROLLBACK TO update_inst_party_rel_pub;
1897: x_return_status := FND_API.G_RET_STS_ERROR ;
1898: FND_MSG_PUB.Count_And_Get
1899: ( p_count => x_msg_count,
1900: p_data => x_msg_data );
1901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1897: x_return_status := FND_API.G_RET_STS_ERROR ;
1898: FND_MSG_PUB.Count_And_Get
1899: ( p_count => x_msg_count,
1900: p_data => x_msg_data );
1901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1902: ROLLBACK TO update_inst_party_rel_pub;
1903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1904: FND_MSG_PUB.Count_And_Get
1905: ( p_count => x_msg_count,

Line 1903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1899: ( p_count => x_msg_count,
1900: p_data => x_msg_data );
1901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1902: ROLLBACK TO update_inst_party_rel_pub;
1903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1904: FND_MSG_PUB.Count_And_Get
1905: ( p_count => x_msg_count,
1906: p_data => x_msg_data );
1907: WHEN OTHERS THEN

Line 1909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1905: ( p_count => x_msg_count,
1906: p_data => x_msg_data );
1907: WHEN OTHERS THEN
1908: ROLLBACK TO update_inst_party_rel_pub;
1909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1910: IF FND_MSG_PUB.Check_Msg_Level
1911: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1912: THEN
1913: FND_MSG_PUB.Add_Exc_Msg

Line 1957: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1953:
1954: csi_utility_grp.check_ib_active;
1955:
1956: -- Standard call to check for call compatibility.
1957: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1958: p_api_version ,
1959: l_api_name ,
1960: g_pkg_name )
1961: THEN

Line 1962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1958: p_api_version ,
1959: l_api_name ,
1960: g_pkg_name )
1961: THEN
1962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1963: END IF;
1964:
1965: -- Initialize message list if p_init_msg_list is set to TRUE.
1966: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1966: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1963: END IF;
1964:
1965: -- Initialize message list if p_init_msg_list is set to TRUE.
1966: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1967: FND_MSG_PUB.initialize;
1968: END IF;
1969:
1970: -- Initialize API return status to success

Line 1971: x_return_status := FND_API.G_RET_STS_SUCCESS;

1967: FND_MSG_PUB.initialize;
1968: END IF;
1969:
1970: -- Initialize API return status to success
1971: x_return_status := FND_API.G_RET_STS_SUCCESS;
1972:
1973: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
1974: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
1975:

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

2011: x_return_status => x_return_status ,
2012: x_msg_count => x_msg_count ,
2013: x_msg_data => x_msg_data ) ;
2014:
2015: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2016: l_msg_index := 1;
2017: l_msg_count := x_msg_count;
2018: WHILE l_msg_count > 0 LOOP
2019: x_msg_data := FND_MSG_PUB.GET(

Line 2021: FND_API.G_FALSE );

2017: l_msg_count := x_msg_count;
2018: WHILE l_msg_count > 0 LOOP
2019: x_msg_data := FND_MSG_PUB.GET(
2020: l_msg_index,
2021: FND_API.G_FALSE );
2022: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2023: l_msg_index := l_msg_index + 1;
2024: l_msg_count := l_msg_count - 1;
2025: END LOOP;

Line 2026: RAISE FND_API.G_EXC_ERROR;

2022: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2023: l_msg_index := l_msg_index + 1;
2024: l_msg_count := l_msg_count - 1;
2025: END LOOP;
2026: RAISE FND_API.G_EXC_ERROR;
2027: END IF;
2028: END IF;
2029: END LOOP;
2030: END IF;

Line 2035: IF FND_API.To_Boolean( p_commit ) THEN

2031: --
2032: -- End of API body
2033:
2034: -- Standard check of p_commit.
2035: IF FND_API.To_Boolean( p_commit ) THEN
2036: COMMIT WORK;
2037: END IF;
2038:
2039: /***** srramakr commented for bug # 3304439

Line 2052: WHEN FND_API.G_EXC_ERROR THEN

2048: FND_MSG_PUB.Count_And_Get
2049: (p_count => x_msg_count ,
2050: p_data => x_msg_data );
2051: EXCEPTION
2052: WHEN FND_API.G_EXC_ERROR THEN
2053: ROLLBACK TO expire_inst_party_rel_pub;
2054: x_return_status := FND_API.G_RET_STS_ERROR ;
2055: FND_MSG_PUB.Count_And_Get
2056: ( p_count => x_msg_count,

Line 2054: x_return_status := FND_API.G_RET_STS_ERROR ;

2050: p_data => x_msg_data );
2051: EXCEPTION
2052: WHEN FND_API.G_EXC_ERROR THEN
2053: ROLLBACK TO expire_inst_party_rel_pub;
2054: x_return_status := FND_API.G_RET_STS_ERROR ;
2055: FND_MSG_PUB.Count_And_Get
2056: ( p_count => x_msg_count,
2057: p_data => x_msg_data );
2058:

Line 2059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2055: FND_MSG_PUB.Count_And_Get
2056: ( p_count => x_msg_count,
2057: p_data => x_msg_data );
2058:
2059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2060: ROLLBACK TO expire_inst_party_rel_pub;
2061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2062: FND_MSG_PUB.Count_And_Get
2063: ( p_count => x_msg_count,

Line 2061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2057: p_data => x_msg_data );
2058:
2059: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2060: ROLLBACK TO expire_inst_party_rel_pub;
2061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2062: FND_MSG_PUB.Count_And_Get
2063: ( p_count => x_msg_count,
2064: p_data => x_msg_data );
2065:

Line 2068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2064: p_data => x_msg_data );
2065:
2066: WHEN OTHERS THEN
2067: ROLLBACK TO expire_inst_party_relationship;
2068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2069: IF FND_MSG_PUB.Check_Msg_Level
2070: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2071: THEN
2072: FND_MSG_PUB.Add_Exc_Msg

Line 2132: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2128: csi_utility_grp.check_ib_active;
2129:
2130:
2131: -- Standard call to check for call compatibility.
2132: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2133: p_api_version ,
2134: l_api_name ,
2135: g_pkg_name )
2136: THEN

Line 2137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2133: p_api_version ,
2134: l_api_name ,
2135: g_pkg_name )
2136: THEN
2137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2138: END IF;
2139:
2140: -- Initialize message list if p_init_msg_list is set to TRUE.
2141: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2141: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2138: END IF;
2139:
2140: -- Initialize message list if p_init_msg_list is set to TRUE.
2141: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2142: FND_MSG_PUB.initialize;
2143: END IF;
2144:
2145: -- Initialize API return status to success

Line 2146: x_return_status := FND_API.G_RET_STS_SUCCESS;

2142: FND_MSG_PUB.initialize;
2143: END IF;
2144:
2145: -- Initialize API return status to success
2146: x_return_status := FND_API.G_RET_STS_SUCCESS;
2147:
2148: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
2149: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2150:

Line 2178: IF (p_account_query_rec.ip_account_id = FND_API.G_MISS_NUM)

2174: ****/
2175:
2176: -- Start API body
2177: --
2178: IF (p_account_query_rec.ip_account_id = FND_API.G_MISS_NUM)
2179: AND (p_account_query_rec.instance_party_id = FND_API.G_MISS_NUM)
2180: AND (p_account_query_rec.party_account_id = FND_API.G_MISS_NUM)
2181: AND (p_account_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
2182:

Line 2179: AND (p_account_query_rec.instance_party_id = FND_API.G_MISS_NUM)

2175:
2176: -- Start API body
2177: --
2178: IF (p_account_query_rec.ip_account_id = FND_API.G_MISS_NUM)
2179: AND (p_account_query_rec.instance_party_id = FND_API.G_MISS_NUM)
2180: AND (p_account_query_rec.party_account_id = FND_API.G_MISS_NUM)
2181: AND (p_account_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
2182:
2183: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');

Line 2180: AND (p_account_query_rec.party_account_id = FND_API.G_MISS_NUM)

2176: -- Start API body
2177: --
2178: IF (p_account_query_rec.ip_account_id = FND_API.G_MISS_NUM)
2179: AND (p_account_query_rec.instance_party_id = FND_API.G_MISS_NUM)
2180: AND (p_account_query_rec.party_account_id = FND_API.G_MISS_NUM)
2181: AND (p_account_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
2182:
2183: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
2184: FND_MSG_PUB.ADD;

Line 2181: AND (p_account_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN

2177: --
2178: IF (p_account_query_rec.ip_account_id = FND_API.G_MISS_NUM)
2179: AND (p_account_query_rec.instance_party_id = FND_API.G_MISS_NUM)
2180: AND (p_account_query_rec.party_account_id = FND_API.G_MISS_NUM)
2181: AND (p_account_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
2182:
2183: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
2184: FND_MSG_PUB.ADD;
2185: RAISE FND_API.G_EXC_ERROR;

Line 2185: RAISE FND_API.G_EXC_ERROR;

2181: AND (p_account_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
2182:
2183: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
2184: FND_MSG_PUB.ADD;
2185: RAISE FND_API.G_EXC_ERROR;
2186: END IF;
2187:
2188: -- Generate the where clause
2189: csi_party_relationships_pvt.Gen_Acct_Where_Clause

Line 2221: IF ((p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE)) THEN

2217:
2218: -- Close the cursor
2219: DBMS_SQL.CLOSE_CURSOR(l_get_acct_cursor_id);
2220:
2221: IF ((p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE)) THEN
2222: IF p_time_stamp <= sysdate THEN
2223: -- Contruct from the history if p_time_stamp is less than sysdate
2224: csi_party_relationships_pvt.Construct_acct_from_hist(x_account_header_tbl, p_time_stamp);
2225: ELSE

Line 2228: RAISE FND_API.G_EXC_ERROR;

2224: csi_party_relationships_pvt.Construct_acct_from_hist(x_account_header_tbl, p_time_stamp);
2225: ELSE
2226: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
2227: FND_MSG_PUB.ADD;
2228: RAISE FND_API.G_EXC_ERROR;
2229: END IF;
2230: END IF;
2231:
2232: -- foreign key resolution for the id columns

Line 2233: IF p_resolve_id_columns = fnd_api.g_true THEN

2229: END IF;
2230: END IF;
2231:
2232: -- foreign key resolution for the id columns
2233: IF p_resolve_id_columns = fnd_api.g_true THEN
2234: IF x_account_header_tbl.count > 0 THEN
2235: l_account_header_tbl := x_account_header_tbl;
2236: csi_party_relationships_pvt.Resolve_id_columns(l_account_header_tbl);
2237:

Line 2247: IF FND_API.To_Boolean( p_commit ) THEN

2243: -- End of API body
2244:
2245: -- Standard check of p_commit.
2246: /*
2247: IF FND_API.To_Boolean( p_commit ) THEN
2248: COMMIT WORK;
2249: END IF;
2250: */
2251:

Line 2265: WHEN FND_API.G_EXC_ERROR THEN

2261: FND_MSG_PUB.Count_And_Get
2262: (p_count => x_msg_count ,
2263: p_data => x_msg_data );
2264: EXCEPTION
2265: WHEN FND_API.G_EXC_ERROR THEN
2266: -- ROLLBACK TO get_inst_party_acct_pub;
2267: x_return_status := FND_API.G_RET_STS_ERROR ;
2268: FND_MSG_PUB.Count_And_Get
2269: ( p_count => x_msg_count,

Line 2267: x_return_status := FND_API.G_RET_STS_ERROR ;

2263: p_data => x_msg_data );
2264: EXCEPTION
2265: WHEN FND_API.G_EXC_ERROR THEN
2266: -- ROLLBACK TO get_inst_party_acct_pub;
2267: x_return_status := FND_API.G_RET_STS_ERROR ;
2268: FND_MSG_PUB.Count_And_Get
2269: ( p_count => x_msg_count,
2270: p_data => x_msg_data );
2271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2267: x_return_status := FND_API.G_RET_STS_ERROR ;
2268: FND_MSG_PUB.Count_And_Get
2269: ( p_count => x_msg_count,
2270: p_data => x_msg_data );
2271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2272: -- ROLLBACK TO get_inst_party_acct_pub;
2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2274: FND_MSG_PUB.Count_And_Get
2275: ( p_count => x_msg_count,

Line 2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2269: ( p_count => x_msg_count,
2270: p_data => x_msg_data );
2271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2272: -- ROLLBACK TO get_inst_party_acct_pub;
2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2274: FND_MSG_PUB.Count_And_Get
2275: ( p_count => x_msg_count,
2276: p_data => x_msg_data );
2277: WHEN OTHERS THEN

Line 2282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2278: IF dbms_sql.is_open(l_get_acct_cursor_id) then
2279: dbms_sql.close_cursor(l_get_acct_cursor_id);
2280: END IF;
2281: -- ROLLBACK TO get_inst_party_acct_pub;
2282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2283: IF FND_MSG_PUB.Check_Msg_Level
2284: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2285: THEN
2286: FND_MSG_PUB.Add_Exc_Msg

Line 2337: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2333: csi_utility_grp.check_ib_active;
2334:
2335:
2336: -- Standard call to check for call compatibility.
2337: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2338: p_api_version ,
2339: l_api_name ,
2340: g_pkg_name )
2341: THEN

Line 2342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2338: p_api_version ,
2339: l_api_name ,
2340: g_pkg_name )
2341: THEN
2342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2343: END IF;
2344:
2345: -- Initialize message list if p_init_msg_list is set to TRUE.
2346: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2346: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2343: END IF;
2344:
2345: -- Initialize message list if p_init_msg_list is set to TRUE.
2346: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2347: FND_MSG_PUB.initialize;
2348: END IF;
2349:
2350: -- Initialize API return status to success

Line 2351: x_return_status := FND_API.G_RET_STS_SUCCESS;

2347: FND_MSG_PUB.initialize;
2348: END IF;
2349:
2350: -- Initialize API return status to success
2351: x_return_status := FND_API.G_RET_STS_SUCCESS;
2352:
2353: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
2354: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2355:

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

2399: ,p_account_count_rec => l_account_count_rec
2400: ,p_oks_txn_inst_tbl => px_oks_txn_inst_tbl
2401: );
2402:
2403: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2404: l_msg_index := 1;
2405: l_msg_count := x_msg_count;
2406: WHILE l_msg_count > 0 LOOP
2407: x_msg_data := FND_MSG_PUB.GET(

Line 2409: FND_API.G_FALSE );

2405: l_msg_count := x_msg_count;
2406: WHILE l_msg_count > 0 LOOP
2407: x_msg_data := FND_MSG_PUB.GET(
2408: l_msg_index,
2409: FND_API.G_FALSE );
2410: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
2411: l_msg_index := l_msg_index + 1;
2412: l_msg_count := l_msg_count - 1;
2413: END LOOP;

Line 2414: RAISE FND_API.G_EXC_ERROR;

2410: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
2411: l_msg_index := l_msg_index + 1;
2412: l_msg_count := l_msg_count - 1;
2413: END LOOP;
2414: RAISE FND_API.G_EXC_ERROR;
2415: END IF;
2416: END IF;
2417: END LOOP;
2418: END IF;

Line 2423: IF FND_API.To_Boolean( p_commit ) THEN

2419: --
2420: -- End of API body
2421:
2422: -- Standard check of p_commit.
2423: IF FND_API.To_Boolean( p_commit ) THEN
2424: COMMIT WORK;
2425: END IF;
2426:
2427: /***** srramakr commented for bug # 3304439

Line 2440: WHEN FND_API.G_EXC_ERROR THEN

2436: FND_MSG_PUB.Count_And_Get
2437: (p_count => x_msg_count ,
2438: p_data => x_msg_data );
2439: EXCEPTION
2440: WHEN FND_API.G_EXC_ERROR THEN
2441: ROLLBACK TO create_inst_party_acct_pub;
2442: x_return_status := FND_API.G_RET_STS_ERROR ;
2443: FND_MSG_PUB.Count_And_Get
2444: ( p_count => x_msg_count,

Line 2442: x_return_status := FND_API.G_RET_STS_ERROR ;

2438: p_data => x_msg_data );
2439: EXCEPTION
2440: WHEN FND_API.G_EXC_ERROR THEN
2441: ROLLBACK TO create_inst_party_acct_pub;
2442: x_return_status := FND_API.G_RET_STS_ERROR ;
2443: FND_MSG_PUB.Count_And_Get
2444: ( p_count => x_msg_count,
2445: p_data => x_msg_data );
2446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2442: x_return_status := FND_API.G_RET_STS_ERROR ;
2443: FND_MSG_PUB.Count_And_Get
2444: ( p_count => x_msg_count,
2445: p_data => x_msg_data );
2446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2447: ROLLBACK TO create_inst_party_acct_pub;
2448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2449: FND_MSG_PUB.Count_And_Get
2450: ( p_count => x_msg_count,

Line 2448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2444: ( p_count => x_msg_count,
2445: p_data => x_msg_data );
2446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2447: ROLLBACK TO create_inst_party_acct_pub;
2448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2449: FND_MSG_PUB.Count_And_Get
2450: ( p_count => x_msg_count,
2451: p_data => x_msg_data );
2452: WHEN OTHERS THEN

Line 2454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2450: ( p_count => x_msg_count,
2451: p_data => x_msg_data );
2452: WHEN OTHERS THEN
2453: ROLLBACK TO create_inst_party_acct_pub;
2454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2455: IF FND_MSG_PUB.Check_Msg_Level
2456: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2457: THEN
2458: FND_MSG_PUB.Add_Exc_Msg

Line 2524: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2520: csi_utility_grp.check_ib_active;
2521:
2522:
2523: -- Standard call to check for call compatibility.
2524: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2525: p_api_version ,
2526: l_api_name ,
2527: g_pkg_name )
2528: THEN

Line 2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2525: p_api_version ,
2526: l_api_name ,
2527: g_pkg_name )
2528: THEN
2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2530: END IF;
2531:
2532: -- Initialize message list if p_init_msg_list is set to TRUE.
2533: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2533: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2530: END IF;
2531:
2532: -- Initialize message list if p_init_msg_list is set to TRUE.
2533: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2534: FND_MSG_PUB.initialize;
2535: END IF;
2536:
2537: -- Initialize API return status to success

Line 2538: x_return_status := FND_API.G_RET_STS_SUCCESS;

2534: FND_MSG_PUB.initialize;
2535: END IF;
2536:
2537: -- Initialize API return status to success
2538: x_return_status := FND_API.G_RET_STS_SUCCESS;
2539:
2540: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
2541: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2542:

Line 2572: p_party_account_tbl(l_count).ip_account_id <> fnd_api.g_miss_num

2568: IF p_party_account_tbl.count > 0 THEN
2569: FOR l_count IN p_party_account_tbl.FIRST..p_party_account_tbl.LAST LOOP
2570: IF p_party_account_tbl.EXISTS(l_count) THEN
2571: IF p_party_account_tbl(l_count).ip_account_id IS NOT NULL AND
2572: p_party_account_tbl(l_count).ip_account_id <> fnd_api.g_miss_num
2573: THEN
2574: BEGIN
2575: SELECT acct.ip_account_id,
2576: acct.party_account_id,

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

2601: ,x_return_status => x_return_status
2602: ,x_msg_count => x_msg_count
2603: ,x_msg_data => x_msg_data);
2604:
2605: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2606: l_msg_index := 1;
2607: l_msg_count := x_msg_count;
2608: WHILE l_msg_count > 0 LOOP
2609: x_msg_data := FND_MSG_PUB.GET(

Line 2611: FND_API.G_FALSE );

2607: l_msg_count := x_msg_count;
2608: WHILE l_msg_count > 0 LOOP
2609: x_msg_data := FND_MSG_PUB.GET(
2610: l_msg_index,
2611: FND_API.G_FALSE );
2612: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2613: l_msg_index := l_msg_index + 1;
2614: l_msg_count := l_msg_count - 1;
2615: END LOOP;

Line 2616: RAISE FND_API.G_EXC_ERROR;

2612: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2613: l_msg_index := l_msg_index + 1;
2614: l_msg_count := l_msg_count - 1;
2615: END LOOP;
2616: RAISE FND_API.G_EXC_ERROR;
2617: END IF;
2618: END IF;
2619: END LOOP;
2620: END IF;

Line 2650: l_party_account_tbl(l_old_party_row).party_account_id <> FND_API.G_MISS_NUM AND

2646: END LOOP;
2647: END IF;
2648:
2649: IF l_party_account_tbl(l_old_party_row).party_account_id IS NOT NULL AND
2650: l_party_account_tbl(l_old_party_row).party_account_id <> FND_API.G_MISS_NUM AND
2651: l_party_account_tbl(l_old_party_row).relationship_type_code = 'OWNER' AND
2652: old_party_account_id IS NOT NULL AND
2653: l_party_account_tbl(l_old_party_row).party_account_id <> old_party_account_id
2654: THEN

Line 2676: p_active_relationship_only => FND_API.G_TRUE,

2672: csi_ii_relationships_pvt.Get_Children
2673: ( p_relationship_query_rec => p_rel_query_rec,
2674: p_rel_tbl => l_rel_tbl,
2675: p_depth => NULL,
2676: p_active_relationship_only => FND_API.G_TRUE,
2677: p_time_stamp => FND_API.G_MISS_DATE,
2678: p_get_dfs => FND_API.G_FALSE,
2679: p_ii_relationship_level_tbl => l_ii_relationship_level_tbl,
2680: x_return_status => x_return_status,

Line 2677: p_time_stamp => FND_API.G_MISS_DATE,

2673: ( p_relationship_query_rec => p_rel_query_rec,
2674: p_rel_tbl => l_rel_tbl,
2675: p_depth => NULL,
2676: p_active_relationship_only => FND_API.G_TRUE,
2677: p_time_stamp => FND_API.G_MISS_DATE,
2678: p_get_dfs => FND_API.G_FALSE,
2679: p_ii_relationship_level_tbl => l_ii_relationship_level_tbl,
2680: x_return_status => x_return_status,
2681: x_msg_count => x_msg_count,

Line 2678: p_get_dfs => FND_API.G_FALSE,

2674: p_rel_tbl => l_rel_tbl,
2675: p_depth => NULL,
2676: p_active_relationship_only => FND_API.G_TRUE,
2677: p_time_stamp => FND_API.G_MISS_DATE,
2678: p_get_dfs => FND_API.G_FALSE,
2679: p_ii_relationship_level_tbl => l_ii_relationship_level_tbl,
2680: x_return_status => x_return_status,
2681: x_msg_count => x_msg_count,
2682: x_msg_data => x_msg_data

Line 2685: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2681: x_msg_count => x_msg_count,
2682: x_msg_data => x_msg_data
2683: );
2684: --
2685: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2686: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
2687: FND_MSG_PUB.Add;
2688: RAISE FND_API.G_EXC_ERROR;
2689: END IF;

Line 2688: RAISE FND_API.G_EXC_ERROR;

2684: --
2685: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2686: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
2687: FND_MSG_PUB.Add;
2688: RAISE FND_API.G_EXC_ERROR;
2689: END IF;
2690: --
2691: IF l_rel_tbl.count > 0 THEN
2692: FOR j in l_rel_tbl.FIRST .. l_rel_tbl.LAST LOOP

Line 2694: l_party_account_tbl(l_old_party_row).ip_account_id := fnd_api.g_miss_num;

2690: --
2691: IF l_rel_tbl.count > 0 THEN
2692: FOR j in l_rel_tbl.FIRST .. l_rel_tbl.LAST LOOP
2693: -- FOR l_pty_acct_csr IN party_account_csr(l_party_account_tbl(l_old_party_row).instance_party_id)
2694: l_party_account_tbl(l_old_party_row).ip_account_id := fnd_api.g_miss_num;
2695: l_party_account_tbl(l_old_party_row).instance_party_id := fnd_api.g_miss_num;
2696: l_party_account_tbl(l_old_party_row).object_version_number := fnd_api.g_miss_num;
2697: l_party_account_tbl(l_old_party_row).active_start_date :=fnd_api.g_miss_date;
2698: l_party_account_tbl(l_old_party_row).active_end_date :=fnd_api.g_miss_date;

Line 2695: l_party_account_tbl(l_old_party_row).instance_party_id := fnd_api.g_miss_num;

2691: IF l_rel_tbl.count > 0 THEN
2692: FOR j in l_rel_tbl.FIRST .. l_rel_tbl.LAST LOOP
2693: -- FOR l_pty_acct_csr IN party_account_csr(l_party_account_tbl(l_old_party_row).instance_party_id)
2694: l_party_account_tbl(l_old_party_row).ip_account_id := fnd_api.g_miss_num;
2695: l_party_account_tbl(l_old_party_row).instance_party_id := fnd_api.g_miss_num;
2696: l_party_account_tbl(l_old_party_row).object_version_number := fnd_api.g_miss_num;
2697: l_party_account_tbl(l_old_party_row).active_start_date :=fnd_api.g_miss_date;
2698: l_party_account_tbl(l_old_party_row).active_end_date :=fnd_api.g_miss_date;
2699: BEGIN

Line 2696: l_party_account_tbl(l_old_party_row).object_version_number := fnd_api.g_miss_num;

2692: FOR j in l_rel_tbl.FIRST .. l_rel_tbl.LAST LOOP
2693: -- FOR l_pty_acct_csr IN party_account_csr(l_party_account_tbl(l_old_party_row).instance_party_id)
2694: l_party_account_tbl(l_old_party_row).ip_account_id := fnd_api.g_miss_num;
2695: l_party_account_tbl(l_old_party_row).instance_party_id := fnd_api.g_miss_num;
2696: l_party_account_tbl(l_old_party_row).object_version_number := fnd_api.g_miss_num;
2697: l_party_account_tbl(l_old_party_row).active_start_date :=fnd_api.g_miss_date;
2698: l_party_account_tbl(l_old_party_row).active_end_date :=fnd_api.g_miss_date;
2699: BEGIN
2700: l_party_id := NULL;

Line 2697: l_party_account_tbl(l_old_party_row).active_start_date :=fnd_api.g_miss_date;

2693: -- FOR l_pty_acct_csr IN party_account_csr(l_party_account_tbl(l_old_party_row).instance_party_id)
2694: l_party_account_tbl(l_old_party_row).ip_account_id := fnd_api.g_miss_num;
2695: l_party_account_tbl(l_old_party_row).instance_party_id := fnd_api.g_miss_num;
2696: l_party_account_tbl(l_old_party_row).object_version_number := fnd_api.g_miss_num;
2697: l_party_account_tbl(l_old_party_row).active_start_date :=fnd_api.g_miss_date;
2698: l_party_account_tbl(l_old_party_row).active_end_date :=fnd_api.g_miss_date;
2699: BEGIN
2700: l_party_id := NULL;
2701: SELECT acct.ip_account_id,

Line 2698: l_party_account_tbl(l_old_party_row).active_end_date :=fnd_api.g_miss_date;

2694: l_party_account_tbl(l_old_party_row).ip_account_id := fnd_api.g_miss_num;
2695: l_party_account_tbl(l_old_party_row).instance_party_id := fnd_api.g_miss_num;
2696: l_party_account_tbl(l_old_party_row).object_version_number := fnd_api.g_miss_num;
2697: l_party_account_tbl(l_old_party_row).active_start_date :=fnd_api.g_miss_date;
2698: l_party_account_tbl(l_old_party_row).active_end_date :=fnd_api.g_miss_date;
2699: BEGIN
2700: l_party_id := NULL;
2701: SELECT acct.ip_account_id,
2702: acct.object_version_number,

Line 2720: l_party_account_tbl(l_old_party_row).ip_account_id <> fnd_api.g_miss_num AND

2716: NULL;
2717: END;
2718: --
2719: IF l_party_account_tbl(l_old_party_row).ip_account_id IS NOT NULL AND
2720: l_party_account_tbl(l_old_party_row).ip_account_id <> fnd_api.g_miss_num AND
2721: old_party_id = l_party_id
2722: THEN
2723: csi_party_relationships_pvt.update_inst_party_account
2724: ( p_api_version => p_api_version

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

2731: ,x_return_status => x_return_status
2732: ,x_msg_count => x_msg_count
2733: ,x_msg_data => x_msg_data);
2734:
2735: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2736: l_msg_index := 1;
2737: l_msg_count := x_msg_count;
2738: WHILE l_msg_count > 0
2739: LOOP

Line 2742: FND_API.G_FALSE );

2738: WHILE l_msg_count > 0
2739: LOOP
2740: x_msg_data := FND_MSG_PUB.GET(
2741: l_msg_index,
2742: FND_API.G_FALSE );
2743: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2744: l_msg_index := l_msg_index + 1;
2745: l_msg_count := l_msg_count - 1;
2746: END LOOP;

Line 2747: RAISE FND_API.G_EXC_ERROR;

2743: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2744: l_msg_index := l_msg_index + 1;
2745: l_msg_count := l_msg_count - 1;
2746: END LOOP;
2747: RAISE FND_API.G_EXC_ERROR;
2748: END IF;
2749: END IF; -- ip_account_id not null check
2750: END LOOP; -- l_rel_tbl loop
2751: END IF; -- l_rel_tbl count check

Line 2763: IF FND_API.To_Boolean( p_commit ) THEN

2759: --
2760: -- End of API body
2761:
2762: -- Standard check of p_commit.
2763: IF FND_API.To_Boolean( p_commit ) THEN
2764: COMMIT WORK;
2765: END IF;
2766:
2767: /***** srramakr commented for bug # 3304439

Line 2780: WHEN FND_API.G_EXC_ERROR THEN

2776: FND_MSG_PUB.Count_And_Get
2777: (p_count => x_msg_count ,
2778: p_data => x_msg_data );
2779: EXCEPTION
2780: WHEN FND_API.G_EXC_ERROR THEN
2781: ROLLBACK TO update_inst_party_acct_pub;
2782: x_return_status := FND_API.G_RET_STS_ERROR ;
2783: FND_MSG_PUB.Count_And_Get
2784: ( p_count => x_msg_count,

Line 2782: x_return_status := FND_API.G_RET_STS_ERROR ;

2778: p_data => x_msg_data );
2779: EXCEPTION
2780: WHEN FND_API.G_EXC_ERROR THEN
2781: ROLLBACK TO update_inst_party_acct_pub;
2782: x_return_status := FND_API.G_RET_STS_ERROR ;
2783: FND_MSG_PUB.Count_And_Get
2784: ( p_count => x_msg_count,
2785: p_data => x_msg_data );
2786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2782: x_return_status := FND_API.G_RET_STS_ERROR ;
2783: FND_MSG_PUB.Count_And_Get
2784: ( p_count => x_msg_count,
2785: p_data => x_msg_data );
2786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2787: ROLLBACK TO update_inst_party_acct_pub;
2788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2789: FND_MSG_PUB.Count_And_Get
2790: ( p_count => x_msg_count,

Line 2788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2784: ( p_count => x_msg_count,
2785: p_data => x_msg_data );
2786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2787: ROLLBACK TO update_inst_party_acct_pub;
2788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2789: FND_MSG_PUB.Count_And_Get
2790: ( p_count => x_msg_count,
2791: p_data => x_msg_data );
2792: WHEN OTHERS THEN

Line 2794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2790: ( p_count => x_msg_count,
2791: p_data => x_msg_data );
2792: WHEN OTHERS THEN
2793: ROLLBACK TO update_inst_party_acct_pub;
2794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2795: IF FND_MSG_PUB.Check_Msg_Level
2796: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2797: THEN
2798: FND_MSG_PUB.Add_Exc_Msg

Line 2845: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2841: csi_utility_grp.check_ib_active;
2842:
2843:
2844: -- Standard call to check for call compatibility.
2845: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2846: p_api_version ,
2847: l_api_name ,
2848: g_pkg_name )
2849: THEN

Line 2850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2846: p_api_version ,
2847: l_api_name ,
2848: g_pkg_name )
2849: THEN
2850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2851: END IF;
2852:
2853: -- Initialize message list if p_init_msg_list is set to TRUE.
2854: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2854: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2851: END IF;
2852:
2853: -- Initialize message list if p_init_msg_list is set to TRUE.
2854: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2855: FND_MSG_PUB.initialize;
2856: END IF;
2857:
2858: -- Initialize API return status to success

Line 2859: x_return_status := FND_API.G_RET_STS_SUCCESS;

2855: FND_MSG_PUB.initialize;
2856: END IF;
2857:
2858: -- Initialize API return status to success
2859: x_return_status := FND_API.G_RET_STS_SUCCESS;
2860:
2861: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
2862: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2863:

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

2900: ,x_msg_count => x_msg_count
2901: ,x_msg_data => x_msg_data );
2902:
2903:
2904: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2905: l_msg_index := 1;
2906: l_msg_count := x_msg_count;
2907: WHILE l_msg_count > 0 LOOP
2908: x_msg_data := FND_MSG_PUB.GET(

Line 2910: FND_API.G_FALSE);

2906: l_msg_count := x_msg_count;
2907: WHILE l_msg_count > 0 LOOP
2908: x_msg_data := FND_MSG_PUB.GET(
2909: l_msg_index,
2910: FND_API.G_FALSE);
2911: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2912: l_msg_index := l_msg_index + 1;
2913: l_msg_count := l_msg_count - 1;
2914: END LOOP;

Line 2915: RAISE FND_API.G_EXC_ERROR;

2911: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2912: l_msg_index := l_msg_index + 1;
2913: l_msg_count := l_msg_count - 1;
2914: END LOOP;
2915: RAISE FND_API.G_EXC_ERROR;
2916: END IF;
2917: END IF;
2918: END LOOP;
2919: END IF;

Line 2924: IF FND_API.To_Boolean( p_commit ) THEN

2920: --
2921: -- End of API body
2922:
2923: -- Standard check of p_commit.
2924: IF FND_API.To_Boolean( p_commit ) THEN
2925: COMMIT WORK;
2926: END IF;
2927:
2928: /***** srramakr commented for bug # 3304439

Line 2941: WHEN FND_API.G_EXC_ERROR THEN

2937: FND_MSG_PUB.Count_And_Get
2938: (p_count => x_msg_count ,
2939: p_data => x_msg_data );
2940: EXCEPTION
2941: WHEN FND_API.G_EXC_ERROR THEN
2942: ROLLBACK TO expire_inst_party_acct_pub;
2943: x_return_status := FND_API.G_RET_STS_ERROR ;
2944: FND_MSG_PUB.Count_And_Get
2945: ( p_count => x_msg_count,

Line 2943: x_return_status := FND_API.G_RET_STS_ERROR ;

2939: p_data => x_msg_data );
2940: EXCEPTION
2941: WHEN FND_API.G_EXC_ERROR THEN
2942: ROLLBACK TO expire_inst_party_acct_pub;
2943: x_return_status := FND_API.G_RET_STS_ERROR ;
2944: FND_MSG_PUB.Count_And_Get
2945: ( p_count => x_msg_count,
2946: p_data => x_msg_data );
2947:

Line 2948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2944: FND_MSG_PUB.Count_And_Get
2945: ( p_count => x_msg_count,
2946: p_data => x_msg_data );
2947:
2948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2949: ROLLBACK TO expire_inst_party_acct_pub;
2950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2951: FND_MSG_PUB.Count_And_Get
2952: ( p_count => x_msg_count,

Line 2950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2946: p_data => x_msg_data );
2947:
2948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2949: ROLLBACK TO expire_inst_party_acct_pub;
2950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2951: FND_MSG_PUB.Count_And_Get
2952: ( p_count => x_msg_count,
2953: p_data => x_msg_data );
2954: WHEN OTHERS THEN

Line 2956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2952: ( p_count => x_msg_count,
2953: p_data => x_msg_data );
2954: WHEN OTHERS THEN
2955: ROLLBACK TO expire_inst_party_acct_pub;
2956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2957:
2958: IF FND_MSG_PUB.Check_Msg_Level
2959: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2960: THEN