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

Line 340: IF NOT FND_API.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

336: BEGIN
337: x_return_status := 'S';
338: x_msg_count := 0;
339: ---check api version
340: IF NOT FND_API.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
341: RAISE G_INCOMPATIBLE_API;
342: END IF;
343:
344: ----default user name

Line 427: x_return_status := FND_API.G_RET_STS_ERROR;

423: END IF;
424: EXCEPTION
425: WHEN G_INCOMPATIBLE_API THEN
426: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_API_VERSION_ERR','CODEVERSION',l_api_version,'VERSION',p_api_version);
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: x_msg_count := 1;
429: WHEN NULL_USER_NAME THEN
430: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_USER_IS_NULL');
431: x_return_status := FND_API.G_RET_STS_ERROR;

Line 431: x_return_status := FND_API.G_RET_STS_ERROR;

427: x_return_status := FND_API.G_RET_STS_ERROR;
428: x_msg_count := 1;
429: WHEN NULL_USER_NAME THEN
430: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_USER_IS_NULL');
431: x_return_status := FND_API.G_RET_STS_ERROR;
432: x_msg_count := 1;
433: WHEN RESP_IS_NULL THEN
434: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_RESP_IS_NULL');
435: x_return_status := FND_API.G_RET_STS_ERROR;

Line 435: x_return_status := FND_API.G_RET_STS_ERROR;

431: x_return_status := FND_API.G_RET_STS_ERROR;
432: x_msg_count := 1;
433: WHEN RESP_IS_NULL THEN
434: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_RESP_IS_NULL');
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: x_msg_count := 1;
437: WHEN INVALID_ROLE THEN
438: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ROLE');
439: x_return_status := FND_API.G_RET_STS_ERROR;

Line 439: x_return_status := FND_API.G_RET_STS_ERROR;

435: x_return_status := FND_API.G_RET_STS_ERROR;
436: x_msg_count := 1;
437: WHEN INVALID_ROLE THEN
438: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ROLE');
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: x_msg_count := 1;
441: WHEN FUNCTION_NAME_NULL THEN
442: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_FUNC_NAME_IS_NULL');
443: x_return_status := FND_API.G_RET_STS_ERROR;

Line 443: x_return_status := FND_API.G_RET_STS_ERROR;

439: x_return_status := FND_API.G_RET_STS_ERROR;
440: x_msg_count := 1;
441: WHEN FUNCTION_NAME_NULL THEN
442: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_FUNC_NAME_IS_NULL');
443: x_return_status := FND_API.G_RET_STS_ERROR;
444: x_msg_count := 1;
445: WHEN ENTITY_ROLE_IS_NULL THEN
446: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_ROLE_IS_NULL');
447: x_return_status := FND_API.G_RET_STS_ERROR;

Line 447: x_return_status := FND_API.G_RET_STS_ERROR;

443: x_return_status := FND_API.G_RET_STS_ERROR;
444: x_msg_count := 1;
445: WHEN ENTITY_ROLE_IS_NULL THEN
446: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_ROLE_IS_NULL');
447: x_return_status := FND_API.G_RET_STS_ERROR;
448: x_msg_count := 1;
449: WHEN MENU_ID_NOT_FOUND THEN
450: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ROLE', 'Privilege', p_entity_role );
451: x_return_status := FND_API.G_RET_STS_ERROR;

Line 451: x_return_status := FND_API.G_RET_STS_ERROR;

447: x_return_status := FND_API.G_RET_STS_ERROR;
448: x_msg_count := 1;
449: WHEN MENU_ID_NOT_FOUND THEN
450: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ROLE', 'Privilege', p_entity_role );
451: x_return_status := FND_API.G_RET_STS_ERROR;
452: x_msg_count := 1;
453: WHEN OBJECT_ID_NOT_FOUND THEN
454: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_OBJECT_ID_ERR', 'object_id',l_entity_type);
455: x_return_status := FND_API.G_RET_STS_ERROR;

Line 455: x_return_status := FND_API.G_RET_STS_ERROR;

451: x_return_status := FND_API.G_RET_STS_ERROR;
452: x_msg_count := 1;
453: WHEN OBJECT_ID_NOT_FOUND THEN
454: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_OBJECT_ID_ERR', 'object_id',l_entity_type);
455: x_return_status := FND_API.G_RET_STS_ERROR;
456: x_msg_count := 1;
457: WHEN INSTANCE_SET_ERR THEN
458: x_msg_data := CZ_UTILS.GET_TEXT('CZ_INVALID_INSTANCE_SET', 'SET',l_inst_name,
459: 'ENTITY_TYPE',l_entity_type, 'ERROR', SQLERRM);

Line 461: x_return_status := FND_API.G_RET_STS_ERROR;

457: WHEN INSTANCE_SET_ERR THEN
458: x_msg_data := CZ_UTILS.GET_TEXT('CZ_INVALID_INSTANCE_SET', 'SET',l_inst_name,
459: 'ENTITY_TYPE',l_entity_type, 'ERROR', SQLERRM);
460: x_msg_count := 1;
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: WHEN PRIV_ALREADY_EXISTS THEN
463: NULL; ---not necessary to return a message
464: WHEN OTHERS THEN
465: x_msg_data := SQLERRM;

Line 466: x_return_status := FND_API.G_RET_STS_ERROR;

462: WHEN PRIV_ALREADY_EXISTS THEN
463: NULL; ---not necessary to return a message
464: WHEN OTHERS THEN
465: x_msg_data := SQLERRM;
466: x_return_status := FND_API.G_RET_STS_ERROR;
467: END grant_privilege;
468:
469: ----------------------------------------------------------------
470: ------revoke privilege on an entity

Line 495: IF NOT FND_API.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

491: BEGIN
492: x_return_status := 'S';
493: x_msg_count := 0;
494: ---check api version
495: IF NOT FND_API.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
496: RAISE G_INCOMPATIBLE_API;
497: END IF;
498:
499: IF (p_entity_role IS NULL) THEN

Line 553: x_return_status := FND_API.G_RET_STS_ERROR;

549: END IF;
550: EXCEPTION
551: WHEN G_INCOMPATIBLE_API THEN
552: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_API_VERSION_ERR','CODEVERSION',l_api_version,'VERSION',p_api_version);
553: x_return_status := FND_API.G_RET_STS_ERROR;
554: WHEN OBJECT_ID_NOT_FOUND THEN
555: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_OBJECT_ID_ERR', 'object_id', l_entity_type);
556: x_return_status := FND_API.G_RET_STS_ERROR;
557: WHEN INVALID_ENTITY_TYPE THEN

Line 556: x_return_status := FND_API.G_RET_STS_ERROR;

552: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_API_VERSION_ERR','CODEVERSION',l_api_version,'VERSION',p_api_version);
553: x_return_status := FND_API.G_RET_STS_ERROR;
554: WHEN OBJECT_ID_NOT_FOUND THEN
555: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_OBJECT_ID_ERR', 'object_id', l_entity_type);
556: x_return_status := FND_API.G_RET_STS_ERROR;
557: WHEN INVALID_ENTITY_TYPE THEN
558: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ENTITY_TYP', 'OBJECTTYPE', l_entity_type);
559: x_return_status := FND_API.G_RET_STS_ERROR;
560: WHEN ENTITY_ROLE_IS_NULL THEN

Line 559: x_return_status := FND_API.G_RET_STS_ERROR;

555: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_OBJECT_ID_ERR', 'object_id', l_entity_type);
556: x_return_status := FND_API.G_RET_STS_ERROR;
557: WHEN INVALID_ENTITY_TYPE THEN
558: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ENTITY_TYP', 'OBJECTTYPE', l_entity_type);
559: x_return_status := FND_API.G_RET_STS_ERROR;
560: WHEN ENTITY_ROLE_IS_NULL THEN
561: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_ROLE_IS_NULL');
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: x_msg_count := 1;

Line 562: x_return_status := FND_API.G_RET_STS_ERROR;

558: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ENTITY_TYP', 'OBJECTTYPE', l_entity_type);
559: x_return_status := FND_API.G_RET_STS_ERROR;
560: WHEN ENTITY_ROLE_IS_NULL THEN
561: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_ENTITY_ROLE_IS_NULL');
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: x_msg_count := 1;
564: WHEN MENU_ID_NOT_FOUND THEN
565: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ROLE', 'Privilege', p_entity_role );
566: x_return_status := FND_API.G_RET_STS_ERROR;

Line 566: x_return_status := FND_API.G_RET_STS_ERROR;

562: x_return_status := FND_API.G_RET_STS_ERROR;
563: x_msg_count := 1;
564: WHEN MENU_ID_NOT_FOUND THEN
565: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_ROLE', 'Privilege', p_entity_role );
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: x_msg_count := 1;
568: WHEN NO_PRIV_EXISTS THEN
569: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_NO_PRIV_EXISTS');
570: -----x_return_status := FND_API.G_RET_STS_ERROR;

Line 570: -----x_return_status := FND_API.G_RET_STS_ERROR;

566: x_return_status := FND_API.G_RET_STS_ERROR;
567: x_msg_count := 1;
568: WHEN NO_PRIV_EXISTS THEN
569: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_NO_PRIV_EXISTS');
570: -----x_return_status := FND_API.G_RET_STS_ERROR;
571: WHEN OTHERS THEN
572: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_FATAL_ERR', 'SQLERRM', SQLERRM);
573: x_return_status := FND_API.G_RET_STS_ERROR;
574: END revoke_privilege;

Line 573: x_return_status := FND_API.G_RET_STS_ERROR;

569: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_NO_PRIV_EXISTS');
570: -----x_return_status := FND_API.G_RET_STS_ERROR;
571: WHEN OTHERS THEN
572: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_FATAL_ERR', 'SQLERRM', SQLERRM);
573: x_return_status := FND_API.G_RET_STS_ERROR;
574: END revoke_privilege;
575:
576: -------------------------------------------------------------
577: PROCEDURE revoke_privilege(p_api_version IN NUMBER,

Line 654: IF NOT FND_API.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

650: l_function_name fnd_form_functions.function_name%TYPE;
651: l_user_name VARCHAR2(40);
652: BEGIN
653: ---check api version
654: IF NOT FND_API.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
655: RAISE G_INCOMPATIBLE_API;
656: END IF;
657: l_profile_value := get_profile_value(USE_ENTITY_ACCESS_CONTROL);
658: IF ( (l_profile_value <> 'Y') ) THEN

Line 715: x_return_status := FND_API.G_RET_STS_SUCCESS;

711: x_return_status OUT NOCOPY VARCHAR2,
712: x_msg_data OUT NOCOPY VARCHAR2)
713: IS
714: BEGIN
715: x_return_status := FND_API.G_RET_STS_SUCCESS;
716: x_msg_data := '';
717: END lock_entity ;
718:
719: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 725: x_return_status := FND_API.G_RET_STS_SUCCESS;

721: x_return_status OUT NOCOPY VARCHAR2,
722: x_msg_data OUT NOCOPY VARCHAR2)
723: IS
724: BEGIN
725: x_return_status := FND_API.G_RET_STS_SUCCESS;
726: x_msg_data := '';
727: END unlock_entity;
728:
729: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 1080: x_return_status := FND_API.G_RET_STS_SUCCESS;

1076: x_msg_count OUT NOCOPY NUMBER,
1077: x_msg_data OUT NOCOPY VARCHAR2)
1078: IS
1079: BEGIN
1080: x_return_status := FND_API.G_RET_STS_SUCCESS;
1081: x_msg_count := 0;
1082: x_msg_data := '';
1083: END lock_entity;
1084:

Line 1096: x_return_status := FND_API.G_RET_STS_SUCCESS;

1092: x_msg_count OUT NOCOPY NUMBER,
1093: x_msg_data OUT NOCOPY VARCHAR2)
1094: IS
1095: BEGIN
1096: x_return_status := FND_API.G_RET_STS_SUCCESS;
1097: x_msg_count := 0;
1098: x_msg_data := '';
1099: END lock_entity;
1100:

Line 1110: x_return_status := FND_API.G_RET_STS_SUCCESS;

1106: x_msg_count OUT NOCOPY NUMBER,
1107: x_msg_data OUT NOCOPY VARCHAR2)
1108: IS
1109: BEGIN
1110: x_return_status := FND_API.G_RET_STS_SUCCESS;
1111: x_msg_count := 0;
1112: x_msg_data := '';
1113: END lock_entity;
1114:

Line 1126: x_return_status := FND_API.G_RET_STS_SUCCESS;

1122: x_msg_count OUT NOCOPY NUMBER,
1123: x_msg_data OUT NOCOPY VARCHAR2)
1124: IS
1125: BEGIN
1126: x_return_status := FND_API.G_RET_STS_SUCCESS;
1127: x_msg_count := 0;
1128: x_msg_data := '';
1129: END lock_entity;
1130:

Line 1149: x_return_status := FND_API.G_RET_STS_SUCCESS;

1145: l_function_name fnd_form_functions.function_name%TYPE;
1146: l_proj_id NUMBER := 0;
1147: l_locked_entities_tbl number_type_tbl;
1148: BEGIN
1149: x_return_status := FND_API.G_RET_STS_SUCCESS;
1150: x_msg_count := 0;
1151: x_msg_data := '';
1152: END unlock_entity;
1153:

Line 1163: x_return_status := FND_API.G_RET_STS_SUCCESS;

1159: x_msg_count OUT NOCOPY NUMBER,
1160: x_msg_data OUT NOCOPY VARCHAR2)
1161: IS
1162: BEGIN
1163: x_return_status := FND_API.G_RET_STS_SUCCESS;
1164: x_msg_count := 0;
1165: x_msg_data := '';
1166: END unlock_entity;
1167:

Line 1176: x_return_status := FND_API.G_RET_STS_SUCCESS;

1172: x_msg_count OUT NOCOPY NUMBER,
1173: x_msg_data OUT NOCOPY VARCHAR2)
1174: IS
1175: BEGIN
1176: x_return_status := FND_API.G_RET_STS_SUCCESS;
1177: x_msg_count := 0;
1178: x_msg_data := '';
1179: END unlock_entity;
1180:

Line 1204: x_return_status := FND_API.G_RET_STS_SUCCESS;

1200: x_msg_count OUT NOCOPY NUMBER,
1201: x_msg_data OUT NOCOPY VARCHAR2)
1202: IS
1203: BEGIN
1204: x_return_status := FND_API.G_RET_STS_SUCCESS;
1205: x_msg_count := 0;
1206: x_msg_data := '';
1207: END unlock_entity;
1208:

Line 1305: x_return_status := FND_API.G_RET_STS_SUCCESS;

1301: l_resp_id NUMBER := 0;
1302: l_profile_value VARCHAR2(255) := '';
1303:
1304: BEGIN
1305: x_return_status := FND_API.G_RET_STS_SUCCESS;
1306: x_msg_count := 0;
1307:
1308: ---check api version
1309: IF NOT FND_API.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

Line 1309: IF NOT FND_API.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN

1305: x_return_status := FND_API.G_RET_STS_SUCCESS;
1306: x_msg_count := 0;
1307:
1308: ---check api version
1309: IF NOT FND_API.Compatible_API_Call(l_api_version,p_api_version,l_api_name,G_PKG_NAME) THEN
1310: RAISE G_INCOMPATIBLE_API;
1311: END IF;
1312:
1313: -----check if models have to be locked for global operations

Line 1363: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1359: x_return_status,
1360: x_msg_count,
1361: x_msg_data);
1362:
1363: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1364: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_LOCK_ENTITY_ERR');
1365: x_msg_count := 1;
1366: x_return_status := FND_API.G_RET_STS_ERROR;
1367: END IF;

Line 1366: x_return_status := FND_API.G_RET_STS_ERROR;

1362:
1363: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1364: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_LOCK_ENTITY_ERR');
1365: x_msg_count := 1;
1366: x_return_status := FND_API.G_RET_STS_ERROR;
1367: END IF;
1368:
1369: EXCEPTION
1370: WHEN G_INCOMPATIBLE_API THEN

Line 1373: x_return_status := FND_API.G_RET_STS_ERROR;

1369: EXCEPTION
1370: WHEN G_INCOMPATIBLE_API THEN
1371: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_API_VERSION_ERR','CODEVERSION',l_api_version,'VERSION',p_api_version);
1372: x_msg_count := 1;
1373: x_return_status := FND_API.G_RET_STS_ERROR;
1374: WHEN NO_LOCK_CONTROL_REQUIRED THEN
1375: NULL; ----do nothing
1376: WHEN USER_NAME_NULL THEN
1377: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_USER_NAME_NULL');

Line 1379: x_return_status := FND_API.G_RET_STS_ERROR;

1375: NULL; ----do nothing
1376: WHEN USER_NAME_NULL THEN
1377: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_USER_NAME_NULL');
1378: x_msg_count := 1;
1379: x_return_status := FND_API.G_RET_STS_ERROR;
1380: WHEN INVALID_USER_NAME THEN
1381: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_USER_NAME','USERNAME',p_user_name);
1382: x_msg_count := 1;
1383: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1383: x_return_status := FND_API.G_RET_STS_ERROR;

1379: x_return_status := FND_API.G_RET_STS_ERROR;
1380: WHEN INVALID_USER_NAME THEN
1381: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_USER_NAME','USERNAME',p_user_name);
1382: x_msg_count := 1;
1383: x_return_status := FND_API.G_RET_STS_ERROR;
1384: WHEN APPL_NAME_NULL THEN
1385: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_APPL_NAME_NULL');
1386: x_msg_count := 1;
1387: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1387: x_return_status := FND_API.G_RET_STS_ERROR;

1383: x_return_status := FND_API.G_RET_STS_ERROR;
1384: WHEN APPL_NAME_NULL THEN
1385: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_APPL_NAME_NULL');
1386: x_msg_count := 1;
1387: x_return_status := FND_API.G_RET_STS_ERROR;
1388: WHEN RESP_NAME_NULL THEN
1389: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_RESP_NAME_NULL');
1390: x_msg_count := 1;
1391: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1391: x_return_status := FND_API.G_RET_STS_ERROR;

1387: x_return_status := FND_API.G_RET_STS_ERROR;
1388: WHEN RESP_NAME_NULL THEN
1389: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_RESP_NAME_NULL');
1390: x_msg_count := 1;
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: WHEN INVALID_APPLICATION THEN
1393: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_APPLICATION','APPLICATION',p_application);
1394: x_msg_count := 1;
1395: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1395: x_return_status := FND_API.G_RET_STS_ERROR;

1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: WHEN INVALID_APPLICATION THEN
1393: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_APPLICATION','APPLICATION',p_application);
1394: x_msg_count := 1;
1395: x_return_status := FND_API.G_RET_STS_ERROR;
1396: WHEN INVALID_RESPONSIBILITY THEN
1397: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_RESPONSIBILITY','RESPONSIBILITY',p_responsibility);
1398: x_msg_count := 1;
1399: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1399: x_return_status := FND_API.G_RET_STS_ERROR;

1395: x_return_status := FND_API.G_RET_STS_ERROR;
1396: WHEN INVALID_RESPONSIBILITY THEN
1397: x_msg_data := CZ_UTILS.GET_TEXT('CZ_SEC_INVALID_RESPONSIBILITY','RESPONSIBILITY',p_responsibility);
1398: x_msg_count := 1;
1399: x_return_status := FND_API.G_RET_STS_ERROR;
1400: WHEN OTHERS THEN
1401: x_msg_data := SQLERRM;
1402: x_msg_count := 1;
1403: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1403: x_return_status := FND_API.G_RET_STS_ERROR;

1399: x_return_status := FND_API.G_RET_STS_ERROR;
1400: WHEN OTHERS THEN
1401: x_msg_data := SQLERRM;
1402: x_msg_count := 1;
1403: x_return_status := FND_API.G_RET_STS_ERROR;
1404: END check_priv_and_lock_entity;
1405:
1406: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
1407: FUNCTION are_models_locked (p_model_id IN NUMBER)

Line 3102: * @param p_unlock_references A value of FND_API.G_TRUE indicates that the child models if any should be

3098: /*#
3099: * This is the public interface for force unlock operations on a model in Oracle Configurator
3100: * @param p_api_version number. Current version of the API is 1.0
3101: * @param p_model_id number. devl_project_id of the model from cz_devl_projects table
3102: * @param p_unlock_references A value of FND_API.G_TRUE indicates that the child models if any should be
3103: * force unlocked. A value of FND_API.G_FALSE indicates that only the root model
3104: * will be unlocked
3105: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3106: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )

Line 3103: * force unlocked. A value of FND_API.G_FALSE indicates that only the root model

3099: * This is the public interface for force unlock operations on a model in Oracle Configurator
3100: * @param p_api_version number. Current version of the API is 1.0
3101: * @param p_model_id number. devl_project_id of the model from cz_devl_projects table
3102: * @param p_unlock_references A value of FND_API.G_TRUE indicates that the child models if any should be
3103: * force unlocked. A value of FND_API.G_FALSE indicates that only the root model
3104: * will be unlocked
3105: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3106: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
3107: * @param x_msg_count number of messages on the stack.

Line 3105: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.

3101: * @param p_model_id number. devl_project_id of the model from cz_devl_projects table
3102: * @param p_unlock_references A value of FND_API.G_TRUE indicates that the child models if any should be
3103: * force unlocked. A value of FND_API.G_FALSE indicates that only the root model
3104: * will be unlocked
3105: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3106: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
3107: * @param x_msg_count number of messages on the stack.
3108: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
3109: * @rep:scope public

Line 3106: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )

3102: * @param p_unlock_references A value of FND_API.G_TRUE indicates that the child models if any should be
3103: * force unlocked. A value of FND_API.G_FALSE indicates that only the root model
3104: * will be unlocked
3105: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3106: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
3107: * @param x_msg_count number of messages on the stack.
3108: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
3109: * @rep:scope public
3110: * @rep:product CZ

Line 3138: x_return_status := FND_API.G_RET_STS_SUCCESS;

3134: l_model_name cz_devl_projects.name%TYPE;
3135:
3136: BEGIN
3137: ----initialize FND stack
3138: x_return_status := FND_API.G_RET_STS_SUCCESS;
3139: x_msg_data := NULL;
3140: x_msg_count := 0;
3141:
3142: ----initialize the message stack depending on the input parameter

Line 3143: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

3139: x_msg_data := NULL;
3140: x_msg_count := 0;
3141:
3142: ----initialize the message stack depending on the input parameter
3143: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
3144:
3145: ----check if the input parameter p_model_id is NULL
3146: ----if it is NULL raise an exception
3147: IF (p_model_id IS NULL) THEN

Line 3162: ELSIF (p_unlock_references = FND_API.G_FALSE) THEN

3158:
3159: -----validate input parameter p_unlock_references
3160: IF (p_unlock_references IS NULL) THEN
3161: l_unlock_references := DO_NOT_UNLOCK_CHILD_MODELS;
3162: ELSIF (p_unlock_references = FND_API.G_FALSE) THEN
3163: l_unlock_references := DO_NOT_UNLOCK_CHILD_MODELS;
3164: ELSIF (p_unlock_references = FND_API.G_TRUE) THEN
3165: l_unlock_references := UNLOCK_CHILD_MODELS;
3166: END IF; /* end if of (p_unlock_references IS NULL) */

Line 3164: ELSIF (p_unlock_references = FND_API.G_TRUE) THEN

3160: IF (p_unlock_references IS NULL) THEN
3161: l_unlock_references := DO_NOT_UNLOCK_CHILD_MODELS;
3162: ELSIF (p_unlock_references = FND_API.G_FALSE) THEN
3163: l_unlock_references := DO_NOT_UNLOCK_CHILD_MODELS;
3164: ELSIF (p_unlock_references = FND_API.G_TRUE) THEN
3165: l_unlock_references := UNLOCK_CHILD_MODELS;
3166: END IF; /* end if of (p_unlock_references IS NULL) */
3167:
3168: ------if p_unlock_references IS FND_API.G_TRUE then

Line 3168: ------if p_unlock_references IS FND_API.G_TRUE then

3164: ELSIF (p_unlock_references = FND_API.G_TRUE) THEN
3165: l_unlock_references := UNLOCK_CHILD_MODELS;
3166: END IF; /* end if of (p_unlock_references IS NULL) */
3167:
3168: ------if p_unlock_references IS FND_API.G_TRUE then
3169: ------do the following
3170: IF (l_unlock_references = UNLOCK_CHILD_MODELS) THEN
3171: l_model_tbl.DELETE;
3172: BEGIN

Line 3216: x_return_status := FND_API.G_RET_STS_ERROR;

3212: EXCEPTION
3213: WHEN MODELID_IS_NULL THEN
3214: NULL;
3215: WHEN NO_FORCE_UNLOCK_PRIV THEN
3216: x_return_status := FND_API.G_RET_STS_ERROR;
3217: x_msg_count := 1;
3218: FND_MESSAGE.SET_NAME( 'CZ','CZ_NO_FORCE_UNLOCK_PRIV');
3219: --FND_MESSAGE.SET_TOKEN('USERNAME',FND_GLOBAL.USER_NAME);
3220: FND_MSG_PUB.ADD;

Line 3223: x_return_status := FND_API.G_RET_STS_ERROR;

3219: --FND_MESSAGE.SET_TOKEN('USERNAME',FND_GLOBAL.USER_NAME);
3220: FND_MSG_PUB.ADD;
3221: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3222: WHEN MODEL_UNLOCK_ERR THEN
3223: x_return_status := FND_API.G_RET_STS_ERROR;
3224: x_msg_count := 1;
3225: FND_MESSAGE.SET_NAME( 'CZ','CZ_MODEL_UNLOCK_ERR');
3226: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
3227: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);

Line 3231: x_return_status := FND_API.G_RET_STS_ERROR;

3227: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);
3228: FND_MSG_PUB.ADD;
3229: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3230: WHEN OTHERS THEN
3231: x_return_status := FND_API.G_RET_STS_ERROR;
3232: x_msg_count := 1;
3233: get_checkout_user(p_model_id, 'PRJ', l_checkout_user, l_model_name);
3234: x_msg_data := CZ_UTILS.GET_TEXT('CZ_UNLOCK_FATAL_ERR', 'OBJECTNAME', l_model_name, 'SQLERRM', SQLERRM);
3235: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3243: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.

3239: /*#
3240: * This is the public interface for force unlock operations on a UI content template in Oracle Configurator
3241: * @param p_api_version number. Current version of the API is 1.0
3242: * @param p_template_id number. Template_id of the template from cz_ui_templates table
3243: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3244: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
3245: * @param x_msg_count number of messages on the stack.
3246: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
3247: * @rep:scope public

Line 3244: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )

3240: * This is the public interface for force unlock operations on a UI content template in Oracle Configurator
3241: * @param p_api_version number. Current version of the API is 1.0
3242: * @param p_template_id number. Template_id of the template from cz_ui_templates table
3243: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3244: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
3245: * @param x_msg_count number of messages on the stack.
3246: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
3247: * @rep:scope public
3248: * @rep:product CZ

Line 3276: x_return_status := FND_API.G_RET_STS_SUCCESS;

3272:
3273: BEGIN
3274:
3275: ----initialize FND stack
3276: x_return_status := FND_API.G_RET_STS_SUCCESS;
3277: x_msg_data := NULL;
3278: x_msg_count := 0;
3279:
3280: ----initialize the message stack depending on the input parameter

Line 3281: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

3277: x_msg_data := NULL;
3278: x_msg_count := 0;
3279:
3280: ----initialize the message stack depending on the input parameter
3281: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
3282:
3283: ----check if the input parameter p_template_id is NULL
3284: ----if it is NULL raise an exception
3285: IF (p_template_id IS NULL) THEN

Line 3313: x_return_status := FND_API.G_RET_STS_ERROR;

3309: EXCEPTION
3310: WHEN TEMPLATEID_IS_NULL THEN
3311: NULL;
3312: WHEN NO_FORCE_UNLOCK_PRIV THEN
3313: x_return_status := FND_API.G_RET_STS_ERROR;
3314: x_msg_count := 1;
3315: FND_MESSAGE.SET_NAME( 'CZ','CZ_NO_FORCE_UNLOCK_PRIV');
3316: --FND_MESSAGE.SET_TOKEN('USERNAME',FND_GLOBAL.USER_NAME);
3317: FND_MSG_PUB.ADD;

Line 3320: x_return_status := FND_API.G_RET_STS_ERROR;

3316: --FND_MESSAGE.SET_TOKEN('USERNAME',FND_GLOBAL.USER_NAME);
3317: FND_MSG_PUB.ADD;
3318: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3319: WHEN TEMPLATE_UNLOCK_ERR THEN
3320: x_return_status := FND_API.G_RET_STS_ERROR;
3321: x_msg_count := 1;
3322: FND_MESSAGE.SET_NAME( 'CZ','CZ_UNLOCK_TMPL_ERR');
3323: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
3324: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);

Line 3328: x_return_status := FND_API.G_RET_STS_ERROR;

3324: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);
3325: FND_MSG_PUB.ADD;
3326: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3327: WHEN OTHERS THEN
3328: x_return_status := FND_API.G_RET_STS_ERROR;
3329: x_msg_count := 1;
3330: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);
3331: x_msg_data := CZ_UTILS.GET_TEXT('CZ_UNLOCK_FATAL_ERR', 'OBJECTNAME', l_template_name, 'SQLERRM', SQLERRM);
3332: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3340: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the

3336: /*#
3337: * This is the public interface for lock operations on a UI content template in Oracle Configurator
3338: * @param p_api_version number. Current version of the API is 1.0
3339: * @param p_template_id number. Template_id of the template from cz_ui_templates table
3340: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
3341: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
3342: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3343: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
3344: * @param x_msg_count number of messages on the stack.

Line 3341: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.

3337: * This is the public interface for lock operations on a UI content template in Oracle Configurator
3338: * @param p_api_version number. Current version of the API is 1.0
3339: * @param p_template_id number. Template_id of the template from cz_ui_templates table
3340: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
3341: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
3342: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3343: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
3344: * @param x_msg_count number of messages on the stack.
3345: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack

Line 3342: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.

3338: * @param p_api_version number. Current version of the API is 1.0
3339: * @param p_template_id number. Template_id of the template from cz_ui_templates table
3340: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
3341: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
3342: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3343: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
3344: * @param x_msg_count number of messages on the stack.
3345: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
3346: * @rep:scope public

Line 3343: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )

3339: * @param p_template_id number. Template_id of the template from cz_ui_templates table
3340: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
3341: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
3342: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3343: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
3344: * @param x_msg_count number of messages on the stack.
3345: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
3346: * @rep:scope public
3347: * @rep:product CZ

Line 3374: x_return_status := FND_API.G_RET_STS_SUCCESS;

3370:
3371: BEGIN
3372:
3373: ----initialize FND stack
3374: x_return_status := FND_API.G_RET_STS_SUCCESS;
3375: x_msg_data := NULL;
3376: x_msg_count := 0;
3377:
3378: ----initialize the message stack depending on the input parameter

Line 3379: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

3375: x_msg_data := NULL;
3376: x_msg_count := 0;
3377:
3378: ----initialize the message stack depending on the input parameter
3379: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
3380:
3381: ----check if locking is enabled
3382: ----if the site level profile for locking is not enabled then
3383: ----there is no need to do locking

Line 3398: ELSIF (p_commit_flag = FND_API.G_TRUE) THEN

3394:
3395: -----initialize l_commit_flag
3396: IF (p_commit_flag IS NULL) THEN
3397: l_commit_flag := DO_NOT_COMMIT;
3398: ELSIF (p_commit_flag = FND_API.G_TRUE) THEN
3399: l_commit_flag := DO_COMMIT;
3400: ELSIF (p_commit_flag = FND_API.G_FALSE) THEN
3401: l_commit_flag := DO_NOT_COMMIT;
3402: END IF; /* IF (p_commit_flag IS NULL) */

Line 3400: ELSIF (p_commit_flag = FND_API.G_FALSE) THEN

3396: IF (p_commit_flag IS NULL) THEN
3397: l_commit_flag := DO_NOT_COMMIT;
3398: ELSIF (p_commit_flag = FND_API.G_TRUE) THEN
3399: l_commit_flag := DO_COMMIT;
3400: ELSIF (p_commit_flag = FND_API.G_FALSE) THEN
3401: l_commit_flag := DO_NOT_COMMIT;
3402: END IF; /* IF (p_commit_flag IS NULL) */
3403:
3404: -----set the checkout_user and checkout_time

Line 3424: x_return_status := FND_API.G_RET_STS_ERROR;

3420: NULL;
3421: WHEN TEMPLATEID_IS_NULL THEN
3422: NULL;
3423: WHEN TEMPLATE_IS_LOCKED THEN
3424: x_return_status := FND_API.G_RET_STS_ERROR;
3425: FND_MESSAGE.SET_NAME( 'CZ','CZ_LOCK_TEMPLATE_ERR');
3426: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
3427: FND_MESSAGE.SET_TOKEN('USERNAME' , l_checkout_user);
3428: FND_MSG_PUB.ADD;

Line 3429: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data, p_encoded => FND_API.G_FALSE);

3425: FND_MESSAGE.SET_NAME( 'CZ','CZ_LOCK_TEMPLATE_ERR');
3426: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
3427: FND_MESSAGE.SET_TOKEN('USERNAME' , l_checkout_user);
3428: FND_MSG_PUB.ADD;
3429: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data, p_encoded => FND_API.G_FALSE);
3430: WHEN OTHERS THEN
3431: x_return_status := FND_API.G_RET_STS_ERROR;
3432: x_msg_count := 1;
3433: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);

Line 3431: x_return_status := FND_API.G_RET_STS_ERROR;

3427: FND_MESSAGE.SET_TOKEN('USERNAME' , l_checkout_user);
3428: FND_MSG_PUB.ADD;
3429: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data, p_encoded => FND_API.G_FALSE);
3430: WHEN OTHERS THEN
3431: x_return_status := FND_API.G_RET_STS_ERROR;
3432: x_msg_count := 1;
3433: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);
3434: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');
3435: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_template_name);

Line 3445: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the

3441: /*#
3442: * This is the public interface for lock operations on a UI content template in Oracle Configurator
3443: * @param p_api_version number. Current version of the API is 1.0
3444: * @param p_templates_to_lock array of templates to lock
3445: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
3446: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
3447: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3448: * @param x_locked_templates templates locked by this procedure
3449: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )

Line 3446: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.

3442: * This is the public interface for lock operations on a UI content template in Oracle Configurator
3443: * @param p_api_version number. Current version of the API is 1.0
3444: * @param p_templates_to_lock array of templates to lock
3445: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
3446: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
3447: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3448: * @param x_locked_templates templates locked by this procedure
3449: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
3450: * @param x_msg_count number of messages on the stack.

Line 3447: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.

3443: * @param p_api_version number. Current version of the API is 1.0
3444: * @param p_templates_to_lock array of templates to lock
3445: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
3446: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
3447: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3448: * @param x_locked_templates templates locked by this procedure
3449: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
3450: * @param x_msg_count number of messages on the stack.
3451: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack

Line 3449: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )

3445: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
3446: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
3447: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3448: * @param x_locked_templates templates locked by this procedure
3449: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
3450: * @param x_msg_count number of messages on the stack.
3451: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
3452: * @rep:scope public
3453: * @rep:product CZ

Line 3476: x_return_status := FND_API.G_RET_STS_SUCCESS;

3472: l_return_status VARCHAR2(1);
3473:
3474: BEGIN
3475:
3476: x_return_status := FND_API.G_RET_STS_SUCCESS;
3477:
3478: ----initialize the message stack depending on the input parameter
3479: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
3480:

Line 3479: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

3475:
3476: x_return_status := FND_API.G_RET_STS_SUCCESS;
3477:
3478: ----initialize the message stack depending on the input parameter
3479: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
3480:
3481: -----check if the input parameter p_template_id
3482: -----has a value
3483: IF (p_templates_to_lock.COUNT = 0) THEN

Line 3507: FND_API.G_FALSE,

3503: l_count := x_locked_templates.COUNT + 1;
3504: x_locked_templates(l_count) := p_templates_to_lock(i);
3505: cz_security_pvt.lock_template(1.0,
3506: p_templates_to_lock(i),
3507: FND_API.G_FALSE,
3508: FND_API.G_FALSE,
3509: l_return_status,
3510: x_msg_count,
3511: x_msg_data);

Line 3508: FND_API.G_FALSE,

3504: x_locked_templates(l_count) := p_templates_to_lock(i);
3505: cz_security_pvt.lock_template(1.0,
3506: p_templates_to_lock(i),
3507: FND_API.G_FALSE,
3508: FND_API.G_FALSE,
3509: l_return_status,
3510: x_msg_count,
3511: x_msg_data);
3512: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 3512: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3508: FND_API.G_FALSE,
3509: l_return_status,
3510: x_msg_count,
3511: x_msg_data);
3512: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3513: x_return_status := FND_API.G_RET_STS_ERROR;
3514: END IF;
3515: END IF;
3516: END LOOP;

Line 3513: x_return_status := FND_API.G_RET_STS_ERROR;

3509: l_return_status,
3510: x_msg_count,
3511: x_msg_data);
3512: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3513: x_return_status := FND_API.G_RET_STS_ERROR;
3514: END IF;
3515: END IF;
3516: END LOOP;
3517: END IF;

Line 3518: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data,p_encoded => FND_API.G_FALSE);

3514: END IF;
3515: END IF;
3516: END LOOP;
3517: END IF;
3518: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data,p_encoded => FND_API.G_FALSE);
3519: IF (p_commit_flag = FND_API.G_TRUE) THEN COMMIT; END IF; /* IF (p_commit_flag = '0') */
3520: EXCEPTION
3521: WHEN NO_TEMPLATES_IDS THEN
3522: NULL;

Line 3519: IF (p_commit_flag = FND_API.G_TRUE) THEN COMMIT; END IF; /* IF (p_commit_flag = '0') */

3515: END IF;
3516: END LOOP;
3517: END IF;
3518: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data,p_encoded => FND_API.G_FALSE);
3519: IF (p_commit_flag = FND_API.G_TRUE) THEN COMMIT; END IF; /* IF (p_commit_flag = '0') */
3520: EXCEPTION
3521: WHEN NO_TEMPLATES_IDS THEN
3522: NULL;
3523: WHEN OTHERS THEN

Line 3524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3520: EXCEPTION
3521: WHEN NO_TEMPLATES_IDS THEN
3522: NULL;
3523: WHEN OTHERS THEN
3524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3525: x_return_status := SQLERRM;
3526: x_msg_count := 1;
3527: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3528: END lock_template;

Line 3535: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.

3531: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
3532: /*#
3533: * This is the public interface for unlock operations on a UI content template in Oracle Configurator
3534: * @param p_template_id number. Template_id of the template from cz_ui_templates table
3535: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3536: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
3537: * @param x_msg_count number of messages on the stack.
3538: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
3539: * @rep:scope public

Line 3536: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )

3532: /*#
3533: * This is the public interface for unlock operations on a UI content template in Oracle Configurator
3534: * @param p_template_id number. Template_id of the template from cz_ui_templates table
3535: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3536: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
3537: * @param x_msg_count number of messages on the stack.
3538: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
3539: * @rep:scope public
3540: * @rep:product CZ

Line 3566: x_return_status := FND_API.G_RET_STS_SUCCESS;

3562: l_lock_profile VARCHAR2(3);
3563:
3564: BEGIN
3565: ----initialize FND stack
3566: x_return_status := FND_API.G_RET_STS_SUCCESS;
3567: x_msg_count := 0;
3568: x_msg_data := NULL;
3569: ----initialize the message stack depending on the input parameter
3570: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

Line 3570: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

3566: x_return_status := FND_API.G_RET_STS_SUCCESS;
3567: x_msg_count := 0;
3568: x_msg_data := NULL;
3569: ----initialize the message stack depending on the input parameter
3570: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
3571:
3572: -----check if the input parameter p_template_id
3573: -----has a value
3574: IF (p_template_id IS NULL) THEN

Line 3603: x_return_status := FND_API.G_RET_STS_ERROR;

3599: NULL;
3600: WHEN TEMPLATEID_IS_NULL THEN
3601: NULL;
3602: WHEN TEMPLATE_UNLOCK_ERR THEN
3603: x_return_status := FND_API.G_RET_STS_ERROR;
3604: x_msg_count := 1;
3605: FND_MESSAGE.SET_NAME( 'CZ','CZ_UNLOCK_TMPL_ERR');
3606: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
3607: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);

Line 3611: x_return_status := FND_API.G_RET_STS_ERROR;

3607: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);
3608: FND_MSG_PUB.ADD;
3609: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3610: WHEN OTHERS THEN
3611: x_return_status := FND_API.G_RET_STS_ERROR;
3612: x_msg_count := 1;
3613: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);
3614: x_msg_data := CZ_UTILS.GET_TEXT('CZ_UNLOCK_FATAL_ERR', 'OBJECTNAME', l_template_name, 'SQLERRM', SQLERRM);
3615: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3633: x_return_status := FND_API.G_RET_STS_SUCCESS;

3629: l_return_status VARCHAR2(1);
3630:
3631: BEGIN
3632:
3633: x_return_status := FND_API.G_RET_STS_SUCCESS;
3634: x_msg_count := 0;
3635: ----initialize the message stack depending on the input parameter
3636: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
3637:

Line 3636: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

3632:
3633: x_return_status := FND_API.G_RET_STS_SUCCESS;
3634: x_msg_count := 0;
3635: ----initialize the message stack depending on the input parameter
3636: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
3637:
3638: -----check if the input parameter p_template_id
3639: -----has a value
3640: IF (p_templates_to_unlock.COUNT = 0) THEN

Line 3649: FND_API.G_FALSE,

3645: FOR I IN p_templates_to_unlock.FIRST..p_templates_to_unlock.LAST
3646: LOOP
3647: cz_security_pvt.unlock_template(1.0,
3648: p_templates_to_unlock(i),
3649: FND_API.G_FALSE,
3650: l_return_status,
3651: x_msg_count,
3652: x_msg_data);
3653: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 3653: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3649: FND_API.G_FALSE,
3650: l_return_status,
3651: x_msg_count,
3652: x_msg_data);
3653: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3654: x_return_status := FND_API.G_RET_STS_ERROR;
3655: END IF;
3656: END LOOP;
3657: END IF;

Line 3654: x_return_status := FND_API.G_RET_STS_ERROR;

3650: l_return_status,
3651: x_msg_count,
3652: x_msg_data);
3653: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3654: x_return_status := FND_API.G_RET_STS_ERROR;
3655: END IF;
3656: END LOOP;
3657: END IF;
3658: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

Line 3659: IF (p_commit_flag = FND_API.G_TRUE) THEN COMMIT; END IF; /* IF (p_commit_flag = '0') */

3655: END IF;
3656: END LOOP;
3657: END IF;
3658: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3659: IF (p_commit_flag = FND_API.G_TRUE) THEN COMMIT; END IF; /* IF (p_commit_flag = '0') */
3660: EXCEPTION
3661: WHEN NO_TEMPLATES_IDS THEN
3662: NULL;
3663: WHEN OTHERS THEN

Line 3664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3660: EXCEPTION
3661: WHEN NO_TEMPLATES_IDS THEN
3662: NULL;
3663: WHEN OTHERS THEN
3664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3665: x_return_status := SQLERRM;
3666: x_msg_count := 1;
3667: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3668: END unlock_template;

Line 3674: * @param p_lock_child_models A value of FND_API.G_TRUE indicates that the child models if any should be

3670: ---------------------
3671: /*#
3672: * This is the public interface for lock operations on a model in Oracle Configurator
3673: * @param p_model_id number. devl_project_id of the model from cz_devl_projects table
3674: * @param p_lock_child_models A value of FND_API.G_TRUE indicates that the child models if any should be
3675: * locked. A value of FND_API.G_FALSE indicates that only the root model
3676: * will be locked
3677: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
3678: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.

Line 3675: * locked. A value of FND_API.G_FALSE indicates that only the root model

3671: /*#
3672: * This is the public interface for lock operations on a model in Oracle Configurator
3673: * @param p_model_id number. devl_project_id of the model from cz_devl_projects table
3674: * @param p_lock_child_models A value of FND_API.G_TRUE indicates that the child models if any should be
3675: * locked. A value of FND_API.G_FALSE indicates that only the root model
3676: * will be locked
3677: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
3678: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
3679: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.

Line 3677: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the

3673: * @param p_model_id number. devl_project_id of the model from cz_devl_projects table
3674: * @param p_lock_child_models A value of FND_API.G_TRUE indicates that the child models if any should be
3675: * locked. A value of FND_API.G_FALSE indicates that only the root model
3676: * will be locked
3677: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
3678: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
3679: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3680: * @param x_locked_entities Contains models locked by this procedure call. This when passed as an input parameter
3681: to unlock_model API would ensure that only those models that have been locked by the lock API are unlocked. Models

Line 3678: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.

3674: * @param p_lock_child_models A value of FND_API.G_TRUE indicates that the child models if any should be
3675: * locked. A value of FND_API.G_FALSE indicates that only the root model
3676: * will be locked
3677: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
3678: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
3679: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3680: * @param x_locked_entities Contains models locked by this procedure call. This when passed as an input parameter
3681: to unlock_model API would ensure that only those models that have been locked by the lock API are unlocked. Models
3682: * that were previously locked would not be unlocked (by the same user). The retaining of the lock state

Line 3679: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.

3675: * locked. A value of FND_API.G_FALSE indicates that only the root model
3676: * will be locked
3677: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
3678: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
3679: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3680: * @param x_locked_entities Contains models locked by this procedure call. This when passed as an input parameter
3681: to unlock_model API would ensure that only those models that have been locked by the lock API are unlocked. Models
3682: * that were previously locked would not be unlocked (by the same user). The retaining of the lock state
3683: * is done only during implicit locks and not when an unlock is done from developer.

Line 3684: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )

3680: * @param x_locked_entities Contains models locked by this procedure call. This when passed as an input parameter
3681: to unlock_model API would ensure that only those models that have been locked by the lock API are unlocked. Models
3682: * that were previously locked would not be unlocked (by the same user). The retaining of the lock state
3683: * is done only during implicit locks and not when an unlock is done from developer.
3684: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
3685: * @param x_msg_count number of messages on the stack.
3686: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
3687: * @rep:scope public
3688: * @rep:product CZ

Line 3711: * p_lock_child_models => FND_API.G_TRUE,

3707: *
3708: * Usage
3709: * lock model and its children : cz_security_pvt.lock_model(
3710: * p_model_id => ,
3711: * p_lock_child_models => FND_API.G_TRUE,
3712: * p_commit_flag => FND_API.G_TRUE,
3713: * p_init_msg_list => FND_API.G_TRUE,
3714: * x_prev_locked_entities => l_locked_entities,
3715: * x_return_status => x_return_status,

Line 3712: * p_commit_flag => FND_API.G_TRUE,

3708: * Usage
3709: * lock model and its children : cz_security_pvt.lock_model(
3710: * p_model_id => ,
3711: * p_lock_child_models => FND_API.G_TRUE,
3712: * p_commit_flag => FND_API.G_TRUE,
3713: * p_init_msg_list => FND_API.G_TRUE,
3714: * x_prev_locked_entities => l_locked_entities,
3715: * x_return_status => x_return_status,
3716: * x_msg_count => x_msg_count,

Line 3713: * p_init_msg_list => FND_API.G_TRUE,

3709: * lock model and its children : cz_security_pvt.lock_model(
3710: * p_model_id => ,
3711: * p_lock_child_models => FND_API.G_TRUE,
3712: * p_commit_flag => FND_API.G_TRUE,
3713: * p_init_msg_list => FND_API.G_TRUE,
3714: * x_prev_locked_entities => l_locked_entities,
3715: * x_return_status => x_return_status,
3716: * x_msg_count => x_msg_count,
3717: * x_msg_data => x_msg_data);

Line 3721: * p_lock_child_models => FND_API.G_FALSE,

3717: * x_msg_data => x_msg_data);
3718: *
3719: * lock root model only : cz_security_pvt.lock_model(
3720: * p_model_id => ,
3721: * p_lock_child_models => FND_API.G_FALSE,
3722: * p_commit_flag => FND_API.G_TRUE,
3723: * p_init_msg_list => FND_API.G_TRUE,
3724: * x_locked_entities => l_locked_entities,
3725: * x_return_status => x_return_status,

Line 3722: * p_commit_flag => FND_API.G_TRUE,

3718: *
3719: * lock root model only : cz_security_pvt.lock_model(
3720: * p_model_id => ,
3721: * p_lock_child_models => FND_API.G_FALSE,
3722: * p_commit_flag => FND_API.G_TRUE,
3723: * p_init_msg_list => FND_API.G_TRUE,
3724: * x_locked_entities => l_locked_entities,
3725: * x_return_status => x_return_status,
3726: * x_msg_count => x_msg_count,

Line 3723: * p_init_msg_list => FND_API.G_TRUE,

3719: * lock root model only : cz_security_pvt.lock_model(
3720: * p_model_id => ,
3721: * p_lock_child_models => FND_API.G_FALSE,
3722: * p_commit_flag => FND_API.G_TRUE,
3723: * p_init_msg_list => FND_API.G_TRUE,
3724: * x_locked_entities => l_locked_entities,
3725: * x_return_status => x_return_status,
3726: * x_msg_count => x_msg_count,
3727: * x_msg_data => x_msg_data);

Line 3761: x_return_status := FND_API.G_RET_STS_SUCCESS;

3757: l_seeded_flag cz_rp_entries.seeded_flag%TYPE;
3758:
3759: BEGIN
3760: ----initialize FND stack
3761: x_return_status := FND_API.G_RET_STS_SUCCESS;
3762: x_msg_data := NULL;
3763: x_msg_count := 0;
3764: x_locked_entities.DELETE;
3765:

Line 3767: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

3763: x_msg_count := 0;
3764: x_locked_entities.DELETE;
3765:
3766: ----initialize the message stack depending on the input parameter
3767: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
3768:
3769: ----check if locking is enabled
3770: ----if the site level profile for locking is not enabled then
3771: ----there is no need to do locking

Line 3804: ELSIF (p_commit_flag = FND_API.G_TRUE) THEN

3800:
3801: -----initialize l_commit_flag
3802: IF (p_commit_flag IS NULL) THEN
3803: l_commit_flag := DO_NOT_COMMIT;
3804: ELSIF (p_commit_flag = FND_API.G_TRUE) THEN
3805: l_commit_flag := DO_COMMIT;
3806: ELSIF (p_commit_flag = FND_API.G_FALSE) THEN
3807: l_commit_flag := DO_NOT_COMMIT;
3808: END IF; /* IF (p_commit_flag IS NULL) */

Line 3806: ELSIF (p_commit_flag = FND_API.G_FALSE) THEN

3802: IF (p_commit_flag IS NULL) THEN
3803: l_commit_flag := DO_NOT_COMMIT;
3804: ELSIF (p_commit_flag = FND_API.G_TRUE) THEN
3805: l_commit_flag := DO_COMMIT;
3806: ELSIF (p_commit_flag = FND_API.G_FALSE) THEN
3807: l_commit_flag := DO_NOT_COMMIT;
3808: END IF; /* IF (p_commit_flag IS NULL) */
3809:
3810: IF (p_lock_child_models IS NULL) THEN

Line 3812: ELSIF (p_lock_child_models = FND_API.G_TRUE) THEN

3808: END IF; /* IF (p_commit_flag IS NULL) */
3809:
3810: IF (p_lock_child_models IS NULL) THEN
3811: l_lock_child_models := DO_NOT_LOCK_CHILD_MODELS;
3812: ELSIF (p_lock_child_models = FND_API.G_TRUE) THEN
3813: l_lock_child_models := LOCK_CHILD_MODELS;
3814: ELSIF (p_lock_child_models = FND_API.G_FALSE) THEN
3815: l_lock_child_models := DO_NOT_LOCK_CHILD_MODELS;
3816: END IF; /* IF (p_lock_child_models IS NULL) */

Line 3814: ELSIF (p_lock_child_models = FND_API.G_FALSE) THEN

3810: IF (p_lock_child_models IS NULL) THEN
3811: l_lock_child_models := DO_NOT_LOCK_CHILD_MODELS;
3812: ELSIF (p_lock_child_models = FND_API.G_TRUE) THEN
3813: l_lock_child_models := LOCK_CHILD_MODELS;
3814: ELSIF (p_lock_child_models = FND_API.G_FALSE) THEN
3815: l_lock_child_models := DO_NOT_LOCK_CHILD_MODELS;
3816: END IF; /* IF (p_lock_child_models IS NULL) */
3817:
3818: IF (l_lock_child_models = LOCK_CHILD_MODELS) THEN

Line 3881: x_return_status := FND_API.G_RET_STS_ERROR;

3877: COMMIT;
3878: END IF; /* IF (l_commit_flag = 1) */
3879: EXCEPTION
3880: WHEN INVALID_MODEL_ID THEN
3881: x_return_status := FND_API.G_RET_STS_ERROR;
3882: x_msg_count := 1;
3883: FND_MESSAGE.SET_NAME( 'CZ','CZ_INVALID_MODEL_ID');
3884: FND_MSG_PUB.ADD;
3885: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

Line 3887: x_return_status := FND_API.G_RET_STS_ERROR;

3883: FND_MESSAGE.SET_NAME( 'CZ','CZ_INVALID_MODEL_ID');
3884: FND_MSG_PUB.ADD;
3885: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3886: WHEN LOCK_SINGLE_MODEL_ERR THEN
3887: x_return_status := FND_API.G_RET_STS_ERROR;
3888: x_msg_count := 1;
3889: FND_MESSAGE.SET_NAME( 'CZ','CZ_LOCK_MODEL_ERR');
3890: FND_MESSAGE.SET_TOKEN('MODELNAME', l_model_name);
3891: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);

Line 3899: x_return_status := FND_API.G_RET_STS_ERROR;

3895: NULL;
3896: WHEN MODELID_IS_NULL THEN
3897: NULL;
3898: WHEN MODEL_IS_LOCKED THEN
3899: x_return_status := FND_API.G_RET_STS_ERROR;
3900: add_to_error_stack(p_model_id,l_model_name_tbl,l_checkout_user_tbl);
3901: IF (l_model_name_tbl.COUNT > 0) THEN
3902: FOR I IN l_model_name_tbl.FIRST..l_model_name_tbl.LAST
3903: LOOP

Line 3913: x_return_status := FND_API.G_RET_STS_ERROR;

3909: END LOOP;
3910: END IF;
3911: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3912: WHEN OTHERS THEN
3913: x_return_status := FND_API.G_RET_STS_ERROR;
3914: x_msg_count := 1;
3915: get_checkout_user(p_model_id, 'PRJ', l_checkout_user, l_model_name);
3916: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');
3917: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_model_name);

Line 3926: * @param p_unlock_child_models A value of FND_API.G_TRUE indicates that the child models if any should be

3922: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
3923: /*#
3924: * This is the public interface for unlock operations on a model in Oracle Configurator
3925: * @param p_model_id number. devl_project_id of the model from cz_devl_projects table
3926: * @param p_unlock_child_models A value of FND_API.G_TRUE indicates that the child models if any should be
3927: * unlocked. A value of FND_API.G_FALSE indicates that only the root model
3928: * will be unlocked
3929: * @param p_models_to_unlock would contain an array of model id(s) that have been populated with
3930: * locked models during the execution of the lock model API. The unlock_model API will unlock only the models

Line 3927: * unlocked. A value of FND_API.G_FALSE indicates that only the root model

3923: /*#
3924: * This is the public interface for unlock operations on a model in Oracle Configurator
3925: * @param p_model_id number. devl_project_id of the model from cz_devl_projects table
3926: * @param p_unlock_child_models A value of FND_API.G_TRUE indicates that the child models if any should be
3927: * unlocked. A value of FND_API.G_FALSE indicates that only the root model
3928: * will be unlocked
3929: * @param p_models_to_unlock would contain an array of model id(s) that have been populated with
3930: * locked models during the execution of the lock model API. The unlock_model API will unlock only the models
3931: * in this array .

Line 3932: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.

3928: * will be unlocked
3929: * @param p_models_to_unlock would contain an array of model id(s) that have been populated with
3930: * locked models during the execution of the lock model API. The unlock_model API will unlock only the models
3931: * in this array .
3932: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3933: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
3934: * @param x_msg_count number of messages on the stack.
3935: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
3936: * @rep:scope public

Line 3933: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )

3929: * @param p_models_to_unlock would contain an array of model id(s) that have been populated with
3930: * locked models during the execution of the lock model API. The unlock_model API will unlock only the models
3931: * in this array .
3932: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3933: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
3934: * @param x_msg_count number of messages on the stack.
3935: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
3936: * @rep:scope public
3937: * @rep:product CZ

Line 3947: * p_commit_flag => FND_API.G_TRUE,

3943: * Usage
3944: *
3945: * unlock models in the array
3946: * p_models_to_unlock : cz_security_pvt.unlock_model(
3947: * p_commit_flag => FND_API.G_TRUE,
3948: * p_models_to_unlock => l_locked_entities,
3949: * p_init_msg_list => FND_API.G_TRUE,
3950: * x_return_status => x_return_status,
3951: * x_msg_count => x_msg_count,

Line 3949: * p_init_msg_list => FND_API.G_TRUE,

3945: * unlock models in the array
3946: * p_models_to_unlock : cz_security_pvt.unlock_model(
3947: * p_commit_flag => FND_API.G_TRUE,
3948: * p_models_to_unlock => l_locked_entities,
3949: * p_init_msg_list => FND_API.G_TRUE,
3950: * x_return_status => x_return_status,
3951: * x_msg_count => x_msg_count,
3952: * x_msg_data => x_msg_data);
3953: *

Line 3970: x_return_status := FND_API.G_RET_STS_SUCCESS;

3966: l_msg_data VARCHAR2(2000);
3967:
3968: BEGIN
3969: ----initialize FND stack
3970: x_return_status := FND_API.G_RET_STS_SUCCESS;
3971: IF (p_init_msg_list = FND_API.G_TRUE) THEN
3972: FND_MSG_PUB.initialize;
3973: END IF;
3974:

Line 3971: IF (p_init_msg_list = FND_API.G_TRUE) THEN

3967:
3968: BEGIN
3969: ----initialize FND stack
3970: x_return_status := FND_API.G_RET_STS_SUCCESS;
3971: IF (p_init_msg_list = FND_API.G_TRUE) THEN
3972: FND_MSG_PUB.initialize;
3973: END IF;
3974:
3975: IF (p_models_to_unlock.COUNT > 0) THEN

Line 3978: unlock_model(1.0,p_models_to_unlock(i),FND_API.G_FALSE,FND_API.G_FALSE,

3974:
3975: IF (p_models_to_unlock.COUNT > 0) THEN
3976: FOR I IN p_models_to_unlock.FIRST..p_models_to_unlock.LAST
3977: LOOP
3978: unlock_model(1.0,p_models_to_unlock(i),FND_API.G_FALSE,FND_API.G_FALSE,
3979: l_return_status,l_msg_count,l_msg_data);
3980: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3981: x_return_status := FND_API.G_RET_STS_ERROR;
3982: END IF;

Line 3980: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3976: FOR I IN p_models_to_unlock.FIRST..p_models_to_unlock.LAST
3977: LOOP
3978: unlock_model(1.0,p_models_to_unlock(i),FND_API.G_FALSE,FND_API.G_FALSE,
3979: l_return_status,l_msg_count,l_msg_data);
3980: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3981: x_return_status := FND_API.G_RET_STS_ERROR;
3982: END IF;
3983: END LOOP;
3984: END IF;

Line 3981: x_return_status := FND_API.G_RET_STS_ERROR;

3977: LOOP
3978: unlock_model(1.0,p_models_to_unlock(i),FND_API.G_FALSE,FND_API.G_FALSE,
3979: l_return_status,l_msg_count,l_msg_data);
3980: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3981: x_return_status := FND_API.G_RET_STS_ERROR;
3982: END IF;
3983: END LOOP;
3984: END IF;
3985: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 3985: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3981: x_return_status := FND_API.G_RET_STS_ERROR;
3982: END IF;
3983: END LOOP;
3984: END IF;
3985: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3986: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3987: END IF;
3988: IF (p_commit_flag = FND_API.G_TRUE) THEN
3989: COMMIT;

Line 3988: IF (p_commit_flag = FND_API.G_TRUE) THEN

3984: END IF;
3985: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3986: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
3987: END IF;
3988: IF (p_commit_flag = FND_API.G_TRUE) THEN
3989: COMMIT;
3990: END IF;
3991: END unlock_model;
3992:

Line 4018: x_return_status := FND_API.G_RET_STS_SUCCESS;

4014: l_lock_profile VARCHAR2(3);
4015:
4016: BEGIN
4017: ----initialize FND stack
4018: x_return_status := FND_API.G_RET_STS_SUCCESS;
4019: x_msg_data := NULL;
4020: x_msg_count := 0;
4021:
4022: ----initialize the message stack depending on the input parameter

Line 4023: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

4019: x_msg_data := NULL;
4020: x_msg_count := 0;
4021:
4022: ----initialize the message stack depending on the input parameter
4023: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
4024:
4025: -----check if the input parameter p_model_id
4026: -----has a value
4027: IF (p_model_id IS NULL) THEN

Line 4042: ELSIF (p_commit_flag = FND_API.G_TRUE) THEN

4038:
4039: -----initialize l_commit_flag
4040: IF (p_commit_flag IS NULL) THEN
4041: l_commit_flag := DO_NOT_COMMIT;
4042: ELSIF (p_commit_flag = FND_API.G_TRUE) THEN
4043: l_commit_flag := DO_COMMIT;
4044: ELSIF (p_commit_flag = FND_API.G_FALSE) THEN
4045: l_commit_flag := DO_NOT_COMMIT;
4046: END IF; /* IF (p_commit_flag IS NULL) */

Line 4044: ELSIF (p_commit_flag = FND_API.G_FALSE) THEN

4040: IF (p_commit_flag IS NULL) THEN
4041: l_commit_flag := DO_NOT_COMMIT;
4042: ELSIF (p_commit_flag = FND_API.G_TRUE) THEN
4043: l_commit_flag := DO_COMMIT;
4044: ELSIF (p_commit_flag = FND_API.G_FALSE) THEN
4045: l_commit_flag := DO_NOT_COMMIT;
4046: END IF; /* IF (p_commit_flag IS NULL) */
4047:
4048:

Line 4067: x_return_status := FND_API.G_RET_STS_ERROR;

4063: NULL;
4064: WHEN MODELID_IS_NULL THEN
4065: NULL;
4066: WHEN MODEL_UNLOCK_ERR THEN
4067: x_return_status := FND_API.G_RET_STS_ERROR;
4068: add_to_error_stack(p_model_id,l_model_name_tbl,l_checkout_user_tbl);
4069: IF (l_model_name_tbl.COUNT > 0) THEN
4070: FOR I IN l_model_name_tbl.FIRST..l_model_name_tbl.LAST
4071: LOOP

Line 4081: x_return_status := FND_API.G_RET_STS_ERROR;

4077: END LOOP;
4078: END IF;
4079: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
4080: WHEN OTHERS THEN
4081: x_return_status := FND_API.G_RET_STS_ERROR;
4082: get_checkout_user(p_model_id, 'PRJ', l_checkout_user, l_model_name);
4083: x_msg_data := CZ_UTILS.GET_TEXT('CZ_UNLOCK_FATAL_ERR', 'OBJECTNAME', l_model_name, 'SQLERRM', SQLERRM);
4084: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4085: END unlock_model;

Line 4097: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;

4093: x_msg_count OUT NOCOPY NUMBER,
4094: x_msg_data OUT NOCOPY VARCHAR2)
4095: IS
4096:
4097: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
4098:
4099: BEGIN
4100:
4101: IF(p_init_msg_list = DO_INIT_MSG_LIST)THEN l_init_msg_list := FND_API.G_TRUE; END IF;

Line 4101: IF(p_init_msg_list = DO_INIT_MSG_LIST)THEN l_init_msg_list := FND_API.G_TRUE; END IF;

4097: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
4098:
4099: BEGIN
4100:
4101: IF(p_init_msg_list = DO_INIT_MSG_LIST)THEN l_init_msg_list := FND_API.G_TRUE; END IF;
4102:
4103: lock_template(p_api_version, p_template_id, FND_API.G_FALSE, l_init_msg_list, x_return_status,
4104: x_msg_count, x_msg_data);
4105: END;

Line 4103: lock_template(p_api_version, p_template_id, FND_API.G_FALSE, l_init_msg_list, x_return_status,

4099: BEGIN
4100:
4101: IF(p_init_msg_list = DO_INIT_MSG_LIST)THEN l_init_msg_list := FND_API.G_TRUE; END IF;
4102:
4103: lock_template(p_api_version, p_template_id, FND_API.G_FALSE, l_init_msg_list, x_return_status,
4104: x_msg_count, x_msg_data);
4105: END;
4106:
4107: ----------------

Line 4117: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;

4113: x_msg_count OUT NOCOPY NUMBER,
4114: x_msg_data OUT NOCOPY VARCHAR2)
4115: IS
4116:
4117: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
4118:
4119: BEGIN
4120:
4121: IF(p_init_msg_list = DO_INIT_MSG_LIST)THEN l_init_msg_list := FND_API.G_TRUE; END IF;

Line 4121: IF(p_init_msg_list = DO_INIT_MSG_LIST)THEN l_init_msg_list := FND_API.G_TRUE; END IF;

4117: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
4118:
4119: BEGIN
4120:
4121: IF(p_init_msg_list = DO_INIT_MSG_LIST)THEN l_init_msg_list := FND_API.G_TRUE; END IF;
4122:
4123: IF (p_force_unlock = '0') THEN
4124: unlock_template(p_api_version, p_template_id, l_init_msg_list, x_return_status, x_msg_count, x_msg_data);
4125: ELSE

Line 4144: l_lock_child_models VARCHAR2(1) := FND_API.G_FALSE;

4140: x_msg_data OUT NOCOPY VARCHAR2)
4141: IS
4142:
4143: l_models_locked_tbl number_type_tbl;
4144: l_lock_child_models VARCHAR2(1) := FND_API.G_FALSE;
4145: l_commit_flag VARCHAR2(1) := FND_API.G_FALSE;
4146: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
4147:
4148: BEGIN

Line 4145: l_commit_flag VARCHAR2(1) := FND_API.G_FALSE;

4141: IS
4142:
4143: l_models_locked_tbl number_type_tbl;
4144: l_lock_child_models VARCHAR2(1) := FND_API.G_FALSE;
4145: l_commit_flag VARCHAR2(1) := FND_API.G_FALSE;
4146: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
4147:
4148: BEGIN
4149:

Line 4146: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;

4142:
4143: l_models_locked_tbl number_type_tbl;
4144: l_lock_child_models VARCHAR2(1) := FND_API.G_FALSE;
4145: l_commit_flag VARCHAR2(1) := FND_API.G_FALSE;
4146: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
4147:
4148: BEGIN
4149:
4150: IF(p_lock_child_models = LOCK_CHILD_MODELS)THEN l_lock_child_models := FND_API.G_TRUE; END IF;

Line 4150: IF(p_lock_child_models = LOCK_CHILD_MODELS)THEN l_lock_child_models := FND_API.G_TRUE; END IF;

4146: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
4147:
4148: BEGIN
4149:
4150: IF(p_lock_child_models = LOCK_CHILD_MODELS)THEN l_lock_child_models := FND_API.G_TRUE; END IF;
4151: IF(p_commit_flag = DO_COMMIT)THEN l_commit_flag := FND_API.G_TRUE; END IF;
4152: IF(p_init_msg_list = DO_INIT_MSG_LIST)THEN l_init_msg_list := FND_API.G_TRUE; END IF;
4153:
4154: lock_model(p_api_version, p_model_id, l_lock_child_models, l_commit_flag, l_init_msg_list,

Line 4151: IF(p_commit_flag = DO_COMMIT)THEN l_commit_flag := FND_API.G_TRUE; END IF;

4147:
4148: BEGIN
4149:
4150: IF(p_lock_child_models = LOCK_CHILD_MODELS)THEN l_lock_child_models := FND_API.G_TRUE; END IF;
4151: IF(p_commit_flag = DO_COMMIT)THEN l_commit_flag := FND_API.G_TRUE; END IF;
4152: IF(p_init_msg_list = DO_INIT_MSG_LIST)THEN l_init_msg_list := FND_API.G_TRUE; END IF;
4153:
4154: lock_model(p_api_version, p_model_id, l_lock_child_models, l_commit_flag, l_init_msg_list,
4155: l_models_locked_tbl, x_return_status, x_msg_count, x_msg_data);

Line 4152: IF(p_init_msg_list = DO_INIT_MSG_LIST)THEN l_init_msg_list := FND_API.G_TRUE; END IF;

4148: BEGIN
4149:
4150: IF(p_lock_child_models = LOCK_CHILD_MODELS)THEN l_lock_child_models := FND_API.G_TRUE; END IF;
4151: IF(p_commit_flag = DO_COMMIT)THEN l_commit_flag := FND_API.G_TRUE; END IF;
4152: IF(p_init_msg_list = DO_INIT_MSG_LIST)THEN l_init_msg_list := FND_API.G_TRUE; END IF;
4153:
4154: lock_model(p_api_version, p_model_id, l_lock_child_models, l_commit_flag, l_init_msg_list,
4155: l_models_locked_tbl, x_return_status, x_msg_count, x_msg_data);
4156: END;

Line 4172: lock_model(p_api_version, p_model_id, p_lock_child_models, FND_API.G_TRUE, FND_API.G_FALSE,

4168: x_msg_data OUT NOCOPY VARCHAR2)
4169: IS
4170: BEGIN
4171:
4172: lock_model(p_api_version, p_model_id, p_lock_child_models, FND_API.G_TRUE, FND_API.G_FALSE,
4173: x_locked_entities, x_return_status, x_msg_count, x_msg_data);
4174: END;
4175:
4176: PROCEDURE unlock_model(p_api_version IN NUMBER,

Line 4186: FND_API.G_FALSE, x_return_status,x_msg_count,x_msg_data);

4182: IS
4183: BEGIN
4184:
4185: unlock_model(p_api_version,p_commit_flag,p_models_to_unlock,
4186: FND_API.G_FALSE, x_return_status,x_msg_count,x_msg_data);
4187: END;
4188:
4189: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
4190: ----unlock model for rule import

Line 4201: x_return_status := FND_API.G_RET_STS_SUCCESS;

4197:
4198: BEGIN
4199: ----initialize FND stack
4200: FND_MSG_PUB.initialize;
4201: x_return_status := FND_API.G_RET_STS_SUCCESS;
4202: x_msg_data := NULL;
4203: x_msg_count := 0;
4204:
4205: cz_security_pvt.unlock_model(1.0,p_model_id,FND_API.G_FALSE,FND_API.G_FALSE,

Line 4205: cz_security_pvt.unlock_model(1.0,p_model_id,FND_API.G_FALSE,FND_API.G_FALSE,

4201: x_return_status := FND_API.G_RET_STS_SUCCESS;
4202: x_msg_data := NULL;
4203: x_msg_count := 0;
4204:
4205: cz_security_pvt.unlock_model(1.0,p_model_id,FND_API.G_FALSE,FND_API.G_FALSE,
4206: x_return_status,x_msg_count,x_msg_data);
4207:
4208: END unlock_model;
4209:

Line 4225: x_return_status := FND_API.G_RET_STS_SUCCESS;

4221: l_msg_count NUMBER;
4222: l_msg_data VARCHAR2(2000);
4223: l_return_status VARCHAR2(1);
4224: BEGIN
4225: x_return_status := FND_API.G_RET_STS_SUCCESS;
4226: IF (p_init_msg_list = FND_API.G_TRUE) THEN
4227: FND_MSG_PUB.initialize;
4228: x_msg_data := NULL;
4229: x_msg_count := 0;

Line 4226: IF (p_init_msg_list = FND_API.G_TRUE) THEN

4222: l_msg_data VARCHAR2(2000);
4223: l_return_status VARCHAR2(1);
4224: BEGIN
4225: x_return_status := FND_API.G_RET_STS_SUCCESS;
4226: IF (p_init_msg_list = FND_API.G_TRUE) THEN
4227: FND_MSG_PUB.initialize;
4228: x_msg_data := NULL;
4229: x_msg_count := 0;
4230: END IF;

Line 4237: FND_API.G_FALSE,

4233: FOR I IN p_models_to_unlock.FIRST..p_models_to_unlock.LAST
4234: LOOP
4235: cz_security_pvt.unlock_model(1.0,
4236: p_models_to_unlock(i),
4237: FND_API.G_FALSE,
4238: FND_API.G_FALSE,
4239: l_return_status,
4240: l_msg_count,
4241: l_msg_data);

Line 4238: FND_API.G_FALSE,

4234: LOOP
4235: cz_security_pvt.unlock_model(1.0,
4236: p_models_to_unlock(i),
4237: FND_API.G_FALSE,
4238: FND_API.G_FALSE,
4239: l_return_status,
4240: l_msg_count,
4241: l_msg_data);
4242: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 4242: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4238: FND_API.G_FALSE,
4239: l_return_status,
4240: l_msg_count,
4241: l_msg_data);
4242: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4243: x_return_status := FND_API.G_RET_STS_ERROR;
4244: END IF;
4245: END LOOP;
4246: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 4243: x_return_status := FND_API.G_RET_STS_ERROR;

4239: l_return_status,
4240: l_msg_count,
4241: l_msg_data);
4242: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4243: x_return_status := FND_API.G_RET_STS_ERROR;
4244: END IF;
4245: END LOOP;
4246: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4247: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);

Line 4246: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

4242: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4243: x_return_status := FND_API.G_RET_STS_ERROR;
4244: END IF;
4245: END LOOP;
4246: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4247: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);
4248: END IF;
4249: END IF;
4250: IF (p_commit_flag = FND_API.G_TRUE) THEN COMMIT; END IF;

Line 4247: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);

4243: x_return_status := FND_API.G_RET_STS_ERROR;
4244: END IF;
4245: END LOOP;
4246: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4247: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);
4248: END IF;
4249: END IF;
4250: IF (p_commit_flag = FND_API.G_TRUE) THEN COMMIT; END IF;
4251: EXCEPTION

Line 4250: IF (p_commit_flag = FND_API.G_TRUE) THEN COMMIT; END IF;

4246: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4247: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);
4248: END IF;
4249: END IF;
4250: IF (p_commit_flag = FND_API.G_TRUE) THEN COMMIT; END IF;
4251: EXCEPTION
4252: WHEN OTHERS THEN
4253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4254: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);

Line 4253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4249: END IF;
4250: IF (p_commit_flag = FND_API.G_TRUE) THEN COMMIT; END IF;
4251: EXCEPTION
4252: WHEN OTHERS THEN
4253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4254: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
4255: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);
4256: END;
4257:

Line 4255: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);

4251: EXCEPTION
4252: WHEN OTHERS THEN
4253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4254: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
4255: fnd_msg_pub.count_and_get(FND_API.G_FALSE, x_msg_count, x_msg_data);
4256: END;
4257:
4258: ------------------------------------->>>>>>>>>>>>>>>>
4259: /* bug #10417318

Line 4321: * @param p_lock_child_models A value of FND_API.G_TRUE indicates that the child models if any should be

4317: /*# bug #10417318
4318: * This is the public interface for lock operations on a model in Oracle Configurator for Multiple Publications to Different Targets
4319: * @param p_api_version number. Current version of the API is 1.0
4320: * @param p_model_id number. devl_project_id of the model from cz_devl_projects table
4321: * @param p_lock_child_models A value of FND_API.G_TRUE indicates that the child models if any should be
4322: * locked. A value of FND_API.G_FALSE indicates that only the root model
4323: * will be locked
4324: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
4325: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.

Line 4322: * locked. A value of FND_API.G_FALSE indicates that only the root model

4318: * This is the public interface for lock operations on a model in Oracle Configurator for Multiple Publications to Different Targets
4319: * @param p_api_version number. Current version of the API is 1.0
4320: * @param p_model_id number. devl_project_id of the model from cz_devl_projects table
4321: * @param p_lock_child_models A value of FND_API.G_TRUE indicates that the child models if any should be
4322: * locked. A value of FND_API.G_FALSE indicates that only the root model
4323: * will be locked
4324: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
4325: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
4326: * @param p_server_id number. Server ID of the Target Environment from cz_model_publications table

Line 4324: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the

4320: * @param p_model_id number. devl_project_id of the model from cz_devl_projects table
4321: * @param p_lock_child_models A value of FND_API.G_TRUE indicates that the child models if any should be
4322: * locked. A value of FND_API.G_FALSE indicates that only the root model
4323: * will be locked
4324: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
4325: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
4326: * @param p_server_id number. Server ID of the Target Environment from cz_model_publications table
4327: * @param p_pub_id number. Publication_id from cz_model_publications table
4328: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.

Line 4325: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.

4321: * @param p_lock_child_models A value of FND_API.G_TRUE indicates that the child models if any should be
4322: * locked. A value of FND_API.G_FALSE indicates that only the root model
4323: * will be locked
4324: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
4325: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
4326: * @param p_server_id number. Server ID of the Target Environment from cz_model_publications table
4327: * @param p_pub_id number. Publication_id from cz_model_publications table
4328: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
4329: * @param x_locked_models Contains models locked by this procedure call and models locked by developer.This when passed as an input parameter

Line 4328: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.

4324: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
4325: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
4326: * @param p_server_id number. Server ID of the Target Environment from cz_model_publications table
4327: * @param p_pub_id number. Publication_id from cz_model_publications table
4328: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
4329: * @param x_locked_models Contains models locked by this procedure call and models locked by developer.This when passed as an input parameter
4330: to unlock_pub_model API would ensure that only those models that have been locked by the lock API are unlocked. Models
4331: * that were previously locked would not be unlocked (by the same user). The retaining of the lock state
4332: * is done only during implicit locks and not when an unlock is done from developer.

Line 4333: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )

4329: * @param x_locked_models Contains models locked by this procedure call and models locked by developer.This when passed as an input parameter
4330: to unlock_pub_model API would ensure that only those models that have been locked by the lock API are unlocked. Models
4331: * that were previously locked would not be unlocked (by the same user). The retaining of the lock state
4332: * is done only during implicit locks and not when an unlock is done from developer.
4333: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
4334: * @param x_msg_count number of messages on the stack.
4335: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
4336: * @rep:scope public
4337: * @rep:product CZ

Line 4361: * p_lock_child_models => FND_API.G_TRUE,

4357: * Usage
4358: * lock model and its children : cz_security_pvt.lock_pub_model(
4359: * p_api_version => 1.0,
4360: * p_model_id => ,
4361: * p_lock_child_models => FND_API.G_TRUE,
4362: * p_commit_flag => FND_API.G_TRUE,
4363: * p_init_msg_list => FND_API.G_TRUE,
4364: * p_server_id => ,
4365: * p_pub_id => ,

Line 4362: * p_commit_flag => FND_API.G_TRUE,

4358: * lock model and its children : cz_security_pvt.lock_pub_model(
4359: * p_api_version => 1.0,
4360: * p_model_id => ,
4361: * p_lock_child_models => FND_API.G_TRUE,
4362: * p_commit_flag => FND_API.G_TRUE,
4363: * p_init_msg_list => FND_API.G_TRUE,
4364: * p_server_id => ,
4365: * p_pub_id => ,
4366: * x_prev_locked_entities => l_locked_entities,

Line 4363: * p_init_msg_list => FND_API.G_TRUE,

4359: * p_api_version => 1.0,
4360: * p_model_id => ,
4361: * p_lock_child_models => FND_API.G_TRUE,
4362: * p_commit_flag => FND_API.G_TRUE,
4363: * p_init_msg_list => FND_API.G_TRUE,
4364: * p_server_id => ,
4365: * p_pub_id => ,
4366: * x_prev_locked_entities => l_locked_entities,
4367: * x_return_status => x_return_status,

Line 4404: x_return_status := FND_API.G_RET_STS_SUCCESS;

4400:
4401:
4402: BEGIN
4403: ----initialize FND stack
4404: x_return_status := FND_API.G_RET_STS_SUCCESS;
4405: x_msg_data := NULL;
4406: x_msg_count := 0;
4407: x_locked_models.DELETE;
4408:

Line 4410: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

4406: x_msg_count := 0;
4407: x_locked_models.DELETE;
4408:
4409: ----initialize the message stack depending on the input parameter
4410: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
4411:
4412: ----check if locking is enabled
4413: ----if the site level profile for locking is not enabled then
4414: ----there is no need to do locking

Line 4514: IF (p_commit_flag = FND_API.G_TRUE) THEN

4510: END IF; /*l_count=0*/
4511: END LOOP;
4512: END IF;
4513: END IF;/* IF (l_lock_child_models = LOCK_CHILD_MODELS) */
4514: IF (p_commit_flag = FND_API.G_TRUE) THEN
4515: COMMIT;
4516: END IF;
4517: EXCEPTION
4518: WHEN INVALID_MODEL_ID THEN

Line 4519: x_return_status := FND_API.G_RET_STS_ERROR;

4515: COMMIT;
4516: END IF;
4517: EXCEPTION
4518: WHEN INVALID_MODEL_ID THEN
4519: x_return_status := FND_API.G_RET_STS_ERROR;
4520: x_msg_count := 1;
4521: FND_MESSAGE.SET_NAME( 'CZ','CZ_INVALID_MODEL_ID');
4522: FND_MSG_PUB.ADD;
4523: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

Line 4529: x_return_status := FND_API.G_RET_STS_ERROR;

4525: NULL;
4526: WHEN MODELID_IS_NULL THEN
4527: NULL;
4528: WHEN MODEL_IS_LOCKED THEN
4529: x_return_status := FND_API.G_RET_STS_ERROR;
4530: add_to_error_stack(p_model_id,l_model_name_tbl,l_checkout_user_tbl);
4531: IF (l_model_name_tbl.COUNT > 0) THEN
4532: FOR I IN l_model_name_tbl.FIRST..l_model_name_tbl.LAST
4533: LOOP

Line 4543: x_return_status := FND_API.G_RET_STS_ERROR;

4539: END LOOP;
4540: END IF;
4541: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
4542: WHEN OTHERS THEN
4543: x_return_status := FND_API.G_RET_STS_ERROR;
4544: x_msg_count := 1;
4545: get_checkout_user(p_model_id, 'PRJ', l_checkout_user, l_model_name);
4546: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');
4547: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_model_name);

Line 4557: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the

4553:
4554: /*# bug #10417318
4555: * This is the public interface for unlock operations on a model in Oracle Configurator for Multiple Publication to Different Targets
4556: * @param p_api_version number. Current version of the API is 1.0
4557: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
4558: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
4559: * @param p_models_to_unlock would contain an array of model id(s) that have been populated with
4560: * locked models during the execution of the lock model API. The unlock_model API will unlock only the models
4561: * in this array .

Line 4558: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.

4554: /*# bug #10417318
4555: * This is the public interface for unlock operations on a model in Oracle Configurator for Multiple Publication to Different Targets
4556: * @param p_api_version number. Current version of the API is 1.0
4557: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
4558: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
4559: * @param p_models_to_unlock would contain an array of model id(s) that have been populated with
4560: * locked models during the execution of the lock model API. The unlock_model API will unlock only the models
4561: * in this array .
4562: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.

Line 4562: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.

4558: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
4559: * @param p_models_to_unlock would contain an array of model id(s) that have been populated with
4560: * locked models during the execution of the lock model API. The unlock_model API will unlock only the models
4561: * in this array .
4562: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
4563: * @param p_pub_id number. Publication_id from cz_model_publications table
4564: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
4565: * @param x_msg_count number of messages on the stack.
4566: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack

Line 4564: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )

4560: * locked models during the execution of the lock model API. The unlock_model API will unlock only the models
4561: * in this array .
4562: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
4563: * @param p_pub_id number. Publication_id from cz_model_publications table
4564: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
4565: * @param x_msg_count number of messages on the stack.
4566: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
4567: * @rep:scope public
4568: * @rep:product CZ

Line 4579: * p_commit_flag => FND_API.G_TRUE,

4575: *
4576: * unlock pub models in the array
4577: * p_models_to_unlock : cz_security_pvt.unlock_pub_model(
4578: * p_api_version => 1.0,
4579: * p_commit_flag => FND_API.G_TRUE,
4580: * p_models_to_unlock => l_locked_models,
4581: * p_init_msg_list => FND_API.G_TRUE,
4582: * p_pub_id => ,
4583: * x_return_status => x_return_status,

Line 4581: * p_init_msg_list => FND_API.G_TRUE,

4577: * p_models_to_unlock : cz_security_pvt.unlock_pub_model(
4578: * p_api_version => 1.0,
4579: * p_commit_flag => FND_API.G_TRUE,
4580: * p_models_to_unlock => l_locked_models,
4581: * p_init_msg_list => FND_API.G_TRUE,
4582: * p_pub_id => ,
4583: * x_return_status => x_return_status,
4584: * x_msg_count => x_msg_count,
4585: * x_msg_data => x_msg_data);

Line 4615: x_return_status := FND_API.G_RET_STS_SUCCESS;

4611:
4612:
4613: BEGIN
4614:
4615: x_return_status := FND_API.G_RET_STS_SUCCESS;
4616: x_msg_data := NULL;
4617: x_msg_count := 0;
4618:
4619: BEGIN

Line 4674: x_return_status := FND_API.G_RET_STS_ERROR;

4670: NULL;
4671: WHEN MODELID_IS_NULL THEN
4672: NULL;
4673: WHEN MODEL_UNLOCK_ERR THEN
4674: x_return_status := FND_API.G_RET_STS_ERROR;
4675: add_to_error_stack(p_model_id,l_model_name_tbl,l_checkout_user_tbl);
4676: IF (l_model_name_tbl.COUNT > 0) THEN
4677: FOR I IN l_model_name_tbl.FIRST..l_model_name_tbl.LAST
4678: LOOP

Line 4688: x_return_status := FND_API.G_RET_STS_ERROR;

4684: END LOOP;
4685: END IF;
4686: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
4687: WHEN OTHERS THEN
4688: x_return_status := FND_API.G_RET_STS_ERROR;
4689: get_checkout_user(p_model_id, 'PRJ', l_checkout_user, l_model_name);
4690: x_msg_data := CZ_UTILS.GET_TEXT('CZ_UNLOCK_FATAL_ERR', 'OBJECTNAME', l_model_name, 'SQLERRM', SQLERRM);
4691: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4692: END;

Line 4709: IF (p_commit_flag = FND_API.G_TRUE) THEN

4705: WHEN OTHERS THEN
4706: NULL;
4707: END;
4708:
4709: IF (p_commit_flag = FND_API.G_TRUE) THEN
4710: COMMIT;
4711: END IF;
4712:
4713: END unlock_pub_model;

Line 4720: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the

4716: /*# bug #10417318
4717: * This is the public interface for lock operations on a UI content template in Oracle Configurator for Multiple Publiction to Different targets
4718: * @param p_api_version number. Current version of the API is 1.0
4719: * @param p_templates_to_lock list of templates to lock.
4720: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
4721: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
4722: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
4723: * @param p_server_id number. Server ID of the Target Environment from cz_model_publications table.
4724: * @param p_pub_id number. Publication_id from cz_model_publications table.

Line 4721: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.

4717: * This is the public interface for lock operations on a UI content template in Oracle Configurator for Multiple Publiction to Different targets
4718: * @param p_api_version number. Current version of the API is 1.0
4719: * @param p_templates_to_lock list of templates to lock.
4720: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
4721: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
4722: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
4723: * @param p_server_id number. Server ID of the Target Environment from cz_model_publications table.
4724: * @param p_pub_id number. Publication_id from cz_model_publications table.
4725: * @param x_locked_templates Contains Templates locked by this procedure call and Templates locked by developer. This when passed as an input parameter

Line 4722: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.

4718: * @param p_api_version number. Current version of the API is 1.0
4719: * @param p_templates_to_lock list of templates to lock.
4720: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
4721: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
4722: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
4723: * @param p_server_id number. Server ID of the Target Environment from cz_model_publications table.
4724: * @param p_pub_id number. Publication_id from cz_model_publications table.
4725: * @param x_locked_templates Contains Templates locked by this procedure call and Templates locked by developer. This when passed as an input parameter
4726: * to unlock_pub_template API would ensure that only those models that have been locked by the lock API are unlocked. Templates

Line 4729: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )

4725: * @param x_locked_templates Contains Templates locked by this procedure call and Templates locked by developer. This when passed as an input parameter
4726: * to unlock_pub_template API would ensure that only those models that have been locked by the lock API are unlocked. Templates
4727: * that were previously locked would not be unlocked (by the same user). The retaining of the lock state
4728: * is done only during implicit locks and not when an unlock is done from developer.
4729: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
4730: * @param x_msg_count number of messages on the stack.
4731: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
4732: * @rep:scope public
4733: * @rep:product CZ

Line 4764: x_return_status := FND_API.G_RET_STS_SUCCESS;

4760:
4761:
4762: BEGIN
4763:
4764: x_return_status := FND_API.G_RET_STS_SUCCESS;
4765: x_msg_data := NULL;
4766: x_msg_count := 0;
4767:
4768: ----initialize the message stack depending on the input parameter

Line 4769: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

4765: x_msg_data := NULL;
4766: x_msg_count := 0;
4767:
4768: ----initialize the message stack depending on the input parameter
4769: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
4770:
4771: -----check if the input parameter p_template_id
4772: -----has a value
4773: IF (p_templates_to_lock.COUNT = 0) THEN

Line 4839: x_return_status := FND_API.G_RET_STS_ERROR;

4835:
4836: WHEN TEMPLATEID_IS_NULL THEN
4837: NULL;
4838: WHEN TEMPLATE_IS_LOCKED THEN
4839: x_return_status := FND_API.G_RET_STS_ERROR;
4840: FND_MESSAGE.SET_NAME( 'CZ','CZ_LOCK_TEMPLATE_ERR');
4841: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
4842: FND_MESSAGE.SET_TOKEN('USERNAME' , l_checkout_user);
4843: FND_MSG_PUB.ADD;

Line 4844: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data, p_encoded => FND_API.G_FALSE);

4840: FND_MESSAGE.SET_NAME( 'CZ','CZ_LOCK_TEMPLATE_ERR');
4841: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
4842: FND_MESSAGE.SET_TOKEN('USERNAME' , l_checkout_user);
4843: FND_MSG_PUB.ADD;
4844: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data, p_encoded => FND_API.G_FALSE);
4845: WHEN OTHERS THEN
4846: x_return_status := FND_API.G_RET_STS_ERROR;
4847: x_msg_count := 1;
4848: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);

Line 4846: x_return_status := FND_API.G_RET_STS_ERROR;

4842: FND_MESSAGE.SET_TOKEN('USERNAME' , l_checkout_user);
4843: FND_MSG_PUB.ADD;
4844: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data, p_encoded => FND_API.G_FALSE);
4845: WHEN OTHERS THEN
4846: x_return_status := FND_API.G_RET_STS_ERROR;
4847: x_msg_count := 1;
4848: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);
4849: FND_MESSAGE.SET_NAME('CZ','CZ_LOCK_FATAL_ERR');
4850: FND_MESSAGE.SET_TOKEN('OBJECTNAME', l_template_name);

Line 4855: IF (p_commit_flag = FND_API.G_TRUE) THEN

4851: FND_MESSAGE.SET_TOKEN('SQLERRM', SQLERRM);
4852: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
4853: END;
4854:
4855: IF (p_commit_flag = FND_API.G_TRUE) THEN
4856: COMMIT;
4857: END IF; /* IF (p_commit_flag = '0') */
4858:
4859: EXCEPTION

Line 4865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4861: NULL;
4862: WHEN NO_LOCKING_REQUIRED THEN
4863: NULL;
4864: WHEN OTHERS THEN
4865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4866: x_return_status := SQLERRM;
4867: x_msg_count := 1;
4868: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
4869: END lock_pub_template;

Line 4877: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the

4873: * @param p_api_version number. Current version of the API is 1.0
4874: * @param p_template_to_unlock contains list of all templates which are locked by lock_pub_template API and locked by developer.
4875: * Templates that were previously locked by developer would not be unlocked (by the same user). The retaining of the
4876: * lock state is done only during implicit locks and not when an unlock is done from developer.
4877: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
4878: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
4879: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
4880: * @param p_pub_id number. Publication_id from cz_model_publications table.
4881: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )

Line 4878: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.

4874: * @param p_template_to_unlock contains list of all templates which are locked by lock_pub_template API and locked by developer.
4875: * Templates that were previously locked by developer would not be unlocked (by the same user). The retaining of the
4876: * lock state is done only during implicit locks and not when an unlock is done from developer.
4877: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
4878: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
4879: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
4880: * @param p_pub_id number. Publication_id from cz_model_publications table.
4881: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
4882: * @param x_msg_count number of messages on the stack.

Line 4879: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.

4875: * Templates that were previously locked by developer would not be unlocked (by the same user). The retaining of the
4876: * lock state is done only during implicit locks and not when an unlock is done from developer.
4877: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
4878: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
4879: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
4880: * @param p_pub_id number. Publication_id from cz_model_publications table.
4881: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
4882: * @param x_msg_count number of messages on the stack.
4883: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack

Line 4881: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )

4877: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
4878: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
4879: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
4880: * @param p_pub_id number. Publication_id from cz_model_publications table.
4881: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
4882: * @param x_msg_count number of messages on the stack.
4883: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack
4884: * @rep:scope public
4885: * @rep:product CZ

Line 4914: x_return_status := FND_API.G_RET_STS_SUCCESS;

4910: l_lock_profile VARCHAR2(3);
4911:
4912: BEGIN
4913: ----initialize FND stack
4914: x_return_status := FND_API.G_RET_STS_SUCCESS;
4915: x_msg_count := 0;
4916: x_msg_data := NULL;
4917: ----initialize the message stack depending on the input parameter
4918: BEGIN

Line 4919: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;

4915: x_msg_count := 0;
4916: x_msg_data := NULL;
4917: ----initialize the message stack depending on the input parameter
4918: BEGIN
4919: IF(p_init_msg_list = FND_API.G_TRUE)THEN fnd_msg_pub.initialize; END IF;
4920:
4921: -----check if the input parameter p_template_id
4922: -----has a value
4923: IF (p_templates_to_unlock.COUNT = 0) THEN

Line 4976: x_return_status := FND_API.G_RET_STS_ERROR;

4972: EXCEPTION
4973: WHEN TEMPLATEID_IS_NULL THEN
4974: NULL;
4975: WHEN TEMPLATE_UNLOCK_ERR THEN
4976: x_return_status := FND_API.G_RET_STS_ERROR;
4977: x_msg_count := 1;
4978: FND_MESSAGE.SET_NAME( 'CZ','CZ_UNLOCK_TMPL_ERR');
4979: FND_MESSAGE.SET_TOKEN('TEMPLATENAME', l_template_name);
4980: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);

Line 4984: x_return_status := FND_API.G_RET_STS_ERROR;

4980: FND_MESSAGE.SET_TOKEN('USERNAME', l_checkout_user);
4981: FND_MSG_PUB.ADD;
4982: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
4983: WHEN OTHERS THEN
4984: x_return_status := FND_API.G_RET_STS_ERROR;
4985: x_msg_count := 1;
4986: get_checkout_user(p_template_id, 'UIT', l_checkout_user, l_template_name);
4987: x_msg_data := CZ_UTILS.GET_TEXT('CZ_UNLOCK_FATAL_ERR', 'OBJECTNAME', l_template_name, 'SQLERRM', SQLERRM);
4988: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 4996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4992: NULL;
4993: WHEN NO_LOCKING_REQUIRED THEN
4994: NULL;
4995: WHEN OTHERS THEN
4996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4997: x_return_status := SQLERRM;
4998: x_msg_count := 1;
4999: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
5000: END;

Line 5017: IF (p_commit_flag = FND_API.G_TRUE) THEN

5013: WHEN OTHERS THEN
5014: NULL;
5015: END;
5016:
5017: IF (p_commit_flag = FND_API.G_TRUE) THEN
5018: COMMIT;
5019: END IF;
5020:
5021: END unlock_pub_template;