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

Line 23: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

19: p_fact_table_name IN VARCHAR2,
20: p_table_alias IN VARCHAR2,
21: p_Ledger_Flag IN VARCHAR2 := 'N',
22: p_api_version IN NUMBER := 1.0,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
24: p_commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_encoded IN VARCHAR2 := FND_API.G_TRUE) IS
26:
27: l_predicate_string LONG;

Line 24: p_commit IN VARCHAR2 := FND_API.G_FALSE,

20: p_table_alias IN VARCHAR2,
21: p_Ledger_Flag IN VARCHAR2 := 'N',
22: p_api_version IN NUMBER := 1.0,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
24: p_commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_encoded IN VARCHAR2 := FND_API.G_TRUE) IS
26:
27: l_predicate_string LONG;
28: l_sqlStmt LONG;

Line 25: p_encoded IN VARCHAR2 := FND_API.G_TRUE) IS

21: p_Ledger_Flag IN VARCHAR2 := 'N',
22: p_api_version IN NUMBER := 1.0,
23: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
24: p_commit IN VARCHAR2 := FND_API.G_FALSE,
25: p_encoded IN VARCHAR2 := FND_API.G_TRUE) IS
26:
27: l_predicate_string LONG;
28: l_sqlStmt LONG;
29: l_cond_predicate LONG := NULL;

Line 61: IF ((l_return_status1 = FND_API.G_RET_STS_ERROR) OR (l_return_status1 = FND_API.G_RET_STS_UNEXP_ERROR)) THEN

57: x_predicate_string => l_predicate_string);
58:
59: l_cond_predicate := l_predicate_string;
60:
61: IF ((l_return_status1 = FND_API.G_RET_STS_ERROR) OR (l_return_status1 = FND_API.G_RET_STS_UNEXP_ERROR)) THEN
62: l_predicate_string := '';
63: END IF;
64:
65: IF ((l_return_status1 = FND_API.G_RET_STS_SUCCESS) AND (substr(rtrim(l_ds_predicate,' '),1,LENGTH(l_ds_predicate)) = '()')) THEN

Line 65: IF ((l_return_status1 = FND_API.G_RET_STS_SUCCESS) AND (substr(rtrim(l_ds_predicate,' '),1,LENGTH(l_ds_predicate)) = '()')) THEN

61: IF ((l_return_status1 = FND_API.G_RET_STS_ERROR) OR (l_return_status1 = FND_API.G_RET_STS_UNEXP_ERROR)) THEN
62: l_predicate_string := '';
63: END IF;
64:
65: IF ((l_return_status1 = FND_API.G_RET_STS_SUCCESS) AND (substr(rtrim(l_ds_predicate,' '),1,LENGTH(l_ds_predicate)) = '()')) THEN
66: l_predicate_string := '';
67: END IF;
68:
69: ELSE

Line 71: l_return_status1 := FND_API.G_RET_STS_SUCCESS;

67: END IF;
68:
69: ELSE
70: l_predicate_string := '';
71: l_return_status1 := FND_API.G_RET_STS_SUCCESS;
72: END IF;
73:
74: Fem_ds_where_clause_generator.FEM_Gen_DS_WClause_PVT(
75: p_api_version => p_api_version,

Line 90: IF ((l_return_status2 = FND_API.G_RET_STS_ERROR) OR (l_return_status2 = FND_API.G_RET_STS_UNEXP_ERROR)) THEN

86: p_where_clause => l_sqlStmt);
87:
88: l_ds_predicate := l_sqlStmt;
89:
90: IF ((l_return_status2 = FND_API.G_RET_STS_ERROR) OR (l_return_status2 = FND_API.G_RET_STS_UNEXP_ERROR)) THEN
91: l_sqlStmt := '';
92: END IF;
93:
94: IF ((l_return_status2 = FND_API.G_RET_STS_SUCCESS) AND (substr(rtrim(l_ds_predicate,' '),1,LENGTH(l_ds_predicate)) = '()')) THEN

Line 94: IF ((l_return_status2 = FND_API.G_RET_STS_SUCCESS) AND (substr(rtrim(l_ds_predicate,' '),1,LENGTH(l_ds_predicate)) = '()')) THEN

90: IF ((l_return_status2 = FND_API.G_RET_STS_ERROR) OR (l_return_status2 = FND_API.G_RET_STS_UNEXP_ERROR)) THEN
91: l_sqlStmt := '';
92: END IF;
93:
94: IF ((l_return_status2 = FND_API.G_RET_STS_SUCCESS) AND (substr(rtrim(l_ds_predicate,' '),1,LENGTH(l_ds_predicate)) = '()')) THEN
95: l_sqlStmt := '';
96: END IF;
97:
98: IF (((l_return_status1 = FND_API.G_RET_STS_ERROR) OR (l_return_status1 = FND_API.G_RET_STS_UNEXP_ERROR)) AND

Line 98: IF (((l_return_status1 = FND_API.G_RET_STS_ERROR) OR (l_return_status1 = FND_API.G_RET_STS_UNEXP_ERROR)) AND

94: IF ((l_return_status2 = FND_API.G_RET_STS_SUCCESS) AND (substr(rtrim(l_ds_predicate,' '),1,LENGTH(l_ds_predicate)) = '()')) THEN
95: l_sqlStmt := '';
96: END IF;
97:
98: IF (((l_return_status1 = FND_API.G_RET_STS_ERROR) OR (l_return_status1 = FND_API.G_RET_STS_UNEXP_ERROR)) AND
99: (l_return_status2 = FND_API.G_RET_STS_SUCCESS)) THEN
100: x_return_status := l_return_status1;
101: x_msg_count := l_msg_count1;
102: x_msg_data := l_msg_data1;

Line 99: (l_return_status2 = FND_API.G_RET_STS_SUCCESS)) THEN

95: l_sqlStmt := '';
96: END IF;
97:
98: IF (((l_return_status1 = FND_API.G_RET_STS_ERROR) OR (l_return_status1 = FND_API.G_RET_STS_UNEXP_ERROR)) AND
99: (l_return_status2 = FND_API.G_RET_STS_SUCCESS)) THEN
100: x_return_status := l_return_status1;
101: x_msg_count := l_msg_count1;
102: x_msg_data := l_msg_data1;
103: ELSIF (((l_return_status2 = FND_API.G_RET_STS_ERROR) OR (l_return_status2 = FND_API.G_RET_STS_UNEXP_ERROR)) AND

Line 103: ELSIF (((l_return_status2 = FND_API.G_RET_STS_ERROR) OR (l_return_status2 = FND_API.G_RET_STS_UNEXP_ERROR)) AND

99: (l_return_status2 = FND_API.G_RET_STS_SUCCESS)) THEN
100: x_return_status := l_return_status1;
101: x_msg_count := l_msg_count1;
102: x_msg_data := l_msg_data1;
103: ELSIF (((l_return_status2 = FND_API.G_RET_STS_ERROR) OR (l_return_status2 = FND_API.G_RET_STS_UNEXP_ERROR)) AND
104: (l_return_status1 = FND_API.G_RET_STS_SUCCESS)) THEN
105: x_return_status := l_return_status2;
106: x_msg_count := l_msg_count2;
107: x_msg_data := l_msg_data2;

Line 104: (l_return_status1 = FND_API.G_RET_STS_SUCCESS)) THEN

100: x_return_status := l_return_status1;
101: x_msg_count := l_msg_count1;
102: x_msg_data := l_msg_data1;
103: ELSIF (((l_return_status2 = FND_API.G_RET_STS_ERROR) OR (l_return_status2 = FND_API.G_RET_STS_UNEXP_ERROR)) AND
104: (l_return_status1 = FND_API.G_RET_STS_SUCCESS)) THEN
105: x_return_status := l_return_status2;
106: x_msg_count := l_msg_count2;
107: x_msg_data := l_msg_data2;
108: ELSIF (((l_return_status1 = FND_API.G_RET_STS_ERROR) OR (l_return_status1 = FND_API.G_RET_STS_UNEXP_ERROR)) AND

Line 108: ELSIF (((l_return_status1 = FND_API.G_RET_STS_ERROR) OR (l_return_status1 = FND_API.G_RET_STS_UNEXP_ERROR)) AND

104: (l_return_status1 = FND_API.G_RET_STS_SUCCESS)) THEN
105: x_return_status := l_return_status2;
106: x_msg_count := l_msg_count2;
107: x_msg_data := l_msg_data2;
108: ELSIF (((l_return_status1 = FND_API.G_RET_STS_ERROR) OR (l_return_status1 = FND_API.G_RET_STS_UNEXP_ERROR)) AND
109: ((l_return_status2 = FND_API.G_RET_STS_ERROR) OR (l_return_status2 = FND_API.G_RET_STS_UNEXP_ERROR))) THEN
110: x_return_status := l_return_status1 || ' and ' || l_return_status2;
111: x_msg_count := 1;
112: x_msg_data := l_msg_data1 || ' and ' || l_msg_data2;

Line 109: ((l_return_status2 = FND_API.G_RET_STS_ERROR) OR (l_return_status2 = FND_API.G_RET_STS_UNEXP_ERROR))) THEN

105: x_return_status := l_return_status2;
106: x_msg_count := l_msg_count2;
107: x_msg_data := l_msg_data2;
108: ELSIF (((l_return_status1 = FND_API.G_RET_STS_ERROR) OR (l_return_status1 = FND_API.G_RET_STS_UNEXP_ERROR)) AND
109: ((l_return_status2 = FND_API.G_RET_STS_ERROR) OR (l_return_status2 = FND_API.G_RET_STS_UNEXP_ERROR))) THEN
110: x_return_status := l_return_status1 || ' and ' || l_return_status2;
111: x_msg_count := 1;
112: x_msg_data := l_msg_data1 || ' and ' || l_msg_data2;
113: ELSE