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 1554: pqp_utilities.debug_enter(l_proc_name);

1550: and p_effective_date between paa.effective_start_date
1551: and paa.effective_end_date ;
1552: begin
1553: IF g_debug THEN
1554: pqp_utilities.debug_enter(l_proc_name);
1555: pqp_utilities.debug('p_assignment_id:'||p_assignment_id);
1556: pqp_utilities.debug('p_business_group_id:'||p_business_group_id);
1557: pqp_utilities.debug('p_effective_date:'||p_effective_date);
1558: END IF;

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

1551: and paa.effective_end_date ;
1552: begin
1553: IF g_debug THEN
1554: pqp_utilities.debug_enter(l_proc_name);
1555: pqp_utilities.debug('p_assignment_id:'||p_assignment_id);
1556: pqp_utilities.debug('p_business_group_id:'||p_business_group_id);
1557: pqp_utilities.debug('p_effective_date:'||p_effective_date);
1558: END IF;
1559:

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

1552: begin
1553: IF g_debug THEN
1554: pqp_utilities.debug_enter(l_proc_name);
1555: pqp_utilities.debug('p_assignment_id:'||p_assignment_id);
1556: pqp_utilities.debug('p_business_group_id:'||p_business_group_id);
1557: pqp_utilities.debug('p_effective_date:'||p_effective_date);
1558: END IF;
1559:
1560: IF p_override_wp IS NOT NULL THEN

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

1553: IF g_debug THEN
1554: pqp_utilities.debug_enter(l_proc_name);
1555: pqp_utilities.debug('p_assignment_id:'||p_assignment_id);
1556: pqp_utilities.debug('p_business_group_id:'||p_business_group_id);
1557: pqp_utilities.debug('p_effective_date:'||p_effective_date);
1558: END IF;
1559:
1560: IF p_override_wp IS NOT NULL THEN
1561: l_proc_step := 10 ;

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

1559:
1560: IF p_override_wp IS NOT NULL THEN
1561: l_proc_step := 10 ;
1562: IF g_debug THEN
1563: pqp_utilities.debug(' Override WP:'||p_override_wp);
1564: END IF;
1565: l_work_pattern := p_override_wp ;
1566: ELSE
1567: l_proc_step := 20 ;

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

1575: l_work_pattern := NVL(l_work_pattern,p_default_wp);
1576:
1577: l_proc_step := 30 ;
1578: IF g_debug THEN
1579: pqp_utilities.debug('Work Pattern:'||l_work_pattern);
1580: END IF ;
1581:
1582: IF l_work_pattern IS NOT NULL THEN
1583:

Line 1585: l_retval := pqp_utilities.pqp_gb_get_table_value(

1581:
1582: IF l_work_pattern IS NOT NULL THEN
1583:
1584: -- FOR i in 1..7 loop
1585: l_retval := pqp_utilities.pqp_gb_get_table_value(
1586: p_business_group_id => p_business_group_id
1587: ,p_effective_date => p_effective_date
1588: ,p_table_name => 'PQP_COMPANY_WORK_PATTERNS'
1589: ,p_column_name => l_work_pattern

Line 1607: pqp_utilities.debug(l_proc_step);

1603: IF l_value IS NULL THEN
1604:
1605: l_proc_step := 35 ;
1606: IF g_debug THEN
1607: pqp_utilities.debug(l_proc_step);
1608: pqp_utilities.debug('p_assignment_id:'||p_assignment_id);
1609: END IF;
1610:
1611: pqp_update_work_pattern_table.update_working_days_in_week

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

1604:
1605: l_proc_step := 35 ;
1606: IF g_debug THEN
1607: pqp_utilities.debug(l_proc_step);
1608: pqp_utilities.debug('p_assignment_id:'||p_assignment_id);
1609: END IF;
1610:
1611: pqp_update_work_pattern_table.update_working_days_in_week
1612: (errbuf => l_errbuff

Line 1621: pqp_utilities.debug(l_proc_step);

1617: );
1618:
1619: l_proc_step := 40 ;
1620: IF g_debug THEN
1621: pqp_utilities.debug(l_proc_step);
1622: pqp_utilities.debug('errbuf:'||l_errbuff);
1623: pqp_utilities.debug('retcode:',l_retcode);
1624: END IF;
1625:

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

1618:
1619: l_proc_step := 40 ;
1620: IF g_debug THEN
1621: pqp_utilities.debug(l_proc_step);
1622: pqp_utilities.debug('errbuf:'||l_errbuff);
1623: pqp_utilities.debug('retcode:',l_retcode);
1624: END IF;
1625:
1626: l_retval :=

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

1619: l_proc_step := 40 ;
1620: IF g_debug THEN
1621: pqp_utilities.debug(l_proc_step);
1622: pqp_utilities.debug('errbuf:'||l_errbuff);
1623: pqp_utilities.debug('retcode:',l_retcode);
1624: END IF;
1625:
1626: l_retval :=
1627: pqp_utilities.pqp_gb_get_table_value

Line 1627: pqp_utilities.pqp_gb_get_table_value

1623: pqp_utilities.debug('retcode:',l_retcode);
1624: END IF;
1625:
1626: l_retval :=
1627: pqp_utilities.pqp_gb_get_table_value
1628: (p_business_group_id => p_business_group_id
1629: ,p_effective_date => p_effective_date
1630: ,p_table_name => 'PQP_COMPANY_WORK_PATTERNS'
1631: ,p_column_name => l_work_pattern

Line 1640: pqp_utilities.debug(l_proc_step);

1636: ) ;
1637:
1638: l_proc_step := 45 ;
1639: IF g_debug THEN
1640: pqp_utilities.debug(l_proc_step);
1641: pqp_utilities.debug('l_error_message:'||l_error_message);
1642: pqp_utilities.debug('l_retval:',l_retval);
1643: pqp_utilities.debug('l_value:',l_value);
1644: END IF;

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

1637:
1638: l_proc_step := 45 ;
1639: IF g_debug THEN
1640: pqp_utilities.debug(l_proc_step);
1641: pqp_utilities.debug('l_error_message:'||l_error_message);
1642: pqp_utilities.debug('l_retval:',l_retval);
1643: pqp_utilities.debug('l_value:',l_value);
1644: END IF;
1645:

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

1638: l_proc_step := 45 ;
1639: IF g_debug THEN
1640: pqp_utilities.debug(l_proc_step);
1641: pqp_utilities.debug('l_error_message:'||l_error_message);
1642: pqp_utilities.debug('l_retval:',l_retval);
1643: pqp_utilities.debug('l_value:',l_value);
1644: END IF;
1645:
1646: IF l_value IS NULL THEN

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

1639: IF g_debug THEN
1640: pqp_utilities.debug(l_proc_step);
1641: pqp_utilities.debug('l_error_message:'||l_error_message);
1642: pqp_utilities.debug('l_retval:',l_retval);
1643: pqp_utilities.debug('l_value:',l_value);
1644: END IF;
1645:
1646: IF l_value IS NULL THEN
1647: fnd_message.set_name( 'PQP', 'PQP_230138_INV_WORK_PATTERN' );

Line 1659: pqp_utilities.debug_exit(l_proc_name) ;

1655: END IF; -- l_work_pattern IS NOT NULL THEN
1656:
1657:
1658: IF g_debug THEN
1659: pqp_utilities.debug_exit(l_proc_name) ;
1660: END IF ;
1661:
1662: RETURN l_value ; -- l_count ;
1663:

Line 1667: pqp_utilities.debug_others

1663:
1664: EXCEPTION
1665: WHEN OTHERS THEN
1666: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1667: pqp_utilities.debug_others
1668: (l_proc_name
1669: ,l_proc_step
1670: );
1671: IF g_debug THEN

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

1668: (l_proc_name
1669: ,l_proc_step
1670: );
1671: IF g_debug THEN
1672: pqp_utilities.debug('Leaving: '||l_proc_name,-999);
1673: END IF;
1674: fnd_message.raise_error;
1675: ELSE
1676: RAISE;