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_ROUTING_STEPS_PVT dependencies on GMD_DEBUG

Line 73: gmd_debug.put_line('Get the routingstep id value : ');

69: x_return_status := FND_API.G_RET_STS_SUCCESS;
70:
71: /* Get the routingStep_id from sequence generator */
72: IF (l_debug = 'Y') THEN
73: gmd_debug.put_line('Get the routingstep id value : ');
74: END IF;
75:
76: IF p_routing_step_rec.routingstep_id IS NULL THEN
77: OPEN Get_routingstep_id_seq;

Line 90: gmd_debug.put_line('Insert the routing steps for routing with routingstep id = '||l_routingstep_id);

86: END IF;
87:
88: /* Step 1 : Create Routing steps */
89: IF (l_debug = 'Y') THEN
90: gmd_debug.put_line('Insert the routing steps for routing with routingstep id = '||l_routingstep_id);
91: END IF;
92:
93: INSERT INTO fm_rout_dtl
94: ( routing_id, routingstep_no, routingstep_id , oprn_id ,step_qty, steprelease_type, text_code

Line 127: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

123: ,p_routing_step_rec.attribute_category, p_routing_step_rec.x_coordinate
124: ,p_routing_step_rec.y_coordinate,p_routing_step_rec.minimum_transfer_qty);
125:
126: IF (l_debug = 'Y') THEN
127: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
128: END IF;
129: EXCEPTION
130: WHEN routing_step_creation_failure OR invalid_version THEN
131: IF (l_debug = 'Y') THEN

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

128: END IF;
129: EXCEPTION
130: WHEN routing_step_creation_failure OR invalid_version THEN
131: IF (l_debug = 'Y') THEN
132: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete '||SQLERRM);
133: END IF;
134: x_return_status := FND_API.G_RET_STS_ERROR;
135: WHEN setup_failure THEN
136: x_return_status := FND_API.G_RET_STS_ERROR;

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

136: x_return_status := FND_API.G_RET_STS_ERROR;
137: WHEN OTHERS THEN
138: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
139: IF (l_debug = 'Y') THEN
140: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
141: END IF;
142: x_return_status := FND_API.g_ret_sts_unexp_error;
143: END insert_routing_steps;
144:

Line 188: gmd_debug.log_initialize('Crsdpvt');

184:
185:
186: BEGIN
187: IF (l_debug = 'Y') THEN
188: gmd_debug.log_initialize('Crsdpvt');
189: END IF;
190:
191: /* Intialize the setup fields */
192: IF NOT gmd_api_grp.setup_done THEN

Line 247: gmd_debug.put_line('After inserting routing step dependencies');

243: );
244:
245: -- Check if routing step dependencies were created
246: IF (l_debug = 'Y') THEN
247: gmd_debug.put_line('After inserting routing step dependencies');
248: END IF;
249:
250: IF SQL%ROWCOUNT = 0 THEN
251: RAISE routing_step_dep_failure;

Line 265: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

261: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
262: RAISE routing_step_dep_failure;
263: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
264: IF (l_debug = 'Y') THEN
265: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
266: END IF;
267:
268: EXCEPTION
269: WHEN routing_step_dep_failure OR invalid_version THEN

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

267:
268: EXCEPTION
269: WHEN routing_step_dep_failure OR invalid_version THEN
270: IF (l_debug = 'Y') THEN
271: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
272: END IF;
273: x_return_status := FND_API.G_RET_STS_ERROR;
274:
275: WHEN routing_cir_ref_failure THEN

Line 277: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete due circular reference');

273: x_return_status := FND_API.G_RET_STS_ERROR;
274:
275: WHEN routing_cir_ref_failure THEN
276: IF (l_debug = 'Y') THEN
277: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete due circular reference');
278: END IF;
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: WHEN setup_failure THEN
281: x_return_status := FND_API.G_RET_STS_ERROR;

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

281: x_return_status := FND_API.G_RET_STS_ERROR;
282: WHEN OTHERS THEN
283: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
284: IF (l_debug = 'Y') THEN
285: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
286: END IF;
287: x_return_status := FND_API.g_ret_sts_unexp_error;
288: END insert_step_dependencies;
289:

Line 334: gmd_debug.put_line('Fetch : Populate the old routing step record ');

330: x_return_status := FND_API.G_RET_STS_SUCCESS;
331:
332: /* Get the old routing rec value */
333: IF (l_debug = 'Y') THEN
334: gmd_debug.put_line('Fetch : Populate the old routing step record ');
335: END IF;
336:
337: /* Intialize the setup fields */
338: IF NOT gmd_api_grp.setup_done THEN

Line 362: gmd_debug.put_line('Seting the update column value ');

358: /* Actual update in fm_rout_dtl table */
359: /* Loop thro' every column in p_update_table table and for each column name
360: assign or replace the old value with the table value */
361: IF (l_debug = 'Y') THEN
362: gmd_debug.put_line('Seting the update column value ');
363: END IF;
364: FOR i IN 1 .. p_update_table.count LOOP
365: IF (UPPER(p_update_table(i).p_col_to_update) = 'STEP_QTY') THEN
366: l_old_routingStep_rec.STEP_QTY := p_update_table(i).p_value;

Line 459: gmd_debug.put_line('Before routing step table update ');

455: RAISE last_update_date_failure;
456: END IF;
457:
458: IF (l_debug = 'Y') THEN
459: gmd_debug.put_line('Before routing step table update ');
460: END IF;
461: UPDATE fm_rout_dtl
462: SET oprn_id = l_old_routingStep_rec.oprn_id
463: ,step_qty = l_old_routingStep_rec.step_qty

Line 506: gmd_debug.put_line('After routing step table update ');

502: ,y_coordinate = l_old_routingStep_rec.y_coordinate
503: WHERE routingStep_id = p_routingstep_id;
504:
505: IF (l_debug = 'Y') THEN
506: gmd_debug.put_line('After routing step table update ');
507: END IF;
508: IF SQL%ROWCOUNT = 0 THEN
509: RAISE routing_update_step_failure;
510: END IF;

Line 518: gmd_debug.put_line('Completed '||m_pkg_name||'.'||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
515: RAISE routing_update_step_failure;
516: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
517: IF (l_debug = 'Y') THEN
518: gmd_debug.put_line('Completed '||m_pkg_name||'.'||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
519: END IF;
520:
521: EXCEPTION
522: WHEN routing_update_step_failure OR invalid_version THEN

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

520:
521: EXCEPTION
522: WHEN routing_update_step_failure OR invalid_version THEN
523: IF (l_debug = 'Y') THEN
524: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
525: END IF;
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: WHEN last_update_date_failure THEN
528: x_return_status := FND_API.G_RET_STS_ERROR;

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

532: x_return_status := FND_API.G_RET_STS_ERROR;
533: WHEN OTHERS THEN
534: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
535: IF (l_debug = 'Y') THEN
536: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
537: END IF;
538: x_return_status := FND_API.g_ret_sts_unexp_error;
539: END update_routing_steps;
540:

Line 586: gmd_debug.log_initialize('Updsdpvt');

582: And Routing_id = vRouting_id;
583:
584: BEGIN
585: IF (l_debug = 'Y') THEN
586: gmd_debug.log_initialize('Updsdpvt');
587: END IF;
588:
589: /* Intialize the setup fields */
590: IF NOT gmd_api_grp.setup_done THEN

Line 679: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

675: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
676: RAISE routing_update_dep_failure;
677: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
678: IF (l_debug = 'Y') THEN
679: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
680: END IF;
681:
682: EXCEPTION
683: WHEN routing_update_dep_failure OR invalid_version THEN

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

681:
682: EXCEPTION
683: WHEN routing_update_dep_failure OR invalid_version THEN
684: IF (l_debug = 'Y') THEN
685: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
686: END IF;
687: x_return_status := FND_API.G_RET_STS_ERROR;
688: WHEN last_update_date_failure THEN
689: x_return_status := FND_API.G_RET_STS_ERROR;

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

693: x_return_status := FND_API.G_RET_STS_ERROR;
694: WHEN OTHERS THEN
695: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
696: IF (l_debug = 'Y') THEN
697: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
698: END IF;
699: x_return_status := FND_API.g_ret_sts_unexp_error;
700: END update_step_dependencies;
701:

Line 778: gmd_debug.log_initialize('Derspvt');

774: setup_failure EXCEPTION;
775:
776: BEGIN
777: IF (l_debug = 'Y') THEN
778: gmd_debug.log_initialize('Derspvt');
779: END IF;
780:
781: /* Intialize the setup fields */
782: IF NOT gmd_api_grp.setup_done THEN

Line 794: gmd_debug.put_line(' get the RoutingStep_id - if it is not passed as a parameter ');

790: x_return_status := FND_API.G_RET_STS_SUCCESS;
791:
792: /* Get the routingstep_no (routingstep_no is used for the routing step dep delete ) */
793: IF (l_debug = 'Y') THEN
794: gmd_debug.put_line(' get the RoutingStep_id - if it is not passed as a parameter ');
795: END IF;
796: IF p_routingStep_id IS NOT NULL THEN
797: l_routingstep_id := p_routingstep_id;
798: GMDRTVAL_PUB.get_routingstep_info(pxRoutingStep_no => l_routingstep_no

Line 810: gmd_debug.put_line('RoutingStep_no = '||l_routingStep_no );

806: END IF;
807: END IF;
808:
809: IF (l_debug = 'Y') THEN
810: gmd_debug.put_line('RoutingStep_no = '||l_routingStep_no );
811: END IF;
812:
813: /* Check if work was done */
814: IF SQL%ROWCOUNT = 0 THEN

Line 884: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

880: DELETE FROM fm_rout_dtl
881: WHERE routingStep_id = p_routingStep_id;
882:
883: IF (l_debug = 'Y') THEN
884: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
885: END IF;
886:
887: EXCEPTION
888: WHEN routing_delete_step_failure OR invalid_version THEN

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

886:
887: EXCEPTION
888: WHEN routing_delete_step_failure OR invalid_version THEN
889: IF (l_debug = 'Y') THEN
890: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
891: END IF;
892: x_return_status := FND_API.G_RET_STS_ERROR;
893: WHEN step_used_in_recipe THEN
894: IF (l_debug = 'Y') THEN

Line 895: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'routing step '||l_routingstep_no||' has override data ');

891: END IF;
892: x_return_status := FND_API.G_RET_STS_ERROR;
893: WHEN step_used_in_recipe THEN
894: IF (l_debug = 'Y') THEN
895: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'routing step '||l_routingstep_no||' has override data ');
896: END IF;
897: FND_MESSAGE.SET_NAME('GMD', 'GMD_STEP_USED_IN_RECIPE');
898: FND_MSG_PUB.ADD;
899: x_return_status := FND_API.G_RET_STS_ERROR;

Line 902: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'delete step dep API not complete');

898: FND_MSG_PUB.ADD;
899: x_return_status := FND_API.G_RET_STS_ERROR;
900: WHEN routing_delete_stepdep_failure THEN
901: IF (l_debug = 'Y') THEN
902: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'delete step dep API not complete');
903: END IF;
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: WHEN setup_failure THEN
906: x_return_status := FND_API.G_RET_STS_ERROR;

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

906: x_return_status := FND_API.G_RET_STS_ERROR;
907: WHEN OTHERS THEN
908: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
909: IF (l_debug = 'Y') THEN
910: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
911: END IF;
912: x_return_status := FND_API.g_ret_sts_unexp_error;
913: END delete_routing_step;
914:

Line 946: gmd_debug.log_initialize('Desdpvt');

942: setup_failure EXCEPTION;
943:
944: BEGIN
945: IF (l_debug = 'Y') THEN
946: gmd_debug.log_initialize('Desdpvt');
947: END IF;
948:
949: /* Set the return status to success initially */
950: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 956: gmd_Debug.put_line('About to delete from step dep table - the routingstep no = '||p_routingstep_no ||' and routing id = '||p_routing_id);

952: /* Actual delete in fm_rout_dep table */
953: /* This delete can be specific to a dep_routingstep_no or a
954: Routingstep_no */
955: IF (l_debug = 'Y') THEN
956: gmd_Debug.put_line('About to delete from step dep table - the routingstep no = '||p_routingstep_no ||' and routing id = '||p_routing_id);
957: END IF;
958:
959: /* Intialize the setup fields */
960: IF NOT gmd_api_grp.setup_done THEN

Line 983: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));

979: END IF;
980:
981: /* Check if work was done */
982: IF (l_debug = 'Y') THEN
983: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
984: END IF;
985:
986: EXCEPTION
987: WHEN routing_delete_dep_failure OR invalid_version THEN

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

985:
986: EXCEPTION
987: WHEN routing_delete_dep_failure OR invalid_version THEN
988: IF (l_debug = 'Y') THEN
989: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
990: END IF;
991: x_return_status := FND_API.G_RET_STS_ERROR;
992: WHEN setup_failure THEN
993: x_return_status := FND_API.G_RET_STS_ERROR;

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

993: x_return_status := FND_API.G_RET_STS_ERROR;
994: WHEN OTHERS THEN
995: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
996: IF (l_debug = 'Y') THEN
997: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
998: END IF;
999: x_return_status := FND_API.g_ret_sts_unexp_error;
1000:
1001: END delete_step_dependencies;