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

Line 144: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Begin of API');

140: fnd_msg_pub.initialize;
141: END IF;
142:
143: IF (l_debug = 'Y') THEN
144: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Begin of API');
145: END IF;
146:
147:
148: /* Intialize the setup fields */

Line 166: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing Number required');

162: END IF;
163:
164: IF p_routings.routing_no IS NULL THEN
165: IF (l_debug = 'Y') THEN
166: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing Number required');
167: END IF;
168: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
169: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_NO');
170: FND_MSG_PUB.ADD;

Line 176: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing Version required');

172: END IF;
173:
174: IF p_routings.routing_vers IS NULL THEN
175: IF (l_debug = 'Y') THEN
176: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing Version required');
177: END IF;
178: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
179: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_VERS');
180: FND_MSG_PUB.ADD;

Line 192: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing Description required');

188: END IF;
189:
190: IF p_routings.routing_desc IS NULL THEN
191: IF (l_debug = 'Y') THEN
192: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing Description required');
193: END IF;
194: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
195: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_DESC');
196: FND_MSG_PUB.ADD;

Line 203: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Item uom required');

199:
200: /* routing_uom must be passed, otherwise give error */
201: IF p_routings.routing_uom IS NULL THEN
202: IF (l_debug = 'Y') THEN
203: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Item uom required');
204: END IF;
205: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
206: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_UOM');
207: FND_MSG_PUB.ADD;

Line 212: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Item uom invalid');

208: RAISE routing_creation_failure;
209: /* call common function to check if um passed is valid */
210: ELSIF (NOT(gmd_api_grp.validate_um(p_routings.routing_uom))) THEN
211: IF (l_debug = 'Y') THEN
212: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Item uom invalid');
213: END IF;
214: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
215: FND_MSG_PUB.ADD;
216: RAISE routing_creation_failure;

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

247: p_routings.effective_end_date IS NOT NULL THEN
248: /* Effective end date must be greater than start date, otherwise give error */
249: IF l_routings_rec.effective_start_date > p_routings.effective_end_date THEN
250: IF (l_debug = 'Y') THEN
251: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
252: ||'effective start date must be less then end date');
253: END IF;
254: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');
255: FND_MSG_PUB.ADD;

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

410: /* to the function that creates the routing steps */
411:
412: /* Step 2 : Create Routing steps */
413: IF (l_debug = 'Y') THEN
414: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
415: ||'Insert the routing steps for routing with routing id = '||l_routing_id);
416: END IF;
417:
418: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

440: END LOOP; /* End loop for p_routings_step_tbl */
441:
442: IF p_routings_step_dep_tbl.count > 0 THEN
443: IF (l_debug = 'Y') THEN
444: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
445: ||'Creating Routing Step dependencies ');
446: END IF;
447: FOR i IN 1 .. p_routings_step_tbl.count LOOP
448: -- Call the routing step dep function

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

503: END LOOP;
504: END IF; /* if p_routings_step_dep_tbl.count > 0 */
505: ELSE
506: IF (l_debug = 'Y') THEN
507: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
508: ||'Routing API needs atleast one step to create its header');
509: END IF;
510: RAISE routing_creation_failure;
511: END IF;

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

549: ,p_data => x_message_list);
550:
551: IF x_message_count = 0 THEN
552: IF (l_debug = 'Y') THEN
553: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
554: ||'Routing Header was created successfully');
555: END IF;
556: END IF;
557:

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

555: END IF;
556: END IF;
557:
558: IF (l_debug = 'Y') THEN
559: gmd_debug.put_line('Completed '||l_api_name ||' at '
560: ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
561: END IF;
562:
563: EXCEPTION

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

562:
563: EXCEPTION
564: WHEN routing_creation_failure OR invalid_version THEN
565: IF (l_debug = 'Y') THEN
566: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
567: END IF;
568: fnd_msg_pub.count_and_get (
569: p_count => x_message_count
570: ,p_encoded => FND_API.g_false

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

589: ROLLBACK TO SAVEPOINT create_routing;
590: x_return_status := FND_API.g_ret_sts_unexp_error;
591: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
592: IF (l_debug = 'Y') THEN
593: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
594: END IF;
595: fnd_msg_pub.count_and_get (
596: p_count => x_message_count
597: ,p_encoded => FND_API.g_false

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

673: fnd_msg_pub.initialize;
674: END IF;
675:
676: IF (l_debug = 'Y') THEN
677: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
678: ||'Begining of Update API ');
679: END IF;
680:
681: /* Intialize the setup fields */

Line 719: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing id is required');

715:
716: /* Check the routing id is not null */
717: IF l_routing_id IS NULL THEN
718: IF (l_debug = 'Y') THEN
719: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing id is required');
720: END IF;
721: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
722: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
723: FND_MSG_PUB.ADD;

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

726:
727: /* Routing Security fix */
728: /* Validation: Check if for given user this routing can be modified */
729: IF (l_debug = 'Y') THEN
730: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
731: ||'Validation of user - owner orgn ocde = '||gmd_api_grp.user_id);
732: END IF;
733:
734: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'

Line 852: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing was updated successfullly');

848: ,p_data => x_message_list);
849:
850: IF x_message_count = 0 THEN
851: IF (l_debug = 'Y') THEN
852: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing was updated successfullly');
853: END IF;
854: END IF;
855:
856: IF (P_commit) THEN

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

857: COMMIT;
858: END IF;
859:
860: IF (l_debug = 'Y') THEN
861: gmd_debug.put_line('Completed '||l_api_name ||' at '
862: ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
863: END IF;
864:
865: EXCEPTION

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

866: WHEN routing_update_failure OR invalid_version THEN
867: ROLLBACK TO SAVEPOINT update_routing;
868: x_return_status := FND_API.G_RET_STS_ERROR;
869: IF (l_debug = 'Y') THEN
870: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
871: END IF;
872: fnd_msg_pub.count_and_get (
873: p_count => x_message_count
874: ,p_encoded => FND_API.g_false

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

884: ROLLBACK TO SAVEPOINT update_routing;
885: x_return_status := FND_API.g_ret_sts_unexp_error;
886: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
887: IF (l_debug = 'Y') THEN
888: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
889: END IF;
890: fnd_msg_pub.count_and_get (
891: p_count => x_message_count
892: ,p_encoded => FND_API.g_false

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

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

Line 1028: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing was created successfullly');

1024: ,p_data => x_message_list);
1025:
1026: IF x_message_count = 0 THEN
1027: IF (l_debug = 'Y') THEN
1028: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing was created successfullly');
1029: END IF;
1030: END IF;
1031:
1032: IF (P_commit) THEN

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

1033: COMMIT;
1034: END IF;
1035:
1036: IF (l_debug = 'Y') THEN
1037: gmd_debug.put_line('Completed '||l_api_name ||' at '
1038: ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1039: END IF;
1040:
1041: EXCEPTION

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

1042: WHEN routing_delete_failure OR invalid_version or routing_used THEN
1043: ROLLBACK TO SAVEPOINT delete_routing;
1044: x_return_status := FND_API.G_RET_STS_ERROR;
1045: IF (l_debug = 'Y') THEN
1046: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1047: END IF;
1048: fnd_msg_pub.count_and_get (
1049: p_count => x_message_count
1050: ,p_encoded => FND_API.g_false

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

1060: ROLLBACK TO SAVEPOINT delete_routing;
1061: x_return_status := FND_API.g_ret_sts_unexp_error;
1062: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
1063: IF (l_debug = 'Y') THEN
1064: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1065: END IF;
1066: fnd_msg_pub.count_and_get (
1067: p_count => x_message_count
1068: ,p_encoded => FND_API.g_false

Line 1111: gmd_debug.log_initialize('Undrtpub');

1107: setup_failure EXCEPTION;
1108: BEGIN
1109: SAVEPOINT undelete_routing;
1110: IF (l_debug = 'Y') THEN
1111: gmd_debug.log_initialize('Undrtpub');
1112: END IF;
1113:
1114: /* Set the return status to success initially */
1115: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1169: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing was undeleted successfullly');

1165: ,p_data => x_message_list);
1166:
1167: IF x_message_count = 0 THEN
1168: IF (l_debug = 'Y') THEN
1169: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing was undeleted successfullly');
1170: END IF;
1171: END IF;
1172:
1173: IF (P_commit) THEN

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

1174: COMMIT;
1175: END IF;
1176:
1177: IF (l_debug = 'Y') THEN
1178: gmd_debug.put_line('Completed '||l_api_name ||' at '
1179: ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1180: END IF;
1181:
1182: EXCEPTION

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

1183: WHEN routing_undelete_failure OR invalid_version THEN
1184: ROLLBACK TO SAVEPOINT undelete_routing;
1185: x_return_status := FND_API.G_RET_STS_ERROR;
1186: IF (l_debug = 'Y') THEN
1187: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1188: END IF;
1189: fnd_msg_pub.count_and_get (
1190: p_count => x_message_count
1191: ,p_encoded => FND_API.g_false

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

1201: ROLLBACK TO SAVEPOINT undelete_routing;
1202: x_return_status := FND_API.g_ret_sts_unexp_error;
1203: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
1204: IF (l_debug = 'Y') THEN
1205: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1206: END IF;
1207: fnd_msg_pub.count_and_get (
1208: p_count => x_message_count
1209: ,p_encoded => FND_API.g_false