eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_WBS_RULES_PVT dependencies on FND_MESSAGE

Line 163: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_SAME_ROUTE' );

159: END IF;
160:
161: --Check if Route is same on both sides of the Rule
162: IF(L_PRE_ROUTE = L_POST_ROUTE) THEN
163: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_SAME_ROUTE' );
164: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
165: FND_MSG_PUB.add;
166: x_return_status := FND_API.G_RET_STS_ERROR;
167:

Line 164: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

160:
161: --Check if Route is same on both sides of the Rule
162: IF(L_PRE_ROUTE = L_POST_ROUTE) THEN
163: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_SAME_ROUTE' );
164: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
165: FND_MSG_PUB.add;
166: x_return_status := FND_API.G_RET_STS_ERROR;
167:
168: IF (l_log_statement >= l_log_current_level) THEN

Line 178: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INCOMPLETE_RULE' );

174: L_RULE_POST_PART := formulate_rule_stmt(L_POST_ROUTE, L_POST_ROUTE_TYPE_MEANING, L_POST_SYSTEM_CODE, L_POST_PROCESS_MEANING);
175:
176: --Check if Rule is filled on both sides
177: IF (L_RULE_PRE_PART = '' OR L_RULE_POST_PART = '') THEN
178: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INCOMPLETE_RULE' );
179: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
180: FND_MSG_PUB.add;
181: x_return_status := FND_API.G_RET_STS_ERROR;
182: IF (l_log_statement >= l_log_current_level) THEN

Line 179: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

175:
176: --Check if Rule is filled on both sides
177: IF (L_RULE_PRE_PART = '' OR L_RULE_POST_PART = '') THEN
178: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INCOMPLETE_RULE' );
179: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
180: FND_MSG_PUB.add;
181: x_return_status := FND_API.G_RET_STS_ERROR;
182: IF (l_log_statement >= l_log_current_level) THEN
183: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Incomplete Rule');

Line 189: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_PRE_POST_SAME' );

185: END IF;
186:
187: --Check if both part of the rule is exactly same
188: IF(L_RULE_PRE_PART = L_RULE_POST_PART) THEN
189: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_PRE_POST_SAME' );
190: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
191: FND_MSG_PUB.add;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: IF (l_log_statement >= l_log_current_level) THEN

Line 190: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

186:
187: --Check if both part of the rule is exactly same
188: IF(L_RULE_PRE_PART = L_RULE_POST_PART) THEN
189: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_PRE_POST_SAME' );
190: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
191: FND_MSG_PUB.add;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: IF (l_log_statement >= l_log_current_level) THEN
194: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Both part are same');

Line 201: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DIFF_ATTR' );

197:
198: --Check if same set of attributes are used on both sides
199: IF((L_PRE_ROUTE IS NULL AND L_POST_ROUTE IS NOT NULL)
200: OR (L_PRE_ROUTE IS NOT NULL AND L_POST_ROUTE IS NULL)) THEN
201: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DIFF_ATTR' );
202: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
203: FND_MSG_PUB.add;
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: IF (l_log_statement >= l_log_current_level) THEN

Line 202: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

198: --Check if same set of attributes are used on both sides
199: IF((L_PRE_ROUTE IS NULL AND L_POST_ROUTE IS NOT NULL)
200: OR (L_PRE_ROUTE IS NOT NULL AND L_POST_ROUTE IS NULL)) THEN
201: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DIFF_ATTR' );
202: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
203: FND_MSG_PUB.add;
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: IF (l_log_statement >= l_log_current_level) THEN
206: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Not Same Attributes');

Line 211: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DIFF_ATTR' );

207: END IF;
208:
209: ELSIF ((L_PRE_ROUTE_TYPE_CODE IS NULL AND L_POST_ROUTE_TYPE_CODE IS NOT NULL)
210: OR (L_PRE_ROUTE_TYPE_CODE IS NOT NULL AND L_POST_ROUTE_TYPE_CODE IS NULL)) THEN
211: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DIFF_ATTR' );
212: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
213: FND_MSG_PUB.add;
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: IF (l_log_statement >= l_log_current_level) THEN

Line 212: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

208:
209: ELSIF ((L_PRE_ROUTE_TYPE_CODE IS NULL AND L_POST_ROUTE_TYPE_CODE IS NOT NULL)
210: OR (L_PRE_ROUTE_TYPE_CODE IS NOT NULL AND L_POST_ROUTE_TYPE_CODE IS NULL)) THEN
211: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DIFF_ATTR' );
212: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
213: FND_MSG_PUB.add;
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: IF (l_log_statement >= l_log_current_level) THEN
216: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Not Same Attributes');

Line 221: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DIFF_ATTR' );

217: END IF;
218:
219: ELSIF ((L_PRE_SYSTEM_CODE IS NULL AND L_POST_SYSTEM_CODE IS NOT NULL)
220: OR (L_PRE_SYSTEM_CODE IS NOT NULL AND L_POST_SYSTEM_CODE IS NULL)) THEN
221: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DIFF_ATTR' );
222: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
223: FND_MSG_PUB.add;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: IF (l_log_statement >= l_log_current_level) THEN

Line 222: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

218:
219: ELSIF ((L_PRE_SYSTEM_CODE IS NULL AND L_POST_SYSTEM_CODE IS NOT NULL)
220: OR (L_PRE_SYSTEM_CODE IS NOT NULL AND L_POST_SYSTEM_CODE IS NULL)) THEN
221: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DIFF_ATTR' );
222: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
223: FND_MSG_PUB.add;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: IF (l_log_statement >= l_log_current_level) THEN
226: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Not Same Attributes');

Line 231: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DIFF_ATTR' );

227: END IF;
228:
229: ELSIF ((L_PRE_PROCESS_CODE IS NULL AND L_POST_PROCESS_CODE IS NOT NULL)
230: OR (L_PRE_PROCESS_CODE IS NOT NULL AND L_POST_PROCESS_CODE IS NULL)) THEN
231: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DIFF_ATTR' );
232: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
233: FND_MSG_PUB.add;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: IF (l_log_statement >= l_log_current_level) THEN

Line 232: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

228:
229: ELSIF ((L_PRE_PROCESS_CODE IS NULL AND L_POST_PROCESS_CODE IS NOT NULL)
230: OR (L_PRE_PROCESS_CODE IS NOT NULL AND L_POST_PROCESS_CODE IS NULL)) THEN
231: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DIFF_ATTR' );
232: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
233: FND_MSG_PUB.add;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: IF (l_log_statement >= l_log_current_level) THEN
236: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Not Same Attributes');

Line 248: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_ROUTE' );

244: OPEN CHK_ROUTE_NUM(L_PRE_ROUTE);
245: FETCH CHK_ROUTE_NUM into L_DUMMY_COUNT;
246: CLOSE CHK_ROUTE_NUM;
247: IF(L_DUMMY_COUNT < 1) THEN
248: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_ROUTE' );
249: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
250: FND_MSG_PUB.add;
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: IF (l_log_statement >= l_log_current_level) THEN

Line 249: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

245: FETCH CHK_ROUTE_NUM into L_DUMMY_COUNT;
246: CLOSE CHK_ROUTE_NUM;
247: IF(L_DUMMY_COUNT < 1) THEN
248: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_ROUTE' );
249: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
250: FND_MSG_PUB.add;
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: IF (l_log_statement >= l_log_current_level) THEN
253: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PreRoute');

Line 264: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_ROUTE_TYPE' );

260: OPEN CHK_ROUTE_TYPE(L_PRE_ROUTE_TYPE_CODE);
261: FETCH CHK_ROUTE_TYPE into L_DUMMY_COUNT;
262: CLOSE CHK_ROUTE_TYPE;
263: IF(L_DUMMY_COUNT < 1) THEN
264: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_ROUTE_TYPE' );
265: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
266: FND_MSG_PUB.add;
267: x_return_status := FND_API.G_RET_STS_ERROR;
268: IF (l_log_statement >= l_log_current_level) THEN

Line 265: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

261: FETCH CHK_ROUTE_TYPE into L_DUMMY_COUNT;
262: CLOSE CHK_ROUTE_TYPE;
263: IF(L_DUMMY_COUNT < 1) THEN
264: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_ROUTE_TYPE' );
265: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
266: FND_MSG_PUB.add;
267: x_return_status := FND_API.G_RET_STS_ERROR;
268: IF (l_log_statement >= l_log_current_level) THEN
269: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PreRouteType');

Line 280: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_SYSTEM' );

276: OPEN CHK_SYSTEM(L_PRE_SYSTEM_CODE);
277: FETCH CHK_SYSTEM into L_DUMMY_COUNT;
278: CLOSE CHK_SYSTEM;
279: IF(L_DUMMY_COUNT < 1) THEN
280: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_SYSTEM' );
281: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
282: FND_MSG_PUB.add;
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: IF (l_log_statement >= l_log_current_level) THEN

Line 281: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

277: FETCH CHK_SYSTEM into L_DUMMY_COUNT;
278: CLOSE CHK_SYSTEM;
279: IF(L_DUMMY_COUNT < 1) THEN
280: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_SYSTEM' );
281: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
282: FND_MSG_PUB.add;
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: IF (l_log_statement >= l_log_current_level) THEN
285: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PreSystem');

Line 296: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_PROCESS' );

292: OPEN CHK_PROCESS(L_PRE_PROCESS_CODE);
293: FETCH CHK_PROCESS into L_DUMMY_COUNT;
294: CLOSE CHK_PROCESS;
295: IF(L_DUMMY_COUNT < 1) THEN
296: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_PROCESS' );
297: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
298: FND_MSG_PUB.add;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: IF (l_log_statement >= l_log_current_level) THEN

Line 297: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

293: FETCH CHK_PROCESS into L_DUMMY_COUNT;
294: CLOSE CHK_PROCESS;
295: IF(L_DUMMY_COUNT < 1) THEN
296: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_PROCESS' );
297: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
298: FND_MSG_PUB.add;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: IF (l_log_statement >= l_log_current_level) THEN
301: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PreProcess');

Line 312: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_ROUTE' );

308: OPEN CHK_ROUTE_NUM(L_POST_ROUTE);
309: FETCH CHK_ROUTE_NUM into L_DUMMY_COUNT;
310: CLOSE CHK_ROUTE_NUM;
311: IF(L_DUMMY_COUNT < 1) THEN
312: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_ROUTE' );
313: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
314: FND_MSG_PUB.add;
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: IF (l_log_statement >= l_log_current_level) THEN

Line 313: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

309: FETCH CHK_ROUTE_NUM into L_DUMMY_COUNT;
310: CLOSE CHK_ROUTE_NUM;
311: IF(L_DUMMY_COUNT < 1) THEN
312: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_ROUTE' );
313: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
314: FND_MSG_PUB.add;
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: IF (l_log_statement >= l_log_current_level) THEN
317: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PostRoute');

Line 328: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_ROUTE_TYPE' );

324: OPEN CHK_ROUTE_TYPE(L_POST_ROUTE_TYPE_CODE);
325: FETCH CHK_ROUTE_TYPE into L_DUMMY_COUNT;
326: CLOSE CHK_ROUTE_TYPE;
327: IF(L_DUMMY_COUNT < 1) THEN
328: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_ROUTE_TYPE' );
329: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
330: FND_MSG_PUB.add;
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: IF (l_log_statement >= l_log_current_level) THEN

Line 329: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

325: FETCH CHK_ROUTE_TYPE into L_DUMMY_COUNT;
326: CLOSE CHK_ROUTE_TYPE;
327: IF(L_DUMMY_COUNT < 1) THEN
328: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_ROUTE_TYPE' );
329: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
330: FND_MSG_PUB.add;
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: IF (l_log_statement >= l_log_current_level) THEN
333: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PostRouteType');

Line 344: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_SYSTEM' );

340: OPEN CHK_SYSTEM(L_POST_SYSTEM_CODE);
341: FETCH CHK_SYSTEM into L_DUMMY_COUNT;
342: CLOSE CHK_SYSTEM;
343: IF(L_DUMMY_COUNT < 1) THEN
344: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_SYSTEM' );
345: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
346: FND_MSG_PUB.add;
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: IF (l_log_statement >= l_log_current_level) THEN

Line 345: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

341: FETCH CHK_SYSTEM into L_DUMMY_COUNT;
342: CLOSE CHK_SYSTEM;
343: IF(L_DUMMY_COUNT < 1) THEN
344: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_SYSTEM' );
345: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
346: FND_MSG_PUB.add;
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: IF (l_log_statement >= l_log_current_level) THEN
349: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PostSystem');

Line 360: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_PROCESS' );

356: OPEN CHK_PROCESS(L_POST_PROCESS_CODE);
357: FETCH CHK_PROCESS into L_DUMMY_COUNT;
358: CLOSE CHK_PROCESS;
359: IF(L_DUMMY_COUNT < 1) THEN
360: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_PROCESS' );
361: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
362: FND_MSG_PUB.add;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: IF (l_log_statement >= l_log_current_level) THEN

Line 361: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

357: FETCH CHK_PROCESS into L_DUMMY_COUNT;
358: CLOSE CHK_PROCESS;
359: IF(L_DUMMY_COUNT < 1) THEN
360: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INV_PROCESS' );
361: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
362: FND_MSG_PUB.add;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: IF (l_log_statement >= l_log_current_level) THEN
365: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Invalid PostProcess');

Line 376: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DUP_RULE' );

372: OPEN CHK_DUP_RULE(G_SCH_WO || L_RULE_PRE_PART || G_BEF_WO || L_RULE_POST_PART);
373: FETCH CHK_DUP_RULE INTO L_DUMMY_COUNT;
374: CLOSE CHK_DUP_RULE;
375: IF(L_DUMMY_COUNT > 0) THEN
376: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DUP_RULE' );
377: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
378: FND_MSG_PUB.add;
379: x_return_status := FND_API.G_RET_STS_ERROR;
380: IF (l_log_statement >= l_log_current_level) THEN

Line 377: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

373: FETCH CHK_DUP_RULE INTO L_DUMMY_COUNT;
374: CLOSE CHK_DUP_RULE;
375: IF(L_DUMMY_COUNT > 0) THEN
376: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_DUP_RULE' );
377: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
378: FND_MSG_PUB.add;
379: x_return_status := FND_API.G_RET_STS_ERROR;
380: IF (l_log_statement >= l_log_current_level) THEN
381: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || ': Duplicate Rule');

Line 390: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INVERSE_RULE' );

386: OPEN CHK_DUP_RULE(G_SCH_WO || L_RULE_POST_PART || G_BEF_WO || L_RULE_PRE_PART);
387: FETCH CHK_DUP_RULE INTO L_DUMMY_COUNT;
388: CLOSE CHK_DUP_RULE;
389: IF(L_DUMMY_COUNT > 0) THEN
390: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INVERSE_RULE' );
391: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
392: FND_MSG_PUB.add;
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: IF (l_log_statement >= l_log_current_level) THEN

Line 391: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

387: FETCH CHK_DUP_RULE INTO L_DUMMY_COUNT;
388: CLOSE CHK_DUP_RULE;
389: IF(L_DUMMY_COUNT > 0) THEN
390: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_INVERSE_RULE' );
391: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
392: FND_MSG_PUB.add;
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: IF (l_log_statement >= l_log_current_level) THEN
395: FND_LOG.string(l_log_statement, L_DEBUG, 'rule_id-' || p_x_wbs_rules_rec.rule_id || 'Inverse of Existing Rule');

Line 436: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_CYC_ROUTE' );

432:
433: EXCEPTION
434: WHEN l_cyclic_loop THEN
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_CYC_ROUTE' );
437: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
438: FND_MSG_PUB.add;
439: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
440: p_count => x_msg_count,

Line 437: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

433: EXCEPTION
434: WHEN l_cyclic_loop THEN
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: FND_MESSAGE.set_name( 'AHL', 'AHL_WBS_CYC_ROUTE' );
437: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
438: FND_MSG_PUB.add;
439: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
440: p_count => x_msg_count,
441: p_data => x_msg_data);

Line 563: FND_MESSAGE.set_name('AHL','AHL_WBS_RECORD_CHANGED');

559: null
560: );
561:
562: IF ( SQL%ROWCOUNT = 0 ) THEN
563: FND_MESSAGE.set_name('AHL','AHL_WBS_RECORD_CHANGED');
564: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
565: FND_MSG_PUB.add;
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: ELSE

Line 564: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

560: );
561:
562: IF ( SQL%ROWCOUNT = 0 ) THEN
563: FND_MESSAGE.set_name('AHL','AHL_WBS_RECORD_CHANGED');
564: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
565: FND_MSG_PUB.add;
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: ELSE
568: -- Check whether Routes form a cycle among the rules. Cannot perform this check before inserting

Line 703: FND_MESSAGE.set_name('AHL','AHL_WBS_RECORD_CHANGED');

699: WHERE RULE_ID = p_x_wbs_rules_rec.rule_id
700: AND object_version_number = p_x_wbs_rules_rec.object_version_number;
701:
702: IF ( SQL%ROWCOUNT = 0 ) THEN
703: FND_MESSAGE.set_name('AHL','AHL_WBS_RECORD_CHANGED');
704: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
705: FND_MSG_PUB.add;
706: x_return_status := FND_API.G_RET_STS_ERROR;
707: ELSE

Line 704: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );

700: AND object_version_number = p_x_wbs_rules_rec.object_version_number;
701:
702: IF ( SQL%ROWCOUNT = 0 ) THEN
703: FND_MESSAGE.set_name('AHL','AHL_WBS_RECORD_CHANGED');
704: FND_MESSAGE.set_token( 'RULE_NO', p_x_wbs_rules_rec.RULE_NUMBER );
705: FND_MSG_PUB.add;
706: x_return_status := FND_API.G_RET_STS_ERROR;
707: ELSE
708: -- Check whether Routes form a cycle among the rules. Cannot perform this check before updating