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.MSC_SCE_PUBLISH_PKG dependencies on FND_FILE

Line 789: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item: ' || l_item_list);

785: l_item_list := ltrim(rtrim(substr(l_list_of_item,1,length (l_list_of_item)),' '),' ') ;
786: l_list_of_item := null;
787: END IF;
788:
789: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item: ' || l_item_list);
790:
791: IF (l_item_list is not null) THEN
792: begin
793: select inventory_item_id

Line 799: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item not found: ' || l_item_list);

795: from msc_items
796: where item_name = l_item_list;
797: exception
798: when no_data_found then
799: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Item not found: ' || l_item_list);
800: l_item_id := null;
801: when others then
802: l_item_id := null;
803: end;

Line 1109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Records fetched by cursor := ' || t_org_id.COUNT);

1105:
1106:
1107: IF t_org_id IS NOT NULL AND t_org_id.COUNT > 0 THEN
1108: log_message ('Records fetched by cursor := ' || t_org_id.COUNT);
1109: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Records fetched by cursor := ' || t_org_id.COUNT);
1110: log_message('At 5');
1111:
1112: get_optional_info(
1113: t_item_id

Line 1276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Defective Planned Order fetched by cursor := ' || t_org_id.COUNT);

1272:
1273:
1274: IF t_org_id IS NOT NULL AND t_org_id.COUNT > 0 THEN
1275: log_message ('Defective Planned Order fetched by cursor := ' || t_org_id.COUNT);
1276: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Defective Planned Order fetched by cursor := ' || t_org_id.COUNT);
1277: log_message('At 8');
1278:
1279: t_pub := companyNameList();
1280: t_pub_id := numberList();

Line 1448: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in publish plan order proc: ' ||sqlerrm);

1444: END IF;
1445:
1446: EXCEPTION
1447: when others then
1448: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in publish plan order proc: ' ||sqlerrm);
1449: END publish_plan_orders;
1450:
1451:
1452: PROCEDURE get_optional_info(

Line 1589: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Error in 2nd query: ' || sqlerrm);

1585: EXCEPTION
1586: WHEN OTHERS THEN
1587: t_supp_id(j) := null;
1588: t_supp(j) := null;
1589: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Error in 2nd query: ' || sqlerrm);
1590: END;
1591: else
1592: t_supp_id(j) := t_supp_id(j-1);
1593: t_supp(j) := t_supp(j-1);

Line 1612: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Error in 3rd query: ' || sqlerrm);

1608: EXCEPTION
1609: WHEN OTHERS THEN
1610: t_supp_site_id(j) := null;
1611: t_supp_site(j) := null;
1612: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Error in 3rd query: ' || sqlerrm);
1613: END;
1614: else
1615: t_supp_site_id(j) := t_supp_site_id(j-1);
1616: t_supp_site(j) := t_supp_site(j-1);

Line 1689: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Error in 4th query: ' || sqlerrm);

1685: when OTHERS then
1686: t_supp_item_name(j) := null;
1687: t_supp_item_desc(j) := null;
1688: t_tp_uom(j) := t_uom_code(j);
1689: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Error in 4th query: ' || sqlerrm);
1690: end;
1691: end;
1692:
1693: IF (t_supp_item_desc(j) is null and t_supp_item_name(j) is not null ) THEN

Line 1765: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Error in get option info proc: ' || sqlerrm);

1761: end if;
1762:
1763: EXCEPTION
1764: WHEN others then
1765: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Error in get option info proc: ' || sqlerrm);
1766: END get_optional_info;
1767:
1768:
1769: PROCEDURE insert_into_sup_dem (

Line 1833: FND_FILE.PUT_LINE(FND_FILE.LOG,'Records fetched := ' || t_pub_id.COUNT);

1829:
1830: log_message('In insert_into_sup_dem');
1831: if t_pub_id is not null and t_pub_id.COUNT > 0 then
1832: log_message('Records fetched := ' || t_pub_id.COUNT);
1833: FND_FILE.PUT_LINE(FND_FILE.LOG,'Records fetched := ' || t_pub_id.COUNT);
1834: if t_pub_id is not null and t_pub_id.COUNT > 0 THEN
1835: l_log_message := get_message('MSC','MSC_X_PUB_NUM_RECORDS',p_language_code) || ': ' || t_pub_id.COUNT || '.' || fnd_global.local_chr(10);
1836: log_message(l_log_message);
1837: log_message('Records to be inserted : ' || t_pub_id.COUNT);

Line 3034: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'PLO' || t_planned_order_qty(j) || ' tp '

3030: IF (t_order_type(j) = PLANNED_ORDER) THEN
3031: -------------------------------------------------------
3032: -- PLANNED_ORDER
3033: ------------------------------------------------------
3034: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'PLO' || t_planned_order_qty(j) || ' tp '
3035: -- || t_tp_planned_order_qty(j) || 'date ' || t_key_date(j));
3036: log_message('PLO' || t_planned_order_qty(j) || ' tp ' || t_tp_planned_order_qty(j) || 'date ' || t_key_date(j));
3037: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PLANNED_ORDER);
3038: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));

Line 3183: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'released qty ' || t_released_qty(j) || ' tp '

3179: IF (t_released_qty(j) < 0 ) THEN
3180: l_released_qty := 0;
3181: l_tp_released_qty := 0;
3182: END IF;
3183: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'released qty ' || t_released_qty(j) || ' tp '
3184: -- || t_tp_released_qty(j) || 'date ' || t_key_date(j));
3185: log_message( 'released qty ' || t_released_qty(j) || ' tp ' || t_tp_released_qty(j) || 'date ' || t_key_date(j));
3186: insert into msc_sup_dem_entries (
3187: transaction_id,

Line 3318: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j)

3314: ------------------------------------------------------
3315: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PURCHASE_ORDER_FROM_PLAN);
3316: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
3317:
3318: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j)
3319: --|| 'date ' || t_key_date(j));
3320: log_message( 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j) || 'date ' || t_key_date(j));
3321: insert into msc_sup_dem_entries (
3322: transaction_id,

Line 3732: FND_FILE.PUT_LINE(FND_FILE.LOG, 'qty ' || t_qty(j) || ' tp ' || t_tp_qty(j)|| 'date ' || t_key_date(j) || ' Item ' || t_item_id(j) || ' base ' || t_base_item_id(j));

3728: else
3729: ---------------------------------------------------*/
3730: ELSE
3731:
3732: FND_FILE.PUT_LINE(FND_FILE.LOG, 'qty ' || t_qty(j) || ' tp ' || t_tp_qty(j)|| 'date ' || t_key_date(j) || ' Item ' || t_item_id(j) || ' base ' || t_base_item_id(j));
3733: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',ORDER_FORECAST);
3734: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
3735:
3736: IF (t_base_item_id(j) is null) THEN

Line 3895: FND_FILE.PUT_LINE(FND_FILE.LOG, 'insert failed on else statement with base item ' || sqlerrm);

3891: p_version,
3892: p_designator);
3893: exception
3894: when others then
3895: FND_FILE.PUT_LINE(FND_FILE.LOG, 'insert failed on else statement with base item ' || sqlerrm);
3896: end;
3897: END IF;
3898: -- Check in if-else ladder for type of order and insert accordingly
3899: -- Ladder 1 -> Planned Order - insert CP Planned Order, Released Planned Order

Line 3907: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'PLO' || t_planned_order_qty(j) || ' tp '

3903:
3904: -------------------------------------------------------
3905: -- PLANNED_ORDER
3906: ------------------------------------------------------
3907: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'PLO' || t_planned_order_qty(j) || ' tp '
3908: -- || t_tp_planned_order_qty(j) || 'date ' || t_key_date(j));
3909: log_message('PLO' || t_planned_order_qty(j) || ' tp ' || t_tp_planned_order_qty(j) || 'date ' || t_key_date(j));
3910: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PLANNED_ORDER);
3911: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));

Line 4056: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'released qty ' || t_released_qty(j) || ' tp '

4052: IF (t_released_qty(j) < 0 ) THEN
4053: l_released_qty := 0;
4054: l_tp_released_qty := 0;
4055: END IF;
4056: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'released qty ' || t_released_qty(j) || ' tp '
4057: -- || t_tp_released_qty(j) || 'date ' || t_key_date(j));
4058: log_message( 'released qty ' || t_released_qty(j) || ' tp ' || t_tp_released_qty(j) || 'date ' || t_key_date(j));
4059: insert into msc_sup_dem_entries (
4060: transaction_id,

Line 4190: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j)

4186: -- PURCHASE_ORDER_FROM_PLAN
4187: ------------------------------------------------------
4188: l_order_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',CP_PURCHASE_ORDER_FROM_PLAN);
4189: l_bucket_type_desc := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_BUCKET_TYPE',t_bucket_type(j));
4190: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j)
4191: --|| 'date ' || t_key_date(j));
4192: log_message( 'Po ' || t_qty(j) || ' tp ' || t_tp_qty(j) || 'date ' || t_key_date(j));
4193: insert into msc_sup_dem_entries (
4194: transaction_id,

Line 4660: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in insert_sup_dem_entries: ' || sqlerrm);

4656: end if;
4657: end if;
4658: EXCEPTION
4659: when others then
4660: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in insert_sup_dem_entries: ' || sqlerrm);
4661: log_message('Error ' || sqlerrm);
4662: --dbms_output.put_line('error ' || sqlerrm);
4663: END insert_into_sup_dem;
4664:

Line 4734: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Type : ' ||t_order_type(j) || '/qty : ' || t_qty(j)

4730:
4731: IF t_pub_id is not null and t_pub_id.COUNT > 0 THEN
4732: FOR j in 1..t_pub_id.COUNT LOOP
4733:
4734: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Type : ' ||t_order_type(j) || '/qty : ' || t_qty(j)
4735: || '/date : ' || t_key_date(j) || '/Item : ' || t_item_id(j)
4736: || '/base :' || t_base_item_id(j));
4737:
4738: IF (t_order_type(j) IN (PLANNED_TRANSFER_DEF, ISO_DEF, INTRANSIT_SHIPMENT_DEF, INTRANSIT_RECEIPT_DEF) ) THEN -- RETURNS FORECAST

Line 5162: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleted number records: ' || l_row);

5158: and NVL(sd.base_item_id, sd.inventory_item_id) =nvl(i.base_item_id,i.inventory_item_id) and
5159: rownum=1 ) ;
5160:
5161: l_row := SQL%ROWCOUNT;
5162: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleted number records: ' || l_row);
5163:
5164: ELSIF ( p_overwrite = 2) THEN --delete by overwritten
5165: delete from msc_sup_dem_entries sd
5166: where sd.publisher_order_type IN (ORDER_FORECAST, CP_PLANNED_ORDER,

Line 5210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleted number records: ' || l_row);

5206: key_date between nvl(p_horizon_start, sysdate - 36500) and
5207: nvl(p_horizon_end, sysdate + 36500);
5208:
5209: l_row := SQL%ROWCOUNT;
5210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Deleted number records: ' || l_row);
5211: END IF;
5212: commit;
5213:
5214: END delete_old_forecast;

Line 5221: FND_FILE.PUT_LINE(FND_FILE.LOG, p_string);

5217: p_string IN VARCHAR2
5218: ) IS
5219: BEGIN
5220: IF ( g_msc_cp_debug= '1' OR g_msc_cp_debug = '2') THEN
5221: FND_FILE.PUT_LINE(FND_FILE.LOG, p_string);
5222: END IF;
5223:
5224: EXCEPTION
5225: WHEN OTHERS THEn