DBA Data[Home] [Help]

APPS.CZ_IB_TRANSACTIONS dependencies on FND_API

Line 61: fnd_msg_pub.GET(i,fnd_api.g_false),

57: USER,
58: 1,
59: 'CZ_IB_TRANSACTIONS',
60: 11276,
61: fnd_msg_pub.GET(i,fnd_api.g_false),
62: m_COUNTER);
63: COMMIT;
64:
65: cz_utils.log_report('CZ_IB_TRANSACTIONS', null, m_COUNTER,

Line 66: fnd_msg_pub.GET(i,fnd_api.g_false), fnd_log.LEVEL_ERROR);

62: m_COUNTER);
63: COMMIT;
64:
65: cz_utils.log_report('CZ_IB_TRANSACTIONS', null, m_COUNTER,
66: fnd_msg_pub.GET(i,fnd_api.g_false), fnd_log.LEVEL_ERROR);
67: END LOOP;
68:
69: END IF;
70:

Line 200: x_return_status := FND_API.g_ret_sts_unexp_error;

196: x_msg_count := CZ_IB_TRANSACTIONS.m_msg_count;
197: x_msg_data := CZ_IB_TRANSACTIONS.m_msg_data;
198: EXCEPTION
199: WHEN OTHERS THEN
200: x_return_status := FND_API.g_ret_sts_unexp_error;
201: x_msg_count := 1;
202: x_msg_data := 'CZ_IB_TRANSACTIONS.delete_transaction_dtls : '||SQLERRM;
203: LOG_REPORT(m_RUN_ID,x_msg_data);
204: END delete_transaction_dtls;

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

205:
206:
207: PROCEDURE create_transaction_dtls(
208: p_api_version IN NUMBER,
209: p_commit IN VARCHAR2 := fnd_api.g_false,
210: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
211: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
212: px_txn_line_rec IN OUT NOCOPY txn_line_rec ,
213: px_txn_line_detail_tbl IN OUT NOCOPY txn_line_detail_tbl,

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

206:
207: PROCEDURE create_transaction_dtls(
208: p_api_version IN NUMBER,
209: p_commit IN VARCHAR2 := fnd_api.g_false,
210: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
211: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
212: px_txn_line_rec IN OUT NOCOPY txn_line_rec ,
213: px_txn_line_detail_tbl IN OUT NOCOPY txn_line_detail_tbl,
214: px_txn_party_detail_tbl IN OUT NOCOPY txn_party_detail_tbl ,

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

207: PROCEDURE create_transaction_dtls(
208: p_api_version IN NUMBER,
209: p_commit IN VARCHAR2 := fnd_api.g_false,
210: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
211: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
212: px_txn_line_rec IN OUT NOCOPY txn_line_rec ,
213: px_txn_line_detail_tbl IN OUT NOCOPY txn_line_detail_tbl,
214: px_txn_party_detail_tbl IN OUT NOCOPY txn_party_detail_tbl ,
215: px_txn_pty_acct_detail_tbl IN OUT NOCOPY txn_pty_acct_detail_tbl,

Line 346: x_return_status := FND_API.g_ret_sts_unexp_error;

342: x_msg_count := CZ_IB_TRANSACTIONS.m_msg_count;
343: x_msg_data := CZ_IB_TRANSACTIONS.m_msg_data;
344: EXCEPTION
345: WHEN OTHERS THEN
346: x_return_status := FND_API.g_ret_sts_unexp_error;
347: x_msg_count := 1;
348: x_msg_data := 'CZ_IB_TRANSACTIONS.create_transaction_dtls : '||SQLERRM;
349: LOG_REPORT(m_RUN_ID,x_msg_data);
350: END create_transaction_dtls;

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

351:
352:
353: PROCEDURE create_txn_ii_rltns_dtls(
354: p_api_version IN NUMBER,
355: p_commit IN VARCHAR2 := fnd_api.g_false,
356: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
357: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
358: px_txn_ii_rltns_tbl IN OUT NOCOPY txn_ii_rltns_tbl,
359: x_return_status OUT NOCOPY VARCHAR2,

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

352:
353: PROCEDURE create_txn_ii_rltns_dtls(
354: p_api_version IN NUMBER,
355: p_commit IN VARCHAR2 := fnd_api.g_false,
356: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
357: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
358: px_txn_ii_rltns_tbl IN OUT NOCOPY txn_ii_rltns_tbl,
359: x_return_status OUT NOCOPY VARCHAR2,
360: x_msg_count OUT NOCOPY NUMBER,

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

353: PROCEDURE create_txn_ii_rltns_dtls(
354: p_api_version IN NUMBER,
355: p_commit IN VARCHAR2 := fnd_api.g_false,
356: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
357: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
358: px_txn_ii_rltns_tbl IN OUT NOCOPY txn_ii_rltns_tbl,
359: x_return_status OUT NOCOPY VARCHAR2,
360: x_msg_count OUT NOCOPY NUMBER,
361: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 453: x_return_status := FND_API.g_ret_sts_unexp_error;

449: x_msg_data := CZ_IB_TRANSACTIONS.m_msg_data;
450:
451: EXCEPTION
452: WHEN OTHERS THEN
453: x_return_status := FND_API.g_ret_sts_unexp_error;
454: x_msg_count := 1;
455: x_msg_data := 'CZ_IB_TRANSACTIONS.create_txn_ii_rltns_dtls : '||SQLERRM;
456: LOG_REPORT(m_RUN_ID,x_msg_data);
457: END create_txn_ii_rltns_dtls;

Line 550: x_return_status := FND_API.g_ret_sts_unexp_error;

546: x_return_message := CZ_IB_TRANSACTIONS.m_return_message;
547:
548: EXCEPTION
549: WHEN OTHERS THEN
550: x_return_status := FND_API.g_ret_sts_unexp_error;
551: x_return_message := 'CZ_IB_TRANSACTIONS.Get_Connected_Configurations : '||SQLERRM;
552:
553: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
554: cz_utils.log_report('CZ_IB_TRANSACTIONS', 'get_connected_configurations', l_ndebug,

Line 636: x_return_status := FND_API.g_ret_sts_unexp_error;

632: x_return_message := CZ_IB_TRANSACTIONS.m_return_message;
633:
634: EXCEPTION
635: WHEN OTHERS THEN
636: x_return_status := FND_API.g_ret_sts_unexp_error;
637: x_return_message := 'CZ_IB_TRANSACTIONS.Get_Configuration_Revision : '||SQLERRM;
638: LOG_REPORT(m_RUN_ID,x_return_message);
639:
640: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 723: v_return_status VARCHAR2(255) := fnd_api.g_ret_sts_success;

719: t_subject_tbl int_array_tbl_type;
720: t_transaction_line_tbl int_array_tbl_type;
721:
722: v_transaction_line_id NUMBER;
723: v_return_status VARCHAR2(255) := fnd_api.g_ret_sts_success;
724: v_msg_data VARCHAR2(2000);
725: v_msg_count NUMBER;
726:
727: BEGIN

Line 757: ,p_commit => fnd_api.g_false

753: -- csi_t_txn_details_grp.delete_transaction_dtls --
754: delete_transaction_dtls
755: (
756: p_api_version => 1.0
757: ,p_commit => fnd_api.g_false
758: ,p_init_msg_list => fnd_api.g_false
759: ,p_validation_level => fnd_api.g_valid_level_none
760: ,p_api_caller_identity => 'CONFIG'
761: ,p_transaction_line_id => v_transaction_line_id

Line 758: ,p_init_msg_list => fnd_api.g_false

754: delete_transaction_dtls
755: (
756: p_api_version => 1.0
757: ,p_commit => fnd_api.g_false
758: ,p_init_msg_list => fnd_api.g_false
759: ,p_validation_level => fnd_api.g_valid_level_none
760: ,p_api_caller_identity => 'CONFIG'
761: ,p_transaction_line_id => v_transaction_line_id
762: ,x_return_status => v_return_status

Line 759: ,p_validation_level => fnd_api.g_valid_level_none

755: (
756: p_api_version => 1.0
757: ,p_commit => fnd_api.g_false
758: ,p_init_msg_list => fnd_api.g_false
759: ,p_validation_level => fnd_api.g_valid_level_none
760: ,p_api_caller_identity => 'CONFIG'
761: ,p_transaction_line_id => v_transaction_line_id
762: ,x_return_status => v_return_status
763: ,x_msg_count => v_msg_count

Line 767: IF (v_return_status <> fnd_api.g_ret_sts_success) THEN

763: ,x_msg_count => v_msg_count
764: ,x_msg_data => v_msg_data
765: );
766:
767: IF (v_return_status <> fnd_api.g_ret_sts_success) THEN
768: x_run_id:=m_RUN_ID;
769: LOG_REPORT(m_RUN_ID,
770: 'Deleting failed for txn line : transaction_line_id='||TO_CHAR(v_transaction_line_id)||' IB API error message : '||v_msg_data,
771: v_msg_count);

Line 798: ,p_commit => fnd_api.g_false

794: -- csi_t_txn_details_grp.delete_transaction_dtls --
795: delete_transaction_dtls
796: (
797: p_api_version => 1.0
798: ,p_commit => fnd_api.g_false
799: ,p_init_msg_list => fnd_api.g_false
800: ,p_validation_level => fnd_api.g_valid_level_none
801: ,p_api_caller_identity => 'CONFIG'
802: ,p_transaction_line_id => v_transaction_line_id

Line 799: ,p_init_msg_list => fnd_api.g_false

795: delete_transaction_dtls
796: (
797: p_api_version => 1.0
798: ,p_commit => fnd_api.g_false
799: ,p_init_msg_list => fnd_api.g_false
800: ,p_validation_level => fnd_api.g_valid_level_none
801: ,p_api_caller_identity => 'CONFIG'
802: ,p_transaction_line_id => v_transaction_line_id
803: ,x_return_status => v_return_status

Line 800: ,p_validation_level => fnd_api.g_valid_level_none

796: (
797: p_api_version => 1.0
798: ,p_commit => fnd_api.g_false
799: ,p_init_msg_list => fnd_api.g_false
800: ,p_validation_level => fnd_api.g_valid_level_none
801: ,p_api_caller_identity => 'CONFIG'
802: ,p_transaction_line_id => v_transaction_line_id
803: ,x_return_status => v_return_status
804: ,x_msg_count => v_msg_count

Line 808: IF (v_return_status <> fnd_api.g_ret_sts_success) THEN

804: ,x_msg_count => v_msg_count
805: ,x_msg_data => v_msg_data
806: );
807:
808: IF (v_return_status <> fnd_api.g_ret_sts_success) THEN
809: x_run_id:=m_RUN_ID;
810: LOG_REPORT(m_RUN_ID,'Deleting failed for txn line : transaction_line_id='||
811: TO_CHAR(v_transaction_line_id)||' IB API error message : '||v_msg_data,v_msg_count);
812: END IF;

Line 874: v_return_status VARCHAR2(255) := fnd_api.g_ret_sts_success;

870: tv_txn_systems_tbl txn_systems_tbl;
871: tv_txn_ii_rltns_tbl txn_ii_rltns_tbl;
872: tv_txn_ext_attrib_vals_tbl txn_ext_attrib_vals_tbl;
873:
874: v_return_status VARCHAR2(255) := fnd_api.g_ret_sts_success;
875: v_msg_data VARCHAR2(2000);
876: v_msg_count NUMBER;
877: t_component_instance_type_tbl char_array_tbl_type;
878: t_config_hdr_tbl int_array_tbl_type;

Line 1177: t_txn_line_dtls_tbl(v_txn_line_dtls_ind).location_id := FND_API.G_MISS_NUM;

1173: IF t_component_instance_type_tbl(i)='I' THEN
1174: t_txn_line_dtls_tbl(v_txn_line_dtls_ind).location_id := t_location_tbl(i);
1175: t_txn_line_dtls_tbl(v_txn_line_dtls_ind).location_type_code := t_location_type_code_tbl(i);
1176: ELSE
1177: t_txn_line_dtls_tbl(v_txn_line_dtls_ind).location_id := FND_API.G_MISS_NUM;
1178: t_txn_line_dtls_tbl(v_txn_line_dtls_ind).location_type_code := FND_API.G_MISS_CHAR;
1179: END IF;
1180:
1181: t_txn_line_dtls_tbl(v_txn_line_dtls_ind).inventory_item_id := t_inventory_item_tbl(i);

Line 1178: t_txn_line_dtls_tbl(v_txn_line_dtls_ind).location_type_code := FND_API.G_MISS_CHAR;

1174: t_txn_line_dtls_tbl(v_txn_line_dtls_ind).location_id := t_location_tbl(i);
1175: t_txn_line_dtls_tbl(v_txn_line_dtls_ind).location_type_code := t_location_type_code_tbl(i);
1176: ELSE
1177: t_txn_line_dtls_tbl(v_txn_line_dtls_ind).location_id := FND_API.G_MISS_NUM;
1178: t_txn_line_dtls_tbl(v_txn_line_dtls_ind).location_type_code := FND_API.G_MISS_CHAR;
1179: END IF;
1180:
1181: t_txn_line_dtls_tbl(v_txn_line_dtls_ind).inventory_item_id := t_inventory_item_tbl(i);
1182: t_txn_line_dtls_tbl(v_txn_line_dtls_ind).inv_organization_id := t_organization_tbl(i);

Line 1434: p_commit => fnd_api.g_false,

1430:
1431: -- csi_t_txn_details_grp.create_transaction_dtls --
1432: create_transaction_dtls
1433: (p_api_version => 1.0,
1434: p_commit => fnd_api.g_false,
1435: p_init_msg_list => fnd_api.g_true,
1436: p_validation_level => fnd_api.g_valid_level_full,
1437: px_txn_line_rec => v_txn_line,
1438: px_txn_line_detail_tbl => tv_txn_line_dtls_tbl,

Line 1435: p_init_msg_list => fnd_api.g_true,

1431: -- csi_t_txn_details_grp.create_transaction_dtls --
1432: create_transaction_dtls
1433: (p_api_version => 1.0,
1434: p_commit => fnd_api.g_false,
1435: p_init_msg_list => fnd_api.g_true,
1436: p_validation_level => fnd_api.g_valid_level_full,
1437: px_txn_line_rec => v_txn_line,
1438: px_txn_line_detail_tbl => tv_txn_line_dtls_tbl,
1439: px_txn_party_detail_tbl => tv_txn_party_tbl,

Line 1436: p_validation_level => fnd_api.g_valid_level_full,

1432: create_transaction_dtls
1433: (p_api_version => 1.0,
1434: p_commit => fnd_api.g_false,
1435: p_init_msg_list => fnd_api.g_true,
1436: p_validation_level => fnd_api.g_valid_level_full,
1437: px_txn_line_rec => v_txn_line,
1438: px_txn_line_detail_tbl => tv_txn_line_dtls_tbl,
1439: px_txn_party_detail_tbl => tv_txn_party_tbl,
1440: px_txn_pty_acct_detail_tbl => t_txn_pty_acct_tbl,

Line 1452: IF (v_return_status <> fnd_api.g_ret_sts_success) THEN

1448:
1449: -- bug #3646589
1450: tv_txn_eav_tbl.DELETE;
1451:
1452: IF (v_return_status <> fnd_api.g_ret_sts_success) THEN
1453: x_run_id:=m_RUN_ID;
1454: LOG_REPORT(x_run_id,v_msg_data,v_msg_count);
1455: END IF;
1456:

Line 1522: v_return_status VARCHAR2(255) := fnd_api.g_ret_sts_success;

1518: x_run_id OUT NOCOPY NUMBER
1519: ) IS
1520: t_rltns_tbl txn_ii_rltns_tbl;
1521: t_enddated_rltns_tbl txn_ii_rltns_tbl;
1522: v_return_status VARCHAR2(255) := fnd_api.g_ret_sts_success;
1523: v_transaction_line_id NUMBER;
1524: v_msg_data VARCHAR2(2000);
1525: v_msg_count NUMBER;
1526: v_run_id NUMBER;

Line 1736: p_commit => fnd_api.g_false,

1732: -- csi_t_txn_rltnshps_grp.create_txn_ii_rltns_dtls --
1733: create_txn_ii_rltns_dtls
1734: (
1735: p_api_version => 1.0,
1736: p_commit => fnd_api.g_false,
1737: p_init_msg_list => fnd_api.g_true,
1738: p_validation_level => fnd_api.g_valid_level_full,
1739: px_txn_ii_rltns_tbl => t_enddated_rltns_tbl,
1740: x_return_status => v_return_status,

Line 1737: p_init_msg_list => fnd_api.g_true,

1733: create_txn_ii_rltns_dtls
1734: (
1735: p_api_version => 1.0,
1736: p_commit => fnd_api.g_false,
1737: p_init_msg_list => fnd_api.g_true,
1738: p_validation_level => fnd_api.g_valid_level_full,
1739: px_txn_ii_rltns_tbl => t_enddated_rltns_tbl,
1740: x_return_status => v_return_status,
1741: x_msg_count => v_msg_count,

Line 1738: p_validation_level => fnd_api.g_valid_level_full,

1734: (
1735: p_api_version => 1.0,
1736: p_commit => fnd_api.g_false,
1737: p_init_msg_list => fnd_api.g_true,
1738: p_validation_level => fnd_api.g_valid_level_full,
1739: px_txn_ii_rltns_tbl => t_enddated_rltns_tbl,
1740: x_return_status => v_return_status,
1741: x_msg_count => v_msg_count,
1742: x_msg_data => v_msg_data

Line 1745: IF (v_return_status <> fnd_api.g_ret_sts_success) THEN

1741: x_msg_count => v_msg_count,
1742: x_msg_data => v_msg_data
1743: );
1744:
1745: IF (v_return_status <> fnd_api.g_ret_sts_success) THEN
1746: x_run_id:=m_RUN_ID;
1747: LOG_REPORT(x_run_id,'DISCONTINUED CONNECTORS FAILED.');
1748: LOG_REPORT(x_run_id,v_msg_data,v_msg_count);
1749: END IF;

Line 1766: t_rltns_tbl(n).active_end_date=FND_API.G_MISS_DATE) THEN

1762: --
1763: FOR n IN t_rltns_tbl.FIRST..t_rltns_tbl.LAST
1764: LOOP
1765: IF NOT(t_rltns_tbl(n).active_end_date IS NULL OR
1766: t_rltns_tbl(n).active_end_date=FND_API.G_MISS_DATE) THEN
1767: t_expired_rltns_tbl(t_expired_rltns_tbl.COUNT+1):=t_rltns_tbl(n);
1768: END IF;
1769: END LOOP;
1770:

Line 1818: p_commit => fnd_api.g_false,

1814: -- csi_t_txn_rltnshps_grp.create_txn_ii_rltns_dtls --
1815: create_txn_ii_rltns_dtls
1816: (
1817: p_api_version => 1.0,
1818: p_commit => fnd_api.g_false,
1819: p_init_msg_list => fnd_api.g_true,
1820: p_validation_level => fnd_api.g_valid_level_full,
1821: px_txn_ii_rltns_tbl => t_expired_rltns_tbl,
1822: x_return_status => v_return_status,

Line 1819: p_init_msg_list => fnd_api.g_true,

1815: create_txn_ii_rltns_dtls
1816: (
1817: p_api_version => 1.0,
1818: p_commit => fnd_api.g_false,
1819: p_init_msg_list => fnd_api.g_true,
1820: p_validation_level => fnd_api.g_valid_level_full,
1821: px_txn_ii_rltns_tbl => t_expired_rltns_tbl,
1822: x_return_status => v_return_status,
1823: x_msg_count => v_msg_count,

Line 1820: p_validation_level => fnd_api.g_valid_level_full,

1816: (
1817: p_api_version => 1.0,
1818: p_commit => fnd_api.g_false,
1819: p_init_msg_list => fnd_api.g_true,
1820: p_validation_level => fnd_api.g_valid_level_full,
1821: px_txn_ii_rltns_tbl => t_expired_rltns_tbl,
1822: x_return_status => v_return_status,
1823: x_msg_count => v_msg_count,
1824: x_msg_data => v_msg_data

Line 1827: IF (v_return_status <> fnd_api.g_ret_sts_success) THEN

1823: x_msg_count => v_msg_count,
1824: x_msg_data => v_msg_data
1825: );
1826:
1827: IF (v_return_status <> fnd_api.g_ret_sts_success) THEN
1828: x_run_id:=m_RUN_ID;
1829: LOG_REPORT(x_run_id,'CREATING EXPIRED RELATIONSHIPS FAILED...');
1830: LOG_REPORT(x_run_id,v_msg_data,v_msg_count);
1831: ELSE

Line 1848: t_rltns_tbl(n).active_end_date=FND_API.G_MISS_DATE) THEN

1844:
1845: FOR n IN t_rltns_tbl.FIRST..t_rltns_tbl.LAST
1846: LOOP
1847: IF (t_rltns_tbl(n).active_end_date IS NULL OR
1848: t_rltns_tbl(n).active_end_date=FND_API.G_MISS_DATE) THEN
1849: t_notexpired_rltns_tbl(t_notexpired_rltns_tbl.COUNT+1):=t_rltns_tbl(n);
1850: END IF;
1851: END LOOP;
1852:

Line 1859: p_commit => fnd_api.g_false,

1855: -- csi_t_txn_rltnshps_grp.create_txn_ii_rltns_dtls --
1856: create_txn_ii_rltns_dtls
1857: (
1858: p_api_version => 1.0,
1859: p_commit => fnd_api.g_false,
1860: p_init_msg_list => fnd_api.g_true,
1861: p_validation_level => fnd_api.g_valid_level_full,
1862: px_txn_ii_rltns_tbl => t_notexpired_rltns_tbl,
1863: x_return_status => v_return_status,

Line 1860: p_init_msg_list => fnd_api.g_true,

1856: create_txn_ii_rltns_dtls
1857: (
1858: p_api_version => 1.0,
1859: p_commit => fnd_api.g_false,
1860: p_init_msg_list => fnd_api.g_true,
1861: p_validation_level => fnd_api.g_valid_level_full,
1862: px_txn_ii_rltns_tbl => t_notexpired_rltns_tbl,
1863: x_return_status => v_return_status,
1864: x_msg_count => v_msg_count,

Line 1861: p_validation_level => fnd_api.g_valid_level_full,

1857: (
1858: p_api_version => 1.0,
1859: p_commit => fnd_api.g_false,
1860: p_init_msg_list => fnd_api.g_true,
1861: p_validation_level => fnd_api.g_valid_level_full,
1862: px_txn_ii_rltns_tbl => t_notexpired_rltns_tbl,
1863: x_return_status => v_return_status,
1864: x_msg_count => v_msg_count,
1865: x_msg_data => v_msg_data

Line 1868: IF (v_return_status <> fnd_api.g_ret_sts_success) THEN

1864: x_msg_count => v_msg_count,
1865: x_msg_data => v_msg_data
1866: );
1867:
1868: IF (v_return_status <> fnd_api.g_ret_sts_success) THEN
1869: x_run_id:=m_RUN_ID;
1870: LOG_REPORT(x_run_id,'CREATING NEW RELATIONSHIPS FAILED...');
1871: LOG_REPORT(x_run_id,v_msg_data,v_msg_count);
1872: ELSE

Line 1964: IF (CZ_IB_TRANSACTIONS.m_return_status <> fnd_api.g_ret_sts_success) THEN

1960: ' x_msg_data => CZ_IB_TRANSACTIONS.m_msg_data); ' ||
1961: ' END LOOP; ' ||
1962: 'END;' USING p_config_hdr_id, p_config_rev_nbr, p_config_status;
1963:
1964: IF (CZ_IB_TRANSACTIONS.m_return_status <> fnd_api.g_ret_sts_success) THEN
1965: x_run_id:=m_RUN_ID;
1966: LOG_REPORT(m_RUN_ID,'csi_item_instance_pub.update_item_instance() failed : '||CZ_IB_TRANSACTIONS.m_msg_data,CZ_IB_TRANSACTIONS.m_msg_count);
1967: END IF;
1968:

Line 2615: IF (v_return_status <> fnd_api.g_ret_sts_success) THEN

2611: x_return_status => v_return_status,
2612: x_return_message => v_return_message
2613: );
2614:
2615: IF (v_return_status <> fnd_api.g_ret_sts_success) THEN
2616: x_run_id:=m_RUN_ID;
2617: LOG_REPORT(x_run_id,'IB API Error : '||v_return_message);
2618: END IF;
2619:

Line 2720: IF (v_return_status <> fnd_api.g_ret_sts_success) THEN

2716: x_config_rec.config_inst_hdr_id := l_config_rec.config_inst_hdr_id;
2717: x_config_rec.config_inst_item_id := l_config_rec.config_inst_item_id;
2718: x_config_rec.config_inst_rev_num := l_config_rec.config_inst_rev_num;
2719:
2720: IF (v_return_status <> fnd_api.g_ret_sts_success) THEN
2721: DEBUG('Get_Configuration_Revision : '||v_return_message);
2722: x_run_id:=m_RUN_ID;
2723: LOG_REPORT(x_run_id,'IB API Error : '||v_return_message);
2724: END IF;