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.CS_KB_ELEMENTS_AUDIT_PKG dependencies on FND_API

Line 271: WHEN FND_API.g_exc_error THEN

267:
268: RETURN l_element_id;
269:
270: EXCEPTION
271: WHEN FND_API.g_exc_error THEN
272: RETURN ERROR_STATUS;
273: WHEN others THEN
274: IF(l_clob IS NOT NULL) THEN
275: DBMS_LOB.freetemporary(l_clob);

Line 624: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

620: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active, sysdate))
621: AND trunc(nvl(end_date_active, sysdate));
622:
623: BEGIN
624: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
625: -- check params
626: IF(p_element_type_id IS NULL OR p_name IS NULL) THEN
627: FND_MSG_PUB.initialize;
628: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');

Line 630: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

626: IF(p_element_type_id IS NULL OR p_name IS NULL) THEN
627: FND_MSG_PUB.initialize;
628: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
629: FND_MSG_PUB.ADD;
630: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
631: X_ELEMENT_ID := -1;
632: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
633: p_count => x_msg_count,
634: p_data => x_msg_data);

Line 632: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

628: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
629: FND_MSG_PUB.ADD;
630: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
631: X_ELEMENT_ID := -1;
632: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
633: p_count => x_msg_count,
634: p_data => x_msg_data);
635:
636: ELSE

Line 646: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

642: IF(l_count <1) THEN
643: FND_MSG_PUB.initialize;
644: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_ELE_TYPE_ID');
645: FND_MSG_PUB.ADD;
646: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
647: X_ELEMENT_ID := -2;
648: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
649: p_count => x_msg_count,
650: p_data => x_msg_data);

Line 648: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

644: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_ELE_TYPE_ID');
645: FND_MSG_PUB.ADD;
646: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
647: X_ELEMENT_ID := -2;
648: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
649: p_count => x_msg_count,
650: p_data => x_msg_data);
651: ELSE
652: -- SEDATE

Line 661: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

657: If l_dummy Is Null Then
658: FND_MSG_PUB.initialize;
659: FND_MESSAGE.set_name('CS', 'CS_KB_EXPIRED_STMT_TYPE');
660: FND_MSG_PUB.ADD;
661: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
662: X_ELEMENT_ID := -3;
663: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
664: p_count => x_msg_count,
665: p_data => x_msg_data);

Line 663: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

659: FND_MESSAGE.set_name('CS', 'CS_KB_EXPIRED_STMT_TYPE');
660: FND_MSG_PUB.ADD;
661: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
662: X_ELEMENT_ID := -3;
663: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
664: p_count => x_msg_count,
665: p_data => x_msg_data);
666: ELSE
667:

Line 686: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

682: IF x_element_id IS NULL OR l_element_number IS NULL THEN
683: FND_MSG_PUB.initialize;
684: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
685: FND_MSG_PUB.ADD;
686: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
687: X_ELEMENT_ID := -1;
688: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
689: p_count => x_msg_count,
690: p_data => x_msg_data);

Line 688: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

684: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
685: FND_MSG_PUB.ADD;
686: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
687: X_ELEMENT_ID := -1;
688: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
689: p_count => x_msg_count,
690: p_data => x_msg_data);
691: ELSE
692:

Line 740: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

736: x_start_active_date => p_start_active_date,
737: x_end_active_date => p_end_active_date,
738: x_content_type => p_content_type );
739:
740: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
741:
742: END IF;
743:
744: END IF;

Line 753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

749:
750: EXCEPTION
751: WHEN others THEN
752: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
754:
755: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
756: p_data => x_msg_data);
757: END Create_Statement;

Line 829: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

825: WHERE element_id = p_element_id
826: AND element_type_id = p_element_type_id;
827:
828: BEGIN
829: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
830: X_RETURN := -8;
831:
832: -- validate params
833: IF (p_element_id IS NULL) OR ( NOT p_element_type_id > 0) THEN

Line 838: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

834: X_RETURN := -1; -- 'CS_KB_C_MISS_PARAM'
835: FND_MSG_PUB.initialize;
836: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
837: FND_MSG_PUB.ADD;
838: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
839: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
840: p_count => X_MSG_COUNT,
841: p_data => X_MSG_DATA);
842: ELSE

Line 839: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

835: FND_MSG_PUB.initialize;
836: FND_MESSAGE.set_name('CS', 'CS_KB_C_MISS_PARAM');
837: FND_MSG_PUB.ADD;
838: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
839: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
840: p_count => X_MSG_COUNT,
841: p_data => X_MSG_DATA);
842: ELSE
843:

Line 854: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

850: X_RETURN := -2;
851: FND_MSG_PUB.initialize;
852: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_ELE_TYPE_ID');
853: FND_MSG_PUB.ADD;
854: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
855: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
856: p_count => X_MSG_COUNT,
857: p_data => X_MSG_DATA);
858: ELSE

Line 855: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

851: FND_MSG_PUB.initialize;
852: FND_MESSAGE.set_name('CS', 'CS_KB_C_INVALID_ELE_TYPE_ID');
853: FND_MSG_PUB.ADD;
854: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
855: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
856: p_count => X_MSG_COUNT,
857: p_data => X_MSG_DATA);
858: ELSE
859: -- SEDATE

Line 876: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

872: X_RETURN := -3;
873: FND_MSG_PUB.initialize;
874: FND_MESSAGE.set_name('CS', 'CS_KB_END_DATED_TYPE');
875: FND_MSG_PUB.ADD;
876: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
877: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
878: p_count => X_MSG_COUNT,
879: p_data => X_MSG_DATA);
880:

Line 877: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

873: FND_MSG_PUB.initialize;
874: FND_MESSAGE.set_name('CS', 'CS_KB_END_DATED_TYPE');
875: FND_MSG_PUB.ADD;
876: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
877: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
878: p_count => X_MSG_COUNT,
879: p_data => X_MSG_DATA);
880:
881: END IF;

Line 934: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

930: FROM CS_KB_SET_ELES
931: WHERE element_id = p_element_id);
932:
933: X_RETURN := OKAY_STATUS;
934: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
935:
936: END IF; -- Type Not End Dated
937:
938: END IF; -- Element Type is valid

Line 946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

942: EXCEPTION
943: WHEN OTHERS THEN
944: X_RETURN := -7;--ERROR_STATUS;
945: FND_MESSAGE.set_name('CS', 'CS_KB_C_UPDATE_ERR');
946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
947: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
948: p_count => X_MSG_COUNT,
949: p_data => X_MSG_DATA);
950: END Update_Statement;

Line 947: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

943: WHEN OTHERS THEN
944: X_RETURN := -7;--ERROR_STATUS;
945: FND_MESSAGE.set_name('CS', 'CS_KB_C_UPDATE_ERR');
946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
947: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
948: p_count => X_MSG_COUNT,
949: p_data => X_MSG_DATA);
950: END Update_Statement;
951:

Line 1106: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

1102:
1103: l_asap_idx_enabled varchar2(4) := null;
1104:
1105: BEGIN
1106: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1107: X_RETURN_ELEMENT := P_ELEMENT_ID;
1108:
1109: SAVEPOINT START_GSU;
1110:

Line 1175: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1171: CS_KB_SYNC_INDEX_PKG.request_sync_km_indexes( l_request_id, l_return_status );
1172: END IF;
1173:
1174: X_RETURN_ELEMENT := l_dup_id;
1175: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1176:
1177: ELSE -- The Updated Statement is not a Duplicate
1178:
1179: /* -- Need to check Soln Usage !!!

Line 1259: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1255: X_RETURN_STATUS := l_return_status;
1256: X_MSG_DATA := l_msg_data;
1257: X_MSG_COUNT := l_msg_count;
1258:
1259: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1260:
1261: cs_kb_sync_index_pkg.MARK_IDXS_ON_GLOBAL_STMT_UPD(P_ELEMENT_ID);
1262:
1263: fnd_profile.get('CS_KB_ENABLE_ASAP_INDEXING', l_asap_idx_enabled);

Line 1316: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1312: x_return_status => l_return_status,
1313: x_msg_data => l_msg_data,
1314: x_msg_count => l_msg_count);
1315:
1316: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1317: X_RETURN_ELEMENT := NULL;
1318: X_RETURN_STATUS := l_return_status;
1319: X_MSG_DATA := l_msg_data;
1320: X_MSG_COUNT := l_msg_count;

Line 1349: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1345: CS_KB_SYNC_INDEX_PKG.request_sync_km_indexes( l_request_id, l_return_status );
1346: END IF;
1347:
1348: X_RETURN_ELEMENT := l_new_element_id;
1349: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1350:
1351: END IF;
1352:
1353: ELSE

Line 1359: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1355: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csk.plsql.CS_KB_ELEMENTS_AUDIT_PVT.Update_Statement_Admin',
1356: 'Stmt is dup of the original - NO new Stmt created.');
1357: END IF;
1358: X_RETURN_ELEMENT := P_ELEMENT_ID;
1359: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1360: END IF; --check if dup of itself
1361:
1362: END IF;
1363:

Line 1385: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

1381:
1382: X_RETURN_ELEMENT := NULL;
1383: FND_MESSAGE.set_name('CS', 'CS_KB_C_UPDATE_ERR');
1384: FND_MSG_PUB.ADD;
1385: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
1386: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1387: p_count => X_MSG_COUNT,
1388: p_data => X_MSG_DATA);
1389: END Update_Statement_Admin;

Line 1386: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

1382: X_RETURN_ELEMENT := NULL;
1383: FND_MESSAGE.set_name('CS', 'CS_KB_C_UPDATE_ERR');
1384: FND_MSG_PUB.ADD;
1385: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
1386: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
1387: p_count => X_MSG_COUNT,
1388: p_data => X_MSG_DATA);
1389: END Update_Statement_Admin;
1390: