APPS.PA_RESOURCE_PKG dependencies on FND_API

Line 38: x_return_status := FND_API.G_RET_STS_SUCCESS;

34: cursor C is
35: select rowid from pa_resources
36: where resource_id = x_resource_id;
37: BEGIN
38: x_return_status := FND_API.G_RET_STS_SUCCESS;
39:
40: --actual insert into pa_resources table
41: insert into PA_RESOURCES (
42: resource_id,

Line 94: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

90: EXCEPTION
91: WHEN NO_DATA_FOUND THEN -- catch the exceptions here
92: -- Set the current program unit name in the error stack
93: -- PA_Error_Utils.Set_Error_Stack('PA_RESOURCE_PKG.Insert_Row1');
94: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
95:
96: WHEN OTHERS THEN -- catch the exceptions here
97: -- Set the current program unit name in the error stack
98: -- PA_Error_Utils.Set_Error_Stack('PA_RESOURCE_PKG.Insert_Row1');

Line 99: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

95:
96: WHEN OTHERS THEN -- catch the exceptions here
97: -- Set the current program unit name in the error stack
98: -- PA_Error_Utils.Set_Error_Stack('PA_RESOURCE_PKG.Insert_Row1');
99: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
100: RAISE;
101: END INSERT_ROW1;
102:
103: --begin of Insert_row2 procedure

Line 135: x_return_status := FND_API.G_RET_STS_SUCCESS;

131: select rowid from pa_resource_txn_attributes
132: where resource_txn_attribute_id = resource_txn_attribute_id;
133:
134: BEGIN
135: x_return_status := FND_API.G_RET_STS_SUCCESS;
136:
137: --actual insert into pa_resource_txn_attribute
138: insert into PA_RESOURCE_TXN_ATTRIBUTES (
139: resource_txn_attribute_id

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

177: EXCEPTION
178: WHEN NO_DATA_FOUND THEN -- catch the exceptions here
179: -- Set the current program unit name in the error stack
180: -- PA_Error_Utils.Set_Error_Stack('PA_RESOURCE_PKG.Insert_Row2');
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
182:
183: WHEN OTHERS THEN -- catch the exceptions here
184: -- Set the current program unit name in the error stack
185: -- PA_Error_Utils.Set_Error_Stack('PA_RESOURCE_PKG.Insert_Row2');

Line 186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

182:
183: WHEN OTHERS THEN -- catch the exceptions here
184: -- Set the current program unit name in the error stack
185: -- PA_Error_Utils.Set_Error_Stack('PA_RESOURCE_PKG.Insert_Row2');
186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
187: RAISE;
188: END INSERT_ROW2;
189:
190: END PA_RESOURCE_PKG;