DBA Data[Home] [Help]

APPS.BIS_WORKFLOW_PROCESS_PVT dependencies on BIS_UTILITIES_PUB

Line 10: , x_error_tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type

6: PROCEDURE Retrieve_WorkFlows
7: ( p_api_version IN number
8: , x_WORKFLOW_Tbl out WORKFLOW_Tbl_Type
9: , x_return_status OUT VARCHAR2
10: , x_error_tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type
11: )
12: IS
13: i NUMBER;
14: cursor wf is

Line 36: , x_error_tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type

32: PROCEDURE Retrieve_WorkFlow_Processes
33: ( p_api_version IN number
34: , x_WORKFLOW_PROCESS_Tbl out WORKFLOW_PROCESS_Tbl_Type
35: , x_return_status OUT VARCHAR2
36: , x_error_tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type
37: )
38: IS
39:
40: i NUMBER;

Line 86: , x_error_tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type

82: ( p_api_version IN number
83: , p_wf_process_short_name IN VARCHAR2
84: , x_wf_process_name OUT VARCHAR2
85: , x_return_status OUT VARCHAR2
86: , x_error_tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type
87: )
88: IS
89: BEGIN
90:

Line 93: if BIS_UTILITIES_PUB.Value_Not_Missing(p_wf_process_short_name)

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)
96: = FND_API.G_TRUE then
97:

Line 95: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_wf_process_short_name)

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
99: into x_wf_process_name

Line 136: , x_error_Tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type

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: )
138: IS
139:
140: CURSOR val_cur is

Line 154: if( BIS_UTILITIES_PUB.Value_Not_Missing(p_wf_process_short_name)

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
158: open val_cur;

Line 156: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_wf_process_short_name)

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;
160: if (val_cur%NOTFOUND) then

Line 167: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

163: BIS_UTILITIES_PVT.Add_Error_Message
164: ( p_error_msg_name => 'BIS_INVALID_WORKFLOW_PROCESS'
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;

Line 197: , x_error_Tbl OUT BIS_UTILITIES_PUB.Error_Tbl_Type

193: ( p_api_version IN NUMBER
194: , p_wf_process_Name IN VARCHAR2
195: , x_wf_process_short_name OUT VARCHAR2
196: , x_return_status OUT VARCHAR2
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;

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 219: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

215: BIS_UTILITIES_PVT.Add_Error_Message
216: ( p_error_msg_name => 'BIS_WF_PROCESS_NAME_IS_NULL'
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: