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.GMD_ROUTINGS_PVT dependencies on GMD_DEBUG

Line 71: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'

67: IF p_routings.routing_id IS NOT NULL THEN
68:
69: /* Step : Create Routing header */
70: IF (l_debug = 'Y') THEN
71: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
72: ||'Inserting the routing header with routing id '||l_routing_id);
73: END IF;
74:
75: GMD_ROUTINGS_PKG.insert_row(

Line 141: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||

137: END IF; /* l_routing_id IS NOT NULL */
138:
139: -- Check if routing header was created
140: IF (l_debug = 'Y') THEN
141: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||
142: 'Row id value after inserting routing is '||l_row_id);
143: END IF;
144: IF l_row_id IS NULL THEN
145: RAISE routing_creation_failure;

Line 154: gmd_debug.put_line('Completed '||l_api_name ||' at '

150: ,p_encoded => FND_API.g_false
151: ,p_data => x_message_list);
152:
153: IF (l_debug = 'Y') THEN
154: gmd_debug.put_line('Completed '||l_api_name ||' at '
155: ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
156: END IF;
157: EXCEPTION
158: WHEN routing_creation_failure OR invalid_version THEN

Line 160: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');

156: END IF;
157: EXCEPTION
158: WHEN routing_creation_failure OR invalid_version THEN
159: IF (l_debug = 'Y') THEN
160: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
161: END IF;
162: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
163: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
164: FND_MSG_PUB.ADD;

Line 178: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);

174: ,p_encoded => FND_API.g_false
175: ,p_data => x_message_list);
176: WHEN OTHERS THEN
177: IF (l_debug = 'Y') THEN
178: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
179: END IF;
180: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
181: x_return_status := FND_API.g_ret_sts_unexp_error;
182: fnd_msg_pub.count_and_get (

Line 338: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'

334: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'IN_USE') THEN
335: l_old_routing_rec.IN_USE := p_update_table(i).p_value;
336: ELSIF (UPPER(p_update_table(i).p_col_to_update) like '%START_DATE%') THEN
337: IF (l_debug = 'Y') THEN
338: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
339: ||'The eff_start_date for Routing prior to update = '||
340: p_update_table(i).p_value);
341: END IF;
342: l_old_routing_rec.EFFECTIVE_START_DATE

Line 346: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'

342: l_old_routing_rec.EFFECTIVE_START_DATE
343: := FND_DATE.canonical_to_date(p_update_table(i).p_value);
344: ELSIF (UPPER(p_update_table(i).p_col_to_update) like '%END_DATE%') THEN
345: IF (l_debug = 'Y') THEN
346: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
347: ||'The eff_end_date for Routing prior to update = '||
348: p_update_table(i).p_value);
349: END IF;
350:

Line 458: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'

454: OPEN Get_vr_start_end_dates(p_routing_id);
455: FETCH Get_vr_start_end_dates INTO l_vr_start_date, l_vr_end_date;
456: IF l_vr_start_date IS NOT NULL THEN
457: IF (l_debug = 'Y') THEN
458: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
459: ||'Comparing VR and Routing Start Dates '||
460: 'Routing Start Date = '||l_old_routing_rec.effective_start_date||
461: ' VR Start Date = '||l_vr_start_date);
462: END IF;

Line 475: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'

471: l_vr_end_date := Null;
472: END IF;
473:
474: IF (l_debug = 'Y') THEN
475: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
476: ||'Comparing VR and Routing End Dates '||
477: 'Routing end Date = '||l_old_routing_rec.effective_end_date||
478: ' VR end Date = '||l_vr_end_date);
479: END IF;

Line 570: gmd_debug.put_line('Completed '||l_api_name ||' at '

566: ,p_encoded => FND_API.g_false
567: ,p_data => x_message_list);
568:
569: IF (l_debug = 'Y') THEN
570: gmd_debug.put_line('Completed '||l_api_name ||' at '
571: ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
572: END IF;
573: EXCEPTION
574: WHEN routing_update_failure OR invalid_version THEN

Line 576: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');

572: END IF;
573: EXCEPTION
574: WHEN routing_update_failure OR invalid_version THEN
575: IF (l_debug = 'Y') THEN
576: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
577: END IF;
578: x_return_status := FND_API.G_RET_STS_ERROR;
579: fnd_msg_pub.count_and_get (
580: p_count => x_message_count

Line 599: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);

595: ,p_encoded => FND_API.g_false
596: ,p_data => x_message_list);
597: WHEN OTHERS THEN
598: IF (l_debug = 'Y') THEN
599: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
600: END IF;
601: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
602: x_return_status := FND_API.g_ret_sts_unexp_error;
603: fnd_msg_pub.count_and_get (

Line 642: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'

638: /* Effective end date must be greater than start date, otherwise give error */
639: IF p_effective_start_date
640: > p_effective_end_date THEN
641: IF (l_debug = 'Y') THEN
642: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
643: ||'Effective start date ('||
644: p_effective_start_date||' ) '||
645: 'must be less then end date ( '||
646: p_effective_end_date||' ) ');

Line 658: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'

654: OPEN Get_oprn_start_end_dates(p_routing_id);
655: FETCH Get_oprn_start_end_dates INTO l_oprn_start_date, l_oprn_end_date;
656: IF l_oprn_start_date IS NOT NULL THEN
657: IF (l_debug = 'Y') THEN
658: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
659: ||'Comparing Oprn and Routing Start Dates '||
660: 'Routing Start Date = '||p_effective_start_date||
661: ' Oprn Start Date = '||l_oprn_start_date);
662: END IF;

Line 670: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'

666: RETURN -1;
667: END IF;
668:
669: IF (l_debug = 'Y') THEN
670: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
671: ||'Comparing Oprn and Routing End Dates '||
672: 'Routing end Date = '||
673: p_effective_end_date||
674: ' Oprn end Date = '||l_oprn_end_date);