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

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

123:
124: /* Validations done prior to creation of routing steps */
125: /* Validation : Check if routing header exists in the database */
126: IF (l_debug = 'Y') THEN
127: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
128: ||'Begin of validations ');
129: END IF;
130:
131: IF p_routing_id IS NOT NULL THEN

Line 160: gmd_debug.put_line('Routing id is required');

156:
157: /* Check the routing id is not null */
158: IF l_routing_id IS NULL THEN
159: IF (l_debug = 'Y') THEN
160: gmd_debug.put_line('Routing id is required');
161: END IF;
162: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
163: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
164: FND_MSG_PUB.ADD;

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

167:
168: /* Routing Security Validation */
169: /* Validation: Check if for given user this routing can be modified */
170: IF (l_debug = 'Y') THEN
171: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
172: ||'Validation of user - owner orgn code = '||gmd_api_grp.user_id);
173: END IF;
174:
175:

Line 184: gmd_debug.put_line('Routing step number is required');

180:
181: /* Check the routing step number is not null */
182: IF p_routing_step_rec.routingstep_no IS NULL THEN
183: IF (l_debug = 'Y') THEN
184: gmd_debug.put_line('Routing step number is required');
185: END IF;
186: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
187: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO');
188: FND_MSG_PUB.ADD;

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

191:
192: /* Check the oprn id is not null */
193: IF p_routing_step_rec.oprn_id IS NULL THEN
194: IF (l_debug = 'Y') THEN
195: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||
196: 'Operation id is required');
197: END IF;
198: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
199: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_ID');

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

205: RAISE routing_step_creation_failure;
206: END IF;
207:
208: IF (l_debug = 'Y') THEN
209: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||
210: 'Validation : Checking for routingStep existence ');
211: END IF;
212: /* Validation : check if this routing step exists in our system */
213: /* If this step exists indicate a duplication not allowed message */

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

220: END IF;
221: END IF;
222:
223: IF (l_debug = 'Y') THEN
224: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||
225: 'Validation : Enforce flag check for routing id = '||l_routing_id);
226: END IF;
227:
228: /* Validation : Enforcing step dependency

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

297: l_routing_step_rec.step_qty := NVL(p_routing_step_rec.step_qty,0);
298:
299: /* Step : Create Routing steps */
300: IF (l_debug = 'Y') THEN
301: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||
302: 'Insert the routing steps for routing with routing id = '||l_routing_id);
303: END IF;
304:
305: GMD_ROUTING_STEPS_PVT.insert_routing_steps

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

313: END IF;
314:
315: -- Check if routing detail was created
316: IF (l_debug = 'Y') THEN
317: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
318: ||'After calling the pvt insert step API the return status: '||x_return_status);
319: END IF;
320:
321: /* After creating routing steps pass the routing id */

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

324:
325: /* Create Routing Step dependencies */
326: IF p_routings_step_dep_tbl.count > 0 THEN
327: IF (l_debug = 'Y') THEN
328: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||
329: 'Creating Routing Step dependencies ');
330: END IF;
331:
332: -- Call the routing step dep function

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

392: ,p_data => x_message_list);
393:
394: IF x_message_count = 0 THEN
395: IF (l_debug = 'Y') THEN
396: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||
397: 'Routing details/steps was created successfullly');
398: END IF;
399: END IF;
400:

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

402: COMMIT;
403: END IF;
404:
405: IF (l_debug = 'Y') THEN
406: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
407: END IF;
408:
409: EXCEPTION
410: WHEN routing_step_creation_failure OR invalid_version THEN

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

409: EXCEPTION
410: WHEN routing_step_creation_failure OR invalid_version THEN
411: ROLLBACK TO SAVEPOINT create_routing_steps;
412: IF (l_debug = 'Y') THEN
413: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete '||SQLERRM);
414: END IF;
415: fnd_msg_pub.count_and_get (
416: p_count => x_message_count
417: ,p_encoded => FND_API.g_false

Line 430: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'failure due to insert step dep'||SQLERRM);

426: ,p_data => x_message_list);
427: WHEN routing_step_dep_failure THEN
428: ROLLBACK TO SAVEPOINT create_routing_steps;
429: IF (l_debug = 'Y') THEN
430: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'failure due to insert step dep'||SQLERRM);
431: END IF;
432: fnd_msg_pub.count_and_get (
433: p_count => x_message_count
434: ,p_encoded => FND_API.g_false

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

437: WHEN OTHERS THEN
438: ROLLBACK TO SAVEPOINT create_routing_steps;
439: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
440: IF (l_debug = 'Y') THEN
441: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
442: END IF;
443: fnd_msg_pub.count_and_get (
444: p_count => x_message_count
445: ,p_encoded => FND_API.g_false

Line 519: gmd_debug.put_line('routing step number required');

515:
516: /* Routingstp number must be passed, otherwise give error */
517: IF p_routingstep_no IS NULL THEN
518: IF (l_debug = 'Y') THEN
519: gmd_debug.put_line('routing step number required');
520: END IF;
521: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
522: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO');
523: FND_MSG_PUB.ADD;

Line 530: gmd_debug.put_line('dep routing step number required');

526:
527: /* Routingstp number must be passed, otherwise give error */
528: IF p_routings_step_dep_tbl(1).dep_routingstep_no IS NULL THEN
529: IF (l_debug = 'Y') THEN
530: gmd_debug.put_line('dep routing step number required');
531: END IF;
532: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
533: FND_MESSAGE.SET_TOKEN ('MISSING', 'DEP_ROUTINGSTEP_NO');
534: FND_MSG_PUB.ADD;

Line 541: gmd_debug.put_line('Item uom required');

537:
538: /* routingstep_no_uom must be passed, otherwise give error */
539: IF p_routings_step_dep_tbl(1).routingstep_no_uom IS NULL THEN
540: IF (l_debug = 'Y') THEN
541: gmd_debug.put_line('Item uom required');
542: END IF;
543: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
544: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO_UOM');
545: FND_MSG_PUB.ADD;

Line 550: gmd_debug.put_line('Item uom invalid');

546: RAISE routing_step_dep_failure;
547: /* call common function to check if um passed is valid */
548: ELSIF (NOT(gmd_api_grp.validate_um(p_routings_step_dep_tbl(1).routingstep_no_uom))) THEN
549: IF (l_debug = 'Y') THEN
550: gmd_debug.put_line('Item uom invalid');
551: END IF;
552: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
553: FND_MSG_PUB.ADD;
554: RAISE routing_step_dep_failure;

Line 560: gmd_debug.put_line('Transfer percent should be positive value');

556:
557: /* transfer pct value should be in between 0 and 100 */
558: IF p_routings_step_dep_tbl(1).transfer_pct < 0 OR p_routings_step_dep_tbl(1).transfer_pct > 100 THEN
559: IF (l_debug = 'Y') THEN
560: gmd_debug.put_line('Transfer percent should be positive value');
561: END IF;
562: FND_MESSAGE.SET_NAME ('GMD', 'FM_INVALID');
563: FND_MSG_PUB.ADD;
564: RAISE routing_step_dep_failure;

Line 570: gmd_debug.put_line('Invalid value for dep_type field');

566:
567: /* dep_type value should be either 0 or 1 */
568: IF p_routings_step_dep_tbl(1).dep_type NOT IN (0,1) THEN
569: IF (l_debug = 'Y') THEN
570: gmd_debug.put_line('Invalid value for dep_type field');
571: END IF;
572: FND_MESSAGE.SET_NAME ('GMD', 'GMD_DEP_TYPE_INVALID');
573: FND_MSG_PUB.ADD;
574: RAISE routing_step_dep_failure;

Line 578: gmd_debug.put_line(' Validation : Check if the routing id exists in the db ');

574: RAISE routing_step_dep_failure;
575: END IF;
576:
577: IF (l_debug = 'Y') THEN
578: gmd_debug.put_line(' Validation : Check if the routing id exists in the db ');
579: END IF;
580: /* Validation : Check if routing header exists in the database */
581: IF p_routing_id IS NOT NULL THEN
582: l_routing_id := p_routing_id;

Line 611: gmd_debug.put_line('Routing id is required');

607:
608: /* Check the routing id is not null */
609: IF l_routing_id IS NULL THEN
610: IF (l_debug = 'Y') THEN
611: gmd_debug.put_line('Routing id is required');
612: END IF;
613: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
614: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
615: FND_MSG_PUB.ADD;

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

618:
619: /* Routing Security Validation */
620: /* Validation: Check if for given user this routing can be modified */
621: IF (l_debug = 'Y') THEN
622: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
623: ||'Validation of user - owner orgn code = '||gmd_api_grp.user_id);
624: END IF;
625: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
626: ,Entity_id => l_routing_id) THEN

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

664: );
665:
666: -- Check if routing step dependencies were created
667: IF (l_debug = 'Y') THEN
668: gmd_debug.put_line('After inserting routing step dependencies');
669: END IF;
670:
671: /* Check if work was done */
672: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 683: gmd_debug.put_line('Routing step dependencies were created successfullly');

679: ,p_data => x_message_list);
680:
681: IF x_message_count = 0 THEN
682: IF (l_debug = 'Y') THEN
683: gmd_debug.put_line('Routing step dependencies were created successfullly');
684: END IF;
685: END IF;
686:
687: IF (P_commit) THEN

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

688: COMMIT;
689: END IF;
690:
691: IF (l_debug = 'Y') THEN
692: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
693: END IF;
694:
695: EXCEPTION
696: WHEN routing_step_dep_failure OR invalid_version THEN

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

695: EXCEPTION
696: WHEN routing_step_dep_failure OR invalid_version THEN
697: ROLLBACK TO SAVEPOINT create_step_dependencies;
698: IF (l_debug = 'Y') THEN
699: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
700: END IF;
701: fnd_msg_pub.count_and_get (
702: p_count => x_message_count
703: ,p_encoded => FND_API.g_false

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

713: WHEN OTHERS THEN
714: ROLLBACK TO SAVEPOINT create_step_dependencies;
715: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
716: IF (l_debug = 'Y') THEN
717: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
718: END IF;
719: fnd_msg_pub.count_and_get (
720: p_count => x_message_count
721: ,p_encoded => FND_API.g_false

Line 820: gmd_debug.put_line('Validation : check if the routing id is valid ');

816:
817: /* Validation : Check if the routing id exists in the db */
818: /* Validation : Check if routing header exists in the database */
819: IF (l_debug = 'Y') THEN
820: gmd_debug.put_line('Validation : check if the routing id is valid ');
821: END IF;
822: IF p_routing_id IS NOT NULL THEN
823: l_routing_id := p_routing_id;
824: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

Line 852: gmd_debug.put_line('Routing id is required');

848:
849: /* Check the routing id is not null */
850: IF l_routing_id IS NULL THEN
851: IF (l_debug = 'Y') THEN
852: gmd_debug.put_line('Routing id is required');
853: END IF;
854: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
855: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
856: FND_MSG_PUB.ADD;

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

859:
860: /* Routing Security fix */
861: /* Validation: Check if for given user this routing can be modified */
862: IF (l_debug = 'Y') THEN
863: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
864: ||'Validation of user - owner orgn code = '||gmd_api_grp.user_id);
865: END IF;
866: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
867: ,Entity_id => l_routing_id) THEN

Line 873: gmd_debug.put_line('Validation : get the routingstep_id with routing id = '

869: END IF;
870:
871: /* get the RoutingStep_id - if it is not passed as a parameter */
872: IF (l_debug = 'Y') THEN
873: gmd_debug.put_line('Validation : get the routingstep_id with routing id = '
874: ||l_routing_id ||'RoutingStepNo = '||p_routingStep_no);
875: END IF;
876:
877: IF p_routingStep_id IS NOT NULL THEN

Line 880: gmd_debug.put_line(' get the RoutingStep_no- for rtstepid = '||l_routingStep_id);

876:
877: IF p_routingStep_id IS NOT NULL THEN
878: l_routingstep_id := p_routingstep_id;
879: IF (l_debug = 'Y') THEN
880: gmd_debug.put_line(' get the RoutingStep_no- for rtstepid = '||l_routingStep_id);
881: END IF;
882: GMDRTVAL_PUB.get_routingstep_info(pxRoutingStep_no => l_routingstep_no
883: ,pxRoutingStep_id => l_routingstep_id
884: ,x_return_status => l_return_status );

Line 886: gmd_debug.put_line(' After get_rouingstep_info is called ret status = '||l_return_status);

882: GMDRTVAL_PUB.get_routingstep_info(pxRoutingStep_no => l_routingstep_no
883: ,pxRoutingStep_id => l_routingstep_id
884: ,x_return_status => l_return_status );
885: IF (l_debug = 'Y') THEN
886: gmd_debug.put_line(' After get_rouingstep_info is called ret status = '||l_return_status);
887: END IF;
888: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
889: /* it indicates that this routing does'ntexists */
890: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');

Line 912: gmd_debug.put_line('Routing step id is required');

908:
909: /* Check the routing id is not null */
910: IF l_routingstep_id IS NULL THEN
911: IF (l_debug = 'Y') THEN
912: gmd_debug.put_line('Routing step id is required');
913: END IF;
914: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
915: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_ID');
916: FND_MSG_PUB.ADD;

Line 995: gmd_debug.put_line('Routing step was updated successfullly');

991: ,p_data => x_message_list);
992:
993: IF x_message_count = 0 THEN
994: IF (l_debug = 'Y') THEN
995: gmd_debug.put_line('Routing step was updated successfullly');
996: END IF;
997: END IF;
998:
999: IF (P_commit) THEN

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

1000: COMMIT;
1001: END IF;
1002:
1003: IF (l_debug = 'Y') THEN
1004: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1005: END IF;
1006: EXCEPTION
1007: WHEN routing_update_step_failure OR invalid_version THEN
1008: ROLLBACK TO SAVEPOINT update_routing_details;

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

1006: EXCEPTION
1007: WHEN routing_update_step_failure OR invalid_version THEN
1008: ROLLBACK TO SAVEPOINT update_routing_details;
1009: IF (l_debug = 'Y') THEN
1010: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1011: END IF;
1012: fnd_msg_pub.count_and_get (
1013: p_count => x_message_count
1014: ,p_encoded => FND_API.g_false

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

1031: WHEN OTHERS THEN
1032: ROLLBACK TO SAVEPOINT update_routing_details;
1033: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
1034: IF (l_debug = 'Y') THEN
1035: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1036: END IF;
1037: fnd_msg_pub.count_and_get (
1038: p_count => x_message_count
1039: ,p_encoded => FND_API.g_false

Line 1139: gmd_debug.put_line ('Transfer pct value should be positive');

1135:
1136: /* transfer pct value should be in between 0 and 100 */
1137: IF l_transfer_pct < 0 OR l_transfer_pct > 100 THEN
1138: IF (l_debug = 'Y') THEN
1139: gmd_debug.put_line ('Transfer pct value should be positive');
1140: END IF;
1141: FND_MESSAGE.SET_NAME ('GMD', 'FM_INVALID');
1142: FND_MSG_PUB.ADD;
1143: RAISE routing_update_dep_failure;

Line 1149: gmd_debug.put_line ('Transfer pct value should be positive');

1145:
1146: /* standard delay value should be in = or > 0 */
1147: IF l_std_delay < 0 THEN
1148: IF (l_debug = 'Y') THEN
1149: gmd_debug.put_line ('Transfer pct value should be positive');
1150: END IF;
1151: FND_MESSAGE.SET_NAME ('GMD', 'FM_INVALID');
1152: FND_MSG_PUB.ADD;
1153: RAISE routing_update_dep_failure;

Line 1159: gmd_debug.put_line('Invalid value for dep_type field');

1155:
1156: /* dep_type value should be either 0 or 1 */
1157: IF l_dep_type NOT IN (0,1) THEN
1158: IF (l_debug = 'Y') THEN
1159: gmd_debug.put_line('Invalid value for dep_type field');
1160: END IF;
1161: FND_MESSAGE.SET_NAME ('GMD', 'GMD_DEP_TYPE_INVALID');
1162: FND_MSG_PUB.ADD;
1163: RAISE routing_update_dep_failure;

Line 1197: gmd_debug.put_line('Routing id is required');

1193:
1194: /* Check the routing id is not null */
1195: IF l_routing_id IS NULL THEN
1196: IF (l_debug = 'Y') THEN
1197: gmd_debug.put_line('Routing id is required');
1198: END IF;
1199: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1200: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
1201: FND_MSG_PUB.ADD;

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

1204:
1205: /* Routing Security fix */
1206: /* Validation: Check if for given user this routing can be modified */
1207: IF (l_debug = 'Y') THEN
1208: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
1209: ||'Validation of user - owner orgn code = '||gmd_api_grp.user_id);
1210: END IF;
1211: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
1212: ,Entity_id => l_routing_id) THEN

Line 1218: gmd_debug.put_line('Validation : get the routingstep_no with routing step id = '

1214: END IF;
1215:
1216: /* get the RoutingStep_no - if it is not passed as a parameter */
1217: IF (l_debug = 'Y') THEN
1218: gmd_debug.put_line('Validation : get the routingstep_no with routing step id = '
1219: ||p_routingstep_id);
1220: END IF;
1221: IF p_routingStep_no IS NOT NULL THEN
1222: l_routingstep_no := p_routingstep_no;

Line 1250: gmd_debug.put_line('Routing id is required');

1246:
1247: /* Check the routing step no is not null */
1248: IF l_routingstep_no IS NULL THEN
1249: IF (l_debug = 'Y') THEN
1250: gmd_debug.put_line('Routing id is required');
1251: END IF;
1252: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1253: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO');
1254: FND_MSG_PUB.ADD;

Line 1290: gmd_debug.put_line('Routing was updated successfullly');

1286: ,p_data => x_message_list);
1287:
1288: IF x_message_count = 0 THEN
1289: IF (l_debug = 'Y') THEN
1290: gmd_debug.put_line('Routing was updated successfullly');
1291: END IF;
1292: END IF;
1293:
1294: IF (P_commit) THEN

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

1295: COMMIT;
1296: END IF;
1297:
1298: IF (l_debug = 'Y') THEN
1299: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1300: END IF;
1301:
1302: EXCEPTION
1303: WHEN routing_update_dep_failure OR invalid_version THEN

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

1302: EXCEPTION
1303: WHEN routing_update_dep_failure OR invalid_version THEN
1304: ROLLBACK TO SAVEPOINT update_step_dependency;
1305: IF (l_debug = 'Y') THEN
1306: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1307: END IF;
1308: fnd_msg_pub.count_and_get (
1309: p_count => x_message_count
1310: ,p_encoded => FND_API.g_false

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

1320: WHEN OTHERS THEN
1321: ROLLBACK TO SAVEPOINT update_routing_details;
1322: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
1323: IF (l_debug = 'Y') THEN
1324: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1325: END IF;
1326: fnd_msg_pub.count_and_get (
1327: p_count => x_message_count
1328: ,p_encoded => FND_API.g_false

Line 1417: gmd_debug.put_line('Validation : Check if routing header exists in the database ');

1413: /* Get routing id if it is not passed in as a parameter */
1414: /* Routing id may be used to get the routingStep_id (PK for fm_rout_dtl) */
1415: /* Get the routing_id value */
1416: IF (l_debug = 'Y') THEN
1417: gmd_debug.put_line('Validation : Check if routing header exists in the database ');
1418: END IF;
1419: IF p_routing_id IS NOT NULL THEN
1420: l_routing_id := p_routing_id;
1421: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

Line 1449: gmd_debug.put_line('Routing id is required');

1445:
1446: /* Check the routing id is not null */
1447: IF l_routing_id IS NULL THEN
1448: IF (l_debug = 'Y') THEN
1449: gmd_debug.put_line('Routing id is required');
1450: END IF;
1451: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1452: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
1453: FND_MSG_PUB.ADD;

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

1456:
1457: /* Routing Security Validation */
1458: /* Validation: Check if for given user this routing can be modified */
1459: IF (l_debug = 'Y') THEN
1460: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
1461: ||'Validation of user - owner orgn code = '||gmd_api_grp.user_id);
1462: END IF;
1463: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
1464: ,Entity_id => l_routing_id) THEN

Line 1475: gmd_debug.put_line(' get the RoutingStep_no- for rtstepid = '||l_routingStep_id);

1471:
1472: IF p_routingStep_id IS NOT NULL THEN
1473: l_routingstep_id := p_routingstep_id;
1474: IF (l_debug = 'Y') THEN
1475: gmd_debug.put_line(' get the RoutingStep_no- for rtstepid = '||l_routingStep_id);
1476: END IF;
1477: GMDRTVAL_PUB.get_routingstep_info(pxRoutingStep_no => l_routingstep_no
1478: ,pxRoutingStep_id => l_routingstep_id
1479: ,x_return_status => l_return_status );

Line 1481: gmd_debug.put_line(' After get_rouingstep_info is called ret status = '||l_return_status);

1477: GMDRTVAL_PUB.get_routingstep_info(pxRoutingStep_no => l_routingstep_no
1478: ,pxRoutingStep_id => l_routingstep_id
1479: ,x_return_status => l_return_status );
1480: IF (l_debug = 'Y') THEN
1481: gmd_debug.put_line(' After get_rouingstep_info is called ret status = '||l_return_status);
1482: END IF;
1483: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1484: /* it indicates that this routing does'ntexists */
1485: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');

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

1487: RAISE routing_delete_step_failure;
1488: END IF;
1489: ELSE
1490: IF (l_debug = 'Y') THEN
1491: gmd_debug.put_line(' get the RoutingStep_id - if it is not passed as a parameter ');
1492: END IF;
1493: l_routingstep_no := p_routingstep_no;
1494: GMDRTVAL_PUB.get_routingstep_info(pRouting_id => l_routing_id
1495: ,pxRoutingStep_no => l_routingstep_no

Line 1509: gmd_debug.put_line('Routing step id is required');

1505:
1506: /* Check the routing id is not null */
1507: IF l_routingstep_id IS NULL THEN
1508: IF (l_debug = 'Y') THEN
1509: gmd_debug.put_line('Routing step id is required');
1510: END IF;
1511: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1512: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_ID');
1513: FND_MSG_PUB.ADD;

Line 1535: gmd_debug.put_line('RoutingStep_id = '||l_routingStep_id );

1531: RAISE routing_delete_step_failure;
1532: END IF;
1533:
1534: IF (l_debug = 'Y') THEN
1535: gmd_debug.put_line('RoutingStep_id = '||l_routingStep_id );
1536: END IF;
1537: /* Actual delete is performed */
1538: GMD_ROUTING_STEPS_PVT.delete_routing_step
1539: ( p_routingstep_id => l_routingstep_id

Line 1551: gmd_debug.put_line('Routing step was deleted successfullly');

1547: ,p_data => x_message_list);
1548:
1549: IF x_message_count = 0 THEN
1550: IF (l_debug = 'Y') THEN
1551: gmd_debug.put_line('Routing step was deleted successfullly');
1552: END IF;
1553: END IF;
1554:
1555: IF (P_commit) THEN

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

1556: COMMIT;
1557: END IF;
1558:
1559: IF (l_debug = 'Y') THEN
1560: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1561: END IF;
1562:
1563: EXCEPTION
1564: WHEN routing_delete_step_failure OR invalid_version THEN

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

1563: EXCEPTION
1564: WHEN routing_delete_step_failure OR invalid_version THEN
1565: ROLLBACK TO SAVEPOINT delete_routing_step;
1566: IF (l_debug = 'Y') THEN
1567: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1568: END IF;
1569: fnd_msg_pub.count_and_get (
1570: p_count => x_message_count
1571: ,p_encoded => FND_API.g_false

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

1580: ,p_data => x_message_list);
1581: WHEN routing_delete_stepdep_failure THEN
1582: ROLLBACK TO SAVEPOINT delete_routing_step;
1583: IF (l_debug = 'Y') THEN
1584: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'delete step dep API not complete');
1585: END IF;
1586: fnd_msg_pub.count_and_get (
1587: p_count => x_message_count
1588: ,p_encoded => FND_API.g_false

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

1591: WHEN OTHERS THEN
1592: ROLLBACK TO SAVEPOINT delete_routing_step;
1593: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
1594: IF (l_debug = 'Y') THEN
1595: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1596: END IF;
1597: fnd_msg_pub.count_and_get (
1598: p_count => x_message_count
1599: ,p_encoded => FND_API.g_false

Line 1680: gmd_Debug.put_line('Validation: In dep step API if routing header exists in the database ');

1676: /* Tables to be checked are mainly gmd step material association
1677: and maybe batch table. Prevent delete if these steps are used in these tables */
1678: /* Get the routing_id value */
1679: IF (l_debug = 'Y') THEN
1680: gmd_Debug.put_line('Validation: In dep step API if routing header exists in the database ');
1681: END IF;
1682: IF p_routing_id IS NOT NULL THEN
1683: l_routing_id := p_routing_id;
1684: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

Line 1712: gmd_debug.put_line('Routing id is required');

1708:
1709: /* Check the routing id is not null */
1710: IF l_routing_id IS NULL THEN
1711: IF (l_debug = 'Y') THEN
1712: gmd_debug.put_line('Routing id is required');
1713: END IF;
1714: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1715: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_ID');
1716: FND_MSG_PUB.ADD;

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

1719:
1720: /* Routing Security Validation */
1721: /* Validation: Check if for given user this routing can be modified */
1722: IF (l_debug = 'Y') THEN
1723: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
1724: ||'Validation of user - owner orgn code = '||gmd_api_grp.user_id);
1725: END IF;
1726: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
1727: ,Entity_id => l_routing_id) THEN

Line 1748: gmd_debug.put_line('Routing step number is required');

1744:
1745: /* Check the routingstep no is not null */
1746: IF p_routingstep_no IS NULL THEN
1747: IF (l_debug = 'Y') THEN
1748: gmd_debug.put_line('Routing step number is required');
1749: END IF;
1750: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1751: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO');
1752: FND_MSG_PUB.ADD;

Line 1759: gmd_debug.put_line('Dep Routing step number is required');

1755:
1756: /* Check the routingstep no is not null */
1757: IF p_dep_routingstep_no IS NULL THEN
1758: IF (l_debug = 'Y') THEN
1759: gmd_debug.put_line('Dep Routing step number is required');
1760: END IF;
1761: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1762: FND_MESSAGE.SET_TOKEN ('MISSING', 'DEP_ROUTINGSTEP_NO');
1763: FND_MSG_PUB.ADD;

Line 1771: gmd_Debug.put_line('About to delete from step dep table - the routingstep no = '

1767: /* Actual delete in fm_rout_dep table */
1768: /* This delete can be specific to a dep_routingstep_no or a
1769: Routingstep_no */
1770: IF (l_debug = 'Y') THEN
1771: gmd_Debug.put_line('About to delete from step dep table - the routingstep no = '
1772: ||p_routingstep_no ||' and routing id = '||l_routing_id);
1773: END IF;
1774:
1775:

Line 1804: gmd_debug.put_line('Routing was deleted successfullly');

1800: ,p_data => x_message_list);
1801:
1802: IF x_message_count = 0 THEN
1803: IF (l_debug = 'Y') THEN
1804: gmd_debug.put_line('Routing was deleted successfullly');
1805: END IF;
1806: END IF;
1807:
1808: IF (P_commit) THEN

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

1809: COMMIT;
1810: END IF;
1811:
1812: IF (l_debug = 'Y') THEN
1813: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));
1814: END IF;
1815:
1816: EXCEPTION
1817: WHEN routing_delete_dep_failure OR invalid_version THEN

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

1816: EXCEPTION
1817: WHEN routing_delete_dep_failure OR invalid_version THEN
1818: ROLLBACK TO SAVEPOINT delete_step_dependency;
1819: IF (l_debug = 'Y') THEN
1820: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1821: END IF;
1822: fnd_msg_pub.count_and_get (
1823: p_count => x_message_count
1824: ,p_encoded => FND_API.g_false

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

1834: WHEN OTHERS THEN
1835: ROLLBACK TO SAVEPOINT delete_step_dependency;
1836: fnd_msg_pub.add_exc_msg (gmd_routing_steps_PUB.m_pkg_name, l_api_name);
1837: IF (l_debug = 'Y') THEN
1838: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1839: END IF;
1840: fnd_msg_pub.count_and_get (
1841: p_count => x_message_count
1842: ,p_encoded => FND_API.g_false