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.PQP_SCHEDULE_CALCULATION_PKG dependencies on PQP_UTILITIES

Line 46: pqp_utilities.debug(p_trace_message, p_trace_location);

42: ,p_trace_location IN NUMBER DEFAULT NULL
43: )
44: IS
45: BEGIN
46: pqp_utilities.debug(p_trace_message, p_trace_location);
47: END debug;
48:
49: --
50: --

Line 55: pqp_utilities.debug(p_trace_number);

51: --
52: PROCEDURE debug(p_trace_number IN NUMBER)
53: IS
54: BEGIN
55: pqp_utilities.debug(p_trace_number);
56: END debug;
57:
58: --
59: --

Line 64: pqp_utilities.debug(p_trace_date);

60: --
61: PROCEDURE debug(p_trace_date IN DATE)
62: IS
63: BEGIN
64: pqp_utilities.debug(p_trace_date);
65: END debug;
66:
67: --
68: --

Line 76: pqp_utilities.debug_enter(p_proc_name, p_trace_on);

72: ,p_trace_on IN VARCHAR2 DEFAULT NULL
73: )
74: IS
75: BEGIN
76: pqp_utilities.debug_enter(p_proc_name, p_trace_on);
77: END debug_enter;
78:
79: --
80: --

Line 88: pqp_utilities.debug_exit(p_proc_name, p_trace_off);

84: ,p_trace_off IN VARCHAR2 DEFAULT NULL
85: )
86: IS
87: BEGIN
88: pqp_utilities.debug_exit(p_proc_name, p_trace_off);
89: END debug_exit;
90:
91: --
92: --

Line 100: pqp_utilities.debug_others(p_proc_name, p_proc_step);

96: ,p_proc_step IN NUMBER DEFAULT NULL
97: )
98: IS
99: BEGIN
100: pqp_utilities.debug_others(p_proc_name, p_proc_step);
101: END debug_others;
102: --
103: --
104: --

Line 111: pqp_utilities.check_error_code(p_error_code, p_error_message);

107: ,p_error_message IN VARCHAR2
108: )
109: IS
110: BEGIN
111: pqp_utilities.check_error_code(p_error_code, p_error_message);
112: END;
113: --
114: --
115: --

Line 1548: pqp_utilities.debug_enter(l_proc_name);

1544: and p_effective_date between paa.effective_start_date
1545: and paa.effective_end_date ;
1546: begin
1547: IF g_debug THEN
1548: pqp_utilities.debug_enter(l_proc_name);
1549: pqp_utilities.debug('p_assignment_id:'||p_assignment_id);
1550: pqp_utilities.debug('p_business_group_id:'||p_business_group_id);
1551: pqp_utilities.debug('p_effective_date:'||p_effective_date);
1552: END IF;

Line 1549: pqp_utilities.debug('p_assignment_id:'||p_assignment_id);

1545: and paa.effective_end_date ;
1546: begin
1547: IF g_debug THEN
1548: pqp_utilities.debug_enter(l_proc_name);
1549: pqp_utilities.debug('p_assignment_id:'||p_assignment_id);
1550: pqp_utilities.debug('p_business_group_id:'||p_business_group_id);
1551: pqp_utilities.debug('p_effective_date:'||p_effective_date);
1552: END IF;
1553:

Line 1550: pqp_utilities.debug('p_business_group_id:'||p_business_group_id);

1546: begin
1547: IF g_debug THEN
1548: pqp_utilities.debug_enter(l_proc_name);
1549: pqp_utilities.debug('p_assignment_id:'||p_assignment_id);
1550: pqp_utilities.debug('p_business_group_id:'||p_business_group_id);
1551: pqp_utilities.debug('p_effective_date:'||p_effective_date);
1552: END IF;
1553:
1554: IF p_override_wp IS NOT NULL THEN

Line 1551: pqp_utilities.debug('p_effective_date:'||p_effective_date);

1547: IF g_debug THEN
1548: pqp_utilities.debug_enter(l_proc_name);
1549: pqp_utilities.debug('p_assignment_id:'||p_assignment_id);
1550: pqp_utilities.debug('p_business_group_id:'||p_business_group_id);
1551: pqp_utilities.debug('p_effective_date:'||p_effective_date);
1552: END IF;
1553:
1554: IF p_override_wp IS NOT NULL THEN
1555: l_proc_step := 10 ;

Line 1557: pqp_utilities.debug(' Override WP:'||p_override_wp);

1553:
1554: IF p_override_wp IS NOT NULL THEN
1555: l_proc_step := 10 ;
1556: IF g_debug THEN
1557: pqp_utilities.debug(' Override WP:'||p_override_wp);
1558: END IF;
1559: l_work_pattern := p_override_wp ;
1560: ELSE
1561: l_proc_step := 20 ;

Line 1573: pqp_utilities.debug('Work Pattern:'||l_work_pattern);

1569: l_work_pattern := NVL(l_work_pattern,p_default_wp);
1570:
1571: l_proc_step := 30 ;
1572: IF g_debug THEN
1573: pqp_utilities.debug('Work Pattern:'||l_work_pattern);
1574: END IF ;
1575:
1576: IF l_work_pattern IS NOT NULL THEN
1577:

Line 1579: l_retval := pqp_utilities.pqp_gb_get_table_value(

1575:
1576: IF l_work_pattern IS NOT NULL THEN
1577:
1578: -- FOR i in 1..7 loop
1579: l_retval := pqp_utilities.pqp_gb_get_table_value(
1580: p_business_group_id => p_business_group_id
1581: ,p_effective_date => p_effective_date
1582: ,p_table_name => 'PQP_COMPANY_WORK_PATTERNS'
1583: ,p_column_name => l_work_pattern

Line 1601: pqp_utilities.debug(l_proc_step);

1597: IF l_value IS NULL THEN
1598:
1599: l_proc_step := 35 ;
1600: IF g_debug THEN
1601: pqp_utilities.debug(l_proc_step);
1602: pqp_utilities.debug('p_assignment_id:'||p_assignment_id);
1603: END IF;
1604:
1605: pqp_update_work_pattern_table.update_working_days_in_week

Line 1602: pqp_utilities.debug('p_assignment_id:'||p_assignment_id);

1598:
1599: l_proc_step := 35 ;
1600: IF g_debug THEN
1601: pqp_utilities.debug(l_proc_step);
1602: pqp_utilities.debug('p_assignment_id:'||p_assignment_id);
1603: END IF;
1604:
1605: pqp_update_work_pattern_table.update_working_days_in_week
1606: (errbuf => l_errbuff

Line 1615: pqp_utilities.debug(l_proc_step);

1611: );
1612:
1613: l_proc_step := 40 ;
1614: IF g_debug THEN
1615: pqp_utilities.debug(l_proc_step);
1616: pqp_utilities.debug('errbuf:'||l_errbuff);
1617: pqp_utilities.debug('retcode:',l_retcode);
1618: END IF;
1619:

Line 1616: pqp_utilities.debug('errbuf:'||l_errbuff);

1612:
1613: l_proc_step := 40 ;
1614: IF g_debug THEN
1615: pqp_utilities.debug(l_proc_step);
1616: pqp_utilities.debug('errbuf:'||l_errbuff);
1617: pqp_utilities.debug('retcode:',l_retcode);
1618: END IF;
1619:
1620: l_retval :=

Line 1617: pqp_utilities.debug('retcode:',l_retcode);

1613: l_proc_step := 40 ;
1614: IF g_debug THEN
1615: pqp_utilities.debug(l_proc_step);
1616: pqp_utilities.debug('errbuf:'||l_errbuff);
1617: pqp_utilities.debug('retcode:',l_retcode);
1618: END IF;
1619:
1620: l_retval :=
1621: pqp_utilities.pqp_gb_get_table_value

Line 1621: pqp_utilities.pqp_gb_get_table_value

1617: pqp_utilities.debug('retcode:',l_retcode);
1618: END IF;
1619:
1620: l_retval :=
1621: pqp_utilities.pqp_gb_get_table_value
1622: (p_business_group_id => p_business_group_id
1623: ,p_effective_date => p_effective_date
1624: ,p_table_name => 'PQP_COMPANY_WORK_PATTERNS'
1625: ,p_column_name => l_work_pattern

Line 1634: pqp_utilities.debug(l_proc_step);

1630: ) ;
1631:
1632: l_proc_step := 45 ;
1633: IF g_debug THEN
1634: pqp_utilities.debug(l_proc_step);
1635: pqp_utilities.debug('l_error_message:'||l_error_message);
1636: pqp_utilities.debug('l_retval:',l_retval);
1637: pqp_utilities.debug('l_value:',l_value);
1638: END IF;

Line 1635: pqp_utilities.debug('l_error_message:'||l_error_message);

1631:
1632: l_proc_step := 45 ;
1633: IF g_debug THEN
1634: pqp_utilities.debug(l_proc_step);
1635: pqp_utilities.debug('l_error_message:'||l_error_message);
1636: pqp_utilities.debug('l_retval:',l_retval);
1637: pqp_utilities.debug('l_value:',l_value);
1638: END IF;
1639:

Line 1636: pqp_utilities.debug('l_retval:',l_retval);

1632: l_proc_step := 45 ;
1633: IF g_debug THEN
1634: pqp_utilities.debug(l_proc_step);
1635: pqp_utilities.debug('l_error_message:'||l_error_message);
1636: pqp_utilities.debug('l_retval:',l_retval);
1637: pqp_utilities.debug('l_value:',l_value);
1638: END IF;
1639:
1640: IF l_value IS NULL THEN

Line 1637: pqp_utilities.debug('l_value:',l_value);

1633: IF g_debug THEN
1634: pqp_utilities.debug(l_proc_step);
1635: pqp_utilities.debug('l_error_message:'||l_error_message);
1636: pqp_utilities.debug('l_retval:',l_retval);
1637: pqp_utilities.debug('l_value:',l_value);
1638: END IF;
1639:
1640: IF l_value IS NULL THEN
1641: fnd_message.set_name( 'PQP', 'PQP_230138_INV_WORK_PATTERN' );

Line 1653: pqp_utilities.debug_exit(l_proc_name) ;

1649: END IF; -- l_work_pattern IS NOT NULL THEN
1650:
1651:
1652: IF g_debug THEN
1653: pqp_utilities.debug_exit(l_proc_name) ;
1654: END IF ;
1655:
1656: RETURN l_value ; -- l_count ;
1657:

Line 1661: pqp_utilities.debug_others

1657:
1658: EXCEPTION
1659: WHEN OTHERS THEN
1660: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1661: pqp_utilities.debug_others
1662: (l_proc_name
1663: ,l_proc_step
1664: );
1665: IF g_debug THEN

Line 1666: pqp_utilities.debug('Leaving: '||l_proc_name,-999);

1662: (l_proc_name
1663: ,l_proc_step
1664: );
1665: IF g_debug THEN
1666: pqp_utilities.debug('Leaving: '||l_proc_name,-999);
1667: END IF;
1668: fnd_message.raise_error;
1669: ELSE
1670: RAISE;