DBA Data[Home] [Help]

APPS.PO_HXC_INTERFACE_PVT dependencies on PO_DEBUG

Line 6: g_debug_unexp BOOLEAN := PO_DEBUG.is_debug_unexp_on;

2: /* $Header: POXVIHXB.pls 120.2 2007/12/24 16:10:24 cvardia ship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_HXC_INTERFACE_PVT';
5: g_log_head CONSTANT VARCHAR2(40) := 'po.plsql.' || g_pkg_name || '.';
6: g_debug_unexp BOOLEAN := PO_DEBUG.is_debug_unexp_on;
7: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;
8:
9: -------------------------------------------------------------------------------
10: --Start of Comments

Line 7: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;

3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_HXC_INTERFACE_PVT';
5: g_log_head CONSTANT VARCHAR2(40) := 'po.plsql.' || g_pkg_name || '.';
6: g_debug_unexp BOOLEAN := PO_DEBUG.is_debug_unexp_on;
7: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;
8:
9: -------------------------------------------------------------------------------
10: --Start of Comments
11: --Name: get_timecard_amount

Line 47: PO_DEBUG.debug_begin(l_log_head);

43: l_progress VARCHAR2(3) := '000';
44: l_person_id PER_ALL_PEOPLE_F.person_id%TYPE;
45: BEGIN
46: IF g_debug_stmt THEN
47: PO_DEBUG.debug_begin(l_log_head);
48: END IF;
49:
50: x_return_status := FND_API.G_RET_STS_SUCCESS;
51:

Line 66: PO_DEBUG.debug_stmt(l_log_head, l_progress,

62: l_person_id := HR_PO_INFO.get_person_id_for_po_line (
63: p_po_line_id => p_po_line_id );
64:
65: IF g_debug_stmt THEN
66: PO_DEBUG.debug_stmt(l_log_head, l_progress,
67: 'Calling OTL API get_mappingvalue_sum for'
68: ||' po_line_id: '||p_po_line_id
69: ||', person_id: '||l_person_id);
70: END IF;

Line 86: PO_DEBUG.debug_stmt(l_log_head, l_progress,

82: p_status => g_status_SUBMITTED,
83: p_resource_id => l_person_id);
84:
85: IF g_debug_stmt THEN
86: PO_DEBUG.debug_stmt(l_log_head, l_progress,
87: 'get_mappingvalue_sum returned: '||x_amount);
88: END IF;
89: END IF;
90:

Line 95: PO_DEBUG.debug_exc(l_log_head, l_progress);

91: EXCEPTION
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: IF g_debug_unexp THEN
95: PO_DEBUG.debug_exc(l_log_head, l_progress);
96: END IF;
97: WHEN OTHERS THEN
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
99: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 101: PO_DEBUG.debug_exc(l_log_head, l_progress);

97: WHEN OTHERS THEN
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
99: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
100: IF g_debug_unexp THEN
101: PO_DEBUG.debug_exc(l_log_head, l_progress);
102: END IF;
103: END get_timecard_amount;
104:
105: -------------------------------------------------------------------------------

Line 149: PO_DEBUG.debug_begin(l_log_head);

145: l_api_version CONSTANT NUMBER := 1.0;
146: l_progress VARCHAR2(3) := '000';
147: BEGIN
148: IF g_debug_stmt THEN
149: PO_DEBUG.debug_begin(l_log_head);
150: END IF;
151:
152: x_return_status := FND_API.G_RET_STS_SUCCESS;
153:

Line 164: PO_DEBUG.debug_stmt(l_log_head, l_progress,

160: RAISE FND_API.g_exc_unexpected_error;
161: END IF;
162:
163: IF g_debug_stmt THEN
164: PO_DEBUG.debug_stmt(l_log_head, l_progress,
165: 'Calling OTL API chk_mapping_exists for'
166: ||' field_name: '||p_field_name
167: ||' field_value: '||p_field_value
168: ||', end_date: '||p_end_date);

Line 192: PO_DEBUG.debug_stmt(l_log_head, l_progress,

188: );
189:
190: IF g_debug_stmt THEN
191: IF (x_timecard_exists) THEN
192: PO_DEBUG.debug_stmt(l_log_head, l_progress,
193: 'chk_mapping_exists returned true.');
194: ELSE
195: PO_DEBUG.debug_stmt(l_log_head, l_progress,
196: 'chk_mapping_exists returned false.');

Line 195: PO_DEBUG.debug_stmt(l_log_head, l_progress,

191: IF (x_timecard_exists) THEN
192: PO_DEBUG.debug_stmt(l_log_head, l_progress,
193: 'chk_mapping_exists returned true.');
194: ELSE
195: PO_DEBUG.debug_stmt(l_log_head, l_progress,
196: 'chk_mapping_exists returned false.');
197: END IF;
198: END IF;
199:

Line 204: PO_DEBUG.debug_exc(l_log_head, l_progress);

200: EXCEPTION
201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: IF g_debug_unexp THEN
204: PO_DEBUG.debug_exc(l_log_head, l_progress);
205: END IF;
206: WHEN OTHERS THEN
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 210: PO_DEBUG.debug_exc(l_log_head, l_progress);

206: WHEN OTHERS THEN
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
209: IF g_debug_unexp THEN
210: PO_DEBUG.debug_exc(l_log_head, l_progress);
211: END IF;
212: END check_timecard_exists;
213:
214: -------------------------------------------------------------------------------

Line 360: PO_DEBUG.debug_begin(l_log_head);

356: l_progress VARCHAR2(3) := '000';
357: l_person_id PER_ALL_PEOPLE_F.person_id%TYPE;
358: BEGIN
359: IF g_debug_stmt THEN
360: PO_DEBUG.debug_begin(l_log_head);
361: END IF;
362:
363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364:

Line 379: PO_DEBUG.debug_stmt(l_log_head, l_progress,

375: l_person_id := HR_PO_INFO.get_person_id_for_po_line (
376: p_po_line_id => p_po_line_id );
377:
378: IF g_debug_stmt THEN
379: PO_DEBUG.debug_stmt(l_log_head, l_progress,
380: 'Calling OTL API get_mappingvalue_sum for'
381: ||' po_line_id: '||p_po_line_id
382: ||' project_id: '||p_project_id
383: ||' task_id: '||p_task_id

Line 408: PO_DEBUG.debug_stmt(l_log_head, l_progress,

404: p_status => g_status_SUBMITTED,
405: p_resource_id => l_person_id);
406:
407: IF g_debug_stmt THEN
408: PO_DEBUG.debug_stmt(l_log_head, l_progress,
409: 'get_mappingvalue_sum for projects returned: '||x_amount);
410: END IF;
411: END IF;
412:

Line 417: PO_DEBUG.debug_exc(l_log_head, l_progress);

413: EXCEPTION
414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: IF g_debug_unexp THEN
417: PO_DEBUG.debug_exc(l_log_head, l_progress);
418: END IF;
419: WHEN OTHERS THEN
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 423: PO_DEBUG.debug_exc(l_log_head, l_progress);

419: WHEN OTHERS THEN
420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
421: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
422: IF g_debug_unexp THEN
423: PO_DEBUG.debug_exc(l_log_head, l_progress);
424: END IF;
425: END get_pa_timecard_amount;
426:
427: END PO_HXC_INTERFACE_PVT;