DBA Data[Home] [Help]

APPS.CSI_PARTY_RELATIONSHIPS_PUB dependencies on CSI_GEN_UTILITY_PVT

Line 80: csi_gen_utility_pvt.put_line( 'get_inst_party_relationship');

76: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
77:
78: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
79: IF (l_csi_debug_level > 0) THEN
80: csi_gen_utility_pvt.put_line( 'get_inst_party_relationship');
81: END IF;
82:
83: -- If the debug level = 2 then dump all the parameters values.
84: IF (l_csi_debug_level > 1) THEN

Line 85: csi_gen_utility_pvt.put_line( 'get_inst_party_relationship' ||

81: END IF;
82:
83: -- If the debug level = 2 then dump all the parameters values.
84: IF (l_csi_debug_level > 1) THEN
85: csi_gen_utility_pvt.put_line( 'get_inst_party_relationship' ||
86: p_api_version ||'-'||
87: p_commit ||'-'||
88: p_init_msg_list ||'-'||
89: p_validation_level ||'-'||

Line 92: csi_gen_utility_pvt.dump_party_query_rec(p_party_query_rec) ;

88: p_init_msg_list ||'-'||
89: p_validation_level ||'-'||
90: p_time_stamp );
91: -- dump the in parameter in the log file
92: csi_gen_utility_pvt.dump_party_query_rec(p_party_query_rec) ;
93: END IF;
94:
95: /***** srramakr commented for bug # 3304439
96: -- Check for the profile option and enable trace

Line 97: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);

93: END IF;
94:
95: /***** srramakr commented for bug # 3304439
96: -- Check for the profile option and enable trace
97: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
98: -- End enable trace
99: ****/
100:
101: -- Start API body

Line 425: csi_gen_utility_pvt.put_line( 'create_inst_party_relationship');

421: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
422:
423: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
424: IF (l_csi_debug_level > 0) THEN
425: csi_gen_utility_pvt.put_line( 'create_inst_party_relationship');
426: END IF;
427:
428:
429: -- If the debug level = 2 then dump all the parameters values.

Line 431: csi_gen_utility_pvt.put_line( 'create_inst_party_relationship'||

427:
428:
429: -- If the debug level = 2 then dump all the parameters values.
430: IF (l_csi_debug_level > 1) THEN
431: csi_gen_utility_pvt.put_line( 'create_inst_party_relationship'||
432: p_api_version ||'-'||
433: p_commit ||'-'||
434: p_init_msg_list ||'-'||
435: p_validation_level );

Line 437: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);

433: p_commit ||'-'||
434: p_init_msg_list ||'-'||
435: p_validation_level );
436: -- Dump the records in the log file
437: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);
438: csi_gen_utility_pvt.dump_party_account_tbl(p_party_account_tbl);
439: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
440: END IF;
441:

Line 438: csi_gen_utility_pvt.dump_party_account_tbl(p_party_account_tbl);

434: p_init_msg_list ||'-'||
435: p_validation_level );
436: -- Dump the records in the log file
437: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);
438: csi_gen_utility_pvt.dump_party_account_tbl(p_party_account_tbl);
439: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
440: END IF;
441:
442: /***** srramakr commented for bug # 3304439

Line 439: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

435: p_validation_level );
436: -- Dump the records in the log file
437: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);
438: csi_gen_utility_pvt.dump_party_account_tbl(p_party_account_tbl);
439: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
440: END IF;
441:
442: /***** srramakr commented for bug # 3304439
443: -- Check for the profile option and enable trace

Line 444: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);

440: END IF;
441:
442: /***** srramakr commented for bug # 3304439
443: -- Check for the profile option and enable trace
444: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
445: -- End enable trace
446: ****/
447:
448: -- Start API body

Line 452: csi_gen_utility_pvt.populate_install_param_rec;

448: -- Start API body
449: --
450: -- Grab the internal party id from csi_installed paramters
451: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
452: csi_gen_utility_pvt.populate_install_param_rec;
453: END IF;
454: --
455: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
456: --

Line 548: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

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;
552: RAISE FND_API.G_EXC_ERROR;

Line 640: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);

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;
644: RAISE FND_API.G_EXC_ERROR;

Line 865: csi_gen_utility_pvt.put_line( 'update_inst_party_relationship ');

861: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
862:
863: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
864: IF (l_csi_debug_level > 0) THEN
865: csi_gen_utility_pvt.put_line( 'update_inst_party_relationship ');
866: END IF;
867:
868:
869: -- If the debug level = 2 then dump all the parameters values.

Line 871: csi_gen_utility_pvt.put_line( 'update_inst_party_relationship:' ||

867:
868:
869: -- If the debug level = 2 then dump all the parameters values.
870: IF (l_csi_debug_level > 1) THEN
871: csi_gen_utility_pvt.put_line( 'update_inst_party_relationship:' ||
872: p_api_version ||'-'||
873: p_commit ||'-'||
874: p_init_msg_list ||'-'||
875: p_validation_level );

Line 877: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);

873: p_commit ||'-'||
874: p_init_msg_list ||'-'||
875: p_validation_level );
876: -- Dump the records in the log file
877: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);
878: csi_gen_utility_pvt.dump_party_account_tbl(p_party_account_tbl);
879: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
880:
881: END IF;

Line 878: csi_gen_utility_pvt.dump_party_account_tbl(p_party_account_tbl);

874: p_init_msg_list ||'-'||
875: p_validation_level );
876: -- Dump the records in the log file
877: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);
878: csi_gen_utility_pvt.dump_party_account_tbl(p_party_account_tbl);
879: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
880:
881: END IF;
882:

Line 879: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

875: p_validation_level );
876: -- Dump the records in the log file
877: csi_gen_utility_pvt.dump_party_tbl(p_party_tbl);
878: csi_gen_utility_pvt.dump_party_account_tbl(p_party_account_tbl);
879: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
880:
881: END IF;
882:
883: /***** srramakr commented for bug # 3304439

Line 885: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);

881: END IF;
882:
883: /***** srramakr commented for bug # 3304439
884: -- Check for the profile option and enable trace
885: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
886: -- End enable trace
887: ****/
888:
889: -- Start API body

Line 926: csi_gen_utility_pvt.put_line('l_old_party_tbl(lp_count).call_contracts'||l_old_party_tbl(lp_count).call_contracts);

922: l_old_party_tbl(lp_count).instance_party_id := l_old_party_csr.instance_party_id;
923: l_old_party_tbl(lp_count).party_id := l_old_party_csr.party_id;
924: l_old_party_tbl(lp_count).cascade_ownership_flag := nvl(p_party_tbl(p_csr).cascade_ownership_flag,'N'); --Added for cascade 2972082
925: l_old_party_tbl(lp_count).call_contracts := p_party_tbl(p_csr).call_contracts; -- added for bug #14843691
926: csi_gen_utility_pvt.put_line('l_old_party_tbl(lp_count).call_contracts'||l_old_party_tbl(lp_count).call_contracts);
927: -- The following code has been written to grab the old owner party_id
928: -- for an instance.
929: lpa_count:= p_party_account_tbl.count;
930: IF lpa_count > 0 THEN

Line 951: csi_gen_utility_pvt.populate_install_param_rec;

947: END IF; -- end if for l_pty_count > 0
948: -- End addition for bug 2151750
949: --
950: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
951: csi_gen_utility_pvt.populate_install_param_rec;
952: END IF;
953: --
954: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
955: --

Line 1125: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

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;
1129: RAISE FND_API.G_EXC_ERROR;

Line 1238: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

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;
1242: RAISE FND_API.G_EXC_ERROR;

Line 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);

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);
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;

Line 1292: csi_gen_utility_pvt.put_line(' account old active_end_date : '||exp_acct_rec.active_end_date);

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);
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

Line 1293: csi_gen_utility_pvt.put_line(' account new active_end_date : '||l_exp_acct_rec.active_end_date);

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);
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

Line 1294: csi_gen_utility_pvt.put_line(' sysdate : '||SYSDATE);

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);
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

Line 1319: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

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;
1323: RAISE FND_API.G_EXC_ERROR;

Line 1347: csi_gen_utility_pvt.put_line('Expiring party record '||l_exp_party_rec.instance_party_id||' of party type '||l_exp_party_rec.relationship_type_code);

1343: END IF;
1344: -- End of 3804960
1345: -- Add log output for bug 7333900
1346: IF (l_csi_debug_level > 0) THEN
1347: csi_gen_utility_pvt.put_line('Expiring party record '||l_exp_party_rec.instance_party_id||' of party type '||l_exp_party_rec.relationship_type_code);
1348: csi_gen_utility_pvt.put_line(' party old active_end_date : '||l_exp_pty.active_end_date);
1349: csi_gen_utility_pvt.put_line(' party new active_end_date : '||l_exp_party_rec.active_end_date);
1350: csi_gen_utility_pvt.put_line(' sysdate : '||SYSDATE);
1351: END IF;

Line 1348: csi_gen_utility_pvt.put_line(' party old active_end_date : '||l_exp_pty.active_end_date);

1344: -- End of 3804960
1345: -- Add log output for bug 7333900
1346: IF (l_csi_debug_level > 0) THEN
1347: csi_gen_utility_pvt.put_line('Expiring party record '||l_exp_party_rec.instance_party_id||' of party type '||l_exp_party_rec.relationship_type_code);
1348: csi_gen_utility_pvt.put_line(' party old active_end_date : '||l_exp_pty.active_end_date);
1349: csi_gen_utility_pvt.put_line(' party new active_end_date : '||l_exp_party_rec.active_end_date);
1350: csi_gen_utility_pvt.put_line(' sysdate : '||SYSDATE);
1351: END IF;
1352: csi_party_relationships_pvt.update_inst_party_relationship

Line 1349: csi_gen_utility_pvt.put_line(' party new active_end_date : '||l_exp_party_rec.active_end_date);

1345: -- Add log output for bug 7333900
1346: IF (l_csi_debug_level > 0) THEN
1347: csi_gen_utility_pvt.put_line('Expiring party record '||l_exp_party_rec.instance_party_id||' of party type '||l_exp_party_rec.relationship_type_code);
1348: csi_gen_utility_pvt.put_line(' party old active_end_date : '||l_exp_pty.active_end_date);
1349: csi_gen_utility_pvt.put_line(' party new active_end_date : '||l_exp_party_rec.active_end_date);
1350: csi_gen_utility_pvt.put_line(' sysdate : '||SYSDATE);
1351: END IF;
1352: csi_party_relationships_pvt.update_inst_party_relationship
1353: ( p_api_version => p_api_version

Line 1350: csi_gen_utility_pvt.put_line(' sysdate : '||SYSDATE);

1346: IF (l_csi_debug_level > 0) THEN
1347: csi_gen_utility_pvt.put_line('Expiring party record '||l_exp_party_rec.instance_party_id||' of party type '||l_exp_party_rec.relationship_type_code);
1348: csi_gen_utility_pvt.put_line(' party old active_end_date : '||l_exp_pty.active_end_date);
1349: csi_gen_utility_pvt.put_line(' party new active_end_date : '||l_exp_party_rec.active_end_date);
1350: csi_gen_utility_pvt.put_line(' sysdate : '||SYSDATE);
1351: END IF;
1352: csi_party_relationships_pvt.update_inst_party_relationship
1353: ( p_api_version => p_api_version
1354: ,p_commit => p_commit

Line 1371: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

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;
1375: RAISE FND_API.G_EXC_ERROR;

Line 1424: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

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;
1428: RAISE FND_API.G_EXC_ERROR;

Line 1525: csi_gen_utility_pvt.put_line('l_ip_acct_rec.call_contracts : '||l_ip_acct_rec.call_contracts);

1521: l_ip_acct_rec := l_temp_acct_rec;
1522: l_new_ip_acct_rec :=l_temp_acct_rec;
1523: END;
1524: l_ip_acct_rec.call_contracts := l_old_party_tbl(l_old_party_row).call_contracts;--Added for Bug#14843691
1525: csi_gen_utility_pvt.put_line('l_ip_acct_rec.call_contracts : '||l_ip_acct_rec.call_contracts);
1526: -- End of code addition for fixing bug 6368172, section 3 of 5
1527:
1528: -- If the retreived party records party_id has been changed then
1529: -- we can assume that a transfer of ownership has taken place in

Line 1663: csi_gen_utility_pvt.put_line('l_cascade_ownership_uimu: ' || l_cascade_ownership_uimu);

1659: END IF;
1660:
1661: --Added for Bug 10414588
1662: l_cascade_ownership_uimu := FND_PROFILE.VALUE('CSI_FORCE_CASCADE_OWNER_UIMU');
1663: csi_gen_utility_pvt.put_line('l_cascade_ownership_uimu: ' || l_cascade_ownership_uimu);
1664: csi_gen_utility_pvt.put_line('cascade_ownership_flag: ' || l_old_party_tbl(l_old_party_row).cascade_ownership_flag);
1665:
1666: l_force_cascade := 'N';
1667: IF p_txn_rec.transaction_type_id IN (1,3) THEN

Line 1664: csi_gen_utility_pvt.put_line('cascade_ownership_flag: ' || l_old_party_tbl(l_old_party_row).cascade_ownership_flag);

1660:
1661: --Added for Bug 10414588
1662: l_cascade_ownership_uimu := FND_PROFILE.VALUE('CSI_FORCE_CASCADE_OWNER_UIMU');
1663: csi_gen_utility_pvt.put_line('l_cascade_ownership_uimu: ' || l_cascade_ownership_uimu);
1664: csi_gen_utility_pvt.put_line('cascade_ownership_flag: ' || l_old_party_tbl(l_old_party_row).cascade_ownership_flag);
1665:
1666: l_force_cascade := 'N';
1667: IF p_txn_rec.transaction_type_id IN (1,3) THEN
1668: l_force_cascade := NVL(l_cascade_ownership_uimu, 'N');

Line 1673: csi_gen_utility_pvt.put_line('l_force_cascade: ' || l_force_cascade);

1669: ELSE
1670: l_force_cascade := nvl(l_old_party_tbl(l_old_party_row).cascade_ownership_flag,'N');
1671: END IF;
1672:
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

Line 1715: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

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;
1719: RAISE FND_API.G_EXC_ERROR;

Line 1768: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

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;
1772: RAISE FND_API.G_EXC_ERROR;

Line 1826: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

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;
1830: RAISE FND_API.G_EXC_ERROR;

Line 1901: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

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;
1905: RAISE FND_API.G_EXC_ERROR;

Line 2027: csi_gen_utility_pvt.put_line( 'expire_inst_party_relationship');

2023: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2024:
2025: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
2026: IF (l_csi_debug_level > 0) THEN
2027: csi_gen_utility_pvt.put_line( 'expire_inst_party_relationship');
2028: END IF;
2029:
2030: -- If the debug level = 2 then dump all the parameters values.
2031: IF (l_csi_debug_level > 1) THEN

Line 2032: csi_gen_utility_pvt.put_line( 'expire_inst_party_relationship:' ||

2028: END IF;
2029:
2030: -- If the debug level = 2 then dump all the parameters values.
2031: IF (l_csi_debug_level > 1) THEN
2032: csi_gen_utility_pvt.put_line( 'expire_inst_party_relationship:' ||
2033: p_api_version ||'-'||
2034: p_commit ||'-'||
2035: p_init_msg_list ||'-'||
2036: p_validation_level );

Line 2038: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

2034: p_commit ||'-'||
2035: p_init_msg_list ||'-'||
2036: p_validation_level );
2037: -- Dump the records in the log file
2038: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
2039: csi_gen_utility_pvt.dump_party_tbl(p_instance_party_tbl);
2040: END IF;
2041:
2042: /***** srramakr commented for bug # 3304439

Line 2039: csi_gen_utility_pvt.dump_party_tbl(p_instance_party_tbl);

2035: p_init_msg_list ||'-'||
2036: p_validation_level );
2037: -- Dump the records in the log file
2038: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
2039: csi_gen_utility_pvt.dump_party_tbl(p_instance_party_tbl);
2040: END IF;
2041:
2042: /***** srramakr commented for bug # 3304439
2043: -- Check for the profile option and enable trace

Line 2044: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);

2040: END IF;
2041:
2042: /***** srramakr commented for bug # 3304439
2043: -- Check for the profile option and enable trace
2044: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
2045: -- End enable trace
2046: ****/
2047:
2048: -- Start API body

Line 2071: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

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;
2075: RAISE FND_API.G_EXC_ERROR;

Line 2202: csi_gen_utility_pvt.put_line( 'get_inst_party_accounts');

2198: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2199:
2200: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
2201: IF (l_csi_debug_level > 0) THEN
2202: csi_gen_utility_pvt.put_line( 'get_inst_party_accounts');
2203: END IF;
2204:
2205: -- If the debug level = 2 then dump all the parameters values.
2206: IF (l_csi_debug_level > 1) THEN

Line 2208: csi_gen_utility_pvt.put_line( 'get_inst_party_account:' ||

2204:
2205: -- If the debug level = 2 then dump all the parameters values.
2206: IF (l_csi_debug_level > 1) THEN
2207:
2208: csi_gen_utility_pvt.put_line( 'get_inst_party_account:' ||
2209: p_api_version ||'-'||
2210: p_commit ||'-'||
2211: p_init_msg_list ||'-'||
2212: p_validation_level ||'-'||

Line 2215: csi_gen_utility_pvt.dump_account_query_rec(p_account_query_rec);

2211: p_init_msg_list ||'-'||
2212: p_validation_level ||'-'||
2213: p_time_stamp );
2214: -- Dump the account query records
2215: csi_gen_utility_pvt.dump_account_query_rec(p_account_query_rec);
2216:
2217: END IF;
2218:
2219: /***** srramakr commented for bug # 3304439

Line 2221: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);

2217: END IF;
2218:
2219: /***** srramakr commented for bug # 3304439
2220: -- Check for the profile option and enable trace
2221: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
2222: -- End enable trace
2223: ****/
2224:
2225: -- Start API body

Line 2407: csi_gen_utility_pvt.put_line( 'create_inst_party_account');

2403: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2404:
2405: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
2406: IF (l_csi_debug_level > 0) THEN
2407: csi_gen_utility_pvt.put_line( 'create_inst_party_account');
2408: END IF;
2409:
2410: -- If the debug level = 2 then dump all the parameters values.
2411: IF (l_csi_debug_level > 1) THEN

Line 2412: csi_gen_utility_pvt.put_line( 'create_inst_party_account:'||

2408: END IF;
2409:
2410: -- If the debug level = 2 then dump all the parameters values.
2411: IF (l_csi_debug_level > 1) THEN
2412: csi_gen_utility_pvt.put_line( 'create_inst_party_account:'||
2413: p_api_version ||'-'||
2414: p_commit ||'-'||
2415: p_init_msg_list );
2416: -- Dump the records in the log file

Line 2417: csi_gen_utility_pvt.dump_party_account_tbl(p_party_account_tbl);

2413: p_api_version ||'-'||
2414: p_commit ||'-'||
2415: p_init_msg_list );
2416: -- Dump the records in the log file
2417: csi_gen_utility_pvt.dump_party_account_tbl(p_party_account_tbl);
2418: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
2419: END IF;
2420:
2421: /***** srramakr commented for bug # 3304439

Line 2418: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

2414: p_commit ||'-'||
2415: p_init_msg_list );
2416: -- Dump the records in the log file
2417: csi_gen_utility_pvt.dump_party_account_tbl(p_party_account_tbl);
2418: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
2419: END IF;
2420:
2421: /***** srramakr commented for bug # 3304439
2422: -- Check for the profile option and enable trace

Line 2423: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);

2419: END IF;
2420:
2421: /***** srramakr commented for bug # 3304439
2422: -- Check for the profile option and enable trace
2423: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
2424: -- End enable trace
2425: ****/
2426:
2427: -- Start API body

Line 2459: csi_gen_utility_pvt.put_line( 'message data = '||x_msg_data);

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;
2463: RAISE FND_API.G_EXC_ERROR;

Line 2594: csi_gen_utility_pvt.put_line( 'update_inst_party_account');

2590: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2591:
2592: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
2593: IF (l_csi_debug_level > 0) THEN
2594: csi_gen_utility_pvt.put_line( 'update_inst_party_account');
2595: END IF;
2596:
2597: -- If the debug level = 2 then dump all the parameters values.
2598: IF (l_csi_debug_level > 1) THEN

Line 2599: csi_gen_utility_pvt.put_line( 'update_inst_party_account:'||

2595: END IF;
2596:
2597: -- If the debug level = 2 then dump all the parameters values.
2598: IF (l_csi_debug_level > 1) THEN
2599: csi_gen_utility_pvt.put_line( 'update_inst_party_account:'||
2600: p_api_version ||'-'||
2601: p_commit ||'-'||
2602: p_init_msg_list );
2603: -- Dump the records in the log file

Line 2604: csi_gen_utility_pvt.dump_party_account_tbl(p_party_account_tbl);

2600: p_api_version ||'-'||
2601: p_commit ||'-'||
2602: p_init_msg_list );
2603: -- Dump the records in the log file
2604: csi_gen_utility_pvt.dump_party_account_tbl(p_party_account_tbl);
2605: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
2606: END IF;
2607:
2608: /***** srramakr commented for bug # 3304439

Line 2605: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

2601: p_commit ||'-'||
2602: p_init_msg_list );
2603: -- Dump the records in the log file
2604: csi_gen_utility_pvt.dump_party_account_tbl(p_party_account_tbl);
2605: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
2606: END IF;
2607:
2608: /***** srramakr commented for bug # 3304439
2609: -- Check for the profile option and enable trace

Line 2610: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);

2606: END IF;
2607:
2608: /***** srramakr commented for bug # 3304439
2609: -- Check for the profile option and enable trace
2610: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
2611: -- End enable trace
2612: ****/
2613:
2614: -- Start API body

Line 2661: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

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;
2665: RAISE FND_API.G_EXC_ERROR;

Line 2792: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

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;
2796: RAISE FND_API.G_EXC_ERROR;

Line 2915: csi_gen_utility_pvt.put_line( 'expire_inst_party_account');

2911: l_csi_debug_level:=fnd_profile.value('CSI_DEBUG_LEVEL');
2912:
2913: -- If CSI_DEBUG_LEVEL = 1 then dump the procedure name
2914: IF (l_csi_debug_level > 0) THEN
2915: csi_gen_utility_pvt.put_line( 'expire_inst_party_account');
2916: END IF;
2917:
2918:
2919: -- If the debug level = 2 then dump all the parameters values.

Line 2921: csi_gen_utility_pvt.put_line( 'expire_inst_party_account:'||

2917:
2918:
2919: -- If the debug level = 2 then dump all the parameters values.
2920: IF (l_csi_debug_level > 1) THEN
2921: csi_gen_utility_pvt.put_line( 'expire_inst_party_account:'||
2922: p_api_version ||'-'||
2923: p_commit ||'-'||
2924: p_init_msg_list );
2925: -- Dump the records in the log file

Line 2926: csi_gen_utility_pvt.dump_party_account_tbl(p_party_account_tbl);

2922: p_api_version ||'-'||
2923: p_commit ||'-'||
2924: p_init_msg_list );
2925: -- Dump the records in the log file
2926: csi_gen_utility_pvt.dump_party_account_tbl(p_party_account_tbl);
2927: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
2928: END IF;
2929:
2930: /***** srramakr commented for bug # 3304439

Line 2927: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);

2923: p_commit ||'-'||
2924: p_init_msg_list );
2925: -- Dump the records in the log file
2926: csi_gen_utility_pvt.dump_party_account_tbl(p_party_account_tbl);
2927: csi_gen_utility_pvt.dump_txn_rec(p_txn_rec);
2928: END IF;
2929:
2930: /***** srramakr commented for bug # 3304439
2931: -- Check for the profile option and enable trace

Line 2932: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);

2928: END IF;
2929:
2930: /***** srramakr commented for bug # 3304439
2931: -- Check for the profile option and enable trace
2932: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
2933: -- End enable trace
2934: ****/
2935:
2936: -- Start API body

Line 2960: csi_gen_utility_pvt.put_line('message data = '||x_msg_data);

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;
2964: RAISE FND_API.G_EXC_ERROR;