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.EGO_ITEM_BULKLOAD_PKG dependencies on FND_MESSAGE

Line 701: FND_MESSAGE.SET_NAME('EGO','EGO_NUM_OF_ITEMS_PROCD');

697:
698: DBMS_SQL.COLUMN_VALUE(l_item_num_cursor, 1, l_item_num_table);
699: -- Bug : 4099546
700: DBMS_SQL.CLOSE_CURSOR(l_item_num_cursor);
701: FND_MESSAGE.SET_NAME('EGO','EGO_NUM_OF_ITEMS_PROCD');
702: l_msg := FND_MESSAGE.GET;
703:
704: Developer_Debug(l_msg||' '||To_char(l_item_num_rows_cnt));
705:

Line 702: l_msg := FND_MESSAGE.GET;

698: DBMS_SQL.COLUMN_VALUE(l_item_num_cursor, 1, l_item_num_table);
699: -- Bug : 4099546
700: DBMS_SQL.CLOSE_CURSOR(l_item_num_cursor);
701: FND_MESSAGE.SET_NAME('EGO','EGO_NUM_OF_ITEMS_PROCD');
702: l_msg := FND_MESSAGE.GET;
703:
704: Developer_Debug(l_msg||' '||To_char(l_item_num_rows_cnt));
705:
706: FND_MESSAGE.SET_NAME('EGO','EGO_ROW');

Line 706: FND_MESSAGE.SET_NAME('EGO','EGO_ROW');

702: l_msg := FND_MESSAGE.GET;
703:
704: Developer_Debug(l_msg||' '||To_char(l_item_num_rows_cnt));
705:
706: FND_MESSAGE.SET_NAME('EGO','EGO_ROW');
707: l_msg := FND_MESSAGE.GET;
708:
709: IF (l_item_num_rows_cnt > 0) THEN
710: FOR i IN 1..l_item_num_rows_cnt LOOP

Line 707: l_msg := FND_MESSAGE.GET;

703:
704: Developer_Debug(l_msg||' '||To_char(l_item_num_rows_cnt));
705:
706: FND_MESSAGE.SET_NAME('EGO','EGO_ROW');
707: l_msg := FND_MESSAGE.GET;
708:
709: IF (l_item_num_rows_cnt > 0) THEN
710: FOR i IN 1..l_item_num_rows_cnt LOOP
711: Developer_Debug(l_msg||' ['||i||'] = '||l_item_num_table(i));

Line 2789: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMCATALOG_INVALID');

2785: -----------------------------------------------------------------------
2786: -- Preparation for Inserting error messages for all pre-processing --
2787: -- Validation errors. --
2788: -----------------------------------------------------------------------
2789: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMCATALOG_INVALID');
2790:
2791: -----------------------------------------------------------------------
2792: -- Fixing MLS Bug# 3421756 --
2793: -- Replacing 1 quote with 2 quotes to be used in Dynamic SQL --

Line 2797: l_item_catalog_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

2793: -- Replacing 1 quote with 2 quotes to be used in Dynamic SQL --
2794: -- None of the messages have ampersands or other suspicious chars --
2795: -- that could cause harm in the Dynamic SQL run below. --
2796: -----------------------------------------------------------------------
2797: l_item_catalog_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2798:
2799: FND_MESSAGE.SET_NAME('EGO','EGO_PRIMARYUOM_INVALID');
2800: l_uom_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2801:

Line 2799: FND_MESSAGE.SET_NAME('EGO','EGO_PRIMARYUOM_INVALID');

2795: -- that could cause harm in the Dynamic SQL run below. --
2796: -----------------------------------------------------------------------
2797: l_item_catalog_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2798:
2799: FND_MESSAGE.SET_NAME('EGO','EGO_PRIMARYUOM_INVALID');
2800: l_uom_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2801:
2802: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_INVALID');
2803: l_lifecycle_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

Line 2800: l_uom_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

2796: -----------------------------------------------------------------------
2797: l_item_catalog_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2798:
2799: FND_MESSAGE.SET_NAME('EGO','EGO_PRIMARYUOM_INVALID');
2800: l_uom_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2801:
2802: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_INVALID');
2803: l_lifecycle_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2804:

Line 2802: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_INVALID');

2798:
2799: FND_MESSAGE.SET_NAME('EGO','EGO_PRIMARYUOM_INVALID');
2800: l_uom_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2801:
2802: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_INVALID');
2803: l_lifecycle_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2804:
2805: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_PHASE_INVALID');
2806: l_lifecycle_ph_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

Line 2803: l_lifecycle_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

2799: FND_MESSAGE.SET_NAME('EGO','EGO_PRIMARYUOM_INVALID');
2800: l_uom_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2801:
2802: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_INVALID');
2803: l_lifecycle_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2804:
2805: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_PHASE_INVALID');
2806: l_lifecycle_ph_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2807:

Line 2805: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_PHASE_INVALID');

2801:
2802: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_INVALID');
2803: l_lifecycle_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2804:
2805: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_PHASE_INVALID');
2806: l_lifecycle_ph_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2807:
2808: FND_MESSAGE.SET_NAME('EGO','EGO_USERITEMTYPE_INVALID');
2809: l_useritemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

Line 2806: l_lifecycle_ph_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

2802: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_INVALID');
2803: l_lifecycle_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2804:
2805: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_PHASE_INVALID');
2806: l_lifecycle_ph_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2807:
2808: FND_MESSAGE.SET_NAME('EGO','EGO_USERITEMTYPE_INVALID');
2809: l_useritemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2810:

Line 2808: FND_MESSAGE.SET_NAME('EGO','EGO_USERITEMTYPE_INVALID');

2804:
2805: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_PHASE_INVALID');
2806: l_lifecycle_ph_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2807:
2808: FND_MESSAGE.SET_NAME('EGO','EGO_USERITEMTYPE_INVALID');
2809: l_useritemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2810:
2811: FND_MESSAGE.SET_NAME('EGO','EGO_BOMITEMTYPE_INVALID');
2812: l_bomitemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

Line 2809: l_useritemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

2805: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_PHASE_INVALID');
2806: l_lifecycle_ph_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2807:
2808: FND_MESSAGE.SET_NAME('EGO','EGO_USERITEMTYPE_INVALID');
2809: l_useritemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2810:
2811: FND_MESSAGE.SET_NAME('EGO','EGO_BOMITEMTYPE_INVALID');
2812: l_bomitemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2813:

Line 2811: FND_MESSAGE.SET_NAME('EGO','EGO_BOMITEMTYPE_INVALID');

2807:
2808: FND_MESSAGE.SET_NAME('EGO','EGO_USERITEMTYPE_INVALID');
2809: l_useritemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2810:
2811: FND_MESSAGE.SET_NAME('EGO','EGO_BOMITEMTYPE_INVALID');
2812: l_bomitemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2813:
2814: FND_MESSAGE.SET_NAME('EGO','EGO_ENGITEMFLAG_INVALID');
2815: l_engitemflag_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

Line 2812: l_bomitemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

2808: FND_MESSAGE.SET_NAME('EGO','EGO_USERITEMTYPE_INVALID');
2809: l_useritemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2810:
2811: FND_MESSAGE.SET_NAME('EGO','EGO_BOMITEMTYPE_INVALID');
2812: l_bomitemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2813:
2814: FND_MESSAGE.SET_NAME('EGO','EGO_ENGITEMFLAG_INVALID');
2815: l_engitemflag_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2816:

Line 2814: FND_MESSAGE.SET_NAME('EGO','EGO_ENGITEMFLAG_INVALID');

2810:
2811: FND_MESSAGE.SET_NAME('EGO','EGO_BOMITEMTYPE_INVALID');
2812: l_bomitemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2813:
2814: FND_MESSAGE.SET_NAME('EGO','EGO_ENGITEMFLAG_INVALID');
2815: l_engitemflag_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2816:
2817: -- Bug: 3778006
2818: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMDESC_IS_FG');

Line 2815: l_engitemflag_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

2811: FND_MESSAGE.SET_NAME('EGO','EGO_BOMITEMTYPE_INVALID');
2812: l_bomitemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2813:
2814: FND_MESSAGE.SET_NAME('EGO','EGO_ENGITEMFLAG_INVALID');
2815: l_engitemflag_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2816:
2817: -- Bug: 3778006
2818: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMDESC_IS_FG');
2819: l_description_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

Line 2818: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMDESC_IS_FG');

2814: FND_MESSAGE.SET_NAME('EGO','EGO_ENGITEMFLAG_INVALID');
2815: l_engitemflag_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2816:
2817: -- Bug: 3778006
2818: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMDESC_IS_FG');
2819: l_description_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2820:
2821: --Bug: 3969593 Adding new 11.5.10 Primary Attrs: Begin
2822: FND_MESSAGE.SET_NAME('EGO','EGO_CONVERSIONS_INVALID');

Line 2819: l_description_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

2815: l_engitemflag_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2816:
2817: -- Bug: 3778006
2818: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMDESC_IS_FG');
2819: l_description_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2820:
2821: --Bug: 3969593 Adding new 11.5.10 Primary Attrs: Begin
2822: FND_MESSAGE.SET_NAME('EGO','EGO_CONVERSIONS_INVALID');
2823: l_conversions_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

Line 2822: FND_MESSAGE.SET_NAME('EGO','EGO_CONVERSIONS_INVALID');

2818: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMDESC_IS_FG');
2819: l_description_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2820:
2821: --Bug: 3969593 Adding new 11.5.10 Primary Attrs: Begin
2822: FND_MESSAGE.SET_NAME('EGO','EGO_CONVERSIONS_INVALID');
2823: l_conversions_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2824:
2825: FND_MESSAGE.SET_NAME('EGO','EGO_DEFAULTING_INVALID');
2826: l_secondary_def_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

Line 2823: l_conversions_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

2819: l_description_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2820:
2821: --Bug: 3969593 Adding new 11.5.10 Primary Attrs: Begin
2822: FND_MESSAGE.SET_NAME('EGO','EGO_CONVERSIONS_INVALID');
2823: l_conversions_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2824:
2825: FND_MESSAGE.SET_NAME('EGO','EGO_DEFAULTING_INVALID');
2826: l_secondary_def_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2827:

Line 2825: FND_MESSAGE.SET_NAME('EGO','EGO_DEFAULTING_INVALID');

2821: --Bug: 3969593 Adding new 11.5.10 Primary Attrs: Begin
2822: FND_MESSAGE.SET_NAME('EGO','EGO_CONVERSIONS_INVALID');
2823: l_conversions_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2824:
2825: FND_MESSAGE.SET_NAME('EGO','EGO_DEFAULTING_INVALID');
2826: l_secondary_def_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2827:
2828: FND_MESSAGE.SET_NAME('EGO','EGO_PRICING_INVALID');
2829: l_ont_pricing_qty_src_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

Line 2826: l_secondary_def_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

2822: FND_MESSAGE.SET_NAME('EGO','EGO_CONVERSIONS_INVALID');
2823: l_conversions_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2824:
2825: FND_MESSAGE.SET_NAME('EGO','EGO_DEFAULTING_INVALID');
2826: l_secondary_def_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2827:
2828: FND_MESSAGE.SET_NAME('EGO','EGO_PRICING_INVALID');
2829: l_ont_pricing_qty_src_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2830:

Line 2828: FND_MESSAGE.SET_NAME('EGO','EGO_PRICING_INVALID');

2824:
2825: FND_MESSAGE.SET_NAME('EGO','EGO_DEFAULTING_INVALID');
2826: l_secondary_def_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2827:
2828: FND_MESSAGE.SET_NAME('EGO','EGO_PRICING_INVALID');
2829: l_ont_pricing_qty_src_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2830:
2831: FND_MESSAGE.SET_NAME('EGO','EGO_SECONDARYUOM_INVALID');
2832: l_secondary_uom_code_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

Line 2829: l_ont_pricing_qty_src_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

2825: FND_MESSAGE.SET_NAME('EGO','EGO_DEFAULTING_INVALID');
2826: l_secondary_def_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2827:
2828: FND_MESSAGE.SET_NAME('EGO','EGO_PRICING_INVALID');
2829: l_ont_pricing_qty_src_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2830:
2831: FND_MESSAGE.SET_NAME('EGO','EGO_SECONDARYUOM_INVALID');
2832: l_secondary_uom_code_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2833:

Line 2831: FND_MESSAGE.SET_NAME('EGO','EGO_SECONDARYUOM_INVALID');

2827:
2828: FND_MESSAGE.SET_NAME('EGO','EGO_PRICING_INVALID');
2829: l_ont_pricing_qty_src_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2830:
2831: FND_MESSAGE.SET_NAME('EGO','EGO_SECONDARYUOM_INVALID');
2832: l_secondary_uom_code_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2833:
2834: FND_MESSAGE.SET_NAME('EGO','EGO_TRACKING_INVALID');
2835: l_tracking_qty_ind_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

Line 2832: l_secondary_uom_code_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

2828: FND_MESSAGE.SET_NAME('EGO','EGO_PRICING_INVALID');
2829: l_ont_pricing_qty_src_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2830:
2831: FND_MESSAGE.SET_NAME('EGO','EGO_SECONDARYUOM_INVALID');
2832: l_secondary_uom_code_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2833:
2834: FND_MESSAGE.SET_NAME('EGO','EGO_TRACKING_INVALID');
2835: l_tracking_qty_ind_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2836: --Bug: 3969593 End

Line 2834: FND_MESSAGE.SET_NAME('EGO','EGO_TRACKING_INVALID');

2830:
2831: FND_MESSAGE.SET_NAME('EGO','EGO_SECONDARYUOM_INVALID');
2832: l_secondary_uom_code_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2833:
2834: FND_MESSAGE.SET_NAME('EGO','EGO_TRACKING_INVALID');
2835: l_tracking_qty_ind_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2836: --Bug: 3969593 End
2837:
2838: FND_MESSAGE.SET_NAME('EGO','EGO_STATUS_INVALID');--MLS STatus

Line 2835: l_tracking_qty_ind_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

2831: FND_MESSAGE.SET_NAME('EGO','EGO_SECONDARYUOM_INVALID');
2832: l_secondary_uom_code_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2833:
2834: FND_MESSAGE.SET_NAME('EGO','EGO_TRACKING_INVALID');
2835: l_tracking_qty_ind_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2836: --Bug: 3969593 End
2837:
2838: FND_MESSAGE.SET_NAME('EGO','EGO_STATUS_INVALID');--MLS STatus
2839: l_inv_item_status_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

Line 2838: FND_MESSAGE.SET_NAME('EGO','EGO_STATUS_INVALID');--MLS STatus

2834: FND_MESSAGE.SET_NAME('EGO','EGO_TRACKING_INVALID');
2835: l_tracking_qty_ind_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2836: --Bug: 3969593 End
2837:
2838: FND_MESSAGE.SET_NAME('EGO','EGO_STATUS_INVALID');--MLS STatus
2839: l_inv_item_status_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2840: -- R12C changes for Pack Hierarchy
2841: FND_MESSAGE.SET_NAME('EGO','EGO_TRADEITEMDESC_INVALID');
2842: l_tradeitemdesc_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

Line 2839: l_inv_item_status_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

2835: l_tracking_qty_ind_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2836: --Bug: 3969593 End
2837:
2838: FND_MESSAGE.SET_NAME('EGO','EGO_STATUS_INVALID');--MLS STatus
2839: l_inv_item_status_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2840: -- R12C changes for Pack Hierarchy
2841: FND_MESSAGE.SET_NAME('EGO','EGO_TRADEITEMDESC_INVALID');
2842: l_tradeitemdesc_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2843:

Line 2841: FND_MESSAGE.SET_NAME('EGO','EGO_TRADEITEMDESC_INVALID');

2837:
2838: FND_MESSAGE.SET_NAME('EGO','EGO_STATUS_INVALID');--MLS STatus
2839: l_inv_item_status_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2840: -- R12C changes for Pack Hierarchy
2841: FND_MESSAGE.SET_NAME('EGO','EGO_TRADEITEMDESC_INVALID');
2842: l_tradeitemdesc_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2843:
2844: -----------------------------------------------------------------------
2845: --Insert the Pre-processed error messages.

Line 2842: l_tradeitemdesc_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

2838: FND_MESSAGE.SET_NAME('EGO','EGO_STATUS_INVALID');--MLS STatus
2839: l_inv_item_status_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2840: -- R12C changes for Pack Hierarchy
2841: FND_MESSAGE.SET_NAME('EGO','EGO_TRADEITEMDESC_INVALID');
2842: l_tradeitemdesc_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2843:
2844: -----------------------------------------------------------------------
2845: --Insert the Pre-processed error messages.
2846: -----------------------------------------------------------------------

Line 5727: FND_MESSAGE.set_name('EGO', 'EGO_IPI_INVALID_VALUE');

5723: -- flash errors where int val is not correct
5724: IF l_attr_disp_val_table(i) IS NOT NULL AND l_attr_int_val_table(i) IS NULL THEN
5725: l_dyn_sql := l_dyn_sql || ' process_flag = '||G_VS_INVALID_ERR_STS;
5726: l_dyn_sql := l_dyn_sql || ' , request_id = '||G_REQUEST_ID;
5727: FND_MESSAGE.set_name('EGO', 'EGO_IPI_INVALID_VALUE');
5728: FND_MESSAGE.set_token('NAME', l_attr_disp_name_table(i));
5729: FND_MESSAGE.set_token('VALUE',NVL(l_attr_disp_val_table(i),l_attr_int_val_table(i)));
5730: l_ebi_err_msg := fnd_message.get();
5731: l_dyn_sql_ebi := ' UPDATE ego_bulkload_intf ' ||

Line 5728: FND_MESSAGE.set_token('NAME', l_attr_disp_name_table(i));

5724: IF l_attr_disp_val_table(i) IS NOT NULL AND l_attr_int_val_table(i) IS NULL THEN
5725: l_dyn_sql := l_dyn_sql || ' process_flag = '||G_VS_INVALID_ERR_STS;
5726: l_dyn_sql := l_dyn_sql || ' , request_id = '||G_REQUEST_ID;
5727: FND_MESSAGE.set_name('EGO', 'EGO_IPI_INVALID_VALUE');
5728: FND_MESSAGE.set_token('NAME', l_attr_disp_name_table(i));
5729: FND_MESSAGE.set_token('VALUE',NVL(l_attr_disp_val_table(i),l_attr_int_val_table(i)));
5730: l_ebi_err_msg := fnd_message.get();
5731: l_dyn_sql_ebi := ' UPDATE ego_bulkload_intf ' ||
5732: ' SET '|| G_VAL_SET_CONV_ERR_COL ||' = '''||l_ebi_err_msg||''''||

Line 5729: FND_MESSAGE.set_token('VALUE',NVL(l_attr_disp_val_table(i),l_attr_int_val_table(i)));

5725: l_dyn_sql := l_dyn_sql || ' process_flag = '||G_VS_INVALID_ERR_STS;
5726: l_dyn_sql := l_dyn_sql || ' , request_id = '||G_REQUEST_ID;
5727: FND_MESSAGE.set_name('EGO', 'EGO_IPI_INVALID_VALUE');
5728: FND_MESSAGE.set_token('NAME', l_attr_disp_name_table(i));
5729: FND_MESSAGE.set_token('VALUE',NVL(l_attr_disp_val_table(i),l_attr_int_val_table(i)));
5730: l_ebi_err_msg := fnd_message.get();
5731: l_dyn_sql_ebi := ' UPDATE ego_bulkload_intf ' ||
5732: ' SET '|| G_VAL_SET_CONV_ERR_COL ||' = '''||l_ebi_err_msg||''''||
5733: ' WHERE TRANSACTION_ID = ' || l_transaction_id;

Line 5730: l_ebi_err_msg := fnd_message.get();

5726: l_dyn_sql := l_dyn_sql || ' , request_id = '||G_REQUEST_ID;
5727: FND_MESSAGE.set_name('EGO', 'EGO_IPI_INVALID_VALUE');
5728: FND_MESSAGE.set_token('NAME', l_attr_disp_name_table(i));
5729: FND_MESSAGE.set_token('VALUE',NVL(l_attr_disp_val_table(i),l_attr_int_val_table(i)));
5730: l_ebi_err_msg := fnd_message.get();
5731: l_dyn_sql_ebi := ' UPDATE ego_bulkload_intf ' ||
5732: ' SET '|| G_VAL_SET_CONV_ERR_COL ||' = '''||l_ebi_err_msg||''''||
5733: ' WHERE TRANSACTION_ID = ' || l_transaction_id;
5734: EXECUTE IMMEDIATE l_dyn_sql_ebi;

Line 6105: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');

6101:
6102: -----------------------------------------------------------------------
6103: -- Providing the Errors Link in the Concurrent Log file.
6104: -----------------------------------------------------------------------
6105: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
6106: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
6107:
6108: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
6109: l_temp_txt := FND_MESSAGE.GET;

Line 6106: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

6102: -----------------------------------------------------------------------
6103: -- Providing the Errors Link in the Concurrent Log file.
6104: -----------------------------------------------------------------------
6105: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
6106: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
6107:
6108: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
6109: l_temp_txt := FND_MESSAGE.GET;
6110:

Line 6108: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');

6104: -----------------------------------------------------------------------
6105: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
6106: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
6107:
6108: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
6109: l_temp_txt := FND_MESSAGE.GET;
6110:
6111: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
6112: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_txt);

Line 6109: l_temp_txt := FND_MESSAGE.GET;

6105: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
6106: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
6107:
6108: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
6109: l_temp_txt := FND_MESSAGE.GET;
6110:
6111: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
6112: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_txt);
6113: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', G_REQUEST_ID);

Line 6111: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');

6107:
6108: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
6109: l_temp_txt := FND_MESSAGE.GET;
6110:
6111: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
6112: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_txt);
6113: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', G_REQUEST_ID);
6114: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
6115:

Line 6112: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_txt);

6108: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
6109: l_temp_txt := FND_MESSAGE.GET;
6110:
6111: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
6112: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_txt);
6113: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', G_REQUEST_ID);
6114: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
6115:
6116: Developer_Debug('G_USER_ID : '||To_char(G_USER_ID));

Line 6113: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', G_REQUEST_ID);

6109: l_temp_txt := FND_MESSAGE.GET;
6110:
6111: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
6112: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_txt);
6113: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', G_REQUEST_ID);
6114: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
6115:
6116: Developer_Debug('G_USER_ID : '||To_char(G_USER_ID));
6117: Developer_Debug('G_PROG_ID : '||To_char(G_PROG_ID));

Line 6114: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);

6110:
6111: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
6112: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_txt);
6113: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', G_REQUEST_ID);
6114: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
6115:
6116: Developer_Debug('G_USER_ID : '||To_char(G_USER_ID));
6117: Developer_Debug('G_PROG_ID : '||To_char(G_PROG_ID));
6118: Developer_Debug('G_REQUEST_ID : '||To_char(G_REQUEST_ID));

Line 7225: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

7221:
7222: EXCEPTION
7223: WHEN OTHERS THEN
7224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7225: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7226: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_BULKLOAD_PKG');
7227: FND_MESSAGE.Set_Token('API_NAME', 'Populate_Seq_Gen_Item_Nums');
7228: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7229: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 7226: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_BULKLOAD_PKG');

7222: EXCEPTION
7223: WHEN OTHERS THEN
7224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7225: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7226: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_BULKLOAD_PKG');
7227: FND_MESSAGE.Set_Token('API_NAME', 'Populate_Seq_Gen_Item_Nums');
7228: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7229: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7230: ,p_count => x_msg_count

Line 7227: FND_MESSAGE.Set_Token('API_NAME', 'Populate_Seq_Gen_Item_Nums');

7223: WHEN OTHERS THEN
7224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7225: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7226: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_BULKLOAD_PKG');
7227: FND_MESSAGE.Set_Token('API_NAME', 'Populate_Seq_Gen_Item_Nums');
7228: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7229: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7230: ,p_count => x_msg_count
7231: ,p_data => x_msg_data);

Line 7228: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

7224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7225: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7226: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_BULKLOAD_PKG');
7227: FND_MESSAGE.Set_Token('API_NAME', 'Populate_Seq_Gen_Item_Nums');
7228: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7229: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7230: ,p_count => x_msg_count
7231: ,p_data => x_msg_data);
7232: END Populate_Seq_Gen_Item_Nums;