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

Line 106: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

102: asst_intf_id_upd NumTabType;
103: max_buffer_size NUMBER := 1000;
104:
105: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_IDS';
106: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
107: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
108: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
109: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
110: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

Line 107: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

103: max_buffer_size NUMBER := 1000;
104:
105: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_IDS';
106: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
107: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
108: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
109: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
110: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
111: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

Line 108: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

104:
105: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_IDS';
106: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
107: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
108: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
109: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
110: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
111: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
112: l_sql_error VARCHAR2(2000);

Line 109: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

105: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_IDS';
106: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
107: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
108: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
109: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
110: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
111: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
112: l_sql_error VARCHAR2(2000);
113: BEGIN

Line 110: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

106: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
107: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
108: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
109: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
110: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
111: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
112: l_sql_error VARCHAR2(2000);
113: BEGIN
114:

Line 111: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

107: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
108: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
109: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
110: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
111: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
112: l_sql_error VARCHAR2(2000);
113: BEGIN
114:
115: x_return_status := l_fnd_success;

Line 631: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

627: asst_intf_id_upd NumTabType;
628: max_buffer_size NUMBER := 1000;
629:
630: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_IDS';
631: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
632: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
633: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
634: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
635: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

Line 632: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

628: max_buffer_size NUMBER := 1000;
629:
630: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_IDS';
631: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
632: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
633: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
634: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
635: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
636: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

Line 633: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

629:
630: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_IDS';
631: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
632: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
633: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
634: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
635: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
636: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
637: l_sql_error VARCHAR2(2000);

Line 634: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

630: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_IDS';
631: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
632: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
633: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
634: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
635: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
636: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
637: l_sql_error VARCHAR2(2000);
638:

Line 635: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

631: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
632: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
633: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
634: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
635: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
636: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
637: l_sql_error VARCHAR2(2000);
638:
639: BEGIN

Line 636: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

632: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
633: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
634: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
635: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
636: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
637: l_sql_error VARCHAR2(2000);
638:
639: BEGIN
640:

Line 1082: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1078: ip_intf_id_upd3 NumTabType;
1079: max_buffer_size NUMBER := 1000;
1080:
1081: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_UPDATE_IDS';
1082: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1083: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1084: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1085: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1086: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

Line 1083: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

1079: max_buffer_size NUMBER := 1000;
1080:
1081: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_UPDATE_IDS';
1082: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1083: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1084: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1085: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1086: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1087: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

Line 1084: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

1080:
1081: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_UPDATE_IDS';
1082: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1083: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1084: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1085: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1086: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1087: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1088: l_sql_error VARCHAR2(2000);

Line 1085: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

1081: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_UPDATE_IDS';
1082: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1083: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1084: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1085: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1086: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1087: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1088: l_sql_error VARCHAR2(2000);
1089: g_derive_ids VARCHAR2(1);

Line 1086: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

1082: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1083: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1084: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1085: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1086: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1087: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1088: l_sql_error VARCHAR2(2000);
1089: g_derive_ids VARCHAR2(1);
1090:

Line 1087: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

1083: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1084: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1085: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1086: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1087: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1088: l_sql_error VARCHAR2(2000);
1089: g_derive_ids VARCHAR2(1);
1090:
1091:

Line 1468: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1464:
1465: r_error c_error%rowtype;
1466:
1467: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.LOG_CREATE_ERRORS';
1468: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1469: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1470: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1471: l_sql_error VARCHAR2(2000);
1472: BEGIN

Line 1469: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

1465: r_error c_error%rowtype;
1466:
1467: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.LOG_CREATE_ERRORS';
1468: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1469: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1470: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1471: l_sql_error VARCHAR2(2000);
1472: BEGIN
1473:

Line 1470: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

1466:
1467: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.LOG_CREATE_ERRORS';
1468: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1469: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1470: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1471: l_sql_error VARCHAR2(2000);
1472: BEGIN
1473:
1474: x_return_status := l_fnd_success;

Line 1520: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1516:
1517: r_error c_error%rowtype;
1518:
1519: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.LOG_CREATE_PW_ERRORS';
1520: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1521: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1522: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1523: l_sql_error VARCHAR2(2000);
1524: l_txn_from_date DATE := to_date(p_txn_from_date, 'YYYY/MM/DD HH24:MI:SS');

Line 1521: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

1517: r_error c_error%rowtype;
1518:
1519: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.LOG_CREATE_PW_ERRORS';
1520: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1521: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1522: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1523: l_sql_error VARCHAR2(2000);
1524: l_txn_from_date DATE := to_date(p_txn_from_date, 'YYYY/MM/DD HH24:MI:SS');
1525: l_txn_to_date DATE := to_date(p_txn_to_date, 'YYYY/MM/DD HH24:MI:SS');

Line 1522: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

1518:
1519: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.LOG_CREATE_PW_ERRORS';
1520: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1521: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1522: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1523: l_sql_error VARCHAR2(2000);
1524: l_txn_from_date DATE := to_date(p_txn_from_date, 'YYYY/MM/DD HH24:MI:SS');
1525: l_txn_to_date DATE := to_date(p_txn_to_date, 'YYYY/MM/DD HH24:MI:SS');
1526: BEGIN

Line 1560: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1556: x_error_message OUT NOCOPY VARCHAR2) IS
1557:
1558:
1559: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.SET_PTY_PROCESS_STATUS';
1560: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1561: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1562: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1563: l_sql_error VARCHAR2(2000);
1564: l_txn_from_date DATE := to_date(p_txn_from_date, 'YYYY/MM/DD HH24:MI:SS');

Line 1561: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

1557:
1558:
1559: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.SET_PTY_PROCESS_STATUS';
1560: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1561: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1562: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1563: l_sql_error VARCHAR2(2000);
1564: l_txn_from_date DATE := to_date(p_txn_from_date, 'YYYY/MM/DD HH24:MI:SS');
1565: l_txn_to_date DATE := to_date(p_txn_to_date, 'YYYY/MM/DD HH24:MI:SS');

Line 1562: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

1558:
1559: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.SET_PTY_PROCESS_STATUS';
1560: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1561: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1562: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1563: l_sql_error VARCHAR2(2000);
1564: l_txn_from_date DATE := to_date(p_txn_from_date, 'YYYY/MM/DD HH24:MI:SS');
1565: l_txn_to_date DATE := to_date(p_txn_to_date, 'YYYY/MM/DD HH24:MI:SS');
1566: BEGIN

Line 1588: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1584: x_error_message OUT NOCOPY VARCHAR2) IS
1585:
1586:
1587: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.SET_EXT_PROCESS_STATUS';
1588: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1589: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1590: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1591: l_sql_error VARCHAR2(2000);
1592: l_txn_from_date DATE := to_date(p_txn_from_date, 'YYYY/MM/DD HH24:MI:SS');

Line 1589: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

1585:
1586:
1587: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.SET_EXT_PROCESS_STATUS';
1588: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1589: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1590: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1591: l_sql_error VARCHAR2(2000);
1592: l_txn_from_date DATE := to_date(p_txn_from_date, 'YYYY/MM/DD HH24:MI:SS');
1593: l_txn_to_date DATE := to_date(p_txn_to_date, 'YYYY/MM/DD HH24:MI:SS');

Line 1590: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

1586:
1587: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.SET_EXT_PROCESS_STATUS';
1588: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1589: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1590: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1591: l_sql_error VARCHAR2(2000);
1592: l_txn_from_date DATE := to_date(p_txn_from_date, 'YYYY/MM/DD HH24:MI:SS');
1593: l_txn_to_date DATE := to_date(p_txn_to_date, 'YYYY/MM/DD HH24:MI:SS');
1594: BEGIN

Line 1624: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1620: subject_id_upd NumTabType;
1621: max_buffer_size NUMBER := 1000;
1622:
1623: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_REL_IDS';
1624: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1625: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1626: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1627: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1628: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

Line 1625: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

1621: max_buffer_size NUMBER := 1000;
1622:
1623: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_REL_IDS';
1624: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1625: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1626: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1627: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1628: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1629: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

Line 1626: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

1622:
1623: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_REL_IDS';
1624: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1625: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1626: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1627: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1628: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1629: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1630: l_sql_error VARCHAR2(2000);

Line 1627: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;

1623: l_api_name VARCHAR2(255) := 'CSI_ML_UTIL_PVT.RESOLVE_REL_IDS';
1624: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1625: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1626: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1627: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1628: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1629: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1630: l_sql_error VARCHAR2(2000);
1631: BEGIN

Line 1628: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

1624: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1625: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1626: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1627: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1628: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1629: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1630: l_sql_error VARCHAR2(2000);
1631: BEGIN
1632:

Line 1629: l_fnd_g_date DATE := FND_API.G_MISS_DATE;

1625: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
1626: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
1627: l_fnd_g_num NUMBER := FND_API.G_MISS_NUM;
1628: l_fnd_g_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
1629: l_fnd_g_date DATE := FND_API.G_MISS_DATE;
1630: l_sql_error VARCHAR2(2000);
1631: BEGIN
1632:
1633:

Line 1852: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1848: l_ins NUMBER;
1849: l_txn_type_id NUMBER;
1850: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1851: l_login_id NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
1852: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1853: SKIP_ERROR EXCEPTION;
1854: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
1855: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
1856:

Line 1978: fnd_api.g_false

1974: WHILE l_msg_count > 0
1975: LOOP
1976: x_msg_data := fnd_msg_pub.get
1977: (l_msg_index,
1978: fnd_api.g_false
1979: );
1980: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
1981: l_msg_index := l_msg_index + 1;
1982: l_msg_count := l_msg_count - 1;

Line 2015: fnd_api.g_false

2011: WHILE l_msg_count > 0
2012: LOOP
2013: x_msg_data := fnd_msg_pub.get
2014: (l_msg_index,
2015: fnd_api.g_false
2016: );
2017: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
2018: l_msg_index := l_msg_index + 1;
2019: l_msg_count := l_msg_count - 1;

Line 2039: fnd_api.g_false

2035: WHILE l_msg_count > 0
2036: LOOP
2037: x_msg_data := fnd_msg_pub.get
2038: (l_msg_index,
2039: fnd_api.g_false
2040: );
2041: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
2042: l_msg_index := l_msg_index + 1;
2043: l_msg_count := l_msg_count - 1;

Line 2065: fnd_api.g_false

2061: WHILE l_msg_count > 0
2062: LOOP
2063: x_msg_data := fnd_msg_pub.get
2064: (l_msg_index,
2065: fnd_api.g_false
2066: );
2067: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
2068: l_msg_index := l_msg_index + 1;
2069: l_msg_count := l_msg_count - 1;

Line 2078: (r_id.subject_id <> fnd_api.g_miss_num))

2074: END IF;
2075:
2076: -- 3. Validate subject_id
2077: IF ((r_id.subject_id IS NOT NULL) AND
2078: (r_id.subject_id <> fnd_api.g_miss_num))
2079: THEN
2080: BEGIN
2081: SELECT 'x'
2082: INTO l_exists

Line 2101: fnd_api.g_false

2097: WHILE l_msg_count > 0
2098: LOOP
2099: x_msg_data := fnd_msg_pub.get
2100: (l_msg_index,
2101: fnd_api.g_false
2102: );
2103: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
2104: l_msg_index := l_msg_index + 1;
2105: l_msg_count := l_msg_count - 1;

Line 2127: fnd_api.g_false

2123: WHILE l_msg_count > 0
2124: LOOP
2125: x_msg_data := fnd_msg_pub.get
2126: (l_msg_index,
2127: fnd_api.g_false
2128: );
2129: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
2130: l_msg_index := l_msg_index + 1;
2131: l_msg_count := l_msg_count - 1;

Line 2140: (r_id.relationship_end_date <> fnd_api.g_miss_date))

2136: END IF;
2137:
2138: -- 4. Validate active_end_date
2139: IF ((r_id.relationship_end_date IS NOT NULL) AND
2140: (r_id.relationship_end_date <> fnd_api.g_miss_date))
2141: THEN
2142: fnd_message.set_name('CSI', 'CSI_ACTIVE_END_DATE');
2143: fnd_message.set_token('ACTIVE_END_DATE',r_id.relationship_end_date);
2144: fnd_msg_pub.add;

Line 2155: fnd_api.g_false

2151: WHILE l_msg_count > 0
2152: LOOP
2153: x_msg_data := fnd_msg_pub.get
2154: (l_msg_index,
2155: fnd_api.g_false
2156: );
2157: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
2158: l_msg_index := l_msg_index + 1;
2159: l_msg_count := l_msg_count - 1;

Line 2190: fnd_api.g_false

2186: WHILE l_msg_count > 0
2187: LOOP
2188: x_msg_data := fnd_msg_pub.get
2189: (l_msg_index,
2190: fnd_api.g_false
2191: );
2192: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
2193: l_msg_index := l_msg_index + 1;
2194: l_msg_count := l_msg_count - 1;

Line 2211: IF x_return_status<>fnd_api.g_ret_sts_success THEN

2207: x_return_status =>x_return_status,
2208: x_msg_count =>x_msg_count,
2209: x_msg_data =>x_msg_data
2210: );
2211: IF x_return_status<>fnd_api.g_ret_sts_success THEN
2212: l_msg_index := 1;
2213: fnd_msg_pub.count_and_get
2214: (p_count => x_msg_count,
2215: p_data => x_msg_data

Line 2222: fnd_api.g_false

2218: WHILE l_msg_count > 0
2219: LOOP
2220: x_msg_data := fnd_msg_pub.get
2221: (l_msg_index,
2222: fnd_api.g_false
2223: );
2224: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
2225: l_msg_index := l_msg_index + 1;
2226: l_msg_count := l_msg_count - 1;

Line 2259: fnd_api.g_false

2255: WHILE l_msg_count > 0
2256: LOOP
2257: x_msg_data := fnd_msg_pub.get
2258: (l_msg_index,
2259: fnd_api.g_false
2260: );
2261: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
2262: l_msg_index := l_msg_index + 1;
2263: l_msg_count := l_msg_count - 1;

Line 2292: fnd_api.g_false

2288: WHILE l_msg_count > 0
2289: LOOP
2290: x_msg_data := fnd_msg_pub.get
2291: (l_msg_index,
2292: fnd_api.g_false
2293: );
2294: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
2295: l_msg_index := l_msg_index + 1;
2296: l_msg_count := l_msg_count - 1;

Line 2324: fnd_api.g_false

2320: WHILE l_msg_count > 0
2321: LOOP
2322: x_msg_data := fnd_msg_pub.get
2323: (l_msg_index,
2324: fnd_api.g_false
2325: );
2326: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
2327: l_msg_index := l_msg_index + 1;
2328: l_msg_count := l_msg_count - 1;

Line 2440: l_return_status := FND_API.G_RET_STS_SUCCESS;

2436: FROM csi_item_instances
2437: WHERE instance_id = l_upd_ins_csr.subject_id;
2438:
2439:
2440: l_return_status := FND_API.G_RET_STS_SUCCESS;
2441: /*
2442: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.instance_id := '||l_instance_rec.instance_id);
2443: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.object_version_number := '||l_instance_rec.object_version_number);
2444: FND_File.Put_Line(Fnd_File.LOG,'l_instance_rec.active_end_date := '||l_instance_rec.active_end_date);

Line 2463: ,p_commit => fnd_api.g_false

2459: l_txn_rec.source_transaction_date := sysdate;
2460:
2461: csi_item_instance_pvt.update_item_instance
2462: (p_api_version => 1.0
2463: ,p_commit => fnd_api.g_false
2464: ,p_init_msg_list => fnd_api.g_false
2465: ,p_validation_level => fnd_api.g_valid_level_full
2466: ,p_instance_rec => l_instance_rec
2467: ,p_txn_rec => l_txn_rec

Line 2464: ,p_init_msg_list => fnd_api.g_false

2460:
2461: csi_item_instance_pvt.update_item_instance
2462: (p_api_version => 1.0
2463: ,p_commit => fnd_api.g_false
2464: ,p_init_msg_list => fnd_api.g_false
2465: ,p_validation_level => fnd_api.g_valid_level_full
2466: ,p_instance_rec => l_instance_rec
2467: ,p_txn_rec => l_txn_rec
2468: ,x_instance_id_lst => l_instance_id_lst

Line 2465: ,p_validation_level => fnd_api.g_valid_level_full

2461: csi_item_instance_pvt.update_item_instance
2462: (p_api_version => 1.0
2463: ,p_commit => fnd_api.g_false
2464: ,p_init_msg_list => fnd_api.g_false
2465: ,p_validation_level => fnd_api.g_valid_level_full
2466: ,p_instance_rec => l_instance_rec
2467: ,p_txn_rec => l_txn_rec
2468: ,x_instance_id_lst => l_instance_id_lst
2469: ,x_return_status => l_return_status

Line 2477: ,p_called_from_rel => fnd_api.g_false

2473: ,p_location_tbl => l_location_tbl
2474: ,p_generic_id_tbl => l_generic_id_tbl
2475: ,p_lookup_tbl => l_lookup_tbl
2476: ,p_ins_count_rec => l_ins_count_rec
2477: ,p_called_from_rel => fnd_api.g_false
2478: ,p_oks_txn_inst_tbl => px_oks_txn_inst_tbl
2479: ,p_child_inst_tbl => px_child_inst_tbl
2480: ,p_validation_mode => 'V'
2481: );

Line 2487: IF NOT(l_return_status = fnd_api.g_ret_sts_success)

2483: FND_File.Put_Line(Fnd_File.LOG,'After update x_msg_data := '||x_msg_data);
2484:
2485:
2486:
2487: IF NOT(l_return_status = fnd_api.g_ret_sts_success)
2488: THEN
2489: /*
2490: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');
2491: fnd_message.set_token('instance_id',l_instance_rec.instance_id);

Line 2505: ,fnd_api.g_false

2501: WHILE l_msg_count > 0
2502: LOOP
2503: x_msg_data := fnd_msg_pub.get
2504: ( l_msg_index
2505: ,fnd_api.g_false
2506: );
2507: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
2508: l_msg_index := l_msg_index + 1;
2509: l_msg_count := l_msg_count - 1;

Line 2609: l_return_status := FND_API.G_RET_STS_SUCCESS;

2605: ,l_instance_rec.object_version_number
2606: FROM csi_item_instances
2607: WHERE instance_id = l_re_upd_csr.subject_id;
2608:
2609: l_return_status := FND_API.G_RET_STS_SUCCESS;
2610:
2611: l_txn_rec.transaction_type_id := csi_ml_util_pvt.get_txn_type_id('OPEN_INTERFACE','CSI');
2612: l_txn_rec.transaction_date := sysdate;
2613: l_txn_rec.source_transaction_date := sysdate;

Line 2617: ,p_commit => fnd_api.g_false

2613: l_txn_rec.source_transaction_date := sysdate;
2614:
2615: csi_item_instance_pvt.update_item_instance
2616: (p_api_version => 1.0
2617: ,p_commit => fnd_api.g_false
2618: ,p_init_msg_list => fnd_api.g_false
2619: ,p_validation_level => fnd_api.g_valid_level_full
2620: ,p_instance_rec => l_instance_rec
2621: ,p_txn_rec => l_txn_rec

Line 2618: ,p_init_msg_list => fnd_api.g_false

2614:
2615: csi_item_instance_pvt.update_item_instance
2616: (p_api_version => 1.0
2617: ,p_commit => fnd_api.g_false
2618: ,p_init_msg_list => fnd_api.g_false
2619: ,p_validation_level => fnd_api.g_valid_level_full
2620: ,p_instance_rec => l_instance_rec
2621: ,p_txn_rec => l_txn_rec
2622: ,x_instance_id_lst => l_instance_id_lst

Line 2619: ,p_validation_level => fnd_api.g_valid_level_full

2615: csi_item_instance_pvt.update_item_instance
2616: (p_api_version => 1.0
2617: ,p_commit => fnd_api.g_false
2618: ,p_init_msg_list => fnd_api.g_false
2619: ,p_validation_level => fnd_api.g_valid_level_full
2620: ,p_instance_rec => l_instance_rec
2621: ,p_txn_rec => l_txn_rec
2622: ,x_instance_id_lst => l_instance_id_lst
2623: ,x_return_status => l_return_status

Line 2631: ,p_called_from_rel => fnd_api.g_false

2627: ,p_location_tbl => l_location_tbl
2628: ,p_generic_id_tbl => l_generic_id_tbl
2629: ,p_lookup_tbl => l_lookup_tbl
2630: ,p_ins_count_rec => l_ins_count_rec
2631: ,p_called_from_rel => fnd_api.g_false
2632: ,p_oks_txn_inst_tbl => px_oks_txn_inst_tbl
2633: ,p_child_inst_tbl => px_child_inst_tbl
2634: ,p_validation_mode => 'U'
2635: );

Line 2641: IF NOT(l_return_status = fnd_api.g_ret_sts_success)

2637: FND_File.Put_Line(Fnd_File.LOG,'After update x_msg_data := '||x_msg_data);
2638: FND_File.Put_Line(Fnd_File.LOG,'After update l_return_status := '||l_return_status);
2639:
2640:
2641: IF NOT(l_return_status = fnd_api.g_ret_sts_success)
2642: THEN
2643:
2644: l_msg_index := 1;
2645:

Line 2655: ,fnd_api.g_false

2651: WHILE l_msg_count > 0
2652: LOOP
2653: x_msg_data := fnd_msg_pub.get
2654: ( l_msg_index
2655: ,fnd_api.g_false
2656: );
2657: csi_gen_utility_pvt.put_line( ' MESSAGE DATA = '||x_msg_data);
2658: l_msg_index := l_msg_index + 1;
2659: l_msg_count := l_msg_count - 1;