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 133: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Begin of API');

129: fnd_msg_pub.initialize;
130: END IF;
131:
132: IF (l_debug = 'Y') THEN
133: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Begin of API');
134: END IF;
135:
136:
137: /* Intialize the setup fields */

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

151: END IF;
152:
153: IF p_routings.routing_no IS NULL THEN
154: IF (l_debug = 'Y') THEN
155: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing Number required');
156: END IF;
157: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
158: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_NO');
159: FND_MSG_PUB.ADD;

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

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

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

177: END IF;
178:
179: IF p_routings.routing_desc IS NULL THEN
180: IF (l_debug = 'Y') THEN
181: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing Description required');
182: END IF;
183: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
184: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_DESC');
185: FND_MSG_PUB.ADD;

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

188:
189: /* routing_uom must be passed, otherwise give error */
190: IF p_routings.routing_uom IS NULL THEN
191: IF (l_debug = 'Y') THEN
192: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Item uom required');
193: END IF;
194: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
195: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_UOM');
196: FND_MSG_PUB.ADD;

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

197: RAISE routing_creation_failure;
198: /* call common function to check if um passed is valid */
199: ELSIF (NOT(gmd_api_grp.validate_um(p_routings.routing_uom))) THEN
200: IF (l_debug = 'Y') THEN
201: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Item uom invalid');
202: END IF;
203: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
204: FND_MSG_PUB.ADD;
205: RAISE routing_creation_failure;

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

236: p_routings.effective_end_date IS NOT NULL THEN
237: /* Effective end date must be greater than start date, otherwise give error */
238: IF l_routings_rec.effective_start_date > p_routings.effective_end_date THEN
239: IF (l_debug = 'Y') THEN
240: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
241: ||'effective start date must be less then end date');
242: END IF;
243: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');
244: FND_MSG_PUB.ADD;

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

385: /* to the function that creates the routing steps */
386:
387: /* Step 2 : Create Routing steps */
388: IF (l_debug = 'Y') THEN
389: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
390: ||'Insert the routing steps for routing with routing id = '||l_routing_id);
391: END IF;
392:
393: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

415: END LOOP; /* End loop for p_routings_step_tbl */
416:
417: IF p_routings_step_dep_tbl.count > 0 THEN
418: IF (l_debug = 'Y') THEN
419: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
420: ||'Creating Routing Step dependencies ');
421: END IF;
422: FOR i IN 1 .. p_routings_step_tbl.count LOOP
423: -- Call the routing step dep function

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

478: END LOOP;
479: END IF; /* if p_routings_step_dep_tbl.count > 0 */
480: ELSE
481: IF (l_debug = 'Y') THEN
482: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
483: ||'Routing API needs atleast one step to create its header');
484: END IF;
485: RAISE routing_creation_failure;
486: END IF;

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

524: ,p_data => x_message_list);
525:
526: IF x_message_count = 0 THEN
527: IF (l_debug = 'Y') THEN
528: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
529: ||'Routing Header was created successfully');
530: END IF;
531: END IF;
532:

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

530: END IF;
531: END IF;
532:
533: IF (l_debug = 'Y') THEN
534: gmd_debug.put_line('Completed '||l_api_name ||' at '
535: ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
536: END IF;
537:
538: EXCEPTION

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

537:
538: EXCEPTION
539: WHEN routing_creation_failure OR invalid_version THEN
540: IF (l_debug = 'Y') THEN
541: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
542: END IF;
543: fnd_msg_pub.count_and_get (
544: p_count => x_message_count
545: ,p_encoded => FND_API.g_false

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

564: ROLLBACK TO SAVEPOINT create_routing;
565: x_return_status := FND_API.g_ret_sts_unexp_error;
566: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
567: IF (l_debug = 'Y') THEN
568: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
569: END IF;
570: fnd_msg_pub.count_and_get (
571: p_count => x_message_count
572: ,p_encoded => FND_API.g_false

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

637: fnd_msg_pub.initialize;
638: END IF;
639:
640: IF (l_debug = 'Y') THEN
641: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
642: ||'Begining of Update API ');
643: END IF;
644:
645: /* Intialize the setup fields */

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

679:
680: /* Check the routing id is not null */
681: IF l_routing_id IS NULL THEN
682: IF (l_debug = 'Y') THEN
683: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing id is required');
684: END IF;
685: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
686: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
687: FND_MSG_PUB.ADD;

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

690:
691: /* Routing Security fix */
692: /* Validation: Check if for given user this routing can be modified */
693: IF (l_debug = 'Y') THEN
694: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
695: ||'Validation of user - owner orgn ocde = '||gmd_api_grp.user_id);
696: END IF;
697:
698: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'

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

801: ,p_data => x_message_list);
802:
803: IF x_message_count = 0 THEN
804: IF (l_debug = 'Y') THEN
805: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing was updated successfullly');
806: END IF;
807: END IF;
808:
809: IF (P_commit) THEN

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

810: COMMIT;
811: END IF;
812:
813: IF (l_debug = 'Y') THEN
814: gmd_debug.put_line('Completed '||l_api_name ||' at '
815: ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
816: END IF;
817:
818: EXCEPTION

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

819: WHEN routing_update_failure OR invalid_version THEN
820: ROLLBACK TO SAVEPOINT update_routing;
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: IF (l_debug = 'Y') THEN
823: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
824: END IF;
825: fnd_msg_pub.count_and_get (
826: p_count => x_message_count
827: ,p_encoded => FND_API.g_false

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

837: ROLLBACK TO SAVEPOINT update_routing;
838: x_return_status := FND_API.g_ret_sts_unexp_error;
839: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
840: IF (l_debug = 'Y') THEN
841: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
842: END IF;
843: fnd_msg_pub.count_and_get (
844: p_count => x_message_count
845: ,p_encoded => FND_API.g_false

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

895: routing_used EXCEPTION;
896: BEGIN
897: SAVEPOINT delete_routing;
898: IF (l_debug = 'Y') THEN
899: gmd_debug.log_initialize('Dertpub');
900: END IF;
901:
902: /* Set the return status to success initially */
903: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

977: ,p_data => x_message_list);
978:
979: IF x_message_count = 0 THEN
980: IF (l_debug = 'Y') THEN
981: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing was created successfullly');
982: END IF;
983: END IF;
984:
985: IF (P_commit) THEN

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

986: COMMIT;
987: END IF;
988:
989: IF (l_debug = 'Y') THEN
990: gmd_debug.put_line('Completed '||l_api_name ||' at '
991: ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
992: END IF;
993:
994: EXCEPTION

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

995: WHEN routing_delete_failure OR invalid_version or routing_used THEN
996: ROLLBACK TO SAVEPOINT delete_routing;
997: x_return_status := FND_API.G_RET_STS_ERROR;
998: IF (l_debug = 'Y') THEN
999: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1000: END IF;
1001: fnd_msg_pub.count_and_get (
1002: p_count => x_message_count
1003: ,p_encoded => FND_API.g_false

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

1013: ROLLBACK TO SAVEPOINT delete_routing;
1014: x_return_status := FND_API.g_ret_sts_unexp_error;
1015: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
1016: IF (l_debug = 'Y') THEN
1017: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1018: END IF;
1019: fnd_msg_pub.count_and_get (
1020: p_count => x_message_count
1021: ,p_encoded => FND_API.g_false

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

1060: setup_failure EXCEPTION;
1061: BEGIN
1062: SAVEPOINT undelete_routing;
1063: IF (l_debug = 'Y') THEN
1064: gmd_debug.log_initialize('Undrtpub');
1065: END IF;
1066:
1067: /* Set the return status to success initially */
1068: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1118: ,p_data => x_message_list);
1119:
1120: IF x_message_count = 0 THEN
1121: IF (l_debug = 'Y') THEN
1122: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Routing was undeleted successfullly');
1123: END IF;
1124: END IF;
1125:
1126: IF (P_commit) THEN

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

1127: COMMIT;
1128: END IF;
1129:
1130: IF (l_debug = 'Y') THEN
1131: gmd_debug.put_line('Completed '||l_api_name ||' at '
1132: ||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1133: END IF;
1134:
1135: EXCEPTION

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

1136: WHEN routing_undelete_failure OR invalid_version THEN
1137: ROLLBACK TO SAVEPOINT undelete_routing;
1138: x_return_status := FND_API.G_RET_STS_ERROR;
1139: IF (l_debug = 'Y') THEN
1140: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1141: END IF;
1142: fnd_msg_pub.count_and_get (
1143: p_count => x_message_count
1144: ,p_encoded => FND_API.g_false

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

1154: ROLLBACK TO SAVEPOINT undelete_routing;
1155: x_return_status := FND_API.g_ret_sts_unexp_error;
1156: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
1157: IF (l_debug = 'Y') THEN
1158: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1159: END IF;
1160: fnd_msg_pub.count_and_get (
1161: p_count => x_message_count
1162: ,p_encoded => FND_API.g_false