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.CSR_RULES_PVT dependencies on FND_LOG

Line 24: fnd_log.string(p_level, 'csr.plsql.' || g_pkg_name || '.' || p_module, p_message);

20: ELSE
21: fnd_file.put_line(fnd_file.log, rpad(p_module, 20) || ': ' || p_message);
22: END IF;
23: ELSE
24: fnd_log.string(p_level, 'csr.plsql.' || g_pkg_name || '.' || p_module, p_message);
25: END IF;
26: END IF;
27: END debug;
28:

Line 420: debug('Validating Rule', l_api_name, fnd_log.level_event);

416: l_valid_base_rule_name csr_rules_tl.rule_name%TYPE;
417: c_rules SYS_REFCURSOR;
418: BEGIN
419: IF l_debug = 'Y' THEN
420: debug('Validating Rule', l_api_name, fnd_log.level_event);
421: debug(' --> Rule Rank = ' || p_rule_rank, l_api_name, fnd_log.level_statement);
422: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);
423: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
424: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);

Line 421: debug(' --> Rule Rank = ' || p_rule_rank, l_api_name, fnd_log.level_statement);

417: c_rules SYS_REFCURSOR;
418: BEGIN
419: IF l_debug = 'Y' THEN
420: debug('Validating Rule', l_api_name, fnd_log.level_event);
421: debug(' --> Rule Rank = ' || p_rule_rank, l_api_name, fnd_log.level_statement);
422: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);
423: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
424: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
425: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);

Line 422: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);

418: BEGIN
419: IF l_debug = 'Y' THEN
420: debug('Validating Rule', l_api_name, fnd_log.level_event);
421: debug(' --> Rule Rank = ' || p_rule_rank, l_api_name, fnd_log.level_statement);
422: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);
423: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
424: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
425: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
426: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);

Line 423: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);

419: IF l_debug = 'Y' THEN
420: debug('Validating Rule', l_api_name, fnd_log.level_event);
421: debug(' --> Rule Rank = ' || p_rule_rank, l_api_name, fnd_log.level_statement);
422: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);
423: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
424: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
425: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
426: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);
427: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);

Line 424: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);

420: debug('Validating Rule', l_api_name, fnd_log.level_event);
421: debug(' --> Rule Rank = ' || p_rule_rank, l_api_name, fnd_log.level_statement);
422: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);
423: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
424: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
425: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
426: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);
427: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);
428: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);

Line 425: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);

421: debug(' --> Rule Rank = ' || p_rule_rank, l_api_name, fnd_log.level_statement);
422: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);
423: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
424: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
425: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
426: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);
427: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);
428: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);
429: END IF;

Line 426: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);

422: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);
423: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
424: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
425: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
426: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);
427: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);
428: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);
429: END IF;
430:

Line 427: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);

423: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
424: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
425: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
426: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);
427: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);
428: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);
429: END IF;
430:
431: IF p_rule_name IS NULL THEN

Line 428: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);

424: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
425: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
426: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);
427: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);
428: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);
429: END IF;
430:
431: IF p_rule_name IS NULL THEN
432: fnd_message.set_name('CSR', 'CSR_RULE_NAME_NOT_GIVEN');

Line 456: debug('Checking for Eligibility', l_api_name, fnd_log.level_statement);

452: RAISE fnd_api.g_exc_error;
453: END IF;
454:
455: IF l_debug = 'Y' THEN
456: debug('Checking for Eligibility', l_api_name, fnd_log.level_statement);
457: END IF;
458:
459: IF NVL(p_rule_id, g_not_specified) <> 0
460: AND (p_appl_id IS NULL OR p_appl_id = g_not_specified)

Line 472: debug('Checking for Duplicates', l_api_name, fnd_log.level_statement);

468: RAISE fnd_api.g_exc_error;
469: END IF;
470:
471: IF l_debug = 'Y' THEN
472: debug('Checking for Duplicates', l_api_name, fnd_log.level_statement);
473: END IF;
474:
475: -- There can be only one Rule with a particular Eligibility Criteria.
476: OPEN c_duplicate_rules;

Line 489: debug('Checking for Multiple Eligibility and Base Rule', l_api_name, fnd_log.level_statement);

485: END IF;
486:
487: IF p_rule_rank NOT IN (0, 2, 4, 8, 16, 32) THEN
488: IF l_debug = 'Y' THEN
489: debug('Checking for Multiple Eligibility and Base Rule', l_api_name, fnd_log.level_statement);
490: END IF;
491:
492: -- Multiple Eligibility Criteria given
493: l_base_rule_query := 'SELECT rule_id, rule_name FROM csr_rules_vl WHERE ';

Line 520: debug('Querying for Base Rule through ' || l_base_rule_query, l_api_name, fnd_log.level_statement);

516: l_base_eligibilty_type := 'APPL';
517: END IF;
518:
519: IF l_debug = 'Y' THEN
520: debug('Querying for Base Rule through ' || l_base_rule_query, l_api_name, fnd_log.level_statement);
521: END IF;
522:
523: OPEN c_rules FOR l_base_rule_query USING l_base_bind1, l_base_bind2;
524: FETCH c_rules INTO l_valid_base_rule_id, l_valid_base_rule_name;

Line 530: debug('Creating Base Rule with Eligibility as ' || l_base_bind1, l_api_name, fnd_log.level_statement);

526:
527: -- Required Base Rule doesnt exists. Create a System Generated Base Rule
528: IF l_valid_base_rule_id IS NULL THEN
529: IF l_debug = 'Y' THEN
530: debug('Creating Base Rule with Eligibility as ' || l_base_bind1, l_api_name, fnd_log.level_statement);
531: END IF;
532: l_valid_base_rule_id :=
533: create_system_gen_base_rule(
534: l_base_eligibilty_type

Line 544: debug('Checking for Territory Eligibility and Base Rule', l_api_name, fnd_log.level_statement);

540:
541: p_base_rule_id := l_valid_base_rule_id;
542: ELSIF p_terr_id IS NOT NULL AND p_terr_id <> g_not_specified THEN
543: IF l_debug = 'Y' THEN
544: debug('Checking for Territory Eligibility and Base Rule', l_api_name, fnd_log.level_statement);
545: END IF;
546:
547: -- Territory Rule. Ensure that Base Rule is that of Parent Territory
548: p_base_rule_id := get_parent_territory_rule(p_terr_id, p_rule_doc);

Line 656: debug('cheking for '||l_window_id||' with new doc window list ' , l_api_name, fnd_log.level_statement);

652: l_window_attrs := DBMS_XMLDOM.getAttributes(l_window_node);
653: l_window_id := DBMS_XMLDOM.getNodeValue(DBMS_XMLDOM.getNamedItem(l_window_attrs, 'windowId'));
654:
655: IF l_debug = 'Y' THEN
656: debug('cheking for '||l_window_id||' with new doc window list ' , l_api_name, fnd_log.level_statement);
657: END IF;
658: IF NOT check_element(l_windows_id_list,l_window_id) THEN
659: IF l_debug = 'Y' THEN
660: debug('removing TL table records for window with window ID '||l_window_id , l_api_name, fnd_log.level_statement);

Line 660: debug('removing TL table records for window with window ID '||l_window_id , l_api_name, fnd_log.level_statement);

656: debug('cheking for '||l_window_id||' with new doc window list ' , l_api_name, fnd_log.level_statement);
657: END IF;
658: IF NOT check_element(l_windows_id_list,l_window_id) THEN
659: IF l_debug = 'Y' THEN
660: debug('removing TL table records for window with window ID '||l_window_id , l_api_name, fnd_log.level_statement);
661: END IF;
662: DELETE csr_rule_windows_tl WHERE window_id = l_window_id;
663: END IF;
664: END LOOP;

Line 728: debug('Updating Rule#' || p_child_rule_id, l_api_name, fnd_log.level_event);

724:
725: l_childrule_dom := DBMS_XMLDOM.newDOMDocument(p_child_doc);
726:
727: IF l_debug = 'Y' THEN
728: debug('Updating Rule#' || p_child_rule_id, l_api_name, fnd_log.level_event);
729: DECLARE
730: buffer VARCHAR2(8000);
731: BEGIN
732: DBMS_XMLDOM.WRITETOBUFFER(l_childrule_dom, buffer);

Line 733: debug(' --> XML Doc#1 = ' || substr(buffer, 1, 3900), l_api_name, fnd_log.level_statement);

729: DECLARE
730: buffer VARCHAR2(8000);
731: BEGIN
732: DBMS_XMLDOM.WRITETOBUFFER(l_childrule_dom, buffer);
733: debug(' --> XML Doc#1 = ' || substr(buffer, 1, 3900), l_api_name, fnd_log.level_statement);
734: debug(' --> XML Doc#2 = ' || substr(buffer, 3901, 3900), l_api_name, fnd_log.level_statement);
735: END;
736: END IF;
737:

Line 734: debug(' --> XML Doc#2 = ' || substr(buffer, 3901, 3900), l_api_name, fnd_log.level_statement);

730: buffer VARCHAR2(8000);
731: BEGIN
732: DBMS_XMLDOM.WRITETOBUFFER(l_childrule_dom, buffer);
733: debug(' --> XML Doc#1 = ' || substr(buffer, 1, 3900), l_api_name, fnd_log.level_statement);
734: debug(' --> XML Doc#2 = ' || substr(buffer, 3901, 3900), l_api_name, fnd_log.level_statement);
735: END;
736: END IF;
737:
738: i := l_baserule_node_list.FIRST;

Line 757: , l_api_name, fnd_log.level_statement);

753: DBMS_XMLDOM.setNodeValue(l_child_text_node, DBMS_XMLDOM.getNodeValue(l_base_text_node));
754: l_child_modified := TRUE;
755: IF l_debug = 'Y' THEN
756: debug('Modified XML Element:' ||DBMS_XMLDOM.getNodeName(l_child_text_node)
757: , l_api_name, fnd_log.level_statement);
758: END IF;
759: END IF;
760: i := l_baserule_node_list.NEXT(i);
761: END LOOP;

Line 772: debug('The Rule:'||p_child_rule_id ||' was modified', l_api_name, fnd_log.level_statement);

768: END IF;
769:
770: IF l_debug = 'Y' THEN
771: IF l_child_modified = TRUE THEN
772: debug('The Rule:'||p_child_rule_id ||' was modified', l_api_name, fnd_log.level_statement);
773: ELSE
774: debug('The Rule:'||p_child_rule_id ||' was NOT modified', l_api_name, fnd_log.level_statement);
775: END IF;
776: END IF;

Line 774: debug('The Rule:'||p_child_rule_id ||' was NOT modified', l_api_name, fnd_log.level_statement);

770: IF l_debug = 'Y' THEN
771: IF l_child_modified = TRUE THEN
772: debug('The Rule:'||p_child_rule_id ||' was modified', l_api_name, fnd_log.level_statement);
773: ELSE
774: debug('The Rule:'||p_child_rule_id ||' was NOT modified', l_api_name, fnd_log.level_statement);
775: END IF;
776: END IF;
777:
778: -- Return whether the Child Rule is Modified or Not.

Line 823: debug('Propogating the Changes From the Rule#'||p_rule_id||' to:'||v_child_rule.rule_id , l_api_name, fnd_log.level_statement);

819:
820: -- Propagate the Changes to the Child Rules Recursively
821: FOR v_child_rule IN c_child_rules LOOP
822: IF l_debug = 'Y' THEN
823: debug('Propogating the Changes From the Rule#'||p_rule_id||' to:'||v_child_rule.rule_id , l_api_name, fnd_log.level_statement);
824: END IF;
825: propagate_to_child_rules(v_child_rule.rule_id, l_child_doc, v_child_rule.rule_doc, p_force);
826: END LOOP;
827:

Line 886: debug('Creating Rule', l_api_name, fnd_log.level_event);

882: -- Initialize Return Status
883: x_return_status := fnd_api.g_ret_sts_success;
884:
885: IF l_debug = 'Y' THEN
886: debug('Creating Rule', l_api_name, fnd_log.level_event);
887: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_event);
888: debug(' --> Base Rule = ' || p_base_rule_id, l_api_name, fnd_log.level_statement);
889: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
890: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);

Line 887: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_event);

883: x_return_status := fnd_api.g_ret_sts_success;
884:
885: IF l_debug = 'Y' THEN
886: debug('Creating Rule', l_api_name, fnd_log.level_event);
887: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_event);
888: debug(' --> Base Rule = ' || p_base_rule_id, l_api_name, fnd_log.level_statement);
889: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
890: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
891: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);

Line 888: debug(' --> Base Rule = ' || p_base_rule_id, l_api_name, fnd_log.level_statement);

884:
885: IF l_debug = 'Y' THEN
886: debug('Creating Rule', l_api_name, fnd_log.level_event);
887: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_event);
888: debug(' --> Base Rule = ' || p_base_rule_id, l_api_name, fnd_log.level_statement);
889: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
890: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
891: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
892: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);

Line 889: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);

885: IF l_debug = 'Y' THEN
886: debug('Creating Rule', l_api_name, fnd_log.level_event);
887: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_event);
888: debug(' --> Base Rule = ' || p_base_rule_id, l_api_name, fnd_log.level_statement);
889: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
890: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
891: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
892: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);
893: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);

Line 890: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);

886: debug('Creating Rule', l_api_name, fnd_log.level_event);
887: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_event);
888: debug(' --> Base Rule = ' || p_base_rule_id, l_api_name, fnd_log.level_statement);
889: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
890: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
891: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
892: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);
893: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);
894: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);

Line 891: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);

887: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_event);
888: debug(' --> Base Rule = ' || p_base_rule_id, l_api_name, fnd_log.level_statement);
889: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
890: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
891: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
892: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);
893: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);
894: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);
895: DECLARE

Line 892: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);

888: debug(' --> Base Rule = ' || p_base_rule_id, l_api_name, fnd_log.level_statement);
889: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
890: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
891: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
892: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);
893: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);
894: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);
895: DECLARE
896: buffer VARCHAR2(8000);

Line 893: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);

889: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
890: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
891: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
892: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);
893: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);
894: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);
895: DECLARE
896: buffer VARCHAR2(8000);
897: BEGIN

Line 894: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);

890: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
891: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
892: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);
893: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);
894: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);
895: DECLARE
896: buffer VARCHAR2(8000);
897: BEGIN
898: DBMS_XMLDOM.WRITETOBUFFER(DBMS_XMLDOM.NEWDOMDOCUMENT(p_rule_doc), buffer);

Line 899: debug(' --> XML Doc#1 = ' || substr(buffer, 1, 3900), l_api_name, fnd_log.level_statement);

895: DECLARE
896: buffer VARCHAR2(8000);
897: BEGIN
898: DBMS_XMLDOM.WRITETOBUFFER(DBMS_XMLDOM.NEWDOMDOCUMENT(p_rule_doc), buffer);
899: debug(' --> XML Doc#1 = ' || substr(buffer, 1, 3900), l_api_name, fnd_log.level_statement);
900: debug(' --> XML Doc#2 = ' || substr(buffer, 3901, 3900), l_api_name, fnd_log.level_statement);
901: END;
902: END IF;
903:

Line 900: debug(' --> XML Doc#2 = ' || substr(buffer, 3901, 3900), l_api_name, fnd_log.level_statement);

896: buffer VARCHAR2(8000);
897: BEGIN
898: DBMS_XMLDOM.WRITETOBUFFER(DBMS_XMLDOM.NEWDOMDOCUMENT(p_rule_doc), buffer);
899: debug(' --> XML Doc#1 = ' || substr(buffer, 1, 3900), l_api_name, fnd_log.level_statement);
900: debug(' --> XML Doc#2 = ' || substr(buffer, 3901, 3900), l_api_name, fnd_log.level_statement);
901: END;
902: END IF;
903:
904: l_base_rule_id := p_base_rule_id;

Line 959: debug('Create Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);

955: ROLLBACK TO csr_rule_create;
956: x_return_status := fnd_api.g_ret_sts_error;
957: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
958: IF l_debug = 'Y' THEN
959: debug('Create Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);
960: END IF;
961: WHEN fnd_api.g_exc_unexpected_error THEN
962: ROLLBACK TO csr_rule_create;
963: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 966: debug('Create Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);

962: ROLLBACK TO csr_rule_create;
963: x_return_status := fnd_api.g_ret_sts_unexp_error;
964: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
965: IF l_debug = 'Y' THEN
966: debug('Create Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);
967: END IF;
968: WHEN OTHERS THEN
969: x_return_status := fnd_api.g_ret_sts_unexp_error;
970: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 976: debug('Create Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);

972: END IF;
973: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
974: ROLLBACK TO csr_rule_create;
975: IF l_debug = 'Y' THEN
976: debug('Create Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);
977: END IF;
978: END create_rule;
979:
980: PROCEDURE update_rule(

Line 1056: debug('Updating Rule#' || p_rule_id, l_api_name, fnd_log.level_event);

1052: -- Initialize Return Status
1053: x_return_status := fnd_api.g_ret_sts_success;
1054:
1055: IF l_debug = 'Y' THEN
1056: debug('Updating Rule#' || p_rule_id, l_api_name, fnd_log.level_event);
1057: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);
1058: debug(' --> OVN = ' || p_object_version_number, l_api_name, fnd_log.level_statement);
1059: debug(' --> Base Rule = ' || p_base_rule_id, l_api_name, fnd_log.level_statement);
1060: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);

Line 1057: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);

1053: x_return_status := fnd_api.g_ret_sts_success;
1054:
1055: IF l_debug = 'Y' THEN
1056: debug('Updating Rule#' || p_rule_id, l_api_name, fnd_log.level_event);
1057: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);
1058: debug(' --> OVN = ' || p_object_version_number, l_api_name, fnd_log.level_statement);
1059: debug(' --> Base Rule = ' || p_base_rule_id, l_api_name, fnd_log.level_statement);
1060: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
1061: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);

Line 1058: debug(' --> OVN = ' || p_object_version_number, l_api_name, fnd_log.level_statement);

1054:
1055: IF l_debug = 'Y' THEN
1056: debug('Updating Rule#' || p_rule_id, l_api_name, fnd_log.level_event);
1057: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);
1058: debug(' --> OVN = ' || p_object_version_number, l_api_name, fnd_log.level_statement);
1059: debug(' --> Base Rule = ' || p_base_rule_id, l_api_name, fnd_log.level_statement);
1060: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
1061: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
1062: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);

Line 1059: debug(' --> Base Rule = ' || p_base_rule_id, l_api_name, fnd_log.level_statement);

1055: IF l_debug = 'Y' THEN
1056: debug('Updating Rule#' || p_rule_id, l_api_name, fnd_log.level_event);
1057: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);
1058: debug(' --> OVN = ' || p_object_version_number, l_api_name, fnd_log.level_statement);
1059: debug(' --> Base Rule = ' || p_base_rule_id, l_api_name, fnd_log.level_statement);
1060: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
1061: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
1062: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
1063: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);

Line 1060: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);

1056: debug('Updating Rule#' || p_rule_id, l_api_name, fnd_log.level_event);
1057: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);
1058: debug(' --> OVN = ' || p_object_version_number, l_api_name, fnd_log.level_statement);
1059: debug(' --> Base Rule = ' || p_base_rule_id, l_api_name, fnd_log.level_statement);
1060: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
1061: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
1062: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
1063: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);
1064: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);

Line 1061: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);

1057: debug(' --> Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);
1058: debug(' --> OVN = ' || p_object_version_number, l_api_name, fnd_log.level_statement);
1059: debug(' --> Base Rule = ' || p_base_rule_id, l_api_name, fnd_log.level_statement);
1060: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
1061: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
1062: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
1063: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);
1064: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);
1065: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);

Line 1062: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);

1058: debug(' --> OVN = ' || p_object_version_number, l_api_name, fnd_log.level_statement);
1059: debug(' --> Base Rule = ' || p_base_rule_id, l_api_name, fnd_log.level_statement);
1060: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
1061: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
1062: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
1063: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);
1064: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);
1065: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);
1066: DECLARE

Line 1063: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);

1059: debug(' --> Base Rule = ' || p_base_rule_id, l_api_name, fnd_log.level_statement);
1060: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
1061: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
1062: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
1063: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);
1064: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);
1065: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);
1066: DECLARE
1067: buffer VARCHAR2(8000);

Line 1064: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);

1060: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_statement);
1061: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
1062: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
1063: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);
1064: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);
1065: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);
1066: DECLARE
1067: buffer VARCHAR2(8000);
1068: BEGIN

Line 1065: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);

1061: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_statement);
1062: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_statement);
1063: debug(' --> Terr ID = ' || p_terr_id, l_api_name, fnd_log.level_statement);
1064: debug(' --> Res Type = ' || p_resource_type, l_api_name, fnd_log.level_statement);
1065: debug(' --> Res ID = ' || p_resource_id, l_api_name, fnd_log.level_statement);
1066: DECLARE
1067: buffer VARCHAR2(8000);
1068: BEGIN
1069: DBMS_XMLDOM.WRITETOBUFFER(DBMS_XMLDOM.NEWDOMDOCUMENT(p_rule_doc), buffer);

Line 1070: debug(' --> XML Doc#1 = ' || substr(buffer, 1, 3900), l_api_name, fnd_log.level_statement);

1066: DECLARE
1067: buffer VARCHAR2(8000);
1068: BEGIN
1069: DBMS_XMLDOM.WRITETOBUFFER(DBMS_XMLDOM.NEWDOMDOCUMENT(p_rule_doc), buffer);
1070: debug(' --> XML Doc#1 = ' || substr(buffer, 1, 3900), l_api_name, fnd_log.level_statement);
1071: debug(' --> XML Doc#2 = ' || substr(buffer, 3901, 3900), l_api_name, fnd_log.level_statement);
1072: END;
1073: END IF;
1074:

Line 1071: debug(' --> XML Doc#2 = ' || substr(buffer, 3901, 3900), l_api_name, fnd_log.level_statement);

1067: buffer VARCHAR2(8000);
1068: BEGIN
1069: DBMS_XMLDOM.WRITETOBUFFER(DBMS_XMLDOM.NEWDOMDOCUMENT(p_rule_doc), buffer);
1070: debug(' --> XML Doc#1 = ' || substr(buffer, 1, 3900), l_api_name, fnd_log.level_statement);
1071: debug(' --> XML Doc#2 = ' || substr(buffer, 3901, 3900), l_api_name, fnd_log.level_statement);
1072: END;
1073: END IF;
1074:
1075: OPEN c_rule_details;

Line 1203: debug('Update Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);

1199: ROLLBACK TO csr_rule_update;
1200: x_return_status := fnd_api.g_ret_sts_error;
1201: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1202: IF l_debug = 'Y' THEN
1203: debug('Update Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);
1204: END IF;
1205: WHEN fnd_api.g_exc_unexpected_error THEN
1206: ROLLBACK TO csr_rule_update;
1207: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1210: debug('Update Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);

1206: ROLLBACK TO csr_rule_update;
1207: x_return_status := fnd_api.g_ret_sts_unexp_error;
1208: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1209: IF l_debug = 'Y' THEN
1210: debug('Update Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);
1211: END IF;
1212: WHEN OTHERS THEN
1213: x_return_status := fnd_api.g_ret_sts_unexp_error;
1214: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1220: debug('Update Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);

1216: END IF;
1217: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1218: ROLLBACK TO csr_rule_update;
1219: IF l_debug = 'Y' THEN
1220: debug('Update Rule Errored with ' || x_msg_data, l_api_name, fnd_log.level_error);
1221: END IF;
1222: END update_rule;
1223:
1224: PROCEDURE delete_rule(

Line 1267: debug('Deleting Rule#' || p_rule_id || ' and the entire hierarchy', l_api_name, fnd_log.level_event);

1263: -- Initialize Return Status
1264: x_return_status := fnd_api.g_ret_sts_success;
1265:
1266: IF l_debug = 'Y' THEN
1267: debug('Deleting Rule#' || p_rule_id || ' and the entire hierarchy', l_api_name, fnd_log.level_event);
1268: END IF;
1269:
1270:
1271: FOR v_child_rule IN c_child_rules LOOP

Line 1273: debug('Deleting Rule#' || v_child_rule.rule_id || ' based on ' || v_child_rule.base_rule_id || ' at level ' || v_child_rule.LEVEL, l_api_name, fnd_log.level_statement);

1269:
1270:
1271: FOR v_child_rule IN c_child_rules LOOP
1272: IF l_debug = 'Y' THEN
1273: debug('Deleting Rule#' || v_child_rule.rule_id || ' based on ' || v_child_rule.base_rule_id || ' at level ' || v_child_rule.LEVEL, l_api_name, fnd_log.level_statement);
1274: END IF;
1275:
1276: -- Delete all the Dependent Objects like Notes.
1277: FOR v_note IN c_rule_notes(v_child_rule.rule_id) LOOP

Line 1279: debug(' Deleting Notes #' || v_note.jtf_note_id, l_api_name, fnd_log.level_statement);

1275:
1276: -- Delete all the Dependent Objects like Notes.
1277: FOR v_note IN c_rule_notes(v_child_rule.rule_id) LOOP
1278: IF l_debug = 'Y' THEN
1279: debug(' Deleting Notes #' || v_note.jtf_note_id, l_api_name, fnd_log.level_statement);
1280: END IF;
1281: jtf_notes_pub.secure_delete_note(
1282: p_api_version => 1.0
1283: , x_return_status => x_return_status

Line 1371: debug('Getting Value of a Parameter:' || p_parameter_name, l_api_name, fnd_log.level_statement);

1367: ORDER BY rule_rank DESC;
1368: BEGIN
1369:
1370: IF l_debug = 'Y' THEN
1371: debug('Getting Value of a Parameter:' || p_parameter_name, l_api_name, fnd_log.level_statement);
1372: END IF;
1373:
1374: IF l_debug = 'Y' THEN
1375: debug('Input Parameters for the API are:' || p_parameter_name ||

Line 1381: ' p_resource_type' || p_resource_type , l_api_name, fnd_log.level_statement);

1377: ' p_resp_id' || p_resp_id ||
1378: ' p_user_id' || p_user_id ||
1379: ' p_terr_id' || p_terr_id ||
1380: ' p_resource_id' || p_resource_id ||
1381: ' p_resource_type' || p_resource_type , l_api_name, fnd_log.level_statement);
1382: END IF;
1383:
1384: IF p_parameter_name IS NULL THEN
1385: RETURN NULL;

Line 1405: debug('The Value of the Parameter:' || p_parameter_name || ' is: ' || l_param_value, l_api_name, fnd_log.level_statement);

1401: CLOSE c_matching_rules_terr;
1402: END IF;
1403:
1404: IF l_debug = 'Y' THEN
1405: debug('The Value of the Parameter:' || p_parameter_name || ' is: ' || l_param_value, l_api_name, fnd_log.level_statement);
1406: END IF;
1407:
1408: RETURN l_param_value;
1409: END get_sch_parameter_value;

Line 1489: debug('Getting Rules for given eligibility', l_api_name, fnd_log.level_event);

1485: -- Initialize Return Status
1486: x_return_status := fnd_api.g_ret_sts_success;
1487:
1488: IF l_debug = 'Y' THEN
1489: debug('Getting Rules for given eligibility', l_api_name, fnd_log.level_event);
1490: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_event);
1491: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_event);
1492: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_event);
1493: END IF;

Line 1490: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_event);

1486: x_return_status := fnd_api.g_ret_sts_success;
1487:
1488: IF l_debug = 'Y' THEN
1489: debug('Getting Rules for given eligibility', l_api_name, fnd_log.level_event);
1490: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_event);
1491: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_event);
1492: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_event);
1493: END IF;
1494:

Line 1491: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_event);

1487:
1488: IF l_debug = 'Y' THEN
1489: debug('Getting Rules for given eligibility', l_api_name, fnd_log.level_event);
1490: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_event);
1491: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_event);
1492: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_event);
1493: END IF;
1494:
1495: IF x_res_rules_tbl IS NULL THEN

Line 1492: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_event);

1488: IF l_debug = 'Y' THEN
1489: debug('Getting Rules for given eligibility', l_api_name, fnd_log.level_event);
1490: debug(' --> Appl ID = ' || p_appl_id, l_api_name, fnd_log.level_event);
1491: debug(' --> Resp ID = ' || p_resp_id, l_api_name, fnd_log.level_event);
1492: debug(' --> User ID = ' || p_user_id, l_api_name, fnd_log.level_event);
1493: END IF;
1494:
1495: IF x_res_rules_tbl IS NULL THEN
1496: x_res_rules_tbl := csr_resource_rules_tbl();

Line 1509: debug(' --> Terr ID = ' || l_res.terr_id, l_api_name, fnd_log.level_event);

1505: l_res := p_res_tbl(i);
1506: l_rule_tbl.DELETE;
1507:
1508: IF l_debug = 'Y' THEN
1509: debug(' --> Terr ID = ' || l_res.terr_id, l_api_name, fnd_log.level_event);
1510: debug(' --> Res Type = ' || l_res.resource_type, l_api_name, fnd_log.level_event);
1511: debug(' --> Res ID = ' || l_res.resource_id, l_api_name, fnd_log.level_event);
1512: END IF;
1513:

Line 1510: debug(' --> Res Type = ' || l_res.resource_type, l_api_name, fnd_log.level_event);

1506: l_rule_tbl.DELETE;
1507:
1508: IF l_debug = 'Y' THEN
1509: debug(' --> Terr ID = ' || l_res.terr_id, l_api_name, fnd_log.level_event);
1510: debug(' --> Res Type = ' || l_res.resource_type, l_api_name, fnd_log.level_event);
1511: debug(' --> Res ID = ' || l_res.resource_id, l_api_name, fnd_log.level_event);
1512: END IF;
1513:
1514: IF l_res.terr_id IS NOT NULL AND l_res.terr_id <> g_not_specified THEN

Line 1511: debug(' --> Res ID = ' || l_res.resource_id, l_api_name, fnd_log.level_event);

1507:
1508: IF l_debug = 'Y' THEN
1509: debug(' --> Terr ID = ' || l_res.terr_id, l_api_name, fnd_log.level_event);
1510: debug(' --> Res Type = ' || l_res.resource_type, l_api_name, fnd_log.level_event);
1511: debug(' --> Res ID = ' || l_res.resource_id, l_api_name, fnd_log.level_event);
1512: END IF;
1513:
1514: IF l_res.terr_id IS NOT NULL AND l_res.terr_id <> g_not_specified THEN
1515: OPEN c_rules FOR l_rules_with_terr_query USING l_res.terr_id, p_appl_id, p_resp_id, p_user_id, l_res.resource_type, l_res.resource_id;

Line 1525: debug(' ---> Fetched Rule with ID = ' || l_rule.rule_id || ' : Rank = ' || l_rule.rule_rank, l_api_name, fnd_log.level_statement);

1521: FETCH c_rules INTO l_rule;
1522: EXIT WHEN c_rules%NOTFOUND;
1523:
1524: IF l_debug = 'Y' THEN
1525: debug(' ---> Fetched Rule with ID = ' || l_rule.rule_id || ' : Rank = ' || l_rule.rule_rank, l_api_name, fnd_log.level_statement);
1526: END IF;
1527:
1528: l_rule_tbl.EXTEND;
1529: l_rule_tbl(l_rule_tbl.COUNT) :=

Line 1560: debug(' ---> Fetched Rule with ID = ' || l_rule.rule_id || ' : Rank = ' || l_rule.rule_rank, l_api_name, fnd_log.level_statement);

1556: FETCH c_rules INTO l_rule;
1557: EXIT WHEN c_rules%NOTFOUND;
1558:
1559: IF l_debug = 'Y' THEN
1560: debug(' ---> Fetched Rule with ID = ' || l_rule.rule_id || ' : Rank = ' || l_rule.rule_rank, l_api_name, fnd_log.level_statement);
1561: END IF;
1562:
1563: l_rule_tbl.EXTEND;
1564: l_rule_tbl(l_rule_tbl.COUNT) :=

Line 1699: debug('Processing WebADI Action ' || p_action || ' for RuleID = ' || p_rule_id || ' with OVN = ' || p_object_version_number, l_api_name, fnd_log.level_event);

1695: l_rule c_rule_details%ROWTYPE;
1696: l_new_rule_doc CLOB;
1697: BEGIN
1698: IF l_debug = 'Y' THEN
1699: debug('Processing WebADI Action ' || p_action || ' for RuleID = ' || p_rule_id || ' with OVN = ' || p_object_version_number, l_api_name, fnd_log.level_event);
1700: debug(' --> Parameter : Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);
1701: debug(' --> Parameter : Description = ' || p_description, l_api_name, fnd_log.level_statement);
1702: debug(' --> Parameter : Plan Scope = ' || p_sp_plan_scope, l_api_name, fnd_log.level_statement);
1703: debug(' --> Parameter : Max Plan Options = ' || p_sp_max_plan_options, l_api_name, fnd_log.level_statement);

Line 1700: debug(' --> Parameter : Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);

1696: l_new_rule_doc CLOB;
1697: BEGIN
1698: IF l_debug = 'Y' THEN
1699: debug('Processing WebADI Action ' || p_action || ' for RuleID = ' || p_rule_id || ' with OVN = ' || p_object_version_number, l_api_name, fnd_log.level_event);
1700: debug(' --> Parameter : Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);
1701: debug(' --> Parameter : Description = ' || p_description, l_api_name, fnd_log.level_statement);
1702: debug(' --> Parameter : Plan Scope = ' || p_sp_plan_scope, l_api_name, fnd_log.level_statement);
1703: debug(' --> Parameter : Max Plan Options = ' || p_sp_max_plan_options, l_api_name, fnd_log.level_statement);
1704: debug(' --> Parameter : Max Resources = ' || p_sp_max_resources, l_api_name, fnd_log.level_statement);

Line 1701: debug(' --> Parameter : Description = ' || p_description, l_api_name, fnd_log.level_statement);

1697: BEGIN
1698: IF l_debug = 'Y' THEN
1699: debug('Processing WebADI Action ' || p_action || ' for RuleID = ' || p_rule_id || ' with OVN = ' || p_object_version_number, l_api_name, fnd_log.level_event);
1700: debug(' --> Parameter : Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);
1701: debug(' --> Parameter : Description = ' || p_description, l_api_name, fnd_log.level_statement);
1702: debug(' --> Parameter : Plan Scope = ' || p_sp_plan_scope, l_api_name, fnd_log.level_statement);
1703: debug(' --> Parameter : Max Plan Options = ' || p_sp_max_plan_options, l_api_name, fnd_log.level_statement);
1704: debug(' --> Parameter : Max Resources = ' || p_sp_max_resources, l_api_name, fnd_log.level_statement);
1705: debug(' --> Parameter : Max Calc Time = ' || p_sp_max_calc_time, l_api_name, fnd_log.level_statement);

Line 1702: debug(' --> Parameter : Plan Scope = ' || p_sp_plan_scope, l_api_name, fnd_log.level_statement);

1698: IF l_debug = 'Y' THEN
1699: debug('Processing WebADI Action ' || p_action || ' for RuleID = ' || p_rule_id || ' with OVN = ' || p_object_version_number, l_api_name, fnd_log.level_event);
1700: debug(' --> Parameter : Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);
1701: debug(' --> Parameter : Description = ' || p_description, l_api_name, fnd_log.level_statement);
1702: debug(' --> Parameter : Plan Scope = ' || p_sp_plan_scope, l_api_name, fnd_log.level_statement);
1703: debug(' --> Parameter : Max Plan Options = ' || p_sp_max_plan_options, l_api_name, fnd_log.level_statement);
1704: debug(' --> Parameter : Max Resources = ' || p_sp_max_resources, l_api_name, fnd_log.level_statement);
1705: debug(' --> Parameter : Max Calc Time = ' || p_sp_max_calc_time, l_api_name, fnd_log.level_statement);
1706: debug(' --> Parameter : Max Overtime = ' || p_sp_max_overtime, l_api_name, fnd_log.level_statement);

Line 1703: debug(' --> Parameter : Max Plan Options = ' || p_sp_max_plan_options, l_api_name, fnd_log.level_statement);

1699: debug('Processing WebADI Action ' || p_action || ' for RuleID = ' || p_rule_id || ' with OVN = ' || p_object_version_number, l_api_name, fnd_log.level_event);
1700: debug(' --> Parameter : Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);
1701: debug(' --> Parameter : Description = ' || p_description, l_api_name, fnd_log.level_statement);
1702: debug(' --> Parameter : Plan Scope = ' || p_sp_plan_scope, l_api_name, fnd_log.level_statement);
1703: debug(' --> Parameter : Max Plan Options = ' || p_sp_max_plan_options, l_api_name, fnd_log.level_statement);
1704: debug(' --> Parameter : Max Resources = ' || p_sp_max_resources, l_api_name, fnd_log.level_statement);
1705: debug(' --> Parameter : Max Calc Time = ' || p_sp_max_calc_time, l_api_name, fnd_log.level_statement);
1706: debug(' --> Parameter : Max Overtime = ' || p_sp_max_overtime, l_api_name, fnd_log.level_statement);
1707: debug(' --> Parameter : Wtp Threshold = ' || p_sp_wtp_threshold, l_api_name, fnd_log.level_statement);

Line 1704: debug(' --> Parameter : Max Resources = ' || p_sp_max_resources, l_api_name, fnd_log.level_statement);

1700: debug(' --> Parameter : Rule Name = ' || p_rule_name, l_api_name, fnd_log.level_statement);
1701: debug(' --> Parameter : Description = ' || p_description, l_api_name, fnd_log.level_statement);
1702: debug(' --> Parameter : Plan Scope = ' || p_sp_plan_scope, l_api_name, fnd_log.level_statement);
1703: debug(' --> Parameter : Max Plan Options = ' || p_sp_max_plan_options, l_api_name, fnd_log.level_statement);
1704: debug(' --> Parameter : Max Resources = ' || p_sp_max_resources, l_api_name, fnd_log.level_statement);
1705: debug(' --> Parameter : Max Calc Time = ' || p_sp_max_calc_time, l_api_name, fnd_log.level_statement);
1706: debug(' --> Parameter : Max Overtime = ' || p_sp_max_overtime, l_api_name, fnd_log.level_statement);
1707: debug(' --> Parameter : Wtp Threshold = ' || p_sp_wtp_threshold, l_api_name, fnd_log.level_statement);
1708: debug(' --> Parameter : Enforce Plan Window = ' || p_sp_enforce_plan_window, l_api_name, fnd_log.level_statement);

Line 1705: debug(' --> Parameter : Max Calc Time = ' || p_sp_max_calc_time, l_api_name, fnd_log.level_statement);

1701: debug(' --> Parameter : Description = ' || p_description, l_api_name, fnd_log.level_statement);
1702: debug(' --> Parameter : Plan Scope = ' || p_sp_plan_scope, l_api_name, fnd_log.level_statement);
1703: debug(' --> Parameter : Max Plan Options = ' || p_sp_max_plan_options, l_api_name, fnd_log.level_statement);
1704: debug(' --> Parameter : Max Resources = ' || p_sp_max_resources, l_api_name, fnd_log.level_statement);
1705: debug(' --> Parameter : Max Calc Time = ' || p_sp_max_calc_time, l_api_name, fnd_log.level_statement);
1706: debug(' --> Parameter : Max Overtime = ' || p_sp_max_overtime, l_api_name, fnd_log.level_statement);
1707: debug(' --> Parameter : Wtp Threshold = ' || p_sp_wtp_threshold, l_api_name, fnd_log.level_statement);
1708: debug(' --> Parameter : Enforce Plan Window = ' || p_sp_enforce_plan_window, l_api_name, fnd_log.level_statement);
1709: debug(' --> Parameter : Consider Standby Shifts = ' || p_sp_consider_standby_shifts, l_api_name, fnd_log.level_statement);

Line 1706: debug(' --> Parameter : Max Overtime = ' || p_sp_max_overtime, l_api_name, fnd_log.level_statement);

1702: debug(' --> Parameter : Plan Scope = ' || p_sp_plan_scope, l_api_name, fnd_log.level_statement);
1703: debug(' --> Parameter : Max Plan Options = ' || p_sp_max_plan_options, l_api_name, fnd_log.level_statement);
1704: debug(' --> Parameter : Max Resources = ' || p_sp_max_resources, l_api_name, fnd_log.level_statement);
1705: debug(' --> Parameter : Max Calc Time = ' || p_sp_max_calc_time, l_api_name, fnd_log.level_statement);
1706: debug(' --> Parameter : Max Overtime = ' || p_sp_max_overtime, l_api_name, fnd_log.level_statement);
1707: debug(' --> Parameter : Wtp Threshold = ' || p_sp_wtp_threshold, l_api_name, fnd_log.level_statement);
1708: debug(' --> Parameter : Enforce Plan Window = ' || p_sp_enforce_plan_window, l_api_name, fnd_log.level_statement);
1709: debug(' --> Parameter : Consider Standby Shifts = ' || p_sp_consider_standby_shifts, l_api_name, fnd_log.level_statement);
1710: debug(' --> Parameter : Spares Mandatory = ' || p_sp_spares_mandatory, l_api_name, fnd_log.level_statement);

Line 1707: debug(' --> Parameter : Wtp Threshold = ' || p_sp_wtp_threshold, l_api_name, fnd_log.level_statement);

1703: debug(' --> Parameter : Max Plan Options = ' || p_sp_max_plan_options, l_api_name, fnd_log.level_statement);
1704: debug(' --> Parameter : Max Resources = ' || p_sp_max_resources, l_api_name, fnd_log.level_statement);
1705: debug(' --> Parameter : Max Calc Time = ' || p_sp_max_calc_time, l_api_name, fnd_log.level_statement);
1706: debug(' --> Parameter : Max Overtime = ' || p_sp_max_overtime, l_api_name, fnd_log.level_statement);
1707: debug(' --> Parameter : Wtp Threshold = ' || p_sp_wtp_threshold, l_api_name, fnd_log.level_statement);
1708: debug(' --> Parameter : Enforce Plan Window = ' || p_sp_enforce_plan_window, l_api_name, fnd_log.level_statement);
1709: debug(' --> Parameter : Consider Standby Shifts = ' || p_sp_consider_standby_shifts, l_api_name, fnd_log.level_statement);
1710: debug(' --> Parameter : Spares Mandatory = ' || p_sp_spares_mandatory, l_api_name, fnd_log.level_statement);
1711: debug(' --> Parameter : Spares Source = ' || p_sp_spares_source, l_api_name, fnd_log.level_statement);

Line 1708: debug(' --> Parameter : Enforce Plan Window = ' || p_sp_enforce_plan_window, l_api_name, fnd_log.level_statement);

1704: debug(' --> Parameter : Max Resources = ' || p_sp_max_resources, l_api_name, fnd_log.level_statement);
1705: debug(' --> Parameter : Max Calc Time = ' || p_sp_max_calc_time, l_api_name, fnd_log.level_statement);
1706: debug(' --> Parameter : Max Overtime = ' || p_sp_max_overtime, l_api_name, fnd_log.level_statement);
1707: debug(' --> Parameter : Wtp Threshold = ' || p_sp_wtp_threshold, l_api_name, fnd_log.level_statement);
1708: debug(' --> Parameter : Enforce Plan Window = ' || p_sp_enforce_plan_window, l_api_name, fnd_log.level_statement);
1709: debug(' --> Parameter : Consider Standby Shifts = ' || p_sp_consider_standby_shifts, l_api_name, fnd_log.level_statement);
1710: debug(' --> Parameter : Spares Mandatory = ' || p_sp_spares_mandatory, l_api_name, fnd_log.level_statement);
1711: debug(' --> Parameter : Spares Source = ' || p_sp_spares_source, l_api_name, fnd_log.level_statement);
1712: debug(' --> Parameter : Min Task Length = ' || p_sp_min_task_length, l_api_name, fnd_log.level_statement);

Line 1709: debug(' --> Parameter : Consider Standby Shifts = ' || p_sp_consider_standby_shifts, l_api_name, fnd_log.level_statement);

1705: debug(' --> Parameter : Max Calc Time = ' || p_sp_max_calc_time, l_api_name, fnd_log.level_statement);
1706: debug(' --> Parameter : Max Overtime = ' || p_sp_max_overtime, l_api_name, fnd_log.level_statement);
1707: debug(' --> Parameter : Wtp Threshold = ' || p_sp_wtp_threshold, l_api_name, fnd_log.level_statement);
1708: debug(' --> Parameter : Enforce Plan Window = ' || p_sp_enforce_plan_window, l_api_name, fnd_log.level_statement);
1709: debug(' --> Parameter : Consider Standby Shifts = ' || p_sp_consider_standby_shifts, l_api_name, fnd_log.level_statement);
1710: debug(' --> Parameter : Spares Mandatory = ' || p_sp_spares_mandatory, l_api_name, fnd_log.level_statement);
1711: debug(' --> Parameter : Spares Source = ' || p_sp_spares_source, l_api_name, fnd_log.level_statement);
1712: debug(' --> Parameter : Min Task Length = ' || p_sp_min_task_length, l_api_name, fnd_log.level_statement);
1713: debug(' --> Parameter : Default Shift Duration = ' || p_sp_default_shift_duration, l_api_name, fnd_log.level_statement);

Line 1710: debug(' --> Parameter : Spares Mandatory = ' || p_sp_spares_mandatory, l_api_name, fnd_log.level_statement);

1706: debug(' --> Parameter : Max Overtime = ' || p_sp_max_overtime, l_api_name, fnd_log.level_statement);
1707: debug(' --> Parameter : Wtp Threshold = ' || p_sp_wtp_threshold, l_api_name, fnd_log.level_statement);
1708: debug(' --> Parameter : Enforce Plan Window = ' || p_sp_enforce_plan_window, l_api_name, fnd_log.level_statement);
1709: debug(' --> Parameter : Consider Standby Shifts = ' || p_sp_consider_standby_shifts, l_api_name, fnd_log.level_statement);
1710: debug(' --> Parameter : Spares Mandatory = ' || p_sp_spares_mandatory, l_api_name, fnd_log.level_statement);
1711: debug(' --> Parameter : Spares Source = ' || p_sp_spares_source, l_api_name, fnd_log.level_statement);
1712: debug(' --> Parameter : Min Task Length = ' || p_sp_min_task_length, l_api_name, fnd_log.level_statement);
1713: debug(' --> Parameter : Default Shift Duration = ' || p_sp_default_shift_duration, l_api_name, fnd_log.level_statement);
1714: debug(' --> Parameter : Dist Last Child Effort = ' || p_sp_dist_last_child_effort, l_api_name, fnd_log.level_statement);

Line 1711: debug(' --> Parameter : Spares Source = ' || p_sp_spares_source, l_api_name, fnd_log.level_statement);

1707: debug(' --> Parameter : Wtp Threshold = ' || p_sp_wtp_threshold, l_api_name, fnd_log.level_statement);
1708: debug(' --> Parameter : Enforce Plan Window = ' || p_sp_enforce_plan_window, l_api_name, fnd_log.level_statement);
1709: debug(' --> Parameter : Consider Standby Shifts = ' || p_sp_consider_standby_shifts, l_api_name, fnd_log.level_statement);
1710: debug(' --> Parameter : Spares Mandatory = ' || p_sp_spares_mandatory, l_api_name, fnd_log.level_statement);
1711: debug(' --> Parameter : Spares Source = ' || p_sp_spares_source, l_api_name, fnd_log.level_statement);
1712: debug(' --> Parameter : Min Task Length = ' || p_sp_min_task_length, l_api_name, fnd_log.level_statement);
1713: debug(' --> Parameter : Default Shift Duration = ' || p_sp_default_shift_duration, l_api_name, fnd_log.level_statement);
1714: debug(' --> Parameter : Dist Last Child Effort = ' || p_sp_dist_last_child_effort, l_api_name, fnd_log.level_statement);
1715: debug(' --> Parameter : Pick Contract Resources = ' || p_sp_pick_contract_resources, l_api_name, fnd_log.level_statement);

Line 1712: debug(' --> Parameter : Min Task Length = ' || p_sp_min_task_length, l_api_name, fnd_log.level_statement);

1708: debug(' --> Parameter : Enforce Plan Window = ' || p_sp_enforce_plan_window, l_api_name, fnd_log.level_statement);
1709: debug(' --> Parameter : Consider Standby Shifts = ' || p_sp_consider_standby_shifts, l_api_name, fnd_log.level_statement);
1710: debug(' --> Parameter : Spares Mandatory = ' || p_sp_spares_mandatory, l_api_name, fnd_log.level_statement);
1711: debug(' --> Parameter : Spares Source = ' || p_sp_spares_source, l_api_name, fnd_log.level_statement);
1712: debug(' --> Parameter : Min Task Length = ' || p_sp_min_task_length, l_api_name, fnd_log.level_statement);
1713: debug(' --> Parameter : Default Shift Duration = ' || p_sp_default_shift_duration, l_api_name, fnd_log.level_statement);
1714: debug(' --> Parameter : Dist Last Child Effort = ' || p_sp_dist_last_child_effort, l_api_name, fnd_log.level_statement);
1715: debug(' --> Parameter : Pick Contract Resources = ' || p_sp_pick_contract_resources, l_api_name, fnd_log.level_statement);
1716: debug(' --> Parameter : Pick IB Resources = ' || p_sp_pick_ib_resources, l_api_name, fnd_log.level_statement);

Line 1713: debug(' --> Parameter : Default Shift Duration = ' || p_sp_default_shift_duration, l_api_name, fnd_log.level_statement);

1709: debug(' --> Parameter : Consider Standby Shifts = ' || p_sp_consider_standby_shifts, l_api_name, fnd_log.level_statement);
1710: debug(' --> Parameter : Spares Mandatory = ' || p_sp_spares_mandatory, l_api_name, fnd_log.level_statement);
1711: debug(' --> Parameter : Spares Source = ' || p_sp_spares_source, l_api_name, fnd_log.level_statement);
1712: debug(' --> Parameter : Min Task Length = ' || p_sp_min_task_length, l_api_name, fnd_log.level_statement);
1713: debug(' --> Parameter : Default Shift Duration = ' || p_sp_default_shift_duration, l_api_name, fnd_log.level_statement);
1714: debug(' --> Parameter : Dist Last Child Effort = ' || p_sp_dist_last_child_effort, l_api_name, fnd_log.level_statement);
1715: debug(' --> Parameter : Pick Contract Resources = ' || p_sp_pick_contract_resources, l_api_name, fnd_log.level_statement);
1716: debug(' --> Parameter : Pick IB Resources = ' || p_sp_pick_ib_resources, l_api_name, fnd_log.level_statement);
1717: debug(' --> Parameter : Pick Territory Resources = ' || p_sp_pick_territory_resources, l_api_name, fnd_log.level_statement);

Line 1714: debug(' --> Parameter : Dist Last Child Effort = ' || p_sp_dist_last_child_effort, l_api_name, fnd_log.level_statement);

1710: debug(' --> Parameter : Spares Mandatory = ' || p_sp_spares_mandatory, l_api_name, fnd_log.level_statement);
1711: debug(' --> Parameter : Spares Source = ' || p_sp_spares_source, l_api_name, fnd_log.level_statement);
1712: debug(' --> Parameter : Min Task Length = ' || p_sp_min_task_length, l_api_name, fnd_log.level_statement);
1713: debug(' --> Parameter : Default Shift Duration = ' || p_sp_default_shift_duration, l_api_name, fnd_log.level_statement);
1714: debug(' --> Parameter : Dist Last Child Effort = ' || p_sp_dist_last_child_effort, l_api_name, fnd_log.level_statement);
1715: debug(' --> Parameter : Pick Contract Resources = ' || p_sp_pick_contract_resources, l_api_name, fnd_log.level_statement);
1716: debug(' --> Parameter : Pick IB Resources = ' || p_sp_pick_ib_resources, l_api_name, fnd_log.level_statement);
1717: debug(' --> Parameter : Pick Territory Resources = ' || p_sp_pick_territory_resources, l_api_name, fnd_log.level_statement);
1718: debug(' --> Parameter : Pick Skilled Resources = ' || p_sp_pick_skilled_resources, l_api_name, fnd_log.level_statement);

Line 1715: debug(' --> Parameter : Pick Contract Resources = ' || p_sp_pick_contract_resources, l_api_name, fnd_log.level_statement);

1711: debug(' --> Parameter : Spares Source = ' || p_sp_spares_source, l_api_name, fnd_log.level_statement);
1712: debug(' --> Parameter : Min Task Length = ' || p_sp_min_task_length, l_api_name, fnd_log.level_statement);
1713: debug(' --> Parameter : Default Shift Duration = ' || p_sp_default_shift_duration, l_api_name, fnd_log.level_statement);
1714: debug(' --> Parameter : Dist Last Child Effort = ' || p_sp_dist_last_child_effort, l_api_name, fnd_log.level_statement);
1715: debug(' --> Parameter : Pick Contract Resources = ' || p_sp_pick_contract_resources, l_api_name, fnd_log.level_statement);
1716: debug(' --> Parameter : Pick IB Resources = ' || p_sp_pick_ib_resources, l_api_name, fnd_log.level_statement);
1717: debug(' --> Parameter : Pick Territory Resources = ' || p_sp_pick_territory_resources, l_api_name, fnd_log.level_statement);
1718: debug(' --> Parameter : Pick Skilled Resources = ' || p_sp_pick_skilled_resources, l_api_name, fnd_log.level_statement);
1719: debug(' --> Parameter : Auto Sch Default Query = ' || p_sp_auto_sch_default_query, l_api_name, fnd_log.level_statement);

Line 1716: debug(' --> Parameter : Pick IB Resources = ' || p_sp_pick_ib_resources, l_api_name, fnd_log.level_statement);

1712: debug(' --> Parameter : Min Task Length = ' || p_sp_min_task_length, l_api_name, fnd_log.level_statement);
1713: debug(' --> Parameter : Default Shift Duration = ' || p_sp_default_shift_duration, l_api_name, fnd_log.level_statement);
1714: debug(' --> Parameter : Dist Last Child Effort = ' || p_sp_dist_last_child_effort, l_api_name, fnd_log.level_statement);
1715: debug(' --> Parameter : Pick Contract Resources = ' || p_sp_pick_contract_resources, l_api_name, fnd_log.level_statement);
1716: debug(' --> Parameter : Pick IB Resources = ' || p_sp_pick_ib_resources, l_api_name, fnd_log.level_statement);
1717: debug(' --> Parameter : Pick Territory Resources = ' || p_sp_pick_territory_resources, l_api_name, fnd_log.level_statement);
1718: debug(' --> Parameter : Pick Skilled Resources = ' || p_sp_pick_skilled_resources, l_api_name, fnd_log.level_statement);
1719: debug(' --> Parameter : Auto Sch Default Query = ' || p_sp_auto_sch_default_query, l_api_name, fnd_log.level_statement);
1720: debug(' --> Parameter : Auto Reject Sts Id Spares = ' || p_sp_auto_reject_sts_id_spares, l_api_name, fnd_log.level_statement);

Line 1717: debug(' --> Parameter : Pick Territory Resources = ' || p_sp_pick_territory_resources, l_api_name, fnd_log.level_statement);

1713: debug(' --> Parameter : Default Shift Duration = ' || p_sp_default_shift_duration, l_api_name, fnd_log.level_statement);
1714: debug(' --> Parameter : Dist Last Child Effort = ' || p_sp_dist_last_child_effort, l_api_name, fnd_log.level_statement);
1715: debug(' --> Parameter : Pick Contract Resources = ' || p_sp_pick_contract_resources, l_api_name, fnd_log.level_statement);
1716: debug(' --> Parameter : Pick IB Resources = ' || p_sp_pick_ib_resources, l_api_name, fnd_log.level_statement);
1717: debug(' --> Parameter : Pick Territory Resources = ' || p_sp_pick_territory_resources, l_api_name, fnd_log.level_statement);
1718: debug(' --> Parameter : Pick Skilled Resources = ' || p_sp_pick_skilled_resources, l_api_name, fnd_log.level_statement);
1719: debug(' --> Parameter : Auto Sch Default Query = ' || p_sp_auto_sch_default_query, l_api_name, fnd_log.level_statement);
1720: debug(' --> Parameter : Auto Reject Sts Id Spares = ' || p_sp_auto_reject_sts_id_spares, l_api_name, fnd_log.level_statement);
1721: debug(' --> Parameter : Auto Reject Sts Id Others = ' || p_sp_auto_reject_sts_id_others, l_api_name, fnd_log.level_statement);

Line 1718: debug(' --> Parameter : Pick Skilled Resources = ' || p_sp_pick_skilled_resources, l_api_name, fnd_log.level_statement);

1714: debug(' --> Parameter : Dist Last Child Effort = ' || p_sp_dist_last_child_effort, l_api_name, fnd_log.level_statement);
1715: debug(' --> Parameter : Pick Contract Resources = ' || p_sp_pick_contract_resources, l_api_name, fnd_log.level_statement);
1716: debug(' --> Parameter : Pick IB Resources = ' || p_sp_pick_ib_resources, l_api_name, fnd_log.level_statement);
1717: debug(' --> Parameter : Pick Territory Resources = ' || p_sp_pick_territory_resources, l_api_name, fnd_log.level_statement);
1718: debug(' --> Parameter : Pick Skilled Resources = ' || p_sp_pick_skilled_resources, l_api_name, fnd_log.level_statement);
1719: debug(' --> Parameter : Auto Sch Default Query = ' || p_sp_auto_sch_default_query, l_api_name, fnd_log.level_statement);
1720: debug(' --> Parameter : Auto Reject Sts Id Spares = ' || p_sp_auto_reject_sts_id_spares, l_api_name, fnd_log.level_statement);
1721: debug(' --> Parameter : Auto Reject Sts Id Others = ' || p_sp_auto_reject_sts_id_others, l_api_name, fnd_log.level_statement);
1722: debug(' --> Parameter : Force Optimizer To Group = ' || p_sp_force_optimizer_to_group, l_api_name, fnd_log.level_statement);

Line 1719: debug(' --> Parameter : Auto Sch Default Query = ' || p_sp_auto_sch_default_query, l_api_name, fnd_log.level_statement);

1715: debug(' --> Parameter : Pick Contract Resources = ' || p_sp_pick_contract_resources, l_api_name, fnd_log.level_statement);
1716: debug(' --> Parameter : Pick IB Resources = ' || p_sp_pick_ib_resources, l_api_name, fnd_log.level_statement);
1717: debug(' --> Parameter : Pick Territory Resources = ' || p_sp_pick_territory_resources, l_api_name, fnd_log.level_statement);
1718: debug(' --> Parameter : Pick Skilled Resources = ' || p_sp_pick_skilled_resources, l_api_name, fnd_log.level_statement);
1719: debug(' --> Parameter : Auto Sch Default Query = ' || p_sp_auto_sch_default_query, l_api_name, fnd_log.level_statement);
1720: debug(' --> Parameter : Auto Reject Sts Id Spares = ' || p_sp_auto_reject_sts_id_spares, l_api_name, fnd_log.level_statement);
1721: debug(' --> Parameter : Auto Reject Sts Id Others = ' || p_sp_auto_reject_sts_id_others, l_api_name, fnd_log.level_statement);
1722: debug(' --> Parameter : Force Optimizer To Group = ' || p_sp_force_optimizer_to_group, l_api_name, fnd_log.level_statement);
1723: debug(' --> Parameter : Optimizer Success Perc = ' || p_sp_optimizer_success_perc, l_api_name, fnd_log.level_statement);

Line 1720: debug(' --> Parameter : Auto Reject Sts Id Spares = ' || p_sp_auto_reject_sts_id_spares, l_api_name, fnd_log.level_statement);

1716: debug(' --> Parameter : Pick IB Resources = ' || p_sp_pick_ib_resources, l_api_name, fnd_log.level_statement);
1717: debug(' --> Parameter : Pick Territory Resources = ' || p_sp_pick_territory_resources, l_api_name, fnd_log.level_statement);
1718: debug(' --> Parameter : Pick Skilled Resources = ' || p_sp_pick_skilled_resources, l_api_name, fnd_log.level_statement);
1719: debug(' --> Parameter : Auto Sch Default Query = ' || p_sp_auto_sch_default_query, l_api_name, fnd_log.level_statement);
1720: debug(' --> Parameter : Auto Reject Sts Id Spares = ' || p_sp_auto_reject_sts_id_spares, l_api_name, fnd_log.level_statement);
1721: debug(' --> Parameter : Auto Reject Sts Id Others = ' || p_sp_auto_reject_sts_id_others, l_api_name, fnd_log.level_statement);
1722: debug(' --> Parameter : Force Optimizer To Group = ' || p_sp_force_optimizer_to_group, l_api_name, fnd_log.level_statement);
1723: debug(' --> Parameter : Optimizer Success Perc = ' || p_sp_optimizer_success_perc, l_api_name, fnd_log.level_statement);
1724: debug(' --> Parameter : Commutes Position = ' || p_sp_commutes_position, l_api_name, fnd_log.level_statement);

Line 1721: debug(' --> Parameter : Auto Reject Sts Id Others = ' || p_sp_auto_reject_sts_id_others, l_api_name, fnd_log.level_statement);

1717: debug(' --> Parameter : Pick Territory Resources = ' || p_sp_pick_territory_resources, l_api_name, fnd_log.level_statement);
1718: debug(' --> Parameter : Pick Skilled Resources = ' || p_sp_pick_skilled_resources, l_api_name, fnd_log.level_statement);
1719: debug(' --> Parameter : Auto Sch Default Query = ' || p_sp_auto_sch_default_query, l_api_name, fnd_log.level_statement);
1720: debug(' --> Parameter : Auto Reject Sts Id Spares = ' || p_sp_auto_reject_sts_id_spares, l_api_name, fnd_log.level_statement);
1721: debug(' --> Parameter : Auto Reject Sts Id Others = ' || p_sp_auto_reject_sts_id_others, l_api_name, fnd_log.level_statement);
1722: debug(' --> Parameter : Force Optimizer To Group = ' || p_sp_force_optimizer_to_group, l_api_name, fnd_log.level_statement);
1723: debug(' --> Parameter : Optimizer Success Perc = ' || p_sp_optimizer_success_perc, l_api_name, fnd_log.level_statement);
1724: debug(' --> Parameter : Commutes Position = ' || p_sp_commutes_position, l_api_name, fnd_log.level_statement);
1725: debug(' --> Parameter : Commute Excluded Time = ' || p_sp_commute_excluded_time, l_api_name, fnd_log.level_statement);

Line 1722: debug(' --> Parameter : Force Optimizer To Group = ' || p_sp_force_optimizer_to_group, l_api_name, fnd_log.level_statement);

1718: debug(' --> Parameter : Pick Skilled Resources = ' || p_sp_pick_skilled_resources, l_api_name, fnd_log.level_statement);
1719: debug(' --> Parameter : Auto Sch Default Query = ' || p_sp_auto_sch_default_query, l_api_name, fnd_log.level_statement);
1720: debug(' --> Parameter : Auto Reject Sts Id Spares = ' || p_sp_auto_reject_sts_id_spares, l_api_name, fnd_log.level_statement);
1721: debug(' --> Parameter : Auto Reject Sts Id Others = ' || p_sp_auto_reject_sts_id_others, l_api_name, fnd_log.level_statement);
1722: debug(' --> Parameter : Force Optimizer To Group = ' || p_sp_force_optimizer_to_group, l_api_name, fnd_log.level_statement);
1723: debug(' --> Parameter : Optimizer Success Perc = ' || p_sp_optimizer_success_perc, l_api_name, fnd_log.level_statement);
1724: debug(' --> Parameter : Commutes Position = ' || p_sp_commutes_position, l_api_name, fnd_log.level_statement);
1725: debug(' --> Parameter : Commute Excluded Time = ' || p_sp_commute_excluded_time, l_api_name, fnd_log.level_statement);
1726: debug(' --> Parameter : Commute Home Empty Trip = ' || p_sp_commute_home_empty_trip, l_api_name, fnd_log.level_statement);

Line 1723: debug(' --> Parameter : Optimizer Success Perc = ' || p_sp_optimizer_success_perc, l_api_name, fnd_log.level_statement);

1719: debug(' --> Parameter : Auto Sch Default Query = ' || p_sp_auto_sch_default_query, l_api_name, fnd_log.level_statement);
1720: debug(' --> Parameter : Auto Reject Sts Id Spares = ' || p_sp_auto_reject_sts_id_spares, l_api_name, fnd_log.level_statement);
1721: debug(' --> Parameter : Auto Reject Sts Id Others = ' || p_sp_auto_reject_sts_id_others, l_api_name, fnd_log.level_statement);
1722: debug(' --> Parameter : Force Optimizer To Group = ' || p_sp_force_optimizer_to_group, l_api_name, fnd_log.level_statement);
1723: debug(' --> Parameter : Optimizer Success Perc = ' || p_sp_optimizer_success_perc, l_api_name, fnd_log.level_statement);
1724: debug(' --> Parameter : Commutes Position = ' || p_sp_commutes_position, l_api_name, fnd_log.level_statement);
1725: debug(' --> Parameter : Commute Excluded Time = ' || p_sp_commute_excluded_time, l_api_name, fnd_log.level_statement);
1726: debug(' --> Parameter : Commute Home Empty Trip = ' || p_sp_commute_home_empty_trip, l_api_name, fnd_log.level_statement);
1727: debug(' --> Parameter : Router Mode = ' || p_sp_router_mode, l_api_name, fnd_log.level_statement);

Line 1724: debug(' --> Parameter : Commutes Position = ' || p_sp_commutes_position, l_api_name, fnd_log.level_statement);

1720: debug(' --> Parameter : Auto Reject Sts Id Spares = ' || p_sp_auto_reject_sts_id_spares, l_api_name, fnd_log.level_statement);
1721: debug(' --> Parameter : Auto Reject Sts Id Others = ' || p_sp_auto_reject_sts_id_others, l_api_name, fnd_log.level_statement);
1722: debug(' --> Parameter : Force Optimizer To Group = ' || p_sp_force_optimizer_to_group, l_api_name, fnd_log.level_statement);
1723: debug(' --> Parameter : Optimizer Success Perc = ' || p_sp_optimizer_success_perc, l_api_name, fnd_log.level_statement);
1724: debug(' --> Parameter : Commutes Position = ' || p_sp_commutes_position, l_api_name, fnd_log.level_statement);
1725: debug(' --> Parameter : Commute Excluded Time = ' || p_sp_commute_excluded_time, l_api_name, fnd_log.level_statement);
1726: debug(' --> Parameter : Commute Home Empty Trip = ' || p_sp_commute_home_empty_trip, l_api_name, fnd_log.level_statement);
1727: debug(' --> Parameter : Router Mode = ' || p_sp_router_mode, l_api_name, fnd_log.level_statement);
1728: debug(' --> Parameter : Travel Time Extra = ' || p_sp_travel_time_extra, l_api_name, fnd_log.level_statement);

Line 1725: debug(' --> Parameter : Commute Excluded Time = ' || p_sp_commute_excluded_time, l_api_name, fnd_log.level_statement);

1721: debug(' --> Parameter : Auto Reject Sts Id Others = ' || p_sp_auto_reject_sts_id_others, l_api_name, fnd_log.level_statement);
1722: debug(' --> Parameter : Force Optimizer To Group = ' || p_sp_force_optimizer_to_group, l_api_name, fnd_log.level_statement);
1723: debug(' --> Parameter : Optimizer Success Perc = ' || p_sp_optimizer_success_perc, l_api_name, fnd_log.level_statement);
1724: debug(' --> Parameter : Commutes Position = ' || p_sp_commutes_position, l_api_name, fnd_log.level_statement);
1725: debug(' --> Parameter : Commute Excluded Time = ' || p_sp_commute_excluded_time, l_api_name, fnd_log.level_statement);
1726: debug(' --> Parameter : Commute Home Empty Trip = ' || p_sp_commute_home_empty_trip, l_api_name, fnd_log.level_statement);
1727: debug(' --> Parameter : Router Mode = ' || p_sp_router_mode, l_api_name, fnd_log.level_statement);
1728: debug(' --> Parameter : Travel Time Extra = ' || p_sp_travel_time_extra, l_api_name, fnd_log.level_statement);
1729: debug(' --> Parameter : Default Router Enabled = ' || p_sp_default_router_enabled, l_api_name, fnd_log.level_statement);

Line 1726: debug(' --> Parameter : Commute Home Empty Trip = ' || p_sp_commute_home_empty_trip, l_api_name, fnd_log.level_statement);

1722: debug(' --> Parameter : Force Optimizer To Group = ' || p_sp_force_optimizer_to_group, l_api_name, fnd_log.level_statement);
1723: debug(' --> Parameter : Optimizer Success Perc = ' || p_sp_optimizer_success_perc, l_api_name, fnd_log.level_statement);
1724: debug(' --> Parameter : Commutes Position = ' || p_sp_commutes_position, l_api_name, fnd_log.level_statement);
1725: debug(' --> Parameter : Commute Excluded Time = ' || p_sp_commute_excluded_time, l_api_name, fnd_log.level_statement);
1726: debug(' --> Parameter : Commute Home Empty Trip = ' || p_sp_commute_home_empty_trip, l_api_name, fnd_log.level_statement);
1727: debug(' --> Parameter : Router Mode = ' || p_sp_router_mode, l_api_name, fnd_log.level_statement);
1728: debug(' --> Parameter : Travel Time Extra = ' || p_sp_travel_time_extra, l_api_name, fnd_log.level_statement);
1729: debug(' --> Parameter : Default Router Enabled = ' || p_sp_default_router_enabled, l_api_name, fnd_log.level_statement);
1730: debug(' --> Parameter : Default Travel Distance = ' || p_sp_default_travel_distance, l_api_name, fnd_log.level_statement);

Line 1727: debug(' --> Parameter : Router Mode = ' || p_sp_router_mode, l_api_name, fnd_log.level_statement);

1723: debug(' --> Parameter : Optimizer Success Perc = ' || p_sp_optimizer_success_perc, l_api_name, fnd_log.level_statement);
1724: debug(' --> Parameter : Commutes Position = ' || p_sp_commutes_position, l_api_name, fnd_log.level_statement);
1725: debug(' --> Parameter : Commute Excluded Time = ' || p_sp_commute_excluded_time, l_api_name, fnd_log.level_statement);
1726: debug(' --> Parameter : Commute Home Empty Trip = ' || p_sp_commute_home_empty_trip, l_api_name, fnd_log.level_statement);
1727: debug(' --> Parameter : Router Mode = ' || p_sp_router_mode, l_api_name, fnd_log.level_statement);
1728: debug(' --> Parameter : Travel Time Extra = ' || p_sp_travel_time_extra, l_api_name, fnd_log.level_statement);
1729: debug(' --> Parameter : Default Router Enabled = ' || p_sp_default_router_enabled, l_api_name, fnd_log.level_statement);
1730: debug(' --> Parameter : Default Travel Distance = ' || p_sp_default_travel_distance, l_api_name, fnd_log.level_statement);
1731: debug(' --> Parameter : Default Travel Duration = ' || p_sp_default_travel_duration, l_api_name, fnd_log.level_statement);

Line 1728: debug(' --> Parameter : Travel Time Extra = ' || p_sp_travel_time_extra, l_api_name, fnd_log.level_statement);

1724: debug(' --> Parameter : Commutes Position = ' || p_sp_commutes_position, l_api_name, fnd_log.level_statement);
1725: debug(' --> Parameter : Commute Excluded Time = ' || p_sp_commute_excluded_time, l_api_name, fnd_log.level_statement);
1726: debug(' --> Parameter : Commute Home Empty Trip = ' || p_sp_commute_home_empty_trip, l_api_name, fnd_log.level_statement);
1727: debug(' --> Parameter : Router Mode = ' || p_sp_router_mode, l_api_name, fnd_log.level_statement);
1728: debug(' --> Parameter : Travel Time Extra = ' || p_sp_travel_time_extra, l_api_name, fnd_log.level_statement);
1729: debug(' --> Parameter : Default Router Enabled = ' || p_sp_default_router_enabled, l_api_name, fnd_log.level_statement);
1730: debug(' --> Parameter : Default Travel Distance = ' || p_sp_default_travel_distance, l_api_name, fnd_log.level_statement);
1731: debug(' --> Parameter : Default Travel Duration = ' || p_sp_default_travel_duration, l_api_name, fnd_log.level_statement);
1732: debug(' --> Parameter : Max Distance In Group = ' || p_sp_max_distance_in_group, l_api_name, fnd_log.level_statement);

Line 1729: debug(' --> Parameter : Default Router Enabled = ' || p_sp_default_router_enabled, l_api_name, fnd_log.level_statement);

1725: debug(' --> Parameter : Commute Excluded Time = ' || p_sp_commute_excluded_time, l_api_name, fnd_log.level_statement);
1726: debug(' --> Parameter : Commute Home Empty Trip = ' || p_sp_commute_home_empty_trip, l_api_name, fnd_log.level_statement);
1727: debug(' --> Parameter : Router Mode = ' || p_sp_router_mode, l_api_name, fnd_log.level_statement);
1728: debug(' --> Parameter : Travel Time Extra = ' || p_sp_travel_time_extra, l_api_name, fnd_log.level_statement);
1729: debug(' --> Parameter : Default Router Enabled = ' || p_sp_default_router_enabled, l_api_name, fnd_log.level_statement);
1730: debug(' --> Parameter : Default Travel Distance = ' || p_sp_default_travel_distance, l_api_name, fnd_log.level_statement);
1731: debug(' --> Parameter : Default Travel Duration = ' || p_sp_default_travel_duration, l_api_name, fnd_log.level_statement);
1732: debug(' --> Parameter : Max Distance In Group = ' || p_sp_max_distance_in_group, l_api_name, fnd_log.level_statement);
1733: debug(' --> Parameter : Max Dist To Skip Actual = ' || p_sp_max_dist_to_skip_actual, l_api_name, fnd_log.level_statement);

Line 1730: debug(' --> Parameter : Default Travel Distance = ' || p_sp_default_travel_distance, l_api_name, fnd_log.level_statement);

1726: debug(' --> Parameter : Commute Home Empty Trip = ' || p_sp_commute_home_empty_trip, l_api_name, fnd_log.level_statement);
1727: debug(' --> Parameter : Router Mode = ' || p_sp_router_mode, l_api_name, fnd_log.level_statement);
1728: debug(' --> Parameter : Travel Time Extra = ' || p_sp_travel_time_extra, l_api_name, fnd_log.level_statement);
1729: debug(' --> Parameter : Default Router Enabled = ' || p_sp_default_router_enabled, l_api_name, fnd_log.level_statement);
1730: debug(' --> Parameter : Default Travel Distance = ' || p_sp_default_travel_distance, l_api_name, fnd_log.level_statement);
1731: debug(' --> Parameter : Default Travel Duration = ' || p_sp_default_travel_duration, l_api_name, fnd_log.level_statement);
1732: debug(' --> Parameter : Max Distance In Group = ' || p_sp_max_distance_in_group, l_api_name, fnd_log.level_statement);
1733: debug(' --> Parameter : Max Dist To Skip Actual = ' || p_sp_max_dist_to_skip_actual, l_api_name, fnd_log.level_statement);
1734: debug(' --> Parameter : Router Calc Type = ' || p_rc_router_calc_type, l_api_name, fnd_log.level_statement);

Line 1731: debug(' --> Parameter : Default Travel Duration = ' || p_sp_default_travel_duration, l_api_name, fnd_log.level_statement);

1727: debug(' --> Parameter : Router Mode = ' || p_sp_router_mode, l_api_name, fnd_log.level_statement);
1728: debug(' --> Parameter : Travel Time Extra = ' || p_sp_travel_time_extra, l_api_name, fnd_log.level_statement);
1729: debug(' --> Parameter : Default Router Enabled = ' || p_sp_default_router_enabled, l_api_name, fnd_log.level_statement);
1730: debug(' --> Parameter : Default Travel Distance = ' || p_sp_default_travel_distance, l_api_name, fnd_log.level_statement);
1731: debug(' --> Parameter : Default Travel Duration = ' || p_sp_default_travel_duration, l_api_name, fnd_log.level_statement);
1732: debug(' --> Parameter : Max Distance In Group = ' || p_sp_max_distance_in_group, l_api_name, fnd_log.level_statement);
1733: debug(' --> Parameter : Max Dist To Skip Actual = ' || p_sp_max_dist_to_skip_actual, l_api_name, fnd_log.level_statement);
1734: debug(' --> Parameter : Router Calc Type = ' || p_rc_router_calc_type, l_api_name, fnd_log.level_statement);
1735: debug(' --> Parameter : Consider Toll Roads = ' || p_rc_consider_toll_roads, l_api_name, fnd_log.level_statement);

Line 1732: debug(' --> Parameter : Max Distance In Group = ' || p_sp_max_distance_in_group, l_api_name, fnd_log.level_statement);

1728: debug(' --> Parameter : Travel Time Extra = ' || p_sp_travel_time_extra, l_api_name, fnd_log.level_statement);
1729: debug(' --> Parameter : Default Router Enabled = ' || p_sp_default_router_enabled, l_api_name, fnd_log.level_statement);
1730: debug(' --> Parameter : Default Travel Distance = ' || p_sp_default_travel_distance, l_api_name, fnd_log.level_statement);
1731: debug(' --> Parameter : Default Travel Duration = ' || p_sp_default_travel_duration, l_api_name, fnd_log.level_statement);
1732: debug(' --> Parameter : Max Distance In Group = ' || p_sp_max_distance_in_group, l_api_name, fnd_log.level_statement);
1733: debug(' --> Parameter : Max Dist To Skip Actual = ' || p_sp_max_dist_to_skip_actual, l_api_name, fnd_log.level_statement);
1734: debug(' --> Parameter : Router Calc Type = ' || p_rc_router_calc_type, l_api_name, fnd_log.level_statement);
1735: debug(' --> Parameter : Consider Toll Roads = ' || p_rc_consider_toll_roads, l_api_name, fnd_log.level_statement);
1736: debug(' --> Parameter : Route Func Delay 0 = ' || p_rc_route_func_delay_0, l_api_name, fnd_log.level_statement);

Line 1733: debug(' --> Parameter : Max Dist To Skip Actual = ' || p_sp_max_dist_to_skip_actual, l_api_name, fnd_log.level_statement);

1729: debug(' --> Parameter : Default Router Enabled = ' || p_sp_default_router_enabled, l_api_name, fnd_log.level_statement);
1730: debug(' --> Parameter : Default Travel Distance = ' || p_sp_default_travel_distance, l_api_name, fnd_log.level_statement);
1731: debug(' --> Parameter : Default Travel Duration = ' || p_sp_default_travel_duration, l_api_name, fnd_log.level_statement);
1732: debug(' --> Parameter : Max Distance In Group = ' || p_sp_max_distance_in_group, l_api_name, fnd_log.level_statement);
1733: debug(' --> Parameter : Max Dist To Skip Actual = ' || p_sp_max_dist_to_skip_actual, l_api_name, fnd_log.level_statement);
1734: debug(' --> Parameter : Router Calc Type = ' || p_rc_router_calc_type, l_api_name, fnd_log.level_statement);
1735: debug(' --> Parameter : Consider Toll Roads = ' || p_rc_consider_toll_roads, l_api_name, fnd_log.level_statement);
1736: debug(' --> Parameter : Route Func Delay 0 = ' || p_rc_route_func_delay_0, l_api_name, fnd_log.level_statement);
1737: debug(' --> Parameter : Route Func Delay 1 = ' || p_rc_route_func_delay_1, l_api_name, fnd_log.level_statement);

Line 1734: debug(' --> Parameter : Router Calc Type = ' || p_rc_router_calc_type, l_api_name, fnd_log.level_statement);

1730: debug(' --> Parameter : Default Travel Distance = ' || p_sp_default_travel_distance, l_api_name, fnd_log.level_statement);
1731: debug(' --> Parameter : Default Travel Duration = ' || p_sp_default_travel_duration, l_api_name, fnd_log.level_statement);
1732: debug(' --> Parameter : Max Distance In Group = ' || p_sp_max_distance_in_group, l_api_name, fnd_log.level_statement);
1733: debug(' --> Parameter : Max Dist To Skip Actual = ' || p_sp_max_dist_to_skip_actual, l_api_name, fnd_log.level_statement);
1734: debug(' --> Parameter : Router Calc Type = ' || p_rc_router_calc_type, l_api_name, fnd_log.level_statement);
1735: debug(' --> Parameter : Consider Toll Roads = ' || p_rc_consider_toll_roads, l_api_name, fnd_log.level_statement);
1736: debug(' --> Parameter : Route Func Delay 0 = ' || p_rc_route_func_delay_0, l_api_name, fnd_log.level_statement);
1737: debug(' --> Parameter : Route Func Delay 1 = ' || p_rc_route_func_delay_1, l_api_name, fnd_log.level_statement);
1738: debug(' --> Parameter : Route Func Delay 2 = ' || p_rc_route_func_delay_2, l_api_name, fnd_log.level_statement);

Line 1735: debug(' --> Parameter : Consider Toll Roads = ' || p_rc_consider_toll_roads, l_api_name, fnd_log.level_statement);

1731: debug(' --> Parameter : Default Travel Duration = ' || p_sp_default_travel_duration, l_api_name, fnd_log.level_statement);
1732: debug(' --> Parameter : Max Distance In Group = ' || p_sp_max_distance_in_group, l_api_name, fnd_log.level_statement);
1733: debug(' --> Parameter : Max Dist To Skip Actual = ' || p_sp_max_dist_to_skip_actual, l_api_name, fnd_log.level_statement);
1734: debug(' --> Parameter : Router Calc Type = ' || p_rc_router_calc_type, l_api_name, fnd_log.level_statement);
1735: debug(' --> Parameter : Consider Toll Roads = ' || p_rc_consider_toll_roads, l_api_name, fnd_log.level_statement);
1736: debug(' --> Parameter : Route Func Delay 0 = ' || p_rc_route_func_delay_0, l_api_name, fnd_log.level_statement);
1737: debug(' --> Parameter : Route Func Delay 1 = ' || p_rc_route_func_delay_1, l_api_name, fnd_log.level_statement);
1738: debug(' --> Parameter : Route Func Delay 2 = ' || p_rc_route_func_delay_2, l_api_name, fnd_log.level_statement);
1739: debug(' --> Parameter : Route Func Delay 3 = ' || p_rc_route_func_delay_3, l_api_name, fnd_log.level_statement);

Line 1736: debug(' --> Parameter : Route Func Delay 0 = ' || p_rc_route_func_delay_0, l_api_name, fnd_log.level_statement);

1732: debug(' --> Parameter : Max Distance In Group = ' || p_sp_max_distance_in_group, l_api_name, fnd_log.level_statement);
1733: debug(' --> Parameter : Max Dist To Skip Actual = ' || p_sp_max_dist_to_skip_actual, l_api_name, fnd_log.level_statement);
1734: debug(' --> Parameter : Router Calc Type = ' || p_rc_router_calc_type, l_api_name, fnd_log.level_statement);
1735: debug(' --> Parameter : Consider Toll Roads = ' || p_rc_consider_toll_roads, l_api_name, fnd_log.level_statement);
1736: debug(' --> Parameter : Route Func Delay 0 = ' || p_rc_route_func_delay_0, l_api_name, fnd_log.level_statement);
1737: debug(' --> Parameter : Route Func Delay 1 = ' || p_rc_route_func_delay_1, l_api_name, fnd_log.level_statement);
1738: debug(' --> Parameter : Route Func Delay 2 = ' || p_rc_route_func_delay_2, l_api_name, fnd_log.level_statement);
1739: debug(' --> Parameter : Route Func Delay 3 = ' || p_rc_route_func_delay_3, l_api_name, fnd_log.level_statement);
1740: debug(' --> Parameter : Route Func Delay 4 = ' || p_rc_route_func_delay_4, l_api_name, fnd_log.level_statement);

Line 1737: debug(' --> Parameter : Route Func Delay 1 = ' || p_rc_route_func_delay_1, l_api_name, fnd_log.level_statement);

1733: debug(' --> Parameter : Max Dist To Skip Actual = ' || p_sp_max_dist_to_skip_actual, l_api_name, fnd_log.level_statement);
1734: debug(' --> Parameter : Router Calc Type = ' || p_rc_router_calc_type, l_api_name, fnd_log.level_statement);
1735: debug(' --> Parameter : Consider Toll Roads = ' || p_rc_consider_toll_roads, l_api_name, fnd_log.level_statement);
1736: debug(' --> Parameter : Route Func Delay 0 = ' || p_rc_route_func_delay_0, l_api_name, fnd_log.level_statement);
1737: debug(' --> Parameter : Route Func Delay 1 = ' || p_rc_route_func_delay_1, l_api_name, fnd_log.level_statement);
1738: debug(' --> Parameter : Route Func Delay 2 = ' || p_rc_route_func_delay_2, l_api_name, fnd_log.level_statement);
1739: debug(' --> Parameter : Route Func Delay 3 = ' || p_rc_route_func_delay_3, l_api_name, fnd_log.level_statement);
1740: debug(' --> Parameter : Route Func Delay 4 = ' || p_rc_route_func_delay_4, l_api_name, fnd_log.level_statement);
1741: debug(' --> Parameter : Estimate First Boundary = ' || p_rc_estimate_first_boundary, l_api_name, fnd_log.level_statement);

Line 1738: debug(' --> Parameter : Route Func Delay 2 = ' || p_rc_route_func_delay_2, l_api_name, fnd_log.level_statement);

1734: debug(' --> Parameter : Router Calc Type = ' || p_rc_router_calc_type, l_api_name, fnd_log.level_statement);
1735: debug(' --> Parameter : Consider Toll Roads = ' || p_rc_consider_toll_roads, l_api_name, fnd_log.level_statement);
1736: debug(' --> Parameter : Route Func Delay 0 = ' || p_rc_route_func_delay_0, l_api_name, fnd_log.level_statement);
1737: debug(' --> Parameter : Route Func Delay 1 = ' || p_rc_route_func_delay_1, l_api_name, fnd_log.level_statement);
1738: debug(' --> Parameter : Route Func Delay 2 = ' || p_rc_route_func_delay_2, l_api_name, fnd_log.level_statement);
1739: debug(' --> Parameter : Route Func Delay 3 = ' || p_rc_route_func_delay_3, l_api_name, fnd_log.level_statement);
1740: debug(' --> Parameter : Route Func Delay 4 = ' || p_rc_route_func_delay_4, l_api_name, fnd_log.level_statement);
1741: debug(' --> Parameter : Estimate First Boundary = ' || p_rc_estimate_first_boundary, l_api_name, fnd_log.level_statement);
1742: debug(' --> Parameter : Estimate Second Boundary = ' || p_rc_estimate_second_boundary, l_api_name, fnd_log.level_statement);

Line 1739: debug(' --> Parameter : Route Func Delay 3 = ' || p_rc_route_func_delay_3, l_api_name, fnd_log.level_statement);

1735: debug(' --> Parameter : Consider Toll Roads = ' || p_rc_consider_toll_roads, l_api_name, fnd_log.level_statement);
1736: debug(' --> Parameter : Route Func Delay 0 = ' || p_rc_route_func_delay_0, l_api_name, fnd_log.level_statement);
1737: debug(' --> Parameter : Route Func Delay 1 = ' || p_rc_route_func_delay_1, l_api_name, fnd_log.level_statement);
1738: debug(' --> Parameter : Route Func Delay 2 = ' || p_rc_route_func_delay_2, l_api_name, fnd_log.level_statement);
1739: debug(' --> Parameter : Route Func Delay 3 = ' || p_rc_route_func_delay_3, l_api_name, fnd_log.level_statement);
1740: debug(' --> Parameter : Route Func Delay 4 = ' || p_rc_route_func_delay_4, l_api_name, fnd_log.level_statement);
1741: debug(' --> Parameter : Estimate First Boundary = ' || p_rc_estimate_first_boundary, l_api_name, fnd_log.level_statement);
1742: debug(' --> Parameter : Estimate Second Boundary = ' || p_rc_estimate_second_boundary, l_api_name, fnd_log.level_statement);
1743: debug(' --> Parameter : Estimate First Avg Speed = ' || p_rc_estimate_first_avg_speed, l_api_name, fnd_log.level_statement);

Line 1740: debug(' --> Parameter : Route Func Delay 4 = ' || p_rc_route_func_delay_4, l_api_name, fnd_log.level_statement);

1736: debug(' --> Parameter : Route Func Delay 0 = ' || p_rc_route_func_delay_0, l_api_name, fnd_log.level_statement);
1737: debug(' --> Parameter : Route Func Delay 1 = ' || p_rc_route_func_delay_1, l_api_name, fnd_log.level_statement);
1738: debug(' --> Parameter : Route Func Delay 2 = ' || p_rc_route_func_delay_2, l_api_name, fnd_log.level_statement);
1739: debug(' --> Parameter : Route Func Delay 3 = ' || p_rc_route_func_delay_3, l_api_name, fnd_log.level_statement);
1740: debug(' --> Parameter : Route Func Delay 4 = ' || p_rc_route_func_delay_4, l_api_name, fnd_log.level_statement);
1741: debug(' --> Parameter : Estimate First Boundary = ' || p_rc_estimate_first_boundary, l_api_name, fnd_log.level_statement);
1742: debug(' --> Parameter : Estimate Second Boundary = ' || p_rc_estimate_second_boundary, l_api_name, fnd_log.level_statement);
1743: debug(' --> Parameter : Estimate First Avg Speed = ' || p_rc_estimate_first_avg_speed, l_api_name, fnd_log.level_statement);
1744: debug(' --> Parameter : Estimate Second Avg Speed = ' || p_rc_estimate_second_avg_speed, l_api_name, fnd_log.level_statement);

Line 1741: debug(' --> Parameter : Estimate First Boundary = ' || p_rc_estimate_first_boundary, l_api_name, fnd_log.level_statement);

1737: debug(' --> Parameter : Route Func Delay 1 = ' || p_rc_route_func_delay_1, l_api_name, fnd_log.level_statement);
1738: debug(' --> Parameter : Route Func Delay 2 = ' || p_rc_route_func_delay_2, l_api_name, fnd_log.level_statement);
1739: debug(' --> Parameter : Route Func Delay 3 = ' || p_rc_route_func_delay_3, l_api_name, fnd_log.level_statement);
1740: debug(' --> Parameter : Route Func Delay 4 = ' || p_rc_route_func_delay_4, l_api_name, fnd_log.level_statement);
1741: debug(' --> Parameter : Estimate First Boundary = ' || p_rc_estimate_first_boundary, l_api_name, fnd_log.level_statement);
1742: debug(' --> Parameter : Estimate Second Boundary = ' || p_rc_estimate_second_boundary, l_api_name, fnd_log.level_statement);
1743: debug(' --> Parameter : Estimate First Avg Speed = ' || p_rc_estimate_first_avg_speed, l_api_name, fnd_log.level_statement);
1744: debug(' --> Parameter : Estimate Second Avg Speed = ' || p_rc_estimate_second_avg_speed, l_api_name, fnd_log.level_statement);
1745: debug(' --> Parameter : Estimate Third Avg Speed = ' || p_rc_estimate_third_avg_speed, l_api_name, fnd_log.level_statement);

Line 1742: debug(' --> Parameter : Estimate Second Boundary = ' || p_rc_estimate_second_boundary, l_api_name, fnd_log.level_statement);

1738: debug(' --> Parameter : Route Func Delay 2 = ' || p_rc_route_func_delay_2, l_api_name, fnd_log.level_statement);
1739: debug(' --> Parameter : Route Func Delay 3 = ' || p_rc_route_func_delay_3, l_api_name, fnd_log.level_statement);
1740: debug(' --> Parameter : Route Func Delay 4 = ' || p_rc_route_func_delay_4, l_api_name, fnd_log.level_statement);
1741: debug(' --> Parameter : Estimate First Boundary = ' || p_rc_estimate_first_boundary, l_api_name, fnd_log.level_statement);
1742: debug(' --> Parameter : Estimate Second Boundary = ' || p_rc_estimate_second_boundary, l_api_name, fnd_log.level_statement);
1743: debug(' --> Parameter : Estimate First Avg Speed = ' || p_rc_estimate_first_avg_speed, l_api_name, fnd_log.level_statement);
1744: debug(' --> Parameter : Estimate Second Avg Speed = ' || p_rc_estimate_second_avg_speed, l_api_name, fnd_log.level_statement);
1745: debug(' --> Parameter : Estimate Third Avg Speed = ' || p_rc_estimate_third_avg_speed, l_api_name, fnd_log.level_statement);
1746: debug(' --> Parameter : Task Per Day Delayed = ' || p_cp_task_per_day_delayed, l_api_name, fnd_log.level_statement);

Line 1743: debug(' --> Parameter : Estimate First Avg Speed = ' || p_rc_estimate_first_avg_speed, l_api_name, fnd_log.level_statement);

1739: debug(' --> Parameter : Route Func Delay 3 = ' || p_rc_route_func_delay_3, l_api_name, fnd_log.level_statement);
1740: debug(' --> Parameter : Route Func Delay 4 = ' || p_rc_route_func_delay_4, l_api_name, fnd_log.level_statement);
1741: debug(' --> Parameter : Estimate First Boundary = ' || p_rc_estimate_first_boundary, l_api_name, fnd_log.level_statement);
1742: debug(' --> Parameter : Estimate Second Boundary = ' || p_rc_estimate_second_boundary, l_api_name, fnd_log.level_statement);
1743: debug(' --> Parameter : Estimate First Avg Speed = ' || p_rc_estimate_first_avg_speed, l_api_name, fnd_log.level_statement);
1744: debug(' --> Parameter : Estimate Second Avg Speed = ' || p_rc_estimate_second_avg_speed, l_api_name, fnd_log.level_statement);
1745: debug(' --> Parameter : Estimate Third Avg Speed = ' || p_rc_estimate_third_avg_speed, l_api_name, fnd_log.level_statement);
1746: debug(' --> Parameter : Task Per Day Delayed = ' || p_cp_task_per_day_delayed, l_api_name, fnd_log.level_statement);
1747: debug(' --> Parameter : Task Per Min Early = ' || p_cp_task_per_min_early, l_api_name, fnd_log.level_statement);

Line 1744: debug(' --> Parameter : Estimate Second Avg Speed = ' || p_rc_estimate_second_avg_speed, l_api_name, fnd_log.level_statement);

1740: debug(' --> Parameter : Route Func Delay 4 = ' || p_rc_route_func_delay_4, l_api_name, fnd_log.level_statement);
1741: debug(' --> Parameter : Estimate First Boundary = ' || p_rc_estimate_first_boundary, l_api_name, fnd_log.level_statement);
1742: debug(' --> Parameter : Estimate Second Boundary = ' || p_rc_estimate_second_boundary, l_api_name, fnd_log.level_statement);
1743: debug(' --> Parameter : Estimate First Avg Speed = ' || p_rc_estimate_first_avg_speed, l_api_name, fnd_log.level_statement);
1744: debug(' --> Parameter : Estimate Second Avg Speed = ' || p_rc_estimate_second_avg_speed, l_api_name, fnd_log.level_statement);
1745: debug(' --> Parameter : Estimate Third Avg Speed = ' || p_rc_estimate_third_avg_speed, l_api_name, fnd_log.level_statement);
1746: debug(' --> Parameter : Task Per Day Delayed = ' || p_cp_task_per_day_delayed, l_api_name, fnd_log.level_statement);
1747: debug(' --> Parameter : Task Per Min Early = ' || p_cp_task_per_min_early, l_api_name, fnd_log.level_statement);
1748: debug(' --> Parameter : Task Per Min Late = ' || p_cp_task_per_min_late, l_api_name, fnd_log.level_statement);

Line 1745: debug(' --> Parameter : Estimate Third Avg Speed = ' || p_rc_estimate_third_avg_speed, l_api_name, fnd_log.level_statement);

1741: debug(' --> Parameter : Estimate First Boundary = ' || p_rc_estimate_first_boundary, l_api_name, fnd_log.level_statement);
1742: debug(' --> Parameter : Estimate Second Boundary = ' || p_rc_estimate_second_boundary, l_api_name, fnd_log.level_statement);
1743: debug(' --> Parameter : Estimate First Avg Speed = ' || p_rc_estimate_first_avg_speed, l_api_name, fnd_log.level_statement);
1744: debug(' --> Parameter : Estimate Second Avg Speed = ' || p_rc_estimate_second_avg_speed, l_api_name, fnd_log.level_statement);
1745: debug(' --> Parameter : Estimate Third Avg Speed = ' || p_rc_estimate_third_avg_speed, l_api_name, fnd_log.level_statement);
1746: debug(' --> Parameter : Task Per Day Delayed = ' || p_cp_task_per_day_delayed, l_api_name, fnd_log.level_statement);
1747: debug(' --> Parameter : Task Per Min Early = ' || p_cp_task_per_min_early, l_api_name, fnd_log.level_statement);
1748: debug(' --> Parameter : Task Per Min Late = ' || p_cp_task_per_min_late, l_api_name, fnd_log.level_statement);
1749: debug(' --> Parameter : Tls Per Day Extra = ' || p_cp_tls_per_day_extra, l_api_name, fnd_log.level_statement);

Line 1746: debug(' --> Parameter : Task Per Day Delayed = ' || p_cp_task_per_day_delayed, l_api_name, fnd_log.level_statement);

1742: debug(' --> Parameter : Estimate Second Boundary = ' || p_rc_estimate_second_boundary, l_api_name, fnd_log.level_statement);
1743: debug(' --> Parameter : Estimate First Avg Speed = ' || p_rc_estimate_first_avg_speed, l_api_name, fnd_log.level_statement);
1744: debug(' --> Parameter : Estimate Second Avg Speed = ' || p_rc_estimate_second_avg_speed, l_api_name, fnd_log.level_statement);
1745: debug(' --> Parameter : Estimate Third Avg Speed = ' || p_rc_estimate_third_avg_speed, l_api_name, fnd_log.level_statement);
1746: debug(' --> Parameter : Task Per Day Delayed = ' || p_cp_task_per_day_delayed, l_api_name, fnd_log.level_statement);
1747: debug(' --> Parameter : Task Per Min Early = ' || p_cp_task_per_min_early, l_api_name, fnd_log.level_statement);
1748: debug(' --> Parameter : Task Per Min Late = ' || p_cp_task_per_min_late, l_api_name, fnd_log.level_statement);
1749: debug(' --> Parameter : Tls Per Day Extra = ' || p_cp_tls_per_day_extra, l_api_name, fnd_log.level_statement);
1750: debug(' --> Parameter : Tls Per Child Extra = ' || p_cp_tls_per_child_extra, l_api_name, fnd_log.level_statement);

Line 1747: debug(' --> Parameter : Task Per Min Early = ' || p_cp_task_per_min_early, l_api_name, fnd_log.level_statement);

1743: debug(' --> Parameter : Estimate First Avg Speed = ' || p_rc_estimate_first_avg_speed, l_api_name, fnd_log.level_statement);
1744: debug(' --> Parameter : Estimate Second Avg Speed = ' || p_rc_estimate_second_avg_speed, l_api_name, fnd_log.level_statement);
1745: debug(' --> Parameter : Estimate Third Avg Speed = ' || p_rc_estimate_third_avg_speed, l_api_name, fnd_log.level_statement);
1746: debug(' --> Parameter : Task Per Day Delayed = ' || p_cp_task_per_day_delayed, l_api_name, fnd_log.level_statement);
1747: debug(' --> Parameter : Task Per Min Early = ' || p_cp_task_per_min_early, l_api_name, fnd_log.level_statement);
1748: debug(' --> Parameter : Task Per Min Late = ' || p_cp_task_per_min_late, l_api_name, fnd_log.level_statement);
1749: debug(' --> Parameter : Tls Per Day Extra = ' || p_cp_tls_per_day_extra, l_api_name, fnd_log.level_statement);
1750: debug(' --> Parameter : Tls Per Child Extra = ' || p_cp_tls_per_child_extra, l_api_name, fnd_log.level_statement);
1751: debug(' --> Parameter : Parts Violation = ' || p_cp_parts_violation, l_api_name, fnd_log.level_statement);

Line 1748: debug(' --> Parameter : Task Per Min Late = ' || p_cp_task_per_min_late, l_api_name, fnd_log.level_statement);

1744: debug(' --> Parameter : Estimate Second Avg Speed = ' || p_rc_estimate_second_avg_speed, l_api_name, fnd_log.level_statement);
1745: debug(' --> Parameter : Estimate Third Avg Speed = ' || p_rc_estimate_third_avg_speed, l_api_name, fnd_log.level_statement);
1746: debug(' --> Parameter : Task Per Day Delayed = ' || p_cp_task_per_day_delayed, l_api_name, fnd_log.level_statement);
1747: debug(' --> Parameter : Task Per Min Early = ' || p_cp_task_per_min_early, l_api_name, fnd_log.level_statement);
1748: debug(' --> Parameter : Task Per Min Late = ' || p_cp_task_per_min_late, l_api_name, fnd_log.level_statement);
1749: debug(' --> Parameter : Tls Per Day Extra = ' || p_cp_tls_per_day_extra, l_api_name, fnd_log.level_statement);
1750: debug(' --> Parameter : Tls Per Child Extra = ' || p_cp_tls_per_child_extra, l_api_name, fnd_log.level_statement);
1751: debug(' --> Parameter : Parts Violation = ' || p_cp_parts_violation, l_api_name, fnd_log.level_statement);
1752: debug(' --> Parameter : Res Per Min Overtime = ' || p_cp_res_per_min_overtime, l_api_name, fnd_log.level_statement);

Line 1749: debug(' --> Parameter : Tls Per Day Extra = ' || p_cp_tls_per_day_extra, l_api_name, fnd_log.level_statement);

1745: debug(' --> Parameter : Estimate Third Avg Speed = ' || p_rc_estimate_third_avg_speed, l_api_name, fnd_log.level_statement);
1746: debug(' --> Parameter : Task Per Day Delayed = ' || p_cp_task_per_day_delayed, l_api_name, fnd_log.level_statement);
1747: debug(' --> Parameter : Task Per Min Early = ' || p_cp_task_per_min_early, l_api_name, fnd_log.level_statement);
1748: debug(' --> Parameter : Task Per Min Late = ' || p_cp_task_per_min_late, l_api_name, fnd_log.level_statement);
1749: debug(' --> Parameter : Tls Per Day Extra = ' || p_cp_tls_per_day_extra, l_api_name, fnd_log.level_statement);
1750: debug(' --> Parameter : Tls Per Child Extra = ' || p_cp_tls_per_child_extra, l_api_name, fnd_log.level_statement);
1751: debug(' --> Parameter : Parts Violation = ' || p_cp_parts_violation, l_api_name, fnd_log.level_statement);
1752: debug(' --> Parameter : Res Per Min Overtime = ' || p_cp_res_per_min_overtime, l_api_name, fnd_log.level_statement);
1753: debug(' --> Parameter : Res Assigned Not Pref = ' || p_cp_res_assigned_not_pref, l_api_name, fnd_log.level_statement);

Line 1750: debug(' --> Parameter : Tls Per Child Extra = ' || p_cp_tls_per_child_extra, l_api_name, fnd_log.level_statement);

1746: debug(' --> Parameter : Task Per Day Delayed = ' || p_cp_task_per_day_delayed, l_api_name, fnd_log.level_statement);
1747: debug(' --> Parameter : Task Per Min Early = ' || p_cp_task_per_min_early, l_api_name, fnd_log.level_statement);
1748: debug(' --> Parameter : Task Per Min Late = ' || p_cp_task_per_min_late, l_api_name, fnd_log.level_statement);
1749: debug(' --> Parameter : Tls Per Day Extra = ' || p_cp_tls_per_day_extra, l_api_name, fnd_log.level_statement);
1750: debug(' --> Parameter : Tls Per Child Extra = ' || p_cp_tls_per_child_extra, l_api_name, fnd_log.level_statement);
1751: debug(' --> Parameter : Parts Violation = ' || p_cp_parts_violation, l_api_name, fnd_log.level_statement);
1752: debug(' --> Parameter : Res Per Min Overtime = ' || p_cp_res_per_min_overtime, l_api_name, fnd_log.level_statement);
1753: debug(' --> Parameter : Res Assigned Not Pref = ' || p_cp_res_assigned_not_pref, l_api_name, fnd_log.level_statement);
1754: debug(' --> Parameter : Res Skill Level = ' || p_cp_res_skill_level, l_api_name, fnd_log.level_statement);

Line 1751: debug(' --> Parameter : Parts Violation = ' || p_cp_parts_violation, l_api_name, fnd_log.level_statement);

1747: debug(' --> Parameter : Task Per Min Early = ' || p_cp_task_per_min_early, l_api_name, fnd_log.level_statement);
1748: debug(' --> Parameter : Task Per Min Late = ' || p_cp_task_per_min_late, l_api_name, fnd_log.level_statement);
1749: debug(' --> Parameter : Tls Per Day Extra = ' || p_cp_tls_per_day_extra, l_api_name, fnd_log.level_statement);
1750: debug(' --> Parameter : Tls Per Child Extra = ' || p_cp_tls_per_child_extra, l_api_name, fnd_log.level_statement);
1751: debug(' --> Parameter : Parts Violation = ' || p_cp_parts_violation, l_api_name, fnd_log.level_statement);
1752: debug(' --> Parameter : Res Per Min Overtime = ' || p_cp_res_per_min_overtime, l_api_name, fnd_log.level_statement);
1753: debug(' --> Parameter : Res Assigned Not Pref = ' || p_cp_res_assigned_not_pref, l_api_name, fnd_log.level_statement);
1754: debug(' --> Parameter : Res Skill Level = ' || p_cp_res_skill_level, l_api_name, fnd_log.level_statement);
1755: debug(' --> Parameter : Standby Shift Usage = ' || p_cp_standby_shift_usage, l_api_name, fnd_log.level_statement);

Line 1752: debug(' --> Parameter : Res Per Min Overtime = ' || p_cp_res_per_min_overtime, l_api_name, fnd_log.level_statement);

1748: debug(' --> Parameter : Task Per Min Late = ' || p_cp_task_per_min_late, l_api_name, fnd_log.level_statement);
1749: debug(' --> Parameter : Tls Per Day Extra = ' || p_cp_tls_per_day_extra, l_api_name, fnd_log.level_statement);
1750: debug(' --> Parameter : Tls Per Child Extra = ' || p_cp_tls_per_child_extra, l_api_name, fnd_log.level_statement);
1751: debug(' --> Parameter : Parts Violation = ' || p_cp_parts_violation, l_api_name, fnd_log.level_statement);
1752: debug(' --> Parameter : Res Per Min Overtime = ' || p_cp_res_per_min_overtime, l_api_name, fnd_log.level_statement);
1753: debug(' --> Parameter : Res Assigned Not Pref = ' || p_cp_res_assigned_not_pref, l_api_name, fnd_log.level_statement);
1754: debug(' --> Parameter : Res Skill Level = ' || p_cp_res_skill_level, l_api_name, fnd_log.level_statement);
1755: debug(' --> Parameter : Standby Shift Usage = ' || p_cp_standby_shift_usage, l_api_name, fnd_log.level_statement);
1756: debug(' --> Parameter : Travel Per Unit Distance = ' || p_cp_travel_per_unit_distance, l_api_name, fnd_log.level_statement);

Line 1753: debug(' --> Parameter : Res Assigned Not Pref = ' || p_cp_res_assigned_not_pref, l_api_name, fnd_log.level_statement);

1749: debug(' --> Parameter : Tls Per Day Extra = ' || p_cp_tls_per_day_extra, l_api_name, fnd_log.level_statement);
1750: debug(' --> Parameter : Tls Per Child Extra = ' || p_cp_tls_per_child_extra, l_api_name, fnd_log.level_statement);
1751: debug(' --> Parameter : Parts Violation = ' || p_cp_parts_violation, l_api_name, fnd_log.level_statement);
1752: debug(' --> Parameter : Res Per Min Overtime = ' || p_cp_res_per_min_overtime, l_api_name, fnd_log.level_statement);
1753: debug(' --> Parameter : Res Assigned Not Pref = ' || p_cp_res_assigned_not_pref, l_api_name, fnd_log.level_statement);
1754: debug(' --> Parameter : Res Skill Level = ' || p_cp_res_skill_level, l_api_name, fnd_log.level_statement);
1755: debug(' --> Parameter : Standby Shift Usage = ' || p_cp_standby_shift_usage, l_api_name, fnd_log.level_statement);
1756: debug(' --> Parameter : Travel Per Unit Distance = ' || p_cp_travel_per_unit_distance, l_api_name, fnd_log.level_statement);
1757: debug(' --> Parameter : Travel Per Unit Duration = ' || p_cp_travel_per_unit_duration, l_api_name, fnd_log.level_statement);

Line 1754: debug(' --> Parameter : Res Skill Level = ' || p_cp_res_skill_level, l_api_name, fnd_log.level_statement);

1750: debug(' --> Parameter : Tls Per Child Extra = ' || p_cp_tls_per_child_extra, l_api_name, fnd_log.level_statement);
1751: debug(' --> Parameter : Parts Violation = ' || p_cp_parts_violation, l_api_name, fnd_log.level_statement);
1752: debug(' --> Parameter : Res Per Min Overtime = ' || p_cp_res_per_min_overtime, l_api_name, fnd_log.level_statement);
1753: debug(' --> Parameter : Res Assigned Not Pref = ' || p_cp_res_assigned_not_pref, l_api_name, fnd_log.level_statement);
1754: debug(' --> Parameter : Res Skill Level = ' || p_cp_res_skill_level, l_api_name, fnd_log.level_statement);
1755: debug(' --> Parameter : Standby Shift Usage = ' || p_cp_standby_shift_usage, l_api_name, fnd_log.level_statement);
1756: debug(' --> Parameter : Travel Per Unit Distance = ' || p_cp_travel_per_unit_distance, l_api_name, fnd_log.level_statement);
1757: debug(' --> Parameter : Travel Per Unit Duration = ' || p_cp_travel_per_unit_duration, l_api_name, fnd_log.level_statement);
1758: debug(' --> Parameter : Defer Same Site = ' || p_cp_defer_same_site, l_api_name, fnd_log.level_statement);

Line 1755: debug(' --> Parameter : Standby Shift Usage = ' || p_cp_standby_shift_usage, l_api_name, fnd_log.level_statement);

1751: debug(' --> Parameter : Parts Violation = ' || p_cp_parts_violation, l_api_name, fnd_log.level_statement);
1752: debug(' --> Parameter : Res Per Min Overtime = ' || p_cp_res_per_min_overtime, l_api_name, fnd_log.level_statement);
1753: debug(' --> Parameter : Res Assigned Not Pref = ' || p_cp_res_assigned_not_pref, l_api_name, fnd_log.level_statement);
1754: debug(' --> Parameter : Res Skill Level = ' || p_cp_res_skill_level, l_api_name, fnd_log.level_statement);
1755: debug(' --> Parameter : Standby Shift Usage = ' || p_cp_standby_shift_usage, l_api_name, fnd_log.level_statement);
1756: debug(' --> Parameter : Travel Per Unit Distance = ' || p_cp_travel_per_unit_distance, l_api_name, fnd_log.level_statement);
1757: debug(' --> Parameter : Travel Per Unit Duration = ' || p_cp_travel_per_unit_duration, l_api_name, fnd_log.level_statement);
1758: debug(' --> Parameter : Defer Same Site = ' || p_cp_defer_same_site, l_api_name, fnd_log.level_statement);
1759: END IF;

Line 1756: debug(' --> Parameter : Travel Per Unit Distance = ' || p_cp_travel_per_unit_distance, l_api_name, fnd_log.level_statement);

1752: debug(' --> Parameter : Res Per Min Overtime = ' || p_cp_res_per_min_overtime, l_api_name, fnd_log.level_statement);
1753: debug(' --> Parameter : Res Assigned Not Pref = ' || p_cp_res_assigned_not_pref, l_api_name, fnd_log.level_statement);
1754: debug(' --> Parameter : Res Skill Level = ' || p_cp_res_skill_level, l_api_name, fnd_log.level_statement);
1755: debug(' --> Parameter : Standby Shift Usage = ' || p_cp_standby_shift_usage, l_api_name, fnd_log.level_statement);
1756: debug(' --> Parameter : Travel Per Unit Distance = ' || p_cp_travel_per_unit_distance, l_api_name, fnd_log.level_statement);
1757: debug(' --> Parameter : Travel Per Unit Duration = ' || p_cp_travel_per_unit_duration, l_api_name, fnd_log.level_statement);
1758: debug(' --> Parameter : Defer Same Site = ' || p_cp_defer_same_site, l_api_name, fnd_log.level_statement);
1759: END IF;
1760:

Line 1757: debug(' --> Parameter : Travel Per Unit Duration = ' || p_cp_travel_per_unit_duration, l_api_name, fnd_log.level_statement);

1753: debug(' --> Parameter : Res Assigned Not Pref = ' || p_cp_res_assigned_not_pref, l_api_name, fnd_log.level_statement);
1754: debug(' --> Parameter : Res Skill Level = ' || p_cp_res_skill_level, l_api_name, fnd_log.level_statement);
1755: debug(' --> Parameter : Standby Shift Usage = ' || p_cp_standby_shift_usage, l_api_name, fnd_log.level_statement);
1756: debug(' --> Parameter : Travel Per Unit Distance = ' || p_cp_travel_per_unit_distance, l_api_name, fnd_log.level_statement);
1757: debug(' --> Parameter : Travel Per Unit Duration = ' || p_cp_travel_per_unit_duration, l_api_name, fnd_log.level_statement);
1758: debug(' --> Parameter : Defer Same Site = ' || p_cp_defer_same_site, l_api_name, fnd_log.level_statement);
1759: END IF;
1760:
1761: IF p_action = 'UPDATE' THEN

Line 1758: debug(' --> Parameter : Defer Same Site = ' || p_cp_defer_same_site, l_api_name, fnd_log.level_statement);

1754: debug(' --> Parameter : Res Skill Level = ' || p_cp_res_skill_level, l_api_name, fnd_log.level_statement);
1755: debug(' --> Parameter : Standby Shift Usage = ' || p_cp_standby_shift_usage, l_api_name, fnd_log.level_statement);
1756: debug(' --> Parameter : Travel Per Unit Distance = ' || p_cp_travel_per_unit_distance, l_api_name, fnd_log.level_statement);
1757: debug(' --> Parameter : Travel Per Unit Duration = ' || p_cp_travel_per_unit_duration, l_api_name, fnd_log.level_statement);
1758: debug(' --> Parameter : Defer Same Site = ' || p_cp_defer_same_site, l_api_name, fnd_log.level_statement);
1759: END IF;
1760:
1761: IF p_action = 'UPDATE' THEN
1762: OPEN c_rule_details;

Line 1877: debug('Process WebADI Action Errored out. Message Count = ' || l_msg_count || ' : Message Data = ' || l_msg_data, l_api_name, fnd_log.level_error);

1873: );
1874:
1875: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1876: IF l_debug = 'Y' THEN
1877: debug('Process WebADI Action Errored out. Message Count = ' || l_msg_count || ' : Message Data = ' || l_msg_data, l_api_name, fnd_log.level_error);
1878: END IF;
1879:
1880: IF l_msg_count > 0 THEN
1881: fnd_message.set_encoded(fnd_msg_pub.get(fnd_msg_pub.g_last));