DBA Data[Home] [Help]

APPS.CZ_DEVELOPER_UTILS_PVT dependencies on FND_GLOBAL

Line 264: l_user_name := FND_GLOBAL.user_name;

260: x_return_status := FND_API.g_ret_sts_success;
261: x_msg_count := 0;
262: x_msg_data := '';
263:
264: l_user_name := FND_GLOBAL.user_name;
265:
266: --check if p_rp_folder_id exists
267: SELECT object_id
268: INTO l_rp_folder

Line 479: l_substr := REPLACE(l_full_path, '\''', FND_GLOBAL.LOCAL_CHR(7) || FND_GLOBAL.LOCAL_CHR(8));

475: p_model_ref_expl_id => p_model_ref_expl_id,
476: p_model_id => p_model_id);
477: END IF;
478:
479: l_substr := REPLACE(l_full_path, '\''', FND_GLOBAL.LOCAL_CHR(7) || FND_GLOBAL.LOCAL_CHR(8));
480: LOOP
481:
482: IF(SUBSTR(l_substr, 1, 1) = '''')THEN
483:

Line 523: RETURN REPLACE(l_path, FND_GLOBAL.LOCAL_CHR(7) || FND_GLOBAL.LOCAL_CHR(8), '\''');

519: FOR i IN l_from + 1..l_to LOOP
520: l_path := l_path || '.' || l_nodes_tbl(i);
521: END LOOP;
522:
523: RETURN REPLACE(l_path, FND_GLOBAL.LOCAL_CHR(7) || FND_GLOBAL.LOCAL_CHR(8), '\''');
524: END get_Path;
525:
526: FUNCTION get_Property(p_property_id IN NUMBER) RETURN VARCHAR2 IS
527: l_property_name CZ_PROPERTIES.NAME%TYPE;

Line 3694: /* l_user_name := FND_GLOBAL.user_name;

3690: WHEN NO_DATA_FOUND THEN
3691: RAISE INVALID_PS_NODE_ID_EXCP;
3692: END;
3693:
3694: /* l_user_name := FND_GLOBAL.user_name;
3695: IF (l_user_name IS NULL) THEN
3696: RAISE USER_IS_NULL_EXCP;
3697: END IF;
3698:

Line 3913: l_user_name := FND_GLOBAL.user_name;

3909: -------------
3910: -- check priv
3911: -------------
3912: /* changes related to bug #3613346
3913: l_user_name := FND_GLOBAL.user_name;
3914: IF (l_user_name IS NULL) THEN
3915: RAISE USER_IS_NULL_EXCP;
3916: END IF;
3917: */

Line 4192: l_user_name := FND_GLOBAL.user_name;

4188: -------------
4189: -- check priv
4190: -------------
4191: /* changes related to bug #3613346
4192: l_user_name := FND_GLOBAL.user_name;
4193: IF (l_user_name IS NULL) THEN
4194: RAISE USER_IS_NULL_EXCP;
4195: END IF;
4196: */

Line 4358: l_user_name := FND_GLOBAL.user_name;

4354: -------------
4355: -- check priv
4356: -------------
4357: /* changes related to bug #3613346
4358: l_user_name := FND_GLOBAL.user_name;
4359: IF (l_user_name IS NULL) THEN
4360: RAISE USER_IS_NULL_EXCP;
4361: END IF;
4362: */

Line 4495: l_user_name := FND_GLOBAL.user_name;

4491: -------------
4492: -- check priv
4493: -------------
4494: /* changes related to bug #3613346
4495: l_user_name := FND_GLOBAL.user_name;
4496: IF (l_user_name IS NULL) THEN
4497: RAISE USER_IS_NULL_EXCP;
4498: END IF;
4499: */

Line 4632: l_user_name := FND_GLOBAL.user_name;

4628:
4629: BEGIN
4630:
4631: FND_MSG_PUB.initialize;
4632: l_user_name := FND_GLOBAL.user_name;
4633: x_return_status := FND_API.G_RET_STS_SUCCESS;
4634:
4635: ------------------------------
4636: -- check for valid p_model_id

Line 5621: l_ampers VARCHAR2(1) := fnd_global.local_chr(38);

5617: l_attrib_count NUMBER := 0;
5618: l_tagname VARCHAR2(255);
5619: attrname VARCHAR2(255);
5620: attrval VARCHAR2(4000);
5621: l_ampers VARCHAR2(1) := fnd_global.local_chr(38);
5622:
5623: BEGIN
5624:
5625: l_attributes := xmldom.getAttributes(p_source_node);

Line 7673: l_user_name := FND_GLOBAL.user_name;

7669: x_return_status := FND_API.g_ret_sts_success;
7670: x_msg_count := 0;
7671: x_msg_data := '';
7672:
7673: l_user_name := FND_GLOBAL.user_name;
7674: ------check if p_rp_folder_id exists
7675: SELECT object_id
7676: INTO l_rp_folder
7677: FROM cz_rp_entries

Line 8635: NewLine CONSTANT VARCHAR2(25) := FND_GLOBAL.NEWLINE;

8631:
8632: CONSTANT_PI CONSTANT VARCHAR2(3) := 'pi';
8633: CONSTANT_E CONSTANT VARCHAR2(3) := 'e';
8634:
8635: NewLine CONSTANT VARCHAR2(25) := FND_GLOBAL.NEWLINE;
8636: StoreNlsCharacters VARCHAR2(16) := NlsNumericCharacters;
8637:
8638: CZ_RT_NO_SUCH_RULE EXCEPTION;
8639: CZ_RT_INCORRECT_DATA EXCEPTION;

Line 8760: v_Name := '''' || REPLACE(c_name.name, '''', '\''') || '''' || FND_GLOBAL.LOCAL_CHR(8) || v_Name;

8756: h_FullName(p_ps_node_id) := 1;
8757: EXIT;
8758: END LOOP;
8759: ELSIF(c_name.parent_id IS NOT NULL)THEN -- This is to exclude the root model name from the path.
8760: v_Name := '''' || REPLACE(c_name.name, '''', '\''') || '''' || FND_GLOBAL.LOCAL_CHR(8) || v_Name;
8761: END IF;
8762: END LOOP;
8763:
8764: h_ModelPath(p_ps_node_id) := v_Name;

Line 8808: v_ModelName := FND_GLOBAL.LOCAL_CHR(7) || '''' || REPLACE(v_ModelName, '''', '\''') || '''';

8804: END IF;
8805:
8806: IF(v_ModelName IS NOT NULL)THEN
8807:
8808: v_ModelName := FND_GLOBAL.LOCAL_CHR(7) || '''' || REPLACE(v_ModelName, '''', '\''') || '''';
8809: END IF;
8810:
8811: IF(v_Name IS NULL)THEN v_Name := generate_model_path(h_ReferringId(v_Node)) || v_ModelName;
8812: ELSE v_Name := generate_model_path(h_ReferringId(v_Node)) || v_ModelName || FND_GLOBAL.LOCAL_CHR(8) || v_Name;

Line 8812: ELSE v_Name := generate_model_path(h_ReferringId(v_Node)) || v_ModelName || FND_GLOBAL.LOCAL_CHR(8) || v_Name;

8808: v_ModelName := FND_GLOBAL.LOCAL_CHR(7) || '''' || REPLACE(v_ModelName, '''', '\''') || '''';
8809: END IF;
8810:
8811: IF(v_Name IS NULL)THEN v_Name := generate_model_path(h_ReferringId(v_Node)) || v_ModelName;
8812: ELSE v_Name := generate_model_path(h_ReferringId(v_Node)) || v_ModelName || FND_GLOBAL.LOCAL_CHR(8) || v_Name;
8813: END IF;
8814: END IF;
8815:
8816: v_Node := h_ParentId(v_Node);

Line 8857: v_subthis := SUBSTR(v_this, INSTR(v_this, FND_GLOBAL.LOCAL_CHR(8), -1, v_level) + 1);

8853: v_level := 1;
8854:
8855: LOOP
8856:
8857: v_subthis := SUBSTR(v_this, INSTR(v_this, FND_GLOBAL.LOCAL_CHR(8), -1, v_level) + 1);
8858: v_subthat := SUBSTR(v_that, INSTR(v_that, FND_GLOBAL.LOCAL_CHR(8), -1, v_level) + 1);
8859:
8860: IF(v_subthis = v_this)THEN EXIT; END IF;
8861: IF(v_subthat = v_that)THEN v_Level := v_Level + 1; EXIT; END IF;

Line 8858: v_subthat := SUBSTR(v_that, INSTR(v_that, FND_GLOBAL.LOCAL_CHR(8), -1, v_level) + 1);

8854:
8855: LOOP
8856:
8857: v_subthis := SUBSTR(v_this, INSTR(v_this, FND_GLOBAL.LOCAL_CHR(8), -1, v_level) + 1);
8858: v_subthat := SUBSTR(v_that, INSTR(v_that, FND_GLOBAL.LOCAL_CHR(8), -1, v_level) + 1);
8859:
8860: IF(v_subthis = v_this)THEN EXIT; END IF;
8861: IF(v_subthat = v_that)THEN v_Level := v_Level + 1; EXIT; END IF;
8862: IF(v_subthis <> v_subthat)THEN EXIT; END IF;

Line 8876: v_name := v_this || FND_GLOBAL.LOCAL_CHR(8) || v_name;

8872:
8873: --Bug #4590481 - in this case we also need to concatenate the path. If the full path is not
8874: --required, the second line will reset it to just the node name.
8875:
8876: v_name := v_this || FND_GLOBAL.LOCAL_CHR(8) || v_name;
8877:
8878: IF(NOT h_FullName.EXISTS(v_ExprPsNodeId(j)))THEN v_name := h_NodeName(v_ExprPsNodeId(j)); END IF;
8879: ELSE v_name := SUBSTR(v_this, INSTR(v_this, FND_GLOBAL.LOCAL_CHR(8), -1, v_depth) + 1) || FND_GLOBAL.LOCAL_CHR(8) || v_name;
8880: END IF;

Line 8879: ELSE v_name := SUBSTR(v_this, INSTR(v_this, FND_GLOBAL.LOCAL_CHR(8), -1, v_depth) + 1) || FND_GLOBAL.LOCAL_CHR(8) || v_name;

8875:
8876: v_name := v_this || FND_GLOBAL.LOCAL_CHR(8) || v_name;
8877:
8878: IF(NOT h_FullName.EXISTS(v_ExprPsNodeId(j)))THEN v_name := h_NodeName(v_ExprPsNodeId(j)); END IF;
8879: ELSE v_name := SUBSTR(v_this, INSTR(v_this, FND_GLOBAL.LOCAL_CHR(8), -1, v_depth) + 1) || FND_GLOBAL.LOCAL_CHR(8) || v_name;
8880: END IF;
8881: END IF;
8882:
8883: v_aux := 1;

Line 8895: WHILE(INSTR(v_name, FND_GLOBAL.LOCAL_CHR(8), 1, v_Level) <> 0)LOOP v_Level := v_Level + 1; END LOOP;

8891: vi_Name(v_Index) := v_name;
8892: vi_Occurrence(v_Index) := v_aux;
8893:
8894: v_Level := 1;
8895: WHILE(INSTR(v_name, FND_GLOBAL.LOCAL_CHR(8), 1, v_Level) <> 0)LOOP v_Level := v_Level + 1; END LOOP;
8896: vi_Depth(v_Index) := v_Level;
8897:
8898: v_name := REPLACE(v_name, '''' || FND_GLOBAL.LOCAL_CHR(7) || '''', '''.''');
8899: v_name := REPLACE(v_name, '''' || FND_GLOBAL.LOCAL_CHR(8) || '''', '''.''');

Line 8898: v_name := REPLACE(v_name, '''' || FND_GLOBAL.LOCAL_CHR(7) || '''', '''.''');

8894: v_Level := 1;
8895: WHILE(INSTR(v_name, FND_GLOBAL.LOCAL_CHR(8), 1, v_Level) <> 0)LOOP v_Level := v_Level + 1; END LOOP;
8896: vi_Depth(v_Index) := v_Level;
8897:
8898: v_name := REPLACE(v_name, '''' || FND_GLOBAL.LOCAL_CHR(7) || '''', '''.''');
8899: v_name := REPLACE(v_name, '''' || FND_GLOBAL.LOCAL_CHR(8) || '''', '''.''');
8900:
8901: RETURN v_name;
8902: END generate_name;

Line 8899: v_name := REPLACE(v_name, '''' || FND_GLOBAL.LOCAL_CHR(8) || '''', '''.''');

8895: WHILE(INSTR(v_name, FND_GLOBAL.LOCAL_CHR(8), 1, v_Level) <> 0)LOOP v_Level := v_Level + 1; END LOOP;
8896: vi_Depth(v_Index) := v_Level;
8897:
8898: v_name := REPLACE(v_name, '''' || FND_GLOBAL.LOCAL_CHR(7) || '''', '''.''');
8899: v_name := REPLACE(v_name, '''' || FND_GLOBAL.LOCAL_CHR(8) || '''', '''.''');
8900:
8901: RETURN v_name;
8902: END generate_name;
8903: ---------------------------------------------------------------------------------------

Line 9127: IF(SUBSTR(v_RuleText, 1, 1) <> FND_GLOBAL.LOCAL_CHR(38))THEN

9123:
9124: nDebug := 1005;
9125:
9126: v_RuleText := v_ExprArgumentName(j);
9127: IF(SUBSTR(v_RuleText, 1, 1) <> FND_GLOBAL.LOCAL_CHR(38))THEN
9128:
9129: v_RuleText := FND_GLOBAL.LOCAL_CHR(38) || v_RuleText;
9130: END IF;
9131:

Line 9129: v_RuleText := FND_GLOBAL.LOCAL_CHR(38) || v_RuleText;

9125:
9126: v_RuleText := v_ExprArgumentName(j);
9127: IF(SUBSTR(v_RuleText, 1, 1) <> FND_GLOBAL.LOCAL_CHR(38))THEN
9128:
9129: v_RuleText := FND_GLOBAL.LOCAL_CHR(38) || v_RuleText;
9130: END IF;
9131:
9132: IF(v_ChildrenIndex.EXISTS(v_ExprId(j)))THEN
9133:

Line 9194: IF(SUBSTR(v_RuleText, 1, 1) <> FND_GLOBAL.LOCAL_CHR(38))THEN

9190: nDebug := 1008;
9191:
9192: IF(isCompatible = 1)THEN v_RuleText := v_ExprArgumentName(j) || ' OF ';
9193: ELSE v_RuleText := v_ExprArgumentName(j) || ' IN {'; END IF;
9194: IF(SUBSTR(v_RuleText, 1, 1) <> FND_GLOBAL.LOCAL_CHR(38))THEN
9195:
9196: v_RuleText := FND_GLOBAL.LOCAL_CHR(38) || v_RuleText;
9197: END IF;
9198:

Line 9196: v_RuleText := FND_GLOBAL.LOCAL_CHR(38) || v_RuleText;

9192: IF(isCompatible = 1)THEN v_RuleText := v_ExprArgumentName(j) || ' OF ';
9193: ELSE v_RuleText := v_ExprArgumentName(j) || ' IN {'; END IF;
9194: IF(SUBSTR(v_RuleText, 1, 1) <> FND_GLOBAL.LOCAL_CHR(38))THEN
9195:
9196: v_RuleText := FND_GLOBAL.LOCAL_CHR(38) || v_RuleText;
9197: END IF;
9198:
9199: IF(v_ChildrenIndex.EXISTS(v_ExprId(j)))THEN
9200:

Line 9620: v_ExprArgumentName(v_index) := FND_GLOBAL.LOCAL_CHR(38) || 'x';

9616: v_ExprDataType(v_index) := NULL;
9617: v_ExprDataValue(v_index) := NULL;
9618: v_ExprDataNumValue(v_index) := NULL;
9619: v_ExprPropertyId(v_index) := NULL;
9620: v_ExprArgumentName(v_index) := FND_GLOBAL.LOCAL_CHR(38) || 'x';
9621: v_ExprParamIndex(v_index) := NULL;
9622:
9623: nLocalExprId := nLocalExprId + 1;
9624: v_ExprId(v_index) := nLocalExprId;

Line 9646: v_ExprArgumentName(v_index) := FND_GLOBAL.LOCAL_CHR(38) || 'x';

9642: v_ExprDataType(v_index) := NULL;
9643: v_ExprDataValue(v_index) := NULL;
9644: v_ExprDataNumValue(v_index) := NULL;
9645: v_ExprPropertyId(v_index) := NULL;
9646: v_ExprArgumentName(v_index) := FND_GLOBAL.LOCAL_CHR(38) || 'x';
9647: v_ExprParamIndex(v_index) := NULL;
9648:
9649: nLocalExprId := nLocalExprId + 1;
9650: v_ExprId(v_index) := nLocalExprId;