DBA Data[Home] [Help]

APPS.PA_ROLE_JOB_BG_PVT dependencies on FND_MSG_PUB

Line 32: FND_MSG_PUB.initialize;

28:
29: -- hr_utility.trace_on(NULL, 'RMDUP');
30: -- hr_utility.trace('start insert row');
31:
32: FND_MSG_PUB.initialize;
33:
34: p_msg_count := 0;
35:
36: -- Check if the role job defaults for this BG is a duplicate

Line 70: fnd_msg_pub.ADD;

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:
73: ELSIF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
74:

Line 75: fnd_msg_pub.add_exc_msg

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',
78: p_error_text => l_error_message_code);
79:

Line 90: fnd_msg_pub.add_exc_msg

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',
92: p_procedure_name => 'INSERT_ROW',
93: p_error_text => l_sqlcode);
94:

Line 113: FND_MSG_PUB.initialize;

109: l_sqlcode varchar2(30);
110:
111: BEGIN
112:
113: FND_MSG_PUB.initialize;
114:
115: p_msg_count := 0;
116:
117: -- Call the table handler to lock the row

Line 132: fnd_msg_pub.add_exc_msg

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',
134: p_procedure_name => 'LOCK_ROW',
135: p_error_text => l_sqlcode);
136:

Line 166: FND_MSG_PUB.initialize;

162: l_business_group_id NUMBER(15);
163:
164: BEGIN
165:
166: FND_MSG_PUB.initialize;
167:
168: p_msg_count := 0;
169:
170: select business_group_id

Line 210: fnd_msg_pub.ADD;

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;
213: ELSIF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
214:

Line 215: fnd_msg_pub.add_exc_msg

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',
218: p_error_text => l_error_message_code);
219:

Line 229: fnd_msg_pub.add_exc_msg

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',
231: p_procedure_name => 'UPDATE_ROW',
232: p_error_text => l_sqlcode);
233:

Line 255: FND_MSG_PUB.initialize;

251: BEGIN
252: -- hr_utility.trace_on(NULL, 'RMFORM');
253: -- hr_utility.trace('start');
254:
255: FND_MSG_PUB.initialize;
256:
257: p_msg_count := 0;
258:
259: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 284: fnd_msg_pub.add_exc_msg

280: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281:
282: l_sqlcode := SQLCODE;
283:
284: fnd_msg_pub.add_exc_msg
285: (p_pkg_name => 'PA_ROLE_JOB_BG_PVT',
286: p_procedure_name => 'DELETE_ROW',
287: p_error_text => l_sqlcode);
288: