APPS.PA_ROLE_JOB_BG_PVT dependencies on FND_API

Line 5: p_commit IN VARCHAR2:=FND_API.G_FALSE,

1: package body PA_ROLE_JOB_BG_PVT AS
2: /* $Header: PAXRJBVB.pls 115.2 2003/08/25 19:01:45 ramurthy ship $ */
3:
4: procedure INSERT_ROW (
5: p_commit IN VARCHAR2:=FND_API.G_FALSE,
6: p_debug_mode IN VARCHAR2 DEFAULT 'N',
7: P_ROLE_JOB_BG_ID OUT NOCOPY NUMBER,
8: P_PROJECT_ROLE_ID IN NUMBER,
9: P_BUSINESS_GROUP_ID IN NUMBER,

Line 45: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

41: p_return_status => p_return_status,
42: p_error_message_code => l_error_message_code);
43:
44: -- hr_utility.trace('after check_dup_job_bg_defaults');
45: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
46:
47: -- Call the table handler to insert into the table
48:
49: -- hr_utility.trace('before tabkle handler insert row');

Line 68: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN

64:
65: -- hr_utility.trace('after tabkle handler insert row');
66: -- hr_utility.trace('error is : ' || sqlerrm);
67:
68: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
69: fnd_message.set_name('PA', l_error_message_code);
70: fnd_msg_pub.ADD;
71: p_msg_count := p_msg_count + 1;
72:

Line 73: ELSIF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

69: fnd_message.set_name('PA', l_error_message_code);
70: fnd_msg_pub.ADD;
71: p_msg_count := p_msg_count + 1;
72:
73: ELSIF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
74:
75: fnd_msg_pub.add_exc_msg
76: (p_pkg_name => 'pa_role_job_bg_utils',
77: p_procedure_name => 'check_dup_job_bg_defaults',

Line 87: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

83:
84: EXCEPTION
85: WHEN OTHERS THEN
86:
87: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
88: l_sqlcode := SQLCODE;
89:
90: fnd_msg_pub.add_exc_msg
91: (p_pkg_name => 'PA_ROLE_JOB_BG_PVT',

Line 100: p_commit IN VARCHAR2:=FND_API.G_FALSE,

96:
97: END;
98:
99: procedure LOCK_ROW (
100: p_commit IN VARCHAR2:=FND_API.G_FALSE,
101: p_debug_mode IN VARCHAR2 DEFAULT 'N',
102: P_ROLE_JOB_BG_ID IN NUMBER,
103: P_OBJECT_VERSION_NUMBER IN NUMBER,
104: p_return_status OUT NOCOPY VARCHAR2,

Line 124: p_return_status := FND_API.G_RET_STS_SUCCESS;

120: P_ROLE_JOB_BG_ID => P_ROLE_JOB_BG_ID,
121: P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
122: );
123:
124: p_return_status := FND_API.G_RET_STS_SUCCESS;
125:
126: EXCEPTION
127: WHEN OTHERS THEN
128:

Line 129: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

125:
126: EXCEPTION
127: WHEN OTHERS THEN
128:
129: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: l_sqlcode := SQLCODE;
131:
132: fnd_msg_pub.add_exc_msg
133: (p_pkg_name => 'PA_ROLE_JOB_BG_PVT',

Line 141: p_commit IN VARCHAR2:=FND_API.G_FALSE,

137: p_msg_count := p_msg_count + 1;
138: END;
139:
140: procedure UPDATE_ROW (
141: p_commit IN VARCHAR2:=FND_API.G_FALSE,
142: p_debug_mode IN VARCHAR2 DEFAULT 'N',
143: P_ROLE_JOB_BG_ID IN NUMBER,
144: P_PROJECT_ROLE_ID IN NUMBER,
145: P_BUSINESS_GROUP_ID IN NUMBER,

Line 175: p_return_status := FND_API.G_RET_STS_SUCCESS;

171: into l_business_group_id
172: from pa_role_job_bgs
173: where role_job_bg_id = p_role_job_bg_id;
174:
175: p_return_status := FND_API.G_RET_STS_SUCCESS;
176:
177: IF l_business_group_id <> p_business_group_id THEN
178:
179: -- Check if the role job defaults for this BG is a duplicate

Line 189: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

185: p_error_message_code => l_error_message_code);
186:
187: END IF;
188:
189: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
190:
191: -- Call the table handler to update the row
192:
193: pa_role_job_bg_pkg.update_row(

Line 208: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN

204: P_CREATED_BY => P_CREATED_BY,
205: P_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN
206: );
207:
208: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
209: fnd_message.set_name('PA', l_error_message_code);
210: fnd_msg_pub.ADD;
211:
212: p_msg_count := p_msg_count + 1;

Line 213: ELSIF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

209: fnd_message.set_name('PA', l_error_message_code);
210: fnd_msg_pub.ADD;
211:
212: p_msg_count := p_msg_count + 1;
213: ELSIF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
214:
215: fnd_msg_pub.add_exc_msg
216: (p_pkg_name => 'PA_ROLE_JOB_BG_UTILS',
217: p_procedure_name => 'check_dup_job_bg_defaults',

Line 226: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

222:
223: EXCEPTION
224: WHEN OTHERS THEN
225:
226: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: l_sqlcode := SQLCODE;
228:
229: fnd_msg_pub.add_exc_msg
230: (p_pkg_name => 'PA_ROLE_JOB_BG_PVT',

Line 239: p_commit IN VARCHAR2:=FND_API.G_FALSE,

235: END;
236:
237:
238: procedure DELETE_ROW (
239: p_commit IN VARCHAR2:=FND_API.G_FALSE,
240: p_debug_mode IN VARCHAR2 DEFAULT 'N',
241: P_ROLE_JOB_BG_ID IN NUMBER,
242: P_OBJECT_VERSION_NUMBER IN NUMBER,
243: p_return_status OUT NOCOPY VARCHAR2,

Line 259: p_return_status := FND_API.G_RET_STS_SUCCESS;

255: FND_MSG_PUB.initialize;
256:
257: p_msg_count := 0;
258:
259: p_return_status := FND_API.G_RET_STS_SUCCESS;
260:
261: -- hr_utility.trace('before my stuff');
262:
263: -- Call the table handler to delete the job defaults for this BG.

Line 273: -- IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

269:
270: -- hr_utility.trace('p_return_status is ' || p_return_status);
271: -- hr_utility.trace('p_msg_data is ' || p_msg_data);
272:
273: -- IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
274: -- END IF;
275:
276: EXCEPTION
277: WHEN OTHERS THEN

Line 280: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

276: EXCEPTION
277: WHEN OTHERS THEN
278:
279: -- hr_utility.trace('SQLERRM is ' || SQLERRM);
280: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281:
282: l_sqlcode := SQLCODE;
283:
284: fnd_msg_pub.add_exc_msg