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 476: l_substr := REPLACE(l_full_path, '\''', FND_GLOBAL.LOCAL_CHR(7) || FND_GLOBAL.LOCAL_CHR(8));

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

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

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

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

3662: WHEN NO_DATA_FOUND THEN
3663: RAISE INVALID_PS_NODE_ID_EXCP;
3664: END;
3665:
3666: /* l_user_name := FND_GLOBAL.user_name;
3667: IF (l_user_name IS NULL) THEN
3668: RAISE USER_IS_NULL_EXCP;
3669: END IF;
3670:

Line 3885: l_user_name := FND_GLOBAL.user_name;

3881: -------------
3882: -- check priv
3883: -------------
3884: /* changes related to bug #3613346
3885: l_user_name := FND_GLOBAL.user_name;
3886: IF (l_user_name IS NULL) THEN
3887: RAISE USER_IS_NULL_EXCP;
3888: END IF;
3889: */

Line 4164: l_user_name := FND_GLOBAL.user_name;

4160: -------------
4161: -- check priv
4162: -------------
4163: /* changes related to bug #3613346
4164: l_user_name := FND_GLOBAL.user_name;
4165: IF (l_user_name IS NULL) THEN
4166: RAISE USER_IS_NULL_EXCP;
4167: END IF;
4168: */

Line 4330: l_user_name := FND_GLOBAL.user_name;

4326: -------------
4327: -- check priv
4328: -------------
4329: /* changes related to bug #3613346
4330: l_user_name := FND_GLOBAL.user_name;
4331: IF (l_user_name IS NULL) THEN
4332: RAISE USER_IS_NULL_EXCP;
4333: END IF;
4334: */

Line 4467: l_user_name := FND_GLOBAL.user_name;

4463: -------------
4464: -- check priv
4465: -------------
4466: /* changes related to bug #3613346
4467: l_user_name := FND_GLOBAL.user_name;
4468: IF (l_user_name IS NULL) THEN
4469: RAISE USER_IS_NULL_EXCP;
4470: END IF;
4471: */

Line 4604: l_user_name := FND_GLOBAL.user_name;

4600:
4601: BEGIN
4602:
4603: FND_MSG_PUB.initialize;
4604: l_user_name := FND_GLOBAL.user_name;
4605: x_return_status := FND_API.G_RET_STS_SUCCESS;
4606:
4607: ------------------------------
4608: -- check for valid p_model_id

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

5588: l_attrib_count NUMBER := 0;
5589: l_tagname VARCHAR2(255);
5590: attrname VARCHAR2(255);
5591: attrval VARCHAR2(4000);
5592: l_ampers VARCHAR2(1) := fnd_global.local_chr(38);
5593:
5594: BEGIN
5595:
5596: l_attributes := xmldom.getAttributes(p_source_node);

Line 7615: l_user_name := FND_GLOBAL.user_name;

7611: x_return_status := FND_API.g_ret_sts_success;
7612: x_msg_count := 0;
7613: x_msg_data := '';
7614:
7615: l_user_name := FND_GLOBAL.user_name;
7616: ------check if p_rp_folder_id exists
7617: SELECT object_id
7618: INTO l_rp_folder
7619: FROM cz_rp_entries

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

8580:
8581: CONSTANT_PI CONSTANT VARCHAR2(3) := 'pi';
8582: CONSTANT_E CONSTANT VARCHAR2(3) := 'e';
8583:
8584: NewLine CONSTANT VARCHAR2(25) := FND_GLOBAL.NEWLINE;
8585: StoreNlsCharacters VARCHAR2(16) := NlsNumericCharacters;
8586:
8587: CZ_RT_NO_SUCH_RULE EXCEPTION;
8588: CZ_RT_INCORRECT_DATA EXCEPTION;

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

8705: h_FullName(p_ps_node_id) := 1;
8706: EXIT;
8707: END LOOP;
8708: ELSIF(c_name.parent_id IS NOT NULL)THEN -- This is to exclude the root model name from the path.
8709: v_Name := '''' || REPLACE(c_name.name, '''', '\''') || '''' || FND_GLOBAL.LOCAL_CHR(8) || v_Name;
8710: END IF;
8711: END LOOP;
8712:
8713: h_ModelPath(p_ps_node_id) := v_Name;

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

8753: END IF;
8754:
8755: IF(v_ModelName IS NOT NULL)THEN
8756:
8757: v_ModelName := FND_GLOBAL.LOCAL_CHR(7) || '''' || REPLACE(v_ModelName, '''', '\''') || '''';
8758: END IF;
8759:
8760: IF(v_Name IS NULL)THEN v_Name := generate_model_path(h_ReferringId(v_Node)) || v_ModelName;
8761: ELSE v_Name := generate_model_path(h_ReferringId(v_Node)) || v_ModelName || FND_GLOBAL.LOCAL_CHR(8) || v_Name;

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

8757: v_ModelName := FND_GLOBAL.LOCAL_CHR(7) || '''' || REPLACE(v_ModelName, '''', '\''') || '''';
8758: END IF;
8759:
8760: IF(v_Name IS NULL)THEN v_Name := generate_model_path(h_ReferringId(v_Node)) || v_ModelName;
8761: ELSE v_Name := generate_model_path(h_ReferringId(v_Node)) || v_ModelName || FND_GLOBAL.LOCAL_CHR(8) || v_Name;
8762: END IF;
8763: END IF;
8764:
8765: v_Node := h_ParentId(v_Node);

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

8802: v_level := 1;
8803:
8804: LOOP
8805:
8806: v_subthis := SUBSTR(v_this, INSTR(v_this, FND_GLOBAL.LOCAL_CHR(8), -1, v_level) + 1);
8807: v_subthat := SUBSTR(v_that, INSTR(v_that, FND_GLOBAL.LOCAL_CHR(8), -1, v_level) + 1);
8808:
8809: IF(v_subthis = v_this)THEN EXIT; END IF;
8810: IF(v_subthat = v_that)THEN v_Level := v_Level + 1; EXIT; END IF;

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

8803:
8804: LOOP
8805:
8806: v_subthis := SUBSTR(v_this, INSTR(v_this, FND_GLOBAL.LOCAL_CHR(8), -1, v_level) + 1);
8807: v_subthat := SUBSTR(v_that, INSTR(v_that, FND_GLOBAL.LOCAL_CHR(8), -1, v_level) + 1);
8808:
8809: IF(v_subthis = v_this)THEN EXIT; END IF;
8810: IF(v_subthat = v_that)THEN v_Level := v_Level + 1; EXIT; END IF;
8811: IF(v_subthis <> v_subthat)THEN EXIT; END IF;

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

8821:
8822: --Bug #4590481 - in this case we also need to concatenate the path. If the full path is not
8823: --required, the second line will reset it to just the node name.
8824:
8825: v_name := v_this || FND_GLOBAL.LOCAL_CHR(8) || v_name;
8826:
8827: IF(NOT h_FullName.EXISTS(v_ExprPsNodeId(j)))THEN v_name := h_NodeName(v_ExprPsNodeId(j)); END IF;
8828: 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;
8829: END IF;

Line 8828: 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;

8824:
8825: v_name := v_this || FND_GLOBAL.LOCAL_CHR(8) || v_name;
8826:
8827: IF(NOT h_FullName.EXISTS(v_ExprPsNodeId(j)))THEN v_name := h_NodeName(v_ExprPsNodeId(j)); END IF;
8828: 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;
8829: END IF;
8830: END IF;
8831:
8832: v_aux := 1;

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

8840: vi_Name(v_Index) := v_name;
8841: vi_Occurrence(v_Index) := v_aux;
8842:
8843: v_Level := 1;
8844: WHILE(INSTR(v_name, FND_GLOBAL.LOCAL_CHR(8), 1, v_Level) <> 0)LOOP v_Level := v_Level + 1; END LOOP;
8845: vi_Depth(v_Index) := v_Level;
8846:
8847: v_name := REPLACE(v_name, '''' || FND_GLOBAL.LOCAL_CHR(7) || '''', '''.''');
8848: v_name := REPLACE(v_name, '''' || FND_GLOBAL.LOCAL_CHR(8) || '''', '''.''');

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

8843: v_Level := 1;
8844: WHILE(INSTR(v_name, FND_GLOBAL.LOCAL_CHR(8), 1, v_Level) <> 0)LOOP v_Level := v_Level + 1; END LOOP;
8845: vi_Depth(v_Index) := v_Level;
8846:
8847: v_name := REPLACE(v_name, '''' || FND_GLOBAL.LOCAL_CHR(7) || '''', '''.''');
8848: v_name := REPLACE(v_name, '''' || FND_GLOBAL.LOCAL_CHR(8) || '''', '''.''');
8849:
8850: RETURN v_name;
8851: END generate_name;

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

8844: WHILE(INSTR(v_name, FND_GLOBAL.LOCAL_CHR(8), 1, v_Level) <> 0)LOOP v_Level := v_Level + 1; END LOOP;
8845: vi_Depth(v_Index) := v_Level;
8846:
8847: v_name := REPLACE(v_name, '''' || FND_GLOBAL.LOCAL_CHR(7) || '''', '''.''');
8848: v_name := REPLACE(v_name, '''' || FND_GLOBAL.LOCAL_CHR(8) || '''', '''.''');
8849:
8850: RETURN v_name;
8851: END generate_name;
8852: ---------------------------------------------------------------------------------------

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

9072:
9073: nDebug := 1005;
9074:
9075: v_RuleText := v_ExprArgumentName(j);
9076: IF(SUBSTR(v_RuleText, 1, 1) <> FND_GLOBAL.LOCAL_CHR(38))THEN
9077:
9078: v_RuleText := FND_GLOBAL.LOCAL_CHR(38) || v_RuleText;
9079: END IF;
9080:

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

9074:
9075: v_RuleText := v_ExprArgumentName(j);
9076: IF(SUBSTR(v_RuleText, 1, 1) <> FND_GLOBAL.LOCAL_CHR(38))THEN
9077:
9078: v_RuleText := FND_GLOBAL.LOCAL_CHR(38) || v_RuleText;
9079: END IF;
9080:
9081: IF(v_ChildrenIndex.EXISTS(v_ExprId(j)))THEN
9082:

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

9139: nDebug := 1008;
9140:
9141: IF(isCompatible = 1)THEN v_RuleText := v_ExprArgumentName(j) || ' OF ';
9142: ELSE v_RuleText := v_ExprArgumentName(j) || ' IN {'; END IF;
9143: IF(SUBSTR(v_RuleText, 1, 1) <> FND_GLOBAL.LOCAL_CHR(38))THEN
9144:
9145: v_RuleText := FND_GLOBAL.LOCAL_CHR(38) || v_RuleText;
9146: END IF;
9147:

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

9141: IF(isCompatible = 1)THEN v_RuleText := v_ExprArgumentName(j) || ' OF ';
9142: ELSE v_RuleText := v_ExprArgumentName(j) || ' IN {'; END IF;
9143: IF(SUBSTR(v_RuleText, 1, 1) <> FND_GLOBAL.LOCAL_CHR(38))THEN
9144:
9145: v_RuleText := FND_GLOBAL.LOCAL_CHR(38) || v_RuleText;
9146: END IF;
9147:
9148: IF(v_ChildrenIndex.EXISTS(v_ExprId(j)))THEN
9149:

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

9565: v_ExprDataType(v_index) := NULL;
9566: v_ExprDataValue(v_index) := NULL;
9567: v_ExprDataNumValue(v_index) := NULL;
9568: v_ExprPropertyId(v_index) := NULL;
9569: v_ExprArgumentName(v_index) := FND_GLOBAL.LOCAL_CHR(38) || 'x';
9570: v_ExprParamIndex(v_index) := NULL;
9571:
9572: nLocalExprId := nLocalExprId + 1;
9573: v_ExprId(v_index) := nLocalExprId;

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

9591: v_ExprDataType(v_index) := NULL;
9592: v_ExprDataValue(v_index) := NULL;
9593: v_ExprDataNumValue(v_index) := NULL;
9594: v_ExprPropertyId(v_index) := NULL;
9595: v_ExprArgumentName(v_index) := FND_GLOBAL.LOCAL_CHR(38) || 'x';
9596: v_ExprParamIndex(v_index) := NULL;
9597:
9598: nLocalExprId := nLocalExprId + 1;
9599: v_ExprId(v_index) := nLocalExprId;