DBA Data[Home] [Help]

APPS.PA_R_PROJECT_RESOURCES_PUB dependencies on FND_API

Line 79: L_INIT_MSG_LIST := FND_API.G_FALSE;

75: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
76: END IF;
77:
78: IF P_INIT_MSG_LIST IS NULL THEN
79: L_INIT_MSG_LIST := FND_API.G_FALSE;
80: END IF;
81:
82: IF P_COMMIT IS NULL THEN
83: L_COMMIT := FND_API.G_TRUE;

Line 83: L_COMMIT := FND_API.G_TRUE;

79: L_INIT_MSG_LIST := FND_API.G_FALSE;
80: END IF;
81:
82: IF P_COMMIT IS NULL THEN
83: L_COMMIT := FND_API.G_TRUE;
84: END IF;
85:
86: IF P_VALIDATE_ONLY IS NULL THEN
87: L_VALIDATE_ONLY := FND_API.G_FALSE;

Line 87: L_VALIDATE_ONLY := FND_API.G_FALSE;

83: L_COMMIT := FND_API.G_TRUE;
84: END IF;
85:
86: IF P_VALIDATE_ONLY IS NULL THEN
87: L_VALIDATE_ONLY := FND_API.G_FALSE;
88: END IF;
89:
90: IF P_MAX_MSG_COUNT IS NULL THEN
91: L_MAX_MSG_COUNT := FND_API.G_MISS_NUM;

Line 91: L_MAX_MSG_COUNT := FND_API.G_MISS_NUM;

87: L_VALIDATE_ONLY := FND_API.G_FALSE;
88: END IF;
89:
90: IF P_MAX_MSG_COUNT IS NULL THEN
91: L_MAX_MSG_COUNT := FND_API.G_MISS_NUM;
92: END IF;
93:
94: IF (l_commit = FND_API.G_TRUE) THEN
95: SAVEPOINT res_pub_create_resource;

Line 94: IF (l_commit = FND_API.G_TRUE) THEN

90: IF P_MAX_MSG_COUNT IS NULL THEN
91: L_MAX_MSG_COUNT := FND_API.G_MISS_NUM;
92: END IF;
93:
94: IF (l_commit = FND_API.G_TRUE) THEN
95: SAVEPOINT res_pub_create_resource;
96: END IF;
97:
98: If L_RESOURCE_TYPE IS NULL THEN

Line 102: X_RETURN_STATUS := fnd_api.g_ret_sts_success;

98: If L_RESOURCE_TYPE IS NULL THEN
99: L_RESOURCE_TYPE := 'EMPLOYEE';
100: End If;
101:
102: X_RETURN_STATUS := fnd_api.g_ret_sts_success;
103:
104: IF fnd_api.to_boolean(L_INIT_MSG_LIST) THEN
105: fnd_msg_pub.initialize;
106: END IF;

Line 104: IF fnd_api.to_boolean(L_INIT_MSG_LIST) THEN

100: End If;
101:
102: X_RETURN_STATUS := fnd_api.g_ret_sts_success;
103:
104: IF fnd_api.to_boolean(L_INIT_MSG_LIST) THEN
105: fnd_msg_pub.initialize;
106: END IF;
107:
108: IF NOT fnd_api.compatible_api_call(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME)

Line 108: IF NOT fnd_api.compatible_api_call(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME)

104: IF fnd_api.to_boolean(L_INIT_MSG_LIST) THEN
105: fnd_msg_pub.initialize;
106: END IF;
107:
108: IF NOT fnd_api.compatible_api_call(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME)
109: THEN
110: RAISE fnd_api.g_exc_error;
111: END IF;
112:

Line 110: RAISE fnd_api.g_exc_error;

106: END IF;
107:
108: IF NOT fnd_api.compatible_api_call(L_API_VERSION, P_API_VERSION, L_API_NAME, G_PKG_NAME)
109: THEN
110: RAISE fnd_api.g_exc_error;
111: END IF;
112:
113: IF ((L_INTERNAL is null) or (L_INDIVIDUAL is null) or (L_RESOURCE_TYPE is null)) THEN
114: --dbms_output.put_line('Internal Flag or Individual Flag or Resource Type cannot be null');

Line 117: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

113: IF ((L_INTERNAL is null) or (L_INDIVIDUAL is null) or (L_RESOURCE_TYPE is null)) THEN
114: --dbms_output.put_line('Internal Flag or Individual Flag or Resource Type cannot be null');
115: PA_UTILS.Add_Message( p_app_short_name => 'PA'
116: ,p_msg_name => 'PA_RS_PUBLIC_PARAMETERS_NULL');
117: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
118: RAISE fnd_api.g_exc_error;
119: END IF;
120:
121: ---Call the Private Procedure

Line 118: RAISE fnd_api.g_exc_error;

114: --dbms_output.put_line('Internal Flag or Individual Flag or Resource Type cannot be null');
115: PA_UTILS.Add_Message( p_app_short_name => 'PA'
116: ,p_msg_name => 'PA_RS_PUBLIC_PARAMETERS_NULL');
117: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
118: RAISE fnd_api.g_exc_error;
119: END IF;
120:
121: ---Call the Private Procedure
122: --dbms_output.put_line('Calling Private Procedure PA_R_PROJECT_RESOURCES_PVT.CREATE_RESOURCE ');

Line 160: IF fnd_api.to_boolean(l_commit) THEN

156: pa_debug.g_err_stage := 'Log: After private API - Create_Resource'; --For bug 4345198
157: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG',pa_debug.g_err_stage);
158: END IF;
159:
160: IF fnd_api.to_boolean(l_commit) THEN
161: COMMIT WORK;
162: END IF;
163:
164: x_return_status := L_RETURN_STATUS;

Line 172: -- p_encoded => FND_API.G_FALSE -- FND_API.G_TRUE : Bug 7369682 : To get translated message

168:
169: IF l_msg_count = 1 THEN
170:
171: pa_interface_utils_pub.get_messages(
172: -- p_encoded => FND_API.G_FALSE -- FND_API.G_TRUE : Bug 7369682 : To get translated message
173: --p_encoded => FND_API.G_TRUE -- Bug 7690604 : Changed back this to FND_API.G_TRUE
174: p_encoded => FND_API.G_FALSE -- Bug 8342225: Changed this to FND_API.G_FALSE
175: ,p_msg_index => 1
176: ,p_msg_count => l_msg_count

Line 173: --p_encoded => FND_API.G_TRUE -- Bug 7690604 : Changed back this to FND_API.G_TRUE

169: IF l_msg_count = 1 THEN
170:
171: pa_interface_utils_pub.get_messages(
172: -- p_encoded => FND_API.G_FALSE -- FND_API.G_TRUE : Bug 7369682 : To get translated message
173: --p_encoded => FND_API.G_TRUE -- Bug 7690604 : Changed back this to FND_API.G_TRUE
174: p_encoded => FND_API.G_FALSE -- Bug 8342225: Changed this to FND_API.G_FALSE
175: ,p_msg_index => 1
176: ,p_msg_count => l_msg_count
177: ,p_msg_data => x_msg_data

Line 174: p_encoded => FND_API.G_FALSE -- Bug 8342225: Changed this to FND_API.G_FALSE

170:
171: pa_interface_utils_pub.get_messages(
172: -- p_encoded => FND_API.G_FALSE -- FND_API.G_TRUE : Bug 7369682 : To get translated message
173: --p_encoded => FND_API.G_TRUE -- Bug 7690604 : Changed back this to FND_API.G_TRUE
174: p_encoded => FND_API.G_FALSE -- Bug 8342225: Changed this to FND_API.G_FALSE
175: ,p_msg_index => 1
176: ,p_msg_count => l_msg_count
177: ,p_msg_data => x_msg_data
178: ,p_data => l_data --: Bug 7369682 : Message is returned by p_data, Not p_msg_data

Line 195: WHEN fnd_api.g_exc_error THEN

191: END IF;
192:
193:
194: EXCEPTION
195: WHEN fnd_api.g_exc_error THEN
196: IF (p_commit = FND_API.G_TRUE) THEN
197: ROLLBACK TO res_pub_create_resource;
198: END IF;
199: -- Set the exception Message and the stack

Line 196: IF (p_commit = FND_API.G_TRUE) THEN

192:
193:
194: EXCEPTION
195: WHEN fnd_api.g_exc_error THEN
196: IF (p_commit = FND_API.G_TRUE) THEN
197: ROLLBACK TO res_pub_create_resource;
198: END IF;
199: -- Set the exception Message and the stack
200: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_R_PROJECT_RESOURCES_PUB'

Line 202: x_return_status := FND_API.G_RET_STS_ERROR ;

198: END IF;
199: -- Set the exception Message and the stack
200: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_R_PROJECT_RESOURCES_PUB'
201: ,p_procedure_name => 'CREATE_RESOURCE');
202: x_return_status := FND_API.G_RET_STS_ERROR ;
203:
204: WHEN OTHERS THEN
205: --DBMS_OUTPUT.put_line (' =============== ');
206: --DBMS_OUTPUT.put_line (' Raised Others in Create Resource Public');

Line 216: IF (p_commit = FND_API.G_TRUE) THEN

212: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG',pa_debug.g_err_stack);
213: pa_debug.write_file('CREATE_RESOURCE: ' || 'LOG',pa_debug.g_err_stage);
214: END IF;
215:
216: IF (p_commit = FND_API.G_TRUE) THEN
217: ROLLBACK TO res_pub_create_resource;
218: END IF;
219:
220: -- Set the exception Message and the stack

Line 223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

219:
220: -- Set the exception Message and the stack
221: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_R_PROJECT_RESOURCES_PUB'
222: ,p_procedure_name => 'CREATE_RESOURCE');
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
224: RAISE;
225:
226: END CREATE_RESOURCE;
227: