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_API_GRP

Line 62: IF NOT gmd_api_grp.setup_done THEN

58:
59: BEGIN
60:
61: /* Intialize the setup fields */
62: IF NOT gmd_api_grp.setup_done THEN
63: gmd_api_grp.setup_done := gmd_api_grp.setup;
64: END IF;
65: IF NOT gmd_api_grp.setup_done THEN
66: RAISE setup_failure;

Line 63: gmd_api_grp.setup_done := gmd_api_grp.setup;

59: BEGIN
60:
61: /* Intialize the setup fields */
62: IF NOT gmd_api_grp.setup_done THEN
63: gmd_api_grp.setup_done := gmd_api_grp.setup;
64: END IF;
65: IF NOT gmd_api_grp.setup_done THEN
66: RAISE setup_failure;
67: END IF;

Line 65: IF NOT gmd_api_grp.setup_done THEN

61: /* Intialize the setup fields */
62: IF NOT gmd_api_grp.setup_done THEN
63: gmd_api_grp.setup_done := gmd_api_grp.setup;
64: END IF;
65: IF NOT gmd_api_grp.setup_done THEN
66: RAISE setup_failure;
67: END IF;
68: /* Set the return status to success initially */
69: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 105: ,p_routing_step_rec.text_code, gmd_api_grp.user_id

101: ,x_coordinate, y_coordinate,minimum_transfer_qty)
102: VALUES
103: ( p_routing_id , p_routing_step_rec.routingstep_no, NVL(p_routing_step_rec.routingstep_id,l_routingStep_id)
104: ,p_routing_step_rec.oprn_id, p_routing_step_rec.step_qty, p_routing_step_rec.steprelease_type
105: ,p_routing_step_rec.text_code, gmd_api_grp.user_id
106: ,gmd_api_grp.user_id, NVL(p_routing_step_rec.last_update_date,SYSDATE)
107: ,NVL(p_routing_step_rec.creation_date,SYSDATE), p_routing_step_rec.last_update_login
108: ,p_routing_step_rec.attribute1, p_routing_step_rec.attribute2
109: ,p_routing_step_rec.attribute3, p_routing_step_rec.attribute4

Line 106: ,gmd_api_grp.user_id, NVL(p_routing_step_rec.last_update_date,SYSDATE)

102: VALUES
103: ( p_routing_id , p_routing_step_rec.routingstep_no, NVL(p_routing_step_rec.routingstep_id,l_routingStep_id)
104: ,p_routing_step_rec.oprn_id, p_routing_step_rec.step_qty, p_routing_step_rec.steprelease_type
105: ,p_routing_step_rec.text_code, gmd_api_grp.user_id
106: ,gmd_api_grp.user_id, NVL(p_routing_step_rec.last_update_date,SYSDATE)
107: ,NVL(p_routing_step_rec.creation_date,SYSDATE), p_routing_step_rec.last_update_login
108: ,p_routing_step_rec.attribute1, p_routing_step_rec.attribute2
109: ,p_routing_step_rec.attribute3, p_routing_step_rec.attribute4
110: ,p_routing_step_rec.attribute5, p_routing_step_rec.attribute6

Line 192: IF NOT gmd_api_grp.setup_done 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
193: gmd_api_grp.setup_done := gmd_api_grp.setup;
194: END IF;
195: IF NOT gmd_api_grp.setup_done THEN
196: RAISE setup_failure;

Line 193: gmd_api_grp.setup_done := gmd_api_grp.setup;

189: END IF;
190:
191: /* Intialize the setup fields */
192: IF NOT gmd_api_grp.setup_done THEN
193: gmd_api_grp.setup_done := gmd_api_grp.setup;
194: END IF;
195: IF NOT gmd_api_grp.setup_done THEN
196: RAISE setup_failure;
197: END IF;

Line 195: IF NOT gmd_api_grp.setup_done THEN

191: /* Intialize the setup fields */
192: IF NOT gmd_api_grp.setup_done THEN
193: gmd_api_grp.setup_done := gmd_api_grp.setup;
194: END IF;
195: IF NOT gmd_api_grp.setup_done THEN
196: RAISE setup_failure;
197: END IF;
198:
199: /* Set the return status to success initially */

Line 237: ,gmd_api_grp.user_id

233: ,p_routings_step_dep_tbl(i).max_delay
234: ,NVL(l_transfer_qty,0)
235: ,p_routings_step_dep_tbl(i).routingstep_no_uom
236: ,p_routings_step_dep_tbl(i).text_code
237: ,gmd_api_grp.user_id
238: ,gmd_api_grp.user_id
239: ,NVL(p_routings_step_dep_tbl(i).last_update_date,SYSDATE)
240: ,NVL(p_routings_step_dep_tbl(i).creation_date,SYSDATE)
241: ,p_routings_step_dep_tbl(i).last_update_login

Line 238: ,gmd_api_grp.user_id

234: ,NVL(l_transfer_qty,0)
235: ,p_routings_step_dep_tbl(i).routingstep_no_uom
236: ,p_routings_step_dep_tbl(i).text_code
237: ,gmd_api_grp.user_id
238: ,gmd_api_grp.user_id
239: ,NVL(p_routings_step_dep_tbl(i).last_update_date,SYSDATE)
240: ,NVL(p_routings_step_dep_tbl(i).creation_date,SYSDATE)
241: ,p_routings_step_dep_tbl(i).last_update_login
242: ,NVL(p_routings_step_dep_tbl(i).transfer_pct,100)

Line 338: IF NOT gmd_api_grp.setup_done 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
339: gmd_api_grp.setup_done := gmd_api_grp.setup;
340: END IF;
341: IF NOT gmd_api_grp.setup_done THEN
342: RAISE setup_failure;

Line 339: gmd_api_grp.setup_done := gmd_api_grp.setup;

335: END IF;
336:
337: /* Intialize the setup fields */
338: IF NOT gmd_api_grp.setup_done THEN
339: gmd_api_grp.setup_done := gmd_api_grp.setup;
340: END IF;
341: IF NOT gmd_api_grp.setup_done THEN
342: RAISE setup_failure;
343: END IF;

Line 341: IF NOT gmd_api_grp.setup_done THEN

337: /* Intialize the setup fields */
338: IF NOT gmd_api_grp.setup_done THEN
339: gmd_api_grp.setup_done := gmd_api_grp.setup;
340: END IF;
341: IF NOT gmd_api_grp.setup_done THEN
342: RAISE setup_failure;
343: END IF;
344:
345: OPEN get_old_routingStep_rec(p_routingStep_id);

Line 372: l_old_routingStep_rec.LAST_UPDATED_BY := gmd_api_grp.user_id;

368: l_old_routingStep_rec.STEPRELEASE_TYPE := TO_NUMBER(p_update_table(i).p_value);
369: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'TEXT_CODE') THEN
370: l_old_routingStep_rec.TEXT_CODE := p_update_table(i).p_value;
371: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATED_BY') THEN
372: l_old_routingStep_rec.LAST_UPDATED_BY := gmd_api_grp.user_id;
373: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATE_DATE') THEN
374: l_old_routingstep_rec.LAST_UPDATE_DATE :=
375: FND_DATE.CANONICAL_TO_DATE(p_update_table(i).p_value);
376: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATE_LOGIN') THEN

Line 377: l_old_routingStep_rec.LAST_UPDATE_LOGIN := gmd_api_grp.user_id;

373: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATE_DATE') THEN
374: l_old_routingstep_rec.LAST_UPDATE_DATE :=
375: FND_DATE.CANONICAL_TO_DATE(p_update_table(i).p_value);
376: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATE_LOGIN') THEN
377: l_old_routingStep_rec.LAST_UPDATE_LOGIN := gmd_api_grp.user_id;
378: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'ATTRIBUTE1') THEN
379: l_old_routingStep_rec.ATTRIBUTE1 := p_update_table(i).p_value;
380: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'ATTRIBUTE2') THEN
381: l_old_routingStep_rec.ATTRIBUTE2 := p_update_table(i).p_value;

Line 590: IF NOT gmd_api_grp.setup_done 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
591: gmd_api_grp.setup_done := gmd_api_grp.setup;
592: END IF;
593: IF NOT gmd_api_grp.setup_done THEN
594: RAISE setup_failure;

Line 591: gmd_api_grp.setup_done := gmd_api_grp.setup;

587: END IF;
588:
589: /* Intialize the setup fields */
590: IF NOT gmd_api_grp.setup_done THEN
591: gmd_api_grp.setup_done := gmd_api_grp.setup;
592: END IF;
593: IF NOT gmd_api_grp.setup_done THEN
594: RAISE setup_failure;
595: END IF;

Line 593: IF NOT gmd_api_grp.setup_done THEN

589: /* Intialize the setup fields */
590: IF NOT gmd_api_grp.setup_done THEN
591: gmd_api_grp.setup_done := gmd_api_grp.setup;
592: END IF;
593: IF NOT gmd_api_grp.setup_done THEN
594: RAISE setup_failure;
595: END IF;
596:
597: /* Set the return status to success initially */

Line 632: l_old_stepDep_rec.LAST_UPDATED_BY := gmd_api_grp.user_id;

628: l_old_stepDep_rec.TRANSFER_PCT := p_update_table(i).p_value;
629: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'TEXT_CODE') THEN
630: l_old_stepDep_rec.TEXT_CODE := p_update_table(i).p_value;
631: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATED_BY') THEN
632: l_old_stepDep_rec.LAST_UPDATED_BY := gmd_api_grp.user_id;
633: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATE_DATE') THEN
634: l_old_stepdep_rec.LAST_UPDATE_DATE := FND_DATE.CANONICAL_TO_DATE(p_update_table(i).p_value);
635: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATE_LOGIN') THEN
636: l_old_stepDep_rec.LAST_UPDATE_LOGIN := gmd_api_grp.user_id;

Line 636: l_old_stepDep_rec.LAST_UPDATE_LOGIN := gmd_api_grp.user_id;

632: l_old_stepDep_rec.LAST_UPDATED_BY := gmd_api_grp.user_id;
633: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATE_DATE') THEN
634: l_old_stepdep_rec.LAST_UPDATE_DATE := FND_DATE.CANONICAL_TO_DATE(p_update_table(i).p_value);
635: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'LAST_UPDATE_LOGIN') THEN
636: l_old_stepDep_rec.LAST_UPDATE_LOGIN := gmd_api_grp.user_id;
637: END IF;
638:
639: /* Compare Dates - if the last update date passed in via the API is less than
640: the last update in the db - it indicates someelse has updated this row after this

Line 782: IF NOT gmd_api_grp.setup_done 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
783: gmd_api_grp.setup_done := gmd_api_grp.setup;
784: END IF;
785: IF NOT gmd_api_grp.setup_done THEN
786: RAISE setup_failure;

Line 783: gmd_api_grp.setup_done := gmd_api_grp.setup;

779: END IF;
780:
781: /* Intialize the setup fields */
782: IF NOT gmd_api_grp.setup_done THEN
783: gmd_api_grp.setup_done := gmd_api_grp.setup;
784: END IF;
785: IF NOT gmd_api_grp.setup_done THEN
786: RAISE setup_failure;
787: END IF;

Line 785: IF NOT gmd_api_grp.setup_done THEN

781: /* Intialize the setup fields */
782: IF NOT gmd_api_grp.setup_done THEN
783: gmd_api_grp.setup_done := gmd_api_grp.setup;
784: END IF;
785: IF NOT gmd_api_grp.setup_done THEN
786: RAISE setup_failure;
787: END IF;
788:
789: /* Set the return status to success initially */

Line 960: IF NOT gmd_api_grp.setup_done 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
961: gmd_api_grp.setup_done := gmd_api_grp.setup;
962: END IF;
963: IF NOT gmd_api_grp.setup_done THEN
964: RAISE setup_failure;

Line 961: gmd_api_grp.setup_done := gmd_api_grp.setup;

957: END IF;
958:
959: /* Intialize the setup fields */
960: IF NOT gmd_api_grp.setup_done THEN
961: gmd_api_grp.setup_done := gmd_api_grp.setup;
962: END IF;
963: IF NOT gmd_api_grp.setup_done THEN
964: RAISE setup_failure;
965: END IF;

Line 963: IF NOT gmd_api_grp.setup_done THEN

959: /* Intialize the setup fields */
960: IF NOT gmd_api_grp.setup_done THEN
961: gmd_api_grp.setup_done := gmd_api_grp.setup;
962: END IF;
963: IF NOT gmd_api_grp.setup_done THEN
964: RAISE setup_failure;
965: END IF;
966:
967: IF p_dep_routingstep_no IS NOT NULL THEN