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.OKC_XPRT_RULE_PVT dependencies on FND_MSG_PUB

Line 747: FOR i IN 1 .. fnd_msg_pub.count_msg

743: PROCEDURE read_message (x_message IN OUT NOCOPY VARCHAR2)
744: IS
745: l_message VARCHAR2 (2000);
746: BEGIN
747: FOR i IN 1 .. fnd_msg_pub.count_msg
748: LOOP
749: l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);
750:
751: IF (LENGTH (l_message) + LENGTH (Nvl(x_message,' '))) <= 2500

Line 749: l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);

745: l_message VARCHAR2 (2000);
746: BEGIN
747: FOR i IN 1 .. fnd_msg_pub.count_msg
748: LOOP
749: l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);
750:
751: IF (LENGTH (l_message) + LENGTH (Nvl(x_message,' '))) <= 2500
752: THEN
753: x_message := x_message || l_message;

Line 2495: fnd_msg_pub.initialize;

2491: -- Atleast one condition must exist
2492: -- Atleast one outcome is required for 'CLAUSE_SELECTION' type rules.
2493: -- If not throw invalid input error.
2494: --
2495: fnd_msg_pub.initialize;
2496: l_rule_type := p_rule_rec.rule_header_rec.rule_type;
2497:
2498: IF l_rule_type = g_clause_rule_type
2499: THEN

Line 2533: fnd_msg_pub.initialize;

2529: END IF;
2530:
2531: -- PRE VALIDATION END
2532: BEGIN
2533: fnd_msg_pub.initialize;
2534: l_error_message := '';
2535: g_rule_id := NULL;
2536: g_rule_intent := NULL;
2537: g_rule_type := NULL;

Line 2556: fnd_msg_pub.initialize;

2552: RAISE;
2553: END;
2554:
2555: BEGIN
2556: fnd_msg_pub.initialize;
2557: l_error_message := '';
2558: create_rule_condition
2559: (p_rule_condition_tbl => p_rule_rec.rule_condition_tbl);
2560: EXCEPTION

Line 2570: fnd_msg_pub.initialize;

2566:
2567: IF l_rule_type = g_clause_rule_type
2568: THEN
2569: BEGIN
2570: fnd_msg_pub.initialize;
2571: l_error_message := '';
2572: create_rule_outcome
2573: (p_rule_outcome_tbl => p_rule_rec.rule_outcome_tbl);
2574: EXCEPTION

Line 2581: fnd_msg_pub.initialize;

2577: p_rule_rec.status := g_ret_sts_error;
2578: RAISE;
2579: END;
2580:
2581: fnd_msg_pub.initialize;
2582:
2583: IF validaterulecondition (g_rule_id) = 'N'
2584: THEN
2585: p_rule_rec.status := g_ret_sts_error;

Line 2594: fnd_msg_pub.initialize;

2590: IF NVL (p_rule_rec.rule_header_rec.org_wide_flag, 'X') <> 'Y'
2591: AND p_rule_rec.template_rules_tbl.COUNT > 0
2592: THEN
2593: BEGIN
2594: fnd_msg_pub.initialize;
2595: l_error_message := '';
2596: create_template_rules
2597: (p_template_rules_tbl => p_rule_rec.template_rules_tbl);
2598: EXCEPTION

Line 2621: fnd_msg_pub.initialize;

2617: l_rule_type okc_xprt_rule_hdrs_all.rule_type%TYPE;
2618: l_error_message VARCHAR2 (2500);
2619: BEGIN
2620: BEGIN
2621: fnd_msg_pub.initialize;
2622: l_error_message := '';
2623: g_rule_id := NULL;
2624: g_rule_intent := NULL;
2625: g_rule_type := NULL;

Line 2645: fnd_msg_pub.initialize;

2641: END;
2642:
2643: IF p_rule_rec.rule_condition_tbl.COUNT > 0
2644: THEN
2645: fnd_msg_pub.initialize;
2646: l_error_message := '';
2647: create_rule_condition
2648: (p_rule_condition_tbl => p_rule_rec.rule_condition_tbl);
2649: END IF;

Line 2654: fnd_msg_pub.initialize;

2650:
2651: IF l_rule_type = g_clause_rule_type
2652: AND p_rule_rec.rule_outcome_tbl.COUNT > 0
2653: THEN
2654: fnd_msg_pub.initialize;
2655: l_error_message := '';
2656: create_rule_outcome
2657: (p_rule_outcome_tbl => p_rule_rec.rule_outcome_tbl);
2658: END IF;

Line 2663: fnd_msg_pub.initialize;

2659:
2660: IF p_rule_rec.rule_header_rec.org_wide_flag <> 'Y'
2661: AND p_rule_rec.template_rules_tbl.COUNT > 0
2662: THEN
2663: fnd_msg_pub.initialize;
2664: l_error_message := '';
2665: create_template_rules
2666: (p_template_rules_tbl => p_rule_rec.template_rules_tbl);
2667: END IF;

Line 2670: fnd_msg_pub.initialize;

2666: (p_template_rules_tbl => p_rule_rec.template_rules_tbl);
2667: END IF;
2668:
2669: -- POST VALIDATION
2670: fnd_msg_pub.initialize;
2671:
2672: IF validaterulecondition (g_rule_id) = 'N'
2673: THEN
2674: p_rule_rec.status := g_ret_sts_error;

Line 2697: fnd_msg_pub.initialize;

2693: l_outcomes_count NUMBER;
2694: l_flag VARCHAR2 (1);
2695: l_failed_rec_num NUMBER := 0;
2696: BEGIN
2697: fnd_msg_pub.initialize;
2698:
2699: -- Get rule status, rule type
2700: BEGIN
2701: SELECT status_code, rule_type

Line 2717: fnd_msg_pub.initialize;

2713: );
2714: RAISE;
2715: END;
2716:
2717: fnd_msg_pub.initialize;
2718:
2719: -- Check whether the rules is available for update
2720: IF g_rule_status_code NOT IN ('DRAFT', 'REVISION', 'ACTIVE')
2721: THEN

Line 2946: fnd_msg_pub.initialize;

2942: set_rec_num_message (p_rec_num => l_failed_rec_num);
2943: read_message (l_error_message);
2944: p_rule_tbl (i).errmsg := l_error_message;
2945: ROLLBACK TO create_rule_sp;
2946: fnd_msg_pub.initialize;
2947: WHEN OTHERS
2948: THEN
2949: p_rule_tbl (i).status := g_ret_sts_error;
2950: set_proc_error_message (p_proc => l_proc);

Line 2962: fnd_msg_pub.initialize;

2958: );
2959: read_message (l_error_message);
2960: p_rule_tbl (i).errmsg := l_error_message;
2961: ROLLBACK TO create_rule_sp;
2962: fnd_msg_pub.initialize;
2963: END;
2964: END LOOP;
2965: END IF;
2966: EXCEPTION

Line 3015: fnd_msg_pub.initialize;

3011: set_rec_num_message (p_rec_num => l_failed_rec_num);
3012: read_message (l_error_message);
3013: p_rule_tbl (i).errmsg := l_error_message;
3014: ROLLBACK TO update_rule_sp;
3015: fnd_msg_pub.initialize;
3016: WHEN OTHERS
3017: THEN
3018: p_rule_tbl (i).status := g_ret_sts_error;
3019: set_proc_error_message (p_proc => l_proc);

Line 3031: fnd_msg_pub.initialize;

3027: );
3028: read_message (l_error_message);
3029: p_rule_tbl (i).errmsg := l_error_message;
3030: ROLLBACK TO update_rule_sp;
3031: fnd_msg_pub.initialize;
3032: END;
3033: END LOOP;
3034: END IF;
3035: EXCEPTION

Line 3089: fnd_msg_pub.initialize;

3085:
3086: read_message (l_error_message);
3087: p_rule_child_entities_tbl (i).errmsg := l_error_message;
3088: ROLLBACK TO del_rule_child_entity_sp;
3089: fnd_msg_pub.initialize;
3090: END;
3091: END LOOP;
3092: END IF;
3093: EXCEPTION