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 738: FND_MESSAGE.SET_NAME('EGO','EGO_NUM_OF_ITEMS_PROCD');

734:
735: DBMS_SQL.COLUMN_VALUE(l_item_num_cursor, 1, l_item_num_table);
736: -- Bug : 4099546
737: DBMS_SQL.CLOSE_CURSOR(l_item_num_cursor);
738: FND_MESSAGE.SET_NAME('EGO','EGO_NUM_OF_ITEMS_PROCD');
739: l_msg := FND_MESSAGE.GET;
740:
741: Developer_Debug(l_msg||' '||To_char(l_item_num_rows_cnt));
742:

Line 739: l_msg := FND_MESSAGE.GET;

735: DBMS_SQL.COLUMN_VALUE(l_item_num_cursor, 1, l_item_num_table);
736: -- Bug : 4099546
737: DBMS_SQL.CLOSE_CURSOR(l_item_num_cursor);
738: FND_MESSAGE.SET_NAME('EGO','EGO_NUM_OF_ITEMS_PROCD');
739: l_msg := FND_MESSAGE.GET;
740:
741: Developer_Debug(l_msg||' '||To_char(l_item_num_rows_cnt));
742:
743: FND_MESSAGE.SET_NAME('EGO','EGO_ROW');

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

739: l_msg := FND_MESSAGE.GET;
740:
741: Developer_Debug(l_msg||' '||To_char(l_item_num_rows_cnt));
742:
743: FND_MESSAGE.SET_NAME('EGO','EGO_ROW');
744: l_msg := FND_MESSAGE.GET;
745:
746: IF (l_item_num_rows_cnt > 0) THEN
747: FOR i IN 1..l_item_num_rows_cnt LOOP

Line 744: l_msg := FND_MESSAGE.GET;

740:
741: Developer_Debug(l_msg||' '||To_char(l_item_num_rows_cnt));
742:
743: FND_MESSAGE.SET_NAME('EGO','EGO_ROW');
744: l_msg := FND_MESSAGE.GET;
745:
746: IF (l_item_num_rows_cnt > 0) THEN
747: FOR i IN 1..l_item_num_rows_cnt LOOP
748: Developer_Debug(l_msg||' ['||i||'] = '||l_item_num_table(i));

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

2870: -----------------------------------------------------------------------
2871: -- Preparation for Inserting error messages for all pre-processing --
2872: -- Validation errors. --
2873: -----------------------------------------------------------------------
2874: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMCATALOG_INVALID');
2875:
2876: -----------------------------------------------------------------------
2877: -- Fixing MLS Bug# 3421756 --
2878: -- Replacing 1 quote with 2 quotes to be used in Dynamic SQL --

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

2878: -- Replacing 1 quote with 2 quotes to be used in Dynamic SQL --
2879: -- None of the messages have ampersands or other suspicious chars --
2880: -- that could cause harm in the Dynamic SQL run below. --
2881: -----------------------------------------------------------------------
2882: l_item_catalog_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2883:
2884: FND_MESSAGE.SET_NAME('EGO','EGO_PRIMARYUOM_INVALID');
2885: l_uom_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2886:

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

2880: -- that could cause harm in the Dynamic SQL run below. --
2881: -----------------------------------------------------------------------
2882: l_item_catalog_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2883:
2884: FND_MESSAGE.SET_NAME('EGO','EGO_PRIMARYUOM_INVALID');
2885: l_uom_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2886:
2887: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_INVALID');
2888: l_lifecycle_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

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

2881: -----------------------------------------------------------------------
2882: l_item_catalog_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2883:
2884: FND_MESSAGE.SET_NAME('EGO','EGO_PRIMARYUOM_INVALID');
2885: l_uom_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2886:
2887: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_INVALID');
2888: l_lifecycle_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2889:

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

2883:
2884: FND_MESSAGE.SET_NAME('EGO','EGO_PRIMARYUOM_INVALID');
2885: l_uom_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2886:
2887: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_INVALID');
2888: l_lifecycle_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2889:
2890: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_PHASE_INVALID');
2891: l_lifecycle_ph_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

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

2884: FND_MESSAGE.SET_NAME('EGO','EGO_PRIMARYUOM_INVALID');
2885: l_uom_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2886:
2887: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_INVALID');
2888: l_lifecycle_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2889:
2890: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_PHASE_INVALID');
2891: l_lifecycle_ph_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2892:

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

2886:
2887: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_INVALID');
2888: l_lifecycle_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2889:
2890: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_PHASE_INVALID');
2891: l_lifecycle_ph_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2892:
2893: FND_MESSAGE.SET_NAME('EGO','EGO_USERITEMTYPE_INVALID');
2894: l_useritemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

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

2887: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_INVALID');
2888: l_lifecycle_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2889:
2890: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_PHASE_INVALID');
2891: l_lifecycle_ph_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2892:
2893: FND_MESSAGE.SET_NAME('EGO','EGO_USERITEMTYPE_INVALID');
2894: l_useritemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2895:

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

2889:
2890: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_PHASE_INVALID');
2891: l_lifecycle_ph_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2892:
2893: FND_MESSAGE.SET_NAME('EGO','EGO_USERITEMTYPE_INVALID');
2894: l_useritemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2895:
2896: FND_MESSAGE.SET_NAME('EGO','EGO_BOMITEMTYPE_INVALID');
2897: l_bomitemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

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

2890: FND_MESSAGE.SET_NAME('EGO','EGO_LIFECYCLE_PHASE_INVALID');
2891: l_lifecycle_ph_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2892:
2893: FND_MESSAGE.SET_NAME('EGO','EGO_USERITEMTYPE_INVALID');
2894: l_useritemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2895:
2896: FND_MESSAGE.SET_NAME('EGO','EGO_BOMITEMTYPE_INVALID');
2897: l_bomitemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2898:

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

2892:
2893: FND_MESSAGE.SET_NAME('EGO','EGO_USERITEMTYPE_INVALID');
2894: l_useritemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2895:
2896: FND_MESSAGE.SET_NAME('EGO','EGO_BOMITEMTYPE_INVALID');
2897: l_bomitemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2898:
2899: FND_MESSAGE.SET_NAME('EGO','EGO_ENGITEMFLAG_INVALID');
2900: l_engitemflag_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

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

2893: FND_MESSAGE.SET_NAME('EGO','EGO_USERITEMTYPE_INVALID');
2894: l_useritemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2895:
2896: FND_MESSAGE.SET_NAME('EGO','EGO_BOMITEMTYPE_INVALID');
2897: l_bomitemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2898:
2899: FND_MESSAGE.SET_NAME('EGO','EGO_ENGITEMFLAG_INVALID');
2900: l_engitemflag_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2901:

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

2895:
2896: FND_MESSAGE.SET_NAME('EGO','EGO_BOMITEMTYPE_INVALID');
2897: l_bomitemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2898:
2899: FND_MESSAGE.SET_NAME('EGO','EGO_ENGITEMFLAG_INVALID');
2900: l_engitemflag_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2901:
2902: -- Bug: 3778006
2903: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMDESC_IS_FG');

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

2896: FND_MESSAGE.SET_NAME('EGO','EGO_BOMITEMTYPE_INVALID');
2897: l_bomitemtype_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2898:
2899: FND_MESSAGE.SET_NAME('EGO','EGO_ENGITEMFLAG_INVALID');
2900: l_engitemflag_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2901:
2902: -- Bug: 3778006
2903: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMDESC_IS_FG');
2904: l_description_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

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

2899: FND_MESSAGE.SET_NAME('EGO','EGO_ENGITEMFLAG_INVALID');
2900: l_engitemflag_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2901:
2902: -- Bug: 3778006
2903: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMDESC_IS_FG');
2904: l_description_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2905:
2906: --Bug: 3969593 Adding new 11.5.10 Primary Attrs: Begin
2907: FND_MESSAGE.SET_NAME('EGO','EGO_CONVERSIONS_INVALID');

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

2900: l_engitemflag_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2901:
2902: -- Bug: 3778006
2903: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMDESC_IS_FG');
2904: l_description_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2905:
2906: --Bug: 3969593 Adding new 11.5.10 Primary Attrs: Begin
2907: FND_MESSAGE.SET_NAME('EGO','EGO_CONVERSIONS_INVALID');
2908: l_conversions_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

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

2903: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMDESC_IS_FG');
2904: l_description_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2905:
2906: --Bug: 3969593 Adding new 11.5.10 Primary Attrs: Begin
2907: FND_MESSAGE.SET_NAME('EGO','EGO_CONVERSIONS_INVALID');
2908: l_conversions_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2909:
2910: FND_MESSAGE.SET_NAME('EGO','EGO_DEFAULTING_INVALID');
2911: l_secondary_def_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

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

2904: l_description_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2905:
2906: --Bug: 3969593 Adding new 11.5.10 Primary Attrs: Begin
2907: FND_MESSAGE.SET_NAME('EGO','EGO_CONVERSIONS_INVALID');
2908: l_conversions_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2909:
2910: FND_MESSAGE.SET_NAME('EGO','EGO_DEFAULTING_INVALID');
2911: l_secondary_def_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2912:

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

2906: --Bug: 3969593 Adding new 11.5.10 Primary Attrs: Begin
2907: FND_MESSAGE.SET_NAME('EGO','EGO_CONVERSIONS_INVALID');
2908: l_conversions_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2909:
2910: FND_MESSAGE.SET_NAME('EGO','EGO_DEFAULTING_INVALID');
2911: l_secondary_def_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2912:
2913: FND_MESSAGE.SET_NAME('EGO','EGO_PRICING_INVALID');
2914: l_ont_pricing_qty_src_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

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

2907: FND_MESSAGE.SET_NAME('EGO','EGO_CONVERSIONS_INVALID');
2908: l_conversions_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2909:
2910: FND_MESSAGE.SET_NAME('EGO','EGO_DEFAULTING_INVALID');
2911: l_secondary_def_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2912:
2913: FND_MESSAGE.SET_NAME('EGO','EGO_PRICING_INVALID');
2914: l_ont_pricing_qty_src_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2915:

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

2909:
2910: FND_MESSAGE.SET_NAME('EGO','EGO_DEFAULTING_INVALID');
2911: l_secondary_def_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2912:
2913: FND_MESSAGE.SET_NAME('EGO','EGO_PRICING_INVALID');
2914: l_ont_pricing_qty_src_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2915:
2916: FND_MESSAGE.SET_NAME('EGO','EGO_SECONDARYUOM_INVALID');
2917: l_secondary_uom_code_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

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

2910: FND_MESSAGE.SET_NAME('EGO','EGO_DEFAULTING_INVALID');
2911: l_secondary_def_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2912:
2913: FND_MESSAGE.SET_NAME('EGO','EGO_PRICING_INVALID');
2914: l_ont_pricing_qty_src_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2915:
2916: FND_MESSAGE.SET_NAME('EGO','EGO_SECONDARYUOM_INVALID');
2917: l_secondary_uom_code_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2918:

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

2912:
2913: FND_MESSAGE.SET_NAME('EGO','EGO_PRICING_INVALID');
2914: l_ont_pricing_qty_src_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2915:
2916: FND_MESSAGE.SET_NAME('EGO','EGO_SECONDARYUOM_INVALID');
2917: l_secondary_uom_code_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2918:
2919: FND_MESSAGE.SET_NAME('EGO','EGO_TRACKING_INVALID');
2920: l_tracking_qty_ind_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

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

2913: FND_MESSAGE.SET_NAME('EGO','EGO_PRICING_INVALID');
2914: l_ont_pricing_qty_src_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2915:
2916: FND_MESSAGE.SET_NAME('EGO','EGO_SECONDARYUOM_INVALID');
2917: l_secondary_uom_code_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2918:
2919: FND_MESSAGE.SET_NAME('EGO','EGO_TRACKING_INVALID');
2920: l_tracking_qty_ind_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2921: --Bug: 3969593 End

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

2915:
2916: FND_MESSAGE.SET_NAME('EGO','EGO_SECONDARYUOM_INVALID');
2917: l_secondary_uom_code_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2918:
2919: FND_MESSAGE.SET_NAME('EGO','EGO_TRACKING_INVALID');
2920: l_tracking_qty_ind_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2921: --Bug: 3969593 End
2922:
2923: FND_MESSAGE.SET_NAME('EGO','EGO_STATUS_INVALID');--MLS STatus

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

2916: FND_MESSAGE.SET_NAME('EGO','EGO_SECONDARYUOM_INVALID');
2917: l_secondary_uom_code_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2918:
2919: FND_MESSAGE.SET_NAME('EGO','EGO_TRACKING_INVALID');
2920: l_tracking_qty_ind_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2921: --Bug: 3969593 End
2922:
2923: FND_MESSAGE.SET_NAME('EGO','EGO_STATUS_INVALID');--MLS STatus
2924: l_inv_item_status_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

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

2919: FND_MESSAGE.SET_NAME('EGO','EGO_TRACKING_INVALID');
2920: l_tracking_qty_ind_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2921: --Bug: 3969593 End
2922:
2923: FND_MESSAGE.SET_NAME('EGO','EGO_STATUS_INVALID');--MLS STatus
2924: l_inv_item_status_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2925: -- R12C changes for Pack Hierarchy
2926: FND_MESSAGE.SET_NAME('EGO','EGO_TRADEITEMDESC_INVALID');
2927: l_tradeitemdesc_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');

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

2920: l_tracking_qty_ind_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2921: --Bug: 3969593 End
2922:
2923: FND_MESSAGE.SET_NAME('EGO','EGO_STATUS_INVALID');--MLS STatus
2924: l_inv_item_status_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2925: -- R12C changes for Pack Hierarchy
2926: FND_MESSAGE.SET_NAME('EGO','EGO_TRADEITEMDESC_INVALID');
2927: l_tradeitemdesc_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2928:

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

2922:
2923: FND_MESSAGE.SET_NAME('EGO','EGO_STATUS_INVALID');--MLS STatus
2924: l_inv_item_status_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2925: -- R12C changes for Pack Hierarchy
2926: FND_MESSAGE.SET_NAME('EGO','EGO_TRADEITEMDESC_INVALID');
2927: l_tradeitemdesc_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2928:
2929: -----------------------------------------------------------------------
2930: --Insert the Pre-processed error messages.

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

2923: FND_MESSAGE.SET_NAME('EGO','EGO_STATUS_INVALID');--MLS STatus
2924: l_inv_item_status_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2925: -- R12C changes for Pack Hierarchy
2926: FND_MESSAGE.SET_NAME('EGO','EGO_TRADEITEMDESC_INVALID');
2927: l_tradeitemdesc_err_msg := REPLACE(FND_MESSAGE.GET,'''','''''');
2928:
2929: -----------------------------------------------------------------------
2930: --Insert the Pre-processed error messages.
2931: -----------------------------------------------------------------------

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

5863: IF l_attr_disp_val_table(i) IS NOT NULL AND l_attr_int_val_table(i) IS NULL THEN
5864: l_error_indicator := TRUE;
5865: l_dyn_sql := l_dyn_sql || ' process_flag = '||G_VS_INVALID_ERR_STS;
5866: l_dyn_sql := l_dyn_sql || ' , request_id = '||G_REQUEST_ID;
5867: FND_MESSAGE.set_name('EGO', 'EGO_IPI_INVALID_VALUE');
5868: FND_MESSAGE.set_token('NAME', l_attr_disp_name_table(i));
5869: FND_MESSAGE.set_token('VALUE',NVL(l_attr_disp_val_table(i),l_attr_int_val_table(i)));
5870: l_ebi_err_msg := fnd_message.get();
5871: l_dyn_sql_ebi := ' UPDATE ego_bulkload_intf ' ||

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

5864: l_error_indicator := TRUE;
5865: l_dyn_sql := l_dyn_sql || ' process_flag = '||G_VS_INVALID_ERR_STS;
5866: l_dyn_sql := l_dyn_sql || ' , request_id = '||G_REQUEST_ID;
5867: FND_MESSAGE.set_name('EGO', 'EGO_IPI_INVALID_VALUE');
5868: FND_MESSAGE.set_token('NAME', l_attr_disp_name_table(i));
5869: FND_MESSAGE.set_token('VALUE',NVL(l_attr_disp_val_table(i),l_attr_int_val_table(i)));
5870: l_ebi_err_msg := fnd_message.get();
5871: l_dyn_sql_ebi := ' UPDATE ego_bulkload_intf ' ||
5872: ' SET '|| G_VAL_SET_CONV_ERR_COL ||' = '''||l_ebi_err_msg||''''||

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

5865: l_dyn_sql := l_dyn_sql || ' process_flag = '||G_VS_INVALID_ERR_STS;
5866: l_dyn_sql := l_dyn_sql || ' , request_id = '||G_REQUEST_ID;
5867: FND_MESSAGE.set_name('EGO', 'EGO_IPI_INVALID_VALUE');
5868: FND_MESSAGE.set_token('NAME', l_attr_disp_name_table(i));
5869: FND_MESSAGE.set_token('VALUE',NVL(l_attr_disp_val_table(i),l_attr_int_val_table(i)));
5870: l_ebi_err_msg := fnd_message.get();
5871: l_dyn_sql_ebi := ' UPDATE ego_bulkload_intf ' ||
5872: ' SET '|| G_VAL_SET_CONV_ERR_COL ||' = '''||l_ebi_err_msg||''''||
5873: ' WHERE TRANSACTION_ID = ' || l_transaction_id;

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

5866: l_dyn_sql := l_dyn_sql || ' , request_id = '||G_REQUEST_ID;
5867: FND_MESSAGE.set_name('EGO', 'EGO_IPI_INVALID_VALUE');
5868: FND_MESSAGE.set_token('NAME', l_attr_disp_name_table(i));
5869: FND_MESSAGE.set_token('VALUE',NVL(l_attr_disp_val_table(i),l_attr_int_val_table(i)));
5870: l_ebi_err_msg := fnd_message.get();
5871: l_dyn_sql_ebi := ' UPDATE ego_bulkload_intf ' ||
5872: ' SET '|| G_VAL_SET_CONV_ERR_COL ||' = '''||l_ebi_err_msg||''''||
5873: ' WHERE TRANSACTION_ID = ' || l_transaction_id;
5874: EXECUTE IMMEDIATE l_dyn_sql_ebi;

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

6254:
6255: -----------------------------------------------------------------------
6256: -- Providing the Errors Link in the Concurrent Log file.
6257: -----------------------------------------------------------------------
6258: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
6259: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
6260:
6261: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
6262: l_temp_txt := rtrim(FND_PROFILE.VALUE('APPS_FRAMEWORK_AGENT'), '/');--FND_MESSAGE.GET;

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

6255: -----------------------------------------------------------------------
6256: -- Providing the Errors Link in the Concurrent Log file.
6257: -----------------------------------------------------------------------
6258: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
6259: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
6260:
6261: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
6262: l_temp_txt := rtrim(FND_PROFILE.VALUE('APPS_FRAMEWORK_AGENT'), '/');--FND_MESSAGE.GET;
6263:

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

6257: -----------------------------------------------------------------------
6258: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
6259: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
6260:
6261: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
6262: l_temp_txt := rtrim(FND_PROFILE.VALUE('APPS_FRAMEWORK_AGENT'), '/');--FND_MESSAGE.GET;
6263:
6264: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
6265: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_txt);

Line 6262: l_temp_txt := rtrim(FND_PROFILE.VALUE('APPS_FRAMEWORK_AGENT'), '/');--FND_MESSAGE.GET;

6258: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINKTXT1');
6259: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
6260:
6261: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
6262: l_temp_txt := rtrim(FND_PROFILE.VALUE('APPS_FRAMEWORK_AGENT'), '/');--FND_MESSAGE.GET;
6263:
6264: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
6265: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_txt);
6266: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', G_REQUEST_ID);

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

6260:
6261: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
6262: l_temp_txt := rtrim(FND_PROFILE.VALUE('APPS_FRAMEWORK_AGENT'), '/');--FND_MESSAGE.GET;
6263:
6264: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
6265: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_txt);
6266: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', G_REQUEST_ID);
6267: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
6268:

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

6261: FND_MESSAGE.SET_NAME('EGO','EGO_ITEMBULK_HOSTANDPORT');
6262: l_temp_txt := rtrim(FND_PROFILE.VALUE('APPS_FRAMEWORK_AGENT'), '/');--FND_MESSAGE.GET;
6263:
6264: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
6265: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_txt);
6266: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', G_REQUEST_ID);
6267: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
6268:
6269: Developer_Debug('G_USER_ID : '||To_char(G_USER_ID));

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

6262: l_temp_txt := rtrim(FND_PROFILE.VALUE('APPS_FRAMEWORK_AGENT'), '/');--FND_MESSAGE.GET;
6263:
6264: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
6265: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_txt);
6266: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', G_REQUEST_ID);
6267: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
6268:
6269: Developer_Debug('G_USER_ID : '||To_char(G_USER_ID));
6270: Developer_Debug('G_PROG_ID : '||To_char(G_PROG_ID));

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

6263:
6264: FND_MESSAGE.SET_NAME('EGO','EGO_ITEM_BULK_ERRS_LINK');
6265: FND_MESSAGE.SET_TOKEN('HOST_AND_PORT', l_temp_txt);
6266: FND_MESSAGE.SET_TOKEN('CONC_REQ_ID', G_REQUEST_ID);
6267: FND_FILE.put_line(FND_FILE.LOG, FND_MESSAGE.GET);
6268:
6269: Developer_Debug('G_USER_ID : '||To_char(G_USER_ID));
6270: Developer_Debug('G_PROG_ID : '||To_char(G_PROG_ID));
6271: Developer_Debug('G_REQUEST_ID : '||To_char(G_REQUEST_ID));

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

7374:
7375: EXCEPTION
7376: WHEN OTHERS THEN
7377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7378: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7379: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_BULKLOAD_PKG');
7380: FND_MESSAGE.Set_Token('API_NAME', 'Populate_Seq_Gen_Item_Nums');
7381: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7382: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

7375: EXCEPTION
7376: WHEN OTHERS THEN
7377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7378: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7379: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_BULKLOAD_PKG');
7380: FND_MESSAGE.Set_Token('API_NAME', 'Populate_Seq_Gen_Item_Nums');
7381: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7382: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7383: ,p_count => x_msg_count

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

7376: WHEN OTHERS THEN
7377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7378: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7379: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_BULKLOAD_PKG');
7380: FND_MESSAGE.Set_Token('API_NAME', 'Populate_Seq_Gen_Item_Nums');
7381: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7382: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7383: ,p_count => x_msg_count
7384: ,p_data => x_msg_data);

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

7377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7378: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7379: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_ITEM_BULKLOAD_PKG');
7380: FND_MESSAGE.Set_Token('API_NAME', 'Populate_Seq_Gen_Item_Nums');
7381: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7382: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7383: ,p_count => x_msg_count
7384: ,p_data => x_msg_data);
7385: END Populate_Seq_Gen_Item_Nums;