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_msg_index => 1
174: ,p_msg_count => l_msg_count
175: ,p_msg_data => x_msg_data
176: ,p_data => x_msg_data -- l_data : Bug 7369682 : Message is returned by p_data, Not p_msg_data

Line 192: WHEN fnd_api.g_exc_error THEN

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

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

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

Line 199: x_return_status := FND_API.G_RET_STS_ERROR ;

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

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

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

Line 220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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