320: where request_id=RequestId;
321:
322: exception
323: when others then
324: FND_MESSAGE.set_name('IA', 'IA_NO_REQUEST_FOUND'); -- Error: Unable to find request id, REQUEST_ID
325: FND_MESSAGE.set_token('REQUEST_ID', RequestId);
326: l_error_message := FND_MESSAGE.Get;
327: raise localException;
328: end;
321:
322: exception
323: when others then
324: FND_MESSAGE.set_name('IA', 'IA_NO_REQUEST_FOUND'); -- Error: Unable to find request id, REQUEST_ID
325: FND_MESSAGE.set_token('REQUEST_ID', RequestId);
326: l_error_message := FND_MESSAGE.Get;
327: raise localException;
328: end;
329:
322: exception
323: when others then
324: FND_MESSAGE.set_name('IA', 'IA_NO_REQUEST_FOUND'); -- Error: Unable to find request id, REQUEST_ID
325: FND_MESSAGE.set_token('REQUEST_ID', RequestId);
326: l_error_message := FND_MESSAGE.Get;
327: raise localException;
328: end;
329:
330: -----------------------------------------------------
339: and application_id=IA_WF_UTIL_PKG.GetApplicationID;
340:
341: exception
342: when others then
343: FND_MESSAGE.set_name('IA', 'IA_NO_RESPONSIBILITY_FOUND'); -- Error: Unable to find responsibility id, RESPONSIBILITY_ID
344: FND_MESSAGE.set_token('RESPONSIBILITY_ID', l_responsibility_id);
345: l_error_message := FND_MESSAGE.Get;
346: raise localException;
347: end;
340:
341: exception
342: when others then
343: FND_MESSAGE.set_name('IA', 'IA_NO_RESPONSIBILITY_FOUND'); -- Error: Unable to find responsibility id, RESPONSIBILITY_ID
344: FND_MESSAGE.set_token('RESPONSIBILITY_ID', l_responsibility_id);
345: l_error_message := FND_MESSAGE.Get;
346: raise localException;
347: end;
348:
341: exception
342: when others then
343: FND_MESSAGE.set_name('IA', 'IA_NO_RESPONSIBILITY_FOUND'); -- Error: Unable to find responsibility id, RESPONSIBILITY_ID
344: FND_MESSAGE.set_token('RESPONSIBILITY_ID', l_responsibility_id);
345: l_error_message := FND_MESSAGE.Get;
346: raise localException;
347: end;
348:
349: -----------------------------------------------------
354: l_rule_id := IA_WF_UTIL_PKG.GetRuleID(p_responsibility_id => l_responsibility_id);
355:
356: exception
357: when others then
358: FND_MESSAGE.set_name('IA', 'IA_NO_RULE_ASSIGNED');
359: -- Error: No rule has been defined for responsibility id, RESPONSIBILITY_ID
360: FND_MESSAGE.set_token('RESPONSIBILITY_ID', l_responsibility_id);
361: l_error_message := FND_MESSAGE.Get;
362: raise localException;
356: exception
357: when others then
358: FND_MESSAGE.set_name('IA', 'IA_NO_RULE_ASSIGNED');
359: -- Error: No rule has been defined for responsibility id, RESPONSIBILITY_ID
360: FND_MESSAGE.set_token('RESPONSIBILITY_ID', l_responsibility_id);
361: l_error_message := FND_MESSAGE.Get;
362: raise localException;
363: end;
364:
357: when others then
358: FND_MESSAGE.set_name('IA', 'IA_NO_RULE_ASSIGNED');
359: -- Error: No rule has been defined for responsibility id, RESPONSIBILITY_ID
360: FND_MESSAGE.set_token('RESPONSIBILITY_ID', l_responsibility_id);
361: l_error_message := FND_MESSAGE.Get;
362: raise localException;
363: end;
364:
365: -----------------------------------------------------
366: debugInfo := 'Initialize rule setup';
367: -----------------------------------------------------
368: if (not IA_WF_UTIL_PKG.ResetRuleSetup(p_rule_id => l_rule_id,
369: p_book_type_code => l_book_type_code) ) then
370: FND_MESSAGE.set_name('IA', 'IA_RULE_RETRIEVAL_ERROR'); -- Error: Unable to find rule id, RULE_ID
371: FND_MESSAGE.set_token('RULE_ID', l_rule_id);
372: l_error_message := FND_MESSAGE.Get;
373: raise localException;
374: end if;
367: -----------------------------------------------------
368: if (not IA_WF_UTIL_PKG.ResetRuleSetup(p_rule_id => l_rule_id,
369: p_book_type_code => l_book_type_code) ) then
370: FND_MESSAGE.set_name('IA', 'IA_RULE_RETRIEVAL_ERROR'); -- Error: Unable to find rule id, RULE_ID
371: FND_MESSAGE.set_token('RULE_ID', l_rule_id);
372: l_error_message := FND_MESSAGE.Get;
373: raise localException;
374: end if;
375:
368: if (not IA_WF_UTIL_PKG.ResetRuleSetup(p_rule_id => l_rule_id,
369: p_book_type_code => l_book_type_code) ) then
370: FND_MESSAGE.set_name('IA', 'IA_RULE_RETRIEVAL_ERROR'); -- Error: Unable to find rule id, RULE_ID
371: FND_MESSAGE.set_token('RULE_ID', l_rule_id);
372: l_error_message := FND_MESSAGE.Get;
373: raise localException;
374: end if;
375:
376: -----------------------------------------------------
551: where request_id=RequestId;
552:
553: exception
554: when others then
555: FND_MESSAGE.set_name('IA', 'IA_NO_REQUEST_FOUND'); -- Error: Unable to find request id, REQUEST_ID
556: FND_MESSAGE.set_token('REQUEST_ID', RequestId);
557: l_error_message := FND_MESSAGE.Get;
558: raise localException;
559: end;
552:
553: exception
554: when others then
555: FND_MESSAGE.set_name('IA', 'IA_NO_REQUEST_FOUND'); -- Error: Unable to find request id, REQUEST_ID
556: FND_MESSAGE.set_token('REQUEST_ID', RequestId);
557: l_error_message := FND_MESSAGE.Get;
558: raise localException;
559: end;
560:
553: exception
554: when others then
555: FND_MESSAGE.set_name('IA', 'IA_NO_REQUEST_FOUND'); -- Error: Unable to find request id, REQUEST_ID
556: FND_MESSAGE.set_token('REQUEST_ID', RequestId);
557: l_error_message := FND_MESSAGE.Get;
558: raise localException;
559: end;
560:
561: -----------------------------------------------------
570: and application_id=IA_WF_UTIL_PKG.GetApplicationID;
571:
572: exception
573: when others then
574: FND_MESSAGE.set_name('IA', 'IA_NO_RESPONSIBILITY_FOUND'); -- Error: Unable to find responsibility id, RESPONSIBILITY_ID
575: FND_MESSAGE.set_token('RESPONSIBILITY_ID', l_responsibility_id);
576: l_error_message := FND_MESSAGE.Get;
577: raise localException;
578: end;
571:
572: exception
573: when others then
574: FND_MESSAGE.set_name('IA', 'IA_NO_RESPONSIBILITY_FOUND'); -- Error: Unable to find responsibility id, RESPONSIBILITY_ID
575: FND_MESSAGE.set_token('RESPONSIBILITY_ID', l_responsibility_id);
576: l_error_message := FND_MESSAGE.Get;
577: raise localException;
578: end;
579:
572: exception
573: when others then
574: FND_MESSAGE.set_name('IA', 'IA_NO_RESPONSIBILITY_FOUND'); -- Error: Unable to find responsibility id, RESPONSIBILITY_ID
575: FND_MESSAGE.set_token('RESPONSIBILITY_ID', l_responsibility_id);
576: l_error_message := FND_MESSAGE.Get;
577: raise localException;
578: end;
579:
580: -----------------------------------------------------
585: l_rule_id := IA_WF_UTIL_PKG.GetRuleID(p_responsibility_id => l_responsibility_id);
586:
587: exception
588: when others then
589: FND_MESSAGE.set_name('IA', 'IA_NO_RULE_ASSIGNED'); -- Error: No rule has been defined for responsibility id, RESPONSIBILITY_ID.
590: FND_MESSAGE.set_token('RESPONSIBILITY_ID', l_responsibility_id);
591: l_error_message := FND_MESSAGE.Get;
592: raise localException;
593: end;
586:
587: exception
588: when others then
589: FND_MESSAGE.set_name('IA', 'IA_NO_RULE_ASSIGNED'); -- Error: No rule has been defined for responsibility id, RESPONSIBILITY_ID.
590: FND_MESSAGE.set_token('RESPONSIBILITY_ID', l_responsibility_id);
591: l_error_message := FND_MESSAGE.Get;
592: raise localException;
593: end;
594:
587: exception
588: when others then
589: FND_MESSAGE.set_name('IA', 'IA_NO_RULE_ASSIGNED'); -- Error: No rule has been defined for responsibility id, RESPONSIBILITY_ID.
590: FND_MESSAGE.set_token('RESPONSIBILITY_ID', l_responsibility_id);
591: l_error_message := FND_MESSAGE.Get;
592: raise localException;
593: end;
594:
595: -----------------------------------------------------
596: debugInfo := 'Initialize rule setup';
597: -----------------------------------------------------
598: if (not IA_WF_UTIL_PKG.ResetRuleSetup(p_rule_id => l_rule_id,
599: p_book_type_code => l_book_type_code) ) then
600: FND_MESSAGE.set_name('IA', 'IA_RULE_RETRIEVAL_ERROR'); -- Error: Unable to find rule id, RULE_ID
601: FND_MESSAGE.set_token('RULE_ID', l_rule_id);
602: l_error_message := FND_MESSAGE.Get;
603: raise localException;
604: end if;
597: -----------------------------------------------------
598: if (not IA_WF_UTIL_PKG.ResetRuleSetup(p_rule_id => l_rule_id,
599: p_book_type_code => l_book_type_code) ) then
600: FND_MESSAGE.set_name('IA', 'IA_RULE_RETRIEVAL_ERROR'); -- Error: Unable to find rule id, RULE_ID
601: FND_MESSAGE.set_token('RULE_ID', l_rule_id);
602: l_error_message := FND_MESSAGE.Get;
603: raise localException;
604: end if;
605:
598: if (not IA_WF_UTIL_PKG.ResetRuleSetup(p_rule_id => l_rule_id,
599: p_book_type_code => l_book_type_code) ) then
600: FND_MESSAGE.set_name('IA', 'IA_RULE_RETRIEVAL_ERROR'); -- Error: Unable to find rule id, RULE_ID
601: FND_MESSAGE.set_token('RULE_ID', l_rule_id);
602: l_error_message := FND_MESSAGE.Get;
603: raise localException;
604: end if;
605:
606: -----------------------------------------------------