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_NETWORK_API_PUB dependencies on CZ_API_PUB

Line 131: PROCEDURE default_pb_parameters(p_appl_param_rec IN OUT NOCOPY CZ_API_PUB.appl_param_rec_type,

127: -------------------------------------------------------------------------
128: -------calling applications default publication parameters to G_MISS_DATE, G_MISS_CHAR etc
129: -------In such cases default the parameter to NULL.
130: ----default pb applicability parameters to NULL if no values are passed in
131: PROCEDURE default_pb_parameters(p_appl_param_rec IN OUT NOCOPY CZ_API_PUB.appl_param_rec_type,
132: x_return_status IN OUT NOCOPY VARCHAR2)
133: IS
134: APPLID_NOT_FOUND EXCEPTION;
135:

Line 192: PROCEDURE delete_configuration(p_config_model_tbl IN cz_api_pub.config_model_tbl_type)

188: END set_error_message;
189:
190: ---------------------------------------------------------------------------
191: ----procedure that deletes the saved configurations
192: PROCEDURE delete_configuration(p_config_model_tbl IN cz_api_pub.config_model_tbl_type)
193: IS
194: PRAGMA AUTONOMOUS_TRANSACTION;
195: l_err_buf VARCHAR2(2000);
196: l_msg_data VARCHAR2(2000);

Line 512: p_appl_params IN CZ_API_PUB.appl_param_rec_type,

508: p_organization_id IN NUMBER,
509: p_config_hdr_id IN NUMBER,
510: p_config_rev_nbr IN NUMBER,
511: p_dummy_header_id IN NUMBER,
512: p_appl_params IN CZ_API_PUB.appl_param_rec_type,
513: p_tree_copy_mode IN VARCHAR2,
514: p_valid_context IN VARCHAR2,
515: x_xml_hdr OUT NOCOPY VARCHAR2 )
516: IS

Line 526: l_save_config_behavior VARCHAR2(30):= CZ_API_PUB.G_NEW_REVISION_COPY_MODE;

522:
523: l_rec_index BINARY_INTEGER;
524:
525: l_database_id VARCHAR2(100);
526: l_save_config_behavior VARCHAR2(30):= CZ_API_PUB.G_NEW_REVISION_COPY_MODE;
527: l_ui_type VARCHAR2(30):= null;
528: l_msg_behavior VARCHAR2(30):= 'brief';
529: l_context_org_id VARCHAR2(80);
530: l_inventory_item_id VARCHAR2(80);

Line 588: IF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN

584:
585: -- config_effective_date should have LONG DATE FORMAT --
586: param_value(9) := to_char(p_appl_params.config_effective_date,'MM-DD-YYYY-HH24-MI-SS');
587:
588: IF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN
589: l_save_config_behavior := 'new_config';
590: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN
591: l_save_config_behavior := 'new_revision';
592: END IF;

Line 590: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN

586: param_value(9) := to_char(p_appl_params.config_effective_date,'MM-DD-YYYY-HH24-MI-SS');
587:
588: IF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN
589: l_save_config_behavior := 'new_config';
590: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN
591: l_save_config_behavior := 'new_revision';
592: END IF;
593:
594: param_value(10) := l_save_config_behavior;

Line 733: p_config_tbl IN CZ_API_PUB.config_tbl_type,

729:
730: --------------------------------------------------------------------------
731: ----procedure that logs trace for network API
732: PROCEDURE trace_gen_config_trees (p_api_version IN NUMBER,
733: p_config_tbl IN CZ_API_PUB.config_tbl_type,
734: p_tree_copy_mode IN VARCHAR2,
735: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
736: p_validation_context IN VARCHAR2,
737: p_config_model_tbl IN OUT NOCOPY CZ_API_PUB.config_model_tbl_type,

Line 735: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,

731: ----procedure that logs trace for network API
732: PROCEDURE trace_gen_config_trees (p_api_version IN NUMBER,
733: p_config_tbl IN CZ_API_PUB.config_tbl_type,
734: p_tree_copy_mode IN VARCHAR2,
735: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
736: p_validation_context IN VARCHAR2,
737: p_config_model_tbl IN OUT NOCOPY CZ_API_PUB.config_model_tbl_type,
738: p_return_status IN OUT NOCOPY VARCHAR2)
739: IS

Line 737: p_config_model_tbl IN OUT NOCOPY CZ_API_PUB.config_model_tbl_type,

733: p_config_tbl IN CZ_API_PUB.config_tbl_type,
734: p_tree_copy_mode IN VARCHAR2,
735: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
736: p_validation_context IN VARCHAR2,
737: p_config_model_tbl IN OUT NOCOPY CZ_API_PUB.config_model_tbl_type,
738: p_return_status IN OUT NOCOPY VARCHAR2)
739: IS
740: PRAGMA AUTONOMOUS_TRANSACTION;
741: TYPE trace_tbl IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;

Line 833: p_instance_tbl IN CZ_API_PUB.config_tbl_type,

829: p_inventory_item_id IN NUMBER,
830: p_organization_id IN NUMBER,
831: p_config_hdr_id IN NUMBER,
832: p_config_rev_nbr IN NUMBER,
833: p_instance_tbl IN CZ_API_PUB.config_tbl_type,
834: p_tree_copy_mode IN VARCHAR2,
835: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
836: p_validation_context IN VARCHAR2,
837: x_config_model_rec IN CZ_API_PUB.config_model_rec_type,

Line 835: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,

831: p_config_hdr_id IN NUMBER,
832: p_config_rev_nbr IN NUMBER,
833: p_instance_tbl IN CZ_API_PUB.config_tbl_type,
834: p_tree_copy_mode IN VARCHAR2,
835: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
836: p_validation_context IN VARCHAR2,
837: x_config_model_rec IN CZ_API_PUB.config_model_rec_type,
838: x_return_status IN VARCHAR2,
839: x_msg_count IN NUMBER,

Line 837: x_config_model_rec IN CZ_API_PUB.config_model_rec_type,

833: p_instance_tbl IN CZ_API_PUB.config_tbl_type,
834: p_tree_copy_mode IN VARCHAR2,
835: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
836: p_validation_context IN VARCHAR2,
837: x_config_model_rec IN CZ_API_PUB.config_model_rec_type,
838: x_return_status IN VARCHAR2,
839: x_msg_count IN NUMBER,
840: x_msg_data IN VARCHAR2)
841: IS

Line 937: --- CZ_API_PUB.INTERACTIVE, CZ_API_PUB.VALIDATE_RETURN

933: --- p_tree_copy_mode IN VARCHAR2 Required
934: --- p_appl_param_rec IN appl_param_rec_type Required
935: --- p_validation_context IN VARCHAR2 Required
936: --- p_validation_type IN VARCHAR2 valid values are :
937: --- CZ_API_PUB.INTERACTIVE, CZ_API_PUB.VALIDATE_RETURN
938: ---OUT : x_return_status OUT NOCOPY VARCHAR2
939: --- x_msg_count OUT NOCOPY NUMBER
940: --- x_msg_data OUT NOCOPY VARCHAR2
941: ---Version: Current version :1.0

Line 945: p_config_tbl IN CZ_API_PUB.config_tbl_type,

941: ---Version: Current version :1.0
942: ---End of comments
943:
944: PROCEDURE generate_config_trees(p_api_version IN NUMBER,
945: p_config_tbl IN CZ_API_PUB.config_tbl_type,
946: p_tree_copy_mode IN VARCHAR2,
947: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
948: p_validation_context IN VARCHAR2,
949: p_validation_type IN VARCHAR2,

Line 947: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,

943:
944: PROCEDURE generate_config_trees(p_api_version IN NUMBER,
945: p_config_tbl IN CZ_API_PUB.config_tbl_type,
946: p_tree_copy_mode IN VARCHAR2,
947: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
948: p_validation_context IN VARCHAR2,
949: p_validation_type IN VARCHAR2,
950: x_config_model_tbl OUT NOCOPY CZ_API_PUB.config_model_tbl_type,
951: x_return_status OUT NOCOPY VARCHAR2,

Line 950: x_config_model_tbl OUT NOCOPY CZ_API_PUB.config_model_tbl_type,

946: p_tree_copy_mode IN VARCHAR2,
947: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
948: p_validation_context IN VARCHAR2,
949: p_validation_type IN VARCHAR2,
950: x_config_model_tbl OUT NOCOPY CZ_API_PUB.config_model_tbl_type,
951: x_return_status OUT NOCOPY VARCHAR2,
952: x_msg_count OUT NOCOPY NUMBER,
953: x_msg_data OUT NOCOPY VARCHAR2
954: )

Line 999: l_orig_item_tbl cz_api_pub.number_tbl_type;

995: validation_status NUMBER;
996: v_parse_status VARCHAR2(1);
997: l_validation_context VARCHAR2(1);
998: l_url VARCHAR2(255);
999: l_orig_item_tbl cz_api_pub.number_tbl_type;
1000: l_new_item_tbl cz_api_pub.number_tbl_type;
1001: l_config_err_msg VARCHAR2(2000);
1002: l_dummy_config_hdr_id NUMBER;
1003:

Line 1000: l_new_item_tbl cz_api_pub.number_tbl_type;

996: v_parse_status VARCHAR2(1);
997: l_validation_context VARCHAR2(1);
998: l_url VARCHAR2(255);
999: l_orig_item_tbl cz_api_pub.number_tbl_type;
1000: l_new_item_tbl cz_api_pub.number_tbl_type;
1001: l_config_err_msg VARCHAR2(2000);
1002: l_dummy_config_hdr_id NUMBER;
1003:
1004: --Sungard ER Bug7673721

Line 1005: l_instance_number_tbl cz_api_pub.number_tbl_type;

1001: l_config_err_msg VARCHAR2(2000);
1002: l_dummy_config_hdr_id NUMBER;
1003:
1004: --Sungard ER Bug7673721
1005: l_instance_number_tbl cz_api_pub.number_tbl_type;
1006: l_value cz_db_settings.value%TYPE;
1007:
1008:
1009: NO_INPUT_RECORDS EXCEPTION;

Line 1028: IF p_validation_type NOT IN(CZ_API_PUB.INTERACTIVE, CZ_API_PUB.VALIDATE_RETURN) THEN

1024: NO_VALIDATION_CONTEXT EXCEPTION;
1025:
1026: BEGIN
1027:
1028: IF p_validation_type NOT IN(CZ_API_PUB.INTERACTIVE, CZ_API_PUB.VALIDATE_RETURN) THEN
1029: RAISE INVALID_VALIDATION_TYPE;
1030: END IF;
1031:
1032: l_orig_item_tbl := cz_api_pub.NUMBER_TBL_TYPE();

Line 1032: l_orig_item_tbl := cz_api_pub.NUMBER_TBL_TYPE();

1028: IF p_validation_type NOT IN(CZ_API_PUB.INTERACTIVE, CZ_API_PUB.VALIDATE_RETURN) THEN
1029: RAISE INVALID_VALIDATION_TYPE;
1030: END IF;
1031:
1032: l_orig_item_tbl := cz_api_pub.NUMBER_TBL_TYPE();
1033: l_new_item_tbl := cz_api_pub.NUMBER_TBL_TYPE();
1034:
1035: ----initialize return status to success
1036: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1033: l_new_item_tbl := cz_api_pub.NUMBER_TBL_TYPE();

1029: RAISE INVALID_VALIDATION_TYPE;
1030: END IF;
1031:
1032: l_orig_item_tbl := cz_api_pub.NUMBER_TBL_TYPE();
1033: l_new_item_tbl := cz_api_pub.NUMBER_TBL_TYPE();
1034:
1035: ----initialize return status to success
1036: x_return_status := FND_API.G_RET_STS_SUCCESS;
1037: fnd_msg_pub.initialize;

Line 1052: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN

1048:
1049: ---verify that the input parameters are not null
1050: IF ( (p_tree_copy_mode IS NULL) OR (p_tree_copy_mode = FND_API.G_MISS_CHAR)) THEN
1051: RAISE INPUT_TREE_MODE_NULL;
1052: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN
1053: new_config_flag := '0';
1054: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN
1055: new_config_flag := '1';
1056: ELSE

Line 1054: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN

1050: IF ( (p_tree_copy_mode IS NULL) OR (p_tree_copy_mode = FND_API.G_MISS_CHAR)) THEN
1051: RAISE INPUT_TREE_MODE_NULL;
1052: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN
1053: new_config_flag := '0';
1054: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN
1055: new_config_flag := '1';
1056: ELSE
1057: RAISE INVALID_TREE_MODE_ERR;
1058: END IF;

Line 1063: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN

1059:
1060: ----verify validation context
1061: IF (p_validation_context IS NULL) THEN
1062: l_validation_context := NULL;
1063: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN
1064: l_validation_context := CZ_API_PUB.G_INSTALLED;
1065: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN
1066: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;
1067: ELSE

Line 1064: l_validation_context := CZ_API_PUB.G_INSTALLED;

1060: ----verify validation context
1061: IF (p_validation_context IS NULL) THEN
1062: l_validation_context := NULL;
1063: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN
1064: l_validation_context := CZ_API_PUB.G_INSTALLED;
1065: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN
1066: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;
1067: ELSE
1068: RAISE INVALID_CONTEXT;

Line 1065: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN

1061: IF (p_validation_context IS NULL) THEN
1062: l_validation_context := NULL;
1063: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN
1064: l_validation_context := CZ_API_PUB.G_INSTALLED;
1065: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN
1066: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;
1067: ELSE
1068: RAISE INVALID_CONTEXT;
1069: END IF;

Line 1066: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;

1062: l_validation_context := NULL;
1063: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN
1064: l_validation_context := CZ_API_PUB.G_INSTALLED;
1065: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN
1066: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;
1067: ELSE
1068: RAISE INVALID_CONTEXT;
1069: END IF;
1070:

Line 1116: CZ_API_PUB.G_NEW_HEADER_COPY_MODE,

1112:
1113: CZ_CONFIG_API_PVT.copy_configuration(1.0,
1114: l_main_config_hdr_id,
1115: l_main_config_rev_nbr,
1116: CZ_API_PUB.G_NEW_HEADER_COPY_MODE,
1117: v_config_hdr_id,
1118: v_config_rev_nbr,
1119: l_orig_item_tbl,
1120: l_new_item_tbl,

Line 1340: IF p_validation_type<>CZ_API_PUB.VALIDATE_RETURN AND

1336: ------get top inv item and org id
1337: get_root_bom_config_item(v_output_cfg_hdr_id,v_output_cfg_rev_nbr,l_inventory_item_id,l_organization_id,l_config_item_id);
1338:
1339: -----if no inv item id or org id is retrieved raise exception
1340: IF p_validation_type<>CZ_API_PUB.VALIDATE_RETURN AND
1341: ( l_inventory_item_id = -1 OR l_organization_id = -1 ) THEN
1342: RAISE INVALID_OUT_INV_ORG_ID;
1343: END IF;
1344:

Line 1426: IF x_config_model_tbl.COUNT>0 AND p_validation_type<>CZ_API_PUB.VALIDATE_RETURN THEN

1422: WHEN INVALID_OUT_INV_ORG_ID THEN
1423: l_errbuf := CZ_UTILS.GET_TEXT('CZ_NET_API_NO_INV_FOR_CFG_HDR','HDR',v_output_cfg_hdr_id,'REV',v_output_cfg_rev_nbr);
1424: set_fnd_message('CZ_NET_API_NO_INV_FOR_CFG_HDR','HDR',v_output_cfg_hdr_id,'REV',v_output_cfg_rev_nbr);
1425: set_error_message(x_return_status,x_msg_count,x_msg_data,l_errbuf);
1426: IF x_config_model_tbl.COUNT>0 AND p_validation_type<>CZ_API_PUB.VALIDATE_RETURN THEN
1427: delete_configuration(x_config_model_tbl);
1428: x_config_model_tbl.DELETE;
1429: END IF;
1430: COMMIT;

Line 1504: p_config_tbl IN CZ_API_PUB.config_tbl_type,

1500: ---Version: Current version :1.0
1501: ---End of comments
1502:
1503: PROCEDURE generate_config_trees(p_api_version IN NUMBER,
1504: p_config_tbl IN CZ_API_PUB.config_tbl_type,
1505: p_tree_copy_mode IN VARCHAR2,
1506: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
1507: p_validation_context IN VARCHAR2,
1508: x_config_model_tbl OUT NOCOPY CZ_API_PUB.config_model_tbl_type,

Line 1506: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,

1502:
1503: PROCEDURE generate_config_trees(p_api_version IN NUMBER,
1504: p_config_tbl IN CZ_API_PUB.config_tbl_type,
1505: p_tree_copy_mode IN VARCHAR2,
1506: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
1507: p_validation_context IN VARCHAR2,
1508: x_config_model_tbl OUT NOCOPY CZ_API_PUB.config_model_tbl_type,
1509: x_return_status OUT NOCOPY VARCHAR2,
1510: x_msg_count OUT NOCOPY NUMBER,

Line 1508: x_config_model_tbl OUT NOCOPY CZ_API_PUB.config_model_tbl_type,

1504: p_config_tbl IN CZ_API_PUB.config_tbl_type,
1505: p_tree_copy_mode IN VARCHAR2,
1506: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
1507: p_validation_context IN VARCHAR2,
1508: x_config_model_tbl OUT NOCOPY CZ_API_PUB.config_model_tbl_type,
1509: x_return_status OUT NOCOPY VARCHAR2,
1510: x_msg_count OUT NOCOPY NUMBER,
1511: x_msg_data OUT NOCOPY VARCHAR2
1512: )

Line 1521: p_validation_type => CZ_API_PUB.INTERACTIVE,

1517: p_config_tbl => p_config_tbl,
1518: p_tree_copy_mode => p_tree_copy_mode,
1519: p_appl_param_rec => p_appl_param_rec,
1520: p_validation_context => p_validation_context,
1521: p_validation_type => CZ_API_PUB.INTERACTIVE,
1522: x_config_model_tbl => x_config_model_tbl,
1523: x_return_status => x_return_status,
1524: x_msg_count => x_msg_count,
1525: x_msg_data => x_msg_data

Line 1537: p_instance_tbl IN CZ_API_PUB.config_tbl_type,

1533: p_inventory_item_id IN NUMBER,
1534: p_organization_id IN NUMBER,
1535: p_config_hdr_id IN NUMBER,
1536: p_config_rev_nbr IN NUMBER,
1537: p_instance_tbl IN CZ_API_PUB.config_tbl_type,
1538: p_tree_copy_mode IN VARCHAR2,
1539: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
1540: p_validation_context IN VARCHAR2,
1541: x_config_model_rec OUT NOCOPY CZ_API_PUB.config_model_rec_type,

Line 1539: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,

1535: p_config_hdr_id IN NUMBER,
1536: p_config_rev_nbr IN NUMBER,
1537: p_instance_tbl IN CZ_API_PUB.config_tbl_type,
1538: p_tree_copy_mode IN VARCHAR2,
1539: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
1540: p_validation_context IN VARCHAR2,
1541: x_config_model_rec OUT NOCOPY CZ_API_PUB.config_model_rec_type,
1542: x_return_status OUT NOCOPY VARCHAR2,
1543: x_msg_count OUT NOCOPY NUMBER,

Line 1541: x_config_model_rec OUT NOCOPY CZ_API_PUB.config_model_rec_type,

1537: p_instance_tbl IN CZ_API_PUB.config_tbl_type,
1538: p_tree_copy_mode IN VARCHAR2,
1539: p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type,
1540: p_validation_context IN VARCHAR2,
1541: x_config_model_rec OUT NOCOPY CZ_API_PUB.config_model_rec_type,
1542: x_return_status OUT NOCOPY VARCHAR2,
1543: x_msg_count OUT NOCOPY NUMBER,
1544: x_msg_data OUT NOCOPY VARCHAR2)
1545: IS

Line 1561: l_config_model_tbl CZ_API_PUB.config_model_tbl_type;

1557:
1558: l_main_config_hdr_id cz_config_hdrs.config_hdr_id%TYPE;
1559: l_main_config_rev_nbr cz_config_hdrs.config_rev_nbr%TYPE;
1560:
1561: l_config_model_tbl CZ_API_PUB.config_model_tbl_type;
1562: l_con_config_tbl container_config_tbl_type;
1563:
1564: l_model_instantiation_type VARCHAR2(1);
1565: l_component_instance_type VARCHAR2(1);

Line 1630: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN

1626:
1627: ---verify that the input parameters are not null
1628: IF ( (p_tree_copy_mode IS NULL) OR (p_tree_copy_mode = FND_API.G_MISS_CHAR)) THEN
1629: RAISE INPUT_TREE_MODE_NULL;
1630: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN
1631: new_config_flag := '0';
1632: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN
1633: new_config_flag := '1';
1634: ELSE

Line 1632: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN

1628: IF ( (p_tree_copy_mode IS NULL) OR (p_tree_copy_mode = FND_API.G_MISS_CHAR)) THEN
1629: RAISE INPUT_TREE_MODE_NULL;
1630: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_HEADER_COPY_MODE) THEN
1631: new_config_flag := '0';
1632: ELSIF (p_tree_copy_mode = CZ_API_PUB.G_NEW_REVISION_COPY_MODE) THEN
1633: new_config_flag := '1';
1634: ELSE
1635: RAISE INVALID_TREE_MODE_ERR;
1636: END IF;

Line 1641: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN

1637:
1638: ----verify validation context
1639: IF (p_validation_context IS NULL) THEN
1640: l_validation_context := NULL;
1641: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN
1642: l_validation_context := CZ_API_PUB.G_INSTALLED;
1643: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN
1644: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;
1645: ELSE

Line 1642: l_validation_context := CZ_API_PUB.G_INSTALLED;

1638: ----verify validation context
1639: IF (p_validation_context IS NULL) THEN
1640: l_validation_context := NULL;
1641: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN
1642: l_validation_context := CZ_API_PUB.G_INSTALLED;
1643: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN
1644: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;
1645: ELSE
1646: RAISE INVALID_CONTEXT;

Line 1643: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN

1639: IF (p_validation_context IS NULL) THEN
1640: l_validation_context := NULL;
1641: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN
1642: l_validation_context := CZ_API_PUB.G_INSTALLED;
1643: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN
1644: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;
1645: ELSE
1646: RAISE INVALID_CONTEXT;
1647: END IF;

Line 1644: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;

1640: l_validation_context := NULL;
1641: ELSIF (p_validation_context = CZ_API_PUB.G_INSTALLED) THEN
1642: l_validation_context := CZ_API_PUB.G_INSTALLED;
1643: ELSIF (p_validation_context = CZ_API_PUB.G_PENDING_OR_INSTALLED) THEN
1644: l_validation_context := CZ_API_PUB.G_PENDING_OR_INSTALLED;
1645: ELSE
1646: RAISE INVALID_CONTEXT;
1647: END IF;
1648:

Line 1719: cz_cf_api.validate(config_input_list,l_xml_hdr,config_messages,validation_status,l_url,CZ_API_PUB.INTERACTIVE);

1715:
1716: config_input_list.DELETE;
1717: l_url := FND_PROFILE.VALUE('CZ_UIMGR_URL');
1718: config_messages.DELETE;
1719: cz_cf_api.validate(config_input_list,l_xml_hdr,config_messages,validation_status,l_url,CZ_API_PUB.INTERACTIVE);
1720:
1721: EXCEPTION
1722: WHEN OTHERS THEN
1723: delete_dummy_config ( l_dummy_config_hdr_id );

Line 1916: ,p_inventory_item_id_tbl IN OUT NOCOPY CZ_API_PUB.number_tbl_type

1912: -- Function: Retrieves all trackable and instantiable child models for a
1913: -- given network container model.
1914:
1915: procedure get_contained_models_pvt(p_model_id IN NUMBER
1916: ,p_inventory_item_id_tbl IN OUT NOCOPY CZ_API_PUB.number_tbl_type
1917: )
1918: IS
1919: l_model_id NUMBER := p_model_id;
1920: l_reference_id NUMBER;

Line 1980: ,p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type

1976:
1977: procedure get_contained_models(p_api_version IN NUMBER
1978: ,p_inventory_item_id IN NUMBER
1979: ,p_organization_id IN NUMBER
1980: ,p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type
1981: ,x_model_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
1982: ,x_return_status OUT NOCOPY VARCHAR2
1983: ,x_msg_count OUT NOCOPY NUMBER
1984: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1981: ,x_model_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type

1977: procedure get_contained_models(p_api_version IN NUMBER
1978: ,p_inventory_item_id IN NUMBER
1979: ,p_organization_id IN NUMBER
1980: ,p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type
1981: ,x_model_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type
1982: ,x_return_status OUT NOCOPY VARCHAR2
1983: ,x_msg_count OUT NOCOPY NUMBER
1984: ,x_msg_data OUT NOCOPY VARCHAR2
1985: )

Line 1995: l_inventory_item_id_tbl CZ_API_PUB.number_tbl_type := cz_api_pub.NUMBER_TBL_TYPE();

1991: l_config_model_lookup_date DATE := p_appl_param_rec.config_model_lookup_date;
1992: l_config_effective_date DATE := p_appl_param_rec.config_effective_date;
1993:
1994: l_model_id NUMBER;
1995: l_inventory_item_id_tbl CZ_API_PUB.number_tbl_type := cz_api_pub.NUMBER_TBL_TYPE();
1996: l_msg_data VARCHAR2(2000);
1997: l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
1998:
1999: BEGIN

Line 1997: l_appl_param_rec CZ_API_PUB.appl_param_rec_type;

1993:
1994: l_model_id NUMBER;
1995: l_inventory_item_id_tbl CZ_API_PUB.number_tbl_type := cz_api_pub.NUMBER_TBL_TYPE();
1996: l_msg_data VARCHAR2(2000);
1997: l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
1998:
1999: BEGIN
2000: x_return_status := FND_API.G_RET_STS_SUCCESS;
2001: fnd_msg_pub.initialize;

Line 2002: x_model_tbl := cz_api_pub.NUMBER_TBL_TYPE();

1998:
1999: BEGIN
2000: x_return_status := FND_API.G_RET_STS_SUCCESS;
2001: fnd_msg_pub.initialize;
2002: x_model_tbl := cz_api_pub.NUMBER_TBL_TYPE();
2003: -- standard call to check for call compatibility
2004: IF (NOT FND_API.compatible_api_call(l_api_version
2005: ,p_api_version
2006: ,l_api_name

Line 2097: ,p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type

2093:
2094: procedure is_container(p_api_version IN NUMBER
2095: ,p_inventory_item_id IN NUMBER
2096: ,p_organization_id IN NUMBER
2097: ,p_appl_param_rec IN CZ_API_PUB.appl_param_rec_type
2098: ,x_return_value OUT NOCOPY VARCHAR2
2099: ,x_return_status OUT NOCOPY VARCHAR2
2100: ,x_msg_count OUT NOCOPY NUMBER
2101: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2354: x_child_config_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type)

2350: -----that has been passed in (for a config hdr and config rev)
2351: PROCEDURE get_child_items(p_config_hdr_id IN NUMBER,
2352: p_config_rev_nbr IN NUMBER,
2353: p_config_item_id IN NUMBER,
2354: x_child_config_tbl OUT NOCOPY CZ_API_PUB.number_tbl_type)
2355:
2356: IS
2357:
2358: BEGIN

Line 2397: v_child_config_tbl CZ_API_PUB.number_tbl_type;

2393: l_api_version CONSTANT NUMBER := 1.0;
2394: l_api_name VARCHAR2(30) := 'ext_deactivate_item';
2395: l_ext_activated_flag VARCHAR2(1);
2396: l_root_inst_changed BOOLEAN;
2397: v_child_config_tbl CZ_API_PUB.number_tbl_type;
2398: l_run_id NUMBER;
2399: l_config_item_id NUMBER;
2400: REMOVE_IB_ERR EXCEPTION;
2401:

Line 2502: p_validation_type IN VARCHAR2 DEFAULT CZ_API_PUB.VALIDATE_ORDER

2498: init_message IN VARCHAR2, -- additional XML
2499: config_messages IN OUT NOCOPY CZ_CF_API.CFG_OUTPUT_PIECES, -- table of output XML messages
2500: validation_status IN OUT NOCOPY NUMBER, -- status return
2501: URL IN VARCHAR2 DEFAULT FND_PROFILE.Value('CZ_UIMGR_URL'),
2502: p_validation_type IN VARCHAR2 DEFAULT CZ_API_PUB.VALIDATE_ORDER
2503: )
2504:
2505: IS
2506: