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.JTF_ASSIGN_PUB dependencies on DBMS_OUTPUT

Line 371: --dbms_output.put_line('Entered LOOP 1');

367: j := l_right;
368: LOOP
369: LOOP
370: i := i +1;
371: --dbms_output.put_line('Entered LOOP 1');
372: --dbms_output.put_line('i is : '||to_char(i));
373: IF (p_list(i).location < l_current_node.location) THEN
374: null;
375: ELSE

Line 372: --dbms_output.put_line('i is : '||to_char(i));

368: LOOP
369: LOOP
370: i := i +1;
371: --dbms_output.put_line('Entered LOOP 1');
372: --dbms_output.put_line('i is : '||to_char(i));
373: IF (p_list(i).location < l_current_node.location) THEN
374: null;
375: ELSE
376: exit;

Line 386: --dbms_output.put_line('Entered LOOP 2');

382: END LOOP;
383:
384: LOOP
385: j := j -1;
386: --dbms_output.put_line('Entered LOOP 2');
387: --dbms_output.put_line('j is : '||to_char(j));
388: IF (p_list(j).location > l_current_node.location) THEN
389: null;
390: ELSE

Line 387: --dbms_output.put_line('j is : '||to_char(j));

383:
384: LOOP
385: j := j -1;
386: --dbms_output.put_line('Entered LOOP 2');
387: --dbms_output.put_line('j is : '||to_char(j));
388: IF (p_list(j).location > l_current_node.location) THEN
389: null;
390: ELSE
391: exit;

Line 459: dbms_output.put_line('Entered LOOP 1');

455: j := l_right;
456: LOOP
457: LOOP
458: i := i +1;
459: dbms_output.put_line('Entered LOOP 1');
460: dbms_output.put_line('i is : '||to_char(i));
461: dbms_output.put_line('i current node : '||l_current_node.terr_rank);
462: IF (p_list(i).terr_rank > l_current_node.terr_rank) THEN
463: null;

Line 460: dbms_output.put_line('i is : '||to_char(i));

456: LOOP
457: LOOP
458: i := i +1;
459: dbms_output.put_line('Entered LOOP 1');
460: dbms_output.put_line('i is : '||to_char(i));
461: dbms_output.put_line('i current node : '||l_current_node.terr_rank);
462: IF (p_list(i).terr_rank > l_current_node.terr_rank) THEN
463: null;
464: ELSE

Line 461: dbms_output.put_line('i current node : '||l_current_node.terr_rank);

457: LOOP
458: i := i +1;
459: dbms_output.put_line('Entered LOOP 1');
460: dbms_output.put_line('i is : '||to_char(i));
461: dbms_output.put_line('i current node : '||l_current_node.terr_rank);
462: IF (p_list(i).terr_rank > l_current_node.terr_rank) THEN
463: null;
464: ELSE
465: exit;

Line 475: dbms_output.put_line('Entered LOOP 2');

471: END LOOP;
472:
473: LOOP
474: j := j -1;
475: dbms_output.put_line('Entered LOOP 2');
476: dbms_output.put_line('j is : '||to_char(j));
477: dbms_output.put_line('j current node : '||l_current_node.terr_rank);
478: IF (j <= 0) THEN
479: dbms_output.put_line('when j <=0');

Line 476: dbms_output.put_line('j is : '||to_char(j));

472:
473: LOOP
474: j := j -1;
475: dbms_output.put_line('Entered LOOP 2');
476: dbms_output.put_line('j is : '||to_char(j));
477: dbms_output.put_line('j current node : '||l_current_node.terr_rank);
478: IF (j <= 0) THEN
479: dbms_output.put_line('when j <=0');
480: exit;

Line 477: dbms_output.put_line('j current node : '||l_current_node.terr_rank);

473: LOOP
474: j := j -1;
475: dbms_output.put_line('Entered LOOP 2');
476: dbms_output.put_line('j is : '||to_char(j));
477: dbms_output.put_line('j current node : '||l_current_node.terr_rank);
478: IF (j <= 0) THEN
479: dbms_output.put_line('when j <=0');
480: exit;
481: END IF;

Line 479: dbms_output.put_line('when j <=0');

475: dbms_output.put_line('Entered LOOP 2');
476: dbms_output.put_line('j is : '||to_char(j));
477: dbms_output.put_line('j current node : '||l_current_node.terr_rank);
478: IF (j <= 0) THEN
479: dbms_output.put_line('when j <=0');
480: exit;
481: END IF;
482: IF (p_list(j).terr_rank < l_current_node.terr_rank) THEN
483: dbms_output.put_line('Inside if');

Line 483: dbms_output.put_line('Inside if');

479: dbms_output.put_line('when j <=0');
480: exit;
481: END IF;
482: IF (p_list(j).terr_rank < l_current_node.terr_rank) THEN
483: dbms_output.put_line('Inside if');
484: null;
485: ELSE
486: dbms_output.put_line('Inside else before exit');
487: exit;

Line 486: dbms_output.put_line('Inside else before exit');

482: IF (p_list(j).terr_rank < l_current_node.terr_rank) THEN
483: dbms_output.put_line('Inside if');
484: null;
485: ELSE
486: dbms_output.put_line('Inside else before exit');
487: exit;
488: END IF;
489:
490:

Line 495: dbms_output.put_line('when i >=j');

491:
492: END LOOP;
493:
494: IF (i >= j) THEN
495: dbms_output.put_line('when i >=j');
496: exit;
497: END IF;
498: dbms_output.put_line('inside j loop before ');
499: dbms_output.put_line('inside j loop before '||p_list(i).terr_rank);

Line 498: dbms_output.put_line('inside j loop before ');

494: IF (i >= j) THEN
495: dbms_output.put_line('when i >=j');
496: exit;
497: END IF;
498: dbms_output.put_line('inside j loop before ');
499: dbms_output.put_line('inside j loop before '||p_list(i).terr_rank);
500: dbms_output.put_line('inside j loop before '||p_list(j).terr_rank);
501: l_dummy_node := p_list(i);
502: p_list(i) := p_list(j);

Line 499: dbms_output.put_line('inside j loop before '||p_list(i).terr_rank);

495: dbms_output.put_line('when i >=j');
496: exit;
497: END IF;
498: dbms_output.put_line('inside j loop before ');
499: dbms_output.put_line('inside j loop before '||p_list(i).terr_rank);
500: dbms_output.put_line('inside j loop before '||p_list(j).terr_rank);
501: l_dummy_node := p_list(i);
502: p_list(i) := p_list(j);
503: p_list(j) := l_dummy_node;

Line 500: dbms_output.put_line('inside j loop before '||p_list(j).terr_rank);

496: exit;
497: END IF;
498: dbms_output.put_line('inside j loop before ');
499: dbms_output.put_line('inside j loop before '||p_list(i).terr_rank);
500: dbms_output.put_line('inside j loop before '||p_list(j).terr_rank);
501: l_dummy_node := p_list(i);
502: p_list(i) := p_list(j);
503: p_list(j) := l_dummy_node;
504: dbms_output.put_line('inside j loop after '||p_list(i).terr_rank);

Line 504: dbms_output.put_line('inside j loop after '||p_list(i).terr_rank);

500: dbms_output.put_line('inside j loop before '||p_list(j).terr_rank);
501: l_dummy_node := p_list(i);
502: p_list(i) := p_list(j);
503: p_list(j) := l_dummy_node;
504: dbms_output.put_line('inside j loop after '||p_list(i).terr_rank);
505: dbms_output.put_line('inside j loop after '||p_list(j).terr_rank);
506: END LOOP;
507:
508: l_dummy_node := p_list(i);

Line 505: dbms_output.put_line('inside j loop after '||p_list(j).terr_rank);

501: l_dummy_node := p_list(i);
502: p_list(i) := p_list(j);
503: p_list(j) := l_dummy_node;
504: dbms_output.put_line('inside j loop after '||p_list(i).terr_rank);
505: dbms_output.put_line('inside j loop after '||p_list(j).terr_rank);
506: END LOOP;
507:
508: l_dummy_node := p_list(i);
509: p_list(i) := p_list(l_right);

Line 511: dbms_output.put_line(' after i '||p_list(i).terr_rank);

507:
508: l_dummy_node := p_list(i);
509: p_list(i) := p_list(l_right);
510: p_list(l_right) := l_dummy_node;
511: dbms_output.put_line(' after i '||p_list(i).terr_rank);
512: dbms_output.put_line(' after l_right '||p_list(l_right).terr_rank);
513: dbms_output.put_line('Values passed are left '||l_left);
514: dbms_output.put_line('Values passed are right '||to_char(i-1));
515:

Line 512: dbms_output.put_line(' after l_right '||p_list(l_right).terr_rank);

508: l_dummy_node := p_list(i);
509: p_list(i) := p_list(l_right);
510: p_list(l_right) := l_dummy_node;
511: dbms_output.put_line(' after i '||p_list(i).terr_rank);
512: dbms_output.put_line(' after l_right '||p_list(l_right).terr_rank);
513: dbms_output.put_line('Values passed are left '||l_left);
514: dbms_output.put_line('Values passed are right '||to_char(i-1));
515:
516: quick_sort_terr_rank(l_left, i-1, p_list);

Line 513: dbms_output.put_line('Values passed are left '||l_left);

509: p_list(i) := p_list(l_right);
510: p_list(l_right) := l_dummy_node;
511: dbms_output.put_line(' after i '||p_list(i).terr_rank);
512: dbms_output.put_line(' after l_right '||p_list(l_right).terr_rank);
513: dbms_output.put_line('Values passed are left '||l_left);
514: dbms_output.put_line('Values passed are right '||to_char(i-1));
515:
516: quick_sort_terr_rank(l_left, i-1, p_list);
517: quick_sort_terr_rank(i+1, l_right, p_list);

Line 514: dbms_output.put_line('Values passed are right '||to_char(i-1));

510: p_list(l_right) := l_dummy_node;
511: dbms_output.put_line(' after i '||p_list(i).terr_rank);
512: dbms_output.put_line(' after l_right '||p_list(l_right).terr_rank);
513: dbms_output.put_line('Values passed are left '||l_left);
514: dbms_output.put_line('Values passed are right '||to_char(i-1));
515:
516: quick_sort_terr_rank(l_left, i-1, p_list);
517: quick_sort_terr_rank(i+1, l_right, p_list);
518:

Line 1471: --dbms_output.put_line('Slots are ...'||to_char(l_slots(i).slot_value)||'...'||to_char(l_x_planned_start_date, 'DD-MON-YYYY HH24:MI'));

1467: X_SLOT_END_DATE => l_x_planned_end_date,
1468: X_SHIFT_CONSTRUCT_ID => l_x_shift_construct_id,
1469: X_AVAILABILITY_TYPE => l_x_availability_type
1470: );
1471: --dbms_output.put_line('Slots are ...'||to_char(l_slots(i).slot_value)||'...'||to_char(l_x_planned_start_date, 'DD-MON-YYYY HH24:MI'));
1472: --dbms_output.put_line('Slots are ...'||to_char(x_assign_resources_tbl(l_current_rec).resource_id)||'...'||to_char(l_x_planned_end_date, 'DD-MON-YYYY HH24:MI'));
1473: -- set back the API name to original name
1474: l_api_name := l_api_name_1;
1475:

Line 1472: --dbms_output.put_line('Slots are ...'||to_char(x_assign_resources_tbl(l_current_rec).resource_id)||'...'||to_char(l_x_planned_end_date, 'DD-MON-YYYY HH24:MI'));

1468: X_SHIFT_CONSTRUCT_ID => l_x_shift_construct_id,
1469: X_AVAILABILITY_TYPE => l_x_availability_type
1470: );
1471: --dbms_output.put_line('Slots are ...'||to_char(l_slots(i).slot_value)||'...'||to_char(l_x_planned_start_date, 'DD-MON-YYYY HH24:MI'));
1472: --dbms_output.put_line('Slots are ...'||to_char(x_assign_resources_tbl(l_current_rec).resource_id)||'...'||to_char(l_x_planned_end_date, 'DD-MON-YYYY HH24:MI'));
1473: -- set back the API name to original name
1474: l_api_name := l_api_name_1;
1475:
1476: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 2815: -- dbms_output.put_line('Select1 is : '||l_dynamic_sql1);

2811: l_dynamic_sql1 := ' SELECT contract_service_id, customer_product_id, expected_resolution_date'||
2812: ' FROM cs_incidents_all_vl'||
2813: ' WHERE incident_id = :1';
2814:
2815: -- dbms_output.put_line('Select1 is : '||l_dynamic_sql1);
2816:
2817: OPEN cur_cs_incidents FOR l_dynamic_sql1 USING l_task_source_id;
2818: FETCH cur_cs_incidents INTO l_contract_id,
2819: l_cp_id,

Line 4369: -- dbms_output.put_line('Count of TM :: '||l_assign_resources_tbl.count);

4365:
4366: -- set back the API name to original name
4367: l_api_name := l_api_name_1;
4368:
4369: -- dbms_output.put_line('Count of TM :: '||l_assign_resources_tbl.count);
4370:
4371: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
4372: -- Unexpected Execution Error from call to Territory Manager
4373: fnd_message.set_name('JTF', 'JTF_AM_ERROR_TERR_API');

Line 9817: -- dbms_output.put_line('Select is : '||l_dynamic_sql);

9813: l_dynamic_sql := ' SELECT territory_id'||
9814: ' FROM css_def_defects_all'||
9815: ' WHERE defect_id = :1';
9816:
9817: -- dbms_output.put_line('Select is : '||l_dynamic_sql);
9818:
9819: OPEN cur_source_defect FOR l_dynamic_sql USING l_object_id;
9820: FETCH cur_source_defect INTO l_territory_id;
9821: