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

Line 63: when FND_API.G_EXC_ERROR then

59: x_WORKFLOW_PROCESS_Tbl(i).process_name := cr.display_name;
60: end loop;
61:
62: EXCEPTION
63: when FND_API.G_EXC_ERROR then
64: x_return_status := FND_API.G_RET_STS_ERROR ;
65: RAISE FND_API.G_EXC_ERROR;
66: when FND_API.G_EXC_UNEXPECTED_ERROR then
67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 64: x_return_status := FND_API.G_RET_STS_ERROR ;

60: end loop;
61:
62: EXCEPTION
63: when FND_API.G_EXC_ERROR then
64: x_return_status := FND_API.G_RET_STS_ERROR ;
65: RAISE FND_API.G_EXC_ERROR;
66: when FND_API.G_EXC_UNEXPECTED_ERROR then
67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 65: RAISE FND_API.G_EXC_ERROR;

61:
62: EXCEPTION
63: when FND_API.G_EXC_ERROR then
64: x_return_status := FND_API.G_RET_STS_ERROR ;
65: RAISE FND_API.G_EXC_ERROR;
66: when FND_API.G_EXC_UNEXPECTED_ERROR then
67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: when others then

Line 66: when FND_API.G_EXC_UNEXPECTED_ERROR then

62: EXCEPTION
63: when FND_API.G_EXC_ERROR then
64: x_return_status := FND_API.G_RET_STS_ERROR ;
65: RAISE FND_API.G_EXC_ERROR;
66: when FND_API.G_EXC_UNEXPECTED_ERROR then
67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: when others then
70: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

63: when FND_API.G_EXC_ERROR then
64: x_return_status := FND_API.G_RET_STS_ERROR ;
65: RAISE FND_API.G_EXC_ERROR;
66: when FND_API.G_EXC_UNEXPECTED_ERROR then
67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: when others then
70: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
71: BIS_UTILITIES_PVT.Add_Error_Message

Line 68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

64: x_return_status := FND_API.G_RET_STS_ERROR ;
65: RAISE FND_API.G_EXC_ERROR;
66: when FND_API.G_EXC_UNEXPECTED_ERROR then
67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: when others then
70: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
71: BIS_UTILITIES_PVT.Add_Error_Message
72: ( p_error_msg_id => SQLCODE

Line 70: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

66: when FND_API.G_EXC_UNEXPECTED_ERROR then
67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: when others then
70: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
71: BIS_UTILITIES_PVT.Add_Error_Message
72: ( p_error_msg_id => SQLCODE
73: , p_error_description => SQLERRM
74: , p_error_proc_name => G_PKG_NAME||'.Retrieve_WorkFlow_Processes'

Line 76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

72: ( p_error_msg_id => SQLCODE
73: , p_error_description => SQLERRM
74: , p_error_proc_name => G_PKG_NAME||'.Retrieve_WorkFlow_Processes'
75: );
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77:
78: END Retrieve_WorkFlow_Processes;
79:
80: -- This procedure is not used anymore

Line 91: x_return_status := FND_API.G_RET_STS_SUCCESS;

87: )
88: IS
89: BEGIN
90:
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: if BIS_UTILITIES_PUB.Value_Not_Missing(p_wf_process_short_name)
94: = FND_API.G_TRUE
95: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_wf_process_short_name)

Line 94: = FND_API.G_TRUE

90:
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: if BIS_UTILITIES_PUB.Value_Not_Missing(p_wf_process_short_name)
94: = FND_API.G_TRUE
95: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_wf_process_short_name)
96: = FND_API.G_TRUE then
97:
98: select wf.display_name

Line 96: = FND_API.G_TRUE then

92:
93: if BIS_UTILITIES_PUB.Value_Not_Missing(p_wf_process_short_name)
94: = FND_API.G_TRUE
95: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_wf_process_short_name)
96: = FND_API.G_TRUE then
97:
98: select wf.display_name
99: into x_wf_process_name
100: from wf_activities_vl wf

Line 109: RAISE FND_API.G_EXC_ERROR;

105: and NVL(wf.end_date,sysdate) >= sysdate;
106:
107: else
108: -- POPULATE THE ERROR TABLE
109: RAISE FND_API.G_EXC_ERROR;
110: end if;
111:
112:
113: EXCEPTION

Line 114: when FND_API.G_EXC_ERROR then

110: end if;
111:
112:
113: EXCEPTION
114: when FND_API.G_EXC_ERROR then
115: x_return_status := FND_API.G_RET_STS_ERROR ;
116: RAISE FND_API.G_EXC_ERROR;
117: when FND_API.G_EXC_UNEXPECTED_ERROR then
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 115: x_return_status := FND_API.G_RET_STS_ERROR ;

111:
112:
113: EXCEPTION
114: when FND_API.G_EXC_ERROR then
115: x_return_status := FND_API.G_RET_STS_ERROR ;
116: RAISE FND_API.G_EXC_ERROR;
117: when FND_API.G_EXC_UNEXPECTED_ERROR then
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 116: RAISE FND_API.G_EXC_ERROR;

112:
113: EXCEPTION
114: when FND_API.G_EXC_ERROR then
115: x_return_status := FND_API.G_RET_STS_ERROR ;
116: RAISE FND_API.G_EXC_ERROR;
117: when FND_API.G_EXC_UNEXPECTED_ERROR then
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
120: when others then

Line 117: when FND_API.G_EXC_UNEXPECTED_ERROR then

113: EXCEPTION
114: when FND_API.G_EXC_ERROR then
115: x_return_status := FND_API.G_RET_STS_ERROR ;
116: RAISE FND_API.G_EXC_ERROR;
117: when FND_API.G_EXC_UNEXPECTED_ERROR then
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
120: when others then
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

114: when FND_API.G_EXC_ERROR then
115: x_return_status := FND_API.G_RET_STS_ERROR ;
116: RAISE FND_API.G_EXC_ERROR;
117: when FND_API.G_EXC_UNEXPECTED_ERROR then
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
120: when others then
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
122: BIS_UTILITIES_PVT.Add_Error_Message

Line 119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

115: x_return_status := FND_API.G_RET_STS_ERROR ;
116: RAISE FND_API.G_EXC_ERROR;
117: when FND_API.G_EXC_UNEXPECTED_ERROR then
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
120: when others then
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
122: BIS_UTILITIES_PVT.Add_Error_Message
123: ( p_error_msg_id => SQLCODE

Line 121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

117: when FND_API.G_EXC_UNEXPECTED_ERROR then
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
120: when others then
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
122: BIS_UTILITIES_PVT.Add_Error_Message
123: ( p_error_msg_id => SQLCODE
124: , p_error_description => SQLERRM
125: , p_error_proc_name => G_PKG_NAME||'.Retrieve_WF_Process_Name'

Line 127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

123: ( p_error_msg_id => SQLCODE
124: , p_error_description => SQLERRM
125: , p_error_proc_name => G_PKG_NAME||'.Retrieve_WF_Process_Name'
126: );
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128:
129: END Retrieve_WF_Process_Name;
130: --
131: PROCEDURE Validate_WF_Process_Short_Name

Line 133: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

129: END Retrieve_WF_Process_Name;
130: --
131: PROCEDURE Validate_WF_Process_Short_Name
132: ( p_api_version IN NUMBER
133: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
134: , p_wf_process_short_name IN VARCHAR2
135: , x_return_status OUT VARCHAR2
136: , x_error_Tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type
137: )

Line 153: x_return_status := FND_API.G_RET_STS_SUCCESS;

149: l_dummy number;
150:
151: BEGIN
152:
153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154: if( BIS_UTILITIES_PUB.Value_Not_Missing(p_wf_process_short_name)
155: =FND_API.G_TRUE
156: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_wf_process_short_name)
157: =FND_API.G_TRUE ) then

Line 155: =FND_API.G_TRUE

151: BEGIN
152:
153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154: if( BIS_UTILITIES_PUB.Value_Not_Missing(p_wf_process_short_name)
155: =FND_API.G_TRUE
156: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_wf_process_short_name)
157: =FND_API.G_TRUE ) then
158: open val_cur;
159: fetch val_cur into l_dummy;

Line 157: =FND_API.G_TRUE ) then

153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154: if( BIS_UTILITIES_PUB.Value_Not_Missing(p_wf_process_short_name)
155: =FND_API.G_TRUE
156: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_wf_process_short_name)
157: =FND_API.G_TRUE ) then
158: open val_cur;
159: fetch val_cur into l_dummy;
160: if (val_cur%NOTFOUND) then
161: close val_cur;

Line 169: RAISE FND_API.G_EXC_ERROR;

165: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
166: , p_error_proc_name => G_PKG_NAME||'.Validate_WF_Process_Short_Name'
167: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
168: );
169: RAISE FND_API.G_EXC_ERROR;
170: end if;
171: close val_cur;
172: end if;
173:

Line 175: when FND_API.G_EXC_ERROR then

171: close val_cur;
172: end if;
173:
174: EXCEPTION
175: when FND_API.G_EXC_ERROR then
176: x_return_status := FND_API.G_RET_STS_ERROR ;
177: RAISE FND_API.G_EXC_ERROR;
178: when FND_API.G_EXC_UNEXPECTED_ERROR then
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 176: x_return_status := FND_API.G_RET_STS_ERROR ;

172: end if;
173:
174: EXCEPTION
175: when FND_API.G_EXC_ERROR then
176: x_return_status := FND_API.G_RET_STS_ERROR ;
177: RAISE FND_API.G_EXC_ERROR;
178: when FND_API.G_EXC_UNEXPECTED_ERROR then
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 177: RAISE FND_API.G_EXC_ERROR;

173:
174: EXCEPTION
175: when FND_API.G_EXC_ERROR then
176: x_return_status := FND_API.G_RET_STS_ERROR ;
177: RAISE FND_API.G_EXC_ERROR;
178: when FND_API.G_EXC_UNEXPECTED_ERROR then
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: when others then

Line 178: when FND_API.G_EXC_UNEXPECTED_ERROR then

174: EXCEPTION
175: when FND_API.G_EXC_ERROR then
176: x_return_status := FND_API.G_RET_STS_ERROR ;
177: RAISE FND_API.G_EXC_ERROR;
178: when FND_API.G_EXC_UNEXPECTED_ERROR then
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: when others then
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

175: when FND_API.G_EXC_ERROR then
176: x_return_status := FND_API.G_RET_STS_ERROR ;
177: RAISE FND_API.G_EXC_ERROR;
178: when FND_API.G_EXC_UNEXPECTED_ERROR then
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: when others then
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
183: BIS_UTILITIES_PVT.Add_Error_Message

Line 180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

176: x_return_status := FND_API.G_RET_STS_ERROR ;
177: RAISE FND_API.G_EXC_ERROR;
178: when FND_API.G_EXC_UNEXPECTED_ERROR then
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: when others then
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
183: BIS_UTILITIES_PVT.Add_Error_Message
184: ( p_error_msg_id => SQLCODE

Line 182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

178: when FND_API.G_EXC_UNEXPECTED_ERROR then
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
181: when others then
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
183: BIS_UTILITIES_PVT.Add_Error_Message
184: ( p_error_msg_id => SQLCODE
185: , p_error_description => SQLERRM
186: , p_error_proc_name => G_PKG_NAME||'.Validate_WF_Process_Short_Name'

Line 188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

184: ( p_error_msg_id => SQLCODE
185: , p_error_description => SQLERRM
186: , p_error_proc_name => G_PKG_NAME||'.Validate_WF_Process_Short_Name'
187: );
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189:
190: END Validate_WF_Process_Short_Name;
191: --
192: PROCEDURE Value_ID_Conversion

Line 201: x_return_status := FND_API.G_RET_STS_SUCCESS;

197: , x_error_Tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type
198: )
199: IS
200: BEGIN
201: x_return_status := FND_API.G_RET_STS_SUCCESS;
202:
203: if BIS_UTILITIES_PUB.Value_Not_Missing(p_wf_process_name)=FND_API.G_TRUE
204: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_wf_process_name)=FND_API.G_TRUE then
205: select wf.name

Line 203: if BIS_UTILITIES_PUB.Value_Not_Missing(p_wf_process_name)=FND_API.G_TRUE

199: IS
200: BEGIN
201: x_return_status := FND_API.G_RET_STS_SUCCESS;
202:
203: if BIS_UTILITIES_PUB.Value_Not_Missing(p_wf_process_name)=FND_API.G_TRUE
204: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_wf_process_name)=FND_API.G_TRUE then
205: select wf.name
206: into x_wf_process_short_name
207: from wf_activities_vl wf

Line 204: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_wf_process_name)=FND_API.G_TRUE then

200: BEGIN
201: x_return_status := FND_API.G_RET_STS_SUCCESS;
202:
203: if BIS_UTILITIES_PUB.Value_Not_Missing(p_wf_process_name)=FND_API.G_TRUE
204: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_wf_process_name)=FND_API.G_TRUE then
205: select wf.name
206: into x_wf_process_short_name
207: from wf_activities_vl wf
208: where wf.item_type = 'BISKPIWF'

Line 221: RAISE FND_API.G_EXC_ERROR;

217: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
218: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
219: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
220: );
221: RAISE FND_API.G_EXC_ERROR;
222: end if;
223:
224: EXCEPTION
225: when FND_API.G_EXC_ERROR then

Line 225: when FND_API.G_EXC_ERROR then

221: RAISE FND_API.G_EXC_ERROR;
222: end if;
223:
224: EXCEPTION
225: when FND_API.G_EXC_ERROR then
226: x_return_status := FND_API.G_RET_STS_ERROR ;
227: RAISE FND_API.G_EXC_ERROR;
228: when FND_API.G_EXC_UNEXPECTED_ERROR then
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 226: x_return_status := FND_API.G_RET_STS_ERROR ;

222: end if;
223:
224: EXCEPTION
225: when FND_API.G_EXC_ERROR then
226: x_return_status := FND_API.G_RET_STS_ERROR ;
227: RAISE FND_API.G_EXC_ERROR;
228: when FND_API.G_EXC_UNEXPECTED_ERROR then
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 227: RAISE FND_API.G_EXC_ERROR;

223:
224: EXCEPTION
225: when FND_API.G_EXC_ERROR then
226: x_return_status := FND_API.G_RET_STS_ERROR ;
227: RAISE FND_API.G_EXC_ERROR;
228: when FND_API.G_EXC_UNEXPECTED_ERROR then
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: when others then

Line 228: when FND_API.G_EXC_UNEXPECTED_ERROR then

224: EXCEPTION
225: when FND_API.G_EXC_ERROR then
226: x_return_status := FND_API.G_RET_STS_ERROR ;
227: RAISE FND_API.G_EXC_ERROR;
228: when FND_API.G_EXC_UNEXPECTED_ERROR then
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: when others then
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

225: when FND_API.G_EXC_ERROR then
226: x_return_status := FND_API.G_RET_STS_ERROR ;
227: RAISE FND_API.G_EXC_ERROR;
228: when FND_API.G_EXC_UNEXPECTED_ERROR then
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: when others then
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
233: BIS_UTILITIES_PVT.Add_Error_Message

Line 230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

226: x_return_status := FND_API.G_RET_STS_ERROR ;
227: RAISE FND_API.G_EXC_ERROR;
228: when FND_API.G_EXC_UNEXPECTED_ERROR then
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: when others then
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
233: BIS_UTILITIES_PVT.Add_Error_Message
234: ( p_error_msg_id => SQLCODE

Line 232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

228: when FND_API.G_EXC_UNEXPECTED_ERROR then
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: when others then
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
233: BIS_UTILITIES_PVT.Add_Error_Message
234: ( p_error_msg_id => SQLCODE
235: , p_error_description => SQLERRM
236: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'

Line 238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

234: ( p_error_msg_id => SQLCODE
235: , p_error_description => SQLERRM
236: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
237: );
238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
239:
240: END Value_ID_Conversion;
241: --
242: END BIS_WORKFLOW_PROCESS_PVT;