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 843: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

839:
840: csi_utility_grp.check_ib_active;
841:
842: -- Standard call to check for call compatibility.
843: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
844: p_api_version ,
845: l_api_name ,
846: g_pkg_name )
847: THEN

Line 848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

844: p_api_version ,
845: l_api_name ,
846: g_pkg_name )
847: THEN
848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
849: END IF;
850:
851: -- Initialize message list if p_init_msg_list is set to TRUE.
852: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 852: IF FND_API.to_Boolean( p_init_msg_list ) THEN

848: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
849: END IF;
850:
851: -- Initialize message list if p_init_msg_list is set to TRUE.
852: IF FND_API.to_Boolean( p_init_msg_list ) THEN
853: FND_MSG_PUB.initialize;
854: END IF;
855:
856:

Line 858: x_return_status := FND_API.G_RET_STS_SUCCESS;

854: END IF;
855:
856:
857: -- Initialize API return status to success
858: x_return_status := FND_API.G_RET_STS_SUCCESS;
859:
860: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
861: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
862:

Line 893: l_grp_call_contracts := FND_API.G_FALSE;

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

Line 959: RAISE FND_API.G_EXC_ERROR;

955: --
956: IF l_internal_party_id IS NULL THEN
957: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
958: FND_MSG_PUB.ADD;
959: RAISE FND_API.G_EXC_ERROR;
960: END IF;
961: -- Check if the table is not empty
962: IF p_party_tbl.count > 0 THEN
963: FOR l_party_row IN p_party_tbl.FIRST..p_party_tbl.LAST LOOP

Line 970: RAISE FND_API.G_EXC_ERROR;

966: -- Get Current Party record
967: IF NOT(CSI_Instance_parties_vld_pvt.Get_Party_Record
968: ( p_party_tbl(l_party_row).instance_party_id,
969: l_curr_party_rec)) THEN
970: RAISE FND_API.G_EXC_ERROR;
971: END IF;
972:
973: -- Check if this is Transfer of ownership (i.e. owner to a new owner)
974: -- If so, then a new owner account is needed for the new party

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

971: END IF;
972:
973: -- Check if this is Transfer of ownership (i.e. owner to a new owner)
974: -- If so, then a new owner account is needed for the new party
975: IF ((p_party_tbl(l_party_row).PARTY_ID <> FND_API.G_MISS_NUM)
976: AND (p_party_tbl(l_party_row).PARTY_ID IS NOT NULL)
977: AND (p_party_tbl(l_party_row).party_id <> l_internal_party_id)
978: AND (p_party_tbl(l_party_row).PARTY_ID <> l_curr_party_rec.PARTY_ID)
979: AND (p_party_tbl(l_party_row).PARTY_SOURCE_TABLE = 'HZ_PARTIES')

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

989: IF p_party_account_tbl.EXISTS(l_acct_row) -- Added for bug 3776650
990: THEN
991: -- Check if the party and its accounts are mapped
992: IF ((p_party_account_tbl(l_acct_row).parent_tbl_index IS NULL)
993: OR (p_party_account_tbl(l_acct_row).parent_tbl_index = FND_API.G_MISS_NUM)
994: OR (NOT(p_party_tbl.EXISTS(p_party_account_tbl(l_acct_row).parent_tbl_index)))
995: ) THEN
996: FND_MESSAGE.SET_NAME('CSI','CSI_API_PARTY_ACCT_NOT_MAPPED');
997: FND_MSG_PUB.Add;

Line 998: RAISE FND_API.G_EXC_ERROR;

994: OR (NOT(p_party_tbl.EXISTS(p_party_account_tbl(l_acct_row).parent_tbl_index)))
995: ) THEN
996: FND_MESSAGE.SET_NAME('CSI','CSI_API_PARTY_ACCT_NOT_MAPPED');
997: FND_MSG_PUB.Add;
998: RAISE FND_API.G_EXC_ERROR;
999: END IF;
1000:
1001: IF ((p_party_account_tbl(l_acct_row).parent_tbl_index = l_party_row)
1002: AND (p_party_account_tbl(l_acct_row).relationship_type_code = 'OWNER')) THEN

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

1002: AND (p_party_account_tbl(l_acct_row).relationship_type_code = 'OWNER')) THEN
1003: l_party_has_correct_acct := TRUE;
1004: -- Check whether bill_to and ship_to are passed. If not make them null
1005: IF p_party_account_tbl(l_acct_row).bill_to_address IS NULL OR
1006: p_party_account_tbl(l_acct_row).bill_to_address = FND_API.G_MISS_NUM THEN
1007: p_party_account_tbl(l_acct_row).bill_to_address := NULL;
1008: END IF;
1009: --
1010: IF p_party_account_tbl(l_acct_row).ship_to_address IS NULL OR

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

1007: p_party_account_tbl(l_acct_row).bill_to_address := NULL;
1008: END IF;
1009: --
1010: IF p_party_account_tbl(l_acct_row).ship_to_address IS NULL OR
1011: p_party_account_tbl(l_acct_row).ship_to_address = FND_API.G_MISS_NUM THEN
1012: p_party_account_tbl(l_acct_row).ship_to_address := NULL;
1013: END IF;
1014: --
1015: END IF;

Line 1025: RAISE FND_API.G_EXC_ERROR;

1021: IF NOT l_party_has_correct_acct THEN
1022: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_OWNER_ACCT');
1023: FND_MESSAGE.SET_TOKEN('PARTY_ID',p_party_tbl(l_party_row).party_id);
1024: FND_MSG_PUB.ADD;
1025: RAISE FND_API.G_EXC_ERROR;
1026: END IF;
1027:
1028: END IF;
1029:

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

1079: IF p_party_account_tbl.EXISTS(l_row) THEN
1080: l_obj_ver_number := NULL;
1081: BEGIN
1082: IF p_party_account_tbl(l_row).ip_account_id IS NOT NULL
1083: AND p_party_account_tbl(l_row).ip_account_id <> fnd_api.g_miss_num
1084: THEN
1085: SELECT acct.object_version_number
1086: INTO l_obj_ver_number
1087: FROM csi_ip_accounts acct

Line 1094: 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)

1090: EXCEPTION
1091: WHEN OTHERS THEN
1092: l_obj_ver_number := NULL;
1093: END;
1094: 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)
1095: AND p_party_account_tbl(l_row).relationship_type_code = 'OWNER'
1096: AND p_party_account_tbl(l_row).instance_party_id = l_party_rec.instance_party_id
1097: AND p_party_account_tbl(l_row).object_version_number = l_obj_ver_number
1098: THEN

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

1114: ,x_return_status => x_return_status
1115: ,x_msg_count => x_msg_count
1116: ,x_msg_data => x_msg_data ) ;
1117:
1118: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1119: l_msg_index := 1;
1120: l_msg_count := x_msg_count;
1121: WHILE l_msg_count > 0 LOOP
1122: x_msg_data := FND_MSG_PUB.GET(

Line 1124: FND_API.G_FALSE );

1120: l_msg_count := x_msg_count;
1121: WHILE l_msg_count > 0 LOOP
1122: x_msg_data := FND_MSG_PUB.GET(
1123: l_msg_index,
1124: FND_API.G_FALSE );
1125: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1126: l_msg_index := l_msg_index + 1;
1127: l_msg_count := l_msg_count - 1;
1128: END LOOP;

Line 1129: RAISE FND_API.G_EXC_ERROR;

1125: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1126: l_msg_index := l_msg_index + 1;
1127: l_msg_count := l_msg_count - 1;
1128: END LOOP;
1129: RAISE FND_API.G_EXC_ERROR;
1130: ELSE
1131: -- Grab the new party rec
1132: l_party_tbl(l_party_row) := l_party_rec;
1133: END IF;

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

1144:
1145:
1146: IF ( (p_party_account_tbl(l_acct_row).ip_account_id IS NULL)
1147: OR
1148: (p_party_account_tbl(l_acct_row).ip_account_id = FND_API.G_MISS_NUM) ) THEN
1149: -- Call Private package to validate and create party accounts
1150: csi_party_relationships_pvt.create_inst_party_account
1151: ( p_api_version => p_api_version
1152: ,p_commit => p_commit

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

1227: ,x_msg_count => x_msg_count
1228: ,x_msg_data => x_msg_data);
1229: END IF;
1230:
1231: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1232: l_msg_index := 1;
1233: l_msg_count := x_msg_count;
1234: WHILE l_msg_count > 0 LOOP
1235: x_msg_data := FND_MSG_PUB.GET(

Line 1237: FND_API.G_FALSE );

1233: l_msg_count := x_msg_count;
1234: WHILE l_msg_count > 0 LOOP
1235: x_msg_data := FND_MSG_PUB.GET(
1236: l_msg_index,
1237: FND_API.G_FALSE );
1238: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1239: l_msg_index := l_msg_index + 1;
1240: l_msg_count := l_msg_count - 1;
1241: END LOOP;

Line 1242: RAISE FND_API.G_EXC_ERROR;

1238: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1239: l_msg_index := l_msg_index + 1;
1240: l_msg_count := l_msg_count - 1;
1241: END LOOP;
1242: RAISE FND_API.G_EXC_ERROR;
1243: END IF;
1244: END IF;
1245: END LOOP;
1246: -- Added by sguthiva for bug 2307804

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

1265: IF l_old_party_tbl(l_row).instance_party_id = p_party_tbl(p_row).instance_party_id
1266: AND l_old_party_tbl(l_row).party_id <> l_internal_party_id
1267: AND p_party_tbl(p_row).party_id = l_internal_party_id
1268: AND ( p_party_tbl(p_row).instance_id IS NOT NULL AND
1269: p_party_tbl(p_row).instance_id <> fnd_api.g_miss_num)
1270: AND p_party_tbl(p_row).relationship_type_code='OWNER'
1271: THEN
1272: FOR l_exp_pty IN exp_pty_csr(p_party_tbl(p_row).instance_id)
1273: LOOP

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

1284: l_exp_acct_rec.ip_account_id := exp_acct_rec.ip_account_id;
1285: l_exp_acct_rec.relationship_type_code := exp_acct_rec.relationship_type_code;
1286: l_exp_acct_rec.object_version_number := exp_acct_rec.object_version_number ;
1287: l_exp_acct_rec.active_end_date :=SYSDATE;
1288: l_exp_acct_rec.expire_flag :=fnd_api.g_true;
1289: -- Add log output for bug 7333900
1290: IF (l_csi_debug_level > 0) THEN
1291: 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);
1292: csi_gen_utility_pvt.put_line(' account old active_end_date : '||exp_acct_rec.active_end_date);

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

1293: csi_gen_utility_pvt.put_line(' account new active_end_date : '||l_exp_acct_rec.active_end_date);
1294: csi_gen_utility_pvt.put_line(' sysdate : '||SYSDATE);
1295: END IF;
1296: IF l_exp_acct_rec.ip_account_id IS NOT NULL
1297: AND l_exp_acct_rec.ip_account_id <> fnd_api.g_miss_num
1298: THEN
1299: l_exp_acct_rec.grp_call_contracts := l_grp_call_contracts;
1300: csi_party_relationships_pvt.update_inst_party_account
1301: ( p_api_version => p_api_version

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

1308: ,x_return_status => x_return_status
1309: ,x_msg_count => x_msg_count
1310: ,x_msg_data => x_msg_data);
1311:
1312: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1313: l_msg_index := 1;
1314: l_msg_count := x_msg_count;
1315: WHILE l_msg_count > 0 LOOP
1316: x_msg_data := FND_MSG_PUB.GET(

Line 1318: FND_API.G_FALSE );

1314: l_msg_count := x_msg_count;
1315: WHILE l_msg_count > 0 LOOP
1316: x_msg_data := FND_MSG_PUB.GET(
1317: l_msg_index,
1318: FND_API.G_FALSE );
1319: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1320: l_msg_index := l_msg_index + 1;
1321: l_msg_count := l_msg_count - 1;
1322: END LOOP;

Line 1323: RAISE FND_API.G_EXC_ERROR;

1319: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1320: l_msg_index := l_msg_index + 1;
1321: l_msg_count := l_msg_count - 1;
1322: END LOOP;
1323: RAISE FND_API.G_EXC_ERROR;
1324: END IF;
1325: END IF;
1326: END LOOP;-- exp_acct_rec IN exp_acct_csr
1327: --end of fix 5511689

Line 1339: p_txn_rec.src_txn_creation_date = FND_API.G_MISS_DATE THEN

1335: l_exp_party_rec.object_version_number := l_exp_pty.object_version_number;
1336: -- Bug 3804960
1337: -- srramakr Need to use the same the date used by the item instance
1338: IF p_txn_rec.src_txn_creation_date IS NULL OR
1339: p_txn_rec.src_txn_creation_date = FND_API.G_MISS_DATE THEN
1340: l_exp_party_rec.active_end_date := sysdate;
1341: ELSE
1342: l_exp_party_rec.active_end_date := p_txn_rec.src_txn_creation_date;
1343: END IF;

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

1359: ,x_return_status => x_return_status
1360: ,x_msg_count => x_msg_count
1361: ,x_msg_data => x_msg_data ) ;
1362:
1363: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1364: l_msg_index := 1;
1365: l_msg_count := x_msg_count;
1366: WHILE l_msg_count > 0
1367: LOOP

Line 1370: FND_API.G_FALSE );

1366: WHILE l_msg_count > 0
1367: LOOP
1368: x_msg_data := FND_MSG_PUB.GET(
1369: l_msg_index,
1370: FND_API.G_FALSE );
1371: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1372: l_msg_index := l_msg_index + 1;
1373: l_msg_count := l_msg_count - 1;
1374: END LOOP;

Line 1375: RAISE FND_API.G_EXC_ERROR;

1371: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1372: l_msg_index := l_msg_index + 1;
1373: l_msg_count := l_msg_count - 1;
1374: END LOOP;
1375: RAISE FND_API.G_EXC_ERROR;
1376: END IF;
1377: -- Bug 10007311 End of party expiration code
1378: END LOOP;
1379: END IF;

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

1391: WHERE instance_party_id=p_party_tbl(p_row).instance_party_id
1392: AND relationship_type_code ='OWNER'
1393: AND nvl(active_end_date, sysdate+1) >= sysdate;
1394: l_exp_acct_rec.active_end_date :=SYSDATE;
1395: l_exp_acct_rec.expire_flag :=fnd_api.g_true;
1396: EXCEPTION
1397: WHEN OTHERS THEN
1398: NULL;
1399: END;

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

1398: NULL;
1399: END;
1400:
1401: IF l_exp_acct_rec.ip_account_id IS NOT NULL
1402: AND l_exp_acct_rec.ip_account_id <> fnd_api.g_miss_num
1403: THEN
1404: l_exp_acct_rec.grp_call_contracts := l_grp_call_contracts;
1405: csi_party_relationships_pvt.update_inst_party_account
1406: ( p_api_version => p_api_version

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

1413: ,x_return_status => x_return_status
1414: ,x_msg_count => x_msg_count
1415: ,x_msg_data => x_msg_data);
1416:
1417: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1418: l_msg_index := 1;
1419: l_msg_count := x_msg_count;
1420: WHILE l_msg_count > 0 LOOP
1421: x_msg_data := FND_MSG_PUB.GET(

Line 1423: FND_API.G_FALSE );

1419: l_msg_count := x_msg_count;
1420: WHILE l_msg_count > 0 LOOP
1421: x_msg_data := FND_MSG_PUB.GET(
1422: l_msg_index,
1423: FND_API.G_FALSE );
1424: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1425: l_msg_index := l_msg_index + 1;
1426: l_msg_count := l_msg_count - 1;
1427: END LOOP;

Line 1428: RAISE FND_API.G_EXC_ERROR;

1424: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1425: l_msg_index := l_msg_index + 1;
1426: l_msg_count := l_msg_count - 1;
1427: END LOOP;
1428: RAISE FND_API.G_EXC_ERROR;
1429: END IF;
1430: END IF;
1431: END IF;
1432: END LOOP;

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

1448: LOOP
1449: IF l_old_party_tbl.EXISTS(l_old_party_row) THEN
1450: IF l_old_party_tbl(l_old_party_row).relationship_type_code = 'OWNER' AND
1451: l_old_party_tbl(l_old_party_row).party_id IS NOT NULL AND
1452: l_old_party_tbl(l_old_party_row).party_id <> fnd_api.g_miss_num
1453: THEN
1454: -- Get Current Party record
1455: IF NOT(CSI_Instance_parties_vld_pvt.Get_Party_Record
1456: ( l_old_party_tbl(l_old_party_row).instance_party_id,

Line 1458: RAISE FND_API.G_EXC_ERROR;

1454: -- Get Current Party record
1455: IF NOT(CSI_Instance_parties_vld_pvt.Get_Party_Record
1456: ( l_old_party_tbl(l_old_party_row).instance_party_id,
1457: l_new_curr_party_rec)) THEN
1458: RAISE FND_API.G_EXC_ERROR;
1459: END IF;
1460:
1461: -- Start of code addition for fixing bug 6368172, section 3 of 5
1462: -- grab the owner account of the parent

Line 1535: AND l_old_parent_owner_pty_acct_id <> fnd_api.g_miss_num

1531: IF l_old_party_tbl(l_old_party_row).party_id <> l_new_curr_party_rec.party_id
1532: -- Start of code addition for fixing bug 6368172, section 4 of 5
1533: OR (l_old_party_tbl(l_old_party_row).party_id = l_new_curr_party_rec.party_id
1534: AND l_old_parent_owner_pty_acct_id IS NOT NULL
1535: AND l_old_parent_owner_pty_acct_id <> fnd_api.g_miss_num
1536: AND l_old_parent_owner_pty_acct_id <> l_new_ip_acct_rec.party_account_id)
1537: -- End of code addition for fixing bug 6368172, section 4 of 5
1538: OR nvl(l_old_party_tbl(l_old_party_row).cascade_ownership_flag,'N')='Y' -- Added for cascade 2972082
1539: THEN

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

1544: -- Here I'm grabbing the children
1545:
1546: -- Added for cascade bug 2972082
1547: IF l_old_party_tbl(l_old_party_row).instance_id IS NULL OR
1548: l_old_party_tbl(l_old_party_row).instance_id = fnd_api.g_miss_num
1549: THEN
1550: BEGIN
1551: SELECT instance_id
1552: INTO l_old_party_tbl(l_old_party_row).instance_id

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

1562: p_rel_query_rec.object_id := l_old_party_tbl(l_old_party_row).instance_id;
1563: p_rel_query_rec.relationship_type_code := 'COMPONENT-OF';
1564: --
1565: IF p_rel_query_rec.object_id IS NOT NULL AND
1566: p_rel_query_rec.object_id <> FND_API.G_MISS_NUM THEN
1567: csi_ii_relationships_pvt.Get_Children
1568: ( p_relationship_query_rec => p_rel_query_rec,
1569: p_rel_tbl => l_rel_tbl,
1570: p_depth => NULL,

Line 1571: p_active_relationship_only => FND_API.G_TRUE,

1567: csi_ii_relationships_pvt.Get_Children
1568: ( p_relationship_query_rec => p_rel_query_rec,
1569: p_rel_tbl => l_rel_tbl,
1570: p_depth => NULL,
1571: p_active_relationship_only => FND_API.G_TRUE,
1572: p_time_stamp => FND_API.G_MISS_DATE,
1573: p_get_dfs => FND_API.G_FALSE,
1574: p_ii_relationship_level_tbl => l_ii_relationship_level_tbl,
1575: x_return_status => x_return_status,

Line 1572: p_time_stamp => FND_API.G_MISS_DATE,

1568: ( p_relationship_query_rec => p_rel_query_rec,
1569: p_rel_tbl => l_rel_tbl,
1570: p_depth => NULL,
1571: p_active_relationship_only => FND_API.G_TRUE,
1572: p_time_stamp => FND_API.G_MISS_DATE,
1573: p_get_dfs => FND_API.G_FALSE,
1574: p_ii_relationship_level_tbl => l_ii_relationship_level_tbl,
1575: x_return_status => x_return_status,
1576: x_msg_count => x_msg_count,

Line 1573: p_get_dfs => FND_API.G_FALSE,

1569: p_rel_tbl => l_rel_tbl,
1570: p_depth => NULL,
1571: p_active_relationship_only => FND_API.G_TRUE,
1572: p_time_stamp => FND_API.G_MISS_DATE,
1573: p_get_dfs => FND_API.G_FALSE,
1574: p_ii_relationship_level_tbl => l_ii_relationship_level_tbl,
1575: x_return_status => x_return_status,
1576: x_msg_count => x_msg_count,
1577: x_msg_data => x_msg_data

Line 1580: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1576: x_msg_count => x_msg_count,
1577: x_msg_data => x_msg_data
1578: );
1579: --
1580: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1581: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
1582: FND_MSG_PUB.Add;
1583: RAISE FND_API.G_EXC_ERROR;
1584: END IF;

Line 1583: RAISE FND_API.G_EXC_ERROR;

1579: --
1580: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1581: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
1582: FND_MSG_PUB.Add;
1583: RAISE FND_API.G_EXC_ERROR;
1584: END IF;
1585: END IF;
1586: --
1587: IF l_rel_tbl.count > 0 THEN

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

1593: -- Now grab the child instances instance_party_id
1594: BEGIN
1595: l_cld_party_rec := l_new_curr_party_rec;
1596: l_cld_party_id := null;
1597: l_cld_party_rec.active_start_date := fnd_api.g_miss_date;
1598: l_cld_party_rec.active_end_date := fnd_api.g_miss_date;
1599: SELECT instance_party_id,
1600: instance_id,
1601: party_id,

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

1594: BEGIN
1595: l_cld_party_rec := l_new_curr_party_rec;
1596: l_cld_party_id := null;
1597: l_cld_party_rec.active_start_date := fnd_api.g_miss_date;
1598: l_cld_party_rec.active_end_date := fnd_api.g_miss_date;
1599: SELECT instance_party_id,
1600: instance_id,
1601: party_id,
1602: object_version_number

Line 1633: -- cascade_ownership_flag=fnd_api.g_true.

1629:
1630: -- The following is modified for cascade bug 2972082
1631: -- to make sure parties were updated only for new party
1632: -- which is different from the original party if
1633: -- cascade_ownership_flag=fnd_api.g_true.
1634: /*
1635: IF l_cld_party_rec.instance_party_id IS NOT NULL AND
1636: l_cld_party_rec.instance_party_id <> fnd_api.g_miss_num AND
1637: ((l_cld_party_id = l_old_party_tbl(l_old_party_row).party_id AND

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

1632: -- which is different from the original party if
1633: -- cascade_ownership_flag=fnd_api.g_true.
1634: /*
1635: IF l_cld_party_rec.instance_party_id IS NOT NULL AND
1636: l_cld_party_rec.instance_party_id <> fnd_api.g_miss_num AND
1637: ((l_cld_party_id = l_old_party_tbl(l_old_party_row).party_id AND
1638: l_cld_party_id <> l_cld_party_rec.party_id)
1639: OR
1640: (l_cld_party_id <> l_old_party_tbl(l_old_party_row).party_id AND

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

1673: csi_gen_utility_pvt.put_line('l_force_cascade: ' || l_force_cascade);
1674: --End of code for Bug 10414588
1675:
1676: IF l_cld_party_rec.instance_party_id IS NOT NULL AND
1677: l_cld_party_rec.instance_party_id <> fnd_api.g_miss_num AND
1678: ((l_cld_party_id = l_old_party_tbl(l_old_party_row).party_id AND
1679: l_cld_party_id <> l_cld_party_rec.party_id)
1680: OR
1681: (l_cld_party_id = l_old_party_tbl(l_old_party_row).party_id AND

Line 1684: l_old_parent_owner_pty_acct_id <> fnd_api.g_miss_num AND

1680: OR
1681: (l_cld_party_id = l_old_party_tbl(l_old_party_row).party_id AND
1682: l_cld_party_id = l_cld_party_rec.party_id AND
1683: l_old_parent_owner_pty_acct_id IS NOT NULL AND
1684: l_old_parent_owner_pty_acct_id <> fnd_api.g_miss_num AND
1685: l_old_child_owner_pty_acct_id IS NOT NULL AND
1686: l_old_child_owner_pty_acct_id <> fnd_api.g_miss_num AND
1687: (l_old_child_owner_pty_acct_id = l_old_parent_owner_pty_acct_id OR nvl(l_force_cascade,'N')='Y') AND --Changed for Bug 10414588
1688: l_old_child_owner_pty_acct_id <> l_new_ip_acct_rec.party_account_id)

Line 1686: l_old_child_owner_pty_acct_id <> fnd_api.g_miss_num AND

1682: l_cld_party_id = l_cld_party_rec.party_id AND
1683: l_old_parent_owner_pty_acct_id IS NOT NULL AND
1684: l_old_parent_owner_pty_acct_id <> fnd_api.g_miss_num AND
1685: l_old_child_owner_pty_acct_id IS NOT NULL AND
1686: l_old_child_owner_pty_acct_id <> fnd_api.g_miss_num AND
1687: (l_old_child_owner_pty_acct_id = l_old_parent_owner_pty_acct_id OR nvl(l_force_cascade,'N')='Y') AND --Changed for Bug 10414588
1688: l_old_child_owner_pty_acct_id <> l_new_ip_acct_rec.party_account_id)
1689: OR
1690: (l_cld_party_id <> l_old_party_tbl(l_old_party_row).party_id AND

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

1704: ,x_return_status => x_return_status
1705: ,x_msg_count => x_msg_count
1706: ,x_msg_data => x_msg_data ) ;
1707:
1708: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1709: l_msg_index := 1;
1710: l_msg_count := x_msg_count;
1711: WHILE l_msg_count > 0 LOOP
1712: x_msg_data := FND_MSG_PUB.GET(

Line 1714: FND_API.G_FALSE );

1710: l_msg_count := x_msg_count;
1711: WHILE l_msg_count > 0 LOOP
1712: x_msg_data := FND_MSG_PUB.GET(
1713: l_msg_index,
1714: FND_API.G_FALSE );
1715: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1716: l_msg_index := l_msg_index + 1;
1717: l_msg_count := l_msg_count - 1;
1718: END LOOP;

Line 1719: RAISE FND_API.G_EXC_ERROR;

1715: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1716: l_msg_index := l_msg_index + 1;
1717: l_msg_count := l_msg_count - 1;
1718: END LOOP;
1719: RAISE FND_API.G_EXC_ERROR;
1720: END IF;
1721:
1722: --added may15
1723: -- Added by sguthiva for bug 2307804

Line 1743: p_txn_rec.src_txn_creation_date = FND_API.G_MISS_DATE THEN

1739: l_exp_party_rec.object_version_number := l_exp_pty.object_version_number;
1740: -- Bug 3804960
1741: -- srramakr Need to use the same the date used by the item instance
1742: IF p_txn_rec.src_txn_creation_date IS NULL OR
1743: p_txn_rec.src_txn_creation_date = FND_API.G_MISS_DATE THEN
1744: l_exp_party_rec.active_end_date := sysdate;
1745: ELSE
1746: l_exp_party_rec.active_end_date := p_txn_rec.src_txn_creation_date;
1747: END IF;

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

1756: ,x_return_status => x_return_status
1757: ,x_msg_count => x_msg_count
1758: ,x_msg_data => x_msg_data ) ;
1759:
1760: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1761: l_msg_index := 1;
1762: l_msg_count := x_msg_count;
1763: WHILE l_msg_count > 0
1764: LOOP

Line 1767: FND_API.G_FALSE );

1763: WHILE l_msg_count > 0
1764: LOOP
1765: x_msg_data := FND_MSG_PUB.GET(
1766: l_msg_index,
1767: FND_API.G_FALSE );
1768: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1769: l_msg_index := l_msg_index + 1;
1770: l_msg_count := l_msg_count - 1;
1771: END LOOP;

Line 1772: RAISE FND_API.G_EXC_ERROR;

1768: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1769: l_msg_index := l_msg_index + 1;
1770: l_msg_count := l_msg_count - 1;
1771: END LOOP;
1772: RAISE FND_API.G_EXC_ERROR;
1773: END IF;
1774: END LOOP;
1775: END IF;
1776: --End addition for bug 3294748

Line 1791: p_txn_rec.src_txn_creation_date = FND_API.G_MISS_DATE THEN

1787: AND relationship_type_code ='OWNER';
1788: -- Bug 3804960
1789: -- srramakr Need to use the same the date used by the item instance
1790: IF p_txn_rec.src_txn_creation_date IS NULL OR
1791: p_txn_rec.src_txn_creation_date = FND_API.G_MISS_DATE THEN
1792: l_exp_acct_rec.active_end_date := sysdate;
1793: ELSE
1794: l_exp_acct_rec.active_end_date := p_txn_rec.src_txn_creation_date;
1795: END IF;

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

1793: ELSE
1794: l_exp_acct_rec.active_end_date := p_txn_rec.src_txn_creation_date;
1795: END IF;
1796: -- End of 3804960
1797: l_exp_acct_rec.expire_flag :=fnd_api.g_true;
1798: EXCEPTION
1799: WHEN OTHERS THEN
1800: NULL;
1801: END;

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

1800: NULL;
1801: END;
1802:
1803: IF l_exp_acct_rec.ip_account_id IS NOT NULL
1804: AND l_exp_acct_rec.ip_account_id <> fnd_api.g_miss_num
1805: THEN
1806: l_exp_acct_rec.grp_call_contracts := l_grp_call_contracts;
1807: csi_party_relationships_pvt.update_inst_party_account
1808: ( p_api_version => p_api_version

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

1815: ,x_return_status => x_return_status
1816: ,x_msg_count => x_msg_count
1817: ,x_msg_data => x_msg_data);
1818:
1819: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1820: l_msg_index := 1;
1821: l_msg_count := x_msg_count;
1822: WHILE l_msg_count > 0 LOOP
1823: x_msg_data := FND_MSG_PUB.GET(

Line 1825: FND_API.G_FALSE );

1821: l_msg_count := x_msg_count;
1822: WHILE l_msg_count > 0 LOOP
1823: x_msg_data := FND_MSG_PUB.GET(
1824: l_msg_index,
1825: FND_API.G_FALSE );
1826: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1827: l_msg_index := l_msg_index + 1;
1828: l_msg_count := l_msg_count - 1;
1829: END LOOP;

Line 1830: RAISE FND_API.G_EXC_ERROR;

1826: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1827: l_msg_index := l_msg_index + 1;
1828: l_msg_count := l_msg_count - 1;
1829: END LOOP;
1830: RAISE FND_API.G_EXC_ERROR;
1831: END IF;
1832: END IF;
1833: END IF;
1834: -- End addition by sguthiva for bug 2307804

Line 1838: l_ip_acct_rec.instance_party_id <> fnd_api.g_miss_num

1834: -- End addition by sguthiva for bug 2307804
1835: IF l_cld_party_rec.party_id <> l_internal_party_id
1836: THEN
1837: IF l_ip_acct_rec.instance_party_id IS NOT NULL AND
1838: l_ip_acct_rec.instance_party_id <> fnd_api.g_miss_num
1839: THEN
1840: l_ip_acct_rec:=l_new_ip_acct_rec; -- added for 2608706
1841: l_ip_acct_rec.instance_party_id := l_cld_party_rec.instance_party_id;
1842: l_ip_acct_rec.ip_account_id := fnd_api.g_miss_num;

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

1838: l_ip_acct_rec.instance_party_id <> fnd_api.g_miss_num
1839: THEN
1840: l_ip_acct_rec:=l_new_ip_acct_rec; -- added for 2608706
1841: l_ip_acct_rec.instance_party_id := l_cld_party_rec.instance_party_id;
1842: l_ip_acct_rec.ip_account_id := fnd_api.g_miss_num;
1843: -- srramakr Bug 3621181 need to cascade Bill_to and Ship_to address to the children
1844: -- l_ip_acct_rec.bill_to_address := fnd_api.g_miss_num;
1845: -- l_ip_acct_rec.ship_to_address := fnd_api.g_miss_num;
1846: l_ip_acct_rec.active_start_date := fnd_api.g_miss_date; -- added for 2608706

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

1840: l_ip_acct_rec:=l_new_ip_acct_rec; -- added for 2608706
1841: l_ip_acct_rec.instance_party_id := l_cld_party_rec.instance_party_id;
1842: l_ip_acct_rec.ip_account_id := fnd_api.g_miss_num;
1843: -- srramakr Bug 3621181 need to cascade Bill_to and Ship_to address to the children
1844: -- l_ip_acct_rec.bill_to_address := fnd_api.g_miss_num;
1845: -- l_ip_acct_rec.ship_to_address := fnd_api.g_miss_num;
1846: l_ip_acct_rec.active_start_date := fnd_api.g_miss_date; -- added for 2608706
1847: l_ip_acct_rec.active_end_date := fnd_api.g_miss_date; -- added for 2608706
1848: l_ip_acct_rec.grp_call_contracts := l_grp_call_contracts;

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

1841: l_ip_acct_rec.instance_party_id := l_cld_party_rec.instance_party_id;
1842: l_ip_acct_rec.ip_account_id := fnd_api.g_miss_num;
1843: -- srramakr Bug 3621181 need to cascade Bill_to and Ship_to address to the children
1844: -- l_ip_acct_rec.bill_to_address := fnd_api.g_miss_num;
1845: -- l_ip_acct_rec.ship_to_address := fnd_api.g_miss_num;
1846: l_ip_acct_rec.active_start_date := fnd_api.g_miss_date; -- added for 2608706
1847: l_ip_acct_rec.active_end_date := fnd_api.g_miss_date; -- added for 2608706
1848: l_ip_acct_rec.grp_call_contracts := l_grp_call_contracts;
1849: -- Added the following code for bug 2972082

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

1842: l_ip_acct_rec.ip_account_id := fnd_api.g_miss_num;
1843: -- srramakr Bug 3621181 need to cascade Bill_to and Ship_to address to the children
1844: -- l_ip_acct_rec.bill_to_address := fnd_api.g_miss_num;
1845: -- l_ip_acct_rec.ship_to_address := fnd_api.g_miss_num;
1846: l_ip_acct_rec.active_start_date := fnd_api.g_miss_date; -- added for 2608706
1847: l_ip_acct_rec.active_end_date := fnd_api.g_miss_date; -- added for 2608706
1848: l_ip_acct_rec.grp_call_contracts := l_grp_call_contracts;
1849: -- Added the following code for bug 2972082
1850: IF nvl(l_old_party_tbl(l_old_party_row).cascade_ownership_flag,'N')='Y'

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

1843: -- srramakr Bug 3621181 need to cascade Bill_to and Ship_to address to the children
1844: -- l_ip_acct_rec.bill_to_address := fnd_api.g_miss_num;
1845: -- l_ip_acct_rec.ship_to_address := fnd_api.g_miss_num;
1846: l_ip_acct_rec.active_start_date := fnd_api.g_miss_date; -- added for 2608706
1847: l_ip_acct_rec.active_end_date := fnd_api.g_miss_date; -- added for 2608706
1848: l_ip_acct_rec.grp_call_contracts := l_grp_call_contracts;
1849: -- Added the following code for bug 2972082
1850: IF nvl(l_old_party_tbl(l_old_party_row).cascade_ownership_flag,'N')='Y'
1851: AND l_cld_party_id <> l_cld_party_rec.party_id

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

1856: -- End of addition for bug 2972082
1857: -- Need to pass the system_id for components also if the Xfer of ownership is
1858: -- initiated from xfer of system. This will be true if both parent and child instances
1859: -- belong to the same system.
1860: l_ip_acct_rec.system_id := fnd_api.g_miss_num;
1861: --
1862: IF p_party_account_tbl.EXISTS(1) AND
1863: p_party_account_tbl(1).system_id IS NOT NULL AND
1864: p_party_account_tbl(1).system_id <> FND_API.G_MISS_NUM AND

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

1860: l_ip_acct_rec.system_id := fnd_api.g_miss_num;
1861: --
1862: IF p_party_account_tbl.EXISTS(1) AND
1863: p_party_account_tbl(1).system_id IS NOT NULL AND
1864: p_party_account_tbl(1).system_id <> FND_API.G_MISS_NUM AND
1865: NVL(p_party_account_tbl(1).relationship_type_code,FND_API.G_MISS_CHAR) = 'OWNER' THEN
1866: Begin
1867: select system_id
1868: into l_ip_acct_rec.system_id

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

1861: --
1862: IF p_party_account_tbl.EXISTS(1) AND
1863: p_party_account_tbl(1).system_id IS NOT NULL AND
1864: p_party_account_tbl(1).system_id <> FND_API.G_MISS_NUM AND
1865: NVL(p_party_account_tbl(1).relationship_type_code,FND_API.G_MISS_CHAR) = 'OWNER' THEN
1866: Begin
1867: select system_id
1868: into l_ip_acct_rec.system_id
1869: from csi_item_instances

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

1867: select system_id
1868: into l_ip_acct_rec.system_id
1869: from csi_item_instances
1870: where instance_id = l_rel_tbl(j).subject_id
1871: and nvl(system_id,fnd_api.g_miss_num) = p_party_account_tbl(1).system_id;
1872: Exception
1873: when no_data_found then
1874: l_ip_acct_rec.system_id := fnd_api.g_miss_num;
1875: End;

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

1870: where instance_id = l_rel_tbl(j).subject_id
1871: and nvl(system_id,fnd_api.g_miss_num) = p_party_account_tbl(1).system_id;
1872: Exception
1873: when no_data_found then
1874: l_ip_acct_rec.system_id := fnd_api.g_miss_num;
1875: End;
1876: END IF;
1877: csi_party_relationships_pvt.create_inst_party_account
1878: ( p_api_version => p_api_version

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

1890: ,p_account_count_rec => l_account_count_rec
1891: ,p_oks_txn_inst_tbl => p_oks_txn_inst_tbl
1892: );
1893:
1894: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1895: l_msg_index := 1;
1896: l_msg_count := x_msg_count;
1897: WHILE l_msg_count > 0 LOOP
1898: x_msg_data := FND_MSG_PUB.GET(

Line 1900: FND_API.G_FALSE );

1896: l_msg_count := x_msg_count;
1897: WHILE l_msg_count > 0 LOOP
1898: x_msg_data := FND_MSG_PUB.GET(
1899: l_msg_index,
1900: FND_API.G_FALSE );
1901: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1902: l_msg_index := l_msg_index + 1;
1903: l_msg_count := l_msg_count - 1;
1904: END LOOP;

Line 1905: RAISE FND_API.G_EXC_ERROR;

1901: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
1902: l_msg_index := l_msg_index + 1;
1903: l_msg_count := l_msg_count - 1;
1904: END LOOP;
1905: RAISE FND_API.G_EXC_ERROR;
1906: END IF;
1907: END IF;
1908: END IF;
1909: -- End commentation by sguthiva for bug 2307804

Line 1927: IF FND_API.To_Boolean( p_commit ) THEN

1923: -- End of API body
1924:
1925:
1926: -- Standard check of p_commit.
1927: IF FND_API.To_Boolean( p_commit ) THEN
1928: COMMIT WORK;
1929: END IF;
1930:
1931: /***** srramakr commented for bug # 3304439

Line 1944: WHEN FND_API.G_EXC_ERROR THEN

1940: FND_MSG_PUB.Count_And_Get
1941: (p_count => x_msg_count ,
1942: p_data => x_msg_data );
1943: EXCEPTION
1944: WHEN FND_API.G_EXC_ERROR THEN
1945: ROLLBACK TO update_inst_party_rel_pub;
1946: x_return_status := FND_API.G_RET_STS_ERROR ;
1947: FND_MSG_PUB.Count_And_Get
1948: ( p_count => x_msg_count,

Line 1946: x_return_status := FND_API.G_RET_STS_ERROR ;

1942: p_data => x_msg_data );
1943: EXCEPTION
1944: WHEN FND_API.G_EXC_ERROR THEN
1945: ROLLBACK TO update_inst_party_rel_pub;
1946: x_return_status := FND_API.G_RET_STS_ERROR ;
1947: FND_MSG_PUB.Count_And_Get
1948: ( p_count => x_msg_count,
1949: p_data => x_msg_data );
1950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1946: x_return_status := FND_API.G_RET_STS_ERROR ;
1947: FND_MSG_PUB.Count_And_Get
1948: ( p_count => x_msg_count,
1949: p_data => x_msg_data );
1950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1951: ROLLBACK TO update_inst_party_rel_pub;
1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1953: FND_MSG_PUB.Count_And_Get
1954: ( p_count => x_msg_count,

Line 1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1948: ( p_count => x_msg_count,
1949: p_data => x_msg_data );
1950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1951: ROLLBACK TO update_inst_party_rel_pub;
1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1953: FND_MSG_PUB.Count_And_Get
1954: ( p_count => x_msg_count,
1955: p_data => x_msg_data );
1956: WHEN OTHERS THEN

Line 1958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1954: ( p_count => x_msg_count,
1955: p_data => x_msg_data );
1956: WHEN OTHERS THEN
1957: ROLLBACK TO update_inst_party_rel_pub;
1958: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1959: IF FND_MSG_PUB.Check_Msg_Level
1960: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1961: THEN
1962: FND_MSG_PUB.Add_Exc_Msg

Line 2006: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2002:
2003: csi_utility_grp.check_ib_active;
2004:
2005: -- Standard call to check for call compatibility.
2006: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2007: p_api_version ,
2008: l_api_name ,
2009: g_pkg_name )
2010: THEN

Line 2011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2007: p_api_version ,
2008: l_api_name ,
2009: g_pkg_name )
2010: THEN
2011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2012: END IF;
2013:
2014: -- Initialize message list if p_init_msg_list is set to TRUE.
2015: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2015: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2012: END IF;
2013:
2014: -- Initialize message list if p_init_msg_list is set to TRUE.
2015: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2016: FND_MSG_PUB.initialize;
2017: END IF;
2018:
2019: -- Initialize API return status to success

Line 2020: x_return_status := FND_API.G_RET_STS_SUCCESS;

2016: FND_MSG_PUB.initialize;
2017: END IF;
2018:
2019: -- Initialize API return status to success
2020: x_return_status := FND_API.G_RET_STS_SUCCESS;
2021:
2022: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
2023: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2024:

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

2060: x_return_status => x_return_status ,
2061: x_msg_count => x_msg_count ,
2062: x_msg_data => x_msg_data ) ;
2063:
2064: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2065: l_msg_index := 1;
2066: l_msg_count := x_msg_count;
2067: WHILE l_msg_count > 0 LOOP
2068: x_msg_data := FND_MSG_PUB.GET(

Line 2070: FND_API.G_FALSE );

2066: l_msg_count := x_msg_count;
2067: WHILE l_msg_count > 0 LOOP
2068: x_msg_data := FND_MSG_PUB.GET(
2069: l_msg_index,
2070: FND_API.G_FALSE );
2071: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2072: l_msg_index := l_msg_index + 1;
2073: l_msg_count := l_msg_count - 1;
2074: END LOOP;

Line 2075: RAISE FND_API.G_EXC_ERROR;

2071: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2072: l_msg_index := l_msg_index + 1;
2073: l_msg_count := l_msg_count - 1;
2074: END LOOP;
2075: RAISE FND_API.G_EXC_ERROR;
2076: END IF;
2077: END IF;
2078: END LOOP;
2079: END IF;

Line 2084: IF FND_API.To_Boolean( p_commit ) THEN

2080: --
2081: -- End of API body
2082:
2083: -- Standard check of p_commit.
2084: IF FND_API.To_Boolean( p_commit ) THEN
2085: COMMIT WORK;
2086: END IF;
2087:
2088: /***** srramakr commented for bug # 3304439

Line 2101: WHEN FND_API.G_EXC_ERROR THEN

2097: FND_MSG_PUB.Count_And_Get
2098: (p_count => x_msg_count ,
2099: p_data => x_msg_data );
2100: EXCEPTION
2101: WHEN FND_API.G_EXC_ERROR THEN
2102: ROLLBACK TO expire_inst_party_rel_pub;
2103: x_return_status := FND_API.G_RET_STS_ERROR ;
2104: FND_MSG_PUB.Count_And_Get
2105: ( p_count => x_msg_count,

Line 2103: x_return_status := FND_API.G_RET_STS_ERROR ;

2099: p_data => x_msg_data );
2100: EXCEPTION
2101: WHEN FND_API.G_EXC_ERROR THEN
2102: ROLLBACK TO expire_inst_party_rel_pub;
2103: x_return_status := FND_API.G_RET_STS_ERROR ;
2104: FND_MSG_PUB.Count_And_Get
2105: ( p_count => x_msg_count,
2106: p_data => x_msg_data );
2107:

Line 2108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2104: FND_MSG_PUB.Count_And_Get
2105: ( p_count => x_msg_count,
2106: p_data => x_msg_data );
2107:
2108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2109: ROLLBACK TO expire_inst_party_rel_pub;
2110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2111: FND_MSG_PUB.Count_And_Get
2112: ( p_count => x_msg_count,

Line 2110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2106: p_data => x_msg_data );
2107:
2108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2109: ROLLBACK TO expire_inst_party_rel_pub;
2110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2111: FND_MSG_PUB.Count_And_Get
2112: ( p_count => x_msg_count,
2113: p_data => x_msg_data );
2114:

Line 2117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2113: p_data => x_msg_data );
2114:
2115: WHEN OTHERS THEN
2116: ROLLBACK TO expire_inst_party_relationship;
2117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2118: IF FND_MSG_PUB.Check_Msg_Level
2119: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2120: THEN
2121: FND_MSG_PUB.Add_Exc_Msg

Line 2181: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2177: csi_utility_grp.check_ib_active;
2178:
2179:
2180: -- Standard call to check for call compatibility.
2181: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2182: p_api_version ,
2183: l_api_name ,
2184: g_pkg_name )
2185: THEN

Line 2186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2182: p_api_version ,
2183: l_api_name ,
2184: g_pkg_name )
2185: THEN
2186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2187: END IF;
2188:
2189: -- Initialize message list if p_init_msg_list is set to TRUE.
2190: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2190: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2187: END IF;
2188:
2189: -- Initialize message list if p_init_msg_list is set to TRUE.
2190: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2191: FND_MSG_PUB.initialize;
2192: END IF;
2193:
2194: -- Initialize API return status to success

Line 2195: x_return_status := FND_API.G_RET_STS_SUCCESS;

2191: FND_MSG_PUB.initialize;
2192: END IF;
2193:
2194: -- Initialize API return status to success
2195: x_return_status := FND_API.G_RET_STS_SUCCESS;
2196:
2197: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
2198: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2199:

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

2223: ****/
2224:
2225: -- Start API body
2226: --
2227: IF (p_account_query_rec.ip_account_id = FND_API.G_MISS_NUM)
2228: AND (p_account_query_rec.instance_party_id = FND_API.G_MISS_NUM)
2229: AND (p_account_query_rec.party_account_id = FND_API.G_MISS_NUM)
2230: AND (p_account_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
2231:

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

2224:
2225: -- Start API body
2226: --
2227: IF (p_account_query_rec.ip_account_id = FND_API.G_MISS_NUM)
2228: AND (p_account_query_rec.instance_party_id = FND_API.G_MISS_NUM)
2229: AND (p_account_query_rec.party_account_id = FND_API.G_MISS_NUM)
2230: AND (p_account_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
2231:
2232: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');

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

2225: -- Start API body
2226: --
2227: IF (p_account_query_rec.ip_account_id = FND_API.G_MISS_NUM)
2228: AND (p_account_query_rec.instance_party_id = FND_API.G_MISS_NUM)
2229: AND (p_account_query_rec.party_account_id = FND_API.G_MISS_NUM)
2230: AND (p_account_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
2231:
2232: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
2233: FND_MSG_PUB.ADD;

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

2226: --
2227: IF (p_account_query_rec.ip_account_id = FND_API.G_MISS_NUM)
2228: AND (p_account_query_rec.instance_party_id = FND_API.G_MISS_NUM)
2229: AND (p_account_query_rec.party_account_id = FND_API.G_MISS_NUM)
2230: AND (p_account_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
2231:
2232: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
2233: FND_MSG_PUB.ADD;
2234: RAISE FND_API.G_EXC_ERROR;

Line 2234: RAISE FND_API.G_EXC_ERROR;

2230: AND (p_account_query_rec.relationship_type_code = FND_API.G_MISS_CHAR) THEN
2231:
2232: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
2233: FND_MSG_PUB.ADD;
2234: RAISE FND_API.G_EXC_ERROR;
2235: END IF;
2236:
2237: -- Generate the where clause
2238: csi_party_relationships_pvt.Gen_Acct_Where_Clause

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

2266:
2267: -- Close the cursor
2268: DBMS_SQL.CLOSE_CURSOR(l_get_acct_cursor_id);
2269:
2270: IF ((p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE)) THEN
2271: IF p_time_stamp <= sysdate THEN
2272: -- Contruct from the history if p_time_stamp is less than sysdate
2273: csi_party_relationships_pvt.Construct_acct_from_hist(x_account_header_tbl, p_time_stamp);
2274: ELSE

Line 2277: RAISE FND_API.G_EXC_ERROR;

2273: csi_party_relationships_pvt.Construct_acct_from_hist(x_account_header_tbl, p_time_stamp);
2274: ELSE
2275: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
2276: FND_MSG_PUB.ADD;
2277: RAISE FND_API.G_EXC_ERROR;
2278: END IF;
2279: END IF;
2280:
2281: -- foreign key resolution for the id columns

Line 2282: IF p_resolve_id_columns = fnd_api.g_true THEN

2278: END IF;
2279: END IF;
2280:
2281: -- foreign key resolution for the id columns
2282: IF p_resolve_id_columns = fnd_api.g_true THEN
2283: IF x_account_header_tbl.count > 0 THEN
2284: l_account_header_tbl := x_account_header_tbl;
2285: csi_party_relationships_pvt.Resolve_id_columns(l_account_header_tbl);
2286:

Line 2296: IF FND_API.To_Boolean( p_commit ) THEN

2292: -- End of API body
2293:
2294: -- Standard check of p_commit.
2295: /*
2296: IF FND_API.To_Boolean( p_commit ) THEN
2297: COMMIT WORK;
2298: END IF;
2299: */
2300:

Line 2314: WHEN FND_API.G_EXC_ERROR THEN

2310: FND_MSG_PUB.Count_And_Get
2311: (p_count => x_msg_count ,
2312: p_data => x_msg_data );
2313: EXCEPTION
2314: WHEN FND_API.G_EXC_ERROR THEN
2315: -- ROLLBACK TO get_inst_party_acct_pub;
2316: x_return_status := FND_API.G_RET_STS_ERROR ;
2317: FND_MSG_PUB.Count_And_Get
2318: ( p_count => x_msg_count,

Line 2316: x_return_status := FND_API.G_RET_STS_ERROR ;

2312: p_data => x_msg_data );
2313: EXCEPTION
2314: WHEN FND_API.G_EXC_ERROR THEN
2315: -- ROLLBACK TO get_inst_party_acct_pub;
2316: x_return_status := FND_API.G_RET_STS_ERROR ;
2317: FND_MSG_PUB.Count_And_Get
2318: ( p_count => x_msg_count,
2319: p_data => x_msg_data );
2320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2316: x_return_status := FND_API.G_RET_STS_ERROR ;
2317: FND_MSG_PUB.Count_And_Get
2318: ( p_count => x_msg_count,
2319: p_data => x_msg_data );
2320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2321: -- ROLLBACK TO get_inst_party_acct_pub;
2322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2323: FND_MSG_PUB.Count_And_Get
2324: ( p_count => x_msg_count,

Line 2322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2318: ( p_count => x_msg_count,
2319: p_data => x_msg_data );
2320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2321: -- ROLLBACK TO get_inst_party_acct_pub;
2322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2323: FND_MSG_PUB.Count_And_Get
2324: ( p_count => x_msg_count,
2325: p_data => x_msg_data );
2326: WHEN OTHERS THEN

Line 2331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2327: IF dbms_sql.is_open(l_get_acct_cursor_id) then
2328: dbms_sql.close_cursor(l_get_acct_cursor_id);
2329: END IF;
2330: -- ROLLBACK TO get_inst_party_acct_pub;
2331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2332: IF FND_MSG_PUB.Check_Msg_Level
2333: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2334: THEN
2335: FND_MSG_PUB.Add_Exc_Msg

Line 2386: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2382: csi_utility_grp.check_ib_active;
2383:
2384:
2385: -- Standard call to check for call compatibility.
2386: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2387: p_api_version ,
2388: l_api_name ,
2389: g_pkg_name )
2390: THEN

Line 2391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2387: p_api_version ,
2388: l_api_name ,
2389: g_pkg_name )
2390: THEN
2391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2392: END IF;
2393:
2394: -- Initialize message list if p_init_msg_list is set to TRUE.
2395: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2395: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2392: END IF;
2393:
2394: -- Initialize message list if p_init_msg_list is set to TRUE.
2395: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2396: FND_MSG_PUB.initialize;
2397: END IF;
2398:
2399: -- Initialize API return status to success

Line 2400: x_return_status := FND_API.G_RET_STS_SUCCESS;

2396: FND_MSG_PUB.initialize;
2397: END IF;
2398:
2399: -- Initialize API return status to success
2400: x_return_status := FND_API.G_RET_STS_SUCCESS;
2401:
2402: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
2403: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2404:

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

2448: ,p_account_count_rec => l_account_count_rec
2449: ,p_oks_txn_inst_tbl => px_oks_txn_inst_tbl
2450: );
2451:
2452: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2453: l_msg_index := 1;
2454: l_msg_count := x_msg_count;
2455: WHILE l_msg_count > 0 LOOP
2456: x_msg_data := FND_MSG_PUB.GET(

Line 2458: FND_API.G_FALSE );

2454: l_msg_count := x_msg_count;
2455: WHILE l_msg_count > 0 LOOP
2456: x_msg_data := FND_MSG_PUB.GET(
2457: l_msg_index,
2458: FND_API.G_FALSE );
2459: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
2460: l_msg_index := l_msg_index + 1;
2461: l_msg_count := l_msg_count - 1;
2462: END LOOP;

Line 2463: RAISE FND_API.G_EXC_ERROR;

2459: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);
2460: l_msg_index := l_msg_index + 1;
2461: l_msg_count := l_msg_count - 1;
2462: END LOOP;
2463: RAISE FND_API.G_EXC_ERROR;
2464: END IF;
2465: END IF;
2466: END LOOP;
2467: END IF;

Line 2472: IF FND_API.To_Boolean( p_commit ) THEN

2468: --
2469: -- End of API body
2470:
2471: -- Standard check of p_commit.
2472: IF FND_API.To_Boolean( p_commit ) THEN
2473: COMMIT WORK;
2474: END IF;
2475:
2476: /***** srramakr commented for bug # 3304439

Line 2489: WHEN FND_API.G_EXC_ERROR THEN

2485: FND_MSG_PUB.Count_And_Get
2486: (p_count => x_msg_count ,
2487: p_data => x_msg_data );
2488: EXCEPTION
2489: WHEN FND_API.G_EXC_ERROR THEN
2490: ROLLBACK TO create_inst_party_acct_pub;
2491: x_return_status := FND_API.G_RET_STS_ERROR ;
2492: FND_MSG_PUB.Count_And_Get
2493: ( p_count => x_msg_count,

Line 2491: x_return_status := FND_API.G_RET_STS_ERROR ;

2487: p_data => x_msg_data );
2488: EXCEPTION
2489: WHEN FND_API.G_EXC_ERROR THEN
2490: ROLLBACK TO create_inst_party_acct_pub;
2491: x_return_status := FND_API.G_RET_STS_ERROR ;
2492: FND_MSG_PUB.Count_And_Get
2493: ( p_count => x_msg_count,
2494: p_data => x_msg_data );
2495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2491: x_return_status := FND_API.G_RET_STS_ERROR ;
2492: FND_MSG_PUB.Count_And_Get
2493: ( p_count => x_msg_count,
2494: p_data => x_msg_data );
2495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2496: ROLLBACK TO create_inst_party_acct_pub;
2497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2498: FND_MSG_PUB.Count_And_Get
2499: ( p_count => x_msg_count,

Line 2497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2493: ( p_count => x_msg_count,
2494: p_data => x_msg_data );
2495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2496: ROLLBACK TO create_inst_party_acct_pub;
2497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2498: FND_MSG_PUB.Count_And_Get
2499: ( p_count => x_msg_count,
2500: p_data => x_msg_data );
2501: WHEN OTHERS THEN

Line 2503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2499: ( p_count => x_msg_count,
2500: p_data => x_msg_data );
2501: WHEN OTHERS THEN
2502: ROLLBACK TO create_inst_party_acct_pub;
2503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2504: IF FND_MSG_PUB.Check_Msg_Level
2505: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2506: THEN
2507: FND_MSG_PUB.Add_Exc_Msg

Line 2573: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2569: csi_utility_grp.check_ib_active;
2570:
2571:
2572: -- Standard call to check for call compatibility.
2573: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2574: p_api_version ,
2575: l_api_name ,
2576: g_pkg_name )
2577: THEN

Line 2578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2574: p_api_version ,
2575: l_api_name ,
2576: g_pkg_name )
2577: THEN
2578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2579: END IF;
2580:
2581: -- Initialize message list if p_init_msg_list is set to TRUE.
2582: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2582: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2579: END IF;
2580:
2581: -- Initialize message list if p_init_msg_list is set to TRUE.
2582: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2583: FND_MSG_PUB.initialize;
2584: END IF;
2585:
2586: -- Initialize API return status to success

Line 2587: x_return_status := FND_API.G_RET_STS_SUCCESS;

2583: FND_MSG_PUB.initialize;
2584: END IF;
2585:
2586: -- Initialize API return status to success
2587: x_return_status := FND_API.G_RET_STS_SUCCESS;
2588:
2589: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
2590: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2591:

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

2617: IF p_party_account_tbl.count > 0 THEN
2618: FOR l_count IN p_party_account_tbl.FIRST..p_party_account_tbl.LAST LOOP
2619: IF p_party_account_tbl.EXISTS(l_count) THEN
2620: IF p_party_account_tbl(l_count).ip_account_id IS NOT NULL AND
2621: p_party_account_tbl(l_count).ip_account_id <> fnd_api.g_miss_num
2622: THEN
2623: BEGIN
2624: SELECT acct.ip_account_id,
2625: acct.party_account_id,

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

2650: ,x_return_status => x_return_status
2651: ,x_msg_count => x_msg_count
2652: ,x_msg_data => x_msg_data);
2653:
2654: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2655: l_msg_index := 1;
2656: l_msg_count := x_msg_count;
2657: WHILE l_msg_count > 0 LOOP
2658: x_msg_data := FND_MSG_PUB.GET(

Line 2660: FND_API.G_FALSE );

2656: l_msg_count := x_msg_count;
2657: WHILE l_msg_count > 0 LOOP
2658: x_msg_data := FND_MSG_PUB.GET(
2659: l_msg_index,
2660: FND_API.G_FALSE );
2661: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2662: l_msg_index := l_msg_index + 1;
2663: l_msg_count := l_msg_count - 1;
2664: END LOOP;

Line 2665: RAISE FND_API.G_EXC_ERROR;

2661: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2662: l_msg_index := l_msg_index + 1;
2663: l_msg_count := l_msg_count - 1;
2664: END LOOP;
2665: RAISE FND_API.G_EXC_ERROR;
2666: END IF;
2667: END IF;
2668: END LOOP;
2669: END IF;

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

2695: END LOOP;
2696: END IF;
2697:
2698: IF l_party_account_tbl(l_old_party_row).party_account_id IS NOT NULL AND
2699: l_party_account_tbl(l_old_party_row).party_account_id <> FND_API.G_MISS_NUM AND
2700: l_party_account_tbl(l_old_party_row).relationship_type_code = 'OWNER' AND
2701: old_party_account_id IS NOT NULL AND
2702: l_party_account_tbl(l_old_party_row).party_account_id <> old_party_account_id
2703: THEN

Line 2725: p_active_relationship_only => FND_API.G_TRUE,

2721: csi_ii_relationships_pvt.Get_Children
2722: ( p_relationship_query_rec => p_rel_query_rec,
2723: p_rel_tbl => l_rel_tbl,
2724: p_depth => NULL,
2725: p_active_relationship_only => FND_API.G_TRUE,
2726: p_time_stamp => FND_API.G_MISS_DATE,
2727: p_get_dfs => FND_API.G_FALSE,
2728: p_ii_relationship_level_tbl => l_ii_relationship_level_tbl,
2729: x_return_status => x_return_status,

Line 2726: p_time_stamp => FND_API.G_MISS_DATE,

2722: ( p_relationship_query_rec => p_rel_query_rec,
2723: p_rel_tbl => l_rel_tbl,
2724: p_depth => NULL,
2725: p_active_relationship_only => FND_API.G_TRUE,
2726: p_time_stamp => FND_API.G_MISS_DATE,
2727: p_get_dfs => FND_API.G_FALSE,
2728: p_ii_relationship_level_tbl => l_ii_relationship_level_tbl,
2729: x_return_status => x_return_status,
2730: x_msg_count => x_msg_count,

Line 2727: p_get_dfs => FND_API.G_FALSE,

2723: p_rel_tbl => l_rel_tbl,
2724: p_depth => NULL,
2725: p_active_relationship_only => FND_API.G_TRUE,
2726: p_time_stamp => FND_API.G_MISS_DATE,
2727: p_get_dfs => FND_API.G_FALSE,
2728: p_ii_relationship_level_tbl => l_ii_relationship_level_tbl,
2729: x_return_status => x_return_status,
2730: x_msg_count => x_msg_count,
2731: x_msg_data => x_msg_data

Line 2734: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2730: x_msg_count => x_msg_count,
2731: x_msg_data => x_msg_data
2732: );
2733: --
2734: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2735: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
2736: FND_MSG_PUB.Add;
2737: RAISE FND_API.G_EXC_ERROR;
2738: END IF;

Line 2737: RAISE FND_API.G_EXC_ERROR;

2733: --
2734: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2735: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_CHILDREN_ERROR');
2736: FND_MSG_PUB.Add;
2737: RAISE FND_API.G_EXC_ERROR;
2738: END IF;
2739: --
2740: IF l_rel_tbl.count > 0 THEN
2741: FOR j in l_rel_tbl.FIRST .. l_rel_tbl.LAST LOOP

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

2739: --
2740: IF l_rel_tbl.count > 0 THEN
2741: FOR j in l_rel_tbl.FIRST .. l_rel_tbl.LAST LOOP
2742: -- FOR l_pty_acct_csr IN party_account_csr(l_party_account_tbl(l_old_party_row).instance_party_id)
2743: l_party_account_tbl(l_old_party_row).ip_account_id := fnd_api.g_miss_num;
2744: l_party_account_tbl(l_old_party_row).instance_party_id := fnd_api.g_miss_num;
2745: l_party_account_tbl(l_old_party_row).object_version_number := fnd_api.g_miss_num;
2746: l_party_account_tbl(l_old_party_row).active_start_date :=fnd_api.g_miss_date;
2747: l_party_account_tbl(l_old_party_row).active_end_date :=fnd_api.g_miss_date;

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

2740: IF l_rel_tbl.count > 0 THEN
2741: FOR j in l_rel_tbl.FIRST .. l_rel_tbl.LAST LOOP
2742: -- FOR l_pty_acct_csr IN party_account_csr(l_party_account_tbl(l_old_party_row).instance_party_id)
2743: l_party_account_tbl(l_old_party_row).ip_account_id := fnd_api.g_miss_num;
2744: l_party_account_tbl(l_old_party_row).instance_party_id := fnd_api.g_miss_num;
2745: l_party_account_tbl(l_old_party_row).object_version_number := fnd_api.g_miss_num;
2746: l_party_account_tbl(l_old_party_row).active_start_date :=fnd_api.g_miss_date;
2747: l_party_account_tbl(l_old_party_row).active_end_date :=fnd_api.g_miss_date;
2748: BEGIN

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

2741: FOR j in l_rel_tbl.FIRST .. l_rel_tbl.LAST LOOP
2742: -- FOR l_pty_acct_csr IN party_account_csr(l_party_account_tbl(l_old_party_row).instance_party_id)
2743: l_party_account_tbl(l_old_party_row).ip_account_id := fnd_api.g_miss_num;
2744: l_party_account_tbl(l_old_party_row).instance_party_id := fnd_api.g_miss_num;
2745: l_party_account_tbl(l_old_party_row).object_version_number := fnd_api.g_miss_num;
2746: l_party_account_tbl(l_old_party_row).active_start_date :=fnd_api.g_miss_date;
2747: l_party_account_tbl(l_old_party_row).active_end_date :=fnd_api.g_miss_date;
2748: BEGIN
2749: l_party_id := NULL;

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

2742: -- FOR l_pty_acct_csr IN party_account_csr(l_party_account_tbl(l_old_party_row).instance_party_id)
2743: l_party_account_tbl(l_old_party_row).ip_account_id := fnd_api.g_miss_num;
2744: l_party_account_tbl(l_old_party_row).instance_party_id := fnd_api.g_miss_num;
2745: l_party_account_tbl(l_old_party_row).object_version_number := fnd_api.g_miss_num;
2746: l_party_account_tbl(l_old_party_row).active_start_date :=fnd_api.g_miss_date;
2747: l_party_account_tbl(l_old_party_row).active_end_date :=fnd_api.g_miss_date;
2748: BEGIN
2749: l_party_id := NULL;
2750: SELECT acct.ip_account_id,

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

2743: l_party_account_tbl(l_old_party_row).ip_account_id := fnd_api.g_miss_num;
2744: l_party_account_tbl(l_old_party_row).instance_party_id := fnd_api.g_miss_num;
2745: l_party_account_tbl(l_old_party_row).object_version_number := fnd_api.g_miss_num;
2746: l_party_account_tbl(l_old_party_row).active_start_date :=fnd_api.g_miss_date;
2747: l_party_account_tbl(l_old_party_row).active_end_date :=fnd_api.g_miss_date;
2748: BEGIN
2749: l_party_id := NULL;
2750: SELECT acct.ip_account_id,
2751: acct.object_version_number,

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

2765: NULL;
2766: END;
2767: --
2768: IF l_party_account_tbl(l_old_party_row).ip_account_id IS NOT NULL AND
2769: l_party_account_tbl(l_old_party_row).ip_account_id <> fnd_api.g_miss_num AND
2770: old_party_id = l_party_id
2771: THEN
2772: csi_party_relationships_pvt.update_inst_party_account
2773: ( p_api_version => p_api_version

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

2780: ,x_return_status => x_return_status
2781: ,x_msg_count => x_msg_count
2782: ,x_msg_data => x_msg_data);
2783:
2784: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2785: l_msg_index := 1;
2786: l_msg_count := x_msg_count;
2787: WHILE l_msg_count > 0
2788: LOOP

Line 2791: FND_API.G_FALSE );

2787: WHILE l_msg_count > 0
2788: LOOP
2789: x_msg_data := FND_MSG_PUB.GET(
2790: l_msg_index,
2791: FND_API.G_FALSE );
2792: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2793: l_msg_index := l_msg_index + 1;
2794: l_msg_count := l_msg_count - 1;
2795: END LOOP;

Line 2796: RAISE FND_API.G_EXC_ERROR;

2792: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2793: l_msg_index := l_msg_index + 1;
2794: l_msg_count := l_msg_count - 1;
2795: END LOOP;
2796: RAISE FND_API.G_EXC_ERROR;
2797: END IF;
2798: END IF; -- ip_account_id not null check
2799: END LOOP; -- l_rel_tbl loop
2800: END IF; -- l_rel_tbl count check

Line 2812: IF FND_API.To_Boolean( p_commit ) THEN

2808: --
2809: -- End of API body
2810:
2811: -- Standard check of p_commit.
2812: IF FND_API.To_Boolean( p_commit ) THEN
2813: COMMIT WORK;
2814: END IF;
2815:
2816: /***** srramakr commented for bug # 3304439

Line 2829: WHEN FND_API.G_EXC_ERROR THEN

2825: FND_MSG_PUB.Count_And_Get
2826: (p_count => x_msg_count ,
2827: p_data => x_msg_data );
2828: EXCEPTION
2829: WHEN FND_API.G_EXC_ERROR THEN
2830: ROLLBACK TO update_inst_party_acct_pub;
2831: x_return_status := FND_API.G_RET_STS_ERROR ;
2832: FND_MSG_PUB.Count_And_Get
2833: ( p_count => x_msg_count,

Line 2831: x_return_status := FND_API.G_RET_STS_ERROR ;

2827: p_data => x_msg_data );
2828: EXCEPTION
2829: WHEN FND_API.G_EXC_ERROR THEN
2830: ROLLBACK TO update_inst_party_acct_pub;
2831: x_return_status := FND_API.G_RET_STS_ERROR ;
2832: FND_MSG_PUB.Count_And_Get
2833: ( p_count => x_msg_count,
2834: p_data => x_msg_data );
2835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2831: x_return_status := FND_API.G_RET_STS_ERROR ;
2832: FND_MSG_PUB.Count_And_Get
2833: ( p_count => x_msg_count,
2834: p_data => x_msg_data );
2835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2836: ROLLBACK TO update_inst_party_acct_pub;
2837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2838: FND_MSG_PUB.Count_And_Get
2839: ( p_count => x_msg_count,

Line 2837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2833: ( p_count => x_msg_count,
2834: p_data => x_msg_data );
2835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2836: ROLLBACK TO update_inst_party_acct_pub;
2837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2838: FND_MSG_PUB.Count_And_Get
2839: ( p_count => x_msg_count,
2840: p_data => x_msg_data );
2841: WHEN OTHERS THEN

Line 2843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2839: ( p_count => x_msg_count,
2840: p_data => x_msg_data );
2841: WHEN OTHERS THEN
2842: ROLLBACK TO update_inst_party_acct_pub;
2843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2844: IF FND_MSG_PUB.Check_Msg_Level
2845: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2846: THEN
2847: FND_MSG_PUB.Add_Exc_Msg

Line 2894: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2890: csi_utility_grp.check_ib_active;
2891:
2892:
2893: -- Standard call to check for call compatibility.
2894: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2895: p_api_version ,
2896: l_api_name ,
2897: g_pkg_name )
2898: THEN

Line 2899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2895: p_api_version ,
2896: l_api_name ,
2897: g_pkg_name )
2898: THEN
2899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2900: END IF;
2901:
2902: -- Initialize message list if p_init_msg_list is set to TRUE.
2903: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2903: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2900: END IF;
2901:
2902: -- Initialize message list if p_init_msg_list is set to TRUE.
2903: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2904: FND_MSG_PUB.initialize;
2905: END IF;
2906:
2907: -- Initialize API return status to success

Line 2908: x_return_status := FND_API.G_RET_STS_SUCCESS;

2904: FND_MSG_PUB.initialize;
2905: END IF;
2906:
2907: -- Initialize API return status to success
2908: x_return_status := FND_API.G_RET_STS_SUCCESS;
2909:
2910: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
2911: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2912:

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

2949: ,x_msg_count => x_msg_count
2950: ,x_msg_data => x_msg_data );
2951:
2952:
2953: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2954: l_msg_index := 1;
2955: l_msg_count := x_msg_count;
2956: WHILE l_msg_count > 0 LOOP
2957: x_msg_data := FND_MSG_PUB.GET(

Line 2959: FND_API.G_FALSE);

2955: l_msg_count := x_msg_count;
2956: WHILE l_msg_count > 0 LOOP
2957: x_msg_data := FND_MSG_PUB.GET(
2958: l_msg_index,
2959: FND_API.G_FALSE);
2960: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2961: l_msg_index := l_msg_index + 1;
2962: l_msg_count := l_msg_count - 1;
2963: END LOOP;

Line 2964: RAISE FND_API.G_EXC_ERROR;

2960: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);
2961: l_msg_index := l_msg_index + 1;
2962: l_msg_count := l_msg_count - 1;
2963: END LOOP;
2964: RAISE FND_API.G_EXC_ERROR;
2965: END IF;
2966: END IF;
2967: END LOOP;
2968: END IF;

Line 2973: IF FND_API.To_Boolean( p_commit ) THEN

2969: --
2970: -- End of API body
2971:
2972: -- Standard check of p_commit.
2973: IF FND_API.To_Boolean( p_commit ) THEN
2974: COMMIT WORK;
2975: END IF;
2976:
2977: /***** srramakr commented for bug # 3304439

Line 2990: WHEN FND_API.G_EXC_ERROR THEN

2986: FND_MSG_PUB.Count_And_Get
2987: (p_count => x_msg_count ,
2988: p_data => x_msg_data );
2989: EXCEPTION
2990: WHEN FND_API.G_EXC_ERROR THEN
2991: ROLLBACK TO expire_inst_party_acct_pub;
2992: x_return_status := FND_API.G_RET_STS_ERROR ;
2993: FND_MSG_PUB.Count_And_Get
2994: ( p_count => x_msg_count,

Line 2992: x_return_status := FND_API.G_RET_STS_ERROR ;

2988: p_data => x_msg_data );
2989: EXCEPTION
2990: WHEN FND_API.G_EXC_ERROR THEN
2991: ROLLBACK TO expire_inst_party_acct_pub;
2992: x_return_status := FND_API.G_RET_STS_ERROR ;
2993: FND_MSG_PUB.Count_And_Get
2994: ( p_count => x_msg_count,
2995: p_data => x_msg_data );
2996:

Line 2997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2993: FND_MSG_PUB.Count_And_Get
2994: ( p_count => x_msg_count,
2995: p_data => x_msg_data );
2996:
2997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2998: ROLLBACK TO expire_inst_party_acct_pub;
2999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3000: FND_MSG_PUB.Count_And_Get
3001: ( p_count => x_msg_count,

Line 2999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2995: p_data => x_msg_data );
2996:
2997: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2998: ROLLBACK TO expire_inst_party_acct_pub;
2999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3000: FND_MSG_PUB.Count_And_Get
3001: ( p_count => x_msg_count,
3002: p_data => x_msg_data );
3003: WHEN OTHERS THEN

Line 3005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3001: ( p_count => x_msg_count,
3002: p_data => x_msg_data );
3003: WHEN OTHERS THEN
3004: ROLLBACK TO expire_inst_party_acct_pub;
3005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3006:
3007: IF FND_MSG_PUB.Check_Msg_Level
3008: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3009: THEN