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_MESSAGE

Line 513: fnd_message.set_name('CSI','CSI_ML_EXT_ATTR_ID_ERROR');

509: AND a.inventory_item_id IS NOT NULL;
510:
511: EXCEPTION
512: WHEN others THEN
513: fnd_message.set_name('CSI','CSI_ML_EXT_ATTR_ID_ERROR');
514: fnd_message.set_token('SQL_ERROR',SQLERRM);
515: x_error_message := fnd_message.get;
516: x_return_status := l_fnd_unexpected;
517: END;

Line 514: fnd_message.set_token('SQL_ERROR',SQLERRM);

510:
511: EXCEPTION
512: WHEN others THEN
513: fnd_message.set_name('CSI','CSI_ML_EXT_ATTR_ID_ERROR');
514: fnd_message.set_token('SQL_ERROR',SQLERRM);
515: x_error_message := fnd_message.get;
516: x_return_status := l_fnd_unexpected;
517: END;
518:

Line 515: x_error_message := fnd_message.get;

511: EXCEPTION
512: WHEN others THEN
513: fnd_message.set_name('CSI','CSI_ML_EXT_ATTR_ID_ERROR');
514: fnd_message.set_token('SQL_ERROR',SQLERRM);
515: x_error_message := fnd_message.get;
516: x_return_status := l_fnd_unexpected;
517: END;
518:
519: EXCEPTION

Line 522: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');

518:
519: EXCEPTION
520: WHEN others THEN
521: l_sql_error := SQLERRM;
522: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
523: fnd_message.set_token('API_NAME',l_api_name);
524: fnd_message.set_token('SQL_ERROR',SQLERRM);
525: x_error_message := fnd_message.get;
526: x_return_status := l_fnd_unexpected;

Line 523: fnd_message.set_token('API_NAME',l_api_name);

519: EXCEPTION
520: WHEN others THEN
521: l_sql_error := SQLERRM;
522: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
523: fnd_message.set_token('API_NAME',l_api_name);
524: fnd_message.set_token('SQL_ERROR',SQLERRM);
525: x_error_message := fnd_message.get;
526: x_return_status := l_fnd_unexpected;
527:

Line 524: fnd_message.set_token('SQL_ERROR',SQLERRM);

520: WHEN others THEN
521: l_sql_error := SQLERRM;
522: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
523: fnd_message.set_token('API_NAME',l_api_name);
524: fnd_message.set_token('SQL_ERROR',SQLERRM);
525: x_error_message := fnd_message.get;
526: x_return_status := l_fnd_unexpected;
527:
528: END resolve_ids;

Line 525: x_error_message := fnd_message.get;

521: l_sql_error := SQLERRM;
522: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
523: fnd_message.set_token('API_NAME',l_api_name);
524: fnd_message.set_token('SQL_ERROR',SQLERRM);
525: x_error_message := fnd_message.get;
526: x_return_status := l_fnd_unexpected;
527:
528: END resolve_ids;
529:

Line 1036: fnd_message.set_name('CSI','CSI_ML_EXT_ATTR_ID_ERROR');

1032: AND a.master_organization_id IS NOT NULL;
1033:
1034: EXCEPTION
1035: WHEN others THEN
1036: fnd_message.set_name('CSI','CSI_ML_EXT_ATTR_ID_ERROR');
1037: fnd_message.set_token('SQL_ERROR',SQLERRM);
1038: x_error_message := fnd_message.get;
1039: x_return_status := l_fnd_unexpected;
1040: END;

Line 1037: fnd_message.set_token('SQL_ERROR',SQLERRM);

1033:
1034: EXCEPTION
1035: WHEN others THEN
1036: fnd_message.set_name('CSI','CSI_ML_EXT_ATTR_ID_ERROR');
1037: fnd_message.set_token('SQL_ERROR',SQLERRM);
1038: x_error_message := fnd_message.get;
1039: x_return_status := l_fnd_unexpected;
1040: END;
1041:

Line 1038: x_error_message := fnd_message.get;

1034: EXCEPTION
1035: WHEN others THEN
1036: fnd_message.set_name('CSI','CSI_ML_EXT_ATTR_ID_ERROR');
1037: fnd_message.set_token('SQL_ERROR',SQLERRM);
1038: x_error_message := fnd_message.get;
1039: x_return_status := l_fnd_unexpected;
1040: END;
1041:
1042: EXCEPTION

Line 1045: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');

1041:
1042: EXCEPTION
1043: WHEN others THEN
1044: l_sql_error := SQLERRM;
1045: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1046: fnd_message.set_token('API_NAME',l_api_name);
1047: fnd_message.set_token('SQL_ERROR',SQLERRM);
1048: x_error_message := fnd_message.get;
1049: x_return_status := l_fnd_unexpected;

Line 1046: fnd_message.set_token('API_NAME',l_api_name);

1042: EXCEPTION
1043: WHEN others THEN
1044: l_sql_error := SQLERRM;
1045: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1046: fnd_message.set_token('API_NAME',l_api_name);
1047: fnd_message.set_token('SQL_ERROR',SQLERRM);
1048: x_error_message := fnd_message.get;
1049: x_return_status := l_fnd_unexpected;
1050:

Line 1047: fnd_message.set_token('SQL_ERROR',SQLERRM);

1043: WHEN others THEN
1044: l_sql_error := SQLERRM;
1045: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1046: fnd_message.set_token('API_NAME',l_api_name);
1047: fnd_message.set_token('SQL_ERROR',SQLERRM);
1048: x_error_message := fnd_message.get;
1049: x_return_status := l_fnd_unexpected;
1050:
1051: END resolve_pw_ids;

Line 1048: x_error_message := fnd_message.get;

1044: l_sql_error := SQLERRM;
1045: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1046: fnd_message.set_token('API_NAME',l_api_name);
1047: fnd_message.set_token('SQL_ERROR',SQLERRM);
1048: x_error_message := fnd_message.get;
1049: x_return_status := l_fnd_unexpected;
1050:
1051: END resolve_pw_ids;
1052:

Line 1422: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');

1418:
1419: EXCEPTION
1420: WHEN others THEN
1421: l_sql_error := SQLERRM;
1422: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1423: fnd_message.set_token('API_NAME',l_api_name);
1424: fnd_message.set_token('SQL_ERROR',SQLERRM);
1425: x_error_message := fnd_message.get;
1426: x_return_status := l_fnd_unexpected;

Line 1423: fnd_message.set_token('API_NAME',l_api_name);

1419: EXCEPTION
1420: WHEN others THEN
1421: l_sql_error := SQLERRM;
1422: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1423: fnd_message.set_token('API_NAME',l_api_name);
1424: fnd_message.set_token('SQL_ERROR',SQLERRM);
1425: x_error_message := fnd_message.get;
1426: x_return_status := l_fnd_unexpected;
1427:

Line 1424: fnd_message.set_token('SQL_ERROR',SQLERRM);

1420: WHEN others THEN
1421: l_sql_error := SQLERRM;
1422: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1423: fnd_message.set_token('API_NAME',l_api_name);
1424: fnd_message.set_token('SQL_ERROR',SQLERRM);
1425: x_error_message := fnd_message.get;
1426: x_return_status := l_fnd_unexpected;
1427:
1428: END resolve_update_ids;

Line 1425: x_error_message := fnd_message.get;

1421: l_sql_error := SQLERRM;
1422: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1423: fnd_message.set_token('API_NAME',l_api_name);
1424: fnd_message.set_token('SQL_ERROR',SQLERRM);
1425: x_error_message := fnd_message.get;
1426: x_return_status := l_fnd_unexpected;
1427:
1428: END resolve_update_ids;
1429:

Line 1488: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');

1484:
1485: EXCEPTION
1486: WHEN others THEN
1487: l_sql_error := SQLERRM;
1488: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1489: fnd_message.set_token('API_NAME',l_api_name);
1490: fnd_message.set_token('SQL_ERROR',SQLERRM);
1491: x_error_message := fnd_message.get;
1492: x_return_status := l_fnd_unexpected;

Line 1489: fnd_message.set_token('API_NAME',l_api_name);

1485: EXCEPTION
1486: WHEN others THEN
1487: l_sql_error := SQLERRM;
1488: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1489: fnd_message.set_token('API_NAME',l_api_name);
1490: fnd_message.set_token('SQL_ERROR',SQLERRM);
1491: x_error_message := fnd_message.get;
1492: x_return_status := l_fnd_unexpected;
1493:

Line 1490: fnd_message.set_token('SQL_ERROR',SQLERRM);

1486: WHEN others THEN
1487: l_sql_error := SQLERRM;
1488: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1489: fnd_message.set_token('API_NAME',l_api_name);
1490: fnd_message.set_token('SQL_ERROR',SQLERRM);
1491: x_error_message := fnd_message.get;
1492: x_return_status := l_fnd_unexpected;
1493:
1494: END log_create_errors;

Line 1491: x_error_message := fnd_message.get;

1487: l_sql_error := SQLERRM;
1488: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1489: fnd_message.set_token('API_NAME',l_api_name);
1490: fnd_message.set_token('SQL_ERROR',SQLERRM);
1491: x_error_message := fnd_message.get;
1492: x_return_status := l_fnd_unexpected;
1493:
1494: END log_create_errors;
1495:

Line 1545: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');

1541:
1542: EXCEPTION
1543: WHEN others THEN
1544: l_sql_error := SQLERRM;
1545: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1546: fnd_message.set_token('API_NAME',l_api_name);
1547: fnd_message.set_token('SQL_ERROR',SQLERRM);
1548: x_error_message := fnd_message.get;
1549: x_return_status := l_fnd_unexpected;

Line 1546: fnd_message.set_token('API_NAME',l_api_name);

1542: EXCEPTION
1543: WHEN others THEN
1544: l_sql_error := SQLERRM;
1545: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1546: fnd_message.set_token('API_NAME',l_api_name);
1547: fnd_message.set_token('SQL_ERROR',SQLERRM);
1548: x_error_message := fnd_message.get;
1549: x_return_status := l_fnd_unexpected;
1550:

Line 1547: fnd_message.set_token('SQL_ERROR',SQLERRM);

1543: WHEN others THEN
1544: l_sql_error := SQLERRM;
1545: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1546: fnd_message.set_token('API_NAME',l_api_name);
1547: fnd_message.set_token('SQL_ERROR',SQLERRM);
1548: x_error_message := fnd_message.get;
1549: x_return_status := l_fnd_unexpected;
1550:
1551: END log_create_pw_errors;

Line 1548: x_error_message := fnd_message.get;

1544: l_sql_error := SQLERRM;
1545: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1546: fnd_message.set_token('API_NAME',l_api_name);
1547: fnd_message.set_token('SQL_ERROR',SQLERRM);
1548: x_error_message := fnd_message.get;
1549: x_return_status := l_fnd_unexpected;
1550:
1551: END log_create_pw_errors;
1552:

Line 1573: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');

1569:
1570: EXCEPTION
1571: WHEN others THEN
1572: l_sql_error := SQLERRM;
1573: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1574: fnd_message.set_token('API_NAME',l_api_name);
1575: fnd_message.set_token('SQL_ERROR',SQLERRM);
1576: x_error_message := fnd_message.get;
1577: x_return_status := l_fnd_unexpected;

Line 1574: fnd_message.set_token('API_NAME',l_api_name);

1570: EXCEPTION
1571: WHEN others THEN
1572: l_sql_error := SQLERRM;
1573: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1574: fnd_message.set_token('API_NAME',l_api_name);
1575: fnd_message.set_token('SQL_ERROR',SQLERRM);
1576: x_error_message := fnd_message.get;
1577: x_return_status := l_fnd_unexpected;
1578:

Line 1575: fnd_message.set_token('SQL_ERROR',SQLERRM);

1571: WHEN others THEN
1572: l_sql_error := SQLERRM;
1573: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1574: fnd_message.set_token('API_NAME',l_api_name);
1575: fnd_message.set_token('SQL_ERROR',SQLERRM);
1576: x_error_message := fnd_message.get;
1577: x_return_status := l_fnd_unexpected;
1578:
1579: END set_pty_process_status;

Line 1576: x_error_message := fnd_message.get;

1572: l_sql_error := SQLERRM;
1573: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1574: fnd_message.set_token('API_NAME',l_api_name);
1575: fnd_message.set_token('SQL_ERROR',SQLERRM);
1576: x_error_message := fnd_message.get;
1577: x_return_status := l_fnd_unexpected;
1578:
1579: END set_pty_process_status;
1580:

Line 1601: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');

1597:
1598: EXCEPTION
1599: WHEN others THEN
1600: l_sql_error := SQLERRM;
1601: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1602: fnd_message.set_token('API_NAME',l_api_name);
1603: fnd_message.set_token('SQL_ERROR',SQLERRM);
1604: x_error_message := fnd_message.get;
1605: x_return_status := l_fnd_unexpected;

Line 1602: fnd_message.set_token('API_NAME',l_api_name);

1598: EXCEPTION
1599: WHEN others THEN
1600: l_sql_error := SQLERRM;
1601: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1602: fnd_message.set_token('API_NAME',l_api_name);
1603: fnd_message.set_token('SQL_ERROR',SQLERRM);
1604: x_error_message := fnd_message.get;
1605: x_return_status := l_fnd_unexpected;
1606:

Line 1603: fnd_message.set_token('SQL_ERROR',SQLERRM);

1599: WHEN others THEN
1600: l_sql_error := SQLERRM;
1601: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1602: fnd_message.set_token('API_NAME',l_api_name);
1603: fnd_message.set_token('SQL_ERROR',SQLERRM);
1604: x_error_message := fnd_message.get;
1605: x_return_status := l_fnd_unexpected;
1606:
1607: END set_ext_process_status;

Line 1604: x_error_message := fnd_message.get;

1600: l_sql_error := SQLERRM;
1601: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1602: fnd_message.set_token('API_NAME',l_api_name);
1603: fnd_message.set_token('SQL_ERROR',SQLERRM);
1604: x_error_message := fnd_message.get;
1605: x_return_status := l_fnd_unexpected;
1606:
1607: END set_ext_process_status;
1608:

Line 1667: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');

1663:
1664: EXCEPTION
1665: WHEN others THEN
1666: l_sql_error := SQLERRM;
1667: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1668: fnd_message.set_token('API_NAME',l_api_name);
1669: fnd_message.set_token('SQL_ERROR',SQLERRM);
1670: FND_File.Put_Line(Fnd_File.LOG,'Error is ' || l_sql_error);
1671: x_error_message := fnd_message.get;

Line 1668: fnd_message.set_token('API_NAME',l_api_name);

1664: EXCEPTION
1665: WHEN others THEN
1666: l_sql_error := SQLERRM;
1667: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1668: fnd_message.set_token('API_NAME',l_api_name);
1669: fnd_message.set_token('SQL_ERROR',SQLERRM);
1670: FND_File.Put_Line(Fnd_File.LOG,'Error is ' || l_sql_error);
1671: x_error_message := fnd_message.get;
1672: x_return_status := l_fnd_unexpected;

Line 1669: fnd_message.set_token('SQL_ERROR',SQLERRM);

1665: WHEN others THEN
1666: l_sql_error := SQLERRM;
1667: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1668: fnd_message.set_token('API_NAME',l_api_name);
1669: fnd_message.set_token('SQL_ERROR',SQLERRM);
1670: FND_File.Put_Line(Fnd_File.LOG,'Error is ' || l_sql_error);
1671: x_error_message := fnd_message.get;
1672: x_return_status := l_fnd_unexpected;
1673:

Line 1671: x_error_message := fnd_message.get;

1667: fnd_message.set_name('CSI','CSI_ML_UNEXP_SQL_ERROR');
1668: fnd_message.set_token('API_NAME',l_api_name);
1669: fnd_message.set_token('SQL_ERROR',SQLERRM);
1670: FND_File.Put_Line(Fnd_File.LOG,'Error is ' || l_sql_error);
1671: x_error_message := fnd_message.get;
1672: x_return_status := l_fnd_unexpected;
1673:
1674: END resolve_rel_ids;
1675:

Line 1965: fnd_message.set_name('CSI', 'CSI_INVALID_RELSHIP_CODE');

1961: FROM csi_ii_relation_types
1962: WHERE relationship_type_code=r_id.relationship_type_code;
1963: EXCEPTION
1964: WHEN NO_DATA_FOUND THEN
1965: fnd_message.set_name('CSI', 'CSI_INVALID_RELSHIP_CODE');
1966: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',r_id.relationship_type_code);
1967: fnd_msg_pub.add;
1968: l_msg_index := 1;
1969: fnd_msg_pub.count_and_get

Line 1966: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',r_id.relationship_type_code);

1962: WHERE relationship_type_code=r_id.relationship_type_code;
1963: EXCEPTION
1964: WHEN NO_DATA_FOUND THEN
1965: fnd_message.set_name('CSI', 'CSI_INVALID_RELSHIP_CODE');
1966: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',r_id.relationship_type_code);
1967: fnd_msg_pub.add;
1968: l_msg_index := 1;
1969: fnd_msg_pub.count_and_get
1970: (p_count => x_msg_count,

Line 2002: fnd_message.set_name('CSI', 'CSI_NON_ATO_PTO_ITEM');

1998: AND (SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE));
1999:
2000: IF l_quantity <> 1
2001: THEN
2002: fnd_message.set_name('CSI', 'CSI_NON_ATO_PTO_ITEM');
2003: fnd_message.set_token('OBJECT_ID',r_id.object_id);
2004: fnd_msg_pub.add;
2005: l_msg_index := 1;
2006: fnd_msg_pub.count_and_get

Line 2003: fnd_message.set_token('OBJECT_ID',r_id.object_id);

1999:
2000: IF l_quantity <> 1
2001: THEN
2002: fnd_message.set_name('CSI', 'CSI_NON_ATO_PTO_ITEM');
2003: fnd_message.set_token('OBJECT_ID',r_id.object_id);
2004: fnd_msg_pub.add;
2005: l_msg_index := 1;
2006: fnd_msg_pub.count_and_get
2007: (p_count => x_msg_count,

Line 2026: fnd_message.set_name('CSI', 'CSI_EXPIRED_OBJECT');

2022: RAISE SKIP_ERROR;
2023: END IF;
2024: EXCEPTION
2025: WHEN NO_DATA_FOUND THEN
2026: fnd_message.set_name('CSI', 'CSI_EXPIRED_OBJECT');
2027: fnd_message.set_token('OBJECT_ID',r_id.object_id);
2028: fnd_msg_pub.add;
2029: l_msg_index := 1;
2030: fnd_msg_pub.count_and_get

Line 2027: fnd_message.set_token('OBJECT_ID',r_id.object_id);

2023: END IF;
2024: EXCEPTION
2025: WHEN NO_DATA_FOUND THEN
2026: fnd_message.set_name('CSI', 'CSI_EXPIRED_OBJECT');
2027: fnd_message.set_token('OBJECT_ID',r_id.object_id);
2028: fnd_msg_pub.add;
2029: l_msg_index := 1;
2030: fnd_msg_pub.count_and_get
2031: (p_count => x_msg_count,

Line 2052: fnd_message.set_name('CSI','CSI_LOCKED_INSTANCE');

2048: -- 2.1 Validate MACD lock functionality for object_id
2049: IF csi_item_instance_pvt.check_item_instance_lock
2050: ( p_instance_id => r_id.object_id)
2051: THEN
2052: fnd_message.set_name('CSI','CSI_LOCKED_INSTANCE');
2053: fnd_message.set_token('INSTANCE_ID',r_id.object_id);
2054: fnd_msg_pub.add;
2055: l_msg_index := 1;
2056: fnd_msg_pub.count_and_get

Line 2053: fnd_message.set_token('INSTANCE_ID',r_id.object_id);

2049: IF csi_item_instance_pvt.check_item_instance_lock
2050: ( p_instance_id => r_id.object_id)
2051: THEN
2052: fnd_message.set_name('CSI','CSI_LOCKED_INSTANCE');
2053: fnd_message.set_token('INSTANCE_ID',r_id.object_id);
2054: fnd_msg_pub.add;
2055: l_msg_index := 1;
2056: fnd_msg_pub.count_and_get
2057: (p_count => x_msg_count,

Line 2088: fnd_message.set_name('CSI', 'CSI_EXPIRED_SUBJECT');

2084: WHERE instance_id=r_id.subject_id
2085: AND (SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE));
2086: EXCEPTION
2087: WHEN NO_DATA_FOUND THEN
2088: fnd_message.set_name('CSI', 'CSI_EXPIRED_SUBJECT');
2089: fnd_message.set_token('SUBJECT_ID',r_id.subject_id);
2090: fnd_msg_pub.add;
2091: l_msg_index := 1;
2092: fnd_msg_pub.count_and_get

Line 2089: fnd_message.set_token('SUBJECT_ID',r_id.subject_id);

2085: AND (SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE));
2086: EXCEPTION
2087: WHEN NO_DATA_FOUND THEN
2088: fnd_message.set_name('CSI', 'CSI_EXPIRED_SUBJECT');
2089: fnd_message.set_token('SUBJECT_ID',r_id.subject_id);
2090: fnd_msg_pub.add;
2091: l_msg_index := 1;
2092: fnd_msg_pub.count_and_get
2093: (p_count => x_msg_count,

Line 2114: fnd_message.set_name('CSI','CSI_LOCKED_INSTANCE');

2110: -- 3.1 Validate MACD lock functionality for subject_id
2111: IF csi_item_instance_pvt.check_item_instance_lock
2112: ( p_instance_id => r_id.subject_id)
2113: THEN
2114: fnd_message.set_name('CSI','CSI_LOCKED_INSTANCE');
2115: fnd_message.set_token('INSTANCE_ID',r_id.subject_id);
2116: fnd_msg_pub.add;
2117: l_msg_index := 1;
2118: fnd_msg_pub.count_and_get

Line 2115: fnd_message.set_token('INSTANCE_ID',r_id.subject_id);

2111: IF csi_item_instance_pvt.check_item_instance_lock
2112: ( p_instance_id => r_id.subject_id)
2113: THEN
2114: fnd_message.set_name('CSI','CSI_LOCKED_INSTANCE');
2115: fnd_message.set_token('INSTANCE_ID',r_id.subject_id);
2116: fnd_msg_pub.add;
2117: l_msg_index := 1;
2118: fnd_msg_pub.count_and_get
2119: (p_count => x_msg_count,

Line 2142: fnd_message.set_name('CSI', 'CSI_ACTIVE_END_DATE');

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;
2145: l_msg_index := 1;
2146: fnd_msg_pub.count_and_get

Line 2143: fnd_message.set_token('ACTIVE_END_DATE',r_id.relationship_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;
2145: l_msg_index := 1;
2146: fnd_msg_pub.count_and_get
2147: (p_count => x_msg_count,

Line 2176: fnd_message.set_name('CSI','CSI_SUB_RELCODE_EXIST');

2172: WHERE subject_id=r_id.subject_id
2173: AND relationship_type_code = r_id.relationship_type_code
2174: AND (active_end_date IS NULL OR active_end_date > SYSDATE)
2175: AND ROWNUM=1;
2176: fnd_message.set_name('CSI','CSI_SUB_RELCODE_EXIST');
2177: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',r_id.relationship_type_code);
2178: fnd_message.set_token('SUBJECT_ID',r_id.subject_id);
2179: fnd_msg_pub.add;
2180: l_msg_index := 1;

Line 2177: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',r_id.relationship_type_code);

2173: AND relationship_type_code = r_id.relationship_type_code
2174: AND (active_end_date IS NULL OR active_end_date > SYSDATE)
2175: AND ROWNUM=1;
2176: fnd_message.set_name('CSI','CSI_SUB_RELCODE_EXIST');
2177: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',r_id.relationship_type_code);
2178: fnd_message.set_token('SUBJECT_ID',r_id.subject_id);
2179: fnd_msg_pub.add;
2180: l_msg_index := 1;
2181: fnd_msg_pub.count_and_get

Line 2178: fnd_message.set_token('SUBJECT_ID',r_id.subject_id);

2174: AND (active_end_date IS NULL OR active_end_date > SYSDATE)
2175: AND ROWNUM=1;
2176: fnd_message.set_name('CSI','CSI_SUB_RELCODE_EXIST');
2177: fnd_message.set_token('RELATIONSHIP_TYPE_CODE',r_id.relationship_type_code);
2178: fnd_message.set_token('SUBJECT_ID',r_id.subject_id);
2179: fnd_msg_pub.add;
2180: l_msg_index := 1;
2181: fnd_msg_pub.count_and_get
2182: (p_count => x_msg_count,

Line 2244: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');

2240: object_id=r_id.object_id))
2241: AND relationship_type_code = r_id.relationship_type_code
2242: AND (active_end_date IS NULL OR active_end_date > SYSDATE)
2243: AND ROWNUM = 1;
2244: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
2245: fnd_message.set_token('RELATIONSHIP_TYPE',r_id.relationship_type_code);
2246: fnd_message.set_token('SUBJECT_ID',r_id.subject_id);
2247: fnd_message.set_token('OBJECT_ID',r_id.object_id);
2248: fnd_msg_pub.add;

Line 2245: fnd_message.set_token('RELATIONSHIP_TYPE',r_id.relationship_type_code);

2241: AND relationship_type_code = r_id.relationship_type_code
2242: AND (active_end_date IS NULL OR active_end_date > SYSDATE)
2243: AND ROWNUM = 1;
2244: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
2245: fnd_message.set_token('RELATIONSHIP_TYPE',r_id.relationship_type_code);
2246: fnd_message.set_token('SUBJECT_ID',r_id.subject_id);
2247: fnd_message.set_token('OBJECT_ID',r_id.object_id);
2248: fnd_msg_pub.add;
2249: l_msg_index := 1;

Line 2246: fnd_message.set_token('SUBJECT_ID',r_id.subject_id);

2242: AND (active_end_date IS NULL OR active_end_date > SYSDATE)
2243: AND ROWNUM = 1;
2244: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
2245: fnd_message.set_token('RELATIONSHIP_TYPE',r_id.relationship_type_code);
2246: fnd_message.set_token('SUBJECT_ID',r_id.subject_id);
2247: fnd_message.set_token('OBJECT_ID',r_id.object_id);
2248: fnd_msg_pub.add;
2249: l_msg_index := 1;
2250: fnd_msg_pub.count_and_get

Line 2247: fnd_message.set_token('OBJECT_ID',r_id.object_id);

2243: AND ROWNUM = 1;
2244: fnd_message.set_name('CSI','CSI_RELATIONSHIP_EXISTS');
2245: fnd_message.set_token('RELATIONSHIP_TYPE',r_id.relationship_type_code);
2246: fnd_message.set_token('SUBJECT_ID',r_id.subject_id);
2247: fnd_message.set_token('OBJECT_ID',r_id.object_id);
2248: fnd_msg_pub.add;
2249: l_msg_index := 1;
2250: fnd_msg_pub.count_and_get
2251: (p_count => x_msg_count,

Line 2279: fnd_message.set_name('CSI','CSI_LINK_EXISTS');

2275: (p_instance_id => r_id.object_id
2276: ,p_mode => 'CREATE'
2277: ,p_relationship_id => NULL )
2278: THEN
2279: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
2280: fnd_message.set_token('INSTANCE_ID',r_id.object_id);
2281: fnd_msg_pub.add;
2282: l_msg_index := 1;
2283: fnd_msg_pub.count_and_get

Line 2280: fnd_message.set_token('INSTANCE_ID',r_id.object_id);

2276: ,p_mode => 'CREATE'
2277: ,p_relationship_id => NULL )
2278: THEN
2279: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
2280: fnd_message.set_token('INSTANCE_ID',r_id.object_id);
2281: fnd_msg_pub.add;
2282: l_msg_index := 1;
2283: fnd_msg_pub.count_and_get
2284: (p_count => x_msg_count,

Line 2311: fnd_message.set_name('CSI','CSI_LINK_EXISTS');

2307: (p_instance_id => r_id.subject_id
2308: ,p_mode => 'CREATE'
2309: ,p_relationship_id => NULL )
2310: THEN
2311: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
2312: fnd_message.set_token('INSTANCE_ID',r_id.subject_id);
2313: fnd_msg_pub.add;
2314: l_msg_index := 1;
2315: fnd_msg_pub.count_and_get

Line 2312: fnd_message.set_token('INSTANCE_ID',r_id.subject_id);

2308: ,p_mode => 'CREATE'
2309: ,p_relationship_id => NULL )
2310: THEN
2311: fnd_message.set_name('CSI','CSI_LINK_EXISTS');
2312: fnd_message.set_token('INSTANCE_ID',r_id.subject_id);
2313: fnd_msg_pub.add;
2314: l_msg_index := 1;
2315: fnd_msg_pub.count_and_get
2316: (p_count => x_msg_count,

Line 2490: fnd_message.set_name('CSI','CSI_FAILED_TO_VALIDATE_INS');

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);
2492: fnd_msg_pub.add;
2493: */
2494: l_msg_index := 1;

Line 2491: fnd_message.set_token('instance_id',l_instance_rec.instance_id);

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);
2492: fnd_msg_pub.add;
2493: */
2494: l_msg_index := 1;
2495: